using this sheet with the giving requrment in the qustions

A company produces the XYZ products with part? (Y)and (Z) shown in the product structure tree below. 200 units of XYZ products are demanded at the beginning of week 5 , and 100 units are needed at the beginning of week 8. Lot-for-lot ordering is used for XYZ. Lot-size for X is 25 units and Y is 40 units. There are 45 units of item XYZ,50 units of X and 30 units of Y now on hand. Lead times for XYZ is 1 week, part X is 2 weeks, part Y is 1 weeks. The scheduled receipts are as follows: (30 XYZ and 20X in week 2 , and 25Y in week 4 . As an operation manager, develop material requiraments olan for XYZ, X and Y, Part Z is supposed to be available based on just-in-time production. MRP PLAN SHEET