“Thanks a million. This [application] is a life saver!”
-Mitchell B., Engineering Group, Brembo
Inventory & Schedule Reporting Tool
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.
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.
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.
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.
Fill out our contact form or call us right now at to find out more about our automotive manufacturing related services. Whether you need Excel data related Analysis or Excel / Microsoft VBA programming, we will save you time and money.