Excavation truck dispatch balance calculator

Calculate trucks to balance observed output and fleet removal capacity with your own figures.

Your numbers

Use the units shown. Results update as you change valid inputs.

Use trucks to balance observed output and fleet removal capacity to compare changes to your inputs. The method and limits below explain the scope.

Examples

Examples

Try the starting example

Measured excavator output (m³/hour)
60
Truck usable capacity (m³)
12
Round-trip cycle including loading (minutes)
40
Scenario fleet (trucks)
3
Trucks to balance observed output
4
Fleet removal capacity (m³/hour)
54
Unremoved volume rate (m³/hour)
6
Fleet spare capacity (m³/hour)
0

Try another scenario

Measured excavator output (m³/hour)
60
Truck usable capacity (m³)
12
Round-trip cycle including loading (minutes)
40
Scenario fleet (trucks)
4
Trucks to balance observed output
4
Fleet removal capacity (m³/hour)
72
Unremoved volume rate (m³/hour)
0
Fleet spare capacity (m³/hour)
12
Calculation method

Calculation method

Trucks to balance observed output

ceil(a*c/(60*b))

Fleet removal capacity (m³/hour)

d*b*60/c

Unremoved volume rate (m³/hour)

max(0,a-d*b*60/c)

Fleet spare capacity (m³/hour)

max(0,d*b*60/c-a)

Symbols and units
a
Measured excavator output (m³/hour)
b
Truck usable capacity (m³)
c
Round-trip cycle including loading (minutes)
d
Scenario fleet (trucks)

Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.

Assumptions & limits

Assumptions & limits

  • Steady average cycle arithmetic; all capacities and rates measured or supplied, positive truck volume/cycle. No traffic, loading safety or dispatch optimization. Supported limits: All numeric inputs must be finite. Only the explicitly described mathematical scenario is supported.
Are these inputs private?

These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.

Share this page
Share this calculator

Leave unchecked to share the page without your entered values.