JOINT EFFECT OF FORECASTING AND LOT-SIZING METHOD ON COST MINIMIZATION OBJECTIVE OF A MANUFACTURER: A CASE STUDY
Jack OLESEN
subrata.scm@gmai.comAalborg University, Department of Materials and Production, , DK 9220, Aalborg East (Denmark)
Carl-Emil Houmøller PEDERSEN
*Aalborg University, Department of Materials and Production, DK 9220, Aalborg East (Denmark)
Markus Germann KNUDSEN
Aalborg University, Department of Materials and Production, , DK 9220, Aalborg East (Denmark)
Sandra TOFT
Aalborg University, Department of Materials and Production, DK 9220, Aalborg East (Denmark)
Vladimir NEDBAILO
Aalborg University, Department of Materials and Production, DK 9220, Aalborg East (Denmark)
Johan PRISAK
Production Manager, Fibertex Personal Care Group, Aalborg (Denmark)
Izabela Ewa NIELSEN
Aalborg University, Department of Materials and Production, DK 9220, Aalborg East (Denmark)
Subrata SAHA
Aalborg University, Department of Materials and Production, DK 9220, Aalborg East (Denmark)
Abstract
Forecasting and lot-sizing problems are key for a variety of products manufactured in a plant of finite capacity. The plant manager needs to put special emphasis on the way of selecting the right forecasting methods with a higher level of accuracy and to conduct procurement planning based on specific lot-sizing methods and associated rolling horizon. The study is conducted using real case data form the Fibertex Personal Care, and has evaluated the joint influence of forecasting procedures such as ARIMA, exponential smoothing methods; and deterministic lot-sizing methods such as the Wagner-Whitin method, modified Silver-Meal heuristic to draw insights on the effect of the appropriate method selection on minimization of operational cost. The objective is to explore their joint effect on the cost minimization goal. It is found that a proficient selection process has a considerable impact on performance. The proposed method can help a manager to save substantial operational costs.
Keywords:
Forecasting, ARIMA, Inventory management, Lot-sizing, Economies-of-scale, Production planning, HeuristicReferences
Ali, M., & Miller, L. (2017). ERP system implementation in large enterprises–a systematic literature review. Journal of Enterprise Information Management, 30(4), 666–692. https://doi.org/10.1108/JEIM-072014-0071
DOI: https://doi.org/10.1108/JEIM-07-2014-0071
Google Scholar
Alotaibi, Y. (2016). Business process modelling challenges and solutions: a literature review. Journal of Intelligent Manufacturing, 27(4), 701–723. https://doi.org/10.1007/s10845-014-0917-4
DOI: https://doi.org/10.1007/s10845-014-0917-4
Google Scholar
Andriolo, A., Battini, D., Grubbström, R. W., Persona, A., & Sgarbossa, F. (2014). A century of evolution from Harris’s basic lot size model: Survey and research agenda. International Journal of Production Economics, 155, 16-38. https://doi.org/10.1016/j.ijpe.2014.01.013
DOI: https://doi.org/10.1016/j.ijpe.2014.01.013
Google Scholar
Bach, I., Bocewicz, G., Banaszak, Z. A., & Muszyński, W. (2010). Knowledge based and CP-driven approach applied to multi product small-size production flow. Control and Cybernetics, 39, 69–95.
Google Scholar
Baker, K. R. (1989). Lot-sizing procedures and a standard data set: a reconciliation of the literature. Journal of Manufacturing and Operations Management, 2(3), 199–221.
Google Scholar
Bocewicz, G., Nielsen, P., & Banaszak, Z. (2019). Declarative modeling of a milk-run vehicle routing problem for split and merge supply streams scheduling. Advances in Intelligent Systems and Computing, 853, 157–172. https://doi.org/10.1007/978-3-319-99996-8_15
DOI: https://doi.org/10.1007/978-3-319-99996-8_15
Google Scholar
Bocewicz, G., Nielsen, P., Banaszak, Z., & Thibbotuwawa, A. (2018). Routing and scheduling of unmanned aerial vehicles subject to cyclic production flow constraints. In International Symposium on Distributed Computing and Artificial Intelligence (pp. 75–86). Springer, Cham. https://doi.org/10.1007/978-3-319-99608-0_9
DOI: https://doi.org/10.1007/978-3-319-99608-0_9
Google Scholar
Box, G. E., Jenkins, G. M., & Reinsel, G. C. (2011). Time series analysis: forecasting and control (Vol. 734). John Wiley & Sons. https://doi.org/0.1111/jtsa.12194
Google Scholar
De Bodt, M. A., Gelders, L. F., & Van Wassenhove, L. N. (1984). Lot sizing under dynamic demand conditions: A review. Engineering Costs and Production Economics, 8(3), 165–187. https://doi.org/10.1016/0167188X(84)90035-1
DOI: https://doi.org/10.1016/0167-188X(84)90035-1
Google Scholar
Drexl, A., & Kimms, A. (1997). Lot sizing and scheduling—survey and extensions. European Journal of operational research, 99(2), 221–235. https://doi.org/10.1016/S0377-2217(97)00030-1
DOI: https://doi.org/10.1016/S0377-2217(97)00030-1
Google Scholar
Eriksen, P. S., & Nielsen, P. (2016). Order quantity distributions: Estimating an adequate aggregation horizon. Management and Production Engineering Review, 7(3), 9–48. https://doi.org/10.1515/mper-2016-0024
DOI: https://doi.org/10.1515/mper-2016-0024
Google Scholar
Fildes, R., Goodwin, P., Lawrence, M., & Nikolopoulos, K. (2009). Effective forecasting and judgmental adjustments: an empirical evaluation and strategies for improvement in supplychain planning. International journal of forecasting, 25(1), 3–23. https://doi.org/10.1016/j.ijforecast.2008.11.010
DOI: https://doi.org/10.1016/j.ijforecast.2008.11.010
Google Scholar
Gola A. (2014) Economic Aspects of Manufacturing Systems Design. Actual Problems of Economics, 156(6), 205–212.
Google Scholar
Grubbström, R. W., & Tang, O. (2012). The space of solution alternatives in the optimal lotsizing problem for general assembly systems applying MRP theory. International Journal of Production Economics, 140(2), 765777. https://doi.org/10.1016/j.ijpe.2011.01.012
DOI: https://doi.org/10.1016/j.ijpe.2011.01.012
Google Scholar
Grubbström, R. W., Bogataj, M., & Bogataj, L. (2010). Optimal lotsizing within MRP theory. Annual Reviews in Control, 34(1), 89–100. https://doi.org/10.3182/20090603-3-RU2001.0562
DOI: https://doi.org/10.1016/j.arcontrol.2010.02.004
Google Scholar
Heady, R. B., & Zhu, Z. (1994). An improved implementation of the Wagner-Whitin Algorithm. Production and Operations Management, 3(1), 55–63. https://doi.org/10.1111/j.1937-5956.1994.tb00109.x
DOI: https://doi.org/10.1111/j.1937-5956.1994.tb00109.x
Google Scholar
Ho, C. J., & Ireland, T. C. (2012). Mitigating forecast errors by lot-sizing rules in ERP-controlled manufacturing systems. International Journal of Production Research, 50(11), 3080–3094. https://doi.org/10.1080/00207543.2011.592156
DOI: https://doi.org/10.1080/00207543.2011.592156
Google Scholar
Hopp, W. J., & Spearman, M. L. (2011). Factory physics. Waveland Press.
Google Scholar
Kazan, O., Nagi, R., & Rump, C. M. (2000). New lot-sizing formulations for less nervous production schedules. Computers & Operations Research, 27(13), 1325–1345. https://doi.org/10.1016/S0305-0548(99)00076-3
DOI: https://doi.org/10.1016/S0305-0548(99)00076-3
Google Scholar
Kian, R., Berk, E., Gürler, Ü., Rezazadeh, H., & Yazdani, B. (2020). The effect of economies-ofscale on the performance of lot-sizing heuristics in rolling horizon basis. International Journal of Production Research, 1–15. https://doi.org/10.1080/00207543.2020.1730464
DOI: https://doi.org/10.1080/00207543.2020.1730464
Google Scholar
Kourentzes, N., Trapero, J. R., & Barrow, D. K. (2020). Optimising forecasting models for inventory planning. International Journal of Production Economics, 225, 107597. https://doi.org/10.1016/j.ijpe.2019.107597
DOI: https://doi.org/10.1016/j.ijpe.2019.107597
Google Scholar
Li, Q., & Disney, S. M. (2017). Revisiting rescheduling: MRP nervousness and the bullwhip effect. International Journal of Production Research, 55(7), 1992–2012. https://doi.org/10.1016/j.ijpe.2019.107597
DOI: https://doi.org/10.1080/00207543.2016.1261196
Google Scholar
Mills, T. C. (2019). Applied Time Series Analysis: A Practical Guide to Modeling and Forecasting. Academic Press.
Google Scholar
Moon, I., Yoo, D. K., & Saha, S. (2016). The distribution-free newsboy problem with multiple discounts and upgrades. Mathematical Problems in Engineering, 2017253. https://doi.org/10.1155/2016/2017253
DOI: https://doi.org/10.1155/2016/2017253
Google Scholar
Nielsen, P., Jiang, L., Rytter, N. G. M., & Chen, G. (2014). An investigation of forecast horizon and observation fit’s influence on an econometric rate forecast model in the liner shipping industry. Maritime Policy & Management, 41(7), 667–682. https://doi.org/10.1080/03088839.2014.960499
DOI: https://doi.org/10.1080/03088839.2014.960499
Google Scholar
Nilakantan, J. M., Li, Z., Tang, Q., & Nielsen, P. (2017). MILP models and metaheuristic for balancing and sequencing of mixed-model two-sided assembly lines. European Journal of Industrial Engineering, 11(3), 353-379. https://doi.org/10.1504/EJIE.2017.084880
DOI: https://doi.org/10.1504/EJIE.2017.084880
Google Scholar
Patalas-Maliszewska, J. (2012). Assessing the Impact of Erp Implementation in the small Enterprises. Foundations of management, 4(2), 51-62. https://doi.org/10.2478/fman-2013-0010
DOI: https://doi.org/10.2478/fman-2013-0010
Google Scholar
Patalas-Maliszewska, J., & Kłos, S. (2017). A Study on Improving the Effectiveness of a Manufacturing Company in the Context of Knowledge Management–Research Results. Foundations of Management, 9(1), 149160. https://doi.org/10.1515/fman-2017-0012
DOI: https://doi.org/10.1515/fman-2017-0012
Google Scholar
Pedersen, C. H., Nedbailo, V., Knudsen, M. G., Olesen, J., & Toft, S. (2020). Analysis and development of an operations system. P4 Semester Project, GBE4 gr. 16/2.016. Global Business Engineering, Aalborg University.
Google Scholar
Saha, S., Das, S., & Basu, M. (2010). Optimal pricing and production lot-sizing for seasonal products over a finite horizon. International Journal of Mathematics in Operational Research, 2(5), 540–553. https://doi.org/10.1504/IJMOR.2010.03434
DOI: https://doi.org/10.1504/IJMOR.2010.034340
Google Scholar
Silver, E. A., & Meal, H. C. (1973). A heuristic for selecting lot size quantities for the case of a deterministic time-varying demand rate and discrete opportunities for replenishment. Production and Inventory Management, 2, 64–74.
Google Scholar
Silver, E. A., Pyke, D. F., & Thomas, D. J. (2016). Inventory and production management in supply chains. CRC Press.
DOI: https://doi.org/10.1201/9781315374406
Google Scholar
Silver, E., & Miltenburg, J. (1984). Two modifications of the SilverMeal lot sizing heuristic. INFOR: Information Systems and Operational Research, 22(1), 56–69. https://doi.org/10.1080/03155986.1984.11731912
DOI: https://doi.org/10.1080/03155986.1984.11731912
Google Scholar
Świć, A., & Gola, A. (2013). Economic Analysis of Casing Parts Production in a Flexible Manufacturing System. Actual Problems of Economics, 141(3), 526–533.
Google Scholar
Syntetos, A. A., Boylan, J. E., & Disney, S. M. (2009). Forecasting for inventory planning: a 50-year review. Journal of the Operational Research Society, 60, 149–S160. https://doi.org/10.1057/jors.2008.173
DOI: https://doi.org/10.1057/jors.2008.173
Google Scholar
Syntetos, A. A., Nikolopoulos, K., & Boylan, J. E. (2010). Judging the judges through accuracyimplication metrics: The case of inventory forecasting. International Journal of Forecasting, 26(1), 134-143. https://doi.org/10.1016/j.ijforecast.2009.05.016
DOI: https://doi.org/10.1016/j.ijforecast.2009.05.016
Google Scholar
Taneja, K., Ahmad, S., Ahmad, K., & Attri, S. D. (2016). Time series analysis of aerosol optical depth over New Delhi using Box–Jenkins ARIMA modeling approach. Atmospheric Pollution Research, 7(4), 585596. https://doi.org/10.1016/j.apr.2016.02.004
DOI: https://doi.org/10.1016/j.apr.2016.02.004
Google Scholar
Van Den Heuvel, W., & Wagelmans, A. P. (2005). A comparison of methods for lot-sizing in a rolling horizon environment. Operations Research Letters, 33(5), 486–496. https://doi.org/10.1016/j.orl.2004.10.001
DOI: https://doi.org/10.1016/j.orl.2004.10.001
Google Scholar
Wagner, H. M., & Whitin, T. M. (1958). Dynamic version of the economic lot size model. Management science, 5(1), 89-96. https://doi.org/10.1287/mnsc.5.1.89
DOI: https://doi.org/10.1287/mnsc.5.1.89
Google Scholar
Xi, M. H., Wang, H. X., & Zhao, Q. H. (2012). Regression Based Integration of Demand Forecasting and Inventory Decision. Advanced Materials Research, 433, 2954–2956. https://doi.org/10.4028/www.scientific.net/AMR.433-440.2954
DOI: https://doi.org/10.4028/www.scientific.net/AMR.433-440.2954
Google Scholar
Zabjek, D., Kovačič, A., & Štemberger, M. I. (2009). The influence of business process management and some other CSFs on successful ERP implementation. Business Process Management Journal, 15(4), 588–608. https://doi.org/10.1108/14637150910975552
DOI: https://doi.org/10.1108/14637150910975552
Google Scholar
Authors
Jack OLESENsubrata.scm@gmai.com
Aalborg University, Department of Materials and Production, , DK 9220, Aalborg East Denmark
Authors
Carl-Emil Houmøller PEDERSEN*Aalborg University, Department of Materials and Production, DK 9220, Aalborg East Denmark
Authors
Markus Germann KNUDSENAalborg University, Department of Materials and Production, , DK 9220, Aalborg East Denmark
Authors
Sandra TOFTAalborg University, Department of Materials and Production, DK 9220, Aalborg East Denmark
Authors
Vladimir NEDBAILOAalborg University, Department of Materials and Production, DK 9220, Aalborg East Denmark
Authors
Johan PRISAKProduction Manager, Fibertex Personal Care Group, Aalborg Denmark
Authors
Izabela Ewa NIELSENAalborg University, Department of Materials and Production, DK 9220, Aalborg East Denmark
Authors
Subrata SAHAAalborg University, Department of Materials and Production, DK 9220, Aalborg East Denmark
Statistics
Abstract views: 153PDF downloads: 44
License
This work is licensed under a Creative Commons Attribution 4.0 International License.
All articles published in Applied Computer Science are open-access and distributed under the terms of the Creative Commons Attribution 4.0 International License.
Most read articles by the same author(s)
- Dilek AYDOGAN-KILIC, Deniz Kenan KILIC, Izabela Ewa NIELSEN, EXAMINATION OF SUMMARIZED MEDICAL RECORDS FOR ICD CODE CLASSIFICATION VIA BERT , Applied Computer Science: Vol. 20 No. 2 (2024)
Similar Articles
- Robert KARPIŃSKI, Józef JONAK, Jacek MAKSYMIUK, MEDICAL IMAGING AND 3D RECONSTRUCTION FOR OBTAINING THE GEOMETRICAL AND PHYSICAL MODEL OF A CONGENITAL BILATERAL RADIO-ULNAR SYNOSTOSIS , Applied Computer Science: Vol. 14 No. 1 (2018)
- Maciej NABOŻNY, ASYNCHRONOUS INFORMATION DISTRIBUTION AND CLUSTER STATE SYNCHRONIZATION , Applied Computer Science: Vol. 14 No. 1 (2018)
- Sebastian CYGAN, Barbara BOROWIK, Bohdan BOROWIK, STREET LIGHTS INTELLIGENT SYSTEM, BASED ON THE INTERNET OF THINGS CONCEPT , Applied Computer Science: Vol. 14 No. 1 (2018)
- Danuta MIEDZIŃSKA, Ewelina MAŁEK, Arkadiusz POPŁAWSKI, NUMERICAL MODELLING OF RESINS USED IN STEREOLITOGRAPHY RAPID PROTOTYPING , Applied Computer Science: Vol. 15 No. 4 (2019)
- Wieslaw FRĄCZ, Grzegorz JANOWSKI, INFLUENCE OF HOMOGENIZATION METHODS IN PREDICTION OF STRENGTH PROPERTIES FOR WPC COMPOSITES , Applied Computer Science: Vol. 13 No. 3 (2017)
- Damian KOLNY, Dorota WIĘCEK, Paweł ZIOBRO, Martin KRAJČOVIČ, APPLICATION OF A COMPUTER TOOL MONITORING SYSTEM IN CNC MACHINING CENTRES , Applied Computer Science: Vol. 13 No. 4 (2017)
- Józef MATUSZEK, Tomasz SENETA, Aleksander MOCZAŁA, FUZZY ASSESSMENT OF MANUFACTURABILITY DESIGN FOR MACHINING , Applied Computer Science: Vol. 15 No. 3 (2019)
- Rafał WOJSZCZYK, VERIFICATION OF ACCURACY AND COST OF USE METHODS OF QUALITY ASSESSMENT OF IMPLEMENTATION OF DESIGN PATTERNS , Applied Computer Science: Vol. 15 No. 1 (2019)
- Jakub ANCZARSKI, Adrian BOCHEN, MArcin GŁĄB, Mikolaj JACHOWICZ, Jacek CABAN, Radosław CECHOWICZ, A METHOD OF VERIFYING THE ROBOT'S TRAJECTORY FOR GOALS WITH A SHARED WORKSPACE , Applied Computer Science: Vol. 18 No. 1 (2022)
- Marcin BADUROWICZ, DETECTION OF SOURCE CODE IN INTERNET TEXTS USING AUTOMATICALLY GENERATED MACHINE LEARNING MODELS , Applied Computer Science: Vol. 18 No. 1 (2022)
You may also start an advanced similarity search for this article.