應用客製化 MES 與 BI 系統於隱形眼鏡工廠之即時外觀良率優化

NCUIR > College of Electrical Engineering & Computer Science > Executive Master of Computer Science and Information Engineering > Electronic Thesis & Dissertation > Item 987654321/99391

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

Title:	應用客製化 MES 與 BI 系統於隱形眼鏡工廠之即時外觀良率優化
Authors:	謝明蕙;HSIEH, Ming-Hui
Contributors:	資訊工程學系在職專班
Keywords:	製造執行系統;商業智慧;隱形眼鏡
Date:	2026-01-28
Issue Date:	2026-03-06 18:52:41 (UTC+8)
Publisher:	國立中央大學
Abstract:	隱形眼鏡產業正面臨少量多樣需求的挑戰。傳統人工管理無法支援頻繁換線下的數據整合，導致異常修正延遲並負面影響直通率（Yield Rate, YR）。本研究透過整合商業智慧（BI）與強化之製造執行系統（MES）來解決此問題。遵循 ISO 13485 規範，本研究開發了客製化 MES 模組，具備支援合併工單的流程卡設定（Run card）與多人協作檢驗輸入功能。來自八大機台的異質數據經 ETL 整合至 MySQL 資料庫，並由 Power BI 提供即時看板。結果顯示，缺陷報表整理時間由 50 分鐘縮短為即時顯示。即時警報促成參數快速調整，有效減少氣泡等關鍵缺陷。外觀良率從 68.41%（2024 Q2）提升至 70.92%（2024 Q4）。此 2.51% 的提升每月約減少 2.5 萬片報廢，證實本系統能有效將被動檢討轉變為主動的即時製程驗證。;The contact lens industry faces challenges from high-mix low-volume (HMLV) demands. Traditional manual management fails to support data integration during frequent line changeovers, causing delayed anomaly corrections and negatively impacting yield rates. This study integrates Business Intelligence (BI) with an enhanced Manufacturing Execution System (MES) to address these issues. Adhering to ISO 13485, this study developed customized MES modules featuring run cards for merged work orders and collaborative inspection inputs. Heterogeneous data from eight machines were integrated into a MySQL database via ETL, with Power BI providing real-time dashboards. Results show defect reporting time decreased from 50 minutes to real-time. Immediate alerts enabled rapid parameter adjustments, reducing critical defects like bubbles. The cosmetic yield rate improved from 68.41% (Q2 2024) to 70.92% (Q4 2024). This 2.51% increase saves approximately 25,000 lenses monthly, confirming that the system effectively transforms passive reviews into active, real-time process verification.
Appears in Collections:	[Executive Master of Computer Science and Information Engineering] Electronic Thesis & Dissertation

Files in This Item:

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

社群 sharing

Loading...