**This is the template i have been using but am having problems with the formulas.

Problem 3 Given the following product tree, determine the low-level codes and complete MRP tables for each part. o There are requirements for 100 units of A at week 4 and 50 units of B at week 5. o There is a scheduled receipt for 100 units of C at week 2. Lot size Lead time (Week) Safety Stock Part A Lot for Lot 1 Part B Lot for Lot 1 Part C Lot for Lot 1 Part D Lot for Lot 1 Part E 500 1 Part F Lot for Lot 1 0 0 0 0 0 0 B (req 2) D E E F E (req 2) E F E F 16 Problem 3 Indented Bill of Materials A B Item name Level Indented BOM D E C FE E F E F A B C D E F 0 0 2 1 3 3 A B C D E F A Lead Time= 1 1 SS=0 3 Lots Size 5 LFL 6 2 4 100 Gross requirements Scheduled receipts Projected on-hand Projected on-hand -SS Net requirements Planned order receipts Planned orders release 0 0 0 0 0 0 0 0 0 0 0 100 100 0 100 100 0 100 100 0 B Lead Time= 1 1 SS= 0 3 LFL 6 2 Lots Size= 5 50 4 0 Gross requirements Scheduled receipts Projected on-hand Projected on-hand -SS Net requirements Planned order receipts Planned orders release 0 0 0 0 0 #VALUE! #VALUE! #VALUE! #VALUE! 0 0 0 50 50 0 50 100 100 0 50 Lead Time: 1 1 SS=0 3 3 Lots Size 5 LFL 6 2 4 100 Gross requirements Scheduled receipts Projected on-hand Projected on-hand -SS Net requirements Planned order receipts Planned orders release D Lead Time= 1 1 0 2 0 SS=0 3 0 4 0 Lots Size 5 0 LFL 6 0 0 Gross requirements Scheduled receipts Projected on-hand Projected on-hand-SS Net requirements Planned order receipts Planned orders release E Lead Time= 1 1 SS=0 3 3 Lots Size 5 500 6 2 4 Gross requirements Scheduled receipts Projected on-hand Projected on-hand - SS Net requirements Planned order receipts Planned orders release 0 0 F Lead Time= 1 1 SS=0 3 Lots Size= 5 LFL 6 2 4 Gross requirements Scheduled receipts Projected on-hand Projected on-hand -SS Net requirements Planned order receipts Planned orders release 0 0