CN116071003B - Material demand plan calculation method, device, electronic equipment and storage medium - Google Patents
Material demand plan calculation method, device, electronic equipment and storage medium Download PDFInfo
- Publication number
- CN116071003B CN116071003B CN202310042304.3A CN202310042304A CN116071003B CN 116071003 B CN116071003 B CN 116071003B CN 202310042304 A CN202310042304 A CN 202310042304A CN 116071003 B CN116071003 B CN 116071003B
- Authority
- CN
- China
- Prior art keywords
- material layer
- demand
- calculating
- planned
- yield
- 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.)
- Active
Links
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
- G06Q10/0875—Itemisation or classification of parts, supplies or services, e.g. bill of materials
-
- 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/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0631—Resource planning, allocation, distributing or scheduling for enterprises or organisations
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Engineering & Computer Science (AREA)
- Economics (AREA)
- Entrepreneurship & Innovation (AREA)
- Strategic Management (AREA)
- Quality & Reliability (AREA)
- Theoretical Computer Science (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Development Economics (AREA)
- General Physics & Mathematics (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Educational Administration (AREA)
- Game Theory and Decision Science (AREA)
- General Factory Administration (AREA)
Abstract
The invention relates to the field of computers, and provides a material demand plan calculation method, a device, electronic equipment and a storage medium, wherein the method comprises the following steps: determining the required arrival date and the required quantity of the materials of the first material layer, the advance period of each material layer and the finished product information in a bill of materials required; calculating a required delivery date for each material layer based on the required arrival date of the first material layer and the lead time of each material layer; calculating the planned number of each material layer based on the material demand number of the first material layer and the finished product information of each material layer; the material demand schedule for each material layer is calculated based on the delivery date and the number of schedules required for each material layer. The material demand plan calculation method provided by the invention can calculate based on the structure of the latest material list no matter what kind of change happens to the structure of the material list, and can accurately calculate the material demand plan without missing or repeated plan.
Description
Technical Field
The present invention relates to the field of computers, and in particular, to a method and apparatus for calculating a material demand plan, an electronic device, and a storage medium.
Background
Most of nonstandard industries face the situations of short project exchange period, more changes and difficult process management at present. In addition, the whole product life cycle is accompanied by the changing process, and the changes can occur at any time from design, planning, purchasing, manufacturing and even final warehousing, so that the situation of missing the plan, repeated downloading and the like often occurs, and the management difficulty of the whole project cycle is further increased. It is difficult for a common plan management method to support a changing scene which is getting worse. However, the conventional Bill of materials (BOM) demand plan is calculated based on a Bill of materials (Bill of materials) structure and a date of delivery, and is difficult in the case that a partial plan has been performed.
Disclosure of Invention
The invention provides a material demand plan calculation method, a material demand plan calculation device, electronic equipment and a storage medium, and aims to accurately calculate a material demand plan.
In a first aspect, the present invention provides a material demand plan calculation method, including:
determining the required arrival date and the required quantity of the materials of the first material layer, the advance period of each material layer and the finished product information in a bill of materials required;
Calculating a required delivery date for each material layer based on the required arrival date of the first material layer and the lead time of each material layer;
calculating the planned quantity of each material layer based on the material demand quantity of the first material layer and the finished product information of each material layer;
the material demand schedule for each material layer is calculated based on the delivery date and the number of schedules required for each material layer.
In one embodiment, the calculating the required delivery date for each material layer based on the required arrival date of the first material layer and the lead time of each material layer includes:
determining a first requested arrival date for the first material layer as a first delivery date for the first material layer;
and calculating the required delivery date of the material layers after the first material layer based on the first delivery date and the lead period of each material layer.
The calculating the required delivery date of the material layers after the first material layer based on the first delivery date and the advance period of each material layer comprises the following steps:
calculating a second required arrival date based on the first delivery date and the first lead time of the first material layer, and determining the second required arrival date as a second delivery date of a second material layer after the first material layer;
Calculating a third required arrival date based on the second delivery date and the second lead time of the second material layer, and determining the third required arrival date as a third delivery date of a third material layer after the second material layer;
and calculating the required delivery date of the last material layer in the bill of materials based on the third delivery date and the third lead time of the third material layer and the lead time of the material layers after the third material layer.
The calculating the planned number of each material layer based on the material demand number of the first material layer and the finished product information of each material layer comprises the following steps:
calculating a first expected demand quantity of the first material layer based on the first material demand quantity, the first material pushed quantity and the first used inventory quantity of the first material layer;
calculating a first planned number of the first material layers based on the first predicted required number of the first material layers, a first planned usage inventory and a first yield;
and calculating the planned number of the material layers after the first material layer based on the first material demand number of the first material layer and the yield of each material layer.
The calculating the planned number of the material layers after the first material layer based on the material demand number of the first material layer and the yield of each material layer includes:
calculating a second material demand quantity of a second material layer after the first material layer based on the first material demand quantity, the first used inventory quantity, the first planned use inventory quantity and the first yield of the first material layer;
calculating a second planned quantity of the second material layer based on the second material demand quantity, the second material pushed quantity, the second used inventory quantity, the second planned used inventory quantity and the second yield of the second material layer;
calculating a third material demand quantity of a third material layer after the second material layer based on the second material demand quantity of the second material layer, a second used inventory quantity, a second planned use inventory quantity, and a second yield;
calculating a third planned quantity of the third material layer based on the third material demand quantity, the third material pushed quantity, the third used inventory quantity, the third planned used inventory quantity and the third yield of the third material layer;
and calculating the planned quantity of the last material layer in the bill of materials based on the third material demand quantity, the third used inventory quantity, the third planned used inventory quantity and the third yield of the material layers after the third material layer, and the pushed quantity, the used inventory quantity, the planned used inventory quantity and the yield of the material layers after the third material layer.
The calculation formula for calculating the material demand quantity of the second material layer after the first material layer based on the material demand quantity, the used stock quantity, the planned use stock quantity and the yield of the first material layer is specifically as follows:
；
wherein, the liquid crystal display device comprises a liquid crystal display device,for the material demand quantity of the second material layer, < > for>For the material demand quantity of the first material layer,/->For the used inventory of the first material layer +.>Stock quantity for the planned use of the first material layer, +>For the yield of the first material layer, < > a->Is a preset proportion.
The calculation formula of the advance period of each material layer is as follows:
；
wherein, the liquid crystal display device comprises a liquid crystal display device,for the advance period of each material layer +.>For a preset fixed time for each material layer, < > for each material layer>For the planned purchase number of each material layer, < > for each material layer>For the planned production number of each material layer, < > for each material layer>For a single piece of time in each material layer.
In a second aspect, the present invention provides a material demand plan computing system comprising:
the determining module is used for determining the required arrival date and the required quantity of the materials of the first material layer, the advance period of each material layer and the finished product information in a bill of materials of the required finished product;
the first calculation module is used for calculating the delivery date required by each material layer based on the required arrival date of the first material layer and the earlier date of each material layer;
The second calculation module is used for calculating the planned quantity of each material layer based on the material demand quantity of the first material layer and the finished product information of each material layer;
and the third calculation module is used for calculating the material demand schedule of each material layer based on the delivery date and the schedule number required by each material layer.
In a third aspect, the present invention also provides an electronic device, including a memory, a processor, and a computer program stored on the memory and executable on the processor, the processor implementing the material demand plan calculation method of the first aspect when executing the program.
In a fourth aspect, the present invention also provides a non-transitory computer readable storage medium comprising a computer program which, when executed by the processor, implements the material demand plan calculation method of the first aspect.
In a fifth aspect, the present invention also provides a computer program product comprising a computer program which, when executed by the processor, implements the material demand plan calculation method of the first aspect.
According to the material demand plan calculation method, the device, the electronic equipment and the storage medium, the required arrival date and the material demand quantity of the first material layer, the advance period of each material layer and the finished product information are determined in the bill of materials for demand materials; calculating a required delivery date for each material layer based on the required arrival date of the first material layer and the lead time of each material layer; calculating the planned number of each material layer based on the material demand number of the first material layer and the finished product information of each material layer; the material demand schedule for each material layer is calculated based on the delivery date and the number of schedules required for each material layer.
In the process of calculating the material demand plan, the material demand plan of each material layer is calculated according to the required arrival date and the material demand quantity of the first material layer in the bill of materials and the advance period and the finished product information of each material layer, so that no matter what change happens to the structure of the bill of materials, the calculation can be performed based on the structure of the latest bill of materials when the material demand plan is executed, missing or repeated planning cannot occur, and the material demand plan is accurately calculated.
Drawings
In order to more clearly illustrate the technical solutions of the present invention, the following description will be given with a brief introduction to the drawings used in the embodiments or the description of the prior art, it being obvious that the drawings in the following description are some embodiments of the present invention, and that other drawings can be obtained from these drawings without the inventive effort of a person skilled in the art.
FIG. 1 is a schematic flow chart of a material demand plan calculation method provided by the invention;
FIG. 2 is a schematic diagram of a material demand plan computing system provided by the present invention;
fig. 3 is a schematic structural diagram of an electronic device provided by the present invention.
Detailed Description
For the purpose of making the objects, technical solutions and advantages of the present invention more apparent, the technical solutions of the present invention will be clearly and completely described below with reference to the accompanying drawings, and it is apparent that the described embodiments are some embodiments of the present invention, not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
The embodiments of the present invention provide embodiments of a material demand plan calculation method, it should be noted that although a logical order is shown in the flowchart, the steps shown or described may be accomplished in an order different from that shown or described herein under certain data.
Referring to fig. 1, fig. 1 is a flow chart of a material demand plan calculation method provided by the present invention. The material demand plan calculation method provided by the embodiment of the invention comprises the following steps:
step 101, determining the required arrival date and the required quantity of the materials of a first material layer, the advance period and the finished product information of each material layer in a bill of materials required;
step 102, calculating the required delivery date of each material layer based on the required arrival date of the first material layer and the earlier date of each material layer;
Step 103, calculating the planned number of each material layer based on the material demand number of the first material layer and the finished product information of each material layer;
step 104, calculating the material demand plan of each material layer based on the required delivery date and the planned quantity of each material layer.
The embodiment of the invention takes the demand computing system as an execution subject as an example. It should be noted that the calculation of the material demand plan (MaterialRequirement Planning, MRP) can be analyzed in the following steps: 1. and expanding a bill of materials BOM of the required finished product to obtain the material requirement of the unit finished product. The required finished product mainly comes from a work order of an MPS calculation result, a production task and an undegraded task; 2. expanding a process route of a required finished product to obtain the operation requirement of a unit finished product; 3. expanding the resource requirement of the required finished product to obtain the resource requirement of the unit finished product; 4. the quantity and time of the required finished products are multiplied by BOM cross products of the expanded bill of materials, and actual material requirements, operation requirements and resource requirements after expansion are obtained; 5. according to the priority order: "work order of undegraded task, production task, MPS calculation result", calculate "start time", "finish time" of the job, and demand time of the corresponding resource, and decompose job demand and resource demand to each working day according to the time proportion; 6. when calculating the "start time" and "finish time" of the operation, the system judges whether to consider the "saturation day minimum load rate" of the work center to calculate the limited capacity scheduling according to whether the "production scheduling constraint" parameter in the [ system parameter table ] is 1, if the parameter is 0, the system schedules according to the infinite production capacity of the enterprise; 7. the process balance of the part is calculated according to the low-level code. Generating from the parts list and the outsource parts list; 8. searching for purchased suppliers, calculating ordering dates and ordering batches. 9. The date of start of the work from the work piece is calculated.
In order to calculate the material demand plan MRP more accurately, the calculation process of the material demand plan MRP is as follows: calculation of lead time and calculation of the number of plans.
Specifically, the demand computing system analyzes a bill of materials BOM of the demand materials, and determines a required arrival date and a required quantity of the materials of the first material layer, and an advance period and a finished product information of each material layer in the bill of materials BOM of the demand materials, wherein the first material layer is a first material layer in the bill of materials BOM, and each material layer comprises the first material layer and other remaining material layers behind the first material layer.
It can be understood that the demand computing system analyzes the bill of materials BOM of the demand materials, and determines the required arrival date and the demand quantity of the materials of the first layer, and the advance period and the finished product information of each material layer in the bill of materials BOM.
Further, the demand computing system computes a delivery date required by each material layer according to the demand arrival date of the first material layer and the lead time of each material layer. Meanwhile, the demand computing system computes the planned quantity of each material layer according to the material demand quantity of the first material layer and the finished product information of each material layer.
Finally, the demand computing system computes a material demand schedule for each material layer based on the delivery date and the number of schedules required for each material layer. It will be appreciated that the demand computing system obtains the assembly time, the assembly lead time, the procurement period, the price-in-hand, the production period, and the production schedule for each material layer based on the delivery date and the schedule quantity required for each material layer.
According to the material demand plan calculation method provided by the embodiment of the invention, the required arrival date and the material demand quantity of the first material layer, the advance period of each material layer and the finished product information are determined in a material list of demand materials; calculating a required delivery date for each material layer based on the required arrival date of the first material layer and the lead time of each material layer; calculating the planned number of each material layer based on the material demand number of the first material layer and the finished product information of each material layer; the material demand schedule for each material layer is calculated based on the delivery date and the number of schedules required for each material layer.
In the process of calculating the material demand plan, the material demand plan of each material layer is calculated according to the required arrival date and the material demand quantity of the first material layer in the bill of materials and the advance period and the finished product information of each material layer, so that no matter what change happens to the structure of the bill of materials, the calculation can be performed based on the structure of the latest bill of materials when the material demand plan is executed, missing or repeated planning cannot occur, and the material demand plan is accurately calculated.
Further, the calculating a delivery date required by each material layer based on the required arrival date of the first material layer and the lead time of each material layer in step 102 includes:
determining a first requested arrival date for the first material layer as a first delivery date for the first material layer;
and calculating the required delivery date of the material layers after the first material layer based on the first delivery date and the lead period of each material layer.
Specifically, the demand computing system expands the bill of materials BOM, and determines a first demand arrival date of a first material layer in the bill of materials BOM as a first delivery date of the first material layer. Further, the demand computing system needs to determine a first lead period for the first material layer.
It should be noted that, the calculation formula of the advance period of each material layer is as follows:
；
wherein, the liquid crystal display device comprises a liquid crystal display device,for the advance period of each material layer +.>For a preset fixed time for each material layer, < > for each material layer>For the planned purchase number of each material layer, < > for each material layer>For the planned production number of each material layer, < > for each material layer>For each materialSingle piece time in the layer.
Therefore, the demand computing system determines the preset fixed time, the planned purchasing number, the planned production number and the single time of the first material layer, and calculates the first advance period of the first material layer according to the calculation formula of the advance period. Further, the demand computing system computes a date of the next level by the first delivery date and the first lead time of the first material layer. In one embodiment, the next level of date = first delivery date-first lead.
Further, the demand computing system determines a date of the next tier as a second demand arrival date for a second material layer subsequent to the first material layer. And sequentially cycling the steps until the delivery date required by the last material layer in the bill of materials BOM is obtained.
In the material demand plan calculation process, the material demand plan of each material layer is calculated according to the required arrival date of the first material layer in the bill of materials and the advance period of each material layer, so that no matter what change occurs in the bill of materials structure, the calculation is performed based on the structure of the latest bill of materials when the material demand plan is executed, no missing or repeated plan occurs, and the material demand plan is accurately calculated.
Further, calculating a required delivery date for a material layer following the first material layer based on the first delivery date and the lead time of each material layer, comprising:
calculating a second required arrival date based on the first delivery date and the first lead time of the first material layer, and determining the second required arrival date as a second delivery date of a second material layer after the first material layer;
Calculating a third required arrival date based on the second delivery date and the second lead time of the second material layer, and determining the third required arrival date as a third delivery date of a third material layer after the second material layer;
and calculating the required delivery date of the last material layer in the bill of materials based on the third delivery date and the third lead time of the third material layer and the lead time of the material layers after the third material layer.
Specifically, the demand computing system computes a second requested arrival date based on the first delivery date and the first lead time, in one embodiment, the second requested arrival date = first delivery date-first lead time. Meanwhile, the demand computing system determines a second demand arrival date as a second delivery date of a second material layer after the first material layer, wherein the first lead period is calculated according to a calculation formula of the lead period.
Further, for a third material layer following the second material layer: the demand computing system computes a third demand arrival date based on the second delivery date and the second lead time for the second physical layer, in one embodiment, the third demand arrival date = second delivery date-second lead time. Meanwhile, the demand computing system determines a third demand arrival date as a third delivery date of the third material layer, wherein the second lead time is calculated according to a calculation formula of the lead time.
Further, for a fourth material layer following the third material layer: the demand computing system computes a fourth demand arrival date based on the third delivery date and the third lead time for the third material layer, in one embodiment, fourth demand arrival date = third delivery date-third lead time. Meanwhile, the demand computing system determines a fourth demand arrival date as a fourth delivery date of the fourth material layer, wherein the third lead period is calculated according to a calculation formula of the lead period.
And sequentially cycling until the delivery date required by the last material layer in the bill of materials is calculated.
In the material demand plan calculation process, the material demand plan of each material layer is calculated according to the required arrival date of the first material layer in the bill of materials and the advance period of each material layer, so that no matter what change occurs in the bill of materials structure, the calculation is performed based on the structure of the latest bill of materials when the material demand plan is executed, no missing or repeated plan occurs, and the material demand plan is accurately calculated.
Further, the calculating the planned number of each material layer based on the material demand number of the first material layer and the product information of each material layer in step 103 includes:
Calculating a first expected demand quantity of the first material layer based on the first material demand quantity, the first material pushed quantity and the first used inventory quantity of the first material layer;
calculating a first planned number of the first material layers based on the first predicted required number of the first material layers, a first planned usage inventory and a first yield;
and calculating the planned number of the material layers after the first material layer based on the first material demand number of the first material layer and the yield of each material layer.
Specifically, the demand computing system expands the bill of material BOM, and for a first material layer of the bill of material BOM, determines a number of demands in the project as a first material demand number of the first material layer. Further, the demand computing system computes a first estimated demand quantity of the first material layer according to the first material demand quantity, the first pushed material quantity, and the first used inventory quantity of the first material layer, and in one embodiment, the first estimated demand quantity=the first material demand quantity-the first pushed material quantity-the first used inventory quantity.
Further, the demand computing system computes a first planned number of first-tier material layers according to the first predicted demand number, the first planned usage inventory number, and the first yield of the first-tier material layers, and in one embodiment, the first planned number= (first predicted demand number-first planned usage inventory number)/first yield. The first planned usage inventory amount is the minimum value of the first expected demand amount and the first current inventory amount, and the first current inventory amount needs to be subtracted from the first safe inventory amount when the safe inventory amount is considered.
Further, the demand computing system computes the planned number of the material layers behind the first material layer according to the first material demand number of the first material layer and the yield of each material layer.
In the material demand plan calculation process, the material demand plan of each material layer is calculated according to the material demand quantity of the first material layer in the bill of materials and the finished product information of each material layer, so that no matter what change happens to the structure of the bill of materials, the calculation is performed based on the structure of the latest bill of materials when the material demand plan is executed, missing or repeated plans cannot occur, and the material demand plan is accurately calculated.
Further, calculating the planned number of material layers after the first material layer based on the material demand number of the first material layer and the yield of each material layer includes:
calculating a second material demand quantity of a second material layer after the first material layer based on the first material demand quantity, the first used inventory quantity, the first planned use inventory quantity and the first yield of the first material layer;
calculating a second planned quantity of the second material layer based on the second material demand quantity, the second material pushed quantity, the second used inventory quantity, the second planned used inventory quantity and the second yield of the second material layer;
Calculating a third material demand quantity of a third material layer after the second material layer based on the second material demand quantity of the second material layer, a second used inventory quantity, a second planned use inventory quantity, and a second yield;
calculating a third planned quantity of the third material layer based on the third material demand quantity, the third material pushed quantity, the third used inventory quantity, the third planned used inventory quantity and the third yield of the third material layer;
and calculating the planned quantity of the last material layer in the bill of materials based on the third material demand quantity, the third used inventory quantity, the third planned used inventory quantity and the third yield of the material layers after the third material layer, and the pushed quantity, the used inventory quantity, the planned used inventory quantity and the yield of the material layers after the third material layer.
Specifically, for the non-first material layer in the bill of materials BOM, the planned number needs to be calculated according to the material demand number of the last material layer.
It should be noted that, according to the material demand quantity of the first material layer, the used stock quantity, the planned use stock quantity and the yield, the calculation formula for calculating the material demand quantity of the second material layer is specifically as follows:
；
Wherein, the liquid crystal display device comprises a liquid crystal display device,for the material requirement of the second material layer, +.>For the material demand quantity of the first material layer, < >>Used stock quantity for the first material layer,/->Stock quantity for planning use of the first material layer,/->For the yield of the first material layer +.>The ratio is preset and is set according to actual conditions.
It is thus also understood that, for the non-first material layer: the material demand quantity of each material layer = { (material demand quantity of last material layer-used stock quantity of last material layer-planned use stock quantity of last material layer)/yield rate of last material layer }. Preset ratio.
Thus, for the second material layer following the first material layer: the demand computing system computes a second material demand quantity of the second material layer according to a first material demand quantity, a first used stock quantity, a first planned use stock quantity and a first finished product rate of the first material layer and by combining the computing formulas of the material demand quantity.
Further, the demand computing system computes a second planned quantity of the second material layer according to the second material demand quantity, the second material pushed quantity, the second used inventory quantity, the second planned used inventory quantity and the second yield of the second material layer.
In one embodiment, the second plan amount= (second amount of data demand-second amount of data pushed-second amount of used inventory-second amount of plan used inventory)/second yield.
For the third material layer following the first material layer: the demand computing system computes a third material demand quantity of the third material layer according to the second material demand quantity of the second material layer, the second used stock quantity, the second planned use stock quantity and the second yield by combining the computing formulas of the material demand quantity.
Further, the demand computing system computes a third planned quantity of the third material layer according to the third material demand quantity, the third material pushed quantity, the third used inventory quantity, the third planned used inventory quantity and the third yield of the third material layer.
In one embodiment, the third schedule number= (third material demand number-third material pushed amount-third used inventory amount-third schedule used inventory amount)/third yield.
For the fourth material layer following the first material layer: the demand computing system computes a fourth material demand quantity of the fourth material layer according to a third material demand quantity of the third material layer, a third used stock quantity, a third planned used stock quantity and a third yield by combining the computing formulas of the material demand quantity.
Further, the demand computing system computes a fourth planned quantity of the fourth material layer according to the fourth material demand quantity, the fourth material pushed quantity, the fourth used inventory quantity, the fourth planned used inventory quantity and the fourth yield of the fourth material layer.
In one embodiment, the fourth plan amount= (fourth material demand amount-fourth material pushed amount-fourth used inventory amount-fourth plan used inventory amount)/fourth yield.
And sequentially circulating until the planned number of the last material layer in the bill of materials is calculated.
In the material demand plan calculation process, the material demand plan of each material layer is calculated according to the material demand quantity of the first material layer in the bill of materials and the finished product information of each material layer, so that no matter what change happens to the structure of the bill of materials, the calculation is performed based on the structure of the latest bill of materials when the material demand plan is executed, missing or repeated plans cannot occur, and the material demand plan is accurately calculated.
Further, the material demand plan calculation system provided by the invention and the material demand plan calculation method provided by the invention are correspondingly referred to each other.
FIG. 2 is a schematic diagram of a material demand plan computing system according to the present invention, wherein the material demand plan computing system comprises:
a determining module 201, configured to determine a required arrival date and a required quantity of materials for a first material layer, and an advance period and finished product information of each material layer in a bill of materials for which a finished product is required;
a first calculation module 202, configured to calculate a delivery date required for each material layer based on the required arrival date of the first material layer and the lead time of each material layer;
the second calculating module 203 is configured to calculate a planned number of each material layer based on the material demand number of the first material layer and the product information of each material layer;
the third calculation module 204 is configured to calculate a material demand schedule for each material layer based on the delivery date and the number of schedules required for each material layer.
Further, the first computing module 202 is further configured to:
determining a first requested arrival date for the first material layer as a first delivery date for the first material layer;
and calculating the required delivery date of the material layers after the first material layer based on the first delivery date and the lead period of each material layer.
Further, the first computing module 202 is further configured to:
calculating a second required arrival date based on the first delivery date and the first lead time of the first material layer, and determining the second required arrival date as a second delivery date of a second material layer after the first material layer;
calculating a third required arrival date based on the second delivery date and the second lead time of the second material layer, and determining the third required arrival date as a third delivery date of a third material layer after the second material layer;
and calculating the required delivery date of the last material layer in the bill of materials based on the third delivery date and the third lead time of the third material layer and the lead time of the material layers after the third material layer.
Further, the second computing module 203 is further configured to:
calculating a first expected demand quantity of the first material layer based on the first material demand quantity, the first material pushed quantity and the first used inventory quantity of the first material layer;
calculating a first planned number of the first material layers based on the first predicted required number of the first material layers, a first planned usage inventory and a first yield;
And calculating the planned number of the material layers after the first material layer based on the first material demand number of the first material layer and the yield of each material layer.
Further, the second computing module 203 is further configured to:
calculating a second material demand quantity of a second material layer after the first material layer based on the first material demand quantity, the first used inventory quantity, the first planned use inventory quantity and the first yield of the first material layer;
calculating a second planned quantity of the second material layer based on the second material demand quantity, the second material pushed quantity, the second used inventory quantity, the second planned used inventory quantity and the second yield of the second material layer;
calculating a third material demand quantity of a third material layer after the second material layer based on the second material demand quantity of the second material layer, a second used inventory quantity, a second planned use inventory quantity, and a second yield;
calculating a third planned quantity of the third material layer based on the third material demand quantity, the third material pushed quantity, the third used inventory quantity, the third planned used inventory quantity and the third yield of the third material layer;
And calculating the planned quantity of the last material layer in the bill of materials based on the third material demand quantity, the third used inventory quantity, the third planned used inventory quantity and the third yield of the material layers after the third material layer, and the pushed quantity, the used inventory quantity, the planned used inventory quantity and the yield of the material layers after the third material layer.
The specific embodiments of the material demand plan computing system provided by the present invention are substantially the same as the embodiments of the material demand plan computing method described above, and will not be described herein.
Fig. 3 illustrates a physical schematic diagram of an electronic device, as shown in fig. 3, the electronic device may include: processor 310, communication interface (Communications Interface) 320, memory 330 and communication bus 340, wherein processor 310, communication interface 320, memory 330 accomplish communication with each other through communication bus 340. The processor 310 may invoke logic instructions in the memory 330 to perform a material demand plan calculation method comprising:
determining the required arrival date and the required quantity of the materials of the first material layer, the advance period of each material layer and the finished product information in a bill of materials required;
Calculating a required delivery date for each material layer based on the required arrival date of the first material layer and the lead time of each material layer;
calculating the planned quantity of each material layer based on the material demand quantity of the first material layer and the finished product information of each material layer;
the material demand schedule for each material layer is calculated based on the delivery date and the number of schedules required for each material layer.
Further, the logic instructions in the memory 330 described above may be implemented in the form of software functional units and may be stored in a computer-readable storage medium when sold or used as a stand-alone product. Based on this understanding, the technical solution of the present invention may be embodied essentially or in a part contributing to the prior art or in a part of the technical solution, in the form of a software product stored in a storage medium, comprising several instructions for causing a computer device (which may be a personal computer, a server, a network device, etc.) to perform 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, random Access Memory), a magnetic disk, or an optical disk, or 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 method of calculating a demand plan for a good provided by the above methods, the method comprising:
determining the required arrival date and the required quantity of the materials of the first material layer, the advance period of each material layer and the finished product information in a bill of materials required;
calculating a required delivery date for each material layer based on the required arrival date of the first material layer and the lead time of each material layer;
calculating the planned quantity of each material layer based on the material demand quantity of the first material layer and the finished product information of each material layer;
the material demand schedule for each material layer is calculated based on the delivery date and the number of schedules required for each material layer.
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 above-provided material demand plan calculation methods, the method comprising:
Determining the required arrival date and the required quantity of the materials of the first material layer, the advance period of each material layer and the finished product information in a bill of materials required;
calculating a required delivery date for each material layer based on the required arrival date of the first material layer and the lead time of each material layer;
calculating the planned quantity of each material layer based on the material demand quantity of the first material layer and the finished product information of each material layer;
the material demand schedule for each material layer is calculated based on the delivery date and the number of schedules required for each material layer.
The apparatus embodiments described above are merely illustrative, wherein the elements illustrated as separate elements may or may not be physically separate, and the elements shown as elements may or may not be physical elements, may be located in one place, or may be distributed over a plurality of network elements. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of this embodiment. Those of ordinary skill in the art will understand and implement the present invention without undue burden.
From the above description of the embodiments, it will be apparent to those skilled in the art that the embodiments may be implemented by means of software plus necessary general hardware platforms, or of course may be implemented by means of hardware. Based on this understanding, the foregoing technical solution may be embodied essentially or in a part contributing to the prior art in the form of a software product, which may be stored in a computer readable storage medium, such as ROM/RAM, a magnetic disk, an optical disk, etc., including several instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to execute the method described in the respective embodiments or some parts of the embodiments.
Finally, it should be noted that: the above embodiments are only for illustrating the technical solution of the present invention, and are not limiting; although the 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 scheme described in the foregoing embodiments can be modified or some technical features thereof can be replaced by equivalents; such modifications and substitutions do not depart from the spirit and scope of the technical solutions of the embodiments of the present invention.
Claims (5)
1. A material demand plan calculation method, comprising:
determining the required arrival date and the required quantity of the materials of the first material layer, the advance period of each material layer and the finished product information in a bill of materials required;
calculating a required delivery date for each material layer based on the required arrival date of the first material layer and the lead time of each material layer;
calculating the planned quantity of each material layer based on the material demand quantity of the first material layer and the finished product information of each material layer;
calculating a material demand schedule for each material layer based on the delivery date and the number of schedules required for each material layer;
wherein, based on the required arrival date of the first material layer and the lead time of each material layer, calculating the required delivery date of each material layer comprises the following steps:
determining a first requested arrival date for the first material layer as a first delivery date for the first material layer;
calculating a required delivery date for a material layer following the first material layer based on the first delivery date and an advance period of each material layer;
the calculation formula of the advance period of each material layer is as follows:
；
Wherein, the liquid crystal display device comprises a liquid crystal display device,for the advance period of each material layer +.>For a preset fixed time for each material layer, < > for each material layer>For the planned purchase number of each material layer, < > for each material layer>For the planned production number of each material layer, < > for each material layer>For a single piece of time in each material layer;
the calculating the planned number of each material layer based on the material demand number of the first material layer and the finished product information of each material layer comprises the following steps:
calculating a first expected demand quantity of the first material layer based on the first material demand quantity, the first material pushed quantity and the first used inventory quantity of the first material layer;
calculating a first planned number of the first material layers based on the first predicted required number of the first material layers, a first planned usage inventory and a first yield;
calculating the planned number of material layers after the first material layer based on the first material demand number of the first material layer and the yield of each material layer;
the calculating the planned number of the material layers after the first material layer based on the first material demand number of the first material layer and the yield of each material layer includes:
calculating a second material demand quantity of a second material layer after the first material layer based on the first material demand quantity, the first used inventory quantity, the first planned use inventory quantity and the first yield of the first material layer;
Calculating a second planned quantity of the second material layer based on the second material demand quantity, the second material pushed quantity, the second used inventory quantity, the second planned used inventory quantity and the second yield of the second material layer;
calculating a third material demand quantity of a third material layer after the second material layer based on the second material demand quantity of the second material layer, a second used inventory quantity, a second planned use inventory quantity, and a second yield;
calculating a third planned quantity of the third material layer based on the third material demand quantity, the third material pushed quantity, the third used inventory quantity, the third planned used inventory quantity and the third yield of the third material layer;
calculating the planned quantity of the last material layer in the bill of materials based on the third material demand quantity, the third used inventory quantity, the third planned used inventory quantity and the third yield of the material layers after the third material layer, and the pushed quantity, the used inventory quantity, the planned used inventory quantity and the yield of the material layers after the third material layer;
the calculation formula for calculating the material demand quantity of the second material layer after the first material layer based on the material demand quantity, the used stock quantity, the planned use stock quantity and the yield of the first material layer is specifically as follows:
；
Wherein, the liquid crystal display device comprises a liquid crystal display device,for the material demand quantity of the second material layer, < > for>For the material demand quantity of the first material layer,for the used inventory of the first material layer +.>Stock quantity for the planned use of the first material layer, +>For the yield of the first material layer, < > a->Is a preset proportion.
2. The material demand plan calculating method according to claim 1, wherein the calculating a delivery date required for a material layer after the first material layer based on the first delivery date and an advance period of each material layer includes:
calculating a second required arrival date based on the first delivery date and the first lead time of the first material layer, and determining the second required arrival date as a second delivery date of a second material layer after the first material layer;
calculating a third required arrival date based on the second delivery date and the second lead time of the second material layer, and determining the third required arrival date as a third delivery date of a third material layer after the second material layer;
and calculating the required delivery date of the last material layer in the bill of materials based on the third delivery date and the third lead time of the third material layer and the lead time of the material layers after the third material layer.
3. A material demand plan computing device, comprising:
the determining module is used for determining the required arrival date and the required quantity of the materials of the first material layer, the advance period of each material layer and the finished product information in a bill of materials of the required finished product;
the first calculation module is used for calculating the delivery date required by each material layer based on the required arrival date of the first material layer and the earlier date of each material layer;
the second calculation module is used for calculating the planned quantity of each material layer based on the material demand quantity of the first material layer and the finished product information of each material layer;
a third calculation module for calculating a material demand schedule for each material layer based on the delivery date and the schedule number required for each material layer;
wherein, based on the required arrival date of the first material layer and the lead time of each material layer, calculating the required delivery date of each material layer comprises the following steps:
determining a first requested arrival date for the first material layer as a first delivery date for the first material layer;
calculating a required delivery date for a material layer following the first material layer based on the first delivery date and an advance period of each material layer;
The calculation formula of the advance period of each material layer is as follows:
；
wherein, the liquid crystal display device comprises a liquid crystal display device,for the advance period of each material layer +.>For a preset fixed time for each material layer, < > for each material layer>For the planned purchase number of each material layer, < > for each material layer>For the planned production number of each material layer, < > for each material layer>For a single piece of time in each material layer;
the calculating the planned number of each material layer based on the material demand number of the first material layer and the finished product information of each material layer comprises the following steps:
calculating a first expected demand quantity of the first material layer based on the first material demand quantity, the first material pushed quantity and the first used inventory quantity of the first material layer;
calculating a first planned number of the first material layers based on the first predicted required number of the first material layers, a first planned usage inventory and a first yield;
calculating the planned number of material layers after the first material layer based on the first material demand number of the first material layer and the yield of each material layer;
the calculating the planned number of the material layers after the first material layer based on the first material demand number of the first material layer and the yield of each material layer includes:
Calculating a second material demand quantity of a second material layer after the first material layer based on the first material demand quantity, the first used inventory quantity, the first planned use inventory quantity and the first yield of the first material layer;
calculating a second planned quantity of the second material layer based on the second material demand quantity, the second material pushed quantity, the second used inventory quantity, the second planned used inventory quantity and the second yield of the second material layer;
calculating a third material demand quantity of a third material layer after the second material layer based on the second material demand quantity of the second material layer, a second used inventory quantity, a second planned use inventory quantity, and a second yield;
calculating a third planned quantity of the third material layer based on the third material demand quantity, the third material pushed quantity, the third used inventory quantity, the third planned used inventory quantity and the third yield of the third material layer;
calculating the planned quantity of the last material layer in the bill of materials based on the third material demand quantity, the third used inventory quantity, the third planned used inventory quantity and the third yield of the material layers after the third material layer, and the pushed quantity, the used inventory quantity, the planned used inventory quantity and the yield of the material layers after the third material layer;
The calculation formula for calculating the material demand quantity of the second material layer after the first material layer based on the material demand quantity, the used stock quantity, the planned use stock quantity and the yield of the first material layer is specifically as follows:
；
wherein, the liquid crystal display device comprises a liquid crystal display device,for the material demand quantity of the second material layer, < > for>For the material demand quantity of the first material layer,for the used inventory of the first material layer +.>To be the instituteThe planned use stock quantity of the first material layer,>for the yield of the first material layer, < > a->Is a preset proportion.
4. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the material demand plan calculation method of any one of claims 1 to 2 when executing the computer program.
5. A non-transitory computer readable storage medium comprising a computer program, characterized in that the computer program when executed by a processor implements the material demand plan calculation method of any one of claims 1 to 2.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310042304.3A CN116071003B (en) | 2023-01-28 | 2023-01-28 | Material demand plan calculation method, device, electronic equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310042304.3A CN116071003B (en) | 2023-01-28 | 2023-01-28 | Material demand plan calculation method, device, electronic equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN116071003A CN116071003A (en) | 2023-05-05 |
| CN116071003B true CN116071003B (en) | 2023-07-18 |
Family
ID=86172795
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310042304.3A Active CN116071003B (en) | 2023-01-28 | 2023-01-28 | Material demand plan calculation method, device, electronic equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116071003B (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2000132619A (en) * | 1998-10-23 | 2000-05-12 | Hitachi Ltd | Supply chain evaluation system |
| CN113283803A (en) * | 2021-06-17 | 2021-08-20 | 金蝶软件（中国）有限公司 | Material demand plan making method, related device and storage medium |
| CN115375216A (en) * | 2021-05-21 | 2022-11-22 | 华为技术有限公司 | Method and device for determining safety stock |
Family Cites Families (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8315923B2 (en) * | 2007-01-09 | 2012-11-20 | Mcphetrige David | Method of determining safety stock levels |
| CN101339635A (en) * | 2008-08-01 | 2009-01-07 | 金蝶软件（中国）有限公司 | Method, system and equipment for determining material demand plan and obtaining material low level code |
| CN101673373A (en) * | 2009-09-16 | 2010-03-17 | 金蝶软件（中国）有限公司 | Method and device for generating production order material-preparing journal entry |
| CN105389653A (en) * | 2015-10-30 | 2016-03-09 | 广东石油化工学院 | Adaptive material requirement plan (MRP) calculation method |
| CN111582650A (en) * | 2020-04-10 | 2020-08-25 | 北京天拓智领科技有限公司 | Material demand plan calculation method |
| CN111861208B (en) * | 2020-07-20 | 2024-02-20 | 精效新软新技术（北京）有限公司 | Automatic calculation method, system and medium for MRP material demand in production management |
| CN112308399A (en) * | 2020-10-29 | 2021-02-02 | 山东浪潮通软信息科技有限公司 | Material demand plan disassembling system and method based on-time delivery |
| CN112613774A (en) * | 2020-12-28 | 2021-04-06 | 浙江智昌机器人科技有限公司 | MRP algorithm based on data feedback |
| CN114596020A (en) * | 2021-10-19 | 2022-06-07 | 杭州新中大科技股份有限公司 | Project MRP design method and system for large-scale customized production |
-
2023
- 2023-01-28 CN CN202310042304.3A patent/CN116071003B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2000132619A (en) * | 1998-10-23 | 2000-05-12 | Hitachi Ltd | Supply chain evaluation system |
| CN115375216A (en) * | 2021-05-21 | 2022-11-22 | 华为技术有限公司 | Method and device for determining safety stock |
| CN113283803A (en) * | 2021-06-17 | 2021-08-20 | 金蝶软件（中国）有限公司 | Material demand plan making method, related device and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN116071003A (en) | 2023-05-05 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| EP1640834B1 (en) | Dynamic-state waiting time analysis method for complex discrete manufacturing | |
| Boute et al. | Dual sourcing and smoothing under nonstationary demand time series: Reshoring with SpeedFactories | |
| US8165904B2 (en) | Allocating inventory levels | |
| US8290607B2 (en) | Planning method and system for optimizing stock and production plan in batch process industry | |
| US20030050817A1 (en) | Capacity- driven production planning | |
| US20060089867A1 (en) | Inventory control system and method | |
| US11170327B2 (en) | Dynamic production planning system and dynamic production planning device | |
| US20220026874A1 (en) | System and method for high-mix wheels for capacity planning resource planning and material resource planning | |
| CN111507673A (en) | Method and device for managing commodity inventory | |
| EP2610696A1 (en) | Process design/production planning device | |
| CN116542508A (en) | Clothing order scheduling method, device and equipment | |
| CN112381485A (en) | Material demand plan calculation method and related equipment | |
| CN101556660A (en) | Production order arranging system and method | |
| CN116071003B (en) | Material demand plan calculation method, device, electronic equipment and storage medium | |
| JP2009157690A (en) | Manufacturing process management apparatus, manufacturing process management method, program and recording medium for the same | |
| CN115700669B (en) | Material difference list generation method, electronic equipment and computer storage medium | |
| CN107678839B (en) | Priority-based client follow-up method, system and readable storage medium | |
| JP2006085646A (en) | Prediction model selection device, prediction model selection method and program | |
| CN111639784B (en) | Inventory management method and related device | |
| JP4902616B2 (en) | Loss cost optimization system, loss cost optimization method, and loss cost optimization program | |
| JP2003263213A (en) | Production management system and production management method | |
| JP3260333B2 (en) | Production management device, production management system, production planning method, and storage medium | |
| JP2008165597A (en) | Business parameter determination system | |
| JP2020197838A (en) | Information processor, control method and program | |
| US20220004993A1 (en) | System and Method for Updating Real-Time Project Status Based on Deliverable Status |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |