- Academic Registry
Programme & Unit Catalogues

MN50750: Optimisation & spreadsheet modelling

[Page last updated: 15 October 2020]

Follow this link for further information on academic years Academic Year: 2020/1
Further information on owning departmentsOwning Department/School: School of Management
Further information on credits Credits: 10      [equivalent to 20 CATS credits]
Further information on notional study hours Notional Study Hours: 200
Further information on unit levels Level: Masters UG & PG (FHEQ level 7)
Further information on teaching periods Period:
Semester 1
Further information on unit assessment Assessment Summary: CW 100%
Further information on unit assessment Assessment Detail:
  • Assessment detail for this unit will be available shortly. (CW 100%)
Further information on supplementary assessment Supplementary Assessment:
Like-for-like reassessment (where allowed by programme regulations)
Further information on requisites Requisites:
Description: Aims:
This unit will introduce you to the concept of making the best possible decisions through the use of mathematics and computers. In addition, the unit covers the advanced functions of Excel the programming language (VBA) embedded within.

Learning Outcomes:

* Recognise the components of an optimisation problem within a given managerial problem [CILO:K1]
* Model and solve real life managerial problems as optimisation problems [CILO:I2, I3]
* Use advanced functions of Excel to provide business decision support [CILO:P1]
* Design spreadsheets and VBA code to solve business problems [CILO:P4, I5]
* Prepare business reports to present the results of an optimisation model to a non-technical audience [CILO:I6, P5].

See LO Section.

Topics covered:
Optimised decision making, what-if analysis, modeling multiple objective problems.
Spreadsheet Modelling: Basic and advanced spreadsheet functions, VBA programming, and implementing optimisation algorithms in VBA.
Further information on programme availabilityProgramme availability:

MN50750 is Compulsory on the following programmes:

School of Management


  • This unit catalogue is applicable for the 2020/21 academic year only. Students continuing their studies into 2021/22 and beyond should not assume that this unit will be available in future years in the format displayed here for 2020/21.
  • Programmes and units are subject to change in accordance with normal University procedures.
  • Availability of units will be subject to constraints such as staff availability, minimum and maximum group sizes, and timetabling factors as well as a student's ability to meet any pre-requisite rules.
  • Find out more about these and other important University terms and conditions here.