MRP Worksheet for Product K, A, B, C, and D (8 Weeks)

MRP Worksheet for Product K:

BOM Graph:

• 2 A per K
• 5 B per K
• 1 B per A
• 3 C per A
• 2 D per A

Product K Details:

• Lead Time: 1 week
• On-hand inventory: 0 units
• Lot sizing method: Lot for Lot

Demand:

• Week 4: 100 units
• Week 5: 200 units
• Week 8: 100 units

| Week | Gross Requirements | Scheduled Receipt | Projected On Hand | Net Requirements | Planned Order Receipt | Planned Order Releases | |---|---|---|---|---|---|---| | 4 | 100 | | | 100 | 100 | | | 5 | 200 | 100 | | 100 | 100 | | | 6 | | 200 | | 100 | 100 | | | 7 | | | 100 | | | 100 | | 8 | 100 | 100 | | | | 100 |

MRP Worksheet for Component A:

Component A Details:

• Lead Time: 1 week
• On-hand inventory: 100 units
• Minimum Order: 250 units
• Lot sizing method: Lot for Lot
• Safety Stock: 50 units

| Week | Gross Requirements | Scheduled Receipt | Projected On Hand | Net Requirements | Planned Order Receipt | Planned Order Releases | |---|---|---|---|---|---|---| | 4 | 200 | | 100 | 100 | 250 | | | 5 | 400 | 250 | 100 | 150 | 250 | | | 6 | | 400 | 300 | 100 | 250 | | | 7 | | | 550 | | | | | 8 | 100 | 550 | 800 | | | 250 |

MRP Worksheet for Component B:

Component B Details:

• Lead Time: 1 week
• On-hand inventory: 120 units
• Minimum Order: 600 units
• Lot sizing method: Lot size by 300 units
• Safety Stock: 0 units

| Week | Gross Requirements | Scheduled Receipt | Projected On Hand | Net Requirements | Planned Order Receipt | Planned Order Releases | |---|---|---|---|---|---|---| | 4 | 500 | | 120 | 380 | 600 | | | 5 | 1000 | 600 | 420 | 580 | 900 | | | 6 | | 900 | 720 | 280 | 900 | | | 7 | | | 1020 | | | | | 8 | 500 | 1020 | 720 | | | 500 |

MRP Worksheet for Component C:

Component C Details:

• Lead Time: 1 week
• On-hand inventory: 50 units
• Minimum Order: 800 units
• Lot sizing method: Lot for Lot
• Safety Stock: 50 units

| Week | Gross Requirements | Scheduled Receipt | Projected On Hand | Net Requirements | Planned Order Receipt | Planned Order Releases | |---|---|---|---|---|---|---| | 4 | 300 | | 50 | 250 | 800 | | | 5 | 750 | 800 | 50 | 700 | 800 | | | 6 | | 750 | 50 | 700 | 800 | | | 7 | | | 750 | | | | | 8 | 150 | 750 | 1000 | | | 150 |

MRP Worksheet for Component D:

Component D Details:

• Lead Time: 1 week
• On-hand inventory: 100 units
• Minimum Order: 400 units
• Lot sizing method: Lot size by 400 units
• Safety Stock: 0 units

| Week | Gross Requirements | Scheduled Receipt | Projected On Hand | Net Requirements | Planned Order Receipt | Planned Order Releases | |---|---|---|---|---|---|---| | 4 | 200 | | 100 | 100 | 400 | | | 5 | 400 | 400 | 100 | 300 | 400 | | | 6 | | 400 | 100 | 300 | 400 | | | 7 | | | 400 | | | | | 8 | 200 | 400 | 600 | | | 200 |