Ivey Publishing
LUX* Resorts & Hotels: Optimal Room Mix Marketing Decisions
Product Number:
Publication Date:
Revised Date:
4 pages (3 pages of text)
Product Type:
Case (Field)
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 Objective:
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.
Management Science,  International
Accommodation & Food Services
Mauritius, Large, 2016
Intended Audience:
$5.30 CAD / $5.00 USD Printed Copy
$4.50 CAD / $4.25 USD Permissions
$4.50 CAD / $4.25 USD Digital Download
Associated Materials
Supplements: 7B17E004 (59 KB)
Translations: Simplified Chinese (4 pages)
You Might Also Like...

Save In: