Thirza Pramudya Sutadipura

Design of Company Inventory Information System Application Based on Microsoft Excel at PT Duta Garmindo Industri Bojong Branch

Introduction

Design of company inventory information system application based on microsoft excel at pt duta garmindo industri bojong branch. Upgrade inventory management at PT Duta Garmindo Industri Bojong Branch. This Excel-based information system automates data, reduces errors, and boosts employee efficiency.

Abstract

Effective and efficient work in a company or organization is a very important thing that helps employees do the work quickly and precisely, one of the important things that must be done effectively and efficiently is to get information. The information obtained will be the basis for the company to make a policy decision. Information about assets or inventory in the company is something that needs to be considered,recording the entry and exit of goods is an activity in inventory management, errors in the amount of input or output of inventory data become a thing that often happens, so we need an information system to manage it. PT Duta Garmindo Industri Bojong Branch uses Microsoft Excel lined inventory management system by manually inputting data, starting from adding, and subtracting to summing the inventory calculated manually, this will reduce the effectiveness and efficiency of employees at work. Therefore, it is necessary to upgrade the Microsoft Excel recording system,which includes the dashboard display, the results of adding and subtracting items automatically and accurately. With this upgrade, it is hoped that the human resources in the company can be more effective and efficient in their work.

Review

This paper, titled "Design of Company Inventory Information System Application Based on Microsoft Excel at PT Duta Garmindo Industri Bojong Branch," effectively identifies a pervasive challenge in corporate operations: the need for efficient and accurate inventory management. The abstract articulates the critical role of timely information in decision-making and underscores how manual, error-prone data entry processes can severely hinder productivity. It specifically highlights the struggles of PT Duta Garmindo Industri Bojong Branch, where an existing manual Excel system for inventory management leads to inefficiencies and errors in recording goods movement, thereby reducing overall employee effectiveness. The premise that a modernized information system is crucial for overcoming these limitations is well-established and relevant to a wide range of organizations. The proposed solution focuses on an "upgrade" to the current Microsoft Excel recording system to address these identified shortcomings. The core enhancements outlined include the development of an improved dashboard display and the implementation of automated calculations for inventory additions and subtractions. This initiative aims to transition the branch from a laborious, manual data entry process to a more automated and precise system, with the explicit goal of boosting the effectiveness and efficiency of human resources. By leveraging an existing, familiar tool like Excel, the project appears to offer a pragmatic and potentially low-cost intervention tailored to the specific operational context of the Bojong branch. While the approach of enhancing an existing Excel system offers immediate practical benefits for a local branch, the scope and nature of the "information system application" warrant further consideration for a journal publication. True information systems typically encompass features such as robust database management, multi-user concurrency, stringent data security, and scalability that often exceed the inherent capabilities of even a sophisticated Excel spreadsheet. The abstract describes a design project primarily focused on local optimization rather than a broader system architecture capable of addressing enterprise-level challenges or growth. For future iterations or a more comprehensive academic contribution, it would be beneficial to critically evaluate the long-term limitations of an Excel-based solution, perhaps by comparing its functionalities and constraints against dedicated inventory management software, and exploring avenues for transitioning towards a more scalable, secure, and resilient database-driven system.

Full Text

Comments

You need to be logged in to post a comment.