8. Talbot Publishing Companys production planning manager has provided the following historical sales data for its leading

Question:

8. Talbot Publishing Company’s production planning manager has provided the following historical sales data for its leading textbook on forecasting:

Year 4 5 6 7 Sales (in 1,000 units) 21 18 20 17 The firm is considering using a basic exponential smoothing model with ␣ 0.2 to forecast this item’s sales.

a. Use the sales average of 20,000 units through year 3 as the forecast for period 4. Prepare forecasts for years 5 through 7 as of the end of year 4.

b. Calculate the average error and MAD value for the three forecasts using the actual sales data provided. Estimate the standard deviation of the forecast errors using the calculated MAD.

c. Redo the forecasts and MAD calculations, updating the forecasts for years 6 and 7 at the end of years 5 and 6, respectively. What do you observe?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Manufacturing Planning And Control For Supply Chain Management

ISBN: 9780073377827

6th Edition

Authors: F. Robert Jacobs, William Berry, David Clay Whybark, Thomas Vollmann

Question Posted: