Loading...
2019.11 Monthly Budget Report MONTHLY BUDGET FINANCIAL STATUS UPDATE To: Mayor and Councilmembers From: Noah Crocker, Finance Director Period: November 2019 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. Page 1 of 10 POINTS OF INTEREST: Current Expense Fund 001 – The Current Expense Fund is used for the general governmental functions of the City. By the end of November 2019, the City has received revenues 1.27% in excess of the total budgeted for 2019. The table to the right provides budget versus actual (YTD) data by source of revenue. The table also shows revenue received for the month of November. Expenditures for the Current Expense operations original budget totaled $11,795,294. During the mid-biennial review, additional expenses were approved by Council (Ordinance 044-19), which increased the expenditure budget to $13,089,622 for FY2019. Through November 67.43% of the amended budget amount has been expended, leaving approximately 32.57% of remaining expenditure authority available for operations through the end of the year. Real Estate Excise Tax Fund 109 and Impact Mitigation Fee Fund 111 Real Estate Excise Tax receipts fluctuate monthly but are currently trending higher (11.50%) than receipts received in the same time period for 2018. The table below shows balances through October 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 payments. The table shows 2019 beginning fund balances, year to date revenue received, expenses budgeted for the biennium and expenses which are obligated for future projects but have not been officially budgeted yet. The intent of this table is to snapshot and illustrate available balances and what is projected for the end of the biennium. This table includes project cost revisions which were approved as part of the mid biennial review amendment Ordinance # 044-19, adopted by Council on October 22nd. No impact fee revenues were received in November. Though there was a slight increase in revenue due to interest earnings. Capital Construction Fund 302 – Construction is complete at McCormick Woods Park and Rockwell Park. The Public Works Department continues to work on project closeout. – no change Impact Fees REET Recreation Reserve MW Transport Impact Parks Impact Bayside Plat SEPA Transportation REET 1 REET 2 Recreation Reserve (001) Admissions 2019-2020 Beginning Balance 536,160 44,127 316,109 541,822 585,759 1,217,673 54,930 2019-2020 Revenue Received 112,907 73,711 6,414 146,637 478,701 489,879 41,315 2019-2020 Expenses Budgeted (100,000) - (313,285) - (159,932) (1,474,781) - 2019-2020 Obligated Expenses (465,000) - - (500,000) (458,000) - (25,000) 2019-2020 Ending Balance 84,066 117,839 9,238 188,459 446,529 232,771 71,246 Revenue Source 2019 Original Budget 2019 Current Budget 2019 YTD % of Budget Received Received November 2019 Property Tax 1,841,000 1,841,000 1,734,983 94%53,883 Sales Tax 5,060,000 5,060,000 4,909,028 97% 484,346 Other Taxes 2,088,300 2,088,300 1,958,735 94%94,228 Total Taxes 8,989,300 8,989,300 8,602,747 96% 632,456 Licenses & Permits 403,400 403,400 470,272 117% 14,064 Intergovernmental Revenue 223,100 223,100 249,883 112% 10,442 Charges for Goods & Services 438,700 438,700 615,929 140% 140,046 Fines and Penalties 176,300 176,300 241,718 137% 20,243 Misc Revenues 172,500 172,500 330,707 192% 28,138 Non Rev - - 11,881 (241) Capital Contributions - - 12,294 - Revenue Totals 10,403,300 10,403,300 10,535,431 101.27% 845,149 Current Expense Fund Revenues Page 2 of 10 Street Capital Construction Fund 304 – Tremont Street is now open; the Public Works department continues to work on the final aspects of this project. Once these are completed, final project closeout can begin. Public Works is also still working on the closeout for Bay Street Pedestrian Path Segment 3 project. The Bay Street Pedestrian Path Right of Way efforts are ongoing. – no change ENTERPRISE/UTILITY FUNDS: Water operation - During the mid-biennial review, a “true up” of beginning fund balance plus an additional $717,779 transfer from the final closeout of the old Water Sewer Utility Fund No. 401 to Water Operating was approved by Council (Ordinance 044-19). This increased the revenues total budget to $4,791,879. At the end of November only 1.58% of additional revenues need to be received to reach the 2019 amended budget amount. It is expected that revenues will exceed what was budgeted by year end. The Water operations original budget authorized total expenditures of $3,563,478. During the mid-biennial review, additional expenses for contractual obligations were requested and approved by Council (Ordinance 044- 19), which increased the Water Operation total expenditure budget to $4,065,878. With the new budget authority, Water Operational expenses (excluding capital project, Debt or ER&R transfers) have 21.23% remaining for operational expenses in December. The water operational expense budget also includes transfers which have not yet been executed. The City manages its transfers according to when the anticipated expenses are to occur in the Water Capital Project, Debt or ER&R fund. Thus, there is currently approximately $1 million of transfers which have not occurred yet. Sewer operation - Sewer Operational Revenues require an additional 5.59% to reach the 2019 amended total budgeted revenues. It is expected that revenues will exceed budgeted by the end of the year. Operational Sewer expenses (excluding transfers for Capital Projects, ER&R and Debt) have 21.19% budget authority remaining for December. The sewer operational expense budget also includes transfers which have not yet been executed. The City manages its transfers according to when the anticipated expenses are to occur in the Sewer Capital Project, Debt or ER&R fund. Thus, there is currently over $1.9 million of transfers which have not occurred yet. Storm Drainage operations - During the mid-biennial review, a “true up” of beginning fund balance to Storm Drainage Operations Operating was approved by Council (Ordinance 044-19), which increased the total operating revenues budget to $1,831,340. After receipt of revenues through November the Storm Drainage operations fund is 7.68% over the 2019 amended budget amount. Expenses for the Storm Drainage Operations Fund (excluding transfers) have 30.91% remaining budget authority through the end of the year. Page 3 of 10 SALES TAX REVENUES SUMMARY •Total 2019 Budget:$5,060,000 •Total 2019 YTD Actuals:$4,909,028 •Year-to-Date Actual revenue collected is 5.57% higher when compared to Year-to Date Budgeted •Year-to-Date Actual revenue collected is 4.92% higher when compared to Prior Year-to Date Actuals The following tables provide additional sales tax information. Table 2: provides current data for sales tax revenue collected Year-to-date. Table 1: shows revenue received by month over a three- year period. Page 4 of 10 12/16/2019 9:06:50 AM Budget Report City of Port Orchard Group Summary For Fiscal: 2019 Period Ending: 11/30/2019 Fiscal Activity Variance Favorable (Unfavorable) Period Activity Current Total Budget Original Total Budget Percent RemainingDepartmentt Fund: 001 - Current Expense Revenue 00 - Revenues 10,535,430.82845,148.7710,403,300.00 10,403,300.00 132,130.82 1.27 % 10,535,430.82845,148.7710,403,300.00 10,403,300.00 132,130.82Revenue Total:1.27 % Expense 01 - Finance 649,027.9978,838.99853,400.00 853,400.00 204,372.01 23.95 % 02 - Court 480,605.9759,262.91625,500.00 701,500.00 220,894.03 31.49 % 03 - Law Enforcement 4,404,820.32435,327.165,823,008.00 5,823,008.00 1,418,187.68 24.35 % 04 - Community Development 1,157,222.05142,798.291,378,200.00 1,378,200.00 220,977.95 16.03 % 05 - Public Works 1,007,346.1672,152.981,262,351.00 1,389,351.00 382,004.84 27.50 % 06 - Miscellaneous 203,487.50650.00650,000.00 1,711,853.00 1,508,365.50 88.11 % 07 - Administration 923,352.1297,168.861,202,835.00 1,232,310.00 308,957.88 25.07 % 8,825,862.11886,199.1911,795,294.00 13,089,622.00 4,263,759.89Expense Total:32.57 % 1,709,568.71-41,050.42-1,391,994.00 -2,686,322.00 4,395,890.71Fund: 001 - Current Expense Surplus (Deficit):163.64 % Fund: 002 - City Street Fund Revenue 00 - Revenues 1,664,031.0682,780.701,934,000.00 2,204,000.00 -539,968.94 24.50 % 1,664,031.0682,780.701,934,000.00 2,204,000.00 -539,968.94Revenue Total:24.50 % Expense 05 - Public Works 1,629,237.45106,286.392,309,591.00 2,594,591.00 965,353.55 37.21 % 1,629,237.45106,286.392,309,591.00 2,594,591.00 965,353.55Expense Total:37.21 % 34,793.61-23,505.69-375,591.00 -390,591.00 425,384.61Fund: 002 - City Street Fund Surplus (Deficit):108.91 % Fund: 003 - Stabilization Fund Revenue 00 - Revenues 223,877.271,702.00200,000.00 966,853.00 -742,975.73 76.84 % 223,877.271,702.00200,000.00 966,853.00 -742,975.73Revenue Total:76.84 % 223,877.271,702.00200,000.00 966,853.00 -742,975.73Fund: 003 - Stabilization Fund Total:76.84 % Fund: 103 - Criminal Justice Revenue 00 - Revenues 305,838.7923,668.15244,600.00 244,600.00 61,238.79 25.04 % 305,838.7923,668.15244,600.00 244,600.00 61,238.79Revenue Total:25.04 % Expense 03 - Law Enforcement 393,442.9114,467.00591,400.00 591,400.00 197,957.09 33.47 % 393,442.9114,467.00591,400.00 591,400.00 197,957.09Expense Total:33.47 % -87,604.129,201.15-346,800.00 -346,800.00 259,195.88Fund: 103 - Criminal Justice Surplus (Deficit):74.74 % Fund: 104 - Special Investigative Unit Revenue 00 - Revenues 19,054.922,806.514,000.00 4,000.00 15,054.92 376.37 % 19,054.922,806.514,000.00 4,000.00 15,054.92Revenue Total:376.37 % Expense 03 - Law Enforcement 2,457.1815.272,080.00 2,080.00 -377.18 -18.13 % 2,457.1815.272,080.00 2,080.00 -377.18Expense Total:-18.13 % 16,597.742,791.241,920.00 1,920.00 14,677.74Fund: 104 - Special Investigative Unit Surplus (Deficit):-764.47 % Fund: 107 - Community Events Revenue 00 - Revenues 112,049.3910,649.00100,000.00 100,000.00 12,049.39 12.05 % 112,049.3910,649.00100,000.00 100,000.00 12,049.39Revenue Total:12.05 % OPERATING FUNDS__________________________________________________________________________________ Page 5 of 10 Budget Report For Fiscal: 2019 Period Ending: 11/30/2019 12/16/2019 9:06:50 AM Fiscal Activity Variance Favorable (Unfavorable) Period ActivityDepartmentt Current Total Budget Original Total Budget Percent Remaining Expense 01 - Finance 0.000.002,500.00 2,500.00 2,500.00 100.00 % 06 - Miscellaneous 66,274.013,215.40100,000.00 100,000.00 33,725.99 33.73 % 07 - Administration 4,058.7159.369,700.00 9,700.00 5,641.29 58.16 % 70,332.723,274.76112,200.00 112,200.00 41,867.28Expense Total:37.31 % 41,716.677,374.24-12,200.00 -12,200.00 53,916.67Fund: 107 - Community Events Surplus (Deficit):441.94 % Fund: 108 - Paths & Trails Revenue 00 - Revenues 1,324.58115.221,000.00 1,000.00 324.58 32.46 % 1,324.58115.221,000.00 1,000.00 324.58Revenue Total:32.46 % 1,324.58115.221,000.00 1,000.00 324.58Fund: 108 - Paths & Trails Total:32.46 % Fund: 109 - Real Estate Excise Tax Revenue 00 - Revenues 968,579.6976,720.16700,000.00 700,000.00 268,579.69 38.37 % 968,579.6976,720.16700,000.00 700,000.00 268,579.69Revenue Total:38.37 % Expense 06 - Miscellaneous 307,991.160.001,634,713.00 1,634,713.00 1,326,721.84 81.16 % 307,991.160.001,634,713.00 1,634,713.00 1,326,721.84Expense Total:81.16 % 660,588.5376,720.16-934,713.00 -934,713.00 1,595,301.53Fund: 109 - Real Estate Excise Tax Surplus (Deficit):170.67 % Fund: 111 - Impact Mitigation Fee Revenue 00 - Revenues 339,668.643,825.87140,000.00 140,000.00 199,668.64 142.62 % 339,668.643,825.87140,000.00 140,000.00 199,668.64Revenue Total:142.62 % Expense 05 - Public Works 51,042.820.00335,285.00 263,285.00 212,242.18 80.61 % 51,042.820.00335,285.00 263,285.00 212,242.18Expense Total:80.61 % 288,625.823,825.87-195,285.00 -123,285.00 411,910.82Fund: 111 - Impact Mitigation Fee Surplus (Deficit):334.11 % Fund: 206 - Bond Redemption Fund Revenue 00 - Revenues 302,424.980.00757,383.00 757,383.00 -454,958.02 60.07 % 302,424.980.00757,383.00 757,383.00 -454,958.02Revenue Total:60.07 % Expense 06 - Miscellaneous 302,424.980.00459,376.00 459,376.00 156,951.02 34.17 % 302,424.980.00459,376.00 459,376.00 156,951.02Expense Total:34.17 % 0.000.00298,007.00 298,007.00 -298,007.00Fund: 206 - Bond Redemption Fund Surplus (Deficit):100.00 % Fund: 401 - Water-Sewer Utilities Revenue 00 - Revenues 30,866.843,318.190.00 40,000.00 -9,133.16 22.83 % 30,866.843,318.190.00 40,000.00 -9,133.16Revenue Total:22.83 % Expense 05 - Public Works 3,426,725.071,426,725.072,000,000.00 3,435,558.00 8,832.93 0.26 % 3,426,725.071,426,725.072,000,000.00 3,435,558.00 8,832.93Expense Total:0.26 % -3,395,858.23-1,423,406.88-2,000,000.00 -3,395,558.00 -300.23Fund: 401 - Water-Sewer Utilities Surplus (Deficit):-0.01 % Fund: 411 - Water Operating Revenue 00 - Revenues 4,716,382.30971,942.214,074,100.00 4,791,879.00 -75,496.70 1.58 % 4,716,382.30971,942.214,074,100.00 4,791,879.00 -75,496.70Revenue Total:1.58 % Expense 05 - Public Works 2,462,254.75220,864.613,563,478.00 4,065,878.00 1,603,623.25 39.44 % 2,462,254.75220,864.613,563,478.00 4,065,878.00 1,603,623.25Expense Total:39.44 % 2,254,127.55751,077.60510,622.00 726,001.00 1,528,126.55Fund: 411 - Water Operating Surplus (Deficit):-210.49 % Page 6 of 10 For Fiscal: 2019 Period Ending: 11/30/2019 12/16/2019 9:06:50 AM Fiscal Activity Variance Favorable (Unfavorable) Period Activity Current Total Budget Original Total Budget Percent Remaining Budget Report Department Fund: 412 - Water Stabilization Revenue 00 - Revenues 101,122.29151.73100,000.00 100,000.00 1,122.29 1.12 % 101,122.29151.73100,000.00 100,000.00 1,122.29Revenue Total:1.12 % 101,122.29151.73100,000.00 100,000.00 1,122.29Fund: 412 - Water Stabilization Total:1.12 % Fund: 414 - Water Debt Service Revenue 00 - Revenues 22,951.500.0080,128.00 80,128.00 -57,176.50 71.36 % 22,951.500.0080,128.00 80,128.00 -57,176.50Revenue Total:71.36 % Expense 05 - Public Works 22,951.500.0080,128.00 80,128.00 57,176.50 71.36 % 22,951.500.0080,128.00 80,128.00 57,176.50Expense Total:71.36 % 0.000.000.00 0.00 0.00Fund: 414 - Water Debt Service Surplus (Deficit):0.00 % Fund: 421 - Storm Drainage Utility Revenue 00 - Revenues 1,690,731.05158,830.401,614,500.00 1,831,340.00 -140,608.95 7.68 % 1,690,731.05158,830.401,614,500.00 1,831,340.00 -140,608.95Revenue Total:7.68 % Expense 05 - Public Works 1,558,923.90107,535.501,989,521.00 2,256,361.00 697,437.10 30.91 % 1,558,923.90107,535.501,989,521.00 2,256,361.00 697,437.10Expense Total:30.91 % 131,807.1551,294.90-375,021.00 -425,021.00 556,828.15Fund: 421 - Storm Drainage Utility Surplus (Deficit):131.01 % Fund: 422 - Storm Drainage Stabilization Revenue 00 - Revenues 167,555.63251.42165,000.00 165,000.00 2,555.63 1.55 % 167,555.63251.42165,000.00 165,000.00 2,555.63Revenue Total:1.55 % 167,555.63251.42165,000.00 165,000.00 2,555.63Fund: 422 - Storm Drainage Stabilization Total:1.55 % Fund: 424 - Storm Drainage Debt Service Revenue 00 - Revenues 177,763.840.00177,764.00 177,764.00 -0.16 0.00 % 177,763.840.00177,764.00 177,764.00 -0.16Revenue Total:0.00 % Expense 05 - Public Works 177,763.840.00177,764.00 177,764.00 0.16 0.00 % 177,763.840.00177,764.00 177,764.00 0.16Expense Total:0.00 % 0.000.000.00 0.00 0.00Fund: 424 - Storm Drainage Debt Service Surplus (Deficit):0.00 % Fund: 431 - Sewer Operating Revenue 00 - Revenues 6,432,243.691,108,792.955,998,200.00 6,715,979.00 -283,735.31 4.22 % 6,432,243.691,108,792.955,998,200.00 6,715,979.00 -283,735.31Revenue Total:4.22 % Expense 05 - Public Works 3,744,364.20282,672.106,413,629.00 6,413,629.00 2,669,264.80 41.62 % 3,744,364.20282,672.106,413,629.00 6,413,629.00 2,669,264.80Expense Total:41.62 % 2,687,879.49826,120.85-415,429.00 302,350.00 2,385,529.49Fund: 431 - Sewer Operating Surplus (Deficit):-789.00 % Fund: 432 - Sewer Stabilization Revenue 00 - Revenues 297,144.97445.87588,300.00 588,300.00 -291,155.03 49.49 % 297,144.97445.87588,300.00 588,300.00 -291,155.03Revenue Total:49.49 % 297,144.97445.87588,300.00 588,300.00 -291,155.03Fund: 432 - Sewer Stabilization Total:49.49 % Fund: 434 - Sewer Debt Service Revenue 00 - Revenues 551.500.0030,128.00 30,128.00 -29,576.50 98.17 % 551.500.0030,128.00 30,128.00 -29,576.50Revenue Total:98.17 % Page 7 of 10 Budget Report For Fiscal: 2019 Period Ending: 11/30/2019 12/16/2019 9:06:50 AM Fiscal Activity Variance Favorable (Unfavorable) Period ActivityDepartment Current Total Budget Original Total Budget Percent Remaining Expense 05 - Public Works 551.500.0030,128.00 30,128.00 29,576.50 98.17 % 551.500.0030,128.00 30,128.00 29,576.50Expense Total:98.17 % 0.000.000.00 0.00 0.00Fund: 434 - Sewer Debt Service Surplus (Deficit):0.00 % Fund: 500 - Equipment Rental and Revolving Revenue 00 - Revenues 2,734,916.7728,034.383,479,632.00 3,555,632.00 -820,715.23 23.08 % 2,734,916.7728,034.383,479,632.00 3,555,632.00 -820,715.23Revenue Total:23.08 % Expense 10 - ER&R 751,272.50417,490.511,481,822.00 1,481,822.00 730,549.50 49.30 % 751,272.50417,490.511,481,822.00 1,481,822.00 730,549.50Expense Total:49.30 % 1,983,644.27-389,456.131,997,810.00 2,073,810.00 -90,165.73Fund: 500 - Equipment Rental and Revolving Surplus (Deficit):4.35 % Report Surplus (Deficit):-146,346.87 7,116,911.93-2,184,374.00 -3,091,249.00 10,208,160.93 330.23 % Page 8 of 10 12/16/2019 9:07:23 AM Budget Report City of Port Orchard Group Summary For Fiscal: 2019 Period Ending: 11/30/2019 Fiscal Activity Variance Favorable (Unfavorable) Period Activity Current Total Budget Original Total Budget Percent RemainingAccount Type Fund: 302 - Capital Construction Revenue 296,881.37137.74818,000.00 973,715.00 -676,833.63 69.51 % Expense 536,812.39268.59500,000.00 748,715.00 211,902.61 28.30 % -239,931.02-130.85318,000.00 225,000.00 -464,931.02Fund: 302 - Capital Construction Surplus (Deficit):206.64 % Fund: 304 - Street Capital Projects Revenue 5,090,250.3416,880.365,325,094.00 6,453,094.00 -1,362,843.66 21.12 % Expense 4,896,097.8051,678.004,882,500.00 6,242,500.00 1,346,402.20 21.57 % 194,152.54-34,797.64442,594.00 210,594.00 -16,441.46Fund: 304 - Street Capital Projects Surplus (Deficit):7.81 % Fund: 403 - Water-Sewer Cumulative Reserve Revenue 16,003.861,896.604,867,000.00 5,599,427.00 -5,583,423.14 99.71 % Expense 5,585,430.97718,430.974,867,000.00 5,599,427.00 13,996.03 0.25 % -5,569,427.11-716,534.370.00 0.00 -5,569,427.11Fund: 403 - Water-Sewer Cumulative Reserve Surplus (Deficit):0.00 % Fund: 413 - Water Capital Revenue 3,667,751.89325,324.565,968,000.00 6,282,944.00 -2,615,192.11 41.62 % Expense 1,887,232.0318,290.604,050,000.00 4,350,000.00 2,462,767.97 56.62 % 1,780,519.86307,033.961,918,000.00 1,932,944.00 -152,424.14Fund: 413 - Water Capital Surplus (Deficit):7.89 % Fund: 423 - Storm Drainage Capital Facil Revenue 289,383.20524.84670,440.00 969,703.00 -680,319.80 70.16 % Expense 636,125.370.00168,800.00 700,000.00 63,874.63 9.12 % -346,742.17524.84501,640.00 269,703.00 -616,445.17Fund: 423 - Storm Drainage Capital Facil Surplus (Deficit):228.56 % Fund: 433 - Sewer Capital Revenue 3,515,402.51415,707.167,314,000.00 8,515,483.00 -5,000,080.49 58.72 % Expense 631,142.3116,104.565,696,600.00 5,696,600.00 5,065,457.69 88.92 % 2,884,260.20399,602.601,617,400.00 2,818,883.00 65,377.20Fund: 433 - Sewer Capital Surplus (Deficit):-2.32 % Report Surplus (Deficit):-44,301.46 -1,297,167.704,797,634.00 5,457,124.00 -6,754,291.70 123.77 % CAPITAL PROJECTS FUNDS__________________________________________________________________________________ Page 9 of 10 Detail Report Date Range: 01/01/2019 - 11/30/2019 12/16/2019 9:15:00 AM Fund Summary Ending BalanceBeginning BalanceFund Total Activity 001 - Current Expense 4,542,596.17 6,252,690.141,710,093.97 002 - City Street Fund 664,461.74 699,255.8034,794.06 003 - Stabilization Fund 933,146.65 1,157,023.92223,877.27 103 - Criminal Justice 513,801.32 426,197.20-87,604.12 104 - Special Investigative Unit 77,460.69 94,058.4316,597.74 107 - Community Events 135,246.39 176,963.0641,716.67 108 - Paths & Trails 8,457.04 9,781.621,324.58 109 - Real Estate Excise Tax 2,009,946.44 2,670,534.97660,588.53 111 - Impact Mitigation Fee 1,440,068.12 1,728,693.94288,625.82 206 - Bond Redemption Fund 0.00 0.000.00 302 - Capital Construction 348,715.00 108,783.98-239,931.02 304 - Street Capital Projects 2,087,099.38 2,281,251.92194,152.54 401 - Water-Sewer Utilities 3,395,558.23 0.00-3,395,558.23 403 - Water-Sewer Cumulative Reserve 5,569,427.11 0.00-5,569,427.11 411 - Water Operating 0.00 2,253,829.312,253,829.31 412 - Water Stabilization 0.00 101,122.29101,122.29 413 - Water Capital 0.00 1,780,519.861,780,519.86 414 - Water Debt Service 0.00 0.000.00 421 - Storm Drainage Utility 1,591,817.04 1,723,618.49131,801.45 422 - Storm Drainage Stabilization 0.00 167,555.63167,555.63 423 - Storm Drainage Capital Facil 969,702.93 622,960.76-346,742.17 424 - Storm Drainage Debt Service 0.00 0.000.00 431 - Sewer Operating 0.00 2,687,881.252,687,881.25 432 - Sewer Stabilization 0.00 297,144.97297,144.97 433 - Sewer Capital 0.00 2,884,260.202,884,260.20 434 - Sewer Debt Service 0.00 0.000.00 500 - Equipment Rental and Revolving 1,082,643.00 3,066,287.271,983,644.27 631 - Trust and Agency 138.84 10,120.909,982.06 632 - Wastewater Treatment Facil Fee 2,553,806.09 2,598,275.5244,469.43 Grand Total:27,924,092.18 33,798,811.435,874,719.25 CASH & INVESTMENT FUND SUMMARY_____________________________________________________________________________________________________________ Page 10 of 10