- Academic Registry
Programme & Unit Catalogues

MN50750: Optimisation & spreadsheet modelling

[Page last updated: 05 August 2021]

Academic Year: 2021/2
Owning Department/School: School of Management
Credits: 10 [equivalent to 20 CATS credits]
Notional Study Hours: 200
Level: Masters UG & PG (FHEQ level 7)
Semester 1
Assessment Summary: CW 100%
Further information on unit assessment Assessment Detail:
  • Assessment detail for this unit will be available shortly.
Supplementary Assessment:
Like-for-like reassessment (where allowed by programme regulations)
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].

Skills: See LO Section.

Content: 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.

Programme availability:

MN50750 is Compulsory on the following programmes:

School of Management


  • This unit catalogue is applicable for the 2021/22 academic year only. Students continuing their studies into 2022/23 and beyond should not assume that this unit will be available in future years in the format displayed here for 2021/22.
  • 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.