How to make an MRP (Material Requirements Plan) + detailed EXAMPLE 

ingenioempresa...
Following on from the production planning videos, today we take a closer look at MRP. I explain how to perform material requirements planning with a detailed example.
Are you ready? Because with material requirements planning or MRP we will answer the following questions:
-What to produce or inventory
-How much to produce or inventory
-When to produce or inventory
Content:
00:08 - What is MRP or material requirements planning.
01:05 - MRP in Production Planning
02:04 - The inputs: What do we need to make an MRP?
03:02 - Material requirements plan example input data: Bill of materials, master production schedule and inventory records
19:55 - Semi-automatic template in excel to make batch by batch MRP
Note: Here it is worth clarifying that I had a mistake. There is a scheduled receipt of 5 units for week 4 and I did not take it into account in the planning. However this does not affect the result of the other elements, since "top board" is a third level element, and none of them depends on its result. Therefore, the final result is still correct.
Ingenio Empresa in networks
Facebook: goo.gl/HDLFyn
Twitter: / ingenioempresa
/ ingenioempresa