English   Danish

2017/2018  KAN-CCMVV4100U  Applying Excel Models in Operations Management

English Title
Applying Excel Models in Operations Management

Course information

Language English
Course ECTS 7.5 ECTS
Type Elective
Level Full Degree Master
Duration One Quarter
Start time of the course Second Quarter
Timetable Course schedule will be posted at calendar.cbs.dk
Max. participants 75
Study board
Study Board for MSc in Economics and Business Administration
Course coordinator
  • Leonardo Santiago - Department of Operations Management (OM)
Please find contact information for Student Hub, student Guidiance Services etc. on My.cbs.dk
Main academic disciplines
  • Management
  • Statistics and quantitative methods
  • Supply chain management and logistics
Last updated on 03-10-2017

Relevant links

Learning objectives
To achieve the grade 12, students should meet the following learning objectives with no or only minor mistakes or errors: The course introduces students to a variety of techniques used in the modelling environment to support the decision analysis process and assess alternative courses of action. For the analysis and evaluation of decisions alternatives the models are implemented in Excel spreadsheets.
At the exam, the student should be able to identify and implement the right model for solving problems similar to the ones dealt with during the course and discuss the possible approaches and solutions. Specifically the student has to:
  • Display a high level of command of the topics presented in the course by outlining the important issues and choosing the appropriate model in relation to the problem under consideration
  • Solve the models and analyse the solutions
  • Evaluate possible alternative solutions for the problem under consideration and argue for the selection of the model that is better suited to solve the problem
  • Identify the weaknesses and limits of their approach
Course prerequisites
To follow the course with proficiency it is suggested to have basic knowledge of linear programming and statistics. However the fundamentals of the methodologies will be provided shortly along the course.

Note that it is not possible to write term paper in this course.
Applying Excel Models in Operations Management:
Exam ECTS 7,5
Examination form Written sit-in exam on CBS' computers
Individual or group exam Individual exam
Assignment type Written assignment
Duration 4 hours
Grading scale 7-step scale
Examiner(s) One internal examiner
Exam period Winter
Aids Limited aids, see the list below:
The student is allowed to bring
  • Non-programmable, financial calculators: HP10bll+ or Texas BA II Plus
  • Language dictionaries in paper format
The student will have access to
  • Advanced IT application package
At all written sit-in exams the student has access to the basic IT application package (Microsoft Office (minus Excel), digital pen and paper, 7-zip file manager, Adobe Acrobat, Texlive, VLC player, Windows Media Player). PLEASE NOTE: Students are not allowed to communicate with others during the exam : Read more about exam aids and IT application packages here
Make-up exam/re-exam
Same examination form as the ordinary exam
If the number of registered candidates for the make-up examination/re-take examination warrants that it may most appropriately be held as an oral examination, the programme office will inform the students that the make-up examination/re-take examination will be held as an oral examination instead.
Description of the exam procedure

The exam consists of a number of exercises which need to be discussed and then solved using excel. Exercises solved along the course constitute the primary base for exam preparation.

Hand in on DE, Digital Exam forum - Excel File.

Course content and structure

The course takes a structured view of operations management decision-making. Different models for various aspects of operations management are considered. The aim is to provide to students with competences to develop solutions to the main relevant operations mangement problems. Course participants will gain an understanding of the main operations areas as well as improve their Excel skills. Solutions models for the following areas of operations management are considered:

  • Network modelling
  • Demand forecasting
  • Aggregate planning
  • Inventory management

Models are subsequently analyzed in order to evaluate the impact of the variation of the model's dimensions and compare different solutions for equivalent problems.

Teaching methods
The course follows a model building approach constituted of three steps: problem formulation, identification of quantitative relations, implementation and execution of the model in Excel.
Teaching is practically oriented. Lectures comprise a review of the operations management area under consideration and the presentation of useful spreadsheet techniques necessary for investigating the issue. For each topic, a number of Excel-exercises are solved in class and discussed. Exercises solved along the course and showing an understanding of the topic constitute the primary base for the exam preparation.
Feedback during the teaching period
During lectures and exercises students interact with the teacher with respect to solving problems that are developed during the course.
Student workload
Preparation 129 hours
Lectures / exercises discussion 33 hours
Course overhead and exam preparation 40 hours
Examination 4 hours
Expected literature

Text Book:

  • Chopra, S. and Meindl, P., Supply Chain Management, Strategy, Planning & Operation, Pearson Prentice-Hall, (2016).


Additional material will be provided along the course.

Last updated on 03-10-2017