Cash on delivery failed-delivery cost · Calculation guide

Outbound cost applies to every attempt. Failed orders incur return and unrecovered product costs.

Calculation guide

Successful orders produce a margin before fulfillment and collection fees.

Expected failed-delivery cost per attempt = Failed delivery rate / 100 × (Outbound cost per attempt + Return transport per failure + Unrecovered product cost per failure). Expected contribution per attempt = (1 − Failed delivery rate / 100) × (Successful merchandise margin − Collection fee per success − Outbound cost per attempt) − Expected failed-delivery cost per attempt

Inputs

Failed delivery rate

Example entry 20 %. Allowed range 0 to 100.

Outbound cost per attempt

Example entry 5 (in the selected currency).

Return transport per failure

Example entry 4 (in the selected currency).

Unrecovered product cost per failure

Example entry 3 (in the selected currency).

Successful merchandise margin

Example entry 25 (in the selected currency).

Collection fee per success

Example entry 2 (in the selected currency).

Worked example

InputValue
Failed delivery rate20%
Outbound cost per attempt5
Return transport per failure4
Unrecovered product cost per failure3
Successful merchandise margin25
Collection fee per success2
ResultValue
Expected failed-delivery cost per attempt2.4
Expected contribution per attempt12

Calculation steps

Expected failed-delivery cost per attempt = ((Failed delivery rate ÷ 100) × ((Outbound cost per attempt + Return transport per failure) + Unrecovered product cost per failure))

((20 ÷ 100) × ((5 + 4) + 3)) = 2.4

Expected contribution per attempt = (((1 − (Failed delivery rate ÷ 100)) × ((Successful merchandise margin − Collection fee per success) − Outbound cost per attempt)) − Expected failed-delivery cost per attempt)

(((1 − (20 ÷ 100)) × ((25 − 2) − 5)) − 2.4) = 12

How each input affects this example

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

InputOriginal inputNew inputAffected resultOriginal resultNew result
Failed delivery rate20%22%Expected failed-delivery cost per attempt2.42.64
Outbound cost per attempt56Expected failed-delivery cost per attempt2.42.6
Return transport per failure45Expected failed-delivery cost per attempt2.42.6
Unrecovered product cost per failure34Expected failed-delivery cost per attempt2.42.6
Successful merchandise margin2528Expected contribution per attempt1214.4
Collection fee per success23Expected contribution per attempt1211.2
Cash on delivery failed-delivery cost →

Sources