Surface area and volume

Question

The good smell perfume company has a new line of perfume and is designing a new fancy bottle for it. Because of the expense of the glass required to make the bottle.The surface area must be less than 150cm2). The company also wants the bottle to hold at least 100 ml of perfume the design under consideration is in a shape of a cylinder. determine the maximum volume possible for a cylindrical bottle that has a total surface area of less than 150cm(2). Determine the volume to the nearest 10ml. Report the dimensions of the bottle and corresponding surface area and volume

Answer 1

Microsoft Excel 14.0 Answer Report
Worksheet: [Book1]Sheet1
Report Created: 5/19/2014 3:47:06 AM
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Solver Options

Objective Cell (Max)
Cell Name Original Value Final Value
$E$4 140.9767131 140.9767131
Max Volume will be 140 cm³

Variable Cells
Cell Name Original Value Final Value Integer
$E$5 r 2.820581654 2.820581654 Contin
$E$6 h 5.64051994 5.64051994 Contin

The radius of the base will be 2.82 cm and the height is 5.64 cm. the surface area is 149.95 cm²