# Projected Stockout Date and Days of Supply Calculator

> Source: https://netray.co/tools/mrp-projected-stockout-date-days-of-supply-calculator
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Find out how many days of supply remain, when you hit safety stock or run out, and how much you are short if the next receipt arrives late.

## Category

supply-chain

## Audience

- Material planner
- Shortage coordinator
- Buyer

## Tool

**Kind:** calculator

**Inputs:**

#### Usable on hand

**Key:** on_hand

**Type:** number

**Default:** 1800

**Min:** 0

**Step:** 10

**Unit:** units

#### Safety stock

**Key:** safety

**Type:** number

**Default:** 400

**Min:** 0

**Step:** 10

**Unit:** units

#### Average daily demand

**Key:** daily

**Type:** number

**Default:** 60

**Min:** 0

**Step:** 1

**Unit:** units

#### Next scheduled receipt quantity

**Key:** receipt_qty

**Type:** number

**Default:** 3000

**Min:** 0

**Step:** 50

**Unit:** units

#### Days until that receipt

**Key:** receipt_in

**Type:** number

**Default:** 40

**Min:** 0

**Step:** 1

**Unit:** days

**Outputs:**

#### Days of supply on hand

**Key:** dos

**Expr:** on_hand / daily

**Format:** days

**Primary:** true

**Description:** Days until stock hits zero with no receipt.

#### Weeks of supply

**Key:** wos

**Expr:** dos / 7

**Format:** weeks

#### Days until safety stock is breached

**Key:** to_ss

**Expr:** max(0, (on_hand - safety) / daily)

**Format:** days

#### Days without stock before receipt

**Key:** gap_days

**Expr:** max(0, receipt_in - dos)

**Format:** days

**Primary:** true

#### Shortage quantity

**Key:** short_qty

**Expr:** gap_days * daily

**Format:** integer

**Description:** Demand that cannot be served before the receipt lands.

#### Days of cover after the receipt

**Key:** cover_after

**Expr:** if(gt(receipt_in, dos), receipt_qty / daily, (on_hand + receipt_qty) / daily - receipt_in)

**Format:** days

**Chart:**

#### Shortage quantity vs receipt arrival day

**Type:** line

**X:** receipt_in

**From:** 0

**To:** 80

**Steps:** 40

**Series:**

- short_qty

**Disclaimer:** Assumes constant daily demand. Use the actual demand profile from your MRP time buckets when demand is lumpy.

## Content

**Intro:** When a supplier slips a delivery, the first question is how long you can last. This calculator turns on hand, demand and receipt timing into a stockout date and a shortage quantity.

**Sections:**

#### How to use it

**Body:** Enter usable on hand, which should exclude quarantine, held and reserved stock, then average daily demand and the next scheduled receipt. The results show days of supply, when safety stock is breached, and how many days of demand go unserved if the receipt arrives after you run out. Move the receipt day to test a pushed out delivery.

**Bullets:**

- Use net available stock, not the gross book balance.
- Take demand from the next few weeks, not the annual average.
- Include only receipts with confirmed dates.

#### The method

**Body:** Days of supply equals usable stock divided by average daily demand. The safety stock breach day uses stock above the safety level. If the receipt is due after days of supply, the gap is receipt days minus days of supply, and the shortage equals the gap times daily demand. If the receipt arrives in time, cover after receipt is the remaining stock plus the receipt, divided by demand.

#### Reading the result

**Body:** With 1,800 units and 60 a day you have 30 days of supply and breach safety stock after about 23 days. A receipt due on day 40 leaves a 10 day gap and a shortage of 600 units. The chart shows the shortage growing linearly once the receipt passes day 30, which gives you a number to take to the supplier or to sales when deciding whether to expedite, substitute or reallocate.

#### Common mistakes

**Body:** Planners often use demand averaged over a year when the next month is far heavier. Others include stock in quality hold, or count a receipt that is still only a planned order. Also check allocations: stock reserved to a single order may not be available to the line that is about to run out.

**Cta:** Netray can keep this calculation live over your ERP data and alert planners when projected stockout dates fall inside lead time.

**Faq:**

#### What is days of supply?

**Answer:** It is usable inventory divided by average daily demand. It tells you how long current stock lasts if nothing else arrives and demand stays at the assumed rate.

#### How is it different from inventory turns?

**Answer:** Turns are an annual, aggregate measure of inventory efficiency. Days of supply is a forward looking, item level measure used to prioritize shortages and expedites.

#### Should safety stock count as available?

**Answer:** For planning it is protected stock, so a breach is a warning. For a true stockout date, it is available until it reaches zero. This tool shows both dates.

#### What if demand is not constant?

**Answer:** Use the sum of actual gross requirements over the horizon to find when cumulative demand exceeds supply. The result will differ from this average based estimate.

## Search terms

days of supply calculator, projected stockout date, inventory days on hand calculator, shortage quantity calculator, material shortage date, weeks of supply formula, stockout risk calculator, inventory runout date

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json