Loading...
Information 05-15-2023Information City E Memorandum TO: Mayor and City Council From: Lori Stich, Finance Manager Date: May 15, 2023 Subject: April 2023 Monthly Financial Report This report is designed to provide summary information regarding the overall level of revenues and expenditures in the General Fund, the Multipurpose Facility Special Revenue Fund, and the Enterprise Funds. These funds provide an important picture of the city's financial health. For the month of April, actual revenues (excluding property taxes and transfers in) and expenditures should run about 33% of the annual budget. It is natural for some of the items to vary from month to month, such as exceeding budget for Supplies but being below budget for Services. This is not considered serious as long as the total expenditure budget amount is not overspent. Significant variances from budget are highlighted below accompanied with a general discussion for the variance. GENERAL FUND Revenues: ■ Property taxes, our largest revenue source, are received in July and December. ■ License & permit collections are about 22% of budget estimates consisting primarily of building -related permits, liquor licenses and rental licenses. ■ Charges for services are 46% of estimates with recreation fees and the Big Lake fire contract making up the majority of collections in April. ■ Transfers in consist of ERMU's 4% March monthly electric revenues received in April. The remaining transfers in will be recorded mid -year. Expenditures: ■ Total departmental expenditures are about 29% of budget and most departments are within or below budget estimates. 2023 Monthly Expenditures $25,000 $20,000 0 z < $15,000 O $10,000 $5, 000 $0 Jan TFeb Mar Apr May Jun � Actual $1,502 $2,819 $4,615 $6,010 Budget $1,708 $3,415 $5,123 $6,830 $8,538 $10,2 Jul I Aug I Sep I Oct I Nov I Dec $11,953I$13,660I$15,368I$17,075I$18,783I$20,490I MULTIPURPOSE FACILITY Through the end of April, expenditures of $571,534 exceed revenues of $564,069 by $7,465. The majority of March collections consist of ice and facility rentals while expenditures are primarily attributable to personal services and utilities. ATTACHMENTS ■ General Fund Revenue & Expense Report ■ Multipurpose Facility — Budget to Actual ■ Enterprise Funds — Budget to Actual ■ Cash Report — All Funds 5-10-2023 12:37 PM CITY OF ELK RIVER PAGE: 1 REVENUE &. EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2023 101-GENERAL FUND FINANCIAL SUMMARY 33.33% OF YEAR COMPLETED CURRENT CURRENT YEAR TO DATE o OF BUDGET PRIOR FY BUDGET PERIOD ACTUAL BUDGET BALANCE YID BALANCE REVENUE SUMMARY General Fund 20,490,000.00 266,196.31 1,228,318.95 5.99 19,261,681.05 1,306,664.17 TOTAL REVENUES 20,490,000.00 266,196.31 1,228,318.95 5.99 19,261,681.05 1,306,664.17 EXPENDITURE SUMMARY General Government City Council 203,750.00 5,954.97 61,276.78 30.07 142,473.22 49,509.58 Communications 451,550.00 31,690.78 129,871.66 28.76 321,678.34 105,906.56 Administrative Services 677,500.00 51,189.46 208,776.00 30.82 468,724.00 176,534.52 Human Resources 402,500.00 24,123.40 119,627.17 29.72 282,872.83 109,936.94 Elections 6,600.00 0.00 6,213.68 94.15 386.32 6,406.00 Finance 717,950.00 39,838.01 265,282.03 36.95 452,667.97 261,481.52 Information Technology 614,450.00 45,497.65 199,430.05 32.46 415,019.95 155,442.89 Legal 275,000.00 22,582.65 67,323.88 24.48 207,676.12 59,939.35 Community Development 0.00 14,066.77 90,379.93 0.00 ( 90,379.93) 84,583.52 Planning 486,250.00 19,780.68 76,345.70 15.70 409,904.30 115,641.50 Building Maintenance 1,029,550.00 71,323.02 308,486.58 29.96 721,063.42 254,129.05 TOTAL General Government 4,865,100.00 326,047.39 1,533,013.46 31.51 3,332,086.54 1,379,511.43 Public Safety Police Administration 1,120,850.00 65,168.62 446,153.15 39.80 674,696.85 381,385.16 Patrol 3,877,900.00 236,432.15 1,095,117.49 28.24 2,782,782.51 978,338.31 Investigations 1,373,150.00 95,157.41 386,450.88 28.14 986,699.12 378,858.14 Police Support Services 829,100.00 50,411.61 201,276.41 24.28 627,823.59 246,639.34 Police Reserves 16,250.00 61.19 1,551.19 9.55 14,698.81 2,787.98 Public safety building 201,100.00 20,337.77 53,607.05 26.66 147,492.95 54,542.50 Fire Administration 1,212,650.00 76,015.76 327,473.64 27.00 885,176.36 272,391.44 Fire Operations 596,300.00 83,669.41 212,118.66 35.57 384,181.34 162,536.93 Emergency Management 33,750.00 5,190.41 6,293.40 18.65 27,456.60 5,930.05 Building Safety 583,600.00 41,832.57 176,939.04 30.32 406,660.96 172,289.39 Code Enforcement 117,500.00 8,213.94 34,650.29 29.49 82,849.71 27,755.10 Environmental 99,650.00 8,046.87 29,728.94 29.83 69,921.06 19,918.33 TOTAL Public Safety 10,061,800.00 690,537.71 2,971,360.14 29.53 7,090,439.86 2,703,372.67 Public Works Street Maintenance 1,567,000.00 111,616.21 425,618.15 27.16 1,141,381.85 364,161.01 Snow Removal 360,000.00 31,348.46 233,219.21 64.78 126,780.79 212,970.49 Equipment Services 386,300.00 28,251.92 99,374.56 25.72 286,925.44 107,806.26 Engineering 458,200.00 35,578.63 145,977.04 31.86 312,.222.96 126,5.26.20 TOTAL Public Works 2,771,500.00 206,795.22 904,188.96 32.62 1,867,311.04 811,463.96 5-10-2023 12:37 PM CITY OF ELK RIVER PAGE: 2 REVENUE &. EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2023 101-GENERAL FUND FINANCIAL SUMMARY Culture & Recreation Parks Department Parks & Rec Admin Recreation Programs Farmers Market Sr Citizen Programs TOTAL Culture & Recreation Economic Development Economic Development Energy City TOTAL Economic Development General TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 33.33% OF YEAR COMPLETED CURRENT CURRENT YEAR TO DATE o OF BUDGET PRIOR FY BUDGET PERIOD ACTUAL BUDGET BALANCE YID BALANCE 1,676,300.00 92,233.04 310,491.68 18.52 1,365,808.32 380,598.75 710,900.00 41,620.14 174,743.90 24.58 536,156.10 197,389.91 197,750.00 1,496.50 26,050.98 13.17 171,699.02 16,459.29 8,750.00 97.33 762.73 8.72 7,987.27 478.49 149,900.00 11,696.09 51,669.35 34.47 98,230.65 39,982.40 2,743,600.00 147,143.10 563,718.64 20.55 2,179,881.36 634,908.84 0.00 ( 363.25) 29,413.70 0.00 ( 29,413.70) 23,209.99 48,000.00 2,023.88 8,100.44 16.88 39,899.56 6,984.12 48,000.00 1,660.63 37,514.14 78.15 10,485.86 30,194.11 20,490,000.00 1,372,184.05 6,009,795.34 29.33 14,480,204.66 5,559,451.01 0.00 ( 1,105,987.74)( 4,781,476.39) 4,781,476.39 ( 4,252,786.84) 5-10-2023 12:37 PM CITY OF ELK RIVER PAGE: 3 REVENUE &. EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2023 101-GENERAL FUND 33.33% OF YEAR COMPLETED CURRENT CURRENT YEAR TO DATE o OF BUDGET PRIOR FY REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE YID BALANCE General Fund faxes 101-3-0000-3111 Current Ad Valorem Taxes 101-3-0000-3121 Gravel Tax TOTAL Taxes Licenses & Permits 101-3-0000-3211 Liquor License 101-3-0000-3212 THC License 101-3-0000-3213 Cigarette License 101-3-0000-3214 Rental License 101-3-0000-3216 Mining License 101-3-0000-3217 Garbage Hauler License 101-3-0000-3218 Other Business License/Permit 101-3-0000-3229 NPDES Permit 101-3-0000-3231 Building Permit 101-3-0000-3232 Plumbing/Heating Permit 101-3-0000-3.233 Permit Surcharge 101-3-0000-3235 Animal License 101-3-0000-3237 Other Non -Business Lic/Permit TOTAL Licenses & Permits Intergovernmental Rev 101-3-0000-3311 Federal Grant 101-3-0000-3322 MV Credit 101-3-0000-3323 Fire State Aid 101-3-0000-3325 Police 20 Aid 101-3-0000-3326 Police Training Reimb 101-3-0000-3329 State Crime Prevention Grant TOTAL Intergovernmental Rev Charges for Services 101-3-0000-3412 Planning & Zoning Fees 101-3-0000-3413 Plan Check Fee 101-3-0000-3415 Special Assessment Search 101-3-0000-3417 Copies 101-3-0000-3418 Other General Govt Services 101-3-0000-3430 Lockout Fees 101-3-0000-3431 Police Services 101-3-0000-3432 School Liaison 101-3-0000-3434 Animal Impound Fee 101-3-0000-3436 Fire Contracts 101-3-0000-3437 Fire Services 101-3-0000-3451 Street Services 101-3-0000-3452 Engineering Services Reimb 101-3-0000-3461 Recreation Fees 13,893,000.00 0.00 0.00 0.00 13,893,000.00 0.00 225,000.00 8,943.23 8,943.23 3.97 216,056.77 17,760.97 14,118,000.00 8,943.23 8,943.23 0.06 14,109,056.77 17,760.97 82,000.00 21,100.00 21,620.00 26.37 60,380.00 20,240.00 4,000.00 400.00 1,600.00 4.0.00 2,400.00 0.00 4,000.00 150.00 300.00 7.50 3,700.00 100.00 65,000.00 9,310.00 29,550.00 45.46 35,450.00 30,335.00 26,000.00 0.00 0.00 0.00 26,000.00 0.00 2,500.00 0.00 765.00 30.60 1,735.00 125.00 16,000.00 620.00 6,460.00 40.38 9,540.00 4,525.00 24,000.00 ( 2,450.00)( 2,275.00) 9.48- 26,275.00 5,600.00 600,000.00 ( 6,071.75) 121,178.05 20.20 478,821.95 200,385.50 160,000.00 6,443.15 38,800.92 24.25 121,199.08 74,998.42 800.00 ( 2,813.17) 817.64 102.21 ( 17.64) 5,417.65 0.00 0.00 560.00 0.00 ( 560.00) 360.00 20,000.00 1,040.00 3,640.00 18.20 16,360.00 8,875.00 1,004,300.00 27,728.23 223,016.61 22.21 781,283.39 350,961.57 0.00 0.00 308.70 0.00 ( 308.70) 0.00 6,000.00 0.00 0.00 0.00 6,000.00 0.00 225,000.00 0.00 4,000.00 1.78 221,000.00 3,000.00 320,000.00 0.00 0.00 0.00 320,000.00 0.00 35,000.00 0.00 0.00 0.00 35,000.00 0.00 48,000.00 0.00 0.00 0.00 48,000.00 0.00 634,000.00 0.00 4,308.70 0.68 629,691.30 3,000.00 25,000.00 2,629.00 7,991.50 31.97 17,008.50 10,352.50 250,000.00 6,106.95 72,604.51 29.04 177,395.49 111,223.19 500.00 0.00 30.00 6.00 470.00 180.00 1,500.00 47.80 328.93 21.93 1,171.07 406.98 0.00 0.00 0.00 0.00 0.00 13.00 3,500.00 140.00 1,020.00 29.14 2,480.00 885.00 30,000.00 7,025.06 18,575.06 61.92 11,424.94 8,270.00 175,000.00 0.00 82,810.50 47.32 92,189.50 86,089.09 500.00 0.00 300.00 60.00 200.00 325.00 400,000.00 45,504.39 238,139.39 59.53 161,860.61 208,781.61 3,000.00 0.00 ( 300.00) 10.00- 3,300.00 0.00 30,000.00 2,960.00 5,170.00 17.23 24,830.00 8,221.67 20,000.00 0.00 0.00 0.00 20,000.00 3,751.20 60,000.00 15,929.25 27,204.25 45.34 32,795.75 24,105.00 5-10-2023 12:37 PM CITY OF ELK RIVER PAGE: 4 REVENUE &. EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2023 101-GENERAL FUND REVENUES 101-3-0000-3462 Sr Center Activities 101-3-0000-3463 Farmer's Market 101-3-0000-3469 Elk RiverFest 101-3-0000-3472 Park Use Fee 101-3-0000-3483 Sewer Inspection Fee 101-3-0000-3484 Contractor License Check TOTAL Charges for Services 101-3-0000-3510 Court Fines 101-3-0000-3512 Ordinance Violations TOTAL Fines & Forfeits Special Assessments 101-3-0000-3610 Special Assmts-County TOTAL Special Assessments Other Revenue 101-3-0000-3621 Interest Income 101-3-0000-3625 Refunds & Reimbursements 101-3-0000-3626 Contributions 101-3-0000-3629 Miscellaneous Revenue TOTAL Other Revenue Other Financing Sources Transfers In 101-3-0000-3921 Transfers 101-3-0000-3926 Transfer -Capital Outlay Resery 101-3-0000-3942 Transfer-WWTS 101-3-0000-3943 Transfer -Liquor 101-3-0000-3944 Transfer -Garbage 101-3-0000-3945 Transfer -Utilities 101-3-0000-3946 Transfer-Stormwater 101-3-0000-3948 Transfer-EDA 101-3-0000-3949 Transfer-HRA TOTAL Transfers In TOTAL General Fund CURRENT CURRENT BUDGET PERIOD 37,000.00 2,721.78 20,000.00 520.00 20,000.00 1,400.00 35,000.00 4,570.00 15,000.00 715.00 1,200.00 ( 55.00) 1,127,200.00 90,214.23 33.33% OF YEAR COMPLETED YEAR TO DATE o OF BUDGET PRIOR FY ACTUAL BUDGET BALANCE YID BALANCE 18,790.70 50.79 18,209.30 14,806.00 20,280.00 101.40 ( 280.00) 19,360.00 2,900.00 14.50 17,100.00 7,800.00 16,718.54 47.77 18,281.46 7,688.32 1,360.00 9.07 13,640.00 3,400.00 35.00 2.92 1,165.00 280.00 513,958.38 45.60 613,241.62 515,938.56 130,000.00 15,639.28 39,014.31 30.01 90,985.69 35,137.29 0.00 0.00 1,600.00 0.00 ( 1,600.00) 2,000.00 130,000.00 15,639.28 40,614.31 31.24 89,385.69 37,137.29 0.00 0.00 ( 190.33) 0.00 190.33 0.00 0.00 0.00 ( 190.33) 0.00 190.33 0.00 120,000.00 0.00 36,277.77 30.23 83,722.23 33,629.01 125,000.00 ( 598.91)( 1,543.58) 1.23- 126,543.58 9,470.00 20,000.00 0.00 39,760.00 198.80 ( 19,760.00) 25,150.00 10,000.00 115.20 2,52.2.91 25.23 7,477.09 4,254.69 275,000.00 ( 483.71) 77,017.10 28.01 197,982.90 72,503.70 300,000.00 0.00 748.69 0.25 299,251.31 1,656.17 78,500.00 0.00 0.00 0.00 78,500.00 0.00 170,000.00 0.00 0.00 0.00 170,000.00 0.00 1,000,000.00 0.00 0.00 0.00 1,000,000.00 0.00 56,500.00 0.00 0.00 0.00 56,500.00 0.00 1,380,000.00 124,155.05 359,902.26 26.08 1,020,097.74 307,705.91 135,000.00 0.00 0.00 0.00 135,000.00 0.00 45,000.00 0.00 0.00 0.00 45,000.00 0.00 36,500.00 0.00 0.00 0.00 36,500.00 0.00 3,201,500.00 124,155.05 360,650.95 11.27 2,840,849.05 309,362.08 20,490,000.00 266,196.31 1,228,318.95 5.99 19,261,681.05 1,306,664.17 TOTAL REVENUE 20,490,000.00 266,196.31 1,228,318.95 5.99 19,261,681.05 1,306,664.17 CITY OF ELK RIVER MULTIPURPOSE FACILITY - BUDGET TO ACTUAL MONTH ENDED APRIL, 2023 Current Year to Date % of Budget Actual Budget Revenues: Ice Rental $830,000 $270,834 32.63% Admissions 40,000 18,527 46.32% Dry Floor Events/Craft Shows 5,000 4,045 80.90% Facility Rental 238,100 70,460 29.59% Advertising/Naming Rights/Sponsorships 168,000 6,300 3.75% Recreation fees (Skating/Hockey) 175,000 116,416 66.52% Concessions/vending 110,000 73,650 66.95% Other Revenues (interest, etc.) 13,900 3,837 27.60% Use of Fund Balance 100,350 0 0.00% Total Revenues $1,680,350 $564,069 33.57% Operating expenses: Personal services $917,800 $336,439 36.66% Supplies 102,850 62,870 61.13% Other service charges 457,700 172,225 37.63% Capital Outlay 202,000 0 0.00% Total Expenditures $1,680,350 $571,534 34.01% Revenues over/(under) expenditures $0 ($7,465) FTCenter April 2023 $1,800,000 Budget, $1,680,350 Budget, $1,680,350 $1, 600,000 $1,400,000 $1, 200,000 $1,000,000 $800,000 Actual Actual $600,000 $564,069 $571,534 $400,000 $200,000 $0 Total Revenues Total Expenditures w W Y J W LL O 7 J Q D F U Q O F w W 0 D 00 N 0 z D LL W a w z W J_ a Q 0 W 0 z W F z O m 0 0 o o o o 0 0 o 0 o 0 (O 00 O 0) O N O In In r 0 N O M N V r O 00 It Cl) O r (O N rn 00 O O 00 0 r r e N N Cl) In Cl) Cl) LO 00 m M L N 01 01 V N ' V In ' Cl) d) ' d) N ' N ' ' N fO R 0 R O (O N V 0) It Cl) (O Cl) 00 r- In N (O N (O ?r 7 r-rl V o0 01 In r- rlM M M y0 U r r r O O O L R Q } V) 0' ' 0 ' 0 0 0 0 O 0' 0 O ' O O O' O C y O O O O In O O O In O In W In In O O 0 W 0 O V O W In 0 W O In ` O 0 (O In N N O 0 r N r 0 r 'O N N V r N N N M In w (O (O V (O M Um ER 0 ' 0 0 0 0 0 0 0 ' 0 0 0 O) O r (O 00 O N (O r V N 0) O (M 00 N (M N N 0 (M a� O O e V V 0) N Cl) Cl) a) N N a) O N m N N N N N Cl) V V co w O r ' r � (O 0 ' (O It It In ' In ' ' In N R D R It 00 0) N O (O 00 O In In 0) V 00 0 L L 00 N Gi M M f6 Q V r V r — V V W V w w w L f6 Q 0' ' 0 O O O ' 0 O 0' 0 O ' O O ' ' O C y O O O In O In O V V V O O M rl O N O O O N N N O r O r ` 'O In In In (M In V O r r 00 (O N N V N O r 1n 1n N O O U ro o o o o 0 0 0 0 0 0 0 0 0 0 0 0 0 w "O OI 00 N (O O1 (M N CO M r O O1 0 0 CO N In 00 0) O O 0 a) N 0 In O V O a) r o cr)r)c 0m00 n r7. 0) 0) 1-0 of m N N N Cl) N N Cl) In N N In N r 0) 0) � 0) (O It ' 0 a) (M M a) V M O O r R O R N Cl) N r- r r It 00 01 O N N 0 r (O M � 0 O O 00 'It O M In Cl) a 00 w O O O L d) d) 00 N r N r 0) 00 00 It N In O N 3 y0 (� O M (O ,It In 0) N (O N N r r In Cl) M O 1-00 N MCO V N 00 N w Q � ER 0000 00000 O O O O O O O O C y 0000 O O O 0ln00ln O 0 0 0 l n O rO M M Olnln O O O 00 01 V O O O V 00 O O O V ` 'O O O N r In M (0 In Cl) 00 It O 0 00 00 O 00 O o0 r 00 r O r r V (O O Cl) (O N Cl) j 7 In (D o0 Cl) 00 (0 (0 0 O �l� V3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 „ O) p OI 00 (O V In O N_ V N_ V Cl) 0 In In O 0) M V (O N' (O N a 0 (O (O o M (O e In O 00 r r Cl) (O (O O 0) w d) d) M O G m Cl) Cl) It Cl) Cl) Cl) N N N N O a) (Oro ' 0rO ' r V o0 ' 00 N ' N O ' N L R 0 R 0) Cl) N 00 (O V It(M V (O In Cl) (O 0 N r 00 a) (O a) (O 1n a) 1n In V N Cl) 0 00 00 01 (M (M 00 r- M 00 M d) d) M M N y0 V ln V o 0 0) M V LO N � J 00o "oo 00000 O 0-0 O o O o o y o N n 00 O 0 0 In O O In (O (O O In O r-V O O O O O O V O O (C O O O (O 'O Cl) d) 01 r 01 M (O (O M Cl) N In 0) � W N w O O 0 w O 0 w O Cl) M O M o� j 7 U ro o0 0) (D(O c o0 O (M In Cl) — V O IO y y R � C otf a m x y 4: y O N 0 Q' y w o x X N C y 0 r m y O V w> C w C m 0 y y C O N y y d O O - R N `5 N R C y 0) y y a Q y wt7 0) � �.- O) a)y _ � >. y y w U j N w y 0 y y R Q w O > (` w o Q w Q C C o co O O R d a> O O ` 0) >. 0) X N U O 0) C C O Q C _ y y '-' 'O N OI R 0) O OI N z O R w OI R .� N C `w O O O 0 N 00 O >. o R `o a m �.� m o w w m o o y U a w a Q�o� N Q Q Qacn R Q u w M 0 RU) O o=_ o 2 �m0 y O 0 0 z-- r_ UH z - 5-10-2023 02:58 PM CITY OF ELK RIVER PAGE: 1 POOLED CASH REPORT (FUND 999) AS OF: APRIL 30TH, 2023 FUND ACCOUNT# ACCOUNT NAME CLAIM ON CASH BEGINNING BALANCE CURRENT CURRENT ACTIVITY BALANCE 002-1010 Cash - Section 125 1,430.06 1,600.66 3,030.72 101-1010 Cash - General Fund 5,084,096.69 ( 1,137,496.44) 3,946,600.25 211-1010 Cash - Library 251,633.95 ( 7,437.85) 244,196.10 219-1010 Cash. - Federal COVID Fund 2,161,612.90 8,701.12 2,170,314.02 221-1010 Cash - Multipurpose Facility 182,553.04 ( 73,436.82) 109,116.22 225-1010 Cash - Park Dedication 1,810,638.70 ( 102,620.56) 1,708,018.14 228-1010 Cash - Landfill 182,058.73 6,940.36 188,999.09 231-1010 Cash.- Landfill Const Debris 827,461.22 0.00 827,461.22 240-1010 Cash - Micro Loan Fund 978,673.48 0.00 978,673.48 242-1010 Cash - State DEED 407,188.69 2,642.66 409,831.35 245-1010 Cash - Development Fund 997,478.80 0.00 997,478.80 290-1010 Cash.- Capital Outlay :Reserve 1,805,437.86 ( 1,0.26.23) 1,804,411.63 291-1010 Cash - Insurance Reserve 14,242.74 ( 1,670.54) 12,572.20 292-1010 Cash - Govt Bldgs Reserve 4,718,058.30 119,885.46 4,837,943.76 294-1010 Cash - Drug Forfeiture 40,268.73 ( 22,799.00) 17,469.73 295-1010 Cash. - Severance Pay Reserve ( 8,396.40) 0.00 ( 8,396.40) 296-1010 Cash - GRE Reserve 816,666.63 0.00 816,666.63 301-1010 Cash - 2020A GO CIP Bonds ( 451,217.13) 0.00 ( 451,217.13) 302-1010 Cash - 2021A GO CIP BONDS ( 302,579.06) 0.00 ( 302,579.06) 333-1010 Cash. - 20.20B (2010/2012) Bonds 208,646.60 0.00 208,646.60 343-1010 Cash - 2019A Sales Tax Bonds 5,754,478.3.2 271,843.98 6,026,322.30 401-1010 Cash - Pavement Mgmt. 7,231,910.87 197,127.52 7,429,038.39 403-1010 Cash - Street Improvement 545,533.62 23,980.02 569,513.64 406-1010 Cash.- City Wide Trunk Util 2,725,544.98 ( 18,219.50) 2,707,325.48 410-1010 Cash - Equipment Replacement 1,837,119.22 ( 46,366.88) 1,790,752.34 420-1010 Cash - Active ER 1,208,071.66 2,783.02 1,210,854.68 421-1010 Cash - PS Building/Fire Sta 3 1,209,937.42 ( 344.28) 1,209,593.14 440-1010 Cash. - Park Improvement 156,767.28 797.26 157,564.54 463-1010 Cash - TIF 423 Prof Powder 7,728.12 0.00 7,728.12 465-1010 Cash - TIF 25 Jackson Hills 10,918.37 0.00 10,918.37 602-1010 Cash - Wastewater Treatment 9,138,034.63 ( 23,004.27) 9,115,030.36 603-1010 Cash. - Liquor 4,619,901.03 7,770.15 4,627,671.18 605-1010 Cash - Garbage 771,701.64 19,080.29 790,781.93 607-1010 Cash - Storm Water 1,849,411.39 58,161.55 1,907,572.94 801-1010 Cash - Interest 81,583.89 64,996.69 146,580.58 821-1010 Cash.- Developer Escrow 712,442.33 74,872.00 787,314.33 TOTAL CLAIM ON CASH 57,587,039.30 ( 573,239.63) 57,013,799.67 CASH IN BANK - POOLED CASH 999-1000 A/P BANK ACCOUNTS 196,167,082.53 730,734.81 196,897,817.34 999-1001 PY BANK ACCOUNT (166,939,082.81)( 1,311,377.56)(168,250,460.37) 999-1002 POOLED INVESTMENTS 28,382,189.56 0.00 28,382,189.56 SUBTOTAL CASH IN BANK - POOLED CASH 57,610,189.28 ( 580,642.75) 57,029,546.53