Intelligent optimization of lubricant mixtures

Problem

Our client, a lubricant manufacturer, required the production of each type of lubricant to mix multiple components in different proportions, generating different costs per gallon for the same final product. Before our intervention, this blend calculation and selection process was performed manually in Excel spreadsheets, which was time-consuming, error-prone, and impeded the rapid evaluation of all possible combinations to find the most economical option. This slowness hampered rapid decision-making and limited cost optimization.

Solution

We developed an intelligent web tool that automates the calculation of optimal blends, replacing the manual Excel process. The platform allows you to manage all components, their updated costs, and the allowable tolerance ranges for each formulation. Using optimization algorithms, the system identifies in seconds the most economical combination per gallon that meets quality standards. It also includes interactive graphics and automatic reports that facilitate cost analysis and savings tracking.

Benefits obtained

Significant reduction in cost per gallon by finding more economical blends without compromising quality.
Elimination of manual Excel processing, reducing errors and calculation times from hours to seconds.
Fast and reliable decision-making thanks to automated optimization.
Clear visualization of savings, trends, and scenarios through integrated graphs and reports.
Flexibility to adjust input prices and recalculate blends in real time.
Direct improvement in product profitability and production process efficiency.
Scalability to manage multiple products and production lines with different requirements.

​​Intelligent optimization of lubricant mixtures

​Problem

Solution​

​Benefits obtained

Intelligent optimization of lubricant mixtures

Problem

Solution

Benefits obtained