Sample report
Margin & Delivery Diagnostic — sample report
SAMPLE — Riverbend Creative is a fictional agency. All figures are illustrative and invented. This is not a client engagement, not a client result, and no client data appears in this document.
- Prepared for
- Dana Okonjo, Founder
- Period reviewed
- January 6 – June 30, 2026
Data received
- Harvest export, Jan 6–Jun 30 · 10 project invoices · 2 interviews
Blended rate used
- $150 / hour, supplied by the agency
Prepared by
- Sanam (Sunny) Anwarali, PMP
- Delivered
Day 10 of 10
Over six months, Riverbend tracked 12,510 billable hours and invoiced 10,474. The gap is 2,036 hours, or $305,400 at your blended rate — $610,800 a year if nothing changes. Most of it sits in two places: the handoff from project management to billing, and scope added without a change order. The five fixes in section 4 recover $91,600 a year — about 15% of the gap. The rest is either priced-in, or costs more to chase than it returns, and section 4 says which is which.
Section 1
Utilization and realization, by role
Utilization is billable hours worked ÷ hours available. Realization is hours invoiced ÷ billable hours worked. A person can be fully utilized and still lose the agency money. Realization is where that shows.
Designers (6)
- $121,500
Project managers (4)
- $71,850
Developers (4)
- $43,200
Account leads (3)
- $42,600
Strategy (2)
- $26,250
- 0 hrs
- 2,025
- 4,050 hrs Hours invoiced Hours worked but never invoiced
Figure at right: value of the gap over six months, at $150.
- Role
- Available
- Billable worked
- Utilization
- Invoiced
- Realization
- Value of gap
Account leads (3)
- 2,700
- 1,890
- 70.0%
- 1,606
- 85.0%
- $42,600
Project managers (4)
- 3,600
- 2,520
- 70.0%
- 2,041
- 81.0%
- $71,850
Designers (6)
- 5,400
- 4,050
- 75.0%
- 3,240
- 80.0%
- $121,500
Developers (4)
- 3,600
- 2,880
- 80.0%
- 2,592
- 90.0%
- $43,200
Strategy (2)
- 1,800
- 1,170
- 65.0%
- 995
- 85.0%
- $26,250
- Total / weighted
- 17,100
- 12,510
- 73.2%
- 10,474
- 83.7%
- $305,400
Annualized: $610,800. Assumption stated out loud — available hours are 900 per person for six months, which is 1,800 a year: 2,080 minus roughly six weeks of holiday and sick leave. Same role mix and same rate carried forward. A number you cannot check is a number you will not act on.
What the table shows
Designers carry the largest gap in dollars, but not because they are idle — their utilization is the second highest in the agency at 75%. They lose 20% of what they work at the invoice. Project managers are the opposite problem: the lowest realization at 81% and the lowest utilization tied with account leads. Developers are the healthiest team you have at 90% realization, and nothing in section 4 asks you to change how they work.
Section 2
The last ten projects, priced honestly
Every row compares what was quoted against what was tracked and what was actually invoiced. Written-off dollars are tracked hours minus invoiced hours, at $150.
- #
- Project
- Quoted
- Hrs tracked
- Hrs invoiced
- Written off%
- Main cause
1
- Brand refresh — Halden
- $68,000
- 512
- 442
- $10,500
- 13.7%
- Scope added, no change order
2
- Website rebuild — Corvo
- $94,000
- 720
- 604
- $17,400
- 16.1%
- Scope added, no change order
3
- Campaign launch — Aster
- $41,000
- 296
- 262
- $5,100
- 11.5%
- Rework after client feedback
4
- Packaging system — Vell
- $37,500
- 268
- 238
- $4,500
- 11.2%
- Estimate below actual
5
- Retainer Q1 — Northwind
- $60,000
- 400
- 356
- $6,600
- 11.0%
- Hours logged after invoicing
6
- Microsite — Halden
- $28,000
- 214
- 176
- $5,700
- 17.8%
- Scope added, no change order
7
- Video series — Aster
- $52,000
- 372
- 318
- $8,100
- 14.5%
- Rework after client feedback
8
- Retainer Q2 — Northwind
- $60,000
- 404
- 368
- $5,400
- 8.9%
- Hours logged after invoicing
9
- Ecommerce migration — Corvo
- $31,500
- 246
- 202
- $6,600
- 17.9%
- Estimate below actual
10
- Event identity — Vell
- $15,000
- 118
96
- $3,300
- 18.6%
- Discount / goodwill
- Total
- $487,000
- 3,550
- 3,062
- $73,200
- 13.7%
- Causes, grouped
- Cause
- Projects
- Dollars
Share
- Scope added without a change order
3
- $33,600
- 45.9%
- Rework after client feedback
2
- $13,200
- 18.0%
- Hours logged after the invoice went out
2
- $12,000
- 16.4%
- Estimate below actual from the start
2
- $11,100
- 15.2%
- Discount or goodwill write-off
1
- $3,300
- 4.5%
- Total
10
- $73,200
- 100%
- The same ten projects, ranked by client
This is usually the table founders ask to see twice. Effective rate is what you actually earned per hour your team put in — quoted value ÷ hours tracked — against your $150 blended rate.
- Client
- Jobs
- Quoted
- Hrs tracked
- Written off
- Realization
- Effective rate
- Corvo
2
- $125,500
- 966
- $24,000
- 83.4%
- $130
- Northwind
2
- $120,000
- 804
- $12,000
- 90.0%
- $149
- Halden
2
- $96,000
- 726
- $16,200
- 85.1%
- $132
- Aster
2
- $93,000
- 668
- $13,200
- 86.8%
- $139
- Vell
2
- $52,500
- 386
- $7,800
- 86.5%
- $136
- Total
10
- $487,000
- 3,550
- $73,200
- 86.3%
- $137
What the tables show
Corvo is your largest client and your least profitable one. They are the biggest line by quoted value at $125,500, and they return $130 an hour against your $150 rate — the lowest of the five. Northwind is quoted 4% lower and returns $149. Over these ten jobs, that difference is worth $18,400.
Scope added without a change order is the single largest cause of write-offs at $33,600, and it is not spread evenly — two of the three projects are Halden, the third is Corvo. This is not an agency-wide discipline problem. It is two relationships where nobody writes the change down.
A note on scope, so the numbers are not read as contradicting each other: section 1 covers all billable work over six months. This section covers ten projects. The $73,200 written off here is a subset of the $305,400 gap above, not a second figure.
Section 3
Where hours disappear between teams
Five handoffs, what is supposed to happen at each, and what the export and the interviews say actually happens. Dollars are the share of the six-month gap attributable to that handoff.
- Handoff
- Supposed to happen
- What actually happens
- Cost
- Evidence
PM → Billing
Invoice is raised from the tracked hours for that period.
The invoice goes out on a date, not on the hours. Entries logged after the 25th land in a period nobody re-bills.
- $96,300
- Export + invoices
Sales → PM
Everything agreed in the pitch is written into the brief.
Two or three commitments are made verbally in the pitch and reach the PM as an assumption rather than a line.
- $71,400
- Interview, both
PM → Production
A revision round opens after the previous round is signed off.
Round three starts while round two is still open, so the hours belong to a round that was already invoiced.
- $48,900
- Export
Production → PM
Internal review is logged to internal.
Internal review is logged to the client job, then written off at invoicing because it cannot be defended.
- $34,200
- Export
Billing → Client
A disputed line is re-issued with the evidence.
A disputed line is removed. Re-issuing takes a conversation nobody has time for.
- $22,800
Invoices
- Attributable to a named handoff
- $273,600
The remaining $31,800 of the six-month gap could not be attributed to a single handoff from the data supplied. It is listed here rather than distributed across the rows above, because spreading it would make the table look tidier and the report less true.
- Section 4
The 90-day fix list
Five changes, ranked by annual dollar impact against effort. None of them needs new software. Each recovery figure names the assumption underneath it.
1
A written change order at 10% scope
Any request that adds more than 10% to a quoted scope gets one paragraph in writing and a number, before work starts. Not a contract — an email the client replies "yes" to.
Owner: Founder · Effort: small · Assumes you recover half of the annualized scope-creep write-off of $67,200.
- $33,600a year
2
A pre-invoice check on the PM → Billing handoff
Before an invoice is raised, one person compares the tracked hours for that job against the lines going out, and flags anything logged in the last five days.
Owner: Ops or Finance · Effort: small · Assumes 15% of the annualized $192,600 lost at this handoff is recoverable in year one.
- $28,900a year
3
Timesheets lock Friday at 5pm
Hours are entered by Friday or they go to the next period with a note. Removes the after-the-invoice entries that currently vanish.
Owner: Each team lead · Effort: small · Assumes three-quarters of the annualized $24,000 in late entries is captured.
- $18,000a year
4
Quarterly estimate calibration from actuals
Once a quarter, compare quoted hours against tracked hours by project type, and adjust the estimating baseline. Two projects in ten were underpriced from the first day.
Owner: Founder + PM lead · Effort: medium · Assumes half of the annualized $22,200 underpricing is corrected at the next quote.
- $11,100a year
5
Monthly realization review, by role
Thirty minutes a month, the same table as section 1. This one recovers nothing on its own — it is the measurement that keeps the first four honest, and the reason you will know at day 90 whether any of this worked.
- Owner: Founder · Effort: small · No direct recovery claimed.—enabler
Sequence
Days 1–30: fixes 1 and 3. Both are rules, not projects, and both stop new losses immediately.
Days 31–60: fix 2, once one month of clean timesheets exists to check against.
Days 61–90: fix 4 at the quarter boundary, and the first monthly review under fix 5.
What I would not do
Do not hire a second project manager. The PM team's problem is realization at 81%, not capacity — they are the least utilized group in the agency alongside account leads, and adding a person makes that number worse. Do not change your rate either. At $150 blended you are inside the range for your market and your size; the money is not in the rate, it is in the hours you already worked and never billed.
How you will know it worked
Re-measure realization by role at day 90, using the same two definitions from section 1. Today the weighted figure is 83.7%. If the first four fixes hold, the target is 88%. If it has not moved by two points, the rules are being written down and not followed, and that is a different conversation.
- Section 5
The call
Held June 30, 2026, 60 minutes, with Dana Okonjo (Founder) and Marcus Hale (Delivery Lead).
- #
- Agreed action
- Owner
- By when
1
- Write and circulate the 10% change-order rule
- Dana
- 7 July
2
- Announce the Friday 5pm timesheet lock at Monday standup
- Marcus
- 6 July
3
- Rebuild the Halden and Corvo scopes with the new rule applied
- Marcus
- July 21
4
- Book the day-90 re-measure
- Dana
- 30 September
- Questions the data could not answer
The Harvest export does not carry a change-order field, so section 2's scope-creep figures come from the interviews and the invoice line items, not from the time data. Two of the ten projects had no separate internal-time code, so the split in the Production → PM row for those jobs is an estimate. Both are stated here rather than smoothed into the tables above.
Scope
What this report is, and where it stops
Findings come from the data listed at the top of this report and from two interviews. Where a figure is an estimate, the assumption is stated beside it.
This report does not include implementing the fixes, software setup, hiring, bookkeeping, or legal and HR advice.
If you want the fixes shipped as well, that is a separate decision after this call, quoted from the fix list above.
Nothing in this document is presented as a result achieved for another client.
- Sanam (Sunny) Anwarali, PMP · Sunnyworks.AI · Chicago, Illinois hello@sunnyworks.ai · sunnyworks.ai · linkedin.com/in/sanamanwarali
Riverbend Creative, its people, its clients and every number in this document are invented for the purpose of showing the format of a Margin & Delivery Diagnostic. No part of it describes real work for a real client.