Analysis of Beef Weight Discrepancies in the MBG Needs Distribution Process Based on Business Intelligence
Keywords:
Severe nonconformity, Business Intelligence, Beef distribution, Food distribution, Simulation dataAbstract
The Free Nutritional Meal Program (MBG) requires a supply of beef in the appropriate amount, but the weight recorded by suppliers during delivery can differ from the actual weight when reweighed at the receiving kitchen. Transaction receipts have so far only served as proof of recording and have not been analyzed to determine the level, frequency, and accumulation of weight discrepancies. This study aims to analyze the discrepancy between the shipped and received weight of beef and apply Business Intelligence (BI) to generate discrepancy indicators that can be used as material for distribution evaluation. The study uses a descriptive quantitative approach based on BI with the stages of data preparation, processing, and analysis. The data used are simulated data, not actual transaction data, in the form of 50 randomly generated delivery transactions to nine SPPG kitchens with a delivery weight of 50–79 kg. Discrepancies are calculated as the difference between the received and delivered weights, then expressed as a percentage of the delivered weight. Of the total delivered weight of 3,248 kg, the received weight reached 3,289.19 kg, resulting in a total discrepancy of 41.19 kg (1.27%), with an average of 0.82 kg per transaction. A total of 41 transactions (82%) showed a greater weight received than the weight sent, while nine transactions (18%) were smaller, with a difference ranging from -1.10 to +2.31 kg. The average difference per kitchen ranged between 0.325 kg (SPPG 2) and 1.40 kg (SPPG 6). The proposed BI framework is able to calculate and summarize weight discrepancies per transaction and per kitchen. Because the results are obtained from simulated data, these findings only demonstrate analytical capabilities and do not reflect actual distribution conditions. Further research needs to validate this framework with actual transaction data and develop an interactive dashboard.
Downloads
References
[1] F. A. Suprapto, E. Praditya, R. M. Dewi, and W. Adiyoso, “A Policy Implementation Review of the Free Nutritious Meal (MBG) Program,” The Journal of Indonesia Sustainable Development Planning, vol. 6, no. 2, pp. 297–312, Aug. 2025, doi: 10.46456/jisdep.v6i2.798.
[2] C. E. Bakker, L. M. O’Sullivan, K. R. Underwood, A. D. Blair, H. R. Rode-Atkins, and J. K. Grubbs, “Product Yield and Color of Striploin and Sirloin Cuts Transported at Different Refrigerated Temperatures,” Meat and Muscle Biology, vol. 7, no. 1, Jan. 2023, doi: 10.22175/mmb.14393.
[3] K. N. Krueger, K. R. Underwood, A. D. Blair, J. K. Grubbs, and C. E. Bakker, “Effects of distance and vibration isolation during transportation on subprimal and case-ready steak quality of beef sirloins,” Transl. Anim. Sci., vol. 10, Jan. 2026, doi: 10.1093/tas/txag102.
[4] S. Davoudi, P. Stasinopoulos, and N. Shiwakoti, “Two Decades of Advancements in Cold Supply Chain Logistics for Reducing Food Waste: A Review with Focus on the Meat Industry,” Sustainability, vol. 16, no. 16, p. 6986, Aug. 2024, doi: 10.3390/su16166986.
[5] A. P. Rambe and S. Suendri, “SISTEM INFORMASI MONITORING DAPUR PROGRAM MAKAN BERGIZI GRATIS BERBASIS FRAMEWORK SCRUM,” Jurnal Informatika Teknologi dan Sains (Jinteks), vol. 8, no. 3, pp. 1074–1081, Aug. 2026, doi: 10.51401/jinteks.v8i3.7669.
[6] U. A. S. Anandri, L. Indawati, and Muh. R. Ridha, “Integrating Business Intelligence and Food Supply Chain Analytics to Support National Nutrition Programs (MBG): Evidence from Rice Production Dashboard in Indonesia,” Komputasi: Jurnal Ilmiah Ilmu Komputer dan Matematika, vol. 23, no. 2, pp. 82–92, Jul. 2026, doi: 10.33751/komputasi.v23i2.113.
[7] N. Wikamulia and S. M. Isa, “Predictive business intelligence dashboard for food and beverage business,” Bulletin of Electrical Engineering and Informatics, vol. 12, no. 5, pp. 3016–3026, Oct. 2023, doi: 10.11591/eei.v12i5.5162.
[8] R. Zimmermann and P. Brandtner, “From Data to Decisions: Optimizing Supply Chain Management with Machine Learning-Infused Dashboards,” Procedia Comput. Sci., vol. 237, pp. 955–964, 2024, doi: 10.1016/j.procs.2024.05.184.
[9] F. P. Eka Putra, F. Muslim, N. Hasanah, Holipah, R. Paradina, and R. Alim, “Analisis Komparasi Protokol Websocket dan MQTT Dalam Proses Push Notification,” Jurnal Sistim Informasi dan Teknologi, pp. 63–72, Jan. 2024, doi: 10.60083/jsisfotek.v5i4.325.
[10] F. Caputo, G. Palazzo, and L. Ligorio, “Business Intelligence in Supply Chain Management: Insights for Performance and Sustainability,” Corp. Soc. Responsib. Environ. Manag., vol. 33, no. 1, pp. 1446–1464, Jan. 2026, doi: 10.1002/csr.70239.
[11] A. Kumah et al., “Cause-and-Effect (Fishbone) Diagram: A Tool for Generating and Organizing Quality Improvement Ideas,” Global Journal on Quality and Safety in Healthcare, vol. 7, no. 2, pp. 85–87, May 2024, doi: 10.36401/JQSH-23-42.
[12] E. B. Susanto, P. A. Christianto, B. Ismanto, and R. Sulistiyaningsih, “TOEHBCHAIN: A Framework for Blockchain-Based Food Distribution Transparency,” ECTI Transactions on Computer and Information Technology (ECTI-CIT), vol. 19, no. 4, pp. 682–692, Oct. 2025, doi: 10.37936/ecti-cit.2025194.263342.
[13] S. Safiuddin and F. P. E. Putra, “Strategi Efisiensi Wireless Sensor Network (WSN),” INFORMATICS FOR EDUCATORS AND PROFESSIONAL : Journal of Informatics, vol. 8, no. 1, p. 52, Jul. 2023, doi: 10.51211/itbi.v8i1.2441.
[14] S. Davoudi, P. Stasinopoulos, and N. Shiwakoti, “Two Decades of Advancements in Cold Supply Chain Logistics for Reducing Food Waste: A Review with Focus on the Meat Industry,” Sustainability, vol. 16, no. 16, p. 6986, Aug. 2024, doi: 10.3390/su16166986.
[15] A. Samuels, “Examining the integration of artificial intelligence in supply chain management from Industry 4.0 to 6.0: a systematic literature review,” Front. Artif. Intell., vol. 7, Jan. 2025, doi: 10.3389/frai.2024.1477044.
[16] U. A. S. Anandri, L. Indawati, and Muh. R. Ridha, “Integrating Business Intelligence and Food Supply Chain Analytics to Support National Nutrition Programs (MBG): Evidence from Rice Production Dashboard in Indonesia,” Komputasi: Jurnal Ilmiah Ilmu Komputer dan Matematika, vol. 23, no. 2, pp. 82–92, Jul. 2026, doi: 10.33751/komputasi.v23i2.113.
[17] Bening Tirta Wibowo, Friski Ardeka Sahda Rianestu, and Indra Devian Lumban Gaol, “Transparansi dan Pengawasan Keuangan Negara dalam Implementasi Program Makan Bergizi Gratis (MBG),” Jurnal Media Administrasi, vol. 11, no. 1, pp. 64–70, Apr. 2026, doi: 10.56444/jma.v11i1.3670.
[18] L. Martina, S. Khansa, and Z. Ahmad, “Analisis Penerapan Teknologi Blockchain Pada Pemenuhan Kebutuhan Pangan Dalam Sektor Industri Pertanian,” Jurnal Agrifoodtech, vol. 3, no. 1, pp. 22–31, Jul. 2024, doi: 10.56444/agrifoodtech.v3i1.1538.
[19] W. A. Müller, S. B. Ferreira, and S. Botelho da Silva, “Enhancing Food Safety in the Cold Chain Through Internet of Things and Artificial Intelligence,” J. Food Sci., vol. 91, no. 2, Feb. 2026, doi: 10.1111/1750-3841.70871.
[20] Y. K. Anagaw et al., “Food adulteration: Causes, risks, and detection techniques—review,” SAGE Open Med., vol. 12, Jan. 2024, doi: 10.1177/20503121241250184.
[21] F. Kartiasih, A. Azhari, and R. E. B. I. Rinangku, “Optimizing tourism development using Google Trends and nighttime light (NTL) data,” Jurnal Ekonomi Indonesia, vol. 14, no. 3, pp. 252–268, Dec. 2025, doi: 10.52813/jei.v14i3.792.
[22] R. Z. Vaz et al., “Meta-analysis on beef cattle carcass chilling loss,” Pesqui. Agropecu. Bras., vol. 60, 2025, doi: 10.1590/s1678-3921.pab2025.v60.03695.
[23] R. Kusumaningrum, A. Darjanto, R. Nurmalina, S. Mulatsih, and S. Suprehatin, “Effect of Import Policy on Beef Supply and Demand in Indonesia before and after the COVID-19 Pandemic,” Tropical Animal Science Journal, vol. 47, no. 2, pp. 242–251, Jun. 2024, doi: 10.5398/tasj.2024.47.2.242.
[24] D. Božić, M. Živičnjak, R. Stanković, and A. Ignjatić, “Impact of the Product Master Data Quality on the Logistics Process Performance,” Logistics, vol. 8, no. 2, p. 43, Apr. 2024, doi: 10.3390/logistics8020043.
[25] F. A. Suprapto, E. Praditya, R. M. Dewi, and W. Adiyoso, “A Policy Implementation Review of the Free Nutritious Meal (MBG) Program,” The Journal of Indonesia Sustainable Development Planning, vol. 6, no. 2, pp. 297–312, Aug. 2025, doi: 10.46456/jisdep.v6i2.798.
[26] I. Fernando, J. Fei, S. Cahoon, and D. C. Close, “A review of the emerging technologies and systems to mitigate food fraud in supply chains,” Crit. Rev. Food Sci. Nutr., vol. 65, no. 26, pp. 5108–5135, Sep. 2025, doi: 10.1080/10408398.2024.2405840.
[27] Lina Marlina, “Dampak Penggunaan Teknologi Blockchain terhadap Transparansi dan Akuntabilitas dalam Manajemen Rantai Pasok,” MUQADDIMAH: Jurnal Ekonomi, Manajemen, Akuntansi dan Bisnis, vol. 3, no. 3, pp. 70–76, Jul. 2025, doi: 10.59246/muqaddimah.v3i3.1501.
[28] E. Ahoa, A. Kassahun, C. Verdouw, and B. Tekinerdogan, “Challenges and Solution Directions for the Integration of Smart Information Systems in the Agri-Food Sector,” Sensors, vol. 25, no. 8, p. 2362, Apr. 2025, doi: 10.3390/s25082362.
[29] M. B. Lai, D. Vergamini, and G. Brunori, “Food Supply Chain: A Framework for the Governance of Digital Traceability,” Foods, vol. 14, no. 12, p. 2032, Jun. 2025, doi: 10.3390/foods14122032.
[30] M. Reitano, M. S. Segovia, and R. M. Nayga, “A systematic review on the impact of Artificial Intelligence in the agri-food supply chain,” Food Policy, vol. 137, p. 102983, Nov. 2025, doi: 10.1016/j.foodpol.2025.102983.
[31] F. P. Eka Putra, F. I. Maulana, N. M. Akbar, and W. Febriantoro, “Twitter sentiment analysis about economic recession in indonesia,” Bulletin of Social Informatics Theory and Application, vol. 7, no. 1, pp. 1–7, Mar. 2023, doi: 10.31763/businta.v7i1.592.
[32] F. P. E. Putra, O. F. Kusuma, Moh. Mursidi, and A. Hamzah, “Comparative Analysis of Laravel and Symfony in PHP-Based Web Application Developmen,” Brilliance: Research of Artificial Intelligence, vol. 5, no. 1, pp. 272–280, Jun. 2025, doi: 10.47709/brilliance.v5i1.5892.
[33] R. Zhang, H. Zhu, Q. Chang, and Q. Mao, “A Comprehensive Review of Digital Twins Technology in Agriculture,” Agriculture, vol. 15, no. 9, p. 903, Apr. 2025, doi: 10.3390/agriculture15090903.
[34] D. W. Kinanti, Agus Riswanto, and Muhamad Ali, “Implementasi Kebijakan Program Makan Bergizi Gratis (MBG) dan Pengelolaan Rantai Pasok Pangan Lokal dalam Mendukung SDGs 2 di Kabupaten Lombok Timur,” ARMADA : Jurnal Penelitian Multidisiplin, vol. 4, no. 8, pp. 4442–4453, Aug. 2026, doi: 10.55681/armada.v4i8.3614.
[35] A. Kumah et al., “Cause-and-Effect (Fishbone) Diagram: A Tool for Generating and Organizing Quality Improvement Ideas,” Global Journal on Quality and Safety in Healthcare, vol. 7, no. 2, pp. 85–87, May 2024, doi: 10.36401/JQSH-23-42.
[36] Rohmah Amredika and Andini Lestari, “Achieving Food and Nutrition Security for Indonesia’s Free Nutritious Meal Program:A Provincial-Level Gap Analysis and Development Strategy,” Jurnal Perencanaan Pembangunan: The Indonesian Journal of Development Planning, vol. 10, no. 1, pp. 219–234, Apr. 2026, doi: 10.36574/jpp.v10i1.814.
[37] A. Wibowo and Yuliani, “Three Decades of School Meal Program Research: Bibliometric Insights for Governance and Sustainability of Indonesia’s Free Nutritional Meal Initiative (MBG),” Jurnal Perencanaan Pembangunan: The Indonesian Journal of Development Planning, vol. 10, no. 1, pp. 198–218, Apr. 2026, doi: 10.36574/jpp.v10i1.745.
[38] L. Marzulina, A. Mukminin, and K. Harto, “Feeding Minds, Building Dignity: Indonesia’s Free Nutritious Meal Policy (MBG), Barriers, Prospects, and Policy Recommendations,” Edukasi: Jurnal Pendidikan dan Pengajaran, vol. 12, no. 2, pp. 848–876, Dec. 2025, doi: 10.19109/ejpp.v12i2.32308.
[39] C. Smyth, D. Dennehy, S. Fosso Wamba, M. Scott, and A. Harfouche, “Artificial intelligence and prescriptive analytics for supply chain resilience: a systematic literature review and research agenda,” Int. J. Prod. Res., vol. 62, no. 23, pp. 8537–8561, Dec. 2024, doi: 10.1080/00207543.2024.2341415.
[40] E. Nawal, F. Hicham, and M. Najat, “Optimizing Supply Chain Performance with AI: Case Studies and Trends (2018–2024),” 2026, pp. 522–528. doi: 10.1007/978-3-032-01536-5_79.
[41] R. W. Lestari, Rr. R. P. A. Agustini, and B. Tutuko, “Manajemen Rantai Pasok SPPG dalam Program Makan Bergizi Gratis pada Berbagai Karakteristik Wilayah,” Jurnal Sosial Teknologi, vol. 6, no. 8, pp. 2684–2697, Aug. 2026, doi: 10.59188/jurnalsostech.v6i8.32950.
[42] S. I. Santoso and T. Mulyadi, “Studi Management Bahan Pangan di Dapur Gizi Gratis Sungai Panas Kota Batam: Strategi Pengurangan Limbah Makanan,” Jurnal Sosial Teknologi, vol. 5, no. 12, pp. 4368–4378, Dec. 2025, doi: 10.59188/jurnalsostech.v5i12.32524.
[43] S. Pora, D. Muksin, and A. F. Rahmat, “Implementasi Program Makan Bergizi Gratis Pada Pemerintahan Prabowo-Gibran: Solusi dan Tantangan,” Jurnal Noken: Ilmu-Ilmu Sosial, vol. 11, no. 2, pp. 635–694, Dec. 2025, doi: 10.33506/jn.v11i2.4352.
[44] D. Muñoz Rojas, J. R. Montoya-Torres, and D. M. Ayala Valderrama, “A Data-Driven Framework for Agri-Food Supply Chains: A Case Study on Inventory Optimization in Colombian Potatoes Management,” Logistics, vol. 9, no. 4, p. 164, Nov. 2025, doi: 10.3390/logistics9040164.
[45] J. McGuire, D. Sefcik, L. Minnich, I. Baucom, and K. Lippa, “NIST Handbook 130:,” Dec. 2025. doi: 10.6028/NIST.HB.130-2026.
[46] A. J. Ribeiro, F. Silva, P. Teixeira, and C. M. Saraiva, “Dry‐Aged Beef: A Global Review of Meat Quality Traits, Microbiome Dynamics, Safety, and Sustainable Strategies,” J. Food Sci., vol. 90, no. 10, Oct. 2025, doi: 10.1111/1750-3841.70589.
[47] M. K. Roberts and J. Daw, “The Importance of Describing Patient Populations,” Progress in Transplantation, vol. 34, no. 1–2, pp. 58–59, Jun. 2024, doi: 10.1177/15269248241237823.
[48] K. N. Krueger, K. R. Underwood, A. D. Blair, J. K. Grubbs, and C. E. Bakker, “Effects of distance and vibration isolation during transportation on subprimal and case-ready steak quality of beef sirloins,” Transl. Anim. Sci., vol. 10, Jan. 2026, doi: 10.1093/tas/txag102.
[49] I. Hidayatullah, M. H. Khairi, I. Maulana, and F. P. Eka Putra, “Analisis Protokol Keamanan Jaringan dalam Era Internet of Things (IoT),” Infotek: Jurnal Informatika dan Teknologi, vol. 8, no. 2, pp. 356–366, Jul. 2025, doi: 10.29408/jit.v8i2.30257.
[50] F. P. Eka Putra, . S., A. Ramadhani, and . M., “Integrasi Teknologi Kuantum dan fiber Optik untuk Meningkatkan Keamanan dan Efisiensi Jaringan Masa Depan,” Jurnal Ilmiah ILKOMINFO - Ilmu Komputer & Informatika, vol. 8, no. 2, pp. 151–163, Jul. 2025, doi: 10.47324/ilkominfo.v8i2.342.
Published
Issue
Section
License
Copyright (c) 2026 suro jalil, habiburrahman (Penulis)
This work is licensed under a Creative Commons Attribution 4.0 International License.
