Blood Stock Inventory Management (BSIMan) Worksheet Administrative

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

Cryoprecipitate
Information

Summary
Blood Stock Inventory Management Worksheet or BSIMan is an MS Excel worksheet designed
to automatically compute the blood stocks 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.

4. Save this file (File > Save as..)

5. Send to pbcbsiman@gmail.com or pbcbsiman@yahoo.com
6. A confirmation email will be sent back to you to confirm reciept.

* Call 9297911 and look for Mr. Philip Rodriguez or Mr. Geoffrey Sayoto for questions
and clarifications regarding your report.
 Whole Blood
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 Fresh Frozen
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
 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 Fresh Frozen
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
 Fresh Frozen 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 Fresh Frozen
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
 Platelets
Administrative
Blood Type Blood Type Information
Week O+ A+ B+ AB+ O- A- B- AB-
1 0 0 0 0 0 0 0 0
2 0 0 0 0 0 0 0 0
3 0 0 0 0 0 0 0 0
Whole Blood
4 0 0 0 0 0 0 0 0
5 0 0 0 0 0 0 0 0
6 0 0 0 0 0 0 0 0 Packed Red
7 0 0 0 0 0 0 0 0 Cells
8 0 0 0 0 0 0 0 0
9 0 0 0 0 0 0 0 0
10 0 0 0 0 0 0 0 0 Fresh Frozen
11 0 0 0 0 0 0 0 0 Plasma
12 0 0 0 0 0 0 0 0
13 0 0 0 0 0 0 0 0
14 0 0 0 0 0 0 0 0
15 0 0 0 0 0 0 0 0 Platelets
16 0 0 0 0 0 0 0 0
17 0 0 0 0 0 0 0 0
18 0 0 0 0 0 0 0 0
19 0 0 0 0 0 0 0 0 Cryoprecipitate
20 0 0 0 0 0 0 0 0
21 0 0 0 0 0 0 0 0
22 0 0 0 0 0 0 0 0
23 0 0 0 0 0 0 0 0 Summary
24 0 0 0 0 0 0 0 0
25 0 0 0 0 0 0 0 0
26 0 0 0 0 0 0 0 0

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

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
 Summary
Administrative
Whole Blood Information
Blood Type Blood Type
O+ A+ B+ AB+ O- A- B- AB-
Weekly 0 0 0 0 0 0 0 0 Whole Blood
2 Weeks 0 0 0 0 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 Fresh Frozen
Plasma
Frozen Plasma
Blood Type Blood Type
O+ A+ B+ AB+ O- A- B- AB-
Weekly 0 0 0 0 0 0 0 0
Platelets
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