Want to create a pdf of this page content to print or email? Click on icon.
Problem Statement
Data Inefficiency & Inconsistency: The manufacturing operations were heavily reliant on extracting reports from SAP to Excel, followed by further manipulations in complex workbooks. This process was not only prone to errors but also consumed a significant portion of key users’ time. As a result, these users spent an overly large portion of their day on data extractions, often performing the same manipulations as their colleagues. This redundancy led to a lack of productivity and created multiple versions of the truth, making it difficult to maintain data consistency and accuracy.
Incomplete Parts Data: A new plant being stabilized in a new geographic location faced severe challenges due to receiving issues and poorly configured lead-time master data. These problems resulted in critical material shortages on the shop floor, causing major rescheduling and last-minute retooling of the production line. The impact was further compounded by hefty penalties from expectant customers, highlighting the urgent need for better data management and operational efficiency.
Lack of Companywide Data Integration: The manufacturing operations also suffered from a lack of companywide data integration. Duplicate vendors existed in the system, and nationwide purchasing from branches and chains was difficult to report on due to poorly captured vendor master data. This lack of integration put enormous pressure on the purchasing department to achieve meaningful cost savings, as they struggled to obtain a clear and accurate view of the company’s purchasing activities. Addressing these challenges was crucial for improving overall operational efficiency and achieving strategic business goals.
Solution Overview
At the time, the client did not have a data warehouse in any shape or form, so the first iteration of a BI environment was modeled from direct table extracts from SAP. Every day more than 135 tables were extracted from SAP using RFC read table. Extraction filters were used where possible and delta loads were placed on tables that had timestamps or sequenced entries. During the pilot phase the selected extraction tool was Data360 Analyzer (Lavastorm), however the Qlik SAP Connector was used for actual production purposes.
The PFEP report was designed, built and produced in a short amount of time using Qlik. In order for the report to be flexible, color thresholds were coded into variables so that changing a variable lead to a rapid recalculation of the report.
To clean up vendor reporting, Pomerol modelled an application in such a way that the selection of a vendor resulted in seeing all purchase orders and invoices for a vendor. Invoices that were matched to an vendor were reported accordingly however the trick was to model open purchases orders alongside non-PO invoices. Additional logic was coded into the report to roll-up branch vendors and to group duplicate vendors under a single name so that analysis of vendor spend at a group level could be done.
Results and Impact
An end-to-end Business Intelligence (BI) reporting solution was implemented using SAP data in an agile methodology. This comprehensive Procurement and Spend application encompassed five years of procurement data, totaling 14 million records, which included invoices, payments, purchase orders, goods receipts, and vendor records. The introduction of the Plan for Every Part (PFEP) had an immediate and significant impact on the business, streamlining processes and enhancing efficiency. Additionally, by saving down the daily data, trending analysis was developed. This enabled stakeholders to identify emerging problems at both the buyer and material group levels, providing valuable insights for proactive decision-making and problem resolution.
The agile approach allowed for iterative development and continuous improvement, ensuring that the BI reporting solution remained aligned with business needs and objectives. The extensive dataset provided a robust foundation for detailed analysis and reporting, facilitating better procurement strategies and spend management. The PFEP initiative not only optimized inventory management but also improved supplier relationships and reduced costs. Overall, the combination of agile methodology, comprehensive data analysis, and strategic initiatives like PFEP contributed to a more responsive and efficient procurement process, driving significant business value.
Category:
Category: