Pricing a food product is two sums. The first is cost: what the batch used, divided by the units it filled, plus packaging, your time and overhead. The second is what each price leaves once the fees of that channel are taken off, because a bag sold at a market, online, to a shop and to a distributor are four different sales. In the example below, a 12 oz bag of granola costs $5.91 to make. It leaves $3.79 at a market, $4.21 online, 59 cents to a shop and loses 71 cents to a distributor. Most pricing mistakes are made by doing only the first sum. The calculator does both: type in a batch, and it shows a row for every channel.
The short version
- Cost a unit = (ingredients ÷ units filled) + packaging + time + overhead.
- Each channel has its own price and its own fees. Give each a row.
- Margin = what's left ÷ the price.
- A shop pays about half the shelf price. A distributor pays less again.
- If you want to be in shops, work back from the shelf price before you set a retail price.
- TaroStack keeps the cost a unit current, from what you actually paid. More below.
Sum one: what a unit costs
A made-up granola maker. One batch bakes out to 8,400 g and fills 24 bags of 340 g.
| What goes in | Amount | You pay | Cost in the batch |
|---|---|---|---|
| Rolled oats | 3.78 kg | $82.50 for 25 kg | $12.47 |
| Honey | 1.44 kg | $60.50 for 5 kg | $17.42 |
| Almonds, sliced | 1.08 kg | $71.50 for 5 kg | $15.44 |
| Coconut oil | 0.9 kg | $35.20 for 4 kg | $7.92 |
| Pumpkin seeds | 0.72 kg | $26.40 for 2 kg | $9.50 |
| Dried cranberries | 0.72 kg | $49.50 for 5 kg | $7.13 |
| Brown sugar | 0.27 kg | $4.60 for 2 kg | $0.62 |
| Salt and cinnamon | $0.84 | ||
| Ingredients, the batch | $71.36 |
| For one bag | |
|---|---|
| Ingredients | $2.97 |
| Pouch and label | $0.52 |
| Time: 2 hours a batch at $20 | $1.67 |
| Overhead: $18 a batch | $0.75 |
| Full cost | $5.91 |
The batch goes into the oven at 9,000 g and comes out at 8,400 g. Bags come from the baked weight. Getting from a kitchen recipe to this table is in recipe multiplier calculator.
Sum two: what each channel leaves
| Where it sells | Price | Fees | Left a bag | Margin |
|---|---|---|---|---|
| Farmers market | $10.00 | 3% | $3.79 | 38% |
| Online | $11.00 | 8% | $4.21 | 38% |
| Wholesale to a shop | $6.50 | $0.59 | 9% | |
| To a distributor | $5.20 | -$0.71 | -14% |
Direct sales work. Wholesale barely does, and the distributor price loses money. That's the usual position of a maker who priced for the market and was then asked for a wholesale sheet.
Working back from the shelf
Shops and distributors each take a share, so the shelf price sets what you're paid.
| The usual shares | For a $9.99 shelf price | |
|---|---|---|
| Shelf price | $9.99 | |
| Shop pays, buying direct | About 60 to 65% of shelf | about $6.25 |
| Distributor pays | About 75 to 80% of what the shop pays | about $4.90 |
Those shares vary by shop and by category, so ask. But the shape holds, and it gives you a test: can you make the bag for well under what a distributor would pay? Here the answer is no. $5.91 is more than $4.90.
Three ways out, in the order most makers try them:
| Change | Full cost a bag |
|---|---|
| As above | $5.91 |
| A double batch in three hours, not four | $5.49 |
| And almonds, honey and pouches bought in bulk, about 15% less | $5.21 |
| And a 10 oz bag at the same price | about $4.40 |
Bigger batches spread the time. Bulk buying cuts the two dearest ingredients. A smaller bag is the lever the big brands use, and it's the one that gets you under $4.90. None of these is free: they need cash, storage and a new label. That's the real decision a wholesale price sheet is asking for.
Two words that get mixed up
Markup is what's added to cost: a $5.91 bag sold at $10 has a 69% markup. Margin is the share of the price that's left: the same sale has a 41% margin before fees. Buyers talk in margin. If a shop says it needs 40%, it means it will pay 60% of the shelf price. The two are worked through in cost-plus pricing example and keystone pricing.
Get the calculator
Download the food pricing calculator. Two sheets and a read-me: the batch cost, where you type each ingredient, what you paid and how much the batch used, and the prices, with a row for each channel showing what's left and the margin. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers. The same costing sheet without the food example is in batch cost calculator, and granola's own pricing in how to price granola.
Where this stops working
A price sheet sent to a buyer is a promise for six months or a year. The almonds it was built on are a price from one invoice. When they go up 12% in March, the 59 cents is gone and nothing on the spreadsheet says so, because the spreadsheet still has the old number in it.
How TaroStack does it
TaroStack keeps the cost under the price sheet honest.
The recipe is by weight, with versions. Change the almonds and it's a new version, with the old one kept.
Cost follows what you paid. Each delivery records its price, freight included. Each batch is costed from the lots it used, so the cost a bag moves when the almonds do.
Actual against standard. Every batch shows what it cost beside what the recipe said, so a drift is seen in weeks, not at year end.
A price-creep report shows each supplier's prices rising over time.
Margins on what things actually cost, by customer, so the shop paying $6.50 is seen for what it leaves.
| The job | Calculator | In TaroStack |
|---|---|---|
| Cost a bag | The day you typed it | From the lots each batch used |
| Almonds went up | Nobody retyped it | The next batch costs more |
| Is wholesale still paying? | Unknown | Margins on real cost |
| Which supplier is creeping | Compare invoices | The price-creep report |
TaroStack costs ingredients and packaging. Your time and overhead are yours to add, as above. Recipes, batches 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.
