Inventory reorder planner: fictional demo

Self-directed fictional demonstration, created with AI assistance. No client data or claimed client results.

A one-sheet Excel reorder planner for 14 fictional home-goods SKUs. Editable stock, commitments, incoming units, target levels and pack sizes feed live formulas. Suggested orders fill the target gap and round up to full supplier packs.

The example contains 12 complete rows and 2 rows needing clarification. Seven valid SKUs suggest 96 units. Missing inputs stay unknown; a confirmed zero remains valid. Invalid quantities and duplicate SKUs block the affected suggestions.

All 14 calculations were checked. Changing stock from 18 to 30 changes the first suggested order from 18 to 6. Blank-to-zero, zero pack-size and duplicate-ID cases were also tested, then restored.

This fixed 14-row demonstration does not forecast demand or account for supplier lead times. Additional rows need formula and summary-range extensions. Calculations and rendering were checked with Artifact Tool; native Excel interaction was not tested.