Recipe Cost Calculator for Home Bakers (Excel & Google Sheets)

INSTANT DOWNLOAD: digital spreadsheet; nothing is shipped.

How much does one cookie really cost you? Enter what you pay for each ingredient and packaging item once, build your recipes from drop-down lists, and the spreadsheet works out the cost per item. It includes your time and overhead and suggests a price for the profit margin you want. Made for home bakers, cottage bakeries and anyone selling at markets, bake sales or to friends.

AI disclosure: this item was created with the use of AI. LB3 Trackers designed it with AI assistance: AI tools helped write the formulas, layout and instructions.

What's included:

- Instructions tab

- Ingredients & packaging list (100 rows): package size, unit and price give the cost per gram, ml or each. Units: g, kg, oz, lb, ml, L, fl oz, gal, each, dozen

- 6 recipe tabs: 20 ingredient lines, 6 packaging lines, your time x hourly rate, overhead %, yield, cost per item, suggested price for your target margin, your price, profit per item and per batch

- Price Summary: all recipes side by side, with a red highlight if a price is below cost

- Update an ingredient price once and every recipe updates

Format: one ZIP file with a BLANK .xlsx, a SAMPLE .xlsx (example prices and two made-up recipes) and a README. Works in Microsoft Excel, Google Sheets (upload to Drive, then open with Google Sheets), LibreOffice and Numbers. No macros. Weigh ingredients in grams for best accuracy; cup measures aren't converted.

Please note: this is a costing tool, not legal, tax or business advice. Check your local rules (for example cottage food laws) before selling food.

Instant download: after payment you get a download link right away.

Questions or a problem with the file? Message us through the store contact page. If the file doesn't work for you, we'll fix it or refund you.

License: personal use. Please don't resell, share or re-upload the file.