Question
You are hired by a Danish distributor of consumer goods, Dicg, to improve their forecasting capabilities. You are tasked with coming up with quarterly forecasts
You are hired by a Danish distributor of consumer goods, Dicg, to improve their forecasting capabilities. You are tasked with coming up with quarterly forecasts for an item that appears to have level, seasonality, and trend. While the company does have an existing Holt-Winter forecasting model, no one knows what the parameters (Alpha, Beta, or Gamma) are.
You do have some information. For example, you know that historically, the demand in each quarter follows this distribution:- Q1 (January through March) = 60% of average quarterly demand- Q2 (April through June) = 80% of average quarterly demand- Q3 (July through September) = 140% of average quarterly demand- Q4 (October through December) = 120% of average quarterly demand.You just ran the forecast at the end of September (end of 2014Q3) and you have the following estimates:
For level:a^2014Q3= 1042 units
For trend:b^2014Q3= 41.7 units per quarter
PART 1
What is your forecast for demand for 2014Q4? In other words, what isx^2014Q3,2014Q4?
PART 2
Suppose the actual demand in 2014Q4 is 1050 units. What is the lowest possible value for your estimate for level,a^2014Q4?
PART 3
The model was run at the end of 2014Q4. It provided you with the most recent estimates of each pattern. The estimate for level,a^2014Q4was 1067.8. What is the value of alpha? Your answer should be to two decimal places.
PART 4
The model was run at the end of 2014Q4. The estimate for trend,b^2014Q4was found to be 39.6. What is value of beta? Your answer should be to two decimal places.
PART 5
The model was run at the end of 2014Q4. The estimate for seasonality,F^2014Q4was found to be 1.189, before any normalization was done. What is the value of gamma? Your answer should be to two decimal places.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started