Recipe Cost Calculator Spreadsheet, Bakery Pricing Template, Recipe Costing Sheet Google Sheets Excel, Home Baker Cake Pricing

Recipe cost calculator spreadsheet for Google Sheets & Excel: price every bake from ingredients, packaging, time and overhead, with 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 (Etsy: You › Purchases › Download Files).
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.