Blog · Procurement and supply chain · Healthcare
Healthcare supply chain analytics compares medical supply usage, availability, expiration losses, and supplier service by facility. Work through a reconciled inventory example and see which records explain each exception.
Healthcare supply chain analytics connects medical supply usage, availability, expiration, and supplier service at each facility. Start with reconciled inventory movements, then compare fulfilled requests and deliveries against their own denominators. A facility with more stock can still have worse availability if the stock does not match local needs.
The useful question is specific: which facility cannot obtain the supply item it requests, and what do the inventory and delivery records show? A network spending total cannot answer that. Keep an item identifier, package unit, facility, and reporting period on every comparison.
Separate current operations from future estimates. Healthcare supply predictions test forecasts against later usage and expiration exposure; this review establishes what happened and what stock remains. The wider supply chain analytics guide covers the broader service, inventory, and cost framework.
Use supply records appropriate to the operational question. An administrative comparison of stock movements does not require patient identities, diagnoses, or treatment details. Define the items and facilities included before extracting the files, so changes in scope do not appear as changes in performance.
Use an inventory snapshot and movement register for stock, a request register for fulfillment, and purchase order receipts for supplier service. Their rows describe different events; reconcile them separately before comparing their totals.
| File | Essential columns | What it establishes |
|---|---|---|
| Inventory movements | Facility, item, movement ID, date, unit, quantity, reason | Receipts, usage, transfers, and losses |
| Inventory snapshot | Facility, item, lot, expiration, stock status, quantity | Closing stock and restrictions |
| Supply requests | Request line ID, facility, item, requested and fulfilled quantities | Availability to the requesting facility |
| Supplier receipts | Purchase order line, promised date, receipt date, supplier | Delivery performance |
Keep lot and expiration detail when the source contains it. The FDA's UDI explanation distinguishes a device identifier from production information, which can include lot, batch, and expiration fields when present on the label. A product identifier alone therefore does not establish the expiration of stock on a shelf.
Retain the original unit and an approved conversion to the reporting unit. Do not assume every supplier's box contains the same number of individual packages. Keep a conversion exception separate from a genuine inventory discrepancy.
Consider a fictional US healthcare operator reviewing September 2026. Both facilities carry the same supply pack at a recorded cost of $4 per pack. The example has no transfers, returns, or adjustments other than expiration losses.
Closing packs = Opening packs + Received packs − Used packs − Expired packs
| Facility | Opening packs | Received packs | Used packs | Expired packs | Closing packs |
|---|---|---|---|---|---|
| East | 900 | 1,400 | 1,650 | 50 | 600 |
| West | 700 | 1,100 | 1,200 | 100 | 500 |
| Total | 1,600 | 2,500 | 2,850 | 150 | 1,100 |
East reconciles as 900 + 1,400 − 1,650 − 50 = 600 packs. West reconciles as 700 + 1,100 − 1,200 − 100 = 500. Together, 1,600 + 2,500 − 2,850 − 150 = 1,100, matching the closing snapshot.
Recorded expiration loss is 50 × 4 = $200 at East and 100 × 4 = $400 at West, totaling $600. These are recorded expired units removed during the month. Stock approaching expiration at month end is a separate exposure measure and should not be added to this historical loss.
The identity is a diagnostic check. A difference could mean an omitted transfer, a unit conversion error, or an adjustment posted after the snapshot. Resolve that difference before explaining usage changes to facility managers.
The request register and delivery register for the same review contain these totals. Fulfilled packs in this simplified example equal the used packs above; confirm that relationship in the real files rather than assuming it.
| Facility | Requested packs | Fulfilled packs | Request fill | Deliveries due | Deliveries on time | On-time delivery |
|---|---|---|---|---|---|---|
| East | 1,700 | 1,650 | 97.1% | 20 | 18 | 90.0% |
| West | 1,300 | 1,200 | 92.3% | 15 | 12 | 80.0% |
| Total | 3,000 | 2,850 | 95.0% | 35 | 30 | 85.7% |
Request fill is fulfilled packs divided by requested packs. East is 1,650 / 1,700 = 97.1%; West is 1,200 / 1,300 = 92.3%. The total is 2,850 / 3,000 = 95.0%, using summed quantities. Percentages are rounded to one decimal place.
On-time delivery is deliveries received by their agreed due date divided by deliveries due. The total is 30 / 35 = 85.7%. Retain the originally agreed date and any approved changes; otherwise moving a due date can make late delivery disappear.
West warrants investigation because it combines lower request fill, worse supplier service, and higher expiration losses. The figures identify an exception, but they do not prove the supplier caused the unfilled requests. Inspect affected item and request lines before drawing that conclusion.
Facility operations should inspect unfilled requests and unusable stock. Procurement should review late purchase order lines with suppliers. Finance should confirm the cost basis and expiration adjustments against the inventory records.
For external context, the FDA medical device shortage list identifies categories FDA has determined to be in shortage. FDA also explains that a listing does not necessarily mean patient care has been affected. Keep that external context separate from your own facility's request and receipt evidence.
A supplier continuity question belongs in supply chain risk analytics. Choosing how to review uploaded operational files belongs in the supply chain software evaluation guide; neither replaces the reconciliation above.
Bring a sample of your own inventory movements, request register, and supplier receipt export to Covirage, which maps the columns and uses its tools to compute and check the facility comparisons. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring your file.
See self-service analytics for the supporting approach to working from your business files.
Start with item and facility identifiers, inventory balances, receipts, issues, expiration adjustments, supply requests, and supplier delivery records. Retain lot and expiration fields where relevant. Operational supply comparisons can use these business records without patient names or individual clinical information.
Not necessarily. Inventory may be expired, held, reserved, or at a different facility. Compare usable stock with local requests, and keep restrictions visible. A network total can look comfortable while an individual facility repeatedly receives less than it requests.
Supply chain operations should own inventory and fulfillment exceptions, procurement should own supplier delivery discussions, and finance should reconcile recorded inventory values and losses. Local facility staff confirm whether the source records describe what happened before any operational change is approved.