2024.10 Monthly Budget ReportDQf!�C�WARD
MONTHLY BUDGET FINANCIAL STATUS UPDATE
To: Mayor and Council members
From: Noah Crocker, Finance Director
Period: October 2024
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.
• The percentage 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 October 31, 2024, 116% of budgeted revenues were received. You'll note the driving factor in our positive
revenue is Licenses & Permits (one-time) revenues. For Property taxes and Sales tax we are on track.
The table provides budget versus actual (YTD) data by source of revenue.
024
2024 Current
Revenue Source
Original
Budget
2024 YTD
Budget
Property Tax
Budget
2,245,000
2,407,886
2,253,831
Received
93.60%
Sales Tax
6,895,000
6,895,000
6,730,067
97.61%
Other Taxes
2,156,000
2,156,000
2,410,967
111.83%
Total Taxes
11,296,000
11,458,886
11,394,866
99.44%
Licenses & Permits
601,200
601,200
1,424,671
236.97%
Intergovernmental Revenue
291,700
488,200
502,906
103.01%
Charges for Goods & Services
448,600
398,600
721,150
180.92%
Fines & Penalties
128,000
128,000
91,425
71.43%
Misc Revenues
121,500
46,500
978,836
2105.02%
Non -Revenues
-
-
225,455
#DIV/0!
Other Financing
F#DIV/0!
(Capital Contributions)
-
-
8,871
REVENUE TOTALS 12,887,000 13,121,386 15,348,181 116.97%
SALES TAX REVENUES SUMMARY
941,844
685,878
182,626
1,810,348
199,885
21,195
81,546
10,763
85,071
217,741
• Total 2024 Budget: $6,895,000
• Total 2024 YTD Actuals: $6,730,067
• Year -to -Date Actual revenue collected is 5.01% higher when compared to Prior Year -to Date Actuals
• Year -to -Date Actual revenue collected is 18.23% higher when compared to Year -to Date Budgeted
The following tables provide additional sales tax information:
Table 1: shows revenue received by month over a three-year period.
Monthly Sales Tax -Three Year Comparison
800,000
700,000
• 2022 Gct W
600,0WM •2@3G tu!
• 2B24 MA1.1
500,000
400,000
300,000
200,000
100,000
0
c
�acJata e��Ja` �a`Lc PQi �a ,Jo ,o Joy e�,oe O`�o� ,e��e oe�,oe
Table 2: provides current
data for sales tax revenue
collected Year-to-date.
$800,000 Sales Tax Revenues
$700,000
$600,000
$500,000 —
$400,000 a t is:caa Bud6i k:<
$300,000
$200,000
$100,000
Ik P yeQ� �o Oe
ENTERPRISE/UTILITY FUNDS OPERATIONS:
Water operation - Water operations budgeted revenue in the amount of $3,949,000 for 2024. Through October,
the city has received $3,798,074 or —96% of the 2024 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 $3,455,567 through October representing —68% of the 2024 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 2024 budget includes $2,146,695 for transfers. A total of $5,076 was
transferred out to fund 413 for Well 11 and a total of $238,349 was transferred out to fund 414 for debt service
related Well 11 Pre -Construction, Well 11 Construction and Well 10&13.
Water Service Payments
600,000
500,000
400,000 ■ 2022
300,000 ■ 2023
■ 2024
200,000
100,000
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Storm Drainage operations- Storm Operations budgeted revenue in the amount of $1,875,000 for 2024. Through
October, the city has received $1,920,945 or —102% of its annual budgeted revenue. Storm Drainage Operations
expended $1,217,061 through October, representing —61% of the 2024 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 2024 budget includes $147,242 for transfers. A total of $607 was transferred to fund 433
for TIP 1.16 expenses.
Storm Drainage Payments
Jan Feb Mar Apr May Jun Jul
Aug Sep Oct
Nov Dec
■ 2022
■ 2023
■ 2024
Sewer operation — Sewer operations budgeted revenue in the amount of $5,701,000 is budgeted for 2024.
Through October, the city has received $5,869,578 or —102% of the 2024 budgeted revenues. Sewer Operations
expended $4,304,744 through October representing —76% of the 2024 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 2024 budget includes $1,154,720 for transfers. A total of $5,504 was transferred out to fund 433
for Marina Pump Station and TIP 1.16.
600,000.00
500,000.00
400,000.00
300,000.00
200,000.00
100,000.00
Sewer Service Payments
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Real Estate Excise Tax (REET) Fund 109 and Impact Mitigation Fee Fund 111
■ 2022
■ 2023
■ 2024
The City's Real Estate Excise Tax receipts fluctuate monthly. October 2024 receipts are Lower than October 2023
by 18%. Total Real estate Excise Tax revenues have a YTD growth rate of-13.13%. The table below shows
balances through October 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 2024 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 October 2024 are as follows:
o Parks $303,368
o Transportation $511,690
o School District Impact $76,021
REET revenues received in October:
o REET 1 $62,810
o REET 2 $62,810
CAPITAL CONSTRUCTION BUDGET PROGRESS
Capital Construction Fund 302: The following General capital projects are in progress:
1) City Hall Remodel
a. City Staff Time, Construction
i. The 3rd floor work is nearing completion. Siding is nearing completing and work has
begun for the Solar Canopy.
2) 730 Prospect Property Acquisition
a. City Staff Time, Purchase
i. Completed
b. Painting
i. Completed
c. HVAC Improvements
i. Pending
3) Public Works Shop EV Fleet Upgrades
a. City Staff Time
i. Completed
4) South Kitsap Community Events Center including Plaza
a. City Staff Time, Design Consulting Services
5) Givens Park Sport Court Remodel
a. City Staff Time, Design Consulting Services
Street Capital Construction Fund 304: The following Street capital projects are in progress:
1) TIP 1.1 Bay St Pedestrian Path ROW
a. City Staff Time, Right of Way Consulting Services
2) TIP 1.14 Sidney non -motorized
a. City Staff Time, Design Consulting Services
3) TIP 1.15 Pottery Ave Non -Motorized
a. City Staff Time, Construction Mgmt. Services, Construction
4) TIP 1.16 SR166/Bay Street Re -Construction
a. City Staff Time, Design Consulting Services
5) TIP 1.18 Tremont Phase 2 &3
a. City Staff Time
6) TIP 1.2 Bay St Pedestrian Path Construction
a. City Staff Time, Design Consulting Services
7) TIP 1.3 Bay St West Pathway Study
a. City Staff Time, Design Consulting Services
8) TIP 1.7 Bethel Phase 5a-Mitchel Roundabout
a. City Staff Time, Construction Mgmt. Services, Construction
9) TIP 1.8 & 1.9 Blueberry & Salmonberry
a. City Staff Time, Design Consulting Services
Water Capital Construction Fund 413: The following Water capital projects are in progress:
1) Water CIP #3-Well 11 Treatment and Pumping Site Improvements
a. City Staff Time, Design Services, Construction
2) Water CIP #10-Melcher Pump Station Rehab
a. City Staff Time
3) Pottery Ave Non -Motorized (Water)
a. City Staff Time, Construction Mgmt. Services, Construction
Sewer Capital Construction Fund 433: The following Sewer capital projects are in progress:
1) Sewer CIP #1-Marina SW Pump Station
a. City Staff Time, Design Services, Construction
2) Sewer Lift Station Controls Upgrade
a. Nothing at this time
3) Bay Street Lift Station Controls
a. Nothing at this time
4) SWCIP # SIB South Sidney Lift Station (Ruby Creek)
a. City Staff Time, Design Services
5) Pottery Ave Non -Motorized (Sewer)
a. City Staff Time, Construction Mgmt. Services, Construction
Budget Report Operating Budget For Fiscal: 2024 Period Ending: 10/31/2024
Group Summary
Departmen...
Fund: 001 - Current Expense
Revenue
00 - Revenues
Original Current
Total Budget Total Budget
Variance
Period Fiscal Favorable Percent
Activity Activity (Unfavorable) Remaining
12,887,000.00 13,121,386.00 2,426,549.55 15,348,180.67 2,226,794.67 16.97%
Revenue Total: 12,887,000.00 13,121,386.00 2,426,549.55 15,348,180.67 2,226,794.67 16.97%
Expense
01- Finance
1,107,300.00
1,424,300.00
73,592.05
807,890.26
616,409.74
43.28%
02 - Court
797,000.00
797,000.00
38,644.02
423,435.32
373,564.68
46.87%
03 - Law Enforcement
6,017,120.00
6,793,080.00
464,267.49
4,919,805.41
1,873,274.59
27.58%
04 - Community Development
2,395,850.00
2,966,370.00
241,914.52
2,385,154.75
581,215.25
19.59%
05 - Public Works
2,216,887.00
2,639,257.00
138,715.40
1,962,659.28
676,597.72
25.64%
06 - Miscellaneous
0.00
2,411,000.00
47,976.47
1,921,889.84
489,110.16
20.29%
07-Administration
1,888,531.00
1,961,531.00
156,627.25
1,333,837.16
627,693.84
32.00%
Expense Total: 14,422,688.00
18,992,538.00
1,161,737.20
13,754,672.02
5,237,865.98
27.58%
Fund: 001- Current Expense Surplus (Deficit):-1,535,688.00-5,871,152.00 1,264,812.35 1,593,508.65 7,464,660.65 127.14%
Fund: 002 - City Street Fund
Revenue
00 - Revenues
1,731,004.00 2,130,547.00 655,058.18 2,661,795.48 531,248.48 24.93%
Revenue Total: 1,731,004.00 2,130,547.00 655,058.18 2,661,795.48 531,248.48 24.93%
Expense
05 - Public Works
2,665,396.00
3,646,666.00
138,338.31
2,217,080.62
1,429,585.38
39.20%
06 - Miscellaneous
0.00
607,000.00
0.00
0.00
607,000.00
100.00%
Expense Total:
2,665,396.00
4,253,666.00
138,338.31
2,217,080.62
2,036,585.38
47.88%
Fund: 002 - City Street Fund Surplus (Deficit):
-934,392.00
-2,123,119.00
516,719.87
444,714.86
2,567,833.86
120.95%
Fund: 003 - Stabilization Fund
Revenue
00 - Revenues
0.00
0.00
13,293.02
138,758.46
138,758.46
0.00%
Revenue Total:
0.00
0.00
13,293.02
138,758.46
138,758.46
0.00%
Fund: 103 - Criminal Justice
Revenue
00 - Revenues
Fund: 003 - Stabilization Fund Total: 0.00 0.00 13,293.02 138,758.46 138,758.46 0.00%
384,000.00 384,000.00 44,860.50 418,816.56 34,816.56 9.07%
Revenue Total: 384,000.00 384,000.00 44,860.50 418,816.56 34,816.56 9.07%
Expense
03 - Law Enforcement
495,100.00
771,100.00
9,170.32
619,598.54
151,501.46
19.65%
Expense Total:
495,100.00
771,100.00
9,170.32
619,598.54
151,501.46
19.65%
Fund: 103 - Criminal Justice Surplus (Deficit):
-111,100.00
-387,100.00
35,690.18
-200,781.98
186,318.02
48.13%
Fund: 104 - Special Investigative Unit
Revenue
00 - Revenues
4,000.00
4,000.00
360.05
3,786.75
-213.25
5.33%
Revenue Total:
4,000.00
4,000.00
360.05
3,786.75
-213.25
5.33%
Expense
03 - Law Enforcement
4,000.00
4,000.00
300.00
300.00
3,700.00
92.50%
Expense Total:
4,000.00
4,000.00
300.00
300.00
3,700.00
92.50%
Fund: 104 - Special Investigative Unit Surplus (Deficit):
0.00
0.00
60.05
3,486.75
3,486.75
0.00%
Fund: 107 - Community Events
Revenue
00 - Revenues
102,200.00
102,200.00
22,676.73
167,648.64
65,448.64
64.04%
Revenue Total:
102,200.00
302,200.00
22,676.73
167,648.64
65,448.64
64.04%
Expense
07 - Administration
102,200.00 127,200.00 10,259.65 34,374.90
92,825.10 72.98%
11/20/2024 9:18:33 AM
Page 14 of 18
Budget Report
For Fiscal: 2024 Period Ending: 10/31/2024
Variance
Original
Current
Period
Fiscal
Favorable
Percent
Departmen...
Total Budget
Total Budget
Activity
Activity
(Unfavorable)
Remaining
Expense Total:
102,200.00
127,200.00
10,259.65
34,374.90
92,825.10
72.98%
Fund: 107 - Community Events Surplus (Deficit):
0.00
-25,000.00
12,417.08
133,273.74
158,273.74
633.09%
Fund: 108 - Paths & Trails
Revenue
00 - Revenues
1,000.00
1,000.00
183.01
1,811.98
811.98
81.20%
Revenue Total:
1,000.00
1,000.00
183.01
1,811.98
811.98
81.20%
Fund: 108 - Paths & Trails Total:
1,000.00
1,000.00
183.01
1,811.98
811.98
81.20%
Fund: 109 - Real Estate Excise Tax
Revenue
00 - Revenues
800,000.00
1,600,000.00
146,846.85
1,757,714.61
157,714.61
9.86%
Revenue Total:
800,000.00
1,600,000.00
146,846.85
1,757,714.61
157,714.61
9.86%
Expense
06 - Miscellaneous
298,000.00
1,397,000.00
826.20
1,128,454.52
268,545.48
19.22%
Expense Total:
298,000.00
1,397,000.00
826.20
1,128,454.52
268,545.48
19.22%
Fund: 109 - Real Estate Excise Tax Surplus (Deficit):
502,000.00
203,000.00
146,020.65
629,260.09
426,260.09
-209.98%
Fund: 111- Impact Mitigation Fee
Revenue
00 - Revenues
5,207,900.00
5,207,900.00
934,838.62
4,473,765.98
-734,134.02
14.10%
Revenue Total:
5,207,900.00
5,207,900.00
934,838.62
4,473,765.98
-734,134.02
14.10%
Expense
06 - Miscellaneous
1,103,300.00
2,934,250.00
67,428.73
798,034.08
2,136,215.92
72.80%
Expense Total:
1,103,300.00
2,934,250.00
67,428.73
798,034.08
2,136,215.92
72.80%
Fund: 111- Impact Mitigation Fee Surplus (Deficit):
4,104,600.00
2,273,650.00
867,409.89
3,675,731.90
1,402,081.90
-61.67%
Fund: 206 - Bond Redemption Fund
Revenue
00 - Revenues
298,000.00
1,397,000.00
2,142.07
947,420.80
-449,579.20
32.18%
Revenue Total:
298,000.00
1,397,000.00
2,142.07
947,420.80
-449,579.20
32.18%
Expense
06 - Miscellaneous
298,000.00
995,410.00
0.00
534,073.65
461,336.35
46.35%
Expense Total:
298,000.00
995,410.00
0.00
534,073.65
461,336.35
46.35%
Fund: 206 - Bond Redemption Fund Surplus (Deficit):
0.00
401,590.00
2,142.07
413,347.15
11,757.15
-2.93%
Fund: 411- Water Operating
Revenue
00 - Revenues
3,949,000.00
3,949,000.00
613,082.03
3,798,073.64
-150,926.36
3.82%
Revenue Total:
3,949,000.00
3,949,000.00
613,082.03
3,798,073.64
-150,926.36
3.82%
Expense
05 - Public Works
3,138,532.00
5,036,312.00
550,059.14
3,455,567.70
1,580,744.30
31.39%
06 - Miscellaneous
555,800.00
2,146,695.00
243,425.44
1,227,893.63
918,801.37
42.80%
Expense Total:
3,694,332.00
7,183,007.00
793,484.58
4,683,461.33
2,499,545.67
34.80%
Fund: 411- Water Operating Surplus (Deficit):
254,668.00
-3,234,007.00
-180,402.55
-885,387.69
2,348,619.31
72.62%
Fund: 412 - Water Stabilization
Revenue
00 - Revenues
0.00
100,000.00
4,436.60
46,312.06
-53,687.94
53.69%
Revenue Total:
0.00
100,000.00
4,436.60
46,312.06
-53,687.94
53.69%
Fund: 412 - Water Stabilization Total:
0.00
100,000.00
4,436.60
46,312.06
-53,687.94
53.69%
Fund: 414 - Water Debt Service
Revenue
00 - Revenues
939,200.00
2,400,670.00
666,208.16
1,904,108.99
-496,561.01
20.68%
Revenue Total:
939,200.00
2,400,670.00
666,208.16
1,904,108.99
-496,561.01
20.68%
Expense
06 - Miscellaneous
939,200.00
1,144,970.00
631,443.79
733,260.18
411,709.82
35.96%
11/20/2024 9:18:33 AM
Page 15 of 18
Budget Report
Original Current
Departmen... Total Budget Total Budget
Expense Total: 939,200.00 1,144,970.00
Fund: 414 - Water Debt Service Surplus (Deficit): 0.00 1,255,700.00
Fund: 421- Storm Drainage Utility
Revenue
For Fiscal: 2024 Period Ending: 10/31/2024
Variance
Period Fiscal Favorable Percent
Activity Activity (Unfavorable) Remaining
631,443.79 733,260.18 411,709.82 35.96%
34,764.37 1,170,848.81-84,851.19 6.76%
00 - Revenues
1,745,000.00
1,875,000.00
216,497.69
1,920,945.72
45,945.72
2.45%
Revenue Total:
1,745,000.00
1,875,000.00
216,497.69
1,920,945.72
45,945.72
2.45%
Expense
05 - Public Works
1,819,352.00
1,980,002.00
107,163.16
1,217,061.47
762,940.53
38.53%
06 - Miscellaneous
277,100.00
320,150.00
607.24
192,925.44
127,224.56
39.74%
Expense Total:
2,096,452.00
2,300,152.00
107,770.40
1,409,986.91
890,165.09
38.70%
Fund: 421- Storm Drainage
Utility Surplus (Deficit):
-351,452.00
-425,152.00
108,727.29
510,958.81
936,110.81
220.18%
Fund: 422 - Storm Drainage Stabilization
Revenue
00 - Revenues
0.00
0.00
2,492.66
26,019.99
26,019.99
0.00%
Revenue Total:
0.00
0.00
2,492.66
26,019.99
26,019.99
0.00%
Fund: 422 - Storm Drainage Stabilization Total:
0.00
0.00
2,492.66
26,019.99
26,019.99
0.00%
Fund: 424 - Storm Drainage Debt Service
Revenue
00 - Revenues
177,100.00
220,150.00
0.00
191,467.73
-28,682.27
13.03%
Revenue Total:
177,100.00
220,150.00
0.00
191,467.73
-28,682.27
13.03%
Expense
06 - Miscellaneous
177,100.00
220,150.00
0.00
191,467.73
28,682.27
13.03%
Expense Total:
177,100.00
220,150.00
0.00
191,467.73
28,682.27
13.03%
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,701,000.00
5,701,000.00
650,918.63
5,869,578.69
168,578.69
2.96%
Revenue Total:
5,701,000.00
5,701,000.00
650,918.63
5,869,578.69
168,578.69
2.96%
Expense
05 - Public Works
4,889,732.00
5,597,612.00
38,459.69
4,304,744.12
1,292,867.88
23.10%
06 - Miscellaneous
709,900.00
1,154,720.00
5,504.84
644,623.68
510,096.32
44.17%
Expense Total:
5,599,632.00
6,752,332.00
43,964.53
4,949,367.80
1,802,964.20
26.70%
Fund: 431- Sewer Operating Surplus (Deficit):
101,368.00
-1,051,332.00
606,954.10
920,210.89
1,971,542.89
187.53%
Fund: 432 - Sewer Stabilization
Revenue
00 - Revenues
0.00
100,000.00
6,639.56
69,308.04
-30,691.96
30.69%
Revenue Total:
0.00
100,000.00
6,639.56
69,308.04
-30,691.96
30.69%
Fund: 432 - Sewer Stabilization Total:
0.00
100,000.00
6,639.56
69,308.04
-30,691.96
30.69%
Fund: 434 - Sewer Debt Service
Revenue
00 - Revenues
678,900.00
1,067,720.00
6,321.53
695,583.90
-372,136.10
34.85%
Revenue Total:
678,900.00
1,067,720.00
6,321.53
695,583.90
-372,136.10
34.85%
Expense
06 - Miscellaneous
403,900.00
465,970.00
0.00
43,733.59
422,236.41
90.61%
Expense Total:
403,900.00
465,970.00
0.00
43,733.59
422,236.41
90.61%
Fund: 434 - Sewer Debt Service Surplus (Deficit):
275,000.00
601,750.00
6,321.53
651,850.31
50,100.31
-8.33%
Fund: 500 - Equipment Rental and Revolving
Revenue
00 - Revenues
1,309,800.00
4,142,200.00
77,850.02
3,962,818.51
-179,381.49
4.33%
Revenue Total:
1,309,800.00
4,142,200.00
77,850.02
3,962,818.51
-179,381.49
4.33%
Expense
10 - ER&R
801,600.00
3,807,400.00
205,159.28
2,088,356.28
1,719,043.72
45.15%
11/20/2024 9:18:33 AM Page 16 of 18
Budget Report
For Fiscal: 2024 Period Ending: 10/31/2024
Variance
Original
Current
Period
Fiscal
Favorable Percent
Departmen... Total Budget
Total Budget
Activity
Activity
(Unfavorable) Remaining
Expense Total: 801,600.00
3,807,400.00
205,159.28
2,088,356.28
1,719,043.72 45.15%
Fund: 500 - Equipment Rental and Revolving Surplus (Deficit): 508,200.00
334,800.00
-127,309.26
1,874,462.23
1,539,662.23-459.88%
Report Surplus (Deficit): 2,814,204.00
-7,845,372.00
3,321,372.47
11,217,695.05
19,063,067.05 242.98%
11/20/2024 9:18:33 AM Page 17 of 18
Budget Report Capital Budget For Fiscal: 2024 Period Ending: 10/31/2024
Group Summary
Account Typ...
Fund: 302 - Capital Construction
Revenue
Expense
Fund: 302 - Capital Construction Surplus (Deficit)
Fund: 304 - Street Capital Projects
Original Current
Total Budget Total Budget
Variance
Period Fiscal Favorable Percent
Activity Activity (Unfavorable) Remaining
370,000.00 2,780,000.00 65,773.79 2,335,151.69-444,848.31 16.00%
370,000.00 11,925,700.00 485,776.24 7,331,310.07 4,594,389.93 38.53%
0.00-9,145,700.00-420,002.45-4,996,158.38 4,149,541.62 45.37%
Revenue
220,000.00
4,143,950.00
91,051.26
1,085,342.84
-3,058,607.16
73.81%
Expense
290,000.00
14,149,095.00
155,259.48
1,388,317.39
12,760,777.61
90.19%
Fund: 304 - Street Capital Projects Surplus (Deficit):
-70,000.00
-10,005,145.00
-64,208.22
-302,974.55
9,702,170.45
96.97%
Fund: 413 - Water Capital
Revenue
2,232,700.00
2,763,950.00
116,357.56
5,484,845.81
2,720,895.81
98.44%
Expense
883,400.00
10,635,295.00
1,136,281.40
4,477,600.76
6,157,694.24
57.90%
Fund: 413 - Water Capital Surplus (Deficit):
1,349,300.00
-7,871,345.00
-1,019,923.84
1,007,245.05
8,878,590.05
112.80%
Fund: 423 - Storm Drainage Capital Facil
Revenue
100,000.00
150,000.00
160,031.87
508,612.71
358,612.71
239.08%
Expense
100,000.00
150,000.00
5,299.24
30,693.71
119,306.29
79.54%
Fund: 423 - Storm Drainage Capital Facil Surplus (Deficit):
0.00
0.00
154,732.63
477,919.00
477,919.00
0.00%
Fund: 433 - Sewer Capital
Revenue
3,491,500.00
5,241,500.00
297,070.85
7,658,555.92
2,417,055.92
46.11%
Expense
369,000.00
15,374,600.00
1,750,441.62
8,726,156.11
6,648,443.89
43.24%
Fund: 433 - Sewer Capital Surplus (Deficit):
3,122,500.00
-10,133,100.00
-1,453,370.77
-1,067,600.19
9,065,499.81
89.46%
Report Surplus (Deficit): 4,401,800.00-37,155,290.00-2,802,772.65-4,881,569.07 32,273,720.93 86.86%
11/20/2024 10:52:23 AM Page 3 of 4
Detail Report Cash & Investments Date Range: 10/01/2024 - 10/31/2024
Fund Summary
Fund
Beginning Balance
Total Activity
Ending Balance
001- Current Expense
17,668,282.17
1,264,812.37
18,933,094.54
002 - City Street Fund
3,956,834.15
516,719.87
4,473,554.02
003 - Stabilization Fund
3,197,215.28
13,293.02
3,210,508.30
103 - Criminal Justice
515,858.41
35,690.18
551,548.59
104 - Special Investigative Unit
104,332.24
60.05
104,392.29
107 - Community Events
514,735.99
12,417.08
527,153.07
108 - Paths & Trails
17,439.90
183.01
17,622.91
109 - Real Estate Excise Tax
6,550,329.54
146,020.65
6,696,350.19
111- Impact Mitigation Fee
10,933,009.22
867,409.89
11,800,419.11
206 - Bond Redemption Fund
511,219.93
2,142.07
513,362.00
302 - Capital Construction
3,318,923.45
-420,002.45
2,898,921.00
304 - Street Capital Projects
1,914,152.91
-64,208.22
1,849,944.69
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,740,012.73
-180,402.63
3,559,610.10
412 - Water Stabilization
1,058,824.17
4,436.60
1,063,260.77
413 - Water Capital
10,285,396.16
-1,019,923.84
9,265,472.32
414 - Water Debt Service
1,136,084.44
34,764.37
1,170,848.81
421- Storm Drainage Utility
2,186,382.59
108,727.30
2,295,109.89
422 - Storm Drainage Stabilization
594,890.61
2,492.66
597,383.27
423 - Storm Drainage Capital Facil
525,052.39
154,732.63
679,785.02
424 - Storm Drainage Debt Service
0.00
0.00
0.00
431- Sewer Operating
8,089,722.53
606,954.09
8,696,676.62
432 - Sewer Stabilization
1,584,577.47
6,639.56
1,591,217.03
433 - Sewer Capital
7,822,167.02
-1,453,370.77
6,368,796.25
434 - Sewer Debt Service
1,508,677.06
6,321.53
1,514,998.59
500 - Equipment Rental and Revolving
5,785,959.06
-127,309.20
5,658,649.86
631- Trust and Agency
13,769.03
-7,885.38
5,883.65
632 - Wastewater Treatment Facil Fee
7,532,576.53
135,567.31
7,668,143.84
Grand Total:
101,066,424.98
646,281.75
101,712,706.73
11/20/2024 10:39:44 AM
Page 5 of 5