Show all your work $($typed in the document or pasting a scanned image of your handwritten solution$).$ Save your solution document in a $.$pdf file and upload it to Canvas along with an Excel file for calculations performed in Excel.

Problem $1(10$ points$)$

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

a$.$ If $22$ units of the end item are to be assembled, how many additional units of E are needed? $($Hint$.$ You don't need to develop an MRP plan to determine this.$)$

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