How to get the manufacturing indices raw data?

One  of my friend told me, we don't have MES (manufacturing Execution System) in our company. How can I get that data?

有人跟我反映,我們公司沒有MES (製造執行系統),我要如何取得這些資料?

It's a big question, I have experience in 3 types of company, maybe I can shear some experience with you.

這是一個大問題,我曾經在三種不同狀況的公司待過,也許可以提供一些建議給你.

1. MES is setup, and implement very well. We have a CIM guy or a team for MES maintenance and development. If you need the raw data, you just ask the CIM guy, provide you a read only's Data Base account, and you can access the database by SQL language though Excel, Visual Basic,Access or other  program languages to develop your reports.

Access MES Database is a very serious thing, it may impact MES performance is your SQL is not good enough, CIM will provide you a DATA Mart's account, it's duplicate from MES database.
We will discuss SQL and  Excel VBA later. If you have such environment, it's very convenient for you develop these management report. All you need to do is ask.

The Most Important Report In MFG -- KSR

KSR is Key Stage Report, It shows the whole production line status in one report. It's a very useful tool when you want to know the line situation deeply.

KSR是重要站點報告,他可以展現整個產獻的狀況.這個報表在深入了解線上狀況時事一個很有用的工具.

KSR is a throughout views, and it record WIP/HWIP (Hold WIP,)/ Wait Time/ Stage Target/Move information by technology.
KSR looks like this format (It's Create by me for a LED FAB, it create by Excle VBA)

KSR是一個縱觀的報表,他紀錄了各產品別的在製品,暫置的在製品,等候時間,站點目標,產出資訊.
KSR報表的格式如同附圖一樣(這是我用Excel VBA所製作的一家LED公司所使用的KSR)

Common Used Report in Manufacturing--MFG indices Daily Summary Report

FAB plan /operation Report and System as the picture shows in below.

工廠內的計畫/運作報表及系統如同下圖所示:


All the Manufacturing Plan are comes form MPS ( Master Production Schedule) and FAB cycle time plan, and MPC (Manufacturing PC) will generate a FAB daily operation plan daily.

所有的製造計畫都來自於主排程以及工廠內的生產週期計畫,製造部的PC將會把主排程的目標拆解成每天的執行計畫.

MFG common used moniter indices

I introduce whole company's manufacturing indices in last article. I will introduce the common used monitor indices in manufacturing. These indices include WIP, Move, Turn Rate (T/R), WPH and available/non-available time.
在上一篇文章中,我介紹了整體公司所使用的製造指標,在這篇文章中我將會介紹常用的監控製造本身的指標,這些指標包含了 在製品,週轉率,每小時產出,以及可生產與非可生產時間.

Manufacturing KPI (Key Performance Indices)

The KPI is a normal term in your career path, which was used to monitor the daily working performance and status by these KPI. If you are sales your KPI will be how many goods you sale. And test score is your KPI if you are a student.
This article will introduce manufacturing terms, such as Wafer out, CLIP, CVP, FAB yield indices,  etc. These indices/terms are daily communication terms in manufacturing. These terms you can find definitions in your text book, I will try to add some actual cases in our FAB.

KPI (關鍵績效指標) 在職涯中是一個很常用/很常見的名詞. 這個指標可以用來衡量工作的表現. 如果你今天是業務員,那麼賣了多少東西就是你的KPI, 如果你是學生,那考試成績就是你的KPI. 本文將會介紹一些製造部常用的名詞,例如 產出,CLIP,CVP, 工廠良率,WIP (在製品), 週轉率,, 製造循環時間等. 這些名詞都是製造部日常溝通的用語.這些名詞你可以找到教科書上的定義,但是我試著介紹在工廠內是如何使用這些名詞或KPI的方式在本文中介紹.

I will start to write some article about manufacturing.

Hi All,
I am CW Hsiao, you can call me Pigo. I have manufacturing experience about 13 years until now. I have worked in TSMC (the biggest IC foundry in the world) MFG dept about 5 years, and EPI star (the biggest LED dice fabrication company in the world)  MFG and QC dept about 5 years. And I work for LED MFG Dept now.

I want to leave some experience memos and notes for all the guys who needed.
I plan one article each week, there are too many things can be write. I believe there are a lot of books for manufacturing field. But I will try to use my personal experience and knowledge to explain the manufacturing in my eyes.

The Blog will include the execution side, people management, FAB control, QC concept and all you can imaging.  You can tell me what you want to know, and I will try to write it out.

The first article I want to write is about FAB KPI (Key Performance Indices).  English is not my mother language, maybe a lot of mistake I  will made, pls feel free let me know. Thanks for your watching. See you soon.

大家好:
我是Pigo, 我在製造的領域已經有十三年的經驗. 我曾經在TSMC (世界最大的晶圓代工廠) 製造部工作過五年,在晶電 (世界最大的LED製造廠)的製造部以及品保部擔任過五年的主管.
目前我在LED的製造部擔任主管.

我想要在這邊將我的一些工作經驗做些紀錄,也許對於一些同在製造領域工作的人能有些交流.
我打算每個星期寫一個主題,在製造的領域有太多東西可以寫了,在教科書上或者是網路上可以找到很多這方面的資料.但是我試著用我自己的經驗跟觀點來解釋製造.

製造的領域是很大的,我想應該會涉及製造執行,人員管理,工廠管理,品保概念等,你可以想見的各種Topic 我都會提及. 如果有人需要我先寫哪些內容,也可以告訴我,我會試著從我的想法出發,寫一些簡單的看法.

第一個部份我想我會寫的是製造相關的KPI以及Terms, 在這邊我會盡量使用中文跟英文各寫一遍,我的英文不是很好,可能會寫得二二六六的,請大家給我意見囉! 不過練習應該就會進步吧??我是這樣想的!!