SupplyIQCascade Ridge Medical Center
Today

Prefilled Saline Flush Syringe, 10 mL

Injection & SharpsVital, 99% service targetPrimary vendor Meridian Medical Supply, lead 1.5 days, ordered every 7 daysMMS-596692

Stock position

On hand
11,472 each15.2 days of supply
On order
0 eachnothing open
Forecast rate
755.5 each/daynext 30 days
Demand over 9 days
6,925 eachlead time plus review period
Safety stock
1,351 eachempirical 99th percentile of forecast error
Reorder point
8,276 eachabove
Stockout
Wed Sep 30
Recommended order
noneby Sat Sep 26
Inventory value
$5,507at $0.48 per each

How the forecast was made

Exponential smoothing10% weekly error, under-forecast59% better than naive

A weighted recent average that learns the weekday pattern and any trend. Recent days count more than old ones.

Report card: the model was fit on history up to Tue Jul 21 and scored on the 56 days after. Weekly totals were off by 10% on average (24% day by day), and it under-forecast by 3% overall. A same-weekday-last-week guess would have been off by 23%.

08541,707todayreport card windowThu Mar 19Wed Oct 14
actual forecast, 80% and 95% range what the model said during the report card windoweach/day
0safety stock 1,351runs out Wed Sep 30tomorrowMon Oct 5
Projected on hand, each: today's stock plus open orders on their expected dates, minus the forecast, day by day.

Vendors and prices, last 90 days

VendorPart numberVendor descriptionSells byPaid per eachInvoices90-day spendPairing
Meridian Medical SupplyMMS-596692PREFILL NS FLUSH SYR 10 ML BX/30BX of 30$0.4914$28,028stand-in
Summit Clinical ProductsSC-338447PREFILL NS FLSH SYR 10 ML 180CSCS of 180$0.627$13,712stand-in

Summit Clinical Products charges $0.6244 per each for this item; Meridian Medical Supply charges $0.4902. That is 27% more on about 89,060 each a year, or $11,954 a year. No contract is on file for this Summit Clinical Products line.