Start with workshop records
List the frame references and repairs your workshop actually handles. Count screws used, unresolved matches and unused assortment compartments over a chosen review period. A large number of nominal sizes does not automatically make a kit useful.
Maintain one row per identified SKU
| Stock field | Why it belongs in the sheet |
|---|---|
| Application and reference | Shows the repair demand behind the item |
| Supplier SKU and drawing revision | Prevents an ambiguous reorder |
| Diameter, pitch, length, head | Keeps similar-looking items separate |
| Pack quantity and order unit | Makes quote totals comparable |
| On-hand and observed usage | Supports the next replenishment decision |
Keep unidentified screws outside approved stock. Preserve compartment labels when refilling a tray; mixing visually similar items destroys the traceability that the assortment is meant to provide.
Calculate a local reorder point
A planning starting point is average usage during replenishment lead time plus a buyer-chosen buffer. Use your own measured demand and supplier lead time, and review the result when either changes. This is an inventory planning method, not an industry-prescribed stock level.
Compare kits with refills
Ask whether individual codes can be reordered and whether pack quantities remain stable. Compare the cost of usable stock, not only the number of compartments. Keep low-use specialist parts on a separate decision list instead of buying a second large kit to replenish one frequently used line.