Quarterly Financial
Report
FY 20/21 FY 20/21
% of % of % of
Total YTD Budget YTD Budget
Budget Budget Actual to Actual Actual YTD Difference % Change to Actual Property Taxes $50,365,000 43% $51,486,500 102% $49,310,947 $2,175,553 4% 108% Sales Taxes / Transaction and Use Tax 19,080,000 16% 22,755,699 119% 19,439,880 $3,315,819 17% 124% Utility User Taxes 8,652,500 7% 9,011,553 104% 9,091,389 ($79,836) -1% 108% Franchise Fees 3,996,000 3% 4,173,484 104% 4,211,074 ($37,590) -1% 99% Transfer Tax 15,000,000 13% 21,929,943 146% 18,536,929 $3,393,014 18% 154% Transient Occupancy Tax 2,200,000 2% 2,555,336 116% 1,996,230 $559,106 28% 143% Business License Taxes 2,200,000 2% 2,382,071 108% 2,253,820 $128,251 6% 100% Departmental Revenues 8,502,850 7% 8,774,931 103% 9,184,641 ($409,710) -4% 105% Interest, Rental Income and Other 3,696,911 3% 2,619,647 71% 3,093,976 ($474,329) -15% 87% Transfers In 4,387,000 4% 6,344,749 145% 9,978,478 ($3,633,729) -36% 146% Total Revenues $118,080,261 100% $132,033,913 112% $127,097,364 $4,936,549 4% 117% FY 21/22 FY 21/22 FY 21/22 to 20/21
Year over Year
146%
87%
105%
100%
143%
154%
99%
108%
124%
108%
145%
71%
103%
108%
116%
146%
104%
104%
119%
102%
0% 20% 40% 60% 80% 100% 120% 140% 160% 180%
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 Fourth Quarter As a % of Budget to Actual for FY 21/22 and FY 20/21
FY21-22
FY20-21
FY 20/21 FY 20/21
% of % o f % of
Total YTD Budge t YTD Budge t
Budget Budget Actual to Actua l Actual YTD Difference % Change to Actua l Fire 42,666,217 34% 38,782,448 91% 37,016,501 1,765,947 5% 94% Police 41,211,457 32% 37,243,423 90% 34,272,474 2,970,949 9% 93% Total Public Safety 83,877,674 66% 76,025,871 91% 71,288,975 4,736,896 7% 93% City Council 272,073 0% 136,426 50% 15,228 121,198 796% 16% City Attorney 992,649 1% 742,064 75% 574,616 167,448 29% 44% City Clerk 624,294 0% 603,464 97% 673,242 (69,778) -10% 87% City Manager 2,043,721 2% 1,072,254 52% 899,128 173,126 19% 88% Finance 3,041,776 2% 2,225,915 73% 2,468,465 (242,550) -10% 88% Human Resources 1,217,684 1% 986,090 81% 805,735 180,355 22% 91% Total General Government 8,192,197 6% 5,766,213 70% 5,436,414 329,799 6% 79% Community Development 1,287,688 1% 700,502 54% 1,311,468 (610,966) -47% 63% Planning, Bldg & Transportation 45,000 0% 33,356 74% - Total Community Development 1,332,688 1% 733,858 55% 1,311,468 (610,966) -47% 63% Recreation and Parks 11,112,118 9% 10,373,834 93% 8,191,142 2,182,692 27% 95% Public Works 3,971,833 3% 3,308,955 83% 2,320,838 988,117 43% 88% Non Departmental 18,561,925 15% 16,189,032 87% 21,544,295 (5,355,263) -25% 75% Total Expenses 127,048,435 $ 100% 112,397,763 $ 88% 110,093,132 $ 2,271,275 $ 2% 88% FY 21/22 FY 21/22 FY 21/22 to 20/21
Year over Year
75%
88%
95%
63%
93%
94%
79%
87%
83%
93%
55%
90%
91%
70%
0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100%
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 21/22 and FY 20/21
FY21/22
FY20/21
FY 20/21 FY 20/21
% of % o f % of
Total YTD Budge t YTD Budge t
Budget Budget Actual to Actua l Actual YTD Difference % Change to Actua l Salaries and Benefits 77,536,523 61% 73,080,475 94% 69,194,947 3,885,528 6% 95% Operating Expenditures 16,019,106 13% 11,288,367 70% 11,439,001 (150,634) -1% 39% Cost Allocation 13,214,639 10% 12,979,549 98% 9,273,133 3,706,416 40% 97% Debt Service 228,151 0% 236,578 104% 231,271 5,307 2% 83% Capital Outlay 80,500 0% 147,521 183% 53,704 93,817 175% 94% Transfers Out 19,969,515 16% 14,665,274 73% 19,901,078 (5,235,804) -26% 156% Total Expenses 127,048,434 100% 112,397,764 88% 110,093,134 2,304,630 2% 88% FY 21/22 FY 21/22 FY 21/22 to 20/21
Year over Year
156%
94%
83%
97%
39%
95%
73%
183%
104%
98%
70%
94%
0% 20% 40% 60% 80% 100% 120% 140% 160% 180% 200%
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 21/22 and FY 20/21
FY21/22
FY20/21
City of Alameda
FY 21/22 Life-to-Date Capital Project Report
Through June 30, 2022 (Unaudited)
As of
6/30/22 % Expended
Project Revised Life-to-Date Outstanding Remaining and
Number Description Budget Actual Expenses Encumbrances Budget Encumbered Capital Projects
C11000 Pavement Management 29,054,139 23,785,229 - 5,268,910 82% C11100 Otis/Pacific Resurfacing 1,570,029 1,565,569 - 4,461 100% C12000 Signs, Pavement Markings 728,524 472,284 - 256,240 65% C12100 Commercial/Slow Streets 735,692 128,345 - 607,347 17% C13000 Traffic Signals & Systems 4,785,423 3,540,938 368,729 875,757 82% C14000 Sidewalks 2,147,835 1,821,838 - 325,997 85% C15000 Park Pathway Repair & Replacement 450,000 400,000 - 50,000 89% C16000 Street, Park, Parking Lot Lighting 5,336,044 1,878,161 109,097 3,348,786 37% C16100 Shoreline Park Pathway Lighting 1,240,734 1,240,734 - 0 0% C17000 Urban Forest - Trees & Landscape Mtce 6,247,081 3,955,226 - 2,291,855 63% C31000 Storm Water Management 2,249,743 1,840,961 5,332 403,450 82% C32000 Storm Water Pump Stations 2,624,255 752,130 - 1,872,125 29% C33000 Green Infrastructure/Trash Capture 50,000 - - 50,000 0% C34000 Lagoon Maintenance 1,305,446 890,938 - 414,508 68% C34100 Bayview Weir 168,000 154,304 - 13,696 92% C34200 Harbor Bay Lagoon Gate 174,863 174,863 - 0 100% C34300 Lagoons 144,554 144,554 - 0 100% C35000 Shoreline Maintenance 654,446 79,849 - 574,596 12% C41000 City Buildings - Public Works 10,582,650 7,532,971 - 3,049,679 71% C42000 City Bldgs - Public Safety 830,850 649,312 - 181,538 78% C42100 Fire Station #1 Improvements 150,000 150,284 - (284) 100% C43000 Library Improvements 253,000 43,150 18,458 191,392 24% C44000 Parking 1,947,900 314,051 - 1,633,849 16% C44100 Parking - Main Street 729,100 559,984 - 169,116 77% City of Alameda
FY 21/22 Life-to-Date Capital Project Report
Through June 30, 2022 (Unaudited)
As of
6/30/22 % Expended
Project Revised Life-to-Date Outstanding Remaining and
Number Description Budget Actual Expenses Encumbrances Budget Encumbered C44200 Parking - Harbor Bay 600,000 112,658 - 487,342 19% C44300 Seaplane Ferry Parking 300,000 - - 300,000 0% C71100 Sea Level Rise 450,000 63,886 - 386,114 14% C71200 Climate Plan 586,375 485,991 - 100,384 83% C71300 Northern Shoreline - Posey/Webster Tubes 310,000 120,510 - 189,490 39% C73000 Fernside Eastshore Pathways 1,514,513 1,514,513 - 0 100% C74000 Public Art in Public Spaces 378,500 16,295 - 362,205 4% C74100 Physical Art 210,000 189,299 15,600 5,101 0% C74200 Estuary Park Service Road 885,000 839,112 - 45,888 95% C75000 Alameda Point Backbone Infrastructure 36,862,277 6,918,910 1,399,298 28,544,069 23% C75100 RESHAP 350,000 20,623 24,378 305,000 13% C75200 Alameda Point Big Whites Painting 1,400,000 82,203 - 1,317,798 6% C76000 Doolittle Landfill - Flare & Piping 500,000 - - 500,000 0% C80100 Citywide WiFi 200,000 165,473 25,219 9,308 95% C80300 ERP Implementation 5,915,298 2,654,910 8,469 3,251,920 45% C80400 Strategic Technology Plan 880,000 511,957 - 368,043 58% C80500 Electronic Doc Mgmt/GIS 1,000,000 - - 1,000,000 0% Total Capital Projects 126,502,270 65,772,009 1,974,579 58,755,682 54% Recreation & Park Projects
C51000 Park Maintenance Improvements 1,566,000 678,012 178,795 709,193 55% C51100 Park Irrigation Improvements 400,000 406,026 - (6,026) 102% C52000 Playground Replacements 1,897,000 1,263,852 436,952 196,196 90% C52400 Woodstock Park Rec Center 190,000 148,253 - 41,747 78% C52500 Estuary Park Field Design 5,576,000 5,542,717 - 33,283 99% City of Alameda
FY 21/22 Life-to-Date Capital Project Report
Through June 30, 2022 (Unaudited)
As of
6/30/22 % Expended
Project Revised Life-to-Date Outstanding Remaining and
Number Description Budget Actual Expenses Encumbrances Budget Encumbered C52600 Park ADA Upgrades 100,000 154,329 - (54,329) 154% C52700 Officers Club Improvements 44,500 21,685 - 22,815 49% C52800 Godfrey Restroom Replacement 748,099 607,014 - 141,085 81% C52900 Alameda Point Gym-Modular Restroom 1,070,769 980,207 - 90,563 92% C54000 Mastick Center Imprevements 565,000 174,750 - 390,250 31% C54100 Mastick Front Entry Improvements 100,000 24,324 - 75,676 24% C55100 Krusi Park 2,259,000 2,319,111 - (60,111) 103% C55200 De-Pave Park 25,000 25,000 - 0 100% C55300 East End Dog Park 75,000 - - 75,000 0% C55400 New City Aquatic Center 150,000 150,000 - 0 100% C55500 Littlejohn Park Rec Center Rebuild 250,000 231,142 - 18,858 92% C55600 Marina Village Park Renovation 1,054,000 267,588 - 786,412 25% C55700 Park Light/Court Resurface 275,000 84,052 - 190,948 31% C55800 Emma Hood Pool Repairs 250,000 250,000 - 0 100% C55900 Leydecker Park Rec Center 213,528 122,720 - 90,808 57% C56100 Encinal Boat Ramp Design 2,136,734 1,960,594 88,379 87,761 96% C56200 Jean Sweeney Park (ARPD) 7,617,438 7,691,858 73,004 (147,424) 102% 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 15,016,368 12,726,421 615,747 1,674,201 89% Transportation Projects
C61000 Street Safety 950,000 590,540 - 359,460 62% C62000 Safe Routes to School Infrastructure 268,000 30,580 - 237,420 11% C63000 Active Transportation Plan Implementation 100,000 - - 100,000 0% C63100 Bike/Ped 946,000 674,816 - 271,184 71% City of Alameda
FY 21/22 Life-to-Date Capital Project Report
Through June 30, 2022 (Unaudited)
As of
6/30/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,122,485 - 59,410 99% C65010 Cross Alameda Trail Connectors 427,000 - - 427,000 0% C65100 Otis Dr Traffic Calming & Safety 1,275,000 1,198,108 - 76,892 94% C65200 Clement Ave CAT - Grant to Broadway 6,843,000 1,159,037 - 5,683,963 17% C65300 Clement & Tilden Way Complete Streets 5,217,000 1,740,181 - 3,476,819 33% C65400 Appezzato Pkwy Dedicated Bus Lane 2,700,000 - - 2,700,000 0% C65500 Bay Farm Island Intersection Control 300,000 111,486 - 188,514 37% C65600 Central Ave Safety Improvements 3,055,300 2,437,960 - 617,340 80% C65700 Lincoln Marshall Safety Improvements 200,000 88,336 (5,910) 117,574 41% C65800 Cross Alameda Trail - Jean Sweeney 4,109,381 4,114,381 - (5,000) 100% C65900 West End Bicycle Pedestrian Crossing 1,355,000 - - 1,355,000 0% 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,299,597 22,563,696 - 3,735,900 86% Sewer Projects
C21000 Sewer Rehabilitation 37,866,542 31,814,931 - 6,051,611 84% C22000 Sewer Pump Stations 17,033,534 10,915,268 68,895 6,049,371 64% C23000 Cyclic Sewer Replacement 7,586,201 7,586,201 - 0 100% Total Sewer Projects 62,486,277 50,316,401 68,895 12,100,981 81% City of Alameda, California
FY 21/22 Year To Date (YTD) Revenues and Expenditures - All Funds Through June 30, 2022
2021-22
Actual Revenues
(Unaudited)
2021-22
Actual Expenditures
(Unaudited)
2021-22
Net Income
(Unaudited)
General Fund
100 General Fund 132,033,914 112,397,763 19,636,151 101 Police/Fire Pension 1079 1,877,132 752,461 1,124,671 102 Police/Fire Pension 1082 49,975 33,162 16,813 104 AMP Reimbursable 12,538,857 12,564,943 (26,086) General Fund Subtotal 146,499,878 125,748,329 20,751,549 Special Revenue Funds -
201 HOME 18,067 18,068 (1) 202 HOME Loan Repayment 54,553 54,553 - 203 CDBG 1,384,751 1,384,751 - 204 CDBG Loan Repayment 297,366 243,894 53,472 205 Special CDBG Grants 396,927 396,927 - 206 Housing In-Lieu 29,341 137,805 (108,464) 207 Rent Review/Stabilization 2,260,682 1,893,055 367,627 208 Affordable Housing (5,151) 482,906 (488,057) 209 Planning/Bldg/Transportation 7,877,290 7,617,826 259,464 210 Alameda Free Library 5,489,194 4,857,261 631,933 211 Gas Tax 1,888,544 2,065,041 (176,497) 212 Road Mtce and Rehab (RMRA) 1,604,113 244,421 1,359,692 213 Vehicle Registration Fees 313,104 110,555 202,549 216 Tidelands 821,502 731,117 90,385 217 Open Space Improvement & Mtce 24,644 50,000 (25,356) 219 Police Asset Seizure (225) - (225) 220 Fire Grants 170,628 2,002,864 (1,832,236) 221 Police Grants 647,218 176,188 471,030 222 Grants 137,860 130,186 7,674 230 County Measure B Streets/Roads 1,956,578 2,230,898 (274,320) 231 County Measure BB Streets/Road 3,089,282 1,549,430 1,539,852 232 County Measure B Bike/Ped 242,992 404,664 (161,672) 233 County Measure BB Bike/Ped 334,663 226,734 107,929 234 County Measure B Paratransit 181,012 200,126 (19,114) 235 County Measure BB Paratransit 306,824 117,411 189,413 240 Commercial Revitalization 1,063,588 626,962 436,626 241 Fleet Industrial Supply Center (15,572) 867,359 (882,931) 250 Golf 313,654 249,839 63,815 251 Mastick Advisory Board 111,839 88,466 23,373 252 Mastick Senior Center Trust 45,631 92,327 (46,696) 253 Adams Street House (1,900) - (1,900) 260 Solid Waste Surcharge 220,919 215,073 5,846 261 City Waste Management Program 590,440 476,065 114,375 262 Integrated Waste - Meas D 161,750 410,502 (248,752) 2021-22
Actual Revenues
(Unaudited)
2021-22
Actual Expenditures
(Unaudited)
2021-22
Net Income
(Unaudited)
263 Curbside Recycling (966) - (966) 264 Stormwater 4,576,780 4,215,366 361,414 265 Parking Fees 930,819 1,256,154 (325,335) 266 Civic Center Garage - 78,693 (78,693) 268 Oak Tree in-Lieu Fee 7,410 - 7,410 270 Island City Maint-84-2 Zone 1 4,599 6,628 (2,029) 271 Island City Maint-84-2 Zone 4 183,719 167,526 16,193 272 Island City Maint-84-2 Zone 5 942,106 773,291 168,815 273 Island City Maint-84-2 Zone 6 453,828 713,585 (259,757) 274 Island City Maint-84-2 Zone 7 (581) 6,599 (7,180) 275 Island City Maint-84-2 Zone 8 77,192 90,311 (13,119) 276 Assessment District Admin 263,090 140,848 122,242 277 Marina Cove Maintenance AD 115,956 139,689 (23,733) 278 Marina Cove Reserve 01-01 (1,193) - (1,193) 279 Alameda Landing Muni SD 776,633 365,270 411,363 280 Bayport Muni Services Dist 03 797,752 386,347 411,405 281 Alameda Point Svc CFD 17-1 593,070 525,964 67,106 282 Marina Village AD 89-1 Refund (9,450) 915 (10,365) 283 Harbor Bay 92-1 AD Matured (1,897) 22,466 (24,363) 284 CFD 13-1 Alameda Landing (CPF) 170,000 33,829 136,171 285 CFD 14-1 Marina Cove II (CPF) 209,666 32,275 177,391 286 BFI Dike Assmt District 93-1 (1,776) - (1,776) 287 Harbor Transportation 817,765 (326,746) 1,144,511 290 Alameda Point 17,175,569 15,147,802 2,027,767 Special Revenue Funds Subtotal 60,092,199 54,130,086 5,962,113 Capital Projects Funds -
301 Alameda Point Capital Projects 4,137,507 5,051,726 (914,219) 302 Construction Impact Fees 2,178,937 744,382 1,434,555 303 Dwelling Unit 283,236 28,701 254,535 305 Dev Impact Fees - Transp 9,487 425,360 (415,873) 306 Dev Impact Fees - Rec/Park 1,120 - 1,120 307 Dev Impact Fees - Public Facility (3,097) - (3,097) 308 Dev Impact Fees - Public Safety (5,507) - (5,507) 310 Capital Improvement Projects 10,739,186 15,340,629 (4,601,443) 320 Transportation Management (28,486) - (28,486) Capital Projects Funds Subtotal 17,312,383 21,590,798 (4,278,415) Debt Service Funds -
401 City Debt Service 1,851,695 1,998,906 (147,211) 410 2013 GO Library Bond 2003 600,682 626,244 (25,562) 420 2003 Alameda Point Rev Bonds 793,009 738,825 54,184 Debt Service Funds Subtotal 3,245,386 3,363,975 (118,589) 2021-22
Actual Revenues
(Unaudited)
2021-22
Actual Expenditures
(Unaudited)
2021-22
Net Income
(Unaudited)
Enterprise Fund -
501 Sewer Services 22,902,821 25,744,813 (2,841,992) Enterprise Fund Subtotal 22,902,821 25,744,813 (2,841,992) Internal Service Funds -
601 Fleet Maintenance & Replacement 4,764,159 3,849,768 914,391 603 Facility Mtce & Replacement 4,855,361 4,733,372 121,989 605 Emergency Operations Center 130,788 128,738 2,050 606 Information Technology 2,954,362 3,998,480 (1,044,118) 609 IT Cable Equip Replace (PEG) 151,620 32,243 119,377 610 Worker's Compensation 4,121,427 2,546,065 1,575,362 611 General Liability 5,173,068 3,808,866 1,364,202 612 Unemployment Insurance 219 32,524 (32,305) 613 Post Employment - OPEB 3,982,043 4,131,411 (149,368) Internal Service Funds Subtotal 26,133,047 23,261,467 2,871,580 Fiduciary Funds -
701 Successor Agency 8,428,464 8,706,380 (277,916) 710 Misc&Safety Pre-1/1/2019 OPEB - - - 720 Pension Reserve (1,351,675) 5,798,878 (7,150,553) Fiduciary Funds Subtotal 7,076,789 14,505,258 (7,428,469) Agency Funds -
801 1998 Rev Bond Debt/Harbor Bay (211) - (211) 802 2010-B Marina Village Bd Refi (4,125) - (4,125) 803 Harbor Bay Assmt Dist CFD 1 (839) - (839) 804 Marina Villg Assmt Dist CFD 2 (616) - (616) 805 Alameda Landing CFD #13-1 1,977,258 1,000,671 976,587 Agency Funds Subtotal 1,971,467 1,000,671 970,796 Totals 285,233,970 269,345,397 15,888,573