Excel Application to calculate multi faceted complex monthly sale commission calculations
$250-750 NZD
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
Nº del proyecto: #20037012
Sobre el proyecto
Adjudicado a:
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.
16 freelancers están ofertando un promedio de $622 por este trabajo
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
I am ready to create excel using vba to calculate monthly sales and commissions. can we discuss in details before starting? thx
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
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
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
Ok Sure let me help. ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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
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