CVP analysis for service companies: hours, cost, and capacity

CVP analysis for service companies translates billable hours into contribution and profit, then checks whether the team can actually deliver those hours. The important constraint is available billable capacity after nonbillable work. A break-even target above that ceiling needs a change in price, delivery cost, staffing, or scope.

Start with a period and a delivery unit

Use one planning month and a unit that reflects how work is sold. Hours suit time-based consulting; completed engagements may suit standardized projects. Do not mix hours and engagements in one volume column.

The calculation follows the contribution approach described in OpenStax's break-even explanation: sales cover variable costs first, then fixed costs, with the remainder becoming profit.

Contribution per billable hour = Realized hourly revenue - Variable delivery cost per hour

Break-even billable hours = Period fixed costs / Contribution per billable hour

Operating profit = Billable hours × Contribution per hour - Period fixed costs

The general break-even analysis explains the underlying formula. For services, the extra work is establishing which hours earn revenue and which costs change when those hours change.

Assemble the workbook from existing exports

Bring an invoice or revenue export, a time report, a payroll and overhead summary, and a staffing calendar. Keep service, client, employee or contractor identifier, work date, billed hours, realized revenue, and variable delivery expense where available. Use one shared month and service classification.

The finance owner should reconcile recognized revenue to the ledger, then explain any difference from invoiced revenue. The operations owner should reconcile worked hours to the time system and approve nonbillable allowances. A billing write-down reduces realized revenue even if the engagement used every planned hour.

Keep salaried delivery payroll in fixed costs when it is committed for the month. Do not also allocate the same salaries into variable cost per hour. The presentation of labor in cost of goods sold is a separate accounting question from its behavior in this decision.

Calculate contribution for two services

A US consulting company plans the following monthly work. Variable expenses are hourly contractor support and job-specific delivery costs; the company's own salaries are included in fixed costs below.

With these columns in A:G and the service rows in rows 2:3, use these Excel formulas and fill down:

E2=B2*C2
F2=B2*D2
G2=E2-F2

The contribution check is =SUMPRODUCT(B2:B3,C2:C3-D2:D3). It returns $98,000, matching total revenue less variable expense. Microsoft documents SUMPRODUCT as the sum of products of corresponding ranges.

Both services contribute $140 per hour here: 200 - 60 and 160 - 20. Total contribution divided by total hours also gives 98,000 / 700 = $140. If service contributions differ, hold the planned service mix explicit and recompute the weighted contribution when that mix changes.

Compare break-even hours with usable capacity

The same month has these cost and capacity inputs:

If fixed cost is in B8, contribution per hour in B9, and available capacity in B10:

B11=B8/B9
B12=B11/B10
B13=B10-B11

Format B12 as a percentage. B13 shows 100 hours of capacity beyond break-even. Those hours are useful only if demand exists and the available people have the required skills. Track capacity utilization with a stated denominator; paid hours and available billable hours answer different questions.

Test volume and the next staffing step

Keep contribution at $140 per hour for these supplied scenarios. The first four use fixed costs of $98,000 and existing billable capacity of 800 hours.

The staffing scenario adds $14,000 of monthly fixed costs and 120 available billable hours. Its capacity becomes 800 + 120 = 920 hours; its new break-even point is 112,000 / 140 = 800 hours. At 850 hours it earns $7,000, less than the existing team at its capacity ceiling, despite delivering more work.

This is why extending a straight profit line beyond capacity fails. OpenStax describes step costs and relevant ranges: costs can stay unchanged over one activity range and rise at the next threshold. Wider financial ratios for service companies complement this delivery-level decision.

Where it goes wrong

• Counting payroll twice. Fixed salaries also charged as variable hourly costs understate contribution and overstate break-even hours.
• Treating paid hours as sellable hours. Leave and internal work consume capacity even when they produce no client invoice.
• Using the list rate. Discounts, fixed-fee overruns, and write-downs make realized revenue per delivered hour lower.
• Ignoring staffing steps. A volume target beyond existing capacity requires its own cost and ramp assumptions.
• Keeping the old mix. Different services can consume different skills and contribute different amounts per hour.

Check your service workbook in Covirage

Bring a sample of your own service revenue, delivery-cost, time, and capacity files to Covirage. Covirage maps the columns; its tools compute and check contribution and supplied capacity scenarios, while the external AI model explains the results with every figure traced to its rows. Create a free Covirage account; account creation takes about a minute.

See Covirage for professional services for the business context.

Covirage is not affiliated with Microsoft.