Home Bakery Pricing Calculator
A cottage-bakery pricing spreadsheet: know what each cookie, cupcake or loaf actually costs, and what to charge.
What it calculates
- Ingredient library (40 rows): package size and price -> cost per gram / ml / each
- Recipe costing with ingredient dropdowns (15 lines)
- Packaging per item, your labor time x hourly wage, overhead per batch
- Cost per item, price per item at your target margin (rounded up to $0.25), half-dozen and dozen prices with optional dozen discount, profit and margin
Real screenshots (sample data)
What you get
Home-Bakery-Pricing-Calculator.xlsx and a 1-page PDF quick-start guide. Duplicate the recipe tab for each product.
$15
Instant download (.xlsx + PDF guide). Works in Excel, Google Sheets and LibreOffice.
Sample ingredient prices are illustrative. Cottage food rules and sales tax vary by location; this tool does not calculate tax.
Free guides: cupcake pricing formula · pricing cookies · free mini calculator
Bundles for bakers
Bakery Pricing + Profit ($29): this calculator + the Home Bakery Profit & Bookkeeping Tracker. Separately $34.
$29
Instant download: both spreadsheets + PDF guides.
Baker Bundle ($35): this calculator + Recipe & Batch Costing Sheet + bakery profit tracker. Separately $49.
$35
Instant download: 3 spreadsheets + 3 PDF guides.
Common questions
Does it work in Google Sheets?
Yes. Upload the .xlsx to Google Drive and open it with Google Sheets. Only standard functions are used. In Sheets, type only in the yellow cells.
Do I need Excel?
No. Google Sheets (free) or LibreOffice (free) work too.
How do I get the files?
Right after payment you see download links, and they are emailed to you. Links work for 7 days, so save the files.
Will it tell me the right price for my area?
No. It turns your own costs and target margin into a price. Local rates and demand are up to you. It is an estimating tool, not tax or financial advice.
Is this a subscription?
No. It is a one-time purchase.