Management reports available from ERP software package and data base for technological resources management in FMC.

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

Abstract: Using the specific reports of a built ERP software system adjacent with a FMC system, increases the efficiency in production programming at the FMC level. It was developed a new software system composed from an ERP web application for technological resource management and the database. In description of the new software system were considered the specific reports generated for launching and tracking/ monitoring the production.

Key words: software system, ERP, management.

1. INTRODUCTION

The paper comes to present the practical utility of the generated reports using the ERP software package and data base for technological resources management in FMC. In the paper are presented the reports and their utilization at the FMC level and in monitoring/ tracking the production. Using those reports the work efficiency will be increased and the time for transmitting the information will be improved.

2. INFORMATION

In the doctoral activity of the authors it was built an ERP software system observing a need for automation and centralization in the activities of production planning in FMC for machining. There were analyzed the components and the activities from a referential FMC and were identified the activity goals. The activity goals were transposed in specific reports generated in the ERP application.

2.1 Reports supplied by the informatics system

The ERP software application is composed from five functional modules: the Production basis module, the Technologies module, the Production Planning module, the Machines Status module and the Reports module. In each module is possible to generate reports containing the data existing in the database at the moment of generating. Those reports are shown in tables of the interfaces. Each interface contains the functionality for generating the report from the screen as Excel file report. On the overall activity the main reports are generated in the Reports module. The Report module contains a control for selecting the category of reports to be generated. The categories contained in the selection control are: standing assets, mobile assets, technologies, production. The standing assets category report contains the data about the machines and the robot from FMC system. The mobile assets category contains a subsequent control for selecting the group of assets. The groups of assets contained in the subsequent selecting control are bar-pieces, parts and tools. Selecting the wanted options is possible to generate the corresponding reports containing the data about selected group or category listed in the selection controls. The main reports for launching the production at the FMC level are generated selecting the Technologies and Production categories from the Report module level. The production launching reports contain all the information needed at the FMC level about technology and planning for starting the manufacturing.

In the ERP application for technological resources management in flexible manufacturing cells is possible to generate reports about part manufacturing technology and part's manufacturing drawings chart, tool sets, machines status, production planning and monitoring. The main reports contain the information to answer to questions like: when to start and finish the production, which are the machines, machining needed, machining parameters, tools to use, in a word how to do the manufacturing and also after the production is started what is the status of manufacturing. Having the right information the technicians from FMC level can program the machines, can select the right tools for machining and ask for the appropriate piece-bars for manufacturing the part.

[FIGURE 2 OMITTED]

[FIGURE 3 OMITTED]

[FIGURE 4 OMITTED]

[FIGURE 5 OMITTED]

[FIGURE 6 OMITTED]

In the ERP software application for technological resources management in FMC is possible to generate the needed reports at the production starting and monitoring, mainly in the Reports module but also to the each specific component module. All the reports are generated containing the data existing in the database at the moment of generating. The data contained in the database is managed by the ERP software application modules. In Fig.2 is presented the interface of the Reports module with the selected category Production. The interface contain a table where are listed the information about production as direct data or as hyperlinks to relevant adjacent reports. From the Production interface of the Reports module is possible to see the current status of manufacturing, the part manufacturing technology, the part manufacturing drawings chart, the machines and tools used, the machines status and the Project file of production planning. In Fig.3 is presented overall part's manufacturing technology report containing the machines, tools, machining and parameters. The report is printable from the browser level. In Fig.4 is presented the part manufacturing drawings chart report. For each step of manufacturing, the report contains a graphical representation of the part at the moment with the tools in work position. The report also contains the name of machining, the tools and machines. In Fig.5 is presented the report shown in the main interface of Machines Status module. The table below the controls section contains the current status of each machine/ robot from the FMC components. In the shown report is available a hyperlink to a detailed report of the corresponding machine containing the history of machine status in time. In Fig.6 is presented the overall production planning and monitoring report containing the preview of the Gantt chart and controls for data management. All the presented reports are very useful in production launching and managing in FMC systems. (Hernandez, 2003; Leon, 2005; Negara, 2004; Stoian, 2003; EBS, 2005; Chatfield & Johnson, 2002; Vlase, 2002).

3. CONCLUSION

There were presented the goals of operating the technologicalinformatics systems and the specific reports corresponding to the need of activity. It was detailed the practical utility of the generated reports in the informatics system. 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 increasing 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

Chatfield, C. & Johnson, T. (2002). Microsoft Project2000, Teora Publishing, ISBN 973-20-0651-X, Bucharest

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

Negara, G. (2004) Applications development in Visual Studio .NET-Course material, Faculty of Informatics, Iasi

Stoian, G. (2003). Software Interfaces. Course notes, Faculty of Mathematics--Informatics, Craiova

EBS Romania (2005). Clarvision ERP--Application documentation

Vlase, A. (2002). Manufacturing Technology of the Industrial Robots--Course material, UPB, Bucharest

Fig. 1. Reports supplied by the informatics system

ERP APPLICATION FOR TECHNOLOGICAL
RESOURCES MANAGEMENT IN
FLEXIBLE MANUFACTURING CELLS

PRODUCTION LAUNCHING
REPORTS

PART MANUFACTURING TECHNOLOGY
PART TECHNOLOGICAL FILM
TOOL SETS
MACHINES STATUS - AVAILABILITY
PRODUCTION PLANNING - START/END DATE
PRODUCTION TRACKING/MONITORING