I only need help with knowing what values to put in the three boxes for goal seek to calculate the alpha box on the excel sheet.

Thanks

Operations Management Forecasting A company has been using exponential smoothing with an alpha of 0.1 to forecast weekly truck sales. It would like to evaluate if an alpha of 0.3 can provide greater accuracy. Period Actual Demand 57 62 1 2 3 4 5 58 60 60 56 6 (1) Calculate the forecasted demand of Period 7 using alpha of 0.1 and 0.3. In your Excel file, create two separate sheets, one for a = 10% and one for a = 30%. (2) Comparing the error measures MAD and MSE, determine which alpha value (0.1 or 0.3) provides a more accurate forecasting process. Explain your analysis in one of the sheets you created in Part (1) of this question. (3) Identify an alpha that provides an acceptable tracking signal in ljeriod 5. TMS EXEI UM Site Support K M N Tracking Signal Cum Error Cum Abs Mad Track Signal (Cum Error/MAD) 5 6 9 12 11 5 2.5 2 6 2 3 9 2.25 4 12 2.4 51 13 2.166667 5.076923 Menu Dimals Calculations Settings 65 f A 9 D E F G H 1 Forecasting Exponential smoothing 2 Enter alpha (between 0 and 1), enter the past demands in the shaded column then entera 3 starting forecant ir the starting forecast is not in the first perioden delete the cor analysis 4 5 Alpha 6 Data Forecasts and Error Analysis 7 Period Demand Forecast Error Absolute Squared Abs Pct Err Period 1 57 57 0 0 00.00 9 Period 2 62 57 5 5 25 08.06% 10 Period 3 58 57 1 1 1 0172 11 Period 4 60 57 3 3 9 05.00% 12 Period 5 00 57 3 3 9 05.00% 13 Period 6 50 52 1 1 0.0178921 14 Total 11 13 45 21.57% 15 Average 1.833333 2.166667 7.5 03.60% 16 Blas MAD MSE MAPE 17 SE 3.354102 18 Next period 57 19 Goal Scok 2 20 Suci + 21 22 Toy 23 Bly changing 24 OK 25 Cance Plot Area 26 27 28 29 30 Forecasting + Value X $ 8 9 55 1 2 3 5 4