Welcome to the eG Forums, a service of the eGullet Society for Culinary Arts & Letters. The Society is a 501(c)3 not-for-profit organization dedicated to the advancement of the culinary arts. These advertising-free forums are provided free of charge through donations from Society members. Anyone may read the forums, but to post you must create a free account.

Help, tracking a commercial wine cellar...

By Graphix
July 8, 2006 in Wine

Followers 0

Recommended Posts

Graphix

Posted July 8, 2006

- Share

Posted July 8, 2006

So i have the small (a.k.a. giant) task of reorganizing a wine cellar for my family's restaurant. its about 160 different reds and 40 whites. were only open for 6 weeks out of the year and we go through anywhere from 30-100+ bottles a day for those 6 weeks. Looking for a way to track cases/bottles in and bottles out...wholesale vs retail cost comparison...etc etc. Its cetainly not an ideal cellar so things easily get jumbled... i have metro shelving coming that will hold upwards of 1000 bottles this is to be used for something like 130 bin numbers. Any software solutions? Ive looked at cellartracker.com and im not sure that it will be ideal for my situation. Anyone have any great excel workbooks that they have come up with for tracking this type of thing?

can take a look at the list if you like...

http://pixelbunker.com/inventory2006.htm

thanks

Brendan