Question: Check my work 5 Problem 3-28 (Algo) 15 points The manager of a travel agency has been using a seasonally adjusted forecast to predict demand

Check my work 5 Problem 3-28 (Algo) 15 points TheCheck my work 5 Problem 3-28 (Algo) 15 points TheCheck my work 5 Problem 3-28 (Algo) 15 points The

Check my work 5 Problem 3-28 (Algo) 15 points The manager of a travel agency has been using a seasonally adjusted forecast to predict demand for packaged tours. The actual and predicted values are as follows: eBook GO Hint Period Demand Predicted 1 137 113 2 197 200 3 157 150 4 92 102 5 87 80 6 132 135 7 127 128 8 128 124 9 93 109 10 148 150 11 103 94 12 88 80 13 123 140 14 133 128 References Click here for the Excel Data File a. Compute MAD for the fifth period, then update it period by period using exponential smoothing with a =.05. (Round your intermediate calculations and final answers to 3 decimal places.) MADt t Period 1 2 3 4 5 10.200 6 10 nnnl 5 6 10.000 7 9.900 10.050 8 9 15 points 10.650 9.950 10 11 12 10.300 10.250 10.700 13 eBook 14 10.1001 Hint References b. Compute a tracking signal for periods 5 through 14 using the initial and updated MADs. (Negative values should be indicated by a minus sign. Round your intermediate calculations and final answers to 3 decimal places.) t Period Tracking Signal 1 2 3 4 5 6 7 8 9 10 11 2

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!