SupplyIQCascade Ridge Medical Center
Today

Face Shield, Disposable, Full Length

PPENon-essential, 90% service targetPrimary vendor Meridian Medical Supply, lead 1.5 days, ordered every 7 daysMMS-065283

Stock position

On hand
581 each11.1 days of supply
On order
0 eachnothing open
Forecast rate
52.2 each/daynext 30 days
Demand over 9 days
476 eachlead time plus review period
Safety stock
9 eachempirical 90th percentile of forecast error
Reorder point
484 eachabove
Stockout
Fri Sep 25
Recommended order
noneby Wed Sep 23
Inventory value
$407at $0.70 per each

How the forecast was made

Exponential smoothing9% weekly error, over-forecast8% 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 9% on average (24% day by day), and it over-forecast by 7% overall. A same-weekday-last-week guess would have been off by 8%.

058117todayreport card windowThu Mar 19Wed Oct 14
actual forecast, 80% and 95% range what the model said during the report card windoweach/day
0safety stock 9runs out Fri Sep 25tomorrowWed Sep 30
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-065283FACE SHLD DISP FULL LNTH BX/25BX of 25$0.6314$2,250stand-in
Northwind Health DistributionNW3704547Face Shield, Disposable, Full Length - 25/BxBX of 25$0.6414$994stand-in