Development of dashboard for hospital logistics management

Abstract

Logistics as an important process in providing high quality and responsive health services has not received enough attention in the literature to date. This paper presents an initial work that attempt to fill this gap by developing a prototype of a dashboard for logistics management in hospital XYZ. The methodology used in this research is divided into intelligence, design and implementation phases. The intelligence phase starts with literature study, survey, gathering objectives and Key Performance Indicator, and collecting necessary data. The design phase consists of designing and constructing database, defining presentation model for each KPI, and designing the storyboard. The dashboard is developed based on the design in the implementation phase. Implementation using several items as samples has demonstrated the potential use of the dashboard. It was found that the item category that contributes highly to the total inventory value (50%) of the hospital has a low service level. Further investigation shows that one item in this category has very low service level because the amount of item received is lower than demand. These findings can be used by management as starting point to identify the root cause and take the necessary actions to solve the problem.