The Bakery Pricing Spreadsheet That Actually Works
Half of cottage bakers track recipe costs in a spreadsheet. The other half wish they did. This guide gives you the minimum-viable spreadsheet template — three tabs, six formulas — and a clear take on whether it's worth maintaining.
Tab 1 — Ingredient master list
Columns:
- A: Ingredient name (e.g. "Bread flour, KA")
- B: Pack size (e.g. 2268 for a 5 lb bag)
- C: Pack unit (e.g. "g")
- D: Pack cost (e.g. $5.49)
- E: Unit cost =
=D2/B2
This is your single source of truth. Update column D when prices change; everything else recalculates automatically.
Tab 2 — Recipes
Columns:
- A: Recipe name
- B: Ingredient (data validation: dropdown from Tab 1)
- C: Quantity used
- D: Unit cost =
=VLOOKUP(B2, Ingredients!A:E, 5, FALSE) - E: Line cost =
=C2*D2
Group by recipe with a SUMIF on E to get total recipe cost.
Tab 3 — Pricing
Columns:
- A: Recipe name
- B: Total recipe cost (SUMIF from Tab 2)
- C: Yield
- D: Cost per unit =
=B2/C2 - E: Target margin %
- F: Suggested price =
=D2/(1-E2/100)
Why this is fragile
- One typo in a VLOOKUP and prices silently break.
- Adding a new ingredient requires touching Tab 1 and re-validating dropdowns.
- Sharing the file with anyone else means training them.
- Mobile editing is painful.
- Exporting a clean cost card for a customer requires manual formatting.
When to switch to an app
The economic break-even is roughly: if you re-cost more than 1 recipe per month, an app pays for itself. The Unlimited Baker plan ($19/mo) at 2 minutes saved per recipe means you break even at ~10 recipes a month — and most active home bakers cost 20–40 recipes per month between price changes, new menu items, and seasonal recipes.
The hybrid approach
What works for many cottage operators: keep an ingredient master spreadsheet for inventory and supplier comparison, and use BakeCostCalc for the actual recipe costing. The spreadsheet is your source of truth for what things cost; the app is where you do the math fast and export PDFs to send to customers.