CN112508381A

CN112508381A - Computing system for project cost of mechanical industry and implementation method thereof

Info

Publication number: CN112508381A
Application number: CN202011395247.XA
Authority: CN
Inventors: 杨洋
Original assignee: Individual
Current assignee: Individual
Priority date: 2020-12-03
Filing date: 2020-12-03
Publication date: 2021-03-16

Abstract

The system comprises a project management module, a budget cost module, an actual completion cost module, a project cost analysis module, a basic data module and a calculation formula module. Has the following advantages: the method overcomes the defect of the existing data island, can solve the calculation and analysis of the related cost of the project, can realize the cost summarization and analysis of each part, and can also realize the total cost summarization and analysis of the project.

Description

Computing system for project cost of mechanical industry and implementation method thereof

Technical Field

The invention relates to management of project cost in the mechanical industry, in particular to an algorithm for calculating and analyzing project budget cost and actual completion cost, and belongs to the technical field of computer software.

Background

The machine manufacturing industry is typical discrete type, single-piece production or multi-variety small-batch production forms are many, the period is long from technical design, process design and manufacturing production, management software needs to customize different solutions and design systems according to the difference of production types, production modes and production organization modes of enterprises, data islands are easily caused due to a plurality of data systems, data integration and sharing cannot be completely realized, data sources need to be opened, and the problem of cost management is solved by utilizing shared data.

Cost management in the mechanical manufacturing industry is a key ring in enterprise internal management, and the traditional cost calculation mode cannot meet the requirements of actual production and rapid development of enterprises and cannot meet the requirements at any time. At present, the requirements of customers are diversified, various requirements can be provided when a scheme is selected, enterprises need to give product quotations of different materials and combinations in time in order to achieve random strain, and how to adjust the cost quotation scheme accurately as soon as possible is a big pain point of the enterprises. The cost quotation system which can meet the change requirements of customers in time and meet the enterprise rules is very important for enterprises, and can provide cost analysis reports for sellers and decision makers in multiple angles to assist the sellers and decision makers in making correct choices.

The project management mode replaces the traditional management mode at present in the mechanical manufacturing industry, but the project cost management still stays in the collection, arrangement and analysis of actual completion cost, the budget cost is basically estimated by using the actual completion cost, the estimated total cost is distributed to various details, the mode is poor in accuracy and inflexible, is a reverse cost method, cannot specifically achieve the budget cost of material and labor hour data of each part, cannot perform very detailed budget data analysis, and cannot perform material analysis, labor hour cost analysis and auxiliary material analysis of a single part. The traditional statistical mode of actual completion cost, the mode of packaging, gathering and accounting of materials and working hours are not suitable for the current development, and the gathering, sorting and analysis of various costs of each part are required, so that the method is more precise to be beneficial to process control, management and promotion of subsequent projects.

The mechanical manufacturing industry rapidly and accurately compiles budget cost, can indicate a fighting target for budget cost management work of enterprises, and provides a direct basis for cost management; moreover, the cost budget can also mobilize and organize the whole staff to make detailed calculation and dig potential, and control the cost consumption. The method promotes enterprises to effectively utilize manpower, material resources and financial resources to strive to improve the operation management, and obtains better economic benefit with the least labor consumption. The estimated cost is accurate, and the actual completion cost can be perfected and restrained, so that the actual completion cost data of the project can be more accurate. The process management of the actual completion cost is also very important, the actual completion cost of the project is summarized and extracted through the circulation and the aggregation of the data, and the data feedback is truly generated. Through the data comparison analysis of the final project budget cost and the actual cost, the leader can be given decision data of a first hand.

Therefore, it is necessary to provide a more reasonable calculation system for budget cost and actual cost and an implementation method thereof for the machinery industry, and the calculation efficiency and the data accuracy can be improved.

Disclosure of Invention

The invention aims to solve the technical problems, provides a project cost calculation system in the mechanical industry and an implementation method thereof, overcomes the defect of the existing data island, can solve the calculation and analysis of project related cost, can realize the cost summarization of each part and can also realize the project total cost summarization.

In order to solve the technical problems, the invention adopts the following technical scheme:

the project cost calculating system for the mechanical industry comprises a project management module, a project cost analysis module, a budget cost module, an actual completion cost module, a basic data module and a calculation formula module.

The project management module is responsible for managing project numbers including creation, modification, locking and unlocking, receiving application of project budgets, receiving notification of project start-up and completion, performing data linkage with other modules, and extracting drawings and process data in a technical system.

The budget cost module is based on the functions of the project management module, the basic data module and the calculation formula module, after budget making application is received, part budget cost of each part in project BOM details is generated in time, assembly part budget cost is generated through cyclic calling, and finally the total budget cost of the project is obtained.

The actual completion cost module is responsible for organizing and arranging the manufacturing BOM details of the project after receiving the project starting and manufacturing notice by relying on the functions of the project management module and the budget cost module, and the system is automatically decomposed into a purchasing plan of a purchasing department, a workshop operation plan and a material receiving limit of a warehouse project; after each part of the project is manufactured, the module calls all actually generated data related to the project, and the actual cost of the project is obtained through summarization.

The cost analysis module collects all data of the project budget cost and the actual completion cost by relying on the functions of the project management module, the budget cost module and the actual completion cost module, and comprehensively analyzes the material cost, the working hour cost and the auxiliary material cost.

The basic data module is responsible for maintaining data such as a material table, a density table, a special character table, a section unit weight table, a material market price table, an equipment time value table and the like, is basic data information for supporting the calculation formula module in the system and participates in calculation of related cost data.

The calculation formula module is responsible for making and maintaining a calculation formula related to cost, and comprises component material cost calculation, component working hour cost calculation, component auxiliary material cost calculation, component total cost calculation and assembly part cost calculation, and the calculation formula module is also an independently operated module and is used for calling during data operation of other modules.

Further, if the component material is a non-profile material, the component material cost calculation method is as follows:

obtaining the material volume N1 and the density N2 of the part, and calculating the material weight M of the part; and then obtaining the material quality and the material model, and calculating the material unit price S by using a price table maintained by a basic data module, wherein the calculation formula of the part material cost in the non-section is Z-N1 multiplied by N2 multiplied by S/1000000.

Further, if the component material is a profile, the component material cost calculation method is as follows:

acquiring the unit model, and inquiring to obtain the unit weight N by using a profile unit weight table maintained by a basic data module; then obtaining the length H of the material, and calculating the material weight M of the part; then, the material and unit model are obtained, and the price table maintained by the basic data module is utilized to calculate the unit price S of the material; the material cost of the component in the case of a profile is calculated as Z ═ nxhxs/1000.

Further, the method of the illustrated component man-hour cost calculation is as follows:

acquiring the names of all the procedures in the process routes of all the parts, and inquiring to obtain a time value K corresponding to the procedures by using an equipment working hour table maintained by a basic data module; acquiring the standard process working hours H (the unit is minutes) of the working procedure; the formula of the labor cost of each procedure is H multiplied by K/60; the calculation formula for the man-hour cost of the component is H1 × K1/60+ H2 × K2/60+ H3 × K3/60 … ….

Further, the method for calculating the auxiliary material cost comprises the following steps:

acquiring the names and materials of auxiliary materials in each part, and inquiring to obtain unit price K corresponding to the auxiliary materials by using an auxiliary material price table maintained by a basic data module; then obtaining the quantity M of each auxiliary material; the formula of the auxiliary material cost is M multiplied by K; the formula for calculating the auxiliary material cost of the part is that F is the sum of the auxiliary material costs of all auxiliary materials, namely M1 multiplied by K1+ M2 multiplied by K2+ M3 multiplied by K3 … ….

Further, the method of calculating the component cost is as follows:

and acquiring the material cost Z, the labor hour cost G and the auxiliary material cost F of each part, and obtaining a calculation formula of the part cost as U + Z + G + F.

Further, the method for calculating the assembly cost is as follows:

firstly, judging whether each component has a previous-level component, and screening all components belonging to the previous-level component if the component has the previous-level component; acquiring the quantity L of the parts, setting a variable Y, initializing to 0, assigning all the sum of the parts to Y by using a formula U + L + Y, assigning Y to the material sum Z of the previous part, acquiring the working hour cost G and the auxiliary material cost F of the previous part, and calculating to obtain the sum U of the previous part; circularly judging until no upper stage exists; the final-stage component is the total assembly component of the whole project, and the sum U of the final-stage component is the total expense of the project; the calculation formula for the component cost is then given as Y ═ component cost U1+ component cost U2+ component cost U2 … …) + labor cost of the component + auxiliary material cost of the component.

The implementation method of the project cost calculation system in the mechanical industry comprises the following specific steps:

step one, a sales clerk and an accessory clerk fill a project application form in a project management module according to the customization requirements of customers, and manage a post-approval project section;

after receiving the instruction, the specialist of the project department generates a new project number by using the project number rule of the project management module, and performs simple Chinese description to facilitate communication in subsequent links; a project department specialist calls technical and technological data details of a PLM system and a CAPP system, organizes project BOM details, and transmits the project BOM details to a budget specialist to carry out budget cost accounting on the project;

step three, the budget specialist performs necessary communication analysis with the sales clerk according to the received budget BOM data, extracts a calculation scheme designed by the calculation module and a data table of the basic data module, generates budget cost, issues the budget cost after being audited by a supervisor, cannot be changed after issuing, and retains an original version record if a system is changed, and generates a new version which is convenient to trace;

step four, after the budget cost is made, the budget cost is transmitted to a sales service person or an accessory service person, the service person negotiates with the client on line, repeatedly modifies the budget cost according to the actual requirement of the client, the project budget cost is filed after the contract is signed, and a project department issues a project making notice;

step five, the project department informs the manufacturing department, organizes production and production, and issues project budget BOM details and completion time to the manufacturing department;

step six, the manufacturing part decomposes the project BOM into a purchasing operation plan and a lathe operation plan to be issued in an actual completion cost module, and decomposes the material receiving plans of various warehouses at the same time, wherein each plan has completion time;

step seven, the business personnel of the purchasing department purchases materials according to a purchasing plan and puts the materials into storage according to market price after the materials come; the workshop material taking personnel go to the warehouse according to the material taking limit of the project to take the raw materials and the auxiliary materials, use the raw materials and the auxiliary materials according to the requirement, and return the surplus raw materials to the original warehouse; the workshop master and the workshop officer can carry out the material preparation, the processing, the assembly welding and the assembly of the parts according to the workshop operation plan, and when the work piece is put into a warehouse for operation, the application working hours of the work piece on each lathe can be recorded into the system;

step eight, after the project is finished, project balance notification is carried out by a project department specialist in the system, the project management module locks the serial number of the project, the project can not carry out all operations such as material purchasing, material warehousing, workshop material receiving, work hour input and the like, and if a plan needs to be added, the project department needs to unlock the project;

and step nine, after the project is finished, a project department specialist can automatically extract all relevant data of the project, budget cost and actual finished cost in the project cost analysis module, and the project cost analysis module carries out required cost analysis.

Further, the implementation method further includes an implementation method of the budget cost module, and the implementation method of the budget cost module includes the following steps:

step one, a salesman fills in an offer application form, and a project department receives the application form after a master system signs;

step two, if the project department finds that no drawing or process exists, the project department timely informs the technical department to organize the design of the drawing and the process according to the requirements of customers; if the item part finds a drawing, drawing and process data detail can be extracted according to the requirements of customers;

step three, acquiring information, code number, name, material, quantity and the like of each part in the project budget BOM list, acquiring a process route (blanking process/machining process/assembly welding process) and an auxiliary material process of each part, and organizing and generating the project budget BOM list;

fourthly, budgeting BOM details, calling a calculation formula and a basic data table to generate the cost of each part, and circularly judging the cost of calling the part cost to generate the cost of each assembly part;

step five, after the budget cost is made, submitting the audit of the project department supervisor, issuing after signing, and receiving by a salesman; the salesman can derive the required report form, and can make an on-line negotiation with the customer, if it is not suitable, the budget specialist can be informed to modify the budget;

and step six, signing the order, filing budget data BOM, and not modifying.

Further, the implementation method also comprises an implementation method of the actual finished cost module, and the implementation method of the actual finished cost module comprises the following steps:

step one, after an order is signed, a project department issues a making notice, a budget cost BOM is a data support signed by the order, a production system receives the order, and a manufacturing BOM of the project is organized according to the budget BOM;

step two, decomposing the manufacturing BOM into a purchasing operation plan and issuing the purchasing operation plan to a purchasing part, and putting the material into a warehouse according to the actual purchasing price after the material is delivered;

step three, decomposing the manufacturing BOM into a workshop operation plan, enabling the workshop to be manufactured according to the process manufacturing route and then to be put into a finished product library, and automatically recording each part of the project, a lathe used by the part, the used working hour and the working hour cost by the system;

step four, decomposing the manufacturing BOM into delivery details of a warehouse, delivering the warehouse to a workshop according to the details, and automatically recording each part of the project by a system during delivery;

step five, if the technology and the process are changed or added, the production part freezes the manufacture BOM of the project or the added project;

step six, after the project is finished, the project department sends a forwarding notification, and the project information in the system is locked and filed and cannot be operated;

step seven, the actual cost of the project is that after the project is finished, the system extracts the material receiving data of the warehouse and the labor hour cost data of the part finishing warehouse according to the project number, and the data are summarized into the actual cost data of the project; when applied to cost accounting, EXCEL or other desired reports may be derived.

By adopting the technical scheme, compared with the prior art, the invention has the following technical effects:

compared with the prior art, the patent has the following advantages:

1. the system can quickly and flexibly organize the project BOM and generate detail of parts required by the project;

2. the system adopts modular design, has clear functions, is interdependent and can independently operate;

3. the basic data module is basic information for supporting cost data calculation in the system, and is set for maintenance and periodic updating by a specially-assigned person, and the contained data tables are all required by the calculation module;

4. the project number in the project management module is unique after being generated and runs through the life cycle of the whole project;

5. the budget cost and the actual cost generated by the system are suitable for the discrete manufacturing industry, and the cost control of single product orders and small-batch orders can be a complete machine product or a part of accessories;

6. a calculation formula module in the system contains a required operation formula, the budget cost is automatically calculated according to the requirement, and the working efficiency is improved;

7. starting and descending the data of each module and link, and sharing the data;

8. the authority is clear, the modular design is adopted, and the operation and maintenance cost is reduced;

9. budgeting cost to realize a report of materials of each part, the cost of each process and the cost of each auxiliary material;

10. the method avoids the summary material of the same materials of the project and avoids the problem of being unfavorable for outputting the part level data of the project;

11. multiple algorithms support the operation of project cost data;

12. the project BOM can be copied and decomposed, can generate a plurality of reports such as lathe working hour reports and material reports, and can be generated flexibly.

Drawings

In order to more clearly illustrate the detailed description of the invention or the technical solutions in the prior art, the drawings that are needed in the detailed description of the invention or the prior art will be briefly described below. Throughout the drawings, like elements or portions are generally identified by like reference numerals. In the drawings, elements or portions are not necessarily drawn to scale.

FIG. 1 is a diagram of the relationship between system modules of a mechanical industry project cost calculation system and its method of implementation;

FIG. 2 is a flow chart of the steps of calculating material cost when the part material is non-profile for a machine industry project cost calculation system and method of implementing the same;

FIG. 3 is a flow chart of the steps of calculating material cost when the part material is a profile for a machine industry project cost calculation system and method of implementing the same;

FIG. 4 is a flow chart of steps in calculating component labor time costs for a machine industry project cost calculation system and method of implementing the same;

FIG. 5 is a flow chart of steps for calculating part and part additive costs for a machine industry project cost calculation system and method of implementation thereof;

FIG. 6 is a flow chart of steps in calculating component costs for a machine industry project cost calculation system and method of implementing the same;

FIG. 7 is a flowchart of the steps of calculating assembly costs for a machine industry project cost calculation system and method of implementing the same;

FIG. 8 is a dataflow diagram of a machine industry project cost calculation system and its implementation method;

FIG. 9 is a flowchart of the steps for calculating the cost budget for a machine industry project cost calculation system and method of implementing the same;

FIG. 10 is a flow chart of steps in calculating actual completion costs for a machine industry project cost calculation system and method of implementing the same;

FIG. 11 is a flowchart of the steps for comparing project budget cost to actual completion cost for a mechanical industry project cost calculation system and method of implementing the same.

Detailed Description

As shown in fig. 1, the project cost calculation system in the mechanical industry includes a project management module, a budget cost module, an actual completion cost module, a project cost analysis module, a basic data module, and a calculation formula module, where data among the modules are interrelated, and input and output link relations are clear, so as to facilitate data transfer, system maintenance, and configuration and management of rights.

The project management module is responsible for managing project numbers, including operations of creation, modification, locking, unlocking and the like, and is responsible for receiving application of project budgets and receiving notification of project startup and completion; the system is responsible for carrying out data linkage with other modules and extracting drawings and process data in a technical system; the generated project number is unique, which is crucial to project management throughout the life cycle of the project, the generation rule of the project number is set by enterprises, and the uniqueness is a necessary principle; the item description is searched by matching with the item number, and can be Chinese characters or characters; the general order category item number is (D2020-01-12) item description is pulp paper mechanical item; the order for the part is (P2020-01-12) pulp paper mechanical part; the item number is required to be placed in brackets, and is a rule set by a background when the system is generated, and the system searches the item number according to the rule. The BOM data of the project consists of all parts, and is provided with a specification list containing important information such as specification type, process route, auxiliary material specification and the like; the person organizing the project data is responsible for generating and providing subsequent module applications. The project management module is communicated with databases of other systems, such as a technical database, an equipment database, a process database, a warehouse management database and the like, so that data sharing is realized, and project data are accurately organized.

The budget cost module refers to that a budget specialist depends on the functions of the project management module, the basic data module and the calculation formula module, the budget cost of each component in the organized project BOM is generated in detail by using a calculation formula module algorithm and a data table of the basic data module, the assembly component cost is generated by cyclic calling, the total budget cost of the project is finally obtained, and a sales clerk is provided to negotiate with a client; after the order is signed, the order is responsible for publishing and filing the project budget cost. The project budget BOM can be copied and decomposed, and can generate a plurality of reports such as lathe working hour reports, material reports and the like.

The actual finished cost module is used for organizing, arranging and manufacturing BOMs, issuing a purchasing plan to a purchasing department, issuing a workshop operation plan and issuing a material receiving limit to a warehouse project when an actual cost specialist relies on the functions of the project management module and the budget cost module and informs the project of formally starting manufacturing by the project department, and after the manufacturing process of a workshop is finished, the project is locked and can not be operated any more; if special conditions exist, the project can be unlocked by approval; the module calls all data related to the project in the warehouse management system and the equipment management system, and integrates the data to obtain the actual cost (actual material cost, actual working hour cost and actual auxiliary material cost) of the project.

The cost analysis module calls data related to the project by relying on functions of the project management module, the budget cost module and the actual completion cost module, and comprehensively analyzes budget material cost, budget working hour cost, budget auxiliary material cost, actual working hour cost and actual auxiliary material cost of the project. After the completion and the transfer of the project are informed, the project is locked, the system starts to collect all information project modules related to the project for analysis, and a summary report is carried out as required and is provided for a superior leader and a decision maker to apply.

The basic data module is basic information of a supporting cost calculation formula module in the system, such as a material density table (for example, the density of a material Q235B corresponds to 7.85kg/cm3), a special character table (for example, x and x are written in the specification and model of raw materials and executed according to enterprise standardization), a section unit weight table (for example, the section unit weight corresponding to 25 x 3 of the angle steel specification of Q235 is 1.124kg/m), a material market price table (for example, the angle steel of the material Q235B is 45 yuan/m, and the price is maintained along with market fluctuation), an equipment time value table (for example, the time value of SKG-2E is 20 yuan/h and executed according to enterprise standardization), and the like, and the data are specially maintained and periodically updated to be called by the calculation module according to requirements.

The calculation formula module is responsible for formulation and maintenance of cost-related calculation formulas, such as formulation and maintenance of material cost, working hour cost, auxiliary material cost, part cost, assembly part cost and other formulas, supports operation of the whole system, is convenient and flexible to maintain, sets various formulas and algorithms required in the system in advance by the calculation formula module, and facilitates calling of the budget cost module and the actual completion cost module as required.

The calculation formula module comprises calculation of material cost of the component, calculation of labor hour cost of the component, calculation of auxiliary material cost of the component, calculation of cost of the component and calculation of assembly cost.

The component material cost calculation methods include the following two methods:

method 1, as shown in fig. 2, when the component material is a non-profile material, the method for calculating the cost of the component material is as follows:

(Note: the calculation of the volume N1 distinguishes between plates, tubes, round bars, flat bars, etc.).

For example, the material of the plate used for the component is Q235B, and the specification model is 1566mm multiplied by 160mm multiplied by 10mm, wherein the material volume N1 is (1566 multiplied by 160 multiplied by 10) mm 3; the material density N2 is 7.85kg/cm 3; the material unit price S is 3 yuan/kg; the material cost Z of the resulting part is calculated to be N1 × N2 × S/1000000 ═ 1566 × 160 × 10 × 7.85 × 3/1000000 ═ 59.006 yuan.

Method 2, as shown in fig. 3, when the component material is a profile, the method for calculating the component material cost is as follows:

For example, the material Q235A of the channel steel is in a specification and model of [80mm multiplied by 43mm multiplied by 5mm-3000mm, wherein the unit weight N of [80mm multiplied by 43mm multiplied by 5mm is 8.045 kg/m; the length H of the material is 3000 mm; the material unit price S is 5.4 yuan/kg; the material cost Z of the resulting part is calculated to be N × H × S8.045 × 3000 × 5.4/1000 130.329 yuan.

As shown in fig. 4, the method of calculating the component man-hour cost is as follows:

For example, the part has a two-step process route, 60 minutes for sawing machine S-12T (value 20 yuan/hour), 180 minutes for lathe C5116E (value 25 yuan/hour); the man-hour cost G ═ H1 × K1+ H2 × K2 ═ 60/60 × 20+180/60 × 25 ═ 95 dollars for the resulting parts were calculated.

As shown in fig. 5, the method for calculating the auxiliary material cost is as follows:

For example, the component has two auxiliary material routes, namely 8kg (unit price of 6.06 yuan/kg) for solid welding wire ER50-6 and 20kg (unit price of 56.41 yuan/kg) for flux-cored welding wire E2209; the excipient cost F of the resulting part is calculated to be 8 × 6.06+20 × 56.41-1176.68 yuan.

As shown in fig. 6, the method of the component cost calculation is as follows:

For example, the formula 1)2)3)4) is utilized to obtain that the component material is Q235B, the specification model is 1566mm multiplied by 160mm multiplied by 10mm, two process routes are 60 minutes for sawing machine S-12T and 180 minutes for lathe C5116E, and two auxiliary material routes are 8kg for solid core welding wire ER50-6 and 20kg for flux core welding wire E2209, and the total component cost U is calculated to be the material cost Z + the labor cost G + the auxiliary material cost F is calculated to be 59.006+95+1176.68 to be 1330.686 yuan.

As shown in fig. 7, the method of assembly cost calculation is as follows:

For example, after the budget cost of each component is obtained, the system obtains the budget costs of all components in the whole project by using a calculation method of loop and nested call according to the call relationship between the upper-level component and the lower-level component. If the cost of the subordinate component 1 of a certain assembly is 100 yuan, the cost of the subordinate component 2 is 200 yuan, and the cost of the subordinate component 3 is 300 yuan, the same assembly belongs to, and the material cost of the assembly is obtained after the sum; if the man-hour cost of the assembly is 50; if the package has an inventory cost of 20; then, the assembly cost Y is calculated as (component cost U1+ component cost U2+ component cost U2 … …) + the man-hour cost of the module + the auxiliary material cost of the module as 100+200+300+50+20 as 670 yuan.

As shown in fig. 8, the implementation method of the project cost calculation system in the mechanical industry includes the following specific steps:

step seven, the business personnel of the purchasing department purchases materials according to a purchasing plan and puts the materials into storage according to market price after the materials come; the workshop material taking personnel go to the warehouse according to the material taking limit of the project to take the raw materials and the auxiliary materials, use the raw materials and the auxiliary materials according to the requirement, and return the surplus raw materials to the original warehouse; the main and the subordinate in the workshop develop the material preparation, the processing, the assembly welding and the assembly of the parts according to the workshop operation plan, and when the work piece is put into a warehouse for operation, the application working hours (standard working hours made by the process) of the work piece on each lathe can be recorded into the system;

and step nine, after the project is finished, a project department specialist can automatically extract all relevant data of the project, budget cost and actual cost in the project cost analysis module, and the project cost analysis module carries out required cost analysis.

The personnel work in each link related to data entry and application in the invention is divided into labor, the operation of personnel in each link is the post and the corresponding authority set by the system, and the data arrangement is standardized; the system can accurately transfer data only when the responsibility is clear, and can carry out reduction when the data entry is wrong and the system sets a corresponding error correction function.

As shown in FIG. 9, the implementation method of the computing system for project cost of the mechanical industry includes an implementation method of a budget cost module, and the implementation method of the budget cost module includes the following steps:

step two, if the project department specialist finds that no drawing or process exists, the project department timely informs the technical department of organizing the design of the drawing or process according to the requirements of customers; if the project department specialist finds the drawing, drawing and process data detail can be extracted according to the requirements of customers;

and step six, signing the order, filing budget data BOM, and not modifying.

The implementation method of the budget cost module shows that the total cost of the project budget is manufactured by applying and manufacturing the budget to provide a quotation application form, acquiring a data BOM list from the system by a budget specialist, and then acquiring a calculation module formula to obtain the cost of the component and the assembly part (the calculation formula of the specific application is explained in detail in the calculation formula module).

As shown in FIG. 10, the method of implementing a computing system for project costs in the machine industry includes an actual as-built cost module implementation method, including the steps of:

step one, after an order is signed, a project department specialist issues a making notice, a budget cost BOM is a data support for signing the order, a production system receives the order, and a manufacturing BOM of the project is organized according to the budget BOM;

step four, decomposing the manufacturing BOM into delivery details of a warehouse, delivering the warehouse to a workshop according to the delivery details, and automatically recording each part (including raw materials and auxiliary materials) of the project by a system during delivery;

step seven, the actual cost of the project is that after the project is finished, the system extracts the material receiving data (including material cost and auxiliary material making into a guarantee amount) of the warehouse and the labor hour cost data of the part finishing warehouse according to the project number, and the data are summarized into the actual cost data of the project; when applied to cost accounting, EXCEL or other desired reports may be derived.

The implementation method of the actual completion cost module shows that the required purchasing plan, workshop operation plan and warehouse material receiving quota are generated by utilizing the algorithm of the calculation module from the manufacture of the project notification manufacture part to the acquisition of the manufacture BOM detail, and the actual cost of the project is systematically collected and extracted through the management and control of the process.

As shown in fig. 11, the implementation method of the project cost calculation system in the mechanical industry includes an implementation method of a project cost analysis module, and the implementation method of the project cost analysis module includes the following steps:

and step one, completing the project making, marking the system project forward mark as True, and locking the relevant data of the project.

And step two, the project analysis system selects the project number to be analyzed and extracts the cost in real time.

Step three, the system will run for a period of time, retrieving all data for the cost associated with the project to be aggregated.

And step four, prompting that the retrieval is successful, and presenting the data to a temporary table.

And step five, selecting the parts for comparative analysis, and screening the selected part information by the system to perform a related summary report.

And step six, selecting options of the whole project comparative analysis, such as material summarizing and comparison, working hour summarizing and comparison, auxiliary material summarizing and the like, and extracting and summarizing the report forms by the system according to the requirements.

The implementation method of the project cost analysis module shows that after the project balance notification, the project module locks the project, and the system starts to collect all information related to the project and extracts and summarizes reports according to requirements.

Compared with the prior art, the invention has the following advantages:

1. the authority is clear, the authority of each post in the system is configured according to actual work needs, and if the post responsibility changes, the authority needs to be completed in time. Such as: the sales clerk and the accessory clerk are responsible for submitting budget applications in the system; the project department special staff is responsible for issuing project start-up and completion notifications in the system; budgeters are responsible for the budget of a project; the manufacturing department planner is responsible for making the operation plan of the purchasing and workshop and the material receiving limit used by the warehouse; the business personnel of the purchasing department is responsible for purchasing and warehousing the materials; the warehouse manager is responsible for delivery; leaders are responsible for approvals in the system, and so on.

2. Data of each business link is strictly input according to standardization, the upper link and the lower link are matched with the data to automatically circulate, through the design of a system and the combination of functional modules, business processes are integrated, a plurality of links such as technology, process, warehouse, production, cost and the like are opened, data sharing application is achieved, a data island is opened, data sources are consistent, repeated operation business links are cancelled, the integrity of a database is realized through the matching of all links, and the accuracy of the data is improved.

3. The project management capability of the mechanical industry can be improved, so that the problem of unreal project cost of manual arrangement is thoroughly solved, repeated business links are reduced, each link of manual arrangement of data is cancelled, the business process is integrated, the working efficiency is improved, and the data accuracy is improved.

4. Various databases are opened, and data can be extracted across the databases; the functions of all modules are distinct and are mutually dependent; multiple algorithms support the operation of cost data; the manual calculation cost is saved, and the labor cost is saved; starting and descending the data of each link, and sharing the data; the system automatically operates, and the efficiency and the data accuracy are improved; the authority is clear, the modular design is adopted, and the operation and maintenance cost is reduced; the estimated cost can be reported according to the mechanical industry mode, and the materials of each part, the cost of each process and the cost of each auxiliary material can be realized; the actual cost can realize uploading the auxiliary material list to the delivery platform, so that the gathering and material receiving of the same materials of the project are avoided, and the problem of being not beneficial to outputting the data of the project part level is avoided.

The description of the present invention has been presented for purposes of illustration and description, and is not intended to be exhaustive or limited to the invention in the form disclosed. Many modifications and variations will be apparent to practitioners skilled in this art. The embodiment was chosen and described in order to best explain the principles of the invention and the practical application, and to enable others of ordinary skill in the art to understand the invention for various embodiments with various modifications as are suited to the particular use contemplated.

Claims

1. A system for calculating project cost in the machine industry, comprising: the project cost analysis system comprises a project management module, a budget cost module, an actual completion cost module, a project cost analysis module, a basic data module and a calculation formula module;

the project management module is responsible for managing project numbers including creation, modification, locking and unlocking, receiving application of project budgets, receiving notification of project start-up and completion, carrying out data linkage with other modules and extracting drawings and process data in a technical system;

the budget cost module is based on the functions of the project management module, the basic data module and the calculation formula module, after a budget making application is received, the budget cost of parts of each part in the project BOM detail is generated in time, the budget cost of an assembly part is generated through cyclic calling, and finally the total budget cost of the project is obtained;

the actual completion cost module is responsible for organizing and arranging the manufacturing BOM details of the project after receiving the project starting and manufacturing notice by relying on the functions of the project management module and the budget cost module, and the system is automatically decomposed into a purchasing plan of a purchasing department, a workshop operation plan and a material receiving limit of a warehouse project; after each part of the project is manufactured, the module calls all actually generated data related to the project, and the actual cost of the project is obtained through summarization;

the cost analysis module collects all data of the project budget cost and the actual completion cost by relying on the functions of the project management module, the budget cost module and the actual completion cost module, and comprehensively analyzes the material cost, the working hour cost and the auxiliary material cost;

the basic data module is responsible for maintaining data such as a material table, a density table, a special character table, a section unit weight table, a material market price table, an equipment time value table and the like, is basic data information for supporting the calculation formula module in the system and participates in calculation of related cost data;

the calculation formula module is responsible for making and maintaining calculation formulas related to cost, and the calculation formulas comprise component material cost calculation, component working hour cost calculation, component auxiliary material cost calculation, component total cost calculation and assembly part cost calculation. The calculation formula module is also an independently operated module and is used for calling during data operation of other modules.

2. The machine industry project cost calculation system of claim 1, wherein: if the component material is a non-profile, the component material cost is calculated as follows:

3. The machine industry project cost calculation system of claim 1, wherein: if the component material is a profile, the component material cost calculation method is as follows:

4. The machine industry project cost calculation system of claim 1, wherein: the method of component man-hour cost calculation shown is as follows:

5. The machine industry project cost calculation system of claim 1, wherein: the method for calculating the auxiliary material cost comprises the following steps:

acquiring the names and materials of auxiliary materials in each part, and inquiring to obtain unit price K corresponding to the auxiliary materials by using an auxiliary material price table maintained by a basic data module; then obtaining the quantity M of each auxiliary material; the formula of the auxiliary material cost is M multiplied by K; the formula F for calculating the cost of the auxiliary materials for the parts is equal to the total cost of all auxiliary materials, i.e. M1 × K1+ M2 × K2+ M3 × K3 … ….

6. The machine industry project cost calculation system of claim 1, wherein: the method of component cost calculation is as follows:

7. The machine industry project cost calculation system of claim 1, wherein: the assembly cost calculation method is as follows:

8. The implementation method of the project cost calculation system in the mechanical industry is characterized in that: the implementation method is applied to a computing system of actual cost and budget cost of the mechanical industry project according to any one of claims 1 to 7;

the implementation method comprises the following specific steps:

9. The method of claim 8, wherein the computing system is further configured to: the implementation method also comprises an implementation method of the budget cost module, and the implementation method of the budget cost module comprises the following steps:

step three, acquiring information, code number, name, material, quantity and the like of each part in the project budget BOM list, acquiring a process route and an auxiliary material process of each part, and organizing and generating the project budget BOM list;

and step six, signing the order, filing budget data BOM, and not modifying.

10. The method of claim 8, wherein the computing system is further configured to: the implementation method also comprises an implementation method of the actual completion cost module, and the implementation method of the actual completion cost module comprises the following steps: