Inventory & Usage Analysis

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

Tuesday, March 17, 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

Pharmacy — Pfizer

90 / 400CRITICAL

Suture — Vicryl 3-0

Operating Rooms — Ethicon (J&J)

30 / 400CRITICAL

Ventilator Circuit (Adult)

ICU — Fisher & Paykel

0 / 100OUT OF STOCK

Normal Saline 0.9% 1000mL

Materials Management — Baxter International

1800 / 4000CRITICAL

Low Stock (18)

N95 Respirator Masks

Materials Management — 3M Healthcare

6400 / 10000Reorder at 5000

IV Catheter 20G

Emergency Department — BD Medical

900 / 1200Reorder at 600

Foley Catheter 16Fr

Med/Surg — Teleflex

420 / 600Reorder at 240

Sterile Surgical Gown (L)

Operating Rooms — Halyard Health

1080 / 1600Reorder at 800

Sterile Surgical Gown (XL)

Operating Rooms — Halyard Health

620 / 1000Reorder at 500

Lactated Ringer's 1000mL

Materials Management — Baxter International

1200 / 2500Reorder at 1200

D5W 1000mL

Materials Management — Baxter International

900 / 1500Reorder at 750

Insulin Glargine 100U/mL (Lantus)

Pharmacy — Sanofi

120 / 200Reorder at 80

Cisplatin 50mg/50mL

Oncology / Cancer Center — Fresenius Kabi

65 / 100Reorder at 40

Pembrolizumab 100mg/4mL (Keytruda)

Oncology / Cancer Center — Merck

24 / 40Reorder at 15

Bone Cement 40g

Operating Rooms — Stryker

48 / 80Reorder at 30

Bone Graft Substitute 10cc

Operating Rooms — Medtronic

22 / 40Reorder at 15

High-Flow Nasal Cannula Kit

ICU — Fisher & Paykel

65 / 100Reorder at 40

Humidifier Chamber (MR850)

ICU — Fisher & Paykel

40 / 60Reorder at 25

Pressure Injury Prevention Mattress Overlay

Med/Surg — Stryker

30 / 50Reorder at 20

Magnesium Sulfate 4g/100mL IV

Labor & Delivery — Fresenius Kabi

80 / 120Reorder at 50

Intracranial Pressure Monitor Kit

Neurosciences — Integra LifeSciences

15 / 25Reorder at 10

Cell Saver Tubing Set

Operating Rooms — Haemonetics

25 / 40Reorder at 15

Expiring Soon (2)

Propofol 200mg/20mL

Pharmacy — 360 units

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

Rapid COVID-19 Antigen Test

Emergency Department — 4200 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