Please provide equation for each box

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 Asto be available in week 5. There are 20 Bs available. All other on-hand balances =0. B(2) B (1) D(1) (1) D(2) RI) Part Number Week 3 1 2 4 5 100 Part Number Quantity B 2 D 1 E 1 1 D 2 F 1 0 A LT=1 Projected available = previous projected available +scheduled receipt +planned order receipt-gross requirement Net requirements = max(0, gross requirements-scheduled receipts - previous projected available) The gross requirement of component = the planned order release of parent * number of components per parent B 20 LT=1 0 LT=1 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 Ordor Polour 0 D LT=1 0 E LT=1 F 0 LT=1