Calculation guide
Count insured days after the waiting period and before the policy end day, measured from the interruption. Use constant daily normal and actual sales, deduct avoided variable costs and cap at the remaining limit.
Inputs
Normal daily sales
Example entry 1000 (in the selected currency).
Actual daily sales during disruption
Example entry 400 (in the selected currency).
Contribution margin on lost sales
Example entry 60 %. Allowed range 0 to 100.
Days interrupted
Example entry 20. Use whole numbers.
Waiting days
Example entry 3. Use whole numbers.
Coverage end day from interruption
Example entry 30. Use whole numbers.
Remaining indemnity limit
Example entry 10000 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Normal daily sales | 1,000 |
| Actual daily sales during disruption | 400 |
| Contribution margin on lost sales | 60% |
| Days interrupted | 20 |
| Waiting days | 3 |
| Coverage end day from interruption | 30 |
| Remaining indemnity limit | 10,000 |
| Result | Value |
|---|---|
| Covered contribution loss | 6,120 |
| Indemnifiable days | 17 |
| Total contribution loss left uncovered | 1,080 |
Calculation steps
Covered contribution loss = min(Remaining indemnity limit, (((max(0, (min(Days interrupted, Coverage end day from interruption) − Waiting days)) × max(0, (Normal daily sales − Actual daily sales during disruption))) × Contribution margin on lost sales) ÷ 100))
min(10,000, (((max(0, (min(20, 30) − 3)) × max(0, (1,000 − 400))) × 60) ÷ 100)) = 6,120
Indemnifiable days = max(0, (min(Days interrupted, Coverage end day from interruption) − Waiting days))
max(0, (min(20, 30) − 3)) = 17
Total contribution loss left uncovered = ((((max(0, (Normal daily sales − Actual daily sales during disruption)) × Contribution margin on lost sales) ÷ 100) × Days interrupted) − Covered contribution loss)
((((max(0, (1,000 − 400)) × 60) ÷ 100) × 20) − 6,120) = 1,080
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 |
|---|---|---|---|---|---|
| Normal daily sales | 1,000 | 1,100 | Covered contribution loss | 6,120 | 7,140 |
| Actual daily sales during disruption | 400 | 440 | Covered contribution loss | 6,120 | 5,712 |
| Contribution margin on lost sales | 60% | 66% | Covered contribution loss | 6,120 | 6,732 |
| Days interrupted | 20 | 22 | Covered contribution loss | 6,120 | 6,840 |
| Waiting days | 3 | 4 | Covered contribution loss | 6,120 | 5,760 |
| Coverage end day from interruption | 30 | 15 | Covered contribution loss | 6,120 | 4,320 |
| Remaining indemnity limit | 10,000 | 5,000 | Covered contribution loss | 6,120 | 5,000 |
