Who are MSM, SPT and Midalloy?

The three companies are sister industrial distributors under common ownership. MSM (Midalloy Specialty Materials) distributes specialty metals — nickel-alloy and specialty stainless bar and wire rod — for critical-component manufacturers, with lead times on some materials stretching up to 2.5 years.

SPT (Specialty Pipe & Tube) distributes large-diameter, heavy-wall seamless steel pipe and mechanical tubing, alongside cutting, heat treating, machining and testing services. Midalloy supplies specialty-alloy welding consumables — stainless, nickel-alloy, aluminum and low-alloy wires and electrodes — to welding distributors and industrial customers.

What problem did they face?

The data to make good buying decisions already existed, but someone had to assemble it. Every purchasing cycle meant pulling sales history from the ERP, stripping out unsellable offcuts and non-inventory purchase orders like freight, equipment and services, subtracting hard and soft reserves, dropping do-not-reorder flags, and reconciling feet against pieces against pounds. That assembly was slow, and the picture was often stale by the time it was done.

Two deeper problems sat underneath. First, no single buyer’s judgment can cover thousands of SKUs, so purchasing depended on the tribal knowledge of a few experienced people — a real key-person risk. Second, demand that lived inside quotes was hard for purchasing to see, even though those quotes were the earliest signal of what customers would actually order.

How did we solve it?

Techjays built an inventory intelligence and demand planning platform that sits over each company’s existing ERP instead of replacing it. The platform integrates directly with MSM’s in-house MS Access-based system, SPT’s Eniteo and Midalloy’s Distribution One, keeping each company’s system of record in place. Data refreshes run on a schedule — nightly at MSM and several times a day at SPT — so each SKU’s picture reflects the latest sync: on-hand, allocated and reserved stock, open vendor purchase orders, stock by location, and purchase, sales and quote history.

Stock-status bands — critical, low, optimal and excess — are configurable business rules, not fixed thresholds. On top of that picture, the forecasting engine produces demand forecasts with confidence scores across 3, 12 and 24-month horizons, a recommended reorder date and quantity, and the likely vendor drawn from buying history. The engine learned each business the way its own buyers did: from the patterns in its own transactions, not a generic model.

  • From manual to automated: the assembly that used to happen by hand every cycle now runs on a schedule, so buyers start from an up-to-date picture instead of building one.
  • Better planning through dashboards: a central dashboard gives planners one view of inventory assets, open orders and incoming stock, with trend charts that can be configured to the questions each team asks, such as aged inventory.
  • A business logic layer: each company’s own rules sit between the raw ERP data and the forecast — stock-status bands, reserves, do-not-reorder flags and the exclusion of non-inventory purchase orders — so the numbers planners see follow how that business actually buys. The rules run per item and per vendor: safety stock and reorder timing use the longest observed lead time of each product from each vendor, and the demand behind those calculations comes from machine-learning predictions built on each company’s own sales history.

The same core platform, developed entirely with Claude Code, was proved at MSM first and then extended to SPT and Midalloy, reaching all three companies within 6 weeks while each kept its own ERP.

Why did the client choose Techjays?

Techjays treated the messy legacy data as the job, not as a precondition. MSM ran on a decades-old in-house Microsoft Access system, and rather than asking the business to wait for a full ERP migration, Techjays built directly on the environment that was already there. Proving the platform at one company before extending it to the sister companies kept the risk low.