JP2003168026A - Quotation preparation method - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a quotation preparation method by which an order- receiving side needs no man power and a customer can freely acquire a quotation. <P>SOLUTION: In the quotation preparation method using a computer, the prices of respective parts are stored in a storage means 113, the basic dimensions of respective parts are stored in a storage means 112, a parts determination rule consisting of relation between the number of respective parts and parameters or the like is stored in a storage means 111, the sundry expenses of past products are stored in a product information database 145. Application parts information is calculated on the basis of parameter values, the parts determination rule and the basic dimensions inputted through a network, the quotation of a product is prepared on the basis of the application parts information, the unit prices of respective parts and the sundry expenses, the set contents of product guarantee are acquired through the network, and a final quotation is prepared on the basis of the quotation of the product and the set contents of the product guarantee. <P>COPYRIGHT: (C)2003,JPO

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention creates a price estimate for a product manufactured from a plurality of parts according to the values of predetermined parameters such as the main dimensions of the product input from a customer's terminal via a network. However, the present invention relates to a method for creating an estimate using a computer that outputs to a customer's terminal.

[0002]

2. Description of the Related Art For exterior products such as gates and fences, there are various shapes and sizes of houses, sites, etc. to which they are attached, and therefore even one product has a width, a height and a door. It is necessary to support many variations that change the number. In addition, when the size of the object to be attached is special, it is often necessary to manufacture a product that perfectly matches the object to be attached by custom-made.

[0003]

By the way, when receiving an order for manufacturing or selling a product, it is customary to present a price estimate to the customer prior to receiving the order. However, in the case of a custom-made product such as that described above, the number and size of each component used to manufacture the product differ according to the product size specified by the customer. With the traditional method of estimating work,
There was a problem that the effort and time would be enormous. Of course, at the estimation stage, the order has not been finalized yet, and in the end it is often impossible to receive the order and the estimation work will be a mess. Therefore, the management resources such as manpower devoted to this estimation work should be reduced as much as possible. Is desired.

From the customer's point of view, it is natural that conditions such as product dimensions and specifications should be changed to make various types of quotations, and they should be compared and examined. In the case of passing through, it is not possible to request many kinds of quotes unnecessarily, and it is the current situation that the conditions are narrowed down to some extent and the quotes are obtained.

The present invention has been made in view of the above circumstances, and it is an object of the present invention that the customer on the quotation request side does not need manpower for preparing the quotation, and the customer on the quotation request side sets the desired conditions. It is to provide a method of creating a quote that allows the user to freely obtain a quote according to the.

[0006]

The present invention creates a price estimate for a product manufactured from a plurality of parts according to the values of predetermined parameters such as main dimensions input from a customer's terminal via a network. A method for producing an estimate using a computer that outputs to a customer's terminal, wherein the unit price storage unit 113 stores the unit price of each component in advance, and the basic size storage unit 112 stores the basic dimensions related to the shape of each component and the arrangement of each component. In the part determination rule storage means 111, the relationship between the number of each part at the time of manufacturing the product and the parameter, and the part whose size changes according to the parameter value, further include the relationship between the size and the parameter. The parts determination rule is stored in the product information database 145 for expenses related to a plurality of products manufactured in the past. Based on the value of the parameter input via the network, the part determination rule stored in the part determination rule storage means 111, and the basic dimensions stored in the basic dimension storage means 112, at least used for the product. The used part information calculation step S13 for calculating the used part information including the number of each part and the size of which changes according to the parameter value, and the used part information calculation step S13. Used component information and the component unit price storage means 113
Based on the material cost obtained from the unit price of each part stored in the product information sheet and the various expenses stored in the product information database 145, a product estimate creating step S14 for creating a product price estimate, and A guarantee setting detail acquisition step S44 for obtaining setting details regarding product guarantee from a terminal via a network is provided, and the product price estimate obtained in the product estimate creation step S14 and the guarantee setting detail acquisition step S44 are obtained. The final price estimate is created based on the settings related to product warranty.

[0007]

BEST MODE FOR CARRYING OUT THE INVENTION Embodiments of the present invention will be described below in detail with reference to the drawings. 1 to 20 illustrate a first embodiment of the present invention. The quotation preparation method according to the present embodiment uses the WWW (W
It can be implemented on a system as shown in FIG. 2, which includes an ord Wide Web) server 300a and a database server 300b, and a terminal 301 connectable to the WWW server 300a via a network such as the Internet.

The WWW server 300a and the database server 300b are, for example, server computers such as personal computers and workstations, and are placed under the control of a maker or a sales company of the quotation receiving side, and an in-house LAN (Local Area Network). Etc. are connected. Further, the terminal 301 is, for example, a personal computer or a mobile phone having an information terminal function, which is owned (or available) by the customer who is the quotation requesting side, and is a Web that can browse websites on the Internet.
b The browser program is installed.

The quotation preparation device Z1 constructed on the WWW server 300a and the database server 300b is
The price estimate for single or multiple exterior products such as gates, gates, fences, etc.
It is automatically created according to predetermined parameters such as the main dimensions of each product, which are input from 1 via the Internet. In the following description, individual products such as gates and fences will be referred to as "individual products", and one or a combination of these "individual products" will be referred to as "composite products" for distinction.

Before explaining the configuration of the quotation preparation device Z1 and the processing procedure thereof, first, a folding telescopic door, which is an example of an individual product, will be described focusing on matters necessary for price estimation. 7 and 8 show the basic structure of the folding telescopic door. Reference numeral 1 is a suspension base side pillar, and 2 is a door stop side pillar, both of which are erected vertically to the ground 3. Reference numeral 4 denotes an upper frame, which is horizontally installed between upper ends of the suspension base side pillar 1 and the door stop side pillar 2. In addition, on the lower surface side of the upper frame 4, the suspension base side pillar 1 and the door stop side pillar 2 are provided.
The hanger rails 5 are mounted between them. As shown in FIG. 9, this hanger rail 5 has a cross-sectional shape in which the central portion of the lower surface of the rectangular tube is opened over the entire longitudinal direction and groove-shaped roller receiving portions 26 are formed on both sides of the opening. There is.

Reference numeral 10 denotes a telescopic door body, which is an even number (six in FIG. 7) of door units 11a, 11b, ...
It is composed by. Each of these doors 11a, 11
, b, ... Are adjacent to each other in the vicinity of the upper end and the lower end of the side edges thereof, hinges 12a, 12b ,.
Are rotatably connected to each other with respect to the vertical axis. Each of the doors 11a, 11b, ... Is composed of a pair of left and right vertical frame members 23, a pair of upper and lower horizontal frame members 24, and a door face member 25 provided inside the frame members. Here, as the door surface material 25, a horizontal lattice, a girder lattice, a gallery,
A vertical grid or the like can be considered. In the present embodiment, as the door surface member 25, a louver type in which louver members 25a are arranged in parallel in the vertical direction as shown in FIG. 11 is used.

The telescopic door 10 has a traveling portion 13 which can travel along the hanger rail 5 in the state shown in FIG.
It is suspended on the upper frame 4 via a, 13b, .... These traveling portions 13a, 13b, ... Are provided at the suspension base side end and the door stop side end of the telescopic door 10, respectively, and in the vicinity of the odd-numbered hinges 12b, 12d ,. It should be noted that the retractable door 10 is provided with a drop rod 14 for preventing rattling inward and outward in the closed state in the vicinity of the odd-numbered hinges 12a, 12c, ... On the side is a handle 15 for opening and closing
And locking means are provided.

FIG. 8 shows a state in which the telescopic door 10 is closed (denoted by symbol A) and an open state (denoted by symbol B) at the same time. In the state A in which the telescopic door 10 is closed, each door is a single unit 11.
The a, 11b, ... Are extended so as to form one plane, and the space between the suspension base side strut 1 and the door stop side strut 2 is closed. When the telescopic door 10 is folded from the closed state A to the open state B, the drop rods 14 are removed and the lock is released, and then the handle 15 is grasped to hold the telescopic door 10 on the suspension base side, that is, FIG. And in the direction of arrow α in FIG. Then, the single doors 11a, 11b, ... Are gradually folded alternately and collected on the suspension base side, and the closed state B in which the space between the suspension base 1 and the door stop side support 2 is largely opened is established.

This foldable telescopic door includes, in addition to the basic components such as the suspension base side pillar 1, the door stop side pillar 2, the upper frame 4, the hanger rail 5, the telescopic door body 10 and the like, a hanger. Side guide rails 6 and 8 provided on the inside of the garage of the rail 5, guide members 18, 19 and 20 installed at a predetermined distance from the hanger rail 5 or the upper frame 4 from the suspension base side 1 side. , 21, and the guide roller 22, the odd-numbered door unit 11 from the hanging side
a, 11c, ... on the upper edge side and the running portions 13a, 13b,
The guide rollers 16a, 16c, which are provided at a position a little distance from the ..., the guide rollers 17a which are provided near the edge of the door-stop side on the upper edge side of the odd-numbered door units 11a, 11c, ... , 17c, ..., Connection parts such as screws and bolts for connecting the respective parts, and the like, but are not described in detail.

Incidentally, the side guide rails 6 and 8, the guide members 18, 19, 20, 21 and the guide roller 22,
Guide rollers 16a, 16c, ..., Guide roller 17
a, 17c, ... Make the operation of the telescopic door 10 smooth and reliable when opening and closing the telescopic door 10, or the telescopic door 1
It is an auxiliary component for preventing the doors 11a, 11b, ... In the state where 0 is open, from swinging out of the plane.

The folding telescopic door has a full width W,
It is assumed that the customer can freely specify the values of the total height H and the number of doors N under predetermined constraint conditions. The total width W, the total height H, and the number N of doors are parameters for the folding telescopic door. In addition, among the respective parts, for example, a suspension base side pillar 1, a door stop side pillar 2, an upper frame 4, a hanger rail 5, a vertical frame member 2
3. Regarding the horizontal frame member 24, the louver member 25a, etc., if the value of the parameter changes, the length thereof changes accordingly, but the cross-sectional dimension thereof does not always change (hereinafter, such a part will be described). Dimensionally variable parts). On the other hand, the running portions 13a, 13b, ... And the guide members 18, 19, 2
Regarding the parts such as 0, the drop rod 14, etc., if the parameter value changes, the number of parts used may change accordingly, but the shape, dimensions, etc. are always the same (hereinafter, such Parts are called dimension invariant parts). The foldable telescopic door has been described above as an example of the individual product, but the parameters can be set for other individual products such as gates, gate posts, and fences in the same way.

Next, the configuration of the estimate creating device Z1 will be described. As shown in FIG. 1, the quotation preparation device Z1 includes an input / output processing unit 101, an individual product processing unit 102, and a composite product processing unit 1 which are built on the WWW server 300a.
03, a guarantee content setting unit 104, and a database unit 105 built on the database server 300b. Here, the quotation preparation device Z1 is realized by executing a quotation preparation program which describes a procedure of a quotation preparation process described later on the WWW server 300a and the database server 300b.

The input / output processing means 101 displays a parameter input screen or the like on the display screen of the terminal 301, determines whether or not the parameter value or the like input from the terminal 301 is appropriate, It performs a process of acquiring an appropriate input parameter or the like that has been input and outputting it to an appropriate means, a process of outputting the estimation result on the display screen of the terminal 301, and the like.
It is connected to the.

The individual product processing unit 102 performs processing relating to estimation for each individual product, and includes a component determination rule storage unit 111, a basic dimension storage unit 112, a component unit price storage unit 113, a used component information calculation unit 114, and a product estimate. It comprises a creation means 115, a product quotation storage means 116, and a product quotation management means 117.

The component determination rule storage means 111 stores a component determination rule for determining the number and size of each component based on the value of the parameter in advance for each type of individual product, and is configured by a hard disk device or the like. To be done. Here, the part determination rule is composed of a relationship between the value of the parameter and the number of used parts (hereinafter, referred to as a number rule), and a relationship between the parameter and the size of each part (hereinafter referred to as a size rule). It The number rule is set for all parts, but the size rule is set only for variable size parts.

As an example of the number rule in the case of a folding type telescopic door, the relationship between the number of doors N, which is one of the parameters, and the number n23 of the vertical frame members 23, which are dimensionally variable parts, is, for example, n23 = N × 2 (1) is set.

Further, the total height H and the number n of the louver members 25a are n.
The relationship with 25 is that the upper frame 4, the horizontal frame member 24, and the hanger rail 5 have sectional heights of h4, h24, and h5, respectively, the arranging pitch of the louver members 25a is p25, the upper surface of the telescopic door 10 and the lower surface of the hanger rail 5. Assuming that the standard value of the sum of the gap d1 between and and the gap d2 between the lower surface of the telescopic door 10 and the ground 3 is d (set to an appropriate value in advance) (see FIG. 12), for example, n25 = ABS [ {H− (h4 + h5 + 2 × h24) −d} / p25] (2) is set. Here, ABS () represents an integer not exceeding that value.

However, when the arrangement pitch p25 of the louver members is constant, the height of the telescopic door 10 is determined according to the number of the louver members 25a.
If the total height H can be set freely, there arises a problem that the gaps d1 and d2 change according to the value of the total height H. In order to avoid such a problem, for example, as the value of the total height H, one of a plurality of levels of height corresponding to the number n25 of the louver members 25a, for example, H = h4 + h5 + 2 × h24 + d + p25 × n25 (2a) where n25 It is also possible to set a constraint condition such that can be set only to any value represented by an integer within a predetermined range.

Further, the number of connecting parts such as screws and bolts used for connecting the respective parts is appropriately set in the form of the relationship with the number of parameters. For example, the number of screws nb5 for attaching the hanger rails 5 to the upper frame 4 is pb5 for the attachment pitch, and h for the cross-sectional height of the suspension base column 1 is h.
1 (= section height h2 of the strut 2 on the door stop side), nb5 = ABS [{W− (2 × h1)} / pb5] (3) is set. Note that the number of suspension base columns 1 is n
The values of 1, the number n2 of the door stop side columns 2, the number n4 of the upper frame 4, etc. are set to always be "1" regardless of the value of the parameter.

An example of the dimensional rule in the case of a folding telescopic door is, for example, the total width W that constitutes a parameter.
And the total height H and the lengths t1, t2, and t4 of the suspension base side pillar 1, the door stop side support pillar 2, and the upper frame 4, the cross-sectional height of the upper frame 4 is h4, and the suspension base side pillar 1 is And the buried length of the door stop side pillar 2 is t0 (set to an appropriate value in advance), t1 = t2 = H-h4 + t0 (4) t4 = W (5)

The length t23 of the vertical frame member 23 is, for example, the number of louver members 25a set in the number rule is n25, the arrangement pitch of the louver members 25a is p25, and the cross-sectional height of the horizontal frame member 24 is h24. Then, t23 = n25 × p25 + 2 × h24 (6) is set (see FIG. 11).

In order to fill the space between the upper and lower horizontal frame members 24, 24 with the louver member 25 without a gap, the length t23 of the vertical frame member 23 is set to the number n25 of the louver members 25a as described above.
(The relationship with the parameter H is defined in the number rule). In this case, as already mentioned, the total value of the gaps d1 and d2 may fluctuate and become slightly larger than the standard value d. In this case, for example, if the hanging length of the telescopic door 10 by the traveling portions 13a, 13b, ...
It is possible to adjust so as to be appropriately distributed to the gaps d1 and d2 above and below zero. Of course, if a constraint condition such as limiting the value of the total height H to a predetermined value corresponding to the number of the louver members 25a is provided, such adjustment is not necessary.

If the arrangement pitch of the louver members 25a can be changed in manufacturing, the length t23 of the vertical frame member 23 is set as a dimensional rule in relation to the parameter H, and the distance is determined by this. Upper and lower horizontal frame members 24,
The number of the louver members 25a is set by the number rule so that the space between the louvers 24 and 24 can be completely filled in at least 24.
You may make it arrange | position at equal pitch. In this case, the arrangement pitch of the louver members 25a will change according to the value of the parameter H, but since the louver members 25a are arranged in the state as shown in FIG. It can be absorbed by the overlap between adjacent members.

The basic dimension storage means 112 stores in advance the basic dimensions relating to the shape of each component and the arrangement of each component for each type of individual product, and is constituted by a hard disk device or the like. For example, the values of the cross-sectional heights (h4, h24, etc.) of each component used in the description of the component determination rule described above are stored in the basic dimension storage means 112. In addition, the telescopic door 10
The standard value d of the sum of the upper and lower gaps d1 and d2, the arrangement pitch p25 of the louver members 25a, and the like are also stored in the basic dimension storage means 112.

The component unit price storage means 113 stores in advance the unit price of each component constituting an individual product for each type of individual product, and is constituted by a hard disk device or the like. The unit price of the parts is set at a price per unit length for the variable size parts and at a price per unit number for the size invariant parts. Here, it is assumed that the weight per unit length of each component and the price per unit weight of the material (aluminum here) are set as the unit price of the variable dimension component (if both are multiplied, each component Price per unit length for each). In the case of the made-to-order product as in the present embodiment, a variable-size component having an arbitrary size is cut out from a material having a fixed length, and therefore, in many cases, the amount of waste of the material is larger than that of the standard product. Therefore, it is possible to add the cost of this waste of material to the unit price in advance or at the calculation stage.

The used part information calculating means 114 is for calculating the number of each part used for an individual product and the size of the variable size part (these are collectively referred to as used part information). The individual product selection screen, the parameter input screen for the selected individual product, and the like are displayed on the display screen of the terminal 301 via the input / output processing unit 101, and the terminal 301 is displayed via the input / output processing unit 101.
Parameter values obtained from the basic size storage means 11
2 is substituted into the component determination rule (number rule and dimension rule) stored in the component determination rule storage means 111 to calculate the used component information regarding the individual product, and the product estimate is calculated. The data is output to the creating means 115.

The product quotation creating means 115 uses the used part information calculated by the used part information calculating means 114 and the unit price of each part stored in the part unit price storage means 113.
A price estimate for an individual product is created based on various expenses obtained from a database unit 105 described later.

The product quotation storage means 116 stores the quotation result concerning the individual product obtained by the product quotation preparation means 115, and is constituted by a hard disk device or the like.

The product quotation management means 117 manages the quotation result for each individual product stored in the product quotation storage means 116.
A list of estimation results stored in 6 is displayed on the display screen of the terminal 301 via the input / output processing unit 101, or based on a deletion request input from the terminal 301 via the input / output processing unit 101. Processing such as deleting a predetermined estimation result is performed.

The guarantee content setting unit 104 is for setting the product guarantee, and includes a premium rate storage unit 131 and a guarantee setting content storage unit 132. In this embodiment, the customer selects the terminal 3 from among a plurality of guarantee forms prepared in advance.
One is selected through 01, and the estimated price of the product is increased according to the selected guarantee form and the like. As shown in FIG. 14, the guarantee forms that can be set include three types, A1 to A3, which have different warranty periods and have different warranty periods, and B1 to B4, which have different warranty periods and have a guarantee period of 3 years.
4 types can be selected, and it is possible to add disaster special contract and earthquake special contract respectively if desired.

For example, in the guarantee mode A1, if the purchased product fails or is damaged in a normal use state, 6 from the purchase.
Until the first month, the liability is 0, that is, the repair is free of charge, and until the first year, the liability is 10%, that is, the customer can repair the burden only with 10% of the repair cost, and similarly, until the second year, the liability is 20%.
%, That is, the customer can repair the product at the burden of only 20% of the repair cost. In guarantee form A2, A3,
The period of exemption from liability is extended with respect to the guarantee form A1, and the guarantee form A3 is the most advantageous content to the customer side.

Similarly, in the guarantee mode B1, if the purchased product fails or is damaged in a normal use state, 6 from the purchase.
The liability is 0 until the first month, 10% until the first year, 20% until the second year, and 30% until the third year. The guarantee forms B2, B3, and B4 are the guarantee forms B1. , The period of exemption from liability has been extended,
The guarantee form B4 is the most advantageous content for the customer.

Further, guarantee forms A1 and B1, A2 and B2,
A3 and B3 are different only in the presence or absence of a guarantee up to the third year after the lapse of two years from the purchase, and B1 is more advantageous than A1 and B2 is more advantageous than A2 on the customer side.
Further, regarding each special provision, for example, a disaster special provision is for a disaster other than an earthquake, for example, damage due to a strong wind, etc. within a guarantee range, and an earthquake special provision is for a damage due to an earthquake, etc. within a guarantee range.

The extra rate storage unit 131 stores in advance an extra rate according to each guarantee form and the like. It is desirable that the premium rate be set to a higher value as the guarantee content is advantageous to the customer side so that the charge burden on the customer side is commensurate with the guarantee content. In the present embodiment, the premium rate increases in the order of guarantee forms A1 to A3 and guarantee forms B1 to B4, respectively, and B1 is higher than guarantee form A1 and B2 is higher than A2.
In order to make the premium rate of B3 higher than that of A3, the premium rates for the guarantee modes A1 to A3 and B1 to B4 are 1.00, 1.01, 1.02, 1. 0
2, 1.03, 1.04 and 1.05 are set. In addition, in the case of adding a disaster special contract or an earthquake special contract, it is assumed that 0.01 and 0.01 are further added to each premium rate, and these values are also stored in the premium rate storage unit 131. In addition, the guarantee setting content storage unit 132 stores the guarantee setting content selected and set via the terminal 301.

The composite product processing unit 103 produces the estimation result for each individual product created and stored by the individual product processing unit 102,
Based on the guarantee setting contents set by the guarantee contents setting unit 104 and other various expenses obtained from the database unit 105 described later, for example, personnel expenses, electricity bills, equipment depreciation expenses, packing material expenses, transportation expenses, etc. The product combination rule storage means 121, which performs processing such as creation of an estimate of a composite product in which individual products are combined and output of the estimate result,
It is provided with a product placement processing means 122 and a composite product quotation creating means 123.

The product combination rule storage means 121 is a rule for combining a plurality of individual products (product combination rule).
Is stored in advance and is configured by a hard disk device or the like. The product combination rule is, for example, the type and number of connecting parts required for combining two predetermined individual products,
Alternatively, it is configured by rules such as unnecessary parts because they can be shared between these two individual products. Furthermore, if there is a combination of individual products that cannot be combined with each other, this is also stored as a product combination rule.

The product placement processing means 122 displays an input request screen for the dimensions (for example, full width and full height) of the product placement area via the input / output processing means 101 prior to all processing.
1 is displayed on the display screen of No. 1 and its shape is determined based on the size of the product placement area input from the terminal 301.
01 is displayed on the display screen. Here, the product placement area is
For example, it is a rectangular area for arranging a composite product in which individual products are combined.

Before the calculation of the used parts information by the used parts information calculation means 114 is started, when an individual product is selected, an input request of the arrangement position of the individual product in the product arrangement area is made, for example, at the terminal 301. Is displayed on the display screen and the arrangement position input from the terminal 301 in response to the input request, the arrangement position of the individual product already estimated, and the product combination rule stored in the product combination rule storage unit 121 are displayed. Based on this, it is determined whether the individual product can be arranged. For example, the product combination rule storage unit 121
If a combination of two individual products that cannot be combined left and right with each other is set in the product combination rule stored in, if an arrangement matching the combination is input, an error is issued to the terminal 301. Output.

After the estimation for each individual product is completed, the composite product quotation creating means 123 stores the estimation result for each individual product stored in the product estimation storage means 116 and the guarantee setting content storage section 132. Based on the guarantee setting contents, the premium rate of each guarantee type stored in the premium rate storage unit 131, and the various expenses and the like obtained from the database unit 105, the estimation process of the composite product combining the individual products is performed. Then, the estimation result is output (displayed) in response to the request from the terminal 301.

The database unit 105 stores the employee information necessary for calculating the cost of each product required for the estimation,
It is a database of work time information, product information, etc., and includes data input means 141, database (DB) management means 142, employee information database (DB) 143, work time database (DB) 144, product information database (DB) 145. And so on.

The data input means 141 is for inputting various basic data, and is composed of a keyboard, a mouse, a card reader and the like. Employee information DB143
Is a database of at least employee information relating to product manufacturing, and as shown in FIG. 15, a plurality of data tables such as a personal data table, a salary data table, a social insurance data table, and a work status data table. And the respective data tables are stored in a state of being associated with each other.

The personal data table is for accumulating personal data about each employee, and is set with items such as employee number, name, gender, date of birth, and date of joining the company. In this personal data table, personal data about all employees are entered corresponding to each item, and are appropriately modified as necessary and always kept in the latest state.

The salary data table is for accumulating salary data about each employee, and includes an employee number, basic salary,
Various items such as various allowances (family allowance, postal allowance, commuting allowance, etc.), health insurance premiums, employee pension insurance premiums, taxes (resident tax, income tax, etc.) are set. This salary data table contains
Salary data for all employees is input, for example, on a monthly basis corresponding to each item.

The social insurance premium data table is for accumulating data of social insurance contributions for each employee, in which items such as employee number, health insurance premium, long-term care insurance premium and welfare pension are set. There is. In this social insurance fee data table, the data of social insurance burden for all employees is entered corresponding to each item, and it is corrected as necessary and always kept up to date. It has become.

The work status data table is for accumulating work status data for each employee, and includes the employee number,
Each item such as date, regular working hours, overtime hours, absenteeism, early leave, late arrival, etc. is set. In this work status data table, work status data relating to all employees is collected, for example, every day, weekly, or monthly, and is input corresponding to each item.

As described above, the data tables are associated with each other through the common item of employee numbers. It should be noted that each data table has a DB management unit 142.
Based on an input screen displayed on the display by an input / output control unit 146, which will be described later, each data is input via a keyboard or the like that constitutes the data input unit 141. Of course, data may be input via a card reader or the like.

The work time DB 144 is a database of work time information required for manufacturing individual products or composite products, and includes a work time data table as shown in FIG. Each item such as employee number, group code, work code, product model code, product individual code, work time, etc. is set in the work time data table, and the work time for each employee and each work and the target product Data such as is input in correspondence with each item.

The employee number is the same as that used in the employee information DB 143, and is represented by, for example, a 3-digit numerical code. The group code indicates a group to which each employee belongs, and is represented by, for example, a two-digit numerical code. The work code indicates the type of work related to the production of individual products or composite products, and is represented by, for example, a one-digit numeric code, and is “setup”,
"Processing", "Assembly", "Inspection", "Packing", "Others"
One code is assigned to each of a plurality of work types such as.

The product model code represents a model of an individual product or a composite product related to the work, and is represented by, for example, a 4-digit code, and one code is provided for each model of the individual product or the composite product. Has been assigned. Codes in the range of 0 to 999 are assigned to models related to "individual products" and 1000 to 999 to models related to "composite products."
Codes in the range of 9, for example, are assigned to models for "individual products" and models for "composite products", respectively. For example, codes for ranges of "individual products" or "composite products" are assigned. It is possible to easily determine whether or not.

The product individual code is individually assigned to an individual product or a composite product related to the work, and is represented by, for example, a 5-digit numerical code. The work time is the time required for the work, and is 1 minute, 5 minutes, 1
Input is possible in predetermined time units such as 5 minutes and 30 minutes.

In the work time table, for example, the contents of the work time input card created by each employee for each work are read by the card reader (data input means 141) to input each data. For example, as shown in FIG. 17, this work time input card is designed to fill in data in a mark sheet system for the same six items as the items in the work time data table in addition to the employee name. Here, regarding the working time, the working time is designated by marking one marking field for each integer and one marking field for each decimal point. The data input means 1
Each data may be input to the work time table via a keyboard or the like which constitutes 41.

The product information DB 145 is a database of individual information of individual products and composite products, and as shown in FIG. 18, has an individual product data table and a composite product data table. In the individual product data table and the composite product data table, a large amount of data on individual products and composite products manufactured in the past are accumulated, and various expenses in the estimation process are calculated based on them. There is. In the individual product data table, items such as a product individual code, used part information, and various expenses are set. Product individual code, work time D
It is the same as that used in B144.

The used part information is composed of small items such as a part code, the number of pieces, and dimensions, and each item is set for one or a plurality of parts used in the individual product. Note that only the component code and the number are input for the dimension-invariant parts, and all the component codes, the number, and the dimensions are input for the dimension-variable parts. In the estimate creation process, various expenses of the product of the same type as the product to be estimated (individual product) are extracted based on the used part information.

The miscellaneous expenses are expenses other than the material cost required for manufacturing each individual product, and include personnel expenses obtained based on the employee information DB 143 and the working time DB 144, as well as electricity bills and equipment depreciation expenses. Based on this, the various expense calculation means 147 of the DB management means 142 calculates it.

In the composite product data table, items such as individual product code, individual product model code, and various expenses are set. The product individual code is the same as that used in the work time DB 144. The individual product model code is the same as the model code of the individual product used in the work time DB 144, and one or a plurality of individual product model codes are input corresponding to the individual product used for the composite product. In the estimate creation process, various expenses of the product of the same kind as the product to be estimated (composite product) are extracted based on this individual product model code.

Other expenses include personnel expenses obtained based on the employee information DB 143 and the working time DB 144, electricity costs,
The various expense calculation means 147 of the DB management means 142 calculates it based on equipment depreciation costs, transportation costs, packing material costs, and the like.

The DB management means 142 is the employee information DB 14
3, a work time DB 144, a product information DB 145, and the like for managing each database, and the input / output control means 1
46, various expense calculation means 147, etc. are provided.

The input / output control means 146 uses the employee information DB1.
43, the work time DB 144, the product information DB 145, and the like for controlling the data input to each database and the data output to the outside, and the data input from the data input means 141 is stored in each DB 143, 144, 145. Function, and externally, that is, the product quotation preparation means 115,
And a function of outputting predetermined information from each database such as the employee information DB 143, the working time DB 144, and the product information DB 145 in response to a request from the composite product quotation creating unit 123.

Expense calculation means 147 is a product information DB1.
The various expenses, which are the items of each data table 45, are calculated for each individual product or each composite product based on the employee information DB 143, the working time DB 144, etc., and operate at a predetermined frequency such as once a month. It is like this.

As a procedure for calculating the various expenses by the various expenses calculating means 147, first, based on the employee information DB 143, the working hours in each employee for a predetermined period (for example, one month) and the company-borne expenses (basic salary, allowance, society) for the working hours are calculated. The total of insurance contributions, etc.) is calculated, and the labor cost per unit time for each employee is calculated based on them. And
Based on the labor cost per unit time and the working time DB 144, the labor cost for each product is calculated for each employee, and the labor cost for each product is calculated by summing them.

For example, employee numbers 203, 501, 25
Personnel costs per unit time for employees 1 and 413 are 1
If it is 800 yen, 1900 yen, 2000 yen, and 2100 yen, the labor cost for the product of the product individual code 115 in the work time DB shown in FIG. 16 is 1800 × 0.
5 + 1900 × 1.0 + 2000 × 0.25 + 2000
× 0.5 + 2100 × 0.5 = 5350 yen.

For each product, electricity bill, equipment depreciation cost,
Calculate freight costs, packing material costs, etc. Of these costs, electricity costs, equipment depreciation costs, etc. may be assigned uniformly for each product, or a basic cost per unit time is set for each work and the working time is set to the basic cost. It may be obtained by multiplying. Of course, other methods may be used. As the packaging material cost, for example, a uniform cost may be assigned to each product.

The transportation cost is included in the cost of the composite product, and it is desirable to allocate a fixed amount for each composite product. The freight cost may be changed depending on the location of the delivery destination, but in that case, even for the same complex product, the cost will differ depending on the delivery destination, which is less preferable as data used for later estimation. Absent.

Then, various expenses for each product are obtained by summing up the labor cost, electricity cost, equipment depreciation cost, transportation cost, packing material cost and other costs for each product. The obtained expenses are the individual product data table of the product information DB 145,
Stored in the composite product data table.

Next, the processing procedure by the estimate preparing device Z1 will be described more specifically according to the flowcharts shown in FIGS. Various data must be stored in the database unit 105 in advance when performing the estimate creation process. In particular, the product information DB 145 is assumed to have various expenses calculated by the various expense calculation means 147 for a large number of individual products and composite products manufactured in the past.

In the quotation preparation process, the quotation preparation apparatus Z1 first publishes an input / output page 151 as shown in FIG. 13 on the Web. Customer is terminal 301
Is connected to the Internet and this web page is accessed using a web browser program, the input / output processing means 101 of the estimate creation device Z1 causes the terminal 30
The input / output page 151 shown in FIG. 13 is displayed on the first display screen (step S1).

The input / output page 151 shown in FIG. 13 is roughly divided into three areas: a layout input / output area 152, a product input area 153, and a management input / output area 154. The layout input / output area 152 further includes a layout area size input area 152a for inputting the total width and total height of the product layout area, and a shape model of the product layout area based on the values input in the layout area size input area 152a.
It is divided into an arrangement area shape display area 152b for displaying dimensions.

Further, the product input area 153 further includes a product selection input area 153a and a parameter input area 153b whose display content changes according to the selected individual product.
It is divided into and. The product selection input area 153a is provided with a selection box 160 in which names of a plurality of selectable individual products are registered in advance, and a list of individual product names is displayed by mouse operation. It is easy to select. Further, for example, in the parameter input area 153b, a product estimate execution button 161 for executing an estimate of an individual product is provided.

In the management input / output area 154, in addition to the list display section 162 that displays a list of individual products for which the estimation process has already been performed and the estimation result has been stored in the product estimation storage means 116, the change button 163 and the delete button 163 are deleted. Button 16
4, a composite product estimate execution button 165, an estimate display button 166, and a warranty content setting button 167 are provided respectively.

The customer first inputs the values of the total width Wa and the total height Ha of the product arrangement area into the arrangement area size input area 152a of the arrangement input / output area 152 using the keyboard of the terminal 301 or the like. Here, for example, when there is no particular limitation in the height direction of the product placement area, the input of the value of the total height Ha can be omitted. Arrangement area size input area 152
When a value is input to a (step S2 → Yes), based on the input value, the product placement processing unit 122 two-dimensionally displays the shape model of the product placement area in the placement area shape display area 152b. S3).

Next, the customer selects the product selection input area 15
One individual product is selected by the selection box 160 of 3a. When the individual product is selected in the selection box 160 (step S4 → Yes), the parameter input form corresponding to the selected individual product is displayed in the parameter input area 153b (step S5). FIG. 13 shows an example in which the folding telescopic door is selected in the selection box 160 and the parameter input form corresponding to the folding telescopic door is displayed in the parameter input area 153b.

Subsequently, the customer inputs the arrangement position of the individual product selected in the selection box 160 using the shape model of the product arrangement area displayed in the arrangement area shape display area 152b. For example, when it is desired to arrange the individual product at the lower right of the product arrangement area, the right boundary line BR and the lower boundary line BB of the shape model may be clicked with the mouse. Also,
To place an individual product on the right side in the product placement area, the right boundary line BR, the upper boundary line BT, and the lower boundary line BB of the shape model may be clicked with the mouse. At this time, since the total height H of the individual product becomes equal to the total height Ha of the product arrangement area, the product arrangement processing unit 122 sets the value of the total height Ha of the product arrangement area in the total height input field d of the parameter input area 153b. It is convenient to insert it automatically. Similarly, if all the boundary lines BR, BL, BT, BB are clicked, the individual products are arranged so as to match the product arrangement area. In this case, the product placement processing means 122 sets the total width W of the product placement area in the total width and total height input fields c and d, respectively.
The values of a and the total height Ha may be automatically inserted. In this case, the composite product is composed of one individual product.

In the state where one or more individual products are already arranged, when a new arrangement position of the individual product is input (when the second and subsequent steps S4 to S16 are repeated), the arrangement area shape display area is displayed. Since the shape of another individual product is already displayed on the shape model of the product placement area displayed in 152b in step S8, which will be described later, the boundary line indicating the shape of the individual product along with the boundary line of the product placement area. (For example, BT1, BL1 in FIG. 13) may be used to input the arrangement position. For example, when the first individual product is already placed at the lower right of the product placement area and the next individual product is placed at the lower left of the product placement area so as to be adjacent to the first product. Includes BL1, BB, BL
Just click on one of the borders with the mouse.

At this time, it is desirable that the size of the newly placed individual product is automatically obtained based on the size of the product placement area and the size of the individual product placed earlier. For example, when a new individual product is placed at the lower left of the product placement area so as to be adjacent to the previously placed individual product, three boundary lines BL1, BB, BL are clicked with the mouse. The total width of the individual product to be newly arranged may be a value obtained by subtracting the total width of the individual product arranged earlier from the total width of the product arrangement area. Also, the total height of the newly placed individual product may be set to the same value as the total height of the individually placed individual product, for example.

When one part can be shared between adjacent individual products, the size of the newly arranged individual product may be a value including the size of the shared part. For example, when the left column of the individual product placed earlier is shared as the right column of the newly placed individual product, the total width of the newly placed individual product is the shared parts ( It should be a value that includes the width of the left column of the product. The method of inputting the arrangement position of the individual product is not limited to the method of clicking the boundary line of the shape displayed on the screen with the mouse, and other methods may be used.

When the arrangement position of the individual product is input (step S6 → Yes), the product arrangement processing means 122 causes
Based on the product combination rule stored in the product combination rule storage means 121, it is determined whether or not the combination of the newly arranged individual product and the already arranged individual product is proper. If the combination of the newly placed individual product and the already placed individual product is set in the product combination rule as a combination that cannot be combined with each other, after an error is output to the terminal 301, The process returns to step S4 and waits for selection of individual products. When arranging the first individual product, the determination in step S7 may be made unconditionally, and the process may proceed unconditionally to the next step S8.

When it is judged that the arrangement of the individual products is proper (step S7 → Yes), the product arrangement processing means 122.
Thus, the shape of the individual product corresponding to the input placement position is hypothetically displayed, for example, by a broken line on the shape model of the product placement area displayed in the placement area shape display area 152b (step S8). FIG. 13 shows a display example in which the right boundary line BR and the lower boundary line BB of the shape model are clicked with the mouse in order to arrange the individual products in the lower right part of the product arrangement area. In this case, since the full width and full height values of the individual product have not been determined yet, the broken line indicating the upper boundary line BT1 and the left boundary line BL1 of the individual product may be displayed at a temporary appropriate position, for example. The display of the shape of the individual product may be performed after the parameter values such as the total width W and the total height H are input in the next step. Note that step S4
~ S8 is an example of the product placement processing step.

Next, the customer is in the parameter input area 1
The values of each parameter and the like are input from the parameter input form of 53b. Parameter input area 15 shown in FIG.
In 3b, in addition to the parameters of the total width W, the total height H, and the number of doors N (input fields c, d, and e, respectively), left opening (L) / right opening (R) (input field a), door surface Format (input field b)
Each value of can be entered. The type of the door surface can be selected from 1 type: horizontal lattice, 2 type: double lattice lattice, 3 type: galleries, 4 type: vertical lattice, but here, 3 type galleries. It is assumed that the type has been selected. Note that when the values of the total width W and the total height H are input, the input total width W and total height H are added to the shape of the individual product that is hypothetically displayed in the arrangement area shape display area 152b.
The value of should be reflected. At this time, the broken line display indicating the assumption may be changed to, for example, the solid line display indicating the confirmation.

After inputting parameter values and the like (step S
9 → Yes), if the customer clicks the product estimation execution button 161 with the mouse (step S10 → Yes),
The input / output processing unit 101 checks whether each input value is an appropriate value. For example, whether the number N of doors is an odd number, or whether the values of the total width W and the total height H are within the range of the total width Wa and the total height Ha of the product placement area,
Each item such as is checked. Further, for example, when a constraint condition such as “the value of the total height H is limited to the value represented by the expression (2a)” is set in advance, whether the input value conforms to this constraint condition or not. Is also checked. If it is determined that the input value is not appropriate (step S11 → No), an error output to that effect is output on, for example, the screen of the terminal 301 (step S12), and the process returns to step S9. Waiting for parameter input.

When it is determined that the input parameter values are appropriate (step S11 → Yes), the used component information calculating means 114 subsequently causes the parameter values W,
H, N, and component determination rules (a quantity rule and a dimension rule) stored in the component determination rule storage unit 111,
Based on the basic size stored in the basic size storage means 112, the used part information (the number and, in the case of the variable size part, the size) of each part used for the individual product is calculated (step). S13: Used parts information calculation step). For example, since the number n25 of the louver members 25a is set by the equation (2) as the number rule, the parameter H and the upper frame 4 and the horizontal frame stored in the basic dimension storage means 112 are included in the equation (2). Sectional height h4 with material 24
It can be calculated by substituting h24, the arrangement pitch p25 of the louver members 25a, and the standard value d of the sum of the gaps d1 and d2.

As for the number n23 of the vertical frame members 23, the equation (1) is set as the number rule.
It can be calculated by substituting the value of the parameter N into the expression. Further, since the length t23 of the vertical frame member 23 is set by the equation (6) as a dimension rule, the number n25 of the louver members 25a calculated based on the equation (2) is added to the equation (6). , The arrangement pitch p25 of the louver members 25a stored in the basic dimension storage means 112, and the horizontal frame member 24
It can be calculated by substituting the cross-sectional height h24 of each. The numbers and dimensions of the other parts are calculated in the same manner. Here, when one part is shared between two individual products, as in the case where the left column of the individual product that has already been quoted is shared as the right column of the individual product to be newly estimated. At this point, the shared parts should be included in both individual products. This is to simplify the process (step S24 described later) in the case of deleting the estimation result of any of the individual products later.

When the used part information of each part is calculated, the product estimate creation means 115 then calculates the material cost and cost of the individual product and creates the price estimate of the individual product based on them. (Step S14: Product estimate creation process). First, the material cost of the individual product is calculated based on the used part information and the unit price of each part stored in the part unit price storage means 113. Here, regarding the variable dimension component, the dimension calculated by the used component information calculation unit 114 is multiplied by the price per unit length stored in the component unit price storage unit 113, and the product is multiplied by the number. Calculate the price of parts.

For example, the size (length) of the upper frame 4 is set to X (m
m), the weight per unit length is Y (g / mm), the price per unit weight of aluminum is Z (yen / g), and the number is M, the amount c4 of the upper frame 4 is c4 = M It becomes xXxYxZ. Further, the cost of waste of cut-out parts made to order may be added. As for the dimension-invariant parts, the price of the part is calculated by multiplying the number calculated by the used-part information calculating means 114 by the price per unit quantity stored in the component unit price storage means 113. . Once the price for each part is obtained, the material cost is obtained by summing the prices for each part.

Further, various expenses of each individual product are calculated based on the product information DB 145 of the database unit 105.
That is, the product estimate creation means 115 is the DB management means 1
Product information DB 14 via the input / output control means 146 of 42
5 is accessed, and one or more individual products that are the same as or similar to the used parts information related to the estimated product are extracted from each individual product stored in the individual product data table, and the predetermined statistics regarding those expenses are calculated. Processing,
For example, the expenses of the estimated product are calculated by obtaining the average.

The product estimate preparing means 115 totals the material cost and various expenses obtained as described above to calculate the estimated price of the individual product. Product quotation preparation means 11
The product quotation result obtained in step 5 is stored in the product quotation storage means 116 (step S15), and the product quotation management means 117 indicates the name of the individual product for which the quotation processing has been performed in the management input / output area 154. Is displayed on the list display unit 162 of. Product quotation storage means 11
In 6, a value such as a parameter value used for calculating the estimation result is stored together with the estimation result. The above steps S4 to S15 are repeated for the number of individual products to be combined with the composite product.

Here, in the middle of the iterative processing of steps S4 to S15, the setting contents are changed from the terminal 301 and the estimation is performed again for the individual product for which the estimation processing has already been performed, or the estimation result is displayed. You can also delete it. The procedure of this individual product estimate editing process will be described with reference to FIG. Steps S4 to S
If any of the individual products displayed in the list display portion 162 is selected during the processing of step 15 (step S21 → Y).
es), and then the processing corresponding to the pressed button is performed.

When the change button 163 is pressed (step S22 → Yes), the product estimate management means 117
Thereby, the parameter value and the like corresponding to the estimation result of the individual product selected in step S21 are read from the product estimation storage means 116, and the parameter input area 15
3b is displayed (step S25), and a state for waiting for correction input of parameter values and the like is entered (step S26). afterwards,
Parameter values etc. are modified by the customer (step S2
6 → Yes), when the product estimate execution button 161 is pressed (step S27), the input / output processing means 101 checks whether or not each input value is an appropriate value, as in step S11 described above (step S27). Step S28).
If it is determined that the input value is not appropriate (step S28 → No), an error output to that effect is output, for example, on the screen (step S29), and the process returns to step S26 to input the parameter. It will be in a waiting state.

On the other hand, when it is determined that the input parameter values and the like are appropriate (step S28 → Yes), the used part information calculation means 114 subsequently uses the used part information of each part used for the individual product. After calculating (step S30), the price estimate of the individual product is created by the product estimate creating means 115 (step S3).
1). The processing contents of steps S30 and S31 are the same as those of steps S13 and S14 described above. The calculated price estimate is overwritten and updated with the uncorrected estimate result stored in the product estimate storage means 116 (step S32).

When the delete button 164 is pressed after any one of the individual products is selected in the list display section 162 (step S22 → No, step S23 → Yes), the product estimate management means 117 causes the step S21. The estimation result of the individual product selected in (4) is deleted from the product estimation storage means 116 (step S24), and at the same time, the display of the individual product is deleted from the list display unit 162.

Further, the guarantee content can be set in the middle of the repeating process of steps S4 to S15 or after the series of processes. The procedure of the setting process regarding the guarantee content will be described with reference to FIG. When the guarantee content setting button 167 in the management input / output area 154 is pressed during the repeating process of steps S4 to S15 or after the series of processes (step S4).
41 → Yes), by the input / output processing means 101, the terminal 3
The guarantee content setting page 171 as shown in FIG. 14 is displayed on the display screen of 01 (step S42).

Each guarantee form A1 to A3 and B1 to B4 is displayed on the guarantee content setting page 171, and one of these seven guarantee forms can be selected by a check button 172 provided for each. There is. Regarding the special contract, three of "No special contract", "Disaster special contract" and "Earthquake special contract" are displayed together with the check button 172, and "No special contract",
Alternatively, it is possible to select at least one of “disaster special contract” and “earthquake special contract”. At the time of opening the warranty content setting page 171, the most basic warranty content,
For example, the guarantee mode A1 and “no special contract” may be preselected.

When any of the guarantee modes and the special contracts is selected on the guarantee content setting page 171, the setting button 173 on the page 171 is pressed (step S43 → Ye).
s), the guarantee setting content is acquired, and the guarantee content setting unit 1
No. 04 is stored in the warranty setting content storage unit 132 (step S44: warranty setting content acquisition step). If the above guarantee content setting process has not been performed, that is, if the overall estimate execution button 165 is pressed without pressing the warranty content setting button 167, the most basic guarantee content, for example, the guarantee form. A1 and “No special contract” may be automatically set, or an error is output at the stage when the total estimation execution button 165 is pressed before setting the guarantee content, and the guarantee content is set. You may be prompted.

Step S for one or more individual products
After the processes of 4 to S15 are repeatedly performed, and if necessary, the process of changing or deleting the estimation result of each individual product and the process of setting the guarantee content are performed, and then the customer presses the composite product estimation execution button 165. And (step S16 → Y
es), the composite product estimate creation unit 123 creates an estimate of the composite product in which the individual products are combined (step S17: composite product estimate creation step). The estimate of the composite product is further set by adding up the estimate results of the individual products stored in the product estimate storage means 116, adding the prices of the connecting parts used for combining the individual products, various expenses, etc. It is obtained by multiplying the extra rate according to the guarantee content.

Here, various expenses are stored in the database unit 105.
It is calculated based on the product information DB 145. That is, the composite product quotation creation unit 123 accesses the product information DB 145 via the input / output control unit 146 of the DB management unit 142, and selects the estimated composite product from among the composite products stored in the composite product data table. Of one or a plurality of composite products having the same or similar individual product groups as those used in the above, and performing predetermined statistical processing on their various expenses, for example, by averaging them, to estimate the various composite products. Calculate expenses.

Further, the premium rate according to the guarantee content is the guarantee content (guarantee form and special provision) stored in the warranty setting content storage unit 132 and the premium rate for each warranty content stored in the premium rate storage unit 131. Required from. For example, the guarantee content stored in the guarantee setting content storage unit 132 is a condition that there is a guarantee form A2 (additional rate of 1.01), a disaster special contract, and an earthquake special contract (additional value of each additional rate is 0.01). In this case, the premium rate is 1.03 (= 1.01 + 0.01 + 0.0
1), and the estimation results of the individual products A and B stored in the product estimation storage unit 116 are 10000 respectively.
If the yen, 20,000 yen, and various expenses are 8,000 yen, the estimated amount of the composite product AB in which the individual products A and B are combined is 39140 yen (= (10000 + 20000 + 8
000) × 1.03).

If there are parts shared among a plurality of individual products that make up a composite product and the shared parts are included in the estimated price of each product,
It is necessary to subtract the price of the shared parts (excess parts) that have been added. It should be noted that the product combination rule storage unit 121 stores the types, numbers, and prices of the connected parts used for combining the individual products, and the parts that can be shared among the individual products.
Are preset in the product combination rule stored in. The quotation result of the composite product thus obtained is arranged in the format of the quotation and is output to the display screen of the terminal 301 by the customer pressing the quotation display button 166 (step S18). An example of the output quote is shown in FIG.

The quotation shown in FIG. 19 shows the individual products A,
It is about the composite product ABC consisting of B and C,
The guarantee contents are set to guarantee form A2, disaster special contract and earthquake special contract. In this example, the estimated prices of the individual products A, B, and C obtained by the individual product processing unit 102 are 70,000 yen × 2, 50,000 yen, and 30,000 yen, respectively, and the quote includes the guarantee contents. The amount of money multiplied by the additional rate of 1.03 (= 1.01 + 0.01 + 0.01) is described. As described above, in the quotation shown in FIG. 19, only the amount including the guarantee fee is described, and the customer does not know the extra amount according to the content of the guarantee. It may be described separately from the price of the product.

Next, examples of composite products to be quoted by the quote creating device Z1 and individual products constituting them will be shown. 20 is an improved product of the folding telescopic door shown in FIGS. 7 to 10 (folding telescopic door with door door 20
1), and the door door is provided on the door stop side of the telescopic door. The parameters of this product can be configured by, for example, the total width, the total height, the width of the door door portion (or the width of the telescopic door portion), and the number of telescopic doors. Further, as the items other than the parameters, the type of the door door, the type of the door surface of the telescopic door, and the like may be set.

Note that the foldable telescopic door with door door shown in FIG. 20 can be considered not as one type of product but as two types of products, that is, a combined product of the foldable telescopic door and the door door. In this case, first, the estimation process (steps S4 to S15) for the foldable telescopic door may be performed, and then the door door may be placed on the foldable telescopic door in an overlapping manner.
In this case, as a parameter of the folding type telescopic door, for example, the width of the single door is required in addition to the parameters shown in FIG. Further, since the width of the door portion of the folding type telescopic door is determined first, the width of the door door arranged later is automatically determined.

FIG. 21 shows a folding telescopic door 20 with a door door.
The left side of 2 shows a composite product in which a door 211 is combined. The foldable telescopic door with door door 202 is the same as the foldable telescopic door with door door 201 shown in FIG. 20 except that the type of the door door and the type of the door surface of the telescopic door are changed. is there. For the door 211, the width and height may be set as parameters, and the type of the door surface may be set as an item other than the parameters. Similarly, FIG. 22 shows a composite product in which the door door 212 is connected to the right side of the folding telescopic door with door door 203.

FIG. 23 shows an example in which a pantograph type telescopic door 204 is used in place of the folding type telescopic door 203 in an arrangement similar to that of FIG. The parameters of the pantograph-type telescopic door 204 include the width, height, and vertical bar 2
The number and height of 04a can be considered.

FIG. 24 shows a composite product in which the folding telescopic door 205 is provided inside the three-way gate 221. In this case, the suspension base side pillar and the door stop side pillar of the folding type expandable door 205 are the vertical frame portions 221 a, 2 of the three-way gate 221.
It can be omitted because it can be shared by 21b. Therefore, when creating the estimate of the composite product in step S17,
For example, the estimated price of the three-way gate 221 and the estimated price of the folding telescopic door 205 (including the suspension base and the door stop side support) and the price of the connecting parts used to combine the two individual products are summed up. Foldable telescopic door 2
The price is calculated by subtracting the price of the suspension base side pillar and the door stop side pillar of No. 05, and then multiplying by the premium rate for the guarantee content.

The individual products that make up the composite product are
It is not necessary that all of them are made-to-order products, that is, those whose dimensions and the like can be freely set by parameter input.
For example, various ready-made products including products of other companies may be used, and the ready-made products and the made-to-order products may be combined.

FIG. 25 shows a composite product in which the roof portion 231 (excluding the front decoration 231a) of another company's product and the leg portion 232 are combined, and the shapes of the front decoration 231a and the leg portion 232 of the roof portion 231 are changed. Two examples are shown. In this example, since the roof portion 231 is a product of another company, the dimensions and the like are fixed, and the front decoration 23 of the roof portion 231 is fixed.
The shapes and dimensions of the 1a and the leg portions 232 can be freely set as parameters within a range suitable for the roof portion 231.

FIG. 26 shows a fence lower body 241 and a gate post 2.
42, a sliding door 243, and an example of a composite product in which a fence lower body 241 and a fence body 244 attached to the upper portion of the sliding door 243 are combined are shown. In this example, for example, the fence 244 is a product of another company and the dimensions are fixed,
The dimensions of the fence lower body 241, the gate post 242, the sliding door 243, etc. can be freely set as parameters within a range suitable for the fence body 244.

When a composite product including an off-the-shelf product such as another company's product is to be estimated as in the above example, the off-the-shelf product such as another company's product is registered in the selection box 160 of the product selection input area 153a. The dimensions of the ready-made product may be displayed instead of the parameter input form for the ready-made product.

As described above, according to the quotation preparation method according to the present embodiment, from the terminal 301 connected to the Internet, the total width W and the total height, which are the main dimensions of the product such as the folding telescopic door to be estimated, are measured. If H and the number N of doors which are intermediate parts are input as parameters, the product determination will be performed based on preset part determination rules, basic part information, part unit prices, and various costs of products manufactured in the past. The price quote is automatically created and the terminal 301
Since it is automatically output to the quotation, the quotation contractor can reduce the manpower required to create the quotation.
The cost related to the estimation process can be significantly reduced. Further, the customer on the quotation request side is not restricted by the time or the number of quotation, and can freely obtain the quotation as many times as he / she likes.

Further, at the time of price estimation, the contents related to the product guarantee can be set from the terminal 301, and the price estimate is created based on the set contents, so that the customer side can make a more concrete and realistic estimate. Based on this, the product configuration, etc. can be examined.

Also, regarding a composite product in which a plurality of these products (individual products) are combined, the estimation result for each individual product, the product combination rule including the price information of the parts necessary for combining the individual products, and the manufacturing in the past. Based on the various costs of the combined product, for example, add the price of parts required for combining each individual product and various costs to the total estimated price of each individual product, and then add a surcharge rate according to the warranty details. It is possible to easily estimate by multiplying by.

Furthermore, when there are parts that can be shared among a plurality of individual products that form a composite product, for example, from the total of the estimated prices of the individual products, the price of the parts required for combining the individual products, The estimated price of the composite product is calculated by subtracting the price of the surplus parts due to the sharing of parts and multiplying it by the surcharge rate according to the guarantee content, so it is possible to accurately calculate the estimate when sharing parts between products. .

In the product placement processing steps S4 to S8, the placement position of each individual product on the product placement area where the composite product is placed is determined by the customer's terminal 30 via the network.
Since the composite product is estimated based on the arrangement position of each individual product, the arrangement relationship of each individual product can be reflected in the estimation. Here, in the product placement processing steps S4 to S8, the shape model of the product placement area is displayed based on the input main dimensions of the product placement area, and the placement position of each individual product is input on the shape model. Therefore, the customer can easily input the arrangement position of each individual product on the screen of the terminal 301.

Further, the estimation result of each individual product created in the product estimation preparing step S14 is stored in the product estimation storage means 116, and the estimation result of any individual product stored in the product estimation storage means 116 is stored. , Can be deleted from the customer's terminal via the network, or the estimation result of any individual product stored in the product estimation storage means 116 can be updated to the estimation result obtained by changing the parameter value. Therefore, the customer can obtain the final estimate of the composite product while repeating trial and error for the estimate for each individual product.

FIG. 27 exemplifies the second embodiment of the present invention, and manufactures a product in the composite product processing section 103 based on the used part information calculated by the used part information calculation means 102 in step S13. An example including a drawing creating unit 124 for creating a drawing is shown. Drawing creation means 12
In FIG. 4, for each individual product such as a foldable telescopic door, basic drawings such as a component drawing and an assembly drawing of the components that make up the individual product are stored in advance, and each component calculated in step S13 is stored. It is sufficient to read the dimensions, replace only the dimension display on each drawing, and output (drawing creation process). As described above, if only the dimension display is replaced without changing the drawing shapes of the parts and the like, the configuration of the drawing creating unit 124 can be simplified. Of course, if the basic drawing stored in advance in the drawing creating unit 124 has a shape in which the drawing shape changes in association with the value of each dimension, the configuration of the drawing creating unit 124 becomes complicated, but more accurate. It is possible to create various manufacturing drawings.

FIG. 28 shows an example of a part drawing output by the drawing creating means 124. FIG. 28 shows the louver member 25a.
2 is an example of the component diagram of FIG. In this figure, the length dimension value "515" calculated in step S13 is displayed on the basic drawing of the louver member 25a. In this way, if the manufacturing drawing of the product can be created based on the part dimension calculated in step S13, when the order is actually decided, the manufacturing of the product corresponding to this estimation result can be performed quickly and accurately. It is possible to

Although each embodiment of the present invention has been described in detail above, the present invention is not limited to this embodiment, and various modifications can be made without departing from the spirit of the present invention.
For example, it is possible to store a surcharge instead of a surcharge rate according to the setting content related to the product guarantee, and add the estimated amount of each product and the surcharge to calculate the final estimated amount.

It is needless to say that the types and contents of guarantee forms, the contents of special cases, etc. shown in the embodiments are merely examples, and can be set arbitrarily.
The payment method of the fee (cash on delivery, bill, transfer, credit card, etc.) can be selected, and a fee or the like according to the selected payment method may be added to the estimated content.

The structure of each table provided in the employee information DB 143, work time DB, and product information DB 145 is an example, and addition and deletion of items are arbitrary. It is sufficient that at least the information necessary for calculating miscellaneous expenses is included. As for various expenses, personnel expenses, electricity charges, equipment depreciation expenses,
Other than the packing material cost and the transportation cost may be included, or one or more of them may be deleted.

Further, in the second embodiment, the drawing creating means 124 is not mounted in the estimation creating apparatus Z1, but the dimensions of each component calculated in step S13 are
The drawings may be created by handing over to another CAD system or the like. Further, the quotation preparation device Z1 can be applied not only to exterior products such as gates and fences, but also to various products such as office products such as cabinets and partitions.

[0124]

According to the present invention, for a product manufactured by a plurality of parts, a price estimate is created according to the value of a predetermined parameter such as a main dimension input from the customer's terminal through the network, and the customer's terminal A method for producing an estimate using a computer which outputs the unit price of each component to the component unit price storage means 113 in advance and the basic size storage means 11
2 shows the basic dimensions related to the shape of each part and the layout of each part.
In the part decision rule storage means 111, a part decision rule consisting of the relationship between the number of each part and the parameter at the time of manufacturing the product and the part whose size changes according to the parameter value is further defined by the relationship between the size and the parameter, Expenses related to a plurality of products manufactured in the past are stored in the product information database 145, and the parameter values input from the customer's terminal via the network and the components stored in the component determination rule storage unit 111. Based on the determination rule and the basic size stored in the basic size storage means 112, at least the number of each part used in the product is included, and the size of the part whose size changes according to the parameter value is further determined. Used component information calculation step S13 for calculating the used component information including the used component information calculation step S1
Used component information calculated in 3 and component unit price storage means 113
Based on the material cost obtained by the unit price of each part stored in the product and the various expenses stored in the product information database 145, a product estimate creating step S14 for creating a product price estimate and the customer terminal A guarantee setting detail acquisition step S44 for acquiring setting details relating to product guarantee via a network is provided, and the product price estimate obtained in the product estimate creation step S14 and the product guarantee setting obtained in the guarantee setting detail acquisition step S44. Since the final price quote is created based on the content, the quote ordering side does not need the manpower for creating the quote, and the quote requesting customer's quote according to his or her desired conditions. Can be freely obtained.

[Brief description of drawings]

FIG. 1 is a block diagram of a quote creating device according to a first embodiment of the present invention.

FIG. 2 is a block diagram of a system configuration showing the first embodiment of the present invention.

FIG. 3 is a flowchart of an estimate creation processing procedure according to the first embodiment of the present invention.

FIG. 4 is a flowchart of an estimate creation processing procedure according to the first embodiment of the present invention.

FIG. 5 is a flowchart of a product quotation edit processing procedure according to the first embodiment of the present invention.

FIG. 6 is a flowchart of a guarantee content setting process procedure according to the first embodiment of the present invention.

FIG. 7 is a front view of a foldable telescopic door as an example of a product.

FIG. 8 is a plan view of a foldable telescopic door as an example of a product.

9 is an enlarged sectional view taken along line XX in FIG.

10 is an enlarged cross-sectional view taken along line YY in FIG.

FIG. 11 is a cross-sectional view showing a cross-sectional shape and an arrangement state of a louver member of a foldable telescopic door.

FIG. 12 is an explanatory diagram showing the relationship between the total height H of the foldable telescopic door and the cross-sectional height of each component.

FIG. 13 is an example of an input / output page of the estimate creation device.

FIG. 14 is an example of a guarantee content setting page of the quote creating apparatus.

FIG. 15 is an explanatory diagram showing the structure of an employee information database.

FIG. 16 is an explanatory diagram showing a configuration of a work time database.

FIG. 17 is an explanatory diagram showing a configuration of a work time input card.

FIG. 18 is an explanatory diagram showing the structure of a product information database.

FIG. 19 is an example of a quote output by the quote creating apparatus.

FIG. 20 is a plan view and a front view of a foldable telescopic door with a door door as an example of a product (or a composite product).

FIG. 21 is a plan view and a front view showing an example of a composite product.

22A and 22B are a plan view and a front view showing an example of a composite product.

23A and 23B are a plan view and a front view showing an example of a composite product.

FIG. 24 is a front view showing an example of a composite product.

FIG. 25 is a perspective view showing an example of a composite product including products of other companies.

FIG. 26 is a plan view and a front view showing an example of a composite product including products of other companies.

FIG. 27 is a block diagram of an estimate creation device showing a second embodiment of the present invention.

FIG. 28 is an example of a component diagram output by the drawing creating means according to the second embodiment of the present invention.

[Explanation of symbols]

111 parts determination rule storage means 112 Basic Dimension Storage Means 113 unit price storage means 116 product estimate storage means 121 product combination rule storage means 145 Product Information Database S4 ~ S8 Product placement process S13 Used parts information calculation process S14 Product estimate creation process S17 Composite product quotation preparation process S44 Guarantee setting content acquisition process

Claims (12)

[Claims] 1. A computer for producing a price estimate for a product manufactured from a plurality of parts in accordance with a value of a predetermined parameter such as a main dimension input from a customer's terminal via a network and outputting the price estimate to the customer's terminal. Is a method for creating a quotation using a component unit price storage means (1
13) The unit price of each part is stored in the basic dimension storage means (112).
The basic dimensions relating to the shape of each component and the arrangement of each component, the dimensions change according to the relation between the number of each component and the parameter at the time of product manufacturing in the component determination rule storage means (111), and the parameter value. For the parts to be stored, the part determination rule consisting of the relationship between the dimensions and the parameters is stored, and the expenses related to the plurality of products manufactured in the past are stored in the product information database (145). At least based on the values of the parameters input via the network, the component determination rule stored in the component determination rule storage means (111), and the basic dimensions stored in the basic dimension storage means (112). Includes the number of each part used in the product, and further includes the size of parts that change in size according to the parameter value. Used part information calculation step (S13) for calculating the used part information, used part information calculated in the used part information calculation step (S13), and unit price of each part stored in the part unit price storage means (113) Material cost obtained by
5) A product quotation creating step (S14) of creating a price quotation for the product based on the expenses stored in
Warranty setting content acquisition step (S44) of acquiring the setting content related to product warranty from the customer's terminal via the network
And a final price estimate based on the product price estimate obtained in the product estimate creation step (S14) and the product guarantee setting content obtained in the warranty setting content acquisition step (S44). A method for creating an estimate characterized by creating. 2. The product information database (145) stores the used part information of past products in relation to various expenses related to a plurality of products manufactured in the past, and the product estimate creating step. (S14) extracts a past product that is the same as or similar to the product relating to the price estimation based on the used component information of the product relating to the price estimation and the used component information relating to a plurality of past products, and The cost preparation method according to claim 1, wherein the cost costs of the product relating to the price estimation are calculated based on the extracted cost costs of the product in the past. 3. A product combination rule storage means (12) in advance.
In 1), a product combination rule including price information of parts required for combination of a plurality of predetermined products is stored, and the estimation result of one or a plurality of products obtained in the product estimation creation step (S14) is stored. , The product combination rule storage means (12
Based on the product combination rule stored in 1), the expenses stored in the product information database (145), and the product warranty setting content obtained in the warranty setting content acquisition step (S44), 3. The method for creating a quote according to claim 1, further comprising a composite product quote creating step (S17) for creating a price quote for a composite product in which one or a plurality of products are combined. 4. The product information database (145) stores information on one or a plurality of products constituting a past composite product in relation to various expenses related to a plurality of composite products manufactured in the past. In the product quotation creation step (S14), the price estimation composite process is performed based on one or a plurality of products composing the price estimation composite product and one or a plurality of past composite product products. 4. The past composite product which is the same as or similar to the product is extracted, and the composite product expenses associated with the price estimation are calculated based on the extracted past composite product expenses. How to create a quote. 5. The composite product quotation creating step (S1)
In 7), an estimated price of one or a plurality of products forming the composite product, a price of parts necessary for combining a plurality of predetermined products forming the composite product, various expenses related to the composite product, Guarantee setting content acquisition process (S44)
The estimate creation method according to claim 3 or 4, wherein the estimate price of the composite product is calculated based on the extra amount according to the setting content related to the product guarantee obtained in (4). 6. The product combination rule storage means (121)
In step S17, a product combination rule including information of parts that can be shared among a plurality of predetermined products is stored, and the composite product is configured in the composite product estimate creation step (S17).
Or, an estimated price of a plurality of products, a price of a part required to combine a plurality of predetermined products forming the composite product, and a surplus part by sharing parts among a plurality of predetermined products forming the composite product 6. The estimated price of the composite product is calculated based on the price of the composite product and the premium according to the setting content related to the product warranty obtained in the warranty setting content acquisition step (S44). How to create a quote. 7. Product placement processing steps (S4) to (S4) for allowing the placement position of each product on the product placement area where the composite product is placed to be entered from the customer's terminal via the network.
8), and the composite product quotation preparation step (S17)
7. The estimate creation according to claim 3, wherein the estimate of the composite product is performed based on the placement position of each product obtained in the product placement processing steps (S4) to (S8). Method. 8. The product placement processing steps (S4) to (S)
8. In 8), the shape model of the product placement area is displayed based on the input main dimensions of the product placement area, and the placement position of each product is input on the shape model. How to create a quote described in. 9. The product quotation storage means (116) stores the quotation result of each product created in the product quotation creation step (S14), and any product stored in the product quotation storage means (116). 9. The method for creating a quotation according to claim 1, wherein the estimation result of the product can be deleted from the customer's terminal via the network. 10. The product estimate creation step (S14)
The value of the parameter used for the estimation together with the estimation result of each product created in 1. is stored in the product estimation storage means (116), and the estimation of any product stored in the product estimation storage means (116) is performed. The estimation method according to claim 1, wherein the result can be updated to an estimation result obtained by changing the value of the parameter. 11. The used part information calculation step (S13)
The method for preparing an estimate according to any one of claims 1 to 10, further comprising a drawing creating step for creating a drawing based on the dimensions of the respective parts calculated in (1). 12. The drawing creating step creates a drawing by replacing only the dimension display of a basic drawing created in advance with the dimension calculated in the used part information calculating step (S13). The method for creating an estimate described in 11.