Progress management device, progress management method, and progress management program
The progress management device objectively assesses construction project progress and financial status by integrating cost and volume-based figures, addressing inaccuracies in existing systems and enabling timely corrective actions.
Patent Information
- Application Number
- JP2025108328
- Authority / Receiving Office
- JP · JP
- Patent Type
- Applications
- Current Assignee / Owner
- Priority Date
- 2021-01-29
- Filing Date
- 2025-06-26
- Publication Date
- 2025-08-28
AI Technical Summary
Existing progress management systems fail to provide an objective understanding of construction work progress and the balance between income and expenditure, as they either rely solely on cost-proportional figures, which inaccurately represent income and expenditure, or solely on volume-based figures, which neglect cost considerations.
A progress management device and method that combines cost-proportional and volume-based figures to objectively assess project progress and income/expenditure status by comparing actual and predicted values, using a control unit to create and compare cost and production volume figures.
Enables accurate and objective assessment of project progress and income/expenditure status, identifying deviations from planned schedules and financial outcomes, facilitating timely corrective actions.
Smart Images

Figure 2025126295000001_ABST
Abstract
Description
[Technical Field]
[0001] The present invention relates to a progress management device, a progress management method, and a progress management program. [Background technology]
[0002] For example, in the past, when managing the progress of construction work, on-site employees would judge each situation based on figures based on the rate of completion, while accounting and management would grasp the progress of construction work and the income and expenditure situation based on figures proportional to cost. For example, Patent Document 1 is an example of a conventional system for progress management. [Prior art documents] [Patent documents]
[0003] [Patent Document 1] Japanese Patent Application Laid-Open No. 2017-174241 Summary of the Invention [Problem to be solved by the invention]
[0004] However, Patent Document 1 does not describe anything about objectively grasping the progress of construction work and the balance of construction work.
[0005] The present invention has been made in consideration of the above, and aims to provide a progress management device, a progress management method, and a progress management program that enable objective understanding of the progress and income / expense status of a project. [Means for solving the problem]
[0006] In order to solve the above-mentioned problems and achieve the object, the present invention is characterized in that the control unit comprises a cost processing means for creating a cost-proportional based figure when a project is accepted, a production volume processing means for creating a production volume based figure when the project is accepted, and a comparison means for comparing the cost-proportional based figure with the production volume based figure to grasp the progress and income / expense situation of the accepted project.
[0007] According to one aspect of the present invention, the cost-proportional figures may include actual costs and actual revenues on a cost-proportional basis, and the volume-based figures may include forecasted volume and actual volume on a volume-based basis.
[0008] According to one aspect of the present invention, the comparison means may determine the progress of the construction work by comparing the predicted progress with the actual progress, and if the predicted progress - the actual progress is less than 0, determine that the project is progressing ahead of schedule, if the predicted progress - the actual progress = 0, determine that the project is progressing at the scheduled pace, and if the predicted progress - the actual progress > 0, determine that the project is behind schedule.
[0009] According to one aspect of the present invention, the comparison means may determine the balance of payments by comparing the actual revenue with the actual turnover, and if actual revenue - actual turnover < 0, determine that the balance of payments has improved, if actual revenue - actual turnover = 0, determine that the balance of payments is as planned, and if actual revenue - actual turnover > 0, determine that the balance of payments has worsened.
[0010] According to another aspect of the present invention, the project may include a construction project.
[0011] In addition, in order to solve the above-mentioned problems and achieve the object, the present invention is a progress management method executed by an information processing device equipped with a control unit, characterized in that it includes a cost processing process executed by the control unit to create a cost-proportional based figure when a project is accepted, a production volume processing process to create a production volume based figure when the project is accepted, and a comparison process to compare the cost-proportional based figure with the production volume based figure to grasp the progress status and income / expense situation of the accepted project.
[0012] In addition, in order to solve the above-mentioned problems and achieve the object, the present invention is a progress management program to be executed by an information processing device equipped with a control unit, characterized in that the control unit executes a cost processing process that creates a cost-proportional figure when a project is accepted, a production volume processing process that creates a production volume-based figure when the project is accepted, and a comparison process that compares the cost-proportional figure with the production volume-based figure to grasp the progress and income / expense situation of the accepted project. [Effects of the Invention]
[0013] The present invention has the effect of making it possible to objectively grasp the progress and income / expenditure status of a project. [Brief explanation of the drawings]
[0014] [Figure 1] Figure 1 is a diagram to explain the issues that arise when only figures based on a cost-proportional basis are used. [Figure 2] Figure 2 is a diagram for explaining the problems that arise when only volume-based figures are used. [Figure 3] FIG. 3 is a diagram for explaining the improvement method of the present invention. [Figure 4] FIG. 4 is a block diagram showing an example of the configuration of the progress management device according to the present embodiment. [Figure 5] FIG. 5 is a flowchart illustrating an outline of the overall processing of the control unit of the progress management device according to the present embodiment. [Figure 6] FIG. 6 is a diagram for explaining a specific example of the processing of the control unit of the progress management device according to the present embodiment. [Figure 7] FIG. 7 is a diagram for explaining a specific example of the processing of the control unit of the progress management device according to the present embodiment. [Figure 8] FIG. 8 is a diagram for explaining a specific example of the processing of the control unit of the progress management device according to the present embodiment. [Figure 9]FIG. 9 is a diagram for explaining a specific example of the processing of the control unit of the progress management device according to the present embodiment. [Figure 10] FIG. 10 is a diagram for explaining a specific example of the processing of the control unit of the progress management device according to the present embodiment. DETAILED DESCRIPTION OF THE INVENTION
[0015] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described in detail with reference to the accompanying drawings. However, the present invention is not limited to this embodiment.
[0016] [1. Overview] For example, in the construction industry, where it typically takes several years to complete a single project, progress management and revenue forecasting are challenges for many companies. In the construction industry, revenue forecasts and progress management are carried out using the cost-to-sales method, but since sales increase when costs are incurred even if work progress is not progressing, it can be difficult to make accurate judgments depending on the cost-to-sales situation. Another method other than the cost-to-sales method is to use completed volume, but while it can accurately grasp the progress status, it is difficult to grasp whether the income and expenditure is deteriorating.
[0017] In other words, in the past, on-site employees judged each situation based on figures based on the completion rate, while accounting and management understood the progress of construction and the income and expenditure situation based on figures proportional to cost. However, while the completion rate is suitable for understanding the progress of construction, it is inappropriate for understanding the income and expenditure situation, and the cost proportional method sometimes does not accurately represent the current situation in terms of progress and income and expenditure.
[0018] Therefore, in this embodiment, by comparing figures based on the amount of work completed with figures based on a cost-proportional basis for construction projects and other such projects, it is possible to objectively, accurately, and easily grasp the progress and income / expense situation of the project.
[0019] The background and problems of the present invention will be explained in detail with reference to Figures 1 and 2. With reference to Figure 1, the problems that arise when only cost-proportional figures are used will be explained. Figure 1 is a diagram for explaining the problems that arise when only cost-proportional figures are used. Figure 1(A) is a diagram showing an example of a cost-proportional budget consumption forecast "A". Figure 1(B) is a diagram showing an example of actual costs and actual revenues [B]. In the following explanation, all monetary units are in thousands of yen, and their description will be omitted.
[0020] In the following explanation, an example will be given in which the contract amount is "100,000" and the budget amount is "80,000".
[0021] In Figure 1(A), when using cost proportional accounting, the forecast value is calculated based on the forecast of the budget consumption rate (progress rate). The example shown in Figure 1(A) shows the consumption rate, consumption amount, and forecast revenue (= contract amount x total consumption amount for the target Q / total budget amount) for 1Q to 4Q, with cost elements being material costs, subcontract costs, labor costs, and expenses.
[0022] For example, the projected revenue for the first quarter is the contract amount of 100,000 x the total amount spent in the first quarter of 25,000 ÷ the total budget of 80,000 = 31,250.
[0023] Figure 1(B) shows an example of actual costs and actual revenues [B] for the budget consumption forecast based on cost proportion in Figure 1(A). In Figure 1(B), the difference from the forecast is that the forecast for 1Q of outsourcing expenses is a consumption rate of 20%, a consumption amount of 4,000, and a revenue forecast for 1Q of 31,250, while the actual outsourcing expenses for 1Q are a consumption rate of 25%, a consumption amount of 5,000, and actual revenue for 1Q of 32,250 (= contract amount of 100,000 x total consumption amount for 1Q of 25,000 / total budget of 80,000).
[0024] Additionally, while the forecast for outsourcing expenses in the 4th quarter is a consumption rate of 20%, a consumption amount of 4,000, and a revenue forecast for the 4th quarter of 16,250, the actual outsourcing expenses in the 4th quarter are a consumption rate of 15%, a consumption amount of 3,000, and a revenue forecast for the 4th quarter of 15,000.
[0025] Looking at first-half revenue up to the second quarter, the actual result of 53,750 was higher than the initial forecast of 52,500, so at first glance it appears to be going well. However, material costs were only recorded as costs at the time the materials were delivered to the materials storage area on-site (1st and 3rd quarters), and do not reflect whether the work itself is progressing smoothly. In addition, outsourcing costs were higher than initially planned, and it is not possible to determine whether this is due to work being brought forward, such as by starting work earlier, or whether work progress has been delayed and additional outsourcing personnel have been added.
[0026] The issues that arise when only volume-based figures are used will be explained with reference to Figure 2. Figure 2 is a diagram for explaining the issues that arise when only volume-based figures are used. Figure 2(A) shows volume-based forecast [C], and Figure 2(B) shows volume-based actual results [D].
[0027] The example shown in Figure 2(A) shows the contract details, number of contracts, unit price, and amount, as well as the volume and amount of work completed for Q1 to Q4. Figure 2(B) shows an example of the actual results [D] for the volume-based forecast in Figure 2(A).
[0028] In Figure 2(B), the differences from the forecast are that for the contract details (steel pipe piles φ600 t=9-10 L=6.5-13m), the forecast for 1Q was number of units "25" and amount of units "25,000", while the actual results for 1Q were number of units "26" and amount of units "26,000", and also the forecast for 4Q was number of units "21" and amount of units "21,000", while the actual results for 4Q were number of units "20" and amount of units "20,000".
[0029] Looking at first-half revenues up to the second quarter, the actual result of 53,500 is higher than the initial forecast of 52,500, so at first glance it appears to be going well. However, because the occurrence of costs is not taken into account at all, it is impossible to determine whether the income and expenditure is progressing as planned or has deteriorated. In the cost-proportional revenue forecast in (1), first-half revenues up to the second quarter are 53,750, but on a volume basis it is 53,500, which means that the income and expenditure for the first half has deteriorated slightly.
[0030] In this way, while a volume-of-production basis is suitable for understanding the progress of construction work, it is inappropriate for understanding the income and expenditure situation, and a cost-proportional basis does not accurately represent the current situation in terms of both progress and income and expenditure.
[0031] Figure 3 is a diagram for explaining the improvement method of the present invention. In this invention, by calculating KPIs that combine the numerical values of the actual cost and actual revenue [B] based on the cost ratio, the forecasted progress [C] based on the progress, and the actual progress [D] based on the progress, for each construction project, it is possible to objectively grasp the progress status and the income and expenditure situation. The following describes the 2Q forecast as an example.
[0032] (1) The progress of the construction work is judged by comparing the total amount of the forecasted progress [C] and the actual progress [D] based on the progress made.
[0033] i) If [C] - [D] < 0, the actual progress is greater than the forecast progress, so it is determined that the construction is progressing ahead of schedule.
[0034] ii) If [C]-[D]=0, the forecasted volume and actual volume are the same, so it is determined that the project is progressing at the planned pace.
[0035] iii) If [C] - [D] > 0, the actual progress is less than the forecasted progress, so it is determined that there is a delay in the progress of the construction work.
[0036] (2) The income and expenditure forecast is determined by comparing the total amount of actual revenue [B] based on a cost-proportional basis and actual volume [D] based on volume.
[0037] i) If [B] - [D] < 0, it is judged that the income and expenditure has improved because less costs have been incurred than planned and more output has been produced.
[0038] ii) If [B] - [D] = 0, the increase in output is just enough to cover the costs incurred, so it is determined that the income and expenditure situation is as planned.
[0039] iii) If [B] - [D] > 0, it is determined that the income and expenditure has deteriorated because costs are higher than expected compared to the volume of work.
[0040] For each indicator, the larger the difference, the greater the deviation from the initial plan, and this is also effective in identifying projects that require early action.
[0041] The progress management device of the present invention can be applied not only to the construction industry but also to IT vendors and the like who carry out scratch development.
[0042] [2. Configuration] An example of the configuration of the progress management device according to this embodiment will be described with reference to Fig. 4. Fig. 4 is a block diagram showing an example of the configuration of the progress management device according to this embodiment.
[0043] The progress management device 100 is a commercially available desktop personal computer. Note that the progress management device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may also be a portable information processing device such as a commercially available notebook personal computer, a PDA (Personal Digital Assistant), a smartphone, or a tablet personal computer.
[0044] The progress management device 100 comprises a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. The units comprised in the progress management device 100 are connected to each other so as to be able to communicate with each other via any communication path.
[0045] The communication interface unit 104 communicably connects the progress management device 100 to a network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via the communication line. Here, the network 300 has a function of connecting the progress management device 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network).
[0046] An input device 112 and an output device 114 are connected to the input / output interface unit 108. The output device 114 may be a monitor (including a home television), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that functions as a pointing device in cooperation with a mouse. In the following, the output device 114 may be referred to as the monitor 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.
[0047] The storage unit 106 stores various databases, tables, files, etc. The storage unit 106 stores computer programs that work in conjunction with the OS (Operating System) to issue commands to the CPU (Central Processing Unit) to perform various processes. The storage unit 106 can be, for example, a memory device such as RAM (Random Access Memory) or ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, or an optical disk. The storage unit 106 also includes a data file 106a and a cost element master 106b.
[0048] The data file 106a is a file for storing various data such as order data, budget data, quarterly budget data, cost-proportional budget consumption forecast data, forecasted volume data (forecasted volume header data, forecasted volume detail data), volume-based forecasts, cost aggregation data, actual costs and revenues, actual volume data, and volume-based actuals.
[0049] The order data may include the construction number and contract amount. The budget data may include the construction number, cost element CD, and budget amount. The quarterly budget data may include the construction number, cost element CD, fiscal year, quarter, and progress rate.
[0050] The cost-proportional budget consumption forecast may include cost elements, budget amounts, progress rates for each quarter (1Q to 4Q), and consumption amounts.
[0051] The forecasted progress data may be composed of forecasted progress header data and forecasted progress detail data. The forecasted progress header data may include data on the construction project number, SEQ, contract details, number of contracts, unit price, and amount. The forecasted progress detail data may include data on the construction project number, SEQ, fiscal year, quarter, and number of completed projects.
[0052] The volume-based forecast may include the contract details, the number of contracts, the unit price, the amount, the number of contracts and the amount of contracts for each quarter (1Q to 4Q).
[0053] The cost summary data may include data on the construction number, cost element CD, accounting year and month, cost element code, and incurred amount.
[0054] The actual cost and actual revenue may include the cost elements for each quarter (1Q to 4Q), the budget amount, the progress rate for each quarter (1Q to 4Q), the consumed amount, and the revenue amount.
[0055] The progress data may include the construction number, SEQ, fiscal year, quarter, and progress amount. The progress-based results may include the contract details, number of contracts, unit price, amount, progress amount and progress amount for each quarter (1Q to 4Q).
[0056] The cost element master 106b can be configured as a table in which cost elements CD and cost element names are associated and registered (see FIG. 7). The cost element master 106b is referenced when converting between cost elements CD and cost element names.
[0057] The control unit 102 is a CPU or the like that performs overall control of the progress management device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, etc., and executes various information processing operations based on these stored programs. Functionally, the control unit 102 conceptually includes an order registration unit 102a, a cost processing unit 102b, a production amount processing unit 102c, a comparison unit 102d, and a screen display control unit 102e.
[0058] When an order is received, the order registration unit 102a inputs order data in response to an operator's operation on an order registration screen (not shown) displayed on the monitor 114, and registers the data in the data file 106a.
[0059] The cost processing section 102b creates a cost-proportional basis numerical value for the case that is the subject of the order data, for example, in response to an operator's operation on a cost registration screen (not shown) displayed on the monitor 114, and registers the value in the data file 106a. The cost-proportional basis numerical value may include actual costs and actual revenues on a cost-proportional basis.
[0060] The production volume processing unit 102c creates production volume-based numerical values for the job that is the subject of the order data, for example, in response to an operator's operation on a production volume registration screen (not shown) displayed on the monitor 114, and registers the numerical values in the data file 106a. The production volume-based numerical values may include production volume-based forecast production volumes and actual production volumes.
[0061] The comparison unit 102d compares the cost-proportional figures with the volume-based figures for the target project in response to, for example, an operator's operation on a comparison screen (not shown) displayed on the monitor 114, and displays and outputs the results of the judgment on the progress status and income / expense situation.
[0062] Specifically, the comparison unit 102d compares the predicted output with the actual output to determine the progress, and if predicted output - actual output < 0, determines that the project is progressing ahead of schedule, if predicted output - actual output = 0, determines that the project is progressing at the scheduled pace, and if predicted output - actual output > 0, determines that the project is behind schedule, and may display and output this information.
[0063] The comparison unit 102d may compare the actual revenue and actual turnover for the income / expense forecast, and if actual revenue - actual turnover < 0, determine that the income / expense situation has improved, if actual revenue - actual turnover = 0, determine that the income / expense situation is as planned, and if actual revenue - actual turnover > 0, determine that the income / expense situation has worsened, and display a message to that effect.
[0064] The screen display control unit 102e controls the display of various screens (for example, an order registration screen, a cost registration screen, a production volume registration screen, a comparison screen, etc.) displayed on the monitor 114 and the inputs thereto.
[0065] [3. Specific Examples] A specific example of the processing of the progress management device 100 in this embodiment will be described with reference to Figures 4 to 10. First, an outline of the overall processing of the progress management device 100 in this embodiment will be described with reference to Figure 5. Figure 5 is a diagram showing a flow for explaining an outline of the overall processing of the progress management device 100 in this embodiment.
[0066] 5, the order registration unit 102a executes an order registration process (step S1). Specifically, in the order registration process, when an order is received, the order registration unit 102a inputs order data in response to an operation by an operator on an order registration screen (not shown) displayed on the monitor 114, and registers the data in the data file 106a.
[0067] The cost processing section 102b executes a budget registration process (step S2). Specifically, in the budget registration process, the cost processing section 102b inputs budget data, quarterly budget data, and a cost-proportional budget consumption forecast for the case that is the subject of the order data in response to, for example, an operator's operation on a cost registration screen (not shown) displayed on the monitor 114, and registers the data in the data file 106a.
[0068] The production volume processing unit 102c executes production volume forecast registration processing (step S3). Specifically, in the production volume forecast registration processing, the production volume processing unit 102c inputs forecast production volume header data, forecast production volume detail data, and production volume-based forecast for the job that is the subject of the order data in response to, for example, an operator's operation on a production volume registration screen (not shown) displayed on the monitor 114, and registers them in the data file 106a.
[0069] The cost processing section 102b executes the construction execution process (step S4). Specifically, in the construction execution process, the cost processing section 102b inputs the cost aggregation data, the actual cost on a cost proportional basis, and the actual revenue for the project that is the subject of the order data in response to, for example, an operator's operation on a cost registration screen (not shown) displayed on the monitor 114, and registers them in the data file 106a.
[0070] The production amount processing unit 102c executes a production amount record registration process (step S5). Specifically, in the production amount record registration process, the production amount processing unit 102c inputs production amount record data and production amount-based record for the job that is the subject of the order data in response to, for example, an operator's operation on a production amount registration screen (not shown) displayed on the monitor 114, and registers the data in the data file 106a.
[0071] The comparison unit 102d executes a comparison process (step S6). Specifically, in the comparison process, the comparison unit 102d compares the cost-proportional-based numerical value with the output-based numerical value for the target project in response to, for example, an operator's operation on a comparison screen (not shown) displayed on the monitor 114, and displays and outputs the results of the progress status and the income / expense status.
[0072] In this case, the comparison unit 102d may compare the predicted output with the actual output to determine the progress, and if predicted output - actual output < 0, determine that the project is progressing ahead of schedule, if predicted output - actual output = 0, determine that the project is progressing at the scheduled pace, and if predicted output - actual output > 0, determine that the project is behind schedule, and display a message to that effect.
[0073] Furthermore, the comparison unit 102d may compare the actual revenue and actual turnover for the income / expense forecast, and if actual revenue - actual turnover < 0, determine that the income / expense situation has improved, if actual revenue - actual turnover = 0, determine that the income / expense situation is as planned, and if actual revenue - actual turnover > 0, determine that the income / expense situation has worsened, and display a message to that effect.
[0074] Next, a specific example of the processing by the control unit 102 of the progress management device 100 in this embodiment will be described with reference to Figures 6 to 10. Figures 6 to 10 are diagrams for explaining a specific example of the processing by the control unit 102 of the progress management device 100 in this embodiment.
[0075] (S1: Order registration process) The order registration process will be described with reference to Fig. 6. Fig. 6 is a diagram for explaining the order registration process. When an order is received, the order registration unit 102a inputs order data in accordance with, for example, an operator's operation on an order registration screen (not shown) displayed on the monitor 114, and registers the data in the data file 106a.
[0076] Figure 6 shows an example of (1) order data. In the example of (1) order data shown in Figure 6, the first line has the construction number "100" and the contract amount "100,000," and the second line has the construction number "101" and the contract amount "200,000." The construction number "100" and the contract amount "100,000" will be explained below.
[0077] (S2: Budget registration process) The budget registration process will be described with reference to Fig. 7. Fig. 7 is a diagram for explaining the budget registration process. For the case that is the subject of the order data, the cost processing section 102b inputs budget data, quarterly budget data, and a cost-proportional budget consumption forecast in response to, for example, an operator's operation on a cost registration screen (not shown) displayed on the monitor 114, and registers the input data in the data file 106a.
[0078] Figure 7(A) shows an example of (2) budget data. In the example of (1) budget data shown in Figure 7(A), the first line has the construction number "100," the cost element CD "100," and the budget amount "20,000." The second line has the construction number "100," the cost element CD "200," and the budget amount "20,000." The third line has the construction number "100," the cost element CD "300," and the budget amount "20,000." The fourth line has the construction number "100," the cost element CD "400," and the budget amount "20,000." The total cost budget is "80,000."
[0079] Figure 7(B) shows an example of the cost element master 106b. In the example of the cost element master 106b shown in Figure 7(B), the first line has a cost element CD of "100" and a cost element name of "material cost," the second line has a cost element CD of "200" and a cost element name of "subcontract cost," the third line has a cost element CD of "300" and a cost element name of "labor cost," and the fourth line has a cost element CD of "400" and a cost element name of "expense." The cost element master 106b is referenced when converting cost elements CD and cost element names, for example, when converting the cost element CDs of budget data and quarterly budget data into "cost element names" for a cost-proportional budget forecast.
[0080] Figure 7(C) shows an example of budget data by second half of the year. In the example of quarterly budget data shown in Figure 7(C), the first line contains the construction number "100", cost element CD "100", fiscal year "2020", quarter "1", and progress rate "50".
[0081] Figure 7(D) shows an example of a cost-proportional budget consumption forecast [A]. In the example of a cost-proportional budget consumption forecast [A] shown in Figure 7(D), the first line shows the following for the cost element "material cost": budget amount "20,000," progress rate for 1Q "50%," consumption amount "10,000," progress rate for 2Q "0%," consumption amount "0," progress rate for 3Q "50%," consumption amount "10,000," progress rate for 4Q "0%," consumption amount "0." Here, the cost elements and budget amount are obtained from (2) budget data. The consumption rate is obtained from the performance rate of (2) quarterly budget data. The consumption amount is calculated by multiplying (2) budget data by the performance rate (consumption rate) of (3) quarterly budget data (for example, the consumption amount for material cost in 1Q is 20,000 x 50% = 10,000).
[0082] Additionally, the forecast revenues are 31,250 for 1Q, 21,250 for 2Q, 31,250 for 3Q, and 16,250 for 4Q. The forecast revenues are calculated by (1) contract data x (3) total amount spent for the corresponding Q in the quarterly budget data ÷ (2) total budget for the budget data. For example, the forecast revenues for 1Q are 100,000 contract amount x 25,000 total amount spent for 1Q ÷ 80,000 total budget = 31,250.
[0083] (S3: Production volume forecast registration process) The production volume forecast registration process will be described with reference to Fig. 8. Fig. 8 is a diagram for explaining the production volume forecast registration process. The production volume processing unit 102c creates forecast production volume header data, forecast production volume detail data, and production volume-based forecasts for the job that is the subject of the order data, for example, in response to an operator's operation on a production volume registration screen (not shown) displayed on the monitor 114, and registers them in the data file 106a.
[0084] Fig. 8(A) is a diagram showing an example of (4) Forecasted Progress Header Data. In the example of (4) Forecasted Progress Header Data shown in Fig. 8(A), the first line contains the construction number "100", SEQ "1", contract details "Steel pipe pile φ600 t=9-10 L=6.5-13m", number of contracts "95", unit price "1,000", and amount "95,000".
[0085] 8(B) is a diagram showing an example of (5) forecasted progress detail data. In the example of (5) forecasted progress detail data shown in FIG. 8(B), the construction number is "100", SEQ is "1", fiscal year is "2020", quarter is "1", and progress amount is "25".
[0086] Figure 8(C) is a diagram showing an example of a volume-based forecast [C]. In the example of volume-based forecast [C] shown in Figure 8(C), the first line contains the contract details "Steel pipe piles φ600 t=9-10 L=6.5-13m", number of contracts "95", unit price "1,000", amount "95,000", number of units completed in 1Q "25", amount of units completed "25,000", number of units completed in 2Q "25", amount of units completed "25,000", number of units completed in 3Q "24", amount of units completed "24,000", and number of units completed in 4Q "21", amount of units completed "21,000".
[0087] Here, the contract details, contract quantity, unit price, and amount are obtained from (4) Forecasted production volume header data. The production volume is obtained from (5) Forecasted production volume detail data. The production volume amount is calculated from (4) Forecasted production volume header data and (5) Forecasted production volume detail data.
[0088] The total trading volume for the first quarter was 27,500, the total trading volume for the second quarter was 25,000, the total trading volume for the third quarter was 26,500, and the total trading volume for the fourth quarter was 21,000.
[0089] (S4: Construction execution process) The construction execution process will be described with reference to Fig. 9. Fig. 9 explains the construction execution process. The cost processing section 102b inputs cost aggregation data, actual costs proportional to costs, and actual revenues for the project that is the subject of the order data in response to, for example, an operator's operation on a cost registration screen (not shown) displayed on the monitor 114, and registers the data in the data file 106a. The cost aggregation data is aggregated by cost calculation from data such as material purchases and subcontract cost accounting.
[0090] Figure 9(A) is a diagram showing an example of (6) cost summary data. In the example of (6) cost summary data shown in Figure 9(A), the first line contains the construction number "100", cost element CD "100", accounting year / month "202004", cost element code "100", and incurred amount "3,000".
[0091] Figure 9 (B) shows an example of actual costs and actual revenues [B] for the budget consumption forecast based on cost proportions in Figure 7 (D). Here, the cost elements and budget amounts are obtained from (2) Budget Data. The consumption amount is the total amount for each period in (6) Cost Aggregation Data (for example, material costs for 1Q are 3,000 + 3,000 + 4000 = 10,000). The consumption rate is the consumption amount divided by the budget amount in (2) Budget Data (for example, the consumption rate for material costs for 1Q is 10,000 ÷ 20,000 = 50%).
[0092] In Figure 9 (B), the differences from the forecast are that the forecast for outsourcing expenses in 1Q is a consumption rate of 20%, a consumption amount of 4,000, and a forecast for revenue in 1Q of 31,250, while the actual results for outsourcing expenses in 1Q are a consumption rate of 25%, a consumption amount of 5,000, and actual revenue in 1Q of 32,250 (= contract amount of 100,000 x total consumption amount in 1Q of 25,000 / total budget of 80,000).
[0093] Additionally, while the forecast for outsourcing expenses in the 4th quarter is a consumption rate of 20%, a consumption amount of 4,000, and a revenue forecast for the 4th quarter of 16,250, the actual outsourcing expenses in the 4th quarter are a consumption rate of 15%, a consumption amount of 3,000, and a revenue forecast for the 4th quarter of 15,000.
[0094] (S5: Production volume registration process) The production volume record registration process will be described with reference to Fig. 10. Fig. 10 is a diagram for explaining the production volume record registration process. The production volume processing unit 102c inputs production volume record data and production volume record data based on the production volume for the case that is the subject of the order data in accordance with, for example, an operator's operation on a production volume registration screen (not shown) displayed on the monitor 114, and registers the data in the data file 106a.
[0095] 10(A) is a diagram showing an example of actual progress data. In the example of actual progress data shown in FIG. 10(A), the first line contains the construction number "100", SEQ "1", fiscal year "2020", quarter "1", and progress amount "26", and the second line contains the construction number "100", SEQ "2", fiscal year "2020", quarter "1", and progress amount "0.5".
[0096] Figure 10(B) shows an example of actual results [D] for the volume-based forecast in Figure 8(C). Here, the contract details, contract quantity, unit price, and amount are obtained from (4) forecast volume header data. The volume of volume is obtained from (7) actual volume data. The volume amount is calculated by multiplying the unit price in (4) forecast volume header data by the volume of volume of (7) actual volume data.
[0097] In Figure 10(B), the differences from the forecast are that for the contract details (steel pipe piles φ600 t=9-10 L=6.5-13m), the forecast for 1Q was for the number of units completed to be "25" and the amount of units completed to be "25,000", while the actual results for 1Q were for the number of units completed to be "26" and the amount of units completed to be "26,000". Also, the forecast for 4Q was for the number of units completed to be "21" and the amount of units completed to be "21,000", while the actual results for 4Q were for the number of units completed to be "20" and the amount of units completed to be "20,000".
[0098] (S6: Comparison process) The comparison unit 102d compares the cost-proportional figures with the volume-based figures for the target project in response to, for example, an operator's operation on a comparison screen (not shown) displayed on the monitor 114, and displays and outputs the results of the progress status and income / expense status.
[0099] The comparison unit 102d compares the predicted output [C] with the actual output [D] to determine the progress, and if the predicted output [C] - the actual output [D] < 0, it determines that the project is progressing ahead of schedule, if the predicted output [C] - the actual output [D] = 0, it determines that the project is progressing at the scheduled pace, and if the predicted output [C] - the actual output [D] > 0, it determines that the project is behind schedule, and may display and output this information. Note that the comparison may be made by total contract content or by contract content.
[0100] In the above example (Fig. 8, Fig. 10), looking at the first half revenue up to 2Q, the total forecast volume "52,500" - the total actual volume "53,500" < 0, so for example, "Regarding progress, projects are moving ahead of schedule up to 2Q" is displayed.
[0101] Furthermore, the comparison unit 102d may compare the income and expenditure situation with the actual revenue [B] and the actual volume of sales [D], and if the actual revenue [B] - the actual volume of sales [D] < 0, determine that the income and expenditure situation has improved, if the actual revenue [B] - the actual volume of sales [D] = 0, determine that the income and expenditure situation is as planned, and if the actual revenue [B] - the actual volume of sales [D] > 0, determine that the income and expenditure situation has worsened, and display and output this information.
[0102] In the above example (Fig. 9, Fig. 10), looking at the first half revenue up to 2Q, the total actual revenue "53,750" - the total actual volume "53,500" is > 0, so for example, the display will output "Regarding the income and expenditure situation, the income and expenditure situation has worsened up to 2Q."
[0103] As explained above, according to this embodiment, the cost processing section 102b prepares a cost-proportional basis figure when an order is received, the output processing section 102c prepares a production-amount-based figure when an order is received, and the comparison section 102d compares the cost-proportional basis figure with the production-amount-based figure to grasp the progress and income / expense situation of the received order, thereby making it possible to objectively grasp the progress and income / expense situation of the order.
[0104] [4. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving business efficiency and promoting appropriate management decisions by companies, thereby contributing to the achievement of SDGs Goals 8 and 9.
[0105] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and digitalized systems, thereby contributing to SDGs Goals 12, 13, and 15. This embodiment can also contribute to strengthening control and governance, thereby contributing to SDG Goal 16.
[0106] 5. Other Embodiments The present invention may be implemented in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.
[0107] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically using known methods.
[0108] Furthermore, the processing procedures, control procedures, specific names, information including parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and drawings can be changed as desired unless otherwise specified.
[0109] Furthermore, with regard to the progress management device 100, the components shown in the drawings are functional concepts, and do not necessarily have to be physically configured as shown in the drawings.
[0110] For example, all or any part of the processing functions of the progress management device 100, particularly the processing functions performed by the control unit, may be implemented by a CPU and a program interpreted and executed by the CPU, or may be implemented as hardware using wired logic. The program is recorded on a non-transitory, computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the progress management device 100 as needed. That is, a computer program for providing instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). This computer program is executed by being loaded into RAM and cooperates with the CPU to form the control unit.
[0111] This computer program may also be stored in an application program server connected to the progress management device 100 via any network, and all or part of it may be downloaded as needed.
[0112] Furthermore, the program for executing the processes described in this embodiment may be stored in a non-transitory computer-readable recording medium or configured as a program product. Here, the term "recording medium" includes any "portable physical medium" such as a memory card, a Universal Serial Bus (USB) memory, a Secure Digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an Erasable Programmable Read Only Memory (EPROM), an Electrically Erasable and Programmable Read Only Memory (EEPROM (registered trademark)), a Compact Disk Read Only Memory (CD-ROM), a Magneto-Optical disk (MO), a Digital Versatile Disk (DVD), and a Blu-ray (registered trademark) disc.
[0113] Furthermore, a "program" is a data processing method written in any language or description method, regardless of the format, such as source code or binary code. Note that a "program" is not necessarily limited to a single structure, but also includes a structure that is distributed as multiple modules or libraries, or a structure that achieves its function by cooperating with a separate program, such as an OS. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in the embodiments, as well as the installation procedure after reading, can use well-known configurations and procedures.
[0114] The various databases stored in the memory unit are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files used for various processes and providing websites.
[0115] The progress management device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as an information processing device connected to any peripheral device. The progress management device 100 may also be realized by installing software (including programs, data, etc.) that causes the device to perform the processing described in this embodiment.
[0116] Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be configured by functionally or physically distributing and integrating them in any unit depending on various additions or functional loads. In other words, the above-described embodiments can be implemented in any combination, or embodiments can be implemented selectively. [Explanation of symbols]
[0117] 100 Progress Management Device 102 Control section 102a Order Registration Department 102b Cost Processing Department 102c Production Processing Department 102d Comparison section 102e Screen display control unit 104 Communication interface unit 106 Storage section 106a Data File 106b Cost Element Master 108 Input / Output Interface Section 112 Input Device 114 Output Device 200 servers 300 Network
Claims
[Claim 1] A progress management device including a control unit, The control unit a cost processing means for creating actual costs and actual revenues on a cost-proportional basis when a project is accepted; a production amount processing means for generating a production amount-based forecast production amount and an actual production amount when the order is received; a comparison means for determining the progress of the construction work by comparing the predicted progress with the actual progress, determining that the project is progressing ahead of schedule if the predicted progress - the actual progress < 0, determining that the project is progressing at the planned pace if the predicted progress - the actual progress = 0, and determining that the project is behind schedule if the predicted progress - the actual progress > 0, and determining that the project is behind schedule by comparing the actual revenue with the actual progress, determining that the profit and loss situation is improving if the actual revenue - the actual progress < 0, determining that the profit and loss situation is as planned if the actual revenue - the actual progress = 0, and determining that the profit and loss situation is worsening if the actual revenue - the actual progress > 0; A progress management device comprising:
Citation Information
Patent Citations
Ccm administration management technology
JP2017174241A