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
| Input | Value |
|---|---|
| Order selling price | 100 |
| Product and fulfillment cost | 55 |
| Full refund probability | 10% |
| Handling per refund | 8 |
| Recovered value per refund | 40 |
| Result | Value |
|---|---|
| Expected contribution per order | 38.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.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Order selling price | 100 | 110 | Expected contribution per order | 38.2 | 47.2 |
| Product and fulfillment cost | 55 | 61 | Expected contribution per order | 38.2 | 32.2 |
| Full refund probability | 10% | 11% | Expected contribution per order | 38.2 | 37.52 |
| Handling per refund | 8 | 9 | Expected contribution per order | 38.2 | 38.1 |
| Recovered value per refund | 40 | 44 | Expected contribution per order | 38.2 | 38.6 |
