Financials
Inventory budget tracking, purchase orders, and delivery cost forecasting
$34.2M
Annual Inventory Budget
FY 2025-26
$14.61M
YTD Spend
$357K over budget
$6.06M
Current Inventory Value
Total value on shelves right now
$16.7K
Pending Purchase Orders
6 orders in pipeline
$7.2K
In-Transit Shipments
3 deliveries expected
Monthly Inventory Spend vs. Budget
Blue bars show actual spend each month. The gray dashed line is the allocated budget. After March, the green bars show the AI's forecast of what the hospital will spend, based on scheduled surgeries, seasonal patterns, and current supply prices.
AI forecast note: April spend is projected $32K above budget due to the flu surge driving higher PPE and medication orders. June also trends high because of 3 additional spinal fusion cases added to the OR schedule.
Budget Allocation by Supply Category
Annual budget, year-to-date spend, and AI-projected full-year spend
| Category | Annual Budget | YTD SpendYear-to-date actual spend | YTD BudgetYear-to-date budgeted amount | Variance | AI Full-Year ForecastAI-projected total spend by end of fiscal year, based on trends and scheduled procedures | vs. Budget |
|---|---|---|---|---|---|---|
| PPE & Safety | $4,260K | $1,926K | $1,776K | +150K | $4,620K | +360K |
| Medications (Non-Controlled) | $8,550K | $3,540K | $3,564K | -24K | $8,490K | -60K |
| Controlled Substances | $2,040K | $885K | $849K | +36K | $2,130K | +90K |
| Surgical Supplies | $9,600K | $4,140K | $3,999K | +141K | $9,930K | +330K |
| Laboratory Supplies | $2,670K | $1,095K | $1,113K | -18K | $2,625K | -45K |
| Respiratory / ICU | $2,160K | $936K | $900K | +36K | $2,250K | +90K |
| General Medical Supplies | $4,920K | $2,085K | $2,049K | +36K | $4,980K | +60K |
| Total | $34.2M | $14.61M | $14.25M | +357K | $35.0M | +825K |