Question: Base your initial forecast on a 4 month weighted moving average applied to the following past demand data in the table below, using the weights:

Base your initial forecast on a 4 month weighted
Base your initial forecast on a 4 month weighted moving average applied to the following past demand data in the table below, using the weights: 9.6.4.2 Clargest weight is for most recent data)? Then forecast the same data based on utilizing exponential smoothing with and alpha of 27, and an initial forecast of 37 Nov. Dec. Jan Feb Mar April May Jun 38 36 40 45 53 . 49 57 60 a. What is the forecast for July using a 4 month weighted moving average forecast? 56.38 b. What is the MAD of the weighted moving average forecast? 746 c. What is the forecast based on exponential smoothing? 4711 d. What is the MAD of the exponential smoothing forecast? 5.25 e. If a change occurred and if you are now only evaluating from January onward using exponential smoothing (alpha 53), and January's forecast at 38, what is the new forecast for July? 52.83 and the MAD? 5.22 1. Given all 3 options, what forecasting method would you choose? exponential smoothing with

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!