LUX* Resorts & Hotels: Optimal Room Mix Marketing Decisions

Name: LUX* Resorts & Hotels: Optimal Room Mix Marketing Decisions
SKU: 9B17E004_P

Singfat Chu; Nitesh Pandey

Product #:9B17E004_P

Supplier:Ivey/NUS

Discipline:International Business, Management Science

Setting:Mauritius, 2016

Details:Case (PDF) • 4 pages • 2017-05-17

Your Price:

$9.71

Language:

Format:

Purchase this material with a free Educator Account and enjoy more benefits:

Free Educator Copy
Free Teaching Notes
Build your coursepack
Discounted academic price

In early 2016, LUX* Resorts & Hotels, a hotel group headquartered in Mauritius, needed to determine the room mix to sell to foreign guests to achieve a specific earnings target. The hotel group also intended to sell some of the remaining rooms to local residents at affordable (discounted) prices. The objective was to maximize the revenue stream to finance local corporate social responsibility projects. The case highlights the practical use of Microsoft Excel Solver, an optimization tool, to resolve routine planning challenges faced by a hotel group.

Learning Objectives

This case is suitable for undergraduate, graduate, and specialized courses in analytics, finance, and hospitality management. It demonstrates how an optimization tool, Microsoft Excel Solver, can be effectively applied to routine hospitality management problems, which are often tackled through time-consuming, trial-and-error attempts. After completing the case, students should be able to

use Microsoft Excel to determine the correct room mix to achieve a hotel’s earnings target;
understand why and how to use an optimization template to resolve hospitality management issues;
consider how to make an earnings target easier to achieve; and
discuss alternative ways a hotel can increase its corporate social responsibility project financing.

LUX* Resorts & Hotels: Optimal Room Mix Marketing Decisions

Subjects:

Industries:

Geography:

Learning Objectives