3. Item Y is made up of (1) unit of Item B, (3) units of Item C, and (2) units of Item D. Item C is made up of (3) units of Item D and (2) units of Item E. Inventory information for all items are as follows: Item Y: 0 on hand, Order sizing is Lot-for-lot,lead time is 1 period. Item B: 30 units on hand. Order sizing is Lot-for-Lot. Lead time = 1 period. Item C: 0 on hand presently, expecting receipt of (20) units in Period 1. Order sizing is Lot- for-Lot. Lead time = 1 period. Item D: 10 units on hand. Expecting receipt of (300) units in Period 1. Order sizing - must buy in quantities of (300) units. Lead time = 2 periods. Item E: 20 units on hand. Expecting receipt of (200) units in Period 1. Order sizing - must buy in qtys of 100 units. Lead time = 2 periods. The gross requirements for Item Y are (40) in Period 4, (50) in Period 6, and (60) in Period 8. A. Create the Product Tree for Item Y. (14 pts) B. Create the "MRP" - planned releases table for all items. Best created in Excel - submit your Excel file. (60 pts) -