Inventory
planning
A system I built to decide when to reorder and how much to buy.
Turning inventory data into purchasing decisions.
The existing inventory tool gave me forecasts and data I couldn't rely on. I built a parallel system in Google Sheets to bring sales, inventory, orders and shipments into one planning process.
For each SKU, it estimated the stockout date, whether a reorder was needed and the order quantity. It accounted for supplier lead times, safety stock, minimum orders and case sizes, and calculated landed cost per unit.
