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

This case study focuses on Product K and its components A, B, C, and D, demonstrating the application of Material Requirements Planning (MRP) and Master Production Schedule (MPS). We'll examine how to plan production and manage inventory effectively using different ordering policies and lead times.

Product K's BOM (Bill of Materials) Structure:

• 2 units of A are needed for 1 unit of K.
• 5 units of B are needed for 1 unit of K.
• 1 unit of B is needed for 1 unit of A.
• 3 units of C are needed for 1 unit of A.
• 2 units of D are needed for 1 unit of A.

Demand for Product K:

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

Lead Times:

• Product K: 1 week
• Components A, B, C, D: 1 week

Inventory:

• Product K: No inventory on hand.
• Component A: 100 units on hand.
• Component B: 120 units on hand.
• Component C: 50 units on hand.
• Component D: 100 units on hand.

Ordering Policies:

• Product K: Lot for Lot
• Component A: Lot for Lot, Minimum Order Quantity: 250 units, Safety Stock: 50 units.
• Component B: Lot Size of 300 units, Minimum Order Quantity: 600 units, Safety Stock: 0 units.
• Component C: Lot for Lot, Minimum Order Quantity: 800 units, Safety Stock: 50 units.
• Component D: Lot Size of 400 units, Minimum Order Quantity: 400 units, Safety Stock: 0 units.

MPS Worksheet for Product K:

| Required Date | Order Release Date | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | |---------------|--------------------|--------|--------|--------|--------|--------|--------|--------|--------| | Week 1 | Week 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | Week 2 | Week 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | Week 3 | Week 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | Week 4 | Week 5 | 100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | Week 5 | Week 6 | 0 | 200 | 0 | 0 | 0 | 0 | 0 | 0 | | Week 6 | Week 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | Week 7 | Week 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 100 | | Week 8 | - | 0 | 0 | 0 | 100 | 200 | 0 | 0 | 0 |

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 | 100 | 0 | 0 | 0 | | 3 | 0 | 100 | 0 | 0 | 0 | | 4 | 200 | 0 | 200 | 250 | 0 | | 5 | 500 | 50 | 450 | 500 | 0 | | 6 | 0 | 0 | 0 | 250 | 0 | | 7 | 0 | 100 | 0 | 0 | 0 | | 8 | 200 | 0 | 200 | 250 | 0 |

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 | 0 | 500 | 600 | 0 | | 5 | 1250 | 0 | 1250 | 1200 | 0 | | 6 | 0 | 0 | 0 | 600 | 0 | | 7 | 0 | 120 | 0 | 0 | 0 | | 8 | 500 | 0 | 500 | 600 | 0 |

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 | 50 | 0 | 0 | 0 | | 3 | 0 | 50 | 0 | 0 | 0 | | 4 | 300 | 0 | 300 | 800 | 0 | | 5 | 1500 | 0 | 1500 | 800 | 0 | | 6 | 0 | 0 | 0 | 800 | 0 | | 7 | 0 | 50 | 0 | 0 | 0 | | 8 | 300 | 0 | 300 | 800 | 0 |

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 | 100 | 0 | 0 | 0 | | 3 | 0 | 100 | 0 | 0 | 0 | | 4 | 200 | 0 | 200 | 400 | 0 | | 5 | 400 | 0 | 400 | 400 | 0 | | 6 | 0 | 0 | 0 | 400 | 0 | | 7 | 0 | 100 | 0 | 0 | 0 | | 8 | 200 | 0 | 200 | 400 | 0 |

This detailed analysis allows us to understand the material requirements and production scheduling for Product K and its components. We can see how the different ordering policies and lead times affect the planning process and ensure the timely availability of materials to meet demand.