I'm part of a small global health organization based out of Indianapolis, Indiana. Our organization works primarily by sending medical brigades consisting of college students or professional organizations and medical professionals to Guatemala, Ecuador, and the Dominican Republic. There, clinics are set up with the help of local partner organizations and on-the-ground employees that provide acute medical care and refer (and pay for) individuals to receive care for more chronic ailments.
Currently, our inventory management system is borderline nonexistent, consisting of rough counts in our warehouse prior to brigades. Medications and supplies are then sent with the brigade members in suitcases to the sites abroad. My goal is to implement an inventory management system that can give real time counts of on-hand supplies that can help to better forecast procurement schedules. In addition, a shipping method needs to be developed that, in short, doesn't involve students carrying supplies across borders.
I'm just wondering if any of you have come across similar problems or have solutions in place that address mine at this time. Excel seems like a simple/cost-effective solution, but I'm not at all opposed to exploring other software options. I hope my request has not been too vague and I am looking forward to filling in any gaps through your questions. Much thanks in advance for your correspondence.