Teaching Note: Spreadsheet Modeling to Determine the Optimum Hotel Room Rate for a Short High-Demand Period
Thin-Yin Leong
School of Information Systems, Singapore Management University, Singapore 178902, Republic of Singapore, tyleong@smu.edu.sg
Wee-Leong Lee
School of Information Systems, Singapore Management University, Singapore 178902, Republic of Singapore, wllee@smu.edu.sg
Abstract
In this article, we describe a business modeling exercise that helps students understand the complex relationship between demand and price. The exercise seeks to determine the optimum pricing, in view of anticipated occupancy response that maximises profit for a hotel. Through the exercise, students are introduced to advanced Excel operations such as Goal Seek and Solver. This exercise goes through a systematic series of basic modeling steps, starting from identifying input variables and performance measures, and building from a basic model to a final model with sufficient complexity to represent reality. A problem commonly encountered when modeling real-world problems is the lack of complete information; often, information has to be inferred from what little is available from the past. This is demonstrated in developing the hotel occupancy and rate relationship. To ensure the model is robust, we show how trade-off and sensitivity analyses can be conducted.
Key words
spreadsheet modeling; demand management
History
Received: January 2010; accepted: June 2010
Download the PDF
Supplementary Material
Citation Information
Leong, T.-Y., W.-L. Lee. 2010. Teaching note: Spreadsheet modeling to determine the optimum hotel room rate for a short high-demand period. INFORMS Trans. Ed. 11(1) 35-42. Available online at http://ite.pubs.informs.org/.