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:

do it in excel, and show screen shots (show the formulas of the calculations, please) (to understand how the process works and how you did it)

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