2021.11 Monthly Budget ReportO R
ORCHARD
MONTHLY BUDGET FINANCIAL STATUS UPDATE
To: Mayor and Council members
From: Noah Crocker, Finance Director
Period: November 2021
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 31st, 2021, 86.50% of budgeted revenues were received. With the updated budget revenue is
on track to meet the budget. Of particular importance, the City budgeted $2,250,000 of transfer in to be
reimbursed from the State after the purchase of the Kitsap Bank property.
The table provides budget versus actual (YTD) data by source of revenue.
'2021
Current
Revenue Source
•
Budget
•.•
Property Tax
Budget
1,976,000
1,976,000
1,986,405
Received
100.53%
Sales Tax
5,235,000
6,735,000
6,260,906
92.96%
Other Taxes
2,080,000
2,080,000
2,169,033
104.28%
Total Taxes
9,291,000
10,791,000
10,416,344
96.53%
Licenses & Permits
480,300
854,600
990,333
115.88%
Intergovernmental Revenue
626,600
1,977,139
2,144,026
108.44%
Charges for Goods & Services
389,300
724,300
752,818
103.94%
Fines & Penalties
163,300
163,300
141,224
86.48%
Misc Revenues
177,000
177,000
177,597
100.34%
Non -Revenues
-
-
8,761
#DIV/01
Capital Contributions
-
2,250,000
19,635
0.87%
REVENUE TOTALS 11,127,500 16,937,339 14,650,738 86.50%
SALES TAX REVENUES SUMMARY
1
108,149
598,570
161,106
867,824
109,580
8,869
75,087
8,175
11,154
8,337
510
• Total 2021 Budget: $6,735,000
• Total 2021 YTD Actuals: $6,260,906
• Year -to -Date Actual revenue collected is 19.4% higher when compared to Prior Year -to Date Actuals
• Year -to -Date Actual revenue collected is 1.39% higher when compared to Year -to Date Budgeted
The following tables provide additional sales tax information:
Monthly Sales Tax -Three Year Comparison
700,000
600,000
500,000
• 2019A�u al
400,000
■ 2020Adu al
300,000
• 2021YTDAc[ual
200,000
100,000
O
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.
$700,000 Sales Tax Revenues
ActuaIs 2021
$600 000
$500,000
$400,000
$300,000 Budget 2021
$200,000
$100,000
aarl Bataoft met met
Real Estate Excise Tax (REET) Fund 109 and Impact Mitigation Fee Fund 111
The City's Real Estate Excise Tax receipts fluctuate monthly. 2021 REET revenue is currently coming in
significantly higher (98%) than the same period in prior years. November 2021 receipts are higher than
November 2020 by 13%. 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.
REET
rRecreation
Transport
Parks -_
Irnp.,tafl.10S
Recreation
Reserve
Blue Berry
(001) Bethel (Fund
Reserve
Impact
Impact
Plat SE PA
Admissions
,,
Tax
2021-2022 Beginning Balance
785,820
255,009
326,495
944,142
1,625,464
1,641,128
118,202
2021-2022 Revenue Received*
31,071
223,767
737
1,065,519
982,032
1,659,776
8,928 234,233
2021-2022 Expenses Budgeted
(606,450)
(250,000)
-
(1,643,550)
(729,000)
(1,198,200)
(115,000) (234,233)
2021-2022 Obligated Expenses
-
(228,776)
(327,232)
-
(1,490,500)
(985,500)
-
2021-2022 Ending Balance
210,441
(0)
0
366,111
387,995
1,117,205
12,131
The table above shows 2021 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 2021 are as follows:
o McCormick Woods Transportation $0
o Parks $25,952
o Transportation $147,052
REET revenues received in November:
o REET 1 $48,030
o REET 2 $48,030
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 — The project closeout of Tremont is almost complete. TIB has accepted the
project and the acceptance from WSDOT is in progress. Bay Street Pedestrian Path right of way efforts continue.
The City has contracted with Skillings Inc for Design and Right of Way Services for the Bethel -Lincoln Round -About
project. Design for the project has begun.
ENTERPRISE/UTILITY FUNDS:
Water operation - Water operations budgeted revenue in the amount of $3,344,700 for 2021. Through
November, the city has received $3,584,300 or —107% 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,184,990 through November representing —75% of the 2021 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 2021 budget includes $1,206,500 for transfers. A transfer in
the amount of $430,336 were recorded for November. A transfer of $21,958 was recorded for the water
stabilization fund, a transfer of $337.12 was recorded for Well#13 advertising to begin design for 90-100%.
500,000
450,000
400,000
350,000
300,000
250,000
200,000
150,000
100,000
50, Q00
Water Service Payments
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
■ 2019
■ 2020
■ 2021
Sewer operation - $5,418,800 is budgeted for Sewer Operational Revenues for 2021. Through the month of
November $5,307,152 was received representing —102% of the 2021 budgeted revenues. Sewer Operations
expended $3,727,465 through November representing —90% of the 2021 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 2021 budget includes $374,150 for transfers. A transfer in the amount of $31,179 were recorded
in November for the Sewer stabilization fund, a transfer of $33.69 was recorded for McCormick Sewer #2.
Sewer Service Payments
600,000
500,000 _ ■
400,000
■ 2019
300,000 ■ 2020
200,000 ■ 2021
100,000 Id
J
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov ❑ec
Storm Drainage operations- $1,652,100 is budgeted for Storm Operational Revenues for 2021. As of the end of
November the Storm Drainage utility has received $1,082,693 or —109% of its annual budgeted revenue. Storm
Drainage Operations expended $1,387,757 through November representing —78% of the 2021 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 2021 budget includes $342,150 for transfers. A transfer in the amount
of $13,670 was recorded for the storm stabilization fund in November.
Storm Drainage Payments
180,000
160,000
140,000
120,000
100,000 ■ 2019
80,000 ■ 2020
60,000 ■ 2021
40,000
20,000
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
OPERATIONS
(,�V City of Port Orchard
ORCHARD
Budget Report
Group Summary
For Fiscal: 2021 Period Ending: 11/30/2021
Variance
Original
Current
Period
Fiscal
Favorable
Percent
Departmen...
Total Budget
Total Budget
Activity
Activity
(Unfavorable)
Remaining
Fund: 001-Current Expense
Revenue
00 - Revenues
11,127,500.00
16,937,339.18
1,089,535.40
14,650,737.90
-2,286,601.28
13.50 %
Revenue Total:
11,127,500.00
16,937,339.18
1,089,535.40
14,650,737.90
-2,286,601.28
13.50 %
Expense
01- Finance
845,484.17
845,484.17
60,202.97
678,407.42
167,076.75
19.76 %
02 - Court
745,605.24
745,605.24
36,022.98
415,102.99
330,502.25
44.33 %
03 - Law Enforcement
5,087,610.55
5,092,860.55
343,893.77
3,832,112.31
1,260,748.24
24.76 %
04- Community Development
1,955,200.27
2,456,315.63
167,939.27
1,846,183.96
610,131.67
24.84%
05 - Public Works
1,503,800.42
1,638,800.42
71,191.69
1,185,564.97
453,235.45
27.66 %
06 - Miscellaneous
475,000.00
3,522,700.00
17,943.62
493,856.12
3,028,843.88
85.98 %
07-Administration
1,541,199.35
1,531,822.57
151,787.40
1,252,756.73
279,065.84
18.22%
Expense Total:
12,153,900.00
15,833,588.58
848,981.70
9,703,984.50
6,129,604.08
38.71 %
Fund: 001 - Current Expense Surplus (Deficit):
-1,026,400.00
1,103,750.60
240,553.70
4,946,753.40
3,843,002.80
-348.18 %
Fund: 002 - City Street Fund
Revenue
00 - Revenues
2,080,700.00
2,275,700.00
108,360.18
1,915,825.31
-359,874.69
15.81 %
Revenue Total:
2,080,700.00
2,275,700.00
108,360.18
1,915,825.31
-359,874.69
15.81 %
Expense
05 - Public Works
2,393,500.00
2,478,686.80
151,656.73
1,487,333.34
991,353.46
40.00 %
Expense Total:
2,393,500.00
2,478,686.80
151,656.73
1,487,333.34
991,353.46
40.00 %
Fund: 002 - City Street Fund Surplus (Deficit):
-312,800.00
-202,986.80
-43,296.55
428,491.97
631,478.77
311.09 %
Fund: 003 - Stabilization Fund
Revenue
00 - Revenues
200,000.00
200,000.00
167.67
202,247.01
2,247.01
1.12 %
Revenue Total:
200,000.00
200,000.00
167.67
202,247.01
2,247.01
1.12 %
Fund: 003 - Stabilization Fund Total:
200,000.00
200,000.00
167.67
202,247.01
2,247.01
1.12 %
Fund: 103 - Criminal Justice
Revenue
00 - Revenues
244,800.00
244,800.13
30,088.26
360,403.02
115,602.89
47.22 %
Revenue Total:
244,800.00
244,800.13
30,088.26
360,403.02
115,602.89
47.22 %
Expense
03 - Law Enforcement
284,800.00
284,800.00
11,280.13
196,923.78
87,876.22
30.86 %
Expense Total:
284,800.00
284,800.00
11,280.13
196,923.78
87,876.22
30.86 %
Fund: 103 - Criminal Justice Surplus (Deficit):
-40,000.00
-39,999.87
18,808.13
163,479.24
203,479.11
508.70 %
Fund: 104 - Special Investigative Unit
Revenue
00 - Revenues
4,000.00
4,000.00
20.25
522.93
-3,477.07
86.93 %
Revenue Total:
4,000.00
4,000.00
20.25
522.93
-3,477.07
86.93 %
Expense
03 - Law Enforcement
4,000.00
4,000.00
0.00
359.79
3,640.21
91.01 %
Expense Total:
4,000.00
4,000.00
0.00
359.79
3,640.21
91.01 %
Fund: 104 - Special Investigative Unit Surplus (Deficit):
0.00
0.00
20.25
163.14
163.14
0.00 %
Fund: 107 - Community Events
Revenue
00 - Revenues
100,000.00
100,000.00
14,037.07
111,636.35
11,636.35
11.64 %
Revenue Total:
100,000.00
100,000.00
14,037.07
111,636.35
11,636.35
11.64 %
12/13/2021 4:25:05 PM
Page 1 of 5
Budget Report
For Fiscal: 2021 Period Ending: 11/30/2021
Variance
Original
Current
Period
Fiscal
Favorable
Percent
Departmen...
Total Budget
Total Budget
Activity
Activity
(Unfavorable)
Remaining
Expense
07-Administration
109,700.00
109,700.00
28,405.29
47,995.57
61,704.43
56.25%
Expense Total:
109,700.00
109,700.00
28,405.29
47,995.57
61,704.43
56.25 %
Fund: 107 - Community Events Surplus (Deficit):
-9,700.00
-9,700.00
-14,368.22
63,640.78
73,340.78
756.09 %
Fund: 108 - Paths & Trails
Revenue
00 - Revenues
1,000.00
999.55
103.32
1,088.14
88.59
8.86 %
Revenue Total:
1,000.00
999.55
103.32
1,088.14
88.59
8.86 %
Fund: 108 - Paths & Trails Total:
1,000.00
999.55
103.32
1,088.14
88.59
8.86 %
Fund: 109 - Real Estate Excise Tax
Revenue
00 - Revenues
1,377,400.00
2,227,400.13
97,417.46
2,641,808.14
414,408.01
18.61 %
Revenue Total:
1,377,400.00
2,227,400.13
97,417.46
2,641,808.14
414,408.01
18.61 %
Expense
06 - Miscellaneous
1,292,900.00
1,292,900.00
130,553.30
587,361.99
705,538.01
54.57 %
Expense Total:
1,292,900.00
1,292,900.00
130,553.30
587,361.99
705,538.01
54.57 %
Fund: 109 - Real Estate Excise Tax Surplus (Deficit):
84,500.00
934,500.13
-33,135.84
2,054,446.15
1,119,946.02
-119.84 %
Fund: 111 - Impact Mitigation Fee
Revenue
00 - Revenues
140,000.00
1,055,000.50
173,532.80
1,321,093.35
266,092.85
25.22 %
Revenue Total:
140,000.00
1,055,000.50
173,532.80
1,321,093.35
266,092.85
25.22 %
Expense
05 - Public Works
50,000.00
50,000.00
0.00
28,111.20
21,888.80
43.78 %
06 - Miscellaneous
865,000.00
1,065,000.00
15,117.93
327,280.86
737,719.14
69.27 %
Expense Total:
915,000.00
1,115,000.00
15,117.93
355,392.06
759,607.94
68.13 %
Fund: 111 - Impact Mitigation Fee Surplus (Deficit):
-775,000.00
-59,999.50
158,414.87
965,701.29
1,025,700.79
1,709.52 %
Fund: 206 - Bond Redemption Fund
Revenue
00 - Revenues
299,900.00
299,900.00
0.00
299,751.40
-148.60
0.05 %
Revenue Total:
299,900.00
299,900.00
0.00
299,751.40
-148.60
0.05 %
Expense
06 - Miscellaneous
299,900.00
299,900.00
0.00
299,751.40
148.60
0.05 %
Expense Total:
299,900.00
299,900.00
0.00
299,751.40
148.60
0.05 %
Fund: 206 - Bond Redemption Fund Surplus (Deficit):
0.00
0.00
0.00
0.00
0.00
0.00 %
Fund: 411 - Water Operating
Revenue
00 - Revenues
3,344,700.00
3,344,700.49
308,894.81
3,584,300.03
239,599.54
7.16 %
Revenue Total:
3,344,700.00
3,344,700.49
308,894.81
3,584,300.03
239,599.54
7.16 %
Expense
05 - Public Works
2,889,600.00
2,890,489.89
179,856.19
2,184,989.99
705,499.90
24.41 %
06 - Miscellaneous
1,206,500.00
1,206,500.00
22,295.12
741,929.77
464,570.23
38.51 %
Expense Total:
4,096,100.00
4,096,989.89
202,151.31
2,926,919.76
1,170,070.13
28.56 %
Fund: 411 - Water Operating Surplus (Deficit):
-751,400.00
-752,289.40
106,743.50
657,380.27
1,409,669.67
187.38 %
Fund: 412 - Water Stabilization
Revenue
00 - Revenues
263,500.00
263,500.00
22,001.35
242,007.56
-21,492.44
8.16 %
Revenue Total:
263,500.00
263,500.00
22,001.35
242,007.56
-21,492.44
8.16 %
Fund: 412 - Water Stabilization Total:
263,500.00
263,500.00
22,001.35
242,007.56
-21,492.44
8.16 %
Fund: 414 - Water Debt Service
Revenue
00 - Revenues
485,125.00
485,125.00
2,925.00
414,937.94
-70,187.06
14.47 %
Revenue Total:
485,125.00
485,125.00
2,925.00
414,937.94
-70,187.06
14.47 %
Page 2 of 5
12/13/2021 4:25:05 PM
Budget Report
For Fiscal: 2021 Period Ending: 11/30/2021
Variance
Original
Current
Period
Fiscal
Favorable
Percent
Departmen...
Total Budget
Total Budget
Activity
Activity
(Unfavorable)
Remaining
Expense
06 - Miscellaneous
485,125.00
485,125.00
2,925.00
414,937.94
70,187.06
14.47 %
Expense Total:
485,125.00
485,125.00
2,925.00
414,937.94
70,187.06
14.47 %
Fund: 414 - Water Debt Service Surplus (Deficit):
0.00
0.00
0.00
0.00
0.00
0.00 %
Fund: 421 - Storm Drainage Utility
Revenue
00 - Revenues
1,652,100.00
1,652,100.30
153,150.26
1,802,693.33
150,593.03
9.12 %
Revenue Total:
1,652,100.00
1,652,100.30
153,150.26
1,802,693.33
150,593.03
9.12 %
Expense
05 - Public Works
1,773,850.00
1,774,455.32
129,106.95
1,387,757.20
386,698.12
21.79 %
06 - Miscellaneous
342,150.00
342,150.00
13,670.00
328,302.92
13,847.08
4.05 %
Expense Total:
2,116,000.00
2,116,605.32
142,776.95
1,716,060.12
400,545.20
18.92 %
Fund: 421 - Storm Drainage Utility Surplus (Deficit):
-463,900.00
-464,505.02
10,373.31
86,633.21
551,138.23
118.65 %
Fund: 422 - Storm Drainage Stabilization
Revenue
00 - Revenues
164,000.00
164,000.38
13,692.39
150,601.57
-13,398.81
8.17 %
Revenue Total:
164,000.00
164,000.38
13,692.39
150,601.57
-13,398.81
8.17 %
Fund: 422-Storm Drainage Stabilization Total:
164,000.00
164,000.38
13,692.39
150,601.57
-13,398.81
8.17 %
Fund: 424 - Storm Drainage Debt Service
Revenue
00 - Revenues
178,100.00
178,100.00
0.00
177,929.92
-170.08
0.10 %
Revenue Total:
178,100.00
178,100.00
0.00
177,929.92
-170.08
0.10 %
Expense
06 - Miscellaneous
178,100.00
178,100.00
0.00
177,929.92
170.08
0.10 %
Expense Total:
178,100.00
178,100.00
0.00
177,929.92
170.08
0.10 %
Fund: 424 - Storm Drainage Debt Service Surplus (Deficit):
0.00
0.00
0.00
0.00
0.00
0.00 %
Fund: 431 - Sewer Operating
Revenue
00 - Revenues
5,418,800.00
5,418,799.68
437,990.14
5,307,152.50
-111,647.18
2.06 %
Revenue Total:
5,418,800.00
5,418,799.68
437,990.14
5,307,152.50
-111,647.18
2.06 %
Expense
05 - Public Works
3,901,150.00
4,131,296.33
404,839.41
3,727,464.73
403,831.60
9.77 %
06 - Miscellaneous
374,150.00
424,150.00
31,212.69
367,182.20
56,967.80
13.43 %
Expense Total:
4,275,300.00
4,555,446.33
436,052.10
4,094,646.93
460,799.40
10.12 %
Fund: 431 - Sewer Operating Surplus (Deficit):
1,143,500.00
863,353.35
1,938.04
1,212,505.57
349,152.22
-40.44 %
Fund: 432 - Sewer Stabilization
Revenue
00 - Revenues
374,150.00
374,150.33
31,244.53
343,688.81
-30,461.52
8.14 %
Revenue Total:
374,150.00
374,150.33
31,244.53
343,688.81
-30,461.52
8.14 %
Fund: 432 - Sewer Stabilization Total:
374,150.00
374,150.33
31,244.53
343,688.81
-30,461.52
8.14 %
Fund: 434 - Sewer Debt Service
Revenue
00 - Revenues
275,000.00
275,000.00
0.00
0.00
-275,000.00
100.00 %
Revenue Total:
275,000.00
275,000.00
0.00
0.00
-275,000.00
100.00 %
Fund: 434 - Sewer Debt Service Total:
275,000.00
275,000.00
0.00
0.00
-275,000.00
100.00 %
Fund: 500 - Equipment Rental and Revolving
Revenue
00 - Revenues
671,500.00
671,500.00
33,852.60
632,390.45
-39,109.55
5.82 %
Revenue Total:
671,500.00
671,500.00
33,852.60
632,390.45
-39,109.55
5.82 %
Expense
10 - ER&R
977,000.00
977,000.00
75,098.82
493,893.03
483,106.97
49.45 %
12/13/2021 4:25:05 PM
Page 3 of 5
Budget Report For Fiscal: 2021 Period Ending: 11/30/2021
Variance
Original Current Period Fiscal Favorable Percent
Departmen... Total Budget Total Budget Activity Activity (Unfavorable) Remaining
Expense Total: 977,000.00 977,000.00
Fund: 500 - Equipment Rental and Revolving Surplus (Deficit):-305,500.00-305,500.00
Report Surplus (Deficit):-1,179,050.00 2,344,273.75
75,098.82 493,893.03 483,106.97 49.45 %
-41,246.22 138,497.42 443,997.42 145.33 %
472,014.23 11,657,325.53 9,313,051.78-397.27 %
12/13/2021 4:25:05 PM
Page 4 of 5
CAPITAL
(,�V City of Port Orchard
ORCHARD
Budget Report
Group Summary
For Fiscal: 2021 Period Ending: 11/30/2021
Variance
Original
Current
Period
Fiscal
Favorable
Percent
Account Typ...
Total Budget
Total Budget
Activity
Activity
(Unfavorable)
Remaining
Fund: 302 - Capital Construction
Revenue
620,000.00
5,403,707.00
140,297.98
297,454.10
-5,106,252.90
94.50 %
Expense
405,000.00
5,180,000.00
131,923.34
316,021.48
4,863,978.52
93.90 %
Fund: 302 - Capital Construction Surplus (Deficit):
215,000.00
223,707.00
8,374.64
-18,567.38
-242,274.38
108.30 %
Fund: 304 - Street Capital Projects
Revenue
3,638,100.00
3,972,848.00
24,302.19
1,080,768.38
-2,892,079.62
72.80 %
Expense
2,956,100.00
2,483,400.00
23,104.86
1,092,523.66
1,390,876.34
56.01 %
Fund: 304 - Street Capital Projects Surplus (Deficit):
682,000.00
1,489,448.00
1,197.33
-11,755.28
-1,501,203.28
100.79 %
Fund: 413 - Water Capital
Revenue
5,995,100.00
4,000,654.00
54,576.96
5,201,276.60
1,200,622.60
30.01 %
Expense
3,012,200.00
3,012,200.00
14,538.90
364,221.94
2,647,978.06
87.91 %
Fund: 413 - Water Capital Surplus (Deficit):
2,982,900.00
988,454.00
40,038.06
4,837,054.66
3,848,600.66
-389.36 %
Fund: 423 - Storm Drainage Capital Facil
Revenue
30,100.00
99,113.00
6.65
94.25
-99,018.75
99.90 %
Expense
0.00
0.00
0.00
5,200.00
-5,200.00
0.00 %
Fund: 423 - Storm Drainage Capital Facil Surplus (Deficit):
30,100.00
99,113.00
6.65
-5,105.75
-104,218.75
105.15 %
Fund: 433 - Sewer Capital
Revenue
3,311,300.00
4,065,350.00
72,453.73
2,113,622.16
-1,951,727.84
48.01 %
Expense
1,999,300.00
1,999,300.00
92,784.62
495,320.11
1,503,979.89
75.23 %
Fund: 433 - Sewer Capital Surplus (Deficit):
1,312,000.00
2,066,050.00
-20,330.89
1,618,302.05
-447,747.95
21.67 %
Report Surplus (Deficit): 5,222,000.00 4,866,772.00 29,285.79 6,419,928.30 1,553,156.30 -31.91 %
12/13/2021 4:27:16 PM Page 1 of 2
Detail Report CASH & INVESTMENTS Date Range: 11/01/2021 - 11/30/2021
Fund Summary
Fund
Beginning Balance
Total Activity
Ending Balance
001 - Current Expense
11,646,011.52
253,016.99
11,899,028.51
002 - City Street Fund
1,951,079.53
-29,032.99
1,922,046.54
003 - Stabilization Fund
2,335,766.39
167.67
2,335,934.06
103 - Criminal Justice
522,278.98
18,808.13
541,087.11
104 - Special Investigative Unit
96,939.78
20.25
96,960.03
107 - Community Events
290,011.01
-11,764.51
278,246.50
108 - Paths & Trails
12,081.27
103.32
12,184.59
109 - Real Estate Excise Tax
5,354,173.86
-33,135.84
5,321,038.02
111 - Impact Mitigation Fee
3,118,752.92
158,414.87
3,277,167.79
206 - Bond Redemption Fund
0.00
0.00
0.00
302 - Capital Construction
211,765.25
8,374.64
220,139.89
304 - Street Capital Projects
1,719,562.48
1,197.33
1,720,759.81
401- Water -Sewer Utilities
0.00
0.00
0.00
403 - Water -Sewer Cumulative Reserve
0.00
0.00
0.00
411 - Water Operating
3,555,099.28
119,876.17
3,674,975.45
412 -Water Stabilization
611,967.09
22,001.35
633,968.44
413 - Water Capital
6,179,370.57
41,386.56
6,220,757.13
414 - Water Debt Service
0.00
0.00
0.00
421 - Storm Drainage Utility
2,109,279.60
15,745.22
2,125,024.82
422 - Storm Drainage Stabilization
315,989.80
13,692.39
329,682.19
423 - Storm Drainage Capital Facil
94,000.55
6.65
94,007.20
424 - Storm Drainage Debt Service
0.00
0.00
0.00
431 - Sewer Operating
4,084,168.85
57,307.46
4,141,476.31
432 - Sewer Stabilization
925,034.95
31,244.53
956,279.48
433 - Sewer Capital
4,007,682.77
-20,330.89
3,987,351.88
434 - Sewer Debt Service
0.00
0.00
0.00
500 - Equipment Rental and Revolving
3,672,973.56
-40,886.37
3,632,087.19
631 - Trust and Agency
9,453.80
-83.12
9,370.68
632 - Wastewater Treatment Facil Fee
4,179,624.31
30,872.68
4,210,496.99
Grand Total:
57,003,068.12
637,002.49
57,640,070.61
12/14/2021 12:40:35 PM
Page 5 of 5