Question: Use a 3 - month weighted moving average to forecast the sales for the months June, July, and August. Use weights of ( 1 0

Use a 3-month weighted moving average to forecast the sales for the months June, July, and
August. Use weights of (10),(5), and (1), giving more weight to more recent data. (6.5 pts)
b) Use exponential smoothing with =0.4 to forecast the sales for the months June, July, and
August. Assume that the forecast for May was $39 million. (6.5 pts)
c) Calculate the Mean Absolute Percent Error (MAPE) for each of the two forecasting methods: 3-
month weighted moving average and exponential smoothing, for each month (June, July, and
August). Based on these calculations, identify which method provided a more accurate forecast
for each month. Be sure to show all error measurements. (7 pts)

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!