Compute the bid floor for any tender response. Lane median plus IQR plus cost target — the floor below which the bid stops making margin.
Bilastine clearance prices into Spain cluster around $700.83/kg median across a tight $645-$750 interquartile band. With a $9.1M lane value and only five active exporters (HHI 0.82), the lane is a concentrated premium-specialty pricing environment. A buyer modelling a 15% margin target above estimated API cost lands the bid floor near the lane p25, leaving narrow but defensible headroom.
Type the molecule and destination market. Optionally constrain by origin country to model a specific supplier's bid.
Lane median + IQR width + your API cost target + your margin floor — combined into a single bid-floor figure with the underlying breakdown.
Citation-anchored brief with the bid floor, the headroom to median and p25, and an aggressive / conservative bracket.
Built from clearance records on the actual lane. The floor is computed against what the market clears, not against a vendor brochure.
API cost is taken from PharmaDB's cost-spread view. The floor stays above cost plus your margin target, every time.
The minimum margin is a hard input. Bids below the computed floor are flagged as walk-away — automatic risk on contract sign-off.
Lane clearance and cost spread refresh weekly. The floor moves with the market; the brief carries the exact computation timestamp.
A real chat thread in PharmaDB. Type a question, the AI agent runs the tools, the answer lands as a saveable note.
pharmagraph_query Twelve molecule-lanes from the live warehouse · 2024 percentile band, USD/kg, with year-on-year median shift.
The bid-floor calculator is the bridge between price intelligence and tender response. PharmaDB takes the lane’s clearance distribution and the cost spread for the API, applies the user’s margin target, and returns a defensible bid floor with headroom to median and p25. The view is molecule_country_flow; the underlying tables are lane_competitiveness and api_cost_spread.
API cost (from PharmaDB's cost-spread view) multiplied by 1 plus the user-supplied margin target. The result is checked against the lane's p25 — if the floor sits below p25, the bid is in the aggressive-entry band. If above p75, the bid is unlikely to win.
PharmaDB falls back to a heuristic: the trailing 12-month minimum clearance price on the lane minus a typical 8% margin assumption. The result is flagged as estimated. The companion view exposes the exact intermediates and energy cost build-up where available.
The bid floor is the minimum at which the bid still makes the target margin. The walk-away floor is the minimum at which the bid still makes any positive margin. PharmaDB surfaces both; the spread between them is the negotiation room.
The median is the price at which roughly half of clearance volume happens. Bids near or below the median are in the competitive zone. Bids near or above the p75 typically lose. The median is the empirical anchor.
Identities are aggregated and anonymised at the threshold required by the trade-data disclaimer. Bid-floor computation uses lane aggregates, never named-counterparty transaction data.
Yes. The same methodology applies to API, FDF, and intermediates. FDF lanes add a pack-size normalisation step in the price percentile view; the bid floor is reported per kg or per pack at the user's choice.
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.