LumenProcess Manager

Free tool · Inventory

ABC/XYZ Inventory

Classify the SKUs of your warehouse by the value they consume in a year (ABC) and by how steady their demand is (XYZ). Paste or open the demand per week or month, and see the nine cells with the policy for each, how often to count every class, the safety stock and reorder point of every SKU at the service level you choose, which SKUs are below it now, and which belong in the golden zone nearest dispatch.

1 · Your SKUs

One row per SKU: SKU, description, unit cost and the demand of each week or month, one column per period. Lead time in days, its spread, stock on hand and picks are optional. With a header row the columns are matched by name; without one the order is SKU, description, unit cost, then the periods.

2 · Settings

Defaults: A up to 80 %, B up to 95 %; X up to a CV of 0.5, Y up to 1.0; counts 12, 4 and 1 a year (monthly, quarterly, yearly).

3 · Classified SKUs

No SKUs yet. Open a file or paste the rows above, or .

Feedback

Did this tool help you?

Your work

All your work in one file

Every tool keeps your work only in this browser. Save it as one file to keep a copy, to carry on from another phone or computer, or to hand it to a colleague. Nothing is uploaded.

Team sync Off

Share the tools you choose with your team: every device keeps working without a connection and syncs when it can. The work is encrypted on this device with a key made from the team code, so the server cannot read it.

Process Manager

More from Lumen

Open the planet: routine, learning, next orbit