Question: ONLY PART E PLEASE!!!!!! Suppose you (or your group) are the manager of a company trying to determine what forecasting method to use. Based upon

ONLY PART E PLEASE!!!!!! Suppose you (or your

ONLY PART E PLEASE!!!!!!

Suppose you (or your group) are the manager of a company trying to determine what forecasting method to use. Based upon the following historical data, calculate the following forecasts and specify what procedure you would utilize. Actual Month Demand 1 63 65 67 70 71 73 4 5 a. Calculate the simple 3-month moving average forecast for periods 4-6. (5 points) 6. Calculate the weighted 3-month moving average using weights of 0.50, 0.30, and 0.20 for periods 4-6. (5 points) c. Calculate the single exponential smoothing forecast for periods 2-6 using an initial forecast (F1) 61, and an a of 0.30. (10 points) d. Calculate the exponential smoothing with trend component forecast for periods 2-6 using an initial trend forecast (Tl) of 1.8, and initial exponential smoothing forecast (Si) of 60 an a of 0.30 and a B of 0.30. (15 points) e. Calculate the Mean Absolute Deviation (MAD) for the forecasts made by each technique in periods 4-6. Which forecasting method do you prefer? Using your preferred technique forecast the demands for the following 2 months (months 7-8). (15 points)

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!