Drug Inventory Reorder Alerts and Expiration Tracking

Takes your clinic's current drug and supply count and tells you what is expired, what is about to expire, and what needs to be reordered.

VeterinarianHealth and Wellness✓ Checkedv1.0

Before and after

BEFORE · what the owner typed

Input from owner: "Northwell Animal Hospital, 2208 Lynnwell St, Pinehollow. Today is March 10, 2025. Omar Powell did the count this morning. I'm Dr. Olivia Phelps. Warn me on anything expiring in the next 60 days. Supplier is Orchardwell Veterinary Supply, 336-555-0195. meloxicam inj 5 mg/mL 10 mL vials, 3 on hand, reorder at 4, order 12, exp 4/15/2025 lot MX2291 cephalexin 250 mg tabs bottle of 100, 5 on hand, reorder at 3, order 6, exp 11/30/2025 carprofen 75 mg chewables bottle of 60, 2 on hand, reorder at 2, order 6, exp 9/30/2025 LR 1 L bags, 18 on hand, reorder at 10, order 24. 6 of them exp 2/28/2025, other 12 exp 8/31/2026 ketamine 100 mg/mL 10 mL, 2 vials, reorder at 1, order 2, exp 5/2/2025 (controlled) gabapentin 100 mg caps, 4 bottles, reorder at 2, order 4, didn't see a date on it"

AFTER · what the skill produced

Inventory alerts for Northwell Animal Hospital
Count date: March 10, 2025. Warning window: 60 days.
Summary: 6 items counted. 4 need action, 1 needs a date from you, 1 is OK.

Expired, remove from use

LR 1 L bags: 6 bags expired February 28, 2025 (10 days ago). The other 12 bags are dated 8/31/2026.

Expiring within 60 days

Meloxicam inj 5 mg/mL 10 mL, lot MX2291: 3 vials expire April 15, 2025 (36 days left).
Ketamine 100 mg/mL 10 mL (controlled substance): 2 vials expire May 2, 2025 (53 days left). Please check this against the clinic's controlled substance records.

Reorder now

Meloxicam inj 5 mg/mL 10 mL: 3 on hand, reorder point 4. Order 12.
Carprofen 75 mg chewables, bottle of 60: 2 on hand, reorder point 2. Order 6.

Stock OK

Cephalexin 250 mg tabs, bottle of 100: 5 on hand, reorder point 3, expires 11/30/2025.
LR 1 L bags: 12 usable bags, reorder point 10.

Order list for Orchardwell Veterinary Supply (336-555-0195)

Meloxicam inj 5 mg/mL, 10 mL vials: 12
Carprofen 75 mg chewables, bottle of 60: 6

Questions for the owner

Gabapentin 100 mg caps: no expiration date was found on the count. What is the date? It is not marked OK until we have it. (4 on hand, reorder point 2.)
The 6 expired LR bags: please follow the clinic's own process for removing them from stock.
Do you want to order replacement ketamine ahead of its May 2 date? Your order quantity is 2 vials.
The LR bags are now 12 usable against a reorder point of 10. Do you want to count the reorder point against usable bags only?

What it does

Takes your clinic's current drug and supply count and tells you what is expired, what is about to expire, and what needs to be reordered. It also builds a ready-to-send order list for your supplier.

Use it when: Use when a veterinary clinic needs to turn a drug or supply count into reorder alerts and expiration warnings, such as "what do we need to order," "check what's expiring," "run the inventory," or "which meds are low."