Project Management Information Systems: an Experience of Developing and Implementation on a Production Enterprise. Case Study Nataliia Yehorchenkovaa,, Oleksii Yehorchenkovb and Anton Sazonova a Kyiv National University of Construction and Architecture, Povitroflotsky Avenue 31, Kyiv, 03037, Ukraine b Taras Shevchenko National University of Kyiv, Volodymyrska Street, 64/13, Kyiv, 01601, Ukraine Abstract There is considered in this paper an experience of development and implementation of a project management system, that includes such components like information technology of project management and a new organizational unit "Project Management Center" of a production aircraft enterprise “Skyeton”. The authors highlighted the main problem of project management in the production enterprise – the intersection of production and project activities in resource management of the enterprise. So, in the paper, there is presented how this problem was solved via the development and implementation of a PRP system that is destined for the collection, storage, processing, and use of project information for budgeting and management of logistical and labor resources purposes, and the scheduling of project realization on different levels of the production and project activities of the Skyeton. The theoretical and practical substantiation of the use of such a system is presented, as well as its advantages compared to similar systems. Keywords Resources management, project and program portfolio, project management, plan, production enterprise, information technology. 1. Introduction Production (or manufacturing) enterprise is a business entity established to produce goods for sale to wholesalers, retailers, or end consumers [1]. Such kind of enterprise decides how much of each commodity that it sells (its “outputs” or “products”) it will produce, and how much of each kind of labor, raw material, fixed capital good, etc., that it employs (its “inputs” or “factors of production”) it will use. The various decisions a business enterprise makes about its productive activities can be classified into three layers of increasing complexity. The first layer includes decisions about methods of producing a given quantity of output in a plant of a given size and equipment. It involves the problem of what is called short-run cost minimization. The second layer, including the determination of the most profitable quantities of products to produce in any given plant, deals with what is called short-run profit maximization. The third layer, concerning the determination of the most profitable size and equipment of the plant, relates to what is called long-run profit maximization [2-5]. If a large enterprise is project-oriented and its project and production activities are closely united then there is a place to talk about megaprojects, because project management in production processes is needed large investment commitment, organizational complexity, and long-lasting impact on the economy, the environment, and society. ____________________________________ Proceedings of the 2nd International Workshop IT Project Management (ITPM 2021), February 16-18, 2021, Slavsko, Lviv region, Ukraine EMAIL: realnata@ukr.net (A. 1); alexee@ukr.net (A. 2); teusone1@outlook.com (A. 3) ORCID: 0000-0001-5970-0958 (A. 1); 0000-0003-1390-5311 (A. 2); 0000-0002-3576-1083 (A. 3) ©️ 2021 Copyright for this paper by its authors. Use permitted under Creative Commons License Attribution 4.0 International (CC BY 4.0). CEUR Workshop Proceedings (CEUR-WS.org) In the paper authors consider an Aviation Production Company “Skyeton”. The enterprise was founded by a group of engineers and pilots in 2006. The company develops and supplies small unmanned aerial systems and light sport aircraft for numerous aerial solutions. One of the enterprise products is Skyeton K-10 Swift - a two-seat, single-engine light sports or ultralight aircraft designed in Ukraine. The Skyeton Swift is a conventionally laid out single-engine, high-wing light aircraft with side-by-side seating for two. The wings have a constant chord, each braced with a single lift strut to the lower fuselage longeron. They use a single metal spar and have stressed skin metal upper surfaces and leading edges, combined with fabric-covered lower surfaces aft of the spar. Fabric covered ailerons and inboard slotted flaps together occupy the whole of the wing trailing edges. The wings carry 2.17° dihedral [6-8]. The main feature of the Skyeton enterprise is using project approaches for production activity. This means that process of creating every aircraft was considered as a separate project, and the production of all aircraft was defined as a project portfolio. So, there was a situation of intersection of the processes of production of airplanes and project management processes. To combine these processes, it was necessary to overcome the next gaps: lack of the information technology that allowed manage both projects and products at the same time with constant information synchronization and lack of organizational unit that will be responsible for project management, like Project Management Office. These gaps were a bridge by the project management system implementation. The project management system included implementation of information technology, changing organization structure, and developing project management methodology. Today exist a lot of scientific researches is dedicated to overcoming these gaps. Some of them are works of Teslia I.M., Morozov V.V., Livesey V.P., Ahrari A.M, Hassan A., and so on [9-13]. Nonetheless throughout proposed in the research approaches there was no one suitable for Skyeton enterprise. The objective of the paper is a description of the experience of project management system implementation on the production enterprise Skyeton. 2. The Main Focus of the Paper The main challenge of project management system development and implementation was resources management of production and project activities of the Skyeton. This problem was based on the relationship between the use of project resources and produced resources of the enterprise. On the (fig.1) this relation is presented. Figure 1: Relation between resources for project and production activities Let’s make a short describing the figure. For project activity the next types of resources are highlighted: Labor resources – a staff of an enterprise that is involved in the creation of a product of production activity. 1. Produced resources – resources that are the results of the production activity of an enterprise. Authors highlight the next types of produced resources: • Resources for production activity. Examples of such resources: raw materials, material, and semi-finished products. These resources are parts of other produced resources. • Resources for project activity. These resources are used for the creation of products resulting from the project activity of an enterprise. • Resources for sales. These resources are used for external sales. 2. Purchased resources – resources resulting from procurement processes of the enterprise. Purchased resources are involved in the production of produced resources. Table 1 shows an example of Skyeton resource and its constituents. Table 1 Example of Skyeton resource and its constituents L-0 Longeron. Code Labor Labor Code Purchased Plan Code Produced Amount of LR resources costs, of PR resources amount of PrR resources of PrR (LR) person * (PR) of PR (PrR) h LR.1 Avangard 6 P.1 Bolt M6x24 8 PR.1 Upper belt 1 LLC (laser OST1 cutting) 31138-80 LR.2 Technical 0.7 P.2 Nut M6 8 PR.1-1 Upper belt 1 control OST1 33059 (produced) LR.3 Coating 3 P.3 Ducson 0.1 PR.1-2 Upper belt 1 anodizing DX61 primer (painted) wh./ col. with DX32 thinner LR.4 Riveting 4 P.4 Rivet 3,5x12 36 PR.2 Lower belt 1 plot OST1 34078-85 LR.5 Layout 3 P.5 Rivet 3,5x8 21 PR.2-1 Lower belt 1 precinct OST1 34078 (produced) LR.6 Рainting 2 P.6 Rivet 3,5x9 200 PR.2-2 Lower belt 1 precinct OST1 34078 (painted) LR.7 Locksmith 4.7 P.7 Rivet 4.0x10 2 PR.3 Spacer 2 precinct OST1 34078 On the (fig.2) presented the hierarchical structure of “Longeron” resource components and also labor resources for its production. Figure 2: Hierarchical structure of “Longeron” resource The longeron is one produced resource of an aircraft, but for the creation of Swift K-10, it is needed about 900 produced and 600 purchased resources. The project portfolio consists of 4-5 aircraft that are created at the same time on different stages of production. Looking at the figure it could be imaged that it is a pretty hard task to manage all resources of the project portfolio given the fact that during the management of these resources in project activity of an enterprise here is a plurality of processes of planning, procurement, storage, logistics, etc. So, there should have been implemented pretty powerful information technology that would allow to make a portfolio schedule and would have tools for all processes of resource management. There was decided to implement software “Primavera P3” for project portfolio planning. But this solution was turned out to be unsustainable in the context of project and production activities of the enterprise because there were issues the solution of which is not provided for in a functional environment of Primavera P3. These issues are defined below. During implementation of the Primavera information system, the next issues were raised: 1. It was necessary to do about 2700 operations for the creation of every aircraft. As far as there was a necessity to manage the projects and the production it was necessary to put all these operations into the Primavera database. Also, links between operations should be set, and resources assigned to tasks. Wherein it was produced in parallel a few aircraft that shared the same labor resources. As the result, it was obtained a complex manageable project portfolio schedule plan. 2. There was a big variance in order of resources production and so it was able to use different optimizations models for schedule plan, but it was impossible when the project plan was created by hands. 3. Constant changes in project portfolio lead to changes in portfolio schedule plan which was pretty hard to make by hands. For example, the CEO decided to change priorities, and there became a situation when it was needed to push one aircraft forward and the schedule plan was changed pretty much and these changes demanded hard work. 4. Often details were produced not one by one but by packages. This helped to reduce time wasted on equipment setup. As a result, part of the produced resources were sent to the warehouse. These resources were used in the next aircraft and did not have to be produced again. Information about warehouse contained in accounting system. And for quality planning, there was a necessity to exchange information between Primavera and the accounting system. 5. It was unclear in the Primavera project model how to manage resources that change their state. 6. It was necessary to manage procurements in the project portfolio and often it is convenient to group purchases from different projects. Also, there was needed to purchase resources in advance. The time for purchase depended on resources. It was tricky to manage such things in Primavera. So, such software as Primavera did not cope with the task of project and production management of the enterprise. There was presumed that with MS Project and the other similar products there will be similar problems. Considering this there was a variant to implement Enterprise Resource Planning (ERP) system, but after marketing analysis, it was defined that ERP system has a weak project management module and these class of system also can solve all planning issues and as result can’t be used for management of project and production activities of the Skyeton. And as a solution, it was decided to develop add-ons for Primavera. And in the process of development, it becomes clear that it easier would be to develop an independent information system that add-ons for Primavera. Such information system should allow to management resources like an ERP system and manage projects like Primavera and will connect information systems are involved in project and production activities. But creation of the such system was needed some theoretical base – the development of a matrix management approach [14]. 3. The matrix management approach The matrix management approach is the project management approach, the implementation of which is carried out in functionally oriented management structures and ensures the achievement of project and enterprise goals. The implementation of methods and tools of projects and organizations management reflects the technology for solving functional problems and does not allow creating a system of actions (works) in matrix management technology. Management technology matrices are formed at the intersection of project and organization management processes with business management procedures. The realization of the matrix management approach indicates the nature of project implementation, the movement of materials, resources, and information along the technological chain determines the organizational and technological features of the structure of the project-oriented enterprise as an object of management. The matrix management approach is used in project and program portfolio management and allows to manage project resources (in contrast to resource management in projects - which is typical for the critical chain method). The matrix models for resource management of the project and program portfolio are an integration of the critical chain method and the matrix management method and allow to manage both the resources in the projects (when the resources allocated to the project are distributed among the works overtime) and project resources (which is typical for the allocation of resources for portfolio/programs projects). And, it is very important, they allow to manage the production of these resources (during the construction of aircraft, create a plan for the production of details that takes into account the simultaneous implementation of several projects). This helps to solve the problem of resource management of project and program portfolios, which will increase the efficiency of the enterprise. As is known, the use of the critical chain method provides effective resource management in the project, while the matrix management approach is used to interconnect project management processes and production activities aimed at generating resources. Therefore, the authors proposed the development of a matrix model of resource management of the project and program portfolio. The matrix model of resource management of the project and program portfolio is an improved approach to project and program portfolios management and provides management processes and procedures that are not only in the vast majority of cases capable of ensuring the systematic completion of projects on time, within budget and by the originally agreed specifications, but also can significantly reduce the time of project execution without increasing resources. The matrix model of resource management of the project and program portfolio considers each portfolio/program as a set of projects ordered or related to each other, implemented through the production activities of the enterprise, which focuses on the production of resources for the project and program portfolio and products for customers [15]. Based on matrix model was developed and implemented PRP that allowed to solve problems with resource management of the portfolio of projects and programs of the company "Skyeton". 4. PRP system development and implementation The PRP system is destined for the collection, storage, processing, and use of project information for budgeting and management of logistical and labor resources purposes, and the scheduling of project realization on different levels of the functional and project-oriented activities of production and construction enterprises. This system is used in particular to the challenges of associated production (operative) and project activities of the enterprise. PRP system covered the next processes of the Skyeton activities: • project planning; • project administration; • project financing; and project information support. The PRP system aims to enhance the management efficiency of the project-oriented organization by optimal (rational) resource utilization and production project activities [16-22]. For these reasons, the PRP system solves problems listed below: • collection and storage of the information of available and required labor resources; • conducting of the regulatory information on the complexity and duration of the operations implemented by the company; • classical calculations of network, bipartite, and line charts; • modeling of the production (operating) planned activities of the enterprise; • preliminary analysis of the production (operating) planned activities of the enterprise; • report processing of the resource loading and production (operating) planned activities; • resource loading optimization; • calculation of the optimal number of resources. The PRP system has the following structure on the (fig.3). PRP system Project Data Base Modeling Management Resources Data Financial Task and and References Explotitation Manipulator Management Monitoring warehouse Budgeting Paymant Time plan Reporting Figure 3: The PRP system structure There are two unique advantages from the traditional project management information systems that the PRP system has: possibility of the simulation modeling and the ability to plan the project from a «product -resource- product» position [23]. Simulation module allows to create the optimal management plan for material and technical and labor resources of Skyeton production based on the established limits, the process sequence, and the requirements to the timing and cost for creating the aircraft. Schematically, the operation of the simulation module is shown in fig.4. Figure 4: The operation of the simulation module When using the simulation module, the best solutions are searched for taking into account the functioning of the entire enterprise, which is achieved by raising the awareness of all management services. The logic of the ability to plan a portfolio of projects from a «product -resource- product» position is as follows (fig.5, fig.6): Figure 5: Portfolio Planning Bipartite Graph Figure 6: The logic of using the bipartite graph 1. When initiating projects, the portfolio defines the product (result) of the project and the requirements for it. 2. A tree of products is being built, the result of which is a list of products necessary for creating the result of the project and the sequence of their necessity in the project. 3. The action on a product at a project-oriented enterprise is determined: • purchase a product; • produce; • take in the warehouse; • available. 4. A correlation of product requirements is carried out for all portfolio projects and a plan is drawn up. When using matrix models, the work will be characterized by two parameters: the product, which is the result of the work, and links with other works. Duration of work is determined automatically by labor efforts for product production. In Figure 7 it is shown a new work flow chart. Figure 7: Diagram of the production process of aileron [19] Such presentation of the resource’s movement process has several advantages: • the number of operations reduces; • duplication of resources disappears; • mess with how to calculate the cost of resources disappears (if resources are entered in the project management information system in the different states, how to determine on which of the states to assign the value?); • the process of determining the status (stage) of the task simplifies. For now, this value is the result of readiness or unavailability of many products. In addition to the planning and monitoring of the tasks fulfillment, materials and technical management, labor resources management, the system allows more accurate than traditional project management information systems to present the technical process, avoid duplication of resources, which is important for the management of projects [24-31]. 5. Creation and implementation of project management center For support of project management in the Skyeton enterprise and PRP-system, in particular, was created a department “Project Management Center”. Project Management Center (PMC) is a structured department of the Skyeton that standardizes project management practices within the enterprise. For this purpose, a single terminology, a single scheme of interaction is implemented, so that managers responsible for the project can understand each other freely. In addition to individual projects, PMC manages the main portfolio of Skyeton projects and structural departments, defines the methodology of repetitive processes, identifies the most effective methods for their future implementation in practice. Assignment of the center: 1. Providing transparent access to the project and program portfolio. 2. Facilitate project and program portfolio management. 3. Developing the methodology of megaproject management. 4. Regular analysis of projects and portfolios. 5. Project Change Management. The main functions of the PMC: 1. Project support: providing managers in the departments with project management guidance. 2. Project management process/methodology: development and implementation of an adequate and standardized process; interest in the experience of domestic and foreign enterprises; analysis and control of project implementation; change management in projects. 3. Training: guiding training programs; consultation on emerging issues; training in project management techniques. 4. Software tools for project management: monitoring the work of responsible employees of the branches when working with automated systems; providing consulting support to users of project management software. 5. Asset control and regulation: identifying staff of project managers who can coherently manage related projects and allocate resources qualitatively; forming a responsibility matrix that determines the place of each manager in the project. The PMC is responsible for allocating resources to improve production. Controlling the projects and responsible persons, the PMC appoints the persons who are most suited to the priority projects and continues to monitor the project until its completion. It also eliminates duplicate tasks, raises productivity, and gives the highest priority to critical projects. The Skyeton Project Management Center consists of the following organizational units: 1. Strategic Committee for the Development and Modernization of the Skyeton. 2. The Working Group for Information and Organizational Support of the Strategic Committee, which in turn includes: • Project and Program Implementation Committee; • Back office. 6. Conclusion The result of the implementation of the project management system was a PRP system that calculates the rational terms of task execution and project budgets in operational activities of the production aircraft enterprise "Skyeton". Experience has shown that the implementation of such technologies increases the production performance of the enterprise by 15-50%. Using the PRP system, it managed to increase the productivity of production by 1,5 times from 8 to 12 airplanes per year without increasing the number of work resources. For today, this system implements in other productions, for example, the Tutkovsky company. The main conclusions of the paper: 1. Production enterprises have specific features in business processes, organizational structure, etc. which should be included when the project management system is implemented. 2. Traditional information technologies of project management not suitable for the management of project and production activities of the enterprise, because these systems could not support all processes of project resource management and a lot of information is lost in project management processes. 3. Using the information system algorithms which are based on the bipartite graph is more convenient for such enterprises like the Skyeton because allows to manage the production of resources for projects of the enterprise. 7. References [1] N. Kokemuller, Define Manufacturing Enterprise. URL: https://bizfluent.com/facts-6148898- define-manufacturing-enterprise. [2] R. Dorfman, Theory of production. URL: https://www.britannica.com/topic/theory-of-production. [3] G. Mankiw, Macroeconomics (8th edition), Worth Publishers, 2012. [4] W.H. Greene, Econometric Analysis (7th Edition), Prentice Hall, 2011. [5] E.Monk, B.Wagner, Concepts in Enterprise Resource Planning (4th edition), Course Technology, 2012. [6] R.Bayerl, M.Berkemeier & et al., World Directory of Leisure Aviation, Lancaster UK: WDLA UK, 2011. [7] P.Jackson, All the World's Aircraft, Coulsdon/Surrey: IHS Jane's, 2010. [8] W. Tacke, B.Marino & et al, World Directory of Light Aviation 2015-16, Flying Pages Europe SARL, 2015. [9] A.Kolomiiets, V.Morozov: ”Investigation of optimization models in decisions making on integration of innovative projects”. Advances in Intelligent Systems and Computing 1246 AISC (2021): 51–64. [10] N.Yehorchenkova, I.Teslia, O.Yehorchenkov: ”Method of project and operational processes integration in the activities of project-oriented enterprises based on functional 4Р-environment”. CEUR Workshop Proceedings, 2565 (2020): 142–151, [11] V. P.Livesey Further insights by project managers into the problems in project management, 2020. URL: https://www.researchgate.net/publication/347404366_Further_insights_by_project_mana gers_into_the_problems_in_ project_management. [12] A.Ahrari, A.Haghani: A New Decision Support System for Optimal Integrated Project Scheduling and Resource Planning, International Journal of Information Technology Project Management, 10(3), 18-33, 2019. doi:10.4018/IJITPM.2019070102, [13] A.Hassan, S.Younas, A. Bhaumik: Exploring an Agile Plus Approach for Project Scope, Time, and Cost Management, International Journal of Information Technology Project Management (IJITPM), 11(2), 72-89, 2020. doi:10.4018/IJITPM.2020040105 [14] I.Teslia, I.Oberemok, O.Timinsky: Systematic organization of management interactions as a tool for improving the efficiency of complex projects, Bulletin ChSTU, 2, 2008. [15] N. Yehorchenkova: Integration of matrix technologies and critical chain method and project and program portfolio management, Management of Development of Complex Systems, 7, 30-35, 2012. [16] V.Burkov, D.Novikov, How to manage projects, Sinteg, 1997. [17] V.Burkov, D. Novikov, How to manage organizations, Sinteg, 2004. [18] A.Voronin, S.Mishin, Optimal hierarchical structure, ISP RAS, 2003. [19] G.Kendall, I.Gerald, S.Rollins, C.Steve, Advanced Project Portfolio Management and the PMO: Multiplying ROI at Warp Speed, 2003. [20] Parviz F. Rad, Project Estimating and Cost Management, 2001. [21] Carlos Eduardo Martins Serra, Benefits Realization Management: Strategic Value from Portfolios, Programs, and Projects, 2016. [22] Harvey A. Levine, Project Portfolio Management: A Practical Guide to Selecting Projects, Managing Portfolios, and Maximizing Benefits, 2005. [23] O. Iegorchenkov, N. Yehorchenkova: ”Product-Resource Planning System”. IEEE First International Conference on Data Stream Mining & Processing, 2016. [24] N.Yehorchenkova, O.Iegorchenkov: Digital ecosystem of instrument-making enterprise. Management of Development of Complex Systems, 27, 37-45, 2016. [25] N.Yehorchenkova, O.Yehorchenkov: ”Production and project activities modeling module of instrument-making enterprise”. 14th International Conference on Advanced Trends in Radioelectronics, Telecommunications and Computer Engineering TSCET’18, Lviv-Slavsko, Ukraine, 2018. [26] A.Iegorchenkov, N.Yehorchenkova: ”Simulation”. ІІ international scientific and practical conference “Information technology and interaction”, Ukraine, Kyiv, 2015. [27] V.Izhevsky, N.Atapina, V.Kononov: The use of statistical methods and simulation methods in risk analysis of the implementation of consolidation processes, Bulletin of the South Ural State University, Series: Economics and Management, 11 (3), 55-65. 2017. [28] M. Odrekhivskyy, V. Pasichnyk, A. Rzheuskyi, V. Andrunyk, M. Nazaruk, O. Kunanets, D. Tabachyshyn, Problems of the intelligent virtual learning environment development. CEUR Workshop Proceedings 2386 (2019) 359–369. [29] V. Tomashevskyi, A. Yatsyshyn, V. Pasichnyk, N. Kunanets, A. Rzheuskyi, Data Warhouses of Hybrid Type: Features of Construction. Advances in Intelligent Systems and Computing book series 938 (2019) 325–334. [30] R. Kaminskyi, N. Kunanets, V. Pasichnyk, A. Rzheuskyi, A. Khudyi, Recovery gaps in experimental data. CEUR Workshop Proceedings 2136 (2018) 108–118. [31] R. Kaminskyi, N. Kunanets, A. Rzheuskyi, A. Khudyi, Methods of statistical research for information managers, in: Proceedings of the 13th International Scientific and Technical Conference on Computer Sciences and Information Technologies, CSIT 2018, 2018, pp. 127– 131.