-
Excerpt from course description

Decision modelling using spreadsheet

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.
  • IIntroduction to Optimization and Linear Programming Models.
  • Modeling and solving LP Problems  and sensitivity analysis.
  • Network Models.
  • Optimization Models with Integer Variables.
  • Nonlinear Optimization Models.
  • Solution methods: Simplex and Evolutionary Solver.
  • Decision Making Under Uncertainty.
  • Introduction to Simulations.
  • Queueing Models.
  • Regression and Forecasting Models.
  • Multiobjective Decision Making.
  • Inventory and Supply Chain Models.

Disclaimer

This is an excerpt from the complete course description for the course. If you are an active student at BI, you can find the complete course descriptions with information on eg. learning goals, learning process, curriculum and exam at portal.bi.no. We reserve the right to make changes to this description.