Zimm\'s Auto Sales would like to know their short term and long term performance
ID: 3228704 • Letter: Z
Question
Zimm's Auto Sales would like to know their short term and long term performance for the future. They would like to know an estimation of their future sales for the next 6 months (short term) and 2 years (long term). Analyze the Excel data attached and do some forecasting to give Zimm's Auto Sales predictions of number of cars sold so they can gain insight and prepare their workforce, cash flow and resources for the future.
Excel Data (In Onedrive): https://1drv.ms/x/s!ApY0tZDzum95lFoahcYX6TIvbBZL
Explanation / Answer
Monthly Sales # Cars Sold Revenue # Cars Sold Revenue # Cars Sold Revenue Month 2015 2016 2017 2018 2019 January 80 $289,042.00 100 $452,712.00 122.7817 122.8333 February 87 $361,562.00 116 $459,326.00 122.8548 122.8334 March 125 $493,384.00 135 $725,665.00 122.8362 122.8333 April 40 $140,000.00 110 $575,545.00 117 122.8242 122.8333 May 42 $196,980.00 76 $344,922.00 122.6667 122.8384 122.8333 June 39 $178,425.00 94 $497,395.00 124.8889 122.833 122.8333 July 45 $191,250.00 108 $546,003.00 121.5185 122.8319 122.8333 August 35 $157,500.00 141 $669,599.00 123.0247 122.8344 122.8333 September 32 $131,336.00 158 $742,064.00 123.144 122.8331 122.8333 October 38 $169,784.00 85 $405,289.00 122.5624 122.8331 122.8333 November 73 $364,272.00 148 $752,069.00 122.9104 122.8335 122.8333 December 104 $485,939.00 146 $810,696.00 122.8723 122.8333 122.8333
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.