Analytical Support for Decision Making
This assignment accounts for 50% of the overall mark for the ASDM Class (the end-of-class exam accounts for the remaining 50%). There are two parts to the assignment. The division of marks between the three parts is shown (total = 100 marks). The marks allocated to each section indicate the amount of effort which should go into each section of the assignment. An indication of required length of submission is given in each section.
This is a group assignment. Because of the amount of work involved in this assignment you should work with a small group of other students (between 3 and 5).
All sections are compulsory - you will not receive an overall mark unless you submit a credible attempt for both sections.
The aims of the assignment are to engender a good understanding of, and skills in, the following aspects of the ASDM class:
• Using a spreadsheet to make sense of data;
• Conducting statistical analysis on a data set of reasonable size;
• Presenting analyses in visual and written form;
• Using multicriteria decision analysis to structure and inform a decision.
You will be advised of the deadline for submission of this assignment by your MBA Administrator.
You should submit one report per group. Your report should include your analysis for parts
A and B. You should also submit a copy of the Excel file used for your analysis.
You will be required to complete the MBA peer assessment form to measure the contribution of each group member to the assignment.
Introduction to the Assignment Context
The Manager of a local hospital has asked for your help. Data has been collected for the last
4 months in the hospital on patients who have had a blood transfusion. The data have been input into a spreadsheet. Unfortunately there is no-one in the Department with the necessary skills to analyse the data. You have been asked to analyse the data and provide a suitable management report for the Manager.
Note: the data provided is real and comes from a Scottish hospital but the name of the actual hospital has been kept confidential.
Background to the Problem
As most people are aware, blood and blood products are a key resource for a health service and are used in providing emergency treatment, in surgical treatment (operations) and in routine care. There are 4 main blood groups (known as ABO): A, B, O and AB. In addition, people either have, or do not have, the Rhesus factor on the surface of their red blood cells. This is usually indicated by 'RhD positive' (does have) or 'RhD negative' (does not have) suffix to the ABO blood group. This means that generally there are 8 main blood types. (Note; this is an oversimplification for the purpose of this assignment. There are in fact over
30 different blood types). Table 1 shows the 8 main blood types and the percentage of the
UK population in each blood type category. Table 2 shows a number of international comparisons.
In the UK, for example, blood supplies are generally obtained through a national blood donor service where citizens voluntarily donate blood, usually twice a year. After donation, the blood goes off to specialist laboratories for routine testing. In Scotland there are two testing labs, in Glasgow and Edinburgh, both working round the clock. The following tests are carried out on every donation:
• HIV - All donations are tested for antibodies to the HIV1 and HIV2 viruses which cause AIDS
• Hepatitis viruses - Hepatitis is an inflammation of the liver which may cause jaundice and sometimes liver failure. All donations are tested for hepatitis B and C.
The information of complete assignment attched in two files