JP7197989B2 - Progress rate calculation device, progress rate calculation method, and progress rate calculation program - Google Patents

Description

The present invention relates to a progress rate calculation device, a progress rate calculation method, and a progress rate calculation program.

Patent Literature 1 discloses a plant construction plan support device and method capable of quickly creating a highly accurate construction plan in line with the details of construction (see paragraph 0008 of Patent Literature 1).

JP 2011-170496 A

In this way, for example, in the field of construction plan management, it is important to accurately grasp the deviation between the planned amount of work (scheduled amount of work) and the amount of work actually performed (actual amount of work). This is important for analyzing delays, etc.

Here, conventionally, although it is possible to compare the planned work amount and the actual work amount at the end of the construction period, the planned work amount and the actual work amount at the end of each of the plurality of periods included in the construction period are different. could not be compared. For example, if the construction period includes April to July, the planned progress rate and actual progress rate at the end of April, the planned progress rate and actual progress rate at the end of May, June By calculating the planned progress rate and actual progress rate at the end of the month and the planned progress rate and actual progress rate at the end of July, the planned work volume and actual work volume at the end of each month Conventionally, it was not possible to make a comparison with

The present invention has been made in view of the above problems, and provides a progress rate calculating apparatus capable of calculating a planned progress rate and an actual progress rate at each end point of a plurality of periods included in a construction period, and a progress rate. An object of the present invention is to provide a calculation method and a progress rate calculation program.

In order to solve the above-described problems and achieve the object, a progress rate calculation device according to the present invention provides a progress rate calculator for calculating a progress rate of construction work on the orderer side of the construction work for managing the progress of the construction work at the contractor. A rate calculation device comprising a control unit and a storage unit, wherein the storage unit stores a scheduled amount for each period, which is an amount to be paid to a construction contractor for each of a plurality of periods included in the construction period, and the construction period. A planned total amount that is the total amount of the scheduled amount for each period within the period, an actual amount for each period that is the amount paid to the construction contractor according to the work performance of the construction for each of the plurality of periods, and the construction period is stored in association with the actual total amount, which is the total amount of the actual amount for each period, and the control unit is the scheduled amount for each period that can be changed except for the fixed period, The process of calculating the scheduled progress rate at the end of the certain period based on the cumulative amount of the scheduled amount for each period and the scheduled total amount at the end of the certain period included in the construction period. a first progress rate calculation means for calculating the scheduled progress rate at the end of the last period included in the construction period from the scheduled progress rate at the end of the first period included in the construction period; The process of calculating the actual progress rate at the end of the certain period based on the cumulative amount of actual results for each period and the total amount of actual results at the end of the certain period is performed at the end of the first period. a second progress rate calculating means for calculating the actual progress rate at the end of the last period from the actual progress rate at the point in time.

Further, the progress rate calculation method according to the present invention is a progress rate calculation device for calculating the progress rate of construction work for managing the progress of construction work at the contractor on the orderer side of the construction work. A progress rate calculation method executed by an information processing apparatus comprising: A scheduled total amount that is the total amount of the scheduled amount for each period within the construction period, and an actual amount for each period that is an amount paid to the construction contractor according to the work performance of the construction for each of the plurality of periods; The actual total amount that is the total amount of the actual amount for each period within the construction period is linked and stored, and is executed by the control unit for each period that can be changed except for the fixed period Calculates a scheduled progress rate at the end of a certain period based on the cumulative amount of the scheduled amounts for each period and the total scheduled amount at the end of the certain period included in the construction period. The first progress is performed until the scheduled progress rate at the end of the last period included in the construction period is calculated from the scheduled progress rate at the end of the first period included in the construction period. a rate calculating step; and a process of calculating an actual progress rate at the end of the given period based on the accumulated amount of actual results for each period and the total amount of actual results at the end of the given period. and a second progress rate calculation step, which is performed from the actual progress rate at the end of the first period to calculating the actual progress rate at the end of the last period. do.

Further, a progress rate calculation program according to the present invention is a progress rate calculation device for calculating the progress rate of construction work for managing the progress of construction work at the contractor on the orderer side of the construction work, and includes a control unit and a storage unit. A progress rate calculation program to be executed by an information processing apparatus comprising: , a scheduled total amount that is the sum of the scheduled amounts for each period within the construction period, and an actual amount for each period that is the amount paid to the construction contractor according to the work performance of the construction for each of the plurality of periods. , and the actual total amount, which is the total amount of the actual amount for each period within the construction period, are linked and stored, and are changeable except for the fixed period for execution by the control unit. It is a scheduled amount for each period, and the scheduled progress rate at the end of the certain period is calculated based on the cumulative amount of the scheduled amount for each period at the end of the period included in the construction period and the total scheduled amount. The calculation process is performed until the scheduled progress rate at the end of the last period included in the construction period is calculated from the scheduled progress rate at the end of the first period included in the construction period. a step of calculating a progress rate; and a process of calculating an actual progress rate at the end of the given period based on the accumulated amount of actual results for each period and the total amount of actual results at the end of the given period. and a second progress rate calculating step, which is performed from the actual progress rate at the end of the first period to calculating the actual progress rate at the end of the last period. Characterized by

ADVANTAGE OF THE INVENTION According to this invention, it is effective in the ability to calculate the planned progress rate and the actual progress rate at the end of each of the plurality of periods included in the construction period.

FIG. 1 is a block diagram showing an example of the configuration of a progress rate calculation device. FIG. 2 is a diagram showing an example of specific contents of order data, project basic information data, supplier master, payee master, project type master, and cost classification master. FIG. 3 is a diagram showing an example of specific contents of an April performance inspection input screen and April purchase data and performance inspection data. FIG. 4 is a diagram showing an example of an acceptance inspection confirmation sheet for April. FIG. 5 is a diagram showing an example of specific contents of the May performance inspection input screen, May purchase data, and performance inspection data. FIG. 6 is a diagram showing an example of an acceptance inspection confirmation sheet for May. FIG. 7 is a diagram showing an example of specific contents of the June performance inspection input screen, June purchase data, and performance inspection data. FIG. 8 is a diagram showing an example of an acceptance inspection confirmation sheet for June. FIG. 9 is a diagram showing an example of specific contents of the performance inspection input screen for July and the purchase data and performance inspection data for July. FIG. 10 is a diagram showing an example of an acceptance inspection confirmation sheet for July. FIG. 11 is a diagram showing an example of calculation of the planned progress rate and the actual progress rate at the end of each month. FIG. 12 is a diagram showing an example of a payment schedule.

Embodiments of a progress rate calculation device, a progress rate calculation method, and a progress rate calculation program will be described in detail below with reference to the drawings. It should be noted that the present invention is not limited by this embodiment. Specific configurations and operations will be described below.

[1. composition]
An example of the configuration of the progress rate calculation device 100 according to this embodiment will be described with reference to FIG. FIG. 1 is a block diagram showing an example of the configuration of the progress rate calculation device 100. As shown in FIG. Specific configurations and operations will be described below.

The progress rate calculation device 100 is a commercially available desktop personal computer. Note that the progress rate calculation device 100 is not limited to a stationary information processing device such as a desktop personal computer, and may be a mobile device such as a commercially available notebook personal computer, PDA (Personal Digital Assistants), a smart phone, or a tablet personal computer. type information processing device.

The progress rate calculation device 100 includes a control unit 102 , a communication interface unit 104 , a storage unit 106 and an input/output interface unit 108 . Each unit included in the progress rate calculation device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 communicably connects the progress rate calculation 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 another device via a communication line. Here, the network 300 has a function of connecting the progress rate calculation device 100 and the server 200 so as to be able to communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). Data such as various masters described later may be stored in the server 200, for example.

An input device 112 and an output device 114 are connected to the input/output interface section 108 . The output device 114 can be a monitor (including a home television), a speaker, or a printer. The input device 112 can be a keyboard, a mouse, a microphone, or a monitor that realizes a pointing device function in cooperation with a mouse. Note that, hereinafter, 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 .

The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 stores a computer program for performing various processes by giving commands to a CPU (Central Processing Unit) in cooperation with an OS (Operating System). As 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.

The storage unit 106 includes, for example, order data 106a, project basic information data 106b, supplier master 106c, payee master 106d, project type master 106e, cost classification master 106f, purchase data 106g, It is provided with output inspection data 106h.

As shown in FIG. 2, the order data 106a includes, for example, order identification data (order number) for identifying an order for construction work, vendor identification data for identifying a vendor for construction work (supplier and Supplier name), construction identification data (project number and project name) for identifying each construction, construction type identification data (project type) for identifying the type of construction, and identifying the type of construction order amount Includes order amount type identification data (cost classification) and construction order amount (order amount) for construction.

The project basic information data 106b includes, for example, the construction identification data (project number and project name), etc., as shown in FIG.

The supplier master 106c includes, for example, the supplier identification data (supplier and supplier name), etc., as shown in FIG.

As shown in FIG. 2, the payee master 106d includes, for example, payee identification data (payee and payee name) for identifying the payee of the order amount for the construction work.

The project type master 106e includes, for example, the construction type identification data (project type code and project type name), etc., as shown in FIG.

The cost classification master 106f includes, for example, the order amount type identification data (cost classification code and cost classification name), etc., as shown in FIG.

The purchase data 106g includes, for example, purchase identification data (purchase number) for identifying purchase, the order identification data (order number), the vendor identification data (purchase supplier and supplier name), the construction identification data (project number and project name), the construction type identification data (project type), the order amount type identification data (cost classification), each period included in the construction period Actual amount for each period, which is the amount paid to the contractor according to the work performance of the construction (2018/4 purchase amount 800,000 yen, 2018/5 purchase amount 1,100,000 yen, 2018/6 purchase amount 1,000,000 yen yen and the purchase amount in July 2018 of 1,100,000 yen), the actual total amount that is the total amount of the actual amount for each period within the construction period (4,000,000 yen, which is the total amount of 800,000 yen, 1,100,000 yen, 1,000,000 yen, and 1,100,000 yen) yen) and consumption tax, etc. on the above actual amounts for each period.

The output inspection data 106h includes, as shown in FIG. date (start date), the end date (end date) of each of the plurality of periods, the scheduled amount for each period that is the amount scheduled to be paid to the contractor for each of the plurality of periods (scheduled amount for April 2018 1,000,000 yen, planned amount of 900,000 yen for May 2018, planned amount of 1,050,000 yen for June 2018, and 1,050,000 yen planned for July 2018), planned total amount (1,000,000 yen) 4,000,000 yen, which is the sum of yen, 900,000 yen, 1,050,000 yen, and 1,050,000 yen), actual amounts for each period (2018/4 purchase amount 800,000 yen, 2018/5 purchase amount 1,100,000 yen, 2018/6 purchase amount Purchase amount of 1,000,000 yen and purchase amount of 2018/7 of 1,100,000 yen), the total amount of the above actual results (4,000,000 yen, which is the total amount of 800,000 yen, 1,100,000 yen, 1,000,000 yen and 1,100,000 yen) and the actual amount for each period Including consumption tax, etc.

The following can be said from the contents explained in the two preceding paragraphs and the preceding paragraph. That is, the output inspection data 106h includes the period-based scheduled amount and the scheduled total amount, etc., while the purchase data 106g includes the period-based actual amount, the actual actual total amount, and the like. The information included in the output inspection data 106h and the information included in the purchase data 106g are linked through the order identification data (order number). Therefore, it can be said that the planned amount for each period, the planned total amount, the actual amount for each period, and the actual total amount are linked and stored in the storage unit 106 .

The control unit 102 is a CPU or the like that comprehensively controls the progress rate calculation device 100 . The control unit 102 has an internal memory for storing a control program such as an OS, a program defining various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Run.

Functionally, the control unit 102 can, for example, (1) determine the end point of the certain period based on the accumulated amount of the scheduled amount for each period and the scheduled total amount at the end point of the certain period included in the construction period. From the scheduled progress rate at the end of the first period included in the construction period to the scheduled progress rate at the end of the last period included in the construction period (2) the cumulative amount of actual results for each period and the total amount of actual results at the end of the certain period; The process of calculating the actual progress rate at the end of the certain period based on the actual progress rate at the end of the last period from the actual progress rate at the end of the first period and a second progress rate calculation unit 102b as second progress rate calculation means that performs until the progress rate is calculated. Details of the processing executed by each unit are described in [2. Specific example of processing].

[2. Specific example of processing]
Specific examples of processing according to the present embodiment will be described in detail below with reference to FIGS. 2 to 12. FIG. In this item, when the construction period of 2018/04/11 to 2018/08/10 was outsourced to the construction contractor ○○ Road, the period of 2018/04/11 to 2018/05/10 (4 2018/05/11 to 2018/06/10 (May) Scheduled progress rate and actual progress rate at the end of the period (May) Progress rate, planned progress rate and actual progress rate at the end of the period from 2018/06/11 to 2018/07/10 (June), and the period from 2018/07/11 to 2018/08/10 The following explanation assumes that the planned progress rate and the actual progress rate at the end of (July) are calculated.

As for the order of the explanation, first, the creation of the data necessary for calculating the progress rate (the purchase data 106g shown in FIG. 9 and the production acceptance inspection data 106h shown in FIG. 9) will be explained, and then the progress rate will be calculated. Calculations will be discussed, and finally, payment schedule creation will be discussed.

[2-1. Creation of purchase data 106g and production inspection data 106h]
The purchase data 106g shown in FIG. 9 and the output inspection data 106h shown in FIG. 9 are created through the processing from April to July. The processing for each month will be described below.

(1) Processing in April First, the contents of order data 106a, project basic information data 106b, supplier master 106c, payee master 106d, project type master 106e, and cost classification master 106f are registered as shown in FIG. be done.

Next, when the order number is entered on the <output inspection input screen> in FIG. ) is displayed on <Acceptance inspection input screen> in FIG.

Then, based on preset information as to how many periods are included in the construction period, the date, start date, and end date are automatically set and displayed on the output inspection input screen. For example, if the number of periods included in the construction period is "4", the construction period "2018/04/11 to 2018/08/10" is divided into 4 parts, and the display of <Acceptance inspection input screen> in Fig. 3 is displayed. As shown in area MA1, "year/month 2018/4 start date 2018/04/11 end date 2018/05/10" is displayed as the first period, and "year/month 2018/5 start date 2018/ 05/11 end date 2018/06/10" is displayed, and the next period is displayed as "year and month 2018/6 start date 2018/06/11 end date 2018/07/10", and the last period is displayed as " Date 2018/7 Start date 2018/07/11 End date 2018/08/10" is displayed.

As the estimated amount, the value obtained by dividing the order amount of "4,000,000 yen" into four is initially displayed on the output inspection input screen. That is, as shown in the display area MA1 of the <output inspection input screen> in FIG. 3, a planned amount of 1,000,000 yen is displayed for each month. The estimated amount can be revised.

The actual amount is entered by the operator. As shown in the display area MA1, "800,000 yen" is entered as the actual amount for April on the <output inspection input screen> in FIG.

After completing the input of the necessary information on the output inspection input screen, the operator can execute registration on the screen to create the purchase data 106g and the output inspection data 106h. The registration cannot be executed unless the total amount of the planned amount matches the order amount.

FIG. 3 shows the created purchase data 106g and output inspection data 106h. The purchase amount “800,000 yen” in the purchase data 106g in FIG. 3 and the purchase amount “800,000 yen” in the piecework acceptance inspection data 106h in FIG. It is information based on the yen. Also, the monthly scheduled amount in the output inspection data 106h in FIG. 3 is information based on the monthly scheduled amount displayed on the <output inspection input screen> in FIG.

Finally, based on the created performance inspection data 106h, etc., the performance inspection confirmation document (a document that certifies the details of the construction work up to the determination of the amount, and is used to exchange confirmation of the amount recorded monthly with the subcontractor. thing) is created. Fig. 4 shows the completed performance inspection confirmation sheet for April. The current inspection amount "800,000 yen" in the output inspection confirmation document in FIG. 4 is information based on the April purchase amount "800,000 yen" in the output inspection data 106h in FIG. Also, the cumulative amount "800,000 yen" in the volume inspection confirmation document in FIG. 4 is the cumulative amount of the April purchase amount "800,000 yen" in the volume inspection data 106h in FIG.

(2) Processing in May First, when the order number is entered on the <output inspection input screen> in FIG. The contents of the acceptance inspection data 106h are displayed on the <output inspection input screen> in FIG.

The estimated amount displayed on the <output inspection input screen> can be appropriately changed by the operator as necessary. However, it is not possible to change the planned amount of "1,000,000 yen" for April, which is the fixed month. In the display area MB1 of <Acceptance inspection input screen> in Fig. 5, the planned amount for May is changed from "1,000,000 yen" to "900,000 yen", and the planned amount for June is changed from "1,000,000 yen" to "1,050,000 yen". It has been changed, and the planned amount for July has been changed from "1,000,000 yen" to "1,050,000 yen".

The actual amount is entered by the operator. As shown in the display area MB1 in the <output inspection input screen> of FIG. 5, "1,100,000 yen" is entered as the actual amount for May.

After completing the input of the necessary information on the output inspection input screen, the purchase data 106g shown in FIG. 5 and the output inspection data 106h shown in FIG. A performance inspection confirmation is created. The cumulative amount of "1,900,000 yen" in the performance inspection confirmation document shown in Fig. 6 is the cumulative total of the purchase amount of April "800,000 yen" and the purchase amount of May "1,100,000 yen" in the performance inspection data 106h of Fig. 5. is.

(3) Processing in June First, when the order number is entered on the <output inspection input screen> in FIG. The contents of the acceptance inspection data 106h are displayed on the <output inspection input screen> in FIG.

The actual amount is entered by the operator. As shown in the display area MC1 of the <output inspection input screen> in FIG. 7, "1,000,000 yen" is entered as the actual amount for June.

After completing the input of the necessary information on the output inspection input screen, the purchase data 106g shown in FIG. 7 and the output inspection data 106h shown in FIG. A performance inspection confirmation is created. The cumulative amount of "2,900,000 yen" in the performance inspection confirmation document shown in Fig. 8 is the purchase amount of April "800,000 yen", the purchase amount of May "1,100,000 yen", and the purchase amount of June It is the cumulative amount with the purchase amount of "1,000,000 yen".

(4) Processing in July First, when the order number is entered on the <output inspection input screen> in FIG. The contents of the acceptance inspection data 106h are displayed on the <output inspection input screen> in FIG.

The actual amount is entered by the operator. As shown in the display area MD1 on the <output inspection input screen> in FIG. 9, "1,100,000 yen" is entered as the actual amount for July.

After completing the input of the necessary information on the output inspection input screen, the operator can execute registration on the screen to create the purchase data 106g and the output inspection data 106h. In July, which is the final month, the registration cannot be executed unless the total amount of the actual amounts matches the order amount.

Finally, based on the created performance inspection data 106h and the like, a performance inspection confirmation document is created. Figure 10 shows the completed performance inspection confirmation for July. The cumulative amount of "4,000,000 yen" in the performance inspection confirmation document shown in Fig. 10 corresponds to the purchase amount of April "800,000 yen", the purchase amount of May "1,100,000 yen", and the purchase amount of June in the performance inspection data 106h of Fig. 9 It is the accumulated amount of the purchase amount of "1,000,000 yen" and the purchase amount of July, "1,100,000 yen".

The purchase data 106g shown in FIG. 9 and the production inspection data 106h shown in FIG. 9 can be created by the procedures described in (1) to (4) above. It is possible to calculate the progress rate to be done.

[2-2. Calculation of progress rate]
In this section, first, the calculation of the planned progress rate will be explained, and then the calculation of the actual progress rate will be explained. The planned progress rate is the progress rate that indicates how far the construction is scheduled to progress at the end of a certain period included in the construction period with respect to the entire schedule. It is a progress rate that shows how much construction has progressed at the end of a certain period included in the construction period against actual results.

[2-2-1. Calculation of scheduled progress rate]
The first progress rate calculation unit 102a calculates the scheduled progress rate at the end of a certain period based on the cumulative amount of scheduled amounts for each period and the scheduled total amount at the end of a certain period included in the construction period. until the scheduled progress rate at the end of the last period included in the construction period is calculated from the scheduled progress rate at the end of the first period included in the construction period.

Specifically, since the construction period is divided into four periods from April to July, the first progress rate calculation unit 102a calculates the planned progress rate at the end of April , the planned progress rate at the end of June, and the planned progress rate at the end of July are calculated as follows.

(1) Planned progress rate at the end of April The planned amount for April is 1,000,000 yen, as shown in the inspection data 106h for the amount of work completed in FIG. Therefore, the cumulative total of the planned amount at the end of April will be 1,000,000 yen. Also, the total planned amount from April to July is 1,000,000 yen + 900,000 yen + 1,050,000 yen + 1,050,000 yen = 4,000,000 yen, as can be read from the performance inspection data 106h in Fig. 9 . For this reason, the first progress rate calculation unit 102a calculates the scheduled progress rate at the end of April as (accumulated amount of planned amount at the end of April/total planned amount from April to July × 100) = 1,000,000 yen ÷ 4,000,000 yen × 100 = 25%. The calculation result is shown in FIG. 11(A).

(2) Planned progress rate at the end of May The planned amount for May is 900,000 yen, as shown in the performance inspection data 106h in FIG. Therefore, the cumulative amount of the planned amount at the end of May is 1,900,000 yen, which is the sum of the planned amount of 1,000,000 yen for April and the planned amount of 900,000 yen for May. Also, the total planned amount from April to July is 4,000,000 yen, as explained in (1). For this reason, the first progress rate calculation unit 102a calculates the planned progress rate at the end of May as (accumulated amount of planned amount at the end of May/total planned amount from April to July × 100) = 1,900,000 yen ÷ 4,000,000 yen × 100 = 47% (rounded down after the decimal point). The calculation result is shown in FIG. 11(B).

(3) Planned progress rate at the end of June The planned amount for June is 1,050,000 yen, as shown in the performance inspection data 106h in FIG. Therefore, the cumulative amount of the planned amount at the end of June is 2,950,000 yen, which is the planned amount of 1,000,000 yen for April, the planned amount of 900,000 yen for May, and the planned amount of 1,050,000 yen for June. . Also, the total planned amount from April to July is 4,000,000 yen, as explained in (1). For this reason, the first progress rate calculation unit 102a calculates the scheduled progress rate at the end of June as (accumulated amount of planned amount at the end of June/total planned amount from April to July × 100) = 2,950,000 yen ÷ 4,000,000 yen × 100 = 73% (rounded down after the decimal point). The calculation result is shown in FIG. 11(C).

(4) Planned progress rate at the end of July The planned amount for July is 1,050,000 yen, as shown in the inspection data 106h of the amount of work completed in FIG. For this reason, the cumulative amount of the planned amount at the end of July is 1,000,000 yen for April, 900,000 yen for May, 1,050,000 yen for June, and 1,050,000 yen for July. It is 4,000,000 yen by adding the yen. Also, the total planned amount from April to July is 4,000,000 yen, as explained in (1). For this reason, the first progress rate calculation unit 102a calculates the scheduled progress rate at the end of July as (accumulated amount of scheduled amount at the end of July/total amount of scheduled amount from April to July × 100) = 4,000,000 yen ÷ 4,000,000 yen × 100 = 100%. The calculation result is shown in (D) of FIG.

[2-2-2. Calculation of actual progress rate]
The second progress rate calculation unit 102b calculates the actual progress rate at the end of a certain period based on the cumulative amount of actual results for each period and the total amount of actual results at the end of a certain period included in the construction period. until the actual progress rate at the end of the last period included in the construction period is calculated from the actual progress rate at the end of the first period included in the construction period.

Specifically, since the construction period is divided into four periods from April to July, the second progress rate calculation unit 102b calculates the actual progress rate at the end of April , the actual progress rate at the end of June, and the actual progress rate at the end of July are calculated as follows.

(1) Actual progress rate at the end of April The actual amount of purchase for April is 800,000 yen, as shown in the purchase data 106g of FIG. Therefore, the cumulative amount of actual results at the end of April is 800,000 yen. Also, the total amount of actual sales from April to July is 800,000 yen + 1,100,000 yen + 1,000,000 yen + 1,100,000 yen = 4,000,000 yen, as can be read from the purchase data 106g in Fig. 9 . For this reason, the second progress rate calculation unit 102b calculates the actual progress rate at the end of April as (accumulated amount of actual amounts at the end of April / total amount of actual amounts from April to July x 100) = 800,000 yen ÷ 4,000,000 yen x 100 = 20%. The calculation result is shown in (E) of FIG.

(2) Actual progress rate at the end of May The actual amount for May is a purchase amount of 1,100,000 yen, as shown in the purchase data 106g of FIG. Therefore, the cumulative amount of actual results at the end of May is 1,900,000 yen, which is the sum of the actual amount of 800,000 yen for April and the actual amount of 1,100,000 yen for May. Also, the total amount of the actual amount from April to July is 4,000,000 yen as explained in (1). For this reason, the second progress rate calculation unit 102b calculates the actual progress rate at the end of May as (accumulated amount of actual amounts at the end of May / total amount of actual amounts from April to July × 100) = 1,900,000 yen ÷ 4,000,000 yen × 100 = 47% (rounded down after the decimal point). The calculation result is shown in (F) of FIG.

(3) Actual progress rate at the end of June The actual amount for June is a purchase amount of 1,000,000 yen, as shown in purchase data 106g in FIG. Therefore, the cumulative amount of actual results at the end of June is 2,900,000 yen, which is the sum of the actual amount of 800,000 yen for April, the actual amount of 1,100,000 yen for May, and the actual amount of 1,000,000 yen for June. . Also, the total amount of the actual amount from April to July is 4,000,000 yen as explained in (1). For this reason, the second progress rate calculation unit 102b calculates the actual progress rate at the end of June as (accumulated amount of actual amounts at the end of June / total amount of actual amounts from April to July × 100) = 2,900,000 yen ÷ 4,000,000 yen × 100 = 72% (rounded down after the decimal point). The calculation result is shown in FIG. 11(G).

(4) Actual progress rate at the end of July The actual amount for July is a purchase amount of 1,100,000 yen, as shown in the purchase data 106g of FIG. For this reason, the cumulative amount of actual results at the end of July is 800,000 yen for April, 1,100,000 yen for May, 1,000,000 yen for June, and 1,100,000 yen for July. It is 4,000,000 yen by adding the yen. Also, the total amount of the actual amount from April to July is 4,000,000 yen as explained in (1). For this reason, the second progress rate calculation unit 102b calculates the actual progress rate at the end of July as (accumulated amount of actual amounts at the end of July / total amount of actual amounts from April to July × 100) = 4,000,000 yen ÷ 4,000,000 yen × 100 = 100%. The calculation result is shown in (H) of FIG.

[2-2-3. summary]
As described above in [2-2-1] and [2-2-2], according to the present embodiment, for example, the planned progress rate and the actual progress rate are calculated and displayed. By doing so, the operator can grasp the discrepancy between the schedule and the actual results, and can analyze work delays and the like. Further, according to the present embodiment, for example, as shown in FIG. It is also possible to check for input omissions and the like.

Further, according to this embodiment, for example, the planned amount and the actual amount for each project can be displayed. For example, ○○ road and ○○ facility are involved in the project with the project number "TYO001", the planned amount for ○○ road in April 2018 is 1,000,000 yen, and the planned amount for ○○ facility in April 2018 is 800,000 yen. In the case of yen, as shown in (I) of FIG. 11, the planned amount for April 2018 for the project can be calculated and displayed as 1,000,000 yen + 800,000 yen = 1,800,000 yen. In addition, if the actual amount of ○○ road in April 2018 is 800,000 yen and the actual amount of ○○ facility in April 2018 is 800,000 yen, as shown in (J) of FIG. The actual amount for 2018/4 can be calculated and displayed as 800,000 yen + 800,000 yen = 1,600,000 yen.

[2-3. Create payment schedule]
In this section, a payment schedule that can be created using the purchase data 106g shown in FIG. 9 created in [2-1] and the performance inspection data 106h shown in FIG. 9 will be described.

For example, when considering the end of April (2018/04/11 to 2018/05/10) as the standard, the amount paid in May is the actual amount of 800,000 yen for that April (Purchase data 106g in Figure 9 The purchase amount for April is 800,000 yen). The 800,000 yen is shown as the payment schedule for May 2018 for ○○ road in the payment schedule in FIG. In this way, when there is purchase data for the corresponding month to be paid, the purchase amount is output from the purchase data 106g of FIG. 9 as having been purchased.

On the other hand, for example, considering the end of April (2018/04/11-2018/05/10) as the standard, the amount to be paid in June, May (2018/05/11-2018/ 06/10) does not yet exist. In this case, the amount to be paid in June will be the initial scheduled amount for May (2018/05/11 to 2018/06/10) (scheduled amount for May in the performance inspection data 106h in Figure 3: 1,000,000 yen) Become. The 1,000,000 yen is shown as the payment schedule for XX Road in June 2018 in the payment schedule in FIG. In this way, when there is no purchase data for the corresponding month for which the payment schedule is to be made, the planned amount is output from the quantity acceptance inspection data 106h as the purchase schedule.

Although detailed explanations are omitted, the scheduled payment of 800,000 yen for May 2018 and the scheduled payment of 1,100,000 yen for June 2018 for ○○ equipment are also shown in the payment schedule in Fig. 12. .

[2-4. summary]
As described above in [2-1] to [2-3], according to the progress rate calculation device 100 according to the present embodiment, the planned progress rate at each end point of a plurality of periods included in the construction period and the actual progress rate can be calculated.

Moreover, when the main point in this embodiment is put together, it will become as follows, for example. In the construction industry, etc., the total amount of work is determined at the start of the outsourced work, but basically this amount is paid to the contractor each month according to the progress of the work. Therefore, in the present embodiment, for example, by making a monthly schedule for the total amount of construction work and recording purchases, the discrepancy between the schedule and the actual result, the planned progress and the actual progress can be calculated. This has made it possible to analyze work delays, etc. In addition, since the progress rate can be used to create monthly payment schedules, it has become easier to manage cash flow. Conventionally, it was possible to check only the cumulative purchase amount for the total construction cost. By storing the planned amount and actual amount for each month in the data, it became possible to see the planned amount and actual amount for each month.

A summary of the functions of this embodiment is as follows (1) to (6), for example.
(1) Register the total order amount to be ordered to the supplier in order input. The registration data is updated with the order data.
(2) Register the planned amount for each month within the construction period for the total order amount registered in the order entry.
(3) Create purchase data for the current month by inputting actual amounts for the current month.
(4) The total purchase amount will not exceed the order amount.
(5) If the planned amount needs to be changed, it can be revised.
(6) Confirmation of the amount posted each month is exchanged with the subcontractor with the confirmation of the performance inspection.

[3. Other embodiments]
The present invention may be implemented in various different embodiments other than the embodiments described above within the scope of the technical idea described in the claims.

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

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

Also, with respect to the progress rate calculation device 100, each illustrated component is functionally conceptual, and does not necessarily need to be physically configured as illustrated.

For example, the processing functions of the progress rate calculation device 100, particularly the processing functions performed by the control unit, may be implemented in whole or in part by a CPU and a program interpreted and executed by the CPU. Alternatively, it may be implemented as hardware using wired logic. The program is recorded on a non-temporary computer-readable recording medium containing programmed instructions for causing the information processing apparatus to execute the processing described in this embodiment, and the progress rate is calculated as necessary. It is read mechanically by the device 100 . That is, a storage unit such as a ROM or HDD (Hard Disk Drive) stores a computer program for giving commands to the CPU in cooperation with the OS to perform various processes. This computer program is executed by being loaded into the RAM and constitutes a control section in cooperation with the CPU.

In addition, this computer program may be stored in an application program server connected to the progress rate calculation device 100 via any network, and it is possible to download all or part of it as necessary. is.

Also, the program for executing the processing described in this embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the term "recording medium" refers to memory cards, USB (Universal Serial Bus) memories, SD (Secure Digital) cards, flexible disks, magneto-optical disks, ROMs, EPROMs (Erasable Programmable Read Only Memory), EEPROMs (registered (trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVD (Digital Versatile Disk), and Disc (registered trademark) such as Blu- shall include any "portable physical medium".

A "program" is a data processing method written in any language or writing method, regardless of the format such as source code or binary code. In addition, the "program" is not necessarily limited to a single configuration, but is distributed as multiple modules or libraries, or cooperates with a separate program represented by the OS to achieve its function. Including things. It should be noted that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading the recording medium in each device shown in the embodiments, the installation procedure after reading, and the like.

The various databases stored in the storage unit are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks. It stores programs, tables, databases, files for web pages, and so on.

Further, the progress rate calculation device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which any peripheral device is connected. Further, the progress rate calculation device 100 may be implemented by installing software (including programs, data, or the like) that causes the device to implement the processing described in the present embodiment.

Furthermore, the specific forms of distribution and integration of devices are not limited to those shown in the figures, and all or part of them can be functionally or physically arranged in arbitrary units according to various additions or functional loads. It can be distributed and integrated. In other words, the embodiments described above may be arbitrarily combined and implemented, or the embodiments may be implemented selectively.

INDUSTRIAL APPLICABILITY The present invention is useful, for example, in the construction industry and the like.

100 progress rate calculation device 102 control unit
102a first progress rate calculator
102b second progress rate calculation unit 104 communication interface unit 106 storage unit
106a Order data
106b Project basic information data
106c Supplier Master
106d Payee master
106e Project type master
106f Cost classification master
106g Purchase data
106h Performance inspection data 108 Input/output interface unit 112 Input device 114 Output device 200 Server 300 Network

Claims (3)

A progress rate calculation device for calculating the progress rate of construction work for managing the progress of construction work at the contractor on the ordering side of the construction work, the device comprising a control unit and a storage unit,
The storage unit contains
A scheduled amount for each period that is the amount to be paid to the construction contractor for each of the multiple periods included in the construction period, a scheduled total amount that is the sum of the scheduled amounts for each period within the construction period, and the plurality of Actual amount for each period, which is the amount paid to the construction contractor according to the work performance of construction for each period, and Actual total amount, which is the total amount of the actual amount for each period within the construction period,
is stored in association with
The control unit
It is the scheduled amount for each period that can be changed except for the fixed period, and is based on the cumulative amount of the scheduled amount for each period at the end of the certain period included in the construction period and the scheduled total amount. The process of calculating the scheduled progress rate at the end of the above is calculated from the scheduled progress rate at the end of the first period included in the construction period to the progress rate at the end of the last period included in the construction period. a first progress rate calculation means that performs until the scheduled progress rate is calculated;
The process of calculating the actual progress rate at the end of the certain period based on the cumulative amount of actual results for each period and the total amount of actual results at the end of the certain period is performed at the end of the first period. second progress rate calculation means for calculating the actual progress rate at the end of the last period from the actual progress rate at the point in time;
to provide
A progress rate calculation device characterized by: A progress rate calculation device for calculating the progress rate of construction work for managing the progress of construction work at the contractor on the ordering side of the work, the progress rate calculation being executed by an information processing device having a control unit and a storage unit. a method,
The storage unit contains
A scheduled amount for each period that is the amount to be paid to the construction contractor for each of the multiple periods included in the construction period, a scheduled total amount that is the sum of the scheduled amounts for each period within the construction period, and the plurality of Actual amount for each period, which is the amount paid to the construction contractor according to the work performance of construction for each period, and Actual total amount, which is the total amount of the actual amount for each period within the construction period,
is stored in association with
executed by the control unit;
It is the scheduled amount for each period that can be changed except for the fixed period, and is based on the cumulative amount of the scheduled amount for each period at the end of the certain period included in the construction period and the scheduled total amount. The process of calculating the scheduled progress rate at the end of the above is calculated from the scheduled progress rate at the end of the first period included in the construction period to the progress rate at the end of the last period included in the construction period. a first progress rate calculation step performed until the scheduled progress rate is calculated;
The process of calculating the actual progress rate at the end of the certain period based on the cumulative amount of actual results for each period and the total amount of actual results at the end of the certain period is performed at the end of the first period. a second progress rate calculation step of calculating the actual progress rate at the end of the last period from the actual progress rate at the point in time;
including
A progress rate calculation method characterized by: A progress rate calculation device for calculating a progress rate of construction work for managing the progress of construction work at the ordering party on the ordering side of the construction work, the progress rate calculation device for causing an information processing device having a control unit and a storage unit to execute the progress rate. A calculation program,
The storage unit contains
A scheduled amount for each period that is the amount to be paid to the construction contractor for each of the multiple periods included in the construction period, a scheduled total amount that is the sum of the scheduled amounts for each period within the construction period, and the plurality of Actual amount for each period, which is the amount paid to the construction contractor according to the work performance of construction for each period, and Actual total amount, which is the total amount of the actual amount for each period within the construction period,
is stored in association with
for causing the control unit to execute
It is the scheduled amount for each period that can be changed except for the fixed period, and is based on the cumulative amount of the scheduled amount for each period at the end of the certain period included in the construction period and the scheduled total amount. The process of calculating the scheduled progress rate at the end of the above is calculated from the scheduled progress rate at the end of the first period included in the construction period to the progress rate at the end of the last period included in the construction period. a first progress rate calculation step performed until the scheduled progress rate is calculated;
The process of calculating the actual progress rate at the end of the certain period based on the cumulative amount of actual results for each period and the total amount of actual results at the end of the certain period is performed at the end of the first period. a second progress rate calculation step of calculating the actual progress rate at the end of the last period from the actual progress rate at the point in time;
including
A progress rate calculation program characterized by

Images