Home Bakery Pricing Calculator Spreadsheet: cost per cookie, cupcake & cake (Excel + Google Sheets)

Know what every bake really costs you, and what to charge for it.

This home bakery cost & pricing calculator turns what you paid for your ingredients into a cost per item, adds your time and overheads, and gives you three prices: wholesale, retail, and the lowest price that still hits your profit margin after card or platform fees.

Most bakers underprice because they forget their time, packaging or fees. This shows you, in green or red, whether each product actually makes money.

Want to see the numbers first? Read the free guide How to price baked goods.

WHAT'S INSIDE

• Ingredient library (80 rows): enter pack size, pack price and shipping once. Cost per gram, ml or piece is worked out for you.
• Recipes for up to 12 products, each with up to 12 ingredients, yield and baking time.
• Price list: ingredients, labour and overhead per item, total cost, wholesale price, retail price and a fee-aware price for your target margin.
• Profit check at your current price: fees, profit, margin and what your time earns per hour.
• Recipe scaler: turn a 24-cookie recipe into a 60-cookie order, every ingredient scaled for you.
• Settings for your hourly rate, monthly overheads, pricing multipliers and fee estimates. Works in any currency.

EXAMPLE: decorated sugar cookies with $0.61 of ingredients and packaging each, plus decorating time, cost $4.55 each. The calculator shows that $4.50 loses money and suggests a profitable price.

WHY IT'S EASY TO USE

• Works in Excel and Google Sheets. One-time price, no subscription, no account.
• A filled-in example and a Start Here tab, so you copy the setup instead of starting from a blank sheet.
• Free updates: your download page always has the latest version.

HOW YOU GET IT

1. After checkout you get a short PDF with your personal download page and your license key (the key is also on your order page).
2. Download the file at sheetsandsums.com/download/bakery-pricing with the email you bought with and your key. You always get the newest version, and future updates are free: same page, same key.
3. Open the .xlsx file in Excel (2016 or newer), Apple Numbers or LibreOffice. Google Sheets: drive.google.com > New > File upload, then open it with Google Sheets.
4. Fill in the yellow cells. Everything else calculates on its own.

GOOD TO KNOW

• Instant digital download. Nothing is shipped.
• No subscription, no macros, no account needed.
• Formulas are locked so they can't break by accident (unlock with Review > Unprotect Sheet, no password).
• Every rate and assumption sits in an editable cell, so the file never goes out of date on you.
• Stuck? The Start Here tab answers most questions. Otherwise email hello@sheetsandsums.com; we usually reply within 2 working days.
• Doesn't open or doesn't work as described? Email us and we'll fix it or refund you.

SELLING AT CRAFT FAIRS?

Check before you book whether a fair is worth the booth fee with the free craft fair calculator, then track sales, stock and profit at your stall with the free Market Day app.

A planning and record-keeping tool, not tax, legal or accounting advice. For use in your own business; please don't resell or share the file.