Inventory Cost Minimization Through Item Categorization and Demand Forecasting: A Case Study-based Approach

Download Full-Text PDF Cite this Publication

Text Only Version

Inventory Cost Minimization Through Item Categorization and Demand Forecasting: A Case Study-based Approach

M. H. Kibria, M. M. A. Khan*, A. B. M. A. Malek and P. K. Biswas

Department of Industrial and Production Engineering, Shahjalal University of Science and Technology.

Abstract Inventory of spare parts is needed for proper maintenance and repair of final products, vehicles, industrial machines and equipment. Holding of excess spare parts for long time generally results in extra cost (in form of holding cost, tied up capital and obsolescence cost). This study, therefore, tries to minimize the inventory cost through spare parts categorization and demand forecasting. ABC analysis was used to identify to most valuable items (Category A Items). Crostons method was used to determine forecasted demand of the Category A items obtained from ABC analysis. Existing spare parts inventory is found to hold a substantial fraction (39%) of idle or unused items. Croston's method showed its potential in predicting the forecasted demand of Category A items used in cement industries. Even though the ordering cost increases four times the existing one, the overall inventory cost of the Category A items decreases by 64% as compared to their existing inventory cost.

Keywords Inventory Cost, Minimization, Item Categorization, Crostons Method

  1. INTRODUCTION

    Spare parts are interchangeable parts that are kept in an inventory and used for the repair or replacement of failed parts. Managing inventory of spare parts plays a vital role in many industries, such as aerospace and defense, transportation, telecommunications and information technology, utilities and durable goods suppliers, automotive, cement industries and manufacturing industries. Production plants hold spare parts for internal use in the maintenance of tools and equipment [1,2].

    Higher efficiency of production plants requires minimization of machine downtimes, and for reducing downtime, spare parts availability must be ensured. However, the availability of spare parts is limited by space and cost [3]. Hence, to overcome such a problem, spare parts inventory must be managed according to their criticality [4]. The criticality classification of spare parts is generally based on administrative efficiency considerations (such as inventory costs, usage rates, etc.) derived from historical data of the company [3]. Also, spare parts of the industrial maintenance are recommended to be classified according to such criticalities as vital, essential, and desirable (VED) [5]. Other facets of criticality such as response time, functionality, consumption, stage of the life cycle, price, purchase lead time, repairability, etc., are also used to evaluate the criticality of items [6].

    Demands for spare parts are difficult to predict based on historical usages data because of their need only for maintenance either preventively or at failure [7]. Intermittent demand for spare parts is particularly challenging to predict, and shortage may result in extremely high costs [8]. Spare parts

    inventory management is, therefore, a very complex problem area for developing intelligent systems to assist in decision making [9]. Hence, it draws attention to many researchers to work on the spare parts inventory management issues. Antosz and Ratnayake applied the AHP technique to select items that need to be stocked on a priority basis [10]. Braglia and Montanari applied the AHP method together with Reliability Centered Maintenance (RCM) in order to develop an inventory management policy matrix for different spare parts [3]. Eaves and Kingsman tried to find out a forecasting method best-suited for a spare part inventory with smooth, irregular, slow-moving, and intermittent demand patterns [11]. Ramanathan developed a weighted linear optimization method to solve the multi- criteria ABC inventory classification problem, which intuitively assigns weights to each criterion [12]. Li and Kuo developed an Enhanced Fuzzy Neural Network (EFNN) based decision support system to forecast the demand for automobile spare parts and hence, to manage the inventory in a central warehouse [13]. Gutierrez et al. developed a Neural Network based model in forecasting lumpy demand [14]. Their models performance was found to be superior to the exponential smoothing, SBA, and Crostons method.

    From the above literature, it is evident that managing spare parts is a complicated problem but a critical issue for the inventory cost reduction and the efficiency enhancement of production equipment as well. Depending on the types and demand patterns of the spare parts, different techniques have been found competent for managing the inventory of spare parts of different sorts. Though different Neural Network-based techniques showed enormous potential in forecasting the demand of the spare parts, no one tries to use these techniques to minimize the inventory management cost so far. This study, therefore, tries to minimize the inventory cost through spare parts categorization and demand forecasting. This study focuses on:

    • Categorizing the spare parts used in the cement industries into moving and nonmoving groups and then, estimating the most valuable moving spare parts (Category-A Items) performing ABC analysis;

    • Selecting a forecasting method able to predict the demand of the Category- A items most accurately; and

    • Finally, applying the spare part categorization and the selected demand forecasting techniques to minimize the overall inventory cost of the Category-A items.

  2. METHODOLOGY

    1. Data collection

      The data on spare parts issued or received daily was collected from a rich administrative database available in a multinational cement company located in Sylhet, Bangladesh,

      method, which is similar to traditional exponential smoothing (ES) when demand is steady [11].

      According to Crostons method, forecasted of demand per period is calculated by dividing mean demand size by mean demand interval, that is:

      using a predesigned table. The table contained such information as item codes, item descriptions, ordered date, transaction

      Ft+1

      = Z t+1

      P t+1

      explanation (received or issued), transaction quantities, unit measurement, and unit cost/price. Data were limited to 2007 through 2018. Within the stated period, the number of records for items issued was found to be 106905, 49162 for items received, and 7572 records of current inventory. The total number of items in different categories was 11952.

    2. Item Categorization

      In this study, items were categorized as moving and non- moving. Items not used for more than three years were termed as non-moving inventory. Items used at least once a year were designated as slow-moving inventory, and very high consumption and frequently moving items were denoted as fast-moving. However, in this study, slow-moving items were considered as moving items. Stockout items, critical items, and unused (idle) items were categorized as non-moving items. This is worth mentioning that idle items incur three types of cost, which, in turn, increase the loss for the company, e.g., Total purchase cost = No of total quantity x unit cost; Total holding cost = No of year x holding cost; Cost of capital = Total cost year x percentage of interest; and Total loss = Total cost + Holding cost + Cost of capital.

      Moreover, in this study, to optimize the cost of moving items, ABC analysis was used to identify to most valuable items (Category A Items), and then the EOQ model was applied to determine the optimum order size o category A items. In the ABC analysis, for the studied company, the classification rule shown in Table 1 was implemented:

      Table 1: Classification rule applied in this study

      Classification

      Percentage of total number of items

      Percentage of the total cost

      A

      5-20%

      50-80%

      B

      20-40%

      20-40%

      C

      50-70%

      5-25%

    3. Demand Forecasting of category-A items

      Forecasting serves as a decision support tool that allows us to determine how changes in inputs affect outcomes. The forecast period determines the priorities of forecast method application, which is traditionally divided into short (1-3 months), mid (3 months-2 years), and long (more than two

      Here, Ft+1= forecast mean demand for period t+1

      Z t+1= forecast demand size for period t+1

      And Pt+1= forecast interval between transaction for period t+1 If the actual demand at time t is Dt is zero then,

      Z t+1= Z t

      P t+1= P t

      But, if the actual demand at time t is more than zero, then

      Z t+1= Dt + (1- ) Z t

      P t+1= Qt + (1- ) P t

      Here, Qt = actual value of the time between consecutive transactions at the instant t; if demand at t-1 is greater than zero then Qt = 1, and if demand at t-1 is zero than Qt = Qt-1 + 1 = smoothing constant.

      Syntetos-Boylan Approximation (SBA) method is a modification to the Crostons method. Syntetos and Boylan suggested a deflating factor to the estimate of mean demand per period based on the smoothing parameter for demand interval . Hence, the modified model describing the forecasted demand per period becomes:

      Ft+1 = (1 – ) Z t+1

      2 P t+1

    4. Forecasting Error Estimations

      The forecasting error (forecast value actual value) is frequently estimated to identify the most accurate forecast method. For this purpose, many estimators like MAD (Mean Absolute Deviation), MSE (Mean Squared Error), or RMSE (Root Mean Squared Error), MAPE (Mean Absolute Percentage Error) are usually used.

      MAD is considered as a standard method due to its simplicity. MAD is calculated as:

      MAD = ||

      Here, Ft = forecasted value; Dt = actual value and N = number of year.

      RMSE (Root Mean Squared Error) is calculated as:

      RMSE = ()2

      Here, Ft = forecasted value; Dt = actual value and N = number of year.

      1

      1

      For intermittent demand, MAPE (Mean Absolute Percentage Error) has some drawbacks because some actual value of demand became zero. Hence Symmetric Mean Absolute Percentage Error (SMAPE) is used instead and calculated as:

      years). Simple quantitative forecast methods are applied for a

      SMAPE = N

      ||

      short and mid-period (simple moving average and potential smoothing), while for a long-term forecast, regression and econometric models are applied. However, the spare part items demand is typically intermittent (highly variable and arrive sporadically). For intermittent demand, Croston's proposes a

      N t=1 |+|

      Here, Ft = forecasted value; Dt = actual value and N = number of year.

    5. Total Inventory Cost

      The total inventory cost function, includes economic order quantity, Q, the size of the safety stock, s, order frequency, D/Q and the purchase price, PD of the item being ordered, i.e.,

      = ( + ) + +

      2

      Where Ch is total holding costs, Co is ordering costs, P is the unit price of the item purchased, and D is the annual demand of that particular item.

    6. The economic order quantity for A-category items

      In this study, the basic model given below is used to determine the optimal order quantity minimizing the sum of carrying costs and ordering costs.

      2

      Figure 1: Moving and non-moving items category in total items

      = =

    7. (S, s) policy model with specific service level for A- category items

    For the basic EOQ model, no safety stock is necessary as this model assumes the demand and the lead time constant. However, for the items considered in this study, demand for the spare parts is stochastic and hence, assumed to be normally distributed, whereas replenishment lead times are assumed fixed and known.

    Thus, the (S, s) policy model with a specific service level is used to determine the size of the safety stock. Also, the reorder point is set to cover the expected demand during the lead time, as well as a safety stock determined by the desired service level.

    For a lead-time demand that follows a normal distribution with a mean of LD and standard deviation of , the safety stock can be calculated as:

    s = Z × standard deviation of lead-time demand =

    Where, Z is the number of standard deviations for a specific service level, and L denotes the lead time.

  3. RESULTS AND DISCUSSION

    1. Spare Parts Categorization

      In this study, spare parts are initially classified as moving and non-moving items. As mentioned earlier, any spare part, which was used at least once in a designated period, was identified as a moving item. Whereas, spare parts with no use within that designated period were identified as non-moving items. Fig. 1 illustrates the distribution of moving and non- moving items found in the existing inventory. From the figure, it is found that the existing inventory contains more non- moving spare parts (54%) than the moving ones. This fact indicates that the current inventory is holding more items unnecessarily, incurring more holding costs and hence, contributing more to the total inventory cost.

      Figure 2: Category of Non-moving items

      The non-moving items are further classified as critical, stock out, and idle. In this study, a non-moving spare part having a longer lead time, incurring a higher cost, and essential for proper functioning is termed as a critical item. Items used earlier but not found in the current inventory are labeled as stock-out items. Any non-moving item apart from the critical and stock-out items is called as idle or unused items, which only contribute to the cost increment. Fig. 2 shows the distribution of critical, stock out, and idle or unused non-moving items. From the figure, it is apparent that among non-moving items, 40% are stock-out items, 39% are idle, and the rest 21% are critical items that must be kept in the inventory and, thus, should be incorporated in inventory cost estimation. However, the aforestated data indicate the fact that there is an ample opportunity for eliminating unused items from the existing inventory and hence, for reducing the inventory costs.

    2. Estimating Most Valuable Moving Spare Parts

      In this study, ABC analysis is performed to identify the items contributing the most to the overall inventory cost. Fig 3 depicts the variation in overall inventory cost with the number of items. From the figure, it is apparent that 552 items (category

      A) incur 81.8% of the overall inventory cost, which is only 10% of the total moving items. Whereas 70% of the items (category

      C) incurs less than 5%, which is insignificant as compared to Category A items. For this reason, in this study, only the category A items are considered while minimizing the overall inventory cost.

      100%

      Cumulative percentage of total cost

      Cumulative percentage of total cost

      90%

      80%

      70%

      60%

      50%

      40%

      30%

      20%

      10%

      0%

      Category-B 1105 items

      13.85% total cost

      Category-A

      552 items

      81.8% total cost

      Category-C 3867 items

      4.37% total cost

      frequency D/Q, and the purchase cost PD of the item being ordered. In this study, Croston's method is used to find the annual forecasted demand D; the basic EOQ model is applied to determine the economic order quanity Q; (S, s) policy model with a 95% service level and a fixed lead time of 20 days is used to calculate the safety stock.

      Table 3 shows how the demand forecasting affects the different inventory cost categories associated with Category A items. From the table, it is evident that applying Crostons technique for forecasting the demand causes a reduction in holding cost and item cost by 96% and 59%, respectively. Even though the current ordering cost increases almost five times the previous ordering cost incurred, the overall inventory cost of Category A items decreases by 64%.

      Table 3: Effect of demand forecasting on inventory cost

      0 1000 2000 3000 4000 5000 6000

      Cumulative inventory items

      Figure 3: ABC analysis on moving items

    3. Selecting the Demand Forecasting Technique for Category A Spare Parts

      In this study, different methods are first used to calculate the forecasted demand of the Category A items, and then the forecasting errors associated with each method are estimated and compared to determine the method most suitable for forecasting the demand of these items. The forecasting methods chosen here are three years, five years and seven years moving average;

      distribution for category A items

      Holding Cost

      Ordering cost

      Items cost

      Inventory Cost

      Before Demand Forecasting

      106.8

      0.5

      646.5

      753.9

      After Demand Forecasting

      4.2

      2.9

      262.8

      269.9

      Fraction (Increase)/Decr ease in Each Cost Item

      0.96

      (4.80)

      0.59

      0.64

      Holding Cost

      Ordering cost

      Items cost

      Inventory Cost

      Before Demand Forecasting

      106.8

      0.5

      646.5

      753.9

      After Demand Forecasting

      4.2

      2.9

      262.8

      269.9

      Fraction (Increase)/Decr ease in Each Cost Item

      0.96

      (4.80)

      0.59

      0.64

      *Cost in Million BDT

      exponential smoothing with a constant of 0.3, 0.5 and 0.8; Croston's method; and Syntetos-Boylan Approximation. In this case, a single item from category A is randomly sampled, and forecasting errors like MAD (Mean Absolute Deviation), RMSE (Root Mean Squared Error), SMAPE (Symmetric Mean Absolute Percentage Error) values are estimated for each technique.

      Table 2 presents the MAD, RMSE, and SMAPE values estimated for different forecasting techniques for a random item. As shown in the table, MAD, RMSE, and SMPE values estimated for Croston's method are relatively small as compared to the other. These results indicate that Croston's method is highly effective as compared to others and can be used to determine the forecasted demand for the category A spare part.

    4. Inventory Cost Reduction through Parts Categorization and Demand Forecasting

    As stated earlier, the overall inventory cost is a function economic order quantity Q, the size of the safety stock s, order

    Table 4: Inventory cost distribution for non-moving items

    Cost Items

    Non-moving Items

    Critical items

    Idle items

    Total Purchase Cost

    140.3

    188.1

    Holding cost

    6.8

    11.5

    Opportunity Cost

    102.2

    124.4

    Total Cost

    249.3

    324.0

    *Cost in Million BDT

    Moreover, from figure 1 and 2, it is apparent that non-moving parts outnumbered moving ones, and the idle or unused parts, in particular, covered almost two-fifth of the non-moving parts. Hence, the overall inventory cost can further be reduced by eliminating the unused items from the existing inventory, as can be seen from Table 4.

    Table 2: Estimation of MAD, RMSE & SMAPE for different forecasting method

    Type of error

    Simple moving average (k = 3)

    Simple moving average (k =5)

    Simple moving average (k = 7)

    Exponential smoothing for 0.3

    Exponential smoothing for 0.5

    Exponential smoothing for 0.8

    Croston's Method

    SBA

    Error Difference

    753

    572.00

    531.71

    674.03

    691.34

    705.74

    500.46

    542.4

    MAD

    83.67

    81.71

    106.34

    67.40

    69.13

    70.57

    45.50

    49.31

    RMSE

    99.67

    99.90

    115.83

    89.00

    86.27

    85.72

    64.16

    67.66

    SMAPE

    68%

    64%

    64%

    59%

    60%

    60%

    40%

    43%

  4. CONCLUSIONS

This study aims at reducing the inventory cost of the spare parts used in the cement industries through parts categorization and demand forecasting techniques. Conclusions can be summarized as follows:

  • Existing spare parts inventory is unnecessarily holding a substantial fraction of idle or unused items, and hence, only contributing to the inventory cost of the spare parts;

  • As compared to exponential smoothing with different constants and Syntetos-Boylan Approximation, Croston's method found to be more accurate in forecasting, and can be used in predicting the forecasted demand of Category A items used in cement industries; and

  • Though the application of forecasting technique in spare parts inventory management significantly increases the ordering cost, the overall inventory cost of the Category A items becomes less by two-third of their existing inventory cost.

REFERENCES

  1. Lengu, D., Syntetos, A. A., & Babai, M. Z. (2014). Spare parts management: Linking distributional assumptions to demand classification. European Journal of Operational Research, 235(3), 624- 635.

  2. Diaz, D. A. B., Hennequin, S., & Roy, D. (2019, July). Spare Parts Management in the Automotive Industry Considering Sustainability. In World Congress on Global Optimization (pp. 1109-1118). Springer, Cham.

  3. Braglia, M., Grassi, A., & Montanari, R. (2004). Multi-attribute classification method for spare parts inventory management. Journal of quality in maintenance engineering, 10(1), 55-65.

  4. Sharaf, M. A., & Helmy, H. A. (2001, February). A classification model for inventory management of spare parts. In INTERNATIONAL CONFERENCE ON PRODUCTION, INDUSTRIAL ENGINEERING, DESIGN AND CONTROLPEDAC (Vol. 7, p. 2001).

  5. Gajpal, P. P., Ganesh, L. S., & Rajendran, C. (1994). Criticality analysis of spare parts using the analytic hierarchy process. International journal of production economics, 35(1-3), 293-297.

  6. Botter, R., & Fortuin, L. (2000). Stocking strategy for service partsa case study. International Journal of Operations & Production Management, 20(6), 656-674.

  7. Wang, W. (2012). A stochastic model for joint spare parts inventory and planned maintenance optimisation. European Journal of Operational Research, 216(1), 127-139.

  8. Boylan, J. E., Syntetos, A. A., & Karakostas, G. C. (2008). Classification for forecasting and stock control: a case study. Journal of the operational research society, 59(4), 473-481.

  9. Antosz, K., & Ratnayake, R. C. (2019). Spare parts criticality assessment and prioritization for enhancing manufacturing systems availability and reliability. Journal of Manufacturing Systems, 50, 212- 225.

  10. Eaves, A. H., & Kingsman, B. G. (2004). Forecasting for the ordering and stock-holding of spare parts. Journal of the Operational Research Society, 55(4), 431-437.

  11. Ramanathan, R. (2006). ABC inventory classification with multiple- criteria using weighted linear optimization. Computers & Operations Research, 33(3), 695-700.

  12. Li, S. G., & Kuo, X. (2008). The inventory management system for automobile spare parts in a central warehouse. Expert Systems with Applications, 34(2), 1144-1153.

  13. Gutierrez, R. S., Solis, A. O., & Mukhopadhyay, S. (2008). Lumpy demand forecasting using neural networks. International Journal of Production Economics, 111(2), 409-420.

Leave a Reply

Your email address will not be published. Required fields are marked *