IMPROVING EFFICIENCY IN DETERMINING THE QUANTITY OF RAW MATERIALS (Duplex and PET) USING VISUAL BASIC FOR APPLICATION

Abstract

This research concludes that the manual process for determining the number of Duplex and PET material orders causes a high cycle time of 25,761 seconds or 429 minutes. High cycle time may affect other departments, if the order is late, it will cause Logistics department and Production department to delay due to not being able to manufacture products on time. After the current system problems are identified, the proposed system uses the System Development Life Cycle (SDLC) methodology with VBA Macro as the main tool. The new system is implemented to reduce manual process and cycle time can be reduced to achieve the aim of this research. Implementing this new system reduces the manual process for determining the number of quantity orders for Duplex and PEt materials to 481.1 seconds or 8 minutes. This is a very drastic change because some of the waiting work has been taken over by the material planner. and this gives full rights to the material to the material planner.