The following table shows the Master Production Schedule (MPS) for end Products X, Y, and Z:

The Bill of Materials (BOM) of each product is as follows:

The following table shows the inventory record data for each component:

Determine the Materials Requirement Plan (MRP) for each item.

Transcribed Image Text:

Product X Y Z 1 2 3 Week 4 80 5 60 6 125 7 55 8 A (2) X B (1) c (2) A (1) Y B (2) c (2) A (2) Z B (2) C (2) A 3 weeks Lot-for-Lot 0 On-hand Inventory 150 Scheduled Receipts 150 (week 3) Lead Time Lot-sizing Rule Safety Stock Item B 1 week Lot-for-Lot 0 0 120 (week 2) с 2 weeks Lot-for-Lot 30 100 None Product X Y Z 1 2 3 Week 4 80 5 60 6 125 7 55 8 A (2) X B (1) c (2) A (1) Y B (2) c (2) A (2) Z B (2) C (2) A 3 weeks Lot-for-Lot 0 On-hand Inventory 150 Scheduled Receipts 150 (week 3) Lead Time Lot-sizing Rule Safety Stock Item B 1 week Lot-for-Lot 0 0 120 (week 2) с 2 weeks Lot-for-Lot 30 100 None