Quick answer
Food cost spreadsheet built for pizzerias: Pizzerias balance dough yield, topping portions, oven capacity, slices, delivery packaging, and frequent price changes on cheese and flour.
What this template helps you do
This food cost spreadsheet is built for pizzerias. Pizzerias balance dough yield, topping portions, oven capacity, slices, delivery packaging, and frequent price changes on cheese and flour. 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 feature high-margin pies, mark sold-out slices, explain half-and-half rules, and update specials without reprinting table menus.
Pizzerias food cost worksheet example
| Menu item | Portion cost | Menu price | Cost driver | Menu action |
|---|---|---|---|---|
| Margherita 12 inch | $3.15 | $13.00 | Cheese and basil yield | Keep price; feature as margin anchor |
| Pepperoni 16 inch | $5.40 | $19.50 | Pepperoni portion drift | Add portion guide before price change |
| Truffle mushroom pie | $7.25 | $24.00 | Premium topping cost | Add stronger description and photo |
| Garlic knots | $0.88 | $5.50 | Dough scrap usage | Promote as add-on |
| Gluten-free crust pizza | $6.80 | $18.00 | Purchased crust cost | Review price monthly |
Pizzerias 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 pizzerias, 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 feature high-margin pies, mark sold-out slices, explain half-and-half rules, and update specials without reprinting table menus. 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.