Determining the Correct Level of Service Parts Inventory

A strongly customer-focused organization may feel that it must keep large quantities of service parts on hand, so that it can fill its customers' service requirements at once.  This can lead to a considerable investment in inventory, as well as large obsolete inventory write-offs.  The accountant may find it helpful to use a set of analysis tools to assist management with the calculation of the best possible investment level for service parts.  Here are some tools to consider:

Please note that not one of the items I've listed in this toolkit is one of the more common metrics, such as fulfillment rates, service levels, demand accuracy, or the percentage of obsolete inventory.  Determining the appropriate level of service parts inventory is extremely difficult to determine when using such aggregate measures, because service levels can vary so dramatically by different types of service parts.

The typical service parts warehouse may contain several thousand different service parts, so conducting an analysis with the preceding toolkit for each individual item would be prohibitively expensive.  Instead, aggregate the service parts by customer, to see which parts are only used by low-throughput customers, and then assign them a low level of stocking priority.  Next, aggregate the service parts by type, and determine the level of customer need for each inventory type by using the direct contact or customer complaint tools.  This quick aggregation approach greatly reduces the effort required to determine the correct stocking levels needed for different types of service parts inventory.