The following table lists the components needed to assemble an end item, lead times (in weeks), and quantities on hand. Item End L Lead Time 2 2 5 3 2 Amount on Hand 11 16 10 21 21 29 30 7 0 Direct Components L(2), C(1), K(3) B(2), 3(3) G(2), B(2) H(4), B(2) 2 N B 3 G H 3 2 Click here for the Excel Data File a. If 43 units of the end item are to be assembled, how many additional units of B are needed? (Hint You don't need to develop an MRP plan.) Additional units a. If 43 units of the end item are to be assembled, how many additional units of B are needed? (Hint You don't need to develop an MRP plan) Additional units b. An order for the end item is scheduled to be shipped at the start of week 11. What is the latest week that the order can be started and still be ready to ship on time? (Hint You don't need to develop an MRP plan.) The latest week The following table lists the components needed to assemble an end item, lead times (in weeks), and quantities on hand. Item End L Lead Time 2 2 5 3 2 Amount on Hand 11 16 10 21 21 29 30 7 0 Direct Components L(2), C(1), K(3) B(2), 3(3) G(2), B(2) H(4), B(2) 2 N B 3 G H 3 2 Click here for the Excel Data File a. If 43 units of the end item are to be assembled, how many additional units of B are needed? (Hint You don't need to develop an MRP plan.) Additional units a. If 43 units of the end item are to be assembled, how many additional units of B are needed? (Hint You don't need to develop an MRP plan) Additional units b. An order for the end item is scheduled to be shipped at the start of week 11. What is the latest week that the order can be started and still be ready to ship on time? (Hint You don't need to develop an MRP plan.) The latest week