Project Quote from Estimated Hours

Excel Formulas › Freelance & Agency

All versionsSUMPRODUCT

Quote a fixed-price project from a task breakdown: estimated hours per task times the rate, summed, plus a buffer for the unexpected. SUMPRODUCT totals it in one formula.

Quick formula: quote from hours and rate with a buffer:

=SUMPRODUCT(task_hours, task_rates) * (1 + buffer)

Each task's hours times its rate, summed, then padded by a contingency buffer.

Functions used (tap for the full reference guide):

SUMPRODUCT

The example

40 hrs at $80 + 15% buffer.

	A	B
1	Item	Value
2	Base (40×80)	3200
3	+15% buffer	→ $3,680

The formula

The formula:

=SUMPRODUCT(task_hours, task_rates) * (1 + buffer) // Σ(hours × rate) × (1 + buffer)

How it works

How it works:

List each task’s estimated hours and the rate for whoever does it.
SUMPRODUCT(hours, rates) sums the per-task costs — the base quote.
Multiply by (1 + buffer) for contingency (10–20% covers scope surprises).
For a single rate, simplify to SUM(hours) * rate * (1 + buffer).

Estimate ranges, not points. Tasks run long more often than short, so a single number underbids. Estimate optimistic/likely/pessimistic hours and use a weighted “PERT” figure (opt + 4×likely + pess)/6 per task before multiplying by rate — it bakes realism in better than a flat buffer alone.

Try it: interactive demo

Live demo

Total hours, rate, buffer %.

Hours

Rate

Buffer %

Quote:

Variations

Single rate

One blended rate:

=SUM(task_hours) * rate * (1 + buffer)

PERT estimate

Weighted hours:

=(opt + 4*likely + pess) / 6

Add fixed costs

Pass-throughs:

=labor_quote + fixed_costs

Pitfalls & errors

Pad for surprises. A buffer of 10–20% covers the scope that always appears.

Match ranges. Hours and rates ranges must align for SUMPRODUCT.

Separate pass-throughs. Add stock, travel, and licenses on top of labor.

Practice workbook

📊

Download the free Project Quote from Estimated Hours practice workbook

A project-quote sheet with the single-rate, PERT, and fixed-cost variants, plus 4 challenges with answers. No sign-up required.

Frequently asked questions

How do I quote a project from estimated hours in Excel?

Use =SUMPRODUCT(task_hours, task_rates) * (1 + buffer). Sum each task's hours×rate and pad with a contingency buffer.

How big should the buffer be?

Usually 10–20% to cover scope surprises. For more rigor, estimate hours with PERT: (opt + 4×likely + pess)/6.

How do I handle pass-through costs?

Add them on top of the labor quote: =labor_quote + fixed_costs.

Stop fighting formulas. Learn them in a day.

This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.

See the Formulas & Functions Class

Function references: SUMPRODUCT