Information system to manage blood inventory and direct collection campaigns

Ferreira, Vanessa Elionara de Souza; Carmo, Breno Barros Telles do; Oliveira, Amanda Gondim de

Acessibilidade / Reportar erro

Brasil

Español English

sumário « anterior atual seguinte »

Sumário

Original Articles • Gest. Prod. 26 (2) • 2019 • https://doi.org/10.1590/0104-530X2223-19 copy

Information system to manage blood inventory and direct collection campaigns

Authorship SCIMAGO INSTITUTIONS RANKINGS

Abstract

Blood collection is one of the challenges of Brazilian Blood Banks, which aims at providing products produced from blood to hospitals. These organizations face the challenge of meeting supply and demand of blood products. This research paper proposes a system to manage inventory levels of blood products in Blood Banks to direct blood collection campaigns. The idea of the system is to maximize the offer and minimize the waste caused by products’ expiry dates. The system was implemented in open source development environment, without financial cost, allowing portability and gratuity characteristics for the system. The system was implemented with real blood bank data to demonstrate system’s functionalities, such as demand forecast. Through comparison of this information with inventory levels, the system provides guidance for blood collection campaigns. It presents a clear and intuitive interface with many features to support the activities of the blood banks and it is able to meet the needs of Blood Banks in Brazil and worldwide.

Keywords:
Blood banks; Demand forecasting; Inventory management; Java; Database

Higher and lower inventory levels calculation phase	Equation
1. Average demand	$d_{m é d} = \frac{\sum_{i = 1}^{n} d_{i}}{n}$
2. Standard deviation	$σ = \sqrt{\frac{\sum_{i = 1}^{n} {(d_{i} - d_{m é d})}^{2}}{n - 1}}$
3. Security stock (Level service = 99,99%)	$E s e g = F S \times σ \times \sqrt{\frac{L T}{P P}}$
4. Monthly lower stock level	$M i n_{m o n t h l y} = D_{m á x} \times L T_{m á x} + E s e g$
5. Daily lower stock level	$M i n_{d a i l y} = M i n_{m o n t h l y} / 30$
6. Stock projected	$E P_{i} = E A_{i} - P_{i}$
7. Blood bags to be collected by product (tow conditions): a) If projected stock is smaller than lower stock level, collect the number of blood bags equal to lower stock level minus projected stock; b) Otherwise, blood bags equal to zero.	$Q B_{p} = \{\begin{matrix} M i n_{d a i l y} - E P_{i} s e E P_{i} < M i n_{d a i l y} \\ 0 \end{matrix}$

Period 2012 (2^nd half)	Product	Fresh Plasma (PF)
Period 2012 (2^nd half)	Blood type	A+	B+	AB+	O+	A-	B-	AB-	O-
Monthly Forecast Error	Jul	-35	10	3	43	6	0	0	0
	Ago	23	5	2	53	0	0	0	4
	Sep	-44	2	0	-43	0	10	0	9
	Oct	-22	0	7	-23	1	0	6	15
	Nov	-52	5	0	-30	4	0	1	2
	Dec	-74	5	2	-231	0	0	0	4
Higher limit (4xMAD)		167	18	9,3	282	7	7	4,7	23
Lower limit (-4xMAD)		-167	-18	-9,3	-282	-7	-7	-5	-23

Plasma Fresco AB-
Year	Monthly demand
Year	Jul	Aug	Sept	Oct	Nov	Dec
2010	0	0	0	0	0	0
2011	0	5	0	0	0	0
2012	0	0	0	6	1	0

Product	Type
PF (Fresh Plasma)	B- (September) e AB- (October)
CP (Platelets Concentrate)	A- (October), B- (September) e AB- (October)
CPA (Platelet Concentrate by Apheresis)	B+ (December) e AB- (October)
CHPL (Blood Cell Concentrate Poor in Leukocyte)	B- (October)
CHP (Pediatric red blood cells)	AB+ (October) e A- (December)
CRIO (Cryoprecipitate)	B+ (August), AB- (October) e O- (October)

Year	Monthly demand
Year	Jul	Aug	Sep	Oct	Nov	Dec
2010	0	0	0	0	0	0
2011	0	5	0	0	0	0
2012	0	0	0	6	1	0

Universidade Federal de São Carlos Departamento de Engenharia de Produção , Caixa Postal 676 , 13.565-905 São Carlos SP Brazil, Tel.: +55 16 3351 8471 - São Carlos - SP - Brazil
E-mail: gp@dep.ufscar.br

Acompanhe os números deste periódico no seu leitor de RSS

[1] Legend: dméd = average demand; di = demand of period i; n = number of periods; i = period index (i = 1, 2, 3,..., n); σ = standard deviation for future demand; Eseg = security stock; FS = security factor; LT = lead time for supply; PP = Frequency of the standard deviation; Dmáx = maximum demand; LTmáx = maximum processing lead time; Minmonthly = monthly minimum stock level; Mindaily= daily lower stock level; EPi= project stock for period i; EAi= current stock for period i; Pi= forecast for period i; QBp=quantity of blood bags necessary for product p.