Revenue Detail by Fund
Third Quarter
Fiscal Year 2021-22
Attachment 1
Actual
Actual
Actual
Adopted
Budget
Q3
July-Mar
Description 2018-19 2019-20 2020-21 2021-22 2021-22
GENERAL FUND - 10
4010 Property Tax - CY Secured 28,504,738 30,178,732 32,927,960 31,522,608 20,981,993 4011 Property Tax - PY Secured 142,834 157,620 191,071 166,414 212,898 4012 Penalties/Delinquencies - PY 38,280 37,433 71,366 43,000 36,652 4015 Supplemental Roll 828,251 566,925 586,637 479,980 290,684 4020 Property Tax - CY Unsecured 861,447 828,336 862,152 830,685 749,009 4021 Prop Tax Collection Fees (173,018) (176,435) (197,269) (200,000) - 4030 Homeowners Subvention 141,035 90,197 138,397 143,000 66,387 4033 Property Tax In-Lieu 13,782,934 14,502,620 15,494,541 15,959,377 7,805,977 Total Property Taxes 44,126,501 46,185,429 50,074,855 48,945,064 30,143,599 4110 Sales & Use Ta x 23,411,301 22,111,203 24,569,589 23,623,613 16,621,203 4112 Prop 172 1,026,604 983,317 1,001,790 1,000,000 841,420 4130 Transient Occupancy Ta x 3,328,337 2,377,697 1,285,299 1,250,000 1,717,532 4131 Short Term Rentals TOT - - 44,825 - 115,794 4150 Business Registration 1,162,887 1,159,258 1,089,393 1,160,000 878,090 4151 Oil Extraction Taxes 13,457 6,386 6,909 10,000 - 4170 Real Estate Transfer Ta x 753,800 741,174 930,576 725,000 795,376 Total Other Taxes 29,696,386 27,379,035 28,928,382 27,768,613 20,969,415 4220 Development Permits 1,329,936 1,260,989 1,454,251 1,310,914 1,484,614 4223 Building Permit Surcharge 519,696 24,803 26,434 - - 4225 Dep. Inspector Cert. Fee 2,508 2,451 2,280 5,000 2,715 4226 Parking Permit Fees 18,256 16,118 16,404 20,500 18,210 4228 Fireworks Permits 26,298 26,186 70,564 34,890 - 4260 Public Works Permits 147,374 109,649 112,653 130,000 52,602 4270 Police Alarm Permits 263,190 234,002 238,294 204,538 201,627 4280 Other Licenses & Permits 105,214 88,868 103,357 94,100 83,503 4282 Hazardous Mat Disclosures 271,336 272,955 271,508 275,000 2,125 4283 Underground Tank Permits 79,562 87,761 86,257 85,000 10,045 4284 Overload Permits 20,194 22,784 23,500 20,000 18,002 4285 Encroachment Permits - - - - 25,490 Total Licenses & Permits 2,783,564 2,146,566 2,405,501 2,179,942 1,898,932 4330 Other Court Fines - Fund 10 1,244,927 994,818 847,839 1,000,000 1,033,892 4360 Administrative Citation 115,676 12,240 20,820 24,000 41,280 Total Fines & Penalties 1,360,603 1,007,058 868,659 1,024,000 1,075,172 4410 Interest Income 755,625 438,429 160,090 361,230 (13,680) 4412 Unrealized Gain/Loss on Invest 1,308,618 (23,025) (507,435) - (63,854) 4413 Supplemental Interest 282,045 458,834 399,062 238,835 - 4417 Property Lease 1,192,767 1,230,378 1,241,563 1,237,563 928,172 4418 Cell Tower Rent 18,076 11,478 6,473 251,000 290,434 4420 Rents 932,914 511,789 376,909 699,000 406,480 4421 Parks & Rec Facility Rent - - - - 1,800 4424 Vista Park Lease - - - 400,000 354,968 4429 Fire Dept Lease 41,133 42,531 43,847 45,000 - 4440 General Concessions 75,787 75,787 75,787 75,787 37,894 4441 R-O-W Impact Fee 387,260 387,260 383,260 383,260 287,445 4445 Prisoners Welfare 15,432 405 - 1,000 - 4460 Franchise Fees 4,312,703 4,145,175 4,181,577 4,300,000 2,036,656 4466 Franchise - Cable PEG Support 180,697 0 - - - Total Use of Money & Property 9,503,057 7,279,042 6,361,133 7,992,675 4,266,314
Revenue Detail by Fund
Third Quarter
Fiscal Year 2021-22
Attachment 1
Actual
Actual
Actual
Adopted
Budget
Q3
July-Mar
Description 2018-19 2019-20 2020-21 2021-22 2021-22
GENERAL FUND - 10
4512 MVL In-Lieu Ta x 69,224 113,039 104,047 100,000 161,078 4527 POST 13,643 73,531 15,798 30,000 16,370 4528 State Mandated Cost Reimb 155,088 79,418 133,158 100,000 (3,770) 4569 Federal Grants - 1,000
4570 Federal Dept. of Justice 794 - - - - 4580 Other Agency Contributions 756,409 501,599 1,329,070 301,000 924,387 4581 Parks Maint - School Dist 69,670 117,887 181,608 175,000 46,655 Total Other Agencies 1,064,828 885,474 1,763,681 706,000 1,145,721 4600 Planning Fees 239,430 438,586 422,115 406,000 383,179 4608 Seismic Fees - 604 638 - 789 4611 Microfilming Fees 27,823 25,069 32,476 20,000 24,612 4612 Sale of Maps & Publications 3,053 4,051 5,565 3,000 11,571 4613 Misc Filing/Cert Fees 5,639 - 4,514 - - 4614 Plan Check Fees 770,104 813,440 765,116 728,174 1,611,240 4617 Weed and Lot Cleaning 4 - - - - 4618 Refuse Services 904,099 615,177 972,402 857,405 652,398 4619 CRV 235,164 256,081 210,117 257,184 213,799 4621 San. District Connection 54,187 7,660 5,769 10,000 2,823 4627 SB1473 Collection Fees 368 86 566 400 428 4628 Plan Check Premium In-House 360 2,592 90 - 4,731 4632 Inspection Premium In-House 6,220 7,088 8,021 3,500 4,131 4633 Business License Review 31,005 26,509 15,136 14,000 16,596 4640 Misc Fire Fees 265,649 358,874 345,524 378,399 260,845 4641 Paramedic Fees for Service 121,963 14,860 5,750 - - 4643 Paramedic Subscription - Res. 681,370 705,055 695,912 700,000 (137,309) 4644 Ambulance Billing 2,742,475 4,150,036 3,520,400 4,126,818 2,813,663 4645 Paramedic Subscription - Bus. 4,853 4,518 3,408 5,000 36,174 4647 Fire Dept - New business 11,433 9,713 10,210 10,000 15,807 4648 Fire Bldg Plan Ck/Inspection 43,392 25,619 21,247 50,000 16,450 4649 Advanced Life Support 58,096 4,116 - - - 4676 Vehicle Charging Station Fees 6,388 5,833 3,909 6,600 5,330 4680 Parking Fees - 167,901 73,522 175,000 110,977 4681 Documentation Assistance Fees - - - - 15 4710 Misc Check Fees 6,035 7,338 3,046 - 4,268 4714 Witness Fees 7,520 6,340 4,460 8,200 1,405 4719 Inspection Prem - Outside Svc 1,531 1,865 270 2,000 6,587 4721 Construction Mgt Reimb - - 10,181 - - 4729 Police - Pay to Sta y 5,967 - - 30,000 - 4730 Misc Police 1,383,559 989,995 1,123,378 1,396,257 437,711 4731 Public Works Fees 161,477 440,941 526,091 339,700 295,701 4737 Damage Repair 106,959 44,696 134,719 20,000 45,252 4799 Misc. Fees - - 168 - - Total Charges for Service 7,886,123 9,134,640 8,924,720 9,547,637 6,839,172 4810 Sale of Propert y 2,411,313 370,249 23,049 10,000 11,967 4815 Donations 548,068 6,734 287,298 293,044 297,123 4812 Indirect Admin Cost - - - - - 4822 Misc Reimbursements/Rebates 21,755 28,072 22,191 15,000 16,777 4830 Miscellaneous 18,079 309,247 105,128 810,000 113,134 4834 Contributed Asset fr Developer - - - - 750,000 Total Other Revenue 2,999,215 714,302 437,666 1,128,044 1,189,001 Total General Fund 99,420,277 $ 94,731,545 $ 99,764,596 $ 99,291,975 $ 67,527,325 $
Revenue Detail by Fund
Third Quarter
Fiscal Year 2021-22
Attachment 1
Actual
Actual
Actual
Adopted
Budget
Q3
July-Mar
Description 2018-19 2019-20 2020-21 2021-22 2021-22
LIBRARY FUND - 13
4010 Property Tax - CY Secured 77,620 72,718 74,837 80,598 49,223 4350 Library Fines 54,457 38,246 2,316 10,000 3,051 4351 Interlibrary Loan Postage 107 43 - 100 49 4420 Rents 22,294 18,810 - 20,000 8,295 4425 Hunt Library Rent 18,000 18,000 1,500 - - 4529 State Grants 7,479 7,940 - 40,000 12,697 4569 Federal Grants 14,864 - - - - 4657 Passport Execution Fee 239,251 141,255 - 125,000 - 4658 Passport Photo Fee 45,090 28,257 10 28,000 - 4815 Donations 3,945 5,730 4,602 600 5,707 4830 Miscellaneous Revenue 18,524 492 89,646 - 17,194 4870 Restricted Contributions 52,467 (21,260) 76,164 60,000 92,892 Total Library Fund 554,098 $ 310,230 $ 249,075 $ 364,298 $ 189,107 $ PARKS & RECREATION FUND - 15
4418 Cell Tower Rent 223,160 231,687 274,240 - - 4419 Park Property Lease 105,852 105,852 105,852 105,852 79,389 4420 Rents 197,199 159,951 92,603 152,000 102,505 4421 Facility Rental 574,830 360,690 (50,978) 271,500 363,711 4424 Vista Park Restaurant Lease 499,462 477,340 335,205 - - 4438 Field Use Charges 40,108 49,800 149,405 95,325 95,254 4440 General Concessions 21,564 16,866 1 13,500 4,081 4685 Parks & Recreation Fees 823,708 425,535 239,579 505,135 245,740 4815 Donations 410,000 83,763 74,535 80,000 78,000 4830 Miscellaneous 32,065 31,219 6,345 28,800 15,374 4831 Museum Center 35,511 21,427 1,817 - - Total Parks & Recreation Fund 2,963,459$ 1,964,129 $ 1,228,603 $ 1,252,112 $ 984,053 $ TOTAL GENERAL OPERATING FUNDS 102,937,834$ 97,005,904 $ 101,242,275 $ 100,908,385 $ 68,700,485 $ INFRASTRUCTURE FUND - 11
4410 Interest Income - - - - 73 Total Infrastructure Fund - $ - $ - $ - $ 73$ WEST COYOTE HILLS ENDOWMENT - 20
4410 Interest Income - - - - (60) 4815 Donations - - - - 103,038 -$ - $ - $ - $ 102,978$ AIR QUALITY IMPROVEMENT FUND - 22
4410 Interest Income 9,419 17,429 13,231 15,600 2,979 4412 Unrealized Gain/Loss on Invest 10,635 4,655 (8,704) - (1,588) 4517 Motor Vehicle Air Quality Fees 180,881 181,139 185,242 181,000 88,010 4580 Other Agency Contributions 27,897 - - - - Total Air Quality Fund 228,832 $ 203,223 $ 189,769 $ 196,600 $ 89,401 $
Revenue Detail by Fund
Third Quarter
Fiscal Year 2021-22
Attachment 1
Actual
Actual
Actual
Adopted
Budget
Q3
July-Mar
Description 2018-19 2019-20 2020-21 2021-22 2021-22
SANITATION FUND - 23
4410 Interest Income - 55,223 31,412 58,136 3,483 4412 Unrealized Gain/Loss on Invest - 28,562 (24,668) - (3,894) 4620 Sanitation Fees 5,590,017 5,647,470 5,781,554 6,400,000 4,180,128 4737 Damage Repair - 4,605 5,384.23 - 4,504 Total Sanitation Fund 5,590,017 $ 5,735,859 $ 5,793,682 $ 6,458,136 $ 4,184,222 $ MEASURE M2 FUND - 25
4410 Interest Income 33,334 85,483 70,641 72,925 11,811 4412 Unrealized Gain/Loss on Invest 40,818 16,736 (29,266) - (4,574) 4546 Measure M2 2,469,923 2,447,087 2,357,163 2,470,502 2,211,265 Total Measure M2 Fund 2,544,075 $ 2,549,307 $ 2,398,538 $ 2,543,427 $ 2,218,502 $ HOUSING FUND - 26
4410 Interest Income 272,688 298,771 271,429 244,756 4,031 4412 Unrealized Gain/Loss on Invest 25,695 14,046 (23,100) - (2,203) 4680 Parking Fees - 1,800 - - - 4830 Miscellaneous 9,500 4,750 4,750 - 5,400 4843 Loan Repayment 230,698 318,172 295,452 150,000 227,215 4998 Allocation to Notes Receivable (230,698) (318,172) (295,452) (150,000) (227,215) Total Housing Fund 307,883 $ 319,367 $ 253,079 $ 244,756 $ 7,228 $ FTV CABLE-PEG ACCESS FUND - 27
4410 Interest Income - 4,586 13,178 16,015 2,880 4412 Unrealized Gain/Loss on Invest - 11,578 (10,051) - (1,527) 4466 Franchise - Cable PEG Support - 213,244 200,407 200,000 99,002 FTV Cable-PEG Access Fund - $ 229,408$ 203,535 $ 216,015 $ 100,354 $ SB2/PLHA FUND - 28
4410 Interest Income - - 308 - 625 4412 Unrealized Gain/Loss on Invest - - 360 - (360) 4529 State Grant - - 688,452 - - Total SB2/PHLA Fund - $ - $ 689,120$ - $ 265 $ SB1/RMRA FUND - 29
4410 Interest Income 17,924 67,380 94,480 51,135 15,764 4412 Unrealized Gain/Loss on Invest 17,208 20,367 (24,324) - (5,719) 4515 Gas Tax SB1/RMR A 2,644,625 2,473,694 2,407,050 2,791,451 1,837,473 Total SB1/RMRA Fund 2,679,757 $ 2,561,441 $ 2,477,205 $ 2,842,586 $ 1,847,518 $ GAS TAX FUND - 30
4410 Interest Income 49,429 80,427 53,636 61,020 8,609 4412 Unrealized Gain/Loss on Invest 48,559 12,135 (26,975) - (3,327) 4513 Gas Tax - 2106 522,601 454,950 455,270 500,495 321,797 4514 Gas Tax - 2103 481,782 984,824 977,424 1,261,694 749,624 4518 Gas Tax - 2107 1,005,081 929,942 1,013,126 1,056,218 570,418 4535 Gas Tax - 2105 791,248 728,557 739,322 822,125 512,061 4737 Damage Repair - 15,945 14,644 - 54,683 4830 Miscellaneous 173,797 160,566 - - - Total Gas Tax Fund 3,072,497 $ 3,367,347 $ 3,226,447 $ 3,701,552 $ 2,213,865 $
Revenue Detail by Fund
Third Quarter
Fiscal Year 2021-22
Attachment 1
Actual
Actual
Actual
Adopted
Budget
Q3
July-Mar
Description 2018-19 2019-20 2020-21 2021-22 2021-22
GRANTS FUND - 32
4410 Interest Income - - - - - 4529 State Grants 1,028,931 153,341 105,798 35,000 4,437,512 4543 County Grants - - - - - 4563 Older Americans Act Grant 80,174 43,763 151,903 109,863 50,871 4567 Program Income 189,711 53,402 26,297 - 16,872 4568 HOME Grant 262,550 44,780 86,985 539,238 35,577 4569 Federal Grants 81,394 1,604,702 4,049,773 - 437,105 4580 Other Agency Contributions 361,830 633,696 671,214 342,973 239,038 4685 Park & Rcereation Fees - - - - - 4814 HOME DAP Repayment - - - 40,000 107,732 4822 Misc. Reimbursements/Rebates - - - - 84 4843 Loan Repayment/Rehab - - - - 108,337 Total Grants Fund 2,004,590 $ 2,533,683 $ 5,091,969$ 1,067,074$ 5,433,127 $ SLES FUND - 33
4529 State Grants 311,023 339,208 338,298 210,000 299,172 Total SLES Fund 311,023 $ 339,208 $ 338,298 $ 210,000 $ 299,172 $ ASSET SEIZURE FUND - 34
4410 Interest Income 8,258 19,732 6,964 10,679 1,301 4412 Unrealized Gain/Loss on Invest 9,118 1,917 (7,456) - (587) 4569 Federal Grants 12,820 3,010 - 15,000 - 4570 Federal Dept of Justice 542,722 237,097 376,717 100,000 296,761 4580 Other Agenc y - - - - 24,060 4730 Miscellaneous 5,990 7,284 98,244 - 5,444 Total Asset Seizure Fund 578,908 $ 269,041 $ 474,468 $ 125,679 $ 326,980 $ CDBG FUND - 35
4562 CDBG 1,115,968 1,783,689 1,372,023 1,345,723 1,633,330 4567 Grant - Program Income - - - - 7,869 4830 Miscellaneous 40,463 57,662 707 - 22,485 Total CDBG Fund 1,156,431 $ 1,841,351 $ 1,372,730 $ 1,345,723 $ 1,663,684 $ DRAINAGE CAPITAL OUTLAY FUND - 36
4410 Interest Income - 123,856 87,300 93,795 20,385 4412 Unrealized Gain/Loss on Invest - 57,309 (49,660) - (7,649) 4620 Sanitation Fees 2,175,490 2,196,313 2,248,382 1,600,000 953,499 Total Drainage Cap Outlay Fund 2,175,490$ 2,377,478 $ 2,286,022 $ 1,693,795 $ 966,236 $ TRAFFIC SAFETY FUND - 37
4310 Motor Vehicle Fines 243,262 193,500 143,492 200,000 82,930 Total Traffic Safety Fund 243,262 $ 193,500 $ 143,492 $ 200,000 $ 82,930 $ ARPA FUND - 38
4410 Interest Income - - 31,867 - 51,040 4412 Unrealized Gain/Loss on Invest - - 29,411 - (29,411) 4569 Federal Grant - - - - 16,332,651 Total ARPA Fund - $ - $ 61,277$ - $ 16,354,280$
Revenue Detail by Fund
Third Quarter
Fiscal Year 2021-22
Attachment 1
Actual
Actual
Actual
Adopted
Budget
Q3
July-Mar
Description 2018-19 2019-20 2020-21 2021-22 2021-22
PARK DWELLING FUND - 39
4410 Interest Income - 127,041 73,527 94,928 9,058 4412 Unrealized Gain/Loss on Invest - 49,878 (46,983) - (2,895) 4684 Park Dwelling Fees 3,858,420 472,420 688,780 1,241,700 232,020 Total Park Dwelling Fund 3,858,420 $ 649,339 $ 715,323 $ 1,336,628$ 238,184 $ AIRPORT FUND - 40
4060 Aircraft Taxes 87,046 106,514 87,697 100,000 110,411 4226 Parking Permits 880 960 500 1,250 360 4410 Interest Income - 55,108 33,375 35,448 6,948 4412 Unrealized Gain/Loss on Invest - 26,671 (22,762) - (3,909) 4420 Rents 75,352 69,107 56,831 72,000 32,856 4430 Fixed-Base Operators 566,755 549,212 529,970 525,000 415,612 4431 Hangar Admin Fee 3,750 1,800 5,600 4,000 6,988 4432 Hangar Rental 1,127,551 1,106,382 1,100,610 1,200,000 934,722 4433 Fuel Flowage Fee 47,457 49,856 39,767 42,000 38,747 4434 Tie-Downs 47,878 64,935 65,031 46,000 74,667 4436 Visitor Aircraft Parking 3,876 5,016 17,920 5,000 4,254 4438 Field Usage Charges 5,675 2,132 1,574 1,700 1,325 4440 General Concessions 15 20 - 300 62 4569 Federal Grants - - 257,779 - 592,500 4720 Airport Fees 4,400 - 4,400 4,400 5,685 4840 Bond Proceeds - - - - - 4830 Miscellaneous 6,205 5,584 1,785 6,000 2,485 Total Airport Fund 1,976,840 $ 2,043,298 $ 2,180,077 $ 2,043,098 $ 2,223,713 $ COMPRESSED NATURAL GAS (CNG) - 41
4410 Interest Income - 6,386 3,487 - 605 4412 Unrealized Gain/Loss on Invest - 3,654 (3,236) - (418) 4420 Rents - - 126 - - 4674 CNG Sales 221,644 189,971 169,979 160,000 127,878 Total CNG Fund 221,644 $ 200,010 $ 170,356 $ 160,000 $ 128,065 $ BREA DAM RECREATIONAL FUND - 42
4410 Interest Income 4,146 (10,051) (18) - 4,069 4412 Unrealized Gain/Loss on Invest 2,888 (4,251) 7,640 - (1,051) 4418 Cell Tower Rent 30,193 30,193 30,910 32,000 24,493 4419 Park Property Lease 23,271 23,975 18,624 24,000 18,654 4420 Rents 2,000 2,000 2,000 - - 4421 Facility Rentals 39,443 34,203 72,971 39,600 29,572 4438 Field Use Charges 148,283 126,131 175,182 32,000 154,313 4440 General Concessions 5,307 3,549 1,366 - 316 4680 Parking Fees 76,249 151,762 - 80,000 - 4686 Golf Fees 1,930,767 1,853,014 3,302,334 2,030,000 2,539,717 4694 Brea Dam Fees 255,057 223,294 354,536 11,960 257,080 4815 Donations - - - - 13,950 4830 Miscellaneous - - - - 206 Total Brea Dam Fund 2,517,604 $ 2,433,819 $ 3,965,543 $ 2,249,560 $ 3,041,319 $
Revenue Detail by Fund
Third Quarter
Fiscal Year 2021-22
Attachment 1
Actual
Actual
Actual
Adopted
Budget
Q3
July-Mar
Description 2018-19 2019-20 2020-21 2021-22 2021-22
WATER FUND - 44
4260 Public Works Permits 40,112 56,021 25,253 40,000 28,262 4280 Other Licenses & Permits - - - - - 4281 Temp Water Permits 4,829 4,862 6,178 5,000 4,817 4410 Interest Income 39 692,760 497,789 496,508 113,294 4412 Unrealized Gain/Loss on Invest 2,888 417,861 (354,349) - (63,512) 4418 Cell Tower Rent 315,442 302,455 291,726 320,000 216,046 4442 Undergound Locating Svc Impact - - - - 202,500 4529 State Grants - - 689,077 (689,077) 4569 Federal Grants - - 290,000 150,418 4612 Sale of Maps & Publications 2,507 1,886 2,665 3,000 1,311 4614 Plan Check Fees 28,638 31,357 35,122 35,000 32,953 4660 Water Sales 31,384,774 35,930,943 42,483,959 46,500,000 30,134,021 4661 Temp Water Sales 19,002 36,176 41,604 40,000 158,943 4662 Municipal Water Sales 7,927 794,105 1,003,854 1,000,000 825,003 4664 Front Footage Charges 31,197 4,275 17,089 - - 4665 Net Zero Water Impact Fee - - - - 4666 Customer Service Charges 245,935 177,181 111,049 240,000 76,987 4668 Water Delinquent Charges 602,572 404,375 591,484 600,000 894,591 4670 Water System Reimb - Devel. 7,515 5,462 18,394 - 8,772 4671 Construction Mgmt Reimb 3,465 2,618 - 5,000 - 4672 Water System Mod. Fees 13,234 19,574 9,139 15,000 9,923 4673 Water Cross-Connection Inspec 1,101 7,325 1,167 25,000 4,528 4710 Miscellaneous Fees & Charges 4,808 5,265 4,112 - 5,800 4734 Water Maintenance Charges - 925 1,351 - 965 4737 Damage Repair - 1,685 47,183 - 28,698 4810 Sale of Propert y 14,221 19,512 95,415 15,000 20,695 4830 Miscellaneous 48,259 45,593 75,334 50,000 15,799 4834 Contributed Assets 184,840 567,355 65,125 - - 4842 Premium on Bond Sales 38,615 38,615 38,615 38,615 38,615 Total Water Fund 33,001,920 $ 39,568,185 $ 46,088,334 $ 49,428,123 $ 32,220,352 $ WHITING-LEMON PARKING FUND - 45
4410 Interest Income - (1,358) (1,527) - (611) 4680 Parking Fees 12,264 7,677 - 10,000 230 Total Whiting-Lemon Parking Fund 12,264$ 6,319 $ (1,527)$ 10,000 $ (381) $ REFUSE COLLECTION FUND - 46
4410 Interest Income - 32,453 17,788 - 2,981 4412 Unrealized Gain/Loss on Invest - 11,801 (10,047) - (1,755) 4618 Refuse Collection 11,238,869 11,624,005 12,665,043 12,466,917 8,486,675 4626 AB939 Fees-Recycling Surcharge 422,031 435,104 441,753 360,000 291,489 4830 Miscellaneous - - 27,500 - - Total Refuse Fund 11,660,900 $ 12,103,363 $ 13,142,038 $ 12,826,917 $ 8,779,391 $ SEWER ENTERPRISE FUND - 47
4251 Wastewater Discharge Permit 37,480 35,500 36,200 40,000 36,200 4410 Interest Income - 250,345 148,721 187,650 27,780 4412 Unrealized Gain/Loss on Invest - 136,322 (120,452) - (15,869) 4677 Sewer Service Fee 6,006,471 5,908,356 6,168,819 6,100,000 3,945,319 4830 Miscellaneous - - 7,023.84 - 30,319 Total Sewer Fund 6,043,951 $ 6,330,523 $ 6,240,311 $ 6,327,650 $ 4,023,749 $
Revenue Detail by Fund
Third Quarter
Fiscal Year 2021-22
Attachment 1
Actual
Actual
Actual
Adopted
Budget
Q3
July-Mar
Description 2018-19 2019-20 2020-21 2021-22 2021-22
LIABILITY INSURANCE FUND - 62
4410 Interest Income 276,738 649,230 369,674 55,187 4412 Unrealized Gain/Loss on Invest 390,815 179,039 (321,178) - (37,679) 4754 Interfund Insurance Premiums 5,928,999 5,959,115 6,355,060 7,346,020 5,511,347 4811 Prior Year Recoverable Cost 1,100 1,200 900 - 800 4830 Miscellaneous - - - - 2,449 4841 Bond Proceeds - - 5,010,000 - 4999 Revenue Allocation (5,928,989) (5,959,115) (11,365,060) (7,346,020) (5,511,347) Total Liability Ins Fund 668,663 $ 829,469 $ 49,396 $ - $ 20,757$ VEHICLE REPLACEMENT FUND - 64
4410 Interest Income 71,872 141,475 85,794 80,000 14,649 4412 Unrealized Gain/Loss on Invest 96,072 29,118 (65,939) - (8,140) 4420 Rents - 25,172 - - - 4756 Vehicle Replacement 1,498,160 1,408,560 1,636,296 2,822,624 2,117,041 4810 Sale of Propert y - 25,350 147,244 - 61,700 4830 Miscellaneous 39,319 - 35,000 - 15,070 4999 Revenue Allocation (1,498,160) (1,408,560) (1,636,296) (2,822,624) (2,117,041) Total Vehicle Replacement Fund 207,263$ 221,115 $ 202,099 $ 80,000 $ 83,278 $ WORKERS COMP FUND - 65
4410 Interest Income 273,871 656,588 418,100 - 86,213 4412 Unrealized Gain/Loss on Invest 383,358 192,603 (318,349) - (48,658) 4760 Workers Comp 4,176,031 4,276,274 4,520,937 4,489,046 3,322,075 4811 PY Recoverable Costs 1,618 - 1,795 - 661 4820 Worker Comp Benefit Reimb 126,500 172,106 234,727 - 210,136 4999 Revenue Allocation (4,176,031) (4,276,274) (4,520,937) (4,489,046) (3,322,075) Total Workers Comp Fund 785,347 $ 1,021,298$ 336,274 $ - $ 248,352$ GROUP INSURANCE FUND - 66
4410 Interest Income - 41,639 24,386 - 5,100 4412 Unrealized Gain/Loss on Invest - 27,384 (23,720) - (3,663) 4754 Insurance Premiums 7,763,864 7,696,373 7,495,483 8,689,606 5,293,124 4823 Cigna Wellness Contributions 20,000 748 76,489 - 53,961 4999 Revenue Allocation (7,763,864) (7,696,373) (7,495,483) (8,689,606) (5,293,124) Total Group Insurance Fund 20,000 $ 69,771 $ 77,156 $ - $ 55,397$ EQUIPMENT MAINTENANCE FUND - 67
4410 Interest Income - 143,119 83,182 - 16,120 4412 Unrealized Gain/Loss on Invest - 70,600 (61,185) - (9,415) 4737 Damage Repair 42,252 21,764 29,189 - 41,072 4755 Equipment Maint 3,099,663 2,980,783 3,143,732 3,309,654 2,217,946 4810 Sale of Propert y 17,674 198 305 - - 4830 Miscellaneous - - - - 520 4999 Revenue Allocation (3,099,663) (2,980,783) (3,143,732) (3,309,654) (2,217,946) Total Equipment Maint Fund 59,926 $ 235,680 $ 51,491 $ - $ 48,297$
Revenue Detail by Fund
Third Quarter
Fiscal Year 2021-22
Attachment 1
Actual
Actual
Actual
Adopted
Budget
Q3
July-Mar
Description 2018-19 2019-20 2020-21 2021-22 2021-22
INFORMATION TECHNOLOGY FUND - 68
4410 Interest Income - 25,924 40,688 - 5,511 4412 Unrealized Gain/Loss on Invest - 5,954 (2,538) - (3,416) 4757 Information Technolog y 3,028,203 3,131,522 2,958,310 6,507,928 4,337,708 4999 Revenue Allocation (3,028,203) (3,131,522) (2,958,310) (6,507,928) (4,337,708) Total Information Tech. Fund - $ 31,878$ 38,150 $ - $ 2,095$ BUILDING MAINTENANCE FUND - 69
4410 Interest Income - 23,311 18,824 - 4,569 4412 Unrealized Gain/Loss on Invest - 14,069 (11,451) - (2,618) 4758 Building Maintenance 2,487,412 2,652,787 2,750,643 2,765,130 2,076,757 4999 Revenue Allocation (2,487,412) (2,652,787) (2,750,643) (2,765,130) (2,076,757) Total Building Maint. Fund - $ 37,380$ 7,373 $ - $ 1,950$ FACILITY CAPITAL REPAIR FUND - 70
4410 Interest Income 24,568 54,572 43,138 10,000 8,555 4412 Unrealized Gain/Loss on Invest 31,129 13,834 (21,411) - (3,273) 4759 Facility Capital Repair 543,610 545,453 516,533 564,224 421,465 4815 Donations 3,202 88,880 - - - 4999 Revenue Allocation (543,610) (545,453) (516,533) (564,224) (421,465) Total Cap. Facility Repair Fund 58,899 $ 157,286 $ 21,728 $ 10,000 $ 5,282 $ CAPITAL PROJECTS FUND - 74
4410 Interest Income 3,419 516 - - - 4413 Supplemental Interest 176,824 - - - - 4529 State Grants 5,744,034 6,749,857 322,181 1,250,000 18,356,055 4545 Measure M Regional 240,752 1,409,535 5,035,292 100,000 216,741 4569 Federal Grants 1,298,197 13,546,069 - - - 4580 Other Agency Contributions 293,494 2,144,068 229,644 1,002,400 478,519 4582 Emergency Management Reimb - 20,374 41,004 - - 4609 Traffic Mitigation Fees 370,239 62,155 - - - 4631 Development Agreement Fees - - 21,528 350,000 363,857 4737 Damage Repair - - - - 3,753 4830 Miscellaneous 242,723 37,585 78,318 - 161,392 4840 Bond/Loan Proceeds - - - - 8,894,000 4999 Revenue Allocation - - - - (8,894,000) Total Capital Projects Fund 8,369,682 $ 23,970,159 $ 5,727,967 $ 2,702,400 $ 19,580,316$ SUCCESSOR AGENCY FUNDS - 80-89
4065 Taxes/ROPS 11,960,542 11,834,201 9,365,723 12,189,227 4,711,439 4410 Interest Income 861,427 831,424 801,791 25,000 358 4412 Unrealized Gain/Loss on Invest 261,381 136,223 (165,695) - (16,007) 4830 Miscellaneous - - - - 50 4840 Bond Proceeds 318,370 318,370 - 318,370 - 4842 Premium on Bond Sales - - 1,889,667 992,015 4843 Loan Repayment/Rehab&Seismic - - (1) - 58,361 4998 Allocation to Notes / Loans Receivable - - - - (58,361) Total Successor Agency Fund 13,421,557$ 13,120,219 $ 11,891,485 $ 12,532,597 $ 5,687,855 $ GRAND TOTAL REVENUES 206,715,479 $ 222,555,228 $ 217,145,480 $ 211,460,701 $ 180,979,270 $