Beverage KPI & COGS Variance Dashboard
What it is
A ready to use dashboard that turns POS sales plus inventory based COGS into clear weekly or monthly performance. It compares Actual vs Theoretical COGS to surface variance, shrinkage, waste, and overpouring, then translates results into a simple Next Week Action Plan.
What it solves
Most venues see sales but cannot explain why margin moved. Messy POS naming, weak category mapping, and incomplete costing create reports that look fine but do not drive decisions. This toolkit standardizes inputs and makes variance visible by category and key items.
Why buy it
• See Sales, Actual COGS, COGS percent, GP, GP percent, and variance in one view
• Spot which categories are driving the gap and how big it is
• Standardize POS names without editing raw exports
• Track reliability with a Data Quality Score (0 to 100) as costing coverage improves
• Get an auto generated Next Week Action Plan instead of guessing
Best for: owners, GMs, beverage managers, and consultants who run weekly or monthly reviews and want a repeatable cost control rhythm.
Select a package
Packages and turnaround
Starter (Instant download)
Template only. Set up the yellow input fields, paste POS into Sales_Data, enter Inventory_COGS, review the Dashboard.
Standard (2 days delivery)
Setup aligned to your outlets, categories, targets, and POS export structure. Mapping, targets, and alert thresholds aligned so your data drops in cleanly.
Advanced (4 days delivery)
Done for you build. You send one period POS export plus category inventory numbers and key item costs. You receive a clean ready to use file plus a short action summary on the top variance categories.
What’s inside
-
Dashboard with KPI cards: Total Sales, Actual COGS, COGS %, Gross Profit, GP %, Theoretical COGS, Variance $ and %
-
Category performance table: sales, mix %, COGS %, target %, variance $
-
Sales mix and variance charts plus trend view
-
Next Week Action Plan auto generated from top variance categories
-
Data Quality Score (0 to 100) to flag missing costing or mapping issues
-
POS_Mapping sheet to standardize item and category names without editing raw exports
-
Inventory based COGS by category (begin, purchases, transfers, end)
-
Item_Costing library (up to 2,000 items) to calculate theoretical COGS per sale
-
Pour_Cost_Translator to convert bottle or pack cost into cost per pour
-
Action_Library and Sources tabs for consistent KPI definitions and troubleshooting