Try It: Data Quality Cost Calculator
Try Change Prevention cost ($/day), then press Calculate.
Observe After Calculate, watch Annual Prevention, Correction / Prevention, and Failure / Prevention.
Explain Describe how prevention cost changes Failure / Prevention after Calculate.
Calculate
Reset
Technical boundaries. Annual Prevention multiplies daily prevention cost by 365. Cost ratios divide entered correction and failure costs by daily prevention cost; zero prevention cost makes ratios undefined.
Try It: Data Quality Cost Calculator
Use this interactive calculator to explore the 1-10-100 rule with your own failure scenario. Adjust the costs to see how the prevention-to-failure ratio changes.
viewof dqCostPreventionInput = Inputs. range ([0 , 100 ], {value : 0.02 , step : 0.01 , label : "Prevention cost ($/day)" })
viewof dqCostCorrectionInput = Inputs. range ([0 , 10000 ], {value : 200 , step : 10 , label : "Correction cost ($)" })
viewof dqCostFailureInput = Inputs. range ([0 , 500000 ], {value : 45000 , step : 100 , label : "Failure cost ($)" })
{
const ratio = dqCostPreventionInput > 0
? (dqCostFailureInput / dqCostPreventionInput). toFixed (0 )
: "Infinite" ;
const corrRatio = dqCostPreventionInput > 0
? (dqCostCorrectionInput / dqCostPreventionInput). toFixed (0 )
: "Infinite" ;
const annualPrevention = (dqCostPreventionInput * 365 ). toFixed (2 );
const viewportWidth = typeof width !== "undefined" ? width : window . innerWidth ;
const compact = viewportWidth < 640 ;
const metricMin = compact ? 130 : 160 ;
return html `<div style="background: var(--bs-light, #f8f9fa); padding: 1.2rem; border-radius: 8px; border-left: 4px solid #16A085; color: var(--bs-body-color); margin-top: 0.5rem;">
<div style="display: grid; grid-template-columns: repeat(auto-fit, minmax( ${ metricMin} px, 1fr)); gap: 1rem; text-align: center;">
<div>
<div style="font-size: 0.85rem; color: var(--bs-body-color); opacity: 0.7;">Annual Prevention</div>
<div style="font-size: 1.5rem; font-weight: bold; color: #16A085;">$ ${ annualPrevention} </div>
</div>
<div>
<div style="font-size: 0.85rem; color: var(--bs-body-color); opacity: 0.7;">Correction / Prevention</div>
<div style="font-size: 1.5rem; font-weight: bold; color: #E67E22;"> ${ corrRatio} :1</div>
</div>
<div>
<div style="font-size: 0.85rem; color: var(--bs-body-color); opacity: 0.7;">Failure / Prevention</div>
<div style="font-size: 1.5rem; font-weight: bold; color: #E74C3C;"> ${ ratio} :1</div>
</div>
</div>
<p style="margin: 0.8rem 0 0 0; font-size: 0.9rem; text-align: center;"><strong>Conclusion:</strong> ${ dqCostPreventionInput === 0 ? "With zero entered prevention cost, cost ratios are undefined; enter a positive cost to compare." : `For this example’s inputs, every $1 spent on prevention corresponds to $ ${ ratio} in modeled failure costs.` } </p>
</div>` ;
}
Back to the chapter