Question: Question Completion Status: QUESTION 4 Your manager is trying to determine what forecasting method to use. He has asked for your help because he knows

Question Completion Status: QUESTION 4 Your manager is trying to determine what forecasting method to use. He has asked for your help because he knows that you have learnt demand forecasting techniques at Abu Dhabi University, Month (0) Actual Demand 1 62 2 65 67 68 5 71 6 73 (a) Calculate the following values using the historical data above. Please type in only your final numerical answer in the blanks and round your answers to one decimal place, 1. Simple three-month moving average forecast for Period 5: II. Simple three-month moving average forecast for Period 6: ill. Mean Absolute Deviation (MAD) for Periods 5 and 6: iv. Mean Absolute Percentage Error (MAPE) for Periods 5 and 6: % (b) Calculate the following values using an initial forecast (F4) of 63.8 and an a of 0.30. Please type in only your final numerical answer in the blanks and round your answers to one decimal place. 1. Exponential smoothing forecast for Period 5: il. Exponential smoothing forecast for Period 6: ill. Mean Absolute Deviation (MAD) for Periods 5 and 6: % iv. Mean Absolute Percentage Error (MAPE) for Periods 5 and 6: QUESTION 5
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
