Question: Need help with c a) Based on the given monthly sales data, it can be said that there is not a strong linear trend in

Need help with c a) Based on the given monthlyNeed help with c

a) Based on the given monthly sales data, it can be said that there is not a strong linear trend in sales over time. b) First, co-owner Bob Day wants to forecast by exponential smoothing by initially setting February's forecast equal to January's sales with a = 0.20. Using the forecasting method, Bob's forecast for the month of May is (rour your response to two decimal places): Forecast Month Jan Feb Mar Apr May Sales 407 376 414 370 407.00 400.80 403.44 396.75 Second, co-owner Sherry Snyder wants to forecast using a three-period moving average. The forecast for the month of May is (round your response to two decimal places). Forecast Month Jan Feb Mar Apr May Sales 407 376 414 370 399.00 386.67 c) Assume that May's actual sales figure turns out to be 400. For the forecast developed by Bob using exponential smoothing, the mean absolute deviation (MAD) = 20.22 sales (round your response to two decimal places) Assume that May's actual sales figure turns out to be 400. For the forecast developed by Sherry using a 3-month moving average, the mean absolute deviation (MAD) = 46.33 sales (round your response to two decimal places)

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!