Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Marquis Hotel is considering a major remodeling effort and needs to determine the best rates and room sizes to maximize revenues. Although the rooms

image text in transcribed The Marquis Hotel is considering a major remodeling effort and needs to determine the best rates and room sizes to maximize revenues. Although the rooms may be renovated, there are no plans to change the current 450-room capacity. The accompanying model and spreadsheet maximizes revenues for the three types of rooms currently available, standard, gold, and platinum. Suppose that the hotel is considering adding suites to its room mix. Based on an analysis of local competitors, suites can sell for a rate of $180, and they expect to sell 20 per day to business travelers. The price elasticity of demand is estimated to be -2.5 . The hotel would want to keep the price of suites between $150 and $200. Modify the model to include suites and find prices that will maximize total revenue. Click the icon to view the model and spreadsheet Total Revenue Model Complete the table of prices that maximize total reven (Round to the nearest cent as needed.) Let S= price of a standard room, G= price of a gold room, and P= price of a platinum room. Maximize the revenue, subject constraints on the price range, and subject to the total room capacity of 450 . MaximizeRevenue70S90G120P10255S2.66667G0.35971P=625S+300G+100P5S22.66667G20.35971P290110149450

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

Wildlife Ecology And Management

Authors: Eric G. Bolen, William Laughlin Robinson

5th Edition

013066250X, 978-0130662507

More Books

Students also viewed these General Management questions

Question

Discuss how frequently households trade securities.

Answered: 1 week ago