Independent compounding pharmacy
~25 employees
Compounding pharmacy
~300 consumable inventory items
This pharmacy produces custom medications while managing a constant flow of consumables used in compounding, packaging, and shipping. Items move daily across storage areas and workstations, and availability directly affects production continuity.
In parallel, the team tracks staff licenses, certifications, and issued safety equipment, all of which require accurate records and timely renewals to stay compliant.
Missing information or delayed updates create immediate operational risk.
Result: A single system where inventory, supplier data, and staff compliance stay connected and updated in real time.
In practice, that meant:
The team relied on multiple spreadsheets split by category (inventory, staff, safety equipment) and maintained by different people.
To maintain these spreadsheets, staff regularly walked through storage areas to manually count consumables and safety equipment, then returned to update the spreadsheets later, adding more delay and inconsistency.
Alerts for low inventory or license expiration did not exist, history for controlled medications was difficult to track, barcode labels already existed, though they were not used for tracking movements.
Staff scans items as they are used or restocked. Each scan records the movement instantly, so stock levels stay accurate during compounding instead of being updated later.
Each item holds its stock level, location, supplier, and movement history in one place, allowing the team to see what is available and where it is stored without checking multiple files.
Low-stock thresholds trigger alerts based on actual usage, allowing the team to reorder before shortages affect production.
Inventory items connect to supplier records, so purchasing decisions use recent pricing and vendor history instead of searching through invoices.
Licenses, certifications, and issued equipment stay attached to each employee record, with alerts triggered automatically before expiration dates.
Inventory reconciliation time reduced from ~3 hours per week to under 30 minutes
Manual data entry for stock movements reduced by ~70%
Stockouts reduced by ~30–50% through earlier low-stock visibility
Inventory checks completed in minutes instead of manual shelf counts
License tracking moved from manual reminders to automated alerts before expiration dates
