ºÚÁÏרÇø

Introduction

The course combines consideration of realistic decision-making problems with theory and methodologies in building and solving spreadsheet models. Examples from finance, marketing, supply chain and other business areas illustrate management science applications and solutions methods using spreadsheet tools widely used in most of the organizations.

Course content

• Introduction to Spreadsheet Modeling.
• Introduction to Optimization and Linear Programming Models.
• Modeling and solving LP problems and sensitivity analysis.
• Network Models.
• Optimization Models with Integer Variables.
• Mixed-Integer Optimization 
• Solution methods: Simplex and Evolutionary Solver.
• Decision Making Under Uncertainty
• Introduction to Simulations
• Multiobjective Decision Making.
• Inventory and Supply Chain Models.