Enhancement of Brake Pads Production Planning with Time Management and Process Condition Using VBA on Microsoft Excel

Abstract

This research aims to increase the efficiency of work management in the production planning process. This research uses an industrial engineering method based on a time and motion study to record operational data and create a standard planning process in the production process. It also uses the VBA on Microsoft Excel to analyze data and facilitate the work of the operators. The results of time data recording can be used to calculate the standard time as part of setting work sequence standards. The trials for two sessions (session 1 is a daytime production and session 2 is a nighttime production) with different production process results showed that the program could be used to plan the two sessions’ production with no difference. The usability test revealed that programmed planning results were greater in percentage mean accuracy compared to actual production than existing planning. There was a 72.17% increase in efficiency in session 1 and a 73.48% increase in efficiency in session 2. This was a statistically significant increase in efficiency. Therefore, it can be concluded that using the above principles and methods can improve the production planning process to be able to plan production more accurately.