Storrs Cycles has just started selling the new Cyclone mountain bike, with monthly sales as shown in the table.

Month Jan Feb Mar Apr

Sales 407 380 414 375

Based on the given monthly sales data, it can be said that there is ______ linear trend in sales over time.

Co-owner Bob Day wants to forecast by exponential smoothing by initially setting February's forecast equal to January's sales with= 0.10

Using the forecasting method, Bob's forecast for the month of May is (round your response to two decimal places):

Month Sales Forecast

Jan 407 ------

Feb 380 407.00

Mar 414 404.30

Apr 375 405.27

May ----- -------

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 407 ----

FEB 380 ----

MAR 414 ----

APR 375 400.33

MAY ---- ______ (ANSWER NEEDED)

Sales Forecast for the month of May is 389.67

Explanation:

Here, for the given data, we can have the three period forecasting analysis as follows:

Formulas used:

three period forecast = Average of actual sales of previous 3 periods

Resultant sheet:

Sales Forecast for the month of May is 389.67

With the above information from the previous questions answered, I need the following answered:

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) = _____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) = _____sales (round your response to two decimal places).

d) Based on the above calculations, the forecast approach used by (Sherry or Bob) is better.

PLEASE ANSWER C AND D. THE PREVIOUS ANSWERS i HAVE INCLUDED ALONG WITH THE CHARTS...THANKS FOR YOUR HELP! I'M NOT YELLING I JUST WANT YOU TO SEE THE DIFFERENCE OF WHAT HAS BEEN DONE AND WHAT I WANT DONE..THANKS.