Summary of the invention
The power grid enterprises' power selling income budgeting system and the method that the purpose of this invention is to provide the accuracy of a kind of efficient that can improve budget compilation and data.
To achieve these goals, the present invention takes following technical solution:
A kind of power grid enterprises power selling income budgeting system comprises:
Data processing unit is used for adopting budget model to calculate the budget compilation data and the budget compilation data are stored in data storage cell according to the historical data that is stored in data storage cell; The data query unit is used for inquiring about the budget compilation data by the human-computer interaction device.
Preferably, described data processing unit comprises that parameter arranges submodule, data read and sub module stored and data budget model submodule; Described parameter arranges the parameter that submodule is used for arranging by the human-computer interaction device power selling income budget; Described data read with sub module stored and are used for obtaining historical data and described budget compilation data being stored in data storage cell from data storage cell; The pre-operator module of described data is used for according to parameter the parameter of submodule setting and the historical data that the data reading submodule is obtained being set, and adopts the zero-base approach budget model to calculate and budget year estimates sum.
Preferably, described data processing unit also comprises data adjustment decomposition submodule; The sum of estimating in budget year that described data adjustment decomposition submodule is used for that data budget submodule is calculated is adjusted, and will estimate that sum decomposes on each detailed according to the proportion that each detail item accounts for total value budget year.
Preferably, the pre-operator module of described data comprises a not generation month piece of data computation module, annual data computation module and zero-base approach budget model; The described month piece of data computation module that occurs came calculating book year that the predicted data in month does not occur for the parameter that the actual generation data incorporating parametric according to the same period upper one year arranges the submodule setting; Described annual data computation module calculates expectation in current year sum according to the historical data of actual generation in the current year and the predicted data that month does not occur the current year that calculates; Described zero-base approach budget model is according to estimating that the calculation of parameter that total incorporating parametric arranges the submodule setting goes out budget year to estimate sum the current year.
A kind of power grid enterprises power selling income budgetary technique may further comprise the steps:
Be used for adopting budget model to calculate the budget compilation data according to the historical data that is stored in data storage cell, and the budget compilation data be stored in the data processing step of data storage cell;
For the data query step of the budget compilation data of working out being inquired about by the human-computer interaction device.
Preferably, described data processing step comprises:
The parameter setting steps is inputted the needed parameter of power selling income budget compilation by the human-computer interaction device;
Data read and storing step, from data storage cell, obtain relevant historical data and result store that the data budget process is calculated in data storage cell;
The data budget process by the historical data in the parameter that arranges in the setting steps that gets parms and the data storage cell that obtains, adopts the zero-base approach budget model that the budget compilation in budget year is calculated, and calculates and budget year estimates sum.
Preferably, described data processing step also comprises:
Data are adjusted decomposition step, and the budget year expectation sum that is used for described data budget process is calculated is adjusted, and with estimating that the proportion that total data accounts for total value by each detailed item decomposes in each detailed item budget year, form budget table, finish budget compilation.
Preferably, described data budget process is when carrying out budget compilation calculating, the calculation of parameter that at first according to the actual generation data incorporating parametric of the same period upper one year the submodule setting was set goes out the predicted data that month does not occur the current year, calculate expectation in current year sum according to the historical data of actual generation in the current year and the predicted data that the current year does not occur month again, then budget year estimate sum according to estimating that sum, the calculation of parameter that adopts the zero-base approach incorporating parametric that the submodule setting is set go out the current year.
By above technical scheme as can be known, the present invention adopts the zero-base approach budget model, take historical data as the establishment basis, in conjunction with various parameters, power grid enterprises are worked out in the power selling income budget of budget year, can automatically peek, computing, simplified budgeting process, alleviate the workload of artificial establishment, improved work efficiency, and can reduce the mistake that the people is estimating, and can decompose by the data adjustment budget data that calculates is adjusted flexibly, again target data is decomposed in detailed of each budget and the classification, make data more meet actual conditions and the demand of organization unit, promote the accuracy of budget data, also so that budget result is more objective, rationally.
Embodiment
As shown in Figure 1, power grid enterprises of the present invention power selling income budgeting system comprises data processing unit 1 and data query unit 2.Data processing unit 1 is used for adopting budget model to calculate the budget compilation data and the budget compilation data are stored in data storage cell according to the historical data that is stored in data storage cell; Data query unit 2 is used for inquiring about the budget compilation data by the human-computer interaction device.Wherein, described data storage cell and described human-computer interaction device belong to known calculations machine equipment common equipment, described data storage cell is used for store historical data and budget compilation data, and the authorized personnel can input historical data in the described data storage cell by the human-computer interaction device, and (this historical data is included in the data of working out front 12 months actual generation of budget compilation data next year at least; As working out data in 2013 in November, 2012, then historical data comprises data in year October in November, 2011 to 2012 at least), in order to use during budget compilation, simultaneously data storage cell can also be stored the budget compilation data that obtain afterwards as calculated and (is included at least when working out next year the budget compilation data, the predicted data in month does not occur the current year, and the expectation of the whole year in current year sum, budget year (next year) budget data), so that authorized personnel's inquiry.The human-computer interaction device comprises input equipment and display device, and input equipment is used for input data and operational order, and display device is used for showing user interface.
As shown in Figure 2, data processing unit 1 comprises that parameter arranges submodule 1-1, data read and sub module stored 1-2, the pre-operator module 1-3 of data and data adjustment decomposition submodule 1-4.Parameter wherein arranges submodule 1-1 for correlation parameters such as the growth factor that the power selling income budget is set, scheduled target number, historical datas; Data read with sub module stored 1-2 and are used for obtaining required historical data from data storage cell; The pre-operator module 1-3 of data reads the historical data of obtaining with sub module stored 1-2 for parameter and data that submodule 1-1 setting is set according to parameter, adopt budget model to calculate budget year budget data, data read with sub module stored 1-2 with budget year budget data be stored in the data storage cell; Present embodiment preferably comprises data adjustment decomposition submodule 1-4, the data adjustment is decomposed submodule 1-4 and is had the function of adjusting data and decomposition data, be used for the budget year budget data that data budget submodule 1-3 calculates is adjusted, and with budget year budget data decompose each relevant detailed, form budget table.
As shown in Figure 3, the pre-operator module 1-3 of data comprises a not generation month piece of data computation module 1-3a, annual data computation module 1-3b and zero-base approach budget model 1-3c, wherein, a month piece of data computation module 1-3a occurs came calculating book year that the predicted data in month does not occur for the parameter that the actual generation data incorporating parametric according to the same period upper one year arranges submodule 1-1 setting, annual data computation module 1-3b according to the current year the actual historical data that occurs and the predicted data that month does not occur the current year that calculates calculate and estimate sum the current year, zero-base approach budget model 1-3c is according to estimating that total incorporating parametric arranges the calculation of parameter that submodule 1-1 arranges and goes out budget year budget data the current year.
Power grid enterprises of the present invention power selling income budgetary technique comprises data processing step and data query step, data processing step adopts budget model to calculate the budget compilation data for the historical data that basis is stored in data storage cell, and the budget compilation data are stored in the data storage cell; The data query step is for to inquire about the budget compilation data of working out by the human-computer interaction device.
In conjunction with Fig. 4, Fig. 4 is the process flow diagram of the inventive method, and the below is described further power grid enterprises of the present invention power selling income budgetary technique.
In data processing step, at first carry out the parameter setting, the authorized personnel is by the needed parameter of input equipment input power selling income budget, such as scheduled target number, growth factor etc.;
Then from data storage cell, obtain required historical data;
Calculate according to set parameter and the historical data the obtained budget compilation to budget year, calculate and budget year estimate sum, data budget model of the present invention is the zero-base approach budget model, adopts the zero-base approach in the budget method to carry out budget compilation;
After working out, can inquire about the budget compilation data.
As preferred technical scheme, budgetary technique of the present invention also comprises data adjustment decomposition step, data are adjusted decomposition step the budget year budget data that the data budget process calculates are adjusted, and will estimate that the proportion that total data accounts for total value by each detailed item decomposes in each detailed, form budget table, finish budget compilation.
In general; power grid enterprises carry out at the year end in the current year usually to the budget compilation of power selling income next year; when next year power selling income budget is worked out; usually also have the current year 1-2 month actual generation number unknown; need to calculate this moment according to the actual generation number of previous year same period; thereby obtain not occuring the current year predicted data in month; then the actual historical data that occurs and the predicted data addition that month does not occur the current year that calculates are just obtained the expectation sum (hereinafter referred to as expectation in current year sum) of the whole year in the current year; on the basis that calculates expectation in current year sum; the parameter that arranges in the incorporating parametric setting steps calculates the expectation total (hereinafter referred to as budget year budget data) of the next year whole year (budget year) according to the zero-base approach budget model.
Since calculate in the data budget process budget year budget data structurally also can be different according to the different demands of enterprise, therefore need to adjust according to parameter budget year budget data, the authorized personnel can adjust data, and according to each detailed proportion that accounts for total value, with budget year budget data decompose on each detailed, finish at last the establishment of budget data.
Below come system and method for the present invention is elaborated with a specific embodiment.
For example, suppose in November in the current year power selling income budget data next year to be worked out, the scheduled target number of determining first budget year is 1200, the wherein total electricity charge=spike electricity charge+crest segment electricity charge+flat section electricity charge+paddy section electricity charge, large commercial power=calcium carbide+synthetic ammonia, estimate that total electricity charge next year increase by 10% on the basis in the current year, namely annual growth is 10%.Preparing method is as follows:
At first, the authorized personnel carries out the parameter setting, adopts input equipment by parameter submodule 1-1 input correlation parameter to be set, and is 1200 such as the scheduled target number of budget year, and annual growth is 10%, and the rate of growth that month does not occur the current year also is 10%;
Secondly, reading out data, read with sub module stored 1-2 by data and from data storage cell 3, to read the real data in 1-10 month in the current year month according to establishment, as shown in table 1, read simultaneously the real data of the previous year same period (November of upper one year and Dec), as the Calculating Foundation that moon piece of data does not occur the current year;
The tabulation of table 1. 1-10 in current year month real data
Again, carry out the data budget; The predicted data that during budget is not first occured month the current year is calculated, the not generation of the pre-operator module 1-3 of data month piece of data computation module 1-3a goes out the predicted data in the current year 11, Dec according to actual generation data and the set Growth Rate Calculation in previous year 11, Dec, and is as shown in table 2; Then calculate expectation in current year sum in conjunction with real data and predicted data, annual data computation module 1-3b obtains real data and the predicted data addition in 11-12 month in 1-10 month in the current year to estimate sum the current year, and is as shown in table 3; Calculate budget year budget data by estimating sum the current year, according to estimating total the current year that annual data computation module 1-3b calculates, the pre-operator module 1-3 of data adopts the zero-base approach incorporating parametric that submodule 1-1 set annual scheduled target number and annual growth are set and calculates budget year budget data, and is as shown in table 4; Data read with sub module stored 1-2 with the result store that calculates in data storage cell;
The tabulation of table 2. 11-12 in current year month predicted data
The tabulation of table 3. expectation in current year sum
The tabulation of table 4. budget year budget data
After obtaining budget year budget data, data are adjusted decomposition; Decomposing submodule 1-4 by the data adjustment adjusts, decomposes the budget year budget data that calculates, for example, rule of thumb judge, the authorized personnel thinks that total electricity charge expectation of large commercial power can reach 900, and total electricity charge of commercial electricity consumption are expected to be 218, and the sale of electricity gross income is constant, decomposing submodule 1-4 by the data adjustment adjusts accordingly budget data, the proportion that accounts for total value according to each subitem again after the adjustment decomposes, and forms budget table, and last budget data result is as shown in table 5;
The data list of table 5. budget year budget compilation
OK |
Budget items |
Total electricity charge |
The spike electricity charge |
The crest segment electricity charge |
The electricity charge of flat section |
The electricity charge of paddy section |
Inferior |
? |
? |
? |
? |
? |
? |
1 |
Large commercial power |
900 |
202.5 |
281.25 |
247.5 |
168.75 |
2 |
Calcium carbide |
525 |
110 |
171 |
149 |
95 |
3 |
Synthetic ammonia |
355 |
88 |
104 |
93 |
70 |
4 |
Resident living power utility |
82 |
13 |
25 |
36 |
8 |
5 |
Commercial electricity consumption |
218 |
68 |
77 |
63 |
10 |
6 |
Sale of electricity adds up to |
1200 |
143 |
157 |
131 |
24 |
After budget compilation is finished, can inquire about by the 2 pairs of establishments in data query unit result.
Power grid enterprises disclosed by the invention power selling income budgetary technique and system, incorporating parametric arranges the various parameters that submodule 1-1 provides, take historical data as the establishment basis, with the zero-base approach budget model power grid enterprises are worked out in the power selling income budget of budget year, generate the power selling income budget of power grid enterprises, when budget data and re-set target that budget model calculates variant, can decompose submodule by the data adjustment adjusts flexibly, again target data is decomposed in detailed of each budget and the classification, finally draw power selling income budget compilation data.The present invention adopts computer system automatically to calculate, and has simplified budgeting process, and the accuracy that has improved establishment efficient and promoted budget data is also so that budget result is more objective, reasonable.
It will be appreciated by those skilled in the art that, unit and the algorithm steps of each example of describing in conjunction with embodiment disclosed herein, can realize with electronic hardware, computer software or the combination of the two, for the interchangeability of hardware and software clearly is described, the composition of each example and step have been described in general manner just according to function in the above description.These functions actually with should with or software mode carry out, depend on application-specific and the design constraint of technical scheme.Realize described function with distinct methods when the professional and technical personnel can specifically should be used for to each, but this realization should not thought and exceeds scope of the present invention.
The method of describing in conjunction with embodiment disclosed herein or the step of algorithm can directly use the software module of hardware, processor execution, and perhaps the combination of the two is implemented.Software module can place random access memory (RAM), internal memory, ROM (read-only memory) (ROM), electrically programmable ROM, electrically erasable ROM, register, hard disk, moveable magnetic disc, CD-ROM or the known any other forms of storage medium of technical field.
To the above-mentioned explanation of the disclosed embodiments, be that this area professional and technical personnel can realize or use the present invention.Multiple modification to previous embodiment will be apparent concerning those skilled in the art, and or else defined General Principle can break away from the situation of the spirit or scope of the present invention among the present invention, realize in other embodiments.Therefore, the present invention will can not be restricted to previous embodiment, but will meet the widest scope consistent with principles of this disclosure and features of novelty.