please solve this Distribution requirement planning problem. please use appropriate methods or formulas

MRP 1. Gross requirements of a product for the next 5 periods are as follows: Periods: 1 2 3 4 5 Gross Reqt.: 30 20 20 0 45 A receipt of 50 units was scheduled in period 1. Inventory on hand is 10 units. The lead time is 2 periods on an average and the production is done only in lots of 50. Make an MRP plan. b. If the following are the transactions after period 1, revise your MRP plan for the next 5 periods. Actual disbursements from stock for item 1234 during week 1 were only 20 instead of the planned 30. The scheduled receipt for 50 due in week 1 was received on Tuesday, but 10 units were rejected, so only 40 were actually received into inventory. The inventory was counted on Thursday and 20 additional pieces were found. The requirement date for the 45 pieces in week 5 was changed to week 4. Marketing requested an additional five pieces for samples in week 2. The requirement for week 6 has been set at 25. MRP 1. Gross requirements of a product for the next 5 periods are as follows: Periods 1 2 3 4 5 Gross Reqt: 30 20 20 0 45 A receipt of 50 units was scheduled in period 1. Inventory on hand is 10 units. The lead time is 2 periods on an average and the production is done only in lots of 50. Make an MRP plan. b. If the following are the transactions after period 1, revise your MRP plan for the next 5 periods Actual disbursements from stock for item 1234 during week 1 were only 20 instead of the planned 30. The scheduled receipt for 50 due in week 1 was received on Tuesday, but 10 units were rejected, so only 40 were actually received into inventory The inventory was counted on Thursday and 20 additional pieces were found. The requirement date for the 45 pieces in week 5 was changed to week 4 Marketing requested an additional five pieces for samples in week 2. The requirement for week 6 has been set at 25