Project Profitability Analyzer
Rank every active project by margin contribution, identify scope creep, and pinpoint which engagements are creating or destroying firm-wide profitability.
Project Margin Ranking
Gross margin by project β green β₯30%, yellow 15β30%, red <15%
Project Detail Matrix
Complete profitability breakdown with hours variance analysis
| Project | Type | Revenue | Cost | Gross Profit | Margin | Hours Var. | $/Hour | Status |
|---|
Engagement Type Comparison
Fixed-fee vs. T&M performance
Portfolio Health
Executive Recommendations
Prioritized actions to improve portfolio profitability
Methodology & Assumptions
Gross Profit = Revenue β (Labor Cost + Expenses). Net Profit = Gross Profit β Overhead Allocation. Hours Variance = Actual Hours β Planned Hours. Scope creep flag triggers at >5% hours overrun.
Overhead allocation is applied as a percentage of project revenue. Effective rate = Revenue Γ· Actual Hours. Sample projects are pre-loaded; edit values in the input panel to reflect your portfolio.