I Need Excel, VBA and Macro expert to get commission calculation sheet done
- or -
Post a project like this2292
$$
- Posted:
- Proposals: 13
- Remote
- #1841941
- Awarded
Virtual Assistant, Excel programmer, Customer Support Agent, EN-GR/GR-EN Translator
Kornos
Spreadsheets and Databases Development, Data Mining, Development (VBA, Visual Basic, SQL), Finance, Financial Markets
Denny
12280502558816498656649846652667454117688319634511414007144947314670171762865
Description
Experience Level: Intermediate
Estimated project duration: less than 1 week
I need the attached sample to have a formula or whatever to calculate the commission based in the below structure, structure, values and other information available in the attachment also you will have to explain to me how it is done so i can copy it in my master sheet.
Deadline is 72 hours after getting awarded for the project.
Structure
When Person achieve X category target they get 200
When Person achieve Z category target they get 400
When person overachieve in Category X they don't get anything for excess
When person overachieve in Category Z they get 15% of the extra sku's value ( Example if the total sku's value they over acheieve is 5000 they will get 15% out of the 5000 but the only condition is to hit 100% if the named taget)
If the overachievement sku's are all in the same day the 15% commission will be calculated of the highest value
Deadline is 72 hours after getting awarded for the project.
Structure
When Person achieve X category target they get 200
When Person achieve Z category target they get 400
When person overachieve in Category X they don't get anything for excess
When person overachieve in Category Z they get 15% of the extra sku's value ( Example if the total sku's value they over acheieve is 5000 they will get 15% out of the 5000 but the only condition is to hit 100% if the named taget)
If the overachievement sku's are all in the same day the 15% commission will be calculated of the highest value
Ab F.
100% (2)Projects Completed
1
Freelancers worked with
1
Projects awarded
67%
Last project
6 Jan 2018
Qatar
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