Calculate usable-unit cost after import damage
Measure an imported order against units you can actually use, then separate confirmed recoveries from unresolved claims.
A low invoice price can become an expensive purchase when cartons are short or goods arrive unusable. Divide the order’s attributable cost by accepted, usable units, not simply the quantity printed on the purchase order. Keep a second, clearly labeled scenario for possible recoveries. A claim submitted is not cash recovered.
This calculation helps a buyer decide whether to replenish, accept a supplier’s proposed remedy or change the next order’s packing and inspection plan. It is a purchasing measure, not a substitute for your accountant’s inventory valuation policy.
Start with a receiving count that balances
Record these totals for each SKU, keeping accepted, held and rejected quantities mutually exclusive within the received total:
- Ordered quantity
- Quantity physically received
- Received and accepted for the intended use
- Received but held for assessment
- Received and rejected
- Missing quantity
Received quantity should equal accepted plus held plus rejected. Ordered quantity should equal received plus missing, after accounting for any agreed split delivery or order amendment. Record units consistently: a carton, set and individual component are not interchangeable.
Do not count an item as usable just because it is physically present. It must meet the acceptance criteria agreed for its purpose. Conversely, cosmetic packaging damage does not necessarily make the product unusable. Record packaging and product condition separately, with photographs and carton identifiers. The ITA packing-list guidance explains how package contents, weights and measurements support inspection. Your receiving log adds actual findings to the supplier’s declared shipment record.
Keep disputed stock out of the accepted bucket until an appropriate assessment resolves it. For unsafe, recalled, battery-containing or other safety-relevant goods, obtain qualified handling and assessment guidance. Do not energize or casually repair suspect goods to improve the denominator.
Build the numerator without counting the same cost twice
For a purchasing comparison, assemble product payment, attributable origin services, freight, destination services, duties, non-recoverable taxes and final delivery. Include additional inspection, sorting or remedy spending only when actually incurred or explicitly labeled as a forecast.
A delivered supplier price may already contain some freight or services. Trace each amount back to an invoice or agreed quote before adding it. Keep recoverable taxes separate from permanent cost when their treatment has been confirmed for your circumstances. This article does not determine whether any tax is recoverable.
Use three views rather than one optimistic number:
- Current gross cost: costs incurred, before recovery
- Current net cost: incurred costs less refunds or credits that have actually been realized and allocated to this order
- Forecast outcome: current cost plus expected remedy spending, less explicitly conditional recoveries
A credit usable only against a future purchase is not identical to a cash refund. Show its terms and practical value separately. Do not subtract a supplier credit and an insurance payment for the same loss without confirming how the arrangements interact.
Hypothetical calculation: 500 ordered, 440 usable
The following USD amounts are invented solely to demonstrate arithmetic, not actual rates or a supplier offer. Assume all costs shown are attributable to this order, and exclude recoverable taxes, financing costs and lost sales.
- Ordered: 500 units
- Received: 480 units
- Accepted: 440 units
- Rejected: 30 units
- Held for assessment: 10 units
- Missing: 20 units
- Product payment: $2,500
- Freight and other attributable landing costs: $1,000
The count balances: 440 + 30 + 10 = 480 received; 480 + 20 = 500 ordered.
Invoice-style landed cost per ordered unit is $3,500 ÷ 500 = $7.00. Current gross cost per accepted unit is $3,500 ÷ 440 = $7.95, rounded to cents. That is approximately 13.6% higher, even though the freight bill has not changed.
Now suppose a $200 cash refund is actually received. Current net cost becomes $3,300 ÷ 440 = $7.50. If the ten held units are later accepted without additional spending, the same net cost becomes $3,300 ÷ 450 = $7.33. These are separate outcomes, not numbers to combine.
A proposed free replacement shipment requires its own calculation. If 20 usable replacements arrive and an additional $120 delivery cost is paid, the original 440-unit baseline becomes ($3,500 + $120) ÷ 460 = $7.87. This scenario assumes no refund and no change to the ten held units. A free product replacement therefore does not necessarily restore the original $7.00 economics.
Decide which action improves the position from today
Historical usable-unit cost reveals what happened, but a remedy decision depends on future spending and useful output. An extra delivery that lowers the blended average may still be worse than buying the few urgently needed units locally. Compare the incremental cost, timing and accepted quantity of each option.
For mixed-SKU orders, allocate shared freight using a documented basis that resembles how the freight was charged. A bulky item and a dense item may consume transport capacity differently. Do not allocate every shared cost by purchase value merely because the spreadsheet makes it easy. Keep the method consistent when comparing suppliers.
Keep claim value separate from proof of entitlement
Retain order specifications, packing list, commercial invoice, payment evidence, transport documents and dated receiving evidence. Check the actual supplier agreement, carrier conditions and insurance policy for required notice and evidence. There is no universal claim deadline in this worksheet.
ICC’s explanation makes clear that Incoterms do not replace wider sales-contract terms or automatically bind insurers and carriers. Likewise, FedEx’s US declared-value guidance distinguishes declared value from insurance and does not promise reimbursement. Neither a delivery term nor a value on a waybill settles your claim by itself.
Before the next order, share the balanced count and cost worksheet with the supplier or sourcing representative. Ask for a written, costed remedy and changes to the specific packing or verification step that failed. The useful output is an agreed next action, not a lower-looking average built on unconfirmed recoveries.
Frequently asked questions
Should I divide by received units or usable units?
Use accepted usable units for this purchasing measure. Track received, held, rejected and missing quantities separately so the denominator remains auditable.
Can I subtract a claim before it is paid?
Show it in a labeled forecast scenario. Keep the current-cost view based on realized recoveries and distinguish cash from restricted credits.
Does a free replacement make the loss disappear?
No. Include incremental freight, handling and assessment costs, and count replacements only when accepted. The original damage may also have caused timing costs.
What if no units are usable?
Cost per usable unit is undefined when the denominator is zero. Report the incurred loss and evaluate recovery or replacement options separately.
Sources
Discuss a sourcing request related to this article.Calculate usable-unit cost after import damage