OPFOR Supply Learn

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

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