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