Dear Mgautam,
No , it is not the responsibility of managers to work on sunday(pl refer SHOPS AND ESTABLISHEMENT ACT). But yes, they are liable to work on sundays, if they have one weekly off in that week. Try to convince your management that giving comp off in lieu of any weekly off or public off is employees rights and they can not violate the rules.