Please solve the following problem in excel.

Problem$02$

A firm that produces electric golf carts has just received an order for $220$ carts, which must be ready for delivery at the start of 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 $220$ golf carts by week $9$ assuming lot$-$for$-$lot ordering.