Materials Requirements Planning

The example table for Materials Requirements Planning is shown below:

For this learning resource, we assume the product has following Product Structure (Bill of Material):

Item 1001 
| 
| 
Item 2001 
| 
| 
Item 3001 

And following empty MRP table:

Data for Item 1001:

• Lead time = 3 weeks
• Lot size quantity = lot for lot (any amount can be ordered)
• On hand quantity = 10

Data for Item 2001:

• Lead time = 1 week
• Lot size quantity = 50
• On hand quantity = 30

Data for Item 3001:

• Lead time = 1 week
• Lot size quantity = 100
• On hand quantity = 10

The MRP takes the following inputs:

• Forecast - gross requirements for the product
• Lead time - the time needed for the parts to arrive
• Lot size quantity - only multiples of this quantity can be ordered
• On hand quantity - quantity currently held in stock
• Scheduled receipts - quantity of part still due to arrive (can be counted as 'on hand')

To create Master Production Schedule, we need to know the gross requirements for each week (these are taken from the forecast). Then by using Netting, Backscheduling and Exploding, we find out the net requirements and we create Planned Order Receipts.

The MRP contains tables (similar to the one above) for each item from the Bill of Material. The forecast for the top item (the product) is filled into the gross requirements section for Item 1001.

Netting

Netting creates a planned order receipt for the net requirements. It's calculated by combining quantity on hand with scheduled receipts less gross requirements. The output of this calculation is projected available. Depending on projected available, planned order is created.

• If the projected available > 0
• or if the projected available = 0

Then no net requirements exists.

• If the projected available < 0

Then there is a need to plan for replenishment.

Assuming that there is schedule receipt for 20 parts due to arrive in week 3, we calculate the net requirements for all weeks.

As we can see, Planned Order Receipts are the same as the Net Requirements. This is because we plan to cover the requirements. '0' results are omitted for the clear view.

Backscheduling

Backscheduling is done when there are planned order receipts from the previous Netting Calculation. Based on Lead Time for the item and the planned order receipt - the Planned Order Release is created. As we can see from the Item 1001 data above - the lead time = 3 weeks. This makes the system to release orders 3 weeks earlier than it is required. (Requirements for 30 in week 5 - released in week 2).

Exploding

When the backscheduling is done, the exploding is executed. Exploding process takes a Planned Order at particular level n and explode it using the Bill of Material giving the Gross Requirements for the level n+1 (level below). Resulting output is a set of Gross Requirements for the next item. This is used for the netting of that item. Exploding moves down through the Product Structure level-by-level starting from the Product Level to the Raw Material level. The following table represents this.

The Gross Requirements for the Item 2001 are in bold (as well as where they come from in Item 1001).
The next step is to do Netting for the Item 2001, after which we do backscheduling and new explosion which gives us Item 3001 and so on, always taking the relevant data for the item into consideration (lead times, qty on hand and lot size). Complete MPS will look like the following:

See Also

• MPS - Master Production Schedule
• Bill of Material