General discussion
-
Topic
-
Excel, inventory
LockedI am trying to build an inventory system for a medical practice that uses 7 expensive drugs. Currently, they have only one person keeping track. I would like to set up so we have a check on whether the staff is keeping good track of these drugs (as I found one injection in the trash can!). I am thinking:
Beginning inventory (Qty) + Purchases (Qty) – ending inventory (Qty) = Qty used for the period.I can find a report for the orders placed for the month (purchases) and if I get the beginning inventory #s from the staff and match the qty used with a report I get from patient accounts, we should be able to see if the staff is reporting accurate numbers every month.
Please suggest how I should build a template for the staff to keep record and also advise if my formula above is going to report accurate quantity used for the monht.