Outsourcing cost processing device, outsourcing cost processing method, and outsourcing cost processing program
The subcontracting cost processing device automates subcontracting cost accounting by aggregating and transferring costs based on daily reports, addressing high workload and delay issues in companies with many subcontracting employees, ensuring timely and efficient cost management.
Patent Information
- Application Number
- JP2023222695
- Authority / Receiving Office
- JP · JP
- Patent Type
- Applications
- Current Assignee / Owner
- Filing Date
- 2023-12-28
- Publication Date
- 2025-07-10
AI Technical Summary
In companies with a large number of subcontracting employees, the workload for subcontracting cost accounting operations is high and prone to delays when assigned tasks are not determined at the time of ordering arrangements, leading to potential processing delays and increased costs that are only recognized at the end of the month.
A subcontracting cost processing device and method that includes inputting and registering indirect and direct project data, daily work results, and procurement data, with automated aggregation and transfer of costs to direct projects based on daily report results, using a control unit to manage and calculate subcontracting costs efficiently.
Enables quick and low-load subcontracting cost accounting even when assigned tasks are not determined, allowing early completion of monthly settlements and timely identification of cost performance issues.
Smart Images

Figure 2025104704000001_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to a subcontracting cost processing device, a subcontracting cost processing method, and a subcontracting cost processing program.
Background Art
[0002] For example, as a system for processing subcontracting costs, there has been conventionally Patent Document 1.
Prior Art Documents
Patent Documents
[0003]
Patent Document 1
Summary of the Invention
Problems to be Solved by the Invention
[0004] Conventionally, in a company with a large number of subcontracting employees, when the assigned tasks for subcontracting employees are not determined at the time of ordering arrangements, there has been a problem that the workload of subcontracting cost accounting operations is high and there is a risk of processing delays.
[0005] The present invention has been made in view of the above, and an object thereof is to provide a subcontracting cost processing device, a subcontracting cost processing method, and a subcontracting cost processing program that can perform subcontracting cost accounting operations with a low load and quickly even when the assigned tasks for subcontracting employees are not determined at the time of ordering arrangements in a company with a large number of subcontracting employees.
Means for Solving the Problems
[0006] In order to solve the above problems and achieve the object, the present invention is a subcontracting cost processing device provided with a control unit, wherein the control unit, when the assigned cases of subcontracting employees have not been determined, inputs indirect project data including an indirect project for charging department costs not associated with customers and registers it in a storage area; an indirect project input means; inputs order data associated with the indirect project and registers it in the storage area; a term contract order input means; inputs direct project data including the direct project of the assigned target case of the subcontracting employee and registers it in the storage area; a project registration means; inputs daily work results including the daily actual working hours of the subcontracting employee and the working hours for each work content of the direct project for the direct project of the subcontracting employee and registers it in the storage area; a daily report input means; based on the order data and the daily work results, inputs procurement data including the working hours and the procurement amount which is the indirect subcontracting cost for the indirect project of the subcontracting employee and registers it in the storage area; a term contract procurement input means; and based on the procurement data, transfers the indirect subcontracting cost registered in the indirect project of the subcontracting employee to each direct project; a subcontracting man-hour input means, characterized in that it is provided with.
[0007] Also, according to one aspect of the present invention, the control unit may further be provided with a daily report aggregation means for extracting the daily work results registered in the storage area based on extraction conditions specified in response to an operator's operation on a daily report aggregation screen and outputting a daily report aggregation table by employee or by project.
[0008] Also, according to one aspect of the present invention, the control unit is configured to be able to access an employee master registered in association with a subcontracting employee and a planned man-hour unit price code, a work content master registered in association with a work content and a daily report man-hour handling classification specifying man-hour handling or non-man-hour handling, and a planned man-hour unit price master registered in association with a planned man-hour unit price code, a cost element, and a standard unit price. The daily report aggregation means acquires a planned man-hour unit price code from the employee master using the employee as a key for each outsourced employee, and acquires a standard unit price from the planned man-hour unit price master using the acquired planned man-hour unit price code as a key, calculates the daily report registration time which is the total of the standard unit price × working hours of the work content, and sets the total time as the outsourcing cost. At this time, when the work content has a daily report man-hour handling classification in the work content master = "not man-hour handled", it may be excluded from the calculation.
[0009] Also, according to one aspect of the present invention, the periodic contract procurement means may calculate the operating hours by aggregating the daily report registration times for each work content of the outsourced employees, and exclude the operating hours when the work content has a daily report man-hour handling classification in the work content master = "not man-hour handled".
[0010] Also, according to one aspect of the present invention, the periodic contract procurement means may create journal entries based on the procurement data.
[0011] In addition, in order to solve the above-described problems and achieve the object, the present invention provides a subcontracting cost processing method executed by an information processing apparatus including a control unit. When the assigned projects of subcontracting employees have not been determined in the control unit, an indirect project input step of inputting indirect project data including an indirect project for charging department costs not associated with a customer and registering it in a storage area, a term contract order input step of inputting order data associated with the indirect project and registering it in the storage area, a project registration step of inputting direct project data including a direct project of an assigned project of a subcontracting employee and registering it in the storage area, a daily report input step of inputting a daily report result including the actual working hours of the subcontracting employee by day and the working hours for each work content of the direct project and registering it in the storage area, a term contract procurement input step of inputting procurement data including the operating hours and the procurement amount as the indirect subcontracting cost for the indirect project of the subcontracting employee based on the order data and the daily report result and registering it in the storage area, and a subcontracting man-hour input step of transferring the indirect subcontracting cost registered in the indirect project of the subcontracting employee to each direct project based on the procurement data.
[0012] Also, in order to solve the above-described problems and achieve the object, the present invention is a subcontracting cost processing program for causing an information processing apparatus including a control unit to execute, wherein when an assigned task of a subcontracting employee has not been determined in the control unit, indirect project data including an indirect project for charging department expenses not associated with a customer is input and registered in a storage area in an indirect project input step, a term contract order input step of inputting order data associated with the indirect project and registering it in the storage area, a project registration step of inputting direct project data including a direct project of an assigned target task of a subcontracting employee and registering it in the storage area, a daily report input step of inputting a daily report result including the actual working hours of a subcontracting employee by day and the working hours for each work content of a direct project and registering it in the storage area, a term contract purchase input step of inputting purchase data including the operating hours and the purchase amount which is an indirect subcontracting cost for the indirect project of a subcontracting employee based on the order data and the daily report result and registering it in the storage area, and a subcontracting man-hour input step of transferring the indirect subcontracting cost registered in the indirect project of a subcontracting employee to each direct project based on the purchase data. The subcontracting cost processing program is characterized by being for causing the above steps to be executed.
Effect of the Invention
[0013] According to the present invention, in an enterprise with a large number of subcontracting employees, even when the assigned task of a subcontracting employee has not been determined at the time of placing an order, it is possible to perform the subcontracting cost accounting work with a low load and quickly.
Brief Description of the Drawings
[0014]
Figure 1
Figure 2
Figure 3
Figure 4
Figure 5
Figure 6
Figure 7
Figure 8
Figure 9
Figure 10
Figure 11
Figure 12
Figure 13
Figure 14
Figure 15
Figure 16
Figure 17
Figure 18
Figure 19
Figure 20
Figure 21
Figure 22
Figure 23
Figure 24
BEST MODE FOR CARRYING OUT THE INVENTION
[0015] Embodiments of the present invention will be described in detail with reference to the drawings. Note that the present invention is not limited by these embodiments. Also, known techniques and well-known techniques are incorporated herein by reference, and descriptions of known techniques and well-known techniques may be omitted.
[0016] [1. Overview] The overview of the present embodiment will be described in the order of [1-1. Problem], [1-2. Focus and solution to the problem], [1-3. Effect], and [1-4. Functional overview of the present embodiment].
[0017] [1-1. Problem] In a corporate entity with more than 300 outsourced employees, during the period when the assigned projects have not been determined at the time of placing an order, in the case of arranging contract employees (there are many cases where the skills of outsourced employees are not clear), when recording the outsourcing fees, the work of aggregating the projects completed during the contract period and the daily report time after each project, and the high workload of the outsourcing fee recording work and the delay in the monthly closing schedule have been issues. That is, in a company with a large number of outsourced employees, when the assigned projects for outsourced employees have not been determined at the time of placing an order, there is an issue that the workload of the outsourcing fee recording work is high and there is a risk of processing delays. Also, since the outsourcing fees cannot be clarified until the end of the month, there are situations where it is not noticed until the end of the month that the outsourcing fees have increased due to troubles occurring at the beginning of the month, and there have also been cases where the timing of implementing countermeasures for ongoing projects has been delayed.
[0018] [1-2. Focus points and solutions for problem-solving] In this embodiment, in a company with a large number of outsourced employees, even when the assigned projects for outsourced employees have not been determined at the time of placing an order, the outsourcing fee recording work can be executed with a low workload and quickly. Specifically, it focused on improving the business issues of a corporate entity with many outsourced employees. It improved the issue of the delay in the monthly closing schedule, leading to the early completion of the monthly settlement. Also, the improvement was that during automatic aggregation, work content CDs that should not be included in the outsourcing fee recording, such as meeting times within the affiliated company, were discriminated, and control was added so that it could be set as a parameter whether to include it in the aggregation time. Regarding the issue that the actual results of the outsourcing fees cannot be determined until the end of the month, it focused on the fact that outsourced employees also register their daily activity results as daily report results.
[0019] [1-3. Effects] In this embodiment, in a company with a large number of outsourced employees, even when the assigned tasks for outsourced employees have not been determined at the time of placing an order, the outsourcing cost accounting operation can be performed with a low load and quickly. Specifically, during the period when the assigned tasks have not been determined at the time of placing an order, the arrangement for temporary contract employees is requested through an indirect project. At the time of outsourcing inspection and acceptance, the daily report times registered in association with the direct project are manually aggregated by time, and the outsourcing cost is accounted for. However, the above problem has been solved by implementing a function to automatically aggregate the daily report results of dispatched employees requested. Also, at the end of the month, the cost performance is not known for the first time at the time of accounting for outsourcing costs. Instead, by implementing a function that enables grasping the profit and loss situation for each project and contract details based on the daily report results of outsourced employees every day, and enables early grasping of a sharply rising cost performance in case of occurrence of troubles, the above problem has been solved.
[0020] [1-4. Functional Overview of this Embodiment] The outsourcing cost processing device of this embodiment implements the following functions. (1) When arranging temporary contract employees, place an order in a state where the assigned tasks have not been determined. After that, implement a function to automatically aggregate the basis time for accounting for outsourcing costs based on the daily report times of each task for which the assigned task has been determined and the daily report has been registered within the contract period. Account for the outsourcing cost (as indirect cost / department cost) based on the aggregated time. (2) Implement a function to perform cost accounting for each project and contract details as planned outsourcing cost = daily report result × planned unit price based on the daily report results registered by outsourced employees every day and the planned unit price information that can be associated with each outsourced employee. (3) Implement a function to allocate the accounted outsourcing cost (indirect cost / department cost) directly as outsourcing cost to each project for which the daily report has been registered. At the end of the month, when each indirect outsourcing cost is transferred to the direct outsourcing cost, the cost information reflected in each project and contract details changes from the planned outsourcing cost to the actual direct outsourcing cost.
[0021] The outsourcing cost processing device of this embodiment can be widely applied to companies engaged in project management-type operations such as software consignment development companies.
[0022] [2. Configuration] An example of the configuration of the outsourcing cost processing apparatus according to this embodiment will be described with reference to the drawings.
[0023] FIG. 1 is a block diagram showing an example of the outsourcing cost processing apparatus according to this embodiment. The outsourcing cost processing apparatus 100 is a workstation, a commercially available desktop personal computer, or the like.
[0024] The outsourcing cost processing 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 outsourcing cost processing apparatus 100 is communicably connected via an arbitrary communication path.
[0025] The communication interface unit 104 communicably connects the outsourcing cost processing apparatus 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 mutually communicably connecting the outsourcing cost processing apparatus 100 and the server 200, the terminal 400,... and is, for example, the Internet or a LAN (Local Area Network). Thereby, the communication interface unit 104 is configured to be able to perform data communication with the server 200 via the network 300.
[0026] An input device 112 and an output device 114 are connected to the input / output interface unit 108. As the output device 114, in addition to a monitor (including a home television), a speaker or a printer can be used. As the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that cooperates with the mouse to realize a pointing device function can be used. Hereinafter, 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.
[0027] The storage unit 106 stores various databases, tables, files, and the like. In the storage unit 106, a computer program for giving instructions to the CPU (Central Processing Unit) in cooperation with the OS (Operating System) to perform various processes is recorded. As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, or the like can be used.
[0028] Further, this storage unit 106 includes an employee master 106a, a supplier master 106b, a payee master 106c, a customer master 106d, a billing destination master 106e, a sales product master 106f, a work content master 106g, a job content master 106h, a planned man-hour unit price header master 106i, a planned man-hour unit price detail master 106j, and a data file 106k. FIG. 2 is a diagram showing a configuration example of the employee master 106a. FIG. 3 is a diagram showing a configuration example of the supplier master 106b. FIG. 4 is a diagram showing a configuration example of the payee master 106c. FIG. 5 is a diagram showing a configuration example of the customer master 106d. FIG. 6 is a diagram showing a configuration example of the billing destination master 106e. FIG. 7 is a diagram showing a configuration example of the sales product master 106f. FIG. 8 is a diagram showing a configuration example of the work content master 106g. FIG. 9 is a diagram showing a configuration example of the job content master 106h. FIG. 10 is a diagram showing a configuration example of the planned man-hour unit price header master 106i. FIG. 11 is a diagram showing a configuration example of the planned man-hour unit price detail master 106j.
[0029] As shown in FIG. 2, the employee master 106a can be composed of a table or the like in which an employee (employee CD and / or employee name), a revision date, an in-house / outsourcing division (0: in-house, 1: outsourcing), an affiliated subcontractor CD, a planned man-hour unit price, and a department CD are associated and registered.
[0030] As shown in FIG. 3, the supplier master 106b can be composed of a table or the like that registers by associating the supplier name, the revision date, the contract target classification (1: target, 0: not target), and the payee CD. It is referred to when converting the payee CD and the supplier name.
[0031] As shown in FIG. 4, the payee master 106c can be composed of a table or the like that registers by associating the payee CD, the payee name, and the revision date. It is referred to when converting the payee CD and the payee name.
[0032] As shown in FIG. 5, the customer master 106d can be composed of a table or the like that registers by associating the customer CD, the customer name, the revision date, and the billing destination CD. It is referred to when converting the customer CD and the customer name.
[0033] As shown in FIG. 6, the billing destination master 106e can be composed of a table or the like that registers by associating the billing destination CD, the billing destination name, and the revision date. It is referred to when converting the billing destination CD and the billing destination name.
[0034] As shown in FIG. 7, the sales product master 106f can be composed of a table or the like that registers by associating the sales product CD, the sales product name, the unit, the sales tax classification, and the sales item.
[0035] As shown in FIG. 8, the work content master 106g can be composed of a table or the like that registers by associating the work content CD, the work content name, the vacation classification name, the start time, the end time, and the break time.
[0036] As shown in FIG. 9, the operation content master 106h can be composed of a table or the like that registers by associating the operation content CD, the operation content name, the revision date, and the daily work hours handling classification name (0: work hours handling, 1: non-work hours handling).
[0037] As shown in FIG. 10, the planned work hours unit price header master 106i can be composed of a table or the like that registers by associating the planned work hours unit price CD, the planned work hours unit price name, and the revision date.
[0038] The planned man-hour unit price details master 106j can be composed of a table or the like that registers by associating the planned man-hour unit price CD, the cost element CD, the cost element name, the revision date, and the standard unit price, as shown in FIG. 11.
[0039] The data file 106k is for storing various data such as indirect project data (indirect project header data, indirect project details data), order data (order header data, order details data), direct project data, contract details data, daily report actual results (daily report data and work content data), purchase data (purchase header data, purchase details data), and period contract transfer data.
[0040] The indirect project data is composed of indirect project header data and indirect project details data. The indirect project header data may include the project CD, project name, project start time, and project end time. The indirect project details data may include the project CD, contract details No, administrator, management department, and JOB No.
[0041] The order data is composed of order header data and order details data. The order header data may include the order number, order date, planned purchase date, supplier, and payee. The order details data may include items such as the order number, line number, PJNo - contract details No - JOBNo, debt account classification, cost-bearing department, contract period, employee CD, basic amount, lower limit time, lower limit unit price, upper limit time, and upper limit unit price.
[0042] The direct project data may include the project CD, project name, PJ start time, PJ end time, sales representative, and sales representative department.
[0043] The contract details data may include PJCD - contract details No, contract details name, order receipt date, customer, billing address, estimated sales amount, and estimated sales consumption tax.
[0044] The daily report results are composed of daily report data and work content data. The daily report data may include the date, day of the week, employee, work details, working hours, break time, and actual working hours. The work content data is for holding the work content and its working hours for each subcontractor for each direct project - contract details, and may include the PJCD - contract details No, work content, and working hours.
[0045] The purchase data is composed of purchase header data and purchase details data. The purchase header data may include the purchase number, order number, purchase date, closing date, scheduled payment date, supplier, and payee. The purchase details data may include the purchase number, line number, PJNo - contract details No - JOBNo, debt subject classification, cost - bearing department, contract period, employee CD, operating hours, payment time, purchase amount, purchase consumption tax, lower limit time and lower limit unit price, upper limit time, and upper limit unit price.
[0046] The period contract transfer data may include the purchase invoice No, details No, transfer date, transfer SEQ, transfer ratio, and transfer purchase principal amount.
[0047] Returning to Figure 2, the control unit 102 is a CPU or the like that comprehensively controls the subcontracting cost processing device 100. The control unit 102 has an internal memory for storing control programs such as the OS, programs defining various processing procedures, and required data, and executes various information processes based on these stored programs.
[0048] The control unit 102 is configured to be able to access the employee master 106a, supplier master 106b, payee master 106c, customer master 106d, billing destination master 106e, sales product master 106f, work content master 106g, task content master 106h, planned man-hour unit price header master 106i, planned man-hour unit price detail master 106j, data file 106k, etc. stored in the storage unit 106. Note that the employee master 106a, supplier master 106b, payee master 106c, customer master 106d, billing destination master 106e, sales product master 106f, work content master 106g, task content master 106h, planned man-hour unit price header master 106i, planned man-hour unit price detail master 106j, data file 106k, etc. may be provided in other locations (for example, server 200), as long as the control unit 102 can access them.
[0049] Functionally conceptually, the control unit 102 includes an indirect project input processing unit 102a, a term contract purchase order input processing unit 102b, a project registration processing unit 102c, a contract detail registration processing unit 102j, a daily report input processing unit 102d, a daily report aggregation processing unit 102e, a term contract procurement input processing unit 102f, a subcontract man-hour input processing unit 102g, a master maintenance unit 102h, and a screen display control unit 102i.
[0050] For example, when the assigned project of the subcontractor is not determined, the indirect project input processing unit 102a inputs indirect project data (indirect project header data and indirect project detail data) including an indirect project for charge of department expenses not associated with a customer in response to an operator's operation on an indirect project input screen (not shown) displayed on the monitor 114, and registers it in the data file 106k.
[0051] For example, the term contract purchase order input processing unit 102b inputs purchase order data (purchase order header data and contract detail data) associated with an indirect project in response to an operator's operation on a term contract purchase order input screen (not shown) displayed on the monitor 114, and registers it in the data file 106k.
[0052] The project registration processing unit 102c inputs direct project data including the direct projects of the contract work orders assigned to the subcontractors according to the operations of the operator on the project input screen displayed on the monitor 114, for example, and registers it in the data file 106k.
[0053] The contract details registration processing unit 102j inputs contract details data including the contract details associated with the direct projects according to the operations of the operator on the contract details registration screen displayed on the monitor 114, for example, and registers it in the data file 106k.
[0054] The daily report input processing unit 102d inputs the daily report results (daily report data and work content data) of the subcontractors and registers them in the data file 106k.
[0055] The daily report aggregation processing unit 102e extracts the daily report results (daily report data and work content data) registered in the data file 106k based on the extraction conditions specified according to the operations of the operator on the daily report aggregation screen displayed on the monitor 114, for example, and displays and outputs a daily report aggregation table by employee or by project. Also, the daily report aggregation processing unit 102e obtains the planned man-hour unit price code from the employee master 106a for each subcontractor using the employee as the key, and obtains the standard unit price from the planned man-hour unit price details master 106j using the obtained planned man-hour unit price code as the key, calculates the total daily report registration time which is the sum of the standard unit price multiplied by the working hours of the work content, and regards the total time as the subcontracting cost. In this case, if the work content is such that the daily report man-hour handling classification in the work content master 106h = "non-man-hour handling", it may be excluded from the calculation.
[0056] The contract-period procurement input processing unit 102f creates procurement data including the operation time and the procurement amount, which is the indirect outsourcing cost, for the indirect projects of the outsourced employees based on the order data and the daily report results according to the operator's operations on the contract-period procurement input screen 450 displayed on the monitor 114, and registers the data in the data file 106k. The operation time is obtained by aggregating the daily report registration times for each work content of the outsourced employees, and may be excluded from the operation time if the work content has a daily report man-hour handling classification name in the work content master 106h of "1: Not handled as man-hours". Further, the contract-period procurement input processing unit 102f may create journal entries based on the procurement data.
[0057] The outsourced man-hour input processing unit 102g transfers the indirect outsourcing costs registered in the indirect projects of the outsourced employees to each direct project based on the procurement data according to the operator's operations on the outsourced man-hour input screen 460 displayed on the monitor 114, and registers the contract-period transfer data in the data file 106k.
[0058] The master maintenance unit 102h is for performing settings such as data input, addition, change, and update on the employee master 106a, the supplier master 106b, the payee master 106c, the customer master 106d, the billing destination master 106e, the sales product master 106f, the work content master 106g, the operation content master 106h, the planned man-hour unit price header master 106i, and the planned man-hour unit price detail master 106j according to the operator's operations on a master maintenance screen (not shown).
[0059] The screen display control unit 102i controls the display and input reception of various screens (for example, the master maintenance screen, the contract-period order input screen, the project registration screen, the contract detail registration screen, the daily report aggregation screen, the contract-period procurement input screen, the outsourced man-hour input screen, etc.).
[0060] [3. Specific Example] A specific example of the processing of the control unit 102 of the outsourcing cost processing apparatus 100 according to the present embodiment will be described with reference to FIGS. 1 to 24. FIGS. 12 to 24 are diagrams for explaining a specific example of the processing of the control unit 102 of the outsourcing cost processing apparatus 100 according to the present embodiment.
[0061] (3-1. Overall Processing) FIG. 12 is a flowchart for explaining the overall processing flow of the control unit 102 of the outsourcing cost processing apparatus 100. With reference to FIG. 12, the overall processing flow of the control unit 102 of the outsourcing cost processing apparatus 100 will be described.
[0062] In FIG. 12, the indirect project input processing unit 102a executes indirect project input processing (step S1). Specifically, in the indirect project input processing, the indirect project input processing unit 102a inputs, for example, in response to an operator's operation on an indirect project input screen (not shown) displayed on the monitor 114, indirect project data (indirect project header data and indirect project detail data) including an indirect project for charging department costs not associated with a customer when the assigned project for the outsourcing employee has not been determined, and registers it in the data file 106k.
[0063] The term contract order input processing unit 102b executes term contract order input processing (step S2). Specifically, in the term contract order input processing, the term contract order input processing unit 102b inputs, for example, in response to an operator's operation on a term contract order input screen displayed on the monitor 114, order data (order header data and contract detail data) associated with the indirect project, and registers it in the data file 106k.
[0064] The project registration processing unit 102c executes project registration processing (step S3). Specifically, in the project registration processing, the project registration processing unit 102c inputs, for example, in response to an operator's operation on a project input screen displayed on the monitor 114, direct project data including a direct project of the project to be assigned to the outsourcing employee, and registers it in the data file 106k.
[0065] The contract details registration processing unit 102j executes the contract details registration process (step S4). Specifically, in the contract details registration process, the contract details registration processing unit 102j inputs contract details data including contract details directly associated with the project in response to an operator's operation on the contract details registration screen displayed on the monitor 114, for example, and registers it in the data file 106k.
[0066] The daily report input processing unit 102d executes the daily report input process (step S5). Specifically, in the daily report input process, the daily report input processing unit 102d inputs the daily report results (daily report data and work content data) of the subcontracting employees and registers them in the data file 106k.
[0067] The daily report aggregation processing unit 102e executes the daily report aggregation process (step S6). Specifically, in the daily report aggregation process, the daily report aggregation processing unit 102e extracts the daily report results (daily report data and work content data) registered in the data file 106k based on the extraction conditions specified in response to an operator's operation on the daily report aggregation screen displayed on the monitor 114, for example, and displays and outputs a daily report aggregation table by employee or by project. Also, for each subcontracting employee, the daily report aggregation processing unit 102e obtains the planned man-hour unit price code from the employee master 106a using the employee as a key, and obtains the standard unit price from the planned man-hour unit price details master 106j using the obtained planned man-hour unit price code as a key, calculates the total daily report registration time which is the sum of the standard unit price × the working hours of the work content, and regards the total time as the subcontracting cost. At that time, if the work content is such that the daily report man-hour handling classification in the work content master 106h = "non-man-hour handling", it may be excluded from the calculation.
[0068] The contract-period procurement input processing unit 102f executes contract-period procurement input processing (step S7). Specifically, in the contract-period procurement input processing, the contract-period procurement input processing unit 102f creates procurement data including the operation time and the procurement amount which is the indirect outsourcing cost for the indirect projects of the outsourced employees based on the order data and the daily report results according to the operator's operations on the contract-period procurement input screen displayed on the monitor 114, and registers it in the data file 106k. The operation time is obtained by aggregating the daily report registration times for each work content of the outsourced employees, and may be excluded from the operation time when the work content has the daily report man-hour handling classification name in the work content master 106h = "1: not handled as man-hours". Further, the contract-period procurement input processing unit 102f may create journal entries based on the procurement data.
[0069] The outsourced man-hour input processing unit 102g executes outsourced man-hour input processing (step S8). Specifically, in the outsourced man-hour input processing, the outsourced man-hour input processing unit 102g transfers the indirect outsourcing cost registered in the indirect projects of the outsourced employees to each direct project based on the procurement data according to the operator's operations on the outsourced man-hour input screen 460 displayed on the monitor 114, and registers the contract-period transfer data in the data file 106k.
[0070] (3-2. Sample Data) With reference to FIGS. 13 to 24, a specific example of the processing of the control unit 102 of the outsourcing cost processing apparatus 100 will be described. FIGS. 13 to 24 are diagrams showing sample data for explaining a specific example of the processing of the control unit 102 of the outsourcing cost processing apparatus 100.
[0071] 1. The flow up to the recording of outsourcing costs (planned cost recording → indirect outsourcing cost recording) will be described. (S1: Indirect project input processing) With reference to FIG. 13, a specific example of the indirect project input processing will be described. In the indirect project input processing, for example, when the assignment of the outsourced employee in charge of the system engineering service business has not been determined, a cost recording destination project is created.
[0072] The indirect project input processing unit 102a inputs, for example, indirect projects (indirect project header data and indirect project detail data) for charging department expenses not associated with a customer when the assigned projects for subcontractors are not determined according to the operator's operations on an indirect project input screen (not shown) displayed on the monitor 114, and registers them in the data file 106k.
[0073] Fig. 13(A) is a diagram showing a data example of indirect project header data. The indirect project header data includes items such as project CD, project name, project start time, and project end time. In the example shown in the figure, the project CD is "Kan00001", the project name is "Subcontracted Expense Accounting Project for the First Business Unit from April to June", the project start is "2023 / 4 / 1", and the project end is "2023 / 6 / 28".
[0074] Fig. 13(B) is a diagram showing a data example of indirect project detail data. The indirect project detail data may include project CD, contract detail No, administrator, management department, and JOB No. In the example shown in the figure, for the first row, the project CD is "Kan00001", the contract detail No is "0001", the administrator is "SE01: Taro Tanaka", the management department is "D001: First Business Unit", and the JOB No is "001: Cost".
[0075] (S2: Input for Period Contract Order Placement) Referring to Fig. 14, a specific example of the input processing for period contract order placement will be described. Input processing for period contract order placement In this case, when the assigned projects are not determined at the arrangement stage, order placement arrangements are made in association with indirect projects (department expense charge PJs not associated with customers).
[0076] The period contract order placement input processing unit 102b inputs, for example, order placement data (order placement header data and contract detail data) associated with an indirect project according to the operator's operations on a period contract order placement input screen displayed on the monitor 114, and registers them in the data file 106k.
[0077] FIG. 14(A) is a diagram showing an example of the display of the periodic order input screen 410. The periodic order input screen 41 includes a header area 411 for specifying the order number (automatically numbered), order date, planned purchase date, supplier, payee, etc., and a detail area 412 for specifying PJNo - contract detail No - JOBNo, debt item classification, cost - bearing department, contract period, employee CD, basic amount, lower limit time, lower limit unit price, upper limit time, upper limit unit price, and a registration button (not shown).
[0078] When the registration button (not shown) is pressed, the order header data and order detail data corresponding to the input contents on the screen are registered. In the case of the input contents shown in this figure, the data in the first row of the order header data and order detail data in FIGS. 14(B) and 14(C) are registered.
[0079] FIG. 14(B) is a diagram showing an example of the order header data. The order header data may include the order number, order date, planned purchase date, supplier, payee. In the example shown in this figure, the first row shows the order number "HAT0000001", order date "2023 / 4 / 1", planned purchase date "2023 / 4 / 30", supplier "Gai1001 (〇△ Engineering)", payee "Gai0001 (〇△ Engineering)".
[0080] FIG. 14(C) is a diagram showing an example of the order detail data. The order detail data has items of order number, line number, PJNo - contract detail No - JOBNo, debt item classification, cost - bearing department, contract period, employee CD, basic amount, lower limit time, lower limit unit price, upper limit time, upper limit unit price. In the example shown in this figure, the first row shows the order number "HAT0000001", line number "1", PJNo - contract detail No - JOBNo "Kan0001 - 0001 - 0001", debt item classification "21: Accounts Payable", cost - bearing department "2100: First Business Unit", contract period "2023 / 4 / 1 to 2023 / 4 / 30", employee CD "GaiCh001", basic amount "400,000", lower limit time "130H", lower limit unit price "2,500", upper limit time "180H", upper limit unit price "3,500".
[0081] (S3: Project registration process) Referring to FIGS. 15 and 16, a specific example of the project registration process will be described. In the project registration process, the orders placed with external contractors and the cases assigned to external employees are directly registered in the project (the order contract associated with the customer).
[0082] The project registration processing unit 102c inputs, for example, direct project data including the direct project of the cases assigned to external employees in response to the operator's operation on the project input screen displayed on the monitor 114, and registers it in the data file 106k.
[0083] FIG. 15(A) is a diagram showing a display example of the project registration screen 420. The project registration screen 420 includes columns for specifying the project No (automatically numbered), project name, salesperson in charge, sales department in charge, customer, and billing destination, and a registration button (not shown).
[0084] When the registration button (not shown) is pressed, direct project data corresponding to the input content on the screen is registered. In the case of the input content shown in the figure, data like the first line of the direct project data shown in FIG. 16(A) is registered.
[0085] FIG. 16(A) is a diagram showing a data example of the direct project data. The direct project data includes items such as project CD, project name, PJ start date, PJ end date, salesperson in charge, and sales department in charge. In the example shown in the figure, the first line shows project CD "PJ00000001", project name "〇★ Bank-oriented △□ System Development Project", PJ start date "2023 / 4 / 1", PJ end date "2023 / 6 / 30", salesperson in charge "Shain001: Employee Taro", and sales department in charge "2100: First Business Department".
[0086] (S4: Contract details registration process) Referring to FIGS. 15 and 16, a specific example of the contract details registration process will be described. In the contract details registration process, contract details (order received information) associated with a project are registered. The contract details registration processing unit 102j, for example, inputs contract details data directly associated with a project in response to an operator's operation on the contract details registration screen displayed on the monitor 114, and registers it in the data file 106k.
[0087] FIG. 15(B) is a diagram showing an example display of the contract details registration screen 430. The contract details registration screen 430 includes a header area 701 for specifying PJNo - contract details No, order received date, scheduled period, salesperson in charge, salesperson in charge department, manager in charge, manager in charge department, contract details name, customer, billing destination, sales product, quantity, and unit price, a details area 702 for specifying the scheduled sales date, salesperson in charge of sales, sales scheduled department, scheduled sales amount, and scheduled sales consumption tax, and a registration button (not shown). When there are multiple scheduled sales for one order received contract, in the details area 702, the amount by month and consumption tax information of the sales are registered.
[0088] When the registration button (not shown) is pressed, direct project data corresponding to the input content on the screen is registered. In the case of the input content shown in the figure, data such as the first line of the contract details data shown in FIG. 16(B) is registered.
[0089] FIG. 16(B) is a diagram showing an example of contract details data. The contract details data includes items such as PJCD - contract details No, contract details name, order received date, customer, billing destination, scheduled sales amount, and scheduled sales consumption tax. In the example shown in the figure, the first line is PJCD - contract details No "PJ00000001 - 0001", contract details name "Upstream process of the △□ system development project for 〇★ Bank", order received date "2023 / 4 / 10", customer "Tok0001: 〇★ Bank", billing destination "Seq0001: 〇★ Bank", scheduled sales amount "2,700,000", and scheduled sales consumption tax "270,000".
[0090] (S5: Daily report input processing) Referring to FIG. 17, a specific example of the daily report input process will be described. In the daily report input process, during the contract period (in this example, from 4 / 1 to 4 / 30), the assigned temporary contract employees (outsourced employees) perform daily report registration (daily report data, work content data) for the assigned projects.
[0091] The daily report input processing unit 102d inputs the daily report achievements (daily report data and work content data) of the outsourced employees and registers them in the data file 106k.
[0092] FIG. 17 shows an example of data for the daily report data and the work content data. The daily report data includes items such as date, day of the week, employee, work content, working hours, break time, and actual working hours. In the example shown in the figure, the first row shows the date "2023 / 4 / 2", day of the week "Monday", employee "GaiCh001", work content "001: Normal work", working hours "9:00 - 17:30", break time "1:00", and actual working hours "7:30".
[0093] The work content data is for holding the work content and its working hours for each direct project - contract detail for each outsourced employee, and includes items such as No, PJCD - contract detail No, work content, and working hours. In the example shown in the figure, the first row shows No "1", PJCD - contract detail No "PJ00000001 - 0001", work content "020: Requirement specification document creation", and working hours "5:30".
[0094] (S6: Daily report aggregation process) Referring to FIGS. 18 and 19, a specific example of the daily report aggregation process will be described. The daily report aggregation processing unit 102e extracts the daily report achievements (daily report data and work content data) registered in the data file 106k based on the extraction conditions specified according to the operator's operation on the daily report aggregation screen displayed on the monitor 114, and displays and outputs a daily report aggregation table by employee or by project.
[0095] Figure 18 shows a display example of the daily report summary screen 440. The daily report summary screen 440 includes an area for specifying extraction conditions such as output classification (by employee, by project), working date, affiliated department, employee, aggregation unit (project unit, contract detail unit, JOB unit), PJNo - contract detail No - JOBNo, etc., and output buttons (e.g., PDF output, CSV output). When extraction conditions are specified and the output button is pressed, a daily report summary table (by PJ, by person) according to the extraction conditions is output.
[0096] Below Figure 18, an output example of the daily report summary table by PJ (working date: April 1 - April 30) is shown. The daily report summary table by PJ includes items such as PJCD - contract detail No, contract detail name, and daily report registration time. The daily report performance by PJ for the specified period can be confirmed.
[0097] Figure 19 shows an output example of the daily report summary table by person (working date: April 1 - April 30), employee master 106a, planned man - hour unit price header master 106i, planned man - hour unit price detail master 106j, an output example of the cost summary table (working date: April 1 - April 30), and an output example of the project summary table (working date: April 1 - April 30).
[0098] The daily report summary table by person includes items such as employee, employee name, PJCD - contract detail No, contract detail name, work content, and daily report registration time. The daily report performance by person for the specified period can be confirmed.
[0099] Also, the daily report summary processing unit 102e can output a cost summary table for the specified period. The cost summary table includes items such as PJCD - contract detail No, contract detail name, labor cost, outsourcing cost, expenses, and total cost. The cost performance for each cost element for the specified period can be confirmed.
[0100] The outsourcing cost is calculated by referring to the employee master 106a and the planned man - hour unit price detail master 106j based on the daily report registration time of the outsourcing employee. At this time, work content with the daily report man - hour handling classification name of "1: non - man - hour handling" in the work content master 106h is excluded. For example, 090: Cooperative society meeting has the daily report man - hour handling classification name of "1: non - man - hour handling".
[0101] Specifically, for each outsourced employee, using the employee as a key, the planned man-hour unit price CD is obtained from the employee master 106a. Then, using the obtained planned man-hour unit price CD as a key, the standard unit price is obtained from the planned man-hour unit price detail master 106j. The standard unit price × daily report registration time is calculated, and the total time is taken as the outsourcing cost.
[0102] For example, for the outsourcing cost of the PJCD - contract detail No. "PJ00000001 - 0001" and the contract detail name "Upstream process of the △□ system development project for 〇★ Bank" in the cost summary table, for Taro outside the company, the standard unit price: 3200 × daily report registration time: 100H = 320,000...(1), for Jiro outside the company, the standard unit price: 3500 × daily report registration time: 40H = 140,000...(2). From (1)+(2), it is 460,000.
[0103] Also, the daily report summary processing unit 102e can output the project summary table for the specified period. The project summary table has items such as PJCD - contract detail No, contract detail name, planned sales, cost of goods sold, and total profit and loss expenses. The profit and loss situation of each project and contract detail for the specified period can be confirmed.
[0104] (S7: Period contract purchase input processing) Referring to FIGS. 20 and 21, a specific example of the period contract purchase input processing will be described. In the period contract purchase input processing, for a procurement arrangement where the assigned project for the outsourced employee has not been determined at the time of arrangement, at the time of procurement accounting, the operation time of the outsourced employee is calculated based on the daily report actual performance for the corresponding contract period by using the daily report summary function. Without this function implementation, it is necessary to manually summarize the daily report actual performance of the outsourced employee for the month and then compare it with the invoice from the outsourcing vendor.
[0105] The periodic contract procurement input processing unit 102f creates procurement data including the operation time and procurement amount for the indirect projects of subcontracting employees based on the order data and daily report results in response to the operator's operations on the periodic contract procurement input screen 450 displayed on the monitor 114, for example, and registers it in the data file 106k. The operation time is obtained by aggregating the daily report registration times for each work content of the subcontracting employees, and is excluded from the operation time if the work content has a daily report man-hour handling classification name in the work content master 106h of "1: Not handled as man-hours". Also, the periodic contract procurement input processing unit 102f creates journal entries based on the procurement data.
[0106] FIG. 20(A) is a diagram showing an example of the display of the periodic contract procurement input screen 450. The periodic contract procurement input screen 450 includes a header area 451 for specifying a procurement number (automatically numbered), an order number, a procurement date, a closing date, a scheduled payment date, a procurement destination, and a payment destination, and a detail area 452 in which PJNo - contract detail No. - JOBNo, debt subject classification, cost burden department, operation time, payment time, procurement actual amount, procurement actual consumption tax amount, contract period, employee CD, basic amount, lower limit time, lower limit unit price, upper limit time, and upper limit unit price are displayed, a daily report aggregation button, and a registration button (not shown).
[0107] In the detail area 452, the order header data and order detail data in the data file 106k are extracted using the specified order number as a key and are displayed in the corresponding locations (PJNo - contract detail No. - JOBNo, debt subject classification, cost burden department, contract period, employee CD, basic amount, lower limit time, lower limit unit price, upper limit time, upper limit unit price).
[0108] When the daily report summary button is pressed, the operating hours are calculated based on the daily results (work content treated as man-hours) that occurred during the contract period (in this example, 4 / 1 to 4 / 30), and are displayed in "operating hours" in details area 452. In addition, based on the operating hours, the payment time, actual purchase amount, and actual purchase consumption tax amount are displayed. When the register button (not shown) is pressed, purchase header data and purchase detail data are registered according to the input contents (display contents) on the screen. In the example of the input contents on this screen, the data in the first line of the purchase header data and purchase detail data as shown in Figures 21 (A) and (B) are registered.
[0109] Figure 20 (C) shows an example of the daily report results for employee CD: GaiCh001 (Outsourced Taro) for the month of April. If the daily labor hour classification name in the work content master 106h = "1: Non-labor hour treatment", it is excluded from the calculation of the working hours. When the working hours of employee CD: GaiCh001 are calculated based on the daily report time, it becomes Employee CD: GaiCh001: Daily report results for April "170H" - Daily labor hour classification in the work content master 106h = 1: Non-labor hour treatment time "10H" = 160H.
[0110] The payment hours will be "160H". The basis for the payment hours of "160H" is that the lower limit hours: 130H < operating hours: 160H, operating hours: 160H < upper limit hours: 180H, and based on this relationship, the basic amount of outsourcing fee: 400,000 yen will be adopted.
[0111] In addition, when recording the journal entry, prepare the following journal entry: Indirect outsourcing costs: 400,000 / Accounts payable: 400,000 Kan0001-0001-0001 Department:2100 1st Division
[0112] Figure 21(A) shows a data example of purchase header data. The purchase header data includes items such as purchase number, order number, purchase date, closing date, scheduled payment date, supplier, and payee. In the example shown in the figure, the first row has a purchase number of "SIR0000001", an order number of "HAT0000001", a purchase date of "2023 / 4 / 30", a closing date of "2023 / 5 / 20", a scheduled payment date of "2023 / 6 / 20", a supplier of "Gai1001 (〇△ Engineering)", and a payee of "Gai1001 (〇△ Engineering)".
[0113] Figure 21(B) shows a data example of purchase detail data. The purchase detail data includes items such as purchase number, line number, PJNo - contract detail No - JOBNo, debt account classification, cost - bearing department, contract period, employee CD, working hours, payment hours, purchase amount, purchase consumption tax, lower limit time lower limit unit price, upper limit time, and upper limit unit price.
[0114] In the example shown in the figure, the first row has a purchase number of "SIR0000001", a line number of "1", a PJNo - contract detail No - JOBNo of "Kan0001 - 0001 - 0001", a debt account classification of "21: Accounts Payable", a cost - bearing department of "2100: First Business Unit", a contract period of "2023 / 4 / 1~2023 / 4 / 30", an employee CD of "GaiCh001", working hours of "160H", payment hours of "160H", a purchase amount of "400,000", a purchase consumption tax of "40,000", a lower limit time of "130 H", a lower limit unit price of "2,500", an upper limit time of "180H", and an upper limit unit price of "3,500".
[0115] 2. Allocation of Indirect Sub - contract Costs to Direct Sub - contract Costs (Indirect Sub - contract Costs Recorded → Direct Sub - contract Costs Recorded) (S8: Sub - contract Labor Input Processing) With reference to FIGS. 22 to 24, a specific example of the subcontracting man-hour input process will be described. In the subcontracting man-hour input process, the allocation from indirect subcontracting costs to direct subcontracting costs (recording indirect subcontracting costs → recording direct subcontracting costs) is performed. The content of item 1 above is in a state where it is recorded as the department cost of "Accounting Department 2100: First Business Division" as indirect subcontracting costs. This indirect subcontracting cost is transferred to the costs of each direct project and contract details according to the actual performance of the subcontracting employee's daily report. For each linked indirect project - contract details - JOB No., the actual daily report performance of the subcontracting employee during the contract period, which links the recorded indirect subcontracting costs at the time of placing a term contract order, is obtained according to the following rules, and the subcontracting costs are transferred.
[0116] The subcontracting man-hour input processing unit 102g, for example, according to the operator's operation on the subcontracting man-hour input screen 460 displayed on the monitor 114, based on the purchase data, transfers the indirect subcontracting costs registered in the indirect projects of the subcontracting employees to each direct project, and registers the term contract transfer data in the data file 106k.
[0117] FIG. 22 is a diagram showing an example of the display of the subcontracting man-hour input screen 460. The subcontracting man-hour input screen 460 includes the transfer date, transfer status (untransferred, transferred), purchase date, contract period, supplier, purchaser in charge, extraction conditions for the transfer source PJ No. - contract details No. - JOB No., and the cost-bearing department, and a header area 461 for specifying them, and a details area 462 in which the purchase number, transfer source PJ No. - contract details No. - JOB No., transfer destination PJ - contract details No. - JOB No., cost-bearing department, dispatched target person, subcontracting cost, transfer ratio, transfer ratio total (daily report time within the contract period of the corresponding subcontracting employee) are displayed, and a display button, a daily report summary button, and an update button are displayed.
[0118] When the daily report summary button is pressed, the actual daily report performance registered in the indirect projects of the subcontracting employees is displayed in the details area 462. In the details area 462, for each daily report time, according to the actual daily report performance of the subcontracting employee, a transfer is made to each direct project.
[0119] In the example shown in the figure, in the header area 461, the transfer date "2023 / 4 / 30", the extraction conditions are the transfer status "not transferred", the purchase date "2023 / 4 / 30", the contract period "2023 / 4 / 1 - 2023 / 4 / 30", and the supplier "Gai1001: 〇△ Engineering" are specified, and data as shown in the detail area 462 is displayed.
[0120] For the purchase number "SIR0000001", the transfer source PJNo - contract detail No - JOBNo "Kan0001 - 0001 - 0001", the cost - bearing department "2100: First Business Department", and the dispatched person "GaiCh001: Sub - contracted Taro", the sub - contracted cost is "400,000", and the transfer rates are "100" for the transfer destination PJ - contract detail No - JOBNo "PJ00000001 - 0001 - 001", "60" for "PJ00000002 - 0001 - 001", and "0" for "PJ00000002 - 0001 - 001", and the total transfer ratio is "160". The "transfer ratio" can be changed by the operator, and the transfer to each direct project can be set. When the update button is pressed, the updated content is reflected, and period - contract transfer data as shown in Figure 24 is generated.
[0121] In the upper part of Figure 23, an example of the daily work report performance of employee CD: GaiCh001 (Sub - contracted Taro) for one month in April is shown. When the daily work - hour handling classification name in the work content master 106h = "1: Non - work - hour handling", it is excluded from the calculation time of the operating hours. When calculating the operating hours of employee CD: GaiCh001 based on the daily work report time, the daily work report performance of employee CD: GaiCh001 in April is "170H" - the daily work - hour classification in the work content master 106h = 1: Non - work - hour handling time "10H" = 160H.
[0122] When making the corresponding journal entry, create a journal entry as shown below. Sub - contracted cost 250,000 ···(1) / Indirect sub - contracted cost 400,000 PJ00000001 - 0001 - 0001 Kan0001 - 0001 - 0001 Department: 2100 First Business Department Department: 2100 First Business Department Subcontracted expenses 150,000 ···(2) PJ00000002 - 0001 - 0001 Department: 2100, First Business Department
[0123] The subcontracted expenses (1) and (2) are calculated as follows. Subcontracted expenses (1) = Reported actual hours of "PJ00000001 - 0001 - 0001": 100H → Recorded subcontracted expenses 400,000 × 100H ÷ 160H (※) = 250,000 Subcontracted expenses (2) = Reported actual hours of "PJ00000002 - 0001 - 0001": 60H → Recorded subcontracted expenses 400,000 × 60H ÷ 160H (※) = 150,000 (※) Reported actual hours of labor hours handling in April of GaiCh001
[0124] As a result of the above transfer process, the revenue and expenditure for each project switch directly from the revenue and expenditure calculation based on the planned subcontracted expenses to the revenue and expenditure calculation based on the actual subcontracted expenses.
[0125] <Actual information on the cost of goods sold based on the planned subcontracted expenses> Below Figure 23, a cost summary table is shown. Regarding the cost of goods sold of Project No - Contract Detail No "PJ00000001 - 0001 - 0001", the actual subcontracted expenses are as follows: Employee CD: Reported actual hours of GaiCh001 Subcontracted Taro 100H → Recorded subcontracted expenses 400,000 × 100H ÷ 160H = 250,000 Employee CD: Reported actual hours of GaiCh002 Subcontracted Jiro 40H → Recorded subcontracted expenses 510,000 × 40H ÷ 170H = 120,000 The total is 370,000. This is the actual performance at the time of subcontracting, which was transferred from the indirect subcontracting expenses to the direct subcontracting expenses as a result of the input of subcontracting labor hours.
[0126] Therefore, the cost of goods sold of Project No - Contract Detail No "PJ00000001 - 0001 - 0001" is 280,000 (labor cost actual performance) + 340,000 (subcontracted expenses) + 5,000 (expenses) = 625,000.
[0127] <Finalized revenue and expenditure situation based on the subcontracted expenses> The upper part of FIG. 24 shows a project profit and loss statement. The cost of sales is the amount considering the outsourced expenses after transfer. It is possible to check the profit and loss status of each project and contract details during the specified period.
[0128] The lower part of FIG. 24 shows a data example of period contract transfer data. The period contract transfer data has items such as purchase invoice No., detail No., transfer date, transfer SEQ, transfer ratio, and transfer purchase principal amount. Transfer SEQ "0" indicates the transfer source, and the detail with the line number registered represents the transfer destination. In the example shown in the figure, the first line has a purchase invoice No. of "SIR0000001", a detail No. of "1", a transfer date of "2023 / 4 / 30", a transfer SEQ of "0", a transfer ratio of "160", and a transfer purchase principal amount of "400,000".
[0129] As described above, according to this embodiment, when the assigned projects of the outsourced employees are not determined, an indirect project input processing unit 102a that inputs and registers indirect project data including an indirect project for charging department expenses not associated with the customer into the storage area, a period contract order input processing unit 102b that inputs and registers order data associated with the indirect project into the storage area, a project registration processing unit 102c that inputs and registers direct project data including the direct projects of the assigned projects of the outsourced employees into the storage area, a daily report input processing unit 102d that inputs and registers the daily report results including the actual working hours of the outsourced employees by day and the working hours for each work content of the direct projects into the storage area for the direct projects of the outsourced employees, a period contract purchase input processing unit 102f that inputs and registers purchase data including the working hours and the purchase amount, which is the indirect outsourced fee, for the indirect projects of the outsourced employees based on the order data and the daily report results into the storage area, and an outsourced man-hour input processing unit 102g that transfers the indirect outsourced fees registered in the indirect projects of the outsourced employees to each direct project based on the purchase data. Therefore, in a company with a large number of outsourced employees, even when the assigned projects of the outsourced employees are not determined at the time of order arrangement, it is possible to perform the outsourced fee accounting work with a low load and quickly.
[0130] [4. Contribution to the United Nations' Sustainable Development Goals (SDGs)] According to the present embodiment, since it can contribute to improving business efficiency and making appropriate business judgments of enterprises, it is possible to contribute to Goals 8 and 9 of the SDGs.
[0131] Also, according to the present embodiment, since it can contribute to reducing waste loss and promoting paperless and digitization, it is possible to contribute to Goals 12, 13, and 15 of the SDGs.
[0132] Also, according to the present embodiment, since it can contribute to strengthening control and governance, it is possible to contribute to Goal 16 of the SDGs.
[0133] [5. Other Embodiments] The present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims, in addition to the above-described embodiments.
[0134] For example, among the processes described in the embodiment, all or part of the processes described as being automatically performed can be performed manually, or all or part of the processes described as being manually performed can be automatically performed by a known method.
[0135] Also, regarding the outsourcing cost processing device 100, each of the illustrated components is a functional concept, and it is not necessarily physically configured as illustrated.
[0136]
[0137] For example, regarding the processing functions provided by the outsourcing cost processing device 100, particularly each processing function performed by the control unit, all or any part thereof may be realized by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware by wired logic. Note that the program is recorded on a non-transitory computer-readable recording medium including programmed instructions for causing an information processing device to execute the processing described in the present embodiment, and is mechanically read by the outsourcing cost processing device 100 as necessary. That is, in a storage unit such as a ROM or an 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 the control unit in cooperation with the CPU.
[0138] Further, this computer program may be stored in an application program server connected to the outsourcing cost processing device 100 via an arbitrary network, and all or part of it can be downloaded as necessary.
[0139] Further, a program for executing the processing described in the present embodiment may be stored in a non-transitory computer-readable recording medium, or may be configured as a program product. Here, this "recording medium" includes any "portable physical medium" such as a memory card, a USB (Universal Serial Bus) memory, an SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Programmable Read Only Memory), an EEPROM (registered trademark) (Electrically Erasable and Programmable Read Only Memory), a CD-ROM (Compact Disk Read Only Memory), an MO (Magneto-Optical disk), a DVD (Digital Versatile Disk), and a Blu-ray (registered trademark) Disc.
[0140] In addition, a "program" is a data processing method described in any language or description method, regardless of the form such as source code or binary code. Note that the "program" is not necessarily limited to being configured singly, and also includes those that are distributedly configured as a plurality of modules or libraries, or those that achieve their functions in cooperation with separate programs typified by an OS. Regarding the specific configuration, reading procedure, and installation procedure after reading for reading a recording medium in each device shown in the embodiment, well-known configurations and procedures can be used.
[0141] Various databases and the like stored in the storage unit are storage means such as 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.
[0142] Further, the outsourcing cost processing device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which any peripheral device is connected. Further, the outsourcing cost processing device 100 may be realized by installing software (including programs or data, etc.) that realizes the processing described in this embodiment in the device.
[0143] Furthermore, the specific form of the distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be functionally or physically distributed and integrated in arbitrary units according to various additions or according to the functional load. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.
Explanation of Reference Numerals
[0144] 100 Outsourcing cost processing device 102 Control unit 102a Indirect project input processing unit 102b Period contract injection input processing unit 102c Project registration processing unit 102d Daily report input processing unit 102e Daily report aggregation processing unit 102f Period contract procurement input processing unit 102g Subcontracted man-hour input processing unit 102h Master maintenance unit 102i Screen display control unit 102j Contract details registration processing unit 104 Communication interface unit 106 Memory unit 106a Employee master 106b Supplier master 106c Payee master 106d Customer master 106e Billing destination master 106f Sales product master 106g Work content master 106h Job content master 106i Planned man-hour unit price header master 106j Planned man-hour unit price details master 106k Data file 108 Input / output interface unit 112 Input device 114 Output device 200 Server 300 Network 400 Terminal
Claims
1. A subcontracting cost processing device including a control unit, wherein the control unit has an indirect project input means for inputting indirect project data including an indirect project for charging department costs not associated with a customer and registering it in a storage area when the assigned projects of subcontracting employees have not been determined; a term contract purchase order input means for inputting purchase order data associated with the indirect project and registering it in the storage area; a project registration means for inputting direct project data including a direct project of the project to be assigned to a subcontracting employee and registering it in the storage area; a daily report input means for inputting daily report results including the actual working hours of the subcontracting employee by day and the working hours for each work content of the direct project and registering it in the storage area; a term contract purchase input means for inputting purchase data including the working hours and the purchase amount which is the indirect subcontracting cost for the indirect project of the subcontracting employee based on the purchase order data and the daily report results and registering it in the storage area; a subcontracting man-hour input means for transferring the indirect subcontracting cost registered in the indirect project of the subcontracting employee to each direct project based on the purchase data; and is characterized by including the above.
2. The control unit further has a daily report summarizing means for extracting the daily report results registered in the storage area based on extraction conditions specified according to an operator's operation on a daily report summary screen and outputting a daily report summary table by employee or project, and is characterized by the subcontracting cost processing device according to Claim 1.
3. The control unit is configured to be able to access an employee master in which a subcontracting employee is registered in association with a planned man-hour unit price code, a work content master in which a work content is registered in association with a daily report man-hour handling classification in which man-hour handling or non-man-hour handling is specified, and a planned man-hour unit price master in which a planned man-hour unit price code, a cost element, and a standard unit price are registered in association with each other, and the daily report summarizing means, for each subcontracting employee, acquires a planned man-hour unit price code from the employee master using the employee as a key, acquires a standard unit price from the planned man-hour unit price master using the acquired planned man-hour unit price code as a key, calculates the total daily report registration time which is the standard unit price × the total working hours of the work content, and regards the total time as the subcontracting cost. At this time, when the work content is such that the daily report man-hour handling classification in the work content master = "non-man-hour handling", it is excluded from the calculation, and is characterized by the subcontracting cost processing device according to Claim 2.
4. The above-mentioned contract-period procurement input means calculates the operating hours by aggregating the daily report registration times for each work content of the outsourced employees, and when the work content has a daily report man-hour handling classification in the work content master of "not subject to man-hours", excludes it from the operating hours. The outsourced cost processing apparatus according to claim 3, characterized in that.
5. The above-mentioned contract-period procurement input means creates journal entries based on the procurement data. The outsourced cost processing apparatus according to claim 4, characterized in that.
6. An outsourced cost processing method executed by an information processing apparatus provided with a control unit, Executed in the above-mentioned control unit, When the assigned projects of the outsourced employees have not been determined, an indirect project input step of inputting indirect project data including an indirect project for charging department costs not associated with the customer into the storage area and registering it; A contract-period order input step of inputting order data associated with the indirect project and registering it in the storage area; A project registration step of inputting direct project data including direct projects of the outsourced employees' assigned projects into the storage area and registering it; A daily report input step of inputting daily report results including the actual working hours of the outsourced employees by day and the working hours for each work content of the direct project for the direct projects of the outsourced employees into the storage area and registering it; A contract-period procurement input step of inputting procurement data including the operating hours and the procurement amount which is the indirect outsourced cost for the indirect projects of the outsourced employees based on the order data and the daily report results into the storage area and registering it; An outsourced man-hour input step of transferring the indirect outsourced cost registered in the indirect projects of the outsourced employees to each direct project based on the procurement data; An outsourced cost processing method, characterized by including the above.
7. An outsourced cost processing program for causing an information processing apparatus provided with a control unit to execute, To the above-mentioned control unit, When the assigned projects of the outsourced employees have not been determined, an indirect project input step of inputting indirect project data including an indirect project for charging department costs not associated with the customer into the storage area and registering it; A contract-period order input step of inputting order data associated with the indirect project and registering it in the storage area; A project registration step of inputting direct project data including direct projects of the outsourced employees' assigned projects into the storage area and registering it; For the direct projects of external contractors, a daily report input process of inputting the actual working hours of external contractors by day and the daily report results including the working hours for each work content of the direct projects and registering them in the memory area. A term contract procurement input process of inputting procurement data including the operating hours and the procurement amount which is the indirect outsourcing cost for the indirect projects of external contractors based on the order data and the daily report results and registering them in the memory area. An outsourcing man-hour input process of transferring the indirect outsourcing cost registered for the indirect projects of external contractors to each direct project based on the procurement data. An outsourcing cost processing program for executing the above.
Citation Information
Patent Citations
Integrated job management system
JP2005216013A
Expense calculation device, expense calculation method and expense calculation program
JP2018055265A
Journal approval work support device, journal approval work support method and journal approval work support program
JP2020194397A
Device, method and program for managing indirect expenses
JP2023130871A
Cost calculation device, cost calculation method, and cost calculation program
JP7085304B2