Sodium Chloride Injection, 0.9%, 1000 mL Bag
Stock position
- On hand
- 7,230 bag17.1 days of supply
- On order
- 0 bagnothing open
- Forecast rate
- 422.0 bag/daynext 30 days
- Demand over 4 days
- 1,817 baglead time plus review period
- Safety stock
- 725 bagempirical 99th percentile of forecast error
- Reorder point
- 2,542 bagabove
- Stockout
- Thu Oct 1
- Recommended order
- noneby Tue Sep 29
- Inventory value
- $13,376at $1.85 per bag
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 (27% day by day), and it showed no systematic bias. A same-weekday-last-week guess would have been off by 10%.
Report card, week by week
| Week of | Used | Forecast | Error | Error % |
|---|---|---|---|---|
| Tue Jul 21 | 2,533 | 2,912 | +379 | 15% |
| Tue Jul 28 | 2,725 | 2,912 | +187 | 7% |
| Tue Aug 4 | 3,913 | 2,912 | -1,001 | 26% |
| Tue Aug 11 | 3,098 | 2,912 | -186 | 6% |
| Tue Aug 18 | 3,100 | 2,912 | -188 | 6% |
| Tue Aug 25 | 2,844 | 2,912 | +68 | 2% |
| Tue Sep 1 | 2,689 | 2,912 | +223 | 8% |
| Tue Sep 8 | 2,820 | 2,912 | +92 | 3% |
| All 8 weeks | 23,722 | 23,300 | -422 | 2% |
Weekly totals in bag. 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
Lots and expiry
Earliest-expiry-first simulation against the forecast. Waste is what remains in a lot on its expiry date.
| Lot | Quantity | Expires | Days | Unit cost | Projected waste |
|---|---|---|---|---|---|
| L00092 | 4,071 | Tue Dec 15 | 92 | $1.85 | 0 bag · $0 |
| L00093 | 3,159 | Fri Jan 15 | 123 | $1.85 | 0 bag · $0 |
Vendors and prices, last 90 days
| Vendor | Part number | Vendor description | Sells by | Paid per bag | Invoices | 90-day spend | Pairing |
|---|---|---|---|---|---|---|---|
| Harborline Pharmaceuticals | 46163030010 | NA CHLORIDE 900 MG/100ML BAG EA | EA of 1 | $1.63 | 31 | $41,459 | NDC exact |
| Cobalt Rx Distributors | CRX-25945 | SODIUM 900MG/100ML BAG 12CT | CS of 12 | $2.18 | 13 | $37,858 | reviewed 0.90 |
Cobalt Rx Distributors charges $2.1802 per bag for this item; Harborline Pharmaceuticals charges $1.6317. That is 34% more on about 70,421 bag a year, or $38,631 a year. No contract is on file for this Cobalt Rx Distributors line.