PharmaDB
Use case · Portfolio & Sourcing Strategy · Trade Seasonality Forecasting v.04.2026 · refreshed monthly
Use cases Portfolio & Sourcing Strategy Trade Seasonality Forecasting
Portfolio & Sourcing Strategy Buyer view Molecule · sacubitril Data · trade flowsData · molecule seasonality view Live

Trade Seasonality Forecasting

Compute monthly seasonal multipliers for any molecule. Pre-build inventory for the peak, hold less through the trough. Sized from declared trade.

Free preview · Ask the AI agent any sourcing question
Try
Sign up takes 30 seconds. Your question lands in your first chat.
Example output · monthly shipment volume aggregated across 1,336 molecules
1.22x · Peak-month multiplier vs annual average, global API trade 2024
n=1,067 molecules with ≥12 shipments in 2024 Indicative

Across the 1,336 molecules with month-level trade telemetry, March is the peak month at 1.22x the annual mean and January is the trough at 0.89x. The peak-to-trough spread is 1.37x at the global level. Molecule-specific curves run far wider; the global aggregate smooths most of that variance.

JanJulDec
Peak month (Mar)
1.22x
73,598 shipments
Trough month (Jan)
0.89x
53,565 shipments
Peak-to-trough spread
1.37x
Molecules with month-level data
1,336
30 seconds

How it works

molecule losartan origin IN destination BR
01

Pick the molecule.

Type the molecule name. The AI agent reads the molecule_seasonality view, four years of monthly trade aggregates.

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

The AI agent computes the multipliers.

Mean monthly value across 2022 to 2025. Each month is normalised against the annual mean. Peak month, trough month, and peak-to-trough ratio surface as KPIs.

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

Save the curve.

Citation-anchored brief with the 12-month curve, the recommended pre-build month, and a one-click handoff to the safety-stock workflow.

Why a planner runs it

S&OP demand shape, sized from real trade.

Four-year mean curve.

Each month is averaged across 2022, 2023, 2024, and 2025 to dampen single-year shocks. The shape is the structural demand pattern.

Pre-build window surfaced.

The AI agent names the month to start building inventory and the month to wind down. No more guessing the lead time for the peak.

Peak-to-trough variance.

Molecules with under 1.5x ratio are flat; over 3x is seasonal; over 5x is extreme and needs a buffer plan.

Auto-trigger safety stock.

Peak-to-trough above 3x triggers the Strategic Safety Stock workflow with the multiplier and lead time pre-filled.

What a real chat looks like

Type a molecule. The AI agent returns the curve.

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

Seasonality · sacubitril
chat · saved 2 min ago
You
Compute the monthly seasonality multiplier for sacubitril API demand. Surface the peak and trough months and recommend a safety-stock posture.
F
Running tool pharmagraph_query
molecule_seasonality · 48 month-year aggregates · 2022-2025
F
Sacubitril demand is heavily back-loaded. The September average is 3.3x the annual mean and the March trough sits at 0.11x. The peak-to-trough ratio of 30x puts this molecule in the extreme-seasonality bucket. Start building inventory in June, hold through August, draw down October to February. Annual lane value sits at $35.1M across all destinations.
Peak month
September
Peak multiplier
3.32x
Trough month
March
PT ratio
30x
Cited molecule_seasonality 48 monthly aggregates molecule_country_flow 2024 annual
Ask a follow-up... ⌘ ↵
Time-to-answer

Manual workflow vs. PharmaDB.

Manual workflow
Excel · email · syndicated reports
  1. 01 Pull monthly trade declarations 3-4 hr
  2. 02 Aggregate by month and year 2-3 hr
  3. 03 Compute multipliers per month 1-2 hr
  4. 04 Validate against multiple years 2-3 hr
  5. 05 Build the S&OP recommendation 2 hr
Total cycle time 1-2 days per molecule
PharmaDB
The AI agent · one query · cited
One query.
Pre-joined warehouse. Monthly aggregates are computed at the view layer. Multipliers refresh on every catalog refresh. The AI agent returns the curve, the peak, and the recommended pre-build month in chat.
Total cycle time Under a minute
Run on a portfolio

Peak-month concentration across the latest blockbuster pool.

Twelve molecules with non-trivial seasonal variance · peak month value as share of annual mean · 2022 to 2025 averages.

Carfilzomib
Peak Sep · trough Mar
1.00
Tirzepatide
Peak Nov · trough Jan
0.93
Acalabrutinib
Peak Dec · trough Feb
0.85
Edoxaban
Peak Dec · trough Jun
0.75
Lenalidomide
Peak Feb · trough Oct
0.72
Saxagliptin
Peak Mar · trough Sep
0.66
Dabigatran
Peak Jun · trough Nov
0.58
Olaparib
Peak Oct · trough Aug
0.55
Abemaciclib
Peak Dec · trough May
0.52
Sacubitril
Peak Sep · trough Mar
0.50
Ibrutinib
Peak May · trough Oct
0.38
Valsartan
Peak Sep · trough Oct
0.36
Competitive Monitored Concentrated Near-monopoly

The seasonality curve is the first piece of demand shape any S&OP planner needs. PharmaDB averages four years of monthly trade aggregates and returns a 12-point multiplier curve in a single query. The view is molecule_seasonality; the source table is shipment-level trade declarations. Refresh cadence is monthly.

FAQ

Frequently asked

What does a seasonal multiplier mean?+

It is the ratio of that month's average trade value to the annual mean monthly value. A multiplier of 2.0 means that month carries twice the demand of an average month. A multiplier of 0.5 means half.

How many years of data go into the curve?+

Four. PharmaDB averages monthly trade aggregates from 2022 through 2025 to smooth out single-year shocks like a pandemic procurement spike or a one-off tender win. The underlying view is molecule_seasonality.

What counts as a seasonal molecule?+

Peak-to-trough ratio above 1.5x is the noise threshold. Above 3x is meaningfully seasonal and warrants S&OP attention. Above 5x is extreme and triggers the Strategic Safety Stock workflow automatically.

Why does sacubitril peak in September?+

The pattern across blockbuster molecules typically traces back to Q4 tender cycles, hemisphere-specific procurement calendars, or local fiscal-year purchasing windows. The trade data shows the shape; the buyer's local-market knowledge fills in the why.

How fresh is the data?+

Trade aggregates refresh monthly. Each month, the trailing 12-month window adds the new month and drops the oldest. The catalog row carries the last-computed timestamp surfaced on every result page.

Does this work for FDF as well as API?+

Yes. The same methodology applies to finished-dosage trade. FDF seasonality often shows a different shape than API because of pack-size and tender effects, so it pays to run both.

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