Automated system of planning of investment projects

The automated system of planning of investment projects is created for Department of Corporate Finances and Investments of MTS for the purpose of initiation, development, approval and monitoring of investment projects. A system covers more than 1500 users in more than 100 regions of presence of the company in the territory of the Russian Federation, Belarus, Ukraine and Uzbekistan.

Creation purposes

The purpose of creation and system implementation - providing in the structured form of the complete information on cash flows of investment projects for acceptance of management decisions concerning their economic feasibility, formation of plans of their financing, plan development of purchases and budgets of the company.

A system automates as procedural processes - initiation and monitoring of investment projects, formation and budgeting of an investment portfolio, and technology processes of collecting, the analysis, consolidation and data exchange at the different levels.

The automated procedural processes:

• Initiation, development, approval and monitoring of investment projects in the company;
• Formation of an investment portfolio of the company;
• Integration of an investment portfolio into the budget of the company (using the general forms and terms of data exchange).

The automated technology processes:

• Collecting and mailing in the multiple directions of information, providing simultaneous data entry at the different levels (The region, Makroregion, the Corporate center);
• The processing and authorization of information providing simultaneous operation over the investment project at the different levels (The region, Makroregion, the Corporate center);
• Consolidation of information at the levels of the Region, Makroregiona, the Corporate center;
• Storage (archiving of the connected data in separate arrays) and timely updating of information;
• Representation and data exchange between participating divisions of process of investment planning, control at the scheduled time and in a necessary format.

Functionality of the solution

Systems automates planning processes and the analysis of the investments of MTS company and formation on the basis of the arriving information of reports on the investment projects (IP) of the company. Basic functions of a system are:

• Initiation of SP;
• Approval of SP;
• Formation of an investment portfolio on the basis of consolidation all developed by SP in a uniform investment pool of Makroregion;
• Splitting investment portfolio of Makroregion and Corporate center for functional responsibility;
• Report generation (selection/report on SP on any of parameters, report on the capital investments, purchase plan).

The main instrument of formation of the plan of investments of the company is filling with the authorized staff of divisions of the company of a special investment form – the passport of the project which contains the following information:

• The reference information about an investment object;
• The cost plan on this project with monthly, itemized breakdown;
• Data on the initiator of the project;
• List of persons responsible for editing and approval of the project with the status of execution;
• List of persons responsible for approval of the project with the status of execution;
• History of making changes in the project.

Passports of projects can be as regional (to include costs of the selected region), and macroregional (to include costs of several regions entering this project). Each passport of the project passes a cycle of editing and the subsequent approval in the company on the basis of the approved matrix of editing and approval for regions, MR, CC, taking into account a functional structure of the company.

On the basis of agreed projects on each region, MR, CC the investment portfolios (IP) form, providing consolidation of information at the level of the region, MR, CC. Investment projects also pass cycles of editing and approval on the basis of the corresponding matrixes of editing and approval. After approval of investment portfolios consolidation of information on all company at the level of the corporate center is provided. The Investment portfolio of the Company built thus goes to approval at shareholder meeting. The approved funding plan of investment projects of the company is result of approval of SP.

System data structure

The data structure of a system supports the distributed regional structure of the company and a hierarchical functional structure of the company.

Support of the distributed regional structure:

• The region - the first step of organizational structure of the company, can consist of several legal entities;
• The macroregion (MR) - contains several regions and can be independent division of the company;
• The Corporate Center (CC) - includes all macroregions and regions, can be independent division of the company.

Support of a hierarchical functional structure of the company:

• Department - the minimum unit functional structures;
• The department - may support several departments;
• The block - may support several departments and/or several blocks.

A system provides following features of access isolation to data and control of making changes:

• Uniquely identifying of the rights on initiation, development, approval and vising of SP in functional and responsible divisions according to the qualifier; differentiation of access rights to the database depending on the level of subordination, a functional vertical and a role of the user;
• Journalizing and documentation of history of making changes (fixation of date, time and actions (the entered data) of the specific user); time supervision of task performance and the number of iterations (for example, at completion), responsible persons.

Features of implementation

• Support of the distributed regional structure of the company and a hierarchical functional structure of the company;
• Possibilities of the analysis and monitorig of financial data in any cuts: under the articles of upravlenchesuy and financial accounting, poproyektno, on regional and organizational divisions of the company;
• The built-in, configured reconciliation procedures of requests for financing, approval and vising of investment projects of applications in electronic form is provided;
• Lack of restrictions for number of the users who are once working with siyetemy.

Results of Implementation

A system allowed to accelerate process of approval of investment projects, consolidations of information and to optimize time of the analysis of investment projects. A system is the analytical tool of employees of regions, macroregions and the corporate center for work with investment projects within the new system of investment planning and control of the company.