Case Study · Industrial Software

Optimization of lubricant blends

A smart web platform replaced the Excel spreadsheets where technicians manually calculated each blend. Now the system suggests the optimal formula in seconds.

Sector

Industrial Lubricants

Duration

10 weeks

Line

Alltime Design

Status

In operation

Optimization of lubricant blends

The Challenge

The technical team calculated each lubricant blend in an Excel spreadsheet shared via email. Each technician had their own version, additive prices were outdated, and a formula error meant wasting an entire batch. The process took 45-60 minutes per new blend.

Our Solution

  • Centralized database: a single catalog of base oils, additives, and suppliers with daily updated prices.
  • Calculation engine: you input the desired technical specifications, and the system suggests optimal combinations along with cost per gallon.
  • Blend history: each formula is logged with who created it, when, and the final cost.
  • Digital approvals: supervisors approve with a single click from their mobile phones, without printing anything.

Measurable Results

22%

Cost reduction

Per blend, thanks to optimized suggestions rather than legacy formulas.

5 min

Time per blend

Formerly 45-60 min. Now the technician decides, the system calculates.

100%

Traceability

Each batch has its formula, author, and cost recorded. Immediate audit.

"We eliminated the emailed Excel. Now everyone calculates using the same prices and the same logic."

Other Case Studies

Does your team still live in Excel?

Let's talk on WhatsApp