How does band allocation work?

I always wonder how this band's allocation is done within the team. Is it like at least one person in the team will get D or C Band?

Do Managers play this game with any strategy? like why don't they give only either A or B band to everyone in the team?