Definition of MRP - Material Requirement Planning - what is mrp
MRP technique (material requirement plan) is a solution relatively new to a classic problem of production: control and coordinate the materials in order to find them available when necessary, and without having the necessity of possessing an excessive inventory
To make possible this techniques are necessary the following dates:
The structure of each product, calculate its components, its materials and quantities appropriated to them. This structure gives a bill of materials known as BOM (bill of materials).
Initial stocks of the final product and every component which conforms it.
Time that is necessary since we order a product until it is obtained.
The size of the minimum pack that you can acquire for each material.
Bill Of Materials BOM
The bill of materials is a clear and precise description of the structure of the shown product.
We will see it clear with the following examples :
We are going to make a bill of material of scissors , it is composed by 3 parts :
The assembly sequence is showed with the hierarchy of the product by means of levels, therefore the level 0 is the finished product, the level 1 is the semi elaborated product and so on.
To work in a comfortably way, we should use a code for each element that conforms the final product, so we can find a representation as the following:
The Bill of materials before is defined by a list of materials of only two levels, there are bills of materials of 20 levels or even more, we have just to think in the development of the bill of the materials of a car, of a train.
Macro Excel MRP - Calculation and automatic explosion of MRP with Excel
In webandmacros you can download the macro Excel MRP, you can:
Next Chapter : MRP example
webandmacros.net 2007 - 2013