Production and Inventory Management System For Berlux Paints

Abstract

Berlux Paints is a leading paint manufacturing company which holds a large market share in paint manufacturing in Sri-Lanka. They produce superior quality decorative paints as emulsion, high gloss enamel, varnishes and other protective coatings. Their staff used, spreadsheet applications and paper documentation to record their manufacturing schedules, inventory details and other related data. Due to manual documentation of data recording and data analysis, there was less integrity. Work load of staff was high and incorrect inventory levels took place. The process was ineffective and led to production delays and increase in overhead costs. As this is a large commercial organization, maintaining records using a manual system was not suitable, due to inaccuracy and inconsistency of records, delay in updating records and non-availability of up to date information for management to make decisions. As a solution it is suitable to use a web based production and Inventory Management System to achieve organizational goals and objectives. The developed system covers purchasing, supplier profile maintenance, inventory management, production planning, scheduling, maintenance of testing statistics, dispatch and generation of various meaningful reports for the purpose of managerial decision making. The System is web based, which is developed using object oriented techniques, employing various UML diagrams for modelling the system and adhering to the MVC architecture. Meanwhile, the system has been developed according to RUP framework. XAMPP web server solution stack is used for the development of this system, utilizing Apache as the web server. PHP is used as the server side scripting language to build the system and MySQL is used for handling the database. The developed system was thoroughly tested using a complete testing procedure and evaluated with user surveys, to determine whether the systems user requirements are accomplished. The system confirms to its specification whilst providing the intended functionality and anticipated outcomes of enhancing efficiency and effectiveness.