Question: Find the expected demand for period No.7 By using Linear Trend Equation. Month X Demand (y) xy x2 1 120 2 135 3 140 4
Find the expected demand for period No.7
By using Linear Trend Equation.
| Month | X | Demand (y) | xy | x2 |
| 1 |
| 120 |
|
|
| 2 |
| 135 |
|
|
| 3 |
| 140 |
|
|
| 4 |
| 147 |
|
|
| 5 |
| 155 |
|
|
| 6 |
| 160 |
|
|
| 7 |
|
|
|
|
Find Forecasting Error by using Tracking Signal
| Period | Actual Demand | Forecasted Demand | E | lEl |
| 1 | 130 | 120 |
|
|
| 2 | 125 | 120 |
|
|
| 3 | 100 | 120 |
|
|
| 4 | 155 | 120 |
|
|
| 5 | 95 | 120 |
|
|
| 6 | 117 | 120 |
|
|
| 7 | 162 | 120 |
|
|
| 8 | 122 | 120 |
|
|
| 9 | 131 | 120 |
|
|
| 10 | 107 | 120 |
|
|
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
