Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need to use excel and am not sure how to input and set up. MINIMAL CONTAINER COST A liquid is to be sealed in

I need to use excel and am not sure how to input and set up.
image text in transcribed
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: 1. Cost of cylindrical container = metal material cost + welding cost 2. Material cost = volume of metal in the container x cost/volume 3. Welding cost = length of welds x cost/length 4. Length of welds = 2 x circumference + height of container 5. Cost/volume is estimated to be $0.01 per cm of metal material volume. 6. Welding cost/length is estimated to be $0.002 per mm of length. Assignment: 1. Specify the diameter and height for minimal cost. 2. Assume diameters are only in whole number increments (heights do not have to be in whole cm). 3. Represent all your calculations in tabulated form. 4. Use font 10-point Times New Roman and for headings use font to 10-point bold italic Times New Roman. 5. Add border outlines for whole table and for each individual cell. 6. Center the labels and number in all cells. 7. Include units of the variables in the headings of the table. 8. Plot the graph of the cost per container as a function of the diameter using chart type "Line". 9. Chart should be scaled to fit the table and chart onto one page so they can be a single page PDF 10. Include your name and student ID at the top left of the page. 11. Always check print preview" before printing to pdf

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Euro A Challenge And Opportunity For Financial Markets Routledge International Studies In Money And Banking

Authors: Michael Artis , Elizabeth Hennessy, Axel Weber

1st Edition

0415217105, 978-0415217101

More Books

Students also viewed these Finance questions