Excel Development for Automotive Manufacturing | Excel Help
Your Programming and Traning Professionals

Automotive Manufacturing Case Study

Process automation that includes shipments, production, transfers, inventory management and other important processes.

“Thanks a million. This [application] is a life saver!”
-Mitchell B., Engineering Group, Brembo


Application Type:

Inventory & Schedule Reporting Tool

A Company Snapshot:

Brembo is a world leader and innovator in the field of automotive disc brake technology. The company supplies high performance braking systems and components for cars, motorbikes, industrial vehicles and machinery.

Their Needs:

As a result of the complex and detailed nature of their business, Brembo hired ESW to create a comprehensive Microsoft Excel & Access database reporting application and to enhance their existing Paint Schedule tool. The inefficiencies within their previous systems led to an opportunity to make improvements to Brembo’s internal business processes and workflows.

The Solution:

ESW developed a Microsoft Excel & Access cost database reporting tool that generates custom reports and utilizes parameter tables to map several lines of data, and also contains a link to the production database to automatically pull in required information. In addition to creating a reporting tool, modifications to Brembo’s Paint Schedule tool were made by developing advanced formulas and macros to predict future production and inventory levels, as well as optimizing performance throughout the tool.

Key Client Benefits:

Brembo can now to use these tools to create reports based on production data and even forecast inventory, ultimately eliminating manual work through automation. ESW’s solutions were tailored to fit the unique needs of their business. The advanced updates allow Brembo to work faster and more efficiently, which saves them time and money.


Contact Us for More Information

Fill out our contact form or call us right now at to find out more about our Insurance related services. Whether you need Excel data related Analysis or Excel / Microsoft VBA programming, we will save you time and money.