JP2018077695A - Device, method and program for executing proportional division processing - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a device, method and program for executing proportional division processing that can perform proportional division processing in the order from a distribution destination with a higher priority order.SOLUTION: In the present embodiment, a priority order detection part 102a detects a priority order in priority order data storing a priority order corresponding to a combination of a distribution source detail and a distribution destination detail, and a proportional division processing execution part 102b executes proportional division processing and calculates a proportional division value, based on a distribution destination set value the distribution destination detail corresponding to the detected priority order includes and a distribution source value the distribution source detail corresponding to the detected priority order includes.SELECTED DRAWING: Figure 1

Description

  The present invention relates to an apportionment process execution device, an apportionment process execution method, and an apportionment process execution program.

  In Patent Document 1, the dividend amount for each claim right is calculated by calculating the dividend for the auction amount associated with the auction based on the relevant laws such as the Civil Code for real estate properties such as land and buildings, or calculating the expected dividend based on the expected target property price. An auction dividend calculation method for automatic calculation is disclosed (see paragraph 0001 and the like).

JP 2004-280857 A

  As described above, when paying or distributing a monetary amount or the like, there may be a priority as to which company or individual or the like should prioritize the allocation. In this case, there is a need for a mechanism that can perform distribution processing in consideration of the priority of distribution destinations and perform distribution to each distribution destination.

  The present invention has been made in view of the above, and provides an apportionment process execution device, an apportionment process execution method, and an apportionment process execution program that can perform an apportionment process in order from a distribution destination having a higher priority.

  In order to solve the above-described problems and achieve the object, the apportionment processing execution device according to the present invention is an apportionment processing execution device including a control unit and a storage unit, and the storage unit includes distribution source information, Allocation source detail data storing allocation source details including allocation source details including distribution source details, allocation destination information, and allocation destination setting values corresponding thereto. And priority data for storing the priority corresponding to the combination of the distribution source specification and the distribution destination specification, and the control unit detects the priority in the priority data. The apportionment processing is executed based on the rank detection means, the distribution destination setting value included in the distribution destination details corresponding to the detected priority order, and the distribution source value included in the distribution source details corresponding to the detected priority order And calculate the apportionment value Further comprising a process execution means, and characterized.

  Further, in the apportionment processing execution device according to the present invention, the storage unit further stores a weighting value master for storing a weighting value for the calculated apportioned value, and the control unit has the calculated apportioning value and And weighting calculation execution means for executing weighting calculation based on the weighting value included in the weighting value master.

  In the apportionment processing execution apparatus according to the present invention, the storage unit further stores a calculation method master that stores a plurality of calculation methods for calculating an apportioned value, and the control unit includes the calculation method. It further comprises comparison display means for comparing and displaying a plurality of proportional values calculated based on a plurality of calculation methods included in the master.

  Further, the apportionment processing execution device according to the present invention includes a calculation method master that stores a plurality of calculation methods for calculating apportioned values in the storage unit, and a plurality of calculation methods calculated based on the plurality of calculation methods. A selection condition master for storing a predetermined selection condition for the apportioned value, and the control unit stores the selection condition master among a plurality of calculation methods included in the calculation method master. It is further characterized by further comprising a calculation method determination means for determining a calculation method capable of calculating a prorated value that satisfies a predetermined selection condition included.

  The apportioning process execution method according to the present invention is an apportioning process execution method executed by an information processing apparatus including a control unit and a storage unit, and the storage unit corresponds to distribution source information and the distribution source information. Distribution source details data that stores distribution source details including distribution source values, distribution destination information including distribution destination information and distribution destination setting values corresponding to the distribution destination details, and the distribution Priority order data for storing priority orders corresponding to combinations of the original details and the distribution destination details, and a priority order for detecting a priority order in the priority order data, which is executed by the control unit Based on the detection step, the allocation destination setting value included in the allocation destination details corresponding to the detected priority order, and the allocation source value included in the allocation source details corresponding to the detected priority order, the apportioning process is executed. , Calculate apportionment values It includes process execution step, and characterized.

  Further, the apportionment process execution program according to the present invention is an apportionment process execution program for causing an information processing apparatus including a control unit and a storage unit to execute, and the storage unit includes distribution source information and corresponding to this Distribution source details data for storing distribution source details data including distribution source details including distribution destination information, distribution destination information, and distribution destination setting values corresponding thereto. Priority data for storing the priority corresponding to the combination of the distribution source specification and the distribution destination specification is stored, and the priority in the priority data to be executed by the control unit is detected. Based on the priority order detection step, the distribution destination setting value included in the distribution destination details corresponding to the detected priority order, and the distribution source value included in the distribution source details corresponding to the detected priority order, the apportioning process is performed. Fruit And, include a proportional division process execution step of calculating the prorated, and characterized.

  According to the present invention, it is possible to perform an apportionment process in order from an allocation destination having a higher priority.

FIG. 1 is a block diagram illustrating an example of a configuration of a prorated processing execution device. FIG. 2 is a diagram illustrating an example of information stored in the storage unit 106 and information to be created. FIG. 3 is a diagram illustrating an example of an input screen and an output screen for apportionment processing. FIG. 4 is a diagram illustrating an example of a distribution process using an average distribution method. FIG. 5 is a diagram illustrating an example of a proportional distribution process using the proportional distribution method. FIG. 6 is a diagram illustrating an example of a proportional distribution process using the proportional distribution method. FIG. 7 is a diagram illustrating an example of an output screen for a proportional distribution process by weighting calculation.

  DESCRIPTION OF EMBODIMENTS Embodiments of an apportionment process execution device, an apportionment process execution method, and an apportionment process execution program according to the present invention will be described below in detail with reference to the drawings. In addition, this invention is not limited by this embodiment.

[1. Overview]
When allocating people, things, money, etc. to each allocation destination, a simulation of the allocation result may be necessary. In addition, there may be a priority of which distribution destination is to be preferentially allocated.

  Conventionally, this simulation has not been automated, and the simulation has been performed manually, which requires a lot of labor and labor. In particular, when there is a priority according to each distribution destination, a complicated work of performing distribution in order from the distribution destination with the highest priority is further required.

  Therefore, in this embodiment, for example, in a large number of matrices including one or more distribution source details in a column and one or more distribution destination details in a row, apportionment processing and distribution are performed in descending order of priority. The apportioning process execution device, apportioning process execution method, and apportioning process execution program are provided.

  In the present embodiment, for example, an apportionment process execution device, an apportionment process execution method, and an apportionment process execution program that can calculate an apportionment value in consideration of the weighting by setting a weighting to the apportionment value in advance is provided.

  In the present embodiment, for example, an apportioning process execution device, an apportioning process execution method, and an apportioning process execution program that can hold a plurality of calculation formulas for calculating a distribution value and that can hold an operator's own customization settings. Is provided.

  Further, in the present embodiment, for example, the distribution values calculated from the plurality of held formulas are distributed to the maximum value, the intermediate value, and the minimum value before output, and a value desired by the operator (for example, the maximum value) An apportioning process execution device, an apportioning process execution method, and an apportioning process execution program are provided. Hereinafter, a specific configuration and operation will be described.

[2. Constitution]
The configuration of the apportionment processing execution apparatus 100 according to the present embodiment will be described with reference to FIG. FIG. 1 is a block diagram illustrating an example of the configuration of the apportionment processing execution apparatus 100.

  The apportioning process execution device 100 is a commercially available desktop personal computer. The apportioning processing execution apparatus 100 is not limited to a stationary information processing apparatus such as a desktop personal computer, but is a portable personal computer such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer. It may be a type information processing apparatus.

  As shown in FIG. 1, the apportionment processing execution apparatus 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each unit included in the apportioning process execution device 100 is connected to be communicable via an arbitrary communication path.

  The communication interface unit 104 communicatively connects the apportionment processing execution device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via a communication line. Here, the network 300 has a function of connecting the apportioning processing execution apparatus 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). Note that data stored in the storage unit 106 to be described later may be stored in the server 200.

  An input device 112 and an output device 114 are connected to the input / output interface unit 108. As the output device 114, a speaker (including a home television), a speaker, and a printer can be used. As the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that realizes a pointing device function in cooperation with the mouse can be used. In the following description, the output device 114 may be described as the monitor 114, and the input device 112 may be described as the keyboard 112 or the mouse 112.

  The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 stores a computer program for giving various instructions to a CPU (Central Processing Unit) in cooperation with an OS (Operating System). As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) and a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, and an optical disk can be used.

  The storage unit 106 includes a D distribution source description 106a as distribution source detailed data, a D distribution destination specification 106b as distribution destination detailed data, a D distribution priority 106c as priority data, a weight value master, and a calculation method master. And an M calculation method 106e as a selection condition master.

  The D distribution source details 106a store distribution source details including distribution source information and distribution source values corresponding to the distribution source information. The allocation source information includes a land name, a right name, an organization name such as a company name, a person name, a project name, and the like as an allocation source. The distribution source value is a numerical value such as the amount of money, area, time, etc. included in each distribution source information. The distribution source specification means one combination of distribution source information and a distribution source value corresponding to the distribution source information (for example, distribution source information = land A, distribution source value = 20 million yen). The number of allocation source details may be one or more, but the apportionment processing execution apparatus 100 according to the present embodiment also includes a case where there are a large number of allocation source details (for example, from land A to land E). The apportioning process can be executed efficiently.

  The D distribution destination description 106b stores distribution destination details including distribution destination information and distribution destination setting values corresponding to the distribution destination information. The allocation destination information is an organization name such as the name of a company that is an allocation destination, a person's name, and the like. The distribution destination setting value is an upper limit value that can be distributed to each distribution destination, and the types of upper limit values are numerical values such as money amount, area, time, and the like. The distribution destination specification means one combination of distribution destination information and a corresponding distribution destination setting value (for example, person name = Tanaka Taro, distribution destination setting value = 20 million yen). Although the number of distribution destination details may be one or more, the apportionment processing execution apparatus 100 according to the present embodiment is efficient even when there are a large number of distribution destination details (for example, there are many personal names, etc.). Prorated processing can be executed.

  The D distribution priority order 106c stores a priority order corresponding to a combination of the distribution source details and the distribution destination details. As will be described later, the apportionment processing execution apparatus 100 according to the present embodiment detects in order from a combination of the distribution source details and the distribution destination details having a high priority, performs an apportionment process, and performs each distribution destination. Make an allocation.

  Here, the specific contents of the D distribution source specification 106a, the D distribution destination specification 106b, and the D distribution priority 106c will be described by dividing the apportionment processing execution apparatus 100 according to the present embodiment into applicable scenes.

  An example of an application scene is a scene where a financial institution calculates its share of real estate collateral. In this case, the allocation source information is the name of each real estate collateral, the allocation source value is the value (amount) of each real estate collateral, the allocation destination information is each financial institution, and the allocation destination set value is the allocation of each financial institution. The maximum amount.

Another example of application is when a financial institution makes a self-assessment. In this case, the allocation source information is receivable information, the allocation source value is the receivable balance, and the allocation destination information is
It becomes collateral guarantee information, and the allocation destination setting value is the collateral guarantee amount. With the above combination, it is possible to simulate the security allocation of security guarantees.

  As another example of application, there is a scene in which a real estate developer calculates the ratio of development land rights according to the investment funds from a company. In this case, the allocation source information is each company, the allocation source value is the investment amount of each company, the allocation destination information is land information, and the allocation destination setting value is the allocation upper limit area of each land.

  As another example of the application scene, there is a scene where the company or the like wants to evaluate the contribution degree of the employee to the company by the working time. In this case, the allocation source information is each project, the allocation source value is the gross profit in each project, the allocation destination information is each employee, and the allocation destination setting value is the working time of each employee.

  The M calculation method 106e stores a plurality of calculation methods for calculating a weighted value and a prorated value for the calculated apportioned value.

  The weighting value for the calculated apportioned value is a value that can be set in advance by the operator in order to increase or decrease only the apportioned value for a specific distribution destination after the apportionment value is calculated. For example, if there are Company A, Company B, and Company C as distribution destinations, and the market value of Company A is high and it is desired to perform distribution preferentially, the weight for Company A is set to x1.5. In this case, only the apportionment value for company A can be increased by a factor of 1.5. In addition, the reference | standard at the time of setting a weight is not limited to such marketability, For example, you may consider the past business performance of a distribution destination, regionality, etc. The weighting value may or may not be stored in the storage unit 106, but is stored because it is information that the weighting calculation execution unit 102c described later refers to when performing weighting calculation. Is preferred.

  Examples of a plurality of calculation methods for calculating the apportioned value include an average apportioning method, a proportional apportioning method, and customization settings. Details of the processing of the average apportioning method and the proportional apportioning method are as described in [3. Specific Example of Processing] will be described. Customization settings are calculation conditions that can be freely set by the operator. For example, setting the allocation source details or allocation destination details that give priority to the apportionment process, or rounding off or rounding off the apportionment values. You can set it. The plurality of calculation methods may or may not be stored in the storage unit 106. However, since the comparison display unit 102d described later is information that is referred to when comparing and displaying a plurality of proportional values, Since it is information to be referred to when the calculation method determination unit 102e described later determines the calculation method, it is preferably stored.

  The M calculation determination 106f stores predetermined selection conditions for a plurality of apportioned values calculated based on the plurality of calculation methods. As the predetermined selection condition, for example, a maximum value, an intermediate value, a minimum value, and the like among the plurality of proportional values can be set. The M calculation determination 106f may or may not be stored in the storage unit 106, but is stored because it is information that the calculation method determination unit 102e described later refers to when determining the calculation method. It is preferable.

  The control unit 102 is a CPU or the like that comprehensively controls the apportioning process execution device 100. The control unit 102 has an internal memory for storing a control program such as an OS, a program that defines various processing procedures, and necessary data, and performs various information processing based on these stored programs. Run. The control unit 102 is functionally conceptually (1) a priority level detection unit 102a as a priority level detection unit for detecting a priority level in the priority level data, and (2) a distribution destination corresponding to the detected priority level. The apportioning process is performed as an apportioning process execution means for executing an apportionment process and calculating an apportionment value based on the apportionment destination setting value included in the item and the apportionment source value included in the apportionment source item corresponding to the detected priority order. An execution unit 102b; and (3) a weight calculation execution unit 102c as a weight calculation execution unit that executes weight calculation based on the calculated apportioned value and the weight value included in the weight value master; (4 A comparison display unit 102d as comparison display means for comparing and displaying a plurality of proportional values calculated based on a plurality of calculation methods included in the calculation method master; and (5) the calculation method A calculation method determination unit 102e as a calculation method determination unit for determining a calculation method capable of calculating a prorated value satisfying a predetermined selection condition included in the selection condition master from a plurality of calculation methods included in the star; I have. Among these, the weighting calculation execution unit 102c, the comparison display unit 102d, and the calculation method determination unit 102e are optional components, but are preferably included in the control unit 102 for the reason described below.

  Hereinafter, the content of the process which the apportioning process execution apparatus 100 which concerns on this embodiment performs is demonstrated. As an outline of the processing, as shown in FIG. 2, a D distribution result specification is created based on the D distribution source specification 106a, the D distribution destination specification 106b, and the D distribution priority 106c. In addition, when the M calculation method 106e and the M calculation determination 106f, which are optional components, exist, in addition to the D distribution result details, a D distribution result header is created. Hereinafter, the contents of the process will be described in more detail with reference to FIGS. FIG. 3 is a diagram illustrating an example of an input screen and an output screen for apportionment processing. FIG. 7 is a diagram illustrating an example of weighting calculation.

(Priority detection process)
The priority level detection unit 102a performs a priority level detection process for detecting a priority level in the D distribution priority level 106c.

  Specifically, in the input screen in the left diagram of FIG. 3, there are three allocation source details (1) to (3) in the column, and two allocation destination details (1) to (2) in the row. . Therefore, there are 3 × 2 = 6 matrices. When the operator registers the priority order in these six matrices and selects “Calculation execution”, the priority order detection unit 102a selects three matrices in which the priority order “1” is described among these matrices. To detect.

(Proportional processing)
The apportioning process execution unit 102b performs an apportioning process based on the allocation destination setting value included in the allocation destination details corresponding to the detected priority and the allocation source value included in the allocation source details corresponding to the detected priority. To execute a distribution process for calculating a distribution value.

  Specifically, a prorated value is calculated for three matrices in which the priority order “1” is described. Here, the distribution destination setting value included in the distribution destination specification (1) corresponding to the detected priority “1” is 2000. On the other hand, the distribution source values included in the distribution source details (1) to (3) corresponding to the detected priority “1” are 4000, 2000, and 2000, respectively.

  The apportioning process execution unit 102b calculates the allocation destination setting value 2000 × allocation source value 4000 / (4000 + 2000 + 2000) = 1000 for the distribution destination details in the row and the allocation source details in the column = “detail (1) / detail (1)”. To do. Similarly, “detail (1) • detail (2)” and “detail (1) • detail (3)” are calculated as allocation destination setting value 2000 × distribution source value 2000 / (4000 + 2000 + 2000) = 500. The apportioned value that is the distribution result is shown on the output screen in the right diagram of FIG. In this way, the apportioning process execution device 100 ends all the processes related to the priority “1”.

  Subsequently, the apportioning process execution apparatus 100 similarly performs the following apportioning process after performing the priority order detecting process for the three matrices in which the priority order “2” is described. That is, the remaining amounts of the allocation source details (1) to (3) are 4000-1000 = 3000, 2000-500 = 1500, and 2000-500 = 1500, respectively, and these are the surplus amounts. Using this surplus amount 3000, the apportioning process execution unit 102b sets the allocation destination setting value 1000 × the surplus power amount 3000 / with respect to the allocation destination details in the row and the allocation source details in the column = “detail (2) / detail (1)”. Calculate as (3000 + 1500 + 1500) = 500. Similarly, for “detail (2) • detail (2)” and “detail (2) • detail (3)”, the allocation destination setting value 1000 × the amount of surplus power 1500 / (3000 + 1500 + 1500) = 250 is calculated. In this way, the apportionment processing execution apparatus 100 ends all the processes related to the priority “2”. The apportioning process execution device 100 may perform the priority detection process and the apportioning process in a similar manner when the priority order “3” or higher exists (not shown).

  In this example, first, priority detection processing and apportioning processing are performed for priority “1”, and then priority detection processing and apportioning processing are performed for priority “2”. In the same manner, the case where repeated processing is performed in units of priority has been described. However, the process performed by the apportioning process execution device 100 is not limited to this. For example, for all priorities, only the priority detection process is performed first, and then the apportioning process is performed for the detected priorities. Similarly, the priority detection process and the apportionment process may be performed in completely separate steps.

  As described above, according to the apportionment processing execution apparatus 100 according to the present embodiment, since it is possible to perform the apportionment processing in order from the distribution destination with the highest priority, each distribution destination is considered in consideration of the priority for each distribution destination. Can be distributed accurately and easily.

(Weighting calculation execution process)
The weighting calculation execution unit 102c performs weighting calculation execution processing for executing weighting calculation based on the calculated apportioned value and the weighting value included in the M calculation method 106e.

  Specifically, a case will be described in which 1.5 times is set as the weighting value for the apportioned value in the distribution destination specification (1) in the right diagram of FIG. In the distribution destination specification (1) on the right side of FIG. 3, the distribution destination setting value is 2000, and the apportionment values are 1000, 500, and 500 in order from the top. When 1.5 times is set as the weighting value, these values are all multiplied by 1.5. The result is shown in FIG. FIG. 7 is a diagram illustrating an example of an output screen for a proportional distribution process by weighting calculation. As shown in the allocation destination details (1) in FIG. 7, the allocation destination setting value is 3000, and the apportionment values are 1500, 750, and 750 in order from the top.

  Subsequently, a distribution process is performed for the three matrices of the distribution destination details (2) for which no weighting value is set. The calculation method is the same as the calculation performed for the three matrices in which the priority “2” in FIG. 3 is described. Therefore, the explanation is omitted, but the apportioned value is the distribution destination specification (2) in FIG. As shown in FIG.

  As described above, if the apportioning process execution device 100 according to the present embodiment includes the weighting calculation execution unit 102c, it is possible to perform calculation in consideration of weighting. For this reason, although the weighting calculation execution part 102c is an arbitrary component, it is preferable to be included in the apportionment processing execution apparatus 100 which concerns on this embodiment.

(Comparison display processing)
The comparison display unit 102d performs comparison display processing for comparing and displaying a plurality of proportional values calculated based on a plurality of calculation methods included in the M calculation method 106e.

  Specifically, the right side of FIG. 3 shows the apportioned value when the average apportioning method is used as the calculation method, but the comparison display unit 102d also displays the proportional apportioning method and customization settings. The apportioned value when apportioning processing is performed using can also be displayed in comparison. Note that the object to be compared and displayed by the comparison display unit 102d is not limited to a plurality of apportioned values calculated based on a plurality of calculation methods, and may be apportioned values calculated by the above-described weighting calculation, for example.

  As described above, if the apportioning process execution device 100 according to the present embodiment includes the comparison display unit 102d, the operator can simultaneously refer to a plurality of apportioned values calculated based on a plurality of calculating methods. For this reason, the comparison display unit 102d is an arbitrary component, but is preferably included in the apportioning process execution device 100 according to the present embodiment.

(Calculation method judgment process)
The calculation method determination unit 102e performs a calculation method determination process for determining a calculation method capable of calculating a prorated value that satisfies a predetermined condition included in the M calculation determination 106f from among a plurality of calculation methods included in the M calculation method 106e. Do.

  Specifically, the M calculation method 106e includes three calculation methods: an average distribution method, a proportional distribution method, and customization settings. The distribution values calculated by each calculation method are 1000, Suppose 500 and 250. Further, it is assumed that the maximum value is set as the predetermined selection condition in the M calculation determination 106f. In this case, the calculation method determination unit 102e determines that the calculation method capable of calculating 1000, which is the maximum value among the three distribution values, is the average distribution method. The predetermined sorting condition (maximum value) and the determined calculation method (average apportioning method) may be displayed on the output screen as shown in the upper left header portion of the right diagram of FIG.

  As described above, when the apportioning process execution device 100 according to the present embodiment includes the calculation method determination unit 102e, the operator can set a desired condition when a plurality of apportionment values are calculated based on a plurality of calculation methods. Only the apportioned values that apply can be referenced. For this reason, the calculation method determination unit 102e is an arbitrary component, but is preferably included in the apportioning process execution device 100 according to the present embodiment.

[3. Specific example of processing]
As a specific example of the processing according to the present embodiment, an apportioning process using an average apportioning method and an apportioning process using a proportional apportioning method will be described with reference to FIGS. 4 to 6, column codes (detail (1), detail A, etc.) correspond to allocation source information, column property prices correspond to allocation source values, and row codes (detail ( 1), etc.) correspond to the distribution destination information, and the numbers in the row ((root) 50,000, etc.) correspond to the distribution destination setting value. In each matrix, the upper row shows the maintenance amount (prorated value), and the filled lower row shows the remaining amount (prorated value-maintenance amount).

[3-1. Average apportioning method]
First, a specific example of the apportioning process using the average apportioning method will be described with reference to FIG. FIG. 4 is a diagram illustrating an example of a distribution process using an average distribution method.

(First rank calculation)
First, the priority order detection unit 102a detects a matrix having the first priority order in the table shown in FIG. The matrix with the highest priority is the row allocation details / column allocation source details = “detail (1) / detail (1)”, “detail (1) / detail (2)”, “detail (1)”・ Detail (3), “Detail (2), Detail C”, “Detail (3), Detail A”, “Detail (4), Detail B”. The apportioning process execution unit 102b executes the following apportioning process for each matrix.

  A description will be given of three matrices whose distribution destination details in the row are the details (1). For “detail (1) / detail (1)”, (root) 50,000 × property price 50,686 / (50,686 + 27,381 + 17,095) = 26,631, which is the maintenance amount at the top of the matrix . The same calculation is performed for "detail (1) / detail (2)" and "detail (1) / detail (3)", and 14,387 and 8,982 are the conservation amounts in the upper part of the matrix, respectively.

  A description will be given of one matrix in which the distribution destination details in the row are the details (2). “Detail (2) / Detail C” is (root) 50,000 × property price 39,552 / 39,552 = 50,000, which exceeds the article price 39,552. For this reason, in the “detail (2) / detail C”, the property price 39,552 is the maintenance amount at the top of the matrix.

  A description will be given of one matrix in which the distribution destination details in the row are the details (3). “Detail (3) / Detail A” is (residual) 3,700 × property price 8,070 / 8,070 = 3,700, which is the maintenance amount at the top of the matrix.

  A description will be given of one matrix in which the distribution destination details in the row are the details (4). “Detail (4) / Detail B” is (root) 47,000 × property price 8,676 / 8,676 = 47,000, which exceeds the article price 8,676. For this reason, in “Detail (4) / Detail B”, the property price 8,676 is the maintenance amount in the upper row of the matrix.

(Second order calculation)
Subsequently, the priority order detection unit 102a detects a matrix having the second highest priority order in the table shown in FIG. The matrix with the second highest priority is the row allocation details / column allocation source details = “detail (2) / detail (1)”, “detail (2) / detail (2)”, “detail (2)”・ Detail (3), “Detail (4), Detail A”, “Detail (4), Detail C”. The apportioning process execution unit 102b executes the following apportioning process for each matrix.

  A description will be given of three matrices in which the distribution destination details in the row are the details (2). Here, with respect to the distribution destination detail (2), 39,552 of the distribution destination setting value (root) of 50,000 have already been allocated in the above-mentioned first rank calculation, so 50,000− 39,552 = 10,448 is the distribution destination setting value in the second rank calculation. For this reason, “detail (2) / detail (1)” is 10,448 × reserved power amount 24,055 / 24,055 + 12,994 + 8,113 = 5,565, which is the maintenance amount in the upper part of the matrix. The same calculation is performed for “detail (2) / detail (2)” and “detail (2) / detail (3)”, and 3,006 and 1,877 are the maintenance amounts in the upper row of the matrix, respectively.

  Description will be given of two matrices whose row allocation details are the details (4). Here, with regard to the distribution destination details (4), in the above-mentioned first rank calculation, among the distribution destination setting value (root) 47,000, 8,676 has already been allocated, so 47,000− 8,676 = 38,324 is the allocation destination setting in the second rank calculation. For this reason, “detail (4) / detail A” is 38,324 × the amount of remaining power 4,370 / 4,370 = 38,324, which exceeds the amount of remaining power 4,370. For this reason, in “Detail (4) / Detail A”, the reserve amount 4,370 is the maintenance amount in the upper row of the matrix. The same calculation is performed for “detail (4) / detail C”, and 0 is the maintenance amount in the upper row of the matrix.

(3rd order calculation)
Subsequently, the priority order detection unit 102a detects the matrix having the third highest priority order in the table shown in FIG. The matrix with the third highest priority is the row allocation details / column allocation source details = “detail (3) / detail (1)”, “detail (3) / detail (2)”, “detail (3)”・ Detail (3) ”is a total of three. The apportioning process execution unit 102b executes the following apportioning process for each matrix.

  A description will be given of three matrices in which the distribution destination details in the row are the details (3). Here, with respect to the distribution destination details (3), the distribution destination setting value is 0 because all of the distribution destination setting values of 3,700 have already been allocated in the above-described first rank calculation. Therefore, for “detail (3) / detail (1)”, 0 is the maintenance amount in the upper row of the matrix. Similarly for “Detail (3) / Detail (2)” and “Detail (3) / Detail (3)”, 0 is the maintenance amount in the upper row of the matrix.

(4th rank calculation)
Subsequently, the priority order detection unit 102a detects the matrix having the fourth priority order in the table shown in FIG. The matrix with the 4th priority is the row allocation details / column allocation source details = “detail (4) / detail (1)”, “detail (4) / detail (2)”, “detail (4) “Detail (3)”. The apportioning process execution unit 102b executes the following apportioning process for each matrix.

  A description will be given of three matrices in which the distribution destination details in the row are the details (4). Here, with regard to the distribution destination details (4), 4,370 and 8,676 have already been allocated among the distribution destination setting values (root) 47,000 in the above-described first rank calculation and second rank calculation. Therefore, 47,000-4,370-8,676 = 33,954 is the distribution destination setting value. For this reason, “detail (4) / detail (1)” is 33,954 × the amount of surplus 18,490 / 18,490 + 9,988 + 6,236 = 18,085, which is the maintenance amount at the top of the matrix. The same calculation is performed for “detail (4) / detail (2)” and “detail (4) / detail (3)”, and 9,769 and 6,100 are the maintenance amounts in the upper part of the matrix, respectively.

[3-2. Proportional proportional distribution method]
Next, a specific example of proportional distribution processing by the proportional distribution method will be described with reference to FIGS. FIG. 5 and FIG. 6 are diagrams illustrating an example of a proportional distribution method using a proportional distribution method. In this proportional apportioning scheme, the priority order is reversed in the rows (for example, in the distribution source specification (3) in FIG. 5, the priority order is not 1 → 2 → 3 from the left, but 2 → 1 → 3). ), The matrix with the reversed priority is turned to the second calculation. In this example, the priority order is reversed, the row allocation details / column allocation source details = “detail (2) / detail (3)”, “detail (2) / detail (4)” 2 For each matrix, the calculation is performed in the second order, and for the other matrices, the calculation is performed in the first order. The first order is the first calculation and the second order is the second calculation, which will be described below.

<First calculation>
In the first calculation, the following calculation is performed for a matrix whose priority is not reversed, and the apportioned values shown in FIG. 5 are obtained. In the same manner as the average apportioning method, the priority detection unit 102a detects a matrix with the first priority, and then the apportionment processing execution unit 102b executes apportioning processing for each of the matrices. When this is completed, the same processing is performed for the matrices with the second and higher priorities in the same manner as the average apportioning method.

<2nd calculation>
In the second calculation, the following calculation is performed for the two matrices whose priorities are reversed, and the distribution values shown in FIG. 6 are obtained. For “detail (2) / detail (3)”, (root) 60,000 × remaining amount of allocation source detail (3) in the first calculation 1,412 / (33,646 + 3,516 + 1,412 + 383) = 2 , 174, which exceeds the amount of reserve 1,412. For this reason, in “Detail (2) / Detail (3)”, the reserve amount 1,412 is the maintenance amount in the upper part of the matrix. The same calculation is performed for “detail (2) / detail (4)”, and 383 is the maintenance amount at the top of the matrix. For “detail (2) / detail (2)”, (root) 60,000 × distribution source value 33,646 / (33,646 + 3,516 + 1,412 + 383) = 51,820 in allocation destination detail (2) However, since this exceeds the distribution source value 33,646, the first calculation result is not changed, and 33,646 is the maintenance amount in the upper part of the matrix. The same calculation is performed for “detail (2) / detail A”, and 3,516 is the maintenance amount at the top of the matrix.

[4. Other Embodiments]
In addition to the above-described embodiments, the present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims.

  For example, among the processes described in the embodiments, all or part of the processes described as being automatically performed can be performed manually, or all of the processes described as being performed manually are all performed. Alternatively, a part can be automatically performed by a known method.

  In addition, the processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each processing, screen examples, and database configurations shown in the present specification and drawings, unless otherwise specified. Can be changed arbitrarily.

  In addition, regarding the apportionment processing execution apparatus 100, each illustrated component is functionally conceptual, and does not necessarily need to be physically configured as illustrated.

  For example, all or any part of the processing functions provided in the apportioning processing execution apparatus 100, particularly the processing functions performed by the control unit 102, are realized by the CPU and a program interpreted and executed by the CPU. It may also be realized as hardware by wired logic. The program is recorded on a non-transitory computer-readable recording medium including a programmed instruction for causing the information processing apparatus to execute the processing described in this embodiment, and apportioning processing is executed as necessary. It is mechanically read by the device 100. In other words, in a storage unit such as a ROM or a HDD (Hard Disk Drive), a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded. This computer program is executed by being loaded into the RAM, and constitutes a control unit in cooperation with the CPU.

  Further, this computer program may be stored in an application program server connected to the apportionment processing execution apparatus 100 via an arbitrary network, and may be downloaded in whole or in part as necessary. It is.

  In addition, a program for executing the processing described in this embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the “recording medium” refers to a memory card, USB (Universal Serial Bus) memory, SD (Secure Digital) card, flexible disk, magneto-optical disk, ROM, EPROM (Erasable Programmable Read Only Memory), EEPROM (registration). Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVD (Digital Digital, Trademark) Any “portable physical media It is intended to include. Therefore, a recording medium storing a program for executing the processing or processing method described in this specification also constitutes the present invention.

  The “program” is a data processing method described in an arbitrary language or description method, and may be in any form such as source code or binary code. Note that the “program” is not necessarily limited to a single configuration, and functions are achieved in cooperation with a separate configuration such as a plurality of modules and libraries or a separate program represented by the OS. Including things. In addition, a well-known structure and procedure can be used about the specific structure and reading procedure for reading a recording medium in each apparatus shown to embodiment, the installation procedure after reading, etc.

  Various databases and the like stored in the storage unit 106 are storage devices such as a memory device such as a RAM and a ROM, a fixed disk device such as a hard disk, a flexible disk, and an optical disk. Programs, tables, databases, web page files, and the like.

  Further, the apportionment processing execution apparatus 100 may be configured as an information processing apparatus such as a known personal computer or workstation, or may be configured as the information processing apparatus to which an arbitrary peripheral device is connected. Further, the apportioning process execution device 100 may be realized by installing software (including a program or data) that realizes the processing described in the present embodiment in the device.

  Furthermore, the specific form of distribution / integration of the devices is not limited to that shown in the figure, and all or a part of them may be functionally or physically in arbitrary units according to various additions or according to functional loads. It can be configured to be distributed and integrated. That is, the above-described embodiments may be arbitrarily combined and may be selectively implemented.

  The present invention is useful in all fields, but is particularly useful in fields such as the real estate industry and the financial industry.

100 Prorated processing execution device
102 Control unit
102a Priority detection unit
102b Prorated processing execution unit
102c Weighting calculation execution unit
102d comparison display section
102e Calculation method determination unit
104 Communication interface
106 Storage unit
106a Allocation source item data
106b Distribution details data
106c Priority data
106d Weight value master
106e Calculation method master
106f Selection condition master
108 Input / output interface
112 Input device
114 Output device 200 Server 300 Network

Claims (6)

An apportionment processing execution device including a control unit and a storage unit,
In the storage unit,
Distribution source item data storing distribution source item information including distribution source information and distribution source values corresponding to the distribution source information,
Distribution destination item data for storing distribution destination details including distribution destination information and distribution destination setting values corresponding to the distribution destination information;
Priority order data for storing priority orders corresponding to combinations of the distribution source details and the distribution destination details;
Is stored,
The controller is
Priority detection means for detecting a priority in the priority data;
Based on the distribution destination setting value included in the distribution destination details corresponding to the detected priority order and the distribution source value included in the distribution source details corresponding to the detected priority order, the distribution process is executed, and the distribution value is calculated. Apportioning processing execution means to be calculated;
Providing
An apportioning process execution device characterized by the above. In the storage unit,
A weight value master for storing a weight value for the calculated apportioned value is further stored;
The controller is
Further comprising weight calculation execution means for executing weight calculation based on the calculated apportioned value and the weight value included in the weight value master;
The apportioning processing execution device according to claim 1. In the storage unit,
A calculation method master that stores a plurality of calculation methods for calculating a prorated value is further stored.
The controller is
A comparison display means for comparing and displaying a plurality of apportioned values calculated based on a plurality of calculation methods included in the calculation method master;
The apportioning processing execution device according to claim 1 or 2, characterized in that: In the storage unit,
A calculation method master that stores a plurality of calculation methods for calculating apportionment values;
A screening condition master that stores predetermined screening conditions for a plurality of apportioned values calculated based on the plurality of calculation methods;
Is further stored,
The controller is
A calculation method determination means for determining a calculation method capable of calculating a prorated value satisfying a predetermined selection condition included in the selection condition master from a plurality of calculation methods included in the calculation method master;
The apportioning processing execution device according to claim 1 or 2, characterized in that: An apportioning process execution method executed by an information processing apparatus including a control unit and a storage unit,
In the storage unit,
Distribution source information, distribution source values corresponding to the distribution source information, distribution source item data for storing the distribution source items to be included,
Allocation destination information, allocation destination setting values corresponding to the allocation destination information, allocation destination details data for storing the allocation destination details,
Priority order data for storing priority orders corresponding to combinations of the distribution source details and the distribution destination details;
Is stored,
Executed by the control unit,
A priority detection step for detecting a priority in the priority data;
Based on the distribution destination setting value included in the distribution destination details corresponding to the detected priority order and the distribution source value included in the distribution source details corresponding to the detected priority order, the distribution process is executed, and the distribution value is calculated. Apportioning process execution step to be calculated;
Including,
A distribution processing execution method characterized by the above. An apportioning process execution program for causing an information processing apparatus including a control unit and a storage unit to execute the program,
In the storage unit,
Distribution source information, distribution source values corresponding to the distribution source information, distribution source item data for storing the distribution source items to be included,
Allocation destination information, allocation destination setting values corresponding to the allocation destination information, allocation destination details data for storing the allocation destination details,
Priority order data for storing priority orders corresponding to combinations of the distribution source details and the distribution destination details;
Is stored,
For causing the control unit to execute,
A priority detection step for detecting a priority in the priority data;
Based on the distribution destination setting value included in the distribution destination details corresponding to the detected priority order and the distribution source value included in the distribution source details corresponding to the detected priority order, the distribution process is executed, and the distribution value is calculated. Apportioning process execution step to be calculated;
Including,
Prorated processing execution program.

Images