Design of Recording and Inventory Control System in Food Canning Factory Sharing

Abstract

Inventory control is very crucial in ensuring the smoothness of production activities in a company. PT Kita Satu Rasa as a food canning factory sharing needs to have a systematic inventory control system to cope with uncertain demand and improve their service performance. This study aims to identify the need for an inventory control system at PT Kita Satu Rasa and to design an inventory control system that is able to meet the company's needs. The inventory control system is designed with the aim of maintaining the availability of cans so that the company will always be able to meet customer’s demand. The method used are the determination of safety stock and reorder point as a reference for the precise order time to the can supplier. The system is designed on Microsoft Excel software and tested for feasibility and suitability to meet company needs through usability testing, simulation, and interview. The results of usability testing show that the system is classified as very feasible with an acceptance percentage of 90%. Through simulation, the system is proven to be able to prevent stock outs compared to the method used by the company. The system is well received by the company and its implementation is expected to contribute to the improvement of the company’s performance and service as a canning service provider for MSMEs.