CN115936302A

CN115936302A - Cost sharing method and device, storage medium and computer equipment

Info

Publication number: CN115936302A
Application number: CN202211208961.2A
Authority: CN
Inventors: 陈红霞; 谷勇成; 蔡名光
Original assignee: Yuanguang Software Co Ltd
Current assignee: Yuanguang Software Co Ltd
Priority date: 2022-09-30
Filing date: 2022-09-30
Publication date: 2023-04-07

Abstract

The embodiment of the application discloses a cost sharing method and device, a storage medium and computer equipment, and relates to the field of office automation. The cost data to be shared are identified through the field values of the cost composition properties in the cost data, then the corresponding field values of the sharing standards are matched in the preset sharing rule table according to the field values of the cost elements, the field values of the cost objects and the field values of the service tags, cost sharing is automatically carried out according to the field values of the sharing standards, refined automatic cost sharing is carried out through three dimensions of the cost elements, the cost objects and the service tags, and therefore the accuracy of the cost sharing and the efficiency of the cost sharing are improved.

Description

Cost sharing method and device, storage medium and computer equipment

Technical Field

The present application relates to the field of office automation, and in particular, to a cost allocation method, apparatus, storage medium, and computer device.

Background

With the increase of the enterprise management level and the enhancement of external supervision, the cost information of the enterprise is required to be reflected more and more finely, such as: the national regulatory organization has definitely required that power grid operation enterprises accurately record and reasonably collect and distribute power transmission and distribution cost according to voltage levels, services and user categories, and form a multidimensional lean cost information reflection report form of management dimensions such as business activities, voltage levels, asset types, user categories and the like. For the multidimensional lean reflection of the cost information, the key is the intelligent identification of the cost data service label and the construction of an indirect cost apportionment rule.

In the prior art, for the construction of a cost allocation rule, an allocation path is generally single, according to a specified allocation path, a cost generation main body allocates to a beneficiary object, for the same generation main body with the same cost, manual allocation is performed on different beneficiaries, and an allocation result cannot accurately reflect the cost occurrence condition.

Disclosure of Invention

The embodiment of the application provides a cost allocation method, a cost allocation device, a storage medium and computer equipment, and can solve the problem that the precision of cost allocation is not high in the prior art. The technical scheme is as follows:

in a first aspect, an embodiment of the present application provides a cost apportionment method, where the method includes:

collecting a cost data set; wherein the cost data set comprises a plurality of cost data, the cost data comprising the following fields: cost elements, service tags, cost objects, cost collection amounts and cost composition properties;

identifying cost data to be apportioned in the cost data set according to field values of cost constituent properties;

for each piece of cost data to be apportioned, matching a field value of an apportionment standard in a preset apportionment rule table according to a field value of a cost element, a field value of a cost object and a field value of a service label;

and according to the matched field value of the allocation standard, allocating the cost data to be allocated to obtain a cost allocation result.

In a second aspect, an embodiment of the present application provides a cost apportioning apparatus, including:

an acquisition unit for acquiring a cost data set; wherein the cost data set comprises a plurality of cost data, the cost data comprising the following fields: cost elements, service tags, cost objects, cost collection amounts and cost composition properties;

an identifying unit configured to identify cost data to be apportioned in the cost data set according to a field value of a cost composition property;

the matching unit is used for matching field values of the apportionment standards in a preset apportionment rule table according to the field values of the cost elements, the cost objects and the service labels for each piece of cost data to be apportioned;

and the apportionment unit is used for apportioning the cost data to be apportioned according to the matched field value of the apportionment standard to obtain a cost apportionment result.

In a third aspect, embodiments of the present application provide a computer storage medium storing a plurality of instructions adapted to be loaded by a processor and to perform the above-mentioned method steps.

In a fourth aspect, an embodiment of the present application provides a computer device, which may include: a processor and a memory; wherein the memory stores a computer program adapted to be loaded by the processor and to perform the above-mentioned method steps.

The beneficial effects brought by the technical scheme provided by some embodiments of the application at least comprise:

the cost data to be apportioned are identified through the field values of the cost composition properties in the cost data, then the corresponding field values of the apportionment standards are matched in a preset apportionment rule table according to the field values of the cost elements, the cost object and the service tags, the cost is automatically apportioned according to the field values of the apportionment standards, the automatic cost apportionment refined through three dimensions of the cost elements, the cost object and the service tags is realized, and the accuracy of the cost apportionment and the efficiency of the cost apportionment are improved.

Drawings

In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings used in the embodiments or the prior art descriptions will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present application, and other drawings can be obtained by those skilled in the art without creative efforts.

Fig. 1 is a schematic diagram of a network architecture provided in an embodiment of the present application;

FIG. 2 is a schematic flow chart diagram of a cost apportionment method provided by an embodiment of the present application;

FIG. 3 is a schematic diagram of a configuration interface of a service attribute tag condition according to an embodiment of the present application;

FIG. 4 is a schematic diagram of a cost apportioning apparatus according to the present application;

fig. 5 is a schematic structural diagram of a computer device provided in the present application.

Detailed Description

In order to make the objects, technical solutions and advantages of the present application more clear, embodiments of the present application will be described in further detail below with reference to the accompanying drawings.

It should be noted that the cost apportionment method provided by the present application is generally executed by a computer device, and accordingly, the cost apportionment device is generally disposed in the computer device.

Fig. 1 shows an exemplary system architecture of a cost apportionment method or a cost apportionment apparatus that can be applied to the present application.

As shown in fig. 1, the system architecture may include: computer device 101 and server 102. Communication between computer device 101 and server 102 may be via a network, which is the medium used to provide the communication links between the various elements described above. The network may include various types of wired or wireless communication links, such as: the wired communication link includes an optical fiber, a twisted pair wire, or a coaxial cable, etc., and the WIreless communication link includes a bluetooth communication link, a WIreless-FIdelity (Wi-Fi) communication link, or a microwave communication link, etc.

A service system is deployed in the server 102, the computer device 101 acquires cost data in the service system by calling an interface to obtain a cost data set, and then identifies cost data to be shared in the cost data set, where the cost data includes the following fields: cost elements, service tags, cost objects, cost collection amounts and cost composition properties; identifying cost data to be apportioned in the cost data set according to field values of the cost composition properties; for each piece of cost data to be apportioned, matching a field value of an apportionment standard in a preset apportionment rule table according to a field value of a cost element, a field value of a cost object and a field value of a service label; and according to the matched field value of the allocation standard, allocating the cost data to be allocated to obtain a cost allocation result.

It should be noted that the computer device 101 and the server 102 may be hardware or software. When the computer device 101 and the server 102 are hardware, they may be implemented as a distributed server cluster composed of a plurality of servers, or may be implemented as a single server. When the computer device 101 and the server 102 are software, they may be implemented as a plurality of software or software modules (for example, to provide distributed services), or may be implemented as a single software or software module, and are not limited in this regard.

Various communication client applications may be installed on the computer device of the present application, for example: video recording application, video playing application, voice interaction application, search application, instant messaging tool, mailbox client, social platform software, etc.

The computer device may be hardware or software. When the computer device is hardware, it may be various computer devices having a display screen, including but not limited to smart phones, tablet computers, laptop portable computers, desktop computers, and the like. When the computer device is software, the above listed computer devices may be installed. Which may be implemented as multiple software or software modules (e.g., to provide distributed services) or as a single software or software module, and is not particularly limited herein.

When the computer equipment is hardware, the computer equipment can also be provided with display equipment and a camera, the display equipment can display various equipment capable of realizing the display function, and the camera is used for collecting video streams; for example: the display device may be a cathode ray tube (CR) display, a light-emitting diode (LED) display, an electronic ink screen, a Liquid Crystal Display (LCD), a Plasma Display Panel (PDP), or the like. A user may utilize a display device on a computer device to view information such as displayed text, pictures, videos, and the like.

It should be understood that the number of computer devices, networks, and servers in fig. 1 is illustrative only. Any number of computer devices, networks, and servers are possible, as desired for an implementation.

The cost sharing method provided by the embodiment of the present application will be described in detail with reference to fig. 2. The cost apportionment device in the embodiment of the present application may be a computer device shown in fig. 1.

Referring to fig. 2, a schematic flow chart of a cost allocation method according to an embodiment of the present application is provided. As shown in fig. 2, the method of the embodiment of the present application may include the steps of:

s201, collecting a cost data set.

In this embodiment, the cost data set includes a plurality of cost data, and the computer device may collect the cost data in an external file or a business system to obtain the cost data set. Providing a form template by the computer equipment, filling the form template by a user, and acquiring each cost data in the filled electronic form by the computer equipment to obtain a cost data set after the filling is finished; or the service system is provided with a calling interface, and the computer equipment acquires the cost data set periodically through the calling interface.

Wherein each cost data in the cost data set comprises field values of the following fields: cost elements, business tags, cost objects, cost aggregate amounts, and cost composition properties. The cost element represents a cost type, such as: the cost elements include: material costs, labor costs, travel costs, power transmission and distribution costs, and the like. The service tag represents an identity of an item, different items having different service tags, for example: the service label is represented using letters or numbers: item a, item B. The cost object represents the type of business activity, for example: for a power grid enterprise, the business activities of the power grid enterprise are generally divided into five categories of maintenance, operation, marketing, operation support and enterprise management, and the maintenance can be further divided into power transmission operation inspection, power transformation operation and maintenance, power distribution operation inspection and communication equipment operation inspection according to a power transmission and distribution link; marketing can be further subdivided into electric energy metering, power supply service, intelligent power utilization, power utilization business, market and efficiency, namely a sender of cost; when the cost is calculated, each expense needs to be reflected on the business activity, the specific business activity cannot be clearly identified when the cost occurs, and the field value of the cost object is recorded as the composite business activity. The cost-aggregation amount represents the amount of incurred charges. The field values of the cost composition property include: the cost is to be shared and directly collected.

For example, the collected cost data set is shown in table 1.

TABLE 1

Each row in table 1 corresponds to a cost data, and the first row in table 1 corresponds to a field of the cost data: the cost element, the service tag, the cost object, the cost collection amount, and the cost composition property, and the 2 nd to 4 th rows in table 1 correspond to field values of the fields included in the cost data, respectively.

S202, identifying cost data to be shared in the cost data set according to the field values of the cost composition properties.

In the present embodiment, the cost data in the cost data set is divided into the cost data to be apportioned and the direct aggregation cost data according to the field value of the cost constituent property, and the field values of the cost constituent property of the cost data to be apportioned and the direct aggregation cost data are different.

S203, for each piece of cost data to be apportioned, matching a field value of an apportionment standard in a preset apportionment rule table according to a field value of a cost element, a field value of a cost object and a field value of a service label.

In this embodiment, the computer device prestores or preconfigures an apportionment rule table, the apportionment rule table stores mapping relationships among the cost elements, the cost objects, and the apportionment criteria, and the apportionment rule table queries the matched apportionment criteria according to field values of the cost elements, the cost objects, and the service tags in the to-be-apportioned cost data. The apportionment rule data includes the following fields: service label, service attribute, rule name, cost element, cost object, beneficiary, allocation standard and service attribute label condition.

Further, before S201, the computer device configures the apportionment rule table based on the configuration instruction of the user, so that the user can flexibly set the cost apportionment rules of different projects according to the actual scene.

Further, the apportionment rule table includes a first sub-table and a second sub-table, the first sub-table includes the following fields: a service label and a service attribute, the second sub-table comprising the following fields: rule names, cost elements, cost objects, beneficiaries, contribution criteria, and business attribute label conditions. The computer equipment analyzes the cost data to be apportioned to obtain a field value of the cost element, a field value of the cost object and a field value of the service label, firstly, a field value of a corresponding service attribute (item classification) is inquired in a first sub-table according to the field value of the service label, and then, a field value of a corresponding apportionment standard is inquired in a second sub-table according to the field value of the cost element, the field value of the cost object and the field value of the inquired service attribute (item classification).

See, for example, the first sub-table shown in table 2 and the second sub-table shown in table 3.

Service labeling: item	Service attribute: item classification
		Item A	Power transformation operation inspection
Item B	Marketing and marketing system

TABLE 2

TABLE 3

Assuming that a computer device analyzes certain to-be-apportioned cost data to obtain that a field value of a service label is "item a", a field value of a cost element is "power transmission and distribution cost", and a field value of a cost object is "composite service activity", first, a field value of a corresponding item classification is queried in table 2 according to the item a to be "power transmission and distribution inspection", and then, a field value of a corresponding apportionment criterion is queried in table 3 according to the "power transmission and distribution cost", the "composite service activity", and the "power transmission and distribution inspection" to be "according to a fixed apportionment coefficient of 1:1".

Assuming that the field value of a service tag obtained by analyzing certain cost data to be apportioned by the computer device is "item B", the field value of a cost element is "power transmission and distribution cost", and the field value of a cost object is "composite business activity", first, the field value of the corresponding item classification is queried in table 2 according to "item a" as "marketing and distribution type", and then the field value of the corresponding apportionment criterion is queried in table 3 according to "power transmission and distribution cost", "composite business activity", and "marketing type" as "according to a fixed apportionment coefficient 3:7".

The computer equipment matches the cost data to be apportioned in the apportionment rule table to obtain corresponding cost apportionment rule data, wherein the cost apportionment rule data comprise the following fields: cost elements, service labels, cost objects, amounts to be apportioned and apportionment criteria.

For example: the cost apportionment data obtained by matching is shown in table 4, and each row in table 4 corresponds to one cost apportionment rule data.

TABLE 4

Further, for the field values of the service attribute tag conditions in each row in table 3, the user may configure the field values through the user interface, the number of the field values of the service attribute tag conditions configured by the user may be one or more, and when the number of the field values is more, the connection may be performed through the "and" logical connector.

For example, referring to the configuration interface of the service attribute tag condition shown in fig. 3, when a user double-clicks a cell of the service attribute tag condition in table 3 through a mouse, the configuration interface shown in fig. 3 is displayed, and then the user inputs a field value in the configuration interface through the input device, and further, the user may perform addition, deletion, and removal operations on the input field value.

And S204, allocating the cost data to be allocated according to the matched field value of the allocation standard to obtain a cost allocation result.

The field value of the apportionment standard represents the apportionment proportion of each beneficiary, the cost aggregation amount in the to-be-apportioned cost data is apportioned according to the field value of the apportionment standard, and the cost apportionment result comprises the following fields: cost elements, business labels, cost before apportionment objects, cost after apportionment objects and apportionment amounts.

For example: the computer device performs allocation according to the data of the cost to be allocated in table 1 by using the field value of the allocation standard in table 4 to obtain the cost allocation result shown in table 5, where rows 2 to 3 in table 5 indicate two cost allocation results after allocating the item a, and rows 4 to 5 indicate two cost allocation results after allocating the item B.

TABLE 5

The embodiment of the application identifies the cost data to be apportioned through the field values of the cost composition properties in the cost data, then matches the corresponding field values of the apportionment standards in the preset apportionment rule table according to the field values of the cost elements, the cost object and the service tags, and automatically apportions the cost according to the field values of the apportionment standards, so that the refined automatic cost apportionment through three dimensions of the cost elements, the cost object and the service tags is realized, and the accuracy of the cost apportionment and the efficiency of the cost apportionment are improved.

The following are embodiments of the apparatus of the present application that may be used to perform embodiments of the method of the present application. For details which are not disclosed in the embodiments of the apparatus of the present application, reference is made to the embodiments of the method of the present application.

Referring to fig. 4, a schematic structural diagram of a cost sharing apparatus provided in an exemplary embodiment of the present application is shown, which is hereinafter referred to as apparatus 4. The apparatus 4 may be implemented as all or part of a computer device, in software, hardware or a combination of both. The device 4 comprises: the device comprises an acquisition unit 401, a recognition unit 402, a matching unit 403 and an apportioning unit 404.

An acquisition unit 401 for acquiring a cost data set; wherein the cost data set comprises a plurality of cost data, the cost data comprising the following fields: cost elements, service tags, cost objects, cost collection amounts and cost composition properties;

an identifying unit 402, configured to identify cost data to be apportioned in the cost data set according to a field value of a cost composition property;

a matching unit 403, configured to match, for each piece of cost data to be apportioned, a field value of an apportionment criterion in a preset apportionment rule table according to a field value of the cost element, a field value of the cost object, and a field value of the service tag;

and an apportioning unit 404, configured to apportion the cost data to be apportioned according to the field value of the matched apportioning criterion to obtain a cost apportioning result.

In one or more possible embodiments, the apportionment rule table includes a first sub-table and a second sub-table;

wherein, the matching of the field value of the apportionment criteria in the preset apportionment rule table according to the field value of the cost element, the field value of the cost object and the field value of the service label comprises:

matching a field value of a corresponding service attribute in the first sub-table according to a field value of a service label;

and matching a corresponding field value of the apportionment standard in the second sub-table according to the matched field value of the business attribute, the field value of the cost element and the field value of the cost object.

In one or more possible embodiments, further comprising:

the configuration unit is used for configuring the cost apportionment rule table; the cost apportionment rule table comprises a plurality of cost apportionment rule data, and the cost apportionment rule data comprises the following fields: rule name, cost factor, sender, beneficiary, contribution criteria, service attribute label condition.

In one or more possible embodiments, when the number of field values of the service attribute tag condition is plural, the plural field values are spaced by a logical connector "and".

In one or more possible embodiments, the configuration unit is further configured to:

displaying a configuration interface based on a triggering instruction of a user to the cell corresponding to the service attribute label condition;

and adding, deleting or modifying the field value of the service attribute label condition based on the configuration instruction of the user to the configuration interface.

In one or more possible embodiments, the cost apportionment result includes the following fields: cost factors, business labels, pre-apportionment cost objects, post-apportionment cost objects, and apportioned amounts.

In one or more possible embodiments, the collecting cost dataset comprises:

collecting a cost data set in a file; or;

and acquiring a cost data set in the business system by calling the interface.

It should be noted that, when the apparatus 4 provided in the above embodiment executes the cost sharing method, only the division of the above functional modules is taken as an example, and in practical applications, the above function distribution may be completed by different functional modules according to needs, that is, the internal structure of the device may be divided into different functional modules to complete all or part of the above functions. In addition, the cost apportionment device and the cost apportionment method provided by the above embodiments belong to the same concept, and the details of the implementation process are referred to in the method embodiments, and are not described herein again.

The above-mentioned serial numbers of the embodiments of the present application are merely for description, and do not represent the advantages and disadvantages of the embodiments.

An embodiment of the present application further provides a computer storage medium, where the computer storage medium may store a plurality of instructions, where the instructions are suitable for being loaded by a processor and executing the method steps in the embodiment shown in fig. 2, and a specific execution process may refer to a specific description of the embodiment shown in fig. 2, which is not described herein again.

The present application further provides a computer program product having at least one instruction stored thereon, the at least one instruction being loaded and executed by the processor to implement the cost apportionment method as described in the various embodiments above.

Referring to fig. 5, a schematic structural diagram of a computer device is provided in an embodiment of the present application. As shown in fig. 5, the computer device 500 may include: at least one processor 501, at least one network interface 504, a user interface 503, memory 505, at least one communication bus 502.

Wherein a communication bus 502 is used to enable connective communication between these components.

The user interface 503 may include a Display screen (Display) and a Camera (Camera), and the optional user interface 503 may also include a standard wired interface and a wireless interface.

The network interface 504 may optionally include a standard wired interface, a wireless interface (e.g., WI-FI interface), among others.

Processor 501 may include one or more processing cores, among other things. The processor 501 interfaces with various components throughout the computer device 500 using various interfaces and lines to perform various functions of the computer device 500 and process data by executing or executing instructions, programs, code sets, or instruction sets stored in the memory 505 and invoking data stored in the memory 505. Optionally, the processor 501 may be implemented in at least one hardware form of Digital Signal Processing (DSP), field-Programmable Gate Array (FPGA), and Programmable Logic Array (PLA). The processor 501 may integrate one or more of a Central Processing Unit (CPU), a Graphics Processing Unit (GPU), a modem, and the like. Wherein, the CPU mainly processes an operating system, a user interface, an application program and the like; the GPU is used for rendering and drawing the content required to be displayed by the display screen; the modem is used to handle wireless communications. It is understood that the modem may not be integrated into the processor 501, but may be implemented by a single chip.

The Memory 505 may include a Random Access Memory (RAM) or a Read-Only Memory (Read-Only Memory). Optionally, the memory 505 includes a non-transitory computer-readable medium. The memory 505 may be used to store instructions, programs, code sets, or instruction sets. The memory 505 may include a stored program area and a stored data area, wherein the stored program area may store instructions for implementing an operating system, instructions for at least one function (such as a touch function, a sound playing function, an image playing function, etc.), instructions for implementing the various method embodiments described above, and the like; the storage data area may store data and the like referred to in the above respective method embodiments. The memory 505 may alternatively be at least one memory device located remotely from the processor 501. As shown in fig. 5, the memory 505, which is a type of computer storage medium, may include therein an operating system, a network communication module, a user interface module, and an application program.

In the computer device 500 shown in fig. 5, the user interface 503 is mainly used as an interface for providing input for a user, and acquiring data input by the user; the processor 501 may be configured to call the application program stored in the memory 505 and specifically execute the method shown in fig. 2, and the specific process may refer to fig. 2 and is not described herein again.

It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by a computer program, which can be stored in a computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. The storage medium may be a magnetic disk, an optical disk, a read-only memory or a random access memory.

The above disclosure is only for the purpose of illustrating the preferred embodiments of the present application and is not to be construed as limiting the scope of the present application, so that the present application is not limited thereto, and all equivalent variations and modifications can be made to the present application.

Claims

1. A method of cost sharing, comprising:

for each piece of cost data to be apportioned, matching field values of apportionment standards in a preset apportionment rule table according to field values of cost elements, field values of cost objects and field values of service labels;

2. The method of claim 1, wherein the apportionment rule table comprises a first sub-table and a second sub-table;

and matching the field value of the corresponding apportionment standard in the second sub-table according to the matched field value of the business attribute, the field value of the cost element and the field value of the cost object.

3. The method of claim 1 or 2, further comprising:

configuring a cost allocation rule table; the cost apportionment rule table comprises a plurality of cost apportionment rule data, and the cost apportionment rule data comprises the following fields: rule name, cost element, sender, beneficiary, contribution standard, service attribute label condition.

4. The method as claimed in claim 3, wherein when the number of the field values of the service attribute tag condition is plural, the plural field values are spaced by a logical connector "and".

5. The method of claim 3, further comprising:

6. The method according to claim 1 or 2 or 4 or 5, wherein the cost apportionment result comprises the following fields: cost factors, business labels, pre-apportionment cost objects, post-apportionment cost objects, and apportioned amounts.

7. The method of claim 6, wherein collecting the cost data set comprises:

collecting a cost data set in a file; or;

and acquiring a cost data set in the business system by calling the interface.

8. A cost apportioning apparatus, comprising:

an acquisition unit for acquiring a cost data set; wherein the cost data set comprises a plurality of cost data, the cost data comprising the following fields: cost elements, service labels, cost objects, cost collection amounts and cost composition properties;

and the apportioning unit is used for apportioning the cost data to be apportioned according to the matched field value of the apportioning standard to obtain a cost apportioning result.

9. A computer storage medium, characterized in that it stores a plurality of instructions adapted to be loaded by a processor and to perform the method steps according to any one of claims 1 to 7.

10. A computer device, comprising: a processor and a memory; wherein the memory stores a computer program adapted to be loaded by the processor and to perform the method steps of any of claims 1 to 7.