solve it by hand ..

3. Here are the parts list and the lead time for product End. Item Child Items Lead time Current Inventory Product End 1 week 50 A A (2 required) B (2 required) C (2 required) D (2 required) C (2 required) C (3 required) D (3 required) none 1 week 150 B 1 week 250 1 week 2 weeks 50 150 D none a. Construct the product-structure tree for product End. (10pts) b. Prepare MRP for component to meet the requirements stated in the master schedule. Blank MRP records have been provided for your use. (15pts) Product End 1 2 3 4 5 6 7 8 Gross requirements 200 200 200 Scheduled receipts 100 Projected on hand Planned-order releases 2 3 4 5 6 8 Gross requirements Scheduled receipts Projected on hand Planned-order releases 2 3 4 6 8 B Gross requirements Scheduled receipts Projected on hand Planned-order releases D a Construct the product-structure tree for product End. (10pts) 6 b. Prepare MRP for component to meet the requirements stated in the master schedule. Blank MRP records have been provided for your use. (15pts) Product End 1 2 3 4 5 7 8 Gross requirements 200 200 200 Scheduled receipts 100 Projected on hand Planned-order releases 2 3 4 5 7 8 Gross requirements Scheduled receipts Projected on hand Planned-order releases 200 1 2 3 4 5 8 B Gross requirements Scheduled receipts Projected on hand Planned-order releases 200 1 2 3 4 S 7 8 Gross requirements Scheduled receipts Projected on hand Planned-order releases 200