Wine Production Cost Calculator — Per-Bottle COGS

• 🍷 Cover — table of contents + quick-start guide
• 📖 Instructions — step-by-step usage + color conventions for input vs formula cells
• ⚙️ Settings — grape varietal / wine type / barrel type dropdowns + yield (L/ton) and liter-to-bottle constants
• 🍇 Grape & Materials — enter grape, labor, barrels & aging, additives, bottling, lab, and facility costs
• 🧮 Cost Calculator — auto-sums 7 cost groups → cost per bottle after shrinkage
• 💰 Margin Analysis — 5 retail price points × 4 sales channels, gross margin %
• 📊 Dashboard — unit economics KPIs + cost/margin charts
• ❓ FAQ — 6 common questions (no-barrel production, allocation, shrinkage, multi-vintage)
• 🗒️ Version Log — release notes

Self-made Excel is prone to errors: calculating oak barrels once instead of allocating according to the number of uses, forgetting to deduct 7-10% shrinkage → lower virtual cost than actual, pricing based on intuition and losing on wholesale channels. This tool modeling the true nature of the wine industry: allocating barrels based on the number of uses (new oak vs neutral), deducting shrinkage in many stages (evaporation, sediment, spillage).

• 🍷 Small / boutique wineries — Dalat, Ninh Thuan… needing the true cost before setting prices
• 🏺 Craft / homemade producers — moving from gut-feel to structured COGS
• 📊 F&B consultants / beverage-industry accountants — a standard cost model to advise clients
• 🚀 Wine-business planners — projecting COGS & gross margin for a business plan

• ✅ Auto-summed 7 COGS groups into cost per bottle
• ✅ 5-price × 4-channel margin analysis in one sheet
• ✅ Barrel allocation by uses + adjustable shrinkage
• ✅ Formulas wrapped in IFERROR — empty template never throws #DIV/0!
• ✅ Centralized Settings with dropdowns for grape varietal / wine type / barrel type

• ✅ Microsoft Excel 2016+ (Windows/Mac)
• ✅ Google Sheets (live link, multi-user)
• ✅ Fully offline-ready — no subscription, no server

• 📄 4 .xlsx files: Sample (pre-filled) + Template (blank), both VI & EN
• 🇻🇳 Vietnamese edition: ₫ currency, L/ton units, Dalat winery sample numbers
• 🇬🇧 English edition: $ currency, gallon units
• 📊 Live companion dashboard on BEUP Canvas
• 🔄 Free updates + email support