Universitas Pelita Harapan is one of the colleges that have research and community service agencies (LPPM) was establish on 8 january 1996. It is intended to support the academic activities in developing the skills, competence and professionalism in the academic community of UPH with the research and do community service. LPPM as a unit in charge of conducting research at the university are required to continue to make improvements in the planning, implementation process, implement the results, as well as mendeseminasikan research results. The purpose of this final project is to research and development sistem dedicated public. The system is developed by using prototyping methodology that has four steps, which are planning, analysis, design and implementation. The system is modeled by UML 2.0. The application is created by using PHP as scripting language for web development, SQL Server as database tool, and tested by using black box testing. The system will be able to assist the store in managing the repair scheduling, manage sparepart, manage payroll and manage employee loans. managing customer data, and employee data.