KR101274623B1 - Method and apparatus for calculating cost - Google Patents

Abstract

PURPOSE: A method for automatically calculating the original cost and a device thereof are provided to automatically calculate original costs by inputting the data of a necessary item to each category by programming a predetermined language. CONSTITUTION: Categories which are necessary to calculate original costs are grouped by a setting unit(110). Each category is generated for defining an estimation method in each category(112). A calculation result provides an information input page by connecting to an application program corresponding to the calculation of the original costs by identifying the input value of sub-categories. [Reference numerals] (110) Group randomly processed materials item by item; (112) Generate a formula required for defining an estimation formula; (114) Provide an information page in each set article; (116) Collect an input value in each article; (118) Store programs; (120) Match variable information for a specific article with a generated formula; (122) Calculate a cost price in each article; (AA) Start; (BB) End

Description

Costing Method and Apparatus {METHOD AND APPARATUS FOR CALCULATING COST}

The present invention relates to an automatic cost calculation for a processed product for automatically calculating the cost by programming the item-specific cost calculation standard of the processed product in a predetermined language.

When estimating a processed product, a calculator or Excel calculates the unit price for those who have a lot of knowledge of the processed product.

This process is not easy to access if you are not an expert in the field, and even if you are an expert, personal deviations occur and errors occur frequently, so accurate calculations are difficult. The problem arises.

Therefore, the present invention provides a technology for automatic cost calculation of processed goods to input the data of items required for cost calculation for each item by programming the cost calculation standard for each item of the processed goods in a predetermined language. I would like to.

According to one aspect of the invention, in the cost calculation method, the step of grouping the items for each item required for cost calculation, and using the grouped items to generate a formula for each item required to define the formula for the estimate, and the estimate Providing a preset item-specific information input page for selecting the development process of the formula, and receives the input value for each item through the preset item-specific information input page, and provides a formula for estimating the input item input value And storing in association with a program defined in a predetermined language providing a function library, and calculating cost for each item by matching variable information about the specific item for each item with the generated formula.

According to another aspect of the present invention, in the cost calculation device, a setting unit for grouping the items for each item required for cost calculation, and for generating a formula for each item to define the formula for quotation using each of the grouped items, and In a predetermined language providing an information input unit for providing a preset item-specific information input page for selecting the development process of the quotation formula, and a function library for inputting item-specific input values through the information input unit and providing quotation calculation formulas. And a control unit for storing in association with a defined program and controlling the variable information of the specific item for each item to calculate the cost for each item by matching the formula generated from the setting unit.

The present invention is to input the data of the items necessary for the cost calculation of each item by programming the cost calculation standard for each item of the processed goods in a predetermined language, and automatically calculate the cost of the processed goods, including various mechanical devices when ordering the processed goods Providing an estimate formula for calculating the quantity of all materials used in the production, by linking the calculation result of the provided quote formula to the application to reduce the time for the quoter to estimate the work, and centralize the data of the quote work Not only can it be managed intensively, it can also improve the consistency and accuracy of estimating work.

1 is an overall flowchart of a cost calculation method according to an embodiment of the present invention.
2 is a block diagram of an apparatus for calculating a cost according to an embodiment of the present invention.
Figure 3 is an exemplary screen showing a screen to which the cost calculation method of the present invention is applied.

Hereinafter, preferred embodiments of the present invention will be described in detail with reference to the accompanying drawings. It will be appreciated that those skilled in the art will readily observe that certain changes in form and detail may be made therein without departing from the spirit and scope of the present invention as defined by the appended claims. To those of ordinary skill in the art.

The present invention relates to automatic cost calculation of processed goods for inputting data of items required for cost calculation for each item by programming a cost calculation standard for each item of processed goods in a predetermined language. In order to easily calculate various item-specific quotations related to processed goods according to the user's needs, a formula is generated by using item-specific items necessary for cost calculation, and a preset item-specific information input page is provided to receive input values for each item. This is recorded in a program programmed in a language such as Visual C or Basic to match the figures of the drawings created during the design / development of the processed products to automatically calculate the cost for each item. All used for the manufacture of finished goods, including devices Providing an estimate formula for calculating the quantity of ash, and by linking the calculation result of the provided quote formula to the application to reduce the time required for the estimate work, and centrally manage the data of the estimate work In addition, it aims to provide technology that can improve the coherence and accuracy of estimating work.

Hereinafter, a cost calculation method according to an embodiment of the present invention will be described in detail with reference to FIG. 1.

1 is a flowchart illustrating a cost calculation method according to an embodiment of the present invention. Referring to FIG. 1, first, an item for each item of processed goods required for cost calculation is grouped in step 110.

Here, in the embodiment of the present invention, the items of the processed goods include, for example, precision parts processing, sheet metal processing, aluminum profile frame, steel pipe welded structure and plastic engineering, the item-specific items required for the cost calculation, for example, the precision parts Machining includes material cost, price by air (rental rate), post-treatment and company profits, and sheet metal processing includes material costs, cutting (lasers, NCT, shearing machines), bending, printing (silk, nickname) and company profits. The aluminum profile frame includes a material cost, cutting, assembly (fastening NUT) and the company profits, the steel pipe welding structure is a material cost, angular processing, welding rate, planer processing, unwinding, painting and company profits The plastics engineering includes material costs, cutting and precision machining and company profits.

In step 112, the equations required to define the quotation formula are generated for each item using the grouped items.

Here, the items are different from each other as described above according to the item-specific processing of the processed goods, the formula is generated by summing the items grouped by item, material and laser for the item among the grouped items (laser) The processing unit price item corresponds to the basic mandatory input value for each item.

In this case, the unit price of the item for each item is input by driving a program defined in a predetermined language, and stored in a DB for each item, the unit price for each item is calculated through a pre-set unit price formula for each item, Looking at an embodiment of the automatic differential unit price calculation for each quantity for a given item as follows.

-Product KG Calculation Formula: Horizontal * Vertical * Height * Specific Gravity / 1, 000, 000 = 100 * 100 * 100 * 2.8 / 1, 000, 000 = 2.8 KG

Material cost formula: Material KG * Actual value = 3.24 * 7, 600 = 26,600

Post-treatment ratio formula: Product KG * Actual value of the corresponding post-treatment = 2.8 * 3, 000 = 8, 400

-Formula of processing cost: Applicable Machine * Time = 18,000 * 1 = 18,000

-Total: material cost + aftertreatment cost + processing cost = 53,000

Grand Total: Total * 1.08 = 114,480

NEGO (5%): Grand Total * 0.95 = 108,756

-NEGO (10%): Grand Total * 0.90 = 103,032

-NEGO (15%): Grand Total * 0.85 = 97,308

The NEGO is managed as follows by adding an item on a program defined in a predetermined language and adding a price for the quantity to an additional NEGO position.

1EA ~ 4EA-> Quote

5EA ~ 9EA-> 5% of total price NEGO

10EA ~ 19EA-> 10% of total price NEGO

20EA ~ 49EA-> 15% of total price NEGE

50EA ~ 99EA-> 30% of total price NEGO

Over 99EA-> 30% of total price NEGO

At this time, the quantity and nego position can be arbitrarily changed / modified, the last change value is stored as a changed value.

Step 114 provides a preset item-specific information input page for selecting the development process of the quotation formula. In the provided information input page, various quotation formulas for calculating the unit price of the processed product are defined, the process of describing the formula is described, the contents are interpreted, and the result is linked to the application program, and the result is displayed in FIG. 3. Provided as a screen as shown.

Here, referring to FIG. 3, FIG. 3 is an exemplary view illustrating a screen to which a cost calculation method of the present invention is applied. The preset item-specific information input page 300 is an item-specific item 310, 312, 313 of a processed product. Sub-items 314, 315, and 317 for the sub-items 314, 315, and 317, and the unit price for the sub-items 314, 315, and 317. Menus, that is, selection areas "add" and "delete" (318, 321) are displayed, and "input complete" area, which is an execution command 316 for calling and executing an action on the item-specific cost calculation, is displayed. The variable information input window for the specific item for each item is displayed, and the result window 322 for the cost calculation for each item is displayed by selecting the execution command.

Subsequently, in step 116, a predetermined language input value is collected and received through the preset item-specific information input page, and in step 118, a predetermined language for providing a function library for providing the quotation calculation formulas, for example, Visual C (Visual C) Or in conjunction with a program defined in a language such as Basic.

For example, the function library providing the quotation calculation formulas defines a grammar of a quotation formula that performs a function desired by a user, similar to the method of defining library functions of "micro Excel", and corresponds to the grammar defined above. Functions constituting the quotation formula may be interpreted to perform a specific function, and when defining the quotation formula, functions previously registered in the library may be employed together in a manner similar to the method used in "Microsoft Excel".

Thereafter, in step 120, variable information about the specific item for each item is matched with the generated formula.

The variable information refers to a size value of an item created at the time of design / development of each item, and the weight, size, type, width, height, height, and height of the item using the prepared item-specific drawing ( NEGO) or input data such as common information such as a variety of items is input.

In step 122, the item-specific cost of the processed goods for each item whose variable information is matched to the generated formula is calculated and displayed on the preset item-specific information input page.

The cost calculation method according to an embodiment of the present invention has been described with reference to FIG. 1.

Hereinafter, a cost calculating apparatus for face recognition according to an embodiment of the present invention will be described in detail with reference to FIG. 2.

2 is a block diagram of a cost calculator according to an embodiment of the present invention. Referring to FIG. 2, the apparatus 200 to which the present invention is applied includes an information input unit 210, software 222, a control unit 214, a setting unit 216, and a DB 218.

The setting unit 216 groups items for each item necessary for cost calculation, and generates, for each item, a formula required to define a quotation formula using each of the grouped items.

The information input unit 210 provides a preset item-specific information input page for selecting a development process of a quotation formula.

The controller 214 receives an input value for each item through the information input unit 210 and stores it in association with a program defined in a predetermined language for providing a function library for providing quotation calculation formulas, and the specific item for each item. Matching the variable information on the equation generated from the setting unit controls to calculate the cost per item.

Here, the program is, for example, a program 222 programmed in a language such as Visual C or Basic.

In addition, the controller 214 controls the unit price of the item for each item by driving a program defined in a predetermined language, and storing it in the DB 218 for each item.

The controller 214 displays a sub-item for each item and a unit price for the sub-item on the preset item-specific information input page, and displays a menu for executing addition / deletion of the sub-item. An execution command for calling and executing an action for item-specific cost calculation is displayed, the variable information input window for the specific item for each item is displayed, and the result window for item-specific cost calculation is displayed by selecting the execution command.

Here, the preset item information input page for each item is displayed on the sub-items for the item-by-item item of the processed goods and the unit price for the sub-items, and is a menu for executing addition / deletion of the sub-items, that is, a selection area. "Add" and "Delete" are displayed, an "input completed" area, which is an execution command for calling and executing an action for the item-specific cost calculation, is displayed, and a variable information input window for the specific item by item is displayed. The result window for the costing of each item is displayed by the execution command selection.

As described above, the operation of the method and apparatus for calculating the cost according to the present invention can be made. Meanwhile, although the above-described embodiments of the present invention have been described in detail, various modifications can be made without departing from the scope of the present invention. . Accordingly, the scope of the present invention should not be limited by the illustrated embodiments, but should be determined by equivalents of the claims and the claims.

210: information input unit 214: control unit
222: S / W 216: setting part
218 DB

Claims (12)

In the cost calculation method,
A process of grouping items for each item required for cost calculation as set forth in Table 1 below through a setting unit, and generating a formula for each item using the grouped items to define a formula for each item;
By receiving the formula required to define the quotation formula generated for each item in the setting unit, the information input unit is set for each item formula for calculating the cost, and provides a preset item information input page to input the actual input value for each item Each item grouped by the item on the preset item information input page is displayed in a preset area, and input values of sub-items for each item are inputted into each field on one side of the displayed preset area to calculate the cost per item. A formula processing process required to define a quotation formula for the display is displayed, and a preset item-specific information input page for identifying the input values of the sub-items input for each field is linked to an application corresponding to the cost calculation and displays the calculation result. Process,
Storing a function library for performing an estimate calculation on the input item-specific input value through a control unit in association with a program defined in a predetermined language;
Calculating the cost of each item by inputting the variable information on the specific item for each item, which is a size value of the item created during the design / development of the item, to the generated formula through the control unit;
The above items include at least two or more of the unit prices for materials, airborne wage rates, post-treatment, business profits, laser processing, printing, bending and assembly,
Material cost and laser processing unit price included in the formula defining the formula for each item is characterized in that the required input value for each item,
The items are different from each other according to the item-specific processing as shown in Table 2, wherein the formula is characterized in that the sum of the items grouped by item,
The process of calculating the cost per item,
The preset item-specific information input page displays a sub-item for each item and a unit price for the sub-item, a menu for executing addition / deletion of the sub-item, and displays an action for calculating the cost per item. The execution command for calling and executing is displayed, the variable information input window for the specific item for each item is displayed, and the result window for the cost calculation for each item is displayed by selecting the execution command. subject Grouped items Formula defining the quote formula Precision part processing Material cost, price by airlift, post-treatment, company profit Precision Parts Processing = Material Cost + Price by Air (Rate) + Post-treatment + Business Profit Sheet metal processing Material cost, cutting (laser, NCT, shearing machine), bending, printing, profit Sheet metal processing = material cost + cutting (laser, NCT, shearing machine) + bending + printing + business profit Aluminum profile frame Material cost, cutting, assembly (fastening NUT), company profit Aluminum profile frame = material cost + cutting + assembly (NUT) + business profit subject Grouped items Precision part processing Material Cost + Price by Air (Rate) + Post-treatment + Business Profit Sheet metal processing Material cost + cutting (laser, NCT, shearing machine) + bending + printing + business profit Aluminum profile frame Material cost + cutting + assembly (NUT) + business profit delete delete delete delete The method of claim 1, wherein the unit price of the item for each item further includes driving and inputting a program defined in a predetermined language, and storing the DB for each item. The method of claim 1, wherein the unit price for each item is calculated through a unit price formula for each item. delete In the cost calculator,
A setting unit for grouping items for each item required for cost calculation as shown in Table 3 below, and for generating items for each item using the grouped items to define formulas for estimating formulas;
By receiving the formula required to define the quotation formula generated for each item in the setting unit, the information input unit is set for each item formula for calculating the cost, and provides a preset item information input page to input the actual input value for each item Each item grouped by the item on the preset item information input page is displayed in a preset area, and input values of sub-items for each item are input by fields on one side of the preset preset area for each item to calculate the cost per item. A formula processing process required to define a quotation formula is displayed, and the input values of the sub-items inputted by the fields are identified to provide a preset item-specific information input page in which a calculation result is displayed in connection with an application corresponding to cost calculation. An information input unit,
A function library for performing quotation calculation on the input item-specific input value is stored in association with a program defined in a predetermined language, and stored in the item-specific item which is a size value for the item created during design / development of the item. And a controller for inputting variable information on the generated formula to calculate the cost for each item.
The above items include at least two or more of the unit prices for materials, airborne wage rates, post-treatment, business profits, laser processing, printing, bending and assembly,
Material cost and laser processing unit price included in the formula defining the formula for each item is characterized in that the required input value for each item,
The items are different from each other according to the item-specific processing as shown in Table 4, wherein the formula is characterized in that the sum of the items grouped by item,
The control unit displays a sub-item for each item and a unit price for the sub-item through the preset item-specific information input page, displays a menu for executing addition / deletion of the sub-item, and costs for the item. Displaying an execution command for calling and executing an action for calculation, displaying a variable information input window for the specific item for each item, and controlling to display a result window for cost calculation for each item by selecting the execution command Costing device made. subject Grouped items Formula defining the quote formula Precision part processing Material cost, price by airlift, post-treatment, company profit Precision Parts Processing = Material Cost + Price by Air (Rate) + Post-treatment + Business Profit Sheet metal processing Material cost, cutting (laser, NCT, shearing machine), bending, printing, profit Sheet metal processing = material cost + cutting (laser, NCT, shearing machine) + bending + printing + business profit Aluminum profile frame Material cost, cutting, assembly (fastening NUT), company profit Aluminum profile frame = material cost + cutting + assembly (NUT) + business profit subject Grouped items Precision part processing Material Cost + Price by Air (Rate) + Post-treatment + Business Profit Sheet metal processing Material cost + cutting (laser, NCT, shearing machine) + bending + printing + business profit Aluminum profile frame Material cost + cutting + assembly (NUT) + business profit
10. The apparatus according to claim 9,
The unit price for the item for each item is a cost calculation device, characterized in that for controlling the input to drive the program defined in a predetermined language, and store the DB by item. delete A computer-readable recording medium having recorded thereon a program for executing the cost calculating method according to any one of claims 1, 6 and 7.

Images