CASE 14 CONSOLIDATED WEEDCUTTERS Part Number Made from Part Number Quantity per 100 301 2. 302 2 150 302 1 Consolidated Weedcutters Inc. makes two models of cutters, the standard (part number 100), and the economy (part number 150). The following information is taken from the bill of material files for each of the weedcutters. 303 1 301 303 2 304 1 302 303 302 1 304 1 304 Part 100 is planned for using a master production schedule. Lead time is two Weeks and it is built in lots of 200. At present there are 200 scheduled to be received in week 1. None is on hand. Act Go CASE 14 CONSOLIDATED WEEDCUTTERS Level 0 100 150 Level 1 301 (2) 303 (1) Level 2 303 (2) Level 3 302 (1) 304 (1) 304 (1) 302 (2) 302 (1) 302 (1) 304 (1) CASE 14 CONSOLIDATED WEEDCUTTERS Part 150 is planned for using a master production schedule. Lead time is one week and it is built in lots of 100. At present there are 100 scheduled to be received in week 1. None is on hand. Part 301 is a component having a lead time of two weeks, and a lot size of 600. At present there are lots scheduled to be received in week 1 and week 2. Part 302 is a component with a lead time of one week, and a lot size of 1500. At present there are 500 on hand and a lot to be received in week 1. Part 303 is a component having a lead time of two weeks, and a lot size of 1500. At present there is a lot scheduled to be received in week 1. Part 304 is a component having a lead time of four weeks, and a lot size of 2000. At present there are 2200 on hand and there is a lot scheduled to be received in week 4. Acti Go to CASE ANALYSIS 1. 2. 3. From information given, draw product trees for each of the finished goods. What is the low-level code for each of the item? Following are sheets for each part. Each sheet has an item master file, a where-used file, a pegged requirement file, and an MPS or MRP work sheet. These files are normally located in different spaces in a computer system, but are combined here for your convenience. Complete the work sheets, filling in information from what is given above, and performing the required calculations. It is the beginning of week 1. What exception message(s) willthe computer generate? What action(s), if any, should be taken? The scheduled receipt for part 302 in week 1 has been received and is 100 parts short. What parts will this affect? What action should be taken? An order is received for 25 of item 100 for delivery in week 3. Can these be promised without changing the MPS? 4. 5. 6. Part Number : 100 Item Master File Planning Factors Lead Time : Order Quantity : Safety Stock: Low-Level Code : Status On-Hand : On Order : Due Date: Act Got Master Schedule Week 1 2 3 4 5 6 7 8 9 10 100 100 100 100 100 100 300 100 200 100 Forecast Requirements Customer Orders 95 90 90 110 70 50 190 60 120 30 0 105 15 125 15 Projected Available Balance 15 15 15 15 Available-to- Promise 200 200 Master Production Schedule Part Number: 150 Item Master File Planning Factors Low-Level Code : Status Lead Time : Order Quantity : Safety Stock: On-Hand : On Order : Due Date: Act Master Schedule Week 1 2 3 4 5 6 7 8 9 10 50 50 50 50 150 50 50 50 50 Forecast Requirements 45 48 48 50 120 30 35 10 25 30 Customer Orders Projected Available Balance Available-to- Promise Master Production Schedule Act Got Part Number : Part Number: Item Master File Planning Factors Low-Level Code : Lead Time : Order Quantity : Safety Stock: Status On-Hand : On Order : Due Date: Where-Used File Where Used: Quantity Per: Pegging File Week 1 2. 3 4 5 6 7 8 9 10 Part Gross Requirements Act Material Requirements Plan Week 1 2 3 4 5 6 7 8 9 10 Gross Requirements Scheduled Receipts Projected Available Balance Net Requirements Planned Order Receipts Planned Order Releases GO CASE 14 CONSOLIDATED WEEDCUTTERS Part Number Made from Part Number Quantity per 100 301 2. 302 2 150 302 1 Consolidated Weedcutters Inc. makes two models of cutters, the standard (part number 100), and the economy (part number 150). The following information is taken from the bill of material files for each of the weedcutters. 303 1 301 303 2 304 1 302 303 302 1 304 1 304 Part 100 is planned for using a master production schedule. Lead time is two Weeks and it is built in lots of 200. At present there are 200 scheduled to be received in week 1. None is on hand. Act Go CASE 14 CONSOLIDATED WEEDCUTTERS Level 0 100 150 Level 1 301 (2) 303 (1) Level 2 303 (2) Level 3 302 (1) 304 (1) 304 (1) 302 (2) 302 (1) 302 (1) 304 (1) CASE 14 CONSOLIDATED WEEDCUTTERS Part 150 is planned for using a master production schedule. Lead time is one week and it is built in lots of 100. At present there are 100 scheduled to be received in week 1. None is on hand. Part 301 is a component having a lead time of two weeks, and a lot size of 600. At present there are lots scheduled to be received in week 1 and week 2. Part 302 is a component with a lead time of one week, and a lot size of 1500. At present there are 500 on hand and a lot to be received in week 1. Part 303 is a component having a lead time of two weeks, and a lot size of 1500. At present there is a lot scheduled to be received in week 1. Part 304 is a component having a lead time of four weeks, and a lot size of 2000. At present there are 2200 on hand and there is a lot scheduled to be received in week 4. Acti Go to CASE ANALYSIS 1. 2. 3. From information given, draw product trees for each of the finished goods. What is the low-level code for each of the item? Following are sheets for each part. Each sheet has an item master file, a where-used file, a pegged requirement file, and an MPS or MRP work sheet. These files are normally located in different spaces in a computer system, but are combined here for your convenience. Complete the work sheets, filling in information from what is given above, and performing the required calculations. It is the beginning of week 1. What exception message(s) willthe computer generate? What action(s), if any, should be taken? The scheduled receipt for part 302 in week 1 has been received and is 100 parts short. What parts will this affect? What action should be taken? An order is received for 25 of item 100 for delivery in week 3. Can these be promised without changing the MPS? 4. 5. 6. Part Number : 100 Item Master File Planning Factors Lead Time : Order Quantity : Safety Stock: Low-Level Code : Status On-Hand : On Order : Due Date: Act Got Master Schedule Week 1 2 3 4 5 6 7 8 9 10 100 100 100 100 100 100 300 100 200 100 Forecast Requirements Customer Orders 95 90 90 110 70 50 190 60 120 30 0 105 15 125 15 Projected Available Balance 15 15 15 15 Available-to- Promise 200 200 Master Production Schedule Part Number: 150 Item Master File Planning Factors Low-Level Code : Status Lead Time : Order Quantity : Safety Stock: On-Hand : On Order : Due Date: Act Master Schedule Week 1 2 3 4 5 6 7 8 9 10 50 50 50 50 150 50 50 50 50 Forecast Requirements 45 48 48 50 120 30 35 10 25 30 Customer Orders Projected Available Balance Available-to- Promise Master Production Schedule Act Got Part Number : Part Number: Item Master File Planning Factors Low-Level Code : Lead Time : Order Quantity : Safety Stock: Status On-Hand : On Order : Due Date: Where-Used File Where Used: Quantity Per: Pegging File Week 1 2. 3 4 5 6 7 8 9 10 Part Gross Requirements Act Material Requirements Plan Week 1 2 3 4 5 6 7 8 9 10 Gross Requirements Scheduled Receipts Projected Available Balance Net Requirements Planned Order Receipts Planned Order Releases GO