As the Energy Strategy Coordinator on the City of Boulder’s Energy Future team, I assumed responsibility as a project manager to oversee the integration, QC, and operation of Excel-based load and financial models with a HOMER Energy resource modeling tool and DPL decision support software, to enable the city to evaluate the cost and carbon implications of forming a municipal utility. This work involved coordinating with three consulting firms, city staff in multiple departments (particularly IT), and several working groups full of community volunteers. I also managed and worked closely with one of the consultants to integrate probabilistic commodity, interest rate, and operations price forecasts into the model, to identify future risks. The result was a 20-year financial model capable of analyzing the probability that Boulder could form a municipal utility while meeting City Charter requirements related to cost, renewables, and carbon emissions. I developed extensive public documentation, including contributing to City Council memoranda, creating handouts on resource and financial assumptions used in the models, and overseeing a volunteer building a Prezi to demonstrate the modeling process.