Your employer is planning to build several cylindrical storage tanks that will hold fuel. He has decided that all of the cylindrical storage tanks should be the same size, but due to space constraints, is unsure what the diameter and height of each tank should be. Also, he currently does not know exactly how much fuel he will need to store. You are tasked with creating a "flexible" spreadsheet for your employer that will calculate the total volume of several cylindrical storage Canks. The following requirements should be met: The input section should include inputs for: tank diameter (feet), tank height (feet), number of tanks built and total amount of fuel to be stored (gallons). • Enter the following values in the input section of your spreadsheet: o Tank Diameter (feet) = 28 o Tank Height (feet) = 20 O Number of Tanks Built (ea) = 3 o Total Amount of Fuel to be Stored (gal) = 275,000 The calculation section should compute: o Volume of One Tank (cubic feet AND gallons) o Total Volume of All Tanks (cubic feet AND gallons) Cylinder Volume = r²h, where r = radius, h = height. Unit conversion: 1 ft³ = 7.48 gallons. In the output section of your spreadsheet, add an IF statement that will compare the total volume of all tanks to the total amount of fuel to be stored: o If the total volume of all tanks is more than the total amount of fuel to be stored, the IF statement should display "Design OK. o If the total volume of all tanks is less than the total amount of fuel to be stored, the IF statement should compute (and display) the tank volume (in gallons) still required to hold the excess fuel.

Your employer is planning to build several cylindrical storage tanks that will hold fuel. He has decided that all of the cylindrical storage tanks should be the same size, but due to space constraints, is unsure what the diameter and height of each tank should be. Also, he currently does not know exactly how much fuel he will need to store. You are tasked with creating a "flexible" spreadsheet for your employer that will calculate the total volume of several cylindrical storage Canks. The following requirements should be met: The input section should include inputs for: tank diameter (feet), tank height (feet), number of tanks built and total amount of fuel to be stored (gallons). • Enter the following values in the input section of your spreadsheet: o Tank Diameter (feet) = 28 o Tank Height (feet) = 20 O Number of Tanks Built (ea) = 3 o Total Amount of Fuel to be Stored (gal) = 275,000 The calculation section should compute: o Volume of One Tank (cubic feet AND gallons) o Total Volume of All Tanks (cubic feet AND gallons) Cylinder Volume = r²h, where r = radius, h = height. Unit conversion: 1 ft³ = 7.48 gallons. In the output section of your spreadsheet, add an IF statement that will compare the total volume of all tanks to the total amount of fuel to be stored: o If the total volume of all tanks is more than the total amount of fuel to be stored, the IF statement should display "Design OK. o If the total volume of all tanks is less than the total amount of fuel to be stored, the IF statement should compute (and display) the tank volume (in gallons) still required to hold the excess fuel.

Similar questions

Juno is a construction worker. He has found a scrap piece of construction aluminum foil. The sheet has the dimensions of 1.00ft x 5.00ft. Juno knows the 3 aluminum density is 2. 70g/cm. He weighs it and finds its mass is 20.1 grams. Help Juno figure out how thick the sheet is. write your answer in millimeters and with the correct amount of significant figures.
An automobile tire is shown in the figure below. The tire is made of rubber with a uniform density of 1.10 × 103 kg/m³. The tire can be modeled as consisting of two flat sidewalls and a tread region. Each of th sidewalls has an inner radius of 16.5 cm and an outer radius of 30.5 cm as shown, and a uniform thickness of 0.675 cm. The tread region can be approximated as having a uniform thickness of 2.50 cm (that i its inner radius is 30.5 cm and outer radius is 33.0 cm as shown) and a width of 19.4 cm. What is the moment of inertia (in kg m2) of the tire about an axis perpendicular to the page through its center? " 33.0 cm 16.5 cm Sidewall 30.5 cm Tread Enter a number. find the moment of inertia of the sidewall and the moment of inertia of the tread region. Each can be modeled as a cylinder of nonzero thickness. What is the inner and outer radius for each case? What is the formula for the moment of inertia for a thick-walled cylinder? How can you find the mass of a hollow cylinder?…
There are three cylindrical vases on the table, none of them is taller than 40 cm. The firstvase can be filled with 2 dl of water, the second one with 3 dl, and the third with more than 6 dl water. The area of the cross section of the first vase is 10 cm^2, the area of the cross section of the other two vases is 20 cm^2. There is the same amount (volume) of water in each vase. It can be observed that if a specific tuning fork is placed just above the vases, its sound is getting louder. The width of the bottom of each vase is 1 cm, the speed of sound in air is 340 m/s, and the frequency of the tuning fork is less than 1 kHz. a) What is the volume of water in the vases? b) What is the frequency of the tuning fork? c) What is the height of the third vase?
Please help. This problem involves finding the radius and volume of a platinum atom using its density. Thank you.
A cylindrical storage tank has a radius of 1.06 m. When filled to a height of 3.67 m, it holds 12600 kg of a liquid industrial solvent. What is the density of the solvent? Number i Units
A cube 7.81 cm on each side is made of a metal alloy. After you drill a cylindrical hole 1.62 cm in diameter all the way through and perpendicular to one face, you find that the cube has a mass of 0.56 kg. What is the density of this metal? Use π=3.14 . Express your answers in kgm3 and in whole numbers (NOT SCIENTIFIC NOTATION).
There is a brass cylinder weighing 1.000 kg, has a diameter of 0.047 meters, and it is 70 mm tall. Which of the following answers represents the volume the cylinder occupies, and the mass density of the brass?
A sphere made of either brass or aluminum has a radius r= 10cm. What is its mass?
You have three objects of varying shapes and sizes: Object 1 is a rectangular block of tin. Object 2 is a cube of aluminum. Object 3 is a sphere of copper. a. the density of tin is 5.75g/cm2. What is the mass of object 1 in kg if the rectangular block has a volume of 1.34L? b. what is the volume in cubic inches of object 2 if the cube of aluminum 7.58 inches on a side? c. what is the mass in kg of object 2? the density of aluminum is 2.70g/cm3 d. what is the volume in cm3 of object 3 if the sphere of copper has a diameter 8.62cm? the volume of the sphere is 4 {pi}^3/3 e. what is the mass in kg of object 3? Copper has a density of 8.96g/cm3
A. On the average, what volume of blood, in liters, does the heart pump during each beat? B. On the average, what volume of blood, in cubic centimeters, does the heart pump during each beat?
Gold, which has a density of 19.32 g/cm3, is the most ductile metal and can be pressed into a thin leaf or drawn out into a long fiber. (a) If a sample of gold with a mass of 4.041 g, is pressed into a leaf of 1.423 μm thickness, what is the area of the leaf? (b) If, instead, the gold is drawn out into a cylindrical fiber of radius 2.900 μm, what is the length of the fiber?
An automobile tire is shown in the figure below. The tire is made of rubber with a uniform density of 1.10 x 103 kg/m3. The tire can be modeled as consisting of two flat sidewalls and a tread region. Each of sidewalls has an inner radius of 16.5 cm and an outer radius of 30.5 cm as shown, and a uniform thickness of 0.620 cm. The tread region can be approximated as having a uniform thickness of 2.50 cm (tha inner radius is 30.5 cm and outer radius is 33.0 cm as shown) and a width of 19.6 cm. What is the moment of inertia (in kg · m2) of the tire about an axis perpendicular to the page through its center? Sidewall 33.0 cm 16.5 cm 30.5 cm Tread kg • m2