Report this item to Etsy

Recipe Cost Calculator Spreadsheet, Food Cost & Menu Pricing (Excel/Google Sheets)

Price:$6.99

Loading
Includes Etsy Purchase Protection

You can only make an offer when buying a single item

Highlights

  • Designed by Deftcell
  • Digital download
  • Digital file type(s): 1 PDF, 2 other files

Recipe cost calculator spreadsheet for Excel and Google Sheets: cost every recipe per batch, per unit and per serving, price it to your target food cost % or margin, and see which items need a new price when ingredient costs move.

Enter what you pay for each ingredient once. The workbook converts cups, tablespoons, ounces, pounds and grams for you, costs every recipe per batch, per unit and per serving, and suggests a price from your target food cost % or margin, rounded up to an ending like .49 or .99. When butter goes up, change one price: every recipe updates, and the Price Changes tab shows which ones fell below target.

WHAT'S INCLUDED
• Recipe-Cost-Calculator.xlsx: the blank workbook for your recipes (9 tabs)
• Recipe-Cost-Calculator-DEMO.xlsx: the same workbook filled with a fictional bakery (31 recipes, 48 ingredients), so you can see every feature working
• PDF guide: setup in 6 steps, every tab explained, and a link to make your own copy in Google Sheets

THE TABS
• Ingredients: your price list. Pack size, unit, price and usable yield (for example 85% for carrots after peeling) give the cost per gram, milliliter or piece
• Recipes: 40 recipe cards with 15 ingredient lines each. Batch yield, servings, packaging per unit and labor minutes give the cost per batch, per unit and per serving
• Pricing: suggested price from your target food cost % or target margin, rounded up to your price ending, plus the actual food cost %, profit and margin at your own price
• Menu Summary: every recipe with price, cost, food cost %, margin and an "on target / below target" flag, plus a menu engineering view (Stars, Plowhorses, Puzzles, Dogs) from the units sold you enter
• Price Changes: which ingredient prices changed, which recipes crossed their target and the price to raise to, plus a what-if stress test ("what if every ingredient costs 10% more?")
• Units: g, kg, oz, lb, ml, L, tsp, tbsp, fl oz, cup, pint, quart, gallon, each and dozen built in, with room for your own units (a "stick" of butter, a "flat" of eggs)
• Settings: currency symbol, default method and targets, price ending, labor rate and your category lists
• Start Here: quick start, FAQ, the formulas used, and the disclaimer

BUILT TO AVOID MISTAKES
• Cream cells are for you; gray cells are formulas. In Excel they're locked (no password), so you can't type over them by accident
• Dropdowns for ingredients, units, categories and pricing methods
• Check columns flag a missing price, an unknown unit, or a cup measure for an ingredient whose cup weight you haven't entered yet
• It never guesses a density: weight-to-volume conversions use the cup weight you enter for that ingredient
• No macros. Your data stays in your own file.

WHO IT'S FOR
Home bakers and cottage-food sellers, bakeries, food trucks, caterers and small cafés who want to set prices from real costs instead of guesses.

HOW DELIVERY WORKS
Instant download after purchase. You get the two .xlsx files and the PDF guide. Open the .xlsx in Excel, or follow the link in the PDF guide to make your own copy in Google Sheets. (You can also upload the .xlsx to Google Drive and open it with Google Sheets.)

WHAT IT ISN'T
Estimates only: the workbook calculates from the numbers you enter. It is not financial, tax or food-safety advice. It doesn't cover food safety, allergens, nutrition, labeling, permits or cottage-food rules. Prices are before sales tax; card or marketplace fees and overhead (rent, utilities) aren't included, so choose targets that leave room for them. The menu engineering view is a common restaurant heuristic, not a rule.

Designed and built by an AI agent, published by Deftcell (Elite Tech Global LLC); every formula is tested before release.

FAQ
• Does it work in Google Sheets? Yes. Every formula uses functions that both Excel and Google Sheets support. The PDF guide has a copy link.
• My recipes use cups, but I buy flour by the pound. Enter what one cup of that ingredient weighs (weigh one level cup of your own flour). The workbook then converts cups, tablespoons and teaspoons for that ingredient. Until you do, the recipe line tells you it needs the cup weight.
• Food cost % or margin? Both. Food cost % (price = ingredient cost ÷ target) is the common restaurant method. Margin % prices from the total cost, including packaging and labor. Pick a default and change it per recipe.
• How does rounding work? Suggested prices round up to the next price with your ending (.99, .49 or .99, .95, quarters, halves, whole numbers or multiples of 5), so they still meet your target. Your own prices are never changed.
• Does it work in metric or another currency? Yes. Grams, kilograms, milliliters and liters are built in, and you choose the currency symbol shown in headings. Amounts are plain numbers.
• How many recipes and ingredients? 40 recipe cards with 15 ingredient lines each, 200 ingredients and 10 units of your own. For a longer recipe, cost a part such as a frosting as its own recipe and add it to the price list.
• Does it work on a phone or tablet? It's designed for a computer. You can open it in the Excel or Google Sheets mobile apps to look things up, but setup is easiest on a larger screen.
• Can I change it? Yes. In Excel the sheets are protected without a password, so you can unprotect them to customize. Your Google Sheets copy is fully editable.
• Is my data shared? No. Everything stays in your own file. There are no macros or scripts.

REFUNDS
Because this is an instant digital download, returns and exchanges aren't accepted. If a file won't open or doesn't work as described, send us a message and we'll fix it or help you get it working.

Instant Download

Your files will be available to download once payment is confirmed.  Here's how.

Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases — see program terms

You may also like

Shoppers with similar taste loved these

Show more
Show more
Listed on Oct 4, 2026