Using the random variates given below, simulate the stated problem below for 8 weeks.

	MIDSQUARE	MULTIPLICATIVE	MIXED
1	0.9167	0.2181	0.2234
2	0.0338	0.0697	0.2711
3	0.1142	0.5789	0.036
4	0.3041	0.4193	0.3373
5	0.2476	0.5141	0.4854
6	0.1305	0.0217	0.9651
7	0.703	0.8029	0.714
8	0.4209	0.7073	0.4233
9	0.7156	0.1701	0.6674
10	0.2083	0.2937	0.6991

A rural clinic receives a delivery of fresh plasma once each week from a central blood bank. The supply varies according to demand from the other clinics and hospitals in the region but ranges between four and nine pints of the most widely used blood type, type O. The number of patients per week requiring this blood varies from zero to four, and each patient may need from one to four pints. Given below are the delivery quantities, patient distribution, and demand per patient:

Delivery			Patients Needing Blood			Demand per Patient
Pints	Cum. Prob.		No. of Patients	Cum. Prob.		Pints	Cum. Prob.
4 5 6 7 8 9	0.15 0.35 0.60 0.75 0.90 1.00		0 1 2 3 4	0.25 0.50 0.80 0.95 1.00		1 2 3 4	0.40 0.70 0.90 1.00

Consider that plasma is storable and there is currently none on hand. Complete the given table.

		Qty. Delivered			Patients Needing Blood		Demand
Wk No.	Beginning Inventory	RN (Midsquare)	Pints	Total Blood on-hand	RN (Multiplicative)	# of Patients	Patient	* RN (Mixed)	Pints	No. of Pints Remaining
1
2
3
4
5
6
7
8
Total

* Tip: * Use RN only when there's a demand

1. What would be the number of pints in excess or short for an eight-week period?
2. What is the clinics service level? Is there a need to improve the clinics inventory of blood?
3. UPLOAD YOUR SOLUTION (PDF/JPEG) ON THE LINK PROVIDED