Operations Management: MPS and MRP for Product K and Components A, B, C, D

This case study focuses on the production planning of Product K and its associated components A, B, C, and D. The following information is provided:

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 for Product K:
- Week 4: 100 units
- Week 5: 200 units
- Week 8: 100 units
Lead time for Product K: 1 week
Initial inventory for Product K: 0 units
Ordering Policy for Product K: Lot for Lot
Lead time for Components A, B, C, D: 1 week
Initial inventory for components:
- A: 100 units
- B: 120 units
- C: 50 units
- D: 100 units
Order Policies and Safety Stocks for Components:
- A:
  - Minimum order quantity: 250 units
  - Order policy: Lot for Lot
  - Safety stock: 50 units
- B:
  - Minimum order quantity: 600 units
  - Order policy: Lot size of 300 units
  - Safety stock: 0 units
- C:
  - Minimum order quantity: 800 units
  - Order policy: Lot for Lot
  - Safety stock: 50 units
- D:
  - Minimum order quantity: 400 units
  - Order policy: Lot size of 400 units
  - Safety stock: 0 units

1. Master Production Schedule (MPS) for Product K

| Week | MPS for Product K | |---|---| | 1 | 0 | | 2 | 0 | | 3 | 0 | | 4 | 100 | | 5 | 200 | | 6 | 0 | | 7 | 0 | | 8 | 100 |

2. Material Requirements Planning (MRP) Worksheets

2.1 MRP Worksheet for Component A:

| Week | Gross requirements | Projected on hand | Net requirements | Planned order receipt | Planned order releases | |---|---|---|---|---|---| | 1 | 0 | 100 | 0 | 0 | 0 | | 2 | 0 | 0 | 0 | 250 | 0 | | 3 | 0 | 0 | 0 | 0 | 0 | | 4 | 200 | 100 | 100 | 0 | 100 | | 5 | 500 | 0 | 500 | 250 | 500 | | 6 | 0 | 0 | 0 | 0 | 0 | | 7 | 0 | 0 | 0 | 0 | 0 | | 8 | 200 | 0 | 200 | 250 | 200 |

2.2 MRP Worksheet for Component B:

| Week | Gross requirements | Projected on hand | Net requirements | Planned order receipt | Planned order releases | |---|---|---|---|---|---| | 1 | 0 | 120 | 0 | 0 | 0 | | 2 | 0 | 120 | 0 | 0 | 0 | | 3 | 0 | 120 | 0 | 0 | 0 | | 4 | 500 | 120 | 380 | 600 | 380 | | 5 | 1000 | 520 | 480 | 600 | 480 | | 6 | 0 | 520 | 0 | 0 | 0 | | 7 | 0 | 520 | 0 | 0 | 0 | | 8 | 500 | 520 | 0 | 0 | 0 |

2.3 MRP Worksheet for Component C:

| Week | Gross requirements | Projected on hand | Net requirements | Planned order receipt | Planned order releases | |---|---|---|---|---|---| | 1 | 0 | 50 | 0 | 0 | 0 | | 2 | 0 | 0 | 0 | 800 | 0 | | 3 | 0 | 0 | 0 | 0 | 0 | | 4 | 300 | 50 | 250 | 0 | 250 | | 5 | 750 | 0 | 750 | 800 | 750 | | 6 | 0 | 0 | 0 | 0 | 0 | | 7 | 0 | 0 | 0 | 0 | 0 | | 8 | 300 | 0 | 300 | 800 | 300 |

2.4 MRP Worksheet for Component D:

| Week | Gross requirements | Projected on hand | Net requirements | Planned order receipt | Planned order releases | |---|---|---|---|---|---| | 1 | 0 | 100 | 0 | 0 | 0 | | 2 | 0 | 0 | 0 | 400 | 0 | | 3 | 0 | 0 | 0 | 0 | 0 | | 4 | 200 | 100 | 100 | 400 | 100 | | 5 | 500 | 0 | 500 | 400 | 500 | | 6 | 0 | 0 | 0 | 0 | 0 | | 7 | 0 | 0 | 0 | 0 | 0 | | 8 | 200 | 0 | 200 | 400 | 200 |

This MRP planning system ensures that sufficient materials are available to meet the production requirements of Product K. By carefully considering lead times, inventory levels, safety stocks, and order policies, this system helps to optimize production and minimize delays.

Operations Management: MPS and MRP for Product K and Components A, B, C, D