# EBA 3610 Decision Modelling Using Spreadsheet

## EBA 3610 Decision Modelling Using Spreadsheet

Course code:
EBA 3610
Department:
Accounting and Operations Management
Credits:
7.5
Course coordinator:
Atle Nordli
Erna Engebrethsen
Course name in Norwegian:
Product category:
Bachelor
Portfolio:
Bachelor of Data Science for Business - Programme Courses
Semester:
2021 Autumn
Active status:
Active
Level of study:
Bachelor
Teaching language:
English
Course type:
One semester
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.

Learning outcomes - Knowledge

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.
Learning outcomes - Skills

After completing the course, students shall be able to:

• Identify and apply modelling approach to solve decision problems.
• Model and solve LP Problems and sensitivity analysis.
• Model decisions under uncertainty.
General Competence

The students will learn how to analyze a decision problem, evaluate the data and how to select a modelling and solution approach.

Course content
• 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.
Teaching and learning activities

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.

Software tools
Software defined under the section "Teaching and learning activities".

There will be a re-sit examination in EBA 36101 autumn 2022 and last time spring 2023.

Qualifications

Higher Education Entrance Qualification

### Covid-19

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.

### Teaching

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.

Required prerequisite knowledge

EBA 2910 Mathematics for Business Analytics, EBA 2904 Statistics or equivalent courses.

Assessments
Assessments
Exam category:
Submission
Form of assessment:
Written submission
Invigilation
Weight:
100
Grouping:
Individual
Support materials:
• No support materials
Duration:
4 Hour(s)
Comment:
23/09/2022 Please note that re-sit examination autumn 2022 will be arranged as a home exam, 4 hours.
25/01/2023 The same applies for the re-sit spring 2023.
Exam code:
EBA 36101
ECTS
Resit:
Examination every semester
Type of Assessment:
Ordinary examination
Total weight:
100