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
| Input | Value |
|---|---|
| Shipment count | 100 |
| Cargo value per shipment | 10,000 |
| Spoilage event probability (%) | 2% |
| Cargo loss if spoiled (%) | 50% |
| Result | Value |
|---|---|
| Expected spoilage loss | 10,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.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Shipment count | 100 | 110 | Expected spoilage loss | 10,000 | 11,000 |
| Cargo value per shipment | 10,000 | 11,000 | Expected spoilage loss | 10,000 | 11,000 |
| Spoilage event probability (%) | 2% | 3% | Expected spoilage loss | 10,000 | 15,000 |
| Cargo loss if spoiled (%) | 50% | 55% | Expected spoilage loss | 10,000 | 11,000 |
