Recipe Cost Calculator Google Sheets, Bakery Pricing Spreadsheet, Home Baker Order Planner, Ingredient Costing

Stop guessing what to charge for your bakes. Enter what you pay for ingredients and what goes into each recipe, and this Google Sheet works out the true cost per item (ingredients, your time, packaging and overhead), suggests a price at your target margin and shows your profit.

WHAT'S INSIDE (9 tabs)

- START HERE: quick setup steps and tips
- Dashboard: number of recipes, average cost per item, average margin, most profitable recipe, orders to bake, order revenue and profit, shopping estimate, cost breakdown per item, ingredient cost by category, cost vs price, top ingredients, margin by recipe and a most profitable list
- Price Calculator: pick any recipe to see the full cost breakdown, its ingredient list with the share of cost, prices at 25% to 60% margin and a price tester
- Recipes: category, items per batch, hands-on minutes, packaging and your price, with ingredients, labour, packaging, overhead, batch cost, cost per item, suggested price, profit, margin, profit per batch and a price check
- Recipe Ingredients: recipe, ingredient (dropdown) and quantity, with unit and cost filled in
- Ingredients: 50 common baking ingredients with example pack sizes and prices, cost per unit and cost per 100
- Batch Planner: customer orders with due date, items, price, status, batches, revenue, cost and profit
- Shopping List: baking plan and every ingredient you need for orders marked To bake, with packs to buy and cost
- Setup: currency, business name, labour rate, overhead %, target margin, default packaging, price rounding and your lists

HOW IT WORKS
1. After purchase, download the PDF from your Etsy account (Purchases and reviews).
2. Click the link. Google asks you to make a copy, which is saved to your own Google Drive.
3. Update the ingredient prices to what you pay, add your recipes and see the right price for every bake.

GOOD TO KNOW
- Two versions included: one with 13 sample recipes to explore and a blank one ready for yours (the ingredient list is kept as a head start)
- Great for home bakers, cake makers, cookie and cupcake sellers, market stalls and small food businesses
- Suggested prices are rounded up to the step you choose (for example 0.25)
- The shopping list counts whole batches and whole packs
- Pick your currency from a list of 25 symbols or type your own
- Works in Google Sheets on computer, tablet and phone. A free Google account is needed. Not made for Excel or Numbers
- Cells that calculate show a gentle warning if you try to edit them, so formulas are not deleted by accident
- This is a digital product. No physical item will be shipped
- For personal use only. Please do not share or resell
- Because this is a digital download, returns are not accepted. If you have any problem, message me and I will be happy to help