Contract amount calculation device, contract amount calculation method and contract amount calculation program

Abstract

To provide a contract amount calculation device or the like capable of improving the efficiency of a calculation service of a contract amount for services included in a contract charged to a contractor (e.g., a government agency) for a project (e.g., public construction) by a public interest corporation.SOLUTION: In this embodiment, (1) outsourcing purchase data (outsourcing purchase data linked to a contract NO) generated to contract information is aggregated to calculate a construction cost, (2) office expenses corresponding to a contract date and a work content code are acquired from an office expense master, and (3) the contraction cost and the office expenses are added to calculate a contract amount.SELECTED DRAWING: Figure 3

Description

[Technical field]

[0001] The present invention relates to a contract amount calculation device, a contract amount calculation method, and a contract amount calculation program. [Background technology]

[0002] Patent Document 1 describes a project risk management system that enables financial institutions to provide financing for not only the land portion of a real estate development project but also the contract construction portion. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] JP 2004-234427 A Summary of the Invention [Problem to be solved by the invention]

[0004] Here, public interest corporations may need to calculate the contract amount for the work included in the contract, which the public interest corporation will bill to the contracting party (such as a government agency) for a project (such as a public construction project), but there is no system (application software) that can make this calculation more efficient. For example, in a typical construction system, the contract amount agreed upon with the contracting party is managed as the billing amount.

[0005] The present invention has been made in consideration of the above-mentioned problems, and aims to provide a contract amount calculation device, a contract amount calculation method, and a contract amount calculation program that can streamline the calculation of the contract amount for work included in a contract that a public interest corporation invoices to a contracting party (e.g., a government agency) for a project (e.g., public works, etc.). [Means for solving the problem]

[0006] In order to solve the above-mentioned problems and achieve the objective, the contract amount calculation device of the present invention is characterized by comprising: an aggregation unit that aggregates expenses linked to an accounting item corresponding to a specified task and a specified contract from purchasing data that manages expenses related to procurement incurred by a public interest corporation to carry out a business, linked to a contract for the business that the public interest corporation has concluded with a contractor for the business and an accounting item linked to the work included in the contract; an acquisition unit that acquires administrative expenses linked to the specified task from an administrative expense master that manages administrative expenses incurred by the public interest corporation to carry out the business by task included in the contract; and a calculation unit that calculates the contract amount for the specified task to be invoiced to the contractor by adding up the aggregated amount obtained by the aggregation unit and the administrative expenses acquired by the acquisition unit.

[0007] In the contract amount calculation device according to the present invention, the cost relating to the purchase may be an outsourcing cost.

[0008] In the contract amount calculation device according to the present invention, the business may be a public works project, and the contracting party may be a government agency.

[0009] In addition, the contract amount calculation method of the present invention is characterized by including an aggregation step in which an aggregation unit aggregates expenses related to purchasing incurred by a public interest corporation to carry out a business, from purchase data managed by linking the expenses related to the contract for the business concluded by the public interest corporation with a contractor for the business and the accounting items linked to the business included in the contract, an acquisition step in which an acquisition unit acquires administrative expenses linked to the designated business from an administrative expense master that manages administrative expenses incurred by the public interest corporation to carry out the business by business included in the contract, and a calculation step in which a calculation unit calculates the contract amount for the designated business to be invoiced to the contractor by adding up the aggregated amount obtained in the aggregation step and the administrative expenses acquired in the acquisition step.

[0010] In addition, the contract amount calculation program of the present invention causes an information processing device to function as: an aggregation means for aggregating expenses linked to an account item corresponding to a specified task and a specified contract from purchase data that manages expenses related to purchases incurred by a public interest corporation to carry out its business by linking them to the contract for the business that the public interest corporation has concluded with a contractor and the account item linked to the task included in the contract; an acquisition means for acquiring administrative expenses linked to the specified task from an administrative expense master that manages administrative expenses incurred by the public interest corporation to carry out its business by task included in the contract; and a calculation means for calculating the contract amount for the specified task to be invoiced to the contractor by adding up the aggregated amount obtained by the aggregation means and the administrative expenses acquired by the acquisition means. Effect of the Invention

[0011] The present invention has the effect of streamlining the calculation of contract amounts for work included in a contract for a project (such as a public works project) that a public interest corporation invoices to a contracting party (such as a government agency) for the project. [Brief description of the drawings]

[0012] [Figure 1] FIG. 1 is a diagram showing an example of the configuration of a contract information registration device 100. As shown in FIG. [Diagram 2] FIG. 2 is a diagram showing an example of the contract header data 106a, the contract detail data 106b, the purchase data 106c, and the administrative cost master data 106d. [Diagram 3] FIG. 3 is a diagram illustrating an example of the contract information registration process. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0013] Hereinafter, an embodiment of a contract amount calculation device, a contract amount calculation method, and a contract amount calculation program according to the present invention will be described in detail with reference to the drawings. Note that the present invention is not limited to the embodiment.

[0014] [1. Configuration] An example of the configuration of a contract information registration device 100 according to this embodiment (including a contract amount calculation device according to the present invention) will be described with reference to Fig. 1 to Fig. 3. Fig. 1 is a block diagram showing an example of the configuration of the contract information registration device 100.

[0015] The contract information registration device 100 is constructed based on a commercially available desktop personal computer. Note that the contract information registration device 100 is not limited to being constructed based on a stationary information processing device such as a desktop personal computer, but may be constructed based on a portable information processing device such as a commercially available notebook personal computer, a PDA (Personal Digital Assistant), a smartphone, or a tablet personal computer.

[0016] The contract information registration device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. The units included in the contract information registration device 100 are connected to each other so as to be able to communicate with each other via any communication path.

[0017] The communication interface unit 104 communicably connects the contract information registration device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via the communication line. Here, the network 300 has a function of connecting the contract information registration device 100 and the server 200 to be able to communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). The data stored in the memory unit 106 may be stored in the server 200, for example.

[0018] An input device 112 and an output device 114 (corresponding to an output unit of the present invention) are connected to the input / output interface unit 108. The output device 114 may be a monitor (including a home television), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that cooperates with a mouse to realize a pointing device function. In the following, the output device 114 may be referred to as the monitor 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.

[0019] Various databases, tables, files, etc. are stored in the storage unit 106. Computer programs for cooperating with an OS (Operating System) to give instructions to a CPU (Central Processing Unit) to perform various processes are recorded in the storage 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 as the storage unit 106.

[0020] The memory unit 106 includes contract header data 106a, contract detail data 106b, purchase data 106c, and administrative expense master data 106d.

[0021] The contract header data 106a manages basic information regarding contracts for projects (such as public works) that public interest corporations have concluded with contractors (such as government agencies, etc.) For specific examples of the data structure of the contract header data 106a and the information (item values) held in the contract header data 106a, please refer to Figure 2 or Figure 3.

[0022] The contract specification data 106b manages information on costs and contract amounts related to the work included in the contract. For specific examples of the data structure of the contract specification data 106b and information (item values) set in the contract specification data 106b, please refer to Figure 2 or Figure 3.

[0023] The purchase data 106c manages the expenses (such as outsourcing expenses) related to purchases incurred by the public corporation to carry out its business, by linking them to the contract (specifically, the work included in the contract) and the accounting items linked to the work included in the contract. Please refer to FIG. 2 for a specific example of the data structure of the purchase data 106c and the information (item values) set in the purchase data 106c. The purchase amount stored in the purchase data 106c corresponds to the cost amount.

[0024] The administrative expenses master 106d manages administrative expenses incurred by the public corporation to carry out its business, classified by the tasks included in the contract. Please refer to FIG. 2 for a specific example of the data structure of the administrative expenses master 106d and the information (item values) set in the administrative expenses master 106d.

[0025] 1, the control unit 102 is a CPU or the like that performs overall control of the contract information registration device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, and required data, and executes various information processing based on these stored programs.

[0026] The control unit 102 conceptually includes a contract information registration unit 102a (including a counting unit, an acquisition unit, and a calculation unit of the present invention) and the like.

[0027] The contract information registration unit 102a compiles, from the purchase data 106c, expenses linked to the designated contract and the accounting items corresponding to the designated business.

[0028] The contract information registration unit 102a acquires the administrative expenses associated with the specified business from the administrative expenses master 106d.

[0029] The contract information registration unit 102a adds up the obtained total amount and the acquired administrative fee to calculate the contract amount for the specified service to be billed to the contracting party.

[0030] A specific example of the process executed by the contract information registration unit 102a will be described in detail in the following "2. Specific Example of Process."

[0031] [2. Specific examples of processing] Here, a specific example of the contract information registration process executed by the contract information registration device 100 will be described with reference to Fig. 3 etc. In particular, a specific example of the process will be described using as an example a case where payment is made to an outsourced contractor in May 2023 and invoiced to the contractor in June 2023. Note that this description is based on the premise that data is stored in the contract header data 106a, contract detail data 106b, purchase data 106c, and administrative expense master 106d as shown in Fig. 2. In addition, this explanation assumes that the operator instructs the display of the contract information registration screen MA (see Figure 3), that the contract information registration unit 102a receives the instruction and displays the contract information registration screen MA on the monitor 114, that the operator sets the contract number "K001" in the header area within the contract information registration screen MA, that the contract information registration unit 102a extracts data linked to the set contract number "K001" from the contract header data 106a and displays it in the header area, and that the operator presses the aggregation button (see Figure 3) provided within the contract information registration screen MA.

[0032] First, the contract information registration unit 102a totals the expenses linked to the contract number "K001" set as the accounting item corresponding to the business from the purchase data 106c for each business displayed in the details area of ​​the contract information registration screen MA, and displays the total amount in the details area. Here, for the business content "construction cost" displayed in the details area, the purchase amount "4,00,000" and the purchase amount "700,000" linked to the contract number "K001" set as the accounting item "outsourced construction cost" corresponding to the "construction cost" are totaled, and "4,700,000" is displayed in the "construction cost" column in the details area. In addition, for the work content "Labor costs" displayed in the details area, the purchase amount "5,000,000" linked to the accounting item "Research and design costs" corresponding to the "Labor costs" and the contract number "K001" is totaled, and "5,000,000" is displayed in the "Construction costs" column in the details area.

[0033] Next, the contract information registration unit 102a obtains, for each task displayed in the details area of ​​the contract information registration screen MA, the administrative expenses associated with the task from the administrative expenses master 106d based on the contract date "2023 / 04 / 01" displayed in the header area of ​​the contract information registration screen MA, and displays the obtained administrative expenses in the details area. Here, the record in the administrative expenses master 106d with a revision date of "2023 / 04 / 01" is referenced based on the contract date of "2023 / 04 / 01". Therefore, for the work content "construction costs" displayed in the details area, the administrative expenses of "2,400,000" linked to the work content "construction costs" corresponding to the "construction costs" are obtained, and "2,400,000" is displayed in the "administrative expenses" column in the details area, and for the work content "labor costs" displayed in the details area, the administrative expenses of "2,800,000" linked to the work content "design costs" corresponding to the "labor costs" are obtained, and "2,800,000" is displayed in the "administrative expenses" column in the details area.

[0034] Next, the contract information registration unit 102a calculates the contract amount for the work to be billed to the contractor "XX City" displayed in the header area of ​​the contract information registration screen MA by adding up the obtained total amount and the obtained administrative fee for each work displayed in the details area of ​​the contract information registration screen MA, and displays the calculated contract amount in the details area. Here, for the work content "construction costs" displayed in the details area, the total amount "4,700,000" and the administrative fee "2,400,000" are added together to calculate the contract amount "7,100,000", and "7,100,000" is displayed in the "contract amount" column in the details area. In addition, for the work content "Work costs" displayed in the details area, the aggregate amount "5,000,000" and the administrative costs "2,800,000" are added together to calculate the contract amount "7,800,000", and "7,800,000" is displayed in the "Contract amount" column in the details area.

[0035] Then, when the operator presses the registration button on the contract information registration screen MA, the contract information registration unit 102a updates the contract detail data 106b as shown in Figure 3 by storing the construction costs, administrative costs, and contract amount displayed in the details area on the contract information registration screen MA in the contract detail data 106b.

[0036] As described above, (1) the outsourcing purchase data (outsourcing purchase data linked to the contract number) generated for the contract information is aggregated to calculate the construction cost, (2) the administrative cost corresponding to the contract date and the work content code (if the construction cost is not 0 yen, the amount calculated by multiplying it by a factor) is obtained from the administrative cost master, and (3) the construction cost and administrative cost are added together to calculate the contract amount. In other words, in order to calculate the contract amount for a contract for a public interest corporation, the construction amount linked to the contract is aggregated, administrative costs are calculated, and the contract amount is calculated. This makes it possible to realize business efficiency by preventing calculation errors in the aggregation of the construction amount (cost amount), administrative costs, and contract amount, and eliminating the need for input. In addition, based on the operation of calculating the billing amount from the cost specific to public interest corporations, it is also possible to perform "calculation of administrative fees according to the rate according to the expense item" and "generation of billing data based on the expenses and administrative fees" specific to public works of public interest corporations contracted by the national and local governments.

[0037] [3. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving business efficiency and promoting appropriate management decisions by companies, thereby contributing to goals 8 and 9 of the SDGs.

[0038] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of SDGs Goals 12, 13, and 15.

[0039] Furthermore, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.

[0040] [4. Other embodiments] The present invention may be embodied in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.

[0041] 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 using known methods.

[0042] In addition, the processing procedures, control procedures, specific names, information including parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and drawings may be changed as desired unless otherwise specified.

[0043] Moreover, with regard to the contract information registration device 100, each of the components shown in the figures is a functional concept, and does not necessarily have to be physically configured as shown in the figures.

[0044] For example, the processing functions of the contract information registration device 100, particularly the processing functions performed by the control unit, may be realized in whole or in part by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded in a non-transient computer-readable recording medium that includes programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the contract information registration device 100 as necessary. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). This computer program is executed by being loaded into a RAM, and cooperates with the CPU to form a control unit.

[0045] In addition, this computer program may be stored in an application program server connected to the contract information registration device 100 via any network, and it is also possible to download all or a part of it as necessary.

[0046] In addition, the program for executing the process described in this embodiment may be stored in a non-transient computer-readable recording medium, or may be configured as a program product. Here, the "recording medium" includes any "portable physical medium" such as a memory card, a Universal Serial Bus (USB) memory, a Secure Digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an Erasable Programmable Read Only Memory (EPROM), an Electrically Erasable and Programmable Read Only Memory (EEPROM (registered trademark)), a Compact Disk Read Only Memory (CD-ROM), a Magneto-Optical disk (MO), a Digital Versatile Disk (DVD), and a Blu-ray (registered trademark) Disc.

[0047] Moreover, a "program" is a data processing method written in any language or description method, and may be in any form, such as source code or binary code. Note that a "program" is not necessarily limited to a single configuration, but also includes a distributed configuration as multiple modules or libraries, and a program that works with a separate program, such as an OS, to achieve its function. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in the embodiments, as well as the installation procedure after reading, may use well-known configurations and procedures.

[0048] The various databases etc. stored in the memory 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 etc. used for various processes and providing websites.

[0049] The contract information registration device 100 may be configured as an information processing device such as a known personal computer or a workstation, or may be configured as the information processing device to which any peripheral device is connected. The contract information registration device 100 may be realized by installing software (including programs or data) that causes the device to realize the processing described in this embodiment.

[0050] Furthermore, the specific form of 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 any unit according to various additions or functional loads. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively. [Industrial Applicability]

[0051] The present invention is useful for general incorporated associations and general incorporated foundations that have been certified as public-benefit organizations. [Explanation of symbols]

[0052] 100 Contract information registration device 102 Control section 102a Contract Information Registration Department 104 Communication interface section 106 Storage section 106a Contract header data 106b Contract details data 106c Purchase Data 106d Administrative expenses master 108 Input / Output Interface Section 112 Input Devices 114 Output Device 200 Servers 300 Network

Claims

1. a tabulation unit that tabulates expenses related to purchases incurred by a public interest corporation to carry out a business from purchase data that is managed by linking the expenses to the contract for the business concluded by the public interest corporation with a contractor and the accounting items associated with the business included in the contract, and tallying up expenses linked to the accounting items corresponding to the designated business and the designated contract; An acquisition unit that acquires administrative expenses associated with the specified business from an administrative expense master that manages administrative expenses incurred by the public interest corporation to carry out the business by business included in the contract; a calculation unit that calculates a contract amount for the specified service to be invoiced to the contractor by adding up the total amount obtained by the calculation unit and the administrative expenses obtained by the acquisition unit; A contract amount calculation device comprising:

2. The costs related to the above purchases are subcontract costs, 2. The contract amount calculation device according to claim 1,

3. The said project is a public works project, The contracting party is a government agency; 3. The contract amount calculation device according to claim 2,

4. a counting step in which the counting unit counts up expenses related to purchases incurred by the public interest corporation to carry out its business from purchase data managed by linking the expenses to the contract for the business concluded by the public interest corporation with a contractor and the accounting items linked to the business included in the contract, and counts up expenses linked to the accounting items corresponding to the designated business and the designated contract; An acquisition step in which an acquisition unit acquires administrative expenses associated with the specified business from an administrative expense master that manages administrative expenses incurred by the public interest corporation to carry out the business by business included in the contract; a calculation step in which a calculation unit calculates a contract amount for the specified work to be invoiced to the contractor by adding up the total amount obtained in the calculation step and the administrative expenses obtained in the acquisition step; A contract amount calculation method comprising:

5. An information processing device, a tabulation means for tabulating expenses related to the account items corresponding to designated tasks and the designated contracts from purchase data managed by linking the costs related to purchases incurred by the public interest corporation to the contracts for the business concluded by the public interest corporation with its contractors and the account items related to the tasks included in the contracts; An acquisition means for acquiring administrative expenses associated with the specified business from an administrative expense master that manages administrative expenses incurred by the public interest corporation to carry out the business by business included in the contract; a calculation means for calculating a contract amount for the specified work to be invoiced to the contractor by adding up the total amount obtained by the calculation means and the administrative expenses obtained by the acquisition means; A contract amount calculation program to function as a contract amount calculation program.

Images