Put together commission structure spreadsheet
- or -
Post a project like this$100
- Posted:
- Proposals: 12
- Remote
- #2012049
- Expired
Microsoft Certified Power BI Data Analyst & Advance Excel Specialist¦Professional Power BI consultant ¦ (ACCA)- Chartered Certified Accountant ¦ Accounting- Reconciliations ¦DAX ¦Data Models ¦
Doha
Spreadsheets|Excel macros and VBA|Google sheets |Google app scripts|Presentations - Tableau, PowerPoint, Prezi|Google data studio
Bay Minette
12815620827069457675079714064161438067144947314806231642492211919421214652181736
Description
Experience Level: Expert
I need some research on the most popular, easy-to-track/measure, and easy to implement methods of calculating sales commissions in the flooring industry for project managers.
I'm looking for a tiered structure. Something along the lines of:
* $0 below sales that just cover overhead
* 1% of sales that break even with overhead but don't cover liabilities, owner draws and asset purchases
* 3% of sales that cover the liabilities, owner draws and asset purchases (net zero)
* 5% of sales that surpass the true break-even point
* 7% of sales that surpass a certain dollar value, for the company
This is an idea, to start.
Not sure how to figure the amount of commissions paid out, into this overhead amount and how to make sure there is still money left towards overhead, once commissions are paid out.
I need help with the commission structure (what will motivate the worker and what will not break the bank for the employer).
I will provide the details of overhead amounts and other amounts that are needed, to the freelance who is granted this task.
Please explain your experience and send some previous excel work to review.
I'm looking for a tiered structure. Something along the lines of:
* $0 below sales that just cover overhead
* 1% of sales that break even with overhead but don't cover liabilities, owner draws and asset purchases
* 3% of sales that cover the liabilities, owner draws and asset purchases (net zero)
* 5% of sales that surpass the true break-even point
* 7% of sales that surpass a certain dollar value, for the company
This is an idea, to start.
Not sure how to figure the amount of commissions paid out, into this overhead amount and how to make sure there is still money left towards overhead, once commissions are paid out.
I need help with the commission structure (what will motivate the worker and what will not break the bank for the employer).
I will provide the details of overhead amounts and other amounts that are needed, to the freelance who is granted this task.
Please explain your experience and send some previous excel work to review.
Anna I.
0% (0)Projects Completed
-
Freelancers worked with
-
Projects awarded
0%
Last project
4 May 2024
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies