Using the following BOM (in its tree form), complete the following MRP analysis, knowing that the lead time is one week for each of the components (including the final product).

You have an MPS of 100 units of A in week 5 and at the beginning there are already 20 units of B. The order quantity is batch-to-batch.

Note:

please do it in excel, (with formulas), and show the formulas

A B(2) C(1) D(1) E(1) D(2) F(1) 1 2 3 4 4 5 Week Gross Requirements Scheduled Receipts Projected Available Net Requirements Planned Order Receipt Planned Order Release