This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: 12. Enter the following data into the Bonuses worksheet a. A1: Total Revenue b. A2: Branch Bonus Rate c. A3: Total Branch Bonus d. A4: Total Bonus for Employees e. A5: Number of Employees at Local Branch f. A6: Average Individual Bonus for Each Employee 13. In cell B1 in the Bonuses worksheet, enter the value in cell E12 of the D Money Banks Worksheet. 14. In cell B2, enter 1.25% (as a percentage). 15. In cell B3, calculate total branch bonus. 16. In cell B4, calculate total bonus for employees by multiplying total B3 by 85%. 17. In cell B5, enter 15. 18. In cell B6, enter formula to calculate individual bonus for each employee. a. Yours should look like this b. 19. Save you work. Upload it to the dropbox....
View Full Document
- Spring '08
- total branch bonus, D Money