I have not had any Captain Morgan and Dr. Pepper but I'm to old to scratch this answer out even with a calculator.
So I use a couple of on line conversion calculators to get the weight of water (at 40 degrees F is just a guess for a well) and the answer I come up with is
86.595 pounds.
First is for a "Tube Volume Calculator": where d2= 2.067" and d1= 1.315" and the length is 100' which equals to
1.3871353296075 cubic feet.
Second is for a "Water Weight Calculator" : where 1.3871353296075 cubic feet equals
86.595 pounds of water at 40 degrees Fahrenheit.
Tube Volume Calculator:
Volume Calculator
Water Weight Calculator:
https://www.thecalculatorsite.com/conversions/common/water-weight.php
Maybe this helps a little and does not confuse the answer the OP was looking for?
Anyway, enjoy your Captain Morgan & Dr. Pepper (I do drink Dr. Pepper),
KC
edit: for the water weight calculator you will have to change the "convert from" to Cubic Feet [ft3], and add in 1.3871353296075 for the volume, and change the water temperature to 40F, and then convert to get the pounds of water answer of 86.595, because the link has wiped out this information.