# Carbide Insert Inventory and Reorder Worksheet

> Source: https://netray.co/tools/carbide-insert-inventory-reorder-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

A tool crib worksheet that computes days of stock, reorder point and suggested order quantity for turning and threading inserts.

## Category

supply-chain

## Industry

Machining

## Audience

- Tool crib attendant
- Buyer
- Machining supervisor

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Insert / item

**Key:** item

**Type:** text

#### Used for

**Key:** use

**Type:** select

**Options:**

- Rough turning
- Finish turning
- Grooving
- Threading
- Boring
- Drilling

#### On hand

**Key:** onhand

**Type:** number

**Unit:** pcs

#### Avg usage per day

**Key:** daily

**Type:** number

**Unit:** pcs

#### Lead time

**Key:** lead

**Type:** number

**Unit:** days

#### Safety days

**Key:** safety

**Type:** number

**Unit:** days

#### Unit price

**Key:** price

**Type:** number

**Format:** currency

#### Reorder point

**Key:** rop

**Type:** number

**Expr:** daily * (lead + safety)

**Format:** integer

**Unit:** pcs

#### Days of stock

**Key:** cover

**Type:** number

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

**Format:** decimal

**Unit:** days

#### Suggested order qty

**Key:** order

**Type:** number

**Expr:** if(lt(onhand, rop), ceil(daily * 30 + rop - onhand), 0)

**Format:** integer

**Unit:** pcs

#### Stock value

**Key:** value

**Type:** number

**Expr:** onhand * price

**Format:** currency

**Rows:**

**Item:** CNMG 432 coated

**Use:** Rough turning

**Onhand:** 120

**Daily:** 10

**Lead:** 5

**Safety:** 3

**Price:** 2.4

**Item:** VNMG 331 finish

**Use:** Finish turning

**Onhand:** 40

**Daily:** 6

**Lead:** 7

**Safety:** 3

**Price:** 1.95

**Item:** Groove 3 mm insert

**Use:** Grooving

**Onhand:** 25

**Daily:** 4

**Lead:** 10

**Safety:** 4

**Price:** 5.2

**Item:** Threading 16 IR 11 TPI

**Use:** Threading

**Onhand:** 18

**Daily:** 2

**Lead:** 10

**Safety:** 5

**Price:** 7.5

**Item:** CCMT 32.51 boring

**Use:** Boring

**Onhand:** 200

**Daily:** 5

**Lead:** 5

**Safety:** 3

**Price:** 2.1

**Totals:**

#### Total stock value

**Key:** value

**Agg:** sum

**Format:** currency

#### Total pieces to order

**Key:** order

**Agg:** sum

**Format:** integer

**Summary:**

#### Average days of stock

**Key:** mean_cover

**Expr:** avg_cover

**Format:** decimal

**Notes:** Order quantity here tops stock up to the reorder point plus 30 days of usage. Change the 30 in your own copy to match your order cycle, and round to pack sizes (insert boxes often hold 10).

## Content

**Intro:** Running out of one insert style stops a lathe, and overstocking ties up cash. This worksheet calculates reorder point, days of stock and a suggested order quantity from on-hand stock and real usage.

**Sections:**

#### How to use the worksheet

**Body:** Enter each insert style with current stock, average daily usage from your issue log, supplier lead time and a safety margin in days. The sheet computes reorder point as daily usage times lead time plus safety days, shows days of stock, and suggests an order quantity when stock falls below the reorder point. Update on-hand counts weekly or after each cycle count and export to Excel for purchasing.

#### The reorder logic

**Body:** Reorder point equals the demand expected during replenishment, plus a buffer. If an insert uses 10 per day, arrives in 5 days and you want 3 days of margin, the reorder point is 80 pieces. Once on-hand falls below that number, an order is due. The suggested quantity here restores stock to the reorder point plus 30 days of use, which is a typical monthly cycle but should be matched to your supplier's pack and discount breaks.

#### Reading the results

**Body:** Days of stock shows exposure at a glance: items under their lead time are at risk. Stock value shows where cash is parked, and the total highlights slow-moving high-cost items. Review any insert with very high days of stock for consolidation, since a shop that runs ten near-identical geometries may do better with fewer standard grades. Slow items with long lead times deserve a safety margin.

#### Common mistakes

**Body:** Do not use purchase history as usage, since buys come in lumps. Use issue transactions or counts. Do not forget scrap and breakage, which push real usage above planned. Avoid setting one safety margin for all items; set higher for single-source or long lead items. And do not skip the physical count: tool crib stock with a vending machine or ERP issue records drifts without periodic checks.

**Cta:** If your crib issues are recorded in an ERP or vending system, Netray can help turn that data into usage figures and automatic reorder suggestions.

**Faq:**

#### How do I get average daily usage?

**Answer:** Take insert issues over a recent period, such as 60 to 90 days, and divide by working days. Exclude one-off project demand if it will not repeat, and update the figure when your product mix changes.

#### What safety days should I use?

**Answer:** It depends on supplier reliability and how costly a stockout is. Common choices run from a few days for local distributors to a couple of weeks for imported or single-source inserts. Review after any stockout.

#### Should expensive inserts follow the same rule?

**Answer:** The formula is the same, but you may reduce stock levels for high-value items and rely on shorter reorder cycles, as long as lead time is dependable. Watch carrying cost and obsolescence risk.

#### Can I export this to purchasing?

**Answer:** Yes. Export to Excel or CSV and filter for rows where suggested order quantity is above zero. Pass that list to the buyer or import it into your purchasing system as a requisition.

## Search terms

insert inventory spreadsheet, tool crib inventory excel, carbide insert reorder point, cutting tool inventory template, tool crib min max sheet, insert stock tracking, tooling reorder worksheet

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