Question: Please help with all alpha bias sum errors and sum absolute deviations! THANK YOU! A grocery store sells the following number of frozen turkeys during


Please help with all alpha bias sum errors and sum absolute deviations! THANK YOU!
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 Click here for the Excel Data File a. Using exponential smoothing, prepare a forecast of sales for each day, starting with F1= 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.) Day Turkeys Sold 80 53 Monday Tuesday Wednesday Thursday Friday Saturday Totals 65 Answer is complete and correct. Forecast Error (t) MAD (t) Tracking (t) Signal 85.00 -5.00 1.00 -5.00 84.00 -31.00 7.00 -5.14 77.80 -12.80 8.16 -5.98 75.24 -32.24 12.98 -6.25 68.79 16.21 13.62 -4.76 72.03 28.97 16.69 -2.15 462.86 -35.86 59.45 -29.28 43 85 101 427 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 Answer is not complete. Bias sum errors Sum absolute deviations -51.55 19.60 20.20 -14.96 X 20.30 -2.98 20.04Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
