Documentation
Shelly Cashman Excel 2016 | Module 3: SAM Project 1a
Pick Up Motors
WORKING WITH LARGE WORKSHEETS, CHARTING, AND WHAT-IF ANALYSIS
Author: Zainab Alasfoor
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 February 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
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 February 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
Applied Sciences
Architecture and Design
Biology
Business & Finance
Chemistry
Computer Science
Geography
Geology
Education
Engineering
English
Environmental science
Spanish
Government
History
Human Resource Management
Information Systems
Law
Literature
Mathematics
Nursing
Physics
Political Science
Psychology
Reading
Science
Social Science
Home
Blog
Archive
Contact
google+twitterfacebook
Copyright © 2019 HomeworkMarket.com