.

Note: Please do all the question please

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 3 67 4 5 71 73 o N al calculate the following yakuns using the historical data above (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: fi. Simple three-month moving average forecast for Period 6: it. 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: ii. Exponential smoothing forecast for Period 6: it. Mean Absolute Deviation (MAD) for Periods 5 and 6: iv. Mean Absolute Percentage Error (MAPE) for Periods 5 and 6: % Based on the results obtained in Question 4 (a) and (b) above, which method is more suited to forecast demand for this particular problem? Please give reasons in support of your answer. For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac). BI V Paragraph Arial 10pt T V V