expecting to increase its annual sales for BMW- X5 in year 2021 by 10 % compared to year 2020 annual sales. Find the quarterly forecast for year 2021, given the following data : (You need to consider the Quarterly seasonal effect) Quarter Actual Car Sales (2019) Actual Car Sales (2020) Quarter 1 80000 88000 Quarter 2 100000 110000 Quarter 3 120000 132000 Quarter 4 90000 99000
expecting to increase its annual sales for BMW- X5 in year 2021 by 10 % compared to year 2020 annual sales. Find the quarterly forecast for year 2021, given the following data : (You need to consider the Quarterly seasonal effect) Quarter Actual Car Sales (2019) Actual Car Sales (2020) Quarter 1 80000 88000 Quarter 2 100000 110000 Quarter 3 120000 132000 Quarter 4 90000 99000
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter13: Regression And Forecasting Models
Section13.7: Exponential Smoothing Models
Problem 28P: The file P13_28.xlsx contains monthly retail sales of U.S. liquor stores. a. Is seasonality present...
Related questions
Question
You work for BMW as a planner. BMW is expecting to increase its annual sales for BMW- X5 in year 2021 by 10 % compared to year 2020 annual sales. Find the quarterly
(You need to consider the Quarterly seasonal effect)
Quarter |
Actual Car Sales (2019) |
Actual Car Sales (2020) |
---|---|---|
Quarter 1 |
80000 |
88000 |
Quarter 2 |
100000 |
110000 |
Quarter 3 |
120000 |
132000 |
Quarter 4 |
90000 |
99000 |
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing