SupplyIQCascade Ridge Medical Center
Today

Surgical Gown, Sterile, Reinforced, Large

SurgicalEssential, 95% service targetPrimary vendor Meridian Medical Supply, lead 1.5 days, ordered every 7 daysMMS-642364

Stock position

On hand
472 each9.6 days of supply
On order
30 eachfirst arrives Wed Sep 16
Forecast rate
49.0 each/daynext 30 days
Demand over 9 days
468 eachlead time plus review period
Safety stock
14 eachempirical 95th percentile of forecast error
Reorder point
481 eachabove
Stockout
Thu Sep 24
Recommended order
noneby Tue Sep 22
Inventory value
$3,021at $6.40 per each

How the forecast was made

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

080161todayreport card windowThu Mar 19Wed Oct 14
actual forecast, 80% and 95% range what the model said during the report card windoweach/day
0safety stock 14runs out Thu Sep 24tomorrowTue Sep 29
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-642364SURG GOWN STRL REINF LG CS/30CS of 30$6.0214$25,471stand-in
Summit Clinical ProductsSC-171359SURG GOWN STRL REINF LG 30CSCS of 30$6.247$2,994stand-in