Raw material inventory management at Vanhollano Bakery Jambi is still done manually, which is prone to recording errors, delays the discovery of low-stock or nearly expired ingredients, and makes inventory reporting time-consuming. This research aims to design a web-based raw material inventory information system that helps the warehouse admin record incoming materials, material issues, and stock adjustments, helps production staff request materials, and helps the owner monitor minimum stock levels and inventory reports. The system was designed using the Waterfall method, modeled with use case diagrams, activity diagrams, and an ERD normalized to 3NF, and is planned to be built with PHP and MySQL. The results are 12 functional requirements, a ten-table database design, an interface design, and 14 Black Box Testing scenarios for three user roles. This research covers only the analysis and design stages; implementation, test execution, and measurement of operational impact remain to be done in future research.
Copyrights © 2026