provided both templates. please provide answer and show work

Do Problem #1, items e and fonly. Use the enclosed template. HW CH6 Template Excel.xlsx B The next template provides the cost data needed to complete part (f). HW CH 6 Problem 1 Cost Data.xlsx | Thickness Length Width 0.5 0.25 0.75 0.25 0.5 A B C 1 Customer Order Numbe Metal 2 Delta BVL1000 Bronze 3 Kappa BVL1001 Copper 4 Kappa BVL1001 Copper 5 Zeta BVL1002 Bronze 6 Delta BVL 1002 Bronze 7 Delta BVL 1003 Brass 8 Beta BVL1003 Brass 9 Zeta BV-1004 Bronze 10 Beta BV-1004 Bronze 11 Delta BVL1005 Bronze 12 Alpha BVL1005 Bronze 13 Alpha BVL1006 Copper 14 Zeta BVL1006 Brass 15 Alpha BVL1007 Copper 16 Beta BVL1007 Brass 17 Kappa BVL1008 Brass 18 Zeta BVL1008 Copper 19 Alpha BVL1009 Brass 20 Beta BVL1009 Brass 21 Beta BVL1010 Bronze Delta BVL1010 Bronze 23 Beta BVL1011 Bronze 24 Kappa BV-1011 Copper 25 Kappa BV-1012 Brass 26 Kappa BV-1012 Copper Sheet1 Sheet2 0.25 0.5 0.75 Sheets : * fa C D Metal Cost $/ft? 1/2" 3/4" $18.45 $25.85 $19.500 $28.45 $23.65 $35.50 $32.55 $36.95 $45.95 Do Problem #1, items e and fonly. Use the enclosed template. HW CH6 Template Excel.xlsx B The next template provides the cost data needed to complete part (f). HW CH 6 Problem 1 Cost Data.xlsx | Thickness Length Width 0.5 0.25 0.75 0.25 0.5 A B C 1 Customer Order Numbe Metal 2 Delta BVL1000 Bronze 3 Kappa BVL1001 Copper 4 Kappa BVL1001 Copper 5 Zeta BVL1002 Bronze 6 Delta BVL 1002 Bronze 7 Delta BVL 1003 Brass 8 Beta BVL1003 Brass 9 Zeta BV-1004 Bronze 10 Beta BV-1004 Bronze 11 Delta BVL1005 Bronze 12 Alpha BVL1005 Bronze 13 Alpha BVL1006 Copper 14 Zeta BVL1006 Brass 15 Alpha BVL1007 Copper 16 Beta BVL1007 Brass 17 Kappa BVL1008 Brass 18 Zeta BVL1008 Copper 19 Alpha BVL1009 Brass 20 Beta BVL1009 Brass 21 Beta BVL1010 Bronze Delta BVL1010 Bronze 23 Beta BVL1011 Bronze 24 Kappa BV-1011 Copper 25 Kappa BV-1012 Brass 26 Kappa BV-1012 Copper Sheet1 Sheet2 0.25 0.5 0.75 Sheets : * fa C D Metal Cost $/ft? 1/2" 3/4" $18.45 $25.85 $19.500 $28.45 $23.65 $35.50 $32.55 $36.95 $45.95