Wine by the Glass Programme Cost & Spoilage Model: Cost per Glass, Pour Size, Spoilage and Preservation Payback Model for Bars and Restaurants
Full description
For beverage managers, sommeliers, bar managers and cost controllers who want to know what each glass of wine costs and where wine is lost after opening. The main workbook takes one row per wine and one row per wine and month. It works out glasses per bottle, cost per glass with expected waste, target price, pour cost, the glass-versus-bottle check, spoilage, yield, days to sell a bottle against opened-bottle life, and margin by wine. It compares pour sizes, shows what over-pouring costs, tests the payback of a vacuum pump, gas spray or inert-gas system, and shows price and margin against spoilage. The companion workbook is a bottle log with pour tests for use at the bar. The Word guide sets out the method, a worked example, the opened-bottle standards and the monthly review.
What is inside
- Wine_by_the_Glass_Model.xlsx: 12 tabs, 3,215 formulas, 2 native charts, 20 drop-down and input rules, 10 integrity checks
- Wine List: 24 sample wines plus 8 spare rows; Monthly Log: 144 sample rows (24 wines x 6 months) plus 30 spare rows
- Glass Model with 19 columns of glasses per bottle, cost per glass, target price, pour cost, glass-versus-bottle ratio, margin per bottle and verdict
- Spoilage Review by wine, by style and by month; Pour Sizes with 5 pour options and 5 over-pour levels; Preservation with 3 options; Sensitivity with 2 grids
- Dashboard with 10 tiles and 2 charts, Method with 18 rows
- Wine_Pour_and_Spoilage_Log.xlsx: 4 tabs, 893 formulas, 46 sample bottles, 12 pour tests, 12-item weekly standards checklist, 6 checks
- Wine_by_the_Glass_Guide.docx and PDF: 8 pages with equations, a worked example read from the workbook, a 19-item standards checklist, the monthly review and a glossary
- README.txt and LICENSE-and-Terms.txt
How it works
- Set the thresholds, scenario and opened-bottle life by method on Assumptions.
- List your wines with bottle size, cost, pour size and prices, and enter each month of bottles opened, glasses sold and glasses wasted.
- Read Glass Model for pricing issues and Spoilage Review for bottles that outlast their life, spoilage and missing glasses.
- Test pour sizes, preservation equipment and prices on their tabs, then run the monthly review.
Details
- Formats: 2 Excel workbooks (.xlsx), 1 Word guide (.docx) and PDF, English
- Software: Excel 2016 or later, or LibreOffice Calc 7 or later
- No macros, no external links, no data tables, no array formulas
- 4 files plus README and license; instant digital download
Good to know
- Sample data is illustrative. Replace it with your own figures.
- Opened-bottle life, expected waste and thresholds are typical starting values. Verify with your supplier and your own trials.
- Single-user license. Do not redistribute.
FAQ
Does it use brand or grape names?
No. Wines are generic codes and styles, so you can enter your own list.
How does it treat waste in the price?
Cost per glass divides the bottle cost by the glasses you can sell after the expected waste for the preservation method. The scenario can raise or lower that waste.
Can I change opened-bottle life?
Yes. Life and expected waste for each method are inputs on Assumptions. The guide gives typical starting values.
How many wines can it hold?
The sample has 24 wines and 8 spare rows. Add rows by copying the last formula row down on Wine List, Glass Model and Spoilage Review.
Do I need macros?
No. Every result is a standard worksheet formula.
