Excel Application to calculate multi faceted complex monthly sale commission calculations

En curso Publicado hace 4 años Pagado a la entrega
En curso Pagado a la entrega

I am looking to use an excel application to automate the calculation of monthly salesperson commissions.

We have 2 groups

Capital Sales – Runs January to December

Parts Sales – Runs April to March

Within each category the rates, abatements and calculations all vary slightly.

It will need to include a monthly and running summary of commission tally’s

From a set of raw data I need the application to calculate the commission for each person and create a calculation sheet that can be emailed direct to each sales staff member.

The raw data is as follows (and is stored in an exel table we use for sales recording)

Territory 1 Sales

Territory 2 Sales

Territory 3 Sales

Territory 4 Sales

Territory 5 Sales

Product 1

Product 2

Product 3

Individual sales by product

Customer 1 - 20

Then for each sub set of data, it needs to calculate

YTD sales

Need to apply an abatement before commission starts

Different commission rates for each staff members

Calculate GP% on YTD sales

Used the GP% to determine certain calculations

Calculate commission on specific product and customer spend at varying %’s and abatement amounts

Combine different territories and products

Individual sale

It is most likely easiest for me to attached examples of my current manual output sheets. I will also attach a sheet that forecasts the sales staff commission

There is a complication in the fact that on sales from 0 – 12.5M commission is paid to sales staff based on set territory but once 12.5M is reached it is based on all territories. Then the payment structure changes.

There are thresholds that need to be met before certain commission is due

The abatement only applies once, so once the threshold is met the abatement ceases to apply

I wonder if the application needs to cater for ALL the commission elements and they can be selected or de selected for individual employees??

See the excel sheet for extra details

Excel Visual Basic

Nº del proyecto: #20037012

Sobre el proyecto

16 propuestas Proyecto remoto Activo hace 4 años

Adjudicado a:

P0L

Hello, I’m an Excel expert and I would like to help you with your commission calculations. Please check my profile and contact me to discuss further details. Regards.

$500 NZD en 10 días
(317 comentarios)
7.3

16 freelancers están ofertando un promedio de $622 por este trabajo

sandroshubladze

Hello I am Excel Expert and VBA developer Can definitely help you with reporting task and create desirable automations If you will be interested contact me thanks & regards

$705 NZD en 5 días
(203 comentarios)
8.1
Webxpert4u

I am ready to create excel using vba to calculate monthly sales and commissions. can we discuss in details before starting? thx

$882 NZD en 7 días
(227 comentarios)
7.9
paris2785

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel application to automate your monthly commissions. I plan to use a combin Más

$600 NZD en 5 días
(225 comentarios)
7.4
prameswara

Hello Sir Im excel VBA macro and formula Expert :) i can help you to make application macro VBA excel for calculate multi faceted complex monthly sale commission like you need please ping me now and we can discuss m Más

$250 NZD en 10 días
(363 comentarios)
7.2
dgled

Hi, I can create for you a Sales Commission Module in Excel to calculate commissions to salespersons based personal parameters, by sales or collections (including by partitional payments). I will add a procedure to co Más

$500 NZD en 10 días
(83 comentarios)
7.1
diorisaguilar

Hi! Automate Excel processes is my business, improve the user experience to manage complicated formulas and calculations. I can help you on this project to automate this commission calculation. I just reviewed the fil Más

$680 NZD en 6 días
(46 comentarios)
6.2
shikhamehta

Hey, I am an Excel expert and have delivered more than 500 projects successfully here on Freelancer itself. I would also like to inform you that I have created commission calculators for Pharma companies like Daiichi- Más

$710 NZD en 10 días
(98 comentarios)
6.4
periyannas

Ok Sure let me help. ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

$823 NZD en 12 días
(107 comentarios)
6.3
urielbaray

Hi! Thank you for taking the time to read my proposal, My name is Uriel Baray I am a VBA Excel Expert with several years of experience on the field, if you are so kind to take a look to my portfolio, I have some sam Más

$300 NZD en 10 días
(39 comentarios)
5.4
KavTan

Hi there, I have read your brief and understand that you require to have running commission rate for set of complex data sets. I am a professional freelancer having advance skills in MS Excel and have experience in cr Más

$750 NZD en 7 días
(50 comentarios)
5.8
afenache

Hi, I can build the excel commission calculator tool that you described. I am a chemical engineer and I have over five years experience in using Excel at an advanced level (complex formulas, array formulas, pivot tab Más

$700 NZD en 7 días
(20 comentarios)
5.2
Diliphero

Greetings, I am a professionally qualified Business & Financial Consultant from Sri Lanka with a degree in Management & Finance. I have the experience in Excel dashboards, VBA and Macros. I have a very good business Más

$800 NZD en 10 días
(14 comentarios)
4.8
NoelReubenMuturi

Greetings, I am Noel, a BA in ECONOMICS, MA in ECONOMICS, ACCA, and an MS Excel guru. You need an excel application to automate the calculation of monthly salesperson commissions. I am qualified to take up the projec Más

$750 NZD en 10 días
(9 comentarios)
4.1