Recipe Cost Calculator Excel Spreadsheet for Home Bakers

Find out what every recipe really costs to make, and what to charge for it. Enter what you paid for each ingredient once. Then build recipes from a dropdown and the calculator does the math: cost per batch, cost per serving, and a suggested price from your markup %.

What's inside:

• Ingredient price list for up to 100 items. Cost per unit is worked out from any package size (g, ml, oz, cups, each...)
• 3 recipe cost cards with ingredient dropdowns, 30 lines each. Duplicate a tab to add more
• Batch cost, cost per serving, suggested price per serving and per batch, profit, and margin
• Space for extra per-batch costs like liners, boxes and toppers
• Recipe Summary tab that compares all your recipes side by side
• Step-by-step Instructions tab, color-coded input cells, and sample data so you can see how it works

What you receive:

• 1 spreadsheet file (.xlsx): Recipe-Cost-Calculator.xlsx, with 6 tabs (Instructions, Recipe Summary, Ingredients, Recipe 1-3)

Works with: desktop spreadsheet apps and online spreadsheet tools that open .xlsx files. Formulas recalculate on their own. A computer is recommended for editing.

Digital download only. Nothing will be shipped. Once your payment goes through, you can download the files using your download link (also emailed to you).

Made with AI help: These templates were designed with AI assistance. I then reviewed, tested and finished them by hand.

Terms: For personal use or use in your own single business. Please don't resell, share or redistribute the files. Because this is a digital item, I can't accept returns. If anything isn't working, message me and I'll help.