Calculation guide
Assume fixed costs stay constant and the new sales are collectible.
Required replacement sales = (Gross bad debt − Expected recovery) / (Contribution margin on sales / 100)
Inputs
Gross bad debt
Example entry 1000 (in the selected currency).
Expected recovery
Example entry 100 (in the selected currency).
Contribution margin on sales
Example entry 30 %. Allowed range 0 to 100.
Worked example
| Input | Value |
|---|---|
| Gross bad debt | 1,000 |
| Expected recovery | 100 |
| Contribution margin on sales | 30% |
| Result | Value |
|---|---|
| Required replacement sales | 3,000 |
Calculation steps
Required replacement sales = ((Gross bad debt − Expected recovery) ÷ (Contribution margin on sales ÷ 100))
((1,000 − 100) ÷ (30 ÷ 100)) = 3,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 |
|---|---|---|---|---|---|
| Gross bad debt | 1,000 | 1,100 | Required replacement sales | 3,000 | 3,333.333333 |
| Expected recovery | 100 | 110 | Required replacement sales | 3,000 | 2,966.666667 |
| Contribution margin on sales | 30% | 33% | Required replacement sales | 3,000 | 2,727.272727 |
