Demand forecasting blood products for blood inventory management: A case study of blood bank of RatchaburiHospital A Case Study: Blood Bank of Ratchaburi Hospital
Keywords:Forecasting, Blood inventory, Exponential smoothing
The purposes of this research were forecasting blood products and develop a multi-dimensional report to support blood inventory management using business intelligence and Microsoft SQL Server to manage data warehouse and data analytic in Tableau Desktop program. Forecasting the demand of red blood cells( A, B, O and AB ) blood products by the exponential smoothing method technique and evaluation of accuracy and error with Mean absolute percentage error (MAPE) and Mean absolute scaled error (MASE). The results of the management satisfaction assessment were at a good level, which could be used to support decision making in the management of blood inventory management effectively.