I need complete and typed answerif you cannot provide complete answersdon't answer it

A grocery store sells the following number of frozen turkeys during the week prior to Thanksgiving: Day Monday Tuesday Wednesday Thursday Friday Saturday Turkeys Sold 80 53 65 43 85 101 picture Click here for the Excel Data File FILE NAME: CH10 P11.xlsx CHAPTER 10, PROBLEM 11 OPERATIONS MANAGEMENT by ROGER SCHROEDER et al. THIS WORKSHEET COMPUTES FIRST ORDER EXPONENTIAL FORECASTS. THE WORKSHEET REQUIRES THE USER TO INPUT VALUES, AS WELL AS SOME FORMULAS. INPUT VALUES IN THE HIGHLIGHTED CELLS. PRESS "CTRL" AND "P" SIMULTANEOUSLY AND CHOOSE "OK" TO OBTAIN A PRINTED OUTPUT. PRESS THE "PAGE DOWN" KEY TO BEGIN. ***** NAME: SECTION: CHAPTER 10, PROBLEM 11 04-Mar-21 ALPHA- WNIA TRACKING SIGNAL DEMAND FORECAST ERROR MAD MONDAY #N/A TUESDAY #N/A WEDNESDAY #N/A THURSDAY #N/A FRIDAY #N/A SATURDAY #N/A VALUE WN/A FORMULA #N/A FORMULA #N/A FORMULA #N/A FORMULA #N/A FORMULA #N/A WN/A #N/A WN/A #N/A #N/A #N/A FORMULA FORMULA FORMULA FORMULA FORMULA FORMULA TOTALS #N/A 0.00 #N/A #N/A 0.00 a. Using exponential smoothing, prepare a forecast of sales for each day, starting with Fy=85 and a = 0.2. Compute the MAD and the tracking signal in each period. Use MADO = 0. (Round all answers to 2 decimal places.) Error () MAD (t) Tracking Signal Day Monday Tuesday Wednesday Thursday Friday Saturday Totals Turkeys Sold Forecast (t) 80 85.00 53 84.00 65 77.80 43 75.24 85 68.79 101 72.031 427 462 86 0.00 -31.00 -12.80 -32.24 16.21 28.97 -30.86 20.20 -1.53 b. On the basis of the criteria given in the text, are the MAD and tracking signal within tolerances? Yes No c. Recompute part a using a = 0.1, 0.3, and 0.4. (Round all answers to 2 decimal places.) Alpha a = 0.1 a=0.2 a = 0.3 a=0.4 Blas sum errors -51.55 -30.87 - 14.96 -2.98 Sum absolute deviations 19.60 20.20 20.30 20.04 Which value of a provides the best forecast? 0.1 0.2 0.3 0.4