JP2003308450A - Construction estimate drawing-up device and storage medium used for device - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To draw up a highly accurate estimate. <P>SOLUTION: This construction estimate drawing-up device has a first step for retrieving each construction name constituting the main construction for drawing up an execution budget of the main construction, a second step for inputting the numerical quantity or unit cost data relative to basic cost items on resources for the construction and miscellaneous expanse items accompanying the construction into item columns of an itemized statement for the estimation object construction selected in the first step and displayed on a display screen, and a third step for displaying automatically a profit rate of the main construction on a profit rate display column of the itemized statement by a calculation means for dividing a contract sum of the main construction by a budget profit, while the working budget amount of the main construction and the budget profit are fluctuated in accompany with fluctuation of the total sum of the construction including the total amount of the miscellaneous expenses, based on the data on at least the miscellaneous expenses inputted in the second step. <P>COPYRIGHT: (C)2004,JPO

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a construction quotation preparation apparatus and a storage medium used for the construction quotation preparation apparatus. For example, (1) civil engineering, (2) slope work, (3) concrete construction, etc. The present invention relates to a construction quotation preparation device suitable for inputting company's progress data regarding each construction included in this construction while grasping the rate, and a storage medium used for the construction quotation preparation equipment.

[0002]

2. Description of the Related Art Conventionally, there is an example of a cost management system proposed to your office, which is described in Japanese Patent Laid-Open No. 11-232323. The embodiment described in this publication is "provided with a plurality of stages in which a company-specific company's own progress is automatically created from accumulated data of daily work reports, and the accumulated data can be referred to in the next estimation, execution budget, etc. There is.

However, the above structure has the following problems. Other than basic cost items such as materials, labor and equipment required for construction, data on miscellaneous expenses are not included.

Therefore, it is not possible to create a highly accurate quote. As a matter of course, since there is no miscellaneous cost reference column in the detailed statement that appears on the display screen, even if the total miscellaneous cost is added to the basic cost items, the miscellaneous cost of the construction is higher than the standard. I can't know if it's the one or not. Furthermore, since there is no calculation means for calculating the quantity of the construction amount of the relevant work or calculation unit for calculating the unit price of the construction amount of the relevant construction in relation to the fluctuation of the data on the miscellaneous expenses, the data regarding the miscellaneous expenses is When entering the total amount of, the layman could not easily make an estimate.

[0005]

In view of the present situation in which the change in the profit rate of this construction must be artificially calculated, the first object of the present invention is that even an amateur can easily create an estimate. It is possible. The second purpose is to create a highly accurate quote. The third purpose is to be able to prepare an estimate of the construction related to the construction for which the quotation request has been received, while comparing and contrasting with public standard unit price or accrual data. The fourth purpose is to be able to know at a glance whether the miscellaneous expenses are higher than the standard or low.

[0006]

The construction quotation preparation apparatus of the present invention comprises a first step of searching for each construction name constituting the construction in order to prepare an execution budget for the construction, and the first step.
Enter the quantity and unit price data for the basic cost items related to the resources of the construction and miscellaneous expenses items associated with the construction in the item column of the breakdown of the construction to be estimated that is selected in each stage and displayed on the display screen. Two stages and this second
Based on at least the miscellaneous expenses data entered at the stage, along with the fluctuation of the total amount of the construction work including the total amount of the miscellaneous expenses, the execution budget amount and budget profit of this construction will change, and the budget profit A third step is provided in which the profit rate of the main work is automatically displayed in the profit rate display field of the detailed statement by the calculation means that divides the contracted amount of work.

Further, the storage medium for the construction quotation preparation device of the present invention is a storage medium in which a program readable by the construction quotation preparation device via a drive is recorded in the file device, and the storage medium is the storage medium. The program installed from was selected in the first step of searching each construction name that constitutes this construction and the display screen, in order to create the execution budget of this construction. In the item column of the breakdown of the construction work to be estimated, the second stage of inputting the quantity and unit price data for the basic cost items related to the resources of the construction work and the miscellaneous expenses items associated with the construction work, and at least the data entered in this second stage Based on the data on miscellaneous expenses, the total amount of the miscellaneous expenses, including the total amount of miscellaneous expenses, will cause changes in the amount of budget for execution of this construction and the profit of The calculation means budget income dividing the contracted in the present construction, characterized in that it comprises a third step of margins of the present construction the margin display field breakdown statement is automatically displayed.

In the above structure, a miscellaneous expense reference column 31 is provided in the breakdown of the construction work, and the miscellaneous expense reference column 31 is obtained by subtracting the total amount of miscellaneous expenses entered from the standard miscellaneous expense amount. The feature is that the amount is displayed. In addition, there is a calculating means for calculating the quantity of the construction amount of the relevant construction and a calculating means for calculating the unit price of the construction amount of the relevant construction in relation to the fluctuation of data on miscellaneous expenses, and the numerical values calculated by these calculating means are It is characterized in that it is displayed in the implementation column for the company provided in the manual. Further, the detailed statement is characterized in that a standard implementation column is provided so that it can be compared with the in-house implementation column.

Here, "main work" means the work under contract. The term “implementation” as used herein means the amount of construction per day. Further, in the narrow sense, the “step” means the consumption of materials, labor, machines and miscellaneous expenses per activity unit (work) in the case of performing the construction. In a broad sense, it means the total consumption of materials, labor, machinery, and miscellaneous expenses when the steps of each work are added to perform this work including the work.

[0010]

DESCRIPTION OF THE PREFERRED EMBODIMENTS FIG. 1 is a block diagram showing an example of the construction of a construction quotation preparation device. Further, FIG. 2 is a processing flow executed by the apparatus.

First, reference numeral 1 is a central processing unit (hereinafter referred to as "CPU"), which has a main memory 3 having a control program 2, a drive 4, a file device (storage means) 5, a keyboard and a mouse. An input device 6 such as a printer and an output device 7 such as a printer are connected to each other. The drive 4 has a function of installing a program and electrically bridges (installs) the CPU 1 and the file device 5. The file device 5 of the present embodiment includes not only a case where it is fixed in advance in a storage means of a general-purpose computer (hardware) but also a storage medium called package software.

Although the storage medium stores the company's own work progress preparation system (software for performing a series of processes), the present invention is also applicable when the storage medium is mounted in, for example, the storage medium storage unit of a notebook computer. The file device 5 of FIG. In such a case, software is installed from the various storage media 5a to 5d via the drive 4, respectively. As the storage medium, a magnetic disk 5a including a floppy disk, an optical disk 5b such as a CD-ROM, a DVD, a magneto-optical disk 5c including an MD, a small rectangular plate-shaped or rod-shaped semiconductor memory 5d can be enumerated.

Now, in this embodiment, various storage media 5a are used.
Assuming that the software is installed in the file device 5 from each of 5d to 5d, the CPU 1 receives the instruction of the control program 2 in the main memory 3, and the file device 5 executes the execution budget (estimate) and budget of the construction work. The detailed statement data file 10 for which a profit rate including profit is to be created is read, and the format of the read detailed statement data file 10 (herein referred to as "detailed statement") 1
1 is displayed on the display screen 12 as shown in FIG.

For the detailed statement 11, for example, by pointing the pointer to a folder drawn in a hierarchical and columnar manner in the main work column divided into frames, an input device (pointing device) 6
It appears on the display screen 12 by operating (clicking).

Therefore, this embodiment requires the first step of searching for the construction name of the construction for which an execution budget (estimate) is to be created. On the display screen 12 of FIG. 3, “contents of the folder of C0010” of the civil engineering work which is the lower layer of this work is displayed. Therefore, each display column of the detailed statement 11 will be described.

Reference numeral 13 is a code display box showing a code attached to each type of work. In this embodiment, for example, the main work is divided into (1) civil engineering, (2) slope work, and (3) concrete work as the upper layers, and the construction names required during these works are positioned as the lower layers. .

FIG. 4 shows the contents of the construction table used in this embodiment. Here, constructions A to K are set as construction names based on the standard main construction established by the government agencies.
Codes “C0001 to C0011” are assigned to each construction name, and each construction name code is stored in a predetermined storage area of the construction table 14 in association with each construction name. Then, this is used as a main work master for calculating the execution budget amount, the profit rate, and the like. The “execution budget amount” for the “contract amount” described later is the total amount (total of a plurality of works) of this construction master.

Therefore, if the folder of C0010 is called and the company's quantity and unit price data regarding the basic cost related to the work G's progress and miscellaneous expenses associated with the civil engineering work are entered, the total appearing in the lower right column of the work G appears. As the amount of money changes, the total amount of money (execution budget) of this construction master changes in conjunction with this. If you call the folder of C0011 and enter the company's quantity and unit price data according to the estimate regarding the basic cost of construction K and miscellaneous expenses associated with the civil engineering work, the total amount shown in the lower right column of the construction K will change. At the same time, the total amount of the construction master (execution budget) also changes in conjunction with this. Therefore,
In the present embodiment, naturally, there is a first calculating means for adding the total number of each construction in the construction master.

Next, 15 is a construction name display box. In this construction name display box 15, (1) civil engineering of this construction,
One of the construction names AK of (2) slope work and (3) concrete work appears. For example, if the construction for which the quotation was received is “concrete crane vehicle placement” in “concrete construction”, in the first step of searching for the construction name of this construction, as described above, select the C0010 folder. click. Then, the name of “Construction G” appears in the construction name display box 15 according to the construction table 14.

Next, 16 is a standard display column showing the standard of the construction. Hereinafter, in this embodiment, the detailed statement 1 regarding the construction G
1 will be described on the assumption that 1 appears on the display screen 12. Here, "Construction G (concrete crane truck placement)"
The standard content of is a non-reinforced structure and is 30m per day.
In the case where it means 3, the standard display field 16 displays the letters, numbers and symbols of "unreinforced structure, less than 30 m3 / day".

Next, reference numerals 17 and 18 are a plurality of implementation columns provided below the standard display column 16 for displaying the construction amount per day. In this embodiment, the in-house implementation column 17 and the standard implementation column 18 are provided in parallel on the left and right. Each implementation column 1
The display boxes 7 and 18 are composed of a plurality of boxes. That is, 17a and 18a are quantity display boxes showing the quantity, 17b and 18b are unit price display boxes showing the unit price, 1
7c and 18c are unit display boxes showing units.

Here, the term "implementation" will be described.
"Execution" means the amount of construction per day. In the present embodiment, the total quantity display column 19 and the construction days display column 20 are provided in a row at the upper right corner of the detailed statement 11 of the construction G, but the quantity display box 17 of the in-house implementation column 17 is provided.
The data (quantity) appearing in a is associated with the data appearing in the total quantity display column 19 and the construction days display column 20, respectively. For example, the number in the total quantity display column 19 is “5
0.00 ", the number in the construction days display column 20 is" 2.50
(Here, it takes two days and a half day) ", the number" 20,00 "in the quantity display box 17a is calculated by the second calculating means that divides the number in the total quantity display field 19 by the number in the construction day display field 20. It is done (means for obtaining the quantity of the construction amount of the construction).

Further, the data (unit price) appearing in the unit price display box 17b of the in-house implementation field 17 is associated with the data appearing in the total price display field 21 of the construction G. The total amount display column 21 is provided in the lower right corner portion of the detailed statement 11 of the construction G. For example, if the number in the total amount display column 21 is "299,199 (here, it means a little less than 300,000)", The number "14,959" in the unit price display box 17b is calculated by the third calculating means for dividing the number in the total amount display field 21 by the number (quantity) appearing in the quantity display box 17a (of the construction amount of the construction. A means to determine the unit price).

Next, 23 is largely provided in a table state between each display box of each of the execution columns 17 and 18 and the total amount display column 21, and the basic cost item and the basic cost item for the resource of the construction G related to the step rate. It is a resource display column that displays miscellaneous expenses items associated with the construction.

Here, the term "progress" will be described. In the narrow sense, the term “step” refers to the consumption of materials, labor, machines and miscellaneous expenses per activity unit (work) when performing the construction. In a broad sense, it means the total consumption of materials, labor, machinery, and miscellaneous expenses when the steps of each work are added to perform this work including the work. In the present embodiment, the resource display column 23 relating to the progress of the construction G displays basic cost items for the construction, miscellaneous expenses items associated with the construction, and the like. Figure 5 shows resource file 2
It is a content explanatory view of 4. From left to right, 2
5 is a resource item code area, 26 is a resource item area associated with the resource item code area, 27 is a quantity area associated with the resource item area, 28 is a unit area associated with the resource item area, and 29 is a quantity area. The associated unit price area, 30 is the amount area and the amount area associated with the unit price area, respectively.

The resource file 2 is displayed on the display screen of FIG.
The contents of 4 are specifically shown. Connectivity between the storage areas will be described with reference to FIG. Looking at the left side of the detailed statement 11 on the display screen 12, an icon is drawn. This icon is associated with the resource item code area 25. The icons having the same pattern have the same or similar identification codes. Therefore, the icons of different designs have different identification codes and different meanings of resource items.

In the resource item area 26, in this embodiment,
A basic cost item 26a and a miscellaneous expense item 26b associated with the basic cost item 26a are provided. The contents of the basic cost item 26a are three elements of materials, labor, and equipment.
The basic cost item 26a of “Construction G (concrete crane vehicle placement)” is “1” and “6” in the sorted numbers.
And "7", "8" and "9". That is, in construction G, the material that corresponds to "material" is ready-mixed concrete,
In addition, “labor” corresponds to civil engineer, special worker, ordinary worker, and “equipment” corresponds to truck crane rent.

On the other hand, the contents of the miscellaneous expense item 26b are as follows.
It is "2", "3" and "4" in the sorted numbers. Many of these contents are invisible, such as damages and electricity bills. In construction G, there are three costs: vibrator loss, concrete bucket loss, and electric power.

The amount area 30 is associated with the quantity area 27 and the unit price area 20, respectively, as described above. Therefore, in this embodiment, at least the miscellaneous expense item 26
The boxes in the quantity area 27 and the unit price area of b are pointer areas, and the user's own numerical values can be entered in these pointer areas.

FIG. 7 shows the miscellaneous expense items 26 via the input device 6.
It is an example of the screen which input the miscellaneous expenses of the company in b. As is clear from comparison with FIG. 3, the number of vibrator loss charges was changed from “1” to “2”. Also, the unit price is "500 yen"
I chose Therefore, vibrator loss = 2 (units) x 5
00 (yen) = 1,000 (yen). In addition, concrete bucket loss = 1 (unit) x 500 (yen) = 500
(Yen) Furthermore, power = 1 kw / h × 500
(Yen) = 500 (yen). Therefore, in this embodiment, the total of the miscellaneous expense items 26b with respect to the basic cost item 26a of "construction G (concrete crane vehicle placement)" is 2,
It will be 000 yen.

By the way, in this embodiment, a miscellaneous expense reference column 31 is provided below the construction number display column 20 of the breakdown statement 11 to indicate whether the total miscellaneous expense is higher or lower than the standard. In the miscellaneous expense reference field 31, an amount obtained by subtracting "2,000 yen" of the miscellaneous expense from the standard miscellaneous expense is displayed.

That is, as shown in FIG. 3, since the standard miscellaneous expenses are "2,736", the fourth calculation means (2,2)
736−2,000 = 736), the number “736” appears. Therefore, the person making the quote is
Looking at this miscellaneous expenses reference column 31, own miscellaneous expenses item 26
It is possible to consider whether or not to service b, and how much it should be.

In construction G, the standard miscellaneous expenses are "2,73".
Therefore, if the total of the miscellaneous expenses of construction G becomes "2,736", the standard 2,736-the miscellaneous expenses of the self becomes 2,736 = 0. Therefore, the miscellaneous expenses of the self. Is the same as the standard miscellaneous expense amount, but if the miscellaneous expense reference column 31 is negative, it means that the miscellaneous expense amount of the user is more than the standard amount.

Further, in this embodiment, in order to improve the accuracy of the company's own work rate of the construction, the miscellaneous expenses of the construction G of "2,000" are added.
While the "yen" is added to the total amount, the unit price of implementation (daily construction amount) also changes. That is, the total amount of only the basic cost item 26a for the construction G was "299,190", but the miscellaneous expenses of "2,000 yen" were added to the total amount "299,190" of the basic cost item 26a. Then (299,190 + 2,000 = 301,190),
The total amount of money of 301,190 yen is displayed in the total amount of money display field 31 (fifth calculation means), and the unit price is also 30.
1,190 (total) / 20 (quantity) = 15,059. As described above, in the present embodiment, as is clear by comparing the unit price display boxes of FIG. 3 and FIG. 6, the unit price also changes in association with the miscellaneous expenses or the total amount of the case.

Further, in the present embodiment, the miscellaneous expense reference display field 31 of the detailed statement 11 is provided so that the profit rate of this construction can be seen at a glance.
A profit margin display field 21 is provided below. The numbers in the profit margin display column 32 are also “2,000
It is changed and displayed by adding "0 yen" to the total amount. In this embodiment, “16.06% → 15.85%”.

As described above, in the present embodiment, when not only the basic cost but also the miscellaneous expenses associated with the civil engineering work are input by the company's quantity and unit price data, the total amount shown in the lower right column of the relevant work G changes. In conjunction with this, the total amount of the construction master (execution budget) also changes, and as a result, the profit rate when the construction is carried out also fluctuates. FIG. 7 shows an example in which the profit rate of the entire main work is changed by changing the miscellaneous expenses of the specific work. In FIG. 7, 35 is a contract amount display column showing the contract amount of this construction, 3
Reference numeral 6 is an execution budget amount display column showing the self execution budget amount including miscellaneous expenses, and 37 is a budget profit amount display column showing the self budget profit amount. Corresponding to these columns 35, 36, 37, standard columns 35a, 36a, 37a are provided on the right side for reference.

Therefore, the person who prepares the estimate can compare whether or not his / her own execution budget amount or budget profit amount is larger or smaller than the standard by comparing with the standard columns 35a, 36a, 37a.

In the present embodiment, however, the profit rate of "16.06% → 15.85%" is obtained by adding "2,000 yen" of the miscellaneous expenses of the construction G to the total amount of the construction G.
Changed to. As described above, the miscellaneous expenses of 2,000 yen are per 20 m3 per day. Construction volume is 50m3
Is equivalent to 2.5, so 2,000 yen x 50/20 =
It will be 5,000 yen. By adding this 5,000 yen to the execution budget amount, the number in the execution budget amount display column of FIG. 8 changes from “2,014,497” to “2,019,497”. In other words, 5,000 yen was added to the cost and profit decreased by 5,000 yen. The profit rate at this time is 5th
By the calculation means, the budget profit 380,503 / contract amount 2,400,000 × 100 = 15.85%. The profit margin of this construction including miscellaneous expenses is shown in the profit margin display column 32.
Displayed in A.

[0039]

[Example] In the first stage of searching for the construction name of this construction, when the folder C0010 is clicked, the construction table 14 displays the name "Construction G" in the construction name display box 15. In this case, the construction G may be input in the construction name display box 15 or the breakdown of "construction G" may be displayed.

[0040]

As is clear from the above description, the present invention has the following effects. (1) In the present invention, when not only the basic cost but also the miscellaneous expenses associated with the civil engineering work are input by the company's quantity and unit price data, the total amount of the relevant work G changes, and in conjunction with this, the main work master Total amount (execution budget amount)
As a result, the profit rate when this work is carried out also fluctuates automatically. Therefore, even an amateur can easily create an estimate. (2) Further, according to the present invention, as shown in FIG. 5, since the resource file also includes data on miscellaneous expenses items, it is possible to create a highly accurate estimate. (3) Further, according to the present invention, since it is possible to create an estimate of the construction related to the construction for which the estimation request has been made while comparing and comparing with the standard unit price or accrual data, it is possible to directly determine whether the budget is in the red. . (4) In particular, you can see at a glance whether miscellaneous expenses are higher than standard or low.

[Brief description of drawings]

1 to 7 are schematic explanatory views showing an embodiment of the present invention.

FIG. 1 is a block diagram showing a configuration example of a construction quotation preparation device.

FIG. 2 is a processing flowchart executed by a construction quotation preparation device.

FIG. 3 is an explanatory view when the unit price data of miscellaneous expenses is not entered in the breakdown of the selected construction.

FIG. 4 is an explanatory diagram of the contents of a construction table.

FIG. 5 is an explanatory diagram of the contents of a resource file.

FIG. 6 is an explanatory diagram in the case where the quantity and unit price data regarding miscellaneous expenses are input in the breakdown of the selected construction work.

FIG. 7 is an explanatory diagram showing an example in which the profit rate has changed.

[Explanation of symbols]

1 ... Central processing unit, 2 ... Control program, 3 ... Main memory, 4 ... Drive, 5 ... File device (storage means), 6 ... Input device, 7 ... Output device, 10 ... Breakdown data file, 11 ... Breakdown Document, 12 ... Display screen, 13 ... Code display box, 14 ... Construction table, 15 ... Construction name display box, 16 ... Standard display column, 17 ... Company implementation column, 18 ... Standard implementation column, 19 ... Total quantity display Column, 20 ...
Construction day display column, 21 ... total amount display column, 23 ... resource display column, 24 ... resource file, 25 ... resource item code area, 26 ... resource item area, 26a ... basic cost item, 2
6b ... Miscellaneous expense items, 27 ... Quantity area, 28 ... Unit area, 29 ... Unit price area, 30 ... Price area, 31 ... Miscellaneous expense reference column, 32, 32A ... Profit margin display column, 33 ..., 34
..., 35 ... Contract amount display column, 36 ... Execution budget amount display column,
37 ... Budget profit amount display column.

Claims (5)

[Claims] 1. A first step of searching for each construction name that constitutes this construction in order to create an execution budget for this construction, and an estimation target selected in this first step and displayed on the display screen. In the item column of the construction breakdown, the second stage of inputting the quantity and unit price data of the basic cost items related to the resources of the construction and miscellaneous expenses items associated with the construction, and at least the miscellaneous expenses input in this second stage. Based on the data on the above, the execution budget amount and budget profit of this work will change with the change of the total amount of the work including the total amount of the miscellaneous expenses, and the calculation amount to divide the contracted amount of the work by this budget profit According to the third stage, the profit rate of the main work is automatically displayed in the profit rate display column of the breakdown statement. 2. In claim 1, a miscellaneous expense reference column 31 is provided in the breakdown of the construction work, and the miscellaneous expense reference column 31 is the total amount of miscellaneous expenses entered from the standard miscellaneous expense amount. A construction quotation preparation device, characterized in that the amount obtained by subtracting is displayed. 3. The method according to claim 1, further comprising a calculating means for obtaining the quantity of the construction amount of the relevant construction and a calculating means for obtaining a unit price of the construction amount of the construction in association with the fluctuation of the data regarding miscellaneous expenses. The construction quotation preparation device, wherein the numerical value calculated by the calculation means is displayed in the in-house implementation column 17 provided in the detailed statement. 4. The construction quotation preparation device according to claim 1, wherein the breakdown statement is provided with a standard implementation field so that it can be compared with the in-house implementation field. 5. A construction medium in which a construction quotation preparation device stores a readable program in its file device via a drive, and a program installed from the storage medium is a storage medium for executing an execution budget for this construction. In order to create, the first stage of searching for each construction name that constitutes this work, and the item column of the detailed statement of the construction work to be estimated that was selected in this first stage and displayed on the display screen, The total amount of miscellaneous expenses based on the second stage of inputting the quantity and unit price data for the basic cost items related to the resources and miscellaneous expense items associated with the construction work, and at least the miscellaneous expense data entered in this second stage In addition to the change in the total amount of the construction work including, the execution budget amount and the budget profit of the construction work fluctuate, and this budget profit is used as a calculation method to divide the contracted amount of the construction work. And a third stage in which the profit margin of the main work is automatically displayed in the profit margin display section of the breakdown statement.