Recipe Cost Calculator | Bakery Pricing Spreadsheet for Google Sheets & Excel

This recipe cost calculator works out exactly what every bake costs (ingredients, packaging, your time and overhead) and gives you profitable retail and wholesale prices.

✦ WHAT'S INCLUDED

• Recipe cost & pricing calculator (.xlsx), example bakery with 29 ingredients and 8 priced recipes

• Blank version (.xlsx): 200 ingredients, 60 products, 800 recipe lines

• Step-by-step PDF guide for Google Sheets and Excel

✦ FEATURES

• Ingredient price list: cost per gram, ml or each from the package you buy

• Automatic unit conversion (g, kg, oz, lb, ml, l, tsp, tbsp, cup, fl oz, each, dozen) plus cup-to-gram conversion with your own density

• Labor at your hourly rate, overhead %, packaging and extras per batch

• Three pricing methods: target margin, ingredient multiplier (3x rule) and wholesale

• Type your real price to see true profit, margin and food-cost %

• Price Tester: compare 6 prices side by side, with the units needed to hit your monthly goal

• Scaling recipe card: pick a recipe and a multiplier (½x, 2x, 3x); quantities and costs update, print-ready

• Ingredient stock on hand with reorder alerts

• Dashboard with margins, weakest product, best profit and charts; flags unit mismatches

✦ WHY IT'S DIFFERENT

• Converts cups to grams with your own densities, so mixed units cost correctly

• 6-price tester with goal math, plus a scaling recipe card

• Stock and reorder alerts built in

• Both Google Sheets and Excel

✦ HOW IT WORKS

1. Buy and download your files instantly after checkout.

2. Upload the .xlsx to Google Drive and open it with Google Sheets, or open it in Excel.

3. Follow the Start Here tab. Everything else calculates.

✦ GOOD TO KNOW

• Instant download: nothing physical is shipped.

• Works in Google Sheets (free) and Microsoft Excel 2016+ / Microsoft 365 / Excel for the web. Not compatible with Apple Numbers.

• Works on desktop and in the Google Sheets and Excel phone apps (a computer is easiest for setup).

• No macros. Example and blank versions included. Licensed for one person or one business.

• Record-keeping and planning tool, not tax, legal or financial advice.

• Questions? Message me. I usually reply within a day.

© SageAndSheets. Please do not share or resell. Because this is a digital download, refunds aren't offered, but if anything isn't working, message me and I'll make it right.