Inventory change analysis: how to read the evidence
Compare inventory snapshots, normalize stock units, and check source evidence before treating a balance change as sales, demand or supplier risk.
Identify the entity and the comparison
A customer, supplier, and SKU have different histories. For inventory, the entity is often a SKU at a specific warehouse, observed on a report date. Compare like units and matching locations. Keep each snapshot’s source file and row so someone can check the original evidence.
Normalize the report before comparing it
Report-style spreadsheets can contain warehouse sections, subtotals, Buddhist Era dates, and case-plus-unit quantities. In a report that uses this convention, 39.31 with a 48-unit case means 39 cases plus 31 units, or 1,903 base units. Confirm the convention against the report totals. Preserve negative stock for review, and distinguish an omitted row from a recorded zero.
Separate the observation from the explanation
A stock balance can fall because of sales, transfers, returns, or adjustments. Inventory carrying cost can change without a new supplier price. To diagnose the cause, bring in receipts, sales, stock movements, purchase orders, or supplier terms. Until that context exists, label the observation as a balance or valuation change rather than a confirmed commercial outcome.
Choose expertise that fits the question
A procurement perspective can assess commercial terms. A supply-chain perspective can assess availability and replenishment. A customer-success perspective can interpret adoption and relationship context. Multiple perspectives can explain the same change differently; keep their evidence and uncertainty available to the person deciding what comes next.