How to Quote a Consulting Project Without Spreadsheets
A repeatable way to scope, staff, and price a services engagement — so the number you send is the number you can defend, and the number that shows up on the invoice.
Most consulting quotes are built backwards. Someone asks “what’s our number for this?”, a partner squints at last year’s similar deal, adds a buffer, and a proposal gets written to justify a figure that was essentially guessed. It works until it doesn’t — until the project runs long, the margin evaporates, and nobody can reconstruct how the price was set.
There’s a more reliable way, and it doesn’t require a finance degree. It requires building the quote from the work up, in a consistent order, every time. Here’s the framework.
Step 1: Break the work into phases
Before any numbers, structure the engagement into phases — the natural chunks of work with a beginning and an end. For most projects that’s some version of:
- Discovery — requirements, access, current-state analysis.
- Build / Implementation — the core delivery.
- Training & Launch — handoff, enablement, go-live.
Phases do three things at once: they give the client a mental model of how the project unfolds, they let you price and stage payments by milestone, and they make the eventual statement of work write itself. Quote as one undifferentiated blob and you lose all three.
Step 2: Staff each phase with real roles and hours
This is where the spreadsheet method quietly fails. Instead of a lump-sum estimate, assign actual roles to each phase and estimate weekly hours. A simplified staffing grid for a 12-week project might look like this:
| Role | Bill rate | Hrs/wk | Weeks | Revenue |
|---|---|---|---|---|
| Solution Architect | $275 | 20 | 12 | $66,000 |
| Project Manager | $195 | 15 | 12 | $35,100 |
| Senior Developer | $185 | 40 | 8 | $59,200 |
The moment you staff this way, the quote stops being a guess. It’s a defensible build-up: roles × rates × hours × weeks. When the client pushes back on price, you don’t negotiate against a vibe — you point at the staffing plan and ask which role they’d like to cut.
Step 3: Know your margin before you send
Every role has two rates: what you bill the client and what the person costs you. The gap is your margin, and it’s the single number most services quotes ignore until it’s too late.
The math is simple: Gross Margin = Total Revenue − Total Cost, and Margin % = Gross Margin ÷ Total Revenue × 100. Set a target margin floor for your firm — say 35% — and check every quote against it before it goes out. A quote that looks like a healthy six-figure deal can hide a margin that doesn’t cover your overhead, and you won’t know unless cost rates are in the model from the start.
If you offer a discount, watch what it does to margin in real time. A 15% discount off the top can cut your margin by far more than 15 percentage points, because it comes entirely out of profit, not cost. Discounting without watching margin is how firms book “wins” that lose money.
Step 4: Decide T&M vs. fixed fee deliberately
Time-and-materials bills the client for actual hours worked — the client carries the risk of overrun. Fixed fee sets one price regardless of hours — you carry that risk, but you keep the upside if you deliver efficiently. The staffing plan you just built works as the basis for either: it’s the literal price in T&M, and your internal cost model (plus a contingency buffer) in fixed fee. We go deep on choosing between them in a separate guide.
Step 5: Make the quote consistent across every rep
The framework above only compounds if everyone follows it. When pricing logic lives in one partner’s head, every quote drifts a little — different rates, different discounts, different margins. The fix is to encode the rules: standard rate cards, discount limits, an approval step when a quote dips below the margin floor. Then a new hire quotes like your most experienced person, because the system carries the judgment.
Step 6: Send something better than a PDF
You’ve built a defensible, well-staffed, margin-checked quote. Don’t bury it in an email attachment that vanishes into the client’s inbox. The last mile matters: a quote the buyer can open, understand phase by phase, ask questions about, and approve — while you can see they’re engaging — closes faster than a PDF you email and then chase. (More on why in The Slow Death of the PDF Proposal.)
The point: quote from the work, not the gut
Spreadsheets aren’t the enemy — guessing is. Whether you use a spreadsheet, purpose-built software, or a napkin, the discipline is the same: structure the work into phases, staff it with real roles and hours, check margin before you send, and keep it consistent across your team. Do that and your quotes get faster, more defensible, and more profitable at the same time.