Operations Management: Material Requirements Planning (MRP) for Product K and its Components

This document details the Material Requirements Planning (MRP) process for a product called 'Product K' and its four components, 'A', 'B', 'C', and 'D'. The objective is to determine the production schedule for each item given the demand for Product K, their respective lead times, and inventory levels.

Bill of Materials (BOM)

The BOM for Product K specifies the quantity of each component needed for its production:

Product K:
- 2 units of component 'A'
- 5 units of component 'B'
- 1 unit of component 'B' is needed for every unit of component 'A'
- 3 units of component 'C' are needed for every unit of component 'A'
- 2 units of component 'D' are needed for every unit of component 'A'

Demand for Product K

The following demand schedule for Product K is given:

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

Lead Times and Inventory

Product K: Lead time is 1 week. There is no initial inventory.
Component A: Lead time is 1 week. Initial inventory is 100 units. Minimum order quantity is 250 units. Lot-for-Lot ordering is used. Safety stock is 50 units.
Component B: Lead time is 1 week. Initial inventory is 120 units. Minimum order quantity is 600 units. Lot size is 300 units. Safety stock is 0 units.
Component C: Lead time is 1 week. Initial inventory is 50 units. Minimum order quantity is 800 units. Lot-for-Lot ordering is used. Safety stock is 50 units.
Component D: Lead time is 1 week. Initial inventory is 100 units. Minimum order quantity is 400 units. Lot size is 400 units. Safety stock is 0 units.

Master Production Schedule (MPS) for Product K

The MPS for Product K is as follows:

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

Material Requirements Planning (MRP) Worksheets

MRP Worksheet for Component A

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

MRP Worksheet for Component B

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

MRP Worksheet for Component C

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

MRP Worksheet for Component D

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

Explanation

The MRP worksheets are calculated based on the following steps:

Gross Requirements: This represents the demand for the component in each week based on the MPS for Product K and the BOM. For example, in week 4, the gross requirement for component A is 200 units (2 units per K * 100 units of K required).
Scheduled Receipt: This represents the amount of the component expected to be received in each week from prior planned orders.
Projected On Hand: This represents the estimated amount of the component on hand at the beginning of each week, taking into account the initial inventory and the scheduled receipts and the gross requirements.
Net Requirements: This is the actual amount of the component required in each week, calculated as Gross Requirements minus Projected On Hand.
Planned Order Receipt: This represents the amount of the component planned to be received in each week, considering the lead time, minimum order quantity, lot sizing rule, and the safety stock. For example, component A has a lead time of 1 week, so the planned order receipt for week 4 is planned to arrive in week 3. The lot-for-lot ordering rule is applied, so the planned order receipt is equal to the net requirements. The minimum order quantity is also considered. For instance, in week 1, the planned order receipt for A is 150 units (because the net requirement is -100 and the minimum order quantity is 250).
Planned Order Releases: This represents the amount of the component planned to be ordered in each week, taking into account the lead time. For example, component A has a lead time of 1 week, so the planned order release for week 4 is made in week 3. The planned order releases are shifted one week earlier than the planned order receipts.

This detailed MRP calculation allows for efficient planning and management of the production process, ensuring that the required materials are available when needed, while also minimizing inventory costs.