Question: Answer D and E only please Question 5 The following table shows the sales. A - Calculate the following nave, 3-months moving average and 3-months

Answer D and E only please Question 5 TheAnswer D and E only please

Question 5 The following table shows the sales. A - Calculate the following nave, 3-months moving average and 3-months weighted moving average forecasts from April to June (the highlighted area). Note that for the 3- months WMA the impact factors are 0.7 (most recent), 0.3 and 0.2 (least recent). (3) Sales Naive 3-months 3-months MA WMA 25 19 Month January February March April May June 14 15 16 24 B - Calculate MAD values and decide the best forecasting method (2) C - Do you think high alpha value (0.1) is a good or bad decision for the exponential smoothing forecast? Explain your answer. (2) D-Conduct a seasonality analysis (calculate seasonal index) and identify the season(s) you observe seasonality. (3) 2019 2020 2021 20 Winter 14 16 30 33 36 Spring Summer Fall 16 19 22 13 20 21 E- If you expect that the average sales for 2022 will be 160 (entire year), then calculate the forecast for the summer of 2022. (2)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!