How is the Year 3 forecast calculated from the Year 2 values?
The Year 3 forecast is calculated by applying the exponential smoothing formula to the Year 2 actual demand and the Year 2 forecast. The actual demand of 365 is weighted by , and the previous forecast of 310 is weighted by , yielding a new forecast of 332.
Conditions
- The smoothing constant is 0.4.
- The actual demand for Year 2 () is 365.
- The forecast for Year 2 () is 310.
Reasoning, step by step
- Identify the Year 2 actual demand, .
- Identify the Year 2 forecast, .
- Substitute these values into the formula: .
- Compute the products: .
- Record 332 as the forecast for Year 3.
Example
The instructor states the next calculation uses previous demand 365 and previous forecast 310. The handwritten expression reads , and the calculator shows the result is 332, which is written in the Forecast Demand column for Year 3.
Common misconceptions
- Using the Year 1 actual demand instead of the Year 2 actual demand for the Year 3 calculation.
- Forgetting to use the newly calculated Year 2 forecast as the input for the Year 3 calculation.
Watch the explanation
Explore next
Answers are generated from source material and independently checked. Consult the original video or creator if something is unclear.