Quick answer
Food cost spreadsheet built for bars: Bars rotate taps, adjust cocktail batches, manage happy hour rules, and need clear drink descriptions that help guests choose quickly.
What this template helps you do
This food cost spreadsheet is built for bars. Bars rotate taps, adjust cocktail batches, manage happy hour rules, and need clear drink descriptions that help guests choose quickly. The worksheet keeps costing decisions close to the menu items guests actually see.
Best use case
Use it before price changes, menu refreshes, supplier increases, or seasonal updates. Use the QR menu to update rotating taps, feature cocktails, clarify happy hour windows, and add ABV or flavor notes without reprinting.
Bars food cost worksheet example
| Menu item | Portion cost | Menu price | Cost driver | Menu action |
|---|---|---|---|---|
| House margarita | $2.40 | $11.00 | Tequila pour control | Keep and feature |
| Espresso martini | $4.25 | $14.00 | Labor and liqueur cost | Add premium photo |
| Local IPA pint | $3.10 | $8.00 | Keg yield | Add brewery note |
| Loaded fries | $2.20 | $9.00 | Kitchen load | Use happy hour only |
| Charcuterie board | $8.90 | $24.00 | Cheese cost | Review portion spec |
Bars food cost review checklist
How to use the spreadsheet
Enter real item costs
Use invoice cost, usable yield, and portion standards instead of rough guesses.
Compare against menu price
Highlight items where contribution margin no longer supports the current price.
Choose the guest-facing action
Decide whether to reprice, resize, rewrite, photograph, feature, or pause the item.
Publish and monitor
Update the QR menu and review guest item views after the change goes live.
Costing should lead to a menu action
For bars, costing work matters most when it changes what guests see: price, description, availability, photo, or placement.
How this connects to your QR menu
Use the QR menu to update rotating taps, feature cocktails, clarify happy hour windows, and add ABV or flavor notes without reprinting. After the spreadsheet is approved, update prices and descriptions in FlipMenu and use analytics to watch whether guests notice the revised items.
Use the worksheet first, then publish the guest-facing result only after the manager review is complete. That keeps the digital menu useful without turning it into an unapproved operations notebook.