Interplay between single-particle and collective motion within nuclear density functional theory