Web-Mobile-Based Mapping System for Free Nutritious Meal (MBG) Distribution Using the Haversine Method and Location-Based Services (LBS)

Abstract

The Free Nutritious Meal (Makan Bergizi Gratis/MBG) program requires coordinated distribution management among service providers, schools, and delivery personnel. This study develops a web- and mobile-based MBG distribution mapping system to support portion requests, distribution data management, driver assignments, location monitoring, and delivery confirmation. The system was developed using Laravel, MySQL, REST API, and an Android application, incorporating Location-Based Services (LBS) and the Haversine formula. The Haversine formula calculates the geographic distance between an SPPG facility and schools to support destination ordering, while Google Maps provides navigation along road networks. Functional testing was conducted using Black Box Testing with 38 test scenarios. All scenarios passed, resulting in a 100% functional test success rate. A Haversine calculation example produced an approximate geographic distance of 0.97 km for one destination based on the tested coordinates. These findings indicate that the prototype functions according to the defined test scenarios. However, operational effectiveness, delivery punctuality, portion accuracy, and food waste reduction have not yet been evaluated through field testing.