MRP Exercise 4 Bill of materials (BOM) (Product Structure) Planned lead times weeks 1 level Table (End Item) 1 week 1 1 1 2 level Leg Assembly (1) 1 week Top (1) 2 weeks Assemble Table Finished leg Assembly Purchase legs Purchase short rails Purchase long rails Purchase tops 1 1 2 30 Short Rails (2) 1 week Long Rails (2) 1 week Legs (4) 1 week Quantity per unit shown in parentheses. We are assuming that the parts for this table are purchased from outside. MRP Exercise 4 Month 1 2 Aggregate Production Plan (S&OP) 200 250 Weeks 1 2 3 4 5 6 Master Production schedule Tables 200 150 100 Demand for finished tables: 200 in week 4, 150 in week 5 and 100 in week 6. -There are 50 tables on hand at present time (week 1). -50 tabletops are currently on hand (week 1) and 50 are scheduled to arrive at the begining of week 2. -100 are on hand (week 1), leg assembly -150 legs are on hand (week 1) and 100 are planned to arrive at the begining of week 2, -50 short rails are on hand (week 1) MRP Exercise 4 Bill of materials (BOM) (Product Structure) Planned lead times weeks 1 level Table (End Item) 1 week 1 1 1 2 level Leg Assembly (1) 1 week Top (1) 2 weeks Assemble Table Finished leg Assembly Purchase legs Purchase short rails Purchase long rails Purchase tops 1 1 2 30 Short Rails (2) 1 week Long Rails (2) 1 week Legs (4) 1 week Quantity per unit shown in parentheses. We are assuming that the parts for this table are purchased from outside. MRP Exercise 4 Month 1 2 Aggregate Production Plan (S&OP) 200 250 Weeks 1 2 3 4 5 6 Master Production schedule Tables 200 150 100 Demand for finished tables: 200 in week 4, 150 in week 5 and 100 in week 6. -There are 50 tables on hand at present time (week 1). -50 tabletops are currently on hand (week 1) and 50 are scheduled to arrive at the begining of week 2. -100 are on hand (week 1), leg assembly -150 legs are on hand (week 1) and 100 are planned to arrive at the begining of week 2, -50 short rails are on hand (week 1)