Question: Please Help me find the tracking signals and explain it step by step not with the excel sheet. 3 The manager of a travel agency

Please Help me find the tracking signals and explain it step by step not with the excel sheet.

Please Help me find the tracking signals andPlease Help me find the tracking signals andPlease Help me find the tracking signals and

3 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: 5 points Period Demand Predicted 1 131 113 2 191 200 3 151 150 4 86 102 5 81 80 6 126 135 121 128 134 124 99 199 154 150 109 94 94 80 129 140 139 128 Naam 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.) Answer is complete and correct. MADI Period 1 1 A Demand 129 2 194 3 156 4 91 5 R5 annn 3 a. Compute MAD for the fifth period, then update it perlod by period using exponential smoothing with a Intermediate calculations and final answers to 3 decimal places.) .05. (Round your 5 points 1 Period 1 2 . 3 4 5 Answer is complete and correct. A A MADE Demand 420 129 194 . 156 . 91 85 9.000 132 9.000 126 8.900 126 8.955 95 9.007 149 8.757 9B 9.069 85 9.315 137 9.399 134 9.479 7 8 9 10 11 12 13 14 3 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.) 5 points Answer is not complete. t Period Domand Tracking Signal 1 129 2 194 156 3 4 91 5 15 00 132 132 125 120 426 126 (0.778) (1.777) 2.584 ? 8 9 95 10 11 149 98 85 12 13 14 137 134

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!