Renormalized mean-field theory of the neutron scattering in cuprate superconductors