An Electrical Power Inventory and Monitoring System

Abstract

The Inventory Management and Monitoring System is a software that is helpful for the various business sectors that operate in stores, products, and services where storeowners, products and services proprietors keep the records of sales and purchases, supply and demand, and risk and opportunities. A mismanaged inventory means disappointed customers, too much cash tied up in warehouses, slower sales, and sometimes detrimental to the work relation environment, investments and businesses, and most probably financial losses. Inventory control problems often result in record and physical count discrepancies which may ultimately lead to higher than preferred inventory levels. Conversely, accurate inventory records result in lower inventory investment and are the foundation for forecasting, ordering, tracking, vendor evaluation, dead stock, and administration plans and decisions.

The researcher observed that most of the application of the inventory system was sales and products. Through this study, the researcher applied inventory in terms of electrical maintenance relations which includes electrical supplies, devices and equipment, services, and electrical power consumption. An Agile software development methodology was used in developing the system. The inventory archive maintenance system was developed using Java, HTML, CSS, PHP, PhpMyAdmin, and MySQL. The Inventory System includes Messaging, Supplies Inventory, Job Orders, Repair Records, and Wattage Consumption. Integration of disciplines made the study finished and the user’s manual was produced for guides and references for the use of the system.