Download the template that turns demand into a buy, and tells you the month each purchase order has to be issued for the units to land on time.
Each tab in the template handles one slice of the operating model — drop in your numbers and the rest updates itself.
Planned receipts are dated to arrival. The Place Order In row subtracts each supplier's lead time to give you the month the purchase order actually has to go out.
On a plan anchored to October with three and four month lead times, most of Q4 is already decided. Fifteen of ninety SKU-months read OVERDUE in the illustrative data.
A 24,000 unit minimum against 12,000 units a month of falling demand guarantees permanent excess. Every month where the minimum, not demand, sized the order is flagged.
Target plus safety ships at 3.25 months and lives in one cell. The illustrative brand buys 11% more units than it sells, because growth has to be financed with inventory.
Take a self-guided tour, or get a walkthrough tailored to your brand.
