Beverage KPI and COGS Variance Dashboard (POS + Inventory)

Stop guessing where beverage profit is leaking. This is a ready to use KPI dashboard that turns POS sales plus inventory based COGS into clear weekly performance numbers, and compares Actual vs Theoretical COGS to surface variance, shrinkage, waste, overpouring, and execution issues by category and key items.
 
What it fixes
No weekly view of Sales, COGS %, GP %, and variance in one place
No clarity on which categories are driving COGS problems
Messy POS naming that breaks reporting consistency
Theoretical costing that is incomplete or unreliable
Teams that see bad numbers but lack a clear next action
 
Ideal for
Cocktail bars, hotel bars, restaurants, and multi outlet venues that run weekly or monthly beverage performance reviews.
 
Packages and turnaround
 
Starter (1 day)
Template only. Set up the yellow input fields, paste POS into Sales_Data, enter Inventory_COGS, review the Dashboard.
 
Standard (2 days)
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)
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
 
Delivery format
Excel (.xlsx) or Google Sheets, your choice.
 
How it works
Configure Setup (yellow cells)
Paste POS export into Sales_Data and map names if needed
Enter Inventory_COGS and maintain Item_Costing to unlock item level variance
Read the Dashboard and follow the Next Week Action Plan
 
Built by The Double Strainer.