Follow the screens at your own pace. Replace fictional examples with your own information.
Visual and written guide available below. Recorded narration is being prepared.
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.
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.
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.
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.
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.
These instructions cover the workbook version shown. Check the product listing for included formats. Google Sheets import and feature compatibility have not been independently verified for these versions.