Use the Excel Solver tool to find the best design for a cylindrical aluminum can. The interior volume of the can should be 500 cm3, and the cans wall thickness should be 0.015 cm. Give the inside and outside dimensions of the can design that minimizes the volume of aluminum used in constructing the can. (Hint: Start with the spreadsheet below, use formulas that refer to cells A2, B2 and D2 to fill in the empty cells, then use the solver tool to minimize H2 by changing the value in B2)

8:50