# Linear programming model for revenue management application

Not what you're looking for?

Problem 30

Hanson Inn is a 96-room hotel located near the airport and convention center in Louisville, Kentucky. When a convention or a special event is in town, Hanson increases its normal room rates and takes reservations based on a revenue management system. The Classic Corvette Owners Association scheduled its annual convention in Louisville for the first weekend in June. Hanson Inn agreed to make at least 50% of its rooms available for convention attendees at a special convention rate in order to be listed as a recommended hotel for the convention. Although the majority of attendees at the annual meeting typically request a Friday and Saturday two-night package, some attendees may select a Friday night only or a Saturday night only reservation. Customers not attending the convention may also request a Friday and Saturday two-night package, or make a Friday night only or Saturday night only reservation. Thus, six types of reservations are possible: convention customers/two-night package; convention customers/Friday night only; convention customers/Saturday night only; regular customers/two-night package; regular customers/Friday night only; and regular customers/Saturday night only.

The cost for each type of reservation is shown here.

The anticipated demand for each type of reservation is as follows:

Hanson Inn would like to determine how many rooms to make available for each type of reservation in order to maximize total revenue.

A. Define the decision variables and state the objective function

CT = number of convention two-night rooms

CF = number of convention Friday only rooms

CS = number of convention Saturday only rooms

RT = number of regular two-night rooms

RF = number of regular Friday only rooms

RS = number of regular Saturday only room

___CT+___CF+___CS+____RT+____RF+____RS

B. Formulate a linear programming model for this revenue management application.

___CT+___CF+___CS+____RT+____RF+____RS

s.t.

1) ___CT___

2) ___CF___

3)___CS___

4) ___RT___

5)___RF___

6)___RS___

7)___CT+___CF___

8) ___CT+___CS___

9) ___CT+___CF+___RT+___RF

10) ___CT+___CS+___RT+___RS

C) What is the optimal allocation and the anticipated total revenue?

Variable Value

CT

CF

CS

RT

RF

RT

Total Revenue

d) Suppose that one week before the convention, the number of regular customers/Saturday night only rooms that were made available sell out. If another nonconvention customer calls and requests a Saturday only room, what is the value of accepting this additional reservation?

The shadow price for constraint 10 is ? and shows an added profit of ? if this additional reservation is accepted

##### Purchase this Solution

##### Solution Summary

The expert examines linear programming model for revenue management applications.

##### Solution Preview

Problem 30

Hanson Inn is a 96-room hotel located near the airport and convention center in Louisville, Kentucky. When a convention or a special event is in town, Hanson increases its normal room rates and takes reservations based on a revenue management system. The Classic Corvette Owners Association scheduled its annual convention in Louisville for the first weekend in June. Hanson Inn agreed to make at least 50% of its rooms available for convention attendees at a special convention rate in order to be listed as a recommended hotel for the convention. Although the majority of attendees at the annual meeting typically request a Friday and Saturday two-night package, some ...

##### Purchase this Solution

##### Free BrainMass Quizzes

##### Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

##### Probability Quiz

Some questions on probability

##### Graphs and Functions

This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.

##### Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.

##### Know Your Linear Equations

Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.