English   Danish

2016/2017  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, Third 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)
Kontaktinformation: https:/​/​e-campus.dk/​studium/​kontakt eller Contact information: https:/​/​e-campus.dk/​studium/​kontakt
Main academic disciplines
  • Management
  • Statistics and quantitative methods
  • Supply chain management and logistics
Last updated on 24-11-2016
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.
Examination
Applying Excel Models in Operations Management:
Exam ECTS 7,5
Examination form Written sit-in exam
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 and Spring
Aids allowed to bring to the exam Closed book: no aids
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.

PC exam on CBS computers.
It is not allowed to bring your own PC and printer.
Hand in on Learn - Excel File.
No access to the Internet, S-drive, and LEARN.
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.
Student workload
Preparation 130 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 24-11-2016