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