O'Reilly logo

Operations Management: An Integrated Approach, 5th Edition by Nada R. Sanders, R. Dan Reid

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Solved Problems

(See student companion site for Excel template.)

Problem 1

Given the following data, calculate forecasts for months 4, 5, 6, and 7 using a three-month moving average and an exponential smoothing forecast with an alpha of 0.3. Assume a forecast of 61 for month 3:

images

Before You Begin:

To use a three-period moving average, remember that you always have to compute the average of the latest three observations. As new data become available, drop off the oldest data. For the exponential smoothing part of this problem, before you begin make sure that you have the three pieces of information you need: the current period's forecast (61 for month 3), the current period's actual value (58), and a value for the smoothing coefficient (α = 0.3).

Solution

images

To compute the moving average forecasts:

images

To compute the exponential smoothing forecasts:

images

This can also be computed using a spreadsheet, as shown here.

images

Problem 2

True Beauty is a cosmetics company that uses exponential smoothing ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required