Automatic cost allocation method and device and related products
By automating configuration and data splitting, the inefficiency and inaccuracy of expense allocation in the insurance and financial industries have been solved, enabling an efficient and traceable expense allocation process and improving calculation efficiency and accuracy.
Patent Information
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2025-12-08
- Publication Date
- 2026-03-10
AI Technical Summary
In industries such as insurance and finance, the cost allocation process suffers from problems such as classification errors, ratio calculation deviations, and inefficiency due to manual operation. Furthermore, the low degree of automation in the process makes it easy to introduce human error.
By configuring the information on the accounts to be allocated, the cost allocation configuration information, and the department ratio information, the raw cost data is obtained using ETL tools or scheduled SQL scripts. Performance attribute tags and account type tags are marked, and two-dimensional splitting and allocation ratio calculation are performed according to the processing rules to achieve automated cost allocation.
It improves the efficiency and accuracy of cost allocation calculations, reduces the degree of human intervention, and makes the generated intermediate data and allocation amounts traceable, eliminating redundant steps and sources of error in traditional manual allocation.
Smart Images
Figure CN121639385A_ABST
Abstract
Description
TECHNICAL FIELD
[0001] The present application relates to the technical field of computers, in particular to an automatic cost allocation method and device and related products. BACKGROUND
[0002] In industries such as insurance and finance, which have high requirements for the accuracy of financial accounting and the compliance of actuarial rules, cost allocation is a core link connecting financial accounting and actuarial analysis. The core goal is to accurately allocate various costs generated in the operation of an enterprise to the corresponding measurement units according to business logic, providing data support for financial statement preparation, actuarial reserve provision, and product profitability analysis.
[0003] In related technologies, business personnel need to manually sort out a large number of parameters such as fulfillment or non-fulfillment cost division, department proportion, and allocation factors, which may lead to classification errors and proportion calculation deviations. At the same time, the process is not automated, and manual intervention is required for parameter configuration, cost splitting, proportion calculation, and tail difference processing, which not only reduces efficiency but also may introduce additional errors due to human operation. SUMMARY
[0004] To solve the above problems, the present application provides an automatic cost allocation method, device and related products, which improves the calculation efficiency of cost allocation and improves the accuracy of the calculation results.
[0005] The embodiments of the present application disclose the following technical solutions:
[0006] In a first aspect, the embodiments of the present application provide an automatic cost allocation method, which comprises:
[0007] Configuring to-be-allocated subject information, cost division configuration information, department proportion information, and allocation factor proportion information;
[0008] Filtering original cost data according to the to-be-allocated subject information, retaining cost data of a target subject and marking a fulfillment attribute tag and a subject type tag of the cost data;
[0009] According to the cost division configuration information, matching the processing rules corresponding to the cost data;
[0010] In the case where the processing rules include proportion calculation, performing two-dimensional splitting on the cost data according to the department proportion information to obtain intermediate data of department-cost type-splitting amount; wherein the two-dimensional splitting includes department splitting and cost type splitting;
[0011] For fulfillment costs in the intermediate data, obtaining the allocation proportion of each measurement unit according to the allocation factor proportion information;
[0012] According to the intermediate data and the allocation proportion of each measurement unit, obtaining the allocation amount of each measurement unit.
[0013] In a possible implementation, the original cost data is filtered according to the subject information to be apportioned, cost data of the target subject is retained, and a performance attribute label and a subject type label of the cost data are marked, specifically including:
[0014] The original cost data is obtained by an ETL tool or a timing SQL script, and the original cost data is synchronized into an original cost data table;
[0015] Based on the subject information to be apportioned, cost data of the target subject is determined from the original cost data table according to a database correlation query;
[0016] The performance attribute label and the subject type label of the cost data are marked.
[0017] In a possible implementation, in the case where the processing rule includes proportion calculation, the cost data is two-dimensionally split according to department proportion information, to obtain intermediate data of department-cost type-split amount, specifically including:
[0018] In the case where the processing rule includes proportion calculation, department proportion information is associated according to the performance attribute label and the subject type label, to obtain an associated data set;
[0019] The split amount is obtained according to a department proportion and a cost type proportion in the associated data set; wherein the split amount is equal to the product of the cost data, the department proportion and the cost type proportion;
[0020] The intermediate data of department-cost type-split amount is obtained according to the fields of the associated data set and the split amount.
[0021] In a possible implementation, the apportioned amount of each measurement unit is obtained according to the intermediate data and the apportioning proportion of each measurement unit, specifically including:
[0022] The preliminary apportioned amount of each measurement unit is obtained according to the intermediate data and the apportioning proportion of each measurement unit;
[0023] In the case where the sum of the preliminary apportioned amounts of the measurement units corresponding to each measurement unit and the benchmark amount has an error amount less than a preset threshold, the measurement units are arranged in descending order according to the preliminary apportioned amounts;
[0024] The error amount is taken as the apportioned amount of the measurement unit ranked first, and the apportioned amounts of the other measurement units are respectively consistent with the corresponding preliminary apportioned amounts.
[0025] In a second aspect, an embodiment of the present application provides an automatic cost apportioning device, the device comprising: a configuration module, a marking module, a matching module, an intermediate data module, an apportioning proportion module and an apportioned amount module;
[0026] The configuration module is configured to configure to-be-apportioned subject information, expense division configuration information, department proportion information, and apportioning factor proportion information.
[0027] The marking module is configured to filter original expense data according to the to-be-apportioned subject information, retain expense data of a target subject, and mark a performance attribute label and a subject type label of the expense data.
[0028] The matching module is configured to match a processing rule corresponding to the expense data according to the expense division configuration information.
[0029] The intermediate data module is configured to perform two-dimensional splitting on the expense data according to the department proportion information to obtain department-expense type-splitting amount intermediate data when the processing rule includes proportion calculation; wherein the two-dimensional splitting includes department splitting and expense type splitting.
[0030] The apportioning proportion module is configured to obtain an apportioning proportion of each measurement unit according to the apportioning factor proportion information for a performance expense in the intermediate data.
[0031] The apportioning amount module is configured to obtain an apportioning amount of each measurement unit according to the intermediate data and the apportioning proportion of each measurement unit.
[0032] In a possible implementation, the marking module is specifically configured to obtain original expense data and synchronize the original expense data into an original expense data table through an ETL tool or a timing SQL script; determine expense data of a target subject from the original expense data table according to a database association query based on to-be-apportioned subject information; and mark a performance attribute label and a subject type label of the expense data.
[0033] In a possible implementation, the intermediate data module is configured to, when the processing rule includes proportion calculation, obtain an association data set according to the performance attribute label and the subject type label and the department proportion information; obtain a splitting amount according to a department proportion and an expense type proportion in the association data set; wherein the splitting amount is equal to a product of the expense data, the department proportion, and the expense type proportion; and obtain department-expense type-splitting amount intermediate data according to a field of the association data set and the splitting amount.
[0034] In a possible implementation, the apportioning amount module is specifically configured to obtain a preliminary apportioning amount of each measurement unit according to the intermediate data and the apportioning proportion of each measurement unit; arrange the measurement units in descending order of the preliminary apportioning amounts of the measurement units when an error amount between a sum of the preliminary apportioning amounts of the measurement units corresponding to each measurement unit and a benchmark amount is less than a preset threshold; take the error amount as an apportioning amount of a measurement unit ranked first in the arrangement, and make the apportioning amounts of other measurement units respectively consistent with the corresponding preliminary apportioning amounts.
[0035] Thirdly, embodiments of this application provide a computer device, including: a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the computer program, it implements the automated cost allocation method as described in any embodiment of the first aspect.
[0036] Fourthly, embodiments of this application provide a computer-readable storage medium storing instructions that, when executed on a terminal device, cause the terminal device to perform the automated cost-sharing method as described in any embodiment of the first aspect.
[0037] To improve the calculation efficiency and accuracy of cost allocation, this application provides an automated cost allocation method. The method involves configuring information on the subject to be allocated, cost allocation configuration information, departmental ratio information, and allocation factor ratio information. Based on the subject information, raw cost data is filtered, retaining the cost data of the target subject and marking the cost data with performance attribute tags and subject type tags. Based on the cost allocation configuration information, the processing rules corresponding to the cost data are matched. If the processing rules include ratio calculation, the cost data is split in two dimensions based on the departmental ratio information to obtain intermediate data of department-cost type-allocated amount. The two-dimensional split includes departmental splitting and cost type splitting. For the performance costs in the intermediate data, the allocation ratio of each measurement unit is obtained based on the allocation factor ratio information. Finally, based on the intermediate data and the allocation ratio of each measurement unit, the allocation amount for each measurement unit is obtained.
[0038] In this embodiment, the processing logic of pre-fixed rules, automated closed-loop processes, and precise data mapping eliminates redundant steps and sources of error in traditional manual or semi-automated cost allocation from the root. On the one hand, by reducing human involvement, the efficiency and accuracy of cost allocation calculation are improved; on the other hand, each calculation step is based on clear input data and configuration rules, and the generated intermediate data (department-cost type-split amount) is traceable to the original cost data, and the allocated amount is traceable to the intermediate data and the allocation factor ratio. Attached Figure Description
[0039] To more clearly illustrate the technical solutions in the embodiments of this application or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of this application. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.
[0040] Figure 1 A flowchart illustrating an automated cost-sharing method provided in this application embodiment;
[0041] Figure 2 A schematic diagram of an automated cost-sharing device provided in an embodiment of this application;
[0042] Figure 3 This is a schematic diagram of a computer device provided in an embodiment of this application. Detailed Implementation
[0043] To enable those skilled in the art to better understand the present application, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present application, and not all embodiments. Based on the embodiments in the present application, all other embodiments obtained by those of ordinary skill in the art without creative effort are within the scope of protection of the present application.
[0044] The terms "first" and "second," etc., used in the specification and claims of this application are used to distinguish different objects, not to describe a specific order of objects. For example, "first operation instruction" and "second operation instruction," etc., are used to distinguish different operation instructions, not to describe a specific order of operation instructions.
[0045] In the embodiments of this application, the terms "exemplary" or "for example" are used to indicate that something is an example, illustration, or description. Any embodiment or design that is described as "exemplary" or "for example" in the embodiments of this application should not be construed as being more preferred or advantageous than other embodiments or design. Specifically, the use of the terms "exemplary" or "for example" is intended to present the relevant concepts in a specific manner.
[0046] In the description of the embodiments of this application, unless otherwise stated, "multiple" means two or more, for example, multiple processing units means two or more processing units, multiple elements means two or more elements, etc.
[0047] The technical solution of this application will be described below with reference to the accompanying drawings.
[0048] See Figure 1 The figure is a flowchart of an automated cost allocation method provided in an embodiment of this application.
[0049] like Figure 1 As shown, the automation cost allocation method includes the following steps:
[0050] S1000: Configure information on the items to be allocated, the cost allocation configuration information, the department ratio information, and the allocation factor ratio information.
[0051] For example, to configure the information of the accounts to be allocated, click Add Account or Batch Import; fill in or upload the account code and account name; select the label (performance cost or non-performance cost); mark the account category (e.g., employee payroll and office rental); submit and review.
[0052] For the expense allocation configuration information and department ratio information, enter the ratio configuration subpage, select the configuration dimension (expense type or department); select the corresponding subject code (the system drop-down selection only displays the subjects that have been entered); fill in the ratio information: for expense type, select any one of acquisition, maintenance, claims, or non-performance cash flow, and fill in the corresponding percentage; for department designation, select the target department and fill in the percentage of that department (for example, office leasing by area ratio); for employee compensation, upload the department head table, and the system will automatically calculate the ratio; submit and save.
[0053] To access the allocation factor ratio information, go to the allocation factor subpage, select the factor type (earned premium, number of claims, or claim amount); fill in the coefficient percentage (e.g., earned premium coefficient 70%, claim amount coefficient 30%); select the applicable scope (all types of insurance or specific types of insurance); and submit to save.
[0054] It should be noted that in this embodiment, all configurations support editing, deletion, and version rollback. When rules need to be adjusted later, they can be modified directly on the corresponding configuration page. The system records historical versions and can be rolled back. After the configuration is completed, click the "Configuration Take Effect" button, and the system will set the current configuration as the default effective version for use in amortization calculations.
[0055] S2000: Filter the original cost data based on the information of the accounts to be allocated, retain the cost data of the target account, and mark the performance attribute label and account type label of the cost data.
[0056] In this embodiment of the application, the original cost data is obtained through an ETL tool or a scheduled SQL script and synchronized to the original cost data table; based on the information of the account to be allocated, the cost data of the target account is determined from the original cost data table according to the database association query; and the performance attribute label and account type label of the cost data are marked.
[0057] Using the list of accounts to be allocated as a filter, the cost data for the target accounts is extracted from the original cost data. First, the account codes or account names in the original cost data are precisely matched with the corresponding fields in the list of accounts to be allocated. Then, the cost data rows that match successfully are retained, and the mismatched data is removed. A subset of the cost data for the target accounts is generated and used as the data source for labeling.
[0058] Among them, the performance attribute label is used to identify direct performance costs and indirect performance costs; the account type label is used to identify cost accounts, expense accounts, or asset accounts.
[0059] In addition, in this embodiment of the application, the cost data of the target subject can also be checked for completeness and accuracy.
[0060] S3000: Based on the cost allocation configuration information, match the processing rules corresponding to the cost data.
[0061] For tagged expenses, the system associates expense allocation configuration information with subject codes, matches the specific processing rules corresponding to the subject, and clarifies the next step of splitting: if the configuration rule is specific subject department identification, the expense is directly associated with the preset target business department (e.g., General Manager's Office Expenses are directly identified as General Manager's Office); if the configuration rule is specific subject category expense type identification, the expense is directly classified into the preset expense type (e.g., Claim Investigation Fees belong to the Claim Related Category, directly identified as Claim Expense Type); if the configuration rule is proportional calculation, the expense is marked as needing subsequent proportional splitting (e.g., Employee Salaries need to be calculated proportionally based on the number of employees in the department, and Office Rentals need to be calculated proportionally based on the area of the department).
[0062] S4000: When the processing rules include proportional calculation, the expense data is split into two dimensions based on the departmental proportional information to obtain intermediate data of department-expense type-split amount; wherein, the two-dimensional split includes department split and expense type split.
[0063] For example, when the processing rules include ratio calculation, the associated department ratio information is obtained based on the performance attribute label and the subject type label to obtain the associated dataset; the split amount is obtained based on the department ratio and expense type ratio in the associated dataset; wherein, the split amount is equal to the product of expense data, department ratio and expense type ratio; and intermediate data of department-expense type-split amount is obtained based on the fields of the associated dataset and the split amount.
[0064] For expenses marked as proportional calculations or requiring further detailed breakdown, the system uses the deferred expenses_department ratio information to complete a two-dimensional breakdown, generating intermediate data of department-expense type-split amount. First, based on the proportion of each business department corresponding to the item in the configuration, the expense amount is split into each department (e.g., office rental expenses are split into 60% for the sales department, 30% for the finance department, and 10% for the technology department based on department area). Then, within each department, the split departmental expenses are further broken down according to the proportions of acquisition expenses, maintenance expenses, claims expenses, and non-performance cash flow in the configuration (e.g., in the sales department's split rental expenses, 70% goes to acquisition expenses and 30% to maintenance expenses). Finally, each original expense is converted into multiple intermediate records of department-expense type-split amount, ensuring clear expense attribution.
[0065] S5000: For performance costs in intermediate data, the allocation ratio of each metering unit is obtained based on the allocation factor ratio information.
[0066] First, read the factor coefficient percentages corresponding to earned premiums, number of claims, or claim amounts in the configuration (e.g., earned premium coefficient 70%, claim amount coefficient 30%). Then, combine the actual business data of the current billing period (e.g., earned premiums of each unit or claim amounts of each insurance type) to calculate the basic allocation ratio for each unit (or contract group) under specific insurance types or all insurance types scenarios (e.g., if the earned premiums of unit A account for 5% of all insurance types and the claim amount accounts for 3% of all insurance types, then the basic ratio = 5% × 70% + 3% × 30% = 4.4%). Finally, multiply the basic allocation ratio by the department-expense type percentage after splitting to obtain the final allocation ratio for each intermediate expense for each unit (or contract group) (e.g., the final allocation ratio for the sales department to obtain the expense breakdown amount = department percentage × expense type percentage × unit basic ratio).
[0067] S6000: Based on intermediate data and the allocation ratio of each metering unit, the allocation amount for each metering unit is obtained.
[0068] For example, based on intermediate data and the allocation ratio of each metering unit, the preliminary allocation amount of each metering unit is obtained; if the error between the sum of the preliminary allocation amounts of each metering unit and the benchmark amount is less than a preset threshold, each metering unit is arranged in descending order of the preliminary allocation amount; the error amount is used as the allocation amount of the metering unit ranked first, and the allocation amounts of other metering units are consistent with their corresponding preliminary allocation amounts.
[0069] In this embodiment, the processing logic of pre-fixed rules, automated closed-loop processes, and precise data mapping eliminates redundant steps and sources of error in traditional manual or semi-automated cost allocation from the root. On the one hand, by reducing human involvement, the efficiency and accuracy of cost allocation calculation are improved; on the other hand, each calculation step is based on clear input data and configuration rules, and the generated intermediate data (department-cost type-split amount) is traceable to the original cost data, and the allocated amount is traceable to the intermediate data and the allocation factor ratio.
[0070] In addition, this application embodiment also provides an automated cost sharing device, the device including: a configuration module 1000, a marking module 2000, a matching module 3000, an intermediate data module 4000, a sharing ratio module 5000, and a sharing amount module 6000;
[0071] Configuration module 1000 is used to configure information on the subject to be allocated, cost allocation configuration information, department ratio information, and allocation factor ratio information.
[0072] The tagging module 2000 is used to filter the original cost data based on the information of the subject to be allocated, retain the cost data of the target subject, and tag the cost data with the performance attribute label and the subject type label.
[0073] The matching module 3000 is used to match the processing rules corresponding to the cost data based on the cost division configuration information.
[0074] The intermediate data module 4000 is used to perform two-dimensional splitting of expense data based on departmental ratio information when the processing rules include ratio calculation, to obtain intermediate data of department-expense type-split amount; wherein, the two-dimensional splitting includes department splitting and expense type splitting.
[0075] The allocation ratio module 5000 is used to obtain the allocation ratio of each metering unit based on the allocation factor ratio information for the performance costs in the intermediate data.
[0076] The apportionment amount module 6000 is used to obtain the apportionment amount for each metering unit based on intermediate data and the apportionment ratio of each metering unit.
[0077] In this embodiment, the processing logic of pre-fixed rules, automated closed-loop processes, and precise data mapping eliminates redundant steps and sources of error in traditional manual or semi-automated cost allocation from the root. On the one hand, by reducing human involvement, the efficiency and accuracy of cost allocation calculation are improved; on the other hand, each calculation step is based on clear input data and configuration rules, and the generated intermediate data (department-cost type-split amount) is traceable to the original cost data, and the allocated amount is traceable to the intermediate data and the allocation factor ratio.
[0078] In one possible implementation, the tagging module 2000 is specifically used to obtain raw cost data through an ETL tool or a scheduled SQL script and synchronize the raw cost data to the raw cost data table; based on the information of the accounts to be allocated, it determines the cost data of the target account from the raw cost data table according to a database join query; and tags the cost data with performance attribute labels and account type labels.
[0079] In one possible implementation, the intermediate data module 3000 is used to obtain a related dataset by associating departmental proportion information based on performance attribute labels and subject type labels when the processing rules include proportion calculation; to obtain the split amount based on the departmental proportion and expense type proportion in the related dataset; wherein the split amount is equal to the product of expense data, departmental proportion and expense type proportion; and to obtain intermediate data of department-expense type-split amount based on the fields of the related dataset and the split amount.
[0080] In one possible implementation, the allocation amount module 5000 is specifically used to obtain the preliminary allocation amount for each metering unit based on intermediate data and the allocation ratio of each metering unit; if the error amount between the sum of the preliminary allocation amounts corresponding to each metering unit and the benchmark amount is less than a preset threshold, the metering units are arranged in descending order of the preliminary allocation amount; the error amount is used as the allocation amount of the metering unit ranked first, and the allocation amounts of other metering units are consistent with their corresponding preliminary allocation amounts.
[0081] This application provides a computer-readable storage medium storing a computer program thereon, which, when executed by a processor, implements the automated cost allocation method described in this application.
[0082] In practical applications, the computer-readable storage medium can be any combination of one or more computer-readable media. The computer-readable medium can be a computer-readable signal medium or a computer-readable storage medium. For example, a computer-readable storage medium can be, but is not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination thereof. More specific examples of computer-readable storage media (a non-exhaustive list) include: an electrical connection having one or more wires, a portable computer disk, a hard disk, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fiber, portable compact disk read-only memory (CD-ROM), optical storage device, magnetic storage device, or any suitable combination thereof. In this embodiment, the computer-readable storage medium can be any tangible medium containing or storing a program that can be used by or in conjunction with an instruction execution system, apparatus, or device.
[0083] Computer-readable signal media may include data signals propagated in baseband or as part of a carrier wave, carrying computer-readable program code. Such propagated data signals may take various forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination thereof. Computer-readable signal media may also be any computer-readable medium other than computer-readable storage media, capable of sending, propagating, or transmitting programs for use by or in connection with an instruction execution system, apparatus, or device.
[0084] Program code contained on a computer-readable medium may be transmitted using any suitable medium, including but not limited to wireless, wire, optical fiber, RF, etc., or any suitable combination thereof.
[0085] Computer program code for performing the operations of this invention can be written in one or more programming languages or a combination thereof, including object-oriented programming languages such as Java, Smalltalk, and C++, as well as conventional procedural programming languages such as "C" or similar programming languages. The program code can be executed entirely on the user's computer, partially on the user's computer, as a standalone software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In cases involving remote computers, the remote computer can be connected to the user's computer via any type of network—including a local area network (LAN) or a wide area network (WAN)—or can be connected to an external computer (e.g., via the Internet using an Internet service provider).
[0086] like Figure 3 The diagram shown is a structural schematic of a computer device provided in an embodiment of this application. Figure 3 The computer device 12 shown is merely an example and should not impose any limitation on the functionality and scope of use of the embodiments of the present invention.
[0087] like Figure 3 As shown, the computer device 12 is represented in the form of a general-purpose computing device. The components of the computer device 12 may include, but are not limited to: one or more processors or processing units 16, system memory 28, and a bus 18 connecting different system components (including system memory 28 and processing unit 16).
[0088] Bus 18 represents one or more of several bus architectures, including a memory bus or memory controller, a peripheral bus, a graphics acceleration port, a processor, or a local bus using any of the various bus architectures. For example, these architectures include, but are not limited to, the Industry Standard Architecture (ISA) bus, the Micro Channel Architecture (MAC) bus, the Enhanced ISA bus, the Video Electronics Standards Association (VESA) local bus, and the Peripheral Component Interconnect (PCI) bus.
[0089] Computer device 12 typically includes a variety of computer system readable media. These media can be any available media that can be accessed by computer device 12, including volatile and non-volatile media, removable and non-removable media.
[0090] System memory 28 may include computer system readable media in the form of volatile memory, such as random access memory (RAM) 30 and / or cache memory 32. Computer device 12 may further include other removable / non-removable, volatile / non-volatile computer system storage media. By way of example only, storage system 34 may be used to read and write non-removable, non-volatile magnetic media (…). Figure 3 Not shown; usually referred to as a "hard drive"). Although Figure 3 Not shown, a disk drive for reading and writing to a removable non-volatile disk (e.g., a "floppy disk") and an optical disk drive for reading and writing to a removable non-volatile optical disk (e.g., a CD-ROM, DVD-ROM, or other optical media) may be provided. In these cases, each drive may be connected to bus 18 via one or more data media interfaces. Memory 28 may include at least one program product having a set (e.g., at least one) of program modules configured to perform the functions of the embodiments of the present invention.
[0091] A program / utility 40 having a set (at least one) of program modules 42 may be stored, for example, in memory 28. Such program modules 42 include, but are not limited to, an operating system, one or more application programs, other program modules, and program data. Each or some combination of these examples may include an implementation of a network environment. Program modules 42 typically perform the functions and / or methods described in the embodiments of the present invention.
[0092] Computer device 12 can also communicate with one or more external devices 14 (e.g., keyboard, pointing device, display 24, etc.), and with one or more devices that enable a user to interact with the computer device 12, and / or with any device that enables the computer device 12 to communicate with one or more other computing devices (e.g., network card, modem, etc.). This communication can be performed through input / output (I / O) interface 22. Furthermore, computer device 12 can also communicate with one or more networks (e.g., local area network (LAN), wide area network (WAN), and / or public networks, such as the Internet) through network adapter 20. Figure 3 As shown, network adapter 20 communicates with other modules of computer device 12 via bus 18. It should be understood that, although... Figure 3 As not shown, it can be used in conjunction with computer device 12 with other hardware and / or software modules, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage systems.
[0093] The processor unit 16 executes various functional applications and data processing by running programs stored in the system memory 28, such as implementing the automated cost allocation method provided in the embodiments of this application.
Claims
1. An automated cost allocation method, characterized by, The method comprises: configuring to-be-allocated subject information, expense division configuration information, department proportion information, and allocation factor proportion information; screening original expense data according to the to-be-allocated subject information, retaining expense data of a target subject, and marking a performance attribute tag and a subject type tag of the expense data; matching a processing rule corresponding to the expense data according to the expense division configuration information; in a case where the processing rule comprises proportion calculation, performing two-dimensional splitting on the expense data according to the department proportion information to obtain intermediate data of department-expense type-splitting amount; wherein the two-dimensional splitting comprises department splitting and expense type splitting; for performance expense in the intermediate data, obtaining an allocation proportion of each measurement unit according to the allocation factor proportion information; obtaining an allocation amount of each measurement unit according to the intermediate data and the allocation proportion of each measurement unit.
2. The method of claim 1, wherein, The screening of original expense data according to the to-be-allocated subject information, the retention of expense data of a target subject, and the marking of a performance attribute tag and a subject type tag of the expense data specifically comprise: obtaining original expense data through an ETL tool or a timing SQL script and synchronizing the original expense data to an original expense data table; determining expense data of the target subject from the original expense data table according to database association query based on the to-be-allocated subject information; marking a performance attribute tag and a subject type tag of the expense data.
3. The method of claim 1, wherein, The two-dimensional splitting of the expense data according to the department proportion information in a case where the processing rule comprises proportion calculation specifically comprises: in a case where the processing rule comprises proportion calculation, obtaining an association data set by associating the department proportion information according to the performance attribute tag and the subject type tag; obtaining a splitting amount according to a department proportion and an expense type proportion in the association data set; wherein the splitting amount is equal to the product of the expense data, the department proportion, and the expense type proportion; obtaining intermediate data of department-expense type-splitting amount according to fields of the association data set and the splitting amount.
4. The method of claim 1, wherein, The obtaining of an allocation amount of each measurement unit according to the intermediate data and the allocation proportion of each measurement unit specifically comprises: obtaining a preliminary allocation amount of each measurement unit according to the intermediate data and the allocation proportion of each measurement unit; in a case where the sum of the preliminary allocation amount of each measurement unit and a reference amount is less than a preset threshold, arranging each measurement unit in descending order according to the preliminary allocation amount; taking the error amount as the allocation amount of the measurement unit ranked first, and taking the preliminary allocation amount as the allocation amount of other measurement units.
5. An automated cost allocation apparatus, characterized by, The device comprises a configuration module, a marking module, a matching module, an intermediate data module, an allocation proportion module, and an allocation amount module. The configuration module is configured to configure to-be-allocated subject information, expense division configuration information, department proportion information, and allocation factor proportion information. The marking module is configured to filter original cost data according to the subject information to be apportioned, retain cost data of a target subject, and mark a performance attribute label and a subject type label of the cost data; The matching module is configured to match a processing rule corresponding to the cost data according to the cost division configuration information; The intermediate data module is configured to, in a case where the processing rule includes proportional calculation, perform two-dimensional splitting on the cost data according to the department proportion information, to obtain intermediate data of department-cost type-splitting amount. The apportionment proportion module is configured to, for performance cost in the intermediate data, obtain an apportionment proportion of each measurement unit according to the apportionment factor proportion information. The apportionment amount module is configured to obtain an apportionment amount of each measurement unit according to the intermediate data and the apportionment proportion of each measurement unit.
6. The apparatus of claim 5, wherein, The marking module is specifically configured to obtain original cost data by an ETL tool or a timing SQL script, and synchronize the original cost data into an original cost data table. The marking module is specifically configured to determine cost data of the target subject from the original cost data table according to database association query based on the subject information to be apportioned, and mark a performance attribute label and a subject type label of the cost data.
7. The apparatus of claim 5, wherein, The intermediate data module is configured to, in a case where the processing rule includes proportional calculation, associate the department proportion information according to the performance attribute label and the subject type label, to obtain an association data set. The intermediate data module is configured to obtain a splitting amount according to a department proportion and a cost type proportion in the association data set, where the splitting amount is equal to a product of the cost data, the department proportion, and the cost type proportion. The intermediate data module is configured to obtain intermediate data of department-cost type-splitting amount according to a field of the association data set and the splitting amount.
8. The apparatus of claim 5, wherein, The apportionment amount module is specifically configured to obtain a preliminary apportionment amount of each measurement unit according to the intermediate data and the apportionment proportion of each measurement unit, and arrange each measurement unit in descending order of the preliminary apportionment amount in a case where an error amount between a sum of the preliminary apportionment amounts of each measurement unit and a benchmark amount is less than a preset threshold. The apportionment amount module is specifically configured to take the error amount as an apportionment amount of the measurement unit ranked first in the arrangement, and make the apportionment amounts of other measurement units consistent with the corresponding preliminary apportionment amounts.
9. A computer device, comprising: The computer readable storage medium stores instructions, and when the instructions run on the terminal device, the terminal device performs the automatic cost apportionment method. The computer readable storage medium stores instructions, and when the instructions run on the terminal device, the terminal device performs the automatic cost apportionment method.
10. A computer-readable storage medium, characterized in that,