Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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]
Step by Step Solution
★★★★★
3.51 Rating (164 Votes )
There are 3 Steps involved in it
Step: 1
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...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started