Attached is a file which may be helpful forecasting how many days of drug may be left with current usage rates, inventory, and rate of change. PHI is stripped out, but the file retains the formulas, logic, and named references for institutions to adapt to their use. The estimated days remaining is based on maximum usage in the last 14 days to assume a worst-case scenario. Feel free to change this logic as needed. Hope this helps the COVID effort!
Kindest Regards,
Michael Van Ornum
Clinical Medication Safety Pharmacist
