2019.06 Monthly Budget Report
MONTHLY BUDGET FINANCIAL STATUS UPDATE
To: Mayor and Councilmembers
From: Noah Crocker, Finance Director
Period: January 2019‐June 30th 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. This first Monthly Budget Financial Status Update will report information from January
through June of 2019. Moving forward Finance will provide this as a monthly report which you should see the 2nd
week preceding the end of the reporting Month.
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 information by department on the expense side. The goal
of the City is to be able 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. This budget cycle brought
many changes with new Funds, updates to our general ledger accounts and how we plan and process the City
budgets. We expect that future budget cycles will smooth out revenues and expenditures.
The Budget Report provides information on current revenues and expenditures by Fund. Information included
will be:
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
2
Variance Shows the difference between budgeted and actual.
Percent remaining is the amount still needed to reach the budgeted amount.
DETAIL FUND SUMMARY REPORT
The Detail Fund Summary Report provides information on current total cash & investment balances by Fund.
POINTS OF INTEREST:
Current Expense Fund 001 – Revenues are trending up slightly (4%) through June. We anticipate that this will
smooth out as the year progresses, but we will continue to monitor this closely. Expenses are segregated by
department, with Department 6 being budgeted transfers out. The departments are doing well with their
expenses. As of June 30th all departments have expended less than 50% of their current expense 2019 budget.
Real Estate Excise Tax Fund 109 – Real Estate Excise Tax Revenues are currently trending higher than expected.
However, many of the capital projects the City is engaged in this budget cycle rely on REET as part of their funding
package. This can be seen in the difference between revenues and expenditures. The REET fund balance is
helping to fund these projects. Spending more REET revenues than we receive may hinder funding of future
projects.
Impact Mitigation Fee Fund 111 – These revenues are utilized for capital projects that tie to the area where the
fees were collected. For the most part there are specific projects that may receive funding from this source. In
the 2019 budget, much like REET, we have budgeted higher expenditures for projects that what we anticipate
receiving in revenue. This requires us to use fund balance dollars.
Capital Construction Fund 302 ‐ The City is in the final stages of McCormick Woods Park and Rockwell Park
construction completion.
Street Capital Construction Fund 304 ‐ Construction on Tremont Widening and Bay Street Pedestrian Path
Segment 3, are winding down and should be complete soon. The Bay Street Pedestrian Path Right of Way efforts
are ongoing.
Water Sewer Utility Fund 401 ‐ In 2019 budget the Water and Sewer operating funds were divided into 411 Water
and 431 Sewer. Fund 401 will transfer its remaining funds equally to these two funds and will be closed at the
end of 2019.
Water Sewer Utility Cumulative Reserve Fund 403 ‐ In 2019 budget the Water and Sewer Cumulative Reserve
Funds were divided into 413 Water and 433 Sewer. Fund 403 will transfer its remaining funds equally to these
two funds and will be closed at the end of 2019.
3
SALES TAX REVENUES SUMMARY
The sales tax table provides information on current sales tax revenue collected Year‐to‐date.
Total 2019 Budget: $5,060,000
Total 2019 YTD Actuals: $2,502,055
Year‐to‐Date Actual revenue collected is 3.52% higher when compared to Year‐to Date Budgeted
Year‐to‐Date Actual revenue collected is 2.9% higher when compared to Prior Year‐to Date Actuals
8/2/2019 11:12:55 AM Page 1 of 5
Budget Report
City of Port Orchard Group Summary
For Fiscal: 2019 Period Ending: 06/30/2019
Fiscal
Activity
Variance
Favorable
(Unfavorable)
Period
ActivityDepartmen…
Current
Total Budget
Original
Total Budget
Percent
Remaining
Fund: 001 - Current Expense
Revenue
00 - Revenues 5,666,425.77733,518.2410,403,300.00 10,403,300.00 -4,736,874.23 45.53 %
5,666,425.77733,518.2410,403,300.00 10,403,300.00 -4,736,874.23Revenue Total:45.53 %
Expense
01 - Finance 341,464.2258,644.65853,400.00 853,400.00 511,935.78 59.99 %
02 - Court 255,168.8741,108.31625,500.00 625,500.00 370,331.13 59.21 %
03 - Law Enforcement 2,384,162.71483,807.695,823,008.00 5,823,008.00 3,438,845.29 59.06 %
04 - Community Development 611,113.82107,310.611,378,200.00 1,378,200.00 767,086.18 55.66 %
05 - Public Works 578,813.51137,220.821,262,351.00 1,262,351.00 683,537.49 54.15 %
06 - Miscellaneous 201,000.000.00650,000.00 650,000.00 449,000.00 69.08 %
07 - Administration 527,269.7973,453.781,202,835.00 1,202,835.00 675,565.21 56.16 %
4,898,992.92901,545.8611,795,294.00 11,795,294.00 6,896,301.08Expense Total:58.47 %
767,432.85-168,027.62-1,391,994.00 -1,391,994.00 2,159,426.85Fund: 001 - Current Expense Surplus (Deficit):155.13 %
Fund: 002 - City Street Fund
Revenue
00 - Revenues 906,374.2463,660.441,934,000.00 1,934,000.00 -1,027,625.76 53.13 %
906,374.2463,660.441,934,000.00 1,934,000.00 -1,027,625.76Revenue Total:53.13 %
Expense
05 - Public Works 972,336.09393,921.622,309,591.00 2,309,591.00 1,337,254.91 57.90 %
972,336.09393,921.622,309,591.00 2,309,591.00 1,337,254.91Expense Total:57.90 %
-65,961.85-330,261.18-375,591.00 -375,591.00 309,629.15Fund: 002 - City Street Fund Surplus (Deficit):82.44 %
Fund: 003 - Stabilization Fund
Revenue
00 - Revenues 213,607.222,313.10200,000.00 200,000.00 13,607.22 6.80 %
213,607.222,313.10200,000.00 200,000.00 13,607.22Revenue Total:6.80 %
213,607.222,313.10200,000.00 200,000.00 13,607.22Fund: 003 - Stabilization Fund Total:6.80 %
Fund: 103 - Criminal Justice
Revenue
00 - Revenues 158,612.8621,782.99244,600.00 244,600.00 -85,987.14 35.15 %
158,612.8621,782.99244,600.00 244,600.00 -85,987.14Revenue Total:35.15 %
Expense
03 - Law Enforcement 241,513.6259,744.03591,400.00 591,400.00 349,886.38 59.16 %
241,513.6259,744.03591,400.00 591,400.00 349,886.38Expense Total:59.16 %
-82,900.76-37,961.04-346,800.00 -346,800.00 263,899.24Fund: 103 - Criminal Justice Surplus (Deficit):76.10 %
Fund: 104 - Special Investigative Unit
Revenue
00 - Revenues 3,957.51528.194,000.00 4,000.00 -42.49 1.06 %
3,957.51528.194,000.00 4,000.00 -42.49Revenue Total:1.06 %
Expense
03 - Law Enforcement 94.4315.702,080.00 2,080.00 1,985.57 95.46 %
94.4315.702,080.00 2,080.00 1,985.57Expense Total:95.46 %
3,863.08512.491,920.00 1,920.00 1,943.08Fund: 104 - Special Investigative Unit Surplus (Deficit):-101.20 %
Fund: 107 - Community Events
Revenue
00 - Revenues 49,726.408,650.78100,000.00 100,000.00 -50,273.60 50.27 %
49,726.408,650.78100,000.00 100,000.00 -50,273.60Revenue Total:50.27 %
OPERATIONAL FUNDS
Budget Report For Fiscal: 2019 Period Ending: 06/30/2019
8/2/2019 11:12:55 AM Page 2 of 5
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 %
06 - Miscellaneous 7,049.151,409.83100,000.00 100,000.00 92,950.85 92.95 %
07 - Administration 3,190.770.009,700.00 9,700.00 6,509.23 67.11 %
10,239.921,409.83112,200.00 112,200.00 101,960.08Expense Total:90.87 %
39,486.487,240.95-12,200.00 -12,200.00 51,686.48Fund: 107 - Community Events Surplus (Deficit):423.66 %
Fund: 108 - Paths & Trails
Revenue
00 - Revenues 690.57133.861,000.00 1,000.00 -309.43 30.94 %
690.57133.861,000.00 1,000.00 -309.43Revenue Total:30.94 %
690.57133.861,000.00 1,000.00 -309.43Fund: 108 - Paths & Trails Total:30.94 %
Fund: 109 - Real Estate Excise Tax
Revenue
00 - Revenues 489,436.50112,064.32700,000.00 700,000.00 -210,563.50 30.08 %
489,436.50112,064.32700,000.00 700,000.00 -210,563.50Revenue Total:30.08 %
Expense
06 - Miscellaneous 46,144.677,982.001,634,713.00 1,634,713.00 1,588,568.33 97.18 %
46,144.677,982.001,634,713.00 1,634,713.00 1,588,568.33Expense Total:97.18 %
443,291.83104,082.32-934,713.00 -934,713.00 1,378,004.83Fund: 109 - Real Estate Excise Tax Surplus (Deficit):147.43 %
Fund: 111 - Impact Mitigation Fee
Revenue
00 - Revenues 247,356.2952,081.82140,000.00 140,000.00 107,356.29 76.68 %
247,356.2952,081.82140,000.00 140,000.00 107,356.29Revenue Total:76.68 %
Expense
05 - Public Works 0.000.00335,285.00 335,285.00 335,285.00 100.00 %
0.000.00335,285.00 335,285.00 335,285.00Expense Total:100.00 %
247,356.2952,081.82-195,285.00 -195,285.00 442,641.29Fund: 111 - Impact Mitigation Fee Surplus (Deficit):226.66 %
Fund: 206 - Bond Redemption Fund
Revenue
00 - Revenues 40,578.492,982.00757,383.00 757,383.00 -716,804.51 94.64 %
40,578.492,982.00757,383.00 757,383.00 -716,804.51Revenue Total:94.64 %
Expense
06 - Miscellaneous 37,596.490.00459,376.00 459,376.00 421,779.51 91.82 %
37,596.490.00459,376.00 459,376.00 421,779.51Expense Total:91.82 %
2,982.002,982.00298,007.00 298,007.00 -295,025.00Fund: 206 - Bond Redemption Fund Surplus (Deficit):99.00 %
Fund: 401 - Water-Sewer Utilities
Revenue
00 - Revenues 17,045.992,712.240.00 0.00 17,045.99 0.00 %
17,045.992,712.240.00 0.00 17,045.99Revenue Total:0.00 %
Expense
05 - Public Works 2,000,000.000.002,000,000.00 2,000,000.00 0.00 0.00 %
2,000,000.000.002,000,000.00 2,000,000.00 0.00Expense Total:0.00 %
-1,982,954.012,712.24-2,000,000.00 -2,000,000.00 17,045.99Fund: 401 - Water-Sewer Utilities Surplus (Deficit):0.85 %
Fund: 411 - Water Operating
Revenue
00 - Revenues 2,413,149.96242,955.804,074,100.00 4,074,100.00 -1,660,950.04 40.77 %
2,413,149.96242,955.804,074,100.00 4,074,100.00 -1,660,950.04Revenue Total:40.77 %
Expense
05 - Public Works 1,420,145.16301,214.003,563,478.00 3,563,478.00 2,143,332.84 60.15 %
1,420,145.16301,214.003,563,478.00 3,563,478.00 2,143,332.84Expense Total:60.15 %
993,004.80-58,258.20510,622.00 510,622.00 482,382.80Fund: 411 - Water Operating Surplus (Deficit):-94.47 %
Budget Report For Fiscal: 2019 Period Ending: 06/30/2019
8/2/2019 11:12:55 AM Page 3 of 5
Fiscal
Activity
Variance
Favorable
(Unfavorable)
Period
ActivityDepartmen…
Current
Total Budget
Original
Total Budget
Percent
Remaining
Fund: 412 - Water Stabilization
Revenue
00 - Revenues 100,206.35206.35100,000.00 100,000.00 206.35 0.21 %
100,206.35206.35100,000.00 100,000.00 206.35Revenue Total:0.21 %
100,206.35206.35100,000.00 100,000.00 206.35Fund: 412 - Water Stabilization Total:0.21 %
Fund: 414 - Water Debt Service
Revenue
00 - Revenues 7,551.50551.5080,128.00 80,128.00 -72,576.50 90.58 %
7,551.50551.5080,128.00 80,128.00 -72,576.50Revenue Total:90.58 %
Expense
05 - Public Works 7,000.000.0080,128.00 80,128.00 73,128.00 91.26 %
7,000.000.0080,128.00 80,128.00 73,128.00Expense Total:91.26 %
551.50551.500.00 0.00 551.50Fund: 414 - Water Debt Service Surplus (Deficit):0.00 %
Fund: 421 - Storm Drainage Utility
Revenue
00 - Revenues 922,119.68129,054.361,614,500.00 1,614,500.00 -692,380.32 42.89 %
922,119.68129,054.361,614,500.00 1,614,500.00 -692,380.32Revenue Total:42.89 %
Expense
05 - Public Works 848,381.31320,412.941,989,521.00 1,989,521.00 1,141,139.69 57.36 %
848,381.31320,412.941,989,521.00 1,989,521.00 1,141,139.69Expense Total:57.36 %
73,738.37-191,358.58-375,021.00 -375,021.00 448,759.37Fund: 421 - Storm Drainage Utility Surplus (Deficit):119.66 %
Fund: 422 - Storm Drainage Stabilization
Revenue
00 - Revenues 166,037.96341.92165,000.00 165,000.00 1,037.96 0.63 %
166,037.96341.92165,000.00 165,000.00 1,037.96Revenue Total:0.63 %
166,037.96341.92165,000.00 165,000.00 1,037.96Fund: 422 - Storm Drainage Stabilization Total:0.63 %
Fund: 424 - Storm Drainage Debt Service
Revenue
00 - Revenues 36,769.588,262.66177,764.00 177,764.00 -140,994.42 79.32 %
36,769.588,262.66177,764.00 177,764.00 -140,994.42Revenue Total:79.32 %
Expense
05 - Public Works 36,769.588,262.66177,764.00 177,764.00 140,994.42 79.32 %
36,769.588,262.66177,764.00 177,764.00 140,994.42Expense Total:79.32 %
0.000.000.00 0.00 0.00Fund: 424 - Storm Drainage Debt Service Surplus (Deficit):0.00 %
Fund: 431 - Sewer Operating
Revenue
00 - Revenues 3,558,104.92441,187.085,998,200.00 5,998,200.00 -2,440,095.08 40.68 %
3,558,104.92441,187.085,998,200.00 5,998,200.00 -2,440,095.08Revenue Total:40.68 %
Expense
05 - Public Works 2,255,518.16758,694.876,413,629.00 6,413,629.00 4,158,110.84 64.83 %
2,255,518.16758,694.876,413,629.00 6,413,629.00 4,158,110.84Expense Total:64.83 %
1,302,586.76-317,507.79-415,429.00 -415,429.00 1,718,015.76Fund: 431 - Sewer Operating Surplus (Deficit):413.55 %
Fund: 432 - Sewer Stabilization
Revenue
00 - Revenues 294,453.49147,378.49588,300.00 588,300.00 -293,846.51 49.95 %
294,453.49147,378.49588,300.00 588,300.00 -293,846.51Revenue Total:49.95 %
294,453.49147,378.49588,300.00 588,300.00 -293,846.51Fund: 432 - Sewer Stabilization Total:49.95 %
Fund: 434 - Sewer Debt Service
Revenue
00 - Revenues 551.50551.5030,128.00 30,128.00 -29,576.50 98.17 %
551.50551.5030,128.00 30,128.00 -29,576.50Revenue Total:98.17 %
Budget Report For Fiscal: 2019 Period Ending: 06/30/2019
8/2/2019 11:12:55 AM Page 4 of 5
Fiscal
Activity
Variance
Favorable
(Unfavorable)
Period
ActivityDepartmen…
Current
Total Budget
Original
Total Budget
Percent
Remaining
Expense
05 - Public Works 0.000.0030,128.00 30,128.00 30,128.00 100.00 %
0.000.0030,128.00 30,128.00 30,128.00Expense Total:100.00 %
551.50551.500.00 0.00 551.50Fund: 434 - Sewer Debt Service Surplus (Deficit):0.00 %
Fund: 500 - Equipment Rental and Revolving
Revenue
00 - Revenues 1,781,674.421,283,461.693,479,632.00 3,479,632.00 -1,697,957.58 48.80 %
1,781,674.421,283,461.693,479,632.00 3,479,632.00 -1,697,957.58Revenue Total:48.80 %
Expense
10 - ER&R 193,939.9023,245.361,481,822.00 1,481,822.00 1,287,882.10 86.91 %
193,939.9023,245.361,481,822.00 1,481,822.00 1,287,882.10Expense Total:86.91 %
1,587,734.521,260,216.331,997,810.00 1,997,810.00 -410,075.48Fund: 500 - Equipment Rental and Revolving Surplus (Deficit):20.53 %
Report Surplus (Deficit):477,930.46 4,105,758.95-2,184,374.00 -2,184,374.00 6,290,132.95 287.96 %
8/2/2019 11:10:37 AM Page 1 of 2
Budget Report
City of Port Orchard Group Summary
For Fiscal: 2019 Period Ending: 06/30/2019
Fiscal
Activity
Variance
Favorable
(Unfavorable)
Period
ActivityAccount Typ…
Current
Total Budget
Original
Total Budget
Percent
Remaining
Fund: 302 - Capital Construction
Revenue 91,777.075,234.16818,000.00 818,000.00 -726,222.93 88.78 %
Expense 439,596.42127,038.87500,000.00 500,000.00 60,403.58 12.08 %
-347,819.35-121,804.71318,000.00 318,000.00 -665,819.35Fund: 302 - Capital Construction Surplus (Deficit):209.38 %
Fund: 304 - Street Capital Projects
Revenue 3,029,386.35345,329.515,325,094.00 5,325,094.00 -2,295,707.65 43.11 %
Expense 1,604,081.0348,897.164,882,500.00 4,882,500.00 3,278,418.97 67.15 %
1,425,305.32296,432.35442,594.00 442,594.00 982,711.32Fund: 304 - Street Capital Projects Surplus (Deficit):-222.03 %
Fund: 403 - Water-Sewer Cumulative Reserve
Revenue 8,870.531,328.054,867,000.00 4,867,000.00 -4,858,129.47 99.82 %
Expense 4,867,000.000.004,867,000.00 4,867,000.00 0.00 0.00 %
-4,858,129.471,328.050.00 0.00 -4,858,129.47Fund: 403 - Water-Sewer Cumulative Reserve Surplus (Deficit):0.00 %
Fund: 413 - Water Capital
Revenue 3,316,485.98663,174.845,968,000.00 5,968,000.00 -2,651,514.02 44.43 %
Expense 1,245,567.71137,668.404,050,000.00 4,050,000.00 2,804,432.29 69.25 %
2,070,918.27525,506.441,918,000.00 1,918,000.00 152,918.27Fund: 413 - Water Capital Surplus (Deficit):-7.97 %
Fund: 423 - Storm Drainage Capital Facil
Revenue 11,663.441,936.86670,440.00 670,440.00 -658,776.56 98.26 %
Expense 40,803.750.00168,800.00 168,800.00 127,996.25 75.83 %
-29,140.311,936.86501,640.00 501,640.00 -530,780.31Fund: 423 - Storm Drainage Capital Facil Surplus (Deficit):105.81 %
Fund: 433 - Sewer Capital
Revenue 3,065,342.1472,357.447,314,000.00 7,314,000.00 -4,248,657.86 58.09 %
Expense 202,477.9929,978.675,696,600.00 5,696,600.00 5,494,122.01 96.45 %
2,862,864.1542,378.771,617,400.00 1,617,400.00 1,245,464.15Fund: 433 - Sewer Capital Surplus (Deficit):-77.00 %
Report Surplus (Deficit):745,777.76 1,123,998.614,797,634.00 4,797,634.00 -3,673,635.39 76.57 %
Capital Projects
Detail Report Date Range: 01/01/2019 - 06/30/2019
8/2/2019 11:15:25 AM Page 5 of 5
Fund Summary
Ending BalanceBeginning BalanceFund Total Activity
001 - Current Expense 4,542,596.17 5,310,454.63767,858.46
002 - City Street Fund 664,461.74 598,500.34-65,961.40
003 - Stabilization Fund 933,146.65 1,146,753.87213,607.22
103 - Criminal Justice 513,801.32 430,900.56-82,900.76
104 - Special Investigative Unit 77,460.69 81,323.773,863.08
107 - Community Events 135,246.39 174,732.8739,486.48
108 - Paths & Trails 8,457.04 9,147.61690.57
109 - Real Estate Excise Tax 2,009,946.44 2,453,238.27443,291.83
111 - Impact Mitigation Fee 1,440,068.12 1,687,424.41247,356.29
206 - Bond Redemption Fund 0.00 2,982.002,982.00
302 - Capital Construction 348,715.00 895.65-347,819.35
304 - Street Capital Projects 2,087,099.38 3,512,404.701,425,305.32
401 - Water-Sewer Utilities 3,395,558.23 1,412,604.22-1,982,954.01
403 - Water-Sewer Cumulative Reserve 5,569,427.11 711,297.64-4,858,129.47
411 - Water Operating 0.00 993,079.41993,079.41
412 - Water Stabilization 0.00 100,206.35100,206.35
413 - Water Capital 0.00 2,070,918.272,070,918.27
414 - Water Debt Service 0.00 551.50551.50
421 - Storm Drainage Utility 1,591,817.04 1,665,749.7173,932.67
422 - Storm Drainage Stabilization 0.00 166,037.96166,037.96
423 - Storm Drainage Capital Facil 969,702.93 940,562.62-29,140.31
424 - Storm Drainage Debt Service 0.00 0.000.00
431 - Sewer Operating 0.00 1,302,973.721,302,973.72
432 - Sewer Stabilization 0.00 294,453.49294,453.49
433 - Sewer Capital 0.00 2,862,864.152,862,864.15
434 - Sewer Debt Service 0.00 551.50551.50
500 - Equipment Rental and Revolving 1,082,643.00 2,268,094.001,185,451.00
631 - Trust and Agency 138.84 9,489.759,350.91
632 - Wastewater Treatment Facil Fee 2,553,806.09 2,563,000.679,194.58
Grand Total:27,924,092.18 32,771,193.644,847,101.46
Cash & Investment Summary