| DC 欄位 |
值 |
語言 |
| DC.contributor | 工業管理研究所在職專班 | zh_TW |
| DC.creator | 呂世暐 | zh_TW |
| DC.creator | Shih-Wei Lu | en_US |
| dc.date.accessioned | 2024-7-22T07:39:07Z | |
| dc.date.available | 2024-7-22T07:39:07Z | |
| dc.date.issued | 2024 | |
| dc.identifier.uri | http://ir.lib.ncu.edu.tw:444/thesis/view_etd.asp?URN=111456019 | |
| dc.contributor.department | 工業管理研究所在職專班 | zh_TW |
| DC.description | 國立中央大學 | zh_TW |
| DC.description | National Central University | en_US |
| dc.description.abstract | 本研究以隱形眼鏡製造為個案，在資料蒐集中發現研究對象 I 公司在生產
排程與回覆交期上遇到了問題，其一是排程系統仍依賴人工排程，除了耗費大
量人工時間與效率低下外，還有人為失誤錯誤的風險。其二是公司訂單經常性
的急單，造成重排程變動頻繁，除了增加人員作業的負荷，也容易讓排程大
亂，其三是業務單位反映，客戶對於 I 公司的訂單準時交貨率不滿，經常性的
遲交已經造成客戶的困擾，公司高層也為此多次招開會議。
針對公司生產排程的問題，本研究使用 Excel VBA 的自動功能，達到以下
功能：自動抓取匹配相同系列的歷史數據良率和稼動率來計算，估算出最有可
能生產完成的時間，再劃分訂單的急迫等級，將交期較短較緊急的訂單優先生
產，以此方式降低經常無法準時交貨的情形。 | zh_TW |
| dc.description.abstract | 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. | en_US |
| DC.subject | 排程自動化 | zh_TW |
| DC.subject | 生產排程 | zh_TW |
| DC.subject | 重排程 | zh_TW |
| DC.subject | 訂單準時交貨率 | zh_TW |
| DC.subject | Excel VBA | zh_TW |
| DC.subject | Scheduling automation | en_US |
| DC.subject | production scheduling | en_US |
| DC.subject | rescheduling | en_US |
| DC.subject | on-time delivery rate of order | en_US |
| DC.subject | Excel VBA | en_US |
| DC.title | 以優先級排程模式建立排程自動化模組提高準交率-以I公司為例 | zh_TW |
| dc.language.iso | zh-TW | zh-TW |
| DC.type | 博碩士論文 | zh_TW |
| DC.type | thesis | en_US |
| DC.publisher | National Central University | en_US |