A combined density functional theory and Monte Carlo study of manganites for magnetic refrigeration