Supply Chain & InventoryFree worksheetPDF, Excel, Word exportMachining

Carbide Insert Inventory and Reorder Worksheet

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.

Download:

Reorder point (pcs)	Days of stock (days)	Suggested order qty (pcs)	Stock value
80	12	0	$288
60	6.6667	200	$78
56	6.25	151	$130
30	9	72	$135
40	40	0	$420

Total stock value

$1,051

Total pieces to order

423

Average days of stock

14.7833

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).

Automate tool crib reorders

Optional: ask how issue transactions could drive reorder suggestions in your ERP.

Optional. The tool and every export work without this. No spam.

How to use the worksheet

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

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

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

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.

Frequently Asked Questions

How do I get average daily usage?

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?

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?

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?

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.

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.

Talk to an Expert Explore More Free Tools

Related Tools

MES & Shop Floor

More Supply Chain & Inventory tools

See all

Back to All Tools