Clinical Supply Forecasting Without Excel
Most clinical supply plans start in a spreadsheet, and most spreadsheets stop being trustworthy once the study has several depots, multiple lots, and enrollment that does not follow the original plan. This page explains where the spreadsheet breaks and what an automated forecasting tool does differently.
Where spreadsheets break
- Adaptive enrollment. Site activation ramps and recruitment rates change monthly. Each change means re-keying demand across every country and depot tab.
- Lot expiry and release. Which lot serves which month depends on release dates, expiry dates and label group. Manual allocation hides stockouts that only appear when a lot expires before it is used.
- Depot buffers and transfers. Min/max buffers per depot and kit, plus transfers between depots, create circular dependencies that formulas handle badly.
- Titration and open-label extension. Visit schedules that change kit type mid-study multiply the number of demand lines to maintain.
- One scenario at a time. A single point estimate says nothing about the range of outcomes if enrollment runs faster or slower.
What an automated forecast does instead
OPFOR Supply models the whole chain from site activation and patient enrollment through visit-driven kit demand, lot allocation and depot transfers. Change an input and the forecast re-runs. Monte Carlo simulation shows P10, P50 and P90 outcomes, so planners see the range of risk rather than one number.
Frequently asked questions
Why do clinical supply spreadsheets break down?
A spreadsheet holds one scenario and one set of assumptions. When enrollment slips, a lot expires early, or a depot buffer changes, every dependent tab has to be updated by hand, and errors compound silently.
What does a forecasting tool do that a spreadsheet cannot?
It re-runs the whole model when an input changes: site activation, patient enrollment, visit-driven kit demand, lot release and expiry, depot allocation and transfers. It can also run many simulated enrollments to show a range of outcomes instead of a single number.
Does a forecasting tool replace the RTSM or IRT system?
No. The RTSM runs live randomization and dispensing. A forecasting tool plans the supply that the RTSM will later dispense: how much to manufacture, when, and where to stage it.
See it on your own study
Build a supply forecast without a single manual spreadsheet update.
Try OPFOR Supply