CITY OF CAMARILLO
Fiscal Year 2023/24 Mid-Year Budget Review
Summary by Fund
"Exhibit B"
101
Revenues 55,378,949$ 24,767,470$ 44.7% 2,979,100$ 58,358,049$ Transfers In 2,025,810 875,310 43.2% 2,025,810 Total Revenue & Transfers In 57,404,759 25,642,780 44.7% 2,979,100 60,383,859 Expenditures 57,603,874 24,849,962 43.1% (6,477,267) 51,126,607 Transfers Out 4,763,614 391,050 8.2% 6,477,267 11,240,881 Total Expenditures & Transfers Out 62,367,488 25,241,012 40.5% - 62,367,488 Revenues Over/(Under) Expenditures (4,962,729) 401,768 2,979,100 (1,983,629) Fund Balance, July 1 85,124,897 - 85,124,897 Fund Balance, End of Period 80,162,168 401,768 2,979,100 83,141,268 207
Revenues - 600,073 0.0% 1,800,000 1,800,000 Transfers In - 271,621 0.0% - - Total Revenue & Transfers In - 871,694 0.0% 1,800,000 1,800,000 Expenditures - - 0.0% - - Transfers Out - - 0.0% 1,800,000 1,800,000 Total Expenditures & Transfers Out - - 0.0% 1,800,000 1,800,000 Revenues Over/(Under) Expenditures - 871,694 - - Fund Balance, July 1 - - - Fund Balance, End of Period - 871,694 - - 208
Revenues 1,713,133 607,956 35.5% 1,713,133 Expenditures - - 0.0% - - Transfers Out 2,996,300 1,831,495 61.1% - 2,996,300 Revenues Over/(Under) Expenditures (1,283,167) (1,223,539) - (1,283,167) Fund Balance, July 1 3,859,363 - 3,859,363 Fund Balance, End of Period 2,576,196 (1,223,539) - 2,576,196 209
Revenues 12,000 12,529 104.4% 12,000 Expenditures - - 0.0% - - Transfers Out 12,000 12,529 104.4% - 12,000 Revenues Over/(Under) Expenditures - - - - Fund Balance, July 1 - -
Fund Balance, End of Period - - - - 210 Gas Tax Fund
Revenues 2,026,412 1,018,999 50.3% - 2,026,412 Transfers In - - 0.0% - - Total Revenue & Transfers In 2,026,412 1,018,999 50.3% - 2,026,412 Expenditures - - 0.0% - - Transfers Out 2,025,810 875,310 43.2% - 2,025,810 Total Expenditures & Transfers Out 2,025,810 875,310 43.2% - 2,025,810 Revenues Over/(Under) Expenditures 602 143,689 - 602 Fund Balance, July 1 231,826 - 231,826 Fund Balance, End of Period 232,428 143,689 - 232,428 211
Revenues 1,760,518 725,393 41.2% - 1,760,518 Transfers In - - 0.0% - - Total Revenue & Transfers In 1,760,518 725,393 41.2% - 1,760,518 Expenditures - - 0.0% - - Transfers Out 815,399 715,399 87.7% - 815,399 Total Expenditures & Transfers Out 815,399 715,399 87.7% - 815,399 Revenues Over/(Under) Expenditures 945,119 9,994 - 945,119 Fund Balance, July 1 1,011,326 - 1,011,326 Fund Balance, End of Period 1,956,445 9,994 - 1,956,445 Fund
Amended
Budget
YTD
Actuals
YTD
Percent
Recommended
Mid-Year
Adjustments
Recommended
Revised
Budget
General Fund
Article 8a TDA Fund
Article 3 TDA Fund
SB 1 Fund
Article 8c TDA Fund
3:25 PM 1/31/2024 1 of 10
CITY OF CAMARILLO
Fiscal Year 2023/24 Mid-Year Budget Review
Summary by Fund
"Exhibit B"
Fund
Amended
Budget
YTD
Actuals
YTD
Percent
Recommended
Mid-Year
Adjustments
Recommended
Revised
Budget
220
Revenues 2,684,508 1,477,409 55.0% - 2,684,508 Transfers In 3,378,495 12,529 0.4% - 3,378,495 Total Revenue & Transfers In 6,063,003 1,489,938 24.6% - 6,063,003 Expenditures 6,063,003 2,677,104 44.2% - 6,063,003 Transfers Out - - 0.0% - Total Expenditures & Transfers Out 6,063,003 2,677,104 44.2% - 6,063,003 Revenues Over/(Under) Expenditures - (1,187,166) - - Fund Balance, July 1 - - - Fund Balance, End of Period - (1,187,166) - - 221
Revenues 1,070,676 610,091 57.0% - 1,070,676 Expenditures 1,334,964 509,366 38.2% - 1,334,964 Transfers Out - - 0.0% - - Total Expenditures & Transfers Out 1,334,964 509,366 38.2% - 1,334,964 Revenues Over/(Under) Expenditures (264,288) 100,725 - (264,288) Fund Balance, July 1 1,434,337 - 1,434,337 Fund Balance, End of Period 1,170,049 100,725 - 1,170,049 222
Revenues 31,060 18,210 58.6% - 31,060 Expenditures 43,060 14,208 33.0% - 43,060 Revenues Over/(Under) Expenditures (12,000) 4,002 - (12,000) Fund Balance, July 1 99,418 - 99,418 Fund Balance, End of Period 87,418 4,002 - 87,418 223
Revenues 1,894 1,104 58.3% - 1,894 Transfers In 4,000 1,050 26.3% - 4,000 Total Revenue & Transfers In 5,894 2,154 36.5% - 5,894 Expenditures 5,658 1,320 23.3% - 5,658 Revenues Over/(Under) Expenditures 236 834 - 236 Fund Balance, July 1 (159) - (159) Fund Balance, End of Period 77 834 - 77 224
Revenues 54,336 29,322 54.0% - 54,336 Expenditures 56,262 23,744 42.2% - 56,262 Revenues Over/(Under) Expenditures (1,926) 5,578 - (1,926) Fund Balance, July 1 59,587 - 59,587 Fund Balance, End of Period 57,661 5,578 - 57,661 225
Revenues 18,645 9,917 53.2% - 18,645 Expenditures 23,596 5,551 23.5% - 23,596 Revenues Over/(Under) Expenditures (4,951) 4,366 - (4,951) Fund Balance, July 1 30,114 - 30,114 Fund Balance, End of Period 25,163 4,366 - 25,163 226
Revenues 22,111 13,388 60.5% - 22,111 Expenditures 23,934 4,179 17.5% - 23,934 Revenues Over/(Under) Expenditures (1,823) 9,209 - (1,823) Fund Balance, July 1 36,902 - 36,902 Fund Balance, End of Period 35,079 9,209 - 35,079 Zone 6-Spanish Hills Maintenance Fund
Citywide Lighting/Landscape MD Fund
Zone 1-Mission Oaks MD1A Fund
Zone 2-Wittenberg Maintenance Fund
Zone 3-Armitos Storm Basin Fund
Zone 4-Mission Oaks Industrial Maintenance Fund
Zone 5-Presley Maintenance Fund
3:25 PM 1/31/2024 2 of 10
CITY OF CAMARILLO
Fiscal Year 2023/24 Mid-Year Budget Review
Summary by Fund
"Exhibit B"
Fund
Amended
Budget
YTD
Actuals
YTD
Percent
Recommended
Mid-Year
Adjustments
Recommended
Revised
Budget
227
Revenues 8,065 4,673 57.9% - 8,065 Expenditures 10,570 2,796 26.5% - 10,570 Revenues Over/(Under) Expenditures (2,505) 1,877 - (2,505) Fund Balance, July 1 16,646 - 16,646 Fund Balance, End of Period 14,141 1,877 - 14,141 228
Revenues 33,637 18,399 54.7% - 33,637 Expenditures 42,604 13,460 31.6% 42,604 Revenues Over/(Under) Expenditures (8,967) 4,939 - (8,967) Fund Balance, July 1 40,834 - 40,834 Fund Balance, End of Period 31,867 4,939 - 31,867 230
Revenues 30,099 17,033 56.6% - 30,099 Expenditures 34,388 13,685 39.8% - 34,388 Revenues Over/(Under) Expenditures (4,289) 3,348 - (4,289) Fund Balance, July 1 61,614 - 61,614 Fund Balance, End of Period 57,325 3,348 - 57,325 231
Revenues 42,344 24,541 58.0% - 42,344 Expenditures 45,616 20,439 44.8% - 45,616 Revenues Over/(Under) Expenditures (3,272) 4,102 - (3,272) Fund Balance, July 1 67,661 - 67,661 Fund Balance, End of Period 64,389 4,102 - 64,389 240
Revenues 261,028 72,030 27.6% (201,927) 59,101 Transfers In - - 0.0% - - Total Revenue & Transfers In 261,028 72,030 27.6% (201,927) 59,101 Transfers Out 373,739 171,975 46.0% - 373,739 Revenues Over/(Under) Expenditures (112,711) (99,945) (201,927) (314,638) Fund Balance, July 1 4,791,569 - 4,791,569 Fund Balance, End of Period 4,678,858 (99,945) (201,927) 4,476,931 251
Revenues 1,341,747 241,680 18.0% (778,786) 562,961 Transfers In - - 0.0% - - Total Revenue & Transfers In 1,341,747 241,680 18.0% (778,786) 562,961 Transfers Out 2,532,209 151,433 6.0% - 2,532,209 Revenues Over/(Under) Expenditures (1,190,462) 90,247 (778,786) (1,969,248) Fund Balance, July 1 11,464,326 - 11,464,326 Fund Balance, End of Period 10,273,864 90,247 (778,786) 9,495,078 252
Revenues 112,303 16,444 14.6% (97,871) 14,432 Transfers Out 925,147 24,195 2.6% - 925,147 Revenues Over/(Under) Expenditures (812,844) (7,751) (97,871) (910,715) Fund Balance, July 1 1,073,249 - 1,073,249 Fund Balance, End of Period 260,405 (7,751) (97,871) 162,534 Zone 7-Sares/Regis Maintenance Fund
Zone 8-Vista Las Posas Maint. Fund
Zone 10-Adolfo Glen III Maint. Fund
Zone 9-Adolfo Glen II Maintenance Fund
Springville Interchange Benefit Assessment
Traffic Mitigation Fees
Bridge Policy Fee
3:25 PM 1/31/2024 3 of 10
CITY OF CAMARILLO
Fiscal Year 2023/24 Mid-Year Budget Review
Summary by Fund
"Exhibit B"
Fund
Amended
Budget
YTD
Actuals
YTD
Percent
Recommended
Mid-Year
Adjustments
Recommended
Revised
Budget
253
Revenues 340 520 152.9% - 340 Transfers Out - - 0.0% - Revenues Over/(Under) Expenditures 340 520 - 340 Fund Balance, July 1 33,783 - 33,783 Fund Balance, End of Period 34,123 520 - 34,123 261
Revenues 2,626 4,560 173.6% - 2,626 Transfers In - - 0.0% - - Total Revenue & Transfers In 2,626 4,560 173.6% - 2,626 Revenues Over/(Under) Expenditures 2,626 4,560 - 2,626 Fund Balance, July 1 296,085 - 296,085 Fund Balance, End of Period 298,711 4,560 - 298,711 262
Revenues 4,058 6,571 161.9% - 4,058 Transfers In - - 0.0% - - Total Revenue & Transfers In 4,058 6,571 161.9% - 4,058 Revenues Over/(Under) Expenditures 4,058 6,571 - 4,058 Fund Balance, July 1 426,613 - 426,613 Fund Balance, End of Period 430,671 6,571 - 430,671 263
Revenues 29,598 47,953 162.0% - 29,598 Transfers Out - - 0.0% - - Revenues Over/(Under) Expenditures 29,598 47,953 - 29,598 Fund Balance, July 1 3,113,351 - 3,113,351 Fund Balance, End of Period 3,142,949 47,953 - 3,142,949 264
Revenues 1,045 152 14.5% - 1,045 Transfers In - - 0.0% - - Total Revenue & Transfers In 1,045 152 14.5% - 1,045 Transfers Out - - - Revenues Over/(Under) Expenditures 1,045 152 - 1,045 Fund Balance, July 1 9,870 - 9,870 Fund Balance, End of Period 10,915 152 - 10,915 275
Revenues 428 2,491 582.0% - 428 Transfers Out - - 0.0% - - Revenues Over/(Under) Expenditures 428 2,491 - 428 Fund Balance, July 1 161,753 - 161,753 Fund Balance, End of Period 162,181 2,491 - 162,181 280
Revenues 677,153 66,093 9.8% - 677,153 Expenditures 500,876 84,672 16.9% 112,019 612,895 Revenues Over/(Under) Expenditures 176,277 (18,579) (112,019) 64,258 Fund Balance, July 1 494,424 - 494,424 Fund Balance, End of Period 670,701 (18,579) (112,019) 558,682 Parking in Lieu
Storm Drain Fees
Signals
Underground Utilities
Street Improvements
Air Quality Fund
CDBG Fund
3:25 PM 1/31/2024 4 of 10
CITY OF CAMARILLO
Fiscal Year 2023/24 Mid-Year Budget Review
Summary by Fund
"Exhibit B"
Fund
Amended
Budget
YTD
Actuals
YTD
Percent
Recommended
Mid-Year
Adjustments
Recommended
Revised
Budget
285
Revenues 152,313 151,108 99.2% - 152,313 Transfers In - - 0.0% - - Total Revenue & Transfers In 152,313 151,108 99.2% - 152,313 Expenditures 299,055 208,071 69.6% - 299,055 Revenues Over/(Under) Expenditures (146,742) (56,963) - (146,742) Fund Balance, July 1 636,349 - 636,349 Fund Balance, End of Period 489,607 (56,963) - 489,607 286
Revenues 222,297 88,047 39.6% - 222,297 Expenditures - - 0.0% - - Transfers Out 2,831,178 35,490 1.3% (938,584) 1,892,594 Total Expenditures & Transfers Out 2,831,178 35,490 1.3% (938,584) 1,892,594 Revenues Over/(Under) Expenditures (2,608,881) 52,557 938,584 (1,670,297) Fund Balance, July 1 2,214,661 - 2,214,661 Fund Balance, End of Period (394,220) 52,557 938,584 544,364 321
Revenue - 13,363 0.0% - - Transfers In 489,938 390,000 79.6% - 489,938 Total Revenue & Transfers In 489,938 403,363 82.3% - 489,938 Expenditures 489,938 411,100 83.9% - 489,938 Revenues Over/(Under) Expenditures - (7,737) - - Fund Balance, July 1 509,716 - 509,716 Fund Balance, End of Period 509,716 (7,737) - 509,716 410
Revenues 5,450,352 - 0.0% - 5,450,352 Transfers In 10,892,153 2,929,987 26.9% 5,878,683 16,770,836 Total Revenue & Transfers In 16,342,505 2,929,987 17.9% 5,878,683 22,221,188 Expenditures 15,432,345 3,579,859 23.2% (3,399,668) 12,032,677 Transfers Out - - 0.0% - - Total Expenditures & Transfers Out 15,432,345 3,579,859 23.2% (3,399,668) 12,032,677 Revenues Over/(Under) Expenditures 910,160 (649,872) 9,278,351 10,188,511 Fund Balance, July 1 11,881,663 - 11,881,663 Fund Balance, End of Period 12,791,823 (649,872) 9,278,351 22,070,174 429
Revenues 50,337 13,984 27.8% - 50,337 Transfers In 3,100 407,319 13139.3% 404,219 407,319 Total Revenue & Transfers In 53,437 421,303 788.4% 404,219 457,656 Expenditures 102,296 66 0.1% - 102,296 Transfers Out - - 0.0% - Total Expenditures & Transfers Out 102,296 66 0.1% - 102,296 Revenues Over/(Under) Expenditures (48,859) 421,237 404,219 355,360 Fund Balance, July 1 8,601,568 - 8,601,568 Fund Balance, End of Period 8,552,709 421,237 404,219 8,956,928 498
Revenues 5,459 3,162 57.9% - 5,459 Expenditures 61,450 9,374 15.3% - 61,450 Transfers Out 3,100 407,319 13139.3% 404,219 407,319 Revenues Over/(Under) Expenditures (59,091) (413,531) 699.8% (404,219) (401,860) Fund Balance, July 1 861,572 - 861,572 Fund Balance, End of Period 802,481 (413,531) (404,219) 459,712 Library Special Revenue Fund
Cable PEG Fees Special Revenue Fund
Library Debt Service Fund
Capital Improvement Projects Fund
Camarillo Corridor Projects Fund
Low/Moderate Income Housing Fund
3:25 PM 1/31/2024 5 of 10
CITY OF CAMARILLO
Fiscal Year 2023/24 Mid-Year Budget Review
Summary by Fund
"Exhibit B"
Fund
Amended
Budget
YTD
Actuals
YTD
Percent
Recommended
Mid-Year
Adjustments
Recommended
Revised
Budget
510
Revenues 2,420,188 1,121,224 46.3% - 2,420,188 Expenditures 2,454,168 2,201,616 89.7% 130,000 2,584,168 Revenues Over/(Under) Expenses (33,980) (1,080,392) (130,000) (163,980) Working Capital, July 1 1,202,196 - 1,202,196 Working Capital, End of Period 1,168,216 (1,080,392) (130,000) 1,038,216 530
Revenues 4,046,942 2,056,457 50.8% - 4,046,942 Expenditures 4,188,110 1,676,525 40.0% - 4,188,110 Revenues Over/(Under) Expenses (141,168) 379,932 - (141,168) Working Capital, July 1 2,505,342 - 2,505,342 Working Capital, End of Period 2,364,174 379,932 - 2,364,174 540
Revenues 2,956,553 1,448,251 49.0% - 2,956,553 Transfers In - - 0.0% - - Total Revenue & Transfers In 2,956,553 1,448,251 49.0% - 2,956,553 Expenditures 4,098,927 711,936 17.4% (453,512) 3,645,415 Total Expenditures & Transfers Out 4,098,927 711,936 17.4% (453,512) 3,645,415 Revenues Over/(Under) Expenses (1,142,374) 736,315 453,512 (688,862) Working Capital, July 1 6,353,189 - - 6,353,189 Working Capital, End of Period 5,210,815 736,315 453,512 5,664,327 550
Revenues 3,761,299 2,835,146 75.4% - 3,761,299 Transfers In 380,000 - 0.0% (340,000) 40,000 Total Revenue & Transfers In 4,141,299 2,835,146 68.5% (340,000) 3,801,299 Expenditures 2,433,976 1,071,167 44.0% (417,850) 2,016,126 Transfers Out - - 0.0% - - Total Expenditures & Transfers Out 2,433,976 1,071,167 44.0% (417,850) 2,016,126 Revenues Over/(Under) Expenses 1,707,323 1,763,979 77,850 1,785,173 Working Capital, July 1 3,611,103 - 3,611,103 Working Capital, End of Period 5,318,426 1,763,979 77,850 5,396,276 551
Revenues 745,418 396,431 53.2% - 745,418 Expenditures 1,352,196 364,971 27.0% (625,000) 727,196 Revenues Over/(Under) Expenses (606,778) 31,460 625,000 18,222 Working Capital, July 1 2,069,262 - - 2,069,262 Working Capital, End of Period 1,462,484 31,460 625,000 2,087,484 552
Revenues 1,164,948 1,730,026 148.5% - 1,164,948 Expenditures 455,565 173,942 38.2% (47,500) 408,065 Revenues Over/(Under) Expenses 709,383 1,556,084 47,500 756,883 Working Capital, July 1 1,228,271 - 1,228,271 Working Capital, End of Period 1,937,654 1,556,084 47,500 1,985,154 City Hall Facility Fund
Risk Management Fund
Information Systems Fund
Vehicles & Equipment Fund
Corporation Yard Facility Fund
Police Facility Fund
3:25 PM 1/31/2024 6 of 10
CITY OF CAMARILLO
Fiscal Year 2023/24 Mid-Year Budget Review
Summary by Fund
"Exhibit B"
Fund
Amended
Budget
YTD
Actuals
YTD
Percent
Recommended
Mid-Year
Adjustments
Recommended
Revised
Budget
553
Revenues 1,220,422 734,754 60.2% - 1,220,422 Expenditures 1,287,568 983,117 76.4% - 1,287,568 Transfers Out - - 0.0% - Total Expenditures & Transfers Out 1,287,568 983,117 76.4% - 1,287,568 Revenues Over/(Under) Expenses (67,146) (248,363) - (67,146) Working Capital, July 1 1,851,370 - 1,851,370 Working Capital, End of Period 1,851,370 - - 1,851,370 555
Revenues 1,302 2,203 169.2% - 1,302 Transfers In - - 0.0% - - Total Revenue & Transfers In 1,302 2,203 169.2% - 1,302 Expenditures 4,250 7,575 178.2% 4,250 Revenues Over/(Under) Expenses (2,948) (5,372) - (2,948) Working Capital, July 1 143,761 - 143,761 Working Capital, End of Period 140,813 (5,372) - 140,813 805
Revenues 8,149,125 3,725,135 45.7% 17,996 8,167,121 Transfers In 105,000 - 0.0% - 105,000 Total Revenue & Transfers In 8,254,125 3,725,135 45.1% 17,996 8,272,121 Expenditures 8,249,181 3,471,460 42.1% 23,373 8,272,554 Revenues Over/(Under) Expenses 4,944 253,675 (5,377) (433) Working Capital, July 1 250,313 - 250,313 Working Capital, End of Period 255,257 253,675 (5,377) 249,880 810
Revenues 5,302,381 655,455 12.4% (1,800,000) 3,502,381 Transfers In - - 0.0% 1,800,000 1,800,000 Total Revenue & Transfers In 5,302,381 655,455 12.4% - 5,302,381 Expenditures 5,479,577 1,844,567 33.7% - 5,479,577 Transfers out - 271,621 0.0% - - Total Expenditures & Transfers Out 5,479,577 2,116,188 38.6% - 5,479,577 Revenues Over/(Under) Expenses (177,196) (1,460,733) - (177,196) Working Capital, July 1 368,179 - 368,179 Working Capital, End of Period 190,983 (1,460,733) - 190,983 Library Facility Fund
Chamber of Commerce Facility Fund
Solid Waste Fund
Transit Fund
3:25 PM 1/31/2024 7 of 10
CITY OF CAMARILLO
Fiscal Year 2023/24 Mid-Year Budget Review
Summary by Fund
"Exhibit B"
Fund
Amended
Budget
YTD
Actuals
YTD
Percent
Recommended
Mid-Year
Adjustments
Recommended
Revised
Budget
815
Revenues 873,207 158,460 18.1% (426,244) 446,963 Transfers In - - 0.0% - - Total Revenue & Transfers In 873,207 158,460 18.1% (426,244) 446,963 Expenditures 959,125 287,609 30.0% (170,000) 789,125 Transfers out - - 0.0% - - Total Expenditures & Transfers Out 959,125 287,609 30.0% (170,000) 789,125 Revenues Over/(Under) Expenses (85,918) (129,149) (256,244) (342,162) Working Capital, July 1 396,439 - 396,439 Working Capital, End of Period 310,521 (129,149) (256,244) 54,277 860
Revenues 16,739,258 7,616,936 45.5% (1,750,000) 14,989,258 Expenditures 21,679,251 9,596,808 44.3% 400,000 22,079,251 Transfers Out - - 0.0% - - Total Expenditures & Transfers Out 21,679,251 9,596,808 44.3% 400,000 22,079,251 Revenues Over/(Under) Expenses (4,939,993) (1,979,872) (2,150,000) (7,089,993) Working Capital, July 1 8,271,398 - 8,271,398 Working Capital, End of Period 3,331,405 (1,979,872) (2,150,000) 1,181,405 861
Revenues 728,287 386,004 53.0% 728,287 Transfers In - - 0.0% - Expenditures 1,203,635 224,795 18.7% (429,739) 773,896 Revenues Over/(Under) Expenses (475,348) 161,209 429,739 (45,609) Working Capital, July 1 2,101,274 - 2,101,274 Working Capital, End of Period 1,625,926 161,209 429,739 2,055,665 862
Revenues 16,788 16,379 97.6% - 16,788 Expenditures 762,394 40,924 5.4% - 762,394 Revenues Over/(Under) Expenses (745,606) (24,545) - (745,606) Working Capital, July 1 1,077,030 - 1,077,030 Working Capital, End of Period 331,424 (24,545) - 331,424 863
Revenues 606,460 304,861 50.3% - 606,460 Transfers In - - 0.0% - - Total Revenue & Transfers In 606,460 304,861 50.3% - 606,460 Expenditures 3,906,896 442,120 11.3% (763,933) 3,142,963 Transfers Out 10,000,000 9,865,999 98.7% - 10,000,000 Revenues Over/(Under) Expenses (13,300,436) (10,003,258) 763,933 (12,536,503) Working Capital, July 1 18,870,944 - - 18,870,944 Working Capital, End of Period 5,570,508 (10,003,258) 763,933 6,334,441 Water Capital Projects Fund
Camarillo Ranch Events
Water Utility Fund
Reclaimed Water Fund
Water Conservation Credit Fund
3:25 PM 1/31/2024 8 of 10
CITY OF CAMARILLO
Fiscal Year 2023/24 Mid-Year Budget Review
Summary by Fund
"Exhibit B"
Fund
Amended
Budget
YTD
Actuals
YTD
Percent
Recommended
Mid-Year
Adjustments
Recommended
Revised
Budget
864
Revenues - 16,615 0.0% - - Transfers In 10,000,000 9,865,999 98.7% - 10,000,000 Total Revenue & Transfers In 10,000,000 9,882,614 0.0% - 10,000,000 Expenditures 182,425 (401,137) 0.0% - 182,425 Transfers Out - - 0.0% - - Total Expenditures & Transfers Out 182,425 (401,137) 0.0% - 182,425 Revenues Over/(Under) Expenses 9,817,575 10,283,751 - 9,817,575 Working Capital, July 1 512,517 - 512,517 Working Capital, End of Period 10,330,092 10,283,751 - 10,330,092 Revenues 121,932,049 53,889,002 44.2% (257,732) 121,674,317 Expenditures 140,870,733 55,126,951 39.1% (12,119,077) 128,751,656 Net Transfers In/(Out) - - 0.0% - - Revenues Over/(Under) Expenses (18,938,684) (1,237,949) 11,861,345 (7,077,339) Fund Balance/Working Capital, July 1 191,346,731 - 191,346,731 172,408,047 (1,237,949) 11,861,345 184,269,392 Water Debt Service
TOTAL CITY OF CAMARILLO
Fund Balance/Working Capital,
3:25 PM 1/31/2024 9 of 10
CITY OF CAMARILLO
Fiscal Year 2023/24 Mid-Year Budget Review
Summary by Fund
"Exhibit B"
Fund
Amended
Budget
YTD
Actuals
YTD
Percent
Recommended
Mid-Year
Adjustments
Recommended
Revised
Budget
871
Revenues 15,183,389 7,849,117 51.7% - 15,183,389 Transfers In - 14,031 0.0% - - Total Revenue & Transfers In 15,183,389 7,863,148 0.0% - 15,183,389 Expenditures 20,162,410 9,300,923 46.1% 350,000 20,512,410 Transfers Out - - 0.0% - - Total Expenditures & Transfers Out 20,162,410 9,300,923 46.1% 350,000 20,512,410 Revenues Over/(Under) Expenses (4,979,021) (1,451,806) (350,000) (5,329,021) Working Capital, July 1 34,193,598 - 34,193,598 Working Capital, End of Period 29,214,577 (1,451,806) (350,000) 28,864,577 872
Revenues 1,368,044 977,509 71.5% - 1,368,044 Expenditures 510,600 258,077 50.5% - 510,600 Revenues Over/(Under) Expenses 857,444 719,432 - 857,444 Working Capital, July 1 185,878 - 185,878 Working Capital, End of Period 1,043,322 719,432 - 1,043,322 873
Revenues 674,804 484,731 71.8% - 674,804 Transfers In - - 0.0% - - Total Revenue & Transfers In 674,804 484,731 71.8% - 674,804 Expenditures 5,584,293 764,332 13.7% (1,041,901) 4,542,392 Revenues Over/(Under) Expenses (4,909,489) (279,601) 1,041,901 (3,867,588) Working Capital, July 1 29,683,093 - 29,683,093 Working Capital, End of Period 24,773,604 (279,601) 1,041,901 25,815,505
TOTAL CAMARILLO SANITARY DISTRICT
Revenues 17,226,237 9,311,357 54.1% - 17,226,237 Expenditures 26,257,303 10,323,332 39.3% (691,901) 25,565,402 Net Transfers In/(Out) - - 0.0% - - Revenues Over/(Under) Expenses (9,031,066) (1,011,975) 691,901 (8,339,165) Fund Balance/Working Capital, July 1 64,062,570 - 64,062,570 55,031,504 (1,011,975) 691,901 55,723,405 Revenues 139,158,286 63,200,359 45.4% (257,732) 138,900,554 Expenditures 167,128,036 65,450,283 39.2% (12,810,978) 154,317,058 Net Transfers In/(Out) - - 0.0% - - Revenues Over/(Under) Expenses (27,969,750) (2,249,924) 12,553,246 (15,416,504) Fund Balance/Working Capital, July 1 255,409,301 - 255,409,301 227,439,551 (2,249,924) 12,553,246 239,992,797 Fund Balance/Working Capital,
End of Period
TOTAL CITY AND CSD
Fund Balance/Working Capital,
End of Period
Camarillo Sanitary District (CSD)-Operating Fund
CSD-Debt Service Fund
CSD-Capital Projects Fund
3:25 PM 1/31/2024 10 of 10