GAG Glass, Aluminum and Framing Supply material resource planning system

Abstract

This study was designed to develop the GAG Glass, Aluminum and Framing Supply Material Resource Planning System. It focused on the following objective, An inventory module that gives accurate daily update, recording, and monitoring of stocks to avoid errors and lose of records, Prepare an item status that would module display the availability of the materials to be used during ordering and setting the customer’s schedule of delivery. An estimation module that shows that estimated computation of customer’s order. A preview module that would show how the customer’s order would look like based on the MRP data. A sales report module the in-demand materials and their status. An order module that serves as a guide to the owner-manager to generate orders to be purchased. The methodology used for the development of the system is the Modified Iterative Waterfall Model which has the following stages; systems analysis, requirement definition, systems design, systems development, testing and maintenance and implementation. Results show that the proposed GAG Glass, Aluminum and Framing Supply Material Resource Planning System automating all the transactions can minimize the workload of the staff/owner. The system will generate a report that helps determine the highest and most demand raw materials and window projects. The system has its own point of sales system to help the owner to easily monitor the raw materials and windows projects that goes in and out. An inventory system that automatically classify the materials that are low-level and stocks that is non marketable. An automated canvass system that will generate the total cost of the customers desired window project.