Cornell University
Library
Cornell UniversityLibrary

eCommons

Help
Log In(current)
  1. Home
  2. Cornell Peter and Stephanie Nolan School of Hotel Administration
  3. Centers and Institutes
  4. The Center for Hospitality Research (CHR)
  5. Center for Hospitality Research Tools
  6. Managing a Wine Cellar Using a Spreadsheet

Managing a Wine Cellar Using a Spreadsheet

File(s)
Wine Cellar Tool Version 4 by Gary Thompson.pdf (6.05 MB)
main article
Wine Cellar V4r1-blank.xlsm (1.57 MB)
spreadsheet (blank)
Wine Cellar V4r1-sample.xlsm (1.98 MB)
spreadsheet (with example)
Permanent Link(s)
https://hdl.handle.net/1813/72640
Collections
Center for Hospitality Research Tools
Author
Thompson, Gary
Abstract

Using examples from Version 4 of Wine Cellar Management Tool, this report describes the many spreadsheet-based analyses in this tool that can assist an individual, restaurant, or bar in managing a wine cellar. The primary motivation for developing Version 4 was to expand the capability of the tool to assist cellar owners in making decisions about how to manage a purposeful decrease in the size of their cellars. In addition to providing insight into the key questions of what to consume and what to promote, the tool shows such interesting and informative analyses as appellations, vintages, and types of wine. In the tool described in this report, the spreadsheet itself incorporates form-based sets of data entry fields. The Wine Cellar Management Tool Version 4, which is available at no charge from The Center for Hospitality Research at Cornell University, does not require actual knowledge of how to construct a spreadsheet. It does require diligent data entry regarding wine purchases and withdrawals.

Date Issued
2020-09-29
Keywords
restaurants
•
wine cellars
•
spreadsheets
•
wine cellar management
Rights
Attribution-NoDerivatives 4.0 International
Rights URI
http://creativecommons.org/licenses/by-nd/4.0/
Type
report

Site Statistics | Help

About eCommons | Policies | Terms of use | Contact Us

copyright © 2002-2026 Cornell University Library | Privacy | Web Accessibility Assistance