PLEASE USE EXCEL AND EXPLAIN EACH STEPS

The following table lists the component needed to assemble an end item, the manufacturing or purchase lead times (in weeks) for typical lot sizes amount on hand and the direct components of each item and, in brackets, the number of each component for each parent Item Direct components End Item Lead Time 1 3 2 L(3), C(1) B(3), J(2) G(1), B(2) L B J 3 4 G 3 a Draw the product structure tree for the End Item b. An order for 40 units of the End Item is scheduled to be shipped at the start of week 10. What is the latest week that production or purchases of the components of the order can be started and the order still be ready to ship on time? (The time-phased product structure) The following table lists the component needed to assemble an end item, the manufacturing or purchase lead times (in weeks) for typical lot sizes amount on hand and the direct components of each item and, in brackets, the number of each component for each parent Item Direct components End Item Lead Time 1 3 2 L(3), C(1) B(3), J(2) G(1), B(2) L B J 3 4 G 3 a Draw the product structure tree for the End Item b. An order for 40 units of the End Item is scheduled to be shipped at the start of week 10. What is the latest week that production or purchases of the components of the order can be started and the order still be ready to ship on time? (The time-phased product structure)