Pls show work and explain how to do it

4.5. Given the following product tree, explode, offset, and determine the gross and net requirements. All lead times are 1 week, and the quantities required are shown in parentheses. The master production schedule calls for 100 As to be available in week 5. There are 20 Bs available. All other on-hand balances = 0. B(2) C(1) D(1) E(1) D(2) F(1) 1 2 3 4 S Part A Lead Time: 1 week Part B Lead Time: 1 week Part C Lead Time: 1 week Week Gross Requirements Scheduled Receipts Projected Available Net Requirements Planned Order Receipt Planned Order Release Gross Requirements Scheduled Receipts Projected Available Net Requirements Planned Order Receipt Planned Order Release Gross Requirements Scheduled Receipts Projected Available Net Requirements Planned Order Receipt Planned Order Release Gross Requirements Scheduled Receipts Projected Available Net Requirements Planned Order Receipt Planned Order Release Gross Requirements Scheduled Receipts Projected Available Net Requirements Planned Order Receipt Planned Order Release Gross Requirements Scheduled Receipts Projected Available Net Requirements Planned Order Receipt Planned Order Release Part D Lead Time: 1 week Part E Lead Time: 1 week Part F Lead Time: 1 week Answer. Planned order releases are Part A: 100 in week 4 Part B: 180 in week 3 Part C: 100 in week 3 Part D: 380 in week 2 Part E: 180 in week 2 Part F: 100 in week 2