explain please

Problem 4: Determine the MRP for product X (25 pts): . X is made of subassemblies A (2) and B (1) . Sub-A is made of parts C (3) and D(2); Sub-B is made of parts D (2) and E(1) Make a product structure tree for product X. Assuming we need 95 units of X by week 10, what is the MRP schedule based on following information of on hand inventory and lead time? Compile your answers to the following questions in a single excel spreadsheet 4-1.Complete product structure tree (5 pts) 4-2. Complete the MRP template with information pertaining to all parts, subassemblies - you can either use the template here or to use the one we practiced in class or to create your own (15 pts) 4-3. What is the release time and quantity for part E? (5 pts) ON-hand Inventory and lead time information Item On-hand Lead time (weeksi 2 1 X 50 35 20 15 2 B c 3 D 30 1 E 20