Sales of Volkswagen's popular Beetle have grown steady at Zimmerman's garage during the past 5 years...

 

Transcribed Image Text:

Sales of Volkswagen's popular Beetle have grown steady at Zimmerman's garage during the past 5 years (see table below). The sales manager had predicted in 2014 that 2015 sales would be 410 VWs. NB: please round of your answers to two decimal places. Year 2015 2016 2017 2018 2019 2020 Sales 450 495 518 563 584 ? Forecast 410 2.1 Forecast above data using; a) Exponential Smoothing with a=0.30. b) 3 months moving average 2.2 Compute and interpret below, for both, exponential smoothing and 3 month moving average: [6 marks] [6 marks] [6 marks] [6 marks] [2 marks] a) MAD b) MSE c) MAPE d) Tracking Signal e) Which forecasting method will you recommend and why? [8 marks] [6 marks] Sales of Volkswagen's popular Beetle have grown steady at Zimmerman's garage during the past 5 years (see table below). The sales manager had predicted in 2014 that 2015 sales would be 410 VWs. NB: please round of your answers to two decimal places. Year 2015 2016 2017 2018 2019 2020 Sales 450 495 518 563 584 ? Forecast 410 2.1 Forecast above data using; a) Exponential Smoothing with a=0.30. b) 3 months moving average 2.2 Compute and interpret below, for both, exponential smoothing and 3 month moving average: [6 marks] [6 marks] [6 marks] [6 marks] [2 marks] a) MAD b) MSE c) MAPE d) Tracking Signal e) Which forecasting method will you recommend and why? [8 marks] [6 marks]

Answer rating: 100% (QA)

SOLUTION To forecast the sales for the year 2020 using Exponential Smoothing with a 030 we can use the following formula Forecast for 2020 Actual sales for 2019Apologies it seems that part of my respo... View the full answer