$7\mathrm{.}17\mathrm{.}1$

Consider monthly demand for the ABC Corporation as shown in the Table below.

A$)$ Forecast the monthly demand for year $6$ using the static method for forecasting.

B$)$ Evaluate the bias, TS$,$ MAD, MAPE, and MSE.

HINT: First de$-$seasonalize the demand from periods $7$ through $54$ and perform a regression using the Data $>$ Data Analysis $>$ Regression tool.

Monthly Demand for ABC Corporation

$\backslash$table$[[$Sales$,$Year $1,$Year $2,$Year $3,$Year $4,$Year $5],[$January$,2,500,3,000,2,000,5,000,5,000],[$February$,3,000,4,000,5,000,4,000,2,000],[$March$,3,000,3,000,5,000,4,000,3,000],[$April$,3,000,5,000,3,000,2,500,2,500],[$May$,4,000,5,500,4,000,5,000,7,000],[$June$,6,000,8,000,6,000,7,000,6,000],[$July$,7,000,3,000,7,000,10,000,8,000],[$August$,6,000,8,000,10,000,14,000,10,000],[$September$,10,000,12,000,15,000,16,000,20,000],[$October$,12,000,12,000,16,000,16,000,20,000],[$November$,14,000,16,000,18,000,20,000,22,000],[$December$,8,000,10,000,8,000,12,000,8,000]]$

Consider monthly demand for the ABC Corporation as shown in the Table below.

A$)$ Forecast the monthly demand for year $6$ using the static method for

forecasting.

B$)$ Evaluate the bias, TS$,$ MAD, MAPE, and MSE.

HINT: First de$-$seasonalize the demand from periods $7$ through $54$ and perform a

regression using the Data $>$ Data Analysis $>$ Regression tool.

Monthly Demand for ABC Corporation

Sales Year $1$ Year $2$ Year $3$ Year $4$ Year $5$

January $2,5003,0002,0005,0005,000$

February $3,0004,0005,0004,0002,000$

March $3,0003,0005,0004,0003,000$

April $3,0005,0003,0002,5002,500$

May $4,0005,5004,0005,0007,000$

June $6,0008,0006,0007,0006,000$

July $7,0003,0007,00010,0008,000$

August $6,0008,00010,00014,00010,000$

September $10,00012,00015,00016,00020,000$

October $12,00012,00016,00016,00020,000$

November $14,00016,00018,00020,00022,000$

December $8,00010,0008,00012,0008,000$