Excel spreadsheet recreate
waterdawg77
NP_EX16_1b_MirielleWhite_1.xlsxDocumentation
| New Perspectives Excel 2016 | Module 1: SAM Project 1b | |
| Rico's Cool Cream | |
| GETTING STARTED WITH EXCEL | |
| 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. | |
Payroll
| Rico's Cool Cream | ||||
| Payroll - June 1-7, 2018 | ||||
| Employee Name | Salary | DOB | Last 4 SSN | Employee ID |
| Robert Thomas | $ 456.27 | 1/2/80 | 4578 | RT804578 |
| Donna Green | $ 506.05 | 3/5/83 | 2133 | |
| Kimberly Mitchell | $ 501.49 | 7/9/65 | 4789 | |
| Susan Parker | $ 346.71 | 4/8/52 | 4785 | |
| Edward Scott | $ 410.33 | 6/3/60 | 1314 | |
| Richard Carter | $ 350.04 | 1/4/48 | 1124 | |
| Dora Thompson | $ 348.70 | 2/9/92 | 5478 | |
| Marley Ruiz | $ 426.63 | 1/1/80 | 4659 | |
| Carl Palmer | $ 360.32 | 4/7/83 | 3018 | |
| Claudia Hall | $ 455.71 | 8/1/65 | 2345 | |
| Faith Hartman | $ 246.04 | 5/4/52 | 7496 | |
| Natalie Peters | $ 419.86 | 7/2/60 | 1709 | |
| Amanda Richardson | $ 216.78 | 1/4/48 | 1848 | |
| Mark Harris | 4785 | |||
| Helen Hill | 1213 | |||
| Michelle Walker | 1585 | |||
| Number of Employees | ||||
Profit
| Rico's Cool Cream | ||||
| June 1-7, 2018 | ||||
| Riverside | Stark Street | Uptown | Walpole | Total |
| Sales | $ 35,875.67 | $ 28,967.24 | $ 36,874.59 | $ 45,784.35 |
| Expenses | $ 15,236.78 | $ 12,658.47 | $ 17,895.36 | $ 25,478.36 |
| Profit | ||||
| Note: Weekly calculations | ||||
| As of June 8, 2018 | ||||
