Exercise for Week 5: Complete the tables for items C, D and E * Each unit of A is composed of 1 unit of B, 2 units of C, 1 unit of D * C is composed of 2 units of D, 3 units of E * Items A, C, D, and E have on-hand inventories of 20, 10, 20, and 10 units, respectively Item B has a scheduled receipt of 10 units in period 1 Develop a material requirements plan. Period 1 2 3 4 5 6 7 8 9 Item: Gross Requirements A 30 30 40 Scheduled receipts LT= 1 Projected on hand 20 20 20 0 0 0 0 0 0 0 Net requirements 10 30 40 Q= Planned order receipts 10 30 40 L4L Planned order releases 10 30 40Period 1 2 3 4 5 6 7 8 9 Item: Gross Requirements B 10 30 40 Scheduled receipts 10 LT=1 Projected on hand Net requirements 0 0 0 30 0 0 40 Q= Planned order receipts 30 40 L4L Planned order releases 30 40 Period 1 2 3 4 5 6 7 8 9 Item: Gross Requirements C 20 60 80 Scheduled receipts LT= 1 Projected on hand Net requirements Q= Planned order receipts min of Planned order releases 50Period 1 2 3 4 5 6 7 8 9 Item: D Gross Requirements Scheduled receipts LT= 2 Projected on hand Net requirements Q= Planned order receipts multiples Planned order of 100 releases Period 1 2 3 4 5 6 7 8 9 Item: E Gross Requirements Scheduled receipts LT= 2 Projected on hand Net requirements Q= Planned order receipts multiples |Planned order of 50 releases