← Back to home
AZEQUEL Operational Diagnostic · Redacted

Where the order-to-cash flow is bleeding.

A load report on Client A — a regional specialty-foods distributor. Not an opinion: every figure traces to an observed cycle time, error rate, or labor rate. Prepared as a 2-week embedded diagnostic.

PREPARED BY Azequel · Dave Exequiel Suico, Fractional COO ENGAGEMENT Systems Diagnostic & Roadmap STATUS Redacted · figures anonymized, internally consistent
§ 00

Subject

ClientClient A (name withheld)
VerticalRegional specialty-foods distribution — dry + refrigerated specialty goods to independent grocers, delis, and restaurants
Revenue~$6.0M / yr
Headcount34 — 8 office/admin, 18 warehouse + drivers, 8 sales/management
Footprint1 distribution center · 4 delivery routes
Order profile~60 orders/day × 250 business days ≈ 15,000 orders/yr, avg order value ~$400 → $6.0M
COGS~68% of revenue (~$4.08M)
Systems todayQuickBooks · 3 shared spreadsheets (orders, inventory, pricing) · email + SMS intake · printed pick sheets
Read this as a load report, not an opinion. Every number traces to an observed cycle time, an error rate, or a labor rate. Where a figure is an estimate, it is labeled and bounded. The purpose is to locate the load-bearing failures in the order-to-cash structure and price the cost of leaving them in place.

Baseline rates used throughout — admin/warehouse blended $22/hr (loaded); owner/principal opportunity cost $75/hr. Every waste figure = these constants × an observed volume.

§ 01

Value-Stream Map — Order-to-Cash

The core flow is lead-to-cash: an order arrives, gets entered, cleared, picked, delivered, invoiced, collected. Value-add touch time for a clean order is ≈ 22 minutes. Elapsed time to delivery ≈ 1.5 days; to cash, ≈ 48 days. Decision latency (non-value-add waiting for a human decision) is called out at every handoff.

                 ORDER-TO-CASH VALUE STREAM  (Client A)
                 VA touch ≈ 22 min | order→cash ≈ 48 days

[1] ORDER INTAKE           phone / email / SMS, no single inbox
      |  ▸ latency: 0–3 hr  (orders sit until batched 2–4×/day)
      v
[2] ORDER ENTRY            re-keyed by hand into spreadsheet, then QuickBooks
      |  ▸ latency: 0 hr, but +3 min rework/order (double entry)
      v
[3] CREDIT / HOLD          ★ FOUNDER BOTTLENECK — owner clears every hold
      |  ▸ latency: 40 min avg, up to 4 hr when owner is on the road
      v
[4] PICK-LIST RELEASE      printed in batches 2×/day
      |  ▸ latency: 0–4 hr  (waits for next print batch)
      v
[5] WAREHOUSE PICK/PACK    paper pick sheet, no scan confirmation
      |  ▸ latency: ~0 hr | 4% of orders leave with a pick error
      v
[6] DISPATCH / ROUTE       manual route assignment by dispatch lead
      |  ▸ latency: batched to route cutoff, 0–2 hr
      v
[7] DELIVERY + POD         paper proof-of-delivery, returned next day
      |  ▸ latency: POD re-enters office +1 day
      v
[8] INVOICING             invoice cut only after POD returns
      |  ▸ latency: 1–2 day lag between delivery and invoice
      v
[9] AR / CASH APPLICATION  manual matching of deposits to invoices
         ▸ latency: DSO ≈ 48 days vs 30-day terms → 18-day slip

Latency summary

HandoffNon-value-add waitRoot cause
Intake → Entry0–3 hrNo single order inbox; batch processing
Entry → Credit+3 min rework/orderDouble keying (spreadsheet and QB)
Credit → Release40 min – 4 hrEvery hold routes to the owner
Release → Pick0–4 hrTwice-daily print batch
Delivery → Invoice1–2 daysInvoice waits on paper POD
Invoice → Cash+18 days vs termsManual cash application, no dunning
Structural finding. The two longest latencies — the credit-hold loop (Step 3) and the invoice-after-POD lag (Step 8) — are decision problems, not labor problems. Cheap to fix, expensive to keep. The 18-day DSO slip alone ties up ~$296K of working capital that should be liquid ($6.0M ÷ 365 × 18).
§ 02

Operational Waste Inventory

Each waste is a specific, observed leak with an annualized cost. Costs are gross (full annual bleed); §05 shows the conservative Year-1 capturable subset. Nothing is double-counted.

#Waste (type)BasisAnnualized
W1Duplicate order entry — rework15,000 orders × 3 min re-key × $22/hr$16,500
W2Order-entry error rework — rework4% × 15,000 = 600 orders × $18 fix$10,800
W3Pick/pack errors → credits & redelivery — rework600 mis-picks × $20 net$12,000
W4Manual AR reconciliation & cash application6 hr/wk × 50 wk × $24/hr$7,200
W5Refrigerated shrink — poor inventory visibilityReducible spoilage on perishable SKUs$14,000
W6Pricing / margin leakage — tribal knowledgeSpecial terms in one head; ~0.3% of revenue$18,000
W7Owner rebuilds sales/margin report weekly4 hr/wk × 50 wk × $75/hr$15,000
W8Credit-hold approval waiting — founder bottleneck30/day × 2 min × 250 days × $75/hr$18,750
Gross identified waste~$112,250/yr

Types — rework (W1–W3) · manual reconciliation (W4) · waiting/spoilage (W5) · tribal knowledge (W6) · manual reporting (W7) · founder bottleneck (W8). Textbook operations-heavy SME: not a sales problem, a flow problem.

§ 03

Decision-Routing / Decision-Rights Map

One structural defect shows up everywhere: decisions route up, not down. The owner is a single point of failure on three loops that should never reach them.

DecisionDecides todayShould decideDelegation
Release order under credit limitOwnerEntry clerk (auto-rule)Auto-clear if within limit & current; only exceptions route up
Price / discount on standard SKUOwner or 1 senior mgrSystem price listCentralize pricing into one governed table; kill verbal quotes
Restock / reorder pointOwner (by feel)Warehouse lead (pars)Set min/max pars per SKU; system flags reorder
Route / delivery exceptionDispatch lead ✓Dispatch leadAlready correct — leave it
Customer credit-limit changeOwner ✓OwnerCorrect — keep at owner, but log it

Founder-bottleneck loops — the three to cut

Principle applied. Push each decision to the lowest responsible level that has the information to make it. The owner should hold limit changes and true exceptions — nothing a rule or a par level can decide.
§ 04

Process Heatmap

Eight core processes rated on maturity (ad-hoc → optimized) and operational risk (impact × likelihood of a costly failure).

Maturity — ○ Ad-hoc · ◐ Repeatable-but-manual · ● Defined/optimized  |  Risk — Low / Med / High

ProcessMaturityRiskNote
Order intakeHighThree channels, no single inbox — orders get lost
Order entryHighDouble-keyed, 4% error rate
Credit / hold decisionMedConsistent, but owner-gated on every order
Inventory managementHighNo perpetual count; monthly manual; drives shrink
Pick / packMedPaper works, but no scan verification
Dispatch / routingLowThe one mature process — dispatch lead owns it well
InvoicingMedAccurate but slow; waits on paper POD
AR / collectionsHighNo dunning cadence; 18-day DSO slip
Reading the map. Five of eight processes are ad-hoc (○) and four carry High risk. The single mature process (dispatch) proves the team can run a defined process — the gap is systems and decision rules, not capability. Risk clusters on the front (intake/entry) and back (inventory/AR) of the flow.
§ 05

Immediate Savings Opportunity

~$58K / yr
Recoverable in Year 1, conservatively — the capturable subset of the $112,250 gross waste in §02, haircut to what is realistically recoverable in twelve months with staged, low-risk builds. Deliberately less than gross so it survives scrutiny; the remaining ~$54K is Year-2 upside.
SourceFixGross/yrCaptureRecovered
W1 Duplicate entrySingle intake → auto-populates order + invoice$16,50090%$14,900
W7 Owner reportingAutomated sales/margin dashboard$15,00080%$12,000
W6 Pricing leakageGoverned central price list$18,00045%$8,100
W2 Entry-error reworkValidation at point of intake$10,80060%$6,500
W3 Pick-error creditsBarcode/scan pick confirmation$12,00050%$6,000
W5 Refrigerated shrinkPerpetual inventory + reorder pars$14,00040%$5,600
W4 AR reconciliationAuto cash-application + dunning cadence$7,20070%$5,000
Year-1 recovered≈ $58,100

Why this number is defensible, not hand-waved

Engagement math. At a $1.5K–3K diagnostic + a staged build retainer, the recovered $58K/yr clears the first year of fees with margin to spare — before the working-capital unlock.
§ 06

Proposed First-30-Days Plan

This diagnostic is Week 0. The following is the 30-day validation-and-blueprint sprint that converts findings into a staged, priced build roadmap — cheap validation before any system is built.

Week 1

Instrument & audit the databases

  • Audit the 3 shared spreadsheets + QuickBooks chart of accounts for structure, duplication, integrity.
  • Pull 90 days of order history to confirm the 4% error rate, 60/day volume, $400 AOV against live data.
  • Reconcile a 30-day inventory sample vs physical count to confirm shrink (W5).
  • Pull AR aging to confirm the 48-day DSO and quantify the working-capital slip.
Week 2

Interview stakeholders

  • Owner — which holds/prices/reports truly need them (validate §03).
  • Order-entry clerks (2) — where re-keying and errors happen (W1, W2).
  • Warehouse lead — pick errors, reorder-by-feel, shrink (W3, W5).
  • Bookkeeper — cash application, dunning, month-end close (W4).
  • 1 senior sales mgr — where tribal pricing lives (W6).
Week 3

Map to-be flow & size the builds

  • Redraw the value stream to-be: single intake, auto-clear credit rule, perpetual inventory, invoice-on-delivery.
  • Draft the auto-clear credit rule and governed price-list schema — highest ROI, lowest risk.
  • Size each build (effort, sequence, dependency) with §05 ROI attached.
Week 4

Deliver diagnostic summary + roadmap

  • Deliverable: prioritized systems roadmap — which system first, in what order, with §05 dollar recovery per phase, staged with acceptance criteria.
  • Recommended Phase 1: single intake + auto-clear credit rule (hits W1, W8 and the largest latency at once).
  • Diagnostic fee credits against the first build if the client proceeds.
§ 07

Assumptions to Sanity-Check

  1. 60 orders/day × 250 days × $400 AOV = $6.0M — volume, day-count and AOV are back-solved to be mutually consistent with revenue. Confirm the real day-count (some distributors run 260–300).
  2. 4% error rate and $18 cost-to-fix — plausible for manual double entry; validate against 90 days of credit memos in Week 1.
  3. Refrigerated shrink (W5) is the softest figure — "reducible" spoilage bounded to $14K but depends on SKU perishability mix; validate against a physical count.
  4. Owner opportunity cost at $75/hr drives W7 and W8 — if the owner's marginal hour is worth more, those figures are conservative.
  5. Capture rates in §05 (40–90%) are judgment calls, deliberately haircut. The $58K headline holds even if two lines come in 10 points low.
  6. Working-capital unlock (~$296K) is a one-time liquidity event, not a recurring saving — kept out of the $58K headline on purpose.