Answer Question Below with examples I posted below. Please answer in Excel and show all formulas.

This is how the answer should be:

E F G . A A B C D Consider the following product structure. N 3 If the demand for product A is 50 units, how many units of each component will be needed? 4 5 A 6 7 00 8 9 B(1) C (1) 10 11 D (2) E (1) F (2) D (1) F (1) 12 13 14 15 16 50 17 18 19 - A B D 20 21 F A B D E F G H Lead Times for Awesome Speaker Kits (As) 1 COMPONENT LEAD TIME 2 3 A A nmn 4 B 5 1 week 2 weeks 1 week 1 week 2 week 3 weeks 6 D 7 E 00 8 F G 2 weeks 9 10 11 12 13 D B 14 15 E A 16 17 18 E G 19 20 21 F D 22 23 24 1 2 3 4 5 6 7 8 25 26 Weeks SUM A x fx =(2*05)+(2*09) j L . N 1 A B D H TABLE Gross Material Requirements Plan for 50 Awesome Speaker Kits (As) 14.3 with Order Release Dates Also Shown WEEK 2 3 LEAD TIME 1 2 3 4 4 5 6 7 8 A 50 5 50 A. Required date B 100 1 week Order release date 50 6 150 7 100 B. Required date D =(2*05)+(2*09) 2 weeks Order release date 100 00 8 E 500 150 C. Required date 9 F 300 1 week Order release date 150 10 G 300 200 E. Required date 11 300 2 weeks Order release date 200 300 12 13 F. Required date 300 3 weeks Order release date 300 14 15 D. Required date 600 200 1 week Order release date 600 200 16 17 G. Required date 300 2 weeks Order release date 300 18 Requirements: 50 units Level Product Structure for "Awesome" Speaker Item On Hand 10 A 0 A B C 15 20 10 10 1 D B (2) C (3) E F 5 2 E (2) E (2) F(2) G 0 3 D (2) G (1) D(2) Gross Reqt On Hand Net Regt A = 501 B 2A 100 101=F17-G17 15 65 20 100 = 150 D = 800 10 E = 500 10 2B+2F 2B+2C 20 1(F) 510 320 195 F = 300 Ols 5 G = 300 195 SUM X V fx =3*F17 A B D E F. G H K L M N o P 1 Requirements: 50 units 2 3 Level Product Structure for "Awesome" Speaker Item On Hand 10 4 A 5 0 B 15 6 20 7 1 D 10 8 B (2) C (3) E 10 5 9 F 10 2 E (2) E (2) F(2) G 0 11 3 D (2) G (1) 12 13 D (2) 14 15 Gross Reqt On Hand Net Reqt = 10 40 16 17 18 19 20 A B 501 100 15 2A = =3*F171 20 65 100 510 D 11111111111111 = 10 = 10 320 E F 2B+2F 2B+2C 2c 1(F) 800 500 300 300 = 21 22 23 24 25 5 195 G = 0 195 SUM X V fx =3*H17-619 A B D E F G H 1 J K L M N 1 Requirements: 50 units 2 3 Level Product Structure for "Awesome" Speaker Item 4 A On Hand 10 15 5 0 A B | 6 20 7 1 D 10 8 B (2) C(3) E 10 9 F 5 | E (2) 10 2 E (2) F(2) G 0 3 D (2) G (1) D (2) 11 12 13 14 15 Gross Reqt On Hand Net Reqt A = 50 401 16 17 18 19 II 11 B = 2A 101 15 65 201=3*H17-619 10 510 100 1501 800 = 20 D = 21 E = 500 10 320 2 B+2F 2B+2c 20 1(F) 22 F 300 5 195 23 G = 300 0 195 24