Budget compilation method and device based on business plan mode and medium
By applying the grid form and multi-dimensional budget form mapping technology of the business plan model in budget preparation, the problem of insufficient fusion and flexibility of data multi-dimensional attributes in traditional budget preparation methods is solved, and efficient and easy-to-use budget preparation and analysis are achieved, reducing the problem of low-level data in traditional budget preparation methods. There is a risk of error.
Patent Information
- Application Number
- CN202411264563.1
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-09-10
- Publication Date
- 2024-12-31
AI Technical Summary
Traditional budget preparation methods cannot effectively take into account the integration and compilation flexibility of multi-dimensional attributes of data, resulting in low ease of use and difficult data collection, which increases the probability of entry errors.
Using a budgeting method based on the business plan model, use ease of use improvements by defining and planning business plan grid forms, map them with multi-dimensional budget forms, push data for analysis and calculation, and take advantage of the clarity and expansion of grid lists. , realize multidimensional data storage and analysis.
It improves the ease of use of budget preparation, reduces the complexity of compilation and the probability of error, breaks down barriers between business systems, and enhances the enthusiasm of enterprises to prepare budgets.
Smart Images

Figure CN119228030A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the technical field of business budget preparation, and in particular to a budget preparation method, device and medium based on a business plan model. Background Art
[0002] In the process of business operations, budget management plays an important role in controlling costs and planning cash flow. Traditional budget preparation methods often rely on manual experience, which is not only time-consuming and labor-intensive, but also prone to errors. With the development of technology, how to optimize the budget preparation process has become a focus of attention. Since the budget involves various business systems, the data naturally comes from various business systems. When preparing the budget, the compiler needs to collect data from various systems and enter it manually, which greatly increases the probability of errors. Based on this, most corporate personnel are generally afraid of budget preparation, which further exacerbates the difficulty of budget preparation.
[0003] Traditional budgeting is mostly done in Excel or online Excel. Although Excel can integrate the multi-dimensional attributes of budgets, such as data can be stored in cells and the data in each cell can be described from multiple dimensions, it also limits the flexibility of budgeting. The more descriptive information there is, the greater the impact on the adjustment of the table. For example, if the table template must be defined in advance and the format of the table changes in the middle, it will have a significant impact on the overall storage of data. Moreover, budgets usually involve multiple dimensions, but the scalability of Excel tables is limited and cannot effectively support the entry of multiple attribute data, which greatly reduces the ease of use of budgeting.
[0004] Therefore, the traditional budget preparation method cannot well balance the integration of multi-dimensional attributes of data and the flexibility of budget preparation, which limits the ease of budget preparation and hinders the enthusiasm of enterprises to prepare budgets. Summary of the invention
[0005] The embodiments of the present invention provide a budget preparation method, device and medium based on a business plan model, which are used to solve the following technical problems: the traditional budget preparation method cannot well balance the integration of multi-dimensional attributes of data and the flexibility of budget preparation, resulting in low usability of budget preparation; and the collection of budget data is difficult, which increases the probability of data entry errors.
[0006] The embodiment of the present invention adopts the following technical solutions:
[0007] On the one hand, an embodiment of the present invention provides a budget preparation method based on a business plan model, the method comprising: defining and planning a business plan grid form according to the business plan preparation content;
[0008] Based on budget preparation requirements, the business plan grid form is improved for usability;
[0009] Budgeting the business plan preparation content through the improved business plan grid form to obtain grid form data;
[0010] Mapping the business plan grid form with the multidimensional budget form to obtain a mapping relationship;
[0011] According to the mapping relationship, the grid form data is pushed as multi-dimensional budget data, and data analysis and calculation are performed on the multi-dimensional budget data.
[0012] In a feasible implementation, according to the content of the business plan, a business plan grid form is defined and planned, specifically including:
[0013] Extracting row information and column information from the business plan preparation content; wherein the row information at least includes a row dimension;
[0014] According to the row information and column information, the row dimension and column dimension of the grid form are defined and planned to obtain the business plan grid form.
[0015] In a feasible implementation, based on budget preparation requirements, the usability of the business plan grid form is improved, specifically including:
[0016] Extracting row information with usability improvement requirements from the budget preparation requirements, and searching for improvement setting methods corresponding to the row information;
[0017] Through the improved setting method, the corresponding row dimensions in the business plan grid form are set to achieve usability improvement.
[0018] In a feasible implementation manner, budget compilation is performed on the business plan compilation content through the improved business plan grid form to obtain grid form data, which specifically includes:
[0019] The business plan preparation content is imported into the business plan grid form, and data is prepared according to the data dimension mode in the business plan grid form to obtain the grid form data.
[0020] In a feasible implementation, the business plan grid form is mapped with the multi-dimensional budget form to obtain a mapping relationship, which specifically includes:
[0021] Obtaining a storage structure table of the business plan grid form;
[0022] Obtaining a multi-dimensional information structure table for each column in the multi-dimensional budget form;
[0023] The storage structure table and the multi-dimensional information structure table are associated and mapped through the same column numbers in the two structure tables to obtain a mapping relationship between the business plan grid form and the multi-dimensional budget form.
[0024] In a feasible implementation manner, obtaining a multi-dimensional information structure table of each column in the multi-dimensional budget form specifically includes:
[0025] Obtaining a column information structure table of the multidimensional budget form, and obtaining column information fields and the meaning of each column information field in the column information structure table;
[0026] According to the column information field, the multi-dimensional information structure corresponding to each column in the multi-dimensional budget form is obtained to obtain the multi-dimensional information structure table.
[0027] In a feasible implementation manner, according to the mapping relationship, the grid form data is pushed as multi-dimensional budget data, and data analysis and calculation are performed on the multi-dimensional budget data, specifically including:
[0028] According to the mapping relationship, the grid form data is obtained and a Cartesian product is performed on the multi-dimensional information structure table of the multi-dimensional budget form to obtain the multi-dimensional budget data;
[0029] Based on data analysis requirements, corresponding analysis and calculations are performed on the multi-dimensional budget data.
[0030] In a feasible implementation manner, according to the mapping relationship, obtaining the grid form data and the multi-dimensional information structure table of the multi-dimensional budget form to perform Cartesian product to obtain the multi-dimensional budget data specifically includes:
[0031] Obtaining required row information and column information from the grid form data to obtain a budget preparation requirement table;
[0032] According to the mapping relationship, a column combination table of a multidimensional budget form corresponding to the column information of the budget preparation demand table is obtained;
[0033] Cartesian product operation is performed on the budget preparation requirement table and the column combination table to obtain the multi-dimensional budget data.
[0034] On the other hand, an embodiment of the present invention also provides a budget preparation device based on a business plan model, the device comprising: at least one processor; and a memory communicatively connected to the at least one processor; wherein the memory stores instructions that can be executed by the at least one processor so that the at least one processor can execute the budget preparation method based on the business plan model.
[0035] Finally, an embodiment of the present invention also provides a storage medium, which is a non-volatile computer-readable storage medium, and the non-volatile computer-readable storage medium stores at least one program, each of which includes instructions, and when the instructions are executed by a terminal, the terminal executes the budget preparation method based on a business planning model.
[0036] Compared with the prior art, the budget preparation method, device and medium based on the business plan model provided by the embodiment of the present invention have the following beneficial effects:
[0037] The present invention replaces the traditional method of budgeting through Excel tables by applying the grid compilation method commonly used in the field of business plans to the field of budgeting. As a two-dimensional table, the grid list cannot realize the multidimensional storage of data, but it is more clear and clear to display, and supports the function extensions such as drag-and-drop, sorting, and screening, and the user can more flexibly configure the table. Combined with the data mapping and conversion method between the business plan grid list and the multidimensional budget table proposed by the present invention, the defect that the grid list cannot perform multidimensional storage of data is overcome, so that the table can also realize multidimensional storage of data while having good scalability, so that the budget data can be further directly analyzed and calculated after budgeting. Through this solution, the budget can be compiled through the mode of the business plan, and then by generating the budget data into the corresponding multidimensional budget, the complexity of compilation is reduced, and the ease of compilation is also improved, and the data comes directly from the system, reducing the error probability that may be caused by human input.
[0038] This solution can effectively break down the barriers between business systems. At the same time, it gets rid of the way that budget preparation can only be done through Excel tables, and switches to a more familiar and more scalable plan list method. This can greatly improve the ease of preparation and increase the enthusiasm of enterprises in preparing budgets. BRIEF DESCRIPTION OF THE DRAWINGS
[0039] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the following briefly introduces the drawings required for use in the embodiments or the prior art descriptions. Obviously, the drawings described below are only some embodiments recorded in the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without creative work. In the drawings:
[0040] Figure 1 A flow chart of a budget preparation method based on a business plan model provided by an embodiment of the present invention;
[0041] Figure 2 A schematic diagram of a business plan grid form format provided by an embodiment of the present invention;
[0042] Figure 3 A schematic diagram of a mapping relationship between a business plan grid form and a multi-dimensional budget form provided in an embodiment of the present invention;
[0043] Figure 4 A schematic diagram of the structure of a budget preparation device based on a business plan model provided by an embodiment of the present invention. DETAILED DESCRIPTION
[0044] In order to enable those skilled in the art to better understand the technical solutions in the present invention, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of this specification, all other embodiments obtained by ordinary technicians in this field without creative work should fall within the scope of protection of the present invention.
[0045] The embodiment of the present invention provides a business plan grid form and a multi-dimensional budget form method, such as Figure 1 As shown, the business plan grid form and multi-dimensional budget form method specifically include steps S101-S105:
[0046] S101. Define and plan the business plan grid form according to the business plan content.
[0047] Specifically, in the business plan preparation content, row information and column information are extracted; wherein the row information at least includes the row dimension, and other attributes such as row attributes and dimension attributes can be used as auxiliary attribute information and customized according to actual demand scenarios. Then, based on the row information and column information, the row dimension and column dimension of the grid form are defined and planned to obtain the business plan grid form.
[0048] In one embodiment, Figure 2A schematic diagram of a business plan grid form format provided by an embodiment of the present invention, such as Figure 2 The following is a grid form of a production plan. The row information involved in this form includes: plan number, product, unit of measurement, contractor, data source, etc. Among them, the plan number is a row attribute, describing the business number of the entire row; the product is a row dimension; the unit of measurement is a product attribute, that is, a dimension attribute; the contractor is a row dimension; the data source is the source of the plan (manual entry or system introduction), which is also a type of row attribute. The column dimension information involved in this form includes: value field (carryover from the previous year, total for this year, etc.), budget period (year + January-December). For the grid form, you don’t need to consider the specific business meaning, you only need to ensure that the form information is complete, that is, the form needs to contain the following columns: plan number, product, unit of measurement, contractor, data source, all of which are string types; and carryover from the previous year, total for this year, and budget from January to December, all of which are numeric types. Complete the grid form definition and planning according to the above requirements.
[0049] S102. Based on budget preparation requirements, improve the usability of the business plan grid form.
[0050] Specifically, the row information with the usability improvement requirements is extracted from the budget preparation requirements, and the improvement setting method corresponding to the row information is found. The corresponding row dimension in the business plan grid form is set through the found improvement setting method to complete the usability improvement.
[0051] In one embodiment, during the grid form definition process, the usability of each row of information can be improved according to the specific needs of budget compilation. For example, the plan number can be dynamically generated according to the rules; the product and the contracting unit can add a dictionary to help select; the data source can be improved by using drop-down enumeration and other settings, which can be easily achieved through the inherent characteristics of the grid list. After completing this part of the definition, each business unit can prepare a budget according to the mode desired by the user.
[0052] S103. Budgeting the business plan preparation content is performed using the improved business plan grid form to obtain grid form data.
[0053] Specifically, the business plan preparation content is imported into the business plan grid form, and data is prepared according to the data dimension mode in the business plan grid form to obtain grid form data.
[0054] S104: Map the business plan grid form and the multi-dimensional budget form to obtain a mapping relationship.
[0055] Specifically, the storage structure table of the business plan grid form is obtained, and the multi-dimensional information structure table of each column in the multi-dimensional budget form is obtained.
[0056] Furthermore, the storage structure table and the multi-dimensional information structure table are associated and mapped through the same column numbers in the two structure tables, so as to obtain a mapping relationship between the business plan grid form and the multi-dimensional budget form.
[0057] Among them, the multi-dimensional information structure table of each column in the multi-dimensional budget form is obtained, including:
[0058] The column information structure table of the multidimensional budget form is obtained, and the column information fields and the meaning of each column information field are obtained in the column information structure table. According to the column information fields, the multidimensional information structure corresponding to each column in the multidimensional budget form is obtained to obtain the multidimensional information structure table.
[0059] As a feasible implementation method, after the budget is compiled through the business plan grid form, since the obtained data does not have much business meaning, if it is necessary to associate the business for related calculation processing or multi-dimensional analysis, it is necessary to convert the row and column data of the grid form into data with multi-dimensional meaning, that is, to generate the corresponding budget multi-dimensional information. At this time, it is necessary to map the grid form data with the budget multi-dimensional data, so as to convert the grid form data into budget data with multi-dimensional meaning. The basis of the mapping definition is the classification and splitting of the report data from the budget perspective.
[0060] In one embodiment, Figure 2 Taking the production plan form shown in the figure as an example, it is assumed that the storage table structure corresponding to the grid form is as shown in Table 1.
[0061] Table 1
[0062]
[0063]
[0064] Since the multidimensional budget form is a multidimensional structure, each column is composed of corresponding multiple dimensions. The table structure corresponding to the column information is shown in Table 2.
[0065] Table 2
[0066] Table name TBICOL Field Name meaning TBICOL_LZB Column number TBICOL_POS Position (information column or data column) TBICOL_YSNM Information column dimension ID TBICOL_DX01 Data column dimension ID …… Data column dimension ID TBICOL_DX12 Data column dimension ID
[0067] The table structure in Table 2 does not involve the specific meaning of the fields. The specific meaning of the fields is stored in the information structure table in Table 3. Taking the eighth column in Table 3 as an example, the eighth column means that the budget period is month 0 and the data type is the budget data planned for January.
[0068] Table 3
[0069] period Data Types TBICOL_LZB TBICOL_POS TBICOL_YSNM TBICOL_DX03 TBICOL_DX04 1 OK Plan No. 2 OK product 3 OK Units of measurement 4 OK Contractor 5 OK Data Source 6 List Amount carried forward from the previous year -1 year Carryover quantity 7 List Total planned for this year 0 years Planned merger 8 List January Plan 0 month January Plan 9 List February Plan +1 month February Plan 10 List March Plan +2 months March Plan 11 List April Plan +3 months April Plan 12 List May Plan +4 months May Plan 13 List June Plan +5 months June Plan 14 List July Plan +6 months July Plan 15 List August Plan +7 months August Plan 16 List September Plan +8 months September Plan 17 List October Plan +9 months October Plan 18 List November Plan +October November Plan 19 List December Plan +November December Plan
[0070] As shown in Table 1, Table 2, and Table 3, the association between the grid form and the multidimensional budget table can be achieved through the column number. By transferring the column number, each column in the grid list can be matched with the column in the multidimensional budget table, so that the dimension information of the column corresponding to the multidimensional budget can be obtained. Figure 3 A schematic diagram of a mapping relationship between a business plan grid form and a multi-dimensional budget form provided by an embodiment of the present invention, such as Figure 3 As shown, since the field name in Table 1 and the information column dimension ID (TBICOL_YSNM) in Table 3 have a one-to-one correspondence according to the column number, the storage structure table of the business plan grid form and the multi-dimensional information structure table of the multi-dimensional budget form can be mapped one-to-one through the column number, thereby associating the storage structure table with the multi-dimensional information structure table.
[0071] S105. According to the mapping relationship, the grid form data is pushed into multi-dimensional budget data, and data analysis and calculation are performed on the multi-dimensional budget data.
[0072] Specifically, according to the mapping relationship, the grid form data is obtained and the multi-dimensional information structure table of the multi-dimensional budget form is Cartesian-producted to obtain the multi-dimensional budget data, which specifically includes:
[0073] The required row information and column information are obtained from the grid form data to obtain the budget preparation demand table. Then, according to the mapping relationship, the column combination table of the multidimensional budget form corresponding to the column information of the budget preparation demand table is obtained.
[0074] Furthermore, the budget preparation requirement table and the column combination table are subjected to Cartesian product operation to obtain multi-dimensional budget data. Then, based on the data analysis requirements, the multi-dimensional budget data is subjected to corresponding analysis and operation.
[0075] In one embodiment, after completing the mapping definition, a correspondence between the grid form and the budget multi-dimensionality can be obtained, and the combination of the row information of the grid form can be directly obtained from the row TBROW_SCYS of Table 1. The column information of the grid form can be mapped to the corresponding column of Table 3 by the column number, and then converted to obtain multi-dimensional combination information. Then, through the Cartesian product of these two parts of data, all the multi-dimensional information of the budget form can be obtained, so that the data of the grid form can be pushed into the multi-dimensional data of the budget, and then subsequent analysis and calculation can be performed.
[0076] by Figure 1Taking the first two rows of as an example, the combination of the compiled products and the contracting units is taken out, as shown in Table 4. The column combination in the multidimensional budget table having a mapping relationship with Table 4 is shown in Table 5.
[0077] Table 4
[0078] Line Number product Contractor 1 notebook Production of a 2 Desktop Production Department 2
[0079] Table 5
[0080] Column number period Data Types 6 -1 year Carryover quantity 7 0 years Plan total 8 0 month January Plan 9 +1 month February Plan 10 +2 months March Plan 11 +3 months April Plan 12 +4 months May Plan 13 +5 months June Plan 14 +6 months July Plan 15 +7 months August Plan 16 +8 months September Plan 17 +9 months October Plan 18 +October November Plan 19 +November December Plan
[0081] After performing Cartesian product operation on Table 4 and Table 5, all the cell information of the final budget table is obtained, as shown in Table 6.
[0082] Table 6
[0083]
[0084]
[0085]
[0086] Business plans are usually compiled in the form of grid lists, while budgets are usually compiled in the form of Excel tables. From the front-end perspective, they compile the same content, but there are significant differences in the ease of use of the compilation. Through front-end comparison, the grid list mode interface uses a two-dimensional table, which is clearer and supports drag-and-drop, sorting, filtering and other functions. Users can easily operate data. At the same time, the grid list has excellent data scalability, and can easily add rows and columns, or customize fields. It also supports user-defined views and layouts, and is superior in terms of functionality and traversability. On the other hand, although the compilation method of Excel well integrates the multi-dimensional attributes of the budget, such as data can be stored in cells, and the data of each cell can be described from multiple dimensional perspectives, etc., this also limits the flexibility of compilation (the more descriptive information, the greater the impact on the adjustment of the table). For example, the table template must be defined in advance. If the table format changes in the middle, it will have a significant impact on the overall storage of the data. Due to some limitations of Excel itself, operating drop-down boxes, date controls, etc. in Excel often encounters various inconveniences, which will affect the overall compilation experience. The present invention combines the advantages of the two compilation methods, compiles the budget through the business plan grid list, and then converts the compilation data into a multi-dimensional structure of the budget through the system, and then performs subsequent budget analysis and calculation.
[0087] In addition, the embodiment of the present invention also provides a business plan grid form and a multi-dimensional budget form device, such as Figure 4 As shown, the business plan grid form and multi-dimensional budget form equipment specifically include:
[0088] at least one processor; and a memory in communication with the at least one processor; wherein,
[0089] The memory stores instructions executable by at least one processor to enable the at least one processor to perform:
[0090] Define and plan the business plan grid form according to the business plan content;
[0091] Based on budget preparation requirements, the business plan grid form is improved for usability;
[0092] Budgeting the business plan preparation content through the improved business plan grid form to obtain grid form data;
[0093] Mapping the business plan grid form with the multidimensional budget form to obtain a mapping relationship;
[0094] According to the mapping relationship, the grid form data is pushed as multi-dimensional budget data, and data analysis and calculation are performed on the multi-dimensional budget data.
[0095] Finally, an embodiment of the present invention further provides a storage medium, which is a non-volatile computer-readable storage medium, and the non-volatile computer-readable storage medium stores at least one program, each of which includes instructions, and when the instructions are executed by a terminal, the terminal executes:
[0096] Define and plan the business plan grid form according to the business plan content;
[0097] Based on budget preparation requirements, the business plan grid form is improved for usability;
[0098] Budgeting the business plan preparation content through the improved business plan grid form to obtain grid form data;
[0099] Mapping the business plan grid form with the multidimensional budget form to obtain a mapping relationship;
[0100] According to the mapping relationship, the grid form data is pushed as multi-dimensional budget data, and data analysis and calculation are performed on the multi-dimensional budget data.
[0101] Each embodiment of the present invention is described in a progressive manner, and the same or similar parts between the embodiments can be referred to each other, and each embodiment focuses on the differences from other embodiments. In particular, for the device, equipment, and non-volatile computer storage medium embodiments, since they are basically similar to the method embodiments, the description is relatively simple, and the relevant parts can be referred to the partial description of the method embodiments.
[0102] The above describes specific embodiments of the present invention. In addition, the processes depicted in the accompanying drawings do not necessarily require the specific order or sequential order shown to achieve the desired results. In some embodiments, multitasking and parallel processing are also possible or may be advantageous.
[0103] The above description is only an embodiment of the present invention and is not intended to limit the present invention. For those skilled in the art, the embodiments of the present invention may have various modifications and variations. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the embodiments of the present invention should be included in the protection scope of the present invention.
Claims
1. A budget preparation method based on a business planning model, characterized in that: The method comprises: Define and plan the business plan grid form according to the business plan content; Based on budget preparation requirements, the business plan grid form is improved for usability; Budgeting the business plan preparation content through the improved business plan grid form to obtain grid form data; Mapping the business plan grid form with the multidimensional budget form to obtain a mapping relationship; According to the mapping relationship, the grid form data is pushed as multi-dimensional budget data, and data analysis and calculation are performed on the multi-dimensional budget data.
2. A budget preparation method based on a business plan model according to claim 1, characterized in that: Define and plan the business plan grid form based on the business plan content, including: Extracting row information and column information from the business plan preparation content; wherein the row information at least includes a row dimension; According to the row information and column information, the row dimension and column dimension of the grid form are defined and planned to obtain the business plan grid form.
3. A budget preparation method based on a business plan model according to claim 1, characterized in that: Based on the budget preparation requirements, the usability of the business plan grid form is improved, including: Extracting row information with usability improvement requirements from the budget preparation requirements, and searching for improvement setting methods corresponding to the row information; Through the improved setting method, the corresponding row dimensions in the business plan grid form are set to achieve usability improvement.
4. A budget preparation method based on a business plan model according to claim 1, characterized in that: The business plan preparation content is budgeted through the improved business plan grid form to obtain grid form data, specifically including: The business plan preparation content is imported into the business plan grid form, and data is prepared according to the data dimension mode in the business plan grid form to obtain the grid form data.
5. A budget preparation method based on a business plan model according to claim 1, characterized in that: The business plan grid form is mapped with the multi-dimensional budget form to obtain a mapping relationship, which specifically includes: Obtaining a storage structure table of the business plan grid form; Obtaining a multi-dimensional information structure table for each column in the multi-dimensional budget form; The storage structure table and the multi-dimensional information structure table are associated and mapped through the same column numbers in the two structure tables to obtain a mapping relationship between the business plan grid form and the multi-dimensional budget form.
6. A budget preparation method based on a business plan model according to claim 5, characterized in that: Obtain a multi-dimensional information structure table for each column in the multi-dimensional budget form, specifically including: Obtaining a column information structure table of the multidimensional budget form, and obtaining column information fields and the meaning of each column information field in the column information structure table; According to the column information field, the multi-dimensional information structure corresponding to each column in the multi-dimensional budget form is obtained to obtain the multi-dimensional information structure table.
7. A budget preparation method based on a business plan model according to claim 1, characterized in that: According to the mapping relationship, the grid form data is pushed as multi-dimensional budget data, and data analysis and calculation are performed on the multi-dimensional budget data, specifically including: According to the mapping relationship, the grid form data is obtained and a Cartesian product is performed on the multi-dimensional information structure table of the multi-dimensional budget form to obtain the multi-dimensional budget data; Based on data analysis requirements, corresponding analysis and calculations are performed on the multi-dimensional budget data.
8. A budget preparation method based on a business plan model according to claim 7, characterized in that: According to the mapping relationship, obtaining the grid form data and the multi-dimensional information structure table of the multi-dimensional budget form to perform Cartesian product to obtain the multi-dimensional budget data specifically includes: Obtaining required row information and column information from the grid form data to obtain a budget preparation requirement table; According to the mapping relationship, a column combination table of a multidimensional budget form corresponding to the column information of the budget preparation demand table is obtained; Cartesian product operation is performed on the budget preparation requirement table and the column combination table to obtain the multi-dimensional budget data.
9. A budget preparation device based on a business planning model, characterized in that: The device comprises: at least one processor; and, a memory communicatively connected to the at least one processor; wherein, The memory stores instructions that can be executed by the at least one processor, so that the at least one processor can execute the budget preparation method based on the business plan model according to any one of claims 1-8.
10. A storage medium, characterized in that: The storage medium is a non-volatile computer-readable storage medium, and the non-volatile computer-readable storage medium stores at least one program, each of which includes instructions, and when the instructions are executed by the terminal, the terminal executes a budget preparation method based on a business plan model according to any one of claims 1-8.
