Inventory costing and margin analysis across 12,000 SKUs

Project Description

We know our overall margin and almost nothing about it per SKU, because landed cost, returns and platform commissions are never allocated properly. We want true per-SKU contribution after landed cost, returns, storage and channel fees, and a repeatable model rather than a one-off spreadsheet. We expect the answer to be uncomfortable — we suspect a chunk of the catalogue loses money. Please do not smooth that over.

Skills Required