how do you get the alpha in this problem by using goal seek

05 K M N Tracking Signal Cum Errorcum Abs Mad Track Signal (Cum rer/ 12 A C D F 6 H Forecasting Exponential smoothing Enteri bolwen and 1), enter the past made the shaded contents a at forecast the starting forecasts on the first period then to the entorn for a row above the starting forecast 4 5 Alpha 6 Data Forecasts and Error Analysis 7 Period Demand Forecast Error Absolute Squared Abs Peter 8 Week 1 46: 461 0 0 00.00% 9 Week 2 450 461 -11 11 121 02.44% 10 Week 463 461 2 2 4 00.43% 11 Week 4 458 461 . 3 9 00.66% 12 Week 5 476 461 15 15 225 03.15% 13 Week 6 492 461 31 31 961 06.30 14 Week 7 482 461 21 21 441 04.36% 15 Week 8 491 461 30 30 900 06.11% 16 Weeks 488 461 27 27 729 05:53 17 Week 10 488 461 27 27 729 0.0553279 18 Total 139 1671 $115 34.520 19 Average 13.9 16.7 411.9 03.45% 20 Blas MAD MSE MAPE 21 SE 22.67086 22 Next period 461 Goal Seek 2 X 23 24 Set cell + 25 To yale 26 by changing cell 1 27 28 OK Cancel 29 ESPEREER 35 207692 16 4 6.2 A 1871 62 10.333333.290323 831 11.55714 4.638554 113 14.1256.012699 140 15.55556 22 167 16.2 2153 112 139 SE 500 490 480 470 55 Value 460 450 440 430 OPM 352 [Operations Management) Chapter 3: Acadian Bakers is a small sweets bakery in Houston, Texas. One of its products is a croissant Acadian bakes the croissants from frozen croissants that it buys. For the sake of quality, the company don't want to store its frozen goods for more than one week. For orders of more than 576 cases, the delivery is free (saving $15 per order). A case contains 144 frozen croissants. Acadian has collected its total weekly sales for croissants (in cases) for the last 10 weeks. Week Sales 461 450 463 458 476 492 7 8 491 9 488 1 2 3 4 5 6 482 10 488 1. Management believes that the sales of croissants are increasing. Under a linear trend projection, determine when Acadian can take advantage of the quantity discount. 2. Find an a-value for which a simple exponential smoothing is considered in-control at the end of Week 10 with TSI 4