Case 01Fractional CIO · Mid-market logistics · Anonymized

    From 14 spreadsheets to one decision surface.—

    A mid-market freight operator running $380M in annual revenue across 23 terminals, 1,400 drivers, and a margin stack held together by tribal knowledge, email threads, and a finance team that spent more time reconciling than deciding.

    Client
    Regional freight operator, 23 terminals
    Role
    Fractional CIO
    Duration
    90 days, idea to production
    Team
    1 architect + 2 analysts + 1 PM
    Year
    2025
    90d
    Idea to production
    141
    Systems consolidated
    3.1×
    Quote turnaround
    $1.8M
    Margin recovered yr 1
    01 / Context

    The quarter closed before the question did.

    The company had grown 4× in six years through acquisition. Every terminal brought its own spreadsheet, its own margin definition, and its own idea of what “on-time” meant. By the time I arrived, the CFO’s team was spending 11 hours per quote reconciling data across 14 sources before they could even begin pricing.

    The CEO asked a simple question every Monday: “What is our gross margin this week?” Three people gave three different answers. The quarter closed before anyone agreed on the number.

    Before — Q1 2025
    After — Q4 2025

    Quote turnaround

    11 hours average. Three analysts pulling from email, ERP exports, and a shared drive folder named “FINAL v3.”

    Quote turnaround

    3.5 hours. Single surface, pre-populated with live lane data and margin thresholds from the spine.

    Margin reconciliation

    9 business days from close to board-ready P&L. Manual journal entries for inter-terminal transfers.

    Margin reconciliation

    Half a day. Automated netting, one canonical gross-margin definition, exceptions surfaced by rule.

    Margin definitions

    Three competing definitions across finance, ops, and sales. Board presentations footnoted with caveats.

    Margin definitions

    One. Governed by a metric contract with ownership, refresh cadence, and exception routing.

    02 / Approach

    Ninety days, five moves.

    1

    Discovery & audit

    Map every data source, every handoff, every definition disagreement. Name the pain in dollars.

    Weeks 1–2
    2

    Metric contract

    One canonical definition of gross margin. Ownership, refresh cadence, and exception escalation path.

    Week 3
    3

    Platform spine

    A data integration layer that replaces the 14 spreadsheets with one governed pipeline.

    Weeks 4–8
    4

    Pricing surface

    A quote-builder that pulls live lane data, margin thresholds, and capacity signals into one screen.

    Weeks 7–10
    5

    Handover & governance

    Runbooks, alerting, and a quarterly review cadence that keeps definitions from drifting.

    Weeks 11–12
    W1
    W2
    W3
    W4
    W5
    W6
    W7
    W8
    W9
    W10
    W11
    W12
    Discovery
    Metric contract
    Platform spine
    Pricing surface
    Handover
    Metric contract signed
    Spine live
    Production
    Sources (14)
    ERP exports
    Shared drives
    Email attachments
    TMS feeds
    Manual journals
    Spine
    Integration layer
    Metric contract
    Governance rules
    Surfaces
    Quote builder
    Margin dashboard
    Alert engine
    Decisions
    Lane pricing
    Capacity allocation
    Board reporting
    03 / Results

    With the numbers attached.

    Quote turnaround
    11.0h
    3.5h
    Margin reconciliation
    9.0d
    0.5d
    Analyst time on plumbing
    60%
    12%
    Definitions of gross margin
    3
    1

    “We stopped arguing about whose number was right — and started arguing about what to do.”

    CFO, anonymized

    Figures are representative composites based on real engagements. Client identity anonymized per NDA. Specific metrics available upon request in a confidential context.

    Have a margin question with three answers?

    Let’s find the one that matters