Problem 4.9 (1)

LENOVO Forecasting Moving averages - 1 period moving average Num pds 3 To change the number of periods use the scrollbar, do Data Forecasts and Error Analysis Period Demand Forecast Error Absolute Squared JANUARY 1.8 FEBRUARY 1.67 1.8 -0.13 0.13 0.0169 MARCH 1.7 1.67 0.03 0.03 0.0009 APRIL 1.85 1.7 0.15 0.15 0.0225 MAY 1.9 1.85 0.05 0.05 0.0025 JUNE 1.87 1.9 -0.03 0.03 0.0009 JULY 1.8 1.87 -0.07 0.07 0.0049 AUGUST 1.83 1.8 0.03 0.03 0.0009 SEPTEMBER 1.7 1.83 -0.13 0.13 0.0169 OCTOBER 1.65 1.7 -0.05 0.05 0.0025 NOVEMBER 1.7 1.65 0.05 0.05 0.0025 DECEMBER 1.75 1.7 0.05 0.05 0.0025 Total -0.05 0.77 0.0739 Average -0.00454545 0.07 0.00671818 Bias MAD MSE SE 0.09061518 Next period 1.75 Enter the past demands in the data area Enter the past demands in the data area

o not change the cell itself Abs Pct Err a) 07.78% 01.76% 08.11% 02.63% 01.60% 03.89% 01.64% 07.65% 03.03% 02.94% 02.86% 43.90% b) 03.99% MAPE c)