How to build a MES?

If you or your company want to build  a MES (Manufacturing Execution System), it's a big job can't do it by your self. And you may co-work with vendors and consultants to do it. The customize fee is charge by working hours. If you have a sample concept for MES, and you will less working time for these common sense discussions.

I had have build 3 MES for 3 companies, but all of them are LED industrial, and very different manage way their are.

What is MES?
A manufacturing execution system (MES) is a control system for managing and monitoring work-in-process on a factory floor. An MES keeps track of all manufacturing information in real time, receiving up-to-the-minute data from robots, machine monitors and employees. Although manufacturing execution systems used to operate as self-contained systems, they are increasingly being integrated with enterprise resource planning (ERP) software suites. The goal of a manufacturing execution system is to improve productivity and reduce cycle-time, the total time to produce an order. By integrating an MES with ERP software, factory managers can be proactive about ensuring the delivery of quality products in a timely, cost-effective manner.

The MES must cost effectively meet the business criteria.
1.improve manufacturing processes and  quality.
2.Reduce IT involving and low build and maintenance cost.
3. Easy support the production line future growth or development.
4.   Integrate with other critical systems in company, ex. ERP.
5.Readily and rapidly adapt FAB un-schedule change in production cycle in business.

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.