以優先級排程模式建立排程自動化模組提高準交率-以I公司為例

NCUIR > School of Management at National Central University > Executive Master of Industrial Management > Electronic Thesis & Dissertation > Item 987654321/94582

Please use this identifier to cite or link to this item: http://ir.lib.ncu.edu.tw/handle/987654321/94582

Title:	以優先級排程模式建立排程自動化模組提高準交率-以I公司為例
Authors:	呂世暐;Lu, Shih-Wei
Contributors:	工業管理研究所在職專班
Keywords:	排程自動化;生產排程;重排程;訂單準時交貨率;Excel VBA;Scheduling automation;production scheduling;rescheduling;on-time delivery rate of order;Excel VBA
Date:	2024-07-22
Issue Date:	2024-10-09 15:17:33 (UTC+8)
Publisher:	國立中央大學
Abstract:	本研究以隱形眼鏡製造為個案，在資料蒐集中發現研究對象 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.
Appears in Collections:	[Executive Master of Industrial Management] Electronic Thesis & Dissertation

Files in This Item:

File	Description	Size	Format
index.html		0Kb	HTML	26	View/Open

社群 sharing

Loading...