Plan tomorrow’s dispatch from an order list
Group orders into loads by route and capacity.
- ForDistributors and warehouses that plan vehicles every evening.
- HelperDispatch Planner
- ModeBerri Mango 1
- AttachExcel sheet
Copy the prompt
These are tomorrow’s orders with customer town and weight. I have [vehicles and capacities]. Group the orders into loads by route so each vehicle is as full as possible, and list anything that does not fit.
Change the words in [brackets] to your own.
What to attach
An Excel sheet (.xlsx). Berri reads the first sheet, so keep the data there.
Run it
Berri opens with the prompt filled in and the Dispatch Planner helper picked. Nothing is sent until you press send.
Run this in BerriTips
- Add delivery time windows as a column and Berri plans around them.
- Ask Berri to check its plan again if anything looks wrong to you; the final call is yours.
Plan tomorrow’s dispatch from an order listDispatch Planner
XLSorders-21-nov.xlsx
These are tomorrow’s orders with customer town and weight. I have two 9 tonne trucks and one 4 tonne pickup. Group the orders into loads by route so each vehicle is as full as possible, and list anything that does not fit.
Reading orders-21-nov.xlsx
Three loads, 21.4 tonnes of 22 used:
| Vehicle | Route | Drops | Load |
|---|---|---|---|
| Truck 1 | Nashik, Sinnar | 6 | 8.8 t |
| Truck 2 | Ahmednagar, Shirur | 5 | 8.9 t |
| Pickup | City drops | 7 | 3.7 t |
One order of 1.2 t to Dhule does not fit. Send it with Friday’s Dhule load.
Figures here are made up to show the shape of the answer. Yours come from your own file and words.