2020.05 Monthly Budget ReportMONTHLY BUDGET FINANCIAL STATUS UPDATE
To: Mayor and Councilmembers
From: Noah Crocker, Finance Director
Period: May 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.
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.
The revenues through May 2020 are trending just above budgeted at 47.58%. The effects of the COVID19
pandemic had little effect
on May Revenues. Future
reports will show what
effects the COVID19
Pandemic may have on the
City’s Current Expense
Fund Revenues.
The table provides budget
versus actual (YTD) data by
source of revenue. The
table also shows revenue
received for the month of
May.
SALES TAX REVENUES SUMMARY
• Total 2020 Budget: $5,085,000
• Total 2020 YTD Actuals: $2,137,180
• Year-to-Date Actual revenue collected is 6.66% higher when compared to Year-to Date Budgeted
• Year-to-Date Actual revenue collected is 2.90% higher when compared to Prior Year-to Date Actuals
The following tables provide additional sales tax information.
Revenue Source
2020
Original
Budget
2020 Current
Budget 2020 YTD
% of
Budget
Received
Received
May 2020
Property Tax 1,900,000 1,900,000 976,327 51.39%137,672
Sales Tax 5,085,000 5,085,000 2,137,180 42.03%415,936
Other Taxes 2,125,000 2,125,000 1,064,066 50.07%158,496
Total Taxes 9,110,000 9,110,000 4,177,574 45.86% 712,105
Licenses & Permits 405,300 405,300 237,247 58.54%66,607
Intergovernmental Revenue 226,700 226,700 111,138 49.02%139
Charges for Goods & Services 444,800 444,800 274,999 61.83%56,321
Fines & Penalties 179,700 179,700 75,940 42.26%12,621
Misc Revenues 173,800 173,800 128,227 73.78%6,228
Non-Revenues - - 4,431 0.00%1,936
Capital Contributions - - 5,000 0.00%-
REVENUE TOTALS 10,540,300 10,540,300 5,014,556 47.58%855,957
Table 1: shows revenue received by month over a three-year period.
Page 2 of 10
Real Estate Excise Tax (REET) Fund 109 and Impact Mitigation Fee Fund 111
Real Estate Excise Tax receipts fluctuate monthly but are currently trending lower (-16.78%) than revenue received
in the same time-period for 2019. This would most likely be due to the COVID19 pandemic. While REET is trending
lower than 2019 actuals, it is still coming in above what was projected for the 2020 budget year. The table below
shows biennial balances through May 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 May are as follows: McCormick
Woods Transportation $17,996.08, Parks $13,787, Transportation $27,449.20. REET revenues received in May:
REET 1 received $20,007.88, REET 2 received $20,007.89.
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*214,767 120,397 7,099 393,461 708,961 709,003 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 235,559 14,663 10,288 235,955 776,184 558,296 93,112
*Revenue received includes interest earned
Table 2: provides current data for sales tax revenue collected Year-to-date.
Page 3 of 10
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 May
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 May
ENTERPRISE/UTILITY FUNDS:
Water operation - Water operations budgeted revenues in the amount of $3,353,200 for 2020. Through May the
City has received 38.83% 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. Future months
will show the impact that
COVID19 may have on
our Water Utility
revenues.
Operational expenses
through the end of May
are at 36.48% 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 are currently approximately $1.541 million of transfers
budgeted in 2019-2020 which have not occurred yet.
Page 4 of 10
Sewer operation -
Sewer Operational
Revenues for the
period ending May
2020 are trending as
projected at 41.73%
of the annual
budgeted revenue.
Operational Sewer
expenses are at
29.99% for the
period ending May
2020 leaving 70.01%
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 are currently
approximately $2.295 million of transfers budgeted in 2019-2020 which have not occurred yet.
Storm Drainage operations -As of May 31st the Storm Drainage utility has received 47.69% of its annual budgeted
revenue. Trending slightly higher than projected.
Expenses through May 31st
for the Storm Drainage
Operations Fund are at
31.49%, leaving 68.51%
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.
Page 5 of 10
6/9/2020 11:53:15 AM
Budget Report
City of Port Orchard Group Summary
For Fiscal: 2020 Period Ending: 05/31/2020
Fiscal
Activity
Variance
Favorable
(Unfavorable)
Period
ActivityDepartmen…
Current
Total Budget
Original
Total Budget
Percent
Remaining
Fund: 001 - Current Expense
Revenue
00 - Revenues 5,014,556.01855,956.8910,540,300.00 10,540,300.00 -5,525,743.99 52.42 %
5,014,556.01855,956.8910,540,300.00 10,540,300.00 -5,525,743.99Revenue Total:52.42 %
Expense
01 - Finance 336,403.5373,439.39872,500.00 872,500.00 536,096.47 61.44 %
02 - Court 216,152.2550,551.83709,600.00 709,600.00 493,447.75 69.54 %
03 - Law Enforcement 1,770,000.12424,471.395,368,387.00 5,368,387.00 3,598,386.88 67.03 %
04 - Community Development 537,072.04137,020.841,435,917.00 1,435,917.00 898,844.96 62.60 %
05 - Public Works 515,932.7472,520.791,126,771.00 1,126,771.00 610,838.26 54.21 %
06 - Miscellaneous 1,175.000.00350,000.00 350,000.00 348,825.00 99.66 %
07 - Administration 455,384.1886,502.761,191,018.00 1,191,018.00 735,633.82 61.77 %
3,832,119.86844,507.0011,054,193.00 11,054,193.00 7,222,073.14Expense Total:65.33 %
1,182,436.1511,449.89-513,893.00 -513,893.00 1,696,329.15Fund: 001 - Current Expense Surplus (Deficit):330.09 %
Fund: 002 - City Street Fund
Revenue
00 - Revenues 740,937.74114,746.511,634,000.00 1,634,000.00 -893,062.26 54.65 %
740,937.74114,746.511,634,000.00 1,634,000.00 -893,062.26Revenue Total:54.65 %
Expense
05 - Public Works 474,915.49115,520.491,683,871.00 1,683,871.00 1,208,955.51 71.80 %
474,915.49115,520.491,683,871.00 1,683,871.00 1,208,955.51Expense Total:71.80 %
266,022.25-773.98-49,871.00 -49,871.00 315,893.25Fund: 002 - City Street Fund Surplus (Deficit):633.42 %
Fund: 003 - Stabilization Fund
Revenue
00 - Revenues 6,120.74570.60200,000.00 200,000.00 -193,879.26 96.94 %
6,120.74570.60200,000.00 200,000.00 -193,879.26Revenue Total:96.94 %
6,120.74570.60200,000.00 200,000.00 -193,879.26Fund: 003 - Stabilization Fund Total:96.94 %
Fund: 103 - Criminal Justice
Revenue
00 - Revenues 132,935.1118,391.50244,700.00 244,700.00 -111,764.89 45.67 %
132,935.1118,391.50244,700.00 244,700.00 -111,764.89Revenue Total:45.67 %
Expense
03 - Law Enforcement 62,381.1814,269.95325,686.00 325,686.00 263,304.82 80.85 %
62,381.1814,269.95325,686.00 325,686.00 263,304.82Expense Total:80.85 %
70,553.934,121.55-80,986.00 -80,986.00 151,539.93Fund: 103 - Criminal Justice Surplus (Deficit):187.12 %
Fund: 104 - Special Investigative Unit
Revenue
00 - Revenues 2,458.43112.214,000.00 4,000.00 -1,541.57 38.54 %
2,458.43112.214,000.00 4,000.00 -1,541.57Revenue Total:38.54 %
Expense
03 - Law Enforcement 1,314.0011.722,200.00 2,200.00 886.00 40.27 %
1,314.0011.722,200.00 2,200.00 886.00Expense Total:40.27 %
1,144.43100.491,800.00 1,800.00 -655.57Fund: 104 - Special Investigative Unit Surplus (Deficit):36.42 %
Fund: 107 - Community Events
Revenue
00 - Revenues 41,618.647,224.39100,000.00 100,000.00 -58,381.36 58.38 %
41,618.647,224.39100,000.00 100,000.00 -58,381.36Revenue Total:58.38 %
OPERATIONS_______________________________________________________________________________________________
Page 6 of 10
Budget Report For Fiscal: 2020 Period Ending: 05/31/2020
6/9/2020 11:53:15 AM
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 6,378.341,500.00109,700.00 109,700.00 103,321.66 94.19 %
6,378.341,500.00112,200.00 112,200.00 105,821.66Expense Total:94.32 %
35,240.305,724.39-12,200.00 -12,200.00 47,440.30Fund: 107 - Community Events Surplus (Deficit):388.85 %
Fund: 108 - Paths & Trails
Revenue
00 - Revenues 497.5660.991,000.00 1,000.00 -502.44 50.24 %
497.5660.991,000.00 1,000.00 -502.44Revenue Total:50.24 %
497.5660.991,000.00 1,000.00 -502.44Fund: 108 - Paths & Trails Total:50.24 %
Fund: 109 - Real Estate Excise Tax
Revenue
00 - Revenues 311,261.0241,987.97700,000.00 700,000.00 -388,738.98 55.53 %
311,261.0241,987.97700,000.00 700,000.00 -388,738.98Revenue Total:55.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 %
276,007.9441,987.97700,000.00 700,000.00 -423,992.06Fund: 109 - Real Estate Excise Tax Surplus (Deficit):60.57 %
Fund: 111 - Impact Mitigation Fee
Revenue
00 - Revenues 363,824.5660,448.01140,000.00 140,000.00 223,824.56 159.87 %
363,824.5660,448.01140,000.00 140,000.00 223,824.56Revenue Total:159.87 %
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 %
363,824.5660,448.01-10,000.00 140,000.00 223,824.56Fund: 111 - Impact Mitigation Fee Surplus (Deficit):-159.87 %
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,302,035.43269,047.933,353,200.00 3,353,200.00 -2,051,164.57 61.17 %
1,302,035.43269,047.933,353,200.00 3,353,200.00 -2,051,164.57Revenue Total:61.17 %
Expense
05 - Public Works 1,016,133.27174,181.302,785,638.00 2,785,638.00 1,769,504.73 63.52 %
1,016,133.27174,181.302,785,638.00 2,785,638.00 1,769,504.73Expense Total:63.52 %
285,902.1694,866.63567,562.00 567,562.00 -281,659.84Fund: 411 - Water Operating Surplus (Deficit):49.63 %
Fund: 412 - Water Stabilization
Revenue
00 - Revenues 506.1743.05290,000.00 290,000.00 -289,493.83 99.83 %
506.1743.05290,000.00 290,000.00 -289,493.83Revenue Total:99.83 %
506.1743.05290,000.00 290,000.00 -289,493.83Fund: 412 - Water Stabilization Total:99.83 %
Fund: 414 - Water Debt Service
Revenue
00 - Revenues 8,075.000.0050,000.00 50,000.00 -41,925.00 83.85 %
8,075.000.0050,000.00 50,000.00 -41,925.00Revenue Total:83.85 %
Page 7 of 10
Budget Report For Fiscal: 2020 Period Ending: 05/31/2020
6/9/2020 11:53:15 AM
Fiscal
Activity
Variance
Favorable
(Unfavorable)
Period
ActivityDepartmen…
Current
Total Budget
Original
Total Budget
Percent
Remaining
Expense
05 - Public Works 8,075.000.0050,000.00 50,000.00 41,925.00 83.85 %
8,075.000.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 781,850.79155,474.851,639,500.00 1,639,500.00 -857,649.21 52.31 %
781,850.79155,474.851,639,500.00 1,639,500.00 -857,649.21Revenue Total:52.31 %
Expense
05 - Public Works 446,487.73103,652.361,417,956.00 1,417,956.00 971,468.27 68.51 %
446,487.73103,652.361,417,956.00 1,417,956.00 971,468.27Expense Total:68.51 %
335,363.0651,822.49221,544.00 221,544.00 113,819.06Fund: 421 - Storm Drainage Utility Surplus (Deficit):-51.38 %
Fund: 422 - Storm Drainage Stabilization
Revenue
00 - Revenues 838.7071.3310,200.00 10,200.00 -9,361.30 91.78 %
838.7071.3310,200.00 10,200.00 -9,361.30Revenue Total:91.78 %
838.7071.3310,200.00 10,200.00 -9,361.30Fund: 422 - Storm Drainage Stabilization Total:91.78 %
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 2,264,678.08450,605.885,427,400.00 5,427,400.00 -3,162,721.92 58.27 %
2,264,678.08450,605.885,427,400.00 5,427,400.00 -3,162,721.92Revenue Total:58.27 %
Expense
05 - Public Works 1,388,425.35282,181.674,629,788.00 4,629,788.00 3,241,362.65 70.01 %
1,388,425.35282,181.674,629,788.00 4,629,788.00 3,241,362.65Expense Total:70.01 %
876,252.73168,424.21797,612.00 797,612.00 78,640.73Fund: 431 - Sewer Operating Surplus (Deficit):-9.86 %
Fund: 432 - Sewer Stabilization
Revenue
00 - Revenues 1,809.87188.8618,400.00 18,400.00 -16,590.13 90.16 %
1,809.87188.8618,400.00 18,400.00 -16,590.13Revenue Total:90.16 %
1,809.87188.8618,400.00 18,400.00 -16,590.13Fund: 432 - Sewer Stabilization Total:90.16 %
Fund: 500 - Equipment Rental and Revolving
Revenue
00 - Revenues 154,666.1723,714.31753,402.00 753,402.00 -598,735.83 79.47 %
154,666.1723,714.31753,402.00 753,402.00 -598,735.83Revenue Total:79.47 %
Expense
10 - ER&R 869,732.7568,453.89370,857.00 370,857.00 -498,875.75 -134.52 %
869,732.7568,453.89370,857.00 370,857.00 -498,875.75Expense Total:-134.52 %
-715,066.58-44,739.58382,545.00 382,545.00 -1,097,611.58Fund: 500 - Equipment Rental and Revolving Surplus (Deficit):286.92 %
Report Surplus (Deficit):394,366.90 2,987,453.982,225,706.00 2,375,706.00 611,747.98 -25.75 %
Page 8 of 10
6/9/2020 11:32:40 AM
Budget Report
City of Port Orchard Group Summary
For Fiscal: 2020 Period Ending: 05/31/2020
Fiscal
Activity
Variance
Favorable
(Unfavorable)
Period
ActivityAccount Typ…
Current
Total Budget
Original
Total Budget
Percent
Remaining
Fund: 302 - Capital Construction
Revenue 785.67102.660.00 0.00 785.67 0.00 %
Expense 611.120.00318,000.00 225,000.00 224,388.88 99.73 %
174.55102.66-318,000.00 -225,000.00 225,174.55Fund: 302 - Capital Construction Surplus (Deficit):100.08 %
Fund: 304 - Street Capital Projects
Revenue 456,782.602,061.69150,000.00 0.00 456,782.60 0.00 %
Expense 260,448.054,551.88592,594.00 360,594.00 100,145.95 27.77 %
196,334.55-2,490.19-442,594.00 -360,594.00 556,928.55Fund: 304 - Street Capital Projects Surplus (Deficit):154.45 %
Fund: 413 - Water Capital
Revenue 1,238,602.26113,706.722,562,500.00 2,562,500.00 -1,323,897.74 51.66 %
Expense 1,434,846.9099,954.804,480,500.00 4,495,444.00 3,060,597.10 68.08 %
-196,244.6413,751.92-1,918,000.00 -1,932,944.00 1,736,699.36Fund: 413 - Water Capital Surplus (Deficit):89.85 %
Fund: 423 - Storm Drainage Capital Facil
Revenue 2,501.64212.770.00 0.00 2,501.64 0.00 %
Expense 0.000.00501,640.00 269,703.00 269,703.00 100.00 %
2,501.64212.77-501,640.00 -269,703.00 272,204.64Fund: 423 - Storm Drainage Capital Facil Surplus (Deficit):100.93 %
Fund: 433 - Sewer Capital
Revenue 278,732.99105,059.592,155,000.00 2,155,000.00 -1,876,267.01 87.07 %
Expense 509,490.7574,479.223,772,400.00 4,973,883.00 4,464,392.25 89.76 %
-230,757.7630,580.37-1,617,400.00 -2,818,883.00 2,588,125.24Fund: 433 - Sewer Capital Surplus (Deficit):91.81 %
Report Surplus (Deficit):42,157.53 -227,991.66-4,797,634.00 -5,607,124.00 5,379,132.34 95.93 %
CAPITAL PROJECTS____________________________________________________________________________________________________________________________________________________
Page 9 of 10
Detail Report Date Range: 01/01/2020 - 05/31/2020
6/9/2020 12:01:39 PM
Fund Summary
Ending BalanceBeginning BalanceFund Total Activity
001 - Current Expense 5,305,645.21 6,488,081.361,182,436.15
002 - City Street Fund 810,626.43 1,076,648.68266,022.25
003 - Stabilization Fund 1,358,179.13 1,364,299.876,120.74
103 - Criminal Justice 350,829.59 421,383.5270,553.93
104 - Special Investigative Unit 93,804.53 94,948.961,144.43
107 - Community Events 151,872.45 187,112.7535,240.30
108 - Paths & Trails 9,918.17 10,415.73497.56
109 - Real Estate Excise Tax 2,456,556.85 2,732,564.79276,007.94
111 - Impact Mitigation Fee 1,760,925.34 2,124,749.90363,824.56
206 - Bond Redemption Fund 0.00 0.010.01
302 - Capital Construction 301,091.23 301,265.78174.55
304 - Street Capital Projects 2,467,946.32 2,664,280.87196,334.55
401 - Water-Sewer Utilities 0.00 0.000.00
403 - Water-Sewer Cumulative Reserve 0.00 0.000.00
411 - Water Operating 2,198,386.82 2,484,288.98285,902.16
412 - Water Stabilization 101,274.62 101,780.79506.17
413 - Water Capital 2,364,571.54 2,168,326.90-196,244.64
414 - Water Debt Service 0.00 0.000.00
421 - Storm Drainage Utility 1,536,288.66 1,871,651.72335,363.06
422 - Storm Drainage Stabilization 167,808.03 168,646.73838.70
423 - Storm Drainage Capital Facil 623,713.61 626,215.252,501.64
424 - Storm Drainage Debt Service 0.00 0.000.00
431 - Sewer Operating 2,426,527.39 3,302,780.12876,252.73
432 - Sewer Stabilization 444,667.60 446,477.471,809.87
433 - Sewer Capital 3,012,178.48 2,781,420.72-230,757.76
434 - Sewer Debt Service 0.00 0.000.00
500 - Equipment Rental and Revolving 3,850,310.87 3,135,244.29-715,066.58
631 - Trust and Agency 73.25 8,381.818,308.56
632 - Wastewater Treatment Facil Fee 2,623,740.73 2,821,353.84197,613.11
Grand Total:34,416,936.85 37,382,320.842,965,383.99
Page 10 of 10