Question: Question 2 (30 points): For the same actual demand data above, perform a forecast using: Moving average of 3 periods. Exponential smoothing of (a=0.2). Make

Question 2 (30 points): For the same actual
Question 2 (30 points): For the same actual
Question 2 (30 points): For the same actual demand data above, perform a forecast using: Moving average of 3 periods. Exponential smoothing of (a=0.2). Make the first forecast value equal to the actual demand. Sketch your results on an excel sheet (period vs. Demand and vs. forecast values) Question 1 (30 points): The following table shows the actual and forecast demand of the textbook production planning and operations analysis, by Nahmias" at University of Sharjah bookstore. Date Actual demand Forecast value (textbooks/day) (textbooks/day) 7-september - 2014 3 8-Sept. 5 9-Sept. 7 10-Sept. 12 11-Sept. 12-Sept. 13-Sept. 14-Sept. 0 2 6 15 8 7 7 2 10 8 4 0 Calculate the different forecast assessment measures, namely: MAD, MSE, MAPE. Question 2 (30 points): For the same actual demand data above, perform a forecast using: Moving average of 3 periods. Exponential smoothing of (a=0.2). Make the first forecast value equal to the actual demand. Sketch your results on an excel sheet (period vs. Demand and vs. forecast values)

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!