Steps for

MINIMAL CONTAINER COST

A liquid is to be sealed in a cylindrical container. Suppose the most marketable

size is a metal container that encloses $250$ cubic centimeters $($cc$)$ of the liquid.

Material of thickness $0\mathrm{.}1$ mm must be used to meet the structural constraints of

the container.

The following component models have been established:

Cost of cylindrical container $=$ metal material cost $+$ welding cost

Material cost $=$ volume of metal container $x$ cost$/$volume

Welding cost $=$ length of welds $x$ cost$/$length

Length of welds $=2x$ circumference $+$ height of container

Cost$/$volume is estimated to be $$0\mathrm{.}01$ per cc of metal container material volume.

Welding cost$/$length is estimated to be $0\mathrm{.}002$ dollars $\frac{?}{mm}$ of length.

What would be design of the cylindrical container for minimal cost?

Specify its diameter and height for minimal cost.

Represent all your calculations in tabulated form. Use font to $10-$point Times

New Roman and for headings use font to $10-$point bold italic Times New

Roman. Add border outlines for whole table and for each individual cell. Center

the labels and number in all cells. Include units of the variables in the headings

of the table.

Plot the graph of the cost per container as a function of the diameter using chart

type "Line". Chart should be correctly scaled. Fit all assignment onto single

page.

Include your name and student ID at the top left of the page.

Save file in your folder. Always check "print preview" before printing.