ASDM Individual Assignment MBM (Strathclyde Business School) 2025

Preamble

This assignment accounts for 100% of the overall mark for the ASDM Class.

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 and interpreting statistical analyses on a data set of reasonable size;
• Using appropriate analysistechniques to structure and inform a decision.
• Presenting your analyses in visual and written form;

The report for this assignment should have three parts. The division of marks and a page length guide for the three partsissummarised below. All parts are compulsory, and each part focuses on a different set of skills. For Part 2 and Part 3 there are multiple problems, and students should answer only one problem from the available options. Students will not receive an overall mark unless a credible attempt is submitted for each part. If students submit answers to multiple problems from parts 2 or 3, only the first problem answered in each case will be marked.

The overall report length must not exceed 8 pages, including appendices. Each part has a strict page limit (detailed below), which should comprise of two sections:

• A summary section: this is expected to be brief and concise and be targeted at a senior manager whose knowledge of statistics and analysis is very limited. It should clearly identify the problem you have tackled, describe the approach you have taken to address the problem, identify any issues or limitations in your analysis, and provide any concluding recommendations that directly address the problem. Note that figures may be included in the summary if these help to communicate your findings, however, it is expected that most figures will be presented in the appendix section.
• A technical appendix section: this should provide all evidence that is necessary to support your summary, and to provide confidence that you have taken a robust approach to the problem. Thisshould include appropriate levels of detail on the approach that you have taken, and show any charts, diagrams, and tables that support your summary. Any assumptions you have made with your analysis should be clearly stated and justified as appropriate. Any modelling decisions you have made should be justified as appropriate.

Introduction to the Assignment Context

The Manager of a local hospital has asked for your help. She thinks that the blood transfusion activity at the hospital is in need of improvement and has identified a number of problems for which she would like some analysis to be conducted. Unfortunately, there is no-one in the Department with the necessary skills to conduct the analysis. You have been asked to focus on three problems and providea suitable management report to support the Manager’s decision making.

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.

Table 1 Blood types and UK population

Source: Blood Transfusion Service website

Blood Transfusion

Transfusion medicine is a specialized branch of haematology that is concerned with the study of blood groups, along with the work of a blood bank to provide a transfusion service for blood and other blood products. Across the world, blood products must be prescribed by a medical doctor (licensed physician or surgeon) in a similar way as medicines. Much of the routine work of a blood bank involves testing blood from both donors and recipients to ensure that every individual recipient is given blood that is compatible and is as safe as possible. If a unit of incompatible blood is transfused between a donor and recipient, a severe acute haemolytic reaction, renal failure and shock are likely to occur, and death is a possibility.

Patients should ideally receive their own blood or type-specific blood products to minimize the chance of a transfusion reaction. Risks can be further reduced by cross-matching blood, but this step may be omitted when blood is required for an emergency. Cross-matching involves mixing a sample of the recipient's serum with a sample of the donor's red blood cells and checking if the mixture agglutinates, or forms clumps. If agglutination is not obvious by direct vision, blood bank technicians usually check for agglutination with a microscope. If agglutination occurs, that particular donor's blood cannot be transfused to that particular recipient.

Blood Compatibility

Although ideally patients should receive matched blood products, in practice some blood group types are compatible with others. Table 3 shows the compatibility between donor and recipient. So for example, a patient who is A- can be given A- blood (their own type) but also O- blood. In fact, examination of Table 3 indicates that O- blood is compatible with all the other blood types and can be used on all patients. O- blood products are often referred to as “universal” as they can be used for all patients. This can be extremely useful, for example, in emergencies when a blood transfusion is needed urgently and there may not be time to identify the patient’s actual blood type.

Table 3 Red blood cell compatibility table

Source: Wikipedia

Note - Assumes absence of atypical antibodies that would cause an incompatibility between donor and recipient blood, as is usual for blood selected by cross matching.

Blood Donations

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.
• Syphilis - Syphilis, a sexually transmitted disease, can be passed on through blood, so all donations are tested.
  Typically, a donation will have been processed and tested and ready for use within 48 hours. Blood has a very short shelf life of around 35 days and has to be stored and distributed under stringent conditions.

Assignment Tasks

As outlined above, for parts 1, 2 and 3 below you should prepare a summary report and a technical appendix. The summary report should be written for the manager whose knowledge of statistics and analysis is very limited. You may use the technical appendices to show any technical analysis that you have conducted (note that appendices are included in your page limit).

For each question you answer, provide your answer along with any supporting evidence. In each case choose which of the methods covered in the class you think are best suited to each problem and justify this choice with a sentence or two. Discuss any assumptions, issues, or limitations in your analysis, along with any concluding recommendations.

Part 1: Exploratory analysis (40 marks) All students should attempt this question

The hospital manager you have been asked to help faces a difficulty. Although O- blood is universal, in the sense that it can be used safely with virtually all patents, it is also in short supply. Table 1 indicates that only around 7% of the UK population is O- and, by implication, only around 7% of blood donations will be O-. The manager would prefer medical staff to be using appropriately matched blood wherever possible and restricting the use of O- blood to those patients who really need it: those patients who are actually O- (since from Table 3 there are no other compatible blood types) and those patients who require emergency blood transfusion (where there is no time to check their blood type).

On the other hand, the manager does not want donated blood to be wasted, which can happen if blood is not used within its shelf life (each unit of blood is marked with an expiry date). As a result, she has carried out some data collection in the hospital over the last six months. A record has been kept of every patient who received O- blood during that period. The following data has been collected on each patient (and is available in the accompanying Excel file for this assignment).

ID: a patient identifier Gender: Male/Female Age: of the patient in years
ABO: Blood group of the patient – O, A, B, AB
Rh: POS(itive) or NEG(ative)

Emergency: whether the patient was an emergency admission and so needed an O- transfusion. Y for Yes, otherwise blank
Units: total number of units of blood transfused

Reason: for patients whose blood group was not O-, the reason (if known) they were given O- blood.

• X means they were given O- blood because the blood available was close to its expiry date and would otherwise have been thrown away
• N means that the hospital blood bank had no supplies of the patient’s actual blood
  type in stock and so O- blood was used instead
• Z means there was some other medical reason for giving the patient O- blood; Age of blood: the maximum age (in days) of the blood units used for transfusion. E.g. a 2 unit transfusion with age of blood equal to 15 days means that one unit is 15 days old, and the other is at most 15 days old.

Duration of Stay: the number of days for which the patient remained in hospital after the transfusion.

Note for some patients there is incomplete data, and some cells may have been left blank/empty.

Your first task is to conduct a thorough analysis of the data presented and to write a report for the hospital manager summarising the key findings in relation to use of O-blood within the hospital. The manager is interested in acquiring a better understanding of hospital’s demand for blood to inform purchasing and storage decisions. Your analysis should include, but not be restricted to, analysis of demand on a daily basis as well as the aggregate demand over a 35-day period which corresponds to shelf life. Your analysis should give a breakdown of the demand where appropriate, but only where this is insightful and with justification provided. Appropriate visualisations should be used to support your analysis.

Part 2: Statistical analysis (30 marks)

Students should select only one of the following questions (choose either question 2.1, 2.2 or 2.3 – note that 2.3 has multiple parts to be answered)

Question 2.1

2.1 Info: The Manager has heard anecdotal evidence that patients who receive older blood (i.e. closer to its expiry date) are more likely to suffer adverse effects from the blood transfusion. She would like to use the Excel data described for Part 1 to determine if there is any evidence of this relationship, which could be used to identify an improved strategy to handling the blood expiry. Specifically, her question is as follows:

2.1 Task: Can the age of blood used in the transfusion be used to predict the duration of a patient’s
stay? Does this relationship vary between patient blood types?

Question 2.2

2.2 Info: The Manager would like to ensure that more transfusions occur with closer matched blood types, so that the O- blood supplies are less commonly used for non-O- patients. Excess demands of a blood type are assumed to represent demands that exceed supply of the blood type (e.g. if there are 2 units of A+ supplies available, and demand is for 5 units of A+, then there is an excess demand of 3 units which need to be covered using an appropriate substitute for A+). Assume that at present, all excess demands are fully covered by O- blood supplies, and that all transfusions of O- to other blood groups could be avoided if there were sufficient supplies of appropriate alternatives. The Manager is considering a revision to the strategy to handle excess demands and would like some analysis of the Excel data described for Part 1, to give a better understanding of these (see details below).

2.2 Task: How many additional units of each blood type would be required per 35-day period to ensure that required demands could be satisfied in 99.99% of cases (e.g. how many additional units of O+ blood would remove the excess demands on the O- supplies with a probability of 0.9999)? HINT: carefully consider the role of the Central Limit Theorem in modelling aggregate demand over a 35-day period.

Question 2.3

2.3 Info: The manager would like to use available data to inform decisions on managing the blood transfusion system in the hospital. However, she is unsure about the quality of data that has been collected, and whether this can be used with confidence. In particular, she is unsure whether the Excel data sample described for Part 1 is sufficient data to give a true representation of the hospital’s blood use. Additionally, she is unsure whether international approaches to managing blood use can be appropriately transferred to a UK hospital. See parts 2.3(i) and 2.3(ii) below.

Regarding the Excel data described for Part 1, the Manager would like to confirm that the data is actually representative of the hospital’s blood use needs. She believes that the O- supplies would be used for other blood types at rates that are equivalent to the distribution of individuals with those other blood types and would like to check how these rates compare with the national average.

2.3 Task (i): for each blood group (except O-), is the proportion of cases in the Excel data sample different to the national average shown in Table 1 (use an appropriate confidence interval to justify your answer)? Using your answer, advise the manager on her query.

Various studies have been published which describe blood management approaches that have been effectively deployed in different countries around the world. The Manager has identified some approaches that sound applicable in her hospital, but she is unsure whether the data can be assumed to be comparable with the UK data. The Manager is aware that, as blood is inherited from parents, there are genetic differences in blood type distributions between countries, as shown with Table 2. However, the Manager thinks that the differences in Table 2 could just be artefacts of the data collection approach in each country.

2.3 Task (ii): Is the UK proportion of O- cases statistically different to the average proportion of O- cases from the sample of other countries shown in Table 2 (use an appropriate confidence interval to justify your answer)? Using your answer, advise the manager on her query.

3.1 Task: 

Which of the improvement options (A, B or C) is preferred, when multiple criteria are used to rank the options, and multiple stakeholder perspectives are considered. Identify at least three criteria/attributes which can be used to rank the three options. Consider the perspectives of at least three potential stakeholder groups for this problem and identify conflicting interests. Use appropriate software to analyse the problem and recommend a course of action. Assume values for any data that you do not have, and briefly explain your reasoning for the values that you use.

Question 3.2

3.2 Info: You have been given access to an expert in the hospital on their current blodd transfusion services. The expert has been able to provide some more detailed data on the improvement options, but for some pieces of information, the expert is unsure. The additional information on the improvement options is as follows:

Option A: under this option there is a 10% chance that the hospital has insufficient stock per patient. Specialist transportation of emergency supplies has an average cost of £5,000. In 80% of cases, this arrives within 3 hours and on average there is no detriment to care. Of the remaining cases, 75% of the time emergency supplies arrive between 3 and 6 hours after requested, and the potential delay to treatment incurs an additional expected cost of £20,000 due to lasting health conditions. For the remaining cases, there is a substantial risk to the patient. If the emergency supply can be delivered in time, the potential delay to treatment incurs an additional expected cost of £100,000. However, in 5% of cases, the emergency supplies do not reach the hospital in time and result in a fatality. This cost placed on this outcome is £1.83 million.

Option B: there are three options for the expansion – noted as small, medium and large. The costs described above refer to the medium expansion (£0.75 million for construction, and £175,000 per anum for maintenance). If the medium expansion is in place, the expert predicts that the increased storage capacity would reduce the likelihood of insufficient stock to 5%. The expert does not have data on the small or large expansions.

Option C: under this option, the expert predicts that improved analysis and management would of blood supplies and demand would reduce the likelihood of insufficient stock to 7%.

3.2 Task: Which of the improvement options has the lowest expected value over one year? Over 5 years? Over 10 years? Assume values for any data that you do not have and explain your reasoning for the values that you use.