Use Excel Step by Step

7. Given the product structure diagrams at Traci's Tomahawk shown below, complete the MRP records for parts A, F, and G using the data provided for each. Product Structures 1 2 Week 3 4 25 15 5 10 20 5 F Part F Gross requirement Scheduled receipt Projected available balance Planned order release 15 I. 15 G (2 required) C D G H Lead time = 2: Q=L4L: SS=0. Week 1 1 2 Part G Week 3 4 5 10 15 15 2 3 4 5 3 Part A Gross requirement Scheduled receipt Projected available balance Planned order release 5 5 20 Gross requirement Scheduled receipt Projected available balance Planned order releases 10 30 Lead time=1:Q=L4L; SS=0. Lead time = 1:Q=multiples of 20:SS= 10