Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You are hired by a Spanish distributor of consumer goods, Dicgu, to improve their forecasting capabilities. You are tasked with coming up with quarterly forecasts

You are hired by a Spanish distributor of consumer goods, Dicgu, to improve their forecasting capabilities. You are tasked with coming up with quarterly forecasts for item LHU72 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: = 1051 units For trend: = 41.6 units per quarter PART 1 What is your forecast for demand for 2014Q4? In other words, what is ? Enter your answer rounded to two decimal places. (For example, if your answer is 12.3456, you should enter 12.35 in the box below.) Part 2 Suppose the actual demand for item LHU72 in 2014Q4 is 1050 units. What is the lowest possible value for your estimate for level, ? Enter your answer rounded to two decimal places. (For example, if your answer is 12.3456, you should enter 12.35 in the box below.) 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, was 1067.8. What is the value of alpha? Enter your answer rounded to two decimal places. (For example, if your answer is 12.3456, you should enter 12.35 in the box below.) Part 4 The model was run at the end of 2014Q4. The estimate for trend, was found to be 39.6. What is value of beta? Enter your answer rounded to two decimal places. (For example, if your answer is 12.3456, you should enter 12.35 in the box below.) Part 5 The model was run at the end of 2014Q4. The estimate for seasonality, was found to be 1.189, before any normalization was done. What is the value of gamma? Enter your answer rounded to two decimal places. (For example, if your answer is 12.3456, you should enter 12.35 in the box below.) 

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Calculus Early Transcendentals

Authors: William L. Briggs, Lyle Cochran, Bernard Gillett

2nd edition

321954428, 321954424, 978-0321947345

More Books

Students also viewed these Mathematics questions

Question

What does it mean when the explanatory variables are collinear?

Answered: 1 week ago