Loading...
2021.08 Monthly Budget ReportO R ORCHARD MONTHLY BUDGET FINANCIAL STATUS UPDATE To: Mayor and Council members From: Noah Crocker, Finance Director Period: August 2021 OVERVIEW: The Finance Department is committed to providing clear information to the Mayor, Council, and staff regarding the budget status of the City. We have prepared the following reports to keep you up to date on the current budget status of the City. 1) Budget Report 2) Detail Fund Summary Report BUDGET REPORT: The Budget report will first provide Operational Funds and follow up with Capital Projects Funds. This report does not include beginning fund balance. This report is designed to provide a high-level view of each fund reviewing total revenues and expenses. The report does provide expense information by department. The goal of the City is to pay all current budget year expenses with current budget year revenues. We are not quite there yet, and this will show in the Surplus (Deficit) line at the end of each fund. We expect that future budget cycles will smooth out revenues and expenditures. The Budget Report provides information on current revenues and expenditures by fund including the following: • The original budgeted amount. • Current budget which would reflect any amendments that have been made. • Period activity which details the revenue and expense activity for the period in which the report was run. • Fiscal activity will provide the year-to-date expense and revenue amounts. • Variance Shows the difference between budgeted and actual. • Percent remaining is the amount still needed to reach the budgeted amount. CASH AND INVESTMENT FUND SUMMARY The Cash and Investment Fund Summary provides information on current total cash & investment balances by Fund. POINTS OF INTEREST: Current Expense Fund 001 — The Current Expense Fund is used for the general governmental functions of the City. As of August 31st, 2021, 94% of budgeted revenues were received. To date revenue is trending higher than expected. Of particular importance, the City received $1,410,539 from the American Rescue Plan Coronavirus State & Local Fiscal Recovery Funds (SLFRF) identified in Intergovernmental Revenue. The table provides budget versus actual (YTD) data by source of revenue. 10,695 621,368 136,999 769,062 165,967 105 55,624 13,897 13,351 894 1 1.018.901 1 SALES TAX REVENUES SUMMARY • Total 2021 Budget: $5,235,000 • Total 2021 YTD Actuals: $4,486,698 • Year -to -Date Actual revenue collected is 24% higher when compared to Prior Year -to Date Actuals • Year -to -Date Actual revenue collected is 32% higher when compared to Year -to Date Budgeted The following tables provide additional sales tax information: Table 1: shows revenue received by month over a three - Monthly Sales Tax -Three Year Comparison 700,000 600,000 500000 ■ 2019 Actual 400,000 ■ 2020 Actual 300,000 •2021 YTD Actual 200,000 100,000 0 Table 2: provides current data for sales tax revenue collected Year-to-date. $700,000 Sales Tax Revenues Actuals 2021 $600,000 $500,000 $400,000 $300,000 Budget 2021 $200,000 $100,000 a(� all t�C` ��� a� ire ,��� �5� 'C i 3p 1,06 Gie � O Real Estate Excise Tax (REET) Fund 109 and Impact Mitigation Fee Fund 111 The City's Real Estate Excise Tax receipts fluctuate monthly. 2021 REET revenue is currently coming in significantly higher (158%) than the same period in prior years. August 2021 receipts are higher than August 2020 by 65%. The table below shows balances through August for REET 1 & 2 and Impact fees. These restricted funds are used as a local funding source for capital projects that have been documented in the City's comprehensive plans. REET funds are also used for debt aavments. .. -'"REET 7 RE ET Transport.. B rtation REEJTJ Reserve �� Bethel (Fund Reserve Impact Impact Plat SEPA JML Admissions ,rRecreation Tax , 2021-2022 Beginning Balance 785,820 255,009 326,495 944,142 1,625,464 1,641,128 118,202 - 2021-2022 Revenue Received* 31,457 58,761 567 287,792 776,819 1,454,178 3,750 234,233 2021-2022 Expenses Budgeted (550,000) (115,000) - (500,000)' (393,000) (1,198,200) (90,000) - 2021-2022Obligated Expenses (267,277) (198,770) (327,062) (743,509) (1,710,500) (585,500) - - 2021-2022 Ending Balance 0 0 0 (11,574) 298,782 1,311,607 31,953 234,233 The table above shows 2021 beginning fund balances, biennial revenue received to date, expenses budgeted for the biennium and expenses which are obligated for future projects but have not yet been officially budgeted. The intent of this table is to snapshot and illustrate available balances and what is projected for the end of the biennium. As identified in this table all funding sources have been either budgeted or obligated. Impact Fees received for August 2021 are as follows: o McCormick Woods Transportation $0 o Parks $17,745 o Transportation $91,202 REET revenues received in August: o REET 1 $70,957 o REET 2 $70,957 o REET 2-Transfer In-$677,331 Capital Construction Fund 302 — The design of the McCormick Woods Splash Pad was completed by Land Expressions, LLC. Murray Smith value engineered the design to meet the project budget constraints and is working on completing the engineering to be ad ready. Rice Fergus Miller is currently working on the City Hall design. Street Capital Construction Fund 304 — The project closeout of Tremont is almost complete. TIB has accepted the project and the acceptance from WSDOT is in progress. Bay Street Pedestrian Path right of way efforts continue. The City has contracted with Skillings Inc for Design and Right of Way Services for the Bethel -Lincoln Round -About project. Design for the project has begun. ENTERPRISE/UTILITY FUNDS: Water operation - Water operations budgeted revenue in the amount of $3,344,700 for 2021. Through August, the city has received $2,492,274 or —75% of the budgeted revenues. Revenues for the water utility, in winter and spring, are typically lower with larger monthly revenues received during the warmer summer and fall months. Water Operations expended $1,554,878 through August representing —54% of the 2021 budget. In addition, the water operational budget includes transfers which occur throughout the year. The City manages its transfers according to policy goals, cashflow needs, and realized expenses for water capital projects, stabilization targets, and debt service payments. The 2021 budget includes $1,206,500 for transfers. A transfer in the amount of $21,958 was recorded in August for the water stabilization fund. 450,000 400,000 350,000 300,000 250,000 200,000 150,000 100,000 50,000 Water Service Payments Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec ■ 2019 ■ 2020 ■ 2021 Sewer operation - $5,418,800 is budgeted for Sewer Operational Revenues for 2021. Through the month of August $3,895,234 was received representing —72% of the 2021 budgeted revenues. Sewer Operations expended $2,614,230 through August representing —67% of the 2021 budget. The sewer operational expense budget includes transfers which occur throughout the year. The City manages its transfers according to policy goals, cashflow needs, and realized expenses for sewer capital projects, stabilization targets, and debt service payments. The 2021 budget includes $374,150 for transfers. A transfer in the amount of $31,179 were recorded in August for the Sewer stabilization fund. 600,000 500,000 400,000 300,000 200,000 100,000 Sewer Service Payments Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov ❑ec ■ 2019 2020 ■ 2021 Storm Drainage operations -As of the end of August the Storm Drainage utility has received $1,341,141 or —82% of its annual budgeted revenue. Storm Drainage Operations expended $985,180 through August representing —55% of the 2021 operating budget. The storm drainage operational budget includes transfers which occur throughout the year. The City manages its transfers according to policy goals, cashflow needs, and realized expenses for storm capital projects, stabilization targets, and debt service payments. The 2021 budget includes $342,150 for transfers. A transfer in the amount of $13,670 was recorded for the storm stabilization fund and a transfer for debt service related to the Tremont Project for $143,702 was recorded in August. 180,000 160,000 140,000 120,000 100,000 80,000 60,000 40,000 20,000 Storm Drainage Payments Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov ❑ec ■ 2019 ■ 2020 ■ 2021 Budget Report City of Port Orchard OPERATIONS Group Summary ORCHARDFor Fiscal: 2021 Period Ending: 08/31/2021 Variance Original Current Period Fiscal Favorable Percent Departmen... Total Budget Total Budget Activity Activity (Unfavorable) Remaining Fund: 001-Current Expense Revenue 00 - Revenues 11,127,500.00 11,127,500.00 1,018,900.56 10,503,220.32 -624,279.68 5.61 % Revenue Total: 11,127,500.00 11,127,500.00 1,018,900.56 10,503,220.32 -624,279.68 5.61 % Expense 01- Finance 845,484.17 845,484.17 56,609.63 498,394.94 347,089.23 41.05 % 02 - Court 745,605.24 745,605.24 33,663.77 299,363.17 446,242.07 59.85 % 03 - Law Enforcement 5,087,610.55 5,087,610.55 318,851.33 2,670,795.18 2,416,815.37 47.50 % 04 - Community Development 1,955,200.27 1,955,200.27 151,824.59 1,214,531.12 740,669.15 37.88 % 05 - Public Works 1,503,800.42 1,503,800.42 98,847.54 936,272.31 567,528.11 37.74 % 06 - Miscellaneous 475,000.00 475,000.00 112.50 465,703.64 9,296.36 1.96 % 07-Administration 1,541,199.35 1,541,199.35 116,626.23 910,548.66 630,650.69 40.92% Expense Total: 12,153,900.00 12,153,900.00 776,535.59 6,995,609.02 5,158,290.98 42.44 % Fund: 001 - Current Expense Surplus (Deficit): -1,026,400.00 -1,026,400.00 242,364.97 3,507,611.30 4,534,011.30 441.74 % Fund: 002 - City Street Fund Revenue 00 - Revenues 2,080,700.00 2,080,700.00 53,656.10 1,275,172.98 -805,527.02 38.71 % Revenue Total: 2,080,700.00 2,080,700.00 53,656.10 1,275,172.98 -805,527.02 38.71 % Expense 05 - Public Works 2,393,500.00 2,393,500.00 200,477.82 1,069,812.25 1,323,687.75 55.30 % Expense Total: 2,393,500.00 2,393,500.00 200,477.82 1,069,812.25 1,323,687.75 55.30 % Fund: 002 - City Street Fund Surplus (Deficit): -312,800.00 -312,800.00 -146,821.72 205,360.73 518,160.73 165.65 % Fund: 003 - Stabilization Fund Revenue 00 - Revenues 200,000.00 200,000.00 159.07 201,722.20 1,722.20 0.86 % Revenue Total: 200,000.00 200,000.00 159.07 201,722.20 1,722.20 0.86 % Fund: 003 - Stabilization Fund Total: 200,000.00 200,000.00 159.07 201,722.20 1,722.20 0.86 % Fund: 103 - Criminal Justice Revenue 00 - Revenues 244,800.00 244,800.00 28,945.82 256,376.99 11,576.99 4.73 % Revenue Total: 244,800.00 244,800.00 28,945.82 256,376.99 11,576.99 4.73 % Expense 03 - Law Enforcement 284,800.00 284,800.00 13,411.57 158,029.14 126,770.86 44.51 % Expense Total: 284,800.00 284,800.00 13,411.57 158,029.14 126,770.86 44.51 % Fund: 103 - Criminal Justice Surplus (Deficit): -40,000.00 -40,000.00 15,534.25 98,347.85 138,347.85 345.87 % Fund: 104 - Special Investigative Unit Revenue 00 - Revenues 4,000.00 4,000.00 19.55 452.39 -3,547.61 88.69 % Revenue Total: 4,000.00 4,000.00 19.55 452.39 -3,547.61 88.69 % Expense 03 - Law Enforcement 4,000.00 4,000.00 300.00 359.79 3,640.21 91.01 % Expense Total: 4,000.00 4,000.00 300.00 359.79 3,640.21 91.01 % Fund: 104 - Special Investigative Unit Surplus (Deficit): 0.00 0.00 -280.45 92.60 92.60 0.00 % Fund: 107 - Community Events Revenue 00 - Revenues 100,000.00 100,000.00 12,610.94 70,242.89 -29,757.11 29.76 % Revenue Total: 100,000.00 100,000.00 12,610.94 70,242.89 -29,757.11 29.76 % 9/13/2021 9:38:37 AM Page 1 of 5 Budget Report For Fiscal: 2021 Period Ending: 08/31/2021 Variance Original Current Period Fiscal Favorable Percent Departmen... Total Budget Total Budget Activity Activity (Unfavorable) Remaining Expense 07-Administration 109,700.00 109,700.00 1,821.82 15,349.84 94,350.16 86.01% Expense Total: 109,700.00 109,700.00 1,821.82 15,349.84 94,350.16 86.01 % Fund: 107 - Community Events Surplus (Deficit): -9,700.00 -9,700.00 10,789.12 54,893.05 64,593.05 665.91 % Fund: 108 - Paths & Trails Revenue 00 - Revenues 1,000.00 1,000.00 104.57 751.81 -248.19 24.82 % Revenue Total: 1,000.00 1,000.00 104.57 751.81 -248.19 24.82% Fund: 108 - Paths & Trails Total: 1,000.00 1,000.00 104.57 751.81 -248.19 24.82 % Fund: 109 - Real Estate Excise Tax Revenue 00 - Revenues 1,377,400.00 1,377,400.00 820,370.63 2,230,996.89 853,596.89 61.97 % Revenue Total: 1,377,400.00 1,377,400.00 820,370.63 2,230,996.89 853,596.89 61.97 % Expense 06 - Miscellaneous 1,292,900.00 1,292,900.00 266,875.70 370,238.62 922,661.38 71.36 % Expense Total: 1,292,900.00 1,292,900.00 266,875.70 370,238.62 922,661.38 71.36 % Fund: 109 - Real Estate Excise Tax Surplus (Deficit): 84,500.00 84,500.00 553,494.93 1,860,758.27 1,776,258.27-2,102.08 % Fund: 111 - Impact Mitigation Fee Revenue 00 - Revenues 140,000.00 140,000.00 109,367.32 378,578.13 238,578.13 170.41 % Revenue Total: 140,000.00 140,000.00 109,367.32 378,578.13 238,578.13 170.41 % Expense 05 - Public Works 50,000.00 50,000.00 0.00 28,111.20 21,888.80 43.78 % 06 - Miscellaneous 865,000.00 865,000.00 40,877.61 229,370.69 635,629.31 73.48 % Expense Total: 915,000.00 915,000.00 40,877.61 257,481.89 657,518.11 71.86 % Fund: 111 - Impact Mitigation Fee Surplus (Deficit): -775,000.00 -775,000.00 68,489.71 121,096.24 896,096.24 115.63 % Fund: 206 - Bond Redemption Fund Revenue 00 - Revenues 299,900.00 299,900.00 266,875.70 299,751.40 -148.60 0.05 % Revenue Total: 299,900.00 299,900.00 266,875.70 299,751.40 -148.60 0.05 % Expense 06 - Miscellaneous 299,900.00 299,900.00 266,875.70 299,751.40 148.60 0.05 % Expense Total: 299,900.00 299,900.00 266,875.70 299,751.40 148.60 0.05 % Fund: 206 - Bond Redemption Fund Surplus (Deficit): 0.00 0.00 0.00 0.00 0.00 0.00 % Fund: 411 - Water Operating Revenue 00 - Revenues 3,344,700.00 3,344,700.00 467,431.17 2,492,274.87 -852,425.13 25.49 % Revenue Total: 3,344,700.00 3,344,700.00 467,431.17 2,492,274.87 -852,425.13 25.49 % Expense 05 - Public Works 2,889,600.00 2,889,600.00 205,592.43 1,554,878.57 1,334,721.43 46.19 % 06 - Miscellaneous 1,206,500.00 1,206,500.00 21,958.00 267,301.98 939,198.02 77.84 % Expense Total: 4,096,100.00 4,096,100.00 227,550.43 1,822,180.55 2,273,919.45 55.51 % Fund: 411 - Water Operating Surplus (Deficit): -751,400.00 -751,400.00 239,880.74 670,094.32 1,421,494.32 189.18 % Fund: 412 - Water Stabilization Revenue 00 - Revenues 263,500.00 263,500.00 21,994.62 176,002.64 -87,497.36 33.21 % Revenue Total: 263,500.00 263,500.00 21,994.62 176,002.64 -87,497.36 33.21 % Fund: 412 - Water Stabilization Total: 263,500.00 263,500.00 21,994.62 176,002.64 -87,497.36 33.21 % Fund: 414 - Water Debt Service Revenue 00 - Revenues 485,125.00 485,125.00 0.00 4,950.00 -480,175.00 98.98 % Revenue Total: 485,125.00 485,125.00 0.00 4,950.00 -480,175.00 98.98 % 9/13/2021 9:38:37 AM Page 2 of 5 Budget Report For Fiscal: 2021 Period Ending: 08/31/2021 Variance Original Current Period Fiscal Favorable Percent Departmen... Total Budget Total Budget Activity Activity (Unfavorable) Remaining Expense 06 - Miscellaneous 485,125.00 485,125.00 0.00 4,950.00 480,175.00 98.98 % Expense Total: 485,125.00 485,125.00 0.00 4,950.00 480,175.00 98.98 % Fund: 414 - Water Debt Service Surplus (Deficit): 0.00 0.00 0.00 0.00 0.00 0.00 % Fund: 421 - Storm Drainage Utility Revenue 00 - Revenues 1,652,100.00 1,652,100.00 167,711.23 1,341,141.86 -310,958.14 18.82 % Revenue Total: 1,652,100.00 1,652,100.00 167,711.23 1,341,141.86 -310,958.14 18.82% Expense 05 - Public Works 1,773,850.00 1,773,850.00 164,985.41 985,180.15 788,669.85 44.46 % 06-Miscellaneous 342,150.00 342,150.00 157,372.30 287,292.92 54,857.08 16.03% Expense Total: 2,116,000.00 2,116,000.00 322,357.71 1,272,473.07 843,526.93 39.86 % Fund: 421 - Storm Drainage Utility Surplus (Deficit): -463,900.00 -463,900.00 -154,646.48 68,668.79 532,568.79 114.80 % Fund: 422 - Storm Drainage Stabilization Revenue 00 - Revenues 164,000.00 164,000.00 13,688.44 109,524.47 -54,475.53 33.22 % Revenue Total: 164,000.00 164,000.00 13,688.44 109,524.47 -54,475.53 33.22 % Fund: 422 - Storm Drainage Stabilization Total: 164,000.00 164,000.00 13,688.44 109,524.47 -54,475.53 33.22 % Fund: 424 - Storm Drainage Debt Service Revenue 00 - Revenues 178,100.00 178,100.00 143,702.30 177,929.92 -170.08 0.10 % Revenue Total: 178,100.00 178,100.00 143,702.30 177,929.92 -170.08 0.10 % Expense 06 - Miscellaneous 178,100.00 178,100.00 143,702.30 177,929.92 170.08 0.10 % Expense Total: 178,100.00 178,100.00 143,702.30 177,929.92 170.08 0.10 % Fund: 424 - Storm Drainage Debt Service Surplus (Deficit): 0.00 0.00 0.00 0.00 0.00 0.00 % Fund: 431 - Sewer Operating Revenue 00 - Revenues 5,418,800.00 5,418,800.00 513,497.88 3,895,234.40 -1,523,565.60 28.12 % Revenue Total: 5,418,800.00 5,418,800.00 513,497.88 3,895,234.40 -1,523,565.60 28.12 % Expense 05 - Public Works 3,901,150.00 3,901,150.00 277,197.83 2,614,229.35 1,286,920.65 32.99 % 06 - Miscellaneous 374,150.00 374,150.00 31,179.00 273,611.51 100,538.49 26.87 % Expense Total: 4,275,300.00 4,275,300.00 308,376.83 2,887,840.86 1,387,459.14 32.45 % Fund: 431 - Sewer Operating Surplus (Deficit): 1,143,500.00 1,143,500.00 205,121.05 1,007,393.54 -136,106.46 11.90 % Fund: 432 - Sewer Stabilization Revenue 00 - Revenues 374,150.00 374,150.00 31,234.75 249,953.44 -124,196.56 33.19 % Revenue Total: 374,150.00 374,150.00 31,234.75 249,953.44 -124,196.56 33.19 % Fund: 432 - Sewer Stabilization Total: 374,150.00 374,150.00 31,234.75 249,953.44 -124,196.56 33.19 % Fund: 434 - Sewer Debt Service Revenue 00 - Revenues 275,000.00 275,000.00 0.00 0.00 -275,000.00 100.00 % Revenue Total: 275,000.00 275,000.00 0.00 0.00 -275,000.00 100.00 % Fund: 434 - Sewer Debt Service Total: 275,000.00 275,000.00 0.00 0.00 -275,000.00 100.00 % Fund: 500 - Equipment Rental and Revolving Revenue 00 - Revenues 671,500.00 671,500.00 29,496.44 535,920.15 -135,579.85 20.19 % Revenue Total: 671,500.00 671,500.00 29,496.44 535,920.15 -135,579.85 20.19 % Expense 10 - ER&R 977,000.00 977,000.00 29,263.48 317,519.30 659,480.70 67.50 % 9/13/2021 9:38:37 AM Page 3 of 5 Budget Report For Fiscal: 2021 Period Ending: 08/31/2021 Variance Original Current Period Fiscal Favorable Percent Departmen... Total Budget Total Budget Activity Activity (Unfavorable) Remaining Expense Total: 977,000.00 977,000.00 29,263.48 317,519.30 659,480.70 67.50 % Fund: 500 - Equipment Rental and Revolving Surplus (Deficit):-305,500.00-305,500.00 232.96 218,400.85 523,900.85 171.49 % Report Surplus (Deficit):-1,179,050.00-1,179,050.00 1,101,340.53 8,550,672.10 9,729,722.10 825.22 % 9/13/2021 9:38:37 AM Page 4 of 5 Budget Report City of Port Orchard CAPITAL Group Summary ORCHARDFor Fiscal: 2021 Period Ending: 08/31/2021 Variance Original Current Period Fiscal Favorable Percent Account Typ... Total Budget Total Budget Activity Activity (Unfavorable) Remaining Fund: 302 - Capital Construction Revenue 620,000.00 620,000.00 572.30 100,854.59 -519,145.41 83.73 % Expense 405,000.00 405,000.00 560.00 119,462.63 285,537.37 70.50 % Fund: 302 - Capital Construction Surplus (Deficit): 215,000.00 215,000.00 12.30 -18,608.04 -233,608.04 108.65 % Fund: 304 - Street Capital Projects Revenue 3,638,100.00 3,638,100.00 40,452.12 904,413.09 -2,733,686.91 75.14 % Expense 2,956,100.00 2,956,100.00 726,171.81 951,256.47 2,004,843.53 67.82 % Fund: 304 - Street Capital Projects Surplus (Deficit): 682,000.00 682,000.00 -685,719.69 -46,843.38 -728,843.38 106.87 % Fund: 413 - Water Capital Revenue 5,995,100.00 5,995,100.00 1,912,876.53 4,556,226.70 -1,438,873.30 24.00 % Expense 3,012,200.00 3,012,200.00 -3.78 336,115.25 2,676,084.75 88.84 % Fund: 413 - Water Capital Surplus (Deficit): 2,982,900.00 2,982,900.00 1,912,880.31 4,220,111.45 1,237,211.45 -41.48 % Fund: 423 - Storm Drainage Capital Facil Revenue 30,100.00 30,100.00 6.64 72.65 -30,027.35 99.76 % Fund: 423 - Storm Drainage Capital Facil Total: 30,100.00 30,100.00 6.64 72.65 -30,027.35 99.76 % Fund: 433 - Sewer Capital Revenue 3,311,300.00 3,311,300.00 852,491.37 1,546,832.72 -1,764,467.28 53.29 % Expense 1,999,300.00 1,999,300.00 33,811.73 375,955.65 1,623,344.35 81.20 % Fund: 433 - Sewer Capital Surplus (Deficit): 1,312,000.00 1,312,000.00 818,679.64 1,170,877.07 -141,122.93 10.76 % Report Surplus (Deficit): 5,222,000.00 5,222,000.00 2,045,859.20 5,325,609.75 103,609.75 -1.98 % 9/13/2021 9:42:02 AM Page 1 of 2 Detail Report Cash & Investments Date Range: 08/01/2021- 08/31/2021 Fund Summary Fund Beginning Balance Total Activity Ending Balance 001 - Current Expense 10,205,058.15 242,364.97 10,447,423.12 002 - City Street Fund 1,831,473.46 -146,821.72 1,684,651.74 003 - Stabilization Fund 2,335,250.18 159.07 2,335,409.25 103 - Criminal Justice 460,421.47 15,534.25 475,955.72 104 - Special Investigative Unit 97,169.94 -280.45 96,889.49 107 - Community Events 256,105.94 10,789.12 266,895.06 108 - Paths & Trails 11,743.69 104.57 11,848.26 109 - Real Estate Excise Tax 4,573,855.21 553,494.93 5,127,350.14 111 - Impact Mitigation Fee 2,364,073.03 68,489.71 2,432,562.74 206 - Bond Redemption Fund 0.00 0.00 0.00 302 - Capital Construction 220,086.93 12.30 220,099.23 304 - Street Capital Projects 2,371,391.40 -685,719.69 1,685,671.71 401- Water -Sewer Utilities 0.00 0.00 0.00 403 - Water -Sewer Cumulative Reserve 0.00 0.00 0.00 411 - Water Operating 3,434,676.09 239,880.74 3,674,556.83 412 -Water Stabilization 545,968.90 21,994.62 567,963.52 413 - Water Capital 3,689,585.11 1,912,880.31 5,602,465.42 414 - Water Debt Service 0.00 0.00 0.00 421 - Storm Drainage Utility 2,256,334.97 -154,646.48 2,101,688.49 422 - Storm Drainage Stabilization 274,916.65 13,688.44 288,605.09 423 - Storm Drainage Capital Facil 99,178.96 6.64 99,185.60 424 - Storm Drainage Debt Service 0.00 0.00 0.00 431 - Sewer Operating 3,675,873.81 205,121.05 3,880,994.86 432 - Sewer Stabilization 831,309.36 31,234.75 862,544.11 433 - Sewer Capital 2,721,247.26 818,679.64 3,539,926.90 434 - Sewer Debt Service 0.00 0.00 0.00 500 - Equipment Rental and Revolving 3,711,397.81 232.96 3,711,630.77 631 - Trust and Agency 8,156.25 3,351.26 11,507.51 632 - Wastewater Treatment Facil Fee 3,327,099.16 643,285.77 3,970,384.93 Grand Total: 49,302,373.73 3,793,836.76 53,096,210.49 9/13/2021 9:49:01 AM Page 5 of 5