Supply Chain Planning Analytics Empowers Planners to Make Efficient Planning Decisions

 

Established in 1997, the client is a world leader in developing and commercializing first-or-best-in-class therapies for rare genetic diseases. Headquartered in California, US, the client has operations spread across 20+ countries and has 2500+ employees worldwide.  

 

Background

The client had implemented analytics solutions that provided visibility into actual and historical data on finance, supply chain, and purchasing business processes. However, these solutions did not provide visibility into supply chain planning data that Planners needed to: 

  • Perform what-if analysis
  • Obtain insights into the resulting impact of planning choices made by them, and
  • Execute the most optimal plan

 

Planners had to spend substantial manual effort to get up-to-date supply chain planning-related information for end-of-month reporting. They faced difficulty and delays in providing answers to common ad hoc questions to support management decisions, such as:  

  • What is the impact on available inventory (Months on Hand) if a planned replenishment is delayed by a month?
  • What is the impact on the replenishment plan if actual demand is x% more than forecast for one of the near-term periods?
  • What are the optimal parameters of the supply chain plan to keep the inventory positions within the prescribed range at all times?

 

Lastly, the supply chain planning process was being executed in reactive rather than proactive mode due to a lack of visibility into dynamic inventory positions and the unavailability of alerts based on real-time supply chain data. 

 

DiLytics partnered with the client to implement a solution based on Oracle APCC (Advanced Planning Command Center). This solution was implemented across the following phases: 

  • Phase I: Out-of-the-box Proof of Concept – APCC was installed, set up, configured and out-of-the-box data was loaded from Oracle Advanced Supply Chain Planning (ASCP), Demantra Demand Management, and Oracle E-Business Suite.
  • Phase II: Out-of-the-box Discovery and Requirements Gathering – capture business requirements for the use of Oracle APCC by the client’s supply chain planning function.
  • Phase III: Detailed design, development, and testing of Oracle APCC – implement and deploy the product based on business requirements gathered in Phase II.

 

The solution enabled the analytical insights in the following areas for the client: 

  • Inventory Overview
  • Safety Stock Vs. Projected Inventory
  • Inventory by Org
  • Inventory Balances – Item Status
  • Months on Hand (MOH) – Item Status
  • Months on Hand (MOH) – Overview
  • Production Plan – Overview
  • Production Plan – Fill
  • Production Plan – Fill Schedule
  • Production Plan – Pack/Label
  • Production Plan – Pack Schedule
  • Order Forecast
  • Plan Vs. Actual Ship Quantity
  • Plan Recommendations

Business Benefits

  • Ability to make efficient planning decisions based on visibility into the latest supply chain planning data
  • Agility in responding to changes in supply chain situations by Executives and Planners, with the enablement of alert triggering mechanisms
  • Enhanced focus by Planners on optimization of supply chain process, due to elimination of manual effort required to produce supply chain planning reports
  • Superior ability to identify opportunities for business process improvement, with Executives and Planners obtaining visibility into a variety of business areas

 

Technical Stack

  • Source Systems: Oracle ASCP (Advanced Supply Chain Planning), Demantra Demand Management, and Oracle EBS
  • Data Integration Tool: Informatica
  • Data Warehouse: Oracle Business Analytics Warehouse
  • Reporting Tool: Oracle Analytics

DiLytics Delivers

View all Success Stories →

Manufacturing Analytics

DiLytics implemented a Manufacturing Analytics solution for a Biotechnology Company in a short period of 100 days.

Custom Data Warehouse

DiLytics implemented a custom data warehouse solution for a Leading Container Leasing Company in a short span of 150 days.

Center of Excellence

DiLytics established a Business Intelligence Center of Excellence to help a Video Game and Digital Entertainment Company maximize RoI.