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

Check my work 3 3 Problem 3-28 (Algo) 5 pointsCheck my work 3 3 Problem 3-28 (Algo) 5 pointsCheck my work 3 3 Problem 3-28 (Algo) 5 points

Check my work 3 3 Problem 3-28 (Algo) 5 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 Period Demand Predicted 1 131 113 2 191 200 3 151 150 150 4 86 192 5 81 80 126 135 121 128 134 124 g 99 SAN 189 10 154 150 11 109 94 94 80 13 129 140 14 139 128 Hint 56789_12BE Print References Click here for the Excel Data File a. Compute MAD for the fifth period, then update it perlod by period using exponential smoothing with a - .05. (Round your Intermediate calculations and final answers to 3 decimal places.) MADE t Period Demand 1 129 2 194 3 156 4 91 5 85 9.000 onal Check my work 3 12 13 14 94 129 139 80 140 128 Click here for the Excel Data File 5 points a. Compute MAD for the fifth period, then update it perlod by period using exponential smoothing with a = 05. (Round your Intermediate calculations and final answers to 3 decimal places.) ebook MAD t A Period Demand 1 129 2 194 3 156 Hint 4 Prirt 5 91 . 85 . 132 9.000 6 9.000 5.500 7 128 References 8 126 9 95 149 98 10 11 12 13 14 815 137 134 b. Compute a tracking signal for periods 5 through 14 using the initial and updated MADs. (Negative values should be indicated by a Homework #6 i Savad Help Save & Exit Submit Check my work 3 149 10 11 98 12 85 137 5 points 13 14 134 eBook 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.) Hint t t A A Period Demand 1 129 Tracking Signal Print 194 2 3 References 156 91 4 5 2 6 7 00 85 132 126 120 120 126 DE 95 8 9 10 149 11 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!