The Use of Intervention Approach in Individual and Aggregate Forecasting Methods for Burger Patties: A Case in Indonesia
Abstract
The Indonesian beef consumption increases sharply during Ramadan and made a difference between supply and demand. The research aimed to study the demand pattern of burger patties and determine a suitable forecasting method compared between quantitative and intervention forecasting methods. The actual demand was intervened by experts based on reasons such as supply shortage, holidays, promotion, and government projects. The daily sales of burger patties were collected for a year. Then, the data were divided into training and testing data. Later, time-series forecasting was performed by software. Then, the best forecasting method for daily data was selected between Individual forecasting and Top-Down forecasting. Similarly, for weekly data, the best forecasting method was compared between aggregate forecasting and Bottom-Up forecasting. Then, repeat the process for the intervened sales data. The result revealed that the mean absolute percentage error was improved after intervention by about 3.64%-58.83%. The combination of quantitative and qualitative approaches improved forecast accuracy. In addition, the aggregate level or weekly sales forecast had higher forecast accuracy than the disaggregated level. The Bottom-Up forecast performs better than the aggregate forecast. Hence, we recommended the company plans based on weekly data and implement Every Low Price to reduce the demand fluctuation.
Keywords
Full Text:
PDFReferences
Agus, A., Budisatria, I. G. S., & Ngadiyono, N. (2014). Road map of beef cattle industry in Indonesia. Faculty of Animal Science. Universitas Gadjah Mada and APFINDO. Yogyakarta, Indonesia.
Athanasopoulos, G., Hyndman, R. J., Kourentzes, N., & Petropoulos, F. (2017). Forecasting with temporal hierarchies. European Journal of Operational Research, 262(1), 60-74. doi:https://doi.org/10.1016/j.ejor.2017.02.046
Australia, M. L. (2018). Market Snapshots Beef. Retrieved from https://www.mla.com.au/globalassets/mla-corporate/prices--markets/documents/os-markets/export-statistics/oct-2018-snapshots/all-beef-markets-snapshots-oct2018.pdf
Bandara, K., Hewamalage, H., Liu, Y.-H., Kang, Y., & Bergmeir, C. (2021). Improving the accuracy of global forecasting models using time series data augmentation. Pattern Recognition, 120, doi:https://doi.org/10.1016/j.patcog.2021.108148
Box, G. E. P., Jenkins, G. M., Reinsel, G. C., & Ljung, G. M. (2015). Time Series Analysis: Forecasting and Control: Wiley.
Cantón Croda, R., Gibaja, D., & Caballero, O. (2018). Sales Prediction through Neural Networks for a Small Dataset. International Journal of Interactive Multimedia and Artificial Intelligence, InPress, 1. doi:10.9781/ijimai.2018.04.003
Chase, C. W. (2009). Demand-Driven Forecasting: A Structured Approach to Forecasting: Wiley.
Chopra, S., & Meindl, P. (2016). Supply chain management: strategy, planning, and operation (Sixth Edition. ed.). Boston: Pearson.
Davydenko, A., & Fildes, R. (2013). Measuring forecasting accuracy: The case of judgmental adjustments to SKU-level demand forecasts. International Journal of Forecasting, 29(3), 510-522. doi:https://doi.org/10.1016/j.ijforecast.2012.09.002
Fong, S., Li, G., Dey, N., Gonzalez Crespo, R., & Herrera-Viedma, E. (2020). Finding an Accurate Early Forecasting Model from Small Dataset: A Case of 2019-nCoV Novel Coronavirus Outbreak.
Ford, J., Nava, C., Tan, J., & Sadler, B. (2020). Automated Machine Learning Framework for Demand Forecasting in Wholesale Beverage Alcohol Distribution. SMU Data Science Review, 3(3), 7.
Ghasemian, A., Hosseinmardi, H., & Clauset, A. (2020). Evaluating Overfit and Underfit in Models of Network Community Structure. IEEE Transactions on Knowledge and Data Engineering, 32(9), 1722-1735. doi:10.1109/TKDE.2019.2911585
Ha, C., Seok, H., & Ok, C. (2018). Evaluation of forecasting methods in aggregate production planning: A Cumulative Absolute Forecast Error (CAFE). Computers & Industrial Engineering, 118, 329-339. doi:https://doi.org/10.1016/j.cie.2018 .03.003
Hamzah, D. I. A., Rusiman, M. S., Him, N. C., Shafi, M. A., Alma, O. G., & Suhartono, S. (2021). A time series analysis for sales of chicken based food product. Paper presented at the AIP Conference Proceedings.
Huber, J., & Stuckenschmidt, H. (2020). Daily retail demand forecasting using machine learning with emphasis on calendric special days. International Journal of Forecasting, 36(4), 1420-1438. doi:https://doi.org/10.1016/j.ijforecast.2020.02. 005
Joseph, V. R., & Vakayil, A. (2021). SPlit: An Optimal Method for Data Splitting. Technometrics, 1-11. doi:10.1080/00401706.2021.1921037
Kharfan, M., Chan, V. W. K., & Efendigil, T. (2021). A data-driven forecasting approach for newly launched seasonal products by leveraging machine-learning approaches. Annals of Operations Research, 303, 1-16.
Lee, C.-Y., & Chiang, M.-C. (2016). Aggregate demand forecast with small data and robust capacity decision in TFT-LCD manufacturing. Computers & Industrial Engineering, 99, 415-422. doi:https://doi.org/10.1016/j.cie.2016.02.013
Lewis, C. (2012). Demand Forecasting and Inventory Control. London: Routledge
Li, X., Yin, Y., Manrique, D. V., & Bäck, T. (2021). Lifecycle forecast for consumer technology products with limited sales data. International Journal of Production Economics, 239, 108206. doi:https://doi.org/10.1016/j.ijpe.2021.108206
Mirčetić, D., Nikoličić, S., Stojanović, Đ., & Maslarić, M. (2017). Modified top down approach for hierarchical forecasting in a beverage supply chain. Transportation Research Procedia, 22, 193-202. doi:https://doi.org/10.1016/j.trpro.2017.03.026
Mor, R.S., Jaiswal, S.K., Singh, S., & Bhardwaj, A. (2018). Demand Forecasting of the Short-Lifecycle Dairy Products. Understanding the Role of Business Analytics.
Nendissa, D. R., Anindita, R., Hanani, N., Muhaimin, A. W., & Henuk, Y. L. (2019). Concentration of beef market in East Nusa Tenggara (ENT) Province, Indonesia.
Pennings, C. L. P., & van Dalen, J. (2017). Integrated hierarchical forecasting. European Journal of Operational Research, 263(2), 412-418. doi:https://doi.org/10.1016 /j.ejor.2017.04.047
Petropoulos, F., & Carver, S. (2019). Chapter 16 - Forecasting for food demand. In R. Accorsi & R. Manzini (Eds.), Sustainable Food Supply Chains (pp. 237-248): Academic Press.
Posch, K., Truden, C., Hungerländer, P., & Pilz, J. (2021). A Bayesian approach for predicting food and beverage sales in staff canteens and restaurants. International Journal of Forecasting, 38 (1) . doi:https://doi.org/10.1016/j.ijforecast.2021.06.001
Pradita, S., Ongkunaruk, P., & Leingpibul, T. (2020). Utilizing an Intervention Forecasting Approach to Improve Reefer Container Demand Forecasting Accuracy: A Case Study in Indonesia. International Journal of Technology, 11 (1), 144. doi:10.14716/ijtech.v11i1.3220
Sevlian, R., & Rajagopal, R. (2018). A scaling law for short term load forecasting on varying levels of aggregation. International Journal of Electrical Power & Energy Systems, 98, 350-361. doi:https://doi.org/10.1016/j.ijepes.2017.10.032
Van Donselaar, K. H., Peters, J., de Jong, A., & Broekmeulen, R. A. (2016). Analysis and forecasting of demand during promotions for perishable items. International Journal of Production Economics, 172, 65-75.
Wolters, J., & Huchzermeier, A. (2021). Joint In-Season and Out-of-Season Promotion Demand Forecasting in a Retail Environment. Journal of Retailing, 97 (4), 726-745. doi:https://doi.org/10.1016/j.jretai.2021.01.003
DOI: https://doi.org/10.18196/agraris.v8i1.12842
Refbacks
- There are currently no refbacks.
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
Indexed By:
Office Address:
Department of Agribusiness, Faculty of Agriculture, Universitas Muhammadiyah Yogyakarta
Ground Floor of F3 Building (Siti Walidah)
Jl. Brawijaya, Tamantiro, Kasihan, Bantul. 55183
Telp.: +62 274 387656, Ext.: 201
HP or WhatsApp: +62 85328737828
Email: agraris@umy.ac.id
AGRARIS is licensed under a Creative Commons Attribution-ShareAlike 4.0 (CC BY-SA 4.0) International License.