| period,t | Demand | Ft | FE(Demand -Ft) | |FE| | RSFE | MAD(|FE|/t) | TRACKING SIGNAL(RSFE/MAD) |
| 1 | 15 | 14 | 1 | 1 | 1 | 1 | 1 |
| 2 | 20 | 18 | 2 | 2 | 3 | 1 | 3 |
| 3 | 20 | 22 | -2 | 2 | 1 | 0.666666667 | 1.5 |
| 4 | 30 | 26 | 4 | 4 | 5 | 1 | 5 |
| 5 | 30 | 30 | 0 | 0 | 5 | 0 | 0 |
| 6 | 40 | 34 | 6 | 6 | 11 | 1 | 11 |
| 7 | 40 | 38 | 2 | 2 | 13 | 0.285714286 | 45.5 |
| 8 | 45 | 42 | 3 | 3 | 16 | 0.375 | 42.667 |
=================================================
| period,t |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| TRACKING SIGNAL(RSFE/MAD) |
| 1 |
| 3 |
| 1.5 |
| 5 |
| 0 |
| 11 |
| 45.5 |
| 42.667 |
Problem 3-33 A manager uses this equation to predict demand for landscaping services: F10- 4t Over...
A manager uses this equation to predict demand for landscaping services: Ft = 7 + 5t. Over the past eight periods, demand has been as follows: Period, t: 1 2 3 4 5 6 7 8 Demand: 13 18 18 28 28 33 38 43 Compute the tracking signals for Periods 1-8. (Negative values should be indicated by a minus sign. Round your intermediate calculations and final answers to 3 decimal places.) Period, t Tracking signal : 1 2 3...
Check my work Problem 3-34 points A manager uses a trend equation plus quarterly relatives to predict demand. Quarter relatives are SR = 0.9, SR2 = 0.95, SR3 = 1.05, and SR4 = 1.1. The trend equation is: Ft= 10 + 3t. Over the past nine quarters, demand has been as follows: eBook Print Period, t: Demand: 1 2 3 4 5 6 7 8 9 15 17 19 23 25 27 32 36 41 References Compute the MAD and...
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: Period Demand Predicted 1 123 113 2 183 200 3 143 150 4 78 102 5 73 80 6 118 135 7 113 128 8 142 124 9 107 109 10 162 150 11 117 94 12 102 80 13 137 140 14 147 128 a. Compute MAD for the fifth period, then...
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: Period Demand Predicted 1 138 113 2 198 200 3 158 150 4 93 102 5 88 80 6 133 135 7 128 128 8 127 124 9 92 109 10 147 150 11 102 94 12 87 80 13 122 140 14 132 128 a. Compute MAD for the fifth period,...
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: Period Demand Predicted 1 124 113 2 184 200 3 144 150 4 79 102 5 74 80 6 119 135 7 114 128 8 141 124 9 106 109 10 161 150 11 116 94 12 101 80 13 136 140 14 146 128 a) Compute MAD for the fifth period, then...