To calculate the Bonuses for January (row 17), you will use the IF function to compare the January

Sales (B7) to the Target for Bonus amount (B29) under Assumptions. If the January Sales meets or exceeds the Target, then they will get a % of the sales as indicated

under Assumptions (multiply the % for Bonuses (B30) by the Sales (B7)). If they dont meet the sales amount, then they get $0. Use Absolute and Relative Referencing. Note: It is possible for some of these results to be $0. HOW TO ENTER IN EXCEL???

January 1, 2017 to December 31, 2017 Today's Date: January February March May September ctober November December Total 32099 892 36198 991 23894 35001 801 38645 901 45690 44321 890 29411 38382 964 25401 31895 40938 Interest 795 1021 Total Income 29239 32991 37189 35802 46578 45211 24870 39546 30310 39346 26343 32916 42034 5688.8 4266.6 2844.4 4266.6 2844.4 6419.8 4814.85 3209.9 4814.85 3209.9 7239.6 5429.7 3619.8 5429.7 3619.8 7000.2 5250.15 3500.1 5250.15 3500.1 9138 6853.5 4569 6853.5 4569 8864.2 6648.15 4432.1 6648.15 4432.1 4778.8 3584.1 2389.4 3584.1 2389.4 5796.75 3864.5 5796.75 3854.5 5882.2 4411.65 2941.1 4411.65 2941.1 7676.4 5757.3 3838.2 5757.3 3838.2 5080.2 3810.15 2540.1 3810.15 2540.1 6379 4784.25 3189.5 4784.25 3189.5 81876.2 61407.15 40938.1 61407.15 40938.1 Sales Force Rent & Utilities Bonuses Total Expenses Assumptions Product Administrative Sales Foroe Rent & Utilities 20% 15% 10% 15% 10% $35,000 Target for Bonus Bonus %