Question: 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
19 Oct 2022,10:49 PM
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:
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:
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 themissing values, useimputation toreplacethe missing valuesand thenasuitable 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:
|
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. |
