tests/expected/mid-matter-early-warning/report.md

# Matter M-1006 (M&A Due Diligence) — Mid-Matter Spend Check

**Audience:** Internal legal operations, inferred from the request for a working mid-matter check.
**Fixture status:** Synthetic test data only; no real client, matter, firm, timekeeper, or invoice data is included.

## Executive summary

M-1006 is tracking well ahead of its budget pace and heading for a significant overrun if nothing changes. Two months in — 50% of the expected 4-month timeline — the matter has already consumed **$51,540, or 86% of the entire $60,000 budget**. Spend also grew 24% month-over-month (largely driven by rising partner hours), so a simple straight-line projection already implies overrunning the budget by ~72%, and if the recent growth trend continues it could be closer to double the budget by the time the matter closes. This is worth flagging now, while there are still two months to intervene, rather than waiting for a post-mortem.

## Budget variance / pacing findings

**Finding: Spend-to-date is far outpacing the timeline, not just the dollars.**
- Billed to date (months 1–2): $22,960 + $28,580 = **$51,540**
- Budget: $60,000 over an expected 4 months
- Time elapsed: 2 of 4 months = **50%** of the timeline
- Budget consumed: $51,540 / $60,000 = **85.9%** of the total budget
- That gap — 86% of budget spent at only 50% of time elapsed — is the core red flag. On a matter tracking to budget, spend-to-date should be roughly in line with time elapsed (or at least not wildly ahead of it), not nearly double the proportional share.

**Finding: Every reasonable projection method points to a material overrun, not just a close call.**
- *Flat run-rate:* average $25,770/month x 4 months = **$103,080 projected total → ~72% over budget** ($43,080 overrun).
- *Current-month run-rate:* remaining 2 months at the month-2 rate ($28,580/month) = $51,540 + $57,160 = **$108,700 projected → ~81% over budget** ($48,700 overrun).
- *Trend-continuation:* spend grew ~24.5% month-over-month (month 1 → month 2). If that growth rate persists for months 3–4, projected total is roughly **$131,000 → ~119% over budget** (more than double).
- Even the most conservative of these methods (flat run-rate) puts the matter more than $40K over budget by the end of month 4. There is no projection path in this data that lands at or under $60,000.

Likely driver: this reads as scope/pace, not a billing error — spend in month 2 rose across every timekeeper role (see below), consistent with the diligence workload genuinely expanding rather than a one-off billing spike.

**Recommended action:** Flag this matter for a budget conversation now, at the two-month mark, rather than at closeout. Options to discuss with the client/stakeholder and outside counsel (or internal team): (1) formally re-baseline the budget to reflect the true scope, (2) tighten scope for the remaining two months (e.g., cap non-essential diligence workstreams), or (3) explicitly approve the overrun in advance so it isn't a surprise at final billing. Given the trajectory, the most useful next step is asking the staffed team directly why month-2 spend jumped ~24% before assuming the same rate holds for months 3–4.

## Staffing mix findings

Only one matter is present in this dataset, so there's no peer M&A matter to benchmark staffing ratios against — a true staffing-mix outlier call (e.g., "this matter uses two partners where peer matters use one") isn't supportable from this file alone.

That said, the within-matter trend is worth flagging as a likely contributor to the pacing problem:

| Role | Month 1 hours | Month 2 hours | Change | Month 1 $ | Month 2 $ |
|---|---|---|---|---|---|
| Partner ($1,000/hr) | 10 | 14 | +40% | $10,000 | $14,000 |
| Associate ($540/hr) | 20 | 22 | +10% | $10,800 | $11,880 |
| Paralegal ($270/hr) | 8 | 10 | +25% | $2,160 | $2,700 |

Partner hours grew the fastest of the three roles (+40%) and partner time is the most expensive hour on the matter, so partner leverage is rising as a share of total hours (26% of hours in month 1 → 30% in month 2). That mix shift is a meaningful part of why spend accelerated rather than held flat, and is worth asking about directly: is more partner-level review needed because the diligence findings are more complex than scoped, or could some of that work be pushed to the associate/paralegal level for the remaining two months?

**Recommendation:** Before month 3 starts, confirm with the partner staffed on this matter whether the increasing partner-hour share is warranted by complexity (in which case the budget should be re-baselined) or is discretionary (in which case it's an easy lever to pull to slow the burn rate without cutting scope).

## Allocation findings

No allocation finding to make here — the dataset contains a single matter and a single (unnamed) staffing team, so there's no cross-matter or cross-firm allocation pattern to evaluate. This section would apply if this matter were compared against other M&A matters or other teams/firms handling similar work; that comparison isn't possible with the data provided.

## AI leverage opportunities

**Not assessed from this fixture.** The file has matter, month, role, hour, rate, billed-amount, budget, and timing fields but no task/activity codes or narrative descriptions. The matter name and staffing trend alone do not identify work suitable for AI assistance.

## Bottom line

Yes, you should be worried, and it's better to raise it now than in month 4. At the halfway point of the timeline, 86% of the budget is already spent, spend is trending up rather than flat, and every projection method — even the most conservative — puts the matter 70%+ over budget by completion. The recommended next step is a direct scope/budget conversation this week, informed by the specific question of why partner hours and total spend jumped from month 1 to month 2.

---
*Note on scope: this dataset does not include a "prior period" or peer-matter comparison file, so all projections above are based solely on this matter's own two-month trend, per the two-months-of-actuals provided. No external systems or invented figures were used.*