Summary of the invention
A wherein purpose of the present invention is to provide a kind of system that group's budget data is decomposed adjustment.
Another object of the present invention is to provide a kind of method of group's budget data being decomposed adjustment.
In order to achieve the above object, the present invention has adopted following technical scheme:
A kind of group's budget data is decomposed the system of adjustment, comprising:
Budget data collecting unit: be used for every detail budgeting data of each subordinate unit of collection company, and budget data is gathered;
The resolution parameter setting unit of group's budget data: be used for according to the budget data that collects and gather, calculate the resolution parameter of group's budget data;
Group's budget data decomposes the tentative calculation unit: is used for according to the resolution parameter of group's budget data group's budget data that group company formulates being decomposed tentative calculation, and when drawing according to group's budget data, the budget data of each subordinate unit;
Group's budget data resolving cell: the budget data for each subordinate unit that will draw decomposes to each subordinate unit, generates the budget data tabulation of group company and each subordinate unit.
As the preferred technical solution of the present invention: described budget data collecting unit is by every budget data of each subordinate unit in the wide area network communication interface collection company.
As the preferred technical solution of the present invention: described budget data gathers and comprises: the budget data of all subordinate units gathers, and same detail budgeting data in all subordinate units gather;
The resolution parameter of described group budget data comprises: the proportion that the budget data that same detail budgeting data in all subordinate units gather shared all subordinate units gathers; And, same the proportion that the detail budgeting data gather in shared these all subordinate units of these detail budgeting data in each subordinate unit;
Described group budget data decomposes tentative calculation and comprises: the proportion that the budget data that gathers shared all subordinate units according to same detail budgeting data in all subordinate units gathers, group's budget data that group company is formulated decomposes tentative calculation, when calculating according to group's budget data, the gathering of same the detail budgeting data in these all subordinate units;
According to same the proportion that the detail budgeting data gather in shared these all subordinate units of these detail budgeting data in each subordinate unit, to according to group's budget data the time, gathering of same detail budgeting data in these all subordinate units decomposed tentative calculation, when calculating according to group's budget data, these detail budgeting data in each subordinate unit.
As the preferred technical solution of the present invention: described budget data gathers and comprises: the budget data of all subordinate units gathers, and every detail budgeting data gathers in each subordinate unit;
The resolution parameter of described group budget data comprises: the proportion that the budget data that gathers shared all subordinate units of every detail budgeting data gathers in each subordinate unit; And, the proportion that gathers of every detail budgeting data in shared this subordinate unit of every detail budgeting data in this subordinate unit;
Described group budget data decomposes tentative calculation and comprises: the proportion that gathers according to the budget data that gathers shared all subordinate units of every detail budgeting data in each subordinate unit, group's budget data that group company is formulated decomposes tentative calculation, when calculating according to group's budget data, every detail budgeting data gathers in this subordinate unit;
The proportion that gathers according to every detail budgeting data in shared this subordinate unit of every detail budgeting data in this subordinate unit, to according to group's budget data the time, gathering of every detail budgeting data decomposed tentative calculation in this subordinate unit, when calculating according to group's budget data, every detail budgeting data in this subordinate unit.
A kind of group's budget data is decomposed the method for adjustment, may further comprise the steps:
Gather budget data: every detail budgeting data of each subordinate unit in the collection company, and budget data gathered;
The resolution parameter of group's budget data is set: according to the budget data that collects and gather, calculate the resolution parameter of group's budget data;
The group budget data decomposes tentative calculation: group's budget data that substitution group company formulates, according to the resolution parameter of the group's budget data that arranges group's budget data is decomposed tentative calculation, and when drawing according to group's budget data, the budget data of each subordinate unit;
Group's budget data decomposes: the budget data of each subordinate unit that will draw decomposes to each subordinate unit, generates the budget data tabulation of group company and each subordinate unit.
As the preferred technical solution of the present invention: described collection budget data is by every budget data of each subordinate unit in the wide area network communication interface collection company.
As the preferred technical solution of the present invention: described budget data gathers and comprises: the budget data of all subordinate units gathers, and same detail budgeting data in all subordinate units gather;
The described resolution parameter that calculates group's budget data comprises: calculate the proportion that budget data that same the detail budgeting data in all subordinate units gather shared all subordinate units gathers; And, calculate same the proportion that the detail budgeting data gather in shared these all subordinate units of these detail budgeting data in each subordinate unit;
Described group budget data decomposes tentative calculation and comprises: the proportion that the budget data that at first gathers shared all subordinate units according to same detail budgeting data in all subordinate units gathers, group's budget data that group company is formulated decomposes tentative calculation, when calculating according to group's budget data, the gathering of same the detail budgeting data in these all subordinate units;
Then, according to same the proportion that the detail budgeting data gather in shared these all subordinate units of these detail budgeting data in each subordinate unit, to according to group's budget data the time, gathering of same detail budgeting data in these all subordinate units decomposed tentative calculation, when calculating according to group's budget data, these detail budgeting data in each subordinate unit.
As the preferred technical solution of the present invention: described budget data gathers and comprises: the budget data of all subordinate units gathers, and every detail budgeting data gathers in each subordinate unit;
The described resolution parameter that calculates group's budget data comprises: calculate the proportion that the budget data that gathers shared all subordinate units of every detail budgeting data gathers in each subordinate unit; And, calculate the proportion that gathers of every detail budgeting data in shared this subordinate unit of every detail budgeting data in this subordinate unit;
Described group budget data decomposes tentative calculation and comprises: the proportion that at first gathers according to the budget data that gathers shared all subordinate units of every detail budgeting data in each subordinate unit, group's budget data that group company is formulated decomposes tentative calculation, when calculating according to group's budget data, every detail budgeting data gathers in this subordinate unit;
Then, the proportion that gathers according to every detail budgeting data in shared this subordinate unit of every detail budgeting data in this subordinate unit, to according to group's budget data the time, gathering of every detail budgeting data decomposed tentative calculation in this subordinate unit, when calculating according to group's budget data, every detail budgeting data in this subordinate unit.
Compared with prior art, the budget data that the present invention adopts proportion parameter automatic classifying to distribute group company to formulate does not need artificial establishment, and not only efficient is high, and reduces artificial the adjustment, avoids occurring the people and is miscount, realizes the accurate control of budget data.
Embodiment
See also Fig. 1, the system that group's budget data is decomposed adjustment comprises:
Budget data collecting unit 101, it passes through every detail budgeting data of each subordinate unit 102 in wide area network communication interface 103 collection company, and budget data is gathered.
The resolution parameter setting unit 104 of group's budget data, it is according to the budget data that collects and gather, and calculates the resolution parameter of group's budget data.
Group's budget data decomposes tentative calculation unit 105, and its resolution parameter according to group's budget data decomposes tentative calculation to group's budget data that group company formulates, when drawing according to group's budget data, and the budget data of each subordinate unit.
Group's budget data resolving cell 106, the budget data of each subordinate unit that it will draw decomposes to each subordinate unit, generates the budget data tabulation of group company and each subordinate unit.
Wherein, described budget data gathers and comprises: the budget data of all subordinate units gather and all subordinate units in same detail budgeting data gather; Perhaps, this budget data gathers and comprises: the budget data of all subordinate units gather and each subordinate unit in the gathering of every detail budgeting data.
Budget data gather that budget data for all subordinate units gathers and all subordinate units in same detail budgeting data when gathering, the resolution parameter of described group budget data comprises: the proportion that the budget data that same detail budgeting data in all subordinate units gather shared all subordinate units gathers; And, same the proportion that the detail budgeting data gather in shared these all subordinate units of these detail budgeting data in each subordinate unit.
Described group budget data decomposes tentative calculation and comprises: the proportion that the budget data that gathers shared all subordinate units according to same detail budgeting data in all subordinate units gathers, group's budget data that group company is formulated decomposes tentative calculation, when calculating according to group's budget data, the gathering of same the detail budgeting data in these all subordinate units.
According to same the proportion that the detail budgeting data gather in shared these all subordinate units of these detail budgeting data in each subordinate unit, to according to group's budget data the time, gathering of same detail budgeting data in these all subordinate units decomposed tentative calculation, when calculating according to group's budget data, these detail budgeting data in each subordinate unit.
Budget data gather that budget data for all subordinate units gathers and each subordinate unit in during the gathering of every detail budgeting data, the resolution parameter of described group budget data comprises: the proportion that the budget data that gathers shared all subordinate units of every detail budgeting data gathers in each subordinate unit; And, the proportion that gathers of every detail budgeting data in shared this subordinate unit of every detail budgeting data in this subordinate unit.
Described group budget data decomposes tentative calculation and comprises: the proportion that gathers according to the budget data that gathers shared all subordinate units of every detail budgeting data in each subordinate unit, group's budget data that group company is formulated decomposes tentative calculation, when calculating according to group's budget data, every detail budgeting data gathers in this subordinate unit.
The proportion that gathers according to every detail budgeting data in shared this subordinate unit of every detail budgeting data in this subordinate unit, to according to group's budget data the time, gathering of every detail budgeting data decomposed tentative calculation in this subordinate unit, when calculating according to group's budget data, every detail budgeting data in this subordinate unit.
See also Fig. 2, based on said system group's budget data decomposed the method for adjustment, may further comprise the steps:
Gather budget data:, and budget data gathered by every detail budgeting data of each subordinate unit in the wide area network communication interface collection company.Described budget data gathers and comprises: the budget data of all subordinate units gathers, and same detail budgeting data in all subordinate units gather.Perhaps, comprising: the budget data of all subordinate units gathers, and every detail budgeting data gathers in each subordinate unit.
The resolution parameter of group's budget data is set: according to the budget data that collects and gather, calculate the resolution parameter of group's budget data.
Group's budget data decomposes tentative calculation: group's budget data that substitution group company formulates, resolution parameter according to the group's budget data that arranges decomposes tentative calculation to group's budget data that group company formulates, when drawing according to group's budget data, the budget data of each subordinate unit.
Group's budget data decomposes: the budget data of each subordinate unit that will draw decomposes to each subordinate unit, generates the budget data tabulation of group company and each subordinate unit.
Wherein, described budget data gather budget data for all subordinate units gather with all subordinate units in same detail budgeting data when gathering, the described resolution parameter that calculates group's budget data comprises: calculate the proportion that budget data that same detail budgeting data in all subordinate units gather shared all subordinate units gathers; And, calculate same the proportion that the detail budgeting data gather in shared these all subordinate units of these detail budgeting data in each subordinate unit; This double numerical value is the resolution parameter of group's budget data.
Described group budget data decomposes tentative calculation and comprises: the proportion that the budget data that at first gathers shared all subordinate units according to same detail budgeting data in all subordinate units gathers, group's budget data that group company is formulated decomposes tentative calculation, when calculating according to group's budget data, the gathering of same the detail budgeting data in these all subordinate units.
Then, according to same the proportion that the detail budgeting data gather in shared these all subordinate units of these detail budgeting data in each subordinate unit, to according to group's budget data the time, gathering of same detail budgeting data in these all subordinate units decomposed tentative calculation, when calculating according to group's budget data, these detail budgeting data in each subordinate unit.
Perhaps, the budget data that described budget data gathers for all subordinate units gathers, during the gathering of every detail budgeting data, the described resolution parameter that calculates group's budget data comprises: calculate the proportion that the budget data that gathers shared all subordinate units of every detail budgeting data gathers in each subordinate unit in each subordinate unit; And, calculate the proportion that gathers of every detail budgeting data in shared this subordinate unit of every detail budgeting data in this subordinate unit; This proportion numerical value is the resolution parameter of group's budget data.
Described group budget data decomposes tentative calculation and comprises: the proportion that at first gathers according to the budget data that gathers shared all subordinate units of every detail budgeting data in each subordinate unit, group's budget data that group company is formulated decomposes tentative calculation, when calculating according to group's budget data, every detail budgeting data gathers in this subordinate unit;
Then, the proportion that gathers according to every detail budgeting data in shared this subordinate unit of every detail budgeting data in this subordinate unit, to according to group's budget data the time, gathering of every detail budgeting data decomposed tentative calculation in this subordinate unit, when calculating according to group's budget data, every detail budgeting data in this subordinate unit.
Embodiment one:
The A of group company has the A1 of subordinate unit, A2, A3, the budget data such as the following table that gather from three subordinate units:
The budget data of A1 unit is as follows:
The budget data of A2 unit is as follows:
The budget data of A3 unit is as follows:
The budget data of all subordinate units is gathered and (the budget product income of A1, A2, A3 subordinate unit gathers to same detail budgeting data in all subordinate units; The unit budget service income of A1, A2, A3 subordinate unit gathers) gather, as follows:
Unit budget product income |
The unit budget service income |
Add up to |
306 |
268 |
574 |
Calculate respectively unit budget product revenue estimates data and gather with unit budget service income budget data and gather the proportion that the budget data of shared A1, A2, A3 subordinate unit gathers, as follows:
Unit budget product income proportion |
Unit budget service income proportion |
306/574 |
268/574 |
Then, calculate unit budget product revenue estimates separately in A1, A2, the A3 subordinate unit, unit budget service income respectively at the proportion that unit budget product revenue estimates data gather, unit budget service income budget data gathers, as follows:
The proportion that the proportion that every unit budget product income in the A1 unit gathers in unit budget product revenue estimates data and every unit budget service income gather at unit budget service income budget data, as follows:
Budget items |
Unit budget product income |
The unit budget service income |
The Q1 product |
30/306 |
43/268 |
The Q2 product |
10/306 |
15/268 |
The Q3 product |
8/306 |
10/268 |
The Q4 product |
12/306 |
18/268 |
The proportion that the proportion that every unit budget product income in the A2 unit gathers in unit budget product revenue estimates data and every unit budget service income gather at unit budget service income budget data, as follows:
Budget items |
Unit budget product income |
The unit budget service income |
The Q1 product |
63/306 |
43/268 |
The Q2 product |
25/306 |
12/268 |
The Q3 product |
18/306 |
17/268 |
The Q4 product |
20/306 |
14/268 |
The proportion that the proportion that every unit budget product income in the A3 unit gathers in unit budget product revenue estimates data and every unit budget service income gather at unit budget service income budget data, as follows:
Budget items |
Unit budget product income |
The unit budget service income |
The Q1 product |
60/306 |
48/268 |
The Q2 product |
15/306 |
20/268 |
The Q3 product |
22/306 |
17/268 |
The Q4 product |
23/306 |
11/268 |
The A of group company is thinking that the budget gross income of group need reach 650 after assessment, inconsistent with the budget gross income 574 that the A1 of subordinate unit, A2, A3 formulate, the budget gross income of 650 group need to be assigned on the budget table of each A1 of subordinate unit, A2, A3, this moment is with the budget gross income substitution of 650 group; At first, group's budget gross income of 650 gathers according to unit budget product revenue estimates data and gathers the proportion that the budget data of shared A1, A2, A3 subordinate unit gathers with unit budget service income budget data and decompose as follows:
Decomposable process in this specific embodiments, decompose according to the rule that rounds up a numerical value position, in the actual use procedure, can set as required.
Then, according to the unit budget product revenue estimates separately in A1, A2, the A3 subordinate unit, unit budget service income respectively at unit budget product revenue estimates data gather, unit budget service income budget data gathers proportion, with the unit budget product gross income of group's budget, the unit budget service gross income of group's budget, decompose to the unit budget table:
The budget data of A1 unit during by group's budget, as follows:
Budget items |
Budget product income |
The budget service income |
The Q1 product |
34 |
49 |
The Q2 product |
11 |
17 |
The Q3 product |
9 |
11 |
The Q4 product |
14 |
20 |
The budget data of A2 unit during by group's budget, as follows:
Budget items |
Budget product income |
The budget service income |
The Q1 product |
71 |
49 |
The Q2 product |
28 |
14 |
The Q3 product |
20 |
19 |
The Q4 product |
23 |
16 |
The budget data of A3 unit during by group's budget, as follows:
Budget items |
Budget product income |
The budget service income |
The Q1 product |
68 |
54 |
The Q2 product |
17 |
23 |
The Q3 product |
25 |
19 |
The Q4 product |
26 |
12 |
At last, will decompose to each subordinate unit according to the budget data that the group budget data decomposes each subordinate unit that tentative calculation draws, generate the budget data tabulation of group company and each subordinate unit, for user's inquiry or adjust.
Embodiment two
The difference of present embodiment and above-described embodiment one is:
Described budget data gather that budget data for all subordinate units gathers and each subordinate unit in the gathering of every detail budgeting data, such as following table:
Calculate the proportion that the budget data that gathers shared all subordinate units of every detail budgeting data in A1, A2, the A3 subordinate unit gathers, such as following table:
Unit |
Proportion |
A1 subordinate unit |
146/574 |
A2 subordinate unit |
212/574 |
A3 subordinate unit |
216/574 |
Then, calculate the proportion that gathers of every detail budgeting data in shared this subordinate unit of every detail budgeting data in each subordinate unit, such as following table:
A1 unit:
Budget items |
Product income proportion |
Service income proportion |
The Q1 product |
30/146 |
43/146 |
The Q2 product |
10/146 |
15/146 |
The Q3 product |
8/146 |
10/146 |
The Q4 product |
12/146 |
18/146 |
A2 unit:
Budget items |
Product income proportion |
Service income proportion |
The Q1 product |
63/212 |
43/212 |
The Q2 product |
25/212 |
12/212 |
The Q3 product |
18/212 |
17/212 |
The Q4 product |
20/212 |
14/212 |
A3 unit:
Budget items |
Product income proportion |
Service income proportion |
The Q1 product |
60/216 |
48/216 |
The Q2 product |
15/216 |
20/216 |
The Q3 product |
22/216 |
17/216 |
The Q4 product |
23/216 |
11/216 |
At this moment, with the budget gross income substitution of 650 group; At first, the budget gross income of 650 group is decomposed as follows according to the proportion that the budget data that gathers shared all subordinate units of every detail budgeting data in A1, A2, the A3 subordinate unit gathers:
Unit |
The constituent parts master budget of group's budget |
A1 subordinate unit |
165 |
A2 subordinate unit |
240 |
A3 subordinate unit |
245 |
Then, according to the proportion that gathers of every detail budgeting data in shared this subordinate unit of every detail budgeting data in A1, A2, the A3 subordinate unit, in the time of will be by group's budget data, the master budget of each subordinate unit, every detail budgeting of the unit of decomposing to, as follows:
The budget data of A1 unit during by group's budget, as follows:
Budget items |
Product income proportion |
Service income proportion |
The Q1 product |
34 |
49 |
The Q2 product |
11 |
17 |
The Q3 product |
9 |
11 |
The Q4 product |
14 |
20 |
The budget data of A2 unit during by group's budget, as follows:
Budget items |
Product income proportion |
Service income proportion |
The Q1 product |
71 |
49 |
The Q2 product |
28 |
14 |
The Q3 product |
20 |
19 |
The Q4 product |
23 |
16 |
The budget data of A3 unit during by group's budget, as follows:
Budget items |
Product income proportion |
Service income proportion |
The Q1 product |
68 |
54 |
The Q2 product |
17 |
23 |
The Q3 product |
25 |
19 |
The Q4 product |
26 |
12 |
At last, will decompose to each subordinate unit according to the budget data that the group budget data decomposes each subordinate unit that tentative calculation draws, generate the budget data tabulation of group company and each subordinate unit, for user's inquiry or adjust.
The above is preferred embodiment of the present invention only, is not to limit practical range of the present invention; Every equivalence of doing according to the present invention changes and revises, and is all covered by the scope of claims of the present invention.