2013/2014 KAN-CCMVU3050U Applying Excel Models in Operations Management
English Title | |
Applying Excel Models in Operations Management |
Course information |
|
Language | English |
Exam ECTS | 7.5 ECTS |
Type | Elective |
Level | Full Degree Master |
Duration | One Quarter |
Course period | Autumn, Spring
Changes in course schedule may occur Wednesday 09.50-12.25, week 6-13 |
Time Table | Please see course schedule at e-Campus |
Study board |
Study Board for MSc in Economics and Business
Administration
|
Course coordinator | |
|
|
Administrative Contact Malindi Wilks - maw.om@cbs.dk | |
Main academic disciplines | |
|
|
Last updated on 20-02-2014 |
Learning objectives | |||||||||||||||||||||||||
The course introduces students to a
variety of techniques used in the modelling environment to support
the decision analysis process. Evaluating alternative models and
choosing the best course of action is the essence of the course.
For the analysis and evaluation of decisions alternatives the
models are implemented and solved 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. Specifically the student has to:
|
|||||||||||||||||||||||||
Course prerequisites | |||||||||||||||||||||||||
To follow the course with proficiency it is suggested to have basic knowledge of mathematical programming and statistics. | |||||||||||||||||||||||||
Examination | |||||||||||||||||||||||||
|
|||||||||||||||||||||||||
Course content and structure | |||||||||||||||||||||||||
The course takes a structured view of management decision-making. Different models for various aspects of operations management are considered. The aim is to provide to students the essential competences for the implementation of solutions to the main relevant operations mangement problems. Course participants will gain a deep understanding of the main business models as well as improve their Excel skills. Solutions models for the following areas of operations management are considered:
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 short review of the operations management area under consideration and the presentation of the spreadsheet techniques necessary for solving the models. Discussions and guidance in problem solving follows. For each topic, a number of Excel-exercises are delivered with solutions. Exercises solved along the course constitute the primary base for the exam preparation. |
|||||||||||||||||||||||||
Further Information | |||||||||||||||||||||||||
Students of the Cand. Merc. Supply
Chain line that attented the course Planning and Control in
Operations and Supply Chain in semester fall 2011 cannot sign to
the course.
The course is planned as semester course for the Autumn semester and as quarter course for the Spring semester. |
|||||||||||||||||||||||||
Expected literature | |||||||||||||||||||||||||
Text Book:
Chopra, Sunil / Meindl, Peter (2009): Supply Chain Management, Strategy, Planning & Operation, 4rd edition, Pearson/Prentice-Hall, Upper Saddle River, NJ - ISBN-13: 978-0136080404
Other indicative literature:
Additional material will be provided along the course. |