CN113837684A - Material price management method, device, equipment, storage medium and computer program - Google Patents
Material price management method, device, equipment, storage medium and computer program Download PDFInfo
- Publication number
- CN113837684A CN113837684A CN202110942626.4A CN202110942626A CN113837684A CN 113837684 A CN113837684 A CN 113837684A CN 202110942626 A CN202110942626 A CN 202110942626A CN 113837684 A CN113837684 A CN 113837684A
- Authority
- CN
- China
- Prior art keywords
- price
- raw material
- target
- management system
- current
- 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.)
- Pending
Links
- 238000007726 management method Methods 0.000 title claims abstract description 150
- 239000000463 material Substances 0.000 title claims abstract description 147
- 238000004590 computer program Methods 0.000 title claims abstract description 21
- 239000002994 raw material Substances 0.000 claims abstract description 242
- 239000013077 target material Substances 0.000 claims abstract description 127
- 238000000034 method Methods 0.000 claims abstract description 32
- 238000004364 calculation method Methods 0.000 claims description 21
- 230000008569 process Effects 0.000 claims description 20
- 230000008520 organization Effects 0.000 claims description 7
- 239000004615 ingredient Substances 0.000 claims description 4
- 238000012545 processing Methods 0.000 abstract description 19
- 230000001960 triggered effect Effects 0.000 description 5
- 238000004891 communication Methods 0.000 description 4
- 238000010586 diagram Methods 0.000 description 4
- 229910001369 Brass Inorganic materials 0.000 description 3
- RYGMFSIKBFXOCR-UHFFFAOYSA-N Copper Chemical compound [Cu] RYGMFSIKBFXOCR-UHFFFAOYSA-N 0.000 description 3
- HCHKCACWOHOZIP-UHFFFAOYSA-N Zinc Chemical compound [Zn] HCHKCACWOHOZIP-UHFFFAOYSA-N 0.000 description 3
- 230000009471 action Effects 0.000 description 3
- 230000008901 benefit Effects 0.000 description 3
- 239000010951 brass Substances 0.000 description 3
- 238000006243 chemical reaction Methods 0.000 description 3
- 229910052802 copper Inorganic materials 0.000 description 3
- 239000010949 copper Substances 0.000 description 3
- 238000013507 mapping Methods 0.000 description 3
- 239000011701 zinc Substances 0.000 description 3
- 229910052725 zinc Inorganic materials 0.000 description 3
- 230000005540 biological transmission Effects 0.000 description 2
- 230000002860 competitive effect Effects 0.000 description 2
- 238000007405 data analysis Methods 0.000 description 2
- 238000012423 maintenance Methods 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 238000013480 data collection Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012827 research and development Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000004083 survival effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/02—Marketing; Price estimation or determination; Fundraising
- G06Q30/0201—Market modelling; Market analysis; Collecting market data
- G06Q30/0206—Price or cost determination based on market factors
Landscapes
- Business, Economics & Management (AREA)
- Engineering & Computer Science (AREA)
- Strategic Management (AREA)
- Entrepreneurship & Innovation (AREA)
- Human Resources & Organizations (AREA)
- Economics (AREA)
- Finance (AREA)
- Accounting & Taxation (AREA)
- Development Economics (AREA)
- Theoretical Computer Science (AREA)
- Marketing (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- Game Theory and Decision Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a material price management method, a device, equipment, a storage medium and a computer program, wherein the method acquires the latest purchase price of raw materials from a cost management system through the price acquisition time of the raw materials based on a linkage rule; when the trigger linkage is determined based on the linkage rule price difference and the latest purchase price of the raw materials, acquiring information of target materials corresponding to the raw materials from a bill of material management system, wherein the information of the target materials comprises the unit consumption of the raw materials of the target materials; acquiring the current selling price of the target material from a material price management system; the adjusted price of the target material is determined according to the latest purchase price, the unit consumption of the raw material and the current sale price, and the cost management system, the bill of material management system and the material management system are subjected to linkage processing, so that the adjusted material price can be automatically determined due to the linkage effect when the price of the raw material changes, and the price management efficiency is effectively improved.
Description
Technical Field
The present invention relates to the field of price management technologies, and in particular, to a method, an apparatus, a device, a storage medium, and a computer program for material price management.
Background
Profitability refers to the ability of an enterprise to obtain profits within a certain period of time, and is also called capital or capital value-added ability, and the profitability is one of the most important business targets of the enterprise and is the basis of the survival and development of the enterprise. One of the key points of profitability lies in determining the price of the material, and the price determination needs to fully consider the price of the raw material in order to ensure the stability of profitability. The price of the material is directly influenced by the fluctuation of the price of the raw material. In order to better determine the price of the material, currently, multiple sets of systems are operated simultaneously to manually analyze the price difference management of the prices of purchased raw materials in an excel file.
However, the data analysis processing is performed on the excel files exported by a plurality of systems in a pure manual mode, and then the price of the material is determined, so that the burden of data processing personnel is increased, and meanwhile, the information hysteresis exists, so that the price management efficiency is relatively low.
Disclosure of Invention
The invention provides a material price management method, a material price management device, material price management equipment, a storage medium and a computer program, which are used for solving the defect of low working efficiency caused by complex manual material price management operation in the prior art, and realizing timely adjustment of material prices so as to improve the price management efficiency.
The invention provides a material price management method, which comprises the following steps:
acquiring the latest purchase price of the current raw material from the cost management system based on the price acquisition time of the raw material in the linkage rule;
when the trigger linkage is determined based on the linkage rule price difference and the latest purchase price of the raw materials, obtaining target materials corresponding to the current raw materials from a bill of materials management system, wherein the target materials comprise the unit consumption of the raw materials of the target materials;
capturing the current selling price of the target material from a material price management system;
and determining the adjusted price of the target material according to the latest purchase price, the unit consumption of the raw materials and the current sale price of the target material.
According to the material price management method provided by the invention, the linkage rule is established by determining the mutual linkage relation among the raw material, the price acquisition time of the raw material, the linkage rule price difference of the raw material and the target material corresponding to the raw material.
According to the material price management method provided by the invention, before the target material corresponding to the current raw material is obtained from the bill of material management system, the method further comprises the following steps:
determining a latest purchasing price difference of the current raw material from the cost management system, wherein the latest purchasing price difference is a difference value between the latest purchasing price and a historical purchasing price;
and if the latest purchase price difference is larger than or equal to the linkage rule price difference corresponding to the current raw material, triggering linkage.
According to a material price management method provided by the present invention, determining an adjusted price of the target material according to the latest purchase price, the unit consumption of the raw material, and the current selling price of the target material includes:
determining the unit raw material price difference of the latest purchase price difference;
determining the material price difference of the target material according to the unit raw material price difference and the unit consumption of the raw material;
and if the purchase information of the historical raw materials corresponding to the target material is consistent with the purchase information of the current raw materials, adding the material price difference and the current selling price to determine the adjusted price of the target material, wherein the purchase information comprises supplier information, purchase organization information and purchase type information.
According to the material price management method provided by the invention, the current raw materials comprise independent raw materials and/or combined raw materials;
when the current raw material is a combined raw material, the obtaining of the latest purchase price of the current raw material includes:
determining the ratio of each component of the combined raw material and the individual price of each component;
determining a latest purchase price for said combined raw material based on said ingredient proportions and said individual prices for said individual ingredients.
According to the material price management method provided by the present invention, after determining the adjusted price of the target material, the method further comprises:
generating price adjustment report details of the target material, wherein the report details comprise the adjusted price of the target material and the calculation process information of the adjusted price;
rechecking the calculation process of the adjusted price according to the calculation process information;
and when a rechecking passing instruction is received, updating the adjusted price to an sap price table in the material price management system so as to sell the target material at the adjusted price.
The present invention also provides a material price management device, including:
the acquisition module is used for acquiring the latest purchase price of the current raw material from the cost management system based on the price acquisition time of the raw material in the linkage rule;
the linkage module is used for acquiring a target material corresponding to the current raw material from a bill of material management system when determining to trigger linkage based on the linkage rule price difference of the raw material and the latest purchase price, wherein the target material comprises the unit consumption of the raw material of the target material;
the grabbing module is used for grabbing the current selling price of the target material from a material price management system;
and the determining module is used for determining the adjusted price of the target material according to the latest purchase price, the unit consumption of the raw materials and the current sale price of the target material.
The invention also provides an electronic device, which comprises a memory, a processor and a computer program stored on the memory and capable of running on the processor, wherein the processor executes the program to realize the steps of the material price management method.
The invention also provides a non-transitory computer readable storage medium having stored thereon a computer program which, when being executed by a processor, carries out the steps of the material price management method according to any of the above.
The invention also provides a computer program product comprising a computer program which, when executed by a processor, carries out the steps of the material price management method according to any one of the above.
The invention provides a material price management method, a device, equipment, a storage medium and a computer program, wherein the method acquires the latest purchase price of raw materials from a cost management system through the price acquisition time of the raw materials based on a linkage rule; when the trigger linkage is determined based on the linkage rule price difference and the latest purchase price of the raw materials, acquiring information of target materials corresponding to the raw materials from a bill of material management system, wherein the information of the target materials comprises the unit consumption of the raw materials of the target materials; acquiring the current selling price of the target material from a material price management system; according to the latest purchase price, the unit consumption of raw materials and the current sale price, the adjusted price of the target material is determined, the cost management system, the bill of material management system and the material management system are subjected to linkage processing, so that when the price of the raw materials in the cost management system changes, the adjusted price of the material can be automatically determined through the bill of material management system and the material price management system under the action of linkage, the complex operation of manually exporting a plurality of excel files for data processing is avoided, meanwhile, the timeliness of data processing can be guaranteed through the automatic processing of the system, and the price management efficiency is effectively improved.
Drawings
In order to more clearly illustrate the technical solutions of the present invention or the prior art, the drawings needed for the description of the embodiments or the prior art will be briefly described below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and those skilled in the art can also obtain other drawings according to the drawings without creative efforts.
FIG. 1 is a flow chart of a material price management method according to an embodiment of the present invention;
FIG. 2 is a second schematic flow chart of a material price management method according to an embodiment of the present invention;
FIG. 3 is a schematic structural diagram of a material price management system provided by an embodiment of the present invention;
fig. 4 is a schematic structural diagram of an electronic device according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention clearer, the technical solutions of the present invention will be clearly and completely described below with reference to the accompanying drawings, and it is obvious that the described embodiments are some, but not all embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
The material price management method, apparatus, device, storage medium, and computer program of the present invention are described below with reference to fig. 1 to 4.
Fig. 1 is a schematic flow chart of a material price management method according to an embodiment of the present invention.
As shown in fig. 1, the material price management method provided by the present invention includes the following steps, the execution subject is a business center system, that is, the system of the present application, and the data analysis processing is performed on the data from different systems through the system of the present application:
101. and acquiring the latest purchase price of the current raw material from the cost management system based on the price acquisition time of the raw material in the linkage rule.
The latest purchase price of the raw material refers to the purchase price of the raw material purchased recently, and can be obtained directly from an sap price table in a cost management System, wherein the sap is short for System Applications and Products of enterprise management series software, and the cost management System comprises the cost purchase price of all the raw materials.
The price acquisition time refers to a corresponding time period, and in order to ensure the timely adjustment of the price, a preset time interval for acquiring the latest purchase price of the raw materials can be determined; according to a preset time interval, the latest purchase price of raw materials is obtained from the cost management system, and then whether linkage is triggered is judged in time, for example, monthly data of the number 1 in the linkage rule, monthly data of the number 15 in the linkage rule, and quarterly data of the number 1 in each quarter in the linkage rule are obtained, so that the sales price is timely adjusted according to the linkage rule. That is, every certain time interval, whether the calculation is changed to '0' in the bill of materials management system is determined, that is, every certain time interval, the inquiry calculation of the linkage rule is performed once to ensure the timely adjustment of the price of the materials.
And in practical cases, the raw materials include independent raw materials and/or combined raw materials; if the current raw material is an independent raw material, the calculation process is directly calculated according to the flow. If the current raw material is a combined raw material, obtaining the latest purchase price of the unit raw material, and further comprising the following steps: determining the ratio of each component of the combined raw material and the individual price of each component, wherein the ratio of each component of the combined raw material is obtained from a material management inventory system, and the individual price of each component is obtained from a cost management system; for example, brass, the composition ratio of copper to zinc, the price of copper alone, and the price of zinc alone need to be determined. According to the component proportion and the individual price of each component, the latest purchase price of the combined raw material is obtained, and the price of the brass can be determined as follows: copper price 0.59+ zinc price 0.41 brass price.
The linkage rule is established for determining the raw materials, the price acquisition time of the raw materials, the linkage rule price difference of the raw materials and the mutual linkage relation between the target materials corresponding to the raw materials. That is to say, the linkage rule refers to that the purchase price of the raw material in the cost management system is obtained within a certain time interval rule, when the purchase price of the raw material fluctuates, the target material corresponding to the raw material is automatically obtained through the bill of material management system, then the current sale price of the target material is obtained from the corresponding material price management system, and the calculation of the adjusted price can be automatically completed by using the latest purchase price of the raw material, the raw material unit consumption of the target material and the current sale price.
102. And when the trigger linkage is determined based on the linkage rule price difference and the latest purchase price of the raw materials, acquiring target materials corresponding to the current raw materials from the bill of material management system, wherein the target materials comprise the unit consumption of the raw materials of the target materials.
After the latest purchase price of the current raw material is obtained, judging whether linkage is triggered according to the linkage rule price difference of the raw material, wherein the specific judgment mode is that the latest purchase price difference of the current raw material is determined from a cost management system, and the latest purchase price difference is the difference value between the latest purchase price and the historical purchase price; and triggering linkage if the latest purchase price difference is greater than or equal to the linkage rule price difference. For example, if the current time is 8 month 1, the reference for determining the latest purchase price difference is to calculate the latest raw material purchase price from 8 month 1, but the acquisition of the raw material purchase price cannot be started from 7 month 20, and the raw material purchase price can be guaranteed to be the latest purchase price only if the acquisition of the raw material purchase price is performed at the current time. Namely, the latest purchase price difference of the current raw materials is larger than or equal to the price difference of the linkage rule, and the linkage is triggered only when the calculation time is within the set time, so that the material price corresponding to the raw materials at the moment is adjusted. Namely, whether linkage is triggered is determined according to the fluctuation range of the latest purchase price of the raw materials, and then the sale price of the materials corresponding to the raw materials is adjusted. And if the linkage is not triggered, the subsequent process is directly stopped, namely the material price is not adjusted.
When the trigger linkage is determined, the unit consumption of the raw materials corresponding to the materials is determined, and the determination mode can be that the target materials corresponding to the current raw materials are directly grabbed from a Bill of materials (bom) management system, wherein the bom management system has the mapping relation between the raw materials and the materials, so that the determination of the unit consumption of the raw materials can be quickly completed, and the determination of the unit consumption of the raw materials is also the determination of the quantity of the raw materials consumed by each Material. Generally, after a trigger linkage rule is determined, data maintenance needs to be performed by a purchase manager firstly, so that whether raw material consumption grabbing is performed is determined, the flow is directly finished when the raw material consumption grabbing is not performed, the raw material consumption grabbing is performed when the raw material grabbing is performed, whether the raw material grabbing is performed or not can be determined, when the raw material grabbing is performed on an industrial line in the rule, other raw materials can be selectively performed, that is, when one of multiple raw materials corresponding to the material needs to perform price maintenance, other raw materials need to be performed, and a final adjusted price is determined better. And the mapping relation between the raw materials and the target materials in the bill of material management system and the unit consumption of the raw materials of the target materials is updated by research and development personnel in real time.
103. And capturing the current selling price of the target material from the material price management system.
After determining the latest purchase price of the raw material and the unit consumption of the raw material of the material corresponding to the raw material, capturing the current sale price of the corresponding material in a material price management system, wherein the current sale price is the price of the corresponding material when the price of the raw material is not adjusted.
104. And determining the adjusted price of the target material according to the latest purchase price, the unit consumption of the raw materials and the current sale price of the target material.
After the latest purchase price of the raw materials, the unit consumption of the raw materials corresponding to the materials and the current sale price of the materials are obtained, the adjusted price of the target materials can be determined according to the relationship among the three. Specifically, unit conversion is carried out on the latest purchase price of the raw material to obtain the latest purchase price of the unit raw material; for example, the current price entered in the raw material management is divided by 1000000 if the unit is T, divided by 1000 if the unit is KG, and divided by 6.89 if the purchasing organization is bonded purchasing organization, thereby converting to the latest purchasing price per unit of raw material. The unit raw material historical purchase price of the raw material is obtained, the unit raw material historical purchase price is the purchase price closest to the purchase time of the unit raw material latest purchase price, unit conversion is also carried out on the unit raw material historical purchase price after the unit raw material historical purchase price purchased last time is obtained in the cost management system, and the unit raw material historical purchase price is converted in the same unit conversion mode.
And performing difference processing on the latest purchase price of the unit raw material and the historical purchase price of the unit raw material to obtain the price difference of the unit raw material, and determining the material price difference of the target material according to the price difference of the unit raw material and the unit consumption of the raw material. The calculation process of the material price difference is discussed in two cases, one is tax-containing, the other is tax-free, and the material price difference with tax is determined by the following method: unit raw material price difference/1.13 raw material unit consumption conditional price, wherein the conditional price is a set parameter. The determination mode of the price difference of the material without tax comprises the following steps: unit raw material price difference raw material unit consumption conditional price.
After the price difference of the materials is obtained, whether the purchase information of the historical raw materials corresponding to the target materials is consistent with the purchase information of the current raw materials is judged, namely whether the historical supplier information, the historical purchase organization information and the historical purchase type information of the historical raw materials corresponding to the target materials are consistent with the historical supplier information, the historical purchase organization information and the historical purchase type information of the current raw materials are consistent, if so, the price difference of the materials is added with the current selling price to obtain the final adjusted price of the target materials, and then the corresponding price difference of the materials can be accurately determined through respective discussion of the two conditions.
According to the material price management method provided by the invention, the latest purchase price of the raw material is obtained from the cost management system through the price obtaining time of the raw material based on the linkage rule; when the trigger linkage is determined based on the linkage rule price difference and the latest purchase price of the raw materials, acquiring information of target materials corresponding to the raw materials from a bill of material management system, wherein the information of the target materials comprises the unit consumption of the raw materials of the target materials; acquiring the current selling price of the target material from a material price management system; according to the latest purchase price, the unit consumption of raw materials and the current sale price, the adjusted price of the target material is determined, the cost management system, the bill of material management system and the material management system are subjected to linkage processing, so that when the price of the raw materials in the cost management system changes, the adjusted price of the material can be automatically determined through the bill of material management system and the material price management system under the action of linkage, the complex operation of manually exporting a plurality of excel files for data processing is avoided, meanwhile, the timeliness of data processing can be guaranteed through the automatic processing of the system, and the price management efficiency is effectively improved.
Fig. 2 is a second schematic flow chart of the material price management method according to the embodiment of the present invention.
As shown in fig. 2, the material price management method provided by the embodiment of the present invention includes the following steps:
201. and acquiring the latest purchase price of the current raw material from the cost management system based on the price acquisition time of the raw material in the linkage rule.
202. And when the trigger linkage is determined based on the linkage rule price difference and the latest purchase price of the raw materials, acquiring target materials corresponding to the current raw materials from the bill of material management system, wherein the target materials comprise the unit consumption of the raw materials of the target materials.
203. And capturing the current selling price of the target material from the material price management system.
204. And determining the adjusted price of the target material according to the latest purchase price, the unit consumption of the raw materials and the current sale price of the target material.
Regarding the steps 201-204, the detailed description has been already made in the corresponding steps 101-104, and therefore, the detailed description is not further provided in this embodiment.
205. And generating price adjustment report details of the target material, wherein the report details comprise the adjusted price of the target material and the calculation process information of the adjusted price.
After the corresponding adjusted price is obtained through accurate calculation, a price adjustment report detail of the corresponding target material needs to be generated, wherein the report detail comprises the adjusted price of the target material and the calculation process information of the adjusted price, and the report detail further comprises a material number, a raw material name, purchase information, report time and the like.
206. And rechecking the calculation process of the adjusted price according to the calculation process information.
And after the correspondingly adjusted price is obtained, the report detail transmission approval node carrying the calculation process detail is subjected to rechecking and approval, namely, the report detail transmission approval node is transmitted to a management personnel operating system to be subjected to rechecking and approval, and when the rechecking and approval is not passed, the process is directly ended.
207. And when a rechecking passing instruction is received, updating the adjusted price to an sap price table in the material price management system so that the target material is sold at the adjusted price.
After the received recheck is passed, the adjustment of the price of the material is agreed, the price of the material is updated to be the adjusted price, and the adjusted price is input into a sap price table in the material price management system, so that the target material corresponding to the raw material is sold at the adjusted price, and the benefit of the surplus income is ensured.
The invention can solve the problems of point-to-point collection of data collection of purchasing cost managers, processing of huge data volume and high-frequency data processing, realizes that a business center automatically connects with a data source system and calculates and updates an expression table, and can lead a user to process information at any time, visualize an operation interface and promote the risk management of purchasing price. According to the mapping relation between the materials and the raw materials, the linkage logic of the materials and the raw materials is established, the price of the materials can be updated timely along with the fluctuation of the market of the raw materials, a fair and fair public cooperation relation is established, a good competitive environment is established for each supplier, the supplier is encouraged to reduce the material cost and obtain the competitive advantage through process improvement and technical innovation.
Based on the same general inventive concept, the application also protects a material price management device. The following describes the material price management device provided by the present invention, and the material price management device described below and the material price management method described above can be referred to correspondingly.
Fig. 3 is a schematic structural diagram of a material price management device according to an embodiment of the present invention.
As shown in fig. 3, the material price management device provided in this embodiment includes:
the acquisition module 31 is used for acquiring the latest purchase price of the current raw material from the cost management system based on the price acquisition time of the raw material in the linkage rule;
the linkage module 32 is used for acquiring target materials corresponding to the current raw materials from the bill of material management system when the linkage is determined to trigger linkage based on the linkage rule price difference and the latest purchase price of the raw materials, wherein the target materials comprise the unit consumption of the raw materials of the target materials;
a grasping module 33 for grasping the current selling price of the target material from the material price management system;
and a determining module 34 for determining an adjusted price of the target material based on the latest purchase price, the unit consumption of the raw material, and the current selling price of the target material.
According to the material price management device provided by the invention, the latest purchase price of the raw material is obtained from the cost management system through the price obtaining time of the raw material based on the linkage rule; when the trigger linkage is determined based on the linkage rule price difference and the latest purchase price of the raw materials, acquiring information of target materials corresponding to the raw materials from a bill of material management system, wherein the information of the target materials comprises the unit consumption of the raw materials of the target materials; acquiring the current selling price of the target material from a material price management system; according to the latest purchase price, the unit consumption of raw materials and the current sale price, the adjusted price of the target material is determined, the cost management system, the bill of material management system and the material management system are subjected to linkage processing, so that when the price of the raw materials in the cost management system changes, the adjusted price of the material can be automatically determined through the bill of material management system and the material price management system under the action of linkage, the complex operation of manually exporting a plurality of excel files for data processing is avoided, meanwhile, the timeliness of data processing can be guaranteed through the automatic processing of the system, and the price management efficiency is effectively improved.
Further, the linkage rule in this embodiment is established for determining the raw material, the price acquisition time of the raw material, the linkage rule price difference of the raw material, and the mutual linkage relationship between the target materials corresponding to the raw material.
Further, the linkage module 31 in this embodiment is specifically further configured to:
determining the latest purchasing price difference of the current raw materials from the cost management system, wherein the latest purchasing price difference is the difference between the latest purchasing price and the historical purchasing price;
and if the latest purchase price difference is larger than or equal to the linkage rule price difference corresponding to the current raw material, triggering linkage.
Further, the determining module 34 in this embodiment is specifically configured to:
determining the unit raw material price difference of the latest purchase price difference;
determining the material price difference of the target material according to the unit raw material price difference and the unit consumption of the raw material;
and if the purchase information of the historical raw materials corresponding to the target material is consistent with the purchase information of the current raw materials, adding the price difference of the materials and the current selling price to determine the adjusted price of the target material, wherein the purchase information comprises supplier information, purchase organization information and purchase type information.
Further, the present raw materials in this embodiment include independent type raw materials and/or combined type raw materials;
when the current raw material is a combined raw material, the determination module 34 is specifically configured to:
determining the ratio of each component of the combined raw material and the individual price of each component;
determining the latest purchase price of the combined raw materials according to the component proportion and the individual price of each component;
and determining the unit raw material price difference of the combined raw materials according to the latest purchase price of the combined raw materials.
Further, the present embodiment further includes a rechecking module, configured to:
generating price adjustment report details of the target material, wherein the report details comprise the adjusted price of the target material and the calculation process information of the adjusted price;
rechecking the calculation process of the adjusted price according to the calculation process information;
and when a rechecking passing instruction is received, updating the adjusted price to an sap price table in the material price management system so that the target material is sold at the adjusted price.
Fig. 4 is a schematic structural diagram of an electronic device according to an embodiment of the present invention.
As shown in fig. 4, the electronic device may include: a processor (processor)410, a communication Interface 420, a memory (memory)430 and a communication bus 440, wherein the processor 410, the communication Interface 420 and the memory 430 are communicated with each other via the communication bus 440. Processor 410 may invoke logic instructions in memory 430 to perform a material price management method comprising: acquiring the latest purchase price of the current raw material from the cost management system based on the price acquisition time of the raw material in the linkage rule; when the trigger linkage is determined based on the linkage rule price difference and the latest purchase price of the raw materials, obtaining target materials corresponding to the current raw materials from a bill of materials management system, wherein the target materials comprise the unit consumption of the raw materials of the target materials; capturing the current selling price of the target material from a material price management system; and determining the adjusted price of the target material according to the latest purchase price, the unit consumption of the raw materials and the current sale price of the target material.
In addition, the logic instructions in the memory 430 may be implemented in the form of software functional units and stored in a computer readable storage medium when the software functional units are sold or used as independent products. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and other various media capable of storing program codes.
In another aspect, the present invention also provides a computer program product comprising a computer program stored on a non-transitory computer readable storage medium, the computer program comprising program instructions which, when executed by a computer, enable the computer to perform the material price management method provided by the above methods, the method comprising: acquiring the latest purchase price of the current raw material from the cost management system based on the price acquisition time of the raw material in the linkage rule; when the trigger linkage is determined based on the linkage rule price difference and the latest purchase price of the raw materials, obtaining target materials corresponding to the current raw materials from a bill of materials management system, wherein the target materials comprise the unit consumption of the raw materials of the target materials; capturing the current selling price of the target material from a material price management system; and determining the adjusted price of the target material according to the latest purchase price, the unit consumption of the raw materials and the current sale price of the target material.
In yet another aspect, the present invention also provides a non-transitory computer readable storage medium having stored thereon a computer program which, when executed by a processor, is implemented to perform the material price management method provided above, the method comprising: acquiring the latest purchase price of the current raw material from the cost management system based on the price acquisition time of the raw material in the linkage rule; when the trigger linkage is determined based on the linkage rule price difference and the latest purchase price of the raw materials, obtaining target materials corresponding to the current raw materials from a bill of materials management system, wherein the target materials comprise the unit consumption of the raw materials of the target materials; capturing the current selling price of the target material from a material price management system; and determining the adjusted price of the target material according to the latest purchase price, the unit consumption of the raw materials and the current sale price of the target material.
The above-described embodiments of the apparatus are merely illustrative, and the units described as separate parts may or may not be physically separate, and the parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the present embodiment. One of ordinary skill in the art can understand and implement it without inventive effort.
Through the above description of the embodiments, those skilled in the art will clearly understand that each embodiment can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware. With this understanding in mind, the above-described technical solutions may be embodied in the form of a software product, which can be stored in a computer-readable storage medium, such as ROM/RAM, magnetic disk, optical disk, etc., and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to execute the methods of the various embodiments or some parts of the embodiments.
Finally, it should be noted that: the above examples are only intended to illustrate the technical solution of the present invention, but not to limit it; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions of the embodiments of the present invention.
Claims (10)
1. A material price management method, comprising:
acquiring the latest purchase price of the current raw material from the cost management system based on the price acquisition time of the raw material in the linkage rule;
when the trigger linkage is determined based on the linkage rule price difference and the latest purchase price of the raw materials, obtaining target materials corresponding to the current raw materials from a bill of materials management system, wherein the target materials comprise the unit consumption of the raw materials of the target materials;
capturing the current selling price of the target material from a material price management system;
and determining the adjusted price of the target material according to the latest purchase price, the unit consumption of the raw materials and the current sale price of the target material.
2. The material price management method according to claim 1, wherein the linkage rule is established by determining a mutual linkage relationship among a raw material, a price acquisition time of the raw material, a linkage rule price difference of the raw material, and a target material corresponding to the raw material.
3. The material price management method according to claim 1, wherein before the obtaining the target material corresponding to the current raw material from the bill of material management system, the method further comprises:
determining a latest purchasing price difference of the current raw material from the cost management system, wherein the latest purchasing price difference is a difference value between the latest purchasing price and a historical purchasing price;
and if the latest purchase price difference is larger than or equal to the linkage rule price difference corresponding to the current raw material, triggering linkage.
4. The material price management method according to claim 3, wherein the determining the adjusted price of the target material based on the latest purchase price, the unit consumption of raw material, and the current selling price of the target material comprises:
determining the unit raw material price difference of the latest purchase price difference;
determining the material price difference of the target material according to the unit raw material price difference and the unit consumption of the raw material;
and if the purchase information of the historical raw materials corresponding to the target material is consistent with the purchase information of the current raw materials, adding the material price difference and the current selling price to determine the adjusted price of the target material, wherein the purchase information comprises supplier information, purchase organization information and purchase type information.
5. The material price management method according to claim 1, wherein the current raw material includes an independent type raw material and/or a combined type raw material;
when the current raw material is a combined raw material, the obtaining of the latest purchase price of the current raw material includes:
acquiring the ratio of each component of the combined raw material from a material management and clearing system, and acquiring the individual price of each component from a cost management system;
determining a latest purchase price for said combined raw material based on said ingredient proportions and said individual prices for said individual ingredients.
6. The material price management method according to claim 1, wherein after determining the adjusted price of the target material, further comprising:
generating price adjustment report details of the target material, wherein the report details comprise the adjusted price of the target material and the calculation process information of the adjusted price;
rechecking the calculation process of the adjusted price according to the calculation process information;
and when a rechecking passing instruction is received, updating the adjusted price to an sap price table in the material price management system so as to sell the target material at the adjusted price.
7. A material price management device, characterized by comprising:
the acquisition module is used for acquiring the latest purchase price of the current raw material from the cost management system based on the price acquisition time of the raw material in the linkage rule;
the linkage module is used for acquiring a target material corresponding to the current raw material from a bill of material management system when determining to trigger linkage based on the linkage rule price difference of the raw material and the latest purchase price, wherein the target material comprises the unit consumption of the raw material of the target material;
the grabbing module is used for grabbing the current selling price of the target material from a material price management system;
and the determining module is used for determining the adjusted price of the target material according to the latest purchase price, the unit consumption of the raw materials and the current sale price of the target material.
8. An electronic device comprising a memory, a processor and a computer program stored on said memory and executable on said processor, characterized in that said processor, when executing said program, carries out the steps of the material price management method according to any of claims 1 to 6.
9. A non-transitory computer readable storage medium, having a computer program stored thereon, wherein the computer program, when being executed by a processor, implements the steps of the material price management method according to any one of claims 1 to 6.
10. A computer program product comprising a computer program, characterized in that the computer program realizes the steps of the material price management method according to any of claims 1 to 6 when being executed by a processor.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110942626.4A CN113837684A (en) | 2021-08-17 | 2021-08-17 | Material price management method, device, equipment, storage medium and computer program |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110942626.4A CN113837684A (en) | 2021-08-17 | 2021-08-17 | Material price management method, device, equipment, storage medium and computer program |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113837684A true CN113837684A (en) | 2021-12-24 |
Family
ID=78960564
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110942626.4A Pending CN113837684A (en) | 2021-08-17 | 2021-08-17 | Material price management method, device, equipment, storage medium and computer program |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113837684A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115511526A (en) * | 2022-09-28 | 2022-12-23 | 惠州市海葵信息技术有限公司 | Price checking management method, system, equipment and storage medium |
| CN116385049A (en) * | 2023-06-07 | 2023-07-04 | 电能易购(北京)科技有限公司 | Intelligent software processing system for adjusting electronic commerce purchase price of industrial product |
-
2021
- 2021-08-17 CN CN202110942626.4A patent/CN113837684A/en active Pending
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115511526A (en) * | 2022-09-28 | 2022-12-23 | 惠州市海葵信息技术有限公司 | Price checking management method, system, equipment and storage medium |
| CN115511526B (en) * | 2022-09-28 | 2023-12-15 | 惠州市海葵信息技术有限公司 | Nuclear price management method, system, equipment and storage medium |
| CN116385049A (en) * | 2023-06-07 | 2023-07-04 | 电能易购(北京)科技有限公司 | Intelligent software processing system for adjusting electronic commerce purchase price of industrial product |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109784779B (en) | Financial risk prediction method, device and storage medium | |
| CN113837684A (en) | Material price management method, device, equipment, storage medium and computer program | |
| CN108230143A (en) | Data report generation method and system after a kind of loan | |
| US20200357072A1 (en) | Systems and methods for trading with market depth information | |
| KR101298177B1 (en) | Investment trading system for using user designed system trading product and method thereof | |
| CN107220893B (en) | Platform information counting method and control system thereof | |
| CN104573996A (en) | Automated quotation system for casting enterprises | |
| CN102117464B (en) | Apparatus, system and relevant method for marketing investment optimizer with dynamic hierarchies | |
| CN111145029A (en) | Futures and stock trading method, system and equipment based on big data | |
| CN114943582A (en) | Information recommendation method and system and recommendation server | |
| GB2593348A (en) | System and method for rapid evaluation of raw material price risk mitigation contracts | |
| US20180225767A1 (en) | Investment management proposal system | |
| CN113420987A (en) | Demand scheduling method, device, server and computer readable storage medium | |
| JP6391498B2 (en) | Asset management simulation system | |
| JP2002024547A (en) | Stock buying and selling timing decision supporting system | |
| CN114764714A (en) | Risk rating method and device for noble metal leasing transaction | |
| CN115221212A (en) | Fund investment data management system and method | |
| CN112950334A (en) | Comprehensive evaluation method and platform suitable for cross-border e-commerce and related equipment | |
| JPH0736976A (en) | Dealing discrimination processing system | |
| CN110827025A (en) | Asset clearing method and system | |
| CN108256719B (en) | Resource processing system and method | |
| CN109388424B (en) | Method and system for carrying out interaction requirement | |
| CN117290409B (en) | Method and device for generating rebate document, terminal equipment and storage medium | |
| CN118428912B (en) | Intelligent AI-based engineering project ledger generation method and system | |
| CN109767048A (en) | Asset grouping method and resource processing method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |