2020.04 Monthly Budget Report
MONTHLY BUDGET FINANCIAL STATUS UPDATE
To: Mayor and Councilmembers
From: Noah Crocker, Finance Director
Period: April 2020
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.
The revenues through April 2020 are trending as budgeted at 39.04%. The effects of the COVID19 pandemic are
not yet visible in these
numbers. Future reports will
show the effects of the Shelter
in Place Order. The table
below provides budget versus
actual (YTD) data by source of
revenue. The table also shows
revenue received for the
month of April.
Real Estate Excise Tax Fund 109 and Impact Mitigation Fee Fund 111
Real Estate Excise Tax receipts fluctuate monthly but are currently trending higher (2.36%) than revenue received
in the same time-period for 2019. The table below shows biennial balances through April 2020 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, biennial revenue received, 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. 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 22, 2019. Impact Fees received for the April are as follows: McCormick
Woods Transportation $14,056.94, Parks $6,488, Transportation $164,695.16
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,834 44,266 316,474 542,494 688,136 1,321,810 54,930
2019-2020 Revenue Received*196,407 106,309 7,117 365,445 687,968 688,009 63,182
2019-2020 Expenses Budgeted (51,043) (100,000) (313,285) - (162,914) (1,472,517) (25,000)
2019-2020 Obligated Expenses (465,000) (50,000) - (700,000) (458,000) - -
2019-2020 Ending Balance 217,198 574 10,306 207,939 755,190 537,302 93,112
*Revenue received includes interest earned
Revenue Source
2020
Original
Budget
2020
Current
Budget
2020 YTD
% of
Budget
Received
Received
April 2020
Property Tax 1,900,000 1,900,000 838,655 44.14%726,585
Sales Tax 5,085,000 5,085,000 1,721,244 33.85%359,821
Other Taxes 2,125,000 2,125,000 905,570 42.62%355,270
Total Taxes 9,110,000 9,110,000 3,465,469 38.04%1,441,676
Licenses & Permits 405,300 405,300 170,640 42.10%40,354
Intergovernmental Revenue 226,700 226,700 111,000 48.96%22,192
Charges for Goods & Services 444,800 444,800 218,678 49.16%43,450
Fines & Penalties 179,700 179,700 63,320 35.24%11,729
Misc Revenues 173,800 173,800 121,998 70.19%9,028
Non-Revenues - - 2,495 0.00%(93)
Capital Contributions - - 5,000 0.00%5,000
REVENUE TOTALS 10,540,300 10,540,300 4,158,599 39.45%1,573,335
Current Expense Fund Revenues
Capital Construction Fund 302 – The McCormick Woods Splash Pad is budgeted for later this year but there has not
yet been any activity -No Change for April
Street Capital Construction Fund 304 – Public Works is continuing to work to close out the Tremont Widening
Project. The Bay Street Pedestrian Path Right of Way efforts are ongoing. – No change for April
ENTERPRISE/UTILITY FUNDS:
Water operation - Water operations budgeted revenues in the amount of $3,353,200 for 2020. Through April
30th the City has received 30.81% of the annual 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.
Operational expenses through April 31st are at 30.22% of the annual budgeted expense. 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.541 million of transfers budgeted in 2019-2020 which have not occurred yet.
Sewer operation - Sewer Operational Revenues for the period ending April 2020 are trending as projected at
33.42% of the annual budgeted revenue.
Operational Sewer expenses are at 33.42% for the period ending April 2020 leaving 66.58% of available annual
budget authority remaining. 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 approximately $2.295 million of transfers
budgeted in 2019-2020 which have not occurred yet.
Storm Drainage operations -As of April 30th the Storm Drainage utility has received 38.21% of its annual budgeted
revenue. Trending slightly higher than projected.
Expenses through April 30th for the Storm Drainage Operations Fund are at 24.18%, leaving 75.82% remaining
budget authority through the end of the year. The storm drainage 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 Storm Drainage Capital Project, Debt or ER&R fund. Thus, there is currently
approximately $268,000 of transfers budgeted in 2019-2020 which have not occurred yet.
SALES TAX REVENUES SUMMARY
• Total 2020 Budget: $5,085,000
• Total 2020 YTD Actuals: $1,721,244
• Year-to-Date Actual revenue collected is 8.74% higher when compared to Year-to Date Budgeted
• Year-to-Date Actual revenue collected is 3.91% 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.
5/12/2020 1:33:31 PM Page 1 of 4
Budget Report
City of Port Orchard Group Summary
For Fiscal: 2020 Period Ending: 04/30/2020
Fiscal
Activity
Variance
Favorable
(Unfavorable)
Period
ActivityDepartmen…
Current
Total Budget
Original
Total Budget
Percent
Remaining
Fund: 001 - Current Expense
Revenue
00 - Revenues 4,158,599.121,573,335.3610,540,300.00 10,540,300.00 -6,381,700.88 60.55 %
4,158,599.121,573,335.3610,540,300.00 10,540,300.00 -6,381,700.88Revenue Total:60.55 %
Expense
01 - Finance 262,964.1454,679.63872,500.00 872,500.00 609,535.86 69.86 %
02 - Court 165,600.4245,045.47709,600.00 709,600.00 543,999.58 76.66 %
03 - Law Enforcement 1,345,005.20347,714.745,368,387.00 5,368,387.00 4,023,381.80 74.95 %
04 - Community Development 400,051.20105,797.961,435,917.00 1,435,917.00 1,035,865.80 72.14 %
05 - Public Works 443,411.9593,021.611,126,771.00 1,126,771.00 683,359.05 60.65 %
06 - Miscellaneous 1,175.0075.00350,000.00 350,000.00 348,825.00 99.66 %
07 - Administration 368,881.4293,988.621,191,018.00 1,191,018.00 822,136.58 69.03 %
2,987,089.33740,323.0311,054,193.00 11,054,193.00 8,067,103.67Expense Total:72.98 %
1,171,509.79833,012.33-513,893.00 -513,893.00 1,685,402.79Fund: 001 - Current Expense Surplus (Deficit):327.97 %
Fund: 002 - City Street Fund
Revenue
00 - Revenues 626,191.23427,235.161,634,000.00 1,634,000.00 -1,007,808.77 61.68 %
626,191.23427,235.161,634,000.00 1,634,000.00 -1,007,808.77Revenue Total:61.68 %
Expense
05 - Public Works 359,395.0090,419.331,683,871.00 1,683,871.00 1,324,476.00 78.66 %
359,395.0090,419.331,683,871.00 1,683,871.00 1,324,476.00Expense Total:78.66 %
266,796.23336,815.83-49,871.00 -49,871.00 316,667.23Fund: 002 - City Street Fund Surplus (Deficit):634.97 %
Fund: 003 - Stabilization Fund
Revenue
00 - Revenues 5,550.14898.43200,000.00 200,000.00 -194,449.86 97.22 %
5,550.14898.43200,000.00 200,000.00 -194,449.86Revenue Total:97.22 %
5,550.14898.43200,000.00 200,000.00 -194,449.86Fund: 003 - Stabilization Fund Total:97.22 %
Fund: 103 - Criminal Justice
Revenue
00 - Revenues 114,543.6131,974.75244,700.00 244,700.00 -130,156.39 53.19 %
114,543.6131,974.75244,700.00 244,700.00 -130,156.39Revenue Total:53.19 %
Expense
03 - Law Enforcement 48,111.2310,185.12325,686.00 325,686.00 277,574.77 85.23 %
48,111.2310,185.12325,686.00 325,686.00 277,574.77Expense Total:85.23 %
66,432.3821,789.63-80,986.00 -80,986.00 147,418.38Fund: 103 - Criminal Justice Surplus (Deficit):182.03 %
Fund: 104 - Special Investigative Unit
Revenue
00 - Revenues 2,346.221,021.744,000.00 4,000.00 -1,653.78 41.34 %
2,346.221,021.744,000.00 4,000.00 -1,653.78Revenue Total:41.34 %
Expense
03 - Law Enforcement 1,302.2811.482,200.00 2,200.00 897.72 40.81 %
1,302.2811.482,200.00 2,200.00 897.72Expense Total:40.81 %
1,043.941,010.261,800.00 1,800.00 -756.06Fund: 104 - Special Investigative Unit Surplus (Deficit):42.00 %
Fund: 107 - Community Events
Revenue
00 - Revenues 34,394.259,974.41100,000.00 100,000.00 -65,605.75 65.61 %
34,394.259,974.41100,000.00 100,000.00 -65,605.75Revenue Total:65.61 %
OPERATING FUNDS
Budget Report For Fiscal: 2020 Period Ending: 04/30/2020
5/12/2020 1:33:31 PM Page 2 of 4
Fiscal
Activity
Variance
Favorable
(Unfavorable)
Period
ActivityDepartmen…
Current
Total Budget
Original
Total Budget
Percent
Remaining
Expense
01 - Finance 0.000.002,500.00 2,500.00 2,500.00 100.00 %
07 - Administration 4,878.341,500.00109,700.00 109,700.00 104,821.66 95.55 %
4,878.341,500.00112,200.00 112,200.00 107,321.66Expense Total:95.65 %
29,515.918,474.41-12,200.00 -12,200.00 41,715.91Fund: 107 - Community Events Surplus (Deficit):341.93 %
Fund: 108 - Paths & Trails
Revenue
00 - Revenues 436.5798.271,000.00 1,000.00 -563.43 56.34 %
436.5798.271,000.00 1,000.00 -563.43Revenue Total:56.34 %
436.5798.271,000.00 1,000.00 -563.43Fund: 108 - Paths & Trails Total:56.34 %
Fund: 109 - Real Estate Excise Tax
Revenue
00 - Revenues 269,273.0560,654.79700,000.00 700,000.00 -430,726.95 61.53 %
269,273.0560,654.79700,000.00 700,000.00 -430,726.95Revenue Total:61.53 %
Expense
06 - Miscellaneous 35,253.080.000.00 0.00 -35,253.08 0.00 %
35,253.080.000.00 0.00 -35,253.08Expense Total:0.00 %
234,019.9760,654.79700,000.00 700,000.00 -465,980.03Fund: 109 - Real Estate Excise Tax Surplus (Deficit):66.57 %
Fund: 111 - Impact Mitigation Fee
Revenue
00 - Revenues 303,376.55191,273.12140,000.00 140,000.00 163,376.55 116.70 %
303,376.55191,273.12140,000.00 140,000.00 163,376.55Revenue Total:116.70 %
Expense
05 - Public Works 0.000.00150,000.00 0.00 0.00 0.00 %
0.000.00150,000.00 0.00 0.00Expense Total:0.00 %
303,376.55191,273.12-10,000.00 140,000.00 163,376.55Fund: 111 - Impact Mitigation Fee Surplus (Deficit):-116.70 %
Fund: 206 - Bond Redemption Fund
Revenue
00 - Revenues 35,253.080.000.00 0.00 35,253.08 0.00 %
35,253.080.000.00 0.00 35,253.08Revenue Total:0.00 %
Expense
06 - Miscellaneous 35,253.070.00298,007.00 298,007.00 262,753.93 88.17 %
35,253.070.00298,007.00 298,007.00 262,753.93Expense Total:88.17 %
0.010.00-298,007.00 -298,007.00 298,007.01Fund: 206 - Bond Redemption Fund Surplus (Deficit):100.00 %
Fund: 411 - Water Operating
Revenue
00 - Revenues 1,032,987.50251,682.813,353,200.00 3,353,200.00 -2,320,212.50 69.19 %
1,032,987.50251,682.813,353,200.00 3,353,200.00 -2,320,212.50Revenue Total:69.19 %
Expense
05 - Public Works 841,951.97180,215.262,785,638.00 2,785,638.00 1,943,686.03 69.78 %
841,951.97180,215.262,785,638.00 2,785,638.00 1,943,686.03Expense Total:69.78 %
191,035.5371,467.55567,562.00 567,562.00 -376,526.47Fund: 411 - Water Operating Surplus (Deficit):66.34 %
Fund: 412 - Water Stabilization
Revenue
00 - Revenues 463.1267.99290,000.00 290,000.00 -289,536.88 99.84 %
463.1267.99290,000.00 290,000.00 -289,536.88Revenue Total:99.84 %
463.1267.99290,000.00 290,000.00 -289,536.88Fund: 412 - Water Stabilization Total:99.84 %
Fund: 414 - Water Debt Service
Revenue
00 - Revenues 8,075.008,075.0050,000.00 50,000.00 -41,925.00 83.85 %
8,075.008,075.0050,000.00 50,000.00 -41,925.00Revenue Total:83.85 %
Budget Report For Fiscal: 2020 Period Ending: 04/30/2020
5/12/2020 1:33:31 PM Page 3 of 4
Fiscal
Activity
Variance
Favorable
(Unfavorable)
Period
ActivityDepartmen…
Current
Total Budget
Original
Total Budget
Percent
Remaining
Expense
05 - Public Works 8,075.008,075.0050,000.00 50,000.00 41,925.00 83.85 %
8,075.008,075.0050,000.00 50,000.00 41,925.00Expense Total:83.85 %
0.000.000.00 0.00 0.00Fund: 414 - Water Debt Service Surplus (Deficit):0.00 %
Fund: 421 - Storm Drainage Utility
Revenue
00 - Revenues 626,375.94136,321.241,639,500.00 1,639,500.00 -1,013,124.06 61.79 %
626,375.94136,321.241,639,500.00 1,639,500.00 -1,013,124.06Revenue Total:61.79 %
Expense
05 - Public Works 342,835.3778,045.321,417,956.00 1,417,956.00 1,075,120.63 75.82 %
342,835.3778,045.321,417,956.00 1,417,956.00 1,075,120.63Expense Total:75.82 %
283,540.5758,275.92221,544.00 221,544.00 61,996.57Fund: 421 - Storm Drainage Utility Surplus (Deficit):-27.98 %
Fund: 422 - Storm Drainage Stabilization
Revenue
00 - Revenues 767.37112.6510,200.00 10,200.00 -9,432.63 92.48 %
767.37112.6510,200.00 10,200.00 -9,432.63Revenue Total:92.48 %
767.37112.6510,200.00 10,200.00 -9,432.63Fund: 422 - Storm Drainage Stabilization Total:92.48 %
Fund: 424 - Storm Drainage Debt Service
Revenue
00 - Revenues 27,245.090.00176,990.00 176,990.00 -149,744.91 84.61 %
27,245.090.00176,990.00 176,990.00 -149,744.91Revenue Total:84.61 %
Expense
05 - Public Works 27,245.090.00176,990.00 176,990.00 149,744.91 84.61 %
27,245.090.00176,990.00 176,990.00 149,744.91Expense Total:84.61 %
0.000.000.00 0.00 0.00Fund: 424 - Storm Drainage Debt Service Surplus (Deficit):0.00 %
Fund: 431 - Sewer Operating
Revenue
00 - Revenues 1,814,072.20502,526.685,427,400.00 5,427,400.00 -3,613,327.80 66.58 %
1,814,072.20502,526.685,427,400.00 5,427,400.00 -3,613,327.80Revenue Total:66.58 %
Expense
05 - Public Works 1,106,243.68269,809.874,629,788.00 4,629,788.00 3,523,544.32 76.11 %
1,106,243.68269,809.874,629,788.00 4,629,788.00 3,523,544.32Expense Total:76.11 %
707,828.52232,716.81797,612.00 797,612.00 -89,783.48Fund: 431 - Sewer Operating Surplus (Deficit):11.26 %
Fund: 432 - Sewer Stabilization
Revenue
00 - Revenues 1,621.01298.2318,400.00 18,400.00 -16,778.99 91.19 %
1,621.01298.2318,400.00 18,400.00 -16,778.99Revenue Total:91.19 %
1,621.01298.2318,400.00 18,400.00 -16,778.99Fund: 432 - Sewer Stabilization Total:91.19 %
Fund: 500 - Equipment Rental and Revolving
Revenue
00 - Revenues 130,951.8622,977.30753,402.00 753,402.00 -622,450.14 82.62 %
130,951.8622,977.30753,402.00 753,402.00 -622,450.14Revenue Total:82.62 %
Expense
10 - ER&R 801,278.8621,051.20370,857.00 370,857.00 -430,421.86 -116.06 %
801,278.8621,051.20370,857.00 370,857.00 -430,421.86Expense Total:-116.06 %
-670,327.001,926.10382,545.00 382,545.00 -1,052,872.00Fund: 500 - Equipment Rental and Revolving Surplus (Deficit):275.23 %
Report Surplus (Deficit):1,818,892.32 2,593,610.612,225,706.00 2,375,706.00 217,904.61 -9.17 %
5/12/2020 1:28:53 PM Page 1 of 2
Budget Report
City of Port Orchard Group Summary
For Fiscal: 2020 Period Ending: 04/30/2020
Fiscal
Activity
Variance
Favorable
(Unfavorable)
Period
ActivityAccount Typ…
Current
Total Budget
Original
Total Budget
Percent
Remaining
Fund: 302 - Capital Construction
Revenue 683.01161.930.00 0.00 683.01 0.00 %
Expense 611.12611.12318,000.00 225,000.00 224,388.88 99.73 %
71.89-449.19-318,000.00 -225,000.00 225,071.89Fund: 302 - Capital Construction Surplus (Deficit):100.03 %
Fund: 304 - Street Capital Projects
Revenue 454,720.911,592.26150,000.00 0.00 454,720.91 0.00 %
Expense 255,896.17238.60592,594.00 360,594.00 104,697.83 29.03 %
198,824.741,353.66-442,594.00 -360,594.00 559,418.74Fund: 304 - Street Capital Projects Surplus (Deficit):155.14 %
Fund: 413 - Water Capital
Revenue 1,124,895.54836,341.172,562,500.00 2,562,500.00 -1,437,604.46 56.10 %
Expense 1,334,892.10456,795.994,480,500.00 4,495,444.00 3,160,551.90 70.31 %
-209,996.56379,545.18-1,918,000.00 -1,932,944.00 1,722,947.44Fund: 413 - Water Capital Surplus (Deficit):89.14 %
Fund: 423 - Storm Drainage Capital Facil
Revenue 2,288.87336.010.00 0.00 2,288.87 0.00 %
Expense 0.000.00501,640.00 269,703.00 269,703.00 100.00 %
2,288.87336.01-501,640.00 -269,703.00 271,991.87Fund: 423 - Storm Drainage Capital Facil Surplus (Deficit):100.85 %
Fund: 433 - Sewer Capital
Revenue 173,673.4043,851.212,155,000.00 2,155,000.00 -1,981,326.60 91.94 %
Expense 435,011.53303,597.483,772,400.00 4,973,883.00 4,538,871.47 91.25 %
-261,338.13-259,746.27-1,617,400.00 -2,818,883.00 2,557,544.87Fund: 433 - Sewer Capital Surplus (Deficit):90.73 %
Report Surplus (Deficit):121,039.39 -270,149.19-4,797,634.00 -5,607,124.00 5,336,974.81 95.18 %
CAPITAL FUNDS
Detail ReportDate Range: 04/01/2020 - 04/30/20205/12/2020 1:40:00 PMPage 5 of 5Fund SummaryEnding BalanceBeginning BalanceFund Total Activity001 - Current Expense 5,644,152.036,477,164.36833,012.33002 - City Street Fund 740,606.831,077,422.66336,815.83003 - Stabilization Fund 1,362,830.841,363,729.27898.43103 - Criminal Justice 395,472.34417,261.9721,789.63104 - Special Investigative Unit 93,838.2194,848.471,010.26107 - Community Events 172,913.95181,388.368,474.41108 - Paths & Trails 10,256.4710,354.7498.27109 - Real Estate Excise Tax 2,629,922.032,690,576.8260,654.79111 - Impact Mitigation Fee 1,873,028.772,064,301.89191,273.12206 - Bond Redemption Fund 0.010.010.00302 - Capital Construction 301,612.31301,163.12-449.19304 - Street Capital Projects 2,665,417.402,666,771.061,353.66401 - Water-Sewer Utilities 0.000.000.00403 - Water-Sewer Cumulative Reserve 0.000.000.00411 - Water Operating 2,326,547.052,398,014.6071,467.55412 - Water Stabilization 101,669.75101,737.7467.99413 - Water Capital 1,775,029.802,154,574.98379,545.18414 - Water Debt Service 0.000.000.00421 - Storm Drainage Utility 1,771,279.981,829,555.9058,275.92422 - Storm Drainage Stabilization 168,462.75168,575.40112.65423 - Storm Drainage Capital Facil 625,666.47626,002.48336.01424 - Storm Drainage Debt Service 0.000.000.00431 - Sewer Operating 2,883,320.183,116,036.99232,716.81432 - Sewer Stabilization 445,990.38446,288.61298.23433 - Sewer Capital 3,010,586.622,750,840.35-259,746.27434 - Sewer Debt Service 0.000.000.00500 - Equipment Rental and Revolving 3,178,057.773,179,983.871,926.10631 - Trust and Agency 9,348.145,187.28-4,160.86632 - Wastewater Treatment Facil Fee 2,716,956.222,747,876.3230,920.10Grand Total:34,902,966.3036,869,657.251,966,690.95MONTHLY CASH & INVESTMENT FUND SUMMARY