Question 7 2.5 pts Given the following information, develop a material requirements plan for end item A and its components (B. C, D, AND E) using the MRP Table. 50 and 80 units of A are needed at the beginning of weeks 6 and 8, respectively. Based on the requirement plans you developed, please answer Questions through 10. Item On-Hand On-Order Lead Time Order Size A 20 I wk lot-for-lot B 2 ks 50 60 1 wk 100 D 150 200 (Week 2) 2 wks 200 E 10 lot-for-lot luk B C(2) D(3) E ED(3) E MRP worksheet to be used for this problem has been provided for you on canvas. The planned-order release for item Bis: Week 3:50 Week 3:50, Week 5: 100 Week 4: 50, Week 6: 100 Week 3:30. Week 5: 80 Week 3:30. Week 5: 60 References Mailings Review View Help Table Design Layout MRP Worksheet for Questions 6-10 1 2 3 4 5 7 6 50 9 10 8 80/ Period: Item: Gross requirements : 20 Scheduled receipts LT: Projected available 1 balance SS: 0 Net requirements Q: L4L Planned order receipts Planned order releases Item: B Gross requirements OH: 0 Scheduled receipts Projected available LT: 2 balance SS: 0 Net requirements Q: 50 Planned order receipts Planned order releases Item: Gross requirements : 60 Scheduled receipts LT: Projected available 1 balance SS: 0 Net requirements Q: 100 Planned order receipts Planned order releases Item: D Gross requirements : 150 Scheduled receipts LT: Projected available 2 balance SS: 0 Net requirements Q: 200 Planned order receipts Planned order releases Item: E Gross requirements OH: 10 Scheduled receipts LT: Projected available 1 balance SS: 0 Net requirements Q: LAL Planned order receipts Planned order releases 200