Optimization of Bread Inventory Requirement Estimation Using Multiple Linear Regression Method at Coffeebox Medan
DOI:
https://doi.org/10.35335/jict.v15i2.185Keywords:
Bread Ordering, Sales, Inventory Estimation, Multiple Linear Regression, Stock Managemen.Abstract
Proper bread inventory management is very important to avoid shortages or waste of stock at Coffeebox, which has been experiencing problems in estimating inventory needs due to manual data management. This study aims to develop a bread inventory requirement estimation model using the multiple linear regression method with bread ordering and bread sold variables. The data used consists of 29 observation samples which are processed through regression calculations to obtain regression coefficients and linear equations. The results showed that the resulting model has the formula Y = 3.152506333 + 0.03249542 X₁ + 0.012684868 X₂, with an estimated bread inventory requirement of 107 boxes based on daily demand and sales data. The implication of these findings is that multiple linear regression models can be used to optimize stock management and improve operational efficiency at Coffeebox. This study has limitations in terms of the variables used, so future research is recommended to expand the model by considering other external variables or using more complex methods such as machine learning algorithms to improve prediction accuracy.
References
Abolghasemi, M., Hurley, J., Eshragh, A., & Fahimnia, B. (2020). Demand forecasting in the presence of systematic events: Cases in capturing sales promotions. International Journal of Production Economics, 230, 107892.
Andrei, B.-A., Casu-Pop, A.-C., Gheorghe, S.-C., & Boiangiu, C.-A. (2019). A study on using waterfall and agile methods in software project management. Journal of Information Systems & Operations Management, 125–135.
Baylen, L. N. L. (2020). Analysis of inventory management systems of selected small-sized restaurants in Quezon province: Basis for an inventory system manual. Journal of Business and Management Studies, 2(3), 9–18.
Brandtner, P., Darbanian, F., Falatouri, T., & Udokwu, C. (2021). Impact of COVID-19 on the customer end of retail supply chains: A big data analysis of consumer satisfaction. Sustainability, 13(3), 1464.
Halbritter, A. H., De Boeck, H. J., Eycott, A. E., Reinsch, S., Robinson, D. A., Vicca, S., Berauer, B., Christiansen, C. T., Estiarte, M., & Grünzweig, J. M. (2020). The handbook for standardized field and laboratory measurements in terrestrial climate change experiments and observational studies (ClimEx). Methods in Ecology and Evolution, 11(1), 22–37.
Inastiana, F., Triayudi, A., & Handayani, E. T. E. (2020). Implementation of the Waterfall Method for Designing Sisar (Archive Information System) at the National University: Implementation of the Waterfall Method for Designing Sisar (Archive Information System) at the National University. Jurnal Mantik, 4(1), 647–653.
Manurung, J., Mawengkang, H., & Zamzami, E. (2017). Optimizing Support Vector Machine Parameters with Genetic Algorithm for Credit Risk Assessment. Journal of Physics: Conference Series, 930(1), 12026. https://doi.org/10.1088/1742-6596/930/1/012026
MOHAJAN, H. K. (2018). Qualitative Research Methodology in Social Sciences and Related Subjects. Journal of Economic Development, Environment and People, 7(1), 23. https://doi.org/10.26458/jedep.v7i1.571
Mohd Fuzi, N. H. (2021). Restaurant Management System for SME Restaurant.
Mujasi, B. (2021). Inventory management practices and operational performance of fast food restaurants: a case of Java house Uganda. Kyambogo University.
Pawar, R. S., Sonje, S. A., & Shukla, S. (2021). Food subsidy distribution system through Blockchain technology: a value focused thinking approach for prototype development. Information Technology for Development, 27(3), 470–498.
Ramos, E., Pettit, T. J., Flanigan, M., Romero, L., & Huayta, K. (2020). Inventory management model based on lean supply chain to increase the service level in a distributor of automotive sector. International Journal of Supply Chain Management, 9(2), 113–131.
RASHID, A., RASHEED, R., AMIRAH, N. A., & AFTHANORHAN, A. (2022). Disruptive factors and customer satisfaction at chain stores in Karachi, Pakistan. Journal of Distribution Science, 20(10), 93–103.
Senarath, U. S. (2021). Waterfall methodology, prototyping and agile development. Tech. Rep., 1–16.
Sitorus, T., & Yustisia, M. (2018). The influence of service quality and customer trust toward customer loyalty: the role of customer satisfaction. International Journal for Quality Research, 12(3), 639.
Strotmann, C., Baur, V., Schultz, M., Büttner, S., Rothe, M., & Pfaff, T. (2023). Reducing returned bakery products and promoting sustainability-Preparing bakery staff for the use of digital forecasting tools. FH Münster University of Applied Sciences.
Jurnal ICT : Information and Communication Technologies is licensed under a 