Skip to content
Berri
Sign in Try Berri
Sign inTry Berri

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 Berri

Tips

  • 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.
What Berri sends back
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:

VehicleRouteDropsLoad
Truck 1Nashik, Sinnar68.8 t
Truck 2Ahmednagar, Shirur58.9 t
PickupCity drops73.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.

Your own job, in your own words.

Try Berri