CN104850975A - MRP (Material Requirement Planning) selection method and device - Google Patents

MRP (Material Requirement Planning) selection method and device Download PDF

Info

Publication number
CN104850975A
CN104850975A CN201510276108.8A CN201510276108A CN104850975A CN 104850975 A CN104850975 A CN 104850975A CN 201510276108 A CN201510276108 A CN 201510276108A CN 104850975 A CN104850975 A CN 104850975A
Authority
CN
China
Prior art keywords
described
material
regional number
mrp
mrp regional
Prior art date
Application number
CN201510276108.8A
Other languages
Chinese (zh)
Inventor
范元冬
陈少兵
Original Assignee
广州视源电子科技股份有限公司
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by 广州视源电子科技股份有限公司 filed Critical 广州视源电子科技股份有限公司
Priority to CN201510276108.8A priority Critical patent/CN104850975A/en
Publication of CN104850975A publication Critical patent/CN104850975A/en

Links

Abstract

An embodiment of the invention discloses an MRP (Material Requirement Planning) selection method which is used for solving a lot of allocation problems in the prior art, which effectively reduces the allocation cost and which improves the MRP efficiency. The method comprises a step of obtaining the stock of materials in a first MRP zone number; a step of determining whether the stock of the materials in the first MRP zone number meets a preset requirement or not; a step of obtaining the stock of materials in a second MRP zone number from a data base according to the first MRP zone number when the stock of any material in the first MRP zone number does not meet the preset requirement; a step of accumulating the total stock of the materials in the first MRP zone number and the materials in the second MRP zone number; and a step of selecting the material which meets the preset requirement as a required material when at least one material in the first MRP zone number and the second MRP zone number meets the preset requirement. An embodiment of the invention also provides a corresponding MRP selection device.

Description

A kind of MRP system of selection and device

Technical field

The present invention relates to electronic applications, be specifically related to a kind of MRP system of selection and device.

Background technology

(it can be used for calculating material requirement amount MRP for English full name: Material Requirement Planning, abbreviation: MRP) be a kind of production planning and control system based on computing machine.

In most of manufacturing enterprise, in order to better production management, often arrange warehouse in external processing factory, traditional MRP system of selection is the maximum prioritizing selection algorithm of stock, that is: prioritizing selection tank farm stock the maximum.This system of selection, for the enterprise of external processing factory Relatively centralized, is applicable, but for the enterprise of external processing factory relative distribution, this algorithm, by a large amount of the alloting of generation, allots cost high, is not easy to implement.

Summary of the invention

Embodiments provide a kind of MRP system of selection and device, for solving in prior art the problem producing and allot in a large number, effectively reducing and alloting cost, improving MRP efficiency.

First aspect present invention provides a kind of MRP system of selection, comprising:

From database, obtain the tank farm stock of material in a MRP regional number, a described MRP regional number is for representing order production ground, and described material comprises major ingredient and substitutes material;

Judge whether the tank farm stock of material in a described MRP regional number meets preset need respectively;

When determining that the tank farm stock of any one material in a described MRP regional number does not meet described preset need, from described database, the tank farm stock of the material in the 2nd MRP regional number is obtained according to a described MRP regional number, described 2nd MRP regional number is for representing a described MRP regional number neighboringly, a described MRP regional number is stored, the tank farm stock of material in described 2nd MRP regional number and a described MRP regional number and described 2nd MRP regional number in described database;

Add up total tank farm stock of the material in a described MRP regional number and described 2nd MRP regional number;

When determining that total tank farm stock of at least one material in a described MRP regional number and described 2nd MRP regional number meets described preset need, select the material meeting described preset need as required material.

In conjunction with first aspect, in the implementation that the first is possible, described judge whether the tank farm stock of material in a described MRP regional number meets preset need respectively after, also comprise:

When determining that in a described MRP regional number, at least one material meets described preset need, select the material meeting described preset need as required material.

In conjunction with the first possible implementation of first aspect, in the implementation that the second is possible, described when determining that in a described MRP regional number, at least one material meets described preset need, select the material meeting described preset need to comprise as required material:

When determining to only have a kind of material to meet described preset need in a described MRP regional number, select the material meeting described preset need as required material.

In conjunction with the first possible implementation of first aspect, in the implementation that the third is possible, described when determining that in a described MRP regional number, at least one material meets described preset need, select the material meeting described preset need to comprise as required material:

When determining that the tank farm stock of at least two kinds of materials in a described MRP regional number meets described preset need, select material that in a described MRP regional number, tank farm stock is maximum as required material.

In conjunction with first aspect, in the 4th kind of possible implementation, described when determining that total tank farm stock of at least one material in a described MRP regional number and described 2nd MRP regional number meets described preset need, select the material meeting described preset need to comprise as required material:

When determining that total tank farm stock of at least one material in a described MRP regional number and described 2nd MRP regional number meets described preset need, select material that in a described MRP regional number, tank farm stock is maximum as required material.

Second aspect present invention provides a kind of MRP selecting arrangement, comprising:

First acquisition module, for obtaining the tank farm stock of material in a MRP regional number from database, a described MRP regional number is for representing order production ground, and described material comprises major ingredient and substitutes material;

Judge module, for judging whether the tank farm stock of material in a described MRP regional number meets preset need respectively;

Second acquisition module, for when determining that the tank farm stock of any one material in a described MRP regional number does not meet described preset need, from described database, the tank farm stock of the material in the 2nd MRP regional number is obtained according to a described MRP regional number, described 2nd MRP regional number is for representing a described MRP regional number neighboringly, a described MRP regional number is stored, the tank farm stock of material in described 2nd MRP regional number and a described MRP regional number and described 2nd MRP regional number in described database;

Accumulation module, for total tank farm stock of the material in an accumulative described MRP regional number and described 2nd MRP regional number;

First selects module, for when determining that total tank farm stock of at least one material in a described MRP regional number and described 2nd MRP regional number meets described preset need, selects the material meeting described preset need as required material.

In conjunction with first aspect, in the implementation that the first is possible, described device also comprises: second selects module;

Described second selects module, for when determining that in a described MRP regional number, at least one material meets described preset need, selects the material meeting described preset need as required material.

In conjunction with the first possible implementation of second aspect, in the implementation that the second is possible,

Described second selects module, specifically for when determining to only have a kind of material to meet described preset need in a described MRP regional number, selects the material meeting described preset need as required material.

In conjunction with the first possible implementation of second aspect, in the implementation that the third is possible,

Described second selects module, specifically for when determining that the tank farm stock of at least two kinds of materials in a described MRP regional number meets described preset need, selects material that in a described MRP regional number, tank farm stock is maximum as required material.

In conjunction with second aspect, in the 4th kind of possible implementation,

Described first selects module, specifically for when determining that total tank farm stock of at least one material in a described MRP regional number and described 2nd MRP regional number meets described preset need, select material that in a described MRP regional number, tank farm stock is maximum as required material.

Apply above technical scheme, owing to storing the tank farm stock of material in a MRP regional number and the 2nd MRP regional number in database, first judge whether the tank farm stock of material in a MRP regional number meets preset need, when determining that the tank farm stock of any one material in a described MRP regional number does not meet described preset need, from described database, obtain the tank farm stock of the material in the 2nd MRP regional number according to a described MRP regional number; Add up total tank farm stock of the material in a described MRP regional number and described 2nd MRP regional number; When determining that total tank farm stock of at least one material in a described MRP regional number and described 2nd MRP regional number meets described preset need, select the material meeting described preset need as required material.Visible, adopt nearby principle to allot material in the present invention, effectively reduce and allot cost, improve MRP efficiency.

Term " first ", " second ", " the 3rd " " 4th " etc. in instructions of the present invention and claims and above-mentioned accompanying drawing are for distinguishing different objects, instead of for describing particular order.In addition, term " comprises " and " having " and their any distortion, and intention is to cover not exclusive comprising.Such as contain the process of series of steps or unit, method, system, product or equipment and be not defined in the step or unit listed, but also comprise the step or unit do not listed alternatively, or also comprise alternatively for other intrinsic step of these processes, method, product or equipment or unit.

In traditional MRP computing, such as: certain enterprise A, its stock material is distributed in SH (Shanghai), these three factories of GZ (Guangzhou), SZ (Shenzhen).Existing at major ingredient 1, the alternative material of major ingredient 1 has alternative material 2, and substitute material 3, following table is the inventory information of each material.

GZ (Guangzhou) SH (Shanghai) SZ (Shenzhen) Add up to Major ingredient 1 0 500 0 500 Substitute material 2 0 200 100 300 Substitute material 3 200 0 0 200

Suppose: plan at Guangzhou (GZ) plant produced product, the wherein demand N=300 of material major ingredient 1, according to the maximum prioritizing selection algorithm of stock, because the tank farm stock of major ingredient 1 is maximum, S [total]=500, so have selected major ingredient 1.

This just means that major ingredient 1 does not have stock in Guangzhou, can only allot from SH (Shanghai), and this expense of alloting produced is surprising, if the cost of major ingredient 1 is lower, directly buying is perhaps more to one's profit, and allots the loss easily causing material in process.Why adopt the maximum prioritizing selection algorithm of stock mainly in order to ensure that amount of purchase is minimized in traditional enterprise information management, but this algorithm does not have the concept of MRP regional number, cause the tank farm stock that have selected other factories, produce a large amount of alloting, allot cost high, and in the process of alloting, easily cause the loss of material, be not easy to implement.In order to solve this problem, launch discussion of the present invention:

To facilitate understanding of the present embodiment of the invention, first introduce during the embodiment of the present invention describes at this relevant factor that can introduce;

MRP;

MRP refers to subordinate according to each level material of product structure and quantitative relation, with every part product for plan object, with the period of completion for time reference back scheduling, by time in advance length distinguish each material and to assign plans the sequencing of time, be plan management of materials and quipment pattern in a kind of industrial manufacturing enterprise.Generally, MRP is first according to the production plan that the market demand forecast and client's order are formulated, then based on production schedule, product structure and Inventory Performance, by calculating demand and the required time of required material, thus determine the processing progress of product and a kind of technology of order schedule.

Refer to Fig. 1, in the embodiment of the present invention, an embodiment of MRP system of selection comprises:

101, from database, obtain the tank farm stock of material in a MRP regional number;

Storage products sequence information in server, this product sequence information comprises O/No., quantity on order, material requirement information etc., and this material requirement information comprises various materials, and the demand that this various materials is corresponding respectively.Time wherein for certain material concrete, server first obtains the tank farm stock of this material in a MRP regional number, and a MRP regional number is for representing order production ground, and described material comprises major ingredient and substitutes material.

102, judge whether the tank farm stock of material in a MRP regional number meets preset need respectively; If so, step 103 is performed; If not, step 104 is performed.

Unlike the prior art, first judge in the embodiment of the present invention whether the tank farm stock of material in a MRP regional number meets preset need, namely, adopt nearby principle, first judge the tank farm stock of the material on order production ground, when there being the tank farm stock meeting preset need, then without the need to alloting material, effectively reducing and alloting cost.

103, when determining that in a MRP regional number, at least one material meets preset need, select the material meeting preset need as required material;

When determining that in a described MRP regional number, at least one material meets described preset need, selecting the material meeting described preset need as required material, without the need to alloting material, directly gathering materials on the spot, improving MRP efficiency.

Wherein, required material is exactly the material being defined as needing in product order, and carries out follow-up alloting and producing.

104, when determining that the tank farm stock of any one material in a MRP regional number does not meet preset need, from database, the tank farm stock of the material in the 2nd MRP regional number is obtained according to a MRP regional number;

Such as, when a MRP regional number represents Guangzhou, Guangzhou belongs to south China district, then can obtain the 2nd MRP regional number in south China district, the 2nd MRP regional number can be Shenzhen and Dongguan.In addition, when a MRP regional number represents Guangdong, the 2nd MRP regional number belonging to south China district with a MRP regional number together can be Guangxi, Hainan, the definition of the geographic area for a MRP regional number and the 2nd MRP regional number and their places in the present invention can be determined according to the set-point of supplies on hand, is not specifically limited herein.

Described 2nd MRP regional number, for representing a described MRP regional number neighboringly, stores the tank farm stock of material in a described MRP regional number and described 2nd MRP regional number in described database.

105, total tank farm stock of the material in a MRP regional number and the 2nd MRP regional number is added up;

When in a described MRP regional number, the tank farm stock of any one material does not meet described preset need, add up total tank farm stock of the material in a described MRP regional number and described 2nd MRP regional number.

106, judge whether total tank farm stock of material in a MRP regional number and the 2nd MRP regional number meets preset need respectively; If so, step 107 is performed;

Because the 2nd MRP regional number is for representing a described MRP regional number neighboringly, visible, a MRP regional number and the 2nd MRP regional number Relatively centralized, allot material from the 2nd MRP regional number, also effectively can reduce and allot cost, improves MRP efficiency.

107, when determining that total tank farm stock of at least one material in a MRP regional number and the 2nd MRP regional number meets preset need, select the material meeting preset need as required material.

It should be noted that, when determining that total tank farm stock of any one material in a MRP regional number and the 2nd MRP regional number all meets preset need, then material that can be maximum using the total tank farm stock in a MRP regional number and the 2nd MRP regional number is as required material.

In the embodiment of the present invention, owing to storing the tank farm stock of material in a MRP regional number and the 2nd MRP regional number in database, first judge whether the tank farm stock of material in a MRP regional number meets preset need, when determining that in a described MRP regional number, at least one material meets described preset need, select the material meeting described preset need as required material; When determining that the tank farm stock of any one material in a described MRP regional number does not meet described preset need, from described database, obtain the tank farm stock of the material in the 2nd MRP regional number according to a described MRP regional number; Add up total tank farm stock of the material in a described MRP regional number and described 2nd MRP regional number; When determining that total tank farm stock of at least one material in a described MRP regional number and described 2nd MRP regional number meets described preset need, select the material meeting described preset need as required material.Visible, adopt nearby principle to allot material in the present invention, effectively reduce and allot cost, improve MRP efficiency.

On basis embodiment illustrated in fig. 1, refer to Fig. 2, in the embodiment of the present invention, another embodiment of MRP system of selection comprises:

201, from database, obtain the tank farm stock of material in a MRP regional number;

A described MRP regional number is for representing order production ground, and described material comprises major ingredient and substitutes material.

202, judge whether the tank farm stock of material in a MRP regional number meets preset need respectively; If so, step 203 is performed; If not, step 204 is performed.

Step 201 ~ 202 to embodiment illustrated in fig. 1 in step 101 ~ 102 similar, specifically can cf. steps 101 ~ 102.

203, when determining to only have a kind of material to meet preset need in a MRP regional number, select the material meeting preset need as required material;

In some optional embodiments, when determining that the tank farm stock of at least two kinds of materials in a described MRP regional number meets described preset need, select material that in a described MRP regional number, tank farm stock is maximum as required material.

Such as: when the tank farm stock of major ingredient in a MRP regional number and wherein a kind of alternative material meets described preset need, then compare this major ingredient and this to substitute whose tank farm stock of material large, using material maximum for tank farm stock as required material.

204, when determining that the tank farm stock of any one material in a MRP regional number does not meet preset need, from database, the tank farm stock of the material in the 2nd MRP regional number is obtained according to a MRP regional number;

Described 2nd MRP regional number, for representing a described MRP regional number neighboringly, stores a described MRP regional number in described database, the tank farm stock of material in described 2nd MRP regional number and a described MRP regional number and described 2nd MRP regional number.

205, total tank farm stock of the material in a MRP regional number and the 2nd MRP regional number is added up;

206, judge whether total tank farm stock of material in a MRP regional number and the 2nd MRP regional number meets preset need respectively; If so, step 207 is performed;

207, when determining that total tank farm stock of at least one material in a MRP regional number and the 2nd MRP regional number meets preset need, the material that in selection the one MRP regional number, tank farm stock is maximum is as required material.

Optionally, a described MRP regional number and described 2nd MRP regional number, and the corresponding respectively tank farm stock of a described MRP regional number and described 2nd MRP regional number stores in the database in the form of a list, is convenient to inquiry.

In the embodiment of the present invention, owing to storing the tank farm stock of material in a MRP regional number and the 2nd MRP regional number in database, first judge whether the tank farm stock of material in a MRP regional number meets preset need, when determining to only have a kind of material to meet preset need in a MRP regional number, select the material meeting preset need as required material; When determining that the tank farm stock of any one material in a described MRP regional number does not meet described preset need, from described database, obtain the tank farm stock of the material in the 2nd MRP regional number according to a described MRP regional number; Add up total tank farm stock of the material in a described MRP regional number and described 2nd MRP regional number; When determining that total tank farm stock of at least one material in a MRP regional number and the 2nd MRP regional number meets preset need, the material that in selection the one MRP regional number, tank farm stock is maximum is as required material.Visible, adopt nearby principle to allot material in the present invention, effectively reduce and allot cost, improve MRP efficiency.

For ease of better implementing the above-mentioned correlation technique of the embodiment of the present invention, be also provided for the relevant apparatus coordinating said method below.

Refer to Fig. 3, in the embodiment of the present invention, an embodiment of MRP selecting arrangement 300 comprises: the first acquisition module 301, judge module 302, the second acquisition module 303, and accumulation module 304 and first selects module 305.

First acquisition module 301, for obtaining the tank farm stock of material in a MRP regional number from database, a described MRP regional number is for representing order production ground, and described material comprises major ingredient and substitutes material;

Judge module 302, for judging whether the tank farm stock of material in a described MRP regional number meets preset need respectively;

Second acquisition module 303, for when determining that the tank farm stock of any one material in a described MRP regional number does not meet described preset need, from described database, the tank farm stock of the material in the 2nd MRP regional number is obtained according to a described MRP regional number, described 2nd MRP regional number is for representing a described MRP regional number neighboringly, a described MRP regional number is stored, the tank farm stock of material in described 2nd MRP regional number and a described MRP regional number and described 2nd MRP regional number in described database;

Accumulation module 304, for total tank farm stock of the material in an accumulative described MRP regional number and described 2nd MRP regional number;

First selects module 305, for when determining that total tank farm stock of at least one material in a described MRP regional number and described 2nd MRP regional number meets described preset need, selects the material meeting described preset need as required material.

In the embodiment of the present invention, owing to storing the tank farm stock of material in a MRP regional number and the 2nd MRP regional number in database, judge module first judges whether the tank farm stock of material in a MRP regional number meets preset need, when determining that the tank farm stock of any one material in a described MRP regional number does not meet described preset need, the second acquisition module obtains the tank farm stock of the material in the 2nd MRP regional number according to a described MRP regional number from described database; Accumulation module adds up total tank farm stock of the material in a described MRP regional number and described 2nd MRP regional number; When determining that total tank farm stock of at least one material in a described MRP regional number and described 2nd MRP regional number meets described preset need, first selects model choice to meet the material of described preset need as required material.Visible, adopt nearby principle to allot material in the present invention, effectively reduce and allot cost, improve MRP efficiency.

On basis embodiment illustrated in fig. 3, refer to Fig. 4 further, in the embodiment of the present invention, an embodiment of MRP selecting arrangement 400 comprises: the first acquisition module 401, judge module 402, second acquisition module 403, accumulation module 404, first selects module 405 and second to select module 406.

First acquisition module 401, for obtaining the tank farm stock of material in a MRP regional number from database, a described MRP regional number is for representing order production ground, and described material comprises major ingredient and substitutes material;

Judge module 402, for judging whether the tank farm stock of material in a described MRP regional number meets preset need respectively;

Second acquisition module 403, for when determining that the tank farm stock of any one material in a described MRP regional number does not meet described preset need, from described database, the tank farm stock of the material in the 2nd MRP regional number is obtained according to a described MRP regional number, described 2nd MRP regional number is for representing a described MRP regional number neighboringly, a described MRP regional number is stored, the tank farm stock of material in described 2nd MRP regional number and a described MRP regional number and described 2nd MRP regional number in described database;

Accumulation module 404, for total tank farm stock of the material in an accumulative described MRP regional number and described 2nd MRP regional number;

First selects module 405, specifically for when determining that total tank farm stock of at least one material in a described MRP regional number and described 2nd MRP regional number meets described preset need, select material that in a described MRP regional number, tank farm stock is maximum as required material.

Second selects module 406, for when determining that in a described MRP regional number, at least one material meets described preset need, selects the material meeting described preset need as required material.

Described second selects module 406, specifically for when determining to only have a kind of material to meet described preset need in a described MRP regional number, selects the material meeting described preset need as required material.

Optionally, described second selects module 406, specifically for when determining that the tank farm stock of at least two kinds of materials in a described MRP regional number meets described preset need, selects material that in a described MRP regional number, tank farm stock is maximum as required material.

In the embodiment of the present invention, owing to storing the tank farm stock of material in a MRP regional number and the 2nd MRP regional number in database, judge module first judges whether the tank farm stock of material in a MRP regional number meets preset need, when determining to only have a kind of material to meet preset need in a MRP regional number, second selects model choice to meet the material of preset need as required material; When determining that the tank farm stock of any one material in a described MRP regional number does not meet described preset need, the second acquisition module obtains the tank farm stock of the material in the 2nd MRP regional number according to a described MRP regional number from described database; Accumulation module adds up total tank farm stock of the material in a described MRP regional number and described 2nd MRP regional number; When determining that total tank farm stock of at least one material in a MRP regional number and the 2nd MRP regional number meets preset need, the material that in the first selection model choice the one MRP regional number, tank farm stock is maximum is as required material.Visible, adopt nearby principle to allot material in the present invention, effectively reduce and allot cost, improve MRP efficiency.

On the basis of above-described embodiment, the embodiment of the embody rule scene providing the embodiment of the present invention page to adjust below.

Store sequence information and inventory information in a database, respectively as following table:

Sequence information table:

Inventory information table:

Attribute Remarks Stock number As: stock number: M1 Stockpile number As: 10000, represent that material has the stock of 10000 MRP regional number As: SH, represents that this material has the stock of 10000 in Shanghai

Server lookup database, can obtain this sequence information and inventory information, and further, server loads the inventory data of all material M1 (major ingredient and alternative material), as following table:

Because the MRP regional number at place, production ground is GZ (Guangzhou), then first load the inventory data that GZ (Guangzhou) is corresponding, obtain following table:

The inventory data corresponding due to GZ (Guangzhou) does not meet preset need, then load the inventory data of GZ (Guangzhou) region further, that is: GZ Guangzhou factory, SZ Shenzhen factory, DG Dongguan factory is all under the jurisdiction of south China district, so load the inventory data of these three factories, obtain following table:

Identical at the total inventory in whole south China district due to alternative material 1 and alternative material 2, then relatively substitute material 1 and the tank farm stock of alternative material 2 in GZ (Guangzhou), further as following table:

Visible, substitute material 1 larger at the tank farm stock of GZ (Guangzhou) than alternative material 2 at the tank farm stock of GZ (Guangzhou), therefore select to substitute material 1 as required material, adopt nearby principle to select to meet the material of preset need generally, cost is alloted in effective minimizing, improves MRP efficiency.

Therefore, owing to storing the tank farm stock of material in a MRP regional number and the 2nd MRP regional number in database, first judge whether the tank farm stock of material in a MRP regional number meets preset need respectively, when determining that in a described MRP regional number, at least one material meets described preset need, select the material meeting described preset need as required material; When determining that the tank farm stock of any one material in a described MRP regional number does not meet described preset need, from described database, obtain the tank farm stock of the material in the 2nd MRP regional number according to a described MRP regional number; Add up total tank farm stock of the material in a described MRP regional number and described 2nd MRP regional number; When determining that total tank farm stock of at least one material in a described MRP regional number and described 2nd MRP regional number meets described preset need, select the material meeting described preset need as required material.Visible, adopt nearby principle to allot material in the present invention, effectively reduce and allot cost, improve MRP efficiency.

Those skilled in the art can be well understood to, and for convenience and simplicity of description, the system of foregoing description, the specific works process of device and unit, with reference to the corresponding process in preceding method embodiment, can not repeat them here.

In several embodiments that the application provides, should be understood that, disclosed system, apparatus and method, can realize by another way.Such as, device embodiment described above is only schematic, such as, the division of described unit, be only a kind of logic function to divide, actual can have other dividing mode when realizing, such as multiple unit or assembly can in conjunction with or another system can be integrated into, or some features can be ignored, or do not perform.Another point, shown or discussed coupling each other or direct-coupling or communication connection can be by some interfaces, and the indirect coupling of device or unit or communication connection can be electrical, machinery or other form.

The described unit illustrated as separating component or can may not be and physically separates, and the parts as unit display can be or may not be physical location, namely can be positioned at a place, or also can be distributed in multiple network element.Some or all of unit wherein can be selected according to the actual needs to realize the object of the present embodiment scheme.

In addition, each functional unit in each embodiment of the present invention can be integrated in a processing unit, also can be that the independent physics of unit exists, also can two or more unit in a unit integrated.Above-mentioned integrated unit both can adopt the form of hardware to realize, and the form of SFU software functional unit also can be adopted to realize.

If described integrated unit using the form of SFU software functional unit realize and as independently production marketing or use time, can be stored in a computer read/write memory medium.Based on such understanding, the part that technical scheme of the present invention contributes to prior art in essence in other words or all or part of of this technical scheme can embody with the form of software product, this computer software product is stored in a storage medium, comprising some instructions in order to make a computer equipment (can be personal computer, server, or the network equipment etc.) perform all or part of step of method described in each embodiment of the present invention.And aforesaid storage medium comprises: USB flash disk, portable hard drive, ROM (read-only memory) (ROM, Read-OnlyMemory), random access memory (RAM, Random Access Memory), magnetic disc or CD etc. various can be program code stored medium.

The above, above embodiment only in order to technical scheme of the present invention to be described, is not intended to limit; Although with reference to previous embodiment to invention has been detailed description, those of ordinary skill in the art is to be understood that: it still can be modified to the technical scheme described in foregoing embodiments, or carries out equivalent replacement to wherein portion of techniques feature; And these amendments or replacement, do not make the essence of appropriate technical solution depart from the spirit and scope of various embodiments of the present invention technical scheme.

Accompanying drawing explanation

Fig. 1 is an embodiment schematic diagram of MRP system of selection in the embodiment of the present invention;

Fig. 2 is another embodiment schematic diagram of MRP system of selection in the embodiment of the present invention;

Fig. 3 is an embodiment schematic diagram of MRP selecting arrangement in the embodiment of the present invention;

Fig. 4 is another embodiment schematic diagram of MRP selecting arrangement in the embodiment of the present invention.

Embodiment

Embodiments provide a kind of MRP system of selection and device, for solving in prior art the problem producing and allot in a large number, effectively reducing and alloting cost, improving MRP efficiency.

Below in conjunction with the accompanying drawing in the embodiment of the present invention, be clearly and completely described the technical scheme in the embodiment of the present invention, obviously, described embodiment is only the present invention's part embodiment, instead of whole embodiments.Based on the embodiment in the present invention, those skilled in the art, not making the every other embodiment obtained under creative work prerequisite, belong to the scope of protection of the invention.

Claims (10)

1. a MRP system of selection, is characterized in that, comprising:
From database, obtain the tank farm stock of material in a MRP regional number, a described MRP regional number is for representing order production ground, and described material comprises major ingredient and substitutes material;
Judge whether the tank farm stock of material in a described MRP regional number meets preset need respectively;
When determining that the tank farm stock of any one material in a described MRP regional number does not meet described preset need, from described database, the tank farm stock of the material in the 2nd MRP regional number is obtained according to a described MRP regional number, described 2nd MRP regional number is for representing a described MRP regional number neighboringly, a described MRP regional number is stored, the tank farm stock of material in described 2nd MRP regional number and a described MRP regional number and described 2nd MRP regional number in described database;
Add up total tank farm stock of the material in a described MRP regional number and described 2nd MRP regional number;
When determining that total tank farm stock of at least one material in a described MRP regional number and described 2nd MRP regional number meets described preset need, select the material meeting described preset need as required material.
2. method according to claim 1, is characterized in that, described judge whether the tank farm stock of material in a described MRP regional number meets preset need respectively after, also comprise:
When determining that in a described MRP regional number, at least one material meets described preset need, select the material meeting described preset need as required material.
3. method according to claim 2, is characterized in that, described when determining that in a described MRP regional number, at least one material meets described preset need, selects the material meeting described preset need to comprise as required material:
When determining to only have a kind of material to meet described preset need in a described MRP regional number, select the material meeting described preset need as required material.
4. method according to claim 2, is characterized in that, described when determining that in a described MRP regional number, at least one material meets described preset need, selects the material meeting described preset need to comprise as required material:
When determining that the tank farm stock of at least two kinds of materials in a described MRP regional number meets described preset need, select material that in a described MRP regional number, tank farm stock is maximum as required material.
5. method according to claim 1, it is characterized in that, described when determining that total tank farm stock of at least one material in a described MRP regional number and described 2nd MRP regional number meets described preset need, select the material meeting described preset need to comprise as required material:
When determining that total tank farm stock of at least one material in a described MRP regional number and described 2nd MRP regional number meets described preset need, select material that in a described MRP regional number, tank farm stock is maximum as required material.
6. a MRP selecting arrangement, is characterized in that, comprising:
First acquisition module, for obtaining the tank farm stock of material in a MRP regional number from database, a described MRP regional number is for representing order production ground, and described material comprises major ingredient and substitutes material;
Judge module, for judging whether the tank farm stock of material in a described MRP regional number meets preset need respectively;
Second acquisition module, for when determining that the tank farm stock of any one material in a described MRP regional number does not meet described preset need, from described database, the tank farm stock of the material in the 2nd MRP regional number is obtained according to a described MRP regional number, described 2nd MRP regional number is for representing a described MRP regional number neighboringly, a described MRP regional number is stored, the tank farm stock of material in described 2nd MRP regional number and a described MRP regional number and described 2nd MRP regional number in described database;
Accumulation module, for total tank farm stock of the material in an accumulative described MRP regional number and described 2nd MRP regional number;
First selects module, for when determining that total tank farm stock of at least one material in a described MRP regional number and described 2nd MRP regional number meets described preset need, selects the material meeting described preset need as required material.
7. device according to claim 6, is characterized in that, described device also comprises: second selects module;
Described second selects module, for when determining that in a described MRP regional number, at least one material meets described preset need, selects the material meeting described preset need as required material.
8. device according to claim 7, is characterized in that,
Described second selects module, specifically for when determining to only have a kind of material to meet described preset need in a described MRP regional number, selects the material meeting described preset need as required material.
9. device according to claim 7, is characterized in that,
Described second selects module, specifically for when determining that the tank farm stock of at least two kinds of materials in a described MRP regional number meets described preset need, selects material that in a described MRP regional number, tank farm stock is maximum as required material.
10. device according to claim 6, is characterized in that,
Described first selects module, specifically for when determining that total tank farm stock of at least one material in a described MRP regional number and described 2nd MRP regional number meets described preset need, select material that in a described MRP regional number, tank farm stock is maximum as required material.
CN201510276108.8A 2015-05-26 2015-05-26 MRP (Material Requirement Planning) selection method and device CN104850975A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201510276108.8A CN104850975A (en) 2015-05-26 2015-05-26 MRP (Material Requirement Planning) selection method and device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201510276108.8A CN104850975A (en) 2015-05-26 2015-05-26 MRP (Material Requirement Planning) selection method and device

Publications (1)

Publication Number Publication Date
CN104850975A true CN104850975A (en) 2015-08-19

Family

ID=53850607

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201510276108.8A CN104850975A (en) 2015-05-26 2015-05-26 MRP (Material Requirement Planning) selection method and device

Country Status (1)

Country Link
CN (1) CN104850975A (en)

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20070270990A1 (en) * 2006-05-16 2007-11-22 Kaan Kudsi Katircioglu System and process for supply management for the assembly of expensive products
CN101315685A (en) * 2007-06-01 2008-12-03 卡特彼勒公司 Process for logistics management
CN102629349A (en) * 2012-01-08 2012-08-08 山西太钢不锈钢股份有限公司 Method for allocating and transferring material between SAP system and multiple MES systems
CN104134124A (en) * 2014-07-31 2014-11-05 武钢集团昆明钢铁股份有限公司 Enterprise material management system and method
CN104463354A (en) * 2014-11-21 2015-03-25 山东航天信息有限公司 Improving method of distributed inventory dispatching

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20070270990A1 (en) * 2006-05-16 2007-11-22 Kaan Kudsi Katircioglu System and process for supply management for the assembly of expensive products
CN101315685A (en) * 2007-06-01 2008-12-03 卡特彼勒公司 Process for logistics management
CN102629349A (en) * 2012-01-08 2012-08-08 山西太钢不锈钢股份有限公司 Method for allocating and transferring material between SAP system and multiple MES systems
CN104134124A (en) * 2014-07-31 2014-11-05 武钢集团昆明钢铁股份有限公司 Enterprise material management system and method
CN104463354A (en) * 2014-11-21 2015-03-25 山东航天信息有限公司 Improving method of distributed inventory dispatching

Similar Documents

Publication Publication Date Title
Madlener et al. New ways for the integrated appraisal of national energy scenarios: the case of renewable energy use in Austria
US20100100405A1 (en) Method and Apparatus for Determining and Managing Sustainability Ratings
Pfenninger Dealing with multiple decades of hourly wind and PV time series in energy models: A comparison of methods to reduce time resolution and the planning implications of inter-annual variability
US7481367B2 (en) Assignment of markdown profiles for automated control of pricing
US7213007B2 (en) Method for forecasting using a genetic algorithm
Henn et al. Metaheuristics for order batching and sequencing in manual order picking systems
Chen et al. Modeling and performance evaluation of supply chains using batch deterministic and stochastic Petri nets
Gross et al. The effect of reducing leadtime on inventory levels-simulation analysis
Kukreja et al. A model for lumpy demand parts in a multi-location inventory system with transshipments
US8838469B2 (en) System and method for optimizing display space allocation of merchandising using regression analysis to generate space elasticity curves
Yang et al. Evaluation of robustness of supply chain information-sharing strategies using a hybrid Taguchi and multiple criteria decision-making method
Ding et al. Parallel machine scheduling under time-of-use electricity prices: New models and optimization approaches
Delarue et al. Adaptive mixed-integer programming unit commitment strategy for determining the value of forecasting
Behboodi et al. Renewable resources portfolio optimization in the presence of demand response
Bel et al. Technical and economical tools to assess customer demand response in the commercial sector
Bandyopadhyay et al. Solving a tri-objective supply chain problem with modified NSGA-II algorithm
Bukhsh et al. An integrated multiperiod OPF model with demand response and renewable generation uncertainty
Delarue et al. Enhanced priority list unit commitment method for power systems with a high share of renewables
Díaz et al. Detecting critical points in on-demand irrigation pressurized networks–a new methodology
Kher Examination of flexibility acquisition policies in dual resource constrained job shops with simultaneous worker learning and forgetting effects
TWI244020B (en) Systems and methods for capacity reservation
Hu et al. Approximate solutions for multi-location inventory systems with transshipments
Mantway et al. Multi-objective BPSO algorithm for distribution system expansion planning including distributed generation
US20150109287A1 (en) Method and system for supply chain network sensitivity analysis and presentation
Zhang et al. Green supply chain performance with cost learning and operational inefficiency effects

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
EXSB Decision made by sipo to initiate 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: 20150819