A fixed-price project can look profitable at proposal stage and become marginal once extra revisions, coordination, and delivery time appear. This project pricing review template helps you compare estimated and actual labor, allocate overhead, calculate markup and margin, and document scope changes before they become invisible costs. Use it at each milestone, during monthly close, and after delivery to improve your next proposal.
Overview
A project pricing review is a repeatable check on whether the agreed price still covers the work required to deliver it. It is useful for freelancers, studios, consultants, and small teams that sell projects for a fixed fee rather than billing every hour.
The review should answer four questions:
- How many hours were expected, and how many have actually been used?
- What is the loaded labor cost of the people doing the work?
- How much overhead should be assigned to this project?
- After all costs, is the remaining contribution consistent with the target margin?
Keep three figures separate: cost, markup, and margin. Cost is what the work consumes. Markup is the amount added to cost to set a selling price. Margin is the share of revenue left after the relevant costs are deducted. Confusing markup with margin is a common reason that a project pricing calculator produces an overly optimistic result.
For related operational decisions, a quarterly small business software stack audit can help identify tool costs that belong in overhead. If the project includes packaging, fulfillment, or printed materials, separate those direct costs from general project labor and review them with a dedicated label cost calculator.
How to estimate
Start with a spreadsheet containing one row for each role or work category. Avoid using one blended estimate when the project involves different rates or skill levels. A simple sheet can use these columns:
| Column | Purpose |
|---|---|
| Work category | Planning, design, development, review, support, or another defined activity |
| Estimated hours | Hours included in the original proposal |
| Actual hours | Hours recorded to date or at completion |
| Hourly cost | Internal labor cost, not the client-facing billable rate |
| Direct expenses | Items purchased specifically for the project |
| Scope change hours | Time caused by approved or unapproved additions |
Use the following formulas in separate cells:
- Labor cost = actual hours × loaded hourly labor cost.
- Direct project cost = labor cost + project-specific expenses.
- Allocated overhead = overhead allocation rate × the selected allocation base.
- Total project cost = direct project cost + allocated overhead.
- Gross profit = project revenue − total project cost.
- Profit margin = gross profit ÷ project revenue.
- Markup = gross profit ÷ total project cost.
For a fixed-price project, project revenue is usually the contracted fee, excluding amounts that are collected on behalf of a third party. Confirm how taxes, pass-through expenses, discounts, retainers, and deposits are treated in your accounting process before comparing projects.
To calculate the price needed for a target margin, use:
Required price = total project cost ÷ (1 − target margin)
For example, a total cost of 6,000 with a target margin of 25% requires a price of 8,000, because 8,000 − 6,000 equals 2,000, or 25% of revenue. This is different from adding a 25% markup, which would produce a price of 7,500 and a lower margin.
Inputs and assumptions
The quality of a project profitability template depends on consistent inputs. Document the assumptions beside the formulas so another person can understand or update the review.
Billable and non-billable hours
Billable hours are hours that can be assigned to a client project under the agreement. They may include delivery, meetings, revisions, and project administration if those activities are part of the quoted scope. Non-billable time includes sales, general administration, internal training, and downtime. Non-billable time still affects the hourly cost of running the business, so do not assume that every paid working hour can generate client revenue.
Loaded labor cost
Loaded labor cost is the cost of employing or engaging a person for the time used on the project, beyond their headline wage or draw. Depending on the business structure, it may include employer taxes, benefits, paid leave, payroll fees, or other employment costs. For a contractor or owner, use a consistent internal cost assumption rather than mixing personal compensation with a client billing rate.
Overhead allocation
Overhead includes costs that support multiple projects, such as software, workspace, accounting, insurance, equipment, and general administration. Choose one allocation method and use it consistently. Options include allocating overhead by labor hours, direct labor cost, revenue, or another activity measure that fits the business. The method is less useful if it changes from project to project without explanation.
Scope and contingency assumptions
List what the fixed price includes: deliverables, review rounds, meetings, response times, integrations, handoffs, and support after launch. A contingency can be added for known uncertainty, but it should not replace a written change-control process. Record whether contingency hours are included in the quoted price or held as a management reserve.
Worked examples
Example 1: Comparing estimate with actuals
Suppose a project was priced at 10,000. The estimate included 80 hours at a loaded labor cost of 45 per hour and 600 in direct expenses. Estimated direct cost was therefore 4,200 before overhead. If the business allocated 800 of overhead, estimated total cost was 5,000. The estimated gross profit was 5,000, producing an estimated margin of 50%.
At the review point, the team has used 105 hours and incurred 750 in direct expenses. Actual labor cost is 105 × 45, or 4,725. Adding direct expenses and 800 of allocated overhead gives total actual cost of 6,275. Gross profit is now 3,725 and actual margin is 37.25%. The project remains profitable, but the change from the estimate is important: 25 additional hours and 150 more in expenses reduced the expected margin.
Example 2: Is the extra work scope creep?
Assume 15 of the additional hours came from a new deliverable requested after approval, while 10 came from underestimated complexity in the original scope. Record the 15 hours as a scope change and the 10 hours as an estimating variance. If the loaded cost is 45 per hour, the requested addition consumed 675 of labor cost before any associated overhead.
This distinction supports a better client and internal conversation. The scope change may justify a change order or revised fee. The estimating variance may require a better discovery checklist, a larger contingency, or a revised rate for similar work. A scope creep cost calculator should show both the hours and the cost impact, not just a vague note that the project expanded.
Spreadsheet-ready review row
For each category, enter: category | estimated hours | actual hours | variance hours | loaded cost per hour | actual labor cost | scope-change hours | direct expenses | notes. Use formulas such as variance hours = actual hours − estimated hours and actual labor cost = actual hours × loaded cost per hour. Add a summary row for revenue, total cost, gross profit, margin, and unbilled scope-change cost.
When to recalculate
Recalculate the review whenever the inputs or the project conditions change. At minimum, complete it at these points:
- Before sending a proposal: confirm current loaded labor costs, overhead, target margin, and expected hours.
- After a discovery or planning phase: replace broad assumptions with information from the actual requirements.
- At each major milestone: compare hours used and remaining work with the original estimate.
- When a scope change is requested: calculate the added labor, expenses, schedule effect, and margin before approving it.
- During monthly close: reconcile time records, invoices, expenses, deposits, and work in progress.
- After project completion: record the final variance and one or two changes for the next estimate.
- When business costs change: update loaded labor, software, workspace, insurance, contractor, and other overhead assumptions.
Review the template annually even if rates appear stable. Tax treatment, staffing costs, software subscriptions, utilization, and the mix of billable work can change the result. If a project repeatedly misses its target margin, do not immediately apply a blanket price increase. First identify whether the cause is under-scoped work, weak time tracking, unallocated overhead, low utilization, excessive revisions, or an outdated cost assumption.
Save one version of the review with the original estimate and another with the final actuals. That history turns a one-time calculation into a pricing system: future proposals can use evidence from completed work, while scope discussions can rely on documented hours and costs rather than memory.
