excel project.
zaina
SC_EX16_3a_HamadAlrasheed_1.xlsxDocumentation
| Shelly Cashman Excel 2016 | Module 3: SAM Project 1a | |
| Pick Up Motors | |
| WORKING WITH LARGE WORKSHEETS, CHARTING, AND WHAT-IF ANALYSIS | |
| 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. | |
2018 Jan-Jun Sales
| PICK UP MOTORS | ||||||||
| Sales Report - January to June 2018 | ||||||||
| Sales | ||||||||
| Vehicle Type | January | February | March | Trend | Total | |||
| Car | $ 142,000.00 | $ 147,600.00 | $ 153,280.00 | $ 155,790.00 | $ 78,960.00 | $ 186,985.00 | $ 864,615.00 | |
| Suv | $ 164,500.00 | $ 135,050.00 | $ 142,340.00 | $ 98,756.00 | $ 72,300.00 | $ 155,420.00 | $ 768,366.00 | |
| Truck | $ 97,685.00 | $ 98,600.00 | $ 99,402.00 | $ 101,540.00 | $ 102,786.00 | $ 105,200.00 | $ 605,213.00 | |
| Other | $ 32,547.00 | $ 25,600.00 | $ 27,890.00 | $ 26,450.00 | $ 9,620.00 | $ 31,248.00 | $ 153,355.00 | |
| Total | $ 436,732.00 | $ 406,850.00 | $ 422,912.00 | $ 382,536.00 | $ 263,666.00 | $ 478,853.00 | $ 2,391,549.00 | |
| Monthly Sales Contribution to Six-Month Sales Total - January to June 2018 | ||||||||
| Sales | ||||||||
| Percentage | 0.18 | 0.17 | 0.18 | 0.16 | 0.11 | 0.20 | ||
| Sales Charts January to June 2018 | ||||||||
| Commission - January to June 2018 | ||||||||
| Monthly Commission | January | February | March | April | May | June | Trend | Total |
| Gross Amount | $ - 0 | |||||||
| Net Amount | $ - 0 | |||||||
| Net Commission % | 0.85 | |||||||
| Commission Estimate - July to Dec 2018 | ||||||||
| Estimated 6 Months Sales Total | ||||||||
| Estimated Average Commission Rate | 2.0% | |||||||
| Estimated Gross Commission | $ - 0 | |||||||
| Estimated Net Commission | $ - 0 | |||||||
| Report Date: |
Monthly Sales per Vehicle Type
Car January February March 142000 147600 153280 155790 78960 186985 Suv January February March 164500 135050 142340 98756 72300 155420 Truck January February March 97685 98600 99402 101540 102786 105200 Other January Feb ruary March 32547 25600 27890 26450 9620 31248
Monthly Sales Contribution to Six-Month Sales Total
Percentage 0.1826146986743738 0.17011986791824044 0.17683601715875361 0.15995323532990544 0.11024904779287399 0.20022713312585275
