How to complete this assignment on Excel?

Problem01: A firm that produces electric golf carts has just received an order for 200 carts, which must be ready for delivery at the start of the week 9 . Information concerning the product structure, lead times and quantities on hand is shown in the following table. Use this information to do each of the following: a) Construct a product structure tree. b) Develop a material requirement plan that will provide 200 golf carts by week 9 assuming lot-for-lot ordering