Supply Chain Analytics
Cost optimization, vendor performance, and operational efficiency metrics
$856K
Total Monthly Spend
vs. $915K budget
12.8x
Inventory TurnoverHow many times inventory cycles through per year — higher means more efficient use of capital
Annual average
3.2 days
Avg Lead Time
Across all vendors
96.8%
Fill RatePercentage of orders delivered complete on first shipment
Last 30 days
$90K
Waste & Expiration
YTD savings vs. prior
24
Active Vendors
Monthly Spend vs. Budget
Tracking actual spend against allocated budget
Waste & Loss Breakdown
YTD total: $90,000 — down 12% from prior year
AI Recommendation: FEFOFirst Expired, First Out — prioritize items closest to expiry enforcement on 12 medication SKUs could reduce expiration waste by $18,200/year.
Vendor Performance Scorecard
Tracking on-time delivery, fill rate, and lead times across key suppliers
| Vendor | On-Time %Percentage of orders delivered by the promised date | Fill Rate %Percentage of ordered items delivered complete on first shipment | Avg Lead (days) | Orders | Spend |
|---|---|---|---|---|---|
| Medline Industries | 96.2% | 98.5% | 2.1 | 426 | $861K |
| Cardinal Health | 93.8% | 97.2% | 2.8 | 294 | $642K |
| BD Medical | 91.5% | 95.8% | 3.4 | 228 | $534K |
| McKesson | 94.1% | 96.9% | 2.3 | 360 | $1026K |
| Pfizer | 89.7% | 94.1% | 5.2 | 102 | $468K |
| Medtronic | 97.3% | 99.1% | 4.1 | 84 | $1236K |
Inventory Turnover by Department
Actual vs. industry benchmark — higher is more efficient
Insight: OR turnover (8.7x) is 13% below benchmark. Review PAR levels and preference card accuracy to reduce excess.