FINAL:

Core Operational & Efficiency Reports (1–10)

1. **Operations Efficiency & Bottleneck Diagnostic Report**  
   Overview: Identifies hidden leaks in daily ops (utilization, owner involvement, dispatch, idle time, callbacks, overtime). Quantifies revenue lift from fixes and flags owner bottlenecks or Ops Manager need. Foundational for stopping $150K–$400K+ annual losses.  
   Type: One-off initial, then quarterly  
   Key variables: Revenue Lift, Revenue Leakage, Technician Idle Time, Percentage of Service Callbacks, Callback Cost Per Incident, Overtime Hours Spent on Operations, Dispatch Delays Post Request, Average Hours Lead to Technician Arrival, Weekly Hours Spent By Owner in Field, Owner Time Spend Field vs Strategic, Number of Full Time Operations Managers

2. **Recurring Revenue & Membership Health Scorecard**  
   Overview: Tracks attach rate, renewal rate, recurring dollars, and membership %. Shows lost opportunity from low penetration and quantifies faster growth potential. Critical for shifting to predictable, high-LTV revenue.  
   Type: Monthly or quarterly  
   Key variables: Customer Lifetime Value, Annual Recurring Revenue, Recurring Revenue in Percent, Maintenance Contract Renewals in Percent, Customer Retention Rate in Percent, Average Annual Revenue Per Maintenance Contract, Annual Maintenance Contracts Count, Average Customer Retention in Years

3. **Technician Productivity & Capacity Utilization Dashboard**  
   Overview: Measures billable utilization, revenue per tech, jobs/day, hours/job, idle time, and capacity gaps. Flags underperformance and hiring triggers. Maximizes revenue per payroll dollar.  
   Type: Monthly  
   Key variables: Revenue Per Field Technician, Billable Hours Per Technician, Job Count Per Day Per Technician, Total Billable Technician Hours in Percent, Technician Efficiency, Technician Idle Time, Number of Technicians, Field Technician Labor Cost in Percent

4. **Profitability & Margin Integrity Report**  
   Overview: Breaks down gross/net/EBITDA margins, cost leaks (labor, markup, overhead), and contribution by service type. Flags erosion and pricing/cost issues. Essential for informed pricing and vendor decisions.  
   Type: Quarterly  
   Key variables: Net Profit Margin, Gross Profit Margin, EBIDTA, Blended Gross Margin Across Departments, Field Technician Labor Cost in Percent, Operating Expenses As Percent of Revenue, Departmental Contribution Margin, Gross Margin Service Department, Gross Margin Installs and Replacement, Average Markup of Supplies

5. **Cash Flow & Liquidity Health Check**  
   Overview: Monitors DSO, cash conversion cycle, days cash on hand, ratios, and working capital. Flags slow collections or overstock and shows cash unlock potential. Vital for growth and seasonal survival.  
   Type: Monthly  
   Key variables: Annual Operating Cash Flow, Cash Conversion Cycle, Average Days to Collect Receivables, Operational Cash Reserves in Days, Working Capital, Working Capital Ratio, Current Ratio, Quick Ratio, Accounts Receivable Turnover Ratio, Annual Inventory Turnover

6. **Sales & Lead Conversion Funnel Performance Report**  
   Overview: Most owners focus only on closing ratio, but the real growth bottleneck is often earlier in the funnel — lead volume, cost per lead, booking rate, and full lead-to-close conversion. This report quantifies marketing ROI, shows how many marketing dollars are wasted on poor lead handling, and calculates potential revenue if booking or closing rates improve by 10–20%. Essential for deciding whether to increase marketing spend, fix CSR performance, or train salespeople.  
   Type: Monthly  
   Key input variables required: Lead Conversion Rate, Closing Ratio In Home Sales Calls, Lead to Booking Rate, Customer Lifetime Value, Annual Inbound Leads, Average Revenue Per Sale, Customer Acquisition Cost, Average Cost Per Lead, Annual Marketing Spend, CAC Ratio to Lifetime Value

7. **Customer Experience & Retention Scorecard**  
   Overview: High customer retention and satisfaction directly drive recurring revenue, referrals, online reviews, and lower acquisition costs. This report monitors CSAT, NPS, first-time fix rate, callback rate, warranty claims, retention rate, and red flags when quality is slipping. It shows the revenue impact of improving first-time fixes or reducing callbacks by even 5%. Critical for protecting reputation and building a referral engine in a review-driven industry.  
   Type: Quarterly  
   Key input variables required: Customer Retention Rate in Percent, Customer Lifetime Value, First Fix Rate, Percentage of Service Callbacks, Net Promoter Score, Average Customer Satisfaction Score, Average Online Review Rating, Callback Cost Per Incident, Annual Warranty Claims in Percent, Annual Spend on Warranty Claims

8. **Growth & Scalability Readiness Report**  
   Overview: Scaling past $1.5–2M requires the right structure — enough managers, techs at capacity, strong recurring base, healthy cash reserves, and no major red flags. This report assesses Ops Manager need, span of control, revenue per employee/tech, YoY growth rate, cash position, debt coverage, and projected revenue lift from efficiency gains. It tells owners exactly what must be fixed before safely adding headcount or marketing dollars. The go-to report before major expansion decisions.  
   Type: One-off (strategic planning), then semi-annual  
   Key input variables required: Year Over Year Growth Rate, Revenue Lift, Annual Revenue Per Full Time Employee, Revenue Per Field Technician, Number of Full Time Operations Managers, Revenue Target Before Hiring Operations Manager, Maximum Number of Owner Managed Technicians, Operational Cash Reserves in Days, Debt to Equity Ratio, Interest Coverage Ratio

9. **Financial Benchmark & Red Flag Dashboard**  
   Overview: This at-a-glance dashboard compares your key financial and operational ratios against industry benchmarks and flags any metric outside healthy ranges (margins, liquidity, turnover, leverage, overhead %). It gives owners instant visibility into creeping problems — rising DSO, thinning margins, low cash reserves, high debt load — before they become crises. Perfect as a monthly executive summary or board-level overview.  
   Type: Monthly  
   Key input variables required: Net Profit Margin, Gross Profit Margin, Operating Expenses As Percent of Revenue, Current Ratio, Quick Ratio, Debt to Equity Ratio, Accounts Receivable Turnover Ratio, Return on Assets, Return on Equity, Working Capital Ratio

10. **Marketing & Customer Acquisition Efficiency Report**  
   Overview: Marketing is often the largest controllable expense after labor. This report calculates true cost per lead, cost per booked call, cost per closed sale, CAC:LTV ratio, and marketing ROI. It flags when dollars are being wasted on poor-quality leads or weak conversion. Owners use it to decide budget allocation, channel effectiveness, and whether to double down or pivot marketing strategy. Critical for profitable growth in a competitive local market.  
   Type: Monthly or quarterly  
   Key input variables required: CAC Ratio to Lifetime Value, Customer Lifetime Value, Customer Acquisition Cost, Average Cost Per Lead, Annual Marketing Spend, Lead to Booking Rate, Lead Conversion Rate, Annual Inbound Leads

List of 68 **Key variables** that appear across the 10 Core Operational & Efficiency Reports, ordered generally by importance/frequency of appearance and overall relevance to plumbing business revenue impact and operational efficiency (most critical and frequently referenced first, based on how central they are to multiple reports and direct ties to revenue leakage, growth, profitability, and scalability):

Customer Lifetime Value, Revenue Lift, Customer Retention Rate in Percent, Revenue Per Field Technician, Net Profit Margin, Gross Profit Margin, CAC Ratio to Lifetime Value, Technician Idle Time, Percentage of Service Callbacks, Callback Cost Per Incident, Number of Full Time Operations Managers, Field Technician Labor Cost in Percent, Operating Expenses As Percent of Revenue, Operational Cash Reserves in Days, Current Ratio, Quick Ratio, Working Capital Ratio, Accounts Receivable Turnover Ratio, Lead Conversion Rate, Lead to Booking Rate, Annual Inbound Leads, Customer Acquisition Cost, Average Cost Per Lead, Annual Marketing Spend, Debt to Equity Ratio, Revenue Leakage, Overtime Hours Spent on Operations, Dispatch Delays Post Request, Average Hours Lead to Technician Arrival, Weekly Hours Spent By Owner in Field, Owner Time Spend Field vs Strategic, Annual Recurring Revenue, Recurring Revenue in Percent, Maintenance Contract Renewals in Percent, Average Annual Revenue Per Maintenance Contract, Annual Maintenance Contracts Count, Average Customer Retention in Years, Billable Hours Per Technician, Job Count Per Day Per Technician, Total Billable Technician Hours in Percent, Technician Efficiency, Number of Technicians, EBIDTA, Blended Gross Margin Across Departments, Departmental Contribution Margin, Gross Margin Service Department, Gross Margin Installs and Replacement, Average Markup of Supplies, Annual Operating Cash Flow, Cash Conversion Cycle, Average Days to Collect Receivables, Working Capital, Annual Inventory Turnover, Closing Ratio In Home Sales Calls, Average Revenue Per Sale, First Fix Rate, Net Promoter Score, Average Customer Satisfaction Score, Average Online Review Rating, Annual Warranty Claims in Percent, Annual Spend on Warranty Claims, Year Over Year Growth Rate, Annual Revenue Per Full Time Employee, Revenue Target Before Hiring Operations Manager, Maximum Number of Owner Managed Technicians, Interest Coverage Ratio, Return on Assets, Return on Equity

-----------------------------------------------------

Core Operational & Efficiency Reports (11–15)

11. **Pricing & Ticket Size Optimization Report**  
   Overview: Average ticket price (ATP) and markup discipline directly determine how much revenue each job generates. Low ATP often signals missed upsells, poor diagnostics, or under-pricing; inconsistent markup erodes gross margins. This report benchmarks your current ATP against industry targets, flags low-ticket red flags, analyzes markup effectiveness, and estimates revenue lift from a 10–20% ticket increase. Critical for owners who want to grow revenue without adding more calls or techs—pure margin expansion.  
   Type: Quarterly  
   Key input variables required: Average Revenue Per Sale, Average Gross Profit Per Job, Average Invoice, Average Markup of Supplies, Gross Margin Service Department, Gross Margin Installs and Replacement, Average Billable Hours Per Job, New Installs vs Repairs in Percent, Revenue Lift

12. **Overhead & Fixed Cost Control Report**  
   Overview: Overhead creep (rent, utilities, software, management labor, marketing %) quietly destroys profitability as revenue grows. This report tracks all major overhead percentages against benchmarks, calculates break-even revenue impact, and flags when fixed/variable costs are out of balance. It shows how much profit is lost annually to each category and projects savings from trimming 5–10% in non-essential areas. Essential for owners scaling past $1.5–2M who need to keep overhead lean to maintain strong net margins.  
   Type: Quarterly  
   Key input variables required: Operating Expenses As Percent of Revenue, Annual Fixed Costs, Percent of Revenue on Lease and Utilities, Percent of Revenue on Software and Tech Support, Insurance Costs As Percent of Gross Revenue, Annual Operating Expense As Percent of Revenue, Annual Break Even Point, Net Profit Margin, Owner Compensation As Percent of Revenue, Annual Marketing Spend

13. **Accounts Receivable & Collections Efficiency Report**  
   Overview: Slow collections tie up cash and increase bad debt risk—common in trades where invoices can sit 45+ days. This report monitors DSO, accounts receivable turnover, aging trends (via derived days outstanding), and cash impact. It flags slow-paying customers or process gaps and estimates how many extra days of cash flow could be unlocked by tightening terms or improving invoicing. Vital for maintaining liquidity during seasonal dips or growth spurts.  
   Type: Monthly  
   Key input variables required: Average Days to Collect Receivables, Accounts Receivable Turnover Ratio, Cash Conversion Cycle, Accounts Receivable Annual Average Balance, Average Number of Days Unpaid Invoices, Annual Operating Cash Flow, Working Capital, Operational Cash Reserves in Days

14. **Employee & Technician Turnover Impact Report**  
   Overview: High turnover in field techs and CSRs costs thousands per departure (recruitment, training, lost productivity). This report calculates turnover rate, recruitment cost impact, lost revenue from vacant positions, and correlation with satisfaction/training hours. It flags dangerous levels and quantifies how reducing turnover by 10% could boost capacity and margins. Critical for owners who want to build a stable, high-performing team rather than constantly rehiring.  
   Type: Quarterly  
   Key input variables required: Technician Turnover Rate, Employee Turnover Rate, Recruitment Cost Per Hire, Average Revenue Per Employee, Annual Revenue Per Full Time Employee, Average Annual Training Hours Per Employee, Training ROI, Employee Satisfaction Score, Revenue Per Field Technician, Number of Technicians

15. **Warranty & Callback Cost Analysis Report**  
   Overview: Callbacks and warranty claims destroy margins through repeat labor, parts, and reputation damage. This report tracks callback rate, warranty claims percentage, first-time fix rate, and estimated cost per incident. It calculates annual profit leakage from poor quality/installs and shows revenue protection from improving first-time fixes by 5–10%. Essential for owners focused on long-term customer trust and reducing non-billable rework.  
   Type: Quarterly  
   Key input variables required: Percentage of Service Callbacks, Callback Cost Per Incident, Annual Warranty Claims in Percent, Annual Spend on Warranty Claims, First Fix Rate, Average Gross Profit Per Job, Revenue Leakage, Customer Retention Rate in Percent

16. **Inventory & Parts Management Efficiency Report**: 
    Overview: Analyzes turns, days on hand, value vs. revenue; flags over/under-stock and cash impact. Improves flow and frees working capital.  
    Type: Quarterly  
    Key variables: Annual Inventory Turnover, Inventory Spend Wastage, Average Value of Inventory, Inventory Book Value, Working Capital, Cash Conversion Cycle, Annual Cost of Goods Sold As Percent of Revenue, Timely Vendor Order Delivery in Percent

17. **Debt & Leverage Health Report**:
    Overview: Reviews debt-to-equity, coverage ratios, fixed assets %; flags risky leverage and balance sheet strength. Supports financing and growth planning.  
    Type: Semi-annual  
    Key variables: Debt to Equity Ratio, Interest Coverage Ratio, Annual Interest Paid on Debt, Fixed Assets As Percent of Total Assets, Return on Equity, Return on Assets, Total Liabilities, Owner Equity

18. **Owner Time Allocation & Delegation Audit**: 
    Overview: Calculates ops time %, field hours, span of control, Ops need trigger; quantifies leakage from bottlenecks. Helps transition to strategic leadership.  
    Type: One-off, then semi-annual  
    Key variables: Weekly Hours Spent By Owner in Field, Owner Time Spend Field vs Strategic, Number of Full Time Operations Managers, Revenue Target Before Hiring Operations Manager, Maximum Number of Owner Managed Technicians, Owner Workweek Hours, Annual Base Salary Operations Manager, Revenue Leakage

19. **Overall Business Health & Red Flag Summary Dashboard**: 
    Overview: Rolls up critical red flags across ops, finance, sales, customer, cash. Scores pillars and prioritizes urgent fixes with impact estimates. Monthly proactive check.  
    Type: Monthly  
    Key variables: Net Profit Margin, Revenue Lift, Year Over Year Growth Rate, Operational Efficiency Score, Current Ratio, Net Promoter Score, Technician Turnover Rate, Revenue Leakage, Working Capital, Debt to Equity Ratio

20. **12-Month Growth Projection & Milestone Report**:
    Overview: Projects revenue, profit, cash, staffing based on growth, efficiency, recurring, marketing. Includes milestones (hiring, budget increases) and risk flags. For 1–3 year roadmaps.  
    Type: One-off annual, quarterly refresh  
    Key variables: Year Over Year Growth Rate, Annual Revenue, Net Profit, Annual Operating Cash Flow, Employee Count, Annual Marketing Spend, Recurring Revenue in Percent, Revenue Lift, Number of Technicians, Working Capital

21. **Talent Retention & Satisfaction Report**:
    Overview: Tracks turnover, satisfaction, training, recruitment cost; estimates revenue impact from reducing churn. Builds high-performing, stable teams.  
    Type: Quarterly  
    Key variables: Technician Turnover Rate, Employee Turnover Rate, Recruitment Cost Per Hire, Training ROI, Employee Satisfaction Score, Average Annual Training Hours Per Employee, Average Days to Hire

22. **Vendor & Supply Chain Performance Report**:
    Overview: Monitors on-time delivery, inventory turns, cash impact; flags unreliable suppliers and savings potential. Ensures job flow and margin control.  
    Type: Quarterly  
    Key variables: Timely Vendor Order Delivery in Percent, Annual Inventory Turnover, Inventory Spend Wastage, Cash Conversion Cycle, Average Number of Days to Pay Suppliers

23. **Digital Reputation & Review Management Report**  
    Overview: Tracks rating, CSAT, NPS; estimates lead/revenue loss from drops. Prioritizes quality fixes for review-driven growth.  
    Type: Monthly  
    Key variables: Average Online Review Rating, Net Promoter Score, Average Customer Satisfaction Score

24. **Safety & Risk Management Dashboard**  
    Overview: Monitors incident rates (proxy), ties to turnover/training/insurance; flags high-risk levels and cost savings from protocols. Protects profitability/compliance.  
    Type: Quarterly  
    Key variables: Safety Incident Rate, Insurance Costs As Percent of Gross Revenue, Technician Turnover Rate, Average Annual Training Hours Per Employee, Training ROI

25. **Seasonal Demand & Capacity Forecasting Report**  
    Overview: Analyzes growth, utilization, overtime to forecast peak bottlenecks/off-season cash needs. Guides staffing/inventory/marketing planning.  
    Type: Semi-annual (pre-peak)  
    Key variables: Year Over Year Growth Rate, Billable Hours Per Technician, Overtime Hours Spent on Operations, Technician Idle Time, Number of Technicians, Operational Cash Reserves in Days, Annual Marketing Spend

26. **Insurance & Risk Cost Control Report**:
    Overview: Tracks insurance % (red flag proxy), links to safety/turnover/claims; flags escalation and premium reduction potential. Controls overhead in high-risk trades.  
    Type: Annual + quarterly check  
    Key variables: Insurance Costs As Percent of Gross Revenue, Safety Incident Rate, Annual Spend on Warranty Claims, Technician Turnover Rate, Annual Warranty Claims in Percent, Callback Cost Per Incident

27. **Exit Readiness & Business Valuation Snapshot**:
    Overview: Estimates SDE, applies multiples; flags low margins/owner dependence/poor recurring that depress value. Steps to boost exit price.  
    Type: Annual  
    Key variables: Seller's Discretionary Earnings (SDE), Business Valuation Multiple, Net Profit Margin, Weekly Hours Spent By Owner in Field, Recurring Revenue in Percent, Owner Compensation As Percent of Revenue, Gross Profit Margin

28. **Energy & Sustainability Efficiency Tracker (HVAC-Focused)**:
    Overview: Tracks reduction targets, ties to fuel %, utilization (fewer trips); flags missed eco-upgrade/routing opportunities. Differentiates for rebates/marketing.  
    Type: Annual + quarterly progress  
    Key variables: Energy Efficiency Reduction As Percent, Technician Efficiency, Dispatch Delays Post Request, Percent of Technician Time Spent on Technical Labor, Average Hours Lead to Technician Arrival, Overtime Hours Spent on Operations

29. **Break-Even & Profit Sensitivity Analysis**:
    Overview: Calculates break-even point, sensitivity to margin/cost changes; flags high break-even vs. current revenue. Guides budgeting/pricing in volatile markets.  
    Type: Quarterly  
    Key variables: Annual Break Even Point, Gross Profit Margin, Operating Expenses As Percent of Revenue, Annual Revenue Required to Cover Costs, Variable Costs As Percent of Revenue, Annual Fixed Costs, Net Profit Margin

30. **Comprehensive KPI Trend & Year-Over-Year Comparison Report**:
    Overview: Compares current vs. prior year on revenue, margins, utilization, cash, red flags resolved/new. Highlights progress/regressions. Ultimate health check for data-driven leadership.  
    Type: Quarterly + annual deep dive  
    Key variables: Year Over Year Growth Rate, Annual Revenue, Gross Profit Margin, Billable Hours Per Technician, Annual Operating Cash Flow, Net Profit Margin, Revenue Leakage, Operational Efficiency Score

31. **Recruitment Pipeline Velocity & Efficiency Report**:
    Overview: Tracks time-to-hire, applicants per opening, cost per hire, pipeline health. Flags long cycles/low quality; estimates lost revenue from vacancies. Proactive scaling without bottlenecks.  
    Type: Quarterly (monthly during heavy hiring)  
    Key variables: Revenue Leakage, Recruitment Pipeline Strength, Average Days to Hire, Applicants Per Technician Job, Recruitment Cost Per Hire

32. **Quality of Hire & Post-Hire Performance Report**:
    Overview: Evaluates quality scores, correlates with turnover/satisfaction; calculates recruitment ROI. Flags poor fits and shows turnover/revenue benefits from better hires. Builds high-performers.  
    Type: Semi-annual  
    Key variables: Training ROI, Average Performance Score of New Hires, Technician Turnover Rate, Employee Satisfaction Score, Recruitment Cost Per Hire

33. **Source of Hire Effectiveness & Cost Report**:
    Overview: Breaks down hires by source %, compares cost/quality across channels. Flags over-reliance on low-ROI sources; shifts budget to referrals/targeted ads. Optimizes talent spend.  
    Type: Quarterly  
    Key variables: Hiring Sources Breakdown, Recruitment Cost Per Hire, Training ROI, Average Performance Score of New Hires

34. **Talent Capacity & Turnover Risk Forecast**:
    Overview: Forecasts staffing gaps from turnover, time-to-hire, growth; quantifies leakage from understaffing. Flags upcoming shortages for proactive hiring. Stays ahead of talent crises.  
    Type: Quarterly  
    Key variables: Revenue Leakage, Technician Turnover Rate, Employee Turnover Rate, Average Days to Hire, Year Over Year Growth Rate, Recruitment Pipeline Strength

35. **Departmental Profitability & Contribution Analysis**:
    Overview: Segments revenue, gross margin, net profit by department (service vs. install) or branch. Flags underperformers; guides pricing/training/marketing focus. Maximizes overall profitability.  
    Type: Quarterly  
    Key variables: Department Net Profit Margin, Blended Gross Margin Across Departments, Departmental Contribution Margin, Revenue Distribution Across Departments, Gross Margin Service Department, Gross Margin Installs and Replacement, Service Department Revenue As Percent, Installations Revenue As Percent

36. **Branch / Location Performance Comparison Report**:
    Overview: Compares revenue %, gross margin %, expenses %, net profit % across branches. Flags underperformers; estimates lift from alignment. Informs investment/close/consolidate decisions.  
    Type: Quarterly (multi-location)  
    Key variables: Revenue Per Branch, Gross Profit Margin, Operating Expenses Per Department As Percent, Net Profit Margin, Revenue Lift

37. **Service vs. Replacement Margin & Mix Optimization Report**:
    Overview: Analyzes revenue mix, departmental margins, profit contribution. Flags over-reliance on low-margin work; calculates uplift from shifting mix (e.g., more service). Boosts net margins without price hikes.  
    Type: Quarterly
    Key variables: New Installs vs Repairs in Percent, Gross Margin Service Department, Gross Margin Installs and Replacement, Service Department Revenue As Percent, Installations Revenue As Percent, Revenue Lift, Blended Gross Margin Across Departments, Departmental Contribution Margin

38. **Overhead Allocation & Departmental Efficiency Report**:
    Overview: Distributes operating expenses by department/branch; compares expense-to-revenue ratios. Flags disproportionate overhead; shows profit gains from allocation/cost control. Optimizes resource deployment.  
    Type: Semi-annual
    Key variables: Operating Expenses Per Department As Percent, Operating Expenses As Percent of Revenue, Blended Gross Margin Across Departments, Net Profit Margin, Departmental Contribution Margin, Revenue Per Branch