Advancements in information technology encourage MSMEs to utilize information systems to enhance the effectiveness of their business management. Es Teh Arjuna, an MSME in Tegal City, faces challenges in monitoring partner sales and managing revenue because transactions are recorded manually using disparate methods; this results in slow data recapitulation, a risk of recording errors, and difficulty for the business owner in quickly accessing sales information. This study aims to analyze requirements, design, develop, and test a web-based information system for partner sales and revenue that provides information in real-time. The Waterfall model was used for system development, while data collection involved observation, interviews, and a literature review. The system was developed using PHP and MySQL and tested via Black Box Testing. The results demonstrate that the system successfully integrates sales data from all outlets into a centralized database, streamlining the management of products, outlets, employees, cashiers, and sales transactions, as well as facilitating the generation of revenue reports for specific periods. Furthermore, the system enables the business owner to monitor sales performance more quickly, accurately, and systematically, thereby supporting decision-making and improving the operational efficiency of Es Teh Arjuna
Manual management of facilities and inventory often leads to difficulties in data retrieval, reporting, and determining asset maintenance priorities. This issue is experienced by the Bandasari Village Office, Dukuhturi District, Tegal Regency, which lacks an integrated inventory management system. This study aims to develop a web-based Facilities and Inventory Management Information System by implementing the Simple Additive Weighting (SAW) method to support asset maintenance prioritization. The research employed the Research and Development (R&D) approach, consisting of problem identification, data collection, system design, implementation, and testing. The system was developed using the Laravel framework with MySQL as the database management system. Functional testing was conducted using the Black Box Testing method to ensure that all system features met user requirements. The results indicate that the developed system successfully integrates inventory management, procurement, maintenance, asset transfers, and reporting into a single web-based platform. Furthermore, the implementation of the SAW method generates objective maintenance priority rankings, enabling more effective and transparent decision-making. Black Box Testing confirmed that all core system functions operated as intended without significant errors. Therefore, the proposed system improves the effectiveness, efficiency, and accuracy of facilities and inventory management at the Bandasari Village Office while supporting more systematic and data-driven asset maintenance decisions.
Asset inventory management is vital for enhancing the operational efficiency of an organization. At the Communication and Informatics Office of Tegal Regency, the process for managing asset inventory is still performed manually, leading to various issues including challenges in asset documentation, data retrieval, management of borrowing, reporting damage, and overseeing the condition of assets. This research intends to create a web-based asset inventory management solution that leverages Quick Response (QR) Code technology to boost the effectiveness, efficiency, and precision of inventory management. The methodology employed for the system's development was Agile Development, which includes stages such as planning, analyzing requirements, designing the system, developing, testing, and conducting iterative evaluations. Data gathering was conducted through observation, interviews, and reviewing existing literature. The completed system offers several key features, such as inventory management, the ability to generate and scan QR Codes, processes for borrowing and returning assets, damage reporting, a monitoring dashboard, and management of user access based on roles. The findings reveal that the implemented system enhances asset identification through QR Codes, delivers real-time inventory data, and enables more efficient monitoring of assets. According to Black Box Testing results, all functionalities of the system performed in alignment with the identified functional requirements. Consequently, the web-based asset inventory management system utilizing QR Code technology can act as a useful solution to enhance the asset inventory management quality at the Communication and Informatics Office of Tegal Regency.
