Material Requirements Planning Assignment 6 The following table lists the components needed to assemble an end item, lead times (in weeks), quantities on hand, and scheduled receipts. Compete an MRP schedules sufficient to produce Item A in quantities of 20 in week two, 10 in week four, 20 in week six, 5 in week seven, 35 in week nine, and 10 in week ten. Assume all components can be ordered on a lot-for-lot basis except Item C, which has a fixed lot size of 50 (can be ordered in multiples of 50 if needed) item Lead Time Amount on Hand Scheduled Receipts 25 A 2 Lot Sizing Lot-for-Lot Lot-for-Lot B 2 22 25 in week #3 1 4 50 in week #1 50 Fixed D 27 Lot-for-Lot NN 15 Lot-for-Lot Item A Item B Item C Item D (2 required) Item e Week Beg lay Master Schedule for 1 2 3 3 4 5 5 9 7 10 S Quantity Week Beg Ins 1 2 3 4 5 6 6 9 7 7 10 8 Gross requirements Scheduled receipts On hand Net requirements Planned order receipts Planned ordet releases Week Beg Iny 1 2 3 3 4 s 9 7 10 Gross requirements Scheduled receipts On hand Net requirements Planned order receipts Planned order releases Week Beg 1 2 9 3 10 Iny 5 6 7 8 Gross requirements Scheduled receipts On hand Net requirements Planned order receipts Planned order releases Wook Bez 9 1 TO 3 2 3 4 5 2 Gross requirements Scheduled receipt On hand Net requirements Planned order receipts Planned order releases silabler lun 3, 2021 12:00am until Jun 10, 2021 11:59pm - Details Please upon the following material requirements planning (MRP assignment and complete the MRP schedules for each of the items that make Item/Product A Please note the requirements for Item A for each of the wecks, along with the lead times on hand scheduled receipts and lot sizin requirement tilank MRP schedule is included for your convenience. Each schedule is worth 2 points