Solve the following problem with Excel Solver: $($Round your answers to the nearest whole number.$)$

Minimize Z $=2$A $+4$B$.$

$4$A $+6$B $>=120$ Resource X

$2$A $+6$B $>=72$ Resource Y

B $>=10$ Resource Z