Q1. Given the following Bill of materials, Master schedule & inventory status file, Master Production Schedule for A and B Week 1 2 3 4 5 6 7 8
Gross Requirement A 0 0 0 0 0 0 0 100
Gross Requirement B 0 0 0 0 0 200 0 0

Item Lead Time (Weeks) On-Hand Inventory Scheduled Receipts Lot Size
A 3 10 0 1
B 2 5 0 1
C 4 140 0 150
D 2 200 250, period 2 250

It is further given that product A requires three C’s and two D’s. Each B requires three D’s.
Required:
1. Prepare a product tree/ bill of materials.
2. Develop a Material requirement plan (MRP) for items A, B, C and D.