OPFOR Supply Learn

Depot Forecasting for Adaptive Clinical Trials

A global trial rarely runs from one warehouse. Kits sit in a central depot and regional depots, each with its own lead time, its own lots and its own sites. Depot forecasting answers a narrow question: which depot needs how many kits of which type, and by when. This page covers what the forecast must model to answer it.

From site demand to depot demand

Demand starts at the site. Each country activates sites on a ramp, each active site enrolls patients, and each enrolled patient generates kit demand from the visit schedule. Every country is assigned a primary depot, so depot demand is the sum of the demand of the sites it serves. When enrollment changes, depot demand changes with it.

What a depot forecast has to model

Why this breaks in a spreadsheet

Each rule above is simple on its own. Together they interact: a transfer changes both depots' balances, an expiry changes which lot is drawn, and a buffer change changes the transfer. In a spreadsheet those links are maintained by hand, so one changed input means re-checking every depot tab. See clinical supply forecasting without Excel for the wider picture.

How OPFOR Supply forecasts by depot

OPFOR Supply runs the chain end to end: site activation, enrollment, visit-driven demand, allocation of lots to depots within each label group, lead-time checks and recommended transfers against your min/max buffers. Change a site ramp, a lot date or a buffer and the whole forecast re-runs, with shortfalls flagged by depot and month.

Frequently asked questions

What is depot forecasting in a clinical trial?

Depot forecasting projects how many kits each regional depot will need, month by month, from the sites it serves. It combines site activation, patient enrollment and the visit schedule with lot release dates, expiry dates and depot lead times, so supply is staged where the demand will land.

How do min/max depot buffers work?

Each depot and kit has a minimum and a maximum level. When projected stock falls below the minimum, a transfer or shipment refills the depot up to the maximum. The forecast checks the policy against projected demand and flags months where the buffer cannot be met.

Why do label groups matter for depot planning?

A lot can only serve demand in its own label group, for example US or ROW. Pooling stock across label groups hides real shortages, so depot demand and depot stock have to be compared within each label group.

How does expiry affect which depot needs a transfer?

Stock that expires before it is used is not available supply. A depot forecast that ignores expiry shows a healthy balance until the lot expires, then a sudden gap. Modeling release and expiry dates per lot shows that gap months in advance.

See it on your own study

Forecast demand and buffers by depot without maintaining a tab per depot.

Try OPFOR Supply