Skip to content

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.

×

Deadline extended to July 15th

Problems caused by shortages are serious, threaten patient care and require urgent action.

Help us provide an overview of the scale of the problem, as well as insights into the impact on overall patient care.

Our aim is to investigate the causes of medicine and medical device shortages in the hospital setting,  while also gathering effective solutions and best practices implemented at local, regional, and national levels.

×

Join us in Prague for the 2nd edition of BOOST!

Secure your spot in the Movement for Shortage-Free World

BOOST is where visionaries, innovators, and healthcare leaders come together to tackle one of the biggest challenges in hospital pharmacy—medicine shortages.