LE 285 HW 4- MRP Repeat the MRP procedure example as shown in class, but with the modified data shown below. 300 units of X are needed in week 10. Lead Time (weeks) 2 Item B On-hand 75 100 12 A(2) B(1) D 200 40 1 3 C(3) C(2) D(5) 1 N 3 4 5 6 7 8 9 10 Spare Parts Needed A 12 14 B 8 10 D 8 10 1 2 3 4 5 6 7 B 9 10 A Week: Gross Requirements On Hand Net Requirements Planned Order Receipt Planner Order Release Gross Requirements On Hand Net Requirements Planned Order Receipt Planner Order Release Gross Requirements On Hand Net Requirements Planned Order Receipt Planner Order Release Gross Requirements On Hand Net Requirements Planned Order Receipt Planner Order Release Gross Requirements On Hand Net Requirements Planned Order Receipt Planner Order Release B D 1 2 3 4 5 6 7 10 8 B 1 eala 9 1. X 95 50 45 Example X A 45 90 75 12 Itern B 15 12 A(2) B(1) On-hand Lead Time (weeks) 50 2 75 3 25 1 10 2 20 2 15 12 1 C(3) C(2) D(5) B 7 25 o 45 18 27 1 2 3 5 6 7 Week Gross Requirements On-Hand Net Requirements Planned Order Receipt Planned Order Release Gross Requirements On-Hand Net Requirements Planned Order Receipt Planned Order Release Gross Requirements On-Hand Net Requirements Planned Order Receipt Planned Order Release Gross Requirements On-Hand Net Requirements Planned Order Receipt Planned Order Release Gross Requirements On-Hand Net Requirements Planned Order Receipt Planned Order Release 8 10 9 121 Additional parts to make. Add this to table on next slide Spare Parts A B D 71 10 VBA. 14 15 3 X 15 v 45 10 35 1 272 27. c 36 54 10 95 units of X from firm orders are required in wook 10 plus the service parts in the table above. 47 36 54 10 35 36 54 10 15 D 135 20 5 130 130