A 20-person AI agency in Boston analyzed their project profitability for the first time and discovered something that changed how they ran the business. Of their 14 active projects, 8 were generating gross margins above 50% — healthy and sustainable. Three were running at 30-40% — below target but not disastrous. And three projects, representing 28% of total revenue, were running at negative margins. The agency was literally paying to do work for those three clients. When they dug deeper, the common thread was clear: all three projects had been scoped by the sales team without delivery input, all three involved new technology areas where the team was learning on the job, and all three had absorbed significant scope creep without corresponding billing increases.
Project profitability analysis is the practice of understanding the true financial performance of each engagement your agency delivers. It reveals which clients, project types, and service lines are generating profit and which are destroying it. Without this visibility, you are making pricing, staffing, and growth decisions in the dark.
The Profitability Calculation
Revenue
For each project, track revenue based on the billing model:
Fixed price: Total contract value, recognized proportionally to work completed (percentage of completion method) Time and materials: Actual hours billed multiplied by contracted billing rates Retainer: Fixed monthly fee, allocated to months of service
Direct Costs
Direct costs are the costs directly attributable to delivering the project:
Labor costs (loaded): For each team member working on the project:
- Hours worked on the project (from time tracking)
- Multiplied by their fully loaded cost rate
Fully loaded cost rate calculation:
- Base salary: $180,000/year
- Benefits (health, dental, vision, retirement): +25% = $45,000
- Payroll taxes: +8% = $14,400
- Equipment and software: $4,800/year
- Total loaded cost: $244,200/year
- Available work hours: 1,840/year (2,080 minus PTO, holidays, sick days)
- Loaded cost rate: $132.72/hour
Why loaded costs matter: If you calculate profitability using base salary only, you overstate margins by 25-40%. A project that looks like it has a 50% margin on base salary may actually have a 35% margin on loaded costs. The decisions you make based on inflated margins lead to underpricing and overcommitting.
Non-labor direct costs:
- Cloud infrastructure costs attributable to the project
- Third-party API costs
- Data acquisition costs
- Contractor costs for project-specific work
- Travel costs for client meetings
- Project-specific software licenses
Gross Profit and Gross Margin
Gross profit = Revenue minus Direct costs Gross margin = Gross profit / Revenue x 100
Benchmarks:
- Excellent: 60%+ gross margin
- Healthy: 50-60%
- Acceptable: 40-50%
- Concerning: 30-40%
- Unacceptable: Below 30%
Contribution to Overhead
After gross profit, the project contributes to the agency's overhead (rent, tools, administration, sales, marketing). The remaining profit after overhead allocation is the project's net contribution.
Simple overhead allocation: Total monthly overhead / Total billable hours = Overhead cost per billable hour
Apply this rate to each project's hours to calculate overhead allocation and net contribution.
Building Your Profitability Tracking System
Real-Time Tracking
Project profitability should be tracked in real time, not calculated after the project is complete. By the time a project is finished, it is too late to fix margin problems.
Weekly tracking for large projects (over $100,000):
- Hours worked by team member (from time tracking)
- Costs incurred (labor hours x loaded rate, plus expenses)
- Revenue earned (percentage of completion or hours billed)
- Current margin
- Projected margin at completion (based on remaining work and current cost trajectory)
- Variance from plan (actual margin versus estimated margin)
Biweekly tracking for smaller projects: Same metrics, reviewed every two weeks.
Automated alerts: Set alerts for:
- Project margin drops below 40%
- Project costs exceed 80% of budget with more than 25% of work remaining
- Hours consumed exceed estimate by 20%
- Individual team member hours significantly exceed their allocation
Earned Value Analysis
Earned Value Management (EVM) provides a rigorous framework for tracking project financial health:
Budget at Completion (BAC): Total budgeted cost for the project Earned Value (EV): Percentage of work completed multiplied by BAC Actual Cost (AC): Actual costs incurred to date
Key calculations:
- Cost Performance Index (CPI) = EV / AC. Above 1.0 means under budget, below 1.0 means over budget.
- Schedule Performance Index (SPI) = EV / Planned Value. Above 1.0 means ahead of schedule, below 1.0 means behind schedule.
- Estimate at Completion (EAC) = BAC / CPI. Projected total cost based on current performance.
- Variance at Completion (VAC) = BAC - EAC. Projected budget variance.
Example:
- BAC: $150,000
- Project is 60% complete, so EV = $90,000
- Actual costs to date: $105,000 (AC)
- CPI = $90,000 / $105,000 = 0.86 (14% over budget)
- EAC = $150,000 / 0.86 = $174,419 (projected to finish $24,419 over budget)
This tells you at the 60% mark that the project is trending toward a significant overrun, giving you time to take corrective action.
Profitability Analysis by Dimension
By Client
Aggregate project profitability by client to understand which client relationships are most valuable:
- Total revenue from the client (trailing 12 months)
- Total direct costs for the client's projects
- Gross margin for the client
- Number of projects
- Average project margin
- Trend (is the client's profitability improving or declining?)
Insight: You may discover that your largest client by revenue is not your most profitable. A smaller client with 60% margins is more valuable per dollar than a larger client with 35% margins.
By Service Type
Analyze profitability by the type of service delivered:
- Strategy and consulting: Typically highest margins (60-70%) because of lower direct costs and higher billing rates
- Data engineering: Moderate margins (45-55%) — more predictable but lower billing rates
- Model development: Variable margins (35-55%) — high billing rates but high risk of scope overrun
- Integration and deployment: Moderate margins (40-50%) — often underscoped
- Ongoing support and maintenance: High margins (55-65%) — predictable and efficient at scale
Insight: If model development consistently generates lower margins than other service types, you may need to change how you scope and price that work.
By Team Member
While sensitive, understanding profitability by team member reveals important patterns:
- What is each person's effective billing rate? (Revenue they generate / hours they work on billable projects)
- What is their margin contribution? (Revenue they generate minus their loaded cost)
- Are there consistent differences in profitability between team members at the same level?
Insight: Differences in profitability between team members often reflect differences in efficiency, scope management, or the types of projects they are assigned to. This is coaching information, not punishment information.
By Deal Source
Analyze profitability by how the deal originated:
- Inbound leads versus outbound sales
- Referral clients versus direct acquisition
- Existing client expansion versus new client
Insight: Referral clients often have higher margins because of stronger trust, shorter sales cycles, and better-fit expectations.
Using Profitability Data
Pricing Improvements
Use historical profitability data to improve pricing:
- Identify project types that consistently underperform. Increase prices or add contingency buffers.
- Identify tasks that consistently take longer than estimated. Adjust estimation guidelines.
- Compare effective billing rates to published rates. If you are consistently billing below published rates, your discounting is too aggressive.
Scoping Improvements
Use profitability data to improve scoping accuracy:
- Track the ratio of estimated hours to actual hours by task type and project type
- Build a database of actual effort for common tasks (data cleaning, model training, API integration)
- Identify which project types have the most estimation variance and focus scoping improvements there
Staffing Decisions
Use profitability data to make better staffing decisions:
- Assign your most efficient team members to projects with tight margins
- Invest in training for team members who consistently underperform on margin
- Consider whether certain work is better delivered by contractors (variable cost) than employees (fixed cost)
Client Relationship Decisions
Use profitability data to manage client relationships:
- Invest more in high-margin, high-revenue client relationships
- For low-margin clients, either renegotiate pricing/scope or consider whether the relationship is worth maintaining
- Track margin trends by client — declining margins may signal a relationship that needs attention
Go/No-Go Decision for New Projects
Use profitability data to inform whether to pursue new opportunities:
- What is the expected margin based on similar past projects?
- Does the pricing allow for minimum acceptable margin after realistic cost assumptions?
- Are there risk factors that historically lead to margin erosion (new technology, unclear data, complex integration)?
Common Profitability Killers
Killer 1: Scope Creep
The most common profitability killer. Small additions accumulate into significant uncompensated work.
Quantify it: Track the percentage of total project hours that are attributable to scope changes not covered by change orders. For many agencies, this is 15-25% of total effort.
Killer 2: Rework
Work that must be redone due to quality issues, misunderstood requirements, or changing direction.
Quantify it: Track rework hours as a percentage of total project hours. Target under 15%.
Killer 3: Underestimation
Systematically estimating less effort than the work actually requires.
Quantify it: Compare estimated hours to actual hours for completed projects. If actual consistently exceeds estimates by more than 20%, your estimation process needs improvement.
Killer 4: Non-billable Project Time
Time spent on project-related work that cannot be billed — internal meetings, context switching, waiting for client input, administrative overhead.
Quantify it: Track the ratio of billable to total project time. If team members are logging 40 hours on a project but only billing 30, 25% of the project time is non-billable overhead.
Killer 5: Staffing Mismatch
Using senior (expensive) team members for tasks that junior (less expensive) team members could handle.
Quantify it: Compare the loaded cost rate of team members assigned to tasks versus the cost rate appropriate for those tasks. Senior engineers doing junior-level data cleaning is a direct margin hit.
Your Next Step
This week:
- Calculate loaded cost rates for every team member. Use these for all profitability calculations going forward.
- Pick your largest active project and calculate its current margin using loaded costs. How does it compare to the margin assumed during pricing?
- Review time tracking data for the past month. Are all project hours being captured?
This month:
- Build a project profitability tracker for all active projects. Review it weekly for large projects, biweekly for smaller ones.
- Analyze profitability for your last 10 completed projects. Identify patterns in which projects are profitable and which are not.
- Set up automated alerts for projects approaching or exceeding budget.
This quarter:
- Analyze profitability by client, service type, and deal source. Identify your most and least profitable segments.
- Use the analysis to adjust pricing and scoping practices.
- Build a historical estimation database to improve future project estimates.
- Implement earned value tracking for all projects over $100,000.
Project profitability is the most actionable financial metric in your agency. It tells you where to focus, what to fix, and how to grow. The agencies that track it religiously make better decisions about pricing, staffing, and client relationships. The ones that do not are flying blind.