SupplyIQCascade Ridge Medical Center
Today

Tourniquet, Disposable, Latex-Free

IV TherapyNon-essential, 90% service targetPrimary vendor Meridian Medical Supply, lead 1.5 days, ordered every 7 daysMMS-591497

Stock position

On hand
3,662 each20.8 days of supply
On order
250 eachfirst arrives Wed Sep 16
Forecast rate
176.0 each/daynext 30 days
Demand over 9 days
1,616 eachlead time plus review period
Safety stock
223 eachempirical 90th percentile of forecast error
Reorder point
1,839 eachabove
Stockout
Wed Oct 7
Recommended order
noneby Sun Oct 4
Inventory value
$439at $0.12 per each

How the forecast was made

Exponential smoothing11% weekly error, unbiased13% 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 11% on average (24% day by day), and it showed no systematic bias. A same-weekday-last-week guess would have been off by 12%.

0198395todayreport card windowThu Mar 19Wed Oct 14
actual forecast, 80% and 95% range what the model said during the report card windoweach/day
0safety stock 223runs out Wed Oct 7tomorrowMon Oct 12
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-591497TOURN DISP LF BX/250BX of 250$0.1113$1,565stand-in
Summit Clinical ProductsSC-726991TOURN DISP LF 250BXBX of 250$0.116$171stand-in