Bakery Pricing Calculator Spreadsheet, Recipe Costing, Profit Margin Tool, Google Sheets Excel

Price every loaf, dozen and box so you actually get paid for your time.

Flour, butter, eggs, chocolate, liners, boxes, your minutes of work, packaging, overhead and Etsy fees. This calculator adds it all up and tells you the minimum price that still hits your target margin. In the example data, a 6-pack of vanilla cupcakes at $12 LOSES $4.38 per sale: 30 minutes of work at $20/hour is $10 of labor before a single egg is counted.

WHAT IT DOES
✓ Ingredient library already set up for baking: cost per gram of flour and butter, per egg, per ml of vanilla, per liner and box, worked out from pack prices
✓ Recipes: list what each bake uses (e.g. 280 g flour + 170 g butter + 200 g chocolate chips + 1 egg + 1 box) and the material cost is totalled for you
✓ Adds your labor (minutes × hourly wage), packaging, overhead % and marketplace fees
✓ Gives the MINIMUM price for your target profit margin
✓ Suggests wholesale and retail prices for cafes, markets and craft fairs
✓ Instant verdict on your current price: Healthy, Raise price or LOSING MONEY

Note: ingredient prices in the example are typical US restaurant-supply prices. Type in what you actually pay; when butter or flour goes up, update one pack price and every bake re-prices itself. Check your local cottage food rules separately; this is a pricing tool, not a legal one.

WHAT YOU GET
• Excel file (.xlsx)
• PDF with your Google Sheets "make a copy" link and a setup guide
• Example bakes already filled in (artisan bread loaf, chocolate chip cookies by the dozen, vanilla cupcakes 6-pack), so clear the yellow cells when you're ready to add yours

WORKS WITH
Google Sheets (free) and Excel 2016+/Microsoft 365, on Mac, Windows, iPad and Chromebook.

Made by Ahmed (finance + automation). Questions? Message me and I'll reply within one business day.
Digital download, nothing shipped. Not affiliated with Etsy, Inc.