Creation of Inventory Management System using Excel Macros
Care Process & Redesign
Technology
National Healthcare Innovation and Productivity Medals
National University Health System
31 December 2024
Develop an Excel-based inventory management system that tracks stock movements, records user entries, and provides. The system successfully improved inventory accuracy and reduced wastage.
Year Submitted: 2024
Published Date: 31 December 2024
Tags: Technology, Care Process ＆ Redesign, Digital Health, Digitalisation, Data Management, Automation, Robotics/Autonomous Systems, Operational Management, Inventory Management
About this Content
Aims
Develop an Excel-based inventory management system that tracks stock movements, records user entries, and provides data-driven ordering recommendations.
Background
Nursing consumable stores in National University Polyclinics previously used Excel for stock tracking, but manual updates led to lost records, discrepancies, and inefficiencies in stock management.
Methods
Implemented Excel Macros for automated stock tracking, entry logging, and data-driven suggestions. Enhanced system security to prevent tampering and ensured accessibility for clinic teams.
Results
Discrepancies in stock audits reduced by 81% after implementation, improving inventory accuracy and order efficiency. Clinics reported better decision-making and improved tracking of consumables.
Conclusion
The system successfully improved inventory accuracy and reduced wastage. Further enhancements will refine automation features and optimize system performance.
Lessons Learnt
Macro-based solutions require rigorous testing before deployment. Future improvements should focus on usability and reducing complexity in coding.
Keywords
Nursing Consumable Store, Polyclinic, Supply of Stock, Wound Dressing, Tamper Proof, Excel Macro
Innovators' Details
Innovators' Details
Healthcare Cluster(s) | National University Health System |
Organization(s) Involved | National University Polyclinics |
Platform(s) | National Healthcare Innovation and Productivity Medals |
Healthcare Professional Group(s) | Allied Health, Nursing |
Applicable Specialty or Discipline | Healthcare Administrators, General Medicine, Wound Care Medicine |
Project Lead(s) | Tan Jin Yang |
Project Member(s) | Gladys Kang Hui Min |
Connect with this contributor!
Tan Jin Yang - Jin_Yang_Tan@nuhs.edu.sg
Project Attachment
417_NUP_NHIP_2024_Creation_of_inventory_management_system_using_Excel_Macros.pdf