SupplyIQCascade Ridge Medical Center
Today

Pulse Oximeter Sensor, Adult, Disposable

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

Stock position

On hand
281 each13.8 days of supply
On order
0 eachnothing open
Forecast rate
20.4 each/daynext 30 days
Demand over 9 days
187 eachlead time plus review period
Safety stock
37 eachempirical 95th percentile of forecast error
Reorder point
224 eachabove
Stockout
Mon Sep 28
Recommended order
noneby Thu Sep 24
Inventory value
$2,501at $8.90 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 (30% day by day), and it under-forecast by 8% overall. A same-weekday-last-week guess would have been off by 10%.

02550todayreport card windowThu Mar 19Wed Oct 14
actual forecast, 80% and 95% range what the model said during the report card windoweach/day
0safety stock 37runs out Mon Sep 28tomorrowSat Oct 3
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-521988PULSE OX SNSR ADLT DISP BX/24BX of 24$7.7713$10,812stand-in
Northwind Health DistributionNW1948596Pulse Oximeter Sensor, Adult, Disposable - 24/BxBX of 24$7.7914$4,860stand-in