I'm convinced most government agencies cannot manage this type construction in an affordable way, including my home county of Sonoma where we are spending $250k - $350k per homeless person to house them in refurbished hotel rooms (remodeling, not new construction).
I don't know what the solution is, but I have become convinced that local governments cannot build their way out of this. We have to come up with something better.