Reinventing Supply Chain Analytics For A Global Pharma Giant
Overview
The global pharmaceutical giant offers a wide range of products and services across geographies. This spread brings in a lot of consistent business but exposes decision makers to the monumental task of managing a complex network of distribution centres & vendors – along with inefficient processes at each level. At the same time, the process was prone to human error and turn-around time for reporting was longer than expected.
With a view to completing the digital transformation of the entire enterprise, eliminating inadequate practices and fuelling innovation led by dynamic supply chain planning and analytics, the global pharma giant implemented were evaluating a platform and seeking a partner who could help them eliminate incongruities, modernize the key pillars of their SCM gamut – as in, inventory planning, spend analytics and vendor analytics – each of which was to underpin their emerging business requirements. Analytics Depot Solutions partnered with the key customer’s stakeholders and implemented the overall solution by leveraging Qlik, NPrinting, Power BI (backed with a DWH), which helped in removing all the hassles through automatic calculations & revisions, suggesting scenarios to course correct. The implemented solution acts as a single version of truth for supply chain data, analytics and report – which, in turn, enables data-driven decision making
Key Challenges
The global pharmaceutical giant offers a wide range of products and services across geographies. This spread brings in a lot of consistent business but exposes decision makers to the monumental task of managing a complex network of distribution centres & vendors – along with inefficient processes at each level. Here is how the key challenges can be summarized:
Key Challenges
Lack of single version of truth for supply chain data and related analytics
Transactional records being maintained with the individual distribution centres across
Budget-vs-actual spend analytics was largely gut-based with no true data backing
Lack of planning system causing slow turnaround of inventory insights
Unproductive data collation activities cause and prolonged variance and actuals analysis, leading to slow decision making
A lacuna in real-time inventory and spend reporting and relevant deriving business insights
Siloed decision making
Manual process depending upon spreadsheets and prone to human-error
Inconsistent approach to data cleaning and transformation
Poor master data management
Solution Implementation
The SCM team needed to keep the nature of inventory and spend management dynamic due to the very nature of the business. But, at the same time, this called for going back & forth multiple times, and consequently, adding up to the complexities and furthering the chances of human-errors. Consequently Analytics Depot Solutions partnered with the key stakeholders to help them traverse their journey of modernization SCM data consolidation, analytics and reporting. Analytics Depot Solutions Team engaged with the SCM team who were primarily mandated with the responsibility of keeping track of the payments and spending on raw materials, packing materials and transportations. They were also required to keep track of inventory and inventory shortage. The team worked in collaboration with the customer’s team and conducted extensive requirements gathering phases in order to understand and also brainstorm various aspects of SCM reporting & analytics needs such as – data sources, integrations, data quality needs, analytics needs, reporting needs, etc.
The contemporary processes at the SCM department were largely dependent on manual extraction of reports from different data sources for the preparation of excel based periodic review/tracker reports. SAP and Excel will be two major Data Sources. SAP for extracting SAP related data and Excels to extract Budget/Plan related data, wherein MM, QM, FI, and PP were the major modules.
The overall Discovery Methodology was 5-pronged and included:
- 1. Interview of the Stakeholders
- 2. Understand the requirements and business needs
- 3. Study of the Excel MIS reports
- 4. Segregating the key metrics
- 5. Understanding the data stored at various sources
Given the insights from the Discovery phase, and with an objective to eliminate all the key challenges, Analytics Depot Solutions commenced with the implementation of an enterprise-wide analytics and reporting platform based on Qlik, NPrinting, Power BI and the backend DWH.
Leveraging these modern technologies helped in modernizing the way below modules (& sub-modules) used to function and bring in unprecedented advantages:
Inventory planning
Value analysis,
Inventory NODs,
Shortage, ageing and shelf life analysis
Spend Analytics to highlight budgeted vs actual spend
Vendor Analytics, to enable vendor evaluation in terms of quality, cost and delivery
Specifically around Inventory management, Analytics Depot Solutions Team collaborated with the key business stakeholders to established a platform enables toe complete horizon of inventory management & analytics, which included:
Inventory Demand Forecast – involves using historical inventory consumption data to predict future consumption rates
Economic Order Quality – to enable calculation of the level inventory to be maintained
Safety Stock Calculations – which determines the level of stock required to minimize stocks
Re-order Triggers – enables stock management team to determine the ideal re-order time for stock
Inventory Ageing – age categorization of inventory to reduce old / obsolete stock
The implementation team built a roadmap of establishing a set of KPIs that would act as the guiding force into the decision making process. Outlined below a few of them, among others:
Key Challenges
DIO monitoring Inventory volume/value consumption rates
Safety Stock Volume Recommended stock level Economic Order Quality
Inventory Volume/Value per Age Bucket Inventory Volume/Value per Category
Forecast Inventory Demand vs Actual Demand Forecast Error
Resulted Benefits
- Shift from manual work to an automated environment for reporting
- An Established single-version-of-truth
- One place to govern data (no duplication of effort and data)
- Faster turnaround time for the real-time reporting
- Data-driven decision making
- Consistent approach to data cleansing, formatting, validation and transformation
- Single platform for all business stakeholders – right from the company board to the individual distribution centers
- Faster, efficient and scenario decision-making enabling prescriptions of the best-next-move
- Transparency and accuracy infused across various levels with rightly implemented Master Data Management
Business Outcomes
Improve predictability of future consumption rates
Cost control by substantial optimization of ordering and holding expenses
Lowered stock-out events with proactive safety stock recommendations
Highly efficient management of obsolete stock
Effective and efficient inventory analysis and procurement planning
Easy and hassle-free analysis of vendor performance based on product quality, delivery and cost efficiency
Faster response to fluctuating business data points and logics such as – prices, customer-mix, workers’ compensation, fuel costs, etc
Empowering users with self-service BI without letting them worry about data sanctity and sources