The cost of an ingredient in a recipe is one sum: the amount you use, times what you paid for the pack, divided by how much is in the pack. Two and a half pounds of flour from a 25 lb bag that cost $18.50 is 2.5 × 18.50 ÷ 25, or $1.85. Do that for every line, add them up, divide by the number of pieces the batch makes, and you have the ingredient cost of one. The calculator below does the sums; the only work is typing what you paid. It's free, and the example is a batch of 48 chocolate chip cookies.
The short version
- For each ingredient: amount used × pack price ÷ pack size.
- Use the same unit for the amount and the pack size (pounds and pounds, not cups and pounds).
- Add the lines for the batch, then divide by the pieces it makes.
- Ingredients are the start. Packaging, your time and overhead come after.
- TaroStack works this out from your recipes and what you last paid, and updates it when a price moves. More below.
A worked example: 48 cookies
| What goes in | Amount | You pay | Cost in the batch |
|---|---|---|---|
| All-purpose flour | 2.5 lb | $18.50 for 25 lb | $1.85 |
| Butter | 2 lb | $4.20 for 1 lb | $8.40 |
| Brown sugar | 1.5 lb | $2.10 for 2 lb | $1.58 |
| Granulated sugar | 1 lb | $3.60 for 4 lb | $0.90 |
| Eggs | 4 | $3.60 for 12 | $1.20 |
| Chocolate chips | 2 lb | $9.80 for 2.5 lb | $7.84 |
| Vanilla extract | 1 fl oz | $11.00 for 8 fl oz | $1.38 |
| Baking soda and salt | $0.10 | ||
| Ingredients, the batch | $23.24 |
$23.24 over 48 cookies is 48 cents a cookie.
Two lines are 70% of it: butter at $8.40 and chocolate at $7.84. That's where to spend your attention. A better price on flour saves pennies a batch. A case price on butter saves dollars.
The unit trap
The sum only works when the amount and the pack are in the same unit. Recipes are written in cups; flour is sold by the pound. A cup of all-purpose flour weighs about 4.25 oz, but a packed cup weighs more, which is why costing by weight is worth the switch. Weigh each ingredient once as you make a batch, write the weights down, and cost from those. More on converting is in how to calculate cost per ounce.
For tiny amounts, don't chase precision. Baking soda and salt are ten cents here, entered as one line.
From ingredients to full cost
The calculator's lower half adds what the ingredient list leaves out:
| A cookie | |
|---|---|
| Ingredients | $0.48 |
| Your time (60 minutes a batch at $18 an hour) | $0.38 |
| Overhead (oven, kitchen), $4 a batch | $0.08 |
| Bag and label, shared by six | $0.07 |
| Full cost | $1.01 |
And what each price leaves:
| Where it sells | Price a cookie | Fees | Left | Margin |
|---|---|---|---|---|
| Market, half dozen for $12 | $2.00 | 3% | $0.93 | 46% |
| Café, wholesale | $1.25 | 0% | $0.24 | 19% |
The ingredient cost said 48 cents, and $1.25 looked like plenty. With an hour of your time in the batch, wholesale leaves 24 cents. That's the reason to finish the sum. How to set the price from here is in how to price cookies.
Get the calculator
Download the ingredient cost calculator. Two sheets and a read-me: the batch cost, where you type amounts and pack prices, and the prices, where you type what you charge. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers. The whole method, step by step, is in steps in recipe costing.
Where this stops working
Prices move. Butter was $4.20 when you filled in the sheet and $4.85 last week, and the sheet still says $4.20. With ten recipes sharing the same butter, that's ten sheets to update, so nobody does, and every cost you quote is from whenever you last had a free evening.
How TaroStack does it
TaroStack keeps ingredient costs current because it sees what you pay.
It costs from what you received. Each delivery is received at its price, freight included if you add it. The recipe's cost follows the stock you're really using, first in, first out.
Units convert themselves. Buy flour by the 25 lb bag, stock it by the pound, use it by the gram. You never do the division.
Every recipe updates at once. When butter goes up, each recipe that uses it shows the new cost. A price-creep report shows which supplier's prices have been climbing.
A photo is enough. Take a picture of a supplier's invoice or price list and its rows are read in for you to check before anything is saved.
Margins on real costs. Margins by product are reported on what things cost you this month, not on a number from last spring.
| The job | Calculator | In TaroStack |
|---|---|---|
| Pack price to recipe cost | You type each price | From what you received |
| A price increase | Edit every sheet | Every recipe updates |
| Cups, pounds, grams | Convert by hand | Converted for you |
| Which ingredient is creeping | Compare old sheets | A report |
TaroStack costs materials and packaging. Your own time and overhead are yours to add on top. Recipes and true cost are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes). The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.
