Water is flowing through a $45^{\circ}$ pipe bend at a rate of $200 \mathrm{gpm}$ and exits into the atmosphere. The inlet to the bend is $1 \frac{1}{2} \mathrm{in}$. inside diameter, and the exit is $1 \mathrm{in}$. in diameter. The friction loss in the bend can be characterized by a loss coefficient of 0.3 (based on the inlet velocity). Calculate the net force (magnitude and direction) transmitted to the flange holding the pipe section in place.