Design a spreadsheet to estimate the dimensions of a tank for holding water. The spreadsheet should use input values from the user to return the height and diameter for a tank that will use the smallest amount of steel and therefore cost the least to produce.
Attached you will find an example of how a working spreadsheet should look. The layout of the sheet that you design does not have to match the layout of this example, but your spreadsheet must use the same input values and return the same results.
The spreadsheet must be capable of approximating the lowest cost dimensions for any value of the input variables.
The "Input Variables" are Volume (gal), Price of Steel ($/lb), Budget ($), Thickness (in), and Density (lb/ft^3).
The Calculations: Diameter (ft) are given and are 2-9. Height (ft), Surface area (ft^2), steel volume (ft^3), and cost ($).
The Results: Cost ($), under budget?, Diameter (ft), Height (ft).