Executive KPI Dashboard
Real-time visibility into the financial consequences of downtime.
How to Use This Tool
Use before a disruption for planning and during an event for real-time financial decision support.
- Enter downtime duration and operating schedule assumptions.
- Enter normal revenue, margin, labor, and production data.
- Complete additional customer, supply-chain, and recovery cost categories.
- Enter expected insurance or contractual recoveries.
- Review expected, conservative, and severe scenarios.
- Assign actions and obtain executive approval.
- Use contribution margin rather than gross revenue alone.
- Separate downtime losses from one-time recovery costs.
- Include idle labor, expedited freight, overtime, customer penalties, and reputation effects.
- Recalculate whenever downtime duration or production capacity changes.
- Compare the cost of downtime against the cost of prevention and redundancy.
Related BROS™ tools: Business Impact Analysis, Recovery Cost Calculator, Revenue at Risk Calculator, Cash Burn Calculator, Insurance Gap Calculator, and Recovery Time Calculator.
1. Downtime Assumptions
Define the event, duration, and operating schedule.
2. Revenue and Margin Impact
Estimate lost business output and contribution margin.
3. Labor and Fixed Cost Impact
Capture labor and overhead that continue while operations are interrupted.
4. Operational and Recovery Costs
Enter additional expenses required to restore operations and serve customers.
| Cost Category | Description / Assumption | Estimated Cost |
|---|---|---|
| Emergency Response | ||
| Repair / Replacement | ||
| IT / Data Recovery | ||
| Expedited Freight | ||
| Alternate Supplier Premium | ||
| Outsourced Production / Service | ||
| Temporary Facility / Equipment | ||
| Professional Fees | ||
| Communications / Reputation Recovery | ||
| Other Recovery Costs | ||
| Operational and Recovery Cost Total | $0 | |
5. Customer, Contract, and Compliance Impact
Capture direct consequences beyond lost revenue.
6. Insurance and Other Offsets
Estimate reimbursements and financial offsets separately from gross losses.
7. Scenario Analysis
Compare downtime exposure at multiple durations and severity levels.
Expected Scenario
Conservative Scenario
Severe Scenario
8. Downtime Threshold and Risk Rating
Compare the estimated impact with management's financial tolerance.
9. Recovery Action Register
Assign actions to reduce downtime duration and financial exposure.
| Action | Owner | Due Date | Priority | Status |
|---|---|---|---|---|
10. Executive Review and Approval
Document assumptions, mitigation decisions, and formal approval.