Constructing cost control and control system by using Finereport skillfully

First, the application of the background

Enterprises in recent years rapid development, scale is also growing, and information transmission and feedback methods are still relatively backward, with the continuous development of information technology, people began to try to use technical means to improve the environment. Enterprise projects continue to increase, and as a senior manager, through the level of escalation through the way although can understand the operation of the project, but often can not guarantee timeliness, and managers of the energy is limited, it is impossible to go to every day of the project inspection. In this context, if senior management wants to understand the income and expenditure of each project, it can use network technology to realize this requirement, then analyze and control it according to the data.

Second, the tool

Finreport, a relational database, an enterprise management system.

Third, cost control database table

Core business system cost control data storage structure:

Duration	Total project Revenue	Total project Cost	Profit	Post-standard budget
Xx	Xx	Xx	Xx	Xx
Xx	Xx	Xx	Xx	Xx

Iv. Demand Analysis

Real-time monitoring of the income and expenditure of all projects in the enterprise, and the more volatile items will be automatically alerted. The data comes from the data statistics of the business system.

Time dimension analysis based on duration

1: Analyze the total project revenue amount per month

2: Analyze the total project cost amount per month

3: Analysis of total project profit amount per month

4: Analyze the Budget value after the item target for each month

Contrast dimension analysis based on difference value

1: Curve Smoothing Description Project operation is stable

2: A large fluctuation project indicates a problem

3: Alert to management through range of fluctuation values

Five, data analysis

Through the enterprise management system to collect data,

Select an item to inquire about revenue and expenditure operations for each month within the duration of the project, and automatically alarm when fluctuations exceed the threshold.

Vi. Production of statements

① Traditional methods of making

Difficulty 1: Need to develop a program for business unit personnel development difficult

Difficulty 2: Past reports are difficult to make more intuitive charting, not intuitive

Difficulty 3: Data from data set statistics results from complex database table structures

② using Finereport reporting tools

Advantage 1: Support multi-data source joint query, easy to achieve data extraction

Advantage 2: Graphical reports can be automatically generated to help manage visual analysis

Advantage 3: Can embed the current business system, highly realize the integration of the system

Advantage 4: The data can be drilled by passing parameters, and the macro and micro queries are realized.

Seven, the effect shows

① The monthly data sorted by time series of durations, the data can be drilled through hyperlinks to detail the revenue and cost of the query.

② based on the generated cost control dynamic graph, the monthly comparison analysis, the income below the cost of the description of the project losses.

③ analyzes the stability of the project operations based on the generated graphs.

④ based on the set threshold value, combined with the development of third-party software, to achieve the automatic warning function

Constructing cost control and control system by using Finereport skillfully