Show excel work and answer question on excel

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

Jan $2,0003,0002,0005,0005,000$

Feb $3,0004,0005,0004,0002,000$

Mar $3,0003,0005,0004,0003,000$

Apr $3,0005,0003,0002,0002,000$

May $4,0005,0004,0005,0007,000$

Jun $6,0008,0006,0007,0006,000$

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

Aug $6,0008,00010,00014,00010,000$

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

Oct $12,00012,00015,00016,00020,000$

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

Dec $8,00010,0008,00012,0008,000$

$2.(26$ pts$)$ Refer to the data set in the $$Q$2$ spreadsheet, which shows monthly demand for the ABC

corporation.

a$)$ Forecast the monthly demand for Year $6$ using the trend projection only. Report your forecast. $(2$

pts$)$ What are the values of MAD, MAPE, MSE, and TS$?(4$ pts$)$

b$)$ Forecast the monthly demand for Year $6$ using the trend & seasonality adjustment. Report your

forecast. $(8$ pts$)$ What are the seasonal factors for each month? $(4$ pts$)$ What are the values of

MAD, MAPE, MSE, and TS$?(4$ pts$)$

c$)$ Based on your analysis, should you consider the seasonality in the forecast? Why or why not? $(4$

pts