Given the following data for demand at the XYZ Company, calculate the monthly forecast for 2003 using a 3-month moving average. Calculate the Forecast, Error, MAD (mean absolute percentage error),...

Given the following data for demand at the XYZ Company, calculate the monthly forecast for 2003 using a 3-month moving average. Calculate the Forecast, Error, MAD (mean absolute percentage error), Bias and the TS (tracking signal) .

Extracted text: Period Demand Forecast Error MAD Bias TS 2-Oct 2012 800 2-Nov 2012 1000 2-Dec 2012 950 2-Jan 2013 1100 2-Feb 2013 930 2-Mar 2013 1020 2-Apr 2013 870