Semans is a manufacturer that produces bracket assemblies. Demand for bracket assemblies (X) is 130 units. The product structure tree and current inventory levels are following. (6) X A B C D E F G 25 16 60 20 180 160 1000 100 Sol: Those who have drawn complete MRP table up to part C considering LT (any number except 0) got full marks. Those who have not write Planned order release and planned order receipt in the table, marks are deducted. Solution with LT=1 Solution with varying LT Level 0 X 1 2 3 4 5 LT-1 Gross Requirement 0 0 0 0 130 Scheduled Receipts 0 0 0 0 0 On-Hand 25 25 25 25 25 Net Requirement 0 0 0 0 105 Planned Order Receipt 0 0 0 0 105 Planned Order Release 0 0 0 105 0 Level 1 A Gross Requirement 0 0 0 420 0 LT-1 Scheduled Receipts 0 0 0 0 0 On-Hand 16 16 16 16 0 Net Requirement 0 0 0 404 0 Planned Order Receipt 0 0 0 404 0 Planned Order Release 0 0 404 0 0 Level 1 B Gross Requirement 0 0 0 210 0 LT-1 Scheduled Receipts 0 0 0 0 0 On-Hand 60 60 60 60 0 Net Requirement 0 0 0 150 0 Planned Order Receipt 0 0 0 150 0 Planned Order Release 0 0 150 0 0 Level 1 C Gross Requirement 0 0 0 315 0 LT-1 Scheduled Receipts 0 0 0 0 0 On-Hand 20 20 20 20 0 Net Requirement 0 0 0 295 0 Planned Order Receipt 0 0 0 295 0 Planned Order Release 0 0 295 0 0 X A(4) C(3) F(4) G(2) B(2) D(3) E(1) Create the MRP up to level 1 using the information provided. <<>> Appendix Common z values Desired Control Limit (%) Z-Value (Standard Deviation Required for Desired Level of Confidence) 91.0 1.35 95.0 1.96 95.5 2.00 99.0 2.58 99.73 3.00 Level 0 X 1 2 3 4 5 LT-1 Gross Requirement 0 0 0 0 130 Scheduled Receipts 0 0 0 0 0 On-Hand 25 25 25 25 25 Net Requirement 0 0 0 0 105 Planned Order Receipt 0 0 0 0 105 Planned Order Release 0 0 0 105 0 Level 1 A Gross Requirement 0 0 0 420 0 LT-2 Scheduled Receipts 0 0 0 0 0 On-Hand 16 16 16 16 0 Net Requirement 0 0 0 404 0 Planned Order Receipt 0 0 0 404 0 Planned Order Release 0 404 0 0 0 Level 1 B Gross Requirement 0 0 0 210 0 LT-3 Scheduled Receipts 0 0 0 0 0 On-Hand 60 60 60 60 0 Net Requirement 0 0 0 150 0 Planned Order Receipt 0 0 0 150 0 Planned Order Release 0 150 0 0 0 Level 1 C Gross Requirement 0 0 0 315 0 LT-4 Scheduled Receipts 0 0 0 0 0 On-Hand 20 20 20 20 0 Net Requirement 0 0 0 295 0 Planned Order Receipt 0 0 0 295 0 Planned Order Release 295 0 0 0