Loading...
HomeMy WebLinkAbout2021-O-35 - 4Q Budget Adjustments ORDINANCE NO. 2021-0-35 AN ORDINANCE PROVIDING BUDGET AMENDMENT FOR THE REMAINDER OF THE FISCAL YEAR BEGINNING OCTOBER 1, 2020 AND ENDING SEPTEMBER 30,2021. WHEREAS, it is necessary to amend the 2020-21 fiscal year budget to adjust revenues and expenditures as reflected on the attached pages, and incorporated herein by reference. The attached budget amendment for the fiscal year beginning October 1,2020 and ending September 30, 2021, was duly presented to the City Council by the City Manager and a public notice was posted in the Stephenville City Hall. NOW,THEREFORE, BE IT ORDAINED BY THE CITY COUNCIL OF THE CITY OF STEPHENVILLE,TEXAS: SECTION 1. That the amended appropriations and anticipated revenues for the fiscal year beginning October 1, 2020 and ending September 30, 2021 for the support of the general government of the City of Stephenville, Texas, be amended and fixed for the remainder of the fiscal year ending September 30,2021,with the revenues and expenditures shown. SECTION 2. That the amended budget is hereby approved in all respects and adopted as the City's budget for the remainder of the fiscal year ending September 30, 2021. PASSED and APPROVED this the 4th day of October, 2021. , S‘;i of Sr a" gnA . css.• c boSyi- , Mayor 4, • : ATTEST: = z ; • — ; • r = Staci L. Kin ' y Secretary '"i,, 8PO R P / lu,,,, Reviewed by en L. Barnes, City Manager Randy Thomas, City Attorney Approved as to form and legality City of Stephenville Statement of Projected Cash Flows All Funds FY 2020-2021 Water Storm Hotel General Sewer Landfill Airport Water Occupancy Fund Fund Fund Fund Fund Tax Fund Cash Balance 10/01(audited) 9,751,595 16,850,611 869,917 171,622 889,609 361,502 Revenues Taxes 13,809,417 408,148 Licenses&Permits 302,562 9,000 20,000 Fines&Forfeitures 117,850 Intergovernmental 2,180,293 - - 1,771,000 Service Charges 1,389,450 8,572,265 975,000 109,380 650,438 50,867 Other Revenue 244,780 38,671 3,440 1,761,755 2,060 12,660 Total Revenue 18,044,352 8,619,936 978,440 1,871,135 2,443,498 471,675 Transfers In 683,841 34,753 - 160,000 - - Transfers Out (1,373,268) (509,518) (28,763) - (264,439) - Expenditures Personnel Costs 11,176,925 1,328,118 232,950 2,406 - 81,275 Operating Expenditures 4,153,663 3,204,214 248,286 78,689 75,268 426,801 Capital Expenditures 1,326,437 13,822,871 - 1,946,115 2,191,000 - Debt Service 347,594 1,803,108 - - 499,526 - Total Expenditures 17,004,619 20,158,311 481,236 2,027,210 2,765,794 508,076 Net Revenues over(under)Expenditures 350,306 (12,013,140) 468,441 3,925 (586,735) (36,401) Estimated Cash Balance 09/30 10,101,901 4,837,471 1,338,358 175,547 302,874 325,101 Restricted: ^�` Operational Reserve 3,832,647 1,133,083 120,309 20,274 18,817 127,019 Debt Service 198,550 1,585,869 503,372 Tourism and Visitor Bureau 198,082 Capital Projects Child Safety Court Technology Court Security Public Safety Downtown Development Plan Airport Improvement 224,754 Grant Match 150,000 Recreation Hall Improvements 27,162 Economic Development Grownth Fund Economic Development Estimated Unrestricted Cash Balance 9/30/2021 5,668,788 2,118,519 1,218,049 155,273 (219,315) - Original Estimated Unrestricted Cash Balance 9/30 3,492,221 1,843,643 1,209,079 129,503 (324,984) - Add difference in Estimated Cash Balance 10/1 versus Audited Cash Balance 10/1 1,508,300 333,920 27,720 22,630 106,431 64,587 Add Revenue adjustments 1,782,932 241,500 75,000 74,255 (90,900) 20,867 Less Expenditure adjustments 1,046,368 241,500 75,000 71,115 (90,138) 57,853 Less Change in Operational Reserve 177,885 59,044 18,750 - 14,463 Less Change in Restricted for Rec Hall Improvements (109,588) Less Change in Restricted for Tourism and Visitor Bureau 13,138 Less Change in Restricted for Capital Projects Less Change in Restricted for Downtown Development Plan Less Change in Restricted for Economic Development Growth Fund Less Change in Restricted for Economic Development Estimated Unrestricted Cash Balance 9/30/2021 5,668,788 2,118,519 1,218,049 155,273 (219,315) - City of Stephenville Statement of Projected Cash Flows All Funds FY 2020-2021 Debt Capital TIF Non--Major Service Project Special Revenue Special Revenue Fund Fund Fund Funds Total Cash Balance 10/01(audited) 214,826 13,723,465 - 80,832 42,913,979 Revenues Taxes 265,289 13,821 14,496,675 Licenses&Permits 331,562 Fines&Forfeitures 11,400 129,250 Intergovernmental 3,500 3,954,793 Service Charges 15,376 11,762,776 Other Revenue 311 1,200 106 2,064,983 Total Revenue 265,600 16,576 13,821 15,006 32,740,039 Transfers In 343,650 967,565 329,829 - 2,519,638 Transfers Out - - (343,650) - (2,519,638) Expenditures Personnel Costs - - - 12,821,674 Operating Expenditures - - 13,000 8,199,921 Capital Expenditures - 14,209,251 - 33,495,674 Debt Service 609,250 - 3,259,478 Total Expenditures 609,250 14,209,251 - 13,000 57,776,747 Net Revenues over(under)Expenditures - (13,225,110) - 2,006 (25,036,708) Estimated Cash Balance 09/30 214,826 498,355 82,838 17,877,271 Restricted: ^• Operational Reserve 5,252,149 Debt Service 214,826 2,502,617 Tourism and Visitor Bureau 198,082 Capital Projects 498,355 498,355 Child Safety 5,112 5,112 Court Technology 8,972 8,972 Court Security 5,800 5,800 Public Safety 42,051 42,051 Downtown Development Plan 0 Airport Improvement 224,754 Grant Match 150,000 Recreation Hall Improvements 27,162 Economic Development Grownth Fund Economic Development Estimated Unrestricted Cash Balance 9/30/2021 - - - 20,903 8,962,217 Original Estimated Unrestricted Cash Balance 9/30 - - - - 6,349,462 Add difference in Estimated Cash Balance 10/1 versus Audited Cash Balance 10/1 (52,301) Add Revenue adjustments Less Expenditure adjustments 285,870 Less Change in Operational Reserve Less Change in Restricted for Rec Hall Improvements Less Change in Restricted for Tourism and Visitor Bureau Less Change in Restricted for Capital Projects (338,171) Less Change in Restricted for Downtown Development Plan Less Change in Restricted for Economic Development Growth Fund Less Change in Restricted for Economic Development Estimated Unrestricted Cash Balance 9/30/2021 - - - - 6,349,462 City of Stephenville Statement of Projected Cash Flows All Funds FY 2020-2021 Discrete Component Unit Cash Balance 10/01(audited) 891,896 Revenues Taxes 519,311 Licenses&Permits Fines&Forfeitures Intergovernmental Service Charges Other Revenue 2,154 Total Revenue 521,465 Transfers In Transfers Out Expenditures Personnel Costs 222,700 Operating Expenditures 651,611 Capital Expenditures 65,000 Debt Service Total Expenditures 939,311 Net Revenues over(under)Expenditures (417,846) Estimated Cash Balance 09/30 474,050 Restricted: .... Operational Reserve 218,578 Debt Service Tourism and Visitor Bureau Capital Projects Child Safety Court Technology Court Security Public Safety Downtown Development Plan Airport Improvement 90,000 Grant Match Recreation Hall Improvements Economic Development Grownth Fund 165,472 Economic Development Estimated Unrestricted Cash Balance 9/30/2021 Original Estimated Unrestricted Cash Balance 9/30 - Add difference in Estimated Cash Balance 10/1 versus Audited Cash Balance 10/1 (23,678) Add Revenue adjustments Less Expenditure adjustments 420,000 Less Change in Operational Reserve (41,078) Less Change in Restricted for Rec Hall Improvements Less Change in Restricted for Tourism and Visitor Bureau Less Change in Restricted for Capital Projects Less Change in Restricted for Downtown Development Plan (75,000) Less Change in Restricted for Economic Development Growth Fund (234,528) Less Change in Restricted for Economic Development (93,072) Estimated Unrestricted Cash Balance 9/30/2021 - Budget Adjustment Register t r�E ncufl Stephenville,TX Budget 2020-2021 Packet:GLPKT02418-4TH Qtr Budget Adjustments Adjustment Date-0913012021 Adjustment Number Account Number Acct Type Account Name Adjustment Description Current Budget Adjustment Proposed Budget BA0000079 01-43500.20191 Revenue COVID 19 STATE GRANT CARES Grant received - 726,698 726,698 01-101-52110.00000 Expense POSTAGE Postage to send phase 2 of meal vouchers 50 1,425 1,475 01-101-58003.00000 Expense ECONOMIC STIMULUS GRANTS Economic Stimulus Grants-meal voucher - 71,260 71,260 01-101-58005.00000 Expense UTILITY ASSISTANCE GRANTS Utility Assistance Grants - 3,489 3,489 01-102-53321.20190 Expense OPERATING SUPPLIES-COVID-19 COVID supplies and PPE - 3,545 3,545 01-105-53321.20190 Expense OPERATING SUPPLIES-COVID-19 COVID supplies and PPE - 3,567 3,567 01-501-53321.20190 Expense OPERATING SUPPLIES-COVID-19 COVID supplies and PPE - 457 457 01-504-53321.20190 Expense OPERATING SUPPLIES-COVID-19 COVID supplies and PPE - 341 341 01-601-53321.20190 Expense OPERATING SUPPLIES-COVID-19 COVID supplies and PPE - 11,599 11,599 BA0000081 01-101-52140.00000 Expense ADVERTISING&PUBLIC NOTICES Bond Election Advertising 2,000 14,000 16,000 BA0000082 01-101-52531.00000 Expense OUTSIDE PROFESSIONALS Study for potential convention center/hotel 39,000 35,650 74,650 BA0000083 01-101-52531.00000 Expense OUTSIDE PROFESSIONALS Professional Services for TIRZ 1C expansion 39,000 37,500 76,500 BA0000084 01-103-54160.00000 Expense COMPUTER MAINTENANCE Carryover HR Automation Project not spent FY 20-21 22,125 2,600 24,725 01-103-55160.00000 Expense COMPUTER EQUIPMENT Carryover HR Automation Project not spent FY 20-21 - 49,211 49,211 BA0000089 01-107-52531.00000 Expense OUTSIDE PROFESSIONALS Welllspring Ins Contract for Benefits Consulting 15,000 12,500 27,500 01.701-51250.00000 Expense GROUP INSURANCE Welllspring Ins Contract for Benefits Consulting 447,109 (12,500) 434,609 BA0000087 01-44030.00000 Revenue EMERGENCY AMBULANCE Additional Ambulance receipts/collection fee 613,000 233,313 846,313 01-201-52542.00000 Expense SPECIAL SERVICES Additional Ambulance receipts/collection fee 79,690 30,331 110,021 BA0000090 01-203-52531.00000 Expense OUTSIDE PROFESSIONALS Professional Services for Microsoft 365 Migration - 22,050 22,050 BA0000106 01-203-55160.00000 Expense COMPUTER EQUIPMENT IT intrusion detection/prevention system - 19,455 19,455 BA0000074 01-43500.20190 Revenue GREEN RIBBON GRANT Adjust carryover of Green Ribbon Grant Project 400,000 (400,000) - ���s� 01-501-55330.20190 MEDIAN IMPROVEMENTS Adjust carryover of Green Ribbon Grant Project 410,775 (407,025) 3,750 g BA0000091 01-45602.00000 Revenue LOAN PROCEEDS Record Purchase of Park mowers&Loan Proceeds - 90,503 90,503 01-501-55120.00000 Revenue MACHINERY&EQUIPMENT Record Purchase of Park mowers& Loan Proceeds - 90,503 90,503 BA0000092 01-501-55265.00000 Expense REC HALL IMPROVEMENTS Replace Rec Hall Windows Council Approved 01/05/21 - 109,588 109,588 BA0000107 01-501-55250.00000 Expense STREETS/SIDEWALKS Increase city share sidewalk improvements grant 343,957 8,562 352,519 BA0000094 01-43500.20210 Revenue COVID VACCINATION CENTER GRANT Vaccination Center Grant - 712,000 712,000 01-601-51130.00000 Expense PART TIME WAGES Vaccination Center personnel 1,654 28,816 30,470 OPERATING SUPPLIES-COVID 01-601-5 33 2 1.20210 Expense VACCINATION CENTER Vaccination Center operating supplies - 111,233 111,233 BA0000093 01-601-51111.00000 Expense SALARY VACANCY SAVINGS Reallocate Budgeted Salary Vacancy Savings (174,279) 174,279 - 01-701-51111.00000 Expense SALARY VACANCY SAVINGS Reallocate Budgeted Salary Vacancy Savings (222,277) (174,279) (396,556) 8A0000095 01-601-55110.00000 Expense VEHICLES Carryover Fire Truck and Equipment from FY 19-20 - 43,816 43,816 BA0000096 01-601-52610.00000 Expense OTHER CONTRACTUAL SERVICES Correct Lease Interest Budgeted 6,817 (298) 6,519 01-601-57550.00000 Expense LEASE INTEREST Correct Lease Interest Budgeted 33,703 298 34,001 BA0000075 01-43500.20200 Revenue NIBRS GRANT Carryover NIBRS grant unspent - 203,255 203,255 01-701-55140.20190 Expense OTHER EQUIPMENT-NIBRS GRANT Carryover NIBRS grant unspent - 203,255 203,255 BA0000080 01-43500.20191 Revenue COVID 19 STATE GRANT Coronavirus Emergency Supplemental Funding rcvd - 111,164 111,164 OTHER EQUIPMENT-COVID 19 01-701-55140.20191 Expense GRANT Coronavirus PPE&Aeroclave Disinfecting Machines - 111,164 111,164 BA0000097 01-701-52550.20190 Expense DAMAGE CLAIMS Carryover Public Safety Building Repairs - 333,977 333,977 BA0000108 01-45601.00000 Revenue CAPITAL LEASE PROCEEDS Record Capital Lease Purchase of Police vehicles - 105,999 105,999 01-701-55110.00000 Expense VEHICLE Record Capital Lease Purchase of Police vehicles 99,000 77,877 176,877 01-701-57600.00000 Expense LEASE PRINCIPAL Record Capital Lease Purchase of Police vehicles 81,073 28,122 109,195 GENERAL FUND NET REVENUES OVER/(UNDER)EXPENDITURES 736,564 Budget Adjustment Register St„„ Stephenville,TX '�Y Budget 2020-2021 Packet:GLPKT02418-4TH Qtr Budget Adjustments Adjustment Date-09/30/2021 Adjustment Number Account Number ACct Type Account Name Adjustment Description Current Budget Adjustment Proposed Budget BA0000069 02-44520-00000 Revenue WASTEWATER CHARGES Utility Rate Study-Council approved 10/27/2020 3,296,950 56,000 3,352,950 02-000-52531.00000 Expense OUTSIDE PROFESSIONALS Utility Rate Study-Council approved 10/27/2020 10,000 56,000 66,000 BA0000098 02-44520.00000 Revenue WASTEWATER CHARGES Water Facility Maintenance increase to actual 3,296,950 100,000 3,396,950 02.001-54235.00000 Expense WATER FACILITY MAINTENANCE Water Facility Maintenance increase to actual 100,000 100,000 200,000 BA0000099 02-44520.00000 Revenue WASTEWATER CHARGES Storm Uri Damages 3,296,950 21,500 3,318,450 02-001-52550.20210 Expense DAMAGE CLAIMS 2021 STORM URI Storm Uri Damages - 21,500 21,500 BA0000100 02-002-54235.00000 Expense WATER FACILITY MAINTENANCE Reallocate maintenance for anticipated actual 170,000 (12,000) 158,000 02-003-54236.00000 Expense METER MAINTENANCE Reallocate maintenance for anticipated actual 45,000 12,000 57,000 BA0000101 02-011-55110.00000 Expense VEHICLES Increase vehicle purchase Council approved 12/1/2020 25,000 5,323 30,323 02-012-54241.00000 Expense SEWER FACILITY MAINTENANCE Increase vehicle purchase Council approved 12/1/2020 75,000 (5,323) 69,677 BA0000102 02-44520-00000 Revenue WASTEWATER CHARGES Increase credit card fees to anticipated actuals 3,296,950 64,000 3,360,950 02-020-53342.00000 Expense WEB CREDIT CARD FEES Increase credit card fees to anticipated actuals 41,379 64,000 105,379 UTILITY FUND NET REVENUES OVER/(UNDER) EXPENDITURES - BA0000103 03-44/10.00000 Revenue LANDFILL GATE FEES Adjust maintenance to anticipated actuals 900,000 75,000 975,000 03-030-54110.00000 Expense VEHICLE MAINTENANCE Adjust maintenance to anticipated actuals 1,000 15,000 16,000 03-030-54120.00000 Expense MACHINERY MAINTENANCE Adjust maintenance to anticipated actuals 50,000 60,000 110,000 LANDFILL FUND NET REVENUES OVER/(UNDER) EXPENDITURES - BA0000071 04-45920.20120 Revenue CAPITAL CONTRIBUTIONS Carryover TXDOT Aviation Grant 1202STVLE - 31,515 (31,515) r, 04-040-55230.20120 Expense AIRPORT IMPROVEMENTS Carryover TXDOT Aviation Grant 1202STVLE - 35,017 35,017 BA0000072 04-45920.20170 Revenue CAPITAL CONTRIBUTIONS Carryover TXDOT Aviation Grant 1702STVLE - 3,795 (3,795) 04-040-55230.20170 Expense AIRPORT IMPROVEMENTS Carryover TXDOT Aviation Grant 1702STVLE - 4,217 4,217 BA0000073 04-45920.20171 Revenue CAPITAL CONTRIBUTIONS Carryover TXDOT Aviation Grant 1702STEVE - 38,945 (38,945) 04-040-55230.20171 Expense AIRPORT IMPROVEMENTS Carryover TXDOT Aviation Grant 1702STEVE - 31,881 31,881 AIRPORT FUND NET REVENUES OVER/(UNDER) EXPENDITURES 3,140 BA0000077 05-43500.00000 Revenue GRANTS Adjust CDBG GLO Grant Carryover 1,861,900 (90,900) 1,771,000 05-050-55231.20180 Expense CDBG GLO GRANT Adjust CDBG GLO Grant Carryover 1,881,138 (90,138) 1,791,000 STORM WATER DRAINAGE FUND NET REVENUES OVER/(UNDER) EXPENDITURES (762) BA0000076 07-45410.00000 Revenue MISCELLANEOUS Museum utilities and insurance receivables due - 12,000 12,000 07-070-58307.00000 Expense H/M TAX-MUSEUM Museum utilities and insurance paid - 12,000 12,000 BA0000104 07-070-58300.00000 Expense UNDESIGNATED GRANT FUNDS All American Barrel Race Council Approved 10/06/20 10,000 20,000 30,000 BA0000105 07-44171.00000 Revenue MOOLA FEST Adjust Moo-la fest to actuals 42,000 8,867 50,867 07-070-58343.00000 Expense MOOLA FEST Adjust Moo-la fest to actuals 83,000 25,853 108,853 HOTEL OCCUPANCY TAX FUND NET REVENUES OVER/(UNDER) EXPENDITURES (36,986) BA0000085 10.402-55250.00000 Expense STREETS Adjust Street Program Carryover 1,973,192 (355,687) 1,617,505 BA0000086 10-402.55250.20200 Expense STREETS-2020 BONDS Adjust 2020 Bonds Street Carryover 7,858,443 641,557 8,500,000 CAPITAL IMPROVEMENTS FUND NET REVENUES OVER/(UNDER) EXPENDITURES (285,870) Budget Adjustment Register - Sttpkent e Stephenville,TX Budget 2020-2021 Packet:GLPKT02418-4TH Qtr Budget Adjustments Adjustment Date-09/30/2021 Adjustment Number Account Number Acct Type Account Name Adjustment Description Current Budget Adjustment Proposed Budget ACCOUNT SUMMARY 01-43500.20190 Revenue GREEN RIBBON GRANT 400,000 (400,000) - 01-43500.20191 Revenue COVID 19 STATE GRANT - 837,862 837,862 01-43500.20200 Revenue NIBRS GRANT - 203,255 203,255 01-43500.20210 Revenue COVID VACCINATION CENTER GRANT - 712,000 712,000 01-44030.00000 Revenue EMERGENCY AMBULANCE 613,000 233,313 846,313 01-45601.00000 Revenue CAPITAL LEASE PROCEEDS - 105,999 105,999 01-45602.00000 Revenue LOAN PROCEEDS - 90,503 90,503 01-101-52110.00000 Expense POSTAGE 50 1,425 1,475 01-101-52140.00000 Expense ADVERTISING&PUBLIC NOTICES 2,000 14,000 16,000 01-101-52531.00000 Expense OUTSIDE PROFESSIONALS 39,000 73,150 112,150 01-101-58003.00000 Expense ECONOMIC STIMULUS GRANTS - 71,260 71,260 01-101-58005.00000 Expense UTILITY ASSISTANCE GRANTS - 3,489 3,489 01-102-53321.20190 Expense OPERATING SUPPLIES-COVID-19 - 3,545 3,545 01-103-54160.00000 Expense COMPUTER MAINTENANCE 22,125 2,600 24,725 01-103-55160.00000 Expense COMPUTER EQUIPMENT - 49,211 49,211 01-105-53321.20190 Expense OPERATING SUPPUES-COVID-19 - 3,567 3,567 01-107-52531.00000 Expense OUTSIDE PROFESSIONALS 15,000 12,500 27,500 01-201-52542.00000 Expense SPECIAL SERVICES 79,690 30,331 110,021 01-203-52531.00000 Expense OUTSIDE PROFESSIONALS - 22,050 22,050 01-203-55160.00000 Expense COMPUTER EQUIPMENT - 19,455 19,455 01-501-53321.20190 Expense OPERATING SUPPUES-COVID-19 - 457 457 01-501-55120.00000 Expense MACHINERY&EQUIPMENT - 90,503 90,503 01-501-55250.00000 Expense STREETS/SIDEWALKS 343,957 8,562 352,519 01-501-55265.00000 Expense REC HALL IMPROVEMENTS - 109,588 109,588 01-501-55330.20190 Expense MEDIAN IMPROVEMENTS 410,775 (407,025) 3,750 01-504-53321.20190 Expense OPERATING SUPPUES-COVID-19 - 341 341 01-601.51111.00000 Expense SALARY VACANCY SAVINGS (174,279) 174,279 - 01-601-51130.00000 Expense PART TIME WAGES 1,654 28,816 30,470 01-601-52610.00000 Expense OTHER CONTRACTUAL SERVICES 6,817 (298) 6,519 01-601-53321.20190 Expense OPERATING SUPPLIES-COVID-19 - 11,599 11,599 01-601-53321.20210 Expense OPERATING SUPPLIES-COVID VACCINATION CENTER - 111,233 111,233 01-601-55110.00000 Expense VEHICLES - 43,816 43,816 01-601-57550.00000 Expense LEASE INTEREST 33,703 298 34,001 01.701-51111.00000 Expense SALARY VACANCY SAVINGS (222,277) (174,279) (396,556) 01-701-51250.00000 Expense GROUP INSURANCE 447,109 (12,500) 434,609 01-701-52550.20190 Expense DAMAGE CLAIMS - 333,977 333,977 01-701-55110.00000 Expense VEHICLE 99,000 77,877 176,877 01-701-55140.20190 Expense OTHER EQUIPMENT-NIBRS GRANT - 203,255 203,255 01-701.55140.20191 Expense OTHER EQUIPMENT-COVID 19 GRANT - 111,164 111,164 01-701-57600.00000 Expense LEASE PRINCIPAL 81,073 28,122 109,195 02-44520.00000 Revenue WASTEWATER CHARGES 3,296,950 241,500 3,538,450 02-000-52531.00000 Expense OUTSIDE PROFESSIONALS 10,000 56,000 66,000 02-001-52550.20210 Expense DAMAGE CLAIMS 2021 STORM URI - 21,500 21,500 02-001-54235.00000 Expense WATER FACILITY MAINTENANCE 100,000 100,000 200,000 02-002-54235.00000 Expense WATER FACILITY MAINTENANCE 170,000 (12,000) 158,000 02-003-54236.00000 Expense METER MAINTENANCE 45,000 12,000 57,000 02-011-55110.00000 Expense VEHICLES 25,000 5,323 30,323 02.012-54241.00000 Expense SEWER FACILITY MAINTENANCE 75,000 (5,323) 69,677 02-020-53342.00000 Expense WEB CREDIT CARD FEES 41,379 64,000 105,379 03-44710.00000 Revenue LANDFILL GATE FEES 900,000 75,000 975,000 03-030-54110.00000 Expense VEHICLE MAINTENANCE 1,000 15,000 16,000 03-030-54120.00000 Expense MACHINERY MAINTENANCE 50,000 60,000 110,000 04-45920.20120 Revenue CAPITAL CONTRIBUTIONS - 31,515 31,515 04-45920.20170 Revenue CAPITAL CONTRIBUTIONS - 3,795 3,795 04-45920.20171 Revenue CAPITAL CONTRIBUTIONS - 38,945 38,945 04-040-55230.20120 Expense AIRPORT IMPROVEMENTS - 35,017 35,017 04-040-55230.20170 Expense AIRPORT IMPROVEMENTS - 4,217 4,217 04-040-55230.20171 Expense AIRPORT IMPROVEMENTS - 31,881 31,881 05.43500.00000 Revenue GRANTS 1,861,900 (90,900) 1,771,000 05-050-55231.20180 Expense CDBG GLO GRANT 1,881,138 (90,138) 1,791,000 07-44171.00000 Revenue MOOLA FEST 42,000 8,867 50,867 07-45410.00000 Revenue MISCELLANEOUS - 12,000 12,000 07-070-58300.00000 Expense UNDESIGNATED GRANT FUNDS 10,000 20,000 30,000 07-070-58307.00000 Expense H/M TAX-MUSEUM - 12,000 12,000 07-070-58343.00000 Expense MOOLA FEST 83,000 25,853 108,853 10-402-55250.00000 Expense STREETS 1,973,192 (355,687) 1,617,505 10-402-55250.20200 Expense STREETS-2020 BONDS 7,858,443 641,557 8,500,000 Account Totals (6,394,699) 416,086 15,978,613) Budget Adjustment Register 8tepkentvlle Stephenville,TX Budget 2020-2021 Packet:GLPKT02418-4TH Qtr Budget Adjustments Adjustment Date-09130/2021 Adjustment Number Account Number Acct Type Account Name Adjustment Description Current Budget Adjustment Proposed Budget Revenue Summary CHARGES FOR SEVICES 558,680 INTERGOVERNMENTAL 1,336,472 OTHER REVENUE 208,502 Total Adjustment to Revenues 2,103,654 Department Expenditure Summary 101 CITY COUNCIL 163,324 102 CITY MANAGER 3,545 103 CITY SECRETARY 51,811 105 MUNICIPAL BUILDING 3,567 107 HUMAN RESOURCES 12,500 201 FINANCE 30,331 203 INFORMATION TECHNOLOGY 41,505 501 PARKS&RECREATION (197,915) 504 LIBRARY 341 601 FIRE 369,743 701 POLICE 567,616 000 UTILITIES ADMIN 56,000 001 WATER PRODUCTION 121,500 002 WATER DISTRIBUTION (12,000) 003 CUSTOMER SERVICE 12,000 011 WASTEWATER COLLECTIONS 5,323 012 WASTEWATER TREATMENT PLANT (5,323) 020 UTILITY BILLING&COLLECTION 64,000 ^I% 030 LANDFILL 75,000 040 AIRPORT 71,115 050 STORM WATER DRAINAGE (90,138) 070 TOURISM 57,853 402 STREET IMPROVEMENT 285,870 Total Adjustment to Expenditures 1,687,568 Net Revenue Over/(Under)Expenditures 416,086 Fund Summary 01 GENERAL FUND 736,564 02 UTILITY FUND - 03 LANDFILL FUND - 04 AIRPORT FUND 3,140 05 STORM WATER DRAINAGE FUND (762) 07 HOTEL OCCUPANCY TAX FUND (36,986) 10 CAPITAL IMPROVEMENTS FUND (285,870) Fund Totals 416,086 SEDA Annual Budgets BUDGET BUDGET BUDGET ACCT NO# ACCT NAME 2019-2020 2020-2021 Amendments 1-PERSONNEL 5790-111 FULL TIME SALARIES 170000.00 170000 178335 5790-113 PART TIME WAGES 0.00 0 5790-121 RETIREMENT 20400.00 17000 14565 5790-122 SOCIAL SECURITY/medicare 13000.00 13000 13000 5790-123 WORKER'S COMPENSATION 1300.00 1300 1300 5790-125 GROUP INSURANCE 17000.00 16000 15500 5790-126 CAR ALLOWANCE 5400.00 5400 0 ** CATEGORY TOTAL** 227100.00 222700 222700 2-CONTRACTUAL 5790-211 POSTAGE 500.00 500 5790-212 COMMUNICATIONS 4500.00 4500 5790-213 MILEAGE REIMBURSEMENT 2500.00 2000 5790-214 ADVERTISEMENT 1000.00 500 5790-215 EDUCATION &SCHOOLING 11500.00 11500 5790-223 MARKETING 80000.00 80000 5790-224 OTHER INSURANCE 1450.00 1450 5790-225 MEETINGS 3000.00 3000 5790-231 RENTAL 4800.00 4800 5790-251 UTILITIES 0.00 0 5790-252 DUES&SUBSCRIPTIONS 7000.00 5000 5790-253 OUTSIDE PROFESSIONALS 10000.00 10000 85000 5790-254 SPECIAL SERVICES 5000.00 5000 5790-262 JANITORIAL SERVICE 0.00 0 ** CATEGORY TOTAL** 131250.00 128250 3-GENERAL SERVICES 5790-312 OFFICE SUPPLIES 1500.00 1000 5790-317 PHOTO AND DUPLICATION 1000.00 1000 5790-332 OPERATING SUPPLIES 1200.00 1000 5790-333 COMPUTER SUPPLIES 3000.00 3000 ** CATEGORY TOTAL** 6700.00 6000 4-MACHINE&EQUIPMENT MAINTENANCE 5790-413 OFFICE EQUIPMENT 3000.00 3000 ** CATEGORY TOTAL** 3000.00 3000 SEDA Annual Budgets BUDGET BUDGET BUDGET ACCT NO# ACCT NAME 2019-2020 2020-2021 Amendments 5-CAPITAL OUTLAY 5790-511 MOTOR VEHICLE 65000 ** CATEGORY TOTAL** 65000 7-ED PROJECTS 5790-700 ECONOMIC DEVELOPMENT PROGRAMS 150000.00 122000 422000 COMMUNITY DEVELOPMENT PROJECT 22867.00 10000 ** CATEGORY TOTAL** 172867.00 132000 8-NOT USED 5790-801 ADMINISTRATIVE SERVICES 28350.00 24861 4861 TSU INTERN 2500.00 2500 ** CATEGORY TOTAL** 30850.00 27361 *** FUND TOTAL EXPENDITURES*** 571767.00 519311 SEDA FUND RESERVE (year end 2019) 850000.00 900000* 460000* Christy Plaza Backstop 250000.00 0 0 TIRZ Establishment 0.00 0 0 SRH Quiet Zone 175000.00 0 0 East Side Sewer 75000.00 0 0 Downtown Development Plan - 75000 0 Economic Development Growth Fund - 400,000 229828 Operating-3 Months(6 mo in 2020) 142942.00 259655 129828 Airport Renovation 80000.00 90000 90000 Available 127058.00 75345 10345 *Estimated Reserve Total Notes: Already$111k up thru first 6 months.This is not reflected.