Oncology Medicine Supply From India to Brazil: How to Prepare a Rolling Demand Forecast

Oncology Medicine Supply From India to Brazil: How to Prepare a Rolling Demand Forecast

• Medical
• October 30, 2026

What Is a Rolling Demand Forecast?

A rolling demand forecast is an estimate of future requirements that is reviewed regularly and extended as each reporting period closes.

For example, a business may maintain a forecast covering the next 12 months. After each month ends, it records actual demand, reviews the remaining estimates and adds another month to the planning horizon.

The planning period should reflect the products, purchasing arrangements and time needed to replenish stock.

Forecast Components May Include:

• Product identification.
• Strength and dosage form.
• Pack configuration.
• Monthly demand estimates.
• Historical sales or consumption.
• Confirmed customer requirements.
• Expected changes in demand.
• Assumptions supporting adjustments.
• Confidence in the available information.
• Forecast version and approval date.

The forecast estimates future demand. A supply plan then considers inventory and incoming shipments to determine what should be ordered and when.

Why Does Demand Forecasting Need Careful Preparation?

Historical sales do not always represent the quantities customers needed.

A month with low sales may reflect unavailable stock. A month with unusually high sales may reflect a customer purchasing several months of inventory at once.

UNDP’s health-product guidance explains that forecasting should account for past consumption and expected changes in use. Underestimating requirements can contribute to shortages, while overestimating them increases overstock and expiry risks. healthimplementation.undp.org

A Demand-Forecast Review May Need to Address:

• What the historical figures measure.
• Which customers and channels are included.
• Periods when products were unavailable.
• Unusual customer orders.
• Confirmed purchasing commitments.
• Changes in contracts.
• Product-specific supply constraints.
• Expected delivery timing.
• Inventory approaching expiry.
• Differences between forecasts and actual demand.

The objective is to maintain an informed estimate and make significant uncertainties visible.

Define the Product and Planning Details

Prepare a precise product list before collecting demand information.

A broad description such as “oncology medicines” does not provide enough detail for reliable purchasing. Different strengths, dosage forms and presentations should remain distinguishable.

The Initial Record Should Include:

• Generic medicine name.
• Brand name, where applicable.
• Internal product code.
• Strength or concentration.
• Dosage form.
• Product presentation.
• Manufacturer.
• Pack configuration.
• Customer product reference.
• Required storage conditions.
• Forecasting unit.
• Customers included.
• Geographic coverage.
• Planning horizon.
• Forecast owner.

Update the record when a product specification, customer requirement or supply arrangement changes.

Confirm the Unit of Measure and Pack Configuration

All forecast inputs and purchasing calculations should use clearly defined units.

A customer may provide requirements in cartons, the supplier may quote packs, and warehouse records may show individual vials.

Details to Confirm:

• Individual units per saleable pack.
• Saleable packs per shipping carton.
• Shipping cartons per pallet, where applicable.
• Units used in historical records.
• Units used in customer forecasts.
• Units used in purchase orders.
• Base unit used for planning.

For example, 100 packs containing five vials each represent 500 vials.

A forecast of 500 packs would represent 2,500 vials for that configuration.

Document the conversion basis before consolidating information. Do not combine different strengths or presentations as though they were interchangeable.

Review Historical Demand and Customer Requirements

Check historical information against the purpose of the forecast.

Distributor sales, hospital receipts and actual consumption represent different stages of the supply chain. Adding them together can count the same underlying requirement more than once.

Demand Information to Review:

• Monthly sales quantities.
• Verified consumption records, where available.
• Customer orders.
• Requested delivery dates.
• Unfulfilled quantities.
• Returns.
• Cancellations.
• Stockout periods.
• One-time bulk orders.
• Tender-related deliveries.
• Contract start and end dates.
• Customer additions or departures.
• Previous forecast assumptions.
• Known data gaps.

Maintain original records alongside adjusted figures so reviewers can understand how the baseline was developed.

Where forecasts use treatment-activity information, the responsible clinical and pharmacy teams should validate the quantities. Commercial planners should not independently determine treatment regimens or doses.

Calculate the Initial Demand Baseline

Establish an initial estimate before adding expected changes.

A recent average can provide a starting point for relatively stable demand. Products with changing requirements may need a trend review or customer-level assessment.

Calculation Steps May Include:

1. Select the Historical Period: Choose a period relevant to current business conditions.
2. Check the Units: Convert records into the agreed planning unit.
3. Review Missing Information: Identify incomplete months or customer records.
4. Investigate Exceptions: Examine stockouts and unusual orders.
5. Calculate the Baseline: Apply the selected forecasting method.
6. Compare Customer Inputs: Review current requirements against the baseline.
7. Document Adjustments: Explain changes and their supporting evidence.
8. Approve the Starting Estimate: Record the owner and approval date.

For example:

Adjusted demand of 240, 270 and 300 vials over three months:

(240 + 270 + 300) ÷ 3 = 270 vials per month.

This establishes an initial average. The increasing pattern should be investigated before assuming future demand will remain at 270 vials.

Adjust for Stockouts and Exceptional Orders

Identify events that make historical records less representative of future requirements.

Low sales during a stockout should not automatically be treated as reduced customer need. Equally, an exceptional purchase should not automatically become a recurring monthly requirement.

Possible Adjustments Include:

• Allowance for documented unfulfilled demand.
• Removal of duplicated transactions.
• Separation of warehouse transfers from sales.
• Correction of unit-conversion errors.
• Identification of one-time purchases.
• Allocation of bulk orders to the periods they cover.
• Changes supported by confirmed customer information.

Comparison Points Include:

• Whether reliable evidence supports the adjustment.
• Whether the requirement is already recorded elsewhere.
• Whether the event is expected to recur.
• Which months are affected.
• Who approved the change.
• When the assumption should be reviewed.

Keep adjusted and unadjusted figures distinguishable.

Obtain Customer-Specific Forecast Inputs

Ask customers for information that can improve the baseline.

Separate confirmed schedules from estimates and possible commercial opportunities.

Customer Information to Request:

• Product and presentation required.
• Monthly quantities.
• Required delivery dates.
• Confirmed purchase commitments.
• Contract duration.
• Planned changes in purchasing frequency.
• Customer inventory, where available.
• New facility requirements.
• Expected contract commencement.
• Tender award status.
• Remaining shelf-life requirements.
• Confidence in the estimate.

Check whether these requirements are already included in historical demand.

Adding a full customer estimate on top of a baseline that already includes that customer can overstate the forecast.

Include Forecast Scenarios and Document Assumptions

Some requirements depend on events that have not yet been confirmed.

Use clearly explained scenarios where uncertainty could materially affect purchasing.

Demand Scenarios May Include:

• Base demand supported by approved assumptions.
• Higher demand following a confirmed expansion.
• Delayed demand if a contract begins later.
• Lower demand after an existing agreement ends.
• Temporary changes in customer purchasing schedules.
• Alternative timing for uncertain requirements.

Assumption Details to Review:

• Description of the expected change.
• Products affected.
• Quantity adjustment.
• Relevant months.
• Supporting evidence.
• Confirmation status.
• Responsible owner.
• Review date.

Scenario quantities should not automatically become purchase commitments. Review the consequences for stock availability, expenditure and expiry exposure before acting.

Confirm Usable Inventory and Incoming Supply

Demand forecasts need to be considered alongside available stock.

The total quantity shown in a warehouse report may include inventory that cannot support the planned requirement.

Information to Review:

• Physical stock balance.
• Batch identification.
• Quality-release status.
• Expiry dates.
• Reserved quantities.
• Damaged or quarantined stock.
• Customer acceptance restrictions.
• Open purchase orders.
• Confirmed incoming quantities.
• Expected usable receipt dates.

Count incoming supply in the period when it is expected to become available for distribution.

Avoid counting the same shipment as both warehouse stock and an outstanding receipt.

Calculate Monthly Supply Requirements

Use the approved demand forecast to project stock balances over time.

A basic monthly calculation is:

Projected closing stock = usable opening stock + usable receipts − forecast demand.

Supply-Planning Questions Include:

• Will stock remain available before the next receipt?
• What closing-stock target has been approved?
• Does the target reflect demand and lead-time uncertainty?
• Are there minimum order quantities?
• Can deliveries be divided?
• Is adequate storage available?
• Will proposed quantities be used before expiry?
• Is funding available for the purchasing schedule?

UNDP recommends translating health-product requirements into monthly needs and reviewing current supplier lead times when scheduling procurement. healthimplementation.undp.org

Assess receipt timing within the month where necessary. A positive month-end balance can conceal an earlier shortage.

Add Production, Import Processing and Delivery Timing

Map the activities between order placement and usable receipt in Brazil.

A supplier’s production lead time covers only part of the replenishment process.

Possible Lead-Time Components Include:

• Purchase order acceptance.
• Production scheduling or stock allocation.
• Batch release.
• Export preparation.
• Document completion.
• Shipment booking.
• International transit.
• Import processing.
• Warehouse delivery.
• Receiving checks.
• Release into available inventory.

The responsible importer and regulatory team should confirm the applicable import pathway and documentation using current ANVISA guidance. www.gov.br

Use current estimates and distinguish planned dates from confirmed milestones.

Maintain One Controlled Forecast Version

Customer inputs, supplier updates and inventory reports may arrive at different times.

Maintain one approved planning version so teams can identify the figures currently used for decisions.

Version Details to Record:

• Forecast preparation date.
• Planning period.
• Product list.
• Data cut-off date.
• Assumptions included.
• Changes from the previous version.
• Prepared-by details.
• Approval status.
• Approved-by details.
• Date shared with relevant partners.

Retain previous versions for comparison.

A controlled forecast should preserve the explanation behind material changes rather than simply overwrite earlier estimates.

Assign Forecast Responsibilities Across the Supply Chain

Forecast preparation requires input from several functions.

Assign an owner to consolidate information, resolve inconsistencies and coordinate approval.

Functions to Involve May Include:

• Customer account management.
• Demand planning.
• Procurement.
• Supplier commercial teams.
• Inventory management.
• Logistics.
• Quality assurance.
• Regulatory affairs.
• Finance.
• Receiving warehouse.
• Distribution teams.

Confirm who provides each input, who approves adjustments and who communicates revised requirements.

Use aggregated product information where possible. Routine supplier forecasts generally do not require identifiable patient information.

A Practical Rolling Demand Forecast Checklist

Hypothetical Example: Calculating a Replenishment Requirement

A Brazilian distributor prepares a monthly supply plan for one oncology medicine presentation.

The following quantities are invented to illustrate the arithmetic. They are not treatment quantities, supplier commitments or a product-specific purchasing recommendation.

All figures are expressed in individual vials.

Illustrative Planning Inputs:

• Forecast demand during the month: 400 vials.
• Usable opening stock: 300 vials.
• Confirmed usable receipts: 150 vials.
• Approved target closing stock: 200 vials.

Projected closing stock before additional replenishment:

300 + 150 − 400 = 50 vials.

Additional usable receipts required to reach the closing-stock target:

400 + 200 − 300 − 150 = 150 vials.

The illustrated plan therefore requires another 150 usable vials within the relevant period to reach the target, assuming the inputs remain unchanged.

The team must still review ordering deadlines, receipt timing, available batches, shelf life and commercial conditions.

A calculated requirement does not establish that the quantity can be supplied in time.

Separate Forecast Quantities From Purchase Commitments

A forecast communicates expected demand. A purchase order creates a commitment according to its agreed commercial terms.

Maintain a clear distinction between planning estimates and accepted orders.

Separate Views May Include:

• Approved baseline forecast.
• Confirmed customer orders.
• Unconfirmed opportunities.
• Higher- and lower-demand scenarios.
• Proposed supplier purchases.
• Accepted purchase orders.
• Confirmed shipment schedules.
• Deferred requirements.

Confirm whether a forecast is indicative or carries contractual obligations.

Do not assume that sharing a forecast reserves production capacity, secures a price or guarantees product availability.

Update the Forecast and Reconcile Actual Demand

Review the forecast at an agreed frequency and when material events occur.

After a period closes, record actual demand, investigate differences and extend the horizon.

Possible Review Activities Include:

• Replace closed-month estimates with actual figures.
• Investigate significant forecast differences.
• Review repeated overforecasting.
• Review repeated underforecasting.
• Update customer schedules.
• Revise receipt dates.
• Recalculate stock projections.
• Review expiry exposure.
• Approve changes.
• Communicate revised requirements.

Records to Reconcile Include:

• Previous forecast versions.
• Sales or consumption records.
• Customer purchase schedules.
• Inventory reports.
• Open purchase orders.
• Supplier confirmations.
• Shipment updates.
• Goods received records.
• Batch-status information.
• Approved planning adjustments.

Document the reasons for material differences so future forecasts can become more reliable.

Common Mistakes to Avoid

Comparing Different Units

Convert inputs to the same clearly defined unit before consolidating quantities.

Checking Only Historical Sales

Review stockouts, customer changes and exceptional orders before projecting demand.

Counting Requirements Twice

Check whether customer commitments are already included in the baseline.

Using One Estimate for Every Presentation

Maintain product-specific forecasts for relevant strengths, dosage forms and pack sizes.

Confusing Forecasts With Purchase Orders

Separate planning information from accepted commercial commitments.

Ignoring Shelf-Life Constraints

Assess whether stock will remain suitable when the requirement arises.

Counting Unavailable Inventory

Exclude quantities that cannot support the planned demand.

Leaving Forecasts Unreconciled

Compare approved estimates with actual demand and investigate significant differences.

Working With Zircon Medtech on Oncology Medicine Supply Planning

When discussing oncology medicine supply from India to Brazil with Zircon Medtech, provide a clear product brief and dated demand forecast.

Identify confirmed requirements separately from indicative estimates and explain significant changes from the previous version.

Information to Share Includes:

• Product name, strength and dosage form.
• Required presentation.
• Pack configuration.
• Monthly forecast quantities.
• Confirmed order quantities.
• Required availability dates.
• Planning horizon.
• Forecast revision date.
• Remaining shelf-life requirements.
• Storage and transport conditions.
• Destination and receiving arrangements.
• Required documentation.

Confirm which details Zircon Medtech can provide and which require input from the Brazilian importer, logistics provider or other partners.

Discuss product availability, order lead times and shipment arrangements before making purchasing commitments.

Turning Demand Estimates Into a Practical Supply Plan

Oncology medicine supply from India to Brazil benefits from a consistent process for reviewing changing requirements.

Define the products, validate historical information, document assumptions and compare demand with usable inventory and incoming supply.

A rolling demand forecast helps the parties communicate future needs, identify potential gaps and review purchasing decisions as new information becomes available.