Use the table provided below showing rooms available, rooms sold and rooms revenue for 7 properties (subject hotel + comp set) for one month to compute occupancy index for the subject hotel. Rooms Available (Supply) Rooms Sold (Demand) Revenue The subject hotel 10'000 7'000 700'000 Hotel A 9'000 3'000 400'000 Hotel B 9'000 8'000 700'000 Hotel C 10'000 7'000 700'000 Hotel D 7'000 5'000 500'000 Hotel E 11'000 8'000 700'000 Hotel F 8'000 4'000 400'000

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...
icon
Related questions
Question
Use the table provided below showing rooms available, rooms sold and rooms revenue for 7 properties (subject hotel + comp set) for one month to compute occupancy index for the subject
hotel.
Rooms Available (Supply)
Rooms Sold (Demand)
Revenue
The subject hotel
10'000
7'000
700'000
Hotel A
9'000
3'000
400'000
Hotel B
9'000
8'000
700'000
Hotel C
10'000
7'000
700'000
Hotel D
000י7
5'000
500'000
Hotel E
11'000
8'000
700'000
Hotel F
8'000
4'000
400'000
Transcribed Image Text:Use the table provided below showing rooms available, rooms sold and rooms revenue for 7 properties (subject hotel + comp set) for one month to compute occupancy index for the subject hotel. Rooms Available (Supply) Rooms Sold (Demand) Revenue The subject hotel 10'000 7'000 700'000 Hotel A 9'000 3'000 400'000 Hotel B 9'000 8'000 700'000 Hotel C 10'000 7'000 700'000 Hotel D 000י7 5'000 500'000 Hotel E 11'000 8'000 700'000 Hotel F 8'000 4'000 400'000
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer