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