Richmond City Council
May 28, 2024

Attachment 1 - FY2023-24 Q3 Budget Review
FUNDS
FY2023-24

ORIGINAL
BUDGET
FY2023-24

REVISED BUDGET

ACTUALS
THRU
MARCH 2024
ENCUMB
W/
ENCUMB
% USED
W/O
ENCUMB
% USED

AVAILABLE
BUDGET
FY2023-24

YEAR-END

PROJECTION
NOTES

GENERAL FUND REVENUE & EXPENDITURE SUMMARY BY CHARACTER GENERAL FUND - 0001
PROPERTY TAXES (50,567,173) (52,181,354) (28,367,873) - 54% 54% (23,813,481) (54,065,269) [1] SALES & USE TAX (56,752,495) (57,897,341) (35,235,093) - 61% 61% (22,662,248) (61,241,216) [2] UTILITY USERS TAX (55,775,083) (57,938,011) (43,516,676) - 75% 75% (14,421,336) (57,921,746) OTHER TAXES (23,237,723) (24,144,377) (7,498,664) - 31% 31% (16,645,713) (19,670,324) [3] LICENSES,PRMITS&FEES (13,286,195) (15,779,175) (11,092,118) - 70% 70% (4,687,058) (16,223,582) [4] FINES & FORFEITURES (331,144) (151,438) (132,107) - 87% 87% (19,331) (189,996) USE OF MONEY&PROPRTY (1,011,535) (1,796,421) (1,871,727) - 104% 104% 75,306 (3,000,000) CHARGES FOR SERVICES (2,561,992) (2,536,992) (1,622,050) - 64% 64% (914,942) (2,242,226) [5] OTHER REVENUE (238,480) (238,480) (190,672) - 80% 80% (47,808) (277,531) RENTAL INCOME (777,028) (777,028) (743,653) - 96% 96% (33,375) (1,009,971) INTERGOV STATE TAXES (125,000) (125,000) (143,154) - 115% 115% 18,154 (143,154) INTERGOV STATE GRANT (110,000) (183,911) (146,980) - 80% 80% (36,931) (197,270) INTERGOV OTHER GRANT (250,000) (280,000) (328,851) - 117% 117% 48,851 (358,854) PROC FR SLE PROP - - (4,987) - - 100% 4,987 (8,654) [6] LOAN/BOND PROCEEDS (40,400) (40,400) - - 0% 0% (40,400) - [7] OPER XFERS IN (20,310,358) (20,310,358) (20,288,662) - 100% 100% (21,696) (20,288,662) [8] TOTAL GENERAL FUND REVENUE (225,374,607) (234,380,287) (151,183,268) - 65% 65% (83,197,019) (236,838,455) SALARIES AND WAGES 83,345,132 85,847,575 59,720,372 - 70% 70% 26,127,203 82,762,173 PYRLL/FRINGE BENEFIT 62,867,833 65,538,296 45,714,058 - 70% 70% 19,824,238 63,827,262 PROF & ADMIN 20,302,711 21,688,714 8,367,438 3,522,409 55% 39% 9,798,867 14,552,294 OTHER OPERATING 8,611,971 8,963,844 4,215,595 1,197,514 60% 47% 3,550,735 5,161,150 UTILITIES 5,288,272 5,690,630 3,964,534 311,625 75% 70% 1,414,470 6,056,600 EQPT & CONTRACT SVCS 5,918,655 5,946,835 2,124,002 327,684 41% 36% 3,495,148 2,896,738 PROVISN FOR INS LOSS 34,200 34,200 29,572 - 86% 86% 4,628 29,419 [9] COST POOL 21,593,734 21,593,734 16,209,785 - 75% 75% 5,383,949 21,593,734 ASSET/CAPITAL OUTLAY 1,893,500 2,817,457 1,397,213 712,127 75% 50% 708,117 3,801,894 DEBT SVC EXPENDITURE 841,353 841,353 418,000 - 50% 50% 423,353 1,476,147 A87 COST PLAN REIMBS (3,531,611) (3,514,373) (2,728,797) - 78% 78% (785,576) (3,514,373) [10] GRANT EXPENDITURES 19,155 98,723 (1,625) 6,277 5% -2% 94,071 (10,009) OPER XFERS OUT 18,189,702 30,748,126 22,463,494 - 73% 73% 8,284,632 34,806,564 [11] TOTAL GENERAL FUND EXPENDITURE 225,374,607 246,295,113 161,893,64 0 6,077,636 68% 66% 78,323,837 233,439,593 GENERAL FUND - NET (SURPLUS)DEFICIT - 11,914,826 (3,398,862) BEGINNING BALANCE: 7/1/23 55,196,962 55,196,962 55,196,962 21% Reserve Policy 47,328,667 53,026,901 53,026,901 ESTIMATED ENDING BALANCE: 6/30/24 7,868,295 (9,744,765) 5,568,923 NOTES
[6] Received monies from auction payout from J.J. Kane Auctioneers and sale of scrap metals [1] Property tax assessments are received in December, April and June. [2] Sales & Use Tax is received two months in arrears
[3] Transfer tax is trending lower. This is a volatile revenue stream and varies significantly from month to month. A few large sales have a significant impact. [4] Measure U revenue will be received between January and June of 2024. [5] Revenues are received intermittent after services are completed. [7] Loan proceeds are received based on loan repayment schedules [8] Transfer In for Secured Pension Override Fund FY2023-24 [9] Annual insurance premiums for drones, fire boat and fire apparatus [10] Administrative overhead reimbursement from non-general fund departments as part of A87 Cost Plan. [11] Transfers Out per the City Council approved schedule to various programs.

Attachment 1 - FY2023-24 Q3 Budget Review
FUNDS
FY2023-24

ORIGINAL
BUDGET
FY2023-24

REVISED BUDGET

ACTUALS
THRU
MARCH 2024
ENCUMB
W/
ENCUMB
% USED
W/O
ENCUMB
% USED

AVAILABLE

BUDGET NOTES

GENERAL FUND REVENUE AND EXPENDITURES BY DEPARTMENT
10 OFFICE OF THE MAYOR
SALARIES AND WAGES 372,679 362,679 223,956 - 62% 62% 138,724 PYRLL/FRINGE BENEFIT 258,424 258,424 137,893 - 53% 53% 120,531 PROF & ADMIN 20,500 30,500 9,705 - 32% 32% 20,795 OTHER OPERATING 3,400 3,400 245 - 7% 7% 3,155 UTILITIES 3,000 3,000 3,486 - 116% 116% (486) [12] COST POOL 35,927 35,927 26,945 - 75% 75% 8,982 EXPENDITURE 693,930 693,930 402,230 - 58% 58% 291,700 11 CITY COUNCIL
SALARIES AND WAGES 329,452 329,452 250,058 - 76% 76% 79,394 [13] PYRLL/FRINGE BENEFIT 322,675 322,675 196,112 - 61% 61% 126,563 PROF & ADMIN 55,450 57,798 18,064 70 31% 31% 39,664 OTHER OPERATING 18,800 16,452 9,386 1,513 66% 57% 5,554 UTILITIES 1,100 1,100 - - 0% 0% 1,100 EQPT & CONTRACT SVCS - 55,000 - - 0% 0% 55,000 COST POOL 51,068 51,068 38,300 - 75% 75% 12,768 ASSET/CAPITAL OUTLAY 3,000 3,000 - - 0% 0% 3,000 EXPENDITURE 781,545 836,545 511,919 1,583 61% 61% 323,043 12 COMMUNITY POL REV COMMISSION
SALARIES AND WAGES 50,000 50,000 34,414 - 69% 69% 15,586 PYRLL/FRINGE BENEFIT 688 688 3,058 - 444% 444% (2,370) [14] PROF & ADMIN 24,450 24,450 8,862 65 37% 36% 15,523 OTHER OPERATING 1,050 1,050 384 - 37% 37% 666 EXPENDITURE 76,188 76,188 46,718 65 61% 61% 29,405 13 CITY MANAGER
INTERGOV STATE GRANT - - 33,442 - - - (33,442) REVENUE - - 33,442 - - - (33,442) SALARIES AND WAGES 672,538 622,538 490,292 - 79% 79% 132,246 [15] PYRLL/FRINGE BENEFIT 319,662 319,662 237,757 - 74% 74% 81,906 PROF & ADMIN 204,347 248,597 30,266 75,711 43% 12% 142,620 OTHER OPERATING 9,400 14,700 9,418 1,332 73% 64% 3,950 UTILITIES - 100 430 - 430% 430% (330) [16] EQPT & CONTRACT SVCS 200 200 49 26 38% 24% 125 COST POOL 69,244 69,244 51,934 - 75% 75% 17,310 ASSET/CAPITAL OUTLAY - 350 497 - 142% 142% (147) [17] A87 COST PLAN REIMBS (180,453) (179,572) (134,680) - 75% 75% (44,892) EXPENDITURE 1,094,938 1,095,819 685,962 77,069 70% 63% 332,788 NOTES
[15] Journals for contras for staff time on grants have not been completed [16] Paid Verizon wireless charges. A budget transfer will be done to cover overage [17] Purchased a printer; no other expenses are anticipated [12] Verizon Wireless cell phone charges trending higher than anticipated [14] Worker's Comp Clerical and Medicare Tax are not budgeted [13] Part-time salaries was not budgeted

Attachment 1 - FY2023-24 Q3 Budget Review
FUNDS
FY2023-24

ORIGINAL
BUDGET
FY2023-24

REVISED BUDGET

ACTUALS
THRU
MARCH 2024
ENCUMB
W/
ENCUMB
% USED
W/O
ENCUMB
% USED

AVAILABLE

BUDGET NOTES
14 CITY CLERK
LICENSES,PRMITS&FEES (600) (600) (200) - 33% 33% (400) [18] CHARGES FOR SERVICES (3,000) (3,000) (4,900) - 163% 163% 1,900 OTHER REVENUE - - (275) - - - 275 REVENUE (3,600) (3,600) (5,375) - 149% 149% 1,775 SALARIES AND WAGES 489,328 489,328 393,606 - 80% 80% 95,722 [19] PYRLL/FRINGE BENEFIT 294,431 294,431 230,896 - 78% 78% 63,535 [20] PROF & ADMIN 145,100 155,100 52,834 11,493 41% 34% 90,773 OTHER OPERATING 20,300 20,300 6,933 1,199 40% 34% 12,167 UTILITIES 1,000 1,000 281 - 28% 28% 719 COST POOL 61,454 61,454 46,091 - 75% 75% 15,363 A87 COST PLAN REIMBS (70,463) (70,119) (52,590) - 75% 75% (17,529) EXPENDITURE 941,150 951,494 678,052 12,692 73% 71% 260,750 15 CITY ATTORNEY
LICENSES,PRMITS&FEES - - (852) - - - 852 [21] REVENUE - - (852) - - - 852 SALARIES AND WAGES 1,381,647 1,376,647 671,343 - 49% 49% 705,304 PYRLL/FRINGE BENEFIT 744,333 744,333 349,868 - 47% 47% 394,465 PROF & ADMIN 1,974,850 1,998,050 895,262 532,267 71% 45% 570,521 OTHER OPERATING 27,750 27,950 8,491 15,143 85% 30% 4,316 [22] UTILITIES - 1,600 910 - 57% 57% 690 EQPT & CONTRACT SVCS 1,250 1,250 76 27 8% 6% 1,146 COST POOL 112,565 112,565 84,425 - 75% 75% 28,140 A87 COST PLAN REIMBS (319,088) (317,531) (238,148) - 75% 75% (79,383) EXPENDITURE 3,923,307 3,944,864 1,772,228 547,437 59% 45% 1,625,199 16 PLANNING & BUILDING SERVICES
LICENSES,PRMITS&FEES (955,500) (955,500) (559,144) - 59% 59% (396,356) [23] OTHER REVENUE (30,000) (30,000) (54,054) - 180% 180% 24,054 REVENUE (985,500) (985,500) (613,199) - 62% 62% (372,301) SALARIES AND WAGES 866,463 886,463 546,074 - 62% 62% 340,389 PYRLL/FRINGE BENEFIT 652,308 652,308 409,373 - 63% 63% 242,935 PROF & ADMIN 875,400 875,400 91,387 143,639 27% 10% 640,374 OTHER OPERATING 28,947 28,947 10,896 1,892 44% 38% 16,159 UTILITIES 11,500 11,500 2,095 9,405 100% 18% - [24] EQPT & CONTRACT SVCS 13,549 13,549 - - 0% 0% 13,549 COST POOL 289,411 289,411 175,810 - 61% 61% 113,601 EXPENDITURE 2,737,578 2,757,578 1,235,635 154,937 50% 45% 1,367,005 NOTES
[18] Photocopy fees are not received every month
[19] Staff salaries slightly higher than anticipated
[20] Worker compensation Clerical higher and payroll fringe benefits higher than anticipated [21] Revenue collected for photocopy fees
[22] PO encumbered with Ricoh USA Inc. for copier rental services [23] Abatement fees are trending lower than expected
[24] PO encumbered with Verizon Wireless for cellular services.

Attachment 1 - FY2023-24 Q3 Budget Review
FUNDS
FY2023-24

ORIGINAL
BUDGET
FY2023-24

REVISED BUDGET

ACTUALS
THRU
MARCH 2024
ENCUMB
W/
ENCUMB
% USED
W/O
ENCUMB
% USED

AVAILABLE

BUDGET NOTES
17 FINANCE
SALARIES AND WAGES 3,491,350 3,415,650 2,324,722 - 68% 68% 1,090,928 PYRLL/FRINGE BENEFIT 2,228,150 2,228,150 1,408,775 - 63% 63% 819,375 PROF & ADMIN 1,014,389 1,089,309 662,148 138,103 73% 61% 289,058 OTHER OPERATING 65,806 65,806 44,937 15,088 91% 68% 5,781 [25] UTILITIES 1,400 1,400 2,015 - 144% 144% (615) [26] EQPT & CONTRACT SVCS 435 1,215 459 621 89% 38% 135 [27] COST POOL 283,577 283,577 212,681 - 75% 75% 70,896 A87 COST PLAN REIMBS (1,152,435) (1,146,811) (860,116) - 75% 75% (286,695) EXPENDITURE 5,932,672 5,938,296 3,795,621 153,812 67% 64% 1,988,863 18 HUMAN RESOURCES
SALARIES AND WAGES 1,323,935 1,323,935 756,407 - 57% 57% 567,528 PYRLL/FRINGE BENEFIT 828,677 828,677 423,660 - 51% 51% 405,017 PROF & ADMIN 1,119,700 1,119,700 580,488 217,020 71% 52% 322,192 [28] OTHER OPERATING 35,705 35,705 23,178 2,032 71% 65% 10,495 UTILITIES 1,500 1,500 494 - 33% 33% 1,006 EQPT & CONTRACT SVCS 150 150 49 1 33% 32% 100 COST POOL 218,189 218,189 163,643 - 75% 75% 54,546 A87 COST PLAN REIMBS (184,290) (183,390) (137,544) - 75% 75% (45,846) EXPENDITURE 3,343,566 3,344,466 1,810,375 219,053 61% 54% 1,315,038 19 POLICE
LICENSES,PRMITS&FEES (90,000) (132,980) (107,994) - 81% 81% (24,986) FINES & FORFEITURES (50,000) (25,000) (37,710) - 151% 151% 12,710 CHARGES FOR SERVICES (1,068,000) (1,008,000) (652,739) - 65% 65% (355,261) [29] OTHER REVENUE (12,000) (12,000) (9,270) - 77% 77% (2,730) INTERGOV STATE GRANT (10,000) (83,911) (90,592) - 108% 108% 6,681 [30] INTERGOV OTHER GRANT (250,000) (280,000) (328,851) - 117% 117% 48,851 [31] REVENUE (1,480,000) (1,541,891) (1,227,157) - 80% 80% (314,734) SALARIES AND WAGES 34,418,730 36,398,581 23,489,009 - 65% 65% 12,909,572 PYRLL/FRINGE BENEFIT 27,058,010 27,058,010 16,643,971 - 62% 62% 10,414,039 PROF & ADMIN 5,348,305 5,569,773 3,107,174 1,011,659 74% 56% 1,450,939 OTHER OPERATING 2,972,200 2,980,659 2,085,959 623,953 91% 70% 270,747 [32] UTILITIES 400,000 400,000 212,474 75,308 72% 53% 112,219 EQPT & CONTRACT SVCS 614,600 467,600 125,926 56,838 39% 27% 284,836 PROVISN FOR INS LOSS 5,700 5,700 5,200 - 91% 91% 500 [33] COST POOL 5,463,534 5,463,534 4,007,652 - 73% 73% 1,455,882 ASSET/CAPITAL OUTLAY 735,000 652,073 171,122 133,613 47% 26% 347,338 EXPENDITURE 77,016,079 78,995,930 49,848,487 1,901,371 66% 63% 27,246,072 NOTES
[28] PO's encumbered with Raftelis Financial Consultants for workforce analysis, and Liebert Cassidy Whitmore for labor negotiations and employment advise [31] Contra Costa County grant to supplement law enforcement services. First installment received in October 2023 [29] Revenues for false alarms and police special services have not been received and can not be estimated when it will be received [25] PO encumbered with Ricoh USA Inc. for copier lease [26] Verizon Wireless charges higher than anticipated
[27] Encumbered funds for shredding services
[30] State of California grant for Police Officers Standards Training (POST). Historically this grant has been $10K but due to an increase in new hires participation in training has been higher.
[32] PO's encumbered with Dicon Fiberoptics Inc. for building lease, and Enterprise Rent a Car for investigative team vehicle rental [33] Annual insurance premium for drones

Attachment 1 - FY2023-24 Q3 Budget Review
FUNDS
FY2023-24

ORIGINAL
BUDGET
FY2023-24

REVISED BUDGET

ACTUALS
THRU
MARCH 2024
ENCUMB
W/
ENCUMB
% USED
W/O
ENCUMB
% USED

AVAILABLE

BUDGET NOTES
20 FIRE
LICENSES,PRMITS&FEES (855,000) (855,000) (246,305) - 29% 29% (608,695) [34] CHARGES FOR SERVICES (720,503) (720,503) (183,925) - 26% 26% (536,578) [35] REVENUE (1,575,503) (1,575,503) (430,230) - 27% 27% (1,145,273) SALARIES AND WAGES 19,063,727 19,716,627 13,667,852 - 69% 69% 6,048,775 PYRLL/FRINGE BENEFIT 15,085,269 15,085,269 10,076,251 - 67% 67% 5,009,018 PROF & ADMIN 1,699,815 1,883,771 151,616 116,504 14% 8% 1,615,652 OTHER OPERATING 817,694 1,100,694 147,032 10,679 14% 13% 942,984 UTILITIES 33,500 33,500 12,102 - 36% 36% 21,398 EQPT & CONTRACT SVCS 215,850 407,913 5,619 (105) 1% 1% 402,398 PROVISN FOR INS LOSS 27,000 27,000 24,372 - 90% 90% 2,628 [36] COST POOL 2,507,975 2,507,975 1,775,986 - 71% 71% 731,989 ASSET/CAPITAL OUTLAY 25,500 25,500 14,993 - 59% 59% 10,507 DEBT SVC EXPENDITURE 114,442 114,442 57,243 - 50% 50% 57,199 OPER XFERS OUT 326,018 326,018 244,514 - 75% 75% 81,504 EXPENDITURE 39,916,790 41,228,708 26,177,578 127,078 64% 63% 14,924,052 21 OFFICE OF NEIGHBORHOOD SAFETY
SALARIES AND WAGES 1,510,773 1,510,773 988,336 - 65% 65% 522,437 PYRLL/FRINGE BENEFIT 1,038,192 1,038,192 739,917 - 71% 71% 298,275 PROF & ADMIN 783,710 783,710 50,218 20,000 9% 6% 713,492 OTHER OPERATING 97,640 97,640 21,728 2,039 24% 22% 73,873 UTILITIES 20,000 20,000 12,361 - 62% 62% 7,639 COST POOL 242,344 242,344 181,759 - 75% 75% 60,585 ASSET/CAPITAL OUTLAY 28,000 28,000 2,874 - 10% 10% 25,126 GRANT EXPENDITURES - - 12 - - - (12) EXPENDITURE 3,720,659 3,720,659 1,997,206 22,039 54% 54% 1,701,414 NOTES
[34] Fire inspection fees differ monthly
[35] All service charges for Chevron Refinery have not been recorded [36] Annual insurance premium for fire boat and fire apparatus FY2023-24

Attachment 1 - FY2023-24 Q3 Budget Review
FUNDS
FY2023-24

ORIGINAL
BUDGET
FY2023-24

REVISED BUDGET

ACTUALS
THRU
MARCH 2024
ENCUMB
W/
ENCUMB
% USED
W/O
ENCUMB
% USED

AVAILABLE

BUDGET NOTES
23 PUBLIC WORK & ENGINEERING SVCS
LICENSES,PRMITS&FEES (106,100) (106,100) (14,501) - 14% 14% (91,599) [37] CHARGES FOR SERVICES (638,289) (673,289) (778,779) - 116% 116% 105,490 OTHER REVENUE (120,000) (120,000) (10,864) - 9% 9% (109,136) [38] RENTAL INCOME (18,000) (18,000) (12,913) - 72% 72% (5,087) [39] PROC FR SLE PROP - - (4,987) - - - 4,987 REVENUE (882,389) (917,389) (822,044) - 90% 90% (95,345) SALARIES AND WAGES 9,589,943 9,716,961 7,641,748 - 79% 79% 2,075,214 [40] PYRLL/FRINGE BENEFIT 8,053,057 8,053,057 5,843,351 - 73% 73% 2,209,706 PROF & ADMIN 1,268,113 1,170,822 331,268 193,798 45% 28% 645,756 OTHER OPERATING 2,453,620 2,376,264 1,646,333 411,090 87% 69% 318,841 [41] UTILITIES 4,058,504 4,456,504 3,361,386 166,734 79% 75% 928,384 [42] EQPT & CONTRACT SVCS 957,400 1,604,047 467,745 214,978 43% 29% 921,325 COST POOL 7,596,307 7,596,307 4,838,499 - 64% 64% 2,757,808 ASSET/CAPITAL OUTLAY 35,000 335,000 134,445 143,505 83% 40% 57,050 [43] DEBT SVC EXPENDITURE 726,911 726,911 360,757 - 50% 50% 366,154 A87 COST PLAN REIMBS (647,398) (644,238) (576,205) - 89% 89% (68,033) [44] EXPENDITURE 34,091,457 35,391,635 24,049,325 1,130,104 71% 68% 10,212,205 24 LIBRARY & CULTURAL SERVICES
RENTAL INCOME (20,000) (20,000) (23,180) - 116% 116% 3,180 REVENUE (20,000) (20,000) (23,180) - 116% 116% 3,180 SALARIES AND WAGES 2,821,326 2,821,326 2,029,682 - 72% 72% 791,644 PYRLL/FRINGE BENEFIT 2,096,396 2,096,396 1,397,879 - 67% 67% 698,517 PROF & ADMIN 686,353 662,036 414,064 84,490 75% 63% 163,482 OTHER OPERATING 57,220 50,261 26,291 16,430 85% 52% 7,540 [45] UTILITIES 9,700 28,284 4,372 20,680 89% 15% 3,231 [46] EQPT & CONTRACT SVCS 1,600 1,300 180 20 15% 14% 1,100 COST POOL 285,035 285,035 213,776 - 75% 75% 71,259 ASSET/CAPITAL OUTLAY 20,100 33,092 6,660 - 20% 20% 26,432 EXPENDITURE 5,977,730 5,977,730 4,092,904 121,620 71% 68% 1,763,206 NOTES
[37] Abatement and Admin fees received differ monthly.
[38] Miscellaneous revenues differs month to month
[39] Rental income received differs monthly.
[40] Stand-by pay was not budgeted for Electrical and Station Engineers divisions [41] PO encumbered with Bosco Oil Company for bulk fuel delivery for City of Richmond (COR) 3 fuel sites. [42] PO's encumbered with ABAG Energy Resources for heating and natural gas for City of Richmond (COR) buildings, and with Verizon Wireless for communications and media related services
[43] Encumbered maintenance materials for Hilltop Soundwall repairs from Nema Construction [44] Admin charges for general liability services slightly higher than anticipated [45] PO encumbered with Ricoh USA Inc. for copier lease [46] Verizon Wireless Internet services charges encumbered

Attachment 1 - FY2023-24 Q3 Budget Review
FUNDS
FY2023-24

ORIGINAL
BUDGET
FY2023-24

REVISED BUDGET

ACTUALS
THRU
MARCH 2024
ENCUMB
W/
ENCUMB
% USED
W/O
ENCUMB
% USED

AVAILABLE

BUDGET NOTES
25 COMMUNITY SERVICES
LICENSES,PRMITS&FEES (548,720) (548,720) (421,223) - 77% 77% (127,497) OTHER REVENUE (16,000) (16,000) (68,370) - 427% 427% 52,370 [47] RENTAL INCOME (563,950) (563,950) (572,344) - 101% 101% 8,394 REVENUE (1,128,670) (1,128,670) (1,061,936) - 94% 94% (66,734) SALARIES AND WAGES 4,100,628 3,984,002 2,621,029 - 66% 66% 1,362,973 PYRLL/FRINGE BENEFIT 1,615,873 1,615,014 1,737,539 - 108% 108% (122,525) [48] PROF & ADMIN 595,426 701,746 212,388 109,535 46% 30% 379,823 OTHER OPERATING 74,233 359,777 23,905 6,881 9% 7% 328,992 UTILITIES 44,625 46,699 20,653 14,055 74% 44% 11,991 EQPT & CONTRACT SVCS 6,000 6,000 131 19 3% 2% 5,850 COST POOL 366,110 366,110 274,585 - 75% 75% 91,525 ASSET/CAPITAL OUTLAY 12,927 16,491 15,355 - 93% 93% 1,136 [49] GRANT EXPENDITURES 19,155 98,723 (1,637) 6,277 5% -2% 94,083 OPER XFERS OUT - 77,500 - - 0% 0% 77,500 EXPENDITURE 6,834,977 7,272,063 4,903,948 136,766 69% 67% 2,231,349 26 INFORMATION TECHNOLOGY
OTHER REVENUE - - (188) - - - 188 REVENUE - - (188) - - - 188 SALARIES AND WAGES 1,042,181 1,042,181 713,380 - 68% 68% 328,801 PYRLL/FRINGE BENEFIT 661,502 661,502 426,007 - 64% 64% 235,495 PROF & ADMIN 860,432 1,365,432 608,889 92,430 51% 45% 664,113 OTHER OPERATING 79,945 121,945 54,163 56,429 91% 44% 11,353 [50] UTILITIES 435,100 417,100 331,369 22,943 85% 79% 62,788 [51] EQPT & CONTRACT SVCS 3,969,799 3,214,821 1,523,577 19,290 48% 47% 1,671,954 COST POOL 148,843 148,843 111,634 - 75% 75% 37,209 ASSET/CAPITAL OUTLAY 1,033,473 1,723,451 1,050,829 435,009 86% 61% 237,613 [52] A87 COST PLAN REIMBS (410,873) (408,867) (306,649) - 75% 75% (102,218) OPER XFERS OUT - 294,000 - - 0% 0% 294,000 EXPENDITURE 7,820,402 8,580,408 4,513,199 626,101 60% 53% 3,441,108 NOTES
[47] Received more payments from Club Evolution than anticipated. [48] Workers compensation Clerical and Unemployment Insurance are higher than anticipated [49] Purchased a TV monitor and lobby chairs for BTA Community Center [50] PO encumbered with Ricoh USA Inc. for copier lease [52] PO encumbered with Nonagon Technology for network upgrade for Richmond Police Department dispatch software [51] Encumbered T-Mobile and AT&T Wireless charges

Attachment 1 - FY2023-24 Q3 Budget Review
FUNDS
FY2023-24

ORIGINAL
BUDGET
FY2023-24

REVISED BUDGET

ACTUALS
THRU
MARCH 2024
ENCUMB
W/
ENCUMB
% USED
W/O
ENCUMB
% USED

AVAILABLE

BUDGET NOTES
36 ECONOMIC DEVELOPMENT PROGRM
OTHER TAXES (1,687,995) (1,687,995) (1,017,639) - 60% 60% (670,356) [53] OPER XFERS IN (86,778) (86,778) (65,082) - 75% 75% (21,696) REVENUE (1,774,773) (1,774,773) (1,082,721) - 61% 61% (692,052) SALARIES AND WAGES 473,946 473,946 613,348 - 129% 129% (139,401) [54] PYRLL/FRINGE BENEFIT 316,160 316,160 310,072 - 98% 98% 6,088 [55] PROF & ADMIN 1,791,036 1,839,507 315,450 486,193 44% 17% 1,037,864 OTHER OPERATING 60,750 70,750 5,704 1,199 10% 8% 63,847 UTILITIES 10,440 10,440 106 2,500 25% 1% 7,834 EQPT & CONTRACT SVCS 1,000 1,000 192 - 19% 19% 808 PROVISN FOR INS LOSS 1,500 1,500 - - 0% 0% 1,500 COST POOL 63,190 63,190 47,395 - 75% 75% 15,795 ASSET/CAPITAL OUTLAY - - 438 - - - (438) [56] EXPENDITURE 2,718,022 2,776,493 1,292,705 489,893 64% 47% 993,896 37 INTERNAL SERVICES PROGRAM
SALARIES AND WAGES 167,088 167,088 152,259 - 91% 91% 14,829 [57] PYRLL/FRINGE BENEFIT 115,533 115,533 77,221 - 67% 67% 38,312 COST POOL 19,992 19,992 14,994 - 75% 75% 4,998 EXPENDITURE 302,613 302,613 244,474 - 81% 81% 58,139 38 TRANSPORTATION OPERATION
LICENSES,PRMITS&FEES (25,000) (25,000) (18,169) - 73% 73% (6,831) CHARGES FOR SERVICES (200) (200) (1,705) - 853% 853% 1,505 [58] REVENUE (25,200) (25,200) (19,874) - 79% 79% (5,326) SALARIES AND WAGES 250,100 230,100 162,858 - 71% 71% 67,242 PYRLL/FRINGE BENEFIT 136,247 136,247 87,324 - 64% 64% 48,923 PROF & ADMIN 10,500 10,500 755 - 7% 7% 9,745 OTHER OPERATING 17,200 17,200 1,988 1,825 22% 12% 13,387 EQPT & CONTRACT SVCS 6,600 6,600 - - 0% 0% 6,600 COST POOL 35,876 35,876 26,906 - 75% 75% 8,970 ASSET/CAPITAL OUTLAY 500 500 - - 0% 0% 500 OPER XFERS OUT - 20,000 - - 0% 0% 20,000 EXPENDITURE 457,023 457,023 279,831 1,825 62% 61% 175,367 NOTES
[53] A major portion of revenue from waste (garbage) taxes comes in June. [54] Staff salaries slightly higher than budgeted and no budget for auto allowance, medical flex and pension credits. A budget transfer will be done for the overages [55] Life, and unemployment insurance and other fringe benefits higher than anticipated [56] Purchased an office chair that was not budgeted.
[57] Staff salaries slightly higher due to longevity pay not budgeted [58] Received charges for services revenues for Richmond Moves transportation services

Attachment 1 - FY2023-24 Q3 Budget Review
FUNDS
FY2023-24

ORIGINAL
BUDGET
FY2023-24

REVISED BUDGET

ACTUALS
THRU
MARCH 2024
ENCUMB
W/
ENCUMB
% USED
W/O
ENCUMB
% USED

AVAILABLE

BUDGET NOTES
91 NON-DEPARTMENTAL
PROPERTY TAXES (50,567,173) (52,181,354) (28,367,873) - 54% 54% (23,813,481) [59] SALES & USE TAX (56,752,495) (57,897,341) (35,235,093) - 61% 61% (22,662,248) [60] UTILITY USERS TAX (55,775,083) (57,938,011) (43,516,676) - 75% 75% (14,421,336) [61] OTHER TAXES (21,549,728) (22,456,382) (6,481,026) - 29% 29% (15,975,357) [62] LICENSES,PRMITS&FEES (10,705,275) (13,155,275) (9,723,729) - 74% 74% (3,431,546) [63] FINES & FORFEITURES (281,144) (126,438) (94,397) - 75% 75% (32,041) [64] USE OF MONEY&PROPRTY (1,011,535) (1,796,421) (1,871,727) - 104% 104% 75,306 [65] CHARGES FOR SERVICES (132,000) (132,000) (2) - 0% 0% (131,998) [66] OTHER REVENUE (60,480) (60,480) (47,651) - 79% 79% (12,829) [67] RENTAL INCOME (175,078) (175,078) (135,216) - 77% 77% (39,862) [68] INTERGOV STATE TAXES (125,000) (125,000) (143,154) - 115% 115% 18,154 [69] INTERGOV STATE GRANT (100,000) (100,000) (89,831) - 90% 90% (10,169) [70] LOAN/BOND PROCEEDS (40,400) (40,400) - - 0% 0% (40,400) [71] OPER XFERS IN (20,223,580) (20,223,580) (20,223,580) - 100% 100% - [72] REVENUE (217,498,972) (226,407,761) (145,929,954) - 64% 64% (80,477,807) NOTES
[64] MUNI Court Fines are trending lower than expected
[65] Interest revenue received
[66] The admin fee for waste collection is received in June [72] Transfer In for Secured Pension Override Fund FY2023-24 [59] Current-Unsecured property tax received. Major portion, Secured Property Tax is received in December, April and June. [60] Sales & Use Tax revenue has a lag of two months, full Quarter 1 revenue will be received in November. [61] Utility user tax is trending higher due to PG&E increases in revenue [62] Transfer tax is trending lower. It is a volatile revenue stream and varies significantly from month to month and a few large sales have a significant impact. [63] Measure U revenue will be received between January and December of 2024. [67] Miscellaneous revenues trending lower than anticipated [68] Received one-time payment ($50k) for rental fees from National Park Service [69] State taxes for motor vehicles fees received between January through March from the State of California [70] Received reimbursements for programs that fall under SB90 (State Mandated Claims Reimbursements) from State of CA [71] Loan proceeds are received based on loan repayment schedules

Attachment 1 - FY2023-24 Q3 Budget Review
FUNDS
FY2023-24

ORIGINAL
BUDGET
FY2023-24

REVISED BUDGET

ACTUALS
THRU
MARCH 2024
ENCUMB
W/
ENCUMB
% USED
W/O
ENCUMB
% USED

AVAILABLE

BUDGET NOTES
SALARIES AND WAGES 929,298 929,298 1,950,001 - 210% 210% (1,020,703) [73] PYRLL/FRINGE BENEFIT 1,042,246 3,713,568 4,977,134 - 134% 134% (1,263,566) [74] PROF & ADMIN 1,824,836 2,102,513 826,599 289,433 53% 39% 986,481 OTHER OPERATING 1,770,311 1,574,343 88,624 28,790 7% 6% 1,456,928 UTILITIES 256,903 256,903 - - 0% 0% 256,903 EQPT & CONTRACT SVCS 130,222 166,190 - 35,968 22% 0% 130,222 COST POOL 3,743,093 3,743,093 3,916,770 - 105% 105% (173,677) [75] A87 COST PLAN REIMBS (566,611) (563,845) (422,865) - 75% 75% (140,980) OPER XFERS OUT 17,863,684 30,030,608 22,218,980 - 74% 74% 7,811,628 EXPENDITURE 26,993,982 41,952,671 33,555,244 354,191 81% 80% 8,043,236 GENERAL FUND - REVENUE TOTAL (225,374,607) (234,380,287) (151,183,268) - 65% 65% (83,197,019) GENERAL FUND - EXPENDITURE TOTAL 225,374,607 246,295,113 161,893,640 6,077,636 68% 66% 78,323,837 GENERAL FUND - NET (SURPLUS)DEFICIT - 11,914,826 10,710,373 6,077,636 141% 90% (4,873,183) BEGINNING BALANCE: 7/1/23 55,196,962 55,196,962 21% Reserve Policy 47,328,667 53,026,901
ESTIMATED ENDING BALANCE: 6/30/24 7,868,295 (9,744,765) NOTES
[73] Variance due to budget for anticipated 6M vacancy savings [74] Variance due to budget for anticipated 5.2M vacancy savings [75] Vehicle replacement internal service charges will be analyzed and a recommendation to adjust will be determined if needed.

Attachment 1 - FY2023-24 Q3 Budget Review
FUNDS
FY2023-24

ORIGINAL
BUDGET
FY2023-24

REVISED
BUDGET

ACTUALS
THRU
MARCH 2024
ENCUMB
W/
ENCUMB
% USED

W/O ENCUMB
% USED

AVAILABLE
BUDGET
FY2023-24

YEAR-END

PROJECTION
NOTES
1001 SECURED PENSION OVERRIDE
PROPERTY TAXES (26,391,783) (26,391,783) (14,992,871) - 57% 57% (11,398,912) (26,391,783) [1] REVENUE (26,391,783) (26,391,783) (14,992,871) - 57% 57% (11,398,912) (26,391,783) OPER XFERS OUT 28,567,497 28,567,497 28,567,497 - 100% 100% - 28,567,497 [2] EXPENDITURE 28,567,497 28,567,497 28,567,497 - 100% 100% - 28,567,497 NET (SURPLUS)DEFICIT 2,175,715 2,175,715 2,175,715 BEGINNING BALANCE: 7/1/23 5,811,792 5,811,792 5,811,792 ESTIMATED ENDING BALANCE: 6/30/24 3,636,078 3,636,078 3,636,078 1002 STATE GAS TAX
USE OF MONEY&PROPRTY - - (33,747) - - - 33,747 - [3] INTERGOV STATE TAXES (3,289,455) (3,289,455) (2,125,153) - 65% 65% (1,164,302) (3,289,455) [4] REVENUE (3,289,455) (3,289,455) (2,158,900) - 66% 66% (1,130,555) (3,289,455) PROF & ADMIN 34,000 34,000 3,758 - 11% 11% 30,242 34,000 EQPT & CONTRACT SVCS 850,000 850,000 756,572 - 89% 89% 93,428 850,000 [5] ASSET/CAPITAL OUTLAY 2,236,105 2,418,441 1,425,222 393,490 75% 59% 599,728 2,418,441 EXPENDITURE 3,120,105 3,302,441 2,185,553 393,490 78% 66% 723,398 3,302,441 NET (SURPLUS)DEFICIT (169,350) 12,986 12,986 BEGINNING BALANCE: 7/1/23 1,281,446 1,281,446 1,281,446 ESTIMATED ENDING BALANCE: 6/30/24 1,450,796 1,268,460 1,268,460 NOTES
[1] Property tax assessment is received in December, April, and June [2] Transfer Out for Pension Obligation Bonds Unfunded Liability, Pension Tax Override portion, and Security & Exchange Commission Pension Override [3] Interest Income for money in the bank account
[4] Reimbursements are based on expenses that have occurred [5] Paid street paving maintenance service costs

Attachment 1 - FY2023-24 Q3 Budget Review
FUNDS
FY2023-24

ORIGINAL
BUDGET
FY2023-24

REVISED
BUDGET

ACTUALS
THRU
MARCH 2024
ENCUMB
W/
ENCUMB
% USED

W/O ENCUMB
% USED

AVAILABLE
BUDGET
FY2023-24

YEAR-END

PROJECTION
NOTES
1003 TRANSPORTATION OPERATION
LICENSES,PRMITS&FEES - - (13,675) - - - 13,675 - [6] OTHER REVENUE (20,000) (20,000) (7,617) - 38% 38% (12,383) (20,000) [7] INTERGOV OTHER GRANT (859,097) (859,097) (24,000) - 3% 3% (835,097) (859,097) [8] OPER XFERS IN - (97,500) - - 0% 0% (97,500) (97,500) [9] REVENUE (879,097) (976,597) (45,292) - 5% 5% (931,305) (976,597) SALARIES AND WAGES 226,088 236,088 192,246 - 81% 81% 43,842 236,088 [10] PYRLL/FRINGE BENEFIT 226,214 226,214 177,278 - 78% 78% 48,936 226,214 [11] PROF & ADMIN 110,000 197,500 121,726 65,774 95% 62% 10,000 197,500 [12] OTHER OPERATING 7,900 7,900 4,017 1,788 73% 51% 2,095 7,900 UTILITIES 2,500 2,500 2,873 - 115% 115% (373) 2,500 [13] EQPT & CONTRACT SVCS 19,097 19,097 - - 0% 0% 19,097 19,097 COST POOL 270,211 270,211 202,660 - 75% 75% 67,551 270,211 EXPENDITURE 862,010 959,510 700,801 67,562 80% 73% 191,146 959,510 NET (SURPLUS)DEFICIT (17,087) (17,087) (17,087) BEGINNING BALANCE: 7/1/23 (837,776) (837,776) (837,776) ESTIMATED ENDING BALANCE: 6/30/24 (820,689) (820,689) (820,689) 1004 ASSET SEIZURE FUND
USE OF MONEY&PROPRTY - - (7,111) - - - 7,111 - [14] REVENUE - - (7,111) - - - 7,111 - ASSET/CAPITAL OUTLAY 140,000 202,025 9,996 - 5% 5% 192,029 202,025 EXPENDITURE 140,000 202,025 9,996 - 5% 5% 192,029 202,025 NET (SURPLUS)DEFICIT 140,000 202,025 202,025 BEGINNING BALANCE: 7/1/23 260,994 260,994 260,994 ESTIMATED ENDING BALANCE: 6/30/24 120,994 58,969 58,969 NOTES
[10] Current actual salaries slightly higher than budgeted but will not continue due to vacancies [11] Fringe benefits (Medical, Medicare, Dental) slightly higher than budgeted but will not continue due to vacancies [14] Interest Income from money in the bank account
[13] Paid Verizon wireless charges. Will make a budget transfer for the overage [12] Subsidized Lyft ride expenses
[6] Budget will be added for revenue received for Enterprise zone fee [7] R-Transit script book revenues has not been received yet [8] Reimbursements are based on expenses that have occurred [9] Reversed duplicate payment from T2 systems.

Attachment 1 - FY2023-24 Q3 Budget Review
FUNDS
FY2023-24

ORIGINAL
BUDGET
FY2023-24

REVISED
BUDGET

ACTUALS
THRU
MARCH 2024
ENCUMB
W/
ENCUMB
% USED

W/O ENCUMB
% USED

AVAILABLE
BUDGET
FY2023-24

YEAR-END

PROJECTION
NOTES
1005 LIBRARY FUND
FINES & FORFEITURES - - (6,560) - - - 6,560 - [15] USE OF MONEY&PROPRTY - - (126,326) - - - 126,326 - [16] INTERGOV FED GRANT - (65,296) (41,796) - 64% 64% (23,500) (65,296) [17] INTERGOV STATE GRANT (10,175,752) (10,195,354) (179,395) - 2% 2% (10,015,959) (10,195,354) [18] INTERGOV OTHER GRANT (60,000) (219,333) - - 0% 0% (219,333) (219,333) [19] REVENUE (10,235,752) (10,479,983) (354,077) - 3% 3% (10,125,906) (10,479,983) SALARIES AND WAGES (161,645) (161,645) - - 0% 0% (161,645) (161,645) PYRLL/FRINGE BENEFIT (52,045) (29,834) - - 0% 0% (29,834) (29,834) PROF & ADMIN 477,780 676,082 123,237 88,268 31% 18% 464,577 676,082 OTHER OPERATING 12,183 22,901 11,783 3,528 67% 51% 7,590 22,901 ASSET/CAPITAL OUTLAY 9,954,479 9,962,899 196,812 949,572 12% 2% 8,816,515 9,962,899 GRANT EXPENDITURES 5,000 17,500 23,995 1,372 145% 137% (7,867) 17,500 [20] EXPENDITURE 10,235,752 10,487,903 355,828 1,042,739 13% 3% 9,089,336 10,487,903 NET (SURPLUS)DEFICIT - 7,920 7,920 BEGINNING BALANCE: 7/1/23 213,907 213,907 213,907 ESTIMATED ENDING BALANCE: 6/30/24 213,907 205,987 205,987 1006 OUTSIDE FUNDED SVCS - GRANTS
INTERGOV STATE GRANT (21,986,200) (29,144,539) (4,249,887) - 15% 15% (24,894,652) (29,144,539) [21] INTERGOV OTHER GRANT (58,812) (494,337) (140,385) - 28% 28% (353,952) (494,337) [22] REVENUE (22,045,012) (29,638,876) (4,390,272) - 15% 15% (25,248,604) (29,638,876) PROF & ADMIN 3,629,224 7,702,921 1,576,370 2,883,125 58% 20% 3,243,425 7,702,921 OTHER OPERATING 16,977 66,227 144 - 0% 0% 66,083 66,227 UTILITIES 50,000 90,500 - - 0% 0% 90,500 90,500 EQPT & CONTRACT SVCS 272,000 272,000 121,000 - 44% 44% 151,000 272,000 ASSET/CAPITAL OUTLAY 15,144,623 21,092,389 7,814,602 2,788,274 50% 37% 10,489,513 21,092,389 GRANT EXPENDITURES 2,932,188 3,003,988 349,880 9,217 12% 12% 2,644,891 3,003,988 EXPENDITURE 22,045,012 32,228,024 9,861,996 5,680,616 48% 31% 16,685,412 32,228,024 NET (SURPLUS)DEFICIT - 2,589,149 2,589,149 BEGINNING BALANCE: 7/1/23 (4,485,822) (4,485,822) (4,485,822) ESTIMATED ENDING BALANCE: 6/30/24 (4,485,822) (7,074,970) (7,074,970) NOTES
[17,18,19] Reimbursements are based on expenses that have occurred [16] Interest Income from money in the bank account
[15] Received revenues from Library fines and fees that were not budgeted [20] Wireless hot-spot monthly service is more than anticipated [21] Reimbursements are based on expenses that have occurred [22] Received funding for MLK turf replacement and reimbursement for BEAM EV ARC Grant

Attachment 1 - FY2023-24 Q3 Budget Review
FUNDS
FY2023-24

ORIGINAL
BUDGET
FY2023-24

REVISED
BUDGET

ACTUALS
THRU
MARCH 2024
ENCUMB
W/
ENCUMB
% USED

W/O ENCUMB
% USED

AVAILABLE
BUDGET
FY2023-24

YEAR-END

PROJECTION
NOTES
1007 EMERGENCY MED SERV
PROPERTY TAXES (215,586) (215,586) - - 0% 0% (215,586) (215,586) [23] USE OF MONEY&PROPRTY - - (8,009) - - - 8,009 - [24] REVENUE (215,586) (215,586) (8,009) - 4% 4% (207,578) (215,586) PROF & ADMIN 103,100 103,100 12,117 4,000 16% 12% 86,983 103,100 OTHER OPERATING 38,486 38,486 24,016 - 62% 62% 14,470 38,486 EQPT & CONTRACT SVCS 74,000 74,000 - - 0% 0% 74,000 74,000 EXPENDITURE 215,586 215,586 36,133 4,000 19% 17% 175,453 215,586 NET (SURPLUS)DEFICIT (0) (0) (0) BEGINNING BALANCE: 7/1/23 273,429 273,429 273,429 ESTIMATED ENDING BALANCE: 6/30/24 273,430 273,430 273,430 1009 VEOLIA MITIGATION
LICENSES,PRMITS&FEES (25,000) (25,000) (12,500) - 50% 50% (12,500) (25,000) [25] USE OF MONEY&PROPRTY - - (8,093) - - - 8,093 - [26] REVENUE (25,000) (25,000) (20,593) - 82% 82% (4,407) (25,000) PROF & ADMIN 100,000 100,000 - - 0% 0% 100,000 100,000 EXPENDITURE 100,000 100,000 - - 0% 0% 100,000 100,000 NET (SURPLUS)DEFICIT 75,000 75,000 75,000 BEGINNING BALANCE: 7/1/23 313,373 313,373 313,373 ESTIMATED ENDING BALANCE: 6/30/24 238,373 238,373 238,373 1010 N.RICHMOND WASTE
LICENSES,PRMITS&FEES (124,207) (124,207) - - 0% 0% (124,207) (124,207) [27] USE OF MONEY&PROPRTY - - (1,471) - - - 1,471 - [28] REVENUE (124,207) (124,207) (1,471) - 1% 1% (122,736) (124,207) PROF & ADMIN 122,375 122,375 - - 0% 0% 122,375 122,375 OTHER OPERATING 832 832 120 - 14% 14% 712 832 UTILITIES 1,000 1,000 603 573 118% 60% (176) 1,000 [29] ASSET/CAPITAL OUTLAY - - 456 - - - (456) - [30] EXPENDITURE 124,207 124,207 1,178 573 1% 1% 122,456 124,207

NET (SURPLUS)DEFICIT - - - BEGINNING BALANCE: 7/1/23 67,036 67,036 67,036 ESTIMATED ENDING BALANCE: 6/30/24 67,036 67,036 67,036 NOTES
[23] Property tax assessment is received in December, April, and June [26] Interest Income from money in the bank account
[28] Interest Income from money in the bank account
[27] Hazardous Material fee from Contra Costa County was received in February last year [29] Encumbered North Richmond Mitigation for refuse (garbage) service [30] Purchased tools for Mobile Library vehicle.
[25] Revenues from permits and fees will be received throughout the fiscal year [24] Interest Income from money in the bank account Page 14 of 35 Attachment 1 - FY2023-24 Q3 Budget Review
FUNDS
FY2023-24

ORIGINAL
BUDGET
FY2023-24

REVISED
BUDGET

ACTUALS
THRU
MARCH 2024
ENCUMB
W/
ENCUMB
% USED

W/O ENCUMB
% USED

AVAILABLE
BUDGET
FY2023-24

YEAR-END

PROJECTION
NOTES
1011 OUTSIDE FUNDED SVCS - DONATION
USE OF MONEY&PROPRTY - - (181) - - - 181 [31] REVENUE - - (181) - - - 181 1012 HILLTOP LANDSCAPE MAINT DIST
PROPERTY TAXES (1,124,594) (1,124,594) (618,523) - 55% 55% (506,071) (1,124,594) [32] USE OF MONEY&PROPRTY - - (4,822) - - - 4,822 - [33] OPER XFERS IN (235,988) (235,988) (176,990) - 75% 75% (58,998) (235,988) REVENUE (1,360,582) (1,360,582) (800,335) - 59% 59% (560,247) (1,360,582) SALARIES AND WAGES 587,668 587,668 443,866 - 76% 76% 143,802 587,668 [34] PYRLL/FRINGE BENEFIT 466,983 466,983 331,677 - 71% 71% 135,306 466,983 PROF & ADMIN 40,000 40,000 10,083 12,417 56% 25% 17,500 40,000 OTHER OPERATING 67,900 77,900 35,890 3,558 51% 46% 38,452 77,900 UTILITIES 88,000 88,000 72,374 - 82% 82% 15,626 88,000 [35] EQPT & CONTRACT SVCS 75,000 65,000 21,620 10,810 50% 33% 32,571 65,000 COST POOL 463,200 463,200 347,401 - 75% 75% 115,799 463,200 ASSET/CAPITAL OUTLAY - 23,000 23,000 - 100% 100% - 23,000 [36] EXPENDITURE 1,788,751 1,811,751 1,285,910 26,786 72% 71% 499,056 1,811,751 NET (SURPLUS)DEFICIT 428,169 451,169 451,169 BEGINNING BALANCE: 7/1/23 247,492 247,492 247,492 ESTIMATED ENDING BALANCE: 6/30/24 (180,678) (203,678) (203,678) 1015 MARINA BAY LNDSCP & LIGHT DIST
PROPERTY TAXES (709,524) (709,524) (393,065) - 55% 55% (316,459) (709,524) [37] USE OF MONEY&PROPRTY - - (15,819) - - - 15,819 - [38] OPER XFERS IN (476,309) (476,309) (357,233) - 75% 75% (119,076) (476,309) REVENUE (1,185,833) (1,185,833) (766,117) - 65% 65% (419,716) (1,185,833) SALARIES AND WAGES 399,727 399,727 332,775 - 83% 83% 66,952 399,727 [39] PYRLL/FRINGE BENEFIT 241,437 241,437 206,461 - 86% 86% 34,976 241,437 [40] PROF & ADMIN 53,503 53,503 21,950 30,100 97% 41% 1,453 53,503 [41] OTHER OPERATING 80,000 80,000 38,391 6,881 57% 48% 34,728 80,000 UTILITIES 134,395 134,395 136,722 - 102% 102% (2,327) 134,395 [42] COST POOL 153,348 153,348 115,011 - 75% 75% 38,337 153,348 ASSET/CAPITAL OUTLAY - 41,000 - - 0% 0% 41,000 41,000 EXPENDITURE 1,062,410 1,103,410 851,310 36,981 81% 77% 215,118 1,103,410 NET (SURPLUS)DEFICIT (123,423) (82,423) (82,423) BEGINNING BALANCE: 7/1/23 (18,717) (18,717) (18,717) ESTIMATED ENDING BALANCE: 6/30/24 104,707 63,707 63,707 NOTES
[37] Property tax assessment is received in December, April, and June [36] Completed expenses for Hilltop Gateway Signs Project [32] Property tax assessment is received in December, April, and June [31, 33, 38] Interest Income from money in the bank account [34] Hilltop crew overtime for weed abatement and high fire zones [35] Paid water bill for various medians and parks.
[39] Salaries for PT- Temp employees sightly higher than budgeted [40] Fringe benefits (Medical, Medicare, Dental) slightly higher than budgeted [41] Park restroom janitorial service from Enviroclean Maintenance encumbered [42] Paid water bill for various medians and parks.

Attachment 1 - FY2023-24 Q3 Budget Review
FUNDS
FY2023-24

ORIGINAL
BUDGET
FY2023-24

REVISED
BUDGET

ACTUALS
THRU
MARCH 2024
ENCUMB
W/
ENCUMB
% USED

W/O ENCUMB
% USED

AVAILABLE
BUDGET
FY2023-24

YEAR-END

PROJECTION
NOTES
1017 CHEVRON MODERNIZATN PROJ & CIA
USE OF MONEY&PROPRTY - - (455,814) - - - 455,814 - [43] OTHER REVENUE - - 42,075 - - - (42,075) - INTERGOV OTHER GRANT (4,000,000) (4,000,000) (16,500) - 0% 0% (3,983,500) (4,000,000) [44] REVENUE (4,000,000) (4,000,000) (430,239) - 11% 11% (3,569,761) (4,000,000) - - - - - - - - PROF & ADMIN 7,986,442 8,095,093 1,498,545 174,093 21% 19% 6,422,456 8,095,093 OTHER OPERATING 19,541 20,541 557 - 3% 3% 19,984 20,541 EQPT & CONTRACT SVCS 1,502,829 1,501,829 303,629 289,033 39% 20% 909,166 1,501,829 ASSET/CAPITAL OUTLAY 171,901 207,252 67,640 13,320 39% 33% 126,292 207,252 GRANT EXPENDITURES 50,000 50,000 - - 0% 0% 50,000 50,000 EXPENDITURE 9,730,713 9,874,715 1,870,371 476,446 24% 19% 7,527,898 9,874,715 NET (SURPLUS)DEFICIT 5,730,713 5,874,715 5,874,715 BEGINNING BALANCE: 7/1/23 17,657,501 17,657,501 17,657,501 ESTIMATED ENDING BALANCE: 6/30/24 11,926,787 11,782,786 11,782,786 1018 RENT CONTROL
LICENSES,PRMITS&FEES (2,914,945) (3,004,698) (2,618,535) - 87% 87% (386,163) (3,004,698) USE OF MONEY&PROPRTY (20,000) (20,000) (52,599) - 263% 263% 32,599 (20,000) [45] OTHER REVENUE (50,000) (50,000) (26,235) - 52% 52% (23,765) (50,000) [46] OPER XFERS IN (150,000) (150,000) (112,500) - 75% 75% (37,500) (150,000) REVENUE (3,134,945) (3,224,698) (2,809,869) - 87% 87% (414,829) (3,224,698) SALARIES AND WAGES 1,442,839 1,670,462 1,172,900 - 70% 70% 497,562 1,670,462 PYRLL/FRINGE BENEFIT 868,399 981,380 682,845 - 70% 70% 298,535 981,380 PROF & ADMIN 547,458 427,358 154,226 86,887 56% 36% 186,245 427,358 OTHER OPERATING 33,425 51,780 17,989 3,556 42% 35% 30,235 51,780 UTILITIES 500 500 - - 0% 0% 500 500 EQPT & CONTRACT SVCS - - 56 4 - - (60) - PROVISN FOR INS LOSS 9,300 9,300 9,195 40 99% 99% 65 9,300 [47] COST POOL 330,473 330,473 247,856 - 75% 75% 82,617 330,473 ASSET/CAPITAL OUTLAY 3,000 5,000 - - 0% 0% 5,000 5,000 EXPENDITURE 3,235,394 3,476,253 2,285,067 90,487 68% 66% 1,100,699 3,476,253 NET (SURPLUS)DEFICIT 100,449 251,555 251,555 BEGINNING BALANCE: 7/1/23 636,946 636,946 636,946 ESTIMATED ENDING BALANCE: 6/30/24 536,497 385,391 385,391 NOTES
[43] Interest Income from money in the bank account
[44] Reimbursements are based on expenses that have occurred [45] Interest Income from money in the bank account
[46] Bad debts recovery revenue has not been received yet [47] Encumbered Insurance Services from CB Malaga Insurance

Attachment 1 - FY2023-24 Q3 Budget Review
FUNDS
FY2023-24

ORIGINAL
BUDGET
FY2023-24

REVISED
BUDGET

ACTUALS
THRU
MARCH 2024
ENCUMB
W/
ENCUMB
% USED

W/O ENCUMB
% USED

AVAILABLE
BUDGET
FY2023-24

YEAR-END

PROJECTION
NOTES
1019 ROAD MAINT & REHAB ACCT (RMRA)
USE OF MONEY&PROPRTY - - (69,565) - - - 69,565 - [48] INTERGOV STATE TAXES (2,864,927) (2,864,927) (1,914,761) - 67% 67% (950,166) (2,864,927) [49] REVENUE (2,864,927) (2,864,927) (1,984,326) - 69% 69% (880,601) (2,864,927) - - - - - - - - ASSET/CAPITAL OUTLAY 2,944,644 3,577,828 34,685 637,299 19% 1% 2,905,844 3,577,828 EXPENDITURE 2,944,644 3,577,828 34,685 637,299 19% 1% 2,905,844 3,577,828 NET (SURPLUS)DEFICIT 79,717 712,901 712,901 BEGINNING BALANCE: 7/1/23 1,514,406 1,514,406 1,514,406 ESTIMATED ENDING BALANCE: 6/30/24 1,434,689 801,505 801,505 1050 CR-PLANNING & BUILDING
LICENSES,PRMITS&FEES (7,012,038) (7,012,038) (6,151,482) - 88% 88% (860,556) (7,012,038) USE OF MONEY&PROPRTY (32,307) (32,307) (392,898) - 1216% 1216% 360,591 (32,307) [50] CHARGES FOR SERVICES (4,314,000) (4,314,000) (203,606) - 5% 5% (4,110,394) (4,314,000) [51] OTHER REVENUE (50) (50) - - 0% 0% (50) (50) [52] INTERGOV FED GRANT (750,000) (750,000) - - 0% 0% (750,000) (750,000) [53] INTERGOV STATE GRANT (3,735,340) (3,861,030) (2,635,882) - 68% 68% (1,225,148) (3,861,030) [54] INTERGOV OTHER GRANT - (15,000) - - 0% 0% (15,000) (15,000) OPER XFERS IN (1,800,000) (1,800,000) (511,357) - 28% 28% (1,288,643) (1,800,000) [55] REVENUE (17,643,736) (17,784,426) (9,895,225) - 56% 56% (7,889,200) (17,784,426) SALARIES AND WAGES 2,903,182 3,083,766 2,009,378 - 65% 65% 1,074,388 3,083,766 PYRLL/FRINGE BENEFIT 1,803,443 1,803,443 1,168,555 - 65% 65% 634,888 1,803,443 PROF & ADMIN 10,581,394 12,794,348 4,522,149 6,641,766 87% 35% 1,630,433 12,794,348 [56] OTHER OPERATING 132,791 147,954 138,624 31,004 115% 94% (21,674) 147,954 [57] UTILITIES 9,000 40,200 8,077 26,325 86% 20% 5,798 40,200 [58] EQPT & CONTRACT SVCS 51,644 76,876 1,198 22,852 31% 2% 52,826 76,876 COST POOL 2,325,434 2,325,434 1,744,074 - 75% 75% 581,360 2,325,434 ASSET/CAPITAL OUTLAY 1,000 108,770 8,626 1,000 9% 8% 99,144 108,770 [59] EXPENDITURE 17,807,888 20,380,791 9,600,680 6,722,946 80% 47% 4,057,164 20,380,791 NET (SURPLUS)DEFICIT 164,153 2,596,365 2,596,365 BEGINNING BALANCE: 7/1/23 6,337,091 6,337,091 6,337,091 ESTIMATED ENDING BALANCE: 6/30/24 6,172,938 3,740,725 3,740,725 NOTES
[59] Encumbered services to reupholster 126 chairs and 4 sofas [57] Ricoh copier lease encumbrance
[58] Encumbered expenses for Richmond Sanitary service
[56] Encumbered project management services from Way 2 Love Inc. and The Healing Spot Counseling Ctr. Inc. [51] Pass-thru Planning EIR CEQA revenues Levin Terminal, Hydrogen Plan, and Aymium has historically been done monthly [52] Revenues from miscellaneous revenue will be received throughout the fiscal year [53, 54] Reimbursements are based on expenses that have occurred [55] Transfers in for Reimaging and Unhoused Intervention Reimaging Program have not taken place yet [48, 50] Interest Income from money in the bank account [49] Reimbursements are based on expenses that have occurred

Attachment 1 - FY2023-24 Q3 Budget Review
FUNDS
FY2023-24

ORIGINAL
BUDGET
FY2023-24

REVISED
BUDGET

ACTUALS
THRU
MARCH 2024
ENCUMB
W/
ENCUMB
% USED

W/O ENCUMB
% USED

AVAILABLE
BUDGET
FY2023-24

YEAR-END

PROJECTION
NOTES
1054 ENGINEERING GRANTS
INTERGOV FED GRANT (5,000) (3,988,000) (1,939,489) - 49% 49% (2,048,511) (3,988,000) [60] INTERGOV STATE GRANT (11,626,357) (16,144,425) (1,874,113) - 12% 12% (14,270,312) (16,144,425) [61] INTERGOV OTHER GRANT (312,099) (314,599) (500,000) - 159% 159% 185,401 (314,599) REVENUE (11,943,456) (20,447,024) (4,313,601) - 21% 21% (16,133,423) (20,447,024) PROF & ADMIN - 55,000 4,800 30,600 64% 9% 19,600 55,000 EQPT & CONTRACT SVCS 27,500 - - - - - - - ASSET/CAPITAL OUTLAY 11,915,956 27,417,798 2,699,350 9,277,934 44% 10% 15,440,514 27,417,798 EXPENDITURE 11,943,456 27,472,798 2,704,150 9,308,534 44% 10% 15,460,114 27,472,798 NET (SURPLUS)DEFICIT - 7,025,774 7,025,774 BEGINNING BALANCE: 7/1/23 (12,391,781) (12,391,781) (12,391,781) ESTIMATED ENDING BALANCE: 6/30/24 (12,391,781) (19,417,554) (19,417,554) 1055 ENCROACHMENT SVCS
LICENSES,PRMITS&FEES (838,000) (838,000) (739,983) - 88% 88% (98,017) (838,000) USE OF MONEY&PROPRTY - - (74,739) - - - 74,739 - [62] CHARGES FOR SERVICES (227,000) (227,000) (316,646) - 139% 139% 89,646 (227,000) REVENUE (1,065,000) (1,065,000) (1,131,368) - 106% 106% 66,368 (1,065,000) SALARIES AND WAGES 412,750 458,238 224,004 - 49% 49% 234,234 458,238 PYRLL/FRINGE BENEFIT 264,071 264,071 161,628 - 61% 61% 102,443 264,071 PROF & ADMIN - 925 - - 0% 0% 925 925 OTHER OPERATING 4,700 3,775 279 471 20% 7% 3,025 3,775 UTILITIES 2,900 2,900 2,699 - 93% 93% 201 2,900 [63] COST POOL 207,055 207,055 155,293 - 75% 75% 51,762 207,055 EXPENDITURE 891,476 936,964 543,903 471 58% 58% 392,589 936,964 NET (SURPLUS)DEFICIT (173,524) (128,036) (128,036) BEGINNING BALANCE: 7/1/23 2,743,116 2,743,116 2,743,116 ESTIMATED ENDING BALANCE: 6/30/24 2,916,640 2,871,152 2,871,152 NOTES
[60, 61] Reimbursements are based on expenses that have occurred [62] Interest Income from money in the bank account
[63] Paid Verizon wireless charges which are higher than anticipated

Attachment 1 - FY2023-24 Q3 Budget Review
FUNDS
FY2023-24

ORIGINAL
BUDGET
FY2023-24

REVISED
BUDGET

ACTUALS
THRU
MARCH 2024
ENCUMB
W/
ENCUMB
% USED

W/O ENCUMB
% USED

AVAILABLE
BUDGET
FY2023-24

YEAR-END

PROJECTION
NOTES
1200 HOUSING ADMINISTRATION
LICENSES,PRMITS&FEES (25,000) (25,000) (14,970) - 60% 60% (10,030) (25,000) [64] USE OF MONEY&PROPRTY (3,741) (3,741) (29,047) - 777% 777% 25,306 (3,741) [65] OTHER REVENUE (618,299) (618,299) (558,201) - 90% 90% (60,097) (618,299) [66] REVENUE (647,039) (647,039) (602,219) - 93% 93% (44,821) (647,039) SALARIES AND WAGES 249,418 249,418 5,501 - 2% 2% 243,917 249,418 PYRLL/FRINGE BENEFIT 93,990 93,990 42,595 - 45% 45% 51,395 93,990 PROF & ADMIN 168,903 168,903 6,260 2,625 5% 4% 160,017 168,903 OTHER OPERATING 1,909 1,909 856 - 45% 45% 1,053 1,909 UTILITIES 801 801 (21) - -3% -3% 822 801 [67] COST POOL 121,347 121,347 91,008 - 75% 75% 30,339 121,347 EXPENDITURE 636,367 636,367 146,199 2,625 23% 23% 487,543 636,367 NET (SURPLUS)DEFICIT (10,672) (10,672) (10,672) BEGINNING BALANCE: 7/1/23 917,436 917,436 917,436 ESTIMATED ENDING BALANCE: 6/30/24 928,108 928,108 928,108 1201 CDBG
USE OF MONEY&PROPRTY (19,567) (19,567) (80,205) - 410% 410% 60,638 (19,567) [68] LOAN/BOND PROCEEDS (142,356) (142,356) (191,591) - 135% 135% 49,236 (142,356) [69] REVENUE (161,923) (161,923) (271,796) - 168% 168% 109,873 (161,923) PROF & ADMIN 18,272 18,272 8,142 - 45% 45% 10,129 18,272 OTHER OPERATING 51 51 - - 0% 0% 51 51 COST POOL 26,923 26,923 20,194 - 75% 75% 6,729 26,923 CDBG/HOME/HSG PROJ 926,481 926,481 - - 0% 0% 926,481 926,481 EXPENDITURE 971,726 971,726 28,336 - 3% 3% 943,390 971,726 NET (SURPLUS)DEFICIT 809,803 809,803 809,803 BEGINNING BALANCE: 7/1/23 1,237,154 1,237,154 1,237,154 ESTIMATED ENDING BALANCE: 6/30/24 427,351 427,351 427,351 1202 HOME PROGRAM
USE OF MONEY&PROPRTY (957) (957) (6,170) - 645% 645% 5,213 (957) [70] LOAN/BOND PROCEEDS (2,538) (2,538) - - 0% 0% (2,538) (2,538) [71] REVENUE (3,494) (3,494) (6,170) - 177% 177% 2,675 (3,494) NET (SURPLUS)DEFICIT (3,494) (3,494) (3,494) BEGINNING BALANCE: 7/1/23 420,879 420,879 420,879 ESTIMATED ENDING BALANCE: 6/30/24 424,373 424,373 424,373 NOTES
[64] Housing admin fees received. Remaining revenue is expected by June. [65, 68, 70] Interest Income from money in the bank account [66] Revenues received from In Lieu Developer fees
[67] Received credit from Nextel Communications
[69] Historical loan repayments have been received
[71] Loan/bond proceeds revenues are received after expenditures take place

Attachment 1 - FY2023-24 Q3 Budget Review
FUNDS
FY2023-24

ORIGINAL
BUDGET
FY2023-24

REVISED
BUDGET

ACTUALS
THRU
MARCH 2024
ENCUMB
W/
ENCUMB
% USED

W/O ENCUMB
% USED

AVAILABLE
BUDGET
FY2023-24

YEAR-END

PROJECTION
NOTES
1203 NEIGHBORHOOD STAB(NP)
LOAN/BOND PROCEEDS (15,000) (15,000) - - 0% 0% (15,000) (15,000) [72] REVENUE (15,000) (15,000) - - 0% 0% (15,000) (15,000) PROF & ADMIN 9,500 9,500 3,117 5,717 93% 33% 666 9,500 [73] EXPENDITURE 9,500 9,500 3,117 5,717 93% 33% 666 9,500 NET (SURPLUS)DEFICIT (5,500) (5,500) (5,500) BEGINNING BALANCE: 7/1/23 67,196 67,196 67,196 ESTIMATED ENDING BALANCE: 6/30/24 72,696 72,696 72,696 1205 EMPLOYMENT & TRAINING
OTHER REVENUE - - (185) - - - 185 - INTERGOV FED GRANT (2,789,664) (3,779,035) (1,326,963) - 35% 35% (2,452,071) (3,779,035) [74] INTERGOV STATE GRANT (2,972,695) (3,557,662) (908,596) - 26% 26% (2,649,066) (3,557,662) [75] INTERGOV OTHER GRANT (282,983) (432,983) (20,000) - 5% 5% (412,983) (432,983) [76] OPER XFERS IN (2,466,201) (2,852,907) (1,840,321) - 65% 65% (1,012,586) (2,852,907) REVENUE (8,511,543) (10,622,586) (4,096,065) - 39% 39% (6,526,521) (10,622,586) SALARIES AND WAGES 2,192,811 767,571 1,179,251 - 154% 154% (411,679) 767,571 [77] PYRLL/FRINGE BENEFIT 1,683,712 1,683,712 853,213 - 51% 51% 830,499 1,683,712 PROF & ADMIN 15,700 167,639 42,997 1,583 27% 26% 123,059 167,639 [78] OTHER OPERATING 54,000 69,104 37,828 26,879 94% 55% 4,397 69,104 [79] UTILITIES 2,500 2,500 6,359 1,549 316% 254% (5,407) 2,500 [80] EQPT & CONTRACT SVCS 850,723 1,241,496 111,486 300,909 33% 9% 829,101 1,241,496 COST POOL 561,697 561,697 421,270 - 75% 75% 140,427 561,697 GRANT EXPENDITURES 4,058,067 5,910,556 2,517,014 205,363 46% 43% 3,188,179 5,910,556 EMPLMT & TRNG ALLOC (1,079,476) (748,765) (0) - 0% 0% (748,765) (748,765) EXPENDITURE 8,339,734 9,655,510 5,169,417 536,282 59% 54% 3,949,811 9,655,510 NET (SURPLUS)DEFICIT (171,809) (967,076) (967,076) BEGINNING BALANCE: 7/1/23 1,106,894 1,106,894 1,106,894 ESTIMATED ENDING BALANCE: 6/30/24 1,278,703 2,073,970 2,073,970 1207 COR-NEIGHBORHOOD STAB(CITY)
PROC FR SLE PROP (133,664) (133,664) - - 0% 0% (133,664) (133,664) [81] REVENUE (133,664) (133,664) - - 0% 0% (133,664) (133,664) OTHER OPERATING 6,753 6,753 2,338 1,162 52% 35% 3,253 6,753 [82] EXPENDITURE 6,753 6,753 2,338 1,162 52% 35% 3,253 6,753 NET (SURPLUS)DEFICIT (126,911) (126,911) (126,911) BEGINNING BALANCE: 7/1/23 (28,992) (28,992) (28,992) ESTIMATED ENDING BALANCE: 6/30/24 97,920 97,920 97,920 NOTES
[72] Loan/bond proceeds revenues are received after expenditures take place [73] Encumbered legal services from Goldfarb & Lipman to assist Housing [74, 75, 76] Reimbursements are based on expenses that have occurred [77] Part-time salaries was not budgeted
[78] Paid travel expenses for Youth Symposium
[79] Ricoh copier lease encumbrance
[80] Comcast internet service encumbrance
[81] Sales of property is not received equally monthly
[82] Encumbered budget from vendor Contra Costa County ORC for property tax & penalty

Attachment 1 - FY2023-24 Q3 Budget Review
FUNDS
FY2023-24

ORIGINAL
BUDGET
FY2023-24

REVISED
BUDGET

ACTUALS
THRU
MARCH 2024
ENCUMB
W/
ENCUMB
% USED

W/O ENCUMB
% USED

AVAILABLE
BUDGET
FY2023-24

YEAR-END

PROJECTION
NOTES
1208 COR-SUCCESSOR HOUSING AGENCY
USE OF MONEY&PROPRTY (23,752) (23,752) (68,828) - 290% 290% 45,076 (23,752) [83] OTHER REVENUE - - (36,702) - - - 36,702 - PROC FR SLE PROP - - (19,286) - - - 19,286 - [84] LOAN/BOND PROCEEDS (63,448) (63,448) - - 0% 0% (63,448) (63,448) [85] REVENUE (87,200) (87,200) (124,815) - 143% 143% 37,615 (87,200) SALARIES AND WAGES 130,698 130,698 98,024 - 75% 75% 32,675 130,698 PYRLL/FRINGE BENEFIT 79,756 79,756 59,817 - 75% 75% 19,939 79,756 PROF & ADMIN 200 200 - - 0% 0% 200 200 CDBG/HOME/HSG PROJ 1,000,000 1,000,000 - - 0% 0% 1,000,000 1,000,000 EXPENDITURE 1,210,655 1,210,655 157,841 - 13% 13% 1,052,814 1,210,655 NET (SURPLUS)DEFICIT 1,123,455 1,123,455 1,123,455 BEGINNING BALANCE: 7/1/23 25,768,200 25,768,200 25,768,200 ESTIMATED ENDING BALANCE: 6/30/24 24,644,745 24,644,745 24,644,745 1209 CAL-HOME GRANT FUND
USE OF MONEY&PROPRTY (9,931) (9,931) (47,942) - 483% 483% 38,011 (9,931) [86] LOAN/BOND PROCEEDS (80,389) (80,389) (112,020) - 139% 139% 31,631 (80,389) [87] REVENUE (90,321) (90,321) (159,962) - 177% 177% 69,642 (90,321) PROF & ADMIN 1,200 1,200 1,322 - 110% 110% (122) 1,200 [88] CDBG/HOME/HSG PROJ 500,000 500,000 - - 0% 0% 500,000 500,000 EXPENDITURE 501,200 501,200 1,322 - 0% 0% 499,878 501,200 NET (SURPLUS)DEFICIT 410,880 410,880 410,880 BEGINNING BALANCE: 7/1/23 1,000,885 1,000,885 1,000,885 ESTIMATED ENDING BALANCE: 6/30/24 590,005 590,005 590,005 1302 HOUSNG IN LIEU FEE - DEVELOPER
LICENSES,PRMITS&FEES (495,269) (495,269) (828,828) - 167% 167% 333,559 (495,269) [89] USE OF MONEY&PROPRTY (566) (566) (47,090) - 8324% 8324% 46,524 (566) [90] REVENUE (495,834) (495,834) (875,918) - 177% 177% 380,083 (495,834) SALARIES AND WAGES 89,452 89,452 67,089 - 75% 75% 22,363 89,452 PYRLL/FRINGE BENEFIT 52,685 52,685 39,514 - 75% 75% 13,171 52,685 PROF & ADMIN 15,000 15,000 - - 0% 0% 15,000 15,000 ASSET/CAPITAL OUTLAY 1,150,000 1,150,000 - - 0% 0% 1,150,000 1,150,000 CDBG/HOME/HSG PROJ 850,000 850,000 - - 0% 0% 850,000 850,000 ESTIMATED ENDING BALANCE: 6/30/24 3,636,078 3,636,078 3,636,078 OPER XFERS OUT 480,000 480,000 - - 0% 0% 480,000 480,000 EXPENDITURE 6,273,215 2,637,137 106,603 - 4% 4% (1,105,544) 6,273,215 NET (SURPLUS)DEFICIT 5,777,381 2,141,303 5,777,381 BEGINNING BALANCE: 7/1/23 3,004,983 3,004,983 3,004,983 ESTIMATED ENDING BALANCE: 6/30/24 (2,772,398) 863,680 (2,772,398) NOTES
[84] City's portion of the Shared Appreciation Value for 404 Marina received [85] Loan repayments are unpredictable. Revenues have been received historically in November and June [87] Revenues from bond proceeds were received in October [88] Paid Amerinational Management Fees
[89] Received significant payment from developer In-Lieu fee for 1411 Harbour Way South site [83, 86, 90] Interest Income from money in the bank account

Attachment 1 - FY2023-24 Q3 Budget Review
FUNDS
FY2023-24

ORIGINAL
BUDGET
FY2023-24

REVISED
BUDGET

ACTUALS
THRU
MARCH 2024
ENCUMB
W/
ENCUMB
% USED

W/O ENCUMB
% USED

AVAILABLE
BUDGET
FY2023-24

YEAR-END

PROJECTION
NOTES
1303 KIDS FIRST INITIATIVE
USE OF MONEY&PROPRTY - - (128,094) - - - 128,094 - [91] OPER XFERS IN (6,453,091) (6,453,091) (4,839,817) - 75% 75% (1,613,274) (6,453,091) REVENUE (6,453,091) (6,453,091) (4,967,911) - 77% 77% (1,485,180) (6,453,091) SALARIES AND WAGES (43,927) (59,593) 162,004 - -272% -272% (221,597) (59,593) [92] PYRLL/FRINGE BENEFIT 47,218 64,548 86,951 - 135% 135% (22,403) 64,548 [93] PROF & ADMIN 6,103,579 6,103,579 611,722 1,096,365 28% 10% 4,395,492 6,103,579 OTHER OPERATING 24,000 24,000 12,445 1,199 57% 52% 10,356 24,000 COST POOL 4,453 4,453 3,340 - 75% 75% 1,113 4,453 EXPENDITURE 6,135,323 6,136,987 876,462 1,097,564 32% 14% 4,162,961 6,136,987 NET (SURPLUS)DEFICIT (317,768) (316,104) (316,104) BEGINNING BALANCE: 7/1/23 3,996,614 3,996,614 3,996,614 ESTIMATED ENDING BALANCE: 6/30/24 4,314,383 4,312,719 4,312,719 1304 EMERGENCY OPE & DISASTR RECVRY
USE OF MONEY&PROPRTY - - (6,491) - - - 6,491 - [94] INTERGOV STATE GRANT - - (18,463) - - - 18,463 - OPER XFERS IN (75,000) (75,000) (75,000) - 100% 100% - (75,000) [95] REVENUE (75,000) (75,000) (99,954) - 133% 133% 24,954 (75,000) PROF & ADMIN 75,000 314,000 165,091 45,200 67% 53% 103,709 314,000 OTHER OPERATING - - 1,590 - - - (1,590) - [96] EXPENDITURE 75,000 314,000 166,681 45,200 67% 53% 102,119 314,000 NET (SURPLUS)DEFICIT - 239,000 239,000 BEGINNING BALANCE: 7/1/23 239,276 239,276 239,276 ESTIMATED ENDING BALANCE: 6/30/24 239,276 276 276 1305 PUBLIC ART
LICENSES,PRMITS&FEES (400,000) (400,000) (416,014) - 104% 104% 16,014 (400,000) [97] USE OF MONEY&PROPRTY - - (63,393) - - - 63,393 - [98] REVENUE (400,000) (400,000) (479,407) - 120% 120% 79,407 (400,000) PROF & ADMIN 1,153,500 1,150,496 45,102 314,339 31% 4% 791,054 1,150,496 OTHER OPERATING - 3,005 2,591 - 86% 86% 414 3,005 [99] EXPENDITURE 1,153,500 1,153,500 47,693 314,339 31% 4% 791,468 1,153,500 NET (SURPLUS)DEFICIT 753,500 753,500 753,500 BEGINNING BALANCE: 7/1/23 2,470,673 2,470,673 2,470,673 ESTIMATED ENDING BALANCE: 6/30/24 1,717,173 1,717,173 1,717,173 NOTES
[99] Paid postage expense to I.T. Department
[91, 94, 98] Interest Income from money in the bank account [92] Error in budgeted contra amount for salary
[93] Contras benefits for staff time of grant funded positions have not been processed yet [95] Completed transfer in for Climate Res. Contingency [96] Purchased safety supplies and materials. A budget transfer will be completed. [97] Permit revenues have historically come in December and May

Attachment 1 - FY2023-24 Q3 Budget Review
FUNDS
FY2023-24

ORIGINAL
BUDGET
FY2023-24

REVISED
BUDGET

ACTUALS
THRU
MARCH 2024
ENCUMB
W/
ENCUMB
% USED

W/O ENCUMB
% USED

AVAILABLE
BUDGET
FY2023-24

YEAR-END

PROJECTION
NOTES
1306 AMERICAN RESCUE PLAN ACT
USE OF MONEY&PROPRTY - - (626,607) - - - 626,607 - [100] REVENUE - - (626,607) - - - 626,607 - PROF & ADMIN 803,750 7,505,473 124,471 1,075,654 16% 2% 6,305,348 7,505,473 ASSET/CAPITAL OUTLAY 6,928,890 15,930,418 337,046 2,062,554 15% 2% 13,530,818 15,930,418 EXPENDITURE 7,732,640 23,435,891 461,516 3,138,209 15% 2% 19,836,166 23,435,891 NET (SURPLUS)DEFICIT 7,732,640 23,435,891 23,435,891 BEGINNING BALANCE: 7/1/23 1,914,523 1,914,523 1,914,523 ESTIMATED ENDING BALANCE: 6/30/24 (5,818,117) (21,521,368) (21,521,368) 1307 TRANSFORMATIVE CLIMATE COMMUNITIES
INTERGOV STATE GRANT - (35,000,000) - - 0% 0% (35,000,000) (35,000,000) [101] REVENUE - (35,000,000) - - 0% 0% (35,000,000) (35,000,000) PYRLL/FRINGE BENEFIT - (0) - - 0% 0% (0) (0) PROF & ADMIN - 30,266,216 554,751 3,351,369 13% 2% 26,360,097 30,266,216 OTHER OPERATING - 29,640 18 - 0% 0% 29,622 29,640 UTILITIES - 1,500 - - 0% 0% 1,500 1,500 ASSET/CAPITAL OUTLAY - 5,095,358 - - 0% 0% 5,095,358 5,095,358 GRANT EXPENDITURES - 80,000 - - 0% 0% 80,000 80,000 EXPENDITURE - 35,472,714 554,768 3,351,369 11% 2% 31,566,577 35,472,714 NET (SURPLUS)DEFICIT - 472,714 472,714 BEGINNING BALANCE: 7/1/23 - - - ESTIMATED ENDING BALANCE: 6/30/24 - (472,714) (472,714) 1308 ENCAMPMENT RESOLUTION FUND
INTERGOV STATE GRANT - (8,602,587) - - 0% 0% (8,602,587) (8,602,587) [102] REVENUE - (8,602,587) - - 0% 0% (8,602,587) (8,602,587) PROF & ADMIN - 7,777,587 - - 0% 0% 7,777,587 7,777,587 OTHER OPERATING - 800,000 - - 0% 0% 800,000 800,000 UTILITIES - 25,000 - - 0% 0% 25,000 25,000 EXPENDITURE - 8,602,587 - - 0% 0% 8,602,587 8,602,587

NET (SURPLUS)DEFICIT - - - BEGINNING BALANCE: 7/1/23 - - - ESTIMATED ENDING BALANCE: 6/30/24 - - - NOTES
[100] Interest Income from money in the bank account
[101, 102] Received the Transformative Climate grant

Attachment 1 - FY2023-24 Q3 Budget Review
FUNDS
FY2023-24

ORIGINAL
BUDGET
FY2023-24

REVISED
BUDGET

ACTUALS
THRU
MARCH 2024
ENCUMB
W/
ENCUMB
% USED

W/O ENCUMB
% USED

AVAILABLE
BUDGET
FY2023-24

YEAR-END

PROJECTION
NOTES
2001 GENERAL CAPITAL FUND
USE OF MONEY&PROPRTY - - (3,685) - - - 3,685 - [103] OTHER REVENUE - (300,000) (300,001) - 100% 100% 1 (300,000) [104] OPER XFERS IN (650,000) (13,764,218) (10,170,218) - 74% 74% (3,594,000) (13,764,218) [105] REVENUE (650,000) (14,064,218) (10,473,904) - 74% 74% (3,590,314) (14,064,218) PROF & ADMIN - 1,105,384 220,018 255,468 43% 20% 629,898 1,105,384 EQPT & CONTRACT SVCS - 67,000 37,444 29,556 100% 56% - 67,000 [106] ASSET/CAPITAL OUTLAY 22,820,449 37,227,280 1,442,464 2,167,735 10% 4% 33,617,081 37,227,280 EXPENDITURE 22,820,449 38,399,664 1,699,926 2,452,759 11% 4% 34,246,979 38,399,664 NET (SURPLUS)DEFICIT 22,170,449 24,335,446 24,335,446 BEGINNING BALANCE: 7/1/23 23,171,347 23,171,347 23,171,347 ESTIMATED ENDING BALANCE: 6/30/24 1,000,898 (1,164,098) (1,164,098) 2002 MEASURE J
USE OF MONEY&PROPRTY - - (41,108) - - - 41,108 - [107] INTERGOV OTHER GRANT (4,292,882) (3,128,821) (2,133,263) - 68% 68% (995,558) (3,128,821) [108] REVENUE (4,292,882) (3,128,821) (2,174,371) - 69% 69% (954,450) (3,128,821) PROF & ADMIN 200,000 200,000 - - 0% 0% 200,000 200,000 EQPT & CONTRACT SVCS 15,000 - - - - - - - ASSET/CAPITAL OUTLAY 5,927,803 2,920,389 634,052 525,238 40% 22% 1,761,099 2,920,389 EXPENDITURE 6,142,803 3,120,389 634,052 525,238 37% 20% 1,961,099 3,120,389 NET (SURPLUS)DEFICIT 1,849,921 (8,431) (8,431) BEGINNING BALANCE: 7/1/23 1,414,863 1,414,863 1,414,863 ESTIMATED ENDING BALANCE: 6/30/24 (435,058) 1,423,294 1,423,294 2007 HARBOR FUND
USE OF MONEY&PROPRTY - - (1,222) - - - 1,222 - [109] REVENUE - - (1,222) - - - 1,222 -

NET (SURPLUS)DEFICIT - - - BEGINNING BALANCE: 7/1/23 46,530 46,530 46,530 ESTIMATED ENDING BALANCE: 6/30/24 46,530 46,530 46,530 2110 IMPACT FEE - PARKS
LICENSES,PRMITS&FEES - (15,096) (23,304) - 154% 154% 8,208 (15,096) USE OF MONEY&PROPRTY - - (4,184) - - - 4,184 - [110] REVENUE - (15,096) (27,488) - 182% 182% 12,392 (15,096) ASSET/CAPITAL OUTLAY 15,000 15,000 15,000 - 100% 100% - 15,000 [111] EXPENDITURE 15,000 15,000 15,000 - 100% 100% - 15,000 NET (SURPLUS)DEFICIT 15,000 (96) (96) BEGINNING BALANCE: 7/1/23 156,253 156,253 156,253 ESTIMATED ENDING BALANCE: 6/30/24 141,253 156,349 156,349 NOTES
[103, 107, 109, 110] Interest Income from money in the bank account [104] Received Brickyard Cove Association other revenue [105] Completed majority of transfers in for the year
[106] Encumbered professional services from Wiss, Janney, Elstner Associates for Pt. Molate Cottages [108] Reimbursements are based on expenses that have occurred [111] Paid annual JPA Capital contribution

Attachment 1 - FY2023-24 Q3 Budget Review
FUNDS
FY2023-24

ORIGINAL
BUDGET
FY2023-24

REVISED
BUDGET

ACTUALS
THRU
MARCH 2024
ENCUMB
W/
ENCUMB
% USED

W/O ENCUMB
% USED

AVAILABLE
BUDGET
FY2023-24

YEAR-END

PROJECTION
NOTES
2111 IMPACT FEE - TRAFFIC
LICENSES,PRMITS&FEES - (71,296) (106,720) - 150% 150% 35,424 (71,296) USE OF MONEY&PROPRTY - - (40,768) - - - 40,768 - [112] REVENUE - (71,296) (147,488) - 207% 207% 76,192 (71,296) ASSET/CAPITAL OUTLAY - 29,608 - 29,608 100% 0% - 29,608 [113] EXPENDITURE - 29,608 - 29,608 100% 0% - 29,608 NET (SURPLUS)DEFICIT - (41,688) (41,688) BEGINNING BALANCE: 7/1/23 1,479,301 1,479,301 1,479,301 ESTIMATED ENDING BALANCE: 6/30/24 1,479,301 1,520,989 1,520,989 2113 IMPACT FEE - FIRE
LICENSES,PRMITS&FEES - (15,172) (23,740) - 156% 156% 8,568 (15,172) USE OF MONEY&PROPRTY - - (1,972) - - - 1,972 - [114] REVENUE - (15,172) (25,712) - 169% 169% 10,540 (15,172) OTHER OPERATING 117,000 117,000 48,175 - 41% 41% 68,825 117,000 EXPENDITURE 117,000 117,000 48,175 - 41% 41% 68,825 117,000 NET (SURPLUS)DEFICIT 117,000 101,828 101,828 BEGINNING BALANCE: 7/1/23 60,394 60,394 60,394 ESTIMATED ENDING BALANCE: 6/30/24 (56,606) (41,434) (41,434) 2114 IMPACT FEE - POLICE
LICENSES,PRMITS&FEES - (13,088) (20,126) - 154% 154% 7,038 (13,088) USE OF MONEY&PROPRTY - - (17,081) - - - 17,081 - [115] REVENUE - (13,088) (37,207) - 284% 284% 24,119 (13,088) ASSET/CAPITAL OUTLAY 155,000 256,201 101,201 - 40% 40% 155,000 256,201 EXPENDITURE 155,000 256,201 101,201 - 40% 40% 155,000 256,201 NET (SURPLUS)DEFICIT 155,000 243,113 243,113 BEGINNING BALANCE: 7/1/23 641,151 641,151 641,151 ESTIMATED ENDING BALANCE: 6/30/24 486,151 398,037 398,037 2115 IMPACT FEE - COMM/AQUATC
LICENSES,PRMITS&FEES - (60,758) (90,764) - 149% 149% 30,006 (60,758) USE OF MONEY&PROPRTY - - (15,607) - - - 15,607 - [116] REVENUE - (60,758) (106,371) - 175% 175% 45,613 (60,758) NET (SURPLUS)DEFICIT - (60,758) (60,758) BEGINNING BALANCE: 7/1/23 574,104 574,104 574,104 ESTIMATED ENDING BALANCE: 6/30/24 574,104 634,862 634,862 NOTES
[113] Encumbered budget for Traffic Safety Improvements [112, 114, 115, 116] Interest Income from money in the bank account

Attachment 1 - FY2023-24 Q3 Budget Review
FUNDS
FY2023-24

ORIGINAL
BUDGET
FY2023-24

REVISED
BUDGET

ACTUALS
THRU
MARCH 2024
ENCUMB
W/
ENCUMB
% USED

W/O ENCUMB
% USED

AVAILABLE
BUDGET
FY2023-24

YEAR-END

PROJECTION
NOTES
2116 IMPACT FEE - PARKS/OPEN
LICENSES,PRMITS&FEES - (253,350) (378,450) - 149% 149% 125,100 (253,350) USE OF MONEY&PROPRTY - - (80,084) - - - 80,084 - [117] REVENUE - (253,350) (458,534) - 181% 181% 205,184 (253,350) PROF & ADMIN - 80,000 76,607 46 96% 96% 3,347 80,000 [118] ASSET/CAPITAL OUTLAY 373,264 373,264 - - 0% 0% 373,264 373,264 EXPENDITURE 373,264 453,264 76,607 46 17% 17% 376,611 453,264 NET (SURPLUS)DEFICIT 373,264 199,914 199,914 BEGINNING BALANCE: 7/1/23 2,957,381 2,957,381 2,957,381 ESTIMATED ENDING BALANCE: 6/30/24 2,584,117 2,757,467 2,757,467 2117 IMPACT FEE - LIBRARY
LICENSES,PRMITS&FEES - (72,106) (106,000) - 147% 147% 33,894 (72,106) USE OF MONEY&PROPRTY - - (47,722) - - - 47,722 - [119] REVENUE - (72,106) (153,722) - 213% 213% 81,616 (72,106) ASSET/CAPITAL OUTLAY 1,204,188 1,204,188 65,123 2 5% 5% 1,139,063 1,204,188 EXPENDITURE 1,204,188 1,204,188 65,123 2 5% 5% 1,139,063 1,204,188 NET (SURPLUS)DEFICIT 1,204,188 1,132,082 1,132,082 BEGINNING BALANCE: 7/1/23 1,796,770 1,796,770 1,796,770 ESTIMATED ENDING BALANCE: 6/30/24 592,582 664,688 664,688 2118 IMPACT FEE - HILLTOP
USE OF MONEY&PROPRTY - - (848) - - - 848 - [120] REVENUE - - (848) - - - 848 -

NET (SURPLUS)DEFICIT - - - BEGINNING BALANCE: 7/1/23 32,306 32,306 32,306 ESTIMATED ENDING BALANCE: 6/30/24 32,306 32,306 32,306 2119 IMPACT FEE - STORM DRAINAGE
LICENSES,PRMITS&FEES - (23,854) (36,634) - 154% 154% 12,780 (23,854) USE OF MONEY&PROPRTY - - (27,125) - - - 27,125 - [121] REVENUE - (23,854) (63,759) - 267% 267% 39,905 (23,854) NET (SURPLUS)DEFICIT - (23,854) (23,854) BEGINNING BALANCE: 7/1/23 1,035,975 1,035,975 1,035,975 ESTIMATED ENDING BALANCE: 6/30/24 1,035,975 1,059,829 1,059,829 2120 IMPACT FEE - WASTEWATER
USE OF MONEY&PROPRTY - - (63,843) - - - 63,843 - [122] REVENUE - - (63,843) - - - 63,843 - ASSET/CAPITAL OUTLAY 250,000 923,842 - 673,842 73% 0% 250,000 923,842 EXPENDITURE 250,000 923,842 - 673,842 73% 0% 250,000 923,842 NET (SURPLUS)DEFICIT 250,000 923,842 923,842 BEGINNING BALANCE: 7/1/23 1,741,052 1,741,052 1,741,052 ESTIMATED ENDING BALANCE: 6/30/24 1,491,052 817,210 817,210 NOTES
[117, 119, 120, 121, 122] Interest Income from money in the bank account [118] Paid engineering services for Richmond Soccer Field Page 26 of 35 Attachment 1 - FY2023-24 Q3 Budget Review
FUNDS
FY2023-24

ORIGINAL
BUDGET
FY2023-24

REVISED
BUDGET

ACTUALS
THRU
MARCH 2024
ENCUMB
W/
ENCUMB
% USED

W/O ENCUMB
% USED

AVAILABLE
BUDGET
FY2023-24

YEAR-END

PROJECTION
NOTES
2125 IRON TRIANGLE/EPA PROGRAM
USE OF MONEY&PROPRTY (1,329) (1,329) (6,796) - 511% 511% 5,467 (1,329) [123] INTERGOV FED GRANT (275,967) (275,967) (60,740) - 22% 22% (215,227) (275,967) [124] REVENUE (277,297) (277,297) (67,537) - 24% 24% (209,760) (277,297) CDBG/HOME/HSG PROJ 275,967 275,967 60,740 21,260 30% 22% 193,967 275,967 EXPENDITURE 275,967 275,967 60,740 21,260 30% 22% 193,967 275,967 NET (SURPLUS)DEFICIT (1,329) (1,329) (1,329) BEGINNING BALANCE: 7/1/23 264,789 264,789 264,789 ESTIMATED ENDING BALANCE: 6/30/24 266,118 266,118 266,118 3001 DS - 2005 TAXABLE POB
USE OF MONEY&PROPRTY - - (53,781) - - - 53,781 - [125] OPER XFERS IN (11,403,165) (11,403,165) (11,153,663) - 98% 98% (249,502) (11,403,165) [126] REVENUE (11,403,165) (11,403,165) (11,207,445) - 98% 98% (195,721) (11,403,165) DEBT SVC EXPENDITURE 11,403,165 11,403,165 11,403,697 - 100% 100% (531) 11,403,165 [127] EXPENDITURE 11,403,165 11,403,165 11,403,697 - 100% 100% (531) 11,403,165

NET (SURPLUS)DEFICIT - - - BEGINNING BALANCE: 7/1/23 236,789 236,789 236,789 ESTIMATED ENDING BALANCE: 6/30/24 236,789 236,789 236,789 3002 DS - 99A PENSION OBLIG BOND
USE OF MONEY&PROPRTY - - (1,750) - - - 1,750 - [128] REVENUE - - (1,750) - - - 1,750 - DEBT SVC EXPENDITURE - - 5,133 - - - (5,133) - [129] EXPENDITURE - - 5,133 - - - (5,133) -

NET (SURPLUS)DEFICIT - - - BEGINNING BALANCE: 7/1/23 80,526 80,526 80,526 ESTIMATED ENDING BALANCE: 6/30/24 80,526 80,526 80,526 3005 DS - 07 REFNDING&CVC CTR
USE OF MONEY&PROPRTY - - (8,092) - - - 8,092 - [130] CHARGES FOR SERVICES (6,684,183) (6,684,183) (5,106,130) - 76% 76% (1,578,053) (6,684,183) OPER XFERS IN (1,463,868) (1,463,868) (1,097,901) - 75% 75% (365,967) (1,463,868) REVENUE (8,148,051) (8,148,051) (6,212,123) - 76% 76% (1,935,928) (8,148,051) DEBT SVC EXPENDITURE 7,771,713 7,771,713 5,872,170 - 76% 76% 1,899,542 7,771,713 [131] EXPENDITURE 7,771,713 7,771,713 5,872,170 - 76% 76% 1,899,542 7,771,713 NET (SURPLUS)DEFICIT (376,339) (376,339) (376,339) BEGINNING BALANCE: 7/1/23 (2,220,140) (2,220,140) (2,220,140) ESTIMATED ENDING BALANCE: 6/30/24 (1,843,802) (1,843,802) (1,843,802) NOTES
[127] Interest payment on 2005 POB debt service
[129, 131] Paid debt service for the year
[123, 125, 128, 130] Interest Income from money in the bank account [124] Reimbursements are based on expenses that have occurred [126] Transfer in for Pension Obligation Bond debt service

Attachment 1 - FY2023-24 Q3 Budget Review
FUNDS
FY2023-24

ORIGINAL
BUDGET
FY2023-24

REVISED
BUDGET

ACTUALS
THRU
MARCH 2024
ENCUMB
W/
ENCUMB
% USED

W/O ENCUMB
% USED

AVAILABLE
BUDGET
FY2023-24

YEAR-END

PROJECTION
NOTES
4001 PORT OF RICHMOND
USE OF MONEY&PROPRTY - - (467,469) - - - 467,469 - [132] RENTAL INCOME (10,451,891) (10,501,891) (4,928,234) - 47% 47% (5,573,658) (10,501,891) [133] INTERGOV OTHER GRANT (1,003,250) (1,003,250) - - 0% 0% (1,003,250) (1,003,250) [134] REVENUE (11,455,141) (11,505,141) (5,395,702) - 47% 47% (6,109,439) (11,505,141) SALARIES AND WAGES 459,994 459,994 289,186 - 63% 63% 170,808 459,994 PYRLL/FRINGE BENEFIT 268,361 268,361 178,988 - 67% 67% 89,373 268,361 PROF & ADMIN 1,001,500 999,394 618,524 142,036 76% 62% 238,834 999,394 [135] OTHER OPERATING 7,200 8,200 2,566 6,700 113% 31% (1,066) 8,200 [136] UTILITIES 483,500 487,100 340,367 3,272 71% 70% 143,461 487,100 EQPT & CONTRACT SVCS 58,000 197,400 70,644 26,356 49% 36% 100,400 197,400 PROVISN FOR INS LOSS 45,000 45,000 43,967 - 98% 98% 1,033 45,000 [137] COST POOL 481,859 481,859 361,394 - 75% 75% 120,465 481,859 ASSET/CAPITAL OUTLAY 5,575,000 5,575,000 1,530 - 0% 0% 5,573,470 5,575,000 DEBT SVC EXPENDITURE 4,267,000 4,267,000 106,213 - 2% 2% 4,160,787 4,267,000 EXPENDITURE 12,647,414 12,789,308 2,013,379 178,363 17% 16% 10,597,566 12,789,308 NET (SURPLUS)DEFICIT 1,192,273 1,284,167 1,284,167 BEGINNING BALANCE: 7/1/23 29,128,106 29,128,106 29,128,106 ESTIMATED ENDING BALANCE: 6/30/24 27,935,833 27,843,939 27,843,939 4003 WASTEWATER
LICENSES,PRMITS&FEES (36,000) (36,000) (106,159) - 295% 295% 70,159 (36,000) FINES & FORFEITURES (2,000) (2,000) - - 0% 0% (2,000) (2,000) [138] USE OF MONEY&PROPRTY - - (996,033) - - - 996,033 - [139] CHARGES FOR SERVICES (28,250,000) (28,250,000) (18,073,773) - 64% 64% (10,176,227) (28,250,000) REVENUE (28,288,000) (28,288,000) (19,175,965) - 68% 68% (9,112,035) (28,288,000) SALARIES AND WAGES 1,485,971 1,508,582 939,143 - 62% 62% 569,439 1,508,582 PYRLL/FRINGE BENEFIT 796,804 796,804 549,093 - 69% 69% 247,711 796,804 PROF & ADMIN 10,844,657 14,522,269 6,337,834 3,610,803 69% 44% 4,573,632 14,522,269 [140] OTHER OPERATING 368,409 378,409 23,357 1,063 6% 6% 353,989 378,409 UTILITIES 1,417,049 1,417,049 951,161 - 67% 67% 465,888 1,417,049 EQPT & CONTRACT SVCS 412,300 542,839 216,367 101,015 58% 40% 225,458 542,839 COST POOL 663,397 663,397 497,545 - 75% 75% 165,852 663,397 ASSET/CAPITAL OUTLAY 47,005,000 57,714,702 7,679,460 4,699,379 21% 13% 45,335,862 57,714,702 DEBT SVC EXPENDITURE 8,059,725 8,059,725 8,060,310 - 100% 100% (585) 8,059,725 [141] EXPENDITURE 71,053,312 85,603,777 25,254,269 8,412,261 39% 30% 51,937,247 85,603,777 NET (SURPLUS)DEFICIT 42,765,312 57,315,777 57,315,777 BEGINNING BALANCE: 7/1/23 57,095,476 57,095,476 57,095,476 ESTIMATED ENDING BALANCE: 6/30/24 14,330,164 (220,300) (220,300) NOTES
[138] Fines and forfeiture revenues are unpredictable but historically have been received in January [132, 139] Interest Income from money in the bank account [133] Revenues from leasing at Pt. Potrero Marine-Auto will be received throughout the fiscal year [134] Reimbursements are based on expenses that have occurred [135] Encumbered Engineering services for Port
[136] Encumbered Ricoh copier lease
[137] Paid Port of Richmond Liability Insurance
[140] Encumbered professional services from Veolia Environmental and Sonoma Technology, Inc. [141] Paid debt service for the year

Attachment 1 - FY2023-24 Q3 Budget Review
FUNDS
FY2023-24

ORIGINAL
BUDGET
FY2023-24

REVISED
BUDGET

ACTUALS
THRU
MARCH 2024
ENCUMB
W/
ENCUMB
% USED

W/O ENCUMB
% USED

AVAILABLE
BUDGET
FY2023-24

YEAR-END

PROJECTION
NOTES
4005 MARINA
USE OF MONEY&PROPRTY - - (131,319) - - - 131,319 - [142] RENTAL INCOME (450,000) (450,000) (420,193) - 93% 93% (29,807) (450,000) REVENUE (450,000) (450,000) (551,512) - 123% 123% 101,512 (450,000) PROF & ADMIN 924,842 924,842 5,312 6,600 1% 1% 912,930 924,842 DEBT SVC EXPENDITURE 206,815 206,815 206,815 - 100% 100% - 206,815 [143] OPER XFERS OUT 86,778 86,778 65,082 - 75% 75% 21,696 86,778 EXPENDITURE 1,218,435 1,218,435 277,209 6,600 23% 23% 934,626 1,218,435 NET (SURPLUS)DEFICIT 768,435 768,435 768,435 BEGINNING BALANCE: 7/1/23 4,204,961 4,204,961 4,204,961 ESTIMATED ENDING BALANCE: 6/30/24 3,436,526 3,436,526 3,436,526 4006 STORMWATER
LICENSES,PRMITS&FEES (75,000) (75,000) (24,452) - 33% 33% (50,548) (75,000) [144] FINES & FORFEITURES - - (500) - - - 500 - USE OF MONEY&PROPRTY - - (37,837) - - - 37,837 - [145] CHARGES FOR SERVICES (1,930,300) (1,930,300) (1,123,419) - 58% 58% (806,881) (1,930,300) [146] RENTAL INCOME (4,380) (4,380) (3,900) - 89% 89% (480) (4,380) INTERGOV STATE GRANT (1,341,278) (1,341,278) - - 0% 0% (1,341,278) (1,341,278) [147] REVENUE (3,350,958) (3,350,958) (1,190,109) - 36% 36% (2,160,849) (3,350,958) SALARIES AND WAGES 113,054 113,054 26,935 - 24% 24% 86,119 113,054 PYRLL/FRINGE BENEFIT 70,192 70,192 15,594 - 22% 22% 54,598 70,192 PROF & ADMIN 1,529,583 2,299,871 945,956 731,334 73% 41% 622,582 2,299,871 [148] OTHER OPERATING 137,175 112,175 67,272 11,214 70% 60% 33,689 112,175 [149] UTILITIES 40,000 40,000 26,789 - 67% 67% 13,211 40,000 EQPT & CONTRACT SVCS - 226,451 113,011 93,440 91% 50% 20,000 226,451 [150] COST POOL 90,530 90,530 67,898 - 75% 75% 22,632 90,530 ASSET/CAPITAL OUTLAY 1,341,278 3,357,945 2,091,449 1,077,373 94% 62% 189,124 3,357,945 [151] EXPENDITURE 3,321,812 6,310,219 3,354,904 1,913,360 83% 53% 1,041,954 6,310,219 NET (SURPLUS)DEFICIT (29,146) 2,959,261 2,959,261 BEGINNING BALANCE: 7/1/23 3,320,225 3,320,225 3,320,225 ESTIMATED ENDING BALANCE: 6/30/24 3,349,371 360,964 360,964 NOTES
[142, 145] Interest Income from money in the bank account [143] Paid principal and interest for Marina debt service [150] Encumbered design management services from American Rivers Inc. [151] Encumbered construction flood risk expenses from UST Testing Services [144] Plan check permits revenues historically has been received in October and November [146] Storm drain revenues are received in December, April, and June [147] Reimbursements are based on expenses that have occurred [148] PO's encumbered with Veolia for annual operation & maintenance of the Treatment Plant and Sanitary Sewer System [149] Encumbered services for Streetsweeper rentals

Attachment 1 - FY2023-24 Q3 Budget Review
FUNDS
FY2023-24

ORIGINAL
BUDGET
FY2023-24

REVISED
BUDGET

ACTUALS
THRU
MARCH 2024
ENCUMB
W/
ENCUMB
% USED

W/O ENCUMB
% USED

AVAILABLE
BUDGET
FY2023-24

YEAR-END

PROJECTION
NOTES
4008 KCRT - CABLE TELEVIS
LICENSES,PRMITS&FEES (1,250,000) (1,250,000) (474,987) - 38% 38% (775,013) (1,250,000) [152] USE OF MONEY&PROPRTY - - (15,259) - - - 15,259 - [153] REVENUE (1,250,000) (1,250,000) (490,246) - 39% 39% (759,754) (1,250,000) SALARIES AND WAGES 505,455 505,455 438,662 - 87% 87% 66,793 505,455 [154] PYRLL/FRINGE BENEFIT 340,880 340,880 263,202 - 77% 77% 77,679 340,880 [155] PROF & ADMIN 53,800 53,800 17,366 - 32% 32% 36,434 53,800 OTHER OPERATING 37,721 37,721 36,813 - 98% 98% 908 37,721 [156] UTILITIES 5,727 5,727 2,754 2,473 91% 48% 500 5,727 [157] PROVISN FOR INS LOSS 604 604 - - 0% 0% 604 604 COST POOL 221,506 221,506 166,129 - 75% 75% 55,377 221,506 EXPENDITURE 1,165,693 1,165,693 924,926 2,473 80% 79% 238,294 1,165,693 NET (SURPLUS)DEFICIT (84,307) (84,307) (84,307) BEGINNING BALANCE: 7/1/23 (1,292,089) (1,292,089) (1,292,089) ESTIMATED ENDING BALANCE: 6/30/24 (1,207,782) (1,207,782) (1,207,782) 4201 RHA-CAPITAL FUND
INTERGOV FED GRANT (1,458,433) (1,458,433) (927,055) - 64% 64% (531,378) (1,458,433) [158] REVENUE (1,458,433) (1,458,433) (927,055) - 64% 64% (531,378) (1,458,433) PROF & ADMIN 219,250 279,250 76,643 44,276 43% 27% 158,332 279,250 [159] OTHER OPERATING 170,000 170,000 68,018 2,524 41% 40% 99,459 170,000 EQPT & CONTRACT SVCS 150,308 280,308 148,187 34,313 65% 53% 97,808 280,308 ASSET/CAPITAL OUTLAY 125,000 25,000 - 25 0% 0% 24,975 25,000 GRANT EXPENDITURES 328,480 238,480 22,429 30,431 22% 9% 185,620 238,480 OPER XFERS OUT 465,395 465,395 390,712 - 84% 84% 74,683 465,395 [160] EXPENDITURE 1,458,433 1,458,433 705,989 111,568 56% 48% 640,876 1,458,433

NET (SURPLUS)DEFICIT - - - BEGINNING BALANCE: 7/1/23 1,606,223 1,606,223 1,606,223 ESTIMATED ENDING BALANCE: 6/30/24 1,606,223 1,606,223 1,606,223 NOTES
[152] Quarterly revenues from Comcast, DirectTV, and Constellation New Energy has not been received yet [153] Interest Income from money in the bank account
[160] Transfer Out for Capital Fund Operations
[155] PERS Unfunded Accrued Liability is slightly higher than budgeted [156] Purchased computer hardware and accessories
[157] Encumbered cable and internet services from Comcast [158] Reimbursements are based on expenses that have occurred [159] Financial services encumbered from D. Rosen consulting [154] Part-time salaries were not budgeted

Attachment 1 - FY2023-24 Q3 Budget Review
FUNDS
FY2023-24

ORIGINAL
BUDGET
FY2023-24

REVISED
BUDGET

ACTUALS
THRU
MARCH 2024
ENCUMB
W/
ENCUMB
% USED

W/O ENCUMB
% USED

AVAILABLE
BUDGET
FY2023-24

YEAR-END

PROJECTION
NOTES
4401 RHA-HACIENDA
PROC FR SLE PROP (57,000) (57,000) - - 0% 0% (57,000) (57,000) [161] REVENUE (57,000) (57,000) - - 0% 0% (57,000) (57,000) SALARIES AND WAGES 10,000 10,000 6,653 - 67% 67% 3,347 10,000 PYRLL/FRINGE BENEFIT 5,000 5,000 3,846 - 77% 77% 1,154 5,000 [162] OTHER OPERATING 5,000 5,000 72 - 1% 1% 4,928 5,000 UTILITIES 1,000 1,000 - - 0% 0% 1,000 1,000 EQPT & CONTRACT SVCS 36,000 36,000 - - 0% 0% 36,000 36,000 EXPENDITURE 57,000 57,000 10,571 - 19% 19% 46,429 57,000

NET (SURPLUS)DEFICIT - - - BEGINNING BALANCE: 7/1/23 (2,124,872) (2,124,872) (2,124,872) ESTIMATED ENDING BALANCE: 6/30/24 (2,124,872) (2,124,872) (2,124,872) 4404 RHA-NEVIN PLAZA
OTHER REVENUE - - (465) - - - 465 - RENTAL INCOME - - 11,157 - - - (11,157) - [163] INTERGOV FED GRANT (535,198) (555,995) (337,315) - 61% 61% (218,680) (555,995) REVENUE (535,198) (555,995) (326,623) - 59% 59% (229,372) (555,995) SALARIES AND WAGES 22,076 26,410 59,804 - 226% 226% (33,394) 26,410 [164] PYRLL/FRINGE BENEFIT 13,985 13,985 33,768 - 241% 241% (19,783) 13,985 [165] PROF & ADMIN 56,950 56,670 40,608 9,729 89% 72% 6,333 56,670 [166] OTHER OPERATING 2,300 6,384 4,083 1,837 93% 64% 464 6,384 [167] UTILITIES 10,000 2,513 1,905 - 76% 76% 608 2,513 [168] EQPT & CONTRACT SVCS - 3,683 3,682 1 100% 100% - 3,683 [169] OPER XFERS OUT 429,887 429,887 - - 0% 0% 429,887 429,887 EXPENDITURE 535,198 539,532 143,850 11,567 29% 27% 384,115 539,532 NET (SURPLUS)DEFICIT - (16,463) (16,463) BEGINNING BALANCE: 7/1/23 (1,176,588) (1,176,588) (1,176,588) ESTIMATED ENDING BALANCE: 6/30/24 (1,176,588) (1,160,125) (1,160,125) NOTES
[164, 165] The payroll charges for RHA are directly charged to fund. After receiving a Timesheet from RHA staff, the charges are then allocated to the appropriate funds. The negative contra transaction is in Fund 4501.
[166] Encumbered audit services from Maze & Associates
[167] Encumbrance for rental of a truck
[168] Paid Pacific Bell telephone expenses
[169] Encumbered contract for pest control from Happy Pest Control, Inc. [161] Revenues from sale of properties is unpredictable [162] Benefit allocations for staff working on grants slightly higher than anticipated [163] Received rental income that was not budgeted

Attachment 1 - FY2023-24 Q3 Budget Review
FUNDS
FY2023-24

ORIGINAL
BUDGET
FY2023-24

REVISED
BUDGET

ACTUALS
THRU
MARCH 2024
ENCUMB
W/
ENCUMB
% USED

W/O ENCUMB
% USED

AVAILABLE
BUDGET
FY2023-24

YEAR-END

PROJECTION
NOTES
4405 RHA-NYSTROM VILLAGE
USE OF MONEY&PROPRTY - - (31) - - - 31 - [170] OTHER REVENUE (6,200) (36,800) (24,890) - 68% 68% (11,910) (36,800) [171] RENTAL INCOME (250,000) (277,868) (209,159) - 75% 75% (68,709) (277,868) INTERGOV FED GRANT (499,194) (507,132) (337,973) - 67% 67% (169,159) (507,132) [172] OPER XFERS IN (915,101) (915,101) (279,080) - 30% 30% (636,021) (915,101) [173] REVENUE (1,670,495) (1,736,901) (851,133) - 49% 49% (885,768) (1,736,901) SALARIES AND WAGES 551,183 562,349 325,614 - 58% 58% 236,735 562,349 PYRLL/FRINGE BENEFIT 433,916 433,916 215,637 - 50% 50% 218,279 433,916 PROF & ADMIN 173,060 291,860 138,138 15,793 53% 47% 137,930 291,860 OTHER OPERATING 106,595 174,900 147,519 6,611 88% 84% 20,770 174,900 [174] UTILITIES 195,600 187,600 141,868 - 76% 76% 45,732 187,600 [175] EQPT & CONTRACT SVCS 143,440 164,135 68,547 23,534 56% 42% 72,054 164,135 PROVISN FOR INS LOSS 35,860 35,860 35,081 11 98% 98% 768 35,860 [176] COST POOL 30,841 62,409 46,809 - 75% 75% 15,600 62,409 EXPENDITURE 1,670,495 1,913,029 1,119,213 45,948 61% 59% 747,867 1,913,029 NET (SURPLUS)DEFICIT - 176,128 176,128 BEGINNING BALANCE: 7/1/23 (2,839,766) (2,839,766) (2,839,766) ESTIMATED ENDING BALANCE: 6/30/24 (2,839,766) (3,015,894) (3,015,894) 4406 RHA-RICHMOND VILLAGE ONE
INTERGOV FED GRANT (283,575) (237,830) (154,863) - 65% 65% (82,967) (237,830) [177] REVENUE (283,575) (237,830) (154,863) - 65% 65% (82,967) (237,830) SALARIES AND WAGES 7,473 7,473 - - 0% 0% 7,473 7,473 PYRLL/FRINGE BENEFIT 3,496 3,496 - - 0% 0% 3,496 3,496 OTHER OPERATING - 209 208 1 100% 100% 0 209 [178] GRANT EXPENDITURES 272,606 226,652 154,863 - 68% 68% 71,789 226,652 EXPENDITURE 283,575 237,830 155,071 1 65% 65% 82,758 237,830

NET (SURPLUS)DEFICIT - - - BEGINNING BALANCE: 7/1/23 453,524 453,524 453,524 ESTIMATED ENDING BALANCE: 6/30/24 453,524 453,524 453,524 4407 RHA-RICHMOND VILLAGE TWO
INTERGOV FED GRANT (167,190) (151,403) (91,304) - 60% 60% (60,099) (151,403) [179] REVENUE (167,190) (151,403) (91,304) - 60% 60% (60,099) (151,403) GRANT EXPENDITURES 167,190 151,403 91,304 - 60% 60% 60,099 151,403 EXPENDITURE 167,190 151,403 91,304 - 60% 60% 60,099 151,403

NET (SURPLUS)DEFICIT - - - BEGINNING BALANCE: 7/1/23 409,904 409,904 409,904 ESTIMATED ENDING BALANCE: 6/30/24 409,904 409,904 409,904 NOTES
[178] Paid taxes to Contra Costa County Tax Collector
[172, 177, 179] Reimbursements are based on expenses that have occurred [173] The quarterly transfers in have not been completed yet [174] Paid for small tools and building maintenance supplies [176] Paid RHA property insurance
[170] Interest Income from money in the bank account
[171] Received more tenants repayments than anticipated [175] Sewer charges slightly higher than anticipated

Attachment 1 - FY2023-24 Q3 Budget Review
FUNDS
FY2023-24

ORIGINAL
BUDGET
FY2023-24

REVISED
BUDGET

ACTUALS
THRU
MARCH 2024
ENCUMB
W/
ENCUMB
% USED

W/O ENCUMB
% USED

AVAILABLE
BUDGET
FY2023-24

YEAR-END

PROJECTION
NOTES
4408 RHA-RICHMOND VILLAGE THREE
INTERGOV FED GRANT (150,234) (106,096) (82,044) - 77% 77% (24,052) (106,096) [180] REVENUE (150,234) (106,096) (82,044) - 77% 77% (24,052) (106,096) GRANT EXPENDITURES 150,234 106,096 82,044 - 77% 77% 24,052 106,096 [181] EXPENDITURE 150,234 106,096 82,044 - 77% 77% 24,052 106,096

NET (SURPLUS)DEFICIT - - - BEGINNING BALANCE: 7/1/23 8,780 8,780 8,780 ESTIMATED ENDING BALANCE: 6/30/24 8,780 8,780 8,780 4501 RHA-CENTRAL OFFICE COST CNTR
LICENSES,PRMITS&FEES - - (25,000) - - - 25,000 - USE OF MONEY&PROPRTY - - (9) - - - 9 - [182] OPER XFERS IN (1,241,263) (1,241,263) (111,632) - 9% 9% (1,129,631) (1,241,263) [183] REVENUE (1,241,263) (1,241,263) (136,641) - 11% 11% (1,104,622) (1,241,263) SALARIES AND WAGES 22,075 22,075 126,531 - 573% 573% (104,456) 22,075 [184] PYRLL/FRINGE BENEFIT 64,453 64,453 86,609 - 134% 134% (22,156) 64,453 [185] PROF & ADMIN 1,138,820 1,138,820 - - 0% 0% 1,138,820 1,138,820 OTHER OPERATING - - 1,856 - - - (1,856) - [186] UTILITIES - - 6,507 - - - (6,507) - [187] COST POOL 15,915 60,788 45,581 - 75% 75% 15,207 60,788 EXPENDITURE 1,241,263 1,286,136 267,085 - 21% 21% 1,019,051 1,286,136 NET (SURPLUS)DEFICIT - 44,873 44,873 BEGINNING BALANCE: 7/1/23 (8,105,053) (8,105,053) (8,105,053) ESTIMATED ENDING BALANCE: 6/30/24 (8,105,053) (8,149,926) (8,149,926) 4502 RHA-HOUSING CORPORATION
LICENSES,PRMITS&FEES - (5,000) (5,000) - 100% 100% - (5,000) REVENUE - (5,000) (5,000) - 100% 0% - (5,000) PROF & ADMIN 7,050 14,050 7,010 - 50% 50% 7,040 14,050 EXPENDITURE 7,050 14,050 7,010 - 50% 50% 7,040 14,050 NET (SURPLUS)DEFICIT 7,050 9,050 9,050 BEGINNING BALANCE: 7/1/23 14,571,030 14,571,030 14,571,030 ESTIMATED ENDING BALANCE: 6/30/24 14,563,980 14,561,980 14,561,980 NOTES
[180] Reimbursements are based on expenses that have occurred [181] Completed some of the operations and subsidy payments [182] Interest Income from money in the bank account
[183] The quarterly transfers in have not been completed yet [184, 185] The payroll charges for RHA are directly charged to fund. After receiving a Timesheet from RHA staff, the charges are then allocated to the appropriate funds. The negative contra transaction is in Fund 4501.
[186] A budget transfer will be completed to cover the office supplies and postage [187] Will complete a budget transfer to cover the Verizon Wireless charges

Attachment 1 - FY2023-24 Q3 Budget Review
FUNDS
FY2023-24

ORIGINAL
BUDGET
FY2023-24

REVISED
BUDGET

ACTUALS
THRU
MARCH 2024
ENCUMB
W/
ENCUMB
% USED

W/O ENCUMB
% USED

AVAILABLE
BUDGET
FY2023-24

YEAR-END

PROJECTION
NOTES
5001 INSURANCE RESERVES
USE OF MONEY&PROPRTY - - (1,410,877) - - - 1,410,877 - [188] CHARGES FOR SERVICES (22,227,589) (22,227,589) (16,098,614) - 72% 72% (6,128,975) (22,227,589) [189] OTHER REVENUE - - (280,380) - - - 280,380 - [190] INTERGOV STATE GRANT - - (1,291,465) - - - 1,291,465 - [191] REVENUE (22,227,589) (22,227,589) (19,081,336) - 86% 86% (3,146,253) (22,227,589) SALARIES AND WAGES 506,482 506,482 425,694 - 84% 84% 80,788 506,482 [192] PYRLL/FRINGE BENEFIT 317,505 317,505 197,003 - 62% 62% 120,502 317,505 PROF & ADMIN 1,152,200 1,117,652 584,235 162,915 67% 52% 370,502 1,117,652 OTHER OPERATING 50,500 50,500 7,693 - 15% 15% 42,807 50,500 PROVISN FOR INS LOSS 21,850,182 21,850,182 12,099,040 1,394,832 62% 55% 8,356,309 21,850,182 COST POOL 619,218 619,218 464,412 - 75% 75% 154,806 619,218 ASSET/CAPITAL OUTLAY 7,000 1,590,701 1,234,911 345,594 99% 78% 10,196 1,590,701 [193] OPER XFERS OUT - 1,040,000 - - 0% 0% 1,040,000 1,040,000 EXPENDITURE 24,503,087 27,092,240 15,012,989 1,903,341 62% 55% 10,175,910 27,092,240 NET (SURPLUS)DEFICIT 2,275,498 4,864,651 4,864,651 BEGINNING BALANCE: 7/1/23 1,881,944 1,881,944 1,881,944 ESTIMATED ENDING BALANCE: 6/30/24 (393,554) (2,982,708) (2,982,708) 5003 EQUIPMENT SERVICES
USE OF MONEY&PROPRTY - - (150,819) - - - 150,819 - [194] CHARGES FOR SERVICES (5,665,733) (5,665,733) (4,263,776) - 75% 75% (1,401,957) (5,665,733) PROC FR SLE PROP - - (137,020) - - - 137,020 - [195] OPER XFERS IN (426,018) (426,018) (319,515) - 75% 75% (106,503) (426,018) REVENUE (6,091,751) (6,091,751) (4,871,130) - 80% 80% (1,220,621) (6,091,751) EQPT & CONTRACT SVCS 155,000 155,000 - - 0% 0% 155,000 155,000 ASSET/CAPITAL OUTLAY 9,215,733 12,580,182 6,968,519 4,638,971 92% 55% 972,692 12,580,182 [196] DEBT SVC EXPENDITURE 326,018 326,018 244,514 - 75% 75% 81,505 326,018 [197] EXPENDITURE 9,696,751 13,061,200 7,213,033 4,638,971 91% 55% 1,209,197 13,061,200 NET (SURPLUS)DEFICIT 3,605,000 6,969,449 6,969,449 BEGINNING BALANCE: 7/1/23 11,110,056 11,110,056 11,110,056 ESTIMATED ENDING BALANCE: 6/30/24 7,505,056 4,140,607 4,140,607 NOTES
[188, 194] Interest Income from money in the bank account [189] Charges for services revenues slightly below budgeted threshold [190] Received reimbursements from Prism, Westport Insurance, and other insurance companies [191] Received funds from preliminary recovery for FEMA [192] Part-time salaries were not budgeted
[193] Encumbered expenses related to BTA fire rehabilitation [195] Revenue from auctioning equipment
[196] Encumbered expenses for purchase of automobiles, buses, and SUV's [197] Paid half of the Holman Capital #5 debt service principal and interest

Attachment 1 - FY2023-24 Q3 Budget Review
FUNDS
FY2023-24

ORIGINAL
BUDGET
FY2023-24

REVISED
BUDGET

ACTUALS
THRU
MARCH 2024
ENCUMB
W/
ENCUMB
% USED

W/O ENCUMB
% USED

AVAILABLE
BUDGET
FY2023-24

YEAR-END

PROJECTION
NOTES
5008 COMPENSATED ABSENCES
OTHER REVENUE (2,600,000) (2,600,000) (1,950,001) - 75% 75% (649,999) (2,600,000) REVENUE (2,600,000) (2,600,000) (1,950,001) - 75% 75% (649,999) (2,600,000) SALARIES AND WAGES 2,600,000 2,600,000 1,481,138 - 57% 57% 1,118,862 2,600,000 PYRLL/FRINGE BENEFIT - - 22,861 - - - (22,861) - [198] EXPENDITURE 2,600,000 2,600,000 1,504,000 - 58% 58% 1,096,000 2,600,000

NET (SURPLUS)DEFICIT - - - BEGINNING BALANCE: 7/1/23 1,240,892 1,240,892 1,240,892 ESTIMATED ENDING BALANCE: 6/30/24 1,240,892 1,240,892 1,240,892 NON GF - REVENUE (229,526,702) (304,721,348) (142,924,668) - 47% 47% (161,796,680) NON GF - EXPENDITURE 330,166,006 455,140,613 146,736,022 53,908,607 44% 32% 254,495,983 NON GF - GRAND TOTAL 100,639,303 150,419,265 3,811,354 53,908,607 38% 3% 92,699,303 NOTES
[198] Medicare Tax employee portion is not budgeted