EPM Platform Implementation

Implementation of a purpose-built solution for Gross-to-Net in Anaplan, a leading Enterprise Performance Management platform

Enteprise Performance Management Gross-to-Net. Anaplan GTN solution contract, channel, demand forecasting and liability analysis

In Brief

Our client was seeking to move away from Excel and establish a capability supporting current and future channel forecasting needs that aligned with their processes, with a high degree of flexibility and scalability.

How We Helped

  • Led a POC to prove the platform capable​​

  • Served as the program lead for the full implementation​​

  • Provided GTN subject matter expertise and a deep understanding of our client's processes

  • Served as an extension of manufacturer team, acting as an advocate, process expert, data expert, and supplemental model builder

  • Developed interfaces for actuals from Model N Flex

Situation

Our client's GTN forecasting processes were managed completely in Excel. Every quarter, users would:

  • Gather demand forecast (separate files)

  • Gather WAC price forecast by brand (separate files)

  • Collect actual transactions (millions of lines)

  • Load data to Excel

  • Review actuals, update projections by contract

  • Consolidate results

  • Prepare summary presentations

  • Provide data to downstream processes (e.g., Finance)

This process involved 68 separate workbooks, 1,127 worksheets and more than 5,000 manual interventions performed per forecast across all workbooks, leaving them exposed to multiple risks:

  • Limited visibility to the effects of pricing actions (price protection penalties, Medicaid liability implications, PHS price changes, ASP-based reimbursement impacts, etc.)

  • Long turnaround times for what-if analyses

  • Excel scalability, integration and reporting constraints

  • High risk of manual error

  • Lack of visibility to previous data overrides and assumptions

Proving out the Platform

After determining that package-based solutions were neither viable nor market-proven, the manufacturer decided to build the GTN capability on Anaplan. Since Anaplan was a new platform for the company, the team executed a Proof-of-Concept that was meant to confirm Anaplan's ability to model complex contract structures (including Price Protection), model impacts to Medicaid liability, and consume transactional data. Specifically, the POC was scoped around:

  • Price Protection calculations for the big PBMs

  • URA calculations 

  • 12-months of actuals for 1 brand, 3 contracts

In addition to proving out the platform, the POC work highlighted important change management elements to be addressed during implementation.

Implementation Phase

After the successful POC, Pharosity led the full implementation of Anaplan to build the manufacturer’s GTN forecasting capability. The primary objectives of the project included:

  • Eliminate Excel while maintaining flexibility and improving forecasting precision

  • Increase efficiency, reduce turnaround times and improve scalability

  • Prevent disruption to upstream and downstream activities

The project was a partnership between:

  • Manufacturer

  • Pharosity Consulting

  • Third-party Anaplan development group

The effort was conducted over a 16-week timeline and achieved the following:

  • Bottom-up model across all contracts and terms, by brand

  • Clear visibility to the impacts of pricing actions, adjusted contract terms, new strategies (rebates, price protection, fees, URA, PHS, etc.)

  • Forecast and scenario turnaround time reduced from weeks to days

  • Fully integrated load of actuals from Model N Flex

  • No disruption to upstream or downstream partner interactions

The Pharosity Consulting team served as the overall program lead and filled several key roles on the project:

  • Defined overall solution architecture across GTN policies, processes and methodologies

  • Served as an extension of manufacturer team, acting as an advocate, process expert, data expert, and supplemental model builder

  • Acted as overall program management lead and facilitated relationship between manufacturer and third-party implementation partner

  • Served as test lead, developed test strategy and plans, facilitated execution of system test and UAT phases while providing issue resolution support

  • Developed interfaces for actuals from Model N Flex

If you'd like to learn more about how Pharosity Consulting can help you decide if an EPM platform is right for your GTN processes; or if you are looking to implement EPM as your solution, please get in touch. We're always willing to share and look for ways to collaborate.

  • LinkedIn

© 2020 by Pharosity Consulting Inc

8 Atkinson Dr. #118

Doylestown, PA 18901

 

Mail: info@pharosity.com