Consider a buoy in the form of a vertical right circular cylinder of outside diameter (D) of 8 feet, and
height (H) of 12 feet. The buoy is a hollow cylinder formed of glass-fiber-reinforced plastic (FRP)
that is ½-inch thick. The buoy is to be placed in a large river and tethered to the bottom by a cable
that is 80 feet long
The cable is supposed to snap if the water depth exceeds 90 feet. Set up an
Excel spreadsheet to compute the force on the cable at different river depths and the force at which
the cable should be designed to snap.
Archimedes Pinciple: mass of obj- apparent mass of obj= Density of water * vol of obj
The force on the cable can be computed from a force balance on the buoy.
The downward force due to gravity is the total mass of the buoy multiplied by gravitational
The Attempt at a Solution
Not sure how to start this, I have to solve it in excel but dont know where to begin