You are leaving our main website to go to our chinese website hosted in China. For legal reasons there will not be any links pointing back to the main website.

Go to chinese website
Logo - Keyrus
Logo - Keyrus
  • Playbook
  • Services
  • Insights
  • Partners
  • Careers
  • About us
    Company purpose
    Innovation & Technologies
    Committed Keyrus
    Regulatory compliance
    Investors
    Management team
    Brands
    Locations

Success story

A centralized platform for demand, scenario, gross margin, and sales & operations planning

By Timothy Kirby

Background

Our client is a globally recognized pharmaceutical company that provides solutions to meet patient medical needs around the world. As a research-based company in an increasingly fast-paced industry, our client needs precise calculation and connection to unify all aspects of the business. 

Typically, planning for demand across multiple real-world scenarios is a time consuming, labor intensive process that can leave less time for meaningful data investigation. Our client sought not only to substantially shorten the time needed for this extensive financial planning, but to also unlock a new level of understanding on the implications to downstream processes within the organization. 

Challenge

Prior to our implementation of Anaplan, establishing a financial plan for an organization valued at over 8 billion USD across 20 countries required over 200 different Excel documents, each with different versions of data, users, and process application. While the business methodology and Excel logic in place was sound, financial forecasts frequently erred by substantial amounts purely due to the disconnectedness in the planning process. 

At a global level, the need to forecast financial data, integrate demand and gross margin planning. and then connect this data to downstream processes such as Gross-to-Net planning quickly became a messy, time consuming process that required hours of manual work. Our client also struggled to connect their financial data to key functional areas such as sales and operations planning.

Solution

Anaplan is a cloud-based planning tool that offered exactly what our client needed – a connected planning solution that cleaned out the messy middle. Its ability to integrate with both upstream and downstream systems while also enabling real-time calculation through its patented hyper block technology is at the core of connecting people, systems, and data to generate useful insights for its users. 

Keyrus leveraged the power of this tool to consolidate data across the organization, which established a centralized platform for both demand and gross margin planning as well as sales and operation planning. This allowed for more easily digestible data and made it readily available to all parties within the organization, from executives down to business analysts. This centralized platform also meant capable and applicable connection across processes, connecting key areas of the business such as demand planning with account reconciliation. 

With the most accurate and up to date data, our client utilized a statistical methodology-based approach to calculate revenue forecasts automatically and allow for adjustments as needed. Additionally, our client can now model revenue forecasts around simulated market events and scenarios to leverage multiple “what-if” financial analyses. 

On the sales & operations side, we established a method to automatically generate customized reports including but not limited to supply plan metrics, supply versus actual and forecasted demand, and inventory analysis. 

Results

After partnering with Keyrus and leveraging the power of Anaplan, our client has a unified platform for demand and gross margin planning, account reconciliation, and S&OP. The platform allows users to easily review calculated contract rebates on past sales and accurately forecast future rebates. 

Additionally, our client now has the capability to perform “what-if” scenario analysis, comparing multiple versions across simulated market events that, if not modeled, would render planning forecasts obsolete. By integrating sales and operations planning to automatically intake readily available data from demand planning forecasts, S&OP reporting is streamlined with real-time data, which further facilitates a connection between demand, manufacturing, and inventory analysis. 

The burden of manual work has been significantly eased and replaced with a dynamic end user experience through intuitive dashboards, creating a space for developing meaningful data insights. Through integration, attention to detail, and empowering the users behind the data, we achieved a solution that cleaned and energized the planning process.

whatsapptwitter
linkedinfacebookworkplace
newsletter.svg

Never miss an insight

Stay updated on the latest articles, events, and more

Your email address is only used to send you the Keyrus newsletter and for commercial prospecting purposes. You can use the link in our emails to opt-out at any time. Learn more about the management of your data and your rights.

Continue reading

Press release

Keyrus named amongst Top B2B Companies on Clutch

December 12, 2022

The Keyrus team is excited to announce that we’ve been named one of the top 1000 companies on Clutch’s platform in 2022! This is the second year that Keyrus has been recognized by Clutch as a top company and B2B leader. 

Webinar

PDF Parsing with Alteryx Intelligence Suite

December 1, 2022

In 20 minutes, we’ll teach you how to use Alteryx Intelligence Suite to eliminate common problems and inefficiencies in accessing data from .pdf files. In the past, you’d need to run custom Python and complex parsing logic to get any usable data from a pdf. Now, you can parse PDFs with out-of-the-box features in Alteryx Intelligence Suite.

Webinar

Modern Cloud Analytics in Action: Keyrus and Red Ventures

November 11, 2022

The cloud offers new opportunities to save you time and money, allowing you to shift focus from maintaining growing servers and upgrading infrastructure to making your data work for you and the success of your business. Watch the webinar and Q&A to learn how AWS, Tableau, and Keyrus worked together to help Red Ventures migrate to a powerful cloud BI tool that created new pathways for success and a modern data culture.

Event

Pharma/Biotech GTN Summit 2022

October 27, 2022

Keyrus & Anaplan Sponsor Life Science Gross-to-Net (GTN) Summit

Press release

Keyrus Achieves AWS Data and Analytics Competency Status

October 6, 2022

Keyrus achieved Amazon Web Services (AWS) Data and Analytics Competency. To receive the designation, AWS Partners must possess deep AWS expertise and deliver solutions seamlessly on AWS.

Webinar

Live Webinar: Lessons on workforce capacity planning and optimization from Optum (UnitedHealthcare)

October 19, 2022

Wednesday, November 9th, 2022 @ 12:00PM Central Time (US and Canada)

Webinar

Tableau Embedded Analytics: Optimizing insights from Salesforce data

September 20, 2022

Want to optimize your visual analytics in Salesforce? You need the right tools. Tableau Embedded Analytics can be used to help you build and visualize reports in Salesforce.

Success story

How C&S Wholesale Grocers maximized ROI with an analytics center of excellence

September 7, 2022

C&S Wholesale Grocers worked with Keyrus and Alteryx to implement an analytics center of excellence to help them efficiently and effectively achieve business objectives, maximize return on investment (ROI), and standardize best practices.

Success story

Implementing a cloud security automation tool at a global consulting firm

September 2, 2022

Keyrus partnered with a consulting firm to build an in-house cloud security solution that would automate their verification processes and keep their information safe.

Success story

Leveraging Salesforce to improve operations at Pajama Program

July 25, 2022

Keyrus partnered with Pajama Program, a nonprofit organization, to review their Salesforce architecture and improve overall operations.

Logo - Keyrus
New York City

252 West 37th st., Suite 1400 New York, NY 10018

Phone:+1 646 664 4872

LinkedInInstagram
PlaybookServicesInsightsPartnersCareersAbout us
Company purposeInnovation & TechnologiesCommitted KeyrusRegulatory complianceInvestorsManagement teamBrandsLocations
Legal notice & Terms of use
Privacy policy
Data protection