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 andPlease help with all alpha bias sum errors and

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.04

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!