THE FEUTEX TOOLKIT

Fleet Route and Driver Plan

Plan route count and driver time from delivery stops and per-route limits.

Supply Chain workspace● Runs in your browser

01 Your input

StopsitemsStops routeitemsDrivinghours/routeService minutesminutes/stopShift hourshours/person

02 Your result

View or copy raw result data

Result data

Formula

Routes = Math.ceil(v.stops/v.stops_route) ; Driver hours = Math.ceil(v.stops/v.stops_route)*v.driving+v.stops*v.service_minutes/60 ; Drivers = Math.ceil((Math.ceil(v.stops/v.stops_route)*v.driving+v.stops*v.service_minutes/60)/v.shift_hours)

Sources and model references

https://openstax.org/books/principles-managerial-accounting/pages/7-2-prepare-operating-budgets

Worked example

Inputs

Stops: 180 items
Stops route: 30 items
Driving: 2 hours/route
Service minutes: 8 minutes/stop
Shift hours: 8 hours/person

Expected results

Routes: 6 items
Driver hours: 36 hours
Drivers: 5 people

Load the example in the workspace to reproduce these results. Display rounding does not change the underlying calculation.

How to use this tool

Enter your own assumptions using a consistent currency and period.
Review the scenario outputs and compare alternative inputs.
Check the stated model limits before using the result in an operating plan.

Try this example

{
  "stops": 180,
  "stops_route": 30,
  "driving": 2,
  "service_minutes": 8,
  "shift_hours": 8
}

Accuracy and scope

Aggregate labor estimate; does not optimize routing, assign routes to shifts or model statutory driving limits, breaks and time windows.

Is my data uploaded?

This tool runs locally in your browser. Input and output are not sent to a processing server. Copy or download your result before leaving the page.