Complete the Following Table

Essay

Complete the following table. Lead time for the part is two weeks. The lot size is 100. What is the projected available at the end of week 3? When is it planned to release an order? $\begin{array}{c}\begin{array}{lll}\text {Week}\\\text {Gross Requirements}\\\text {Scheduled Receipts}\\\text {Projected Available 40}\\\text {Net Requirements}\\\text {Planned Order Receipt}\\\text {Planned Order Release} \end{array} \begin{array}{lllll}& 1 & 2 & 3 & 4 \\20 & & 65 & 35 & 25 \\& & 100 & &\\\\\\\\\\\end{array}\end{array}$