Good Morning Everyone!
I am trying to build a new excel spreadsheet that will allow me to calculate all the bonuses of my employees based on their performances for easy help when it comes to payroll time.
To do this I need a lot of help with formulas!! I have attached my spreadsheet for reference.
Basically, each employee, listed on the tabs on the bottom of the spreadsheet, will be given a daily score which is recorded under the appropriate date on the calendar for that person. Then, I want the excel file to calculate their monthly average from the scores produced and relay this to a month review sheet.
In the month review sheet, I would like to have it so I can enter the monthly sales of our company and have the sheet calculate how much money is available for bonuses based on the overall team percentage. For example, if the overall team score was 80%, then 2% of the monthly sales would be allotted to a bonus pool. If the overall team score was 90%, then 3% of monthly sales would be allotted to a bonus pool, etc...Then, from this monthly pool, I want the funds to be split amongst the six employees based on their performance. For example, if they get a 90% monthly average they would get a bigger portion of the bonus pool than a colleague who only scored a 70%. I need some ideas and suggestions for how I can use formulas for this, so that the operator of the spreadsheet only has to input the monthly sales amounts, and the daily scores of the employees.
I would be very appreciative of any help I could get!!
Thanks a lot,
Yorke
Bookmarks