The BOM for two finished products (D and E), inventory status, and other relevant information follow. We want to compute the Planned Order Releases for products D, E, and F. Please note that product F is a component of both D and E. Please determine the value of each of the following 8 values in the 3 tables below: Y, Z, P, Q, R, U, V, and W.

Please Note: Please TYPE each answer in the proper cell in the tables below (e.g., M = 57there is no product M in the tablesits just an example here). You do NOT need to explain how you get these values. For a value of zero, please write 0 (do not leave it empty). You can fill the rest of the other values in the tablesbut they will not be graded (only the 8 values are graded). There is NO partial credits for any mistake (i.e., each answer is either right or wrong).

D E A (3) F (2) C (2) A (2) B (3) F (2) 2 21 3 9 4 5 5 8 6 6 Q = 30; LT = 1; SS = 0; BI=10 Part D Gross Requirements Scheduled Receipts Projected On-hand Inventory Net Requirement Planned Order Releases 0 0 0 0 10 0 Y= Z= Q=LFL;LT = 2; SS = 3; BI=15 Part E Gross Requirements Scheduled Receipts Projected On-hand Inventory Net Requirement Planned Order Releases 10 0 2 12 11 P= 3 15 0 4 11 0 Q= 5 6 0 6 8 10 R= 4 Q = 30; LT = 1; SS = 0; BI=30 Part F Gross Requirements Scheduled Receipts Projected On-hand Inventory Net Requirement Planned Order Releases U= 60 V= 0 0 0 0 10 W