Using excel

ECTT 204 and ECIV 202 Homework #4 Cylindrical steel water tank 6 feet long by 3 feet in diameter is mounted on a flatbed truck. The tank lays on ck bed long-ways - it is not standing on the circular end. The maximum recommended load for the truck pounds. The tank weighs 400 pounds when empty. What is the maximum allowable depth of y? is 2500 (Water weighs 62.4 lb per cubic foot). Provide a plot of total weigth vs water depth and indicate on the plot the maximum allowable depth (You can do this as a drawing with your shapes tool or by turning the plot marker red). Finally, play around with trace dependents and trace precendents functions. Don't forget to use your name box to rename cells to assist in your programming. 2 cos-111-2 = A = cross sectional area of water HW Grading Block Points Points Possible Received Given, find, solution explanation,equations, and drawing Clearly labeled tables with input and output data Clearly labeled plot to verify root or solution Use of goal seek to find exact solution 10 10 10 35