Johnson & Johnson: gross-to-net forecasting and reconciliation

Case study · Healthcare

Johnson & Johnson deployed the RoadMap GPS Suite to unify class-of-trade demand forecasting with Gross-to-Net financial reconciliation, closing the gap between supply chain planning and net revenue realization across its complex healthcare portfolio.

The challenge

Johnson & Johnson operates in a healthcare ecosystem that spans retail, hospital, specialty, government, and wholesale channels. Each channel carries distinct contract pricing, chargeback structures, and rebate accrual requirements. High-volume SKU portfolios with long product life cycles and patent cliffs compound the forecasting difficulty.

Demand forecasts were not tightly integrated with GTN financial reconciliation, creating misalignment between supply chain and finance. Forecasts lacked precision at the trade channel level, so rebate accruals, chargebacks, and contract adjustments created persistent variance between gross sales projections and net revenue realization. Inaccurate trade-level forecasting led to inventory imbalance, working capital inefficiencies, and earnings variability.

The solution

We implemented the RoadMap GPS advanced statistical forecasting and demand planning platform to unify operational and financial planning. Best-of-breed statistical modeling generated forecasts at granular trade-channel levels, incorporating seasonal, trend, and lifecycle patterns along with promotion and contract impact adjustments.

GTN modeling was embedded directly into the forecasting workflow: automated rebate and chargeback accrual modeling, contract price variance analysis, and net revenue projections tied directly to demand forecasts. This created a closed-loop planning process where demand forecast fed revenue forecast, which fed net revenue reconciliation and executive visibility in real time.

• Advanced statistical forecasting by class of trade: retail, hospital, specialty, government
• Baseline and promotional uplift separation at channel level
• Integrated Gross-to-Net accrual modeling (rebates, chargebacks, contract variances)
• Forecast Value Added analysis and override discipline tracking
• Executive KPI dashboards unifying supply chain and financial performance
• Scenario modeling and sensitivity analysis

Results

• Improved trade-level forecast accuracy with reduced bias across major channels
• Reduced GTN leakage through improved accrual forecasting and reconciliation discipline
• More accurate demand signals improved production planning and inventory positioning
• Finance gained full transparency into forecast assumptions
• Supply chain gained visibility into net revenue impact of planning decisions
• Commercial teams aligned on trade-specific performance metrics
• Executive leadership received a single source of truth across forecasting, demand planning, and financial performance
• Improved long-term forecast reliability through FVA analysis and override governance

Key takeaways

• Forecast accuracy at the aggregate level masks trade-channel problems. Class-of-trade granularity is required to manage chargeback and rebate risk.
• GTN reconciliation belongs inside the forecasting workflow, not downstream of it. Connecting accrual modeling to demand forecasts closes the gap between commercial intent and financial outcome.
• When supply chain and finance share a forecast, override discipline improves. Visibility into FVA and net revenue impact changes how planners make adjustments.
• For global healthcare companies, forecasting is a financial control function as much as a supply chain function.