A fictional composite regional freight brokerage, built to show exactly what the Professional deep-dive deliverable contains — findability, financial silo analysis, position mapping, and a complete, sequenced transformation roadmap. Not a real company. Not a valuation.
This is the deliverable a Professional-tier client receives after the free scan: not "here's what's wrong," but a sequenced, owned, dated plan for what changes and in what order. The analysis below is built the way a Wharton-trained operating consultant would build it — grounded in the P&L, honest about trade-offs, and silent on any number this product is not licensed to give.
Add-back methodology mirrors a standard SDE/EBITDA schedule: owner compensation normalized to market rate, one-time legal costs added back, related-party rent adjusted to fair market. This section shows the structure of the analysis — it never converts into a valuation, multiple, or worth estimate. Every dollar of margin lift below traces back to the four people-moves above, not to a smaller headcount.
| Line item | Annual | % of revenue |
|---|---|---|
| Revenue | $14,200,000 | 100.0% |
| Carrier & freight cost (COGS) | $9,940,000 | 70.0% |
| Gross profit | $4,260,000 | 30.0% |
| Payroll & benefits (ops + admin) | $1,890,000 | 13.3% |
| ↳ of which: 4 AI-collapsible admin roles | $416,000 | 2.9% |
| Facilities & equipment | $285,000 | 2.0% |
| Software & tech stack (pre-transformation) | $96,000 | 0.7% |
| Other SG&A | $224,000 | 1.6% |
| Add-backs (owner comp normalization, one-time legal, related-party rent) | +$196,000 | 1.4% |
| Adjusted EBITDA | $1,861,000 | 13.1% |
This report states EBITDA. It never states what Ashford Bay Logistics is worth — that is a licensed broker's opinion of value, built from a full P&L and general ledger review, and is offered as a separate, human-led engagement.
This is the centerpiece of the Deep Dive, not a footnote — four real moves, named, with the job description rewritten for the person whose role changes most. (Illustrative names — Ashford Bay is a fictional composite.)
Before: 18 hrs/week manually matching carrier invoices to rate confirmations.
After: relocated to Carrier Relationship Specialist. Job description rewritten (see below).
Before: 22 hrs/week manual load-matching and carrier confirmations.
After: relocated to Key-Account Coordinator, owning the top 20 shipper relationships.
Before: 15 hrs/week chasing carrier insurance and safety documentation.
After: relocated to Carrier Onboarding & Safety Trainer, building the program instead of chasing paperwork.
Before: 20 hrs/week on routine phone/email scheduling.
After: relocated to Customer Success Lead, the first call when a shipper has a problem.
Purpose: Own the day-to-day relationship with Ashford Bay's top 30 carrier partners — the human on the other end of every rate negotiation, service issue, and capacity crunch, freed from manual invoice-matching to do it.
Day-to-day:
1. Weekly check-ins with top-tier carriers on capacity, rates, and service issues.
2. Review AI-flagged invoice variances (the system now matches the routine 80% automatically) and resolve the exceptions personally.
3. Lead quarterly rate renegotiations using AI-prepared cost/performance briefs.
4. First point of contact when a carrier relationship needs a human — capacity emergencies, disputes, new-carrier onboarding.
How AI supports this role: the reconciliation engine handles routine invoice matching; Maria reviews exceptions and owns every relationship decision the system can't make.
Why this is a growth role: Maria already knew every carrier's quirks from three years of reconciliation work — that knowledge is worth far more in a relationship seat than in data entry. This role directly protects freight cost (70% of revenue) instead of just auditing it after the fact.
Nobody is marked "eliminated." Every AI-exposed role maps to a relocation, not a layoff — the freed capacity funds the move, not a severance line.
| Role | Headcount | AI exposure | Recommended action |
|---|---|---|---|
| Dispatch coordinators | 6 | High | RELOCATE → key-account coordination |
| Invoice reconciliation clerks | 3 | High | RELOCATE → carrier relationship desk |
| Compliance paperwork clerks | 2 | High | RELOCATE → onboarding & safety training |
| Inbound scheduling reps | 3 | Medium-high | RELOCATE → customer success |
| Account managers | 8 | Low | RETAIN — augment with AI research briefs |
| Drivers & owner-operators (contracted) | 19 | Very low | RETAIN — unaffected |
| Operations leadership | 3 | Low | AUGMENT — AI dashboard for daily exception review |
| Finance & admin leadership | 2 | Medium | AUGMENT — AI-drafted monthly close, human sign-off |
Presented the way a sales engineer would walk a operator through it — category by category, plain about what each tool replaces and what it costs to run.
Reads inbound load tenders, matches to available capacity, drafts the carrier confirmation. A human approves exceptions only.
OCR + matching engine reconciles carrier invoices against rate confirmations automatically, flags variances over threshold for a human.
Tracks carrier insurance, authority, and safety documentation expirations; auto-requests renewals; escalates only true gaps.
Handles routine inbound scheduling and status questions by phone/chat, hands off anything relationship- sensitive to a (now relocated) human.
Daily one-page brief per key account: shipment trends, at-risk signals, upsell openings — the account manager still makes every call.
Drafts the monthly financial package from the books; the controller reviews and signs. Human accountability stays exactly where it is.
Confirm the P&L silo map with ownership and the 4 affected employees. No system goes live until the relocation plan for each person is named and agreed.
Stand up load-matching and invoice-reconciliation automation in parallel with the existing manual process; run both for 6 weeks before cutover.
Move the 4 identified employees into customer success and carrier-relationship roles, with a 3-week paid training ramp. Freed payroll capacity funds the raises for the new roles.
Deploy the AI scheduling assistant and account-manager research briefs; measure retention and upsell lift against the freed capacity.
Run your own free scan first — it takes about a minute and costs nothing.