JP2000048071A - Integral estimate system for building and interior construction - Google Patents

Abstract

PROBLEM TO BE SOLVED: To speedily prepare an exact estimate with no personal difference by settling disordered article data owned by respective makers within a uniform format. SOLUTION: The integral estimate system fr building/interior construction is constructed by settling the disordered article data owned by the respective makers within the uniform format. A master article database 14 manages the article data by registering the main information of article items to be used. A master model base 15 registers/manages information required for estimating the destination of stocking, construction or sewing concerning high-frequency articles or additional articles at the destination of a client while abbreviating them into model. A master article type base 16 classifies the information of article data for each article type and registers/manages them. A master item base 17 registers/manages information further precisely classifying the contents of items into item number data for each item. Besides, a master scale calculation base 18 becomes a base for calculating the scale required for estimation and registers/manages the information different by articles or article groups for each client/supplier.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a system for estimating the total cost of construction and interior work, and more particularly, to a method of storing all the product data of the industry, which has been conventionally separated, in a unified format. In the normal price structure of a wide variety of products such as different ones, and in the unit price matrix such as two-dimensional, the unit price of materials (the combined unit price of materials and wages), unit price (unit price x unit price that cannot be displayed), multiple Regarding rate setting, construction unit price, sewing unit price, etc., it is related to systematize cost management based on ordering of customers, suppliers, etc. and unit price for input products, immediately making estimates and receiving orders. .

[0002]

2. Description of the Related Art Interior work has inherent characteristics that are affected by its type, structure, scale, application, grade, and the like. There is a need to agree on how to handle a wide variety of parts, such as cloth, flooring, skirting boards, tiles, custom curtains / various design curtains, etc. Absent.

Heretofore, the estimation work has been performed by hand for an enormous amount of time while successively selecting products desired by customers for various parts. Unfortunately,
Each of the above parts has many similar products, each with a different profit margin.Moreover, for example, the curtain fabric used as a material for style curtains has standardized dimensions. Attach the parts to the basic scale, create a style curtain,
The necessary number must be added in consideration of the formula for preparation (necessary scale formula) for each supplier. Therefore, there is a large gap in the estimation depending on the person who estimates or how to handle it.

[0004] Not only the purchase price differs for similar products of various parts, but also the selling price differs for each customer. As personal preferences have diversified as recently,
The details of the estimate are complicated due to the interior work, and mistakes are more likely to occur.

[0005]

However, even in such a situation, in order to receive orders from customers and increase business results, quickly create a quote and use it as a reference material for comparison with other companies. In some cases, estimates must be revised accurately and promptly.

Therefore, the present invention provides accurate product knowledge without individual differences without having to remember detailed product knowledge, unit price settings of customers and suppliers set by the company, and accurate calculation formulas that differ for each supplier. An object of the present invention is to provide a system for estimating an interior construction work that can create an estimate and save labor and speed up the estimation.

[0007]

In order to solve the above-mentioned problem, according to the present invention, a system for estimating the total cost of construction and interior work by storing irregular product data owned by each manufacturer in a unified format.

[0008] If unit prices for a plurality of suppliers / customers are set for substantially the same product, different units or different sales are particularly provided for the substantially same product. If a plurality of quantities, sales prices, suppliers and purchase prices are provided, it is possible to adapt to complicated interior construction work. Further, it is preferable that the required scale can be calculated for each product type. If different supplier / customer patterns for different rates are set,
Still preferred.

[0009]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS The details of the present invention will be described based on an embodiment shown in the drawings. FIG. 1 shows the entire configuration of an interior construction work integration system according to the present invention. The central processing unit (hereinafter referred to as a CPU) 11 controls the entire system and performs processes such as integration and cost analysis, and activation of a computer itself. In addition to software, programs for processing the breakdown of work subjects such as cloth pasting work, floor formation work, style curtain / blind creation / installation work, lighting fixture installation work, estimation breakdown printing program, and product / item analysis program , A subject master base 13 for registering (including addition, change, and deletion) and managing each subject name of the work, and registering main information of a product list used for various works, and storing the product data. Product master base 14 to be managed and products that are frequently used for customers or accessories (rails, tassels, metal fittings, etc.) A model master base 15 that collects and registers and manages information necessary for estimating the destination, construction site, sewing destination, etc. in a model, and a product master base 16 that classifies and manages product data information by product type. Item master base 17 that registers and manages information classified into each item as data that can be made into product numbers (product codes) that can be further broken down into varieties, and requires design curtains, blinds, roll screens, Roman shades, etc. It is used at the time of size calculation and is the basis for calculating the size required for estimating the curtain etc. Registering and managing different information for each customer / supplier (supplier, construction site, sewing destination) by product or product group Yes, in other words, it is possible to form a scale for each type of design curtain (fabric, lining, frill, frenzy, trim, etc.). This is a category that can be specified, and a master scale calculation master base 18 that manages data (sewing allowance, fold multiple, etc.) necessary for calculation, the purchase price of products for each customer / supplier, and company, and sales of products. Regarding the amount, set the rate of material unit price for each manufacturer, sample book, product type, and item,
In addition, an item-based multiplication rate setting master base 19 that can be set with the material unit price, the construction unit price, and the sewing unit price.
And a sample book master base 20 for registering and managing sample book code and sample book name information for each maker, and information of each customer and general customer related to sales and information on suppliers, construction destinations, and sewing destinations (company Name, address, telephone number, person in charge, etc.
Furthermore, a company master base 21 for managing quotation numbers, order numbers, sales numbers, construction numbers, and the like, and information (addresses, telephone numbers, etc.) of each company, each customer, each supplier, and employees, etc. Person in charge of registration and management Master base 22, quantity of goods used for each interior construction work, estimated price of equipment manufacturer related to goods, and data necessary for estimation, such as width and height dimensions of materials for curtains An input device 23 such as a keyboard for inputting information, etc., a simulation basis master 24 for storing the simulation data for changing the breakdown contents (specification / unit price calculation), and calculation basis data for automatically calculating the total of each set of interior work. (Accounting estimate /
Request), and an automatic calculation basis master 25 for storing the
These are connected to the CPU 11. CPU 11
Is connected to a display device 30, such as a CRT, a printer 31, and a floppy drive 32 for driving a floppy disk (not shown) for storing data output to the display device 30 and the printer 31 via an output interface 29. ing. In addition, register construction site information,
A construction location master base to be managed, a construction location master base to register and manage construction location information, and the like may be connected.

In the subject master base 13, for example, the following subject names are registered. Cross work Curtain work Style curtain work Flooring work Tile work Baseboard work Architectural work

The data to be input to the commodity master base 14 include a maker code number and a maker name for a maker, a kind code number and a kind name for a kind, a sample code number and a sample book name for a sample book code, and a product code for a sample book code. There are an item code number and an item name, a unit price related to a product code, a unit, and the like. These data may be tentatively input in advance as common data in advance (for example, building design unit price or the like should be included in the product master as common data), but may be changed as necessary.
Manufacturer data, sample book data, item data, and product code are indispensable contents when composing one product, while product data exists as a common item regardless of the manufacturer. Data is also essential. The calculation of the required scale is determined by the type, and the total estimate is displayed according to the type. However, major classification,
This is excluded when the work is input by dividing the middle class and the small class from the hierarchy (for example, the large class is interior work, the middle class is curtain work, and the small class is style curtain work). Further, it is possible to input W × H and three-dimensionally W × H × D into the product master base 14 as a matrix unit price table. For example, W2000 mm × H2
If it is defined as 000 mm, a matrix is formed every 500 mm. In addition, the same product is provided with a plurality of product codes, and is regarded as a common product by inputting another manufacturer, thereby enabling input display as a common product in business or the like.

The data to be input to the model master base 15 include an item code number as a model number, a model name, a maker code number and a maker name for a maker, a product code and a product name for a product number and a product name, Quantity, supplier code number and supplier name for supplier, material cost / quantity, construction destination code number and construction destination name for construction destination, construction cost / quantity, sewing code number and construction destination name for sewing destination , Sewing cost / quantity, selling unit price and setting unit. The total display is performed on the total estimate for each code entered as a template. However, this is excluded when the business is input by dividing the hierarchy into the large classification, the middle classification, and the small classification.

[0013] This model master is not affected by the company pattern of the product by the item-specific charge rate setting master, and has a unique display content. Therefore, it is possible to input the product master regardless of the product in the product master. The contents registered in the template master are displayed collectively as details in the business. The displayed content is displayed regardless of the pattern of the billing destination and is the content input to the template master.

The data to be input to the item master base 17 include a maker code number and a maker name for a maker, a sample book code and a sample book name for a sample book, a kind code and a kind name for a product, and an item code and a product name for a product. There are names. The data to be entered in the item-based rate setting master base 19 include the company code / sample name for the maker, the maker code number and maker name for the maker, and the sample code and sample book for the sample code for the sample book. Classification number (symbol) of pattern to set the rate of sales material used for name, type and item for each group, type code and type name for type, item code and item name for item, multiplication for item Material work (material + labor) unit price, which is the amount when a unit price is set at a fixed amount without a rate, and each set rate, which is the set numerical value of each of the normal or special price The unit price for the product that does not exist (cannot be displayed as a percentage), the unit for the unit price (based on the price setting), the construction unit price, and the sewing unit price for normal or special price. There is.

[0015] The company / customer /
The supplier is displayed, and the pattern divided by the company master is input. At what stage the price of the entered product data is set by selection, that is, whether it is at the product level, at the manufacturer level, at the sample book level,
Select the item level to set the price, and assuming that the manufacturer, product type, sample book, and item are entered in the product data, enter data such as material construction cost, unit price, cost rate, construction, etc. Is done. Setting Details Only the above-mentioned unit price of material works in conjunction with the purchase rate on the quote / order / sales screen.

[0016] It should be input data to the main scale calculation master base 18, item code number, style name of the curtain, each sewing destination company code in the calculation code, m ² units of the seam allowances, folds magnification curtain, There is a loss in units of mm. The scale calculation content is input according to which pattern content in the category (own company, customer, supplier) is used.

A type code number and a type name are input to the type master base 16. Sample Book Master Base 2
The data to be input to 0 includes a maker code number and a maker name for the maker, a sample code number and a sample book name for the sample book, and the like.

The company master base 21 classifies the company into its own company, customers, suppliers, construction sites, etc. according to the classification, and codes each classification according to the classification. That is, the manufacturer code number, manufacturer name,
A pattern classification number (symbol), a serial number for quotes, orders, and construction, a product code number, and the like are added. Address,
Phone / fax number, contact person, house bank data,
The closing date, tax rate, fraction processing, collection date counted from the closing date, and the like are input as information.

When certain setting contents are the same in the selling method, the purchasing method, and the like for each type divided by the classification, it is possible to divide the data into groups and code them for each pattern to perform classification. If the pattern cannot be divided, for example, as unit price calculation, purchase (m) / sale (m ² ) × factor + construction unit (m ² ) method A, purchase (m) / sale (m) It is also possible to divide the method into a B method of (multiplying factor + construction unit (m)) and a C method in which the material unit price is calculated at a fixed price, the material is discounted, and only the construction is separately calculated. Further, it is also possible to determine the display of the product number (product code) of the forms for each company.

The person-in-charge master base 22 codes persons in charge of the company for each type of company, customer, supplier, construction site, etc. divided by the company master. That is, a company code number, a company name, a responsible code number, a person in charge, and the like are assigned to each type. It is also possible to record personal information at a level such as date of birth or date of medical examination.

The above-described input to each master base is performed as advance preparation. Customer coding, e.g. phone numbers,
When it is not possible to divide the product to be handled, the price setting of the customer and its patterning, and the pattern, the customer code = pattern, and the same processing can be performed for the supplier. It is convenient to collectively input a product configuration that is frequently used for customers as a model master, input unit price / quantity / unit, etc., and at the same time, input information such as supplier and construction destination in the specification. Quick and accurate sales are performed by integrating quote calculation masters to easily calculate the quantity of customers and suppliers, and masters in charge of inputting the results and information of the sales representatives. Information can be extracted, and information can be collected from various angles by coding and combining a large number of contents.

An example of a working operation specifically performed in the integrating system configured as described above will be described with reference to the procedure shown in FIG. At the start of the multiplication system, the classification of business processes (estimation, order, sales,
Purchase). The creation date is set as the processing date, and a serial number is automatically displayed for each selected section.

A billing address is entered using a company code number and a name. The construction serial number for each billing destination is automatically displayed. If the billing party has a primary contractor, enter the company code of the primary contractor.
Enter the name of the person in charge of the billing company. Enter the person in charge of the company by code number and name.

As the construction work, a construction name and its detailed information are input. That is, in addition to the name of the construction, the address of the construction site and the telephone / fax are inputted, and the selection of the foreign tax / internal tax and the designation of the tax rate are performed. In addition, for example, the sales rate is set by purchasing, and the discount price of the purchasing price is set.

Next, a code number of a maker involved in sales is first input as a work description. Enter the product code number as the item or product number. By inputting these, the data is input to each master in the preparatory stage, so that the required scale calculation method is determined from the product master product type and the like. Further, by inputting the model number, the detailed data input to the model master can be reflected in this specification line.

Next, when the dimensions (W × H × D) are input,
Depending on the product, the required scale calculation screen is drawn out from the required scale calculation master as a required calculation screen, so that quick and accurate numerical values can be calculated. The calculation contents can be seen as if they are not at various angles. For example,
The quantity calculated by the summary scale calculation is converted in units of the billing rate pattern for each billing destination item, and a numerical value is extracted from the matrix as a sales quantity and displayed.

By inputting the maker and the item or the product number, a selling unit price is calculated from the billing rate pattern for each billing destination in consideration of materials, construction, sewing, and costs, and the sales amount calculated from the unit price calculation of the selling unit price is calculated. Displayed in conjunction.
The same can be done for a supplier, and a plurality of supplier settings can be made from one detailed line.

It should be noted that, by specializing the contents output from the required scale calculation master in the contents output from the output interface 29, it is possible to dramatically improve efficiency in the field. The automatic calculation basis master 25 and the product master 14 (when there is no data, the contents are manually input) are displayed as default values of the required scale calculation master 18, and the customer and supplier are simulated by the material cost ratio setting master. With 24, the unit display and quantity can be performed for each.

For example, the necessary material for the curtain, the required material for the style, etc. can be quickly obtained by connecting the product master, the automatic calculation master, etc., and entering the manufacturer, product number, dimension width and height, and using the simulation basis master 24. In addition to being able to calculate the value of the sale / purchase, the simulation grounds master is displayed as a default value, so that the simulation can be performed again by a change by manual input. In the style, a composite style such as a frill or trim attached to the basic style can also be calculated by the simulation basis master 24 or the like.

Also, accessories required for mounting the curtain, such as rails, tufts, tassel, etc., and installation costs, etc., can be registered in the product master 14, and the necessary contents can be determined at the same time as the specification is entered. The simulation basis master 24 can calculate the finished dimensions and the like in a complex manner, and it is also possible to sum up and display necessary numerical values and the same product contents. The simulation grounds master 24 is a master for displaying necessary numerical values depending on a product to be attached.

Further, in the construction or interior, there are a plurality of master scale masters 18, and the contents of the master scale calculation masters can be specially combined and displayed on a screen, and the totals can be counted.

[0032]

According to the present invention, irregular product data owned by each of the architectural and interior manufacturers is stored in a uniform format. , Equipped with multiple supplier and customer unit price settings as patterns (groups) for products, setting multiple unit prices for each product type, manufacturer, product type, item (table of contents, index), product code, etc. It is possible to manage a plurality of product numbers and OEM manufacturers in the same manner, and to collect data in each unit. When one product unit is manufactured by combining a plurality of products based on the calculation method (calculation of required scale) provided for each product type and its value, the products are divided by each pattern,
By substituting unit prices and calculated values and adding them together,
It is possible to give an instruction to automatically produce a product desired by the customer.

The method of calculating the unit price and quantity of the product or product is also 2
A three-dimensional price list can be calculated simply by inputting a numerical value, and an appropriate display can be made by setting a supplier and a customer. In the present invention, since a product composing one product (model name) has a plurality of units, respective sales quantities, sales prices, suppliers and purchase prices for these, etc., it is necessary to store these as a master to perform business. Sometimes they can be displayed all at once.

Moreover, in performing such a complicated job, even if there is no special knowledge or technology, if a customer is specified on a personal computer, it is possible to accurately create and display uniform contents without individual differences. Therefore, it is possible to save labor and speed up sales and cost management from estimation. In addition, by performing various operations on the same screen of a personal computer, estimates, orders, sales, and purchases can be centrally managed.

[Brief description of the drawings]

FIG. 1 is an overall configuration diagram showing an embodiment of the present invention.

FIG. 2 is an explanatory diagram of a flowchart showing a specific example of a work operation in the present embodiment.

[Explanation of symbols]

 11 CPU 12 ROM 13 Subject Master Base 14 Product Master Base 15 Template Master Base 16 Product Master Base 17 Item Master Base 18 Master Scale Calculation Master Base 19 Item-Specific Charge Setting Master Base 20 Sample Book Master Base 21 Company Master Base 22 Master base 24 Simulation basis Master base 25 Automatic calculation basis Master base 30 Display device 31 Printer

Claims (5)

[Claims] 1. An architectural system characterized by storing irregular product data owned by each manufacturer in a unified format.
Estimation system for interior construction. 2. The system according to claim 1, wherein unit prices are set for a plurality of suppliers / customers for substantially the same product. 3. The multiplication estimation system according to claim 2, wherein substantially the same product is provided with a plurality of different units, different sales quantities, sales prices, suppliers and purchase prices. . 4. The multiplication estimation system according to claim 1, wherein a scale can be calculated for each product type. 5. The method according to claim 1, wherein different rates are set for each of a plurality of suppliers / customers.
The integration estimation system according to any one of Items 1 to 4.