Resistor Demand Prediction Using Manual Gradient Boosting Implementation for Inventory Optimization
Keywords:
Demand Prediction, Resistor, Gradient Boosting, Inventory Optimization, Time SeriesAbstract
This study proposes and evaluates a manual implementation of the Gradient Boosting algorithm for monthly resistor demand forecasting to optimize inventory in electronic component stores. Efficient inventory management is critical in a competitive market to ensure product availability and minimize costs. While conventional forecasting methods often struggle with demand instability in diverse resistor SKUs, Gradient Boosting offers robust capabilities for handling complex, non-linear patterns. Our methodology involves training the model on a small, simulated historical dataset (5 unique resistor IDs), using past demand data as features. The model's performance is evaluated using Mean Absolute Error (MAE) and Root Mean Squared Error (RMSE), which consistently decreased during 20 training iterations (final MAE 0.2529, RMSE 0.2938). The model successfully predicted demand for Month-4 and Month-5 using a sliding window strategy. These predictions have significant implications for reducing overstocking costs, preventing understocking, and optimizing purchasing decisions. However, the use of a very small simulated dataset is a major limitation, leading to overfitting and limiting the model's generalizability for real-world applications. This study primarily serves as a methodological illustration of the core principles of Gradient Boosting. Future work should focus on larger, real-world datasets and leveraging optimized libraries for enhanced accuracy and practical reliability
References
D. K. Vaka, “Integrating Inventory Management and Distribution: a Holistic Supply Chain Strategy,” International Journal of Managing Value and Supply Chains (IJMVSC), vol. 15, no. 2, p. 13, Jun. 2024.
V. Pasupuleti, B. Thuraka, C. S. Kodete, and S. Malisetty, “Enhancing Supply Chain Agility and Sustainability through Machine Learning: Optimization Techniques for Logistics and Inventory Management,” Logistics, vol. 8, no. 3, p. 73, 2024, doi: 10.3390/logistics8030073.
G. K. Mweshi, “Effects of Overstocking and Stockouts on the Manufacturing Sector,” International Journal of Advances in Engineering and Management (IJAEM), vol. 4, no. 9, pp. 1054–1064, Sep. 2022, doi: 10.35629/5252-040910541064.
R. Winurputra and D. E. Ratnawati, “Peramalan Penjualan Produk Menggunakan Extreme Gradient Boosting (XGBOOST) Dan Kerangka Kerja Crisp-Dm untuk Pengoptimalan Manajemen Persediaan (Studi Kasus: Ub Mart),” JTIIK, vol. 12, no. 2, pp. 417–428, Apr. 2025, doi: 10.25126/jtiik.2025129451.
S. B. Dalimunthe, R. Ginting, and S. Sinulingga, “The Implementation Of Machine Learning In Demand Forecasting : A Review Of Method Used In Demand Forecasting With Machine Learning,” j.sist.teknik.industri., vol. 25, no. 1, pp. 41–49, Jan. 2023, doi: https://doi.org/10.32734/jsti.v25i1.9290.
P. Dankorpho, “Sales Forecasting for Retail Business Using XGBoost Algorithm,” Journal of Computer Science and Technology Studies, vol. 6, no. 2, pp. 136–141, Jun. 2024, doi: https://doi.org/10.32996/jcsts.2024.6.2.15.
B. Auffarth, Machine Learning for Time-Series with Python: Forecast, Predict, and Detect Anomalies with State-of-the-Art Machine Learning Methods. Packt Publishing Ltd, 2021.
Y. Tadayonrad and A. B. Ndiaye, “A New Key Performance Indicator Model for Demand Forecasting in Inventory Management Considering Supply Chain Reliability and Seasonality,” Supply Chain Analytics, vol. 3, p. 100026, 2023, doi: https://doi.org/10.1016/j.sca.2023.100026.
K. Kanike, “Factors Disrupting Supply Chain Management in Manufacturing Industries,” Journal of Supply Chain Management Science, vol. 4, no. 1-2, pp. 1–24, 2023, doi: https://doi.org/10.18757/jscms.2023.6986.
T. Chen and C. Guestrin, "XGBoost: A Scalable Tree Boosting System," in Proc. ACM SIGKDD Int. Conf. Knowl. Discovery Data Mining, 2016, pp. 785–794, doi: 10.1145/2939672.2939785.
J. H. Friedman, “Greedy Function Approximation: A Gradient Boosting Machine,” Ann. Stat., vol. 29, no. 5, pp. 1189–1232, 2001.
T. Hastie, R. Tibshirani, and J. Friedman, The Elements of Statistical Learning: Data Mining, Inference, and Prediction, 2nd ed. New York, NY, USA: Springer, 2009.
Z. He, D. Lin, T. Lau, and M. Wu, “Gradient Boosting Machine: A Survey,” arXiv:1908.06951 [cs.LG], 2019, doi: 10.48550/arXiv.1908.06951.
A. Géron, Hands-on Machine Learning with Scikit-Learn, Keras, and TensorFlow: Concepts, Tools, and Techniques to Build Intelligent Systems. O’Reilly Media, Inc., 2022.
“Standard Resistor Values,” Logwell.com. [Online]. Available: https://www.logwell.com/tech/components/resistor_values.html. [Accessed: Jun. 6, 2025].
“Standard Resistor Values E24,” Asenergi.com. [Online]. Available: https://asenergi.com/pdf/resistors/standard-resistor-values-e24.pdf. [Accessed: Jun. 6, 2025].
“Standard Resistor Series Values: E3, E6, E12, E24, E48, E96, E192,” ElectricalVolt.com. [Online]. Available: https://www.electricalvolt.com/standard-resistor-series-values-e3-e6-e12-e24-e48-e96/#h-resistors-e-series-values-and-tolerance-band. [Accessed: Jun. 6, 2025].
“Resistor Chart: Comprehensive Guide to Resistor Values, E-Series, and Color Codes,” Wevolver. [Online]. Available: https://www.wevolver.com/article/resistor-chart-comprehensive-guide-to-resistor-values-e-series-and-color-codes [Accessed: Jun. 7, 2025].
A. V. Tatachar, “Comparative Assessment of Regression Models Based On Model Evaluation Metrics,” International Research Journal of Engineering and Technology (IRJET), vol. 8, no. 09, pp. 853–860, Sep. 2021.
D. Chicco, M. J. Warrens, and G. Jurman, “The coefficient of determination R-squared is more informative than SMAPE, MAE, MAPE, MSE and RMSE in regression analysis evaluation,” PeerJ Computer Science., vol. 7, p. e623, 2021.
R. J. Hyndman and G. Athanasopoulos, Forecasting: Principles and Practice, 3rd ed. Melbourne: OTexts, 2021. [Online]. Available: https://otexts.com/fpp3/.
S. Ben Taieb, G. Bontempi, A. F. Atiya, and A. Sorjamaa, “A review and comparison of strategies for multi-step ahead time series forecasting based on the NN5 forecasting competition,” Neurocomputing, vol. 73, no. 10-12, pp. 3428–3438, 2010, doi: 10.1016/j.neucom.2010.01.032
