Question: Problem 4.33 Question Help o Storrs Cycles has just started selling the new Cyclone mountain bike, with monthly sales as shown in the table. Month

Problem 4.33 Question Help o Storrs Cycles has

Problem 4.33 Question Help o Storrs Cycles has just started selling the new Cyclone mountain bike, with monthly sales as shown in the table. Month Sales Jan 400 Feb 380 Mar Apr 418 365 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 (round your response to two decimal places): Month Sales Forecast Jan 400 Feb 380 400.00 Mar 418 396.00 Apr 365 400.40 May 393.32 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). Month Sales Forecast Jan 400 Feb 380 Mar 418 Apr 365 399.33 May 387.67 sales C) Assume that May's actual sales figure turns out to be 410. For the forecast developed by Bob using exponential smoothing, the mean absolute deviation (MAD) = (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!