DATA ANALYTICS EXAMPLES

Challenges | Solutions | Results

Maintenance cost minimization via linear programming

Challenges

Linear programming model for workers’ schedule in order to minimize costs

Factors to be considered: workers’ skillset and level, deadlines, penalties, travelling time, internal and external worker cost

Processing a whole year’s data takes too much time and memory

Solution

  • MILP model in Python using CPLEX solver
  • The parameters and objective are based on the mathematical equivalent of the real-life rules, constraints and expectations
  • Geographically separated dataset allows reasonable runtime

Results

Optimal balance between internal and external operator employment.
Labor and travel cost minimization, lead time reduction.