BRENNEN

Industries / Industrial equipment and services / Industrial services / MRO supply

Storerooms

A plant's storeroom holds the spare parts and supplies its maintenance crews draw on, and the work is deciding what to stock and how much, keeping it in good condition on the shelf, and handing out the right part for each job.

6

Milestones achieved, from 1913 to 2024.

0

To watch for: announced, not yet confirmed outside.

2

Open deliverables. Nobody has shipped them.

The road

AchievedWatch forOpen

Achieved

  1. 1913

    A formula for order size

    Ford W. Harris, an engineer who had worked for Westinghouse in East Pittsburgh from 1904 to 1912, published "How Many Parts to Make at Once" in Factory, The Magazine of Management in February 1913. It balanced the cost of carrying stock, which rises with the size of each lot, against the set-up cost per unit, which falls with it, and gave a square-root formula for the best lot size. Applied to buying instead of making, it is the economic order quantity (EOQ) formula used to decide how much stock to order at a time. Donald Erlenkotter of the University of California, Los Angeles, who found the forgotten paper about 75 years later, calls the formula one of the most cited and applied results in production and operations management.

    escholarship.org

    Credit

    Ford Whitman Harris; rediscovered by Donald Erlenkotter

  2. 1978

    ABC sorting reaches spares

    ABC analysis ranks stock items by what is spent on them each year, so that the few costly items get the closest control and the many cheap ones the least. A. Dale Flowers of Texas Tech University and James B. O'Neill II, plant buyer at Devro in Lubbock, Texas, applied it to the spare parts of a small, highly automated plant and reported in the journal Interfaces that the results had been put into use and had improved operations.

    api.crossref.org

    Credit

    A. Dale Flowers and James B. O'Neill II

  3. 1995

    Seals freed from cure dates

    The US military standard MIL-STD-1523A, dated 1 February 1984, set maximum ages for rubber seals and other age-sensitive elastomer items accepted for military aircraft, missiles and space vehicles, counted from the date the rubber was cured. It was cancelled on 30 January 1995, with future purchases pointed to SAE AS1933, which covers hose; storage of seals moved to SAE's ARP5316 guidance. The seal maker Apple Rubber now says that when a seal is stored properly, age is no longer considered a factor in its failure.

    LessonHow a part is stored can matter more than how old it is.

    everyspec.comapplerubber.com

    Credit

    US Department of Defense; SAE International

  4. 2003

    Half the stock not needed

    The US Postal Service's Office of Inspector General (OIG) audited the maintenance stockrooms that keep its mail processing plants running. It projected that in November 2002 their spare parts exceeded demand by $131 million, 50% of the inventory, under the Postal Service's own criteria. At the 11 plants it visited, maintenance staff routinely ordered more than the inventory system recommended, did not carry out the required yearly reviews to clear excess parts, and did not classify critical parts consistently.

    LessonA stocking rule saves money only if people follow it and review the shelves against it.

    uspsoig.gov

    Credit

    USPS Office of Inspector General, report AC-AR-03-007, 30 September 2003

  5. 2005

    A part outside the checks

    During a heat exchanger overhaul at BP's Texas City refinery in early 2005, three pipe elbows were removed, stored temporarily and reinstalled 39 days later. The elbows were dimensionally identical, and a carbon steel elbow went into a high-temperature hydrogen line that needed a 1.25% chrome alloy steel elbow. BP's procedure required alloy parts to be tested when they were received in the warehouse and when they were shipped from it for new construction, but not during maintenance. The elbow ruptured on 28 July 2005 after fewer than 3,000 hours in service; the hydrogen fire burned for two hours and caused a reported $30 million in property damage, and one employee had a minor injury.

    LessonMaterial checks must cover every part that goes back into service, including parts that never pass through the storeroom.

    csb.gov

    Credit

    investigated by the US Chemical Safety Board (CSB), bulletin of 12 October 2006

  6. 2024

    Surplus and shortages together

    Amtrak's Office of Inspector General reported in February 2024 that the railroad managed $239 million of parts and materials for maintaining its locomotives and passenger cars at 21 storage facilities at the end of 2022. In September 2023 it held $49 million of surplus and obsolete stock, including $14.4 million it would likely never use, while 34 of 39 mechanical employees interviewed said a part they needed had been unavailable at least weekly in the past year. The auditors traced the imbalance partly to distorted consumption data, made worse when crews took parts from other trains, and found the company had no strategic inventory goals.

    LessonStock levels set from bad usage records give too much of some parts and too little of others at the same time.

    oversight.gov

    Credit

    Amtrak Office of Inspector General, report OIG-A-2024-004

Open

  1. 01

    A table of storeroom audits

    A public table of published audits of maintenance storerooms and parts stores at public bodies, such as postal services, railroads, transit agencies, utilities and ports, each coded the same way: stock value, share found excess or obsolete, evidence of stockouts, the causes named, the recommendations, and whether they were carried out.

    The brief
    Credit · unclaimed
  2. 02

    Storage care from the manuals

    An open table of what makers say stored spare parts need while they wait on the shelf, such as turning the shafts of stored motors and pumps, keeping motor heaters on, protecting seals from heat, light and ozone, and recharging batteries, each with its interval and the manual page it came from; and a small program that turns a storeroom's item list into a dated care schedule.

    The brief
    Credit · unclaimed

Open 01 · the brief

A table of storeroom audits

Credit · unclaimed

The first to publish is credited on this line, and the deliverable moves from Open to Achieved.

What to build

A public table of published audits of maintenance storerooms and parts stores at public bodies, such as postal services, railroads, transit agencies, utilities and ports, each coded the same way: stock value, share found excess or obsolete, evidence of stockouts, the causes named, the recommendations, and whether they were carried out.

Why it is still open

The audits are published one at a time and use different measures. The USPS OIG counted $131 million of excess stock in 2003, and Amtrak's OIG counted $49 million of surplus alongside weekly shortages in 2024, but no table that sets audits from different bodies side by side was found in this research.

uspsoig.govoversight.gov

Built with what exists

pdftotext and pdfplumber to pull text and tables from the reports; a small extraction model such as Meta's Muse Ember for a first pass at each field (see the Note "The jobs agents repeat"), with every figure checked by a person against its page; a CSV file published under an open license.

  1. First step

    Collect 15 audits from US federal, state and city inspectors general and code them by hand to settle the list of fields.

  2. Done looks like

    At least 40 audits from at least two countries coded, every figure linked to the page it came from, and a second person recoding 10 of them, with the share of fields on which the two disagree published.

Open 02 · the brief

Storage care from the manuals

Credit · unclaimed

The first to publish is credited on this line, and the deliverable moves from Open to Achieved.

What to build

An open table of what makers say stored spare parts need while they wait on the shelf, such as turning the shafts of stored motors and pumps, keeping motor heaters on, protecting seals from heat, light and ozone, and recharging batteries, each with its interval and the manual page it came from; and a small program that turns a storeroom's item list into a dated care schedule.

Why it is still open

Since the US military dropped fixed cure dates for seals in 1995, storage rules rest on storage conditions written in separate guides, and SAE's own storage practice for seals, ARP5316E, was cancelled in October 2018. The Electric Power Research Institute (EPRI) published best practices in 2010 for shipping and storing spare turbine and generator components, a report on one class of large parts. GitHub searches for "storage preservation" and "shelf life" found no table of storage rules for spare parts, and none turned up in this research.

saemobilus.sae.orgrestservice.epri.com

Built with what exists

Public installation and maintenance manuals from motor, pump, gearbox, seal and battery makers; a small extraction model such as Meta's Muse Ember to find the storage sections (see the Note "The jobs agents repeat"); Python for the schedule.

  1. First step

    Download the manuals of ten common motor and pump models and copy out their storage sections by hand.

  2. Done looks like

    Storage rules for at least 100 part types from at least 30 makers' manuals, each tied to its page; two maintenance technicians check a random 50 and the error rate is published; the program run on a sample list of 500 storeroom items.