Revenue Program Development: Sacramento Regional County Sanitation District and Sacramento Area Sewer District

The Sacramento Regional County Sanitation District and the Sacramento Area Sewer District (the Districts) provide wastewater treatment and collection service to over 1.3 million users in northern California. The Districts' CFO relies upon a financial model to project monthly service charges, calculate impact fees and to provide supporting documentation for bond issues by each of the two Districts. In general, the existing model met the needs of the CFO, but had limited forecasting and reporting capability. The existing model was primarily used by the CFO, with limited usage by other managers who maintained separate capital planning workbooks.In order to address these functionality and usage limitations, the Districts decided to develop a centralized program that could be shared across divisions and replace individual desktop models. The desired program needed to be dynamic, yet user-friendly. Further, the program needed to accommodate different types of users, with differing levels of knowledge regarding the District's financial system.