Pls showing me how to do Deseasonalized Demand, and regression using the attached.

Please show using Microsoft Excel!!!! Do not answer if you are not using the EXCEL. Thank you.

Assignment 3 - BSAD 554 1. Consider monthly demand for the ABC corporation, as shown in the following table. Forecast the monthly demand for Year 6 using the static method for forecasting. Evaluate the bias, TS, MAD, MAPE, and MSE. Evaluate the quality of the forecast. Sales Year 1 Year 2 Year 3 Year 4 Year 5 JAN 2,000 3,000 2,000 5,000 5,000 FEB 3,000 4.000 5,000 4,000 2,000 MAR 3,000 3,000 5,000 4,000 3,000 APR 3,000 5,000 3,000 2,000 2,000 MAY 4,000 5,000 4,000 5,000 7,000 JUN 6,000 8,000 6,000 7,000 6,000 JUL 7,000 3,000 7,000 10,000 8,000 AUG 6,000 8,000 10,000 14,000 10,000 SEP 10,000 12,000 15,000 16,000 20,000 OCT 12,000 12,000 15,000 16,000 20,000 NOV 14,000 16,000 18,000 20,000 22,000 DEC 8,000 10,000 8,000 12,000 8,000 Total 78,000 89,000 98,000 115,000 113,000A B C D E F G H I Problem 1 Demand Year Month Period D Year 1 JAN 2000 FEB 3000 MAR 3000 APR 4 3000 MAY 5 4000 JUN 6 6000 JUL 7 7000 AUG 8 6000 SEP 9 10000 OCT 10 12000 NOV 11 14000 DEC 12 8000 Year 2 JAN 13 3000 FEB 14 4000 MAR 15 3000 APR 16 5000 MAY 17 5000 JUN 18 8000 JUL 19 3000 AUG 20 8000 SEP 21 12000 OCT 22 12000 NOV 23 16000 DEC 24 10000 Year 3 JAN 25 2000 FEB 26 5000 MAR 27 5000 APR 28 3000 MAY 29 4000 JUN 30 6000 JUL 31 7000 AUG 32 10000 SEP 33 15000 OCT 34 15000 NOV 35 18000 DEC 36 8000 Year 4 JAN 37 5000 FEB 38 4000 MAR 39 4000 APR 40 2000 MAY 41 5000 JUN 42 7000 JUL 43 10000 AUG 44 14000 SEP 45 16000 OCT 46 16000 NOV 47 20000 DEC 48 12000 Year 5 JAN 49 5000 FEB 50 2000 MAR 51 3000 APP 52 2000 MAY 53 7000 JUN 54 6000 JUL 55 8000 AUG 56 10000 SEP 57 20000 OCT 58 20000 NOV 59 22000 DEC 60 8000