INVENTORY ANALYSIS OF A MULTISPECIALTY MEDICAL CLINIC IN BANDUNG

• Main Author: Fadli, Aulia
• Format: Theses
• Language: Indonesia
• Subjects: Manajemen umum
• Online Access: https://digilib.itb.ac.id/gdl/view/57200
• Institution: Institut Teknologi Bandung

A multispecialty mother and child clinic in Bandung has a business issue where they could not achieve the Key Performance Indicator (KPI) target of 15 days in Inventory every month from July 2018 to June 2019. This KPI aims monitor the performance of the inventory. The current Days in Inventory average is 21 days. DII is influenced by 3 factors which are the inventory system, demand forecasting and operational process. The inventory process starts at the finance unit doing planning and demand forecasting, then to the pharmacy unit who procure from suppliers, and then manage the inventory depot, then the medical unit will prescribe and use items from in inventory, and the patient could receive needed service and medicine. Several root causes are found which results in high inventory cost and increases the Days in Inventory. First is the mismatch of stock optimization model and the procurement model. The stock level optimization uses the Q-model to have a fixed order quantity. However, the procurement is done weekly which are closer to the fixedtime period model or the P-model. The next root cause is the unoptimized forecasting using simple moving averages. It is considered unoptimized because there are trends and seasonality in diseases which could be forecasted. The third and last root cause is inefficiencies in inventory operations, such as the poorly set up physical inventory facilities, and medical software setup not properly, so it is difficult and a hassle for the physician to know current stock and causes outside order prescription. All the root causes lead to increase in inventory stock or failure to spend inventory. Several solution alternatives to each root causes are analyzed; the chosen plans involve implementing fixes in the procurement method and inventory processes of the clinic. Comparison of the average inventory level was calculated, and the current method, and the Q-model and P-model is compared. The Q-model calculation was found to be under the 15 days in inventory and will be used for the stock level optimization calculation and procurement method. and the inventory database system and facilities are to be improved to allow automatized data entry and retrieval, which involves help with the software system developers. Combining these solutions will allow the target KPI of 15 days in inventory to be reached.