1. Eighty units of end item E are needed at the beginning of week 6. Three cases (30 units per case)

1. Eighty units of end item E are needed at the beginning of week 6. Three cases (30 units per case) of J have been ordered and one case is scheduled to arrive in week 3, one in week 4 and one in week 5. Note: J must be ordered by the case and B must be produced in multiples of 120units. There are 60 units of B and 20units of J now on hand. Lead times are 2weeks for each of E and B, and one week for J.Prepare a materials requirement plan for component JEB (2)J (3)J (4)F (2)If you can do this better in Excel, feel free to do so.MasterWeekBeg Inventory123456ScheduleQuantityE LT = 2Beg Inv123456Gross RequirementsScheduled ReceiptsProjected on handNet requirementsPlanned order receiptsPlanned order releasesB (2) LT =Beg Inv123456Gross RequirementsScheduled ReceiptsProjected on handNet requirementsPlanned order receiptsPlanned order releasesJ(4) & J (3) LT =Beg Inv123456Gross RequirementsScheduled ReceiptsProjected on handNet requirementsPlanned order receiptsPlanned order releases