The following table lists the components needed to assemble an end item, lead times $($in weeks$),$ and quantities on hand.

ItemLead TimeAmount on HandDirect ComponentsEnd$20$L$(2),$ C$(1),$ K$(3)$L$28$B$(2),$ J$(3)$C$312$G$(2),$ B$(2)$K$317$H$(4),$ B$(2)$B$232$J$327$G$35$H$30$

Click here for the Excel Data File

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.$)$

An order for the end item is scheduled to be shipped at the start of week $13.$ 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 following table lists the components needed to assemble an end item, lead times $($in weeks$),$ and quantities on hand.

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.$)$

Answer is complete but not entirely correct.

Additional units

b$.$ An order for the end item is scheduled to be shipped at the start of week $13.$ 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.$)$

Answer is complete but not entirely correct.