Loading...
HomeMy WebLinkAbout2021.08 August Monthly Report To: Erika Storlie, City Manager From: Hitesh Desai, CFO/City Treasurer Subject: August 2021 Monthly Financial Report Date: October 1, 2021 Please find attached the unaudited financial statements as of August 31, 2021. A summary by fund for revenues, expenditures, fund and cash balances is as follows: Fund #Fund Name Revenue Expense Net Fund Balance Cash Balance 100 General 76,894,769 69,802,527 7,092,243 24,558,510 20,799,319 170 American Rescue Plan 21,603,267 - 21,603,267 21,603,267 21,603,267 175 General Assistance 604,123 735,762 (131,640) 257,896 257,768 176 Health and Human Services 1,999,803 1,542,259 457,544 1,427,607 1,427,418 177 Reparations 26,410 1,302 25,108 243,250 243,250 180 Good Neighbor 1,000,673 425,591 575,081 925,899 925,899 185 Library 4,686,442 5,077,357 (390,915) 2,503,924 2,516,187 186 Library Debt Service 200,000 124,950 75,050 76,195 76,195 187 Library Capital Improvement FD - 386,219 (386,219) 897,739 897,739 200 MFT 3,503,556 1,639,437 1,864,119 5,826,862 5,604,468 205 E911 960,484 563,730 396,754 1,786,384 1,429,659 210 Special Service Area (SSA) #9 305,556 299,214 6,342 (208,318) (208,318) 215 CDBG 484,871 890,583 (405,711) (344,888) (344,888) 220 CD Loan 86,382 - 86,382 269,207 269,207 235 Neighborhood Improvement 17 8 9 22,130 22,130 240 Home 273,726 276,100 (2,374) 27,191 53,228 250 Affordable Housing 354,026 1,528,833 (1,174,807) 2,626,976 2,759,868 320 Debt Service 7,860,362 2,935,232 4,925,130 5,646,588 5,669,611 330 Howard Ridge 687,445 299,703 387,742 2,723,785 2,706,915 335 West Evanston 1,044,888 100,687 944,201 2,738,831 2,738,831 340 Dempster-Dodge-TIF 94,007 113,081 (19,073) 193,189 193,189 345 Chicago Main-TIF 462,250 860,781 (398,531) 926,141 926,141 350 Special Service Area (SSA) #6 5,271 7,548 (2,277) 1,796 1,796 355 Special Service Area (SSA) #7 76,875 73,741 3,134 3,487 3,487 360 Special Service Area (SSA) #8 31,526 30,893 633 1,678 1,678 415 Capital Improvements 757,876 3,223,127 (2,465,252) 8,053,261 8,443,628 416 Crown Construction 3,208,026 176,836 3,031,189 5,662,074 6,950,330 417 Crown Community CTR Maintenance 116,664 - 116,664 291,664 291,664 420 Special Assessment 72,850 326,256 (253,406) 2,400,061 2,396,878 505 Parking 5,438,451 5,812,423 (373,971) 114,986 334,287 510 Water 13,805,942 15,197,037 (1,391,096) 9,518,452 11,670,157 515 Sewer 6,448,836 5,364,846 1,083,990 5,985,936 4,588,041 520 Solid Waste 3,613,615 3,509,280 104,335 (45,990) (715,110) 600 Fleet 2,074,344 1,821,364 252,980 992,661 (356,690) 601 Equipment Replacement 297,165 977,166 (680,001) (156,457) (156,457) 605 Insurance 13,748,434 12,385,912 1,362,522 (7,101,167) (2,621,852) Grand Total 172,828,931 136,509,786 36,319,145 100,450,803 101,398,920 Memorandum Please note that the attached supporting documents have been updated to show further fund and department analysis. Included above are ending fund and cash balances as of August 31, 2021. Cash balance represents liquid cash and/or invested assets which can be used (or easily sold) to support and fund current operations. Fund balance includes illiquid assets or future cash receipts or disbursements such as receivables (including property tax) due to the City and accounts payable/accrued expenses. All fund balances are unaudited. Covid-19 Staff continues to monitor the impact of Covid-19 on the City’s finances for 2021. General Fund The unaudited financial statements show the General Fund as of August 31, 2021 with a fund balance of $24,558,510 and cash balance of $20,799,319. The attached financials show General Fund revenues at 69% of budget and expenses at 63% of budget against a target of 67%. The 2020 ending balance for the General Fund is 17,466,267. The Cook County second installment property tax bills for tax year 2020 went out during the last week of August with a due date of October 1. Expenses are slightly below target. January through August are typically slower months for program spending and overtime. The mild winter weather in the early part of the year helped keep costs low. Staff continues to monitor Police and Fire overtime expenses. Through August, Police had spent 50% of budget for overtime, and Fire had spent 6% over the annual budget. For Police, this is below target of 67%. Overtime is higher in Fire Department due to the onboarding/ training of new firefighters. Overtime will begin to decrease once recruits are fully trained. Fire overtime is also high in August due to Firefighter/Paramedics serving at vaccine clinics. This cost is expected to be covered by FEMA reimbursement. Overtime Expenses 2020 Actual 2021 Budget 2021 YTD % Budget Police $913,232 $ 1,484,322 $736,267 50% Fire $1,651,457 $ 959,956 $1,017,293 106% Enterprise Funds Parking fund revenues through August 31, 2021 are at 47% of budget and expenses are at 52%. The fund ended 2020 with a fund balance of $488,957. Through August 31, 2021 , the Water Fund appears low on revenue and expenses. This is because capital projects funded with IEPA loan/debt will take place later in the year. These projects are budgeted in Other Revenue and expenses in Capital Outlay. The 2020 ending fund balance is $10,909,547. The Water Fund revenues reflect payment from the Village of Skokie at the rate of $1.26 per 1000 gallons as agreed upon recently. Through August 31, 2021, the Sewer Fund also appears low on expenses mainly due to the capital projects and debt service payments occurring later in the year. The revenues are low because of bond proceeds (budgeted as Other Financing Sources) were received in September. The 2020 ending fund balance is $4,901,944. Through August 31, 2021, the Solid Waste Fund has a negative fund balance of $45,990 and a negative cash balance of $715,110. The fund ended 2020 with a fund balance of $(150,325). Other Funds Through August 31, 2021, the SSA #4 Fund is showing negative fund and cash balance of $208,318. Through August 31, 2021, the Capital Improvements Fund is showing a fund balance of $8,053,261 and a cash balance of $8,443,628. The fund continues to spend down Series 2019B and Series 2020 bond proceeds. Through August 31, 2021, the Crown Construction fund is showing fund balance of $5,662,074 and cash balance of $6,950,330. The fund continues to spend down balances from bond proceeds and gifts from the Friends of Robert Crown. Through August 31, 2021, the Insurance Fund is showing a negative fund balance of $8,104,930 and a negative cash balance of $2,621,852. Fund balance is significantly lower than cash balance due to accrued liabilities for pending litigations. If there are any questions on the attached report, please contact me by phone at (847) 448-8082 or by email: hdesai@cityofevanston.org. Detailed fund summary reports can be found at: http://www.cityofevanston.org/city-budget/financial-reports/. CERTIFICATION OF ATTACHED FINANCIAL REPORTS As required per Illinois Statute 65 ILCS 5/3.1-35-45 I, Hitesh Desai, Treasurer of the City of Evanston, hereby affirm that I have reviewed the August 31, 2021 year-to-date financial information and reports which to the best of my knowledge appear accurate and complete. Income Statement Through 08/31/21 Summary Listing Annual MTD YTD Budget Less % of Prior Year Organization Organization Description Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual Fund Category Governmental Funds Fund Type GENERAL FUND Fund 100 - GENERAL FUND REVENUE 12 LEGISLATIVE .00 .00 (200.00)200.00 +++.00 14 CITY CLERK 500.00 .00 121.00 379.00 24 47.00 15 CITY MANAGER'S OFFICE 68,600,003.00 6,583,445.28 50,274,206.53 18,325,796.47 73 71,948,682.90 17 LAW 537,000.00 22,521.14 324,833.99 212,166.01 60 374,776.51 19 ADMINISTRATIVE SERVICES 3,958,500.00 (161,030.30)1,698,774.85 2,259,725.15 43 2,468,829.67 21 COMMUNITY DEVELOPMENT 4,974,700.00 76,313.93 4,309,159.90 665,540.10 87 7,577,748.81 22 POLICE 12,599,461.00 85,101.01 6,630,509.11 5,968,951.89 53 12,098,944.12 23 FIRE MGMT & SUPPORT 12,420,378.00 198,804.78 7,328,889.79 5,091,488.21 59 12,282,439.34 24 HEALTH 1,272,842.00 102,845.66 1,250,775.15 22,066.85 98 888,088.69 26 PUBLIC WORKS .00 .00 5.00 (5.00)+++5.13 30 PARKS AND RECREATION 6,021,025.00 432,232.15 4,785,546.68 1,235,478.32 79 5,095,070.90 40 PUBLIC WORKS AGENCY 638,200.00 52,306.67 292,147.28 346,052.72 46 253,667.34 REVENUE TOTALS $111,022,609.00 $7,392,540.32 $76,894,769.28 $34,127,839.72 69%$112,988,300.41 EXPENSE 12 LEGISLATIVE .00 .00 795.00 (795.00)+++3,139.75 13 CITY COUNCIL 556,165.60 37,412.96 318,529.56 237,636.04 57 472,270.09 14 CITY CLERK 178,794.66 13,242.82 121,859.60 56,935.06 68 183,831.96 15 CITY MANAGER'S OFFICE 6,004,834.63 487,449.10 3,897,369.53 2,107,465.10 65 10,136,584.81 17 LAW 576,892.00 43,473.31 309,543.54 267,348.46 54 511,640.20 19 ADMINISTRATIVE SERVICES 10,360,246.39 962,748.45 6,358,967.30 4,001,279.09 61 9,295,177.88 21 COMMUNITY DEVELOPMENT 3,073,829.11 236,417.77 2,109,262.95 964,566.16 69 3,150,001.53 22 POLICE 39,734,285.59 2,100,556.46 24,180,413.19 15,553,872.40 61 38,724,587.22 23 FIRE MGMT & SUPPORT 26,006,574.05 1,261,639.17 16,216,794.43 9,789,779.62 62 26,265,320.62 24 HEALTH 1,556,419.50 163,275.74 1,310,822.43 245,597.07 84 1,331,233.68 30 PARKS AND RECREATION 11,329,360.87 1,249,923.64 7,226,952.38 4,102,408.49 64 9,550,408.37 40 PUBLIC WORKS AGENCY 11,642,790.99 905,625.59 7,751,216.63 3,891,574.36 67 11,566,540.90 48 LIBRARY .00 .00 .00 .00 +++30.00 EXPENSE TOTALS $111,020,193.39 $7,461,765.01 $69,802,526.54 $41,217,666.85 63%$111,190,767.01 Grand Totals REVENUE TOTALS 111,022,609.00 7,392,540.32 76,894,769.28 34,127,839.72 69%112,988,300.41 EXPENSE TOTALS 111,020,193.39 7,461,765.01 69,802,526.54 41,217,666.85 63%111,190,767.01 Grand Total Net Gain (Loss)$2,415.61 ($69,224.69)$7,092,242.74 ($7,089,827.13)$0.06 $1,797,533.40 Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 3,110,000.00 .00 1,530,000.00 1,580,000.00 49 3,110,000.00 450,000.00 37,500.00 300,000.00 150,000.00 67 100,000.00 125,000.00 82,074.80 165,905.80 (40,905.80)133 50,548.97 2,000.00 .00 2,740.00 (740.00)137 95,950.00 .00 218.57 1,157.41 (1,157.41)+++800.72 $3,687,000.00 $119,793.37 $1,999,803.21 $1,687,196.79 54%$3,357,299.69 $3,687,000.00 $119,793.37 $1,999,803.21 $1,687,196.79 54%$3,357,299.69 736,373.00 .00 .00 736,373.00 0 .00 $736,373.00 $0.00 $0.00 $736,373.00 0%$0.00 1,697,148.21 164,371.25 1,043,181.73 653,966.48 61 1,217,849.18 603,870.00 123,336.22 321,763.67 282,106.33 53 338,286.16 .00 284.10 8,861.29 (8,861.29)+++10,268.14 143,333.00 .00 52,292.01 91,040.99 36 735,569.47 465,000.00 6,413.62 116,160.66 348,839.34 25 112,670.28 .00 .00 .00 .00 +++3,352.00 $2,909,351.21 $294,405.19 $1,542,259.36 $1,367,091.85 53%$2,417,995.23 $3,645,724.21 $294,405.19 $1,542,259.36 $2,103,464.85 42%$2,417,995.23 3,687,000.00 119,793.37 1,999,803.21 1,687,196.79 54%3,357,299.69 3,645,724.21 294,405.19 1,542,259.36 2,103,464.85 42%2,417,995.23 $41,275.79 ($174,611.82)$457,543.85 $416,268.06 1,109%$939,304.46 Income Statement Through 08/31/21 Summary Listing Classification Fund Category Governmental Funds Fund Type GENERAL FUND Fund 176 - HUMAN SERVICES FUND REVENUE Department 24 - HEALTH Property Taxes Interfund Transfers Intergovernmental Revenue Other Revenue Interest Income Department 24 - HEALTH Totals REVENUE TOTALS EXPENSE Department 21 - COMMUNITY DEVELOPMENT Services and Supplies Department 21 - COMMUNITY DEVELOPMENT Totals Department 24 - HEALTH Salary and Benefits Services and Supplies Insurance and Other Chargebacks Community Sponsored Organizations Miscellaneous REVENUE TOTALS EXPENSE TOTALS Fund 176 - HUMAN SERVICES FUND Net Gain (Loss) Interfund Transfers Department 24 - HEALTH Totals EXPENSE TOTALS Fund 176 - HUMAN SERVICES FUND Totals Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual .00 .00 21,586,827.00 (21,586,827.00)+++.00 .00 4,108.39 16,440.02 (16,440.02)+++.00 $0.00 $4,108.39 $21,603,267.02 ($21,603,267.02)+++$0.00 $0.00 $4,108.39 $21,603,267.02 ($21,603,267.02)+++$0.00 .00 4,108.39 21,603,267.02 (21,603,267.02)+++.00 .00 .00 .00 .00 +++.00 $0.00 $4,108.39 $21,603,267.02 $21,603,267.02 +++$0.00 Income Statement Through 08/31/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Special Revenue Funds Fund 170 - AMERICAN RESCUE PLAN REVENUE Department 99 - NON-DEPARTMENTAL Intergovernmental Revenue Interest Income EXPENSE TOTALS Fund 170 - AMERICAN RESCUE PLAN Net Gain (Loss) Department 99 - NON-DEPARTMENTAL Totals REVENUE TOTALS Fund 170 - AMERICAN RESCUE PLAN Totals REVENUE TOTALS Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 1,300,000.00 .00 600,546.54 699,453.46 46 1,100,904.14 27,500.00 .00 2,585.00 24,915.00 9 42,115.91 1,000.00 105.41 991.08 8.92 99 3,131.62 $1,328,500.00 $105.41 $604,122.62 $724,377.38 45%$1,146,151.67 $1,328,500.00 $105.41 $604,122.62 $724,377.38 45%$1,146,151.67 452,062.40 42,211.93 324,492.99 127,569.41 72 406,614.05 865,982.00 52,242.51 406,855.56 459,126.44 47 708,132.08 7,000.00 4,000.00 4,413.58 2,586.42 63 4,910.00 $1,325,044.40 $98,454.44 $735,762.13 $589,282.27 56%$1,119,656.13 $1,325,044.40 $98,454.44 $735,762.13 $589,282.27 56%$1,119,656.13 1,328,500.00 105.41 604,122.62 724,377.38 45%1,146,151.67 1,325,044.40 98,454.44 735,762.13 589,282.27 56%1,119,656.13 $3,455.60 ($98,349.03)($131,639.51)($135,095.11)(3,809%)$26,495.54 Income Statement Through 08/31/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Special Revenue Funds Fund 175 - GENERAL ASSISTANCE FUND REVENUE Department 24 - HEALTH Property Taxes Other Revenue Interest Income Department 24 - HEALTH Totals REVENUE TOTALS EXPENSE Department 24 - HEALTH Salary and Benefits Services and Supplies Miscellaneous Department 24 - HEALTH Totals EXPENSE TOTALS Fund 175 - GENERAL ASSISTANCE FUND Totals REVENUE TOTALS EXPENSE TOTALS Fund 175 - GENERAL ASSISTANCE FUND Net Gain (Loss) Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 400,000.00 .00 .00 400,000.00 0 .00 .00 .00 .00 .00 +++200,000.00 .00 871.00 26,180.29 (26,180.29)+++16,806.50 .00 44.47 229.41 (229.41)+++.00 $400,000.00 $915.47 $26,409.70 $373,590.30 7%$216,806.50 $400,000.00 $915.47 $26,409.70 $373,590.30 7%$216,806.50 .00 1,271.04 1,301.64 (1,301.64)+++.00 400,000.00 .00 .00 400,000.00 0 .00 $400,000.00 $1,271.04 $1,301.64 $398,698.36 0%$0.00 $400,000.00 $1,271.04 $1,301.64 $398,698.36 0%$0.00 400,000.00 915.47 26,409.70 373,590.30 7%216,806.50 400,000.00 1,271.04 1,301.64 398,698.36 0%.00 $0.00 ($355.57)$25,108.06 $25,108.06 +++$216,806.50 Income Statement Through 08/31/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Special Revenue Funds Fund 177 - REPARATIONS FUND REVENUE Department 15 - CITY MANAGER'S OFFICE Other Taxes Interfund Transfers Other Revenue Interest Income Department 15 - CITY MANAGER'S OFFICE Totals REVENUE TOTALS EXPENSE Department 15 - CITY MANAGER'S OFFICE Services and Supplies Miscellaneous Department 15 - CITY MANAGER'S OFFICE Totals EXPENSE TOTALS Fund 177 - REPARATIONS FUND Totals REVENUE TOTALS EXPENSE TOTALS Fund 177 - REPARATIONS FUND Net Gain (Loss) Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 1,000,000.00 .00 1,000,000.00 .00 100 1,000,000.00 .00 112.07 672.51 (672.51)+++1,805.35 $1,000,000.00 $112.07 $1,000,672.51 ($672.51)100%$1,001,805.35 $1,000,000.00 $112.07 $1,000,672.51 ($672.51)100%$1,001,805.35 .00 39.64 327.00 (327.00)+++497.43 620,000.00 .00 11,112.50 608,887.50 2 33,034.90 380,000.00 .00 414,151.77 (34,151.77)109 870,000.04 $1,000,000.00 $39.64 $425,591.27 $574,408.73 43%$903,532.37 $1,000,000.00 $39.64 $425,591.27 $574,408.73 43%$903,532.37 1,000,000.00 112.07 1,000,672.51 (672.51)100%1,001,805.35 1,000,000.00 39.64 425,591.27 574,408.73 43%903,532.37 $0.00 $72.43 $575,081.24 $575,081.24 +++$98,272.98 Income Statement Through 08/31/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Special Revenue Funds Fund 180 - GOOD NEIGHBOR FUND REVENUE Department 99 - NON-DEPARTMENTAL Other Revenue Interest Income Department 99 - NON-DEPARTMENTAL Totals REVENUE TOTALS EXPENSE Department 99 - NON-DEPARTMENTAL Services and Supplies Fund 180 - GOOD NEIGHBOR FUND Totals REVENUE TOTALS EXPENSE TOTALS Fund 180 - GOOD NEIGHBOR FUND Net Gain (Loss) Miscellaneous Interfund Transfers Department 99 - NON-DEPARTMENTAL Totals EXPENSE TOTALS Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 7,252,000.00 .00 3,962,488.73 3,289,511.27 55 7,268,891.26 .00 .00 4,478.01 (4,478.01)+++22,320.17 .00 35.59 171.83 (171.83)+++149.90 209,000.00 .00 250,000.00 (41,000.00)120 199,414.25 238,000.00 83,617.63 232,547.34 5,452.66 98 285,045.65 400,000.00 34,871.65 176,118.71 223,881.29 44 427,372.39 227,224.00 (4,175.48)52,960.35 174,263.65 23 71,720.03 15,000.00 783.50 7,677.45 7,322.55 51 26,949.16 $8,341,224.00 $115,132.89 $4,686,442.42 $3,654,781.58 56%$8,301,862.81 $8,341,224.00 $115,132.89 $4,686,442.42 $3,654,781.58 56%$8,301,862.81 5,910,018.36 423,354.24 3,731,168.13 2,178,850.23 63 5,405,967.44 2,052,000.00 74,894.80 1,105,381.09 946,618.91 54 1,714,948.94 8,500.00 .00 .00 8,500.00 0 775.00 .00 .00 .00 .00 +++600.00 361,226.00 30,101.00 240,808.00 120,418.00 67 354,375.00 $8,331,744.36 $528,350.04 $5,077,357.22 $3,254,387.14 61%$7,476,666.38 $8,331,744.36 $528,350.04 $5,077,357.22 $3,254,387.14 61%$7,476,666.38 8,341,224.00 115,132.89 4,686,442.42 3,654,781.58 56%8,301,862.81 8,331,744.36 528,350.04 5,077,357.22 3,254,387.14 61%7,476,666.38 $9,479.64 ($413,217.15)($390,914.80)($400,394.44)(4,124%)$825,196.43 Income Statement Through 08/31/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Special Revenue Funds Fund 185 - LIBRARY FUND REVENUE Department 48 - LIBRARY Property Taxes Fines and Forfeitures Charges for Services Interfund Transfers Intergovernmental Revenue Other Revenue Library Revenue Interest Income Department 48 - LIBRARY Totals REVENUE TOTALS EXPENSE Department 48 - LIBRARY Salary and Benefits Services and Supplies Capital Outlay Miscellaneous Interfund Transfers EXPENSE TOTALS Fund 185 - LIBRARY FUND Net Gain (Loss) Department 48 - LIBRARY Totals EXPENSE TOTALS Fund 185 - LIBRARY FUND Totals REVENUE TOTALS Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 3,656,700.00 247,865.34 3,500,191.13 156,508.87 96 4,346,950.35 12,000.00 (55.88)3,364.87 8,635.13 28 18,013.10 $3,668,700.00 $247,809.46 $3,503,556.00 $165,144.00 95%$4,364,963.45 $3,668,700.00 $247,809.46 $3,503,556.00 $165,144.00 95%$4,364,963.45 .00 .00 .00 .00 +++25,472.95 .00 .00 .00 .00 +++1,044,987.00 $0.00 $0.00 $0.00 $0.00 +++$1,070,459.95 1,038,000.00 1,842.31 561,099.02 476,900.98 54 684,583.03 2,284,000.00 327,856.25 381,681.94 1,902,318.06 17 1,316,209.69 1,044,987.00 87,082.00 696,656.00 348,331.00 67 .00 $4,366,987.00 $416,780.56 $1,639,436.96 $2,727,550.04 38%$2,000,792.72 $4,366,987.00 $416,780.56 $1,639,436.96 $2,727,550.04 38%$3,071,252.67 3,668,700.00 247,809.46 3,503,556.00 165,144.00 95%4,364,963.45 4,366,987.00 416,780.56 1,639,436.96 2,727,550.04 38%3,071,252.67 ($698,287.00)($168,971.10)$1,864,119.04 $2,562,406.04 (267%)$1,293,710.78 Income Statement Through 08/31/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Special Revenue Funds Fund 200 - MOTOR FUEL TAX FUND REVENUE Department 40 - PUBLIC WORKS AGENCY Intergovernmental Revenue Interest Income Department 40 - PUBLIC WORKS AGENCY Totals REVENUE TOTALS EXPENSE Department 26 - PUBLIC WORKS Capital Outlay Interfund Transfers Department 26 - PUBLIC WORKS Totals Department 40 - PUBLIC WORKS AGENCY Services and Supplies Capital Outlay REVENUE TOTALS EXPENSE TOTALS Fund 200 - MOTOR FUEL TAX FUND Net Gain (Loss) Interfund Transfers Department 40 - PUBLIC WORKS AGENCY Totals EXPENSE TOTALS Fund 200 - MOTOR FUEL TAX FUND Totals Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 1,321,600.00 118,189.94 959,625.69 361,974.31 73 1,460,634.96 .00 .00 .00 .00 +++240,821.00 .00 .00 266.17 (266.17)+++.00 7,000.00 83.73 591.91 6,408.09 8 5,531.23 $1,328,600.00 $118,273.67 $960,483.77 $368,116.23 72%$1,706,987.19 $1,328,600.00 $118,273.67 $960,483.77 $368,116.23 72%$1,706,987.19 742,978.48 46,043.00 365,646.15 377,332.33 49 561,536.22 374,000.00 25.93 118,136.44 255,863.56 32 241,438.39 299,163.00 .00 7,795.66 291,367.34 3 506,613.00 18,230.00 1,519.00 12,152.00 6,078.00 67 18,229.00 .00 .00 .00 .00 +++500.00 90,000.00 7,500.00 60,000.00 30,000.00 67 260,000.00 $1,524,371.48 $55,087.93 $563,730.25 $960,641.23 37%$1,588,316.61 $1,524,371.48 $55,087.93 $563,730.25 $960,641.23 37%$1,588,316.61 1,328,600.00 118,273.67 960,483.77 368,116.23 72%1,706,987.19 1,524,371.48 55,087.93 563,730.25 960,641.23 37%1,588,316.61 ($195,771.48)$63,185.74 $396,753.52 $592,525.00 (203%)$118,670.58 Income Statement Through 08/31/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Special Revenue Funds Fund 205 - EMERGENCY TELEPHONE (E911) FUND REVENUE Department 22 - POLICE Other Taxes Intergovernmental Revenue Other Revenue Interest Income Department 22 - POLICE Totals REVENUE TOTALS EXPENSE Department 22 - POLICE Salary and Benefits Services and Supplies Capital Outlay Insurance and Other Chargebacks Fund 205 - EMERGENCY TELEPHONE (E911) FUND Totals REVENUE TOTALS EXPENSE TOTALS Fund 205 - EMERGENCY TELEPHONE (E911) FUND Net Gain (Loss) Miscellaneous Interfund Transfers Department 22 - POLICE Totals EXPENSE TOTALS Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 592,665.00 .00 305,550.82 287,114.18 52 603,396.20 .00 .00 5.00 (5.00)+++87.15 $592,665.00 $0.00 $305,555.82 $287,109.18 52%$603,483.35 $592,665.00 $0.00 $305,555.82 $287,109.18 52%$603,483.35 575,000.00 .00 299,213.69 275,786.31 52 591,950.27 $575,000.00 $0.00 $299,213.69 $275,786.31 52%$591,950.27 $575,000.00 $0.00 $299,213.69 $275,786.31 52%$591,950.27 592,665.00 .00 305,555.82 287,109.18 52%603,483.35 575,000.00 .00 299,213.69 275,786.31 52%591,950.27 $17,665.00 $0.00 $6,342.13 ($11,322.87)36%$11,533.08 Income Statement Through 08/31/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Special Revenue Funds Fund 210 - SPECIAL SERVICE AREA (SSA) #9 REVENUE Department 21 - COMMUNITY DEVELOPMENT Property Taxes Interest Income Department 21 - COMMUNITY DEVELOPMENT Totals REVENUE TOTALS EXPENSE Department 21 - COMMUNITY DEVELOPMENT Services and Supplies EXPENSE TOTALS Fund 210 - SPECIAL SERVICE AREA (SSA) #9 Net Gain (Loss) Department 21 - COMMUNITY DEVELOPMENT Totals EXPENSE TOTALS Fund 210 - SPECIAL SERVICE AREA (SSA) #9 Totals REVENUE TOTALS Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 2,758,514.00 93,924.75 484,871.14 2,273,642.86 18 1,698,645.65 $2,758,514.00 $93,924.75 $484,871.14 $2,273,642.86 18%$1,698,645.65 $2,758,514.00 $93,924.75 $484,871.14 $2,273,642.86 18%$1,698,645.65 319,997.01 27,268.81 233,792.35 86,204.66 73 365,979.08 506,200.00 5.84 4,913.18 501,286.82 1 71,266.08 .00 4,280.00 125,230.49 (125,230.49)+++607,132.53 150,000.00 .00 138,008.55 11,991.45 92 292,237.53 80,000.00 106,150.00 368,480.10 (288,480.10)461 282,315.50 1,700,000.00 7,845.28 20,157.83 1,679,842.17 1 70,077.60 .00 .00 .00 .00 +++12,111.33 $2,756,197.01 $145,549.93 $890,582.50 $1,865,614.51 32%$1,701,119.65 $2,756,197.01 $145,549.93 $890,582.50 $1,865,614.51 32%$1,701,119.65 2,758,514.00 93,924.75 484,871.14 2,273,642.86 18%1,698,645.65 2,756,197.01 145,549.93 890,582.50 1,865,614.51 32%1,701,119.65 $2,316.99 ($51,625.18)($405,711.36)($408,028.35)(17,510%)($2,474.00) Income Statement Through 08/31/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Special Revenue Funds Fund 215 - CDBG FUND REVENUE Department 21 - COMMUNITY DEVELOPMENT Intergovernmental Revenue Department 21 - COMMUNITY DEVELOPMENT Totals REVENUE TOTALS EXPENSE Department 21 - COMMUNITY DEVELOPMENT Salary and Benefits Services and Supplies Capital Outlay Insurance and Other Chargebacks Community Sponsored Organizations Miscellaneous Interfund Transfers EXPENSE TOTALS Fund 215 - CDBG FUND Net Gain (Loss) Department 21 - COMMUNITY DEVELOPMENT Totals EXPENSE TOTALS Fund 215 - CDBG FUND Totals REVENUE TOTALS Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 110,000.00 8,699.30 85,810.72 24,189.28 78 74,015.96 .00 35.31 571.75 (571.75)+++2,387.91 $110,000.00 $8,734.61 $86,382.47 $23,617.53 79%$76,403.87 $110,000.00 $8,734.61 $86,382.47 $23,617.53 79%$76,403.87 175,000.00 .00 .00 175,000.00 0 120,955.83 .00 .00 .00 .00 +++8.50 $175,000.00 $0.00 $0.00 $175,000.00 0%$120,964.33 $175,000.00 $0.00 $0.00 $175,000.00 0%$120,964.33 110,000.00 8,734.61 86,382.47 23,617.53 79%76,403.87 175,000.00 .00 .00 175,000.00 0%120,964.33 ($65,000.00)$8,734.61 $86,382.47 $151,382.47 (133%)($44,560.46) Income Statement Through 08/31/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Special Revenue Funds Fund 220 - CDBG LOAN FUND REVENUE Department 21 - COMMUNITY DEVELOPMENT Other Revenue Interest Income Department 21 - COMMUNITY DEVELOPMENT Totals REVENUE TOTALS EXPENSE Department 21 - COMMUNITY DEVELOPMENT Services and Supplies REVENUE TOTALS EXPENSE TOTALS Fund 220 - CDBG LOAN FUND Net Gain (Loss) Miscellaneous Department 21 - COMMUNITY DEVELOPMENT Totals EXPENSE TOTALS Fund 220 - CDBG LOAN FUND Totals Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual .00 1.35 16.94 (16.94)+++334.15 $0.00 $1.35 $16.94 ($16.94)+++$334.15 $0.00 $1.35 $16.94 ($16.94)+++$334.15 .00 .48 7.85 (7.85)+++77.70 .00 .00 .00 .00 +++150,000.00 $0.00 $0.48 $7.85 ($7.85)+++$150,077.70 $0.00 $0.48 $7.85 ($7.85)+++$150,077.70 .00 1.35 16.94 (16.94)+++334.15 .00 .48 7.85 (7.85)+++150,077.70 $0.00 $0.87 $9.09 $9.09 +++($149,743.55) Income Statement Through 08/31/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Special Revenue Funds Fund 235 - NEIGHBORHOOD IMPROVEMENT REVENUE Department 21 - COMMUNITY DEVELOPMENT Interest Income Department 21 - COMMUNITY DEVELOPMENT Totals REVENUE TOTALS EXPENSE Department 21 - COMMUNITY DEVELOPMENT Services and Supplies Interfund Transfers EXPENSE TOTALS Fund 235 - NEIGHBORHOOD IMPROVEMENT Net Gain (Loss) Department 21 - COMMUNITY DEVELOPMENT Totals EXPENSE TOTALS Fund 235 - NEIGHBORHOOD IMPROVEMENT Totals REVENUE TOTALS Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual .00 .00 .00 .00 +++31,207.45 540,453.00 16,992.83 246,725.68 293,727.32 46 427,547.16 25,000.00 4,689.00 26,952.41 (1,952.41)108 12,333.55 150.00 6.66 47.78 102.22 32 114.73 $565,603.00 $21,688.49 $273,725.87 $291,877.13 48%$471,202.89 $565,603.00 $21,688.49 $273,725.87 $291,877.13 48%$471,202.89 63,875.72 5,185.81 43,934.71 19,941.01 69 12,520.85 500,565.00 16,998.19 232,495.14 268,069.86 46 411,196.39 .00 .00 (431.14)431.14 +++25,398.32 500.00 3.50 101.50 398.50 20 47.85 $564,940.72 $22,187.50 $276,100.21 $288,840.51 49%$449,163.41 $564,940.72 $22,187.50 $276,100.21 $288,840.51 49%$449,163.41 565,603.00 21,688.49 273,725.87 291,877.13 48%471,202.89 564,940.72 22,187.50 276,100.21 288,840.51 49%449,163.41 $662.28 ($499.01)($2,374.34)($3,036.62)(359%)$22,039.48 Income Statement Through 08/31/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Special Revenue Funds Fund 240 - HOME FUND REVENUE Department 21 - COMMUNITY DEVELOPMENT Charges for Services Intergovernmental Revenue Other Revenue Interest Income Department 21 - COMMUNITY DEVELOPMENT Totals REVENUE TOTALS EXPENSE Department 21 - COMMUNITY DEVELOPMENT Salary and Benefits Services and Supplies Insurance and Other Chargebacks Miscellaneous EXPENSE TOTALS Fund 240 - HOME FUND Net Gain (Loss) Department 21 - COMMUNITY DEVELOPMENT Totals EXPENSE TOTALS Fund 240 - HOME FUND Totals REVENUE TOTALS Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 75,000.00 .00 15,453.00 59,547.00 21 76,650.00 658,000.00 16,683.43 236,684.15 421,315.85 36 255,299.89 175,600.00 32,083.34 96,250.02 79,349.98 55 655,416.71 5,700.00 459.99 5,639.23 60.77 99 27,280.46 $914,300.00 $49,226.76 $354,026.40 $560,273.60 39%$1,014,647.06 $914,300.00 $49,226.76 $354,026.40 $560,273.60 39%$1,014,647.06 202,683.56 15,521.08 118,517.38 84,166.18 58 118,297.21 2,031,050.00 5.00 1,199,434.95 831,615.05 59 398,862.20 10,000.00 .00 4,200.00 5,800.00 42 2,800.00 17,000.00 .00 (27,308.62)44,308.62 (161)(34,214.97) 166,000.00 .00 217,865.45 (51,865.45)131 246,094.03 102,510.00 7.00 16,124.16 86,385.84 16 406,628.08 $2,529,243.56 $15,533.08 $1,528,833.32 $1,000,410.24 60%$1,138,466.55 $2,529,243.56 $15,533.08 $1,528,833.32 $1,000,410.24 60%$1,138,466.55 914,300.00 49,226.76 354,026.40 560,273.60 39%1,014,647.06 2,529,243.56 15,533.08 1,528,833.32 1,000,410.24 60%1,138,466.55 ($1,614,943.56)$33,693.68 ($1,174,806.92)$440,136.64 73%($123,819.49) Income Statement Through 08/31/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Special Revenue Funds Fund 250 - AFFORDABLE HOUSING FUND REVENUE Department 21 - COMMUNITY DEVELOPMENT Other Taxes Intergovernmental Revenue Other Revenue Interest Income Department 21 - COMMUNITY DEVELOPMENT Totals REVENUE TOTALS EXPENSE Department 21 - COMMUNITY DEVELOPMENT Salary and Benefits Services and Supplies Capital Outlay Insurance and Other Chargebacks Community Sponsored Organizations Miscellaneous Department 21 - COMMUNITY DEVELOPMENT Totals EXPENSE TOTALS Fund 250 - AFFORDABLE HOUSING FUND Totals REVENUE TOTALS EXPENSE TOTALS Fund 250 - AFFORDABLE HOUSING FUND Net Gain (Loss) Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 482,243.00 .00 200,000.00 282,243.00 41 480,145.00 $482,243.00 $0.00 $200,000.00 $282,243.00 41%$480,145.00 $482,243.00 $0.00 $200,000.00 $282,243.00 41%$480,145.00 482,243.00 .00 124,950.26 357,292.74 26 438,095.05 $482,243.00 $0.00 $124,950.26 $357,292.74 26%$438,095.05 .00 .00 .00 .00 +++42,049.00 $0.00 $0.00 $0.00 $0.00 +++$42,049.00 $482,243.00 $0.00 $124,950.26 $357,292.74 26%$480,144.05 482,243.00 .00 200,000.00 282,243.00 41%480,145.00 482,243.00 .00 124,950.26 357,292.74 26%480,144.05 $0.00 $0.00 $75,049.74 $75,049.74 +++$0.95 Income Statement Through 08/31/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Debt Service Funds Fund 186 - LIBRARY DEBT SERVICE FUND REVENUE Department 48 - LIBRARY Property Taxes Department 48 - LIBRARY Totals REVENUE TOTALS EXPENSE Department 48 - LIBRARY Debt Service Department 48 - LIBRARY Totals Fund 186 - LIBRARY DEBT SERVICE FUND Totals REVENUE TOTALS EXPENSE TOTALS Fund 186 - LIBRARY DEBT SERVICE FUND Net Gain (Loss) Department 99 - NON-DEPARTMENTAL Debt Service Department 99 - NON-DEPARTMENTAL Totals EXPENSE TOTALS Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 968,000.00 .00 670,975.12 297,024.88 69 1,227,407.93 5,366.00 894.46 12,288.92 (6,922.92)229 20,631.95 400.00 531.20 4,181.23 (3,781.23)1,045 12,998.83 $973,766.00 $1,425.66 $687,445.27 $286,320.73 71%$1,261,038.71 $973,766.00 $1,425.66 $687,445.27 $286,320.73 71%$1,261,038.71 335,000.00 131.69 154,295.25 180,704.75 46 352,868.87 500,000.00 .00 .00 500,000.00 0 382,140.14 .00 .00 .00 .00 +++731.37 218,113.00 18,176.00 145,408.00 72,705.00 67 314,020.09 $1,053,113.00 $18,307.69 $299,703.25 $753,409.75 28%$1,049,760.47 $1,053,113.00 $18,307.69 $299,703.25 $753,409.75 28%$1,049,760.47 973,766.00 1,425.66 687,445.27 286,320.73 71%1,261,038.71 1,053,113.00 18,307.69 299,703.25 753,409.75 28%1,049,760.47 ($79,347.00)($16,882.03)$387,742.02 $467,089.02 (489%)$211,278.24 Income Statement Through 08/31/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Debt Service Funds Fund 330 - HOWARD-RIDGE TIF FUND REVENUE Department 99 - NON-DEPARTMENTAL Property Taxes Other Revenue Interest Income Department 99 - NON-DEPARTMENTAL Totals REVENUE TOTALS EXPENSE Department 99 - NON-DEPARTMENTAL Services and Supplies Capital Outlay Miscellaneous Interfund Transfers Department 99 - NON-DEPARTMENTAL Totals Fund 330 - HOWARD-RIDGE TIF FUND Net Gain (Loss) EXPENSE TOTALS Fund 330 - HOWARD-RIDGE TIF FUND Totals REVENUE TOTALS EXPENSE TOTALS Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 1,237,000.00 .00 869,943.77 367,056.23 70 1,697,958.33 11,000.00 .00 171,504.26 (160,504.26)1,559 10,282.60 4,000.00 522.26 3,440.19 559.81 86 6,070.52 $1,252,000.00 $522.26 $1,044,888.22 $207,111.78 83%$1,714,311.45 $1,252,000.00 $522.26 $1,044,888.22 $207,111.78 83%$1,714,311.45 5,000.00 364.42 50,687.35 (45,687.35)1,014 787.35 500,000.00 .00 .00 500,000.00 0 111,700.00 200,000.00 .00 .00 200,000.00 0 382,670.00 75,000.00 6,250.00 50,000.00 25,000.00 67 135,000.00 $780,000.00 $6,614.42 $100,687.35 $679,312.65 13%$630,157.35 $780,000.00 $6,614.42 $100,687.35 $679,312.65 13%$630,157.35 1,252,000.00 522.26 1,044,888.22 207,111.78 83%1,714,311.45 780,000.00 6,614.42 100,687.35 679,312.65 13%630,157.35 $472,000.00 ($6,092.16)$944,200.87 $472,200.87 200%$1,084,154.10 Income Statement Through 08/31/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Debt Service Funds Fund 335 - WEST EVANSTON TIF FUND REVENUE Department 99 - NON-DEPARTMENTAL Property Taxes Other Revenue Interest Income Department 99 - NON-DEPARTMENTAL Totals REVENUE TOTALS EXPENSE Department 99 - NON-DEPARTMENTAL Services and Supplies Capital Outlay Miscellaneous Interfund Transfers Department 99 - NON-DEPARTMENTAL Totals Fund 335 - WEST EVANSTON TIF FUND Net Gain (Loss) EXPENSE TOTALS Fund 335 - WEST EVANSTON TIF FUND Totals REVENUE TOTALS EXPENSE TOTALS Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 147,000.00 .00 93,668.57 53,331.43 64 170,306.49 .00 .00 .00 .00 +++100,000.00 .00 42.04 338.48 (338.48)+++795.89 $147,000.00 $42.04 $94,007.05 $52,992.95 64%$271,102.38 $147,000.00 $42.04 $94,007.05 $52,992.95 64%$271,102.38 2,000.00 131.38 464.51 1,535.49 23 772.52 168,923.00 14,077.00 112,616.00 56,307.00 67 165,870.00 $170,923.00 $14,208.38 $113,080.51 $57,842.49 66%$166,642.52 $170,923.00 $14,208.38 $113,080.51 $57,842.49 66%$166,642.52 147,000.00 42.04 94,007.05 52,992.95 64%271,102.38 170,923.00 14,208.38 113,080.51 57,842.49 66%166,642.52 ($23,923.00)($14,166.34)($19,073.46)$4,849.54 80%$104,459.86 Income Statement Through 08/31/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Debt Service Funds Fund 340 - DEMPSTER-DODGE TIF FUND REVENUE Department 99 - NON-DEPARTMENTAL Property Taxes Interfund Transfers Interest Income Department 99 - NON-DEPARTMENTAL Totals REVENUE TOTALS EXPENSE Department 99 - NON-DEPARTMENTAL Fund 340 - DEMPSTER-DODGE TIF FUND Totals REVENUE TOTALS EXPENSE TOTALS Fund 340 - DEMPSTER-DODGE TIF FUND Net Gain (Loss) Services and Supplies Interfund Transfers Department 99 - NON-DEPARTMENTAL Totals EXPENSE TOTALS Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 879,000.00 .00 460,178.39 418,821.61 52 1,145,554.72 1,130,000.00 .00 .00 1,130,000.00 0 .00 .00 260.62 2,071.45 (2,071.45)+++5,057.19 $2,009,000.00 $260.62 $462,249.84 $1,546,750.16 23%$1,150,611.91 $2,009,000.00 $260.62 $462,249.84 $1,546,750.16 23%$1,150,611.91 5,000.00 132.08 475.43 4,524.57 10 785.07 1,130,000.00 403,127.24 685,073.16 444,926.84 61 251,298.71 262,843.00 21,904.00 175,232.00 87,611.00 67 260,610.00 $1,397,843.00 $425,163.32 $860,780.59 $537,062.41 62%$512,693.78 $1,397,843.00 $425,163.32 $860,780.59 $537,062.41 62%$512,693.78 2,009,000.00 260.62 462,249.84 1,546,750.16 23%1,150,611.91 1,397,843.00 425,163.32 860,780.59 537,062.41 62%512,693.78 $611,157.00 ($424,902.70)($398,530.75)($1,009,687.75)(65%)$637,918.13 Income Statement Through 08/31/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Debt Service Funds Fund 345 - CHICAGO-MAIN TIF REVENUE Department 99 - NON-DEPARTMENTAL Property Taxes Other Revenue Interest Income Department 99 - NON-DEPARTMENTAL Totals REVENUE TOTALS EXPENSE Department 99 - NON-DEPARTMENTAL Services and Supplies Capital Outlay Interfund Transfers Department 99 - NON-DEPARTMENTAL Totals EXPENSE TOTALS Fund 345 - CHICAGO-MAIN TIF Totals REVENUE TOTALS EXPENSE TOTALS Fund 345 - CHICAGO-MAIN TIF Net Gain (Loss) Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 221,000.00 .00 5,264.15 215,735.85 2 224,827.08 500.00 .34 6.96 493.04 1 315.81 $221,500.00 $0.34 $5,271.11 $216,228.89 2%$225,142.89 $221,500.00 $0.34 $5,271.11 $216,228.89 2%$225,142.89 221,500.00 .00 7,548.47 213,951.53 3 226,411.95 $221,500.00 $0.00 $7,548.47 $213,951.53 3%$226,411.95 $221,500.00 $0.00 $7,548.47 $213,951.53 3%$226,411.95 221,500.00 .34 5,271.11 216,228.89 2%225,142.89 221,500.00 .00 7,548.47 213,951.53 3%226,411.95 $0.00 $0.34 ($2,277.36)($2,277.36)+++($1,269.06) Income Statement Through 08/31/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Debt Service Funds Fund 350 - SPECIAL SERVICE AREA (SSA) #6 REVENUE Department 99 - NON-DEPARTMENTAL Property Taxes Interest Income Department 99 - NON-DEPARTMENTAL Totals REVENUE TOTALS EXPENSE Department 99 - NON-DEPARTMENTAL Services and Supplies EXPENSE TOTALS Fund 350 - SPECIAL SERVICE AREA (SSA) #6 Net Gain (Loss) Department 99 - NON-DEPARTMENTAL Totals EXPENSE TOTALS Fund 350 - SPECIAL SERVICE AREA (SSA) #6 Totals REVENUE TOTALS Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 154,800.00 .00 76,800.08 77,999.92 50 141,256.43 .00 .66 74.57 (74.57)+++91.37 $154,800.00 $0.66 $76,874.65 $77,925.35 50%$141,347.80 $154,800.00 $0.66 $76,874.65 $77,925.35 50%$141,347.80 115,000.00 .00 73,740.97 41,259.03 64 140,994.91 $115,000.00 $0.00 $73,740.97 $41,259.03 64%$140,994.91 $115,000.00 $0.00 $73,740.97 $41,259.03 64%$140,994.91 154,800.00 .66 76,874.65 77,925.35 50%141,347.80 115,000.00 .00 73,740.97 41,259.03 64%140,994.91 $39,800.00 $0.66 $3,133.68 ($36,666.32)8%$352.89 Income Statement Through 08/31/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Debt Service Funds Fund 355 - SPECIAL SERVICE AREA (SSA) #7 REVENUE Department 99 - NON-DEPARTMENTAL Property Taxes Interest Income Department 99 - NON-DEPARTMENTAL Totals REVENUE TOTALS EXPENSE Department 99 - NON-DEPARTMENTAL Services and Supplies EXPENSE TOTALS Fund 355 - SPECIAL SERVICE AREA (SSA) #7 Net Gain (Loss) Department 99 - NON-DEPARTMENTAL Totals EXPENSE TOTALS Fund 355 - SPECIAL SERVICE AREA (SSA) #7 Totals REVENUE TOTALS Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 60,200.00 .00 31,524.70 28,675.30 52 59,743.95 .00 .32 1.02 (1.02)+++24.15 $60,200.00 $0.32 $31,525.72 $28,674.28 52%$59,768.10 $60,200.00 $0.32 $31,525.72 $28,674.28 52%$59,768.10 60,200.00 .00 30,893.10 29,306.90 51 58,722.29 $60,200.00 $0.00 $30,893.10 $29,306.90 51%$58,722.29 $60,200.00 $0.00 $30,893.10 $29,306.90 51%$58,722.29 60,200.00 .32 31,525.72 28,674.28 52%59,768.10 60,200.00 .00 30,893.10 29,306.90 51%58,722.29 $0.00 $0.32 $632.62 $632.62 +++$1,045.81 Income Statement Through 08/31/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Debt Service Funds Fund 360 - SPECIAL SERVICE AREA (SSA) #8 REVENUE Department 99 - NON-DEPARTMENTAL Property Taxes Interest Income Department 99 - NON-DEPARTMENTAL Totals REVENUE TOTALS EXPENSE Department 99 - NON-DEPARTMENTAL Services and Supplies Department 99 - NON-DEPARTMENTAL Totals EXPENSE TOTALS Fund 360 - SPECIAL SERVICE AREA (SSA) #8 Totals REVENUE TOTALS EXPENSE TOTALS Fund 360 - SPECIAL SERVICE AREA (SSA) #8 Net Gain (Loss) Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 449,000.00 .00 .00 449,000.00 0 .00 $449,000.00 $0.00 $0.00 $449,000.00 0%$0.00 $449,000.00 $0.00 $0.00 $449,000.00 0%$0.00 449,000.00 .00 386,219.11 62,780.89 86 94,525.25 $449,000.00 $0.00 $386,219.11 $62,780.89 86%$94,525.25 $449,000.00 $0.00 $386,219.11 $62,780.89 86%$94,525.25 449,000.00 .00 .00 449,000.00 0%.00 449,000.00 .00 386,219.11 62,780.89 86%94,525.25 $0.00 $0.00 ($386,219.11)($386,219.11)+++($94,525.25) Income Statement Through 08/31/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Capital Project Funds Fund 187 - LIBRARY CAPITAL IMPROVEMENT FD REVENUE Department 48 - LIBRARY Other Revenue Department 48 - LIBRARY Totals REVENUE TOTALS EXPENSE Department 48 - LIBRARY Capital Outlay Department 48 - LIBRARY Totals Fund 187 - LIBRARY CAPITAL IMPROVEMENT FD Net Gain (Loss) EXPENSE TOTALS Fund 187 - LIBRARY CAPITAL IMPROVEMENT FD Totals REVENUE TOTALS EXPENSE TOTALS Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 13,936,263.00 .00 7,056,087.53 6,880,175.47 51 12,814,108.59 1,197,401.00 99,785.00 798,280.00 399,121.00 67 3,319,053.04 .00 351.69 (406.96)406.96 +++12,054,284.90 1,500.00 912.73 6,400.98 (4,900.98)427 24,864.03 $15,135,164.00 $101,049.42 $7,860,361.55 $7,274,802.45 52%$28,212,310.56 $15,135,164.00 $101,049.42 $7,860,361.55 $7,274,802.45 52%$28,212,310.56 .00 2.53 19.98 (19.98)+++133,807.04 15,133,666.00 .00 2,935,211.78 12,198,454.22 19 27,774,476.37 $15,133,666.00 $2.53 $2,935,231.76 $12,198,434.24 19%$27,908,283.41 $15,133,666.00 $2.53 $2,935,231.76 $12,198,434.24 19%$27,908,283.41 15,135,164.00 101,049.42 7,860,361.55 7,274,802.45 52%28,212,310.56 15,133,666.00 2.53 2,935,231.76 12,198,434.24 19%27,908,283.41 $1,498.00 $101,046.89 $4,925,129.79 $4,923,631.79 328,780%$304,027.15 Income Statement Through 08/31/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Capital Project Funds Fund 320 - DEBT SERVICE FUND REVENUE Department 99 - NON-DEPARTMENTAL Property Taxes Interfund Transfers Other Revenue Interest Income Department 99 - NON-DEPARTMENTAL Totals REVENUE TOTALS EXPENSE Department 99 - NON-DEPARTMENTAL Services and Supplies Debt Service Department 99 - NON-DEPARTMENTAL Totals EXPENSE TOTALS Fund 320 - DEBT SERVICE FUND Totals REVENUE TOTALS EXPENSE TOTALS Fund 320 - DEBT SERVICE FUND Net Gain (Loss) Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual .00 11,292.03 88,884.63 (88,884.63)+++.00 .00 .00 .00 .00 +++470,000.04 .00 .00 331,168.38 (331,168.38)+++.00 7,645,000.00 311,400.00 330,617.63 7,314,382.37 4 6,833,019.50 .00 518.01 7,892.71 (7,892.71)+++24,813.33 $7,645,000.00 $323,210.04 $758,563.35 $6,886,436.65 10%$7,327,832.87 .00 1,008.58 (1,577.88)1,577.88 +++18,170.77 .00 1.22 890.13 (890.13)+++61,116.40 $0.00 $1,009.80 ($687.75)$687.75 +++$79,287.17 $7,645,000.00 $324,219.84 $757,875.60 $6,887,124.40 10%$7,407,120.04 696,766.01 56,728.45 463,090.53 233,675.48 66 676,147.47 .00 27,427.34 828,077.41 (828,077.41)+++1,564,539.87 9,705,000.00 98,606.92 1,931,959.31 7,773,040.69 20 7,018,081.23 $10,401,766.01 $182,762.71 $3,223,127.25 $7,178,638.76 31%$9,258,768.57 .00 .00 .00 .00 +++85.00 .00 .00 .00 .00 +++290,000.00 $0.00 $0.00 $0.00 $0.00 +++$290,085.00 $10,401,766.01 $182,762.71 $3,223,127.25 $7,178,638.76 31%$9,548,853.57 7,645,000.00 324,219.84 757,875.60 6,887,124.40 10%7,407,120.04 10,401,766.01 182,762.71 3,223,127.25 7,178,638.76 31%9,548,853.57 ($2,756,766.01)$141,457.13 ($2,465,251.65)$291,514.36 89%($2,141,733.53) Income Statement Through 08/31/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Capital Project Funds Fund 415 - CAPITAL IMPROVEMENTS FUND REVENUE Department 40 - PUBLIC WORKS AGENCY Charges for Services Interfund Transfers Intergovernmental Revenue Other Revenue Interest Income Department 40 - PUBLIC WORKS AGENCY Totals Department 99 - NON-DEPARTMENTAL Other Revenue Interest Income Department 99 - NON-DEPARTMENTAL Totals REVENUE TOTALS EXPENSE Department 40 - PUBLIC WORKS AGENCY Salary and Benefits Services and Supplies Capital Outlay Department 40 - PUBLIC WORKS AGENCY Totals Department 99 - NON-DEPARTMENTAL Services and Supplies Interfund Transfers Department 99 - NON-DEPARTMENTAL Totals EXPENSE TOTALS Fund 415 - CAPITAL IMPROVEMENTS FUND Totals REVENUE TOTALS EXPENSE TOTALS Fund 415 - CAPITAL IMPROVEMENTS FUND Net Gain (Loss) Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual .00 .00 .00 .00 +++2,000,000.00 .00 .00 1,000,000.00 (1,000,000.00)+++.00 1,000,000.00 .00 2,200,000.00 (1,200,000.00)220 2,037,500.00 .00 1,221.58 8,025.71 (8,025.71)+++90,687.56 $1,000,000.00 $1,221.58 $3,208,025.71 ($2,208,025.71)321%$4,128,187.56 $1,000,000.00 $1,221.58 $3,208,025.71 ($2,208,025.71)321%$4,128,187.56 .00 5.00 6,309.13 (6,309.13)+++333,461.83 1,000,000.00 68,553.75 170,527.32 829,472.68 17 8,172,492.39 637,500.00 .00 .00 637,500.00 0 637,500.00 $1,637,500.00 $68,558.75 $176,836.45 $1,460,663.55 11%$9,143,454.22 $1,637,500.00 $68,558.75 $176,836.45 $1,460,663.55 11%$9,143,454.22 1,000,000.00 1,221.58 3,208,025.71 (2,208,025.71)321%4,128,187.56 1,637,500.00 68,558.75 176,836.45 1,460,663.55 11%9,143,454.22 ($637,500.00)($67,337.17)$3,031,189.26 $3,668,689.26 (475%)($5,015,266.66) Income Statement Through 08/31/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Capital Project Funds Fund 416 - CROWN CONSTRUCTION FUND REVENUE Department 40 - PUBLIC WORKS AGENCY Interfund Transfers Intergovernmental Revenue Other Revenue Interest Income Department 40 - PUBLIC WORKS AGENCY Totals REVENUE TOTALS EXPENSE Department 40 - PUBLIC WORKS AGENCY Services and Supplies Capital Outlay Interfund Transfers Department 40 - PUBLIC WORKS AGENCY Totals Fund 416 - CROWN CONSTRUCTION FUND Net Gain (Loss) EXPENSE TOTALS Fund 416 - CROWN CONSTRUCTION FUND Totals REVENUE TOTALS EXPENSE TOTALS Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 175,000.00 14,583.00 116,664.00 58,336.00 67 175,000.00 $175,000.00 $14,583.00 $116,664.00 $58,336.00 67%$175,000.00 $175,000.00 $14,583.00 $116,664.00 $58,336.00 67%$175,000.00 175,000.00 14,583.00 116,664.00 58,336.00 67%175,000.00 .00 .00 .00 .00 +++.00 $175,000.00 $14,583.00 $116,664.00 ($58,336.00)67%$175,000.00 Income Statement Through 08/31/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Capital Project Funds Fund 417 - CROWN COMMUNITY CTR MAINTENANCE REVENUE Department 40 - PUBLIC WORKS AGENCY Interfund Transfers Department 40 - PUBLIC WORKS AGENCY Totals Fund 417 - CROWN COMMUNITY CTR MAINTENANCE Net Gain (Loss) REVENUE TOTALS Fund 417 - CROWN COMMUNITY CTR MAINTENANCE Totals REVENUE TOTALS EXPENSE TOTALS Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 125,000.00 (990.87)61,249.68 63,750.32 49 168,414.88 30,000.00 8,027.55 11,600.39 18,399.61 39 35,236.30 $155,000.00 $7,036.68 $72,850.07 $82,149.93 47%$203,651.18 $155,000.00 $7,036.68 $72,850.07 $82,149.93 47%$203,651.18 .00 5.00 40.00 (40.00)+++60.00 .00 .00 .00 .00 +++.00 .00 .00 .00 .00 +++477,930.00 $0.00 $5.00 $40.00 ($40.00)+++$477,990.00 500,000.00 .00 .00 500,000.00 0 .00 489,314.00 40,777.00 326,216.00 163,098.00 67 .00 $989,314.00 $40,777.00 $326,216.00 $663,098.00 33%$0.00 $989,314.00 $40,782.00 $326,256.00 $663,058.00 33%$477,990.00 155,000.00 7,036.68 72,850.07 82,149.93 47%203,651.18 989,314.00 40,782.00 326,256.00 663,058.00 33%477,990.00 ($834,314.00)($33,745.32)($253,405.93)$580,908.07 30%($274,338.82) Income Statement Through 08/31/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Capital Project Funds Fund 420 - SPECIAL ASSESSMENT FUND REVENUE Department 26 - PUBLIC WORKS Other Taxes Interest Income Department 26 - PUBLIC WORKS Totals REVENUE TOTALS EXPENSE Department 26 - PUBLIC WORKS Services and Supplies Capital Outlay Interfund Transfers Department 26 - PUBLIC WORKS Totals Department 40 - PUBLIC WORKS AGENCY Capital Outlay Interfund Transfers Department 40 - PUBLIC WORKS AGENCY Totals EXPENSE TOTALS Fund 420 - SPECIAL ASSESSMENT FUND Totals REVENUE TOTALS EXPENSE TOTALS Fund 420 - SPECIAL ASSESSMENT FUND Net Gain (Loss) Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual .00 .00 150.00 (150.00)+++75.00 10,133,725.00 1,447,469.25 5,169,836.46 4,963,888.54 51 6,937,516.53 .00 .00 .00 .00 +++140,907.09 1,404,700.00 20,442.02 253,984.93 1,150,715.07 18 348,622.73 20,000.00 547.12 14,479.96 5,520.04 72 53,583.60 $11,558,425.00 $1,468,458.39 $5,438,451.35 $6,119,973.65 47%$7,480,704.95 .00 .00 .00 .00 +++2,831.29 $0.00 $0.00 $0.00 $0.00 +++$2,831.29 $11,558,425.00 $1,468,458.39 $5,438,451.35 $6,119,973.65 47%$7,483,536.24 255,033.38 15,234.93 149,324.22 105,709.16 59 270,658.21 $255,033.38 $15,234.93 $149,324.22 $105,709.16 59%$270,658.21 693,477.26 50,715.07 489,442.49 204,034.77 71 764,801.44 4,484,316.00 267,894.22 2,371,453.65 2,112,862.35 53 3,970,535.24 1,750,000.00 .00 119,308.32 1,630,691.68 7 8,004.00 351,502.00 29,292.00 234,336.00 117,166.00 67 350,666.04 .00 .00 .00 .00 +++2,899,592.72 47,164.00 .00 28,215.00 18,949.00 60 11,644.07 50,000.00 .00 .00 50,000.00 0 .00 3,132,390.00 261,032.00 2,088,256.00 1,044,134.00 67 4,631,907.00 $10,508,849.26 $608,933.29 $5,331,011.46 $5,177,837.80 51%$12,637,150.51 487,451.58 41,648.83 332,086.84 155,364.74 68 523,157.26 .00 .00 .00 .00 +++23,335.04 $487,451.58 $41,648.83 $332,086.84 $155,364.74 68%$546,492.30 $11,251,334.22 $665,817.05 $5,812,422.52 $5,438,911.70 52%$13,454,301.02 11,558,425.00 1,468,458.39 5,438,451.35 6,119,973.65 47%7,483,536.24 11,251,334.22 665,817.05 5,812,422.52 5,438,911.70 52%13,454,301.02 $307,090.78 $802,641.34 ($373,971.17)($681,061.95)(122%)($5,970,764.78) Income Statement Through 08/31/21 Summary Listing Classification Fund Category Proprietary Funds Fund Type Enterprise Funds Fund 505 - PARKING SYSTEM FUND REVENUE Department 19 - ADMINISTRATIVE SERVICES Licenses, Permits and Fees Charges for Services Interfund Transfers Other Revenue Interest Income Department 19 - ADMINISTRATIVE SERVICES Totals Department 40 - PUBLIC WORKS AGENCY Other Revenue Department 40 - PUBLIC WORKS AGENCY Totals REVENUE TOTALS EXPENSE Department 15 - CITY MANAGER'S OFFICE Salary and Benefits Department 15 - CITY MANAGER'S OFFICE Totals Department 19 - ADMINISTRATIVE SERVICES Salary and Benefits Services and Supplies Capital Outlay Insurance and Other Chargebacks Depreciation Expense Debt Service Miscellaneous Interfund Transfers Department 19 - ADMINISTRATIVE SERVICES Totals Department 40 - PUBLIC WORKS AGENCY Salary and Benefits Services and Supplies EXPENSE TOTALS Fund 505 - PARKING SYSTEM FUND Net Gain (Loss) Department 40 - PUBLIC WORKS AGENCY Totals EXPENSE TOTALS Fund 505 - PARKING SYSTEM FUND Totals REVENUE TOTALS Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 50,000.00 (1,002.10)47,824.90 2,175.10 96 61,116.67 23,006,700.00 1,697,228.04 13,302,915.25 9,703,784.75 58 23,591,431.45 19,629,150.00 1,674.15 422,187.50 19,206,962.50 2 298,660.82 70,000.00 1,444.06 33,014.14 36,985.86 47 71,542.67 $42,755,850.00 $1,699,344.15 $13,805,941.79 $28,949,908.21 32%$24,022,751.61 .00 .00 .00 .00 +++143,910.27 $0.00 $0.00 $0.00 $0.00 +++$143,910.27 $42,755,850.00 $1,699,344.15 $13,805,941.79 $28,949,908.21 32%$24,166,661.88 5,927,918.46 432,679.87 3,823,082.29 2,104,836.17 64 5,618,144.35 4,793,710.00 302,881.77 1,793,425.41 3,000,284.59 37 3,212,472.18 24,200.00 .00 .00 24,200.00 0 .00 .00 3,612.96 11,355.00 (11,355.00)+++.00 .00 .00 .00 .00 +++2,865,860.20 1,000.00 .00 .00 1,000.00 0 .00 15,000.00 .00 8,580.19 6,419.81 57 300.00 180,000.00 15,000.00 120,000.00 60,000.00 67 11,418,966.32 $10,941,828.46 $754,174.60 $5,756,442.89 $5,185,385.57 53%$23,115,743.05 .00 .00 .00 .00 +++(120,875.19) 1,539,653.00 128,304.00 1,026,432.00 513,221.00 67 1,513,955.00 2,318,294.00 .00 1,245,619.62 1,072,674.38 54 1,089,040.81 4,049,559.00 337,464.00 2,699,712.00 1,349,847.00 67 3,799,559.00 $7,907,506.00 $465,768.00 $4,971,763.62 $2,935,742.38 63%$6,281,679.62 $18,849,334.46 $1,219,942.60 $10,728,206.51 $8,121,127.95 57%$29,397,422.67 42,755,850.00 1,699,344.15 13,805,941.79 28,949,908.21 32%24,166,661.88 18,849,334.46 1,219,942.60 10,728,206.51 8,121,127.95 57%29,397,422.67 $23,906,515.54 $479,401.55 $3,077,735.28 ($20,828,780.26)13%($5,230,760.79) Income Statement Through 08/31/21 Summary Listing Classification Fund Category Proprietary Funds Fund Type Enterprise Funds Fund 510 - WATER FUND REVENUE Department 40 - PUBLIC WORKS AGENCY Licenses, Permits and Fees Charges for Services Other Revenue Interest Income Department 40 - PUBLIC WORKS AGENCY Totals Department 71 - UTILITIES Other Revenue Department 71 - UTILITIES Totals REVENUE TOTALS EXPENSE Department 40 - PUBLIC WORKS AGENCY Salary and Benefits Services and Supplies Capital Outlay Insurance and Other Chargebacks Depreciation Expense Contingencies Miscellaneous Interfund Transfers Department 40 - PUBLIC WORKS AGENCY Totals Department 71 - UTILITIES Salary and Benefits Insurance and Other Chargebacks Debt Service Interfund Transfers Department 71 - UTILITIES Totals EXPENSE TOTALS Fund 510 - WATER FUND Totals REVENUE TOTALS EXPENSE TOTALS Fund 510 - WATER FUND Net Gain (Loss) Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 1,500,000.00 3,851.74 173,549.60 1,326,450.40 12 1,060.49 24,068,000.00 739,465.10 4,295,281.29 19,772,718.71 18 420,882.76 .00 .00 .00 .00 +++(11,246,385.32) $25,568,000.00 $743,316.84 $4,468,830.89 $21,099,169.11 17%($10,824,442.07) $25,568,000.00 $743,316.84 $4,468,830.89 $21,099,169.11 17%($10,824,442.07) .00 .00 .00 .00 +++.00 25,568,000.00 743,316.84 4,468,830.89 21,099,169.11 17%(10,824,442.07) ($25,568,000.00)($743,316.84)($4,468,830.89)$21,099,169.11 17%$10,824,442.07 Income Statement Through 08/31/21 Summary Listing Classification Fund Category Proprietary Funds Fund Type Enterprise Funds Fund 513 - WATER DEPR IMPRV &EXTENSION FUND EXPENSE Department 71 - UTILITIES Services and Supplies Capital Outlay REVENUE TOTALS EXPENSE TOTALS Fund 513 - WATER DEPR IMPRV &EXTENSION FUND Net Gain (Loss) Interfund Transfers Department 71 - UTILITIES Totals EXPENSE TOTALS Fund 513 - WATER DEPR IMPRV &EXTENSION FUND Totals Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 10,375,408.00 796,215.83 6,447,235.49 3,928,172.51 62 10,242,065.74 2,001,000.00 895.63 (1,036.33)2,002,036.33 (0)385,501.29 25,000.00 434.06 2,636.99 22,363.01 11 15,110.87 $12,401,408.00 $797,545.52 $6,448,836.15 $5,952,571.85 52%$10,642,677.90 .00 .00 .00 .00 +++47,866.81 $0.00 $0.00 $0.00 $0.00 +++$47,866.81 $12,401,408.00 $797,545.52 $6,448,836.15 $5,952,571.85 52%$10,690,544.71 1,425,265.69 107,001.03 873,381.71 551,883.98 61 1,332,414.71 1,484,650.00 146,804.65 419,856.18 1,064,793.82 28 394,477.24 3,343,000.00 .00 117,444.02 3,225,555.98 4 .00 332,255.00 27,688.00 221,504.00 110,751.00 67 306,557.04 .00 .00 .00 .00 +++3,773,558.96 1,500.00 500.00 500.00 1,000.00 33 1,456.21 855,375.00 71,282.00 570,256.00 285,119.00 67 1,337,532.00 $7,442,045.69 $353,275.68 $2,202,941.91 $5,239,103.78 30%$7,145,996.16 .00 .00 .00 .00 +++60,949.08 5,195,191.00 293,312.74 3,161,903.77 2,033,287.23 61 726,343.24 $5,195,191.00 $293,312.74 $3,161,903.77 $2,033,287.23 61%$787,292.32 $12,637,236.69 $646,588.42 $5,364,845.68 $7,272,391.01 42%$7,933,288.48 12,401,408.00 797,545.52 6,448,836.15 5,952,571.85 52%10,690,544.71 12,637,236.69 646,588.42 5,364,845.68 7,272,391.01 42%7,933,288.48 ($235,828.69)$150,957.10 $1,083,990.47 $1,319,819.16 (460%)$2,757,256.23 Income Statement Through 08/31/21 Summary Listing Classification Fund Category Proprietary Funds Fund Type Enterprise Funds Fund 515 - SEWER FUND REVENUE Department 40 - PUBLIC WORKS AGENCY Charges for Services Other Revenue Interest Income Department 40 - PUBLIC WORKS AGENCY Totals Department 71 - UTILITIES Other Revenue Department 71 - UTILITIES Totals REVENUE TOTALS EXPENSE Department 40 - PUBLIC WORKS AGENCY Salary and Benefits Services and Supplies Capital Outlay Insurance and Other Chargebacks Depreciation Expense Miscellaneous Interfund Transfers Department 40 - PUBLIC WORKS AGENCY Totals Department 71 - UTILITIES Salary and Benefits Debt Service Department 71 - UTILITIES Totals Fund 515 - SEWER FUND Net Gain (Loss) EXPENSE TOTALS Fund 515 - SEWER FUND Totals REVENUE TOTALS EXPENSE TOTALS Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual .00 207.25 1,543.00 (1,543.00)+++2,184.00 $0.00 $207.25 $1,543.00 ($1,543.00)+++$2,184.00 1,332,500.00 .00 650,000.00 682,500.00 49 1,332,500.00 297,000.00 2,101.00 150,765.15 146,234.85 51 298,870.04 4,516,450.00 353,304.52 2,710,269.86 1,806,180.14 60 4,245,578.25 122,000.00 808.47 101,036.88 20,963.12 83 71,739.00 $6,267,950.00 $356,213.99 $3,612,071.89 $2,655,878.11 58%$5,948,687.29 $6,267,950.00 $356,421.24 $3,613,614.89 $2,654,335.11 58%$5,950,871.29 1,405,702.00 108,414.87 941,611.77 464,090.23 67 1,333,777.77 3,778,926.00 103,294.03 2,060,841.29 1,718,084.71 55 3,519,042.76 505,000.00 42,530.00 298,081.40 206,918.60 59 104,512.20 .00 .00 .00 .00 +++41,124.85 10,000.00 .00 7,409.40 2,590.60 74 8,143.41 302,000.00 25,167.00 201,336.00 100,664.00 67 322,362.00 $6,001,628.00 $279,405.90 $3,509,279.86 $2,492,348.14 58%$5,328,962.99 .00 .00 .00 .00 +++(13,022.26) $0.00 $0.00 $0.00 $0.00 +++($13,022.26) $6,001,628.00 $279,405.90 $3,509,279.86 $2,492,348.14 58%$5,315,940.73 6,267,950.00 356,421.24 3,613,614.89 2,654,335.11 58%5,950,871.29 6,001,628.00 279,405.90 3,509,279.86 2,492,348.14 58%5,315,940.73 $266,322.00 $77,015.34 $104,335.03 ($161,986.97)39%$634,930.56 Income Statement Through 08/31/21 Summary Listing Classification Fund Category Proprietary Funds Fund Type Enterprise Funds Fund 520 - SOLID WASTE FUND REVENUE Department 26 - PUBLIC WORKS Charges for Services Department 26 - PUBLIC WORKS Totals Department 40 - PUBLIC WORKS AGENCY Property Taxes Licenses, Permits and Fees Charges for Services Other Revenue Department 40 - PUBLIC WORKS AGENCY Totals REVENUE TOTALS EXPENSE Department 40 - PUBLIC WORKS AGENCY Salary and Benefits Services and Supplies Capital Outlay Depreciation Expense Miscellaneous Interfund Transfers Department 40 - PUBLIC WORKS AGENCY Totals Department 71 - UTILITIES Salary and Benefits Department 71 - UTILITIES Totals EXPENSE TOTALS Fund 520 - SOLID WASTE FUND Totals REVENUE TOTALS EXPENSE TOTALS Fund 520 - SOLID WASTE FUND Net Gain (Loss) Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 3,127,440.00 258,953.00 2,071,624.00 1,055,816.00 66 3,070,014.00 69,000.00 .00 2,719.84 66,280.16 4 14,453.78 1,000.00 .00 .00 1,000.00 0 .00 $3,197,440.00 $258,953.00 $2,074,343.84 $1,123,096.16 65%$3,084,467.78 $3,197,440.00 $258,953.00 $2,074,343.84 $1,123,096.16 65%$3,084,467.78 1,148,166.41 88,735.80 738,683.87 409,482.54 64 1,134,913.86 2,034,507.00 119,131.82 1,045,166.19 989,340.81 51 1,316,444.13 .00 .00 19,924.22 (19,924.22)+++3.92 .00 .00 17,589.46 (17,589.46)+++7,999.49 .00 .00 .00 .00 +++900.00 $3,182,673.41 $207,867.62 $1,821,363.74 $1,361,309.67 57%$2,460,261.40 $3,182,673.41 $207,867.62 $1,821,363.74 $1,361,309.67 57%$2,460,261.40 3,197,440.00 258,953.00 2,074,343.84 1,123,096.16 65%3,084,467.78 3,182,673.41 207,867.62 1,821,363.74 1,361,309.67 57%2,460,261.40 $14,766.59 $51,085.38 $252,980.10 $238,213.51 1,713%$624,206.38 Income Statement Through 08/31/21 Summary Listing Classification Fund Category Proprietary Funds Fund Type Internal Service Funds Fund 600 - FLEET SERVICES FUND REVENUE Department 19 - ADMINISTRATIVE SERVICES Charges for Services Other Revenue Interest Income Department 19 - ADMINISTRATIVE SERVICES Totals REVENUE TOTALS EXPENSE Department 19 - ADMINISTRATIVE SERVICES Salary and Benefits Services and Supplies Capital Outlay Insurance and Other Chargebacks Miscellaneous EXPENSE TOTALS Fund 600 - FLEET SERVICES FUND Net Gain (Loss) Department 19 - ADMINISTRATIVE SERVICES Totals EXPENSE TOTALS Fund 600 - FLEET SERVICES FUND Totals REVENUE TOTALS Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 224,885.00 18,739.00 149,912.00 74,973.00 67 1,479,425.00 1,060,217.00 .00 147,093.00 913,124.00 14 158,320.03 .00 .00 159.62 (159.62)+++432.99 $1,285,102.00 $18,739.00 $297,164.62 $987,937.38 23%$1,638,178.02 $1,285,102.00 $18,739.00 $297,164.62 $987,937.38 23%$1,638,178.02 .00 .00 69.90 (69.90)+++35,725.99 1,600,000.00 .00 977,096.02 622,903.98 61 648,105.00 $1,600,000.00 $0.00 $977,165.92 $622,834.08 61%$683,830.99 .00 .00 .00 .00 +++1,532,788.60 $0.00 $0.00 $0.00 $0.00 +++$1,532,788.60 $1,600,000.00 $0.00 $977,165.92 $622,834.08 61%$2,216,619.59 1,285,102.00 18,739.00 297,164.62 987,937.38 23%1,638,178.02 1,600,000.00 .00 977,165.92 622,834.08 61%2,216,619.59 ($314,898.00)$18,739.00 ($680,001.30)($365,103.30)216%($578,441.57) Income Statement Through 08/31/21 Summary Listing Classification Fund Category Proprietary Funds Fund Type Internal Service Funds Fund 601 - EQUIPMENT REPLACEMENT FUND REVENUE Department 19 - ADMINISTRATIVE SERVICES Charges for Services Other Revenue Interest Income Department 19 - ADMINISTRATIVE SERVICES Totals REVENUE TOTALS EXPENSE Department 19 - ADMINISTRATIVE SERVICES Services and Supplies Capital Outlay Department 19 - ADMINISTRATIVE SERVICES Totals Department 26 - PUBLIC WORKS Depreciation Expense EXPENSE TOTALS Fund 601 - EQUIPMENT REPLACEMENT FUND Net Gain (Loss) Department 26 - PUBLIC WORKS Totals EXPENSE TOTALS Fund 601 - EQUIPMENT REPLACEMENT FUND Totals REVENUE TOTALS Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual .00 .00 830.44 (830.44)+++247,262.46 .00 .00 .00 .00 +++2,000,000.00 10,402,039.00 831,949.25 6,715,465.03 3,686,573.97 65 9,707,994.97 1,475,000.00 132,246.26 978,489.40 496,510.60 66 2,876,171.13 8,890,677.00 706,992.82 6,053,649.26 2,837,027.74 68 6,492,580.46 $20,767,716.00 $1,671,188.33 $13,748,434.13 $7,019,281.87 66%$21,324,009.02 $20,767,716.00 $1,671,188.33 $13,748,434.13 $7,019,281.87 66%$21,324,009.02 662,619.98 44,505.41 409,008.06 253,611.92 62 618,397.39 2,914,200.00 37,441.89 1,425,148.35 1,489,051.65 49 3,465,872.47 16,641,267.00 1,257,023.84 10,551,755.96 6,089,511.04 63 14,110,030.08 .00 .00 .00 .00 +++300.00 $20,218,086.98 $1,338,971.14 $12,385,912.37 $7,832,174.61 61%$18,194,599.94 $20,218,086.98 $1,338,971.14 $12,385,912.37 $7,832,174.61 61%$18,194,599.94 20,767,716.00 1,671,188.33 13,748,434.13 7,019,281.87 66%21,324,009.02 20,218,086.98 1,338,971.14 12,385,912.37 7,832,174.61 61%18,194,599.94 $549,629.02 $332,217.19 $1,362,521.76 $812,892.74 248%$3,129,409.08 Income Statement Through 08/31/21 Summary Listing Classification Fund Category Proprietary Funds Fund Type Internal Service Funds Fund 605 - INSURANCE FUND REVENUE Department 99 - NON-DEPARTMENTAL Charges for Services Interfund Transfers Other Revenue Workers Compensation and Liability Insurance Department 99 - NON-DEPARTMENTAL Totals REVENUE TOTALS EXPENSE Department 99 - NON-DEPARTMENTAL Salary and Benefits Services and Supplies Insurance and Other Chargebacks Miscellaneous Department 99 - NON-DEPARTMENTAL Totals EXPENSE TOTALS Fund 605 - INSURANCE FUND Totals REVENUE TOTALS EXPENSE TOTALS Fund 605 - INSURANCE FUND Net Gain (Loss) Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 11,815,000.00 (553,863.06)13,722,490.58 (1,907,490.58)116 19,601,260.66 2,500,000.00 180,554.93 1,280,154.75 1,219,845.25 51 2,174,018.22 $14,315,000.00 ($373,308.13)$15,002,645.33 ($687,645.33)105%$21,775,278.88 $14,315,000.00 ($373,308.13)$15,002,645.33 ($687,645.33)105%$21,775,278.88 10,805,300.00 886,516.38 7,119,664.04 3,685,635.96 66 10,399,738.82 225,000.00 8,843.07 144,275.62 80,724.38 64 148,468.04 $11,030,300.00 $895,359.45 $7,263,939.66 $3,766,360.34 66%$10,548,206.86 $11,030,300.00 $895,359.45 $7,263,939.66 $3,766,360.34 66%$10,548,206.86 14,315,000.00 (373,308.13)15,002,645.33 (687,645.33)105%21,775,278.88 11,030,300.00 895,359.45 7,263,939.66 3,766,360.34 66%10,548,206.86 $3,284,700.00 ($1,268,667.58)$7,738,705.67 $4,454,005.67 236%$11,227,072.02 Income Statement Through 08/31/21 Summary Listing Classification Fund Category Fiduciary Funds Fund Type Pension Trust Funds Fund 700 - FIRE PENSION FUND REVENUE Department 23 - FIRE MGMT & SUPPORT Other Revenue Interest Income Department 23 - FIRE MGMT & SUPPORT Totals REVENUE TOTALS EXPENSE Department 23 - FIRE MGMT & SUPPORT Salary and Benefits REVENUE TOTALS EXPENSE TOTALS Fund 700 - FIRE PENSION FUND Net Gain (Loss) Miscellaneous Department 23 - FIRE MGMT & SUPPORT Totals EXPENSE TOTALS Fund 700 - FIRE PENSION FUND Totals Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 18,214,700.00 2,572,614.43 25,783,546.49 (7,568,846.49)142 28,106,377.21 1,500,000.00 242,653.61 2,116,692.04 (616,692.04)141 2,579,448.58 $19,714,700.00 $2,815,268.04 $27,900,238.53 ($8,185,538.53)142%$30,685,825.79 $19,714,700.00 $2,815,268.04 $27,900,238.53 ($8,185,538.53)142%$30,685,825.79 14,326,000.00 1,336,006.29 9,881,733.09 4,444,266.91 69 13,459,230.47 375,000.00 50,562.06 265,551.95 109,448.05 71 399,999.29 $14,701,000.00 $1,386,568.35 $10,147,285.04 $4,553,714.96 69%$13,859,229.76 $14,701,000.00 $1,386,568.35 $10,147,285.04 $4,553,714.96 69%$13,859,229.76 19,714,700.00 2,815,268.04 27,900,238.53 (8,185,538.53)142%30,685,825.79 14,701,000.00 1,386,568.35 10,147,285.04 4,553,714.96 69%13,859,229.76 $5,013,700.00 $1,428,699.69 $17,752,953.49 $12,739,253.49 354%$16,826,596.03 Income Statement Through 08/31/21 Summary Listing Classification Fund Category Fiduciary Funds Fund Type Pension Trust Funds Fund 705 - POLICE PENSION FUND REVENUE Department 22 - POLICE Other Revenue Interest Income Department 22 - POLICE Totals REVENUE TOTALS EXPENSE Department 22 - POLICE Salary and Benefits Miscellaneous Department 22 - POLICE Totals EXPENSE TOTALS Fund 705 - POLICE PENSION FUND Totals REVENUE TOTALS EXPENSE TOTALS Fund 705 - POLICE PENSION FUND Net Gain (Loss)