Last-mile cost per successful delivery · Calculation guide

Include all attempted stops and their costs in the same route period.

Calculation guide

Divide the full route cost by successful deliveries only.

Cost per successful delivery = ((Fixed route costs + (Attempted stops × Variable cost per attempted stop)) ÷ Successful deliveries)

Inputs

Fixed route costs

Example entry 300 (in the selected currency).

Attempted stops

Example entry 100. Allowed range 1.0 to 10000000.0. Use whole numbers.

Variable cost per attempted stop

Example entry 2 (in the selected currency).

Successful deliveries

Example entry 80. Allowed range 1.0 to 10000000.0. Use whole numbers.

Worked example

InputValue
Fixed route costs300
Attempted stops100
Variable cost per attempted stop2
Successful deliveries80
ResultValue
Cost per successful delivery6.25

Calculation steps

Cost per successful delivery = ((Fixed route costs + (Attempted stops × Variable cost per attempted stop)) ÷ Successful deliveries)

((300 + (100 × 2)) ÷ 80) = 6.25

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Fixed route costs300330Cost per successful delivery6.256.625
Attempted stops100110Cost per successful delivery6.256.5
Variable cost per attempted stop23Cost per successful delivery6.257.5
Successful deliveries8088Cost per successful delivery6.255.681818
Last-mile cost per successful delivery →

Sources