Construction price management device, program, and construction price management system

Abstract

To provide a construction price management device, a program, and a construction price management system that continually manage price management even during a working period of a construction.SOLUTION: A construction price management device 10 includes: a target gross profit calculation unit 11c that calculates a target gross profit on the basis of an accepted order amount and a target gross profit and registers it to a database 12; a planned gross profit calculation unit 11d that calculates a planned gross profit on the basis of the accepted order amount and a budget for the construction price, and registers it to the database 12; a planned gross profit ratio calculation unit 11e that calculates a planned gross profit ratio on the basis of the accepted order amount and the planned gross profit, and registers it to the database 12; an execution gross profit calculation unit 11f that calculates an execution gross profit on the basis of a trading volume and an already executed construction price, and registers it to the database 12; an execution gross profit ratio calculation unit 11g that calculates an execution gross profit ratio on the basis of the trading volume and the execution gross profit, and registers it to the database 12; and an execution ledger generation unit 11l that generates an execution ledger that displays the accepted order amount, the target gross profit ratio, the gross profit, the planned gross profit ratio, the gross profit, and the execution gross profit on one screen.SELECTED DRAWING: Figure 2

Description

[Technical field]

[0001] The present invention relates to a computer device, a computer system, or a program for managing construction prices. More specifically, the present invention relates to a device or the like that can grasp construction prices at any time during the construction period of the construction. [Background technology]

[0002] In construction work such as painting, civil engineering, and building construction, it is important to carry out the work safely, quickly, and cheaply, and to do so, it is necessary to constantly grasp the current state of the work and manage the work by eliminating excessive work, waste, and inconsistencies. In addition, in order for companies that undertake such construction work to ensure business profits, it is particularly important to calculate an actual budget that sets out the amount required for the work and manage the work price within that budget. In other words, it is necessary to maximize the profits obtained from each work by minimizing the costs required for the execution of the work while maintaining the quality of the work.

[0003] From this perspective, for example, Patent Document 1 proposes a civil engineering cost management device that allows the amount of work completed to be easily input at the site of the civil engineering work, accurately grasps the cost of the civil engineering work, and constantly manages the progress. The civil engineering cost management device of Patent Document 1 is said to be able to grasp the progress of the work at the site in terms of the amount of work completed (based on monetary value) and the completed form (based on the amount of work completed), and to appropriately manage costs and progress so as to avoid deficits against the budget and delays in the construction period. [Prior art documents] [Patent documents]

[0004] [Patent Document 1] Japanese Patent Application Publication No. 11-161712 Summary of the Invention [Problem to be solved by the invention]

[0005] However, since construction prices are not accurately determined until various construction projects are completely completed, it is difficult to grasp the construction prices that have been incurred up to a certain point during the construction period, and there is a problem that it is difficult to make appropriate judgments about the procurement of materials and outsourcing of work. Specifically, if it is not possible to properly grasp the construction price that has been incurred at a certain point during the construction period in relation to the order amount, it is difficult to know whether there is room in the budget, and it becomes difficult to make decisions about the procurement costs of materials and outsourcing costs. In particular, in relation to the gross profit margin (profit margin) targeted by the business company and the planned gross profit margin at the time of budget formulation, the construction personnel often cannot understand how much effective gross profit margin has been secured at a certain point during the construction period, and therefore, after the construction is completed, the effective gross profit margin has fallen below the target gross profit margin or planned gross profit margin without realizing it, or in the worst case, the effective gross profit has become negative. The device of Patent Document 1 is designed to grasp the progress of the construction in a timely manner based on the amount and the completed amount, but since it does not focus on managing the provisional construction prices required up to that point, the device cannot properly grasp the effective gross profit margin during the construction period.

[0006] Therefore, the main object of the present invention is to ensure appropriate profits for each construction project by constantly managing the construction price, particularly the effective gross profit rate, even during the construction period. [Means for solving the problem]

[0007] The inventor of the present invention has earnestly studied means for solving the problems of the above-mentioned conventional technology, and has found that, in addition to the target gross profit rate and gross profit (target gross profit rate, target gross profit) and the gross profit rate and gross profit rate planned at the time of budget formulation (planned gross profit rate, planned gross profit), the actual gross profit rate and actual gross profit during the construction period can be automatically calculated, and a construction ledger that can display these values ​​in a list can be created and presented to users such as construction personnel, making it easier to manage the construction price that has been completed during the construction period, and raising awareness of ensuring appropriate profits for each construction. Based on the above knowledge, the inventor has come up with the idea that the problems of the conventional technology can be solved, and has completed the present invention. Specifically, the present invention has the following configuration.

[0008] The first aspect of the present invention relates to a construction price management device. The "construction price" in this specification is the construction price described in the public construction construction cost estimation standard, and is the cost charged to the client as the construction cost. The construction price includes the construction cost (including direct construction cost and site management cost, etc.), which is all the costs incurred at the construction site, and sales and administrative expenses (also called general administrative expenses) for maintaining the business that are not directly related to the construction. The amount equivalent to consumption tax is not included in the construction price referred to here. The construction price management device according to the present invention basically has an input unit, a database, a target gross profit calculation unit, a planned gross profit calculation unit, a planned gross profit rate calculation unit, an effective gross profit calculation unit, an effective gross profit rate calculation unit, and an execution ledger generation unit. The input unit accepts input of cost information including information on the order amount, target gross profit rate, construction price budget, progress, and completed construction price for a specific construction, and provides the user with an interface for this purpose. The database stores the cost information accepted by the input unit in association with information on the specific construction. The target gross profit calculation unit calculates a target gross profit based on the order amount and the target gross profit rate stored in the database, and registers the target gross profit in the database. The planned gross profit calculation unit calculates a planned gross profit based on the order amount and the budget for the construction price stored in the database, and registers the planned gross profit in the database. The planned gross profit rate calculation unit calculates a planned gross profit rate based on the order amount and the planned gross profit stored in the database, and registers the planned gross profit rate in the database. The actual gross profit calculation unit calculates an actual gross profit based on the completed volume and the price of the completed construction stored in the database, and registers the actual gross profit in the database. The actual gross profit rate calculation unit calculates an actual gross profit rate based on the completed volume and the actual gross profit registered in the database, and registers the actual gross profit rate in the database. The actual ledger generation unit reads out the order amount, target gross profit rate, target gross profit, planned gross profit rate, planned gross profit, actual gross profit rate, and actual gross profit registered in the database, and generates an actual ledger that displays these numerical values ​​on one screen. In addition, "displaying on one screen" means that it is sufficient for the various numerical values ​​described here to be shown on one document or in one window (display area on a computer screen), and it is not necessary for all numerical values ​​to be displayed on a display etc. at the same time.In this way, by listing various figures such as order amount, target gross profit margin, target gross profit, planned gross profit margin, planned gross profit, actual gross profit margin, and actual gross profit on the execution ledger, it is possible to properly understand whether profits are being secured for each project.

[0009] In the construction price management device according to the present invention, it is preferable that the input unit further accepts input of the breakdown of the amount of work completed and the breakdown of the price of the completed construction during the construction period from the time the construction is ordered until completion, and registers them in the database. In this case, the actual gross profit calculation unit calculates the total amount of work completed from the breakdown of the amount of work completed registered in the database, and calculates the total price of the completed construction from the breakdown of the price of the completed construction registered in the database. Then, the actual gross profit calculation unit calculates the actual gross profit during the construction period based on the total amount of work completed and the total price of the completed construction, and registers the actual gross profit during the construction period in the database. In this way, the construction price management device has the function of calculating the total amount of work completed and the breakdown of the price of the completed construction input during the construction period from each of the details, making it easy to grasp the actual gross profit during the construction period at any time.

[0010] In the construction price management device according to the present invention, it is preferable that the effective gross profit rate calculation unit calculates the effective gross profit rate during the construction period based on the volume of work registered in the database and the effective gross profit during the construction period, and registers the effective gross profit rate during the construction period in the database. In this way, by calculating the effective gross profit rate during the construction period as well as the effective gross profit during the construction period at any time, it becomes easier to manage the construction price at any time during the construction period.

[0011] In the construction price management device according to the present invention, it is preferable that the input unit further accepts input of the breakdown of the progress during the construction period from after the order for the construction to before completion, and registers it in the database. In this case, it is preferable that the construction price management device further has a construction progress rate calculation unit that calculates the total progress from the breakdown of the progress registered in the database, and calculates the construction progress rate based on the total progress and the order amount registered in the database. It is preferable that the information on this construction progress rate is displayed on the execution ledger. In this way, by the construction price management device further having a function to automatically calculate the construction progress rate based on the breakdown of the progress input during the construction period, it becomes easier to grasp, for example, how much profit (execution gross profit) can be secured at the construction progress rate at a certain point in time.

[0012] The construction price management device according to the present invention preferably further includes a search unit that searches for information on construction with any effective gross profit margin from information on construction stored in the database. For example, it becomes easy to search all at once for construction that has achieved a target effective gross profit margin (for example, 10% or more), or conversely, for construction that has not achieved the target effective gross profit margin, and it becomes possible to find improvements to achieve the target.

[0013] The second aspect of the present invention relates to a computer program. The program according to the present invention is a program for making a general-purpose computer function as the construction price management device according to the first aspect described above. The program according to the present invention may be downloadable via the Internet, or may be stored in a non-transitory recording medium such as a CD-ROM.

[0014] The third aspect of the present invention relates to a construction price management system. The construction price management system comprises a terminal device and a server device connected to each other through a network. The construction price management system comprises the above-mentioned input unit, database, target gross profit calculation unit, planned gross profit calculation unit, planned gross profit rate calculation unit, actual gross profit calculation unit, actual gross profit rate calculation unit, and execution ledger generation unit. Each of these functional units may be possessed by either the terminal device or the server device, and may be realized by cooperation between the terminal device and the server device. In particular, it is preferable that the construction price management system is configured such that the server device has a database, and one or more terminal devices connected to the server device can access a common database on the server device. Effect of the Invention

[0015] According to the present invention, the construction price, particularly the effective gross profit rate, can be constantly managed even during the construction period, thereby enhancing awareness of ensuring appropriate profits for each construction project. [Brief description of the drawings]

[0016] [Figure 1] Figure 1 shows a schematic diagram of the features of the construction price management device. [Diagram 2] FIG. 2 is a block diagram showing the functional configuration of the construction price management device. [Diagram 3] FIG. 3 shows an example of a main menu presented by the construction price management device. [Figure 4] FIG. 4 shows an example of a construction ledger budget created by the construction price management device. [Diagram 5] FIG. 5 shows an example of a construction work budget plan created by the construction work price management device. [Figure 6] FIG. 6 shows an example of a construction work ledger created by the construction work price management device. [Figure 7] FIG. 7 shows an example of a execution ledger created by the construction price management device. [Figure 8]FIG. 8 shows an example of a progress amount input screen presented by the construction price management device. [Figure 9] FIG. 9 shows an example of a construction ledger search menu presented by the construction price management device. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0017] Hereinafter, the embodiments of the present invention will be described with reference to the drawings. The present invention is not limited to the embodiments described below, and includes appropriate modifications of the embodiments described below within the scope obvious to those skilled in the art.

[0018] FIG. 1 is a schematic diagram showing the features of a construction work price management device according to an embodiment of the present invention. As shown in FIG. 1, the construction work price management device includes a database that comprehensively stores information about a plurality of construction works. In this database, identification information such as a unique construction work number is assigned to each construction work, and various information related to each construction work is stored in association with this identification information. In addition, the construction work price management device can use the information stored in this database to create a construction work ledger budget (see FIG. 4), a construction work budget plan (see FIG. 5), a construction ledger (see FIG. 6), and an execution ledger (see FIG. 7), etc., for each construction work, and provide them to the user. Details of each document will be described later, but the construction ledger budget and construction work budget plan are created at the time of budget planning before the construction work is ordered, and mainly include basic matters of the construction work, estimated amounts of various costs required for the construction work, budget plans, etc. On the other hand, the construction ledger and execution ledger are created after the construction work is ordered, and mainly include the price and progress of the construction work performed during the construction work period, or a breakdown of these.

[0019] As a noteworthy point, as shown in Figure 1, the construction budget plan includes the target gross profit calculated from the budget of the order amount and the target gross profit rate, and the planned gross profit and its planned gross profit rate calculated from the budget of the order amount and the budget of the construction price. In addition, the execution ledger inherits at least the target gross profit rate, the target gross profit, the planned gross profit rate, and the planned gross profit from the construction budget plan, and in addition to these values, the completed construction volume, the price of the construction work that has already been carried out, or the actual gross profit and its actual gross profit rate calculated from these amounts are listed. By listing at least the target gross profit rate, the target gross profit, the planned gross profit, the planned gross profit, the actual gross profit rate, and the actual gross profit rate in a list in the execution ledger, the construction manager can easily grasp at any time whether the gross profit rate targeted by the business company and the planned gross profit rate calculated at the time of budget planning have been achieved at each point during the construction period. In addition, if there is a possibility that these targets cannot be achieved, it becomes possible to make policy corrections during the construction period, such as changing the way construction expenses are used.

[0020] The main items listed in the construction ledger budget and the construction ledger are the same, and the items listed in the construction ledger budget prepared before an order is received are carried over to the construction ledger after an order is received. The construction ledger budget is linked in the database to the business property summary, which lists basic details of the construction and customer requirements, making it possible to immediately view the business property summary from the construction ledger budget. In addition, a folder provided by the computer's OS is linked in the database to the construction ledger, and this folder is called the construction ledger folder. The construction ledger folder can store various data such as documents related to the construction (such as bidding documents and contract documents) and site photos.

[0021] Fig. 2 is a block diagram showing the main functional configuration of the construction price management device 10 according to one embodiment of the present invention. Note that Fig. 2 shows only the main functions related to the features of the construction price management device 10 in order to explain the features of the construction price management device 10, and the construction price management device 10 may have various other functions and is not limited to the functions described here.

[0022] The construction price management device 10 mainly includes a processing unit 11 and a storage unit 12. The processing unit 11 is composed of, for example, a processor and a memory. Examples of the processor are a known CPU or GPU. The processor performs a predetermined arithmetic processing and image processing according to the programs and data stored in the memory, and executes various control processes while writing the results of the processing in the working space of the memory. The memory is composed of, for example, a volatile memory such as a RAM (Random Access Memory), and is used for the arithmetic processing by the above-mentioned processor. The storage unit 12 is an element (storage) for storing data mainly used for processing by the processing unit 11. This storage unit 12 is used as a database that comprehensively stores information about multiple construction projects. The storage unit 12 may store a program used for processing by the processor included in the processing unit 11. The storage unit 12 is composed of a non-volatile memory such as a ROM (Read Only Memory) or a flash memory, and an HDD (Hard Disk Drive).

[0023] The construction price management device 10 also includes an input / output interface for connecting the input device 20 and the output device 30. The input device 20 and the output device 30 can be regarded as an integrated device included in the construction price management device 10. The input device 20 can be a known input device such as a keyboard, mouse, or touchpad. The output device 30 can be a known output device such as a display, projector, or printer. In this embodiment, it is basically assumed that documents such as the construction ledger budget, construction budget plan, construction ledger, and execution ledger described above are displayed on a display and provided to the user. However, these documents can also be printed by a printer.

[0024] As shown in FIG. 2, the processing unit 11 of the construction price management device 10 mainly includes an input unit 11a, an output unit 11b, a target gross profit calculation unit 11c, a planned gross profit calculation unit 11d, a planned gross profit rate calculation unit 11e, an actual gross profit calculation unit 11f, an actual gross profit rate calculation unit 11g, a construction progress rate calculation unit 11h, a construction ledger budget generation unit 11i, a construction budget plan generation unit 11j, a construction ledger generation unit 11k, an actual ledger generation unit 11l, and a search unit 11m. These functional blocks 11a to 11m are realized by the processing unit 11 executing arithmetic processing according to a predetermined program. The input unit 11a accepts predetermined input information from a user. For example, the input unit 11a provides a predetermined user interface on the display of the output device 30 to allow the user to input predetermined input information to the construction price management device 10 via the input device 20. The output unit 11b controls the output device 30 to output the results of calculations performed by each block of the processing unit 11. For example, the output unit 11b displays documents such as the above-mentioned construction ledger budget, construction budget plan, construction ledger, and execution ledger, as well as screens for inputting each item, on the display of the output device 30. The functions of the blocks 11c to 11m other than the input unit 11a and the output unit 11b will be described below with reference to examples.

[0025] FIG. 3 shows an example of a main menu that summarizes the functions provided by the construction price management device 10. This main menu is displayed on the display of the output device 30, and the user can operate the main menu using the input device 20. The actual construction price management device 10 has various functions, but in this embodiment, the description will be limited to the functions related to the construction ledger. As shown in FIG. 3, when the construction ledger menu is clicked, a window is opened and further buttons for the construction ledger budget, construction ledger, execution ledger, execution ledger list, and construction ledger search are displayed, and the user can select any one of these buttons. Clicking the construction ledger budget button transitions to a viewing screen for the construction ledger budget and construction budget plan, clicking the construction ledger button transitions to a viewing screen for the construction ledger, and clicking the execution ledger button transitions to a viewing screen for the execution ledger. In addition, the execution ledger list button calls a function for creating a list of the execution ledger for each construction stored in the database. The construction ledger search button transitions to a construction ledger search menu (see FIG. 9).

[0026] 4 to 7 show examples of the construction ledger budget, construction budget plan, construction ledger, and execution ledger that can be output by the construction price management device 10. Basically, all of the information (text data and numerical data) listed in each of these documents is stored in the database in the storage unit 12. Therefore, the processing unit 11 can create the above-mentioned various documents by reading out the necessary information from this database and applying it to the format of each document. Since the data structure in the database is complex, this application shows examples of each document instead. Each document shown in FIG. 4 to FIG. 7 is basically a document related to the same construction. In the illustrated example, each document lists identification information for this construction, such as the construction number "20507003". In other words, in the database, various information listed in each document is stored in association with the construction number "20507003".

[0027] Figure 4 shows an example of a work ledger budget. A work ledger budget is a document created during budget planning before a work is officially ordered. The work ledger budget contains basic information about the work, such as the contractor, construction period, order amount, and estimated amount. As shown in Figure 4, when a customer requests an estimate for the construction budget, a unique work number (20507003) is assigned to the work. This work number is then used consistently after the order is received as a number to identify the work. As shown in Figure 4, in addition to the unique work number, the work ledger budget contains information such as the abbreviated name, order date, on-site management type (full-time or semi-full-time), the contractor's company name, the name of our staff, the name of the contractor's staff, the main type of work (painting work, civil engineering work, etc.), the classification of prime contractor or subcontractor, the address of the work site, construction period, order amount, estimate date, estimate amount, payment terms, work overview, other special notes, and change history of the order amount. The construction ledger budget can also include information on the breakdown of the amount of work completed (date, amount), the issuance of an invoice for the amount of work completed (date, amount), and the date of receipt of payment for the invoice (date, amount) if such information is predictable. The input unit 11a accepts this information from the user and registers each piece of information in the database as appropriate. The construction ledger budget generation unit 11i reads out this information from the database and generates the construction ledger budget by fitting the read out information into the construction ledger budget format.

[0028] In addition, this construction ledger budget allows the user to input the estimated amount and the consumption tax rate. The input unit 11a accepts input of the estimated amount and the consumption tax rate for the construction project and registers them in the database. For example, when the estimated amount (3,650,000 yen) and the consumption tax rate (10%) are input, the processing unit 11 automatically calculates the tax amount (365,000 yen) and the amount including tax (4,015,000 yen), and these values ​​are registered in the database and also published in the construction ledger budget.

[0029] As shown in Fig. 4, the construction ledger budget includes the business property summary number. The business property summary number is a button, and when the button is clicked, the business property summary associated with the construction project is read from the memory unit 12 and displayed on the display. The information to be written in the business property summary may be publicly known.

[0030] Figure 5 shows an example of a construction budget plan. The construction budget plan is a document that is created together with the construction ledger budget described above at the time of budget planning before the construction work is officially ordered. This construction budget plan is used to calculate the direct construction cost budget, taking into account the order amount, and to find gross profit and gross profit rate. The construction budget plan inherits the same construction number as the construction ledger budget. The construction budget plan also inherits the order amount (3,650,000 yen) that was entered for the construction ledger budget.

[0031] First, the construction budget plan allows the user to calculate the target gross profit. Specifically, the construction budget plan allows the user to input the value of the target gross profit rate. The input unit 11a accepts the input of the target gross profit rate information for the construction project and registers it in the database. The target gross profit calculation unit 11c of the processing unit 11 reads the order amount and the target gross profit rate from the database, and automatically calculates the target gross profit based on these values. For example, when the target gross profit rate (10.00%) is input, the target gross profit calculation unit 11c calculates [order amount x target gross profit rate], automatically calculates the target gross profit (365,000 yen), and registers the value in the database.

[0032] This construction budget plan also allows the user to enter information about the direct construction cost budget. "Direct construction cost" refers to costs directly incurred in carrying out construction work. In the example shown in Figure 5, the total direct construction cost budget (2,430,000 yen) is the sum of the total material purchases (360,000 yen), total labor costs (200,000 yen), total subcontract costs (1,560,000 yen), total leases (250,000 yen), total industrial waste (none), total auxiliary materials (10,000 yen), and total other (50,000 yen). In addition, the construction budget plan may be designed so that the total budget of direct construction costs is directly input, but the total budget of direct construction costs is automatically calculated by inputting the breakdown of material purchase costs, labor costs, subcontract costs, lease costs, industrial waste (industrial waste disposal costs), auxiliary material costs, and other expenses. That is, when the user inputs the breakdown of each item (material purchase, labor costs, subcontract costs, lease, industrial waste, auxiliary materials, and others) in the construction budget plan, the processing unit 11 automatically calculates the total of each item, and these values ​​are registered in the database and posted in the construction budget plan. Furthermore, when the total of each item is obtained, the processing unit 11 automatically calculates the total budget of direct construction costs (2,430,000 yen) by adding up these costs, and the value is registered in the database and posted in the construction budget plan.

[0033] In addition, the construction budget plan can calculate site management costs and sales and administrative costs (also called general administrative costs). "Site management costs" are costs necessary for managing and operating a construction site when carrying out construction work. "Sales and administrative costs" are costs necessary for the ongoing operation of a construction company when carrying out construction work. Specifically, the construction budget plan allows the user to input values ​​for the site management rate and sales and administrative costs. The input unit 11a accepts input of information on the site management rate and sales and administrative costs for the construction work in question and registers them in the database. The values ​​of the site management rate and sales and administrative costs are arbitrary and may be set according to past empirical rules. In the illustrated example, the site management rate is set to 10.00% and the sales and administrative costs to 7.0%, but are not limited to these. When the site management rate is input, the processing unit 11 reads out the order amount and the site management rate from the database and automatically calculates the site management cost based on these values. For example, when a site management rate (10.00%) is input, the processing unit 11 calculates [order amount x site management rate], automatically calculates the site management cost (365,000 yen), and registers this value in the database. Similarly, when a sales management rate is input, the processing unit 11 reads out the order amount and sales management rate from the database, and automatically calculates the sales management cost based on these values. For example, when a site management rate (7.00%) is input, the processing unit 11 calculates [order amount x sales management rate], automatically calculates the site management cost (255,500 yen), and registers this value in the database.

[0034] In addition, the construction budget plan allows the calculation of the construction price. The construction price is the sum of the direct construction cost, site management cost, and sales and administrative cost described above. In the illustrated example, the processing unit 11 reads out the direct construction cost (2,430,000 yen), site management cost (365,000 yen), and sales and administrative cost (255,500 yen) from the database, adds up these values, and automatically calculates the construction price (3,050,500 yen), and registers the value in the database.

[0035] In addition, the construction budget plan can calculate the planned gross profit and the planned gross profit rate. Specifically, the planned gross profit calculation unit 11d of the processing unit 11 reads the order amount and the construction price from the database, and automatically calculates the planned gross profit based on these values. In the illustrated example, the planned gross profit calculation unit 11d reads the order amount (3,650,000 yen) and the construction price (3,050,500 yen) from the database, calculates [order amount-construction price], automatically calculates the planned gross profit (599,500 yen), and registers this value in the database. Furthermore, the planned gross profit rate calculation unit 11e of the processing unit 11 reads the order amount and the planned gross profit from the database, and automatically calculates the planned gross profit rate based on these values. In the illustrated example, the planned gross profit calculation unit 11e reads the order amount (3,650,000 yen) and the planned gross profit (599,500 yen) from the database, calculates [planned gross profit / order amount], automatically calculates the planned gross profit rate (16.42%), and registers this value in the database.

[0036] Furthermore, in this construction budget plan, as shown in Fig. 5, the processing unit 11 may automatically calculate the difference (234,500 yen) obtained by subtracting the target gross profit from the planned gross profit. If this difference is negative, the target gross profit will not be achieved at the time of budget planning, and the plan will need to be revised. In that case, the reason why the difference is negative may be entered in the construction budget plan. The upper difference is registered in the database together with the reason.

[0037] The necessary items to be included in the construction budget plan are obtained by the above-mentioned various calculation processes. The construction budget plan generation unit 11j reads out the necessary items to be included in the construction budget plan from the database, and generates the construction budget plan by fitting the read-out information into the construction budget plan format. As shown in Figure 5, the construction budget plan displays information on the order amount, target gross profit rate, target gross profit, planned gross profit rate, planned gross profit, construction price, etc. on one screen.

[0038] FIG. 6 shows an example of a construction ledger. The construction ledger is a document that is created after a construction project is officially ordered. The construction ledger basically inherits the items listed in the construction ledger budget shown in FIG. 4. In other words, the items listed in the construction ledger are information that has already been entered and registered in the database when the construction ledger budget is created, so the construction ledger can be created by reading the information from this database. The construction ledger generating unit 11k can generate the construction ledger by reading this information from the database and fitting the read information into the construction ledger format. Unlike the construction ledger budget, the construction ledger allows photos of the construction site and the construction target to be posted before and after construction. Link information for these photo data can be managed in a database.

[0039] As shown in FIG. 6, the construction ledger has an execution ledger button, a budget change button, and a construction ledger folder button. Clicking the execution ledger button transitions to a screen for viewing the execution ledger, which will be described later. Clicking the budget change button transitions to a dedicated screen for budget changes (not shown), where the total material purchases, total labor costs, total outsourcing costs, total lease costs, total industrial waste, total auxiliary materials, and total other costs, as well as their breakdown, determined in the construction budget plan (see FIG. 5) can be changed. When the amounts of these items are changed, the amounts registered in the database are also updated. It is preferable to keep a record of the amounts before the change in the database so that the history of when and how the amounts were changed can be checked later. Clicking the construction ledger folder button also expands the construction ledger folder linked to this construction ledger. The construction ledger folder can store various data, such as documents related to the construction (such as bidding documents and contract documents) and site photos.

[0040] Figure 7 shows an example of an execution ledger. The execution ledger is a document for managing the daily progress made during the construction period and the executed budget. By checking the execution ledger, you can easily check the progress rate of the construction work and the remaining budget. In addition, the execution ledger regularly updates and publishes the effective gross profit margin and effective gross margin, so by comparing the latest effective gross profit margin with the target gross profit margin and planned gross profit margin determined when the budget was formulated, you can immediately understand whether profits are being secured at the current point in time.

[0041] As shown in Figure 7, the execution ledger lists basic information such as the project number, abbreviated name, the name of the manager, the type of on-site management (resident or semi-resident), the company name of the contractor, the classification of prime contractor or subcontractor, the address of the construction site, and the contract construction period (from to). This information can be inherited from what is already registered in the database. In addition, the execution ledger also lists information on the profits of the construction, such as the order amount (excluding tax), target gross profit rate, target gross profit, planned gross profit rate, and planned gross profit. As mentioned above, this information is entered or calculated when the construction budget plan is created and registered in the database, so the information on the database can be inherited. In addition, the execution ledger also lists information on the breakdown of each budget, which is the basis for the planned gross profit and planned gross profit rate calculated during the budget plan. Specifically, the execution ledger lists the total budget for the order amount (volume), purchase costs, labor costs, outsourcing costs, lease costs, industrial waste, auxiliary materials, and other expenses, just like the construction budget plan (see Figure 5). In addition, the execution ledger lists the total direct construction cost budget, site management costs (calculated at 10%), sales and administrative costs (calculated at 7%), construction price, gross profit (planned gross profit), and gross profit rate (planned gross profit rate) that were determined when the construction budget plan was created. Similarly, the various budgets listed in the execution ledger can be carried over from those already registered in the database. The direct construction cost gross profit (1,220,000 yen) is not listed in the construction budget plan, but is simply the value obtained by subtracting the total direct construction costs (2,430,000 yen) from the order amount (3,650,000 yen).

[0042] In addition, the total amount of work performed during the construction period can be entered in the execution ledger. In the example shown in FIG. 7, the total amount of work performed is 100,000 yen. The total amount of work may be directly entered in the execution ledger, but it is preferable to provide a dedicated screen for recording the amount of work so that the breakdown of the amount of work can be entered. FIG. 8 shows an example of a screen for recording the amount of work. The execution ledger has a button for recording the amount of work, and clicking this button transitions to the screen for recording the amount of work. As shown in FIG. 8, the screen for recording the amount of work displays information such as the construction number and basic information of the contractor, as well as the order amount, the amount including tax, the amount of consumption tax, and the construction price budget. In addition, in the screen for recording the amount of work, the breakdown of the amount of work can be entered for each day in association with the date of execution. As the breakdown of the amount of work, the degree to which the work has progressed relative to the order amount is entered on a monetary basis. In the example shown in the figure, it can be seen that work for an amount of work of 100,000 yen was completed on May 1, 2023. In addition to the breakdown of the amount of work, the amount of additional orders, the amount billed to the supplier, the amount received from the supplier, and the discount amount on the order amount can be input on the screen for recording the amount of work. The input unit 11a provides the screen for recording the amount of work to the user, and accepts input of information such as the breakdown of the amount of work from the user, and registers the input information in the database in a timely manner.

[0043] Furthermore, the processing unit 11 automatically calculates the total amount of the transaction from the breakdown of the transaction amount, and displays it on the screen for recording the transaction amount. In the illustrated example, since there is only one line of the transaction amount breakdown, the total amount and the breakdown amount are the same, but if there are two or more lines of the transaction amount breakdown, the total amount of the breakdown amount is displayed on the screen. The total amount of the transaction amount calculated on the screen for recording the transaction amount is registered in the database and is also transferred to the execution ledger. In the example shown in FIG. 7, the amount of the transaction that has been completed (100,000 yen) in the execution ledger is the value calculated in this manner using the screen for recording the transaction amount.

[0044] On the screen for recording the amount of work completed, the amount obtained by subtracting the total amount of work completed from the order amount is displayed as the remaining amount, and the amount of the total amount of work completed that has not yet been invoiced to the contractor is the remaining amount invoiced. Also, if any amount has been received from the contractor during the construction period, this amount can be recorded on this screen along with the breakdown of the amount of work completed. In that case, the amount obtained by subtracting the total amount of work received from the order amount is the remaining amount received.

[0045] The progress rate of the work is also displayed on the screen for recording the amount of work completed. That is, the work progress rate calculation unit 11h of the processing unit 11 calculates the total amount of work completed from the breakdown of the amount of work completed registered in the database, and calculates the progress rate of the work based on the total amount of work completed and the order amount registered in the database. Specifically, the work progress rate calculation unit 11h calculates [total amount of work completed / order amount], automatically calculates the progress rate of the work, registers the value in the database, and displays it on the screen for recording the amount of work completed. In the example shown in FIG. 8, the order amount is 3,650,000 yen, while the current total amount of work completed is 100,000 yen, so the progress rate of the work is 2.74%. Also, as shown in FIG. 7, the progress rate of the work calculated here is also listed in the execution ledger.

[0046] Returning to the explanation of FIG. 7, the execution ledger allows the direct construction costs that have been performed during the construction period to be entered at any time. As described above, the direct construction costs are the total of the cost of materials, labor costs, outsourcing costs, lease costs, industrial waste costs, auxiliary material costs, and other expenses. The construction budget plan has a purchase cost button, and clicking this button transitions to a screen (not shown) for inputting the breakdown of purchase costs, where the breakdown of the completed purchase costs can be entered. The total is calculated from the input purchase cost breakdown and posted in the execution ledger. Similarly, the construction budget plan has a labor cost button, and clicking this button transitions to a screen (not shown) for inputting the breakdown of the completed labor costs, where the breakdown of the labor costs can be entered. The total is calculated from the input labor cost breakdown and posted in the execution ledger. The construction budget plan also has an outsourcing button, and clicking this button transitions to a screen (not shown) for inputting the breakdown of outsourcing costs, lease costs, industrial waste costs, and auxiliary material costs by item, where the breakdown of outsourcing costs, lease costs, industrial waste costs, and auxiliary material costs that have already been executed can be input. The total of each item is calculated from the input breakdown of outsourcing costs, lease costs, industrial waste costs, and auxiliary material costs, and is posted in the execution ledger. In the example shown, at the current point in time, the purchase costs, labor costs, outsourcing costs, lease costs, industrial waste costs, and auxiliary material costs that have already been executed are all zero. The construction budget plan also has an expenses button, and clicking this button transitions to a screen (not shown) for inputting the breakdown of other expenses, where the breakdown of executed expenses can be input by item. Examples of other expense items, as shown in Figure 7, include labor costs, regular labor costs, statutory welfare, employee welfare costs, power costs, fuel costs, transportation costs, utility costs, taxes and public charges, various membership fees, packing and construction freight, rent, insurance, communication costs, entertainment costs, conference costs, fees, research costs, miscellaneous costs, repair costs, and complaint handling costs. In the example shown, it can be seen that transportation costs amounted to about 800 yen. The total amount of each other expense item (800 yen) is posted in the other expenses column of the execution ledger. The breakdown of the direct construction costs that have been executed and the total amount entered or automatically calculated in this way are registered in the database. This makes it possible to record direct construction costs that occur daily during the construction period in the execution ledger at any time.

[0047] In addition, the execution ledger can calculate the price of the completed construction work at any time during the construction period. As described above, the construction price is the sum of the direct construction cost, the site management cost, and the sales and administrative cost. In the illustrated example, the processing unit 11 reads out the completed direct construction cost (800 yen) from the database. The processing unit 11 also reads out the completed total amount of work (100,000 yen) from the database, and multiplies it by the site management rate (10%) to obtain the completed site management cost (10,000 yen). Similarly, the processing unit 11 multiplies the completed total amount of work (100,000 yen) by the sales and administrative rate (7%) to obtain the completed sales and administrative cost (7,000 yen). The processing unit 11 then automatically calculates the completed construction price (17,800 yen) by adding up the completed direct construction cost (800 yen), the site management cost (10,000 yen), and the sales and administrative cost (7,000 yen), and registers the value in the database. In addition, the price of the completed work calculated here (17,800 yen) will also be posted in the execution ledger.

[0048] In addition, the execution ledger can calculate the execution gross profit and the execution gross profit rate. Specifically, the execution gross profit calculation unit 11f of the processing unit 11 reads the executed amount and the executed construction price from the database, and automatically calculates the execution gross profit based on these values. In the illustrated example, the execution gross profit calculation unit 11f reads the executed amount (100,000 yen) and the executed construction price (17,800 yen) from the database, calculates [executed amount - executed construction price], automatically calculates the execution gross profit (82,200 yen), and registers this value in the database. Furthermore, the execution gross profit rate calculation unit 11g of the processing unit 11 reads the executed amount and the execution gross profit from the database, and automatically calculates the execution gross profit rate based on these values. In the illustrated example, the effective gross profit calculation unit 11g reads out the executed volume (100,000 yen) and the executed gross profit (82,200 yen) from the database, calculates [executed gross profit / executed volume], automatically calculates the effective gross profit rate (82.20%), and registers the value in the database.

[0049] The main items to be included in the execution ledger are obtained by the above-mentioned various calculation processes. The execution ledger generation unit 11l reads out the items to be included in the execution ledger from the database, and generates the execution ledger by fitting the read out information into the execution ledger format. As shown in FIG. 7, the execution ledger displays information on the order amount, target gross profit margin, target gross profit, planned gross profit margin, planned gross profit, actual gross profit margin, and actual gross profit on one screen. The execution ledger also displays the current construction progress rate. In particular, in this execution ledger, the order amount, target gross profit margin, target gross profit, planned gross profit margin, planned gross profit, actual gross profit margin, and actual gross profit are displayed in a row, so that these values ​​can be confirmed at a glance. In addition, the actual gross profit margin and actual gross profit are values ​​that change from time to time by inputting the breakdown of the completed amount and the breakdown of each item of the direct construction cost into the execution ledger on a daily basis. Similarly, the construction progress rate listed in the execution ledger also changes from time to time according to the completed amount. Therefore, by checking this execution ledger, it is possible to always know whether the actual gross profit is being secured against the construction progress rate, and whether the actual gross profit rate is not below the target gross profit rate or the planned gross profit rate. This supports construction management that eliminates unreasonableness, waste, and inconsistency, and raises awareness of ensuring appropriate profits for each construction project.

[0050] As described with reference to the main menu in FIG. 1, the construction cost management device 10 has a construction ledger search function. Clicking on the construction ledger search in the main menu transitions to the construction ledger search menu shown in FIG. 9. In this construction ledger search menu, a command to search the construction ledger for the database can be input. That is, in the example of the construction ledger search menu shown in FIG. 9, various buttons are provided for inputting the gross profit margin (i.e., the actual gross profit margin) as a search condition for each stage of construction completion (payment completed), construction completion (unpaid), and construction incompletion. Specifically, for construction completion (payment completed) and construction completion (unpaid), buttons are provided for searching the construction ledger under conditions such as gross profit margin of 27% or more, gross profit margin of 17 to 27%, gross profit margin of 10 to 17%, gross profit margin of 0 to 10%, and gross profit margin of less than 0%. For construction incompletion, buttons are provided for searching the construction ledger under conditions such as gross profit margin of 27% or more and gross profit margin of less than 27%.

[0051] The database stores information about a plurality of construction projects, and a construction ledger and an execution ledger are created for each construction project that has been ordered. For this reason, the aforementioned execution gross profit margin is calculated for each of the plurality of construction projects and registered in the database. Then, the search unit 11m of the processing unit 11 issues a search command to the database, with the execution gross profit margin rate corresponding to the button clicked by the user in the construction ledger search menu as a search condition. This allows the search unit 11m to search for information about construction projects with the execution gross profit margin rate specified by the user from among the information about a large number of construction projects stored in the database. In particular, the construction ledger search menu shown in FIG. 9 has buttons for selecting gross profit margin rates for each stage of construction completion (payment completed), construction completion (unpaid), and construction incomplete, so that the search unit 11m can search for information about construction projects with the execution gross profit margin rate of the construction projects in the database by limiting the conditions to construction completion (payment completed), construction completion (unpaid), and construction incomplete. For the construction projects extracted by the search unit 11m, the construction ledger generation unit 11k creates an execution ledger for them, and the created execution ledger is output from the output device 30. In this way, by calculating the effective gross profit rate for each construction project received and registering it in the database, construction projects with any effective gross profit rate can be searched for at any time from the database.

[0052] Above, an embodiment of the construction cost management device 10 has been described with reference to FIG. 2 and the like. This construction cost management device 10 is a so-called stand-alone type, and is assumed to be not connected to the Internet. On the other hand, the present invention is not limited to such a stand-alone type construction cost management device, and can also be applied to a server-client type construction management system. That is, the present invention may be a construction price management system including a terminal device and a server device connected to each other through a network. In this case, the terminal device and the server device may share each function of the construction cost management device 10 described above. For example, in this system, a database describing the construction cost management device 10 may be provided in a server device on the cloud, and a plurality of terminal devices connected to this server device may be able to access a common database via the Internet. This allows a plurality of terminal devices to share information on the database. Also, in this system, each functional block of the processing unit 11 described for the construction cost management device 10 may be realized by a terminal device, or a part of it may be realized by a server device on the cloud. In this way, in the server-client type construction management system, each function of the construction cost management device 10 described above can be realized by the cooperation of a terminal device and a server device connected to each other through a network.

[0053] In the above, in order to express the contents of the present invention, the present specification has described the embodiments of the present invention with reference to the drawings. However, the present invention is not limited to the above-mentioned embodiments, and includes modifications and improvements that are obvious to a person skilled in the art based on the matters described in the present specification. [Explanation of symbols]

[0054] 10...Construction price management device 11... Processing section 12...Storage section 11a...Input section 11b...Output section 11c…Target gross profit calculation section 11d…Planned Gross Profit Calculation Department 11e…Planned Gross Profit Margin Calculation Department 11F…Actual Gross Profit Calculation Department 11g…Effective gross profit calculation section 11h…Construction progress rate calculation section 11i…Construction ledger budget generation section 11j…Construction budget plan generation section 11k…Construction ledger generation section 11l…Execution ledger generation section 11m…Search section 20...Input device 30...Output device

Claims

1. An input unit that accepts input of cost information including information regarding the order amount, target gross profit rate, budget of construction price, progress, and price of construction work that has already been performed for a specific construction work; a database that stores the cost information in association with information about the specific construction project; a target gross profit calculation unit that calculates a target gross profit based on the order amount and the target gross profit rate stored in the database and registers the target gross profit in the database; a planned gross profit calculation unit that calculates a planned gross profit based on the order amount and the construction price budget stored in the database and registers the planned gross profit in the database; a planned gross profit margin calculation unit that calculates a planned gross profit margin based on the order amount and the planned gross profit stored in the database, and registers the planned gross profit margin in the database; an actual gross profit calculation unit that calculates an actual gross profit based on the amount of work and the price of the completed construction work stored in the database, and registers the actual gross profit in the database; an effective gross profit margin calculation unit that calculates an effective gross profit margin based on the volume and effective gross profit registered in the database, and registers the effective gross profit margin in the database; The system has an execution ledger generating unit that generates an execution ledger that displays the order amount, target gross profit rate, target gross margin, planned gross profit rate, planned gross margin, actual gross profit rate, and actual gross margin registered in the database on one screen. Construction price management device.

2. The input unit further receives input of a breakdown of the progress and a breakdown of the price of the completed construction during the construction period from after the construction is received until completion, and registers the input in the database, The actual gross profit calculation unit calculates the total amount of work from the breakdown of the amount of work registered in the database, and calculates the total price of the completed construction work from the breakdown of the price of the completed construction work registered in the database, calculates the actual gross profit during the construction period based on the total amount of work and the total price of the completed construction work, and registers the actual gross profit during the construction period in the database. The construction price management device according to claim 1.

3. The effective gross profit rate calculation unit calculates an effective gross profit rate during the construction period based on the volume registered in the database and the effective gross profit during the construction period, and registers the effective gross profit rate during the construction period in the database. The construction price management device according to claim 2.

4. The input unit further receives an input of a breakdown of the completed work during a construction period from after the construction work is received until completion, and registers the input in the database, The construction price management device further includes a construction progress rate calculation unit that calculates a total amount of work from the breakdown of the amount of work registered in the database, and calculates a construction progress rate based on the total amount of work and the order amount registered in the database. The construction price management device according to claim 1 or 2.

5. The system further includes a search unit for searching for information on construction projects with any effective gross profit rate from information on construction projects stored in the database. The construction price management device according to claim 1 or 2.

6. The search unit searches for information on construction work stored in the database, based on at least the condition of completion or incompletion of the construction work, and searches for information on construction work with an arbitrary effective gross profit rate from information on construction work that meets the limited condition. The construction price management device according to claim 5.

7. A program for causing a computer to function as the construction price management device according to claim 1.

8. A construction price management system comprising a terminal device and a server device connected to each other through a network, the system comprising: An input unit that accepts input of cost information including information regarding the order amount, target gross profit rate, budget of construction price, progress, and price of construction work that has already been performed for a specific construction work; a database that stores the cost information in association with information about the specific construction project; a target gross profit calculation unit that calculates a target gross profit based on the order amount and the target gross profit rate stored in the database and registers the target gross profit in the database; a planned gross profit calculation unit that calculates a planned gross profit based on the order amount and the construction price budget stored in the database and registers the planned gross profit in the database; a planned gross profit margin calculation unit that calculates a planned gross profit margin based on the order amount and the planned gross profit stored in the database, and registers the planned gross profit margin in the database; an actual gross profit calculation unit that calculates an actual gross profit based on the amount of work and the price of the completed construction work stored in the database, and registers the actual gross profit in the database; an effective gross profit margin calculation unit that calculates an effective gross profit margin based on the volume and effective gross profit registered in the database, and registers the effective gross profit margin in the database; The system has an execution ledger generating unit that generates an execution ledger that displays the order amount, target gross profit rate, target gross margin, planned gross profit rate, planned gross margin, actual gross profit rate, and actual gross margin registered in the database on one screen. system.

Images