In: Advanced Math
Develop a three-period moving average forecast for April 2019 through January 2020. Calculate the MFE, MAD, and MAPE values for April through December 2019. LOADING... Click the icon to view the time series data. Develop a three-period moving average and fill-in the table below (enter your responses rounded to one decimal place). Month Demand Forecast January 2019 123123 February 7474 March 114114 April 7777 103.66103.66 May 9898 88.3388.33 June 136136 96.3396.33 July 103103 103.66103.66 August 106106 112.33112.33 September 100100 103103 October 9393 99.6699.66 November 9090 94.9394.93 December 8989 90.6690.66 The forecast for January 2020 is nothing. (Enter your response rounded to one decimal place.) The MFE is nothing. (Enter your response rounded to one decimal place and include a minus sign if necessary.) The MAD is nothing. (Enter your response rounded to one decimal place.) The MAPE is nothing %. (Enter your response rounded to one decimal place.) Enter your answer in each of the answer boxes.
As per three period moving average method:
forecast of particular month=(sum of demand of previous three month)/3
So, forecast of April month=(123+74+114)/3=103.67
forecast of May month=(74+114+77)/3=88.33
similarly you can calculate for other months(image attached) and formula of MFE, MAD and MAPE also attached
Now
N=number of forecast calculated period
so, for April to December, N=9
MFE=(-24.33/9)=-2.7
MAD=(123/9)=13.7
MAPE=(122.77/9)=13.6