Free XLSX template
Recipe Costing Sheet
Calculate ingredient usage, active labor, packaging, batch cost, unit cost, and a target-margin price.

What is included
- 10 ingredient rows
- Package-to-usage formulas
- Labor, packaging, and yield summary
- Target-margin price formula
How to use it
- Replace the example ingredients with your own package price, package size, and used quantity.
- Use the same measurement unit for package size and amount used; enter active labor minutes, hourly rate, packaging, other cost, and sellable yield.
- Enter a target margin below 100%, then review batch cost, unit cost, and suggested price.
Example calculation
Ingredient line: $8 pack × 350 g used ÷ 5,000 g pack → $0.56 used cost. Illustrative only; replace every example row before real use.
Formula assumptions and limits
- The workbook divides numeric package usage by numeric package size; it does not convert grams, ounces, cups, or other units for you.
- Normal waste belongs in sellable yield; the price formula is cost ÷ (1 − target margin), not a demand forecast.
File and compatibility
Format: Microsoft Excel workbook (.xlsx). Microsoft Excel, LibreOffice Calc, or import into Google Sheets.
License
Free for your bakery's internal business use. Do not resell or redistribute the unchanged file.
Data note
The downloaded file stays on your device and is separate from your online workspace; edits do not sync between them. Bake Pricing does not receive values entered into the file. Financial results depend on your inputs. Keep backups and remove example rows before real use.
Download Recipe Costing Sheet← All templates