Loading...
Information 12-20-2021Information City E Memorandum TO: Mayor and City Council From: Lori Stich, Assistant Finance Director Date: December 20, 2021 Subject: November 2021 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 November, actual revenues (excluding property taxes and transfers in) and expenditures should run about 92% 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: ■ The second half property taxes will be received in December. ■ License & permit collections are at 125% of budget with collections for November consisting primarily of building -related permits along with business license renewals. Building -related permit revenues exceed budget by $190,366. ■ Intergovernmental revenues remain at about 95% of budget estimates. ■ Charges for services are at 109% of the estimated budget amount with collections for November consisting mainly of planning fees. ■ Fines and forfeits, which lag a month for collections, are running about 92% of budget. ■ Transfers in consists of ERMU's 4% October electric revenues. Expenditures: ■ Total departmental expenditures are about 85% of budget and most departments are within or below budget estimates. 2021 Monthly Expenditures $ 20, 000 $18,000 $16,000 p $14,000 z $12,000 _ $10,000 ~ $8,000 $6,000 $4,000 $2,000 $0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Actual $1,240 $2,094 $3,408 $5,009 $6,224 $7,743 $9,036 $10,360 $11,686 $13,615 $14,903 Budget $1,461 $2,922 $4,383 $5,844 $7,305 $8,766 $10,227 $11,688 $13,149 $14,610 $16,071 $17,533 MULTIPURPOSE FACILITY Through the end of November, expenditures of $1,096,066 exceed revenues of $843,563 by $252,503. The majority of November collections consist of ice rentals and facility rentals. ATTACHMENTS ■ General Fund Revenue & Expense Report ■ Multipurpose Facility Revenue & Expense Report ■ Enterprise Funds - Budget to Actual ■ Cash Report - All Funds 12-14-2021 03:43 PM CITY OF ELK RIVER PAGE: 1 REVENUE &. EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2021 101-GENERAL FUND FINANCIAL SUMMARY 91.67% OF YEAR COMPLETED CURRENT CURRENT YEAR TO DATE o OF BUDGET PRIOR FY BUDGET PERIOD ACTUAL BUDGET BALANCE YID BALANCE REVENUE SUMMARY General Fund 17,532,500.00 211,831.62 11,561,540.57 65.94 5,970,959.43 10,747,589.06 TOTAL REVENUES 17,532,500.00 211,831.62 11,561,540.57 65.94 5,970,959.43 10,747,589.06 EXPENDITURE SUMMARY General Government City Council 173,200.00 3,576.71 154,879.57 89.42 18,3.20.43 134,418.67 Communications 336,000.00 31,908.58 291,560.13 86.77 44,439.87 249,167.62 Administrative Services 593,150.00 54,700.55 534,086.53 90.04 59,063.47 505,902.74 Human Resources 355,750.00 20,499.39 292,286.75 82.16 63,463.25 255,483.04 Elections 6,800.00 0.00 6,300.00 92.65 500.00 72,929.38 Finance 655,800.00 35,395.87 565,721.74 86.26 90,078.26 537,908.02 Information Technology 489,800.00 37,680.18 397,189.93 81.09 92,610.07 427,510.80 Legal 255,000.00 22,834.69 201,950.99 79.20 53,049.01 179,862.29 Community Development 209,500.00 13,524.57 189,193.13 90.31 20,306.87 188,329.58 Planning 364,150.00 28,445.81 324,341.30 89.07 39,808.70 310,19.2.78 Building Maintenance 788,500.00 67,614.92 722,314.61 91.61 66,185.39 672,338.09 TOTAL General Government 4,227,650.00 316,181.27 3,679,824.68 87.04 547,825.32 3,534,043.01 Public Safety Police Administration 925,200.00 50,460.05 886,320.62 95.80 38,879.38 782,153.97 Patrol 3,274,300.00 237,562.83 2,607,971.82 79.65 666,328.18 2,379,407.34 Investigations 1,238,700.00 93,462.68 999,854.71 80.72 238,845.29 886,161.79 Police Support Services 834,550.00 57,225.94 626,264.36 75.04 208,285.64 616,933.63 Police Reserves 16,750.00 707.15 3,734.71 22.30 13,015.29 4,508.87 Public safety building 160,600.00 37,569.04 155,983.98 97.13 4,616.02 130,842.93 Fire Administration 981,700.00 58,734.69 945,097.17 96.27 36,602.83 742,397.80 Fire Operations 422,200.00 28,372.61 367,346.43 87.01 54,853.57 354,723.52 Emergency Management 62,700.00 891.98 19,510.95 31.12 43,189.05 24,720.01 Building Safety 531,850.00 35,063.41 435,765.55 81.93 96,084.45 450,215.60 Code Enforcement 86,300.00 6,593.02 76,236.00 88.34 10,064.00 71,430.89 Environmental 58,300.00 4,429.43 51,068.42 87.60 7,231.58 48,940.23 TOTAL Public Safety 8,593,150.00 611,072.83 7,175,154.72 83.50 1,417,995.28 6,492,436.58 Public Works Street Maintenance 1,462,850.00 110,608.34 1,272,706.75 87.00 190,143.25 1,250,723.95 Snow Removal 345,800.00 25,015.12 248,031.07 71.73 97,768.93 228,104.37 Equipment Services 254,050.00 21,722.84 216,469.14 85.21 37,580.86 199,770.69 Engineering 492,800.00 30,317.15 351,454.81 71.32 141,345.19 293,461.10 TOTAL Public Works 2,555,500.00 187,663.45 2,088,661.77 81.73 466,838.23 1,972,060.11 12-14-2021 03:43 PM CITY OF ELK RIVER PAGE: 2 REVENUE &. EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2021 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 91.67% OF YEAR COMPLETED CURRENT CURRENT YEAR TO DATE o OF BUDGET PRIOR FY BUDGET PERIOD ACTUAL BUDGET BALANCE YID BALANCE 1,307,700.00 102,186.30 1,206,929.88 92.29 100,770.12 1,026,141.47 553,850.00 44,448.95 476,032.96 85.95 77,817.04 532,418.73 122,700.00 1,03.2.81 8.2,395.27 67.15 40,304.73 72,208.15 8,750.00 1,005.71 15,773.40 180.27 ( 7,023.40) 8,546.67 129,300.00 10,618.09 116,847.10 90.37 12,452.90 137,866.68 2,122,300.00 159,291.86 1,897,978.61 89.43 224,321.39 1,777,181.70 0.00 13,097.89 40,475.98 0.00 ( 40,475.98) 33,701.96 33,900.00 1,714.51 21,404.19 63.14 12,495.81 20,073.45 33,900.00 14,812.40 61,880.17 182.54 ( 27,980.17) 53,775.41 17,532,500.00 1,289,021.81 14,903,499.95 85.00 2,629,000.05 13,829,496.81 0.00 ( 1,077,190.19)( 3,341,959.38) 3,341,959.38 ( 3,081,907.75) 12-14-2021 03:43 PM CITY OF ELK RIVER PAGE: 3 REVENUE &. EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2021 101-GENERAL FUND 91.67% 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 12,315,000.00 0.00 6,468,789.85 52.53 5,846,210.15 5,978,653.37 101-3-0000-3112 Delinquent Ad Valorem Taxes 0.00 0.00 31,598.70 0.00 ( 31,598.70) 35,310.99 101-3-0000-3121 Gravel Tax 150,000.00 0.00 178,540.54 119.03 ( 28,540.54) 142,489.54 101-3-0000-3131 Penalties/Interest 0.00 0.00 2,622.32 0.00 ( 2,622.32) 965.31 TOTAL Taxes 12,465,000.00 0.00 6, 681, 551. 41 53.60 5,783,448.59 6, 157, 419.21 Licenses & Permits 101-3-0000-3211 Liquor License 76,000.00 5,365.00 70,795.00 93.15 5,205.00 18,298.66 101-3-0000-3213 Cigarette License 3,000.00 2,700.00 4,161.25 138.71 ( 1,161.25) 2,450.00 101-3-0000-3214 Rental License 65,000.00 1,950.00 58,533.00 90.05 6,467.00 48,963.00 101-3-0000-3216 Mining License 25,000.00 0.00 25,849.37 103.40 ( 849.37) 25,760.95 101-3-0000-3217 Garbage Hauler License 2,000.00 0.00 420.00 21.00 1,580.00 485.00 101-3-0000-3218 Other Business License/Permit 15,000.00 4,415.00 14,630.00 97.53 370.00 16,175.00 101-3-0000-3229 NPDES Permit 20,000.00 1,400.00 23,100.00 115.50 ( 3,100.00) 19,803.25 101-3-0000-3231 Building Permit 450,000.00 24,307.70 567,602.39 126.13 ( 117,602.39) 383,588.15 101-3-0000-3.232 Plumbing/Heating Permit 110,000.00 15,282.92 182,763.46 166.15 ( 72,763.46) 91,215.58 101-3-0000-3233 Permit Surcharge 500.00 ( 366.14) 2,553.51 510.70 ( 2,053.51) 7,908.49 101-3-0000-3235 Animal License 0.00 100.00 450.00 0.00 ( 450.00) 515.00 101-3-0000-3237 Other Non -Business Lic/Permit 12,000.00 1,200.00 23,700.00 197.50 ( 11,700.00) 21,177.50 TOTAL Licenses & Permits 778,500.00 56,354.48 974,557.98 125.18 ( 196,057.98) 636,340.58 Intergovernmental Rev 101-3-0000-3322 MV Credit 5,500.00 0.00 2,877.79 52.3.2 2,6.22.21 3,092.55 101-3-0000-3323 Fire State Aid 200,000.00 0.00 218,908.66 109.45 ( 18,908.66) 207,496.42 101-3-0000-3325 Police 20 Aid 305,000.00 0.00 276,543.13 90.67 28,456.87 310,309.06 101-3-0000-3326 Police Training Reimb 32,000.00 0.00 38,002.19 118.76 ( 6,002.19) 29,168.23 101-3-0000-3329 State Crime Prevention Grant 60,000.00 0.00 33,524.37 55.87 26,475.63 33,852.73 101-3-0000-3330 Other State Grants 0.00 0.00 0.00 0.00 0.00 11,570.11 TOTAL Intergovernmental Rev 602,500.00 0.00 569,856.14 94.58 32,643.86 595,489.10 Charges for Services 101-3-0000-3412 Planning & Zoning Fees 25,000.00 1,875.00 32,738.00 130.95 ( 7,738.00) 18,366.69 101-3-0000-3413 Plan Check Fee 220,000.00 11,518.55 270,435.63 122.93 ( 50,435.63) 169,494.19 101-3-0000-3415 Special Assessment Search 500.00 60.00 1,220.00 244.00 ( 720.00) 600.00 101-3-0000-3417 Copies 1,500.00 91.00 1,389.84 92.66 110.16 1,357.08 101-3-0000-3418 Other General Govt Services 500.00 0.00 0.00 0.00 500.00 52.00 101-3-0000-3430 Lockout Fees 5,500.00 320.00 3,500.00 63.64 2,000.00 4,165.00 101-3-0000-3431 Police Services 15,000.00 ( 80.00) 50,133.53 334.22 ( 35,133.53) 11,253.41 101-3-0000-3432 School Liaison 151,000.00 0.00 155,077.50 102.70 ( 4,077.50) 147,072.00 101-3-0000-3434 Animal Impound Fee 2,500.00 0.00 250.00 10.00 2,250.00 850.00 101-3-0000-3436 Fire Contracts 286,000.00 0.00 289,661.96 101.28 ( 3,661.96) 280,007.80 101-3-0000-3437 Fire Services 6,000.00 0.00 0.00 0.00 6,000.00 6,137.50 101-3-0000-3451 Street Services 25,000.00 1,785.00 21,070.66 84.28 3,9.29.34 14,894.33 101-3-0000-3452 Engineering Services Reimb 25,000.00 0.00 14,793.17 59.17 10,206.83 18,371.57 12-14-2021 03:43 PM CITY OF ELK RIVER PAGE: 4 REVENUE &. EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2021 101-GENERAL FUND 91.67% OF YEAR COMPLETED CURRENT CURRENT YEAR TO DATE o OF BUDGET PRIOR FY REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE YID BALANCE 101-3-0000-3461 Recreation Fees 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 Fines & Forfeits 101-3-0000-3510 Court Fines 101-3-0000-3511 Parking Fines 101-3-0000-3512 Ordinance Violations TOTAL Fines & Forfeits Special Assessments 60,000.00 30,000.00 12,000.00 10,000.00 20,000.00 12,000.00 1,000.00 908,500.00 120,000.00 0.00 0.00 120,000.00 842.00 31,495.00 52.49 28,505.00 13,651.00 4,438.00 29,830.00 99.43 170.00 8,117.00 0.00 21,792.01 181.60 ( 9,792.01) 11,964.00 200.00 20,422.00 204.22 ( 10,422.00) 500.00 5,925.00 27,127.79 135.64 ( 7,127.79) 22,711.99 1,495.00 17,125.00 142.71 ( 5,125.00) 16,245.00 80.00 1,205.00 120.50 ( 205.00) 1,070.00 28,549.55 989,267.09 108.89 ( 80,767.09) 746,880.56 8,068.41 108,867.34 0.00 0.00 0.00 2,000.00 8,068.41 110,867..34 90.72 11,132.66 76,486.31 0.00 0.00 150.00 0.00 ( 2,000.00) 1,100.00 92.39 9,132.66 77,736.31 Other Revenue 101-3-0000-3621 Interest Income 75,000.00 0.00 89,443.24 119.26 ( 14,443.24) 105,973.51 101-3-0000-3625 Refunds & Reimbursements 130,000.00 0.00 20,412.10 15.70 109,587.90 ( 2,511.32) 101-3-0000-3626 Contributions 25,000.00 0.00 19,000.00 76.00 6,000.00 0.00 101-3-0000-3629 Miscellaneous Revenue 6,500.00 2,552.31 16,767.74 257.97 ( 10,267.74) 12,673.87 TOTAL Other Revenue 236,500.00 2,552.31 145,623.08 61.57 90,876.92 116,136.06 Transfers In 101-3-0000-3921 Transfers 101-3-0000-3924 Transfer - MIT 101-3-0000-3930 Transfer -Development 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 0.00 140,000.00 10,600.00 160,000.00 500,000.00 52,000.00 1,355,000.00 121,000.00 41,000.00 41,900.00 2,421,500.00 0.00 460.00 0.00 0.00 0.00 0.00 0.00 10,600.00 100.00 0.00 160,000.00 100.00 0.00 500,000.00 100.00 0.00 52,000.00 100.00 116,306.87 1,162,857.53 85.82 0.00 121,000.00 100.00 0.00 41,000.00 100.00 0.00 41,900.00 100.00 116,306.87 2,089,817.53 86.30 460.00) 490,424.77 140,000.00 0.00 0.00 10,600.00 0.00 155,000.00 0.00 500,000.00 0.00 50,000.00 192,142.47 1,115,862.47 0.00 15,500.00 0.00 39,500.00 0.00 40,700.00 331,682.47 2,417,587.24 TOTAL General Fund 17,532,500.00 211,831.62 11,561,540.57 65.94 5,970,959.43 10,747,589.06 TOTAL REVENUE 17,532,500.00 211,831.62 11,561,540.57 65.94 5,970,959.43 10,747,589.06 12-14-2021 03:43 PM CITY OF ELK RIVER PAGE: 1 REVENUE &. EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2021 221-MULTIPURPOSE FACILITY FINANCIAL SUMMARY REVENUE SUMMARY Multipurpose Facility Hockey Skating Concessions TOTAL REVENUES EXPENDITURE SUMMARY Culture & Recreation Multipurpose Facility Hockey Skating Concessions TOTAL Culture & Recreation TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 91.67% OF YEAR COMPLETED CURRENT CURRENT YEAR TO DATE o OF BUDGET PRIOR FY BUDGET PERIOD ACTUAL BUDGET BALANCE YID BALANCE 1,521,850.00 115,587.89 750,601.72 49.32 771,248.28 291,477.77 61,000.00 ( 28,77.2.60) 58,657.74 96.16 2,342.26 63,399.75 35,000.00 9,306.00 24,788.00 70.82 10,212.00 ( 146.00) 139,300.00 0.00 9,515.63 6.83 129,784.37 24,930.03 1,757,150.00 96,121.29 843,563.09 48.01 913,586.91 379,661.55 1,324,300.00 161,356.08 1,050,568.85 79.33 273,731.15 623,306.10 30,150.00 2,355.00 36,541.73 121.20 ( 6,391.73) 25,695.64 19,950.00 1,397.16 7,302.83 36.61 12,647.17 3,338.61 87,500.00 540.94 1,652.46 1.89 85,847.54 28,458.59 1,461,900.00 165,649.18 1,096,065.87 74.98 365,834.13 680,798.94 1,461,900.00 165,649.18 1,096,065.87 74.98 365,834.13 680,798.94 295,250.00 ( 69,527.89)( 252,502.78) 547,752.78 ( 301,137.39) Sales and cost of sales: Sales Cost of sales Gross profit Operating revenues: User charges Delinquency collections Other Total operating revenues Operating expenses: Personal services Supplies Other service charges Depreciation * Total operating expenses Operating income (loss) Nonoperating revenues (expenses): Interest income Interest expense/agent fees Total nonoperating revenues (expenses) Income (loss) before contributions & transfers Contributions - connection fees Transfers out NET INCOME (LOSS) Items reclassified to balance sheet at year end: Capital Outlay Bond Payment Revenues over/(under) expenditures * Recorded at yearend CITY OF ELK RIVER ENTERPRISE FUNDS - BUDGET TO ACTUAL MONTH ENDED NOVEMBER, 2021 Liquor Sewer Garbage Stormwater Current Year to Date % of Current Year to Date % of Current Year to Date % of Current Year to Date % of Budget Actual Budget Budget Actual Budget Budget Actual Budget Budget Actual Budget $ 7,670,500 $ 7,731,073 100.79% 5,403,500 5,397,063 99.88% $ 2,350,000 $ 1,962,338 83.50% $ 1,735,000 $ 1,475,451 85.04% $ 575,000 $ 487,398 84.76% 2,267,000 2,334,010 102.96% - - - - - - 500 869 173.80% - 1,430 - - 265 - 4,800 5,604 116.75% 120,000 135,747 113.12% - - - - - 4,800 5,604 116.75% 2,470,500 2,098,954 84.96% 1,735,000 1,476,881 85.12% 575,000 487,663 84.81% 971,550 913,656 94.04% 743,800 623,901 83.88% 32,550 28,979 89.03% - - - 19,600 16,768 85.55% 260,100 221,591 85.19% 19,400 20,496 105.65% 1,000 133 13.30% 306,500 337,470 110.10% 700,400 653,180 93.26% 1,483,900 1,308,644 88.19% 522,900 160,021 30.60% 124,000 - 0.00% 1,646,000 - 0.00% - - - 458,000 - 0.00% 1,421,650 1,267,894 89.18% 3,350,300 1,498,672 44.73% 1,535,850 1,358,119 88.43% 981,900 160,154 16.31% 850,150 1,071,721 126.06% (879,800) 600,282 -68.23% 199,150 118,762 59.63% (406,900) 327,509 -80.49% 50,000 60,278 120.56% 50,000 83,192 166.38% 3,000 5,889 196.30% 5,000 15,897 317.94% - - - (231,100) (143,186) 61.96% - - - - - - 50,000 60,278 120.56% (181,100) (59,994) 33.13% 3,000 5,889 196.30% 5,000 15,897 317.94% 900,150 1,131,999 125.76% (1,060,900) 540,288 -50.93% 202,150 124,651 61.66% (401,900) 343,406 -85.45% - - - 100,000 1,236,486 1236.49% - - - - - 750,000 1,001,394 133.52% (160,000) (160,000) 100.00% (52,000) (52,000) 100.00% 121,000 121,000 100.00% 150,150 130,605 86.98% (1,120,900) 1,616,774 -144.24% 150,150 72,651 48.39% 522,900 222,406 -42.53% (20,000) (18,000) - (135,000) (67,733) - - - - - - (440,000) (440,000) - - - 130,150 112,605 1,695,900 1,109,041 150,150 72,651 522,900 222,406 12-14-2021 04:08 PM CITY OF ELK RIVER PAGE: 1 POOLED CASH REPORT (FUND 999) AS OF: NOVEMBER 30TH, 2021 FUND ACCOUNT# ACCOUNT NAME CLAIM ON CASH BEGINNING BALANCE CURRENT CURRENT ACTIVITY BALANCE 002-1010 Cash - Section 125 13,.225.50 ( 75.07) 13,150.43 101-1010 Cash - General Fund 5,858,873.28 ( 1,084,616.05) 4,774,257.23 211-1010 Cash - Library 220,795.13 ( 7,462.53) 213,332.60 219-1010 Cash.- Federal COVID Fund 1,334,034.87 43,715.23 1,377,750.10 221-1010 Cash - Multipurpose Facility ( 98,326.49) 10,512.97 ( 87,813.52) 225-1010 Cash - Park Dedication 932,292.44 0.00 932,292.44 228-1010 Cash - Landfill 202,925.26 ( 20,635.30) 182,289.96 231-1010 Cash.- Landfill Const Debris 806,877.97 0.00 806,877.97 240-1010 Cash - Micro Loan Fund 854,742.59 4,592.81 859,335.40 242-1010 Cash - State DEED 200,473.56 4,149.90 204,623.46 245-1010 Cash - Development Fund 1,854,699.61 ( 21,053.53) 1,833,646.08 290-1010 Cash. - Capital Outlay :Reserve 1,869,001.33 ( 28,355.15) 1,840,646.IS 291-1010 Cash - Insurance Reserve 16,902.83 8,220.68 25,123.51 292-1010 Cash - Govt Bldgs Reserve 3,830,248.09 ( 7,790.55) 3,822,457.54 294-1010 Cash - Drug Forfeiture 51,270.34 ( 568.79) 50,701.55 295-1010 Cash. - Severance Pay Reserve 78,832.13 0.00 78,832.13 296-1010 Cash - GRE Reserve 1,050,368.19 0.00 1,050,368.19 301-1010 Cash - 2020A GO CIP Bonds 4,162.37 0.00 4,162.37 302-1010 Cash - 2021A GO CIP BONDS 96,411.13 0.00 96,411.13 333-1010 Cash. - 20.20B (2010/2012) Bonds 752,790.76 0.00 752,790.76 343-1010 Cash - 2019A Sales Tax Bonds 3,446,168.42 303,347.85 3,749,516.27 401-1010 Cash - Pavement Mgmt. 6,659,548.91 ( 797,668.51) 5,861,880.40 403-1010 Cash - Street Improvement 325,751.07 ( 5,032.08) 320,718.99 406-1010 Cash. - City Wide Trunk Utii 3,498,824.51 ( 2,322.00) 3,496,502.51 410-1010 Cash - Equipment Replacement 945,471.21 56,847.84 1,002,319.05 420-1010 Cash - Active ER 3,646,713.80 ( 578,414.46) 3,068,299.34 421-1010 Cash - PS Building/Fire Sta 3 5,762,890.49 ( 988,018.11) 4,774,872.38 440-1010 Cash. - Park Improvement 427,553.90 1,315.28 428,869.18 463-1010 Cash - TIF 423 Prof Powder 28,475.59 0.00 28,475.59 465-1010 Cash - TIF 25 Jackson Hills 2,505.68 0.00 2,505.68 602-1010 Cash - Wastewater Treatment 7,173,046.81 85,727.00 7,258,773.81 603-1010 Cash. - Liquor 4,493,182.53 85,953.09 4,579,135.62 605-1010 Cash - Garbage 491,895.81 20,034.16 511,929.97 607-1010 Cash - Storm Water 1,397,637.75 20,144.99 1,417,782.74 801-1010 Cash - Interest 42,021.45 209.88 42,231.33 821-1010 Cash. - Developer Escrow 723,236.72 ( 6,394.63) 716,842.09 TOTAL CLAIM ON CASH 58,995,525.54 ( 2,903,635.08) 56,091,890.46 CASH IN BANK - POOLED CASH 999-1000 A/P BANK ACCOUNTS 173,479,741.11 ( 1,697,098.28) 171,782,642.83 999-1001 PY BANK ACCOUNT (142,866,405.13)( 1,206,536.80)(144,072,941.93) 999-1002 POOLED INVESTMENTS 28,382,189.56 0.00 28,382,189.56 SUBTOTAL CASH IN BANK - POOLED CASH 58,995,525.54 ( 2,903,635.08) 56,091,890.46