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