# Inventory Days of Cover vs Lead Time Worksheet

> Source: https://netray.co/tools/inventory-days-of-cover-vs-lead-time-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Calculate days of cover for each part and compare it with replenishment lead time to spot shortage and excess risk.

## Category

supply-chain

## Audience

- Materials planner
- Buyer
- Production planner

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Part number

**Key:** part

**Type:** text

#### On hand

**Key:** onhand

**Type:** number

**Unit:** units

#### On order

**Key:** onorder

**Type:** number

**Unit:** units

#### Average daily usage

**Key:** usage

**Type:** number

**Unit:** units/day

#### Lead time

**Key:** lead

**Type:** number

**Unit:** days

#### Unit cost

**Key:** unitcost

**Type:** number

**Format:** currency

#### Days of cover (on hand)

**Key:** cover_oh

**Type:** number

**Expr:** if(gt(usage,0), onhand / usage, 0)

**Format:** decimal

#### Days of cover (incl. on order)

**Key:** cover_all

**Type:** number

**Expr:** if(gt(usage,0), (onhand + onorder) / usage, 0)

**Format:** decimal

#### Cover minus lead time (days)

**Key:** gap

**Type:** number

**Expr:** cover_all - lead

**Format:** decimal

**Help:** Negative means the pipeline does not cover the lead time.

#### On-hand value

**Key:** value

**Type:** number

**Expr:** onhand * unitcost

**Format:** currency

**Rows:**

**Part:** BRG-6204-2RS

**Onhand:** 3400

**Onorder:** 2000

**Usage:** 55

**Lead:** 28

**Unitcost:** 3.1

**Part:** SEAL-KIT-A14

**Onhand:** 150

**Onorder:** 0

**Usage:** 14

**Lead:** 35

**Unitcost:** 22.4

**Part:** HYD-HOSE-3/8-2M

**Onhand:** 40

**Onorder:** 100

**Usage:** 4

**Lead:** 14

**Unitcost:** 18.9

**Part:** PCB-CTRL-REV-C

**Onhand:** 900

**Onorder:** 600

**Usage:** 26

**Lead:** 56

**Unitcost:** 41

**Part:** GASKET-FLG-DN50

**Onhand:** 9800

**Onorder:** 0

**Usage:** 95

**Lead:** 10

**Unitcost:** 0.65

**Totals:**

#### Total on-hand value

**Key:** value

**Agg:** sum

**Format:** currency

#### Average days of cover

**Key:** cover_all

**Agg:** avg

**Format:** decimal

#### Worst cover gap

**Key:** gap

**Agg:** min

**Format:** decimal

**Summary:**

#### Items reviewed

**Key:** items

**Expr:** count

**Format:** integer

#### Average on-hand value per item

**Key:** value_per_item

**Expr:** sum_value / count

**Format:** currency

**Notes:** Days of cover assumes steady usage. A negative gap means on-hand plus open orders will not last through the replenishment lead time at the current rate, check open order due dates before acting.

## Content

**Intro:** Days of cover tells you how long stock will last at current usage. Set against lead time, it shows which parts will run out before a new order can arrive and which carry far more than they need.

**Sections:**

#### How to use the worksheet

**Body:** Pull on-hand, open purchase or work order quantity, average daily usage and lead time for the parts you manage. Usage should come from recent issues, for example the last 90 days divided by working days, adjusted for known events. Paste or type the data, delete the sample rows and read the two computed cover columns and the gap. Sort the exported Excel by the gap column to build your daily shortage list.

#### The calculation

**Body:** Days of cover = quantity divided by average daily usage. Two versions are shown: on hand only, which is the real buffer today, and on hand plus on order, which assumes open orders arrive on time. The gap is total cover minus replenishment lead time. A negative gap means that even if everything arrives, a reorder placed today would arrive after you run out. A very large positive gap points to excess you may be carrying.

#### How to read it

**Body:** Treat items with a negative gap as urgent: expedite, split orders or find an alternate source. Items with on-hand cover shorter than lead time but healthy total cover depend on open orders, so check due dates and supplier confirmations. Items whose cover is many times the lead time are candidates for lower order quantities, cancelled open orders or the slow-moving review. Use the on-hand value column to prioritise by money tied up.

#### Common mistakes

**Body:** Using last year's average usage for a part with a changing trend gives a false picture, use a recent window. Counting on-order quantity that is already late inflates cover. Forgetting allocated or reserved stock overstates availability, so use available quantity if your ERP tracks it. And remember lumpy parts do not consume smoothly, for those add a safety buffer or use requirements from MRP instead of averages.

**Cta:** Netray can build a live version of this view over your ERP, with open order dates and allocations included, read-only and on your own infrastructure if needed.

**Faq:**

#### Is days of cover the same as days of supply?

**Answer:** In practice yes, both mean quantity divided by average daily usage. Some companies base days of supply on forecast demand rather than past usage, so state which one your report uses.

#### Which usage period should I use?

**Answer:** Ninety days is a common default for stable parts. Use a shorter window for fast changing demand and a longer one for seasonal parts. Be consistent across the report so numbers can be compared.

#### Should I use calendar days or working days?

**Answer:** Use the same basis as your lead time. If lead time is stated in calendar days, use usage per calendar day, otherwise convert both to working days. Mixing them overstates cover by about 30%.

#### What cover is too much?

**Answer:** There is no fixed figure. Compare to lead time plus review period plus safety stock. A cover several times that sum, with no seasonal or strategic reason, is excess stock worth a second look.

## Search terms

days of cover inventory, inventory coverage days, days of supply worksheet, stock cover vs lead time, inventory coverage excel template, weeks of supply calculation, shortage risk worksheet, materials planner worksheet

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