Development of system and database for Capacity Planning in Integrated Circuit Manufacturing

Abstract

The objective of this study was to reduce working-time during the capacity planning for integrated circuit manufacturing in final test process. From the study and data analysis of current processing situation of the company that was chosen as case study, data used in the calculation of capacity planning were stored scatteredly in Excel file format. As a result, time was wasted in collecting data, and it took a long time to calculate capacity planning and create the report. Therefore, we propose the solution by developing a database management system and web application for machine requirement calculation and capacity planning. After the experiment, it was found that while conventional working process took 5 hours for one capacity planning task, the new process takes only 15 minutes for the same task. This can be deduced that working-time has been reduced by 95%, and also the output result has 100% of correctness.