Problem 2: MRP Explosion, Inventory Records The Bill of materials for item A is shown in the figure below. Data from the inventory records are shown in the table below. The MPS for A indicates start of production of 80 units in week 3 and 55 units in week 6; for B indicates start of production of 125 units in week 5; for C indicates start of production of 60 units in week 4; Bill of Materials D(23) E(3) D(1) E121 D (2) E (2) F12) F (21 F(2) + Data from the Inventory Records: Item D E F Lot-size rule FOQ=150 L4L POQ (P=2) 1 Lead time (weeks) 3 1 2 Scheduled receipts 150 (wk 3) 120 (wk 2) none Beginning inventory 150 0 100 1. Fill the following table Component Immediate Parents & (Usage quantity) D E F 2. The "how much and when" question has to be answered for all immediate parents before the question can be answered for the component. In what order should the MRP tables be prepared for components D, E, and F? 3. What is the planned order release for D? a. 0-0-160-120-125-110 b. 0-0-0-0-150-150 c. 160-120-125-110-0-0 d. 0-150-150-0-0-0 4. What is the gross requirement for E? a. 0-0-80-120-250-55 b. 0-80-120-250-55-0 C. 0-0-80-250-55-0 d. 0-0-0-80-250-55 5. What is the planned order receipt for F? a. 0-0-160-500-110-0 b. 160-500-110-0-0-0 C. 0-0-560-0-110-0 d. 560-0-110-0-0-0 51 B C D(2) E(1) D(1) E (2) (D (2) (E (2) F(2) F (2) (F (2) Problem 2: MRP Explosion, Inventory Records The Bill of materials for item A is shown in the figure below. Data from the inventory records are shown in the table below. The MPS for A indicates start of production of 80 units in week 3 and 55 units in week 6; for B indicates start of production of 125 units in week 5; for C indicates start of production of 60 units in week 4; Bill of Materials D(23) E(3) D(1) E121 D (2) E (2) F12) F (21 F(2) + Data from the Inventory Records: Item D E F Lot-size rule FOQ=150 L4L POQ (P=2) 1 Lead time (weeks) 3 1 2 Scheduled receipts 150 (wk 3) 120 (wk 2) none Beginning inventory 150 0 100 1. Fill the following table Component Immediate Parents & (Usage quantity) D E F 2. The "how much and when" question has to be answered for all immediate parents before the question can be answered for the component. In what order should the MRP tables be prepared for components D, E, and F? 3. What is the planned order release for D? a. 0-0-160-120-125-110 b. 0-0-0-0-150-150 c. 160-120-125-110-0-0 d. 0-150-150-0-0-0 4. What is the gross requirement for E? a. 0-0-80-120-250-55 b. 0-80-120-250-55-0 C. 0-0-80-250-55-0 d. 0-0-0-80-250-55 5. What is the planned order receipt for F? a. 0-0-160-500-110-0 b. 160-500-110-0-0-0 C. 0-0-560-0-110-0 d. 560-0-110-0-0-0 51 B C D(2) E(1) D(1) E (2) (D (2) (E (2) F(2) F (2) (F (2)
