Permalink
2012/2013 KAN-CM_T91 Applying Excel Models for Business and Operations Management
| English Title | |
| Applying Excel Models for Business and 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 Tuesday 12.35-14.15, week 6 Wednesdag 12.35-16.05, week 6,8-12 Thursday 12.35-16.05, week 8 |
| 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 Category of the Course | |
|
|
| Last updated on 07-11-2012 | |
| Learning objectives | |||||||||||||||||
|
At the exam, the student should be able to identify and implement in Excel the right method for solving problems similar to the ones dealt with during the course. These problems include: - Use of historical sales data series in order to assess future market share and demand - Product pricing and simulation of market conditions for new product launch - Definition of quality control standards and acceptance criteria - Suppliers scoring and assessment - Comparing suppliers and suppliers contracts for buyback, revenue sharing, and flexible quantities - Optimal aggregate planning and optimal level of product availability - Inventory control with constant and variable demand - Project plan implementation
|
|||||||||||||||||
| Prerequisite | |||||||||||||||||
|
To follow the course with proficiency it is suggested to have basic knowledge of linear programming and basic statistics.
This course is closed for students of the Cand.Merc. Supply Chain Management specialization. |
|||||||||||||||||
| Examination | |||||||||||||||||
| Applying Excel Models for Business and Operations Management | |||||||||||||||||
|
|||||||||||||||||
| Examination | |||||||||||||||||
| 4 hour individual computer exam | |||||||||||||||||
| Prerequisites for attending the exam | |||||||||||||||||
| It is strongly suggested to follow in-class lectures. | |||||||||||||||||
| Course content | |||||||||||||||||
The course takes a structured view of management decision-making. Different models for various aspects of business and operations management are considered.The aim is to provide students with competences for the implementation of solutions to real life business problems. Moreover, course participants will gain a deeper understanding of the main business theories as well as improve their Excel skills. Solutions models for the following areas of business and operations management will be considered:
|
|||||||||||||||||
| 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. For each topic, there will be Excel-exercises to solve using empirical data. Guiding solutions will be available. Each lecture will be structured in two parts: introduction and review of the business area under consideration and the spreadsheet techniques necessary for solving the exercises. Discussions, problem solving, and individual guidance will follow. Students will be encouraged to influence in-class teaching by providing business problems examples encountered along their study curricula. |
|||||||||||||||||
| Expected literature | |||||||||||||||||
|
Indicative Literature:
Barlow, J.F. Excel models for Business and Operation Management. John Wiley and Sons, LTD, 2005 Ragsdale, C.T. (2004) Spreadsheet Modelling and Decision Analysis: A Practical Implementation to Management Science (4th edition), Thomson, South-Western, ISBN 0-324-18399-2 Additional notes will be provided |
|||||||||||||||||
Last updated on 07-11-2012