Free shipping threshold profitability · Calculation guide

Calculate the basket value needed to cover subsidized shipping, fixed handling and a target contribution using the pre-shipping gross margin percentage.

Calculation guide

Minimum free-shipping basket = (Merchant shipping cost + Fixed fulfillment per basket + Target contribution per basket) / (Merchandise margin on basket / 100)

Inputs

Merchandise margin on basket

Example entry 40 %. Allowed range 0 to 100.

Merchant shipping cost

Example entry 8 (in the selected currency).

Fixed fulfillment per basket

Example entry 2 (in the selected currency).

Target contribution per basket

Example entry 6 (in the selected currency).

Worked example

InputValue
Merchandise margin on basket40%
Merchant shipping cost8
Fixed fulfillment per basket2
Target contribution per basket6
ResultValue
Minimum free-shipping basket40

Calculation steps

Minimum free-shipping basket = (((Merchant shipping cost + Fixed fulfillment per basket) + Target contribution per basket) ÷ (Merchandise margin on basket ÷ 100))

(((8 + 2) + 6) ÷ (40 ÷ 100)) = 40

How each input affects this example

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

InputOriginal inputNew inputAffected resultOriginal resultNew result
Merchandise margin on basket40%44%Minimum free-shipping basket4036.363636
Merchant shipping cost89Minimum free-shipping basket4042.5
Fixed fulfillment per basket23Minimum free-shipping basket4042.5
Target contribution per basket67Minimum free-shipping basket4042.5
Free shipping threshold profitability →

Sources