Prefilled Saline Flush Syringe, 10 mL
Stock position
- On hand
- 11,472 each15.2 days of supply
- On order
- 0 eachnothing open
- Forecast rate
- 755.5 each/daynext 30 days
- Demand over 9 days
- 6,925 eachlead time plus review period
- Safety stock
- 1,351 eachempirical 99th percentile of forecast error
- Reorder point
- 8,276 eachabove
- Stockout
- Wed Sep 30
- Recommended order
- noneby Sat Sep 26
- Inventory value
- $5,507at $0.48 per each
How the forecast was made
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 10% on average (24% day by day), and it under-forecast by 3% overall. A same-weekday-last-week guess would have been off by 23%.
Report card, week by week
| Week of | Used | Forecast | Error | Error % |
|---|---|---|---|---|
| Tue Jul 21 | 5,144 | 5,233 | +89 | 2% |
| Tue Jul 28 | 5,904 | 5,233 | -671 | 11% |
| Tue Aug 4 | 6,270 | 5,233 | -1,037 | 17% |
| Tue Aug 11 | 5,519 | 5,233 | -286 | 5% |
| Tue Aug 18 | 5,475 | 5,233 | -242 | 4% |
| Tue Aug 25 | 4,752 | 5,233 | +481 | 10% |
| Tue Sep 1 | 4,375 | 5,233 | +858 | 20% |
| Tue Sep 8 | 5,729 | 5,233 | -496 | 9% |
| All 8 weeks | 43,168 | 41,861 | -1,307 | 3% |
Weekly totals in each. Error is forecast minus what was used, so a positive number means the model ran high. This window was hidden from the model when it was fit.
Demand forecast
last 180 days and the next 30The model only knows the usage history. If you know something it does not, a coming surge, a new service line, a product being dropped, adjust the forecast and the stock math follows.
Projected on hand
Vendors and prices, last 90 days
| Vendor | Part number | Vendor description | Sells by | Paid per each | Invoices | 90-day spend | Pairing |
|---|---|---|---|---|---|---|---|
| Meridian Medical Supply | MMS-596692 | PREFILL NS FLUSH SYR 10 ML BX/30 | BX of 30 | $0.49 | 14 | $28,028 | AI 0.88 |
| Summit Clinical Products | SC-338447 | PREFILL NS FLSH SYR 10 ML 180CS | CS of 180 | $0.62 | 7 | $13,712 | AI 0.80 |
Summit Clinical Products charges $0.6244 per each for this item; Meridian Medical Supply charges $0.4902. That is 27% more on about 89,060 each a year, or $11,954 a year. No contract is on file for this Summit Clinical Products line.