Executive Summary
Return On Assets
69.7%
Asset-to-Revenue
312.5%
Revenue-to-Profit
22.3%
Profit-to-Cash
85.1%
Financial Performance
Revenue
Net Profit
Cash Flow
Gross Margin %
Operational Metrics
Payroll
Hours Worked
Team Size
Labor Utilization %
Balance Sheet Snapshot
$42,800
$8,200
$95,000
$157,300
CRM Pipeline Overview
Total pipeline value: $503,000 across 13 deals
$85,000
Thompson Kitchen Remodel
Sarah Thompson
Garcia Bathroom Renovation
Miguel Garcia
Park Basement Finish
David Park
$40,500
Wilson Deck Build
Jennifer Wilson
Chen Master Bath
Amy Chen
$100,000
Rodriguez Full Reno
Carlos Rodriguez
Baker Garage Conversion
Tom Baker
$132,500
Miller Kitchen & Bath
Lisa Miller
Johnson Addition
Robert Johnson
Davis Porch Build
Mark Davis
$145,000
Anderson Whole House
James Anderson
Taylor Bathroom
Susan Taylor
Brown Kitchen
Michael Brown
Job Profitability — 4-Category Cost Breakdown
| Job | Sale Price | Labor | Materials | Subs | Fees | Disposal | Overhead | Net Profit | Margin |
|---|---|---|---|---|---|---|---|---|---|
Miller Kitchen & BathLisa Miller | $48,000 | $12,800 | $8,200 | $3,800 | $1,600 | $800 | $4,800 | $16,000 | 33.3% |
Johnson AdditionRobert Johnson | $72,000 | $19,200 | $12,500 | $5,400 | $2,200 | $1,500 | $7,200 | $24,000 | 33.3% |
Davis Porch BuildMark Davis | $12,500 | $3,200 | $3,100 | $0 | $875 | $400 | $1,250 | $3,675 | 29.4% |
Anderson Whole HouseJames Anderson | $95,000 | $25,600 | $16,000 | $7,500 | $3,000 | $2,000 | $9,500 | $31,400 | 33.1% |
Taylor BathroomSusan Taylor | $18,000 | $3,840 | $4,200 | $1,200 | $600 | $300 | $1,800 | $6,060 | 33.7% |
Brown KitchenMichael Brown | $32,000 | $8,000 | $5,800 | $2,200 | $1,000 | $600 | $3,200 | $11,200 | 35.0% |
Crew Performance
Lead Carpenter
Carpenter
Apprentice
Electrician Sub
Painter
AI Insights
Revenue Growth Trend
Revenue peaked at $82,000 in July 2025 and has been declining seasonally. Current December revenue of $35,000 is typical for the winter slowdown. Consider booking interior projects (kitchens, bathrooms) to maintain cash flow through Q1.
COGS Ratio Increasing
Your cost of goods sold as a percentage of revenue has risen from 48% in July to 63% in December. Material costs may be rising or you may be discounting during the slow season. Review your pricing on recent bids.
Labor Utilization Below Target
Current labor utilization is at 81.8%, below the 85% target. With 5 employees in December, consider cross-training crew members or scheduling maintenance/prep work to fill gaps.
Credit Card Balance Trending Up
Business credit card balance has reached $8,200. The Home Depot card at $3,100 suggests material purchases are being financed. Consider negotiating net-30 terms with your top 3 suppliers instead.
Strong Pipeline Value
Your pipeline has $358,000 in total deal value across all stages. If you close at your historical 65% rate, that projects to $232,700 in upcoming revenue — enough to cover Q1-Q2 operating costs.
Ready to See Your Own Numbers?
Connect your QuickBooks in 5 minutes and get the same level of insight for your business. No spreadsheets. No guessing. Just clarity.
