If possible make, chart has to be made on excel
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.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 = 2 x circumference + height of container Cost/volume is estimated to be $0.01 per cc of metal container material volume. Welding cost/length is estimated to be 0.002 dollars/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. 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.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 = 2 x circumference + height of container Cost/volume is estimated to be $0.01 per cc of metal container material volume. Welding cost/length is estimated to be 0.002 dollars/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
