Blended Rate Calculator
A blended rate is a weighted average, and nearly every spreadsheet gets it wrong by averaging the rates. A blended rate calculator has to weight each one by hours instead.
Blended bill rate
- Blended bill rate $230,400.00 of billings over 1,600 hours. Weighted by hours, not by headcount. The unweighted average of the rates is $161.25, which differs by $17.25 because the mix is not even.
- $144.00
- Blended cost rate $100,160.00 over the same hours. This is cost per paid hour and is the figure most people stop at, which is where the error creeps in.
- $62.60
- Cost per billed hour $62.60 divided by 75% utilization. Non-billable time has to be carried by the billable hours, so at 75% every billed hour carries $20.87 of somebody's unbilled time. Pricing off the paid-hour cost is the single most common way a services business prices itself into a loss.
- $83.47
- Gross margin as priced $130,240.00 on $230,400.00. This uses the paid-hour cost; against the billed-hour cost the real margin is 42%.
- 56.5%
- Rate needed for 45% margin $7.76 above your current blended rate, about 5.4% more. Note the divisor: cost / (1 - margin), not cost x (1 + margin). A 45% margin is a 1.82x markup, not 1.45x.
- $151.76
- Total hours Senior 320, Mid 640, Junior 480, Lead 160
- 1,600
- Total cost and billings Direct labor only. Overhead, tools, software and non-delivery staff sit below this line and come out of the gross margin.
- $100,160.00 / $230,400.00
| Role | Hours | Share | Cost/hr | Bill/hr | Margin |
|---|---|---|---|---|---|
| Senior | 320 | 20% | $85.00 | $185.00 | 54% |
| Mid | 640 | 40% | $58.00 | $140.00 | 59% |
| Junior | 480 | 30% | $38.00 | $95.00 | 60% |
| Lead | 160 | 10% | $110.00 | $225.00 | 51% |
- A blended rate must be weighted by hours. Averaging the rates themselves assumes every role works the same number of hours, which is never true and usually flatters the senior end.
- Markup and margin are not the same. To reach a 45% margin you divide cost by 0.55, which is a 1.82x markup. Multiplying by 1.45 gives a 31% margin.
How the Blended Rate Calculator works
A blended rate is one hourly figure that stands in for a mixed team. An agency quoting a project with a lead, two seniors, three mid-level people and a junior does not want to present six rates and a staffing table, so it quotes one.
The arithmetic is a weighted average: total billings divided by total hours. The mistake is to average the rates instead, and it is extremely common, including in spreadsheets built by people who should know better. Averaging the rates treats every role as working the same number of hours, which is never true. A team where the junior works twice the hours of the lead has a blended rate well below the arithmetic mean of their rates, and quoting the mean loses money on every project where the mix skews junior.
The second and more expensive error is pricing from the wrong cost. Your cost rate is what somebody costs per hour you pay them. But you cannot bill every hour you pay for: there is vacation, training, sales support, internal work and the gaps between projects. If 75% of paid hours are billable, then every billed hour has to carry a third of an hour of unbilled time on top of itself, and the cost per *billed* hour is the paid-hour cost divided by 0.75, which is a third higher.
Pricing off the paid-hour cost is the single most common way a services business prices itself into a loss while believing it has a healthy margin. It looks profitable per hour and is not profitable per person, and the gap only shows up at the end of the year.
Utilization is therefore not a productivity metric to optimize upward without limit. Sustained utilization above about 85% usually means nobody is doing sales, training or improvement work, and it precedes a bad quarter. The right move is to price correctly for realistic utilization rather than to chase the number.
Third: margin and markup are not the same thing, and confusing them is worth a lot of money. To achieve a 45% gross margin you divide cost by (1 - 0.45), which is a 1.82x markup. Multiplying cost by 1.45 gives a 31% margin, fourteen points short. The required-rate figure above uses the division, which is the correct form.
One thing worth keeping visible underneath the blend: the per-role margins. A blended rate can look perfectly healthy while one role is being billed below its cost, because the others are carrying it. That is often a deliberate choice (loss-leading on a lead's strategic time to win the work), and it should be a choice rather than an accident. The table above shows the margin on each role so the blend does not hide it.
Finally, the blend is only valid for the mix it was computed from. Quote a project at a blended rate and then staff it more senior than planned and you have silently given away margin. Agencies that quote blended rates either hold the mix as a contractual assumption or re-blend when the staffing changes.
Blended Rate Calculator FAQ
How do you calculate a blended hourly rate?
Total billings divided by total hours: a weighted average, not an average of the rates. If a senior at $185 works 320 hours and a junior at $95 works 480, the blended rate is ($59,200 + $45,600) / 800 = $131, not the $140 midpoint of the two rates.
Why is my blended rate lower than the average of my rates?
Because more hours are worked at the lower rates. An unweighted average assumes every role contributes equal hours, which almost never happens. Junior staff typically work more project hours than leads. Weighting by hours is what makes the figure correct, and the gap between the two is usually several dollars an hour.
Should the cost rate include non-billable time?
Your cost per paid hour does not, and that is why you must divide it by your utilization rate to get the cost per billed hour. At 75% utilization, a $58 paid-hour cost is $77 per billed hour. Pricing off the paid-hour figure is the most common way a services business quietly prices below cost.
What rate do I need for a 45% margin?
Cost divided by 0.55, not cost times 1.45. Using the billed-hour cost, a $77 cost needs a $140 rate for a 45% margin. Multiplying by 1.45 would give $112, which is only a 31% margin. The margin-versus-markup confusion is worth about fourteen points here.
What is a good utilization rate?
For most professional services, 70-80% of paid hours billable is healthy. Sustained figures above about 85% usually mean nobody is doing sales, training or internal improvement, and that tends to precede a bad quarter. Price for realistic utilization rather than treating the number as something to maximize.