How to evaluate your DL manpower (2/2)

How to judge DL's manpower's value. It's a difficult topic in management. Because of your target is people. I want to focused on certify system, and about the working quality  and productivity, I will split to another article to explain it.
Why I using certify to describe DL manpower value? My Boss say, we can'd do management if not quantitative it. A manpower's value is what he or she can do for you. Beside the volumes, the other one is what he/she can do on his job.
In my working experience, we using certify to describe the manpower's skill level. The more certify he or she does, and more job he or she can do.

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.

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