 Open Access
 Authors : M. H. Kibria , M. M. A. Khan , A. B. M. A. Malek , P. K. Biswas
 Paper ID : IJERTV8IS120386
 Volume & Issue : Volume 08, Issue 12 (December 2019)
 Published (First Online): 07012020
 ISSN (Online) : 22780181
 Publisher Name : IJERT
 License: This work is licensed under a Creative Commons Attribution 4.0 International License
Inventory Cost Minimization Through Item Categorization and Demand Forecasting: A Case Studybased 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

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 bestsuited for a spare part inventory with smooth, irregular, slowmoving, 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 Networkbased 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 (CategoryA 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 CategoryA items.


METHODOLOGY

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.

Item Categorization
In this study, items were categorized as moving and non moving. Items not used for more than three years were termed as nonmoving inventory. Items used at least once a year were designated as slowmoving inventory, and very high consumption and frequently moving items were denoted as fastmoving. However, in this study, slowmoving items were considered as moving items. Stockout items, critical items, and unused (idle) items were categorized as nonmoving 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
520%
5080%
B
2040%
2040%
C
5070%
525%

Demand Forecasting of categoryA 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 (13 months), mid (3 months2 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 t1 is greater than zero then Qt = 1, and if demand at t1 is zero than Qt = Qt1 + 1 = smoothing constant.
SyntetosBoylan 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

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 midperiod (simple moving average and potential smoothing), while for a longterm 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.

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.

The economic order quantity for Acategory 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 nonmoving items category in total items
= =

(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 leadtime 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 leadtime demand =
Where, Z is the number of standard deviations for a specific service level, and L denotes the lead time.


RESULTS AND DISCUSSION

Spare Parts Categorization
In this study, spare parts are initially classified as moving and nonmoving 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 nonmoving 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 Nonmoving items
The nonmoving items are further classified as critical, stock out, and idle. In this study, a nonmoving 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 stockout items. Any nonmoving item apart from the critical and stockout 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 nonmoving items. From the figure, it is apparent that among nonmoving items, 40% are stockout 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.

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%
CategoryB 1105 items
13.85% total cost
CategoryA
552 items
81.8% total cost
CategoryC 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

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 SyntetosBoylan 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.

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 nonmoving items
Cost Items
Nonmoving 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 nonmoving parts outnumbered moving ones, and the idle or unused parts, in particular, covered almost twofifth of the nonmoving 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%


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 SyntetosBoylan 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 twothird of their existing inventory cost.
REFERENCES

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.

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. 11091118). Springer, Cham.

Braglia, M., Grassi, A., & Montanari, R. (2004). Multiattribute classification method for spare parts inventory management. Journal of quality in maintenance engineering, 10(1), 5565.

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).

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(13), 293297.

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

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

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), 473481.

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.

Eaves, A. H., & Kingsman, B. G. (2004). Forecasting for the ordering and stockholding of spare parts. Journal of the Operational Research Society, 55(4), 431437.

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

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

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