Operations Management: MRP and MPS for Product K and its Components

This document details the Material Requirements Planning (MRP) and Master Production Schedule (MPS) for Product K and its four components, A, B, C, and D. Here's the breakdown:

Product K:

• Bill of Materials (BOM):
  • 2 units of A are needed per K.
  • 5 units of B are needed per K.
  • 1 unit of B is needed per A.
  • 3 units of C are needed per A.
  • 2 units of D are needed per A.
• Demand:
  • Week 4: 100 units
  • Week 5: 200 units
  • Week 8: 100 units
• Lead Time: 1 week
• Inventory: None on hand
• Ordering Policy: Lot for Lot

Components:

• Component A:
  • Lead Time: 1 week
  • Inventory: 100 units
  • Minimum Order: 250 units
  • Ordering Policy: Lot for Lot
  • Safety Stock: 50 units
• Component B:
  • Lead Time: 1 week
  • Inventory: 120 units
  • Minimum Order: 600 units
  • Ordering Policy: Lot size by 300 units
  • Safety Stock: 0 units
• Component C:
  • Lead Time: 1 week
  • Inventory: 50 units
  • Minimum Order: 800 units
  • Ordering Policy: Lot for Lot
  • Safety Stock: 50 units
• Component D:
  • Lead Time: 1 week
  • Inventory: 100 units
  • Minimum Order: 400 units
  • Ordering Policy: Lot size by 400 units
  • Safety Stock: 0 units

MPS for Product K:

| Week | MPS (units) | |------|--------------| | 4 | 100 | | 5 | 200 | | 6 | 0 | | 7 | 0 | | 8 | 100 |

MRP Worksheet for Component A:

| Week | Gross Requirements | Scheduled Receipt | Projected On Hand | Net Requirements | Planned Order Receipt | Planned Order Releases | |------|--------------------|--------------------|-------------------|-----------------|-----------------------|------------------------| | 1 | | | 100 | | | | | 2 | | | 100 | | | | | 3 | | | 100 | | | | | 4 | 200 | | 100 | 100 | 250 | 250 | | 5 | 500 | 250 | 100 | 150 | 400 | | | 6 | 450 | 250 | | 200 | 450 | | | 7 | 150 | 250 | | | | | | 8 | 100 | 250 | | | | |

MRP Worksheet for Component B:

| Week | Gross Requirements | Scheduled Receipt | Projected On Hand | Net Requirements | Planned Order Receipt | Planned Order Releases | |------|--------------------|--------------------|-------------------|-----------------|-----------------------|------------------------| | 1 | | | 120 | | | | | 2 | | | 120 | | | | | 3 | | | 120 | | | | | 4 | 500 | | 120 | 380 | 600 | 600 | | 5 | 1000 | 600 | 520 | 480 | 900 | | | 6 | 950 | 600 | | 350 | 900 | | | 7 | 350 | 600 | | | | | | 8 | 200 | 600 | | | | |

MRP Worksheet for Component C:

| Week | Gross Requirements | Scheduled Receipt | Projected On Hand | Net Requirements | Planned Order Receipt | Planned Order Releases | |------|--------------------|--------------------|-------------------|-----------------|-----------------------|------------------------| | 1 | | | 50 | | | | | 2 | | | 50 | | | | | 3 | | | 50 | | | | | 4 | 300 | | 50 | 250 | 800 | 800 | | 5 | 750 | 800 | 0 | 750 | 800 | | | 6 | 450 | 800 | | 450 | 800 | | | 7 | 150 | 800 | | | | | | 8 | 50 | 800 | | | | |

MRP Worksheet for Component D:

| Week | Gross Requirements | Scheduled Receipt | Projected On Hand | Net Requirements | Planned Order Receipt | Planned Order Releases | |------|--------------------|--------------------|-------------------|-----------------|-----------------------|------------------------| | 1 | | | 100 | | | | | 2 | | | 100 | | | | | 3 | | | 100 | | | | | 4 | 200 | | 100 | 100 | 400 | 400 | | 5 | 500 | 400 | 100 | 0 | | | | 6 | 0 | 400 | 100 | 100 | 400 | | | 7 | 0 | 400 | 100 | | | | | 8 | 0 | 400 | 100 | | | |

This document provides a comprehensive overview of the MRP and MPS for Product K and its components, offering insights into demand planning, inventory management, and production scheduling. It can be used as a reference for decision-making related to production planning and inventory control.