Weighted trapezoidal inequalities related to the area balance of a function with applications