Introduction

In the highly competitive world of automobiles today, operational flexibility and data-driven decision-making are the pillars of long-term success. This case study showcases how Production Modeling India (PMI) worked with one of the world's most recognized industrial conglomerates to transform their Value Stream Mapping (VSM) process—by bringing in real-time information and visual analytics to enable effective forward-looking planning and performance improvement in their automotive components manufacturing plants.

About the Client

The client is an industrial behemoth with a diversified portfolio of businesses under Automotive Technology, Industrial Solutions, Elevator Technology, Materials Services, and Steel Europe. Under its Automotive Technology business segment, one of its most critical business segments, undertakes production of mission-critical components such as camshafts, crankshafts, and steering columns. They send these advanced components globally to leading auto and machinery manufacturers, an indication of the engineering capability of the client, along with manufacturing scale. Although it has a solid market footing, the client realized that it needed to upgrade its internal process tracking instruments. It no longer had a sufficient use for traditional Value Stream Maps (VSMs) in light of mounting production complexity and dynamic operational requirements.

Objectives of the Engagement

The main objectives of the project were definite and proactive:

Aligning Value Stream Mapping (VSM) with Real-time Data for Manufacturing Excellence in Automotive Industry

Problems Encountered by the Client

Though the client already had VSMs, they were static in nature and not adaptive enough to adapt to evolving conditions. The major problems encountered were:

• Difficulty in ascertaining the precise flow of 13 various products through manufacturing stages.
• Limited ability to use existing VSMs to drive lead time reduction initiatives.
• Inadequate support for WIP optimization due to manual data tracking.
• Outdated VSMs with non-interactive symbols and unlinked data sources.
• The need for durable VSMs that could adapt to evolving databases without requiring complete redesigns.

These challenges impacted both planning accuracy and execution efficiency, calling for a solution that combined Lean principles with real-time data integration.

Technical Analysis and Key Observations

PMI’s static analysis phase involved summarizing robotic timing data and translating it into event-based activity cycle times. Machine utilization levels were calculated by factoring in changeovers, maintenance, and forced delays. The analysis revealed that while the facility could achieve the required throughput, certain stations operated near capacity limits.

1. Data Collection

PMI started by downloading related data sets from the client's cloud storage server. The data sets covered production cycles, stock levels, process streams, and past product information. Interactivity was maintained with the client's in-house team in order to grasp the subtleties of each process and product.

2. Estimation & Data Analysis

Having the data in place, PMI engineers evaluated the existing VSMs on usability, precision, and connectivity of data. The steps involved:

• Revamping VSMs to match the new plant layout and operating flows.

• Developing 13 separate product-wise VSMs in Microsoft Visio, with real-time production values reflected.

• Removing old symbols and legends and substituting them with dynamic visuals.

• Adding macros to enable auto-extraction of data and create dynamic behavior within the VSMs.

• Making the VSMs filterable by date, so users can observe changes in flows through time.

• Identifying Value-Added (VA), Non-Value-Added (NVA), and critical WIP points.

The use of macros enabled live data to auto-populate VSMs, reducing the need for manual intervention and ensuring decisions were made based on up-to-date performance.

3. Results & Conclusion

Embedding real-time data within VSMs had a dramatic impact on visibility and responsiveness:

Improved VSM Usability: Through updated symbols and dynamic dashboards, the VSMs were no longer static diagrams but dynamic management tools.

Real-Time Process Mapping: Production flow, inventory, and lead times were instantly visible, making it easier to respond to issues quickly.

WIP Optimization: In-flight monitoring allowed for proactive WIP level management, avoiding bottlenecks and lowering idle inventory.

Better Decision-Making: Supervisors and planners could now trust VSM dashboards for better planning and shift allocation.

Foundation for Continuous Improvement: The system created a basis for continued Lean efforts, facilitating kaizen activities and process reengineering.

By correlating 13 product lines with actual time production data, the customer not only achieved more control over manufacturing operations but also established a foundation for more intelligent, more rapid, and more agile production systems.

Aligning Value Stream Mapping (VSM) with Real-time Data for Manufacturing Excellence in Automotive Industry

Conclusion

This project was able to effectively turn the Value Stream Mapping ability of the client from a passive documentation tool into an active performance management system. The use of live data and automation through macros enabled the client to eliminate lead times, streamline operations, and control WIP appropriately.

In an industry driven by precision and speed, this project stands as a model for how manufacturing organizations can align traditional Lean tools with digital transformation to unlock higher levels of efficiency, responsiveness, and competitiveness. PMI’s structured approach and technical proficiency delivered a solution that was not only innovative but also practical and scalable, aligning with the client’s broader vision for manufacturing excellence.

    Download Our Company Brochure