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.

  1. Three months ago: 400 units
  2. Two months ago: 350 units
  3. Last month: 325 units

The moving average forecast for this month is calculated as:

Forecast for this month=400+350+3253=10753=358.33 units\text{Forecast for this month} = \frac{400 + 350 + 325}{3} = \frac{1075}{3} = 358.33 \text{ units}


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.

  1. Two months ago: 350 units
  2. Last month: 325 units
  3. This month (actual): 300 units

So, the three-month moving average forecast for next month would be:

Forecast for next month=350+325+3003=9753=325 units\text{Forecast for next month} = \frac{350 + 325 + 300}{3} = \frac{975}{3} = 325 \text{ units}


Part (c): Forecast for This Month Using Simple Exponential Smoothing

For exponential smoothing, the formula is:

Forecastthis month=α×Actual demandlast month+(1α)×Forecastlast month\text{Forecast}_{\text{this month}} = \alpha \times \text{Actual demand}_{\text{last month}} + (1 - \alpha) \times \text{Forecast}_{\text{last month}}

Where:

  • α=0.20\alpha = 0.20 (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

Forecasttwo months ago=0.20×400+0.80×450=80+360=440 units\text{Forecast}_{\text{two months ago}} = 0.20 \times 400 + 0.80 \times 450 = 80 + 360 = 440 \text{ units}

Step 2: Forecast Last Month

Forecastlast month=0.20×350+0.80×440=70+352=422 units\text{Forecast}_{\text{last month}} = 0.20 \times 350 + 0.80 \times 440 = 70 + 352 = 422 \text{ units}

Step 3: Forecast This Month

Forecastthis month=0.20×325+0.80×422=65+337.6=402.6 units\text{Forecast}_{\text{this month}} = 0.20 \times 325 + 0.80 \times 422 = 65 + 337.6 = 402.6 \text{ units}


Summary of Answers

  1. Part (a): Forecast for this month using a three-month moving average = 358.33 units.
  2. Part (b): Forecast for next month (if actual demand this month is 300) = 325 units.
  3. 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

  1. How would the forecast change if the smoothing constant was 0.3 instead of 0.2?
  2. What would be the effect of increasing the period in the moving average to four months?
  3. How does exponential smoothing differ from weighted moving average forecasting?
  4. What are the benefits of using a moving average forecast versus exponential smoothing?
  5. Can we adjust the smoothing constant dynamically for more responsive forecasting?

Tip

Using a higher smoothing constant (α\alpha) 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