Click here for the Excel Data File a. If 20 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 15 . 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.) \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F & G & H & 1 \\ \hline 1 & Item & End & B & C & D & E & F & G & H \\ \hline 2 & LT (wk) & 1 & 3 & 4 & 4 & 2 & 1 & 2 & 1 \\ \hline 3 & Amount on hand & 0 & 10 & 9 & 25 & 11 & 29 & 6 & 0 \\ \hline \end{tabular}