Skip to content
Haul bookkeeping · COGS math

Bulk lot & haul COGS splitter

A $150 thrift box with 25 pieces does not give every item a $6 cost basis if one piece is a $120 jacket and another is a $10 accessory. The total cost is the same, but the per-item numbers are not.

Split the lot equally or weight each item by its expected resale price. Add tax, hauling and cleaning costs, then get a per-item COGS, gross profit and margin table you can use for pricing and bookkeeping.

25-item haul exampleEqual or weightedPer-item margin

How to use this calculator

Three steps to a reliable answer.

Quick guide
  1. 1Enter the total lot cost and the number of items.
  2. 2Choose equal allocation or weighted by expected resale price.
  3. 3Review per-item COGS, gross profit and margin before pricing the haul.

Allocation does not change total profit; it changes each item's cost basis. Weighted allocation puts more cost on the pieces expected to bring the most revenue.

Lot inputs

Recalculates as you type.

$

What you paid for the lot.

$

Tax, hauling, cleaning.

items

1–100 items. Add or remove rows instantly.

Allocation method

Every item receives the same share of the total cost.

Total cost to allocate

Lot + extra costs$150.00

COGS allocated across 25 items

$150.00

Allocated cost reconciles to the total.

Equal split

Average COGS

$6.00

Expected resale

$1,064.00

Projected gross

$914.00

Projected margin

85.9%

Equal split

$6.00 per item

Weighted range

$1.41–$16.92

Gross profit here is expected resale minus allocated lot cost. It does not subtract platform fees, shipping or your labor.

Item-by-item COGS

Edit expected sale prices to reprioritize the weighted split.

Equal allocation
ItemExpected sale ($)Allocated COGSGross profitMarginCost share
#1$6.00$59.0090.8%4.0%
#2$6.00$39.0086.7%4.0%
#3$6.00$22.0078.6%4.0%
#4$6.00$114.0095.0%4.0%
#5$6.00$12.0066.7%4.0%
#6$6.00$29.0082.9%4.0%
#7$6.00$16.0072.7%4.0%
#8$6.00$34.0085.0%4.0%
#9$6.00$9.0060.0%4.0%
#10$6.00$49.0089.1%4.0%
#11$6.00$24.0080.0%4.0%
#12$6.00$19.0076.0%4.0%
#13$6.00$74.0092.5%4.0%
#14$6.00$6.0050.0%4.0%
#15$6.00$32.0084.2%4.0%
#16$6.00$44.0088.0%4.0%
#17$6.00$14.0070.0%4.0%
#18$6.00$26.0081.3%4.0%
#19$6.00$36.0085.7%4.0%
#20$6.00$89.0093.7%4.0%
#21$6.00$4.0040.0%4.0%
#22$6.00$22.0078.6%4.0%
#23$6.00$54.0090.0%4.0%
#24$6.00$18.0075.0%4.0%
#25$6.00$69.0092.0%4.0%

Total allocated $150.00 of $150.00

Blank prices count as $0 in weighted mode.

Two ways to split a haul

Allocation does not change total profit. It changes which item looks profitable, which one needs a price cut and which one should have stayed at the bottom of the bin.

Equal split

Divide the total cost by the item count. Best when the pieces are similar, when you have not priced them yet, or when you want one simple cost basis for every item.

Weighted by expected price

Give each item a share of the cost based on its expected resale value. A $120 jacket absorbs more of the haul than a $10 accessory, which makes per-item margins more honest.

What belongs in the lot cost

COGS starts with the purchase price, but the haul is not free to move, clean or store. Put the supporting costs in the same pool so the per-item number reflects the full cost of getting it listed.

Purchase price

The number on the receipt or the winning bid. This is the base cost every item shares.

Buyer premium and tax

Auction premiums, sales tax and card fees are part of what the haul cost you. Add them before allocating.

Hauling and prep

Van rental, fuel, parking, storage, cleaning supplies and repairs all help turn the lot into sellable inventory.

Worked example

$150 across 25 items

Equal split: $150 ÷ 25 = $6.00 of COGS per item. If the 25 items are expected to sell for $1,064 total, projected gross profit is $914 before fees, shipping and labor.

Weighted split: the $120 item receives about $16.92 of the cost, while the $10 item receives about $1.41. The same $150 is allocated, but the high-value piece now carries more of the haul's cost and the cheap piece shows the margin that made it worth listing.

Equal COGS

$6.00

per item

Expected resale

$1,064.00

25 items

Projected gross

$914.00

before fees

Projected margin

85.9%

on resale

Which method should a reseller use?

Use equal allocation for cheap, similar lots where the record keeping matters more than precision. It is fast, defensible and keeps every item's cost basis stable when prices change during the listing cycle.

Use weighted allocation when the lot is mixed. A storage unit with furniture, tools and smalls is not a 1/40th-per-item business. Weighting by expected resale price keeps the expensive pieces from looking artificially profitable and the cheap pieces from looking like losses.

Dead stock still has a cost

An item that never sells keeps its allocated cost. In an equal split, that is an easy number to see: one unsold piece carries the same COGS as a sold one. In a weighted split, the unsold high-value piece can carry a large share of the haul, which is a warning sign rather than a bookkeeping error.

Review unsold inventory separately. Mark it down, bundle it or donate it, and keep the write-off visible so the next lot is priced against reality instead of the best-case resale total.

Next in the haul workflow

Price the item, then protect the margin

Once the per-item COGS is set, check the sale price after fees and see what a sizing return would cost before the first offer.

Shoe lots

Sneaker size cross-reference

Convert sizes and choose a box before listing the pairs from a shoe haul.

Labor check

Thrift flip hourly wage

A 25-item lot takes hours to clean, shoot and list. See what the haul pays per hour.

Bulk lot COGS FAQ

Equal vs weighted allocation, extra costs and unsold inventory.

How do I split the cost of a bulk lot across items?

Add the purchase price and any extra lot costs such as tax, hauling or cleaning supplies to get the total cost. Divide that total by the number of items for an equal allocation, or give each item a share of the total based on its expected resale price for a weighted allocation. The allocated costs should always add back to the total lot cost.

Should I use equal or weighted COGS allocation?

Equal allocation is fastest when the items are similar or you do not yet know which pieces will sell. Weighted allocation is more accurate for mixed lots because a $120 jacket absorbs more of the purchase cost than a $15 accessory. Pick one method and apply it consistently so your margins stay comparable across hauls.

Do I include tax, gas and supplies in the lot cost?

Yes. Add sales tax, buyer premiums, hauling, parking, cleaning supplies and other costs that were necessary to get the lot ready to sell. The calculator's extra-lot-cost field spreads those costs across the items using the same allocation method. Keep receipts so the total cost basis is documented.

Does weighted allocation change my total profit?

No. Allocation only changes how the same total cost is divided between items. Total lot profit is total expected resale minus total lot cost either way. Weighted allocation changes each item's gross profit and margin, which is why it matters for pricing, markdowns and deciding which pieces were actually worth sourcing.

What happens if some items never sell?

The unsold item keeps its allocated cost, so dead stock drags down the haul's realized profit. A weighted split can make that visible by assigning more cost to high-value pieces, while an equal split spreads the risk across everything. Review unsold items separately and write down or donate inventory you will not list.

Can I use this bulk lot allocation for taxes?

A reasonable, consistent cost-allocation method supports reseller bookkeeping and inventory records, but tax treatment depends on your entity, accounting method and country. Keep the lot receipt, item list and the allocation you used. This calculator is a bookkeeping aid, not tax advice.

Bulk lot allocations are estimates based on the costs and expected resale prices you enter. They do not account for unsold inventory, returns, platform fees or taxes. Use a consistent allocation method and keep lot receipts and item records. Not tax or accounting advice.

ResellCompass

The reseller workbench

The next flip starts with better math.

34 free calculators for fees, shipping, sourcing, listing research and client payouts. No account or spreadsheet needed.