JP2015043162A - Cost reduction calculation system, cost reduction calculation method, and program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To virtually calculate processing cost before and after equipment investment from a work log to calculate cost reduction effect.SOLUTION: A cost reduction calculation system includes: a work level aggregation device 103; a cost calculation device 104; and a cost calculation rule storage section 106. The work level aggregation device 103 establishes aggregation conditions for customer data to aggregate an obtained work log based on setting conditions of the ATM log and the like of the successive same account number in the same ATM. The cost calculation device 104 calculates a processing cost of a work log aggregated by the work level aggregation device 103. The cost calculation rule storage section 106 stores a cost calculation rule in which a cost calculation rule is set for each work attribute of the work log. The cost calculation device 104 calculates a processing cost for each work attribute of an aggregated work log based on the cost calculation rule stored in the cost calculation rule storage section 106.

Description

  The present invention relates to a reduction cost calculation system, a reduction cost calculation method, and a program, and more particularly, to a technique effective for a technique for calculating an operational cost reduction effect before and after measures such as capital investment in terms of money.

  As a technique for calculating the effect of capital investment, a technique for comparing operating results with the previous year from the same month is widely known.

  In addition, to calculate the operational cost reduction effect before and after measures such as capital investment by converting the amount, it can be realized by calculating and comparing each cost by actually conducting a comparative experiment. Is possible.

  Other techniques include, for example, activity-based costing (ABC), activity-based management (ABM), and a method of costing in detail by matching costs to human work. Is known (Non-Patent Document 1). In this method, costs are calculated by dividing costs into activity units and calculating costs using a standard for each activity.

ABC (Activity Based Costing) / ABM (Activity Based Management), Nikkei Business Publications website (http://itpro.nikkeibp.co.jp/free/NGT/govtech/20050413/ 159142 /)

  The increase in sales due to capital investment can be calculated by a control experiment or year-on-year comparison. However, the cost is often captured only when there is an extreme change such as a decrease in the number of personnel, and there is a possibility that the cost is not accurate.

  Also, in order to calculate the costs before and after capital investment by conducting a control experiment, it is necessary to conduct experiments before and after capital investment. Not realistic. In addition, in the control experiment, it is expected that the work assumed in the experiment is exactly the same, but it is generally difficult in the actual work.

  On the other hand, in the case of cost calculation, in the activity standard management described in Non-Patent Document 1, it is necessary to extract a person's work activity in detail and to give an appropriate cost to each work activity.

  However, if there is a difference in the business itself due to the impact before and after the capital investment, it is not possible to uniformly calculate the cost only by the difference in work time and the cost, but the business itself has changed. It is necessary to cope with that.

  For example, after capital investment, logs can be taken at a fine processing level, so time and cost must be considered at the fine processing level, but when it was manual work before capital investment, there was no work at that fineness, Problems such as inability to give time and cost due to its fineness occur.

  The purpose of the present invention is to virtually compare the costs before and after the measure from the operation log only when comparing the operation costs in cases where changes occur in the operations themselves, such as before and after capital investment. It is intended to provide a technique capable of calculating the cost reduction effect by measures such as capital investment while eliminating the need for a control experiment.

  The above and other objects and novel features of the present invention will be apparent from the description of this specification and the accompanying drawings.

  Of the inventions disclosed in the present application, the outline of typical ones will be briefly described as follows.

  That is, a typical outline is applied to a reduction cost calculation system and has the following characteristics.

  The reduction cost calculation system includes a level aggregation unit, a cost calculation unit, and a cost calculation rule storage unit. The level aggregating unit executes an aggregation process for aggregating the acquired work logs based on set setting conditions. The cost calculation unit calculates the processing cost of the work log aggregated by the work level aggregation unit. The cost calculation rule storage unit stores a cost calculation rule in which a cost calculation rule is set for each work attribute of the work log.

  Then, the cost calculation unit calculates a processing cost for each work attribute of the aggregated work log based on the cost calculation rule stored in the cost calculation rule storage unit.

  The present invention can also be applied to a method using a system for calculating the processing cost for each work level of a work log and a program for causing a computer system to function as the system.

  Among the inventions disclosed in the present application, effects obtained by typical ones will be briefly described as follows.

  It is possible to calculate the cost reduction effect while eliminating the need for a control experiment when comparing operational costs before and after capital investment.

It is explanatory drawing which shows an example of a structure in the reduction cost calculation system by one Embodiment. It is a flowchart which shows an example of the cost calculation process by the reduction cost calculation system of FIG. It is explanatory drawing which showed an example of the unit price table in which the unit price of the cost of the process when using ATM is described. It is explanatory drawing which showed an example of the unit price list | wrist of the cost of a process when a bank employee responds manually in a sales shop. It is explanatory drawing which shows an example of an ATM log. It is explanatory drawing which shows an example of the data format of an ATM log. It is explanatory drawing which shows an example of the log by which the aggregation process was carried out. It is explanatory drawing which shows an example of the result of having read the ATM log and performing cost calculation. It is explanatory drawing which shows an example of the result of having read the log after an aggregation process, and having calculated cost. It is a display example of the reduction cost comparison displayed on the output device of FIG. It is a display example which shows transition of the reduction cost displayed on the output device of FIG.

  In the following embodiments, when it is necessary for the sake of convenience, the description will be divided into a plurality of sections or embodiments. However, unless otherwise specified, they are not irrelevant to each other. There are some or all of the modifications, details, supplementary explanations, and the like.

  Further, in the following embodiments, when referring to the number of elements (including the number, numerical value, quantity, range, etc.), especially when clearly indicated and when clearly limited to a specific number in principle, etc. Except, it is not limited to the specific number, and may be more or less than the specific number.

  Further, in the following embodiments, the constituent elements (including element steps and the like) are not necessarily indispensable unless otherwise specified and apparently essential in principle. Needless to say.

  Similarly, in the following embodiments, when referring to the shape, positional relationship, etc. of components, etc., the shape of the component is substantially the case unless it is clearly specified and the case where it is clearly not apparent in principle. And the like are included. The same applies to the above numerical values and ranges.

  In all the drawings for explaining the embodiments, the same members are denoted by the same reference symbols in principle, and the repeated explanation thereof is omitted. In order to make the drawings easy to understand, even a plan view may be hatched.

  Hereinafter, embodiments will be described in detail.

<Configuration of reduction cost calculation system>
FIG. 1 is an explanatory diagram illustrating an example of a configuration of a reduction cost calculation system according to an embodiment.

  The reduction cost calculation system shown in FIG. 1 is a system that visualizes, for example, a bank ATM, that is, a reduction cost of manpower due to the introduction of an automatic teller machine. As shown, the reduction cost calculation system includes a cost calculation rule input device 101, a log extraction device 102, a work level aggregation device 103, a cost calculation device 104, an analysis device 105, a cost calculation rule storage unit 106, and a work log storage unit 107. A consolidated log storage unit 108, a cost data storage unit 109, an output device 110, and a business database 112.

  Cost calculation rule input device 101, log extraction device 102, work level aggregation device 103, cost calculation device 104, analysis device 105, cost calculation rule storage unit 106, work log storage unit 107, aggregation log storage unit 108, cost data storage unit 109 and the output device 110 are connected to each other via a bus 111. The log extraction device 102 and the business database 112 are connected by a network 113 that is a communication line.

  The cost calculation rule input device 101 inputs a cost calculation rule. The log extraction device 102 extracts a work log stored in the business database 112. A work level aggregating apparatus 103 as a work level aggregating unit performs an aggregation process for aggregating work logs extracted by the log extracting apparatus 102.

  The cost calculation device 104 serving as a cost calculation unit calculates the cost for the work log aggregated by the work level aggregation device 103. The analysis device 105, which is an analysis unit, analyzes the cost data calculated by the cost calculation device 104 by a tabulation process.

  The cost calculation rule storage unit 106 stores the cost calculation rule input by the cost calculation rule input device 101. The work log storage unit 107 stores the work log extracted by the log extraction device 102.

  The aggregation log storage unit 108 stores work logs that have been aggregated by the work level aggregation device 103. The cost data storage unit 109 stores the cost calculation result of the work log calculated by the cost calculation device 104.

  The output device 110 includes, for example, a monitor and a printer, and displays the analysis result obtained by the analysis device 105. The business database 112 stores work logs. In this case, the work log stored in the business database 112 is an ATM log.

  Subsequently, the operation of the reduction cost calculation system will be described.

  The processing functions of the work level aggregation device 103, the cost calculation device 104, and the analysis device 105 described below are, for example, programs stored in a program storage memory (not shown) provided in the reduction cost calculation system. This type of software is realized by executing a CPU (Central Processing Unit) (not shown) of the reduction cost calculation system.

  FIG. 2 is a flowchart showing an example of cost calculation processing by the reduction cost calculation system of FIG.

  First, a cost calculation rule is input by the cost calculation rule input device 101 (step S101). The input cost calculation rule is stored in the cost calculation rule storage unit 106.

  Here, the cost calculation rule input by the cost calculation rule input device 101 will be described with reference to FIGS. 3 and 4. The cost calculation rule is composed of the unit price of the cost of processing when using ATM as the first work process and the unit price of the cost of manual processing as the second work process.

  FIG. 3 is an explanatory diagram showing an example of a unit price table in which unit costs of processing costs when ATM is used. In this case, as shown in FIG. 3, considering that the unit price varies depending on the ATM machine, the time zone, and the transaction type, which are work attributes, the cost can be set for each of them.

  FIG. 4 is an explanatory diagram showing an example of a unit price table for the cost of processing when a bank employee manually handles at a sales office.

  In this case, as shown in FIG. 4, the cost can be set in accordance with the time zone and transaction type as work attributes. For example, it is basically impossible to respond outside the time, but depending on the purpose of the analysis, the same amount as in the time period may be set, or an extra amount may be set as compared with the case in the time period.

  In FIG. 4, there is a column for entering an ATM machine number as data even though it is a manual process, and this determines which store man-hours are used virtually, thereby changing the unit price. In addition, it is possible to aggregate for each store at the time of aggregation.

  Unlike the ATM process of FIG. 3, in FIG. 4, since the bank employee processes balance inquiry, transfer, payment, etc. at once, the unit price corresponding to these combinations is set. As described above, the unit price tables shown in FIGS. 3 and 4 are examples of cost calculation rules.

  In the cost calculation rule input device 101 for inputting these cost calculation rules, for example, parts other than the cost are already described, and only the cost is input. This function can be realized by a software program, for example.

  Subsequently, in FIG. 2, the log extraction device 102 extracts the work log stored in the business database 112 via the network 113 (step S <b> 102). The extracted work log is stored in the work log storage unit 107.

  The extracted work log is an ATM log as described above. FIG. 5 is an explanatory diagram showing an example of an ATM log.

  As shown in the figure, the ATM log is an ATM transaction history and is recorded by attributes such as time, account number, transaction type, ATM number, and branch. When recorded in the work log storage unit 107, type data indicating that the work log is an ATM log is given. Furthermore, a log ID that is a serial number for each log is assigned and recorded.

  FIG. 6 is an explanatory diagram showing an example of the data format of the ATM log.

  As shown in FIG. 6, in the data format of the ATM log, data indicating that the type is ATM and a log ID are assigned to each row of the log shown in FIG. 3 and FIG. .

  Then, returning to FIG. 2, the work level aggregating apparatus 103 reads the ATM log in the work log storage unit 107 and performs an aggregation process that is a process of aggregating ATM logs of the same account number that are continuous with the same ATM as the setting condition ( Step S103). The aggregated ATM log is stored in the aggregate log storage unit 108.

  Based on the data shown in FIG. 6, a log as shown in FIG. 7 to be described later is generated by collecting logs of the same account number in which rows are continuous at the same ATM.

  FIG. 7 is an explanatory diagram illustrating an example of a log that has been subjected to aggregation processing.

  Here, all items of the log in FIG. 7 are newly created items. The type is described as “manual”, and a serial number is assigned to the log ID. When collecting ATM logs, the first time and the last time are recorded as the start time and the end time, respectively.

  The account number records the corresponding account number in the ATM log. In the transaction type, the transaction types of the corresponding ATM logs are arranged in a comma separated manner. The branch name corresponding to the ATM log is recorded in the branch name. In the ATM log ID, the log IDs of the corresponding ATM logs are arranged in a comma separated manner.

  Subsequently, the cost calculation device 104 includes an ATM log stored in the work log storage unit 107, an aggregated log stored in the aggregation log storage unit 108, and a cost calculation rule stored in the cost calculation rule storage unit 106. Respectively. Then, cost calculation is executed for the process described in each line of each log (step S104). The cost calculation device 104 stores the cost calculation result in the cost data storage unit 109.

  As shown in FIGS. 3 and 4, since the unit price of the cost under each condition is described in the cost calculation rule, the operation attributes such as time and transaction type in each row of the log are read out. The unit price of the cost of the corresponding condition may be selected.

  FIG. 8 is an explanatory diagram illustrating an example of a result of cost calculation by reading an ATM log. FIG. 8 shows the result of calculating the cost by ATM processing. FIG. 9 is an explanatory diagram showing an example of a result of cost calculation by reading the log after the aggregation processing. FIG. 9 shows the result of calculating the cost by manual processing.

  Then, the analysis device 105 reads the cost data stored in the cost data storage unit 109, performs a totaling process (step S105), and outputs the result to the output device 110.

  In the aggregation process in the process of step S105, the ATM log and the manual aggregation log are aggregated for each period, and the difference in cost between the ATM log and the human aggregation log is calculated with respect to the log of the same period. This can be done by an analysis method such as totaling for each branch where the office is installed.

  FIG. 10 is a display example of reduction cost comparison displayed on the output device 110 of FIG. FIG. 11 is a display example showing the transition of the reduction cost displayed on the output device 110 of FIG.

  FIG. 10 shows an example in which the difference between the manual cost and the ATM cost is displayed for each branch as the ATM introduction effect. FIG. 11 shows an example in which the reduction costs shown in FIG. 10 are displayed in time series.

  According to the above, it is possible to compare the cost when it is assumed that it is performed manually before the introduction of ATM and the cost after introduction of ATM. Thereby, the cost reduction effect by introduction of ATM can be visualized.

  At that time, a plurality of procedures such as transfer, withdrawal, and balance inquiry are performed collectively at the branch office. Therefore, in a situation where it is not appropriate to add the respective costs, an appropriate cost unit price can be set according to the combination of procedures.

  Further, in the present embodiment, the technology for visualizing the reduction costs before and after the capital investment of ATM has been described, but the visualization technology by the reduction cost calculation system can be implemented not limited to ATM.

  For example, the present invention can be applied to visualization of reduction costs before and after the investment of a bank's Internet banking. At that time, the corresponding cost is input in the cost calculation rule in the process of step S101 of FIG. Further, in the work level aggregation in the process of step S103, instead of “aggregating logs of the same account number continuous with the same ATM”, performing a process of aggregating logs between Internet banking login and logout Realization is possible.

  As mentioned above, the invention made by the present inventor has been specifically described based on the embodiment. However, the present invention is not limited to the embodiment, and various modifications can be made without departing from the scope of the invention. Needless to say.

  In addition, this invention is not limited to above-described embodiment, Various modifications are included. For example, the above-described embodiment has been described in detail for easy understanding of the present invention, and is not necessarily limited to one having all the configurations described.

  Further, a part of the configuration of one embodiment can be replaced with the configuration of another embodiment, and the configuration of another embodiment can be added to the configuration of one embodiment. . In addition, it is possible to add, delete, and replace other configurations for a part of the configuration of each embodiment.

101 Cost Calculation Rule Input Device 102 Log Extraction Device 103 Work Level Aggregation Device 104 Cost Calculation Device 105 Analysis Device 106 Cost Calculation Rule Storage Unit 107 Work Log Storage Unit 108 Aggregation Log Storage Unit 109 Cost Data Storage Unit 110 Output Device 111 Bus 112 Business Database 113 network

Claims (13)

A work level aggregating unit for aggregating the acquired work logs based on the set setting conditions;
A cost calculation unit for calculating a processing cost of the work log aggregated by the work level aggregation unit;
A cost calculation rule storage unit for storing a cost calculation rule in which a cost calculation rule is set for each work attribute of the work log;
Have
The said cost calculation part is a reduction cost calculation system which each calculates the processing cost for every work attribute of the said work log aggregated based on the said cost calculation rule stored in the said cost calculation rule memory | storage part. In the reduction cost calculation system according to claim 1,
The cost calculation rule stored in the cost calculation rule storage unit indicates a cost calculation rule for each work attribute for the first work process and a cost calculation rule for each work attribute for the second work process. Is,
The cost calculating unit classifies the aggregated work log into the processing cost of the work attribute in the work log classified into the first work process and the second work process based on the cost calculation rule. A reduction cost calculation system for calculating each processing cost of the work attribute in the work log. In the reduction cost calculation system according to claim 2,
Furthermore, it has an analysis unit for analyzing the processing cost calculated by the cost calculation unit,
The said analysis part is a reduction cost calculation system which outputs the difference of the process cost of the said work log classified into the said 1st work process, and the process cost of the said work log classified into the said 2nd work process. In the reduction cost calculation system according to claim 2,
The work log acquired by the work level aggregation unit is a transaction history of an automated teller machine,
The first work process is a machine process work performed by the automatic teller machine,
The second work process is a reduction cost calculation system, which is a manual process for manually processing a process performed by the automatic teller machine. In the reduction cost calculation system according to claim 2,
The work log acquired by the work level aggregation unit is a transaction history of Internet banking,
The first work process is a machine work performed by the internet banking processing system;
The second work process is a reduction cost calculation system, which is a manual process that manually processes a process to be processed by the processing system. A reduction cost calculation method by a computer system comprising: an aggregate work level aggregation unit that aggregates work logs; a cost calculation unit that calculates processing costs of the aggregated work logs; and an analysis unit that analyzes the calculated process costs There,
A step of aggregating the acquired work logs for each set setting condition in the aggregation work level aggregation unit;
In the cost calculation unit, based on a cost calculation rule in which a rule for cost calculation is set for each work attribute of the work log, each of calculating a processing cost for each work attribute of the aggregated work log,
A method for calculating reduction costs. In the reduction cost calculation method according to claim 6,
The cost calculation rule indicates a cost calculation rule for each work attribute for a first work process and a cost calculation rule for each work attribute for a second work process,
Calculating each of the processing costs,
Classifying the aggregated work logs into the first work process and the second work process;
Calculating a processing cost of the work attribute in the work log classified into the first work processing based on the cost calculation rule;
Calculating a processing cost of the work attribute in the work log classified into the second work processing based on the cost calculation rule;
A method for calculating reduction costs. In the reduction cost calculation method according to claim 7,
Furthermore, the analysis unit includes a step of calculating a difference between the processing cost of the work log classified into the first work process and the processing cost of the work log classified into the second work process. Cost calculation method. In the reduction cost calculation method according to claim 7,
The work log to be acquired is a transaction history of an automated teller machine,
The first work process is a machine process work performed by the automatic teller machine,
The second work process is a reduction cost calculation method, which is a manual process of manually processing a work performed by the automatic teller machine. In the reduction cost calculation method according to claim 7,
The work log to be acquired is a transaction history of Internet banking,
The first work process is a machine work performed by the internet banking processing system;
The method of calculating a reduction cost, wherein the second work process is a work of a manual process for manually processing a process to be processed by the processing system. A program for causing a computer system to execute an aggregation process for aggregating work logs and a cost calculation process for calculating a processing cost of the aggregated work logs,
In the aggregation process, a step of aggregating the acquired work logs for each set setting condition;
In the cost calculation process, based on a cost calculation rule in which a cost calculation rule is set for each work attribute of the work log, a process cost for each work attribute of the aggregated work log is calculated,
A program with The program according to claim 11, wherein
The step of calculating the processing cost for each work attribute of the aggregated work log,
Classifying the aggregated work logs into a first work process and a second work process;
Calculating a processing cost of the work attribute in the work log classified into the first work processing based on the cost calculation rule;
Calculating a processing cost of the work attribute in the work log classified into the second work processing based on the cost calculation rule;
Having a program. The program according to claim 12,
Further, a program that causes the computer system to execute a step of calculating a difference between a processing cost of the work log classified as the first work process and a processing cost of the work log classified as the second work process. .

Images