Storrs Cycles has just started selling the new Cyclone mountain…
Question Answered step-by-step Storrs Cycles has just started selling the new Cyclone mountain… Storrs Cycles has just started selling the new Cyclone mountain bike, with monthly sales as shown in the table. Month Jan Feb Mar AprSales 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.00Mar 414 404.30Apr 375 405.27May —– ——- 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.33MAY —- ______ (ANSWER NEEDED) Sales Forecast for the month of May is 389.67Explanation: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 periodsResultant 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. Engineering & Technology Industrial Engineering Operations Management BBM 411 Share QuestionEmailCopy link Comments (0)
Needs help with similar assignment?
We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper
Get Answer Over WhatsApp Order Paper Now