L Material Requirements Planning Assignment 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 Lot Sizing A 2 25 Lot-for-Lot 2 25 in week #3 Lot-for-Lot 1 4 50 in week #1 50 Fixed D 2 27 Lot-for-Lot E 2 15 Lot-for-Lot B 22 Item A Item B Item C (2 required) Item D Item E L L Week Master Schedule for Beg Inv 1 2 4 $ 6 9 10 Quantity Week 9 Beg Inv 1 2 3 4 $ 6 7 10 Gross requirements Scheduled receipts On hand Net requirements Planned order receipts Planned order releases Week BI Beg Iny 1 2 3 5 9 7 10 8 Gross requirements Scheduled receipts On hand Net requirements Planned order receipts Planned order releases Weck Beg. Iny 1 4 5 7 10 Gross requirements Scheduled receipts On hand Net requirements Planned order receipts Planned order releases Weck Beg Ley 1 2 3 4 9 6 10 Gross requirements Scheduled receipts Os hand Net requirements Planned order receipta Planacd order releases