Automation of Daily Cycle Count Generation
Care Process & Redesign
Technology
National University Health System Quality Improvement
National University Health System
31 December 2023
Automate daily cycle count generation, reducing time required by 75% (from 2 minutes to under 30 seconds). The automation system improved time management, ensuring faster and more accurate inventory processes.
Year Submitted: 2023
Published Date: 31 December 2023
Tags: Technology, Care Process ＆ Redesign, Digitalisation, Operational Management, Inventory Management
About this Content
Aims
Automate daily cycle count generation, reducing time required by 75% (from 2 minutes to under 30 seconds).
Background
Manual cycle counts were time-consuming and prone to inconsistencies, requiring significant staff effort.
Methods
Designed an Excel VBA-powered system to automate list generation and track discrepancies.
Results
Achieved an 82% reduction in cycle count generation time, improving efficiency and accuracy.
Conclusion
The automation system improved time management, ensuring faster and more accurate inventory processes.
Lessons Learnt
Automation simplifies repetitive tasks and enhances operational efficiency; scalable to other pharmacy sections.
Keywords
Cycle Count, Pharmacy, Automation, Inventory, Technology
Innovators' Details
Innovators' Details
Healthcare Cluster(s) | National University Health System |
Organization(s) Involved | Ng Teng Fong General Hospital |
Platform(s) | National University Health System Quality Improvement |
Healthcare Professional Group(s) | Allied Health, Pharmacy |
Applicable Specialty or Discipline | Pharmacology |
Project Lead(s) | Tan Matthew |
Project Member(s) | Stacey Ng |
Connect with this contributor!
Matthew Tan - matthew_tan_quan_sheng@nuhs.edu.sg
Project Attachment
C_360_NTFGH_QM_2023_Automation_of_daily_cycle_count_generation.pdf