MONTHLY PUBLIC SAFETY REPORT B6 December 2023 Department News Residential Contact 96 Contacts Neighborhood Visits starting this month Santa Parade update 2023 Accidents Oct - Nov Dec Activity Oct Nov Dec YTD Proactive Activity Oct Nov a Dec 6 DPS Activity 1815 1487 1708 19571 600 547 507 495 5 Police CFS 628 516 663 7050 500 440 EMS CFS 15 11 13 147 400 316 3 300 Fire CFS 12 10 8 109 242 22 2 192 202 200 Arrests 11 21 18 159 1 House Watches, Close 100 Patrols, & Community 642 434 459 5323 Contacts Auto/Ped Hit & Run Major Majorv w/o Minor 0 w/Inj. Inj. Traffic Enforcement 507 495 547 6783 Close Patrol House Watch Traffic Crime Trends Oct Nov "Dec 6 5 5 4 3 3 2 2 1 1 1 1 1 0 0 U 0 0 0 0 0 0 0 Assault Burglary Burglary Burglary Criminal Death Fraud Narcotics Theft Report Theft Report- Other (See *) Report Report Report Report Mischief Investigation Motor Vehicle Commercial Residential Vehicle Report * Other offenses excluding traffic, warrants and' "report only." Dalworlhinglon RG December 2023 Financial Summary Gardens General Fund Reserve YTD balance ended the month with 315 operating days, which is 345% of the minimum target. Budgeted Operating Expenses FY 23/24 $ 3,798,118 Operating Budget Expenditures cost per day (365 days) $ 10,406 Fund Balance at 12/31/23 $ 3,274,077 # of operating days in Fund Balance 315 This month had an increase of 65 days from November's: # of days, which was 250. This increase is primarily due to property tax collections. Enterprise Working Capital balance should be a minimum of 90 days to comply with the Financial Policy. This month had a decrease of 11 days from November's # of days, which was 127. The material reasons for the decrease were as follows: Kimley Horn $20,000 towards the water study & $3,153 for GIS services TAS $9,510 emergency Scada repairs Axis Construction $20,780 Kasco Mixer Budgeted Operating Expenses FY 23/24 $ 2,316,772 Operating Budget Expenditures cost per day (365 days) $ 6,347 Working Capital Balance at 12/31/23 $ 735,607 # of operating days in Fund Balance 116 110-General Fund REVENUES YTD revenues are trending below the 3-month budget by ($117.7K) > Property taxes are under by ($133,714) > Sales taxes are under by ($15,168) > Franchise taxes are over by $3,893 > Permits are over by $20,142 > Fines & Fees are over by $13,559 > Charges for services are over by $2,043 > Other Revenue is under by ($579) > Oil & Gas is under by ($2,829) > Other financing sources are under by ($5,000) Property and Sales taxes are budgeted monthly based on historical trends. Taxes: Franchise-Refuse 110.00.4070: After questioning the high franchise amounts and requesting detail reports, it was determined that CWD has overpaid the city $3,856.63. Actual Franchise Fee totals for Oct - Dec should be $3,128.97. CWD has provided detail and finance has confirmed this is correct. Permits/Fees: Building 110.00.4100: $1,884 2512 Roosevelt Drive Charges for Service 110.00.4455: Platting/Zone $4,500 Roosevelt Estates Other Revenue 110.00.4800: Interest Income LOGIC decreased to 5.5411% from November of 5.5598%. TexStar increased to 5.3378% from November of 5.3307%. Susser Bank rates have remained unchanged at 3.5%. Current interest for December was $13,743.67, of which $1,815.76 was fori the CLSFRF account and transferred to the 142-City Hall Fund. Interest revenue is over the 3-month budget by $69. EXPENDITURES YTD expenditures are trending below the 3-month budget by ($130,797), of which material variances are explained by department below: > Court dept ($3,867), of which ($2,000) is related to a budgeted pending capital purchase for server upgrades. Admin dept ($7,840), of which ($5,400) is related to a budgeted pending capital purchase for server upgrades and ($4,000) budgeted November election expense. PSO dept ($82,076), of which the material variances are ($66,851) personnel, ($5,954) training, and ($2,000) is related to a budgeted pending capital purchase for server upgrades. > Fire dept $22,041, of which the material variances are ($17,327) personnel. > PW dept ($7,417), of which the material variances are $5,092) personnel. > Transfer out to CCPD for ($5,000) is under budget pending proceeds of vehicle sales. An Expenditure account with noteworthy monthly expenditures: 110.40.7045: Consultants: Engineer-Platting with Kimley Horn. Explanation of services: $1,180, 4 hours, Roosevelt Estates 110.40.7415: Contractual: Contract Labor reflects a temporary accounting clerk to assist the finance dept. 110.50.6270: Mat/Supplies: Emergency Equip reflects costs to purchase (2) Truespeed Lidars $2,990. 110.55.6805: Maintenance: Vehicles reflects $4,322 for E243 PM repairs. 110.60.7030: Consultants: Engineer-Regular reflects a reclass for GIS Service that should have been expensed to the enterprise fund. 120-Enterprise Fund REVENUES YTD revenues are trending below the 3-month budget by ($77,312). Primary reason is lower water and sewer sales due to more rain in the last 3 months versus prior 3-year average for these 3 months. Water and Sewer revenues are budgeted monthly based on 3-year historical trends. EXPENSES YTD expenses are below the 3-month budget by ($104,081), of which $23,099) personnel costs, ($11,143) Maintenance: Water & Sewer systems, ($60,478) Consultants: Engineer-Regular related to the Kimley Horn services explained in more detail below, ($27,105) purchase water, ($5,294) sewer treatment, ($30,000) prorate portion oft the $200,000 budgeted item for unknown expenses. 120.40.6910: Maintenance: Water Distribution reflects costs for emergency repairs to the SCADA system at the Arkansas Ln station $9,510 120.40.7030: Consultants: Engineer-Regular engineering costs with Kimley Horn. Explanation of services: ) $12,063 Bowen Sewer Assessment 42 hours $3,153 GIS Services reclassed from the general fund for last month billing classified as stormwater and should have been 100% enterprise. $20,000 Water Master Plan update. $80,000 lump sum contract signed. Budget amendment presented to move from 120.40.9200 capital to cover these costs. 120.40.9020: Capital Outlay - Water Tank reflects costs for KASCO Mixer. Monthly Water Loss (1.4%) 140-CDBG Project Fund 140.00.6605: CDBG Projects reflects engineering costs from Topographic on the 49th CDBG project. 141-City Street Bond Fund 141.00.4895 Other Revenue: Contributed Property reflects the final reimbursement on the Tarrant County Bond Corzine project. 142-City Hall Bond Fund 142.00.6603 DPS Complex reflects costs for access door controls in the DPS room. 143-Street Sales Tax Fund 143.40.6835: Maintenance Street Repair reflects costs for the W Arkansas Lane striping. 143.40.9360: Capital Outlay: Street Project reflects costs of $8,657 to Bridge Brothers for the Middle Bridge on Roosevelt & Sunset 185-CCPD Fund 185.50.9100: Capital Outlay: DPS Equipment reflects new Unit: 49 accessory upfit costs Oil & Gas Reserve Fund Gas royalties for Dec were $3,298.15. Royalties have a 2-month lag from the receipt month. Oct volume decreased from Sep by (86.30)/cf with a price decreasing $.004/cf. Oct Rate $2.2144/cf. Gas Reserve Funds life-to-date are $832,101.73 (includes interest earned). This balance represents 79.97 days of operating reserve. BKV/XTO ENERGY -Transportation -Gross Revenue -Net Revenue e-Production 45,000 6,000 40,000 5,000 C 35,000 U R B E 30,000 4,000 V E 25,000 C N 3,000 20,000 U F E E 15,000 2,000 E 10,000 T 1,000 5,000 UNIT PRICE $12.00 $10.00 $8.00 $6.00 A R $4.00 $2.00 $0.00 - PRODUCTION MONTH 4 Unit Price 8 - 6 - P 3D C 0 - E FF TnT F6 B LA - E 0 3 $A A B RD - - 4 R, - 3 REuN 3 a E2 eNy 3 2 p 3 E - - u, o - e o & unr a & "Ay d a - 12, o a uy 3 12, unp - 8 1, "eN e e 3 02 o 8 o 5 Qy E 8 o 02, un 3 3 & EV a 5 67 o - 5 Pa, R N PRup W 62, "ey 87 eo 0 a8equapad a E I - - 3 E E E I a 3 8 E à - I 5 : 4 E C 5 € a - S a I 1 D5 i E 5 5 . a ET - - - E: : :. E I I I * a à I E a 1 1 : - I : - a a e E I I I a - 4 - 1 1 B Bi I - 33 I E E e I - A I E - - i 1 5 3 E 12 3 1 s I3 - - I E E E - 18 1 I I B E 1 a - 3. - a - I I 8 1 8 6 3 E E a l @ e 1 I 1. E I I E - - E1 I 4 € - I 31 - a :. E 3 E 1 - E E 1 I E 3 3 E I 3 3 I 1 E - 1 E al E 8 31 - - - - E E a - E I 5 5 I - - e - a EI - I a - I 1 - 3 =3 8 1 I I I € 3 a E - & I 5 I 1 1 S I I - I - I 3 I I E I & 1 I I 11 1 I & I I : 5 I a 2 I 3 I 6 35 I I E 110 - GENERAL FUND General Fund Year to Date BUDGET VS. ACTUALI REPORT (BAR) FY 2023-24 FY 2023-24 OVR/(UNDER) % OF BUDGET FY2 2022-23 FY 2021-22 YTDE Ending December 31, 2023 BUDGET YTD BUDGET YTD YTD YTD Property Taxes 2,282,121 1,086,233 (1,195,888) 47.6% 1,167,653 1,109,263 Sales & Use Taxes 609,147 137,197 (471,950) 22.5% 104,751 134,097 Franchise Taxes 289,861 11,224 (278,637) 3.9% 6,471 7,279 Permits & Fees 56,595 34,023 (22,572) 60.1% 12,941 16,006 Fines & Fees 316,500 92,684 (223,816) 29.3% 47,254 89,708 Charges for Service 22,000 7,668 (14,332) 34.9% 19,410 Other Revenue 220,950 41,149 (179,801) 18.6% 27,234 3,109 Other Financing Sources 76,000 16,500 (59,500) 21.7% 11,000 9,316 Oil8 & Gas 60,000 12,171 (47,829) 20.3% 58,219 48,153 TOTALI REVENUES $ 3,933,174 $ 1,438,848 $ (2,494,326) 36.6% $ 1,435,523 $ 1,436,342 Salary & Wages 1,846,296 381,312 (1,464,984) 20.7% 389,714 284,936 Taxes & Benefits 815,341 156,172 (659,169) 19.2% 152,074 109,901 Training & Travel 78,343 8,646 (69,697) 11.0% 6,444 9,691 Materials & Supplies 165,514 35,087 (130,427) 21.2% 29,053 13,021 Utilities 71,065 16,930 (54,135) 23.8% 16,240 12,067 Maintenance 114,864 36,833 (78,031) 32.1% 22,188 5,939 Consultants 188,905 54,356 (134,549) 28.8% 38,098 23,788 Contractual 338,103 103,803 (234,300) 30.7% 89,102 52,070 Other 179,686 17,434 (162,252) 9.7% 28,945 7,199 Capital Outlay 52,200 41,463 (10,737) 79.4% 15,315 Transfer to Gas Reserve 35,000 5,921 (29,079) 16.9% 67,634 19,073 Transfer to Enterprise 0.0% Transfer to PRFDC 0.0% Transfer to CCPD 10,000 (10,000) 0.0% 9,200 Transfer to DPS Complex 10,200 5,373 (4,827) 52.7% 591,605 Transfer to Fire Truck Fund 25,000 6,250 (18,750) 25.0% 6,250 6,250 TOTALE EXPENDITURES $ 3,930,518 $ 869,580 $ (3,060,938) 22.1% $ 1,452,661 $ 553,136 Revenue Over/(Under) Expenditures $ 2,656 $ 569,268 $ 566,613 > (17,139) $ 883,206 TOTAL REVENUE: HISTORICAL TREND 1,200,000 1,000,000 800,000 600,000 - FY: 2023-24 -FY: 2022-23 400,000 -FY: 2021-22 200,000 Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep TOTAL EXPENDITURE: HISTORICAL TREND 1,000,000 900,000 800,000 700,000 600,000 4 FY 2023-24 500,000 -FY: 2022-23 400,000 -FY 2021-22 300,000 200,000 100,000 OCT NOV DEC JAN FEB MAR APR MAY JUN: JUL AUG SEP 01/18/2024 Page 1 of 47 110 - GENERAL FUND General Fund CURRENTI MONTH BUDGET VS. ACTUAL REPORT (BAR) BUDGET ACTUAL OVR/(UNDER) % OF BUDGET FY: 2022-23 FY: 2021-22 Month Ending December 31, 2023 DEC DEC BUDGET DEC DEC DEC Property Taxes 953,252 817,249 (136,002) 85.7% 905,037 835,078 Sales & Use Taxes 47,589 44,843 (2,747) 94.2% 47,634 40,856 Franchise Taxes 900 4,035 3,135 448.3% 886 949 Permits & Fees 4,627 3,455 (1,172) 74.7% 3,870 3,057 Fines & Fees 26,375 34,582 8,207 131.1% 22,135 27,679 Charges for Service 1,625 4,500 2,875 276.9% 760 7,770 Other Revenue 14,054 14,181 127 100.9% 8,112 771 Other Financing Sources 5,500 5,500 100.0% 5,500 Oil8 & Gas 5,000 3,298 (1,702) 66.0% 15,665 17,266 TOTALI REVENUES $ 1,058,922 $ 931,643 $ (127,279) 88.0% $ 1,009,600 $ 933,425 Salary & Wages 156,885 132,601 (24,284) 84.5% 139,514 126,591 Taxes & Benefits 64,430 53,849 (10,581) 83.6% 53,982 49,724 Training & Travel 6,479 184 (6,295) 2.8% 630 1,274 Materials & Supplies 13,393 12,392 (1,000) 92.5% 10,051 9,188 Utilities 5,468 5,724 256 104.7% 5,309 5,127 Maintenance 9,572 10,214 642 106.7% 8,660 6,198 Consultants 14,503 10,246 (4,257) 70.6% 10,789 14,607 Contractual 37,311 29,598 (7,713) 79.3% 27,092 24,455 Other 4,422 6,523 2,101 147.5% 4,663 4,702 Capital Outlay 0.0% Transfer to Gas Reserve 2,917 1,215 (1,702) 41.7% 13,582 15,182 Transfer to Enterprise Fund 0.0% Transfer to PRFDC 0.0% Transfer to Fire Truck Fund 2,083 2,083 100.0% 2,083 2,083 Transfer to CCPD 0.0% Transfer tol DPS Complex 1,700 1,816 116 106.8% 853 TOTALE EXPENDITURES $ 319,163 $ 266,445 $ (52,718) 83.5% $ 277,208 $ 259,132 Revenue Over/(Under) Expenditures $ 739,759 $ 665,198 $ (74,561) $ 732,392 $ 674,293 DECEMBER REVENUE: HISTORICAL TREND 1,000,000 900,000 800,000 700,000 600,000 500,000 ACTUAL 400,000 "FY2022-23 300,000 FY 2021-22 200,000 100,000 Property Taxes Sales & Use Franchise Taxes Permits & Fees Fines & Fees Charges for Other Revenue Other Financing Oil & Gas Taxes Service Sources DECEMBER EXPENDITURE: HISTORICAL TREND 150,000 125,000 100,000 75,000 50,000 25,000 ACTUAL "FY2022-23 a - d s s s FY 2021-22 9 & - A % / / / 9 & 6 / / & / s / % * 4 6 / - & / d - % - - / - - - - 01/18/2024 Page 2 of 47 & e 8 8 & 8 8 8 8 B 3 3 8 0 8 8 3 - DE 8 - & 0 6 8 8 3 3 8 5 : 8 8 0 8 o 9 A 8 G M a 8 a - - E f 9 8 a 8 8 8 9 - E a N - E 8 8 8 8 8 a N - m m & 3 3 1 A 6 - Lt E a I I 4 a a 3 I a - E a 1 * a R a e 3 a 8 E A e 8 5 - a 8 8 € 5 e 3 E 8 8 E 3 E & a E 8 6 3 8 8 8 # 9 9 E B 2 3 : 3 : - 3 8 3 1 8 E a A - o e S € 4 : 4 E 8 a E a E 3 : 9 9 - 0 € 3 5 E 9 2 8 9 5 3 0 E I 6 5 I a n I - o I 3 I E 8 E - 3 5 la € 5 - o le a a E o E 6 8 8 8 8 5 - 8 8 8 - V N 3 5 8 e - 8 3 3 - 8 6 3 a a 4E 5 B A 5 E de 3 5 a 8 8 8 a 8 8 s R 5 A 9 E a E 5 3 3 E 3 - 5 8 a E 8 a 3 a 3 a 5 8 3 a 8 B A 3 6 3 e - a 3 a - 8 8 E 8 3 R 5 B 9 3 B 3 a le e E 5 DD la i5 : 9 E > 8 E E S 0 - : 5 E N - I e 8 2 E y 0 De dB E a 6 6 e - a - df € E - 0 I - a 1 3 a e a E de E - E E e a E E E 3 5 - I € I a S I I 6 I e E l- - e 3 o I E a a W a E E 5 I E 8 a E 3 a e 8 E 3 5 Q - 3 d0 D 3 0 a la DE E de le E de la e E E S S N a e e 2 de la 3