The following is a question from Operations managementProduct K is made according to the BOM graph2 A is needed per K 5 B is needed per K and 1 B is needed per A 3 C is needed per A 2 D is needed perA

MPS for Product K:

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

MRP Worksheet for Component A:

Week Gross Requirements Scheduled Receipts Projected On Hand Net Requirements Planned Order Receipt Planned Order Releases

4 200 100 100 0 0 250 5 400 250 100 50 250 250 6 0 250 100 0 0 0 7 0 250 100 0 0 0 8 200 250 50 0 250 0 9 0 250 300 0 0 0 10 0 250 350 0 0 0 11 0 250 400 0 0 0

MRP Worksheet for Component B:

Week Gross Requirements Scheduled Receipts Projected On Hand Net Requirements Planned Order Receipt Planned Order Releases

4 500 120 0 500 600 600 5 1000 600 0 400 700 700 6 0 600 400 0 0 0 7 0 600 400 0 0 0 8 500 600 300 0 600 0 9 0 600 600 0 0 0 10 0 600 600 0 0 0 11 0 600 600 0 0 0

MRP Worksheet for Component C:

Week Gross Requirements Scheduled Receipts Projected On Hand Net Requirements Planned Order Receipt Planned Order Releases

4 600 50 0 600 800 800 5 300 800 0 300 500 500 6 0 800 300 0 0 0 7 0 800 300 0 0 0 8 300 800 500 0 800 0 9 0 800 800 0 0 0 10 0 800 800 0 0 0 11 0 800 800 0 0 0

MRP Worksheet for Component D:

Week Gross Requirements Scheduled Receipts Projected On Hand Net Requirements Planned Order Receipt Planned Order Releases

4 200 100 0 200 400 400 5 400 400 0 0 0 0 6 0 400 0 0 0 0 7 0 400 0 0 0 0 8 200 400 200 0 400 0 9 0 400 400 0 0 0 10 0 400 400 0 0 0 11 0 400 400 0 0 0