Free XLSX template

Recipe Costing Sheet

Calculate ingredient usage, active labor, packaging, batch cost, unit cost, and a target-margin price.

Preview of the Recipe Costing Sheet workbook

What is included

  • 10 ingredient rows
  • Package-to-usage formulas
  • Labor, packaging, and yield summary
  • Target-margin price formula

How to use it

  1. Replace the example ingredients with your own package price, package size, and used quantity.
  2. Use the same measurement unit for package size and amount used; enter active labor minutes, hourly rate, packaging, other cost, and sellable yield.
  3. 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