EBA 3610 Decision modelling using spreadsheet
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.
During the course, students should have acquired:
- Basic knowledge in Spreadsheet Modeling.
- Basic knowledge of Optimization with Linear, as well as Nonlinear Programming Models.
- Basic knowledge in Queueing Models.
After completing the course, students shall be able to:
- Identify and apply modelling approach to solve decision problems.
- Use spreadsheets for various business applications.
- Model and solve LP Problems and sensitivity analysis.
- Model decisions under uncertainty.
The students will learn how to analyze a decision problem, evaluate the data and how to select a modelling and solution approach.
- 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.
The course will include/entail a combination of Lectures and exercises using Excel.
Students are expected to solve a number of spreadsheet exercises, which will be given after each lecture.
Due to the Covid-19 pandemic, there may be deviations in teaching and learning activities as well as exams, compared with what is described in this course description.
Information about what is taught on campus and other digital forms will be presented with the lecture plan before the start of the course each semester.
EBA 2910 Mathematics for Business Analytics, EBA 2904 Statistics or equivalent courses.
|Exam category||Weight||Invigilation||Duration||Support materials||Grouping||Comment exam|
Form of assessment:
Internal and external examiner
Examination every semester
|100||Yes||4 Hour(s)||Individual||Exam includes several tasks to be solved based on a spreadsheet|
|Form of assessment:||Written submission|
|Support materials:|| |
|Comment:||Exam includes several tasks to be solved based on a spreadsheet|
|Exam code:||EBA 36101|
|Resit:||Examination every semester|
Group work / Assignments
Student's own work with learning resources
A course of 1 ECTS credit corresponds to a workload of 26-30 hours. Therefore a course of 7,5 ECTS credit corresponds to a workload of at least 200 hours.