An algorithm for establishing rational quantities of spare parts and production materials

Road to inventory optimization: Control inventory costs to produce financial savings.

By Sandy Cater BAS, CSCP, PMP, SCMP, CPIM, CIRM, SSGB, ABB Reliability Services

1 of 2 < 1 | 2 View on one page

“The storeroom never has the parts we need.” This statement has been voiced by many throughout our plant. During an operations meeting, management emphasized that something must be done to stop the extended breakdown times resulting from material shortages that cause lost production and revenues. The storeroom manager quickly responded by taking the lead to improve customer service from stores.

The storeroom manager began her venture by reviewing the shortages that occurred during the past six months. Her summarized findings revealed that 20% of these occurrences had inaccurate, on-hand inventory records that, if correct, would have fulfilled the requirements. The other 80% had accurately recorded, on-hand inventory but not enough quantity to satisfy the requirements. The manager decided that she should focus first on the factors causing 80% of the problem, but inventory inaccuracy would need to be tackled immediately following.

What is inventory optimization?

For optimization, we use mean absolute deviation, the sum of absolute deviations from calculating weekly usage.

– Sandy Cater BAS, CSCP, PMP, SCMP, CPIM, CIRM, SSGB, ABB Reliability Services

Realizing the complexity of righting the inventory quantities to satisfy internal customers while ensuring that costs are managed, the storeroom manager decided to learn about the subject and attended an inventory optimization workshop.

Inventory optimization is an ongoing structured approach to ensure inventory is stocked in the proper quantities to support operations without carrying excess inventory. Management assigns the acceptable service levels required from stores for each class of materials. Inventory analysis then determines the appropriate reorder point and reorder quantities required to sustain those service levels.

Inventory optimization benefits

Getting inventory under control provides valuable advantages. These include:

  • Minimal inventory — quantities are set at the lowest point that supports operations
  • Less obsolescence — only the required inventory is carried
  • Reduced expediting — the inventory held most requests
  • Satisfied customers — stock is based on anticipated needs
  • Increased inventory turns — the right materials are held at the minimum acceptable quantities
  • Reduced idle time waiting for materials — the needed items are available immediately from stock
  • Reduced loss of revenue — production is operational more often.

Inventory optimization

At the workshop, the storeroom manager learned how to calculate the savings to be achieved by inventory optimization. The steps are as follows:

1.  Confirm that lead times to order, purchase and receive materials are accurate. This ensures that replenishment occurs when expected.

2.  Calculate the costs associated with carrying and ordering stock items (Table 1). The Association for Operations Management (APICS) defines carrying cost as “the cost of holding inventory, usually defined as a percentage of the dollar value of inventory per unit of time (generally one year). Carrying cost depends mainly on the cost of capital invested, as well as such costs of maintaining the inventory as taxes and insurance, obsolescence, spoilage and space occupied. Such costs vary from 10-to-35% annually, depending on type of industry. Carrying cost is ultimately a policy variable reflecting the opportunity cost of alternative uses for funds invested in inventory.”

    Table 1. Basic carrying cost determination
    Table 1. Basic carrying cost determinatio

    APICS defines ordering cost as “used in calculating order quantities, the costs that increase as the number of orders placed increases. It includes costs related to the clerical work of preparing, releasing, monitoring and receiving orders, the physical handling of goods, inspections and setup costs, as applicable (Table 2).”

    Table 2. Basic ordering cost determination
    Table 2. Basic ordering cost determination

    3.  Assign service-level expectations by material classification. Critical materials might require 99% fill rate. Non-critical materials might be set to 90% fill rate. You could use a 75% fill rate for easily acquired materials such as those items that might be purchased in local retail establishments when you fall short of requirements.

    4.  Choose the statistical equivalent for calculating safety stock based on approved service level (Table 3).

    Table 3. Service level
    Table 3. Service level

    5.  Calculate the safety stock levels for each inventory item. Record the quantity issued in each of the past 52 weeks and calculate the average weekly usage based on these 52 weeks. Record each week’s absolute deviation from the weekly average and then square those values. Add the squared absolute deviations and calculate the average of the total squared absolute deviations. Next, calculate the square root of the average of the total squared absolute deviations. Using the mean absolute deviation (MAD) safety factor from Table 3, multiply the relevant safety factor for each material by the calculated square root of the average total absolute deviations. This is your safety stock quantity, which might need to be rounded upward to match inventory unit of measure (Table 4).

    1 of 2 < 1 | 2 View on one page
    Show Comments
    Hide Comments

    Join the discussion

    We welcome your thoughtful comments.
    All comments will display your user name.

    Want to participate in the discussion?

    Register for free

    Log in for complete access.


    No one has commented on this page yet.

    RSS feed for comments on this page | RSS feed for all comments