Blood Stock Inventory Management (BSIMan) Worksheet Administrative

Information
Name of Institute
Whole Blood
Address
Packed Red
Officer in Charge
Cells
Position
Tel no. Plasma
Fax no.
E-mail Platelets
Period covered

Cryoprecipitate
Information

Summary
Blood Stock Inventory Management Worksheet or BSIMan is a MS Excel worksheet designed
to automatically compute the blood stock inventory.

Defenition
usage - the number of blood units of any one type transfused on a given day.

Instructions
1. Collect weekly blood and component data over a six-month-period utilization.
2. Record usage by ABO and Rh type for each week segregated into specific blood
components.
3. Enter data into BSIMan. Include administrative information.
4. In the BSIMan, click on the box located on the right side for the specific blood
component inventory.
4. BSIMan will automatically:

a. disregard the single highest usage for each type to correct for unusual week-to-
week variation (e.g., large volumes for emergency).

b. total the number of units of each ABO and Rh type, omitting the highest week in
each column,
c. divide each total by 25, and

d. give an estimate of the average weekly blood usage of each ABO and Rh type.
 Whole Blood
Administrative
Blood Type Blood Type Information
Week O+ A+ B+ AB+ O- A- B- AB-
1 8 4 4 2
2 10 7 5 0
3 9 6 5 2
Whole Blood
4 13 8 6 0
5 8 6 5 1
6 12 7 6 0 Packed Red
7 14 5 4 2 Cells
8 9 6 6 2
9 10 7 7 1
10 11 4 5 0
11 10 6 4 0 Plasma
12 14 9 7 0
13 15 5 5 1
14 11 6 6 2
15 14 5 7 4 Platelets
16 8 5 5 2
17 9 6 6 0
18 10 8 8 2
19 12 5 5 0 Cryoprecipitate
20 9 6 6 3
21 10 6 5 1
22 10 6 4 2
23 8 8 7 2 Summary
24 9 7 5 0
25 10 4 5 2
26 12 6 6 0

A+ B+ AB+ O- A- B- AB-

Highest
15 9 8 4 0 0 0 0
week
Total used 275 158 144 31 0 0 0 0
Sub Total 260 149 136 27 0 0 0 0
Average
weekly
10.4 5.96 5.44 1.08 0 0 0 0
blood
usage
Weekly 11 6 6 2 0 0 0 0
2 Weeks 22 12 12 4 0 0 0 0
 Packed Red Cells
Administrative
Blood Type Blood Type Information
Week O+ A+ B+ AB+ O- A- B- AB-
1
2
3
Whole Blood
4
5
6 Packed Red
7 Cells
8
9
10
11 Plasma
12
13
14
15 Platelets
16
17
18
19 Cryoprecipitate
20
21
22
23 Summary
24
25
26

O+ A+ B+ AB+ O- A- B- AB-

Highest
0 0 0 0 0 0 0 0
week
Total used 0 0 0 0 0 0 0 0
Sub Total 0 0 0 0 0 0 0 0
Average
weekly
0 0 0 0 0 0 0 0
blood
usage
Weekly 0 0 0 0 0 0 0 0
2 Weeks 0 0 0 0 0 0 0 0
Administrative
Information

Whole Blood

Packed Red
Cells

Plasma

Platelets

Cryoprecipitate

Summary
 (FFP) Plasma
Administrative
Blood Type Blood Type Information
Week O+ A+ B+ AB+ O- A- B- AB-
1
2
3
Whole Blood
4
5
6 Packed Red
7 Cells
8
9
10
11 (FFP)Plasma
12
13
14
15 Platelets
16
17
18
19 Cryoprecipitate
20
21
22
23 Summary
24
25
26

O+ A+ B+ AB+ O- A- B- AB-

Highest
0 0 0 0 0 0 0 0
week
Total used 0 0 0 0 0 0 0 0
Sub Total 0 0 0 0 0 0 0 0
Average
weekly
0 0 0 0 0 0 0 0
blood
usage
Weekly 0 0 0 0 0 0 0 0
2 Weeks 0 0 0 0 0 0 0 0
Administrative
Information

Whole Blood

Packed Red
Cells

(FFP)Plasma

Platelets

Cryoprecipitate

Summary
 Platelets
Administrative
Blood Type Blood Type Information
Week O+ A+ B+ AB+ O- A- B- AB-
1
2
3
Whole Blood
4
5
6 Packed Red
7 Cells
8
9
10
11 Plasma
12
13
14
15 Platelets
16
17
18
19 Cryoprecipitate
20
21
22
23 Summary
24
25
26

O+ A+ B+ AB+ O- A- B- AB-

Highest
0 0 0 0 0 0 0 0
week
Total used 0 0 0 0 0 0 0 0
Sub Total 0 0 0 0 0 0 0 0
Average
weekly
0 0 0 0 0 0 0 0
blood
usage
Weekly 0 0 0 0 0 0 0 0
2 Weeks 0 0 0 0 0 0 0 0
Administrative
Information

Whole Blood

Packed Red
Cells

Plasma

Platelets

Cryoprecipitate

Summary
 Cryoprecipitate
Administrative
Blood Type Blood Type Information
Week O+ A+ B+ AB+ O- A- B- AB-
1
2
3
Whole Blood
4
5
6 Packed Red
7 Cells
8
9
10
11 Plasma
12
13
14
15 Platelets
16
17
18
19 Cryoprecipitate
20
21
22
23 Summary
24
25
26

O+ A+ B+ AB+ O- A- B- AB-

Highest
0 0 0 0 0 0 0 0
week
Total used 0 0 0 0 0 0 0 0
Sub Total 0 0 0 0 0 0 0 0
Average
weekly
0 0 0 0 0 0 0 0
blood
usage
Weekly 0 0 0 0 0 0 0 0
2 Weeks 0 0 0 0 0 0 0 0
Administrative
Information

Whole Blood

Packed Red
Cells

Plasma

Platelets

Cryoprecipitate

Summary
 Summary
Administrative
Whole Blood Information
Blood Type Blood Type
O+ A+ B+ AB+ O- A- B- AB-
Weekly 11 6 6 2 0 0 0 0 Whole Blood
2 Weeks 22 12 12 4 0 0 0 0

Packed red cells

Blood Type Blood Type
Packed Red
O+ A+ B+ AB+ O- A- B- AB- Cells
Weekly 0 0 0 0 0 0 0 0
2 Weeks 0 0 0 0 0 0 0 0
Plasma
Plasma
Blood Type Blood Type
O+ A+ B+ AB+ O- A- B- AB-
0 0 0 0 0 0 0 0
Platelets
Weekly
2 Weeks 0 0 0 0 0 0 0 0

Platelets Cryoprecipitate
Blood Type Blood Type
O+ A+ B+ AB+ O- A- B- AB-
Weekly 0 0 0 0 0 0 0 0
2 Weeks 0 0 0 0 0 0 0 0 Summary
Cryoprecipitate
Blood Type Blood Type
O+ A+ B+ AB+ O- A- B- AB-
Weekly 0 0 0 0 0 0 0 0
2 Weeks 0 0 0 0 0 0 0 0