Loading...
2022.11 Monthly Budget Report MONTHLY BUDGET FINANCIAL STATUS UPDATE To: Mayor and Council members From: Noah Crocker, Finance Director Period: November 2022 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 November 30, 2022, 126% of budgeted revenues were received. 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. SALES TAX REVENUES SUMMARY  Total 2022 Budget: $5,340,000  Total 2022 YTD Actuals: $7,134,430  Year-to-Date Actual revenue collected is 13.95% higher when compared to Prior Year-to Date Actuals  Year-to-Date Actual revenue collected is 45% higher when compared to Year-to Date Budgeted The following tables provide additional sales tax information: Revenue Source 2022 Original Budget 2022 Current Budget 2022 YTD % of Budget Received Received Current Period Property Tax 1,995,500 2,068,300 2,055,250 99.37%101,537 Sales Tax 5,340,000 5,340,000 7,134,430 133.60%730,655 Other Taxes 2,093,100 2,093,100 2,394,451 114.40%170,714 Total Taxes 9,428,600 9,501,400 11,584,132 121.92% 1,002,905 Licenses & Permits 481,200 481,200 1,527,577 317.45%39,885 Intergovernmental Revenue 326,700 2,352,239 1,901,544 80.84%7,241 Charges for Goods & Services 389,500 449,500 1,155,552 257.08%26,337 Fines & Penalties 163,100 163,100 106,336 65.20%8,405 Misc Revenues 177,100 177,100 291,919 164.83%46,753 Non-Revenues - - (1,055) #DIV/0!(2,071) Capital Contributions - - - #DIV/0!- REVENUE TOTALS 10,966,200 13,124,539 16,566,005 126.22%1,129,455 Current Expense Fund Revenues Table 1: shows revenue received by month over a three-year period. Table 2: provides current data for sales tax revenue collected Year-to-date. Real Estate Excise Tax (REET) Fund 109 and Impact Mitigation Fee Fund 111 The City’s Real Estate Excise Tax receipts fluctuate monthly. November 2022 receipts are Higher than November 2021 by 25%. The table below shows balances through November 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 above shows 2022 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. Impact Fees received for November 2022 are as follows: o Parks $11,360 o Transportation $20,709 o School District Impact $6,854 REET revenues received in November: o REET 1 $60,817 o REET 2 $60,817 Capital Construction Fund 302 – The McCormick Woods Splash Pad Retrofit is in design with Murray Smith 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 –Bay Street Pedestrian Path right of way efforts continue. The City has contracted with Skilling’s Inc for Design and Right of Way Services for the Bethel-Lincoln Round-About project. Design for the project is in progress. Impact Fees REET Recreation Reserve MW Transport Impact Parks Impact Bayside Plat SEPA Transportation REET 1 REET 2 Recreation Reserve (001) Admissions Tax School District Impact Blue Berry Bethel (Fund 304) 2021-2022 Beginning Balance 785,820 255,009 326,495 944,142 1,625,464 1,641,128 118,202 - - 2021-2022 Revenue Received* 40,204 619,949 4,541 3,041,819 1,944,093 2,637,509 38,593 360,800 234,233 2021-2022 Expenses Budgeted (606,450) (670,000) - (1,683,550) (3,554,000) (1,714,200) (115,000) (800,000) (234,233) 2021-2022 Obligated Expenses (219,574) (204,958) (331,036) (100,000) (15,557) - - - 2021-2022 Ending Balance - - - 2,202,411 0 2,564,437 41,795 (439,200) - ENTERPRISE/UTILITY FUNDS: Water operation - Water operations budgeted revenue in the amount of $3,344,600 for 2022. Through November, the city has received $3,548,128 or ~106% 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 $2,753,142 through November representing ~89% of the 2022 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 2022 budget includes $649,755 for transfers. There were no reported transfers this month. Sewer operation - $5,418,900 is budgeted for Sewer Operational Revenues for 2022. Through the month of November $5,769,824 was received representing ~106% of the 2022 budgeted revenues. Sewer Operations expended $3,450,986 through November representing ~77% of the 2022 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 2022 budget includes $989,844 for transfers. A total of $145 was transferred to fund 433 for the Marina Pump Station project this month. Storm Drainage operations- $1,831,000 is budgeted for Storm Operational Revenues for 2022. As of the end of November the Storm Drainage utility has received $1,826,807 or ~99% of its annual budgeted revenue. Storm Drainage Operations expended $1,504,778 through November representing ~79% of the 2022 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 2022 budget includes $868,000 for transfers. No transfers were executed this month. Budget Report For Fiscal: 2022 Period Ending: 11/30/2022 12/12/2022 1:32:56 PM Page 14 of 17 Group Summary Fiscal Activity Variance Favorable (Unfavorable) Period ActivityDepartmen… Current Total Budget Original Total Budget Percent Remaining Fund: 001 - Current Expense Revenue 00 - Revenues 16,566,005.351,129,455.0510,966,200.00 13,124,539.00 3,441,466.35 26.22 % 16,566,005.351,129,455.0510,966,200.00 13,124,539.00 3,441,466.35Revenue Total:26.22 % Expense 01 - Finance 758,637.9156,162.40904,035.24 1,096,414.53 337,776.62 30.81 % 02 - Court 434,656.0338,570.42794,231.21 849,492.77 414,836.74 48.83 % 03 - Law Enforcement 4,265,233.10520,264.515,282,255.09 5,697,011.84 1,431,778.74 25.13 % 04 - Community Development 2,225,632.36220,695.271,627,716.77 3,144,092.10 918,459.74 29.21 % 05 - Public Works 1,346,426.1191,238.371,495,384.20 1,589,381.27 242,955.16 15.29 % 06 - Miscellaneous 2,103,137.50300.00502,800.00 5,645,878.00 3,542,740.50 62.75 % 07 - Administration 1,357,511.44155,579.341,566,377.49 1,708,054.91 350,543.47 20.52 % 12,491,234.451,082,810.3112,172,800.00 19,730,325.42 7,239,090.97Expense Total:36.69 % 4,074,770.9046,644.74-1,206,600.00 -6,605,786.42 10,680,557.32Fund: 001 - Current Expense Surplus (Deficit):161.68 % Fund: 002 - City Street Fund Revenue 00 - Revenues 3,484,388.79101,328.022,112,400.00 3,601,600.00 -117,211.21 3.25 % 3,484,388.79101,328.022,112,400.00 3,601,600.00 -117,211.21Revenue Total:3.25 % Expense 05 - Public Works 2,453,788.36179,451.402,400,500.00 4,762,205.20 2,308,416.84 48.47 % 2,453,788.36179,451.402,400,500.00 4,762,205.20 2,308,416.84Expense Total:48.47 % 1,030,600.43-78,123.38-288,100.00 -1,160,605.20 2,191,205.63Fund: 002 - City Street Fund Surplus (Deficit):188.80 % Fund: 003 - Stabilization Fund Revenue 00 - Revenues 395,371.438,333.120.00 360,000.00 35,371.43 9.83 % 395,371.438,333.120.00 360,000.00 35,371.43Revenue Total:9.83 % 395,371.438,333.120.00 360,000.00 35,371.43Fund: 003 - Stabilization Fund Total:9.83 % Fund: 103 - Criminal Justice Revenue 00 - Revenues 412,845.7934,060.58247,100.00 247,100.00 165,745.79 67.08 % 412,845.7934,060.58247,100.00 247,100.00 165,745.79Revenue Total:67.08 % Expense 03 - Law Enforcement 345,950.1922,581.15292,000.00 419,525.00 73,574.81 17.54 % 345,950.1922,581.15292,000.00 419,525.00 73,574.81Expense Total:17.54 % 66,895.6011,479.43-44,900.00 -172,425.00 239,320.60Fund: 103 - Criminal Justice Surplus (Deficit):138.80 % Fund: 104 - Special Investigative Unit Revenue 00 - Revenues 1,015.10194.774,000.00 4,000.00 -2,984.90 74.62 % 1,015.10194.774,000.00 4,000.00 -2,984.90Revenue Total:74.62 % Expense 03 - Law Enforcement 300.000.004,000.00 4,000.00 3,700.00 92.50 % 300.000.004,000.00 4,000.00 3,700.00Expense Total:92.50 % 715.10194.770.00 0.00 715.10Fund: 104 - Special Investigative Unit Surplus (Deficit):0.00 % Fund: 107 - Community Events Revenue 00 - Revenues 150,261.9815,766.74100,000.00 100,000.00 50,261.98 50.26 % 150,261.9815,766.74100,000.00 100,000.00 50,261.98Revenue Total:50.26 % Expense 07 - Administration 39,936.216,446.5296,800.00 131,778.00 91,841.79 69.69 % 39,936.216,446.5296,800.00 131,778.00 91,841.79Expense Total:69.69 % 110,325.779,320.223,200.00 -31,778.00 142,103.77Fund: 107 - Community Events Surplus (Deficit):447.18 % Operation Budget Report Budget Report For Fiscal: 2022 Period Ending: 11/30/2022 12/12/2022 1:32:56 PM Page 15 of 17 Fiscal Activity Variance Favorable (Unfavorable) Period ActivityDepartmen… Current Total Budget Original Total Budget Percent Remaining Fund: 108 - Paths & Trails Revenue 00 - Revenues 1,332.06132.821,000.00 1,000.00 332.06 33.21 % 1,332.06132.821,000.00 1,000.00 332.06Revenue Total:33.21 % 1,332.06132.821,000.00 1,000.00 332.06Fund: 108 - Paths & Trails Total:33.21 % Fund: 109 - Real Estate Excise Tax Revenue 00 - Revenues 1,840,921.49129,627.87700,000.00 1,808,000.00 32,921.49 1.82 % 1,840,921.49129,627.87700,000.00 1,808,000.00 32,921.49Revenue Total:1.82 % Expense 06 - Miscellaneous 2,190,742.5315,433.12298,300.00 3,975,300.00 1,784,557.47 44.89 % 2,190,742.5315,433.12298,300.00 3,975,300.00 1,784,557.47Expense Total:44.89 % -349,821.04114,194.75401,700.00 -2,167,300.00 1,817,478.96Fund: 109 - Real Estate Excise Tax Surplus (Deficit):83.86 % Fund: 111 - Impact Mitigation Fee Revenue 00 - Revenues 2,580,439.6652,716.68140,000.00 1,640,000.00 940,439.66 57.34 % 2,580,439.6652,716.68140,000.00 1,640,000.00 940,439.66Revenue Total:57.34 % Expense 06 - Miscellaneous 474,232.4251,098.64250,000.00 2,645,000.00 2,170,767.58 82.07 % 474,232.4251,098.64250,000.00 2,645,000.00 2,170,767.58Expense Total:82.07 % 2,106,207.241,618.04-110,000.00 -1,005,000.00 3,111,207.24Fund: 111 - Impact Mitigation Fee Surplus (Deficit):309.57 % Fund: 206 - Bond Redemption Fund Revenue 00 - Revenues 298,110.800.00298,300.00 298,300.00 -189.20 0.06 % 298,110.800.00298,300.00 298,300.00 -189.20Revenue Total:0.06 % Expense 06 - Miscellaneous 298,110.800.00298,300.00 298,300.00 189.20 0.06 % 298,110.800.00298,300.00 298,300.00 189.20Expense Total:0.06 % 0.000.000.00 0.00 0.00Fund: 206 - Bond Redemption Fund Surplus (Deficit):0.00 % Fund: 411 - Water Operating Revenue 00 - Revenues 3,548,128.02331,528.803,344,600.00 3,344,600.00 203,528.02 6.09 % 3,548,128.02331,528.803,344,600.00 3,344,600.00 203,528.02Revenue Total:6.09 % Expense 05 - Public Works 2,753,142.24208,272.112,486,600.00 3,072,082.11 318,939.87 10.38 % 06 - Miscellaneous 658,692.060.00563,500.00 652,692.06 -6,000.00 -0.92 % 3,411,834.30208,272.113,050,100.00 3,724,774.17 312,939.87Expense Total:8.40 % 136,293.72123,256.69294,500.00 -380,174.17 516,467.89Fund: 411 - Water Operating Surplus (Deficit):135.85 % Fund: 412 - Water Stabilization Revenue 00 - Revenues 307,058.252,964.39263,500.00 294,755.00 12,303.25 4.17 % 307,058.252,964.39263,500.00 294,755.00 12,303.25Revenue Total:4.17 % 307,058.252,964.39263,500.00 294,755.00 12,303.25Fund: 412 - Water Stabilization Total:4.17 % Fund: 414 - Water Debt Service Revenue 00 - Revenues 583,672.6571,425.00355,125.00 756,225.00 -172,552.35 22.82 % 583,672.6571,425.00355,125.00 756,225.00 -172,552.35Revenue Total:22.82 % Expense 06 - Miscellaneous 583,672.6571,425.00355,125.00 758,390.00 174,717.35 23.04 % 583,672.6571,425.00355,125.00 758,390.00 174,717.35Expense Total:23.04 % 0.000.000.00 -2,165.00 2,165.00Fund: 414 - Water Debt Service Surplus (Deficit):100.00 % Budget Report For Fiscal: 2022 Period Ending: 11/30/2022 12/12/2022 1:32:56 PM Page 16 of 17 Fiscal Activity Variance Favorable (Unfavorable) Period ActivityDepartmen… Current Total Budget Original Total Budget Percent Remaining Fund: 421 - Storm Drainage Utility Revenue 00 - Revenues 1,826,807.84170,613.541,667,000.00 1,831,000.00 -4,192.16 0.23 % 1,826,807.84170,613.541,667,000.00 1,831,000.00 -4,192.16Revenue Total:0.23 % Expense 05 - Public Works 1,504,778.38129,522.741,379,650.00 1,924,382.68 419,604.30 21.80 % 06 - Miscellaneous 367,846.520.00341,250.00 868,000.00 500,153.48 57.62 % 1,872,624.90129,522.741,720,900.00 2,792,382.68 919,757.78Expense Total:32.94 % -45,817.0641,090.80-53,900.00 -961,382.68 915,565.62Fund: 421 - Storm Drainage Utility Surplus (Deficit):95.23 % Fund: 422 - Storm Drainage Stabilization Revenue 00 - Revenues 197,688.641,665.52164,100.00 190,850.00 6,838.64 3.58 % 197,688.641,665.52164,100.00 190,850.00 6,838.64Revenue Total:3.58 % 197,688.641,665.52164,100.00 190,850.00 6,838.64Fund: 422 - Storm Drainage Stabilization Total:3.58 % Fund: 424 - Storm Drainage Debt Service Revenue 00 - Revenues 177,046.520.00177,200.00 177,200.00 -153.48 0.09 % 177,046.520.00177,200.00 177,200.00 -153.48Revenue Total:0.09 % Expense 06 - Miscellaneous 177,046.520.00177,200.00 177,200.00 153.48 0.09 % 177,046.520.00177,200.00 177,200.00 153.48Expense Total:0.09 % 0.000.000.00 0.00 0.00Fund: 424 - Storm Drainage Debt Service Surplus (Deficit):0.00 % Fund: 431 - Sewer Operating Revenue 00 - Revenues 5,769,824.13450,755.375,418,900.00 5,418,900.00 350,924.13 6.48 % 5,769,824.13450,755.375,418,900.00 5,418,900.00 350,924.13Revenue Total:6.48 % Expense 05 - Public Works 3,450,986.81320,162.323,564,481.00 4,484,154.67 1,033,167.86 23.04 % 06 - Miscellaneous 638,255.61145.68928,719.00 989,844.00 351,588.39 35.52 % 4,089,242.42320,308.004,493,200.00 5,473,998.67 1,384,756.25Expense Total:25.30 % 1,680,581.71130,447.37925,700.00 -55,098.67 1,735,680.38Fund: 431 - Sewer Operating Surplus (Deficit):3,150.13 % Fund: 432 - Sewer Stabilization Revenue 00 - Revenues 453,692.884,436.34374,150.00 435,275.00 18,417.88 4.23 % 453,692.884,436.34374,150.00 435,275.00 18,417.88Revenue Total:4.23 % 453,692.884,436.34374,150.00 435,275.00 18,417.88Fund: 432 - Sewer Stabilization Total:4.23 % Fund: 434 - Sewer Debt Service Revenue 00 - Revenues 281,929.001,714.32275,000.00 275,000.00 6,929.00 2.52 % 281,929.001,714.32275,000.00 275,000.00 6,929.00Revenue Total:2.52 % 281,929.001,714.32275,000.00 275,000.00 6,929.00Fund: 434 - Sewer Debt Service Total:2.52 % Fund: 500 - Equipment Rental and Revolving Revenue 00 - Revenues 1,189,134.1452,349.00685,500.00 1,106,300.00 82,834.14 7.49 % 1,189,134.1452,349.00685,500.00 1,106,300.00 82,834.14Revenue Total:7.49 % Expense 10 - ER&R 828,186.32129,510.16484,000.00 904,800.00 76,613.68 8.47 % 828,186.32129,510.16484,000.00 904,800.00 76,613.68Expense Total:8.47 % 360,947.82-77,161.16201,500.00 201,500.00 159,447.82Fund: 500 - Equipment Rental and Revolving Surplus (Deficit):-79.13 % Report Surplus (Deficit):342,208.78 10,808,772.451,200,850.00 -10,783,335.14 21,592,107.59 200.24 % 12/12/2022 1:49:42 PM Page 1 of 2 Budget Report City of Port Orchard Group Summary For Fiscal: 2022 Period Ending: 11/30/2022 Fiscal Activity Variance Favorable (Unfavorable) Period ActivityAccount Typ… Current Total Budget Original Total Budget Percent Remaining Fund: 302 - Capital Construction Revenue 188,976.7611,776.970.00 1,398,000.00 -1,209,023.24 86.48 % Expense 163,638.0011,188.000.00 1,398,000.00 1,234,362.00 88.29 % 25,338.76588.970.00 0.00 25,338.76Fund: 302 - Capital Construction Surplus (Deficit):0.00 % Fund: 304 - Street Capital Projects Revenue 3,312,123.7752,830.81690,000.00 8,518,587.00 -5,206,463.23 61.12 % Expense 2,850,436.3478,582.431,006,000.00 9,090,750.00 6,240,313.66 68.64 % 461,687.43-25,751.62-316,000.00 -572,163.00 1,033,850.43Fund: 304 - Street Capital Projects Surplus (Deficit):180.69 % Fund: 413 - Water Capital Revenue 1,823,365.4440,355.69969,100.00 2,734,100.00 -910,734.56 33.31 % Expense 539,057.10119,560.1355,200.00 1,551,300.00 1,012,242.90 65.25 % 1,284,308.34-79,204.44913,900.00 1,182,800.00 101,508.34Fund: 413 - Water Capital Surplus (Deficit):-8.58 % Fund: 423 - Storm Drainage Capital Facil Revenue 1,244.54293.220.00 500,000.00 -498,755.46 99.75 % Expense 0.000.000.00 500,000.00 500,000.00 100.00 % 1,244.54293.220.00 0.00 1,244.54Fund: 423 - Storm Drainage Capital Facil Surplus (Deficit):0.00 % Fund: 433 - Sewer Capital Revenue 2,995,561.1742,588.606,300,800.00 19,321,878.00 -16,326,316.83 84.50 % Expense 927,354.33291.376,300,800.00 12,350,700.00 11,423,345.67 92.49 % 2,068,206.8442,297.230.00 6,971,178.00 -4,902,971.16Fund: 433 - Sewer Capital Surplus (Deficit):70.33 % Report Surplus (Deficit):-61,776.64 3,840,785.91597,900.00 7,581,815.00 -3,741,029.09 49.34 % Capital Budget Report Detail Report Date Range: 11/01/2022 - 11/30/2022 12/12/2022 1:47:19 PM Page 5 of 5 Fund Summary Ending BalanceBeginning BalanceFund Total Activity 001 - Current Expense 14,815,971.73 14,862,616.4746,644.74 002 - City Street Fund 3,182,026.98 3,103,903.60-78,123.38 003 - Stabilization Fund 2,723,154.93 2,731,488.058,333.12 103 - Criminal Justice 613,226.50 624,705.9311,479.43 104 - Special Investigative Unit 97,501.85 97,696.62194.77 107 - Community Events 369,047.36 378,367.589,320.22 108 - Paths & Trails 13,503.82 13,636.64132.82 109 - Real Estate Excise Tax 4,833,004.91 4,947,199.66114,194.75 111 - Impact Mitigation Fee 5,424,989.10 5,426,607.141,618.04 206 - Bond Redemption Fund 0.00 0.000.00 302 - Capital Construction 244,903.87 245,492.84588.97 304 - Street Capital Projects 2,208,325.14 2,182,573.52-25,751.62 401 - Water-Sewer Utilities 0.00 0.000.00 403 - Water-Sewer Cumulative Reserve 0.00 0.000.00 411 - Water Operating 3,718,582.01 3,841,838.70123,256.69 412 - Water Stabilization 960,072.26 963,036.652,964.39 413 - Water Capital 7,692,687.83 7,613,483.39-79,204.44 414 - Water Debt Service 0.00 0.000.00 421 - Storm Drainage Utility 2,029,423.79 2,070,514.5941,090.80 422 - Storm Drainage Stabilization 539,407.77 541,073.291,665.52 423 - Storm Drainage Capital Facil 94,965.77 95,258.99293.22 424 - Storm Drainage Debt Service 0.00 0.000.00 431 - Sewer Operating 5,521,888.21 5,652,335.58130,447.37 432 - Sewer Stabilization 1,436,790.86 1,441,227.204,436.34 433 - Sewer Capital 5,732,491.93 5,774,789.1642,297.23 434 - Sewer Debt Service 555,215.38 556,929.701,714.32 500 - Equipment Rental and Revolving 4,055,033.40 3,977,872.24-77,161.16 631 - Trust and Agency 7,556.33 7,225.21-331.12 632 - Wastewater Treatment Facil Fee 5,237,640.60 5,263,689.4626,048.86 Grand Total:72,107,412.33 72,413,562.21306,149.88 Cash & Investment Report