Revenue management using seat utilization programme : a Japanese restaurant case study.

Seat optimization is a tool widely used in restaurant revenue management. This study analyses data from a Japanese restaurant, using an optimization technology known as AIMMS to identify the potential for better seat utilization and higher revenue to be obtained. Leveraged on Linear Programming, a m...

Full description

Saved in:
Bibliographic Details
Main Authors: Ng, Eileen Yu Ting., Yip, Claire Kai Ling., Luong, Ha Thi Thu.
Other Authors: Nanyang Business School
Format: Final Year Project
Language:English
Published: 2012
Subjects:
Online Access:http://hdl.handle.net/10356/48155
Tags: Add Tag
No Tags, Be the first to tag this record!
Institution: Nanyang Technological University
Language: English
Description
Summary:Seat optimization is a tool widely used in restaurant revenue management. This study analyses data from a Japanese restaurant, using an optimization technology known as AIMMS to identify the potential for better seat utilization and higher revenue to be obtained. Leveraged on Linear Programming, a model was built to investigate if minimizing the number of empty seats at occupied tables engenders better seat utilization than the present First-Come-First-Serve practice. The results obtained coincide with our original prediction: by minimizing the number of empty seats at occupied tables, seat utilization improves from 1.05% to 15.13%, with an average increase of 5.78%. The augmentation of potential revenue to be generated as a result of more empty seats averages 2.32% of the current revenue generated by the FCFS practice, with the highest percentage change in potential revenue being 7.8% and the lowest at 0.40%. The study also conducts a sensitivity analysis to reflect a more realistic input of the restaurant’s demand. Similar results are obtained: higher seat utilization and higher potential revenue are recognized when the demand increases.