Hotel Design Problem Statement

Currently the hotel has 450 rooms with the following history:

Table 6. Hotel example data summary

Room Type

Rate

Daily Avg. No. Sold

Revenue

Standard

$85

250

$21,250

Gold

$98

100

$9,800

Platinum

$139

50

$6,950

Each market segment has its own price/demand elasticity. Estimates are:

Room Type

Elasticity

Standard

-3

Gold

-1

Platinum

-2

This means, for example, that a 1% decrease in the price of a standard room will increase the number of rooms sold by 3%. Similarly, a 1% increase in the price will decrease the number of rooms sold by 3%. For any proposed set of prices, the projected number of rooms of a given type sold can be found using the formula:

Rooms Sold formula.

where variables are:

VariableDescription

H

Historical average number of rooms sold

E

Elasticity

N

New price

C

Current price

The hotel owners want to keep the price of a standard room between $70 and $90, a gold room between $90 and $110, and a platinum room between $120 and $149. All prices are in whole dollar increments (discrete). Although the rooms may be renovated and reconfigured, there are no plans to expand beyond the current 450-room capacity.