THE UNIVERSITY of EDINBURGH

DEGREE REGULATIONS & PROGRAMMES OF STUDY 2021/2022

Information in the Degree Programme Tables may still be subject to change in response to Covid-19

University Homepage
DRPS Homepage
DRPS Search
DRPS Contact
DRPS : Course Catalogue : Business School : Common Courses (Management School)

Postgraduate Course: Optimisation Models for Marketing Decisions (CMSE11473)

Course Outline
SchoolBusiness School CollegeCollege of Arts, Humanities and Social Sciences
Credit level (Normal year taken)SCQF Level 11 (Postgraduate) AvailabilityNot available to visiting students
SCQF Credits10 ECTS Credits5
SummaryThis course aims to provide the tools for modelling and solving optimisation models arriving in business contexts. Optimisation models frequently appear in business contexts when a manager faces complex decision making. The course will present the students with a variety of quantitative skills that can assist a decision maker in modelling, understanding and finding optimal (close to optimal) solutions to a business problem.
Course description Academic Description:
This course aims to provide the tools for modelling and solving optimisation models arriving in business contexts. Optimisation models frequently appear in business contexts when a manager faces complex decision making. The course will present the students with a variety of quantitative skills that can assist a decision maker in modelling, understanding and finding solutions to a business problem.

Spreadsheet modelling using Microsoft Excel will also be covered at the outset and intensively practised during the course. The course focus is practical, with abundance of hands-on, close-to-reality, case studies. The students will develop the ability of understand the business context, decide on the complexity of the model that fits the problem better, use mathematical modelling and reasoning to construct the model, implement the model in the spreadsheet and decide on the type of optimisation algorithm that better suits the model. At the end of the course, the student will also be in a position to correctly interpret and implement the solution provided by the model and analyse its sensitivity to changes in the data.

Outline Content:
A selection of topics among:
- Introduction to operational research
- Linear programming
- Integer programming
- Goal programming
- Nonlinear unconstrained optimisation
- Metaheuristics
- Heuristics in logistics

Student Learning Experience:
The course focus is practical, with abundance of hands-on, close-to-reality, case studies. Spreadsheet modelling using Microsoft Excel will also be covered at the outset and intensively practiced during the course.

Tutorial/seminar hours represent the minimum total live hours - online or in-person - a student can expect to receive on this course. These hours may be delivered in tutorial/seminar, lecture, workshop or other interactive whole class or small group format. These live hours may be supplemented by pre-recorded lecture material for students to engage with asynchronously.
Entry Requirements (not applicable to Visiting Students)
Pre-requisites Co-requisites
Prohibited Combinations Other requirements None
Course Delivery Information
Academic year 2021/22, Not available to visiting students (SS1) Quota:  None
Course Start Block 3 (Sem 2)
Timetable Timetable
Learning and Teaching activities (Further Info) Total Hours: 100 ( Seminar/Tutorial Hours 10, Programme Level Learning and Teaching Hours 2, Directed Learning and Independent Learning Hours 88 )
Additional Information (Learning and Teaching) Seminar/Tutorial hrs are the min total live hrs, online or in-person, students can expect to receive
Assessment (Further Info) Written Exam 0 %, Coursework 100 %, Practical Exam 0 %
Additional Information (Assessment) 50% coursework (individual) - assesses all course Learning Outcomes
50% coursework (group) - assesses all course Learning Outcomes
Feedback Formative feedback:
Students will gain feedback on their understanding of the material when they perform computer lab exercises. Students may ask questions in lectures and in forums to assess their knowledge.
No Exam Information
Learning Outcomes
On completion of this course, the student will be able to:
  1. Understand and critically discuss the nature of problem solving and decision making (and its support through quantitative techniques) in Business Analytics.
  2. Understand and critically assess various methods and algorithms for finding optimal solutions.
  3. Understand and apply the techniques for modelling optimisation problems.
  4. Understand and critically assess the relative merits of the techniques for modelling optimisation problems.
  5. Work within pairs in modelling optimisation problems, discussing different modelling options and deciding what level of complexity suits each business case.
Reading List
Operations Research. Taha, Hamdy A.10th edition.Harlow, United KingdomPearson Education Limited, 2016
Anderson, D.R., Sweeney, D, Williamns, A.W. and Wisniewski, M. (2017), An Introduction to Management Science - Quantitative Approaches to Decision Making (Third Edition), South-Western Cengage Learning
Albright, S.C and Winston, W.L. (2004), Spreadsheet Modeling and Applications - Essentials of Practical Management Science, South-Western Cengage Learning

Resource List:
https://eu01.alma.exlibrisgroup.com/leganto/public/44UOE_INST/lists/29527247760002466?auth=SAML
Additional Information
Graduate Attributes and Skills Cognitive Skills
Students will develop skills such as:
- the ability to build models to support management decision making;
- the ability to critically validate models for management decision making;
- the ability to interpret results and suggest best solutions for decision making models;
- the ability to understand the intuition behind optimisation algorithms.

Subject Specific Skills
Students will gain:
- an appreciation of methods involved in business decision modelling;
- experience in applying model building methods to realistic examples involving optimisation;
- experience in using spreadsheets to tackle optimisation problems.

By the end of the course students will be expected to:
- be able to plan and carry out analyses based on construction and solution of appropriate optimisation models;
- be able to employ analytical and problem solving skills;
- show that they can report results in a concise way;
- have enhanced their skills in using commercial software products.
KeywordsNot entered
Contacts
Course organiserDr Belén Martín-Barragán
Tel: (0131 6)51 5539
Email: Belen.Martin@ed.ac.uk
Course secretaryMs Emily Davis
Tel: (0131 6)51 7112
Email: Emily.Davis@ed.ac.uk
Navigation
Help & Information
Home
Introduction
Glossary
Search DPTs and Courses
Regulations
Regulations
Degree Programmes
Introduction
Browse DPTs
Courses
Introduction
Humanities and Social Science
Science and Engineering
Medicine and Veterinary Medicine
Other Information
Combined Course Timetable
Prospectuses
Important Information