Mathematical Programming using OPL-CPLEX

Program Objective

Many Enterprises, irrespective of their size, are still resort to decision making using excel, at best, or gut feeling, at worst. Such decision making process not only takes long time to plan, but it also results in sub-optimal resource utilization, leading to higher expenses and capital requirement.

Decisions - such as "where to put the new plant?", "How much should be the capacity of different plants?", "What should be the production schedule?", "How much inventory should be held and where?", "How the orders can be delivered cost-effectively?" - can be made using scientifically proven models. Resorting to such decision making helps companies to reduce operational expenses and capital requirement.

Decision systems using such mathematical models help companies to plan and replan in minutes. Such agility helps companies to cope with, and profit from, dynamic business environment.

Program Benefits

The participants are exposed to, and gain working knowledge on:

  • How to analyse business decision making process.
  • Identify different drivers of business decisions
  • How to model such decision requirements into mathematical modelling.
  • How to convert such mathematical models into ILOG OPL Code.
  • How to debug and tune the models for performance
  • How to integrate the Optimization model in an IT Solution (DSS)
  • How to deal with model scalability issues

Who should attend

  • Project Managers
  • System Architects
  • Operations Research consultants
  • Business Analyst
  • OR Model Developers
  • Integration and test engineers

Workshop Agenda

Day 1


  • Introduction to Operations Research
  • Industry usage of OR applications
  • Mathematical Modelling
  • Different Types of Mathematical Modelling

Solving Problems Using Excel Solvers

  • Solving LP problems in Excel Solver
  • Solving LP Problems in CPLEX using Excel Plug in

CPLEX and OPL Studio

  • CPLEX Solver - An introduction
  • Exploring OPL Studio
  • Introduction to OPL
  • Creating an OPL Model, Solving and Accessing the solution

A Deeper Understanding of OPL

  • Exploring OPL Syntaxes
  • Understanding OPL Data Constructs
  • An introduction to sets, arrays, tuples, decision variables, constraints
  • Specifying data source, Accessing Excel, Databases etc
  • Usage of OPL Script

Day 2

Solving Problems Using CPLEX / OPL Studio

  • Linear Programming: Mathematical Formulation and OPL Modelling
  • Hands on Programming Session and Discussion

Solving Problems Using CPLEX / OPL Studio

  • Integer Programming: Mathematical Formulation and OPL Modelling
  • Binary Integer Programming: Mathematical Formulation and OPL Modelling

Concert Technology (with Java)

  • Accessing CPLEX solver from Java
  • Usage of Java Concert API
  • Sample Problems using Java
  • Introduction to other programming languages APIs

Advanced Concepts

  • Exploring sparsity using tuples
  • Solving a Linear Programming problem using tuples

Teaching Methodology

The programme is delivered using formal lectures combined with practical and interactive case studies and exercises to reinforce concepts covered in each session. The use of ILOG OPL Studio will be emphasised from the start. It will be assumed that delegates have a basic working knowledge of Excel, operations research (LP & IP fundamentals), and programming language (C / Java). Emphasis is placed on delegates gaining practical, hands-on experience of the design and construction of optimization models using ILOG OPL Studio.

Ways to Train

  • Class Room
  • Virtual Class Room
  • On-Site Team Training

Faculty details

Bala. Padmakumar, PGPEX (Ex-MBA), IIM, Calcutta

Bala has over 28 years of industry experience working in various industries - Manufacturing, Telecom, Finance, and Consulting; handled various functions - Product development, Project Management, Operations and Quality, Business setup and Growth, Training and Business Consulting, working for C-DOT (Govt. of India), Wipro, Lucent Technologies (USA), and Bank of New York Mellon; and in different countries - India, USA, UK, and Israel.

Bala has deep knowledge in international economics, investment science, risk analytics, and operations research. While working for Lucent Technologies, USA, Bala has been awarded with a US patent for coming up with power control algorithm for wireless networks.

Currently, Bala and his team are engaged in optimization model research and development, solution development using such model in the areas of Production Planning / Logistics / Supply Chain / Transportation optimization, and Financial Risk Analytics and Management. Bala is working closely with their clients in helping them reduce operating cost and gain competitive advantage.

Dr. Ram, PhD (IISc)

Prof. Ram having more than 10 years of experience in teaching Operations Research, Operations Management, and Supply Chain Management for one of the leading business schools in Chennai. In addition, Prof. Ram is an advisor to OptiRisk, and actively involved in optimization model research and consulting. Prof. Ram has a PhD in the field of Operations Research from Indian Institute of Science (IISc). Prof. Ram is a Certified Supply Chain Professional (CSCP) by APICS, USA.


Location Date
Chennai 06-07-2018
Bangalore 13-07-2018
Mumbai 20-07-2018
Delhi 27-07-2018


The workshop fee is Rs. 45,000 (Forty Five thousand only) + appicable taxes.

More Resources

Request Callback

Sales Order Management

Delivery Planning and Management

Collection Management System

12V DC Wireless Dot Matrix Printer

Transportation Optimization

Packing Optimization

Production Planning and Scheduling

Inventory Management

Supply Chain Network Design

Portfolio Optimization

Engineering R&D


Staff Augmentation

About Us




Contact Us