Minitab 20 and Python based-the forecasting of demand and optimal inventory of liquid aluminum sulfate supplies

Oki Dwipurwani, Fitri Maya Puspita, Siti Suzlin Supadi, Evi Yuliza


In a company, inventory management is crucial due to the significant impact on various aspects of the business. Similarly, the Indonesian water supply company (PDAM) requires effective inventory management to ensure the supply of liquid aluminum sulfate chemicals. The probabilistic statistical inventory control (SIC) model is commonly used for inventory management. However, previous research on chemical inventory models in PDAMs often relied on simple linear regression to forecast demand data, which fails to capture the inherent volatility in demand. Therefore, this research aimed to predict demand data using the seasonal autoregressive integrated moving average (SARIMA) method and determine the optimal policy for supplying liquid aluminum sulfate chemicals. The results showed that the best demand forecasting model was SARIMA (2,1,2) (1,1,0)12 with a mean absolute percentage error (MAPE) value of 8.19%. The finding of the optimal inventory policy showed a safety stock value of 11,922.35 kg, a reorder point value of 49,511.20 kg, and an order quantity of 21,526.59 kg, leading to a total cost of IDR 11,132,034,145.45. The sensitivity test also showed that variations in lead time, price, μ, and σ parameters directly influence changes in total cost, reorder point, and safety stock. These calculations were conducted using Minitab and Python software.


Liquid aluminum sulfate; Normal probability distributed; Probabilistic inventory; Seasonal ARIMA; Sensitivity analysis; Statistical inventory control

Full Text:




  • There are currently no refbacks.

Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.

Indonesian Journal of Electrical Engineering and Computer Science (IJEECS)
p-ISSN: 2502-4752, e-ISSN: 2502-4760
This journal is published by the Institute of Advanced Engineering and Science (IAES) in collaboration with Intelektual Pustaka Media Utama (IPMU).

shopify stats IJEECS visitor statistics