On the "data and template" tab I am required to show work as well.

A B D H M Holt-Winter's method Three-period moving average 1 Alpha Beta Gamma 0.200 0.100 0.200 MAD ME MAD ME Demand Base level Trend Seasonality (S) Forecast FE Abs FE Forecast FE Abs FE 3 Period Month Year 7 1 January 2 February 1 3 March 1 10 April 1 11 5 May 12 6 lung 1 13 7 July 1 14 8 August 1 9 September 1 16 10 October 1 17 11 November 1 18 12 December 1 19 13 January 2 20 February 2 21 15 March 2 22 16 April 2 21 17 May 2 24 18 June 2 25 19 July 2 26 20 AU 2 27 21 September 2 28 October 2 29 23 November 2 30 24 December 2 31 25 January 32 26 February 3 1 27 March Instructions to 99 139 104 142 125 165 140 137 166 166 221 191 164 203 281 243 271 279 320 227 285 323 284 286 + 287 319 279 Data & Template Home Insert Draw Page Layout Formulas Data Review View Tell me 07 . H M Three period moving average Holt-Winter's method 1 2 3 4 Alpha Beta Gamma 0.200 0.100 0.200 MAD ME MAD ME 5 6 Period Year Base level (E) Trend (T) Seasonality (5) Forecast FE Abs FE Forecast FE Abs FE 33 34 35 36 37 27 28 29 30 31 Demand 3 279 3 353 3 329 3 299 3 409 3 3 261 3 409 3 299 3 340 4 382 4 307 4 39 40 33 34 14 Month March April May June July August September October November December January February March April May June July August September October November December January February March 36 32 38 39 40 41 42 40 460 4 4 4 4 4 44 331 426 476 365 502 515 419 544 49 50 51 52 53 54 55 56 57 58 CO 4 4 46 47 48 49 50 4 5 546 5 5 Instructions Questions Data & Template AutoSave OFF Home Insert Formulas Review B9 Assignment1(3) (1) Draw Page Layout Data View Tell me x fx 1) What is forecast for period 51 (March of Year 5) when Holt-Winter's method is used? D Assignment 1 F G H K M N 1 2 -3 4 Please see the data in the next tab ("Data & Template"). For this data, please implement a) Holt-Winter's forecasting method (please use the given values for alpha, beta and gamma - do not change them), and b) the three-perlod moving average forecasting method. Please answer the following questions: 1) What is Topcast for period 51 (March of Year 5) when Holt-Winter's method is used? Answers units 2) What is forecast for period 51 (March of Year 5) when the three perlod movine average method is used? Answer: units 15 16 17 3) Which of these forecasts (see 1) and 2)) do you consider to be the better forecast for period 517 Please explain and justify your answer (-30 70 words) Answer: 19 20 21 22 24 25 26 28 29 31 33 34 Instructions & Questions Data & Template A B D H M Holt-Winter's method Three-period moving average 1 Alpha Beta Gamma 0.200 0.100 0.200 MAD ME MAD ME Demand Base level Trend Seasonality (S) Forecast FE Abs FE Forecast FE Abs FE 3 Period Month Year 7 1 January 2 February 1 3 March 1 10 April 1 11 5 May 12 6 lung 1 13 7 July 1 14 8 August 1 9 September 1 16 10 October 1 17 11 November 1 18 12 December 1 19 13 January 2 20 February 2 21 15 March 2 22 16 April 2 21 17 May 2 24 18 June 2 25 19 July 2 26 20 AU 2 27 21 September 2 28 October 2 29 23 November 2 30 24 December 2 31 25 January 32 26 February 3 1 27 March Instructions to 99 139 104 142 125 165 140 137 166 166 221 191 164 203 281 243 271 279 320 227 285 323 284 286 + 287 319 279 Data & Template Home Insert Draw Page Layout Formulas Data Review View Tell me 07 . H M Three period moving average Holt-Winter's method 1 2 3 4 Alpha Beta Gamma 0.200 0.100 0.200 MAD ME MAD ME 5 6 Period Year Base level (E) Trend (T) Seasonality (5) Forecast FE Abs FE Forecast FE Abs FE 33 34 35 36 37 27 28 29 30 31 Demand 3 279 3 353 3 329 3 299 3 409 3 3 261 3 409 3 299 3 340 4 382 4 307 4 39 40 33 34 14 Month March April May June July August September October November December January February March April May June July August September October November December January February March 36 32 38 39 40 41 42 40 460 4 4 4 4 4 44 331 426 476 365 502 515 419 544 49 50 51 52 53 54 55 56 57 58 CO 4 4 46 47 48 49 50 4 5 546 5 5 Instructions Questions Data & Template AutoSave OFF Home Insert Formulas Review B9 Assignment1(3) (1) Draw Page Layout Data View Tell me x fx 1) What is forecast for period 51 (March of Year 5) when Holt-Winter's method is used? D Assignment 1 F G H K M N 1 2 -3 4 Please see the data in the next tab ("Data & Template"). For this data, please implement a) Holt-Winter's forecasting method (please use the given values for alpha, beta and gamma - do not change them), and b) the three-perlod moving average forecasting method. Please answer the following questions: 1) What is Topcast for period 51 (March of Year 5) when Holt-Winter's method is used? Answers units 2) What is forecast for period 51 (March of Year 5) when the three perlod movine average method is used? Answer: units 15 16 17 3) Which of these forecasts (see 1) and 2)) do you consider to be the better forecast for period 517 Please explain and justify your answer (-30 70 words) Answer: 19 20 21 22 24 25 26 28 29 31 33 34 Instructions & Questions Data & Template