excel project
zaina
SC_EX16_2a_HamadAlrasheed_1.xlsxDocumentation
| Shelly Cashman Excel 2016 | Module 2: SAM Project 1a | |
| Rough Stitch Clothing | |
| FORMULAS, FUNCTIONS, AND FORMATTING | |
| Author: | Hamad Alrasheed |
| 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. | |
Profit Analysis
| Rough Stitch Clothing | ||||
| Sales | ||||
| Department | 2018 | 2019 | 2020 | 2021 |
| Women's | 150,200 | 88,600 | 125,000 | 178,956 |
| Men's | 123,615 | 47,100 | 114,580 | 145,698 |
| Children's | 85,680 | 15,417 | 74,250 | 105,600 |
| Babies' | 75,000 | 40,300 | 62,358 | 86,400 |
| Total | ||||
| Average | ||||
| Highest | ||||
| Lowest | ||||
| Expenses | ||||
| 2018 | 2019 | 2020 | 2021 | |
| Items Cost | 148,500 | 79,850 | 125,340 | 168,950 |
| Payrol | 52,689 | 42,350 | 45,600 | 52,350 |
| Rent | 68,900 | 70,200 | 70,200 | 70,200 |
| Other | 15,230 | 12,364 | 1,680 | 2,050 |
| Total | $ 285,319 | $ 204,764 | $ 242,820 | $ 293,550 |
| Profit | ||||
| 2018 | 2019 | 2020 | 2021 | |
| Amount |
Employee Discount
| Employee Discount Listing | |||||
| Employee Name | Department | Dept Code | Employee ID | Hiring Date | Discount |
| Stephanie Michaelski | Women's | 010 | SM-WO-010 | 1/20/21 | 0.05 |
| Maria Angeles | Women's | 010 | 2/5/18 | 0.22 | |
| Jayson Ellerbee | Men's | 021 | 3/7/19 | 0.18 | |
| Lily Minamoto | Children's | 034 | 5/8/18 | 0.22 | |
| Lauren Ramirez | Babies' | 043 | 7/15/18 | 0.22 | |
| Last updated | Monday, April 04, 2016 |
