Question: Based upon the following historical data, answer the following questions: a. Calculate the weighted three-month moving average forecast using weights of wl -0.1,w2-03, and w3

Based upon the following historical data, answer

Based upon the following historical data, answer the following questions: a. Calculate the weighted three-month moving average forecast using weights of wl -0.1,w2-03, and w3 -0.6 for periods 4 to 12. b. Calculate the single exponential smoothing forecast for periods 2 to 12 using an initial forecast (F1) of 61 and in a of 0.30. c Use MAD to measure accuracy of the forecasting model. d. Which of the two forecasts would you prefer and why? Month Actual Demand Week Actual Demand 48 Jul 81 Feb 50 Aug 75 Mar 53 Sep 78 Apr 59 Oct 84 67 Nov 88 Jun 70 Dec 80 Jan May

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!