This is a Simulation problem, can I please get the solution of this.

Question 3 A hospital receives a delivery of fresh plasma once each week from a central blood bank. The supply varies according to demand from other hospitals in the region but ranges between 4 and 9 units of the most widely used blood type, type 0. The number of patients per week requiring this blood varies from 0 to 4, and each patient may need from 1 to 4 units. Consider the following delivery quantities, patient distribution and demand per patient: Delivery Quantities (units per week) Probability 4 6 7 8 9 0.18 0.25 0.27 0.15 0.10 0.05 DSC3703 Patients per week requiring blood Probability 0.21 0.29 0.33 0.12 0.05 3 4 Demand per patient (units per week) Probability 0.40 0.30 0.20 0.10 4 The objective is to determine what would be the number of units in excess or short for a 20-week period. Use simulation to derive your answer. Consider that plasma is storable and there is currently none on hand. Assume that the delivery is done at the beginning of a week so that the quantity delivered at the beginning of a week can be used to meet the demand of that same week (if necessary). (3.1) Use sequentially the following random numbers to simulate the delivery quantities, U-0.70 U, -0.03 Ug = 0.67 UA=0.08 Ug = 0.68 U 0.97 U 0.70 Ug = 0.87 Ug = 0.60 U10 = 0.19 U11 = 0.57 U12 = 0.85 U13 = 0.96 U1=0.26 Us=0.86 U16 = 0.73 U17 = 0.56 U18 = 0.12 Ug = 0.19 U20 =0.73 U21 -0.43 Un=0.73 U2 = 0.23 U2 = 0.08 Ug = 0.54 (3.2) Use sequentially the following random numbers to simulate the number of weekly patients requiring blood. U20 = 0.46 U2 = 0.35 U23 = 0.81 U2 = 0.69 Ug = 0.78 U21 0.79 U2 -0.07 Ug = 0.78 U40.06 Ug = 0.91 U36 = 0.81 U = 0.12 Ug = 0.56 Ug = 0.20 U = 0.56 Un=0.27 U2 = 0.44 U43=0.88 U41=0.81 Vas = 0.29 U46=0.34 047 = 0.37 U4 = 0.33 V = 0.80 Ug = 0.45 (3.3) Use sequentially the following random numbers to generate the quantity of blood required for each of the patients derived in Question 1.2 and find the total weekly demand for the period in question US 0.71 Us2 = 0.19 Uss = 0.63 Usa = 0.68 Us = 0.92 Ug = 0.81 US7 = 0.12 Us=0.56 Ug = 0.20 U = 0.56 U=0.57 U2 = 0.85 U63 0.96 U = 0.26 Va=0.86 UGG = 0.73 167=0.56 US = 0.12 U = 0.19 U70 =0.73 Un = 0.05 U2 = 0.42 UT = 0.80 U-4 = 0.83 Uys=0.42 (3.4) Determine the number of units in excess or short for the period in question 2 DSC3703 Show all your calculations. You should present your answers to Question 3.4 in the form of the following table; Week Quantity Total Number Total Number delivered blood of patients weekly of units on hand blood required remaining 1 2 3 4 5 6