CN110610337A - Method and equipment for realizing MRP function based on material double units - Google Patents
Method and equipment for realizing MRP function based on material double units Download PDFInfo
- Publication number
- CN110610337A CN110610337A CN201910854886.9A CN201910854886A CN110610337A CN 110610337 A CN110610337 A CN 110610337A CN 201910854886 A CN201910854886 A CN 201910854886A CN 110610337 A CN110610337 A CN 110610337A
- Authority
- CN
- China
- Prior art keywords
- finished products
- determining
- finished
- current
- information
- 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
- 239000000463 material Substances 0.000 title claims abstract description 70
- 238000000034 method Methods 0.000 title claims abstract description 65
- 239000000047 product Substances 0.000 claims abstract description 335
- 239000002994 raw material Substances 0.000 claims abstract description 151
- 239000011265 semifinished product Substances 0.000 claims abstract description 63
- 238000006243 chemical reaction Methods 0.000 claims abstract description 19
- 230000006870 function Effects 0.000 claims description 21
- 238000004590 computer program Methods 0.000 claims description 13
- 238000012545 processing Methods 0.000 claims description 7
- 238000004519 manufacturing process Methods 0.000 abstract description 32
- 238000010586 diagram Methods 0.000 description 19
- 238000003860 storage Methods 0.000 description 17
- 230000008569 process Effects 0.000 description 14
- 238000007726 management method Methods 0.000 description 13
- 238000005096 rolling process Methods 0.000 description 9
- 238000012384 transportation and delivery Methods 0.000 description 6
- 238000013439 planning Methods 0.000 description 5
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 238000012986 modification Methods 0.000 description 3
- 230000004048 modification Effects 0.000 description 3
- 230000002776 aggregation Effects 0.000 description 2
- 238000004220 aggregation Methods 0.000 description 2
- 238000004364 calculation method Methods 0.000 description 2
- 238000004891 communication Methods 0.000 description 2
- 238000013461 design Methods 0.000 description 2
- 230000009977 dual effect Effects 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000009826 distribution Methods 0.000 description 1
- 239000000835 fiber Substances 0.000 description 1
- 230000010365 information processing Effects 0.000 description 1
- 238000007689 inspection Methods 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 230000008520 organization Effects 0.000 description 1
- 230000002085 persistent effect Effects 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 238000000547 structure data Methods 0.000 description 1
- 230000001052 transient effect Effects 0.000 description 1
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
Landscapes
- Business, Economics & Management (AREA)
- Economics (AREA)
- Engineering & Computer Science (AREA)
- Marketing (AREA)
- Quality & Reliability (AREA)
- Finance (AREA)
- Entrepreneurship & Innovation (AREA)
- Human Resources & Organizations (AREA)
- Accounting & Taxation (AREA)
- Operations Research (AREA)
- Development Economics (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- General Factory Administration (AREA)
Abstract
The invention provides a method and equipment for realizing MRP function based on material double units, wherein the method comprises the following steps: acquiring basic data, wherein the basic data comprises product demand information, current inventory information and in-transit raw material information; determining the total number of finished products required at the required time point according to the product demand information, determining the first finished product number of the finished products which can be converted at the required time point according to the current inventory information, and determining the second finished product number of the finished products which can be converted at the required time point according to the in-transit raw material information; and determining the shortage amount of the finished products according to the total number of the finished products, the current inventory finished product amount, the first finished product amount and the second finished product amount, and determining the required raw materials according to the shortage amount of the finished products. The invention reasonably utilizes the material double units and solves the problems of inconsistent demand and production or larger error and the risk of purchasing lost materials caused by the fact that the existing MRP system cannot accurately complete the conversion relation among raw materials, semi-finished products and finished products.
Description
Technical Field
The invention relates to the technical field of production management, in particular to a method and equipment for realizing MRP function based on material double units.
Background
The material management is a general term of a series of management activities such as planning, organization, control and the like, such as purchasing, acceptance, supply, storage, distribution, reasonable use, saving, comprehensive utilization and the like of various materials required by the production and operation activities of enterprises. The material management is a cross point of each link of internal logistics of an enterprise, links important links such as purchasing and production, production and sales and the like, and is concerned with a life line of enterprise cost and profit.
MRP (Material requisition Planning) refers to a management mode of Material Planning in an industrial manufacturing enterprise, in which each article is used as a Planning object, a completion period is used as a time reference inverted plan, and the sequence of issuing Planning time of each article is distinguished according to the length of a lead period according to the relationship between the membership and the quantity of each layer of the article in a product structure. MRP is a practical technique for making a production plan of a product according to market demand prediction and a customer order, then generating a schedule plan based on the product, composing a material structure table and an inventory condition of the product, and calculating a required amount and a required time of a required material by a computer, thereby determining a processing schedule and an ordering schedule of the material.
The material management mainly adopts an MRP system to evaluate the comprehensive conditions of the production capacity and the materials, so that the purchasing demand of the materials is predicted and a purchasing plan is made. However, when the existing MRP system performs material management and forecast purchasing requirements, there is no coordination mechanism between the process procedures, and it is unable to dynamically ensure the correlation between the process procedures and accurately integrate the material information of each process procedure, so that during purchasing forecast, the problems of unbalanced yield between the process procedures, inconsistent demand and production or large error and risk of purchasing material loss may be caused by the inaccurate establishment of raw materials and the conversion relationship between the semi-finished products and finished products of each process procedure.
Disclosure of Invention
The invention provides a method and equipment for realizing an MRP function based on material double units, and aims to solve the problems that the existing MRP system cannot accurately finish raw materials, and the conversion relation between semi-finished products and finished products of each process causes the imbalance of yield among the processes, the inconsistency of demand and production or large error and the risk of purchasing lost materials.
According to a first aspect of the embodiments of the present invention, a method for implementing an MRP function based on a material double unit is provided, the method including:
acquiring basic data, wherein the basic data comprises product demand information, current inventory information and in-transit raw material information;
determining the total number of finished products required at the required time point according to the product demand information, determining the first finished product number of the finished products which can be converted at the required time point according to the current inventory information, and determining the second finished product number of the finished products which can be converted at the required time point according to the in-transit raw material information;
and determining the shortage amount of the finished products according to the total number of the finished products, the current inventory finished product amount, the first finished product amount and the second finished product amount, and determining the required raw materials according to the shortage amount of the finished products.
According to a second aspect of the embodiments of the present invention, there is provided a smart device, including:
the data summarization module is used for acquiring basic data, wherein the basic data comprises product demand information, current inventory information and in-transit raw material information;
the demand forecasting module is used for determining the total number of finished products required at the demand time point according to the product demand information, determining the first finished product number of the finished products which can be converted at the demand time point according to the current inventory information, and determining the second finished product number of the finished products which can be converted at the demand time point according to the in-transit raw material information;
and the demand determining module is used for determining the shortage amount of the finished products according to the total number of the finished products, the current stock finished product amount, the first finished product amount and the second finished product amount, and determining the required raw materials according to the shortage amount of the finished products.
Optionally, the product demand information determined by the data summarization module includes a demand time point, a demand total number of finished products, and a bill of materials of the product;
the current inventory information comprises current raw material inventory information and current semi-finished product inventory information.
Optionally, the determining, by the demand forecasting module, the first finished product quantity of the finished product that can be converted according to the current inventory information includes:
determining the number of finished products which can be converted from the raw materials in the current stock at the required time point according to the current raw material stock information and the conversion time from the raw materials to the finished products;
determining the number of finished products which can be converted into semi-finished products in the current stock at the required time point according to the current semi-finished product stock information and the conversion time from the semi-finished products to the finished products;
and determining the sum of all the determined quantities as the first finished product quantity.
Optionally, the determining, by the demand forecasting module, the number of finished products into which the raw materials in the current stock can be converted according to the current raw material stock information includes:
determining the number of finished products which can be converted from the raw materials in the current stock according to the current raw material stock information and the yield of the raw materials;
determining the number of finished products into which semi-finished products in the current inventory can be converted according to the current semi-finished product inventory information, wherein the method comprises the following steps:
and determining the number of finished products which can be converted from the semi-finished products in the current inventory according to the current semi-finished product inventory information and the yield of the semi-finished products.
Optionally, the demand forecasting module determines a second finished product quantity of finished products that can be converted at the demand time point according to the in-transit raw material information, and includes:
determining raw materials which arrive at the stock in different periods according to the in-transit raw material information;
and determining the quantity of the second finished products of the converted finished products according to the corresponding raw materials which arrive at the stock in the period of the demand time point.
Optionally, the demand forecasting module determines a second finished product quantity of the finished products that can be converted according to the raw materials that arrive in the stock within the period of the demand time point, and includes:
and determining the second finished product quantity of the finished products which can be converted according to the raw materials which reach the stock and the yield of the raw materials corresponding to the period of the demand time point.
Optionally, the demand determining module determines a shortage amount of the finished product according to the total number of the finished product, the current number of finished products in stock, the first number of finished products and the second number of finished products, and determines the required raw material according to the shortage amount of the finished product, including:
according to the formula: determining the shortage of finished products, namely the total number of the finished products, the number of finished products in current stock, the number of first finished products and the number of second finished products;
and determining the required raw materials according to the shortage of the finished product.
According to a third aspect of embodiments of the present invention, there is provided an intelligent device, including: a memory and a processor; wherein:
the memory is used for storing programs;
the processor is used for executing the program in the memory and comprises the following steps:
acquiring basic data, wherein the basic data comprises product demand information, current inventory information and in-transit raw material information;
determining the total number of finished products required at the required time point according to the product demand information, determining the first finished product number of the finished products which can be converted at the required time point according to the current inventory information, and determining the second finished product number of the finished products which can be converted at the required time point according to the in-transit raw material information;
and determining the shortage amount of the finished products according to the total number of the finished products, the current inventory finished product amount, the first finished product amount and the second finished product amount, and determining the required raw materials according to the shortage amount of the finished products.
Optionally, the product demand information determined by the processor includes a time point of demand, a total number of required finished products, and a bill of materials constituting the product;
the current inventory information comprises current raw material inventory information and current semi-finished product inventory information.
Optionally, the processor determines a first finished product quantity of finished products that can be converted according to the current inventory information, including:
determining the number of finished products which can be converted from the raw materials in the current stock at the required time point according to the current raw material stock information and the conversion time from the raw materials to the finished products;
determining the number of finished products which can be converted into semi-finished products in the current stock at the required time point according to the current semi-finished product stock information and the conversion time from the semi-finished products to the finished products;
and determining the sum of all the determined quantities as the first finished product quantity.
Optionally, the processor determines, according to the current raw material inventory information, a number of finished products into which the raw materials in the current inventory can be converted, including:
determining the number of finished products which can be converted from the raw materials in the current stock according to the current raw material stock information and the yield of the raw materials;
determining the number of finished products into which semi-finished products in the current inventory can be converted according to the current semi-finished product inventory information, wherein the method comprises the following steps:
and determining the number of finished products which can be converted from the semi-finished products in the current inventory according to the current semi-finished product inventory information and the yield of the semi-finished products.
Optionally, the processor determines a second quantity of finished goods that can be converted into finished goods at the required time point according to the in-transit raw material information, including:
determining raw materials which arrive at the stock in different periods according to the in-transit raw material information;
and determining the quantity of the second finished products of the converted finished products according to the corresponding raw materials which arrive at the stock in the period of the demand time point.
Optionally, the processor determines a second quantity of finished products that can be converted into finished products according to the corresponding raw materials arriving in stock in the period of the demand time point, including:
and determining the second finished product quantity of the finished products which can be converted according to the raw materials which reach the stock and the yield of the raw materials corresponding to the period of the demand time point.
Optionally, the processor determines a shortage of finished products according to the total number of finished products, the current number of finished products in stock, the first number of finished products and the second number of finished products, and determines the required raw materials according to the shortage of finished products, including:
according to the formula: determining the shortage of finished products, namely the total number of the finished products, the number of finished products in current stock, the number of first finished products and the number of second finished products;
and determining the required raw materials according to the shortage of the finished product.
According to a fourth aspect of the embodiments of the present invention, there is provided a chip, the chip is coupled to a memory in a device, so that the chip invokes, when running, program instructions stored in the memory, to implement the above aspects of the embodiments of the present application and any method that may be designed according to the aspects.
According to a fifth aspect of the embodiments of the present invention, there is provided a computer-readable storage medium storing program instructions which, when executed on a computer, cause the computer to perform the method of any of the possible designs to which the above aspects and aspects relate.
According to a sixth aspect of the embodiments of the present invention, there is provided a computer program product, which, when run on an electronic device, causes the electronic device to perform a method of implementing the above aspects of the embodiments of the present application and any possible design related to the aspects.
The intelligent equipment positioning method provided by the invention has the following beneficial effects:
the invention provides a method and equipment for realizing MRP function based on material double units, which reasonably use the material double units, accurately complete the proportion conversion among finished products, semi-finished products and raw materials, realize the MRP material demand plan, and solve the problems of unbalanced yield among process procedures, inconsistent demand and production or larger error and risk of purchasing idle materials caused by the fact that the existing MRP system cannot accurately complete the conversion relation among the raw materials, the semi-finished products and the finished products.
Drawings
In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings needed to be used in the description of the embodiments will be briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without creative efforts.
Fig. 1 is a frame diagram of a method for implementing an MRP function based on two units of material according to an embodiment of the present invention;
fig. 2 is a schematic diagram of a method for implementing an MRP function based on two units of material according to an embodiment of the present invention;
FIG. 3 is a schematic front-end page diagram illustrating demand aggregation of MDS requirements of a rolling operation scheme according to an embodiment of the present invention;
FIG. 4 is a front-end page diagram of a rolling execution scheme of an MRP system provided in an embodiment of the present invention;
fig. 5 is a schematic diagram of an apparatus for implementing an MRP function based on a material double unit provided in an embodiment of the present invention;
fig. 6 is a schematic structural diagram of a device for implementing an MRP function based on a material double unit provided in an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention clearer, the present invention will be described in further detail with reference to the accompanying drawings, and it is apparent that the described embodiments are only a part of the embodiments of the present invention, not all of the embodiments. 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.
For convenience of understanding, terms referred to in the embodiments of the present invention are explained below:
1) double units of materials: the material is a general term for stock and is a precondition for establishing BOM and other business data, including raw materials, in-product, semi-finished product, tool, auxiliary material and the like; the double units of the material refer to the same material, and the stock form of the material is expressed by two units in the system.
2) BOM (Bill of Material, Bill of materials): the method comprises the following steps of describing a product structure file in a data format, wherein the product structure data file can be identified by a computer and indicates the structural relationship among materials and the required quantity of each material; the BOM enables the system to identify the product structure, provides basis for the purchasing department to make purchasing application, provides basis for the production department to issue production orders to carry out quota material collection, and is a link for contacting and communicating various businesses of enterprises.
3) MDS (Master Demand Schedule): the MDS is only responsible for the balance of the demands, does not consider the production capacity, does not consider the inventory, the materials in preparation and in use, and only calculates the demands.
Referring to fig. 1, fig. 1 is a frame diagram of a method for implementing an MRP function based on two units of material according to an embodiment of the present invention; as shown in the figure, the basic data comprises four items of management data, purchase data, sale data and sale prediction, the four items of basic data are initially set, and then an MRP scheme is set according to the four items of basic data, including the MDS requirement of the operation scheme to obtain the demand summary; maintaining the MRP version and rolling the MRP to determine the shortage of finished products; and finally, calculating to obtain a raw material purchasing plan by combining with actual conditions. The specific embodiments are described in detail below.
Example 1
The embodiment of the invention provides a method for realizing MRP function based on material double units, as shown in FIG. 2, the method comprises the following steps:
step S201, acquiring basic data, wherein the basic data comprises product demand information, current inventory information and in-transit raw material information;
determining product demand information according to the customer order, wherein the product demand information comprises the time point of finished product demand and the total number of required finished products, and determining a bill of materials forming the product according to a BOM table.
And setting production management data, purchase data, sales data and sales prediction at the basic material data of each process step.
The production management data timely and effectively adjusts various relations inside and outside the production process of an enterprise through production control work, so that the operation of a production system meets the requirements of a set production plan, and the aims of the variety, quality, yield, production period and production cost of expected production are fulfilled.
The production management data comprises: material dispensing unit lot, minimum material dispensing quantity, production unit lot, minimum production quantity, loss rate during production, fixed lead time, modified lead time lot, QC lead time, and the like. The tube production data in this embodiment is responsible for maintaining the time required from the previous process to the completion of the production of the semi-finished product and the finished product, i.e. the fixed lead time.
The production management information also comprises the inventory information of the current materials including raw materials, semi-finished products, finished products and the like and the in-transit raw material information such as the number of in-transit raw materials, the delivery time, the arrival time and the like.
The purchasing data includes purchasing unit batch, minimum purchasing quantity, purchasing loss rate, file operation time, lead time of delivery, lead time to factory, lead time to warehouse, etc. In this embodiment, the procurement data is responsible for maintaining the time required for the procurement of the parts, i.e. the lead time of delivery.
The sales data is responsible for maintaining the sales forecast codes corresponding to the product codes.
The sales forecast is responsible for generating sales forecast codes, namely product forecast material numbers, which refer to material codes.
The said information of production management, purchase, sale and sale forecast are manually set up according to actual conditions.
And importing the customer demand order data into the system MDS after the four basic data are set.
Fig. 3 is a schematic front-end page diagram illustrating requirement aggregation of MDS requirements of a rolling operation scheme according to an embodiment of the present invention; as shown in the figure, the MDS version is the same as the MRP version, and MDS operation parameters need to be set during operation, and mainly include the following data:
1) date range of data
The data date range is a prediction time range section, which limits the effective time of the MDS requirement, and the MDS requirement is invalid and cannot be used as a data source of the MRP when the effective time of the MDS requirement is less than the starting time of the data date range or exceeds the ending time of the data date range. The date range of the data is determined by the delivery date of the customer's required order and can be adjusted properly according to the actual situation.
2) Date selection
The specific date of the finished product requirement is set according to the delivery date of the sales contract or the delivery date formulated in the system, and can be selected from dates provided by the system.
3) Using time distance mode
The time distance mode provided by the system comprises the following steps: month, ten days, week, day, and custom time interval.
The time intervals are months, ten days and weeks, the days of the months, ten days, the early months, the early days and the Monday of the week in which the start date of the data date range is located are taken as the second time interval days of the time intervals, and the first time interval day is the previous months, ten days, the early months, the early days and the Monday of the week.
The time interval is day and the self-defined time interval, the starting date of the data date range is the second time interval day, and the first time interval day is the previous day.
The material demands in the time distance range are all summarized on the time distance day.
The time interval mode is selected by the user according to the actual situation, and is not specifically limited in this embodiment.
4) Other data in the schematic diagram include a forecast plan benchmark day, a demand inclusion mode, a forecast quantity source, an operation date, an order source, a priority and other data that a user may select according to the actual situation, which is not specifically limited in this embodiment.
The data content shown in fig. 3 is only one possible selection situation, and the data can be adjusted and updated at any time according to the actual situation when the user operates the device.
After the operation parameters are set, basic data collected at different time points can be obtained by rolling the MDS requirements.
Step S102, determining the total number of finished products required at the required time point according to the product demand information, determining the first number of finished products which can be converted into finished products at the required time point according to the current inventory information, and determining the second number of finished products which can be converted into finished products at the required time point according to the in-transit raw material information;
the step obtains summarized basic data of different time points through MDS requirements of the rolling operation scheme, and the total number of required finished products corresponding to the different requirement time points can be determined from the basic data.
The current inventory information includes current raw material inventory information and current semi-finished product inventory information.
The material basic data is provided with a main unit field, a yield field and a reference unit field. The stock unit is the main unit of the material. The conversion application of double units of materials is realized in a BOM according to composition quantity and base number fields, the quantity refers to the sub-component composition of how many units are needed by a parent component of one unit, and the composition quantity is presented by the base number if the composition quantity cannot be expressed by an integer or a decimal divided by the integer.
The main unit and the reference unit are arranged to realize the conversion relationship among the raw materials, the semi-finished products and the finished products, so that the quantity of the finished products into which the raw materials and the semi-finished products can be converted can be obtained according to the stock information of the raw materials and the semi-finished products, such as the stock quantity.
Obtaining the conversion time from the raw materials to the finished products according to the basic data, further determining the number of the raw materials in the current stock which can be converted into the finished products at the demand time point, determining the number of the finished products which can be converted from the raw materials in the current stock which can be converted into the finished products at the demand time point, and multiplying the number of the finished products by the corresponding finished product yield to obtain the number of the finished products which can be converted from the raw materials in the current stock at the demand time point;
obtaining the conversion time from the semi-finished products to the finished products according to the basic data, further determining the number of the semi-finished products in the current stock which can be converted into the finished products at the demand time point, determining the number of the finished products which can be converted from the semi-finished products in the current stock which can be converted into the finished products at the demand time point, and multiplying the number of the finished products by the corresponding finished product yield to obtain the number of the finished products which can be converted from the semi-finished products in the current stock at the demand time point;
the sum of the number of finished products into which the raw materials in the current stock can be converted at the demand time point and the number of finished products into which the semi-finished products in the current stock can be converted at the demand time point is determined as the first finished product number.
The yield is the qualified rate, which is the ratio of the materials which are qualified in the inspection to the total number of the materials. In the embodiment, additional raw materials caused by the unqualified or loss problem are added to the required raw materials obtained by demand prediction by setting a yield field.
In this embodiment, the yield of the finished products when determining the number of the first finished products may be calculated according to the yield of the raw materials and the yield of the semi-finished products in the yield field of the basic data, and the specific calculation may be performed by using the existing method, which is not described in detail herein.
Determining the quantity of raw materials which reach the inventory in different periods according to the in-transit raw material information including the quantity of the raw materials and the time of arrival at the inventory, selecting the raw materials which can reach the inventory at the required time point and before and are converted into finished products, calculating the quantity of the finished products which can be converted from the raw materials, and multiplying the quantity of the finished products by the corresponding finished product yield to obtain the quantity of the finished products which can be converted from the in-transit raw materials at the required time point; and determining the number of the finished products as a second finished product number.
In this embodiment, the yield of the finished product when determining the second quantity of finished products may be calculated according to the yield of the raw material in the yield field of the basic data, and the specific calculation may be performed by using an existing method, which is not described in detail herein.
And step S103, determining the shortage amount of the finished products according to the total number of the finished products, the current inventory finished product amount, the first finished product amount and the second finished product amount, and determining the required raw materials according to the shortage amount of the finished products.
Reading the quantity of finished products in the current stock from the basic data, determining the total quantity of the required finished products, the first quantity of the finished products and the second quantity of the finished products according to the steps, and according to a formula: and calculating the short-cut amount of the finished product at the required time point.
After determining the shortage of the finished products at the demand time point, the user determines the shortage condition of the required raw materials according to the shortage of the finished products, and determines a new raw material purchasing plan according to the demand time point and the shortage condition of the raw materials.
The MRP version in this embodiment is periodically maintained, and is specifically implemented by periodically updating basic data including product information, current inventory information, and in-transit raw material information by a user, rolling MDS requirements of an operation scheme to obtain requirement summaries at different requirement time points, then rolling an execution scheme by the MRP system according to the requirement summary data, and determining required raw materials corresponding to different requirement time points by executing the above steps.
Fig. 4 is a front-end page schematic diagram of a rolling execution scheme of an MRP system provided in an embodiment of the present invention; as shown in the figure, the parameters to be set mainly include:
source of simulated material number: selecting MDS requirements, and importing the requirement summary data obtained by the operation MDS requirements;
BOM expansion order: setting according to data in a BOM (bill of material) table;
supply and demand date range: determining according to the demand order;
the time distance using mode comprises the following steps: the operation is the same as the operation of the MDS, and the user selects the operation according to the actual situation, which is not specifically limited in the embodiment;
the data such as other parameters shown in the figure may be selected by the user according to the actual situation, and is not specifically limited in this embodiment.
The data content shown in fig. 4 is only one possible selection situation, and the data can be adjusted and updated at any time according to the actual situation when the user operates the device.
In the embodiment, 4GL language is adopted to realize process front-end page display, background code logic control and related interface data development.
Example 2
The method for realizing the MRP function based on the material double unit in the invention is explained above, and the equipment for realizing the MRP function based on the material double unit is explained below.
Referring to fig. 5, an embodiment of the present invention provides an apparatus for implementing an MRP function based on a material dual unit, including:
the data summarizing module 501 is used for acquiring basic data, wherein the basic data comprises product demand information, current inventory information and in-transit raw material information;
a demand forecasting module 502, configured to determine, according to the product demand information, a total number of finished products required at a demand time point, determine, according to current inventory information, a first number of finished products that can be converted into finished products at the demand time point, and determine, according to the in-transit raw material information, a second number of finished products that can be converted into finished products at the demand time point;
and the demand determining module 503 is configured to determine a shortage amount of the finished products according to the total number of the finished products, the current number of finished products in stock, the first number of finished products and the second number of finished products, and determine the required raw materials according to the shortage amount of the finished products.
Optionally, the product demand information determined by the data summarization module includes a demand time point, a demand total number of finished products, and a bill of materials of the product;
the current inventory information comprises current raw material inventory information and current semi-finished product inventory information.
Optionally, the determining, by the demand forecasting module, the first finished product quantity of the finished product that can be converted according to the current inventory information includes:
determining the number of finished products which can be converted from the raw materials in the current stock at the required time point according to the current raw material stock information and the conversion time from the raw materials to the finished products;
determining the number of finished products which can be converted into semi-finished products in the current stock at the required time point according to the current semi-finished product stock information and the conversion time from the semi-finished products to the finished products;
and determining the sum of all the determined quantities as the first finished product quantity.
Optionally, the determining, by the demand forecasting module, the number of finished products into which the raw materials in the current stock can be converted according to the current raw material stock information includes:
determining the number of finished products which can be converted from the raw materials in the current stock according to the current raw material stock information and the yield of the raw materials;
determining the number of finished products into which semi-finished products in the current inventory can be converted according to the current semi-finished product inventory information, wherein the method comprises the following steps:
and determining the number of finished products which can be converted from the semi-finished products in the current inventory according to the current semi-finished product inventory information and the yield of the semi-finished products.
Optionally, the demand forecasting module determines a second finished product quantity of finished products that can be converted at the demand time point according to the in-transit raw material information, and includes:
determining raw materials which arrive at the stock in different periods according to the in-transit raw material information;
and determining the quantity of the second finished products of the converted finished products according to the corresponding raw materials which arrive at the stock in the period of the demand time point.
Optionally, the demand forecasting module determines a second finished product quantity of the finished products that can be converted according to the raw materials that arrive in the stock within the period of the demand time point, and includes:
and determining the second finished product quantity of the finished products which can be converted according to the raw materials which reach the stock and the yield of the raw materials corresponding to the period of the demand time point.
Optionally, the demand determining module determines a shortage amount of the finished product according to the total number of the finished product, the current number of finished products in stock, the first number of finished products and the second number of finished products, and determines the required raw material according to the shortage amount of the finished product, including:
according to the formula: determining the shortage of finished products, namely the total number of the finished products, the number of finished products in current stock, the number of first finished products and the number of second finished products;
and determining the required raw materials according to the shortage of the finished product.
Example 3
Referring to fig. 6, another embodiment of the device for implementing an MRP function based on a material dual unit provided in the embodiment of the present application includes:
a processor 601, a memory 602, a transceiver 609, and a bus system 611;
wherein the memory is used for storing programs;
the processor is used for executing the program in the memory and comprises the following steps:
acquiring basic data, wherein the basic data comprises product demand information, current inventory information and in-transit raw material information;
determining the total number of finished products required at the required time point according to the product demand information, determining the first finished product number of the finished products which can be converted at the required time point according to the current inventory information, and determining the second finished product number of the finished products which can be converted at the required time point according to the in-transit raw material information;
and determining the shortage amount of the finished products according to the total number of the finished products, the current inventory finished product amount, the first finished product amount and the second finished product amount, and determining the required raw materials according to the shortage amount of the finished products.
Fig. 6 is a schematic structural diagram of an intelligent device according to an embodiment of the present invention, where the intelligent device 600 may generate relatively large differences according to different configurations or performances, and may include one or more processors (CPU) 601 (e.g., one or more processors) and a memory 602, and one or more storage media 603 (e.g., one or more mass storage devices) for storing applications 604 or data 606. Wherein the memory 602 and storage medium 603 may be transient or persistent storage. The program stored in the storage medium 603 may include one or more modules (not shown), and each module may include a series of instruction operations in the information processing apparatus. Still further, the processor 601 may be configured to communicate with the storage medium 603 and execute a series of instruction operations in the storage medium 603 on the smart device 600.
The smart device 600 may also include one or more power supplies 610, one or more wired or wireless network interfaces 607, one or more input-output interfaces 608, and/or one or more operating systems 605, such as Windows Server, Mac OS X, Unix, Linux, FreeBSD, etc.
Optionally, the product demand information determined by the processor includes a time point of demand, a total number of required finished products, and a bill of materials constituting the product;
the current inventory information comprises current raw material inventory information and current semi-finished product inventory information.
Optionally, the processor determines a first finished product quantity of finished products that can be converted according to the current inventory information, including:
determining the number of finished products which can be converted from the raw materials in the current stock at the required time point according to the current raw material stock information and the conversion time from the raw materials to the finished products;
determining the number of finished products which can be converted into semi-finished products in the current stock at the required time point according to the current semi-finished product stock information and the conversion time from the semi-finished products to the finished products;
and determining the sum of all the determined quantities as the first finished product quantity.
Optionally, the processor determines, according to the current raw material inventory information, a number of finished products into which the raw materials in the current inventory can be converted, including:
determining the number of finished products which can be converted from the raw materials in the current stock according to the current raw material stock information and the yield of the raw materials;
determining the number of finished products into which semi-finished products in the current inventory can be converted according to the current semi-finished product inventory information, wherein the method comprises the following steps:
and determining the number of finished products which can be converted from the semi-finished products in the current inventory according to the current semi-finished product inventory information and the yield of the semi-finished products.
Optionally, the processor determines a second quantity of finished goods that can be converted into finished goods at the required time point according to the in-transit raw material information, including:
determining raw materials which arrive at the stock in different periods according to the in-transit raw material information;
and determining the quantity of the second finished products of the converted finished products according to the corresponding raw materials which arrive at the stock in the period of the demand time point.
Optionally, the processor determines a second quantity of finished products that can be converted into finished products according to the corresponding raw materials arriving in stock in the period of the demand time point, including:
and determining the second finished product quantity of the finished products which can be converted according to the raw materials which reach the stock and the yield of the raw materials corresponding to the period of the demand time point.
Optionally, the processor determines a shortage of finished products according to the total number of finished products, the current number of finished products in stock, the first number of finished products and the second number of finished products, and determines the required raw materials according to the shortage of finished products, including:
according to the formula: determining the shortage of finished products, namely the total number of the finished products, the number of finished products in current stock, the number of first finished products and the number of second finished products;
and determining the required raw materials according to the shortage of the finished product.
Embodiments of the present invention further provide a computer-readable storage medium, which includes instructions that, when executed on a computer, cause the computer to perform the method for positioning an intelligent device provided in the foregoing embodiments.
It can be clearly understood by those skilled in the art that, for convenience and brevity of description, the specific working processes of the above-described apparatuses and modules may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.
In the several embodiments provided in the present application, it should be understood that the disclosed system, apparatus and method may be implemented in other manners. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the modules is merely a logical division, and in actual implementation, there may be other divisions, for example, multiple modules or components may be combined or integrated into another system, or some features may be omitted, or not implemented. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or modules, and may be in an electrical, mechanical or other form.
The modules described as separate parts may or may not be physically separate, and parts displayed as modules may or may not be physical modules, may be located in one place, or may be distributed on a plurality of network modules. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the present embodiment.
In addition, functional modules in the embodiments of the present application may be integrated into one processing module, or each of the modules may exist alone physically, or two or more modules are integrated into one module. The integrated module can be realized in a hardware mode, and can also be realized in a software functional module mode. The integrated module, if implemented in the form of a software functional module and sold or used as a stand-alone product, may be stored in a computer readable storage medium.
In the above embodiments, the implementation may be wholly or partially realized by software, hardware, firmware, or any combination thereof. When implemented in software, may be implemented in whole or in part in the form of a computer program product.
The computer program product includes one or more computer instructions. When loaded and executed on a computer, cause the processes or functions described in accordance with the embodiments of the application to occur, in whole or in part. The computer may be a general purpose computer, a special purpose computer, a network of computers, or other programmable device. The computer instructions may be stored in a computer readable storage medium or transmitted from one computer readable storage medium to another, for example, from one website site, computer, server, or data center to another website site, computer, server, or data center via wired (e.g., coaxial cable, fiber optic, Digital Subscriber Line (DSL)) or wireless (e.g., infrared, wireless, microwave, etc.). The computer-readable storage medium can be any available medium that a computer can store or a data storage device, such as a server, a data center, etc., that is integrated with one or more available media. The usable medium may be a magnetic medium (e.g., floppy disk, hard disk, magnetic tape), an optical medium (e.g., DVD), or a semiconductor medium (e.g., Solid State Disk (SSD)), among others.
The technical solutions provided by the present application are introduced in detail, and the present application applies specific examples to explain the principles and embodiments of the present application, and the descriptions of the above examples are only used to help understand the method and the core ideas of the present application; meanwhile, for a person skilled in the art, according to the idea of the present application, there may be variations in the specific embodiments and the application scope, and in summary, the content of the present specification should not be construed as a limitation to the present application.
As will be appreciated by one skilled in the art, embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to the application. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
It will be apparent to those skilled in the art that various changes and modifications may be made in the present application without departing from the spirit and scope of the application. Thus, if such modifications and variations of the present application fall within the scope of the claims of the present application and their equivalents, the present application is intended to include such modifications and variations as well.
Claims (10)
1. A method for realizing MRP function based on material double units is characterized by comprising the following steps:
acquiring basic data, wherein the basic data comprises product demand information, current inventory information and in-transit raw material information;
determining the total number of finished products required at the required time point according to the product demand information, determining the first finished product number of the finished products which can be converted at the required time point according to the current inventory information, and determining the second finished product number of the finished products which can be converted at the required time point according to the in-transit raw material information;
and determining the shortage amount of the finished products according to the total number of the finished products, the current inventory finished product amount, the first finished product amount and the second finished product amount, and determining the required raw materials according to the shortage amount of the finished products.
2. The method of claim 1, wherein the product demand information includes a point in time of demand, a total number of finished products demanded, a bill of materials comprising the product;
the current inventory information comprises current raw material inventory information and current semi-finished product inventory information.
3. The method of claim 1, wherein determining a first quantity of finished goods that can be converted to finished goods based on current inventory information comprises:
determining the number of finished products which can be converted from the raw materials in the current stock at the required time point according to the current raw material stock information and the conversion time from the raw materials to the finished products;
determining the number of finished products which can be converted into semi-finished products in the current stock at the required time point according to the current semi-finished product stock information and the conversion time from the semi-finished products to the finished products;
and determining the sum of all the determined quantities as the first finished product quantity.
4. The method of claim 3, wherein determining the number of finished products into which the raw materials in the current inventory can be converted based on the current raw material inventory information comprises:
determining the number of finished products which can be converted from the raw materials in the current stock according to the current raw material stock information and the yield of the raw materials;
determining the number of finished products into which semi-finished products in the current inventory can be converted according to the current semi-finished product inventory information, wherein the method comprises the following steps:
and determining the number of finished products which can be converted from the semi-finished products in the current inventory according to the current semi-finished product inventory information and the yield of the semi-finished products.
5. The method of claim 1, wherein determining a second quantity of finished goods that can be converted to finished goods at a point in time of demand from the in-transit raw material information comprises:
determining raw materials which arrive at the stock in different periods according to the in-transit raw material information;
and determining the quantity of the second finished products of the converted finished products according to the corresponding raw materials which arrive at the stock in the period of the demand time point.
6. The method of claim 1, wherein determining a second quantity of finished goods that can be converted into finished goods based on the corresponding stock arriving raw materials during the time period at the demand time point comprises:
and determining the second finished product quantity of the finished products which can be converted according to the raw materials which reach the stock and the yield of the raw materials corresponding to the period of the demand time point.
7. The method of claim 1, wherein determining a shortage of finished goods based on the total number of finished goods, the current quantity of finished goods in stock, the first quantity of finished goods, and the second quantity of finished goods, and determining a required raw material based on the shortage of finished goods comprises:
according to the formula: determining the shortage of finished products, namely the total number of the finished products, the number of finished products in current stock, the number of first finished products and the number of second finished products;
and determining the required raw materials according to the shortage of the finished product.
8. A smart device, comprising:
the data summarization module is used for acquiring basic data, wherein the basic data comprises product demand information, current inventory information and in-transit raw material information;
the demand forecasting module is used for determining the total number of finished products required at the demand time point according to the product demand information, determining the first finished product number of the finished products which can be converted at the demand time point according to the current inventory information, and determining the second finished product number of the finished products which can be converted at the demand time point according to the in-transit raw material information;
and the demand determining module is used for determining the shortage amount of the finished products according to the total number of the finished products, the current stock finished product amount, the first finished product amount and the second finished product amount, and determining the required raw materials according to the shortage amount of the finished products.
9. A smart device comprising a memory and a processor, wherein:
the memory is used for storing a program of a computer for executing the intelligent equipment positioning method of any one of claims 1 to 7;
the central processing unit is used for executing the program in the memory and realizing the steps of the intelligent device positioning method according to any one of claims 1 to 7.
10. A computer program storage medium having a computer program stored thereon, wherein the computer program, when executed by a processor, performs the steps of the method for locating a smart device according to any one of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910854886.9A CN110610337A (en) | 2019-09-10 | 2019-09-10 | Method and equipment for realizing MRP function based on material double units |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910854886.9A CN110610337A (en) | 2019-09-10 | 2019-09-10 | Method and equipment for realizing MRP function based on material double units |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110610337A true CN110610337A (en) | 2019-12-24 |
Family
ID=68892503
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910854886.9A Pending CN110610337A (en) | 2019-09-10 | 2019-09-10 | Method and equipment for realizing MRP function based on material double units |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110610337A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111260293A (en) * | 2020-01-17 | 2020-06-09 | Oppo（重庆）智能科技有限公司 | Remote material matching method and system |
| CN111539666A (en) * | 2020-03-31 | 2020-08-14 | 合肥联宝信息技术有限公司 | Material demand management method and device and computer storage medium |
| CN112613774A (en) * | 2020-12-28 | 2021-04-06 | 浙江智昌机器人科技有限公司 | MRP algorithm based on data feedback |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101692300A (en) * | 2009-10-14 | 2010-04-07 | 金蝶软件（中国）有限公司 | Warning method, warning device and warning system for visual safety stock |
| CN103106547A (en) * | 2013-02-21 | 2013-05-15 | 广州宝钢南方贸易有限公司 | Device and method for forecasting steel product procurement demands |
| CN103679322A (en) * | 2012-10-24 | 2014-03-26 | 杭州金色能源科技有限公司 | Production data processing method, device thereof, and system thereof |
| US20190197449A1 (en) * | 2017-12-26 | 2019-06-27 | International Business Machines Corporation | Validation of supply chain data structures |
-
2019
- 2019-09-10 CN CN201910854886.9A patent/CN110610337A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101692300A (en) * | 2009-10-14 | 2010-04-07 | 金蝶软件（中国）有限公司 | Warning method, warning device and warning system for visual safety stock |
| CN103679322A (en) * | 2012-10-24 | 2014-03-26 | 杭州金色能源科技有限公司 | Production data processing method, device thereof, and system thereof |
| CN103106547A (en) * | 2013-02-21 | 2013-05-15 | 广州宝钢南方贸易有限公司 | Device and method for forecasting steel product procurement demands |
| US20190197449A1 (en) * | 2017-12-26 | 2019-06-27 | International Business Machines Corporation | Validation of supply chain data structures |
Non-Patent Citations (1)
| Title |
|---|
| 尹斐: "MRP系统中的物料清单和物料需求计划研究", 《中国优秀博硕士学位论文全文数据库(硕士)经济与管理科学辑》 * |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111260293A (en) * | 2020-01-17 | 2020-06-09 | Oppo（重庆）智能科技有限公司 | Remote material matching method and system |
| CN111539666A (en) * | 2020-03-31 | 2020-08-14 | 合肥联宝信息技术有限公司 | Material demand management method and device and computer storage medium |
| CN111539666B (en) * | 2020-03-31 | 2022-04-15 | 合肥联宝信息技术有限公司 | Material demand management method and device and computer storage medium |
| CN112613774A (en) * | 2020-12-28 | 2021-04-06 | 浙江智昌机器人科技有限公司 | MRP algorithm based on data feedback |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110610337A (en) | Method and equipment for realizing MRP function based on material double units | |
| CN110276571A (en) | Cargo dispatching method and device and computer readable storage medium | |
| WO2021218553A1 (en) | Net-shaped supply chain decision method and device based on robot, and storage medium | |
| JP6370757B2 (en) | Profit / loss prediction apparatus and profit / loss prediction program | |
| WO2014141394A1 (en) | Device for assisting determination of supply group and program for assisting determination of supply group | |
| CN109978392B (en) | Agile software development management method and device, electronic equipment and storage medium | |
| He et al. | A retailer promotion policy model in a manufacturer Stackelberg dual-channel green supply chain | |
| WO2023202326A1 (en) | Data processing method and related apparatus | |
| EP4207018A1 (en) | Stocking quantity determination method and apparatus, and computer storage medium and electronic device | |
| Zheng et al. | Impact of an emergency order opportunity on supply chain coordination | |
| CN103400216A (en) | System and method for contract management based on metadata | |
| JP2013178731A (en) | Producible quantity calculation device, producible quantity calculation program, and storage medium | |
| US20170091683A1 (en) | Database system for distribution center fulfillment capacity availability tracking and method therefor | |
| Sawik | Multi-objective due-date setting in a make-to-order environment | |
| CN112990743B (en) | Method, device and storage medium for determining production cycle of commodity | |
| CN101593317A (en) | The material requirement planning system and method | |
| JP6242362B2 (en) | Profit / loss prediction apparatus and profit / loss prediction program | |
| CN108491996A (en) | Cost Estimation, device, terminal and computer readable storage medium | |
| CN110276469B (en) | Order placing control method, order placing control device and computer system | |
| CN108681838B (en) | Scheduling plan determining method and device | |
| CN107229996A (en) | A kind of integrated supply chain management platform | |
| US20040122724A1 (en) | System and method for generating priorities of manufacturing orders | |
| CN111126722A (en) | WeChat small program based commodity checking method | |
| CN112101703B (en) | Metadata-based predicted available inventory statistical method and device | |
| US20140364983A1 (en) | Systems and Methods for Harmonizing Customer Orders and Production Capacities in Lean Manufacturing |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20191224 |