Description

This interactive Project Profitability Calculator is built for services businesses – engineering, IT, consulting, agencies – that run fixed-price or time & materials (T&M) projects. Capture roles, rates and hours, plus subcontractors, travel, software and other direct costs, and the tool automatically calculates revenue, direct cost, gross profit, overhead allocation, contingency, net profit and net margin for each scenario.

You can compare Scenario A vs B, adjust discounts, overhead %, contingency and utilisation targets, and instantly see the impact on profitability, effective rate, breakeven hours and utilisation vs target. With currency & VAT options, autosave, CSV export and a notes section for assumptions, it gives you a repeatable way to sanity-check every proposal before sending it to the client.

Key features

• Model Fixed Price or T&M projects
• Roles table for rate/hr, hours, cost/hr and billable vs non-billable
• Other direct costs: subcontractors, travel, software, materials with markup & charge-through
• Automatic revenue, gross profit, net profit and margin % calculation
• Overhead and contingency as configurable percentages
• Billable hours, effective rate, breakeven hours & utilisation vs target
• Scenario A/B comparison, CSV export, autosave to browser and space for notes/assumptions