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
| Input | Value |
|---|---|
| Fixed route costs | 300 |
| Attempted stops | 100 |
| Variable cost per attempted stop | 2 |
| Successful deliveries | 80 |
| Result | Value |
|---|---|
| Cost per successful delivery | 6.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.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Fixed route costs | 300 | 330 | Cost per successful delivery | 6.25 | 6.625 |
| Attempted stops | 100 | 110 | Cost per successful delivery | 6.25 | 6.5 |
| Variable cost per attempted stop | 2 | 3 | Cost per successful delivery | 6.25 | 7.5 |
| Successful deliveries | 80 | 88 | Cost per successful delivery | 6.25 | 5.681818 |
