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
icon
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?

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
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
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Managerial Economics: Applications, Strategies an…
Managerial Economics: Applications, Strategies an…
Economics
ISBN:
9781305506381
Author:
James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
Publisher:
Cengage Learning
Microeconomic Theory
Microeconomic Theory
Economics
ISBN:
9781337517942
Author:
NICHOLSON
Publisher:
Cengage
Microeconomics: Private and Public Choice (MindTa…
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: 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