Question 1195420: A pharmacist working in Black lion Specialized Hospital wants to secure the availability of Urografin 76% injection. To evaluate the current inventory policy for this drug, he got a 2 years average weekly-dispensed data at hand.
Weeks Unit
dispensed
11 1
20 1
48 1
55 1
85 1
12 2
32 2
42 2
56 2
67 2
72 2
10 3
31 3
6 4
22 4
43 4
47 4
49 4
71 4
80 4
94 4
5 5
13 5
21 5
26 5
37 5
39 5
46 5
50 5
57 5
58 5
69 5
74 5
79 5
4 6
15 6
18 6
30 6
38 6
70 6
76 6
86 6
3 7
7 7
16 7
19 7
34 7
40 7
44 7
51 7
61 7
68 7
77 7
8 8
14 8
17 8
28 8
33 8
35 8
41 8
45 8
59 8
64 8
66 8
75 8
81 8
103 8
1 9
9 9
27 9
36 9
60 9
62 9
65 9
104 9
73 10
90 10
93 10
101 10
89 11
100 11
102 11
2 12
83 12
92 12
99 12
88 13
91 13
25 14
52 14
84 14
87 14
98 14
29 15
95 15
23 16
78 16
97 16
54 17
53 18
63 18
82 18
96 18
24 19
Questions:
1. Calculate all the summary statistics in Excel.
a. Min/max, frequency, percentage, cumulative percentage, mean, median, mode, quartile (1st, 2nd, and 3rd), range, interquartile range, variance, standard deviation, and coefficient of variation.
b. Graph out frequency, percentage, and cumulative percentage.
2. Evaluating the current inventory level:
a. What is the probability that he will meet the demand if he stock 7 units? b. What is the probability of a stock-out if he stock 12 units?
c. How many units of the injectable Urografin he should stock to meet 90% of the demand. d. What is the inventory level that covers 100% of the demand?
3. When the injectable Urografin is stocked out, the pharmacist have an alternative infusion of Trazograf 76%. Each time the injectable is out of stock, he orders the prescribers to switch to Trazograf 76%, a far more expensive contrasting agent, which increases total cost per patient significantly.
a. What is the probability to meet demand from the combined inventory?
b. What is the probability that demand is less than the combined inventory but more than that of the Urografin 76% injection alone?
c. Considering the combined inventory, what is the probability of a stock out?
4. If the pharmacist told you that, he has 5 units of Urografin 76% injection and 2 units of Trazograf 76% infusion, what is the probability of meeting 95% of the demand per week?
Answer by ikleyn(52790)   (Show Source):
You can put this solution on YOUR website! .
Hello, if you think that the goal of this forum for tutors is to work instead of you, doing your job - then you make a big mistake.
The goal of this forum is totally different.
|
|
|
