本研究以隱形眼鏡製造為個案,在資料蒐集中發現研究對象 I 公司在生產 排程與回覆交期上遇到了問題,其一是排程系統仍依賴人工排程,除了耗費大 量人工時間與效率低下外,還有人為失誤錯誤的風險。其二是公司訂單經常性 的急單,造成重排程變動頻繁,除了增加人員作業的負荷,也容易讓排程大 亂,其三是業務單位反映,客戶對於 I 公司的訂單準時交貨率不滿,經常性的 遲交已經造成客戶的困擾,公司高層也為此多次招開會議。 針對公司生產排程的問題,本研究使用 Excel VBA 的自動功能,達到以下 功能:自動抓取匹配相同系列的歷史數據良率和稼動率來計算,估算出最有可 能生產完成的時間,再劃分訂單的急迫等級,將交期較短較緊急的訂單優先生 產,以此方式降低經常無法準時交貨的情形。;This study takes contact lens manufacturing as a case study. During the data collection, it was found that the research object Company I encountered problems in production scheduling and response delivery. First, the scheduling system still relied on manual scheduling, which in addition to consuming a lot of manual time and efficiency In addition to being low, there is also the risk of human error. The second is that the company′s orders are often urgent, resulting in frequent rescheduling and changes. In addition to increasing the workload of personnel, it can also easily cause chaos in the schedule. The third is that business units report that customers are dissatisfied with the on-time delivery rate of company I′s orders. , frequent late deliveries have caused trouble to customers, and the company′s senior management has held many meetings for this reason. In response to the company′s production scheduling problem, this study uses the automatic function of Excel VBA to achieve the following functions: automatically capture and match the same series of historical data yield and utilization rates to calculate, estimate the most likely time for production completion, and then Divide the urgency levels of orders and give priority to orders with shorter delivery times and more urgent orders, in this way reducing the frequent inability to deliver on time.