CN103065220A - System and method of decomposing adjustment for group budget data - Google Patents

Abstract

The present invention provides a system for decomposing and adjusting group budget data, including: budget data acquisition unit: used to collect various detailed budget data of each subordinate unit in the group company, and summarize the budget data; decompose the group budget data Parameter setting unit: used to calculate the decomposition parameters of the group budget data based on the collected budget data and summaries; Decompose the trial calculation to obtain the budget data of each subordinate unit according to the group budget data; group budget data decomposition unit: used to decompose the obtained budget data of each subordinate unit to each subordinate unit, and generate the group company and each subordinate unit list of budget data for . The present invention adopts the specific gravity parameter to automatically decompose and distribute the budget data formulated by the group company, which has high efficiency, avoids human calculation errors, and realizes precise control of the budget data.

Description

System and method for decomposing and adjusting group budget data

technical field

The invention relates to the technical field of data processing, in particular to a system and method for decomposing and adjusting group budget data.

Background technique

Budget data is an important reference data for business operations, especially for large group companies. At present, group enterprises mainly use manual compilation for the preparation of budget data. First, the group company summarizes the budget data reported by its subordinate units, and then formulates a total budget data according to the business plan of the enterprise; at this time, if the total budget data reported by the subordinate units does not match the budget data formulated by the group company , you can only ask the subordinate units to reorganize. For example: Group company G has three subordinate units A, B, and C. The budget data reported by each subordinate unit is as follows: the budget data of subordinate unit A is 60, the budget data of subordinate unit B is 70, and the budget data of subordinate unit C is 80 and 210 in aggregated budget data. If the group company G thinks that the total budget data needs to be formulated as 260, at this time, it can only ask the subordinate units to recompile the budget data to achieve the budget data formulated by the group company G, and the group company G cannot carry out according to its own The judgment standard decomposes the budget data and distributes it to each subordinate unit. In group enterprises with numerous subordinate units and budget items, relying on manual preparation of budget data is not only inefficient, but also complicated and frequent adjustments make budget preparation difficult to achieve precise control.

Contents of the invention

One of the objectives of the present invention is to provide a system for decomposing and adjusting group budget data.

Another object of the present invention is to provide a method for decomposing and adjusting group budget data.

In order to achieve the above object, the present invention adopts following technical scheme:

A system for decomposing and adjusting group budget data, including:

Budget data acquisition unit: used to collect the detailed budget data of each subordinate unit in the group company and summarize the budget data;

Decomposition parameter setting unit of group budget data: used to calculate the decomposition parameters of group budget data according to the collected budget data and summary;

Group budget data decomposition and trial calculation unit: it is used to decompose and try to calculate the group budget data formulated by the group company according to the decomposition parameters of the group budget data, and obtain the budget data of each subordinate unit when the group budget data is used;

Group budget data decomposition unit: used to decompose the obtained budget data of each subordinate unit into each subordinate unit, and generate a list of budget data of the group company and each subordinate unit.

As a preferred technical solution of the present invention: the budget data acquisition unit collects various budget data of each subordinate unit in the group company through a wide area network communication interface.

As a preferred technical solution of the present invention: the budget data summary includes: the budget data summary of all subordinate units, and the same detailed budget data summary of all subordinate units;

The decomposition parameters of the group budget data include: the proportion of the summary budget data of the same item in all subordinate units to the summary budget data of all subordinate units; and, the proportion of the detailed budget data in each subordinate unit to all The proportion of summary budget data of the same item in subordinate units;

The group budget data decomposition trial calculation includes: according to the proportion of the summary budget data summary of the same item in all subordinate units to the budget data summary of all subordinate units, the group budget data formulated by the group company is decomposed and trial calculation is carried out, and the calculation is calculated according to In the case of group budget data, the summary of the detailed budget data of the same item in all subordinate units;

According to the proportion of the detailed budget data in each subordinate unit to the summary of the same detailed budget data in all subordinate units, the summary of the same detailed budget data in all subordinate units is calculated according to the group budget data Decompose the trial calculation and calculate the detailed budget data of each subordinate unit when the group budget data is used.

As a preferred technical solution of the present invention: the budget data summary includes: the budget data summary of all subordinate units, the summary of each detailed budget data in each subordinate unit;

The decomposition parameters of the group budget data include: the proportion of the summary budget data of each subordinate unit to the summary budget data of all subordinate units; and the proportion of the detailed budget data of the subordinate unit to the subordinate The proportion of the summary of each detailed budget data in the unit;

The group budget data decomposition trial calculation includes: according to the proportion of the summary budget data of each subordinate unit in the summary budget data of all subordinate units, the group budget data formulated by the group company is decomposed and trial calculation is carried out to calculate According to the group budget data, the summary of each detailed budget data in the subordinate unit;

According to the proportion of the detailed budget data in the subordinate unit to the summary of the detailed budget data in the subordinate unit, when the group budget data is used, the summary of the detailed budget data in the subordinate unit is decomposed and calculated, and calculated When exporting the group budget data, the detailed budget data of the subordinate unit.

A method for decomposing and adjusting group budget data, comprising the following steps:

Collect budget data: collect detailed budget data of each subordinate unit in the group company, and summarize the budget data;

Set the decomposition parameters of the group budget data: calculate the decomposition parameters of the group budget data according to the collected budget data and summary;

Decomposition trial calculation of group budget data: Substituting the group budget data formulated by the group company, decomposing and trial calculation of the group budget data according to the decomposition parameters of the set group budget data, and obtaining the budget data of each subordinate unit according to the group budget data;

Decomposition of group budget data: decompose the obtained budget data of each subordinate unit into each subordinate unit, and generate a list of budget data of the group company and each subordinate unit.

As a preferred technical solution of the present invention: the collection of budget data collects various budget data of each subordinate unit in the group company through the communication interface of the wide area network.

As a preferred technical solution of the present invention: the budget data summary includes: the budget data summary of all subordinate units, and the same detailed budget data summary of all subordinate units;

The decomposition parameters for calculating the group budget data include: calculating the proportion of the summary budget data of the same item in all subordinate units to the summary budget data of all subordinate units; and calculating the detailed budget data of each subordinate unit The proportion of budget data in the summary of the same item of detailed budget data in all subordinate units;

The group budget data decomposition trial calculation includes: first, according to the proportion of the same detailed budget data summary in all subordinate units to the budget data summary of all subordinate units, the group budget data formulated by the group company is decomposed and trial calculation is carried out to calculate According to the group budget data, the summary of the same detailed budget data in all subordinate units;

Then, according to the proportion of the detailed budget data in each subordinate unit to the summary of the same detailed budget data in all subordinate units, the group budget data, the same detailed budget data in all subordinate units Summarize and decompose trial calculations to calculate the detailed budget data of each subordinate unit in accordance with the group budget data.

As a preferred technical solution of the present invention: the budget data summary includes: the budget data summary of all subordinate units, the summary of each detailed budget data in each subordinate unit;

The decomposition parameters for calculating the group budget data include: calculating the proportion of the summary budget data of each subordinate unit to the summary budget data of all subordinate units; and calculating the detailed budget data of the subordinate unit The ratio of the budget data to the summary of each detailed budget data in the subordinate unit;

The group budget data decomposition trial calculation includes: first, according to the proportion of the summary budget data of each subordinate unit in the summary budget data of all subordinate units, the group budget data formulated by the group company is decomposed and trial calculation is performed, and the calculation When exporting the group budget data, the summary of each detailed budget data in the subordinate unit;

Then, according to the proportion of the detailed budget data in the subordinate unit to the summary of the detailed budget data in the subordinate unit, the summary of the detailed budget data in the subordinate unit is decomposed and calculated according to the group budget data , to calculate the detailed budget data of the subordinate unit according to the group budget data.

Compared with the prior art, the present invention adopts the specific gravity parameter to automatically decompose and distribute the budget data formulated by the group company without manual compilation, which not only has high efficiency, but also reduces human adjustments, avoids human calculation errors, and realizes precise control of budget data.

Description of drawings

Fig. 1 is a structural block diagram of the present invention.

Fig. 2 is a flowchart of steps of the present invention.

Detailed ways

Please refer to Figure 1, the system for disaggregating and adjusting group budget data includes:

The budget data collection unit 101 collects various detailed budget data of each subordinate unit 102 in the group company through the wide area network communication interface 103, and summarizes the budget data.

The decomposition parameter setting unit 104 of the group budget data calculates the decomposition parameters of the group budget data according to the collected budget data and summary.

The group budget data decomposition and trial calculation unit 105 is used to decompose and try the group budget data formulated by the group company according to the decomposition parameters of the group budget data, and obtain the budget data of each subordinate unit according to the group budget data.

A group budget data decomposing unit 106, which decomposes the obtained budget data of each subordinate unit into each subordinate unit, and generates a list of budget data of the group company and each subordinate unit.

Wherein, the budget data summary includes: the summary of budget data of all subordinate units and the summary of the same detailed budget data in all subordinate units; or, the summary of budget data includes: the summary of budget data of all subordinate units and the Summary of detailed budget data.

When the budget data is summarized as the summary of budget data of all subordinate units and the summary of the same item of detailed budget data in all subordinate units, the decomposition parameters of the group budget data include: The proportion of the budget data summary of the subordinate unit; and, the proportion of the detailed budget data of each subordinate unit to the summary of the same detailed budget data of all subordinate units.

The group budget data decomposition trial calculation includes: according to the proportion of the summary budget data summary of the same item in all subordinate units to the budget data summary of all subordinate units, the group budget data formulated by the group company is decomposed and trial calculation is carried out, and the calculation is calculated according to In the case of group budget data, it is the summary of the detailed budget data of the same item in all subordinate units.

According to the proportion of the detailed budget data in each subordinate unit to the summary of the same detailed budget data in all subordinate units, the summary of the same detailed budget data in all subordinate units is calculated according to the group budget data Decompose the trial calculation and calculate the detailed budget data of each subordinate unit when the group budget data is used.

When the budget data is summarized as the summary of the budget data of all subordinate units and the summary of each detailed budget data in each subordinate unit, the decomposition parameters of the group budget data include: the summary of each detailed budget data in each subordinate unit The proportion of the summary budget data of all subordinate units; and, the proportion of each detailed budget data of this subordinate unit to the summary of each detailed budget data of this subordinate unit.

The group budget data decomposition trial calculation includes: according to the proportion of the summary budget data of each subordinate unit in the summary budget data of all subordinate units, the group budget data formulated by the group company is decomposed and trial calculation is carried out to calculate According to the group budget data, the summary of each detailed budget data in the subordinate unit.

According to the proportion of the detailed budget data in the subordinate unit to the summary of the detailed budget data in the subordinate unit, when the group budget data is used, the summary of the detailed budget data in the subordinate unit is decomposed and calculated, and calculated When exporting the group budget data, the detailed budget data of the subordinate unit.

Please refer to Figure 2, the method for decomposing and adjusting group budget data based on the above system includes the following steps:

Collect budget data: collect detailed budget data of each subordinate unit in the group company through the WAN communication interface, and summarize the budget data. The budget data summary includes: the budget data summary of all subordinate units, and the same detailed budget data summary of all subordinate units. Or, include: summary of budget data of all subordinate units, summary of each detailed budget data of each subordinate unit.

Set the decomposition parameters of the group budget data: Calculate the decomposition parameters of the group budget data according to the collected budget data and summary.

Decomposition trial calculation of group budget data: substituting the group budget data formulated by the group company, and decomposing the group budget data formulated by the group company according to the decomposition parameters of the set group budget data, to obtain the group budget data, each subordinate unit budget data.

Decomposition of group budget data: decompose the obtained budget data of each subordinate unit into each subordinate unit, and generate a list of budget data of the group company and each subordinate unit.

Wherein, when the budget data summary is the summary of the budget data of all subordinate units and the summary of the detailed budget data of the same item in all subordinate units, the decomposition parameters for calculating the group budget data include: calculating the same item in all subordinate units The proportion of the detailed budget data summary in the budget data summary of all subordinate units; and, calculate the proportion of the detailed budget data in each subordinate unit to the same detailed budget data summary in all subordinate units; the two The multiplicity value is the decomposition parameter of the group budget data.

The group budget data decomposition trial calculation includes: first, according to the proportion of the same detailed budget data summary in all subordinate units to the budget data summary of all subordinate units, the group budget data formulated by the group company is decomposed and trial calculation is carried out to calculate When the group budget data is used, it is the summary of the detailed budget data of the same item in all subordinate units.

Then, according to the proportion of the detailed budget data in each subordinate unit to the summary of the same detailed budget data in all subordinate units, the group budget data, the same detailed budget data in all subordinate units Summarize and decompose trial calculations to calculate the detailed budget data of each subordinate unit in accordance with the group budget data.

Alternatively, the summary of the budget data is the summary of the budget data of all subordinate units. When summarizing the detailed budget data in each subordinate unit, the decomposing parameters for calculating the group budget data include: calculating the budget data of each subordinate unit. Calculate the proportion of the summary of detailed budget data of all subordinate units in the summary of budget data of all subordinate units; The value is the decomposition parameter of the group budget data.

The group budget data decomposition trial calculation includes: first, according to the proportion of the summary budget data of each subordinate unit in the summary budget data of all subordinate units, the group budget data formulated by the group company is decomposed and trial calculation is performed, and the calculation When exporting the group budget data, the summary of each detailed budget data in the subordinate unit;

Then, according to the proportion of the detailed budget data in the subordinate unit to the summary of the detailed budget data in the subordinate unit, the summary of the detailed budget data in the subordinate unit is decomposed and calculated according to the group budget data , to calculate the detailed budget data of the subordinate unit according to the group budget data.

Embodiment one:

Group company A has subordinate units A1, A2, and A3. The budget data collected from the three subordinate units are as follows:

The budget figures for unit A1 are as follows:

The budget data for unit A2 is as follows:

The budget data for A3 units are as follows:

Summarize the budget data of all subordinate units and the detailed budget data of the same item in all subordinate units (summary of budgetary product income of A1, A2, A3 subordinate units; summary of unit budget service income of A1, A2, A3 subordinate units) Summary, as follows:

Unit Budget Product Revenue Unit Budget Service Income total 306 268 574

Calculate the proportions of unit budget product income budget data summary and unit budget service income budget data summary to the budget data summary of A1, A2, A3 subordinate units respectively, as follows:

Proportion of product revenue per unit budget Proportion of service revenue per unit budget 306/574 268/574

Then, calculate the respective proportions of the unit budget product revenue budget and unit budget service revenue in the unit budget product revenue budget data summary and unit budget service revenue budget data summary of the subordinate units A1, A2 and A3, as follows:

The proportion of each unit budget product income in the unit budget product income and the proportion of each unit budget service income in the unit budget service income budget data summary in the unit is as follows:

budget item Unit Budget Product Revenue Unit Budget Service Income

Q1 product 30/306 43/268 Q2 products 10/306 15/268 Q3 products 8/306 10/268 Q4 products 12/306 18/268

A2 The proportion of each unit budget product income in the unit budget product income budget data summary and the unit budget service income in the unit budget service income budget data summary are as follows:

budget item Unit Budget Product Revenue Unit Budget Service Income Q1 product 63/306 43/268 Q2 products 25/306 12/268 Q3 products 18/306 17/268 Q4 products 20/306 14/268

A3 The proportion of each unit budget product income in the unit budget product income budget data summary and the unit budget service income in the unit budget service income budget data summary are as follows:

budget item Unit Budget Product Revenue Unit Budget Service Income Q1 product 60/306 48/268 Q2 products 15/306 20/268

Q3 products 22/306 17/268 Q4 products 23/306 11/268

After evaluation, group company A believes that the total budgeted income of the group needs to reach 650, which is inconsistent with the total budgeted income of 574 formulated by subordinate units A1, A2, and A3. It needs to distribute the total budgeted income of 650 to each subordinate unit A1, A2 , A3's budget table, at this time, substitute the total budgeted income of the group of 650; first, the total budgeted income of the group of 650 is based on the sum of unit budget product income budget data and unit budget service income budget data summary accounted for by A1, A2, A3 The breakdown of the proportion of budget data summary of subordinate units is as follows:

In the decomposition process in this specific embodiment, the unit digit of the numerical value is decomposed according to the rounding rule, which can be set according to the actual use process.

Then, according to the respective proportions of unit budget product revenue budget and unit budget service revenue in the unit budget product revenue budget data summary and unit budget service revenue budget data summary in the subordinate units of A1, A2 and A3, the unit budget of the group budget The total income of products and the total income of unit budget services of the group budget are decomposed into the unit budget table:

The budget data of unit A1 in group budget are as follows:

budget item Budget product revenue Budget service income Q1 product 34 49 Q2 products 11 17

Q3 products 9 11 Q4 products 14 20

According to the group budget, the budget data of unit A2 are as follows:

budget item Budget product revenue Budget service income Q1 product 71 49 Q2 products 28 14 Q3 products 20 19 Q4 products twenty three 16

The budget data of unit A3 in group budget are as follows:

budget item Budget product revenue Budget service income Q1 product 68 54 Q2 products 17 twenty three Q3 products 25 19 Q4 products 26 12

Finally, decompose the budget data of each subordinate unit obtained according to the group budget data decomposition trial calculation to each subordinate unit, and generate a list of budget data of the group company and each subordinate unit for users to query or adjust.

Embodiment two

The differences between this embodiment and the first embodiment above are:

The budget data summary is the summary of the budget data of all subordinate units and the summary of each detailed budget data in each subordinate unit, as shown in the following table:

Calculate the proportion of the summaries of detailed budget data in subordinate units A1, A2 and A3 to the summary budget data of all subordinate units, as shown in the following table:

unit proportion A1 subordinate unit 146/574 A2 subordinate units 212/574 A3 subordinate unit 216/574

Then, calculate the proportion of each detailed budget data in each subordinate unit to the summary of each detailed budget data in the subordinate unit, as shown in the following table:

A1 unit:

budget item Proportion of product revenue Proportion of Service Income Q1 product 30/146 43/146 Q2 products 10/146 15/146 Q3 products 8/146 10/146 Q4 products 12/146 18/146

A2 unit:

budget item Proportion of product revenue Proportion of Service Income Q1 product 63/212 43/212 Q2 products 25/212 12/212 Q3 products 18/212 17/212 Q4 products 20/212 14/212

A3 unit:

budget item Proportion of product revenue Proportion of Service Income Q1 product 60/216 48/216 Q2 products 15/216 20/216 Q3 products 22/216 17/216 Q4 products 23/216 11/216

At this time, substitute the total budget revenue of the 650 group; first, the total budget revenue of the 650 group is based on the proportion of the summary budget data of the sub-units A1, A2, and A3 to the summary budget data of all sub-units, The breakdown is as follows:

unit The total budget of each unit of the group budget A1 subordinate unit 165 A2 subordinate units 240 A3 subordinate unit 245

Then, according to the proportion of each detailed budget data in the subordinate units of A1, A2, and A3 to the summary of each detailed budget data in the subordinate units, the total budget of each subordinate unit is decomposed into units according to the group budget data The detailed budgets are as follows:

The budget data of unit A1 in group budget are as follows:

budget item Proportion of product revenue Proportion of Service Income Q1 product 34 49 Q2 products 11 17 Q3 products 9 11 Q4 products 14 20

According to the group budget, the budget data of unit A2 are as follows:

budget item Proportion of product revenue Proportion of Service Income Q1 product 71 49

Q2 products 28 14 Q3 products 20 19 Q4 products twenty three 16

The budget data of unit A3 in group budget are as follows:

budget item Proportion of product revenue Proportion of Service Income Q1 product 68 54 Q2 products 17 twenty three Q3 products 25 19 Q4 products 26 12

Finally, decompose the budget data of each subordinate unit obtained according to the group budget data decomposition trial calculation to each subordinate unit, and generate a list of budget data of the group company and each subordinate unit for users to query or adjust.

The above descriptions are only preferred embodiments of the present invention, and are not intended to limit the implementation scope of the present invention; all equivalent changes and modifications made according to the present invention are covered by the scope of the claims of the present invention.

Claims (8)

1. A system for decomposing and adjusting group budget data, characterized in that it includes: Budget data acquisition unit: used to collect the detailed budget data of each subordinate unit in the group company and summarize the budget data; Decomposition parameter setting unit of group budget data: used to calculate the decomposition parameters of group budget data according to the collected budget data and summary; Group budget data decomposition and trial calculation unit: it is used to decompose and try to calculate the group budget data formulated by the group company according to the decomposition parameters of the group budget data, and obtain the budget data of each subordinate unit when the group budget data is used; Group budget data decomposition unit: used to decompose the obtained budget data of each subordinate unit into each subordinate unit, and generate a list of budget data of the group company and each subordinate unit. 2. The system for decomposing and adjusting group budget data according to claim 1, characterized in that: the budget data collection unit collects various budget data of each subordinate unit in the group company through a wide area network communication interface. 3. The system for decomposing and adjusting group budget data according to claim 1, characterized in that: The budget data summary includes: the budget data summary of all subordinate units, and the same detailed budget data summary of all subordinate units; The decomposition parameters of the group budget data include: the proportion of the summary budget data of the same item in all subordinate units to the summary budget data of all subordinate units; and the proportion of the detailed budget data in each subordinate unit to the total The proportion of summary budget data of the same item in subordinate units; The group budget data decomposition trial calculation includes: according to the proportion of the summary budget data summary of the same item in all subordinate units to the budget data summary of all subordinate units, the group budget data formulated by the group company is decomposed and trial calculation is carried out, and the calculation is calculated according to In the case of group budget data, the summary of the detailed budget data of the same item in all subordinate units; According to the proportion of the detailed budget data in each subordinate unit to the summary of the same detailed budget data in all subordinate units, the summary of the same detailed budget data in all subordinate units is calculated according to the group budget data Decompose the trial calculation and calculate the detailed budget data of each subordinate unit when the group budget data is used. 4. The system for decomposing and adjusting group budget data according to claim 1, characterized in that: The budget data summary includes: the budget data summary of all subordinate units, and the summary of each detailed budget data in each subordinate unit; The decomposition parameters of the group budget data include: the proportion of the summary budget data of each subordinate unit to the summary budget data of all subordinate units; and the proportion of the detailed budget data of the subordinate unit to the subordinate The proportion of the summary of each detailed budget data in the unit; The group budget data decomposition trial calculation includes: according to the proportion of the summary budget data of each subordinate unit in the summary budget data of all subordinate units, the group budget data formulated by the group company is decomposed and trial calculation is carried out to calculate According to the group budget data, the summary of each detailed budget data in the subordinate unit; According to the proportion of the detailed budget data in the subordinate unit to the summary of the detailed budget data in the subordinate unit, when the group budget data is used, the summary of the detailed budget data in the subordinate unit is decomposed and calculated, and calculated When exporting the group budget data, the detailed budget data of the subordinate unit. 5. A method for decomposing and adjusting group budget data, comprising the following steps: Collect budget data: collect detailed budget data of each subordinate unit in the group company, and summarize the budget data; Set the decomposition parameters of the group budget data: calculate the decomposition parameters of the group budget data according to the collected budget data and summary; Decomposition trial calculation of group budget data: Substituting the group budget data formulated by the group company, decomposing and trial calculation of the group budget data according to the decomposition parameters of the set group budget data, and obtaining the budget data of each subordinate unit according to the group budget data; Decomposition of group budget data: decompose the obtained budget data of each subordinate unit into each subordinate unit, and generate a list of budget data of the group company and each subordinate unit. 6. The method for decomposing and adjusting group budget data according to claim 1, characterized in that: the collected budget data collects various budget data of each subordinate unit in the group company through a wide area network communication interface. 7. The method for decomposing and adjusting group budget data according to claim 1, characterized in that: The budget data summary includes: the budget data summary of all subordinate units, and the same detailed budget data summary of all subordinate units; The decomposition parameters for calculating the group budget data include: calculating the proportion of the summary budget data of the same item in all subordinate units to the summary budget data of all subordinate units; and calculating the detailed budget data of each subordinate unit The proportion of budget data in the summary of the same item of detailed budget data in all subordinate units; The group budget data decomposition trial calculation includes: first, according to the proportion of the same detailed budget data summary in all subordinate units to the budget data summary of all subordinate units, the group budget data formulated by the group company is decomposed and trial calculation is carried out to calculate According to the group budget data, the summary of the same detailed budget data in all subordinate units; Then, according to the proportion of the detailed budget data in each subordinate unit to the summary of the same detailed budget data in all subordinate units, the group budget data, the same detailed budget data in all subordinate units Summarize and decompose trial calculations to calculate the detailed budget data of each subordinate unit in accordance with the group budget data. 8. The method for decomposing and adjusting group budget data according to claim 1, characterized in that: The budget data summary includes: the budget data summary of all subordinate units, and the summary of each detailed budget data in each subordinate unit; The decomposing parameters for calculating the group budget data include: calculating the proportion of the summary budget data of each subordinate unit to the summary budget data of all subordinate units; and calculating the detailed budget data of the subordinate unit The ratio of the budget data to the summary of each detailed budget data in the subordinate unit; The group budget data decomposition trial calculation includes: first, according to the proportion of the summary budget data of each subordinate unit in the summary budget data of all subordinate units, the group budget data formulated by the group company is decomposed and trial calculation is performed, and the calculation When exporting the group budget data, the summary of each detailed budget data in the subordinate unit; Then, according to the proportion of the detailed budget data in the subordinate unit to the summary of the detailed budget data in the subordinate unit, the summary of the detailed budget data in the subordinate unit is decomposed and calculated according to the group budget data , to calculate the detailed budget data of the subordinate unit according to the group budget data.

Images