Hong Life CalculatorsUnderstanding the food wholesale margin and spoilage calculator — concept and principle
Fresh produce, meat, fish and bakery goods lose weight and value between purchase and sale: some spoils, some is trimmed, some dries out. This calculator shows the margin you really earn once that loss is counted, next to the margin you would believe if you ignored it. Wholesalers, grocers and restaurant buyers use it to set selling prices and to see how much a reduction in waste is worth. It works with any currency and any unit (kg, lb, case) as long as purchase and selling prices use the same unit.
How it is calculated
- Cost per sellable kg = purchase cost ÷ (1 − loss%/100)
- Real margin = (selling price − cost per sellable kg) ÷ selling price × 100
- Margin ignoring loss = (selling price − purchase cost) ÷ selling price × 100
The loss percentage is the share of purchased weight that never gets sold, by spoilage, trimming or shrinkage.
The principle
You pay for every kilogram you buy, but you only earn on the kilograms you sell. If 8% is lost, each purchased kilogram yields 0.92 kg of saleable product, so the cost has to be spread over less weight: dividing by (1 − loss) does exactly that. Note that this is not the same as adding 8% to the cost; the division gives a slightly larger increase (about 8.7% here). Margin is measured on the selling price, the usual retail and wholesale convention, not as a markup on cost.
Worked example
- Saleable share = 1 − 0.08 = 0.92.
- Cost per sellable kg = 3.2 ÷ 0.92 = $3.48.
- Real margin = (4.5 − 3.478) ÷ 4.5 × 100 = 22.71%.
- Margin ignoring loss = (4.5 − 3.2) ÷ 4.5 × 100 = 28.89%.
An 8% loss wipes out about 6 percentage points of margin, roughly a fifth of the gross profit.
How to read the result
The gap between the two margins is the cost of waste. If the real margin does not cover storage, transport, labour and overhead, raise the price, buy smaller quantities more often or reduce the loss. Track the loss rate per product: leafy greens and fish usually lose far more than root vegetables or frozen goods.
Common mistakes
- Adding the loss percentage to cost instead of dividing by (1 − loss).
- Confusing margin (on price) with markup (on cost).
- Using a single average loss rate for very different products.
- Forgetting that markdown sales of near-expiry stock also reduce margin.
Frequently asked questions
What loss rate should I use?
Measure it: weigh what you buy and what you actually sell over several weeks. Use the figure per product category.
How do I find the price needed for a target margin?
Price = cost per sellable kg ÷ (1 − target margin). For a 30% margin here: 3.478 ÷ 0.7 ≈ 4.97.
Does moisture loss count?
Yes. Any weight bought but not sold, including drying, trimming and samples, belongs in the loss rate.
Sources: Datar & Rajan, Horngren's Cost Accounting (Pearson) · FAO, The State of Food and Agriculture 2019: Moving forward on food loss and waste reduction