From Reactive to Planned: Using Dashboards to Spot Maintenance Patterns
Quick Summary
Dashboards show which equipment breaks down most. Spot the pattern: "HVAC Unit #12 has 8 breakdowns in 6 months." Replace reactive fixes with scheduled preventive maintenance. Reduce breakdowns and costs by 40-60%.
The Problem: Firefighting Instead of Planning
Your facilities team is busy -- constantly busy. Monday morning, a water heater fails. Two hours of emergency repairs. Wednesday, the parking lot lighting keeps flickering. Thursday, someone finds the HVAC Unit #12 running inefficiently, temperature rising. By Friday, you've spent $8,000 fixing things that broke.
Your CFO asks: "Why do we keep fixing the same stuff? Can't you predict these failures?"
You look at your spreadsheets. You have work order numbers, costs, descriptions. But no visibility into patterns:
- How many times did HVAC Unit #12 actually break down this year?
- Which asset generated the most work orders?
- How much money are we wasting on reactive repairs vs prevention?
- If we did preventive maintenance, would we save money?
You can't answer. You just know your team is exhausted and your maintenance budget is way over.
The reality:
- 80% of your work is reactive (fixing broken things)
- 20% is planned (scheduled preventive maintenance)
- You're spending $5 to fix something that costs $1 to prevent
The Infodeck Solution: Dashboards Reveal Patterns
Dashboards show exactly which equipment breaks down most. Once you see the pattern, you shift from reactive to planned maintenance.
Here's what Infodeck dashboards reveal:
Dashboard 1: Work Order Volume by Asset
A chart shows all your assets ranked by number of work orders:
- HVAC Unit #12: 8 work orders in 6 months (emergency repairs)
- HVAC Unit #5: 3 work orders in 6 months (normal)
- Chiller A: 2 work orders in 6 months (normal)
- Boiler B: 5 work orders in 6 months (aging equipment?)
- Water heater: 1 work order
Insight: HVAC Unit #12 is broken 2.7x more than Unit #5 (same model, same age). Something is wrong.
Dashboard 2: Breakdown by Work Order Type
A pie chart shows: 45% emergency repairs, 30% preventive maintenance, 25% inspections.
Insight: You're spending almost half your budget on emergencies. Industry best practice is 20% emergency, 60% preventive, 20% inspections.
Dashboard 3: Cost by Failure Reason
A table shows:
- Bearing failure: $12,400 (8 incidents, $1,550 ea)
- Filter replacement: $2,100 (14 incidents, $150 ea)
- Valve failure: $8,900 (6 incidents, $1,483 ea)
Insight: Bearing failures and valve failures are driving costs. These are preventable with maintenance.
Dashboard 4: HVAC Unit #12 Deep Dive
You click into HVAC Unit #12 and see:
- 8 work orders in 6 months
- All reactive (emergency calls, not scheduled)
- Reasons: bearing degradation, efficiency drop, cooling loss
- Trend: Getting worse (4 repairs in last 2 months)
Insight: Unit #12 is failing. The pattern is clear: bearing is wearing out. Preventive bearing replacement would cost $800 now. Emergency repairs are costing $1,500 each, and you're doing 2 per month.
From Insight to Action: The Shift
You decide: "Instead of waiting for HVAC Unit #12 to fail again, let's do scheduled maintenance."
Before (Reactive):
- Unit fails → Emergency call → Technician diagnoses → Order parts → Install → $1,500 cost
- Downtime: 4-6 hours (tenants complaining)
- Occurs 2x per month = $3,000/month for one unit
After (Planned):
- Inspect bearing health monthly (15 min, included in scheduled PM)
- When bearing shows 70% wear, schedule replacement during planned window
- Replacement takes 2 hours on your schedule, not 6 hours emergency
- Cost: $800 replacement + tech time = $1,200 total
- Occurs 1x every 6 months = $200/month for one unit
Savings: $2,800/month for one unit. If you have 5 similar units with reactive patterns, that's $14,000/month saved by shifting to planned.
Before vs After
| Metric | Reactive (80% of work) | Planned (60% target) |
|---|---|---|
| Work order volume | 80 emergencies, 20 planned | 20 emergencies, 60 planned |
| Cost per repair | $1,500 (includes emergency premium) | $800 (standard rates) |
| Downtime per incident | 4-6 hours (tenant impact) | 1-2 hours (scheduled window) |
| Equipment life | 5-7 years (stressed) | 8-10 years (well-maintained) |
| Predictability | Unpredictable costs | Budget ±10% |
How to Use Dashboards to Plan Maintenance
Dashboard: Work Orders by Asset (Monthly)
- Go to Dashboards
- Open "Work Order Volume by Asset" (or create if missing)
- Select time period: Last 6 months
- Identify top 5 assets with most work orders
- Click into each one to see the trend
For each asset in top 5:
- Is the work order volume increasing (trend line going up)?
- Are most work orders reactive (emergency) or planned?
- What's the cost per work order?
Dashboard: Reactive vs Planned Ratio
- View "Work Order Type Distribution" pie chart
- Current state: 45% reactive, 30% preventive, 25% inspection
- Goal state: 20% reactive, 60% preventive, 20% inspection
For each problematic asset:
- Calculate: If we shift to 100% preventive, how much could we save?
- Example: HVAC Unit #12 costs $3,000/mo reactive. Preventive would cost $800/6mo = $133/mo. Savings: $2,867/mo.
Dashboard: Cost by Root Cause
- View "Maintenance Costs by Failure Reason"
- Identify high-cost failures (bearing, valve, sensor)
- Ask: Are these preventable with earlier maintenance?
For each root cause:
- Create a preventive maintenance task that addresses it
- Bearing degradation → Schedule bearing health check monthly
- Valve failure → Schedule valve inspection quarterly
- Sensor drift → Schedule sensor calibration every 6 months
Step-by-Step Setup
Step 1: Ensure All Work Orders Are Categorized
- Go to Work Orders
- For each work order, confirm these fields are filled:
- Type: Reactive, Preventive, or Inspection
- Asset: Which equipment this is for
- Reason: Why the work was needed (failure type, routine check, etc.)
- If missing, add these details to historical work orders
Learn more: Create and Categorize Work Orders
Step 2: Set Up Dashboard: Work Orders by Asset
- Go to Dashboards
- Click Create Dashboard
- Add chart: "Work Order Volume by Asset"
- Settings:
- Data: Count of work orders
- Group by: Asset name
- Filter: Last 6 months
- Sort: Highest to lowest
- Save dashboard
Learn more: Create Dashboards
Step 3: Set Up Dashboard: Reactive vs Planned
- Add chart to dashboard: "Work Order Type Distribution"
- Settings:
- Data: Count of work orders
- Group by: Work order type (Reactive, Preventive, Inspection)
- Filter: Last 6 months
- Display: Pie chart
- Add a second metric: "Target: 20% Reactive, 60% Preventive, 20% Inspection"
Step 4: Analyze Top Problematic Assets
- View "Work Order Volume by Asset" dashboard
- Identify top 3 assets with most work orders
- For each one, click through to see:
- Monthly trend (is it increasing?)
- Work order reasons (what keeps breaking?)
- Costs (how much are we spending?)
Step 5: Create Preventive Maintenance Plans
For your top 3 problematic assets, create recurring preventive work orders:
Example: HVAC Unit #12
- Create recurring work order: "HVAC Unit #12 -- Preventive Maintenance"
- Schedule: Monthly (1st Wednesday)
- Type: Preventive
- Steps: Bearing inspection, filter change, coil cleaning, efficiency test
- Estimated cost: $150/month
- Expected benefit: Avoid $1,500 emergency repairs
Learn more: Recurring Work Orders
Example: Boiler B (5 work orders in 6 months)
- Create recurring: "Boiler B -- Quarterly Service"
- Schedule: Every 3 months
- Type: Preventive
- Steps: Burner inspection, combustion test, valve check, safety test
- Cost: $300/quarter
- Avoid: Multiple emergency repairs costing $1,000+ each
Step 6: Monitor the Shift
Each month:
- Review "Reactive vs Planned" dashboard
- Track progress toward 20% reactive / 60% preventive
- Review asset-specific dashboards:
- HVAC Unit #12 work orders (should drop from 2/month to 0)
- Boiler B work orders (should drop from 1/month to 0)
- Compare costs month-over-month
Target: After 3 months of preventive maintenance, reactive work orders should drop 30-40%.
Real Results
Large commercial property manager, 15 buildings:
- Dashboards revealed: 45 emergency repairs per month (very high)
- Top 5 assets: 80% of emergency calls
- Implemented preventive maintenance for top 5
- Result after 6 months:
- Emergency repairs: Down from 45/month to 15/month (67% reduction)
- Maintenance cost: Down 35% ($45,000/month to $29,000/month)
- Equipment downtime: Cut from 120 hours/month to 20 hours/month
- Savings: $192,000/year
Hospital facilities team:
- Reactive repairs were unpredictable and disrupted critical operations
- Dashboards showed which equipment needed attention
- Shifted to planned preventive maintenance
- Result:
- Zero unplanned downtime for critical systems (vs 6-8 incidents/year previously)
- Maintenance budget predictable within 8% (vs 30% variance)
- Equipment lifecycle extended (HVAC systems lasting 10 years vs 6-7 years)
Multi-tenant office building:
- Tenants complained: "Maintenance is always fixing something; we're never confident it won't break again"
- Dashboards showed 60% reactive work orders
- Shifted to 80% preventive over 6 months
- Result:
- Tenant satisfaction score rose 18 points (from 6.2/10 to 7.6/10)
- Lease renewals increased (5 of 6 major tenants renewed, citing "reliable maintenance")
- Additional revenue: $150,000 in lease premium from improved reputation
Common Questions
Q: Preventive maintenance costs money too. How do I justify it? A: Run the math with your dashboards. If HVAC Unit #12 costs $3,000/month in emergency repairs, preventive maintenance at $200/month is 15x cheaper. Plus, you avoid tenant downtime and unpredictable budget overruns.
Q: What if I don't have 6 months of historical data yet? A: Start collecting it. In the meantime, look at manufacturers' recommended maintenance schedules. They're based on typical failure patterns. Once you have 3-6 months of data, compare your patterns to recommendations and adjust.
Q: Should I stop emergency repairs entirely? A: No. Some emergencies are unpredictable (accident damage, weather events). The goal is to get from 80% emergency to 20% emergency. That still means you handle true emergencies quickly; you just eliminate the preventable ones.
Q: How often should I review dashboards? A: Weekly (quick check that reactive work is trending down) and monthly (detailed analysis for the coming month's planning).
Related Articles
- Dashboards Overview
- Create and Customize Dashboards
- Recurring Work Orders
- Work Order Categories and Types
- Work Order Analytics and Reporting
Implementation Timeline
| Month | Action |
|---|---|
| Month 1 | Set up dashboards. Categorize work orders (Reactive, Preventive, Inspection). |
| Month 2 | Analyze top 5 assets. Create preventive maintenance plans for #1 and #2. |
| Month 3 | Expand preventive plans to #3, #4, #5. Monitor dashboard trends. |
| Month 4-6 | Evaluate results. Adjust frequency/scope based on data. Plan for Year 2. |
Next Steps
- Pull your work order data for the last 6 months -- Export or review in your current system.
- Categorize by work order type -- Mark each as Reactive, Preventive, or Inspection.
- Identify your top 5 problem assets -- Which equipment generates the most work orders?
- Set up dashboards in Infodeck -- Follow the step-by-step above. See your data visually.
- Create preventive maintenance plans -- For your top 3 assets, plan recurring maintenance.
Ready to cut maintenance costs and stop firefighting? Set up your first dashboard today.