Loading...
2022/03/22 City Council Resolution 2022-035 RESOLUTION NO. 2022-035 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF ROHNERT PARK AUTHORIZING AND APPROVING THE FINANCE DIRECTOR TO INCREASE APPROPRIATIONS FOR FY 2021-22 WITHIN VARIOUS FUNDS AS INCORPORATED IN EXHIBIT A WHEREAS,the City Council of the City of Rohnert Park adopted the FY 2021-22 Budget on June 8, 2021; and, WHEREAS, the City Council has the authority to amend the budget; and, WHEREAS, the departments were directed to review their budgets in conjunction with the annual mid-year review and were asked to identify operational changes that would impact the remainder of the fiscal year; and WHEREAS, the City Manager has reviewed and recommended the operational changes to be brought forward to the City Council for consideration; and WHEREAS, the restricted funds would only be used in a manner consistent with restrictions; and WHEREAS, appropriations would not exceed the appropriations limit for the 2021-22 fiscal year. NOW, THEREFORE, BE IT RESOLVED by the City Council of the City of Rohnert Park that the foregoing recitals are true and correct and that it does hereby authorize and approve the Finance Director to increase appropriations for FY 2021-22 within various funds and accounts as incorporated in Exhibit A. BE IT FURTHER RESOLVED that the Finance Director is authorized to make any administrative adjustments necessary to process the amendments in accordance with generally accepted accounting principles. DULY AND REGULARLY ADOPTED this 22nd day of March 2022. CITY OF ROHNERT PARK G f Jac e Elwar ATTEST: Elizabeth Machado, Deputy City Clerk Attachments: Exhibits A and B \• GIUDICE: Rte. HOLLINGSWORTH-ADAMS: e, STAFFORD:Fkbs r*f LINARES: j}t,�e ELWARD: {AE_ 1 AYES: ( ) NOES: ( ) ABSENT: ( ) ) ABSTAIN: ( 0 ) City of Rohnert Park Exhibit A 1 of 6 Proposed FY 2021/22 Budget Appropriation Amendments Account Number Funding Source Account Number Amendment Amount General Fund Increase appropriations to fund continuing implementation of Financial System upgrade project in FY21-22 001-1315-300-7001 611-0000-400-8001 $306,000 Increase appropriations to fund City's match for Open Space grant for CIP0719 Crane Creek Trail Project. 310-0719-400-9901 001-1900-400-8310 $107,900 Increase appropriations for Walmart Community Grant 001-P218-400-5210 001-P218-300-3570 $5,000 Increase appropriations to fund increased electricity costs due to enrollment in Sonoma Clean Power Evergreen program 001-1900-400-5220 Projected Savings $40,250 Increase appropriations to fund unanticipated costs for the 2021 special election 001-1900-400-6830 Projected Savings $60,000 Water Enterprise Fund 511-0000-400-5220 511 Fund Balance $26,000 Sewer Enterprise Fund 510-0000-400-5220 510 Fund Balance $6,000 Information Technology Fund Increase appropriations for additional uninterrupted power supplies, switches and phone system upgrades 610-0000-400-5330 610 Fund Balance $68,000 Budget for first payment to upgrade City Hall Servers 610-0000-400-9510 610 Fund Balance $38,000 Technology Replacement Fund Increase appropriations to transfer funds from Infrastructure Fund to Technology Replecement Fund 611-0000-300-7640 640-0000-400-8611 $500,000 Increase appropriations to fund increased electricity costs due to enrollment in Sonoma Clean Power Evergreen program Increase appropriations to fund increased electricity costs due to enrollment in Sonoma Clean Power Evergreen program City of Rohnert Park Exhibit A 2 of 6 Account Number Funding Source Account Number Amendment Amount Capital Projects Fund Release funding from Casino Mitigation for CIP1722 replaced by Neighborhood Upgrade funding already budgeted 310-1722-300-7184 184-1722-400-8310 ($344,605) General Plan Maintenance Fee Decrease appropriations due to carryover unspent contract encumbrance from FY 20-21 103-0000-400-5901 103 Fund Balance ($397,531) Casino Mitigation Fund Reduce transfer from Casino Mitigation to Casino Reserve, originally budgeted to replenish Casino Reserve 187-0000-300-7184 184-0000-400-8187 ($600,000) General Fund Appropriations Amendment $519,150 Enterprise Fund Appropriations Amendment $32,000 Internal Service Fund Appropriations Amendment $606,000 Capital Project Fund Appropriations Amendment ($344,605) Special Revenue Fund Appropriations Amendment ($997,531) City of Rohnert Park Exhibit B Mid-Year Report Expenses % Spent from Revised Budget 3 of 6 Fund Fund Name Adopted Budget Final Budget YTD Actual % Spent* 001 General Fund 44,804,263 70,944,276 43,350,668 61.1% 100 Alcohol Beverage Sales (ABSO) 72,196 72,196 22,683 31.4% 101 Abandoned Veh Abatement (AVA)122,321 122,321 39,664 32.4% 102 Traffic Safety Fund 60,000 60,000 - 0.0% 103 Gen Plan Maintenance Fee Fund 650,000 1,047,531 53,261 5.1% Increase Spay and Neuter Fund 16,000 20,738 12,951 62.4% 106 State Asset Forfeiture SRF 150,000 150,000 - 0.0% Increase PAC Facility Capital Reserve F 17,500 42,500 3,980 9.4% 109 Sports Ctr Capital Facility Rese 77,350 107,350 16,012 14.9% 111 Community Srvcs Facility Fee 15,000 25,000 - 0.0% 112 Measure M Parks 406,162 671,162 152,938 22.8% 125 Refuse Road Impact Fee - 318,923 138,350 43.4% 130 Gas Tax Fund(2105, 2106, 2107)775,000 2,131,158 635,977 29.8% 131 Gas Tax 2107.5 (Admin & Eng) 25,000 25,000 - 0.0% 132 Gas Tax SB1 RMRA Sec2031 - 1,412,295 212,295 15.0% 135 Measure M - Traffic - 1,048,470 106,419 10.1% 140 Senior Center Bingo Fund 390,402 390,402 11,015 2.8% 147 Affordable Linkage Developer Fee 85,922 85,922 - 0.0% 148 Affrdbl Hsng Residential Fee - 185,250 1,433 0.8% 150 Traffic Signals Fund Developer Fee 3,000 388,799 38,644 9.9% 151 Maintenance Annuity Fund 9,042,250 9,042,250 13,039 0.1% 152 Regional Traffic Fee Fund 413,000 461,647 - 0.0% 157 CDA $1 per Bus Lic 5,000 5,000 - 0.0% 164 PFFP 03 Admin Developer Fee 259,407 259,407 129,704 50.0% 165 Public Facility Finance Developer Fee 1,079,014 9,394,410 515,982 5.5% 170 Measure M Fire Fund 707,000 707,000 356,251 50.4% 172 SLESF Fund 150,000 150,000 75,000 50.0% 173 DIVCA AB2987 - PEG FEES FUND 105,000 600,000 29,712 5.0% 175 Casino SEA Fund Sec.2.2 634,185 634,185 231,223 36.5% 176 Casino CRPUSD 1,247,598 1,247,598 316,153 25.3% Increase Wilfred Widening Maintenc JEPA 210,782 218,946 83,553 38.2% 181 Casino Problem Gambling 125,000 140,000 49,497 35.4% 183 Casino Public Service 4,676,771 4,686,613 2,330,193 49.7% Release f Casino Mitigation Supplemntl 6,288,179 8,369,092 436,362 5.2% 187 Casino Reserve - 2,000,000 - 0.0% 188 Tribe Charity (non guarantee)1,247,598 1,247,598 456,842 36.6% Decrease Neighbrhd Upgrd WkFrce Hsng 1,897,758 2,248,673 500,129 22.2% 190 Rent Appeals Board-RAB 130,632 130,632 1,268 1.0% 191 Copeland Creek Drainage Developer Fee 2,265 2,265 - 0.0% 193 CFD Assessment 610,176 610,176 306,640 50.3% 194 SESP Add'l PS Personnel Fee 145,000 145,000 72,500 50.0% 195 SESP Regional Traffic Fee Fund 500,000 500,000 - 0.0% Reduce t Five Creek SP CFD Fund 223,000 223,000 111,500 50.0% 234 2017 Sewer Refunding Bond 2005 698,450 698,450 136,854 19.6% 310 Capital Projects Fund 802,265 28,403,792 1,476,753 5.2% 325 2007 R Bond Proceeds - 56,652 11,231 19.8% City of Rohnert Park Exhibit B Mid-Year Report Expenses % Spent from Revised Budget 4 of 6 Fund Fund Name Adopted Budget Final Budget YTD Actual % Spent* 510 Sewer Utility Fund 15,701,726 19,999,592 6,444,291 32.2% 511 Water Utility Fund 8,305,927 9,881,990 3,135,774 31.7% 512 Refuse Utility Fund 30,000 70,000 5,000 7.1% 515 Recycled Water Utility Fund 412,904 527,904 177,386 33.6% 519 Water Capacity Developer Fee - 1,610,805 19,170 1.2% 530 Sewer - Capital Preservation 265,000 2,521,086 9,539 0.4% 531 Water - Capital Preservation 500,000 1,741,996 77,081 4.4% 540 Sewer Capital Project Fund - 6,279,821 35,090 0.6% 541 Water Capital Project Fund 650,000 5,095,821 276,897 5.4% 545 Recycled Water Capital Fund - 151,664 - 0.0% 560 Golf Course Enterprise Fund 77,432 117,189 19,276 16.4% 610 ISF - Information Technology 1,548,977 1,991,321 717,108 36.0% 611 ISF - Technology Replacement 622,617 813,131 4,600 0.6% 620 ISF - Vehicle Replacement 245,000 245,000 - 0.0% 630 ISF - Fleet 780,646 780,646 371,187 47.5% 640 ISF - Infrastructure - 4,624,283 104,232 2.3% 710 RP Foundation Trust Fund 1,577,980 1,577,980 283,959 18.0% 911 Successor Agency Housing Fund 524,008 553,798 196,083 35.4% 912 Successor Agency to the CDC 4,488,788 4,488,788 3,085,066 68.7% 952 1999 TABS-RSA 1,754,300 1,754,300 908,342 51.8% 955 2018 TABS Refunding Bonds-A 1,545,544 1,545,544 60,139 3.9% City of Rohnert Park Exhibit B Mid-Year Report Revenues * % Recieved from Revised Budget 5 of 6 Fund Fund Name Adopted Budget Final Budget Actual % Received 001 General Fund (44,804,263) (45,571,422) (21,503,154) 47.2% 100 Alcohol Beverage Sales (ABSO) (25,725) (25,725) (297) 1.2% 101 Abandoned Veh Abatement (AVA)(60,900) (60,900) (25,447) 41.8% 102 Traffic Safety Fund (61,000) (61,000) (24,378) 40.0% Increa Gen Plan Maintenece Fee Fund (266,176) (266,176) (140,604) 52.8% 104 Spay and Neuter Fund (15,800) (15,800) (6,455) 40.9% Increa PAC Facility Capital Reserve F (20,000) (20,000) (12,207) 61.0% 109 Sports Ctr Capitl Faciliy Rese (72,500) (72,500) (32,039) 44.2% 111 Community Srvcs Facility Fee (15,100) (15,100) (9,034) 59.8% 112 Measure M Parks (450,000) (450,000) (161,376) 35.9% 113 #N/A (39,050) (39,050) (24,580) 62.9% 130 Gas Tax Fund(2105, 2106, 2107)(1,086,739) (1,086,739) (437,830) 40.3% 131 Gas Tax 2107.5 (Admin & Eng) (6,100) (6,100) (6,033) 98.9% 132 Gas Tax SB1 RMRA Sec2031 (850,047) (850,047) (290,925) 34.2% 135 Measure M - Traffic (346,736) (346,736) (105,993) 30.6% 140 Senior Center Bingo Fund (352,815) (352,815) (28,211) 8.0% 147 Affordable Linkage Developer Fee (181,969) (181,969) (154) 0.1% 148 Affrdbl Hsng Residential Fee (342,252) (342,252) (252,919) 73.9% 150 Traffic Signals Fund Developer Fee (3,000) (3,000) (368) 12.3% 151 Maintenance Annuity Fund (1,761,201) (1,761,201) (547,141) 31.1% 152 Regional Traffic Fee Fund (413,858) (413,858) (210,128) 50.8% 156 Strong Motion (759) (759) (64) 8.4% 157 CDA $1 per Bus Lic (3,860) (3,860) (751) 19.5% 158 Buildg Standard Sp Rev SB1473 (208) (208) (524) 251.9% 164 PFFP 03 Admin Developer Fee (158,646) (158,646) (902) 0.6% 165 PublicFacility Finance Developer Fee (5,166,855) (5,166,855) (3,458,378) 66.9% 170 Measure M Fire Fund (719,189) (719,189) (404,275) 56.2% 172 SLESF Fund (150,000) (150,000) (164) 0.1% 173 DIVCA AB2987 - PEG FEES FUND (57,700) (57,700) (28,728) 49.8% Increa Casino SEA Fund Sec.2.2 (623,805) (623,805) (158,234) 25.4% 176 Casino CRPUSD (1,247,598) (1,247,598) (316,153) 25.3% 181 Casino Problem Gambling (157,450) (157,450) (39,916) 25.4% Releas Casino Waterway (62,840) (62,840) (15,916) 25.3% 183 Casino Public Service (4,047,437) (4,047,437) (749,259) 18.5% 184 Casino Mitigation Supplemntl (6,241,992) (6,241,992) (1,627,862) 26.1% Decre Casino Reserve (1,919,000) (1,919,000) (3,434) 0.2% 188 Tribe Charity (non guarantee)(1,247,598) (1,247,598) (316,153) 25.3% 189 Neighbrhd Upgrd WkFrce Hsng (1,252,598) (1,252,598) (317,740) 25.4% 190 Rent Appeals Board-RAB (99,831) (99,831) (243) 0.2% 193 CFD Assessment (610,934) (610,934) (513,387) 84.0% 194 SESP Add'l PS Personnel Fee (50,588) (50,588) (29,720) 58.7% Reduc SESP Regional Traffic Fee Fund (152,400) (152,400) (21,078) 13.8% 196 SESP Valley House Mitigation Fund (74,600) (74,600) (5,206) 7.0% 197 Five Creek SP CFD Fund (61,865) (61,865) (222) 0.4% 234 2017 Sewer Refunding Bond 2005 (698,450) (698,450) (164,225) 23.5% 310 Capital Projects Fund (1,805,265) (28,362,374) (998,747) 3.5% 430 Permanent-Spreckles Donations (43,600) (43,600) (4,917) 11.3% 431 Permanent Spreckels Endowment (35,000) (35,000) - 0.0% City of Rohnert Park Exhibit B Mid-Year Report Revenues * % Recieved from Revised Budget 6 of 6 Fund Fund Name Adopted Budget Final Budget Actual % Received 510 Sewer Utility Fund (15,033,200) (15,033,200) (5,702,795) 37.9% 511 Water Utility Fund (8,711,800) (8,711,800) (3,939,557) 45.2% 515 Recycled Water Utility Fund (482,200) (482,200) (243,324) 50.5% 519 Water Capacity Developer Fee (846,391) (846,391) (508,190) 60.0% 530 Sewer - Capital Preservation (924,000) (924,000) (392,847) 42.5% 531 Water - Capital Preservation (990,800) (990,800) (458,788) 46.3% 535 Recycled Water-Cptl Prsrvation (11,750) (11,750) (5,388) 45.9% 540 Sewer Captial Project Fund - (6,279,821) (28,289) 0.5% 541 Water Capital Project Fund (650,000) (5,095,821) (345,888) 6.8% 545 Recycled Water Capital Fund - (151,664) - 0.0% 560 Golf Course Enterprise Fund (105,200) (105,200) (32,632) 31.0% 610 ISF - Information Technology (1,506,740) (1,697,254) (754,257) 44.4% 611 ISF - Technology Replacement (48,072) (48,072) (24,913) 51.8% 620 ISF - Vehicle Replacement (1,219,962) (1,219,962) (557,612) 45.7% 630 ISF - Fleet (704,811) (704,811) (352,504) 50.0% 631 Fleet Cpt'l & Maint Reserve (72,500) (72,500) (72,500) 100.0% 640 ISF - Infrastructure (2,700,000) (2,700,000) (1,353,270) 50.1% 710 RP Fountation Trust Fund (1,280,488) (1,280,488) (325,135) 25.4% 905 American Rescue Plan (8,148,583) (8,148,583) (5,182,869) 63.6% 911 Successor Agency Housing Fund (50,420) (50,420) (11,182) 22.2% 912 Successor Agency to the CDC (3,559,477) (3,559,477) (468,801) 13.2% 952 1999 TABS-RSA (1,755,700) (1,755,700) (1,754,254) 99.9% 955 2018 TABS Refunding Bonds-A (1,545,544) (1,545,544) (1,205,834) 78.0%