Refund rate effect on order contribution · Calculation guide

A refund returns the full selling price. Fulfillment and product costs are incurred on every order.

Calculation guide

Refunded orders also incur handling and may recover inventory value.

Expected contribution per order = Order selling price − Product and fulfillment cost − Full refund probability / 100 × (Order selling price + Handling per refund − Recovered value per refund)

Inputs

Order selling price

Example entry 100 (in the selected currency).

Product and fulfillment cost

Example entry 55 (in the selected currency).

Full refund probability

Example entry 10 %. Allowed range 0 to 100.

Handling per refund

Example entry 8 (in the selected currency).

Recovered value per refund

Example entry 40 (in the selected currency).

Worked example

InputValue
Order selling price100
Product and fulfillment cost55
Full refund probability10%
Handling per refund8
Recovered value per refund40
ResultValue
Expected contribution per order38.2

Calculation steps

Expected contribution per order = ((Order selling price − Product and fulfillment cost) − ((Full refund probability ÷ 100) × ((Order selling price + Handling per refund) − Recovered value per refund)))

((100 − 55) − ((10 ÷ 100) × ((100 + 8) − 40))) = 38.2

How each input affects this example

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

InputOriginal inputNew inputAffected resultOriginal resultNew result
Order selling price100110Expected contribution per order38.247.2
Product and fulfillment cost5561Expected contribution per order38.232.2
Full refund probability10%11%Expected contribution per order38.237.52
Handling per refund89Expected contribution per order38.238.1
Recovered value per refund4044Expected contribution per order38.238.6
Refund rate effect on order contribution →

Sources