Faculty & Research
The Wine Cellar Management Tool
By: Gary M. Thompson Ph.D.
Executive Summary:
As described in the accompanying report “Managing a Wine Cellar Using a Spreadsheet,” by Gary M. Thompson, the Wine Cellar Management Tool is a spreadsheet that can be used to help manage a wine cellar, either for individuals or for firms such as restaurants or bars. The spreadsheet comes in two versions. The "Sample" version allows you to examine how the spreadsheet will look after you have entered data on the wines you own. The "Blank" version is the version you should use to enter your own data after you have downloaded it.
The spreadsheet is already formatted with the formulas that you will need to use the tool. Thus, you do not need to know much about a spreadsheet. Instead, all of the data are entered or edited via fill-in forms that are accessible from the “Switchboard” worksheet that is part of the download. As described in the report, the spreadsheet contains a large number of cellar analyses that are interesting and informative, and that can be used to help guide cellar management decisions, such as what to consume or what to promote. All that the tool requires is that you be disciplined about recording the inflows and outflows to and from the cellar. Because the data reside in a spreadsheet on your computer, there are no data security issues.
To view the tool, please click on the link below
Wine Cellar Management Tool - Sample
Wine Cellar Management Tool - Blank
Download The Report
To view the corresponding report, please click on the link below.
Managing a Wine Cellar Using a Spreadsheet
Your Comments Please
If this CHR Report made a positive impact on your management approach or business operations, we welcome your commentary. We would like to post your comments on our website. Please submit your comments to js372@sha.cornell.edu and rohit.verma@cornell.edu.
About Gary M. Thompson Ph.D.
Gary M. Thompson is a professor of operations management in the School of Hotel Administration, where he teaches graduate and undergraduate courses in operations management. Previously he spent eight years on the faculty of the David Eccles School of Business at the University of Utah. He holds a BS with first class honors from the University of New Brunswick, an MBA from the University of Western Ontario, and a PhD in operations management from The Florida State University. His current research focuses on optimizing restaurant table mixes, on optimizing conference schedules to improve attendee satisfaction, on course scheduling in post-secondary and corporate training environments, and on the effects on customer service of labor staffing and scheduling decisions. His research has appeared in the Cornell Hospitality Quarterly, Decision Sciences, the Journal of Operations Management, Management Science, Naval Research Logistics, Operations Research and other journals. He has consulted for several prominent hospitality companies and is the founder and president of Thoughtimus, Inc., a small software development firm focusing on scheduling products.
For more information visit http://www.hotelschool.cornell.edu/research/facultybios/faculty.html?id=84