Basics of new ERP software package and data base for technological resources management in FMC.

Popescu, Stefan Eugen ; Minciu, Constantin ; Nicolescu, Adrian Florin] 等

Abstract: Using an adequate ERP software system together with a technological system, the efficiency in production programming is highly increased. It was developed a new software system composed from an ERP web application for technological resource management and the database. The software system and the referential flexible manufacturing cell (FMC) are forming a new technological-informatics system having specific interconnected practical features. In description of the new identified system were considered the general components and features, the inputs and outputs of the system, the software modules and functionalities.

Key words: technological system, ERP, management.

1. INTRODUCTION

The paper comes to complete the ways of practical using of FMC systems by integrating it with software systems for technological resources management. In the paper are presented the technical-informatics system, the methodology of work and the advantages of using the described integrated systems. The technological-informatics integration conduct to optimizing the utilization of technological systems by improving data flow communications, data management and decreasing the time for transmitting the information to FMC level.

2. INFORMATION

Initially it was composed the FMC system for machining. It was made an analysis of the components and activities from the level of FMC referential model for machining with Gantry robot. The components and activities are formed the basis of development of the ERP application for production planning and the database. So were identified the features of application functionalities and database. The ERP application was developed using VisualStudio2005 and the databases was developed using SQLServer2005.

2.1 The Reference model of FMC for tool machining

The Reference model of FMC for tool machining was formed by selecting the machines, the robot, the conveyor and the command and control unit. The FMC was composed for manufacturing parts with revolution surfaces starting from bars.

The FMC consists from following selected components:

1. Promot Automation Palette Conveyor (Promot,2006)

2. Gantry robot GUDEL with six degree of freedom,

3. Tool Center DMG Gildemaister TWIN102,

4. CNC System Motoman NX100. (Gudel; DMG, 2006)

In function of components dimensions were result the entire cell dimensions as being the following:

Height Tmin=4313mm; Width LXg_min = 5082mm; Length = LYg_min= 7285mm

The bars pieces are bring to the FMC level by palettes transported with the Conveyor system. The industrial Gantry robot positioning the bar pieces from Conveyor into the work space of the Tool Center for manufacturing the parts. When the work is done the part is positioned back on the port-part palette.

[FIGURE 1 OMITTED]

2.2 The developed ERP Software System

The ERP Software System consists from the ERP application and the database. Both of them were developed by analyzing the components and the activities from the FMC reference model. The activities and components determined the data tables from the database and the functionalities of the ERP application. The ERP application was developed as web application accessible in intranet from every available terminal connected in the network. The communication of data to the FMC working level consists in listing the appropriate reports for launching the production. In the activities of analyzing were identified the specific functionalities of ERP software system. The specific functionalities were grouped in distinct modules. Each module is interconnected with the others by sharing the same database tables. In the next image are observed the names of the modules and the specific functionalities from the ERP application for technological resource management in FMC. The ERP software system was built by applying practically the methods of programming enginery: analysis, design, implementation and testing. The application goals were consisting of easy and secure access to the application and also the users to can make data input and reports output. The ERP software functionalities are corresponding to the activity goals.

The combined systems technological FMC and informatics ERP are forming a new technological-informatics system with specific features and emergent properties. A system is a collection of interconnected components functioning together for a common purpose. A system can include software components, mechanical, electrical, hardware and electronics and can be operated by humans. The components are interdependent. The properties and behavior of components can be analyzed individually but also as a part of the entire system. (Leon, 2005)

Every system is characterized by the inputs and the outputs and also by the specific activities enterprise at its level. In the next table are presented the input data, the activities and the output data for the informatics system and technological system, forming holistically the table of technological-informatics system utilization. The output data from informatics system is the input data for the technological system and similar the output data from technological system become input data for informatics system. It can be observed the integration of the two systems and the main outputs consisting of manufactured parts and specific reports for launching and monitoring the production.

2.4 The advantages of Technical-Informatics system The advantages of utilization the Technical-Informatics system consist in:

* Centralized database of technological resources.

* Specific work functionalities: parts manufacturing technology, production planning, machines status, reports.

* Clear reports information for launching the production.

* Report tracking of the parts production status.

The database and ERP application permits an efficient data management about technological resources from FMC systems.

The design of the database was consisted in identifying:

* The purpose of the database

* The needed tables

* The needed fields of each table

* The links between the tables (Hernandez, 2003)

The specific work functionalities permit to the user to rapidly compose the parts manufacturing technology, to plan the start date and the end of the parts production, to monitor the machines status end to listing the specific reports. The functionalities were identified by analyzing the adjacent activities for launching the production in FMC. The reports were identified by analyzing the needs of information to the production level of the FMC. Overall the utilization of the new integrated system offer a clear evidence of the resources, production and machines and an increase speed of making the parts and diffusing the information flow in the system and to FMC personnel. The building of technological-informatics system was consisting of an interdisciplinary study, technological (FMC--engineering and management of the technological systems) and informatics (software methodology from programming enginery).

3. CONCLUSION

It was presented the technological-informatics system made from referential FMC for machining and the ERP application developed in the doctoral preparation activity by the author. It was presented in a centralized table the methodology of work-flow characterized by inputs and outputs. There were presented the advantages of using the informatics systems for resources management together with technological systems. Overall there were made original contributions by forming the referential FMC and building the software system made from ERP application and database. The contributions are conducting to an increase of the efficiency of work in planning, organizing, managing and tracking/ monitoring the production in FMC for machining. Next is intended the development of the entire software system in an assembly of modular software product useful to different industrial partners.

4. REFERENCES

Hernandez, M. (2003). Database Design, Teora Publishing, ISBN 973-20-0892-X, Bucharest

Leon, F. (2005). Programing Enginery--Course material, Gh. Asachi Technical University Iasi, Faculty of Automatics and Calculators, Iasi

BMH Bastian (2006). Bastian Conveying Solutions Catalog 404

DMG Gildemeister (2006). Twin Series Catalog Gudel Robotics (2006). Gantry Robot Trackmotion with KUKA motion controller KM C2G Catalog

Promot Automation (2006). Machine Tool Automation

Table 1 UTILISATION of technological-informatics system

The UTILISATION of technological--informatics systems

 INFORMATICS SISTEM TECHNOLOGICAL SISTEM


INPUT DATA Data about: --FMC Components
 --FMC Components --Data about part
 --Manufactured part --Semi-part
 --Semi-part --Input data from
 informatics system

ACTIVITIES --Data input --Revisions and machines
 --Part technology maintenance
 --Project and Web planning --Tools sets
 --Launching production --Machines programming
 reports --Machining

OUTPUT --Reports --Parts
DATA --Part technology --Production status
 --Film technology (Project planning, no. of
 --Manufacturing planning parts, web report)
 --Machines status
 --Tools and machines

Fig. 2. The components of the Informatics system

ERP APPLICATION FOR TECHNOLOGICAL
RESOURCES MANAGEMENT IN ROBOTIZED FLEXIBLE
MANUFACTURING CELLS

MODULES FUNCTIONALITIES

PRODUCTION BASIS DATA MANAGEMENT
TECHNOLOGIES PARTS PRODUCTION
PRODUCTION PLANNING PLANNING
MACHINES STATUS MAINTENANCE
REPORTS LAUNCH PRODUCTION

Fig. 3. The components of the Technical-Informatics system

TECHNICAL-INFORMATICS SYSTEM COMPONENTS

TECHNICAL SYSTEM INFORMATICS SYSTEM

IND. ROBOT WEB APPLICATION
TOOL CENTER
TOOLS DATABASE
TECHNOLOGY
MACHINING DATA INPUTS
TC PROGRAMING
PARTS REPORTS