個案總覽

Spreadsheet to accompany product 8B17E004.

Student spreadsheet to accompany product 9B17E004.

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.

Student spreadsheet for case W17282.

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.