Math Problem 1-Materials Requirements Planning Use the following information to complete the MRP tables for items...

Transcribed Image Text:

Math Problem 1-Materials Requirements Planning Use the following information to complete the MRP tables for items B & C. Show your answers in the tables. (There is an extra MRP table.) B(2) A D (4) E (3) D (4) ABC B (1) F (3) E (3) On-Hand Sch. Receipts 15 150 0 Lot Size LFL Lead Time Safety Stock 120 in period 1 140 in period 2 FOQ=80 EOQ=100 122 0 20 10 0 Item: A Description: MPS Period Gross Requirements Scheduled Receipts On Hand 15 Net Requirements Planned Order Receipts Planned Order Releases Item: Description: Period Gross Requirements Scheduled Receipts On Hand Net Requirements Planned Order Receipts Planned Order Releases Item: Description: Period Gross Requirements Scheduled Receipts On Hand Net Requirements Planned Order Receipts Planned Order Releases Item: Description: Period Gross Requirements Scheduled Receipts On Hand Net Requirements Planned Order Receipts Planned Order Releases Safety Stock=0 Lot Size =LFL Lead Time 1 week 2 3 4 5 6 120 65 150 15 15 15 0 0 0 0 105 65 150 105 65 150 105 65 150 Safety Stock= Lot Size = Lead Time = 3 4 5 6 Safety Stock= 8 7 8 Lot Size = 2 3 4 Lead Time= 6 8 Safety Stock= Lot Size= 1 2 3 4 5 Lead Time= 6 7 8 Math Problem 1-Materials Requirements Planning Use the following information to complete the MRP tables for items B & C. Show your answers in the tables. (There is an extra MRP table.) B(2) A D (4) E (3) D (4) ABC B (1) F (3) E (3) On-Hand Sch. Receipts 15 150 0 Lot Size LFL Lead Time Safety Stock 120 in period 1 140 in period 2 FOQ=80 EOQ=100 122 0 20 10 0 Item: A Description: MPS Period Gross Requirements Scheduled Receipts On Hand 15 Net Requirements Planned Order Receipts Planned Order Releases Item: Description: Period Gross Requirements Scheduled Receipts On Hand Net Requirements Planned Order Receipts Planned Order Releases Item: Description: Period Gross Requirements Scheduled Receipts On Hand Net Requirements Planned Order Receipts Planned Order Releases Item: Description: Period Gross Requirements Scheduled Receipts On Hand Net Requirements Planned Order Receipts Planned Order Releases Safety Stock=0 Lot Size =LFL Lead Time 1 week 2 3 4 5 6 120 65 150 15 15 15 0 0 0 0 105 65 150 105 65 150 105 65 150 Safety Stock= Lot Size = Lead Time = 3 4 5 6 Safety Stock= 8 7 8 Lot Size = 2 3 4 Lead Time= 6 8 Safety Stock= Lot Size= 1 2 3 4 5 Lead Time= 6 7 8