Perishable goods companies need to plan regular delivery runs to get stock to customers.
- Customers order normally on a regular cycle - it may be weekly, by weekly, monthly, daily etc.
- Telesales - there is a telesales cycle at the customer level including preferred day and frequency.
- Sales Rep - there is a sales rep visit cycle at the customer level including preferred day and frequency.
- Deliveries normally follow sales orders with a day or two delay
Hence customers need to be clustered for their order cycle with a reference to the possible delivery dates and times - so this determines the order cycles for the customers.
- The desire is to ensure the customer runs out of all stock around the same time - this helps to consolidate all required items onto a single delivery and reduces "urgent" deliveries. The system proposes an order based on individual SKU sell rates to assist in reducing deliveries.
- Not all customers order each time on the regular cycle - the order may be too small to avoid a delivery fee or sales may have been affected by some issue.
After contacting customers