Refrigerated cargo spoilage reserve · Calculation guide

For identical shipments, multiply the probability of spoilage by loss severity conditional on spoilage.

Calculation guide

Use net cargo value at risk per shipment.

Expected spoilage loss = ((((Shipment count × Cargo value per shipment) × Spoilage event probability (%)) × Cargo loss if spoiled (%)) ÷ 10000)

Inputs

Shipment count

Example entry 100. Allowed range 0 to 10000. Use whole numbers.

Cargo value per shipment

Example entry 10000 (in the selected currency).

Spoilage event probability (%)

Example entry 2 %. Allowed range 0 to 100.

Cargo loss if spoiled (%)

Example entry 50 %. Allowed range 0 to 100.

Worked example

InputValue
Shipment count100
Cargo value per shipment10,000
Spoilage event probability (%)2%
Cargo loss if spoiled (%)50%
ResultValue
Expected spoilage loss10,000

Calculation steps

Expected spoilage loss = ((((Shipment count × Cargo value per shipment) × Spoilage event probability (%)) × Cargo loss if spoiled (%)) ÷ 10,000)

((((100 × 10,000) × 2) × 50) ÷ 10,000) = 10,000

How each input affects this example

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

InputOriginal inputNew inputAffected resultOriginal resultNew result
Shipment count100110Expected spoilage loss10,00011,000
Cargo value per shipment10,00011,000Expected spoilage loss10,00011,000
Spoilage event probability (%)2%3%Expected spoilage loss10,00015,000
Cargo loss if spoiled (%)50%55%Expected spoilage loss10,00011,000
Refrigerated cargo spoilage reserve →

Sources