Zimm\'s Auto Sales would like to know their short term and long term performance
ID: 3228656 • 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
Forecast using moving average next 6 months Forecast using moving average next 2 years Monthly Sales Month 590844.3 591393.6041 January 591545.8 591393.1223 February 591474.4 591393.247 March 545901.00 591288.2 591393.1279 April 576964.00 591436.1 591393.1657 May 616176.67 591399.5 591393.1802 June 579680.56 591374.6 591393.158 July 590940.41 591403.4 591393.168 August 595599.21 591392.5 591393.1687 September 588740.06 591390.2 591393.1649 October 591759.89 591395.4 591393.1672 November 592033.05 591392.7 591393.1649 December 590844.33 591392.7 591393.1672
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.