Quick answer
Food cost spreadsheet built for cafes: Cafes manage coffee, milk alternatives, pastries, breakfast items, daypart menus, and frequent price sensitivity on small-ticket orders.
What this template helps you do
This food cost spreadsheet is built for cafes. Cafes manage coffee, milk alternatives, pastries, breakfast items, daypart menus, and frequent price sensitivity on small-ticket orders. 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 separate breakfast, drinks, pastries, and lunch; update sold-out pastries; and highlight seasonal drinks with photos.
Cafes food cost worksheet example
| Menu item | Portion cost | Menu price | Cost driver | Menu action |
|---|---|---|---|---|
| Oat latte | $1.42 | $5.25 | Milk alternative cost | Review alt-milk surcharge |
| Avocado toast | $3.85 | $11.50 | Avocado waste | Adjust portion spec |
| Breakfast sandwich | $2.90 | $8.75 | Egg and cheese cost | Keep as traffic item |
| Blueberry muffin | $0.96 | $4.25 | Batch yield | Feature if sell-through strong |
| Cold brew | $0.72 | $4.75 | Concentrate dilution | Promote in afternoon |
Cafes 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 cafes, 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 separate breakfast, drinks, pastries, and lunch; update sold-out pastries; and highlight seasonal drinks with photos. 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.