OEE reoprt- Overall equipment effectiveness

Let's come back introduce the report in manufacturing, the next is a very important report in MFG's daily life. The OEE report is evaluate and explain FAB daily operation useful tool. It looks like below picture shows.

(This picture is get from http://oeealert.com/index.html)

Each row means one equipment daily status.

KER--- Key Equipment Report

The next report, I want to introduce KER to you. This report is provided another view of point with KSR. it look like below picture.
This report is I create for a LED FAB.

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.

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.
在上一篇文章中,我介紹了整體公司所使用的製造指標,在這篇文章中我將會介紹常用的監控製造本身的指標,這些指標包含了 在製品,週轉率,每小時產出,以及可生產與非可生產時間.