Planned labor cost calculation device, planned labor cost calculation method, and planned labor cost calculation program

Abstract

To calculate projected labor costs that more accurately reflect actual costs. [Solution] The cost accounting unit 102c obtains employee, work content, and work time from the daily report data stored in the storage unit 106, refers to the employee master 106e to obtain the planned man-hour unit price code using the employee as the key, refers to the work content classification determination master 106b to obtain cost elements using the obtained work content as the key, refers to the planned man-hour unit price master 106d to obtain the planned cost (standard unit price, multiplier) using the obtained planned man-hour unit price code and cost elements as the keys, and calculates the planned labor cost for each cost element for the obtained employee by multiplying the planned cost by the work time.

Description

Technical Field

[0001] The present invention relates to a planned labor cost calculation device, a planned labor cost calculation method, and a planned labor cost calculation program.

Background Art

[0002] For example, labor costs refer to the costs obtained by aggregating salaries, statutory welfare expenses, etc. including overtime pay for employees directly involved in the manufacture of goods or projects (hereinafter, for the sake of distinction, this labor cost will be referred to as "actual labor cost"). Conventionally, as a system for calculating labor costs, for example, there is Patent Document 1.

Prior Art Documents

Patent Documents

[0003]

Patent Document 1

Summary of the Invention

Problems to be Solved by the Invention

[0004] Originally, labor costs refer to "actual labor costs", but it is difficult to calculate the above costs as costs in actual operation. As an approximate value, it is common to set one planned unit price and use the amount calculated by the planned unit price × daily work time as labor costs (hereinafter, this labor cost will be referred to as "planned labor cost").

[0005] Therefore, how to set this planned unit price becomes a very important point for companies that calculate plans and costs using planned labor costs. In general work hour input, since there is only one unit price, it does not have a correct relationship with actual attendance and leave, and excessive cost differences will occur. Also, if the unit price is set in anticipation of this, it will result in an inappropriate unit price.

[0006] The present invention has been made in view of the above, and aims to provide a planned labor cost calculation device, a planned labor cost calculation method, and a planned labor cost calculation program that can calculate planned labor costs that are closer to the actual situation. [Means for solving the problem]

[0007] To solve the above-mentioned problems and achieve the objective, the present invention provides a planned labor cost calculation device equipped with a control unit, wherein the control unit is configured to access a master group in which planned man-hour unit price codes, cost elements specifying patterns of labor costs, work content specifying various tasks, and planned unit prices are registered in association with each other, an employee master in which employees and planned man-hour unit price codes are registered in association with each other, and daily report data including work day, employee, target project, work content, and work time, and the device obtains employees, work content, and work time from the daily report data, obtains a planned man-hour unit price code using the employee as the key by referring to the employee master, obtains cost elements from the master group using the obtained work content as the key, obtains a planned unit price using the obtained planned man-hour unit price code and cost elements as the key, and is equipped with cost calculation means that calculates the planned labor cost for each employee, for each cost element, by planned unit price × work time.

[0008] Furthermore, according to one aspect of the present invention, the master data group may include a work content classification discrimination master in which work content and cost elements are registered in association, and a planned man-hour unit price master in which planned man-hour unit price codes, cost elements, and planned unit prices are registered in association, and the cost calculation means may refer to the work content classification discrimination master to obtain cost elements using the acquired work content as a key, refer to the planned man-hour unit price master to obtain planned costs using the acquired planned man-hour unit price codes and cost elements as keys, and for each employee whose data has been acquired, the planned labor cost may be calculated by multiplying the planned cost by the work time.

[0009] Furthermore, according to one aspect of the present invention, the planned unit price may include the standard unit price and a multiplier applied to the standard unit price.

[0010] Furthermore, according to one aspect of the present invention, the work content may include normal work, overtime work, and nighttime work, and the cost elements may include labor costs (normal), labor costs (overtime), and labor costs (nighttime).

[0011] Furthermore, in order to solve the above-mentioned problems and achieve the objectives, the present invention provides a method for calculating planned labor costs executed by an information processing device equipped with a control unit, wherein the control unit is configured to access a master group in which planned man-hour unit price codes, cost elements that specify patterns of labor costs, work content that specifies various tasks, and planned unit prices are registered in association with each other, an employee master in which employees and planned man-hour unit price codes are registered in association with each other, and daily report data including work day, employee, target project, work content, and work time, and the method is characterized by including a cost calculation step executed by the control unit, which obtains employees, work content, and work time from the daily report data, refers to the employee master to obtain a planned man-hour unit price code using the employee as the key, obtains cost elements from the master group using the obtained work content as the key, obtains a planned unit price using the obtained planned man-hour unit price code and cost elements as the key, and calculates the planned labor cost for each employee for each cost element by calculating the planned labor cost by multiplying the planned unit price by the work time.

[0012] Furthermore, in order to solve the above-mentioned problems and achieve the objective, the present invention provides a planned labor cost calculation program to be executed by an information processing device equipped with a control unit, wherein the control unit includes a master group registered in association with a planned man-hour unit price code, cost elements specifying a pattern of labor costs, work content specifying various tasks, and planned unit price, an employee master registered in association with an employee and a planned man-hour unit price code, and daily report data including work day, employee, target project, work content, and work time. The program is configured to access the control unit, and is a program for calculating planned labor costs that causes the control unit to perform a cost calculation process in which it obtains employees, work content, and work hours from the daily report data, obtains a planned labor cost unit price code using the employee as the key by referring to the employee master, obtains cost elements from the master group using the obtained work content as the key, obtains a planned unit price using the obtained planned labor cost unit price code and cost elements as the key, and calculates the planned labor cost for each employee by calculating the planned labor cost by multiplying the planned unit price by the work hours for each cost element. [Effects of the Invention]

[0013] The present invention has the effect of making it possible to calculate planned labor costs that are closer to the actual situation. [Brief explanation of the drawing]

[0014] [Figure 1] Figure 1 is a block diagram showing an example of the configuration of the planned labor cost calculation device according to this embodiment. [Figure 2] Figure 2 shows an example of the structure of the work content master. [Figure 3] Figure 3 shows an example of a master configuration for determining the work content category. [Figure 4] Figure 4 shows an example of the cost element master configuration. [Figure 5] Figure 5 shows an example of the structure of the planned man-hour unit price master. [Figure 6] Figure 6 shows an example of the employee master data structure. [Figure 7] Figure 7 is a diagram illustrating the overall processing outline of the control unit of the planned labor cost calculation device in this embodiment. [Figure 8] Figure 8 is a diagram illustrating a specific example of the processing performed by the control unit of the planned labor cost calculation device in this embodiment. [Figure 9] Figure 9 is a diagram illustrating a specific example of the processing performed by the control unit of the planned labor cost calculation device in this embodiment. [Figure 10A]FIG. 10A is a diagram for explaining a specific example of the processing of the control unit of the planned labor cost calculation device in the present embodiment. [Figure 10B] FIG. 10B is a diagram for explaining a specific example of the processing of the control unit of the planned labor cost calculation device in the present embodiment. [Figure 11] FIG. 11 is a diagram for explaining a specific example of the processing of the control unit of the planned labor cost calculation device in the present embodiment. [Embodiment for Carrying Out the Invention]

[0015] Embodiments of the present invention will be described in detail based on the drawings. Note that the present invention is not limited to these embodiments.

[0016] [1. Overview] The overview of the present invention will be described in the order of [1-1. Problem / Background], [1-2. Solution Method], and [1-3. Effect].

[0017] [1-1. Problem / Background] For example, in an IT company, labor costs account for more than 70% of the total cost. Labor costs refer to the total cost obtained by adding up salaries, statutory welfare expenses, etc., including overtime pay for employees directly involved in the manufacture of products or projects (hereinafter, for the sake of distinction, this labor cost will be referred to as "actual labor cost").

[0018] Originally, labor costs refer to actual labor costs. However, due to the difference between the business division from the beginning to the end of the month and the salary division where the closing date is not limited to that, it is difficult to calculate the above expenses as costs in actual operation. As an approximate value, one planned unit price is set, and it is common to use the amount calculated by the planned unit price × daily report time as the labor cost (hereinafter, the labor cost obtained by this operation will be referred to as "planned labor cost").

[0019] Therefore, how to set the planned unit price is a crucial issue for companies that plan and calculate costs using planned labor costs (because incorrect unit prices can lead to large cost variances and inappropriately high estimates). Planned unit prices are calculated by dividing actual labor costs by the expected monthly working hours, but actual work systems are not limited to flexible work arrangements; there are also forms of daily overtime. Such employees incur increased unit prices according to their daily working hours, but with typical man-hour input, there is only one unit price, so it does not correlate correctly with actual attendance and leads to excessive cost variances. On the other hand, setting a unit price that takes this into account results in an inappropriate unit price. For example, companies that undertake program development projects are prone to overtime due to program modifications before deadlines, and in such cases, the calculation of planned labor costs will be significantly inaccurate. It is necessary to be able to calculate planned labor costs using multiple unit prices so that they can be calculated in a way that more accurately reflects the actual situation.

[0020] [1-2. Solution] In this invention, in order to calculate planned labor costs that are closer to the actual situation (actual labor costs), (1) cost elements, work content, and planned unit prices are registered in advance for each pattern such as regular work, overtime, and late-night overtime; (2) the person entering the project daily report enters the work content separately depending on whether it is work done during regular hours or overtime hours; and (3) when calculating the planned labor costs from the work hours by cost accounting, the planned labor costs are calculated using multiple planned unit prices by aggregating the work done during regular hours and work done during overtime hours separately.

[0021] [1-3. Effects] According to the present invention, the following effects are obtained. (1) With the present invention, when calculating the cost of planned labor costs, it is possible to calculate using multiple unit prices instead of just one unit price as in the past, thus enabling labor cost calculations that are closer to the actual situation. (2) Unlike salaries, whose calculation rules are stipulated by law, overtime multipliers can be set by each company, and in some cases, overtime multipliers and early morning overtime multipliers are set separately. It is possible to respond flexibly to such companies as well.

[0022] This invention is widely applicable to companies, for example, in the IT media industry, that calculate and include labor costs as part of their cost of goods sold.

[0023] [2. Structure] Figure 1 is a block diagram showing an example of the configuration of the planned labor cost calculation device 100 according to this embodiment. In Figure 1, the planned labor cost calculation device 100 is, for example, a commercially available desktop personal computer. Note that the planned labor cost calculation device 100 is not limited to stationary information processing devices such as desktop personal computers, but may also be portable information processing devices such as commercially available notebook personal computers, PDAs (Personal Digital Assistants), smartphones, and tablet personal computers. The planned labor cost calculation device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each part of the planned labor cost calculation device 100 is connected to communicate via any communication path.

[0024] The communication interface unit 104 connects the planned labor cost calculation device 100 to the network 300 via communication devices such as routers and wired or wireless communication lines such as dedicated lines. The communication interface unit 104 has the function of communicating data with other devices via communication lines. Here, the network 300 has the function of connecting the planned labor cost calculation device 100 with employee terminals (not shown) and servers 200 used by employees, enabling them to communicate with each other, and is, for example, the internet or a LAN (Local Area Network). The employee terminal is configured to communicate data with the planned labor cost calculation device 100. The employee terminal inputs daily report data and transmits it to the planned labor cost calculation device 100.

[0025] The input / output interface unit 108 is connected to an input device 112 and an output device 114. The output device 114 can be a monitor (including a home television), a speaker, or a printer. The input device 112 can be a keyboard, mouse, microphone, or a monitor that works in conjunction with the mouse to provide pointing device functionality. Note that in the following, the output device 114 may be referred to as the monitor 114.

[0026] The memory unit 106 stores various databases, tables, and files. The memory unit 106 also stores computer programs that work in cooperation with the OS (Operating System) to give instructions to the CPU (Central Processing Unit) to perform various processes. As the memory unit 106, for example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks can be used.

[0027] Furthermore, the storage unit 106 stores the work content master 106a, the work content classification determination master 106b, the cost element master 106c, the planned man-hour unit price master 106d, the employee master 106e, the actual cost table, daily report data, etc. Figure 2 shows an example of the configuration of the work content master 106a. Figure 3 shows an example of the configuration of the work content classification determination master 106b. Figure 4 shows an example of the configuration of the cost element master 106c. Figure 5 shows an example of the configuration of the planned man-hour unit price master 106d. Figure 6 shows an example of the configuration of the employee master 106e.

[0028] As shown in Figure 2, the work content master 106a can consist of tables that register work content codes and work content names (regular work, overtime work, late-night work) in association with each other.

[0029] As shown in Figure 3, the work content classification master 106b can be composed of tables, etc., that register work content (work content code and / or work content name) and cost elements (cost element code and / or cost element name) in association.

[0030] As shown in Figure 4, the cost element master 106c can be composed of tables that register cost element codes and cost element names (labor costs (normal), labor costs (overtime), labor costs (nighttime)) in association.

[0031] As shown in Figure 5, the planned man-hour unit price master 106d can be composed of tables that associate and register the planned man-hour unit price code, cost elements (cost element code and / or cost element name), and planned unit price (standard unit price, multiplier).

[0032] The integrated functions of the work content master 106a, work content classification determination master 106b, cost element master 106c, and planned man-hour unit price master 106d are referred to as the "master group." The master group registers the planned man-hour unit price code, cost elements that define multiple labor cost patterns, work content that defines multiple patterns of work content, and planned unit price (e.g., standard unit price × multiplier) in association with each other. The master group may be composed of separate or integrated components.

[0033] As shown in Figure 6, the employee master 106e can be composed of tables that associate and register employees (employee code and / or employee), planned man-hour unit price codes, etc.

[0034] Daily report data may include the work date, employee (employee code and / or employee name), target project, work details (work details code and / or work details name), and work time.

[0035] The actual cost table is a table for storing cost accounting results and includes fields for accounting year and month, project code, cost element code, and amount.

[0036] Returning to Figure 1, the control unit 102 is a CPU or similar component that comprehensively controls the planned labor cost calculation device 100. The control unit 102 has internal memory for storing control programs such as the OS, programs that define various processing procedures, and required data, and executes various information processing based on these stored programs.

[0037] The control unit 102 is configured to access the work content master 106a, work content classification determination master 106b, cost element master 106c, planned man-hour unit price master 106d, employee master 106e, actual cost table, daily report data, etc., which are stored in the storage unit 106. Note that the work content master 106a, work content classification determination master 106b, cost element master 106c, planned man-hour unit price master 106d, employee master 106e, actual cost table, daily report data, etc. may be located in another location (for example, on the server 200), as long as the control unit 102 can access them.

[0038] Functionally, the control unit 102 consists of a master maintenance unit 102a and a daily report registration unit 102b. It comprises a cost accounting unit 102c, a revenue and expenditure output unit 102d, and a screen display control unit 102e.

[0039] The master maintenance unit 102a performs editing such as inputting, adding, and changing data for the work content classification master 106b, cost element master 106c, planned man-hour unit price master 106d, and employee master 106e, for example, in response to operator operations on the master maintenance screen (not shown) displayed on the monitor 114.

[0040] The daily report registration unit 102b, for example, provides a daily report registration screen in response to a request from an employee terminal, and, in response to the employee's operation on the employee terminal on the daily report registration screen, inputs daily report data including the work date, employee, target case, work content code, and work time, and registers it in the storage unit 106.

[0041] The cost accounting unit 102c retrieves employee, work content, and work hours from the daily report data stored in the memory unit 106, refers to the employee master 106e to obtain the planned man-hour unit price code using the employee as the key, refers to the master group to obtain cost elements using the retrieved work content as the key, and uses the retrieved planned man-hour unit price code and cost elements as keys to obtain the planned cost (standard unit price, multiplier to be applied to the standard unit price), calculates the planned labor cost for each cost element for the retrieved employee by multiplying the planned cost by the work hours, and stores the cost calculation results in the actual cost table.

[0042] More specifically, the system references the work content classification master 106b to retrieve cost elements using the retrieved work content as the key, references the planned man-hour unit price master 106d to retrieve the planned cost (standard unit price, multiplier) using the retrieved planned man-hour unit price code and cost elements as the keys, calculates the planned labor cost for each employee by multiplying the planned cost by the working hours, and stores the cost calculation results in the actual cost table.

[0043] The revenue and expenditure output unit 102d, for example, in response to the operator's operation on the revenue and expenditure output screen (not shown) displayed on the monitor 114, refers to the actual cost table and displays and outputs the revenue and expenditure (report) of the planned labor costs for each cost element for the target project for each accounting month.

[0044] The screen display control unit 102e controls the display and input reception of various screens (for example, master maintenance screen, income and expenditure output screen, daily report input screen, etc.) to be displayed on the monitor 114 and employee terminals.

[0045] [3. Specific examples] Referring to Figures 1 to 11, a specific example of the processing of the control unit 102 of the planned labor cost calculation device 100 in this embodiment will be described. Figures 7 to 11 are diagrams illustrating a specific example of the processing of the control unit 102 of the planned labor cost calculation device 100 in this embodiment.

[0046] [3-1. Overall Processing] Figure 7 is a flowchart illustrating the overall processing outline of the control unit 102 of the planned labor cost calculation device 100 in this embodiment. Referring to Figure 7, the overall processing outline of the control unit 102 of the planned labor cost calculation device 100 in this embodiment will be explained.

[0047] In Figure 7, the master maintenance unit 102a performs the master maintenance process (step S1). Specifically, in the master maintenance process, the master maintenance unit 102a sets data for the work content classification master 106b, the cost element master 106c, the planned man-hour unit price master 106d, and the employee master 106e, for example, in response to the operator's operation on the master maintenance screen (not shown) displayed on the monitor 114.

[0048] The daily report registration unit 102b executes the daily report registration process (step S2). Specifically, in the daily report registration process, the daily report registration unit 102b, for example, provides a daily report registration screen in response to a request from an employee terminal, and, in response to the employee's operation on the employee terminal on the daily report registration screen, inputs daily report data including the work date, employee, target case, work content code, and work time and registers it in the storage unit 106.

[0049] The cost accounting unit 102c executes the cost accounting process (step S3). Specifically, in the cost accounting process, the cost accounting unit 102c obtains employee, work content, and work hours from the daily report data stored in the storage unit 106, refers to the employee master 106e to obtain the planned man-hour unit price code using the employee as the key, refers to the work content classification determination master 106b to obtain cost elements using the obtained work content as the key, refers to the planned man-hour unit price master 106d to obtain the planned cost (standard unit price, multiplier) using the obtained planned man-hour unit price code and cost elements as the keys, calculates the planned labor cost for each cost element for the obtained employee by multiplying the planned cost by the work hours, and stores the cost calculation results in the actual cost table.

[0050] The revenue and expenditure output unit 102d executes the project revenue and expenditure report output process (step S4). Specifically, in the project revenue and expenditure report output process, the revenue and expenditure output unit 102d, for example, in response to the operator's operation on the revenue and expenditure output screen (not shown) displayed on the monitor 114, refers to the actual cost table and displays and outputs a revenue and expenditure report for the target project, showing the planned labor costs for each cost element for each accounting month.

[0051] [3-2. Sample Data] Figures 8 to 11 are diagrams showing sample data to illustrate a specific example of the processing performed by the control unit 102 of the planned labor cost calculation device 100 in this embodiment. A specific example of the processing performed by the control unit 102 of the planned labor cost calculation device 100 in this embodiment will be explained with reference to Figures 8 to 11.

[0052] (S1: Master Maintenance Processing) Refer to Figure 8 to explain a specific example of the master maintenance process. The master maintenance unit 102a sets data for the work content classification master 106b, cost element master 106c, planned man-hour unit price master 106d, and employee master 106e in response to the operator's operations on the master maintenance screen (not shown) displayed on the monitor 114. As an example, we will describe the calculation of labor costs for a company where employees perform normal work during the day and sometimes work overtime from after the customer's business hours until late at night for system replacement.

[0053] Figure 8(A) shows an example of registration in the work content master 106a. The work content master 106a can be composed of tables that associate work content codes and work content names. In the example shown in the figure, the first row has work content code "X" and work content name "Normal work", the second row has work content code "Y" and work content name "Overtime work", and the third row has work content code "Z" and work content name "Late-night work".

[0054] Figure 8(B) shows an example of registration in the work content classification master 106b. The work content classification master 106b can be composed of tables that associate work content codes and cost element codes. In the example shown in the figure, the first row is work content code "X" and cost element code "110", the second row is work content code "Y" and cost element code "111", and the third row is work content code "Z" and cost element code "112".

[0055] Figure 8(C) shows an example of registration in the cost element master 106c. The cost element master 106c can be composed of tables that register cost element codes and cost element names in association. In the example shown in the figure, the first row has cost element code "110" and cost element name "Labor Costs (Normal)", the second row has cost element code "111" and cost element name "Labor Costs (Overtime)", and the third row has cost element code "112" and cost element name "Labor Costs (Late Night)".

[0056] Figure 8(D) shows an example of registration in the planned man-hour unit price master 106d. The planned man-hour unit price master 106d can be composed of tables that associate and register planned man-hour unit price codes, cost element codes, cost element names, standard unit prices, and multipliers. In the example shown in the figure, the first row is planned man-hour unit price code "T00", cost element code "110", cost element name "Labor Costs (Normal)", standard unit price "3000", multiplier "1", the second row is planned man-hour unit price code "T00", cost element code "111", cost element name "Labor Costs (Overtime)", standard unit price "3000", multiplier "1.25", and the third row is planned man-hour unit price code "T00", cost element code "112", cost element name "Labor Costs (Late Night)", standard unit price "3000", multiplier "1.75". Since this involves overtime work outside of regular hours plus late-night overtime, the late-night overtime multiplier will be 1.5 times or more. However, in this example, a higher multiplier is set to take into account transportation costs after working late at night.

[0057] (S2: Daily report registration process) A specific example of the daily report registration process will be explained with reference to Figure 9. The daily report registration unit 102b, for example, provides a daily report registration screen in response to a request from an employee terminal, and based on the employee's operation on the employee terminal on the daily report registration screen, inputs daily report data including the work date, employee, target case, work content code, and work time, and registers it in the storage unit 106.

[0058] Figure 9 shows an example of the display of the daily report registration screen 400. The daily report registration screen 400 includes a header area 401 for inputting the target day, employee, working hours, break time, and actual working hours, a detail area 402 for inputting details (details No., target case, target case name, work content, work time), and a registration button (not shown). When an employee on an employee terminal presses the registration button (not shown) on the daily report registration screen 400, daily report data corresponding to the input on the daily report registration screen 400 is registered in the storage unit 106. In the case of the input shown in the figure, daily report data as shown in Figure 10A(A) is registered.

[0059] (S3: Cost accounting process) Refer to Figures 10A and 10B to explain a specific example of the cost accounting process. The cost accounting unit 102c retrieves employee, work content, and work hours from the daily report data stored in the memory unit 106, retrieves the planned labor cost code using the employee as the key by referring to the employee master 106e, retrieves cost elements using the retrieved work content as the key by referring to the work content classification judgment master 106b, retrieves the planned cost (standard unit price, multiplier) using the retrieved planned labor cost code and cost elements as the keys by referring to the planned labor cost master 106d, calculates the planned labor cost (planned cost × work hours) for each cost element for the retrieved employee, and stores the cost calculation results in the actual cost table. In the cost accounting process, work content and work hours are retrieved from the daily report data, and labor costs are calculated according to the amount set by the planned unit price (= standard unit price × multiplier).

[0060] In the figure, (A) shows an example of daily report data, (B) shows an example of registration in the work content master 106a, (C) shows an example of registration in the work content classification judgment master 106b, (D) shows an example of registration in the cost element master 106c, (E) shows an example of registration in the planned man-hour unit price master 106d, (F) shows an example of registration in the employee master 106e, and (G) shows an example of data in the actual cost table.

[0061] The daily report data may include the work date, employee, target project, work content code, and work time. In the example shown in the figure, the first row contains the work date "2024 / 05 / 29", employee "S0001", target project "PJ2405000001-0001-0001", work content code "X", and work time "08:00".

[0062] (1) Obtain employee code, work content code, and work time from the daily report data. (2) Using the acquired employee code as the key, retrieve the planned man-hour unit price code from employee master 106e. (3) Using the acquired work content code as the key, the cost element code is obtained from the work content classification determination master 106b. (4) Using the acquired planned labor cost code and cost element code as keys, the unit price and multiplier for each cost element are obtained from the planned labor cost master 106d, and the planned labor cost is calculated for each cost element using the planned unit price (standard unit price × multiplier) × working hours.

[0063] The planned labor costs based on cost accounting are as follows: Labor costs (normal): ¥3,000 x 1 x 8 hours = ¥24,000 Labor costs (overtime)...¥3,000 x 1.25 x 4h = ¥15,000 ·Labor expenses (late night) ··· ¥3,000×1.75×1h=¥5,250

[0064] (5) Store the cost calculation results in the actual cost table. The actual cost table, as shown in (F), includes fields for accounting year and month, project code, cost element code, and amount. In the example shown in the figure, the first row contains accounting year and month "2024 / 05", project code "PJ2405000001-0001-0001", cost element code "110", and amount "24,000".

[0065] (S4: Project Income and Expenditure Report Output Processing) Referring to Figure 11, a specific example of the project income and expenditure report output process will be explained. The income and expenditure output unit 102d, for example, in response to the operator's operation on the income and expenditure output screen (not shown) displayed on the monitor 114, refers to the actual cost table and displays and outputs a project income and expenditure report for the target project, showing the planned labor costs for each cost element for each accounting month. The project income and expenditure report makes it possible to view labor costs by cost element for which settings have been made. Figure 11 is a diagram showing an image of the project income and expenditure report. As shown in Figure 11, the project income and expenditure report includes, for example, the planned labor costs for each cost element (labor costs (normal), labor costs (overtime), labor costs (night work), ...) for each project and accounting month.

[0066] As described above, according to this embodiment, the cost accounting unit 102c obtains employees, work content, and work hours from the daily report data stored in the storage unit 106, obtains the planned man-hour unit price code using the employee as the key by referring to the employee master 106e, obtains cost elements using the obtained work content as the key by referring to the work content classification determination master 106b, obtains the planned cost (standard unit price, multiplier) using the obtained planned man-hour unit price master 106d as the key by referring to the obtained planned man-hour unit price code and cost elements, and calculates the planned labor cost for each cost element for the obtained employees by multiplying the planned cost by the work hours, making it possible to calculate planned labor costs that are closer to the actual situation.

[0067] [4. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving operational efficiency and promoting appropriate management decisions within companies, thereby enabling contributions to SDGs Goals 8 and 9.

[0068] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and digital processes, thereby contributing to SDGs Goals 12, 13, and 15.

[0069] Furthermore, this embodiment can contribute to strengthening control and governance, thereby enabling contributions to SDG Goal 16.

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

[0071] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically by known methods.

[0072] Furthermore, the processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each process, screen examples, and database configuration shown in this specification and in the drawings may be changed at will unless otherwise specified.

[0073] Furthermore, with respect to the planned labor cost calculation device 100, each component shown in the diagram is a functional concept and does not necessarily need to be physically configured as shown.

[0074] For example, the processing functions of the planned labor cost calculation device 100, particularly those performed by the control unit 102, may be implemented in whole or in part by a CPU and a program interpreted and executed by the CPU, or they may be implemented as wired logic hardware. The program is recorded on a non-temporary computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processing described in this embodiment, and is mechanically read by the planned labor cost calculation device 100 as needed. That is, a storage unit such as ROM or HDD (Hard Disk Drive) contains a computer program that works in cooperation with the OS to give instructions to the CPU and perform various processing tasks. This computer program is executed by being loaded into RAM and works in cooperation with the CPU to constitute the control unit.

[0075] Furthermore, this computer program may be stored on an application program server connected to the planned labor cost calculation device 100 via any network, and it is possible to download all or part of it as needed.

[0076] Furthermore, the program for executing the processing described in this embodiment may be stored on a non-temporary computer-readable recording medium, or it may be configured as a program product. Here, "recording medium" includes any "portable physical medium" such as memory cards, USB (Universal Serial Bus) memory, SD (Secure Digital) cards, flexible disks, magneto-optical disks, ROMs, EPROMs (Erasable Programmable Read Only Memory), EEPROMs (Registered Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROMs (Compact Disk Read Only Memory), MOs (Magneto-Optical disks), DVDs (Digital Versatile Disks), and Blu-ray (Registered Trademark) Discs.

[0077] Furthermore, "program" refers to a data processing method described in any language or writing method, regardless of its format, such as source code or binary code. Note that "program" is not necessarily limited to a single, monolithic structure; it also includes distributed structures consisting of multiple modules or libraries, and those that work in cooperation with other programs, such as an operating system, to achieve their functions. Regarding the specific configuration and reading procedures for reading the recording medium in each device shown in this embodiment, as well as the installation procedures after reading, well-known configurations and procedures can be used.

[0078] The various databases stored in the memory unit 106 include memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files used for various processes and website provision.

[0079] Furthermore, the planned labor cost calculation device 100 may be configured as a known personal computer or workstation or other information processing device, or as an information processing device to which any peripheral devices are connected. Alternatively, the planned labor cost calculation device 100 may be implemented by installing software (including programs or data, etc.) that enables the processing described in this embodiment onto the device.

[0080] Furthermore, the specific forms of distribution and integration of the devices are not limited to those shown in the figures, and all or part of them can be configured by functionally or physically distributing and integrating them in any unit according to various additions or functional loads. In other words, the embodiments described above may be implemented in any combination, or the embodiments may be implemented selectively. [Explanation of symbols]

[0081] 100 Planned Labor Cost Calculation Device 102 Control Unit 102a Master Maintenance Department 102b Daily Report Registration Department 102c Cost Accounting Department 102d Income and Expenditure Output Unit 102e Screen display control unit 104 Communication Interface Section 106 Storage section 106a Work Content Master 106b Master for determining work content classification 106c Cost Element Master 106d Planned Man-Hour Unit Price Master 106e Employee Master 200 servers 300 Networks

Claims

1. A planned labor cost calculation device equipped with a control unit, The control unit, A master data set containing a planned man-hour unit price code, cost elements specifying labor cost patterns, work content specifying various tasks, and a set of master data associated with planned unit prices, The employee master data, which associates employees with their planned man-hour unit price codes, Daily report data including work date, employee, target project, work content, and work time, It is configured to be accessible, A planned labor cost calculation device is characterized by comprising cost calculation means that obtains employees, work content, and work hours from the aforementioned daily report data, obtains a planned labor cost code using the employee as the key by referring to the aforementioned employee master, obtains cost elements from the master group using the obtained work content as the key, obtains a planned unit price using the obtained planned labor cost code and cost elements as the key, and calculates the planned labor cost for each employee for each cost element by multiplying the planned unit price by the work hours.

2. The aforementioned master group is A master data set for classifying work content, which associates work content with cost elements, A planned work hour cost master, which is registered by associating the planned work hour cost code, cost elements, and planned cost, Includes, The cost calculation means is characterized in that it obtains cost elements by referring to the work content classification discrimination master and using the obtained work content as a key, obtains the planned cost by referring to the planned man-hour unit price master and using the obtained planned man-hour unit price code and cost elements as keys, and calculates the planned labor cost for each cost element for the obtained employee by multiplying the planned cost by the working time, as described in claim 1.

3. The planned labor cost calculation device according to claim 1 or 2, characterized in that the planned unit price includes a standard unit price and a multiplier to be applied to the standard unit price.

4. The planned labor cost calculation device according to claim 1 or 2, characterized in that the work content includes normal work, overtime work, and night work, and the cost elements include labor costs (normal), labor costs (overtime), and labor costs (night).

5. A method for calculating planned labor costs, which is performed by an information processing device equipped with a control unit, The control unit, A master data set containing a planned man-hour unit price code, cost elements specifying labor cost patterns, work content specifying various tasks, and a set of master data associated with planned unit prices, The employee master data, which associates employees with their planned man-hour unit price codes, Daily report data including work date, employee, target project, work content, and work time, It is configured to be accessible, The control unit is executed as follows: A method for calculating planned labor costs, characterized by including a cost calculation step which involves obtaining employees, work content, and work hours from the aforementioned daily report data, obtaining a planned labor cost code using the employee as the key by referring to the aforementioned employee master, obtaining cost elements from the master group using the obtained work content as the key, obtaining a planned unit price using the obtained planned labor cost code and cost elements as the keys, and for each employee, calculating the planned labor cost by multiplying the planned unit price by the work hours for each cost element.

6. A program for calculating planned labor costs to be executed by an information processing device equipped with a control unit, The control unit, A master data set containing a planned man-hour unit price code, cost elements specifying labor cost patterns, work content specifying various tasks, and a set of master data associated with planned unit prices, The employee master data, which associates employees with their planned man-hour unit price codes, Daily report data including work date, employee, target project, work content, and work time, It is configured to be accessible, The control unit, A program for calculating planned labor costs that executes a cost calculation process to obtain employee, work content, and work time from the aforementioned daily report data, obtain the planned labor cost unit code using the employee as the key by referring to the aforementioned employee master, obtain cost elements from the master group using the obtained work content as the key, obtain the planned unit price using the obtained planned labor cost unit code and cost elements as the keys, and calculate the planned labor cost for each employee by calculating the planned labor cost multiplied by the planned unit price for each cost element.

Images