# Supplier Delay Stockout Exposure Calculator > Source: https://netray.co/tools/supplier-delay-stockout-exposure-calculator > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Test what a late purchase order does to coverage: days short, units short and the expedite quantity needed. ## Category supply-chain ## Audience - Materials planner - Expediter - Buyer ## Tool **Kind:** calculator **Currency:** $ **Inputs:** #### Usable on hand **Key:** onhand **Type:** number **Default:** 900 **Min:** 0 **Step:** 10 **Unit:** units **Help:** Exclude quarantine and stock allocated to other work. #### Daily usage **Key:** use **Type:** number **Default:** 60 **Min:** 0 **Step:** 1 **Unit:** units/day #### Original PO due in **Key:** due **Type:** number **Default:** 18 **Min:** 0 **Step:** 1 **Unit:** days #### Supplier delay **Key:** slip **Type:** slider **Default:** 7 **Min:** 0 **Max:** 30 **Step:** 1 **Unit:** days #### Safety stock held **Key:** ss **Type:** number **Default:** 200 **Min:** 0 **Step:** 10 **Unit:** units **Help:** Part of on hand you would normally not touch. #### Cost per unit short **Key:** lostval **Type:** number **Default:** 45 **Min:** 0 **Step:** 1 **Unit:** $ **Help:** Expedite premium, idle labor or lost margin per unit of shortage. **Outputs:** #### Days of coverage on hand **Key:** cover **Expr:** onhand / use **Format:** days #### Days short, original date **Key:** short0 **Expr:** max(0, due - cover) **Format:** days #### New receipt in **Key:** newdue **Expr:** due + slip **Format:** days #### Days short, with delay **Key:** short1 **Expr:** max(0, newdue - cover) **Format:** days **Primary:** true #### Extra days short from delay **Key:** extra **Expr:** short1 - short0 **Format:** days #### Units short before receipt **Key:** units **Expr:** short1 * use **Format:** integer **Primary:** true #### Days the safety stock would cover **Key:** buffer **Expr:** ss / use **Format:** days #### Estimated shortage cost **Key:** cost **Expr:** units * lostval **Format:** currency **Chart:** #### Days short vs supplier delay **Type:** line **X:** slip **From:** 0 **To:** 30 **Steps:** 31 **Series:** - short1 - short0 **Disclaimer:** Assumes steady usage and that the full PO quantity arrives on the new date. Partial shipments and demand changes are not modeled. ## Content **Intro:** A supplier emails that your order will be a week late. Is that a problem? This calculator answers by comparing the days of coverage you have with the new receipt date and valuing any gap. **Sections:** #### How to use it **Body:** Enter usable on-hand stock, daily usage, the original due date as days from today and the slip. Add safety stock if you want to see how many days it would cover, and a cost per unit short for an estimate of exposure. The slider shows the effect of different slips on days short. **Bullets:** - Net out allocations and quarantined stock - Use consumption, not forecast, if the two differ - Update daily usage when the build schedule changes #### The method **Body:** Coverage in days is on hand divided by daily usage. Days short is the receipt date minus coverage, floored at zero. Compare the original and delayed receipts to isolate the harm caused by the delay. Units short is days short times daily usage, which is also the minimum quantity you would need to expedite from another source. #### Reading the result **Body:** If the delayed receipt still falls inside your coverage, no action is needed beyond monitoring. If the gap is only a few days, safety stock may absorb it, but that means the buffer is consumed and the next surprise will hit. Use the chart to find the slip at which shortages begin, then agree trigger points with the supplier. #### Common mistakes **Body:** Using total on hand when part of it is reserved for other orders overstates coverage. Planners also forget in-transit stock or inspection time before receipt becomes usable. In your ERP, check requirement dates in the MRP exception messages or stock requirements list, which show reschedule suggestions for late supply. **Cta:** If you want delayed purchase orders flagged with their shortage exposure automatically inside your ERP, Netray can build that alert. **Faq:** #### How do I know the usage rate? **Answer:** Use the average daily consumption over the next few weeks from the build schedule or requirements list. If usage is lumpy, run the calculator for the period that matters, or per job, rather than relying on an average. #### Should safety stock count as coverage? **Answer:** Count it if you are willing to use it. The tool shows both views: coverage on hand includes it, and a separate output shows how many days it alone would last, so you can see how much buffer is left. #### What if the supplier ships in parts? **Answer:** Run the calculation for the first partial shipment date and quantity, then again for the remainder. A partial that arrives before your coverage ends can eliminate the shortage even when the full order is late. #### Does this handle several parts at once? **Answer:** No, it is one part at a time. For many parts, use a worksheet or a shortage report from the ERP and apply the same logic by item to rank which delays actually hurt. ## Search terms supplier delay stockout calculator, late purchase order impact, days of coverage calculator, stockout days calculator, expedite quantity calculator, po slip impact on production, material shortage exposure, inventory coverage until receipt --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json