City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2023
Fund 1000 - General Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2023/24
Operating Programs
City Attorney
10100 Comprehensive Legal Services 1,760,726 $ 1,773,946 $ (13,220) $ - $ Total City Attorney 1,760,726 1,773,946 (13,220) - City Manager
10200 Office of the City Manager 5,247,361 4,926,436 320,925 - Total City Manager 5,247,361 4,926,436 320,925 - Community Development
10400 Planning 792,996 672,383 120,613 -
10600 Community Development Department Management 775,620 776,964 (1,344) - Total Community Development 1,568,615 1,449,346 119,269 - Environmental Services
14700 Regulatory Programs 1,416,007 1,260,149 155,858 - 14900 Environmental Sustainability 820,404 505,843 314,561 - 15100 Stormwater Collections 450,500 490,780 (40,280) - Total Environmental Services 2,686,911 2,256,772 430,139 - Finance
10800 Non-Utility Revenue Management and Special Projects 777,501 795,065 (17,565) - 10900 Budget Management 1,160,567 1,001,391 159,176 - 11000 Purchasing 1,823,891 1,589,081 234,810 - 11100 Financial Management and Analysis 1,703,385 1,718,092 (14,707) - 11200 Accounting and Financial Services 1,491,296 1,726,987 (235,691) - 11300 Utility Billing 3,449,184 3,478,918 (29,734) - Total Finance 10,405,823 10,309,534 96,289 - Human Resourc
es
11400 Human Resources 5,011,894 4,885,411 126,483 - Total Human Resources 5,011,894 4,885,411 126,483 - Library and Recreation Services
11900 Library 10,065,487 9,606,646 458,841 - 12000 Recreation Services 9,771,109 9,038,832 732,278 - Total Library and Recreation Services 19,836,596 18,645,477 1,191,119 - Public Safety
12100 Police Services 30,212,438 29,568,457 643,981 - 12200 Fire Services 30,995,057 32,565,613 (1,570,556) - 12300 Community Safety Services 3,427,605 3,246,292 181,313 - 12400 Personnel and Training 2,680,437 2,274,654 405,783 - 12500 Investigation Services 5,420,156 5,666,103 (245,948) - 12600 Communication Services 4,299,508 4,324,898 (25,390) - 12700 Public Safety Administrative Services 6,706,612 6,783,659 (77,048) - 12800 Records Management and Property Services 2,413,080 2,207,460 205,620 - 12900 Fire Prevention and Hazardous Material Services 2,408,575 2,007,835 400,740 - 13000 Community Preservation Services - - -
Total Public Safety 88,563,467 88,644,972 (81,505) - Public Works
13100 Transportation and Traffic Services 3,400,556 3,247,989 152,567 - 13200 Pavement Maintenance and Concrete Maintenance 4,965,849 4,055,346 910,503 - 13300 Street Lights, Signs and Debris 2,661,445 2,136,359 525,087 - 13400 Urban Forestry 2,484,454 1,557,185 927,269 - 13600 Neighbor
hood Parks and Open Space Management 12,352,771 11,813,542 539,229 - Description
Fund 1000
Attachment 1
City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2023
Fund 1000 - General Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2023/24Description
13700 Public Works Administration and Property Management 780,463 809,437 (28,974) - Total Public Works 26,645,539 23,619,858 3,025,681 - Projected Savings
Gas Tax Offset for 13200 Pavement Program (1,250,000) (824,634) (425,366) - Total Operating Programs 160,476,932 155,687,118 4,789,814 - Debt Service
70100 Civic Center Bonds Trustee/Investment Mgmt Fee 5,055,425 4,042,808 1,012,617 - Total Debt Service 5,055,425 4,042,808 1,012,617 - Lease Payments
00001 Financial Services 27,000 18,025 8,975 - 00001 Lease Expenditure - Principal - 1,285,250 (1,285,250) - Total Lease Pa
yments 27,000 1,303,275 (1,276,275) - Transfers Out
580511 General Services Fund - Tech Fund 1,583,500 1,583,500 - - 580511 General Services Fund - Proj Mgmt Serv 613,282 664,877 (51,595) - 580511 Employee Payroll & Benefits Fund - Insurance 7,030,113 7,030,113 - - 580511 Employee Payroll & Benefits Fund - Pension Trust 2,219,620 2,219,620 - - 580511 Employee Payroll & Benefits Fund - Retirement 25,798,162 25,798,162 - - 580511 Infrastructure Fund - General Assets 18,968,443 18,968,443 - - 580511 Liability and Property Insurance Fund 3,098,573 3,098,573 - - 580511 Youth and Neighborhood Services Fund 669,483 669,483 - - 580511 Community Recreation Fund - Golf 1,840,000 1,840,000 - - -
Total Transfers Out 61,821,176 61,872,771 (51,595) - Equipment
P20000 General Equipment 5,000 $ 1,557 $ 3,443 $ - $ P20802 Recreation Equipment 342,781 36,309 306,472 237,320 P20901 Public Safety Equipment 313,472 222,737 90,735 90,735 Total E
quipment 661,253 260,603 400,650 328,055 Projects
Infrastructure Projects
818700 Corporation Yard Buildings - Rehabilitation 26,763 - 26,763 - 820130 Routine Resurfacing of City Owned Parking Lots 190,992 - 190,992 190,992 822762 Storm Pump Station Nu mber 2 Rehabilitation 17,570 - 17,570 - 824780 Upgrading of Fuel Stations 1,194,973 120,977 1,073,996 1,073,996 825290 Pavement Rehab ilitation 4,479,655 453 4,479,202 4,479,202 825362 Replacement/Repair/Rehabilitat ion of Storm Drain 1,205,456 488,524 716,932 716,932 825730 Pedestrian Lighted Crosswalk Maintenance and Replacement 1,263,401 487,803 775,598 775,598 829400 Sidewalk, Curb and Gutter Replacement 3,085,448 812,095 2,273,353 2,273,353 831340 Civic Center Modernization 4,444,715 3,381,645 1,063,070 1,063,070 831580 ADA Projects and Emergency Concrete Replacement 105,307 754 104,553 - 831770 Illuminated Street Sign Replacement Project 325,089 - 325,089 325,089 833750 Public Safety Emergency Generator Replacement 2,380,253 98,923 2,281,331 2,281,331 833030 Pavement Standards 4,438 - 4,438 4,438 833810 Traffic Signal Maintenance Services Augmentation 510,722 - 510,722 184,000 836140 Stormwater Outfall Emergency Repair - 24,909 (24,909) - Outside Group Funding Projects
803700 Leadership Sunnyvale [GF] 6,000 6,000 - - 819720 Outside Group Funding Support [GF] 135,000 135,000 - - 830630 Dispute Resolution Services 45,000 45,000 - - 832380 Ii
zuka Sister City Engagement Funding 6,500 2,500 4,000 - 836020 A Sunny Place for Growing Readers 88,316 31,616 56,700 56,700 Capital Projects
Fund 1000
Attachment 1
City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2023
Fund 1000 - General Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2023/24Description
802150 Utility Undergrounding Cost Sharing 405,355 - 405,355 405,355 826730 Underground Overhead Utilities 659,452 267,088 392,364 392,364 826790 Sunnyvale Avenue Median (Iowa to Washington) 247,925 - 247,925 247,925 830590 Corporation Yard Site Feas ibility and Modernization Plan 41,733 28,425 13,308 13,308 830600 Lakewood Branch Libr ary Facility 1,481,000 5,000 1,476,000 1,476,000 831320 RDA Counsel Fees 2,699 1,700 999 999 831511 Green Stormwater Infrastructure Implementation - General Fund 214,862 - 214,862 214,862 831600 Solar Installations on City Facilities 14,738 - 14,738 - 831650 ADA Transition Plan 50,000 - 50,000 50,000 832330 Grade Separation Caltrain Crossings at Mary Ave. Study Issue 199,782 117,679 82,102 - 832590 Installation of Charging Stations for Electric Vehicles 146,705 - 146,705 146,705 832690 Library Restroom Renovation 420,000 - 420,000 420,000 832890 Traffic Signal Specifications and Standard Details 31,188 30,092 1,095 - 832970 Peery Park Transportation Improvements 704,668 80,907 623,761 623,761 832990 Sunnyvale Traffic Signal Upgrades 83,810 1,680 82,130 82,130 834340 Corn Palace Park Maintenance 15,000 - 15,000 - 834350 344 Charles Street Renovation 34,156 - 34,156 34,156 834370 Traffic Sign Installation and Maintenance 117,565 11,335 106,230 - 834500 Homestead Road Full Time Bicycle Lane Study 116,734 108,334 8,400 2,260 834700 Green Bike Lane Maintenance 35,000 - 35,000 35,000 834710 Ci
vic Center Phase 2 Planning - Main Library 798,905 4,258 794,647 794,647 835210 Improve Bicycle and Pedestrian Access at Sunnyvale Caltrain 383,423 1,743 381,680 381,680 835220 Bike Rack Installation Program in Commercial Areas 16,785 - 16,785 16,785 835660 Pedestrian & Bicyle Fac ility Installation on Tasman 273,181 - 273,181 273,181 835840 Manzano Way Park Maintenance 30,000 - 30,000 - 835930 Re-evaluate Traffic Calming Program and Policy 200,000 10,952 189,048 189,048 836340 Transportation and General Fund Grant Matching 2,500,000 - 2,500,000 2,500,000 836350 MTC Pavement Management Technical Assistance Program 18,300 18,300 - - Special Projects
804201 City-wide Aerial Photos 9,032 9,032 - - 805150 Library Foundation Program Grant 48,608 - 48,608 48,608 821010 Maintenance of City Owned Properties - Downtown 18,000 1,425 16,575 - 825070 Bicycle Map Revision 31,996 - 31,996 31,996 825400 Update of Standard Specifications and Details 5,463 - 5,463 - 825570 239 - 241 Commercial Street Property Maintenance 11,365 9 11,356 - 825700 General Plan Updates 371,727 16,089 355,638 355,638 825962 SCVURPPP Contracting and Fiscal Agent - General Fund 55,000 17,406 37,594 - 829140 Fire Station Electrical Systems and Roll Up Door Replacement 317,767 - 317,767 317,767 829510 Emergency Medical Dispatch First Responder Incentive Funding 331,505 61,424 270,081 270,081 829620 Downtown Association 40,000 40,000 - - 829630 Council Set Aside 47,390 - 47,390 - 830660 EMS Pati
ent Care Data System 12,417 - 12,417 12,417 830980 Comprehensive Update of the Precise Plan for El Camino Real 75,161 - 75,161 - 831290 Climate Action Plan Implementation 1,231,982 105,675 1,126,307 188,325 831310 Minimum Wage Enforcement Agreement 15,000 15,000 - - 831490 Website Redesign Implementation, Upgrades and Maintenance 75,114 55,277 19,837 19,837 831980 Annual State of the City 46,367 31,589 14,778 - 832160 Eng. Services for Transportation Related Projects/Priorities 1,001,259 386,705 614,554 614,554 832220 Fire Prevention (Non HazMat) Technology Project 25,559 - 25,559 25,559 832230 Fire Prevention (HazMat) Technology Project 7,535 6,300 1,235 1,235 832260 Office of Emergency Services 60,803 48,178 12,624 12,624 832290 Safe Routes to School Program 34,302 34,301 1 - 832401 Silicon Valley Healthy Aging Partnership (SVHAP) 69,076 43,615 25,461 - 832570 AMD Grant Funds to Columbia Neighborhood Center 3,000 2,806 194 - 832640 CAP and Green Building Updates 45,900 - 45,900 45,900 832660 Economic Development Strategy 16,688 - 16,688 16,688 832670 Sunnyvale Elections 38,750 38,750 - - 833940 Orchard Heritage Park and Museum Analysis Study 350,000 - 350,000 350,000 834010 FY 2018/19 Tobacco Decoy Operations 34,612 13,196 21,416 21,416 834110 FY 2019/20 Recruitment and Training for Sworn Officers 400,000 395,020 4,980 - 834120 FY 2020/21 Recruitment and Training for Sworn Officers 3,277,256 1,390,532 1,886,724 34,747 Fund 1000
Attachment 1
City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2023
Fund 1000 - General Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2023/24Description
834130 FY21/22 Recruitment and Training for Sworn Officers 7,875,699 5,449,752 2,425,947 2,425,947 834140 FY22/23 Recruitment and Training Costs for Sworn Officers 4,440,559 1,270,413 3,170,146 3,170,146 834240 Digital Literacy 186,289 86 186,203 162,214 834420 Airplane Noise Monitoring System 5,040 - 5,040 5,040 834430 Electronic Records Management System 413,556 193,148 220,407 220,407 834440 Organizational Development 53,806 9,833 43,973 43,973 834560 GIS Onetime Support 149,168 38,640 110,528 110,528 834780 Evaluation of Right to Lease Ordinance 58,847 192 58,655 10,000 834790 Addition to the Heritage Resource Inventory of Sites Associated with Tech Innovation 75,000 - 75,000 75,000 834810 Ascertain Suitable Location(s) for the Installation of Youth Cricket Batting Cages 2,786 - 2,786 - 834980 Finance Transient Occupancy Tax Audit 45,000 5,563 39,437 39,437 835010 Green Stormwater Infrastructure Plan Implementation 850,000 565 849,435 849,435 835020 Bi-Annual Election Services 489,750 85,762 403,988 - 835110 Electronic ADA Compliance 30,000 354 29,647 29,647 835120 Bi-Annual National Citizen Survey 16,000 16,000 - - 835130 Council Technology Expence 5,474 3,372 2,102 2,102 835150 DPS Reimbursable Mutual Aid (Out of County) 344,339 52,397 291,942 - 835160 DPS Police Services Contract Overtime 36,502 36,502 - - 835200 Cricket Stadium at Baylands Park 200,000 - 200,000 200,000 835260 Tasman Drive Temporary Lane Closure 18,073 18,053 20 20 835320 F
Y 2020/21 SHSGP Training Grant 45,583 23,920 21,663 - 835400 Contribution to Our City Forest 15,000 6,900 8,100 8,100 835450 Stormwater-Wastewater Bacteria Control Program 49,000 12,454 36,546 36,546 835470 Stormwater System Strategic Plan and Funding Evaluation 250,000 - 250,000 250,000 835490 Community Events & Neighborhood Grants 67,893 25,253 42,640 17,500 835510 Maintenance of 725 Kifer Rd. (SCS Property) 50,000 19,030 30,970 - 835620 Cultural Inclusion 260,924 176,553 84,371 - 835640 Housing Mitigation Fee Study 88,435 88,435 - - 835670 Poplar Avenue Sidewalk Study 75,000 69,130 5,871 874 835680 Smart Cities Initiative Study 125,000 87,500 37,500 37,500 835690 Creation of Objective Citywide and Specific Area Plan/Citywide Landscape Design Guidelines 175,900 122,126 53,774 53,774 835720 2023 Housing Element Update 315,631 288,158 27,473 27,473 835730 DPW - JAG Local Funding 35,903 34,565 1,338 1,338 835750 FY21/22 DPS EOC Laptop Replacement 35,200 33,879 1,321 - 835760 FY21/22 OTS STEP Grant 134,318 58,644 75,674 73,289 835790 DPS FY21/22 DOJ COPS Micro Grant 37,378 17,075 20,304 20,304 835810 Code Enforcement Activities to Address Substandard Residential 60,020 51,536 8,485 8,485 835820 Temporary Housing for Unhoused Individuals 500,000 370,941 129,059 129,059 835850 REAP Housing Strategy Implementation 64,976 - 64,976 64,976 835910 Stormw
ater Permit Implementation 275,604 4,609 270,995 270,995 835950 Universal Basic Income Study 100,000 - 100,000 100,000 836030 Care & Connect Program 25,000 - 25,000 - 836050 Disease Prevention and Health Promotion 60,000 22,790 37,210 37,210 836060 DPS State Homeland Security Grants Program (SHSGP) Project 9,695 10,794 (1,099) - 836070 Sustainable California Libraries 30,000 16,729 13,271 - 836080 Living with Nature: Explore the Outdoors with the Library Total 11,083 - 11,083 - 836120 DPS BSCC Officer Wellness Grant 139,012 - 139,012 139,012 836130 Second Harvest Loan Repayment Grant 47,570 47,570 - - 836430 SB379 SolarApp+ 80,000 342 79,658 79,658 836510 San Andreas Regional Center, After School Recreation Program 80,596 3,832 76,764 76,764 Total Projects 55,407,807 17,809,414 37,598,393 32,869,015 Total Appropriations 283,449,593 240,975,989 42,473,604 33,197,070 Equipment Carryover - 328,055 (328,055) Capital Projects Carryover - 8,300,167 (8,300,167) Infrastructure Projects Carryover - 13,368,001 (13,368,001) Special Projects Carryover - 11,144,146 (11,144,146) Outside Group Funding Projects Carryover - 56,700 (56,700) Total 283,449,593 274,173,059 9,276,534
Fund 1000
Attachment 1
City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2023
Fund 1040 - Youth and Neighborhood Services Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2023/24
Operating Programs
Library and Recreation Services
12000 Recreation Services 869,800$ 858 ,215$ 11, 586$ -$ Total Library and Recreation Services 869,800 858,215 11, 585 - Total Operating Programs 869,800 858,215 11, 585 - Projects
Special Projects
835301 ECHD Grant ShapeUp Sunnyvale, Year 2 45,000 45, 000 - - Total Projects 45,000 45,000 - - Transfers Out
Employee Payroll & Benefits Fund 129,721 129,721 - Total Transfer Out 129,721 129,721 - - Total Appropriations 1,044,521 1,032,936 11, 585 - Total 1,044,521 1,032,936 11, 585
Description
Fund 1040
Attachment 1
City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2023
Fund 2020 - Housing Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2023/24
Operating Programs
Community Development
10500 Housing MIT and BMR Program 1,257,188$ 1, 182,948$ 74, 240$ -$ Total Community Development 1,257,188 1,182,948 74, 240 - Total Operating Programs 1,257,188 1,182,948 74, 240 - Transfers Out
580511 Employee Payroll & Benefits Fund 217,477 217 ,477 - - 580511 General Fund - In Lieu 82,333 82, 333 - - Total Transfers Out 299,810 299,810 - - Projects
Special Projects
823750 BMR Compliance Enforcement 116,694 - 116 ,694 100 ,000 825700 General Plan Updates 129,623 - 129 ,623 129 ,623 826520 Pre-Development Costs on Affordable Housing Sites 49,591 13, 643 35, 947 35, 947 826530 County-wide Homeless Count 22,114 - 22, 114 - 828100 First-Time Homebuyer Loans (81-120% AMI) 315,000 100 ,000 215 ,000 - 832030 Orchard Gardens Apartments Redevelopment 7,500,000 - 7, 500,000 7, 500,000 Infrastructure
831340 Civic Cener Modernization 174,705 132 ,210 42, 494 42, 494 Total Projects 8,307,726 245,854 8, 061,872 7, 808,065 Total Appropriations 9,864,724 1,728,612 8, 136,112 7, 808,065 Project Carryover - 7,808,065 (7 ,808,065) Deferred Transfers Out - - - Total 9,864,724 9,536,677 328 ,047
Description
Fund 2020
Attachment 1
City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2023
Fund 2040 - Community Development Block Grant Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2023/24
Operating Programs
Community Development
16100 CDBG Program 255,662$ 260 ,777$ (5 ,115)$ -$ 16200 CDBG RLF 170,072 58, 347 111 ,725 - 16300 CDBG-CV - 59, 291 (5 9,291) - Total Community Development 425,734 378,415 47,319 -
Total Operating Programs 425,734 378,415 47,319 -
Transfers Out
551026 General Fund - In Lieu 22,828 11,961 10, 867 - Total Transfers Out 22,828 11,961 10,867 -
Projects
Special Projects
803501 CDBG Housing Rehabilitation Revolving Loan Fund 78,783 28, 071 50, 712 50, 712 812701 Home Access, Paint, Emergency Repair, and Energy-Efficiency 100,000 94, 354 5, 646 - 829560 Sunnyvale Workforce Development Program-DST 517,993 453 ,787 64, 206 - Outside Group Funding Projects
827550 Outside Group Funding Support [CDBG] 194,184 184 ,072 10, 112 - 835550 Mobile Showers and Laundry 17,190 10, 615 6, 575 - 835560 Emergency Assistance for Households w/Disabilities 74,793 72, 529 2, 264 - 835570 COVID-19 Testing and Vaccinations 110,886 7, 791 103 ,095 - Capital Projects
832020 ADA Curb Retrofits (CDBG) 448,000 364 ,390 83, 610 - Total Projects 1,541,829 1,215,609 326 ,220 50, 712 Total Appropriations 1,990,391 1,605,985 384 ,406 50, 712 Project Carryover - 50,712 (5 0,712) Total 1,990,391 1,656,697 333 ,694
Description
Fund 2040
Attachment 1
City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2023
Fund 2060 - HOME Grant Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2023/24
Operating Programs
Community Development
16400 Lower Income Housing (HOME) 81,013$ 76, 282$ 4, 731$ -$ Total Community Development 81,013 76,282 4, 731 - Total Operating Programs 81,013 76,282 4, 731 - Transfers Out
551026 General Fund - In Lieu 6,597 1, 426 5, 171 - Total Transfers Out 6,597 1,426 5, 171 - Projects
Special Projects
828750 Tenant Based Rental Assistance (HOME) 2,000,000 527 ,229 1, 472,771 1, 472,771 Total Projects 2,000,000 527,229 1, 472,771 1, 472,771 Total Appropriations 2,087,610 604,937 1, 482,673 1, 472,771 Project Carryover - 1,472,771 (1 ,472,771) Total 2,087,610 2,077,708 9, 902
Description
Fund 2060
Attachment 1
City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2023
Fund 2080 - Low & Moderate Income Housing Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2023/24
Operating Programs
Community Development
10500 Housing and CDBG Program 41,650$ 42, 545$ (8 95)$ -$ Total Community Development 41,650 42,545 (8 95) - Total Operating Programs 41,650 42,545 (8 95) - Transfers Out
580511 General Fund - In Lieu 3,488 3, 488 - - 580511 Housing Fund - Mitigation 2,500,000 2, 500,000 - - 580511 Employee Payroll & Benefits Fund 10,132 10, 128 4 - Total Transfers Out 2,513,620 2,513,616 4 - Projects
Special Projects
831761 Homeless Prevention and Rapid Re-Housing (HPRR) 250,000 200 ,586 49, 414 - Total Projects 250,000 200,586 49, 414 - Total Appropriations 2,805,270 2,756,747 48, 523 - Total 2,805,270 2,756,747 48, 523
Description
Fund 2080
Attachment 1
City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2023
Fund 2100 - Park Dedication Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2023/24
Projects
Capital Projects
826710 Washington Community Swim Center 110,000$ 34, 804$ 75, 196$ -$ 830510 Plaza del Sol Phase II 2,339,744 180 ,117 2, 159,627 2, 159,627 830600 Lakewood Branch Library Facility 2,360,038 134 ,316 2, 225,722 2, 353,895 831880 Preschool Outdoor Play Area 377,440 27, 223 350 ,217 350 ,217 832000 East and West Channel Trail Construction 500,000 - 500 ,000 500 ,000 834330 Corn Palace Park Development 806,359 51, 416 754 ,943 754 ,943 834580 Washington and Ortega Parks Light Conversion to LED 500,000 - 500 ,000 500 ,000 834680 Las Palmas Tennis Center Needs Assessment 31,451 248 31, 204 31, 204 835830 Manzano Way Park Acquisition 1,150,000 - 1, 150,000 1, 150,000 835960 Cricket Batting Cage 200,000 - 200 ,000 200 ,000 Infrastructure Projects
818550 Park Buildings - Rehabilitation 530,795 13, 495 517 ,300 517 ,300 820130 Routine Resurfacing of City Owned Parking Lots 25,428 - 25, 428 25, 428 820140 Computer/Radio Controlled Landscape Median Irrigation 50,000 155 49, 845 49, 845 820240 Park Tennis/Basketball Court Reconstruction 161,304 41, 933 119 ,372 119 ,372 820270 Playground Equipment Replacement 3,053,681 12, 292 3, 041,389 3, 041,389 820280 Park Furniture and Fixtures Replacement 195,621 152 ,659 42, 962 42, 962 825850 Swim Pools Infrastructure 99,324 8, 523 90, 801 - 827160 Sunnyvale Tennis Center Court Rehabilitation 119,194 - 119 ,194 119 ,194 829150 Swimming Pool Buildings Infrastructure 787,675 29, 213 758 ,462 758 ,462 829440 Land Acquisition Due Diligence 19,592 18 19, 574 19, 574 830310 Community Center Grounds Renovation and Enhancement 7,301,074 451 ,639 6, 849,434 6, 849,434 830340 Fair Oaks Park Renovation and Enhancement 884,208 102 ,377 781 ,831 781 ,831 830490 Fremont Pool Infrastructure Improvements 61,405 - 61, 405 61, 405 831340 Civic Center Modernization 18,049,110 8, 265,000 9, 784,110 9, 784,110 831860 John W. Christian Greenbelt Pathway Rehabilitation 20,000 4, 903 15, 098 15, 098 832720 Washington Pool Infrastructure Replacement and Renovation 9,974 - 9, 974 - 832770 De Anza Park Pathway Renovation 20,000 - 20, 000 - 832800 Performing Arts Center Infrastructure 452,200 - 452 ,200 452 ,200 834770 Lakewood Park Renovation and Enhancement 16,407,659 299 ,613 16, 108,046 16, 108,046 Special Projects
829160 Golf Course Tree Trimming and Removal 9,712 - 9, 712 - Total Projects 56,632,988 9,809,943 46, 823,045 46, 745,534 Transfers Out
Infrastructure Fund - Golf and Tennis 511,593 511,593 - - General Services Fund - Project Management Services 2,892,018 1,567,881 1, 324,137 - Total Transfers Out 3,403,611 2,079,474 1, 324,137 - Total Appropriations 60,036,599 11,889,417 48, 147,182 46, 745,534 Project Carryover - 46,745,534 (4 6,745,534) Total 60,036,599 58,634,951 1, 401,648
Description
Fund 2100
Attachment 1
City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2023
Fund 2200 - Asset Forfeiture Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2023/24
Operating Programs
Public Safety
12100 Police Services 1,740$ 3, 127$ (1 ,387)$ -$ Total Public Safety 1,740 3,127 (1 ,387) - Total Operating Programs 1,740 3,127 (1 ,387) - Projects
Capital Projects
819840 Police Services Equipment - Acquisition 16,733 - 16, 733 16, 733 Total Projects 16,733 - 16, 733 16, 733 Total Appropriations 18,473 3,127 15, 346 16, 733 Project Carryover - 16,733 (1 6,733) Total 18,473 19,860 (1 ,387) Description
Fund 2200
Attachment 1
City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2023
Fund 2220 - Police Services Augmentation Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2023/24
Operating Programs
Public Safety
12500 Investigation Services 406,735$ 408 ,262$ (1 ,526)$ -$ -
Total Public Safety 406,735 408,262 (1 ,527) - Total Operating Programs 406,735 408,262 (1 ,527) - Total Appropriations 406,735 408,262 (1 ,527) - Total 406,735 408,262 (1 ,527) Description
Fund 2220
Attachment 1
City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2023
Fund 2300 - Employment Development Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2023/24
Operating Programs
NOVA Workforce Services
15300 NOVA Workforce Services Department 10,500,000$ 9, 055,463$ 1, 444,537$ -$ Total NOVA Workforce Services 10,500,000 9,055,463 1, 444,537 - Total Operating Programs 10,500,000 9,055,463 1, 444,537 - Total Appropriations 10,500,000 9,055,463 1, 444,537 - Total 10,500,000 9,055,463 1, 444,537 Description
Fund 2300
Attachment 1
City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2023
Fund 2400 - Parking District Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2023/24
Operating Programs
Public Works
13500 Downtown Parking Lot Maintenance 106,319$ 62, 773$ 43, 546$ -$ 13700 Public Works Administration and Property Management 54,520 44, 326 10, 194 - 13902 Land Use Permits and Parcel Maps (Parking District Fund) - 17 (1 7) - Total Public Works 160,839 107,116 53,723 -
Total Operating Programs 160,839 107,116 53, 723 - Projects
Infrastructure Projects
831340 Civic Center Modernization 4,479 129 4, 350 4, 350 Total Projects 4,479 129 4, 350 4, 350 Transfers Out
General Fund - In Lieu 11,860 11,860 - - Long Term Rent - Civic Center Rent Expense 5,524 2,762 2, 762 - Employee Payroll & Benefits Fund 21,877 21,877 - - Total Transfers Out 39,261 36,499 2, 762 - Total Appropriations 204,579 143,744 60, 835 4, 350 Project Carryover - 4,350 (4 ,350) Total 204,579 148,094 56, 485 Description
Fund 2400
Attachment 1
City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2023
Fund 2500 - Gas Tax Street Improvement Fund
Description Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2023/24
Operating Programs
Public Works
13200 Pavement and Concrete Maintenance 1,250,000$ 824 ,634$ 425 ,366$ -$ Total Public Works 1,250,000 824,634 425 ,366 - Total Operating Programs 1,250,000 824,634 425 ,366 - Transfers Out
580511 General Services Fund - Project Management Service 137,766 182 ,186 (4 4,420) - Total Transfers Out 137,766 182,186 (4 4,420) - Projects
Infrastructure Projects
820120 Repaint Street Light Poles 20,000 3, 000 17, 000 - 820180 Traffic Signal Controller Replacement 1,121,267 - 1, 121,267 1, 121,267 820190 Traffic Signal Hardware and Wiring 2,188,575 192 ,174 1, 996,402 1, 996,402 820200 Traffic Signal Light Emitting Diode (LED) Array Replacements 986,659 311 ,601 675 ,058 675 ,058 825290 Pavement Rehabilitation 1,941,681 572 ,665 1, 369,016 1, 369,016 825340 Street Lights Conduit Replacement 869,703 419 ,785 449 ,918 - 825730 Pedestrian Lighted Crosswalk Maintenance and Replacement 14,650 12, 232 2, 418 2, 418 825740 Battery Backup System for Traffic Signals Maintenance 106,279 - 106 ,279 106 ,279 Capital Projects
831590 Intelligent Transportation Systems 403,939 - 403 ,939 403 ,939 831870 Preventive Maintenance for Various Bridges 331,498 - 331 ,498 331 ,498 832950 Java Drive Road Diet and Bike Lanes 269,400 133 ,257 136 ,143 - 832990 Sunnyvale Traffic Signal Upgrades 163,000 - 163 ,000 163 ,000 833850 Sunnyvale Safe Routes to School Improvements 801,307 - 801 ,307 801 ,307 835000 Pedestrian & Bicycle Safety Improvements at Fremont Ave. & Manet Drive/Bobwhite Ave. 60,000 - 60,000 60,000 835410 Fremont Avenue Traffic Signals Retiming 35,000 - 35, 000 35, 000 835420 Hollenbeck Avenue Traffic Signals Retiming 15,000 - 15, 000 15, 000 835430 Mary Avenue Traffic Signals Retiming 14,550 - 14, 550 14, 550 835440 Remington Drive Traffic Signals Retiming 14,645 - 14, 645 14, 645 Special Project
825400 Update of Standard Specifications and Details 5,463 - 5, 463 - Total Projects 9,362,616 1,644,715 7, 717,901 7, 109,378 Total Appropriations 10,750,382 2,651,535 8, 098,847 7, 109,378 Project Carryover - 7,109,378 (7 ,109,378) Total 10,750,382 9,760,913 989 ,469
Fund 2500
Attachment 1
City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2023
Fund 2520 - Road Maintenance and Rehabilitation Account (RMRA) Fund Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2023/24
Project
Infrastructure Project
825290 Pavement Rehabilitation 8,631,309$ 2, 201,096$ 6, 430,213$ 6, 430,213$ Total Projects 8,631,309 2,201,096 6, 430,213 6, 430,213 Total Appropriations 8,631,309 2,201,096 6, 430,213 6, 430,213 Project Carryover - 6,430,213 (6 ,430,213) Total 8,631,309 8,631,309 -
Description
Fund 2520
Attachment 1
City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2023
Fund 2540 - Transportation Development Act (TDA) Article 3 Fund Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2023/24
Projects
Capital Projects
834570 Install Green Bike Lanes 79,734$ 70, 928$ 8, 806$ -$ 835000 Pedestrian & Bicycle Safety Improvements at Fremont Ave. & Manet Drive/Bobwhite Ave. 299,709 238,669 61,040 61,040 835860 Pedestrian/Bicycle Pathway Spot Improvements 155,354 1, 324 154 ,030 154 ,030 Total Projects 534,797 310,921 223 ,876 215 ,070 Total Appropriations 534,797 310,921 223 ,876 215 ,070 Project Carryover - 215,070 (2 15,070) Total 534,797 525,991 8, 806
Description
Fund 2540
Attachment 1
City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2023
Fund 2560 - 2016 Measure B Santa Clara VTA Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2023/24
Projects
Capital Projects
835630 Stevens Creek Trail Extension (W. Remington Ave to W.
Fremont Ave) 3,498,658$ 304,548$ 3,194,110$ 3,194,110$ 836040 East Channel Trail Study 830,000 - 830 ,000 830 ,000 Infrastructure Projects
825290 Pavement Rehabilitation 709,370 931 ,793 (2 22,423) - 828030 Annual Slurry Seal of City Streets 692,650 265 ,264 427 ,386 427 ,386 829400 Sidewalk, Curb and Gutter Replacement 2,850,936 779 ,940 2, 070,996 2, 070,996 Special Project
835250 Bicycle and Pedestrian Education & Encouragement Program 556,144 48, 575 507 ,569 507 ,569 Total Projects 9,137,758 2,330,119 6, 807,639 7, 030,061 Total Appropriations 9,137,758 2,330,119 6, 807,639 7, 030,061 Project Carryover - 7,030,061 (7 ,030,061) Total 9,137,758 9,360,181 (2 22,423) Description
Fund 2560
Attachment 1
City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2023
Fund 2580 - VRF Local Road Improvement Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2023/24
Project
Infrastructure Project
825290 Pavement Rehabilitation 4,714,362$ 74, 096$ 4, 640,266$ 4, 640,266$ Total Projects 4,714,362 74,096 4, 640,266 4, 640,266 Total Appropriations 4,714,362 74,096 4, 640,266 4, 640,266 Project Carryover - 4,640,266 (4 ,640,266) Total 4,714,362 4,714,362 -
Description
Fund 2580
Attachment 1
City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2023
Fund 3100 - Capital Projects Fund
Final Budget Actual Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2023/24
Transfers Out
580511 General Fund - In Lieu 17,037$ 17, 155$ (1 18)$ -$ 521815 Real Property Purchase - 20, 000 (2 0,000) - Total Transfers Out 17,037 37,155 (2 0,118) - Projects
Subfund 3101 - General Assets
Capital Projects
825610 Fair Oaks Avenue Overhead Bridge 2,228,756 3, 376,973 (1 ,148,217) - 830600 Lakewood Branch Library Facility 23,038,081 420 ,893 22, 617,188 22, 617,188 832910 Bernardo Avenue Bicycle Undercrossing Environmental Analysis 276,427 55, 464 220 ,962 220 ,962 832920 East Sunnyvale Area Transportation Improvements 2,618,517 5, 656 2, 612,861 2, 612,861 832930 Fair Oaks Avenue Bike Lanes and Streetscape - Phase 2 176,000 (2 ,688) 178 ,688 - 832950 Java Drive Road Diet and Bike Lanes 342,549 230 ,164 112 ,384 25, 000 832960 Lawrence Station Area Sidewalks and Bicycle Facilities 354,913 258 ,850 96, 062 - 832970 Peery Park Area Transportation Improvements 2,651,110 232 ,891 2, 418,219 2, 418,219 832990 Sunnyvale Traffic Signal Upgrades 2,416,688 372 ,780 2, 043,908 2, 043,908 833000 Sunnyvale SNAIL Neighborhood Improvements - ATP 4,794,454 566 ,734 4, 227,719 4, 227,719 833790 Pedestrian and Bicyclist Infrastructure Improvements 918,789 742 ,430 176 ,359 176 ,359 833800 Pedestrian/Bicycle Improvement-Homestead Rd at Homestead 61,575 37,708 23,867 - 833850 Sunnyvale Safe Routes to School Improvements 1,546,451 25, 497 1, 520,954 1, 520,954 833890 Mary Ave Caltrain Tracks Cross Safety 1,249 1, 249 - - 834250 Advanced Dilemma Zone Detection Phase 2 - Highway Safety 1,152,665 874,121 278,544 278 ,544 834520 Tasman-Java LRT Corridor Signal Timing 3,574 888 2, 686 - 834530 Maude Avenue Corridor Signal Timing 1,230 343 887 - 834540 Mathilda-Sunnyvale-Saratoga Corridor Signal Timing 9,239 1, 999 7, 240 - 835060 Duane Avenue Traffic Signals Retiming 2,208 478 1, 730 - 835070 Wolfe Road Traffic Signals Retiming 5,613 1, 215 4, 398 - 835080 Homestead Road Traffic Signals Retiming 2,940 636 2, 304 - 835090 Bernardo Avenue Traffic Signals Retiming 1,935 419 1, 516 - 835100 Kifer Road Traffic Signals Retiming 1,882 407 1, 474 - 835410 Fremont Avenue Traffic Signals Retiming 315,000 54, 502 260 ,498 260 ,498 835420 Hollenbeck Avenue Traffic Signals Retiming 135,000 54, 502 80, 498 80, 498 835430 Mary Avenue Traffic Signals Retiming 130,950 22, 646 108 ,304 108 ,304 835440 Remington Drive Traffic Signals Retiming 131,805 22, 809 108 ,996 108 ,996 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 80, 401 412 ,249 412 ,249 835960 Cricket Batting Cage 75,000 - 75, 000 75, 000 835980 Evelyn Avenue Multi-use Trail 4,072,787 - 4, 072,787 4, 072,787 836040 East Channel Trail Study 1,000,000 - 1, 000,000 1, 000,000 Total Subfund 3101 - General Assets 50,860,035 7,439,969 43, 420,066 44, 160,046 Subfund 3105 - Community Benefits
Capital Projects
835210 Improve Bicycle and Pedestrian Access at Sunnyvale Caltrain Station 49,677 226 49,451 49,451 Infrastructure Projects
836660 Murphy Avenue Pedestrian Mall Improvements Total 800,000 - 800 ,000 800 ,000 Special Project
835390 Peery Park Rides Shuttle Program 500,000 - 500 ,000 500 ,000 Total Subfund 3105 - Community Benefits 1,349,677 226 1, 349,451 500 ,000 Subfund 3109 - Traffic Mitigation Projects
Capital Project
816000 Future Traffic Signal Construction 425,040 19, 876 405 ,164 405 ,164 Total Subfund 3109 - Traffic Mitigation Projects 425,040 19,876 405 ,164 405 ,164 Description
Fund 3100
Attachment 1
City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2023
Fund 3100 - Capital Projects Fund
Final Budget Actual Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2023/24Description
Subfund 3111 - Transportation Impact Fees
Capital Projects
830640 Stevens Creek Trail Extension (Dale/Heatherstone to Remington) 776,868 - 776,868 776,868 832440 Mary Avenue Overcrossing Environmental Impact Report 353,333 157 ,100 196 ,233 196 ,233 832910 Bernardo Avenue Bicycle Undercrossing Environmental Analysis 442,507 85,506 357,001 357,001 832920 East Sunnyvale Area Transportation Improvements 755,483 970 754 ,513 754 ,513 832930 Fair Oaks Avenue Bike Lanes and Streetscape - Phase 2 44,000 11, 914 32, 086 32, 086 832950 Java Drive Road Diet and Bike Lanes 89,103 12, 070 77, 033 25, 000 832960 Lawrence Station Area Sidewalks and Bicycle Facilities 94,274 68, 817 25, 457 - 833000 Sunnyvale SNAIL Neighborhood Improvements - ATP 1,198,863 141 ,684 1, 057,180 1, 057,180 833010 Bicycle and Pedestrian Safety Improvements 194,016 - 194 ,016 194 ,016 833020 Future Traffic Signal Construction 843,345 68, 881 774 ,464 774 ,464 833790 Pedestrian and Bicyclist Infrastructure Improvements 70,731 19, 803 50, 928 50, 928 833850 Sunnyvale Safe Routes to School Improvements 807,924 38, 256 769 ,669 769 ,669 834490 Enhanced Crosswalk on California Avenue at Pajaro Avenue 148,000 113 ,128 34, 872 7, 000 835000 Pedestrian & Bicycle Safety Improvements at Fremont Ave. & Manet Drive/Bobwhite Ave. 8,000 8,000 - - 835630 Stevens Creek Trail Extension (W. Remington Ave to W.
Fremont Ave) 389,000 33,839 355,161 355,161 835980 Evelyn Avenue Multi-use Trail 68,197 50 68, 147 68, 147 836040 East Channel Trail Study 1,000,000 - 1, 000,000 1, 000,000 Infrastructure Projects
829400 Sidewalk, Curb, and Gutter Replacement 99,000 - 99, 000 99, 000 831340 Civic Center Modernization 1,244,300 - 1, 244,300 1, 244,300 Special Projects
825530 Transportation Model Update 105,900 46, 444 59, 456 59, 456 Total Subfund 3111 - Transportation Impact 8,732,845 806,460 7, 926,385 7, 821,022 Total Projects 61,367,597 8,266,531 53, 101,066 52, 886,232 Total Appropriations 61,384,634 8,303,686 53, 080,948 52, 886,232 Project Carryover - 52,886,232 (5 2,886,232) Total 61,384,634 61,189,918 194 ,716
Fund 3100
Attachment 1
City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2023
Fund 3200 - Infrastructure Renovation & Replacement Fund Description Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2023/24
Projects
Capital Projects
825610 Fair Oaks Avenue Overhead Bridge Repair 1,664,200$ 622,882$ 1,041,318$ 1,041,318$ 829140 Fire Station Electrical System 36,141 - 36,141 36,141 835890 Fire Station 2 - New Construction 4,200,000 - 4,200,000 4,200,000 836010 Mobile Electric Vehicle Charging Stations 327,680 6,975 320,705 320,705 Infrastructure Projects
820270 Playground Equipment Replacement 777,463 - 777,463 777,463 825850 Swim Pools Infrastructure 430,258 - 430,258 430,258 831340 Civic Center Modernization 14,025,302 4,871,758 9,153,544 9,153,544 832730 Renovate Median Landscaping to Low Maintenance 2,933,037 7,121 2,925,916 2,925,916 Total Projects 24,394,080 5,508,736 18, 885,344 18, 885,344 Total Appropriations 24,394,080 5,508,736 18, 885,344 18, 885,344 Project Carryover - 18,885,344 (1 8,885,344) Total 24,394,080 24,394,080 -
Fund 3200
Attachment 1
City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2023
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 28,786,449$ 26, 346,150$ 2, 440,299$ 28, 786,449$ Total Projects 28,786,449 26,346,150 2, 440,299 28, 786,449 Total Appropriations 28,786,449 26,346,150 2, 440,299 28, 786,449 Project Carryover - 28,786,449 (2 8,786,449) Total 28,786,449 55,132,599 (2 6,346,150) Description
Fund 2400
Attachment 1
City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2023
Fund 6040 - Water Supply and Distribution Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2023/24
Debt Service
70112 2017A Water Revenue Refunding Bonds 515,000$ 523,987$ (8, 987)$ -$ 70113 2017A-T Water Revenue Refunding Bonds 633,560 633,984 (424) - Total Debt Service 1,148,560 1,157,971 (9, 411) - Operating Programs
Environmental Services
14300 Water Resources 8,585,935 7,885, 370 700,565 - 15000 Wholesale Water Purchases 35,682,738 35,665, 427 17,311 - 00001 City Wide Program - 48,311 ( 48,311) - Total Environmental Services 44,268,673 43,599,108 669,565 - Total Operating Programs 44,268,673 43,599,108 669,565 - Transfers Out
580511 Liability and Property Insurance Fund 282,476 282,476 - - 580511 General Fund - In Lieu 3,804,287 3,804, 287 - - 580511 Employee Payroll & Benefits Fund - Retirement 890,913 890,913 - - 580511 Employee Payroll and Benefits Fund - Leaves 31,368 31,368 - - 580511 General Services Fund - Project Management Services 1,023,444 964,079 59,365 - 580511 Insurance and Other Benefits Fund 428,127 428,127 - - 580511 Employee Payroll and Benefits Fund - Pension Trust 99,836 99,836 - - 580511 General Services Fund - Fleet Services 117,800 117,800 - - 551028 Civic Center Rent 323,471 161,736 161,735 - Total Transfers Out 7,001,722 6,780,622 221,100 - Projects
Capital Projects
806351 Land Development and Capital Construction 442,236 452,299 (10, 063) - 834360 Water System Seismic Risk and Vulnerability Study 200,000 36,248 163,752 163,752 834380 Fire Hydrant Replacement 120,000 46,775 73,225 60,000 834590 Urgent Water Main Repairs 250,000 27,962 222,038 222,038 Infrastructure Projects
815203 Replacement of Water/Sewer Supervisory Control System 95,000 - 95,000 95,000 825301 Pressure Reducing Valve Replacement & Relocation for SCADA 200,000 65,586 134,414 125,000 825451 City-wide Water Line Replacement 9,813,028 4,439, 656 5,373, 372 5,373, 372 830170 Refurbishment of Water Tanks 4,042,803 281,978 3,760, 825 3,760, 825 831340 Civic Center Modernization 282,053 206,248 75,805 75,805 831550 Adjust Water Utilities in Supp 345,563 - 345,563 345,563 831840 Cathodic Protection SFPUC Turnouts and Transmission Pipeline 811,506 - 811,506 811,506 834610 Water System GIS Updates and Maintenance 46,119 21,509 24,610 24,610 825251 Mary/Carson Water Plant Mechanical Reconstructions 7,767,302 - 7,767, 302 7,767, 302 Special Projects
818700 Corporation Yard Buildings - Rehabilitation 5,554 - 5,554 - 824281 Leak Detection and Condition Assessment Program 29,029 15,958 13,071 - 825400 Update of Standard Specifications and Details 5,463 - 5,463 - 830590 Corporation Yard Site Feasibility and Modernization Plan 8,229 4,478 3,751 3,751 831480 Water Conservation and Drought Response 73,426 18,630 54,796 30,000 831600 Solar Installations on City Facilities 74,860 13,906 60,954 5,000 834640 Interactive Voice Response (IVR) for Utility Billing Call Center 2,000 - 2,000 2,000 834650 Utility Billing Reporting Tool 6,668 2,894 3,774 3,774 834720 Laboratory Certification Update 25,000 - 25,000 7,500 835940 Comprehensive Update of 2013 Feasibility Study for RW Expansion 170,000 34,870 135,130 135,130 836110 Recycled Water Grant Matching 1,250,000 2,449 1,247, 551 1,247, 551 Total Projects 26,065,840 5,671,446 20,394, 394 20,259, 479 Total Appropriations 78,484,795 57,209,147 21,275, 648 20,259, 479 Description
Fund 6040
Attachment 1
City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2023
Fund 6040 - Water Supply and Distribution Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2023/24Description
Project Carryover - 20,259,479 (20, 259,479) Total 78,484,795 77,468,626 1,016, 169 Fund 6040
Attachment 1
City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2023
Fund 6080 - Wastewater Management Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2023/24
Debt Service
70114 2017A Wastewater Revenue Refunding Bonds 632,000$ 632,350$ (350)$ -$ 70115 2017A-T Wastewater Revenue Refunding Bonds 1,374,916 1,375, 845 (929) - 521012 Financial Services 5,500 2,350 3,150 Total Debt Service 2,012,416 2,010,545 1,871 - Operating Programs
Environmental Services
00001 City Wide Program - (9, 441) 9,441 - 14600 Wastewater Management 14,634,563 13,756, 572 877,991 - 14700 Regulatory Programs 3,453,733 2,963, 354 490,379 - 14800 Wastewater Collections 3,798,435 3,593, 439 204,996 - Total Environmental Services 21,886,731 20,303,924 1,582, 807 - Project Operating 28,743 - 28,743 - Total Non-Departmental 28,743 - 28,743 - Total Operating Programs 21,915,474 20,303,924 1,611, 550 - Transfers Out
551011 Interfund Loan Principal Repaid 805,766 805,765 1 - 551012 Interfund Loan Interest Paid 143,849 143,850 (1) - 580511 Liability and Property Insurance Fund 571,503 571,503 - - 580511 General Fund - In Lieu 2,877,123 2,877, 123 - - 580511 Employee Payroll & Benefits Fund 3,108,377 3,108, 377 - - 580511 General Services Fund - Project Management Services 439,335 413,599 25,736 - 551022 Long Term Rent - WPCP Expense 842,894 842,894 - - 551028 Civic Center Rent 554,285 277,143 277,142 Total Transfers Out 9,343,132 9,040,254 302,878 - Equipment
P20201 Wastewater Equipment 464,900 384,701 80,199 80,199 Total Equipment 464,900 384,701 80,199 80,199 Projects
Infrastructure Projects
805253 Sewer Emergency Repair and Replacement 670,924 639,152 31,772 - 815203 Replacement of Water/Sewer Supervisory Control System 5,000 - 5,000 5,000 825331 Replacement/Repair/Rehabilitation of Sanitary Sewer System 5,772,638 2,022, 874 3,749, 764 3,749, 764 825521 WPCP Biosolids Processing 1,979,488 1,885, 485 94,003 - 829070 Lawrence Expressway Sanitary Sewer Rehabilitation 30,000 6,610 23,390 23,390 830200 Repairs to the Secondary Process 100,000 96,258 3,742 830210 Repairs to the Power Generation Facility 829,224 441,849 387,375 287,375 830220 Repairs to the Tertiary Process 809,709 248,769 560,940 560,940 831340 Civic Center Modernization 483,265 354,324 128,941 128,941 831630 Repairs to Solids/Dewatering Facility 325,000 203,429 121,571 - 831680 Adjust Sewer Utilities in Support of Paving Projects 274,063 - 274,063 274,063 831730 WPCP Oxidation Pond Levee Rehabilitation 6,468,880 490,944 5,977, 936 5,977, 936 832430 Recycled and Potable Water Plan Development 146,165 - 146,165 - 833270 SCWP Community Improvements 640,000 - 640,000 640,000 834750 Peery Park Specific Plan Wastewater Capacity Improvements 1,069,668 29,313 1,040, 355 1,040, 355 Capital Projects
818700 Corporation Yard Buildings - Rehabilitation 2,805 - 2,805 - 822762 Storm Pump Station Number 2 Rehabilitation 131,168 8,136 123,032 - 828210 Inspection Data Mgmt and Handheld Data Entry Device Project 250,000 - 250,000 250,000 829100 Sanitary Sewer Siphon Cleaning and Assessment 690,473 19,265 671,208 30,000 830590 Corporation Yard Site Feasibility and Modernization Plan 4,204 2,239 1,965 1,965 833070 WPCP Electronic Operations & Maintenance Manual 343,516 15,879 327,637 327,637 834460 Sewer Capacity Enhancement Projects 1,000,000 25,011 974,989 974,989 Special Projects
824341 Wastewater Cost of Service Study 56,007 - 56,007 56,007 825400 Update of Standard Specifications and Details 5,463 - 5,463 - 830260 Sanitary Sewer Salinity Reduction Study 113,646 - 113,646 113,646 Description
Fund 6080
Attachment 1
City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2023
Fund 6080 - Wastewater Management Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2023/24Description
831600 Solar Installations on City Facilities 28,893 - 28,893 - 831620 Repairs to the WPCP Support Facilities 100,000 - 100,000 100,000 832920 East Sunnyvale Area Transportation Improvements 93,500 - 93,500 93,500 833060 Annual Digester Cleaning 198,738 - 198,738 142,635 834640 Interactive Voice Response (IVR) for Utility Billing Call Center 2,000 - 2,000 2,000 834650 Utility Billing Reporting Tool 6,666 2,894 3,772 3,772 834720 Laboratory Certification Update 51,379 10,971 40,408 7,500 835450 Stormwater - Wastewater Bacteria Control Program 100,000 53,709 46,291 46,291 835480 Baykeeper Litigation Expenses 113,371 109,553 3,818 3,818 835940 Comprehensive Update of 2013 Feasibility Study for Recycled Water Expansion 80,000 - 80,000 80,000 835991 Cupertino Sanitary District Sewer Flow Diversion 115,000 - 115,000 115,000 836440 Abandonment of Rancho Rinconada Sewer Line Segment 25,000 - 25,000 25,000 SRF Funded Projects
824771 Primary Process Design and Construction1 10,802,464 5,941,748 4,860, 716 4,860, 716 831470 WPCP Construction Management3 26,529,956 2,269,997 24,259, 959 24,259, 959 830240 WPCP Program Management2 5,159,210 2,515,783 2,643, 427 2,643, 427 WIFIA Funded Projects
833110 SCWP Oversight 465,297 298,923 166,374 - 833150 SCWP Existing Plant Rehabilitation - Split Flow 64,265,831 2,775, 711 61,490, 120 61,490, 120 833210 SCWP Secondary Treatment Improvements-Split Flow CAS Stage 1 104,451,037 28,012, 206 76,438, 831 76,438, 831 833240 SCWP Administration and Lab Building 1,293,057 - 1,293, 057 1,293, 057 All other Clean Water Program Projects
833100 SCWP - Capital Replacement 430,000 - 430,000 - 833120 SCWP Environmental Mitigation 1,439,719 21,479 1,418, 240 1,418, 240 833370 SCWP Cogeneration Upgrade 1,606,691 - 1,606, 691 1,606, 691 834390 SCWP WPCP Condition Assessment 1,300,000 - 1,300, 000 1,300, 000 834400 SCWP Master Plan Update 1,750,000 163,269 1,586, 731 1,586, 731 834900 SCWP Financing Support 772,222 31,206 741,016 741,016 835500 Cleanwater Program Reserve 257,232 - 257,232 257,232 Total Projects 243,638,570 48,696,986 194,941, 584 192,957, 544 Total Appropriations 277,374,492 80,436,410 196,938, 082 193,037, 743 Project Carryover - 192,957,544 (192, 957,544) Equipment Carryover - 80,199 (80, 199) Total 277,374,492 273,474,153 3,900, 339
Fund 6080
Attachment 1
City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2023
Fund 6100 - Solid Waste Management Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2023/24
Operating Programs
00001 City Wide Program -$ ( 137,444)$ 137 ,444$ -$ 13200 Pavement and Concrete Maintenance 922,415 903,552 18, 863 - 14400 Solid Waste Management 51,695,880 50, 155,249 1, 540,631 - 14700 Regulatory Programs 60,726 63, 116 (2 ,390) - 15100 Stormwater Collections 136,342 11, 440 124 ,902 - Total Environmental Services 52,815,363 50,995,913 1, 819,450 - Total Operating Programs 52,815,363 50,995,913 1, 819,450 - Transfers Out
551011 Interfund Principle Repaid - General Fund 3,280,350 3, 280,350 - - 551012 Interfund Interest Paid - General Fund 189,852 189 ,852 - - 551021 Long Term Rent - 301 Carl Rd (SMaRT) 839,060 839 ,060 - - 551023 Long Term Rent-Landfill 522,965 522 ,965 - - 580511 Liability and Property Insurance Fund 59,123 59, 123 - - 580511 General Fund 4,120,387 4, 120,387 - - 580511 Employee Payroll & Benefits Fund 645,617 645 ,617 - - 551028 Civic Center Rent 175,106 87, 553 87, 553 - 580511 Project Administration 16,101 15, 154 947 - Total Transfers Out 9,848,561 9,760,061 88, 500 - Projects
Infrastructure Projects
825911 Flare Structure Replacement 50,000 - 50, 000 50, 000 831600 Solar Installations on City Facilities 100,397 - - - 831340 Civic Center Modernization 152,716 111 ,057 41, 659 41, 659 Capital Projects
829081 Storm System Trash Control Devices 629,835 61, 818 568 ,017 568 ,017 Special Projects
801351 Sunnyvale Contribution to SMaRT Station Equipment Rep. 66,897 66, 897 - - 821181 Contribution to SMaRT Station Operations Contract RFP 176,975 - 176 ,975 - 824261 Solid Waste Cost of Service Study 11,856 5, 615 6, 241 6, 241 830910 Zero Waste Strategic Plan 585,766 280 ,606 305 ,160 - 831691 Storm System Trash Reduction Programs 180,981 - 180 ,981 65, 000 833040 Landfill South Hill Drainage Correction 186,455 1, 816 184 ,639 100 ,000 834640 Interactive Voice Response (VR) for Utility Billing Call Center 2,000 - 2, 000 2, 000 834650 Utility Billing Reporting Tool 6,666 2, 894 3, 772 3, 772 835460 Recycle Yard Transition to Parking Lot 50,000 - 50, 000 - Total Projects 2,200,544 530,703 1, 669,841 836 ,689 Total Appropriations 64,864,468 61,286,677 3, 577,791 836 ,689 Project Carryover - 836,689 (8 36,689) Total 64,864,468 62,123,366 2, 741,102
Description
Fund 6100
Attachment 1
City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2023
Fund 6140 - SMaRT Station Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2023/24
Operating Programs
Environmental Services
14500 SMaRT Station 29,607,127$ 27, 429,212$ 2, 177,915$ -$ Total Environmental Services 29,607,127 27,429,212 2, 177,915 - Total Operating Programs 29,607,127 27,429,212 2, 177,915 - Transfers Out
580511 Employee Payroll & Benefits Fund 162,040 162 ,040 - - 580511 Civic Center Rent 16,281 8, 141 8, 140 - 551028 SMaRT Station Land Rent 375,251 - 375 ,251 Total Transfers Out 553,572 170,181 383 ,391 - Projects
Infrastructure Projects
811250 SMaRT Station Equipment Replacement 93,870 - 93, 870 93, 870 828260 Replace SMaRT Station 29,728,182 259 ,169 29, 469,013 29, 469,013 831340 Civic Center Modernization 14,743 10, 577 4, 166 4, 166 Special Projects
821170 SMaRT Station Operations Contract RFP 239,868 - 239 ,868 - 836000 Anaerobic Digestion and Composting Improvements 3,000,000 1, 544,753 1, 455,247 1, 455,247 Total Projects 33,076,663 1,814,499 31, 262,164 31, 022,296 Total Appropriations 63,237,362 29,413,892 33, 823,470 Project Carryover - 31,022,296 (3 1,022,296) Total 63,237,362 60,436,188 2, 801,174
Description
Fund 6140
Attachment 1
City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2023
Fund 6180 - Development Enterprise Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2023/24
Operating Programs
Community Development
10300 Building Safety 5,205,232$ 5, 479,722$ (2 74,490)$ -$ 10400 Planning 2,753,436 3, 129,653 (3 76,217) - Total Community Development 7,958,668 8,609,375 (6 50,707) - Public Works
13100 Transportation and Traffic Services 465,023 398 ,484 66, 539 - 13400 Urban Forestry 50,130 47, 384 2, 746 - 13900 Land Development - Engineering Services 2,253,312 1, 876,880 376 ,432 - Total Public Works 2,768,465 2,322,747 445 ,718 - Environmental Services
14700 Regulatory Programs 263,079 157 ,951 105 ,129 - Total Environmental Services 263,079 157,951 105 ,128 - Library and Recreation Services
12000 Community Services 24,744 29, 097 (4 ,353) - Total Library and Recreation Services 24,744 29,097 (4 ,353) - Office of the City Attorney
10100 Comprehensive Legal Services 432,412 403 ,844 28, 568 - Total Office of the City Attorney 432,412 403,844 28, 568 - Public Safety
12900 Fire Prevention and Hazardous Material Services 1,289,005 1, 157,052 131 ,953 - Total Public Safety 1,289,005 1,157,052 131 ,953 - Office of the City Manager
10200 Office of the City Manager 391,554 278 ,868 112 ,686 - Total Office of the City Manager 391,554 278,868 112 ,686 - Total Operating Programs 13,127,927 12,958,934 168 ,993 - Transfers Out
580511 General Fund - In Lieu 1,846,009 1, 846,009 - - 580511 Property and Liability Insurance Fund 8,374 8, 374 - - 580511 Employee Payroll & Benefits Fund 2,915,234 2, 915,234 - - 580511 General Services Fund - Technology and Communication 500,000 500 ,000 - - 551028 Civic Center Rent 1,246,774 623 ,387 623 ,387 Total Transfers Out 6,516,391 5,893,005 623 ,386 - Projects
Special Projects
830901 Transportation and Traffic Services 12,194 12, 194 - - 833960 Moffett Park Specific Plan Staffing 220,892 284 ,233 (6 3,341) - 834260 Cost of Service Study for Community Development Fees 53,400 - 53, 400 53, 400 835190 Updates to Single Family Home 100,000 46, 218 53, 783 53, 783 834730 Public Safety Impact Fee Study 125,000 - 125 ,000 125 ,000 835910 Stormwater Permit Implementation 50,000 50, 000 50, 000 Infrastructure Projects
831340 Civic Center Modernization 1,086,944 798 ,551 288 ,392 288 ,392 Total Projects 1,648,430 1,141,196 507 ,234 570 ,575 Description
Fund 6180
Attachment 1
Total Appropriations 21,292,748 19,993,135 1, 299,613 570 ,575 Project Carryover - 570,575 (5 70,575) Total 21,292,748 20,563,710 729 ,038
Fund 6180
Attachment 1
City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2023
Fund 6200 - Golf and Tennis Operations Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2023/24
Operating Programs
Public Works
14000 Golf Course Operations 4,051,891$ 4, 257,973$ (2 06,082)$ -$ Total Public Works 4,051,891 4,257,973 (2 06,082) - Total Operating Programs 4,051,891 4,257,973 (2 06,082) - Projects
Infrastructure Projects
831340 Civic Center Modernization 142,744 105 ,768 36, 976 36, 976 Total Projects 142,744 105,768 36, 976 36, 976 Transfers Out
General Fund - In Lieu 388,617 388,617 - - Long Term Rent - Civic Center Rent Expense 163,787 81,894 81, 893 - Employee Payroll & Benefits Fund 583,814 583,813 1 - Liability & Property Insurance Fund 67,540 67,540 - - Total Transfers Out 1,203,757 1,121,863 81, 894 - Total Appropriations 5,398,392 5,485,604 (8 7,212) 36, 976 Project Carryover - 36,976 (3 6,976) Total 5,398,392 5,522,580 (1 24,188) Description
Fund 6200
Attachment 1
City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2023
Fund 7020 - General Services Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2023/24
Equipment
P20600 Furniture 111,766 -$ 1 11,766$ -$ P20700 Fleet Equipment 6,642,627 3,702,920 2, 939,707 2, 939,707 P21300 Building Maintenance Equipment 645,082 87,712 557 ,370 557 ,370 P21600 Information Processing Hardware 2,000,959 328,152 1, 672,808 1, 485,700 P21601 Information Processing Software 3,751,958 247,487 3, 504,471 - P21603 Communications and Office Equipment 376,937 164,864 212 ,073 212 ,073 P21610 KSUN Equipment 245,261 49,844 195 ,417 10, 000 P21612 Payroll HRIS 229,462 159,886 69, 576 69, 576 Total Equipment 14,004,052 4,740,865 9, 263,187 5, 274,426 Operating Programs
Finance
11000 Purchasing 623,229 689 ,919 (6 6,690) - 11200 Accounting and Financial Services 279,718 200 ,231 79, 487 - Total Finance 902,947 890,150 12, 797 - Information Technology
15200 Information Technology Services and Support 11,808,171 11, 636,726 171 ,445 - Total Information Technology 11,808,171 11,636,726 171 ,445 - Public Works
13800 Capital Project Management 4,019,505 3, 754,633 264 ,872 - 14100 Fleet, Fuel, and Equipment 3,974,288 4, 436,343 (4 62,055) - 14200 Facility Services 5,535,351 5, 287,581 247 ,770 - Total Public Works 13,529,144 13,478,557 50, 587 - Total Operating Programs 26,240,262 26,005,433 234 ,829 - Transfers Out
580511 General Fund - In Lieu 175,854 175 ,854 - - 580511 Employee Payroll and Benefits Fund 4,123,500 4, 123,500 - - 580511 Infrastructure Fund 423,000 423 ,000 551028 Civic Center Rent 1,432,795 716 ,397 - Total Transfers Out 6,155,149 5,438,751 716 ,398 - Projects
Infrastructure Projects
818700 Corporation Yard Buildings - Rehabilitation 20,984 - 20, 984 - 831340 Civic Center Modernization 144,545 100 ,480 44, 065 44, 065 Special Projects
830521 ERP System Acquisition, Implementation, and Support 4,441,019 1, 490,331 2, 950,688 2, 950,688 832270 Permitting System Replacement 1,771,897 1, 248,285 523 ,611 523 ,611 834600 Microsoft Server OS and SQL Server Upgrade 157,625 4, 454 153 ,171 153 ,171 835920 Library Office Reconfiguration 140,000 6, 922 133 ,079 133 ,079 835610 Computer Aided Dispatch (CAD) System Replacement 4,623,994 48, 558 4, 575,437 4, 575,437 -
Capital Projects -
830590 Corporation Yard Site Feasibility and Modernization Plan 31,779 16, 119 15, 660 15, 660 Total Projects 11,331,842 2,915,149 8, 416,693 8, 395,709 Total Appropriations 57,731,305 39,100,198 18, 631,107 13, 670,135 Equipment Carryover - 5,274,426 (5 ,274,426) Project Carryover - 8,395,709 (8 ,395,709) Total 57,731,305 52,770,333 4, 960,972
Description
Fund7020
Attachment 1
City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2023
Fund 7060 - Employee Payroll and Benefits Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2023/24
Operating Programs
Human Resources
11500 Employee Leave Benefits - Leave Earned 19,143,860$ 19, 592,460$ (4 48,600)$ -$ 11600 Retirement, Insurances, and Taxes 80,939,998 77, 773,167 3, 166,831 - 11700 Workers' Compensation Program 5,707,744 6, 179,111 (4 71,367) - -
Total Human Resources 105,791,602 103,544,738 2, 246,864 - Non-Departmental
00001 Non-Programmatic Pension Trust 11,498 2, 298 9, 199 - Total Non-Departmental 11,498 2,298 9, 200 - Total Operating Programs 105,803,100 103,547,036 2, 256,064 - Transfers Out
00001 Transfers Out - Employee Benefits - PTO to GF 2,418,675 2, 343,256 75, 419 - 00001 Non-Programmatic Transfer to OPEB Trust 3,086,000 3, 086,000 - - Total Transfers Out 5,504,675 5,429,256 75, 419 - Total Appropriations 111,307,775 108,976,292 2, 331,483 - Deferred Transfers Out - -
Total 111,307,775 108,976,292 2, 331,483
Description
Fund 7060
Attachment 1
City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2023
Fund 7080 - Property and Liability Insurance Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2023/24
Operating Programs
Human Resources
11400 Human Resources 124,858$ 80, 822$ 44, 036$ -$ 11800 City Liability and Property Insurance and Claim Costs 4,628,437 4, 844,464 (2 16,027) - Total Human Resources 4,753,295 4,925,286 (1 71,991) - Total Operating Programs 4,753,295 4,925,286 (1 71,991) - Transfer Out
580511 Employee Payroll and Benefits Fund 17,649 17, 649 - Total Transfer 17,649 17,649 - - Total Appropriations 4,770,944 4,942,935 (1 71,991) - Total 4,770,944 4,942,935 (1 71,991) Description
Fund 7080
Attachment 1
City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2023
Fund 5040 - Fremont Pool Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2023/24
Transfers Out
580511 General Fund - In Lieu 26,867$ 20, 987$ 5, 880$ -$ Total Transfers Out 26,867 20,987 5, 880 - Total Appropriations 26,867 20,987 5, 880 - Total 26,867 20,987 5, 880 Description
Fund 5040
Attachment 1
City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2023
Fund 5080 - Swirsky Youth Opportunity Fund
Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2023/24
Transfers Out
580511 General Fund - In Lieu 13,800$ 10, 777$ 3, 023$ -$ Total Transfers Out 13,800 10,777 3, 023 - Total Appropriations 13,800 10,777 3, 023 - Total 13,800 10,777 3, 023 Description
Fund 5080
Attachment 1
City of Sunnyvale
Year-end Appropriations Budget
Fiscal Year Ending June 30, 2023
Fund 8100 - Community Facilities District No. 3 (Estates at Sunnyvale) Fund Final Budget
Actual
Expenditures
Variance
Favorable
(Unfavorable)
Carryover to
FY 2023/24
Operating Programs
Public Works
15100 CFD Estates at Sunnyvale 26,431$ 13, 158$ 13, 273$ -$ Total Public Works 26,431 13,158 13, 273 - Total Operating Programs 26,431 13,158 13, 273 - Projects
Infrastructure Projects
831340 Civic Center Modernization 305 - 305 305 831390 CFD #3 Ten Year Infrastructure Improvements 44,941 - 44, 941 44, 941 Total Projects 45,246 - 45, 246 45, 246 Transfers Out
580511 General Fund - In Lieu 1,970 1, 970 - - 580511 Employee Payroll and Benefits Fund 3,607 3, 607 - - 580511 Civic Center Rent 337 169 168 - Total Transfers Out 5,914 5,746 168 - Total Appropriations 77,591 18,904 58, 687 45, 246 Project Carryover - 45,246 (4 5,246) Total 77,591 64,150 13, 441 Description
Fund 8100
Attachment 1