Job Costing & Project Profitability Calculator

What is job costing and why does it matter for service businesses?

Job costing is the practice of tracking all costs tied to a specific project — labor, subcontractors, direct expenses, and overhead — and comparing them against that project's revenue to calculate gross profit and margin per engagement.

Most service businesses know their overall company margin but not their per-project margin. Job costing makes the per-project number visible, which is where the decision-relevant information lives. A consulting firm can run a 35% blended margin across all clients while simultaneously losing money on two of them and carrying the rest at 55% — without project-level costing, every client looks identical in the P&L.

The four cost components of a fully costed project:

• Direct labor — hours worked × loaded hourly rate. The loaded rate includes wages, employer payroll taxes, and benefits, not just the base wage. Using raw hourly pay understates labor cost by 25–40%.
• Direct costs — subcontractor fees, materials, software licenses, travel, and any other expense incurred specifically for this engagement.
• Overhead allocation — indirect costs (rent, software subscriptions, admin salaries, utilities) distributed to the project proportionally, typically as a percentage of direct labor.
• Gross profit — revenue minus all of the above. Gross margin is gross profit expressed as a percentage of revenue.

Many businesses underestimate indirect costs, leading to a reduction in net profit by 20–30% compared to gross profit. Job costing catches that gap before it becomes a pattern.

How do I use this calculator to analyze a completed project?

Here is a complete walkthrough using the default scenario: a web agency completing a $25,000 website redesign.

Step 1: Enter the project financials.

• Project revenue: $25,000 (what the client paid)
• Quoted project cost: $15,000 (your original estimate)
• Target gross margin: 50% (the firm's standard margin goal)

These three inputs set the baseline. The calculator immediately shows your quoted margin — (25,000 − 15,000) ÷ 25,000 = 40.0% — and will compare it against actual margin once costs are entered.

Step 2: Enter labor inputs.

• Loaded hourly rate: $75 (blended across designer, developer, and project manager at true loaded cost)
• Quoted hours: 150 (what the original scope projected)
• Actual hours logged: 175 (what the team actually worked, including non-billable time)
• Billable hours: 155 (hours invoiced to the client)

The 20-hour gap between actual (175) and billable (155) represents unbilled scope creep — time worked but not recovered through invoicing.

Step 3: Enter direct costs.

• Subcontractor cost: $1,500 (a freelance copywriter engaged for the project)
• Direct expenses: $500 (stock photography and font licenses)
• Overhead rate: 15% of direct labor

Step 4: Read the outputs.

• Actual labor cost: $13,125 (175 hrs × $75)
• Overhead: $1,969 ($13,125 × 15%)
• Total direct cost: $17,094
• Gross profit: $7,906
• Actual margin: 31.6% vs. 40.0% quoted
• Cost variance: +$2,094 over budget
• Margin erosion: 8.4 percentage points below the quoted margin
• Hours overrun: +25 hours beyond scope
• Realization rate: 88.6% (155 billable ÷ 175 actual)
• Effective hourly rate: $161.29 (revenue ÷ billable hours)
• Cost per hour delivered: $97.68 (total cost ÷ actual hours)

Step 5: Diagnose and decide.

The diagnosis is specific: 25 hours of scope overrun, of which 5 were billed and 20 were absorbed. Those 20 unrecovered hours at $75 loaded rate = $1,500 in margin that left the project without hitting the invoice. The remaining $594 of cost variance came from overhead on the overrun hours. The fix for the next similar project: a change order clause triggered at 10% over quoted hours, or a 15% contingency buffer built into the original quote. Either closes most of the gap.

What is a good gross margin on a service project?

Benchmarks vary significantly by sector and pricing model, but published ranges for professional services:

In professional services, a net profit margin between 10% and 20% is typical, with gross margins often ranging from 50% to 70%. Gross margin is higher than net because it excludes firm-wide overhead (salaries of non-billable staff, office costs, software) that reduces the gross figure to the net.

The margin vs. target output in this calculator gives you an immediate read on whether any individual project cleared your firm's standard threshold. A single project at −18 pp is recoverable; a pattern of −18 pp across your client base is a pricing or scoping problem that compounds into a firm-level margin problem.

10–15% gross margin is break-even territory for most trade businesses once all costs are accounted for. 20–25% is healthy. 30%+ is where PE-ready businesses operate. For pure professional services where labor is the dominant cost, these thresholds shift upward — sub-40% delivery margin generally signals either underpricing or chronic scope overrun.

What do realization rate and effective hourly rate actually tell you?

These two outputs answer different questions and are most useful read together.

Realization rate = billable hours ÷ actual hours logged. In the default scenario: 155 ÷ 175 = 88.6%. This tells you what percentage of the time your team worked on this project ended up on an invoice. The unrecovered 11.4% (20 hours) represents time spent on the client's work that you absorbed rather than billed — scope creep, goodwill revisions, internal rework, or unclear change order boundaries.

A realization rate below 80% on a fixed-fee project is a scoping problem. Below 70% is a structural problem that will repeat across every similar engagement until the contract language or the quoting process changes.

Effective hourly rate = project revenue ÷ billable hours. $25,000 ÷ 155 = $161.29. This is the rate you actually earned per hour billed — useful for comparing across projects and for checking whether a project's effective rate covered your cost structure.

Cost per hour delivered = total direct cost ÷ actual hours. $17,094 ÷ 175 = $97.68. This is what each of those 175 hours cost you in loaded labor, direct expenses, and overhead.

The spread between effective hourly rate ($161.29) and cost per hour ($97.68) is your per-hour profit: $63.61. As scope creep drives actual hours upward without additional billing, cost per hour rises while effective hourly rate stays flat — compressing this spread until you break even. Running this calculation after every project gives you an early warning when a client relationship or project type is systematically eroding the spread.

What is the difference between job costing and project quoting — and which should I use when?

They are complementary tools that answer opposite questions at opposite ends of the project lifecycle.

Project quoting is forward-looking: you estimate what a project will cost before starting it, then add your target margin to arrive at a price. Inputs are estimates — projected hours, expected materials, anticipated subcontractor spend. The output is a number to put in front of the client. Most free job cost calculators online are actually quoting tools: labor estimate + materials + overhead + desired profit = price. For Sheetflow's quoting tool, see the Project Pricing & Consulting Quote Builder.

Job costing is backward-looking: once the project is complete, you enter actuals — what you actually spent, what you actually billed, how many hours were really logged — and calculate what the margin truly was. This calculator is explicitly a post-project tool. There are no estimates here; every input should come from your time tracking system, your invoices, and your accounting records.

The feedback loop between the two tools is where most service businesses leak margin invisibly. A firm that quotes carefully but never costs projects retrospectively has no systematic way to know whether their quotes are accurate. The pattern is predictable: poor tracking leads to actual job costs being 15–20% higher than initially calculated, significantly impacting financial health in service industries where margins are often tight.

Running both tools consistently closes the loop: quote → deliver → compare actuals to estimate → adjust next quote. The hours variance output in this calculator — +25 hours over scope in the default scenario — becomes the direct input to a more accurate quote next time. Over several projects, the gap between quoted and actual margin should narrow as estimates improve.