Every liquidation reseller knows the feeling: you open a pallet, start pricing items, and later realize the numbers don't add up. You thought you'd make 60% margin. Your actual take-home tells a different story.
Almost always, the root cause is the same — cost per unit was calculated wrong, or not calculated at all.
According to the National Retail Federation's 2022 Returns Report, U.S. retailers processed $816 billion in merchandise returns — roughly 16.5% of all retail sales. That mountain of returned goods flows directly into the liquidation market as pallets, truckloads, and manifested lots. The resellers who profit consistently from that flow are the ones who get their cost math right, every single time.
The Core Formula
Simple in theory. The errors live in what "Total Lot Cost" actually means, and in what happens as you add items over time.
What Goes Into Total Lot Cost
Most resellers only count the purchase price. That's the first — and biggest — mistake.
Your true lot cost includes every dollar you spend to get that inventory into your hands and ready to sell:
- Purchase price — the hammer price at auction, or the negotiated invoice amount
- Buyer's premium — typically 15–20% on top of the auction hammer price, often overlooked
- Freight and shipping — a full pallet typically runs $150–$450 depending on distance and carrier
- Marketplace fees — if you paid a platform fee to access the listing
- Inspection or handling fees — some warehouse pickups charge a loading fee
A Complete Worked Example
Let's walk through a real scenario: a mixed electronics pallet purchased at auction.
| Cost Component | Amount |
|---|---|
| Auction hammer price | $1,200.00 |
| Buyer's premium (20%) | $240.00 |
| Freight (cross-province) | $310.00 |
| Total lot cost | $1,750.00 |
After unboxing, you count 43 items.
| Calculation | Result |
|---|---|
| Cost per unit (true) | $40.70 |
| Cost per unit (auction price only) | $27.91 |
| Difference per item | $12.79 |
If you price an item at $89.99 using the true cost, your margin is 54.8%. Price it using only the auction price and you'd calculate a 69% margin — while actually pocketing 13 percentage points less per sale. On 43 items, that gap compounds fast.
The "Items Added Later" Problem
Most resellers don't unbox an entire pallet in one sitting. You pull out 15 items on day one, then add 10 more on day two, then discover a box you missed on day three.
Here's what happens to your cost per unit when you do this manually:
- Day 1: 15 items counted → $1,750 ÷ 15 = $116.67/unit
- Day 2: 25 items total → $1,750 ÷ 25 = $70.00/unit
- Day 3: 43 items total → $1,750 ÷ 43 = $40.70/unit
Any prices you set on day one are based on $116.67/unit. By day three, the real cost is $40.70. Those early prices might be fine — or they might be wildly overpriced, costing you sales. You won't know unless you go back and recalculate every item manually.
Weighted Cost Per Unit (For Mixed-Value Lots)
Simple equal division works well when items in a lot are roughly equivalent. It breaks down when you have a highly mixed lot — say, 30 small accessories worth $8–$12 each alongside 3 high-end electronics worth $200+ each.
In that case, a weighted approach allocates cost proportionally to each item's estimated resale value:
- Estimate resale value for each group: 30 accessories × $10 = $300 total; 3 electronics × $200 = $600 total
- Total estimated resale value: $900
- Accessories share of cost: ($300 / $900) × $1,750 = $583 → $583 ÷ 30 = $19.43/unit
- Electronics share of cost: ($600 / $900) × $1,750 = $1,167 → $1,167 ÷ 3 = $389/unit
This gives a more accurate picture for pricing decisions, especially when a few high-value items represent the majority of a lot's worth.
The Four Mistakes That Kill Margins
- Not including freight and fees. The most common error. Understates cost by 20–40% on most lots.
- Averaging across multiple lots. Each lot has its own cost basis. Mixing them together means every item's cost is wrong.
- Setting prices before the full count is in. Early prices are based on incorrect (inflated) cost per unit from a partial count.
- Forgetting auction buyer's premiums. A 20% premium on a $1,500 lot is $300 — not a rounding error.
How to Track This Without a Spreadsheet
Manually recalculating cost per unit every time you add an item is not practical at scale. A spreadsheet can work for one or two lots, but as soon as you're running five, ten, or twenty active lots simultaneously, the math becomes a full-time job.
The cleanest approach: use software that recalculates cost per unit automatically every time you scan an item into a lot — and flags your selling price as red if it falls below your true cost.
That's exactly what StockDrive Pro does. You enter the total lot cost (including freight and fees) once when you create a lot. As you scan each item in, the cost per unit updates in real time. When you set a selling price, your margin appears instantly. If you add more items later, every item's true cost adjusts automatically.
No spreadsheet. No mental math. No margin surprises.
Stop calculating in spreadsheets
StockDrive Pro divides your lot cost automatically as you scan each item in. Real margins, every time.
Start Free Trial — No Credit Card