Demand Planning for Pharma and Healthcare Products

Put simply, healthcare products demand planning, a specialist part of demand planning and inventory optimization, covers medicines, over-the-counter products, supplements, diagnostics, medical devices and consumables, and it differs from other consumer sectors because a stockout can harm a patient and because regulation shapes almost every part of the supply chain. Products carry expiry dates, are tracked by lot, are made in validated facilities and often depend on a small number of qualified suppliers. Demand may be driven by prescriptions, tenders, reimbursement decisions, seasons of illness and guidance from health authorities. This guide is written for planners and finance leaders in the consumer-facing and commercial parts of healthcare. It is general information and not regulatory or clinical advice, and requirements vary by product and market, so always work with your quality and regulatory teams. It follows specialty retailers, leads to seasonal demand planning and promotion forecasting, and links to cash flow management.

What makes healthcare planning different

Four features stand out. Service matters more: for essential products, the cost of a stockout is not just lost margin but a risk to patients and to trust with health systems. Time matters in a different way: expiry limits how long stock can be held, and customers often require a minimum remaining life at delivery. Control matters: lot traceability, quarantine and release, and recall readiness are built into operations. And demand has special sources: prescriptions follow clinical practice, tenders create step changes, and policy decisions such as reimbursement or formulary changes can shift volumes quickly. The planner must understand each source and its uncertainty.

Service targets by criticality

Not all products warrant the same service level. Classify products by clinical or commercial criticality. Essential products with few substitutes need very high availability and larger safety stock, and the company may choose to hold buffer stock at several points. Products with close substitutes can tolerate more risk. Elective or lifestyle products behave more like consumer goods. Document the classification and the service target for each class, and agree it with medical, quality and commercial colleagues. Tie safety stock to the target and to the variability of both demand and supply. See safety stock formula.

Shelf life and minimum remaining life

Customers such as wholesalers, pharmacies and hospitals typically require a minimum remaining shelf life at receipt, often expressed as a percentage of the total life or a number of months. If a product has a shelf life of 36 months and the customer requires at least 24 months remaining on delivery, the product has 12 months in which it can be produced, stored and shipped to that customer. Stock beyond that point can only go to customers or markets with lower requirements, or must be written off. Planning should consider the age of stock by lot, the demand by customer and the requirements of each customer. Production batches should be sized so that most of the batch is sold within the useful window. See inventory aging reports.

Batches, lot sizes and lead times

Pharmaceutical and healthcare manufacturing is often done in large batches with long lead times, including testing and release. A batch may take weeks or months from the start of production to release for sale, and the minimum batch size may exceed several months of demand. This creates the familiar tension between large batches that risk expiry and small batches that increase cost. Plan on a rolling horizon long enough to cover the full lead time, including quality testing, and maintain a view of work in progress by stage. Because supply is hard to change quickly, forecast accuracy over the long horizon matters. See forecast bias.

Tender-driven demand

Hospitals, health systems and government buyers often purchase through tenders. The outcome is binary or tiered, and the volume that results can be large. Forecasting tender demand requires scenarios. Suppose a tender covers 100,000 units. The company estimates a 30 percent chance of winning the full volume, a 30 percent chance of winning half of it and a 40 percent chance of losing (illustrative). The probability-weighted volume is 0.30 × 100,000 + 0.30 × 50,000 + 0.40 × 0 = 30,000 + 15,000 + 0 = 45,000 units. Check: probabilities sum to 1.00. The expected value is a useful input for finance, but the supply plan cannot be built on the expected value alone, because the outcomes are 100,000, 50,000 or 0, never 45,000. The planner might commit to production for the base case of 50,000 units, hold a reserve of capacity and materials for the upside of another 50,000, and agree triggers for release when the result is known. The cost of the reserve is weighed against the value of the sales that would otherwise be lost. After the award, replace the scenarios with the awarded volume, delivery schedule and the actual call-offs.

Seasonal illness and policy changes

Some products follow seasons of illness, such as colds, allergies or influenza. Timing and severity vary, and external data such as surveillance reports can help. Build a seasonal profile and a scenario for a mild, normal and severe season. Policy changes, including changes in reimbursement, guidelines, pricing or the entry of generic competitors, can change volumes quickly. Keep a calendar of known policy events and include their expected effect in the forecast. For products losing exclusivity, plan the decline in volume and the corresponding reduction in inventory and commitments, and avoid buying ahead of demand that will not return. See seasonal demand planning.

Shortages and allocation

When supply is short, due to a manufacturing problem or a raw material shortage, the company must allocate what it has. Establish a policy in advance: by customer type, by criticality of use, by past volumes or by a mix. Communicate openly with customers and authorities where required. Track the recovery plan, including timing, and update customers on the expected return of full supply. The policy should be applied consistently, and the planning team should be ready to model the effects of the allocation on service, revenue and relationships.

Cold chain and special handling

Some healthcare products require controlled temperatures, special packaging or secure handling. These add cost and constraints: validated shippers, limited transit windows, qualified carriers and temperature monitoring. The planner must factor these into lead times and delivery schedules, and into the cost of holding and moving stock. A temperature excursion can make a lot unusable, so contingency plans and spare stock for critical shipments are part of the design. See excess and obsolete inventory.

Serialization, traceability and data

Many markets require tracking of individual packs or lots. The planning system should carry lot, expiry and status information, and reports should be available by lot. Good data on sales by customer, sell-out where available, and inventory in the channel improves the forecast and supports recall readiness. Poor master data, such as inconsistent product identifiers across systems, causes errors that are expensive in a regulated setting. See data quality.

Financial considerations

Healthcare supply chains often involve high-value inventory, long cycles and large write-off exposure. Finance should be part of planning. The cost of expiry, the working capital tied up in large batches and the effects of tender timing on cash are material. Reserve policies for short-dated stock should be clear and consistent, and the effect of write-offs on margin should be tracked. See inventory write-downs and how inventory decisions affect cash flow.

Measures to track

Track forecast accuracy and bias by product and customer group, fill rate and on-time delivery by customer, stockout incidents on critical products, stock by remaining shelf life, expiry write-offs, batch release lead time, tender forecast versus outcome and supplier performance. Review monthly with quality, regulatory and commercial colleagues present.

A batch-size example with a shelf-life window

Suppose a product has a shelf life of 36 months from manufacture. Release testing takes two months, and shipping to the customer takes one month (illustrative). A key customer group requires at least 24 months of remaining life on delivery. The product must therefore arrive no later than 36 - 24 = 12 months after manufacture. Because it cannot be sold before release and shipping are complete, the earliest delivery is at month 3. The selling window to this customer group is the period from month 3 to month 12, which is 9 months. If the group buys 4,000 units a month, a batch can serve at most 9 × 4,000 = 36,000 units within the window. A batch of 50,000 units would leave 50,000 - 36,000 = 14,000 units that cannot go to this group. At a cost of $12 per unit, that is 14,000 × 12 = $168,000 of stock whose destination must be found elsewhere, such as markets with lower remaining-life requirements, or else written off. Check: 36,000 + 14,000 = 50,000. The comparison with the cost of a smaller batch, which may have a higher unit cost, shows whether the large batch pays. Many companies find that the cost saving from a larger batch is smaller than the exposure it creates.

Channel inventory

Wholesalers, distributors and pharmacies hold their own stock, which affects the company's sales. A change in the channel's target stock, a stock build ahead of a price increase or a destocking after a policy change can move sell-in far from the underlying consumption. Where data is available, track channel inventory in weeks of cover and compare sell-in with sell-out. Without this view, a rise in shipments can be mistaken for rising demand. Agree with distributors on the data they will share and use it to adjust the forecast. See demand planning for CPG companies for the same issue in consumer goods.

Working with quality and regulatory teams

The planning team depends on quality and regulatory colleagues for release dates, deviations, investigations and market authorizations. A batch on hold, a change in packaging requiring approval or a delay in a market registration can change the supply plan overnight. Include these colleagues in the monthly planning meeting, or at least have a routine for receiving status updates. Build the known constraints into the lead times, and keep a log of events that delayed supply to improve future estimates. Treat compliance as a design constraint of the plan, not as an obstacle to it.

Common mistakes

Setting the same service target for all products wastes cash on low-criticality items and under-protects essential ones. Planning on printed shelf life and not the customer's minimum remaining life overstates the window. Forecasting tenders with a single expected value produces plans that match no actual outcome. Ignoring batch release time shortens the real lead time. Failing to plan for loss of exclusivity leaves excess stock. Treating compliance as separate from planning causes costly surprises.

FAQs

Why is healthcare demand planning different?

Patient safety, expiry, lot control, regulation and tender-driven demand make service and shelf life central.

How do I set service levels?

Classify products by criticality and substitutability, set targets by class and size safety stock accordingly.

How should I forecast a tender?

Use scenarios with probabilities, plan for the base case and hold reserves for the upside, then replace with actual awards.

How does shelf life affect batch sizes?

Customers require minimum remaining life, so the usable window is shorter than the printed life and batches should fit it.

What should I do when supply is short?

Apply a pre-agreed allocation policy, communicate with customers and track recovery.