Storrs Cycles has just started selling the new Cyclone mountain…

/in /by

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