This assignment contains two parts which are both equally weighted:
Part 1 (50% marks – 1,500 words maximum):
A small manufacturing company is expanding and have approached you to help them select
the best way to acquire more space. They have identified 4 alternative options; either
extend their current warehouse or purchase space in either the city centre, a suburb or in
shared warehouses. They have also identified 5 key criteria; public transport links, ease of
parking, layout of the warehouse space, security and purchase cost. They have provided
you with their thoughts in the following table:

Alternatives
A1
(Centre)
A2
(Suburb)
A3
(Shared)
A4
(Extend)
C1 (Public
transport links)
Good bus
and rail
links
Good bus
links but no
rail link
Poor bus
links but
good rail
link
Excellent
bus and rail
links
C2 ( parking) Poor Good Excellent Moderate
C3 (warehouse
space)
Poor Excellent Good Good
C4 (security) *** **** *** **
C5 (cost) £800,000 £600,000 £300,000 £250,000

Subject to the External Examiner’s approval and may be subject to change LUBS5308
2 of 5
Using this information model this decision using AHP and TOPSIS. You will have to
make assumptions based on the information provided to create the decision tables for
AHP and TOPSIS.
Your report has two objectives:
1. Summarise the data used and outputs for the AHP and TOPSIS analyses, including
your workings in a single Excel file.
2. Respond to the small manufacturing company on how to proceed with their
decision. Provide justification for your response using your analyses.
Your (1,500 word maximum) report should use tables and figures as appropriate as well as
text to present your findings. In addition to the report, you must submit all your
workings/calculations in a single Excel file. This Excel file must contain no annotations,
all written work should be in the report. No appendices are required, and any material
provided in appendices will not contribute to the final mark. This section will be marked
using the following marking scheme:
Success Criteria Weighting
General
Presentation
Use of tables and graphics
Introduction
AHP and TOPSIS analyses
Identifying and summarising the data used
Providing and describing the outputs of the analyses
Response to Company
Summary of the way forward for the company
Technical details on how you came to give this advice

15%
5%
10%
10%
35%
15%
20%
40%
20%
20%
Total = 100%

Subject to the External Examiner’s approval and may be subject to change LUBS5308
3 of 5
Note: Presentation includes structure/format of the report, clarity of expression, grammar
and spelling. Your report will be rated on each success criterion using a six-point scale
from 0 (very poor) to 5 (excellent). The overall mark will be a weighted average of the
ratings.
Part 2 (50% marks – 1,500 words maximum):
Brewdog has provided you with data on 196 different beers which includes the Alcohol by
volume (ABV), International Bitterness Units (IBU), Original Gravity (OG), Colour Units
from the European Brewery Convention (EBC), pH (Acid & Base Scale), Attenuation
Level, Fermentation temperature in Celsius and the Yeast type used (BrewDogNew.csv).
There are several missing data points and Brewdog would like the beers clustered.
Brewdog will use the cluster information for marketing similar beers to their customers.
Identify the missing values, use imputation to replace the missing values and then a suitable
clustering algorithm to cluster the beers.
Your report has two objectives:
1. Show how you can use imputation to replace the missing values and then evaluate
the imputed values.
2. Utilise a suitable clustering algorithm to cluster the beers. Provide and explain the
information in a dendrogram.
Your report should use tables and figures as appropriate as well as text to present your
findings. No appendices are required, and any material provided in appendices will not
contribute to the final mark. This section will be marked using the following marking
scheme:
Your (1,500 word maximum) report should use tables and figures as appropriate as well as
text to present your findings. No appendices are required, and any material provided in
appendices will not contribute to the final mark. This section will be marked using the
following marking scheme:
Subject to the External Examiner’s approval and may be subject to change LUBS5308
4 of 5
Success Criteria Weighting
General
Presentation
Use of tables and graphics
Introduction
Imputation
Briefly discuss the various options for dealing with the missing
data
Correctly impute values for the missing data
Clustering
Correctly select and utilise a clustering algorithm on the data
Provide and explain the clustering information in a
dendrogram

15%
5%
10%
10%
30%
10%
20%
45%
30%
15%
Total = 100%
Note: Presentation includes structure/format of the report, clarity of expression, grammar
and spelling. Your report will be rated on each success criterion using a six-point scale
from 0 (very poor) to 5 (excellent). The overall mark will be a weighted average of the
ratings.

LUBS5308_100% Assignment_Resit_Jan 22

CITATION