Tiered commission plan with new accounts plan paid monthly
I posted here a few weeks ago and someone was able to help! I have an added twist to the commission plan that I got help on.
I need to have sales of new account commissioned at a different rate than the normal commission plan. However, I would also like to have the sales of the new accounts included into the overall commission cumulative sales total. In that way the salesman is able to move into the next commission tier. I do NOT want to have the sales of the new accounts to be double commissioned, ie paid at both the new accounts commission rate and the normal commission rate.
Therefore my question is: How do I get the sales of the new accounts to be included in the normal cumulative sales plan total without it getting commissioned at the normal sales plan rate.
See attached spreadsheet. I have the new sales accounts and the commission for it separated from the normal sales plan. But I don't know how to include the sales of the new accounts into the sales of the normal plan without it getting commissioned at the normal plan rate.
Help!!! thank you!!
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By Cmar in forum Excel Formulas & Functions
Last Post: 03-08-2014, 02:15 AM
By ncsvapi in forum Excel Programming / VBA / Macros
Last Post: 11-03-2013, 08:23 AM
By sachinshaligram in forum Excel Programming / VBA / Macros
Last Post: 06-29-2012, 06:27 AM
By rock_chalk35 in forum Excel General
Last Post: 06-08-2012, 01:39 PM
By mdithi in forum Excel General
Last Post: 05-11-2012, 02:14 AM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1