SupplyIQCascade Ridge Medical Center
Today

Syringe, 3 mL, Luer Lock

Injection & SharpsEssential, 95% service targetPrimary vendor Meridian Medical Supply, lead 1.5 days, ordered every 7 daysMMS-448929

Stock position

On hand
10,136 each18.2 days of supply
On order
0 eachnothing open
Forecast rate
556.6 each/daynext 30 days
Demand over 9 days
5,127 eachlead time plus review period
Safety stock
852 eachempirical 95th percentile of forecast error
Reorder point
5,979 eachabove
Stockout
Fri Oct 2
Recommended order
noneby Tue Sep 29
Inventory value
$1,318at $0.13 per each

How the forecast was made

Exponential smoothing11% weekly error, under-forecast7% worse 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 11% on average (24% day by day), and it under-forecast by 5% overall. A same-weekday-last-week guess would have been off by 10%.

05901,179todayreport card windowThu Mar 19Wed Oct 14
actual forecast, 80% and 95% range what the model said during the report card windoweach/day
0safety stock 852runs out Sat Oct 3tomorrowThu Oct 8
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-448929SYR 3 ML LUER LK BX/100BX of 100$0.1215$7,161stand-in