This is the template i have been using (required) but my excel formulas are not coming out right. Please show the excel formulas needed
. Problem 2 A company produces two basic products called A and B. Each week, the owner plans to assemble 25 of A and 10 of B. o The company produces 25 A and 10 B every week continuously, therefore order 25 A and 10 B every week o There is a current SR of 10 for G and Y at week 1 o Projected OH for G and Y are 0 and 60 respectively o G has the ordering policy of LFL(Lot for Lot) and LT(Lead time) = 1 o Y has the ordering policy of LFL, LT = 2 Given the information and BOM structure diagrams for A and B, complete the MRP table for component G and Y for the next seven weeks. B . A G F X Y N 13 (req 2) B D E F G H Indented Bill of Materials (s. Item name Level Indented BOM B G F Y X Y B G F Z Y B G F Z Z (reg 2 G SS=0 3 10 2 10 4 10 Lots Size= LFL 5 6 10 10 7 10 Lead Time= 1 1 10 10 0 0 Gross requirements Scheduled receipts Projected on-hand Projected on-hand - SS Net requirements Planned order receipts Planned orders release 0 0 -10 -10 10 0 10 -10 -10 10 30 10 -10 -10 10 40 10 -10 -10 10 50 10 -10 -10 10 60 10 -10 -10 10 70 10 Y 2 45 SS=0 3 45 4 45 Lots Size= LFL 5 6 45 45 7 25 Gross requirements Scheduled receipts Projected on-hand Projected on-hand -SS Net requirements Planned order receipts Planned orders release Lead Time= 2 1 45 10 60 25 60 25 -20 -20 20 0 -65 -65 65 0 -110 -110 110 0 - 155 -155 155 0 -200 -200 200 0 -225 -225 225 . Problem 2 A company produces two basic products called A and B. Each week, the owner plans to assemble 25 of A and 10 of B. o The company produces 25 A and 10 B every week continuously, therefore order 25 A and 10 B every week o There is a current SR of 10 for G and Y at week 1 o Projected OH for G and Y are 0 and 60 respectively o G has the ordering policy of LFL(Lot for Lot) and LT(Lead time) = 1 o Y has the ordering policy of LFL, LT = 2 Given the information and BOM structure diagrams for A and B, complete the MRP table for component G and Y for the next seven weeks. B . A G F X Y N 13 (req 2) B D E F G H Indented Bill of Materials (s. Item name Level Indented BOM B G F Y X Y B G F Z Y B G F Z Z (reg 2 G SS=0 3 10 2 10 4 10 Lots Size= LFL 5 6 10 10 7 10 Lead Time= 1 1 10 10 0 0 Gross requirements Scheduled receipts Projected on-hand Projected on-hand - SS Net requirements Planned order receipts Planned orders release 0 0 -10 -10 10 0 10 -10 -10 10 30 10 -10 -10 10 40 10 -10 -10 10 50 10 -10 -10 10 60 10 -10 -10 10 70 10 Y 2 45 SS=0 3 45 4 45 Lots Size= LFL 5 6 45 45 7 25 Gross requirements Scheduled receipts Projected on-hand Projected on-hand -SS Net requirements Planned order receipts Planned orders release Lead Time= 2 1 45 10 60 25 60 25 -20 -20 20 0 -65 -65 65 0 -110 -110 110 0 - 155 -155 155 0 -200 -200 200 0 -225 -225 225
