I spent about 9 hours yesterday analyzing sales, order and forecast data for Walmart, Home Depot and Lowe’s vendors, and I am somewhat surprised by my observations. It’s pretty clear that there are some min/max rules in place, as I can see patterns to the order quantities based on the OH inventory and the order case pack quantities. However, what surprises me is that I also see a large number of what I would guess are “manual overrides.” That is UPC/stores which clearly need inventory and fall under the minimum OH of other stores, but which do not have an open order, and UPC/stores that are clearly overstocked (e.g. high WOS), and yet have an open order. It makes sense that there would be automated replenishment rules in place and then some lead-way for the buyer/replenishment manager to make judgment calls, so that leads me to my question….
What do you know about your key retail customer’s replenishment rules?
- Simple min/max ordering?
- Based on OTB dollars?
- WOS trigger?
- At what level is demand calculated? e.g. Category/Region, Category/State, Sub-category/State
- Under what situations will the buyer do a manual override?