INTEGRATED BUSINESS PLANNING ALL IN ONE AUTOMATING PROCESS TOOLS USING VBA-EXCEL (CASE STUDY AT PT APL INDONESIA)

Abstract

It is discovered that the supply chain management division, or more specifically, Integrated Business Planning (IBP), only has one member serving as a supervisor and assist by one Intern to handle many task that still carried out by manually at the company with a huge size like PT APL Indonesia. IBP has a scoring system that includes input scoring, which gives value for accuracy in submitting specific documents, next is process scoring that gives value to each participant's attendance at monthly meetings, and another scoring system which gives value for each division's work results called output scoring. The division must open numerous documents and programs to complete each of these scoring processes, and the process is still carried out manually. By existence of this application, the IBP division can do almost practically all of its processes could be completed in a single excel-VBA file. Long-running processes can be shortened by up to 70% compared to their initial duration. Another feature of this application is the ability to complete a whole process by simply clicking one button. Based on Excel-VBA, which is intimately familiar to the Supply Chain Planning division's users, enabling it to be utilized and comprehended with ease. With this application, IBP supervisors who previously required interns to complete manual tasks can now eliminate the need for interns to be replaced every six months.