Use the product structure tree and information shown below: E B(3) C2) D(2) 1(2) S(2) D(2) Ninety-five units of end item E are needed at the beginning of week 7. Take into account that on hand there are 5 units of E, 50 units of B, 100 units of C, and 80 units of D. Also, 30 units of Chave been outsourced and are expected to arrive in Week 4. Lead times are two weeks for E and C, and one week for the other components. Lot-for-lot ordering will be used for all items. You are to prepare a material requirements plan for Item D. For Item D, identify how much is needed for each week. . If no quantities are needed in a particular week, write 0. . You should use the MRP Template and complete this problem. Data Entry Table for Quantities of Planned-Order Releases Start of Week How Much 1 2 3 4 5 6 7 8 Alternative Text for Figure The diagram shows the following with three levels: The top level is the final assembly E. The middle level consists of two items: B and C. The diagram shows three Bs are needed for each E and it shows that two Cs are needed for each E. E is the parent of both B and C, and similarly B and C are the children of E; connector lines show that relationship. The bottom level consists of three items shown in four locations: D, 1, S and again D. The diagram shows two Ds are needed for each B and it shows that two I's are needed for each B, and it shows that two Ss are needed for each C, and it shows that two Ds are needed for each C. B is the parent of both D and I, and similarly D and I are the children of B; connector lines show that relationship. C is the parent of both S and D, and similarly S and D are the children of C: connector lines show that relationship. Alternative Text for Data-Entry Table for Item D The table has two columns. The first column is labeled "Start of Week". The second column is labeled "How Much"; (it is looking for the Quantities of Planned-Order Releases. Each row lists the Week Number (in the first column) and expects values to be entered for the How Much quantity (in the second column) for Weeks 1, 2, 3, 4, 5, 6, 7, and 8