Reefer Cargo Temperature Excursion, Cold Chain & Cargo Claim Exposure Tool
Reefer Cargo Temperature Excursion, Cold Chain & Cargo Claim Exposure Tool
Examine cargo-specific temperature bands and recorded sensor observations, locate cold-chain evidence gaps, and build a transparent impairment and recovery scenario. A refrigeration alarm is not, by itself, proof of cargo damage.
1. Cargo Lot & Temperature Specification Register
Enter each lot's documented band and independent commercial impairment estimate. The value impairment is user-supplied, not calculated from degree-hours.
| Use | Lot ID | Product / lot | Quantity kg | Value USD | Lower °C | Upper °C | Affected % | Impairment % | Salvage USD | Damage assessment | Remove |
|---|
2. Logger Observation Register
One row per timestamped reading. Select the cargo lot and sensor position, and use a consistent timezone. Thermal dose is integrated only over adjacent, verified observations of the same sensor series within the maximum interpolation gap.
| Use | Cargo lot | Sample time | Temp °C | Sensor position | Data quality | Observation / source | Remove |
|---|
3. Custody, Power & Handling Event Register
Record unplugging, genset faults, defrost, door openings, transfers, terminal handovers, surveys and preserved equipment alarms. Event flags require investigation, not automatic causation.
| Use | Time | Event | Status | Possible interruption h | Location / source note | Remove |
|---|
4. Survey, Mitigation & Storage Cost Register
Separate survey, cold-storage, sorting, reworking and reasonable mitigation from cargo impairment. Avoid duplicating costs already included in the fixed inputs above.
| Use | Cost category | Amount USD | Supporting evidence | Details / invoice | Remove |
|---|
5. Evidence & Notification Register
Preserve originals and resolve notices, product specifications, recorder calibration, stuffing/pulp temperatures, survey and salvage records before asserting causation or recovery.
| Use | Evidence requirement | Critical? | Status | Responsible party | Document reference | Remove |
|---|