the short answer is that it depends.
I did the maths on my situation and it did not work out. It is currently cheaper to pay the $120 / month or so on insurance and maintenance for the second car as opposed to renting a car for the once a month that we actually use the second car.
The trouble is that renting a car is expensive and public transit is an even bigger hassle.