What is the rationale for prohibiting management prerogative in a collective agreement?

Because "management prerogative" usually means acting without consulting workers, or acting in a way that may be detrimental to workers.