Case price vs unit cost: how to price products bought by the case
If the cost in your sheet is the case price, every selling price built on it is wrong. One division fixes it.
· 4 min read
Wholesale invoices price by the case. Your customers buy one bottle, one packet, one bar of soap. If the price you mark up is the case price, your shelf price is many times too high — or, worse, a unit price gets typed in by hand and nobody remembers which products are which.
The formula
Unit cost = case price ÷ units in the case.
The units are in the pack size. 24 × 100 g means 24 units of 100 g. At €16.80 for the case, one unit costs €16.80 ÷ 24 = €0.70.
Packs inside packs
Some packs have two levels: 2 × 12 × 231 g is two trays of twelve, so 24 units. Multiply every count before the size: 2 × 12 = 24. A pack written as just 1 kg is a single unit.
| Pack on the invoice | Units | Case price | Unit cost |
|---|---|---|---|
| 24 × 100 g | 24 | €16.80 | €0.70 |
| 12 × 500 g | 12 | €36.00 | €3.00 |
| 2 × 12 × 231 g | 24 | €33.60 | €1.40 |
| 1 kg | 1 | €10.40 | €10.40 |
Where the pack size hides
Some suppliers give the pack its own column (Pack, Embalagem, Inhoud). Others write it inside the description: “Red Tea ( 24 × 250 g )”. Either way the number is there — it just has to be read for every line. The same unit cost is what lets you compare two suppliers fairly, because a cheaper case can still be a dearer unit.
How SAMZY does it
When you create a sheet from a supplier invoice, SAMZY reads the pack size from its own column or from the description, counts the units (2 × 12 = 24) and divides the case price for you. It can also write the units into a column of your template, so you can see how each cost was worked out. Your markup formulas then start from the right number.
Questions
- How do I calculate the cost per unit from a case price?
- Divide the case price by the number of units in the case. For 24 × 100 g at €16.80, that is €16.80 ÷ 24 = €0.70 per unit.
- What about packs like 2 × 12?
- Multiply the counts: 2 × 12 = 24 units. The last number with a unit, like 231 g, is the size of one unit, not a count.
