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 OH: 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 Question 6 2. 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 6 through 10. Item On-Hand On-Order Lead Time Order Size 20 I wk lot-for-lot B 2 wks 50 60 1 wk 100 150 200 (Week 2) 200 E 10 1 wk lot-for-lot D 2 wks B C(2) D(3) E E D(3) E Day MRP Worksheet for Question - 10 Comments LT 1 SS: 0 Q14L Projected available balance Net requirements Planned order receipts Planned order releases e 3 Type here to search OR MRP worksheet to be used for this problem has been provided for you on canvas. The planned-order release for product A is: Week 5:30, Week 7: 80 Week 6:30, Week 8: 80 Week 5:30 Week 6: 50, Week 8: 80 Week 5: 50, Week 7: 80