Turning an hourly rate into a fixed project price requires more than multiplying hours by a number. This guide explains how to build a repeatable hourly rate to project price workflow, account for non-billable time and overhead, test markup and margin, and use an editable workbook structure for proposals that remain profitable when assumptions change.
Overview
An hourly rate is an input. A project price is a commitment based on scope, effort, risk, and the result the client expects. If you simply multiply a visible hourly rate by estimated hours, you may leave out planning, administration, revisions, software, employer costs, downtime, or contingency. The result can look competitive while producing little usable profit.
A practical project pricing template should separate four layers:
- Direct delivery cost: the internal cost of the people doing the work.
- Project effort: the hours required for discovery, production, communication, review, and delivery.
- Project adjustments: contingency, rush handling, complexity, or other clearly defined factors.
- Commercial price: the amount presented to the client, excluding or including tax according to your normal proposal format.
The downloadable-style workbook described here can be built in Excel or Google Sheets with separate tabs for staff rates, scope breakdown, pricing calculations, markup and margin references, and the client-facing proposal price sheet. Keeping the internal assumptions separate from the client view makes the file easier to review and reuse.
How to estimate a project price from an hourly rate
Use the following sequence for each new quote.
1. Define the deliverable and boundaries
Write down what the client receives, what is excluded, the number of review rounds, the expected timeline, and the client inputs required. A vague scope creates an unreliable hour estimate. A short scope-breakdown checklist is often more valuable than a complex formula.
2. Break the work into activities
List tasks rather than estimating the project as one block. Typical rows might include discovery, planning, production, internal review, client meeting time, revisions, quality control, file preparation, and project closeout. Add an owner or role to each row so that different internal rates can be applied.
3. Estimate hours by role
For each activity, enter the estimated hours and the applicable internal cost rate or billable rate. The basic cost calculation is:
Task cost = estimated hours × hourly cost rate
Then total the task costs. If more than one person contributes, retain each role as a separate line instead of averaging the rates too early.
4. Add reasonable project protection
Apply a contingency only after the scope has been estimated. It should reflect uncertainty such as incomplete requirements, dependencies, or a new type of work. Do not use contingency to disguise an unclear scope. State internally what the allowance covers and whether unused time is tracked.
5. Convert cost into a price
If your target is a markup on cost, use:
Price = total cost × (1 + markup percentage)
If your target is a margin on the selling price, use:
Price = total cost ÷ (1 − target margin percentage)
These formulas are not interchangeable. A 25% markup and a 25% margin produce different prices. Include both columns in the workbook and label them clearly.
6. Check the result against the scope
Before sending a proposal, compare the proposed price with the hours, delivery schedule, staffing plan, and exclusions. If the number feels too high, reduce scope or change the delivery approach rather than silently cutting the hours needed to do the work properly.
Inputs and assumptions for the pricing workbook
A reliable hourly rate to project price calculator depends on transparent assumptions. Create an assumptions tab with the date reviewed and the person responsible for maintaining it.
Internal cost inputs
- Base pay or contractor cost for each role
- Employer taxes, benefits, and other people-related costs where applicable
- Software, equipment, insurance, facilities, and other operating overhead
- Expected productive or billable capacity, separated from total available working time
- Currency and whether rates are shown before or after applicable taxes
A simple loaded hourly cost can be estimated by adding relevant employment and overhead costs to compensation, then allocating that total across realistic productive hours. Avoid treating every paid hour as billable; administration, sales, training, leave, and internal work also need to be funded.
Scope inputs
- Task or deliverable name
- Role responsible
- Estimated hours
- Number of review or revision cycles
- Dependencies and client-provided inputs
- Contingency percentage or contingency hours
Commercial inputs
Record the target markup, target margin, payment schedule, validity period, minimum project fee if one is used, and any rush or complexity adjustment. Keep taxes, discounts, and payment terms visible as separate rows. This makes the proposal easier to audit and reduces the chance that a discount is mistaken for a lower delivery cost.
For related planning, a break-even and profit margin calculator guide can help connect project pricing with broader fixed-cost and profitability decisions. The profit margin and markup calculator guide is useful when checking the difference between the two measures.
Worked examples
Example 1: One role with a markup target
Assume a project requires 32 hours and the internal loaded cost is $40 per hour. The estimated delivery cost is:
32 × $40 = $1,280
With a 25% markup on cost, the proposed price would be:
$1,280 × 1.25 = $1,600
The gross profit amount before other adjustments is $320. The margin on the selling price is 20%, not 25%, because the markup was calculated from cost.
Example 2: Multiple roles and contingency
Suppose a project includes 10 hours of planning at $50 per hour, 20 hours of production at $40 per hour, and 6 hours of review and delivery at $35 per hour.
- Planning: 10 × $50 = $500
- Production: 20 × $40 = $800
- Review and delivery: 6 × $35 = $210
The estimated cost is $1,510. If the workbook adds a 10% contingency, the protected cost basis is $1,661. With a target margin of 30%, the price calculation is:
$1,661 ÷ 0.70 = $2,372.86
Depending on your pricing policy, this may be rounded to a clean proposal figure. The proposal should still identify the scope, included revision rounds, assumptions, and exclusions rather than presenting the number without context.
Example 3: Fixed price versus hourly billing
A fixed price is appropriate when the scope and acceptance criteria can be described clearly. Hourly billing may be more suitable when requirements are expected to change or when the client controls important dependencies. The same internal estimate can inform either model, but the commercial risk is different. A fixed-price quote should include stronger scope controls, change-order language, and a process for approving work outside the original estimate.
When to recalculate your project pricing
Recalculate the workbook whenever a pricing input changes, not only when a new year begins. Review it before each proposal if the project uses different roles, unusual scope, or significant uncertainty.
Run a broader rate-card review at least when there are changes to pay, benefits, employer costs, software, facilities, capacity, currency, or tax treatment. Update benchmark and example rows when your team’s cost structure shifts rather than carrying old examples forward automatically. If you use industry reference ranges, treat them as discussion points and validate them against your own delivery economics.
A quarterly margin audit can reveal whether estimated hours match actual hours. Compare quoted hours with time spent by task, review where overruns occurred, and record whether the cause was scope change, underestimation, rework, or internal inefficiency. Then update the relevant assumption instead of applying a blanket increase to every project.
Before sending the next proposal, use this short final check:
- Confirm the scope, exclusions, assumptions, and client responsibilities.
- Check that every role and task has realistic hours.
- Verify loaded cost inputs and the date they were last reviewed.
- Choose either markup or margin deliberately and confirm the formula.
- Test the price against the required timeline and available capacity.
- Transfer only the approved client-facing figures to the proposal price sheet.
- Schedule a review after delivery so actual effort can improve the next estimate.
This workflow turns an hourly rate into a defensible project price while keeping the calculation editable. Save a clean master workbook, duplicate it for each quote, and maintain a separate rate-card version so new hires, raises, overhead changes, and market conditions can be reflected without rebuilding the model.
