1.Solutions should consist of an Excel workbook and a Word document. Please attach both files when submitting the project.
2.In the Excel workbook perform all calculations and simulations.
3.In the Word document write a report summarizing the results obtained in your Excel workbook.
4.The project consists of two parts. Please complete each part in a separate worksheet butin the same workbook Project: University administers at a local University have recently launched several planning projects to determine how effectively local emergency facilities such as local hospitals can handle natural disasters (weather fire etc.).One of these projects focused on the transport of disaster victims from the campus to the five major hospitals in the area (i)Beth Israel Deaconess Medical Center (ii)Tufts Medical Center (iii)Massachusetts General Hospital (iv)Boston Medical Center (v)Brigham and Women’s Hospital The project team would like to determine how many victims each hospital might expect in a disaster and how long it would take to transport victims to the hospitals. However because of lack of historical data on disasters in the area the project team have decided to assume that the total number of victims is best approximated by a triangular probability distribution with a minimum and a maximum of respectively 20 and 300 victims and with a peak of 80 victims. The emergency facilities and capabilities at the five hospitals vary. The following table describes how victims will be distributed to the hospitals in the event of a disaster situation: ð‘¯ð’ð’”ð’‘ð’Šð’•ð’‚ð’ð‘¨ð’ð’ð’ð’„ð’‚ð’•ð’Šð’ð’ð’ð’‡ð‘«ð’Šð’”ð’‚ð’”ð’•ð’†ð’“ð‘½ð’Šð’„ð’•ð’Šð’Žð’”Beth Israel Medical 30% Tufts Medical 15% Massachusetts General 20% Boston Medical 25% Brigham and Women’s 10% The proximity of the hospitals to the university campus also varies. It is estimated that the transport times to each of the hospitals is exponentially distributed with a certain average that depends on that hospital. The following table indicates the average of the transport time for each hospital. ð‘¯ð’ð’”ð’‘ð’Šð’•ð’‚ð’ð‘¨ð’—ð’†ð’“ð’‚ð’ˆð’†ð’Šð’ð‘´ð’Šð’ð’–ð’•ð’†ð’”Beth Israel Medical 7 Tufts Medical 10 Massachusetts General 15 Boston Medical 15 Brigham and Women’s 20 For simplicity we may assume that each hospital has two emergency vehicles so that one leaves the university campus when the other one leaves the hospital. This means that one emergency vehicle arrives at the campus when the other arrives at the hospital. Therefore the total transport time for each hospital will be the sum of transporting each victim to that hospital. 1.Perform a simulation analysis consisting of 5000 simulations to determine: (i)Average number of victims that can be expected at each hospital. (ii)For each hospital the average total time (in hours) needed to transport all victims. (iii)For part (i) above create a chart the displays the Law of Large Numbers in action for the Beth Israel Medical. (Law of large numbers: As the number of trials becomes larger the observed averages approach to the theoretical average.) (iv)For the Beth Israel Medical hospital perform an exploratory data analysis of the total transport time by: a)Calculating a 95% confidence interval for the total transport time b)Determining a probability distribution that best fits the total transport time (in hours). c)Support your assertion in part (b) by creating a frequency distribution and performing a Chi-squared Goodness of fit test. (v)Let ð’•denote the average transport time (in minutes) per victim for the entire process of transporting all victims. Perform an exploratory data analysis of ð’•. 2.Perform a simulation analysis consisting of 5000 simulations in another worksheet of your workbook; however assume that the total number ofvictims is normally distributed with a mean of 150 victims and a standard deviation of 50 victims. Furthermore suppose that the transport time for each hospital is normally distributed with a mean and a standard deviation that differ for each hospital. The table below displays these quantities: ð‘¯ð’ð’”ð’‘ð’Šð’•ð’‚ð’ð‘´ð’†ð’‚ð’ð’Šð’ð‘´ð’Šð’ð’–ð’•ð’†ð’”ð‘ºð‘«ð’Šð’ð‘´ð’Šð’ð’–ð’•ð’†ð’”Beth Israel Medical 7 2 Tufts Medical 10 4 Massachusetts General 15 3 Boston Medical 15 5 Brigham and Women’s 20 3 Analyze the results of this simulation by repeating parts (i) –(v) of part 1 using the above values. 3.In the word document explain your methodologies and conclusions. 4.What are the major quantitative and qualitative differences between the outputs of simulations (1) and (2) above. 5.Explainhow the information obtained from your simulation can be used for planning purposes. 6.Inyour opinion how can each simulation be changed to provide additional useful information
Requirements: follow by instruction | .xls file
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more