Forecasting Methods to Reduce Inventory Level in Supply Chain

Abstract

Based on the two-level supply chain composed of suppliers and retailers, we assume that market demand is subject to an ARIMA(1, 1, 1). The supplier uses the minimum mean square error method (MMSE), the simple moving average method (SMA) and the weighted moving average method (WMA) respectively to forecast the market demand. According to the statistical properties of stationary time series, we calculate the mean square error between supplier forecast demand and market demand. Through the simulation, we compare the forecasting effects of the three methods and analyse the influence of the lead-time L and the moving average parameter N on prediction. The results show that the forecasting effect of the MMSE method is the best, of the WMA method is the second, and of the SMA method is the last. The results also show that reducing the lead-time and increasing the moving average parameter improve the prediction accuracy and reduce the supplier inventory level.

Share and Cite:

Cai, T. and Li, X. (2022) Forecasting Methods to Reduce Inventory Level in Supply Chain. Journal of Applied Mathematics and Physics, 10, 301-310. doi: 10.4236/jamp.2022.102023.

1. Introduction

Inventory problem has been an important problem in supply chain. Enterprise in the supply chain has been looking for ways to reduce their inventory levels because savings in inventory levels will eventually translate into cost savings over time. In order to control inventory, we must improve the forecasting accuracy. Many pieces of literature have proved that information sharing is an effective method to improve forecasting accuracy and reduce average inventory level. Suppliers hope to have stable quantity, stable variety demand, abundant and flexible delivery time, while retailers hope suppliers can deliver goods efficiently. Information sharing promotes the coordinated operation of supply chain. When sharing sales forecasting and inventory information, suppliers can know the demand and inventory of retailers in advance. Thus, we can shorten the delivery time, reduce the demand difference, and reduce the inventory cost and shortage cost [1] [2]. However, because of the importance of information, enterprises are reluctant to share information about themselves. Supply chain enterprises can only rely on improving forecasting accuracy to reduce their inventory level. Scholars at home and abroad put forward many methods to improve the accuracy of prediction. These methods analyze supply chain demand forecasting and inventory control from different aspects. The literature [3] [4] [5] has studied two-level supply chain under ARMA(1, 1), AR(1) and MA(1) demand processes. It studied effects of single exponential smoothing method and simple moving average method on mean square error and inventory level, which show that the saving of inventory cost depends on the improvement of forecasting accuracy. The literature [6] [7] use simple moving average method and weighted moving average method to forecast demand based on ARMA(p, q) demand process. The research shows that forecasting can save the inventory cost. The literature [8] [9] introduced exponential smoothing method and simple moving average method to infer downstream demand, and studied how manufacturers prepare inventory. Feng [10] shows that as for ARIMA(1, 1, 1) demand process, using moving average method to forecast the demand on lead-time can reduce the phenomenon of demand amplification. There are also many scholars optimizing some forecasting methods to improve the forecasting accuracy. Rhee improved forecast accuracy by controlling scheduled orders [11]. Huang [12] improved the forecasting accuracy of order demand by optimizing genetic algorithm. In some ways, the above strategies reduce the bullwhip effect and improve the forecasting accuracy. However, some errors will inevitably occur when using these strategies to forecast, and these errors will be amplified by suppliers step by step in the supply chain, which will lead to large fluctuations in the inventory system [13]. Therefore, this study starts from forecasting methods and forecasting errors to study the influence of three different forecasting strategies on supplier.

We base our modeling framework on the works of Tliche et al., considering the two-level supply chain composed of a supplier and a retailer. Different from the previous time series demand model, we assume that the market demand obeys an autoregressive integrated moving average model ARIMA(1, 1, 1). We adopt the minimum mean square error method, the simple moving average method and the weighted moving average method to forecast the retailer’s demand, and take the mean square error as an indicator to measure the forecasting effect.

2. Framework Model Assumptions

We consider a simple two-level supply chain composed of a supplier and a retailer. We keep the same assumptions as in Tliche et al.’s model, excepting the ARIMA(1, 1) demand process. The parameters of the demand process are known. Both the supplier and the retailer use periodic review system. At time period t, the retailer first receives an order x t from the market, and then checks its inventory, and before the periodt ends, send out the order to the supplier. We assume that the order information transfer time is zero.

The supplier starts to forecast the retailer’s orders at the end of the period t L 1 , then prepare the goods and send them to the retailer. Although the supplier does not receive the order from the retailer until the end of the periodt, the supplier has already sent the goods to the retailer at the end of the periodt. Due to the difference between the supplier’s forecasting and the retailer’s actual order, the retailer may receive more or less goods. The retailer can store the surplus goods for next period using. As for the insufficient part, the supplier will reissue the insufficient goods to the retailer. L represents the retailer’s order lead-time (the time from production to delivery). The retailer’s order lead-time is non-zero and deterministic.

Time-series process is widely used to simulate the demands of products in different fields. At time period t ( t = 1 , 2 , ), We assume that arriving demand is an invertible causal process ARIMA(1, 1, 1) at the retailer. Let x t be the ARIMA(1, 1, 1) demand process at the retailer, such as

ϕ ( B ) ( 1 B ) x t = θ ( B ) ε t (1)

where ϕ ( B ) = 1 ϕ 1 B , θ ( B ) = 1 θ 1 B , B is the lag operator, ϕ 1 is autoregressive coefficient, θ 1 is moving average coefficient. { ε t } represents the fluctuation error of demand, independent and identically distributed at each period, E ( ε t ) = 0 , V a r ( ε t ) = σ 2 . The equivalent form is

x t = ( 1 + ϕ 1 ) x t 1 ϕ 1 x t 2 + ε t θ 1 ε t 1 (2)

According to the sufficient and necessary conditions that ARIMA is causal and invertible, we can get the condition of model ARIMA(1, 1, 1) stability is { ϕ 1 | | ϕ 1 | < 1 } , and the condition of model ARIMA(1, 1, 1) invertibility is { θ 1 | | θ 1 | < 1 } .

Use the linear equation of the fluctuation error term ε t to represent the demand function x t , then

x t = ε t + ψ 1 ε t 1 + ψ 2 ε t 2 + ψ 3 ε t 3 = j = 0 ψ j ε t j (3)

where ψ 0 = 1 , ψ 1 = 1 + ϕ 1 θ 1 , ψ j = ( 1 + ϕ 1 ) ψ j 1 ϕ 1 ψ j 2 , j = 2 , 3 , .

According to the characteristics of the demand equation, it can be concluded that the total demand of retailers over the L + 1 review periods is

i = 1 L + 1 x t + i = i = 1 L + 1 j = 0 ψ j ε t + i j (4)

3. Suppliers Production Strategy

The supplier’s production strategy is based on the forecasting demand or the retailer’s order. Since the supplier makes production plans in advance, the strategy is based on the supplier’s own forecast rather than the retailer’s order. We consider the three forecasting methods: Minimum Mean Square Error method (MMSE), Simple Moving Average method (SMA) and Weighted Moving Average method (WMA). Our objective is to find the most accurate forecasting method. The mean square error (MSE) is a good matric to measure the difference between the forecast and the true demand, and easy to compute. So we use it to compare the three prediction methods. The less the mean square error is, the more effective the forecasting method is.

3.1. Principle of Minimum Mean Square Error Prediction

The supplier adopts the MMSE method. According to the characteristics of demand process, at the time period t + L , the true value of market demand is

x t + L = ( ε t + L + ψ 1 ε t + L 1 + ψ 2 ε t + L 2 + + ψ L 1 ε t + 1 ) + ( ψ L ε t + ψ L + 1 ε t 1 + ) (5)

where ε t , ε t 1 , are known and ε t + L , ε t + L 1 , , ε t + 1 are unmeasured. Suppose the retailer’s forecasting demand at the period i + L is

f t + L M M S E = ψ 0 ε t + ψ 1 ε t 1 + ψ 2 ε t 2 + (6)

The mean square error between the forecast and the demand is

E ( x t + L f t + L M M S E ) 2 = ( 1 + ψ 1 2 + + ψ L 1 2 ) σ 2 + j = 0 ( ψ L + j ψ j ) 2 σ 2 (7)

To minimize the mean square error, if and only if

ψ j = ψ L + j (8)

Therefore, at time period t + i , under the principle of minimizing the mean square error, the forecast is

f t + i M M S E = ψ i ε t + ψ i + 1 ε t 1 + ψ i + 2 ε t 2 + (9)

The mean square error of the supplier’s forecasts over the L + 1 review periods is

M S E M M S E = E ( i = 1 L + 1 x t + i i = 1 L + 1 f t + i M M S E ) 2 = V a r ( i = 1 L + 1 ( x t + i f t + i M M S E ) ) = V a r ( i = 1 L + 1 ( ε t + i + ψ 1 ε t + i 1 + ψ 2 ε t + i 2 + + ψ i 1 ε t + 1 ) ) = V a r ( i = 0 L ψ i ε t + 1 + i = 0 L 1 ψ i ε t + 2 + + i = 0 1 ψ i ε t + 1 + i = 0 0 ψ i ε t + 1 ) = ( i = 0 L ψ i ) 2 σ 2 + ( i = 0 L 1 ψ i ) 2 σ 2 + + ( i = 0 0 ψ i ) 2 σ 2 = σ 2 [ i = 0 L ( j = 0 i ψ j ) 2 ] (10)

3.2. Principle of Simple Moving Average Prediction

The supplier adopts the SMA method. The predicting values of the market demand at period t + i is

f t + i S M A = x t + x t 1 + x t 2 + + x t N + 2 + x t N + 1 N (11)

where x t , x t 1 , , x t N + 1 are the true demand at period t , t 1 , , t N + 1 , and N is the order of the simple moving average. Then, the sum of the foercasts over the L + 1 review periods is

i = 1 L + 1 f t + i S M A = ( L + 1 ) ( x t + x t 1 + x t 2 + + x t N + 2 + x t N + 1 N ) = ( L + 1 ) f t + 1 (12)

The mean square error of the supplier’s forecasts over the L + 1 review periods is

M S E S M A = E ( i = 1 L + 1 x t + i i = 1 L + 1 f t + i S M A ) 2 = V a r ( i = 1 L + 1 x t + i ( L + 1 ) ( x t + x t 1 + x t 2 + + x t N + 2 + x t N + 1 N ) ) = V a r ( i = 1 L + 1 x t + i ) + ( L + 1 ) 2 V a r ( f t + 1 ) 2 ( L + 1 ) cov ( i = 1 L + 1 x t + i , f t + 1 ) = ( L + 1 ) γ 0 + 2 i = 1 L i γ L + 1 i + ( L + 1 ) 2 [ γ 0 N + 2 N 2 i = 1 N 1 i γ N i ] 2 ( L + 1 ) N i = 1 L + 1 k = 0 N 1 γ i + k (13)

where γ k = cov ( x t + k , x t ) is the covariance of x t + k and x t in the demand process ARIMA(1, 1, 1) that only depends on the length of period translation and has nothing to do with the start period and the end period. They are determined by

γ 0 = γ ( x t , x t ) = ( 1 + ϕ 1 ) γ 1 ϕ 1 γ 2 + σ 2 ( 1 θ 1 ψ 1 ) γ 1 = γ ( x t , x t + 1 ) = ( 1 + ϕ 1 ) γ 0 ϕ 1 γ 1 σ 2 θ 1 γ k = γ ( x t + k , x t ) = ( 1 + ϕ 1 ) γ k 1 ϕ 1 γ k 2 ( k 2 ) (14)

3.3. Principle of Weighted Moving Average Prediction

The supplier adopts the WMA method to forecast next period demand, and the forecasting value at period t + i is

f t + i W M A = i = 1 N y i x t + 1 i (15)

where y i is the weight vector, and i = 1 N y i = 1 , y i 0 , i { 1 N } . The total forecasting demand over the L + 1 review periods is

i = 1 L + 1 f t + i W M A = ( L + 1 ) ( i = 1 N y i x t + 1 i ) (16)

The mean square error of the supplier’s forecasts over the L + 1 review periods is

M S E W M A = E ( i = 1 L + 1 x t + i i = 1 L + 1 f t + i W M A ) 2 = V a r ( i = 1 L + 1 x t + i ( L + 1 ) f t + i W M A ) = V a r ( i = 1 L + 1 x t + i ) + ( L + 1 ) 2 V a r ( f t + i W M A ) 2 ( L + 1 ) cov ( i = 1 L + 1 x t + i , f t + i W M A ) = ( L + 1 ) γ 0 + 2 i = 1 L i γ L + 1 i + ( L + 1 ) 2 [ γ 0 i = 1 N y i 2 + 2 j = 1 N 1 ( y j i = j + 1 N y i γ i j ) ] 2 ( L + 1 ) i = 1 L + 1 j = 1 N y i γ i + j 1 (17)

To determine the weights of the WMA method, we solve the optimization problem

{ min M S E W M A i = 1 N y i = 1 y i 0 , i { 1 N } (18)

The objective function is convex and the constraint conditions are linear equality constraint and linear inequality constraint. In each iteration, the initial feasible point is selected and the feasible point is taken as the starting point. The constraint acting at this point is taken as the equality constraint, and the objective function is minimized under this constraint, while the other constraints are left alone. After finding a new and better feasible point, repeat the above process until the best point is found. In this paper, according to the effective set method, we use MATLAB program iteration, and then the optimal weights for different objective functions and constraint functions are obtained.

From the three subsections we conclude that the SMA method is easy to compute and therefore is easy to use in practice, but it relies on the observations of the most recent N periods, does not apply to the processes with curvilinear trends and seasonal trends, and therefore can be used only for short-term prediction. The MMSE method is applicable to a wide range, but difficult to compute. With repect to the WMA method, it is easier to compute than the MMSE method, more difficult than the SMA method, and not applicable for long-term prediction as the SMA method.

4. Simulation Calculation

In this section, we through numerical simulation to analyze the influence of parameters on the mean square error, and how these parameters affect the mean square error. According to the equation mode of parameters, we summarize some measures that can help managers control inventory. We use the effective set method to calculate the optimal weight, and apply the optimal weight to our simulation experiment. All the values selected in this paper have been used in the previous literature. The selected data simulation results are the most clear, so it is shown as an example. Through a large number of simulations, we find that the simulation results obtained by selecting other data are the same. In the simulation part, we use MATLAB programming software design the algorithms.

It can be seen from the expression of mean square error that the size of mean square error is related to parameters L , N , ϕ 1 , θ 1 . Since parameters ϕ 1 , θ 1 do not determine changes in inventory strategy and order form, and it has no effect on demand forecasting in lead-time, so we are not going to talk too much about their values. We only consider the influence of lead-time L and sampling period N on the mean square error.

4.1. Comparison of the Three Prediction Methods

In the first part of the simulation, we take the regression coefficient, the moving average term and the moving average parameter as follows: ϕ 1 = 0.25 ; θ 1 = 0.1 ; N = 12 . The mean square errors of the three forecasting methods varying with the lead-time L are shown in Figure 1(a). The mean square errors percentage reductions of the MMSE method relative to the other forecasting methods are shown in Figure 1(b).

It can be seen from Figure 1(a) that no matter which forecasting method is adopted, the error of the demand forecast will increase as the lead-time increases. This is consistent with the facts. As the lead-time increases, the forecast period becomes longer, which leads to a larger forecasting error. When the lead-timeL is given, it can be seen from Figure 1(a) that the mean square error of the MMSE method is significantly smaller than that of the SMA method or the WMA method, and the forecasting effect is the best. The mean square error of the SMA method is the most, and the forecasting effect is the worst. The mean square error of the WMA method is between the MMSE method and the SMA method, and its forecasting effect is also between them. It is suggested that managers can shorten the forecast lead-time as much as possible in order to improve the forecasting accuracy and reduce inventory holding.

From Figure 1(b), when the lead-timeL is smaller, the mean square errors percentage reductions of the MMSE method relative to the others are more. With the lead-timeL increases, the mean square errors percentage reductions decrease. It implies that the prediction gaps between the MMSE method and the other methods narrow as the lead-timeL increases.

4.2. Comparison between Simple Moving Average Method and Weighted Moving Average Method

In the second part of the simulation, we take the regression coefficient and moving average term, lead-time as follows. ϕ 1 = 0.8 ; θ 1 = 0.1 ; L = 5 . Since the MMSE method does not rely on the moving average parameterN, we mainly compare the SMA with the WMA method in this part. The mean square errors of the two forecasting methods varying with the moving average parameter N are shown in Figure 2(a). The mean square errors percentage reduction of the WMA method relative to the SMA method is shown in Figure 2(b).

(a)(b)

Figure 1. (a) MSE varies with the lead-time L; (b) The MSE percentage reduction of the MMSE method.

(a)(b)

Figure 2. (a) MSE varies with the moving average parameter N; (b) The MSE percentage reduction of the WMA method.

As can be seen from Figure 2(a), when changingN among [ 5 , 12 ] , the mean square error of the SMA method or the WMA method decreases with the increase of N. When the moving average parameterN is given, the mean square error of the SMA method is greater than that of the WMA method. The forecasting effect of the WMA method is better than that of the SMA method. It is consistent with the fact, the more the moving average parameterN is, the better the forecasting effect is. We suggest that managers increase the moving average parameterN as much as possible in order to improve the forecasting accuracy.

Figure 2(b) shows that when the moving average parameterN is more, the mean square errors percentage reduction of the WMA method relative to the SMA method is more. As the moving average parameterN increases, the mean square errors percentage reduction increases. It implies that the prediction gap between the two moving average methods increases as the moving average parameter N increases.

5. Results and Discussion

This paper mainly studies three forecasting methods in the two-level supply chain. We calculate the mean square error of the three forecasting methods and analyze the influence of the lead-timeL and the moving average parameterN on mean square error. The results show that reducing the lead time and increasing the moving average parameter can improve the forecasting accuracy. Different forecasting methods have different forecasting effects. With the mean square error as the evaluation indicator, we conclude that the forecasting effect of the MMSE method is the best, of the WMA method is the second, and of the SMA method is the last. Not every forecasting method can be applied to all situations, so supplier should choose the forecasting method scientifically and practically.

Acknowledgements

This work was supported by the National Natural Science Foundation of China (12071112).

Conflicts of Interest

The authors declare no conflicts of interest regarding the publication of this paper.

References

[1] Sabitha, D., Rajendran, C., Kalpakam, S. and Ziegler, H. (2016) The Value of Information Sharing in a Serial Supply Chain with AR (1) Demand and Non-Zero Replenishment Lead Times. European Journal of Operational Research, 255, 758-777.
https://doi.org/10.1016/j.ejor.2016.05.016
[2] Kovtun, V., Giloni, A. and Hurvich, C. (2019) The Value of Sharing Disaggregated Information in Supply Chains. European Journal of Operational Research, 277, 469-478.
https://doi.org/10.1016/j.ejor.2019.02.034
[3] Ali, M.M., E.boylan, J. and A.syntetos, A. (2012) Forecast Errors and Inventory Performance under Forecast Information Sharing. International Journal of Forecasting, 28, 830-841.
https://doi.org/10.1016/j.ijforecast.2010.08.003
[4] Ali, M.M., Babai, M.Z., Boylan, J.E. and A.Syntetos A. (2017) Supply Chain Forecasting When Information Is Not Shared. European Journal of Operational Research, 260, 984-994.
https://doi.org/10.1016/j.ejor.2016.11.046
[5] Rostami-Tabar, B., Babai, M.Z., Ali, M. and Boylan, J.E. (2018) The Impact of Temporal Aggregation on Supply Chains with ARMA (1, 1) Demand Processes. European Journal of Environmental Science Operational Research, 273, 920-932.
https://doi.org/10.1016/j.ejor.2018.09.010
[6] Tliche, Y., Taghipour, A. and Canel-depitre, B. (2019) Downstream Demand Inference in Decentralized Supply Chains. European Journal of Operational Research, 274, 65-77.
https://doi.org/10.1016/j.ejor.2018.09.034
[7] Tliche, Y., Taghipour, A. and Canel-Depitre, B. (2020) An Improved Forecasting Approach to Reduce Inventory Levels in Decentralized Supply Chains. European Journal of the Operational Research, 287, 511-527.
https://doi.org/10.1016/j.ejor.2020.04.044
[8] Giloni, A., Hurvich, C. and Seshadri, S. (2014) Forecasting and Information Sharing in Supply Chains under ARMA Demand. IIE Transactions, 46, 35-54.
https://doi.org/10.1080/0740817X.2012.689122
[9] Ali, M.M and Boylan, J.E. (2012) On the Effect of Non-Optimal Forecasting Methods on Supply Chain Downstream Demand. IMA Journal of Management Mathematics, 23, 81-98.
https://doi.org/10.1093/imaman/dpr005
[10] Feng, Y. and Ma, J.H. (2008) Demand Forecasting in Supply Chain Based on ARMA (1, 1) Process. Industrial Engineering, 11, 50-55.
[11] Rhee, Y. (2021) An Analysis and Validation of Effectiveness on Demand Forecasting Considering the Planned Order Effect. American Journal of Industrial and Business Management, 11, 1036-1051.
https://doi.org/10.4236/ajibm.2021.1110063
[12] Huang, J.Q., Zhang, A.J. and Zhao, G.M. (2018) Hybrid Genetic Particle Swarm Optimization Algorithm for Forecast of Orders Demand Based on Low Deviation Sequence. Journal of Yibin University, 18, 38-40.
[13] He, H.D. and Wang, Y. (2017) Study of Predicted Error on Stability for Linear Supply Chain. Guangxi Science, 24, 327-332.

Copyright © 2023 by authors and Scientific Research Publishing Inc.

Creative Commons License

This work and the related PDF file are licensed under a Creative Commons Attribution 4.0 International License.