Sunnyvale City Council
December 13, 2022

City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2022
Fund 1000 - General Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2022/23
Operating Programs
City Attorney
10100 Comprehensive Legal Services 1,641,769$ 1 ,708,388$ ( 66,619)$ -$ Total City Attorney 1,641,769 1,708,388 ( 66,619) - City Manager
10200 Office of the City Manager 5,165,085 4 ,643,639 5 21,447 - Total City Manager 5,165,085 4,643,639 5 21,446 - Community Development
10400 Planning 759,880 5 87,827 1 72,053 - 10600 Community Development Department Management 750,200 7 37,893 1 2,308 - Total Community Development 1,510,080 1,325,720 1 84,360 - Environmental Services
14700 Regulatory Programs 1,147,562 1 ,062,817 8 4,745 - 14900 Environmental Sustainability 796,323 4 79,502 3 16,821 - 15100 Stormwater Collections 472,763 4 06,212 6 6,552 - Total Environmental Services 2,416,648 1,948,531 4 68,117 - Finance
10700 Audit 44,203 - 4 4,203 - 10800 Non-Utility Revenue Management and Special Projects 709,335 6 96,953 1 2,383 - 10900 Budget Management 1,226,661 9 89,727 2 36,934 - 11000 Purchasing 1,861,155 1 ,825,874 3 5,281 - 11100 Financial Management and Analysis 1,303,610 1 ,272,458 3 1,152 - 11200 Accounting and Financial Services 1,846,022 1 ,777,572 6 8,450 - 11300 Utility Billing 3,459,651 3 ,259,473 2 00,178 - Total Finance 10,450,638 9,822,058 6 28,580 - Human Resources
11400 Human Resources 4,617,834 4 ,128,516 4 89,317 - Total Human Resources 4,617,834 4,128,516 4 89,318 - Library and Recreation Services
11900 Library 9,319,564 9 ,026,052 2 93,512 - 12000 Recreation Services 8,738,761 8 ,038,056 7 00,705 - Total Library and Recreation Services 18,058,325 17,064,109 9 94,216 - Public Safety
12100 Police Services 29,040,227 2 8,231,743 8 08,484 - 12200 Fire Services 29,970,234 3 1,560,678 ( 1,590,444) - 12300 Community Safety Services 3,087,239 3 ,087,529 ( 290) - 12400 Personnel and Training 2,585,572 2 ,429,222 1 56,350 - 12500 Investigation Services 4,485,315 4 ,577,146 ( 91,831) - 12600 Communication Services 4,340,053 4 ,462,514 ( 122,461) - 12700 Public Safety Administrative Services 6,214,640 6 ,167,825 4 6,814 - 12800 Records Management and Property Services 2,334,146 2 ,091,225 2 42,921 - 12900 Fire Prevention and Hazardous Material Services 2,308,403 1 ,896,317 4 12,086 - 13000 Community Preservation Services - - - Total Public Safety 84,365,828 84,504,200 ( 138,372) - Public Works
13100 Transportation and Traffic Services 2,982,611 2 ,796,657 1 85,954 - 13200 Pavement Maintenance and Concrete Maintenance 4,686,111 3 ,951,067 7 35,044 - 13300 Street Lights, Signs and Debris 2,476,535 2 ,048,925 4 27,610 - Description
Fund 1000
Attachment 1

City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2022
Fund 1000 - General Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2022/23Description
13400 Urban Forestry 1,571,837 1 ,403,392 1 68,444 - 13600 Neighborhood Parks and Open Space Management 11,214,331 1 0,583,004 6 31,327 - 13700 Public Works Administration and Property Management 721,183 7 29,832 ( 8,649) - Total Public Works 23,652,608 21,512,876 2 ,139,732 - Projected Savings
Gas Tax Offset for 13200 Pavement Program (1,500,000) (1,064,216) ( 435,784) - Total Operating Programs 150,378,815 145,593,821 4 ,784,994 - Debt Service
70100 Civic Center Bonds Trustee/Investment Mgmt Fee 5,055,425 5 ,055,425 - - Total Debt Service 5,055,425 5,055,425 - - Lease Payments
00001 Financial Services - 4 4,104 ( 44,104) - 00001 Lease Expenditure - Principal 1,248,210 1 ,241,250 6 ,960 - Total Lease Payments 1,248,210 1,285,354 ( 37,144) - Non-Departmental Expenditures
COVID-19 Emergency Expenditures - 144,661 ( 144,661) - Total Non-Departmental Expenditures - 144,661 ( 144,661) - Transfers Out
580511 General Services Fund - Fleet 480,786 4 80,786 - - 580511 General Services Fund - Proj Mgmt Serv 550,205 4 84,837 6 5,368 - 580511 Employee Payroll & Benefits Fund - Insurance 7,649,615 7 ,649,615 - - 580511 Employee Payroll & Benefits Fund - Pension Trust 1,405,458 1 ,405,458 - - 580511 Employee Payroll & Benefits Fund - Leaves 437,653 4 37,653 - - 580511 Employee Payroll & Benefits Fund - Retirement 20,603,124 2 0,603,124 - - 580511 Infrastructure Fund - General Assets 15,465,024 1 5,465,024 - - 580511 Liability and Property Insurance Fund 2,582,859 2 ,582,859 - - 580511 Youth and Neighborhood Services Fund 598,091 5 98,091 - - 580511 Community Recreation Fund - Golf 1,535,000 1 ,535,000 - - -
Total Transfers Out 51,307,815 51,242,446 6 5,369 - Equipment
P20000 General Equipment 50,000$ 49,998$ 2$ -$ P20802 Recreation Equipment 111,485 29,199 8 2,286 3 5,940 P20901 Public Safety Equipment 358,370 313,941 4 4,428 4 4,428 Total Equipment 519,855 393,139 1 26,716 8 0,368 Projects
Infrastructure Projects
818700 Corporation Yard Buildings - Rehabilitation 22,411 3 ,250 1 9,161 - 820130 Routine Resurfacing of City Owned Parking Lots 190,992 - 1 90,992 1 90,992 820140 Computer/Radio Controlled Landscape Median Irrigation 1,337,339 1 ,337,339 - - 822752 Storm Pump Station Number 1 Rehabilitation - - - - 822762 Storm Pump Station Number 2 Rehabilitation 16,641 1 1,573 5 ,068 5 ,068 824780 Upgrading of Fuel Stations 1,194,973 - 1 ,194,973 1 ,194,973 825290 Pavement Rehabilitation 4,375,655 - 4 ,375,655 4 ,375,655 825362 Replacement/Repair/Rehabilitation of Storm Drain 1,295,277 8 9,821 1 ,205,456 1 ,205,456 825730 Pedestrian Lighted Crosswalk Maintenance and Replacement 902,020 1 91 9 01,829 9 01,829 829400 Sidewalk, Curb and Gutter Replacement 1,499,483 3 94,446 1 ,105,036 1 ,105,036 831340 Civic Center Modernization 4,694,816 2 48,875 4 ,445,940 4 ,445,940 831580 ADA Projects and Emergency Concrete Replacement 91,365 - 9 1,365 - 831770 Illuminated Street Sign Replacement Project 325,089 - 3 25,089 3 25,089 833750 Public Safety Emergency Generator Replacement 2,511,367 1 31,114 2 ,380,253 2 ,380,253 Fund 1000
Attachment 1

City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2022
Fund 1000 - General Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2022/23Description
833030 Pavement Standards 47,009 4 2,571 4 ,438 4 ,438 833810 Traffic Signal Maintenance Services Augmentation 507,628 1 78,426 3 29,202 2 00,000 Outside Group Funding Projects
803700 Leadership Sunnyvale [GF] 6,000 2 ,583 3 ,417 - 819720 Outside Group Funding Support [GF] 305,000 2 90,077 1 4,923 830630 Dispute Resolution Services 45,000 4 5,000 - - 832380 Iizuka Sister City Engagement Funding 12,500 6 ,000 6 ,500 6 ,500 836020 A Sunny Place for Growing Readers 88,316 - 8 8,316 8 8,316 Capital Projects
802150 Utility Undergrounding Cost Sharing 405,355 - 4 05,355 4 05,355 826730 Underground Overhead Utilities 684,457 2 5,005 6 59,452 6 59,452 826790 Sunnyvale Avenue Median (Iowa to Washington) 247,925 - 2 47,925 2 47,925 830590 Corporation Yard Site Feasibility and Modernization Plan 41,733 - 4 1,733 4 1,733 830600 Lakewood Branch Library Facility 1,000,000 - 1 ,000,000 1 ,000,000 831320 RDA Counsel Fees - 2 ,159 ( 2,159) - 831511 Green Stormwater Infrastructure Implementation - General Fund 242,869 2 8,007 2 14,862 2 14,862 831600 Solar Installations on City Facilities 40,823 - 4 0,823 - 831650 ADA Transition Plan 28,378 - 2 8,378 - 832330 Grade Separation Caltrain Crossings at Mary Ave. Study Issue 387,209 1 87,427 1 99,782 1 99,782 832590 Installation of Charging Stations for Electric Vehicles 45,459 1 5,809 2 9,649 2 9,649 832600 Library LED Lighting Conversion 7,500 - 7 ,500 - 832690 Library Restroom Renovation 1,748,239 - 1 ,748,239 4 20,000 832870 Fire Station Master Plan 667,064 2 5,500 6 41,564 - 832880 Active Transportation Plan Update 50,000 - 5 0,000 - 832890 Traffic Signal Specifications and Standard Details 50,415 1 9,228 3 1,188 3 1,188 832920 East Sunnyvale Area Transportation Improvements Total - 4 62 ( 462) - 832930 Fair Oaks Avenue Bike Lanes and Streetscape - Phase 2 - 8 ( 8) - 832960 Lawrence Station Area Sidewalks and Bicycle Facilities - 4 63 ( 463) - 832970 Peery Park Transportation Improvements 713,082 8 ,414 7 04,668 7 04,668 832990 Sunnyvale Traffic Signal Upgrades 111,020 2 7,210 8 3,810 8 3,810 834340 Corn Palace Park Maintenance 15,000 - 1 5,000 - 834350 344 Charles Street Renovation 39,156 5 ,000 3 4,156 3 4,156 834370 Traffic Sign Installation and Maintenance 130,783 1 3,218 1 17,565 1 17,565 834500 Homestead Road Full Time Bicycle Lane Study 150,000 3 3,266 1 16,734 1 16,734 834700 Green Bike Lane Maintenance 35,000 - 3 5,000 3 5,000 834710 Civic Center Phase 2 Planning - Main Library 300,000 1 ,095 2 98,905 2 98,905 835210 Improve Bicycle and Pedestrian Access at Sunnyvale Caltrain 383,423 - 383,423 3 83,423 835220 Bike Rack Installation Program in Commercial Areas 17,116 3 31 1 6,785 1 6,785 835660 Pedestrian & Bicyle Facility Installation on Tasman 200,000 - 2 00,000 2 00,000 835840 Manzano Way Park Maintenance 15,000 - 1 5,000 - Special Projects
804201 City-wide Aerial Photos 8,528 8 ,528 - - 805150 Library Foundation Program Grant 48,608 - 4 8,608 4 8,608 821010 Maintenance of City Owned Properties - Downtown 18,000 3 ,777 1 4,223 - 825070 Bicycle Map Revision 4,807 3 ,571 1 ,236 - 825400 Update of Standard Specifications and Details 5,463 - 5 ,463 5 ,463 825570 239 - 241 Commercial Street Property Maintenance 11,034 9 1 1,025 - 825700 General Plan Updates 238,733 6 ,381 2 32,352 2 32,352 825962 SCVURPPP Contracting and Fiscal Agent - General Fund 55,000 1 7,720 3 7,280 - 826350 FY 18-19 Recruitment and Training for Sworn Officers 343,949 3 30,108 1 3,841 - 829140 Fire Station Electrical Systems and Roll Up Door Replacement 82,752 - 8 2,752 8 2,752 829510 Emergency Medical Dispatch First Responder Incentive Funding 378,431 5 1,861 3 26,569 3 26,569 829620 Downtown Association 40,000 2 8,697 1 1,303 - 829630 Council Set Aside 100,000 - 1 00,000 - 830660 EMS Patient Care Data System 69,843 5 7,425 1 2,417 1 2,417 830980 Comprehensive Update of the Precise Plan for El Camino Real 75,161 8 3,307 ( 8,146) - 831290 Climate Action Plan Implementation 882,200 6 1,219 8 20,982 8 20,982 831310 Minimum Wage Enforcement Agreement 15,000 1 5,000 - - 831490 Website Redesign Implementation, Upgrades and Maintenance 124,497 4 9,383 7 5,114 7 5,114 831980 Annual State of the City 21,017 1 8,190 2 ,827 - 832160 Eng. Services for Transportation Related Projects/Priorities 951,606 3 90,347 5 61,259 5 61,259 832220 Fire Prevention (Non HazMat) Technology Project 25,873 3 14 2 5,559 2 5,559 Fund 1000
Attachment 1

City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2022
Fund 1000 - General Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2022/23Description
832230 Fire Prevention (HazMat) Technology Project 14,221 6 ,685 7 ,535 7 ,535 832260 Office of Emergency Services 115,954 5 5,151 6 0,803 6 0,803 832290 Safe Routes to School Program 58,000 - 5 8,000 3 4,302 832401 Silicon Valley Healthy Aging Partnership (SVHAP) 55,518 3 6,660 1 8,858 1 8,858 832571 AMD Grant Funds to Columbia Neighborhood Center, Year 2 6,000 5 ,662 3 38 - 832640 CAP and Green Building Updates 45,900 - 4 5,900 4 5,900 832660 Economic Development Strategy 16,688 - 1 6,688 1 6,688 832670 Sunnyvale Elections 190,318 7 2,165 1 18,152 3 8,750 833640 2017 Housing Strategy - ( 2,198) 2 ,198 - 833700 Lawrence Station Area Plan - Housing and Sense of Place 156,677 4 7,560 1 09,116 - 833920 Acquiring Control of Caltrans Traffic Signals on El Camino Real 230,753 1 29,105 1 01,648 - 833940 Orchard Heritage Park and Museum Analysis Study 350,000 - 3 50,000 3 50,000 833950 Analysis of Sunnyvale Golf Program Subsidy 15,885 - 1 5,885 - 834010 FY 2018/19 Tobacco Decoy Operations 39,000 4 ,388 3 4,612 3 4,612 834110 FY 2019/20 Recruitment and Training for Sworn Officers 2,508,327 1 ,486,250 1 ,022,077 4 00,000 834120 FY 2020/21 Recruitment and Training for Sworn Officers 6,223,438 2 ,946,572 3 ,276,866 3 ,276,866 834130 FY21/22 Recruitment and Training for Sworn Officers 5,996,880 1 ,720,743 4 ,276,137 4 ,276,137 834140 FY22/23 Recruitment and Training Costs for Sworn Officers - 3 ,415 ( 3,415) - 834240 Digital Literacy 229,568 4 3,279 1 86,289 1 86,289 834430 Electronic Records Management System 550,875 1 37,319 4 13,556 4 13,556 834440 Organizational Development 53,806 - 5 3,806 5 3,806 834560 GIS Onetime Support 183,917 3 4,749 1 49,168 1 49,168 834640 Interactive Voice Response (IVR) for Utility Billing Call Center 5,000 - 5 ,000 - 834650 Utility Billing Reporting Tool 108 - 1 08 - 834780 Evaluation of Right to Lease Ordinance 60,000 1 ,153 5 8,847 5 8,847 834790 Addition to the Heritage Resource Inventory of Sites Associated with Tech Innovation 75,000 - 75,000 75,000 834800 Responsible Construction Ordinance Study 8,199 - 8 ,199 - 834810 Ascertain Suitable Location(s) for the Installation of Youth Cricket Batting Cages 14,253 11,466 2,786 2,786 834820 Improving Traffic Operations at Fremont/Bernardo/Hwy 85 60,000 - 6 0,000 - 834850 Evaluate Options for Revisions to the Sunnyvale Business License Tax 10,000 - 10,000 - 834980 Finance Transient Occupancy Tax Audit 45,000 - 4 5,000 4 5,000 835010 Green Stormwater Infrastructure Plan Implementation 42,877 1 4,116 2 8,762 - 835110 Electronic ADA Compliance 30,000 - 3 0,000 3 0,000 835150 DPS Reimbursable Mutual Aid (Out of County) - 3 44,389 ( 344,389) ( 344,389) 835160 DPS Police Services Contract Overtime 34,797 ( 34,797) ( 34,797) 835200 Cricket Stadium at Baylands Park 200,000 - 2 00,000 2 00,000 835260 Tasman Drive Temporary Lane Closure 34,241 1 6,168 1 8,073 1 8,073 835290 FY20/21 DPS Crime Reporting and IA/Use of Force Tracking Software 120,361 85,198 35,163 - 835310 FY 2020/21 DPS Traffic Records Improvement 25,000 2 4,800 2 00 - 835320 FY 2020/21 SHSGP Training Grant 45,583 - 4 5,583 4 5,583 835330 FY20/21 DPS OTS Bike/Ped Safety Grant 33,929 2 ,734 3 1,195 - 835340 FY20/21 DPS OTS Selective Traffic Enforcement Program 34,969 30,397 4,572 - 835360 Housing Strategy Implementation - Mobile Home Park MOU 42,655 4 1,432 1 ,223 835370 Fair Oaks Park Unhoused Individuals Relocation and Temporary Housing 160,921 160,921 - - 835690 Creation of Objective Citywide and Specific Area Plan/Citywide Landscape Design Guidelines 310,000 134,100 175,900 175,900 835710 Sunnyvale Community Services Tenant Improvements 1,500,000 1 ,500,000 - - 835720 2023 Housing Element Update 530,059 2 04,333 3 25,726 3 25,726 835730 DPW - JAG Local Funding 30,204 1 3,293 1 6,911 1 6,911 835750 FY21/22 DPS EOC Laptop Replacement 27,003 1 9,498 7 ,505 - 835760 FY21/22 OTS STEP Grant 80,000 4 5,682 3 4,318 3 4,318 835790 DPS FY21/22 DOJ COPS Micro Grant 51,600 1 4,222 3 7,378 3 7,378 835770 Sunny Side Up: Sunnyvale Public Library Mobile Kitchen Cart 13,080 1 3,040 4 0 - 835800 Library Workforce Partnership Initiative 15,000 1 4,628 3 72 3 72 835810 Code Enforcement Activities to Address Substandard Residential 109,862 49,842 60,020 6 0,020 835820 Temporary Housing for Unhoused Individuals 500,000 - 5 00,000 5 00,000 835850 REAP Housing Strategy Implementation 75,000 1 0,024 6 4,976 6 4,976 835620 Cultural Inclusion 135,000 6 2,451 7 2,549 7 2,549 835510 Maintenance of 725 Kifer Rd. (SCS Property) 50,000 3 2,221 1 7,779 - Fund 1000
Attachment 1

City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2022
Fund 1000 - General Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2022/23Description
835490 Community Events & Neighborhood Grants 68,680 4 1,161 2 7,519 2 7,519 835470 Stormwater System Strategic Plan and Funding Evaluation 250,000 - 2 50,000 2 50,000 835640 Housing Mitigation Fee Study 60,000 - 6 0,000 6 0,000 835650 Real Property Tax Ballot Measure Study 50,000 3 3,050 1 6,950 - 835670 Poplar Avenue Sidewalk Study 75,000 - 7 5,000 7 5,000 835680 Smart Cities Initiative Study 125,000 - 1 25,000 1 25,000 835400 Contribution to Our City Forest 15,000 - 1 5,000 1 5,000 Total Projects 52,886,697 13,982,329 3 8,904,368 3 5,161,656 Total Appropriations 261,396,817 217,697,175 4 3,699,642 35,242,024 Equipment Carryover - 80,368 ( 80,368) Capital Projects Carryover - 5,240,993 ( 5,240,993) Infrastructure Projects Carryover - 16,334,730 ( 16,334,730) Special Projects Carryover - 13,491,118 ( 13,491,118) Outside Group Funding Projects Carryover - 94,816 ( 94,816) Total 261,396,817 252,939,199 8 ,457,618
Fund 1000
Attachment 1

City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2022
Fund 1040 - Youth and Neighborhood Services Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2022/23
Operating Programs
Library and Recreation Services
12000 Recreation Services 694,272$ 7 54,275$ ( 60,003)$ -$ Total Library and Recreation Services 694,272 754,275 ( 60,003) - Total Operating Programs 694,272 754,275 ( 60,003) - Projects
Special Projects
835300 ECHD Grant ShapeUp Sunnyvale 301 3 01 - - 835301 ECHD Grant ShapeUp Sunnyvale, Year 2 35,000 3 5,000 - - Total Projects 35,301 35,301 - - Transfers Out
580511 Employee Payroll & Benefits Fund 116,697 1 16,697 - Total Transfer Out 116,697 116,697 - - Total Appropriations 846,270 906,273 ( 60,003) - Total 846,270 906,273 ( 60,003) Description
Fund 1040
Attachment 1

City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2022
Fund 2020 - Housing Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2022/23
Operating Programs
Community Development
10500 Housing MIT and BMR Program 1,011,087$ 8 79,657$ 1 31,430$ -$ Total Community Development 1,011,087 879,657 1 31,430 - Total Operating Programs 1,011,087 879,657 1 31,430 - Transfers Out
580511 General Fund 11,245,263 1 1,245,000 2 63 2 63 580511 Employee Payroll & Benefits Fund 203,675 2 07,671 ( 3,996) - 580511 General Fund - In Lieu 99,101 9 9,101 - - Total Transfers Out 11,548,039 11,551,772 ( 3,733) 2 63 Projects
Special Projects
823750 BMR Compliance Enforcement 116,694 - 1 16,694 1 16,694 825700 General Plan Updates 129,623 1 29,623 1 29,623 825930 Maintain City-Owned Properties - Downtown/388 Charles Street - 5 ,130 ( 5,130) ( 5,130) 826520 Pre-Development Costs on Affordable Housing Sites 65,000 1 5,409 4 9,591 4 9,591 826530 County-wide Homeless Count 10,114 - 1 0,114 1 0,114 828100 First-Time Homebuyer Loans (81-120% AMI) 250,000 1 85,000 6 5,000 6 5,000 832030 Orchard Gardens Apartments Redevelopment 7,500,000 - 7 ,500,000 7 ,500,000 833600 Block 15 - Affordable Housing Site 17,000,000 1 7,000,000 - - Infrastructure
831340 Civic Cener Modernization 181,443 6 ,738 1 74,705 1 74,705 Total Projects 25,252,874 17,212,278 8 ,040,596 8 ,040,596 Total Appropriations 37,812,000 29,643,707 8 ,168,293 8 ,040,859 Project Carryover - 8,040,596 ( 8,040,596) Deferred Transfers Out - 263 ( 263) Total 37,812,000 37,684,566 1 27,434
Description
Fund 2020
Attachment 1

City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2022
Fund 2060 - HOME Grant Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2022/23
Operating Programs
Community Development
10500 Housing and CDBG Program 78,304$ 4 9,903$ 2 8,401$ -$ Total Community Development 78,304 49,903 2 8,401 - Total Operating Programs 78,304 49,903 2 8,401 - Transfers Out
551026 General Fund - In Lieu 5,939 3 ,028 2 ,911 - 580511 Employee Payroll & Benefits Fund 21,006 - 2 1,006 - Total Transfers Out 26,945 3,028 2 3,917 - Projects
Special Projects
828750 Tenant Based Rental Assistance (HOME) 801,239 6 27,845 1 73,394 - 835140 Block 15 Projects 482,837 4 82,837 - - Total Projects 1,284,076 1,110,682 1 73,394 - Total Appropriations 1,389,325 1,163,613 2 25,712 - Total 1,389,325 1,163,613 2 25,712
Description
Fund 2060
Attachment 1

City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2022
Fund 2040 - Community Development Block Grant Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2022/23
Operating Programs
Community Development
10500 Housing and CDBG Program 364,943$ 3 90,177$ ( 25,234)$ -$ Total Community Development 364,943 390,177 (25,234) -
Total Operating Programs 364,943 390,177 (25,234) -
Transfers Out
551026 General Fund - In Lieu 25,342 17,403 7 ,939 - 580511 Employee Payroll & Benefits Fund 81,688 - 8 1,688 - -
Total Transfers Out 107,030 17,403 89,627 -
Projects
Special Projects
803501 CDBG Housing Rehabilitation Revolving Loan Fund 181,284 1 02,501 7 8,783 7 8,783 812701 Home Access, Paint, Emergency Repair, and Energy-Efficiency 50,000 4 3,450 6 ,550 829560 Sunnyvale Workforce Development Program-DST 240,266 2 40,266 - - 835700 SCS Walk-In Cooler/Freezer 100,000 - 1 00,000 - Outside Group Funding Projects
827550 Outside Group Funding Support [CDBG] 203,303 2 00,781 2 ,522 - 835230 2020 Coronavirus Rent Relief and Support 776,165 7 76,165 - - 835550 Mobile Showers and Laundry 50,000 3 2,810 1 7,190 - 835560 Emergency Assistance for Households w/Disabilities 91,671 1 6,878 7 4,793 7 4,793 835570 COVID-19 Testing and Vaccinations 203,930 9 3,044 1 10,886 1 10,886 Capital Projects
832020 ADA Curb Retrofits (CDBG) 334,304 2 31,944 1 02,359 - Total Projects 2,230,923 1,737,839 4 93,084 2 64,462 Total Appropriations 2,702,896 2,145,419 5 57,477 2 64,462 Project Carryover - 264,462 ( 264,462) Total 2,702,896 2,409,881 2 93,015
Description
Fund 2040
Attachment 1

City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2022
Fund 2080 - Redevelopment Housing Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2022/23
Operating Programs
Community Development
10500 Housing and CDBG Program 44,275$ 3 9,409$ 4 ,866$ -$ Total Community Development 44,275 39,409 4 ,866 - Total Operating Programs 44,275 39,409 4 ,866 - Transfers Out
580511 General Fund - In Lieu 3,227 3 ,227 - - 580511 Housing Fund - Mitigation 1,000,000 1 ,000,000 - - 580511 Employee Payroll & Benefits Fund 11,670 1 1,670 - - Total Transfers Out 1,014,896 1,014,896 - - Projects
Special Projects
831761 Homeless Prevention and Rapid Re-Housing (HPRR) 250,000 2 50,000 - - Total Projects 250,000 250,000 - - Total Appropriations 1,309,171 1,304,305 4 ,866 - Total 1,309,171 1,304,305 4 ,866
Description
Fund 2080
Attachment 1

City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2022
Fund 2100 - Park Dedication Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2022/23
Projects
Capital Projects
826710 Washington Community Swim Center 2,924,103$ 9 01,265$ 2 ,022,838$ 1 10,000$ 830510 Plaza del Sol Phase II 2,449,141 1 09,397 2 ,339,744 2 ,339,744 830600 Lakewood Branch Library Facility 2,683,337 1 95,126 2 ,488,211 2 ,488,211 831880 Preschool Outdoor Play Area 458,897 8 1,457 3 77,440 3 77,440 832000 East and West Channel Trail Construction 500,000 - 5 00,000 5 00,000 834680 Las Palmas Tennis Center Needs Assessment 75,000 4 3,549 3 1,451 3 1,451 835830 Manzano Way Park Acquisition 1,150,000 - 1 ,150,000 1 ,150,000 Infrastructure Projects
818550 Park Buildings - Rehabilitation 2,253,520 1 ,722,726 5 30,795 5 30,795 820130 Routine Resurfacing of City Owned Parking Lots 25,428 - 2 5,428 2 5,428 820140 Computer/Radio Controlled Landscape Median Irrigation 929,337 8 27,931 1 01,406 5 0,000 820240 Park Tennis/Basketball Court Reconstruction 679,082 2 73,261 4 05,821 8 5,000 820270 Playground Equipment Replacement 2,464,290 1 02,988 2 ,361,302 2 ,361,302 820280 Park Furniture and Fixtures Replacement 182,515 1 14,406 6 8,109 6 8,109 825850 Swim Pools Infrastructure 69,747 4 ,542 6 5,204 6 5,204 827160 Sunnyvale Tennis Center Court Rehabilitation 16,636 - 1 6,636 - 829150 Swimming Pool Buildings Infrastructure 818,925 3 1,250 7 87,675 7 87,675 829170 Sunken Gardens Driving Range Light Replacement 198,499 1 4,940 1 83,559 - 829440 Land Acquisition Due Diligence 25,400 5 ,808 1 9,592 1 9,592 830310 Community Center Grounds Renovation and Enhancement 1,744,760 2 58,393 1 ,486,367 1 ,486,367 830340 Fair Oaks Park Renovation and Enhancement 8,045,120 7 ,058,534 9 86,586 9 86,586 830490 Fremont Pool Infrastructure Improvements 34,126 - 3 4,126 3 4,126 831340 Civic Center Modernization 23,204,110 5 ,155,000 1 8,049,110 1 8,049,110 831860 John W. Christian Greenbelt Pathway Rehabilitation 547,594 4 76,367 7 1,228 2 0,000 832740 Upgrade Park Pathway Lighting to LED 5,795 1 ,623 4 ,171 - 832770 De Anza Park Pathway Renovation 665,484 5 43,330 1 22,154 1 22,154 832780 All Inclusive Playground 970,965 9 70,378 5 87 - 832800 Performing Arts Center Infrastructure 540,531 8 8,331 4 52,200 4 52,200 834770 Lakewood Park Renovation and Enhancement 2,249,804 - 2 ,249,804 2 ,249,804 Special Projects
829160 Golf Course Tree Trimming and Removal 9,712 - 9 ,712 9 ,712 Total Projects 55,921,858 18,980,603 3 6,941,255 3 4,400,009 Transfers Out
580511 Infrastructure Fund - Golf and Tennis 511,593 - 5 11,593 5 11,593 580511 General Services Fund - Project Management Services 2,625,579 2 ,365,733 2 59,846 - Total Transfers Out 3,137,172 2,365,733 7 71,439 5 11,593 Total Appropriations 59,059,030 21,346,336 3 7,712,694 3 4,911,602 Project Carryover - 34,400,009 ( 34,400,009) Deferred Transfers Out - 511,593 ( 511,593) Total 59,059,030 56,257,938 2 ,801,092
Description
Fund 2100
Attachment 1

City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2022
Fund 2200 - Asset Forfeiture Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2022/23
Operating Programs
Public Safety
12100 Police Services 1,668$ 1 ,668$ -$ -$ Total Public Safety 1,668 1,668 - - Total Operating Programs 1,668 1,668 - - Projects
Capital Projects
819840 Police Services Equipment - Acquisition 33,339 1 6,606 1 6,733 1 6,733 828150 Police Services Equipment - Cell Phones 14,812 - 1 4,812 - Total Projects 48,151 16,606 3 1,545 1 6,733 Total Appropriations 49,819 18,273 3 1,545 1 6,733 Project Carryover - 16,733 ( 16,733) Total 49,819 35,007 1 4,812 Description
Fund 2200
Attachment 1

City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2022
Fund 2220 - Police Services Augmentation Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2022/23
Operating Programs
Public Safety
12500 Investigation Services 332,132$ 3 24,361$ 7 ,770$ -$ -
Total Public Safety 332,132 324,361 7 ,771 - Total Operating Programs 332,132 324,361 7 ,771 - Total Appropriations 332,132 324,361 7 ,771 - Total 332,132 324,361 7 ,771
Description
Fund 2220
Attachment 1

City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2022
Fund 2300 - Employment Development Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2022/23
Operating Programs
NOVA Workforce Services
15300 NOVA Workforce Services Department 10,430,520$ 8 ,533,900$ 1 ,896,620$ -$ Total NOVA Workforce Services 10,430,520 8,533,900 1 ,896,620 - Total Operating Programs 10,430,520 8,533,900 1 ,896,620 - Transfers Out
580511 Employee Payroll & Benefits Fund 69,480 6 9,480 - - Total Transfers Out 69,480 69,480 - - Total Appropriations 10,500,000 8,603,380 1 ,896,620 - Total 10,500,000 8,603,380 1 ,896,620 Description
Fund 2300
Attachment 1

City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2022
Fund 2400 - Parking District Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2022/23
Operating Programs
Public Works
13500 Downtown Parking Lot Maintenance 100,911$ 5 5,473$ 4 5,438$ -$ 13700 Public Works Administration and Property Management 51,838 3 5,521 1 6,317 - Total Public Works 152,749 90,994 6 1,755 - Total Operating Programs 152,749 90,994 6 1,755 - Projects
Infrastructure Projects
831340 Civic Center Modernization 4,749 2 70 4 ,479 4 ,479 Total Projects 4,749 270 4 ,479 4 ,479 Transfers Out
580511 General Fund - In Lieu 13,624 1 3,624 - - 580511 Employee Payroll & Benefits Fund 27,074 2 7,074 - - Total Transfers Out 40,697 40,697 - - Total Appropriations 198,195 131,961 6 6,234 4 ,479 Project Carryover - 4,479 ( 4,479) Total 198,195 136,440 6 1,755 Description
Fund 2400
Attachment 1

City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2022
Fund 2500 - Gas Tax Fund
Description Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2022/23
Operating Programs
Public Works
13200 Pavement and Concrete Maintenance 1,500,000$ 1 ,064,216$ 4 35,784$ -$ Total Public Works 1,500,000 1,064,216 4 35,784 - Total Operating Programs 1,500,000 1,064,216 4 35,784 - Transfers Out
580511 General Services Fund - Project Management Service 388,677 3 41,634 4 7,043 - Total Transfers Out 388,677 341,634 4 7,043 - Projects
Infrastructure Projects
820120 Repaint Street Light Poles 304,528 1 99,959 1 04,569 2 0,000 820180 Traffic Signal Controller Replacement 1,012,539 1 4,525 9 98,014 9 98,014 820190 Traffic Signal Hardware and Wiring 2,065,803 3 ,369 2 ,062,434 2 ,062,434 820200 Traffic Signal Light Emitting Diode (LED) Array Replacements 764,778 5 0 7 64,728 7 64,728 825290 Pavement Rehabilitation 1,349,536 2 8,800 1 ,320,736 1 ,320,736 825340 Street Lights Conduit Replacement 894,696 3 7,792 8 56,904 8 56,904 825730 Pedestrian Lighted Crosswalk Maintenance and Replacement 15,356 7 07 1 4,650 1 4,650 825740 Battery Backup System for Traffic Signals Maintenance 83,811 2 5,585 5 8,226 5 8,226 -
Capital Projects -
831590 Intelligent Transportation Systems 403,939 - 4 03,939 4 03,939 831870 Preventive Maintenance for Various Bridges 331,498 - 3 31,498 3 31,498 832990 Sunnyvale Traffic Signal Upgrades 163,000 - 1 63,000 1 63,000 834550 Speed Feedback Signs Maintenance and Replacement 50,000 5 0,000 - - 835410 Fremont Avenue Traffic Signals Retiming 35,000 - 3 5,000 3 5,000 835420 Hollenbeck Avenue Traffic Signals Retiming 15,000 - 1 5,000 1 5,000 835430 Mary Avenue Traffic Signals Retiming 14,550 - 1 4,550 1 4,550 835440 Remington Drive Traffic Signals Retiming 14,645 - 1 4,645 1 4,645 -
Special Project -
825400 Update of Standard Specifications and Details 5,463 - 5 ,463 5 ,463 Total Projects 7,524,142 360,786 7 ,163,356 7 ,078,788 Total Appropriations 9,412,819 1,766,636 7 ,646,183 7 ,078,788 Project Carryover - 7,078,788 ( 7,078,788) Total 9,412,819 8,845,424 5 67,395
Fund 2500
Attachment 1

City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2022
Fund 2520 - Road Maintenance and Rehabilitation Account (SB1) Fund Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2022/23
Project
Infrastructure Project
825290 Pavement Rehabilitation 5,991,788$ 6 96,183$ 5 ,295,605$ 5 ,295,605$ Total Projects 5,991,788 696,183 5 ,295,605 5 ,295,605 Total Appropriations 5,991,788 696,183 5 ,295,605 5 ,295,605 Project Carryover - 5,295,605 ( 5,295,605) Total 5,991,788 5,991,788 -
Description
Fund 2520
Attachment 1

City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2022
Fund 2540 - Transportation Development Act (TDA) Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2022/23
Projects
Capital Projects
834570 Install Green Bike Lanes 79,734$ -$ 79,734$ 7 9,734$ 835000 Pedestrian & Bicycle Safety Improvements at Fremont Ave. & Manet Drive/Bobwhite Ave. 357,588 57,318 300,270 300,270 835860 Pedestrian/Bicycle Pathway Spot Improvements 156,554 1 ,200 1 55,354 1 55,354 Total Projects 593,876 58,518 5 35,358 5 35,358 Total Appropriations 593,876 58,518 5 35,358 5 35,358 Project Carryover - 535,358 ( 535,358) Total 593,876 593,876 -
Description
Fund 2540
Attachment 1

City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2022
Fund 2560 - 2016 Measure B Santa Clara VTA Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2022/23
Projects
Infrastructure Projects
825290 Pavement Rehabilitation 628,027$ 4 92,100$ 1 35,927$ 1 35,927$ 828030 Annual Slurry Seal of City Streets 563,286 5 06,503 5 6,783 5 6,783 829400 Sidewalk, Curb and Gutter Replacement 1,807,369 7 79,442 1 ,027,927 1 ,027,927 835630 Stevens Creek Trail Extension (W. Remington Ave to W.

Fremont Ave) 3,500,000 1,342 3,498,658 3,498,658 Special Project
835250 Bicycle and Pedestrian Education & Encouragement Program 402,445 2 1,848 3 80,598 3 80,598 Total Projects 6,901,127 1,801,234 5 ,099,893 5 ,099,893 Total Appropriations 6,901,127 1,801,234 5 ,099,893 5 ,099,893 Project Carryover - 5,099,893 ( 5,099,893) Total 6,901,127 6,901,127 -
Description
Fund 2560
Attachment 1

City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2022
Fund 2580 - VRF Local Road Improvement Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2022/23
Project
Infrastructure Project
825290 Pavement Rehabilitation 3,621,098$ 5 0,400$ 3 ,570,698$ 3 ,570,698$ Total Projects 3,621,098 50,400 3 ,570,698 3 ,570,698 Total Appropriations 3,621,098 50,400 3 ,570,698 3 ,570,698 Project Carryover - 3,570,698 ( 3,570,698) Total 3,621,098 3,621,098 -
Description
Fund 2580
Attachment 1

City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2022
Fund 3100 - Capital Projects Fund
Final Budget Actual Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2022/23
Transfers Out
580511 General Fund - In Lieu 16,495$ 1 6,495$ -$ -$ 580511 Capital Project Fund-Traffic Impact Fees 30,113 3 0,113 - - 580511 Infrastructure Fund - General Assets 3,808,343 3 ,808,343 - - 580511 Transfer To Gas Tax Fund 192,403 1 92,403 - - Total Transfers Out 4,047,355 4,047,355 - - Projects
Subfund 3101 - General Assets
Capital Projects
825610 Fair Oaks Avenue Overhead Bridge 10,550,328 8 ,322,342 2 ,227,986 2 ,227,986 826710 Washington Community Swim Center 57 5 7 - - 830600 Lakewood Branch Library Facility 23,340,471 3 02,390 2 3,038,081 2 3,038,081 832910 Bernardo Avenue Bicycle Undercrossing Environmental Analysis 350,534 7 4,108 2 76,427 2 76,427 832920 East Sunnyvale Area Transportation Improvements 2,686,443 6 7,926 2 ,618,517 2 ,618,517 832930 Fair Oaks Avenue Bike Lanes and Streetscape - Phase 2 624,171 3 89,601 2 34,571 1 76,000 832950 Java Drive Road Diet and Bike Lanes 443,798 1 01,223 3 42,575 3 42,575 832960 Lawrence Station Area Sidewalks and Bicycle Facilities 383,763 2 8,850 3 54,913 3 54,913 832970 Peery Park Area Transportation Improvements 2,682,546 3 1,436 2 ,651,110 2 ,651,110 832990 Sunnyvale Traffic Signal Upgrades 2,433,027 1 6,340 2 ,416,688 2 ,416,688 833000 Sunnyvale SNAIL Neighborhood Improvements - ATP 4,844,149 4 9,695 4 ,794,454 4 ,794,454 833790 Pedestrian and Bicyclist Infrastructure Improvements 918,789 - 9 18,789 9 18,789 833800 Pedestrian/Bicycle Improvement-Homestead Rd at Homestead 957,795 896,219 61,575 6 1,575 833850 Sunnyvale Safe Routes to School Improvements 1,833,000 2 86,549 1 ,546,451 1 ,546,451 833890 Mary Ave Caltrain Tracks Cross Safety 559,267 5 58,018 1 ,249 1 ,249 834250 Advanced Dilemma Zone Detection Phase 2 - Highway Safety 1,167,111 14,447 1,152,665 1 ,152,665 834520 Tasman-Java LRT Corridor Signal Timing 64,938 4 3,560 2 1,378 3 ,574 834530 Maude Avenue Corridor Signal Timing 26,503 1 5,719 1 0,783 1 ,230 834540 Mathilda-Sunnyvale-Saratoga Corridor Signal Timing 135,457 1 06,958 2 8,500 9 ,239 835060 Duane Avenue Traffic Signals Retiming 32,395 2 5,574 6 ,821 2 ,208 835070 Wolfe Road Traffic Signals Retiming 82,293 6 4,979 1 7,315 5 ,613 835080 Homestead Road Traffic Signals Retiming 43,123 3 4,046 9 ,077 2 ,940 835090 Bernardo Avenue Traffic Signals Retiming 28,372 2 2,403 5 ,969 1 ,935 835100 Kifer Road Traffic Signals Retiming 27,596 2 1,787 5 ,809 1 ,882 835410 Fremont Avenue Traffic Signals Retiming 315,000 - 3 15,000 3 15,000 835420 Hollenbeck Avenue Traffic Signals Retiming 135,000 - 1 35,000 1 35,000 835430 Mary Avenue Traffic Signals Retiming 130,950 - 1 30,950 1 30,950 835440 Remington Drive Traffic Signals Retiming 131,805 - 1 31,805 1 31,805 835870 Sunnyvale Quick Build Bicycle, Pedestrian and Safe Routes to School Safety Improvements 1,900,000 - 1,900,000 1,900,000 835900 TFCA Moffett Park Drive/Innovation Way Corridor Retiming 492,650 - 4 92,650 4 92,650 Total Subfund 3101 - General Assets 57,321,333 11,474,226 4 5,847,107 4 5,711,505 Subfund 3105 - Community Benefits
Special Project
835210 Improve Bicycle and Pedestrian Access at Sunnyvale Caltrain 49,677 - 49,677 4 9,677 835390 Peery Park Rides Shuttle Program 500,000 - 5 00,000 5 00,000 Total Subfund 3105 - Community Benefits 549,677 - 5 49,677 5 49,677 Operations 132,455 131,308 1 ,147 - Total Subfund 3107 - Capital Projects/City of Santa Clara - Calabazas Creek Bridge Fund 132,455 131,308 1,147 - Subfund 3109 - Traffic Mitigation Projects
Capital Project
816000 Future Traffic Signal Construction 105,368 3 2,155 7 3,213 7 3,213 Total Subfund 3109 - Traffic Mitigation Projects 105,368 32,155 7 3,213 7 3,213 Description
Subfund 3107 - Capital Projects/City of Santa Clara - Calabazas Creek Bridge Fund
Fund 3100
Attachment 1

City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2022
Fund 3100 - Capital Projects Fund
Final Budget Actual Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2022/23Description
Subfund 3111 - Transportation Impact Fees
Special Projects
825530 Transportation Model Update 158,199 7 4,367 8 3,833 8 3,833 835740 Acquisition of 970 W. Evelyn Avenue 8,580,000 8 ,486,130 9 3,870 - Capital Projects
830640 Stevens Creek Trail Extension (Dale/Heatherstone to Remington) 776,868 - 776,868 776,868 832440 Mary Avenue Overcrossing Environmental Impact Report 407,238 5 3,905 3 53,333 3 53,333 832910 Bernardo Avenue Bicycle Undercrossing Environmental Analysis 492,682 50,175 442,507 442,507 832920 East Sunnyvale Area Transportation Improvements 773,529 1 7,583 7 55,945 7 55,945 832930 Fair Oaks Avenue Bike Lanes and Streetscape - Phase 2 165,944 3 9,196 1 26,748 4 4,000 832950 Java Drive Road Diet and Bike Lanes 116,407 2 7,330 8 9,077 8 9,077 832960 Lawrence Station Area Sidewalks and Bicycle Facilities 101,957 7 ,220 9 4,737 9 4,737 833000 Sunnyvale SNAIL Neighborhood Improvements - ATP 1,211,287 1 2,424 1 ,198,863 1 ,198,863 833010 Bicycle and Pedestrian Safety Improvements 600,137 - 6 00,137 6 00,137 833020 Future Traffic Signal Construction 845,845 2 ,500 8 43,345 8 43,345 833790 Pedestrian and Bicyclist Infrastructure Improvements 243,466 1 72,735 7 0,731 7 0,731 833800 Pedestrian/Bicycle Improvement-Homestead Rd at Homestead 104,402 104,402 - - 833850 Sunnyvale Safe Routes to School Improvements 458,565 5 6,762 4 01,803 4 01,803 834490 Enhanced Crosswalk on California Avenue at Pajaro Avenue 148,000 - 1 48,000 1 48,000 835000 Pedestrian & Bicycle Safety Improvements at Fremont Ave. & Manet Drive/Bobwhite Ave. 8,000 - 8,000 8,000 835630 Stevens Creek Trail Extension (W. Remington Ave to W.

Fremont Ave) 389,000 - 389,000 389,000 Infrastructure Projects
829400 Sidewalk, Curb, and Gutter Replacement 99,000 - 9 9,000 9 9,000 831340 Civic Center Modernization 1,244,300 - 1 ,244,300 1 ,244,300 Total Subfund 3111 - Transportation Impact 16,924,826 9,104,729 7 ,820,097 7 ,643,479 Total Projects 75,033,659 20,742,418 5 4,291,241 5 3,977,874 Total Appropriations 79,081,014 24,789,773 5 4,291,241 5 3,977,874 Project Carryover - 53,977,874 ( 53,977,874) Total 79,081,014 78,767,647 3 13,367
Fund 3100
Attachment 1

City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2022
Fund 3200 - Infrastructure Fund
Description Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2022/23
Projects
Capital Projects
825610 Fair Oaks Avenue Overhead Bridge Repair 1,800,909$ 135,940$ 1,664,969$ 1,664,969$ 829140 Fire Station Electrical System 36,141 - 36,141 36,141 834580 Washington and Ortega Light Conversion to LED - (795) 795 - 836010 Mobile Electric Vehicle Charging Stations 327,680 - 327,680 327,680 Infrastructure Projects
818700 Corporation Yard Buildings - Rehabilitation 3,200 3,200 - - 820270 Playground Equipment Replacement 777,463 - 777,463 777,463 825290 Pavement Rehabilitation (833,397) - (833,397) (833,397) 825850 Swim Pools Infrastructure 438,529 17,843 420,686 420,686 828030 Annual Slurry Seal of City Streets (109,840) - (109,840) (110,034) 829190 Community Center Comprehensive Infrastructure 9,264 9,264 - - 829400 Sidewalk, Curb and Gutter Replacement (391,029) (391,029) - - 831340 Civic Center Modernization 25,710,074 12,622,127 13,087,947 13,602,302 831850 Washington Park Renovation and Enhancement - (311) 311 - 832730 Renovate Median Landscaping to Low Maintenance 2,969,413 36,376 2,933,037 2,933,037 832780 All Inclusive Playground 2,425,202 2,424,674 528 - Total Projects 33,163,609 14,857,289 1 8,306,320 1 8,818,847 Total Appropriations 33,163,609 14,857,289 1 8,306,320 1 8,818,847 Project Carryover - 18,818,847 ( 18,818,847) Total 33,163,609 33,676,136 ( 512,527) Fund 3200
Attachment 1

City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2022
Fund 3300 - Capital Project 2020 Civic Center Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2022/23
Projects
Infrastructure Projects
831340 Civic Center Modernization 108,780,420$ 7 9,993,971$ 2 8,786,449$ 2 8,786,449$ Total Projects 108,780,420 79,993,971 2 8,786,449 2 8,786,449 Total Appropriations 108,780,420 79,993,971 2 8,786,449 2 8,786,449 Project Carryover - 28,786,449 ( 28,786,449) Total 108,780,420 108,780,420 -
Description
Fund 2400
Attachment 1

City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2022
Fund 6040 - Water Supply and Distribution Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2022/23
Debt Service
70112 2017A Water Revenue Refunding Bonds 515,000$ 5 45,000$ ( 30,000)$ -$ 70113 2017A-T Water Revenue Refunding Bonds 633,493 6 09,843 2 3,650 - Total Debt Service 1,148,493 1,154,843 ( 6,350) - Operating Programs
Environmental Services
14300 Water Resources 7,409,554 7 ,108,132 3 01,421 - 15000 Wholesale Water Purchases 31,534,273 3 4,003,560 ( 2,469,287) - 00001 City Wide Program - ( 41,731) 41,731 - Total Environmental Services 38,943,827 41,111,693 ( 2,167,866) - Total Operating Programs 38,943,827 41,111,693 ( 2,167,866) - Transfers Out
580511 Liability and Property Insurance Fund 225,981 2 25,981 - - 580511 General Fund - In Lieu 4,161,903 4 ,161,903 - - 580511 Employee Payroll & Benefits Fund - Retirement 1,171,728 1 ,171,728 - - 580511 Employee Payroll and Benefits Fund - Leaves 24,890 2 4,890 - - 580511 General Services Fund - Project Management Services 1,019,833 8 78,579 1 41,254 - 580511 Insurance and Other Benefits Fund 321,301 3 21,301 - - 580511 Employee Payroll and Benefits Fund - Pension Trust 57,877 5 7,877 - - Total Transfers Out 6,983,513 6,842,260 1 41,253 - Projects
Capital Projects
806351 Land Development and Capital Construction 344,940 244,114 1 00,827 1 00,827 834360 Water System Seismic Risk and Vulnerability Study 200,000 - 2 00,000 2 00,000 834380 Fire Hydrant Replacement 120,000 6 1,032 5 8,968 - 834590 Urgent Water Main Repairs 250,000 - 2 50,000 2 50,000 Infrastructure Projects
815203 Replacement of Water/Sewer Supervisory Control System 95,000 - 9 5,000 9 5,000 825301 Pressure Reducing Valve Replacement & Relocation for SCADA 165,001 1 65,001 - - 825451 City-wide Water Line Replacement 11,775,043 2 ,889,369 8 ,885,674 8 ,885,674 830170 Refurbishment of Water Tanks 4,042,803 - 4 ,042,803 4 ,042,803 831340 Civic Center Modernization 292,564 1 0,512 2 82,052 2 82,052 831550 Adjust Water Utilities in Supp 243,824 - 2 43,824 2 43,824 831840 Cathodic Protection SFPUC Turnouts and Transmission Pipeline 817,475 6 ,506 8 10,969 8 10,969 834610 Water System GIS Updates and Maintenance 35,000 3 ,882 3 1,119 3 1,119 825251 Mary/Carson Water Plant Mechanical Reconstructions 836,348 - 8 36,348 8 36,348 Special Projects
818700 Corporation Yard Buildings - Rehabilitation 12,148 - 1 2,148 - 824281 Leak Detection and Condition Assessment Program 49,169 2 0,140 2 9,029 2 9,029 824291 Water Cost of Service Study 10,000 1 0,000 - - 825400 Update of Standard Specifications and Details 5,463 - 5 ,463 5 ,463 830590 Corporation Yard Site Feasibility and Modernization Plan 8,715 4 86 8 ,229 8 ,229 831480 Water Conservation and Drought Response 72,500 2 4,474 4 8,026 4 8,026 831600 Solar Installations on City Facilities 208,051 1 2,825 1 95,226 - 834640 Interactive Voice Response (IVR) for Utility Billing Call Center 16,667 - 1 6,667 2 ,000 834650 Utility Billing Reporting Tool 16,631 6 ,436 1 0,195 6 ,668 834720 Laboratory Certification Update 25,000 - 2 5,000 2 5,000 Total Projects 19,642,342 3,454,775 1 6,187,567 1 5,903,031 Total Appropriations 66,718,175 52,563,571 1 4,154,604 1 5,903,031 Project Carryover - 15,903,031 ( 15,903,031) Description
Fund 6040
Attachment 1

City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2022
Fund 6040 - Water Supply and Distribution Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2022/23Description
Total 66,718,175 68,466,602 ( 1,748,427) Fund 6040
Attachment 1

City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2022
Fund 6080 - Wastewater Management Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2022/23
Debt Service
70114 2017A Wastewater Revenue Refunding Bonds 632,000$ 6 37,500$ ( 5,500)$ -$ 70115 2017A-T Wastewater Revenue Refunding Bonds 1,360,054 1 ,368,434 ( 8,380) - 70121 SRF Loan Clean Water Total 5,270,934 6 ,147,431 ( 876,497) - 70123 WIFIA Federal/EPA Loan Total 521,750 2 ,058,331 ( 1,536,581) - Total Debt Service 7,784,738 10,211,696 ( 2,426,958) - Operating Programs
Environmental Services
00001 City Wide Program - 8 6,602 ( 86,602) - 14600 Wastewater Management 12,466,743 1 2,216,235 2 50,508 - 14700 Regulatory Programs 3,242,687 2 ,805,997 4 36,690 - 14800 Wastewater Collections 3,280,370 2 ,990,789 2 89,581 - Total Environmental Services 18,989,800 18,099,623 8 90,177 - Project Operating 24,631 - 2 4,631 - Total Non-Departmental 24,631 - 2 4,631 - Total Operating Programs 19,014,431 18,099,623 9 14,808 - Transfers Out
551011 Interfund Loan Principal Repaid 782,297 7 82,297 - - 551012 Interfund Loan Interest Paid 167,318 1 67,318 - - 580511 Liability and Property Insurance Fund 353,202 3 53,202 - - 580511 General Fund - In Lieu 3,099,280 3 ,099,280 - - 580511 Employee Payroll & Benefits Fund 3,640,208 3 ,640,208 - - 580511 General Services Fund - Project Management Services 666,986 5 77,038 8 9,948 - 580511 Long Term Rent - WPCP Expense 826,367 8 26,367 - - 580511 General Fund - Projects 72,455 7 2,455 - - Total Transfers Out 9,608,113 9,518,166 8 9,947 - Equipment
P20201 Wastewater Equipment 608,524 69,098 5 39,426 5 39,426 Total Equipment 608,524 69,098 5 39,426 5 39,426 Projects
Infrastructure Projects
805253 Sewer Emergency Repair and Replacement 400,000 1 67,911 2 32,089 2 32,089 815203 Replacement of Water/Sewer Supervisory Control System 5,000 - 5 ,000 5 ,000 825331 Replacement/Repair/Rehabilitation of Sanitary Sewer System 4,942,718 8 70,566 4 ,072,152 4 ,072,152 825521 WPCP Biosolids Processing 1,982,711 1 ,703,223 2 79,488 2 79,488 829070 Lawrence Expressway Sanitary Sewer Rehabilitation 3,188,790 2 ,537,819 6 50,971 3 0,000 830190 Repairs to the Primary Process 27,320 2 6,064 1 ,256 - 830200 Repairs to the Secondary Process 144,290 1 44,290 - - 830210 Repairs to the Power Generation Facility 899,703 7 0,479 8 29,224 7 29,224 830220 Repairs to the Tertiary Process 1,137,379 5 5,115 1 ,082,264 7 00,000 831340 Civic Center Modernization 501,324 1 8,059 4 83,265 4 83,265 831630 Repairs to Solids/Dewatering Facility 487,800 6 0,373 4 27,428 3 25,000 831680 Adjust Sewer Utilities in Support of Paving Projects 172,324 - 1 72,324 1 72,324 831730 WPCP Oxidation Pond Levee Rehabilitation 6,178,665 2 04,798 5 ,973,867 5 ,973,867 832430 Recycled and Potable Water Plan Development 146,165 - 1 46,165 1 46,165 833270 SCWP Community Improvements 600,000 - 6 00,000 6 00,000 834750 Peery Park Specific Plan Wastewater Capacity Improvements 510,073 - 5 10,073 5 10,073 835280 Secondary Treatment Emergency Repairs 585,059 1 63,826 4 21,233 - Capital Projects
818700 Corporation Yard Buildings - Rehabilitation 6,383 - 6 ,383 - 822762 Storm Pump Station Number 2 Rehabilitation 171,099 3 9,931 1 31,168 1 31,168 828210 Inspection Data Mgmt and Handheld Data Entry Device Project 250,000 - 2 50,000 2 50,000 Description
Fund 6080
Attachment 1

City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2022
Fund 6080 - Wastewater Management Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2022/23Description
829100 Sanitary Sewer Siphon Cleaning and Assessment 713,548 2 3,075 6 90,473 6 90,473 830590 Corporation Yard Site Feasibility and Modernization Plan 4,474 2 70 4 ,204 4 ,204 833070 WPCP Electronic Operations & Maintenance Manual 378,738 3 5,222 3 43,516 3 43,516 833090 Sanitary and Storm System Hydraulic Model Update 210,803 2 05,590 5 ,213 - 834460 Sewer Capacity Enhancement Projects 500,000 - 5 00,000 - Special Projects
825400 Update of Standard Specifications and Details 5,463 - 5 ,463 5 ,463 831600 Solar Installations on City Facilities 80,300 - 8 0,300 - 833060 Annual Digester Cleaning 257,200 - 2 57,200 1 00,000 834640 Interactive Voice Response (IVR) for Utility Billing Call Center 16,667 - 1 6,667 2 ,000 834650 Utility Billing Reporting Tool 16,631 6 ,436 1 0,194 6 ,666 834720 Laboratory Certification Update 73,328 2 1,949 5 1,379 5 1,379 834900 SCWP Financing Support 800,184 2 7,962 7 72,222 7 72,222 835450 Stormwater - Wastewater Bacteria Control Program 100,000 - 1 00,000 1 00,000 835480 Baykeeper Litigation Expenses 323,156 2 09,785 1 13,371 1 13,371 835991 Cupertino Sanitary District Sewer Flow Diversion 115,000 - 1 15,000 1 15,000 SRF Funded Projects
824771 Primary Process Design and Construction1 7,694,524 2,092,061 5 ,602,464 5 ,602,464 831470 WPCP Construction Management3 8,425,290 1,780,848 6 ,644,442 6 ,644,442 830240 WPCP Program Management2 4,696,414 2,937,204 1 ,759,210 1 ,759,210 WIFIA Funded Projects
833110 SCWP Oversight 351,567 3 35,503 1 6,063 - 833150 SCWP Existing Plant Rehabilitation - Split Flow 4,880,750 8 35,880 4 ,044,870 4 ,044,870 833210 SCWP Secondary Treatment Improvements-Split Flow CAS Stage 1 37,966,831 6,345,223 31,621,608 3 1,621,608 833240 SCWP Administration and Lab Building (266,603) 1 27,389 ( 393,992) ( 393,992) All other Clean Water Program Projects
833100 SCWP - Capital Replacement 220,000 - 2 20,000 2 20,000 833120 SCWP Environmental Mitigation 1,070,865 1 1,146 1 ,059,719 1 ,059,719 834390 SCWP WPCP Condition Assessment 300,000 - 3 00,000 3 00,000 834400 SCWP Master Plan Update 875,000 ( 150,000) 1 ,025,000 1 ,025,000 Total Projects 92,146,932 20,907,998 7 1,238,934 6 8,827,428 Total Appropriations 129,162,738 58,806,581 7 0,356,157 6 9,366,854 Project Carryover - 68,827,428 ( 68,827,428) Equipment Carryover - 539,426 ( 539,426) Total 129,162,738 128,173,435 9 89,303
Fund 6080
Attachment 1

City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2022
Fund 6100 - Solid Waste Management Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2022/23
Operating Programs
00001 City Wide Program -$ 157,126$ ( 157,126)$ -$ 13200 Pavement and Concrete Maintenance 843,845 752,769 9 1,076 - 14400 Solid Waste Management 46,525,241 4 4,206,313 2 ,318,928 - Total Environmental Services 47,369,086 45,116,208 2 ,252,878 - Total Operating Programs 47,369,086 45,116,208 2 ,252,878 - Transfers Out
551011 Interfund Principle Repaid - General Fund 3,428,423 3 ,428,423 - - 551012 Interfund Interest Paid - General Fund 285,395 2 85,395 - - 551021 Long Term Rent - 301 Carl Rd (SMaRT) 822,608 8 22,608 - - 551023 Long Term Rent-Landfill 512,711 5 12,711 - - 580511 Liability and Property Insurance Fund 47,298 4 7,298 - - 580511 General Fund 3,317,953 3 ,144,562 1 73,391 - 580511 Employee Payroll & Benefits Fund 636,165 6 36,165 - - Total Transfers Out 9,050,553 8,877,162 1 73,391 - Projects
Infrastructure Projects
825911 Flare Structure Replacement 50,000 - 5 0,000 5 0,000 831600 Solar Installations on City Facilities 279,162 - - - 831340 Civic Center Modernization 158,377 5 ,660 1 52,716 1 52,716 Capital Projects
829081 Storm System Trash Control Devices 191,000 - 1 91,000 1 91,000 Special Projects
801351 Sunnyvale Contribution to SMaRT Station Equipment Rep. (109,503) 9 4,660 ( 204,163) ( 204,163) 821181 Contribution to SMaRT Station Operations Contract RFP 123,131 - 1 23,131 - 824261 Solid Waste Cost of Service Study 41,201 2 9,346 1 1,856 1 1,856 830910 Zero Waste Strategic Plan 560,266 2 39,800 3 20,466 - 831691 Storm System Trash Reduction Programs 173,481 - 1 73,481 1 13,000 833210 Secondary Treatment & Thickening/Dewatering - CAS Stage 1 18,000,000 - 1 8,000,000 1 8,000,000 833830 Procure Post-2021 Solid Waste Collection Franchise - 5 ,891 ( 5,891) ( 5,891) 834640 Interactive Voice Response (VR) for Utility Billing Call Center 16,667 - 1 6,667 2 ,000 834650 Utility Billing Reporting Tool 16,631 6 ,436 1 0,194 6 ,666 835460 Recycle Yard Transition to Parking Lot 25,000 - 2 5,000 2 5,000 833040 Landfill South Hill Drainage Correction 188,271 1 ,816 1 86,455 1 86,455 Total Projects 19,713,684 383,608 1 9,330,076 1 8,528,640 Total Appropriations 76,133,323 54,376,978 2 1,756,345 1 8,528,640 Project Carryover - 18,528,640 ( 18,528,640) Total 76,133,323 72,905,618 3 ,227,705
Description
Fund 6100
Attachment 1

City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2022
Fund 6140 - SMaRT Station Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2022/23
Operating Programs
Environmental Services
14500 SMaRT Station 29,316,883$ 2 5,865,543$ 3 ,451,340$ -$ Total Environmental Services 29,316,883 25,865,543 3 ,451,340 - Total Operating Programs 29,316,883 25,865,543 3 ,451,340 - Transfers Out
580511 Employee Payroll & Benefits Fund 135,369 1 35,369 - - Total Transfers Out 135,369 135,369 - - Projects
Infrastructure Projects
811250 SMaRT Station Equipment Replacement 322,894 2 36,710 8 6,184 8 6,184 828260 Replace SMaRT Station 16,297,343 1 09,895 1 6,187,448 1 6,187,448 831340 Civic Center Modernization 14,724 5 23 1 4,201 1 4,201 Special Projects
821170 SMaRT Station Operations Contract RFP 90,000 5 1,207 3 8,793 - 836000 Anaerobic Digestion and Composting Improvements 3,000,000 - 3 ,000,000 3 ,000,000 Total Projects 19,724,962 398,335 1 9,326,627 1 9,287,833 Total Appropriations 49,177,214 26,399,247 2 2,777,967 Project Carryover - 19,287,833 ( 19,287,833) Total 49,177,214 45,687,080 3 ,490,134
Description
Fund 6140
Attachment 1

City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2022
Fund 6180 - Development Enterprise Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2022/23
Operating Programs
Community Development
10300 Building Safety 4,280,061$ 4 ,847,149$ ( 567,088)$ -$ 10400 Planning 2,634,689 2 ,860,575 ( 225,886) - Total Community Development 6,914,750 7,707,724 ( 792,974) - Public Works
13100 Transportation and Traffic Services 460,958 3 77,946 8 3,012 - 13400 Street Tree Services 48,988 3 7,755 1 1,232 - 13900 Land Development - Engineering Services 2,093,180 1 ,887,494 2 05,686 - Total Public Works 2,603,126 2,303,196 2 99,930 - Environmental Services
14700 Regulatory Programs 243,602 1 72,438 7 1,164 - Total Environmental Services 243,602 172,438 7 1,164 - Library and Recreation Services
12000 Community Services 21,274 2 3,569 ( 2,295) - Total Library and Recreation Services 21,274 23,569 ( 2,295) - Office of the City Attorney
10100 Comprehensive Legal Services 435,034 3 44,573 9 0,461 - Total Office of the City Attorney 435,034 344,573 9 0,461 - Public Safety
12900 Fire Prevention and Hazardous Material Services 1,207,298 1 ,216,405 ( 9,107) - Total Public Safety 1,207,298 1,216,405 ( 9,107) - Total Operating Programs 11,425,084 11,767,905 ( 342,821) - Transfers Out
580511 General Fund - In Lieu 1,946,575 1 ,946,575 - - 580511 Property and Liability Insurance Fund 6,699 6 ,699 - - 580511 Employee Payroll & Benefits Fund 2,726,392 2 ,726,392 - - 580511 General Services Fund - Technology and Communication 2,291,755 2 ,291,755 - - Total Transfers Out 6,971,421 6,971,421 - - Projects
Special Projects
829751 Fire Prevention Construction-Related Permitting 67,035 6 7,035 - - 830901 Transportation and Traffic Services 21,608 9 ,414 1 2,194 1 2,194 833960 Moffett Park Specific Plan Staffing 279,136 2 16,228 6 2,908 6 2,908 834260 Cost of Service Study for Community Development Fees 53,400 - 5 3,400 5 3,400 835190 Updates to Single Family Home 100,000 - 1 00,000 1 00,000 834730 Public Safety Impact Fee Study 125,000 - 1 25,000 1 25,000 Infrastructure Projects
831340 Civic Center Modernization 1,127,643 4 0,700 1 ,086,944 1 ,086,944 Total Projects 1,773,823 333,377 1 ,440,446 1 ,440,446 Total Appropriations 20,170,328 19,072,703 1 ,097,625 1 ,440,446 Project Carryover - 1,440,446 ( 1,440,446) Total 20,170,328 20,513,149 ( 342,821)
Description
Fund 6180
Attachment 1

City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2022
Fund 6200 - Golf and Tennis Operations Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2022/23
Operating Programs
Public Works
14000 Golf Course Operations 3,880,692$ 3 ,821,579$ 5 9,113$ -$ Total Public Works 3,880,692 3,821,579 5 9,113 - Total Operating Programs 3,880,692 3,821,579 5 9,113 - Projects
Infrastructure Projects
831340 Civic Center Modernization 148,135 5 ,391 1 42,744 1 42,744 Total Projects 148,135 5,391 1 42,744 1 42,744 Transfers Out
580511 General Fund - In Lieu 464,588 4 64,588 - - 580511 Employee Payroll & Benefits Fund 856,381 8 56,381 - - 580511 Liability & Property Insurance Fund 54,032 5 4,032 - - Total Transfers Out 1,375,001 1,375,001 - - Total Appropriations 5,403,828 5,201,971 2 01,857 1 42,744 Project Carryover - 142,744 ( 142,744) Total 5,403,828 5,344,715 5 9,113
Description
Fund 6200
Attachment 1

City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2022
Fund 7020 - General Services Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2022/23
Equipment
P20600 Furniture 31,143.00$ -$ 31, 143$ 31, 143$ P20700 Fleet Equipment 5,133,411 2,148,987 2, 984,424 2, 984,424 P21300 Building Maintenance Equipment 702,841 109,918 592 ,923 592 ,923 P21600 Information Processing Hardware 1,487,068 597,610 889 ,458 852 ,874 P21601 Information Processing Software 1,902,321 281,194 1, 621,127 1, 364,139 P21603 Communications and Office Equipment 1,447,462 1,251,269 196 ,193 196 ,193 P21610 KSUN Equipment 239,323 7,572 231 ,751 231 ,751
Total Equipment 10,943,569 4,396,551 6, 547,018 6, 253,447 Operating Programs
Finance
11000 Purchasing 718,190 703 ,842 14, 348 -
11200 Accounting and Financial Services 183,804 123 ,004 60, 800 - Total Finance 901,994 826,846 75, 148 -
Information Technology
15200 Information Technology Services and Support 9,908,863 9, 860,555 48, 308 - Total Information Technology 9,908,863 9,860,555 48, 308 - Public Works
13800 Capital Project Management 3,743,339 3, 458,829 284 ,510 - 14100 Fleet, Fuel, and Equipment 3,470,004 4, 044,830 (5 74,826) - 14200 Facility Services 5,197,138 4, 846,572 350 ,565 - Total Public Works 12,410,481 12,350,232 60, 249 - Total Operating Programs 23,221,338 23,037,633 183 ,705 - Transfers Out
580511 General Fund - In Lieu 191,800 191 ,800 - -
580511 Employee Payroll and Benefits Fund - Pension Trust 4,600,442 4, 600,442 - - -
Total Transfers Out 4,792,242 4,792,242 - - Projects
Infrastructure Projects
818700 Corporation Yard Buildings - Rehabilitation 44,236 31, 444 12, 792 12, 792 831340 Civic Center Modernization 148,550 5, 121 143 ,429 143 ,429 Special Projects
830521 ERP System Acquisition, Implementation, and Support 3,900,641 2, 230,583 1, 670,058 1, 670,058 831890 Information Technology -- Risk Assessment 99,750 - 99, 750 - 832270 Permitting System Replacement 2,891,577 1, 429,161 1, 462,416 1, 462,416 834600 Microsoft Server OS and SQL Server Upgrade 157,625 250 157 ,375 157 ,375 831340 Civic Center Modernization 80,210 - 80, 210 80, 210 835580 Replacement DPS Video Surveillance System 353,254 - 353 ,254 - 835590 Replacement DPS Mobile Computing 313,506 - 313 ,506 - 835600 Replacement DPS Enterprise Storage 287,842 - 287 ,842 - 835610 Computer Aided Dispatch (CAD) System Replacement 1,902,720 - 1, 902,720 1, 902,720 -
Capital Projects -
830590 Corporation Yard Site Feasibility and Modernization Plan 33,723 1, 944 31, 779 31, 779 Total Projects 10,213,635 3,698,503 6, 515,132 5, 460,779 Total Appropriations 49,170,784 35,924,929 13, 245,855 11, 714,226 Equipment Carryover - 6,253,447 (6 ,253,447)
Description
Fund 7020
Attachment 1

City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2022
Fund 7020 - General Services Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2022/23Description
Project Carryover - 5,460,779 (5 ,460,779)
Total 49,170,784 47,639,155 1, 531,629
Fund 7020
Attachment 1

City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2022
Fund 7060 - Employee Payroll and Benefits Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2022/23
Operating Programs
Human Resources
11500 Employee Leave Benefits - Leave Earned 18,015,650$ 1 8,779,070$ ( 763,420)$ -$ 11600 Retirement, Insurances, and Taxes 80,074,830 7 7,401,578 2 ,673,252 - 11700 Workers' Compensation Program 5,375,016 6 ,527,299 ( 1,152,283) - -
Total Human Resources 103,465,496 102,707,947 7 57,549 - Non-Departmental
00001 Non-Programmatic Pension Trust 8,717 4 ,409 4 ,308 - Total Non-Departmental 8,717 4,409 4 ,308 - Total Operating Programs 103,474,213 102,712,356 7 61,857 - Transfers Out
00001 Transfers Out - Employee Benefits - PTO to GF 2,050,916 2 ,148,015 ( 97,099) - 00001 Non-Programmatic Executive Home Mortgage Program 2,000,000 - 2 ,000,000 2 ,000,000 Total Transfers Out 4,050,916 2,148,015 1 ,902,901 2 ,000,000 Total Appropriations 107,525,129 104,860,371 2 ,664,758 2 ,000,000 Deferred Transfers Out 2,000,000 (2,000,000)
Total 107,525,129 106,860,371 6 64,758
Description
Fund 7060
Attachment 1

City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2022
Fund 7080 - Property and Liability Insurance Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2022/23
Operating Programs
Human Resources
11400 Human Resources 115,441$ 8 8,263$ 2 7,178$ -$ 11800 City Liability and Property Insurance and Claim Costs 3,612,351 3 ,727,932 ( 115,582) - Total Human Resources 3,727,792 3,816,195 ( 88,403) - Total Operating Programs 3,727,792 3,816,195 ( 88,403) - Transfer Out
580511 Employee Payroll and Benefits Fund 23,340 2 3,340 - Total Transfer 23,340 23,340 - - Total Appropriations 3,751,132 3,839,535 ( 88,403) - Total 3,751,132 3,839,535 ( 88,403) Description
Fund 7080
Attachment 1

City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2022
Fund 5040 - Fremont Pool Permanent Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2022/23
Transfers Out
580511 General Fund - In Lieu 21,471$ 1 8,009$ 3 ,462$ -$ Total Transfers Out 21,471 18,009 3 ,462 - Total Appropriations 21,471 18,009 3 ,462 - Total 21,471 18,009 3 ,462 Description
Fund 5040
Attachment 1

City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2022
Fund 5080 - Swirsky Youth Opportunity Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2022/23
Transfers Out
580511 General Fund - In Lieu 11,040$ 9 ,252$ 1 ,789$ -$ Total Transfers Out 11,040 9,252 1 ,788 - Total Appropriations 11,040 9,252 1 ,788 - Total 11,040 9,252 1 ,788 Description
Fund 5080
Attachment 1

City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2022
Fund 8100 - Community Facilities District No. 3 (Estates at Sunnyvale) Fund Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2022/23
Operating Programs
Public Works
15100 CFD Estates at Sunnyvale 40,406$ 7 ,886$ 3 2,520$ -$ Total Public Works 40,406 7,886 3 2,520 - Total Operating Programs 40,406 7,886 3 2,520 - Projects
Infrastructure Projects
831340 Civic Center Modernization 305 - 3 05 3 05 Total Projects 305 - 3 05 3 05 Transfers Out
580511 General Fund - In Lieu 3,574 3 ,574 - - 580511 Employee Payroll and Benefits Fund 9,803 9 ,803 - - Total Transfers Out 13,377 13,377 - - Total Appropriations 54,088 21,263 3 2,825 3 05 Project Carryover - 305 ( 305) Total 54,088 21,568 3 2,520 Description
Fund 8100
Attachment 1