Question: PLEASE ONLY ANSWER THE SECOND PART TO B a) Based on the given monthly sales data, it can be said that there is not a

PLEASE ONLY ANSWER THE SECOND PART TO B a) BasedPLEASE ONLY ANSWER THE SECOND PART TO B

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.10. Using the forecasting method, Bob's forecast for the month of May is (round your response to two decimal places): Sales Forecast Month Jan Feb Mar Apr May 404 376 414 365 404.00 401.20 402.48 398.73 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 404 376 414 365 398.00 385 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) = 19.89 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) = 8 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!