Machine Shop Inventory Management

Inventory management for machine shops and fabricators: bar and sheet stock by length, offcuts, tooling life, job costing, and work orders against multi-level BOMs.

Machine Shop Inventory Management

Machine shops track material by the length and the offcut, not by the unit. This is inventory for bar and sheet stock consumed against jobs, tooling that wears out, and multi-level BOMs that only exist because someone drew them.

By Tibeau De Grauwe, FounderUpdated September 2026

  • 25 products free
  • No credit card
  • 10-min setup

Material that is measured, not counted

A distributor holds two hundred units of a part. A machine shop holds eighteen metres of 40x40x2 box section, four full sheets of 3mm mild steel and a rack of remnants nobody has measured since March. Both are inventory, but only one of them fits a system that thinks in whole units.

The practical requirement is a unit of measure per item that matches how the material is bought and how it is consumed, and the honesty to accept that these are sometimes different. Bar arrives in six metre lengths and is consumed in cut lengths; sheet arrives by the sheet and is consumed by area. A stock figure that says "3 sheets" when a job needs 1.4 square metres is only useful if someone can do the arithmetic reliably under pressure.

Weight-based stock brings its own trap. Buying by the kilogram and issuing by the piece works until the piece weight is wrong, at which point stock drifts steadily in one direction and nobody can say why until a count.

Offcuts, remnants and the material you already own

Every cut produces two things: the part and the remainder. In most shops the remainder goes on a rack and leaves the system entirely, which means the shop simultaneously holds material and believes it does not. The result is repeat purchasing of stock that is already twenty metres away.

The fix does not have to be elaborate. Remnants above a threshold length get a label, a location and a quantity; anything below the threshold is scrap and is treated as consumed. Setting that threshold deliberately is more important than where it lands, because a rule everybody applies beats an ideal nobody follows.

The payoff shows up in two places: material cost per job falls when remnants get used first, and the material availability check before a run stops sending someone to the supplier for a length that is already in the rack.

  • Label and locate remnants above an agreed threshold
  • Treat anything below the threshold as consumed, not as stock
  • Check remnants before ordering new material for a job
  • Review the remnant rack periodically or it becomes a scrap rack

Tooling as a consumable with a life

Inserts, end mills, drills and blades are not fixed assets and they are not quite ordinary stock either. They are consumed on a curve driven by how much material has been cut, which means the reorder signal that actually works is job volume rather than a monthly average.

Two failures are common. The first is running out of a specific insert grade mid-job, which stops a machine for a courier delivery that costs more than a year of holding the item. The second is the opposite: a drawer of tooling for a machine that left the shop two years ago, bought by someone who has since moved on.

Treat high-use tooling as stock with minimum levels and low-stock alerts, and treat expensive specials as items with an owner and a documented reason for being held. Where a tool is genuinely reground and reused rather than discarded, it starts behaving like an asset with a service history, and tracking it that way is more honest than pretending it is a consumable.

Jobs, work orders and BOMs that are real but shallow

Machine shop bills of materials are rarely deep, but they are rarely flat either. A fabricated frame that feeds a finished assembly is a made part: it has its own material, its own operations and its own run, and planning the assembly without planning the frame first is how a job stalls with the bench occupied.

Work orders are what connect the BOM to the shop floor. Released against real material availability, they tell you what can actually start; released optimistically, they fill the floor with partly finished jobs holding cut material that no other job can use, which is the most expensive form of work in progress a small shop can carry.

Recording completed and scrapped quantities separately is what makes yield visible. A run of twenty that produced nineteen good parts and one reject is data about your process; a run recorded as nineteen complete is a mystery with one part missing.

In StockFlow, the Production module turns bills of materials into work orders on a planning board, records builds with the components they consumed, tracks lots through the run and reports expected against actual yield. It is included on Professional and above, or available as a $4/month add-on.

Job costing and keeping the count honest

A quote is only as good as the material cost behind it, and material cost is only real if what was issued to the job was recorded against the job. Where the shop consumes whatever is nearest and reconciles later, the standard cost in the quote and the actual cost of the work part company quietly and permanently.

Cycle counting works better than an annual shutdown for a shop with a small number of high-value material lines. Counting the ten most-consumed items weekly catches drift while the cause is still identifiable, and it takes less time than the argument that follows a bad year-end count.

Barcode labels on racks and material do more work here than anywhere else, because the alternative is someone reading a grade and dimension off the end of a bar in poor light. Scanning material out to a job on a phone is the version of this that survives a busy Thursday.

  • Issue material to the job, not to the general ether
  • Cycle count high-consumption material weekly rather than annually
  • Label racks and remnants so identification does not rely on memory
  • Compare quoted material cost against issued cost on finished jobs

Stop buying steel you already have in the rack

Track material by its own unit of measure, keep remnants and tooling countable, and release jobs against stock that is genuinely free. Free to start.

No credit card required
Free Starter plan
Cancel anytime

Trusted by small businesses

What our customers say

Super Kind! Quick replies from their support and very easy fixes, changed the dashboard a bit and customized it. Also gave me 450 items extra on the free plan just for me. Highly recommend and again great service!

Erasable Trading AU

Best customer service! Stockflow's customer support is fast and extremely helpful. They assisted me with customization of the software to improve my experience as a user.

Justin M.

Co-Owner, Consumer Goods

Frequently asked questions

What makes machine shop inventory different from ordinary stock control?
Material is consumed by length, area or weight rather than by the piece, every cut produces a remnant that is still inventory, tooling wears out against job volume rather than time, and most parts are made rather than bought, so availability depends on planning production and not just checking a shelf.
How do you track offcuts and remnants?
Set a threshold length or size above which a remnant is labelled, located and counted as stock, and below which it is treated as scrap. The threshold matters less than applying it consistently, because the aim is to stop buying material the shop already owns.
Should tooling be tracked as inventory or as assets?
Consumable tooling such as inserts and drills is best tracked as stock with minimum levels and low-stock alerts. Tooling that is reground and reused, or that is expensive and individually identifiable, behaves more like an asset with a service history and is better tracked that way.
How do you know whether a job can run?
Explode the bill of materials against material that is not already committed to another released job, including remnants, and add the expected scrap. Checking against total stock rather than uncommitted stock is why two jobs can both look feasible and both stall.
Can StockFlow handle materials measured by length or weight?
Yes. Items carry their own unit of measure and BOM quantities can be fractional, so a component can be entered as 0.4 kg of coating or a cut length of bar rather than being forced into whole units.
Does a small machine shop need work orders?
Once more than two or three jobs are in progress at the same time, yes. Work orders are what record which job consumed which material and what was scrapped, and without them job costing is an estimate and yield is unmeasurable.