Filgrastim Injection, 480 mcg/0.8 mL Prefilled Syringe
Stock position
- On hand
- 55 syringe55 days of supply
- On order
- 3 syringefirst arrives Mon Sep 14
- Forecast rate
- 1.0 syringe/daynext 30 days
- Demand over 4 days
- 4 syringelead time plus review period
- Safety stock
- 4 syringeempirical 95th percentile of forecast error
- Reorder point
- 8 syringeabove
- Stockout
- Sun Nov 8
- Recommended order
- noneby Wed Nov 4
- Inventory value
- $10,450at $190.00 per syringe
How the forecast was made
This item is used on fewer than 60% of days, so the forecast is 'how much when it's used' times 'how often it's used', each updated daily.
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 2.9 syringe a week, and it over-forecast by 28% overall. A same-weekday-last-week guess would have been off by 54%. This item had no usage on 52% of days, so the intermittent method is used.
Report card, week by week
| Week of | Used | Forecast | Error | Error % |
|---|---|---|---|---|
| Tue Jul 21 | 4 | 7 | +3 | 75% |
| Tue Jul 28 | 7 | 7 | -0 | 0% |
| Tue Aug 4 | 3 | 7 | +4 | 133% |
| Tue Aug 11 | 8 | 7 | -1 | 13% |
| Tue Aug 18 | 2 | 7 | +5 | 250% |
| Tue Aug 25 | 10 | 7 | -3 | 30% |
| Tue Sep 1 | 1 | 7 | +6 | 600% |
| Tue Sep 8 | 8 | 7 | -1 | 13% |
| All 8 weeks | 43 | 55 | +12 | 28% |
Weekly totals in syringe. 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 |
|---|---|---|---|---|---|
| L00116 | 40 | Wed Oct 14 | 30 | $190.00 | 10 syringe · $1,899 |
| L00118 | 11 | Mon Mar 29 | 196 | $190.00 | 0 syringe · $0 |
| L00117 | 4 | Sat Aug 7 | 327 | $190.00 | 0 syringe · $0 |
Vendors and prices, last 90 days
| Vendor | Part number | Vendor description | Sells by | Paid per syringe | Invoices | 90-day spend | Pairing |
|---|---|---|---|---|---|---|---|
| Harborline Pharmaceuticals | 00069029101 | FILGRASTIM-AAFI 300 UG/.5ML SYR EA | EA of 1 | $166.58 | 24 | $17,491 | NDC exact |
| Summit Clinical Products | SC-469213 | FILGRA 300UG/.5ML PFS 1CT | EA of 1 | $173.25 | 6 | $1,559 | reviewed 0.90 |