I need help in this part. Please do it correctly, I need the answers of question 8 and 9 and also the solution of above methods in excel with the chart. Please do it correctly

1	2007	1: Winter	5100	2	SSD-2200 Chip	112200
2	2007	1: Winter	4898	2	SSD-2200 Chip	107756
3	2007	1: Winter	5260	2	SSD-2200 Chip	115720
4	2007	2: Spring	5169	2	SSD-2200 Chip	113718
5	2007	2: Spring	4793	2	SSD-2200 Chip	105446
6	2007	2: Spring	3553	2	SSD-2200 Chip	78166
7	2007	3: Summer	3152	2	SSD-2200 Chip	69344
8	2007	3: Summer	4760	2	SSD-2200 Chip	104720
9	2007	3: Summer	4157	2	SSD-2200 Chip	91454
10	2007	4: Autumn	3772	2	SSD-2200 Chip	82984
11	2007	4: Autumn	4595	2	SSD-2200 Chip	101090
12	2007	4: Autumn	3375	2	SSD-2200 Chip	74250
13	2008	1: Winter	2280	2	SSD-2200 Chip	50160
14	2008	1: Winter	2634	2	SSD-2200 Chip	57948
15	2008	1: Winter	3667	2	SSD-2200 Chip	80674

Task 5 -Forecast Demand for the SSD-2200 (10 points) The demand for the SSD-2200 Chip has been very difficult to predict over the past three years. Your team has decided to try and forecast demand using exponential smoothing. You are not sure what value of a (alpha) to use, so you have decided to create and compare two forecasts using two values of a. The first forecast should use an a value equal to 0.4 and the second forecast should use an a value of 0.2. For each forecast, measure the forecast error and select the best method for the past three years (Months 1 to 36) by calculating the Mean Absolute Deviation (MAD) and the Mean Squared Error (MSE). To communicate your findings, you will also need to create a plot of the Actual Units Sold (Demand) and both forecasts. To calculate each forecast, you will need to create a formula to calculate the Exponential Smoothing forecast value for each of the months in your data set. Use the unit demand for the first month as the starting forecast in Month 1 (i.e., your first forecast will be in Month 2) and use your formula to calculate the forecast for remaining 35 months. To calculate the MAD, you will need to calculate the average of the absolute forecast errors for all months. To calculate the MSE you will need to calculate the average mean squared error of the forecast errors for all months. The plot should use the format below (Note that the direction of the lines in the chart in your answer might be different from this figure.): The plot should use the format below (Note that the direction of the lines in the chart in your answer might be different from this figure.): SSO 2200 Chie Demand +Actus ---E Swingers Datsmitted from this man I . 00 S.T. 11 12 13 14 16 17 18 Task 5 Questions: 8. What are the MAD and MSE using a = 0.4 to prepare a forecast? What are the MAD and MSE for the forecast prepared with a = 0.22 9. Which value of a do you recommend should be used for future forecasts? Why? 2 2 2 2 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 2008 2008 2008 2008 2008 2008 2008 2008 2008 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2: Spring 2: Spring 2: Spring 3: Summer 3: Summer 3: Summer 4: Autumn 4: Autumn 4 Autumn 1: Winter 1: Winter 1: Winter 2: Spring 2: Spring 2: Spring 3: Summer 3: Summer 3: Summer 4. Autumn 4: Autumn 4: Autumn 2291 2960 2951 2844 1768 3180 2830 1952 2932 2094 2476 3898 4063 2311 3995 2594 3874 2565 2463 3562 2443 NINININININININININININININININININININININ 2 2 SSD-2200 Chip SSD-2200 Chip SSD-2200 Chip SSD-2200 Chip SSD-2200 Chip SSD-2200 Chip SSD-2200 Chip SSD-2200 Chip SSD-2200 Chip SSD-2200 Chip SSD-2200 Chip SSD-2200 Chip SSD-2200 Chip SSD-2200 Chip SSD-2200 Chip SSD-2200 Chip SSD-2200 Chip SSD-2200 Chip SSD-2200 Chip SSD-2200 Chip SSD-2200 Chip 50402 65120- 64922 62568 38896 69960 62260 42944 64504 46068! 54472 85756 89386 50842 87890 57068 85228: 564301 541861 783641 53746 2 2 2 2 Task 5 -Forecast Demand for the SSD-2200 (10 points) The demand for the SSD-2200 Chip has been very difficult to predict over the past three years. Your team has decided to try and forecast demand using exponential smoothing. You are not sure what value of a (alpha) to use, so you have decided to create and compare two forecasts using two values of a. The first forecast should use an a value equal to 0.4 and the second forecast should use an a value of 0.2. For each forecast, measure the forecast error and select the best method for the past three years (Months 1 to 36) by calculating the Mean Absolute Deviation (MAD) and the Mean Squared Error (MSE). To communicate your findings, you will also need to create a plot of the Actual Units Sold (Demand) and both forecasts. To calculate each forecast, you will need to create a formula to calculate the Exponential Smoothing forecast value for each of the months in your data set. Use the unit demand for the first month as the starting forecast in Month 1 (i.e., your first forecast will be in Month 2) and use your formula to calculate the forecast for remaining 35 months. To calculate the MAD, you will need to calculate the average of the absolute forecast errors for all months. To calculate the MSE you will need to calculate the average mean squared error of the forecast errors for all months. The plot should use the format below (Note that the direction of the lines in the chart in your answer might be different from this figure.): The plot should use the format below (Note that the direction of the lines in the chart in your answer might be different from this figure.): SSO 2200 Chie Demand +Actus ---E Swingers Datsmitted from this man I . 00 S.T. 11 12 13 14 16 17 18 Task 5 Questions: 8. What are the MAD and MSE using a = 0.4 to prepare a forecast? What are the MAD and MSE for the forecast prepared with a = 0.22 9. Which value of a do you recommend should be used for future forecasts? Why? 2 2 2 2 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 2008 2008 2008 2008 2008 2008 2008 2008 2008 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2: Spring 2: Spring 2: Spring 3: Summer 3: Summer 3: Summer 4: Autumn 4: Autumn 4 Autumn 1: Winter 1: Winter 1: Winter 2: Spring 2: Spring 2: Spring 3: Summer 3: Summer 3: Summer 4. Autumn 4: Autumn 4: Autumn 2291 2960 2951 2844 1768 3180 2830 1952 2932 2094 2476 3898 4063 2311 3995 2594 3874 2565 2463 3562 2443 NINININININININININININININININININININININ 2 2 SSD-2200 Chip SSD-2200 Chip SSD-2200 Chip SSD-2200 Chip SSD-2200 Chip SSD-2200 Chip SSD-2200 Chip SSD-2200 Chip SSD-2200 Chip SSD-2200 Chip SSD-2200 Chip SSD-2200 Chip SSD-2200 Chip SSD-2200 Chip SSD-2200 Chip SSD-2200 Chip SSD-2200 Chip SSD-2200 Chip SSD-2200 Chip SSD-2200 Chip SSD-2200 Chip 50402 65120- 64922 62568 38896 69960 62260 42944 64504 46068! 54472 85756 89386 50842 87890 57068 85228: 564301 541861 783641 53746 2 2 2 2