Project Profitability Analysis

Overview

Project profitability analysis compares project revenue against all costs (primarily labor) to determine true profit margins, revealing which work is financially successful and which drains resources.

Basic Formula

Profit Margin % = ((Revenue - Total Costs) / Revenue) × 100

Revenue

• Fixed fee or actual hours billed
• Plus any additional charges

Costs

• Labor: Actual hours × team member rates
• Materials/expenses
• Overhead allocation
• Software/tools

Key Metrics

Gross Profit

Revenue minus direct costs (labor, materials)

Profit Margin %

What percentage of revenue is profit Target: 30-50% for service businesses

Effective Hourly Rate

Revenue / Total Hours Worked Shows true value per hour

Budget Variance

Actual hours vs. estimated hours Indicates estimation accuracy

Analysis Process

1. Gather Data

• Total project revenue
• All time tracked (billable + non-billable)
• Team member cost rates
• Expenses incurred

2. Calculate Labor Cost

Sum of (Hours Worked × Employee Cost Rate) Use loaded rate (salary + benefits + overhead)

3. Determine Total Project Cost

Labor + Materials + Expenses + Overhead

4. Calculate Profit

Revenue - Total Cost

5. Compute Margin

(Profit / Revenue) × 100 = Margin %

Insights Generated

By Project Type

Which services are most profitable?

• Web development: 40% margin
• Maintenance: 25% margin
• Training: 60% margin

Action: Focus sales on high-margin services

By Client

Which clients are profitable?

• Client A: 45% margin (great!)
• Client B: 10% margin (scope creep, underpriced)
• Client C: -5% margin (losing money!)

Action: Renegotiate with low-margin clients or fire them

By Team Member

Which team members drive profitability?

• Senior A: High cost but very efficient
• Junior B: Low cost but requires supervision

Action: Optimize team allocation

By Project Phase

Which phases consume most time?

• Discovery: 10% of time, 5% of budget
• Development: 60% of time, 50% of budget
• Testing: 30% of time, 20% of budget (over!)

Action: Improve testing estimates, invest in automation

Tools for Analysis

• Scoro: Built-in profitability dashboards
• Productive.io: Real-time project profit tracking
• Harvest: Simple profit reports
• BigTime: Advanced PSA analytics
• Kantata: Enterprise profitability tools

Common Findings

Underpricing

Projects consistently under 20% margin indicate pricing too low.

Poor Estimation

Large variance between estimated and actual hours.

Scope Creep

Revenue fixed but hours ballooning.

Inefficient Delivery

High hours relative to deliverables.

Actions to Improve Profitability

1. Raise Prices: Especially on high-demand, low-margin work
2. Improve Estimates: Use historical data
3. Control Scope: Strict change order process
4. Optimize Teams: Right skill level for each task
5. Automate: Reduce labor hours needed
6. Fire Bad Clients: Those consistently unprofitable
7. Focus Sales: On high-margin services
8. Productize: Turn services into repeatable offerings