Optimal Production Scheduling using VBA on Microsoft Excel

Abstract

The objectives of this research were to develop the sequence production for multiple machine-multiple job, and to reduce schedule production time in a case study problem using Visual Basic for Application (VBA) on Microsoft Excel. Generally, sequencing problems occur frequently and are important issues for manufacturing processes in industrial processes It is difficult to find the best method to solve these problems, since there are many variables that affect the manufacturing processes, such as processing time, queue time and idle time. This research studied especially manufacturing on machine including five jobs and four machines flow shop. The operating system for this analysis assumes that each machine can handle one job at a time, all machines are ready to perform and a machine will be available for the next job only when the previous job has been completed. Based on the information used in the study and results of analytical algorithm by using VBA on Microsoft Excel, it was found the best method to solve problems in sequence production with case studies, and presented the minimize makespan of 34 minutes. Finally, the results obtained from the VBA program are accurate and can be evaluated quickly in about 12 minutes of processing time.

Keywords

• vba
• microsoft excel
• sequence production
• schedule production