Definition of MRP - Material Requirement Planning

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.

Integrated components

Quantities

Assembly sequence

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:

Bill of materials example.

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:

	Know the application macro Excel MRP
	Download the application of macro excel MRP

Next Chapter: MRP example

	Enter your search terms Submit search form
	Web www.webandmacros.net