Hint: Please verify the ATP calculations for item 100, since you need to determine the demand time fence first for both items 100 and 150. Also, each team has to upload just one submission.

Mosch PoE 16.110111 KSE 14 CONSOLIDATED WEEDCUTTERS CASE 14 CONSOLIDATED WEEDCUTTERS 301 121 303 303 021 304 302 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. 302 0 304 Q1 Part Number : 100 Item Master File Planning Factors Low-Level Code : Status On-Hand: Safety Stock: Lead Time: On Order: Order Quantity : Due Date: Week 1 2 3 4 56 7 8 9 9 10 02 50 50 50 50 150 50 50 50 50 Forecast Requirements 45 48 48 50 120 30 35 10 25 Customer Orders 30 Projected Available Balance Available-to- Promise Master Production Schedule Wowowo 16.110111 ASE 14 CONSOLIDATED WEEDCUTTERS CASE 14 CONSOLIDATED WEEDCUTTERS 100 100 301 121 303 303 021 302 304 32 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. 304 (1) 302 10 304 10 Tech Q1 Part Number : Lead Time: Order Quantity : Safety Stock: On Order : Due Date: Part Number: Item Master File Planning Factors Low-Level Code : Status On-Hand: Where-Used File Where Used: Quantity Per: Pegging File Week Gross Part Requirements 1 9 10 Q2 Material Requirements Plan Week 2 3 5 7 8 10 Gross Requirements Scheduled Receipts Projected Available Balance Net Requirements Planned Order Receipts Planned Order Releases Mosch PoE 16.110111 KSE 14 CONSOLIDATED WEEDCUTTERS CASE 14 CONSOLIDATED WEEDCUTTERS 301 121 303 303 021 304 302 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. 302 0 304 Q1 Part Number : 100 Item Master File Planning Factors Low-Level Code : Status On-Hand: Safety Stock: Lead Time: On Order: Order Quantity : Due Date: Week 1 2 3 4 56 7 8 9 9 10 02 50 50 50 50 150 50 50 50 50 Forecast Requirements 45 48 48 50 120 30 35 10 25 Customer Orders 30 Projected Available Balance Available-to- Promise Master Production Schedule Wowowo 16.110111 ASE 14 CONSOLIDATED WEEDCUTTERS CASE 14 CONSOLIDATED WEEDCUTTERS 100 100 301 121 303 303 021 302 304 32 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. 304 (1) 302 10 304 10 Tech Q1 Part Number : Lead Time: Order Quantity : Safety Stock: On Order : Due Date: Part Number: Item Master File Planning Factors Low-Level Code : Status On-Hand: Where-Used File Where Used: Quantity Per: Pegging File Week Gross Part Requirements 1 9 10 Q2 Material Requirements Plan Week 2 3 5 7 8 10 Gross Requirements Scheduled Receipts Projected Available Balance Net Requirements Planned Order Receipts Planned Order Releases