Inventory & Usage Analysis

Current inventory health, consumption patterns, anomaly detection, and cost optimization

Friday, May 1, 2026

71

In Stock

18

Low Stock

4

Critical / OOS

2

Expiring Soon

$619K

On-Hand Value

6

AI Alerts

Daily Supply Consumption — Actual vs. AI Predicted

Total supply items consumed hospital-wide per day. The solid blue line is what was actually used. The dashed green line is what the AI predicted. Comparing these shows how accurate our forecasting is and where consumption is deviating from expectations.

Actual consumption
AI predicted
90% confidence range

Usage by Department

How many items each department consumes per day. Red predicted bars mean the AI expects a >10% increase — usually driven by scheduling or seasonal factors.

Current daily usage
AI predicted (next 7 days)
>10% increase expected

Inventory Value on Shelves

Dollar value of stock currently held by each department, with average days of supply on hand.

Materials Management
$974K18.4d
Pharmacy
$1785K12.1d
Operating Rooms
$1291K8.7d
Emergency Department
$468K6.2d
Laboratory
$357K14.5d
Intensive Care Unit
$625K9.3d
Med/Surg
$314K11.6d
Labor & Delivery
$249K15.2d
Total on-hand value$6.06M

Critical & Out of Stock (4)

Heparin Sodium 5000U/mL

PharmacyPfizer

90 / 400CRITICAL

Suture — Vicryl 3-0

Operating RoomsEthicon (J&J)

30 / 400CRITICAL

Ventilator Circuit (Adult)

ICUFisher & Paykel

0 / 100OUT OF STOCK

Normal Saline 0.9% 1000mL

Materials ManagementBaxter International

1800 / 4000CRITICAL

Low Stock (18)

N95 Respirator Masks

Materials Management3M Healthcare

6400 / 10000Reorder at 5000

IV Catheter 20G

Emergency DepartmentBD Medical

900 / 1200Reorder at 600

Foley Catheter 16Fr

Med/SurgTeleflex

420 / 600Reorder at 240

Sterile Surgical Gown (L)

Operating RoomsHalyard Health

1080 / 1600Reorder at 800

Sterile Surgical Gown (XL)

Operating RoomsHalyard Health

620 / 1000Reorder at 500

Lactated Ringer's 1000mL

Materials ManagementBaxter International

1200 / 2500Reorder at 1200

D5W 1000mL

Materials ManagementBaxter International

900 / 1500Reorder at 750

Insulin Glargine 100U/mL (Lantus)

PharmacySanofi

120 / 200Reorder at 80

Cisplatin 50mg/50mL

Oncology / Cancer CenterFresenius Kabi

65 / 100Reorder at 40

Pembrolizumab 100mg/4mL (Keytruda)

Oncology / Cancer CenterMerck

24 / 40Reorder at 15

Bone Cement 40g

Operating RoomsStryker

48 / 80Reorder at 30

Bone Graft Substitute 10cc

Operating RoomsMedtronic

22 / 40Reorder at 15

High-Flow Nasal Cannula Kit

ICUFisher & Paykel

65 / 100Reorder at 40

Humidifier Chamber (MR850)

ICUFisher & Paykel

40 / 60Reorder at 25

Pressure Injury Prevention Mattress Overlay

Med/SurgStryker

30 / 50Reorder at 20

Magnesium Sulfate 4g/100mL IV

Labor & DeliveryFresenius Kabi

80 / 120Reorder at 50

Intracranial Pressure Monitor Kit

NeurosciencesIntegra LifeSciences

15 / 25Reorder at 10

Cell Saver Tubing Set

Operating RoomsHaemonetics

25 / 40Reorder at 15

Expiring Soon (2)

Propofol 200mg/20mL

Pharmacy360 units

Expires: 2026-06-15$4,500 at risk

Rapid COVID-19 Antigen Test

Emergency Department4200 units

Expires: 2026-04-30$22,050 at risk

AI Alerts — Outbreak Intel, Predictions & Recommendations

Outbreak intelligence, demand predictions, anomaly detection, cost-saving opportunities, and compliance gaps detected by the AI.

Full Analysis

Fentanyl usage in ICU has increased 47% over the past 5 days without a corresponding increase in patient census or acuity scores. Pattern deviates significantly from historical norms.

Recommended Action

Flag for pharmacy review and controlled substance audit. Cross-reference with patient administration records.

Projected Impact

Potential diversion risk — requires immediate investigation

Health Canopy AI

Inventory intelligence agent

Hi! I'm your inventory AI agent.

I have real-time access to UCSF's inventory across all 5 campuses, purchase orders, equipment maintenance, compliance data, and AI forecasts.

Scripted demo — responses reflect UCSF inventory data