In recent years the size and shape of drink cans have been varied. The traditional looking pop can is no longer the only option in purchasing your 12 oz (355 ml) soda. Half size pops, Monster drinks, coffee drinks, etc have filled the grocery shelves.
Your task is to design a cylindrical can (355 ml) that minimizes can production costs. The production costs can be minimized by using the smallest amount of material possible. When cans are manufactured, any material that does not get used in the can will be shredded and recycled. What should the dimensions of the new can be? Hint: 1 mL = 1 cm3
This problem lends itself to using a spreadsheet and graph from the spreadsheet. Please show work/formulas used in the spreadsheet as well as a graph.
