Hello, can you help me with this one? Please explain it to me as well. This is MRP question from Operations Management. This is tough. You can provide excel sheet too and that will be great. But explanation of the process is a must. Thank you so much!

5. Product P is composed of three subassemblies: K, L, and W. Subassembly K is assembled using 3 Gs and 4 Hs; L is made of 2 Ms and 2 Ns, and W is made of 3 Zs. On-hand inventories are 40 Gs, and 200 Hs. Scheduled receipts are 10 ks at the start of week 3 and 30 Ks at the start of week 6. (LO2 & 3) One hundred Ps must be shipped at the start of week 6, and another 100 at the start of week 7. Manufacturing lead times are two weeks for subassemblies and purchase lead times are one week for the components. Final assembly of P requires one week for 100 units. Include an extra 10- percent scrap allowance in each planned order of G. The minimum order size for H is 200 units. For other items, use lot-for-lot ordering. Develop each of the following: a. The product structure tree. b. The material requirements plan for P, K, G, and H