The Docket · Government Meeting · DKT-2026-000203

On the agenda: Brunswick Md Finance Commission Meeting - Feb 15, 2024 — License Plate Reader (Feb 15)

Past ⚠ Agenda Watch Brunswick, Maryland · Thursday, February 15, 2024 — 3 years ago

About this record

The published agenda for this February 15 meeting contains: "License Plate Reader". The meeting has passed; the record and its outcome live here permanently.

WhenThursday, February 15, 2024
Check the agenda document for the meeting time.

WhereBrunswick, Maryland

BodyFinance Commission Meeting - Feb 15, 2024

Money$3,146 was at stake

On the record“License Plate Reader”

The agenda, word for word

Government public record — the full text of the published document, archived August 2, 2026. Gold highlighting of key terms is ours, not the original’s. Read the original document ↗

60 pages · scroll to read

Page 1 of 60

FINANCE & UTILITY COMMISSION MEETING
Via Zoom ONLY
Thursday, February 15, 2024
5:00 PM

Agenda
1. Water & Sewer Capacity and Tap Fee Study Presentation
2. Water & Sewer Rate Study
3. Economic Development Funding Relief Agreement & Capacity Fee
Payment Plan – 30 West Potomac Street
4. Yourtee Springs Storage Tank Engineering
5. Reservoir Engineering
6. Finance Reports

Join Zoom Meeting
https://us02web.zoom.us/j/88216646836?pwd=S3J3TDdaaUlFUnd1YlBkSzd
Vck03Zz09
Meeting ID: 882 1664 6836
Passcode: 878267
Dial by your location
• +1 309 205 3325 US

Page 2 of 60

City of Brunswick

2024 Water & Sewer Capacity and Tap Fee Adjustments
Construction Cost Index Adjustments Only
January 22, 2024

Prepared by:

Page 3 of 60

City of Brunswick
Summary of 2024 Water & Sewer Capacity and Tap Fee Adjustments
(A)

(B)

(C)

(D)

_Option 1_
Apply the CCI Only Since
the Development of
Impact Fees (2009)
+56.4% Incr.
Total Fee

(E)

(F)

_Option 2_
Apply the CCI Only Since
Start of Significant
Customer Growth (2006)
+91.4% Incr.
Total Fee

(G)

(H)

_Option 3_
Apply the CCI Since the
Current Water & Sewer Fees
Were Implemented (2002)
+138.4% Incr.
Total Fee

City Department

Current Fees

Water Capacity Fee

$3,146

+$1,773

$4,919

+$2,877

$6,023

+$4,355

$7,501

Water Tap Fee

$2,625

+$1,479

$4,104

+$2,401

$5,026

+$3,634

$6,259

Total Water Fees

$5,771

+$3,252

$9,023

+$5,277

$11,048

+$7,989

$13,760

Sewer Capacity Fee

$3,956

+$2,229

$6,185

+$3,618

$7,574

+$5,476

$9,432

Sewer Tap Fee

$2,346

+$1,322

$3,668

+$2,145

$4,491

+$3,248

$5,594

Total Sewer Fees

$6,302

+$3,552

$9,854

+$5,763

$12,065

+$8,724

$15,026

Total Capacity Fee

$7,102

+$4,002

$11,104

+$6,495

$13,597

+$9,831

$16,933

Total Tap Fee

$4,971

+$2,801

$7,772

+$4,546

$9,517

+$6,881

$11,852

$12,073

+$6,804

$18,877

+$11,041

$23,114

+$16,713

$28,786

11 Total Water & Sewer Fees
12

Percentage Increase

Brunswick W&S Rate Analysis
1/22/2024

+56.4%

+91.4%

+138.4%

Page 1

Page 4 of 60

City of Brunswick

Capacity Fees Only

MD Utilities Current 2024 Water & Sewer Capacity Fees Only
(A)

(B)

(C)

(D)

(E)

Utility

Water Capacity Fee

Sewer Capacity Fee

Combined Water & Sewer
Capacity Fees

Difference to
Brunswick (2002-2023)

Brunswick - Current

$3,146

$3,956

$7,102

Hagerstown

$2,900

$5,100

$8,000

12.6%

Thurmont

$3,410

$4,925

$8,335

17.4%

Thurmont Starting Oct. 2024

$3,935

$6,575

$10,510

48.0%

Westminster

$5,244

$5,496

$10,740

51.2%

$4,919

$6,185

$11,104

56.4%

6 Brunswick Option 1 - 2009 CCI Adj.
7

Williamsport

$4,095

$7,200

$11,295

59.0%

Washington County

$2,700

$8,600

$11,300

59.1%

Union Bridge

$4,282

$7,068

$11,350

59.8%

Smithsburg

$2,600

$8,916

$11,516

62.2%

Taneytown

$5,110

$7,790

$12,900

81.6%

City of Frederick

$6,907

$6,063

$12,970

82.6%

13 Brunswick Option 2 - 2006 CCI Adj.

$6,023

$7,574

$13,597

91.4%

14 Brunswick Option 3 - 2002 CCI Adj.

$7,501

$9,432

$16,933

138.4%

15
16

Frederick County "All-In Only"

$6,813

$8,916

$15,729

Emmitsburg "All-in Only"

$8,200

$8,000

$16,200

Carroll County "All-In Only"

$9,773

$8,419

$18,192

Brunswick W&S Rate Analysis
1/22/2024

Page 2

Page 5 of 60

City of Brunswick

Capacity & Tap
Fees Total

MD Utilities Current 2024 Water & Sewer Capacity and Tap Fees
(A)

(B)

(C)

(D)

(E)

Utility

Total Water Capacity
and Tap Fees

Total Sewer Capacity
and Tap Fees

Combined Water & Sewer
Capacity and Tap Fees

Difference to
Brunswick (2002-2023)

Hagerstown

$4,095

$6,450

$10,545

(12.7%)

Brunswick - Current

$5,771

$6,302

$12,073

Union Bridge

$5,282

$8,068

$13,350

10.6%

Westminster

$6,044

$7,496

$13,540

12.2%

Washington County

$5,525

$8,600

$14,125

17.0%

City of Frederick

$7,746

$6,563

$14,309

18.5%

Taneytown

$5,860

$8,540

$14,400

19.3%

Thurmont

$6,733

$8,708

$15,440

27.9%

Frederick County

$6,813

$8,916

$15,729

30.3%

Emmitsburg

$8,200

$8,000

$16,200

34.2%

Smithsburg

$5,100

$12,341

$17,441

44.5%

Williamsport

$7,295

$10,600

$17,895

48.2%

Carroll County

$9,773

$8,419

$18,192

50.7%

Brunswick Option 1 - 2009 CCI Adj.

$9,023

$9,854

$18,877

56.4%

Thurmont Starting Oct. 2024

$8,080

$11,640

$19,720

63.3%

Brunswick Option 2 - 2006 CCI Adj.

$11,048

$12,065

$23,114

91.4%

Brunswick Option 3 - 2002 CCI Adj.

$13,760

$15,026

$28,786

138.4%

Brunswick W&S Rate Analysis
1/22/2024

Page 3

Page 6 of 60

City of Brunswick

Option 1: Apply the CCI Since the
Development of Impact Fees (2009)

Brunswick's Construction Cost Index Water & Sewer Fee Adjustments
(A)

(B)

(C)

(D)

(E)

(F)

(G)

(H)

Year

Water
Capacity
Fee

Water
Tap
Fee

Total
Water
Fees

Sewer
Capacity
Fee

Sewer
Tap
Fee

Total
Sewer
Fees

Combined
Water &
Sewer Fees

2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023

$3,146
$3,146
$3,146
$3,146
$3,146
$3,146
$3,146
$2,969
$3,059
$3,220
$3,265
$3,295
$3,359
$3,337
$3,320
$3,433
$3,572
$3,676
$3,667
$4,216
$4,886
$4,919

Brunswick W&S Rate Analysis
1/22/2024

$2,625
$2,625
$2,625
$2,625
$2,625
$2,625
$2,625
$2,477
$2,552
$2,687
$2,724
$2,749
$2,803
$2,784
$2,771
$2,864
$2,981
$3,067
$3,059
$3,518
$4,077
$4,104

$5,771
$5,771
$5,771
$5,771
$5,771
$5,771
$5,771
$5,447
$5,611
$5,907
$5,988
$6,044
$6,162
$6,121
$6,091
$6,297
$6,553
$6,743
$6,726
$7,734
$8,962
$9,023

$3,956
$3,956
$3,956
$3,956
$3,956
$3,956
$3,956
$3,734
$3,846
$4,049
$4,105
$4,143
$4,224
$4,196
$4,175
$4,317
$4,492
$4,622
$4,611
$5,301
$6,144
$6,185

$2,346
$2,346
$2,346
$2,346
$2,346
$2,346
$2,346
$2,214
$2,281
$2,401
$2,434
$2,457
$2,505
$2,488
$2,476
$2,560
$2,664
$2,741
$2,734
$3,144
$3,643
$3,668

$6,302
$6,302
$6,302
$6,302
$6,302
$6,302
$6,302
$5,948
$6,127
$6,450
$6,540
$6,600
$6,729
$6,684
$6,651
$6,876
$7,156
$7,363
$7,345
$8,445
$9,787
$9,854

$12,073
$12,073
$12,073
$12,073
$12,073
$12,073
$12,073
$11,395
$11,738
$12,357
$12,528
$12,644
$12,891
$12,805
$12,742
$13,173
$13,709
$14,106
$14,071
$16,179
$18,749
$18,877

(I)

(J)

Construction
Cost Index ("CCI") Increase
Annually

Cumulative

(5.6%)
3.0%
5.3%
1.4%
0.9%
2.0%
(0.7%)
(0.5%)
3.4%
4.1%
2.9%
(0.2%)
15.0%
15.9%
0.7%

(5.6%)
(2.8%)
2.4%
3.8%
4.7%
6.8%
6.1%
5.5%
9.1%
13.6%
16.8%
16.5%
34.0%
55.3%
56.4%

Page 4

Page 7 of 60

City of Brunswick

Option 2: Apply the CCI Since Start of
Significant Customer Growth (2006)

Brunswick's Construction Cost Index Water & Sewer Fee Adjustments
(A)

(B)

(C)

(D)

(E)

(F)

(G)

(H)

Year

Water
Capacity
Fee

Water
Tap
Fee

Total
Water
Fees

Sewer
Capacity
Fee

Sewer
Tap
Fee

Total
Sewer
Fees

Combined
Water &
Sewer Fees

2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023

$3,146
$3,146
$3,146
$3,146
$3,354
$3,543
$3,852
$3,636
$3,745
$3,943
$3,997
$4,034
$4,113
$4,086
$4,066
$4,203
$4,374
$4,501
$4,489
$5,162
$5,982
$6,023

Brunswick W&S Rate Analysis
1/22/2024

$2,625
$2,625
$2,625
$2,625
$2,799
$2,956
$3,214
$3,034
$3,125
$3,290
$3,335
$3,366
$3,432
$3,409
$3,392
$3,507
$3,650
$3,755
$3,746
$4,307
$4,992
$5,026

$5,771
$5,771
$5,771
$5,771
$6,153
$6,499
$7,066
$6,669
$6,870
$7,232
$7,333
$7,401
$7,545
$7,495
$7,458
$7,710
$8,024
$8,256
$8,235
$9,469
$10,974
$11,048

$3,956
$3,956
$3,956
$3,956
$4,218
$4,455
$4,844
$4,572
$4,710
$4,958
$5,026
$5,073
$5,172
$5,138
$5,112
$5,285
$5,500
$5,659
$5,645
$6,491
$7,523
$7,574

$2,346
$2,346
$2,346
$2,346
$2,501
$2,642
$2,873
$2,711
$2,793
$2,940
$2,981
$3,008
$3,067
$3,047
$3,032
$3,134
$3,262
$3,356
$3,348
$3,849
$4,461
$4,491

$6,302
$6,302
$6,302
$6,302
$6,719
$7,097
$7,716
$7,283
$7,502
$7,898
$8,007
$8,082
$8,239
$8,184
$8,144
$8,420
$8,762
$9,016
$8,993
$10,341
$11,984
$12,065

$12,073
$12,073
$12,073
$12,073
$12,872
$13,597
$14,783
$13,952
$14,373
$15,130
$15,340
$15,482
$15,784
$15,679
$15,602
$16,130
$16,786
$17,272
$17,229
$19,810
$22,958
$23,114

(I)

(J)

Construction
Cost Index ("CCI") Increase
Annually

Cumulative

6.6%
5.6%
8.7%
(5.6%)
3.0%
5.3%
1.4%
0.9%
2.0%
(0.7%)
(0.5%)
3.4%
4.1%
2.9%
(0.2%)
15.0%
15.9%
0.7%

6.6%
12.6%
22.4%
15.6%
19.0%
25.3%
27.1%
28.2%
30.7%
29.9%
29.2%
33.6%
39.0%
43.1%
42.7%
64.1%
90.2%
91.4%

Page 5

Page 8 of 60

City of Brunswick

Option 3: Apply the CCI Since Water &
Sewer Fees Were Implemented (2002)

Brunswick's Construction Cost Index Water & Sewer Fee Adjustments
(A)

(B)

(C)

(D)

(E)

(F)

(G)

(H)

Year

Water
Capacity
Fee

Water
Tap
Fee

Total
Water
Fees

Sewer
Capacity
Fee

Sewer
Tap
Fee

Total
Sewer
Fees

Combined
Water &
Sewer Fees

2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023

$3,146
$3,219
$3,648
$3,918
$4,177
$4,413
$4,797
$4,528
$4,664
$4,910
$4,978
$5,024
$5,122
$5,088
$5,063
$5,235
$5,448
$5,605
$5,591
$6,429
$7,450
$7,501

Brunswick W&S Rate Analysis
1/22/2024

$2,625
$2,686
$3,044
$3,269
$3,485
$3,682
$4,003
$3,778
$3,892
$4,097
$4,154
$4,192
$4,274
$4,246
$4,225
$4,368
$4,545
$4,677
$4,665
$5,364
$6,217
$6,259

$5,771
$5,904
$6,692
$7,187
$7,663
$8,094
$8,800
$8,306
$8,556
$9,007
$9,132
$9,217
$9,397
$9,334
$9,288
$9,602
$9,993
$10,282
$10,257
$11,793
$13,667
$13,760

$3,956
$4,047
$4,588
$4,927
$5,253
$5,549
$6,033
$5,694
$5,865
$6,174
$6,260
$6,318
$6,441
$6,398
$6,367
$6,582
$6,850
$7,048
$7,031
$8,084
$9,369
$9,432

$2,346
$2,400
$2,721
$2,922
$3,115
$3,290
$3,577
$3,376
$3,478
$3,662
$3,712
$3,747
$3,820
$3,794
$3,776
$3,904
$4,062
$4,180
$4,169
$4,794
$5,556
$5,594

$6,302
$6,448
$7,308
$7,849
$8,368
$8,839
$9,610
$9,070
$9,344
$9,836
$9,972
$10,065
$10,261
$10,193
$10,143
$10,486
$10,913
$11,228
$11,200
$12,878
$14,925
$15,026

$12,073
$12,352
$14,001
$15,036
$16,030
$16,933
$18,410
$17,376
$17,900
$18,843
$19,104
$19,282
$19,658
$19,527
$19,431
$20,088
$20,906
$21,510
$21,457
$24,671
$28,592
$28,786

(I)

(J)

Construction
Cost Index ("CCI") Increase
Annually

Cumulative

2.3%
13.3%
7.4%
6.6%
5.6%
8.7%
(5.6%)
3.0%
5.3%
1.4%
0.9%
2.0%
(0.7%)
(0.5%)
3.4%
4.1%
2.9%
(0.2%)
15.0%
15.9%
0.7%

2.3%
16.0%
24.5%
32.8%
40.3%
52.5%
43.9%
48.3%
56.1%
58.2%
59.7%
62.8%
61.7%
60.9%
66.4%
73.2%
78.2%
77.7%
104.4%
136.8%
138.4%

Page 6

Page 9 of 60

City of Brunswick
MD Municipality Current 2024 Parks, Police & Municipal Buildings Impact Fees
(A)

(B)

(C)

(D)

(E)

(F)

Municipality

Parks Impact
Fee

Municipality

Police
Impact Fee

Municipality

Municipal
Buildings
Impact Fee

Carroll County

$533

Brunswick - Current

$306

Brunswick - Current

$307

City of Frederick

$868

Anne Arundel County

$339

Brunswick Option 1 - 2009
CCI Adj.

$480

Taneytown

$1,000

Brunswick Option 1 - 2009
CCI Adj.

$479

Mount Airy

$2,200

Brunswick - Current

$1,021

Jefferson County, WV

$531

Thurmont

$1,420

Mount Airy

$1,700

Mount Airy

$1,500

Prince George's County

$2,749

Brunswick Option 1 - 2009
CCI Adj.

$1,597

Thurmont Starting Oct.
2024

$1,840

Emmitsburg

$3,898

Brunswick W&S Rate Analysis
1/22/2024

Page 7

Page 10 of 60

City of Brunswick
MD Municipality Current 2024 School Impact Fees

Brunswick W&S Rate Analysis
1/22/2024

(A)

(B)

Municipality

School Impact Fee

Anne Arundel County

$9,213

Prince George's County

$10,180

Howard County

$11,250

Frederick County

$17,071

City of Frederick

$20,421

Montgomery County

$25,004

+$3,350 City Specific

Page 1

Page 11 of 60

SMART UTILITY MANAGEMENT / LLC
Rates / Budgeting

_______________________________________________________________________________________________________________________________________

∑

Regulatory Consulting

__________________________________________________________________________________________________________________________________________________________

February 9, 2024
City of Brunswick
1 West Potomac St.
Brunswick, Md. 21716

Subject:

Engagement Letter for Smart Utility Management, LLC to Perform a Review of the
City of Brunswick’s Water & Sewer Retail Rates to Determine their Revenue
Adequacy for the upcoming Fiscal Year 2025 Budget Forecast.

The City of Brunswick desires to have a comprehensive review of the retail rates for its water and
sewer utilities in order to determine their revenue adequacy for the upcoming 2025 fiscal year.
As a result, Smart Utility Management, LLC (“SUM”) is proposing to provide the following services
for these utilities projected for the upcoming fiscal year ending June 30, 2025:
1)

Financial Adequacy Forecast
• Develop a fiscal year 2025 forecast of total retail sales, revenues, and expenses
• Perform industry standard techniques to determine the adequacy of the retail
rates to cover the City’s utility operating expenses with appropriate margins
• Include 2-3 options for the total percentage increases/decreases to retail rates
• Determine impacts to the City and by individual rate classes
• Prepare retail rate comparisons with other Utilities to inform rate design and
adjustments to rate class revenues including the allocation between In Town and
Out of Town customers
• Utilize historic retail rate maintenance to inform equitable revenue adjustments
• Modernize retail rates to ensure appropriate collection of fixed costs
• Update the Utility Rate fee schedule & coordinate rate change implementation
• A Cost of Service Study is not included in this proposal at this time
Fixed Fee……………..$19,500
Anticipated Date of Completion: End of April 2024 (6 to 8 Weeks)

Page 1 of 2

P.O. Box 4151, Ocean City, Maryland 21843

(410) 251-0526 / [email protected]

Page 12 of 60

City of Brunswick

February 9, 2024
Page 2 of 2

Please note that the Fixed Fee for these services are all-inclusive and include one in-person
presentation to the Mayor and Council. Any additional time, materials, travel, meetings and
reports after that first presentation to Council will be charged as Additional Services.
2)

Additional Services
• Any services following the first presentation to the Mayor and Council.
Time and Materials……………..$215.00 /hr. & materials at cost
**Travel time for in-person appearances will be at the Time and Materials hourly rate**

If these terms are acceptable, please sign/date below and return a copy of this executed
Engagement Letter to me at your convenience and I will begin work on these studies. Also, I
would like to say that I greatly appreciate this opportunity and I look forward to working closely
with you and the City over the coming weeks/months.
Sincerely,
Smart Utility Management, LLC

Christopher S. Simms
Principal
Approving Party
City of Brunswick

Signature__________________________________ Date of Approval ______________
Name_________________________
Title__________________________

Page 13 of 60

February 14, 2024
Mr. Matthew Campbell
Director of Utilities
City of Brunswick
One West Potomac Street
Brunswick, Maryland 21716
Re:

Proposal – Change Order No. 1; Additional Engineering Design and Construction Services for a Water
Storage Tank for the Yourtee Spring Water Treatment Plant (WTP)

Dear Mr. Campbell:
Whitman, Requardt and Associates, LLP (WRA) is pleased to present our design change order proposal for
additional engineering services including final design and construction services for a water storage tank at Yourtee
Spring.
Background
As a follow-on to the Yourtee WTP construction, the City plans to install a water storage tank at the WTP site to
improve the fire flow and provide equalization for local demands. The pumps at the Yourtee WTP were designed to
fill an on-site storage tank, however sizing and routing of the water mains and appurtenances connecting the WTP to
the new tank required additional efforts. In addition, the City has requested that WRA provide design services during
construction, including progress meetings, shop drawing reviews, RFI responses, and as-built drawings.
The following describes the proposed additional scope of work for the new water storage tank design:
A. Scope of Services
Upon Notice to Proceed, we will complete the design and assist the City with facility construction, as described
below.
1. Water Storage Tank Sizing, Location and Style
a. Complete design the water storage tank, including epoxy and glass-lined bolted steel tanks.
b. Complete design associated with site piping from filtration/WTP building to tank, and from tank back to the
filtration building point of entry into the distribution system.
2. Permitting Services
a. Environmental:
WRA assumes no wetlands, wetland buffers, streams, or 100-year floodplains will be impacted; and
therefore, a Joint Federal/State permit will not be required. WRA assumes the limit of disturbance will be
less than 20,000 SF, therefore the project would be exempt from the Washington County Forest
Conservation Ordinance. WRA will prepare and submit the Forest Conservation Ordinance Request for
Exemption form (selecting exemption (A)) to obtain the exemption. No forest impacts are anticipated but
individual tree impacts will be minimized and addressed through best management practices.
b. Washington County E&SC, SWM and Grading permits will be obtained. We have assumed that a full
development review process is not required.

G:\00djh\Proposal Development\Frederick County\Brunswick\Water Storage tank\Change Order Jan24\Brunswick Yourtee Tank CO1.docx

Page 14 of 60

Page 2
February 14, 2024

Mr. Matt Campbell
City of Brunswick, MD
3. Engineering Bidding and Construction Services

Provide additional bidding and construction management services which includes:
 Attend Pre-Bid Meeting, issue meeting notes;
 Assist City with Addenda (up to 2)
 Evaluate bids
 On-site or virtual Kick-off and Progress Meetings (7 meetings)
 Shop Drawing review (up to 25)
 Responses to Contractor’s Requests for Information (RFIs) (up to 10)
 Geotechnical and/or Structural Engineer site inspection for tank foundation construction and tank
installation (two site visits)
 Change Order Review (up to 2)
 System Integrator field testing (one site visit)
 Substantial Completion Punch List – one site visit (4 disciplines)
 Final Completion Acceptance
 Record Drawings
B. List of Drawings (additional drawings are shown in italics)
Sheet No.
G-1
C-1
SC-1
SC-2
M-1
M-2
M-3
M-4
M-5
M-6
E-1
E-2
E-3
I-1
I-2
I-3

Sheet Name
Title Sheet, Location Map and List of Drawings
Proposed Site Plan – New Work, Legend and Abbreviations
Erosion and Sediment Control Notes
Erosion and Sediment Control Details
Mechanical Legend, Abbreviations, Notes and System Hydraulics
Process and Tank Schematic
Potable Water Storage Tank Sections
Water Storge Tank Plans and Details
Existing Filter Building Modifications, Sections and Photos
Existing Filter Building Piping Modifications Plans and Sections
Electrical Legend, Abbreviations and Notes
Proposed Site Plan – New Work
Schedule
I&C Notes, Legend and Abbreviations
Instrumentation Plan
Instrumentation Details

C. Assumptions
1. Tank foundation design by Tank manufacturer.
2. Tank design to include lightning protection and passive tank mixing system.
3. Performance specifications for the lightning protection system.
4. Provide electrical power and grounding plans.
5. Assume that the existing upgraded electrical service will remain.
6. There are no lighting design requirements.
7. Bid Ready (100% signed and sealed) documents will be generated and provided for advertising and bidding.
8. No IDRs, no daily Construction Inspection is included.
9. Construction observations will be performed at monthly in-person progress meetings.
10. Construction duration of 6 months is assumed.
11. MDE Construction Permit was submitted on 11/30/2023 and approved on 2/2/2024.

G:\00djh\Proposal Development\Frederick County\Brunswick\Water Storage tank\Change Order Jan24\Brunswick Yourtee Tank CO1.docx

Page 15 of 60

Page 3
February 14, 2024

Mr. Matt Campbell
City of Brunswick, MD

D. Compensation
We will perform the Scope of Services on a lump sum basis. The lump sum cost for the Scope of Services is included
below. This fee will not be exceeded without your authorization.

Scope Item
1.0 Tank Design and Site Plan
2.0 Permitting Services
3.0 Construction Engineering Services
Total

Cost
$20,745
$7,397
$64,218
$92,360

This fee will not be exceeded without your authorization.
We will perform the required scope of work and any authorized additional services based on our current IDQ
Contract Services Agreement with Frederick County DUSWM / DWSU, on the basis of specified technical payroll
rates plus out-of-pocket expenses. The payroll rates include payroll burden, overhead costs for partners,
accountants, secretarial staff, and other non-technical support personnel engaged on this project. Out of pocket
expenses include subconsultant fees, reproduction, plus the costs for any other expenses used exclusively on this
project and are directly chargeable.
If a work effort for this project is recognized as being outside of this scope of services by WRA or is requested by the
City of Brunswick, a scope amendment will be submitted for the City’s authorization, prior to proceeding with that
effort.
Invoices will be rendered every four weeks for the actual services performed during the previous four-week period
and are due within 30 days of receipt.
A detailed Manhour Estimate and Cost Breakdown is included as an attachment to this proposal.

E. Schedule
The proposal assumes that all work will be completed by October 2024 with Notice to Proceed in February 2024;
however, WRA will not be liable for delays beyond its reasonable control.
Milestone
1
100% Documents
2
County Permitting
3
Construction Completion

Duration
4 weeks after comments received from MDE
4 weeks after MDE permit received
24 weeks after Contractor NTP

F. Terms and Conditions
This work will be completed in accordance with our current IDQ Agreement with Frederick County.

If this proposal is acceptable to you, please sign in the appropriate location below and return a copy for our files.

G:\00djh\Proposal Development\Frederick County\Brunswick\Water Storage tank\Change Order Jan24\Brunswick Yourtee Tank CO1.docx

Page 16 of 60

Mr. Matt Campbell
City of Brunswick, MD

Page 4
February 14, 2024

Very truly yours,
Whitman, Requardt and Associates, LLP

Dennis J. Hasson, P.E., BCEE
Partner
Enclosures
cc:
File
David Chung, P.E.
P. Andrew Cooper, P.E., BCEE

APPROVAL:

Signature

Date

G:\00djh\Proposal Development\Frederick County\Brunswick\Water Storage tank\Change Order Jan24\Brunswick Yourtee Tank CO1.docx

Page 17 of 60

Attachment A

PROJECT NAME: City of Brunswick - Yourtee Spring Filtration Plant Water Storage Tank Design and CMS

REVISION

T, R,E
Use Labor Cost Rates for year: 2022

$196

Bolted steel water Storage Tank include tank mixer
1a.
Design

1b. Site and Building piping

2a. Environmental permitting
2b. County permitting
3.

$150

$123

$97

$196

$150

$100

$196

$147

$64

$196

$133

$97

$196

$141

$64

$196

$141

$64

Line Item Totals

Subcontractor
Expenses

Subcontractor
hours

WRA EXPENSES

WRA TOTAL
PAYROLL

WRA TOTAL
HOURS

I&C Designer /
CADD

Design Engineer I&C

Project Manager I&C

Electrical
Designer / CADD

Design Engineer Electrical

Project Manager Electrical

Design Engineer WWW

Design Engineer HVAC/Plumbing

Project Manager Mechanical

Struct. Designer /
CADD

Design Engineer Structural

Project Manager Structural

Registered Prof.
Engineer Geotechnical

Senior Project
Engineer Geotech

Project Manager Geotech

Design Engineer W/WW

Design Engineer Civil

PROJECT DESCRIPTION: Yourtee Spring WTP
Water Storage Tank Design and Construction
Management Services

TASK

Senior Project
Engineer - Civil

Project Manager

CLIENT: City of Brunswick

Subcontractor
Payroll

DATE 1/22/2024
BY PAC

MANHOUR ESTIMATE AND PROPOSAL

T, R,E

S,or L

(See Legend)

S,or L (See Legend)

108

$11,684

$9,062

$2,964

$4,434

$5,096

$1,976

$200

$2,176

$2,677

$1,171

$1,000

$12,488

Bidding andConstruction services - Project
Management 6 months (26wks@1 hr/wk)

Pre-Bid Meeting

Addenda (2)

Evaluate Bids

$1,171

Kickoff and Progress Meetings (7)

$11,488

Shop drawing review (25)

137

$20,065

Response to Contractors RFIs (10)

$5,107

$2,376

$1,051

$1,568

$2,095

$3,998

$150

$4,148

6
2

Geotech and Structural -submittal review and onsite support

Change Order Review (2)

System Integrator field testing, total 8 I/C hrs.

Substantial Completion Punch List

Final Completion and Acceptance

$659

Record Drawings

$3,541

$91,010

128

TASK A SUBTOTALS =

As Builts/Record Dwgs

TASK A SUB-TOTAL DOLLARS = $25,088

162

146

664

$3,599

$19,845

$1,548

$392

$2,699

$1,568

$1,470

$2,744

$19,476

$3,528

$2,818

$3,136

$3,099

$91,010

202

Civil

$24,992

Geotech

$3,091

Structural

$3,038

160

Mech.

$22,220

Electrical

$6,346

SCADA

$6,235

$1,350

Subcontractor Total
Profit on Sub
WRA Total
TASK A TOTAL

Design
Engineer - Civil

Design
Engineer W/WW

Project
Manager Geotech

Senior Project
Engineer Geotech

Registered
Prof. Engineer Geotechnical

Project
Manager Structural

Design
Engineer Structural

Struct.
Designer /
CADD

Project
Manager Mechanical

Design
Engineer HVAC/Plumbin
g

Design
Engineer WWW

Project
Manager Electrical

Design
Engineer Electrical

Electrical
Designer /
CADD

Project
Manager - I&C

Design
Engineer - I&C

I&C Designer /
CADD

WRA
EXPENSES

Senior Project
Engineer - Civil

Bare Labor Cost rates for year 2022
Contract Rates - LOADED LABOR AT A FACTOR OF:

Project
Manager

PROJECT TOTAL

$196.00

$149.94

$122.50

$96.78

$196.00

$149.94

$100.00

$196.00

$147.00

$64.31

$196.00

$133.40

$96.78

$196.00

$140.88

$64.31

$196.00

$140.88

$64.31

T = Travel

$196.00

$149.94

$122.50

$96.78

$196.00

$149.94

$100.00

$196.00

$147.00

$64.31

$196.00

$133.40

$96.78

$196.00

$140.88

$64.31

$196.00

$140.88

$64.31

E = Equipment Rental

$0
0.0%
$92,360
$92,360
$92,360

S = Subcontractor
L= Laboratory Cost
R = Reproduction
Whitman, Requardt and Associates, LLP

Yourtee Water Storage Tank Fee CO1 IDQ Rates_01.22.2024.xlsx

Page 1 of 1

$92,360

Page 18 of 60

February 14, 2024
Mr. Matthew Campbell
Director of Water and Sewer Utilities
City of Brunswick
One West Potomac Street
Brunswick, Maryland 21716
Re:

Proposal - Design Engineering Services for the Replacement of the Drinking Water Reservoir

Dear Mr. Campbell:
Whitman, Requardt and Associates, LLP (WRA) is pleased to present our proposal for Design Engineering Services
for replacement of the Town’s aging drinking water reservoir with a new ground-level concrete potable water
reservoir.

A. Scope of Services
Upon Notice to Proceed, we will proceed with design, as described below.
Background
The Town’s existing reservoir consists of a 3.0 MG finished water in-ground concrete reservoir with a geotextile
floating roof located adjacent to the two elevated water storage tanks at the end of East K Street, on the south side of
Souder Road in Brunswick, Maryland. The reservoir has reached the end of its useful life, and the City plans to
replace it with a 2.0 to 3.0 MG (capacity TBD) wire-wound circular prestressed concrete ground-level storage tank
with a self-supporting concrete dome roof (such as those manufactured by DN Tanks or Preload).
The project consists of preparing contract drawings and specifications for demolishing the existing 3.0 MG finished
water in-ground reservoir having a base elevation of 487 feet and an overflow elevation of approximately 509 feet, and
constructing the new tank in the same location as the existing reservoir. The new reservoir will be partially buried and
have an approximate base elevation of 486 feet and an overflow elevation of approximately 502 feet, which will be
finalized during design.
In addition, an in-line booster pumping system or a temporary water tank to provide a clearwell for the high service
pumps to fill the elevated towers will be required while the existing reservoir is out of service and prior to completion of
the new reservoir. Design of the temporary tank(s) or pumping system(s) is included as part of this project.
Documents (by others) provided by the City to WRA include:
 Sheet C-200 Site and Layout Plan
 Draft Specifications for Demolition of Existing Reservoir and Construction of New Reservoir
 Geotechnical Report for Brunswick Reservoir Replacement
 SWM Study for Brunswick Reservoir Replacement
The following describes the proposed scope of work for the new potable water reservoir design:

G:\00djh\Proposal Development\Frederick County\Brunswick\Water Reservoir\Reservoir Design - Bruns 3MG.docx

Page 19 of 60

Mr. Matt Campbell
City of Brunswick, MD

Page 2
February 14, 2024

1. Project Management and Progress Meetings
WRA will provide overall project management and coordination. Meetings will include a kickoff meeting and
monthly progress meetings (virtual) for the duration of the design. WRA will provide meeting agendas and
minutes.
2. Topographic Surveys and Geotechnical Engineering
a. Topographic Surveys of the tank site have been performed by others as part of the initial study Site and
Layout Plan. No surveys will be performed as part of WRA’s scope.
b. The Geotechnical Engineering Report has been completed by others. WRA Geotechnical Engineers will
review the report and provide structural foundation design recommendations.
3. Water Storage Tank, Site Utilities and Water Transmission Main Design
a. Review site with respect to preliminary site plan and surveyed topography for the new prestressed wirewound circular concrete storage tank, capacity TBD (2.0 to 3.0 MG).
b. Review system hydraulics to confirm height of tank (floor elevation, overflow elevation), volume (diameter)
as well as tank location and capacity.
c.

Provide guidelines for tank foundation and foundation drain designed by the tank manufacturer and typical
design loads for this region.

d. Construction plans will be submitted to the Owner as 30%, 60%, 90% and Bid Ready (100%) complete,
with comments addressed after each submission. 30% design will include site visit. Designs will include:
-

Temporary interim storage or pumping system

Demolition of existing reservoir.

Grading of site to accommodate tank foundation and construction.

Associated site piping to and from the new reservoir, as well as overflow and tank drain piping.

Instrumentation and controls / alarms to monitor tank level, overflow, etc.

e. Specifications will be Owner standard form, including EJCDC general and supplementary conditions.
Limited technical specification sections will be included for items not specified on the drawings or covered
by Owner Standard Specifications. Specifications will be submitted with 60%, 90% and Bid Ready (100%)
submissions.

4. Permitting Services
a. Environmental: WRA assumes no wetlands, wetland buffers, streams, or 100-year floodplains will be
impacted; and therefore, a Joint Federal/State permit will not be required.
b. City of Brunswick / Frederick County Storm Water Management, Forest Ordinance and Grading permits
will be obtained. We have assumed that a full development review process is required. No forest impacts
are anticipated but individual tree impacts will be minimized and addressed through best management
practices.
c.

SCD Erosion & Sediment Control Permit will be obtained.

d. MDE Water Construction Permit and NOI will be obtained.

G:\00djh\Proposal Development\Frederick County\Brunswick\Water Reservoir\Reservoir Design - Bruns 3MG.docx

Page 20 of 60

Mr. Matt Campbell
City of Brunswick, MD

Page 3
February 14, 2024

5. Bidding Services
Two (2) hard copy and one (1) electronic bid document sets will be provided to the City upon approval of the
documents. Additional services include attending the Pre-bid meeting, and issuing one addendum.
B. List of Drawings
Sheet No.
G-1
G-2
C-1
C-2
C-3
C-4
C-5
C-6
C-7
C-8
C-9
S-1
S-2
M-1
M-2
M-3
M-4
M-5
M-6
E-1
E-2
E-3
E-4
I-1
I-2
I-3
I-4
I-5
I-6

Sheet Name
Title Sheet, Map Key, Legend and General Notes
Existing Reservoir Demolition Plan
Civil Notes
Reservoir Site / Grading Plan
Interim Storage / Pumping System Site Plan
Water Main Plan and Profile – Onsite Mains
Civil Details, Appurtenances, Boring Logs
E&SC Plan
E&SC Notes and Details
SWM Plan
SWM Notes and Details
General Structural Notes and Typical Details
Miscellaneous Structural Details
General Mechanical Notes, Legends, and Abbreviations
Tank Schematic
Interim Storage / Pumping System Plans and Sections
Water Tank Plan
Water Tank Sections
Sections and Details
Abbreviations, Symbols and General Notes
Site plan - Grounding and Power Plan
Receptacles, Interior and Exterior Lighting Plans
One Line Diagram and Panel Schedule
Instrumentation Notes, Legends and Abbr.
Water Tank P&ID
Interim Storage / Pumping System P&ID
Control Diagrams
Instrumentation Plan
Instrumentation Details

C. Assumptions
1.
2.
3.
4.
5.

Tank and tank foundation design by tank manufacturer.
Tank design to include an active tank mixing system.
Tank will have below grade dedicated inlet and dedicated outlet.
Tank joint at foundation does not need to be visible.
Altitude vault or other control valve vaults and or buildings are not required – pipes to/from the new reservoir
will tie to existing pipes serving the ex. reservoir.
6. Residual measurements and chemical addition are not required.
7. Flow meter is not required.
8. Tank overflow will have a manufacturer designed dechlorination device and will discharge to a drain box
(with air gap) which is directed to on-site storm drain.
9. Tank design will not include lightning protection.
10. Provide electrical power, exterior tank and perimeter lighting and grounding plans.

G:\00djh\Proposal Development\Frederick County\Brunswick\Water Reservoir\Reservoir Design - Bruns 3MG.docx

Page 21 of 60

Mr. Matt Campbell
City of Brunswick, MD

Page 4
February 14, 2024

11. Existing electrical service at the site is adequate.
12. Existing reservoir can be taken offline for the duration of construction, however a temporary tank/pumping
system is required.
13. Exclude design of telecom, fire alarm and security systems.
14. Exclude short circuit, coordination, and arc flash studies.
15. No wetlands, waterways, Joint Permit application are required.
16. Full development review permitting process is required.
17. Site surveys were previously performed by others. WRA will utilize this survey for our designs.
18. Geotechnical investigations and reports were previously performed by others. WRA will review the
Geotechnical reports, use them for site design, and provide to the tank Contractor for their design.

D. Compensation
A detailed workhour breakdown showing the derivation of this estimated fee is provided in the manhour spreadsheet
which is attached, and summarized below.
Scope Item
1.0 Project Management and Meetings
2.0 Surveys and Geotechnical Engineering
3.a-c Site Review, Dimensions, Foundation
3.d Interim Storage / Pumping
3.d 30% Design
3.d 60% Design and Site Visit
3.d 90% Design
3.d 100% Bid-Ready Design
4.0 Permitting Services
5.0 Bidding Services
Total

Cost
$20,542
$14,971
$20,269
$28,041
$35,968
$38,102
$26,340
$20,562
$11,948
$7,172
$223,915

This fee will not be exceeded without your authorization.
We will perform the required scope of work and any authorized additional services based on our current IDQ Contract
Services Agreement with Frederick County DUSWM / DWSU, on the basis of specified technical payroll rates plus outof-pocket expenses. The payroll rates include payroll burden, overhead costs for partners, accountants, secretarial
staff, and other non-technical support personnel engaged on this project. Out of pocket expenses include subconsultant
fees, reproduction, plus the costs for any other expenses used exclusively on this project and are directly chargeable.
If a work effort for this project is recognized as being outside of this scope of services by WRA or is requested by the
City of Brunswick, a scope amendment will be submitted for the City’s authorization, prior to proceeding with that effort.
Invoices will be rendered every four weeks for the actual services performed during the previous four-week period
and are due within 30 days of receipt.
A detailed Manhour Estimate and Cost Breakdown by task is included as Attachment A.

E. Schedule
The proposal assumes that all work will be completed by July 2025 with Notice to Proceed in February 2024;
however, WRA will not be liable for delays beyond its reasonable control.

G:\00djh\Proposal Development\Frederick County\Brunswick\Water Reservoir\Reservoir Design - Bruns 3MG.docx

Page 22 of 60

Mr. Matt Campbell
City of Brunswick, MD

Page 5
February 14, 2024

Milestone
1
30% Drawings
2
60% Drawings, Technical Specification
and Cost Estimate
3
90% Documents Drawings, Specification
and Cost Estimate
4
100% Documents Drawings, Specification
and Cost Estimate

Duration
16 weeks after Notice to Proceed
20 weeks after receiving 30%
comments
16 weeks after receiving 60%
comments
16 weeks after receiving 90%
comments

F. Terms and Conditions
This work will be completed in accordance with our current IDQ Agreement with Frederick County.

If this proposal is acceptable to you, please sign in the appropriate location below and return a copy for our files.
Thank you for the opportunity to present our Proposal. We look forward to working with you on this project.

Very truly yours,
Whitman, Requardt and Associates, LLP

Dennis J. Hasson, P.E., BCEE
Partner
Enclosures
cc:
File
David Chung, P.E.
P. Andrew Cooper, P.E., BCEE
APPROVAL:

Signature

Date

G:\00djh\Proposal Development\Frederick County\Brunswick\Water Reservoir\Reservoir Design - Bruns 3MG.docx

Page 23 of 60

Attachment A

PROJECT NAME: City of Brunswick - Potable Water Reservoir Design

REVISION

T, R,E

T, R,E
(See Legend)

Use Labor Cost Rates for year:

2024

$201

$150

$107

$93

$186

Project Management, kick-off meeting and monthly
progress meetings

Topographic Surveys and Geotechnical
Engineering

Site Review

Confirm Tank Dimensions

Tank Foundation Guidelines

Interim Storage / Pumping Design

30% Design

60% Design, Plans and Specifications

90% Design, Plans and Specifications

100% Bid Ready Documents

Permitting

Bidding

TASK A SUBTOTALS =

162

TASK A SUB-TOTAL DOLLARS = $32,510

$150

$105

$145

$99

$85

48
2
4
2

20
4

$130

136

$20,392

$150

$20,542

$14,971

$4,697

$300

$4,997

$1,986

$13,286

$127

$85

4
20

$186

$104

$99

(See Legend)

$185

$85

2
8

S,or L

220

$28,041

298

$35,968

324

$37,952

$150

$38,102

214

$26,340

156

$20,562

104

$11,948

$6,872

$300

$7,172

$223,015

364

198

130

260

1706

$7,183

$38,846

$18,374

$13,734

$19,492

$3,480

$7,494

$8,875

$33,779

$6,605

$6,310

$9,688

$6,310

$8,352

$1,981

$223,015

610

Civil

$64,403

204

Geotech

$33,227

100

386

Mech.

$49,259

110

Electrical

$15,999

114

SCADA

$14,662

Structural $10,974

$900

Subcontractor Total
Profit on Sub
WRA Total
TASK A TOTAL

$84.68

$184.90

$129.92

$84.68

$185.60

$127.48

$84.68

$185.60

$104.40

$0.00

$99.06

T = Travel

$98.60

$84.68

$184.90

$129.92

$84.68

$185.60

$127.48

$84.68

$185.60

$104.40

$0.00

$99.06

E = Equipment Rental

$0
0.0%
$223,915
$223,915

$223,915

WRA
EXPENSES

Sr. Project
Engineer /
Environmental
Scientist

$98.60

$145.00

Elect.
Draftsman /
CADD

$145.00

$105.00

Design
Engineer Electrical

$105.00

$149.94

Senior Project
Engineer Electrical

$149.94

$185.60

Design
Engineer Mechanical

$185.60

$92.80

Senior Project
Engineer Mechanical

$92.80

$106.72

Struct. CAD
Operator

$106.72

$149.64

Design
Engineer Structural

$149.64

$200.68

Senior Project
Engineer Structural

$200.68

Geologist /
Hydrologist

Sr. Project
Engineer Electrical / I&C

Mech Designer/
CADD

Geotech Regd.
Prof. Engineer

Geotech. Senior
Proj. Engr.

Design
Engineer - Civil

2024

Design
Engineer W/WW

SCADA/
Electrical
Design
Engineer

Bare Labor Cost rates for year

Senior Project
Engineer - Civil

Project Manager

PROJECT TOTAL

Contract Rates* - LOADED LABOR AT A FACTOR OF:

Line Item Totals

Subcontractor
Expenses

Subcontractor
hours

WRA EXPENSES

WRA TOTAL
PAYROLL

WRA TOTAL
HOURS

Sr. Project
Engineer /
Environmental
Scientist

SCADA/ Electrical
Design Engineer

Sr. Project
Engineer Electrical / I&C

Elect. Draftsman /
CADD

Design Engineer Electrical

Senior Project
Engineer Electrical

Mech Designer/
CADD

Design Engineer Mechanical

Senior Project
Engineer Mechanical

Struct. CAD
Operator

Design Engineer Structural

Senior Project
Engineer Structural

Geotech Regd.
Prof. Engineer

Geotech. Senior
Proj. Engr.

Geologist /
Hydrologist

Design Engineer Civil

PROJECT DESCRIPTION: Demolition of existing
reservoir and design of a new potable water
reservoir

Design Engineer W/WW

TASK

Senior Project
Engineer - Civil

Project Manager

CLIENT: City of Brunswick

Subcontractor
Payroll

DATE 1/23/2024
BY PAC

MANHOUR ESTIMATE AND PROPOSAL

S = Subcontractor
L= Laboratory Cost
R = Reproduction

*Current Frederick County Facilities IDQ Rates

Whitman, Requardt and Associates, LLP

Bruns Reservoir Tank Fee IDQ Rates_01.23.2024.xlsx

Page 1 of 1

$223,915

Page 24 of 60

General Ledger
Budget Status
User:
Printed:
Period:

Rbruchey
2/6/2024 - 2:46 PM
7, 2024

Account Number

Description

Fund
30
Dept
30-106
R43
30-106-04-4323

R46
30-106-04-4322

R50
30-106-04-4321

Dept
30-110
R21
30-110-03-4202

Budget Amount

Period Amount

YTD Amount

YTD Var

Encumbered Amount

Available

% Available

Capital Project Fund
Impact Fees
Charges-Impact Fees
Impact Fees-Municipal Facility

0.00

R43 Sub Totals:

0.00

Charges-Public Safety
Impact Fees-Police

600.00

0.00

600.00

0.00

600.00

100.00

R46 Sub Totals:

600.00

0.00

600.00

0.00

600.00

100.00

Charges-Recreation
Impact Fees-Parks

2,000.00

0.00

2,000.00

0.00

2,000.00

100.00

R50 Sub Totals:

2,000.00

0.00

2,000.00

0.00

2,000.00

100.00

Revenue Sub Totals:

2,600.00

0.00

2,600.00

0.00

2,600.00

100.00

Dept 106 Sub Totals:
Grants - Federal Government
Grant-Public Safety
SHSP Homeland Security Grant

-2,600.00

0.00

-2,600.00

0.00

Grants-Other Intergovernment
Miscellaneous Federal Grants

58,500.00

0.00

58,500.00

0.00

58,500.00

100.00

R30 Sub Totals:

58,500.00

0.00

58,500.00

0.00

58,500.00

100.00

Revenue Sub Totals:

58,500.00

0.00

58,500.00

0.00

58,500.00

100.00

Dept 110 Sub Totals:
Grants - State Government
Grant-Parks, Rec, Culture
Program Open Space Grants&LPPI

-58,500.00

0.00

-58,500.00

0.00

301,642.44

-301,642.44

0.00

-301,642.44

0.00

R21 Sub Totals:
R30
30-110-03-4219

Dept
30-111
R22
30-111-03-4251
GL-Budget Status (2/6/2024 - 2:46 PM)

Page 1

Page 25 of 60

Account Number

Description

30-111-03-4252
30-111-03-4253
30-111-03-4254

R23
30-111-03-4240
30-111-03-4245

R30
30-111-03-4227
30-111-03-4260
30-111-03-4265
30-111-03-4266
30-111-03-4267
30-111-03-4268
30-111-03-4269
30-111-03-4270
30-111-03-4273

Dept
30-170
R81
30-170-06-4622

Dept
30-172
R83
30-172-06-4700
30-172-06-4709

GL-Budget Status (2/6/2024 - 2:46 PM)

Budget Amount

Period Amount

YTD Amount

YTD Var

Encumbered Amount

Available

% Available

Community Parks & Playgrounds
Preservation MD Grant
POS Grants-East Potomac

0.00
0.00
0.00

R22 Sub Totals:

0.00

301,642.44

-301,642.44

0.00

-301,642.44

0.00

Grant-Community Development
Community Legacy Grants
CDBG Programs

0.00
0.00

R23 Sub Totals:

0.00

Grants-Other Intergovernment
SHA Administrative Grants
MDE Grants
Cap from St-Martns CreekTunnel
Cap from St-13th Ave Pole Barn
Cap from St - 811 W Potomac St
Cap fr St-30-34 W Potomac-CDBG
Miscellaneous State Grants
Cap fr St-Kaplon WPotomac-CDBG
ARPA Grant

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
397,571.25

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
-397,571.25

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
-397,571.25

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

R30 Sub Totals:

0.00

397,571.25

-397,571.25

0.00

-397,571.25

0.00

Revenue Sub Totals:

0.00

699,213.69

-699,213.69

0.00

-699,213.69

0.00

Dept 111 Sub Totals:
Investment Earnings
Investment Earnings
Interest-Impact Fees

0.00

-699,213.69

699,213.69

0.00

725.54

-725.54

0.00

-725.54

0.00

R81 Sub Totals:

0.00

725.54

-725.54

0.00

-725.54

0.00

Revenue Sub Totals:

0.00

725.54

-725.54

0.00

-725.54

0.00

Dept 170 Sub Totals:
Contributions & Donations
Contributions-Non-Govt
Contributed Capital
Misc.Grants/Donations-Non-Govt

0.00

-725.54

725.54

0.00

0.00
0.00

R83 Sub Totals:

0.00

Page 2

Page 26 of 60

Account Number

Dept
30-173
R80
30-173-06-4652

Dept
30-175
R80
30-175-06-4699

R85
30-175-08-5101
30-175-08-5106

Dept
30-190
R86
30-190-07-5000

Dept
30-504
E30
30-504-10-8003
30-504-10-8005
30-504-10-8008
30-504-10-8009
GL-Budget Status (2/6/2024 - 2:46 PM)

Description

Budget Amount

Period Amount

YTD Amount

YTD Var

Encumbered Amount

Available

% Available

Revenue Sub Totals:

0.00

Dept 172 Sub Totals:
Sales of Property
Miscellaneous Revenues
Sale of Building

0.00

R80 Sub Totals:

0.00

Revenue Sub Totals:

0.00

Dept 173 Sub Totals:
Other Revenues
Miscellaneous Revenues
Miscellaneous Revenue

0.00

10.44

-10.44

0.00

-10.44

0.00

R80 Sub Totals:

0.00

10.44

-10.44

0.00

-10.44

0.00

Interfund Transfers
Transfers In from General Fund
Budgeted Use of Reserves

1,040,800.00
0.00

0.00
0.00

1,040,800.00
0.00

0.00
0.00

R85 Sub Totals:

1,040,800.00

0.00

1,040,800.00

0.00

Revenue Sub Totals:

1,040,800.00

0.00

1,040,810.44

-10.44

0.00

-10.44

0.00

Dept 175 Sub Totals:
Long-term Debt Proceeds
Other Sources
Proceeds from New Debt

-1,040,800.00

0.00

-1,040,810.44

10.44

0.00

161,600.00

0.00

161,600.00

0.00

161,600.00

100.00

R86 Sub Totals:

161,600.00

0.00

161,600.00

0.00

161,600.00

100.00

Revenue Sub Totals:

161,600.00

0.00

161,600.00

0.00

161,600.00

100.00

Dept 190 Sub Totals:
Finance & Administration
Project Outlays
Capital-Equipment
Capital-Software Upgrade
Capital-Building Improvements
Medical Center Building & Prop

-161,600.00

0.00

-161,600.00

0.00

0.00
0.00
0.00
500,000.00

0.00
0.00
0.00
0.00

0.00
0.00
0.00
516,369.47

0.00
0.00
0.00
-16,369.47

0.00
0.00
0.00
0.00

0.00
0.00
0.00
-16,369.47

0.00
0.00
0.00
0.00
Page 3

Page 27 of 60

Account Number

Description

30-504-10-8330
30-504-19-8331

40 W Potomac St Project
Citizen Engagement Portal-ARPA

Dept
30-507
E30
30-507-10-8004

Dept
30-520
E30
30-520-11-8003
30-520-11-8004
30-520-11-8008
30-520-11-8332
30-520-11-8333

Dept
30-530
E30
30-530-12-8003
30-530-12-8004
30-530-12-8008
30-530-12-8009
30-530-12-8305
30-530-12-8310
30-530-12-8311
30-530-12-8315
30-530-12-8320
30-530-12-8331
GL-Budget Status (2/6/2024 - 2:46 PM)

Budget Amount

Period Amount

YTD Amount

YTD Var

Encumbered Amount

Available

% Available

0.00
0.00

0.00
25,000.00

0.00
-25,000.00

0.00
66,421.00

0.00
-91,421.00

0.00
0.00

E30 Sub Totals:

500,000.00

0.00

541,369.47

-41,369.47

66,421.00

-107,790.47

0.00

Expense Sub Totals:

500,000.00

0.00

541,369.47

-41,369.47

66,421.00

-107,790.47

0.00

Dept 504 Sub Totals:
Planning & Zoning
Project Outlays
Capital-Vehicles

500,000.00

0.00

541,369.47

-41,369.47

66,421.00

30,000.00

0.00

35,364.00

-5,364.00

0.00

-5,364.00

0.00

E30 Sub Totals:

30,000.00

0.00

35,364.00

-5,364.00

0.00

-5,364.00

0.00

Expense Sub Totals:

30,000.00

0.00

35,364.00

-5,364.00

0.00

-5,364.00

0.00

Dept 507 Sub Totals:
Police Department
Project Outlays
Capital-Equipment
Capital-Vehicles
Capital-Building Improvements
811 W Potomac St Project
License Plate Reader-Trailer

30,000.00

0.00

35,364.00

-5,364.00

0.00

8,000.00
50,000.00
0.00
0.00
0.00

0.00
0.00
0.00
0.00
0.00

0.00
0.00
0.00
-1,353.50
0.00

8,000.00
50,000.00
0.00
1,353.50
0.00

0.00
0.00
0.00
16,920.40
0.00

8,000.00
50,000.00
0.00
-15,566.90
0.00

100.00
100.00
0.00
0.00
0.00

E30 Sub Totals:

58,000.00

0.00

-1,353.50

59,353.50

16,920.40

42,433.10

73.16

Expense Sub Totals:

58,000.00

0.00

-1,353.50

59,353.50

16,920.40

42,433.10

73.16

Dept 520 Sub Totals:
Public Works
Project Outlays
Capital-Equipment
Capital-Vehicles
Capital-Building Improvements
Capital-Other Infrastructure
Sidewalk Improvements
Storm Water Management Project
Blacktop Improvements
MS4 Implementation Project
1106 Petersville Rd
13th Ave Pole Barn Project

58,000.00

0.00

-1,353.50

59,353.50

16,920.40

13,000.00
102,500.00
20,000.00
0.00
0.00
50,000.00
200,000.00
65,000.00
0.00
0.00

0.00
0.00
1,551.77
0.00
0.00
0.00
0.00
0.00
0.00
0.00

13,235.00
113,389.39
1,551.77
0.00
0.00
0.00
0.00
42,113.37
0.00
0.00

-235.00
-10,889.39
18,448.23
0.00
0.00
50,000.00
200,000.00
22,886.63
0.00
0.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
51,914.75
0.00
0.00

-235.00
-10,889.39
18,448.23
0.00
0.00
50,000.00
200,000.00
-29,028.12
0.00
0.00

0.00
0.00
92.24
0.00
0.00
100.00
100.00
0.00
0.00
0.00
Page 4

Page 28 of 60

Account Number

Description

30-530-12-8332
30-530-12-8333
30-530-12-8334
30-530-12-8335
30-530-12-8425
30-530-12-8430
30-530-19-8325
30-530-19-8326
30-530-19-8327
30-530-19-8328
30-530-19-8329
30-530-19-8330

Dept
30-540
E30
30-540-18-8500
30-540-18-8501
30-540-18-8502
30-540-18-8513
30-540-18-8514
30-540-18-8515
30-540-18-8516
30-540-18-8517
30-540-18-8519
30-540-19-8505
30-540-19-8509
30-540-19-8510
30-540-19-8511
30-540-19-8512
30-540-19-8513
30-540-19-8514
30-540-19-8515
30-540-19-8516
30-540-19-8517
30-540-19-8518
30-540-19-8519
30-540-19-8520
30-540-19-8521
GL-Budget Status (2/6/2024 - 2:46 PM)

Budget Amount

Period Amount

YTD Amount

YTD Var

Encumbered Amount

Available

% Available

811 W Potomac St Project
23 S Virginia Ave Project
Martin's Creek Tunnel Project
811 Additional Items
Clean-Up - Mold & Flooding
Meters Station
ADA Curb Cuts-CDBG
30,32,34 W Potomac Impr-CDBG
Kaplon Bldg-W PotomacImpr-CDBG
West B St StormWater Pipe-ARPA
DelawareAv StrmWater Pipe-ARPA
Sidewalks-ARPA

0.00
0.00
0.00
150,000.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

-1,353.52
0.00
0.00
114,698.49
0.00
0.00
0.00
0.00
0.00
0.00
0.00
372,487.60

1,353.52
0.00
0.00
35,301.51
0.00
0.00
0.00
0.00
0.00
0.00
0.00
-372,487.60

16,920.40
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
88,580.00
44,679.00
52,125.25

-15,566.88
0.00
0.00
35,301.51
0.00
0.00
0.00
0.00
0.00
-88,580.00
-44,679.00
-424,612.85

0.00
0.00
0.00
23.53
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

E30 Sub Totals:

600,500.00

1,551.77

656,122.10

-55,622.10

254,219.40

-309,841.50

0.00

Expense Sub Totals:

600,500.00

1,551.77

656,122.10

-55,622.10

254,219.40

-309,841.50

0.00

Dept 530 Sub Totals:
Parks
Project Outlays
Park Improvement Projects
Sports Complex Improvements
CSX Open Space Improvements
CityPark Building Improvements
Brunswick Welcome Arch
Peach Orchard Lane-Wenner Prop
B&O Park-Bond
Sports Complex-Bond
WTRI Bulding-13th Ave-Bond
Caboose/WB Tower-CLG
WB Tower move
E Potmac Park Proj (POS Grant)
LL Fields Complex (POS) Grant
City Park Playground
Playground Equipment
Gum Springs Footbridge
Sports Complex Toilets
City Park Trail
BrunswickCampground Playground
2nd Ave Park Playground
WTRI Building-13th Ave-POS
Caines Property-POS
B&O Park

600,500.00

1,551.77

656,122.10

-55,622.10

254,219.40

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
75,000.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

0.00
10,604.24
0.00
0.00
0.00
0.00
0.00
0.00
75,000.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
88,559.00
213,083.44
264,955.92
0.00
100,000.00

0.00
-10,604.24
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
-88,559.00
-213,083.44
-264,955.92
0.00
-100,000.00

0.00
0.00
0.00
0.00
0.00
0.00
87,301.50
217,530.50
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

0.00
-10,604.24
0.00
0.00
0.00
0.00
-87,301.50
-217,530.50
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
-88,559.00
-213,083.44
-264,955.92
0.00
-100,000.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Page 5

Page 29 of 60

Account Number

Description

30-540-19-8522
30-540-19-8523

B&O Park-LPPI
City Park Bldg Impr-LPPI

Dept
30-543
E30
30-543-18-8551

Dept
30-545
E30
30-545-18-8581

Budget Amount

Period Amount

YTD Amount

YTD Var

Encumbered Amount

Available

% Available

0.00
0.00

87,246.50
26,640.00

-87,246.50
-26,640.00

87,753.50
91,440.00

-175,000.00
-118,080.00

0.00
0.00

E30 Sub Totals:

75,000.00

0.00

866,089.10

-791,089.10

484,025.50

-1,275,114.60

0.00

Expense Sub Totals:

75,000.00

0.00

866,089.10

-791,089.10

484,025.50

-1,275,114.60

0.00

Dept 540 Sub Totals:
Swimming Pool
Project Outlays
Swimming Pool Improvements

75,000.00

0.00

866,089.10

-791,089.10

484,025.50

0.00

E30 Sub Totals:

0.00

Expense Sub Totals:

0.00

Dept 543 Sub Totals:
Campground
Project Outlays
Campground Improvements

0.00

E30 Sub Totals:

0.00

Expense Sub Totals:

0.00

Dept 545 Sub Totals:

0.00

Fund Revenue Sub Totals:

1,263,500.00

0.00

1,740,749.67

-477,249.67

0.00

-477,249.67

0.00

Fund Expense Sub Totals:

1,263,500.00

1,551.77

2,097,591.17

-834,091.17

821,586.30

-1,655,677.47

0.00

1,551.77

356,841.50

-356,841.50

821,586.30

Revenue Totals:

1,263,500.00

0.00

1,740,749.67

-477,249.67

0.00

-477,249.67

0.00

Expense Totals:

1,263,500.00

1,551.77

2,097,591.17

-834,091.17

821,586.30

-1,655,677.47

0.00

Report Totals:

0.00

1,551.77

356,841.50

-356,841.50

821,586.30

Fund 30 Sub Totals:

GL-Budget Status (2/6/2024 - 2:46 PM)

Page 6

Page 30 of 60

General Ledger
Budget Status
User:
Printed:
Period:

Rbruchey
2/6/2024 - 2:27 PM
7, 2024

Account Number

Description

Fund
10
Dept
10-101
R01
10-101-01-4002
10-101-01-4004
10-101-01-4005
10-101-01-4006
10-101-01-4008
10-101-01-4009
10-101-01-4010

Dept
10-102
R01
10-102-01-4030

Dept
10-103
R01
10-103-01-4040
10-103-01-4041

GL-Budget Status (2/6/2024 - 2:27 PM)

Budget Amount

Period Amount

YTD Amount

YTD Var

Encumbered Amount

Available

% Available

General Fund
Local Property Tax
Taxes
Real Estate Taxes
Additions & Abatements
Penalty/Int-Delinquent Taxes
Discount Allowed on Taxes
Refunds on Real Estate Taxes
Homeowners Credit-Property Tax
Real Estate Taxes-Public UT

4,060,300.00
11,700.00
36,000.00
-42,000.00
0.00
7,000.00
6,600.00

1,988,047.31
0.00
40,283.68
10.68
0.00
-887.73
0.00

3,979,607.39
-14,009.02
41,172.23
-47,309.17
-156.70
4,508.73
0.00

80,692.61
25,709.02
-5,172.23
5,309.17
156.70
2,491.27
6,600.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00

80,692.61
25,709.02
-5,172.23
5,309.17
156.70
2,491.27
6,600.00

1.99
219.74
0.00
-12.64
0.00
35.59
100.00

R01 Sub Totals:

4,079,600.00

2,027,453.94

3,963,813.46

115,786.54

0.00

115,786.54

2.84

Revenue Sub Totals:

4,079,600.00

2,027,453.94

3,963,813.46

115,786.54

0.00

115,786.54

2.84

Dept 101 Sub Totals:
Income Taxes
Taxes
Income Taxes

-4,079,600.00

-2,027,453.94

-3,963,813.46

-115,786.54

0.00

1,500,000.00

8,845.42

465,515.09

1,034,484.91

0.00

1,034,484.91

68.97

R01 Sub Totals:

1,500,000.00

8,845.42

465,515.09

1,034,484.91

0.00

1,034,484.91

68.97

Revenue Sub Totals:

1,500,000.00

8,845.42

465,515.09

1,034,484.91

0.00

1,034,484.91

68.97

Dept 102 Sub Totals:
Other Local Taxes
Taxes
Admission & Amusement Taxes
Public Utility Taxes

-1,500,000.00

-8,845.42

-465,515.09 -1,034,484.91

0.00

40,000.00
130,000.00

7,251.18
83,034.57

14,861.81
107,002.51

25,138.19
22,997.49

0.00
0.00

25,138.19
22,997.49

62.85
17.69

R01 Sub Totals:

170,000.00

90,285.75

121,864.32

48,135.68

0.00

48,135.68

28.32

Revenue Sub Totals:

170,000.00

90,285.75

121,864.32

48,135.68

0.00

48,135.68

28.32

Page 1

Page 31 of 60

Account Number

Description

Dept
10-105
R11
10-105-02-4063
10-105-02-4064

Dept
10-110
R21
10-110-03-4202

R30
10-110-03-4201
10-110-03-4219

Dept
10-111
R20
10-111-03-4230
10-111-03-4231

R21
10-111-03-4221
10-111-03-4222
10-111-03-4225

R23
10-111-03-4235
10-111-03-4236
10-111-03-4240
GL-Budget Status (2/6/2024 - 2:27 PM)

Budget Amount

Period Amount

YTD Amount

YTD Var

Encumbered Amount

Available

% Available

Dept 103 Sub Totals:
Licenses & Permits
Franchise Fees
Profession&Occupation Licenses
Cable Television Franchise Fee

-170,000.00

-90,285.75

-121,864.32

-48,135.68

0.00

9,000.00
122,000.00

6.89
0.00

216.71
27,487.63

8,783.29
94,512.37

0.00
0.00

8,783.29
94,512.37

97.59
77.47

R11 Sub Totals:

131,000.00

6.89

27,704.34

103,295.66

0.00

103,295.66

78.85

Revenue Sub Totals:

131,000.00

6.89

27,704.34

103,295.66

0.00

103,295.66

78.85

Dept 105 Sub Totals:
Grants - Federal Government
Grant-Public Safety
SHSP Homeland Security Grant

-131,000.00

-6.89

-27,704.34

-103,295.66

0.00

16,000.00

0.00

8,354.16

7,645.84

0.00

7,645.84

47.79

R21 Sub Totals:

16,000.00

0.00

8,354.16

7,645.84

0.00

7,645.84

47.79

Grants-Other Intergovernment
FEMA Grants
Miscellaneous Federal Grants

0.00
8,000.00

0.00
0.00

0.00
1,329.68

0.00
6,670.32

0.00
0.00

0.00
6,670.32

0.00
83.38

R30 Sub Totals:

8,000.00

0.00

1,329.68

6,670.32

0.00

6,670.32

83.38

Revenue Sub Totals:

24,000.00

0.00

9,683.84

14,316.16

0.00

14,316.16

59.65

Dept 110 Sub Totals:
Grants - State Government
Intergovernmental
Highway User Revenue
HUR Supplemental

-24,000.00

0.00

-9,683.84

-14,316.16

0.00

453,000.00
0.00

81,686.10
0.00

130,263.68
0.00

322,736.32
0.00

0.00
0.00

322,736.32
0.00

71.24
0.00

R20 Sub Totals:

453,000.00

81,686.10

130,263.68

322,736.32

0.00

322,736.32

71.24

Grant-Public Safety
State Aid Police Protection
Other GOCCP Grants
SHA Enforcement Grants

116,000.00
23,500.00
0.00

0.00
0.00
0.00

63,216.00
0.00
0.00

52,784.00
23,500.00
0.00

0.00
0.00
0.00

52,784.00
23,500.00
0.00

45.50
100.00
0.00

R21 Sub Totals:

139,500.00

0.00

63,216.00

76,284.00

0.00

76,284.00

54.68

Grant-Community Development
Berlin Cemetary Rehab Grant
Heritage Museum Grant
Community Legacy Grants

0.00
0.00
81,000.00

0.00
0.00
0.00

0.00
0.00
81,000.00

0.00
0.00
0.00

0.00
0.00
81,000.00

0.00
0.00
100.00
Page 2

Page 32 of 60

Account Number

Description

10-111-03-4245

R30
10-111-03-4261
10-111-03-4266
10-111-03-4273

Dept
10-112
R20
10-112-03-4271

R21
10-112-03-4275
10-112-03-4276

R30
10-112-03-4274
10-112-03-4280
10-112-03-4289

Dept
10-130
R05
10-130-04-4345

Budget Amount

Period Amount

YTD Amount

YTD Var

Encumbered Amount

Available

% Available

CDBG Programs

0.00

R23 Sub Totals:

81,000.00

0.00

81,000.00

0.00

81,000.00

100.00

Grants-Other Intergovernment
Chesapeake Bay Trust
Emergency Management-StateDept
ARPA Grant

0.00
0.00
0.00

0.00
0.00
10,425.00

0.00
37,265.48
367,967.19

0.00
-37,265.48
-367,967.19

0.00
0.00
0.00

0.00
-37,265.48
-367,967.19

0.00
0.00
0.00

R30 Sub Totals:

0.00

10,425.00

405,232.67

-405,232.67

0.00

-405,232.67

0.00

Revenue Sub Totals:

673,500.00

92,111.10

598,712.35

74,787.65

0.00

74,787.65

11.10

Dept 111 Sub Totals:
Grants - County Government
Intergovernmental
Tax Equity-Frederick County

-673,500.00

-92,111.10

-598,712.35

-74,787.65

0.00

1,243,300.00

310,813.50

932,440.50

310,859.50

0.00

310,859.50

25.00

R20 Sub Totals:

1,243,300.00

310,813.50

932,440.50

310,859.50

0.00

310,859.50

25.00

Grant-Public Safety
County Alcohol/Tobacco Grant
Marijuana Educaton Reimb Grant

0.00
0.00

R21 Sub Totals:

0.00

Grants-Other Intergovernment
County Financial Corp. Grant
TRIPP Grant
Miscellaneous County Grants

1,100.00
0.00
0.00

0.00
0.00
0.00

1,103.17
0.00
0.00

-3.17
0.00
0.00

0.00
0.00
0.00

-3.17
0.00
0.00

0.00
0.00
0.00

R30 Sub Totals:

1,100.00

0.00

1,103.17

-3.17

0.00

-3.17

0.00

Revenue Sub Totals:

1,244,400.00

310,813.50

933,543.67

310,856.33

0.00

310,856.33

24.98

Dept 112 Sub Totals:
General Government Charges
Developer Agreements
Reimbursements from Developers

-1,244,400.00

-310,813.50

-933,543.67

-310,856.33

0.00

200.00
100.00

28.00
0.00

144.00
245.00

56.00
-145.00

0.00
0.00

56.00
-145.00

28.00
0.00

R05 Sub Totals:
R41
10-130-04-4401
10-130-04-4403

GL-Budget Status (2/6/2024 - 2:27 PM)

Charges-General Government
Admin Svcs-Copies,Notary,Faxes
NSF Check Fee

Page 3

Page 33 of 60

Account Number

Description

Budget Amount

Period Amount

YTD Amount

YTD Var

Encumbered Amount

Available

% Available

300.00

28.00

389.00

-89.00

0.00

-89.00

0.00

Charges-Zoning & Planning
Zoning Fees
Consulting Review Fee
Development Review Fee
Appeals Filing Fee

15,000.00
0.00
45,000.00
0.00

1,425.00
0.00
450.00
0.00

8,325.00
0.00
6,845.00
0.00

6,675.00
0.00
38,155.00
0.00

0.00
0.00
0.00
0.00

6,675.00
0.00
38,155.00
0.00

44.50
0.00
84.79
0.00

R42 Sub Totals:

60,000.00

1,875.00

15,170.00

44,830.00

0.00

44,830.00

74.72

Revenue Sub Totals:

60,300.00

1,903.00

15,559.00

44,741.00

0.00

44,741.00

74.20

Dept 130 Sub Totals:
Public Safety Charges
Charges-Public Safety
Police Reports

-60,300.00

-1,903.00

-15,559.00

-44,741.00

0.00

200.00

30.00

215.00

-15.00

0.00

-15.00

0.00

R46 Sub Totals:

200.00

30.00

215.00

-15.00

0.00

-15.00

0.00

Revenue Sub Totals:

200.00

30.00

215.00

-15.00

0.00

-15.00

0.00

Dept 132 Sub Totals:
PublicWorks/Highways & Streets
Charges-Streets,Sidewalks
Inspection Fees

-200.00

-30.00

-215.00

15.00

0.00

180.00

-180.00

0.00

-180.00

0.00

R41 Sub Totals:
R42
10-130-04-4340
10-130-04-4341
10-130-04-4342
10-130-04-4344

Dept
10-132
R46
10-132-04-4410

Dept
10-134
R47
10-134-04-4439

R47 Sub Totals:
R48
10-134-04-4420
10-134-04-4421

R86
10-134-04-4423

Dept
R60

10-140

GL-Budget Status (2/6/2024 - 2:27 PM)

0.00

180.00

-180.00

0.00

-180.00

0.00

Charges-Parking
Parking Meter Collections
Parking Permits

8,000.00
0.00

876.90
0.00

2,956.70
0.00

5,043.30
0.00

0.00
0.00

5,043.30
0.00

63.04
0.00

R48 Sub Totals:

8,000.00

876.90

2,956.70

5,043.30

0.00

5,043.30

63.04

Other Sources
Infrastructure Insurnce Reimb

0.00

R86 Sub Totals:

0.00

Revenue Sub Totals:

8,000.00

876.90

3,136.70

4,863.30

0.00

4,863.30

60.79

Dept 134 Sub Totals:
Utility Service Charges
Charges-Utility

-8,000.00

-876.90

-3,136.70

-4,863.30

0.00

Page 4

Page 34 of 60

Account Number

Description

10-140-04-4431
10-140-04-4436
10-140-04-4437
10-140-04-4441
10-140-04-4442
10-140-04-4443

Dept
10-150
R50
10-150-04-4505
10-150-04-4506
10-150-04-4507
10-150-04-4508
10-150-04-4510
10-150-04-4512
10-150-04-4513
10-150-04-4514
10-150-04-4516
10-150-04-4517
10-150-04-4519
10-150-04-4520

Dept
10-160
R70
10-160-05-4600
10-160-05-4605
10-160-05-4606
10-160-05-4607
10-160-05-4610

Budget Amount

Period Amount

YTD Amount

YTD Var

Encumbered Amount

Available

% Available

Interest-UT bills
Tipping Fees
Recycling/Bulk Trash/Compost
Settlement Charges
Refund-Utility Bills
Administrative UT Write-offs

0.00
400,700.00
6,000.00
16,000.00
0.00
0.00

0.00
202.34
0.00
850.00
0.00
0.00

9.47
197,694.80
4,178.63
5,600.00
0.00
0.00

-9.47
203,005.20
1,821.37
10,400.00
0.00
0.00

0.00
0.00
0.00
0.00
0.00
0.00

-9.47
203,005.20
1,821.37
10,400.00
0.00
0.00

0.00
50.66
30.36
65.00
0.00
0.00

R60 Sub Totals:

422,700.00

1,052.34

207,482.90

215,217.10

0.00

215,217.10

50.91

Revenue Sub Totals:

422,700.00

1,052.34

207,482.90

215,217.10

0.00

215,217.10

50.91

Dept 140 Sub Totals:
Recreation Charges
Charges-Recreation
Railroad Days Festival Revenue
Veterans Day Parade Revenue
Spring Festival Revenue
Pool Admissions
Pool Lessons
Pool Passes
Pool Rentals & Lease Payments
Campground Rentals & Lease
City Park Building Rental
City Park Building Deposits
July 4 Festival Revenue
Santa Train Rides Revenue

-422,700.00

-1,052.34

-207,482.90

-215,217.10

0.00

14,000.00
1,400.00
0.00
22,000.00
6,000.00
15,000.00
6,000.00
56,200.00
7,000.00
0.00
0.00
0.00

3,397.57
0.00
225.00
0.00
0.00
0.00
0.00
9,100.00
1,110.00
0.00
0.00
0.00

23,099.01
345.00
225.00
19,903.20
-375.00
880.00
-300.00
31,850.00
6,790.00
0.00
0.00
16,732.73

-9,099.01
1,055.00
-225.00
2,096.80
6,375.00
14,120.00
6,300.00
24,350.00
210.00
0.00
0.00
-16,732.73

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

-9,099.01
1,055.00
-225.00
2,096.80
6,375.00
14,120.00
6,300.00
24,350.00
210.00
0.00
0.00
-16,732.73

0.00
75.36
0.00
9.53
106.25
94.13
105.00
43.33
3.00
0.00
0.00
0.00

R50 Sub Totals:

127,600.00

13,832.57

99,149.94

28,450.06

0.00

28,450.06

22.30

Revenue Sub Totals:

127,600.00

13,832.57

99,149.94

28,450.06

0.00

28,450.06

22.30

Dept 150 Sub Totals:
Fines & Forfeitures
Fines & Forfeitures
Property Abatements
Civil Citations
Confiscations
Parking Fines
Restitution

-127,600.00

-13,832.57

-99,149.94

-28,450.06

0.00

5,000.00
5,000.00
0.00
700.00
0.00

0.00
150.00
0.00
20.00
0.00

5,156.29
5,200.00
0.00
135.00
0.00

-156.29
-200.00
0.00
565.00
0.00

0.00
0.00
0.00
0.00
0.00

-156.29
-200.00
0.00
565.00
0.00

0.00
0.00
0.00
80.71
0.00

10,700.00

170.00

10,491.29

208.71

0.00

208.71

1.95

R70 Sub Totals:

GL-Budget Status (2/6/2024 - 2:27 PM)

Page 5

Page 35 of 60

Account Number

Dept
10-170
R81
10-170-06-4620
10-170-06-4621

Dept
10-171
R82
10-171-06-4630
10-171-06-4631
10-171-06-4632

Dept
10-172
R83
10-172-06-4709

Dept
10-173
R80
10-173-06-4650
10-173-06-4651

GL-Budget Status (2/6/2024 - 2:27 PM)

Description

Budget Amount

Period Amount

YTD Amount

YTD Var

Encumbered Amount

Available

% Available

Revenue Sub Totals:

10,700.00

170.00

10,491.29

208.71

0.00

208.71

1.95

Dept 160 Sub Totals:
Investment Earnings
Investment Earnings
Interest-Investment
Interest-Bank

-10,700.00

-170.00

-10,491.29

-208.71

0.00

3,000.00
0.00

0.00
0.00

10,169.52
0.00

-7,169.52
0.00

0.00
0.00

-7,169.52
0.00

0.00
0.00

R81 Sub Totals:

3,000.00

0.00

10,169.52

-7,169.52

0.00

-7,169.52

0.00

Revenue Sub Totals:

3,000.00

0.00

10,169.52

-7,169.52

0.00

-7,169.52

0.00

Dept 170 Sub Totals:
Rents & Concessions
Rental Income
Rental Income
Rental Income-102 W Potomac St
Rental Income-610 9th Avenue

-3,000.00

0.00

-10,169.52

7,169.52

0.00

3,300.00
62,800.00
0.00

0.00
5,189.75
26,313.68

1,650.00
46,090.44
100,951.68

1,650.00
16,709.56
-100,951.68

0.00
0.00
0.00

1,650.00
16,709.56
-100,951.68

50.00
26.61
0.00

R82 Sub Totals:

66,100.00

31,503.43

148,692.12

-82,592.12

0.00

-82,592.12

0.00

Revenue Sub Totals:

66,100.00

31,503.43

148,692.12

-82,592.12

0.00

-82,592.12

0.00

Dept 171 Sub Totals:
Contributions & Donations
Contributions-Non-Govt
Misc.Grants/Donations-Non-Govt

-66,100.00

-31,503.43

-148,692.12

82,592.12

0.00

500.00

0.00

5,000.00

-4,500.00

0.00

-4,500.00

0.00

R83 Sub Totals:

500.00

0.00

5,000.00

-4,500.00

0.00

-4,500.00

0.00

Revenue Sub Totals:

500.00

0.00

5,000.00

-4,500.00

0.00

-4,500.00

0.00

Dept 172 Sub Totals:
Sales of Property
Miscellaneous Revenues
Sale of Vehicle/Equipment
Sale of Lots/Land

-500.00

0.00

-5,000.00

4,500.00

0.00

35,000.00
0.00

0.00
0.00

3,112.00
0.00

31,888.00
0.00

0.00
0.00

31,888.00
0.00

91.11
0.00

R80 Sub Totals:

35,000.00

0.00

3,112.00

31,888.00

0.00

31,888.00

91.11

Revenue Sub Totals:

35,000.00

0.00

3,112.00

31,888.00

0.00

31,888.00

91.11
Page 6

Page 36 of 60

Account Number

Description

Dept
10-175
R20
10-175-03-4700

R80
10-175-06-4643
10-175-06-4690
10-175-06-4692
10-175-06-4693
10-175-06-4694
10-175-06-4697
10-175-06-4698
10-175-06-4699
10-175-06-4701

R85
10-175-08-5106

Dept
10-190
R86
10-190-07-5000

Dept
10-501
E01
10-501-10-6000
10-501-10-6020
10-501-10-6021
10-501-10-6025

GL-Budget Status (2/6/2024 - 2:27 PM)

Budget Amount

Period Amount

YTD Amount

YTD Var

Encumbered Amount

Available

% Available

Dept 173 Sub Totals:
Other Revenues
Intergovernmental
US Postal Service Reimb

-35,000.00

0.00

-3,112.00

-31,888.00

0.00

18,000.00

0.00

10,414.88

7,585.12

0.00

7,585.12

42.14

R20 Sub Totals:

18,000.00

0.00

10,414.88

Miscellaneous Revenues
Scrap Metal-Public Works
Cash Over/Under
Employee Paid Health Insurance
Refund-Unemployment Insurance
Discounts for Accounts Payable
Refunds & Rebates
Reimbursements
Miscellaneous Revenue
State Retirement Credit

7,585.12

0.00

7,585.12

42.14

500.00
0.00
85,500.00
0.00
0.00
54,500.00
5,000.00
1,000.00
0.00

0.00
0.00
6,984.01
0.00
0.00
0.00
0.00
552.15
0.00

2,353.82
0.00
53,534.99
0.00
0.00
0.00
1,999.08
35,979.11
0.00

-1,853.82
0.00
31,965.01
0.00
0.00
54,500.00
3,000.92
-34,979.11
0.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

-1,853.82
0.00
31,965.01
0.00
0.00
54,500.00
3,000.92
-34,979.11
0.00

0.00
0.00
37.39
0.00
0.00
100.00
60.02
0.00
0.00

R80 Sub Totals:

146,500.00

7,536.16

93,867.00

52,633.00

0.00

52,633.00

35.93

Interfund Transfers
Budgeted Use of Reserves

0.00

R85 Sub Totals:

0.00

Revenue Sub Totals:

164,500.00

7,536.16

104,281.88

60,218.12

0.00

60,218.12

36.61

Dept 175 Sub Totals:
Long-term Debt Proceeds
Other Sources
Proceeds from New Debt

-164,500.00

-7,536.16

-104,281.88

-60,218.12

0.00

1,789,000.00 -1,789,000.00

0.00

-1,789,000.00

0.00

R86 Sub Totals:

0.00

1,789,000.00 -1,789,000.00

0.00

-1,789,000.00

0.00

Revenue Sub Totals:

0.00

1,789,000.00 -1,789,000.00

0.00

-1,789,000.00

0.00

Dept 190 Sub Totals:
Mayor & Council
Personnel Costs
Salaries
Social Security
Medicare
Pension Expense

0.00

-1,789,000.00

1,789,000.00

0.00

31,200.00
2,000.00
500.00
4,700.00

2,600.00
161.20
37.70
0.00

18,200.00
1,128.40
263.90
4,055.84

13,000.00
871.60
236.10
644.16

0.00
0.00
0.00
0.00

13,000.00
871.60
236.10
644.16

41.67
43.58
47.22
13.71

Page 7

Page 37 of 60

Account Number

Description

10-501-10-6030

Workers Compensation

E10
10-501-10-6101
10-501-10-6104
10-501-10-6109
10-501-10-6112
10-501-10-6114
10-501-10-6120
10-501-10-6121
10-501-10-6122
10-501-10-6125
10-501-10-6132
10-501-10-6133
10-501-10-6137
10-501-10-6138
10-501-10-6143
10-501-10-6300
10-501-10-6301
10-501-10-6603
10-501-10-6805
10-501-10-6806
10-501-10-6813
10-501-10-6814
10-501-10-6815
10-501-10-6816
10-501-10-6817
10-501-10-6818
10-501-10-6819
10-501-10-6820
10-501-10-6821
10-501-10-6822
10-501-10-6823
10-501-10-6824
10-501-10-6825
10-501-10-6826
10-501-19-6830

E30
10-501-10-8001

GL-Budget Status (2/6/2024 - 2:27 PM)

Budget Amount

Period Amount

YTD Amount

YTD Var

Encumbered Amount

Available

% Available

400.00

0.00

362.00

38.00

0.00

38.00

9.50

E01 Sub Totals:

38,800.00

2,798.90

24,010.14

14,789.86

0.00

14,789.86

38.12

Operating Expenses
Legal Fees
Consultant Fees
Dues & Subscriptions
Annual Service Contracts
Insurance-Liability,Auto,Prop.
Office Supplies
Operating Expense
Wireless Phones & Data
Postage
Training & Seminars
Travel & Meals
Senior Center Vehicle Fuel
Water Utility Expense
Employee Awards
Information Technology
IT Network Admin Consultant
Cleaning Services
Election Judges
Christmas Lights Contest
Civic Contrib&Comm Youth Progr
Youth Advisory Council
Senior Center
Heritage Museum
Beacon(Food Bank)
Annex Operating Expenses
Brunswcl PreservationCommittee
Distinguished Citizens Award
Park Heights Cemetery
102 W Potomac OperatingExpense
History Commission
610 9th Avenue Operating Exp
9 S Maple Avenue Operating Exp
214 13th Ave Operating Expense
Museum Revitalization-ARPA

0.00
0.00
8,000.00
0.00
20,000.00
200.00
3,000.00
0.00
0.00
6,000.00
0.00
100.00
14,000.00
3,500.00
2,000.00
2,500.00
7,000.00
6,000.00
800.00
4,500.00
2,500.00
5,000.00
15,000.00
4,000.00
0.00
0.00
3,500.00
3,000.00
15,000.00
4,000.00
0.00
0.00
0.00
0.00

0.00
0.00
0.00
0.00
0.00
0.00
981.98
0.00
0.00
0.00
0.00
0.00
0.00
3,187.45
0.00
152.78
500.00
0.00
0.00
1,250.00
0.00
472.21
0.00
0.00
700.00
0.00
0.00
0.00
371.95
0.00
1,291.05
0.00
0.00
0.00

0.00
0.00
7,479.24
12.01
11,607.00
0.00
2,914.52
0.00
0.00
7,744.59
0.00
0.00
13,732.46
3,187.45
3.64
1,551.26
3,500.00
0.00
1,200.00
4,200.00
0.00
3,014.25
7,500.00
4,000.00
3,955.58
0.00
2,931.65
3,000.00
16,118.17
2,098.21
14,655.70
121.72
11.77
166,502.78

0.00
0.00
520.76
-12.01
8,393.00
200.00
85.48
0.00
0.00
-1,744.59
0.00
100.00
267.54
312.55
1,996.36
948.74
3,500.00
6,000.00
-400.00
300.00
2,500.00
1,985.75
7,500.00
0.00
-3,955.58
0.00
568.35
0.00
-1,118.17
1,901.79
-14,655.70
-121.72
-11.77
-166,502.78

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
353,414.00

0.00
0.00
6.51
0.00
41.97
100.00
2.85
0.00
0.00
0.00
0.00
100.00
1.91
8.93
99.82
37.95
50.00
100.00
0.00
6.67
100.00
39.72
50.00
0.00
0.00
0.00
16.24
0.00
0.00
47.54
0.00
0.00
0.00
0.00

E10 Sub Totals:

129,600.00

8,907.42

281,042.00

-151,442.00

353,414.00

-504,856.00

0.00

Project Outlays
Project Outlay

0.00

Page 8

Page 38 of 60

Account Number

Description

Budget Amount

Period Amount

YTD Amount

YTD Var

Encumbered Amount

Available

% Available

0.00

Expense Sub Totals:

168,400.00

11,706.32

305,052.14

-136,652.14

353,414.00

-490,066.14

0.00

Dept 501 Sub Totals:
Finance & Administration
Personnel Costs
Salaries
Salaries Overtime-Regular
Salaries-Holiday Salaried
Salaries Transferred In
Salaries Transferred Out
Social Security
Medicare
Health,Dental,&Vision Premiums
Fringe Benefits Transferred In
Fringe Benefits Transfered Out
Pension Expense
Life Insurance-ER Paid
Workers Compensation
Post Employment Charges
Accrued Leave

168,400.00

11,706.32

305,052.14

-136,652.14

353,414.00

595,300.00
0.00
0.00
0.00
0.00
37,000.00
8,700.00
66,600.00
0.00
0.00
57,900.00
400.00
2,100.00
0.00
0.00

46,448.08
4.90
0.00
0.00
0.00
2,828.28
661.49
7,122.12
0.00
0.00
0.00
64.71
0.00
0.00
0.00

326,529.65
1,443.65
0.00
0.00
0.00
20,002.85
4,678.18
52,263.59
0.00
0.00
40,716.68
221.47
1,915.00
0.00
0.00

268,770.35
-1,443.65
0.00
0.00
0.00
16,997.15
4,021.82
14,336.41
0.00
0.00
17,183.32
178.53
185.00
0.00
0.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

268,770.35
-1,443.65
0.00
0.00
0.00
16,997.15
4,021.82
14,336.41
0.00
0.00
17,183.32
178.53
185.00
0.00
0.00

45.15
0.00
0.00
0.00
0.00
45.94
46.23
21.53
0.00
0.00
29.68
44.63
8.81
0.00
0.00

E01 Sub Totals:

768,000.00

57,129.58

447,771.07

320,228.93

0.00

320,228.93

41.70

Operating Expenses
Advertising & Printing
Legal Fees
Bank Service Fees
Consultant Fees
Payroll Service
Granicus Maintenance Fees
Dues & Subscriptions
Annual Service Contracts
Insurance-Liability,Auto,Prop.
Office Supplies
Operating Expense
Wireless Phones & Data
Physical Exams & Drug Testing
Postage
Postage Meter Rent
Safety Program
Telephones & Internet

3,500.00
30,000.00
50,000.00
1,000.00
15,000.00
11,000.00
4,500.00
50,000.00
4,500.00
15,000.00
15,000.00
0.00
500.00
3,000.00
0.00
500.00
10,000.00

89.71
1,053.00
14.00
0.00
3,846.51
968.78
580.08
522.87
0.00
1,088.35
0.00
0.00
0.00
0.00
0.00
0.00
646.98

1,350.71
25,566.00
24,072.06
160.00
29,335.66
6,753.17
3,831.56
40,709.72
4,972.33
4,994.37
7,274.51
251.71
272.50
100.75
0.00
0.00
7,201.05

2,149.29
4,434.00
25,927.94
840.00
-14,335.66
4,246.83
668.44
9,290.28
-472.33
10,005.63
7,725.49
-251.71
227.50
2,899.25
0.00
500.00
2,798.95

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
1,574.87
4,848.18
0.00
0.00
0.00
0.00
0.00
0.00

2,149.29
4,434.00
25,927.94
840.00
-14,335.66
4,246.83
668.44
9,290.28
-472.33
8,430.76
2,877.31
-251.71
227.50
2,899.25
0.00
500.00
2,798.95

61.41
14.78
51.86
84.00
0.00
38.61
14.85
18.58
0.00
56.21
19.18
0.00
45.50
96.64
0.00
100.00
27.99

E30 Sub Totals:

Dept
10-504
E01
10-504-10-6000
10-504-10-6001
10-504-10-6015
10-504-10-6016
10-504-10-6017
10-504-10-6020
10-504-10-6021
10-504-10-6022
10-504-10-6023
10-504-10-6024
10-504-10-6025
10-504-10-6026
10-504-10-6030
10-504-10-6031
10-504-10-6050

E10
10-504-10-6100
10-504-10-6101
10-504-10-6103
10-504-10-6104
10-504-10-6105
10-504-10-6106
10-504-10-6109
10-504-10-6112
10-504-10-6114
10-504-10-6120
10-504-10-6121
10-504-10-6122
10-504-10-6124
10-504-10-6125
10-504-10-6126
10-504-10-6129
10-504-10-6130
GL-Budget Status (2/6/2024 - 2:27 PM)

Page 9

Page 39 of 60

Account Number

Description

10-504-10-6132
10-504-10-6133
10-504-10-6134
10-504-10-6136
10-504-10-6137
10-504-10-6138
10-504-10-6139
10-504-10-6142
10-504-10-6300
10-504-10-6301
10-504-10-6416
10-504-10-6417
10-504-10-6418
10-504-10-6425
10-504-10-6603

E30
10-504-10-8001

Dept
10-507
E01
10-507-10-6000
10-507-10-6001
10-507-10-6020
10-507-10-6021
10-507-10-6022
10-507-10-6025
10-507-10-6026
10-507-10-6028
10-507-10-6030
10-507-10-6031
10-507-10-6050

Budget Amount

Period Amount

YTD Amount

YTD Var

Encumbered Amount

Available

% Available

Training & Seminars
Travel & Meals
Tuition Reimbursement
Utilities
Vehicle Fuel
Water Utility Expense
Contract Labor
Audits & Bookkeeping
Information Technology
IT Network Admin Consultant
Maint. & Repair-Equipment
Maint. & Repair-Vehicles
Maint. & Repair-Building
2018 FEMA Flooding
Cleaning Services

4,000.00
0.00
0.00
8,000.00
0.00
2,000.00
25,000.00
40,000.00
15,000.00
27,000.00
0.00
0.00
5,000.00
0.00
11,500.00

280.00
0.00
0.00
0.00
126.36
0.00
0.00
0.00
200.00
2,444.42
0.00
0.00
553.00
0.00
850.00

6,004.47
812.65
0.00
2,191.01
667.46
246.78
0.00
41,275.00
1,753.79
18,878.48
0.00
0.00
4,122.02
0.00
5,950.00

-2,004.47
-812.65
0.00
5,808.99
-667.46
1,753.22
25,000.00
-1,275.00
13,246.21
8,121.52
0.00
0.00
877.98
0.00
5,550.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
1,081.60
0.00
0.00

-2,004.47
-812.65
0.00
5,808.99
-667.46
1,753.22
25,000.00
-1,275.00
13,246.21
8,121.52
0.00
0.00
-203.62
0.00
5,550.00

0.00
0.00
0.00
72.61
0.00
87.66
100.00
0.00
88.31
30.08
0.00
0.00
0.00
0.00
48.26

E10 Sub Totals:

351,000.00

13,264.06

238,747.76

112,252.24

7,504.65

104,747.59

29.84

Project Outlays
Project Outlay

0.00

350.00

-350.00

0.00

-350.00

0.00

E30 Sub Totals:

0.00

350.00

-350.00

0.00

-350.00

0.00

Expense Sub Totals:

1,119,000.00

70,393.64

686,868.83

432,131.17

7,504.65

424,626.52

37.95

Dept 504 Sub Totals:
Planning & Zoning
Personnel Costs
Salaries
Salaries Overtime-Regular
Social Security
Medicare
Health,Dental,&Vision Premiums
Pension Expense
Life Insurance-ER Paid
Clothing & Shoe Allowance
Workers Compensation
Post Employment Charges
Accrued Leave

1,119,000.00

70,393.64

686,868.83

432,131.17

7,504.65

306,000.00
0.00
19,000.00
4,500.00
105,000.00
35,400.00
250.00
400.00
5,700.00
0.00
0.00

23,644.81
0.00
1,420.48
332.18
8,727.27
0.00
35.04
0.00
0.00
0.00
0.00

175,216.14
0.00
10,566.59
2,471.09
61,101.14
32,038.92
122.64
717.80
4,995.00
0.00
0.00

130,783.86
0.00
8,433.41
2,028.91
43,898.86
3,361.08
127.36
-317.80
705.00
0.00
0.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

130,783.86
0.00
8,433.41
2,028.91
43,898.86
3,361.08
127.36
-317.80
705.00
0.00
0.00

42.74
0.00
44.39
45.09
41.81
9.49
50.94
0.00
12.37
0.00
0.00

476,250.00

34,159.78

287,229.32

189,020.68

0.00

189,020.68

39.69

1,000.00
0.00

0.00
0.00

1,000.00
0.00

0.00
0.00

1,000.00
0.00

100.00
0.00

E01 Sub Totals:
E10
10-507-10-6100
10-507-10-6101
GL-Budget Status (2/6/2024 - 2:27 PM)

Operating Expenses
Advertising & Printing
Legal Fees

Page 10

Page 40 of 60

Account Number

Description

10-507-10-6104
10-507-10-6109
10-507-10-6112
10-507-10-6114
10-507-10-6120
10-507-10-6121
10-507-10-6122
10-507-10-6124
10-507-10-6125
10-507-10-6129
10-507-10-6130
10-507-10-6132
10-507-10-6133
10-507-10-6135
10-507-10-6136
10-507-10-6137
10-507-10-6138
10-507-10-6300
10-507-10-6301
10-507-10-6416
10-507-10-6417
10-507-10-6418
10-507-10-6425
10-507-10-6603
10-507-10-6870

E30
10-507-10-8001

Dept
10-520
E01
10-520-11-6000
10-520-11-6001
10-520-11-6002
10-520-11-6003
10-520-11-6004
10-520-11-6006
GL-Budget Status (2/6/2024 - 2:27 PM)

Budget Amount

Period Amount

YTD Amount

YTD Var

Encumbered Amount

Available

% Available

Consultant Fees
Dues & Subscriptions
Annual Service Contracts
Insurance-Liability,Auto,Prop.
Office Supplies
Operating Expense
Wireless Phones & Data
Physical Exams & Drug Testing
Postage
Safety Program
Telephones & Internet
Training & Seminars
Travel & Meals
Uniforms
Utilities
Vehicle Fuel
Water Utility Expense
Information Technology
IT Network Admin Consultant
Maint. & Repair-Equipment
Maint. & Repair-Vehicles
Maint. & Repair-Building
2018 FEMA Flooding
Cleaning Services
Board of Appeals Honoraria

10,000.00
1,000.00
5,000.00
1,100.00
11,000.00
1,000.00
3,000.00
300.00
0.00
200.00
2,500.00
2,000.00
150.00
2,100.00
7,000.00
500.00
2,500.00
5,000.00
4,000.00
0.00
0.00
0.00
0.00
4,200.00
0.00

0.00
0.00
0.00
0.00
312.62
0.00
251.39
0.00
0.00
0.00
273.87
0.00
0.00
9.36
0.00
0.00
0.00
0.00
611.10
0.00
0.00
0.00
0.00
280.00
0.00

3,718.49
362.49
1,168.45
4,884.80
3,840.19
2,400.00
2,041.15
76.00
0.00
0.00
2,070.49
0.00
0.00
829.85
4,392.44
44.43
797.14
0.00
3,877.12
0.00
0.00
13,604.00
0.00
2,800.00
165.00

6,281.51
637.51
3,831.55
-3,784.80
7,159.81
-1,400.00
958.85
224.00
0.00
200.00
429.51
2,000.00
150.00
1,270.15
2,607.56
455.57
1,702.86
5,000.00
122.88
0.00
0.00
-13,604.00
0.00
1,400.00
-165.00

6,000.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

281.51
637.51
3,831.55
-3,784.80
7,159.81
-1,400.00
958.85
224.00
0.00
200.00
429.51
2,000.00
150.00
1,270.15
2,607.56
455.57
1,702.86
5,000.00
122.88
0.00
0.00
-13,604.00
0.00
1,400.00
-165.00

2.82
63.75
76.63
0.00
65.09
0.00
31.96
74.67
0.00
100.00
17.18
100.00
100.00
60.48
37.25
91.11
68.11
100.00
3.07
0.00
0.00
0.00
0.00
33.33
0.00

E10 Sub Totals:

63,550.00

1,738.34

47,072.04

16,477.96

6,000.00

10,477.96

16.49

Project Outlays
Project Outlay

0.00

E30 Sub Totals:

0.00

Expense Sub Totals:

539,800.00

35,898.12

334,301.36

205,498.64

6,000.00

199,498.64

36.96

Dept 507 Sub Totals:
Police Department
Personnel Costs
Salaries
Salaries Overtime-Regular
Salaries Overtime-Court
Salaries Overtime-Grant
Salaries Overtime-Event
Salaries Shift Differential

539,800.00

35,898.12

334,301.36

205,498.64

6,000.00

1,503,800.00
10,000.00
8,000.00
12,000.00
0.00
10,400.00

107,632.90
270.71
307.26
423.05
0.00
635.63

770,422.96
1,766.63
3,693.45
8,781.04
0.00
4,830.29

733,377.04
8,233.37
4,306.55
3,218.96
0.00
5,569.71

0.00
0.00
0.00
0.00
0.00
0.00

733,377.04
8,233.37
4,306.55
3,218.96
0.00
5,569.71

48.77
82.33
53.83
26.82
0.00
53.55
Page 11

Page 41 of 60

Account Number

Description

10-520-11-6014
10-520-11-6016
10-520-11-6017
10-520-11-6018
10-520-11-6020
10-520-11-6021
10-520-11-6022
10-520-11-6025
10-520-11-6026
10-520-11-6028
10-520-11-6030
10-520-11-6031
10-520-11-6050
10-520-11-6055

Salaries-Holiday Premium
Salaries Transferred In
Salaries Transferred Out
Salaries- K-9
Social Security
Medicare
Health,Dental,&Vision Premiums
Pension Expense
Life Insurance-ER Paid
Clothing & Shoe Allowance
Workers Compensation
Post Employment Charges
Accrued Leave
EmployeeTuition Reimbursement
E01 Sub Totals:

E10
10-520-11-6100
10-520-11-6101
10-520-11-6104
10-520-11-6109
10-520-11-6112
10-520-11-6114
10-520-11-6120
10-520-11-6121
10-520-11-6122
10-520-11-6123
10-520-11-6124
10-520-11-6129
10-520-11-6130
10-520-11-6131
10-520-11-6132
10-520-11-6135
10-520-11-6136
10-520-11-6137
10-520-11-6138
10-520-11-6139
10-520-11-6300
10-520-11-6301
10-520-11-6416
10-520-11-6417
10-520-11-6418
10-520-11-6503
GL-Budget Status (2/6/2024 - 2:27 PM)

Operating Expenses
Advertising & Printing
Legal Fees
Consultant Fees
Dues & Subscriptions
Annual Service Contracts
Insurance-Liability,Auto,Prop.
Office Supplies
Operating Expense
Wireless Phones & Data
Parts & Supplies
Physical Exams & Drug Testing
Safety Program
Telephones & Internet
Tools & Small Equipment
Training & Seminars
Uniforms
Utilities
Vehicle Fuel
Water Utility Expense
Contract Labor
Information Technology
IT Network Admin Consultant
Maint. & Repair-Equipment
Maint. & Repair-Vehicles
Maint. & Repair-Building
IIT Fees - Frederick County

Budget Amount

Period Amount

YTD Amount

YTD Var

Encumbered Amount

Available

% Available

31,800.00
0.00
0.00
0.00
93,300.00
21,900.00
311,000.00
173,500.00
1,100.00
13,500.00
137,900.00
0.00
0.00
1,000.00

7,696.44
0.00
0.00
0.00
7,137.30
1,669.20
23,827.93
0.00
140.16
0.00
0.00
0.00
0.00
500.00

20,007.59
0.00
0.00
0.00
49,406.43
11,554.64
164,278.58
162,115.18
475.81
11,250.00
113,146.00
0.00
0.00
1,000.00

11,792.41
0.00
0.00
0.00
43,893.57
10,345.36
146,721.42
11,384.82
624.19
2,250.00
24,754.00
0.00
0.00
0.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

11,792.41
0.00
0.00
0.00
43,893.57
10,345.36
146,721.42
11,384.82
624.19
2,250.00
24,754.00
0.00
0.00
0.00

37.08
0.00
0.00
0.00
47.05
47.24
47.18
6.56
56.74
16.67
17.95
0.00
0.00
0.00

2,329,200.00

150,240.58

1,322,728.60

1,006,471.40

0.00

1,006,471.40

43.21

1,000.00
0.00
12,000.00
2,500.00
5,000.00
30,000.00
1,500.00
1,100.00
11,000.00
0.00
3,000.00
2,000.00
14,000.00
24,500.00
9,000.00
7,000.00
30,000.00
56,000.00
5,000.00
0.00
1,000.00
2,600.00
1,300.00
0.00
0.00
35,000.00

0.00
0.00
0.00
0.00
0.00
0.00
64.24
0.00
900.61
0.00
422.50
173.80
783.58
471.30
-495.00
252.00
0.00
3,414.49
0.00
0.00
0.00
152.78
495.00
0.00
0.00
0.00

0.00
0.00
11,762.39
560.00
563.07
38,270.60
1,374.95
683.15
7,767.51
0.00
3,224.50
564.76
7,679.98
2,701.49
3,002.44
940.56
8,702.23
27,012.61
1,636.57
0.00
4,472.70
2,830.74
1,155.00
1,800.30
7.38
35,182.00

1,000.00
0.00
237.61
1,940.00
4,436.93
-8,270.60
125.05
416.85
3,232.49
0.00
-224.50
1,435.24
6,320.02
21,798.51
5,997.56
6,059.44
21,297.77
28,987.39
3,363.43
0.00
-3,472.70
-230.74
145.00
-1,800.30
-7.38
-182.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
60.01
0.00
0.00
0.00
0.00

100.00
0.00
1.98
77.60
88.74
0.00
8.34
37.90
29.39
0.00
0.00
71.76
45.14
88.97
66.64
86.56
70.99
51.76
67.27
0.00
0.00
0.00
11.15
0.00
0.00
0.00
Page 12

Page 42 of 60

Account Number

Description

10-520-11-6540
10-520-11-6542
10-520-11-6544
10-520-11-6545
10-520-11-6546
10-520-11-6603
10-520-19-6200

E30
10-520-11-8001

Dept
10-521
E10
10-521-11-6138
10-521-11-6570
10-521-11-6571

Dept
10-530
E01
10-530-12-6000
10-530-12-6001
10-530-12-6004
10-530-12-6005
10-530-12-6014
10-530-12-6016
10-530-12-6020
10-530-12-6021
10-530-12-6022
10-530-12-6023
10-530-12-6024
10-530-12-6025

GL-Budget Status (2/6/2024 - 2:27 PM)

Budget Amount

Period Amount

YTD Amount

YTD Var

Encumbered Amount

Available

% Available

Investigations
K9 Expense
Safety Equipment & Firearms
Bullet Proof Vests
Less Lethal Equipment
Cleaning Services
Operating Grant Expenses

1,000.00
9,100.00
10,000.00
3,500.00
9,000.00
8,400.00
0.00

8.56
501.20
0.00
1,018.00
0.00
560.00
1,476.00

18.96
5,115.47
1,370.43
1,018.00
8,260.55
4,200.00
12,861.96

981.04
3,984.53
8,629.57
2,482.00
739.45
4,200.00
-12,861.96

0.00
0.00
7,217.80
0.00
0.00
0.00
525.76

981.04
3,984.53
1,411.77
2,482.00
739.45
4,200.00
-13,387.72

98.10
43.79
14.12
70.91
8.22
50.00
0.00

E10 Sub Totals:

295,500.00

10,199.06

194,740.30

100,759.70

7,803.57

92,956.13

31.46

Project Outlays
Project Outlay

0.00

37.04

-37.04

0.00

-37.04

0.00

E30 Sub Totals:

0.00

37.04

-37.04

0.00

-37.04

0.00

Expense Sub Totals:

2,624,700.00

160,439.64

1,517,505.94

1,107,194.06

7,803.57

1,099,390.49

41.89

Dept 520 Sub Totals:
Fire & Rescue Service
Operating Expenses
Water Utility Expense
Ambulance Company Contribution
Fire Company Contribution

2,624,700.00

160,439.64

1,517,505.94

1,107,194.06

7,803.57

15,000.00
15,000.00
15,000.00

0.00
0.00
0.00

4,336.64
0.00
0.00

10,663.36
15,000.00
15,000.00

0.00
0.00
0.00

10,663.36
15,000.00
15,000.00

71.09
100.00
100.00

E10 Sub Totals:

45,000.00

0.00

4,336.64

40,663.36

0.00

40,663.36

90.36

Expense Sub Totals:

45,000.00

0.00

4,336.64

40,663.36

0.00

40,663.36

90.36

Dept 521 Sub Totals:
Public Works
Personnel Costs
Salaries
Salaries Overtime-Regular
Salaries Overtime-Event
Salaries Overtime-Snow Removal
Salaries-Holiday Premium
Salaries Transferred In
Social Security
Medicare
Health,Dental,&Vision Premiums
Fringe Benefits Transferred In
Fringe Benefits Transfered Out
Pension Expense

45,000.00

0.00

4,336.64

40,663.36

0.00

1,003,200.00
4,000.00
0.00
9,000.00
0.00
0.00
62,200.00
14,600.00
345,500.00
0.00
0.00
132,600.00

84,012.60
268.07
0.00
5,611.85
0.00
0.00
5,401.19
1,263.20
34,420.86
0.00
0.00
0.00

628,004.48
6,870.23
0.00
5,611.85
0.00
0.00
39,287.10
9,188.10
244,461.17
0.00
0.00
123,105.52

375,195.52
-2,870.23
0.00
3,388.15
0.00
0.00
22,912.90
5,411.90
101,038.83
0.00
0.00
9,494.48

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

375,195.52
-2,870.23
0.00
3,388.15
0.00
0.00
22,912.90
5,411.90
101,038.83
0.00
0.00
9,494.48

37.40
0.00
0.00
37.65
0.00
0.00
36.84
37.07
29.24
0.00
0.00
7.16

Page 13

Page 43 of 60

Account Number

Description

10-530-12-6026
10-530-12-6028
10-530-12-6030
10-530-12-6031
10-530-12-6050

Life Insurance-ER Paid
Clothing & Shoe Allowance
Workers Compensation
Post Employment Charges
Accrued Leave
E01 Sub Totals:

E10
10-530-12-6100
10-530-12-6101
10-530-12-6102
10-530-12-6104
10-530-12-6109
10-530-12-6112
10-530-12-6114
10-530-12-6120
10-530-12-6121
10-530-12-6122
10-530-12-6123
10-530-12-6124
10-530-12-6125
10-530-12-6129
10-530-12-6130
10-530-12-6131
10-530-12-6132
10-530-12-6135
10-530-12-6136
10-530-12-6137
10-530-12-6138
10-530-12-6144
10-530-12-6145
10-530-12-6300
10-530-12-6301
10-530-12-6416
10-530-12-6417
10-530-12-6418
10-530-12-6420
10-530-12-6421
10-530-12-6425
10-530-12-6602
10-530-12-6603
10-530-12-6605
10-530-12-6606
GL-Budget Status (2/6/2024 - 2:27 PM)

Operating Expenses
Advertising & Printing
Legal Fees
Cleaning Supplies
Consultant Fees
Dues & Subscriptions
Annual Service Contracts
Insurance-Liability,Auto,Prop.
Office Supplies
Operating Expense
Wireless Phones & Data
Parts & Supplies
Physical Exams & Drug Testing
Postage
Safety Program
Telephones & Internet
Tools & Small Equipment
Training & Seminars
Uniforms
Utilities
Vehicle Fuel
Water Utility Expense
Equipment Rentals
Bathroom Trailer Oper Expenses
Information Technology
IT Network Admin Consultant
Maint. & Repair-Equipment
Maint. & Repair-Vehicles
Maint. & Repair-Building
Maint. & Repair-Infrastructure
Ground & Landscaping
2018 FEMA Flooding
Christmas Lights
Cleaning Service - Contracted
Street Sweeping - Contracted
Parking Meter Maintenance

Budget Amount

Period Amount

YTD Amount

YTD Var

Encumbered Amount

Available

% Available

900.00
1,700.00
87,200.00
0.00
0.00

162.06
0.00
0.00
0.00
0.00

574.23
13,916.09
80,952.00
275.26
0.00

325.77
-12,216.09
6,248.00
-275.26
0.00

0.00
0.00
0.00
0.00
0.00

325.77
-12,216.09
6,248.00
-275.26
0.00

36.20
0.00
7.17
0.00
0.00

1,660,900.00

131,139.83

1,152,246.03

508,653.97

0.00

508,653.97

30.63

1,300.00
0.00
2,000.00
0.00
100.00
6,400.00
21,000.00
3,000.00
1,500.00
15,000.00
8,500.00
2,000.00
200.00
3,000.00
5,000.00
50,000.00
18,500.00
16,000.00
30,000.00
50,000.00
5,000.00
9,500.00
1,000.00
4,400.00
4,900.00
15,000.00
30,000.00
40,000.00
40,000.00
30,000.00
0.00
1,200.00
10,000.00
0.00
35,000.00

0.00
0.00
64.20
0.00
0.00
18.72
500.00
135.33
0.00
1,057.65
40.66
0.00
0.00
79.96
391.14
0.00
254.55
0.00
0.00
4,534.98
0.00
0.00
0.00
0.00
916.66
777.27
4,782.67
0.00
1,274.04
0.00
0.00
0.00
560.00
0.00
710.25

0.00
0.00
1,156.28
0.00
198.60
2,484.91
26,358.60
1,795.80
2,380.14
8,706.25
4,189.60
1,067.50
0.00
2,526.88
5,051.57
20,178.86
2,101.59
15,600.90
8,738.66
36,184.20
1,851.51
3,749.77
0.00
3,639.41
5,059.21
8,295.91
21,984.23
13,362.57
1,125.94
8,095.00
0.00
39.58
3,500.00
1,800.00
5,494.75

1,300.00
0.00
843.72
0.00
-98.60
3,915.09
-5,358.60
1,204.20
-880.14
6,293.75
4,310.40
932.50
200.00
473.12
-51.57
29,821.14
16,398.41
399.10
21,261.34
13,815.80
3,148.49
5,750.23
1,000.00
760.59
-159.21
6,704.09
8,015.77
26,637.43
38,874.06
21,905.00
0.00
1,160.42
6,500.00
-1,800.00
29,505.25

0.00
0.00
0.00
0.00
0.00
3,169.88
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
6,313.01
0.00
0.00
0.00
0.00
0.00
0.00
0.00
200.00
0.00
21.66
2,243.80
7,685.92
0.00
0.00
0.00
0.00
0.00
0.00
0.00

1,300.00
0.00
843.72
0.00
-98.60
745.21
-5,358.60
1,204.20
-880.14
6,293.75
4,310.40
932.50
200.00
473.12
-51.57
23,508.13
16,398.41
399.10
21,261.34
13,815.80
3,148.49
5,750.23
1,000.00
560.59
-159.21
6,682.43
5,771.97
18,951.51
38,874.06
21,905.00
0.00
1,160.42
6,500.00
-1,800.00
29,505.25

100.00
0.00
42.19
0.00
0.00
11.64
0.00
40.14
0.00
41.96
50.71
46.63
100.00
15.77
0.00
47.02
88.64
2.49
70.87
27.63
62.97
60.53
100.00
12.74
0.00
44.55
19.24
47.38
97.19
73.02
0.00
96.70
65.00
0.00
84.30
Page 14

Page 44 of 60

Account Number

Description

10-530-12-6607
10-530-12-6608
10-530-12-6609
10-530-12-6610
10-530-12-6611
10-530-12-6612
10-530-12-6650
10-530-12-6651
10-530-19-6200

E30
10-530-12-8001

Dept
10-531
E10
10-531-12-6700
10-531-12-6701
10-531-12-6702

Dept
10-540
E10
10-540-18-6101
10-540-18-6114
10-540-18-6121
10-540-18-6123
10-540-18-6136
10-540-18-6416
10-540-18-6421
10-540-18-6603
10-540-18-6822
10-540-18-7001

GL-Budget Status (2/6/2024 - 2:27 PM)

Budget Amount

Period Amount

YTD Amount

YTD Var

Encumbered Amount

Available

% Available

Road Salt & Cinders
Snow Removal
Street Lights
Street Signs
Tree Removal
Weed Control
Storm Water Mgmt Damage/Repair
Infrastructure Loan Program
Operating Grant Expenses

30,000.00
8,000.00
96,000.00
20,000.00
20,000.00
0.00
15,000.00
0.00
0.00

12,921.47
888.76
257.35
0.00
0.00
0.00
1,915.00
0.00
0.00

20,328.32
1,803.46
56,452.50
1,691.46
7,300.00
0.00
4,141.25
0.00
0.00

9,671.68
6,196.54
39,547.50
18,308.54
12,700.00
0.00
10,858.75
0.00
0.00

369.98
0.00
0.00
0.00
0.00
0.00
1,827.30
0.00
0.00

9,301.70
6,196.54
39,547.50
18,308.54
12,700.00
0.00
9,031.45
0.00
0.00

31.01
77.46
41.20
91.54
63.50
0.00
60.21
0.00
0.00

E10 Sub Totals:

648,500.00

32,080.66

308,435.21

340,064.79

21,831.55

318,233.24

49.07

Project Outlays
Project Outlay

0.00

E30 Sub Totals:

0.00

Expense Sub Totals:

2,309,400.00

163,220.49

1,460,681.24

848,718.76

21,831.55

826,887.21

35.81

Dept 530 Sub Totals:
Waste Collection & Disposal
Operating Expenses
Trash Hauling-Contracted
Recycling\Bulk Trash
Tipping Charges

2,309,400.00

163,220.49

1,460,681.24

848,718.76

21,831.55

276,300.00
50,000.00
222,700.00

33,040.08
4,973.34
1,030.38

199,656.06
39,367.97
126,214.60

76,643.94
10,632.03
96,485.40

0.00
0.00
0.00

76,643.94
10,632.03
96,485.40

27.74
21.26
43.33

E10 Sub Totals:

549,000.00

39,043.80

365,238.63

183,761.37

0.00

183,761.37

33.47

Expense Sub Totals:

549,000.00

39,043.80

365,238.63

183,761.37

0.00

183,761.37

33.47

Dept 531 Sub Totals:
Parks
Operating Expenses
Legal Fees
Insurance-Liability,Auto,Prop.
Operating Expense
Parts & Supplies
Utilities
Maint. & Repair-Equipment
Berlin Cemetery
Cleaning Services
Park & Recreation Committee
Park Renewal

549,000.00

39,043.80

365,238.63

183,761.37

0.00

0.00
3,000.00
500.00
9,000.00
5,000.00
4,000.00
3,000.00
12,000.00
0.00
50,000.00

0.00
0.00
0.00
2,496.66
456.95
0.00
0.00
1,000.00
0.00
0.00

0.00
2,461.00
0.00
11,965.30
6,149.58
975.00
0.00
7,000.00
0.00
11,660.68

0.00
539.00
500.00
-2,965.30
-1,149.58
3,025.00
3,000.00
5,000.00
0.00
38,339.32

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

0.00
539.00
500.00
-2,965.30
-1,149.58
3,025.00
3,000.00
5,000.00
0.00
38,339.32

0.00
17.97
100.00
0.00
0.00
75.63
100.00
41.67
0.00
76.68

Page 15

Page 45 of 60

Account Number

Description

10-540-18-7002
10-540-18-7003

E30
10-540-19-8000

Dept
10-541
E01
10-541-18-6000
10-541-18-6001
10-541-18-6020
10-541-18-6021
10-541-18-6022
10-541-18-6025
10-541-18-6026
10-541-18-6030

E10
10-541-18-6100
10-541-18-6104
10-541-18-6109
10-541-18-6121
10-541-18-6136
10-541-18-7031
10-541-18-7033
10-541-18-7035
10-541-18-7036
10-541-18-7039
10-541-18-7040

E30
10-541-18-8001

GL-Budget Status (2/6/2024 - 2:27 PM)

Budget Amount

Period Amount

YTD Amount

YTD Var

Encumbered Amount

Available

% Available

CityPark Building Improvements
Rivers Edge Trail Project

1,000.00
0.00

0.00
0.00

1,000.00
0.00

0.00
0.00

1,000.00
0.00

100.00
0.00

E10 Sub Totals:

87,500.00

3,953.61

40,211.56

47,288.44

0.00

47,288.44

54.04

Project Outlays
Rivers Edge Trail PhaseII-ARPA

0.00

5,008.00

-5,008.00

0.00

-5,008.00

0.00

E30 Sub Totals:

0.00

5,008.00

-5,008.00

0.00

-5,008.00

0.00

Expense Sub Totals:

87,500.00

3,953.61

45,219.56

42,280.44

0.00

42,280.44

48.32

Dept 540 Sub Totals:
Events
Personnel Costs
Salaries
Salaries Overtime-Regular
Social Security
Medicare
Health,Dental,&Vision Premiums
Pension Expense
Life Insurance-ER Paid
Workers Compensation

87,500.00

3,953.61

45,219.56

42,280.44

0.00

24,600.00
1,000.00
1,600.00
400.00
5,200.00
2,800.00
100.00
100.00

2,195.85
0.00
136.14
31.84
437.65
0.00
3.50
0.00

16,146.55
0.00
999.89
233.85
3,059.06
2,713.94
12.25
52.00

8,453.45
1,000.00
600.11
166.15
2,140.94
86.06
87.75
48.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

8,453.45
1,000.00
600.11
166.15
2,140.94
86.06
87.75
48.00

34.36
100.00
37.51
41.54
41.17
3.07
87.75
48.00

E01 Sub Totals:

35,800.00

2,804.98

23,217.54

12,582.46

0.00

12,582.46

35.15

Operating Expenses
Advertising & Printing
Consultant Fees
Dues & Subscriptions
Operating Expense
Utilities
July 4th Events
Railroad Days Festival
Veterans Day Parade
Volunteers - Events
Miscellaneous Event Expenses
RR Days POS Grant Expenses

0.00
6,000.00
200.00
0.00
0.00
9,000.00
38,000.00
16,000.00
0.00
20,000.00
0.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
22.25
0.00

0.00
4,875.00
154.99
0.00
0.00
9,000.00
55,738.21
15,036.79
0.00
17,491.66
0.00

0.00
1,125.00
45.01
0.00
0.00
0.00
-17,738.21
963.21
0.00
2,508.34
0.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

0.00
1,125.00
45.01
0.00
0.00
0.00
-17,738.21
963.21
0.00
2,508.34
0.00

0.00
18.75
22.51
0.00
0.00
0.00
0.00
6.02
0.00
12.54
0.00

E10 Sub Totals:

89,200.00

22.25

102,296.65

-13,096.65

0.00

-13,096.65

0.00

Project Outlays
Project Outlay

0.00

E30 Sub Totals:

0.00

0.00
Page 16

Page 46 of 60

Account Number

Dept
10-543
E10
10-543-18-6114
10-543-18-6121
10-543-18-6123
10-543-18-6129
10-543-18-6130
10-543-18-6136
10-543-18-6138

Dept
10-545
E10
10-545-18-6114
10-545-18-6121
10-545-18-6123
10-545-18-6129
10-545-18-6130
10-545-18-6136
10-545-18-6301
10-545-18-7071
10-545-19-6200

Dept
10-560
E01
10-560-16-6000
10-560-16-6020
10-560-16-6021
10-560-16-6022
10-560-16-6025
GL-Budget Status (2/6/2024 - 2:27 PM)

Description

Budget Amount

Period Amount

YTD Amount

YTD Var

Encumbered Amount

Available

% Available

Expense Sub Totals:

125,000.00

2,827.23

125,514.19

-514.19

0.00

-514.19

0.00

Dept 541 Sub Totals:
Swimming Pool
Operating Expenses
Insurance-Liability,Auto,Prop.
Operating Expense
Parts & Supplies
Safety Program
Telephones & Internet
Utilities
Water Utility Expense

125,000.00

2,827.23

125,514.19

-514.19

0.00

600.00
90,000.00
1,000.00
0.00
1,000.00
5,000.00
8,000.00

0.00
9.99
0.00
0.00
103.41
0.00
0.00

807.00
49,609.60
358.06
0.00
714.19
2,603.30
8,406.80

-207.00
40,390.40
641.94
0.00
285.81
2,396.70
-406.80

0.00
0.00
0.00
0.00
0.00
0.00
0.00

-207.00
40,390.40
641.94
0.00
285.81
2,396.70
-406.80

0.00
44.88
64.19
0.00
28.58
47.93
0.00

E10 Sub Totals:

105,600.00

113.40

62,498.95

43,101.05

0.00

43,101.05

40.82

Expense Sub Totals:

105,600.00

113.40

62,498.95

43,101.05

0.00

43,101.05

40.82

Dept 543 Sub Totals:
Campground
Operating Expenses
Insurance-Liability,Auto,Prop.
Operating Expense
Parts & Supplies
Safety Program
Telephones & Internet
Utilities
IT Network Admin Consultant
Campground General Maintenance
Operating Grant Expenses

105,600.00

113.40

62,498.95

43,101.05

0.00

800.00
2,000.00
1,500.00
0.00
0.00
14,000.00
700.00
6,000.00
0.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

381.00
632.00
99.99
0.00
0.00
9,323.21
0.00
8,106.12
0.00

419.00
1,368.00
1,400.01
0.00
0.00
4,676.79
700.00
-2,106.12
0.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

419.00
1,368.00
1,400.01
0.00
0.00
4,676.79
700.00
-2,106.12
0.00

52.38
68.40
93.33
0.00
0.00
33.41
100.00
0.00
0.00

E10 Sub Totals:

25,000.00

0.00

18,542.32

6,457.68

0.00

6,457.68

25.83

Expense Sub Totals:

25,000.00

0.00

18,542.32

6,457.68

0.00

6,457.68

25.83

Dept 545 Sub Totals:
Economic Development
Personnel Costs
Salaries
Social Security
Medicare
Health,Dental,&Vision Premiums
Pension Expense

25,000.00

0.00

18,542.32

6,457.68

0.00

18,400.00
1,200.00
300.00
3,500.00
2,100.00

1,400.89
86.86
20.31
0.00
0.00

10,484.77
648.25
151.59
0.00
0.00

7,915.23
551.75
148.41
3,500.00
2,100.00

0.00
0.00
0.00
0.00
0.00

7,915.23
551.75
148.41
3,500.00
2,100.00

43.02
45.98
49.47
100.00
100.00
Page 17

Page 47 of 60

Account Number

Description

10-560-16-6026
10-560-16-6030

Life Insurance-ER Paid
Workers Compensation

E10
10-560-16-6100
10-560-16-6104
10-560-16-6120
10-560-16-6122
10-560-16-6905
10-560-16-6906
10-560-16-6907
10-560-16-6908
10-560-16-6909
10-560-16-6910
10-560-16-7036

E30
10-560-19-6201
10-560-19-6202

Dept
10-562
E01
10-562-16-6000
10-562-16-6020
10-562-16-6021
10-562-16-6022
10-562-16-6025
10-562-16-6026
10-562-16-6030

E10
10-562-10-6818
10-562-10-6822
10-562-16-6100
GL-Budget Status (2/6/2024 - 2:27 PM)

Budget Amount

Period Amount

YTD Amount

YTD Var

Encumbered Amount

Available

% Available

100.00
100.00

2.18
0.00

18.85
0.00

81.15
100.00

0.00
0.00

81.15
100.00

E01 Sub Totals:

25,700.00

1,510.24

11,303.46

14,396.54

0.00

14,396.54

56.02

Operating Expenses
Advertising & Printing
Consultant Fees
Office Supplies
Wireless Phones & Data
Economic Developmnt Commission
Community Legacy Expenditures
Grants Miscellaneous
TRIPP Grant Expenses
CDBG Grant Expenditures
Building Blocks Grant Expenses
Volunteers - Events

5,000.00
0.00
0.00
0.00
1,000.00
0.00
0.00
5,000.00
0.00
100,000.00
0.00

52.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

812.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

4,188.00
0.00
0.00
0.00
1,000.00
0.00
0.00
5,000.00
0.00
100,000.00
0.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

4,188.00
0.00
0.00
0.00
1,000.00
0.00
0.00
5,000.00
0.00
100,000.00
0.00

83.76
0.00
0.00
0.00
100.00
0.00
0.00
100.00
0.00
100.00
0.00

E10 Sub Totals:

111,000.00

52.00

812.00

110,188.00

0.00

110,188.00

99.27

Project Outlays
Smoketown/Cannon Parking-Fence
Smoketown/Cannon Parking-ARPA

81,000.00
0.00

0.00
0.00

73,832.50
10,425.00

7,167.50
-10,425.00

0.00
0.00

7,167.50
-10,425.00

8.85
0.00

E30 Sub Totals:

81,000.00

0.00

84,257.50

-3,257.50

0.00

-3,257.50

0.00

Expense Sub Totals:

217,700.00

1,562.24

96,372.96

121,327.04

0.00

121,327.04

55.73

Dept 560 Sub Totals:

217,700.00

1,562.24

96,372.96

121,327.04

0.00

Personnel Costs
Salaries
Social Security
Medicare
Health,Dental,&Vision Premiums
Pension Expense
Life Insurance-ER Paid
Workers Compensation

70,000.00
4,400.00
1,100.00
31,000.00
8,200.00
100.00
300.00

5,355.21
314.74
73.60
2,576.39
0.00
8.76
0.00

39,446.44
2,316.04
541.61
18,034.82
7,593.30
30.66
233.00

30,553.56
2,083.96
558.39
12,965.18
606.70
69.34
67.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00

30,553.56
2,083.96
558.39
12,965.18
606.70
69.34
67.00

43.65
47.36
50.76
41.82
7.40
69.34
22.33

E01 Sub Totals:

115,100.00

8,328.70

68,195.87

46,904.13

0.00

46,904.13

40.75

5,000.00
0.00
100.00

0.00
0.00
0.00

5,000.00
0.00
100.00

0.00
0.00
0.00

5,000.00
0.00
100.00

100.00
0.00
100.00

Operating Expenses
Main Street Donation
Arts&Entertainment Donation
Advertising & Printing

Page 18

Page 48 of 60

Account Number

Description

10-562-16-6104
10-562-16-6125
10-562-16-7039
10-562-19-6201

Dept
10-570
E40
10-570-50-9000
10-570-50-9001
10-570-50-9002
10-570-50-9003
10-570-50-9004
10-570-50-9005

Dept
10-600
E85
10-600-08-9503
10-600-08-9504

Budget Amount

Period Amount

YTD Amount

YTD Var

Encumbered Amount

Available

% Available

Consultant Fees
Postage
Misc Event Expenses
MainStreet Revitalization-ARPA

0.00
0.00
4,000.00
0.00

0.00
0.00
0.00
0.00

0.00
0.00
0.00
242,734.19

0.00
0.00
4,000.00
-242,734.19

0.00
0.00
0.00
0.00

0.00
0.00
4,000.00
-242,734.19

0.00
0.00
100.00
0.00

E10 Sub Totals:

9,100.00

0.00

242,734.19

-233,634.19

0.00

-233,634.19

0.00

Expense Sub Totals:

124,200.00

8,328.70

310,930.06

-186,730.06

0.00

-186,730.06

0.00

Dept 562 Sub Totals:
Debt Service
Debt Service
Debt Service
Debt Service-City Hall
Debt Service-Police
Debt Service-Public Works
Debt Service-Infrastructure
Debt Service-Planning & Zoning

124,200.00

8,328.70

310,930.06

-186,730.06

0.00

0.00
40,000.00
60,000.00
170,000.00
85,000.00
10,000.00

0.00
2,535.39
4,888.58
8,193.94
13,349.50
688.69

0.00
17,433.46
34,818.54
131,814.57
130,127.01
6,003.53

0.00
22,566.54
25,181.46
38,185.43
-45,127.01
3,996.47

0.00
0.00
0.00
0.00
0.00
0.00

0.00
22,566.54
25,181.46
38,185.43
-45,127.01
3,996.47

0.00
56.42
41.97
22.46
0.00
39.96

E40 Sub Totals:

365,000.00

29,656.10

320,197.11

44,802.89

0.00

44,802.89

12.27

Expense Sub Totals:

365,000.00

29,656.10

320,197.11

44,802.89

0.00

44,802.89

12.27

Dept 570 Sub Totals:
Transfer Out
Interfund Transfers Out
Transfer to Capital Projects
Transfer to Community Develop.

365,000.00

29,656.10

320,197.11

44,802.89

0.00

315,800.00
0.00

0.00
0.00

2,040,800.00 -1,725,000.00
0.00
0.00

0.00
0.00

-1,725,000.00
0.00

0.00
0.00

E85 Sub Totals:

315,800.00

0.00

2,040,800.00 -1,725,000.00

0.00

-1,725,000.00

0.00

Expense Sub Totals:

315,800.00

0.00

2,040,800.00 -1,725,000.00

0.00

-1,725,000.00

0.00

Dept 600 Sub Totals:

315,800.00

0.00

2,040,800.00 -1,725,000.00

0.00

Fund Revenue Sub Totals:

8,721,100.00

2,586,421.00

8,517,127.42

203,972.58

0.00

203,972.58

2.34

Fund Expense Sub Totals:

8,721,100.00

527,143.29

7,694,059.93

1,027,040.07

396,553.77

630,486.30

7.23

0.00

-2,059,277.71

-823,067.49

823,067.49

396,553.77

Fund 10 Sub Totals:

GL-Budget Status (2/6/2024 - 2:27 PM)

Page 19

Page 49 of 60

Account Number

GL-Budget Status (2/6/2024 - 2:27 PM)

Description

Budget Amount

Period Amount

YTD Amount

YTD Var

Encumbered Amount

Available

% Available

Revenue Totals:

8,721,100.00

2,586,421.00

8,517,127.42

203,972.58

0.00

203,972.58

2.34

Expense Totals:

8,721,100.00

527,143.29

7,694,059.93

1,027,040.07

396,553.77

630,486.30

7.23

Report Totals:

0.00

-2,059,277.71

-823,067.49

823,067.49

396,553.77

Page 20

Page 50 of 60

General Ledger
Budget Status
User:
Printed:
Period:

Rbruchey
2/6/2024 - 2:45 PM
7, 2024

Account Number

Description

Fund
20
Dept
20-111
R23
20-111-03-4245

R30
20-111-03-4260
20-111-03-4271
20-111-03-4272
20-111-03-4273

Dept
20-140
R60
20-140-04-4430
20-140-04-4431
20-140-04-4433
20-140-04-4434
20-140-04-4437
20-140-04-4438
20-140-04-4439
20-140-04-4443

Dept

20-171

GL-Budget Status (2/6/2024 - 2:45 PM)

Budget Amount

Period Amount

YTD Amount

YTD Var

Encumbered Amount

Available

% Available

Water Fund
Grants - State Government
Grant-Community Development
CDBG Programs

0.00

R23 Sub Totals:

0.00

Grants-Other Intergovernment
MDE Grants
Yourtee Springs MD State Grant
Reservoir State Grant
ARPA Grant

0.00
0.00
331,000.00
250,000.00

0.00
0.00
0.00
334,762.81

0.00
0.00
0.00
991,398.71

0.00
0.00
331,000.00
-741,398.71

0.00
0.00
0.00
0.00

0.00
0.00
331,000.00
-741,398.71

0.00
0.00
100.00
0.00

R30 Sub Totals:

581,000.00

334,762.81

991,398.71

-410,398.71

0.00

-410,398.71

0.00

Revenue Sub Totals:

581,000.00

334,762.81

991,398.71

-410,398.71

0.00

-410,398.71

0.00

Dept 111 Sub Totals:
Utility Service Charges
Charges-Utility
Connection Charges
Interest-UT bills
Parts,Service Restore,ApplyFee
Service Charges
Sale of Sub-Meters
Sale of Meters
Inspection Fee
Administrative UT Write-offs

-581,000.00

-334,762.81

-991,398.71

410,398.71

0.00

300,000.00
0.00
8,000.00
2,223,200.00
0.00
45,000.00
5,000.00
0.00

0.00
0.00
0.00
4,363.23
0.00
0.00
460.00
0.00

59,774.00
22.64
2,925.00
1,189,228.65
0.00
10,680.00
2,160.00
0.00

240,226.00
-22.64
5,075.00
1,033,971.35
0.00
34,320.00
2,840.00
0.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

240,226.00
-22.64
5,075.00
1,033,971.35
0.00
34,320.00
2,840.00
0.00

80.08
0.00
63.44
46.51
0.00
76.27
56.80
0.00

R60 Sub Totals:

2,581,200.00

4,823.23

1,264,790.29

1,316,409.71

0.00

1,316,409.71

51.00

Revenue Sub Totals:

2,581,200.00

4,823.23

1,264,790.29

1,316,409.71

0.00

1,316,409.71

51.00

Dept 140 Sub Totals:
Rents & Concessions

-2,581,200.00

-4,823.23

-1,264,790.29 -1,316,409.71

0.00

Page 1

Page 51 of 60

Account Number

Description

Budget Amount

Period Amount

YTD Amount

YTD Var

Encumbered Amount

Available

% Available

R82
20-171-06-4630

Rental Income
Rental Income

80,000.00

7,091.34

58,215.29

21,784.71

0.00

21,784.71

27.23

R82 Sub Totals:

80,000.00

7,091.34

58,215.29

21,784.71

0.00

21,784.71

27.23

Revenue Sub Totals:

80,000.00

7,091.34

58,215.29

21,784.71

0.00

21,784.71

27.23

Dept 171 Sub Totals:
Contributions & Donations
Intergovernmental
Contribution-Government

-80,000.00

-7,091.34

-58,215.29

-21,784.71

0.00

R20 Sub Totals:

0.00

Revenue Sub Totals:

0.00

Dept 172 Sub Totals:
Sales of Property
Miscellaneous Revenues
Sale of Vehicle/Equipment

0.00

R80 Sub Totals:

0.00

Revenue Sub Totals:

0.00

Dept 173 Sub Totals:
Other Revenues
Miscellaneous Revenues
Employee Paid Health Insurance
Refund-Unemployment Insurance
Refunds & Rebates
Reimbursements
Miscellaneous Revenue
State Retirement Credit

0.00

14,800.00
0.00
2,500.00
0.00
20,000.00
0.00

780.70
0.00
0.00
0.00
18.46
0.00

5,768.82
0.00
0.00
0.00
18.46
0.00

9,031.18
0.00
2,500.00
0.00
19,981.54
0.00

0.00
0.00
0.00
0.00
0.00
0.00

9,031.18
0.00
2,500.00
0.00
19,981.54
0.00

61.02
0.00
100.00
0.00
99.91
0.00

R80 Sub Totals:

37,300.00

799.16

5,787.28

31,512.72

0.00

31,512.72

84.48

Interfund Transfers
Transfers In from General Fund

0.00

R85 Sub Totals:

0.00

37,300.00

799.16

5,787.28

31,512.72

0.00

31,512.72

84.48

Dept
20-172
R20
20-172-03-4710

Dept
20-173
R80
20-173-06-4650

Dept
20-175
R80
20-175-06-4692
20-175-06-4693
20-175-06-4697
20-175-06-4698
20-175-06-4699
20-175-06-4701

R85
20-175-08-5101

Revenue Sub Totals:
GL-Budget Status (2/6/2024 - 2:45 PM)

Page 2

Page 52 of 60

Account Number

Description

Dept
20-190
R86
20-190-07-5000

Dept 175 Sub Totals:
Long-term Debt Proceeds
Other Sources
Proceeds from New Debt

Dept
20-532
E01
20-532-20-6000
20-532-20-6001
20-532-20-6014
20-532-20-6016
20-532-20-6017
20-532-20-6019
20-532-20-6020
20-532-20-6021
20-532-20-6022
20-532-20-6023
20-532-20-6025
20-532-20-6026
20-532-20-6028
20-532-20-6030
20-532-20-6031
20-532-20-6050

E10
20-532-20-6100
20-532-20-6101
20-532-20-6102
20-532-20-6104
20-532-20-6108
20-532-20-6109
20-532-20-6112
20-532-20-6114
20-532-20-6120
20-532-20-6121
20-532-20-6122
GL-Budget Status (2/6/2024 - 2:45 PM)

Budget Amount

Period Amount

YTD Amount

YTD Var

Encumbered Amount

Available

% Available

-37,300.00

-799.16

-5,787.28

-31,512.72

0.00

R86 Sub Totals:

0.00

Revenue Sub Totals:

0.00

Dept 190 Sub Totals:
Water
Personnel Costs
Salaries
Salaries Overtime-Regular
Salaries-Holiday Premium
Salaries Transferred In
Salaries Transferred Out
Salaries Transferred OT
Social Security
Medicare
Health,Dental,&Vision Premiums
Fringe Benefits Transferred In
Pension Expense
Life Insurance-ER Paid
Clothing & Shoe Allowance
Workers Compensation
Post Employment Charges
Accrued Leave

0.00

497,700.00
11,000.00
0.00
110,300.00
0.00
7,000.00
30,900.00
7,300.00
111,900.00
48,800.00
56,000.00
400.00
600.00
33,100.00
0.00
0.00

29,807.74
629.42
0.00
5,019.62
0.00
118.13
1,853.00
433.36
4,689.93
393.00
0.00
48.79
0.00
0.00
1,162.97
0.00

240,669.17
3,858.79
0.00
68,454.83
0.00
4,832.54
12,022.55
6,689.76
50,701.21
5,594.41
45,117.74
180.45
4,395.62
27,174.00
9,824.12
0.00

257,030.83
7,141.21
0.00
41,845.17
0.00
2,167.46
18,877.45
610.24
61,198.79
43,205.59
10,882.26
219.55
-3,795.62
5,926.00
-9,824.12
0.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

257,030.83
7,141.21
0.00
41,845.17
0.00
2,167.46
18,877.45
610.24
61,198.79
43,205.59
10,882.26
219.55
-3,795.62
5,926.00
-9,824.12
0.00

51.64
64.92
0.00
37.94
0.00
30.96
61.09
8.36
54.69
88.54
19.43
54.89
0.00
17.90
0.00
0.00

E01 Sub Totals:

915,000.00

44,155.96

479,515.19

435,484.81

0.00

435,484.81

47.59

Operating Expenses
Advertising & Printing
Legal Fees
Cleaning Supplies
Consultant Fees
Bond Amortization Expense
Dues & Subscriptions
Annual Service Contracts
Insurance-Liability,Auto,Prop.
Office Supplies
Operating Expense
Wireless Phones & Data

4,000.00
0.00
1,500.00
0.00
0.00
0.00
35,000.00
39,000.00
500.00
29,000.00
3,500.00

0.00
0.00
93.02
0.00
0.00
0.00
1,818.00
0.00
179.99
100.00
502.78

126.38
0.00
344.40
0.00
0.00
0.00
21,692.69
43,727.33
171.36
15,733.93
3,794.62

3,873.62
0.00
1,155.60
0.00
0.00
0.00
13,307.31
-4,727.33
328.64
13,266.07
-294.62

0.00
0.00
0.00
13,500.00
0.00
0.00
396.00
0.00
0.00
0.00
0.00

3,873.62
0.00
1,155.60
-13,500.00
0.00
0.00
12,911.31
-4,727.33
328.64
13,266.07
-294.62

96.84
0.00
77.04
0.00
0.00
0.00
36.89
0.00
65.73
45.75
0.00
Page 3

Page 53 of 60

Account Number

Description

20-532-20-6123
20-532-20-6124
20-532-20-6125
20-532-20-6129
20-532-20-6130
20-532-20-6131
20-532-20-6132
20-532-20-6134
20-532-20-6135
20-532-20-6136
20-532-20-6137
20-532-20-6138
20-532-20-6142
20-532-20-6300
20-532-20-6301
20-532-20-6400
20-532-20-6416
20-532-20-6417
20-532-20-6418
20-532-20-6420
20-532-20-7501
20-532-20-7502
20-532-20-7503
20-532-20-7504
20-532-21-6419
20-532-21-6421
20-532-23-6104
20-532-23-6112
20-532-23-6144
20-532-23-6145
20-532-23-6420
20-532-23-7505
20-532-23-7506
20-532-40-6400
20-532-40-6416

E20
20-532-20-6107

E30
20-532-19-8500
GL-Budget Status (2/6/2024 - 2:45 PM)

Budget Amount

Period Amount

YTD Amount

YTD Var

Encumbered Amount

Available

% Available

Parts & Supplies
Physical Exams & Drug Testing
Postage
Safety Program
Telephones & Internet
Tools & Small Equipment
Training & Seminars
Tuition Reimbursement
Uniforms
Utilities
Vehicle Fuel
Water Utility Expense
Audits & Bookkeeping
Information Technology
IT Network Admin Consultant
Loss on Disposal of Equip
Maint. & Repair-Equipment
Maint. & Repair-Vehicles
Maint. & Repair-Building
Maint. & Repair-Infrastructure
Chemicals
Laboratory
Ground Rent
Sludge Haulng (by Sewer Dept)
Maint. & Repair-Other
Maint. & Repair-Grounds
Consultant Fees
Annual Service Contracts
Equipment Rentals
Operating Supplies
Maint. & Repair-Infrastructure
Water Meter Repair & Replace
Special Taxing District Meters
Loss on Disposal of Equipment
Maint. & Repair-Equipment

10,000.00
2,000.00
2,000.00
5,000.00
20,000.00
2,000.00
3,500.00
0.00
15,000.00
110,000.00
5,000.00
500.00
0.00
1,000.00
8,000.00
0.00
75,000.00
2,500.00
50,000.00
2,500.00
150,000.00
48,000.00
0.00
20,000.00
15,000.00
5,000.00
25,000.00
31,000.00
0.00
8,000.00
40,000.00
5,000.00
32,000.00
0.00
0.00

340.21
0.00
77.51
99.00
827.89
0.00
0.00
0.00
0.00
0.00
587.73
0.00
0.00
8.25
763.88
0.00
1,848.65
0.00
7,210.79
0.00
5,025.72
208.10
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

7,176.01
253.50
260.64
891.12
11,489.39
235.97
1,116.91
0.00
12,294.56
26,093.13
2,977.08
121.72
0.00
33.00
5,204.04
0.00
52,992.55
1,089.39
12,057.79
0.00
93,197.17
11,127.52
0.00
20,288.24
14,693.77
513.45
0.00
12,830.23
296.39
658.80
6,957.75
2,591.63
8,780.00
0.00
0.00

2,823.99
1,746.50
1,739.36
4,108.88
8,510.61
1,764.03
2,383.09
0.00
2,705.44
83,906.87
2,022.92
378.28
0.00
967.00
2,795.96
0.00
22,007.45
1,410.61
37,942.21
2,500.00
56,802.83
36,872.48
0.00
-288.24
306.23
4,486.55
25,000.00
18,169.77
-296.39
7,341.20
33,042.25
2,408.37
23,220.00
0.00
0.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
12,833.54
0.00
29,989.00
0.00
13,898.11
0.00
0.00
0.00
0.00
0.00
0.00
5,089.26
0.00
0.00
0.00
0.00
0.00
0.00
0.00

2,823.99
1,746.50
1,739.36
4,108.88
8,510.61
1,764.03
2,383.09
0.00
2,705.44
83,906.87
2,022.92
378.28
0.00
967.00
2,795.96
0.00
9,173.91
1,410.61
7,953.21
2,500.00
42,904.72
36,872.48
0.00
-288.24
306.23
4,486.55
25,000.00
13,080.51
-296.39
7,341.20
33,042.25
2,408.37
23,220.00
0.00
0.00

28.24
87.33
86.97
82.18
42.55
88.20
68.09
0.00
18.04
76.28
40.46
75.66
0.00
96.70
34.95
0.00
12.23
56.42
15.91
100.00
28.60
76.82
0.00
0.00
2.04
89.73
100.00
42.20
0.00
91.77
82.61
48.17
72.56
0.00
0.00

E10 Sub Totals:

805,500.00

19,691.52

391,812.46

413,687.54

75,705.91

337,981.63

41.96

Depreciation
Depreciation

127,200.00

63,600.00

74,200.00

53,000.00

0.00

53,000.00

41.67

E20 Sub Totals:

127,200.00

63,600.00

74,200.00

53,000.00

0.00

53,000.00

41.67

Project Outlays
Yourtee Springs Storage Tank

250,000.00

0.00

20,546.53

229,453.47

9,631.10

219,822.37

87.93
Page 4

Page 54 of 60

Account Number

Description

20-532-19-8501
20-532-19-8502
20-532-19-8503
20-532-19-8504
20-532-19-8505
20-532-19-8506
20-532-19-8507
20-532-19-8508
20-532-19-8509
20-532-19-8510
20-532-19-8511
20-532-19-8512
20-532-19-8513
20-532-20-8000
20-532-20-8001
20-532-20-8003
20-532-20-8004
20-532-20-8009
20-532-21-8101
20-532-21-8114
20-532-22-8248
20-532-22-8249
20-532-22-8250
20-532-22-8251
20-532-22-8425
20-532-22-8427
20-532-23-8003
20-532-23-8006
20-532-23-8008
20-532-23-8103
20-532-23-8104
20-532-23-8105
20-532-40-8003
20-532-40-8005

East F St 2nd to 5th WaterMain
6th Ave fr East H-East E-ARPA
East H fr 5th to Gum Spr-ARPA
5th Ave fr East F-East H-ARPA
4th Ave 100 Block-ARPA
2nd Ave fr Concord-K St-ARPA
WPotomac fr Del toFlorida-ARPA
Yourtee-Reline Under RR-ARPA
Reline Waterline-KnoxvilleARPA
Yourtee Rehab-Phase II-PAYGO
Downtown Water Line Upgr-ARPA
WaterLn Separation for HO-ARPA
Lead Line&Service Inventory
Capitalized to Fixed Assets
Project Outlay
Capital-Equipment
Capital-Vehicles
Capital-Other Infrastructure
Yourtee Springs Improvements
Filter Flow Meters(3)
Corrosion Inhibitor
Mixer for 250k Storage Tank
Intake Cooling Units
Replacement Gates at Reservoir
Water Tower Service
1.25M Gal Ground Storage Tank
Capital-Equipment
Line Replacements
Line Replacement (DPW)
RF Water Meter Replacement
Sub-Meter Purchases
Hydrant Replacement Project
Capital-Equipment
Capital-Software Upgrade

Dept
20-570
E40
20-570-50-9000
GL-Budget Status (2/6/2024 - 2:45 PM)

Budget Amount

Period Amount

YTD Amount

YTD Var

Encumbered Amount

Available

% Available

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
4,500.00
51,300.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
36,000.00
331,000.00
0.00
180,000.00
40,000.00
60,000.00
2,000.00
35,000.00
60,000.00
0.00

0.00
334,762.81
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
98.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

0.00
885,644.83
93,889.35
0.00
0.00
0.00
0.00
0.00
-21,232.00
1,453.81
12,550.00
0.00
20,338.50
0.00
0.00
0.00
58,317.39
0.00
0.00
-350.00
3,248.02
0.00
0.00
0.00
37,319.30
6,689.70
0.00
0.00
35.49
3,033.45
0.00
9,502.00
0.00
0.00

0.00
-885,644.83
-93,889.35
0.00
0.00
0.00
0.00
0.00
21,232.00
-1,453.81
-12,550.00
0.00
-20,338.50
0.00
0.00
4,500.00
-7,017.39
0.00
0.00
350.00
-3,248.02
0.00
0.00
0.00
-1,319.30
324,310.30
0.00
180,000.00
39,964.51
56,966.55
2,000.00
25,498.00
60,000.00
0.00

0.00
80,512.85
1,278,186.45
19,216.91
16,154.98
19,442.79
29,179.66
0.00
0.00
21,765.00
6,181.50
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
19,410.32
0.00
0.00
0.00
7,733.00
117,080.99
0.00
0.00
25,019.42
41,832.55
0.00
0.00
0.00
0.00

0.00
-966,157.68
-1,372,075.80
-19,216.91
-16,154.98
-19,442.79
-29,179.66
0.00
21,232.00
-23,218.81
-18,731.50
0.00
-20,338.50
0.00
0.00
4,500.00
-7,017.39
0.00
0.00
350.00
-22,658.34
0.00
0.00
0.00
-9,052.30
207,229.31
0.00
180,000.00
14,945.09
15,134.00
2,000.00
25,498.00
60,000.00
0.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
100.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
62.61
0.00
100.00
37.36
25.22
100.00
72.85
100.00
0.00

E30 Sub Totals:

1,049,800.00

334,860.81

1,130,986.37

-81,186.37

1,691,347.52

-1,772,533.89

0.00

Expense Sub Totals:

2,897,500.00

462,308.29

2,076,514.02

820,985.98

1,767,053.43

-946,067.45

0.00

Dept 532 Sub Totals:
Debt Service
Debt Service
Debt Service

2,897,500.00

462,308.29

2,076,514.02

820,985.98

1,767,053.43

264,000.00

0.00

264,000.00

0.00

264,000.00

100.00
Page 5

Page 55 of 60

Account Number

Description

Budget Amount

Period Amount

YTD Amount

YTD Var

Encumbered Amount

Available

% Available

20-570-50-9100

Interest Expense

118,000.00

44,346.23

65,454.23

52,545.77

0.00

52,545.77

44.53

E40 Sub Totals:

382,000.00

44,346.23

65,454.23

316,545.77

0.00

316,545.77

82.87

Expense Sub Totals:

382,000.00

44,346.23

65,454.23

316,545.77

0.00

316,545.77

82.87

Dept 570 Sub Totals:

382,000.00

44,346.23

65,454.23

316,545.77

0.00

Fund Revenue Sub Totals:

3,279,500.00

347,476.54

2,320,191.57

959,308.43

0.00

959,308.43

29.25

Fund Expense Sub Totals:

3,279,500.00

506,654.52

2,141,968.25

1,137,531.75

1,767,053.43

-629,521.68

0.00

159,177.98

-178,223.32

178,223.32

1,767,053.43

Revenue Totals:

3,279,500.00

347,476.54

2,320,191.57

959,308.43

0.00

959,308.43

29.25

Expense Totals:

3,279,500.00

506,654.52

2,141,968.25

1,137,531.75

1,767,053.43

-629,521.68

0.00

Report Totals:

0.00

159,177.98

-178,223.32

178,223.32

1,767,053.43

Fund 20 Sub Totals:

GL-Budget Status (2/6/2024 - 2:45 PM)

Page 6

Page 56 of 60

General Ledger
Budget Status
User:
Printed:
Period:

Rbruchey
2/6/2024 - 2:52 PM
7, 2024

Account Number

Description

Fund
60
Dept
60-111
R30
60-111-03-4260
60-111-03-4273

Dept
60-140
R60
60-140-04-4430
60-140-04-4431
60-140-04-4433
60-140-04-4434
60-140-04-4439
60-140-04-4440
60-140-04-4441
60-140-04-4443

Dept
60-175
R80
60-175-06-4692
60-175-06-4693
60-175-06-4697
60-175-06-4698
60-175-06-4699
GL-Budget Status (2/6/2024 - 2:52 PM)

Budget Amount

Period Amount

YTD Amount

YTD Var

Encumbered Amount

Available

% Available

Wastewater
Grants - State Government
Grants-Other Intergovernment
MDE Grants
ARPA Grant

53,000.00
0.00

0.00
1,170.00

47,536.00
92,865.00

5,464.00
-92,865.00

0.00
0.00

5,464.00
-92,865.00

10.31
0.00

R30 Sub Totals:

53,000.00

1,170.00

140,401.00

-87,401.00

0.00

-87,401.00

0.00

Revenue Sub Totals:

53,000.00

1,170.00

140,401.00

-87,401.00

0.00

-87,401.00

0.00

Dept 111 Sub Totals:
Utility Service Charges
Charges-Utility
Connection Charges
Interest-UT bills
Parts,Service Restore,ApplyFee
Service Charges
Inspection Fee
Frederick Co. Treatment Charge
Sludge Haulng Fee (Water Dept)
Administrative UT Write-offs

-53,000.00

-1,170.00

-140,401.00

87,401.00

0.00

748,000.00
0.00
0.00
1,998,500.00
7,000.00
100,000.00
0.00
0.00

0.00
0.00
0.00
-1,734.83
720.00
0.00
0.00
0.00

75,164.00
26.18
0.00
1,087,146.40
3,000.00
94,681.00
0.00
0.00

672,836.00
-26.18
0.00
911,353.60
4,000.00
5,319.00
0.00
0.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

672,836.00
-26.18
0.00
911,353.60
4,000.00
5,319.00
0.00
0.00

89.95
0.00
0.00
45.60
57.14
5.32
0.00
0.00

R60 Sub Totals:

2,853,500.00

-1,014.83

1,260,017.58

1,593,482.42

0.00

1,593,482.42

55.84

Revenue Sub Totals:

2,853,500.00

-1,014.83

1,260,017.58

1,593,482.42

0.00

1,593,482.42

55.84

Dept 140 Sub Totals:
Other Revenues
Miscellaneous Revenues
Employee Paid Health Insurance
Refund-Unemployment Insurance
Refunds & Rebates
Reimbursements
Miscellaneous Revenue

-2,853,500.00

1,014.83

-1,260,017.58 -1,593,482.42

0.00

11,000.00
0.00
9,400.00
0.00
0.00

688.02
0.00
0.00
0.00
0.00

5,360.10
0.00
9,400.00
0.00
0.00

48.73
0.00
100.00
0.00
0.00

5,639.90
0.00
0.00
0.00
0.00

5,360.10
0.00
9,400.00
0.00
0.00

0.00
0.00
0.00
0.00
0.00

Page 1

Page 57 of 60

Account Number

Description

Budget Amount

Period Amount

YTD Amount

YTD Var

Encumbered Amount

Available

% Available

60-175-06-4701

State Retirement Credit

0.00

20,400.00

688.02

5,639.90

14,760.10

0.00

14,760.10

72.35

Interfund Transfers
Transfers In from General Fund

0.00

R85 Sub Totals:

0.00

Revenue Sub Totals:

20,400.00

688.02

5,639.90

14,760.10

0.00

14,760.10

72.35

Dept 175 Sub Totals:
Long-term Debt Proceeds
Other Sources
Proceeds from New Debt

-20,400.00

-688.02

-5,639.90

-14,760.10

0.00

R86 Sub Totals:

0.00

Revenue Sub Totals:

0.00

Dept 190 Sub Totals:
Wastewater
Personnel Costs
Salaries
Salaries Overtime-Regular
Salaries-Holiday Premium
Salaries Transferred In
Salaries Transferred Out
Salaries Transferred OT
Social Security
Medicare
Health,Dental,&Vision Premiums
Fringe Benefits Transferred In
Fringe Benefits Transfered Out
Pension Expense
Life Insurance-ER Paid
Clothing & Shoe Allowance
Workers Compensation
Accrued Leave

0.00

475,800.00
3,000.00
0.00
44,100.00
0.00
4,000.00
29,500.00
6,900.00
87,400.00
19,600.00
0.00
43,600.00
400.00
600.00
31,000.00
0.00

34,530.50
281.36
0.00
5,769.84
0.00
0.00
2,088.88
488.53
4,918.71
441.39
0.00
0.00
48.79
0.00
0.00
0.00

261,059.81
654.76
0.00
36,909.30
0.00
0.00
14,959.49
4,803.57
52,203.48
2,820.18
0.00
46,405.10
174.94
4,776.52
29,969.00
0.00

214,740.19
2,345.24
0.00
7,190.70
0.00
4,000.00
14,540.51
2,096.43
35,196.52
16,779.82
0.00
-2,805.10
225.06
-4,176.52
1,031.00
0.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

214,740.19
2,345.24
0.00
7,190.70
0.00
4,000.00
14,540.51
2,096.43
35,196.52
16,779.82
0.00
-2,805.10
225.06
-4,176.52
1,031.00
0.00

45.13
78.17
0.00
16.31
0.00
100.00
49.29
30.38
40.27
85.61
0.00
0.00
56.27
0.00
3.33
0.00

E01 Sub Totals:

745,900.00

48,568.00

454,736.15

291,163.85

0.00

291,163.85

39.04

700.00

0.00

700.00

0.00

700.00

100.00

R80 Sub Totals:
R85
60-175-08-5101

Dept
60-190
R86
60-190-07-5000

Dept
60-533
E01
60-533-60-6000
60-533-60-6001
60-533-60-6014
60-533-60-6016
60-533-60-6017
60-533-60-6019
60-533-60-6020
60-533-60-6021
60-533-60-6022
60-533-60-6023
60-533-60-6024
60-533-60-6025
60-533-60-6026
60-533-60-6028
60-533-60-6030
60-533-60-6050

E10
60-533-60-6100
GL-Budget Status (2/6/2024 - 2:52 PM)

Operating Expenses
Advertising & Printing

Page 2

Page 58 of 60

Account Number

Description

60-533-60-6101
60-533-60-6102
60-533-60-6104
60-533-60-6108
60-533-60-6109
60-533-60-6112
60-533-60-6114
60-533-60-6120
60-533-60-6121
60-533-60-6122
60-533-60-6123
60-533-60-6124
60-533-60-6125
60-533-60-6129
60-533-60-6130
60-533-60-6131
60-533-60-6132
60-533-60-6135
60-533-60-6136
60-533-60-6137
60-533-60-6138
60-533-60-6142
60-533-60-6300
60-533-60-6301
60-533-60-6400
60-533-60-6416
60-533-60-6417
60-533-60-6418
60-533-60-6420
60-533-60-6421
60-533-60-6702
60-533-60-7501
60-533-60-7502
60-533-61-6104
60-533-61-6112
60-533-61-6144
60-533-61-6145
60-533-61-6416
60-533-61-6419
60-533-61-6420

E20
GL-Budget Status (2/6/2024 - 2:52 PM)

Budget Amount

Period Amount

YTD Amount

YTD Var

Encumbered Amount

Available

% Available

Legal Fees
Cleaning Supplies
Consultant Fees
Bond Amortization Expense
Dues & Subscriptions
Annual Service Contracts
Insurance-Liability,Auto,Prop.
Office Supplies
Operating Expense
Wireless Phones & Data
Parts & Supplies
Physical Exams & Drug Testing
Postage
Safety Program
Telephones & Internet
Tools & Small Equipment
Training & Seminars
Uniforms
Utilities
Vehicle Fuel
Water Utility Expense
Audits & Bookkeeping
Information Technology
IT Network Admin Consultant
Loss on Disposal of Equip
Maint. & Repair-Equipment
Maint. & Repair-Vehicles
Maint. & Repair-Building
Maint. & Repair-Infrastructure
Maint. & Repair-Grounds
Tipping Charges
Chemicals
Laboratory
Consultant Fees
Annual Service Contracts
Equipment Rentals
Operating Supplies
Maint. & Repair-Equipment
Maint. & Repair-Galyn Manor
Maint. & Repair-Infrastructure

0.00
1,200.00
0.00
0.00
400.00
124,400.00
39,000.00
1,200.00
6,500.00
3,500.00
4,000.00
2,500.00
1,000.00
4,000.00
8,000.00
4,000.00
1,500.00
4,500.00
150,000.00
2,500.00
13,000.00
0.00
3,000.00
7,500.00
0.00
125,000.00
1,500.00
10,000.00
0.00
10,000.00
100,000.00
130,000.00
45,000.00
2,000.00
37,000.00
0.00
17,000.00
5,000.00
18,000.00
10,000.00

0.00
39.60
0.00
0.00
0.00
6,010.09
0.00
1,139.05
0.00
452.96
935.77
0.00
0.00
99.00
721.24
0.00
0.00
0.00
0.00
250.09
0.00
0.00
0.00
763.88
0.00
4,919.15
0.00
1,373.10
0.00
0.00
10,792.55
0.00
1,813.95
0.00
0.00
0.00
999.32
0.00
315.00
0.00

0.00
445.49
0.00
0.00
50.00
19,021.31
44,188.34
1,372.03
5,082.41
3,461.24
3,794.99
198.50
0.00
767.47
5,019.63
214.98
1,252.00
2,930.15
63,019.76
1,454.24
2,696.56
0.00
111.09
5,714.54
0.00
74,505.53
1,147.64
9,046.16
0.00
0.00
74,938.96
63,735.86
16,925.00
0.00
12,830.23
296.40
10,994.79
0.00
5,405.23
175.26

0.00
754.51
0.00
0.00
350.00
105,378.69
-5,188.34
-172.03
1,417.59
38.76
205.01
2,301.50
1,000.00
3,232.53
2,980.37
3,785.02
248.00
1,569.85
86,980.24
1,045.76
10,303.44
0.00
2,888.91
1,785.46
0.00
50,494.47
352.36
953.84
0.00
10,000.00
25,061.04
66,264.14
28,075.00
2,000.00
24,169.77
-296.40
6,005.21
5,000.00
12,594.77
9,824.74

0.00
0.00
13,500.00
0.00
0.00
99,797.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
45,521.91
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
5,089.26
0.00
0.00
0.00
0.00
0.00

0.00
754.51
-13,500.00
0.00
350.00
5,581.69
-5,188.34
-172.03
1,417.59
38.76
205.01
2,301.50
1,000.00
3,232.53
2,980.37
3,785.02
248.00
1,569.85
86,980.24
1,045.76
10,303.44
0.00
2,888.91
1,785.46
0.00
4,972.56
352.36
953.84
0.00
10,000.00
25,061.04
66,264.14
28,075.00
2,000.00
19,080.51
-296.40
6,005.21
5,000.00
12,594.77
9,824.74

0.00
62.88
0.00
0.00
87.50
4.49
0.00
0.00
21.81
1.11
5.13
92.06
100.00
80.81
37.25
94.63
16.53
34.89
57.99
41.83
79.26
0.00
96.30
23.81
0.00
3.98
23.49
9.54
0.00
100.00
25.06
50.97
62.39
100.00
51.57
0.00
35.32
100.00
69.97
98.25

E10 Sub Totals:

892,900.00

30,624.75

430,795.79

462,104.21

163,908.17

298,196.04

33.40

Depreciation
Page 3

Page 59 of 60

Account Number

Description

Budget Amount

Period Amount

YTD Amount

YTD Var

Encumbered Amount

Available

% Available

60-533-60-6107

Depreciation

183,300.00

91,650.00

106,925.00

76,375.00

0.00

76,375.00

41.67

E20 Sub Totals:

183,300.00

91,650.00

106,925.00

76,375.00

0.00

76,375.00

41.67

Project Outlays
I&I Improvements-ARPA
WWTP Upgrade Design/Engin-ARPA
Capital-Equipment
Capital-Plant Improvements
Capital-Building Improvements
UV Bulb Replacement
Belt Press Rebuild
Portable Sewer Meter
SBR Ammonia&NitrateProbe Upgra
WWTP Bldg/Elec Sys Rehab
WWTP Upgrade
Galyn Manor PLC Upgrade
PLC Upgrade
Capitalized to Fixed Assets
Project Outlay
Capital-Equipment
Capital-Vehicles
Capital-Other Infrastructure
Potomac St Pump Station Gate
Capital-Equipment
Capital - Vehicles
Line Replacements
Inflow & Infiltration

0.00
0.00
55,500.00
0.00
0.00
0.00
0.00
16,000.00
0.00
0.00
250,000.00
0.00
100,000.00
0.00
0.00
55,000.00
51,300.00
0.00
0.00
0.00
0.00
175,000.00
100,000.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

92,865.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
10,342.57
58,317.39
0.00
0.00
0.00
0.00
0.00
0.00

-92,865.00
0.00
55,500.00
0.00
0.00
0.00
0.00
16,000.00
0.00
0.00
250,000.00
0.00
100,000.00
0.00
0.00
44,657.43
-7,017.39
0.00
0.00
0.00
0.00
175,000.00
100,000.00

201,020.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
250,000.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

-293,885.00
0.00
55,500.00
0.00
0.00
0.00
0.00
16,000.00
0.00
0.00
0.00
0.00
100,000.00
0.00
0.00
44,657.43
-7,017.39
0.00
0.00
0.00
0.00
175,000.00
100,000.00

0.00
0.00
100.00
0.00
0.00
0.00
0.00
100.00
0.00
0.00
0.00
0.00
100.00
0.00
0.00
81.20
0.00
0.00
0.00
0.00
0.00
100.00
100.00

E30 Sub Totals:

802,800.00

0.00

161,524.96

641,275.04

451,020.00

190,255.04

23.70

Expense Sub Totals:

2,624,900.00

170,842.75

1,153,981.90

1,470,918.10

614,928.17

855,989.93

32.61

Dept 533 Sub Totals:
Debt Service
Debt Service
Debt Service
Interest Expense

2,624,900.00

170,842.75

1,153,981.90

1,470,918.10

614,928.17

217,000.00
85,000.00

0.00
31,471.67

0.00
51,071.87

217,000.00
33,928.13

0.00
0.00

217,000.00
33,928.13

100.00
39.92

E40 Sub Totals:

302,000.00

31,471.67

51,071.87

250,928.13

0.00

250,928.13

83.09

Expense Sub Totals:

302,000.00

31,471.67

51,071.87

250,928.13

0.00

250,928.13

83.09

E30
60-533-19-8500
60-533-19-8501
60-533-40-8003
60-533-40-8007
60-533-40-8008
60-533-40-8108
60-533-40-8112
60-533-40-8113
60-533-40-8114
60-533-40-8117
60-533-40-8120
60-533-40-8121
60-533-40-8122
60-533-60-8000
60-533-60-8001
60-533-60-8003
60-533-60-8004
60-533-60-8009
60-533-60-8112
60-533-61-8003
60-533-61-8004
60-533-61-8006
60-533-61-8121

Dept
60-570
E40
60-570-50-9000
60-570-50-9100

GL-Budget Status (2/6/2024 - 2:52 PM)

Page 4

Page 60 of 60

Account Number

Description

Budget Amount

Period Amount

YTD Amount

YTD Var

Encumbered Amount

302,000.00

31,471.67

51,071.87

250,928.13

0.00

Fund Revenue Sub Totals:

2,926,900.00

843.19

1,406,058.48

1,520,841.52

Fund Expense Sub Totals:

2,926,900.00

202,314.42

1,205,053.77

0.00

201,471.23

Revenue Totals:

2,926,900.00

Expense Totals:

Report Totals:

Dept 570 Sub Totals:

Fund 60 Sub Totals:

GL-Budget Status (2/6/2024 - 2:52 PM)

Available

% Available

0.00

1,520,841.52

51.96

1,721,846.23

614,928.17

1,106,918.06

37.82

-201,004.71

201,004.71

614,928.17

843.19

1,406,058.48

1,520,841.52

0.00

1,520,841.52

51.96

2,926,900.00

202,314.42

1,205,053.77

1,721,846.23

614,928.17

1,106,918.06

37.82

0.00

201,471.23

-201,004.71

201,004.71

614,928.17

Page 5

Read the agenda documentPrimary source ↗

The government’s own published record — read it yourself, then decide what to do about it.

Surveillance in BrunswickLocal report →

The cameras, the coverage, and the local record for this community.

Outcome

Not yet recorded. The record stays open — outcomes are added as minutes and vote results are published.

Provenance

Where this record came from. Every source is listed, permanently.

Agenda Watch · Aug 2, 2026

Permanent ID DKT-2026-000203 — this record is never deleted.

Record history

Every change to this record, logged as it happened.

Aug 2, 2026 Filed on the Docket
Aug 2, 2026 Full document archived — public record
Aug 2, 2026 Location confirmed Brunswick
Aug 3, 2026 Record updated
Aug 3, 2026 Record updated
Aug 3, 2026 Record updated
Aug 3, 2026 Record updated
Aug 3, 2026 Record updated
Aug 3, 2026 Record updated
Aug 3, 2026 Record updated
Aug 3, 2026 Record updated
Aug 3, 2026 Record updated
Aug 3, 2026 Record updated
Aug 3, 2026 Record updated
Aug 3, 2026 Record updated
Aug 4, 2026 Record updated
Aug 4, 2026 Record updated
Aug 4, 2026 Record updated
Aug 4, 2026 Record updated
Aug 4, 2026 Record updated
Aug 4, 2026 Record updated
Aug 4, 2026 Record updated
Aug 4, 2026 Record updated
Aug 4, 2026 Record updated
Aug 4, 2026 Record updated
Aug 4, 2026 Record updated
Aug 4, 2026 Record updated
Aug 4, 2026 Record updated
Aug 4, 2026 Record updated
Aug 4, 2026 Record updated
Aug 4, 2026 Record updated
Aug 4, 2026 Record updated
Aug 4, 2026 Record updated
Aug 4, 2026 Record updated
Aug 4, 2026 Record updated
Aug 4, 2026 Record updated
Aug 4, 2026 Record updated
Aug 4, 2026 Record updated
Aug 4, 2026 Record updated
Aug 4, 2026 Record updated

← The full Docket · every meeting, vote, and action on the permanent record · also in the National Record Index.

On the agenda: Brunswick Md Finance Commission Meeting - Feb 15, 2024 — License Plate Reader (Feb 15)

The agenda, word for word

Provenance

Record history

More on the Docket in Maryland