Small And Medium-sized Enterprise Workshop Production Management System Design And Implementation

With the rapid development of China’s economy and the mature of its investment environment, many major automobile manufacturers have set up factories in China. A wider market is opened for the domestic private automobile parts manufacturers. However the private auto parts manufacturers have to utilize advanced technology and improve their management skills to meet the requirements of the international cooperation. To survive and prosper in the competition, the private auto parts manufacturers have to adjust their production control methods in order to reduce the non-production related expenses and production cycle; on the other hand, it is important for them to promote their enterprise image to secure more business opportunities. To achieve this goal, it is necessary to adopt information technology in the production process. It is a fact that many of the small and medium manufacturers are still using paper logs and notes in managing their production process. The paper based method has its shortcoming of low efficiency and accuracy. By adopting information technology, for example, using bar code to collect real time production information will help in improving the efficiency and accuracy.To meet the requirements of the auto parts manufacturers, we developed a production process management software suite based on the specific requirements of Anhui MeiDa electronic industrial co. Ltd. In the software suite, the database is managed using Microsoft Access and the programming language is Visual Basic. The ADO (Active Data Object) control is used to establish communication between database and various applications.The software suite has user-friendly interface, it is easy to operate. It meets the general requirements of the small and medium enterprises in production information management. The current version of the software suite has been put into use in the production process of Anhui MeiDa electronic industrial co. Ltd. The software suite improves the efficiency of the production management. It not only provides real time information and analysis reports for management to understand and control the production process, it also helps to identify and solve the potential problems. The management can make more reliable decision with the help of the software suite. The enterprise competitiveness is greatly enhanced by using the software suite.