FY 2024 Budget document

2024

ANNUAL

BUDGET

City of Johns Creek

FY

Index

General Fund Summary

Revenues

1. Local Option Sales Tax

6.Business & Occupation Tax

2. Property Taxes

7. Interest Earnings

3. Insurance Premium Tax

8. Municipal Court Fees

4.Motor Vehicle TAVT

9. Gas Franchise Fees

5.Electric Franchise Fees

10. Alcohol Beverage Excise Tax

Personnel

Department Summary

City Clerk

Court

IT/GIS

City Council

Facilities

Legal

City Manager

Finance

Police

Communications

Fire

Public Works

Community Development

Human Resources

Recreation and Parks

Capital and Enhancement Projects

Infrastructure Maintenance Accrual

Equipment Replacement Accrual

Vehicle Replacement Accrual

Parks Bond Fund

TSPLOST Fund

TSPLOST II Fund

Other Funds

Debt Fund

5-Year Forecast

Proposed 9/12/2023 FY2024 Budget Page 1 of 88

1000000 - General Fund (Summary)

Summary of General Fund Revenues and Expenditures

Revenues

FY2021

FY2022

FY2024

Object Account Actuals Actuals Revised YTD 07/31 Annualized Proposed

313100

Local Option Sales Tax

$23,829,144

$28,164,964

$27,000,000

$20,803,239

$27,936,276

$29,500,000

$2,500,000

9%

Property Taxes (Current + Prior Year)

$19,240,185

$20,419,902

$21,609,256

$2,299,255

$23,316,000

$22,345,205

$735,949

3%

316200

Insurance Premium Tax

$6,362,964

$6,724,630

$6,600,000

$0

$6,600,000

$6,800,000

$200,000

3%

311315

Motor Vehicle TAVT

$2,759,142

$3,214,224

$3,400,000

$2,675,460

$3,734,012

$4,000,000

$600,000

18%

311710

Electric Franchise Fees

$2,475,251

$2,645,999

$2,700,000

$2,333,675

$2,953,168

$3,000,000

$300,000

11%

316100

Business & Occupation Tax

$1,816,703

$1,914,255

$1,780,000

$1,938,508

$2,010,883

$2,000,000

$220,000

12%

361000

Interest Earnings

$44,342

$257,656

$60,000

$1,809,747

$2,323,815

$1,700,000

$1,640,000

2733%

351170

Municipal Court Fees

$974,857

$914,873

$740,000

$1,069,235

$1,411,711

$1,250,000

$510,000

69%

311730

Gas Franchise Fees

$1,076,596

$931,851

$978,400

$485,533

$971,067

$1,009,000

$30,600

3%

314200

Alcohol Beverage Excise

$963,082

$979,200

$810,000

$791,226

$1,084,271

$1,000,000

$190,000

23%

Other Revenues

$9,582,177

$6,127,551

$5,898,315

$4,513,430

$5,714,857

$5,430,950

($467,365)

-8%

Subtotal - Revenues

$69,124,443

$72,295,104

$71,575,971

$38,719,309

$78,056,060

$78,035,155

$6,459,184

9.02%

391000 Operating Transfers In $1,200,000 $1,200,000 $0 ($1,200,000)

399999

Use of Fund Balance

$1,804,047

$822,897

($981,150)

Subtotal - All Revenues

$69,124,443

$72,295,104

$74,580,018

$38,719,309

$81,060,107

$78,858,052

$4,278,034

5.74%

Expenditures

FY2021

FY2022

FY2024

Object Account Actuals Actuals Revised YTD 07/31 Annualized Proposed

1001330

City Clerk

$367,609

$636,909

$894,903

$795,408

$875,375

$959,034

$64,131

7%

1001310

City Council

$164,130

$349,770

$357,938

$250,670

$361,606

$376,007

$18,069

5%

1001320

City Manager

$3,730,404

$1,002,674

$1,594,313

$1,055,464

$1,542,760

$1,842,552

$248,239

16%

1001570

Communications

$608,541

$791,448

$820,186

$663,003

$814,587

$891,461

$71,275

9%

1007410

Community Development

$2,223,290

$2,246,410

$2,513,229

$1,930,090

$2,262,986

$2,761,241

$248,012

10%

1002650

Court

$643,619

$643,180

$746,726

$530,424

$686,474

$799,045

$52,319

7%

1001565

Facilities

$2,649,116

$2,616,178

$2,806,805

$648,500

$2,532,536

$2,785,449

($21,356)

-1%

1001511

Finance

$1,421,785

$1,600,072

$2,134,101

$1,788,522

$2,044,786

$2,296,930

$162,829

8%

1003510

Fire

$9,795,043

$10,043,327

$12,876,519

$10,709,220

$12,632,608

$14,313,781

$1,437,262

11%

1001540

Human Resources

$958,969

$895,904

$682,587

$487,858

$614,060

$895,504

$212,917

31%

1001535

IT/GIS

$2,097,765

$2,259,071

$2,342,998

$2,039,837

$2,458,435

$2,557,977

$214,979

9%

1001530

Legal

$430,890

$371,325

$450,000

$296,926

$450,000

$0

0%

1003210

Police

$9,990,977

$10,639,051

$14,761,815

$11,164,867

$13,736,740

$15,539,346

$777,531

5%

1004110

Public Works

$6,147,016

$6,270,837

$6,618,741

$4,590,251

$6,562,096

$6,857,636

$238,895

4%

1006110

Recreation & Parks

$2,052,590

$2,179,382

$3,932,832

$1,965,398

$3,596,511

$4,433,385

$500,553

13%

Subtotal - Expenditures

$43,281,742

$42,545,540

$53,533,693

$38,916,438

$51,171,560

$57,759,348

$4,225,655

7.89%

Unallocated

$0

0%

BALANCE

$25,842,701

$29,749,565

$21,046,325

($197,129)

$29,888,547

$21,098,704

$52,379

0%

Transfers Out

FY2021

FY2022

FY2024

Object Account Actuals Actuals Revised YTD 07/31 Annualized Adopted

3010000

Capital/Enhancements

$2,710,870

$11,880,512

$4,890,000

$5,752,500

$862,500

18%

3020000

Infrastructure Maintenance Accrual

$9,255,350

$12,215,946

$12,786,483

$12,650,714

($135,769)

-1%

3030000

Equipment Accrual

$1,057,544

$1,092,039

$1,184,572

$1,424,881

$240,309

20%

3500000

Vehicle Replacement Accrual

$1,026,020

$1,053,517

$1,185,270

$1,270,608

$85,338

7%

5600000

Stormwater Fund

$0

$36,200

$0

0%

Debt Service/Other Fund

$4,394,549

$0

$1,000,000

$0

($1,000,000)

-100%

Subtotal - Transfers Out

$18,444,333

$26,278,214

$21,046,325

$21,098,704

$52,379

0%

Balanced

$0

% Inc

(Dec)

% Inc

(Dec)

% Inc

(Dec)

FY2023

$ Inc (Dec)

from 2023

FY2023

$ Inc (Dec)

from 2023

$ Inc (Dec)

from 2023

FY2023

Proposed 9/12/2023 FY 2024 Budget Page 2 of 88

1000000 Revenues (Summary)

Detailed Breakdown of Revenues

Top 10 Revenue Sources

FY 2021

FY2022

FY 2024

Object

Account

Actuals

Revised

YTD 07/31

Annualized

Proposed

313100

Local Option Sales Tax

$23,829,144

$28,164,964

$27,000,000

$20,803,239

$27,936,276

$29,500,000

$2,500,000

9%

311100

Real Property Current Year

$17,113,965

$18,775,777

$20,241,551

$0

$20,988,745

$21,696,069

$1,454,518

7%

311200

Real Property Prior Year

$2,126,220

$1,644,125

$1,367,705

$2,299,255

$2,327,255

$649,136

($718,569)

-53%

316200

Insurance Premium Tax

$6,362,964

$6,724,630

$6,600,000

$0

$6,600,000

$6,800,000

$200,000

3%

311315

Motor Vehicle TAVT

$2,759,142

$3,214,224

$3,400,000

$2,675,460

$3,734,012

$4,000,000

$600,000

18%

311710

Electric Franchise Fees

$2,475,251

$2,645,999

$2,700,000

$2,333,675

$2,953,168

$3,000,000

$300,000

11%

316100

Business & Occupation Tax

$1,816,703

$1,914,255

$1,780,000

$1,938,508

$2,010,883

$2,000,000

$220,000

12%

361000

Interest Earnings

$44,342

$257,656

$60,000

$1,809,747

$2,323,815

$1,700,000

$1,640,000

2733%

351170

Municipal Court Fees

$974,857

$914,873

$740,000

$1,069,235

$1,411,711

$1,250,000

$510,000

69%

311730

Gas Franchise Fees

$1,076,596

$931,851

$978,400

$485,533

$971,067

$1,009,000

$30,600

3%

314200

Alcohol Beverage Excise

$963,082

$979,200

$810,000

$791,226

$1,084,271

$1,000,000

$190,000

23%

Subtotal - Top 10 Revenues

$59,542,266

$66,167,554

$65,677,656

$34,205,879

$72,341,203

$72,604,205

$6,926,549

11%

Other Revenues

(sorted by FY2024)

FY 2021

FY2022

FY 2024

Object Account Actuals Actuals Revised YTD 07/31 Annualized Proposed

323101

Building Residential

$785,603

$877,953

$871,000

$610,709

$854,000

($17,000)

-2%

311750

Television Cable Franchise Fees

$961,589

$919,251

$855,600

$651,303

$894,215

$849,000

($6,600)

-1%

323102

Building Commercial

$261,566

$558,937

$451,000

$594,912

$891,953

$755,000

$304,000

67%

321100

Alcohol Beverage Licenses

$483,005

$510,855

$540,000

$534,150

$540,009

$540,000

$0

0%

311340

Recording Intangible Tax

$1,297,893

$778,645

$1,100,000

$303,514

$359,083

$350,000

($750,000)

-68%

316300

Financial Institution Tax

$203,338

$278,871

$289,000

$36,836

$229,696

$289,000

$0

0%

322905

Building Plan Review

$238,473

$242,404

$304,000

$185,352

$236,411

$271,000

($33,000)

-11%

391000

Operating Transfers In (CVB)

$3,647,606

$137,992

$90,000

$114,001

$202,583

$210,000

$120,000

133%

311600

Real Estate Transfer Tax

$281,039

$274,011

$327,000

$142,015

$191,522

$191,000

($136,000)

-42%

347930

Athletic Field Rental

$107,741

$130,469

$107,000

$102,036

$160,214

$160,000

$53,000

50%

321201

Professional Flat Fee

$132,951

$128,423

$134,000

$109,600

$98,000

($36,000)

-27%

311300

Motor Vehicle Tax

$92,530

$82,295

$89,000

$64,817

$71,055

$71,000

($18,000)

-20%

322902

Administrative Fee

$68,550

$73,167

$70,000

$54,488

$56,150

$70,000

$0

0%

349930

Airbnb Fees

$0

$102,249

$0

$115,980

$60,000

100%

321220

Insurance Fee

$52,500

$52,980

$52,000

$68,325

$55,000

$3,000

6%

347510

Non-Resident Fees

$30,570

$36,232

$37,000

$51,217

$73,489

$50,000

$13,000

35%

347920

Pavilion Rental

$27,379

$52,105

$26,000

$29,756

$52,425

$50,000

$24,000

92%

323110

Electrical

$38,584

$3,851

$64,000

$6,257

$7,182

$40,000

($24,000)

-38%

342130

False Alarms

$55,965

$63,375

$40,000

$48,800

$100,866

$40,000

$0

0%

371103

Diwali Festival

$0

$37,420

$36,912

$37,000

($420)

-1%

322901

Site/Plan Review

$51,600

$52,650

$55,000

$33,700

$33,000

($22,000)

-40%

321212

Commercial

$8,418

$181,327

$10,000

$126,346

$30,000

$20,000

200%

322210

Zoning & Land Use Residential

$218,561

$60,274

$68,000

$16,187

$16,250

$30,000

($38,000)

-56%

324100

Business License Penalty

$38,260

$31,435

$30,000

$57,684

$30,000

$0

0%

383000

Damaged Property

$54,859

$100,863

$30,000

$125,211

$30,000

$0

0%

347910

Tennis Court Rental

$21,343

$23,955

$900

$9,507

$31,104

$25,000

$24,100

2678%

371104

Lunar New Year

$0

$25,262

$25,000

100%

311760

Telephone Franchise Fees

$35,406

$18,446

$35,000

$9,677

$19,058

$20,000

($15,000)

-43%

321140

Pouring Permit

$3,690

$5,220

$3,000

$20,188

$22,780

$20,000

$17,000

567%

324400

Business License Interest

$19,534

$8,676

$6,000

$18,035

$20,000

$14,000

233%

371102

International Festival

$5,832

$29,366

$20,000

$923

$20,000

$0

0%

323108

Plumbing

$18,001

$9,752

$17,000

$25

$17,000

$0

0%

347500

Program Fees

$7,728

$20,181

$15,000

$17,994

$15,000

$0

0%

342125

Background Checks

$15,260

$13,398

$14,000

$11,425

$13,456

$14,000

$0

0%

322230

Sign Permits

$9,185

$11,907

$11,000

$9,915

$10,561

$11,000

$0

0%

347940

Community Room Rental

$3,975

$14,723

$11,000

$11,655

$11,000

$0

0%

371100

Donation Revenue

$5,260

$3,000

$0

$8,900

$6,400

0%

349900

Other Charges For Services

$4,143

$7,400

$6,000

$8,063

$11,915

$6,000

$0

0%

322101

Administrative Variance Resident

$5,601

$6,750

$2,200

$4,000

$6,058

$5,000

$2,800

127%

342120

Accident Reports

$3,972

$5,248

$6,000

$3,905

$4,882

$5,000

($1,000)

-17%

321209

Massage Therapy

$3,700

$3,600

$5,000

$3,500

$4,131

$4,000

($1,000)

-20%

321205

Door-To-Door Solicitation

$2,850

$1,575

$3,000

$2,550

$4,500

$3,000

$0

0%

323104

Retaining Wall

$21,780

$2,724

$9,000

$911

$1,169

$3,000

($6,000)

-67%

323103

Demolition

$2,000

$2,300

$1,800

$1,975

$1,800

$0

0%

321203

Special Event Fee

$1,600

$1,093

$600

$950

$2,048

$1,500

$900

150%

322904

Administrative Permit

$2,900

$2,990

$2,500

$1,630

$1,500

($1,000)

-40%

322906

Administrative Fee Surety Bonds

$250

$5,750

$0

$2,750

$1,000

0%

349910

Police Vehicle Usage

$770

$1,340

$4,000

$660

$893

$1,000

($3,000)

-75%

% Inc

(Dec)

% Inc

(Dec)

FY 2023

$ Inc (Dec) from

2023

FY 2023

$ Inc (Dec) from

2023

Proposed 9/12/2023 FY 2024 Budget Page 3 of 88

343910

Right-Of-Way-Donation

$1,150

$620

$300

$538

$833

$300

$0

0%

341391

Administrative Fee

$225

$200

$500

$25

$50

$200

($300)

-60%

349300

NSF Check Fee

$30

$90

$300

$60

$270

$150

($150)

-50%

322903

Microfilming Fees

$1,097

$934

$400

$54

$92

$100

($300)

-75%

321207

Pawn Shop

$100

$75

$45

$75

$0

($45)

-100%

321213

Administrative Variance Commercial

$700

$0

$1,700

$0

$6,058

$0

($1,700)

-100%

323109

Mechanical

$37,147

$27,987

$44,000

$0

($44,000)

-100%

331150

Categorical Indirect

$3,624

$1,925

$0

0%

331210

Direct (from other governments)

$8,409

$28,573

$0

$10,944

$0

0%

331250

Indirect

$3,670

$0

0%

341900

Other Fees

$1,194

$135

$1,000

$0

($1,000)

-100%

341910

Election Qualifying Fee

$5,550

$0

0%

342126

Expungements

$25

$0

$50

$25

$50

$0

($50)

-100%

342127

Rad Kids Program

$0

$25

$0

$30

$0

0%

342140

Incident Reports

$20

$821

$0

$10

$17

$0

0%

389000

Other Misc. Revenue

$14,216

$29,641

$0

$63,130

$0

0%

392100

Sale Of Assets

$156,027

$103,937

$0

$44,034

$0

0%

Total Other Revenues

$9,582,177

$6,127,551

$5,898,315

$4,513,430

$5,714,857

$5,430,950

-$467,365

-8%

TOTAL REVENUES

$69,124,443

$72,295,104

$71,575,971

$38,719,309

$78,056,060

$78,035,155

$6,459,184

8%

391000

Operating Transfers In

$0

$1,200,000

$0

($1,200,000)

399999

Use Of Reserves - Budget

$0

$1,804,047

$822,897

($981,150)

REVENUES + USE OF FUND BALANCE

$69,124,443

$72,295,104

$74,580,018

$41,723,356

$81,060,107

$78,858,052

$4,278,034

8%

Proposed 9/12/2023 FY 2024 Budget Page 4 of 88

Revenue Detail: Local Option Sales Tax

29,500,000$ of 78,035,155$

37.8%

of

Projected Revenues

Purpose

Mechanics

Current Rate

Projection

Local Option Sales Tax (LOST) is intended to be used to assist funding services provided including police and fire protection, streets, roads, parks, and recreational

programs. In short, LOST revenues expand the total revenues available to the City to pay for services that would otherwise be paid for out of property taxes.

The FY2024 revenue projection reflects an increase of 9.3% over the FY2023 budgeted revenues and is based on a review of historical actuals and projected total

receipts for FY2023.

A one percent (1%) sales and use tax is charged within Fulton County and collected

by the State Revenue Commissioner. The collected funds are distributed to the cities

and counties, on a monthly basis, in accordance with the formula in the Certificate of

Distribution.

The City receives 7.3493% of the one percent sales and use tax collected in Fulton

County. The distribution percentage is a negotiated amount (approved by Council in

Resolution 2022-11-33 in November 2022).

$16

$17

$18

$19

$20

$21

$22

$23

$24

$25

$26

$27

$28

$29

$30

$31

FY2021 Actuals FY2022 Actuals FY 2023 Revised FY 2023 Annualized FY 2024 Proposed

$23,829,144 $28,164,964 $27,000,000 $27,936,276 $29,500,000

Millions

Local Option Sales Tax

Sales Tax

(LOST)

37.8%

Sales Tax

(LOST) 37.8%

Proposed 9/12/2023 FY 2024 Budget Page 5 of 88

Revenue Detail: Real and Personal Property Tax

22,345,205$ of 78,035,155$

Including Current and Prior Year

28.6%

of

Projected Revenues

Purpose

Mechanics

Current Rate

Projection

FY2024 revenues will be impacted by the three factors (the millage rate, percentage received in fiscal year, percentage of collections) and changes in the 2023 Tax

Digest (growth and reassessment). For the purpose of projecting FY2024 collections (to be received in October and November 2024), staff has made the following

assumptions. A millage rate of $3.646 per $1,000 of taxable value was utilized for the FY2024 Budget preparation. Additional assumptions include, on-time billing

by Fulton (4% of FY2023 property taxes and 96% of FY2024 property taxes will be collected in FY2024). Secondly, collections are anticipated at 97% of billed taxes

(based on historical collection rates from FY2012 - FY2018). Third, staff has assumed Council will capture the 2024 Tax Digest growth from reassessments and

new construction and $200M growth to the tax digest.

FY2023 revenues have not yet been received (anticipated to be collected in October and November 2023) and are impacted by three factors - the millage rate, the

timing of billing, and the percentage of collections. The Council sets the millage rate in the summer (after the digest is received from Fulton County). Fulton County

has indicated the preparation of the digest is on-time and anticipates the billing of the FY2023 taxes will be completed in August 2023 so 96% of revenues should be

received within a time period that will be recognized for FY2023. Finally, FY2023 collections will be impacted by appeals. Based on historical trends, collections are

anticipated at 97% of the billed taxes. The graph below reflects FY2023 revenue in the annualized amount including $2.3M in one-time revenue from prior year

appeals that have now been settled. The increased amount of prior year collections is not forecasted to continue into FY2024.

Real and Personal Property Tax is for the purpose of generating revenues to defray the costs of operating the City, provide governmental services, repay principal

and interest on general obligation bonds, and for any other public purpose as determined by the City Council in its discretion.

The revenue projection FY2024 is a 3.4% increase compared to FY2023 budgeted numbers and assumes a millage rate of 3.646 mills.

Each year the City Council establishes a millage rate for the City property tax. The

millage rate is capped by the Charter at 4.731 unless a higher millage rate is

recommended by resolution of the City Council and subsequently approved by a

majority of the qualified voters of the City voting in a referendum.

The 2023 millage rate was set at the August 8, 2023 Council Meeting. The 2023

millage rate is 3.646 mills or $3.646 for every $1,000 of net assessed value. When

forecasting property tax revenue for FY2024, a millage rate of 3.646 mills was

utilized. The actual FY2024 rate will be set in the summer of 2024 once the Tax

Digest is received from Fulton County.

$-

$5

$10

$15

$20

$25

FY2021 Actuals FY2022 Actuals FY 2023 Revised FY 2023 Annualized FY 2024 Proposed

$19,240,185 $20,419,902 $21,609,256 $23,316,000 $22,345,205

Millions

Real and Personal Property Tax

(including current and prior year)

Property Tax

28.6%

Proposed 9/12/2023 FY 2024 Budget Page 6 of 88

Revenue Detail: Insurance Premium Tax

6,800,000$ of 78,035,155$

8.7%

of

Projected Revenues

Purpose

Mechanics

Current Rates

Projection

The Insurance Premium Tax is levied on gross direct premiums on life, accident, and sickness insurance policies written on persons residing within the boundaries

of the City, and other types of insurance policies written by all companies doing business in the State of Georgia.

The FY2024 revenue projection reflects an increase of 3% over the FY2023 budgeted revenues and is based on a review of historical actuals and projected total

receipts for FY2023.

Insurance Premium Taxes are collected by the Georgia Commissioner of Insurance

and distributed to municipalities based on premiums allocated on a population ratio

formula (the population of Johns Creek divided by the population of all other

municipalities in Georgia). The tax is distributed in a lump sum payment each fall.

The current rates are one percent (1%) on gross direct premiums for life, accident,

and sickness policies, and two and a half percent (2.5%) on gross premiums of all

other types of insurance.

$3.0

$3.5

$4.0

$4.5

$5.0

$5.5

$6.0

$6.5

$7.0

FY2021 Actuals FY2022 Actuals FY 2023 Revised FY 2023 Annualized FY 2024 Proposed

Series1

$6,362,964 $6,724,630 $6,600,000 $6,600,000 $6,800,000

Millions

Insurance Premium Tax

Insurance

Premium

Tax

9.7%

Insurance

Premium

Tax 8.7%

Proposed 9/12/2023 FY 2024 Budget Page 7 of 88

Revenue Detail: Motor Vehicle TAVT

4,000,000$ of 78,035,155$

5.1%

of

Projected Revenues

Purpose

Mechanics

Current Rate

Projection

The recent change to the tax percentage split and the increase number of Johns Creek residents purchasing new cars continue to be reflected in the revenue

projection.

In 2012, the Georgia General Assembly passed House Bill 386 which changed the way motor vehicles are taxed in Georgia. Under prior law, motor vehicles were

generally subject to Sales Tax at the time of purchase and an Annual Ad Valorem Tax every year thereafter. Under House Bill 386, motor vehicles titled in Georgia

on or after March 1, 2013 are subject to a one-time TAVT and are exempt from Sales Tax and Annual Ad Valorem Tax.

The current TAVT Rate is 7% of the vehicles fair market value at the time of

purchase.

The FY2024 revenue projection reflects a 17.6% increase over the FY2023 budgeted revenues and is based on a review of historical actuals and projected total

receipts for FY2023.

The 7% Tax is collected by Georgia Department of Revenue (GDOR). Effective July

1, 2019, GDOR retains 35% and distributes the remaining 65% to Fulton County

based on sales within that part of the county. Fulton County then distributes the

funds to government entities within Fulton County based on location of the buyer.

MARTA first receives a fixed amount drawn prorata from all Fulton County

collections. The remaining amount is distributed between Fulton County School

District (49%), Fulton County (28%) and the City of Johns Creek (23%)

$1.0

$1.5

$2.0

$2.5

$3.0

$3.5

$4.0

$4.5

FY2021 Actuals FY2022 Actuals FY 2023 Revised FY 2023 Annualized FY 2024 Proposed

$2,759,142 $3,214,224 $3,400,000 $3,734,012 $4,000,000

Millions

Motor Vehicle TAVT

Motor Vehicle

TAVT 5.1%

Proposed 9/12/2023 FY 2024 Budget Page 8 of 88

Revenue Detail: Electric Franchise Fees

3,000,000$ of 78,035,155$

3.8%

of

Projected Revenues

Purpose

Mechanics

Current Rate

Projection

Franchise fees are implemented as part of a service agreement executed between the City and a utility company that grants the company usage of the City's right-of-

way. The fees are intended to reimburse the City for the use and maintenance of the right-of-way. Traditionally, the fees are also viewed as compensation for the

awarding by local governments of exclusive rights to specific public utility companies to provide service in specific areas.

The City currently collects electric franchise fees from two electricity providers:

Georgia Power and Sawnee EMC. Georgia Power remits its payments annually,

while Sawnee remits its payments quarterly.

The current electric franchise fee rate is four percent (4%) of total electricity sales

receipts.

The FY2024 revenue projection reflects a 11.1% increase over the FY2023 budgeted revenues and is based on a review of historical actuals and projected total

receipts for FY2023.

$-

$0.5

$1.0

$1.5

$2.0

$2.5

$3.0

$3.5

FY2021 Actuals FY2022 Actuals FY 2023 Revised FY 2023 Annualized FY 2024 Proposed

$2,475,251 $2,645,999 $2,700,000 $2,953,168 $3,000,000

Millions

Electric Franchise Fees

Electric Franchise

Fees 3.8%

Proposed 9/12/2023 FY 2024 Budget Page 9 of 88

Revenue Detail: Business & Occupation Tax

2,000,000$ of 78,035,155$

2.6%

of

Projected Revenues

Purpose

Mechanics

Current Rate

Projection

Business and Occupation Taxes are taxes imposed on businesses located within the City for the purpose of generating revenue for the provision of local

government services.

City Council adopts a schedule of fees establishing the taxation method and scale for

occupations within the City. The current methodology utilizes a combination of

profitability ratios, gross receipts, and number of employees to reach a final tax

number. Businesses must pay their occupation taxes annually by March 31 and state

law mandates that the occupation tax for a new business be paid within thirty (30)

days of commencing the business.

The current rate establishes twenty four (24) profitability ratio tiers based on NAIC

(North American Industry Classification) codes with corresponding tax rates, ranging

from $0.50 to $2.20 per thousand dollars gross revenue. The tax rate increases

based on the profitability of the business. An additional $13 per employee tax and a

$75 administrative fee is included in the final taxes due. Professional practitioners, as

identified by state law, may choose to pay a $400 flat rate in lieu of the gross

receipt/profitability ratio classification.

The FY2024 revenue projection reflects a 12.4% increase over the FY2023 budgeted revenues and is based on a review of historical actuals and projected total

receipts for FY2023.

$-

$0.5

$1.0

$1.5

$2.0

$2.5

FY2021 Actuals FY2022 Actuals FY 2023 Revised FY 2023 Annualized FY 2024 Proposed

$1,816,703 $1,914,255 $1,780,000 $2,010,883 $2,000,000

Millions

Business & Occupation Tax

Business &

Occupation

Tax 2.6%

Proposed 9/12/2023 FY 2024 Budget Page 10 of 88

Revenue Detail: Interest Earnings

1,700,000$ of 78,035,155$

2.2%

of

Projected Revenues

Purpose

Mechanics

Current Rate

Projection

Interest earnings are generated from the City's investable cash balance.

Interest is paid monthly to the City from funds on deposit at various financial

institutions.

The current rate for all of our financial investments are detailed in a Quarterly

Investment Report. As of March 31, 2023, interest earning rates ranged from 0.15% -

1.58% amongst three financial institutions.

The FY2024 revenue projection reflects a 2733.3% increase over the FY2023 budgeted revenues and is based on a review of historical actuals and projected total

receipts for FY2024. Working with an Investment Advisor, the City will seek to maximize the interest earnings on investable funds while maintaining focus on safety

of principal and sufficient liquidity to meet the needs of the City, while attaining a market rate of return throughout budgetary and economic cycles.

$-

$0.5

$1.0

$1.5

$2.0

$2.5

FY2021 Actuals FY2022 Actuals FY 2023 Revised FY 2023 Annualized FY 2024 Proposed

$44,342 $257,656 $60,000 $2,323,815 $1,700,000

Millions

Interest Earnings

2.2%

Proposed 9/12/2023 FY 2024 Budget Page 11 of 88

Revenue Detail: Municipal Court Fees

1,250,000$ of 78,035,155$

1.6%

of

Projected Revenues

Purpose

Mechanics

Current Rate

Projection

Municipal Court Fees are payments to the Court for citations issued for traffic and municipal ordinance violations.

Municipal Court sentences require specific payments for violations of traffic laws and

municipal ordinances as deterrence for offenses committed within the City's

jurisdiction.

Fines issued by the Municipal Court reflect consistent fee amounts with the

standardized maximum amount varying according to violation and statute.

The FY2024 revenue projection reflects a 68.9% increase from the FY2023 budgeted revenues and is based on a review of historical actuals and projected total

receipts for FY2023.

$500,000

$600,000

$700,000

$800,000

$900,000

$1,000,000

$1,100,000

$1,200,000

$1,300,000

$1,400,000

$1,500,000

FY2021 Actuals FY2022 Actuals FY 2023 Revised FY 2023 Annualized FY 2024 Proposed

$974,857 $914,873 $740,000 $1,411,711 $1,250,000

Municipal Court Fees

Municipal Court

Fees 1.6%

Proposed 9/12/2023 FY 2024 Budget Page 12 of 88

Revenue Detail: Gas Franchise Fees

1,009,000$ of 78,035,155$

1.3%

of

Projected Revenues

Purpose

Mechanics

Current Rate

Projection

Franchise fees are collected per an agreement executed between the City and a utility company that grants the company usage of the City's right-of-way. The fees

are intended to reimburse the City for the use and maintenance of the right-of-way. Traditionally, the fees are also viewed as compensation for the awarding by local

governments of exclusive rights to specific public utility companies to provide service in specific areas.

The City currently collects gas franchise fees from one natural gas provider: Atlanta

Gas Light. AGL remits its payments quarterly.

The current gas franchise fee rate is roughly three percent (3%) of total gas sales

receipts. It is calculated by using the base year franchise fee factor multiplied by the

inflation index and the design day capacity of the last day of the previous fiscal year.

The FY2024 revenue projection reflects an increase of 3.1% over the FY2023 budgeted revenues and is based on a review of historical actuals and projected total

receipts for FY2023.

$-

$200,000

$400,000

$600,000

$800,000

$1,000,000

$1,200,000

FY2021 Actuals FY2022 Actuals FY 2023 Revised FY 2023 Annualized FY 2024 Proposed

$1,076,596 $931,851 $978,400 $971,067 $1,009,000

Gas Franchise Fees

1.3%

Proposed 9/12/2023 FY 2024 Budget Page 13 of 88

Revenue Detail: Alcohol Beverage Excise Tax

1,000,000$ of 78,035,155$

1.3%

of

Projected Revenues

Purpose

Mechanics

Current Rate

Projection

The Alcohol Beverage Excise Tax is an excise tax imposed on the sales of alcoholic beverages within the City for the purpose of raising revenue for City operations.

The FY2024 revenue projection reflects an increase of 23.5% from the FY2023 budgeted revenues and is based on a review of historical actuals and projected total

receipts for FY2023. Liquor by the drink sales have decreased since the onset of the pandemic and are anticipated to return to pre-pandemic level.

Alcoholic Beverage Excise Taxes are established by the City Council as part of the

Schedule of Fees and are paid monthly to the City by applicable businesses.

The current excise tax rate is three percent (3%) on all liquor by the drink. For all

wine and liquor sold by wholesalers to retailers in the City, the excise tax rate is

$0.22 per liter or $0.00065 per ounce. The excise tax rate to be paid by the

wholesalers is $0.05 per 12 ounces of beer in smaller containers and $6.00 per

container of draft beer.

$500,000

$600,000

$700,000

$800,000

$900,000

$1,000,000

$1,100,000

$1,200,000

FY2021 Actuals FY2022 Actuals FY 2023 Revised FY 2023 Annualized FY 2024 Proposed

$963,082 $979,200 $810,000 $1,084,271 $1,000,000

Alcohol Beverage Excise

Alcohol Beverage

Excise Tax 1.3%

Proposed 9/12/2023 FY 2024 Budget Page 14 of 88

Personnel

City Clerk

3

Full Time

1

Part Time

(1) Part Time Administrative Worker

City Council

1

Full Time

(7) Part Time Elected Official, (1) Executive Aide to Mayor

7

Part Time

City Manager

6

Full Time

0

Part Time

Communications

4

Full Time

0

Part Time

Community Development

20

Full Time

0

Part Time

Court

4

Full Time

(1) Municipal Court Administrator, (3) Assistant Court Clerk

1

Part Time

(1) Part Time Administrative Worker

Facilities

0

Full Time

0

Part Time

Finance

12

Full Time

0

Part Time

Fire

89

Full Time

0

Part Time

Human Resources

4

Full Time

0

Part Time

IT/GIS

7

Full Time

0

Part Time

Legal

0

Full Time

Contracted

0

Part Time

The base personnel presented parallel the 255 current full-time staff as authorized in the revised FY2023 Budget. As with prior years, the public safety

personnel make up the bulk (186 positions or 73%) of the City's personnel. The FY2024 Budget is not requesting any additional personnel.

(1) City Clerk, (1) Assistant City Clerk, (1) City Records Manager

(1) Fire Chief, (2) Deputy Fire Chief, (1) Fire Marshal, (1) Fire Captain, Support Services, (1) Fire Captain, Deputy

Fire Marshal, (1) Fire Lieutenant, EMS & Training Officer, (1) Fire Lieutenant, Training Division, (1) Executive

Assistant, (1) Fire Community Outreach Coordinator, (3) Fire Battalion Chief EMT/Paramedic, (9) Fire Captain EMT,

(3) Fire Captain Paramedic, (3) Fire Lieutenant Paramedic, (16) Fire Apparatus Operator EMT, (2) Fire Apparatus

Operator Paramedic, (20) Firefighter Paramedic, (12) Firefighter EMT, (4) Firefighter EMT Cadet, (6)

Firefighter/Cadet, (1) Building Superintendent

(1) HR Director, (1) Sr. HR Generalist, (1) HR Generalist, (1) Executive Assistant

(1) IT Director, (1) Applications Support Manager, (1) IT Systems Manager, (1) Senior IT Technician, (1) IT

Technician (1) GIS Analyst II, (1) IT Applications Analyst

(1) Community Development Director, (1) Assistant Community Development Director, (1) Land Development

Manager, (1) Environmental Compliance Manager, (2) Land Development Inspector II / Site Inspector, (1) Chief Code

Compliance Officer, (1) Code Compliance Officer, (1) Administrative Assistant, (1) Planner III, (1) Planner II, (1)

Community Development Coordinator, (1) Business Solutions Analyst, (1) Receptionist, (1) Chief Building Officer, (1)

Building Inspector, (1) Plans Examiner, (1) Plans Coordinator, (2) Permit Technician

Facilities personnel included in Fire Department to reflect reporting structure

(1) Finance Director, (1) Controller, (1) Finance Manager, (1) Risk Manager, (1) Purchasing Manager, (1) Revenue

Manager, (1) Accountant, (1) Finance Analyst, (1) Executive Assistant, (1) A/P Specialist, (1) Revenue Specialist, (1)

Revenue Technician

(1) City Manager, (2) Assistant City Manager, (1) Economic Development Director, (1) Assistant to City Manager, (1)

Executive Assistant

(1) Communications Director, (1) Senior Communications Manager, (1) Electronic Communications Manager, (1)

Digital Production Manager

Proposed 9/12/2023 FY 2024 Budget Page 15 of 88

Police

97

Full Time

7

Part Time

Public Works

0

Full Time

All positions are contracted

0

Part Time

Recreation and Parks

8

Full Time

12 Part Time

Total Personnel 255 Full Time

(6) Part Time Recreation Leader, (2) Part Time Recreation Leader - Cauley Creek, (2) Part Time Recreation Leader

II's, (1) Part Time Swim Coach, (1), Part Time Assistant Swim Coach

(6) Retired Officer Program PT

80 Sworn Positions: (1) Police Chief, (2) Major, (1) Captain, (9) Lieutenant, (8) Sergeant, (11) Corporal, (48) Officer

17 Civilian Positions: (2) Crime Scene Investigator, (1) Police Records Manager, (1) Assistant Police Records

Manager, (6) Police Records Clerk, (1) Police Admin Operations Manager, (1) Executive Assistant, (1) Administrative

Assistant, (2) Maintenance Worker, (1) Fleet Manager, (1) Mental Health Clinician

(1) Mental Health Advocate PT

(1) Recreation and Parks Director, (1) Capital Projects Manager, (1) Field Superintendent, (1) Recreation Manager,

(1) Recreation Coordinator - Cauley Creek, (1) Recreation Coordinator, (1) Park Place Coordinator, (1) Special

Events Coordinator

Proposed 9/12/2023 FY 2024 Budget Page 16 of 88

Departmental Summaries

FY 2021

FY2022

FY2024

Department

Actuals

Revised

YTD 07/31

Annualized

Proposed

1001330

City Clerk

$367,609

$636,909

$894,903

$795,408

$875,375

$959,034

$64,131

7%

Personnel

$339,792

$294,946

$381,590

$305,625

$366,407

$433,199

$51,609

14%

Operations

$27,817

$341,962

$513,313

$489,784

$508,968

$525,835

$12,522

2%

1001310

City Council

$164,130

$287,770

$357,938

$250,670

$361,606

$376,007

$18,069

5%

Personnel

$121,446

$187,122

$219,384

$186,391

$222,759

$231,140

$11,756

5%

Operations

$42,685

$100,649

$138,554

$64,279

$138,847

$144,867

$6,313

5%

1001320

City Manager

$3,730,404

$1,002,670

$1,594,313

$1,055,464

$1,542,760

$1,842,552

$248,239

16%

Personnel

$709,506

$824,229

$1,173,165

$922,319

$1,112,923

$1,337,019

$163,854

14%

Operations

$3,020,898

$178,441

$421,148

$133,145

$429,837

$505,533

$84,385

20%

1001570

Communications

$608,541

$791,448

$820,186

$663,003

$814,587

$891,461

$71,275

9%

Personnel

$557,841

$598,684

$635,792

$535,703

$638,086

$684,116

$48,324

8%

Operations

$50,700

$192,765

$184,394

$127,301

$176,501

$207,345

$22,951

12%

1007410

Community Development

$2,223,290

$2,246,410

$2,513,229

$1,930,090

$2,262,986

$2,761,241

$248,012

10%

Personnel

$1,656,080

$2,140,353

$2,319,783

$1,770,732

$2,081,022

$2,570,656

$250,873

11%

Operations

$567,210

$106,058

$193,446

$159,358

$181,964

$190,585

($2,861)

-1%

1002650

Court

$643,619

$643,180

$746,726

$530,424

$686,474

$799,045

$52,319

7%

Personnel

$423,358

$429,246

$477,857

$351,907

$422,990

$511,011

$33,154

7%

Operations

$220,261

$213,934

$268,869

$178,518

$263,484

$288,034

$19,165

7%

1001565

Facilities

$2,649,116

$2,616,178

$2,806,805

$648,500

$2,532,536

$2,785,449

($21,356)

-1%

Personnel

$84,431

($2,677)

$0

0%

Operations

$2,564,685

$2,618,855

$2,806,805

$648,500

$2,532,536

$2,785,449

($21,356)

-1%

1001511

Finance

$1,421,785

$1,600,060

$2,134,101

$1,788,522

$2,044,786

$2,296,930

$162,829

8%

Personnel

$1,209,455

$1,415,349

$1,569,110

$1,260,037

$1,486,692

$1,707,722

$138,612

9%

Operations

$212,331

$184,710

$564,991

$528,484

$558,094

$589,208

$24,217

4%

1003510

Fire

$9,795,043

$10,043,327

$12,876,519

$10,709,220

$12,632,608

$14,313,781

$1,437,262

11%

Personnel

$9,085,166

$9,136,246

$11,705,209

$9,756,287

$11,546,370

$13,034,683

$1,329,474

11%

Operations

$709,877

$907,081

$1,171,310

$952,933

$1,086,238

$1,279,098

$107,788

9%

1001540

Human Resources

$958,969

$895,904

$682,587

$487,858

$614,060

$895,504

$212,917

31%

Personnel

$507,252

$442,175

$494,505

$362,447

$427,512

$634,096

$139,591

28%

Operations

$451,717

$453,729

$188,082

$125,412

$186,548

$261,408

$73,326

39%

1001535

IT/GIS

$2,097,765

$2,259,071

$2,342,998

$2,039,837

$2,458,435

$2,557,977

$214,979

9%

Personnel

$991,692

$975,500

$1,026,102

$896,405

$1,060,404

$1,127,570

$101,468

10%

Operations

$1,106,073

$1,283,571

$1,316,896

$1,143,432

$1,398,031

$1,430,407

$113,511

9%

1001530

Legal

$430,890

$371,325

$450,000

$296,926

$450,000

$0

0%

Personnel

$0

0%

Operations

$430,890

$371,325

$450,000

$296,926

$450,000

$0

0%

1003210

Police

$9,990,977

$10,639,051

$14,761,815

$11,164,867

$13,736,740

$15,539,346

$777,531

5%

Personnel

$8,252,661

$8,428,763

$12,145,899

$9,398,446

$11,134,413

$12,937,016

$791,117

7%

Operations

$1,738,316

$2,210,288

$2,615,916

$1,766,420

$2,602,327

$2,602,330

($13,586)

-1%

1004110

Public Works

$6,147,016

$6,258,338

$6,618,741

$4,590,251

$6,562,096

$6,857,636

$238,895

4%

Personnel

($5,671)

$45

$0

0%

Operations

$6,152,686

$6,258,293

$6,618,741

$4,590,251

$6,562,096

$6,857,636

$238,895

4%

1006110

Recreation and Parks

$2,052,590

$2,179,382

$3,932,832

$1,965,398

$3,596,511

$4,433,385

$500,553

13%

Personnel

$314,947

$322,483

$882,806

$402,974

$556,229

$1,406,199

$523,393

59%

Operations

$1,737,642

$1,856,899

$3,050,026

$1,562,424

$3,040,282

$3,027,186

($22,840)

-1%

Total - All Departments

$43,281,742

$42,471,025

$53,533,693

$38,916,438

$51,171,560

$57,759,348

$4,225,655

8%

Total - Personnel $24,247,954 $25,192,465 $33,031,202 $26,149,273 $31,055,807 $36,614,427 $3,583,225 11%

Total - Operations $19,033,788 $17,278,559 $20,502,491 $12,767,165 $20,115,753 $21,144,921 $642,430 3%

% Inc

(Dec)

FY2023

$ Inc (Dec)

from 2023

Proposed 9/12/2023 FY 2024 Budget Page 17 of 88

City Clerk (1001330)

1001330

Personnel

FY 2021

FY 2022

FY 2024

Object

Account

Actuals

Revised

YTD 07/31

Annualized

Proposed

511100

Regular Employees

$256,801

$220,674

$274,191

$220,829

$263,232

$306,522

$32,331

12%

511151

Car Allowance

$3,021

$3,621

$3,600

$3,000

$3,600

$0

0%

511200

Temporary/PT Employee

$8,432

$7,486

$8,736

$9,998

$12,872

$8,736

$0

0%

512101

Health

$19,449

$13,709

$27,685

$17,965

$21,710

$30,618

$2,933

11%

512102

Long-Term Disability

$1,599

$1,389

$1,197

$1,345

$1,631

$1,710

$513

43%

512103

Dental

$2,060

$1,715

$3,015

$1,801

$2,151

$2,546

($469)

-16%

512104

Life

$1,201

$3,722

$1,910

$2,296

$2,748

$2,800

$890

47%

512200

Social Security (FICA)

$16,142

$14,184

$17,294

$14,159

$16,936

$19,546

$2,252

13%

512300

Medicare

$3,775

$3,317

$4,046

$3,311

$3,961

$4,571

$525

13%

512400

Retirement

$26,562

$24,570

$39,271

$30,422

$37,068

$52,109

$12,838

33%

512700

Workers Compensation

$750

$558

$645

$498

$441

($204)

-32%

Subtotal - Personnel

$339,792

$294,946

$381,590

$305,625

$366,407

$433,199

$51,609

14%

Operations

FY 2021

FY 2022

FY 2024

Object

Account

Actuals

Revised

YTD 07/31

Annualized

Proposed

521203

Contractual

$6,635

$9,846

$20,875

$14,404

$20,875

$21,500

$625

3%

521204

Election

$0

$311,725

$465,312

$462,309

$462,310

($3,002)

-1%

523300

Advertising

$4,475

$2,409

$5,500

$3,638

$5,500

$0

0%

523400

Printing & Binding

$84

$202

$200

$105

$200

$300

$100

50%

523500

Travel

$1,523

$3,691

$8,201

$2,350

$8,201

$17,300

$9,099

111%

523600

Dues & Fees

$1,024

$8,599

$1,289

$810

$860

$1,289

$0

0%

523700

Education & Training

$4,984

$3,302

$5,511

$4,752

$5,511

$11,211

$5,700

103%

523901

Hospitality

$102

$350

$750

$227

$750

$0

0%

523905

Recording Fees

$151

$159

$575

$279

$430

$575

$0

0%

531000

Supplies

$15

$585

$3,500

$77

$3,500

$0

0%

531120

Office Supplies

$2,004

$977

$1,300

$751

$1,300

$0

0%

531130

Postage

$262

$116

$300

$81

$300

$0

0%

531703

Operating Supplies

$6,559

$0

0%

Subtotal - Operations

$27,817

$341,962

$513,313

$489,784

$508,968

$525,835

$12,522

2%

TOTAL CITY CLERK

$367,609

$636,909

$894,903

$795,408

$875,375

$959,034

$64,131

7%

% Inc

(Dec)

% Inc

(Dec)

FY 2023

$ Inc (Dec)

from 2023

FY 2023

$ Inc (Dec)

from 2023

Proposed 9/12/2023 FY 2024 Budget Page 18 of 88

City Clerk (1001330)

Contractual - Items Described

Vendor Name

Cost per

Units

Total

Code Book Updates and Web Hosting

Municode

$10,500

1

$10,500

Online Records Request Portal

GovQA

$8,500

1

$8,500

Online State Reporting

Easy Vote

$2,500

1

$2,500

521203

$21,500

Election - Items Described

Vendor Name

Cost per

Units

Total

2023 Municipal Election (November) and Runoff (December)

Fulton County

$462,310

1

$462,310

521204

$462,310

Advertising - Items Described

Vendor Name

Cost per

Units

Total

Legal Ads

Johns Creek Herald

$100

30

$3,000

Other Ads

AJC

$500

5

$2,500

523300

$5,500

Printing and Binding - Items Described

Vendor Name

Cost per

Units

Total

Public Comment Cards

Fed Ex - Allegra

$100

3

$300

523400

$300

Travel - Items Described

Vendor Name

Cost per

Units

Total

Clerks Travel (includes Asst. Clerk)

GMA/IIMC

$1,900

4

$7,600

Assistant Clerk Travel

$1,700

1

$1,700

Records Mgr Travel

GRA/ARMA Regional Mtgs

$4,000

1

$4,000

Tyler Conference Travel Tyler $2,000 2 $4,000

523500

$17,300

Dues and Fees - Items Described

Vendor Name

Cost per

Units

Total

Records Management Association

ARMA

$225

1

$225

Georgia Records Association

GRA

$45

1

$45

International Institute of Municipal Clerks

IIMA

$195

2

$390

Association of Imaging and Information Management

AIIM

$179

1

$179

Georgia Clerks and Finance Officers Association

GMC/FOA

$225

2

$450

523600

$1,289

Education and Training - Items Described

Vendor Name

Cost per

Units

Total

IIMC Conference

IIMC

$1,000

1

$1,000

GMC Conference

GMC/FOA

$1,000

2

$2,000

GMC Regional Training

Carl Vinson

$150

4

$600

GMA Conference

GMA

$800

1

$800

ARMA International Conference

ARMA

$1,500

1

$1,500

ARMA Meetings

ARMA

$29

9

$261

Webinar Training Opportunities

various

$100

4

$400

Tyler User Conference

Tyler

$1,400

2

$2,800

GARVIS Conference SOS $700 1 $700

Other Election Training

SOS

$800

1

$800

GRA Conference

Georgia Records Association

$350

1

$350

523700

$11,211

Hospitality - Items Described

Vendor Name

Cost per

Units

Total

Georgia Clerks Meetings

Various

$100

2

$200

Internal Staff Training

Various

$100

4

$400

Regional Records Round Table Meeting

Various

$150

1

$150

523901

$750

Recording Fees - Items Described

Vendor Name

Cost per

Units

Total

Printing Records for GSCCCA

GSCCCA

$25

11

$275

Recordings

GSCCCA

$25

12

$300

FY 2024 Proposed Operations

Proposed 9/12/2023 FY 2024 Budget Page 19 of 88

523905

$575

Supplies - Items Described

Vendor Name

Cost per

Units

Total

Shredding Services

Shred Ahead

$250

6

$1,500

Basic Office Supplies - Folders, Pens, Etc.

Office Depot, Staples, etc.

$2,000

1

$2,000

531000

$3,500

Office Supplies - Items Described

Vendor Name

Cost per

Units

Total

Clerk-specific supplies (archival paper, notary seal, proclamation seals and ribbon)

$650

2

$1,300

531120

$1,300

Postage - Items Described

Vendor Name

Cost per

Units

Total

Letters and Mailings

USPS

$1

600

$300

531130

$300

$525,835

Proposed 9/12/2023 FY 2024 Budget Page 20 of 88

City Council (1001310)

1001310

Personnel

FY 2021

FY 2022

FY 2024

Object

Account

Actuals

Revised

YTD 07/31

Annualized

Adopted

511100

Regular Employees

$112,113

$166,559

$189,784

$158,032

$188,964

$196,187

$6,403

3%

511151

Car Allowance

$50

$3,971

$4,800

$4,000

$4,800

$0

0%

511153

Gym Membership

$491

$0

0%

512101

Health

$0

0%

512102

Long-Term Disability

$0

$358

$401

$381

$460

$486

$85

21%

512103

Dental

$0

0%

512104

Life

$0

$631

$638

$649

$775

$742

$104

16%

512200

Social Security (FICA)

$6,951

$10,586

$12,066

$10,060

$12,030

$12,164

$98

1%

512300

Medicare

$1,626

$2,476

$2,825

$2,353

$2,814

$2,845

$20

1%

512400

Retirement

$0

$2,202

$8,729

$10,574

$12,574

$13,802

$5,073

58%

512700

Workers Compensation

$215

$339

$141

$342

$114

($27)

-19%

Subtotal - Personnel

$121,446

$187,122

$219,384

$186,391

$222,759

$231,140

$11,756

5%

Operations

FY 2021

FY 2022

FY 2024

Object

Account

Actuals

Revised

YTD 07/31

Annualized

Adopted

521200

Professional Services

$9,573

$3,313

$4,000

$615

$4,000

$0

0%

521207

Other Professional Services

$0

$3,351

$0

$485

$0

0%

523500

Travel

$1,334

$13,868

$40,750

$13,459

$40,750

$0

0%

523600

Dues & Fees

$29,017

$22,930

$31,785

$26,306

$31,785

$33,098

$1,313

4%

523700

Education & Training

$1,732

$15,998

$16,300

$6,616

$16,300

$0

0%

523901

Hospitality

$33

$8,626

$12,000

$4,908

$12,000

$17,000

$5,000

42%

523906

Local Grant Match

$0

$30,000

$10,000

$30,000

$0

0%

531000

Supplies

$89

$307

$700

$24

$700

$0

0%

531120

Office Supplies

$870

$1,007

$3,000

$1,258

$2,200

$3,000

$0

0%

531130

Postage

$14

$0

$19

$0

$19

$0

0%

531703

Operating Supplies

$24

$1,249

$0

$608

$0

0%

Subtotal - Operations

$42,685

$100,649

$138,554

$64,279

$138,847

$144,867

$6,313

5%

TOTAL CITY COUNCIL

$164,130

$287,770

$357,938

$250,670

$361,606

$376,007

$18,069

5%

% Inc

(Dec)

FY 2023

$ Inc (Dec)

from 2023

$ Inc (Dec)

from 2023

% Inc

(Dec)

Proposed 9/12/2023 FY 2024 Budget Page 21 of 88

City Council (1001310)

Professional Services - Items Described

Vendor Name

Cost per

Units

Total

Professional Services

Various

$250

16

$4,000

521200

$4,000

Travel - Items Described

Vendor Name

Cost per

Units

Total

Mileage Reimbursements

Various

$4,000

1

$4,000

Travel Costs for Training

Various

$500

17

$8,500

Per Diem for Education and Training Opportunities

Various

$20

50

$1,000

Retreat Hotel and Meals

Various

$15,000

1

$15,000

Hotels - GMA and Cities United Summit

Various

$250

49

$12,250

523500

$40,750

Dues and Fees - Items Described

Vendor Name

Cost per

Units

Total

Georgia Municipal Association

GMA

$27,558

1

$27,558

Newspaper Subscription

AJC

$15

12

$180

Industry Publication

Atlanta Business Chronicle

$11

10

$110

Professional Organizations

Various

$300

5

$1,500

Dinners and Luncheons

Various

$50

75

$3,750

523600

$33,098

Education and Training - Items Described

Vendor Name

Cost per

Units

Total

GMA Annual Conference (in Savannah)

Georgia Municipal Association

$950

7

$6,650

Cities United Annual Conference (in Atlanta)

Georgia Municipal Association

$450

7

$3,150

Training Courses for Elected Officials

Carl Vinson Institute

$650

10

$6,500

523700

$16,300

Hospitality - Items Described

Vendor Name

Cost per

Units

Total

Hosting Visiting Dignitaries

Various

$100

20

$2,000

Other Meetings

Various

$50

100

$5,000

MLK Breakfast

Various

$5,000

1

$5,000

State of City Address

Various

$5,000

1

$5,000

523901

$17,000

Local Grant Match

Vendor Name

Cost per

Units

Total

Local Arts Grant

Various

$30,000

1

$30,000

523906

$30,000

Supplies - Items Described

Vendor Name

Cost per

Units

Total

General Supplies

Various

$100

7

$700

531000

$700

Office Supplies - Items Described

Vendor Name

Cost per

Units

Total

Basic Office Supplies - Folders, Pens, etc.

Various

$100

30

$3,000

531120

$3,000

Postage - Items Described

Vendor Name

Cost per

Units

Total

Letters and Mailings

USPS

$1

37

$19

531130

$19

$144,867

FY 2024 Proposed Operations

Proposed 9/12/2023 FY 2024 Budget Page 22 of 88

City Manager (1001320)

1001320

Personnel

FY 2021

FY 2022

FY 2024

Object

Account

Actuals

Revised

YTD 07/31

Annualized

Proposed

511100

Regular Employees

$537,820

$612,070

$853,474

$670,992

$808,228

$950,672

$97,198

11%

511151

Car Allowance

$4,829

$8,800

$14,400

$10,000

$12,400

$14,400

$0

0%

511153

Gym Membership

$315

$92

$0

0%

511200

Temporary/PT Employee

$2,896

$0

0%

512101

Health

$39,754

$56,683

$96,008

$74,243

$89,507

$127,659

$31,651

33%

512102

Long-Term Disability

$3,308

$3,885

$3,842

$3,703

$4,538

$4,521

$679

18%

512103

Dental

$4,520

$4,216

$4,509

$4,540

$5,428

$6,138

$1,629

36%

512104

Life

$2,491

$5,844

$5,966

$6,073

$7,324

$7,998

$2,032

34%

512200

Social Security (FICA)

$27,452

$31,445

$45,831

$34,716

$43,100

$48,901

$3,070

7%

512300

Medicare

$7,554

$8,681

$12,227

$9,446

$11,407

$13,785

$1,558

13%

512400

Retirement

$77,021

$91,617

$136,135

$107,790

$130,176

$161,614

$25,479

19%

512700

Workers Compensation

$1,546

$896

$773

$816

$1,331

$558

72%

Subtotal - Personnel

$709,506

$824,229

$1,173,165

$922,319

$1,112,923

$1,337,019

$163,854

14%

Operations

FY 2021

FY 2022

FY 2024

Object

Account

Actuals

Revised

YTD 07/31

Annualized

Proposed

521200

Professional Services

$35,226

$14,442

$107,500

$37,246

$107,500

$0

0%

521207

Other

$2,928,004

$96,692

$181,614

$24,188

$181,614

$196,614

$15,000

8%

523300

Advertising

$0

$3,213

$16,500

$11,500

$16,500

$42,500

$26,000

158%

523500

Travel

$832

$1,124

$9,750

$0

$9,750

$13,750

$4,000

41%

523600

Dues & Fees

$32,329

$21,154

$62,444

$22,105

$62,444

$89,769

$27,325

44%

523700

Education & Training

$9,062

$22,259

$20,540

$27,804

$27,600

$7,060

34%

523901

Hospitality

$2,879

$13,482

$15,700

$6,226

$15,700

$20,700

$5,000

32%

531120

Office Supplies

$3,064

$1,334

$2,000

$580

$2,000

$0

0%

523400

Printing and Binding

$0

$5,000

$2,145

$5,000

$0

0%

531130

Postage

$1,290

$206

$100

$341

$100

$0

0%

531703

Operating Supplies

$5,442

$4,536

$0

$1,012

$1,184

$0

0%

579100

Unallocated

$2,770

$0

0%

Subtotal - Operations

$3,020,898

$178,441

$421,148

$133,145

$429,837

$505,533

$84,385

20%

TOTAL CITY MANAGER

$3,730,404

$1,002,670

$1,594,313

$1,055,464

$1,542,760

$1,842,552

$248,239

16%

FY 2023

$ Inc (Dec)

from 2023

FY 2023

$ Inc (Dec)

from 2023

% Inc

(Dec)

% Inc

(Dec)

Proposed 9/12/2023 FY 2024 Budget Page 23 of 88

City Manager (1001320)

Professional Services - Items Described

Vendor Name

Cost per

Units

Total

Renderings

$2,500

5

$12,500

Increase in Studies, Consultants, and other services

$95,000

1

$95,000

521200

$107,500

Other - Items Described

Vendor Name

Cost per

Units

Total

Small Business Resources Center

JC Chamber

$10,000

1

$10,000

Other Consultants

Various

$46,614

1

$46,614

Other Consultants

Various

$25,000

4

$100,000

Living Displays Care at Autrey Mill

Various

$5,000

1

$5,000

ARC Green Communities

Various

$25,000

1

$25,000

Midsize Business Initiative

Various

$10,000

1

$10,000

521207

$196,614

Advertising - Items Described

Vendor Name

Cost per

Units

Total

Marketing materials for economic development

$2,500

2

$5,000

Town Center brand activation efforts - booth materials (table covers, banners, etc.)

$5,000

2

$10,000

BizNow Event w/ Greater North Fulton Chamber

$1,500

1

$1,500

Greater North Fulton Chamber of Commerce Gala Table

GNFCC

$8,500

1

$8,500

ECONOMIX Conference Sponsorship Table

ECONOMIX

$8,500

1

$8,500

GA Trend Magazine - Business Issue Advertising Spread

GA Trend Magazine

$2,000

1

$2,000

Business Chronicle Magazine - Advertising Spread

Business Chronicle

$2,000

1

$2,000

Event Sponsorships for Econ. Dev.

Various

$2,500

2

$5,000

523300

$42,500

Travel - Items Described

Vendor Name

Cost per

Units

Total

Parking Fees

Various Staff

$10

25

$250

Travel for GMA Annual Conference

Various

$1,000

2

$2,000

Travel to GCCMA Conferences

Various

$400

4

$1,600

Travel to ICMA Conference

Various

$1,000

2

$2,000

Mileage for Eco. Dev. Meetings, etc.

various

$50

8

$400

Travel to Eco. Dev. Conferences

various

$2,500

1

$2,500

Travel for BIO International Conference

various

$4,000

1

$4,000

Per Diem at GSA Rates

Staff

$50

20

$1,000

523500

$13,750

Dues and Fees - Items Described

Vendor Name

Cost per

Units

Total

Johns Creek Chamber of Commerce

JCCC

$10,000

1

$10,000

Greater North Fulton Chamber of Commerce

GNFCC

$5,000

1

$5,000

Georgia City County Management Association

GCCMA

$200

4

$800

International City County Management Association

ICMA

$1,400

3

$4,200

International City County Management Association

ICMA

$250

1

$250

Leadership Johns Creek - Tuition

LJC

$2,500

2

$5,000

Leadership Johns Creek - Alumni

LJC

$50

2

$100

Project Management Institute

PMI

$164

1

$164

Special Needs Certified - Citywide

SNC

$365

1

$365

Rotary of Johns Creek - Quarterly Dues

RJC

$360

4

$1,440

Costco Membership for City

Costco

$60

1

$60

Digital and hosting fees for Town Center websites

$2,000

1

$2,000

Georgia Economic Development Association

GEDA

$650

1

$650

Post-certification related dues and fees

Various

$500

1

$500

Bar-certification related dues and fees

Various

$2,500

1

$2,500

Costar Subscription

$25,740

1

$25,740

Business Wise Subscription

$3,000

1

$3,000

Placer.ai Subscription

Placer.ai

$2,333

12

$28,000

523600

$89,769

FY 2024 Proposed Operations

Proposed 9/12/2023 FY 2024 Budget Page 24 of 88

Education and Training - Items Described

Vendor Name

Cost per

Units

Total

GCCMA Spring Conference

GCCMA

$450

4

$1,800

GCCMA Fall Conference

GCCMA

$450

4

$1,800

ICMA Annual Conference ICMA $750 4 $3,000

GMA Annual Conference

GMA

$1,000

3

$3,000

GMA Mayor's Day Annual Conference

GMA

$500

1

$500

Chamber and GNFCC Meetings

Various

$50

8

$400

Georgia Economic Developers Association - Conferences

$550

2

$1,100

Eco. Dev. Trainings, Trade Shows, Courses

Various

$500

3

$1,500

ECONOMIX Conference

ECONOMIX

$2,000

1

$2,000

Eco. Dev. Programs

Carl Vinson Institute

$500

2

$1,000

Facilitation Training

TBD

$1,500

1

$1,500

Social Media Techology Certification

Gwinnett Tech

$2,500

1

$2,500

Social Media Marketing for Econ. Dev. Course

IEDC

$2,500

1

$2,500

Georgia Mainstreet Program

GA Dept. Community Affairs

$2,500

2

$5,000

523700

$27,600

Hospitality - Items Described

Vendor Name

Cost per

Units

Total

City Manager - Rotating Employee Luncheons

Various

$100

12

$1,200

City Merchandise for Visitors / Tour Groups

Various

$6

1000

$6,000

Meetings with Visitors and Guests

Various

$50

30

$1,500

Life Sciences Familiarization Tour

Various

$4,000

1

$4,000

Technology Familiarization Tour

Various

$4,000

1

$4,000

JC10 Summit - Event Supplies

Various

$4,000

1

$4,000

523901

$20,700

Office Supplies - Items Described

Vendor Name

Cost per

Units

Total

Basic Office Supplies - Folders, Pens, Etc.

Office Depot, Staples, etc.

$100

20

$2,000

531110

$2,000

Printing and Binding - Items Described

Vendor Name

Cost per

Units

Total

Town Center branding, printed materials, and marketing materials

$2,500

2

$5,000

523400

$5,000

Postage - Items Described

Vendor Name

Cost per

Units

Total

Letters and Mailings USPS $1 200 $100

531130

$100

$505,533

Proposed 9/12/2023 FY 2024 Budget Page 25 of 88

Communications (1001570)

1001570

Personnel

FY 2021

FY 2022

FY 2024

Object

Account

Actuals

Revised

YTD 07/31

Annualized

Proposed

511100

Regular Employees

$399,717

$427,044

$454,448

$387,371

$462,218

$486,308

$31,860

7%

511151

Car Allowance

$4,829

$4,800

$4,000

$4,800

$0

0%

511153

Gym Membership

$181

$300

$360

$300

$360

$0

0%

512101

Health

$47,582

$49,521

$53,531

$40,370

$47,604

$60,458

$6,927

13%

512102

Long-Term Disability

$2,534

$2,957

$2,771

$2,305

$2,763

$2,554

($217)

-8%

512103

Dental

$4,062

$4,007

$4,330

$3,459

$4,097

$4,640

$310

7%

512104

Life

$2,026

$4,543

$4,449

$3,981

$4,731

$4,441

($8)

0%

512200

Social Security (FICA)

$23,557

$25,477

$27,318

$23,287

$27,842

$30,151

$2,833

10%

512300

Medicare

$5,636

$6,015

$6,390

$5,495

$6,560

$7,051

$661

10%

512400

Retirement

$66,803

$73,034

$76,919

$64,496

$76,471

$82,672

$5,753

7%

512700

Workers Compensation

$914

$957

$476

$639

$681

$205

43%

Subtotal - Personnel

$557,841

$598,684

$635,792

$535,703

$638,086

$684,116

$48,324

8%

Operations

FY 2021

FY 2022

FY 2024

Object

Account

Actuals

Revised

YTD 07/31

Annualized

Proposed

521200 Professional Services $2,500 $0 $3,000 $0 $3,000 $3,000 $0 0%

521300

Technical Services

$18,714

$19,048

$20,358

$16,291

$20,358

$22,873

$2,515

12%

522320

Rental Equipment

$210

$0

$1,600

$0

$1,600

$0

0%

523300

Advertising

$7,809

$20,270

$39,584

$17,328

$39,584

$50,834

$11,250

28%

523400

Printing & Binding

$190

$2,053

$5,400

$936

$5,000

$13,400

$8,000

148%

523500

Travel

$1,162

$12,663

$14,083

$3,252

$9,083

$16,513

$2,430

17%

523600

Dues & Fees

$5,038

$6,074

$6,484

$4,411

$6,333

$6,540

$56

1%

523700

Education & Training

$1,649

$1,838

$8,685

$5,179

$7,835

($850)

-10%

523900

Other

$209

$385

$0

0%

523901

Hospitality

$519

$9,544

$6,600

$494

$6,600

$8,600

$2,000

30%

531120

Office Supplies

$1,132

$189

$200

$211

$200

$0

0%

531130

Postage

$0

$50

$0

$50

$0

0%

531600

Small Equipment

$0

$3,250

$355

$709

$900

($2,350)

-72%

531703

Operating Supplies

$11,568

$120,702

$75,100

$78,844

$75,000

($100)

0%

Subtotal - Operations

$50,700

$192,765

$184,394

$127,301

$176,501

$207,345

$22,951

12%

TOTAL COMMUNICATIONS

$608,541

$791,448

$820,186

$663,003

$814,587

$891,461

$71,275

9%

FY 2023

$ Inc (Dec)

from 2023

FY 2023

$ Inc (Dec)

from 2023

% Inc

(Dec)

% Inc

(Dec)

Proposed 9/12/2023 FY 2024 Budget Page 26 of 88

Communications (1001570)

Contracted - Items Described

Vendor Name

Cost per

Units

Total

Web Tech Support

Blue Key

$3,000

1

$3,000

521200

$3,000

Technical Services - Items Described

Vendor Name

Cost per

Units

Total

Website hosting

Wakefly

$3,500

1

$3,500

E-mail service

Constant Contact

$3,500

1

$3,500

Web Security Certificate (SSL Cert.)

Wakefly

$150

1

$150

Online forms

WuFoo

$299

1

$299

Online public calendars

Calendar Wiz

$259

1

$259

Custom URLs for city projects

Go Daddy

$100

3

$300

Music Licensing

Music Vine

$45

12

$540

Online Media Monitoring Service

Meltwater

$1,500

1

$1,500

Social Media Archiving Solution

Archive Social

$5,988

1

$5,988

Website Auditing Service

SiteImprove

$6,137

1

$6,137

Website License

Kentico

$700

1

$700

521214

$22,873

Rental Equipment - Items Described

Vendor Name

Cost per

Units

Total

A/V Equipment Rental

Various

$400

4

$1,600

522320

$1,600

Advertising - Items Described

Vendor Name

Cost per

Units

Total

Quarter Page Advertisements - Calendar

Johns Creek Herald

$360

6

$2,160

Third Page Advertisements - Calendar

Johns Creek Herald

$498

6

$2,988

Half Page Advertisements (for events)

Johns Creek Herald

$634

9

$5,706

Full Page Advertisement

Chamber Guidebook

$2,500

1

$2,500

Peach Jar - School Advertising

Peach Jar

$645

6

$3,870

Social Media Advertising

Facebook

$20

428

$8,560

Social Media Advertising

Instagram

$20

247

$4,940

Social Media - Post Boost (for events)

Facebook

$120

8

$960

Additional community ads

TBD

$500

3

$1,500

Direct Mail (Targeted)

TBD

$550

8

$4,400

Half Page Advertisement North Fulton edition

Atlanta Business Chronicle

$1,000

1

$1,000

Half Page Advertisement

North Fulton Chamber Guidebook

$2,500

1

$2,500

Digital Billboard Ads for Events

Clear Channel Outdoor

$1,750

5

$8,750

Half Page Advertisement

Georgia Trend

$1,000

1

$1,000

523300

$50,834

Printing and Binding - Items Described

Vendor Name

Cost per

Units

Total

Annual Report

$1,400

1

$1,400

Brochures and Flyers

$4,000

3

$12,000

523400

$13,400

Travel - Items Described

Vendor Name

Cost per

Units

Total

Mileage Reimbursements

Various Staff

$1

300

$165

Hotel

TBD

$300

29

$8,700

Transportation

TBD

$60

10

$600

Airfare

TBD

$4,500

1

$4,500

Per Diem at GSA Rates

GSA

$91

28

$2,548

523500

$16,513

Dues and Fees - Items Described

Vendor Name

Cost per

Units

Total

FY 2024 Proposed Operations

Proposed 9/12/2023 FY 2024 Budget Page 27 of 88

Rotary - Quarterly Dues

Rotary

$360

4

$1,440

Public Relations Society of America - Annual Dues

PRSA

$425

1

$425

City County Communications and Marketing Association

3CMA

$400

4

$1,600

Newspaper Subscription

Atlanta Journal Constitution

$550

1

$550

National Association of Government Web Professionals

NAGW

$225

1

$225

Award Application Fees

Various

$200

4

$800

International City County Managers Association

ICMA

$1,400

1

$1,400

Annual Dues

$100

1

$100

523600

$6,540

Education and Training - Items Described

Vendor Name

Cost per

Units

Total

3CMA Annual Conference

3CMA

$750

1

$750

PRSA National Conference

PRSA

$1,395

1

$1,395

NAGW Conference

NAGW

$1,650

1

$1,650

Govn't Social Media Conference

GSMC

$700

1

$700

National Association of Broadcasters Conference

NAB

$600

1

$600

Adobe Max Conference

Adobe

$995

2

$1,990

International City County Managers Association

ICMA

$750

1

$750

523700

$7,835

Hospitality - Items Described

Vendor Name

Cost per

Units

Total

Promotional Items for City Events

Various

$150

4

$600

Branded Items

Various

$1,000

8

$8,000

523901

$8,600

Office Supplies - Items Described

Vendor Name

Cost per

Units

Total

Basic Office Supplies - Folders, Pens, Etc.

Office Depot, Staples, etc.

$200

1

$200

531120

$200

Postage - Items Described

Vendor Name

Cost per

Units

Total

Letters and Mailings

USPS

$1

100

$50

531130

$50

Small Equipment

Vendor Name

Cost per

Units

Total

Camera Lens for video

$900

1

$900

561600

$900

Operating Supplies - Items Described

Vendor Name

Cost per

Units

Total

International Festival

Various

$45,000

1

$45,000

Arts Festival

$15,000

1

$15,000

New Banners and Signs for Events

$500

30

$15,000

531703

$75,000

$207,345

Proposed 9/12/2023 FY 2024 Budget Page 28 of 88

Community Development (1007410)

1007410

Personnel

FY 2021

FY 2022

FY 2024

Object

Account

Actuals

Revised

YTD 07/31

Annualized

Proposed

511100

Regular Employees

$1,166,172

$1,532,197

$1,680,164

$1,253,782

1,494,317

$1,738,383

$58,219

3%

511151

Car Allowance

$4,829

$4,800

$4,000

4,800

$4,800

$0

0%

511153

Gym Membership

$360

$677

$540

$735

855

$720

$180

33%

511200

Temporary/PT Employee

$43,639

-

$0

$25,644

32,235

$41,600

100%

511300

Overtime

$57

$212

$0

$112

335

$0

0%

512101

Health

$179,213

$202,730

$204,931

$161,670

189,614

$310,387

$105,456

51%

512102

Long-Term Disability

$7,311

$10,668

$10,027

$7,430

8,890

$9,659

($368)

-4%

512103

Dental

$14,284

$14,608

$15,081

$9,850

11,510

$15,104

$23

0%

512104

Life

$5,840

$23,912

$15,961

$12,433

15,029

$15,881

($80)

-1%

512200

Social Security (FICA)

$72,590

$91,964

$99,997

$76,867

84,093

$109,572

$9,575

10%

512300

Medicare

$17,030

$21,508

$23,391

$17,977

19,731

$25,810

$2,419

10%

512400

Retirement

$143,082

$233,121

$262,510

$197,578

216,948

$295,525

$33,015

13%

512700

Workers Compensation

$1,673

$3,927

$2,381

$2,655

2,665

$3,215

$834

35%

Subtotal - Personnel

$1,656,080

$2,140,353

$2,319,783

$1,770,732

$2,081,022

$2,570,656

$250,873

11%

Operations

FY 2021

FY 2022

FY 2024

Object

Account

Actuals

Revised

YTD 07/31

Annualized

Proposed

521200

Professional Services

$38,876

$66,166

$115,000

$129,695

$115,000

$0

0%

521208

Other IGA (SAFEbuilt)

$497,098

$0

0%

523300

Advertising

$3,165

$8,770

$11,950

$1,069

$5,000

$9,450

($2,500)

-21%

523400

Printing & Binding

$3,310

$2,519

$11,243

$25

$8,000

$9,500

($1,743)

-16%

523500

Travel

$3,488

$8,295

$14,651

$9,958

$10,000

$14,600

($51)

0%

523600

Dues & Fees

$3,607

$2,862

$4,705

$2,108

$3,008

$5,070

$365

8%

523700

Education and Training

$3,969

$4,662

$17,487

$9,499

$11,000

$17,845

$358

2%

523901

Hospitality

$1,186

$1,272

$700

$1,919

$2,161

$1,200

$500

71%

531120

Office Supplies

$9,135

$4,433

$6,300

$2,064

$3,500

$6,030

($270)

-4%

531130

Postage

$2,291

$3,411

$7,310

$2,766

$5,500

$7,390

$80

1%

531710

Uniforms

$1,038

$3,669

$4,100

$255

$4,100

$4,500

$400

10%

579100

Unallocated

$46

$0

0%

Subtotal - Operations

$567,210

$106,058

$193,446

$159,358

$181,964

$190,585

($2,861)

-1%

TOTAL COMMUNITY DEVELOPMENT

$2,223,290

$2,246,410

$2,513,229

$1,930,090

$2,262,986

$2,761,241

$248,012

10%

FY 2023

$ Inc (Dec)

from 2023

FY 2023

$ Inc (Dec)

from 2023

% Inc

(Dec)

% Inc

(Dec)

Proposed 9/12/2023 FY 2024 Budget Page 29 of 88

Community Development (1007410)

Professional Services - Items Described

Vendor Name

Cost per

Units

Total

Consulting Services - Arborist

$5,000

3

$15,000

Consulting Services (Planning Plans, Reports, Building Services, Arborist, etc.) $100,000 1 $100,000

521200

$115,000

Advertising - Items Described

Vendor Name

Cost per

Units

Total

Legal Ads - Rezonings, Public Hearings, etc.

Johns Creek Herald

$250

20

$5,000

Public Hearing Signs

$89

50

$4,450

523300

$9,450

Printing and Binding - Items Described

Vendor Name

Cost per

Units

Total

Brochures and Forms

Various

$500

3

$1,500

Printing for Board Meetings, Focus Groups and Committees

Various

$1,000

2

$2,000

Public outreach and engagement materials, banners, etc.

Various

$2,000

2

$4,000

Master Plan efforts

Various

$2,000

1

$2,000

523400

$9,500

Travel - Items Described

Vendor Name

Cost per

Units

Total

Mileage Reimbursements

Various Staff

$200

1

$200

Hotel

TBD

$300

24

$7,200

Transportation and/or Airfare

TBD

$300

16

$4,800

Per Diem at GSA Rates

Staff

$96

25

$2,400

523500

$14,600

Dues and Fees - Items Described

Vendor Name

Cost per

Units

Total

American Society of Engineers

ASE

$275

1

$275

American Planning Association

APA

$430

4

$1,720

Georgia Professional Engineer license

State of Georgia

$100

1

$100

Southeast Stormwater Association Membership

SESWA

$700

1

$700

Certified Floodplain Manager - Association of State Floodplain Manager

ASFPM

$285

1

$285

Surveying and Mapping Society of Georgia

SAMSOG

$260

1

$260

International City/County Management Association

ICMA

$200

1

$200

ICC Governmental Membership

ICC

$265

1

$265

ICC Membership for CBO

ICC

$185

1

$185

Building Officials Association of GA

BOAG

$35

3

$105

Association of Licensed Architects

AIA

$250

1

$250

National Council of Architectural Registration Board

$225

1

$225

Professional Architect License Renewal

$90

1

$90

Electrical Contractor's License Renewal

$100

1

$100

Georgia Association of Code Enforcement

GACE

$62

5

$310

523600

$5,070

Education and Training - Items Described

Vendor Name

Cost per

Units

Total

GA Soil & Water Conservation Certificate, Level 1B

$129

3

$387

GA Soil & Water Conservation Certificate, Level II

$129

3

$387

GA Soil & Water Conservation Erosion Seminar

$35

4

$140

Southeast Stormwater Association Annual Conference

$295

2

$590

Certified Professional in Erosion & Sediment Control Certification Renewal

$140

1

$140

Certified Floodplain Manager Renewal

ASFPM

$120

1

$120

MS4 CECI Recertification

$197

1

$197

MS4 Green Infrastructure Training Technician

$497

1

$497

Surveying and Mapping Society of Georgia Annual Conference

$475

1

$475

Energov Staff Training

Tyler

$2,600

1

$2,600

Georgia Association of Floodplain Manager Annual Conference

$300

2

$600

Georgia Association of Code Enforcement Annual Conference

$850

4

$3,400

American Planning Association National Planning Conference

$1,000

1

$1,000

Urban Land Insitute Spring Meeting

ULI

$700

2

$1,400

Notary Training and recertification

$177

2

$354

Georgia Planning Association Annual Conference

$250

2

$500

Building Officials Association of GA Annual Conference

$350

1

$350

ICC Annual Conference & Exhibition

ICC

$500

1

$500

Permit Tech Certificate CEU & Renewal Fees

ICC

$230

2

$460

Plans Coordinator (Residential Plans Examiner, CEU & Renewal Fee

ICC

$860

1

$860

Plans Examiner Certificate CEU & Renewal Fee

ICC

$1,054

1

$1,054

FY 2024 Proposed Operations

Proposed 9/12/2023 FY 2024 Budget Page 30 of 88

Building Inspector Certificate CEU & Renewal Fee

ICC

$448

2

$896

CBO Examination

ICC

$518

1

$518

CBO Certificate CEU & Renewal Fee

ICC

$420

1

$420

523700

$17,845

Hospitality

Vendor Name

Cost per

Units

Total

Planning Commission and BZA Meetings

$1,200

1

$1,200

523901

$1,200

Office Supplies - Items Described

Vendor Name

Cost per

Units

Total

Basic Office Supplies - tree measuring tape, spray paint, stakes, posts, etc.)

Office Depot, Staples, etc.

$37

90

$3,330

Business cards, Board Nameplates and Notary

$950

1

$950

Inspection Equipment (meters, measuring devices, etc.)

$1,350

1

$1,350

Printer Toner

$200

2

$400

531120

$6,030

Postage - Items Described

Vendor Name

Cost per

Units

Total

Letters

USPS

$0.63

5,000

$3,150

Certified Mail - Code Compliance/Land Development Citations

$8

50

$400

Postcard notices for public hearing (Rezoning, SUP and Variance)

$0.48

8,000

$3,840

531130

$7,390

Uniforms - Items Described

Vendor Name

Cost per

Units

Total

Land Inspector Uniforms

Gall's/Amazon

$500

4

$2,000

Building Inspector Uniforms

Gall's/Amazon

$500

2

$1,000

Code Compliance Uniforms

Gall's

$750

2

$1,500

531710

$4,500

$190,585

Proposed 9/12/2023 FY 2024 Budget Page 31 of 88

Court (1002650)

1002650

Personnel

FY 2021

FY 2022

FY 2024

Object

Account

Actuals

Revised

YTD 07/31

Annualized

Proposed

511100

Regular Employees

$275,057

$273,858

$306,007

$221,576

$268,844

$318,516

$12,509

4%

511153

Gym Membership

$362

$360

$375

$465

$540

$180

50%

511200

Temporary/PT Employee

$11,883

$13,260

$18,720

$17,628

$21,666

$23,860

$5,140

27%

511300

Overtime

$2,577

$4,274

$4,728

$1,915

$2,296

$2,578

($2,150)

-45%

512101

Health

$59,307

$60,944

$64,085

$49,321

$58,363

$75,605

$11,520

18%

512102

Long-Term Disability

$1,745

$1,929

$1,831

$1,401

$1,718

$1,813

($18)

-1%

512103

Dental

$4,368

$4,319

$4,655

$3,194

$3,767

$4,171

($484)

-10%

512104

Life

$1,374

$2,627

$2,916

$2,367

$2,871

$2,912

($4)

0%

512200

Social Security (FICA)

$16,848

$16,815

$18,877

$13,809

$16,713

$21,387

$2,510

13%

512300

Medicare

$3,940

$3,932

$4,416

$3,230

$1,384

$5,002

$586

13%

512400

Retirement

$45,147

$46,156

$50,414

$36,560

$44,372

$54,148

$3,734

7%

512700

Workers Compensation

$750

$771

$848

$531

$479

($369)

-44%

Subtotal - Personnel

$423,358

$429,246

$477,857

$351,907

$422,990

$511,011

$33,154

7%

Operations

FY 2021

FY 2022

FY 2024

Object

Account

Actuals

Revised

YTD 07/31

Annualized

Proposed

521203

Contractual

$50,529

$51,933

$60,750

$60,222

$60,750

$40,114

($20,636)

-34%

521208

Other IGA

$16,800

$15,400

$0

0%

521211

Municipal Judge

$36,225

$33,738

$59,250

$26,666

$59,250

$0

0%

521212

Court Solicitor

$95,812

$86,402

$110,250

$68,246

$110,250

$0

0%

521213

Indigent Defense

$2,058

$1,289

$7,500

$2,525

$4,414

$7,500

$0

0%

523100

Insurance

$140

$0

0%

523300

Advertising

$180

$25

$300

$0

$300

$0

0%

523400

Printing & Binding

$0

$2,000

$2,109

$3,559

$2,000

$0

0%

523500

Travel

$0

$4,602

$7,000

$3,123

$5,555

$7,000

$0

0%

523600

Dues & Fees

$1,157

$585

$846

$639

$930

$983

$137

16%

523700

Education & Training

$1,596

$3,205

$9,255

$1,942

$10,345

$1,090

12%

523852

Software Licensing Fee

$0

$37,092

100%

523901

Hospitality

$565

$6,091

$1,200

$1,309

$1,200

$0

0%

523903

Merchant Service Charges

$526

$747

$1,560

$466

$531

$1,560

$0

0%

531120

Office Supplies

$5,062

$4,067

$3,000

$5,011

$3,000

$0

0%

531130

Postage

$1,863

$4,332

$3,150

$4,798

$6,771

$4,500

$1,350

43%

531400

Books & Periodicals

$1,072

$1,268

$1,168

$1,272

$1,300

$132

11%

531703

Operating Supplies

$6,677

$109

$1,500

$49

$1,500

$0

0%

Subtotal - Operations

$220,261

$213,934

$268,869

$178,518

$263,484

$288,034

$19,165

7%

TOTAL COURT

$643,619

$643,180

$746,726

$530,424

$686,474

$799,045

$52,319

7%

FY 2023

$ Inc (Dec)

from 2023

FY 2023

$ Inc (Dec)

from 2023

% Inc

(Dec)

% Inc

(Dec)

Proposed 9/12/2023 FY 2024 Budget Page 32 of 88

Court (1002650)

Contractual - Items Described

Vendor Name

Cost per

Units

Total

Secure Remote Safe

Brinks

$667

12

$8,004

Translation Services and Travel-Other Languages

8A Translation, LLC

$285

12

$3,420

Translation Services and Travel-Spanish

8A Translation, LLC

$178

105

$18,690

In-House Probation Development - Phase III

Insight Consulting Group

$10,000

1

$10,000

521203

$40,114

Municipal Judge - Items Described

Vendor Name

Cost per

Units

Total

Presiding Over Court (3 hrs at $200 per hour)

Donald Schaefer, Chief Judge

$600

55

$33,000

Presiding Over Court (3 hrs at $175 per hour)

Wanda Dallas, Assistant Judge

$525

25

$13,125

Presiding Over Court (3 hrs at $175 per hour)

Jenny Nguyen, Assistant Judge

$525

25

$13,125

521211

$59,250

Court Solicitor - Items Described

Vendor Name

Cost per

Units

Total

Solicitor - Court Sessions (3 hrs at $150 per hour)

Larry Delan, Chief Solicitor

$450

105

$47,250

Assistant Solicitors - Court Sessions (3 hrs at $150 per hour)

Angela Couch, Maggie Benson

$450

105

$47,250

Solicitors - Outside of Court

Solicitor and Asst. Solicitors

$150

105

$15,750

521212

$110,250

Indigent Defense - Items Described

Vendor Name

Cost per

Units

Total

Public Defender / Indigent Defense - In Court

Various (4)

$85

50

$4,250

Public Defender / Indigent Defense - Out of Court

Various (4)

$65

50

$3,250

521213

$7,500

Insurance

Vendor Name

Cost per

Units

Total

Court Clerk Bonding Insurance

Travelers

$140

1

$140

523100

$140

Advertising - Items Described

Vendor Name

Cost per

Units

Total

Legal Ads and Notices

ALM Media, LLC

$25

12

$300

523300

$300

Printing and Binding - Items Described

Vendor Name

Cost per

Units

Total

Court Forms, business cards, brochures

Priority Printing

$400

5

$2,000

523400

$2,000

Travel - Items Described

Vendor Name

Cost per

Units

Total

Per Diem for Travel to/from Conferences - Clerks

Various

$1,000

4

$4,000

Per Diem for Travel to/from Conferences - Judges

Various

$1,000

3

$3,000

523500

$7,000

Dues and Fees - Items Described

Vendor Name

Cost per

Units

Total

Georgia Municipal Court Clerks Council

GMCCC

$60

4

$240

National Association of Court Management

NACM

$125

1

$125

Georgia Council of Court Administrators

GCCA

$120

3

$360

Georgia Records Association

GRA

$45

1

$45

GCIC Terminal Agency Coordinator

GCIC

$20

3

$60

Notary Public

State of Georgia

$51

3

$153

523600

$983

Education and Training - Items Described

Vendor Name

Cost per

Units

Total

Institute of Continuing Judicial Education - Clerks

ICJE

$200

4

$800

Institute of Continuing Judicial Education - Judges

ICJE

$325

3

$975

Georgia Council of Court Administrators - Spring Conference

GCCA

$375

2

$750

Georgia Council of Court Administrators - Fall Conference

GCCA

$375

2

$750

Georgia Crime Information Center - TAC Symposium

GCIC

$300

2

$600

National Association of Court Management Conference

NACM

$750

2

$1,500

Professional Development Training

Various

$500

4

$2,000

National Center For State Courts - Court Adm. Nat' Certification

NCSC

$495

6

$2,970

523700

$10,345

Software Licensing Fee

Vendor Name

Cost per

Units

Total

Software License - Operating System

Courtware

$2,812

12

$33,744

FY 2024 Proposed Operations

Proposed 9/12/2023 FY 2024 Budget Page 33 of 88

Drive Program Annual Maintenance Fee - Software Application

JAG

$3,348

1

$3,348

523852

$37,092

Hospitality - Items Described

Vendor Name

Cost per

Units

Total

Midyear/ Annual Court meetings/ refreshments / Court Programs

Various

$100

12

$1,200

523901

$1,200

Merchant Service Charges - Items Described

Vendor Name

Cost per

Units

Total

Bank Service Charges

United Community

$100

12

$1,200

Stop Check Fees

United Community

$30

12

$360

523903

$1,560

Office Supplies - Items Described

Vendor Name

Cost per

Units

Total

Basic Office Supplies - Folders, Pens, Etc.

Office Depot, Staples, etc.

$1,500

2

$3,000

531110

$3,000

Postage - Items Described

Vendor Name

Cost per

Units

Total

Court Notices

USPS

$0.60

7,250

$4,350

Certified Mail

USPS

$6.00

25

$150

531130

$4,500

Books and Periodicals - Items Described

Vendor Name

Cost per

Units

Total

Court Reference Materials

Thomas Reuters

$325

4

$1,300

531400

$1,300

Operating Supplies - Items Described

Vendor Name

Cost per

Units

Total

Probation supplies, drug/alcohol sceens/cups, gloves, etc.

Various

$750

2

$1,500

531703

$1,500

$288,034

Proposed 9/12/2023 FY 2024 Budget Page 34 of 88

Facilities (1001565)

1001565

Personnel

FY 2021

FY 2022

FY 2024

Object Account Actuals Actuals Revised YTD 07/31 Annualized Proposed

511100

Regular Employees

$48,835

-$1,915

$0

0%

511151

Car Allowance

$86

$0

0%

511153

Gym Membership

$13

$0

0%

511200

Temporary/PT Employee

$0

0%

511300

Overtime

$6,787

-$491

$0

0%

512101

Health

$13,102

$0

0%

512102

Long-Term Disability

$371

$0

0%

512103

Dental

$1,105

$0

0%

512104

Life

$294

$0

0%

512200

Social Security (FICA)

$3,230

-$143

$0

0%

512300

Medicare

$772

-$33

$0

0%

512400

Retirement

$9,086

-$96

$0

0%

512700

Workers Compensation

$751

$0

0%

Subtotal - Personnel

$84,431

-$2,677

$0

0%

Operations

FY 2021

FY 2022

FY 2024

Object Account Actuals Actuals Revised YTD 07/31 Annualized Proposed

521200

Professional Services

$146,057

$126,658

$186,255

$86,682

$92,385

$162,140

($24,115)

-13%

521203

Contractual

$1,160

$9,846

$2,808

$8,621

$11,774

$3,288

$480

17%

522210

Equipment

$2,436

$4,451

$12,000

$4,012

$12,000

$0

0%

522220

Building

$13,503

$29,420

$20,000

$30,910

$20,000

$0

0%

522310

Rental - Land & Buildings

$2,779

$0

0%

523500

Travel

$0

$390

$0

$390

$0

0%

523600

Dues & Fees

$3,513

$70,202

$46,175

$12,642

$25,054

$46,175

$0

0%

523700

Education & Training

$785

$673

$6,230

$362

$724

$6,230

$0

0%

523851

Maintenance Contracts

$80,698

$61,175

$94,760

$39,813

$43,460

$102,940

$8,180

9%

523901

Hospitality

$15,406

$26,544

$27,700

$22,310

$28,274

$35,150

$7,450

27%

531111

Vehicles

$24,833

$1,367

$0

0%

531120

Office Supplies

$8,705

$12,453

$34,150

$10,234

$12,321

$34,850

$700

2%

531130

Postage

$11,614

$12,470

$20,324

$6,557

$20,324

$0

0%

531210

Water /Sewage

$4,208

$3,257

$4,800

$2,437

$3,466

$6,000

$1,200

25%

531230

Electricity

$158,741

$150,414

$163,200

$100,251

$118,231

$163,200

$0

0%

531270

Gasoline/Diesel - Fuel

$28,213

$928

$4,000

$0

$4,000

$0

0%

531702

Office Equipment

$12,668

$47,393

$32,500

$67,874

$32,500

$0

0%

531703

Operating Supplies

$1,685

$12,947

$13,000

$14,854

$16,507

$14,750

$1,750

13%

542300

Furniture & Fixtures

$1,429

$0

$91,297

$12,333

$19,771

$25,000

($66,297)

-73%

542400

Computers

$0

$50,000

100%

579100

Unallocated

$700

$1,762

$0

0%

591610

Operating Transfers Out

$2,045,552

$2,046,896

$2,047,216

$228,608

$2,047,216

$2,046,512

($704)

0%

Subtotal - Operations

$2,564,685

$2,618,855

$2,806,805

$648,500

$2,532,536

$2,785,449

($21,356)

-1%

TOTAL FACILITIES

$2,649,116

$2,616,178

$2,806,805

$648,500

$2,532,536

$2,785,449

($21,356)

-1%

% Inc

(Dec)

% Inc

(Dec)

FY 2023

$ Inc (Dec)

from 2023

FY 2023

$ Inc (Dec)

from 2023

Proposed 9/12/2023 FY 2024 Budget Page 35 of 88

Facilities (1001565)

Professional Services - Items Described

Vendor Name

Cost per

Units

Total

Handyman Services - Drywall repair, etc.

Various

$200

50

$10,000

Janitorial Services - Day (City Hall)

Various

$2,925

12

$35,100

Janitorial Services - Night (City Hall)

Various

$5,420

12

$65,040

Locksmith Services

Various

$250

8

$2,000

Window Cleaning (City Hall)

Various

$20,000

2

$40,000

Carpet Cleaning and Tile Replacement

Various

$5,000

2

$10,000

521200

$162,140

Contractual - Items Described

Vendor Name

Cost per

Units

Total

Shredding Services

A Shred Ahead-Possibly Change

$149

12

$1,788

Vending Machine Leases

Allied Vending

$125

12

$1,500

521203

$3,288

Equipment - Items Described

Vendor Name

Cost per

Units

Total

Tools and Equipment for minor repairs

Various

$500

24

$12,000

522210

$12,000

Building - Items Described

Vendor Name

Cost per

Units

Total

Minor Renovations

Various

$1,000

20

$20,000

522220

$20,000

Travel

Vendor Name

Cost per

Units

Total

Various

$390

1

$390

523500

$390

Dues and Fees - Items Described

Vendor Name

Cost per

Units

Total

Southeast Government Fleet Managers Association

SGFMA

$100

1

$100

National Emergency Number Association

NENA

$150

1

$150

Building Owners and Managers Organization

BOMA

$925

1

$925

Technology Park Common Area Assessment

JC Owners Association

$9,000

1

$9,000

Stormwater and Association Fees

$36,000

1

$36,000

523600

$46,175

Education & Training

Vendor Name

Cost per

Units

Total

Basic Microsoft Word and Excel Training Courses

TBD

$1,955

2

$3,910

HVAC Training

TBD

$580

4

$2,320

523700

$6,230

Maintenance Contracts - Items Described

Vendor Name

Cost per

Units

Total

Dumpster / Waste Management (City Hall)

$100

156

$15,600

Elevator Maintenance (City Hall)

Thyssenkrupp

$5,670

1

$5,670

Fire Suppression Maintenance (City Hall)

Basesix

$470

4

$1,880

Generator (main) (City Hall)

Nixon

$1,850

4

$7,400

HVAC Maintenance (City Hall)

HVH

$4,000

12

$48,000

Pest Control (City Hall)

Northwest

$350

12

$4,200

Enterprise Battery Backup Sytem

$8,000

1

$8,000

HVAC Maintenance

HVH

$8,990

1

$8,990

Security and Fire Alarm System-Park Place

Basesix

$1,750

1

$1,750

Security and Fire Alarm System-Cauley Creek

Basesix

$1,450

1

$1,450

523851

$102,940

Hospitality - Items Described

Vendor Name

Cost per

Units

Total

Council Meeting Meals

Various

$550

23

$12,650

Community Meetings - Meals for Staff working through into night

Various

$125

12

$1,500

Breakroom Coffee

TBD

$750

12

$9,000

Golf Cart Rentals for Events

Milton Golf Carts

$400

15

$6,000

Breakroom Supplies (plates, cutlery, etc.)

Various

$250

24

$6,000

523901

$35,150

FY 2024 Proposed Operations

Proposed 9/12/2023 FY 2024 Budget Page 36 of 88

Office Supplies - Items Described

Vendor Name

Cost per

Units

Total

Basic Office Supplies - Folders, Pens, Etc.

Office Depot, Staples, etc.

$500

52

$26,000

New Employee Supplies - Start up Supplies

Office Depot, Staples, etc.

$100

15

$1,500

New Employee Supplies - Nametags

Various

$50

15

$750

New Employee Supplies - Business Cards

Various

$60

15

$900

Carpet in Studio

TBD

$350

2

$700

Interior wayfinding and other signage

Various

$1,000

5

$5,000

531000

$34,850

Postage - Items Described

Vendor Name

Cost per

Units

Total

Postage Machine

Pitney Bowes

$1,657

12

$19,884

Postage Supplies (Postage Labels, etc.)

Pitney Bowes

$88

5

$440

531130

$20,324

Water/Sewage - Items Described

Vendor Name

Cost per

Units

Total

City Hall

Fulton County

$1,500

4

$6,000

531210

$6,000

Electricity - Items Described

Vendor Name

Cost per

Units

Total

Lights (interior/exterior) (City Hall)

Sawnee EMC

$13,400

12

$160,800

Parking Lot Lights (City Hall)

Sawnee EMC

$200

12

$2,400

531230

$163,200

Gasoline/Diesel

Vendor Name

Cost per

Units

Total

Generator (Refuel) (City Hall)

Nixon

$2,000

2

$4,000

523270

$4,000

Office Equipment - Items Described

Vendor Name

Cost per

Units

Total

Council / Court Chambers Chair Replacements

TBD

$100

100

$10,000

Office Chair Replacements

Various

$200

50

$10,000

Other Office Furniture

Office Depot, Staples, etc.

$250

50

$12,500

531702

$32,500

Operating Supplies

Vendor Name

Cost per

Units

Total

Southeastern Paper Group (Cleaning Supplies)

$9,000

1

$9,000

Breakroom Supplies (Paper and plastic products (Amazon/Staples)

Various

$5,750

1

$5,750

531703

$14,750

Furniture Fixtures

Vendor Name

Cost per

Units

Total

Building Fixtures and Programs

Various

$25,000

1

$25,000

542300

$25,000

Computers

Vendor Name

Cost per

Units

Total

City Hall Computer Hardware Supplies

Various

$50,000

1

$50,000

542400

$50,000

Operating Transfers Out - Items Described

Vendor Name

Cost per

Units

Total

Debt Service for City Hall COPS Issuance

$2,046,512

1

$2,046,512

591610

$2,046,512

$2,785,449

Proposed 9/12/2023 FY 2024 Budget Page 37 of 88

Finance (1001511)

1001511

Personnel

FY 2021

FY 2022

FY 2024

Object

Account

Actuals

Revised

YTD 07/31

Annualized

Proposed

511100

Regular Employees

$867,720

$1,007,096

$1,124,247

$897,451

$1,056,895

$1,161,645

$37,398

3%

511500

Excess Regular Salaries

$0

0%

511151

Car Allowance

$4,829

$4,800

$4,000

$4,800

$0

0%

511153

Gym Membership

$703

$780

$180

$675

$765

$360

$180

100%

511300

Overtime

$0

$551

$0

$2,876

$0

0%

512101

Health

$110,582

$128,140

$143,061

$125,519

$149,488

$225,263

$82,202

57%

512102

Long-Term Disability

$5,725

$6,848

$6,554

$5,193

$6,231

$6,683

$129

2%

512103

Dental

$11,106

$10,928

$11,735

$8,482

$10,022

$12,735

$1,000

9%

512104

Life

$4,435

$12,432

$10,494

$8,716

$10,361

$10,537

$43

0%

512200

Social Security (FICA)

$51,528

$58,203

$64,732

$50,764

$60,259

$69,749

$5,017

8%

512300

Medicare

$12,086

$14,034

$15,707

$12,385

$14,605

$16,844

$1,137

7%

512400

Retirement

$139,303

$169,696

$185,940

$142,816

$169,229

$197,480

$11,540

6%

512700

Workers Compensation

$1,438

$1,811

$1,660

$1,161

$1,626

($34)

-2%

Subtotal - Personnel

$1,209,455

$1,415,349

$1,569,110

$1,260,037

$1,486,692

$1,707,722

$138,612

9%

Operations

FY 2021

FY 2022

FY 2024

Object

Account

Actuals

Revised

YTD 07/31

Annualized

Proposed

521200

Professional Services

$22,206

$4,810

$2,000

$98,360

$2,000

$0

0%

521201

Audit

$25,250

$30,505

$34,000

$26,000

$40,000

$6,000

18%

521203

Contractual

$83,862

$47,084

$155,000

$54,161

$58,311

$155,000

$0

0%

521300

Technical Services

$300

$235

$500

$225

$500

$0

0%

523100

Insurance

$0

$277,680

$276,295

$277,680

$0

0%

523300

Advertising

$719

$1,191

$1,000

$338

$1,074

$1,500

$500

50%

523400

Printing & Binding

$704

$1,683

$2,000

$734

$1,434

$2,000

$0

0%

523500

Travel

$0

$2,189

$0

$921

$0

0%

523600

Dues & Fees

$1,105

$2,277

$2,435

$2,285

$2,470

$2,435

$0

0%

523700

Education & Training

$761

$6,553

$21,000

$2,637

$21,000

$0

0%

523901

Hospitality

$176

$211

$250

$556

$500

$250

100%

523903

Merchant Services Charge

$42,530

$62,096

$50,001

$49,087

$68,587

$66,668

$16,667

33%

523904

Finance Charges/Bank Charges

$5,783

$12,676

$10,000

$9,315

$11,315

$10,400

$400

4%

531000

Supplies

$170

$93

$0

$30

$0

0%

531120

Office Supplies

$3,857

$2,355

$2,600

$4,090

$3,000

$400

15%

531130

Postage

$4,896

$4,363

$5,525

$2,298

$3,214

$5,525

$0

0%

531703

Operating Supplies

$16,895

$235

$1,000

$1,095

$2,191

$1,000

$0

0%

579100

Unallocated

$3,118

$6,155

$0

$57

$109

$0

0%

Subtotal - Operations

$212,331

$184,710

$564,991

$528,484

$558,094

$589,208

$24,217

4%

TOTAL FINANCE

$1,421,785

$1,600,060

$2,134,101

$1,788,522

$2,044,786

$2,296,930

$162,829

8%

FY 2023

$ Inc (Dec)

from 2023

FY 2023

$ Inc (Dec)

from 2023

% Inc

(Dec)

% Inc

(Dec)

Proposed 9/12/2023 FY 2024 Budget Page 38 of 88

Finance (1001511)

Professional Services - Items Described

Vendor Name

Cost per

Units

Total

Outside Professional Opinions and Services

Various

$2,000

1

$2,000

521200

$2,000

Audit - Items Described

Vendor Name

Cost per

Units

Total

Annual External Audit

Mauldin and Jenkins

$40,000

1

$40,000

521201

$40,000

Contractual - Items Described

Vendor Name

Cost per

Units

Total

Business License Discovery

S&S Management

$30,000

1

$30,000

Property Tax Billing

Dr. Ferdinand

$35,000

1

$35,000

Financial Advisor

Todd Barnes

$55,000

1

$55,000

Internal Auditor

TBD

$8,750

4

$35,000

521203

$155,000

Technical Services - Items Described

Vendor Name

Cost per

Units

Total

NIGP Code License

NIGP

$500

1

$500

521300

$500

Insurance

Vendor Name

Cost per

Units

Total

APEX General Liab/Professional/Vehcile Ins. Coverage

Various

$277,680

1

$277,680

523100

$277,680

Advertising - Items Described

Vendor Name

Cost per

Units

Total

TSPLOST Required Annual Notice

Various

$250

1

$250

Johns Creek Herald

Various

$250

5

$1,250

523300

$1,500

Printing and Binding - Items Described

Vendor Name

Cost per

Units

Total

Laser Checks

Safeguard Business System

$2,000

1

$2,000

523400

$2,000

Dues and Fees - Items Described

Vendor Name

Cost per

Units

Total

Govn't Finance Officers Association

GFOA

$300

2

$600

Georgia Govn't Finance Officers Association

GGFOA

$150

3

$450

Association of Govn't Accountants

AGA

$135

1

$135

Public Risk Management Association (PRIMA)

$385

1

$385

National Institute of Govn't Purchasing

NIGP

$250

1

$250

Georgia Society of CPAs

GSCPA

$265

1

$265

American Institute of CPAs

AICPA

$250

1

$250

Board of Accountancy

BOA

$100

1

$100

523600

$2,435

Education and Training - Items Described

Vendor Name

Cost per

Units

Total

Training Classes

Carl Vinson Institute of Government

$300

7

$2,100

Govn't Finance Officers Association Conference

GFOA

$3,500

1

$3,500

GGFOA - Fall Conference

GGFOA

$1,500

2

$3,000

Georgia Public Risk Management Association

Georgia PRIMA

$750

2

$1,500

Purchasing Training

Various

$3,000

1

$3,000

Budget Training

Various

$1,500

2

$3,000

Revenue Training

Various

$2,500

1

$2,500

Regional Training Sessions

Munis

$1,200

1

$1,200

CPA Continuing Education Training

Various

$1,200

1

$1,200

523700

$21,000

Hospitality - Items Described

Vendor Name

Cost per

Units

Total

Meetings

Various

$50

10

$500

523901

$500

Merchant Service Fees - Items Described

Vendor Name

Cost per

Units

Total

Credit Card Processing Fee

Bank

$16,667

4

$66,668

523903

$66,668

Proposed 9/12/2023 FY 2024 Budget Page 39 of 88

Finance Charges/Bank Charges - Items Described

Vendor Name

Cost per

Units

Total

Credit Card - Executive Level Card Fees

Bank of America

$200

2

$400

Account Charges

TBD

$2,500

4

$10,000

523904

$10,400

Office Supplies - Items Described

Vendor Name

Cost per

Units

Total

Basic Office Supplies - Folders, Pens, Etc.

Office Depot, Staples, etc.

$50

60

$3,000

531120

$3,000

Postage - Items Described

Vendor Name

Cost per

Units

Total

Letters

USPS

$1

11,000

$5,500

Certified Mail

USPS

$1

25

$25

531130

$5,525

Operating Supplies - Items Described

Vendor Name

Cost per

Units

Total

Other Operating Supplies

Various

$250

4

$1,000

531703

$1,000

$589,208

Proposed 9/12/2023 FY 2024 Budget Page 40 of 88

Fire (1003510)

1003510

Personnel

FY 2021

FY 2022

FY 2024

Object

Account

Actuals

Revised

YTD 07/31

Annualized

Proposed

511100

Regular Employees

$5,115,510

$5,022,965

$7,305,902

$5,952,665

$7,054,092

$7,728,122

$422,220

6%

511102

Hazard Pay

$0

$86,000

$0

0%

511500

Excess Regular Salaries

$0

0%

511153

Gym Membership

$10,203

$10,190

$9,540

$7,860

$9,270

$8,640

($900)

-9%

511154

Paramedic Incentive Pay

$95,000

$92,500

$105,000

$82,500

($22,500)

-21%

511155

Signing Bonus

$0

$20,000

$0

0%

511200

Temporary/PT Employee

$2,400

$0

$7,410

$0

($7,410)

-100%

511400

Holiday Pay

$0

$77,918

$47,240

$54,388

$48,533

($29,385)

-38%

511300

Overtime

$571,526

$481,264

$518,154

$710,034

$882,523

$737,145

$218,991

42%

512101

Health

$1,256,438

$1,332,927

$1,444,603

$1,139,494

$1,346,061

$1,939,316

$494,713

34%

512102

Long-Term Disability

$41,667

$44,248

$42,567

$34,147

$41,106

$44,229

$1,662

4%

512103

Dental

$96,891

$95,443

$105,735

$74,941

$88,278

$105,153

($582)

-1%

512104

Life

$32,449

$65,376

$68,307

$58,907

$70,137

$70,216

$1,909

3%

512200

Social Security (FICA)

$447,862

$428,483

$425,772

$395,969

$471,195

$524,185

$98,413

23%

512300

Medicare

$55,315

$100,210

$99,607

$92,606

$110,199

$122,798

$23,191

23%

512400

Retirement

$1,042,178

$1,089,936

$1,207,202

$939,034

$1,115,732

$1,321,131

$113,929

9%

512700

Workers Compensation

$317,726

$286,704

$287,492

$200,889

$302,715

$15,223

5%

Subtotal - Personnel

$9,085,166

$9,136,246

$11,705,209

$9,756,287

$11,546,370

$13,034,683

$1,329,474

11%

Operations

FY 2021

FY 2022

FY 2024

Object

Account

Actuals

Revised

YTD 07/31

Annualized

Proposed

521200

Professional Services

$1,526

$792

$29,675

$16,113

$19,043

$29,675

$0

0%

521203

Contractual

$32,496

$41,240

$34,366

$40,614

$41,240

$0

0%

521205

Fire IGA

$27,683

$33,528

$35,795

$38,688

$45,722

$36,140

$345

1%

521219

False Alarm Contract Fees

$4,554

$3,824

$4,100

$4,577

$5,409

$4,100

$0

0%

522220

Facility Repair & Maintenance

$123

$1,577

$0

$262

$310

$0

0%

523100

Insurance

$215,932

$163,870

$216,823

$219,757

$216,823

$0

0%

523300

Advertising

$0

$375

$600

$0

$600

$0

0%

523400

Printing & Binding

$340

$1,157

$2,000

$0

$2,000

$0

0%

523500

Travel

$0

$17,560

$14,429

$17,053

$20,725

$3,165

18%

523600

Dues & Fees

$11,758

$9,099

$42,627

$28,448

$33,620

$44,614

$1,987

5%

523700

Education & Training

$26,309

$43,078

$34,870

$37,277

$44,055

$67,175

$32,305

93%

523851

Maintenance Contracts

$59,317

$91,984

$80,806

$49,995

$59,085

$97,270

$16,464

20%

523852

Software Licensing Fee

$63,613

$58,928

$70,751

$66,519

$78,613

$75,460

$4,709

7%

523901

Hospitality

$110

$0

$2,335

$2,760

$0

0%

531110

Other Supplies

-$156,945

$40,190

$29,956

$35,321

$41,743

$50,210

$20,254

68%

531111

Vehicles

$143,066

$157,204

$183,700

$130,238

$153,918

$196,675

$12,975

7%

531114

Medical

$32,781

$27,856

$39,300

$26,944

$31,843

$45,800

$6,500

17%

531120

Office Supplies

$6,796

$5,579

$6,825

$4,724

$5,583

$6,825

$0

0%

531130

Postage

$11

$27

$125

$119

$141

$125

$0

0%

531210

Water/Sewage

$8,609

$9,635

$9,120

$5,594

$6,611

$9,480

$360

4%

531220

Natural Gas

$14,543

$18,449

$15,669

$12,030

$14,217

$16,435

$766

5%

531230

Electricity

$48,938

$53,725

$65,232

$32,610

$38,540

$65,232

$0

0%

531270

Gasoline/Diesel - Fuel

$63,024

$93,855

$71,795

$68,344

$80,770

$106,885

$35,090

49%

531600

Small Equipment

$0

$240

$20,000

$22,322

$26,381

$20,000

$0

0%

531700

Other

$9,556

$9,819

$17,100

$6,752

$7,979

$20,188

$3,088

18%

531703

Operating Supplies

$17,600

$20,558

$18,460

$11,536

$13,633

$21,380

$2,920

16%

531710

Uniforms

$62,991

$21,019

$106,640

$80,576

$95,227

$71,576

($35,064)

-33%

531711

Officer Supplies

$15,144

$8,230

$10,540

$3,055

$3,610

$12,465

$1,925

18%

579100

Unallocated

$0

($13)

$0

0%

Subtotal - Operations

$709,877

$907,081

$1,171,310

$952,933

$1,086,238

$1,279,098

$136,313

9%

TOTAL FIRE

$9,795,043

$10,043,327

$12,876,518

$10,709,220

$12,632,608

$14,313,781

$1,465,787

11%

FY 2023

$ Inc (Dec)

from 2023

FY 2023

$ Inc (Dec)

from 2023

% Inc

(Dec)

% Inc

(Dec)

Proposed 9/12/2023 FY 2024 Budget Page 41 of 88

Fire (1003510)

Professional Services - Items Described

Vendor Name

Cost per

Units

Total

Recruitment Administrative Costs

Various

$125

5

$625

Pre-Employment Background Check

Various

$100

5

$500

Pre-Employment Medical Exam

Concentra

$380

5

$1,900

Psychological Review

Stone and Associates

$350

5

$1,750

Promotional Testing

TBD

$830

30

$24,900

521200

$29,675

Contractual - Items Described

Vendor Name

Cost per

Units

Total

Medical Director

Dr. Dukes

$3,437

12

$41,240

521203

$41,240

Fire IGA - Items Described

Vendor Name

Cost per

Units

Total

Portable Radio Fees

Fulton County

$420

77

$32,340

Fire Consoles (at ChatComm) Radio Fees

Fulton County

$1,900

2

$3,800

521205

$36,140

False Alarm Contract Fees - Items Described

Vendor Name

Cost per

Units

Total

Fees for False Alarm Monitoring Contract

Central Square

$4,100

1

$4,100

521219

$4,100

Insurance - Items Described

Vendor Name

Cost per

Units

Total

Liability / Professional / Vehicle / Property

Travelers

$197,345

1

$197,345

Cancer Insurance

$19,478

1

$19,478

523100

$216,823

Advertising - Items Described

Vendor Name

Cost per

Units

Total

Advertising (RFP's), etc.

Various

$100

3

$300

Advertising for Recruitment to Open Positions

Various

$100

3

$300

523300

$600

Printing and Binding - Items Described

Vendor Name

Cost per

Units

Total

Large Document Printing (Annual Report, etc.)

$2,000

1

$2,000

523400

$2,000

Travel

Vendor Name

Cost per

Units

Total

GA Public Safety Training Center Meal Tickets

$90

34

$3,060

FDIC Travel and Per Diem

$1,500

2

$3,000

Swiftwater Rescue Travel and Per Diem

$548

5

$2,740

Training Activities

$45

150

$6,750

Vision 20/20 Travel and Per Diem

$450

2

$900

Ga EMS Conference Travel and Per Diem

GAEMS

$1,500

2

$3,000

Firefighter Memorial Travel and Per Diem

$425

3

$1,275

523500

$20,725

Dues and Fees - Items Described

Vendor Name

Cost per

Units

Total

National Fire Protection Association

NFPA

$200

1

$200

International Code Council

ICC

$280

1

$280

International Association of Fire Chiefs

IAFC

$280

7

$1,960

Georgia Association of Fire Chiefs (chief officers)

GAFC

$80

7

$560

Georgia Association of Fire Chiefs (fire chief)

$100

1

$100

Metro Atlanta Fire Chiefs Association

MAFCA

$200

1

$200

International Association of Arson Investigators

IAAI

$125

5

$625

Georgia Fire Investigators Association

GFIA

$25

5

$125

Georgia Fire Inspectors Association

GFIA

$25

4

$100

International Society of Fire Service Instructors

ISFSI

$125

1

$125

Georgia EMS Instructor Association

GEMSA

$60

8

$480

National Fire Protection Administration Standards and Codes Access

NFPA

$1,750

1

$1,750

National Registry - Paramedics

NREMT

$32

18

$576

National Registry - EMT's

NREMT

$26

12

$312

Paramedic Certification

State of Georgia

$75

26

$1,950

Emergency Medical Technician Certification

State of Georgia

$75

34

$2,550

FY 2024 Proposed Operations

Proposed 9/12/2023 FY 2024 Budget Page 42 of 88

EMT - Advanced Certification

State of Georgia

$75

4

$300

Other Dues and Fees - Pro Board Cert.

Various

$25

90

$2,250

Fire Dept. Incident Safety Officer Association

FDSOA

$385

1

$385

Child Car Safety Seat Certification (Recert.)

Safe Kids WW

$30

14

$420

CPR Recertification (Cards)

AHA

$26

78

$2,028

ACLS Recertification

AHA

$26

13

$338

Georgia Firefighters Pension Fund Dues

$2,250

12

$27,000

523600

$44,614

Education and Training - Items Described

Vendor Name

Cost per

Units

Total

GPSFIA Spring Arson Conference

GPSFIA

$100

6

$600

Georgia EMS Conference

GEMSA

$250

20

$5,000

Training Facility Fees and Materials

Various

$200

30

$6,000

Webinars and Other On-Demand Training

Various

$250

4

$1,000

Station Study Books, Materials, Test Banks

Various

$1,250

1

$1,250

Fire Conference

FDIC

$1,300

2

$2,600

Georgia Fire Safety Symposium

GPSTC

$125

4

$500

Blue Card Renewals

Blue Card

$255

5

$1,275

GPSIA Spring Conference

GPSTC

$100

2

$200

Swiftwater Rescue Instructor Course

Rescue 3 International

$280

10

$2,800

National Fallen Firefighters Memorial

$340

5

$1,700

Leadership Education and Training Costs

$10,000

1

$10,000

Paramedic School

Faithful Guardian

$10,000

3

$30,000

Training Thermal Imagers

SEEK

$650

2

$1,300

Ga EMS Conference

GAEMS

$1,000

2

$2,000

Vision 20/20 Symposium

Vision 20/20

$475

2

$950

523700

$67,175

Maintenance Contracts - Items Described

Vendor Name

Cost per

Units

Total

Lawn Chemical Treatment (weeds, fertilizer, etc.)

$360

12

$4,320

Dumpster Service

Advanced Disposal

$584

12

$7,008

Pest Control/Exterminators/Rodent Control

Arrow

$477

12

$5,724

Medical Oxygen Service

Airgas

$100

7

$700

Turn-Out Gear and PPE Repairs and Maintenance

Various

$1,500

3

$4,500

Uniform Cleaning and Repairs

Various

$125

20

$2,500

Fire Extinguisher Maintenance on Fire Trucks

Various

$100

30

$3,000

Stove Hood Extinguishing Testing and Repair

TBD

$625

4

$2,500

Radio Tuning, Programming, Repairs

Atlanta Communications

$125

78

$9,750

Self Contained Breathing Apparatus Fit Tests

MES

$31

86

$2,666

SCBA Testing and Repairs

MES

$10,000

1

$10,000

Document Shredding

Allshred

$42

11

$462

Lucas Device Maintenance Contract

Physio Control

$6,000

1

$6,000

Life Pak Annual Maintenance

Physio Control

$1,555

8

$12,440

Oil Separator Service

TBD

$1,250

4

$5,000

HVAC Maintenance Contract

HVH

$3,000

1

$3,000

Generator Maintenance

TBD

$1,025

4

$4,100

Fuel Tank Cleaning

Crompco LLC

$3,400

4

$13,600

523851

$97,270

Software Licensing Fee - Items Described

Vendor Name

Cost per

Units

Total

Online Training Platform

Target Solutions

$23,684

1

$23,684

Online Survey Tools

Survey Monkey

$485

1

$485

Online IFSTA Membership Textbooks

IFSTA

$28

89

$2,492

EKOS System Fuel Management

EKOS

$325

12

$3,900

Site Access Control for Fuel Management

$200

12

$2,400

Knox Box and Click2Enter Service

Knox Box

$2,000

1

$2,000

Knox Cloud Service

Knox

$585

1

$585

Active 911

A911

$1,200

1

$1,200

Handtevi

$1,200

1

$1,200

Drafting Software

Smartdraw

$357

2

$714

Inspections and Pre-Plan Software

APX

$10,800

1

$10,800

Records Management System

ESO

$26,000

1

$26,000

523852

$75,460

Other Supplies - Items Described

Vendor Name

Cost per

Units

Total

Food for Emergency Incidents

Various

$50

20

$1,000

Proposed 9/12/2023 FY 2024 Budget Page 43 of 88

Batteries (Flashlights, SCBA, Portable Radios)

Batteries Plus

$140

34

$4,760

Click to Enter Devices

Click to Enter

$1,100

2

$2,200

Knox Key Secure Devices for Fire Apparatus and brackets

Knox

$1,200

3

$3,600

Filtration Masks and Canisters (FMO)

TBD

$170

2

$340

CO monitor for Investigators

ASA Safety Supply

$108

3

$324

Portable Radio Supplies (straps, microphones, etc.)

TBD / Various

$7,700

1

$7,700

Bank Charger for HQ for assigned radios

Motorola

$1,315

1

$1,315

Kitchenware (pots, pans, plates, cutlery)

TBD

$250

6

$1,500

Bottled Water and Sports Drinks

Various

$4

2,500

$10,000

Lawn Maintenance Equipment - replacements

$1,516

1

$1,516

Coolers for Training and Stations

Coleman

$125

8

$1,000

Hydrant Maintenance Supplies

Various

$4,000

1

$4,000

Fire Investigation Supplies / Tools

Various

$150

1

$150

Pine Straw / Mulch

TBD

$2,500

4

$10,000

Fuel Access Keys

GASBOY

$105

1

$105

Winch Hardware

TBD

$350

2

$700

531110

$50,210

Vehicle Supplies - Items Described

Vendor Name

Cost per

Units

Total

Fire Admin. Vehicles - Preventative Maintenance

Various

$60

27

$1,620

Fire Admin. Vehicles - Minor Vehicle Service

Various

$280

8

$2,240

Fire Admin. Vehicles - Major Vehicle Service

Various

$530

4

$2,120

Apparatus Scheduled Maintenance

Various

$850

22

$18,700

Utility Vehicle Scheduled Maintenance & Minor Repairs

Various

$800

1

$800

Rescue Boat Scheduled Maintenance & Minor Repairs

Various

$1,250

2

$2,500

Tire Replacement

Southern Tire Mart / Nextire

$1,200

34

$40,800

Apparatus - Minor Repairs

Various

$2,250

25

$56,250

Apparatus - Major Repairs

Various

$5,250

8

$42,000

NFPA Required Ladder/Aerial Testing

Consolidated Fleet Service

$1,680

3

$5,040

Pump Maintenance

Ten-8

$375

8

$3,000

Vehicle Cleaning and Detailing

Club Corners Car Wash

$250

8

$2,000

Hydraulic Tool Maintenance

Georgia Fire and Rescue Supply

$575

5

$2,875

Small Motorized Equipment Maintenance

Various

$125

30

$3,750

Air Trailer Maintenance and Air Quality Sampling

MES

$400

12

$4,800

In-House Vehicle Maintenance and Cleaning Supplies

Various

$290

12

$3,480

Pump Testing

Ten-8

$400

8

$3,200

Trailer Service and Tires

TBD

$1,500

1

$1,500

531111

$196,675

Medical - Items Described

Vendor Name

Cost per

Units

Total

Medical Supplies

Various

$3,150

12

$37,800

SWAT Medic Specialized Supplies

Various

$200

5

$1,000

Pharmaceutical

Lillys

$7,000

1

$7,000

531114

$45,800

Office Supplies - Items Described

Vendor Name

Cost per

Units

Total

Inspections Forms

TBD

$1

500

$500

Shipping Fees

USPS, FedEx, UPS

$50

20

$1,000

Stationary

TBD

$75

8

$600

Basic Office Supplies - Folders, Pens, Etc.

Office Depot, Staples, etc.

$235

15

$3,525

Printer Ink Cartridges

Office Depot, Staples, etc.

$50

24

$1,200

531120

$6,825

Postage - Items Described

Vendor Name

Cost per

Units

Total

Letters and Mailings

USPS

$1

250

$125

531130

$125

Water/Sewage - Items Described

Vendor Name

Cost per

Units

Total

Station 61

Fulton County

$260

12

$3,120

Station 62

Fulton County

$95

12

$1,140

Station 63

Fulton County

$215

12

$2,580

Station 64

Fulton County

$220

12

$2,640

531210

$9,480

Natural Gas - Items Described

Vendor Name

Cost per

Units

Total

Station 61

SCANA

$430

12

$5,160

Proposed 9/12/2023 FY 2024 Budget Page 44 of 88

Station 62

SCANA

$330

12

$3,960

Station 63

SCANA

$235

12

$2,820

Station 64

SCANA

$330

12

$3,960

LP Tank @ Station 62 (Emergency Generator)

$535

1

$535

531220

$16,435

Electricity - Items Described

Vendor Name

Cost per

Units

Total

Station 61

Georgia Power

$1,623

12

$19,476

Station 62

Sawnee EMC

$1,325

12

$15,900

Station 63

Sawnee EMC

$1,163

12

$13,956

Station 64

Georgia Power

$1,325

12

$15,900

531230

$65,232

Gasoline/Diesel - Items Described

Vendor Name

Cost per

Units

Total

Gasoline

JRP

$4

4,500

$18,000

Diesel

JRP

$5

16,450

$82,250

Mixed Fuel, Boat Oil, Ethanol Free Fuel

Various

$335

13

$4,355

Diesel Exhaust Fluid

Various

$190

12

$2,280

531270

$106,885

Small Equipment

Vendor Name

Cost per

Units

Total

Small quanity of exercise equipment at each station

$5,000

4

$20,000

531600

$20,000

Other - Items Described

Vendor Name

Cost per

Units

Total

Citizens Fire Academy Uniforms and Supplies

Various

$200

22

$4,400

Community Safety Day

Various

$625

1

$625

Fire and Safety Education Materials

Various

$8,200

1

$8,200

NFPA 921 Hard Copy Book

NFPA

$123

1

$123

Equipment for Honor Guard

Various

$950

1

$950

CPR Classes (Cards, Materials)

AHA

$6

200

$1,200

CPR Supplies (books, face shields, etc.)

Chenning Bete

$1,000

1

$1,000

Stop the Bleed tourniquet supplies

TBD

$2,000

1

$2,000

Camera for Educator/Investigator

Nikon D5600 w/lens

$1,300

1

$1,300

I-Pens for Fire Inspectors

Apple

$130

3

$390

531700

$20,188

Operating Supplies - Items Described

Vendor Name

Cost per

Units

Total

Station 61

Grainger / Various

$580

12

$6,960

Station 62

Grainger / Various

$350

12

$4,200

Station 63

Grainger / Various

$435

12

$5,220

Station 64

Grainger / Various

$350

12

$4,200

HQ - Bunker Gear Soap

Grainger / Various

$200

4

$800

531703

$21,380

Uniforms - Items Described

Vendor Name

Cost per

Units

Total

Utility Uniforms - Full Time Personnel

TBD

$718

88

$63,151

SWAT Medic Tactical Uniforms

TBD

$350

4

$1,400

Replacements for Rips, Tears, Etc.

TBD

$325

15

$4,875

Honor Guard Uniforms

TBD

$430

5

$2,150

531710

$71,576

Officer Supplies - Items Described

Vendor Name

Cost per

Units

Total

Firefighter of the Quarter

Various

$800

4

$3,200

HAZMAT Supplies

Various

$500

4

$2,000

Technical Rescue Equipment Replacement

Various

$1,000

1

$1,000

Fire and Arson Debris Analysis

Various

$500

3

$1,500

Safety Glasses, Work Gloves. Etc.

TBD

$45

89

$4,005

MSA Filters (TEMS Gas Masks)

Various

$76

10

$760

531711

$12,465

$1,279,098

Proposed 9/12/2023 FY 2024 Budget Page 45 of 88

Human Resources (1001540)

1001540

Personnel

FY 2021

FY 2022

FY 2024

Object

Account

Actuals

Revised

YTD 07/31

Annualized

Proposed

511100

Regular Employees

$368,663

$332,531

$368,057

$260,278

$307,608

$461,424

$93,367

25%

511151

Car Allowance

$4,829

$4,800

$4,000

$4,800

$0

0%

511153

Gym Membership

$866

$541

$180

$305

$365

$180

$0

0%

511200

Temporary/PT Employee

$0

0%

512101

Health

$37,404

$33,613

$38,150

$27,435

$31,633

$54,978

$16,828

44%

512102

Long-Term Disability

$2,419

$1,967

$1,773

$1,587

$1,899

$2,092

$319

18%

512103

Dental

$3,450

$2,107

$2,219

$2,541

$3,051

$4,131

$1,912

86%

512104

Life

$1,838

$3,382

$2,817

$2,729

$3,221

$3,599

$782

28%

512200

Social Security (FICA)

$20,841

$18,465

$20,716

$15,455

$18,283

$28,608

$7,892

38%

512300

Medicare

$5,163

$4,526

$4,847

$3,614

$4,276

$6,691

$1,844

38%

512400

Retirement

$60,892

$39,183

$50,430

$43,932

$51,806

$66,947

$16,517

33%

512700

Workers Compensation

$887

$1,032

$516

$570

$646

$130

25%

Subtotal - Personnel

$507,252

$442,175

$494,505

$362,447

$427,512

$634,096

$139,591

28%

Operations

FY 2021

FY 2022

FY 2024

Object

Account

Actuals

Revised

YTD 07/31

Annualized

Proposed

521200

Professional Services

$116,951

$169,987

$23,690

$82,723

$97,763

$29,010

$5,320

22%

521203

Contractual

$3,604

$2,607

$9,150

$580

$685

$28,260

$19,110

209%

521207

Other

$8,789

$15,329

$46,500

$4,048

$29,322

$54,250

$7,750

17%

523100

Insurance

$275,112

$233,935

$0

0%

523300

Advertising

$0

$379

$5,600

$1,633

$2,791

$21,800

$16,200

289%

523500

Travel

$0

$4,100

$1,651

$2,242

$6,100

$2,000

49%

523600

Dues & Fees

$2,452

$1,675

$2,521

$2,409

$3,118

$2,948

$427

17%

523700

Education & Training

$32,769

$25,164

$62,136

$17,210

$22,697

$83,255

$21,119

34%

523901

Hospitality

$1,156

$1,235

$2,875

$1,361

$3,161

$4,825

$1,950

68%

531120

Office Supplies

$798

$1,583

$2,410

$473

$866

$2,210

($200)

-8%

531130

Postage

$411

$202

$500

$493

$904

$750

$250

50%

531703

Operating Supplies

$185

$1,040

$0

$296

$350

$0

0%

531710

Uniforms

$0

$593

$22,600

$12,488

$22,600

$25,000

$2,400

11%

542300

Furniture Fixtures

$0

$6,000

$48

$3,000

($3,000)

-50%

579100

Unallocated

$9,490

$0

0%

Subtotal - Operations

$451,717

$453,729

$188,082

$125,412

$186,548

$261,408

$73,326

39%

TOTAL HUMAN RESOURCES

$958,969

$895,904

$682,587

$487,858

$614,060

$895,504

$212,917

31%

% Inc

(Dec)

FY 2023

$ Inc (Dec)

from 2023

FY 2023

$ Inc (Dec)

from 2023

% Inc

(Dec)

Proposed 9/12/2023 FY 2024 Budget Page 46 of 88

Human Resources (1001540)

Professional Services - Items Described

Vendor Name

Cost per

Units

Total

Employment Law Queries

FMG/Others

$325

50

$16,250

Third-Party HR Consulting

TBD

$300

10

$3,000

Online Grammar Software

Grammarly

$180

4

$720

Survey Software

Surveymonkey

$400

4

$1,600

Online Recruiting Software

Applicant Pro

$610

12

$7,320

Webpage Creative Software

Canva

$120

1

$120

521200

$29,010

Contractual - Items Described

Vendor Name

Cost per

Units

Total

Pre-Employment Assessment Tools

PAN

$3

100

$300

Posters and Notices (1 set per location per update)

$190

9

$1,710

Web-Based Employee Training with LMS and Customization

LinkedIn Learning

$105

250

$26,250

521203

$28,260

Other - Items Described

Vendor Name

Cost per

Units

Total

Employee Assistance Program

ESI Employee Assistance Program

$25

250

$6,250

Employee Lunch n Learns (non-Wellness)

Various

$25

250

$6,250

Employee Appreciation Events

Various

$35

250

$8,750

Employee Recognition Event Awards

Various

$87

250

$21,750

Drug Screenings - New Employees

Concentra/LabCorp

$75

50

$3,750

Background Screenings - Employees and Volunteers

PSI/Others

$150

50

$7,500

521207

$54,250

Advertising - Items Described

Vendor Name

Cost per

Units

Total

Recruiting Text Line Service

Various

$50

12

$600

Department Head Recruiting Costs

Various

$15,000

1

$15,000

Job Ad Writing by Applicant Pro

Various

$120

10

$1,200

Advertisements for Open Positions

Various

$500

10

$5,000

523300

$21,800

Travel - Items Described

Vendor Name

Cost per

Units

Total

Travel GLGPA Conferences

Various

$700

3

$2,100

Travel for PSHRA Conference

Various

$1,000

2

$2,000

Travel for Recruiting as needed

Various

$500

4

$2,000

523700

$6,100

Dues and Fees - Items Described

Vendor Name

Cost per

Units

Total

Society for Human Resource Management

SHRM

$244

3

$732

Public Service Human Resources Association (formerly IPMA)

PSHRA

$420

1

$420

Georgia Local Government Personnel Association

GLGPA

$50

3

$150

Local Events (Chamber/other)

Various

$75

6

$450

Executive Assistant IAAP Membership

IAAP

$200

1

$200

Plan Sponsor Council of America

PSCA

$100

1

$100

Local Membership for SHRM-Atlanta

SHRM-Atlanta

$149

4

$596

Professional Recertification Fees

Various

$300

1

$300

523600

$2,948

Education and Training - Items Described

Vendor Name

Cost per

Units

Total

Tuition Reimbursement (city wide)

Various

$3,000

17

$50,010

Tuition Reimbursement (city wide) Revised FY23 Budget

Various

-

1

$0

Training Programs GLGPA

GLGPA

$1,115

3

$3,345

Training Programs SHRM-ATL

SHRM-Atl

$800

4

$3,200

Attend PSHRA Conference required for Committee Participation

PSHRA

$850

2

$1,700

Leadership Training for City Leaders

Various

$25,000

1

$25,000

523700

$83,255

Hospitality - Items Described

Vendor Name

Cost per

Units

Total

Meals with Candidates for Executive Positions

Various

$50

5

$250

Refreshments for Training Events

Various

$25

15

$375

New Hire Gifts

Various

$30

50

$1,500

Monthly Birthday Cakes

Various

$100

12

$1,200

FY 2024 Proposed Operations

Proposed 9/12/2023 FY 2024 Budget Page 47 of 88

Employee Relations (flowers for funerals, meals for sick/injured, etc.)

$150

10

$1,500

523901

$4,825

Office Supplies - Items Described

Vendor Name

Cost per

Units

Total

Business Cards

$50

4

$200

Office Supplies Unique to HR - Folders, Labels, Etc.

Office Depot, Staples, etc.

$125

12

$1,500

Birthday Cards

Various

$170

3

$510

531120

$2,210

Postage - Items Described

Vendor Name

Cost per

Units

Total

Letters/Compliance Notices

USPS

$1

750

$750

531130

$750

Uniforms - Items Described

Vendor Name

Cost per

Units

Total

City Shirts (for citywide employees)

The Corporate Shop

$25,000

1

$25,000

531710

$25,000

Furniture

Vendor Name

Cost per

Units

Total

Furniture for HR Staff

Various

$3,000

1

$3,000

542300

$3,000

$261,408

Proposed 9/12/2023 FY 2024 Budget Page 48 of 88

IT/GIS (1001535)

1001535

Personnel

FY 2021

FY 2022

FY 2024

Object

Account

Actuals

Revised

YTD 07/31

Annualized

Proposed

511100

Regular Employees

$729,245

$719,484

$742,947

$639,060

$755,154

$787,419

$44,472

6%

511151

Car Allowance

$4,829

$4,800

$4,000

$4,800

$0

0%

511153

Gym Membership

$284

$362

$360

$300

$360

$0

0%

511200

Temporary/PT Employee

$0

$9,009

$9,912

$0

0%

511300

Overtime

$0

$5,231

$0

0%

512101

Health

$72,073

$73,820

$87,805

$80,912

$95,757

$123,169

$35,364

40%

512102

Long-Term Disability

$4,368

$4,645

$3,984

$3,685

$4,426

$4,114

$130

3%

512103

Dental

$6,530

$5,820

$7,208

$4,991

$5,885

$6,568

($640)

-9%

512104

Life

$3,624

$7,611

$6,516

$6,459

$7,667

$7,192

$676

10%

512200

Social Security (FICA)

$42,318

$42,233

$44,157

$37,836

$44,902

$47,567

$3,410

8%

512300

Medicare

$10,252

$10,094

$10,421

$9,015

$10,667

$11,418

$997

10%

512400

Retirement

$116,781

$99,970

$117,229

$100,275

$120,010

$133,861

$16,632

14%

512700

Workers Compensation

$1,389

$1,402

$675

$864

$1,102

$427

63%

Subtotal - Personnel

$991,692

$975,500

$1,026,102

$896,405

$1,060,404

$1,127,570

$101,468

10%

Operations

FY 2021

FY 2022

FY 2024

Object

Account

Actuals

Revised

YTD 07/31

Annualized

Proposed

521200

Professional Services

$259,654

$331,116

$307,345

$205,225

$370,494

$447,840

$140,495

46%

523500

Travel

$0

$2,045

$0

$7,424

$8,099

$0

0%

523600

Dues and Fees

$535

$415

$500

$0

$500

$0

0%

523700

Education & Training

$4,143

$6,200

$20,975

$12,495

$13,631

$20,975

$0

0%

523852

Software Licensing Fee

$518,768

$632,820

$662,930

$637,846

$665,829

$646,002

($16,928)

-3%

523901

Hospitality

$512

$1,695

$750

$87

$175

$750

$0

0%

531120

Office Supplies

$1,693

$479

$1,500

$1,679

$1,832

$1,500

$0

0%

531130

Postage

$0

$15

$0

$242

$0

0%

531280

Mobile Data Charges

$196,822

$188,248

$188,440

$138,462

$169,797

$190,940

$2,500

1%

531290

Telephone Service

$48,804

$55,497

$71,956

$35,540

$43,372

$59,400

($12,556)

-17%

531703

Operating Supplies

$0

$661

$0

$956

$1,462

$0

0%

542400

Computers

$75,142

$61,706

$62,500

$103,476

$123,098

$62,500

$0

0%

542500

Other Computer Equipment

$0

$2,675

$0

0%

Subtotal - Operations

$1,106,073

$1,283,571

$1,316,896

$1,143,432

$1,398,031

$1,430,407

$113,511

9%

TOTAL IT/GIS

$2,097,765

$2,259,071

$2,342,998

$2,039,837

$2,458,435

$2,557,977

$214,979

9%

FY 2023

$ Inc (Dec)

from 2023

FY 2023

$ Inc (Dec)

from 2023

% Inc

(Dec)

% Inc

(Dec)

Proposed 9/12/2023 FY 2024 Budget Page 49 of 88

IT/GIS (1001535)

Professional Services - Items Described

Vendor Name

Cost per

Units

Total

Network Support

Willing Minds

$25,000

1

$25,000

Network Security Tools and Services

Various

$75,000

1

$75,000

GIS Support

Various

$72,000

1

$72,000

Infrastructure Cloud Hosting

Various

$50,000

1

$50,000

Disaster Recovery Services

Agility

$700

12

$8,400

Facility Security

Various

$500

4

$2,000

Hosting

Granicus

$9,850

4

$39,400

Printer/Copier Lease Costs

Kyocera

$4,500

12

$54,000

Backup Server Hardware Maintenance

Dell

$31,000

1

$31,000

Online Communication Tools

Seamless Docs; Civic Comment

$21,000

1

$21,000

Tyler Continuing Education

Tyler

$65,000

1

$65,000

GCIC Access for Police and Court

Georgia Technology Authority

$420

12

$5,040

521200

$447,840

Dues and Fees - Items Described

Vendor Name

Cost per

Units

Total

Association Dues

GMIS

$500

1

$500

523600

$500

Education and Training - Items Described

Vendor Name

Cost per

Units

Total

Conferences, Webinars, and Cyber Security Training

$2,000

6

$12,000

Esri International User Conference

Various

$3,025

1

$3,025

Esri Developer Summit

Various

$3,950

1

$3,950

GMIS Annual Conference

GMIS

$2,000

1

$2,000

523700

$20,975

Software Licensing Fee - Items Described

Vendor Name

Cost per

Units

Total

ESRI Licensing

ESRI

$75,000

1

$75,000

Document Management Maintenance

Optiview

$45,000

1

$45,000

Barracuda E-mail Archiver / Spam Filter

Barracuda

$21,000

1

$21,000

Bentley Microstation

Bentley

$1,000

4

$4,000

Microsoft 365 Licenses

Microsoft

$75,000

1

$75,000

Enterprise Software Licenses

Microsoft

$10,000

2

$20,000

Cisco Smartnet

Cisco

$8,500

1

$8,500

Remote Access

GoToMyPC

$6,000

1

$6,000

Helpdesk Maintenance

FreshService

$13,000

1

$13,000

2FA (Police) Maintenance

2FA

$9,000

1

$9,000

Tyler ERP Maintenance

Tyler

$140,000

1

$140,000

Crowdstrike Antivirus

Crowdstrike

$14,000

1

$14,000

Palo Alto Firewall Maintenance

Sayers

$6,500

1

$6,500

Netmotion Virtual Private Network Maintenance

Newcom Wireless

$8,000

1

$8,000

Records Management System Maintenance (Police)

OSSI

$115,000

1

$115,000

Crime Reports (Police)

Crime Reports

$5,000

1

$5,000

Electronic Warrant Interface Maintenance (Police)

EWI

$1,500

1

$1,500

Adobe Creative Cloud Licenses

Adobe

$1,000

13

$13,000

Adding Users to Existing Programs (like Adobe Pro and InDesign)

$1,000

10

$10,000

New Software (like MySidewalk and OpenGov Portal)

$4,834

3

$14,502

Software Licenses for PD Mobile Units

Various

$5,000

3

$15,000

Backup Software Support

Veeam

$12,000

1

$12,000

Mobile Device Management Platform

AirWatch

$15,000

1

$15,000

523852

$646,002

Hospitality - Items Described

Vendor Name

Cost per

Units

Total

Meetings/Training

$750

1

$750

523901

$750

Office Supplies - Items Described

Vendor Name

Cost per

Units

Total

Basic Office Supplies - Folders, Pens, Etc.

Office Depot, Staples, etc.

$1,500

1

$1,500

531120

$1,500

FY 2024 Proposed Operations

Proposed 9/12/2023 FY 2024 Budget Page 50 of 88

Mobile Data Charges - Items Described

Vendor Name

Cost per

Units

Total

Smartphones Data/Usage Charges

Verizon

$516

175

$90,300

Aircard/Data Devices

Verizon

$456

190

$86,640

Cell Phone/Device Charges

Verizon

$300

25

$7,500

Ipad Device Charges

Verizon

$700

5

$3,500

Cell Phone/Device Repairs

Verizon

$100

30

$3,000

531280

$190,940

Telephone Service - Items Described

Vendor Name

Cost per

Units

Total

City Hall / Police Internet & Phone Circuits

TBD

$3,100

12

$37,200

Station #61 - Analog line

Comcast

$85

12

$1,020

Station #62 - Analog line

Comcast

$85

12

$1,020

Station #63 - Analog line

Comcast

$85

12

$1,020

Autrey Mill Internet and Phone

AT&T

$140

12

$1,680

ChatComm Data Circuit - 10MB Connection

Syncpoint Technologies

$850

12

$10,200

ChatComm Data Circuit Upgrade to 100MB

IXP

$200

12

$2,400

City Hall Television Service

Comcast

$190

12

$2,280

PD South Precinct - Analog line

Direct TV

$75

12

$900

Park Place DSL

Comcast

$140

12

$1,680

531290

$59,400

Computers - Items Described

Vendor Name

Cost per

Units

Total

City Hall Computer Hardware Supplies

$50,000

1

$50,000

Police/Court Computer Hardware Supplies

$10,000

1

$10,000

Fire Computer Hardware Supplies

$2,500

1

$2,500

542400

$62,500

$1,430,407

Proposed 9/12/2023 FY 2024 Budget Page 51 of 88

Legal (1001530)

1001530

Operations

FY 2021

FY 2022

FY 2024

Object Account Actuals Actuals Revised YTD 07/31 Annualized Proposed

521200 Professional Services $142,890 $83,325 $150,000 $80,926 $150,000 $150,000 $0 0%

521206 Legal $288,000 $288,000 $300,000 $216,000 $300,000 $300,000 $0 0%

Subtotal - Operations

$430,890

$371,325

$450,000

$296,926

$450,000

$0

0%

TOTAL LEGAL

$430,890

$371,325

$450,000

$296,926

$450,000

$0

0%

FY 2023

$ Inc (Dec)

from 2023

% Inc

(Dec)

Proposed 9/12/2023 FY 2024 Budget Page 52 of 88

Legal (1001530)

Professional Services - Items Described

Vendor Name

Cost per

Units

Total

Professional Services

$150,000

1

$150,000

521200

$150,000

Professional Services - Items Described

Vendor Name

Cost per

Units

Total

Legal

$300,000

1

$300,000

521206

$300,000

$450,000

FY 2024 Proposed Operations

Proposed 9/12/2023 FY 2024 Budget Page 53 of 88

Police (1003210)

1003210

Personnel

FY 2021

FY 2022

FY 2024

Object Account Actuals Actuals Revised YTD 07/31 Annualized Proposed

511100

Regular Employees

$4,890,896

$4,694,934

$7,711,217

$6,058,959

$7,195,386

$7,986,162

$274,945

4%

511150 Excess Regular Salaries $0 $0 $0 $0 $0 $0 $0 0%

511102

Hazard Pay

$0

$71,085

$0

0%

511152

Housing Stipend

$77,807

$153,029

$153,600

$188,800

$225,600

$230,400

$76,800

50%

511153

Gym Membership

$5,832

$5,410

$4,140

$4,665

$5,565

$4,320

$180

4%

511154

Paramedic Incentive Pay

$5,893

$5,000

$0

0%

511155

Signing Bonus

$0

$10,000

$15,000

100%

511200

Temporary/PT Employee

$52,208

$124,959

$103,954

$73,114

$87,767

$155,469

$51,515

50%

511400

Holiday Pay

$0

$51,945

$44,042

$52,747

$42,137

($9,808)

-19%

511300

Overtime

$356,995

$453,755

$537,799

$347,980

$410,765

$432,356

($105,443)

-20%

512101

Health

$1,063,806

$1,093,294

$1,342,600

$974,426

$1,150,281

$1,617,365

$274,765

20%

512102

Long-Term Disability

$38,051

$42,956

$41,366

$34,417

$41,496

$45,645

$4,279

10%

512103

Dental

$79,364

$76,288

$92,833

$61,239

$72,091

$90,274

($2,559)

-3%

512104

Life

$29,965

$61,777

$66,487

$59,634

$71,085

$72,244

$5,757

9%

512200

Social Security (FICA)

$427,277

$428,757

$471,685

$397,465

$473,077

$528,525

$56,840

12%

512300

Medicare

$89,997

$101,847

$110,343

$92,991

$110,675

$123,756

$13,413

12%

512400

Retirement

$914,745

$933,438

$1,227,593

$912,471

$1,089,635

$1,343,842

$116,249

9%

512700

Workers Compensation

$219,826

$182,236

$230,337

$138,243

$249,521

$19,184

8%

Subtotal - Personnel

$8,252,661

$8,428,763

$12,145,899

$9,398,446

11,134,413

$12,937,016

$791,117

7%

Operations

FY 2021

FY 2022

FY 2024

Object Account Actuals Actuals Revised YTD 07/31 Annualized Proposed

521200

Professional Services

$64,472

$68,608

$106,130

$49,263

$77,493

$125,080

$18,950

18%

521207

Other

$13,908

$11,414

$40,000

$68,089

$127,048

$40,000

$0

0%

521208

Police IGA

$132,180

$152,948

$146,010

$92,713

$146,010

$150,610

$4,600

3%

521219

False Alarm Contract Fees

$22,432

$25,326

$30,000

$16,457

$25,000

$30,000

$0

0%

522210

Equip. Repair & Maintenance

$24,134

$23,381

$71,775

$9,824

$61,775

$60,215

($11,560)

-16%

522220

Facility Repair & Maintenance

$18,860

$28,491

$77,490

$10,493

$99,836

$21,640

($55,850)

-72%

522310

Rental - Land & Buildings

$50,806

$56,774

$68,220

$55,540

$69,475

$64,560

($3,660)

-5%

523100

Insurance

$463,927

$381,154

$398,183

$439,620

$398,183

$0

0%

523200

Communications

$384

$137

$11,000

$580

$6,000

$11,000

$0

0%

523300

Advertising

$1,676

$1,363

$8,400

$5,605

$6,400

$8,400

$0

0%

523500

Travel

$22,324

$62,601

$125,328

$54,131

$110,328

$165,178

$39,850

32%

523600

Dues & Fees

$50,194

$86,226

$111,279

$79,091

$118,012

$116,141

$4,862

4%

523700

Education & Training

$39,965

$53,455

$127,225

$38,536

$117,225

$130,125

$2,900

2%

523901

Hospitality

$21,891

$19,569

$54,225

$17,738

$20,412

$62,725

$8,500

16%

523903

Merchant Services Charge

$183

$321

$0

$271

$425

$0

0%

531110

Other Supplies

$3,825

$2,813

$68,020

$29,593

$65,505

$32,500

($35,520)

-52%

531111

Vehicles

$231,895

$367,499

$294,397

$290,449

$329,397

$298,372

$3,975

1%

531112

Evidence Supplies

$8,219

$6,586

$22,320

$6,857

$22,320

$0

0%

531113

Buy Money

$1,860

$2,928

$10,000

$330

$660

$10,000

$0

0%

531120

Office Supplies

$13,318

$16,781

$28,840

$15,414

$19,318

$28,840

$0

0%

531130

Postage

$1,813

$1,474

$4,379

$1,315

$1,854

$4,379

$0

0%

531220

Natural Gas

$978

$902

$1,092

$840

$1,392

$1,092

$0

0%

531230

Electricity

$2,581

$2,719

$2,880

$1,346

$1,613

$2,880

$0

0%

531270

Gasoline/Diesel - Fuel

$229,711

$383,416

$225,375

$241,865

$326,903

$327,000

$101,625

45%

531703 Operating Supplies $20,341 $38,480 $77,416 $13,851 $121,871 $66,100 ($11,316) -15%

531710 Uniforms $107,689 $115,300 $125,795 $78,884 $103,884 $134,045 $8,250 7%

531711

Officer Supplies

$188,750

$299,620

$380,137

$147,727

$198,014

$290,945

($89,192)

-23%

Subtotal - Operations

$1,738,316

$2,210,288

$2,615,916

$1,766,420

2,602,327

$2,602,330

($13,586)

-1%

TOTAL POLICE

$9,990,977

$10,639,051

$14,761,815

$11,164,867

13,736,740

$15,539,346

$777,531

5%

FY 2023

$ Inc (Dec)

from 2023

FY 2023

$ Inc (Dec)

from 2023

% Inc

(Dec)

% Inc

(Dec)

Proposed 9/12/2023 FY 2024 Budget Page 54 of 88

Police (1003210)

Professional Services - Items Described

Vendor Name

Cost per

Units

Total

Investigative Applications

Apple, Various

$50

10

$500

Digital Investigative Tools

Various

$1,000

3

$3,000

Court Ordered Expenditures (suspect phone records, etc.)

$100

40

$4,000

Language Line Services

8A Translation

$100

20

$2,000

Maintenance and Repair for Live Scan

Live Scan

$3,000

2

$6,000

AI Photo (Intel)

Clearview

$6,500

1

$6,500

Pole Camera Installation and Electricity

Various

$500

3

$1,500

Video Focus Pro

Salient Sciences

$1,800

1

$1,800

Cellphone Tracking Software - ZETX

Lexis Nexis

$3,000

1

$3,000

Guardian Tracking - Annual Maintenance

Guardian

$2,500

1

$2,500

Power Details

$4,000

1

$4,000

Access Control System

NCI

$500

1

$500

Background/Hiring - Drug Tests

Concentra

$65

15

$975

Background/Hiring - Medical Tests

Concentra

$185

15

$2,775

Background/Hiring - Physical Fitness Test - Supplies

Various

$100

2

$200

Background/Hiring - Prescreening Applicants

PSI

$185

20

$3,700

Background/Hiring - Psychological Tests

Stone and Associates

$450

15

$6,750

Background/Hiring - Written Test & Others

Standard and Associates

$25

200

$5,000

Crime Reports (crimereports.com)

Motorola

$5,000

1

$5,000

Palentine Tech - Electronic Warrant System

Palentine

$1,500

2

$3,000

Power DMS Suite

Innovative Data Solutions

$8,000

1

$8,000

Promotional Testing - Consultant for Challenges

Standard and Associates

$300

1

$300

Promotional Testing - New Question Bank

Standard and Associates

$45

30

$1,350

Promotional Testing - Written and Oral Test

Standard and Associates

$3,400

1

$3,400

Transcription Services

Various

$100

20

$2,000

Social Media Archiver

Archive Social

$800

6

$4,800

Graphic Design Expenses for Social Media

Various

$800

1

$800

CANVA for Social Media

Various

$140

1

$140

Intellihub

Various

$200

75

$15,000

Survey Monkey

$400

1

$400

Pictory Video Design

Pictory

$500

1

$500

Flowcode - QR code generator

Flowcode

$400

1

$400

Drone 41 Software

PIX4D

$500

1

$500

Document Shredding

Shred Ahead

$275

12

$3,300

Georgia Technology Authority (GCIC user fees)

GTA

$600

1

$600

Cordico Shield (76-100 sworn)

Lexipol

$12,000

1

$12,000

AceK9 Watch Dog Monitoring

Ace K9

$175

5

$875

Law Enforcement Management Software (Records/CID GCIC access)

LEMS/LX

$2,415

1

$2,415

SWAT MD

Various

$4,100

1

$4,100

Nutrition Fitness Challenge

Various

$750

2

$1,500

521200

$125,080

Other - Items Described

Vendor Name

Cost per

Units

Total

Inmate Medical

$1,000

40

$40,000

521207

$40,000

Police IGA - Items Described

Vendor Name

Cost per

Units

Total

Inmate Housing

Various

$60

850

$51,000

Fulton Radio ChatComm Consoles

Fulton County

$1,850

2

$3,700

Fulton Radio Subscriber Fee

Fulton County

$417

230

$95,910

521208

$150,610

False Alarm Contract Fees - Items Described

Vendor Name

Cost per

Units

Total

Fees

Central Square

$30,000

1

$30,000

521219

$30,000

Equipment Maintenance and Repairs - Items Described

Vendor Name

Cost per

Units

Total

RAPID's IRIS Scanner Maintenance

Rapid ID

$2,500

1

$2,500

DVR Repairs and Equipment

AXON

$9,000

1

$9,000

Radio Repair and Maintenance

Motorola

$250

30

$7,500

Flock Camera Maintenance/Moves

Flock

$500

10

$5,000

Proposed 9/12/2023 FY 2024 Budget Page 55 of 88

Taser Repair and Maintenance

Taser

$3,350

1

$3,350

Weapon Repair and Maintenance

Various

$35

275

$9,625

Red Dot Maintnenace Kits

Various

$40

100

$4,000

INTOX-Alco Sensor repair and maintenance

INTOX

$1,500

1

$1,500

Laser/Radar Recertification

Various

$95

32

$3,040

Laser/Radar Repair

Various

$3,000

1

$3,000

License Plate Recognition Ext. Service Agreement

Vigiliant

$550

4

$2,200

Vigilant LPR Maint/Repair

SSI

$1,000

2

$2,000

Fitness Equipment

Various

$5,000

1

$5,000

Drone repair and maintenance

Various

$2,500

1

$2,500

522210

$60,215

Facility Repairs and Maintenance - Items Described

Vendor Name

Cost per

Units

Total

K9 Field Maintenance

Various

$1,000

1

$1,000

Security Cameras (maintenance and replacement of eol cameras, new cameras, etc.)

Avigilon

$1,200

1

$1,200

South Precinct - Facility (HVAC service, access control, facility repairs)

Various

$2,500

1

$2,500

Cleaning Services for South Precinct

Sam Kote

$400

24

$9,600

Pest Control - South Precinct

Halliday Pest Control

$70

12

$840

Locksmith - change, repair locks

Allied Lock & Key

$150

10

$1,500

Police Facility (access control - South Precinct

$5,000

1

$5,000

522220

$21,640

Rental - Land and Building - Items Described

Vendor Name

Cost per

Units

Total

South Precinct - Rent

Old Alabama LLC

$3,930

12

$47,160

South Precinct - Common Area Maintenance

Old Alabama LLC

$750

12

$9,000

Offsite Storage

Various

$700

12

$8,400

522310

$64,560

Insurance - Items Described

Vendor Name

Cost per

Units

Total

Liability / Professional / Vehicle / Property

Travelers

$353,663

1

$353,663

Liability / Professional / Vehicle / Property

Travelers

$44,520

1

$44,520

5231000

$398,183

Communications - Items Described

Vendor Name

Cost per

Units

Total

Printed Brochures and Newspaper Inserts

Various

$500

10

$5,000

Graphic Design

Various

$1,000

2

$2,000

Banners for Booth/Table

Various

$500

6

$3,000

Classified (other than hiring)

Johns Creek Herald

$250

4

$1,000

523200

$11,000

Advertising - Items Described

Vendor Name

Cost per

Units

Total

Brochures and Advertisements

Various

$250

2

$500

Job Announcements

Various

$200

4

$800

Promotional Materials - Recruiting

Various

$500

6

$3,000

Public Resource Pamphlets

Various

$500

1

$500

Facebook Push /Boost Posts

Facebook

$20

75

$1,500

Social Media Management Tool

HootSuite

$1,600

1

$1,600

Stock Photo Licenses

Various

$10

50

$500

523300

$8,400

Travel - Items Described

Vendor Name

Cost per

Units

Total

Investigative Travel Expenditures

Various

$250

8

$2,000

JCAF Team Training Travel

Various

$1,000

4

$4,000

JCAF GA Narcotics Off Assc Conf Travel

Various

$500

4

$2,000

Training - advanced homicide, etc. Travel

Various

$500

3

$1,500

Training - intelligence gathering, Travel

Various

$1,000

5

$5,000

Fingerprint Certification Testing

$1,000

1

$1,000

Background Travel Expenditures

Various

$500

3

$1,500

Command College - Lodging

Various

$550

10

$5,500

Command College - Per Diem

Various

$335

10

$3,350

Driver Training Conf Travel

Various

$1,250

2

$2,500

FTO Conference Travel

Various

$650

1

$650

GA Public Safety Training Center Meal Tickets

GPSTC

$90

60

$5,400

Firearms Instructors Course Travel

Various

$1,000

6

$6,000

Proposed 9/12/2023 FY 2024 Budget Page 56 of 88

Use of Force Seminar

Various

$1,000

2

$2,000

TAC Conf Travel

Various

$1,250

2

$2,500

American Polygraph Seminar Travel

APAAS

$2,580

3

$7,740

Tri-State Polygraph Conf Travel

TSPC

$1,190

3

$3,570

RMS System Fall Conf Travel

Various

$1,200

2

$2,400

RMS System Spring Conf Travel

Various

$1,200

3

$3,600

CALEA Conference Travel

Various

$1,500

3

$4,500

GPAC Conference Travel

Various

$800

2

$1,600

Internal Affairs Conf Travel

Various

$2,200

3

$6,600

IACP Technology Conference Travel

IACP

$2,200

2

$4,400

IACP Conference Travel

IACP

$2,250

4

$9,000

Command Staff Training (FBI,GACP, etc.)

Various

$10,000

1

$10,000

GA Assoc of Women in Public Safety

Various

$650

3

$1,950

SMILE Conf Travel

Various

$1,400

1

$1,400

New Canine Travel

Various

$9,200

1

$9,200

Advanced Training Classes Travel

Various

$1,750

3

$5,250

Accident Recon & Drone Training Travel

Various

$1,500

2

$3,000

Traffic Unit Training Travel

Various

$1,400

6

$8,400

FBI Leeda Media & Pub Rel Training Tra

Various

$2,000

2

$4,000

ALERRT Conference - Travel

Various

$2,000

2

$4,000

Bike Unit Training Travel

Various

$600

4

$2,400

CIT International Conf Travel

Various

$1,400

1

$1,400

Nat'l Tactical Off. Association Conf. Travel

NTOA

$1,875

5

$9,375

CNT Training Travel (NTOA)

Various

$1,875

1

$1,875

Axon Accelerate Conference Travel

Axon

$2,200

2

$4,400

Peer Support Conference Travel

Various

$1,000

8

$8,000

Travel for Traffic Incident Management Conference

$2,218

1

$2,218

523500

$165,178

Dues and Fees - Items Described

Vendor Name

Cost per

Units

Total

Cellebrite Licenses (cell phone forensics)

Cellebrite

$4,500

1

$4,500

Georgia Narcotics Association

GNA

$15

4

$60

GPS Tracking - Pole Cam Fees

Coleman

$588

2

$1,176

Audio Translation

GMR

$250

5

$1,250

International Association of Identification

IAI

$60

3

$180

Int'l Association Law Enforcement Ed/Trainers

IALEETA

$50

3

$150

Int'l Asst'n for Law Enform't Firearms Instructors

IALEFI

$55

3

$165

Int'l Association of Property and Evidence

IAPE

$50

3

$150

Investigative Search Database (Transunion)

TLO

$2,500

1

$2,500

Pawn Search Database Access Fees

LEEDS online

$6,000

1

$6,000

A Child is Missing Yearly Fee

ACIM

$400

1

$400

Regional Organized Crime Information Center

ROCIC

$300

1

$300

First Two (investigative tool - mobile address)

First Two

$6,000

1

$6,000

National Tactical Officers Association

NTOA

$150

1

$150

Certifications - Nat'l Narcotics Dog Det. Asst'n

NNDDA

$55

5

$275

Dues - National Narcotics Det Dog Association

NNDDA

$320

1

$320

Licenses (DEA, GA Pharm, Fulton CO)

Various

$500

1

$500

Georgia Police Accreditation Coalition Fees

GPAC

$250

1

$250

Leadership Johns Creek - Alumni Dues

LJC

$50

2

$100

National Accreditation - Annual Fees

CALEA

$4,800

1

$4,800

National Accreditation Mock Assessment fees

Various

$500

1

$500

State Certification Fee

GA Chiefs Asst'n

$475

1

$475

National Information Officers Association

NIOA

$80

3

$240

Crime Analysis Meetings (Metro)

Various

$500

1

$500

FBI National Academy Association

FBINAA

$125

2

$250

American Polygraph Association

APA

$150

3

$450

Georgia Polygraph Association

GPA

$55

3

$165

American Association of Police Polygraphists

AAPP

$125

3

$375

GA Terminal Agency Coordinators Association

TAC

$25

8

$200

Georgia Records Association

GRA

$60

8

$480

Cherokee SO Training Facility Fee

Cherokee SO

$2,500

2

$5,000

Johns Creek Indoor Gun Range

Johns Creek Indo

$175

83

$14,525

Sharpshooters Gun Range

Sharpshooters

$12,000

1

$12,000

Georgia Association of Chiefs of Police Dues

GACP

$300

5

$1,500

Proposed 9/12/2023 FY 2024 Budget Page 57 of 88

International Association of Chiefs of Police

IACP

$150

5

$750

Atlanta Metropol

Metropol

$125

4

$500

ICAC Computer Forensic Software

Magnet Forensics

$5,200

1

$5,200

CrimeDex

$100

1

$100

Software Fee - RxGym Site for CrossFit JCPD

RxGym

$500

1

$500

Callyo 10-21 Video License

Callyo

$6,000

1

$6,000

GA Assoc of Chaplains

GALEC

$20

6

$120

NAMI Annual Membership

NAMI

$40

1

$40

CIT International Annual Memebrship

CITIA

$25

1

$25

Int'l Mountain Bike Association Membership

RAMBO

$100

4

$400

Notary Fee (Reimbursement)

Various

$100

20

$2,000

Fingerprint Comparison Software

FCS

$700

1

$700

Peace Officers Annuity & Benefit Fund

POAB

$23,700

1

$23,700

GrayKey

Grayshift

$10,000

1

$10,000

International Municipal Signal Association and Certification Renewal

$110

2

$220

523600

$116,141

Education and Training - Items Described

Vendor Name

Cost per

Units

Total

A/C/B/D-Squad Training Courses

Various

$1,250

4

$5,000

CIT International Conference

Various

$450

1

$450

Crime Scene Investigation Recertification

Various

$350

3

$1,050

Training - intelligence gathering, etc.

Various

$200

5

$1,000

Training - advanced homicide, etc.

Various

$250

3

$750

Training - Evidence/CSI

Various

$400

5

$2,000

JCAF Training Classes

Various

$500

4

$2,000

GA Narcotics Officers Association Conference

GNOA

$500

4

$2,000

Advanced Training Classes

Various

$1,500

3

$4,500

Accreditation Conference

GPAC

$200

2

$400

Accreditation Training

GPAC

$1,000

1

$1,000

Annual Conference - CALEA

CALEA

$675

2

$1,350

Internal Affairs - Annual Conference

Various

$600

3

$1,800

Records Management System - Fall Conf.

Superion

$800

2

$1,600

Records Management System - Spring Conf.

Superion

$800

3

$2,400

IACP Technology Conference

IACP

$600

2

$1,200

American Polygraph Assoc Annual Seminar

APAAS

$400

3

$1,200

Tri State Polygraph Conference

GBI

$100

3

$300

Polygraph School

AIIOP

$5,750

1

$5,750

Command College - Registration Fees

Columbus State

$1,000

10

$10,000

Leadership Training

Various

$1,000

5

$5,000

CPR Recertification

Chat Tech

$7

100

$700

Firearms Instructors Update Course

Various

$500

6

$3,000

Fitness Coordinators Training

Various

$1,000

6

$6,000

Less Lethal Instructor Re-Cert Training

Various

$1,000

2

$2,000

Peace Officer Standards and Training Fees

POST

$4,000

1

$4,000

Taser Instructor Recertification

Taser

$500

3

$1,500

Terminal Agency Coordinator Conference

GA TAC

$225

2

$450

Blue Guns for Training

Various

$100

25

$2,500

Use of Force Seminar

Daigle Law Group

$500

2

$1,000

FBI LEEDA Leadership Institute

FBI LEEDA

$2,100

4

$8,400

Driver Instructor Training

Various

$500

2

$1,000

Department Training Classes - drug response, etc.

Various

$500

15

$7,500

Jiu Jitsu

Various

$500

14

$7,000

SWAT Training Classes

Various

$750

7

$5,250

Training Classes

Various

$500

2

$1,000

Traffic Unit- Training classes

Various

$795

6

$4,770

Accident Recon & Drone Training

Various

$500

2

$1,000

STOP program

Various

$1,600

1

$1,600

Cops and Special Ops Training Classes

Various

$800

10

$8,000

SMILE (social media) Conference

Various

$500

1

$500

GA Assc of Women in Public Safety

GAWPS

$185

3

$555

Police Cyclist Course for Bike Patrol

IPMBA

$400

4

$1,600

FBI LEEDA Media & Public Relations

FBI LEEDA

$700

2

$1,400

NTOA Conference Registration

NTOA

$500

5

$2,500

AXON Body Worn Certification (2-Year)

AXON

$300

1

$300

Proposed 9/12/2023 FY 2024 Budget Page 58 of 88

AXON Accelerate Conference

AXON

$600

2

$1,200

ALERRT Conference Registration

ALERRT

$500

2

$1,000

Peer Support Confference

Various

$250

8

$2,000

International Municipal Signal Association Conference and traffic signal training

$825

2

$1,650

523700

$130,125

Hospitality - Items Described

Vendor Name

Cost per

Units

Total

Gifts for Children

Various

$20

300

$6,000

Traffic Safety Class (gifts)

Various

$10

250

$2,500

K-9 Stuffed animals

Hero Industries

$4,500

3

$13,500

K-9 Theamed Baseball Trading Cards

Various

$250

5

$1,250

Water, Snacks, etc. for Background/Hiring

Various

$4,000

1

$4,000

Annual Awards Banquet

Various

$3,500

1

$3,500

Annual Luncheon

Various

$375

4

$1,500

Awards

Various

$1,500

1

$1,500

JCCAPS Awards

Various

$750

1

$750

CPA Class Meals

Various

$800

16

$12,800

CPA Graduation

Various

$2,000

2

$4,000

Student P S Academy (Drinks/Awards)

Various

$75

7

$525

JCCAPS Quaterly Meeting

Various

$800

4

$3,200

Coffee with a Cop

Various

$100

12

$1,200

Food for EOC or Critical events

Various

$250

14

$3,500

Hotel stays for Emergency Operations Center events

Various

$150

20

$3,000

523901

$62,725

Other Supplies - Items Described

Vendor Name

Cost per

Units

Total

Flock VMS

Flock

$1,000

15

$15,000

Pole mounted LPR Expansion

Flock

$3,500

5

$17,500

531110

$32,500

Vehicles - Items Described

Vendor Name

Cost per

Units

Total

Patrol Cars - Priority Service Oil Changes and Quick Repairs

Alpharetta Auto

$69

400

$27,600

Patrol Cars - Minor Vehicle Service

Alpharetta Auto

$300

170

$51,000

Patrol Cars - Major Vehicle Service

Alpharetta Auto or Dealership

$600

125

$75,000

Patrol Cars - Batteries

Alpharetta Auto or Dealership

$180

50

$9,000

Patrol Cars - Tires

Nextire

$130

250

$32,500

Body Shop Deductible

PAC

$2,500

7

$17,500

Cars - Car Wash

Club Corners

$11

725

$7,975

CID and Admin. Vehicles - Oil Changes

Various

$32

29

$928

CID and Admin. Vehicles - Minor Vehicle Service

Various

$300

20

$6,000

CID and Admin. Vehicles - Major Vehicle Service

Various

$600

15

$9,000

CID and Admin. - Tires

Nextire

$130

50

$6,500

City Hall Vehicles - Oil Changs

Various

$69

51

$3,519

City Hall Vehicles - Minor Vehicle Service

Various

$250

17

$4,250

City Hall Vehicles - Major Service

Various

$500

22

$11,000

Cars - Detailed Cleaning

Club Corners

$25

20

$500

Motors - Oil Changes

Harley Davidson

$150

6

$900

Motors - Minor Vehicle Service

Harley Davidson

$400

6

$2,400

Motors - Major Vehicle Service

Harley Davidson

$1,200

6

$7,200

Motors - Tires

Harley Davidson

$300

8

$2,400

Motors - Detail Cleaning Supplies

Various

$50

6

$300

Motors - Trailer Maintenance

Various

$400

1

$400

Motors - Supplies (motor covers, laser holders)

Various

$2,000

1

$2,000

Trailer Maintenance & Repair

Various

$2,500

1

$2,500

Confidential Tags and New Tags

Department of Driver Services

$30

25

$750

Decals - Replacements for Field Damage

EC Signs

$500

5

$2,500

Decals - Promotional (pink, armed forces, etc.)

EC Signs

$500

10

$5,000

Decal / TRV

TBD

$2,500

1

$2,500

Windshield Repair

Glass Plus

$250

10

$2,500

In-Car Printers

Brother

$475

10

$4,750

531111

$298,372

Evidence Supplies - Items Described

Vendor Name

Cost per

Units

Total

Test Kits (Blood Alcohol, Gun Shot Reside, Etc.)

Various

$500

8

$4,000

Proposed 9/12/2023 FY 2024 Budget Page 59 of 88

Protective Devices (Gloves, Shoe and Suit Covers, etc.)

Tyvek, others

$1,000

5

$5,000

Documentation Supplies (bags, boxes, vials, swabs, bushes, testing kits)

Various

$1,000

7

$7,000

Reporting/Recording Crime Scene Supplies (DVDs, labels, ink cartridges, shipping costs)

Various

$750

8

$6,000

Scales (annual calibration)

Rite Weight

$320

1

$320

531112

$22,320

Buy Money - Items Described

Vendor Name

Cost per

Units

Total

Investigative Funds

n/a

$500

20

$10,000

531113

$10,000

Office Supplies - Items Described

Vendor Name

Cost per

Units

Total

Basic Office Supplies - Folders, Pens, Etc.

Office Depot, Staples, etc.

$150

80

$12,000

Copy Paper/Business Cards/Letterhead

Various

$1,375

4

$5,500

Printer Ink Cartridges

Staples, etc.

$50

50

$2,500

Printer Toner

Staples, etc.

$250

4

$1,000

Binders for Training Materials

Staples, etc.

$4

85

$340

Forms

Alpha Graphics

$2,500

1

$2,500

Paper Ticket Books (backup system)

Pro Solutions

$2,000

1

$2,000

Thermal Paper

NewComm

$2,600

1

$2,600

Background/Hiring Booklet

Various

$10

40

$400

531120

$28,840

Postage - Items Described

Vendor Name

Cost per

Units

Total

Postage Machine Supplies (Postage Labels, etc.)

Pitney Bowes

$300

12

$3,600

Courier Services

Various

$100

5

$500

Mailing Services

UPS, FedEx

$25

5

$125

Letters

USPS

$0.50

250

$125

Certified Mail

USPS

$1

25

$29

531130

$4,379

Natural Gas - Items Described

Vendor Name

Cost per

Units

Total

South Precinct

Fireside

$91

12

$1,092

531220

$1,092

Electricity - Items Described

Vendor Name

Cost per

Units

Total

South Precinct

Sawnee EMC

$240

12

$2,880

531230

$2,880

Gasoline/Diesel - Items Described

Vendor Name

Cost per

Units

Total

Gasoline (Non-Public Safety Vehicles)

Various

$1

42,000

$42,000

Gasoline

Various

$1

285,000

$285,000

531270

$327,000

Operating Supplies - Items Described

Vendor Name

Cost per

Units

Total

Breakroom Supplies (Coffee, Cleaning, plates, napkins, etc.)

Various

$450

12

$5,400

Batteries (radios, stingers, cameras, defib, L3 Mic packs, etc.)

Various

$300

12

$3,600

First Aid Kits

Various

$750

1

$750

Bike Patrol - maintenance, replacement parts, etc.

Various

$1,000

8

$8,000

Citizens Police Academy

Various

$2,500

1

$2,500

Grammarly Software

Grammarly

$150

1

$150

Community Programs (STOP/CPA/Leadership JC/etc.)

Various

$1,800

10

$18,000

Defib FRX Pads

Southeastern Emergency Equipment

$36

100

$3,600

Defib Batteries

Boundtreee

$115

50

$5,750

Stryker CR2 AED Batteries

Stryker Med

$225

15

$3,375

Stryker CR2 AED Pads

Stryker Med

$125

35

$4,375

Storage Bins

Various

$10

20

$200

TLR (Weapon Light) Parts

Various

$10

90

$900

Camera maintenance, parts, etc.

Various

$1,500

1

$1,500

TRV Supplies

Various

$8,000

1

$8,000

531703

$66,100

Uniforms - Items Described

Vendor Name

Cost per

Units

Total

Police Uniforms - Patrol, Command Staff

T&T

$750

80

$60,000

Patch/Rank Insignia

T&T

$2

450

$675

Proposed 9/12/2023 FY 2024 Budget Page 60 of 88

Patrol Armor Skin

T&T

$125

25

$3,125

Patrol LBV

T&T

$150

25

$3,750

Armor Skin Shirts

T&T

$60

100

$6,000

Shoe Allowance

Various

$150

100

$15,000

Crime Scene Technicians - Uniforms and Rain Gear

T&T

$350

2

$700

Traffic Unit Uniforms

T&T

$1,000

4

$4,000

Motors - Uniforms

Various

$1,000

3

$3,000

K9 Uniforms

T&T

$1,000

5

$5,000

Records Uniforms

T&T

$400

8

$3,200

Crisis Negotiations Uniforms

Various

$265

3

$795

SWAT Team Uniforms (BDU's, Jump Suit, Training Shirts, Boots)

Various

$1,000

7

$7,000

Clothing Allowance - Detectives, Internal Affairs (CMD)

Various

$500

20

$10,000

Bike Patrol Uniforms (COP)

Various

$600

5

$3,000

CIT Uniforms

T&T

$500

1

$500

JCCAPS Uniforms - New Positions (Shirts, Pants, Belts, Coats, Traffic Vest, Hats, Gloves)

T&T

$650

2

$1,300

JCCAPS Uniforms - Replacements (Shirts, Pants, Belts, Coats, Traffic Vest, Hats, Gloves)

T&T

$150

25

$3,750

SWAT Team New Operator Needs

Various

$250

7

$1,750

SWAT Boots

Various

$150

10

$1,500

531710

$134,045

Officer Supplies - Items Described

Vendor Name

Cost per

Units

Total

Patrol Supplies (Flex cuffs, valve masks, report guides, quick ID guides)

Various

$6,000

1

$6,000

Investigations Resources (books, applications)

Various

$400

1

$400

ID Cards

Various

$18

140

$2,520

Canine Needs (Veterinary Care, Food, Tags, Treats)

Various

$3,000

12

$36,000

Canine Resources (bite sleeve, tracking software, etc.)

Various

$1,300

2

$2,600

New Canine

Various

$15,000

1

$15,000

Annual Law Enforcement Handbooks

Thompson West

$50

80

$4,000

ASP Baton

Tactical Gear Supply

$115

15

$1,725

Badges

T & T

$150

100

$15,000

Flashlights - Strion

Tactical Gear Supply

$150

15

$2,250

Flashlights - Weapon

Tactical Gear Supply

$130

40

$5,200

Hand Cuffs

Tactical Gear Supply

$50

15

$750

Leather Gear/Holster

Tactical Gear Supply

$225

50

$11,250

Leather Gear/Duty Belts

Tactical Gear Supply

$100

50

$5,000

Nylon Duty Gear for Bikes/K-9

Tactical Gear Supply

$225

12

$2,700

Driver Training Supplies (cones, bumpers) (SS)

Various

$1,000

1

$1,000

Munitions (.45, .223, 12GA, 9MM, .308, Sim, 40mm, etc.)

Various

$93,500

1

$93,500

Officer Trauma Kits and Supplies

Various

$5,500

1

$5,500

Other Range Supplies

Various

$5,000

1

$5,000

Pepper Spray

Various

$500

1

$500

TI Simulator Supplies

TI

$3,500

1

$3,500

Naloxone Replacement

Various

$75

85

$6,375

Red Dot Sights

Tac Gear

$550

10

$5,500

Admin Holsters for Red Dot Sights

Tac Gear

$75

100

$7,500

40mm Accessories (Bags, Slings, Lights)

Tac Gear

$300

10

$3,000

Molle Pouches for LBV

Tac Gear

$100

20

$2,000

Resources (Taser platforms, holsters, medic kits, munitions)

Various

$1,400

8

$11,200

Misc Equipment (stud finder/tapes/wood etc)

Various

$1,000

1

$1,000

Gear (knee pads/eyewear/pouches)

Various

$275

7

$1,925

Accident Investigation Supplies (crash zone software update, diagnostics, total station etc.)

Alco Sensors, InTox9000, others

$10,000

1

$10,000

Alco-Sensors and Alco-Sensor Tubes for UPD (TEU)

Various

$500

7

$3,500

30 liter Dry Gas Tank (Alco-Sensor calibrations)

Various

$300

1

$300

JCCAPS equipment

Various

$250

25

$6,250

Trunk or Treat/Community Safety Day Supplies (COP)

Various

$3,000

3

$9,000

Childrens Program Supplies

Various

$4,000

1

$4,000

531711

$290,945

$2,602,330

Proposed 9/12/2023 FY 2024 Budget Page 61 of 88

Public Works (1004110)

1004110

Personnel

FY 2021

FY 2022

FY 2024

Object

Account

Actuals

Revised

YTD 07/31

Annualized

Proposed

511100

Regular Employees

-$3,186

$0

0%

511150

Excess Regular Salaries

$0

0%

511153

Gym Membership

-$12

$45

$0

0%

511300

Overtime

$0

0%

512101

Health

$0

0%

512102

Long-Term Disability

$0

0%

512103

Dental

$0

0%

512104

Life

$0

0%

512200

Social Security (FICA)

-$186

$0

0%

512300

Medicare

-$43

$0

0%

512400

Retirement

-$159

$0

0%

512700

Workers Compensation

-$2,085

$0

0%

Subtotal - Personnel

-$5,671

$45

$0

0%

Operations

FY 2021

FY 2022

FY 2024

Object

Account

Actuals

Revised

YTD 07/31

Annualized

Proposed

521200

Professional Services

$195,405

$258,957

$272,500

$66,663

$272,500

$0

0%

521202

Jacobs (fka CH2M Hill)

$2,580,158

$2,696,004

$2,773,006

$2,014,707

$2,773,006

$2,950,811

$177,805

6%

521207

Other Professional Services

$0

$67,510

$0

$67,510

$0

($67,510)

-100%

521208

Other IGA

$89,821

$82,283

$68,532

$53,519

$68,532

$0

0%

521210

Contracted

$1,956,889

$2,006,660

$2,086,800

$1,479,071

$2,030,155

$2,201,800

$115,000

6%

522200

Repairs & Maintenance

$138,521

$54,147

$100,000

$51,008

$100,000

$0

0%

523300

Advertising

$9,451

$5,750

$7,000

$7,750

$7,000

$0

0%

523500

Travel

$119

$0

0%

523600

Dues & Fees

$2,921

$2,729

$6,000

$3,174

$5,250

$6,000

$0

0%

523901

Hospitality

$26

$1,301

$5,500

$62

$5,500

$0

0%

531000

Supplies

$1,022

$18

$0

0%

531111

Vehicles

$267

$19

$0

0%

531120

Office Supplies

$21,164

$6,406

$2,600

$3,909

$2,600

$0

0%

531130

Postage

$486

$250

$500

$363

$500

$0

0%

531230

Electricity

$818,797

$805,820

$830,076

$609,866

$830,076

$833,676

$3,600

0%

531703

Operating Supplies

$63,922

$64,232

$125,000

$72,061

$125,000

$135,000

$10,000

8%

591610

Operating Transfers Out

$273,717

$228,098

$273,717

$0

0%

Subtotal - Operations

$6,152,686

$6,258,293

$6,618,741

$4,590,251

$6,562,096

$6,857,636

$238,895

4%

TOTAL PUBLIC WORKS

$6,147,016

$6,258,338

$6,618,741

$4,590,251

$6,562,096

$6,857,636

$238,895

4%

% Inc

(Dec)

FY 2023

$ Inc (Dec)

from 2023

FY 2023

$ Inc (Dec)

from 2023

% Inc

(Dec)

Proposed 9/12/2023 FY 2024 Budget Page 62 of 88

Public Works (1004110)

Professional Services - Items Described Vendor Name Cost per Units Total

Engineering Services

Various

$25,000

7

$175,000

Traffic Counts

Various

$2,500

11

$27,500

Traffic Modeling

Various

$25,000

1

$25,000

Transportation Planning

Various

$15,000

3

$45,000

521200

$272,500

Jacobs Contract - Items Described

Vendor Name

Cost per

Units

Total

Public Works Department Professional Service Contract

$2,950,811

1

$2,950,811

521202

$2,950,811

Other IGA - Items Described

Vendor Name

Cost per

Units

Total

Animal Control

Fulton County

$68,532

1

$68,532

521208

$68,532

Contracted - Items Described

Vendor Name

Cost per

Units

Total

Pavement Markings

Various

$25,000

2

$50,000

Traffic Signal Maintenance Contract

Siemens ITS

$400,000

1

$400,000

Right of Way Maintenance Contract OPTECH, YELLOWSTONE $1,470,000 1 $1,470,000

Intersection Geometric Improvements

Various

$90,000

1

$90,000

Utility Location Contract

TBD

$99,800

1

$99,800

Environmental Education and Waste Reduction

AM and KNFB

$70,000

1

$70,000

Adopt a Road Program Management

$10,000

1

$10,000

Recycling and Putrescible Waste Disposal

Conex/Conservation Excellence

$4,500

1

$4,500

Roll-Off Service

Waste Management

$7,500

1

$7,500

521210

$2,201,800

Repairs and Maintenance - Items Described

Vendor Name

Cost per

Units

Total

Emergency Repairs and Weather Events

$25,000

4

$100,000

522200

$100,000

Advertising - Items Described

Vendor Name

Cost per

Units

Total

Advertisements

Various

$250

28

$7,000

523300

$7,000

Dues and Fees - Items Described

Vendor Name

Cost per

Units

Total

Call Before You Dig - Quarterly Dues

Georgia 811

$1,500

4

$6,000

523600

$6,000

Hospitality - Items Described

Vendor Name

Cost per

Units

Total

Food for Emergency Operation Center events

Various

$250

10

$2,500

Hotel stays for Emergency Operations Center events

Various

$150

20

$3,000

523901

$5,500

Office Supplies - Items Described

Vendor Name

Cost per

Units

Total

Basic Office Supplies - Folders, Pens, Etc.

Office Depot, Staples, etc.

$50

52

$2,600

531110

$2,600

Postage - Items Described

Vendor Name

Cost per

Units

Total

Letters and Mailings

USPS

$1

1,000

$500

531130

$500

Electricity - Items Described Vendor Name Cost per Units Total

Streetlights (~3400) in subdivisions and along major roadways

Sawnee EMC

$48,000

12

$576,000

53 Traffic Signals plus school flashers

Sawnee EMC

$2,400

14

$33,600

Streetlights for 23 subdivisions and 3 major roadways

Georgia Power

$16,273

12

$195,276

26 Traffic Signals plus school flashers

Georgia Power

$2,400

12

$28,800

531230

$833,676

Operating Supplies - Items Described

Vendor Name

Cost per

Units

Total

Proposed 9/12/2023 FY 2024 Budget Page 63 of 88

'Touch a Truck' Day Supplies

Various

$5,000

1

$5,000

Glass Recycling Program

$50,000

1

$50,000

Hazardous Waste Disposal Event

KNFB

$75,000

1

$75,000

Safety Equipment

$5,000

1

$5,000

531703

$135,000

Operating Transfers Out - Items Described

Vendor Name

Cost per

Units

Total

Debt Service for $4M Resurfacing Loan at 3.31% interest

GTIB, State Road and Tollway Authority

$22,810

12

$273,717

591610

$273,717

$6,857,636

Proposed 9/12/2023 FY 2024 Budget Page 64 of 88

Recreation and Parks (1006110)

1006110

Personnel

FY 2021

FY 2022

FY 2024

Object Account Actuals Actuals Revised YTD 07/31 Annualized Proposed

511100

Regular Employees

$152,634

$153,452

$565,604

$190,791

$255,813

$723,474

$157,870

28%

511153

Gym Membership

$261

$107

$180

$15

$30

$0

($180)

-100%

511151

Car Allowance

$0

$1,200

$400

$1,200

$4,800

$3,600

300%

511200

Temporary/PT Employee

$79,026

$87,207

$109,096

$107,181

$160,348

$252,981

$143,885

132%

511300

Overtime

$0

$162

$0

0%

512101

Health

$39,567

$38,020

$69,100

$48,054

$60,783

$197,493

$128,393

186%

512102

Long-Term Disability

$911

$1,111

$1,686

$1,170

$1,597

$4,124

$2,438

145%

512103

Dental

$2,820

$3,271

$4,218

$3,284

$4,127

$17,658

$13,440

319%

512104

Life

$710

$1,789

$2,614

$1,978

$2,687

$6,612

$3,998

153%

512200

Social Security (FICA)

$13,439

$14,513

$45,673

$17,662

$24,541

$60,540

$14,867

33%

512300

Medicare

$2,753

$3,394

$11,603

$4,131

$5,740

$14,159

$2,556

22%

512400

Retirement

$22,336

$18,726

$59,598

$27,763

$38,817

$122,991

$63,393

106%

512700

Workers Compensation

$489

$731

$12,234

$546

$1,367

($10,867)

-89%

Subtotal - Personnel

$314,947

$322,483

$882,806

$402,974

$556,229

$1,406,199

$523,393

59%

Operations

FY 2021

FY 2022

FY 2024

Object Account Actuals Actuals Revised YTD 07/31 Annualized Proposed

521200

Professional Services

$3,365

$1,385

$5,000

$29,864

$35,294

$5,000

$0

0%

521202

Jacobs (f/k/a CH2M)

$272,043

$247,095

$256,620

$0

$256,620

$0

($256,620)

-100%

521210

Contracted

$1,074,973

$1,172,000

$1,963,500

$1,017,038

$1,963,500

$2,123,500

$160,000

8%

522320

Rental - Equip. & Vehicles

$35,477

$11,285

$18,500

$10,892

$12,872

$18,500

$0

0%

523300

Advertising

$369

$350

$0

$2,630

$3,108

$0

0%

523400

Printing & Binding

$0

$4,999

$8,805

$1,062

$8,805

$0

0%

523500

Travel

$26

$1,922

$30,592

$3,069

$30,592

$0

0%

523600

Dues & Fees

$3,690

$11,619

$7,375

$3,491

$4,126

$7,575

$200

3%

523700

Education & Training

$427

$886

$500

$173

$204

$500

$0

0%

523901

Hospitality

$20,055

$15,834

$20,500

$15,821

$18,698

$20,500

$0

0%

523903

Merchant Services Charge

$472

$3,360

$1,000

$1,117

$1,320

$1,000

$0

0%

531111

Vehicles

$0

$1,500

$17,304

$20,450

$1,500

$0

0%

531120

Office Supplies

$875

$132

$3,490

$8,310

$9,821

$3,490

$0

0%

531130

Postage

$0

$200

$0

$200

$0

0%

531210

Water/Sewage

$80,659

$67,937

$131,220

$74,284

$115,000

$131,220

$0

0%

531220

Natural Gas

$4,996

$5,819

$5,304

$5,476

$6,472

$5,304

$0

0%

531230

Electricity

$121,816

$114,567

$180,000

$97,614

$140,000

$276,000

$96,000

53%

531600

Small Equipment

$0

$2,165

$2,500

$0

$2,500

$0

0%

531703

Operating Supplies

$118,400

$194,876

$412,420

$273,449

$412,420

$390,000

($22,420)

-5%

531710

Uniforms

$0

$669

$1,000

$830

$981

$1,000

$0

0%

Subtotal - Operations

$1,737,642

$1,856,899

$3,050,026

$1,562,424

$3,040,282

$3,027,186

($22,840)

-1%

TOTAL RECREATION AND PARKS

$2,052,590

$2,179,382

$3,932,832

$1,965,398

$3,596,511

$4,433,385

$500,553

13%

FY 2023 $ Inc (Dec)

from 2023

FY 2023 $ Inc (Dec)

from 2023

% Inc (Dec)

Proposed 9/12/2023 FY 2024 Budget Page 65 of 88

Recreation and Parks (1006110)

Professional Services - Items Described

Vendor Name

Cost per

Units

Total

Survey for Potential Parkland

TBD

$5,000

1

$5,000

521200 $5,000

Contracted - Items Described

Vendor Name

Cost per

Units

Total

Parks Maintenance Contract

PLM

$1,200,000

1

$1,200,000

Basic Maintenance of Future Park Areas

Various

$40,000

1

$40,000

Landscaping (City Hall) Quarterly Planting

PLM

$3,000

4

$12,000

Lawn Chemical Treatment (City Hall) (weeds, fertilizer, etc.)

PLM

$300

6

$1,800

Lawn Maintenance (City Hall)

PLM

$2,500

12

$30,000

Adult Co-Ed Softball

TBD

$1,700

1

$1,700

Cauley Creek Maintenance

$800,000

1

$800,000

Clubhouse Instructor Fees (Free Outdoor Fitness)

Various

$1,000

30

$30,000

Park Place Instructors, Speakers, Etc.

Various

$8,000

1

$8,000

521210

$2,123,500

Rental - Equipment and Vehicles - Items Described

Vendor Name

Cost per

Units

Total

Light Rental for Events (3 movies, 4 concerts, 1 holiday event) $500 10 $5,000

Mini-Bus Rental (for Park Place Field Trips)

BusMax

$250

42

$10,500

Charter Bus Rental (Park Place Field Trips)

Cooper Transportation

$1,500

2

$3,000

522320

$18,500

Printing and Binding - Items Described

Vendor Name

Cost per

Units

Total

Annual Parks Guide & Special Needs Program Guide

Various

$1

6,364

$7,955

Other Brochures and Flyers

Various

$50

17

$850

523400

$8,805

Travel - Items Described

Vendor Name

Cost per

Units

Total

JCAT Hotels (three rooms, two nights)

$150

6

$900

JCAT Staff/Coaches Food (24 meals)

$10

24

$240

Mileage (Meetings, etc.)

$540

1

$540

Hotel for GRPA Annual Conference (7 room nights between two individuals)

$150

9

$1,350

Travel and per diem costs

$27,282

1

$27,282

Per Diem for GRPA Annual Conference (3 meals per day, 4 days, 2 staff)

$10

28

$280

523500

$30,592

Dues and Fees - Items Described

Vendor Name

Cost per

Units

Total

GRPA Annual Agency Dues

GRPA

$750

1

$750

NRPA Annual Membership Dues

NRPA

$165

1

$165

GRPA District 7 Dues

GRPA

$100

1

$100

NRPA CPRP Renewal Fee

NRPA

$60

1

$60

Music Licensing Fees

Various

$900

2

$2,000

Online Registration Program - Annual Fee

Rec1

$4,500

1

$4,500

523600

$7,575

Education and Training - Items Described

Vendor Name

Cost per

Units

Total

GRPA Annual Conference

GRPA

$200

2

$400

GRPA Programmers - Spring Workshop

GRPA

$25

2

$50

GRPA Programmers - Fall Workshop

GRPA

$25

2

$50

523700

$500

Hospitality - Items Described

Vendor Name

Cost per

Units

Total

Park Place - Group Food Activities (lunch'n'learns, potluck dinner entrée, special occasion parties)

$200

30

$6,000

Park Place - Promotional Items (branded items, bingo prizes, T-shirts, etc.)

$1,125

4

$4,500

Park Place - Water, Coffee, and Coffee Supplies

$77

52

$4,000

Park Place - Promotional Items (branded items, bingo prizes, T-shirts, etc.)

$1,000

4

$4,000

Park Place - Water, Coffee, and Coffee Supplies

$500

4

$2,000

523901

$20,500

FY 2024 Proposed Operations

Proposed 9/12/2023 FY 2024 Budget Page 66 of 88

Merchant Service Charges - Items Described

Vendor Name

Cost per

Units

Total

Credit Card Processing Fee

Bank

$3

400

$1,000

523903

$1,000

Vehicles - Items Described

Vendor Name

Cost per

Units

Total

Park Golf Carts (tune up, tire repair, batteries, etc.)

Action Specialty Carts

$300

5

$1,500

531111

$1,500

Office Supplies - Items Described

Vendor Name

Cost per

Units

Total

Park Place - Basic Office Supplies - Folders, Pens, Etc.

Office Depot, Staples, etc.

$35

26

$910

Park Place - Main Printer/Copier - Toner and Ink Cartridges

$300

3

$900

Park Place - Color Printer - Toner and Ink Cartridges

$189

8

$1,512

Park Place - Desk Printer - Ink Cartridges

$84

2

$168

531120

$3,490

Postage - Items Described

Vendor Name

Cost per

Units

Total

Letters and Mailings

USPS

$1

400

$200

531130

$200

Water/Sewage - Items Described

Vendor Name

Cost per

Units

Total

Park Irrigation and Bathrooms

Fulton County

$10,935

12

$131,220

531210

$131,220

Natural Gas - Items Described

Vendor Name

Cost per

Units

Total

Park Place

EMC Gas

$208

12

$2,496

Autrey Mill - Propane

North Georgia Propane

$234

12

$2,808

531220

$5,304

Electricity - Items Described

Vendor Name

Cost per

Units

Total

Parks and Park Buildings

Sawnee EMC, Georgia Power

$23,000

12

$276,000

531230

$276,000

Small Equipment - Items Described

Vendor Name

Cost per

Units

Total

Newtown Clubhouse fitness equipment

Various

$250

4

$1,000

Park Place (small equipment purchases)

Various

$1,500

1

$1,500

531600

$2,500

Operating Supplies - Items Described

Vendor Name

Cost per

Units

Total

Adaptive Recreation Events/Programs

Various

$5,000

1

$5,000

City Hall Christmas Tree Set-up & Take-down, Storage

$35,000

1

$35,000

Additional Special Events

$150,000

1

$150,000

Special Events and Programming

$200,000

1

$200,000

531703

$390,000

Uniforms - Items Described

Vendor Name

Cost per

Units

Total

PT Rec Leader Uniforms

Various

$50

20

$1,000

531710

$1,000

$3,027,186

Proposed 9/12/2023 FY 2024 Budget Page 67 of 88

Capital Projects and Enhancements (Fund 301)

Summary of Funded Requests

Funded

1

City Council (City Clerk)

Municipal Elections (Transition In-House 2025)

250,000

2

City Council (City Manager)

One Johns Creek

25,000

3

Human Resources

Health Insurance Preventative Care Incentive Credits

162,500

4

Information Technology

IT/PD Evidence Fire Suppression System

225,000

5

Information Technology

Migration to Tyler Content Manager Enterprise

80,000

6

Recreation

Creekside Park Amphitheater (Bandshell and Terraced Seating behind City Hall)

5,000,000

7

Recreation

Daffodil Planting

10,000

$5,752,500

Details of Funded Requests

1

Municipal Elections (Transition In-House 2025)

Funded:

$250,000

Requested by: City Council (City Clerk) Requested: $250,000

2 One Johns Creek Funded: $25,000

Requested by: City Council (City Manager) Requested: $25,000

3 Health Insurance Preventative Care Incentive Credits Funded: $162,500

Requested by: Human Resources Requested: $162,500

4

IT/PD Evidence Fire Suppression System

Funded:

$225,000

Requested by:

Information Technology

Requested:

$225,000

5

Migration to Tyler Content Manager Enterprise

Funded:

$80,000

Requested by:

Information Technology

Requested:

$80,000

Staff provided options for transitioning the conduct of municipal elections away from Fulton County to either in-house staff or a partnership with other north Fulton

County cities with the costs associated with each alternative. Council elected to transition to having staff conduct municipal elections beginning with the 2025

General Election. Staff working with a consultant has begun the process of developing a timeline for activities leading up this election. Training, information

gathering and research are slated to take place through the end of 2023. Accordingly, the elections line item in the Clerk’s department for the proposed FY2024

Budget is $462K which includes an increase of $135K to cover election training, information gathering and research. The balance of this line item is programmed

in the event the City would need to engage Fulton County to conduct a Special Election before the City takes over the conduct of the 2025 General Election.

Several activities (naming an elections superintendent, identifying and securing polling places and selecting and purchasing equipment) are also anticipated in

FY2024, but not funded as part of the proposed FY2024 Budget shared with Council on July 11, 2023. This Capital Project will provide funding to plan for this

effort.

A Capital Project is defined as an expenditure that has an expected useful life of three (3) years or more with an estimated total cost of $50,000 or more. An

Enhancement is a request for expanded/improved services beyond the current service level in the adopted budget. Departmental requests for Capital Projects and

Enhancements have been prioritized and funded to the extent possible within available resources. The seven enhancements recommended for funding are

summarized in a table below and then described more fully on the pages that follow.

During construction of City Hall, the gas fire suppression system specified in the plans was removed as a cost saving measure, replaced with standard water fire

sprinklers. Water poses a major threat to critical IT systems and police evidence, and needs to be replaced with the system originally specified.

To promote wellness at the City of John’s Creek, Human Resources will introduce a wellness plan for 2024 where employees will receive a reduction off their

health insurance premiums by completing preventative care visits throughout the year. The goal for the city is to create a culture of wellness that educates and

promotes employee well-being. This will reduce bi-weekly insurance premium rates for participating employees by $25 per pay period. Encouraging employees to

complete preventative care is expected to decrease the City’s loss ratio, which in turn will result in the opportunity to seek more competitive premium rates.

One Johns Creek is a collaborative initiative working to reduce substance use among youth while promoting a thriving culture of community wellness by

connecting entities across sectors of the community by using a coalition with representatives from each of 12 roles: youth, parents, businesses, media, schools,

youth-serving organizations, law enforcement, civic/volunteer organizations, religious/fraternal organizations, healthcare professionals, state/local/tribal

government, and substance abuse organizations. Since the inception of One Johns Creek in 2020, several Johns Creek elected officials and staff have

volunteered their time and talents to serve as advisors and consultants. One Johns Creek has been assisting with promotion and participation in the Drug Take

Back Days, working directly with Johns Creek schools through school counseling and other means, and formalizing their coalition of support across the

community. This initiative was not funded in the proposed FY2024 Budget shared with Council on July 11, 2023, but per Council direction on August 22, 2023, it

is being funded as a Capital Project.

We currently use Filebound as the retention repository for all city documents. Tyler Content Manager is currently used for all ERP related documents. Moving to

TCM consolidates services into one document repository, all in an interface familiar to staff.

Proposed 9/12/2023 FY2024 Budget Page 68 of 88

6

Creekside Park Amphitheater (Bandshell and Terraced Seating behind City Hall)

Funded:

$5,000,000

Requested by:

Recreation

Requested:

$5,000,000

7

Daffodil Planting

Funded:

$10,000

Requested by:

Recreation

Requested:

$10,000

At the Retreat in January 2023, Council confirmed Creekside Park as a strategic priority. Creekside Park is the City’s most direct, visible implementation of the

Town Center Plan and demonstrates the Council’s commitment to creating a community gathering space in Town Center. As the project progresses through the

necessary right-of-way acquisition and environmental permitting, at the June 2023 Work Session, Council reviewed the project status and financials. Council

confirmed its commitment to fully funding the construction of Creekside Park. Through TSPLOST I and II, Council has previously set aside funding for the

signature trail which will meander through the constructed wetland area within the existing south pond area, lead up to and around the north pond (behind City

Hall) as well as connecting up to East Johns Crossing. Council has also set aside funds freed up through the American Rescue Plan Act, the Fiscal Year 2022

end-of-year surplus, and Fiscal Year 2023 for engineering and right-of-way. However, funds have not yet been identified to fund the construction of the

Amphitheater (Bandshell and Terraced Seating behind City Hall). The requested funding would be added to the budget for construction and is anticipated to cover

most if not all of the cost of the signature amphitheater (with a 40x40 stage and angled (1:12) roof). The amphitheater includes both the bandshell as well as the

terraced seating between the stage and City Hall.

Symbolizing new beginnings in a caring community, in 2023 the City hosted its first Daffodil Days which encouraged community participation through a week-long

give-back and volunteer efforts and culminated in a celebration of the community’s collaborative achievements with a market at City Hall in late March. To build

on this new tradition, the requested enhancement would allow for a mass planting of daffodils in all City parks.

Proposed 9/12/2023 FY2024 Budget Page 69 of 88

Infrastructure Maintenance Accrual (Fund 302)

Beginning Ending

Maintenance Accruals

Balance

Contributions Projects

Balance

Roads and Right-of-Way

$5,243,865

$6,759,939

$4,350,000

$7,653,804

Sidewalks and Trails

$1,419,372

$635,568

$400,000

$1,654,940

Traffic Signal System

$2,402,101

$809,684

$200,000

$3,011,785

Bridges, Tunnels, and Dams

$2,102,420

$842,764

$0

$2,945,184

Parks

$2,295,358

$2,040,877

$1,850,000

$2,486,235

Fire Stations

$1,811,995

$291,000

$350,000

$1,752,995

City Hall

$603,104

$255,000

$400,000

$458,104

Land Acquisition

$4,952,498

$1,015,884

$0

$5,968,382

Total

$20,830,713 $12,650,715 $7,550,000

$25,931,428

Summary of Requests

Accrual

Funded

1

City Hall - HVAC Replacement - Phase III

City Hall

$200,000

2

City Hall - General Repairs and Maintenance

City Hall

$200,000

3

Fire Station Repairs and Maintenance

Fire Stations

$150,000

5

Fire Station Roof Repairs for Station #61

Fire Stations

$200,000

6

Resurfacing (Main Roads + Neighborhood Roads)

Roads and Right-of-Way

$3,000,000

7

Roadway Patching

Roads and Right-of-Way

$600,000

9

Road and Right-of-Way Maintenance Materials

Roads and Right-of-Way

$400,000

10

Pavement Marking Refreshes and Restriping

Roads and Right-of-Way

$200,000

11

Sign Maintenance Materials

Roads and Right-of-Way

$150,000

12

Concrete Repairs and Maintenance

Sidewalks and Trails

$400,000

13

Traffic Signal Maintenance Materials and Detection Replacements

Traffic Signal System

$200,000

14

Park Maintenance Materials

Parks

$1,400,000

15 Park Refreshes (Existing Parks) Parks

$450,000

Total

$7,550,000

The Council created the Infrastructure Maintenance Accrual in 2016 to set aside funds for the care and maintenance of existing

assets and infrastructure. The annual investment has grown each year and accrual amounts have been adjusted based on improved

understanding of maintenance costs. When comparing FY2023 to FY2024, the contribution to the accrual has been adjusted by

inflation, with the exception of the Fire Stations and City Hall Accruals, to ensure the funding set aside for future repairs and

maintenance will keep up with the cost of the future work. Those accruals were set according to the Capital Reserve Study

completed August 2021, which also addresses inflationary costs and replacement costs for items referenced within those accruals.

FY2024

Proposed 9/12/2023 FY2024 Budget Page 70 of 88

Infrastructure Maintenance Projects Described

City Hall Repairs and Maintenance/Facilities

1

$200,000

2

$200,000

General repairs and maintenance of various systems at City Hall. Since moving into the City Hall building, there have been

several needed repairs for all of the existing systems. The repairs were started in the 2022 budget and will need to be continued

into the 2024 budget. Based on historical actuals, the requested $75,000 for FY 2024 is anticipated to cover the following items:

Plumbing Repairs: $10,000

Electrical Repairs: $10,000

Roof Repairs: $2,000

Window Repairs: $10,000

Door Repairs/Replacements: $10,000

Safety Related Repairs (fire alarm control panel, other alerting devices): $13,000

HVAC Repairs: $20,000

An additional item for the Facility Repairs, is the re-surfacing of the parking lot at City Hall. Last year Public Works resurfaced the

front two drive isles, but the remaining parking lot is still needed to be completed. The entire project is estimated to cost

approximately $280K, which could be separated into two fiscal years with $125,000 in FY2024 and the remaining balance in

FY2025.

City Hall - General Repairs and Maintenance

By design, the expenditures in the Infrastructure Maintenance Accrual do not equal the level of investment each year as the fund

is designed to build up for the larger expenditures by spreading the cost out over the years leading up to the expenditure for a

major replacement such as a the roof at Park Place or a bridge rebuild.

City Hall - HVAC Replacement - Phase III

The heating, ventilation, and cooling systems (HVAC) for City Hall has been a significant concern over the years. This entire

system is operated by four rooftop units (RTUs) and over 80 plenum induction PIUs operating in zones throughout the building.

The RTUs would begin heating and or cooling the building and then once the desired room temperature is reached, the PIUs

would maintain the temperature throughout the building during business hours. However, the initial RTU’s did not have forced

heated air capabilities, so the existing PIUs had to do most of the work which has caused them the failure rate to be accelerated

on an already aged system. The 2022 & 2023 budgets allowed the replacement/repair of the four RTUs to have the heating

capabilities needed. Now this project continues with the replacement/repairing of the smaller PIU’s scattered throughout all three

floors. In the FY2023 budget there is funding for replacing/upgrading 12 of the existing PIU’s. The requested $200,000 for

FY2024 is anticipated to cover the replacement of several more PIUs that are beginning to show signs of failing. The additional

PIU replacements will be prioritized based on current repair cost/issues and their ability to properly manage the conditioned air

space that they cover.

Proposed 9/12/2023 FY2024 Budget Page 71 of 88

Fire Station Repairs and Maintenance

3

Fire Station Repairs and Maintenance

$150,000

5

Fire Station Roof Repairs for Station #61

$200,000

Road and Right-of-Way Projects

6

Resurfacing (Main Roads + Neighborhood Roads)

$3,000,000

The proposed funding is anticipated to provide for incidental repairs needed throughout the year to include: plumbing, electrical,

HVAC, structural, and mechanical (such as overhead door and motor repairs) at all four fire stations. As the fire station are

operated 24 hours a day, every day of the year, repairs are needed to maintain the functionality of these buildings. This funding

request can be described in two categories: Incidental Repairs totaling $54,000 and Identified Repairs/Replacements totaling

$96,000. Within the $96,000 of Identified Repairs/Replacements are the following three projects: HVAC @ Station 61 on

Dormitory Side: $70,000. This side of the station was poorly designed and is no longer meeting the needs of the occupied space.

The plan is to have this entire side of the station re-designed by Trane to better control the heating, cooling, and humidity

conditions in these areas. Awning Replacement @Station 62: $15,000. The original awning was removed several years ago due

to its condition that posed a risk to our members.

Reception Area @ Station 61: $11,000. The reception at Station 61 has become very outdated in its appearance and

functionality. Since this is an area where the community see’s when they walk into the station, it needs to be upgraded.

The Capital Reserve Analysis completed in August 2021 noted the roof of Station 61 was in need of significant repairs. Based

on several quotes received so far, the roof does not need a full replacement, but does need several areas of rotten wood

replaced and a complete re-sealing of the entire roof system.

In 2011, the City completed a pavement study to identify and prioritize resurfacing efforts. Ranked on a 100-point scale, the

majority of the City’s roadways were in poor condition. The Council set a target Pavement Quality Indicator (PQI) score of 70 and

committed to a $4-$5M investment annually for five years to improve the quality of the roadways. In 2016, the City accelerated

the plan by increasing the annual investment through the use of reserves. In 2018, the City completed what was originally

planned as a five year initial push in four years and had resurfaced every roadway originally scored below a PQI of 70. In

January 2018, the City completed a new pavement study and re-ranked all the roadways. The updated assessment showed the

overall conditions of the roadways had improved. Instead of $4-$5M annually, a step-down level of annual investment of $3M

($1M on main roadways and $2M on neighborhood roadways) was needed to maintain a PQI score of 70 for the next five years.

In FY 2023 council approved another pavement assessment to determine the state of the pavement in the City. Preliminary

results suggest that roads are in reasonably good condition. In order to maintain the level 70 PQI of all roads within the next 5

year cycle, the funding level should remain at $3M ($1.5M for main roads, and $1.5M for neighborhood roads). Construction,

engineering, and daily inspection (CEI) costs are included in the requested amount.

Proposed 9/12/2023 FY2024 Budget Page 72 of 88

7

$600,000

9

Road and Right-of-Way Maintenance Materials

$400,000

10

$200,000

11 $150,000

Pavement markings, including striping and reflective pavement markers (RPMs) provide guidance to drivers by delineating travel

lanes and reminding drivers where they should be on the roadway. Appropriately retroflective pavement markings have been

shown to have a positive correlation to improve safety of travel, particularly nighttime travel. Pavement markings wear and

deteriorate over time from both vehicle travel and weather. To maintain the overall roadway condition, the City restripes and

replaces pavement markers as part of the maintenance of our roadways. Historically the City has set aside $200K annually for

restriping and replacing pavement markings to repaint worn striping and add new reflectors throughout the City. For FY2024, the

funding request continues the $200K level of funding for materials and is anticipated to address the needs.

Pavement Marking Refreshes and Restriping

Vehicle usage and weather cause roadways to deteriorate over time. The distresses / deterioration in the asphalt is evidenced in

cracks and potholes. Asphalt patching is one of the most effective ways to address significant potholes. Additionally, annual

roadway patching efforts are vital to stop the deterioration of roads to the point that they must be fully reconstructed when

resurfaced. As such, asphalt patching and pothole repair are a part of the City's long-term strategy to gradually improve the

condition of the roads. Historically the City has set aside $600K for roadway patching. The segments for patching would be

identified based on Pavement Quality Index scores, potholes, and other identified roadway failures (cracks, gaps, roughness).

The segments will be determined after the funding amount has been settled. If additional funds were available, additional

roadways could be patched.

Roadway Patching

The City maintains street signs, vehicular directional signage, and a limited number of wayfinding signs (such as those noting the

park entrances). The majority of the City's signs are constructed of aluminum or high density urethane in an effort to improve

durability and limit maintenance. However, all outdoor signs exposed to the elements deteriorate over time (evidenced in fading

and reduced retroflectivity). Additionally, signs within the right-of-way are occasionally damaged by motor vehicle accidents.

Historically the City has set aside $100K annually for materials to replace damaged or faded signage / sign posts throughout the

City. As part of the FY 2023 pavement assessment, staff was able to get a sign inventory completed as well. With the results

pending, staff is anticipating an increased expense to upgrade signs to the standard reflectivity upon receipt of the report. An

increase to $150,000 is requested for this reason.

Sign Maintenance Materials

Maintaining the City's roads and right-of-way areas requires a significant amount of materials (from pothole repair supplies to

landscaping materials). The City has found by separating the labor costs from the costs for materials provides better

transparency as to the true cost of providing service and understanding the needs for labor versus materials. Additionally, in

some instances it is more cost-effective to purchase materials directly for use by the contracted maintenance provider. The labor

costs associated with right-of-way maintenance remain in the operating budget. Historically, the City has set aside $400K

annually for the road and right-of-way materials. For FY2024,the funding request continues the $400K level of funding for

materials and is anticipated to address the needs.

Proposed 9/12/2023 FY2024 Budget Page 73 of 88

Sidewalk Projects

12

$400,000

Traffic Signal Projects

13

Traffic Signal Maintenance Materials and Detection Replacements

$200,000

Park Projects

14

Park Maintenance Materials

$1,400,000

15

Park Refreshes (Existing Parks)

$450,000

Concrete Repairs and Maintenance

If properly installed, concrete sidewalks, curbs, and gutters can last for decades. However, concrete requires maintenance for

lasting durability. Weather (freeze-thaw disintegration), nature (tree roots creating horizontal displacement), and vehicle

accidents are leading causes of concrete distress and deterioration (cracks and other more visible failures). Historically the City

has set aside $400K annually for concrete repairs and maintenance to repair or replace broken sidewalk and concrete curbs and

gutters throughout the City. For FY2024, the requested funding is anticipated to remain at $400K.

An increase in funding utilized to renovate existing elements, improve the landscaping (re-grass or landscape bare spots),

maintenance/repairs at park facilities (fix broken doorknobs, freshen paint), and replace worn park equipment (benches, trash

cans, etc.). The high level of usage at the City's parks necessitates an investment to keep the parks looking as inviting and "new"

as possible. Some areas targeted this year would be trail renovations, and window refurbishment at Autrey Mill Nature Preserve,

installing new wayfinding signage at various parks (per the adopted Parks Master Plan), resurfacing tennis courts at Newtown

Park and improvement to common areas at Ocee Park.

Maintaining the City's parks system requires materials (from pine straw and gravel to toilet paper and fill dirt for infield leveling).

The City has found by separating the labor costs from the costs for materials provides better transparency as to true cost of

providing service and understanding the needs for labor versus materials. The labor costs associated with parks system

maintenance contract remain in the operating budget. For FY2024, the requested funding has been increased to account for a

full year of maintenance for the new Cauley Creek Park.

Maintaining the City's traffic signal system requires materials (from traffic signal heads to traffic signal controllers). The City has

found by separating the labor costs from the costs for materials provides better transparency as to true cost of providing service

and understanding the needs for labor versus materials. The labor costs associated with traffic signal maintenance contract

remain in the operating budget. Historically the City has set aside $150K annually for the traffic signal maintenance materials.

For FY2024, staff anticipates increased costs due to inflation and increased capital project completion. The requested funding is

$200K for materials and is anticipated to address the needs.

Proposed 9/12/2023 FY2024 Budget Page 74 of 88

Equipment Accrual (Fund 303)

Cumulative

Equipment Accruals

Contributions

Projects

Balance

###

Police

$886,709

$756,270

$130,439

$775,278

###

Fire

$265,153

$387,500

($122,347)

$133,106

###

Information Technology

$273,019

$309,000

($35,981)

$332,119

Total

$1,424,881 $1,452,770 ($27,889)

$1,240,503

Police Accrual Components

Unit Cost Units

Replacement

Cost

Lifespan

(years)

FY2024

Contribution

FY2024

Projects

1

Automated External Defibrillators (AEDs)

$2,250

80

$180,000

10

$18,000

$22,500

2

AXON (OSP7+, Fleet, Int. Room)

$44,750

80

$3,580,000

10

$358,000

3

Ballistic Shields

$1,520

25

$38,000

5

$7,600

4

Bicycles

$5,000

8

$40,000

4

$10,000

5

Body Armor\Ballistic Carrier\Helmets

$2,150

100

$215,000

5

$43,000

$53,750

6

Communication System - SWAT

$1,712

10

$17,120

5

$3,424

$0

7

Communications Set - Motor Unit

$1,420

4

$5,680

7

$811

$0

8

Digital Cameras

$1,000

12

$12,000

4

$3,000

9

Drones

$7,500

6

$45,000

3

$15,000

10

Gas Masks

$605

80

$48,400

5

$9,680

$0

11

Handgun lights

$130

200

$26,000

7

$3,714

$0

12

Handgun sights

$135

200

$27,000

10

$2,700

$0

13

Handguns

$510

200

$102,000

10

$10,200

$0

14

Helmets - Motor Unit

$760

4

$3,040

5

$608

$0

15

Helmets - SWAT

$1,700

10

$17,000

5

$3,400

16

Lasers and Radar Units

$4,060

40

$162,400

5

$32,480

$8,120

17

Launcher - 40mm

$2,000

20

$40,000

12

$3,333

$0

18

Iron Sights

$150

100

$15,000

5

$3,000

$0

19

Radios

(Mobile, Portable & Base)

$7,600

215

$1,634,000

10

$163,400

$114,000

20

Red Dot Sights for Long Guns

$550

100

$55,000

5

$11,000

$0

21

Rifle Slings

$50

60

$3,000

5

$600

$0

22

Rifles - Specialty / Sniper

$10,160

2

$20,320

10

$2,032

$0

23

Rifles - Suppressors

$600

60

$36,000

10

$3,600

$0

24

Rifles / Long Guns

$1,520

75

$114,000

10

$11,400

$0

25

SWAT Body Armor, Vests, and Plates

$3,850

14

$53,900

5

$10,780

$15,400

26

Training Simulator

$68,000

1

$68,000

10

$6,800

$0

27

Weapon Lights for Long Guns

$250

60

$15,000

3.5

$4,286

$0

28

Weapon Sights for Long Guns

$560

60

$33,600

10

$3,360

$0

29

Tac Vests for JCAF

$2,000

5

$10,000

5

$2,000

30

Flock ALPR

$2,500

55

$137,500

1

$137,500

31

Breaching Tools

$500

40

$20,000

10

$2,000

$6,000

###

Total

$886,709

$756,270

The Equipment Accrual was established in FY2019 in recognition that from our public safety departments to the information

technology that serves as the backbone of all departments, the City has recurring equipment costs that can be best accounted for

and addressed through an accrual. Similar to the Infrastructure Maintenance Accrual and Vehicle Replacement Accrual, the

Equipment Accrual is designed to build-up for larger expenditures by spreading the cost out over the years leading up to a major

replacement project. Additionally, the Equipment Accrual is designed to ensure funding for basic equipment needs are provided for

before capital projects and enhancements.

Beginning

Balance

FY2024

$368,100

$1,268,392

$644,839

$255,453

Ending

Balance

Proposed 9/12/2023

FY2024 Budget Page 75 of 88

Fire Accrual Components

Unit Cost Units

Replacement

Cost

Lifespan

(years)

FY2024

Contribution

FY2024

Projects

1

Automated External Defibrillators (AEDs)

$1,750

12

$21,000

10

$2,100

$0

2

Bail Out System

$810

86

$69,660

10

$6,966

$0

3

Ballistic Helmets and Vests

$1,960

11

$21,560

5

$4,312

$28,500

4

Bunker Gear and Bunker Boots

$2,900

86

$249,400

5

$49,880

$26,000

5

Cameras for Fire Investigations

$5,000

2

$10,000

10

$1,000

$0

6

Extrication Tools

$63,800

2

$127,600

12

$10,633

$0

7

Fastwrench Standpipes

$300

4

$1,200

10

$120

$0

8

Forcible Entry Tools

$100

100

$10,000

5

$2,000

$0

9

Generator Replacement - Station #62

$65,000

1

$65,000

30

$2,167

$65,000

10

Headsets (for Fire Apparatus Operators)

$500

20

$10,000

5

$2,000

$0

11

Helmets and Helmet Fronts

$460

80

$36,800

5

$7,360

$3,000

12

High Rise Hose Packs

$1,600

3

$4,800

10

$480

$0

13

High Rise Standpipe Kits

$2,200

4

$8,800

10

$880

$0

14

Hose Nozzles

$21,340

1

$21,340

7

$3,049

$0

15

Hoses

$2,030

45

$91,350

5

$18,270

$57,000

16

Mattresses

$6,600

1

$6,600

8

$825

$0

17

Personal Protective Equipment

$1,640

90

$147,600

5

$29,520

197,000

18

Portable Scene Lights

$1,500

6

$9,000

20

$450

$0

19

Radios

(Mobile, Portable & Base Station)

$7,600

84

$638,400

10

$63,840

$0

20

Rescue Lift Bags

$4,800

1

$4,800

10

$480

$0

21

Rescue Strut Systems

$35,000

5

$175,000

12

$14,583

$0

22

SCBA Face Pieces

$300

86

$25,800

5

$5,160

$0

23

Self Contained Breathing Apparatus

$6,450

48

$309,600

10

$30,960

$0

24

Small Hardware & Tools

$200

100

$20,000

5

$4,000

$6,000

25

Swift Water Rescue Wet Suits / PFDs

$2,030

3

$6,090

5

$1,218

$0

26

Ventilation Saws

$2,100

2

$4,200

12

$350

$0

27

Water Rescue Gear

$510

25

$12,750

5

$2,550

$5,000

###

Total

$265,153

$387,500

Information Technology

Unit Cost Units

Replacement

Cost

Lifespan

(years)

FY2024

Contribution

FY2024

Projects

1

Computers (desktops and laptops)

$2,000

157

$314,000

4

$78,500

$99,000

2

Council Chamber Audio Visual

$200,000

1

$200,000

7

$28,571

$30,000

3

Displays

$750

20

$15,000

4

$3,750

$0

4

Desktop Printers

$200

50

$10,000

5

$2,000

$5,000

5

In-Car Cameras - Server Side

$3,050

9

$27,450

3

$9,150

$0

6

Mobile Computing Tablets - Fire

$2,640

14

$36,960

3

$12,320

$0

7

Mobile Computing Terminals - Police

$2,440

60

$146,400

3

$48,800

$59,000

8

Network Hardware (Switches, Controllers, etc.)

$10,776

21

$226,296

7

$32,328

$24,000

9

Servers

$18,000

16

$288,000

5

$57,600

$92,000

###

Total

$273,019

$309,000

Proposed 9/12/2023

FY2024 Budget Page 76 of 88

Vehicle Replacement Accrual (Fund 350)

Beginning

Ending

Cumulative

Vehicle Replacements Balance Contributions Projects Balance Balance

Police Vehicles

($94,161)

$579,393

$922,000

($342,607)

($436,768)

Fire Apparatus / Vehicles

$592,801

$591,053

$444,500

$146,553

$739,354

Other City Vehicles

$51,968

$100,162

$80,000

$20,162

$72,130

Total

$550,608

$1,270,608

$1,446,500

($175,892)

$374,716

Summary of Vehicle Replacement Requests

Requested Funded Scheduled Replacements

1

Police: 14 Vehicles

→ 14

Vehicles

$922,000

14 vehicles

2 $37,000 $37,000 1 vehicle 1 vehicle

3

Fire: 3 Vehicles

→ (3) 2024

Ford F150's

$201,000

3 vehicles

4

Fire: 2 Vehicles

→ (2) 2024

Ford Expedition 4x4

$152,000

2 vehicles

5

$54,500

1 vehicle

6

Community Development: 2007 Ford Ranger

→ 2024

Ford Explorer

$40,000

1 vehicle

7 Public Works: 2008 Chevy Tahoe → 2023 Ford Explorer $40,000 $40,000 1 vehicle 1 vehicle

$1,446,500

Vehicle Replacement Projects Described

1

Police: 14 Vehicles

→ 14

Vehicles

Funded:

$922,000

2

Fire: 2009 Polaris Ranger 6x6

→ 2024

Polaris XP 1000 4x4

Funded:

$37,000

3

Fire: 3 Vehicles

→ (3) 2024

Ford F150's

Funded:

$201,000

The Vehicle Replacement Accrual sets aside funds for the replacement of existing vehicles. From fire trucks to police patrol

vehicles to trucks driven by inspectors, the City provides the resources necessary for the staff to provide services. The 2024

Budget sets aside almost $1.3M for vehicle replacements. By design, the expenditures in the Vehicle Replacement Accrual do not

equal the total or replacements each year as the fund is designed to build up for the larger expenditures by spreading the cost out

over the years leading up to the expenditure for a major replacement such as a fire engine.

The City vehicle replacement schedule anticipates replacing fourteen police vehicles each year to gradually refresh the fleet. For

FY2024, the Police Department is requesting to replace fourteen vehicles. The requested replacements are based on elevated

maintenance costs, high mileage, and intense use requirements. The replacements will likely be the fourteen vehicles that are

between seven and eleven years old, but the final vehicle replacement assessment will be made in the fall based on funding

awarded and double-checking the mileage, maintenance, and any issues that arise between Budget adoption and the receipt of

the vehicles. The $922,000 of funding would provide for the replacement of fourteen vehicles.

FY2024

Fire: 2009 Polaris Ranger 6x6 → 2024 Polaris XP 1000 4x4

The vehicle replacement schedule anticipates replacing this vehicle in FY2024. The vehicle scheduled for replacement is a 2009

Polaris Ranger 6x6 (Unit # 107). The mileage is just over 2,113 with 361 engine hours. Maintenance on this vehicle is getting

more and more expensive and difficult to locate parts that will work on the vehicle due to its age. The $37,000 of funding is

anticipated to provide for the replacement of the 2009 Polaris Ranger 6x6 with a 2024 Polaris XP 1000 4x4.

The vehicle replacement schedule anticipates replacing three vehicles in FY2024. The vehicles scheduled for replacement include

a 2015- F250 (Unit #237), a 2016-F250 (Unit #240), and a 2009 Chevy Impala (Unit #228). The age and mileage on these

vehicles is well outside of the replacement cycle. Vehicle #237 has 116,602 miles and is 8 years old. Vehicle #240 has 107,190

miles and is 7 years old. Finally, vehicle #228 only has 45,916 miles, however, it is over 14 years old. The $201,000 of funding is

anticipated to provide for the replacement of the three vehicles with three Ford F150's.

Fire: 2008 Chevy 2500 4x4 → 2024 Ford F150

Proposed 9/12/2023 FY2024 Budget Page 77 of 88

4

Fire: 2 Vehicles

→ (2) 2024

Ford Expedition 4x4

Funded:

$152,000

5

Fire: 2008 Chevy 2500 4x4

→ 2024

Ford F150

Funded:

$54,500

6

Community Development: 2007 Ford Ranger

→ 2024

Ford Explorer

Funded:

$40,000

7

Public Works: 2008 Chevy Tahoe

→ 2023

Ford Explorer

Funded:

$40,000

The vehicle replacement schedule anticipates replacing one of the Community Development vehicles in FY2024. The vehicle

scheduled for replacement is a 2007 Ford Ranger (Unit # C5832). The mileage is just over 105,000. Of note, the vehicle required

major maintenance in 2021. In considering the replacement, the City anticipates replacing the vehicle with a 4-door Ford Explorer

or similar SUV. The $40,000 of funding is anticipated to provide for the replacement of the Ford Ranger with a Ford Explorer.

The vehicle replacement schedule anticipates replacing one of the Public Works vehicles in FY2024. The vehicle scheduled for

replacement is a 2008 Chevy Tahoe (Unit # C5846). The mileage is just over 137,000. Of note, the vehicle required major

maintenance in 2022 and already in 2023. In considering the replacement, the City anticipates replacing the vehicle with a 4-door

Ford Explorer or similar SUV. The $40,000 of funding is anticipated to provide for the replacement of the Chevy Tahoe with a Ford

Explorer.

The vehicle replacement schedule anticipates replacing two vehicles in FY2024. The vehicles scheduled for replacement include a

2016 Ford F250 4X4 (Unit #242) and a 2014 Chevy Tahoe 4X4 (Unit #234). The current mileage on Unit #242 is 68,552 with

4,770 engine hours. Unit #234 has 147,347 miles. The $152,000 of funding is anticipated to provide for the replacement of the

two vehicles with two Ford Expedition 4x4.

The vehicle replacement schedule anticipates replacing one vehicle in FY2024. The vehicle scheduled for replacement is a 2008

Chevy 2500 4X4 (Unit #214). The current mileage is 205,537. Maintenance has been a big issue with this vehicle. It has been in

the shop for multiple repairs and has a variety of items that need to be done. The $54,500 of funding is anticipated to provide for

the replacement of the Chevy 2500 with a Ford F150.

Proposed 9/12/2023 FY2024 Budget Page 78 of 88

Parks Bond (Fund 310)

Existing Park

Improvement Projects

Autrey Mill

Farm Museum Renovation

Autrey Mill

Forest Management Study

Autrey Mill

Bus Turnaround and Pervious Parking Lot

Autrey Mill

Relocation of Smokehouse

Autrey Mill

Program Barn Bathroom Addition

Autrey Mill

Restroom and Pavilion Addition

Newtown

Soccer and Lacrosse Synthetic Turf

Newtown

Playground Sidewalk Connection

Newtown

Bocce Court Expansion

Newtown

Perimeter Trail Loop Connection

Ocee

Pavilion Near the Tennis Courts

Ocee

Soft Surface Trail

Shakerag

Track Field Synthetic Turf

Shakerag

Tot Lot Playground

Shakerag

Fishing Pier

Shakerag

Wildlife Observation Deck

Shakerag

Cricket Pitch and Batting Cages

Shakerag

Pavilion at Field #3

New Parks and Park Connections

Land Acquisition for Cauley Creek Park

On-Going Projects Current Stage

Creekside Park - in Town Center (behind City Hall) Right of Way

Chattahoochee River Greenway (Abbotts Bridge Road to Cauley Creek Park) Engineering

Rogers Bridge Pedestrian Bridge (Cauley Creek Park to Rogers Park) July 2023

November 2020

December 2021

Completed

Morton Road Park November 2020

State Bridge Park May 2021

Bell-Boles Park October 2021

May 2021

Cauley Creek Park June 2023

February 2020

April 2021

May 2022

October 2017

July 2019

August 2019

September 2021

May 2021

October 2021

December 2017

September 2019

March 2020

January 2019

In November 2016, voters in Johns Creek approved the issuance of a $40M bond for recreation and park

improvements. The bonds were issued in the spring of 2017.

Annually the Council has received a Parks Bond implementation presentation at a Work Session in late January

with a review of projects by park as well as the accounting for expenditures on each project. As the revenues

have all been received and all revenues have been spent or encumbered, no Council action for additional

appropriation is requested as part of the FY2024 Budget and this fund will not be reflected in future Budgets.

Parks Bond-funded projects are listed below. On a going-forward basis, the few remaining active projects with

some funding through the Parks Bond will be continued in the Capital Projects Fund.

Completed

September 2018

October 2018

January 2019

Proposed 9/12/2023 FY 2024 Budget Page 79 of 88

TSPLOST (Fund 335)

Projects Completed

Bell Road at Cauley Creek Park Roundabout

Bell Road at McGinnis Ferry Road

Bell Road at Medlock Bridge Road

Bell Road at Rogers Circle South Roundabout

Bell Road Bridge over Cauley Creek Tributary

Jones Bridge Road at Waters Road

Medlock Bridge Road at State Bridge Road (Interim)

State Bridge Road Widening (Camden Way to the River)

Projects in Construction

Barnwell Road at Holcomb Bridge Road

Haynes Bridge Road at Old Alabama Road

Jones Bridge Road Multi-Modal

Jones Bridge (Waters Road to State Bridge Road)

McGinnis Ferry Road (Sargent Road to Douglas Road)

Medlock Bridge Road at Johns Creek Parkway

Projects in Right-of-Way Acquisition

Jones Bridge Road at Douglas Road

Medlock Bridge Road at Skyway, Abbotts, and Bell

Medlock Bridge Trail (Creekside Park Trail)

Projects in Engineering Stage

Medlock Bridge Road at McGinnis Ferry Road

Medlock Bridge Road at State Bridge Road

Project on Hold

New Location Road (Bell Road to Johns Creek Parkway)

December 2022

May 2022

March 2023

Last Council Action

July 2022

November 2020

ROW Authorized

January 2023

May 2020

July 2021

November 2020

Groundbreaking

February 2022

June 2022

March 2023

May 2023

Bids Received June 2023

March 2023

September 2021

The TSPLOST (Transportation Special Purpose Local Option Sales Tax) was approved by Johns Creek voters in

November 2016. The three-quarters of a penny sales tax was implemented across Fulton County outside the City

of Atlanta from April 1, 2017 - March 31, 2022. As voters subsequently approved a TSPLOST in November 2021

(or TSPLOST II), the TSPLOST approved in 2016 is also referred to as TSPLOST I.

Annually Council receives a 'State of the Program' overall implementation presentation at a Work Session in late

January with both programmatic updates (as to which projects are in which stages) as well as accounting for

expenditures on each project. As the revenue collection period is over and the revenues have all been spent or

encumbered, no Council action for additional appropriation is requested as part of the FY2024 Budget and this

fund will not be reflected in future Budgets.

For transparency, TSPLOST I funded projects are listed below by current stage.

Ribbon Cutting

March 2022

July 2020

March 2021

Proposed 9/12/2023 FY 2024 Budget Page 80 of 88

TSPLOST II (Fund 336)

Revenues

Total

Anticipated

FY 2024

Anticipated

Object

Account

Authorized

Ending FY23

Proposed

Remaining

313400

TSPLOST Revenue

$65,501,474

$19,650,442

$13,100,295

$32,750,737

361000

Interest Earnings

$0

Total

$65,501,474

$19,650,442

$13,100,295

$32,750,737

FY2024 Expenditure Authorizations

Total

Anticipated

FY2024

Anticipated

Object

Account

Authorized

Ending FY23

Proposed

Remaining

521202

Project Management

$3,275,074

$600,074

$400,000

$2,275,000

579100

Budgeted Inflation

$5,240,118

$0

$5,240,118

541210

Bridges

$6,500,000

$100,000

$1,000,000

$5,400,000

541420

Traffic Congestion Relief

$14,200,000

$4,750,000

$4,450,000

$5,000,000

541200

Landscape/Streetscape

$3,500,000

$120,000

$7,000

$3,373,000

541210

Operations and Safety

$16,286,282

$3,500,000

$2,050,000

$10,736,282

541420 Pedestrian/Bike Improvements

$16,500,000

$5,300,000

$5,150,000

$6,050,000

Total

$65,501,474

$14,370,074

$13,057,000

$38,074,400

Voters approved a continuation of TSPLOST or TSPLOST II as part of the November 2021 election. The adopted budget list for Johns Creek includes $6.5M for

bridges, $14.2M for traffic congestion relief, $3.5M for landscape / streetscape improvements, $16.2M for operations and safety projects and $16.5M for pedestrian /

bike improvements. A separate fund has been established for TSPLOST II (Fund 336) to budget the projects in the categories approved by Council.

Proposed 9/12/2023 FY 2024 Budget Page 81 of 88

Other Funds

Seized/Forfeited Asset Fund

FY 2021

FY 2022

FY 2024

Fund 210

Actuals Actuals Revised YTD 3/31 Annualized Proposed

Revenues

$29,257

$807

$176,706

$23,130

$222,965

$177,490

$784

Expenditures

$97,046

$127,590

$176,706

$38,381

$120,786

$177,490

$784

($67,789)

($126,783)

$0

($15,251)

$102,179

$0

State Confiscated Fund

FY 2021

FY 2022

FY 2024

Fund 211

Actuals Actuals Revised YTD 3/31 Annualized Proposed

Revenues

$56,613

$18,776

$10,000

$11,721

$23,442

$10,000

$0

Expenditures

$18,093

$1,766

$10,000

$0

$10,000

$0

$38,520

$17,010

$0

$11,721

$23,442

$0

E911 Fund

FY 2021

FY 2022

FY 2024

Fund 215

Actuals Actuals Revised YTD 3/31 Annualized Proposed

Revenues

$1,938,970

$1,989,487

$2,068,468

$682,548

$1,365,096

$2,212,375

$143,907

Expenditures

$1,938,970

$1,989,487

$2,068,468

$910,709

$1,821,418

$2,212,375

$143,907

$0

($228,161)

($456,323)

$0

LMIG Fund

FY 2021

FY 2022

FY 2024

Fund 250

Actuals Actuals Revised YTD 3/31 Annualized Proposed

Revenues

$668,359

$732,907

$700,000

$0

$700,000

$750,000

$50,000

Expenditures

$168,395

$27,413

$700,000

$121,789

$700,000

$750,000

$50,000

$499,964

$705,495

$0

($121,789)

$0

Hotel/Motel Fund

FY 2021

FY 2022

FY 2024

Fund 275

Actuals

Revised

YTD 3/31 Annualized

Proposed

Revenues

$383,455

$513,164

$780,545

$228,558

$1,087,097

$863,391

$82,846

Expenditures

$383,455

$513,164

$831,645

$313,198

$1,087,097

$863,391

$31,746

$0

($51,100)

($84,640)

$0

$51,100

Tree Replacement Fund

FY 2021

FY 2022

FY 2024

Fund 285

Actuals

Revised

YTD 3/31 Annualized

Proposed

Revenues

$41,744

$196,960

$20,000

$11,336

$20,000

$0

Expenditures

$0

$20,000

$0

$20,000

$0

$41,744

$196,960

$0

$11,336

($8,664)

$0

Stormwater Fund

FY 2021

FY 2022

FY 2024

Fund 560/570

Actuals

Revised

YTD 3/31 Annualized

Proposed

Revenues

$7,493,705

$2,111,182

$4,119,742

$2,621,857

$4,119,742

$3,800,000

($319,742)

Operational Expenditures

$134,023

$3,177,990

$4,119,742

$2,352,380

$4,119,742

$2,900,000

($1,219,742)

Capital Project Expenditures

$0

$900,000

$7,359,682

($1,066,808)

$0

$269,477

$0

Change from

2023

FY 2023

Change from

2023

FY 2023 Change from

2023

Balance

FY 2023

Balance

Change from

2023

Change from

2023

Change from

2023

FY 2023

Change from

2023

Proposed 9/12/2023 FY 2024 Budget Page 82 of 88

Seized/Forfeited Asset (Fund 210)

FY 2021 FY 2022 FY 2024

Object Account Actuals Actuals Revised

YTD 3/31 Annualized

Proposed

351320

Cash Confiscations

$28,366

$0

$22,781

$45,562

$0

351360

Other Confiscated/Escheats

$0

361000

Interest Earnings

$891

$807

$0

$348

$697

$0

399999

Other Financing Sources

$0

$176,706

$0

$176,706

$177,490

$784

$29,257

$807

$176,706

$23,130

$222,965

$177,490

$784

FY 2021

FY 2022

FY 2024

Object

Account

Actuals

Revised

YTD 3/31

Annualized

Proposed

522310

Rental - Land & Buildings

$3,398

$44,166

$42,000

$17,290

$41,400

$42,840

$840

523700

Education & Training

$0

$16,495

$40,000

$0

$40,000

$0

531110

Other Supplies

$0

$10,383

$30,000

$15,650

$31,300

$30,000

$0

531703

Operating Supplies

$0

$225

$50,000

$40,150

$80,300

$50,000

$0

531711

Officer Supplies

$1,603

$0

542550

Other Equipment

$92,045

$19,117

$14,650

$2,495

$4,990

$14,650

$0

542200

Vehicles

$0

$56

$0

($56)

572500

Fulton County District Attorney's Office

$0

$37,204

$0

($37,204)

$0

$97,046

$127,590

$176,706

$38,381

$120,786

$177,490

$784

State Confiscated (Fund 211)

FY 2021 FY 2022 FY 2024

Object

Account

Actuals

Revised

YTD 3/31 Annualized

Proposed

351320

Fines and Forfeitures

$41,813

$18,776

$10,000

$11,721

$23,442

$10,000

$0

351360

Sale of Confiscated Property

$14,800

$0

$56,613

$18,776

$10,000

$11,721

$23,442

$10,000

$0

FY 2021

FY 2022

FY 2024

Object

Account

Actuals

Revised

YTD 3/31 Annualized

Proposed

531110

Other Supplies

$0

$10,000

$0

$10,000

$0

572000

Payments to Other Agencies

$18,093

$1,766

$0

$18,093

$1,766

$10,000

$0

$10,000

$0

E911 (Fund 215)

FY 2021

FY 2022

FY 2024

Object

Account

Actuals

Revised

YTD 3/31 Annualized

Proposed

342500

E-911 Charges/Fees

$1,576,888

$1,631,945

$2,068,468

$571,693

$1,143,386

$2,212,375

$143,907

342510

Prepaid Wireless

$362,082

$357,541

$0

$110,855

$221,710

$0

389000

Other Miscellaneous Revenue

$0

391000

Operating Transfers In

$0

$1,938,970

$1,989,487

$2,068,468

$682,548

$1,365,096

$2,212,375

$143,907

FY 2021

FY 2022

FY 2024

Object

Account

Actuals

Revised

YTD 3/31 Annualized

Proposed

521218

Emergency 911 Services

$0

531590

Other Costs

$0

572200

ChatComm/E911 Authority

$1,938,970

$1,989,487

$2,068,468

$910,709

$1,821,418

$2,212,375

$143,907

$1,938,970

$1,989,487

$2,068,468

$910,709

$1,821,418

$2,212,375

$143,907

LMIG (Fund 250)

FY 2021

FY 2022

FY 2024

Object

Account

Actuals

Revised

YTD 3/31 Annualized

Proposed

331150

Revenue - LMIG

$668,359

$732,907

$700,000

$0

$700,000

$750,000

$50,000

$668,359

$732,907

$700,000

$0

$700,000

$750,000

$50,000

FY 2021

FY 2022

FY 2024

Object

Account

Actuals

Revised

YTD 3/31 Annualized

Proposed

Sidewalk Trails

$0

$750,000

Intersection Improvements

$0

Autrey Mill Right Turn Lane Extension

$0

Operational Improvements - Taylor Road

$0

Professional Services

$0

$11,500

$0

Road Improvement

$0

$15,913

$700,000

$121,789

$700,000

$0

($700,000)

Operating Transfer

$168,395

$0

$168,395

$27,413

$700,000

$121,789

$700,000

$750,000

$50,000

FY 2023

Total

Expenditures

FY 2023 Change from

2023

Change from

2023

FY 2023

Change from

2023

FY 2023

Change from

2023

FY 2023

Change from

2023

FY 2023

Change from

2023

FY 2023

Change from

2023

Change from

2023

Total

Revenues

Total

Expenditures

Revenues

Expenditures

Total

Expenditures

Revenues

Total

Proposed 9/12/2023 FY 2024 Budget Page 83 of 88

Hotel/Motel Tax (Fund 275)

FY 2021

FY 2022

FY 2024

Object

Account

Actuals

Revised

YTD 3/31 Annualized

Proposed

314100

Hotel/Motel Tax

$383,455

$483,164

$534,350

$213,258

$579,802

$653,391

$119,041

331150

Categorical Indirect

$0

$30,000

$246,195

$15,300

$507,295

$210,000

($36,195)

361100

Interest Earnings

$0

399999

Other Funding Sources - Fund Balance

$0

$383,455

$513,164

$780,545

$228,558

$1,087,097

$863,391

$119,041

FY 2021

FY 2022

FY 2024

Object

Account

Actuals

Revised

YTD 3/31 Annualized

Proposed

521200

Professional Services

$0

$220,000

$64,321

$220,000

$210,000

($10,000)

541200

Site Improvement

$0

$30,000

$287,295

$21,100

$287,295

$0

($287,295)

571110

Tourism Product Development (Contract with CVB)

$150,698

$189,884

$91,593

$89,516

$227,862

$256,783

$165,190

571120

Tourism Promotion (Transfer to CVB)

$123,242

$155,289

$123,242

$73,207

$186,348

$210,000

$86,758

591610

Operating Transfers Out (to General Fund)

$109,515

$137,992

$109,515

$65,053

$165,591

$186,608

$77,093

$383,455

$513,164

$831,645

$313,198

$1,087,097

$863,391

$31,746

Tree Replacement (Fund 285)

FY 2021

FY 2022

FY 2024

Object

Account

Actuals

Revised

YTD 3/31 Annualized

Proposed

346910

Development Fees

$41,744

$196,960

$20,000

$11,336

$20,000

$0

$41,744

$196,960

$20,000

$11,336

$20,000

$0

FY 2021

FY 2022

FY 2024

Object

Account

Actuals

Revised

YTD 3/31 Annualized

Proposed

531703

Cauley Creek Park Tree Planting

$0

139990

Fund Balance - Unreserved

$0

$20,000

$0

$20,000

$0

$20,000

$0

$20,000

$0

Stormwater (Fund 560)

FY 2021

FY 2022

FY 2024

Object

Account

Actuals

Revised

YTD 3/31 Anticipated

Proposed

399999

Other Financing Sources

$7,049,287

$76,075

$919,742

$459,871

$919,742

$800,000

$0

344260

Stormwater Utility Fees

$444,418

$2,035,107

$3,200,000

$2,161,986

$3,200,000

$3,000,000

($200,000)

$7,493,705

2,111,182

$

$4,119,742

$2,621,857

$4,119,742

$3,800,000

($200,000)

FY 2021

FY 2022

FY 2024

Object

Account

Actuals

Revised

YTD 3/31 Annualized

Proposed

521200

Professional Services

$0

$138,048

$547,132

$206,639

$547,132

$500,000

($47,132)

521202

Jacobs (fka CH2M Hill)

$122,500

$490,000

$504,700

$254,800

$504,700

$519,840

$15,140

522210

Equipment Repair & Maint

$0

$105,868

$21,000

$8,474

$21,000

$0

522200

Repairs & Maintenance

$0

$2,443,473

$3,035,412

$1,882,044

$3,035,412

$1,814,562

($1,220,850)

523300

Advertising

$0

$2,500

$0

$2,500

$0

523400

Printing & Binding

$0

$556

$1,248

$414

$1,248

$10,848

$9,600

531120

Office Supplies

$0

$45

$5,500

$0

$5,500

$2,000

($3,500)

531130

Postage

$11,523

$0

$250

$9

$250

$27,250

$27,000

531703

Operating Supplies

$0

$2,000

$0

$2,000

$0

$134,023

$3,177,990

$4,119,742

$2,352,380

$4,119,742

$2,900,000

($1,219,742)

Stormwater Capital Projects (Fund 570)

541200

Site Improvement

$0

$900,000

Details of Funded Requests

Stormwater Quality Improvement Project

Funded:

$900,000

Requested by: Public Works

Requested:

$900,000

This project will improve stream bank stabilization and stormwater quality with projects as per the City's Stormwater Master Plan.

Change from

2023

Total

FY 2023 Change from

2023

Total

Expenditures FY 2023 Change from

2023

Revenues

Total

Change from

2023

Total

FY 2023Revenues

Expenditures

Total

Capital Project Expenditures

Operating Expenditures

FY 2023

Revenues

Total

FY 2023

Change from

2023

FY 2023

Change from

2023

Proposed 9/12/2023 FY 2024 Budget Page 84 of 88

Debt Funds

Debt Service (Fund 400)

FY 2021

FY 2022

FY2024

Object

Actuals

Revised

YTD 03/31 Annualized

Proposed

391000

$3,319,269

$2,320,613

$3,320,933

$1,411,086

$1,273,717

$273,717

$2,047,216

$2,046,512

Total

$3,319,269

$2,320,613

$3,320,933

$1,411,086

$3,320,933

$2,320,229

FY 2021

FY 2022

FY2024

Object

Actuals

Revised

YTD 03/31 Annualized

Proposed

581200

$2,677,412

$2,803,589

$203,886

$1,213,589

$255,218

$1,590,000

$1,630,000

582200

$641,857

$517,344

$318,278

$60,128

$18,499

$457,216

$416,512

$3,319,269

$3,320,933

$522,164

$3,320,933

$2,320,229

FY2024 Debt Service Payment Schedules

GTIB Loan

Payment Date

Principal

Interest

P&I Payment

10/1/2023

$20,947

$1,862

$22,810

11/1/2023

$21,005

$1,805

$22,810

12/1/2023

$21,063

$1,747

$22,810

1/1/2024

$21,121

$1,689

$22,810

2/1/2024

$21,179

$1,630

$22,810

3/1/2024

$21,238

$1,572

$22,810

4/1/2024

$21,296

$1,513

$22,810

5/1/2024

$21,355

$1,455

$22,810

6/1/2024

$21,414

$1,396

$22,810

7/1/2024

$21,473

$1,337

$22,810

8/1/2024

$21,532

$1,277

$22,810

9/1/2024

$21,592

$1,218

$22,810

Total

$255,218

$18,499

$273,717

City Hall - COPs Issuance

Payment Date

Principal

Interest

P&I Payment

3/1/2024

$208,256

9/1/2024

$1,630,000

$208,256

$1,838,256

Total

$1,630,000

$416,512

$2,046,512

FY2023

The City has three debts: (1) City Hall Certificate of Participation issuance, (2) Resurfacing Loan from Georgia Tollway Infrastructure Bank, and (3) Parks

General Obligation Bond issuance. The first two are managed out of Fund 400 (Debt Service Fund) and the Parks Bond Debt is distinctly managed out of

Fund 410 (Parks Bond Debt Service).

In accordance with the City's Debt Management Policy, as part of the budget preparation, each debt is reviewed and considered for potential early

repayment. Of the three debts, two have not yet reached the point when they can be considered to be retired early. The City Hall COPS issuance is

callable at par on September 1, 2027. The Parks Bond (for bonds maturing on April 1, 2028 or later) is callable on or after April 1, 2027. The GTIB loan

for resurfacing can be prepaid in whole or in part at any time without premium or penalty according to the terms of the Promissory Note. The Adopted

FY2024 Budget anticipates paying the $273,717 of principal and interest that are due in FY2024.

…City Hall COPS issuance

Total

…GTIB Resurfacing Loan

Expenditures

FY2023

…from Public Works for GTIB Resurfacing Loan

…from Facilities for City Hall COPS issuance

Capital Lease Principal

Revenues

Account

Operating Transfers In

Capital Lease Interest

Account

…City Hall COPS issuance

…GTIB Resurfacing Loan

Proposed 9/12/2023 FY 2024 Budget Page 85 of 88

Debt Service Parks GO Bond (Fund 410)

FY 2021

FY 2022

FY2024

Object

Actuals

Revised

YTD 03/31 Annualized

Proposed

311100

$1,985,223

$2,355,347

$2,452,989

$0

$2,452,989

311200

$252,128

$181,554

$179,356

$248,359

$179,356

361000

$4,270

$5,610

$5,000

$37,248

$74,496

$5,000

Total

$2,241,621

$2,542,511

$2,637,345

$285,607

$2,775,844

$2,637,345

FY 2021

FY 2022

FY2024

Object

Actuals

Revised

YTD 03/31 Annualized

Proposed

581100

$700,000

$730,000

$770,000

$800,000

582100

$1,398,638

$1,363,638

$1,327,138

$1,288,638

139990

$0

$548,707

Total

$2,098,638

$2,093,638

$2,097,138

$2,637,345

FY2024 Debt Service Payment Schedule

Parks GO Bonds, Series 2017

Date

Principal

Interest

Total (P+I)

10/1/2023

$0

$644,319

4/1/2024

$800,000

$644,319

$1,444,319

Total

$800,000

$1,288,638

$2,088,638

Fund Balance - Unreserved

Property Taxes - Current Year

Property Taxes - Prior Year

Interest Earnings

Account

Expenditures

Account

Revenues

Bond Principal

Bond Interest

FY2023

Proposed 9/12/2023 FY 2024 Budget Page 86 of 88

Five-Year Capital Needs

Project Description

Requested Funds

Requested Year of Funding

Identified Funding Source(s)

Department Priority

Perceived Need

Council Support

Service Impact

Useful Life

On-Going Costs…Impact to Operating Budget

Legal Mandate

Town Center Vision and Plan

Creekside Park

Trail Network

Johns Creek Parkway at Lakefield Drive Intersection

Lakefield Drive ("Main Street") Streetscape

Pedestrian Crossing at Medlock Bridge Road

Johns Creek Parkway Road Modification (Between Lakefield Drive and McGinnis Ferry Road)

Stormwater Management Plan

Civic / Cultural / Performing Arts Center

Although the FY2024 Budget only authorizes those capital projects shown as funded in the Capital Projects Fund,

those projects represent only part of the known capital investments for the City over the five-year horizon. Several

planning documents adopted by the City Council (such as the Transportation Master Plan adopted by Council in 2008,

the Recreation and Parks Strategic Plan adopted by Council in March 2016, the Comprehensive Plan adopted by

Council in October 2018, and the Town Center Vision and Plan adopted by Council in October 2021) identify the City's

capital investments over a longer period. Additionally, adopted policies (such as the Sidewalk Prioritization Policy and

the Intersection Improvement Policy) identify areas for significant capital investment over the next several decades.

In November 2021, the voters approved an extension to the Transportation Special Purpose Local Option Sales Tax

(or TSPLOST II). At the April 11, 2022 Work Session, Council reviewed initial projects to utilize an estimated $46.9

million of the total anticipated $65.5 million of revenues and authorized staff to begin engineering. Although the

revenue stream is significant, it does not fully address identified capital needs. For example, Council set aside $16.5M

for pedestrian and bike improvements to add sidewalk and trails. However, the Sidewalk Prioritization Policy has

identified over $100M of needed sidewalks and trails to fully build out the City's network. Additionally, the 5-Year

capital list as included in the FY2022 Budget identified over $92M of unfunded capital projects over the next five years.

In FY2024 staff will launch a new and improved Capital Planning Process. In order to provide a more focused

discussion, staff will develop a comprehensive list of projects forecast for FY2025-FY2029 likely to be captured in the

following areas for significant capital investment listed below based on adopted plans and policies. Those inputs will be

vetted by senior management and capital project narrative developed detailing

All of this information will be assembled in a Working Binder for review and Discussion with Council during the

January/February 2024 timeframe in a Council Work Session(s). Output from that focused discussion will then be

incorporated in the FY2025 Budget Development Process and each successive year.

Proposed 9/12/2023 FY 2024 Budget Page 87 of 88

Land Acquisition

Recreation and Parks Strategic Plan

Cauley Creek Park - Phase II - Construction

Autrey Mill Park and Nature Preserve Improvements

Newtown Park Improvements

Ocee Park Improvements

Shakerag Park Improvements

Creekside Park Construction

Indoor Recreation Center - Location and features TBD

Chattahoochee River Greenway

Sidewalk Policy and Prioritization

Sidewalks

Trails

Multi-Modal Corridors (under development)

Intersection Improvements

Safety Improvements

Operational Improvements

Transportation Master Plan

Safety and Operational Improvements

Congestion Relief

Improved Street Network

Intelligent Traffic Signal System

Fiber System Redundancy

Connected Vehicle Enhancements

Communication System Improved Stability

Proposed 9/12/2023 FY 2024 Budget Page 88 of 88