Thesis

INTRODUCTION

Inventory is a difficult asset to control—it arrives and depart company premises daily, it is scattered throughout the warehouse and production areas (and possibly offsite storage locations), it may contain obsolete or scrap items, can involve thousands of part numbers, can include items owned by the suppliers, and may be valued using a variety of techniques. Buying inventory costs money. Therefore, more efficient control of the amount of inventory required to be held in stock to fulfill orders can be better for a company in terms of its cash flow. Having a more efficient system in place can help make a company more productive and this is also cost-effective.

Due to the complexity posed by inventory control and tracking systems, accuracy of data and efficiency of the system should always be the top priority as information gathered is very critical for effective decision-making. With these in mind, the researchers sought and studied every aspect and details of Dennis and Gina General Merchandise, and have taken into consideration the areas of opportunity that can contribute to a more efficient and systematic inventory system.

Indeed, for some small-mid businesses, purchase of an electronic inventory tracking system might constitute a wasteful use of financial resources, and for this reason, the researchers have come up with a computerized inventory system with minimal system requirements, Microsoft Office Excel, which, in this study, have been utilized to its full potential and capacity as it aims at increasing productivity and maintaining competitiveness. Moreover, the system is capable of addressing a wide variety of inventory control options—in one integrated system.

Given such development, the Proposed Integrated Inventory Control System will be a critical organizational asset to Dino and Gina General Merchandise that can help it realize important competitive gains in the area of inventory management.