Profile

e-Catalog

Contact

Search

Cart

Quantitative Management: Integer Linear Programming

Audience

Analysts and business decision makers seeking competency in the area of quantitative management

Prerequisites

A general understanding of information systems and management principles, along with a grounding in calculus and algebra

Course Aim

This course aims to show how to construct linear programming models with general integer, binary, and mixed decision variables to solve a range of optimization problems

Learning Objectives

Understand the advantages of using both general and integer linear programming models. Formulate integer linear programming models in LINDO. Formulate integer linear programming spreadsheet models. Model logical conditions using binary variables. Formulate binary integer programming models for optimization problems with dependent decisions. Interpret the LINDO and spreadsheet solutions to optimization problems with dependent decisions. Formulate integer programming models for fixed costs problems. Formulate spreadsheet models for fixed costs problems. Interpret the LINDO and spreadsheet solutions to fixed costs problems. Formulate mixed integer linear programming models. Prepare spreadsheet formulations for mixed integer linear programming.

Topics Covered

General Integer Linear Programming - Introducing integer linear programming - LINDO general integer LP solution - Spreadsheet general integer LP solution Binary Integer Programming - LINDO formulation - Spreadsheet formulation - Solutions and interpretation Dependent Decisions - Logical conditions - LINDO and spreadsheet formulation - Solutions and interpretation Fixed Cost - LINDO formulation - Spreadsheet formulation - Solutions and interpretation Hands-on: Mixed Integer Programming - LINDO formulation - Spreadsheet formulation - Solutions and interpretation