Chapter 7 - Chapter 7 Demand Forecasting in a Supply Chain...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Exercise Solutions : Problem 7-1: We utilize a static model with level, trend, and seasonality components to evaluate the forecasts for year 6. Initially, we deseasonalize the demand and utilize regression in estimating the trend and level components. We then estimate the seasonal factors for each period and evaluate forecasts. EXCEL Worksheet 7-1 provides the solution to this problem. The model utilized for forecasting is: l t l t S T l t L F + + + + = ] ) ( [ The deseasonalized regression model is: t D _ = 5997.261 + 70.245 t The seasonal indices for each of the twelve months are: Month S.I JAN 0.427 FEB 0.475 MAR 0.463 APR 0.398 MAY 0.621 JUN 0.834 JUL 0.853 AUG 1.151 SEP 1.733 OCT 1.778 NOV 2.124 DEC 1.095 For example, the forecast for January of Year 6 is obtained by the following calculation: F 61 = [5997.261 + (61) * 70.245] * 0.4266 = 4386 The quality of the forecasting method is quite good given that the forecast errors are not too high. Problem 7-2:
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 09/17/2009 for the course INDUSTRIAL 0906547 taught by Professor Khaldontahboub during the Three '09 term at ADFA.

Page1 / 3

Chapter 7 - Chapter 7 Demand Forecasting in a Supply Chain...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online