CN104700170A - Cost calculation tree generation method and cost calculation tree generation device - Google Patents

Cost calculation tree generation method and cost calculation tree generation device Download PDF

Info

Publication number
CN104700170A
CN104700170A CN201310655289.6A CN201310655289A CN104700170A CN 104700170 A CN104700170 A CN 104700170A CN 201310655289 A CN201310655289 A CN 201310655289A CN 104700170 A CN104700170 A CN 104700170A
Authority
CN
China
Prior art keywords
supplies consumption
tree
path
circulating path
cost
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CN201310655289.6A
Other languages
Chinese (zh)
Other versions
CN104700170B (en
Inventor
赵复科
李长山
赵林
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Aisino Corp
Original Assignee
Aisino Corp
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Aisino Corp filed Critical Aisino Corp
Priority to CN201310655289.6A priority Critical patent/CN104700170B/en
Publication of CN104700170A publication Critical patent/CN104700170A/en
Application granted granted Critical
Publication of CN104700170B publication Critical patent/CN104700170B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Landscapes

  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)
  • General Factory Administration (AREA)

Abstract

The invention discloses a cost calculation tree generation method and a cost calculation tree generation device. The method includes the steps: acquiring cost data generated in a production process, and generating a material consumption relation according to the cost data; constructing a material consumption relational tree according to the material consumption relation, deducing a cost calculation sequence during construction of the material consumption relational tree, and checking whether cyclic material receiving exists or not after each branch of the material consumption relational tree is constructed; if cyclic material receiving routes exist in the cost calculation sequence deducing process, listing the cyclic routes and materials capable of disconnecting the cyclic material receiving routes; disconnecting the materials of each cyclic route according to the listed cyclic routes and the materials capable of disconnecting the cyclic material receiving routes, and re-executing the step of constructing the material consumption relational tree according to the material consumption relation until no cyclic material receiving routes exists.

Description

A kind of manufacturing cost calculates the method and apparatus of tree
Technical field
The present invention relates to data processing field, calculate the method and apparatus of tree in particular to a kind of manufacturing cost.
Background technology
ERP(Enterprise Resource Planning, Enterprise Resources Planning) be an accounting for management be the infosystem of core, identify and planning Enterprise Resource, thus obtain customer order, complete processing and pay, finally obtaining customer payment.In other words, ERP, plans buying, production, cost, stock, distribution, transport, finance, human resources by all for enterprises resource consolidations together, thus reaches best resource combination, obtain optimum efficiency, be also conducive to enterprise simultaneously and the market demand is made a response rapidly.
At present, the information that the enterprise information management system based on ERP management software framework provided of the supvr of existing a lot of enterprise is as one of the important evidence of business decision.The cost of enterprise is one of important evidence of supvr's decision-making.Production cost, as an important component part of enterprise cost, therefore needs the production cost accurately and timely calculating enterprise.But the production run of generation type enterprise and complex process, the computation process causing production cost is also very complicated.
Step of calculating the cost of production is: first determine cost objective to be calculated, then the data such as indirect expense, direct cost and the output occurred in production run are collected, then by the indirect expense collected according to the regular allocation defined to corresponding cost center and cost objective, obtain supplies consumption relation derivation according to cost data again and go out pricing order, finally successively upwards expense is distributed in the completion of final cost object with between product from the material (i.e. starting material) that pricing order is maximum, obtain final production cost.
Pricing order is producing the important evidence of distributing as carrying out completing, and therefore derives pricing order correctly, fast extremely important.BOM(Bill of Material in production enterprise, Bill of Material (BOM)) have recorded the important foundation data of producing certain product consumable material, originally can be used as the foundation of derivation pricing order, but may the material that it consumes be adjusted owing to producing same article in different production batch or order, therefore directly according to BOM derivation pricing order, spent material information inference pricing order should can not be produced according to real.
Summary of the invention
The invention provides the method and apparatus that a kind of manufacturing cost calculates tree, calculate tree in order to quick, easy manufacturing cost.
For achieving the above object, the invention provides a kind of method that manufacturing cost calculates tree, comprising the following steps:
Obtain the cost data occurred in production run, and generate supplies consumption relation according to cost data;
According to supplies consumption relation structure supplies consumption relational tree, pricing order of deriving in the process of structure supplies consumption relational tree, and after often having constructed a supplies consumption relational tree branch, check whether it can produce circulation neck material;
If create circulation neck material path in derivation pricing sequential process, then list circulating path and the material that can disconnect this circulation neck material path;
According to listed circulating path and the material disconnecting circulating path, disconnect the material of each circulating path, re-execute according to supplies consumption relation structure supplies consumption relational tree step, till neck material path of not circulating produces.
Optionally, from each system of ERP, collect the various cost datas occurred in production run.
Optionally, when obtaining from external system the cost data occurred in production run, by the mode of called Web service (Web Service), by the document in external system with XML(eXtensible MarkupLanguage, extend markup language) mode of character string obtains, and be stored into after treatment and collect in database table.
Optionally, when finding out circulation neck material path, this circulating path and all materials disconnecting this circulating path are shown in the lump, select for user, and again construct supplies consumption relational tree and derivation pricing order, till not having circulating path to produce according to the material of user-selected this circulating path of disconnection.
Optionally, by the various cost data in the production run obtained from each system of ERP and the supplies consumption relational storage that generates according to various cost data in a database.
For achieving the above object, present invention also offers the device that a kind of manufacturing cost calculates tree, comprising:
Expense collects module, collects the various cost datas occurred in production run from each system of ERP;
Supplies consumption relation generation module, collects according to expense the cost data that module collects and generates supplies consumption relation;
Supplies consumption relational tree constructing module, supplies consumption relational tree is generated according to the supplies consumption relation that supplies consumption relation generation module generates, to derive while structure supplies consumption relational tree the pricing order of each material, and after often having constructed a supplies consumption relational tree branch, check whether it can produce circulation neck material;
Circulating path disconnection module, if be checked through circulation neck material path in supplies consumption relational tree construction process, then the material listing all circulating paths and each circulating path of disconnection accepts the selection of user, and disconnects each circulating path according to the selection of user;
Memory module, for storing supplies consumption data that supplies consumption relation generation module collects, the derive pricing tree and circulation neck material path that generate and user of supplies consumption relational tree constructing module select to disconnect the material of circulating path.
The present invention calculates tree with quick, easy manufacturing cost, disconnects neck material path of circulating flexibly.Namely only need namely can derive pricing according to the producing cost data genaration supplies consumption relation structure supplies consumption relational tree obtained from each system and check out all circulation neck material paths, can meet user by specifying the material disconnecting circulating path specifies material to disconnect circulating path, for follow-up calculating the cost of production more accurately establishes solid foundation.
Accompanying drawing explanation
In order to be illustrated more clearly in the embodiment of the present invention or technical scheme of the prior art, be briefly described to the accompanying drawing used required in embodiment or description of the prior art below, apparently, accompanying drawing in the following describes is only some embodiments of the present invention, for those of ordinary skill in the art, under the prerequisite not paying creative work, other accompanying drawing can also be obtained according to these accompanying drawings.
Fig. 1 is that the manufacturing cost of one embodiment of the invention calculates the method flow diagram set;
Fig. 2 is that the manufacturing cost of a preferred embodiment of the invention calculates the method flow diagram set;
Fig. 3 is the preliminary supplies consumption relational tree schematic diagram generated in one embodiment of the invention;
Fig. 4 is the final pricing tree schematic diagram generated in one embodiment of the invention;
Fig. 5 is that the manufacturing cost of one embodiment of the invention calculates the apparatus structure block diagram set.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present invention, be clearly and completely described the technical scheme in the embodiment of the present invention, obviously, described embodiment is only the present invention's part embodiment, instead of whole embodiments.Based on the embodiment in the present invention, those of ordinary skill in the art, not paying the every other embodiment obtained under creative work prerequisite, belong to the scope of protection of the invention.
Fig. 1 is that the manufacturing cost of one embodiment of the invention calculates the method flow diagram set; As shown in the figure, the method comprises the following steps:
S110, obtains the cost data occurred in production run, and generates supplies consumption relation according to cost data;
Wherein, the mode obtaining in production run the cost data occurred can have two kinds, one be to collect from each system of ERP systems such as (as manufactured) supply chain and finance in production run the various cost datas that occur; One is obtain from external system, when obtaining in production run from external system the cost data occurred, by the mode of called Web service, is obtained by the document in external system in the mode of XML character string, and is stored into after treatment and collects in database table.
S120, according to supplies consumption relation structure supplies consumption relational tree, pricing order of deriving in the process of structure supplies consumption relational tree, and after often having constructed a supplies consumption relational tree branch, check whether it can produce circulation neck material;
S130, if create circulation neck material path in derivation pricing sequential process, then lists circulating path and the material that can disconnect this circulation neck material path;
Wherein, when finding out circulation neck material path, this circulating path and all materials disconnecting this circulating path are shown in the lump, select for user, and again construct supplies consumption relational tree and derivation pricing order, till not having circulating path to produce according to the material of user-selected this circulating path of disconnection.
S140, according to listed circulating path and the material disconnecting circulating path, disconnects the material of each circulating path, re-executes according to supplies consumption relation structure supplies consumption relational tree step, till neck material path of not circulating produces.
In specific implementation process, can store in a database by the various cost data in the production run obtained from each system of ERP and according to the supplies consumption relation that various cost data generates.
Above-described embodiment can fast, easy manufacturing cost calculates tree, disconnects circulation neck material path flexibly.Namely only need namely can derive pricing according to the producing cost data genaration supplies consumption relation structure supplies consumption relational tree obtained from each system and check out all circulation neck material paths, can meet user by specifying the material disconnecting circulating path specifies material to disconnect circulating path, for follow-up calculating the cost of production more accurately establishes solid foundation.
Fig. 2 is that the manufacturing cost of a preferred embodiment of the invention calculates the method flow diagram set; As shown in the figure, Fig. 2 illustrates the process that a complete manufacturing cost calculates tree:
101, collect from systems such as the manufacturing, supply chain and finance the cost data produced production run;
First, in other system, fill in relevant document, and store in a database.Collect module click collect button, system judges whether to peek from external system.If not external system, then eject DataBase combining configuration, the address of supply chain, fiscal module and table are configured, after determining from these databases purpose data classifying to cost data table.If external system, then by calling Web Service(network service) mode, the document in system is passed to cost model in the mode of XML character string, is stored into after treatment and collects database table.
102, supplies consumption relation is generated according to the cost data collected;
In supplies consumption relation generation module, click and generate button.Now program can obtain the data collected in tables of data, generates supplies consumption relation by related algorithm, as shown in table 1, and result is presented in interface.
Table 1
Sequence number Accounting period Product Material State
1 2012.11 A B 1
2 2012.11 B C 1
3 2012.11 B D 1
4 2012.11 C E 1
5 2012.11 C F 1
6 2012.11 D B 1
7 2012.11 E D 1
103, constructions cost calculates tree, checks circulation neck material path;
Click tree and generate button, according to supplies consumption relation, derivation manufacturing cost calculates tree.
First, the pricing order of preset all products is 0, obtains product A and consumes the material B that sequence number is 1, construct the branch A->B of supplies consumption relational tree accordingly according to supplies consumption relation.Check that before the branch of B place, all material is A, does not comprise material B, there is not circulation neck material path, the pricing order of the B that can derive.Because the pricing order of A is 0, the pricing order deriving B is accordingly 1.
In like manner, carry out all products of searching loop, process its pricing order, and data are stored in database.After progressively constructing supplies consumption relational tree and derivation pricing tree, the supplies consumption relational tree shown in Fig. 3 finally, the pricing order shown in table 2 and the neck of the circulation shown in table 3 material path can be obtained.Owing to there is circulation neck material path, so the data in pricing sequence list are incorrect, again calculate after needing the material of the disconnection circulating path selected according to user.
Table 2
Sequence number Accounting period Material Pricing order
1 2012.11 A 0
2 2012.11 B 1
3 2012.11 C 2
4 2012.11 D 4
5 2012.11 E 3
6 2012.11 F 3
Table 3
Sequence number Accounting period Circulating path Disconnect circulation article
1 2012.11 B->D->B
2 2012.11 B->C->E->D->B
104, disconnect circulation, re-construct pricing tree;
Pricing according to primary structural elements is set, and judges whether to there is circulation, then submits to data to be stored into database without circulation.Otherwise the material that prompting disconnects each circulating path is selected for user, user selects it to think and then re-constructs the mode more reasonably disconnecting circulating path pricing tree, finally calculate production cost more accurately.
User, according to the circulating path of interface display, selects article to carry out opening operation, by disconnected node information stored in database.Again upgrade material relationships table after disconnection, as shown in table 4, the state of gap becomes 0.According to the supplies consumption relation disconnected behind circulation neck material path derivation pricing tree again.When there being multiple final finished product, construct supplies consumption relational tree one by one by final finished product, manufacturing cost calculates tree.
Final pricing tree generation is complete is stored into database, and is illustrated in interface, as shown in Figure 4.
Table 4
Sequence number Accounting period Material Pricing order
1 2012.11 A 0
2 2012.11 B 1
3 2012.11 C 0
4 2012.11 D 2
5 2012.11 E 1
6 2012.11 F 1
Fig. 5 is that the manufacturing cost of one embodiment of the invention calculates the apparatus structure block diagram set.As shown in Figure 5, this device comprises:
Expense collects module, collects the various cost datas occurred in production run from each system of ERP;
Supplies consumption relation generation module, collects according to expense the cost data that module collects and generates supplies consumption relation;
Supplies consumption relational tree constructing module, supplies consumption relational tree is generated according to the supplies consumption relation that supplies consumption relation generation module generates, to derive while structure supplies consumption relational tree the pricing order of each material, and after often having constructed a supplies consumption relational tree branch, check whether it can produce circulation neck material;
Circulating path disconnection module, if be checked through circulation neck material path in supplies consumption relational tree construction process, then the material listing all circulating paths and each circulating path of disconnection accepts the selection of user, and disconnects each circulating path according to the selection of user;
Memory module, for storing supplies consumption data that supplies consumption relation generation module collects, the derive pricing tree and circulation neck material path that generate and user of supplies consumption relational tree constructing module select to disconnect the material of circulating path.
As shown in Fig. 2, Fig. 5, during derivation pricing order, first collect module from all cost datas the system taking-up production runes such as the manufacturing, supply chain, finance in expense; Generate supplies consumption relation in supplies consumption relation generation module by these cost datas again, be stored in the supplies consumption relation table of memory module; Then supplies consumption relational tree is constructed at supplies consumption tree constructing module by supplies consumption relation, and check circulation neck material path and derivation pricing order, the circulation be checked through neck material path is saved in circulating path table and the pricing sequence list of memory module; Finally disconnect module in circulation and disconnect circulation neck material path according to the material that user selectes.
One of ordinary skill in the art will appreciate that: accompanying drawing is the schematic diagram of an embodiment, the module in accompanying drawing or flow process might not be that enforcement the present invention is necessary.
One of ordinary skill in the art will appreciate that: the module in the device in embodiment can describe according to embodiment and be distributed in the device of embodiment, also can carry out respective change and be arranged in the one or more devices being different from the present embodiment.The module of above-described embodiment can merge into a module, also can split into multiple submodule further.
Last it is noted that above embodiment is only in order to illustrate technical scheme of the present invention, be not intended to limit; Although with reference to previous embodiment to invention has been detailed description, those of ordinary skill in the art is to be understood that: it still can be modified to the technical scheme described in previous embodiment, or carries out equivalent replacement to wherein portion of techniques feature; And these amendments or replacement, do not make the essence of appropriate technical solution depart from the spirit and scope of embodiment of the present invention technical scheme.

Claims (6)

1. manufacturing cost calculates a method for tree, it is characterized in that, comprises the following steps:
Obtain the cost data occurred in production run, and generate supplies consumption relation according to described cost data;
According to described supplies consumption relation structure supplies consumption relational tree, pricing order of deriving in the process of the described supplies consumption relational tree of structure, and after often having constructed a supplies consumption relational tree branch, check whether it can produce circulation neck material;
If create circulation neck material path in derivation pricing sequential process, then list circulating path and the material that can disconnect this circulation neck material path;
According to listed circulating path and the material disconnecting circulating path, disconnect the material of each circulating path, re-execute described according to described supplies consumption relation structure supplies consumption relational tree step, till neck material path of not circulating produces.
2. manufacturing cost as claimed in claim 1 calculates the method for tree, it is characterized in that, collects the various cost datas occurred in production run from each system of ERP.
3. manufacturing cost as claimed in claim 1 calculates the method for tree, it is characterized in that, when obtaining from external system the cost data occurred in production run, by the mode of called Web service, document in external system is obtained in the mode of XML character string, and is stored into after treatment and collects in database table.
4. manufacturing cost as claimed in claim 1 calculates the method for tree, it is characterized in that, when finding out circulation neck material path, this circulating path and all materials disconnecting this circulating path are shown in the lump, select for user, and again construct supplies consumption relational tree and derivation pricing order, till not having circulating path to produce according to the material of user-selected this circulating path of disconnection.
5. manufacturing cost as claimed in claim 2 calculates the method for tree, it is characterized in that, by the various cost data in the production run obtained from each system of ERP and the supplies consumption relational storage that generates according to described various cost data in a database.
6. manufacturing cost calculates a device for tree, it is characterized in that, comprising:
Expense collects module, collects the various cost datas occurred in production run from each system of ERP;
Supplies consumption relation generation module, collects according to described expense the cost data that module collects and generates supplies consumption relation;
Supplies consumption relational tree constructing module, supplies consumption relational tree is generated according to the supplies consumption relation that described supplies consumption relation generation module generates, to derive while structure supplies consumption relational tree the pricing order of each material, and after often having constructed a supplies consumption relational tree branch, check whether it can produce circulation neck material;
Circulating path disconnection module, if be checked through circulation neck material path in supplies consumption relational tree construction process, then the material listing all circulating paths and each circulating path of disconnection accepts the selection of user, and disconnects each circulating path according to the selection of user;
Memory module, for storing supplies consumption data that supplies consumption relation generation module collects, the derive pricing tree and circulation neck material path that generate and user of supplies consumption relational tree constructing module select to disconnect the material of circulating path.
CN201310655289.6A 2013-12-05 2013-12-05 A kind of method and apparatus that manufacturing cost calculates tree Active CN104700170B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201310655289.6A CN104700170B (en) 2013-12-05 2013-12-05 A kind of method and apparatus that manufacturing cost calculates tree

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201310655289.6A CN104700170B (en) 2013-12-05 2013-12-05 A kind of method and apparatus that manufacturing cost calculates tree

Publications (2)

Publication Number Publication Date
CN104700170A true CN104700170A (en) 2015-06-10
CN104700170B CN104700170B (en) 2018-08-24

Family

ID=53347266

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201310655289.6A Active CN104700170B (en) 2013-12-05 2013-12-05 A kind of method and apparatus that manufacturing cost calculates tree

Country Status (1)

Country Link
CN (1) CN104700170B (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107506951A (en) * 2017-10-11 2017-12-22 金蝶软件(中国)有限公司 The computational methods and relevant apparatus of a kind of Material Cost
CN110956389A (en) * 2019-11-28 2020-04-03 金蝶软件(中国)有限公司 Nesting inspection method and device and storage medium

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101510281A (en) * 2009-03-23 2009-08-19 金蝶软件(中国)有限公司 System and method for determining cost calculation step
CN101714225A (en) * 2009-10-28 2010-05-26 金蝶软件(中国)有限公司 Method and device for calculating product cost
CN102004976A (en) * 2010-12-31 2011-04-06 用友软件股份有限公司 Method and device for generating production cost calculating sequence
US20120185073A1 (en) * 2011-01-17 2012-07-19 DataNet Quality Systems Process Cost Analysis System
CN203102358U (en) * 2013-01-31 2013-07-31 东莞市盟大塑化科技有限公司 Plastic product cost accounting system based on Internet

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101510281A (en) * 2009-03-23 2009-08-19 金蝶软件(中国)有限公司 System and method for determining cost calculation step
CN101714225A (en) * 2009-10-28 2010-05-26 金蝶软件(中国)有限公司 Method and device for calculating product cost
CN102004976A (en) * 2010-12-31 2011-04-06 用友软件股份有限公司 Method and device for generating production cost calculating sequence
US20120185073A1 (en) * 2011-01-17 2012-07-19 DataNet Quality Systems Process Cost Analysis System
CN203102358U (en) * 2013-01-31 2013-07-31 东莞市盟大塑化科技有限公司 Plastic product cost accounting system based on Internet

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
张荣: "机械产品制造成本递归建模技术研究与应用", 《中国优秀博硕士学位论文全文数据库 (硕士) 工程科技Ⅱ辑》 *

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107506951A (en) * 2017-10-11 2017-12-22 金蝶软件(中国)有限公司 The computational methods and relevant apparatus of a kind of Material Cost
CN110956389A (en) * 2019-11-28 2020-04-03 金蝶软件(中国)有限公司 Nesting inspection method and device and storage medium

Also Published As

Publication number Publication date
CN104700170B (en) 2018-08-24

Similar Documents

Publication Publication Date Title
CN110826980A (en) ERP system based on cloud platform and operation method thereof
CN110796416B (en) Industrial networking based order processing method and computer storage medium
Zijm et al. Capacitated two-indenture models for repairable item systems
KR102111430B1 (en) PLM Apparatus and Managing Method Thereof
CN106156987A (en) The equalization methods of inventory variance and device
CN111985862A (en) Method and apparatus for locating inventory items
Kumar et al. Managing reverse exchanges in service supply chains
CN117035687A (en) Power grid business fixed asset process configuration method, system and computer storage medium
Li et al. A QFD-based evaluation method for business models of product service systems
Tafakkori et al. Disruption-resilient supply chain entities with decentralized robust-stochastic capacity planning
CN113780913B (en) Method and device for generating safety stock information
CN104700170A (en) Cost calculation tree generation method and cost calculation tree generation device
US20220164745A1 (en) Computer-based platform for customer-integrated supply chain management
CN115700669B (en) Material difference list generation method, electronic equipment and computer storage medium
US20190303815A1 (en) Distributed manufacturing system
Forghani et al. Contractor selection based on swot analysis with vikor and topsis methods in fuzzy environment
CN114327376A (en) IT architecture establishing method, IT architecture establishing device, processor and electronic equipment
CN112184026A (en) Purchase material quality feedback system based on cloud platform
Ceballos et al. Proposal of Improvement for a Textile Finishing Company in the Medellin city Through of Discrete Simulation
Petrović et al. A study of multi criteria decision making for selecting suppliers of linear motion guide
US20240095224A1 (en) Graph data processing methods and systems
Benedito et al. Optimal production and storage capacities in a system with reverse logistics and periodic demand
CN110648090A (en) Logistics process node management method and system
Ambrosio-Flores et al. Warehouse management model integrating BPM-Lean Warehousing to increase order fulfillment in SME distribution companies
Vakhranev et al. Organization of production based on auctions

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant