Commission calculator in Excel
- or -
Post a project like this1983
£75(approx. $97)
- Posted:
- Proposals: 40
- Remote
- #2394997
- Awarded
Description
Experience Level: Expert
Need a simple spreadsheet that calculates value of commission earned on value of sales and enables a team leader to allocate to people. Would like it to:
1. calculate the correct rate of bonus pot payable based on the value of the sales (there are three levels)
2. divide this pot up between the three types of people to be paid (introducer, presenter, support)
3. allow multiple people to be included and the amounts recalculated amongst them
Infographic of how the bonus scheme works is attached. Just need some way of automating the allocation of it.
1. calculate the correct rate of bonus pot payable based on the value of the sales (there are three levels)
2. divide this pot up between the three types of people to be paid (introducer, presenter, support)
3. allow multiple people to be included and the amounts recalculated amongst them
Infographic of how the bonus scheme works is attached. Just need some way of automating the allocation of it.
Julia L.
100% (2)Projects Completed
3
Freelancers worked with
3
Projects awarded
38%
Last project
4 Jul 2019
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hello Julia,
What is the status of the project?
Thanks
804675
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