The EAHP Board, elected for three-year terms, oversees the association’s activities. Comprising directors responsible for core functions, it meets regularly to implement strategic goals. Supported by EAHP staff, the Board controls finances, coordinates congress organization, and ensures compliance with statutes and codes of conduct.
DEVELOPMENT OF A DYNAMIC STOCK MANAGEMENT TOOL: “ILIKECOMMANDS” (submitted in 2019)
European Statement
Selection, Procurement and Distribution
Author(s)
TRISTAN TERNEL, MELINDA PLACE, BERENICE GILLOTEAU, ELODIE DECHAMBENOIT, EMELINE DEVOS, FATEN ABOU-DAHER, ANAELLE DECOENE, THOMAS QUERUAU LAMERIE, FREDERIQUE DANICOURT
Why was it done?
The main purpose of developing this tool is the need to provide centralised product parameters through a unique summary screen that permits a regular monitoring of inventory, enabling us to identify the glitches before things get out of control, resolve issues the soonest to improve the stock control system (order threshold, market), maintaining compliance and documenting usage to prevent sudden shortages, in a harmonised way in order to reduce the time spent to order.
What was done?
Development of a dynamic stock management tool plugged into a computerised model (Excel©), to integrate all data needed for a stock forecast in terms of specialties, providers, therapeutic classes, last order date, supply disruptions, market, restocking time, turnover, stock, orders, security threshold, average daily consumption, average time of supply, and delivery estimated time for all pharmaceutical products in hospital.
How was it done?
It’s important to know how much you have from each product, and each dosage of the same product, through a dynamic database that’s collecting all data (product code and average daily consumption) and highlighting the order quantity threshold. This reliable inventory is updated on a daily basis with data extracted from our economic and financial management coupled with Business Object©. Using specific formulas and filters, and referring to the decision flowchart, such data allow adjusting and optimising our stock management in real time.
What has been achieved?
First, this tool has allowed us to gather all required data and, subsequently, reduced the need to another application (such as NEWAC© and MAGH2©). Second, it has allowed us to understand the mechanism of order suggestions by displaying characteristics of some sectors (such as expensive products and chemotherapy). Moreover, it improved the management of supply disruptions by showing the solution of each disrupted product in a summary table, which results in significant time saving along the drug supply chain.
What next?
An organised supply chain, a fast response to overcome and handle sudden supply shortages, as well as a huge time saving are the main reasons to rely on this efficient system, which lead to an optimised and secure patient care. Moreover, it fits any computer software, and its application is very friendly to be used in every hospital pharmacy.