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

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 | 100 | | | | | | | | | Week 4 | Week 3 | | | | 100 | | | | | | Week 5 | Week 4 | | 200 | | | 100 | | | | | Week 8 | Week 7 | | | | | | | 100 | |

MRP Worksheet for Component A:

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

MRP Worksheet for Component B:

| Week | Gross Requirements | Projected On Hand | Net Requirements | Planned Order Receipt | Planned Order Release | |------------|--------------------|-------------------|------------------|-----------------------|-----------------------| | Week 1 | | 120 | | | | | Week 2 | 400 | 120 | 280 | 600 | 600 | | Week 3 | | 420 | | | | | Week 4 | 1000 | 420 | 580 | 600 | 600 | | Week 5 | | 920 | | | | | Week 6 | 2500 | 920 | 1580 | 1200 | 1200 | | Week 7 | | 1720 | | | | | Week 8 | 1000 | 1720 | 280 | | 1200 |

MRP Worksheet for Component C:

| Week | Gross Requirements | Projected On Hand | Net Requirements | Planned Order Receipt | Planned Order Release | |------------|--------------------|-------------------|------------------|-----------------------|-----------------------| | Week 1 | | 50 | | | | | Week 2 | 300 | 50 | 250 | 800 | 800 | | Week 3 | | 550 | | | | | Week 4 | 300 | 550 | | | | | Week 5 | | 550 | | | | | Week 6 | 900 | 550 | 350 | 800 | 800 | | Week 7 | | 800 | | | | | Week 8 | 300 | 800 | | | |

MRP Worksheet for Component D:

| Week | Gross Requirements | Projected On Hand | Net Requirements | Planned Order Receipt | Planned Order Release | |------------|--------------------|-------------------|------------------|-----------------------|-----------------------| | Week 1 | | 100 | | | | | Week 2 | 500 | 100 | 400 | 800 | 800 | | Week 3 | | 500 | | | | | Week 4 | 200 | 500 | | | | | Week 5 | | 500 | | | | | Week 6 | 600 | 500 | 100 | 800 | 800 | | Week 7 | | 700 | | | | | Week 8 | 400 | 700 | | | |