English  |  正體中文  |  简体中文  |  全文筆數/總筆數 : 80990/80990 (100%)
造訪人次 : 41077203      線上人數 : 1120
RC Version 7.0 © Powered By DSPACE, MIT. Enhanced by NTU Library IR team.
搜尋範圍 查詢小技巧:
  • 您可在西文檢索詞彙前後加上"雙引號",以獲取較精準的檢索結果
  • 若欲以作者姓名搜尋,建議至進階搜尋限定作者欄位,可獲得較完整資料
  • 進階搜尋


    請使用永久網址來引用或連結此文件: http://ir.lib.ncu.edu.tw/handle/987654321/94582


    題名: 以優先級排程模式建立排程自動化模組提高準交率-以I公司為例
    作者: 呂世暐;Lu, Shih-Wei
    貢獻者: 工業管理研究所在職專班
    關鍵詞: 排程自動化;生產排程;重排程;訂單準時交貨率;Excel VBA;Scheduling automation;production scheduling;rescheduling;on-time delivery rate of order;Excel VBA
    日期: 2024-07-22
    上傳時間: 2024-10-09 15:17:33 (UTC+8)
    出版者: 國立中央大學
    摘要: 本研究以隱形眼鏡製造為個案,在資料蒐集中發現研究對象 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.
    顯示於類別:[工業管理研究所碩士在職專班 ] 博碩士論文

    文件中的檔案:

    檔案 描述 大小格式瀏覽次數
    index.html0KbHTML20檢視/開啟


    在NCUIR中所有的資料項目都受到原著作權保護.

    社群 sharing

    ::: Copyright National Central University. | 國立中央大學圖書館版權所有 | 收藏本站 | 設為首頁 | 最佳瀏覽畫面: 1024*768 | 建站日期:8-24-2009 :::
    DSpace Software Copyright © 2002-2004  MIT &  Hewlett-Packard  /   Enhanced by   NTU Library IR team Copyright ©   - 隱私權政策聲明