SupplyIQCascade Ridge Medical Center
Today

Nitrile Exam Gloves, Medium, Powder-Free

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

Stock position

On hand
47,380 each22.3 days of supply
On order
0 eachnothing open
Forecast rate
2124.9 each/daynext 30 days
Demand over 9 days
19,498 eachlead time plus review period
Safety stock
2,669 eachempirical 90th percentile of forecast error
Reorder point
22,167 eachabove
Stockout
Wed Oct 7
Recommended order
noneby Sun Oct 4
Inventory value
$4,027at $0.09 per each

How the forecast was made

Exponential smoothing7% weekly error, under-forecast60% 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 (22% day by day), and it under-forecast by 5% overall. A same-weekday-last-week guess would have been off by 17%.

02,4424,885todayreport card windowThu Mar 19Wed Oct 14
actual forecast, 80% and 95% range what the model said during the report card windoweach/day
0safety stock 2,669runs 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-412029NITRILE EXAM GLOVE MED PF BX/100BX of 100$0.0813$10,750stand-in
Northwind Health DistributionNW7815444Nitrile Exam Gloves, Medium, Powder-Free - 1000/CsCS of 1,000$0.1013$8,710stand-in

Northwind Health Distribution charges $0.1037 per each for this item; Meridian Medical Supply charges $0.0785. That is 32% more on about 340,667 each a year, or $8,576 a year. No contract is on file for this Northwind Health Distribution line.