Warehouse Spare Part Coding Generator

Levels 1–5 · Use / location data

FLOC

1Industry

2Business category

3Installation / site

4Plant / unit

3bPlant area

Area no.

5Section / system

Site sequence

Unit sequence

Equipment tag no.

Levels 1–5 describe where the part is used. They build the functional location (FLOC) and are not part of the stock code, so the same part serves several locations.

Levels 6–9 · Equipment subdivision

STOCK CODE

6Equipment class

7Subunit

8Maintainable item / component

9Part family

Part description

Manufacturer

Manufacturer part no.

Unit of measure

Generated code

—

ISO 55000 · Criticality & risk

–

Safety / environment consequence

Production consequence

Replacement lead time

Redundancy / alternatives

Criticality class

Auto-calculated — you can override.

Spare strategy

Stock & lifecycle data

MIN (reorder)

MAX (order up to)

On hand

Lead time (weeks)

Annual usage (pcs / year)

Unit cost

Currency

Supplier

Lifecycle status

Review date

Warehouse location

Store

Zone / area

Rack

Shelf

Bin

—

Notes / technical remarks

Item master register

Stock code	Description	Equip. class	Subunit	Maintainable item	Part family	FLOC	Crit.	Strategy	MIN	MAX	Qty	Lead	Supplier	Status

Economic order parameters

Ordering cost per order

Purchasing + receiving + admin cost of raising one order.

Holding cost rate (% / year)

Capital, storage, insurance and obsolescence as a share of the item value.

Demand variability (CV)

Standard deviation ÷ mean of the usage. 0.2 = steady, 0.6 = erratic.

Round order quantity to

Service level by criticality

Class A

Class B

Class C

Keep at least 1 unit for criticality A items with no recorded usage (insurance spare)

Include demo items

Annual cost vs order quantity

—

Total cost Ordering cost Holding cost

Select a line in the table to see its cost curve.

MIN / MAX proposals

	Stock code	Description	Crit.	Usage / yr	Lead	Unit cost	EOQ	Safety stock	MIN now → proposed	MAX now → proposed	Annual cost now → proposed

EOQ = √(2 × annual usage × ordering cost ÷ (holding rate × unit cost)) · safety stock = z × CV × weekly usage × √lead time · MIN = usage during the lead time + safety stock · MAX = MIN + EOQ. Proposals are always shown against the MIN/MAX you already have — nothing changes until you apply it.

Group by

Measure

Include demo items

Distribution

Criticality mix by part family group

A — insurance / safety B — critical, stocked C — routine

Lead time distribution

Number of items per replenishment lead-time band — the longer the tail, the more insurance stock the plant needs.

Stock value concentration (ABC)

Cumulative share of stock value, items sorted from the most valuable. A healthy store reaches 80% of value within 20–30% of the items.

Items below MIN, by family group

Benchmark by part family group

The same numbers as the charts, ready to compare or export.

Part family group	Items	Stock value	Share	Avg lead time	Criticality A	Below MIN	No MIN/MAX	Obsolete

Automatic coding from reference & description

Paste your part list — the engine reads each reference and description and proposes the full ISO 14224 code.

Input

offline engine

Part list — one per line: reference ; description (or just a description)

Default equipment class when unknown

Apply location from

The offline engine works with no key and no internet, in English and French. Add a Claude API key below to have the model resolve the descriptions it is unsure about.

Claude API (optional)

API key

Model

Use the model for

Remember the key in this browser

The key is sent straight from this file to api.anthropic.com. Only tick “remember” on a computer you control — a stored key can be read by anyone using this browser profile.

Proposed codes

	Reference	Description	Proposed code	Equip. class	Subunit	Maintainable item	Part family	Crit.	Confidence	Why

CMMS exchange

Write the item master out in your CMMS's own column names, and read its export back to compare.

1 · Field mapping

CMMS profile

File format

CMMS column	Item master field

2 · Read a CMMS export

Export file from the CMMS (Excel, CSV or JSON)

Match register items on

CMMS column holding that key

Nothing is written to the CMMS from here. You review the differences, apply what you want to the register, then send the generated import file through your normal CMMS import.

Differences

	Status	Key	Register item	Field	Register value	CMMS value

ISO 14224 taxonomy — 9 levels

Level	Name	Description	Used in

Equipment class tree

Level 6 → 7 → 8, with the part families available at level 9.

Licence

Licence name

Licence key

Trial version — up to 10 items in the register, so you can code a few parts and see the whole workflow.

Full version unlocks: unlimited items · Excel and CSV/JSON export of the register · CMMS import files · applying the EOQ MIN/MAX proposals · benchmark export · AI coding without the 5-line limit.

The licence name must be typed exactly as it was issued. One key works on every browser of the licence holder.

Code format

Separator

Sequence length

Segments included in the stock code

Level 6 — Equipment class

Level 7 — Subunit

Level 8 — Maintainable item

Level 9 — Part family

Sequence number

Prefix (optional)

Functional location

Include the plant area number in the FLOC

The sequence runs per code stem, so every distinct family combination starts again at 0001.

Data

The register is stored in this browser. Export regularly — a JSON export is the full backup, CSV is for Excel and CMMS import.

Excel

Import an Excel file (.xlsx)

Other formats

Import JSON backup or CSV

Merge with existing register (uncheck to replace)

Demo mode

Generate a demo warehouse in the register

Demo items are tagged and kept apart from your own data — switching demo mode off removes only those.

Demo size

Seed

The seed makes the generated set reproducible — change it for a different warehouse.

How the two standards are applied

ISO 14224 — taxonomy & data structure

Levels 1–5 carry the use and location data (industry, business category, installation, plant/unit, section/system). Levels 6–9 subdivide the equipment itself — equipment class, subunit, maintainable item and part. The stock code is built from levels 6–9 so that failure and consumption data can be rolled up by equipment class, exactly as the standard intends.

ISO 55000 — value, alignment, assurance

Every coded item carries criticality (safety, production, lead time, redundancy), a spare strategy, MIN/MAX policy, cost, supplier and lifecycle status. That turns a numbering scheme into an asset-management decision record: what the item protects, what it costs to hold, and when it must be reviewed.

Trial version — this feature is part of the full version. Enter your licence key in Data & Settings → Licence, or ask for one at contact@spare-link.com.

Warehouse Spare Part Coding Generator

Levels 1–5 · Use / location data

Levels 6–9 · Equipment subdivision

Generated code

ISO 55000 · Criticality & risk

Stock & lifecycle data

Item master register

Economic order parameters

Annual cost vs order quantity

MIN / MAX proposals

Distribution

Criticality mix by part family group

Lead time distribution

Stock value concentration (ABC)

Items below MIN, by family group

Benchmark by part family group

Automatic coding from reference & description

Input

Claude API (optional)

Proposed codes

CMMS exchange

1 · Field mapping

2 · Read a CMMS export

Differences

Code decoder

Input

Meaning

ISO 14224 taxonomy — 9 levels

Equipment class tree

Licence

Code format

Data

How the two standards are applied

ISO 14224 — taxonomy & data structure

ISO 55000 — value, alignment, assurance