City of Morgan Hill
Year to Date Expenses - Fiscal Year 2022-23
For the Month Ended Oct 31, 2022
33% of Year Complete
CURRENT
FUND MONTH PERCENT OF
NO. FUND/ACTIVITY ACTUAL AMENDED YTD OUTSTANDING TOTAL TOTAL TO PRIOR
EXPENSES BUDGET EXPENSES ENCUMBRANCE ALLOCATED BUDGET YTD
ENTERPRISE FUNDS
SEWER
640 SEWER OPERATIONS 892,490 16,300,411 4,493,325 194,636 4,687,961 29% 4,493,325 641 SEWER CAPITAL EXPANSION 235,508 23,292,409 369,092 999,897 1,368,989 6% 190,421 642 SEWER RATE STABILIZATION 151 1,818 606 - 606 33% 380 643 SEWER-CAPITAL PROJECTS 1,230,422 23,494,295 8,996,401 617,903 9,614,304 41% 3,681,104 TOTAL SEWER FUND(S) 2,358,572 63,088,933 13,859,424 1,812,436 15,671,860 25% 8,365,230 WATER
Water Operations 956,492 16,045,940 4,496,370 746,244 5,242,614 33% 4,357,307 Utility Billing 98,940 1,097,979 278,316 55,931 334,247 30% 282,710 Water Conservation 35,174 439,985 79,664 31,539 111,203 25% 27,016 650 WATER OPERATIONS 1,090,605 17,583,904 4,854,350 833,715 5,688,064 32% 4,667,033 651 WATER CAPITAL EXPANSION 57,928 893,125 238,907 25,802 264,709 30% 254,098 652 WATER RATE STABILIZATION 113 1,362 454 - 33% 454 124 653 WATER-CAPITAL PROJECTS 35,089 5,617,611 61,494 275,844 6 337,338 % 117,472 TOTAL WATER FUND(S) 1,183,736 24,096,001 5,155,205 1,135,360 6,290,565 26% 5,038,726 TOTAL ENTERPRISE FUNDS 3,542,307 87,184,934 19,014,629 2,947,796 21,962,425 25% 13,403,956
INTERNAL SERVICE FUNDS
730 INFORMATION SYSTEMS 150,489 2,518,930 509,974 84,355 594,330 24% 614,340 740 BUILDING MAINTENANCE 109,452 1,668,218 397,189 63,426 460,616 28% 339,934 741 BUILDING REPLACEMENT 2,612 1,611,451 68,526 25,823 94,349 6% 49,940 745 CIP ADMINISTRATION 166,693 1,982,153 569,223 13,738 582,961 29% 519,242 760 UNEMPLOYMENT - 15,000 - - n/a - -
770 WORKERS COMPENSATION 11,542 1,106,358 535,143 - 535,143 48% 604,516 790 EQUIPMENT REPLACEMENT 68,683 1,055,964 234,232 395,206 629,438 60% 83,538 791 EMPLOYEE BENEFITS FUND 27,658 700,000 178,440 - 178,440 25% 81,071 795 GEN. LIABILITY INSURANCE 16,795 1,893,436 1,667,342 4,650 1,671,992 88% 1,457,006 TOTAL INTERNAL SERVICE FUNDS 553,924 12,551,510 4,160,069 587,198 4,747,267 38% 3,749,588 REPORT TOTAL $ 13,033,404 $ 215,144,372 $ 52,252,846 $ 17,721,599 $ 69,974,445 33% 52,237,174 $
City of Morgan Hill
Fund Activity Summary - Fiscal Year 2022-23
For The Month Ended October 31, 202233% of Year Complete Beginning Year to-Date
Fund Fund Balance YTD % of YTD % of Deficit or
No. Fund 07-01-22 Actual Budget Actual Budget Carryover Reserved1 Unreserved 010 GENERAL FUND 30,325,888 $ 8, $ 17% 15, 437,904 $ 540,108 29% (7, $ 102,205) $ 3,650,137 $ 19,573,547 TOTAL GENERAL FUND $ 30,325,888 $ 8,437,904 17% $ 15,540,108 29% $ (7,102,205) $ 3,650,137 $ 19,573,547 202 STREET MAINTENANCE 63,915 $ 203,737 22% $ 1,680 27% $ 202,057 $ - $ 265,972 205 PUBLIC SAFETY/SUPPL. LAW 251,291 74,476 73% 26% 74,059 417 - 325,350 206 DEVELOPMENT SERVICES (495,437) 2,465,884 40% 1,646,005 27% 819,879 362,337 (37,895) 207 LONG RANGE PLANNING 1,197,975 383,055 38% 270,043 29% 113,012 29,345 1,281,642 215 / 216 CDBG 29,812 223 91% 33% 27 196 - 30,008225 ASSET SEIZURE 101,644 360 37% 33% 253 107 - 101,751229 LIGHTING AND LANDSCAPE 190,530 579 0% 48,140 21% (47,561) 5,423 137,546 230 COMMUNITY FACILITIES DISTRICT 132,368 341 1% 11,828 30% (11,487) - 120,881232 ENVIRONMENTAL PROGRAMS 236,258 180,279 33% 140,151 27% 40,128 8,762 267,624 234 MOBILE HOME PK RENT STAB. 69,992 790 179% 33% 294 496 - 70,488 235 SENIOR HOUSING 236,079 n/a - n/a - - - 236,079
236 HOUSING MITIGATION 5,879,386 216,700 14% 265,784 14% (49,084) 184,267 5,646,035 240 EMPLOYEE ASSISTANCE 61,964 2,524 12% 4,237 20% (1,713) - 60,251 246 COUNTYWIDE SOLID WASTE 129,862 401,901 46% 310,563 17% 91,338 1,086,679 (865,479) 247 ENVIRONMENT REMEDIATION 139,118 472 46% n/a - 472 - 139,590255 HOUSING SUCCESSOR AGENCY 3,091,721 184,795 79% 404,991 35% (220,195) 320,833 2,550,692 260 PUBLIC ART 67,129 n/a 17,993 - 96% (17,993) - 49,136 TOTAL SPECIAL REVENUE FUNDS $ 11,383,607 $ 4,116,116 33% $ 3,122,406 23% $ 993,711 $ 2,020,886 $ 10,356,432 301 PARK DEV. IMPACT FUND $ (822,989) $ 1,337,102 98% $ 619,015 24% $ 718,087 $ 168,828 $ (273,730) 302 PARK MAINTENANCE 2,567,344 10,153 17% 217,868 34% (207,715) - 2,359,629 303 LOCAL DRAINAGE 11,596,359 682,759 182% 687,010 8% (4,251) 290,248 11,301,860 304 LOCAL DRAINAGE/NON-AB1600 1,374,682 68,841 236% 13,563 7% 55,277 7,940 1,422,019 306 AGRICULTURE AND OPEN SPACE PRESERVA 26,326 589,238 520% 41,951 15% (15,625) - 573,613 308 STREET CIP 5,741,205 21% 5, 988,911 65% (4, 411,041 422,130) 2,220,875 (901,800) 309 TRAFFIC IMPACT FUND 1,187,038 54,044 1% 1, 21% (1, 956,082 902,038) 4,259,952 (4,974,952) 315 PUBLIC SAFETY FACILITIES IMPACT 3,221,824 36,674 1% 2% ( 194,684 158,011) 653,897 2,409,917 346 PUBLIC FACILITIES NON-AB1600 2,878,803 32% 16,531 370,020 1% 353,489 6,066 3,226,225 347 PUBLIC FACILITIES IMPACT FUND 1,017,051 10,279 7% 9,718 3% 561 - 1,017,612348 LIBRARY IMPACT FUND 1,444,583 30,752 6% 74,305 33% (43,553) - 1,401,030 350 UNDERGROUNDING 1,600,648 5,764 19% 380 0% 5,384 - 1,606,032355 SCHOOL PEDESTRIAN/TRAFFIC SFTY (46,063) 43% 6,789 208,410 2% 201,620 1,350 154,207 360 COMM/REC CTR IMPACT FUND 1,295,025 52,149 4% 37% ( 544,239 492,090) 883,062 (80,126) 375 QUIMBY FEE 839,370 1,538,915 236% 72,025 5% 1,466,890 46,604 2,259,655 TOTAL CAPITAL PROJECT FUNDS $ 34,484,118 $ 5,421,098 25% $ 9,865,203 21% $ (4,444,106) $ 8,538,822 $ 21,501,191 420 CIVIC CENTER DEBT $ 173,445 $ 98,046 34% $ 234,549 80% ( $ 136,503) $ 241,117 $ (204,175) 441 POLICE FACILITY BOND DEBT 166,744 129,359 33% 315,882 82% (186,523) 306,877 (326,655) TOTAL DEBT SERVICE FUNDS $ 340,189 $ 227,406 33% $ 550,431 81% $ (323,025) $ 547,993 $ (530,830) Revenues Expenses Ending Fund Balance
City of Morgan Hill
Fund Activity Summary - Fiscal Year 2022-23
For The Month Ended October 31, 202233% of Year Complete Beginning Year to-Date
Fund Fund Balance YTD % of YTD % of Deficit or
No. Fund 07-01-22 Actual Budget Actual Budget Carryover Reserved1 Unreserved Revenues Expenses Ending Fund Balance
640 SEWER OPERATIONS $ 4,567,000 $ 3,927,734 27% 4, $ 493,325 28% ( $ 565,591) 194,636 3,806,772 641 SEWER IMPACT FUND* 20,552,531 6,721,607 38% 369,092 2% 6,352,516 999,897 25,905,150 642 SEWER RATE STABILIZATION 2,726,339 26,400 53% 33% 25,794 606 - 2,752,133 643 SEWER-CAPITAL PROJECTS 22,007,034 2,245,311 33% 8,996,401 38% (6,751,090) 617,903 14,638,041 650 WATER OPERATIONS 4,289,349 5,378,517 30% 4,854,350 28% 524,168 833,715 3,979,802 651 WATER IMPACT FUND* 2,924,596 65,754 7% 238,907 27% (173,154) 25,802 2,725,640 652 WATER RATE STABILIZATION 3,154,313 11,232 n/a 33% 10,778 454 - 3,165,091 653 WATER -CAPITAL PROJECT 10,397,946 1,723,225 34% 61,494 1% 1,661,731 275,844 11,783,833 TOTAL ENTERPRISE FUNDS $ 70,619,108 $ 20,099,780 32% $ 19,014,629 22% $ 1,085,151 $ 2,947,796 $ 68,756,463 730 INFORMATION SERVICES $ 795,800 $ 747,284 33% $ 509,974 20% $ 237,310 $ 84,355 $ 948,755 740 BUILDING MAINTENANCE (166,058) 551,915 33% 397,189 24% 154,726 63,426 (74,758) 741 BUILDING REPLACEMENT 3,719,439 283,106 34% 68,526 4% 214,580 25,823 3,908,196 745 CIP ENGINEERING 8,327 536,618 27% 569,223 29% (32,605) 13,738 (38,016) 760 UNEMPLOYMENT 316,781 1,051 45% n/a - 1,051 - 317,832 770 WORKERS COMPENSATION 1,944,442 267,436 37% 535,143 48% (267,707) 30,000 1,646,735 790 EQUIPMENT REPLACEMENT 6,113,244 373,777 30% 234,232 22% 139,545 395,206 5,857,583 791 EMPLOYEE BENEFITS FUNDS (161,343) 269,998 33% 178,440 25% 91,558 - (69,785)795 GEN. LIABILITY INSURANCE 1,123,565 660,966 33% 1,667,342 88% (1,006,375) 4,650 112,540 TOTAL INTERNAL SERVICE FUNDS $ 13,694,197 $ 3,692,152 32% $ 4,160,069 33% $ (467,917) $ 617,198 $ 12,609,082
SUMMARY BY FUND TYPE
GENERAL FUND GROUP 30,325,888 $ $ 8,437,904 17% 15, $ 540,108 29% (7, $ 102,205) $ 3,650,137 $ 19,573,547 SPECIAL REVENUE GROUP 11,383,607 4,116,116 33% 3,122,406 23% 993,711 2,020,886 10,356,432 DEBT SERVICE GROUP 340,189 227,406 33% 550,431 81% (323,025) 547,993 (530,830) CAPITAL PROJECTS GROUP 34,484,118 5,421,098 25% 9,865,203 21% (4,444,106) 8,538,822 21,501,191 ENTERPRISE GROUP 70,619,108 20,099,780 32% 19,014,629 22% 1,085,151 2,947,796 68,756,463 INTERNAL SERVICE GROUP 13,694,197 3,692,152 32% 4,160,069 33% (467,917) 617,198 12,609,082 TOTAL ALL GROUPS $ 160,847,107 $ 41,994,455 26% 52, $ 252,846 24% (10, $ 258,391) $ 18,322,832 $ 132,265,884 For Enterprise Funds: Unrestricted fund balance = Fund balance net of fixed assets and long-term liabilities. *Unreserved fund balance includes bond proceeds reserved for projects listed in bond documents. 1 Amount restricted for encumbrances, fixed asset replacement, long-term receivables, and bond reserves.