Pro Bar Manager Spreadsheet Suite - Pour Cost, SPLH and Menu Engineering
Run your bar program like a profit center, not an afterthought. Built by a 38-year hospitality operator who has managed bar operations across fine dining, hotel food and beverage, casino lounges, and high-volume restaurant bars.
This 9-sheet suite covers every financial and operational metric a bar manager needs, pour cost, recipe costing, inventory, waste tracking, labor scheduling with SPLH, and a full beverage menu engineering matrix. Works for restaurant bars, hotel bars, standalone bars, and casino lounge operations.
What is included:
How to Use: step-by-step setup and daily workflow guide Inventory Count: full bar inventory count sheet with par levels, variance tracking, and cost valuation by category Recipe Costing: cocktail and beverage recipe costing with pour cost percentage, ingredient costs, and sell price analysis Daily Sales Report: daily bar revenue entry by category with running totals, pour cost percentage, and comp tracking Prime Cost Tracker: combined pour cost and bar labor tracking against your prime cost target Waste Log: document and track every pour, spill, breakage, and void with cost impact analysis Menu Engineering: beverage menu matrix classifying every drink as a star, plowhorse, puzzle, or dog by profitability and popularity Labor Scheduler: bar staffing schedule with live labor cost and SPLH calculated as you build the schedule Dashboard: live bar performance summary pulling key metrics from all sheets, pour cost, SPLH, waste, top sellers, and prime cost in one view
9 sheets. Instant download. Excel and Google Sheets compatible. Sample data and setup guide included. Own it forever. No subscription.