Question

Additional Algo 15-11 Forecasting with Seasonality Demand history for the past three years is shown below, along with the seasonal indices for each quarter. Year Quarter Demand Seasonal Index Year 1 Q1 255 0.75 Q2 298 0.862 Q3 429 1.323 Q4 373 1.086 Year 2 Q1 273 0.75 Q2 276 0.862 Q3 474 1.323 Q4 396 1.086 Year 3 Q1 245 0.75 Q2 292 0.862 Q3 460 1.323 Q4 350 1.086 Do not round intermediate calculations. Round your answer to the nearest whole number. Use exponential smoothing with alpha (?) = 0.3 and an initial forecast of 343 along with seasonality to calculate the Q1, 2020 forecast.

          Additional Algo 15-11 Forecasting with Seasonality

Demand history for the past three years is shown below, along with the seasonal indices for each quarter.

Year Quarter Demand Seasonal Index
Year 1 Q1 255 0.75
Q2 298 0.862
Q3 429 1.323
Q4 373 1.086
Year 2 Q1 273 0.75
Q2 276 0.862
Q3 474 1.323
Q4 396 1.086
Year 3 Q1 245 0.75
Q2 292 0.862
Q3 460 1.323
Q4 350 1.086

Do not round intermediate calculations. Round your answer to the nearest whole number.

Use exponential smoothing with alpha (?) = 0.3 and an initial forecast of 343 along with seasonality to calculate the Q1, 2020 forecast.

Show more…

Additional Algo 15-11 Forecasting with Seasonality

Demand history for the past three years is shown below, along with the seasonal indices for each quarter.

Year Quarter Demand Seasonal Index
Year 1 Q1 255 0.75
Q2 298 0.862
Q3 429 1.323
Q4 373 1.086
Year 2 Q1 273 0.75
Q2 276 0.862
Q3 474 1.323
Q4 396 1.086
Year 3 Q1 245 0.75
Q2 292 0.862
Q3 460 1.323
Q4 350 1.086

Do not round intermediate calculations. Round your answer to the nearest whole number.

Use exponential smoothing with alpha (?) = 0.3 and an initial forecast of 343 along with seasonality to calculate the Q1, 2020 forecast.

Added by Meagan G.

Elementary Statistics a Step by Step Approach

Allan G. Bluman 9th Edition

Instant Answer

Solved by Expert Lucas Finney

02/24/2023

Step 1

First, we need to calculate the deseasonalized demand for each quarter. To do this, we will divide the actual demand by the seasonal index for each quarter. Deseasonalized Demand: Year 1: Q1: 255 / 0.75 = 340 Q2: 298 / 0.862 = 345.47 Q3: 429 / 1.323 = 324.27 Q4: Show more…

Show all steps

lock

Thanks for your feedback!

Forecasting with Seasonality Demand history for the past three years is shown below, along with the seasonal indices for each quarter. Year 1: Q1 (Demand 255, Index 0.75), Q2 (Demand 298, Index 0.862), Q3 (Demand 429, Index 1.323), Q4 (Demand 373, Index 1.086) Year 2: Q1 (Demand 273, Index 0.75), Q2 (Demand 276, Index 0.862), Q3 (Demand 474, Index 1.323), Q4 (Demand 396, Index 1.086) Year 3: Q1 (Demand 245, Index 0.75), Q2 (Demand 292, Index 0.862), Q3 (Demand 460, Index 1.323), Q4 (Demand 350, Index 1.086) Do not round intermediate calculations. Round your answer to the nearest whole number. Use exponential smoothing with alpha (̑̑) = 0.3 and an initial forecast of 343 along with seasonality to calculate the Q1, 2020 forecast:

Play audio

Feedback

Powered by NumerAI

Lucas Finney and 85 other subject Intro Stats / AP Statistics educators are ready to help you.

Ask a new question

Labs

Want to see this concept in action?

NEW

Explore this concept interactively to see how it behaves as you change inputs.

View Labs

Key Concepts

Recommended Videos

Recommended Textbooks

Transcript

Ace is your personal tutor. It breaks down any question with clear steps so you can learn.

Start Using Ace

Continue solving this problem

Create a free account to:

View full step-by-step solution
Ask follow-up questions with Ace AI
Save progress and study later