Stock & Reorder Planner

Step 1. List your products
Hi, I'm Alex. Save your own copy, then open Stock register. Replace the examples and enter each SKU once, with its product name and supplier. The register covers one hundred SKUs.

Step 2. Enter stock and demand
Enter stock on hand, committed quantity and quantity already on order. Add average daily demand, supplier lead days, safety quantity and your chosen cover days. Enter unit cost in column P.

Step 3. Read the suggested order
Available stock is on hand, less committed stock, plus stock on order. The suggested order covers lead time, cover days and safety stock when the reorder point is reached.

Step 4. Resolve warnings
Review the Action column for missing inputs, duplicate SKUs or negative stock. Enter valid zero values where appropriate. Leave the calculated columns K to O intact.

Step 5. Review before ordering
Open Stock dashboard to see stock value, SKUs to reorder and suggested order cost. Check supplier minimums and delivery timing before ordering. This is a stock snapshot, so update quantities manually as stock changes.