I am trying to make excel work for our salesteam. The thing I try to put togheter is a workbook where each salesperson have a place to write down each sale. They put in the amount of each sale and excel will show how much is earned that month.
For instance when each new month starts, each teammember is given a budget. All sales within the budget is rewarded with a commision on 10 %. All sales that are made one top of the monthly budget is rewarded 30 % of the amount of each sale. Say a sale of product X gives a total of USD 1.000 added to the monthly sale, this will give the person whom made this sale either 100 USD or 300 USD, if they are over budget or not.
In addition they have a minimum vage of 100 USD each and every working day Mon-Fri each week. On top of that comes the sales reward, either 10 or 30 % of each sales made.
I belive that the salesteam will focus better if they can use a excel book like this to keep track of the salary and paycheck.
I have tried many things but I am new to excel so I can't seem to make this work. I even tried to modify an excisting template that I downloaded from microsoft. I found several other templates on the net but they all seemed to be based on the one over at MS.
Bookmarks