We find ultimate sharp conditions for the maximal operator associated with generalized spherical mean Radon transform on radial functions to be bounded on power-weighted Lebesgue spaces. Moreover, we also obtain all the corresponding endpoint results, which are optimal power-weighted weak or restricted weak type estimates. These results shed new light on the problem of optimality of the known $L^p$ estimates for the maximal operator in the general non-radial case.