Answer ASAP I will

2. In Sheet2 of the Microsoft Excel workbook provided, determine the minimum-cost

blend of alloys 1 through 5 inclusive to produce a new alloy of 40% tin, 35% zinc, and

25% lead. Make any clear-cut corrections to the presentation of the worksheet you deem

appropriate. Implement appropriate data validation. (20 points)

\begin{tabular}{llrrrrrr} \multicolumn{1}{c}{ A } & \multicolumn{1}{c}{ B } & \multicolumn{1}{c}{ C } & \multicolumn{1}{c}{ D } & E & \multicolumn{1}{c}{F} \\ \cline { 7 - 8 } & & & \multicolumn{2}{c}{ Alloy } & & \\ 2 & Propurty & 1 & 2 & 3 & 4 & 5 \\ 3 & \%tin & 60 & 25 & 45 & 20 & 50 \\ 4 & \%zinc & 10 & 15 & 45 & 50 & 40 \\ 5 & \%lead & 30 & 60 & 10 & 30 & 10 \\ 6 & Cost (\$/lb) & 22 & 20 & 25 & 24 & 27 \\ 7 & & & & & & \\ 8 & & & & & \end{tabular}