Free XLSX template
Bakery Price List
Turn batch cost and yield into cost per unit, a target-margin price, and the actual margin at your selling price.

What is included
- 10 product rows
- Cost-per-unit formula
- Target-margin price
- Actual margin comparison
How to use it
- Enter the complete batch cost and number of sellable units for each product.
- Choose a target margin as a percentage below 100%.
- Enter the actual selling price to compare achieved margin with the target.
Example calculation
Margin check: $6 unit cost sold for $10 → 40% margin; 66.67% markup. Illustrative only; replace every example row before real use.
Formula assumptions and limits
- Cost per unit is batch cost ÷ units; suggested price is unit cost ÷ (1 − target margin).
- Actual margin uses (selling price − unit cost) ÷ selling price; selling fees and tax are not inserted automatically.
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 Bakery Price List← All templates