KR20180000814A - System for providing estimate sheet calculated automatically - Google Patents

Abstract

The present invention relates to a system for providing an automatic quotation calculation service. More specifically, in order to calculate an estimate generated in the machining process of an applied product, the unit price, the material, and the specification of each component are inputted, and the quotient can be automatically calculated based on the unit price. The automatic calculation of estimating service which makes it easy to make individual revisions easily and to output the result of cost analysis calculation in report format so as to analyze the profits of the inside room And the like.
To this end, the present invention includes a process cost, a bending ratio, a material cost, a raw material purchasing unit price, and a processing cost applied to a cutting machine (CNC (computer numerical control)) to calculate an estimate required for processing including cutting of an applied article A unit price input module for inputting a unit price required for a quote calculation; A drawing data extraction module for drawing a drawing file from the design drawing program and extracting a numerical value including a specification of the component of each drawing; The detailed information is output by performing operations corresponding to the items including item, standard, thickness, material, and quantity for each component by using the values input to the unit price input module and the values extracted from the drawing data extraction module. An information output module; A quotation generation module for generating a quotation by performing an operation corresponding to an item of the quotation form using an input value extracted from the unit price input module and the drawing data extraction module; A component list providing module that provides a list including images, specifications, and materials of each component using the values input to the unit price input module and the values extracted from the drawing data extraction module; And a cost analysis data output module for performing a calculation corresponding to the cost analysis item using the input values extracted from the unit price input module and the drawing data extraction module and outputting the cost analysis calculation result on a display in a report form. And provides a service providing system.

Description

[0001] The present invention relates to a system for providing automatic quotation calculation service,

The present invention relates to a system for providing an automatic quotation calculation service. More specifically, in order to calculate the quotation generated in the machining process of an applied product, inputting the unit price required for calculating the quotation such as the unit price, the material, and the specification of each component can automatically calculate the quotation based on the unit price, The automatic calculation of estimating service which makes it easy to make individual revisions easily and to output the result of cost analysis calculation in report format so as to analyze the profits of the inside room And the like.

In the past, a design drawing was created by using a design program such as a CAD program, and the total cost was estimated based on the completed drawing based on the completed drawing, and the total estimate was calculated.

This conventional method has a problem in that it takes several months to calculate a quotation because the person in charge of the related work has written it manually, and the accuracy of the calculation result is also low.

On the other hand, the unit price calculation method of laser and CNC plasma cutting work is formed in various units such as time, MM, and KG. Since the method of calculating the above-mentioned unit price calculation method reflects the transaction method of the local community and the individual tendency of the estimator, the estimation unit price and the basic standard unit price are different for each company.

Therefore, the necessary numerical values are extracted from the design drawing file in conjunction with the design drawing file, the quotation is calculated according to the unit price calculation method desired by the user, the quotation of the individual parts is calculated, the unit price and the specification can be selectively modified , It is necessary to develop a more convenient program that can calculate the quotation according to the quotation unit price.

Prior Art Document KR Patent Publication No. 1512293 (registered April 9, 2015)

SUMMARY OF THE INVENTION The present invention has been made to solve the above-mentioned problems, and it is an object of the present invention to provide a flexible quotation calculation program by making it possible to improve work speed and efficiency, The purpose is to do.

In order to achieve the above object, a system for providing an automatic quotation calculation service according to the present invention has a processing ratio of a cutting machine (CNC (Computer Numerical Control)), a bending ratio A unit price input module for inputting a unit price required for calculating a quotation including a unit price, a material cost, a raw material purchase unit price, and a processing unit cost; A drawing data extraction module for drawing a drawing file from the design drawing program and extracting a numerical value including a specification of the component of each drawing; The detailed information is output by performing operations corresponding to the items including item, standard, thickness, material, and quantity for each component by using the values input to the unit price input module and the values extracted from the drawing data extraction module. An information output module; A quotation generation module for generating a quotation by performing an operation corresponding to an item of the quotation form using an input value extracted from the unit price input module and the drawing data extraction module; A component list providing module that provides a list including images, specifications, and materials of each component using the values input to the unit price input module and the values extracted from the drawing data extraction module; And a cost analysis data output module for performing an operation corresponding to the cost analysis item using the input values extracted from the unit price input module and the drawing data extraction module and outputting the cost analysis calculation result on a display in a report format.

In addition, the unit price input module is composed of a CNC application unit input sub-module to which a CNC (computer numerical control) applied unit price is input for each thickness of an applied product, a processing cost application unit input module , The bending ratio applied unit price for the thickness of the applied product is input, and the bending ratio applied unit price input submodule, the applicable unit price input submodule according to the material of the authorized product, and the current raw material purchasing unit price If you are processing an approved product that has a relatively larger size than the raw material cost of an input product that is input to the input module of the raw material input unit and the input unit price of the raw material, the input price of the raw material, Module, subcontracting purchase where raw material purchase price is input from subcontractor A unit price input unit submodule into which a quotation unit price unit including a unit price input submodule, a weight (KG), a specification (MM), and a time unit is inputted, The total cutting time is output by using the processing rate input submodule that allows the input of the processing rate of the material type and the processing rate entered in the processing rate input submodule and the quotation unit price inputted in the unit price input unit submodule And a cutting machining time input submodule.

In addition, the cost analysis data output module calculates the actual cost of the product based on the value entered in the unit price input module and the drawing data extraction module, based on the estimated unit price, net material profit margin, actual processing cost, And output the cost analysis data by performing an operation corresponding to the cost information item.

According to the present invention, the design drawing file is generated in conjunction with the design drawing file program, and the numerical data of the constituent parts are automatically extracted from the design drawing file. When the basic information such as the unit price, material and specification of each part is inputted, By providing a quotation calculation program that allows estimates to be calculated, it is possible to improve the convenience and speed of work by moving away from the conventional manual quotation calculation method, and to facilitate individual quotation and correction adjustment by using an Excel-based system have.

According to the present invention, the automatically calculated manufacturing cost can be output as cost analysis data that can be analyzed for each item, and it can be analyzed at a glance, It has the effect to make.

BRIEF DESCRIPTION OF THE DRAWINGS FIG. 1 is a configuration diagram of an automatic quote calculation service providing system according to a preferred embodiment of the present invention;
2 is a block diagram of the unit price input module,
3 is a diagram illustrating a screen of a unit price input module,
4 is a diagram illustrating a screen of the drawing data extraction module,
5 is an exemplary screen view of a detailed information output module for each component;
6 is a diagram illustrating a screen of a quotation generation module,
7 is an exemplary screen view of the component parts list providing module,
FIG. 8 is an exemplary screen view of the cost analysis data output module, and FIG.
FIGS. 9 to 15 illustrate calculation methods of each item of the cost analysis data output module.

Hereinafter, preferred embodiments of the present invention will be described in detail with reference to the accompanying drawings. In the drawings, the same reference numerals are used to designate the same or similar components throughout the drawings. In the following description of the present invention, a detailed description of known functions and configurations incorporated herein will be omitted when it may make the subject matter of the present invention rather unclear. In addition, the preferred embodiments of the present invention will be described below, but it is needless to say that the technical idea of the present invention is not limited thereto and can be variously modified by those skilled in the art.

2 is a configuration diagram of a unit price input module, FIG. 3 is a view illustrating a screen of a unit price input module, FIG. 4 is a diagram illustrating a configuration of a unit price input module according to a preferred embodiment of the present invention, 5 is a diagram illustrating a screen of a detailed information output module for each component, FIG. 6 is a screen exemplary view of a quotation generation module, FIG. 7 is a screen exemplary view of a component part list providing module, FIG. 8 is a view illustrating a screen of the cost analysis data output module, and FIGS. 9 to 15 are diagrams illustrating a calculation method of each item of the cost analysis data output module.

1 to 15, an automatic quote calculation service providing system 1000 according to a preferred embodiment of the present invention is installed in an external terminal such as a computer and linked to a design drawing program, A drawing data extraction module 200, and a detailed information output module 300 for each component, which is a program capable of inputting or modifying various values for calculating a quotation, ), A quotation generation module 400, a component parts list provision module 500, a cost analysis data output module 600, and a storage module 700.

The automated quote calculation service providing system 1000 according to the preferred embodiment of the present invention can be implemented in the form of a spreadsheet program.

The unit price input module 100 calculates a unit price by applying a machining cost, a bending ratio, a material cost, a raw material purchasing unit price, and a machining rate of a cutting machine (CNC (computer numerical control)) to calculate an estimate required for machining, And the unit cost required for calculating the quotation including the price.

2 to 3, the items of the unit price input module 100 include a CNC application unit price input submodule 110, a processing cost application unit price input submodule 112, a bending ratio application unit input submodule 114, a material-dependent application unit price input submodule 116, a raw material building unit price input submodule 118, a heavy plate raw material building unit input submodule 120, an outer cutting and buying unit price input submodule 122, A sub-module 124, a processing rate input sub-module 126, and a cutting processing time input sub-module 128.

The CNC application unit price input submodule 110 is inputted with a unit price of CNC (Computer Numerical Control) for each thickness of an applied product, and the unit price when CNC which is one of the cutting machines is inputted.

The CNC application unit price input submodule 110 displays the thickness (unit, T) on the horizontal axis and the CNC application unit price according to the thickness on the horizontal axis. In this case, the CNC unit price by a specific function formula can be applied only when 'CNC' is written in the remarks column (not shown). For example, the CNC applied unit price calculation method is calculated by multiplying the materials listed in the processing specification table stored on the database (not shown) by the processing unit price.

The unit cost for applying the processing cost is input to the input submodule 112, to which the processing cost of the supplied workpiece is applied.

The machining cost application unit price input submodule 112 displays materials such as SS, HOLE SS, SUS, and HOLE SUS on the horizontal axis and the thickness (unit, T) on the vertical axis.

The processing cost applying unit price input module 112 can input numerical values to be inputted in a region where the horizontal axis and the vertical axis intersect.

The processing cost applying unit price input module 112 can apply the applied processing ratio and the hole processing ratio to the processing unit cost and the hole using the processing cost table stored in the database (not shown). For example, 0.1T, 0.2T, 0.3T, and 0.4T can be made of SUS material, and SUS 7T processing ratio can be applied. 0.5T, 0.6T, 0.7T, 0.8T and 0.9T can be input CR, and the applied processing ratio can be applied with the 5T processing ratio.

The bending ratio applied unit price input module 114 is divided based on a specific thickness and the applied unit price can be inputted. For example, it can be divided into 7T or less and 8T or more.

The module for inputting the applied unit price per material 116 is a module for inputting a unit price to be applied according to the material of an authorized product, and can input a unit price to be applied according to materials such as steel plates and steel plates. The unit sub-module 116 for inputting the unit price per material has a thickness (unit, T) in a predetermined range on the horizontal axis and an SS plate (Structure Steel), a cold rolled carbon steel sheet (CR), a pickled and oiled steel ), AL (Aluminum), and the like are displayed.

The applied unit price input module for each material 116 can input numerical values to be inputted in a region where the horizontal axis and the vertical axis intersect.

The Raw Material Purchase Price Input Sub-Module 118 is an item for inputting the purchase price of the raw material. The Raw Material Purchase Price Input Submodule 118 can be input according to the thickness of the material.

 The plate material input unit price input module 120 is a module in which a raw material purchase unit price is inputted when an applied product having a relatively larger size than the size of an input product inputted into the input module for inputting raw material costs 118 of raw materials is processed.

The thick plate subcontracting module submodule 120 can be input by thickness. For example, it may be classified into 6T, 8-9T, 10-12T, 14-40T, 45-50T, 55-60T, and 65-80T.

The outer cut-and-buried unit price input sub-module 122 inputs the unit price of the raw material purchased from the subcontractor. Each thickness (unit, T) can be input. If you do not enter the material, the standardized material (for example, SS400) can be applied.

The quotation unit unit input submodule 124 can input any of the quotation unit units including the weight (KG), the standard (MM), and the time. Generally, the unit price calculation method of the cutting operation is formed by any one of the above units, but different units may be applied depending on the estimator. For example, when the eighth data input submodule 124 is calculated by weight, it is input as KG. Exceptionally, you can also enter 'M' when calculating a product under 1KG.

The processing rate input sub-module 126 is an item that allows to input the processing rate of SS (one of the material types) and SUS (one of the material types) per hour. Here, since the processing rate input sub-module 126 is classified into SS (per hour) and SUS (per hour), it can be inputted by referring to the material reference item 127.

The cutting processing time input submodule 128 automatically inputs the total cutting processing time based on the processing rate input to the processing rate input submodule 126 and the applied unit price input to the unit price inputting submodule 124. [ The cutting time is generated by the cutting rate (%), which is a value differentially given to the machine's aging condition, and the processing rate, which is the cost divided by the cutting time.

Here, the cutting feed (%) is a cutting speed, which is the speed at which the laser cuts the article to be fed, which is a numerical value including the speed at which the laser cuts the article to be cut, do.

The parameters applied to the cutting feed (%) are the processing unit price, the hole unit price, the rapid feed * acceleration / deceleration, the piercing (SEC) Time per second), and the rate per second.

Referring to FIG. 4, the drawing data extraction module 200 executes a design drawing program capable of drawing work, and retrieves a drawing file in which work has been completed, and extracts numerical values including specifications of the component parts of each drawing.

Referring to FIG. 5, the detailed information output module 300 for each component uses the values input to the unit price input module 100 and the values extracted from the drawing data extraction module 200, Material, and quantity, and outputs detailed information.

Each item of detail information includes item name, width, length, thickness, material, quantity, material cost, applied processing cost, remarks, folding ratio, hole unit price, hole quantity, hole processing cost, (Raw material cost), material processing cost, material weight, LOSS (ROSS) material amount, and the like are classified and displayed.

Referring to FIG. 6, the quotation generation module 400 generates a quotation based on the material cost and the processing cost input by the unit price input module 100. There are a number of quotation forms including the quotation form, which shows separately the material cost and the processing cost, and the quotation form which is divided by the processing cost into the material cost for the term rate. can do.

Referring to FIG. 7, the component parts list providing module 500 provides a list including images, specifications, and materials for each component using the values input to the unit price input module and the values extracted from the drawing data extraction module.

The component parts list providing module 500 includes a first standard formatting module 510 processed as in-house storage data and a second standard formatting module 520 processed in a form usable as product shipment data, .

 8, the cost analysis data output module 600 performs an operation corresponding to the cost analysis item using the input values extracted from the unit price input module 100 and the drawing data extraction module 200, On a display in the form of a report.

Items output to the cost analysis data output module 600 include the net material profit margin, the actual processing cost, the amount of lost material generated during the work, the actual work material cost amount, and the actual sales profit in comparison with the estimated price.

The calculation method for the cost analysis data item can use the function of the Excel program.

Hereinafter, a method of calculating a result value for the item will be described with reference to FIGS. 9 to 15. FIG.

Referring to FIG. 8, the 'quotation unit price' is a sum of the material cost and the processing cost of an authorized product, and is calculated by multiplying the processing cost by the sum of the individual material cost of the product and the individual processing cost.

The quotation unit price includes the values of 'application material cost', 'application processing cost', 'bending ratio', 'hole processing cost', 'automatic processing distance of automatic input value' among the values automatically input to the detailed information output module 300 Weight ".

9, the 'material price' is generated from the values input to the CNC applicable unit input submodule 110, the material applied unit price input submodule 116, and the quotation unit unit input submodule 124.

10, the 'application processing cost (processing unit price)' is a value obtained by subtracting a value inputted in the SS (one of the materials) and SUS (one of the materials) items of the processing cost application unit sub- Is generated from the value input to the submodule 124.

Referring to FIG. 11, the 'bending ratio' is generated from the value input to the bending ratio application unit sub-module 114.

Referring to FIG. 12, a value input to the 'processing unit price (HOLL unit price)' is generated from a hole SS and a hole SUS item value among the values input to the application unit price input submodule 116 do.

The quotation unit price is generated by applying the sum of the applied material cost, the applied processing ratio, the bending ratio, the hole unit price, and the processing distance of the automatic input value in terms of weight.

Referring to FIG. 8, the 'net material profit margin' item is calculated by subtracting the raw material purchase material cost from the processed estimated material cost. At this time, a value obtained by calculating the difference between the material cost on the quotation and the material purchase material cost is input.

Referring to FIG. 13, the actual material cost is generated by the raw material cost unit input module 118 and the heavy plate raw material cost unit input module 120. FIG.

Referring to FIG. 14, a value calculated by summing up the input values of the processing ratio and the bending ratio is input into the 'actual processing ratio' item. The 'actual processing cost' item is generated by the processing cost application unit input submodule 112, the bending ratio application unit input submodule 114, and the quotation unit price input submodule 124.

Referring to FIG. 15, the 'LOSS (Lost) Material Amount' field of the work (product interval) calculates and outputs the material amount of the loss (LOSS) portion of the plate material and the gap loss (LOSS) portion.

At this time, the item (product interval) LOSS material amount 'item is generated by the fifth data input submodule 118 and the sixth data input submodule 120.

Referring to FIG. 7, the item 'NEGO amount' is an item that allows the user to input the deducted amount when the discounted amount is applied in the estimate cost.

Referring to FIG. 7, in the 'actual work material cost' item, an amount obtained by subtracting the work (product interval) LOSS material amount from the raw material purchase unit price is input.

The actual work material cost value is calculated by generating the raw material cost unit value by the raw material cost unit input module 118 and the heavy plate raw material cost unit input module 120 and calculating the work (product interval) LOSS material cost And the resultant value is calculated.

Referring to FIG. 7, 'Estimated real profit margin (%)' item is a sum of net profit margin, actual processing cost, work (product interval) LOSS material amount, discount applied amount (NEGO amount) Is calculated and output as a percentage of the unit price.

The cost analysis data output from the cost analysis data output module 600 can be used to check the sales profit, the weight of the scrap, the processing time, the weight of the actual product, and the actual work material cost.

The storage module 700 stores the unit price of each item input by the unit price input module 100, and stores quotations, design drawings, cost analysis data, and the like for each company. It is possible to recall a partial quotation item by calling each company quotation stored in the storage module 700.

It will be apparent to those skilled in the art that various modifications, substitutions and substitutions are possible, without departing from the scope and spirit of the invention as disclosed in the accompanying claims. will be. Therefore, the embodiments disclosed in the present invention and the accompanying drawings are intended to illustrate and not to limit the technical spirit of the present invention, and the scope of the technical idea of the present invention is not limited by these embodiments and the accompanying drawings . The scope of protection of the present invention should be construed according to the following claims, and all technical ideas within the scope of equivalents should be construed as falling within the scope of the present invention.

100 - Unit Price Input Module
110 - CNC applicable price input sub-module
112 - Processing cost applied unit price input submodule
114 - Bending ratio applied unit price input submodule
116 - Applied Unit Price Input Sub-module for each Material
118 - Raw material input unit input module
120 - Plate Raw Material Purchase Unit Input Submodule
122 - Subclause for subcontracting cutting cost
124 - Quotation Unit Price Input Module
126 - Processing rate input sub-module
128 - Cutting time input submodule
200 - drawing data extraction module
300 - Detailed information output module for each component
400 - Quote generation module
500 - Component List Module
600 - Cost analysis data output module
700 - Storage module
1000 - Automatic quotation calculation service providing system

Claims (3)

It is necessary to calculate the quotation including the processing cost, the bending ratio, the material cost, the unit cost of raw material purchase, and the unit price of the processing cost of CNC (computer numerical control) in order to calculate the estimate required for processing including the cutting of the authorized product A unit price input module for inputting a unit price;
A drawing data extraction module for drawing a drawing file from the design drawing program and extracting a numerical value including a specification of the component of each drawing;
The detailed information is output by performing operations corresponding to the items including item, standard, thickness, material, and quantity for each component by using the values input to the unit price input module and the values extracted from the drawing data extraction module. An information output module;
A quotation generation module for generating a quotation by performing an operation corresponding to an item of the quotation form using an input value extracted from the unit price input module and the drawing data extraction module;
A component list providing module that provides a list including images, specifications, and materials of each component using the values input to the unit price input module and the values extracted from the drawing data extraction module; And
A cost analysis data output module for outputting the result of cost analysis calculation on the display in the form of a report by performing an operation corresponding to the cost analysis item using the input values extracted from the unit price input module and the drawing data extraction module
And an automatic quotation calculation service providing system. The method according to claim 1,
Unit price input module
CNC application unit price input submodule, CNC (Computer numerical control) input unit price, CNC input unit submodule, CNC input unit price, CNC input price, Bending ratio Applied unit price to be input for bending ratio Applicable unit price Input submodule, Applicable unit price input submodule to which the unit price applied according to the material of the authorized product is inputted, Current raw material purchase unit price Raw material purchase unit price is input based on the price If you are processing an approved product that has a larger size than the raw material cost of the input product that is input to the submodule, the raw material input unit price input submodule, the raw material input unit price is inputted, The sub-module for inputting the price of the peripheral cutting buried unit, (KG), Specification (MM), Quotation unit price, Including time, Quotation unit price, Entering unit, Input unit price, Processing rate of material type including SS, And a cut processing time input for outputting a total cutting processing time using the processing rate inputted to the processing rate input sub-module and the quotation unit price inputted to the unit inputting sub-module of the quotation unit price input Submodule
And an automatic quote calculation service providing system. 3. The method according to claim 1 or 2,
The cost analysis data output module
Based on the values entered in the unit price input module and the drawing data extraction module, it corresponds to the cost information item including the quotation unit price, the net material profit margin, the actual processing cost, the amount of lost material generated during the work, the actual work material cost amount, And outputting the cost analysis data.

Images