Question: Problem 1 A dry cleaner uses exponential smoothing to forecast equipment usage at its main plant. August usage was forecasted to be 85% capacity; actual

Problem 1

A dry cleaner uses exponential smoothing to forecast equipment usage at its main plant. August usage was forecasted to be 85% capacity; actual usage was 89%. A smoothing constant of .12 is used.

Prepare a forecast for September.

Assuming actual September usage of 94%, prepare a forecast for October.

The concept used to solve the problem Exponential Smoothing

Definition: Each new forecast is based on the previous forecast plus a percentage of the difference between that forecast and the actual value of the series at that point.

Formula: Ft = Ft- 1 + (At 1 Ft-1)

F = Forecast

A = Actual

Ft = Forecast for period t

Ft 1 = Forecast for the previous period (i.e., period t 1)

The = Smoothing constant (percentage)

At 1 = Actual demand or sales for the previous period

Excel Example:

Smoothing Constant

0.12

Month

Actual

Forecast

August

89%

85%

a.

September

b.

October

September forecast =August forecast+ *(Actual August demand-August forecast)

September forecast =

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!