Chad Mees, Mayor Vickie Cooper, Mayor Pro-Tempore Gayle Jones, Council Member Jackiel Ivicic, Council Member Jesse Luna, Council Member Shelton Gilmore, Council Member RTLE NOTICE AND AGENDA OF A CALLED MEETING OF THE CITY COUNCIL OF THE CITY OF BARTLETT, TEXAS Notice is hereby given that the City Council of the City of Bartlett, Texas will holda Regular Called Meeting 6:001 PM Monday,September 23rd,2024 Bartlett City Hall 140 W Clark Street, Bartlett, TX 76511 For citizen comments, please contact Brenda Kelley, City Secretary at municipalcourt@bartlelt-x.IS. CALLTO ORDER, DECLARE A QUORUM, PLEDGE OF ALLEGIANCE, AND INVOCATION CITIZENS COMMUNICATION (The City Council welcomes public comments on items not listed on the agenda. However, the Council cannot respond until tne item is posted on ajuture meeting agenda. Pubiic comments are umitea to. 3 minutes.) PUBLICI HEARINGS 1. Budget Hearing. 2. Tax Rate Hearing 3. Council Vote: Budget Hearing VOTE: MPTCooper CM Gilmore CMI Luna CM. Jones CMI Ivicic 4. Council Vote: Tax Rate Hearing: VOTE: MPT Cooper CM Gilmore CMLuna CMJones CM Ivicic REGOLAR AGENDA: REVIEW/DISCUSS AND CONSIDER ACTION Yes No Yes No Dann nf Chad Mees, Mayor Vickie Cooper, Mayor Pro-Tempore Gayle Jones, Council Member Jackie Ivicic, Council Member Jesse Luna, Council Member Shelton Gilmore, Council Member RTLE 5. Discuss, review, and take any necessary action to adopt Ordinance 2024-09-23-01. An Ordinance of the City of Bartlett Texas adopting a budget for the fiscal year (FY) beginning October 15,2024 to September 30h ,2025. 6. Discuss, review, and take any necessary action to adopt Ordinance 2024-09-23-02. An Ordinance for the City of Bartlett Texas setting the Tax Rate for 2024-2025 tax year at 0.7166 cents on each $100 of taxable value of real property that is not exempt from taxation. Levying Taxes for the use and support of the Municipal Government of the City for the Fiscal Year (FY) 7. Discuss, review, and take any necessary action to adopt Ordinance 2024-09-23-03. An Ordinance amending the utility rate structure for residential and commercial customers. 8. Discuss, review, and take any necessary action to adopt Ordinance 2024-09-23-04. An Ordinance amending the Water Utility rate structure for in-city and out-of-city residential and commercial customers; Providing for an increase in Water rates: and Providing notice 9. Discuss, review, and take any necessary action to approve the sub-grant the Texas Division of Emergency Management(IDEM, has issued for the Hazard Mitigation Grant Program (HMGP), 10.Discuss, review, and take any necessary action to consider MRB Engineering group for Professional Services General Land Office (GLO) Community Development Block Grant 11.Discuss, review, and take any necessary action to consider MRB Engineering Group Proposal for Professional Services Texas Department of Emergency Management Generators-Evie Street Authorizing certain adjustments to the budget; andi including procedural provisions. beginning October 15t, 2024 ending September 30th, 2025 Providing for an increase in Electric rates; and providing an effective date. requirements for out-of-city rate payers. DR-4485, Texas Covid-19 Pandemic. (CDBG) City Wide Water System Valve Replacement. Lift Station and Wastewater Treatment Plant Lift Station. FUTURE AGENDA ITEMS ADJOURN Alli items listed on the agenda are eligible for discussion and/or action. The City Council reserves the right to retire into executive session at any time during the course of this meeting to deliberate any of the matters listed, as authorized by Texas Government 551.071 (Consultation with Attorney), 551.072 (Deliberations about Real Property), 551.073 (Deliberations about gifs and donations), 551.074(Personne. Matters), 551.076 (Deliberations about Security Devices) and 551.086 (Economic Development). Allj final deliberations and actions of the governing body shall be held in an open meeting as required by Texas Govemment Code 551.102. Dace 2 nf2 TY Chad Mees, Mayor Vickie Cooper, Mayor Pro-Tempore Gayle Jones, Council Member Jackie Ivicic, Council Member Jesse Luna, Council Member Shelton Gilmore, Council Member Icertify this agenda was posted, pursuant to' Texas Government Code 551.043, at least 72 hours prior to the commencement oft the meeting in accordance with the Texas Open Meetings Act. Posted Friday, September 20-h, 2024, at or before 6:00P.M. Butolly Posted by /s/ Brenda Kelley Ci/Clerk g2g3/ Dace 2 nf2 PROPOSED FISCAL YEAR (FY) 2024-2025 BUDGET City of Bartlett, Texas Chad Mees, Mayor Vickie Cooper, Mayor Pro-Tempore Gayle Jones, Council Member Jackie Ivicic, Council Member Jesse Luna, Council Member Shelton Gilmore, Council Member City of Bartlet-F Proposed Tax Rate This budget will raise more total property taxes than last year's budget by $8,618.88 or 1.00%, and of that amount $725.97 is tax revenue to be raised from new property added to the tax roll this year. Tax Rate Proposed FY Adopted FY Adopted FY 2023 2025 2024 Property Tax 0.7166/$100 0.7500/$100 0.5549/$100 Rate No New 0.7163/$100 0.5033/$100 0.5667/$100 Revenue Tax Rate Revenue 0.6323/$100 0.6397/$100 0.4387/$100 Maintenance &0 Operations Tax Rate ApprovalTax Voter 0.7166/$100 0.5215/$100 0.5549/$100 Rate Debt Rate 0.0843/$100 0.1103/$100 0.1162/$100 FV 2023-2024 FV 2023-2024 Remaining Remaining 2025 Budget 23,466.00 0.00% (76,699.39) 29.31% 2,354.36 #DIV/O! 25.00 #DIV/OI 100.00 104.00% 405,944.01 403.48% 109,061.70 122.32% 12,465.59 133.06% 96,664.27 560.31% (35,557.00) (16,991.71) 41.15% 58,575.49 9862.58% 13,704.10 3,384.98 69,121.37 127,613.82 #DIV/O! FV 2023-2024 FV 2023-2024 Remaining FY: 2022-2023 FV: 2023-20241 Vear FV: 2023-2024 Budget Balance %Balance Proposed FY: 2024- 01- General Fund Revenue Summary Q-Non-Depatmental 11-Administration 12-Municipal Court 15-Parks andRecreation 1B-library 20-Baseball Complex Revenue Totals Expense Summary 00-Non-Departmental 11-Administration 12-Municipal Court 13-Police 14-Fire 15-Parks andR Recreation 16-Publicy Works 17-Streets 18-Library 20- -Baseball Complex 70-Flectric Water Expense Totals Revenues Over(Under)! Expenditures 01- General Fund I(Revenue) 00-Non-C Departmental License& Permits 00-6115F PetF Registration Total License & Permits Miscellaneous 00-6 6801 Miscellaneous Revenue 00-6900F Payroll Reimbursement 00-6 69011 Insurance Reimbursement Total Miscellaneous Total Non-Departmental Grand Total 01- Generall Fund (Revenue) 11-Administration Property Tax 11-60031 I8SF Property Tax 11-6005 M8OP Property Tax Total Property Tax Sales Tax 11-6021 Sales Tax 11-6050 Bartiett Muncipal Total Sales Tax Liçense &F Permits 11-6101 Building Permits 11-6112 Manf. Home Permits 11-6115 PetF Registration Totall License & Permits Business &F Franchise 11-6113F Franchise Fees Total Business a Franchise Miscellaneous 11-6801 Faxes 11-69901 Transfers Between Funds Total Miscellaneous Actuals 85.00 615,762.14 40,624.13 500.00 3,025.00 390,366.90 6,428.04 342,688.79 34,503.12 115,890.68 18,894.32 72,881.46 13,981.25 41,822.83 87,279.45 142,620.47 To Date Actuals Budget 23,466.00 31,800.61 2,354.36 25.00 2,600.00 539,709.01 597,739.70 17,473.93 264,467.83 50,166.59 117,664.27 11,879.29 59,175.49 13,704.10 3,384.98 69,121.37 127,613.82 606,701.00 6,763.00 2,100.00 2,600.00 67,000.00 698,575.00 24,854.00 558,792.01 48,600.00 26,895.00 9,400.00 20,500.00 6,400.00 18,150.00 246,420.65 961,417.04 1,425,403.00 (463,985.96) 67.45% 1,808,306.89 108,500.00 2,500.00 133,765.00 488,678.00 222,346.00 (204,872.07) 398,333.00 (133,865.17) 66.39% 37,701.00 21,000.00 35,557.00 28,871.00 600.00 659,996.27 1,021,663.01 $ 1,536,403.00 $ (514,739.99) 66.50% $ 2,426,470.89 7.86% 0.00% #DIV/O! #DIV/O! #DIV/O! $ 567,279.00 1,267,357.31 $ 1,872,928.88 $ 1,366,881.00 $ 505,249.38 137.02% $ 2,292,865.66 (607,361.04) (851,265.87) $ 169,522.00 $ (1,020,787.87) -502.16%$ 133,605.23 FV 2022-2023 FY: 2023-2024 Year FY: 2023-2024 Budget Balance %Balance. Proposed FY 2024- Actuals $ To Date Actuals Budget 52.00 52.00 $ 114.00 23,300.00 $ 23,414.00 85.00S 23,466.00 I$ 85.00S 23,466.00 I$ To Date Actuals Budget $ 125,610.92 $ 124,063.00 Remaining!: 2025 Budget 0.00% 0.00%! $ 154,970.00 0.00% 0.00% 0.00%5 606,701.00 0.00% 606,701.00 %Balance Proposed FY: 2024- Remaining!: 2025 Budget 85.00 85.00 $ (52.00) $ (52.00) 0.00% $ (114.00) (23,300.00) $ (23,414.00) 0.00% $ 606,701.00 (3,466.00) (23,466 FY 2023-2024 FV 2023-2024 Budget $451,731 $ Actuals FY: 2022-2023 FY: 2023-2024 Year FY 2023-2024 Dollars Over 1,547.92 101.25% 185,507.30 492,397.44 $ 634,350.98 $ 719,605.00 $ (85,254.02) 88.15%_$ 739,849.59 $ 492,397.44 $ 759,961.90 $ 843,668.00 $ 83,706.10 90.08% $ 925,356.89 $ 82,388.31 $ 102,209.00 $ 155,950.00 $ (53,741.00) 65.54% $ 155,950.00 54,925.54 $ 102,209.00 $ 141,550.00 (39,341.00) 72.21%_$ 141,550.00 Development District Sales Tax $ 27,462.77 14,400.00 30,000.00 10,000.00 300.00 10,000.00 (14,400.00) 16,492.50 154.98% (2,350.00) 76.50% (300.00) 5,504.21 155.04% 5,504.21 155.04%_s 29,569.43 0.00% 0.00% 14,400.00 25,000.00 7,000.00 15,000.00 15,000.00 680,000.00 19,801.50 6,050.00 46,492.50 7,650.00 $ 25,851.50 $ 54,142.50 $ 40,300.00 $ 13,842.50 134.35% $ 32,000.00 12,178.79 $ 15,504.21 12,178.79 2,946.10 $ 29,569.43 $ 2,946.10 15,504.21 $ 10,000.00 copies& #DIV/O! $ 0.00% 7.88%$ 680,000.00 375,475.00 $ (375,475.00) 29,569.43 375,475.00s (345,905.57)! 11-6851 Donations Total Donations Total Administration Grand Total 01- Generall Fund (Revenue) 12-Municipal Court Fines andF Forfeitures 12-6301 Court Fines Revenue 12-6302 Minicipal Court Building Security Fund 12-6303 Municipal Courts Service Fee Retained 12-6304 Municipal Technology Fund 12-6305! Municipal Jury Funds 12-63061 Locall Truancy Prevention and Diversion Fund 12-6308 Omnibase Fee 12-6351 Court Costs Collected Total Fines and Forfeitures Total Municipal Court Grand Total 01- Icenerall Fund (Revenue) 15-Parks andRecreation Rents 15-6701 Gate8 & Rental 15-6872 Land Lease Total Rents Miscellaneous 15-6702 Total Miscellaneous Total Parks and Recreation Grand Total o- Generall Fund (Revenue) 18-Library Donations 18-6851 Donations Total Donations TotalLibrary Grand Total 0- Generall Fund (kKevenue) 20-Baseball Complex Miscellaneous 20-6 6741 Cemetery Total Miscellaneous Total Baseball Complex Grand Total Total Revenue 0- General Fund (Expense) 00-Non- Departmental Other Sources 00- 7024F Past Duel IRS Taxl Lability Total Other Sources Personnel 00-7033 Employee Retirement Total Personne! 30.00 30.00 10.00 10.00 20.00 300.00% 20.00 300.00% FV 2023-2024 FV 2023-2024 Remaining 615,762.415 961,417.045 1,425,403.005 (463,985.96) 67.45% 1,808,306.89 615,762.14 I$ 961,417.04 IS 1,425,403.00 (463,985.96) 67.45% 1,808,306.89 FY: 2022-2023 FY2 2023-20241 Year FV2 2023-2024 Budget Balance % Balancel. Proposed FY: 2024- Remaining/2025 Budget #DIV/O! $ #DIV/O! #DIV/O! #DIV/O! $ #DIV/O! #DIV/O! #DIV/O! Actuals To Date Actuals Budget 23,461.79 958.31 6,262.83 819.20 15.00 $ 750.12 $ 440.00 $ 7,916.88 24,322.00 $ 108,500.00 $ (84,178.00) 22.42% $ 751.13 4,504.31 636.45 12.58 448.73 $ 372.00 753.41 751.13 4,504.31 636.45 12.58 $ 448.73 372.00 753.41 4,500.00 650.00 15.00 448.00 400.00 750.00 6,763.00 40,624.13 s 31,800.61 $ 108,500.00 $ (76,699.39)! 29.31% $ 6,763.00 40,624:5 31,800.61 108,500.00 (76,699.39) 29.31%5 6,763.00 40,624.135 31,800.61 108,500.00 (76,699.39) 29.31%5 FY 2023-2024 FY: 2023-2024 Remaining Remaining/2025 Budget 1,600.00 #DIV/O! 500.00 #DIV/O! 254.36 #DIV/O! 254.36 #DIV/OI 2354.36 #DIV/OD 2,354.36 #DIV/0I FY 2023-2024 FY 2023-2024 Remaining Remaining/2025 Budget 25.00 #DIV/O!$ 25.00 DIV/oIS 25.00 #DIV/ODES 25.00 #DIV/0! $ FV 2023-2024 FY2 2023-2024 Remaining 2,500.00 2,500.005 FV Actuals 500.00 $ FY 2023-20241 Vear FV 2023-2024 Budget Balance % Balance. Proposed FY 2024- To Date Actuals Budget 1,600.00 $ 500.00 254.36 254.36 1,600.00 500.00 500.00 $ 2,100.00 $ 500.005 2,354.365 500.00S 2,354.365 To Date Actuals Budget 25.00 25.005 25.00S 25.00 To Date Actuals Budget 3,025.00 2,600.00 3,025.005 2,600.00 $ 2,100.00 #DIV/01 $ 2,100.00 2,100.00 2,100.00 FV 2022-2023 FY: 2023-2024 Year FV: 2023-2024 Budget Balance %Balance Proposed FY 2024- Actuals FY2022-2023 FV2 2023-2024 Year FV2023-2024 Budget Balance % Balance Proposed FV 2024- Remaining/2025 Budget 100.00 104.00% 100.00 104.00% 2,600.00 Actuals 2,600.00 3,025.005 2,600.0015 2,500.00 100.00 104.00% 2,600.00 3,025.00 $ 2,600.00 $ 2,500.00 s 100.00 104.00% 2,600.00 659,996.27 $ 1,021,663.01 $ 1,536,403.00 514,739.99 66.50%s 2,426,470.89 FV 2023-2024 Remaining/2025 Budget #DIV/O! $ FV2 Remaining FY2022-2023 FY 2023-2024 Year FY 2023-2024 Budget Balance %Balance Proposed FY 2024- Actuals To Date Actuals Budget 517,130.49 22,578.52 $ 22,578.521 67,615.00 449,515.49 764.82%$ 67,000.00 517,130.49 $ 67,615.00 449,515.49 764.82% 67,000.00 22,578.52 22,578.52 #DIV/OI Transfers 00-9254 Totall Transfers Total Non- Departmental Grand Total 01-G General und (Expense) 11-Administration Personnel 11-7011 Salaries and Wages 11-7012 Council Stipends 11-7021 State Unemployment Taxes- SUI 11-7031 Workers Comp 11-7032 Health Insurance 11-7033 Employee Retirement 11-7670 Physicals, 5PS Screenings, etc. $ 11-8507 Employee Relations and Appreciation 11-92011 Training andE Education Total Personnel Not Categorized 11-70201 I85C Debt Total Not Categorized Other Sources 11-7022 Federal Payrolll Taxes FICA $ 11-7210 CADE Entity Fees Total Other Sources Miscellaneous 11-7111 Advertising and Legal Notices 11-7951 Dues and Membership Fees 11-8001 Cost of Elections 11-8204L Liability Insurance- General Liability 11-8401 Legale Expenses 11-8402 Accounting Audit Expenses 11-8501 Miscellaneous Expense emonasComrbubon/Peal Tributes 11-8701F Postage Fees & Subscriptions 11-92517 Travel Expense Total Miscellaneous Contractual 11-7200 Appraisal District Fees 11-7651 11-8951 sortware Agreements Total Contractual Utilities 11-7451 Cellular Phones and Pagers $ 11-91511 Telephone &1 Internet Services_$ 10,096.64 Total Utilities Debt Service 11-8251 InterestE Expense Total Debt Service Supplies 11-8551 Office Supplies Total Supplies Repair & Maintenance 11-8851 Facility! Maintenance 11-8953 Copier Service 11-8954 Lomputer Hardware& Repairs Total Repair & 11-92551 Transfer from GFto18S Out 66,150.00 (66,150.00) 0.00% 66,150.00 (66,150.00) 0.00%5 539,709.015 153,765.00155 405,944.01 403.48%5 67,000.00 539,709.01 133,765.00 405,944.01 403.48% 67,000.00 FV 2023-2024 FV: 2023-2024 Remaining 90,000.00 68,035.36 175.59% 3,300.00 (550.00) 83.33% 260.00 (168.80) 35.08% 46,249.44 #DIV/O! 11,583.00 3,090.40 126.68% 7,185.00 9,952.04 238.51% 65.00 #DIV/O! 3,506.00 1,720.02 149.06% 2,040.00 923.50 145.27% 124,063.00 3,500.00 7,500.00 1,670.00 7,000.00 4,012.00 30,000.00 15,000.00 1,060.00 960.00 100.00 2,260.00 $ (2,260.00) 3,500.00 1,500.00 $ 4,000.00 5,500.00 7,463.00 7,463.00 FY: 2022-2023 FY 2023-20241 Vear FV 2023-2024 Budget Balance % Balance. Proposed FY 2024- Actuals ToD Date Budget 127,453.89 158,035.36 3,300.00 2,750.00 88.43 91.20 19,781.20 46,249.44 11,347.33 14,673.40 9,672.70 $ 17,137.04 $ 65.00 3,416.50 5,226.02 258.00 2,963.50 114,003.25 Remaining! 2025 Budget 261,025.00 3,300.00 260.00 1,260.00 31,915.00 29,372.00 100.00 4,000.00 $ 175,318.05 $ 247,190.96 $ 117,874.00 $ 129,316.96 209.71% $ 331,232.00 (10,059.75) 91.89%_$ 124,063.00 114,003.25 $ 124,063.00 $ (10,059.75) 91.89% $ 124,063.00 12,089.78 $ 6,886.00 $ 5,203.78 175.57%_$ 9,750.20 3,749.44 1,146.15 51,489.00 17,000.00 4,530.91 11,266.85 5,675.76 21,755.57 27,431.33 1,053.79 $ 11,150.43 $ 10,373.48 19,968.00 3,500.00 23,468.00 7,500.00 3,000.00 7,000.00 4,012.00 52,000.00 17,000.00 1,500.00 15,000.00 6,700.00 68,000.00 1,100.00 4,000.00 (3,500.00) 1,703.78 116.40% (781.46) 89.58% 2,239.25 234.09% (3,149.75) 55.00% (4,012.00) 26,458.94 188.20% 1,000.00 106.67% 347.46 132.78% (960.00) 15,177.59 15277.59% 6,688.00 (3,500.00) 0.00%$ 9,750.20 $ 12,089.78 $ 10,386.00 6,718.54 $ 3,909.25 $ 3,850.25 56,458.94 16,000.00 1,407.46 15,277.59 6,688.00 69,222.80 838.20 $ 9,535.28 0.00% 0.00% $ 0.00% #DIV/O! $ 0.00% $ 89,182.35 $ 103,622.03 $ 69,562.00 $ 34,060.03 148.96% $ 107,012.00 Services-F Regular 62,534.80 $ 28,180.00 $ 34,354.80 221.91%_$ 31,680.00 $ 37,542.80 218.51% 74,700.00 (661.80) 55.88% 5,535.28 238.38%$ 4,873.48 188.61% 5,100.00 (7,463.00) (7,463.00) 0.00%_$ 0.00% $ 16,039.21 $ 16,039.21 57,171.12 4,214.21 110.00 $ 61,495.33 11,730.58 11,730.58 27,703.80 $ 1,425.93 377.09 29,506.82 750.00 $ 10,980.58 1564.08%_$ 750.00 $ 10,980.58 1564.08% 5,000.00 1,000.00 $ 26,703.80 2770.38% 4,800.00 $ 24,706.82 614.73% 28,000.00 5,000.00 25,000.00 2,500.00 500.00 3,800.00 (2,374.07) 37.52% 377.09 #DIV/O! $ 0.00%) 116,600.001 (116,600.00)! Total Transfers Total Administration Grand Total 0I- Generall Fund (Expense) 12-MunicipalCourt Personnel 12-7004) Judge 12-7011 Salaries and Wages 12-7021 State Unemployment Taxes SUI 12-7032H Health Insurance 12-70336 Employee Retirement 12-9201 Traininga andE Education Total Personnel Other Sources 12-7022F Federal Payroli Taxes- FICA Total Other Sources Miscellaneous 12-7801 Court Costs, Fines, &Fees 12-8400F Prosecutor Expense 12-8401 LegalE Expenses 12-8701F Postage Fees8 & Subscriptions 12-92511 TravelE Expense Total Miscellaneous Supplles 12-8551 Office Supplies Total Supplies Contractual 12-8951 Sortware Agreements Total Contractual Total Municipal Court Grand Total 0- Generall Fund (Expense) 13-Police Personnel 13-7011 Salaries and Wages 13-7021 State Unemployment Taxes- SUI 13-7032 Health Insurance 13-7033E Employee Retirement 13-7038 Department Overtime (OT) 13-92011 Training andE Education Total Personnel Other Sources 13-7022 Federal Payroll Taxes FICA Total Other Sources Miscellaneous 13-7120A Animal Control Officer and Related Expenses 13-7155 Code Abatement 13-7160 Community Development & Support 13-7951 Dues and Membership Fees 13-82041 Liability Insurance General Liability 13-8501 Miscellaneous Expense 13-8701 Postage Fees8 & Subscriptions $ 13-92511 Travel Expense Total Miscellaneous Capital 13-7401 Capital Expenditures Total Capital 116,600.00 I$ (116,600.00) 0.00%] 390,366.901 597,739.70115 488,67B.001E5 109,061.70 122.32%5 698,575.00 390,366.90 597,739.7015 488,678.0015 109,061.70 122.329 698,575.00 FV2 2022-2023 FY 2023-2024 Vear FY 2023-2024 Budget Balance %Balance Proposed FY: 2024- FV 2023-2024 FY 2023-2024 Remaining 461.54 #DIV/O! $ (90,513.06) (687.54) (23,166.00) (7,265.00) (200.00) (6,996.48) (62,832.35) 13.21% $ 1,277.50 #DIV/O! (1,950.00) (200.00) 450.00 #DIV/0!$ Actuals To Date Actuals Budget 461.54 5,076.94 12.46 5,550.94 388.52 388.52 9,567.65 1,277.50 50.00 450.00 189.32 189.32 Remaining/2025 Budget 5.31%$ 1.78% 0.00% 0.00% 0.00% 5.26%_$ 5.26%$ 2.50% $ 0.00% 6.31%_ 6.31%$ 0.00% 2,400.00 270.00 184.00 184.00 9,500.00 1,500.00 500.00 500.00 6,000.02 11.98 105.00 6,117.00 459.16 459.16 (148.12) $ 95,590.00 700.00 23,166.00 7,265.00 200.00 7,385.00 7,385.00 $ (6,996.48) 72,400.00 2,000.00 200.00 126,921.00 (121,370.06) 4.37% $ 2,670.00 (148.12) $ 11,345.15 74,600.00 $ (63,254.85) 15.21%$ 12,000.00 3,000.00 $ (2,810.68) 3,000.00 $ (2,810.68) 10,440.00 (10,440.00) 10,000.00 10,440.00 (10,440.00) 0.00%5 10,000.00 6,428.04 7,473.935 222:346.0055 (204,872.07) 7.86%5 24,854.00 6,428.045 17,473.939 222,346.0057 (204,872.07)1 7.86%5 24,854.00 FV: 2022-2023 FY 2023-2024 Year FV 2023-2024 Budget Balance %Balance. Proposed FY 2024- $ 217,135.75 $ 158,013.27 $ 223,810.00 $ (65,796.73) 70.60% $ 340,964.01 FV2023-2024 FV: 2023-2024 Remaining Actuals ToD Date Actuals Budget Remaining/2025 Budget 6.62% 0.00% 9.08% 82.80 35,302.39 16,246.87 363.48 $ 269,131.29 16,610.84 16,610.84 660.00 3,200.00 $ 2,474.36 $ $ 655.37 $ 6,989.73 20,279.64 67.48 23,896.68 16,320.33 237.96 12,088.04 12,088.04 780.00 3,950.00 2,416.02 165.00 594.05 880.45 19,402.44 1,020.00 46,613.00 16,600.00 2,620.00 15,910.00 (952.52)! (22,716.32)! 51.27% (279.67) 98.32% (2,382.04) 200.00 53,192.00 31,486.00 4,992.85 9,800.00 198,535.72 $ 290,663.00 $ (92,127.28) 68.30% $ 435,642.01 (3,821.96)! 75.98%_$ 26,084.00 15,910.00 $ (3,821.96) 75.98% 1,200.00 $ (420.00) 65.00% 7,000.00 $ (4,583.98) 500.00 12,260.00 $ (12,260.00) 750.00 $ 660.00 $ 11,000.00 26,084.00 1,000.00 3,000.00 1,000.00 17,316.00 500.00 22,816.00 30,000.00 3,950.00 #DIV/O! 34.51% (335.00) 33.00% 0.00% $ 594.05 #DIV/0! * 130.45 117.39% (660.00) 0.00% 8,402.44 176.39%_$ 8,785.52 $ 22,370.00 $ (13,584.48) 39.27% 20,279.641 19,402.4419 11,000.00 $ 8,402.44 176.39% 30,000.00 Utilities 13-7451 Cellular Phones and Pagers $ 13-9151 Telephone &1 Internet Services! $ 13-9352 Purchased Gas Power Total Utilities Contractual 13-7651 Contract Services-Regularly Scheduled 13-8951 Sortwarer Maintenance Agreements Total Contractual Supplies 13-8030 Equipment Purchases 13-8551 Office Supplies 13-9101 Operating Supplies Not Office 13-9301 Uniform Expense Total Supplies Repair & Maintenance 13-8051 Equipment 13-8101 Fuel& Oil 13-8851 Facility Maintenance 13-9401 Vehiclel Maintenance Total Repair & Maintenance Debt Service 13-82511 Interest Expense Total Debt Service Total Police Grand Total 01- General Fund (Expense) 14-Fire Utilities 14-7451 Cellular Phones & Pagers $ 14-91511 Telephone &1 Internet Services_$ 1,433.55 $ Total Utilities Supplies 14-7501 Chemicals 14-8030 Equipment Purchases 14-8451 Medicals Supplies 14-9101 Uperating Supples Not Office Total Supplies Repair B Maintenance 14-7657 Fire Hydrant Inspections 14-8051 Equipment Maintenance 14-8101 Fuel&Oil 14-8851 Facility! Maintenance 14-9401 Vehicle! Maintenance Total Repair &N Maintenance 14-7951 Dues and Membership Fees 14-8204 Labinty Insurance- General Liability Total Personnel 14-92011 Training and Education Total Personnel Total Fire Grand Total 01- Generall Fund (Expense) 15-Parks andRecreation. 3,815.43 $ 3,051.37 4,208.87 504.73 $ 8,529.03 $ 7,884.19 2,530.00 $ 4,050.00 750.00 7,330.00 6,000.00 3,240.00 9,240.00 4,750.00 4,650.00 2,420.00 5,200.00 13,360.00 5,500.00 940.00 521.37 120.61% 52.34 101.29% (19.52) 97.40% 554.19 107.56% $ 8,450.00 3,600.00 4,100.00 750.00 4,102.34 730.48 (6,000.00) 1,368.37 142.23% (4,631.63) 49.87% $ 4,600.00 (3,988.04) 16.04% $ (4,393.95) (2,420.00) (8,056.99) 52.10% 12,200.00 (5,175.00) (9,848.05) 646.59 #DIV/O! (5,283.00) (940.00) 0.00%_$ 3,577.45 3,577.45 2,055.42 1,039.63 702.54 361.28 9,265.88 688.67 3,457.39 13,773.22 4,608.37 4,608.37 7,745.00 761.96 256.05 25.00 3,511.95 646.59 217.00 4,400.54 4,600.00 5,000.00 1,000.00 5,000.00 1,200.00 300.00 10,000.00 700.00 8,000.00 5,000.00 $ 2,745.00 154.90% 5.51% $ 0.00%_$ 0.48%$ 26.29% $ 3.95%_$ 0.00% 3,797.59 $ 8,763.01 $ 16,820.00 24,060.00 $ (19,659.46) 18.29% 19,000.00 940.005 (940.00) 0.00%5 FV: 2023-2024 FY: 2023-2024 Remaining 600.00 1,000.00 5,000.00 3,000.00 2,500.00 342,688-797E 264,467.83 398,333.00 E(33,865:1771 66.39% 558,792.01 342,688.79 264,467.8319 398,333.00 (133,865.17) 66.39% 558,792.01 FY 2022-2023 FV 2023-2 -2024) Vear FY 2023-2024 Budget Balance % Balance. Proposed FV 2024- Remaining2025 Budget Actuals To Date Actuals Budget 600.92 $ 2,034.47 $ 2,059.33 1,570.00 5,391.99 $ $ 3,460.24 $ 18,521.02 $ 10,422.23 $ 28,033.37 14,501.28 6,651.74 275.00 618.40 $ 22,046.42 536.42 $ 1,522.91 $ 9,512.35 9,401.99 2,599.26 77.16 674.73 12,753.14 4,908.75 $ 4,908.75 2,412.00 1$ (63.58) 89.40% $ (1,000.00) 0.00% (5,000.00) 0.00% 9,512.35 #DIV/O! $ (3,000.00) 0.00% 9,401.99 #DIV/O! 99.26 103.97% 77.16 #DIV/O! 600.00 1,800.00 2,400.00 10,000.00 3,000.00 10,000.00 2,500.00 200.00 5,000.00 1,000.00 13,000.00 2,500.00 3,380.00 $ (1,857.09)! 45.06%_$ 3,980.00 $ (1,920.67) 51.74% $ 2,500.00 $ 16,021.02 740.84% 8,500.00 $ 19,533.37 329.80% $ 10,000.00 5,000.00 $ (4,325.27) 13.49%_$ 10,500.00 $ 2,253.14 121.46% 20,700.00 1,000.00 $ 3,908.75 490.88% $ 12,221.00 $ (12,221.00) 13,221.00 $ (8,312.25) 37.13% 1,500.00 0.00%_$ 12,000.00 912.00 160.80%_$ 2,412.005 1,500.00 912.00 160.80% 2,500.00 34,503.12 50,166.595 37,701.005 12,465.59 133.0695 48,600.00 34,503.12 50,166.59 37,701.00 12,465.59 133.069 48,600.00 FV 2023-2024 FY 2023-2024 Budget Balance % Balance. Proposed FV 2024- Remaining FY 2022-2023 FY: Actuals Year FV To Date Actuals Budget Remaining 2025 Budget Personnel 15-7011 Salaries and Wages 15-7013F Pool Manager 15-7021 State Unemployment" Taxes- SUI 15-7032H Health Insurance 15-7649 On-Call Compenssation 15-9201 Training andE Education Total Personnel Other Sources 15-7022 Federal Payroll Taxes FICA $ 6,721.65 Total Other Sources Supplies 15-7501 15-9101 Chemicals uperating Supples -Not Office Totals Supplies Repair8 & Maintenance 15-8051 Equipment Maintenance 15-8851 Facility Maintenance Total Repair & Maintenance Utilities 15-91511 Telephone &I Internet Services! Total Utilities Total Parks and Recreation Grand Total 01- Genera Fund (Expense) 16-Public Works. Personnel 16-7011 Salaries andy Wages 16-7021 State Unemployment Taxes- SUI 16-9201 Training and Education Total Personnel Other Sources 16-7022 Federal Payroll Taxes FICA Total Other Sources Supplies 16-7501 Chemicals 16-9101 Operating! Supplies Not Office 16-9301 Uniform Expense Total Supplies Repair & 16-8051 Equipment Total Repair Maintenance Miscellaneous 16-82041 Liabinity insurance- General Liability Totall Utilities 16-91511 Telephone &1 Internet Services_s Total Total Public Works Grand Total 01- General Fund (Expense) 17-Streets Supplies 17-7501 Chemicals Total Supplies Repair & Maintenance 17-8051 Equipment Maintenance 17-8854 Street Repair & Maintenance Total Repair8 & 85,924.85 61.04 17,560.62 1,940.00 105,486.51 $ 103,771.39 $ 6,721.65 $ 1,684.84 $ 224.22 1,909.06 $ 3,364.71 $ 1,152.60 1,152.60 620.86 620.865 81,989.04 100.00 85.79 18,446.56 2,400.00 750.00 6,455.84 $ 6,455.84 $ 2,422.64 $ 942.07 $ 425.43 $ 2,978.36 3,403.79 $ 668.54 668.545 21,000.00 60,989.04 390.42% 100.00 #DIV/O! 85.79 #DIV/O! 18,446.56 #DIV/O! 2,400.00 #DIV/O! 750.00 #DIV/O! 6,455.84 #DIV/O! 6,455.84 #DIV/0! $ 2,422.64 #DIV/O! $ 942.07 #DIV/O! $ 3,364.71 #DIV/OI $ 3,500.00 425.43 #DIV/O! 2,978.36 #DIV/O! 3,403.79 #DIV/OI 668.54 #DIV/O! 668.54 #DIV/oS FV:2023-2024 FY 2023-2024 Remaining 20,160.00 $ (20,160.00) 570.00 800.00 12,960.00 5,400.00 85.00 750.00 21,000.00 $ 82,771.39 494.15% $ 19,195.00 2,500.00 1,000.00 500.00 3,000.00 3,500.00 700.00 700.00 115,890.68 117,664:2735 21,000.00 96,664.27 560.31%5 26,895.00 115,890.685 117,664.275 21,000.00 96,664.27 560.31% 26,895.00 FV2 2022-2023 FY 2023-20241 Vear FV2 2023-2024 Budget Balance % Balance Proposed FY: 2024- Actuals To Date Actuals Budget Remaining/2025 Budget 0.00% 0.00% 0.00% 0.00% 0.00%$ 0.00% 0.00%_$ 0.00%_$ 0.00% 0.00% 100.00% $ (570.00) (800.00) $ 21,530.00 $ (21,530.00) 0.00% $ 1,553.00 s (1,553.00) 1,553.00 3,000.00 500.00 400.00 3,900.00 600.00 600.00 7,104.00 870.00 900.00S (1,553.00) 0.00% (3,000.00) (500.00) (400.00) (600.00) (7,104.00) (870.00) 3,000.00 500.00 3,000.00 2,000.00 (3,900.00) 0.00% $ 6,500.00 (600.00) 0.00%$ 2,000.00 7,104.00 $ (7,104.00) 0.00% $ 900.005 900.00 900.005 900.005 900.00 9,400.00 900.0015 35587005 (34,68700) 2.5545 900.00 35,587.005 (34,687.00) 2.53% 9,400.00 FY2 2023-2024 FY: 2023-2024 Remaining 600.00 (600.00)! 600.00 (600.00) 0.00% 1,500.00 (1,500.00) 26,000.00 FV 2022-2023 FY 2023-2024 Year FV 2023-2024 Budget Balance % Balance Proposed FY 2024- Actuals ToDate Actuals Budget Remaining!: 2025 Budget 0.00%_$ 0.00% $ 1,500.00 18,894.32 $ 11,879.29 (14,120.71) 45.69%_$ 19,000.00 18,894.32 11,879.297 27,500.00 $ (15,620.71) 43.20% 20,500.00 Miscellaneous 1/-82041 LiaDinity Liability Total Miscellaneous Total Streets Grand Total 01-3 seneral Fund (Expense) 18-Library Personnel 18-7011 Salaries and Wages 18-7021 State Unemployment Taxes- SUI 18-7032 Health Insurance 18-70336 Employee Retirement Total Other Sources 18-7022 Federal Payroll Taxes- FICA Total Other Sources Miscellaneous 18-7701 Books, Movies, Subscriptions $ 18-8701 Postage Feesas Subscriptions $ Total Miscellaneous Repair & 18-8051 Equipment 18-8851 Facility Maintenance 18-8953 Copier Service Total Repair & Supplies 18-8551 Office Supplies Total Supplies Utilities 18-9151 Telephone &1 Internet Services Total Utilities Totallbrary Grand Total 01- Generallrund (Expense) 20-Baseball Complex Contractual 20-7651 Contract Services Total Contractual Supplies 20-9102 100Is & Non-Capital Equipment Total Supplies Utilities 20-9351 Purchased Water Total Utilities Total Baseball Complex Grand Total 01-General Fund (Expense) 70-Electic Personnel 70-7011 Salaries andV Wages (ClassB Lineman, Apprentice) 70-7021 State Unemployment" Taxes- SUI 70-7032 Health Insurance 70-7033E Employee Retirement 70-7 -70380 Department Overtime (OT) Total Personnel Other Sources General 771.00 (771.00) 0.00% 771.005 (771.00) 0.00%5 FY 2023-2024 FV 2023-2024 Remaining $ 34,463.46 $ 22.50 9,223.28 3,762.61 47,471.85 #DIV/OI $ 2,636.46 2,636.46 #DIV/O! $ 235.00 45.00 637.63 566.13 18,894.32 11,879.295 28,871.005 (6,991.71) 41:15%5 20,500.00 18,894.32 FV Actuals 11,879.29 28,871.009 (6,991.71) 41.15%5 20,500.00 Y2023-2024Year FY2023-2024 Budget Balance % Balance. Proposed FY 2024- To Date Actuals Budget 40,259.62 $ 34,463.46 $ 20.70 9,570.06 3,021.73 52,872.11 $ 47,471.85 3,079.83 3,079.83 3,185.55 135.00 3,320.55 10,038.16 1,020.97 2,041.94 Remaining/2025 Budget #DIV/O! $ #DIV/O! $ #DIV/O! #DIV/O! #DIV/O! #DIV/O! #DIV/O! $ #DIV/O! #DIV/O! 22.50 9,223.28 3,762.61 $ 2,636.46 2,636.46 3,164.39 $ 235.00 $ 3,399.39 $ 45.00 $ 637.63 $ 566.13 $ 1,177.26 $ 154.64 $ 154.64 $ 4,264.39 600.00 $ 2,564.39 527.40% $ 2,500.00 300.00 200.00 700.00 600.00 200.00 200.00 2,000.00 2,000.00 6,400.00 600.00 2,799.39 566.57% $ 2,800.00 1,177.26 #DIV/0! $ 1,400.00 154.64 #DIV/O!S 154.64 #DIV/01 4,264.39 4,264.39 #DIV/OHS 600.00 IE 58,503.99 9850.67905 600.00 58,503.99 9850.679 6,400.00 FV 2023-2024 FY 2023-2024 Remaining 15,625.00 #DIV/O! 15,625.00 #DIV/0IS 15,600.00 230.29 #DIV/O! $ 230.29 #DIV/0I (2,151.19) #DIV/O! $ (2,151.19) #DIV/ODS 2,300.00 13,704.10 #DIV/OIS 18,150.00 13,704.10 #DIV/0IS 18,150.00 FV: 2023-2024 FY 2023-2024 Remaining 2,118.38 5.30 838.48 260.77 2,549.84 2,549.84 4,264.39 63,864.275 59,103.997155 63,864.279 59,103.999 #DIV/O! FV 2022-2023 FV 2023-2024 Vear FV 2023-2024 Budget Balance %Balance Proposed FV: 2024- Actuals 15,600.00 $ 15,600.00 To Date Actuals Budget 15,625.00 15,625.00 230.29 230.29 $ (2,151.19) Remaining/2025 Budget 15,600.00 250.00 250.00 2,300.00 (1,618.75) (,618.75) (2,151.19) 13,981.255 13,704.105 13,981.25 13,704.105 FY Actuals $ 36,242.50 $ 20.70 2,787.06 39,050.26 $ 3,222.93 FY2 2023-2024Vear FY 2023-2024 Budget Balance %Balance Proposed FY 2024- To Date Actuals Budget 2,118.38 $ 5.30 838.48 260.77 Remaining/2025 Budget #DIV/O! $ 174,465.00 #DIV/O! #DIV/O! #DIV/O! 0.00%$ 19,632.00 6,961.65 100.00 31,915.00 3,222.93 #DIV/OI $ 233,073.65 70-7022 Federal Payroll Taxes FICA Total Other Sources Total Electric Grand Total 01-G General Fund (Expense) B0-Water Personnel 80-7009T Team Leader 80-7011 Salaries andy Wages 80-7021 State Unemployment" Taxes- SUI 80-7032H Health Insurance 80-7 7033 Employee Retirement 80-7650 Over Time 80-92011 Training and Education Total Personnel Other Sources 80-7 7022F Federal Payroll Taxes FICA Total Other Sources Total Water Grand Total o- General Fund (Expense) 81-Sewer Personnel 81-7011 Salaries andy Wages 81-7021 State Unemployment Taxes- $ SUIS 81-7032 Health Insurance 81-70336 Employee Retirement Total Personnel Other Sources 81-7022 Federal Payrolil Taxes FICA Total Other Sources Total Sewer Grand Total TotalExpense 2,772.57 2,772.57 41,822.83 3,384.985 41,822.83 3,384.98 162.05 162.05 162.05 #DIV/O! 13,347.00 162.05 #DIV/OI 13,347.00 3,384.98 #DIV/OHES 246,420.65 3,384.98 #DIV/0! 246,420.65 FY 2023-2024 FY: 2023-2024 Remaining 14,342.70 #DIV/O! 37,617.00 45.00 11,319.48 1,771.41 47.25 FV: 2022-2023 FV 2023-20241 Vear FV 2023-2024 Budget Balance %E Balancel. Proposed FY: 2024- Actuals To Date Actuals Budget 14,342.70 37,617.00 45.00 11,319.48 1,771.41 47.25 3,978.53 Remaining2025 Budget #DIV/OL #DIV/O! #DIV/O! #DIV/O! #DIV/0! 66,691.90 41.41 15,372.27 $390,106.00 250.00 $85,107 $43,897 18,076.00 5,000.00 $29,843 $29,843 $ 82,105.58 $ 65,142.84 $ 5,173.87 5,173.875 3,978.535 87/279.45E 69,121.3715 $ 87,279.455 69,121.375 $ 65,142.84 #DIV/01 $ 537,436.00 3,978.53 #DIV/O! 3,978.53 #DIV/OI 69,121.37 #DIV/OIS 567,279.00 69,121.37 #DIV/O! 567,279.00 FV 2023-2024 FY 2023-2024 Remaining $ 92,125.90 #DIV/O! 45.00 18,446.56 9,948.73 120,566.19 #DIV/OH $ 7,047.63 7,047.63 #DIV/oI 17,613.82 DIV/OD 127,613.82 #DIV/ODS FY: 2022-2023 FY2023-2024 Vear FY 2023-2024 Budget Balance %E Balancel. Proposed FY 2024- Actuals To Date Actuals Budget Remaining/2025 Budget #DIV/O! #DIV/O! #DIV/O! #DIV/OI (Wastewater/Water Operations) $ 107,196.55 $ 92,125.90 $ 41.39 19,140.37 8,041.60 $ 134,419.91 $ 120,566.19 $ 8,200.56 8,200.56 7,047.635 142,620.47 127,613.8215 142,620.475 127,613.82 45.00 $ 18,446.56 9,948.73 ls 7,047.63 1,259,240.12 1,872,928.88 1,366,881.00 506,045.88 137.02% 2,292,865.66 Year1 To Date Actuals Actuals Budget 39,193.07 162,264.49 116,200.00 322,354.55 475,999.50 446,200.00 166,352.11 263,057.83 256,500.00 137,281.12 220,092.48 235,149.00 (15,056.52) 580.00 338,437.00 337,857.00 1,188,707.38 636,043.96 $ 802,032.97 593,907.00 (208,125.97) 135,275.24 253,148.32 94,460.00 (158,688.32) 141,327.29 142,530.33 90,457.72 202,149.00 $ (392,795.10) FY2023-2024 Actuals Actuals $ 210.00 $ $ $ 38,633.07 FY: 2023-2024 FY: 2023-2024 % Remaining 46,064.49 29,799.50 6,557.83 FY 2022-2023 (August 1st) FY2023-2024 Budget Balance 790,202.28 1,140,591.51 1,460,200.00 (319,608.49) $1,455,383.13 $2,262,005.81 $2,514,249.00 $(252,243.19) Balance Proposed FY 2024- Remaining 139.64% 78.11% 1,368,812.11 106.68% 102.56% 93.60% 89.97% $ 2,825,720.16 0.17% 75.72% 1,207,087.00 135.04% 268.00% 93.92% $ 2,671,120.65 -3.95% 154,599.51 Balance Proposed FV: 2024- Remaining 0.00% $ 34.95% $ 100.86% $ 60,000.00 95.05% $ 63,000.00 0.00% 0.00% 02- Utilities Fund (Summary) Revenue Summary 00: 70-Electric 80-Water 81-Sewer 84- arbae Revenue Totals Expense Summary 00: 70-Electric 80-Water 81-Sewer 34- arbae Expense Totals 2025 Budget 63,000.00 722,080.66 407,635.42 264,191.98 686,240.00 353,253.65 282,010.00 142,530.00 973,256.47 1,285,296.00 312,039.53 (142,530.33) #DIV/O! $2,101,353.87 $2,171,548.09 $2,312,100.00 $ 140,551.91 Revenues Over(Under) Expenditures $ (645,970.74) 02-4 Utilities Fund (Revenue) 00-6000 - Miscellaneous 00-6 6025 Returned Check Fees 00- 6404 Utility Connection Disconnection Fees UU-6415 w/WWIP IMPRV LOAN REPA MENT 00-6000- Total Miscellaneous 00-6400 -- Business &F Franchise 00-6410F Franchise Fees 00-6400- - Business & Franchise Total 00-6700 - Grant Income 00-6751 Grant Proceeds 00-6700- - Grant Income Total 02-00-- Total Grand Total 02-Utlltles Fund (Revenue) 70-Electric 70-6400 - Miscellaneous 70-6402 Utility Penalties 70-6400- 70-6430 Business & Franchise 70-6431 Municipal Light & Power Total Business & Franchise 70-Electric- Total Grand Total 02- -Utiihles Fund (Revenue) 80-Water 80-6400 - Business & Franchise 80-6401 Water 80-6402 Utility Penalties 80-6412 Water TapF Fees 80-6400- - Business & Franchise Total 80-- ater Total Grand Total 02- Utlitles Fund (Revenue) FV 2023-2024 FY 2023-2024 % Remaining $ (105.00) (520.13) 50,000.00 FY 2022-2023 Vear To Date FV 2023-2024 Budget Balance 00- Budget 105.00 $ 60,720.13 2025 Budget 3,000.00 350.00 $ 2,096.86 $ 6,000.00 $ 3,903.14 $ 39,193.07 $ 62,921.99 $ 66,200.00 $ 3,278.01 60,200.00 50,000.00 50,000.00 50,000.00 99,342.50 $ 99,342.50 FY 2023-2024 Actuals (10.48) $ (99,342.50) #DIV/O! (99,342.50)0.009 39,193.07 l$ 162,264.49 $ 116,200.00 $ (46,064.49) 39,193.075 162,264.49 116,200.00 $ (46,064.49) Vear ToDate FY 2023-2024 Budget Balance 139.64% $ 63,000.00 139.64%5 63,000.00 Balance! Proposed FV 2024- Remaining -3.01% $ -3.01% $ 79.07%_s 1,368,812.11 79.07% $ 1,368,812.11 78.11% $ 1,368,812.11 78.119 1,368,812.11 Balance Proposed FY 2024- Remaining 2025 Budget 97.26% $ 677,080.66 120.00% 106.68% $ 722,080.66 106.68% 722,080.66 106.689 722,080.66 FV: 2023-2024 FY2023-2024 % Remaining 17,000.00 $ 17,511.49 FY: Actuals Budget (511.49) 2025 Budget Total $ (10.48) $ (511.49) $ 17,000.00 $ 17,511.49 790,212.76 $ 1,141,103.00 $ 1,443,200.00 $ 302,097.00 790,212.76 $1,141,103.00 $1,443,200.00 $ 302,097.00 790,202.28 $1,140,591.51 $1,460,200.00 319,608.49 790,202.28 $1,140,591.51 $1,460,200.00 $ 319,608.49 FY: 2022-2023 Year To Date FY: 2023-2024 Budget Balance FY 2023-2024 Actuals Actuals Budget $ 280,932.56 424,236.15 436,200.00 31,421.99 39,763.35 10,000.00 12,000.00 10,000.00 FY 2023-2024 FV 2023-2024 % Remaining 11,963.85 (39,763.35) #DIV/O! (2,000.00) 35,000.00 10,000.00 $ 322,354.55 $ 475,999.50 446,200.00 $ (29,799.50) 322,354.55 $ 475,999.50 446,200.00 (29,799.50) 322,354.55 475,999.505 446,200.00 IS (29,799.50) FY 2023-2024 Actuals (4.08) 156,356.19 10,000.00 FY 2023-2024 FV 2023-2024 % Remaining 87.75 #DIV/O! (2,645.58) (4,000.00) FY 2022-2023 Vear ToDate FV 2023-2024 Budget Balance Balance Proposed FV 2024- Remaining 2025 Budget 101.07% 397,635.42 140.00%_$ 10,000.00 102.56% 407,635.42 102.56%s 407,635.42 102.569 407,635.42 Balancel Proposed FY 2024- Remaining 2025 Budget 93.63% 264,191.98 93.60% 264,191.98 93.60% 264,191.98 93.60% 264,191.98 89.97%s 2,825,720.16 Balancel Proposed FV 2024- Remaining 0.00% $ 0.00% 0.00% 0.00% 0.00% 0.00% $ 0.00% 0.00% $ 9.67% $ 0.00% $ 9.29% 0.00% $ 0.00% $ 0.00% $ 0.00%_$ 680,000.00 0.00% 680,000.00 0.00% 0.00% 0.17% 686,240.00 0.17%05 686,240.00 Balance Proposed FY 2024- Remaining! 14.11% $ 7.32% $ 14.48% 23.74% 0.00% 5.33% 13.85%$ 218,657.00 81-Sewer Actuals Budget (87.75) 249,145.58 246,500.00 14,000.00 10,000.00 FY: 2023-2024 Actuals 81-6400 -- Business & Franchise 81-6402 Utility Penalties 81-6411 Wastewater 81-6412 Sewer Tap Fees 81-Se erl Total Grand Total 02-Utlitles Fund (Revenue) 84- arbae 84-6400- - Business &F Franchise 84-6402 Garbage Late Penalties $ 84-6421 Garbage Revenue 84-- Garbage Total Grand Total 81-6400- Business &F Franchisel Total $ 166,352.11 263,057.83 256,500.00 $ (6,557.83) 166,352.11 $ 263,057.83 256,500.00 (6,557.83) $ 166,352.115 263,057.8319 256,500.005 (6,557.83) FV 2022-2023 Vear ToDate FV2023-2024 Budget Balance FV: 2023- 2024 FV: 2023-2024 % Remaining 67.50 #DIV/O! 235,149.00 $ 14,989.02 Actuals Budget (67.50)! $ $ 137,281.12 $ 220,159.98 84-6400- - Business & Franchise Total $ 137,281.12 $ 220,092.48 $ 235,149.00 $ 15,056.52 02--U Utitility Fund Total Revenue 1,455,383.13 $2,262,005.81 2,514,249.00 252,243.19 137,281.12 $ 220,092.48 $ 235,149.00 15,056.52 137,281.12 220,092.48 235,149.00 15,056.52 02-Utitest Fund (Expense) 00- 00-7000 -- Personnel 00-7003 Utility Clerk 00-7011 Salaries andy Wages 00-7021 State Unemployment Taxes SUI 00-7032 Health Insurance 00-7033 Employee Retirement $ 00-7000- - Personnel Total 00-7022 - Other Sources 00-7022 Federal Payroll Taxes FICA $ 00-7022- Other Sources Total 00-7600 & 00-8 8952 Contractual 00-7651 Contract Services- Regularly Scheduled 00-8 8952: Software Licenses 00-7600 & 00-8952 - Contractual Total 00-8551 & 00-9101 Supplies 00-8551 Office Supplies uperating suppies NOt Office 00-8551 & 00-9101 - Supplles Total 00-9253 = Transfers 00-9253 Interfund Transfer Out 00-9253. Transfers Total 00-9351- Purchased Water 00-9351 Purchased ater Total 00-Personnel- Total Grand Total 02-U Utlities Fund (Expense) 70-Electric 70-7000 - Personnel 70-7011 Salaries andy Wages 70-7021 State Unemployment Taxes SUI 70-7032 Health Insurance 70-70336 Employee Retirement 70-7040 PayrollF Reimbursement 70-9201 Training andE Education 70-7000 &7 70-9201 - FY 2023-2024 Actuals $ 0.00 $ FV 2023-2024 FV: 2023-2024 % Budget Remaining $ 3,000.00 $ 3,000.00 $ 39,785.00 $ 39,785.00 $ 260.00 $ 11,583.00 3,112.00 $ 57,740.00 $ 57,740.00 2,982.00 $ 2,982.00 $ 2,982.00 $ 2,982.00 580.00 $ 6,000.00 $ 5,420.00 240.00 $ 240.00 6,240.00 $ 5,660.00 3,000.00 $ 3,000.00 100.00 $ 3,100.00 $ 3,100.00 267,375.00 $ 267,375.00 267,375.00 $ 267,375.00 1,000.00 1,000.00 $ 1,000.00 FV: 2022-2023 Vear ToDate FY: 2023-2024 Budget Balance Actuals $ $ 0.00 2025 Budget 260.00 11,583.00 3,112.00 6,000.00 240.00 6,240.00 $ $ 580.00 100.00 1,000.00 $ 580.00 338,437.00 $ 337,857.00 580.00 338,437,.00115 337,857.00 FY 2023-2024 Actuals Actuals $ 41.39 13,719.42 2,717.15 $ 2,060.98 1,939.00 Total 151,154.61 22,994.26 FY 2023-2024 FV 2023-2024 Remalning 505.00 23,156.00 8,680.00 15,000.00 166,021.00 143,026.74 FV 2022-2023 Vear To Date FY 2023-2024 Budget Balance $ 132,737.65 $ 16,742.38 $ 118,680.00 $ 101,937.62 Budget 36.98 3,353.92 800.00 2025 Budget 468.02 19,802.08 6,619.02 14,200.00 $218,657 Other Sources 70-7022 Federal Payroll Taxes FICA Total Other Sources 70-74518 & 70-9000 Utilities 70-7451 Cellular Phones &F Pagers 70-9321 Light and Power 70-93221 TCOS 70-74518 & 70-9000 - Utilities Total 70-7600 &7 70-8952 Contractual 70-7651 Contract Services- Regularly Scheduled 70-7652 Contract Services- Emergency 70-7654 Engineering: Services 70-8952 Software Licenses 70-7600 &7 - 70-8100, 70-9400, 70-9500 Repair8 & Maintenance 70-8101 Fuel andOir 70-9401 Vehicle Maintenance 70-9501 Electric Meters 70-9503 Lines, Poles, & Transformers 70-8100, 70-9400, 70-9500- Repair & Maintenance Total 70-8204 &7 70-8751 - Miscellaneous 70-8204 Liability Insurance- General Liability 70-8751 Purchased Power 70-8204 &: 70-8751 - Miscellaneous Total 70-8250- Debt Service 70-8251 InterestE Expense 70-8250- Debts ServiceTotal Debt Service 70-8451, 70-8551, 70-9100, 70-9300- Supplies 70-8451 Medical Supplies 70-8551 Office Supplies 70-9101 Operating Supplies Not Office 70-91021 Tools & Non-Capital Equipment 70-9301 UniformE Expense 70-8451, 70-8551, 70-9100, 70-9300 Sunnlies Total 70-9256- Transfers 70-92561 Transfer from Utilities to 185 70-9256- Transfers Total 70-Electric- Total Grand Total 02-URlItles Fund (Expense) B0-Water. 80-7000 & 80-9201 - Personnel 80-7011 Salaries andy Wages 80-7021 State Unemployment Taxes- SUI 80-7032 Health Insurance 80-7033E Employee Retirement 80-7040F Payroll 80-92011 Training and Education 80-7000 & 80-9201 - Personnel Total 80-7022 - Other Sources 80-7022- - Other Sources Total 80-7400- Capital 80-7 7401 Capital Expenditures 80-7400- - Captial Total 80-7451 & 80-9154 Utilities 80-7451 Cellular & Pagers 10,154.44 $ 1,280.81 $ 8,320.00 7,039.19 7,039.19 630.00 12,000.00 75,617.10 15.39% 15.39% 0.00% 0.00% 57.99%$ 120,000.00 54.19%$ 120,000.00 143.69% $ 90,000.00 145.74% 296.01% 0.00% 181.88% $ 140,000.00 6.36% 13.89% 5.46% 28.22% $ 22,500.00 0.00% 89.04% 555,000.00 84.94% $ 580,000.00 0.00% 0.00% 0.00% $ 0.00% $ 3357.20% $ 45,500.00 9.01% 6.05%_$ 2,000.00 691.04% $ 48,000.00 0.00% 0.00% 75.7411307087.00 75.7295 1,207,087.00 Balance Proposed FY 2024- Remaining 2025 Budget 15.09% 1.74% 15.94% 0.00% 0.00% 0.00% 14.35% $ 233,073.65 19.56% 19.56% $ 103.57% 103.57% $ 15,000.00 335.29%($ $ 10,154.44 1,280.81 8,320.00 630.00 12,000.00 104,382.90 $ 180,000.00 104,382.90 $ 192,630.00 88,247.10 $ 27,743.58 $ 129,321.82 5,864.43 90,000.00 $ (39,321.82) 30,000.00 $ (13,722.62) 40,000.00 (78,405.70) 240.00 15,000.00 $ 14,046.11 5,000.00 88,095.00 $ 83,283.45 25,620.00 $ 25,620.00 530,000.00 9,100.00 $ 9,100.00 $ 9,100.00 $ 9,100.00 500.00 $ 500.00 300.00 $ 2,000.00 3,040.00 77,930.00 77,930.00 77,930.00 43,722.62 118,405.70 953.89 694.54 24,049.76 4,811.55 50,000.00 10,000.00 4,000.00 3,500.00 5,000.00 25,000.00 240.00 4,305.46 (24,049.76) #DIV/O! Total $ 33,608.01 $ 291,450.14 $ 160,240.00 $(131,210.14) $ 10,179.62 21,405.13 3,523.84 $ 35,108.59 $ 30,509.74 108,095.00 $ 77,585.26 790,293.28 $ 471,916.40 58,083.60 790,293.28 $ 471,916.40 555,620.00 $ 83,703.60 $ $ $ 300.00 1,819.79 2,855.99 77,930.00 $ 165,801.28 $ 50,358.00 $ 1,500.00 $ (48,858.00) $ 168,388.45 $ 50,722.22 * 7,340.00 $ (43,382.22) $1,188,707.38 $ 973,256.47 $1,285,296.00 $ 312,039.53 $1,188,707.38 $ 973,256.47 $1,285,296.00 312,039.53 FY2 2022-2023 Vear To Date FV 2023-2024 Budget Balance 2,587.17 180.21 184.01 500.00 77,930.00 77,930.00 Actuals Actuals $ 56,604.00 $ 20.69 8,780.31 Budget 48,376.80 $ 320,690.00 21.95 9,223.28 Remaining 272,313.20 1,238.05 48,641.72 19,780.00 2,000.00 15,251.43 (462.01) 1,500.00 1,260.00 57,865.00 19,780.00 2,000.00 18,960.00 12,950.00 5,029.42 233,073.65 $ 65,405.00 $ 57,622.03 9 401,595.00 $ 343,972.97 $ 4,330.29 $ 3,708.57 $ 18,960.00 $ 15,251.43 $ 29,430.44 $ 13,412.01 $ 12,950.00 $ (462.01) 80-7022 Federal Payroll Taxes- FICA $ 4,330.29 3,708.57 $ 29,430.44 13,412.01 7,176.20 15,000.00 5,000.00 (3,529.42)! 80-9151 Services 80-74518 & 80-9154- - 80-7501, 80-8551, 80-9100, 80- 9301 -- Supplies 80-7501 Chemicals 80-8551 Office Supplies 80-9101 Operating Supplies Not Office 80-91027 Tools & Non- Capital Equipment 80-9301 Uniform Expense 80-7501, 80-8551, 80-9100, 80-9301 Sunnlles Total 80-7650, 80-8351, 80-8952 Contractual 80-7651 Contract Services- Regularly Scheduled 80-76545 Engineering Services 80-8351 Equipment Rental 80-8952 Software Licenses 80-7650, 80-8351, 80-8952- Contractual Total 80-7653, 80-8051, 80-8101, 80- 8851, 80-9401, 80-9502 : Repair & 80-7 7653) Water Tank Repair and Maintenance 80-8051 Equipment Maintenance 80-8101 Fuel and Oil 80-8851 Facility Maintenance 80-9401 Vehicle Maintenance 80-9502 Wells, Lines, & Meters 80-7653, 80-8051, 80-8101, 80-8851, 80-9401, 80-9502 Repalr & 80-7951, 80-9251, 80-9 9400 - Miscellaneous 80-7 7951 Dues and Membership Fees 80-9251 Travel Expense 80-9451 Sample Analysis 80-9471 Water System Fees 80-7951, 80-9251, 80-9400- Total 80-8250 - Debt Service 80-8251 Interest Expense 80-8250- Debt Service Total 80-9250 - Transfers 80-92561 Transfer from Utilitiest to 185 80-9250- - Transfers Total 80- ater-Total Grand Total 02-Utlitles Fund (Expense) 81-Sewer. 81-7401-- Capital 81-7401 Capital Expenditures 81-7401- - Capitall Total 81-7501, 81-8030, 81-8451,81- 9100- -- Supplies 81-7501 Chemiçals 81-8030 Equipment Purchases 81-8451 Medical Supplies 81-8551 Office Supplies 81-9101 Operating! Supplies -Not Office 81-4102 T00IS & Non-Lapital Equipment 81-7501, 81-8030, 81-8451, 81-9100-- Sunnlies Total 81-7650 81-7651 Contract Services- Regularly Scheduled 81-7652 Emergency 81-7654 Engineering Services 81-8351 Equipment Rental 81-7650 &81-8351 - Contractual Total Contractual 81-8051,81-8101, 81-9401 - Repair & Maintenance 81-8051 Equipment Maintenance 81-8101 Fuel and Oil 81-9401 Vehicle Maintenance 81-8051, 81-8101, 81-9401 - Repair & Maintenance Total &I Internet Total 1,152.80 1,330.69 119.99 24,558.54 2,787.81 4,262.35 54,000.00 473,619.60 1,869.78 480.00 (850.69) 12,000.00 (1,770.33) (119.99) #DIV/OI 2,000.00 $ (22,558.54) 2,000.00 (787.81) 3,920.00 (342.35) 42,702.00 (11,298.00) 5,000.00 (468,619.60) (1,869.78) #DIV/OI 240.00 240.00 (481,547.38) 277.23% 321.22% $ 6,000.00 114.75% 1227.93%_$ 139.39% 108.73%_ 228.41% $ 45,500.00 126.46% 9472.39%$ 0.00% 1104.44% $ 127,000.00 113.15% 2855.25% 252.78% 136.95% 242.29% $ 134,000.00 67.84% 710.90% $ 18,700.00 0.00%_ 0.00% 0.00%_$ 0.00% $ 29,880.00 135.04% $ 353,253.65 135.04% 353,253.65 Balance Proposed FY 2024- Remaining Remaining 2025 Budget (7,867.94) #DIV/OI (7,867.94) #DIV/O! 2,000.00 1,930.00 3.50%_$ (255.85) #DIV/OI 500.00 500.00 0.00% 250.00 250.00 0.00% 1,000.00 (51,301.02) 5230.10% 1,000.00 113.34 88.67% 1,100.00 $ (110,770.25) 10170.02% 2,000.00 (16,798.66) 939.93% 5,000.00 5,000.00 0.00% (9,775.11) #DIV/O! 1,000.00 (3,482.99) 448.30% 6,600.00 6,589.02 0.17% 2,000.00 (14,675.40) 833.77% 220.51% $ 11,000.00 1,000.00 14,000.00 25,000.00 1,500.00 5,000.00 50,000.00 75,000.00 2,000.00 8,329.00 $ 6,360.11 $ 1,980.00 $ (4,380.11) 11,842.74 $ 13,770.33 59,173.03 4,757.64 4,433.83 259,539.56 $ 80,207.24 $ 45,499.02 $ 19,920.00 $ (25,579.02) 259,539.56 529,489.38 47,942.00 43,138.72 5,400.85 33,442.83 2,816.00 126.38 89,268.02 1,805.00 158.56 3,142.88 $ 9,503.19 $ 14,609.63 $ 17,772.41 44,580.45 14,276.23 25,278.08 77.20 4,108.59 39,848.89 1,985.00 46.83 1,696.00 14,044.58 39,400.00 500.00 10,000.00 3,000.00 (5,180.45) (13,776.23) (15,278.08) (77.20) #DIV/O! (1,108.59) (39,848.89) #DIV/OI (1,985.00) #DIV/O! (46.83) #DIV/O! 804.00 (14,044.58) #DIV/OI 5,280.00 29,880.00 42,000.00 20,000.00 10,000.00 2,000.00 10,000.00 50,000.00 2,000.00 200.00 2,500.00 14,000.00 5,300.00 5,300.00 29,880.00 $ 174,192.80 $ 128,169.44 $ 52,900.00 $ (75,269.44) 2,500.00 2,500.00 $ (15,272.41) 5,280.00 5,280.00 $ 5,280.00 29,880.00 29,880.00 29,880.00 636,043.96 802,032.97 $ 593,907.00 $(208,125.97) 636,043.96 802,032.975 593,907.00 S/(208,125:.97)1 FY: 2022-2023 Vear To Date FV2023-2024 Budget Balance Actuals Actuals Budget 7,867.94 7,867.94 70.00 255.85 52,301.02 886.66 111,870.25 18,798.66 9,775.11 4,482.99 10.98 16,675.40 8,000.00 2,000.00 500.00 52,000.00 1,000.00 100,000.00 20,000.00 10,000.00 2,000.00 5,000.00 4,000.00 33,783.21 33,783.21 $ 53,513.53 $ 4,750.00 $ (48,763.53) 1126.60% $ 55,500.00 Services- 48,178.76 2,295.48 14,917.78 11,461.18 $ 50,474.24 $ 140,444.02 $ 8,100.00 $(132,344.02) 1733.88% $ 130,000.00 I$ 26,378.96 $ 21,169.37 $ 9,600.00 I$ (11,569.37)! 81-8111: Grant Expense 81-8111 Grant Programs Litys Portion 81-8111 - Grant Expensel Total 81-8250- Debt Service 81-8251 Interest Expense 81-8250- - Debts Service Total 81-8601 &81-9451 Miscellaneous 81-8601 Permit Fees 81-9451 Sample Analysis 81-8601 &8 81-9451- - Miscellaneous Tatal 81-9150 Utilities 81-9151 lelepnone & internet Services Total Utilities 81-9200- - Personnel 81-9201 Training andE Education 81-9200 - Personnel Total 91-9250 --1 Transfers 81-92561 Transfer from Utilitiest tol I8S 91-9250 - Transfers Total 81-Se er-Total Grand Total 02- Ullitles Fund (Expense) 84- arba 84-7650 - Contractual 84-/652 Lontract services-solia Waste Collection Total Contractual 84-Garbage- Total Grand Total Total Expense 1,000.00 1,000.00 (1,000.00) #DIV/OI (1,000.00) #DIV/0! 6,850.00 6,850.00 (23,677.00) #DIV/O! 1,200.00 (36.00) #DIV/O! (36.00) #DIV/O! 47,160.00 6,850.00 6,850.00 0.00% 0.00% $ 6,850.00 32.38% 173.32% $ 30,500.00 0.00% 0.00% $ 6,850.00 24,000.00 6,500.00 14,775.11 9,863.72 $ 23,677.00 5,440.46 16,800.00 $ 11,359.54 1,200.00 1,200.00 $ 1,200.00 $ 24,638.83 $ 29,117.46 $ 16,800.00 $ (12,317.46) 36.00 36.00 1,000.00 1,000.00 47,160.00 2025 Budget 142,530.00 142,530.00 142,530.00 142,530.00 47,160.00 47,160.00 * 47,160.00 94,460.00 $(158,688.32 94,460.00 Actuals Actuals Budget 141,327.29 142,530.33 $ 141,327.29 142,530.33 $ 141,327.29 142,530.33 141,327.295 142,530.33 0.00% 0.00% 47,160.00 268.00% 282,010.00 268.00% 282,010.00 U4 Balance Proposed FY 2024- Remaining 135,275.24 253,148.32 135,275.2415 253,148.32 FV 2022-2023 Vear To Date FV 2023-2024 Budget Balance Remalning (142,530.33) #DIV/O! $(142,530.33) #DIV/0! $(142,530.33) #DIV/01 $/(142,530.331 #DIV/01 2,101,353.87 $2,171,548.09 2,312,100.00 140,551.91 93.92% $2671,120.65 FV2023- $ 1,448.89 $ FY 2023-2024 FY 2023-2024 Proposed FY 04- otel Occupancy' Tax Fund (Summary) Revenue Summary 60-Special Revenue Revenue Totals 04- otel Occupancy Tax Fund (Revenue) 60-Special Revenue Business & Franchise 60-7777 Hotel Occupancy Tax Total Business &F Franchise Total Special Revenue Total Revenue FY2022- 2024 Vear To FV: 2023-2024 Budget Balance % Balance 2024-2025 2023 Actuals Date Actuals Budget $1,448.89 $1,448.89 $ Remaining $ 1,448.89 $ $ 1,448.89 $ $ 1,448.89 $ Remaining Budget $ 1,000.00 $1,000.00 $ 1,000.00 Revenues Over(Under) Expenditures $ 1,448.89 $1,448.89 $ FY: 2023- $ 1,448.89 $1,448.89 $ $1,448.89 $1,448.89 FV 2023-2024 FY 2023-2024 Proposed FY FV2022- 2024 Vear To FY2023-2024 Budget Balance % Balance 2024-2025 2023 Actuals Date Actuals Budget Remaining $ 1,448.89 0.00 $ 1,448.89 0.00 1,448.89 0.00 1,448.89 0.00 Remaining Budget $ $ $ 1,000.00 $ 1,000.00 $1,000.00 1,000.00 FY 2023-2024 Year 01-2024) Budget 85.00 23,466.00 615,762.14 40,624.13 31,800.61 500.00 2,354.36 25.00 3,025.00 2,600.00 539,709.01 390,366.90 597,739.70 6,428.04 17,473.93 342,688.79 264,467.83 34,503.12 50,166.59 115,890.68 117,664.27 18,894.32 11,879.29 72,881.46 59,175.49 13,981.25 13,704.10 41,822.83 3,384.98 87,279.45 69,121.37 142,620.47 127,613.82 (607,361.04) (851,265.87) FY: 2023-2024 FY 2023-2024 Remaining Remaining 2025 Budget 23,466.00 0.00% 67.45% 1,913,906.48 (76,699.39) 29.31% 2,354.36 #DIV/O! 25.00 #DIV/0! $ 100.00 104.00% 405,944.01 403.48% 109,061.70 122.32% 12,465.59 133.06% 96,664.27 560.31% (35,557.00) (16,991.71) 41.15% 58,575.49 9862.58% 13,704.10 3,384.98 69,121.37 127,613.82 FV: 2022-2023 To Date Actuals (08- FY 2023-2024 Budget Balance % Balance Proposed FY 2024- 01- General Fund Revenue Summary po-Non-Depatmentel 11-Administration 12-Municipal Court 15-Parks and Recreation 18-Library 20-BasabaiComolas Revenuel Totals Expense Summary po-Non-Departmental 11-Administration 12-MunicipalCourt 13-Police 14-Fire 15-Parks and Recreation 16-PublicV Works 17-Streets 18-Library 20-Baseball Complex 70-Electric 80-Water 81-Sewer Expense Totals Revenues Over(Under)! Expenditures 01- General Fund (Revenue) p0-Non-Departmental License & Permits 00-6115 PetR Registration Total License & Permits Miscellaneous 00-6801 Miscellaneous Revenue 00-6 6900 Payroll Reimbursement 00-6901 Insurance Reimbursement Total Total Non- Departmental Grand Total 01-G General Fund (Revenue) 11-Administration Property Tax 11-60031 I8SF Property Tax 11-6005 M8OP Property Tax Total Property Tax Sales Tax 11-6021 Sales Tax 11-6050 Bartlett Muncipal Development District Sales Tax Total Sales Tax License & Permits 11-6101 Building Permits 11-6112 Manf. Home Permits 11-6115 Pet Registration Actuals 606,701.00 6,763.00 2,100.00 2,600.00 963,683.06 24,854.00 558,792.01 48,600.00 26,895.00 9,400.00 20,500.00 6,400.00 18,150.00 246,420.65 567,279.00 41,096.76 961,417.04 1,425,403.00 (463,985.96) 108,500.00 2,500.00 133,765.00 488,678.00 222,346.00 (204,872.07) 398,333.00 (133,865.17) 66.39% 37,701.00 21,000.00 35,557.00 28,871.00 600.00 659,996.27 $ 1,021,663.01 $ 1,536,403.00 $ (514,739.99) 66.50% $ 2,532,070.48 7.86% 0.00% #DIV/O! #DIV/OI #DIV/O! #DIV/O! $ 1,267,357.31 $ 1,872,928.88 $ 1,366,881.00 $ 505,249.38 137.02% $ 2,490,973.72 169,522.00 $ (1,020,787.87) -502.16% FY 2022-2023 FY 2023-20241 Vear FV 2023-2024 Budget Balance % Balance. Proposed FY 2024- Remaining/2025 Budget 0.00% 0.00% $ 0.00% $ 154,970.00 0.00% $ 451,731.00 0.00% 0.00% $ 606,701.00 0.00% $ 606,701.00 %Balance Proposed FV 2024- Remaining): 2025 Budget Actuals $ To Date Actuals Budget Remaining (52.00) $ (52.00) (114.00) (23,300.00) (23,414.00)! (23,466.00)! Budget 85.00 85.00 $ $ 52.00 52.00 $ 114.00 $ 23,300.00 23,414.00 23,466.00 23,466.00 To Date Actuals Budget 85.00 85.00 (23,466.00) 0.00% 606,701.00 FV 2022-2023 FY 2023-2024 Vear FY: 2023-2024 Dollars Over Actuals $ $ 492,397.44 $ 125,610.92 $ 124,063.00 $ 1,547.92 101.25% 101,351.48 719,605.00 141,550.00 14,400.00 634,350.98 719,605.00 $ (85,254.02) 88.15% $ 492,397.44 $ 759,961.90 $ 843,668.00 $ 83,706.10 90.08% $ 820,956.48 54,925.54 $ 102,209.00 $ 141,550.00 $ (39,341.00) 72.21% $ 82,388.31 $ 102,209.00 $ 155,950.00 $ (53,741.00) 27,462.77 14,400.00 (14,400.00) 0.00% 65.54% $ 155,950.00 19,801.50 $ 46,492.50 $ 30,000.00 $ 16,492.50 154.98% $ 25,000.00 6,050.00 $ 7,650.00 10,000.00 $ (2,350.00) 76.50% 7,000.00 300.00 $ (300.00)! 0.00% Total License & Permits Business8 &F Franchise 11-6113 Franchise Fees Total & Franchise Miscellaneous 11-6801 Miscellaneous- Copies &F Faxes $ 11-69901 Transfers Between Funds Total Miscellaneous Donations 11-6851 Donations Total Donations Total Administration Grand Total 01- General Fund (Revenue) 12-Municipal Court Fines andF Forfeitures 12-6301 Court Fines Revenue 12-6302 Minicipal Court Building Securityl Fund 12-6303 Municipal Court Service Fee Retained 12-6304 Municipal Technology Fund 12-6305 Municipal Jury Funds 12-6306 Local Truancy Prevention and Diversion Fund 12-6308 Omnibase Reimbursement Fee $ 12-6351 Court Costs Collected Total Fines andF Forfeitures Total Municipal Court Grand Total 01- General Fund (Revenue) 15-Parks and Recreation Rents 15-6701 Gate8 & Rental 15-6872 Land Lease Total Rents Miscellaneous 15-6702 Concession Total Total Parksa and Recreation Grand Total 01- General Fund (Revenue) 18-Library Donations 25,851.50 $ 12,178.79 12,178.79 54,142.50 40,300.00 13,842.50 134.35% 5,504.21 155.04% 5,504.21 155.04%_s 29,569.43 32,000.00 15,000.00 15,000.00 890,000.00 15,504.21 $ 10,000.00 15,504.21 $ 10,000.00 2,946.10 $ 29,569.43 $ #DIV/O! 0.00% 7.88%_$ 890,000.00 20.00 300.00%_$ 20.00 300.00% 375,475.00 $ (375,475.00) 2,946.10 $ 29,569.43 $ 375,475.00 $ (345,905.57) 30.00 30.00 10.00 10.00 615,762.14 FV 2022-2023 FV Actuals 961,417.04 1,425,403.00 (463,985.96) 67.45% 1,913,906.48 $ 615,762.14 $ 961,417.04 $ 1,425,403.00 $ (463,985.96)! 67.45% $ 1,913,906.48 Year FY 2023-2024 Budget Balance % Balance Proposed FY 2024- Remaining 2025 Budget #DIV/OI $ #DIV/O! $ #DIV/O! $ #DIV/O! #DIV/0! $ #DIV/O! $ #DIV/O! To Date Actuals Budget Remaining 23,461.79 $ 24,322.00 $ 108,500.00 $ (84,178.00) 22.42% $ 958.31 $ 6,262.83 $ 819.20 $ 15.00 750.12 $ 440.00 $ 7,916.88 $ 40,624.13 9 31,800.61 40,624.13 $ 31,800.61 751.13 * 4,504.31 $ 636.45 $ 12.58 448.73 $ 372.00 $ 753.41 751.13 $ 4,504.31 636.45 12.58 448.73 372.00 753.41 4,500.00 650.00 15.00 448.00 400.00 750.00 6,763.00 6,763.00 108,500.00 $ (76,699.39) 29.31% $ 6,763.00 40,624.13 $ 31,800.61 $ 108,500.00 $ (76,699.39)! 29.31% 108,500.00 (76,699.39) 29.31% FY2 2022-2023 FY2 2023-2024 Vear FY2 2023-2024 Budget Balance %Balance! Proposed FY 2024- Remaining! 2025 Budget #DIV/O! $ #DIV/O! #DIV/O! Actuals 500.00 To Date Actuals Budget $ 1,600.00 $ 500.00 500.00 2,100.00 $ 254.36 254.36 $ 2,354.36 $ 2,354.36 $ ToD Date Actuals Budget Remaining $ 1,600.00 500.00 254.36 254.36 #DIV/0I 2,354.36 #DIV/O! $ 2,100.00 2,354.36 #DIV/OI 1,600.00 500.00 $ 2,100.00 #DIV/0! $ 2,100.00 $ 500.00 500.00 2,100.00 FY Actuals FY:2023-2024) Year FY 2023-2024 Budget Balance %B Balance. Proposed FY 2024- Remaining 2025 Budget Remaining 18-6851 Donations Total Donations Total Library Grand Total 01- General Fund (Revenue) 20-Baseball Complex Miscellaneous 20-6741 Cemetery Revenue Total Miscellaneous Total Baseball Complex Grand Total Total Revenue 01-G General Fund (Expense) 00-Non-D Departmental Olher Sources 00- 7024 Past Due IRS Taxl Liability Total Other Sources Personnel 00-7033 Employee Retirement Total Personnel Transfers 00-9254 Interfund Transfer Out Total Transfers Total Non-Departmental Grand Total 01- General Fund (Expense) 11-Administration Personnel 11-7011 Salaries andy Wages 11-7012 Council Stipends 11-7021 State Unemployment Taxes- SUI 11-7031 Workers Comp 11-7032 Health Insurance 11-7033 Employee Retirement 11-7670 Physicals, 5P Screenings, etc. 11-8507 Employee Relations and Appreciation 11-92017 Training and Education Total Personnel Not Categorized 11-7020 I85 Debt Total Not Categorized 25.00 25.00 25.00 25.00 $ Budget 2,600.00 $ 2,600.00 $ 2,500.00 2,600.00 25.00 #DIV/O! 25.00 #DIV/0! $ 25.00 #DIV/OI $ 25.00 #DIV/0! $ FY: 2022-2023 FV2 2023-20241 Year FV 2023-2024 Budget Balance %E Balance Proposed FY 2024- Remaining/2025 Budget Actuals To Date $ 3,025.00 3,025.00 3,025.00 $ 2,600.00 3,025.00 659,996.27 1,021,663.01 Remaining 2,500.00 $ 2,500.00 2,500.00 1,536,403.00 100.00 104.00% 100.00 104.00% $ 2,600.00 100.00 104.00% $ 2,600.00 100.00 104.00% 514,739.99 Budget Balance Remaining 67,615.00 2,600.00 2,600.00 66.50%s 2,532,070.48 % Balance Proposed FV 2024- Remaining/2025 Budget FV 2022-2023 FV Actuals Year FY To Date Actuals Budget 517,130.49 22,578.52 22,578.52 449,515.49 764.82% 22,578.52 #DIV/OI 22,578.52 #DIV/0! $ (66,150.00) $ 517,130.49 $ 67,615.00 $ 449,515.49 764.82% $ 66,150.00 66,150.00 $ (66,150.00) 133,765.00 405,944.01 403.48% $ 0.00% 0.00% $ 539,709.01 $ 133,765.00 $ 405,944.01 403.48% $ 539,709.01 To Date Actuals Budget FY Actuals FY 2023-20241 Year FY 2023-2024 Budget Balance %Balance Proposed FY 2024- Remaining! 2025 Budget 83.33% $ #DIV/O! $ #DIV/O! $ Remaining $ 127,453.89 $ 158,035.36 $ 90,000.00 $ 68,035.36 175.59% $ 261,025.00 3,300.00 $ 88.43 $ 19,781.20 $ 46,249.44 $ 11,347.33 $ 14,673.40 9,672.70 $ 17,137.04 3,416.50 258.00 $ 2,750.00 91.20 3,300.00 $ 260.00 $ (550.00) (168.80) 35.08% $ 46,249.44 65.00 923.50 145.27% (10,059.75) 91.89% 3,300.00 260.00 1,260.00 31,915.00 29,372.00 100.00 4,000.00 $ 11,583.00 $ 3,090.40 126.68% $ 7,185.00 $ 9,952.04 238.51% $ 3,506.00 $ 1,720.02 149.06% $ 65.00 $ 5,226.02 $ 2,963.50 114,003.25 $ 2,040.00 $ 124,063.00 $ 175,318.05 $ 247,190.96 $ 117,874.00 $ 129,316.96 209.71% $ 331,232.00 114,003.25 I$ 124,063.001 (10,059.75)! 91.89%$ Other Sources 11-7022 Federal Payrolll Taxes FICA 11-7210 CADE Entity Fees Total Other Sources Miscellaneous 9,750.20 $ 12,089.78 $ 6,886.00 3,500.00 $ (3,500.00) 5,203.78 175.57%$ 19,968.00 0.00% 3,500.00 7,500.00 3,000.00 7,000.00 4,012.00 52,000.00 17,000.00 1,500.00 15,000.00 9,750.20 $ 12,089.78 $ 10,386.00 $ 1,703.78 116.40% $ 23,468.00 11-7111 Advertising and Legal Notices $ 11-7951 Dues and Membership! Fees 11-8001 Cost of Elections 11-8204 Liability Insurance- General Liability 11-8401 LegalE Expenses 11-8402 Accounting Audit Expenses 11-8501 Miscellaneous Expense 11-8511 Tributes 11-9251 Travel Expense Total Miscellaneous Contractual 11-7200 Appraisal District Fees 11-7651 Contract Services- Regular 11-8951 Software Maintenance Agreements Total Contractual Utilities Total Utilities Debt Service 2250- 11-82511 Interest Expense Total Debt Service Supplies 11-8551 Office Supplies Total Supplies Repair & Maintenance 11-8851 Facility 11-8953 Copier Service 11-8954 Computer Hardware & Repairs $ Total Repair & Maintenance Transfers 11-9255 Transferf from GF tol8S Total Transfers Total 3,749.44 $ 6,718.54 $ 1,146.15 $ 3,909.25 $ $ 3,850.25 16,000.00 1,407.46 $ 7,500.00 1,670.00 7,000.00 4,012.00 15,000.00 1,060.00 960.00 100.00 2,260.00 (781.46) 89.58% 2,239.25 234.09% $ (3,149.75) 55.00% (4,012.00) 26,458.94 188.20% $ 1,000.00 106.67% 347.46 132.78% (960.00) 15,177.59 15277.59% (2,260.00) 6,688.00 (3,500.00) 34,354.80 221.91% (661.80) 55.88% 5,535.28 238.38% 0.00% 51,489.00 $ 56,458.94 $ 30,000.00 17,000.00 4,530.91 0.00% 0.00% #DIV/0! $ 0.00% 11-8701 Postage Fees8 & Subscriptions $ 11,266.85 $ 15,277.59 $ $ 89,182.35 $ 103,622.03 $ 69,562.00 $ 34,060.03 148.96% $ 107,012.00 5,675.76 $ 21,755.57 1,053.79 $ 6,688.00 $ 62,534.80 838.20 $ 9,535.28 6,700.00 68,000.00 1,100.00 4,000.00 3,500.00 28,180.00 1,500.00 $ 4,000.00 $ 27,431.33 $ 69,222.80 $ 31,680.00 $ 37,542.80 218.51% $ 74,700.00 11-7451 Cellular Phones andF Pagers $ 11-91511 Telephone &I Internet Services $ 10,096.64 $ 11,150.43 $ 10,373.48 $ 5,500.00 $ 4,873.48 188.61% $ 5,100.00 Capital Note $ 295,000.00 0.00% 94,171.06 0.00% $ 389,171.06 5,000.00 25,000.00 2,500.00 500.00 7,463.00 $ (7,463.00) $ 7,463.00 $ (7,463.00) $ 16,039.21 $ 16,039.21 $ 11,730.58 57,171.12 $ 27,703.80 4,214.21 $ 110.00 11,730.58 750.00 10,980.58 1564.08% 750.00 $ 10,980.58 1564.08% $ 5,000.00 1,000.00 $ 26,703.80 2770.38% 3,800.00 $ (2,374.07) 37.52% 1,425.93 $ 377.09 377.09 #DIV/O! 0.00% 0.00% $ 61,495.33 $ 29,506.82 $ 4,800.00 $ 24,706.82 614.73% $ 28,000.00 116,600.00 $ (116,600.00) 116,600.00 $_(116,600.00) 390,366.90 597,739.70 $ 488,678.00 L$ 109,061.70 122.32% $ 963,683.06 Grand Total 01- General Fund (Expense) 12-Municipal Court Personnel 12-7004 Judge 12-7011 Salaries and Wages 12-7021 State Unemployment Taxes sur $ 12-7032 Health Insurance 12-70336 Employee Retirement 12-9201 Training andE Education Total Personnel Other Sources 12-7022 Federal Payroll Taxes- FICA $ Total Other Sources Miscellaneous 12-7801 Court Costs, Fines, & Fees 12-8400 Prosecutor Expense 12-8401 Legal Expenses 12-8701 Postage Fees8 & Subscriptions 12-9251 TravelE Expense Total Miscellaneous Supplies 12-8551 Office Supplies Total Supplies Contractual 12-8951 Software Agreements Total Contractual Total Municipal Court Grand Total 01-6 General Fund (Expense) 13-Police Personnel 13-7011 Salaries andy Wages 13-7021 State Unemployment Taxes SUI 13-7032 Health Insurance 13-7033 Employee Retirement 13-7038 Department Overtime (OT) 13-9201 Training andE Total Personnel Other Sources 13-7022 FederalF Payroll Taxes FICA s 390,366.90 s 597,739.70 s 488,678.00 s 109,061.70 122.32% 963,683.06 FV2 2022-2023 FY 2023-2 2024 Year FV Budget Balance Remaining %E Balance. Proposed FY 2024- Remaining!: 2025 Budget #DIV/O! $ 5.319 $ 1.78% $ 0.00% $ 0.00% $ 0.00% 4.37% $ 5.26% 5.26% $ #DIV/O! $ 2.50% $ 0.00% $ #DIV/O! 6.31% $ 6.31% $ 0.00% $ 0.00% $ 10,000.00 7.86% $ 24,854.00 7.86% $ 24,854.00 % Balance. Proposed FY 2024- Remaining!: 2025 Budget 6.62% $ 0.00% $ 9.08% $ Actuals To Date Actuals Budget 461.54 $ 5,076.94 $ 95,590.00 $ (90,513.06) 12.46 $ 700.00 $ 23,166.00 $ (23,166.00) $ 7,265.00 200.00 7,385.00 461.54 (687.54) (7,265.00) (200.00) (6,996.48)! 2,400.00 6,000.02 $ 11.98 $ $ 105.00 459.16 $ 459.16 $ (148.12) $ $ $ $ $ $ 270.00 2,670.00 184.00 184.00 9,500.00 1,500.00 500.00 500.00 $ 6,117.00 $ 5,550.94 $ 126,921.00 $ (121,370.06) 388.52 $ 388.52 $ 7,385.00 $ (6,996.48) 9,567.65 $ 72,400.00 $ (62,832.35) 13.21% $ 1,277.50 $ 50.00 $ $ 450.00 189.32 1,277.50 (200.00) 450.00 (2,810.68) (10,440.00)! 2,000.00 $ (1,950.00) 200.00 (148.12)! $ 11,345.15 $ 74,600.00 $ (63,254.85) 15.21% $ 12,000.00 3,000.00 10,440.00 10,440.00 (10,440.00) $ 189.32 $ 3,000.00 $ (2,810.68) 10,000.00 6,428.04 $ 17,473.93 ls 222,346.00 $ (204,872.07)! 6,428.04 $ 17,473.93 $ 222,346.00 $ (204,872.07)! FY 2022-2023 FV 2023-2024 Vear FV 2023-2024 Budget Balance Actuals $ To Date Actuals Budget Remaining $ 217,135.75 $ 158,013.27 $ 223,810.00 $ (65,796.73) 70.60% $ 340,964.01 $ 35,302.39 $ 23,896.68 $ 46,613.00 $ (22,716.32) 51.27% $ 82.80 67.48 $ 1,020.00 (952.52) (279.67) 98.32% (2,382.04) 200.00 53,192.00 31,486.00 4,992.85 9,800.00 26,084.00 $ 16,246.87 $ 16,320.33 $ 16,600.00 363.48 $ 237.96 2,620.00 $ 269,131.29 $ 198,535.72 $ 290,663.00 $ (92,127.28) 68.30% $ 435,642.01 16,610.84 $ 12,088.04 $ 15,910.00 $ (3,821.96)! 75.98%_$ Total Other Sources 13-7120A Animal Control Officer and Related Expenses 13-7155 Code Abatement 13-7160 Community Development& Support 13-7951 Dues andN Membership Fees 13-82041 Liability Insurance- General Liability 13-8501 Miscellaneous Expense 13-8701 Postage Fees8 & Subscriptions $ 13-9251 Travel Expense Total Miscellaneous Capital 13-7401 Capital Expenditures Total Capital Utilities 16,610.84 $ 660.00 $ 3,200.00 $ 2,474.36 $ 12,088.04 780.00 $ 3,950.00 2,416.02 165.00 594.05 880.45 15,910.00 1,200.00 $ 7,000.00 500.00 12,260.00 $ (12,260.00) 750.00 660.00 (3,821.96) 75.98% $ 26,084.00 (420.00) 65.00% $ 3,950.00 #DIV/O! $ (4,583.98) 34.51%_$ (335.00) 33.00% $ 0.00%_$ 594.05 #DIV/O! $ 130.45 117.39% $ (660.00) 0.00% 1,000.00 3,000.00 1,000.00 17,316.00 500.00 655.37 6,989.73 20,279.64 3,815.43 $ 4,208.87 $ 504.73 Regularly $ $ 8,785.52 $ 22,370.00 $ (13,584.48) 39.27% $ 22,816.00 19,402.44 $ 11,000.00 3,051.37 $ 4,102.34 $ 730.48 8,402.44 176.39%_s 30,000.00 8,402.44 176.39% $ 30,000.00 521.37 120.61%$ 52.34 101.29%_$ (19.52) 97.40% $ 554.19 107.56% $ 8,450.00 20,279.64 $ 19,402.44 $ 11,000.00 13-7451 Phones and Pagers $ 13-9151 Telephone &1 Internet Services $ 13-9352 Purchased Gas Power Total Utilities Contractual 13-7651 Contract Scheduled 13-8951 Software Agreements Total Contractual Supplies 13-8030 Equipment Purchases 13-8551 Office Supplies 13-9101 Operating! Supplies Not Office $ 13-9301 Uniform Expense Total Supplies Repair8 & 13-8051 Equipment Maintenance 13-8101 Fuel&Oil 13-8851 Facility 13-9401 Vehicle Total Repair & Maintenance Debt Service 13-8251 Interest Expense Total Debt Service Total Police Grand Total 01- General Fund (Expense) 2,530.00 $ 4,050.00 750.00 3,600.00 4,100.00 750.00 8,529.03 $ 7,884.19 $ 7,330.00 6,000.00 $ (6,000.00) 3,240.00 0.00%$ 3,577.45 $ 3,577.45 $ 4,608.37 4,608.37 7,745.00 $ 761.96 $ 256.05 1,368.37 142.23% 4,600.00 5,000.00 1,000.00 5,000.00 1,200.00 300.00 10,000.00 700.00 8,000.00 9,240.00 $ (4,631.63) 49.87% $ 4,600.00 5,000.00 $ 2,745.00 154.90% $ 4,750.00 $ (3,988.04) 4,650.00 2,420.00 2,055.42 $ 1,039.63 702.54 361.28 $ 9,265.88 $ 688.67 $ 3,457.39 16.04% $ 5.51% 0.00% 0.48% $ 26.29% $ #DIV/OI $ 3.95% 0.00% (4,393.95) (2,420.00) 3,797.59 $ 8,763.01 $ 16,820.00 $ (8,056.99) 52.10%s 12,200.00 25.00 $ 646.59 217.00 5,200.00 $ (5,175.00) 3,511.95 $ 13,360.00 $ (9,848.05) $ $ 646.59 (5,283.00) (940.00)! 5,500.00 940.00 $ 13,773.22 $ 4,400.54 $ 24,060.00 $ (19,659.46) 18.29% e 19,000.00 940.00 $ (940.00) 0.00%s 342,688.79 264,467.83 $ 398,333.00 $ (133,865.17) 66.39% $ 558,792.01 342,688.79 $ 264,467.83 $ 398,333.00 $ (133,865.17)! 66.39% $ 558,792.01 FY 2022-2023 FY2 2023-2024) Year FV2 2023-2024 Budget Balance %B Balance Proposed FY 2024- Remaining: 2025 Budget 14-Fire Utilities Total Utilities Supplies 14-7501 Chemicals 14-8030 Equipment Purchases 14-8451 Medical Supplies 14-9101 Operating Supplies Not Office Total Supplies Repair &N Maintenance 14-7657 Fire Hydrant Inspections 14-8051 Equipment Maintenance 14-8101 Fuel&Oil 14-8851 Facility Maintenance 14-9401 Vehicle Maintenance Total Repair & Miscellaneous 14-7951 Dues and Membership! Fees 14-8204 Liability Insurance General Liability Total Miscellaneous Personnel 14-9201 Training and Education Total Personnel TotalF Fire Grand Total 01- General Fund (Expense) 15-Parks andRecreation. Personnel 15-7011 Salaries and Wages 15-7013 Pool Manager 15-7021 State Unemployment Taxes- SUI 15-7032 Health Insurance 15-7649 On-Call Compenssation 15-9201 Training andE Education Total Personnel Other Sources 15-7022 Federal Payroll Taxes- FICA $ Total Other Sources Supplies Actuals To Date Actuals Budget Remaining 600.00 14-7451 Cellular Phones & Pagers $ 14-9151 Telephone &1 Internet Services $ 600.92 $ 1,433.55 536.42 $ 1,522.91 (63.58) 89.40%_$ (1,920.67) 51.74% $ 2,400.00 600.00 1,800.00 3,380.00 $ (1,857.09) 45.06% 1,000.00 $ (1,000.00) 5,000.00 $ (5,000.00) 2,500.00 2,034.47 $ 2,059.33 $ 3,980.00 0.00% 0.00% #DIV/O! $ 1,570.00 $ 5,391.99 $ 3,460.24 9,512.35 18,521.02 9,512.35 16,021.02 740.84% 19,533.37 329.80% 0.00% $ 9,401.99 #DIV/O! $ 99.26 103.97% $ 77.16 #DIV/O! $ (4,325.27) 13.49% 10,000.00 10,000.00 3,000.00 10,000.00 2,500.00 200.00 5,000.00 1,000.00 12,000.00 2,500.00 2,500.00 10,422.23 $ 28,033.37 $ 8,500.00 $ 3,000.00 $ (3,000.00) 2,500.00 $ 5,000.00 1,000.00 12,221.00 1,500.00 37,701.00 14,501.28 6,651.74 $ 275.00 618.40 9,401.99 $ 2,599.26 77.16 674.73 4,908.75 $ $ 4,908.75 $ 13,221.00 2,412.00 2,412.00 $ 22,046.42 $ 12,753.14 $ 10,500.00 $ 2,253.14 121.46% $ 20,700.00 3,908.75 490.88%_$ (12,221.00) (8,312.25) 37.13% $ 13,000.00 912.00 160.80% 0.00% 1,500.00 $ 912.00 160.80% 34,503.12 $ 50,166.59 $ 37,701.00 $ 12,465.59 133.06% $ 48,600.00 34,503.12 $ 50,166.59 FV 2022-2023 FV 2023-2024 Vear FV 12,465.59 133.06%s 48,600.00 Budget Balance Remaining % Balance Proposed FY 2024- Remaining 2025 Budget #DIV/O! #DIV/O! $ #DIV/0! $ #DIV/O! $ #DIV/O! #DIV/O! Actuals To Date Actuals Budget $ 85,924.85 $ 81,989.04 $ 21,000.00 $ 60,989.04 390.42% 12,960.00 5,400.00 85.00 750.00 100.00 85.79 $ 2,400.00 $ 750.00 6,455.84 100.00 $ 85.79 $ 18,446.56 2,400.00 750.00 6,455.84 6,455.84 #DIV/O! $ $ $ $ 61.04 $ 17,560.62 $ 18,446.56 $ 1,940.00 $ $ 105,486.51 $ 103,771.39 $ 21,000.00 $ 82,771.39 494.15% $ 19,195.00 6,721.65 $ 6,721.65 $ 6,455.84 $ 15-7501 Chemicals 15-9101 Operating Supplies Not Office $ Total Supplies Repair & Maintenance 15-8051 Equipment Maintenance 15-8851 Facility Maintenance Total Repair & Utilities 15-9151 Telephone &1 Internet Services $ Total Utilities Total Parks andF Recreation Grand Total 01- General Fund (Expense) 16-Publicy Works Personnel 16-7011 Salaries and Wages 16-7021 State Unemployment" Taxes- SUI 16-9201 Training andE Education Total Personnel Other Sources 16-7022 Federal Payroll Taxes- FICA Total Other Sources Supplies 16-7501 Chemicals 16-9101 Operatings Supplies Not Office 16-9301 Uniform Expense Total Supplies Repair & Maintenance 16-8 8051 Equipment Total Repair & Maintenance Miscellaneous 16-82041 Liability Liability Total Miscellaneous Utilities 16-9151 Telephone & Internet Total Utilities TotalPublic Works Grand Total 01- Generall Fund (Expense) 17-Streets Supplies 17-7501 Chemicals Total Supplies Repair & Maintenance 17-8051 Equipment Maintenance 17-8854 Street Repair8 & Maintenance Total Repair8 &N Maintenance 1,684.84 $ 224.22 2,422.64 942.07 425.43 $ 2,978.36 668.54 668.54 $ 2,422.64 942.07 425.43 2,978.36 668.54 668.54 #DIV/O! $ 96,664.27 560.31% 96,664.27 560.31%s 26,895.00 #DIV/O! #DIV/O! #DIV/O! $ #DIV/O! #DIV/O! $ 2,500.00 1,000.00 500.00 3,000.00 700.00 700.00 26,895.00 $ 1,909.06 $ 3,364.71 $ 3,364.71 #DIV/01 $ 3,500.00 1,152.60 1,152.60 $ 3,403.79 620.86 $ 620.86 $ 3,403.79 #DIV/O! $ 3,500.00 $ 115,890.68 $ 117,664.27 $ 21,000.00 115,890.68 $ 117,664.27 21,000.00 FV 2022-2023 FY2 2023-2024 Year FV 2023-2024 Budget Balance %Balance Proposed FY: 2024- Remaining; 2025 Budget 0.00% 0.00% 0.00% 0.00% $ 0.00% 0.00% $ 0.00% 0.00% 0.00%_$ 0.00%_$ 0.00% 0.00% $ 0.00% 100.00% 245545 %B Balancel. Proposed FY: 2024- Remaining/2025 Budget 0.00%_$ 0.00%$ 0.00%$ Actuals To Date Actuals Budget Remaining 20,160.00 $ (20,160.00) 570.00 $ 800.00 $ 21,530.00 $ (21,530.00) 1,553.00 $ (1,553.00)! 1,553.00 $ (1,553.00) 3,000.00 $ (3,000.00) 500.00 400.00 3,900.00 600.00 600.00 (570.00) (800.00) 3,000.00 500.00 3,000.00 2,000.00 (500.00) (400.00) (600.00) (3,900.00) 0.00% 6,500.00 (600.00) 0.00%$ 2,000.00 7,104.00 $ (7,104.00) 7,104.00 $ (7,104.00) 870.00 $ 900.005 (870.00) 900.00 900005 900.00 900.00 900.00 9,400.00 900.00 35,587,0015 (64,68700) 900.00 1$ 35,587.005 (34,687.00) 2.5399 9,400.00 FY 2023-2024 FY 2023-2024 Remaining 600.00 600.00 1,500.00 $ (1,500.00) 26,000.00 $ (14,120.71) 45.69%_$ FY 2022-2023 FY 2023-2024Vear FY2023-2024 Budget Balance Actuals To Date Actuals Budget (600.00) (600.00) 1,500.00 19,000.00 18,894.32 11,879.29 18,894.32 11,879.29 27,500.00 (15,620.71) 43.20% 20,500.00 Miscellaneous 17-82041 Liability Insurance General Liability Total Miscellaneous Total Streets Grand Total 01- General Fund (Expense) 18-Library Personnel 18-7011 Salaries andy Wages 18-7021 State Unemployment Taxes SUI 18-7032 Health Insurance 18-7033 Employee Retirement Total Personnel Other Sources 18-7022 FederalF Payroll Taxes FICA Total Other Sources Miscellaneous 18-7701 Books, Movies, Subscriptions 18-8701 Postage Fees & Subscriptions Total Repair & Maintenance 18- 8051 Equipment Maintenance 18-8851 Facility Maintenance 18-8953 Copier Service Total Repair & Maintenance Supplies 18-8551 Office Supplies Total Supplies Utilities 18-9151 Telephone & Internet Services Total Utilities Total Library Grand Total 01- General Fund (Expense) 20-Baseball Complex Contractual 20-7651 Contract Services Total Contractual Supplies 20-91027 Tools & Non- Capital Equipment Total Supplies Utilities 20-9351 Purchased Water Total Utilities Total Baseball Complex Grand Total 01- General Fund (Expense) 70-Electric Personnel 70-7011 Salaries andV Wages (ClassB Lineman, Apprentice) 70-7021 State Unemployment Taxes- SUI 70-7032 Health Insurance 70-7033 Employee Retirement 70-7038 Department Overtime (OT) Total Personnel 771.00 $ (771.00) 0.00% 771.00 (771.00) 0.00% FV: 2023-2024 FY 2023-2024 Remaining 34,463.46 22.50 9,223.28 3,762.61 $ 47,471.85 #DIV/OI 2,636.46 2,636.46 #DIV/ON 2,564.39 527.40% 235.00 #DIV/O! 45.00 637.63 566.13 $ 1,177.26 #DIV/ON * 1,400.00 154.64 154.64 #DIV/0I 4,264.39 4,264.39 #DIV/OD 58,503.99 9850.67% 6,400.00 600.00 58,503.99 9850.67% FV 2023-2024 FV: 2023-2024 %Balancel. Proposed FY 2024- Remaining Remaining/2025 Budget 15,625.00 #DIV/OI 230.29 #DIV/O! 230.29 #DIV/01 $ (2,151.19)! #DIV/O! $ $ (2,151.19) #DIV/0IS 13,704.10 #DIV/OI 18,150.00 13,704.10 #DIV/0! 18,150.00 FY 2023-2024 FY2023-2024 Budget Balance Remaining 18,894.32 11,879.29 28,871.005 (16,991.71) 41.15%5 20,500.00 18,894.32 11,879.29 28,871.00S (16,991.71) 41.15%5 20,500.00 FY: 2022-2023 FV2 2023-20241 Vear FY2023-2024 Budget Balance % Balance. Proposed FY 2024- Remaining), 2025 Budget #DIV/O! #DIV/O! #DIV/O! #DIV/O! #DIV/O! Actuals To Date Actuals Budget $ 40,259.62 $ 34,463.46 20.70 9,570.06 $ 3,021.73 $ 52,872.11 3,079.83 3,079.83 3,185.55 135.00 3,320.55 10,038.16 1,020.97 $ 2,041.94 22.50 9,223.28 3,762.61 47,471.85 2,636.46 2,636.46 3,164.39 $ 235.00 $ 3,399.39 45.00 $ 637.63 566.13$ 1,177.26 $ 154.64 $ 154.64 4,264.39 600.00 2,500.00 300.00 2,800.00 200.00 700.00 600.00 200.00 200.00 2,000.00 2,000.00 6,400.00 600.00 $ 2,799.39 566.57% #DIV/O! #DIV/O! #DIV/O! #DIV/O! #DIV/O! 2,549.84 2,549.845 4,264.39 63,864.275 59,103.9915 63,864.27 59,103.999 600.00 FY 2022-2023 FV 2023-20241 Vear FV 2023-2024 Budget Balance Actuals To Date Actuals Budget 15,600.00 $ 15,625.00 $ $ 15,600.00 $ 15,625.00 15,600.00 250.00 250.00 2,300.00 2,300.00 $ 15,625.00 #DIV/O $ 15,600.00 230.29 230.29 $ (1,618.75) $ (2,151.19)$ (1,618.75) (2,151.19) 13,981.255 13,704.105 13,981.25 13,704.10 FY 2022-2023 FY 2023-20241 Year FY Actuals $ 36,242.50 $ 20.70 $ 2,787.06 39,050.261 3,222.931 %Balance! Proposed FY 2024- Remaining!: 2025 Budget 2,118.38 #DIV/0! $ 5.30 #DIV/OI 838.48 #DIV/O! 260.77 #DIV/OI 0.00% 3,222.93 #DIV/0I 233,073.65 ToD Date Actuals Budget 2,118.38 $ 5.30 838.48 260.77 174,465.00 100.00 31,915.00 19,632.00 6,961.65 Other Sources 70-7022 Federal Payroll Taxes FICA Total Other Sources Total Electric Grand Total 01-7 GenerallFund (Expense) 80-Water Personnel 80-70091 Team Leader 80-7011 Salaries and Wages 80-7 7021 State Unemployment Taxes SUI 80-7032 Health Insurance 80-7033 Employee Retirement 80-7650 Over Time 80-92011 Training andE Education Total Personnel Other Sources 80-7 7022 Federal Payroll Taxes- FICA Total Other Sources Total Water Grand Total 01- Generall Fund (xpense) 81-Sewer Personnel 81-7011 Salaries andy Wages (Wastewater/Water Operations) 81-7021 State Unemployment Taxes- SUIS 81-7032H Health Insurance 81-7033E Employee Retirement Total Personnel Other Sources 81-7022 Federal Payroll Taxes FICA Total Other Sources Total Sewer Grand Total Total Expense 2,772.57 2,772.57 41,822.83 3384.98 41,822.83 3,384.985 162.05 162.055 162.05 #DIV/O! 13,347.00 162.05 #DIV/OS 13,347.00 3,384.98 #DIV/0IS 246,420.65 3,384.98 #DIV/0I 246,420.65 FV: 2023-2024 FY: 2023-2024 Remaining 14,342.70 37,617.00 45.00 11,319.48 1,771.41 47.25 65,142.84 #DIV/O 537,436.00 3,978.53 3,978.53 #DIV/OD 69,121.37 #DIV/OD $ 567,279.00 69,121.37 #DIV/OD 567,279.00 FV: 2023-2024 FY2023-2024 Remaining 92,125.90 45.00 18,446.56 9,948.73 120,566.19 #DIV/O! $ 7,047.63 7,047.63 #DIV/0I 127,613.82 #DIV/OIE 127,613.82 #DIV/OI FY 2022-2023 FY 2023-20241 Vear FY 2023-2024 Budget % Balance. Proposed FY 2024- Remaining/2025 Budget #DIV/O! #DIV/O! #DIV/O! #DIV/O! #DIV/O! #DIV/0! #DIV/O! Actuals ToD Date Actuals Budget 14,342.70 37,617.00 45.00 11,319.48 1,771.41 47.25 3,978.53 $ 66,691.90 41.41 15,372.27 $390,106.00 250.00 $85,107 $43,897 18,076.00 5,000.00 $29,843 $29,843 82,105.58 $ 65,142.84 $ 5,173.87 5,173.879 3,978.53 87,279.455 69,12.1.3755 87,279.45 69,121.37 FY 2022-2023 FV: 2023-2024 Year FY 2023-2024 Budget Balance %Balance Proposed FY 2024- Remaining 2025 Budget #DIV/O! #DIV/O! #DIV/O! #DIV/O! #DIV/O! Actuals To Date Actuals Budget $ 107,196.55 $ 92,125.90 $ 41.39 19,140.37 8,041.60 $ 134,419.91 8,200.56 $ 8,200.56 7,047.639 $ 142/620.4715 127,613.823 $ 142,620.4715 127,613.82 45.00 18,446.56 9,948.73 120,566.19 7,047.63 1,259,240.12 1,872,928.88 1,366,881.00 506,047.88 137.02% 2,490,973.72 FV 2023-2024 Year1 Tol 2024) FV 2023-2024 FV: 2023-2024 % Rate Change FV: 2022-2023 Date Actuals (08-01- FV2023-2024 Budget Balance Balance 39,193.07 $ 162,264.49 $ 116,200.00 $ 46,064.49 322,354.55 $ 475,999.50 $ 446,200.00 $ 29,799.50 166,352.11 $ 263,057.83 $ 256,500.00 $ 6,557.83 1,455,383.13 $ 2,262,005.81 $ 2,514,249.00 $ (252,243.19) 1,188,707.38 $ 973,256.47 $ 1,285,296.00 $ 312,039.53 Proposed FY 2024- 02- Utilities Fund (Summary) Revenue Summary 00: 70-Electric Bo-Water 31-Sewer 34-Garbage Revenue Totals Expense Summary po: 70-Electric ao-Water 81-Sewer 84-Garbage Expense Totals Revenues Over(Under)! Expenditures 02- Utilities Fund (Revenue) 00-6 6000 00-6025F Returned Check Fees 00-6404 Utility Connection- Fees 00-6415 W/WWTP IMPRV LOAN REPAYMENT 00-6 6000 - Total 00-6400- Business & Franchise 00-6410F Franchise Fees 00-6400 - Business & Franchise Total 00-6700- Grant Income 00-6 6751 GrantP Proceeds 00-6 -6700- - Grant Income Total 02-00-- Total Grand Total 02-Utilities Fund (Revenue) 70-Electric 70-6400- 70-6402 Utility Penalties 70-6400- Miscellaneous Total 70-6430- Business & Franchise 70-6431 Municipal Light8 &F Power TotalE Business & Franchise 70-Electric- - Total Grand Total Actuals Budget Remaining Remaining 2025 Budget 139.64% 78.11%$ 1,541,659.31 106.68% 881,127.41 102.56% 312,364.89 93.60% 268,172.01 89.97% $ 3,006,323.63 0.17%_$ 896,240.00 75.72%$ 1,129,157.00 135.04% 323,373.65 268.00% 228,000.00 93.92% $ 2,719,300.65 -3.95%$ 287,022.98 Balance Proposed FV: 2024- Remaining 2025 Budget 0.00% 34.95% 100.86% 95.05% 0.00% 0.00% $ 3,000.00 790,202.28 1,140,591.51 $ 1,460,200.00 $ (319,608.49) 137,281.12 $ 220,092.48 235,149.00 $ (15,056.52) 580.00 $ 338,437.00 $ 337,857.00 802,032.97 $ 593,907.00 $ (208,125.97) 636,043.96 135,275.24 $ 253,148.32 141,327.29 $ 142,530.33 (645,970.74) Actuals 94,460.00 $ (158,688.32) 202,149.00 (392,795.10) (142,530.33) #DIV/OI 142,530.00 2,101,353.87 $ 2,171,548.09 $ 2,312,100.00 140,551.91 FV2 2022-2 2023 FY2 2023- 20241 Year FV: 2023- 2024 Budget Balance 90,457.72 To Date Actuals Budget Remaining $ (105.00) (520.13) 50,000.00 210.00 $ 350.00 $ 38,633.07 $ 60,720.13 105.00 $ 2,096.86 $ 6,000.00 $ 3,903.14 3,000.00 3,000.00 60,200.00 50,000.00 $ 50,000.00 $ 50,000.00 $ 39,193.07 $ 62,921.99 $ 66,200.00 $ 3,278.01 99,342.50 $ 99,342.50 (99,342.50) #DIV/O! $ (99,342.50)0.009 39,193.07 39,193.07 Actuals 162,264.49 116,200.00 (46,064.49) 162,264.49 $ 116,200.00 $ (46,064.49)! 139.64% $ 3,000.00 139.64% $ 3,000.00 Balance Proposed FV 2024- Remaining 2025 Budget -3.01% -3.01% $ 79.07% $ 1,541,659.31 79.07% $ 1,541,659.31 78.11% $1541,659.31 78.11% $ 1,541,659.31 FV2 2022-2023 FV 2023-2 2024 Year FV2 2023-2024 Budget Balance To Date Actuals Budget (511.49) Remaining 17,000.00 $ 17,511.49 (10.48) $ (10.48)! $ (511.49)! $ 17,000.00 $ 17,511.49 790,212.76 $ 1,141,103.00 $ 1,443,200.00 $ 302,097.00 $ 790,212.76 $ 1,141,103.00 $ 1,443,200.00 $ 302,097.00 790,202.28 1,140,591.51 s 1,460,200.00 $ 319,608.49 790,202.28 $ 1,140,591.51 $ 1,460,200.00 319,608.49 02- Utilities Fund (Revenue) 80-Water 80-6 6400 - Business & Franchise 80-6401 Water 80-6402 UtilityP Penalties 80-6412V Water TapF Fees 80-6 6400 - Business &F Franchise Total 80 --Water Total Grand Total 02- Utilitles Fund (Revenue) 81-Sewer. 81-6400 Business & Franchise 81-6402 Utility Penalties 81-6411 Wastewater 81-6412 Sewer Tap Fees 81-6400- Business a Franchise Total 81- Sewer1 Total Grand Total 02- -Utilities Fund (Revenue) 84-Garbage. 84-6400- Business & Franchise 84-6402 Garbage! Late Penalties 84-6421 Garbage Revenue 84-6400- Business & Franchise Total 84- Garbage Total Grand Total 02-- Utitility FundT Total 02-U Utilities Fund (Expense) 00-7 7000 Personnel 00-7003 Utility Clerk 00-7011 Salariesa and Wages 00-7021 State Unemployment Taxes- SUI 00-7032 Health Insurance 00-7033 Employee Retirement 00-7000 - Personnel Total 00-7022 - Other Sources 00-7022 Federal Payroll Taxes FICA 00-7022- Other Sources Total 00-7 76008 &0 00-8 8952 Contractual 00-7651 Contract Services- Regularly Scheduled 00-8952 Software Licenses FY 2022-2023 FY2 2023-2024 Year FV2 2023-2024 Budget Balance 280,932.56 $ 424,236.15 $ 436,200.00 $ 11,963.85 322,354.55 $ 475,999.50 $ 446,200.00 $ (29,799.50) 322,354.55 $ 475,999.50 446,200.00 (29,799.50)! 322,354.55 $ 475,999.50 $ 446,200.00 $ (29,799.50)! FV 2022-2023 FV 2023-2024) Vear FV2023-2024 Budget Balance Balance Proposed FV 2024- Remaining 2025 Budget 97.26%_$ 836,127.41 120.00% 106.68% 881,127.41 106.68% 881,127.41 106.68% 881,127.41 Balance Proposed FV: 2024- Remaining 2025 Budget 101.07% 302,364.89 140.00% 102.56% $ 312,364.89 102.56% $ 312,364.89 102.56%s 312,364.89 Balance Proposed FV 2024- Remaining 2025 Budget 93.63% 268,172.01 93.60% $ 268,172.01 93.60% 268,172.01 93.60% 268,172.01 89.97% $ Actuals To Date Actuals Budget Remaining 31,421.99 $ 10,000.00 39,763.35 12,000.00 (39,763.35) #DIV/O! (2,000.00) 35,000.00 10,000.00 10,000.00 Actuals To Date Actuals Budget Remaining (4.08) $ 10,000.00 $ 166,352.11 Actuals $ (87.75) $ 14,000.00 263,057.83 $ 256,500.00 ToD Date Actuals Budget $ 137,281.12 $ 220,159.98 137,281.12 137,281.12 1,455,383.13 Actuals 87.75 #DIV/O! (4,000.00) (6,557.83) (6,557.83)! Remaining 156,356.19 $ 249,145.58 $ 246,500.00 $ (2,645.58) 166,352.11 $ 263,057.83 $ 256,500.00 10,000.00 10,000.00 166,352.11 $ 263,057.83 L$ 256,500.00 $ (6,557.83)! FV2 2022-2023 FV 2023- 2024 Year FV: 2023-2024 Budget Balance (67.50)! $ 67.50 #DIV/O! 14,989.02 15,056.52 15,056.52 235,149.00 $ 137,281.12 $ 220,092.48 $ 235,149.00 $ 15,056.52 220,092.48 235,149.00 220,092.48 235,149.00 2,262,005.81 2,514,249.00 252,243.19 FV 2022-2023 FV 2023-2024 Year FY2 2023-2 2024 Budget Balance Balance Proposed FY 2024- Remaining 2025 Budget 0.00%! 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% $ 9.67% $ 6,000.00 0.00% To Date Actuals Budget Remaining 3,000.00 $ 3,000.00 39,785.00 $ 39,785.00 260.00 11,583.00 3,112.00 57,740.00 $ 57,740.00 2,982.00 $ 2,982.00 $ 2,982.00 260.00 11,583.00 3,112.00 2,982.00 5,420.00 240.00 $ 0.00 0.00 580.00 $ 6,000.00 240.00 240.00 00-76008 &0 00-8 8952 - Contractual Total 00-8551 &00-9101 - Supplies 00-8551 Offices Supplies 00-9101 Operating Supplies Not Office 00-8551 & 00-9101 - Supplies Total 00-9253 - Transfers 00-92531 Interfund Transfer Out 00-9253-1 Transfers Total 00-9351 : Purchased Water 00-9351 Purchased Water1 Total 00-P Personnel Total Grand Total 02-Utilities Fund (Expense) 70-Electric 70-7000- Personnel 70-7011 Salaries andV Wages 70-7021 State Unemployment Taxes- SUI 70-7032 Health Insurance 70-7033E Employee 70-7040F Payroll Reimbursement 70-9201 Trainingz andE Education 70-70008 &7 70-9201 - Personnel Total Other Sources 70-7022 Federal Payroll Taxes- FICA Total Other Sources 70-745187 70-9000- -- Utilities 70-7451 Cellular Phones & Pagers 70-9321 Lighta and Power 70-93221 TCOS 70-74518 & 70-9000- - 70-7 760087 70-8952 - Contractual 70-7651 Contract Services- Regularly Scheduled 70-7652 Contract Services- Emergency 70-7654 Engineering Services 70-8952 Software Licenses 70-7600 &7 70-8952 Contractual" Total 70-8100, 70-9400, 70-9500 Repair& 70-8101 FuelandOil 70-9401 Vehicle! 70-9501 Electric Meters 70-9503 Lines, Poles, &1 Transformers 70-8100, 70-9400, 70-9500- Repair& Maintenance Total 70-8204& 70-8751 580.00 6,240.00 3,000.00 $ 3,000.00 100.00 $ $ 3,100.00 $ 3,100.00 267,375.00 267,375.00 $ 267,375.00 $ 267,375.00 1,000.00 1,000.00 $ 1,000.00 580.00 $ 338,437.00 $ 337,857.00 580.00 $ 338,437.00 $ 337,857.00 FV 2023-2 2024 Vear FV 2023-2024 Budget Balance ToDate Actuals Budget 5,660.00 100.00 9.29% 0.00% $ 0.00% 0.00% $ 0.00% 890,000.00 0.00% $ 890,000.00 0.00% 0.00% $ 0.17% 896,240.00 0.17% 896,240.00 Balance Proposed FY 2024- Remaining 2025 Budget 14.11% $ 7.32% 14.48% 23.74% 0.00% 218,657.00 5.33% 13.85% $ 218,657.00 15.39% 15.39% $ 0.00% 0.00% 57.99% 120,000.00 54.19% $ 120,000.00 143.69% $ 90,000.00 145.74% $ 50,000.00 296.01% 0.00% 181.88% $ 140,000.00 6.36%_$ 10,000.00 13.89% 5.46%_ 5,000.00 28.22% $ 22,500.00 6,240.00 1,000.00 FV2 Actuals Remaining 505.00 $ 132,737.65 $ 41.39 $ 13,719.42 $ 2,717.15 $ 1,939.00 $ 151,154.61 22,994.26 10,154.44 16,742.38 $ 118,680.00 $ 101,937.62 3,353.92 $ 23,156.00 $ 19,802.08 2,060.98 $ 8,680.00 $ 6,619.02 36.98 $ 468.02 800.00 1,280.81 15,000.00 166,021.00 143,026.74 8,320.00 630.00 $ 12,000.00 $ 12,000.00 180,000.00 14,200.00 7,039.19 630.00 75,617.10 $ 10,154.44 $ 1,280.81 $ 8,320.00 $ 7,039.19 104,382.90 Total $ 104,382.90 $ 192,630.00 $ 88,247.10 $ 27,743.58 $ 129,321.82 $ 90,000.00 $ (39,321.82) 5,864.43 33,608.01 $ 10,179.62 $ 21,405.13 3,523.84 $ 43,722.62 $ 30,000.00 $ (13,722.62) 291,450.14 $ 160,240.00 $ (131,210.14) 118,405.70 40,000.00 $ (78,405.70) 240.00 240.00 953.89 694.54 24,049.76 4,811.55 15,000.00 $ 14,046.11 5,000.00 $ 4,305.46 88,095.00 4,000.00 3,500.00 (24,049.76) #DIV/OI 83,283.45 35,108.59 $ 30,509.74 108,095.00 77,585.26 70-8204L Liability Insurance- General Liability 70-8751 Purchased Power 70-820487 70-8751- - Total 70-8250-- Debt Service 70-8251 Interest Expense 70-8250- Debt ServiceTotal Debt Service 70-8451, 70-8551, 70-9100, 70-9300-- Supplies 70-8451 Medicals Supplies 70-8551 Offices Supplies 70-9101 Operating Supplies- Noto Office $ 165,801.28 70-91021 Tools & Non- CapitalE Equipment $ 2,587.17 $ 70-9301 Uniform Expense 70-8451, 70-8551, 70-9100, 70-9300-- Supplies Total 70-9256- Transfers 70-92561 Transfer from Utilitiest to 18S 70-9256- Transfers Total 70-Electric- -Total Grand Total 02-Utlities Fund (Expense) B0-Water. 80-7000 &8 80-9201 Personnel 80-7011 Salaries and Wages 80-7021 State Unemployment Taxes- SUI 80-7032 Health Insurance 80-7033 Employee Retirement 80-7 7040 Payroll 80-9201 Training andE Education 80-7000 a 80-9201 - Personnel Total 80-7 7022 Other Sources 80-7022 Federal Payroll Taxes- FICA 80-7022- - Other 80-7400- - Capital 80-7401 Capital 80-7400 - Captial Total 80-7451 &8 80-9154- 80-7451 Cellular Phones8 & Pagers 80-9151 Telephone8 & Internet Services 80-745188 80-9154- - Utilities Total 80-7 7501, 80-8551, 80-9100, 80-9301 - Supplies 80-7501 Chemicals 80-8551 Offices Supplies 80-9101 Operating Supplies- Noto Office 80-91021 Tools& Non- Capital Equipment 25,620.00 530,000.00 9,100.00 9,100.00 $ 9,100.00 500.00 300.00 1,500.00 $ (48,858.00) 2,000.00 3,040.00 7,340.00 $ (43,382.22) 77,930.00 77,930.00 $ 77,930.00 25,620.00 58,083.60 9,100.00 500.00 300.00 1,819.79 2,855.99 77,930.00 0.00% 89.04% 555,000.00 84.94% $ 580,000.00 0.00% 0.00% 0.00%$ 0.00% 3357.20% 9.01% 6.05% 691.04% $ 48,000.00 0.00% 0.00% 75.72% $1,129,157.00 75.72%s 1,129,157.00 Balance Proposed FY 2024- Remaining 2025 Budget 15.09% 1.74%_$ 15.94%_s 0.00%_$ 0.00% 233,073.65 0.00%$ 14.35% $ 233,073.65 19.56%_s 19.56% $ 103.57%_s 103.57% $ 15,000.00 335.29%_s 277.23%s 321.22% $ 6,000.00 114.75%_s 1227.93%s 139.39%_$ 25,000.00 790,293.28 790,293.28 471,916.40 471,916.40 $ 555,620.00 $ 83,703.60 50,358.00 180.21 184.01 50,722.22 45,500.00 500.00 2,000.00 168,388.45 1,188,707.38 Actuals 973,256.47 $ 1,285,296.00 $ 312,039.53 1,188,707.38 $ 973,256.47 $1,285,296.00 $ 312,039.53 FV 2022-2023 FV: 2023- 2024 Vear FV2 Budget Balance Remaining 272,313.20 1,238.05 48,641.72 19,780.00 2,000.00 15,251.43 (462.01) To Date Actuals Budget 48,376.80 21.95 9,223.28 56,604.00 20.69 8,780.31 $ 1,260.00 57,865.00 19,780.00 2,000.00 18,960.00 $ 65,405.00 $ 57,622.03 $ 401,595.00 $ 343,972.97 4,330.29 $ 4,330.29 $ 29,430.44 13,412.01 7,176.20 $ 1,152.80 11,842.74 $ 59,173.03 $ 4,757.64 $ 3,708.57 Total 3,708.57 $ 18,960.00 $ 15,251.43 12,950.00 15,000.00 5,000.00 1,000.00 14,000.00 25,000.00 1,500.00 $ 29,430.44 $ 13,412.01 $ 12,950.00 $ (462.01) 5,029.42 $ 1,330.69 $ 13,770.33 119.99 24,558.54 2,787.81 $ 1,500.00 $ (3,529.42) 480.00 (850.69) $ 8,329.00 $ 6,360.11 $ 1,980.00 $ (4,380.11) 12,000.00 $ (1,770.33) 2,000.00 2,000.00 (119.99)! #DIV/OI (22,558.54) (787.81)! 80-9301 Uniform Expense 80-7501, 80-8551, 80-9100, 80-9301- Supplles Total 80- 7650, 80-8351, 80-8952 Contractual 80-7651 Contract Services- Regularly 80-7654E Engineering Services 80-8351E Equipment Rental 80-8952 Software Licenses 80-7650, 80-8351, 80-8952-- Contractual Total 8851, 80-9401, 80-9502 - Repair& Maintenance 80-7653 Water TankF Repaira and Maintenance 80-8051 Equipment Maintenance 80-8101 Fuela andOil 80-8851 Facility Maintenance 80-9401 Vehicle Maintenance 80-9502V Wells, Lines, & Meters 80-7653, 80-8051, 80-8101, 80-8851, 80-9401, 80-9502 - Repair & 80-7951, 80-9251, 80-9400 Miscellaneous 80-7951 Dues and Membership Fees 80-9251 Travel Expense 80-9451 Sample Analysis 80-9471 Water System Fees 80-7951, 80-9251, 80-9400- Miscellaneous Total 80-8250 Debt Service 80-8251 Interest Expense 80- 8250- Debt Service Total 80-9250 - Transfers 80-92561 Transfer from Utilitiest to I8S 80-9250 - Transfers Total 80-Water- Total Grand Total 02-Utilities Fund (Expense) B1-Sewer 81-7401 Capital 81-7401 Capital Expenditures 81-7401 Capital Total 81-7501, 81-8030, 81-8451, 81-9100 Supplies 81-7501 Chemicals 81-8030 Equipment Purchases 81-8451 Medical Supplies 81-8551 Offices Supplies 81-9101 Operating Supplies- Not Office_$ 33,783.21 81-91021 Tools & Non- CapitalE Equipment 81-7501, 81- 8030, 81-8451, 81-9100- Supplies Total 4,433.83 4,262.35 54,000.00 259,539.56 473,619.60 1,869.78 259,539.56 529,489.38 43,138.72 $ 5,400.85 33,442.83 2,816.00 126.38 89,268.02 1,805.00 158.56 3,142.88 9,503.19 3,920.00 42,702.00 5,000.00 (468,619.60) 240.00 47,942.00 39,400.00 500.00 10,000.00 3,000.00 (342.35) (11,298.00) (1,869.78) #DIV/O! 240.00 (481,547.38) (5,180.45) (13,776.23) (15,278.08) (77.20) #DIV/OI (1,108.59) (39,848.89)! #DIV/O! (1,985.00) #DIV/O! (46.83) #DIV/O! 804.00 (14,044.58) #DIV/OI 5,280.00 29,880.00 108.73%s 228.41% $ 45,500.00 126.46%s 9472.39% 0.00% 1104.44% $ 127,000.00 113.15%s 2855.25% 252.78% 136.95%_$ 242.29% $ 134,000.00 5,000.00 50,000.00 75,000.00 2,000.00 80,207.24 $ 45,499.02 $ 19,920.00 $ (25,579.02) 44,580.45 14,276.23 25,278.08 77.20 4,108.59 39,848.89 1,985.00 46.83 1,696.00 14,044.58 42,000.00 20,000.00 10,000.00 2,000.00 10,000.00 50,000.00 2,000.00 200.00 2,500.00 14,000.00 5,300.00 174,192.80 $ 128,169.44 $ 52,900.00 $ (75,269.44) 2,500.00 67.84%_s 710.90% $ 18,700.00 0.00% 0.00% $ 5,300.00 0.00% 0.00% 135.04% 323,373.65 135.04%s 323,373.65 Balance! Proposed FY: 2024- Remaining 2025 Budget $ 14,609.63 $ 17,772.41 $ 2,500.00 $ (15,272.41) 5,280.00 $ 5,280.00 $ 5,280.00 29,880.00 29,880.00 $ 29,880.00 593,907.00 $ (208,125.97) 636,043.96 Actuals 802,032.97 ToDate Actuals Budget 7,867.94 7,867.94 $ 70.00 255.85 52,301.02 886.66 $ 636,043.96 s 802,032.97 $ 593,907.00 $ (208,125.97) FV2 2022-2023 FY 2023-2024 Vear FV 2023-2024 Budget Balance Remaining (7,867.94) #DIV/OI (7,867.94) #DIV/O! 2,000.00 $ 1,930.00 3.50%_$ (255.85) #DIV/O! 500.00 500.00 0.00% 250.00 250.00 0.00%$ 1,000.00 (51,301.02)! 5230.1094 1,000.00 113.34 88.67% 8,000.00 2,000.00 500.00 52,000.00 1,000.00 33,783.21 $ 53,513.53 $ 4,750.00 $ (48,763.53)! 1126.60% 55,500.00 81-7650881-8351- Contractual 81-7651 Contract Services-F -Regularly Scheduled 81-7652 Contracts Services- Emergency 81-7654 Engineering Services 81-8351 Equipment Rental 81-7650 81-8351 Contractual 81-8051, 81-8101, 81-9401 - Repair& Maintenance 81-8051 Equipment Maintenance 81-8101 Fuela andOil 81-9401 Vehicle Maintenance 81-8051, 81-8101, 81-9401 Repair& Total 81-8111- Grant Expense 81-8111 Grant Programs City's Portion 81-8111- Grant Expense Total 81-8250- Debts Service 81-8251 Interest Expense 81-8250- - Debts Service Total 81-86018 &81-9451 81-8601F Permit Fees 81-9451 Sample Analysis 81-86018 &8 81-9451- Miscellaneous Total 81-9150- Utilities 81-91517 Telephone& Internets Services Total Utilities 81-9200- 81-92011 Training andE Education 81-9200 - Personnel Total 91-9250- Transfers 81-92561 Transferf from Utilities tol 185 91-9250- --1 Transfers Total 81-Sewer- Total Grand1 Total 02-Utilities Fund (Expense) 84-Garbage 84-7650- Contractual 84-7652 Contract Services-s Solid Waste Collection Total Contractual 84-Garbage- Total Grand Total Total Expense 111,870.25 18,798.66 $ 9,775.11 4,482.99 10.98 16,675.40 1,000.00 $ 1,000.00 $ 1,100.00 (110,770.25) 2,000.00 5,000.00 10170.02% 939.93% 0.00%_$ 100,000.00 20,000.00 10,000.00 2,000.00 5,000.00 4,000.00 48,178.76 2,295.48 14,917.78 11,461.18 (16,798.66) 5,000.00 (9,775.11) #DIV/OI (3,482.99) 6,589.02 (14,675.40) Total $ 50,474.24 $ 140,444.02 $ 8,100.00 $ (132,344.02) 1733.88% 130,000.00 1,000.00 6,600.00 2,000.00 448.30%_s 0.17% 833.77% 220.51% 11,000.00 $ 26,378.96 $ 21,169.37 $ 9,600.00 $ (11,569.37) (1,000.00) #DIV/OI $ (1,000.00) #DIV/O! 6,850.00 6,850.00 $ 6,850.00 $ 6,850.00 0.00% 0.00% $ 32.38% 173.32% 30,500.00 0.00% 0.00% $ 14,775.11 9,863.72 23,677.00 5,440.46 (23,677.00) #DIV/O! 11,359.54 1,200.00 24,000.00 6,500.00 16,800.00 1,200.00 $ 1,200.00 $ 1,200.00 24,638.83 $ 29,117.46 $ 16,800.00 $ (12,317.46) $ 36.00 36.00 (36.00) #DIV/OI $ (36.00)! #DIV/O! $ 1,000.00 47,160.00 1,000.00 47,160.00 47,160.00 $ 47,160.00 0.00% 0.00% $ 268.00% $ 228,000.00 268.00% $ 228,000.00 Balance Proposed FV 2024- 2025 Budget 142,530.00 142,530.00 93.92% $ 2,719,300.65 135,275.24 Actuals 253,148.32 $ 94,460.00 $ (158,688.32) 135,275.24 $ 253,148.32 $ 94,460.00 $ (158,688.32)! FY2 2022-2023 FY 2023-2024 Vear FV 2023-2024 Budget Balance To Date Actuals Budget 142,530.33 142,530.33 Remaining 141,327.29 $ 141,327.29 $ 142,530.33 $ 141,327.29 141,327.29 $ 142,530.33 (142,530.33) #DIV/O! $ (142,530.33) #DIV/0! $ 142,530.00 (142,530.33) #DIV/OI $ 142,530.00 $ (142,530.33)! #DIV/O! $ 2,101,353.87 $ 2,171,548.09 $2,312,100.00 140,551.91 FY2023-2024 Actuals Budget 1,448.89 FY: 2023-2024 FY 2023-2024 Proposed FY 04- Hotel Occupancy Tax Fund FY2022-2023 Vear To Date FV: 2023-2024 Budget Balance %B Balance 2024-2025 (Summary) Revenue Summary 60-Special Revenue Revenue Totals Revenues Over(Under) Expenditures 04- Hotel Occupancy Tax Fund (Revenue) 60-Special Revenue Business & Franchise 60-7777 Hotel Occupancy Tax Total Business & Franchise Total Special Revenue Total Revenue Actuals Remaining 1,448.89 $ $ 1,448.89 $ $ 1,448.89 Remaining Budget $ 1,000.00 $1,000.00 $ 1,000.00 $1,448.89 $1,448.89 $ 1,448.89 $1 1,448.89 $ FY2 2023- FY2023-2024 FY2 2023-2024 Proposed FY FY2022- 2024 Vear To FY: 2023-2024 Budget Balance % Balance 2024-2025 2023 Actuals Date Actuals Budget Remaining $ 1,448.89 0.00 $ 1,448.89 0.00 $ 1,448.89 0.00 $ 1,448.89 0.00 Remaining Budget $ 1,448.89 $ $1,448.89 $ $1,448.89 $ $1,448.89 $ 1,000.00 $1,000.00 $1,000.00 $1,000.00 ORDINANCE 2024-09-23-01 AN ORDINANCE OF THE CITY OF BARTLETT, TEXAS, ADOPTING A BUDGET FOR THE FISCAL YEAR BEGINNING OCTOBER 1, 2024, AND ENDING ON SEPTEMBER 30, 2025; AUTHORIZING CERTAIN ADJUSTMENTS TO THE BUDGET; AND INCLUDING PROCEDURAL PROVISIONS WHEREAS, The Mayor and City Council have prepared a proposed budget for fiscal year 2024 WHEREAS, The City Council discussed the proposed budget for fiscal year 2024- 2025 at public WHEREAS, The proposed budget has been on file with the city clerk and made available to the WHEREAS, Apublic hearing on the proposed budget was held by the City Council on September WHEREAS, The City has complied with all applicable requirements of the Texas Local NOW, THEREFORE, BE IT ORDAINED BY THE CITY COUNCIL OF BARTLETT, TEXAS: The City of Bartlett 2024 = 2025 proposed budget is approved and adopted for the fiscal year - 2025. meeting on July 11th, 2024. public for review as required by State law. 23, 2024, and all interested persons were given an opportunity to be heard for or against any item or the amount of any item contained in the budget. Government Code prior to the adoption of the proposed budget. Section 1. beginning October 1, 2024 and ending September 30, 2025 Section 2. The City Administrator is authorized to transfer funds from the Utility Fund to the General Fund under the following conditions: A. The City's internal accountant has submitted supporting documentation for the transfer B. Written approval for the transfer is signed by at least two of the normal bank account C. The City Administrator is directed to provide monthly reports to the City Council on to the City Administrator. signatories authorized by the City Council. transfers and reimbursements made under this authorization. Section 3. Upon closure of the 2024-2025 fiscal year (date range Oct. 1, 2024 - Sept. 30, 2025) the City Treasurer will inform the city council of any un-used funds from that budget year that may be made available for long-term capital improvements for the city (i.e., roads, wastewater infrastructure, city vehicles, buildings, etc.) and upon council approval. Section 4. Ifany word, phrase, clause, sentence, or paragraph of this Ordinance is held to be unconstitutional ori invalid by a Court of competent jurisdiction, the other provisions of this Ordinance will continue int full force and effect. Section 5. are repealed. All ordinance and resolutions or parts of ordinances or resolutions in conflict with this Ordinance PASSED AND APPROVED THIS 23rd DAY OF SEPTEMBER, 2024. CHAD MEES, MAYOR BARTLETT, TEXAS ATTEST: BRENDA KELLEY, CITY SECRETARY ORDINANCE 2024-09-23-02 AN ORDINANCE OF THE CITY OF BARTLETT, TEXAS, SETTING A TAX RATE AND LEVYING TAXES FOR THE SUPPORTAND USE OF THE MUNICIPAL GOVERNMENT FOR THE FISCAL YEAR BEGINNING OCTOBER 1, 2024, AND ENDING ON SEPTEMBER 30, 2025; AND INCLUDING PROCEDURAL PROVISIONS WHEREAS, The Chief Appraiser of the Bell and Williamson County Appraisal Districts has prepared and certified the appraisal roll for the City, being that portion of the approved appraisal roll of the Bell and Williamson County Appraisal Districts which accordance with the applicable requirements of State law in the Temple Daily 23, 2024. All interested persons were given an opportunity at the hearings to be list property taxable by the City. Telegram on September 13th, 2024. heard for or against the proposed tax rate WHEREAS, Notice of the proposed tax rate for the City for the 2024 tax year was published in WHEREAS, Publichearings on the proposed tax rate were held by the City Council on September WHEREAS, The City has complied with all applicable requirements of the Texas Local NOW, THEREFORE, BE IT ORDAINED BY THE CITY COUNCIL OF BARTLETT, TEXAS: The tax rate for the City of Bartlett, Texas for the tax year 2024-2025 is set at seventy-one and sixty-six thousandth cents ($0.7166) on each one hundred dollars ($100) of the taxable value of real and personal property not exempt from taxation by the constitution and laws of this State situated within the corporate limits ofi the City. THIS RATE WILL RAISE MORE REVENUE FROM PROPERTY TAXES THAN LAST YEAR'S RATE BY AN AMOUNT OF $8,618.88 WHICH IS A 1.00% INCREASE FROM LAST YEAR'S RATE. THE PROPERTY TAX REVENUE TO BE RAISED FROM NEW PROPERTY ADDED TO THE TAX ROLL THIS YEAR IS $725.97. The tax rate in Section 1 above is levied for the tax year 2024-2025 upon real and personal property not exempt from taxation by the constitution and laws of this State situated within the corporate limits of the City and shall be collected for the use and support of the municipal Government Code prior to the adoption of the proposed budget. Section 1. Section 2. government of the City of Bartlett, Texas. Section 3. The Tax Assessor-Collector is authorized to assess and collect the taxes of the City employing thei tax rate stated in Section 1 of this ordinance. Section 4. The City Administrator shall keep accurate and complete records of all funds collected under this Ordinance and of the purposes for which they are expended. Section 5. Funds collected pursuant tot this ordinance shall be expended as set forth in the City of Bartlett 2024-2 2025 Budget, as may be amended from time to time. Section 6. General Fund All funds collected by the City which are not specifically appropriated shall be deposited in the PASSED AND APPROVED THIS 23rd DAY OF SEPTEMBER, 2024. CHAD MEES, MAYOR BARTLETT, TEXAS ATTEST: BRENDA KELLEY, CITY SECRETARY ORDINANCE 2024-09-23-03 AN ORDINANCE AMENDING THE UTILITY RATE STRUCTURE FOR RESIDENTIAL AND COMMERCIAL CUSTOMERS; PROVIDING FOR AN INCREASE IN ELECTRIC RATES; AND PROVIDING AN EFFECTIVE DATE. WHEREAS, the City has reviewed the current utility rate structure in accordance with its authority WHEREAS, the City recognizes that adjustments to the utility rates are necessary to ensure that under the Texas Utility Code; and the electric utility has a reasonable opportunity to earn a reasonable return on invested capital, as required by Texas Utility Code Section 36.051, while maintaining the quality of service, efficiency of operations, and conservation efforts, as necessary operating expenses, while providing reliable service to the public; and prescribed in Section 36.052; and WHEREAS, the City is committed to establishing rates that cover the utility's reasonable and WHEREAS, the Customer Charge is $30.00 for residential customers the Customer Charge is WHEREAS, the current rate of $0.1215 per kilowatt-hour (kWh) for residential customers and WHEREAS, the City has determined that an increase in rates is necessary and appropriate to NOW, THEREFORE, BE IT ORDAINED BY THE CITY COUNCIL OF BARTLETT, TEXAS: Section 1. Amendment to Base Fees for Residential and Commercial Users - S A5.041 & The current base fee of $30.00 for in-city customers is hereby amended to $32.50, effective upon Section 2. Amendment to Residential Utility Rate - S A5.041 Residential rate classification. The current residential utility rate of$0.1215 per Kilowatt-hour (kWh) is hereby amended. The new residential rate shall be $0.1356 per kilowatt-hour (kWh), effective upon the adoption of this Section 3. Amendment to Commercial Utility Rate - S A5.042 Commercial rate The current commercial utility rate of $0.0975 per Kilowatt-hour (kWh) is hereby amended. The new commercial rate shall be $0.1175 per kilowatt-hour (KWh), effective upon the adoption of this $30.00 for commercial customers; and $0.0975 per kilowatt-hour (kWh) for commercial customers; and the rates remain fair and equitable to all customers. provide the utility with sufficient revenues to meet its obligations while ensuring that A.5042 the adoption of this ordinance. ordinance. classification. ordinance. Section 4. Findings of Compliance with Texas Utility Code Ina adopting the rate adjustments set forth herein, the City Council has considered and complied with Texas Utility Code Sections 36.051 and 36.052. The rates adopted herein allow the electric utility a reasonable opportunity to earn a fair return on its invested capital used and useful in providing service to the public, and such rates have been determined to bej just, reasonable, and necessary. Section 5. Effective Date publication as required by law. Section 6. Severability This ordinance shall take effect immediately October 1st, 2024 upon its passage, approval, and Ifany provision of this ordinance or the application thereof to any person or circumstance is held invalid, such invalidity shall not affect other provisions or applications of the ordinance that can be given effect without the invalid provision or application, and to this end the provisions of this ordinance are declared to be severable. PASSED AND. APPROVED THIS 23rd DAY OF SEPTEMBER, 2024. CHAD MEES, MAYOR BARTLETT, TEXAS ATTEST: BRENDA KELLEY, CITY SECRETARY ORDINANCE 2024-09-23-04 AN ORDINANCE AMENDING THE WATER UTILITY RATE STRUCTURE FOR IN-CITY AND OUT-OF-CITY RESIDENTIAL AND COMMERCIAL CUSTOMERS; PROVIDING FOR AN INCREASE IN WATER RATES; AND PROVIDING NOTICE REQUIREMENTS FOR OUT-OF-CITY RATEPAYERS. WHEREAS, the City has reviewed the current water utility rate structure in accordance with its WHEREAS, Texas Water Code Section 13.042 grants municipalities exclusive original jurisdiction authority under the Texas Water Code; and over water and sewer utility rates, operations, and services provided within the corporate limits of the municipality, and the City Council seeks to ensure that these rates are fair, just, and reasonable while maintaining adequate and efficient services city and out-of-city residential and commercial customers to reflect increasing costs notice to out-of-city customers regarding any rate changes, including the effective date oft the new rates and additional information on how to obtain rate details; and capital costs associated with providing reliable water services to both in-city and out- provide the utility with sufficient revenues to meet its obligations while ensuring that for all in-city customers; and WHEREAS, the City recognizes the need to adjust water utility rates and base fees for both in- WHEREAS, Texas Water Code Section 13.043() requires the City to provide individual written WHEREAS, the current water rates are insufficient to meet the operational, maintenance, and WHEREAS, the City has determined that an increase in rates is necessary and appropriate to NOW, THEREFORE, BE IT ORDAINED BY THE CITY COUNCIL OF BARTLETT, TEXAS: Section 1. Amendment to Base Fees for In-City and Out-of-City Customers and to ensure the long-term sustainability of water services; and of-city customers. the rates remain fair and equitable to all customers. A. In-City Customers: The current base fee of $30 for in-city customers is hereby amended to $32.50, effective upon the adoption of this ordinance. B. Out-of-City Customers: The current base fee of $45 for out-of-city customers is hereby amended to $47.50, effective upon the adoption of this ordinance. Section 2. Amendment to In-City Residential Water Rate The current in-city residential water rate of $6.125 per thousand gallons is hereby amended. The new rate for in-city residential customers shall be $6.325 per thousand gallons, effective upon the adoption of this ordinance. Section 3. Amendment to In-City Commercial Water Rate The currenti in-city commercial water rate of $6.125 per thousand gallons is hereby amended. The new rate for in-city commercial customers shall be $6.325 per thousand gallons, effective upon the adoption of this ordinance. Section 4. Amendment to Out-of-City Residential Water Rate The current out-of-city residential water rate of $6.325 per thousand gallons is hereby amended. The new rate for out-of-city residential customers shall be $6.545 per thousand gallons, effective upon the adoption of this ordinance. Section 5. Amendment to Out-of-City Commercial Water Rate The current out-of-city commercial water rate of $6.125 per thousand gallons is hereby amended. The new rate for out-of-city commercial customers shall be $6.325 per thousand gallons, effective upon the adoption of this ordinance. Section 6. Notice to Out-of-City Ratepayers Pursuant to Texas Water Code Section 13.043(), the City shall, within 60 days of this rate change, provide individual written notice to each out-of-city ratepayer eligible to appeal. The notice must include, at a minimum: The effective date of the new rates; The new rates as established by this ordinance; The location where additional information on rates may be obtained. The notice may be provided electronically if the City has access to a ratepayer's e-mail address. This ordinance shall take effect immediately upon its passage, approval, and publication as Section 7. Effective Date required by law. Section 8. Severability Ifa any provision of this ordinance or the application thereof to any person or circumstance is held invalid, such invalidity shall not affect other provisions or applications of the ordinance that can be given effect without the invalid provision or application, and to this end, the provisions of this ordinance are declared to be severable. PASSED AND APPROVED THIS 23rd DAY OF SEPTEMBER, 2024. CHAD MEES, MAYOR BARTLETT, TEXAS ATTEST: BRENDA KELLEY, CITY SECRETARY TDEM THE TEXASAGM UNIVERSITYSYSTEM September 17, 2024 The Honorable Chad Mees Mayor City of Bartlett 140' W Clark Bartlett, TX 76511 Subject: Sub-Grant Award Dear Mayor Mees: The Texas Division of Emergency Management (TDEM) has issued a sub-grant for the Hazard Mitigation Grant Program (HMGP), DR-4485, Texas Covid-19 Pandemic. The following is the information related to this award: Sub-Recipient Information: UEI Number: TINS Number: FIPS Number: Award Information: CD7CYEMV1SB7 74-6000224 491-05732-00 Catalog of Federal Domestic Assistance: 97.039 FEMA Project Number: 0061 Project Title: City of Bartlett Fire Dept & Water Wells Generators Period of Performance (POP): September 3, 2024 to August 25, 2026 PROJECT FUNDS OBLIGATIONS Total Subgrant Share % Amount Version/ Amendment Date 0 Federal Federal Share Amount Local Share % Local Share Amount 9/3/2024 $450,048.00 90% $405,043.20 10% $45,004.80 Please Note: This award is not for research or development as defined in 2 Code of Federal The eligible management costs for a reimbursement request are calculated by multiplying the eligible direct project costs submitted by the percentage of obligated management costs (up to5 5%) for the project. In some cases, the management costs submitted for a reimbursement Regulations (C.F.R.5200.87. 2883 Highway 71E PO Box 285 Del Valle, TX78617-9998 Page 2 DR-4485-0061 Award Letter will exceed the eligible management cost amount. In this instance, the management costs will be trapped until additional eligible direct project costs are submitted for reimbursement, MANAGEMENT COSTS OBLIGATIONS Total Management Costs Federal Share % 100% Federal Share Amount $22,502.40 Local Amount $0 Version/ Amendment 0 Local Share % Share 0% Date 9/3/2024 $22,502.40 The approved Scope of Work (SOW) follows and the terms and conditions of this award are attached. It is important that the sub-recipient read, understand and comply with the SOW and all terms and conditions. It is also vital that this information be disseminated to sub- The City of Bartlett proposes to install three permanently mounted, emergency generators with associated automatic transfer switches and electrical system upgrades at three City of Bartlett locations. The generator will be attached to a 13'L x 8'Wx 6"D concrete slab, within a 6' high barbed-wire fence enclosure. The proposed generators will mitigate the water supply and fire department equipment from being compromised during power outages. Providing the generators at the three sites will provide emergency power that would allow the City to continue to operate its water supply and provide fire safety service to its citizens through short and long duration disasters. The proposed locations of the generators include: 1. The City of Bartlett's Main Water Well, located on 117 Emma Street B, Bartlett, Texas, 2. The City of Bartlett's Fire Department, located at 200 West Clark Street, Bartlett, Texas, 3. The City of Bartlett's 2nd Water Well, located at 135 West Pietzsch Street, Bartlett, Texas, The City of Bartlett proposes to use approved MC for recordkeeping, notice of award/contract execution, kick-off meeting, startup docs, establish files, maintain records, progress meetings, embursemenVminancal management, design phase, bids, construction City of Bartlett has been granted an Extraordinary Circumstances exception under the provisions of Title 44 of the Code of Federal Regulations (44 C.F.R.)S 201.6. This award is recipient's staff and contractors involved in work related to this project. 76511 north of the Water Treatment Plant (30.793823, -97.430402). 76511 (30.796239, -97.429969). 65100/9489.974.9) compliance, quarterly reporting, close-out, and completion. 2883 Highway 71E PO Box 285 Del Valle, TX78617-9998 Page 3 DR-4485-0061 Award Letter contingent upon the subrecipient submittal and FEMA approval of the mitigation plan within 12 months from the date of email transmission of this letter. If the City of Bartlett does not satisfy this requirement within one year, the approved project will be terminated by FEMA and any costs incurred after notice of termination will not be reimbursed. The recipient must agree to monitor the plan update process to ensure the plan stays on course for completion. Ifthe plan is not approved within this timeframe, all remaining funds will be returned to In accordance with FEMA Instruction 108-1-1 and DHS Instruction 023-01-001-01; this project has been determined to be Categorically Excluded (CATEX M13). FEMA concludes that the project is categorically excluded from the National Environmental Policy Act (NEPA) requirement to prepare further environmental documentation. No extraordinary conditions in accordance with DHS Instruction 023-01-001-01 exist involving this project. Signing and returning this award letter indicates sub-recipient's acceptance of the SOWof the sub-award, the ability to pay the local cost share, and all grant terms and conditions FEMA. outlined in the attached documents. The sub-recipient must ensure that: 1. The initial quarterly progress report for the project is submitted at the end of the approving quarter. Please include the project number (provided above) in your future quarterly reports. Note that 44 C.F.R. $2 206.438(c) indicates the state must provide a quarterly progress report to FEMA indicating the status and completion date for each project funded. The report must include any problems or circumstances affecting completion dates, SOW, or project cost that may result in non-compliance with the 2. Ina accordance with HMGP rules and policy, TDEM requires the submittal of all closeout documentation within 90-days of the project completion not to exceed the POP. The Governor's Authorized Representative (GAR) "shall certify that reported costs were incurred in the performance of eligible work, that the approved work was completed and that the mitigation measure is in compliance with the provisions of the FEMA-State Agreement" in accordance with 44 C.F.R. S2 206.438(d). Ifchanges are needed to the SOW for the sub-award, period of performance or costs associated to the sub-award, the sub-recipient should immediately contact TDEM. No change to the sub-award will be considered approved until the sub-recipient is notified in writing by approved grant conditions. TDEM. 2883 Highway 71E PO Box 285 Del Valle, TX7 78617-9998 Page 4 DR-4485-0061 Award Letter This signed and dated award letter and attached grant terms and conditions must be returned to TDEM before payment on the sub-award can be processed. Your signature is required on this award letter and on the last page of the attached grant terms and conditions. You must also initial each exhibit on the last page of the grant terms and conditions. Please sign, date, and return both the award letter along with the attached grant terms and conditions acknowledging acceptance of this sub-award via email to the assigned Mitigation Coordinator, Jeffrey Pearce, at effrey.pearce@tdem.texas.gov. Chad Mees, Mayor Date Should you wish to appeal any determination related to this sub-award you must do sO within 60 days of receipt of the notice of the action. You will need to provide your appeal with any documentation supporting your position to your assigned TDEM Mitigation Coordinator within Ifyou have any questions please contact your Mitigation Coordinator, Jeffrey Pearce, at the allotted time. 979-204-2983 orjefrey,pearce@tdem.texas.gov. Respectfully, R W. Nim Kidd, MPA, CEMO Chief- Texas Division of Emergency Management Vice Chancellor for Disaster and Emergency Services The Texas A&M University System ATTACHMENTS: FEMA Approval Letter Grant Terms and Conditions Record of Environmental Considerations Technical Recommendations Copy: Adrian Flores, City Administrator lyacmin@partel-kus 2883 Highway 71E PO Box 285 Del Valle, TX78617-9998 U.S. Department ofHomeland Security FEMA Region 6 800 N.I Loop 288 Denton,1 TX 76209 FEMA September3 3,2024 W. Nim Kidd, MPA CEM 2883 Highway 71E E. P.O. Box 285 Del Valle, TX 78617-9998 RE: DR-4485-0061-TX Dear ChiefKidd: Chief, Texas Division of Emergency Management Vice Chancellor - The Texas A&M University System ATTN: Mr. Josh Davies, State Hazard Mitigation Officer City of Bartlett - City of Bartlett Fire Dept. & Water Wells Generators Approval Assistance Listing 97.039 Hazard Mitigation Grant Program This letter provides official notification that the Federal Emergency Management Agency (FEMA) approves the application submitted by the City of Bartlett for the City of Bartlett Fire Department and Water Wells Generator project. The Federal share is available through the Hazard Mitigation Grant Program (HMGP) under DR-4485-TX. The non-federal match Pursuant to Section 1215 of the Disaster Recovery Reform Act of2018, which amended Section 324 of the Robert T. Stafford Disaster Reliefand Assistance Act, Subrecipient Management Costs (MC) ini the amount of $22,502.40 are available to the City of Bartlett at a Federal Cost requirement of $45,004.80 will be provided by the City of Bartlett. Share of 100 percent. Summary of funding for the project is illustrated below: DR-4485-0061-TX Federal Share $405,043.20 (90%) $22,502.40 (100%) $427,545.60 Non-Federal Share $45,004.80 (10%) $0.00 (0%) $45,004.80 Total $450,048.00 (100%) $22,502.40 (100%) $472,550.40 Project Costs Subrecipient MC Total Obligation project: The following is the approved scope of work (SOW) and MC activities for the above-referenced www. fema. gov ChiefKidd September 3, 2024 Page 2 The City ofBartlett proposes to install three permanently mounted, emergency generators with associated automatic transfer switches and electrical system upgrades at three City of Bartlett locations. The generator will be attached to a 13'Lx 8'W: X 6"D concrete slab, within a 6' high barbed-wire fence enclosure. The proposed generators will mitigate the water supply and fire department equipment from being compromised during power outages. Providing the generators at the three sites will provide emergency power that would allow the City to continue to operate its water supply and provide fire safety service to its citizens through short and long duration 1.The City of Bartlett's Main Water Well, located on 117 Emma Street B, Bartlett, Texas, 76511 2. The City ofBartlett's Fire Department, located at 200 West Clark Street, Bartlett, Texas, 3. The City of Bartlett's 2nd Water Well, located at 135 West Pietzsch Street, Bartlett, Texas, The City of Bartlett proposes to use approved MC for recordkeeping, notice of award/contract execution, kick-off meeting, startup docs, establish files, maintain records, progress meetings, remburemenlfinancial management, design phase, bids, construction compliance, quarterly City ofBartlett has been granted an Extraordinary Circumstances exception under the provisions ofTitle 44 of the Code of Federal Regulations (44 C.F.R.)$201.6. This award is contingent upon the subrecipient submittal and FEMA approval of the mitigation plan within 12 months from the date of email transmission of this letter. Ifthe City of Bartlett does not satisfy this requirement within one year, the approved project will be terminated by FEMA and any costs incurred after notice of termination will not be reimbursed. The recipient must agree to monitor the plan update process to ensure the plan stays on course for completion. Ifthe plan is not approved within this timeframe, all remaining funds will be returned to FEMA. This project has been determined to be Categorically Excluded (CATEX) in accordance with FEMA Instruction 108-1-1 and Department ofl Homeland Security (DHS) Instruction 023-01- 001-01; CATEX M13 from the need to prepare either an Environmental Impact Statement or Environmental Assessment. No extraordinary circumstances in accordance with DHS Instruction 023-01-001-01 have been identified regarding this action. The subrecipient must comply with all conditions set forth in the attached Record of Environmental Consideration (REC). Failure to comply with these conditions may. jeopardize federal assistance including funding. disasters. The proposed locations oft the generators include: north of the Water Treatment Plant (30.793823,- -97.430402). 76511 00796239,-97429969. 76100.9489,974399) reporting, close-out, and completion. Technical Conditions: 1.The project and all its attendant utilities are supporting a critical action. The generator and all components must be elevated, or otherwise protected, to the 0.2 percent annual chance (500- www. fema. gov ChiefKidd September 3, 2024 Page3 year) base flood elevation (BFE) or the 100-year BFE plus the freeboard required per American Society of Civil Engineers (ASCE-24), whichever is higher. The subrecipient must submit documentation of compliance to FEMA upon closeout. a) Determination oft the BFE may be provided by the local floodplain administrator. This may include an issued permit or elevation certificate. An email or letter from the administrator is also acceptable. Other documentation may include a statement or study by a licensed engineer. A reference to al FEMA Flood Insurance Study or other flood b) Ifmultiple sources of flood hazard data are available for a project site, use the best available information. The best available information is the source which provides the c) In rare situations, elevating or protecting to the BFE or BFE plus freeboard is not practicable. This may be due to engineering feasibility or cost. In those situations, the subrecipient must provide documentation to FEMA with aj justification. The subrecipient must provide proof that non-compliance was due to unfeasibility or cost. 2. The subrecipient must coordinate with the local floodplain administrator to obtain required permits. The subrecipient must comply with any conditions oft the permit(s) prior to initiating work. All permits and coordination pertaining to these activities must be retained by the subrecipient. Submit permits and documentation of coordination to FEMA at closeout. 3. FEMA approved Benefit Cost Analysis (BCA) file titled 4485-0061 BCA Re-analysis.xlsx" is attached to this recommendation. This BCA file must be used for any future scope ofwork The following programmatic conditions must be met within 90 days ofthis award letter or federal funding may be de-obligated: Itemized budget broken out into correct units. FEMA will not establish activity completion timeframes for individual subawards. The Period of Performance (POP) for DR-4485-TX is February 1, 2027, which is 48 months from the close oft the application period. It is the responsibility of the recipient and subrecipient to ensure all approved activities associated with this subaward are completed by the end of the POP. Any costs incurred prior to the date oft this approval or after the POP will be disallowed. A change to the approved SOW requires prior approval from FEMA. The National Environmental Policy Act (NEPA) stipulates that additions or amendments to a HMGP SOW shall be reviewed by all state and federal agencies participating in the NEPA process. NEPA sign-off for all SOW additions or amendments is essential before the revised SOW can be approved by FEMA or product is also acceptable. highest BFE or BFE plus freeboard. and/or budget modifications. implemented by the HMGP subrecipient. www.t fema. gov ChiefKidd September 3, 2024 Page 4 Ina accordance with FEMA Policy #104-11-1 Interim Hazard Mitigation Grant Program Management Costs, any MC provided will be obligated in increments sufficient to cover recipient and subrecipient needs for no more than one year unless contractual agreements require additional funding. Actual subrecipient MC are to be reconciled quarterly during the review of expenditures submitted by the subrecipient through quarterly report process. Subrecipient MC can be expended for a maximum time of 180 days after work is completed for The initial quarterly progress reports for the HMGP project are due at the end oft the approving quarter. Please include this HMGP project in your future quarterly reports. Note that 44 C.F.R. $ 206.438(c) indicates the State must provide a quarterly progress report to FEMA indicating the status and completion date for each project funded. The report will include any problems or circumstances affecting completion dates, SOW, or project cost that may result in non- Ina accordance with HMGP rules and policy, we require the submittal of all closeout documentation within 90 days oft the project completion, not to exceed the POP. Section 206.438(d) of44 C.F.R. requires the Governors Authority Representative to "certify that reported costs were incurred in the performance of eligible work, that the approved work was completed, and that the mitigation measure is in compliance with the provisions of the FEMA- The Obligation Report, REC, Technical Recommendation Report, and 4485-0061 BCA Re- Ifyou have any questions regarding the information, please contact Roosevelt Grant III, Mitigation Division Director, at (940)8 898-5127 or Roosevet.Granttl@@tema.dhs.gov. the subaward or the end ofthe POP, whichever is sooner. compliance with the approved grant conditions. State Agreement." analysis.xlsx are included for your records. Sincerely, GEORGE A Digitally signed by ROBINSON Date: 2024.09.03 George A. Robinson Regional Administrator GEORGEA AROBINSON 11:54:55-05'00' Enclosures: Obligation Report REC Technical Recommendation Report 4485-0061 BCA Re-analysis.xlsx www. .fema. gov DIVISIOA MANP Texas Division of Emergency Management Subrecipient Agreement for TDEM-Administered Grant Awards Date Revised: February 22, 2024 Index Letter to Subrecipient. Subrecipient Information Subrecipient Agreement. II Letter to Subrecipient Dear Subrecipient: Congratulations on your new award! The following document, in conjunction with the applicable State Administrative Plan (SAP) or Disaster State Administrative Plan (DSAP), lays out applicable laws, rules, and regulations set forth by local, State, and Federal authority that you, Subrecipient, agree to upon acknowledgement. Before you may request or receive any funding awarded to you, you must establish acceptance of this award. By accepting this award, you acknowledge that the terms of the following document are conditions of your award. Please read this agreement in full. Acknowledgement by means of signature at the conclusion of the document, holds Subrecipient to the terms and conditions in the agreement. Failure to sign this agreement infringes on the ability to obtain Federal awards, or state or local grant awards, administered through the Texas Division of Emergency Management. Subrecipient Information Entity Information Entity Name: EIN/TIN: UE!: Address Line 1: Address Line 2: City State UEI Expiration Date: Zip(+4) Subrecipient Contacts Primary Contact Serves as the primary point of contact for project(s). Name: Email: Position/Job Title: Phone Number: Certifying Official Serves as the official representative of the organization. Must possess the authority to obligate funds & enter into contracts for the organization. Name: Email: Position/Job Title: Phone Number: Primary Finance Contact Serves as primary contact for all financial matters. Name: Email: Position/Job Title: Phone Number: DIVISION Cy MAN Texas Division of Emergency Management Subrecipient Agreement for IDEM-Administered Grant Awards II Table of Contents Revisions State of the Agreement. AGREEMENT AUTHORITY. Agreement I. GENERAL TERMS. II. STANDARD OF PERFORMANCE. III. FAILURE TO PERFORM IV. FUNDING OBLIGATIONS. V. RECOUPMENT OF FUNDS.. VII. STATE REQUIREMENTS FOR GRANTS. VIII. RESTRICTIONS AND GENERAL CONDITIONS IX. PROCUREMENT CONTRACTING. X. MONITORING XI. AUDIT... XII. RETENTION. AND ACCESSIBILITY OF RECORDS. XIII. CHANGES, AMENDMENTS, SUSPENSIONS OR TERMINATION XIV. ENFORCEMENT. XV. CONFLICTS OF INTEREST.. XVI. CLOSING OF THIS AWARD. XVII. NOTICES. XVIII. TDEM GRANTS MANAGEMENT SYSTEM.. XIX. PERFORMANCE PERIOD. XX. COST/SCOPE MODIFICATION. XXI. FINAL EXPENDITURES REPORT. XXII. NET SMALL PROJECT OVERRUN. XXIII. APPEALS. XXIV. REQUESTS FOR REIMBURSEMENT. XXV. QUARTERLY REPORT REQUIREMENTS XXVI. EQUIPMENT RECORDS XXVII.FEMA PUBLIC ASSISTANCE PORTAL AND FEMA GO. XXVII. INDIRECT COST RATES. XXIX. REQUEST FOR INFORMATION. 5 5 6 8 9 11 11 12 13 14 14 15 15 15 16 17 17 17 17 19 19 19 20 20 20 21 21 24 27 29 33 34 35 36 37 42 VI. UNIFORM ADMINISTRATIVE REQUIREMENTS, COST PRINCIPALS AND AUDIT REQUIREMENTS. Exhibits EXHIBIT A: ASSURANCE-NON-CONSTRUCTION PROGRAMS EXHIBIT B: ASSURNCIS-COMSTRUCTON PROGRAMS. EXHIBIT C: CERTIFICATIONS FOR GRANT AGREEMENTS. EXHIBIT D: STATE OF TEXAS ASSURANCES. EXHIBIT E: ENVIRONMENTAL REVIEW.. EXHIBITF: ADDITIONAL GRANT CERTIFICATIONS. EXHIBIT G: REQUESTFOR INFORMATION POLICY.. EXHIBIT H: PRE-OBLIGATION REQUEST FOR INFORMATION POLICY EXHIBIT :: RECOUPMENT OF FUNDS Grant Acknowledgement, Agreement and Signature. Revisions Rev. 1. Change from Authorized Agent to Primary Finance Contact information on the Rev.2. Inclusion of language related to subrecipient reimbursement for Recipient Subrecipient Information page. management cost. Terms and Conditions February 2024 Pagel1 State of the Agreement Agreement Authority This agreement applies to all Department of Homeland Security Federal Emergency Management Agency (DHS/FEMA) awards or other awarding agency financial assistance awards administered by the Texas Division of Emergency Management (TDEM). The federal government, the State of Texas, and TDEM have the right to seek Subrecipients are required to follow applicable provisions of the Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards located at Title 2, Code of Federal Regulations (C.F.R.Part 200, and adopted by DHS at2C.F.R Part 3002, as well as all other applicable federal, state, and local laws, regulations, By accepting this agreement, Subrecipient and its executives, as defined in 2C.F.R. $170.315, certify that the subrecipient's policies are in accordance with guidance applicable to federal, state and local laws, and relevant executive guidance. This agreement, consisting of these terms and conditions and all exhibits, is between the Texas Division of Emergency Management (TDEM), an agency of the State of Texas, TDEM and Subrecipient are collectively hereinafter referred to as the parties. All awards made under this agreement are subject to the same terms and conditions except where additional provisions may be added by TDEM to assure compliance with the judicial enforcement of these actions. policies, procedures, and executive orders. hereinafter referred to as TDEM, and Subrecipient. aforementioned authority. Subrecipient may not assign or transfer any interest in this award without prior written consent of TDEM and, if required, DHS/FEMA or other awarding agency. Terms and Conditions - February 2024 Page/2 Agreement General Terms 1. The terms recipient and pass-through entity have the same meaning as grantee, as used in governing statutes, regulations, and DHS/FEMA guidance. 2. Throughout this document the terms grant and award will be used 3. A recipient is a non-Federal entity for administration purposes. 4. As subrecipient is known as a subgrantee as used in governing statutes, 5. The grant referred to in this agreement is an award to the subrecipient passed 6. The "certifying official" is the mayor, judge, or executive director authorized to execute these terms and conditions, and to submit changes of subrecipient agents. Contracted staff and/or vendors may assist the certifying official in completing related grant tasks but may not act in lieu of the certifying official. 7. Project and any subsequent versions for those projects accepted by Subrecipient and subsequently obligated or de-obligated by DHS/FEMA are 8. TDEM uses contractors to assist in administering subawards, both in communication with Subrecipient and the awarding agency. A subrecipients point of contact for all awards will be the assigned regional staff. TDEM may task various grant management tasks to contractors to work directly with 9. Within 10 calendar days of any change, Subrecipient must notify TDEM of any change in Designated Subrecipient Agents as submitted during the execution of this agreement, and any subsequent changes submitted by Subrecipient in 10. In the event Subrecipient hires a consultant to assist them with managing its Public Assistance and Hazard Mitigation grants (or other), they must be listed on the Designated Subrecipient Agent Form (DSA) and may not act in lieu of the designated agent. TDEM will direct all correspondence to the Subrecipient. The Subrecipient is solely responsible for sharing written communications with the consultant. The Subrecipient is the primary point of contact and must be interchangeably. regulations, and DHS/FEMA guidance. through from TDEM to Subrecipient. considered subawards to this agreement. subrecipients. TDEM's Grants Management System (GMS). included in all decision-making activities. Terms and Conditions - February 2024 Page/3 I. Standard of Performance Subrecipient must perform all activities as approved by TDEM and that is required in applicable grant/funding awards. Subrecipient must perform all activities in accordance with all terms, provisions and requirements set forth in the award, 1. Assurances - Non-Construction Programs (Federal authority), hereinafter including, the following exhibits: referred to as Exhibit A as Exhibit B Exhibit C 2. Assurances - Construction Programs (Federal authority), hereinafter referred to 3. Certifications for Grant Agreements (Federal authority), hereinafter referred to as 4. State of Texas Assurances (State authority), hereinafter referred to as Exhibit D 5. Environmental Review Certification (Federal authority), hereinafter referred to as 6. Additional Grant Certifications (State authority), hereinafter referred to as Exhibit 7. Request for Information and Documentation Policy (State authority), hereinafter 8. Pre-Obligation Request for Information and Documentation Policy (State 9. Recoupment of Funds (State authority), hereinafter referred to as Exhibitl Exhibit E F referred to as Exhibit G authority), hereinafter referred to as Exhibit H III. Failure to Perform In the event Subrecipient fails to implement and complete the project(s) approved and awarded, or comply with any provision of this grant, Subrecipient is liable to TDEM for an amount not to exceed the amount of this award and may be barred from receiving additional DHS/FEMA grant program funds or any other grant program funds administered by the State of Texas until repayment is made and any other compliance or audit finding is satisfactorily resolved, in addition to any other remedy specified in this grant. Failure to timely implement and complete projects may reduce future funding in additional DHS/FEMA and/or other grant programs administered by TDEM. Terms and Conditions - February 2024 Page 14 IV. Funding Obligations TDEM is not liable to Subrecipient for any costs incurred by Subrecipient that are not 1. Notwithstanding any other provision of this grant, the total of all payments and other obligations incurred by TDEM under this award must not exceed the total cumulative award amounts listed on the subawards (projects and subsequent 2. Subrecipient must contribute the required cost share, also known as non-Federal 3. Subrecipient must provide supporting documentation that supports the totality of 4. Ini the event that TDEM is required to continue to manage the subrecipients award after the Recipients (TDEM) allocated state management funds have been exhausted, subrecipient agrees to reimburse TDEM for such costs necessary to close FEMA awards including the final recoupment of any funds due to FEMA allowable costs authorized under the applicable award. versions). share or match, listed on the subaward. funding requests in accordance with program policy. and/or TDEM and the State of Texas. V. Recoupment of Funds Subrecipient must refund to TDEM any sum of these award funds that TDEM and/or DHS/FEMA determines to be an overpayment to and/or has not been spent by Subrecipient in accordance with this award. Refund payment(s) may be made from local, state, or federal grant funds unless prohibited by federal regulation or other Nothing in Exhibit -Recoupment of Funds shall limit TDEM's ability to implement alternative remedies for which it has authority to resolve outstanding recoupments or to limit TDEM's ability to take immediate recoupment action(s) after notice of VI. Uniform Administrative Requirements, Cost Principals and Audit Requirements provision. required refund has been made. Except as specifically modified by law or this grant, Subrecipient shall administer this award through compliance with the most recent version of all applicable laws and regulations, including but not limited to DHS/FEMA program legislation, federal awarding agency regulations, and the terms and conditions of this grant. A non- exclusive list sanctioned by Federal Authority is provided below (not all may apply in every project): Terms and Conditions - February 2024 Page 15 a. Public Law 93-288, as amended (Stafford Act) b. 44C.F.R., Emergency Management and Assistance 2 2C.F.R., Grants and Agreements d. Disaster Mitigation Act of 2000 Executive Order 11988, Floodplain Management - Executive Order 11990, Protection of Wetlands Executive Order 12372, Intergovernmental Review of Programs and Activities h. Executive Order 12549, Debarment and Suspension Executive Order 12612, Federalism Executive Order 12699, Seismic Design k. Executive Order 12898, Environmental Justice Coastal Barrier Resources Act, Public Law 97-348 m. Single Audit Act, Public Law 98-502 n. Sandy Recovery Improvement Act publications 0. Disaster Recovery Reform Act of 201816 U.S.C. S 470, National Historic Preservation Act p. 16 U.S.C. S 1531, Endangered Species Act References q. FEMA program publications, guidance, and policies VII. State Requirements for Grants Subrecipient must comply with all other federal, state, and local laws and regulations applicable to this award including but not limited to the laws and the regulations promulgated in Texas Government Code, Chapter 783, Uniform Grant and Contract htp/www.window.sttetuspocurementlcatradlugms pdf and the most recent applicable version of the program State Administrative Plan (and all effective updates), available at: htps/dem.texas.ov. Subrecipient must, in addition to the assurances and certifications, comply and require each of its subcontractors employed in the completion of the project to comply with all applicable statutes, regulations, executive orders, Office of Management and Budget (OMB) circulars, Management (UGMS) at: Terms and Conditions - February 2024 Pagel 16 terms and conditions of this award and the approved application. Grant funds must not be awarded to or expended by any entity which performs political polling. This prohibition does not apply to a poll conducted by an academic institution as part of the institution's academic mission that is not conducted for the Award funds may not be expended by a unit of local government unless the following limitations and reporting requirements are satisfied: 1. Texas General Appropriations Act, Art. IX, Parts 2 and 3, except there is no requirement for increased salaries for local government employees; 2. Texas Government Code Sections 556.004, 556.005, and 556.006, which prohibits using any money or vehicle to support the candidacy of any person for office, influencing positively or negatively the payment, loan, or gift to a person or political organization for a political purpose, and using grant funds to influence the passage or defeat of legislation including not assisting with the funding of a lobbyist, or using grant funds to pay dues to an organization with a registered 3. Texas Government Code Sections 2113.012 and 2113.101, which prohibits using grant funds to compensate any employee who uses alcoholic beverages on active duty and Subrecipient may not use grant funds to purchase an alcoholic beverage and may not pay or reimburse any travel expense for an 4. Texas General Appropriations Act, Art. IX, Section 6.13, which requires Subrecipient to make every effort to attain key performance target levels associated with this grant, including performance milestones, milestone time frames, and related performance reporting requirements; and 5. General Appropriations Act, Art. IX, Sections 7.01 and 7.02, and' Texas Government Code $2102.0091, which requires that this award may only be expended if Subrecipient timely completes and files its reports. TDEM strongly encourages subrecipients to complete refresher training in federal procurement standards as variances from these standards account for the majority off funding de-obligation. TDEM will provide training or sources for subrecipients to attain training. Federal procurement training may be required of some recipients in advance of funding or as a condition of funding and/or if additional monitoring is benefit of a particular candidate or party. lobbyist; alcoholic beverage; deemed appropriate by TDEM. Terms and Conditions - February 2024 Page17 VIII. Restrictions and General Conditions DHS/FEMA grant funds must only be used for the purposes set forth in this award and must be consistent with the statutory authority for the grant. Award funds must not be used for matching funds for other federal grants/cooperative agreements, lobbying, or intervention in federal regulatory or adjudicatory proceedings. In addition, federal funds must not be used to sue the federal government or any other 1. Federal employees are prohibited from directly benefiting from any funds under 2. Ina accordance with 2CF.R.525.300, TDEM will not make a subaward unless the Subrecipient has obtained a unique entity identifier (UEI). A UEI is the identifier required for System for Award Management (SAM) registration to uniquely identify entities with which the federal government does business. 3. Subrecipient maintains that it has registered at SAM.gov or other federally established site for contractor registration and entered TDEM-required information. Subrecipient shall keep current, and then review and update the information at least annually. Subrecipient shall keep information current in the SAM database until the later of when it submits this grant's final financial report or receives final award payment. Subrecipient agrees that it must not make any subaward agreement or contract related to this award without first obtaining the vendor or subawardee's mandatory UEI. See 2 C.F.R. Part 25, Appendix A. 4. Subrecipient must report total compensation for each of the five most highly compensated executives for the preceding completed fiscal year if the following is applicable (2C.F.R. Subtitle A; Chapter 1, Part 170, Appendix A to Part170). a. Subrecipient shall report whether Subrecipient received $25 million or more in Federal procurement contracts or financial assistance subject to the government entity. this Grant. See FEMA Information Bulletin 350. Transparency Act per 2C.FR.$170.320. b. Subrecipient shall report whether 80% or more of Subrecipient's annual gross revenues were from Federal procurement contracts or Federal financial assistance. If Subrecipient answers "yes" to both questions, Subrecipient shall report, along with subrecipient's UEI, the names and total compensation (see 17 CER.5229402012) for each of subrecipient's five most highly compensated executives for the preceding completed fiscal year. Subrecipient shall report executive total compensation at SAM.gov, or other federally established replacement site. Terms and Conditions - February 2024 Pagel 18 5. By signing this grant, Subrecipient certifies that, if required, Subrecipient has registered, entered the required information, and shall keep information in the System for Award Management (SAM) database current, and update the information at least annually until the subrecipient submits its final financial report, 6. Subrecipient agrees that it shall not make any subaward agreement or contract 7. Subrecipient must comply with Federal Executive Orders 12549 and 12689, which provide protection against waste, fraud, and abuse by debarring or suspending those persons deemed irresponsible in their dealings with the Federal government 8. Ad completed direct deposit form from Subrecipient must be provided to TDEM, prior tor receiving any funds under the provisions of this grant. The direct deposit form is 9. Subrecipient shall maintain property/nventory records which, at minimum, shall include a description of the property, a serial number or other identification number, the source of property, who holds title, the acquisition date, the cost of the property, the percentage of federal participation in the cost of the property, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. Subrecipient shall develop and implement a control system to prevent loss, damage, or theft of property and Subrecipient shall investigate and document any loss, damage or theft of property funded under this 10.DHS/FEMA and/or TDEM, through its authorized representatives, have the right at all reasonable times to make site visits to review project accomplishments and management control systems and to provide such technical assistance as may be required. Ifany site visit is made by DHS/FEMA or TDEM on the premises of Subrecipient or a contractor under this grant, Subrecipient must provide and must require its contractors to provide all reasonable facilities and assistance for the safety and convenience of the government representatives in the performance of their duties. All site visits and evaluations shall be performed in such a manner that will not unduly delay the work. Ai final physical site inspection for eligible scope of work and program compliance may be conducted after the subrecipient's Project or receives final payment. without first obtaining the subawardee's mandatory UEI. currently available at ntps/dem.texas.goVy grant. Completion and Certification Report has been submitted. IX. Procurement Contracting Subrecipient shall comply with all applicable federal, state, and local laws and requirements, including but not limited to proper competitive solicitation processes where required, for any procurement which utilizes federal funds awarded under this Terms and Conditions - February 2024 Page/9 award in accordance with 2 C.F.R. 200. 317-327 and Appendix II to Part 200 (A-C) 1. All contracts executed using funds awarded under this award shall contain the contract provisions listed under 2C.F.R. 200.327 and Appendix Il (A), Uniform Administrative Requirements for Grants and Cooperative Agreements to State 2. For each of the following types of procurement, activities must follow the most and (E-J). and Local Governments. restrictive of federal, state, or local procurement regulations: a. Micro purchase b. Small purchase Sealed bid d. Competitive proposal under the other methods) e. Non-Competitive proposal (solely when the award of a contract is unfeasible 3. The State must approve the use of a noncompetitive procurement method. Federal regulations allow for noncompetitive procurements under certain circumstances, including when a non-state entity determines that immediate actions required to address the public exigency or emergency cannot be delayed by a competitive solicitation. Failure to follow eligible procurement methods will result in ineligible costs. Other types of agreements for services must have State approval prior to use or execution. A copy of the local procurement policy must 4. Contracts attributed as cost-plus-percentage-of-cost or percentage-of- construction-cost" are explicitly prohibited by Federal procurement standards and 5. Subrecipients must perform cost/price analysis for every procurement action in 6. Subrecipients must negotiate profit as a separate element where required. 7. Subrecipients must not make any award to any party which is debarred or suspended, or is otherwise excluded from participation in the Federal assistance programs (Executive Order 12549, Debarment and Suspension). a. Subrecipient must maintain documentation validating review of debarment list of eligible contractors. Evidence of non-debarment for vendors must be ntp/www.window.stlelkusprocurementlproglvendor performance/debart ed/ and submitted for review. TDEM will not reimburse any expense fora be provided to the State before initial payment. are ineligible for DHS/FEMA grant. excess of the Simplified Acquisition Threshold. documented through SAM.gov and Terms and Conditions - February 2024 Page 110 debarred vendor or a vendor or Subrecipient that does not have a valid SAM.gov registration. 8. Subrecipients must comply with rules related to underutilized businesses (small and minority businesses, women's enterprises and labor surplus firms) at2 9. Subrecipients must comply with the rules of recovered materials for procurements at 2 C.FR520032310. Subrecipients must comply with the rules for domestic preferences for procurements at 2C.FRS200.322 C.F.R$200.321. X. Monitoring Subrecipient will be monitored periodically by federal, state, or local entities, both programmaticaly and financially, to ensure that project goals, objectives, performance requirements, timelines, milestone completion, budget, and other a. TDEM, or its authorized representative, reserves the right to perform periodic deskloffice-based and/or on-site monitoring of subrecipient's compliance with this award and of the adequacy and timeliness of subrecipient's performance b. After each monitoring visit, if the monitoring visit reveals deficiencies in subrecipient's performance under this grant, a monitoring report will be provided to the subrecipient that includes requirements for the timely correction of such deficiencies by subrecipient. Failure by subrecipient to take action(s) specified in the monitoring report may be cause for suspension or termination of this award pursuant to the Changes, Amendments, Suspensions or Termination Section (XIII) herein. program-related criteria are met. pursuant to this award. XI. Audit Subrecipients expending $750,000 or more in total federal financial assistance in a fiscal year will be required to provide an audit made in accordance with OMB Uniform Guidance; Cost Principles, Audit, and Administrative Requirements for 1. Acopy of the Single Audit must be submitted to TDEM or your cognizant state agency within nine months of the end of the subrecipient's fiscal year. If not required to submit a single audit, a response to the request will suffice. Failing to follow the regulation can result in significant adverse consequences including any action listing in the Enforcement Section (XIV) of this agreement Federal Awards, Subpart F. Terms and Conditions - February 2024 Page/11 Subrecipient must give DHS/FEMA, the Comptroller General of the United States, the Texas State Auditor, TDEM, or any of their duly authorized representatives access to and the right to conduct a financial or compliance audit of funds received, and performances rendered under this award. Subrecipient must permit TDEM or its authorized representative to audit subrecipient's records. Subrecipient must provide any documents, materials, or information necessary to facilitate such audit. 1. Subrecipient understands and agrees that it is liable to TDEM for any costs disallowed pursuant to any financial or compliance audit(s) of these funds. Subrecipient further understands and agrees that reimbursement to TDEM of such disallowed costs shall be paid by Subrecipient from funds that were not provided or otherwise made available to the subrecipient pursuant to this award 2. Subrecipient must take such action to facilitate the performance of such audit(s) conducted pursuant to this section as TDEM may require of Subrecipient. Subrecipient must ensure that this clause concerning the authority to audit funds received indirectly by subcontractors through Subrecipient and the requirement 3. Subrecipient understands that acceptance of funds under this award acts as acceptance of the authority of the State Auditor's Office to conduct an audit or investigation in connection with those funds. Subrecipient further agrees to cooperate fully with the State Auditor's Office's audit or investigation, including providing all records requested. Subrecipient must ensure that this clause concerning the State Auditor's Office's authority to audit funds and the requirement to cooperate fully with the State Auditor's Office is included in any subgrants or subcontracts it awards. Additionally, the State Auditor's Office shall at any time have access to and the rights to examine, audit, excerpt, and transcribe any pertinent books, documents, working papers, and records of orany other federal contract. to cooperate is included in any subcontract it awards. Subrecipient relating to this award. XII. Retention and Accessibility of Records Subrecipient shall follow its own internal retention policy, or the State's retention policy, whichever is more restrictive. At a minimum, the subrecipient must maintain fiscal records and supporting documentation for all expenditures of this award's funds pursuant to the applicable OMB2C.F.R. Subpart D - Post Federal Award 1. Subrecipient shall retain these records and any supporting documentation fora a minimum of three (3) years from the later of the completion of this project's public objective, submission of the final expenditure report, orany litigation, dispute,or Requirements. $200.334-338, and this agreement. audit. Terms and Conditions = February 2024 Page I 12 2. Records shall be retained for three (3) years after any real estate or equipment 3. DHS/FEMA or TDEM may direct subrecipient to retain documents or to transfer certain records to DHS/FEMA custody when DHS/FEMA determines that the Subrecipient must give DHS/FEMA, the Comptroller General of the United States, the Texas State Auditor, TDEM, or any of its duly authorized representatives, access to and the right to examine all books,accounts, records, reports, files, other papers, things, or property belonging to or in use by subrecipient pertaining to this award including records concerning the past use of DHS/FEMA funds. Such rights to access shall continue as long as the records are retained by Subrecipient. final disposition. records possess long term retention value. XIII. Changes, Amendments, Suspensions or Termination TDEM may modify this agreement after an award has been made.Once notification has been made in writing, any subsequent request for funds indicates Subrecipient's acceptance of the changes to this subrecipient award. Any alteration, addition, or Any alterations, additions, or deletions to this agreement that are required by changes in federal and state laws, regulations, or policy are automatically incorporated into this agreement without written amendment to this award and shall become effective upon the date designated by such law or regulation. In the event DHS/FEMA or TDEM determines that changes are necessary to this agreement after an award has been made, including changes to the period of performance of the award, or terms and conditions, the certifying official shall be notified electronically of the changes in writing. Once notification has been made, any subsequent request for refunds will indicate subrecipients acceptance of the 1. Ini the event subrecipient fails to comply with any term of this grant or agreement, TDEM may, upon written notification to subrecipient, suspend this award, in whole or in part, withhold payments to Subrecipient, and prohibit Subrecipient from incurring 2. TDEM has the right to terminate this award, in whole or in part, at any time before the end of the Performance Period, if TDEM determines that subrecipient has failed toc comply with any terms of this grant. TDEM shall provide written notice of the deletion to this agreement by subrecipient is not valid. changes to this award. additional obligations of this grant's funds. termination that includes: a. The reason(s) for such determination; b. The effective date of such termination; and Terms and Conditions - February 2024 Page 113 C. The scope of the termination of the award. d. Termination of an award is final. XIV. Enforcement Ifs subrecipient materially fails to comply with any term of this award or agreement, whether stated in a federal or state statute or regulation, an assurance, in a state plan or application, a notice of award, or elsewhere, TDEM or DHS/FEMA may take one or more of the following actions, as appropriate in the circumstances: 1. Increased monitoring of projects and require additional financial and performance 2. Require all payments as reimbursements rather than advance payments; 3. Temporarily withhold payments pending correction of the deficiency; reports; 4. Disallow or deny use of funds and matching credit for all or part of the cost of the 5. Request DHS/FEMA to wholly or partially de-obligate funding for a project; 6. Withhold cash payments pending correction of the deficiency bysubrecipient or activity or action not in compliance; more severe enforcement action by TDEM or DHS/FEMA; 7. Withhold future awards for the grant program; and 8. Take other remedies that may be legally available Int taking an enforcement action, TDEM will adhere to any administrative proceeding to which Subrecipient is entitled under any statute or regulation applicable to the action involved, and where TDEM, as the recipient, is obligated to follow. The costs to a subrecipient resulting from expenses incurred by the subrecipient during a suspension or after termination of this award are not allowable. The enforcement remedies identified in this section, including suspension and termination, do not preclude subrecipient from being subject to "Debarment and Suspension" under Executive Order 12549. 2C.F.R., Appendix II Part 200, (1). The subrecipient must maintain and provide upon request written standards of conduct covering conflicts ofi interest and governing the actions of its employees engaged in the selection, award and administration of contracts and must establish safeguards to prohibit employees from using their positions for a purpose that XV. Conflicts of Interest Terms and Conditions = February 2024 Page/14 constitutes or presents the appearance of personal or organizational conflict of interest or personal gain. XVI. Closing of this Award TDEM will close each subaward after receiving all required final documentation from the subrecipient. If the close out review and reconciliation indicates that subrecipient iso owed additional funds, TDEM will send the final payment automatically to subrecipient. If Subrecipient did not use all the funds received, TDEM will recover the 1. DHS/FEMA or TDEM's right to disallow costs and recover funds on the basis of a 2. Subrecipient's obligation to return any funds due as a result of later refunds, 3. Records retention requirements, property management requirements, and audit 4. Any other provisions of this award that impose continuing obligations on Subrecipient or that govern the rights and limitations of the parties to this award unused funds. This does not affect: later audit or other review; corrections, or other transactions; requirements, as set forth herein; and after the expiration or termination of this award. XVII. Notices All notices and other communications pertaining to this agreement shall be delivered in electronic format and shall be transmitted in TDEM's Grant Management System, hereinafter referred to as "GMS". TDEM reserves the right to use other delivery avenues as needed. XVIII. TDEM Grants Management System TDEM requires the use of the TDEM's Grants Management System (GMS) for subrecipient grant management functions. Subrecipient is required to access GMS for all grant related functions as required by TDEM unless written authorization from TDEM is given. Requested forms and processes may be adjusted and changed to Subrecipient agrees to monitor GMS as necessary to properly manage and complete awarded projects under this agreement. Paper forms and email requests to initiate grant management functions within GMS are not accepted. accommodate GMS processes and requirements. Terms and Conditions - February 2024 Page 115 XIX. Performance Period The performance period for this award is listed on the subaward letter for each project. All projects must be completed within the performance period and within the approved budget. Subrecipient shall have expended all award funds and must submit final requests for reimbursements, invoices, and any supporting documentation to TDEM no later than 60 calendar days after the end of the performance period. TDEM is not obligated to reimburse expenses incurred after the From time to time, the performance period for grants may be extended by TDEM. These extensions do not change the established performance periods for subrecipients to submit final requests for reimbursements, invoices, and any 1. All work must be done prior to the approved project completion deadline performance period or submitted after the deadline. supporting documentation. assigned to each project. process equivalent). a. For Public Assistance projects written at 100% complete, documentation must be submitted within 60 days of the Recovery Scoping Meeting (or DHS/FEMA b. For projects not written at 100% complete for both Hazard Mitigation and Public Assistance awards, documentation must be submitted within 60 days of the work completion date. 2. Should additional time be required, a time extension request must be submitted which: a. Identifies the projects requiring an extension; b. Explains the reason for an extension; d. Provides an anticipated completion date; C. Indicates the percentage of work that has been completed; e. Provides detailed milestones documenting expected progress. The reason for an extension must be based on extenuating circumstances, or unusual project requirements that are beyond the control of Subrecipient. Failure to submit a time extension request 90 days prior to the end of the period of performance may result in denial, or reduction or withdrawal of federal funds for approved dwork. Terms and Conditions - February 2024 Page 116 XX. Cost/Scope Modification Any change to a project's approved scope of work must be reported and approved through TDEM and DHS/FEMA before starting the project. Failure to do sO will Subrecipient shall submit requests for cost overruns to TDEM for review. Any requests sent for a Public Assistance project will be submitted to DHS/FEMA for review and approval. Approval of these requests is not guaranteed and is subject to funding availability. Costs incurred prior to approval of any scope or budget/cost jeopardize award funding. changes may be denied. XXI. Final Expenditures Report The Project Completion and Certification Report (P4) must be submitted to TDEM within 90 days of all approved work being completed for each project. If any project requires the purchase of insurance as a condition of receiving federal funds, a copy oft the current policy must be attached to this report and the Applicant's Attestation for Duplication of Benefits (DOB) form certifying other funds were received to complete the project. XXII. Net Small Project Overrun If the total actual cost of all of a subrecipient's Public Assistance small projects combined exceeds the total obligated for all small projects, the subrecipient may request additional funding through the appeal process, within 60 days of the latest work completion date of all its Small Projects, as described in the Public Assistance Program and Policy Guide. A net small project overrun appeal will require a review of all small projects and could result in a reduction of funding. XXIII. Appeals 1. Public Assistance Ini the event that a subrecipient does not agree with the determinations made by DHS/FEMA, the subrecipient has the right to file an appeal. This appeal must be submitted in GMS by initiating a New Project Appeal, attaching documented justification supporting the subrecipient's position, specifying the monetary figure in dispute and the provisions in federal law, regulation, or policy with which the subrecipient believes the initial action was inconsistent. Additionally, for disasters declared on or after January 1, 2022, subrecipients must submit appeals using DHS/FEMA's Grants Portal system, in addition to GMS. An appeal must be submitted by the subrecipient within the following time frames: Terms and Conditions - February 2024 Page 117 a. Any DHS/FEMA determination = 60 days from the written notice of the b. Second Appeal - 60 days from the written notice of the determination Appeals should be addressed to the TDEM's Deputy Chief of Recovery & Mitigation and should contain additional information that the subrecipient wants to have considered. Upon receipt of an appeal from Subrecipient, TDEM will review the material submitted, and forward the appeal with a written For presidentially declared disasters on or after October 30, 2012, a subrecipient may choose to arbitrate in lieu of submitting a second appeal. The arbitration program is designed to offer an alternate second appeal process by providing final adjudication through an independent, neutral panel of arbitrators for particular PA projects involving a dispute equal to or in excess of $500,000 (or $100,000 if the Applicant is in a "rural area", defined as having a population of less than 200,000 living outside an urbanized area) and must be filed within 60 days of receipt of the first appeal decision. For specific information, refer to determination being made. made on the previous appeal. recommendation to DHS/FEMA within 60 days. 44 CFRS206.206. 2. Hazard Mitigation Ini the event that a subrecipient does not agree with the determinations made by DHS/FEMA, the subrecipient has the right to file an appeal. This appeal must be submitted in GMS by initiating a New Project Appeal, attaching documented justification supporting the subrecipient's position, specifying the monetary figure in dispute and the provisions in federal law, regulation, or policy with which the subrecipient believes the initial action was inconsistent. Ina accordance with 44 C.F.RS206.440, an appeal must be submitted by the a. Any DHS/FEMA or TDEM determination = 60 days from the date of the determination of the appeal written on the DHS/FEMA letter; b. Second Appeal - 60 days from the written notice of the determination made on the previous appeal. The decision of the Second Appeal is final Appeals must be addressed to the State Hazard Mitigation Officer (SHMO) and should contain additional information, in accordance with Hazard Mitigation Assistance (HMA) guidance, that the subrecipient wants to have considered by DHS/FEMA. Upon receipt of an appeal from the subrecipient, TDEM will forward subrecipient within the following time frames: and not subject to arbitration. the appeal to DHS/FEMA within 60 days. Terms and Conditions - February 2024 Page I 18 XXIV. Requests for Reimbursement Subrecipient will request payment ofi funds on projects by initiating a request for reimbursement (RFR) in GMS or an advance ofi funds request (AFR) through GMS. The request must include documentation supporting the request. Payments for open projects must be requested at least quarterly ifexpenditures have been made in that quarter. If payment is not requested quarterly, Subrecipient is subject to enforcement mechanisms described in the Enforcement section (XIV). Additional monitoring may be required of subrecipients ifi funds are advanced. Small projects will be paid upon completion of work and submission of all necessary closeout documentation to TDEM. Due to the increase of the small project maximum, subrecipients may require an Advance of Funds to pay eligible costs of approved project scopes of work. XXV. Quarterly Report Requirements Subrecipients must submit quarterly progress reports (QPR) for open, large projects in Public Assistance, all Hazard Mitigation Grant Program, Building Resilient Infrastructure and Committees (BRIC), and Pre-Disaster Mitigation Grant projects using GMS. QPRs are due to TDEM the 15th of the month after the reporting period ends. The reporting period consists of 4 3-month periods: a. Quarter 1 (Q1): October - December b. Quarter 2 (Q2): January - March . Quarter 3 (Q3): April - June d. Quarter 4 (Q4): July - September Failure to submit required QPRs that demonstrate appropriate project progress for two or more quarters, or Requests for Reimbursement (RFR) not submitted quarterly, can result in the withholding or de-obligation of funding for subrecipients TDEM may use the data provided in QPRS when considering requests for overruns, period of performance extensions, or any other award activity. Ifprojects are not progressing, TDEM will require additional reporting or may take any other until all QPRS are submitted to TDEM. appropriate action to comply with required standards. XXVI. Equipment Records When an individual item of equipment is no longer required for federally-funded programs or projects, Subrecipient must calculate the current fair market value of the individual item. If items have a fair market value in excess of $5,000.00, Subrecipient must make DHS/FEMA aware. For full rules and regulations regarding purchased Terms and Conditions - February 2024 Page/1 19 equipment, reference 2C.F.R.200.313. XXVII. FEMA Public Assistance Portal and FEMA GO In addition to TDEM's Grants Management System, must utilize the required DHS/FEMA grant management systems. The FEMA Public Assistance Delivery Model, or Simplified Application process, is used to facilitate the writing of project worksheets in FEMA's Grants Portal system (Portal). The subrecipient must establish and maintain an active account in the Portal. Iti is the subrecipient's responsibility to provide and upload timely, all information requested that is needed to write accurate project worksheets. The Portal provides the subrecipient visibility of the entire project The FEMA Grant Outcomes (FEMA GO) platform is used to facilitate the application, tracking, and management of Hazard Mitigation Grant Programs (HMGP) including Building Resilient Infrastructure and Communities (BRIC), Flood Mitigation Assistance (FMA), and HMGP Post Fire Assistance. The subrecipient is responsible for requesting and maintaining an active account in FEMA GO and responding timely to any information requested in order to complete the award process. The use of FEMA's Grants Portal and FEMA GO do not eliminate the requirement to writingprocess. use TDEM's Grants Management System. XXVIII. Indirect Cost Rates The subrecipient may use the negotiated Indirect Cost Rate approved by its cognizant agency, or may use the 10 percent de minimis rate of modified total direct costs (MTDC) (as per2CER.5200414) when receiving Management Costs. XXIX. Request for Information TDEM and/or DHS/FEMA may request additional information from the subrecipient throughout the life cycle of this grant. This process, the Request for Information, herein referred to as RFI. DHS/FEMA RFIs may be received directly from TDEM's Grants Management System (GMS), FEMA systems (FEMA Grants Portal & FEMA GO), DHS/FEMA employees, or indirectly through TDEM representatives. DHS/FEMA RFI timeframes may vary, but due dates are always communicated upon transmission of the RFI. The TDEM RFI policies can be found in Exhibits G& H. Terms and Conditions - February 2024 Page 120 Exhibits Exhibit A: Assurance = Non-Construction Programs (See Standard Form 424B) As the duly authorized representative of subrecipient, Icertify that subrecipient 1. Has the legal authority to apply for federal assistance and the institutional, managerial and financial capability (including funds sufficient to pay the non-federal share of project cost) to ensure proper planning, management and completion of the 2. Will give the Department of Homeland Security, the Texas Division of Emergency Management, the Comptroller General of the United States and, ifappropriate, the State, through any authorized representative, access to and the right to examine all records, books, papers, or documents related to this grant and will establish a proper accounting system in accordance with generally accepted accounting 3. Will establish safeguards to prohibit employees from using their positions fora a purpose that constitutes or presents the appearance of personal or organizational 4. Will initiate and complete the work within the applicable time frame after receipt of 5. Will comply with the Intergovernmental Personnel Act of 1970 (42 U.S.C.S54728- 4763) relating to prescribed standards for merit systems for programs funded under one of the 19 statutes or regulations specified in Appendix A ofOPM's Standards for a Merit System of Personnel Administration (5 C.F.R. 900, Subpart F). 6. Will comply with all Federal statutes relating to nondiscrimination. These include but are not limited to: (a) Title VI of the Civil Rights Act of 1964 (P.L. 88-352) which prohibits discrimination on the basis of race, color or national origin; (b) Title IX of the Education Amendments of 1972, as amended (20 U.S.C.S91681-1683, and 1685-1686 and 44 C.F.R. Part 19), which prohibits discrimination on the basis of sex; (c) Section 504 of the Rehabilitation Act of1973, as amended (29 U.S.C.S $794), which prohibits discrimination on the basis of handicaps; (d) the Age Discrimination Act of 1975, as amended (42U.S.C. $56101-6107), which prohibits discrimination on the basis of age; (e) the Drug Abuse Office and Treatment Act of 1972 (P.L. 92- 255), as amended, relating to nondiscrimination on the basis of drug abuse; () the Comprehensive Alcohol Abuse and Alcoholism Prevention, Treatment and Rehabilitation Act of 1970 (P.L. 91-616), as amended, relating to nondiscrimination on the basis of alcohol abuse or alcoholism; (g) $$523 and527 of the Public Health Service Act of 1912 (42 U.S.C. $$290dd-3 and 290ee-3), as amended, relating to project described in this grant. standards or agency directives. conflict ofi interest or personal gain. approval of the awarding agency. Terms and Conditions - February 2024 Page 121 confidentiality of alcohol and drug abuse patient records; (h) Title VIII of the Civil Rights Act of 1968 (42 U.S.C.S53601 et seq.), as amended, relating to nondiscrimination in the sale, rentalor financing of housing; () any other nondiscrimination provisions in the specific statute(s) under which agreement for Federal assistance is being made; and () the requirements of any other nondiscrimination statute(s) which may apply to the application. 7. Will comply or has already complied with the requirements of Titles II and III of the Uniform Relocation Assistance and Real Property Acquisition Policies Act of1970 (P.L. 91-646) which provide for fair and equitable treatment of persons displaçed or whose property is acquired as a result of Federal or federaly-assisted programs. These requirements apply to all interests in realproperty acquired for project 8. Will comply, as applicable, with provisions of the Hatch Act (5 U.S.C. SS1501-1508 and 7324-7328) which limit the political activities of employees whose principal employment activities are funded in whole or in part with Federal funds. 9. Will comply, as applicable, with the provisions of the Davis-Bacon Act (40 U.S.C. $$276a to 276a-7), the Copeland Act (40 U.S.C. $276c and 18 U.S.C. $874), and the Contract Work Hours and Safety Standards Act (40 U.S.C. $$327-333), regarding labor standards for federaly-assisted construction sub-agreements. 10.Will comply, if applicable, with flood insurance purchase requirements of Section 102(a) of the Flood Disaster Protection Act of 1973 (P.L. 93-234) which requires recipients in a special flood hazard area to participate in the program and to purchase flood insurance if the total cost of insurable construction and acquisition is 11.Will comply with environmental standards which may be prescribed pursuant to the following: (a) institution of environmental quality control measures under the National Environmental Policy Act of 1969 (P.L. 91-190 as amended by 42 U.S.C. 4311 et seq. and Executive Order (EO) 11514) which establishes national policy goals and procedures to protect and enhance the environment, including protection against natural disasters. To comply with NEPA for DHSgrant-supported activities, DHS- FEMA requires the environmental aspects tobe reviewed and evaluated before final action on the application; (b) notification of violating facilities pursuant to EO 11738; (c) protection of wetlands pursuant to EO 11990; (d) evaluation of flood hazards in floodplains in accordance with EO 11988; (e) assurance of project consistency with the approved State management program developed underthe Coastal Zone Management Act of 1972 (16 U.S.C.S51451 et seq.); (f) comply with the Clean Air Act of 1977, (42U.S.C.S97401 et seq. and Executive Order 11738) providing for the protection of and enhancement of the quality of the nation's air resources to promote public health and welfare and for restoring and maintaining the chemical, physical, purposes regardless of Federal participation in purchases. $10,000.00 or more. Terms and Conditions - February 2024 Page 122 and biological integrity of the nation's waters; (g) protection of underground sources of drinking water under the Safe Drinking Water Act of 1974, as amended (P.L. 93- 523); and, (h) protection of endangered species under theEndangered Species Act 12.Will comply with the Wild and Scenic Rivers Act of 1968 (16 U.S.C. $$1271 etseq.) related to protecting components or potential components of the national wild and 13.Will assist the awarding agency in assuring compliance with Section 106 of the National Historic Preservation Act of 1966, as amended (16 U.S.C. $470), EO 11593 (identification and protection of historic properties), and the Archaeological and Historic Preservation Act of 1974 (16 U.S.C. $$469a-1 etseq.). 14.Will comply with P.L. 93-348, 45 C.F.R. 46, and DHS Management Directive 026- 044 (Directive) regarding the protection of human subjects involved in research, development, and related activities supported by this Grant. "Research" means a systematic investigation, including research, development, testing, and evaluation designed to develop or contribute to general knowledge. See Directive for additional provisions for including humans in the womb, pregnant women, and neonates (Subpart B); prisoners(Subpart C); and children (Subpart D). See also 15.Will comply with the Laboratory Animal Welfare Act of 1966 (P.L. 89-544, as amended, 7U.S.C. $$2131 et seq.) which requires the minimum standards of care and treatment for vertebrate animals bred for commercial sale, used in research, transported commercially, or exhibited to the public according to the Guide for Care and Use of Laboratory Animals and Public Health Service Policy and Government 16.Will comply with the Lead-Based Paint Poisoning Prevention Act (42 U.S.C.S54801 et seq.), which prohibits the use of lead-based paint in construction or rehabilitation of 17.Will cause to be performed the required financial and compliance audits in accordance with the Single Audit Act Amendments of 1996 and OMB Circular No. A- 133 (now OMB 2 C.F.R. 200.500), "Audits of States, Local Governments, and Non- 18.Will comply with all applicable requirements of all other Federal laws, executive orders, regulations, grant guidance, and policies governing this Grant. of 1973, as amended (P.L. 93- 205). scenic rivers system. state and local law for research using autopsy materials. Principals Regarding the Care and Use of Animals. residence structures. Profit Organizations." Terms and Conditions - February 2024 Page 123 Exhibit B: Assurances - Construction Programs (See Standard Form 424D) As the duly authorized representative of subrecipient, I'certify that subrecipient: 1. Has the legal authority to apply for federal assistance, and the institutional, managerial and financial capability (including funds sufficient to pay the non-federal share of project costs) to ensure properplanning, management and completion of 2. Will give the Department of Homeland Security, the Texas Division of Emergency Management, the Comptroller General of the United Statesand, if appropriate, the State, the right to examine all records, books, papers, or documents related to this grant and will establish a proper accounting system in accordance with generally 3. Will not dispose of, modify the use of, or change the terms of the real property title or other interest in the site and facilities without permissionand instructions from the awarding agency. Will record the federal awarding agency directives and will include a covenant in the title of realj property acquired in whole or in part with federal assistance funds to assure nondiscrimination during the useful life of this Grant. 4. Will comply with the requirements of the assistance awarding agency with regard to the drafting, review and approval of construction plans andspecifications. 5. Will provide and maintain competent and adequate engineering supervision at the construction site to ensure that the complete work conforms with the approved plans and specifications and will furnish progressive reports and such other information as 6. Will initiate and complete the work within the applicable time frame afterreceipt of 7. Will establish safeguards to prohibit employees from using their positions for a purpose that constitutes or presents the appearance of personal ororganizational 8. Will comply with the ntergovernmental Personnel Act of 1970 (42 U.S.C. $54728- 4763) relating to prescribed standards of merit systems for programs funded under one of the 19 statutes or regulations specifiedin Appendix A of OPM's Standards for a Merit System of Personnel Administration (5 C.F.R. 900, Subpart F). 9. Will comply with the Lead-Based Paint Poisoning Prevention Act (42 U.S.C. $$4801 et seq.) which prohibits the use of lead-based paint in construction or rehabilitation project described in this Grant. accepted accounting standards or agency directives. may be required by the awarding agency or State. approval of the awarding agency. conflict of interest or personalgain. of residence structures. Terms and Conditions - February 2024 Page 124 10.Will comply with all federal statutes relating to nondiscrimination. These include but are not limited to: (a) Title VI of the Civil Rights Act of 1964 (P.L. 88-352) which prohibits discrimination on the basis of race, color or national origin; (b) Title IX of the Education Amendments of 1972, as amended (20 U.S.C. $$1681 1683, and 1685- 1686 and 44 C.F.R. Part 19), which prohibits discrimination on the basis of sex; (c) Section 504 of the Rehabilitation Act of 1973, as amended (29) U.S.C. $794), which prohibits discrimination on the basis of handicaps; (d) the Age Discrimination Act of 1975, as amended (42 U.S.C. $56101-6107), which prohibits discrimination on the basis of age; (e) the Drug Abuse Office and Treatment Act of 1972 (P.L. 92-255), as amended relating to nondiscrimination on the basis of drug abuse; () the Comprehensive Alcohol Abuse and Alcoholism Prevention, Treatment and rehabilitation Act of 1970 (P.L. 91-616), as amended, relating to nondiscrimination on the basis of alcohol abuse or alcoholism; (g) $$523 and 527 of the Public Health Service Act of 1912 (42 U.S.C. $$290dd-3 and 290ee-3), as amended, relating to confidentiality of alcohol and drug abuse patient records; (h) Title VIII of the Civil Rights Act of 1968 (42 U.S.C. $$3601 et seq.), as amended, relating to nondiscrimination in the sale, rental or financing of housing; () any other nondiscrimination provisions in the specific statue(s) under which agreement for Federal assistance is being made; and () the requirements of any other nondiscrimination statue(s) which may apply to the agreement. activities are funded in whole or in part withFederal funds. 11.Will comply with the provisions of the Hatch Act (5 U.S.C. $51501-1508and 7324- 7328) which limit the political activities of employees whose principal employment 12.Will comply or has already complied with the requirements of Titles Il andlII of the Uniform Relocation Assistance and Real Property Acquisition Policies Act of 1970 (P.L. 91-646) which provide for fair and equitable treatment of persons displaced or whose property is acquired as a resultof federal and ederally-assisted programs. These requirements apply to all interests in real property acquired for project 13.Will comply, as applicable, with the provisions of the Davis-Bacon Act (40 U.S.C. $$276a to 276a-7), the Copeland Act (40 U.S.C. $276c and 18 U.S.C. $874), and the Contract Work Hours and Safety Standards Act(40 U.S.C. $$327-333) regarding labor standards for federally- assistedconstructionssub-agreements. 14.Will comply with flood insurance purchase requirements of Section 102(a) of the Flood Disaster Protection Act of 1973 (P.L. 93-234) whichrequires recipients in a special flood hazard area to participate in the program and to purchase flood insurance if the total cost ofi insurable construction and acquisition is $10,000 or 15.Will comply with environmental standards which may be prescribed pursuant to the purposes regardless of Federal participation in purchases more. Terms and Conditions February 2024 Page 125 following: (a) institution of environmental quality control measures under the National Environmental Policy Act of 1969 (P.L. 91-190) as amended by 42 U.S.C. 4311 et seq. and Executive Order (EO) 11514 which establishes national policy goals and procedures to protectand enhance the environment, including protection against natural disasters; (b) notification of violating facilities pursuant to EO 11738; (c)protection of wetlands pursuant to EO 11990; (d) evaluation of flood hazards in floodplains in accordance with EO 11988; (e) assurance of project consistency with the approved State management program developed under the Coastal Zone Management Act of 1972 (16 U.S.C. $$1451 et seq.); () comply with the Clean Air Act of 1977, (42 U.S.C.SS7401 et seq. and Executive Order 11738) providing for the protectionofand enhancement of the quality of the nation's air resources to promote public health and welfare and for restoring and maintaining the chemical, physical, and biological integrity of the nation's waters; (g) protection of underground sources of drinking water under the Safe Drinking Water Act of 1974, as amended (P.L. 93-523); and, (h) protection of endangered species under the Endangered Species Act of1973, as amended (P.L. 93-205). 16.Will comply with the Wild and Scenic Rivers Act of 1968 (16 U.S.C. $$1271 et seq.) related to protecting components or potential components of the national wild and 17.Will assist the awarding agency in assuring compliance with Section 106 of the National Historic Preservation Act of 1966, as amended (16 U.S.C. $470), EO 11593 (identification and protection of historic properties), and the Archaeological and Historic Preservation Act of 1974 (16 U.S.C. $$469a-1 et seq). 18.Will cause to be performed the required financial and compliance auditsin accordance with the Single Audit Act Amendments of 1996 and OMBO Circular No. A-133 (now OMB2C.F.R. 200.500), "Audits of States, LocalGovernments, and 19.Will comply with all applicable requirements of all other Federal laws, executive orders, regulations, grant guidance and policies governing this grant. scenic rivers system. Non-Profit Organizations." Terms and Conditions - February 2024 Page 126 Exhibit C: Certifications for Grant Agreements The undersigned, as the authorized official, certifies the following to the best of his/her 1. No federal appropriated funds have been paid or will be paid by or on behalf of the undersigned to any person for influencing or attempting to influence an officer or employee of an agency, a Member of Congress, an officer or employee of Congress, or an employee or a Member of Congress in connection with the awarding of any federal contract, the making of any federal grant, the making of any federal loan, the entering into of any cooperative agreement, and the extension, continuation, renewal, amendment, or modification of any Federal contract, grant, loan, or 2. Ifany funds other than federal appropriated funds have been paid or will be paid to any person for influencing or attempting to influence an officer or employee of any agency, a Member of Congress, an officer or employee of Congress, ora an employee oral Member of Congress in connection with this federal contract, grant, loan, or cooperative agreement, the undersigned shall complete and submit Standard Form-LLL Disclosure of Lobbying Activities, in accordance with its instructions. 3. The undersigned shall require that the language of this certification prohibiting lobbying be included in the award documents for all subawards at all tiers (including subcontracts, subgrants, and contracts under grants, loans, and cooperative agreements) and that all subrecipients shall certify and disclose accordingly. This certification is a material representation of fact upon which reliance wasplaced when this transaction was made or entered into. Submission of this certification is a prerequisite for making or entering into this transaction imposed by Section 1352, Title 31, U.S. Code. Any person who fails to file the required certification shall be subjectto a civil penalty of not less than $10,000 and not more than $100,000 for 4. As required by Executive Order 12549, Debarment and Suspension, and implemented at 28 C.F.R. Part 67, for prospective participants in primary covered transactions, as defined at 28 C.F.R. Part 67, Section 67.510. (Federal Certification), the subrecipient certifies that it and its principals and vendors: a. Are not debarred, suspended, proposed for debarment, declared ineligible, sentenced to a denial of Federal benefits by a State or Federal court, or voluntarily excluded from covered transactions by any Federal department or agency. Subrecipientcan access debarment information by going to www.sam.gov and the State Debarred Vendor List at: www.window.state.kusprocurementprogvendor perormance/epared. knowledge and belief: cooperative agreement. each such failure. Terms and Conditions - February 2024 Page 127 b. Have not within a three-year period preceding this grant been convicted of or had a civil judgment rendered against them for commission of fraud or a criminal offense in connection with obtaining, attempting to obtain, or performing a public (federal, state, or local) transaction or contract under a public transaction, violation of Federal or State antitrust statutes or commission of embezzlement, theft, forgery, bribery, falsification or destruction of records, making false . - Are not presently indicted for or otherwise criminally or civilly charged by a governmental entity (federal, state, or local) withcommission of any of the offenses enumerated in paragraph (D)(2) of this certification; d. Have not within a three-year period preceding this grant had one or more public transactions (federal, state, or local)terminated for cause or default; or e. Where subrecipient is unable to certify to any of the statements in this certification, he or she shall attach an explanation to this grant. (Federal 5. Federal funds will be used to supplement existing funds, and will not replace (supplant) funds that have been appropriated for the same purpose. Subrecipient may be required to supply documentation certifying that a reduction in non-federal resources occurred for reasons other than the receipt or expected receipt of federal 6. Subrecipient will comply with 2 C.F.R. Part 180, Subpart C as a condition of receiving grant funds and subrecipient will require such compliance in any subgrants or 7. Subrecipient will comply with the Drug-free Workplace Act, in Subpart B of2C.F.R. 8. Subrecipient is not delinquent on any federal debt. Examples of relevant debt include delinquent payroll and other taxes, audit disallowances, and benefit overpayments. See OMB Circular A-129 and form SF-424, item number 17 for 9. Subrecipient will comply with all applicable requirements of all other federal laws, executive orders, regulations, program andadministrative requirements, policies and 10.Subrecipient understands that failure to comply with any of the above assurances may result in suspension, termination orreduction of funds in this grant. statements, or receiving stolen property; Certification). funds. contract at the next tier. Part 3001. additional information andguidance. any other requirements governing this grant. Terms and Conditions - February 2024 Page 128 Exhibit D: State of Texas Assurances As the duly authorized representative of subrecipient, Icertify that subrecipient: 1. Shall comply with Texas Government Code, Chapter 573, by ensuring that no officer, employee, or member oft the Subrecipient's governing body or of the Subrecipient's contractor shall vote or confirm the employment of any person related within the second degree of affinity or the third degree of consanguinity to any member of the governing body or to any other officer or employee authorized to employ or supervise such person. This prohibition shall not prohibit the employment of a person who shall have been continuously employed for a period of two years, or such other period stipulated by local law, prior to the election or appointment of the officer, employee, org governing body member related to such person in the prohibited degree. 2. Shall insure that all information collected, assembled, or maintained by the Subrecipient relative to a project will be available to the public during normal business hours in compliance with Texas Government Code, Chapter 552, unless 3. Shall comply with Texas Government Code, Chapter 551, which requires all regular, special, or called meetings of governmental bodies to be open to the public, except as otherwise provided by law or specifically permitted in the Texas Constitution. 4. Shall comply with Section 231.006, Texas Family Code, which prohibits payments to 5. Shall not contract with or issue a license, certificate, or permit to the owner, operator, or administrator of a facility if the Subrecipient is a health, human services, public safety, or law enforcement agency and the license, permit, or certificate has been revoked by another health and human services agency or public safety or law 6. Shall comply with all rules adopted by the Texas Commission on Law Enforcement pursuant to Chapter 1701, Texas Occupations Code, orshall provide the grantor agency with a certification from the Texas Commission on Law Enforcement that the agency is in the process of achieving compliance with such rules if the Subrecipient is a law enforcement agency regulated by Texas Occupations Code, Chapter 1701. 7. Shall follow all assurances. When incorporated into a grant award or contract, standard assurances contained in the application package become terms or conditions for receipt of grant funds. Administering state agencies and subrecipients shall maintain an appropriate contract administration system to ensure that all terms, conditions, and specifications are met. (See UGMS Section _.36 for additional otherwise expressly prohibited by law. a person who is in arrears on child support payments. enforcement agency. guidance on contract provisions). Terms and Conditions - February 2024 Page 129 8. Shall comply with the Texas Family Code, Section 261.101, which requires reporting of all suspected cases of child abuse to local law enforcement authorities and to the Texas Department of Child Protective and Regulatory Services. Subrecipient shall also ensure that all program personnel are properly trained and 9. Shall comply with all federal statutes relating to nondiscrimination. These include but are not limited to: (a) Title VI of the Civil Rights Act of 1964 (P.L. 88-352), which prohibits discrimination on the basis of race, color, or national origin; (b) Title IX of the Education Amendments of 1972, as amended (20 U.S.C. $$1681-1683, and 1685-1686), which prohibits discrimination on the basis of sex; (c) Section 504 of the Rehabilitation Act of 1973, as amended (29 U.S.C. $794), which prohibits discrimination on the basis of handicaps and the Americans with Disabilities Act of 1990 including Titles I, II, and III of the Americans with Disability Act which prohibits recipients from discriminating on the basis of disability in the operation of public entities, public and private transportation systems, places of public accommodation, and certaintesting entities, 44 US.C.S512101-12213: (d) the Age Discrimination Act of 1974, as amended (42 U.S.C. $56101-6107), which prohibits discrimination on the basis of age; (e) the Drug Abuse Office and Treatment Act of 1972 (P.L. 92- 255), as amended, relating to nondiscrimination on the basis of drug abuse; () the Comprehensive Alcohol Abuse and Alcoholism Prevention, Treatment, and Rehabilitation Act of 1970 (P.L. 91-616), as amended, relating to the nondiscrimination on the basis of alcohol abuse or alcoholism; (9)S$523 and 527 of the Public Health Service Act of 1912 (42 U.S.C. $$290dd-3 and 290ee-3), as amended, relating to confidentiality of alcohol and drug abuse patient records; (h) Title VIII of the Civil Rights Act of 1968 (42 U.S.C. $$3601 et seq.), as amended, relating to nondiscrimination in the sale, rental, or financing of housing; () any other nondiscrimination provisions in the specific statute(s) under which application for Federal assistance is being made; and () the requirements of any other nondiscrimination statute(s) which may apply to thisgrant. aware of this requirement. 10.Shall comply, as applicable, with the provisions of the Davis-Bacon Act (40 U.S.C. $$276a to 276a-7), the Copeland Act (40 U.S.C. $276c and 18 U.S.C. $874), and the Contract Work Hours and Safety Standards Act (40 U.S.C. $9327-333), regarding labor standards for federally assisted construction subagreements. 11.Shall comply with requirements of the provisions of the Uniform Relocation Assistance and Real Property Acquisitions Act of1970 (P.L. 91- 646), which provide for fair and equitable treatment of persons displaced or whose property is acquired as a result of Federal or federally assisted programs. These requirements apply to all interests in real property acquired for project purposes regardless of Federal 12.Shall comply with the provisions of the Hatch Political Activity Act (5 U.S.C. $$7321- participation in purchases. Terms and Conditions - February 2024 Page I 30 29), which limit the political activity of employees whose principal employment 13.Shall comply with the minimum wage and maximum hours provisions of the Federal Fair Labor Standards Act and the Intergovernmental Personnel Act of 1970, as 14.Shall insure that the facilities under its ownership, lease, or supervision which shall be utilized in the accomplishment of the project are not listed on the Environmental Protection Agency's (EPA) list ofViolating Facilities and that it will notify the Federal grantor agency of the receipt of any communication from the Director of the EPA Office of Federal Activities indicating that a facility to be used in the project is under 15.Shall comply with the flood insurance purchase requirements of Section 102(a) of the Flood Disaster Protection Act of 1973, Public Law 93-234. Section 102(a) requires the purchase of flood insurance in communities where such insurance is available as acondition for the receipt of any Federal financial assistance for construction or acquisition proposed for use in any area that has been identified by the Secretary of the Department of Housing and Urban Development as an area having special flood 16.Shall comply with environmental standards which may be prescribed pursuant to the following: (a) institution of environmental quality control measures under the National Environmental Policy Act of 1969 (P.L. 91-190) and Executive Order (EO) 11514; (b) notification of violating facilities pursuant to EO 11738; (c) protection of wetlands pursuant to EO 11990; (d) evaluation of flood hazards in floodplains in accordance with EO 11988; (e) assurance of project consistency with the approved state management program developed under the Coastal Zone Management. Act of 1972 (16U.S.C. $$1451 et seq.); () conformity of federal actions to State (Clear Air) Implementation Plans under Section 176(c) of the Clean Air Act of 1977, as amended (42 U.S.C. $$7401 et seq.); (g) protection of underground sources of drinking water underthe Safe Drinking Water Act of 1974, as amended (P.L. 93- 523); and (h) protection of endangered species under the Endangered Species Act 17.Shall comply with the Wild and Scenic Rivers Act of 1968 (16 U.S.C. $$1271 et seq.) related to protecting components or potential components of the national wild and 18.Shall assist the awarding agency in assuring compliance with Section 106 of the National Historic Preservation Act of 1966, as amended (16 U.S.C. $470), EO 11593 (identification and protection of historic properties), and the Archaeological and Historic Preservation Act of 1974 (16 U.S.C. $$469a-1 et seq.). activities are funded in whole or in part with Federal funds. applicable. consideration for listing by the EPA (EO 11738). hazards. of 1973, as amended (P.L. 93-205). scenic rivers system. Terms and Conditions February 2024 Page 131 19.Shall comply with the Laboratory Animal Welfare Act of 1966 (P.L. 89-544, as amended, 7 U.S.C. $$2131 et seq.) which requires the minimum standards of care and treatment for vertebrate animals bred for commercial sale, used in research, transported commercially, or exhibited to the public according to the Guide for Care and Use of Laboratory Animals and Public Health Service Policy and Government 20.Shall comply with the Lead-Based Paint Poisoning Prevention Act (42 U.S.C. $$4801 et seq.) which prohibits the use of lead-based paint in construction or rehabilitation of 21.Shall comply with the Pro-Children Act of 1994 (Public Law 103-277), which prohibits smoking within any portion of any indoor facility used for the provision of 22. Shall comply with all federal tax laws and are solely responsible for filing all required 23.Shall comply with all applicable requirements of all other federal and state laws, executive orders, regulations, and policies governing this program. 24.And its principals are eligible to participate and have not been subjected to suspension, debarment, or similar ineligibility determined by any federal, state, or local governmental entity and it is not listed on a state or federal government's terrorism watch list as described in Executive Order 13224. Entities ineligible for 25.Shall adopt and implement applicable provisions of the model HIVIAIDS workplace guidelines of the Texas Department of Health as required by the Texas Health and Principals Regarding the Care and Use of Animals. residential structures. services for children. state and federal taxi forms. federal procurement have Exclusions listed at SAM.gov. Safety Code, Ann., Sec. 85.001, et seq. Terms and Conditions - February 2024 Page 132 Exhibit E: Environmental Review As the duly authorized representative of subrecipient, I certify that subrecipient: 1. Shall assess its federally funded projects for potential impact to environmental 2. Shall submit any required screening form(s) as soon as possible and shall comply with deadlines established by TDEM. Timelines for the Environmental Planning and Historic Preservation (EHP) review process will vary based upon the complexity of the project and the potential for environmental or historical impact. 3. Shall include sufficient review time within its project management plan to comply with EHP requirements. Initiation of any activity prior to completion of FEMA's EHP review will result in a non-compliance finding and TDEM will not authorize or 4. As soon as possible upon receiving this grant, shall provide information to TDEM to assist with the legally required EHP review and to ensure compliance with applicable EHP laws and Executive Orders (EO) currently using the FEMA EHP Screening Form OMB Number 1660-0115/FEMA Form 024-0-01 and submitting it, with all supporting documentation, to TDEM for review. These EHP requirements include but are not limited to the National Environmental Policy Act, the National Historic Preservation Act, the Endangered Species Act, EO 11988 - Floodplain Management, EO 11990 - Protection of Wetlands, and EO 12898- Environmental Justice. Subrecipient shall comply with all Federal, State, and local EHP requirements and 5. Shall not undertake any activity from the project that would result in ground disturbance, facility modification, or purchase and use of sonar equipment without the prior approval of FEMA. These include but are not limited to communications towers, physical securtyennancements involving ground disturbance, new resources and historicproperties. release Grant funds for non-compliant projects. shall obtain applicable permits and clearances. construction, and modifications to buildings. 6. Shall comply with all mitigation or treatment measures required for the project as the result of FEMA's EHP review. Any changes to an approved project description will require re-evaluation for compliance with EHP requirements before the project can 7. Ifground disturbing activities occur during project implementation, subrecipient shall ensure monitoring of ground disturbance and if any potential archeological resources are discovered, subrecipient shall immediately cease construction in that area and notify FEMAand the appropriate State Historical Preservation Office. proceed. Terms and Conditions - February 2024 Page 133 Exhibit F: Additional Grant Certifications 1. Public Assistance and Hazard Mitigation Program Grant (HMGP) a. Match Certifications Subrecipient certifies that it has the ability to meet or exceed the cost share required for all subawards (projects) and amendments (versions) under this Grant Agreement. b. Duplication of Program Statement this project Match Certification. C. Federal Debt Disclosure Subrecipient certifies there has not been, nor will be, a duplication of benefits for Subrecipient certifies that it not delinquent on and Federal debt. 2. HMGP Only a. Maintenance Agreement Applicant certifies that there is a Maintenance Agreement needed for this facility and that a copy of that agreement will be provided to TDEM. b. Environmental Justice Statement Federal Executive Order 12898 compliance requirements - If there are any concentration of low income of minority populations in or near the HMGP A Applicant certifies that the HMGP project result will not result in a disproportionately high effect on low income or minority populations. ii. - Applicant certifies that actions will be taken to ensure of environmental justice for low income and minority populations related to this HMGP projects: OR project. Terms and Conditions - February 2024 Page 134 Exhibit G: Request for Information Policy Timelines for providing complete and accurate information and documentation are crucial to the success of the overall Grant Program and to the timely completion and closure of awarded projects. TDEM has developed a framework following a progressive series of communications for the Subrecipient, referred to as Request for Information (RFI). TDEM will work with Subrecipients throughout the RFI process as communication This policy will be applied to Public Assistance and Hazard Mitigation projects for management and closeout activities after obligation. This policy will address non- responsive and inadequate responses to requests for information. Although the timeline outlines milestones to be completed, nothing limits the ability of TDEM from sending is the key to success. communications. TDEM regional coordinators or the Support Affiliate will reach out to Subrecipient's primary contact requesting the information needed. Communication will be documented in GMS. Ifadequate response is not received, TDEM Regional Unit Chief will reach out to Subrecipient primary contact. Communication Ifadequate response is not received, TDEM Regional Section Chief will reach out to Subrecipient primary contact. Ifadequate response is not received, TDEM regional coordinator or Support Affiliate will send al letter, signed by the Day 30 Regional Unit or Section Chief notifying the subrecipient oft the missed deadline and any action that will be taken. IfSubrecipient requires additional time ay written request Extension must be submitted to the Regional Coordinator nol later than Request Day 30. Extensions will be approved at TDEM's discretion and up to 30 days may be granted; in total an RFI will have awindow of no more than 60 days. Ifadequate response is not received, TDEM regional coordinator will send a letter, signed by the Regional Unit or Endof Section Chief notifying the subrecipient of the missed deadline Day 10 will be documented in GMS. Day 20 Communication will be documented in GMS. Extension and any action that will be taken. Terms and Conditions - February 2024 Page 135 Exhibit H: Pre-Obligation Request for Information Policy Timelines for providing complete and accurate information and documentation are crucial to the success of the overall Grant Program and to the timely obligation of projects. TDEM has developed a framework following a progressive series of communications for the subrecipient, referred to as Request for Information (RFI). TDEM will work with subrecipients throughout the RFI process as communication is the This policy will be applied to Hazard Mitigation projects for management activities pre- obligation. This policy will address non-responsive and inadequate responses to requests for information. The timeline outlined below represents a single, 15-day period beginning from TDEM's first review of Subrecipient's application. Failure to supply timely responses could result in dismissal of application or award submission. Although the timeline outlines milestones to be completed, nothing limits the ability of TDEM from key to success. sending communications. Upon initial review of Subrecipient's HMGP application, TDEM staff willi initiate contact with Subrecipient via email. This first Day 1 communication begins the 15-day pre-obligation request for information policy timeline. 5 days after the first communication, if adequate response is not received, the Regional Unit Chief will issue a read receipt, high highlighting previous requests and notifying Subrecipient oft the 10 remaining days to provide the requested information. 5d days after the second communication, ifa adequate response is not received, TDEM staff will issue a formal reminder through al letter signed by the Regional Unit Chief and emailed tot the Day 11 Subrecipient's primary contact and Certifying Official informing them oft the final 5 days remaining to provide the requested information. The Assistant Chief is to be copied on the email for 50 days after the third communication, if adequate response is not received, TDEM staff will send a letter, signed by the Regional Unit Chief, to Subrecipient's primary contact notifying Day6 6 importance email to the Subrecipient's primary contact visibility. Day 16 Subrecipient ofr missed deadline. Terms and Conditions - February 2024 Page 136 Exhibit :: Recoupment of Funds Procedure Summary 1. This procedure is to ensure responsible spending of federal dollars, 2CFRS 200.344 and 2CFRS200.345 require that the State of Texas and the Texas Division of Emergency Management (TDEM) act to identify and recover any 2. This procedure applies to all Division subrecipients that receive funds from or through TDEM and explains the process by which funding to subrecipients will be recovered in the event that such funding is determined to be an overpayment or is not expended appropriately under the terms and conditions between TDEM and the subrecipient and/or applicable FEMA program, statue, regulations, or guidance. 3. The federal dollars described in this policy are passed through the Division, which serves as the Governor's authorized representative for certain federal grants and awards. Any amount of debt owed to the federal government is ultimately the responsibility of the State of Texas, not specifically the responsibility of the Division. improper payments. Procedure 1. Applicability of Recoupment 1.1.This procedure will be applied to subrecipients that have been determined by the Division to have received an overpayment or that the Division determines has not spent federal funds in accordance with their grant or financial award. 2. Recipient's Responsibilities 2.1.subrecipients are required to sign Grant Terms and Conditions prior to receipt of funds that stipulate subrecipients shall refund to the Division any sum that has been determined by the Division to be an overpayment to Subrecipient or that the Division determines has not been spent by Subrecipient in accordance with 2.2.No refund payment(s) shall be made from local, state or federal grant funds unless repayment with grant funds is specifically permitted under the applicable 2.3.Subrecipients shall make such refund to the Division within thirty (30) calendar their grant or financial award. program. days after the Division requests such refund. 3. Division Collection Actions Terms and Conditions - February 2024 Page 137 3.1. .Upon determination that a subrecipient has received an overpayment or has not expended funds in accordance with the grant or fiscal award, the following steps 3.1.1. First Formal Communication: A recoupment letter will be sent to the subrecipient's Authorized Agent(s) highlighting the amount of federal funds owed, electronic transfer information, and the requirement to repay the 3.1.1.1. The communication will be sent using electronic mail to the designated agent identified in the grant/funding application, and; 3.1.1.2. Posted in TDEM's Grants Management System (GMS), and; 3.1.2. The Division will confirm receipt of the recoupment letter by either receiving a written confirmation from the subrecipient or making documented verbal contact with the subrecipients designated agent, mayor, or county 3.1.3. Ifthe subrecipient fails to make repayment of the amount identified in the recoupment letter within thirty (30) business days of receipt of the letter, the Division may offset an applicant's owed funds against current available funding due to applicant unless an agreement to return funding is reached 3.1.4. If the repayment is not made, the Division shall send an additional notice tot the subrecipient by electronic mail and posted to the TDEM Grants Management System (GMS) thirty (30) to forty-five (45) days after the first letter was sent and then confirm receipt of the recoupment letter by either receiving a written confirmation from the subrecipient or making documented verbal contact with the subrecipients designated agent, mayor, or county judge as applicable. This letter will indicate the amount of funds that have been transferred to offset the amount due and remaining balance or will confirm if offset will occur. In addition, the letter will contain information related to recoupment options that may be taken in accordance with section Ifthe repayment is not made after the second letter, the Division shall send a third notice to the subrecipient by electronic mail and posted to the TDEM Grants Management System (GMS) thirty (30) to forty-five (45) days after the second letter was sent and then confirm receipt of the recoupment letter by either receiving a written confirmation from the subrecipient or making documented verbal contact with the subrecipients designated agent, mayor, or county judge as applicable. This letter will indicate the amount of funds that have been will be taken: amount within thirty (30) calendar days. judge as applicable. with the applicant as approved by TDEM 3.2 Delinquent Accounts. Terms and Conditions - February 2024 Page 138 transferred to offset the amount due and remaining balance or will confirm if offset will occur. In addition, the letter will contain information related to recoupment options that may be taken in accordance with section 3.2 Delinquent 3.1.5. Ift the subrecipient fails to make repayment of the amount identified in the recoupment letter or enter an agreement to repay the funding with the Division approved by TDEM within one hundred twenty (120) days from the date that the original recoupment letter was sent, the Division will take any and all authorized actions to withhold funding for other grants, including issuing a State Comptroller Warrant Hold and/or referring the matter to the attorney general. The Division shall notify the subrecipient of any such Accounts. decision. 3.2. Delinquent Accounts 3.2.1. Delinquency Determination 3.2.1.1. Ifas subrecipient fails to make repayment of the amount identified in the recoupment letter or enter an agreement approved by TDEM to repay the funding with the Division within 120 days from the date the original recoupment letter was sent, the Division may determine that the 3.2.1.2. AtTDEM's sole discretion, TDEM may authorize payment plans that fully reimburse the full amount owed over a 1-9-month period or prior to the end of the grant period. From time to time, variances in approved timelines may occur based on the phase of the grant process and other timelines determined by FEMA such as periods of performance and closeout liquidation periods. account is delinquent. 3.2.1.3. Should a subrecipient enter into a payment plan and then fail to make more than one timely payment, the payment plan shall be considered invalid and the full balance shall be due within 30 calendar days. If payment is not made within 30 days, the actions contained within Section 3.1.7 and Section 3.2. 3.2.2. Warrant Hold Process 3.2.2.1. Once the Division has determined that the debt is delinquent, the Division may utilize the state comptroller's warrant hold process to ensure payments are not issued to the individual or entity that is indebted to the state. 3.2.3. Referral to the Attorney General Terms and Conditions - February 2024 Page 139 3.2.3.1. Once the account is determined to be delinquent, the Division may determine whether to refer the account to the Attorney General through the System Office of the General Counsel. 3.2.3.2. The determination as to the manner in which to pursue the collection of the account must consider the following: 3.2.3.2.2. The existence of any security or collateral; 3.2.3.2.3. The likelihood of collection through passive means; 3.2.3.2.4. The cost to the Division or Attorney General in attempting to 3.2.3.2.5. The availability of resources within the Division or Attorney General to devote to the collection of the obligation. 3.2.3.2.1. The size of the debt; collect the obligation; and 3.2.4. Referral to the Attorney General 3.2.4.1. Upon a determination to refer to the Attorney General, the Division shall notify the subrecipient of the delinquency status of the account, including the amount in no more than two mailed letters. 3.2.4.1.1. The first demand letter shall be mailed USPS First Class Mail within 30 days after the debt has been determined delinquent and an Attorney General referral is desired. 3.2.4.1.2. The second demand letter shall be mailed USPS First Class Mail between 30-60 days after the first demand letter was mailed if repayment of the amount has not occurred. 3.2.4.2. Ifthe Division determines that it will refer the matter to the Attorney General, it shall, through the System Office of the General Counsel, notify the Attorney General around the 90th day after the first demand letter was sent. 3.3.The Division shall maintain copies of all communications with the subrecipients regarding the recoupment of the grant or financial award funding. 4. TDEM's Ability to Remedy Nothing in this procedure shall limit TDEM's ability to implement alternative remedies for which it has authority to resolve outstanding recoupments. Terms and Conditions - February 2024 Page 140 Nothing in this policy shall prohibit TDEM from immediately taking any recoupment action after the first thirty (30) day notice has been issued requesting repayment. Related Statutes, Policies, or Requirements Texas A&M University System Regulation 21.01.04 1Tex. Admin. Code Section 59.2 Tex. Gov't Code Section 403.055 Tex. Gov't Code Chapter 2107 Texas A&M University System Office Collection and Write-off Guidance Texas A&M University System Regulation 09.04.01 Terms and Conditions - February 2024 Page 141 Grant Acknowledgement, Agreement and Signature Please provide your signature next to each item in acknowledgement you have received, read, understand, and agree to abide by the terms. , the undersigned and Certifying Official of Printed Name Subrecipient Name understand that TDEM strongly encourages refresher training in federal procurement standards as variances from these standards account for the majority of funding deobligation. lalso certify thatl have read and understand each section oft the above agreement. My signatures below serve as Subrecipient agreement to comply with all laws, rules, regulations, and policy presented. Agreement Authority Signature Signature Signature Signature Signature Signature Signature Agreement (Sectionl-XXIX) Exhibit. A: Assurance - Non-Construction Exhibit B: Assurance - Construction Exhibit C: Certifications for Grant Programs Programs Agreements Exhibit D: State of Texas Assurances Exhibit E: Environmental Review Certification Terms and Conditions - February 2024 Page 142 Exhibit F: Additional Grant Certifications Exhibit G: Request for Information Policy Exhibit H: Pre-Obligation Request for Exhibit :: Recoupment of Funds Signature Signature Signature Signature Information Policy Please sign below to acknowledge subrecipient's acceptance of this grant and all exhibits and subrecipient's agreement to abide by all terms and conditions. Signature of Certifying Official Date Printed Name Title Terms and Conditions - February 2024 Page 143 05/09/2023 21:45:00 FEDERAL EMERGENCY MANAGEMENT AGENCY RECORD OF ENVIRONMENTAL CONSIDERATION (REC) REC-01 Project FMGP-485.006-x0) NEPA DETERMINATION Title: City ofE Bartlett Fire Dept & Water Wells Generator Non Compliant Flag: No EAF Public Notice Date: EIS Notice ofl Intent EAI Draft Date: EAI Fonsi EIS RODI Date: EAI Final Date: Leve!: CATEX Comment The City ofE Bartlett proposes toi install three (3) permanently mounted, emergency generators with associated: automatic transfer switches and electrical system upgrades att three City of Bartlett locations. The generator will be attached toa 13Lx8Wx6D concrete slab, within a6' high barbed-wire fence enclosure. The proposed generators willr mitigate they water supply and fire department equipment from being compromised during power outages. Providingt the generators att the three sites will provide emergency power that would allow the City to continue toc operate its water supply and providef fire 1.The City of Bartlett's Main Water Well, located on1 117 Emma StB, Bartlett, TX 76511 north oft the 2.1 The City ofE Bartlett's Fire Department, located at 200 W Clark St, Bartlett, TX 76511(30.796239,- 3.1 The City ofE Bartlett's 2nd Water' Well, located at 135 W. Pietzsch Street, Bartlett, TX 76511 This project has been determined to be Categorically Excluded from the need top prepare either an Environmental Impact Statement or Environmental Assessment ina accordance with FEMAI Instruction 108-1-1 and DHS Instruction 023-01-001-01; CATEX M13. Particular attention should be given to the project conditions before and during projecti implementation. Failure to comply with these conditions safety service toi its citizens through short and long duration disasters. Thep proposed locations oft the generators include: Water Treatment Plant (30.7 793823, -97.430402). 97.429969) (30.794459, -97.429943) may jeopardize federal assistance including funding. odawodu- 05/09/2023 20:49:36 GMT CATEX CATEGORIES Catex Category Code *m13 Description Selected ('m13) Construction or installation ofs structures, facilities, ore equipment for the Yes purpose ofe ensuring the continuity of operations duringi incidents such as emergencies, disasters, flooding, and power outages involving less than one acre of ground disturbance. Examples include thei installation of generators, installation of storage tanks ofu up to 10,000 gallons, installation ofp pumps, construction ofs structures tol house emergency equipment, and utility line installation. This CATEX covers associated ground disturbing activities, such as trenching, excavation, and vegetation removal of less than one acre, as well as modification of existing structures. EXTRAORDINARY Extraordinary Circumstance Code Description Selected? NoE Extraordinary Circumstances weres selected ENVIRONMENTAL LAW/EXECUTIVE ORDER NOTE: Allt times are GMT using a24-hour clock. Page 1of 4 05/09/2023 21:45:00 FEDERAL EMERGENCY MANAGEMENT AGENCY RECORD OF ENVIRONMENTAL CONSIDERATION (REC) REC-01 Project HMGP-485-0081-TX00 Title: City ofE Bartlett Fire Dept & Water Wells Generator Environmentall Lawl Executive Order Clean Air Act (CAA) (CBRA) Clean Water Act (CWA) (CZMA) Executive Order 11988- Floodplains Status Description Comment Completed Project will not resulti in permanent air emissions Review concluded or otherwise protected area Review concluded Review concluded and does nota affect a coastal: zone area- Review concluded Coastal Barrier Resources Act Completed Projecti is not on or connected to CBRA Unit Completed Project would nota affect any water of the U.S. Coastal Zone Management Act Completed Projecti is not! located ina coastal zone area Completed No effect onf floodplain/lood levels and Per Flood Insurance Rate Map (FIRM) panels project outside floodplain Review concluded 48491C0175F and dated 12/20/2019 and 48027C0700E dated 09/26/2008, the project is located outside the 500-year floodplain, special flood hazard area andt the activity does not adversely affect floodplain values. odawodu- 05/09/2023 20:53:10 GMT (NWI) online mapper, accessed on 5/9/23, for the sites indicates that the areas are not located within nor dot they affecta a designated wetland. - odawodu- 05/09/2023 20:53:38 GMT Executive Order 11990- Wetlands Completed No effects on wetlands and project outside Areview of the National Wetland Inventory wetlands Review concluded Executive Order 12898- Environmental Justice for Low Income and! Minority Populations Completed Low income or minority population in or near Completed No disproportionately high anda adverse project area impact onl lowi income orr minority population- Review concluded habitat presenti in areas affected directly or indirectly byt thef federal action Completed No effect tos species or designated critical habitat (See comments forj justification)- Review concluded unique farmland Review concluded waterway/body ofv water- Endangered Species Act (ESA) Completed Listeds species and/or designated critical Farmland Protection Policy Act Completed Project does not affect designated prime or Fish and Wildlife Coordination Completed Project does nota affect, control, or modifya (FPPA) Act (FWCA) NOTE: Allt times are GMT usinga az 24-hour clock. Page2of4 05/09/2023 21:45:00 FEDERAL EMERGENCY MANAGEMENT AGENCY RECORD OF ENVIRONMENTAL CONSIDERATION (REC) REC-01 Project HMGP-485.061-TX00 Title: City ofE Bartlett Fire Dept & Water Wells Generator Environmental Law! Executive Order Status Description Comment Review concluded Migratory Bird Treaty Act (MBTA) Completed Project! located within a fyway zone Completed Project does not have potential to take migratory birds Review concluded Completed Projectr not located in or near Essential Fish Habitat- Review concluded Magnuson-Stevens. Fishery Conservation and Management Act (MSA) (NHPA) National Historic Preservation. Act Completed Standard Section 106 review FEMAI has determined there will be No Historic Properties Affected. SHPO concurrence with this determination was received, dated 8/1/2022. The scope ofv work has been reviewed and FEMAI has determined, based on Tribal preferences, that the project will not require Tribal Consultation. amccomb1 05/09/2023 18:50:08 GMT Completed Historic Buildings and Structures Completed No properties int the project area are! 50y years or older orl listed ont the National Register- Review concluded Completed Archeological Resources Completed Project affects only previously disturbed ground- Review concluded Resource Conservation and Completed Review concluded Recovery Act, aka Solid Waste Disposal Act (RCRA) (WSR) Wild and Scenic Rivers Act Completed Projecti is nota along and does not affect Wild and Scenic River Review concluded CONDITIONS Special Conditions required oni implementation of Projects: NOTE: Allt times are GMT using a 24-hour clock. Page 3of 4 05/09/2023 21:45:01 FEDERAL EMERGENCY MANAGEMENT AGENCY RECORD OF ENVIRONMENTAL CONSIDERATION (REC) REC-01 Project MGP-485.0061-x0) Title: City ofE Bartlett Fire Dept & Water Wells Generator Unusable equipment, debris and material shall be disposed ofina an approved manner and location. Int the event significant items (or evidence thereof) are discovered duringi implementation oft the project, appliçant shall handle, manage, and dispose of petroleum products, hazardous materials andt toxic wastei ina accordance tot the requirements and to thes satisfaction oft the governing local, state and federal agencies. Standard Conditions: Source ofc condition: Resource Conservation: and Recovery Act, aka Solid Waste Monitoring Required: No Disposal Act (RCRA) Any changet to thea approved scope of work willr require re-evaluation for compliance with NEPA and other Laws and Executive Orders. This review does not address allf federal, state and! local requirements. Acceptance off federal funding requires recipient to comply with all federal, state and locall laws. Failuret to obtain alla appropriate federal, state andl local environmental permits and clearances may Ifground disturbing activities occur during construction, applicant will monitor ground disturbance andi ifany potential archeological resources are discovered, willi immediately cease construction int that area andr notify the State andI FEMA. jeopardize federal funding. NOTE: Allt times are GMT using a 24-hour clock. Page 4of4 FEMA Region 6 Hazard Mitigation ssstance-tngineenng Record of Technical Consideration and Benefit Cost Summary Project Summary FEMA Program: Project Number: Subrecipient: County or Parish: Project Title: Project Type: Phase: Project Cost: BCA Summary Projected Benefit: Projected Cost: Benefit Cost Ratio: Benefit Coast Analysis Tool Used: Damage and Frequency Relationship: Hazard Type Analysis: Property Structure Type Type of Service: Number of Generators: BCA Reanalysis: Subrecipient BCA File Name: HMGP 4485-0061 City of Bartlett Bell County Generator Not Phased $450,048 City of Bartlett Fire Dept & Water Wells Generators $1,515,276 $577,827 2.62 Benefit-Cost Calculator V.6.0. Professional Expected Damages Infrastructure Falure/Uncategorized Utilities/Critical Facility Building Potable Water/Fire Station 3 Yes BCA Report Bartlett Main Well, Fire Dept, & 2nd Well Generators 05.08.2024.pdf FEMA June 12, 2024 1 Engineering Technical Recommendation and BCA Summary FEMA Reanalysis BCA SUMMARY Projected Benefits: Projected Cost: Benefit Cost Ratio: Benefit Coast Analysis Tool Used: Damage and Frequency Relationship: Hazard Type Analysis: Property Structure Type Type of Service: Number of Generators: FEMA: Reanalysis Summary: BCA File Name: Objective $1,514,396 $475,463 3.19 Benefit-Cost Calculator V.6.0. Build 20240510.2248 Professional Expected Damages Infrastructure Falure/Uncategorized Utilities/Critical Facility Building Potable Water/Fire Station 3 Recommended Annual Maintenance Costs were revised. Fire Station site Number of Customers Served was revised. 4485-0061 BCA Re-analysis.xlsx FEMA funds projects that reduce the risk to people and property from natural hazards. FEMA reviews all subapplications for eligibility and compliance with program requirements. This includes a program, technical, and Environmental and Historic Preservation (EHP) review. The technical review determines if the proposed project is technically feasible and cost-effective. This review may also identify pre- or post-award conditions. The conditions listed below must be met by project closeout. Scope of Work The City of Bartlett proposes the procurement and installation of 2 permanent 70-Kw and 1 permanent 150-kW natural gas generators. The generators will mitigate the Main Water Well, 2nd Water Well, and the City of Bartlett's Fire Department from power loss duei to natural hazards. Generators will be installed with automatic transfer switches on a concrete pad. Each generator will be in weather- -proof housing units at the required elevation for each site. See Table 11 for location coordinates. The Main Water Well project site has existing security fencing. The The subrecipient provided documentation from Trey S. Taylor, P.E., Texas# 94706, stating that the above noted, 70- kW and 150-kW size Kw generator capacities are sufficient to maintain the essential functions of the Main Water subrecipient will install security fencing at the other two sites. Well, 2nd Water Well, and the City of Bartlett's Fire Department. June 12, ,2024 2 Engineering Technical Recommendation and BCA Summary The scope of work includes developing final designs with at topographic survey. Site preparation and construction of two 11'Lx 6'Wx 6"D concrete pads (2nd Water Well & Fire Department) and one 13'Lx8 8'Wx6"D concrete pad (Main Water Well). The procurement of a generator, automatic transfer switch, and necessary generator appurtenances. Installation of the generator with its components, including transfer switch. Electrical wiring and integration of the generator with the facility's electrical system. Generator testing will be completed after installation. The generators Minimum elevation of the generator and all electrical components will be! 500-yr flood event or the 100-year plus freeboard required by ASCE-24, whichever is higher. The generator will be anchored per ASCE 24 requirements. All project components must be in compliance with latest edition of codes and standards required by Federal, State willl be protected by thei installation of security fencing. and Local Rules and regulations. Table 1: Generator Locations Name Main Water Well 2nd Water Well Fire Department Latitude Longitude Flood FIRM Zone 30.793823 97.430402 Outside 48491C0175F, effective on 12/20/2019 30.794459 97.429943 Outside 48491C0175F, effective on 12/20/2019 30.796239 97.429969 Outside 48027C0700E, effective on 09/26/2008 Benefit Cost Analysis AE Benefit Cost Analysis (BCA) was completed, thei following information was applied: Data Project Useful 19 Life Cost Maintenance Cost Number of Customers Data Used in BCA Source 1 2 3 4 Default value for BCA Toolkit Project budget for subapplication. $1 per kW of the generators' size/capacity $450,048 $570-$650 1,633 Region 6 minimum Annual Maintenance Costs based on $500 plus 2020 Census denotes 1,633 residents of the City of Bartlett.A conservative assessment was completed for the Number of Customers Served value used in the BCA re-analysis, averaging the total population of the City of Bartlett among the 2 Water Well projects sites, to establish a minimum value for the Number of Customers Served at each site. (1,633/2) = 816.5 customers. The population of the City of Bartlett was used as the value for the Number of Customers Served for the Fire Department project site June 12, 2024 3 Engineering Technical Recommendation and BCA Summary Data Data Used in BCA Source in the BCA. If the BCA is revised ini the future, supporting documentation to verify the specific number of customers served would be required to increase the calculated benefits of the BCA. 6 7 Damages Before Mitigation Damages After Default Mitigation Default Default values from BCA Toolkit Default values from BCA Toolkit Conditions 1. The project and all its attendant utilities are supporting a critical action. The generator and all components must be elevated, or otherwise protected, tot the 0.2% annual chance (500-year) basei flood elevation (BFE) or the 100-year BFE plus the freeboard required per ASCE-24, whichever is higher. The applicant must submit documentation of a) Determination of the BFE may be provided by the local floodplain administrator. This may include an issued permit or elevation certificate. An email or letter from the administrator is also acceptable. Other documentation may include a statement or study by a licensed engineer. A reference to a FEMA Flood b) Ifmultiple sources of flood hazard data are available for a project site, use the best available information. The best available information is the source which provides the highest BFE or BFE plus freeboard. Inr rare: situations, elevating or protecting to the BFE or BFE plus freeboard is not practicable. This may be due toe engineering feasibility or cost. In those situations, the subrecipient must provide documentation to FEMA with aj justification. The subrecipient must provide proof that non-compliance was due to unfeasibility or cost. 2. Subrecipient must coordinate with the local floodplain administrator to obtain required permits. The subrecipient must comply with any conditions of the permit(s) prior to initiating work. All permits and coordination pertaining to these activities must be retained by the subrecipient. Submit permits and documentation of coordination to FEMA at 3. FEMA approved BCA file titled 4485-0061 BCA Re-analysis.xisx" is attached to this recommendation. This BCA compliance to FEMA upon closeout. Insurance Study or other flood product is also acceptable. closeout. file must be used for any future scope of work and/or budget modifications. June 12, 2024 4 FEMA Benefit-Cost Calculator V6.0.0 Welcome Benefit-Cost Analysis (BCA) is the method by which the future benefits ofa hazard mitigation project are determined and compared to its costs. The end result is a Benefit-Cost Ratio (BCR), which is calculated bya FEMA requires a BCA1 to validate cost effectiveness of proposed hazard project's total benefits divided by its total costs. mitigation projects prior to funding. For a community and/or property, this tool will assist with: Estimating Annual Hazard Risks Evaluating Mitigation Cost Effectiveness Developing Aggregate Benefit-Cost Models used in this tool, visit FEMA BCA Website. For more information, including methodologies of the calculation models Getting Started Click on the "BCA Calculator" button on the ribbon bar. 257 o SorB Find & Bltens Select- BCAV6.0 @ FEMA Add-Ins Editing Template Last Updated: July 17,2019 MRB Group Advancing Communities September 20, 2024 The Honorable Chad Mees, Mayor City of Bartlett 140 W. Clark Street Bartlett, TX7 76511 Re: Proposal for Professional Services CDBG City Wide Water System Valve Replacement-City of Bartiett Dear Mayor Mees, Services. MRB Group, P.C. (MRB) is pleased to provide the City of Bartlett with this proposal for Professional ackgroumatumdertanmding The City of Bartlett's water system valves are aged, and many are no longer fully functional. When a water main breaks, the valves are not functional, requiring the City to drain the entire water system to repair the break. This Project will replace isolation valves to limit the number of residences without water during ay water main break. We understand this Project will be partially funded by a Community Development Block Grant (CDBG). II. Scope of Services and Compensation A. Design Phase 1. Compile existing site and system information as needed for the design. A map of existing 2. When the funding application was submitted in 2023, one hundred and two (102) valves were anticipated to be replaced. Current economic conditions may not allow for replacement of all valves. MRB will review the location oft the valves and put together an initial priority list for valve replacement. The City and MRB will meet to finalize the priority list prior to beginning valve locations will be created from the GIS database. detailed design. 3031 W. Calhoun Ave, Temple, TX76501 . (254)771-2054 TBPE Firm No. F-10615 MRBGroup.com MRB Group Advancing Communities 3. Prepare design drawings using aerial mapping with GIS water system data as a base and technical specifications for locations of valve replacement and installation of new valves and 4. Provide an engineer's opinion of probable construction costs for the installation of new 5. Provide Contract Documents for bidding the work utilizing EJCDC Standard documents and Construction Specifications Institute section format. The Project is anticipated to be bid under 6. Attend one (1) meeting with the City of Bartlett to review the contract documents. MRB will develop the final set of drawings and specifications based on review comments received from 7. Submit plans and specifications to the Texas Commission on Environmental Quality (TCEQ) for review and approval. MRB will work with TCEQ to resolve any questions or concerns. required restoration. valves. asingle contractor. the City. 8. Produce final contract documents for bidding. Subtotal of A, Items 1-8 B. Bidding Phase $27,790.00 1. MRB will prepare an advertisement for bid for publication on CivCast and provide electronic documents to the Client to be distributed to bidders as requested. MRB will provide two (2) sets of 11x17 plans and specifications toi the Client to allow local contractors to review the plans and specifications at the Client's office. MRB will distribute electronic bid documents in 2. MRB will coordinate and chair al Pre-Bid meeting to present the general outline of the Project tol bidders, clarify any questions on the contract documents, and prepare clarifications or 3. MRB will prepare an Addendum based on questions and comments from bidders during the 4. MRB will attend the bid opening and review the bids received for completeness and conformance with the bidding requirements. MRB will provide al bid review and summary to PDF format to bidders via CivCast. changes via an Addendum. bid process and distribute them in PDF format via CivCast. assist the Client in awarding the contract. Subtotal of B, Items 1-4 $5,000.00 Thel Honorable Chad Mees, Mayor City ofB Bartlett September 20, 2024 Re: CDBG City) Wide Water System Valve Replacement--Cily of Bartlett MRB Group Advancing Communities - Construction Administration 1. Coordinate and chair the pre-construction meeting with the Contractor, Grant Administrator, 3. Respond to RFIs, issue RFPs, andi issue clarifications and change orders, as required. 4. Review the progress of work and payment applications and provide recommendations to the 5. Issue Substantial Completion certification and provide punch list to Contractor. 6. Provide record drawing documents in PDF format based on red lines and field notes from the 7. Construction administration is anticipated to take four (4) months to complete. and City representatives. Prepare and distribute meeting minutes. 2. Review contractor shop drawings and submittals. City and Grant Administrator. Contractor. Subtotal of C, Items 1-7 D. Construction Observation $9,000.00 1. Observe the activities of the Contractor on a part-time basis. Construction observation will be limited to a maximum oft twelve (12) hours per week for twelve (12) weeks. This task will be on an hourly basis. Subtotal of D, Item 1 Total Compensation $20,160.00 $61,950.00 The cost figures shown above represent our lump sum and hourly not-to-exceed amounts. Any additional work beyond this fee and outside the scope of this proposal would be reviewed with the Client. MRB Group will submit monthly statements for. services rendered during each invoicing period based on the efforts performed during that period. MRB Group Rates are subject to adjustment. III. Additional Services The following items, not included in the above scope of services, can be provided on a personnel time-charge basis but would only be performed upon receipt of your authorization: Thel Honorable Chad Mees, Mayor City ofE Bartlett September 20, 2024 Re: CDBG City) Wide Water System Valve Replacement--Clity ofB Bartlett Advancing Communities MRB Group A. Attendance at Board Meetings or Public Meetings. B. Geotechnical investigations. C. Hazardous Materials Survey. D. Grant administration. : Survey IV. Commencement of Work Upon receipt oft the signed proposal, MRB Group will begin work on the Project. V. Standard Terms and Conditions Attached hereto and made part of this Agreement are MRB Group's Standard Terms and Conditions. Ifthis proposal is acceptable, please sign where indicated and return it to our office. Thank you for considering our firm. We look forward to working with you on this significant Project. Sincerely, daso James J. Oberst, P.E., LEED/ AP Executive Vice President/Coo Tiey E Central Texas Operations Manager Https: Imrbgroup365. sharepoint comalesPoposalsshard Documents/TexasBantet. City of/0-24-0575 2023 CDBG Water Valve ReplacemenuProposal- CDBG Water System Valve Replacement. .docx The Honorable Chad Mees, Mayor City of Bartlett September 20, 2024 Re: CDBG City Wide Water System Valve Replacement--City of Bartlett Advancing Communities MRB Group Enclosure MRB Group's Standard Terms and Conditions Proposal Accepted for the City of Bartlett by: Signature Title Date The Honorable Chad Mees, Mayor City of Bartlett September 20, 2024 Re: CDBG City) Wide Water System Valve Replacement--City of Bartlett Advancing Communities MRB Group MRB GROUP, P.C.AGREEMENT FOR PROFESSIONAL SERVICES STANDARD TERMS AND CONDITIONS A. TERMINATION This Agreement may be terminated by either party with seven days' written notice ini the event of substantial failure to perform in accordance with the terms hereof by one party through no fault of the other party. Ifthis Agreement is so terminated, the Professional Services Organization (hereinafter referred to as P.S.O.) shall be paid for services performed on the basis of his reasonable estimate for the portion of work completed prior to termination. In the event of any termination, the P.S.O. shall be paid all terminal expenses resulting therefrom, plus payment for additional services then due. Any primary payment madeshall be credited toward any terminal payment due the P.S.O. If, prior to termination of this Agreement, any work designed or specified by the P.S.O. during any phase of the worki is abandoned, after written notice from the client, the P.S.O. shall be paid for services performed on account of it prior to receipt of such notice from the client. B. OWNERSHIP OF DOCUMENTS All reports, drawings, specifications, computer files, field data and other documents prepared by the P.S.O. are instruments of service and shall remain the property of the P.S.O. The client shall not reuse or make any modification to the instruments of service without the written permission of the P.S.O. The client agrees to defend, indemnify and hold harmless the P.S.O. from all claims, damages, liabilities and costs, including attorneys' fees, arising from reuse or modification of the instruments of service by the client or any person or entity that acquires or obtains the instruments of service from or through the client. ESTIMATES Since the P.S.O. has no control over the cost ofl labor and materials, or over competitive bidding and market conditions, the estimates of construction cost provided for herein are to be made on the basis of his experience. and qualifications, but the P.S.O. does not guarantee the accuracy of such estimates as compared to the Contractor's bid or the project construction cost. D. INSURANCE The P.S.O. agrees to procure and maintain insurance at the P.S.O.'s expense, such insurance as will protect him and the client from claims under the Workmen's Compensation Act and from claims for bodily injury, death or property damage which may arise from the negligent performance by the P.S.O. or his representative. INDEPENDENT CONTRACTOR The P.S.O. agrees that in accordance with its status as an independent contractor, itwill conduct itself with such status, that it will neither hold itself out as nor claim to be an officer or employee oft the client, byreason hereof, and thati ity will not by reason hereof make any claim, demand or application to or for any right or privilege applicable to an officer or employee of the client, including, but not limited to, Workmen's Compensation coverage, unemployment insurance benefits or Social Security coverage. Page1 Advancing Communities MRB Group SUCCESSORS AND ASSIGNS The client and the P.S.O. each binds himself and his partners, successors, executors, administrators and assigns to the other party of this Agreement and to the partners, successors, executors, administrators and assigns of such other party, in respect to all covenants of this Agreement; except as above, neither the client nor the P.S.O. shall assign, submit or transfer his interest in this Agreement without the written consent oft the other. G. P.S.O. NOT RESPONSIBLE FOR SAFETY PROVISIONS The P.S.O. is not responsible for construction means, methods, techniques, sequences or procedures, time of performance, programs, or for any safety precautions in connection with the construction work. The P.S.O.is not responsible for the Contractor's failure to execute the work in accordance with the Contract Drawings and/or Specifications. H. INVOICES. ANDI PAYMENT Client will pay! MRB Group, Engineering, Architecture, Surveying, D.P.C. for services in respect of the period during which Services are performed in accordance with the fee structure and work estimate set forth ini the proposal. Invoices willl be submitted on a periodic basis, or upon completion of Services, as indicated in the proposal or contract. All invoices are due upon receipt. Any invoice remaining unpaid after 30 days will bear interest from such date at 1.5 percent per month or at the maximum lawful interest rate, ifs such lawful rate is less than 1.5 percent per month. If client fails to pay anyi invoice when due, MRB may, at any time, and without waiving any other rights or claims against Client and without thereby incurring any liability to Client, elect to terminate performance of Services upon ten (10) days prior written notice by MRB to client. Notwithstanding any termination of Services by MRB for non-payment of Invoices, Client shall pay MRB ini full for all Services rendered by MRB1 to the date of termination of Services plus alli interest and termination costs and expenses incurred by MRB that are related to such termination. Client shall be liable to reimburse MRB for all costs and expenses of collection, including reasonable attorney's fees. FEES REQUIRED FROM JURISDICTIONAL AGENCIES MRB Group, D.P.C. is not responsible for nor does the Compensation Schedule established in the Agreement include fees or payments required of jurisdictional agencies. The client herein agrees to pay all application, entrance, recording andlor service fees required by said agencies. P.S.O. NOT ANI EMPLOYEE employees or agents. INDEMNITY Thel P.S.O. agrees not to hold himself out as an officer, employee or agent of the Owner, nor shall he make any claim against the Owner as an officer, employee or agent thereof for such benefits accruing to said officers, The Owner will require any Contractor and Subcontractors performing the work to hold it harmless and indemnify and defend the Owner and P.S.O., their officers, employees and agents from all claims resulting from the Contractor's negligence int the performance of1 the work. Page2 Advancing Communities MRB Group September 18, 2024 The Honorable Chad Mees, Mayor City of Bartlett 140 W. Clark Street Bartlett, TX76511 Re: Proposal for Professional Services TDEM Generators - Evie Street Lift Station and Wastewater Treatment Plant Lift Station Dear Mayor Mees, MRB Group is pleased to provide the City of Bartlett with this proposal for Professional Services for new generators at the Evie Street Lift Station and the' Wastewater Treatment Plant Lift Station ("Project"). acgoundlunertandng The City of Bartlett's existing wastewater treatment plant lift station's emergency generator is at the end of its useful life and is proposed to be replaced as part of this Project. The Evie Street Lift Station does not have an existing generator and does not operate during power outages. This critical lift station serves approximately 80 homes and the prison in Bartlett; therefore, a new generator is proposed for this lift station as well. We understand that the replacement of the WWTP Lift Station generator and installation of the Evie Street Lift Station generator will be funded by a partial grant from the Texas Division of Emergency Management (TDEM). Our scope of work willl be to design appropriate generators for each site. II. Scope of Services and Compensation A. Design Phase 1. Compile existing site and system information as needed for the design of the new generators. 2. Conduct at topographic oft the two (2) sites and al boundary survey for the Evie Street site. 3. Prepare a temporary construction easement for the adjacent parcel surrounding the Evie Street Lift Station site. 303 W. Calhoun Ave, Temple, TX76501- (254)771-2054 TBPE No. F-10615 MRBGroup.com Advancing Communities MRB Group 4. Prepare design drawings and technical specifications for new generators at the two (2) lift station sites. The design willi include the sizing and selection of the generatorsautomatic transfer switches, the electrical requirements, including SCADA (related only to the generators), pad design, and the details of thet final improvement of the generators. 5. Provide an engineer's opinion of probable construction cost for the installation of new 7. Provide Contract Documents for bidding of the work utilizing EJCDC Standard documents and Construction Specifications Institute section format. The Project is anticipated to be bid 8. Attend one (1) meeting with the City of Bartlett to review the contract documents. Based on the City's review comments, MRB will develop the final set of drawings and specifications. 9. Submit plans and specifications to the Texas Commission on Environmental Quality (TCEQ) for review and approval. MRB will work with TCEQ to resolve any questions or concerns. generators at each lift station site. . Coordinate with sub-consultants, including electrical and survey. under a single contractor. 10. Produce final contract documents for bidding. Subtotal of A, Items 1-10 B. Bidding Phase $25,640.00 1. MRB will prepare an advertisement for bid for publication on CivCast and provide electronic documents to the Client to be distributed to bidders as requested. MRB will provide two (2) sets of 11x17 plans and specifications to the Client to allow local contractors to review the plans and specifications at the Client's office. MRB will distribute electronic bid documents in 2. MRB will coordinate and chair al Pre-Bid meeting to present the general outline of the Project tol bidders, clarify any questions on the contract documents, and prepare clarifications or 3. MRB will prepare an Addendum based on questions and comments from bidders during the 4. MRB willa attend the bid opening and review the bids received to ensure completeness and conformance with the bidding requirements. MRB will provide al bid review and summary to PDF format to bidders via CivCast. changes via an Addendum. bid process and distribute them in PDF format via CivCast. assist the Client in awarding the contract. The Honorable Chad Mees, Mayor City of Bartlett September 18, 2024 Re: TDEM Generators- Evie StreetLift Stationa and Wastewater Treatment Plant Lifts Station Advancing Communities MRB Group Subtotal of B, Items 1-4 Construction Administration $5,500.00 1. Coordinate and chair the pre-construction meeting with the Contractor, Grant Administrator, 3. Respond to RFIs, issue RFPs, andi issue clarifications and change orders, as required. 4. Review the progress of work and payment applications and provide recommendations to the 5. Issue Substantial Completion certification and provide a punch list to the Contractor. 6. Provide record drawing documents in PDF format based on red lines and field notes from the and City representatives. Prepare and distribute meeting minutes. 2. Review contractor shop drawings and submittals. City and Grant Administrator. Contractor. Subtotal of C, Items 1-6 Total Compensation $8,500.00 $39,640.00 The cost figure shown above represents our lump sum amount. Any additional work beyond this fee and outside the scope of this proposal would be reviewed with the Client. MRB Group will submit monthly statements for services rendered during each invoicing period based on the efforts performed during that period. MRB Group Rates are subject to adjustment. II. Additional Services Thei following items, noti included in the above scope of services, can be provided on a personnel time-charge basis but would only be performed upon receipt of your authorization: A. Attendance at Board Meetings or Public Meetings. B. Geotechnical investigations. Hazardous Materials Survey. D. Grant administration. :. Construction Observation. F. Utility company fees The Honorable Chad Mees, Mayor City of Bartlett September 18,2 2024 Re: TDEM Generators- Evie StreetLift Stationa andV Wastewater Treatment Plant Lift Station Advancing Communities MRB Group IV. Commencement of Work Upon receipt of the signed proposal, MRB Group willl begin work on the Project. V. Standard Terms and Conditions Attached hereto and made part of this Agreement are MRB Group's Standard Terms and Conditions. Ift this proposal is acceptable, please sign where indicated and return itt to our office. Thank you for considering our firm. We look forward to working with you on this Project. Sincerely, 14 Trey S. Taylor, P.E. Central Texas Operations Manager daoen James J. Oberst, P.E., LEEDAP Executive' Vice President/COO Https: Imrbgroup365 sharepoint comaieuPopaaShamd Documemnts/TexasBantet. City of/0-24-0617 TEDM Generators Evie Sta and WWTP/Proposal. Generators atE Evie StLS and WWTPI LS8 8-28-2024. docx Enclosure MRB Group's Standard Terms and Conditions Proposal Accepted for the City of Bartlett by: Signature Title Date The Honorable Chad Mees, Mayor City ofE Bartlett September 18,2024 Re: TDEM Generators- Evie Streetl Lift Station and Wastewater Treatment Plant Lift Station Advancing Communities MRB Group MRB GROUP, P.C. AGREEMENT FOR PROFESSIONAL SERVICES STANDARD TERMS AND CONDITIONS A. TERMINATION This Agreement may be terminated by either party with seven days' written notice in the event of substantial failure to perform in accordance with the terms hereof by one party through no fault of the other party. Ifthis Agreement is so terminated, the Professional Services Organization (hereinafter referred to as P.S.O.) shall be paid for services performed on the basis of his reasonable estimate for the portion of work completed prior tot termination. Ini the event of any termination, the P.S.O. shall be paid all terminal expenses resulting therefrom, plus payment for additional services then due. Any primary payment madeshall be credited toward any terminal payment due the P.S.O. If, prior to termination of this Agreement, any work designed or specified by the P.S.O. during any phase of the work is abandoned, after written notice from the Client, the P.S.O. shall be paid for services performed on account of it prior to receipt of such notice from the Client. B. OWNERSHIP OF DOCUMENTS All reports, drawings, specifications, computer files, field data and other documents prepared by the P.S.O. are instruments of service and shall remain the property of the P.S.O. The Client shall not reuse or make any modification to the instruments of service without the written permission of the P.S.O. The Client agrees to defend, indemnify and hold harmless the P.S.O. from all claims, damages, liabilities and costs, including attorneys' fees, arising from reuse or modification of the instruments of service by the Client or any person or entity that acquires or obtains the instruments of service from or through the Client. :. ESTIMATES Since the P.S.O. has no control over the cost of labor and materials, or over competitive bidding and market conditions, the estimates of construction cost provided for herein are to be made on the basis of his experience and qualifications, but the P.S.O. does not guarantee the accuracy of such estimates as compared to the Contractor's bid or the project construction cost. D. INSURANCE The P.S.O. agrees to procure and maintain insurance at the P.S.O.'s expense, such insurance as will protect him and the Client from claims under the Workmen's Compensation Act and from claims for bodily injury, death or property damage which may arise from the negligent performance by the P.S.O. or his representative. INDEPENDENT CONTRACTOR Thel P.S.O. agrees that in accordance withi its status as an independent contractor, itv will conduct itself with such status, that it will neither hold itself out as nor claim to be an officer or employee of the Client, byreason hereof, and that it will not by reason hereof make any claim, demand or application to or for any rightor privilege applicable to an officer or employee of the Client, including, but not limited to, Workmen's Compensation coverage, unemployment insurance benefits or Social Security coverage. Page1 Advancing Communities MRB Group SUCCESSORS AND ASSIGNS The Client and the P.S.O. each binds himself and his partners, successors, executors, administrators and assigns to the other party of this Agreement: and to the partners, successors, executors, administrators and assigns of such other party, in respect to all covenants oft this Agreement; except as above, neither the Client nor the P.S.O. shall assign, submit or transfer his interest in this Agreement without the written consent oft the other. . P.S.O. NOT RESPONSIBLE FOR SAFETY PROVISIONS The P.S.O. is not responsible for construction means, methods, techniques, sequences or procedures, time of performance, programs, or for any safety precautions in connection with the construction work. The P.S.O.is not responsible for the Contractor's failure to execute the work in accordance with the Contract Drawings and/or Specifications. H. INVOICES AND PAYMENT Client will pay MRB Group, Engineering, Architecture, Surveying, D.P.C. for services in respect of the period during which Services are performed in accordance with the fee structure and work estimate set forth in the proposal. Invoices will be submitted on a periodic basis, or upon completion of Services, as indicated in the proposal or contract. All invoices are due upon receipt. Any invoice remaining unpaid after 30 days will bear interest from such date at 1.5 percent per month or at the maximum lawful interest rate, ifs such lawful rate is less than 1.5 percent per month. If Client fails to pay any invoice when due, MRB may, at any time, and without waiving any other rights or claims against Client and without thereby incurring any liability to Client, elect to terminate performance of Services upon ten (10) days prior written notice by MRB to Client. Notwithstanding any termination of Services by MRB for non-payment of Invoices, Client shall pay MRBi in full for all Services rendered by MRB to the date of termination of Services plus alli interest and termination costs and expenses incurred by MRB that are related to such termination. Client shall be liable to reimburse MRB1 for all costs and expenses of collection, including reasonable attorney's fees. FEES REQUIRED FROM JURISDICTIONAL AGENCIES MRB Group, D.P.C. is not responsible for nor does the Compensation Schedule established in the Agreement include fees or payments required ofj jurisdictional agencies. The Client herein agrees to pay all application, entrance, recording and/or service fees required by said agencies. P.S.O. NOT ANI EMPLOYEE employees or agents. INDEMNITY The P.S.O. agrees not to hold himself out as an officer, employee or agent of the Owner, nor shall he make any claim against the Owner as an officer, employee or agent thereof for such benefits accruing to said officers, The Owner will require any Contractor and Subcontractors performing the work to hold it harmless and indemnify and defend the Owner and P.S.O., their officers, employees and agents from all claims resulting from the Contractor's negligence ini the performance oft the work. Page2