PharmaDB
Use case · Pricing & Cost Benchmarks · Walk-Away Floor Price v.04.2026 · refreshed weekly
Use cases Pricing & Cost Benchmarks Walk-Away Floor Price
Pricing & Cost Benchmarks Buyer view Molecule · venetoclax Data · molecule API price aggregates Live

Walk-Away Floor Price

Compute the absolute walk-away floor from the trimmed minimum clearance price. The bid below which no margin remains, calibrated from real declarations.

Free preview · Ask the AI agent any sourcing question
Try
Sign up takes 30 seconds. Your question lands in your first chat.
Example output · venetoclax API · global 2024 · 7 active suppliers · 14 trimmed shipments · walk-away floor $1,000
$11,669.28 USD/kg · median · the bid line
n=14 shipments · trade warehouse, last 24 months Indicative

Venetoclax API clears at $11,669/kg median with a $10,000-to-$14,842 interquartile band across 7 active suppliers. The trimmed minimum sits at $1,000/kg, the absolute floor someone has cleared at in the dataset. Read this as: any bid below $10,000 is well below the p25, below $5,000 is approaching the trimmed minimum band, and a bid at $1,000 would match a known clearance but is structurally a no-margin event for any supplier without captive volume. The walk-away floor is the line below which the bid stops being a contract; it becomes a strategic loss.

p25 · aggressive entry
$10,000.00
deals get done
median · the bid line
$11,669.28
where the market clears
p75 · premium
$14,841.88
likely loses
Distribution · 8 price buckets
$1,000
$4,000
$7,000
$9,000
$10,000
$12,000
$14,000
$17,000
Walk-away floor
$1,000
p25 negotiation floor
$10,000
Median benchmark
$11,669
Active suppliers
7
30 seconds

How it works

molecule losartan origin IN destination BR
01

Pick a molecule.

Type the API INN. The AI agent pulls the trimmed minimum, p25, median, and supplier count from the global aggregate.

0 HHI 0.42 1
computed · pre-joined · anonymised
02

The AI agent computes the walk-away.

Trimmed minimum is the absolute floor. p25 is the structural negotiation floor. The user's margin target above the trimmed minimum gives the walk-away threshold.

brief · cited
Lane concentration · structurally concentrated
HHI0.42
Top-3 share71%
Actionqualify second source
03

Save the floor brief.

Citation-anchored brief: the walk-away floor, the negotiation bracket (p25 to median), and the supplier count signal on whether the floor is held by competition or by a single cheap buyer.

Why a finance team runs it

The bid floor below which margin disappears.

Trimmed minimum is the absolute floor.

The trimmed minimum represents the cheapest declared clearance in the dataset, with outliers removed. Below this, bids are either intra-group, captive volume, or strategic loss; not structurally negotiable for a market participant.

p25 is the negotiation floor.

Above the trimmed minimum and below the median sits the p25. This is where 25% of declared volume actually cleared. A bid at p25 is competitive but defensible.

Two-tier protection.

Bids below p25 are flagged as aggressive but allowed. Bids below the trimmed minimum are flagged as walk-away; sign-off required by finance.

Refreshes weekly.

API aggregates refresh weekly. The floor moves with the market; the brief carries the exact computation timestamp.

What a real chat looks like

Type a molecule. The AI agent returns the walk-away.

A real chat thread in PharmaDB. Type a question, the AI agent runs the tools, the answer lands as a saveable note.

Walk-away · venetoclax API
chat · saved 2 min ago
You
For venetoclax, surface the trimmed minimum API clearance price as the walk-away floor.
F
Running tool pharmagraph_query
molecule_api_prices · venetoclax · trimmed minimum + percentiles · 2024
F
Venetoclax API trimmed minimum is $1,000/kg, the absolute floor in 14 trimmed shipments. The p25 is $10,000 (10x the floor), reflecting that the floor is one outlier and the structural negotiation band sits an order of magnitude higher. Median is $11,669. Walk-away threshold: any bid below $10,000 should require finance sign-off; below $5,000 is presumed structural-loss territory for a typical participant. With 7 active suppliers, the floor is held by limited competition; the brief flags no-go on accepting the $1,000 floor as the going-forward expected price.
Walk-away floor
$1,000
p25 negotiation floor
$10,000
Median
$11,669
Active suppliers
7
Cited molecule_api_prices 7 suppliers · 14 trimmed molecule_country_flow lane-level shipments molecule_catalog INN matched
Ask a follow-up... ⌘ ↵
Time-to-answer

Manual workflow vs. PharmaDB.

Manual workflow
Excel · email · syndicated reports
  1. 01 Pull trade declarations for the molecule 3-4 hr
  2. 02 Trim outliers and unit-mismatched rows 2-3 hr
  3. 03 Compute trimmed minimum and percentiles 1-2 hr
  4. 04 Validate against prior-period anchor 2 hr
  5. 05 Build walk-away brief with margin overlay 2-3 hr
Total cycle time 1 day per molecule
PharmaDB
The AI agent · one query · cited
One query.
Pre-joined warehouse. The trimmed minimum and percentile band sit on `molecule_api_prices`. The AI agent returns the walk-away with the supplier-count signal inline.
Total cycle time Under a minute
Run it across your portfolio

Where the walk-away floor sits, per molecule.

Twelve molecules · 2024 trimmed minimum and p25 · USD/kg API.

Sitagliptin global API
$0.10 floor
↓ 8%
Empagliflozin global API
$1.68 floor
↑ 6%
Apixaban global API
$2.22 floor
↑ 7%
Linagliptin global API
$2.47 floor
↑ 9%
Vortioxetine global API
$9.90 floor
↓ 2%
Dolutegravir global API
$99 floor
↓ 6%
Sacubitril global API
$354 floor
↓ 4%
Abiraterone global API
$800 floor
↑ 0%
Venetoclax global API
$1,000 floor
↑ 4%
Tofacitinib global API
$1,707 floor
↓ 5%
Nilotinib global API
$2,595 floor
↓ 2%
Dasatinib global API
$2,500 floor
↓ 3%
IQR (p25–p75) Median USD/kg ↓ YoY price drop · margin pressure · ↑ YoY price rise · tighter market

The walk-away floor is the absolute lower bound for margin-positive bidding. PharmaDB surfaces the trimmed minimum from molecule_api_prices alongside the structural p25 and median. Refresh cadence is weekly.

FAQ

Frequently asked

How is the walk-away floor different from the bid floor?+

The bid floor is the price below which the user does not achieve their target margin (usually p25 plus a margin target). The walk-away floor is the trimmed minimum: the price below which structurally no margin remains for any supplier. The walk-away is the harder line.

Why use the trimmed minimum rather than absolute minimum?+

Customs data carries unit-mismatched rows (per-pack labelled as per-kg) and other artifacts. The trimmed minimum excludes rows below 0.01x median, giving an empirical floor that real participants have cleared at.

What if the trimmed minimum looks too low to be real?+

Sometimes the trimmed minimum reflects intra-group transfers or captive-supply contracts that other buyers cannot replicate. The brief surfaces a confidence chip when the trimmed minimum sits more than 10x below the p25; the user should not treat that floor as competitively negotiable.

How is the supplier count used?+

Floors held by many suppliers (15+) are competitive; the trimmed minimum is closer to the structural floor. Floors held by 3-6 suppliers may carry an artificially low trimmed minimum that reflects one supplier's tactical clearance; the structural floor is higher.

Does this support contract sign-off?+

Yes. Bids at or below the walk-away floor require finance sign-off in most enterprise pricing policies. The brief carries a chip that flags the bid as walk-away level for the workflow.

How fresh is the data?+

API aggregates refresh weekly. The walk-away floor reruns on every refresh; the catalog row carries the exact timestamp.

Run your question.

Bring the molecule, the lane, or the supplier you're sourcing this week. The AI agent runs it on PharmaDB in 30 minutes. You keep the brief.

Book a working session