Plumbing Command Center - Executive Dashboard

🔧 Plumbing Command Center

Your Plumbing Company

Live Business Intelligence

Live • Updates in 60s
Today's Revenue
$12,450
↑ 23% vs yesterday
18 jobs completed
Avg Job Value
$692
↑ $47 this week
Target: $650
Profit Margin
68%
↑ 3.2% this month
After materials & labor
Technician Utilization
87%
↑ 5% this week
7 of 8 techs active
💡 Key Insight
Emergency drain services are generating 3.2x more profit per hour than standard installations. Consider promoting 24/7 emergency services in your Facebook ads - current ROI on emergency jobs is 340%.

Revenue Trend

Quick Stats

Jobs This Week
127
↑ 15 vs last week
Customer Rating
4.8★
From 94 reviews
Callback Rate
2.1%
Industry avg: 5.8%
Materials on Hand
$24,350
17 days of stock

Technician Scorecard

Technician Jobs Today Revenue Generated Labor Cost Net Profit Profit/Hour Customer Rating Status
Mike Johnson 5 $3,840 $320 $2,520 $315/hr 4.9★ Excellent
Sarah Chen 4 $2,960 $280 $1,880 $282/hr 4.8★ Excellent
Tom Rodriguez 4 $2,640 $280 $1,560 $234/hr 4.7★ Good
Lisa Martinez 3 $1,920 $240 $1,120 $224/hr 4.9★ Good
David Kim 2 $1,090 $160 $650 $163/hr 4.5★ Below Target
📊 Performance Analysis
Mike Johnson is your top performer at $315/hour profit. He specializes in emergency drain services which have the highest profit margins. Consider having him train other techs on upselling emergency services and efficient drain clearing techniques. David Kim needs coaching on job completion speed.
Top Performer
Mike Johnson
$315/hr profit rate
Avg Profit/Tech
$1,546
↑ $180 vs last week
Labor Efficiency
92%
Billable hours
Training ROI
340%
From drain certification

30-Day Technician Trends

Service Type Profitability

Service Type Jobs/Week Avg Price Avg Time Materials Cost Profit/Job Profit/Hour ROI
Emergency Drain Service 23 $485 1.2 hrs $42 $363 $303/hr 340%
Water Heater Replacement 8 $1,840 3.5 hrs $580 $980 $280/hr 169%
Leak Repair 31 $320 1.5 hrs $38 $222 $148/hr 284%
Toilet Installation 12 $650 2.2 hrs $180 $338 $154/hr 188%
Pipe Inspection 18 $280 1.8 hrs $15 $193 $107/hr 687%
Sink/Faucet Installation 15 $420 2.5 hrs $120 $200 $80/hr 167%
💰 Profitability Insight
Emergency drain services are your cash cow at $303/hour profit. They require minimal materials ($42) and command premium pricing. Focus marketing on 24/7 emergency availability. Water heater replacements generate high revenue per job ($1,840) making them ideal for filling slower periods.
Highest Profit/Hour
$303/hr
Emergency Drain Service
Highest Revenue/Job
$1,840
Water Heater Replacement
Most Requested
Leak Repair
31 jobs this week
Best ROI
687%
Pipe Inspection

Service Mix Trend

Materials Cost Analysis

Material Category Monthly Usage Cost/Unit Total Cost Jobs Using Avg Markup Profit Impact
Pipes & Fittings 340 units $18.50 $6,290 89 180% $11,322
Water Heaters 8 units $580 $4,640 8 85% $3,944
Drain Equipment 156 units $12.25 $1,911 67 210% $4,013
Fixtures (Toilets/Sinks) 27 units $165 $4,455 27 95% $4,232
Valves & Connectors 245 units $8.90 $2,181 78 165% $3,599
📦 Inventory Optimization
Pipes & fittings deliver your highest profit impact ($11,322/month) with 180% markup. Stock levels are optimal at 17 days. Consider negotiating bulk pricing with your supplier for drain equipment - your 210% markup on these items is excellent, and increased volume could improve margins further.
Total Materials Cost
$19,477
This month
Avg Markup
155%
Across all materials
Inventory Turnover
17 days
Healthy range: 14-21
Waste/Returns
1.2%
Industry avg: 3.5%

Materials Cost Trend

Marketing Channel Performance

Channel Monthly Spend Leads Generated Cost/Lead Conversions Revenue ROI Status
Google Ads (Emergency) $2,400 67 $35.82 41 $19,885 728% Winning
Facebook Ads $1,200 89 $13.48 28 $7,560 530% Winning
Referral Program $450 23 $19.57 18 $6,120 1260% Winning
Google Local Service Ads $800 34 $23.53 22 $7,040 780% Winning
Yelp Ads $600 18 $33.33 9 $2,340 290% Good
Direct Mail $950 12 $79.17 5 $1,600 68% Cut
🎯 Marketing Decision
Your referral program is crushing it at 1260% ROI with $19.57/lead. Double down on this channel - consider increasing referral bonuses from $50 to $75. Google Ads for emergency services at 728% ROI should get more budget. Cut direct mail immediately - it's losing money at 68% ROI.
Best ROI Channel
1260%
Referral Program
Lowest Cost/Lead
$13.48
Facebook Ads
Total Marketing Spend
$6,400
This month
Blended ROI
597%
Across all channels

Marketing ROI Trend