Beverage Cost Control Workbook
BEVERAGE COST CONTROL WORKBOOK
Find the 3–7% your pour cost is hiding.
———
THE PROBLEM
You know your beverage GP feels off. You don't have time to chase it down sheet by sheet. Most templates you've tried are generic, badly built, or both.
This workbook is different. It's a closed-loop pour cost system designed by an Australian hospitality operator, for Australian hospitality operators. One Excel file. Eight sheets. Built to be opened weekly and to tell you exactly where your margin is leaking.
———
WHAT'S INSIDE
Eight sheets, all linked. Update Setup once and every other sheet pulls from there.
- Setup. Venue name, week ending, all editable targets per category. Single source of truth.
- Recipe Costing. 50 drink slots. Cost per ingredient, sell price, pour cost %, GP $, GP %.
- Stock Take. Weekly category COGS, revenue, pour cost % vs target. Spirits, Beer, Wine, Cocktails, Non-Alcoholic.
- Waste & Spillage. 60-entry log. Spillage, comp, staff drink, other. Total feeds Performance Tracker and Dashboard.
- Performance Tracker. 12-week trend. Average, best, worst, variance vs target.
- Benchmarks. Eight Australian industry ranges. Live status against your actual.
- Dashboard. Six KPI cards, category breakdown, 12-week trend snapshot. Open this each week.
- Cover. Quick reference, version, licence, sheet index.
Every formula colour-coded. Blue cells are your inputs. Black cells calculate. Green cells link across sheets. You can't accidentally break the model.
———
WHAT YOU GET
- The .xlsx file. Works in Excel, Google Sheets, Numbers, LibreOffice.
- Lifetime access for one venue.
- Free updates as the workbook evolves.
- A$197 AUD, GST inclusive.
- Automatic tax invoice on purchase.
———
WHO THIS IS FOR
Independent bars, pubs, restaurants, and hotel F&B operators in Australia who want to run a tight beverage program without paying A$300 a month for a POS add-on.
If you have a venue where pour cost % matters and you've stopped trusting the report your POS spits out, this is for you.
If you want to be told exactly what to do without doing the work yourself, this isn't.
———
BUILT BY
Radu Ciprian Popa, founder of Nest Hospitality Solutions (nest1hs.com.au). 25 years in Australian hospitality operations. Built this workbook because he needed it himself.
———
REFUND POLICY
If you open the workbook and it doesn't do what's promised on this page, contact via nest1hs.com.au within 14 days. Full refund, no questions.
———
A$197 AUD. GST inclusive. One-time payment. Lifetime use.