Hotel Room Pricing A hotel has 500 rooms. During a typical week in the holiday season, the hotel is busy on Monday, Tuesday, Wednesday, and Thursday nights, primarily with business people, but there is generally space available on Friday, Saturday, and Sunday nights. Hotel management provided the following demand estimates, as shown in Table 8.1: Assume linear demand functions over the range of all non-negative room rates and demands. Table 8.1: Demand Estimates Estimated Demand Room Rate Days (rooms/day) $160 Mon, Tue, Wed, Thur 500 Fri, Sat, Sun 200 $175 Mon, Tue, Wed, Thur 350 Fri, Sat, Sun 125
Hotel Room Pricing A hotel has 500 rooms. During a typical week in the holiday season, the hotel is busy on Monday, Tuesday, Wednesday, and Thursday nights, primarily with business people, but there is generally space available on Friday, Saturday, and Sunday nights. Hotel management provided the following demand estimates, as shown in Table 8.1: Assume linear demand functions over the range of all non-negative room rates and demands. Table 8.1: Demand Estimates Estimated Demand Room Rate Days (rooms/day) $160 Mon, Tue, Wed, Thur 500 Fri, Sat, Sun 200 $175 Mon, Tue, Wed, Thur 350 Fri, Sat, Sun 125
Managerial Economics: Applications, Strategies and Tactics (MindTap Course List)
14th Edition
ISBN:9781305506381
Author:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
Publisher:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
Chapter3: Demand Analysis
Section: Chapter Questions
Problem 9E
Related questions
Question
Based off the attached information, What is the revenue-maximizing room rate if the hotel posts only a single rate good for any day of the week? What weekly occupancy results?
Can you discuss how to set this up in Excel using Solver?
Transcribed Image Text:Hotel Room Pricing
A hotel has 500 rooms. During a typical week in the holiday season, the hotel is busy on
Monday, Tuesday, Wednesday, and Thursday nights, primarily with business people, but
there is generally space available on Friday, Saturday, and Sunday nights.
Hotel management provided the following demand estimates, as shown in Table 8.1:
Assume linear demand functions over the range of all non-negative room rates and
demands.
Table 8.1: Demand Estimates
Estimated Demand
Room Rate
Days
(rooms/day)
$160
Mon, Tue, Wed, Thur
500
Fri, Sat, Sun
200
$175
Mon, Tue, Wed, Thur
350
Fri, Sat, Sun
125
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
Managerial Economics: Applications, Strategies an…
Economics
ISBN:
9781305506381
Author:
James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
Publisher:
Cengage Learning
Microeconomics: Private and Public Choice (MindTa…
Economics
ISBN:
9781305506893
Author:
James D. Gwartney, Richard L. Stroup, Russell S. Sobel, David A. Macpherson
Publisher:
Cengage Learning
Managerial Economics: Applications, Strategies an…
Economics
ISBN:
9781305506381
Author:
James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
Publisher:
Cengage Learning
Microeconomics: Private and Public Choice (MindTa…
Economics
ISBN:
9781305506893
Author:
James D. Gwartney, Richard L. Stroup, Russell S. Sobel, David A. Macpherson
Publisher:
Cengage Learning
Economics: Private and Public Choice (MindTap Cou…
Economics
ISBN:
9781305506725
Author:
James D. Gwartney, Richard L. Stroup, Russell S. Sobel, David A. Macpherson
Publisher:
Cengage Learning
Exploring Economics
Economics
ISBN:
9781544336329
Author:
Robert L. Sexton
Publisher:
SAGE Publications, Inc
Managerial Economics: A Problem Solving Approach
Economics
ISBN:
9781337106665
Author:
Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:
Cengage Learning