Excel spreadsheet recreate
waterdawg77
NP_EX16_2b_MirielleWhite_1.xlsxDocumentation
| New Perspectives Excel 2016 | Module 2: SAM Project 1b | |
| Kelly's Telemarketing | |
| FORMATTING WORKBOOK TEXT AND DATA | |
| Author: | Mirielle White |
| Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website. | |
Weekly Compensation
| Kelly's Telemarketing | ||||||
| Workers' Compensation | ||||||
| Report Date: | 31-Mar-18 | |||||
| Weekly Pay | ||||||
| Employee | Base Salaries | Bonus Multiplier | Bonus Rate | Total Bonus | Total Salaries | Bonus Percentage |
| Joan Dickinson | $350 | 5 | 14 | 70 | ||
| Marley Bubble | $400 | 2 | 20 | 40 | ||
| Bob Roberts | $360 | 1 | 20 | 20 | ||
| Peggy Moore | $420 | 10 | 15 | 150 | ||
| Average | $383 | |||||
| This chart shows the total salary as a combination of the base salary and total bonus. | ||||||
Combined Pay by Employee
Base Salaries
Joan Dickinson Marley Bubble Bob Roberts Peggy Moore 350 400 360 420 Total Bonus
Joan Dickinson Marley Bubble Bob Roberts Peggy Moore 70 40 20 150
