Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Badrutt's Palace Hotel St. Moritz which is one of the best Alpine hotels in Switzerland has provided you with their quarterly bookings data over

The Badrutt's Palace Hotel St. Moritz which is one of the best Alpine hotels in Switzerland has provided you with their quarterly bookings data over the last 6 years as follows:

Year

Quarter-1

(Demand in units)

Quarter-2

(Demand in units)

Quarter-3

(Demand in units)

Quarter-4

(Demand in units)

2017 45,000 22,000 64,000 33,000
2018 48,000 27,000 74,000 41,000
2019 52,000 32,000 83,000 46,000
2020 57,000 35,000 94,000 52,000
2021 61,000 42,000 104,000 56,000
2022 67,000 49,000 120,000 61,000

Required:

  1. Calculate the seasonal indices for each season using multiplicative index (3 Marks)

  1. Forecast the demand for each season of the year 2023 given that the annual demand forecast is 324,000 units. (2 Marks)

  1. Deseasonalize the actual demand data (2017-2022) above using the seasonal indices obtained in (a) above. (2 Marks)

  1. Generate OLS equation using the Deseasonalized data in (iii) above (in thousand units)

(3 Marks)

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