← SIMRANJAISWAL.INCASE · STUCK MONEY · 05 · PRICING

The discount nobody approved

A B2B medical-equipment procurement platform, quoting hospitals by hand and losing money before the invoice existed. The Leak Ledger, run on pricing: a pocket-price waterfall, a corridor per category, and quote-to-order conversion up 27%.

PRICE LEVELLEAKRECOVERED
THE POCKET-PRICE WATERFALL · LIST PRICE = 100 · WHERE THE MONEY LEFT BETWEEN THE PRICE LIST AND THE BANK · ILLUSTRATIVE, AVERAGE DEAL · CLICK "AFTER".
0QUOTE-TO-ORDER CONVERSION · REPORTED
0WIDEST-TO-NARROWEST POCKET PRICE, SAME PRODUCT · ILLUSTRATIVE
0OPERATING-PROFIT LIFT FROM A 1% PRICE GAIN · McKINSEY
0VOLUME NEEDED TO OFFSET A 5% PRICE CUT · McKINSEY
01 · THE BUSINESS QUESTION

Every quote was priced by a human, negotiated by another, and closed by a third. Nobody could say what a product actually sold for.

The platform sells medical equipment — diagnostic imaging, patient monitoring, surgical instruments, consumables, refurbished devices — to small and mid-size hospitals that buy on quotation. A hospital asks; a category team sources and costs it from vendors; a pricing team sets a quote; sales negotiates; finance invoices. Four hands, four judgements, and no line in any system that said this is the price we meant to charge. The founders' question came from the board: are we losing deals on price, or winning them at any price? The honest answer was: both, and nobody could tell which was which.

02 · THE DATA

Three systems again. The quotation workflow — every request stamped as it moved Quotation Requested → Assigned to Pricing → Assigned to Category → Quotation Generated, or died as Cannot Procure — with a turnaround clock on each hand-off. The CRM, where sales logged the negotiation and, when a quote was lost, a Not Accepted Reason — free text, including "price". And the accounting ledger, where vendor bills carried cost and invoices carried the selling price, so margin could be computed per line for the first time.

-- margin per invoice line: what we paid the vendor against what the hospital paid us (real shape)
SELECT i.date                 AS bill_date,
       i.payment_terms_label,
       li.sku, li.product_category,
       li.quantity * v.bcy_rate  AS cost_price,          -- vendor bill, base currency
       li.quantity * li.rate     AS selling_price
FROM zoho.invoices i
JOIN zoho.invoices_line_items li ON li.invoice_id = i.invoice_id
LEFT JOIN zoho.bills_line_items v ON v.sku = li.sku AND v.bill_date <= i.date;

# then, in pandas — the number nobody had seen per line before
df["margin"] = (df.selling_price - df.cost_price) / df.selling_price
df = df.replace([np.inf, -np.inf], np.nan)              # a ₹0 selling price is a data bug, not a 100% discount
03 ·TRACEWHERE THE PRICE CHANGED HANDS

List price is a story you tell yourself. Pocket price is what reaches the bank. The gap between them had five steps, and only one was a decision.

The waterfall at the top of this page is the TRACE. It follows one average deal from the price list to the money that actually landed, and names every step where value fell away: the category discount (published, deliberate), the negotiated discount (sales, unrecorded, the largest leak), freight and installation absorbed to "get the deal done", and the cost of extended payment terms — 60 and 90 days granted as a closing gesture, which is a discount wearing a calendar. The framework is McKinsey's pocket-price waterfall; the finding was local: only the first step had an owner.

04 ·AGECOHORTS: WHO GOT THE DISCOUNT, AND DID IT BUY ANYTHING

Small hospitals were getting the deepest discounts. Large ones were paying closer to list. And the deepest discounts did not win more often.

WONLOST
180 QUOTES, ILLUSTRATIVE · X = DEAL SIZE · Y = POCKET PRICE AS % OF LIST · THE BAND IS THE PROBLEM: THE SAME PRODUCT LEFT AT 46% AND AT 97% OF LIST, AND THE WINS ARE NOT WHERE THE DISCOUNTS ARE.

Cohorting every quote by pocket price and outcome produced the chart above, and the two findings that changed the conversation. First, the pocket-price band was 3.1× wide for identical products: some hospitals paid under half of list, some nearly all of it, and deal size explained almost none of it — long relationships and whichever rep picked up the phone explained most. Second, and this is the one that matters, discounting deeper did not lift the win rate. Past a point, quotes were lost anyway, for reasons the CRM had been recording all along: delivery time, a missing demo, a competitor's brand. The discount was buying nothing.

05 ·RANKTHE LEAKS, BY WHAT THEY WERE WORTH TO SEAL
LEAKSHARE OF POCKET GAPEFFORT TO SEALVERDICT
Negotiated discounts with no approval trail≈ 45%Low — a corridor and an approval ruleSeal first. The largest leak had no owner; giving it one recovered most of it.
Category cost moved, list price didn't≈ 20%Low — recompute list from vendor bills monthlySeal with the corridor. Some products were being quoted below current cost.
Freight and installation absorbed≈ 15%Medium — price them, then discount them visiblySeal second. Make the gift a line item so it is a decision.
Quotes lost above the corridor— (lost revenue)Low — a ceiling flagThe mirror leak: over-pricing on categories where the market was tight.
Slow quotes— (lost revenue)Medium — turnaround targets per hand-offQuotes that took more than two days lost far more often, at any price.
06 ·SEALTHE CORRIDOR · TRY IT

Not a price list — a corridor per category: a floor that protects margin, a target that wins, a ceiling that flags. Pick a quote.

FLOOR · % OF LIST · BELOW THIS NEEDS A FOUNDER'S APPROVAL
TARGET · WHERE THIS CATEGORY WINS
CEILING · ABOVE THIS THE QUOTE IS FLAGGED FOR REVIEW
ILLUSTRATIVE CORRIDORS — THE REAL ONES WERE FITTED FROM EIGHTEEN MONTHS OF WON AND LOST QUOTES PER CATEGORY AND REFRESHED MONTHLY FROM VENDOR COST. THE STRUCTURE IS THE POINT: THREE NUMBERS PER CATEGORY, DERIVED FROM DATA, WITH A RULE ATTACHED TO EACH.
WIN RATE BY PRICE BAND
SHARE OF QUOTES WON, BY POCKET PRICE AS % OF LIST · ILLUSTRATIVE · THE FALL IS GENTLE UNTIL 90% — THE CORRIDOR SITS WHERE IT STARTS.
POCKET MARGIN BY PRICE BAND
POCKET MARGIN AT EACH BAND · ILLUSTRATIVE · BELOW 60% OF LIST THE PLATFORM WAS PAYING TO MAKE THE SALE.
# the corridor, fitted per category from won and lost quotes (simplified)
bands = quotes.assign(band=pd.cut(quotes.pocket_pct, bins=range(40, 105, 5)))
curve = bands.groupby(["category", "band"]).agg(win_rate=("won", "mean"), n=("won", "size"), margin=("pocket_margin", "median"))

def corridor(cat):
    c = curve.loc[cat]
    floor  = c[c.margin >= MIN_MARGIN[cat]].index.min().left          # protects margin
    target = c[c.n >= 12].win_rate.idxmax().left                       # where it actually wins
    ceil   = c[c.win_rate >= 0.25].index.max().right                   # beyond this, quotes die
    return floor, target, ceil

# the rule in the quote tool: below floor → approval; above ceiling → review; outside either → logged, always
07 ·WATCHNINE MONTHS OF THE THREE NUMBERS THAT MATTER
QUOTE-TO-ORDER CONVERSIONPOCKET PRICE INDEX (M0 = 100)QUOTES OUTSIDE THE CORRIDOR
THREE SERIES, ONE SCALE (INDEX, M0 = 100) · CONVERSION IS THE REPORTED OUTCOME (+27%); THE OTHER TWO ARE ILLUSTRATIVE · HOVER A POINT.

The watch was three numbers on one page, refreshed from the same daily job that ran the collections tracker in case 01: conversion, the pocket price index, and — the one that kept the corridor honest — the share of quotes going out outside it. When that share crept up, it was never the corridor that was wrong; it was a new rep, or a vendor cost that had moved. The monthly read said which.

08 · THE TAKEAWAY

The cheapest money to recover is the money you were about to give away. Collections chase what is owed; pricing decides what is owed, and it was being decided by whoever was on the phone. Trace the price from list to bank, cohort the deals, and the leak names itself — then the seal is three numbers per category with a rule on each, and the win rate goes up, because the discounts were never what was winning.

STARTUP WORK (ZOPLAR ERA, 2023–25) — OUTCOME FIGURE AS REPORTED: QUOTE-TO-ORDER CONVERSION UP 27% FROM THE PRICING-INTELLIGENCE FRAMEWORK AND MARGIN LOGIC. THE WATERFALL STEPS, THE 180-QUOTE BAND, THE CORRIDORS, WIN-RATE AND MARGIN CURVES ARE REPRESENTATIVE RECONSTRUCTIONS; EMPLOYER DATA CONFIDENTIAL. THE QUOTATION-WORKFLOW STATES, THE CRM FIELDS AND THE MARGIN JOIN ARE THE REAL SHAPE OF THE PIPELINE. FRAMEWORK: McKINSEY, "THE POWER OF PRICING" (POCKET-PRICE WATERFALL; 1% PRICE ≈ 8% OPERATING PROFIT; 18.7% VOLUME TO OFFSET A 5% CUT).

Quoting by hand, and not sure whether you lose on price or win at any price? The Leak Audit starts with eighteen months of quotes and invoices and comes back with the waterfall, the band, and the three numbers per category. Two weeks, fixed fee.

Start with a TRACE → Case 01 → The method →