Part Number Quantity per 100 2 2 150 1 Made from Part Number 30 1 30 2 30 2 30 3 30 3 30 4 Level 0 100 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. 150 301 Level 1 301 (2) 303 (1) 302 Level 2 303 (2) Part 100 is planned for using a master production schedule. Lead time is two Weeksand it is built in lots of 200. At present there are 200 scheduled to be received in week 1. None is on hand. 304 302 (1) 304 (1) 304 (1) 302 (2) 302 (1) 302 (1) Level 3 CASE ANALYSIS Part 150 is planned for using a master production schedule. Lead time isone 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 andweek 2. Part 302 is a component with a lead time of one week, and a lot size of1500. At present there are 500 on hand and a lot to be received inweek 1. Part 303 is a component having a lead time of two weeks, and a lot size of1500. 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 sizeof 2000. At present there are 2200 on hand and there is a lot scheduled to be received in week 4. 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, awhere- 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 worksheets, 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 thesebe promised without changing the MPS? 6 Master Schedule 4 9 1 100 2 100 5 100 6 100 7 300 10 100 100 100 100 200 95 Item Master File Planning Factors 90 90 110 70 50 190 60 120 30 105 15 125 15 Weck Forecast Requirements Customer Orders Projected 0 Available Balance Available-to- Promise Master Production Schedule Lead Time: Order Quantity: Safety Stock: 15 15 15 15 Low-Level Code Status On-Hand: 200 200 On Order: Due Date: On-Hand: Part Number: 150 Item Master File Planning Factors Low-Level Code: Status Lead Tunson Order Quantity. Due Dat Safety Stock Order: Master Schedule Part Number : Week 1 2 3 4 5 7 9 10 Part Number: Itern Master File Planning Factors SO 50 SO 50 150 SO 50 SO SO Forecast Requirements Lead Tube Order Quan Safety Stock: 45 48 48 SO 120 30 35 10 25 30 Customer Orders Low-Level Cade. Status On-Hands On Order Due Date: Projected Available Balance Where-Used File Where Used: Quantity Per: Available-to- Promise Pegging File 1 Master Production Schedule 2 4 5 7 9 9 10 Week Grass Requirements Part 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 Part Number Quantity per 100 2 2 150 1 Made from Part Number 30 1 30 2 30 2 30 3 30 3 30 4 Level 0 100 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. 150 301 Level 1 301 (2) 303 (1) 302 Level 2 303 (2) Part 100 is planned for using a master production schedule. Lead time is two Weeksand it is built in lots of 200. At present there are 200 scheduled to be received in week 1. None is on hand. 304 302 (1) 304 (1) 304 (1) 302 (2) 302 (1) 302 (1) Level 3 CASE ANALYSIS Part 150 is planned for using a master production schedule. Lead time isone 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 andweek 2. Part 302 is a component with a lead time of one week, and a lot size of1500. At present there are 500 on hand and a lot to be received inweek 1. Part 303 is a component having a lead time of two weeks, and a lot size of1500. 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 sizeof 2000. At present there are 2200 on hand and there is a lot scheduled to be received in week 4. 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, awhere- 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 worksheets, 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 thesebe promised without changing the MPS? 6 Master Schedule 4 9 1 100 2 100 5 100 6 100 7 300 10 100 100 100 100 200 95 Item Master File Planning Factors 90 90 110 70 50 190 60 120 30 105 15 125 15 Weck Forecast Requirements Customer Orders Projected 0 Available Balance Available-to- Promise Master Production Schedule Lead Time: Order Quantity: Safety Stock: 15 15 15 15 Low-Level Code Status On-Hand: 200 200 On Order: Due Date: On-Hand: Part Number: 150 Item Master File Planning Factors Low-Level Code: Status Lead Tunson Order Quantity. Due Dat Safety Stock Order: Master Schedule Part Number : Week 1 2 3 4 5 7 9 10 Part Number: Itern Master File Planning Factors SO 50 SO 50 150 SO 50 SO SO Forecast Requirements Lead Tube Order Quan Safety Stock: 45 48 48 SO 120 30 35 10 25 30 Customer Orders Low-Level Cade. Status On-Hands On Order Due Date: Projected Available Balance Where-Used File Where Used: Quantity Per: Available-to- Promise Pegging File 1 Master Production Schedule 2 4 5 7 9 9 10 Week Grass Requirements Part 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