Alameda City Council
March 21, 2023

Exhibit 1
FY 22/23 FY21-22 FY 21/22
% of % of % of
Total YTD Budget Year-End YTD Budget
Q2 Revised Budget Budget Actual to Actual Estimate Actual YTD Difference % Change to Actual Property Taxes $53,260,000 43% $25,321,300 48% $54,750,000 $23,286,408 $2,034,892 9% 46% Sales Taxes / Transaction and Use Tax 21,389,900 17% 5,877,847 27% 21,789,900 7,161,825 ($1,283,978) -18% 38% Utility User Taxes 9,192,500 7% 3,022,635 33% 9,192,500 2,675,738 $346,898 13% 31% Franchise Fees 3,949,000 3% 1,133,605 29% 3,089,000 1,282,581 ($148,976) -12% 41% Transfer Tax 13,000,000 11% 5,997,904 46% 13,000,000 9,177,100 ($3,179,195) -35% 61% Transient Occupancy Tax 2,400,000 2% 1,027,532 43% 2,800,000 1,074,152 ($46,619) -4% 49% Business License Taxes 2,300,000 2% 2,598,765 113% 2,700,000 2,351,800 $246,964 11% 107% Departmental Revenues 8,601,371 7% 3,715,317 43% 8,553,771 3,406,691 $308,626 9% 40% Interest, Rental Income and Other 4,242,703 3% 2,611,205 62% 4,242,703 1,206,968 $1,404,236 116% 33% Transfers In 4,528,000 4% 674,445 15% 12,008,313 2,154,228 ($1,479,783) -69% 49% Total Revenues $122,863,474 100% $51,980,555 42.31% $132,126,187 $53,777,492 ($1,796,937) -3.34% 46% FY 22/23 FY 22/23 FY 22/23 to 21/22
Year over Year
49%
33%
40%
107%
49%
61%
41%
31%
38%
46%
15%
62%
43%
113%
43%
46%
29%
33%
27%
48%
0% 20% 40% 60% 80% 100% 120%
Transfers In
Interest, Rental Income and Other
Departmental Revenues
Business License Taxes
Transient Occupancy Tax
Transfer Tax
Franchise Fees
Utility User Taxes
Sales Taxes / Transaction and Use Tax
Property Taxes
City of Alameda, California
General Fund Unaudited Revenue Report through Second Quarter As a % of Budget to Actual for FY 22/23 and FY 21/22
FY22-23
FY21-22
1 FY 21/22 FY 21/22
% of % of % of
Total YTD Budget YTD Budget
Budget Budget Actual to Actual Actual YTD Difference % Change to Actual Fire 47,532,666 38% 20,880,885 44% 18,681,306 2,199,579 12% 44% Police 42,978,116 34% 18,688,010 43% 17,910,494 777,516 4% 43% Total Public Safety 90,510,782 72% 39,568,896 44% 36,591,801 2,977,095 8% 44% City Council 240,926 0% 36,757 15% 59,842 (23,085) -39% 22% City Attorney 1,413,309 1% 338,435 24% 340,883 (2,448) -1% 34% City Clerk 890,229 1% 288,111 32% 280,070 8,041 3% 45% City Manager 1,290,793 1% 183,170 14% 373,898 (190,727) -51% 18% Finance 3,189,505 3% 1,137,076 36% 1,038,080 98,995 10% 34% Human Resources 1,215,118 1% 393,776 32% 468,688 (74,911) -16% 38% Total General Government 8,239,880 7% 2,377,326 29% 2,561,462 -184,135 -7% 31% Community Development 1,486,284 1% 267,227 18% 158,032 109,194 69% 12% Planning, Bldg & Transportation 144,053 0% 63,459 44% - Total Community Development 1,630,337 1% 330,686 20% 158,032 109,194 69% 12% Recreation and Parks 12,132,702 10% 5,762,549 47% 4,735,722 1,026,826 22% 43% Public Works 3,934,041 3% 1,751,815 45% 1,536,723 215,092 14% 39% Non Departmental 10,047,288 8% 3,436,878 34% 3,590,326 (153,448) -4% 19% Total Expenses 126,495,030$ 100% 53,228,149$ 42% 49,174,065$ 3,990,624$ 8% 39% FY 22/23 FY 22/23 FY 22/23 to 21/22
Year over Year
19%
39%
43%
12%
43%
44%
31%
34%
45%
47%
20%
43%
44%
29%
0% 5% 10% 15% 20% 25% 30% 35% 40% 45% 50%
Non Departmental
Public Works
Recreation and Parks
Community Development
Police
Fire
General Government
City of Alameda, California
General Fund YTD Expenditures by Department (Unaudited) As a % of Budget to Actual for FY 22/23 and FY 21/22
FY22/23
FY21/22
2 FY 21/22 FY 21/22
% of % of % of
Total YTD Budget YTD Budget
Budget Budget Actual to Actual Actual YTD Difference % Change to Actual Salaries and Benefits 83,954,795 66% 38,347,648 46% 35,394,861 2,952,787 8% 46% Operating Expenditures 18,020,146 14% 4,977,811 28% 4,124,888 852,922 21% 26% Cost Allocation 14,190,603 11% 7,077,968 50% 6,485,346 592,622 9% 49% Debt Service 235,000 0% 117,498 50% 114,076 3,422 3% 50% Capital Outlay 382,335 0% 40,195 11% - 40,195 0% 0%
Transfers Out 9,712,151 8% 2,667,029 27% 3,054,894 (387,865) -13% 15% Total Expenses 126,495,030 100% 53,228,149 42% 49,174,065 4,054,083 8% 39% FY 22/23 FY 22/23 FY 22/23 to 21/22
Year over Year
15%
0%
50%
49%
26%
46%
27%
11%
50%
50%
28%
46%
0% 10% 20% 30% 40% 50% 60%
Transfers Out
Capital Outlay
Debt Service
Cost Allocation
Operating Expenditures
Salaries and Benefits
City of Alameda, California
General Fund YTD Expenditures by Type (Unaudited)
As a % of Budget to Actual for FY 22/23 and FY 21/22
FY22/23
FY21/22
3 City of Alameda
FY 22/23 Life-to-Date Capital Project Report
Through December 31, 2022 (Unaudited)
As of
12/31/22 % Expended
Project Revised Life-to-Date Outstanding Remaining and
Number Description Budget Actual Expenses Encumbrances Budget Encumbered Capital Projects
C11000 Pavement Management 33,099,400 26,840,571 2,201,087 4,057,742 88% C11100 Otis/Pacific Resurfacing 1,579,000 1,565,569 - 13,431 99% C12000 Signs, Pavement Markings 928,524 484,854 28,137 415,533 55% C12100 Commercial/Slow Streets 780,350 193,441 13,154 573,755 26% C13000 Traffic Signals & Systems 5,385,423 4,020,421 190,791 1,174,211 78% C14000 Sidewalks 3,147,835 2,072,420 217,871 857,544 73% C15000 Park Pathway Repair & Replacement 500,000 400,000 - 100,000 80% C16000 Street, Park, Parking Lot Lighting 3,536,044 2,043,954 197,525 1,294,565 63% C16100 Shoreline Park Pathway Lighting 1,240,734 1,240,734 - 0 0% C17000 Urban Forest - Trees & Landscape Mtce 8,836,081 4,696,602 2,706,648 1,432,832 84% C31000 Storm Water Management 3,209,743 2,149,044 239,865 820,834 74% C32000 Storm Water Pump Stations 2,624,255 1,477,498 1,121,374 25,383 99% C33000 Green Infrastructure/Trash Capture 190,000 - - 190,000 0% C34000 Lagoon Maintenance 1,517,128 949,188 209,721 358,220 76% C34100 Bayview Weir 168,000 154,304 - 13,696 92% C34200 Harbor Bay Lagoon Gate 174,863 177,582 - (2,720) 102% C34300 Lagoons 182,872 144,554 - 38,318 79% C35000 Shoreline Maintenance 705,446 84,585 82,855 538,006 24% C41000 City Buildings - Public Works 12,754,650 7,840,400 973,407 3,940,843 69% C42000 City Bldgs - Public Safety 830,850 659,782 31,944 139,124 83% C42100 Fire Station #1 Improvements 150,000 (149,716) - 299,716 -100% C43000 Library Improvements 253,000 54,144 37,380 161,476 36% C44000 Parking 1,947,900 314,710 - 1,633,190 16% C44100 Parking - Main Street 729,100 561,893 26 167,181 77% 4 City of Alameda
FY 22/23 Life-to-Date Capital Project Report
Through December 31, 2022 (Unaudited)
As of
12/31/22 % Expended
Project Revised Life-to-Date Outstanding Remaining and
Number Description Budget Actual Expenses Encumbrances Budget Encumbered C44200 Parking - Harbor Bay 600,000 114,500 - 485,500 19% C44300 Seaplane Ferry Parking 300,000 - - 300,000 0% C71100 Sea Level Rise 2,450,000 66,242 - 2,383,758 3% C71200 Climate Plan 586,375 485,991 - 100,384 83% C71300 Northern Shoreline - Posey/Webster Tubes 310,000 125,070 3 184,928 40% C73000 Fernside Eastshore Pathways 1,514,513 (459,129) 133,700 1,839,942 -21% C74000 Public Art in Public Spaces 378,500 16,295 - 362,205 4% C74100 Physical Art 210,000 204,899 - 5,101 0% C74200 Estuary Park Service Road 885,000 839,112 - 45,888 95% C75000 Alameda Point Backbone Infrastructure 36,862,277 15,271,288 21,010,606 580,383 98% C75100 RESHAP 350,000 213,999 - 136,001 61% C75200 Alameda Point Big Whites Painting 2,800,000 287,213 1 2,512,786 10% C76000 Doolittle Landfill - Flare & Piping 500,000 - - 500,000 0% C80100 Citywide WiFi 200,000 183,302 19,885 (3,187) 102% C80300 ERP Implementation 5,915,298 2,664,498 121,693 3,129,107 47% C80400 Strategic Technology Plan 880,000 547,844 57,495 274,661 69% C80500 Electronic Doc Mgmt/GIS 1,000,000 - - 1,000,000 0% Total Capital Projects 140,213,161 78,537,657 29,595,164 32,080,340 77% Recreation & Park Projects
C51000 Park Maintenance Improvements 2,199,000 754,082 18,380 1,426,538 35% C51100 Park Irrigation Improvements 400,000 406,026 - (6,026) 102% C52000 Playground Replacements 1,897,000 1,690,934 67,096 138,970 93% C52400 Woodstock Park Rec Center 190,000 148,253 - 41,747 78% C52500 Estuary Park Field Design 5,576,000 5,543,276 10,169 22,555 100% 5 City of Alameda
FY 22/23 Life-to-Date Capital Project Report
Through December 31, 2022 (Unaudited)
As of
12/31/22 % Expended
Project Revised Life-to-Date Outstanding Remaining and
Number Description Budget Actual Expenses Encumbrances Budget Encumbered C52600 Park ADA Upgrades 100,000 (20,231) 18,900 101,331 -1% C52700 Officers Club Improvements 44,500 21,685 - 22,815 49% C52800 Godfrey Restroom Replacement 748,099 608,014 - 140,085 81% C52900 Alameda Point Gym-Modular Restroom 1,070,769 980,207 - 90,563 92% C54000 Mastick Center Imprevements 565,000 175,148 19,500 370,352 34% C54100 Mastick Front Entry Improvements 100,000 24,324 - 75,676 24% C55100 Krusi Park 2,259,000 2,224,194 - 34,806 98% C55200 De-Pave Park 825,000 25,000 - 800,000 3% C55300 East End Dog Park 75,000 - - 75,000 0%
C55400 New City Aquatic Center 150,000 50,198 - 99,802 33% C55500 Littlejohn Park Rec Center Rebuild 2,127,686 282,406 1,596,217 249,063 88% C55600 Marina Village Park Renovation 1,054,000 267,588 - 786,412 25% C55700 Park Light/Court Resurface 275,000 203,052 - 71,948 74% C55800 Emma Hood Pool Repairs 250,000 (18,859) - 268,859 -8% C55900 Leydecker Park Rec Center 213,528 128,367 - 85,161 60% C56100 Encinal Boat Ramp Design 2,136,734 2,069,754 - 66,980 97% C56200 Jean Sweeney Park (ARPD) 7,617,438 7,556,523 60,915 0 100% C56300 Neptune Park Path 215,000 38,082 - 176,918 18% C58100 Golf Parking Lot Improvements 500,000 497,681 - 2,319 100% Total Recreation & Park Projects 18,327,054 12,913,514 1,730,261 3,683,279 80% Transportation Projects
C61000 Street Safety 3,200,000 688,143 110,247 2,401,610 25% C62000 Safe Routes to School Infrastructure 368,000 57,477 17,695 292,829 20% C63000 Active Transportation Plan Implementation 600,000 - - 600,000 0% C63100 Bike/Ped 946,000 674,816 - 271,184 71% 6 City of Alameda
FY 22/23 Life-to-Date Capital Project Report
Through December 31, 2022 (Unaudited)
As of
12/31/22 % Expended
Project Revised Life-to-Date Outstanding Remaining and
Number Description Budget Actual Expenses Encumbrances Budget Encumbered C65000 Cross Alameda Trail 7,181,895 7,133,663 22,846 25,385 100% C65010 Cross Alameda Trail Connectors 427,000 - - 427,000 0% C65100 Otis Dr Traffic Calming & Safety 1,275,000 1,198,108 50 76,842 94% C65200 Clement Ave CAT - Grant to Broadway 6,843,000 1,378,968 435,050 5,028,982 27% C65300 Clement & Tilden Way Complete Streets 5,217,000 1,777,478 91,797 3,347,726 36% C65400 Appezzato Pkwy Dedicated Bus Lane 2,700,000 - - 2,700,000 0% C65500 Bay Farm Island Intersection Control 300,000 111,561 - 188,439 37% C65600 Central Ave Safety Improvements 15,255,300 3,120,894 395,630 11,738,776 23% C65700 Lincoln Marshall Safety Improvements 200,000 126,579 29,809 43,612 78% C65800 Cross Alameda Trail - Jean Sweeney 4,109,381 4,114,381 - (5,000) 100% C65900 West End Bicycle Pedestrian Crossing 1,555,000 19,729 1,530,271 5,000 100% C66000 Park St Corridor Operations Improvements 1,139,921 956,406 - 183,515 84% C67000 Seaplane Lagoon Ferry Terminal 23,804,676 21,607,290 - 2,197,386 91% Total Transportation Projects 26,499,597 22,583,426 1,530,271 2,385,900 91% Sewer Projects
C21000 Sewer Rehabilitation 45,516,542 33,812,260 5,073,892 6,630,391 85% C22000 Sewer Pump Stations 17,033,534 11,164,464 1,456,512 4,412,558 74% C23000 Cyclic Sewer Replacement 7,586,201 7,586,201 - 0 100% Total Sewer Projects 70,136,277 52,562,924 6,530,404 11,042,949 84% 7