Math Problem Statement
Actual demand for a product for the past three months was
Three months ago
Two months ago
Last month
400 units
350 units
325 units
Final PDF to printer
84 OPERATIONS AND SUPPLY CHAIN MANAGEMENT
jac98375_ch03_046-093.indd 84 09/17/21 12:53 PM
a. Using a simple three-month moving average, make a forecast for this month.
b. If 300 units were actually demanded this month, what would your forecast be
for next month?
c. Using simple exponential smoothing, what would your forecast be for this
month if the exponentially smoothed forecast for three months ago was 450
units and the smoothing constant was 0.20?
Solution
Let's solve each part of this problem step-by-step.
Part (a): Three-Month Moving Average Forecast for This Month
To find a forecast using a simple three-month moving average, we average the demand of the last three months.
- Three months ago: 400 units
- Two months ago: 350 units
- Last month: 325 units
The moving average forecast for this month is calculated as:
Part (b): Forecast for Next Month with Actual Demand of 300 Units This Month
If the actual demand for this month turns out to be 300 units, we can use it to create a new three-month moving average for the forecast for next month.
- Two months ago: 350 units
- Last month: 325 units
- This month (actual): 300 units
So, the three-month moving average forecast for next month would be:
Part (c): Forecast for This Month Using Simple Exponential Smoothing
For exponential smoothing, the formula is:
Where:
- (smoothing constant),
- Actual demand last month = 325 units,
- Forecast three months ago = 450 units (given).
We will calculate the forecast for each month step-by-step until this month.
Step 1: Forecast Two Months Ago
Step 2: Forecast Last Month
Step 3: Forecast This Month
Summary of Answers
- Part (a): Forecast for this month using a three-month moving average = 358.33 units.
- Part (b): Forecast for next month (if actual demand this month is 300) = 325 units.
- Part (c): Forecast for this month using exponential smoothing = 402.6 units.
Would you like a deeper explanation for any part of this solution?
Related Questions to Explore
- How would the forecast change if the smoothing constant was 0.3 instead of 0.2?
- What would be the effect of increasing the period in the moving average to four months?
- How does exponential smoothing differ from weighted moving average forecasting?
- What are the benefits of using a moving average forecast versus exponential smoothing?
- Can we adjust the smoothing constant dynamically for more responsive forecasting?
Tip
Using a higher smoothing constant () in exponential smoothing will make the forecast more responsive to recent demand changes but can lead to more variability.
Ask a new question for Free
By Image
Drop file here or Click Here to upload
Math Problem Analysis
Mathematical Concepts
Time Series Forecasting
Moving Average
Exponential Smoothing
Formulas
Simple Moving Average: (Demand of last three months) / 3
Exponential Smoothing: Forecast = α × Actual demand last month + (1 - α) × Forecast last month
Theorems
-
Suitable Grade Level
Grades 10-12
Related Recommendation
Forecasting Demand Using Three-Quarter Moving Average
Forecasting October Demand Using Moving Average, Exponential Smoothing, and Linear Regression
Three-Quarter Moving Average Forecast for Quarterly Demand
Three-Quarter Moving Average Forecast for Demand
Forecasting Sales Demand using Three-Month and Five-Month Moving Averages