English   Danish

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
  • Chiara Gobbi - Department of Operations Management
Administrative Contact Malindi Wilks - maw.om@cbs.dk
Main Category of the Course
  • Information Systems
  • Management
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
  • Display a high level of command of the methods presented in the course
  • Ability to modify the relevant methods in relation to problems specificity
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.
Applying Excel Models for Business and Operations Management
Applying Excel Models for Business and Operations Management:
Type of test Written Exam
Marking scale 7-step scale
Second examiner No second examiner
Exam period Autumn Term and Spring Term
Aids Closed Book
Duration 4 Hours
It is strongly suggested to follow in-class lectures.
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:  
  • Marketing  (demand/sales estimation) and salesforce allocation
  • Product pricing  and revenue management
  • Quality control
  • Resources allocation in production and transportation
  • Aggregate planning and production operations
  • Inventory planning and control
  • Project management
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