HomeMy Public PortalAbout2017-10-12 packet
Notice of Meeting and Tentative Agenda
CITY OF JEFFERSON
Finance Committee
Thursday, October 12, 2017 at 7:30 AM
City Hall, 320 E. McCarty Street, Jefferson City, MO ~ Boone-Bancroft Room
TENTATIVE AGENDA
1. Call to Order
2. Roll Call
3. Approval of the minutes of the September 14, 2017
4. Financial Reports
a. Sales Tax Report
b. Revenue Model Report
c. Expense Report
d. Fund Balance Report
5. Lodging Tax Report
6. Discussion of Property Code Enforcement software – Sonny Sanders
7. Discussion of Fire Station #2 – Chief Schofield
8. Discussion of Updated Five-Year Forecast – Margie Mueller
9. New Business
10. Old Business
11. Adjournment
NOTES
Individuals should contact the ADA Coordinator at (573) 634-6570 to request accommodations or alternative
formats as required under the Americans with Disabilities Act. Please allow three business days to process the
request.
CITY OF JEFFERSON
Finance Committee Meeting
Thursday, September 14, 2017
MINUTES
The meeting was called to order by the Finance Committee Chairman, Councilman Mihalevich at 7:33 am. Roll
call showed that Councilmen Mihalevich, Hussey, and Henry were in attendance. Councilman Prather was not in
attendance. Councilman Graham was not in attendance during roll call, but joined the meeting at 8:16 am.
Next the minutes of the July 13, 2017 meeting were reviewed. A motion to approve was made by Councilman
Hussey and seconded by Councilman Henry. The minutes were approved unanimously.
The next item on the agenda was a report by the Finance Director, Margie Mueller, covering the Financial
Reports. Ms. Mueller reviewed the Revenue Model, the September sales tax receipts, year-to-date general ledger
account information, and the current fund balance calculation.
The next item on the agenda was a report by Chief Accountant, Shiela Pearre, covering the Lodging Tax receipts
to date. 4/7 of the Lodging tax collected during the timeframe where the rate has been 7%, less any expenses paid
by the 4 Cent Lockbox Fund, is $4,081,011. The average monthly amount collected for the 4 Cent Lockbox Fund
is $51,977. A report comparing occupancy rates for 2017, 2016, 2015, 2014, 2013 and 2012 was included along
with a report listing occupancy rates from other cities.
The next item on the agenda was a discussion lead by City Counselor, Ryan Moehlman, regarding a supplemental
appropriation for the Municipal Court renovation. Mr. Moehlman, along with staff from Architects Alliance,
presented floor plan renderings along with cost projections. A motion was made by Councilman Hussey and
seconded by Councilman Henry to move the supplemental appropriation to full Council. The motion passed
unanimously.
There was no new business to discuss.
There was no old business to discuss.
The meeting adjourned at 8:22 am.
As recorded by:
Shiela Pearre, Chief Accountant
Memo
To:Steve Crowell
From:Shiela Pearre
Date:October 10, 2017
Re:Sales Tax Revenues
The City received the October 1% Sales Tax in the amount of $883,215 which is $86,138 less
than projected for October. January thru October shortfall is $160,723 (1.42%) in the General Fund.
1% General Sales Tax
Receipt Actual Budget
Period Receipts Projection1 Variance
Nov-16 Jan-17 $1,083,570 $924,504 $159,066
Dec-16 Feb-17 $806,789 $823,770 ($16,981)
Jan-17 & Oct-Dec 16 Qtrly Mar-17 $1,073,842 $1,129,724 ($55,882)
Feb-17 Apr-17 $843,561 $951,232 ($107,670)
Mar-17 May-17 $687,741 $731,839 ($44,098)
Apr-17 & Jan-Mar 17 Qtrly Jun-17 $1,000,942 $1,071,788 ($70,847)
May-17 Jul-17 $1,154,051 $1,069,247 $84,804
Jun-17 Aug-17 $678,636 $650,040 $28,597
Jul-17 & Apr-June 17 Qtrly Sep-17 $1,143,504 $1,195,077 ($51,574)
Aug-17 Oct-17 $883,215 $969,353 ($86,138)
Sep-17 Nov-17 $959,772
Oct-17 & Jul-Sept 17 Qtrly Dec-17 $823,654
Total Overage/Shortfall $11,300,000 ($160,723)
1Budgeted based on 3-year average percentage
1/2% Capital Improvement Tax - Sales Tax F & G combined
Receipt Actual Budget
Period Receipts Projection2 Variance
Nov-16 Jan-17 $525,521 $396,801 $128,721
Dec-16 Feb-17 $402,964 $353,565 $49,399
Jan-17 & Oct-Dec 16 Qtrly Mar-17 $506,597 $484,882 $21,715
Feb-17 Apr-17 $411,020 $408,272 $2,748
Mar-17 May-17 $340,162 $314,108 $26,054
Apr-17 & Jan-Mar 17 Qtrly Jun-17 $489,008 $460,015 $28,993
May-17 Jul-17 $559,119 $458,924 $100,195
Jun-17 Aug-17 $338,618 $278,999 $59,618
Jul-17 & Apr-June 17 Qtrly Sep-17 $542,457 $512,931 $29,525
Aug-17 Oct-17 $425,493 $416,050 $9,443
Sep-17 Nov-17 $411,938
Oct-17 & Jul-Sept 17 Qtrly Dec-17 $353,515
Total Overage/Shortfall $4,850,000 $456,412
2Budgeted based on 3-year average percentage
1/2% Parks Sales Tax
Receipt Actual Budget
Period Receipts Projection3 Variance
Nov-16 Jan-17 $525,521 $415,075 $110,446
Dec-16 Feb-17 $395,217 $369,848 $25,369
Jan-17 & Oct-Dec 16 Qtrly Mar-17 $506,524 $507,213 ($689)
Feb-17 Apr-17 $411,020 $427,075 ($16,055)
Mar-17 May-17 $340,162 $328,574 $11,587
Apr-17 & Jan-Mar 17 Qtrly Jun-17 $489,008 $481,201 $7,807
May-17 Jul-17 $559,115 $480,060 $79,055
Jun-17 Aug-17 $338,470 $291,848 $46,622
Jul-17 & Apr-June 17 Qtrly Sep-17 $542,457 $536,554 $5,903
Aug-17 Oct-17 $425,497 $435,211 ($9,714)
Sep-17 Nov-17 $430,909
Oct-17 & Jul-Sept 17 Qtrly Dec-17 $369,796
Total Overage/Shortfall $5,073,365 $260,332
3Budgeted based on 3-year average percentage
Period
Reporting
Period
Reporting
Period
Reporting
City of Jefferson, Mo. - Account Analysis
Printed 10/10/2017
Account Name General Fund Sales Tax Receipt Month: OCTOBER 2017
Account Number 10-100-400010 Prior 5 years
Monthly
REPORTING PERIOD RECEIPT PERIOD 2012 2013 2014 2015 2016 2017 Average
Nov January 843,061 764,659 741,056 944,619 929,179 1,083,570 act.844,515
Dec February 619,287 703,181 789,830 727,437 812,670 806,789 act.730,481
Jan & Oct-Dec Qtrly March 992,559 1,008,111 920,599 1,091,021 1,183,675 1,073,842 act.1,039,193
Feb April 852,653 777,424 737,482 1,059,943 893,024 843,561 act.864,105
Mar May 530,069 537,141 802,765 618,854 648,305 687,741 act.627,427
Apr & Jan-Mar Qtrly June 1,028,514 1,023,015 865,930 1,045,933 1,119,566 1,000,942 act.1,016,592
May July 797,785 872,436 1,048,754 963,280 1,012,207 1,154,051 act.938,892
Jun August 557,032 546,351 614,048 562,996 661,518 678,636 act.588,389
Jul & Apr-Jun Qtrly September 1,069,414 1,096,581 996,272 1,185,891 1,197,976 1,143,504 act.1,109,227
Aug October 769,129 717,262 919,035 918,839 903,829 883,215 act.845,619
Sept November 615,421 677,366 651,080 661,849 623,645 959,772 est.645,872
Oct & Jul-Sept Qtrly December 982,684 932,387 1,015,322 1,075,638 1,016,682 823,654 est.1,004,542
Actual to Date $ 9,657,608 $ 9,655,913 $ 10,102,175 $ 10,856,302 $ 11,002,277 9,355,851
Estimated to Fiscal Year end (based on averages and on Budgeted amount)1,783,426
Total Actual & Estimated $ 11,139,277
Less: Budget 11,300,000
Over (Under) Budget -$ 160,723
$ 1,083,570
$ 1,890,359
$ 2,964,201
$ 3,807,762 $ 4,495,504
$ 5,496,445
$ 6,650,496
$ 7,329,132
$ 8,472,636
$ 9,355,851
$ 924,504
$ 1,748,274
$ 2,877,998
$ 3,829,230
$ 4,561,069
$ 5,632,857
$ 6,702,104
$ 7,352,144
$ 8,547,221
$ 9,516,574
$ 10,476,346
$ 11,300,000
$ 0
$ 500,000
$ 1,000,000
$ 1,500,000
$ 2,000,000
$ 2,500,000
$ 3,000,000
$ 3,500,000
$ 4,000,000
$ 4,500,000
$ 5,000,000
$ 5,500,000
$ 6,000,000
$ 6,500,000
$ 7,000,000
$ 7,500,000
$ 8,000,000
$ 8,500,000
$ 9,000,000
$ 9,500,000
$ 10,000,000
$ 10,500,000
$ 11,000,000
$ 11,500,000
$ 12,000,000
Nov Dec Jan & Oct-Dec
Qtrly
Feb Mar Apr & Jan-Mar
Qtrly
May Jun Jul & Apr-Jun
Qtrly
Aug Sept Oct & Jul-Sept
Qtrly
REPORTING PERIOD
YTD Actuals vs. YTD Budget
Actual
Budget
City of Jefferson, Mo. - Account Analysis
Printed 10/10/2017
Account Name Capital Imprs Sales Tax Receipt Month: OCTOBER 2017
Account Number 44-100-400010/45-100-440010 Prior 5 years
Monthly
REPORTING PERIOD RECEIPT PERIOD 2012 2013 2014 2015 2016 2017 Average
Nov January 412,434 372,459 359,800 461,560 455,278 525,521 act.412,306
Dec February 308,567 350,813 394,475 362,597 405,543 402,964 act.364,399
Jan & Oct-Dec Qtrly March 466,856 475,110 423,641 511,685 563,056 506,597 act.488,070
Feb April 409,365 372,340 348,172 512,808 431,353 411,020 act.414,808
Mar May 263,902 266,422 399,863 308,247 322,957 340,162 act.312,278
Apr & Jan-Mar Qtrly June 494,757 483,070 416,943 496,466 539,529 489,008 act.486,153
May July 389,423 425,325 503,869 473,120 498,229 559,119 act.457,993
Jun August 278,231 272,603 306,157 280,733 330,112 338,618 act.293,567
Jul & Apr-Jun Qtrly September 504,307 521,260 484,992 565,296 570,134 542,457 act.529,198
Aug October 367,366 357,619 430,185 442,371 435,416 425,493 act.406,591
Sept November 306,968 323,871 324,697 330,393 310,506 411,938 est.319,287
Oct & Jul-Sept Qtrly December 469,095 443,688 485,136 515,478 494,218 353,515 est.481,523
Actual to Date $ 4,671,272 $ 4,664,580 $ 4,877,931 $ 5,260,753 $ 5,356,330 4,540,959
Estimated to Fiscal Year end (based on averages and on Budgeted amount)765,453
Total Actual & Estimated $ 5,306,412
Less: Budget 4,850,000
Over (Under) Budget $ 456,412
$ 525,521
$ 928,485
$ 1,435,082
$ 1,846,103
$ 2,186,264
$ 2,675,273
$ 3,234,392
$ 3,573,009
$ 4,115,466
$ 4,540,959
$ 396,801
$ 750,365
$ 1,235,247
$ 1,643,519
$ 1,957,627
$ 2,417,642
$ 2,876,567
$ 3,155,566
$ 3,668,497
$ 4,084,547
$ 4,496,485
$ 4,850,000
$ 100,000
$ 350,000
$ 600,000
$ 850,000
$ 1,100,000
$ 1,350,000
$ 1,600,000
$ 1,850,000
$ 2,100,000
$ 2,350,000
$ 2,600,000
$ 2,850,000
$ 3,100,000
$ 3,350,000
$ 3,600,000
$ 3,850,000
$ 4,100,000
$ 4,350,000
$ 4,600,000
$ 4,850,000
$ 5,100,000
Nov Dec Jan & Oct-
Dec Qtrly
Feb Mar Apr & Jan-
Mar Qtrly
May Jun Jul & Apr-Jun
Qtrly
Aug Sept Oct & Jul-
Sept Qtrly
REPORTING PERIOD
YTD Actuals vs. YTD Budget
Actual
Budget
City of Jefferson, Mo. - Account Analysis
Printed 10/10/2017
Account Name Parks Sales Tax Receipt Month: OCTOBER 2017
Account Number 21-210-400010 Prior 5 years
Monthly
REPORTING PERIOD RECEIPT PERIOD 2012 2013 2014 2015 2016 2017 Average
Nov January 405,730 372,447 359,708 461,472 455,239 525,521 act.410,919
Dec February 308,456 350,714 393,562 362,371 405,543 395,217 act.364,129
Jan & Oct-Dec Qtrly March 466,713 475,026 423,546 511,582 563,039 506,524 act.487,981
Feb April 409,353 372,242 348,076 512,738 431,353 411,020 act.414,752
Mar May 263,822 266,456 398,085 308,030 322,957 340,162 act.311,870
Apr & Jan-Mar Qtrly June 494,733 482,382 416,845 496,386 539,529 489,008 act.485,975
May July 389,006 425,194 503,790 473,038 498,229 559,115 act.457,851
Jun August 278,072 272,321 305,930 280,513 330,112 338,470 act.293,390
Jul & Apr-Jun Qtrly September 505,913 521,155 484,904 565,217 572,847 542,457 act.530,007
Aug October 366,846 357,482 430,093 442,370 435,416 425,497 act.406,441
Sept November 306,831 323,768 324,481 330,393 310,506 430,909 est.319,196
Oct & Jul-Sept Qtrly December 468,924 443,569 484,999 515,368 494,218 369,796 est.481,415
Actual to Date $ 4,664,400 $ 4,662,755 $ 4,874,018 $ 5,259,477 $ 5,358,988 4,532,991
Estimated to Fiscal Year end (based on averages and on Budgeted amount)800,705
Total Actual & Estimated $ 5,333,697
Less: Budget 5,073,365
Over (Under) Budget $ 260,332
$ 525,521
$ 920,739
$ 1,427,263
$ 1,838,283
$ 2,178,445
$ 2,667,453
$ 3,226,568
$ 3,565,038
$ 4,107,495
$ 4,532,991
$ 415,075
$ 784,923
$ 1,292,136
$ 1,719,211
$ 2,047,785
$ 2,528,986
$ 3,009,046
$ 3,300,895
$ 3,837,449
$ 4,272,660
$ 4,703,569
$ 5,073,365
$ 100,000
$ 350,000
$ 600,000
$ 850,000
$ 1,100,000
$ 1,350,000
$ 1,600,000
$ 1,850,000
$ 2,100,000
$ 2,350,000
$ 2,600,000
$ 2,850,000
$ 3,100,000
$ 3,350,000
$ 3,600,000
$ 3,850,000
$ 4,100,000
$ 4,350,000
$ 4,600,000
$ 4,850,000
$ 5,100,000
$ 5,350,000
Nov Dec Jan & Oct-
Dec Qtrly
Feb Mar Apr & Jan-
Mar Qtrly
May Jun Jul & Apr-Jun
Qtrly
Aug Sept Oct & Jul-
Sept Qtrly
REPORTING PERIOD
YTD Actuals vs. YTD Budget
Actual
Budget
Re
v
e
n
u
e
Mo
d
e
l
Re
p
o
r
t
Fo
r
Pe
r
i
o
d
En
d
i
n
g
Se
p
t
e
m
b
e
r
30
,
20
1
7
Da
t
a
as
of
Oc
t
o
b
e
r
9,
20
1
7
FY
20
1
7
Y
T
D
Ac
t
u
a
l
P
r
o
j
e
c
t
e
d
Ov
e
r
/
De
s
c
r
i
p
t
i
o
n
Bu
d
g
e
t
As
of
10
/
9
/
1
7
(U
n
d
e
r
)
Bu
d
g
e
t
Sa
l
e
s
Ta
x
an
d
Us
e
Ta
x
$1
1
,
3
0
0
,
0
0
0
.
0
0
$
9
,
3
5
5
,
8
5
0
.
8
7
($
1
6
0
,
7
2
3
.
0
4
)
In
t
e
r
g
o
v
e
r
n
m
e
n
t
a
l
Ta
x
e
s
$2
,
2
2
0
,
0
0
0
.
0
0
$
1
,
9
2
1
,
1
8
0
.
1
2
$
1
2
3
,
1
1
8
.
2
2
Ot
h
e
r
Ta
x
e
s
$1
1
6
,
0
0
0
.
0
0
$
9
5
,
5
7
5
.
9
2
($
2
,
2
1
0
.
5
8
)
Fr
a
n
c
h
i
s
e
& Ut
i
l
i
t
y
Ta
x
$7
,
5
0
0
,
0
0
0
.
0
0
$
5
,
8
8
8
,
9
7
8
.
3
3
($
3
4
7
,
1
3
6
.
0
2
)
Pr
o
p
e
r
t
y
Ta
x
e
s
$5
,
2
7
4
,
6
9
9
.
0
0
$
5
,
4
0
6
,
5
2
0
.
5
8
$
1
4
2
,
7
5
8
.
6
0
In
t
e
r
g
o
v
e
r
n
m
e
n
t
a
l
$6
6
,
9
8
1
.
5
4
$
6
9
,
7
0
1
.
6
3
$
7
,
7
6
0
.
0
9
Ch
a
r
g
e
s
fo
r
Se
r
v
i
c
e
s
$2
,
7
1
5
,
9
9
3
.
6
5
$
2
,
6
4
1
,
8
6
1
.
6
2
$
2
7
,
8
9
3
.
6
5
Fe
e
s
,
Li
c
e
n
s
e
s
,
& Pe
r
m
i
t
s
$7
0
8
,
4
0
0
.
0
0
$
9
6
7
,
1
7
6
.
5
7
$
2
9
3
,
6
7
5
.
0
5
Fi
n
e
s
& Fo
r
f
e
i
t
u
r
e
s
$1
,
0
0
9
,
1
0
0
.
0
0
$
7
4
7
,
8
8
8
.
7
3
($
1
8
9
,
6
4
6
.
5
9
)
Co
n
t
r
i
b
u
t
i
o
n
s
/
D
o
n
a
t
i
o
n
s
$3
0
8
,
6
4
1
.
6
5
$
2
7
6
,
0
8
4
.
0
8
$
1
7
,
4
4
2
.
4
3
Ot
h
e
r
Op
e
r
a
t
i
n
g
Re
v
e
n
u
e
s
$8
4
,
1
8
1
.
2
5
$
1
7
0
,
4
7
2
.
8
1
$
1
0
7
,
4
0
2
.
6
2
In
t
e
r
e
s
t
In
c
o
m
e
$1
1
0
,
0
0
0
.
0
0
$
1
6
2
,
1
4
3
.
3
6
$
6
0
,
6
0
6
.
4
7
Ot
h
e
r
No
n
Op
e
r
a
t
i
n
g
Re
v
e
n
u
e
$5
4
,
0
0
0
.
0
0
$
9
6
,
7
9
9
.
5
0
$
6
2
,
7
9
9
.
5
0
Op
e
r
a
t
i
n
g
Tr
a
n
s
f
e
r
s
In
$23
,
8
0
0
.
0
0
$22
,
6
1
3
.
8
4
$86
0
.
7
2
To
t
a
l
s
$3
1
,
4
9
1
,
7
9
7
.
0
9
$
2
7
,
8
2
2
,
8
4
7
.
9
6
$
1
4
4
,
6
0
1
.
1
2
FY2017
Revenue Model Report (Detail)Remaining
For Period Ending September 30, 2017 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification
Description Budget As of 10/9/17 As of 10/9/17 TOTAL (Under) Budget of Formulas
Sales Tax and Use Tax
10‐100‐400010 Sales Tax $11,300,000.00 $9,355,850.87 $1,783,426.09 $11,139,276.96 ($160,723.04)($160,723.04)
$11,300,000.00 $9,355,850.87 $1,783,426.09 $11,139,276.96 ($160,723.04) ($160,723.04)
Intergovernmental Taxes
10‐100‐401030 Motor Vehicle Sales Tax $550,000.00 $438,996.23 $128,892.44 $567,888.67 $17,888.67 $17,888.67
10‐100‐403010 Gasoline Tax $1,120,000.00 $868,662.11 $293,045.66 $1,161,707.77 $41,707.77 $41,707.77
10‐100‐430080 Road & Bridge Tax $550,000.00 $613,521.78 $0.00 $613,521.78 $63,521.78 $63,521.78
$2,220,000.00 $1,921,180.12 $421,938.10 $2,343,118.22 $123,118.22 $123,118.22
Other Taxes
10‐100‐403020 Cig Tax $116,000.00 $95,575.92 $18,213.50 $113,789.42 ($2,210.58)($2,210.58)
$116,000.00 $95,575.92 $18,213.50 $113,789.42 ($2,210.58)($2,210.58)
Franchise & Utility Tax
10‐100‐410020 Electric Utility Lic Tax $4,000,000.00 $3,216,125.06 $719,300.59 $3,935,425.65 ($64,574.35)($64,574.35)
10‐100‐410030 Gas Utility License Tax $1,000,000.00 $718,265.11 $85,060.08 $803,325.19 ($196,674.81)($196,674.81)
10‐100‐410052 Telephone/Cell Utility $2,070,000.00 $1,657,730.07 $346,877.45 $2,004,607.52 ($65,392.48)($65,392.48)
10‐100‐410053 Telephone/Cell Audit $0.00 ($15,210.20)$16,210.20 $1,000.00 $1,000.00 $1,000.00
10‐100‐410060 Cable Franchise Fee $430,000.00 $312,068.29 $96,437.34 $408,505.63 ($21,494.37)($21,494.37)
$7,500,000.00 $5,888,978.33 $1,263,885.65 $7,152,863.98 ($347,136.02)($347,136.02)
Property Taxes
10‐100‐420010 Current Property Tax $4,617,300.00 $4,716,999.85 $3,431.36 $4,720,431.21 $103,131.21 $103,131.21
10‐100‐420020 Del Property Tax $46,000.00 $41,881.71 $892.48 $42,774.19 ($3,225.81)($3,225.81)
10‐100‐420040 Fin Institution Tax $42,000.00 $53,460.77 $0.00 $53,460.77 $11,460.77 $11,460.77
10‐100‐420050 Prop Tax Int & Penalties $25,000.00 $24,318.41 $1,463.66 $25,782.07 $782.07 $782.07
10‐100‐420055 Surtax Receipts ‐ County Reimb $54,399.00 $54,399.28 $0.00 $54,399.28 $0.28 $0.28
10‐100‐420060 Surtax Receipts $465,000.00 $464,899.77 $560.47 $465,460.24 $460.24 $460.24
10‐100‐420080 Special Tax Rev $25,000.00 $50,560.79 $4,589.05 $55,149.84 $30,149.84 $30,149.84
$5,274,699.00 $5,406,520.58 $10,937.02 $5,417,457.60 $142,758.60 $142,758.60
Intergovernmental
10‐100‐430040 Local Grant $5,040.00 $0.09 $5,040.00 $5,040.09 $0.09 $0.09
10‐100‐480020 NSP Rehab Sales $61,941.54 $62,291.54 $0.00 $62,291.54 $350.00 $350.00
10‐100‐480025 HUD Program Income $0.00 $7,410.00 $0.00 $7,410.00 $7,410.00 $7,410.00
$66,981.54 $69,701.63 $5,040.00 $74,741.63 $7,760.09 $7,760.09
Charges for Services
10‐100‐440010 Admin Charge Backs $1,556,063.00 $1,556,063.00 $0.00 $1,556,063.00 $0.00 $0.00
10‐100‐440050 Emt Reimbursement $25,000.00 $25,000.00 $0.00 $25,000.00 $0.00 $0.00
10‐100‐440210 Street Cuts $28,000.00 $19,246.00 $4,511.61 $23,757.61 ($4,242.39)($4,242.39)
10‐100‐440910 Fuel Charge ‐ backs $11,000.00 $7,971.40 $853.66 $8,825.06 ($2,174.94)($2,174.94)
10‐100‐440920 Parts Charge backs $185,000.00 $179,914.94 $18,365.27 $198,280.21 $13,280.21 $13,280.21
10‐100‐440930 Labor Charge backs $240,000.00 $209,127.48 $21,149.43 $230,276.91 ($9,723.09)($9,723.09)
10‐100‐481020 Cole Cty Animal Rescue $105,508.00 $79,131.03 $26,377.00 $105,508.03 $0.03 $0.03
10‐100‐481030 Rent City Hall/Annex $35,000.00 $35,000.00 $0.00 $35,000.00 $0.00 $0.00
10‐100‐481040 Rent Other $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
10‐100‐481045 Rent‐tower Sites $104,000.00 $126,031.08 $2,276.32 $128,307.40 $24,307.40 $24,307.40
10‐100‐481065 Parking Spot Maintenance $25,000.00 $25,000.00 $0.00 $25,000.00 $0.00 $0.00
10‐100‐481075 Cole Cty 911 Reimb $366,423.91 $339,071.94 $26,515.11 $365,587.05 ($836.86)($836.86)
10‐100‐481080 Sale Of Maps/GIS Data $0.00 $30.00 $0.00 $30.00 $30.00 $30.00
10‐100‐481085 Cole Cty GIS Joint Coop $15,000.00 $24,850.00 $1,250.00 $26,100.00 $11,100.00 $11,100.00
10‐100‐481100 Sale Of Grave Sites $4,000.00 $6,936.00 $727.27 $7,663.27 $3,663.27 $3,663.27
10‐100‐481105 TIF Administration Fee $15,998.74 $8,498.75 $0.00 $8,498.75 ($7,499.99)($7,499.99)
10‐100‐481110 Long & Short $0.00 ($10.00)$0.00 ($10.00)($10.00)($10.00)
$2,715,993.65 $2,641,861.62 $102,025.68 $2,743,887.30 $27,893.65 $27,893.65
Fees, Licenses, & Permits
10‐100‐450010 Liquor Licenses $66,000.00 $64,181.00 $174.30 $64,355.30 ($1,644.70)($1,644.70)
10‐100‐450020 Business Licenses $215,000.00 $214,517.93 $2,449.24 $216,967.17 $1,967.17 $1,967.17
10‐100‐450021 Home Occupation Permit $1,600.00 $1,589.98 $121.03 $1,711.01 $111.01 $111.01
10‐100‐450040 Abandoned Bldg. Regist. $0.00 $7,775.00 $0.00 $7,775.00 $7,775.00 $7,775.00
10‐100‐450041 Abandoned Bldg. Admin Fee $6,500.00 $104,467.00 $0.00 $104,467.00 $97,967.00 $97,967.00
10‐100‐450045 Building Construct. Fees $150,000.00 $304,545.70 $19,728.58 $324,274.28 $174,274.28 $174,274.28
10‐100‐450050 Electrical Certificates $19,000.00 $19,470.00 $0.00 $19,470.00 $470.00 $470.00
10‐100‐450060 Electrical Permits $4,000.00 $2,539.34 $1,562.02 $4,101.36 $101.36 $101.36
10‐100‐450070 Plumbing Licenses $10,500.00 $10,596.00 $102.91 $10,698.91 $198.91 $198.91
10‐100‐450080 Plumbing Permits $4,000.00 $4,115.75 $212.38 $4,328.13 $328.13 $328.13
10‐100‐450090 Other Lic & Permits $2,000.00 $1,809.00 $387.83 $2,196.83 $196.83 $196.83
10‐100‐450091 Day Care Inspection Fees $7,000.00 $6,035.00 $1,232.65 $7,267.65 $267.65 $267.65
FY2017
Revenue Model Report (Detail)Remaining
For Period Ending September 30, 2017 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification
Description Budget As of 10/9/17 As of 10/9/17 TOTAL (Under) Budget of Formulas
10‐100‐450092 Food Inspection Fees $85,000.00 $88,057.57 ($3,167.99)$84,889.58 ($110.42)($110.42)
10‐100‐450100 Curb Cut Permits $800.00 $1,057.00 $70.94 $1,127.94 $327.94 $327.94
10‐100‐450110 Board Of Adj Fees $1,300.00 $2,520.00 $0.00 $2,520.00 $1,220.00 $1,220.00
10‐100‐450120 Sign Permits $5,100.00 $5,829.00 $259.22 $6,088.22 $988.22 $988.22
10‐100‐450130 Demolition Permits $900.00 $477.00 $13.94 $490.94 ($409.06)($409.06)
10‐100‐450150 Acc Rep Fees‐police $11,200.00 $10,591.70 $834.08 $11,425.78 $225.78 $225.78
10‐100‐450160 Accrpt/blastg P‐fire $900.00 $1,233.00 $261.05 $1,494.05 $594.05 $594.05
10‐100‐450170 Animal Redemption Fees $60,000.00 $58,735.00 $6,105.68 $64,840.68 $4,840.68 $4,840.68
10‐100‐450180 Animal Vaccinations Fees $4,300.00 $4,425.00 $573.50 $4,998.50 $698.50 $698.50
10‐100‐450185 Animal Cremation Fees $30,000.00 $37,085.00 $812.74 $37,897.74 $7,897.74 $7,897.74
10‐100‐450186 Animal Boarding Fees $0.00 $930.00 $0.00 $930.00 $930.00 $930.00
10‐100‐450190 Taxi Permits $700.00 $312.00 $0.00 $312.00 ($388.00)($388.00)
10‐100‐450230 Vacating Right Of Way $800.00 $1,596.00 $39.50 $1,635.50 $835.50 $835.50
10‐100‐450250 Rezoning Request $12,000.00 $4,583.60 $3,018.63 $7,602.23 ($4,397.77)($4,397.77)
10‐100‐450255 Planning & Zoning Review Fees $8,000.00 $7,048.00 $106.24 $7,154.24 ($845.76)($845.76)
10‐100‐450260 Non‐refundable Plans/spec $1,800.00 $1,055.00 $0.00 $1,055.00 ($745.00)($745.00)
$708,400.00 $967,176.57 $34,898.48 $1,002,075.05 $293,675.05 $293,675.05
Fines & Forfeitures
10‐100‐460010 Court Cost $75,500.00 $66,551.93 $6,135.76 $72,687.69 ($2,812.31)($2,812.31)
10‐100‐460015 Court Restitutions $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
10‐100‐460018 Inmate Security Fund $12,500.00 $11,044.38 $946.63 $11,991.01 ($508.99)($508.99)
10‐100‐460020 Jail Cost Recovery $4,000.00 $1,506.28 $228.50 $1,734.78 ($2,265.22)($2,265.22)
10‐100‐460025 Alcohol Offense Cost Rec $8,000.00 $5,145.00 $368.06 $5,513.06 ($2,486.94)($2,486.94)
10‐100‐460030 Pol Fines‐traffic $860,000.00 $636,917.89 $62,938.62 $699,856.51 ($160,143.49)($160,143.49)
10‐100‐460090 Parking Fines $53,000.00 $29,629.44 $1,898.33 $31,527.77 ($21,472.23)($21,472.23)
10‐100‐460100 Bankcard Charges ($3,900.00)($2,906.19)($951.21)($3,857.40)$42.60 $42.60
$1,009,100.00 $747,888.73 $71,564.68 $819,453.41 ($189,646.59)($189,646.59)
Contributions/Donations
10‐100‐480055 JC Fire Museum $0.00 $3,226.00 $0.00 $3,226.00 $3,226.00 $3,226.00
10‐100‐480070 Community Projects Donations $5,891.65 $5,891.65 $0.00 $5,891.65 $0.00 $0.00
10‐100‐480080 Dare Donations $0.00 $500.00 $0.00 $500.00 $500.00 $500.00
10‐100‐480090 Police K‐9 Donations $500.00 $500.00 $0.00 $500.00 $0.00 $0.00
10‐100‐480165 Animal S Donations $0.00 $13,716.43 $0.00 $13,716.43 $13,716.43 $13,716.43
10‐100‐481055 Street Repair‐Solid Waste Cntr $302,250.00 $252,250.00 $50,000.00 $302,250.00 $0.00 $0.00
10‐100‐481095 Cemetery Donations $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$308,641.65 $276,084.08 $50,000.00 $326,084.08 $17,442.43 $17,442.43
Other Operating Revenues
10‐100‐480011 Police Evidence Funds $0.00 $10,457.83 $0.00 $10,457.83 $10,457.83 $10,457.83
10‐100‐481070 Miscellaneous $35,000.00 $47,158.13 $4,258.61 $51,416.74 $16,416.74 $16,416.74
10‐100‐481072 TIF Prof Svcs Deposit $1,181.25 $86,196.29 $0.00 $86,196.29 $85,015.04 $85,015.04
10‐100‐481074 Revenue Share ‐ Purchasing Card $18,000.00 $15,266.05 $2,858.50 $18,124.55 $124.55 $124.55
10‐100‐481077 Insurance Claims $20,000.00 $11,394.51 $3,993.96 $15,388.47 ($4,611.53)($4,611.53)
10‐100‐481078 Cafeteria Refunds $10,000.00 $0.00 $10,000.00 $10,000.00 $0.00 $0.00
$84,181.25 $170,472.81 $21,111.06 $191,583.87 $107,402.62 $107,402.62
Interest Income
10‐100‐470010 Interest $110,000.00 $162,143.36 $8,463.11 $170,606.47 $60,606.47 $60,606.47
$110,000.00 $162,143.36 $8,463.11 $170,606.47 $60,606.47 $60,606.47
Other Non Operating Revenue
10‐100‐485050 Sale Of Assets $54,000.00 $96,799.50 $20,000.00 $116,799.50 $62,799.50 $62,799.50
$54,000.00 $96,799.50 $20,000.00 $116,799.50 $62,799.50 $62,799.50
Operating Transfers In
10‐100‐490240 Trsfr From Lodging Tax $23,800.00 $22,613.84 $2,046.88 $24,660.72 $860.72 $860.72
10‐100‐490630 Transfer from Self Funded Hlth Ins $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$23,800.00 $22,613.84 $2,046.88 $24,660.72 $860.72 $860.72
$31,491,797.09 $27,822,847.96 $3,813,550.25 $31,636,398.21 $144,601.12 $144,601.12
General Ledger
Trial Balance by Acct Type and Full
Acct Number
User: spearre
Printed: 10/09/17 08:47:49
Period 01 - 13
Fiscal Year 2017
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10 General Fund
Revenue Revenue
100 Revenue
10-100-400010 Sales Tax 11,300,000.00 8,472,636.17 0.00 2,827,363.83 25.02
10-100-400020 Sales Tax Interest 0.00 0.00 0.00 0.00 0.00
R10 Sales & Use Taxes 11,300,000.00 8,472,636.17 0.00 2,827,363.83 25.02
10-100-401030 Motor Vehicle Tax 550,000.00 438,996.23 0.00 111,003.77 20.18
10-100-403010 Gasoline Tax 1,120,000.00 868,662.11 0.00 251,337.89 22.44
10-100-430080 Road & Bridge Tax 550,000.00 613,521.78 0.00 -63,521.78 -11.55
R16 Intergovernmental Taxes 2,220,000.00 1,921,180.12 0.00 298,819.88 13.46
10-100-403020 Cigarette Tax 116,000.00 95,575.92 0.00 20,424.08 17.61
R20 Other Taxes 116,000.00 95,575.92 0.00 20,424.08 17.61
10-100-410020 Electric Utility Lic Tax 4,000,000.00 3,216,125.06 0.00 783,874.94 19.60
10-100-410021 Electric Utility-AUDIT 0.00 0.00 0.00 0.00 0.00
10-100-410030 Gas Utility License Tax 1,000,000.00 718,265.11 0.00 281,734.89 28.17
10-100-410031 Gas Utility-AUDIT 0.00 0.00 0.00 0.00 0.00
10-100-410050 INACTIVE - Phone Utility Tax 0.00 0.00 0.00 0.00 0.00
10-100-410051 INACTIVE - Cell Utility Tax 0.00 0.00 0.00 0.00 0.00
10-100-410052 TelephoneCell Utility Tax 2,070,000.00 1,657,730.07 0.00 412,269.93 19.92
10-100-410053 TelephoneCell Utility-AUDIT 0.00 -15,210.20 0.00 15,210.20 0.00
10-100-410060 Cable Franchise Fee 430,000.00 312,068.29 0.00 117,931.71 27.43
10-100-410061 Cable Utility-AUDIT 0.00 0.00 0.00 0.00 0.00
R30 Franchise & Utility Tax 7,500,000.00 5,888,978.33 0.00 1,611,021.67 21.48
10-100-420010 Cur Property Tax 4,617,300.00 4,716,999.85 0.00 -99,699.85 -2.16
10-100-420020 Del Property Tax 46,000.00 41,881.71 0.00 4,118.29 8.95
10-100-420040 Fin Inst Tax 42,000.00 53,460.77 0.00 -11,460.77 -27.29
10-100-420050 Prop Tax Int & Penalties 25,000.00 24,318.41 0.00 681.59 2.73
10-100-420055 Surtax Receipts - County Reimb 54,399.00 54,399.28 0.00 -0.28 0.00
10-100-420060 Surtax Receipts 465,000.00 464,899.77 0.00 100.23 0.02
10-100-420080 Special Tax Rev 25,000.00 50,560.79 0.00 -25,560.79 -102.24
R40 Property Taxes 5,274,699.00 5,406,520.58 0.00 -131,821.58 -2.50
GL - Trial Balance by Acct Type and Full Acct Number (10/09/2017 - 8:47 AM)Page 1
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-100-430010 Federal Grants 0.00 0.00 0.00 0.00 0.00
10-100-430020 State Grants 0.00 0.00 0.00 0.00 0.00
10-100-430040 Local Grants 5,040.00 0.09 0.00 5,039.91 100.00
10-100-430060 Drug Forfeiture 0.00 0.00 0.00 0.00 0.00
10-100-430074 Overtime Reimb 0.00 0.00 0.00 0.00 0.00
10-100-430100 State DNR Historic Pres.0.00 0.00 0.00 0.00 0.00
10-100-480020 NSP Rehab Sales 61,941.54 62,291.54 0.00 -350.00 -0.57
10-100-480025 HUD Program Income 0.00 7,410.00 0.00 -7,410.00 0.00
R50 Intergovernmental 66,981.54 69,701.63 0.00 -2,720.09 -4.06
10-100-440010 Admin Charge Backs 1,556,063.00 1,556,063.00 0.00 0.00 0.00
10-100-440050 Emt Reimbursement 25,000.00 25,000.00 0.00 0.00 0.00
10-100-440210 Street Cuts 28,000.00 19,246.00 0.00 8,754.00 31.26
10-100-440910 Fuel Charge-backs 11,000.00 7,971.40 0.00 3,028.60 27.53
10-100-440920 Parts Charge-back 185,000.00 179,914.94 0.00 5,085.06 2.75
10-100-440930 Labor Charge-backs 240,000.00 209,127.48 0.00 30,872.52 12.86
10-100-450189 Animal Shelter Bricks 0.00 0.00 0.00 0.00 0.00
10-100-481020 Cole Cty Animal Rescue 105,508.00 79,131.03 0.00 26,376.97 25.00
10-100-481030 Rent City Hallannex 35,000.00 35,000.00 0.00 0.00 0.00
10-100-481039 Rent-Hyde Park Facility 0.00 0.00 0.00 0.00 0.00
10-100-481040 Rent Other 0.00 0.00 0.00 0.00 0.00
10-100-481045 Rent-tower Sites 104,000.00 126,031.08 0.00 -22,031.08 -21.18
10-100-481065 Parking Spot Maintenance 25,000.00 25,000.00 0.00 0.00 0.00
10-100-481075 Cole Cty 911 Reimb 366,423.91 339,071.94 0.00 27,351.97 7.46
10-100-481080 Sale Of Mapsgis Data 0.00 30.00 0.00 -30.00 0.00
10-100-481085 Cole Cty Gis Joint Coop 15,000.00 24,850.00 0.00 -9,850.00 -65.67
10-100-481090 Cole Cty Sheriff-New World 0.00 0.00 0.00 0.00 0.00
10-100-481100 Sale Of Grave Sites 4,000.00 6,936.00 0.00 -2,936.00 -73.40
10-100-481105 TIF Administration Fee 15,998.74 8,498.75 0.00 7,499.99 46.88
10-100-481110 Long & Short 0.00 -10.00 0.00 10.00 0.00
R60 Charges for Services 2,715,993.65 2,641,861.62 0.00 74,132.03 2.73
10-100-450010 Liquor Licenses 66,000.00 64,181.00 0.00 1,819.00 2.76
10-100-450020 Business Licenses 215,000.00 214,517.93 0.00 482.07 0.22
10-100-450021 Home Occupation Permit 1,600.00 1,589.98 0.00 10.02 0.63
10-100-450030 Soliciters Licenses 0.00 0.00 0.00 0.00 0.00
10-100-450040 Abandoned Bldg Registration 0.00 7,775.00 0.00 -7,775.00 0.00
10-100-450041 Abandoned Bldg Admin Fee 6,500.00 104,467.00 0.00 -97,967.00 -1,507.18
10-100-450045 Bldg Constr Fees 150,000.00 304,545.70 0.00 -154,545.70 -103.03
10-100-450050 Electrical Certificates 19,000.00 19,470.00 0.00 -470.00 -2.47
10-100-450060 Electrical Permits 4,000.00 2,539.34 0.00 1,460.66 36.52
10-100-450070 Plumbing Licenses 10,500.00 10,596.00 0.00 -96.00 -0.91
10-100-450080 Plumbing Permits 4,000.00 4,115.75 0.00 -115.75 -2.89
10-100-450090 Other Lic & Permits 2,000.00 1,809.00 0.00 191.00 9.55
10-100-450091 Day Care Inspection Fees 7,000.00 6,035.00 0.00 965.00 13.79
10-100-450092 Food Inspection Fees 85,000.00 88,057.57 0.00 -3,057.57 -3.60
10-100-450100 Curb Cut Permits 800.00 1,057.00 0.00 -257.00 -32.13
10-100-450110 Board Of Adj Fees 1,300.00 2,520.00 0.00 -1,220.00 -93.85
10-100-450120 Sign Permits 5,100.00 5,829.00 0.00 -729.00 -14.29
GL - Trial Balance by Acct Type and Full Acct Number (10/09/2017 - 8:47 AM)Page 2
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-100-450130 Demolition Permits 900.00 477.00 0.00 423.00 47.00
10-100-450150 Acc Rep Fees-police 11,200.00 10,591.70 0.00 608.30 5.43
10-100-450160 Accrptblastg P-fire 900.00 1,233.00 0.00 -333.00 -37.00
10-100-450170 Animal Redemption Fees 60,000.00 58,735.00 0.00 1,265.00 2.11
10-100-450180 Animal Vaccinations Fees 4,300.00 4,425.00 0.00 -125.00 -2.91
10-100-450185 Animal Cremation Fees 30,000.00 37,085.00 0.00 -7,085.00 -23.62
10-100-450186 Animal Boarding Fees 0.00 930.00 0.00 -930.00 0.00
10-100-450190 Taxi Permits 700.00 312.00 0.00 388.00 55.43
10-100-450230 Vacating Right Of Way 800.00 1,596.00 0.00 -796.00 -99.50
10-100-450250 Rezoning Request 12,000.00 4,583.60 0.00 7,416.40 61.80
10-100-450255 Planning & Zoning Review Fees 8,000.00 7,048.00 0.00 952.00 11.90
10-100-450260 Non-refundable Plansspec 1,800.00 1,055.00 0.00 745.00 41.39
R65 Fees Licenses & Permits 708,400.00 967,176.57 0.00 -258,776.57 -36.53
10-100-460010 Court Cost 75,500.00 66,551.93 0.00 8,948.07 11.85
10-100-460015 Court Restitutions 0.00 0.00 0.00 0.00 0.00
10-100-460018 Inmate Security Fund 12,500.00 11,044.38 0.00 1,455.62 11.64
10-100-460020 Jail Cost Recovery 4,000.00 1,506.28 0.00 2,493.72 62.34
10-100-460025 Alcohol Offense Cost Rec 8,000.00 5,145.00 0.00 2,855.00 35.69
10-100-460030 Pol Fines-traffic 860,000.00 636,917.89 0.00 223,082.11 25.94
10-100-460040 Pol Tickets-parking 0.00 0.00 0.00 0.00 0.00
10-100-460050 Pol Fines-other 0.00 0.00 0.00 0.00 0.00
10-100-460060 Dog Fines 0.00 0.00 0.00 0.00 0.00
10-100-460070 P & Code Violations 0.00 0.00 0.00 0.00 0.00
10-100-460090 Parking Fines 53,000.00 29,629.44 0.00 23,370.56 44.10
10-100-460100 Bankcard Charges -3,900.00 -2,906.19 0.00 -993.81 25.48
R70 Fines & Forfeitures 1,009,100.00 747,888.73 0.00 261,211.27 25.89
10-100-430055 INACTIVE - DARE Contributions 0.00 0.00 0.00 0.00 0.00
10-100-480015 Sidewalk Waiver Revenue 0.00 0.00 0.00 0.00 0.00
10-100-480030 Donations-Recycling 0.00 0.00 0.00 0.00 0.00
10-100-480050 Sober Driver Program 0.00 0.00 0.00 0.00 0.00
10-100-480055 JC Fire Museum 0.00 3,226.00 0.00 -3,226.00 0.00
10-100-480063 Private Donations-Cultural Art 0.00 0.00 0.00 0.00 0.00
10-100-480065 Cultural Arts 0.00 0.00 0.00 0.00 0.00
10-100-480070 Community Projects Donations 5,891.65 5,891.65 0.00 0.00 0.00
10-100-480080 Dare Donations 0.00 500.00 0.00 -500.00 0.00
10-100-480090 Police K-9 Donations 500.00 500.00 0.00 0.00 0.00
10-100-480165 Animal S Donations 0.00 13,716.43 0.00 -13,716.43 0.00
10-100-481050 Transfer StnPlng-Sld Wst Cntr 0.00 0.00 0.00 0.00 0.00
10-100-481055 Street Repair-Solid Waste Cntr 302,250.00 252,250.00 0.00 50,000.00 16.54
10-100-481095 Cemetery Donations 0.00 0.00 0.00 0.00 0.00
10-100-486070 Cap Contr-Neighborhood Imp Pro 0.00 0.00 0.00 0.00 0.00
R72 ContributionsDonations 308,641.65 276,084.08 0.00 32,557.57 10.55
10-100-450187 Special Sn Program 0.00 0.00 0.00 0.00 0.00
10-100-450188 Adoption Voucher Program 0.00 0.00 0.00 0.00 0.00
10-100-480010 Citizen Participation 0.00 0.00 0.00 0.00 0.00
10-100-480011 Police Evidence Funds 0.00 10,457.83 0.00 -10,457.83 0.00
GL - Trial Balance by Acct Type and Full Acct Number (10/09/2017 - 8:47 AM)Page 3
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-100-481069 Utility Audit Revenue 0.00 0.00 0.00 0.00 0.00
10-100-481070 Miscellaneous 35,000.00 47,158.13 0.00 -12,158.13 -34.74
10-100-481072 TIF Developer Reimbursements 1,181.25 86,196.29 0.00 -85,015.04 -7,197.04
10-100-481074 Revenue Share 18,000.00 15,266.05 0.00 2,733.95 15.19
10-100-481077 Insurance Claims 20,000.00 11,394.51 0.00 8,605.49 43.03
10-100-481078 Cafeteria Refunds 10,000.00 0.00 0.00 10,000.00 100.00
R75 Other Operating Revenues 84,181.25 170,472.81 0.00 -86,291.56 -102.51
10-100-470010 Interest 110,000.00 162,143.36 0.00 -52,143.36 -47.40
10-100-470051 Unrealized Gainslosses 0.00 0.00 0.00 0.00 0.00
R80 Interest Income 110,000.00 162,143.36 0.00 -52,143.36 -47.40
10-100-485049 Capvhcleqp-sale Of Assets 0.00 0.00 0.00 0.00 0.00
10-100-485050 Sale Of Assets 54,000.00 96,799.50 0.00 -42,799.50 -79.26
R85 Other Non-Operating Revenue 54,000.00 96,799.50 0.00 -42,799.50 -79.26
10-100-490193 Trsfr From Grant Fund 0.00 0.00 0.00 0.00 0.00
10-100-490240 Trsfr From Lodging Tax 23,800.00 22,613.84 0.00 1,186.16 4.98
10-100-490260 Trans from Firemen's Spec Rev 0.00 0.00 0.00 0.00 0.00
10-100-490280 Trnf From Stoneridge Tdd 0.00 0.00 0.00 0.00 0.00
10-100-490320 Trans from Cap Proj-Street&PF 0.00 0.00 0.00 0.00 0.00
10-100-490353 Transfer From Cit 'e'0.00 0.00 0.00 0.00 0.00
10-100-490600 Transfer from Water Fund 0.00 0.00 0.00 0.00 0.00
10-100-490620 Transfer from Parking Fund 0.00 0.00 0.00 0.00 0.00
10-100-490630 Tran from Self-Funded Hlth Ins 0.00 0.00 0.00 0.00 0.00
R90 Transfers In 23,800.00 22,613.84 0.00 1,186.16 4.98
10-100-495995 Transfer From(to) Surplus 2,647,170.52 0.00 0.00 2,647,170.52 100.00
10-100-495996 Trnasfer From(To) Surplus 0.00 0.00 0.00 0.00 0.00
10-100-495998 Loan Proceeds 0.00 0.00 0.00 0.00 0.00
R99 Carry Over Surplus 2,647,170.52 0.00 0.00 2,647,170.52 100.00
100 Revenue 34,138,967.61 26,939,633.26 0.00 7,199,334.35 21.09
149 Entitlement Grant
10-149-430010 Federal Grants 501,904.43 92,827.57 0.00 409,076.86 81.50
10-149-430020 State Grants 0.00 0.00 0.00 0.00 0.00
10-149-430040 Local Grants 0.00 0.00 0.00 0.00 0.00
R50 Intergovernmental 501,904.43 92,827.57 0.00 409,076.86 81.50
149 Entitlement Grant 501,904.43 92,827.57 0.00 409,076.86 81.50
185 Non-Departmental
10-185-430010 Federal Grants 0.00 0.00 0.00 0.00 0.00
10-185-430020 State Grants 0.00 0.00 0.00 0.00 0.00
10-185-430040 Local Grants 0.00 0.00 0.00 0.00 0.00
R50 Intergovernmental 0.00 0.00 0.00 0.00 0.00
185 Non-Departmental 0.00 0.00 0.00 0.00 0.00
GL - Trial Balance by Acct Type and Full Acct Number (10/09/2017 - 8:47 AM)Page 4
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
300 Police Department
10-300-430010 Federal Grants 21,195.85 17,922.50 0.00 3,273.35 15.44
10-300-430020 State Grants 35,000.00 35,000.00 0.00 0.00 0.00
10-300-430040 Local Grants 0.00 150.00 0.00 -150.00 0.00
10-300-430074 Overtime Reimb 107,042.30 41,564.19 0.00 65,478.11 61.17
R50 Intergovernmental 163,238.15 94,636.69 0.00 68,601.46 42.03
300 Police Department 163,238.15 94,636.69 0.00 68,601.46 42.03
310 School Resource Officer
10-310-430010 Federal Grants 0.00 0.00 0.00 0.00 0.00
10-310-430020 State Grants 0.00 0.00 0.00 0.00 0.00
10-310-430040 Local Grants 194,541.30 211,760.22 0.00 -17,218.92 -8.85
R50 Intergovernmental 194,541.30 211,760.22 0.00 -17,218.92 -8.85
310 School Resource Officer 194,541.30 211,760.22 0.00 -17,218.92 -8.85
320 M.U.S.T.A.N.G.
10-320-430010 Federal Grants 43,462.53 13,038.20 0.00 30,424.33 70.00
10-320-430020 State Grants 0.00 0.00 0.00 0.00 0.00
10-320-430040 Local Grants 0.00 0.00 0.00 0.00 0.00
10-320-430060 Drug Forfeiture 0.00 0.00 0.00 0.00 0.00
10-320-430074 Overtime Reimb 17,753.00 9,362.48 0.00 8,390.52 47.26
R50 Intergovernmental 61,215.53 22,400.68 0.00 38,814.85 63.41
320 M.U.S.T.A.N.G.61,215.53 22,400.68 0.00 38,814.85 63.41
400 Fire Department
10-400-430010 Federal Grant 276,961.00 780.70 0.00 276,180.30 99.72
10-400-430040 Local Grants 1,200.00 1,200.00 0.00 0.00 0.00
R50 Intergovernmental 278,161.00 1,980.70 0.00 276,180.30 99.29
400 Fire Department 278,161.00 1,980.70 0.00 276,180.30 99.29
520 Plan & Protect Svcs-Admin
10-520-430040 Local Grants 0.00 0.00 0.00 0.00 0.00
R50 Intergovernmental 0.00 0.00 0.00 0.00 0.00
520 Plan & Protect Svcs-Admin 0.00 0.00 0.00 0.00 0.00
522 Plan & Protect Svcs-MPO
10-522-430010 Federal Grants 376,825.72 144,042.43 0.00 232,783.29 61.77
10-522-430020 State Grants 0.00 0.00 0.00 0.00 0.00
10-522-430040 Local Grants 20,064.70 2,381.68 0.00 17,683.02 88.13
R50 Intergovernmental 396,890.42 146,424.11 0.00 250,466.31 63.11
522 Plan & Protect Svcs-MPO 396,890.42 146,424.11 0.00 250,466.31 63.11
GL - Trial Balance by Acct Type and Full Acct Number (10/09/2017 - 8:47 AM)Page 5
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
530 Plan & Protect Svc-RedevGrant
10-530-430010 Federal Grants 48,480.00 48,950.00 0.00 -470.00 -0.97
10-530-430020 State Grants 0.00 0.00 0.00 0.00 0.00
10-530-430040 Local Grants 20,500.00 29,331.25 0.00 -8,831.25 -43.08
R50 Intergovernmental 68,980.00 78,281.25 0.00 -9,301.25 -13.48
530 Plan & Protect Svc-RedevGrant 68,980.00 78,281.25 0.00 -9,301.25 -13.48
532 Plan & Protect Svcs-Env Health
10-532-430010 Federal Grants 0.00 0.00 0.00 0.00 0.00
10-532-430020 State Grants 0.00 0.00 0.00 0.00 0.00
10-532-430040 Local Grants 0.00 0.00 0.00 0.00 0.00
R50 Intergovernmental 0.00 0.00 0.00 0.00 0.00
532 Plan & Protect Svcs-Env Health 0.00 0.00 0.00 0.00 0.00
990 Capital Projects
10-990-430010 Federal Grants 893,468.52 420,024.81 0.00 473,443.71 52.99
10-990-430020 State Grants 0.00 0.00 0.00 0.00 0.00
10-990-430040 Local Grants 0.00 14,870.99 0.00 -14,870.99 0.00
R50 Intergovernmental 893,468.52 434,895.80 0.00 458,572.72 51.33
990 Capital Projects 893,468.52 434,895.80 0.00 458,572.72 51.33
Revenue Revenue 36,697,366.96 28,022,840.28 0.00 8,674,526.68 23.64
Expense Expense
110 Mayor & Council
10-110-501010 Salary-Elected Officials 64,800.00 58,950.00 0.00 5,850.00 9.03
10-110-501020 Salaries 0.00 0.00 0.00 0.00 0.00
10-110-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00
10-110-502010 Social Security 4,957.20 4,200.34 0.00 756.86 15.27
10-110-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00
10-110-502040 Workers Compensation 37.47 37.47 0.00 0.00 0.00
E05 Personnel Services 69,794.67 63,187.81 0.00 6,606.86 9.47
10-110-511010 Advertising 0.00 0.00 0.00 0.00 0.00
10-110-511020 Postage 100.00 10.63 0.00 89.37 89.37
10-110-512010 Printing 697.00 697.00 0.00 0.00 0.00
10-110-512020 Copies 200.00 0.07 0.00 199.93 99.97
10-110-513010 Office Supplies 684.00 778.58 0.00 -94.58 -13.83
10-110-514040 Food 0.00 0.00 0.00 0.00 0.00
E10 Materials & Supplies 1,681.00 1,486.28 0.00 194.72 11.58
10-110-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00
10-110-520025 Security 1,500.00 665.08 0.00 834.92 55.66
10-110-520030 Dues And Publications 5,000.00 4,707.90 0.00 292.10 5.84
10-110-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-110-520070 Training & Education 892.00 310.00 0.00 582.00 65.25
GL - Trial Balance by Acct Type and Full Acct Number (10/09/2017 - 8:47 AM)Page 6
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-110-522020 Professional Services 100.00 300.00 0.00 -200.00 -200.00
10-110-529010 Special Events 0.00 0.00 0.00 0.00 0.00
E15 Contractual Services 7,492.00 5,982.98 0.00 1,509.02 20.14
10-110-534010 Telephone 0.00 0.00 0.00 0.00 0.00
E20 Utilities 0.00 0.00 0.00 0.00 0.00
10-110-547020 Maintenance Agreements 75.00 89.16 0.00 -14.16 -18.88
E25 Repairs & Maintenance 75.00 89.16 0.00 -14.16 -18.88
10-110-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00
110 Mayor & Council 79,042.67 70,746.23 0.00 8,296.44 10.50
120 City Clerk
10-120-501020 Salaries 66,131.70 50,788.83 0.00 15,342.87 23.20
10-120-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00
10-120-501090 Overtime 0.00 0.00 0.00 0.00 0.00
10-120-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00
10-120-502010 Social Security 5,059.07 3,698.88 0.00 1,360.19 26.89
10-120-502020 Group Health Insurance 4,427.58 10,268.34 0.00 -5,840.76 -131.92
10-120-502030 Retirement 9,787.50 7,516.73 0.00 2,270.77 23.20
10-120-502040 Workers Compensation 33.57 33.57 0.00 0.00 0.00
10-120-502050 Life Insurance 129.25 57.60 0.00 71.65 55.44
10-120-502060 Long Term Disability 203.17 166.27 0.00 36.90 18.16
10-120-502070 Employee Assistance Prgm 34.84 32.36 0.00 2.48 7.12
E05 Personnel Services 85,806.68 72,562.58 0.00 13,244.10 15.43
10-120-511020 Postage 200.00 214.27 0.00 -14.27 -7.14
10-120-512010 Printing 0.00 0.00 0.00 0.00 0.00
10-120-512020 Copies 300.00 243.27 0.00 56.73 18.91
10-120-513010 Office Supplies 500.00 478.68 0.00 21.32 4.26
E10 Materials & Supplies 1,000.00 936.22 0.00 63.78 6.38
10-120-520030 Dues And Publications 275.00 114.98 0.00 160.02 58.19
10-120-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-120-520070 Training And Education 1,000.00 36.00 0.00 964.00 96.40
10-120-522020 Professional Services 1,109.64 829.64 0.00 280.00 25.23
10-120-529030 Election Expense 30,000.00 17,618.30 0.00 12,381.70 41.27
E15 Contractual Services 32,384.64 18,598.92 0.00 13,785.72 42.57
10-120-534010 Telephone 0.00 0.00 0.00 0.00 0.00
E20 Utilities 0.00 0.00 0.00 0.00 0.00
10-120-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00
10-120-547020 Maintenance Agreements 295.00 295.76 0.00 -0.76 -0.26
E25 Repairs & Maintenance 295.00 295.76 0.00 -0.76 -0.26
GL - Trial Balance by Acct Type and Full Acct Number (10/09/2017 - 8:47 AM)Page 7
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-120-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00
120 City Clerk 119,486.32 92,393.48 0.00 27,092.84 22.67
140 City Administrator
10-140-501020 Salaries 209,190.37 188,609.03 0.00 20,581.34 9.84
10-140-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00
10-140-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00
10-140-501090 Overtime 0.00 0.00 0.00 0.00 0.00
10-140-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00
10-140-502010 Social Security 16,673.14 12,290.50 0.00 4,382.64 26.29
10-140-502020 Group Health Insurance 20,053.89 20,310.13 0.00 -256.24 -1.28
10-140-502030 Retirement 33,467.42 24,995.77 0.00 8,471.65 25.31
10-140-502040 Workers Compensation 85.32 85.32 0.00 0.00 0.00
10-140-502050 Life Insurance 199.76 121.33 0.00 78.43 39.26
10-140-502060 Long Term Disability 412.24 266.04 0.00 146.20 35.46
10-140-502070 Employee Assistance Prgm 52.39 48.64 0.00 3.75 7.16
E05 Personnel Services 280,134.53 246,726.76 0.00 33,407.77 11.93
10-140-511010 Advertising 500.00 0.00 0.00 500.00 100.00
10-140-511020 Postage 250.00 94.58 0.00 155.42 62.17
10-140-512010 Printing 200.00 106.00 0.00 94.00 47.00
10-140-512020 Copies 250.00 103.92 0.00 146.08 58.43
10-140-513010 Office Supplies 850.00 487.07 0.00 362.93 42.70
10-140-517010 Operational Supplies 727.00 485.00 0.00 242.00 33.29
E10 Materials & Supplies 2,777.00 1,276.57 0.00 1,500.43 54.03
10-140-520030 Dues And Publications 1,800.00 508.70 0.00 1,291.30 71.74
10-140-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-140-520070 Training And Education 3,000.00 2,540.00 0.00 460.00 15.33
10-140-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00
10-140-520090 Recruitment 0.00 0.00 0.00 0.00 0.00
10-140-520095 Relocation Fees 0.00 0.00 0.00 0.00 0.00
10-140-522020 Professional Services 800.00 188.16 0.00 611.84 76.48
E15 Contractual Services 5,600.00 3,236.86 0.00 2,363.14 42.20
10-140-534010 Telephone 0.00 0.00 0.00 0.00 0.00
E20 Utilities 0.00 0.00 0.00 0.00 0.00
10-140-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00
10-140-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00
10-140-547020 Maintenance Agreements 220.00 231.99 0.00 -11.99 -5.45
E25 Repairs & Maintenance 220.00 231.99 0.00 -11.99 -5.45
10-140-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00
140 City Administrator 288,731.53 251,472.18 0.00 37,259.35 12.90
GL - Trial Balance by Acct Type and Full Acct Number (10/09/2017 - 8:47 AM)Page 8
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
149 Entitlement Grant
10-149-501020 Salaries 38,624.05 20,511.82 0.00 18,112.23 46.89
10-149-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00
10-149-502010 Social Security 3,072.52 1,472.12 0.00 1,600.40 52.09
10-149-502020 Group Health Insurance 4,778.10 5,340.36 0.00 -562.26 -11.77
10-149-502030 Retirement 2,984.22 2,013.01 0.00 971.21 32.54
10-149-502040 Workers Compensation 30.00 0.00 0.00 30.00 100.00
10-149-502050 Life Insurance 37.21 31.39 0.00 5.82 15.64
10-149-502060 Long Term Disability 58.75 65.31 0.00 -6.56 -11.17
10-149-502070 Employee Assistance Program 13.10 12.16 0.00 0.94 7.18
E05 Personnel Services 49,597.95 29,446.17 0.00 20,151.78 40.63
10-149-511010 Advertising 1,499.93 1,230.25 0.00 269.68 17.98
10-149-511020 Postage 500.00 221.53 0.00 278.47 55.69
10-149-512020 Copies 0.07 0.07 0.00 0.00 0.00
10-149-513010 Office Supplies 1,000.00 269.67 0.00 730.33 73.03
10-149-517010 Operational Supplies 525.00 67.94 0.00 457.06 87.06
E10 Materials & Supplies 3,525.00 1,789.46 0.00 1,735.54 49.24
10-149-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-149-520070 Training And Education 5,776.46 5,432.67 0.00 343.79 5.95
10-149-522020 Professional Services 0.00 0.00 0.00 0.00 0.00
10-149-528010 Housing Rehabilitation 0.00 0.00 0.00 0.00 0.00
10-149-528011 Housing Rehab-Code Deficiency 40,198.00 9,493.00 0.00 30,705.00 76.38
10-149-528012 Housing Rehab-Energy Efficienc 30,198.00 4,996.00 0.00 25,202.00 83.46
10-149-528020 Housing Assistance 25,540.00 20,392.00 0.00 5,148.00 20.16
10-149-528030 Public Improvement 66,300.72 0.00 0.00 66,300.72 100.00
10-149-528040 Neighborhood Redevelopmnt 111,223.54 18,733.00 0.00 92,490.54 83.16
10-149-528050 Neighborhood Facility 0.00 0.00 0.00 0.00 0.00
10-149-528060 Economic Development 0.00 0.00 0.00 0.00 0.00
10-149-528070 Emergency Assistance 5,000.00 0.00 0.00 5,000.00 100.00
10-149-528080 Homeless Objectives 35,133.47 10,200.16 0.00 24,933.31 70.97
E15 Contractual Services 319,370.19 69,246.83 0.00 250,123.36 78.32
10-149-547020 Maintenance Agreements 350.00 224.59 8.48 116.93 33.41
E25 Repairs & Maintenance 350.00 224.59 8.48 116.93 33.41
10-149-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00
10-149-577045 Clay Street Plaza 0.00 0.00 0.00 0.00 0.00
10-149-577055 Marshall & Roland Sidewalk 0.00 0.00 0.00 0.00 0.00
10-149-577064 Broadway St Sidewalk 130,365.00 118,378.55 11,986.45 0.00 0.00
E75 Capital Projects 130,365.00 118,378.55 11,986.45 0.00 0.00
149 Entitlement Grant 503,208.14 219,085.60 11,994.93 272,127.61 54.08
150 City Counselor
GL - Trial Balance by Acct Type and Full Acct Number (10/09/2017 - 8:47 AM)Page 9
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-150-501020 Salaries 228,300.53 225,505.55 0.00 2,794.98 1.22
10-150-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00
10-150-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00
10-150-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00
10-150-501090 Overtime 0.00 0.00 0.00 0.00 0.00
10-150-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00
10-150-502010 Social Security 17,464.99 16,497.68 0.00 967.31 5.54
10-150-502020 Group Health Insurance 38,273.07 39,985.73 0.00 -1,712.66 -4.47
10-150-502030 Retirement 33,788.48 33,374.72 0.00 413.76 1.22
10-150-502040 Workers Compensation 160.76 160.76 0.00 0.00 0.00
10-150-502050 Life Insurance 444.56 342.56 0.00 102.00 22.94
10-150-502060 Long Term Disability 635.04 664.99 0.00 -29.95 -4.72
10-150-502070 Employee Assistance Prgm 87.49 81.24 0.00 6.25 7.14
10-150-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 319,154.92 316,613.23 0.00 2,541.69 0.80
10-150-511010 Advertising 0.00 0.00 0.00 0.00 0.00
10-150-511020 Postage 600.00 388.07 0.00 211.93 35.32
10-150-512010 Printing 150.00 0.00 0.00 150.00 100.00
10-150-512020 Copies 300.00 2.50 0.00 297.50 99.17
10-150-513010 Office Supplies 1,800.00 1,047.39 0.00 752.61 41.81
10-150-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00
E10 Materials & Supplies 2,850.00 1,437.96 0.00 1,412.04 49.55
10-150-520020 Auditing Travel Expense 0.00 0.00 0.00 0.00 0.00
10-150-520030 Dues And Publications 11,000.00 6,919.65 1,848.00 2,232.35 20.29
10-150-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-150-520070 Training And Education 6,000.00 2,428.12 0.00 3,571.88 59.53
10-150-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00
10-150-520095 Relocation Fees 0.00 0.00 0.00 0.00 0.00
10-150-521010 Malpractice Insurance 1,000.00 0.00 0.00 1,000.00 100.00
10-150-522020 Professional Services 44,150.00 24,647.90 0.00 19,502.10 44.17
10-150-525030 Court Cost & Witness Fees 75.00 11.25 0.00 63.75 85.00
E15 Contractual Services 62,225.00 34,006.92 1,848.00 26,370.08 42.38
10-150-534010 Telephone 0.00 0.00 0.00 0.00 0.00
E20 Utilities 0.00 0.00 0.00 0.00 0.00
10-150-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00
10-150-547020 Maintenance Agreements 625.00 499.93 0.00 125.07 20.01
E25 Repairs & Maintenance 625.00 499.93 0.00 125.07 20.01
10-150-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
10-150-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00
150 City Counselor 384,854.92 352,558.04 1,848.00 30,448.88 7.91
160 Municipal Court
GL - Trial Balance by Acct Type and Full Acct Number (10/09/2017 - 8:47 AM)Page 10
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-160-501010 Salary-elected Officals 59,999.88 59,583.26 0.00 416.62 0.69
10-160-501020 Salaries 101,707.05 47,738.79 0.00 53,968.26 53.06
10-160-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00
10-160-501050 Parttime(wo Benefits)17,068.99 4,701.75 0.00 12,367.24 72.45
10-160-501090 Overtime 3,000.00 2,069.54 0.00 930.46 31.02
10-160-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00
10-160-502010 Social Security 13,905.85 8,386.55 0.00 5,519.30 39.69
10-160-502020 Group Health Insurance 20,227.17 9,134.10 0.00 11,093.07 54.84
10-160-502030 Retirement 15,496.64 6,049.90 0.00 9,446.74 60.96
10-160-502040 Workers Compensation 106.42 106.42 0.00 0.00 0.00
10-160-502050 Life Insurance 199.76 59.46 0.00 140.30 70.23
10-160-502060 Long Term Disability 312.11 122.33 0.00 189.78 60.81
10-160-502070 Employee Assistance Prgm 61.03 56.64 0.00 4.39 7.19
E05 Personnel Services 232,084.90 138,008.74 0.00 94,076.16 40.54
10-160-511010 Advertising 0.00 0.00 0.00 0.00 0.00
10-160-511020 Postage 3,800.00 3,026.01 0.00 773.99 20.37
10-160-512010 Printing 1,090.00 270.00 0.00 820.00 75.23
10-160-512020 Copies 500.00 178.99 0.00 321.01 64.20
10-160-513010 Office Supplies 3,500.00 2,392.22 0.00 1,107.78 31.65
E10 Materials & Supplies 8,890.00 5,867.22 0.00 3,022.78 34.00
10-160-520025 Security 7,000.00 9,590.35 -3,036.21 445.86 6.37
10-160-520030 Dues And Publications 450.00 60.00 0.00 390.00 86.67
10-160-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-160-520070 Training And Education 2,500.00 780.84 0.00 1,719.16 68.77
10-160-522020 Professional Services 4,500.00 4,400.02 0.00 99.98 2.22
10-160-525005 Appointed Counsel 7,000.00 3,872.50 0.00 3,127.50 44.68
10-160-525010 Care Of Prisoners 2,000.00 0.00 0.00 2,000.00 100.00
10-160-525030 Court Cost & Witness Fees 40.00 0.00 0.00 40.00 100.00
E15 Contractual Services 23,490.00 18,703.71 -3,036.21 7,822.50 33.30
10-160-534010 Telephone 0.00 0.00 0.00 0.00 0.00
E20 Utilities 0.00 0.00 0.00 0.00 0.00
10-160-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00
10-160-547020 Maintenance Agreements 730.00 960.89 0.00 -230.89 -31.63
E25 Repairs & Maintenance 730.00 960.89 0.00 -230.89 -31.63
10-160-572020 Purchase Of Equipment 5,563.24 689.06 5,563.24 -689.06 -12.39
10-160-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 5,563.24 689.06 5,563.24 -689.06 -12.39
160 Municipal Court 270,758.14 164,229.62 2,527.03 104,001.49 38.41
170 Human Resources
10-170-501020 Salaries 194,985.36 174,785.23 0.00 20,200.13 10.36
10-170-501050 Parttime(wo Benefits)38,932.80 25,923.24 0.00 13,009.56 33.42
10-170-501090 Overtime 300.00 111.60 0.00 188.40 62.80
GL - Trial Balance by Acct Type and Full Acct Number (10/09/2017 - 8:47 AM)Page 11
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-170-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00
10-170-502010 Social Security 17,917.69 15,269.03 0.00 2,648.66 14.78
10-170-502020 Group Health Insurance 19,329.42 16,714.13 0.00 2,615.29 13.53
10-170-502030 Retirement 28,902.24 25,884.76 0.00 3,017.48 10.44
10-170-502040 Workers Compensation 94.53 94.53 0.00 0.00 0.00
10-170-502050 Life Insurance 370.14 268.74 0.00 101.40 27.40
10-170-502060 Long Term Disability 521.91 497.87 0.00 24.04 4.61
10-170-502070 Employee Assistance Prgm 78.58 72.96 0.00 5.62 7.15
10-170-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 301,432.67 259,622.09 0.00 41,810.58 13.87
10-170-511010 Advertising 150.00 49.00 0.00 101.00 67.33
10-170-511020 Postage 300.00 104.08 0.00 195.92 65.31
10-170-512010 Printing 1,000.00 0.00 0.00 1,000.00 100.00
10-170-512020 Copies 500.00 505.08 0.00 -5.08 -1.02
10-170-513010 Office Supplies 1,200.00 1,003.03 0.00 196.97 16.41
10-170-517010 Operational Supplies 750.00 662.70 0.00 87.30 11.64
E10 Materials & Supplies 3,900.00 2,323.89 0.00 1,576.11 40.41
10-170-520030 Dues And Publications 1,468.00 32.05 0.00 1,435.95 97.82
10-170-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-170-520060 Wellness Program 3,500.00 1,720.55 0.00 1,779.45 50.84
10-170-520070 Training And Education 5,220.00 3,613.24 0.00 1,606.76 30.78
10-170-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00
10-170-521060 Drugalcohol Screening 0.00 0.00 0.00 0.00 0.00
10-170-521065 Background Checks 940.00 792.25 0.00 147.75 15.72
10-170-522020 Professional Services 2,000.00 3,650.92 0.00 -1,650.92 -82.55
10-170-529010 Special Events 1,000.00 50.56 0.00 949.44 94.94
10-170-529015 Human Rights Commission 0.00 0.00 0.00 0.00 0.00
E15 Contractual Services 14,128.00 9,859.57 0.00 4,268.43 30.21
10-170-534010 Telephone 0.00 0.00 0.00 0.00 0.00
E20 Utilities 0.00 0.00 0.00 0.00 0.00
10-170-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00
10-170-547020 Maintenance Agreements 220.00 227.92 0.00 -7.92 -3.60
E25 Repairs & Maintenance 220.00 227.92 0.00 -7.92 -3.60
10-170-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00
170 Human Resources 319,680.67 272,033.47 0.00 47,647.20 14.90
180 Finance Department
10-180-501020 Salaries 622,105.16 543,611.09 0.00 78,494.07 12.62
10-180-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00
10-180-501050 Parttime(wo Benefits)4,362.72 4,362.72 0.00 0.00 0.00
10-180-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00
10-180-501090 Overtime 0.00 0.00 0.00 0.00 0.00
GL - Trial Balance by Acct Type and Full Acct Number (10/09/2017 - 8:47 AM)Page 12
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-180-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00
10-180-502010 Social Security 47,924.80 40,701.38 0.00 7,223.42 15.07
10-180-502020 Group Health Insurance 74,853.57 65,733.38 0.00 9,120.19 12.18
10-180-502030 Retirement 92,071.56 76,968.32 0.00 15,103.24 16.40
10-180-502040 Workers Compensation 531.10 531.10 0.00 0.00 0.00
10-180-502050 Life Insurance 1,212.25 859.99 0.00 352.26 29.06
10-180-502060 Long Term Disability 1,788.94 1,725.31 0.00 63.63 3.56
10-180-502070 Employee Assistance Prgm 307.77 285.64 0.00 22.13 7.19
E05 Personnel Services 845,157.87 734,778.93 0.00 110,378.94 13.06
10-180-511010 Advertising 1,000.00 533.18 0.00 466.82 46.68
10-180-511020 Postage 9,500.00 8,035.78 0.00 1,464.22 15.41
10-180-511021 Mail Machine Cost 2,500.00 2,319.11 0.00 180.89 7.24
10-180-512010 Printing 4,000.00 2,804.95 484.90 710.15 17.75
10-180-512020 Copies 2,500.00 1,237.58 0.00 1,262.42 50.50
10-180-512021 Copy Machine Cost 1,000.00 -610.22 35.10 1,575.12 157.51
10-180-513010 Office Supplies 4,000.00 6,569.26 0.00 -2,569.26 -64.23
10-180-517010 Operational Supplies 5,500.00 1,017.62 0.00 4,482.38 81.50
E10 Materials & Supplies 30,000.00 21,907.26 520.00 7,572.74 25.24
10-180-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00
10-180-520020 Auditing Travel Expenses 0.00 0.00 0.00 0.00 0.00
10-180-520030 Dues And Publications 2,300.00 1,805.00 0.00 495.00 21.52
10-180-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-180-520070 Training And Education 11,000.00 2,703.44 0.00 8,296.56 75.42
10-180-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00
10-180-522010 Audit 31,595.00 26,883.28 0.00 4,711.72 14.91
10-180-522015 Budget Expense 0.00 0.00 0.00 0.00 0.00
10-180-522020 Professional Services 500.00 11.48 0.00 488.52 97.70
E15 Contractual Services 45,395.00 31,403.20 0.00 13,991.80 30.82
10-180-534010 Telephone 0.00 0.00 0.00 0.00 0.00
E20 Utilities 0.00 0.00 0.00 0.00 0.00
10-180-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00
10-180-547020 Maintenance Agreements 1,000.00 954.46 0.00 45.54 4.55
E25 Repairs & Maintenance 1,000.00 954.46 0.00 45.54 4.55
10-180-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00
180 Finance Department 921,552.87 789,043.85 520.00 131,989.02 14.32
185 Non-Departmental
10-185-501020 Salaries 12,571.99 0.00 0.00 12,571.99 100.00
10-185-501021 Vacancy Savings 0.00 0.00 0.00 0.00 0.00
10-185-501022 Separation Incentive Prog Svgs 0.00 0.00 0.00 0.00 0.00
10-185-502020 Group Health Insurance 0.00 21,469.40 0.00 -21,469.40 0.00
10-185-502021 Self Insurance-Group Health 0.00 0.00 0.00 0.00 0.00
GL - Trial Balance by Acct Type and Full Acct Number (10/09/2017 - 8:47 AM)Page 13
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-185-502022 Wellness Assessment 11,221.68 19,635.00 0.00 -8,413.32 -74.97
10-185-502023 Self Insurance-Retirees 0.00 0.00 0.00 0.00 0.00
10-185-503010 Awards Program 0.00 0.00 0.00 0.00 0.00
10-185-504010 Employee Salary Guarantee Fund 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 23,793.67 41,104.40 0.00 -17,310.73 -72.75
10-185-514010 Gas 12,000.00 8,013.70 0.00 3,986.30 33.22
10-185-514011 Gas Oil & Antifreeze 0.00 0.00 0.00 0.00 0.00
10-185-514012 Gas, Oil, Antifreeze ALLOCATE 0.00 0.00 0.00 0.00 0.00
E10 Materials & Supplies 12,000.00 8,013.70 0.00 3,986.30 33.22
10-185-520030 Dues and Publications 0.00 0.00 0.00 0.00 0.00
10-185-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00
10-185-521010 General Insurance 315,582.72 285,403.10 0.00 30,179.62 9.56
10-185-521020 Insurance Deductible 15,000.00 22,476.52 0.00 -7,476.52 -49.84
10-185-521030 Self Ins Prop & Casualty 75,000.00 9,271.71 0.00 65,728.29 87.64
10-185-521060 Drugalcohol screening 5,364.00 2,057.25 0.00 3,306.75 61.65
10-185-521070 Prov For Unsettled Claims 0.00 0.00 0.00 0.00 0.00
10-185-522015 TIF Prof Svcs 1,181.25 67,538.79 0.00 -66,357.54 -5,617.57
10-185-522020 Professional Services 172,600.00 124,999.96 0.00 47,600.04 27.58
10-185-522025 JCTV 55,000.00 55,000.00 0.00 0.00 0.00
10-185-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00
10-185-526030 Assessment Charge 45,750.00 45,892.00 0.00 -142.00 -0.31
10-185-527020 Economic Development 185,000.00 185,000.00 46,250.00 -46,250.00 -25.00
10-185-529010 Special Events 7,000.00 20,688.86 0.00 -13,688.86 -195.56
E15 Contractual Services 877,477.97 818,328.19 46,250.00 12,899.78 1.47
10-185-531010 Electricity 42,000.00 30,025.06 0.00 11,974.94 28.51
10-185-533010 Natural Gas 6,400.00 3,861.72 0.00 2,538.28 39.66
10-185-535010 Water 7,250.00 5,798.01 0.00 1,451.99 20.03
10-185-535020 Downtown Irrigation 0.00 0.00 0.00 0.00 0.00
E20 Utilities 55,650.00 39,684.79 0.00 15,965.21 28.69
10-185-540010 Building & Grounds Maint.65,040.00 33,372.59 19,900.00 11,767.41 18.09
10-185-540020 Tree & Landscape Maint 25,000.00 25,000.00 0.00 0.00 0.00
10-185-547020 Maintenance Agreements 2,100.00 1,560.79 0.00 539.21 25.68
E25 Repairs & Maintenance 92,140.00 59,933.38 19,900.00 12,306.62 13.36
10-185-550010 Miscellaneous 9,290.36 2,233.00 0.00 7,057.36 75.96
10-185-550015 Bad Debt Expense 0.00 2,403.00 0.00 -2,403.00 0.00
10-185-550020 Neighborhood Reinvestment 0.00 0.00 0.00 0.00 0.00
10-185-550025 Contingency 0.00 0.00 0.00 0.00 0.00
10-185-550026 Addt'l PositionsEquipment 20,754.89 12,625.38 0.00 8,129.51 39.17
10-185-550030 Old Town Projects 0.00 0.00 0.00 0.00 0.00
10-185-550035 Old Town Redev Committee 0.00 0.00 0.00 0.00 0.00
10-185-550036 Salute to America 10,000.00 10,000.00 0.00 0.00 0.00
10-185-550037 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00
10-185-550038 Civil War Reenactment Comm 0.00 0.00 0.00 0.00 0.00
10-185-550040 Public Art 9,665.00 2,000.00 0.00 7,665.00 79.31
GL - Trial Balance by Acct Type and Full Acct Number (10/09/2017 - 8:47 AM)Page 14
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-185-550041 ALPLA Settlement 0.00 0.00 0.00 0.00 0.00
10-185-550042 Jefferson Day Celebration 0.00 0.00 0.00 0.00 0.00
10-185-550043 JC Fire Museum 0.00 2,041.54 0.00 -2,041.54 0.00
10-185-550045 Conference Center 0.00 0.00 0.00 0.00 0.00
10-185-550050 Neighb Stablization Prog 0.00 0.00 0.00 0.00 0.00
10-185-550060 MSP 20,000.00 0.00 0.00 20,000.00 100.00
10-185-550070 Energy Grant Expenditures 0.00 0.00 0.00 0.00 0.00
10-185-550080 Neighborhd Improvement Progr 0.00 0.00 0.00 0.00 0.00
10-185-550090 Hazard Mitigation 0.00 0.00 0.00 0.00 0.00
E30 Other Operating Expenses 69,710.25 31,302.92 0.00 38,407.33 55.10
10-185-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
10-185-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00
10-185-578073 Council Infrastructure Proj 0.00 0.00 0.00 0.00 0.00
E75 Capital Projects 0.00 0.00 0.00 0.00 0.00
10-185-580080 Note Principal 0.00 0.00 0.00 0.00 0.00
10-185-580090 Note Interest 0.00 0.00 0.00 0.00 0.00
E90 Debt Service 0.00 0.00 0.00 0.00 0.00
185 Non-Departmental 1,130,771.89 998,367.38 66,150.00 66,254.51 5.86
190 I.T. Department
10-190-501020 Salaries 531,187.69 465,964.79 0.00 65,222.90 12.28
10-190-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00
10-190-501050 Parttime(wo benefits)0.00 0.00 0.00 0.00 0.00
10-190-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00
10-190-501090 Overtime 1,200.00 0.00 0.00 1,200.00 100.00
10-190-501095 Overtime Straight Pay 0.00 50.57 0.00 -50.57 0.00
10-190-502010 Social Security 40,727.66 33,917.24 0.00 6,810.42 16.72
10-190-502020 Group Health Insurance 75,335.92 64,906.51 0.00 10,429.41 13.84
10-190-502030 Retirement 78,793.38 56,869.33 0.00 21,924.05 27.82
10-190-502040 Workers Compensation 357.11 357.11 0.00 0.00 0.00
10-190-502050 Life Insurance 1,026.20 702.29 0.00 323.91 31.56
10-190-502060 Long Term Disability 1,575.82 1,445.62 0.00 130.20 8.26
10-190-502070 Employee Assistance Prgm 248.84 231.00 0.00 17.84 7.17
E05 Personnel Services 730,452.62 624,444.46 0.00 106,008.16 14.51
10-190-511010 Advertising 1,646.00 1,632.40 0.00 13.60 0.83
10-190-511020 Postage 116.11 116.11 0.00 0.00 0.00
10-190-512010 Printing 0.00 0.00 0.00 0.00 0.00
10-190-512020 Copies 83.89 28.41 0.00 55.48 66.13
10-190-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00
10-190-513010 Office Supplies 1,000.00 496.76 0.00 503.24 50.32
10-190-514030 Small Tools 0.00 0.00 0.00 0.00 0.00
10-190-514040 Food 150.00 60.27 0.00 89.73 59.82
10-190-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00
GL - Trial Balance by Acct Type and Full Acct Number (10/09/2017 - 8:47 AM)Page 15
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-190-517010 Operational Supplies 3,651.00 2,418.63 0.00 1,232.37 33.75
E10 Materials & Supplies 6,647.00 4,752.58 0.00 1,894.42 28.50
10-190-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00
10-190-520030 Dues And Publications 99.00 99.00 0.00 0.00 0.00
10-190-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-190-520070 Training And Education 14,500.00 11,996.10 0.00 2,503.90 17.27
10-190-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00
10-190-522020 Professional Services 1,500.00 1,006.26 0.00 493.74 32.92
10-190-522030 Services - Prof Training 0.00 0.00 0.00 0.00 0.00
10-190-522040 Service-internet T1 Web 15,154.00 14,156.30 0.00 997.70 6.58
10-190-522050 Service-remote Locations 0.00 0.00 0.00 0.00 0.00
10-190-522060 City Web Site 4,400.00 4,377.99 0.00 22.01 0.50
E15 Contractual Services 35,653.00 31,635.65 0.00 4,017.35 11.27
10-190-534010 Telephone 52,200.00 47,067.42 0.00 5,132.58 9.83
E20 Utilities 52,200.00 47,067.42 0.00 5,132.58 9.83
10-190-545010 Software Licensemaint 130,000.00 127,471.47 1,539.00 989.53 0.76
10-190-545020 Citywide Wiringnetwork 300.00 7.90 0.00 292.10 97.37
10-190-547010 Equipment Maintenance 713.81 713.81 0.00 0.00 0.00
10-190-547020 Maintenance Agreements 15,976.62 7,293.13 8,683.49 0.00 0.00
E25 Repairs & Maintenance 146,990.43 135,486.31 10,222.49 1,281.63 0.87
10-190-572020 Purchase Of Equipment 39,709.57 114.99 0.00 39,594.58 99.71
E70 Capital Purchases 39,709.57 114.99 0.00 39,594.58 99.71
190 I.T. Department 1,011,652.62 843,501.41 10,222.49 157,928.72 15.61
300 Police Department
10-300-501020 Salaries 4,263,295.67 3,779,737.86 0.00 483,557.81 11.34
10-300-501030 Holiday Pay 131,844.61 114,094.57 0.00 17,750.04 13.46
10-300-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00
10-300-501050 Parttime(wo Benefits)61,845.64 48,362.32 0.00 13,483.32 21.80
10-300-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00
10-300-501070 Stand-by Plan 4,000.00 3,852.00 0.00 148.00 3.70
10-300-501090 Overtime 287,885.80 279,262.10 0.00 8,623.70 3.00
10-300-501095 Overtime Straight Pay 7,000.00 11,456.87 0.00 -4,456.87 -63.67
10-300-502010 Social Security 355,601.71 307,774.39 0.00 47,827.32 13.45
10-300-502020 Group Health Insurance 757,648.99 652,699.51 0.00 104,949.48 13.85
10-300-502030 Retirement 829,580.25 739,835.39 0.00 89,744.86 10.82
10-300-502040 Workers Compensation 39,409.96 39,409.96 0.00 0.00 0.00
10-300-502050 Life Insurance 8,521.00 5,888.13 0.00 2,632.87 30.90
10-300-502060 Long Term Disability 12,725.99 12,126.47 0.00 599.52 4.71
10-300-502070 Employee Assistance Prgm 2,396.71 2,225.00 0.00 171.71 7.16
10-300-503010 Awards Program 1,600.00 0.00 0.00 1,600.00 100.00
10-300-503020 Unemployment Compensation 1,000.00 0.00 0.00 1,000.00 100.00
E05 Personnel Services 6,764,356.33 5,996,724.57 0.00 767,631.76 11.35
GL - Trial Balance by Acct Type and Full Acct Number (10/09/2017 - 8:47 AM)Page 16
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-300-511010 Advertising 1,026.00 1,711.83 0.00 -685.83 -66.85
10-300-511020 Postage 1,500.00 1,290.58 0.00 209.42 13.96
10-300-512010 Printing 5,500.00 5,703.91 0.00 -203.91 -3.71
10-300-512020 Copies 55.03 0.00 0.00 55.03 100.00
10-300-512030 Photographic Supplies 2,000.00 1,071.00 0.00 929.00 46.45
10-300-513010 Office Supplies 14,474.00 16,230.04 0.00 -1,756.04 -12.13
10-300-514010 Gas 140,000.00 123,918.15 0.00 16,081.85 11.49
10-300-514040 Food 700.00 741.84 0.00 -41.84 -5.98
10-300-515040 First Aid Supplies 1,000.00 1,108.15 0.00 -108.15 -10.82
10-300-516010 Ammunition & Firearms Supplies 26,300.00 25,035.82 9,180.00 -7,915.82 -30.10
10-300-516020 Dare Program 16,500.00 12,654.46 0.00 3,845.54 23.31
10-300-516030 Special Investigation 2,500.00 0.00 0.00 2,500.00 100.00
10-300-516040 Investigations (Grant)0.00 0.00 0.00 0.00 0.00
10-300-516050 Community Projects 5,936.62 5,583.22 0.00 353.40 5.95
10-300-517010 Operational Supplies 48,075.00 47,321.34 315.46 438.20 0.91
E10 Materials & Supplies 265,566.65 242,370.34 9,495.46 13,700.85 5.16
10-300-520030 Dues And Publications 4,220.00 4,211.90 0.00 8.10 0.19
10-300-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-300-520070 Training And Education 58,030.85 53,151.82 0.00 4,879.03 8.41
10-300-520080 Tuition Reimbursement 9,180.00 11,267.00 0.00 -2,087.00 -22.73
10-300-520090 Recruitment 1,400.00 1,382.17 0.00 17.83 1.27
10-300-521040 Medical Claimsservices 5,000.00 4,403.15 0.00 596.85 11.94
10-300-521050 Medical Services 0.00 0.00 0.00 0.00 0.00
10-300-522020 Professional Services 12,200.00 12,197.50 0.00 2.50 0.02
10-300-522026 Drug Forfeiture - Justice 0.00 0.00 0.00 0.00 0.00
10-300-522027 Drug Forfeiture - Treasury 0.00 0.00 0.00 0.00 0.00
10-300-522028 Police Evidence Funds 0.00 55,292.03 0.00 -55,292.03 0.00
10-300-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00
10-300-523030 Building Lease 0.00 0.00 0.00 0.00 0.00
10-300-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00
10-300-525020 Sober Driver Program 0.00 0.00 0.00 0.00 0.00
10-300-525050 Police Reserve 0.00 0.00 0.00 0.00 0.00
10-300-529010 Special Events 1,500.00 1,367.27 0.00 132.73 8.85
E15 Contractual Services 91,530.85 143,272.84 0.00 -51,741.99 -56.53
10-300-531010 Electricity 68,250.00 47,230.54 0.00 21,019.46 30.80
10-300-533010 Natural Gas 7,000.00 875.30 0.00 6,124.70 87.50
10-300-534010 Telephone 19,500.00 20,401.62 0.00 -901.62 -4.62
10-300-535010 Water 4,500.00 2,656.22 0.00 1,843.78 40.97
E20 Utilities 99,250.00 71,163.68 0.00 28,086.32 28.30
10-300-540010 Building & Grounds Maint.40,000.00 29,554.23 100.00 10,345.77 25.86
10-300-541030 Vehicle Wash 12,000.00 9,455.42 0.00 2,544.58 21.20
10-300-544010 K-9 Operations 18,500.00 14,126.36 0.00 4,373.64 23.64
10-300-544015 Care of Animals 0.00 0.00 0.00 0.00 0.00
10-300-544020 Civil Defense 0.00 0.00 0.00 0.00 0.00
10-300-544030 Emerg Mgmt Operations 21,300.00 11,001.08 0.00 10,298.92 48.35
10-300-545010 Software Licensemaint 62,000.00 61,164.01 0.00 835.99 1.35
GL - Trial Balance by Acct Type and Full Acct Number (10/09/2017 - 8:47 AM)Page 17
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-300-546010 Clothing Expense 46,300.00 25,376.90 -1,947.99 22,871.09 49.40
10-300-546020 Uniform Cleaning 25,000.00 16,561.98 0.00 8,438.02 33.75
10-300-547010 Equipment Maintenance 9,350.00 7,460.91 0.00 1,889.09 20.20
10-300-547020 Maintenance Agreements 46,600.00 44,184.45 3,531.00 -1,115.45 -2.39
10-300-547030 Radio Maintenance 10,000.00 7,742.12 0.00 2,257.88 22.58
E25 Repairs & Maintenance 291,050.00 226,627.46 1,683.01 62,739.53 21.56
10-300-572010 Purchase Of Vehicles 198,511.76 169,109.00 0.00 29,402.76 14.81
10-300-572011 Purchase of Vehicles-Lease Pmt 0.00 0.00 0.00 0.00 0.00
10-300-572020 Purchase Of Equipment 35,295.00 35,295.00 0.00 0.00 0.00
10-300-572070 MDT Year 2 Equipment 0.00 0.00 0.00 0.00 0.00
10-300-572075 LLEBG Annual Grant Equipment 9,902.40 9,902.40 0.00 0.00 0.00
10-300-572076 LLEBG Stimulus Equipment 0.00 0.00 0.00 0.00 0.00
10-300-572080 DEA Equipment Grant 0.00 0.00 0.00 0.00 0.00
10-300-572100 MDT Year 3 Equipment 0.00 0.00 0.00 0.00 0.00
10-300-572110 Jcpd Mdt Equipment 0.00 0.00 0.00 0.00 0.00
10-300-572120 Cole Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00
10-300-572130 Osage B Mdt Equip 0.00 0.00 0.00 0.00 0.00
10-300-572140 Camden Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00
10-300-572150 Callaway Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00
10-300-572160 Fulton Mdt Equip 0.00 0.00 0.00 0.00 0.00
10-300-572170 Eldon Mdt Equip 0.00 0.00 0.00 0.00 0.00
10-300-572180 Miller Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00
10-300-572190 Camdenton Cty Mtd 0.00 0.00 0.00 0.00 0.00
10-300-572200 Lake Ozark Mdt Equip 0.00 0.00 0.00 0.00 0.00
10-300-572210 Cole Co Reimbursable Grant Exp 6,601.60 6,601.60 0.00 0.00 0.00
10-300-572310 Software-camdnmilob 0.00 0.00 0.00 0.00 0.00
10-300-572320 Software-morgan Cty 0.00 0.00 0.00 0.00 0.00
10-300-572330 Software-jcpdcole Cty 0.00 0.00 0.00 0.00 0.00
10-300-572340 Software-colboone Cty 0.00 0.00 0.00 0.00 0.00
10-300-572350 Software-fultncallaway 0.00 0.00 0.00 0.00 0.00
10-300-572360 Software-vpnfirewl 0.00 0.00 0.00 0.00 0.00
10-300-572370 Software-prof Serv 0.00 0.00 0.00 0.00 0.00
10-300-572410 Project Mgmt Fees 0.00 0.00 0.00 0.00 0.00
10-300-572420 Contingency 0.00 0.00 0.00 0.00 0.00
10-300-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 250,310.76 220,908.00 0.00 29,402.76 11.75
300 Police Department 7,762,064.59 6,901,066.89 11,178.47 849,819.23 10.95
310 School Resource Officer
10-310-501020 Salaries 233,273.88 254,165.03 0.00 -20,891.15 -8.96
10-310-501030 Holiday Pay 8,866.04 4,818.93 0.00 4,047.11 45.65
10-310-501090 Overtime 17,126.00 30,509.37 0.00 -13,383.37 -78.15
10-310-501095 Overtime Straight Pay 410.00 105.82 0.00 304.18 74.19
10-310-502010 Social Security 19,865.21 20,752.20 0.00 -886.99 -4.47
10-310-502020 Group Health Insurance 61,286.66 48,781.67 0.00 12,504.99 20.40
10-310-502030 Retirement 47,780.37 51,683.58 0.00 -3,903.21 -8.17
10-310-502040 Workers Compensation 2,538.82 2,538.82 0.00 0.00 0.00
GL - Trial Balance by Acct Type and Full Acct Number (10/09/2017 - 8:47 AM)Page 18
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-310-502050 Life Insurance 473.93 389.62 0.00 84.31 17.79
10-310-502060 Long Term Disability 714.82 815.95 0.00 -101.13 -14.15
10-310-502070 Employee Assistance Prgm 130.97 121.60 0.00 9.37 7.15
E05 Personnel Services 392,466.70 414,682.59 0.00 -22,215.89 -5.66
10-310-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00
E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00
10-310-520070 Training And Education 0.00 0.00 0.00 0.00 0.00
10-310-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00
E15 Contractual Services 0.00 0.00 0.00 0.00 0.00
10-310-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00
10-310-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00
10-310-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00
E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00
10-310-572010 Purchase Of Vehicles 0.00 0.00 0.00 0.00 0.00
10-310-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00
310 School Resource Officer 392,466.70 414,682.59 0.00 -22,215.89 -5.66
320 M.U.S.T.A.N.G.
10-320-501020 Salaries 93,718.69 80,905.37 0.00 12,813.32 13.67
10-320-501030 Holiday Pay 2,364.09 337.87 0.00 2,026.22 85.71
10-320-501090 Overtime 24,650.00 22,297.76 0.00 2,352.24 9.54
10-320-501095 Overtime Straight Pay 1,000.00 594.20 0.00 405.80 40.58
10-320-502010 Social Security 7,691.06 7,520.98 0.00 170.08 2.21
10-320-502020 Group Health Insurance 19,569.70 16,697.99 0.00 2,871.71 14.67
10-320-502030 Retirement 18,498.75 19,160.84 0.00 -662.09 -3.58
10-320-502040 Workers Compensation 1,018.46 1,018.46 0.00 0.00 0.00
10-320-502050 Life Insurance 180.17 125.27 0.00 54.90 30.47
10-320-502060 Long Term Disability 271.24 260.89 0.00 10.35 3.82
10-320-502070 Employee Assistance Prgm 52.39 48.64 0.00 3.75 7.16
E05 Personnel Services 169,014.55 148,968.27 0.00 20,046.28 11.86
10-320-514010 Gas 5,000.00 4,773.55 0.00 226.45 4.53
10-320-516040 Investigations 14,350.00 10,871.12 0.00 3,478.88 24.24
10-320-517010 Operational Supplies 7,750.31 1,833.05 0.00 5,917.26 76.35
E10 Materials & Supplies 27,100.31 17,477.72 0.00 9,622.59 35.51
10-320-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-320-520070 Training And Education 0.00 0.00 0.00 0.00 0.00
10-320-522020 Professional Services 0.00 0.00 0.00 0.00 0.00
10-320-522025 Drug Forfeiture - MUSTANG 0.00 0.00 0.00 0.00 0.00
10-320-523010 Equipment Rentlease 18,269.11 13,000.00 0.00 5,269.11 28.84
10-320-523020 Building Lease 0.00 0.00 0.00 0.00 0.00
E15 Contractual Services 18,269.11 13,000.00 0.00 5,269.11 28.84
GL - Trial Balance by Acct Type and Full Acct Number (10/09/2017 - 8:47 AM)Page 19
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-320-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00
10-320-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00
10-320-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00
10-320-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00
E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00
10-320-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00
320 M.U.S.T.A.N.G.214,383.97 179,445.99 0.00 34,937.98 16.30
330 Animal Control
10-330-501020 Salaries 328,493.12 292,416.02 0.00 36,077.10 10.98
10-330-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00
10-330-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00
10-330-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00
10-330-501070 Stand-by Plan 4,308.00 3,862.50 0.00 445.50 10.34
10-330-501090 Overtime 1,709.00 1,896.28 0.00 -187.28 -10.96
10-330-501095 Overtime Straight Pay 500.00 0.00 0.00 500.00 100.00
10-330-502010 Social Security 25,628.27 21,720.47 0.00 3,907.80 15.25
10-330-502020 Group Health Insurance 57,912.97 56,935.19 0.00 977.78 1.69
10-330-502030 Retirement 49,581.50 44,130.00 0.00 5,451.50 11.00
10-330-502040 Workers Compensation 2,494.77 2,494.77 0.00 0.00 0.00
10-330-502050 Life Insurance 640.40 467.39 0.00 173.01 27.02
10-330-502060 Long Term Disability 1,003.75 969.46 0.00 34.29 3.42
10-330-502070 Employee Assistance Prgm 209.55 194.52 0.00 15.03 7.17
10-330-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 472,481.33 425,086.60 0.00 47,394.73 10.03
10-330-511010 Advertising 0.00 0.00 0.00 0.00 0.00
10-330-511020 Postage 100.00 110.93 0.00 -10.93 -10.93
10-330-512010 Printing 1,570.00 1,710.65 0.00 -140.65 -8.96
10-330-512020 Copies 0.00 0.00 0.00 0.00 0.00
10-330-513010 Office Supplies 400.00 477.70 0.00 -77.70 -19.43
10-330-514030 Small Tools 0.00 0.00 0.00 0.00 0.00
10-330-514040 Food 240.00 250.52 0.00 -10.52 -4.38
10-330-515040 First Aid Supplies 700.00 326.80 0.00 373.20 53.31
10-330-517010 Operational Supplies 9,700.00 10,961.44 0.00 -1,261.44 -13.00
E10 Materials & Supplies 12,710.00 13,838.04 0.00 -1,128.04 -8.88
10-330-520030 Dues And Publications 1,390.00 1,381.78 0.00 8.22 0.59
10-330-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-330-520070 Training And Education 1,950.00 500.00 0.00 1,450.00 74.36
10-330-521040 Medical Claimsservices 564.00 505.00 0.00 59.00 10.46
10-330-522020 Professional Services 2,715.00 13,967.95 0.00 -11,252.95 -414.47
10-330-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00
10-330-529045 Veterinary Services 7,700.00 10,457.38 0.00 -2,757.38 -35.81
10-330-529050 Spay & Neuter Program 0.00 0.00 0.00 0.00 0.00
GL - Trial Balance by Acct Type and Full Acct Number (10/09/2017 - 8:47 AM)Page 20
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-330-529060 Special Sn Program 0.00 0.00 0.00 0.00 0.00
10-330-529065 Adoption Voucher Program 0.00 0.00 0.00 0.00 0.00
10-330-529067 Animal Shelter Bricks 0.00 0.00 0.00 0.00 0.00
10-330-529068 Animal Shelter Donations 14,890.46 14,890.46 0.00 0.00 0.00
E15 Contractual Services 29,209.46 41,702.57 0.00 -12,493.11 -42.77
10-330-531010 Electricity 18,700.00 18,579.76 0.00 120.24 0.64
10-330-533010 Natural Gas 15,800.00 15,338.97 0.00 461.03 2.92
10-330-534010 Telephone 300.00 143.84 0.00 156.16 52.05
10-330-535010 Water 4,000.00 2,649.72 0.00 1,350.28 33.76
E20 Utilities 38,800.00 36,712.29 0.00 2,087.71 5.38
10-330-540010 Building & Grounds Maint.13,390.00 14,441.67 0.00 -1,051.67 -7.85
10-330-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00
10-330-541030 Vehicle Wash 540.00 540.00 0.00 0.00 0.00
10-330-544040 Care Of Animals 41,000.00 52,780.58 0.00 -11,780.58 -28.73
10-330-544050 Animal Food 5,000.00 4,756.11 0.00 243.89 4.88
10-330-545010 Software Licensemaint 2,350.00 2,287.56 0.00 62.44 2.66
10-330-546010 Clothing Expense 1,800.00 1,923.94 0.00 -123.94 -6.89
10-330-546020 Uniform Cleaning 200.00 195.13 0.00 4.87 2.44
10-330-547010 Equipment Maintenance 1,000.00 956.84 0.00 43.16 4.32
10-330-547020 Maintenance Agreements 69.00 69.00 0.00 0.00 0.00
10-330-547030 Radio Maintenance 61.00 53.55 0.00 7.45 12.21
E25 Repairs & Maintenance 65,410.00 78,004.38 0.00 -12,594.38 -19.25
10-330-572010 Purchase of Vehicles 28,251.96 24,982.40 0.00 3,269.56 11.57
10-330-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
10-330-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 28,251.96 24,982.40 0.00 3,269.56 11.57
10-330-578069 Animal Shelter 0.00 0.00 0.00 0.00 0.00
E75 Capital Projects 0.00 0.00 0.00 0.00 0.00
330 Animal Control 646,862.75 620,326.28 0.00 26,536.47 4.10
390 9-1-1 Police
10-390-501020 Salaries 860,459.47 750,972.62 0.00 109,486.85 12.72
10-390-501030 Holiday Pay 29,479.22 27,701.65 0.00 1,777.57 6.03
10-390-501050 Parttime(wo Benefits)2,600.00 0.00 0.00 2,600.00 100.00
10-390-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00
10-390-501090 Overtime 15,814.00 14,639.08 0.00 1,174.92 7.43
10-390-501095 Overtime Straight Pay 500.00 78.70 0.00 421.30 84.26
10-390-502010 Social Security 69,527.23 57,844.14 0.00 11,683.09 16.80
10-390-502020 Group Health Insurance 169,048.38 131,272.86 0.00 37,775.52 22.35
10-390-502030 Retirement 135,322.10 113,712.73 0.00 21,609.37 15.97
10-390-502040 Workers Compensation 481.13 481.13 0.00 0.00 0.00
10-390-502050 Life Insurance 1,737.10 1,156.46 0.00 580.64 33.43
10-390-502060 Long Term Disability 2,637.44 2,393.22 0.00 244.22 9.26
10-390-502070 Employee Assistance Prgm 556.61 516.72 0.00 39.89 7.17
GL - Trial Balance by Acct Type and Full Acct Number (10/09/2017 - 8:47 AM)Page 21
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-390-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 1,288,162.68 1,100,769.31 0.00 187,393.37 14.55
10-390-511010 Advertising 100.00 0.00 0.00 100.00 100.00
10-390-512010 Printing 0.00 0.00 0.00 0.00 0.00
10-390-517010 Operational Supplies 5,000.00 1,399.02 0.00 3,600.98 72.02
E10 Materials & Supplies 5,100.00 1,399.02 0.00 3,700.98 72.57
10-390-520030 Dues And Publications 480.00 496.00 0.00 -16.00 -3.33
10-390-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-390-520070 Training And Education 5,000.00 2,588.27 0.00 2,411.73 48.23
10-390-522020 Professional Services 1,320.00 1,994.48 -680.00 5.52 0.42
10-390-523010 Equipment Rentlease 98,000.00 86,361.15 0.00 11,638.85 11.88
E15 Contractual Services 104,800.00 91,439.90 -680.00 14,040.10 13.40
10-390-534010 Telephone 0.00 0.00 0.00 0.00 0.00
E20 Utilities 0.00 0.00 0.00 0.00 0.00
10-390-545010 Software Licensemaint 23,000.00 23,000.00 0.00 0.00 0.00
10-390-546010 Clothing Expense 6,000.00 2,081.61 0.00 3,918.39 65.31
10-390-546020 Uniform Cleaning 1,400.00 2,634.00 0.00 -1,234.00 -88.14
10-390-547010 Equipment Maintenance 2,600.00 337.50 0.00 2,262.50 87.02
10-390-547020 Maintenance Agreements 42,000.00 41,278.91 144.29 576.80 1.37
10-390-547030 Radio Maintenance 5,000.00 4,742.36 0.00 257.64 5.15
E25 Repairs & Maintenance 80,000.00 74,074.38 144.29 5,781.33 7.23
10-390-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00
390 9-1-1 Police 1,478,062.68 1,267,682.61 -535.71 210,915.78 14.27
400 Fire Department
10-400-501020 Salaries 3,783,411.71 3,278,166.89 0.00 505,244.82 13.35
10-400-501030 Holiday Pay 270,304.05 269,698.57 0.00 605.48 0.22
10-400-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00
10-400-501080 Step-up Pay 28,500.00 31,620.00 0.00 -3,120.00 -10.95
10-400-501090 Overtime 43,000.00 25,391.72 0.00 17,608.28 40.95
10-400-501095 Overtime Straight Pay 35,000.00 18,207.87 0.00 16,792.13 47.98
10-400-502010 Social Security 69,436.89 52,084.88 0.00 17,352.01 24.99
10-400-502020 Group Health Insurance 644,562.45 563,365.31 0.00 81,197.14 12.60
10-400-502030 Retirement 1,822,395.71 1,559,489.44 0.00 262,906.27 14.43
10-400-502040 Workers Compensation 79,145.55 79,145.55 0.00 0.00 0.00
10-400-502050 Life Insurance 7,794.43 5,016.05 0.00 2,778.38 35.65
10-400-502060 Long Term Disability 11,342.56 10,329.79 0.00 1,012.77 8.93
10-400-502070 Employee Assistance Prgm 1,990.71 1,848.08 0.00 142.63 7.16
10-400-503010 Awards Program 900.00 817.07 0.00 82.93 9.21
E05 Personnel Services 6,797,784.06 5,895,181.22 0.00 902,602.84 13.28
10-400-511010 Advertising 1,150.00 661.90 0.00 488.10 42.44
GL - Trial Balance by Acct Type and Full Acct Number (10/09/2017 - 8:47 AM)Page 22
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-400-511020 Postage 200.00 164.31 0.00 35.69 17.85
10-400-512010 Printing 1,036.00 669.00 0.00 367.00 35.42
10-400-512020 Copies 50.00 0.35 0.00 49.65 99.30
10-400-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00
10-400-513010 Office Supplies 1,300.00 1,262.84 0.00 37.16 2.86
10-400-514010 Gas 41,000.00 35,574.35 0.00 5,425.65 13.23
10-400-514020 Chemicals 1,500.00 1,195.00 0.00 305.00 20.33
10-400-514030 Small Tools 5,700.00 5,655.53 0.00 44.47 0.78
10-400-514040 Food 0.00 0.00 0.00 0.00 0.00
10-400-515040 First Aid Supplies 1,507.00 1,506.18 0.00 0.82 0.05
10-400-517010 Operational Supplies 10,000.00 9,452.68 0.00 547.32 5.47
E10 Materials & Supplies 63,443.00 56,142.14 0.00 7,300.86 11.51
10-400-520030 Dues And Publications 2,507.00 2,506.85 0.00 0.15 0.01
10-400-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-400-520060 Wellness Program 0.00 0.00 0.00 0.00 0.00
10-400-520070 Training And Education 24,000.00 20,606.41 0.00 3,393.59 14.14
10-400-520080 Tuition Reimbursement 4,000.00 4,170.00 0.00 -170.00 -4.25
10-400-520085 Traing-Home Land Security 0.00 0.00 0.00 0.00 0.00
10-400-521040 Medical Claimsservices 38,550.00 36,940.48 0.00 1,609.52 4.18
10-400-522020 Professional Services 3,250.00 2,840.85 0.00 409.15 12.59
10-400-523010 Equipment Rentlease 458.63 58.74 0.00 399.89 87.19
10-400-524010 Trash Collections 100.00 0.00 0.00 100.00 100.00
10-400-529010 Special Events 5,541.37 5,541.37 0.00 0.00 0.00
10-400-529040 Child Pass Seat Pass-through 2,500.00 780.00 0.00 1,720.00 68.80
E15 Contractual Services 80,907.00 73,444.70 0.00 7,462.30 9.22
10-400-531010 Electricity 32,000.00 29,421.42 0.00 2,578.58 8.06
10-400-533010 Natural Gas 13,425.00 12,095.57 0.00 1,329.43 9.90
10-400-534010 Telephone 23,075.00 20,014.05 0.00 3,060.95 13.27
10-400-535010 Water 16,500.00 16,866.91 0.00 -366.91 -2.22
E20 Utilities 85,000.00 78,397.95 0.00 6,602.05 7.77
10-400-540010 Building & Grounds Maint.203,738.00 93,517.80 126,483.38 -16,263.18 -7.98
10-400-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00
10-400-546010 Clothing Expense 46,100.00 43,280.00 -2,841.00 5,661.00 12.28
10-400-546020 Uniform Cleaning 500.00 258.25 0.00 241.75 48.35
10-400-547010 Equipment Maintenance 16,500.00 16,017.84 1,700.80 -1,218.64 -7.39
10-400-547020 Maintenance Agreements 28,500.00 27,081.37 -14,681.97 16,100.60 56.49
10-400-547030 Radio Maintenance 9,500.00 2,108.72 0.00 7,391.28 77.80
E25 Repairs & Maintenance 304,838.00 182,263.98 110,661.21 11,912.81 3.91
10-400-572010 Purchase Of Vehicles 88,875.00 89,593.07 0.00 -718.07 -0.81
10-400-572011 Purchase of Vehicles-Lease Pmt 0.00 0.00 0.00 0.00 0.00
10-400-572020 Purchase Of Equipment 7,650.00 7,645.85 0.00 4.15 0.05
10-400-572021 Purchase of Equipment-ONE TIME 0.00 0.00 0.00 0.00 0.00
10-400-572060 Fire Grant Equipgear 274,461.00 0.00 106,247.40 168,213.60 61.29
10-400-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00
10-400-575004 Fire Apparatus 1,163,313.93 1,163,313.93 0.00 0.00 0.00
GL - Trial Balance by Acct Type and Full Acct Number (10/09/2017 - 8:47 AM)Page 23
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
E70 Capital Purchases 1,534,299.93 1,260,552.85 106,247.40 167,499.68 10.92
400 Fire Department 8,866,271.99 7,545,982.84 216,908.61 1,103,380.54 12.44
401 Fire Museum
10-401-531010 Electricity 619.06 834.91 0.00 -215.85 -34.87
10-401-533010 Natural Gas 324.39 384.22 0.00 -59.83 -18.44
10-401-535010 Water 306.55 368.47 0.00 -61.92 -20.20
E20 Utilities 1,250.00 1,587.60 0.00 -337.60 -27.01
10-401-540010 Building & Grounds Maint.0.00 0.00 0.00 0.00 0.00
E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00
401 Fire Museum 1,250.00 1,587.60 0.00 -337.60 -27.01
500 Public Works
10-500-501020 Salaries 0.00 0.00 0.00 0.00 0.00
10-500-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00
10-500-501090 Overtime 0.00 0.00 0.00 0.00 0.00
10-500-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00
10-500-502010 Social Security 0.00 0.00 0.00 0.00 0.00
10-500-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00
10-500-502030 Retirement 0.00 0.00 0.00 0.00 0.00
10-500-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
10-500-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00
10-500-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00
10-500-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 0.00 0.00 0.00 0.00 0.00
10-500-511010 Advertising 0.00 0.00 0.00 0.00 0.00
10-500-511020 Postage 0.00 0.00 0.00 0.00 0.00
10-500-512010 Printing 0.00 0.00 0.00 0.00 0.00
10-500-512020 Copies 0.00 0.00 0.00 0.00 0.00
10-500-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00
10-500-514040 Food 0.00 -291.18 0.00 291.18 0.00
10-500-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00
E10 Materials & Supplies 0.00 -291.18 0.00 291.18 0.00
10-500-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00
10-500-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-500-520070 Training And Education 0.00 0.00 0.00 0.00 0.00
10-500-522020 Professional Services 0.00 0.00 0.00 0.00 0.00
10-500-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00
10-500-527010 Comm Serv Projects 0.00 0.00 0.00 0.00 0.00
E15 Contractual Services 0.00 0.00 0.00 0.00 0.00
10-500-534010 Telephone 0.00 0.00 0.00 0.00 0.00
E20 Utilities 0.00 0.00 0.00 0.00 0.00
GL - Trial Balance by Acct Type and Full Acct Number (10/09/2017 - 8:47 AM)Page 24
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-500-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00
E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00
10-500-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
10-500-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00
500 Public Works 0.00 -291.18 0.00 291.18 0.00
520 Plan & Protect Svcs-Admin
10-520-501020 Salaries 233,118.82 205,830.72 0.00 27,288.10 11.71
10-520-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00
10-520-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00
10-520-501090 Overtime 0.00 0.00 0.00 0.00 0.00
10-520-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00
10-520-502010 Social Security 17,188.14 15,439.72 0.00 1,748.42 10.17
10-520-502020 Group Health Insurance 31,191.13 23,207.85 0.00 7,983.28 25.59
10-520-502030 Retirement 32,020.81 26,103.15 0.00 5,917.66 18.48
10-520-502040 Workers Compensation 123.35 123.35 0.00 0.00 0.00
10-520-502050 Life Insurance 419.10 253.23 0.00 165.87 39.58
10-520-502060 Long Term Disability 607.35 510.85 0.00 96.50 15.89
10-520-502070 Employee Assistance Prgm 104.77 97.28 0.00 7.49 7.15
10-520-503010 Awards Program 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 314,773.47 271,566.15 0.00 43,207.32 13.73
10-520-511010 Advertising 5,474.42 5,474.42 0.00 0.00 0.00
10-520-511020 Postage 200.00 22.32 0.00 177.68 88.84
10-520-512010 Printing 0.00 0.00 0.00 0.00 0.00
10-520-512020 Copies 0.00 0.00 0.00 0.00 0.00
10-520-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00
10-520-513010 Office Supplies 881.83 970.76 0.00 -88.93 -10.08
10-520-514010 Gas 9,000.00 7,359.26 0.00 1,640.74 18.23
10-520-514030 Small Tools 0.00 0.00 0.00 0.00 0.00
10-520-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00
10-520-517010 Operational Supplies 1,020.93 1,214.74 0.00 -193.81 -18.98
E10 Materials & Supplies 16,577.18 15,041.50 0.00 1,535.68 9.26
10-520-520030 Dues And Publications 500.00 125.88 0.00 374.12 74.82
10-520-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-520-520070 Training And Education 1,269.70 1,163.20 0.00 106.50 8.39
10-520-522020 Professional Services 3,369.16 1,260.15 0.00 2,109.01 62.60
E15 Contractual Services 5,138.86 2,549.23 0.00 2,589.63 50.39
10-520-534010 Telephone 0.00 0.00 0.00 0.00 0.00
E20 Utilities 0.00 0.00 0.00 0.00 0.00
10-520-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00
10-520-547020 Maintenance Agreements 1,419.45 873.60 80.65 465.20 32.77
E25 Repairs & Maintenance 1,419.45 873.60 80.65 465.20 32.77
GL - Trial Balance by Acct Type and Full Acct Number (10/09/2017 - 8:47 AM)Page 25
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-520-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00
520 Plan & Protect Svcs-Admin 337,908.96 290,030.48 80.65 47,797.83 14.15
521 Plan & Protect Svcs-Planning
10-521-501020 Salaries 62,688.54 55,161.04 0.00 7,527.50 12.01
10-521-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00
10-521-501050 Parttime(wo Benefits)13,890.11 10,671.22 0.00 3,218.89 23.17
10-521-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00
10-521-501090 Overtime 0.00 0.00 0.00 0.00 0.00
10-521-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00
10-521-502010 Social Security 5,702.12 4,923.13 0.00 778.99 13.66
10-521-502020 Group Health Insurance 10,090.77 8,733.25 0.00 1,357.52 13.45
10-521-502030 Retirement 9,277.93 8,163.86 0.00 1,114.07 12.01
10-521-502040 Workers Compensation 40.27 40.27 0.00 0.00 0.00
10-521-502050 Life Insurance 99.27 85.34 0.00 13.93 14.03
10-521-502060 Long Term Disability 202.07 176.87 0.00 25.20 12.47
10-521-502070 Employee Assistance Prgm 26.19 24.32 0.00 1.87 7.14
10-521-503010 Awards Program 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 102,017.27 87,979.30 0.00 14,037.97 13.76
10-521-511010 Advertising 5,000.00 4,879.25 0.00 120.75 2.42
10-521-511020 Postage 1,000.00 539.16 0.00 460.84 46.08
10-521-512010 Printing 0.00 0.00 0.00 0.00 0.00
10-521-512020 Copies 19.08 19.08 0.00 0.00 0.00
10-521-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00
10-521-513010 Office Supplies 1,000.00 672.59 0.00 327.41 32.74
10-521-514040 Food 174.88 174.88 0.00 0.00 0.00
10-521-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00
10-521-517010 Operational Supplies 1,916.04 1,238.47 0.00 677.57 35.36
E10 Materials & Supplies 9,110.00 7,523.43 0.00 1,586.57 17.42
10-521-520030 Dues And Publications 15,500.00 13,897.70 0.00 1,602.30 10.34
10-521-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-521-520070 Training And Education 1,126.13 0.00 0.00 1,126.13 100.00
10-521-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00
10-521-522020 Professional Services 0.00 0.00 0.00 0.00 0.00
10-521-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00
E15 Contractual Services 16,626.13 13,897.70 0.00 2,728.43 16.41
10-521-534010 Telephone 0.00 0.00 0.00 0.00 0.00
E20 Utilities 0.00 0.00 0.00 0.00 0.00
10-521-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00
10-521-547020 Maintenance Agreements 1,662.58 1,389.52 132.14 140.92 8.48
E25 Repairs & Maintenance 1,662.58 1,389.52 132.14 140.92 8.48
GL - Trial Balance by Acct Type and Full Acct Number (10/09/2017 - 8:47 AM)Page 26
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-521-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00
521 Plan & Protect Svcs-Planning 129,415.98 110,789.95 132.14 18,493.89 14.29
522 Plan & Protect Svcs-MPO
10-522-501020 Salaries 114,947.75 96,510.90 0.00 18,436.85 16.04
10-522-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00
10-522-501090 Overtime 0.00 0.00 0.00 0.00 0.00
10-522-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00
10-522-502010 Social Security 11,592.06 7,360.11 0.00 4,231.95 36.51
10-522-502020 Group Health Insurance 18,872.81 12,126.91 0.00 6,745.90 35.74
10-522-502030 Retirement 24,116.63 14,283.61 0.00 9,833.02 40.77
10-522-502040 Workers Compensation 63.37 63.37 0.00 0.00 0.00
10-522-502050 Life Insurance 317.26 153.76 0.00 163.50 51.54
10-522-502060 Long Term Disability 496.94 315.49 0.00 181.45 36.51
10-522-502070 Employee Assistance Prgm 78.58 72.96 0.00 5.62 7.15
E05 Personnel Services 170,485.40 130,887.11 0.00 39,598.29 23.23
10-522-511010 Advertising 2,101.00 1,293.50 0.00 807.50 38.43
10-522-511020 Postage 400.00 232.12 0.00 167.88 41.97
10-522-512010 Printing 125.00 38.00 0.00 87.00 69.60
10-522-512020 Copies 50.00 2.63 0.00 47.37 94.74
10-522-513010 Office Supplies 1,000.00 775.21 0.00 224.79 22.48
10-522-514040 Food 250.00 194.18 0.00 55.82 22.33
10-522-517010 Operational Supplies 1,245.00 314.32 0.00 930.68 74.75
E10 Materials & Supplies 5,171.00 2,849.96 0.00 2,321.04 44.89
10-522-520030 Dues And Publications 1,305.00 1,305.00 0.00 0.00 0.00
10-522-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-522-520070 Training And Education 9,576.64 4,863.48 0.00 4,713.16 49.22
10-522-522020 Professional Services 235,000.00 68,330.86 6,669.14 160,000.00 68.09
10-522-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00
E15 Contractual Services 245,881.64 74,499.34 6,669.14 164,713.16 66.99
10-522-534010 Telephone 0.00 0.00 0.00 0.00 0.00
E20 Utilities 0.00 0.00 0.00 0.00 0.00
10-522-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00
10-522-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00
10-522-547020 Maintenance Agreements 750.00 594.46 146.88 8.66 1.15
10-522-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00
E25 Repairs & Maintenance 750.00 594.46 146.88 8.66 1.15
10-522-572020 Purchase Of Equipment 2,774.00 0.00 2,774.00 0.00 0.00
E70 Capital Purchases 2,774.00 0.00 2,774.00 0.00 0.00
522 Plan & Protect Svcs-MPO 425,062.04 208,830.87 9,590.02 206,641.15 48.61
GL - Trial Balance by Acct Type and Full Acct Number (10/09/2017 - 8:47 AM)Page 27
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
530 Plan & Protect Svc-RedevGrant
10-530-501020 Salaries 104,707.80 70,571.69 0.00 34,136.11 32.60
10-530-501050 Parttime (wo Benefits)0.00 0.00 0.00 0.00 0.00
10-530-501090 Overtime 0.00 0.00 0.00 0.00 0.00
10-530-502010 Social Security 8,010.14 4,888.22 0.00 3,121.92 38.97
10-530-502020 Group Health Insurance 16,238.38 10,987.02 0.00 5,251.36 32.34
10-530-502030 Retirement 15,496.76 10,444.57 0.00 5,052.19 32.60
10-530-502040 Workers Compensation 28.02 0.00 0.00 28.02 100.00
10-530-502050 Life Insurance 205.63 108.70 0.00 96.93 47.14
10-530-502060 Long Term Disability 307.40 226.51 0.00 80.89 26.31
10-530-502070 Employee Assistance Prgm 65.48 60.80 0.00 4.68 7.15
E05 Personnel Services 145,059.61 97,287.51 0.00 47,772.10 32.93
10-530-511010 Advertising 493.05 495.05 0.00 -2.00 -0.41
10-530-511020 Postage 100.00 94.03 0.00 5.97 5.97
10-530-512010 Printing 50.00 40.00 0.00 10.00 20.00
10-530-512020 Copies 22.00 0.00 0.00 22.00 100.00
10-530-513010 Office Supplies 300.00 303.58 0.00 -3.58 -1.19
10-530-517010 Operational Supplies 300.00 408.70 0.00 -108.70 -36.23
E10 Materials & Supplies 1,265.05 1,341.36 0.00 -76.31 -6.03
10-530-520030 Dues And Publications 500.00 270.00 0.00 230.00 46.00
10-530-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-530-520070 Training And Education 750.52 899.52 0.00 -149.00 -19.85
10-530-522020 Professional Services 0.00 0.00 0.00 0.00 0.00
10-530-524020 Recycle Collectprocess 0.00 0.00 0.00 0.00 0.00
10-530-524024 Mid-Mo Solid Wast Mgmt Dist 0.00 0.00 0.00 0.00 0.00
10-530-524025 Glass Recycling 0.00 0.00 0.00 0.00 0.00
10-530-524026 Household Hazardous Waste 18,800.00 14,402.22 4,397.78 0.00 0.00
10-530-524027 Portable Recycling 0.00 0.00 0.00 0.00 0.00
10-530-524028 Misc Recycling 2,000.00 1,670.84 0.00 329.16 16.46
10-530-524029 Recycling Education 9,000.00 5,513.68 0.00 3,486.32 38.74
10-530-528085 Fair Housing Assistance Prog 238.00 238.00 0.00 0.00 0.00
E15 Contractual Services 31,288.52 22,994.26 4,397.78 3,896.48 12.45
10-530-534010 Telephone 0.00 0.00 0.00 0.00 0.00
E20 Utilities 0.00 0.00 0.00 0.00 0.00
10-530-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00
10-530-547020 Maintenance Agreements 350.00 61.79 76.87 211.34 60.38
E25 Repairs & Maintenance 350.00 61.79 76.87 211.34 60.38
10-530-550020 NRA-Residential 55,000.00 52,836.47 0.00 2,163.53 3.93
10-530-550030 NRA-Commercial Facade 35,000.00 16,715.32 0.00 18,284.68 52.24
10-530-550031 Historic Preservation Grant 0.00 0.00 0.00 0.00 0.00
10-530-550032 NRA-Rental Facade 15,066.00 5,060.00 0.00 10,006.00 66.41
10-530-550035 Old Town Redev Committee 0.00 0.00 0.00 0.00 0.00
10-530-550037 Historic Preservation Comm 247.84 247.84 0.00 0.00 0.00
10-530-550039 Historic Preservation Grant 0.00 0.00 0.00 0.00 0.00
GL - Trial Balance by Acct Type and Full Acct Number (10/09/2017 - 8:47 AM)Page 28
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-530-550050 Neighb Stablization Prog 62,411.54 14,492.81 0.00 47,918.73 76.78
10-530-550055 HERO 48,480.00 44,500.00 0.00 3,980.00 8.21
10-530-550060 MSP 0.00 0.00 0.00 0.00 0.00
10-530-550090 Hazard Mitigation 0.00 0.00 0.00 0.00 0.00
E30 Other Operating Expenses 216,205.38 133,852.44 0.00 82,352.94 38.09
530 Plan & Protect Svc-RedevGrant 394,168.56 255,537.36 4,474.65 134,156.55 34.04
531 Plan & Protect Svcs-Build Reg
10-531-501020 Salaries 0.00 0.00 0.00 0.00 0.00
10-531-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00
10-531-501090 Overtime 0.00 0.00 0.00 0.00 0.00
10-531-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00
10-531-502010 Social Security 0.00 0.00 0.00 0.00 0.00
10-531-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00
10-531-502030 Retirement 0.00 0.00 0.00 0.00 0.00
10-531-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
10-531-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00
10-531-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00
10-531-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 0.00 0.00 0.00 0.00 0.00
10-531-511010 Advertising 0.00 0.00 0.00 0.00 0.00
10-531-511020 Postage 0.00 0.00 0.00 0.00 0.00
10-531-512010 Printing 0.00 0.00 0.00 0.00 0.00
10-531-512020 Copies 0.00 0.00 0.00 0.00 0.00
10-531-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00
10-531-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00
10-531-514030 Small Tools 0.00 0.00 0.00 0.00 0.00
10-531-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00
10-531-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00
E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00
10-531-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00
10-531-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-531-520070 Training And Education 0.00 0.00 0.00 0.00 0.00
10-531-522020 Professional Services 0.00 0.00 0.00 0.00 0.00
10-531-522021 Abatement 0.00 0.00 0.00 0.00 0.00
10-531-522022 Demo 0.00 0.00 0.00 0.00 0.00
10-531-522070 Legal Services 0.00 0.00 0.00 0.00 0.00
10-531-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00
10-531-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00
E15 Contractual Services 0.00 0.00 0.00 0.00 0.00
10-531-534010 Telephone 0.00 0.00 0.00 0.00 0.00
E20 Utilities 0.00 0.00 0.00 0.00 0.00
10-531-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00
10-531-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00
GL - Trial Balance by Acct Type and Full Acct Number (10/09/2017 - 8:47 AM)Page 29
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-531-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00
10-531-547020 Maintenance Agreements 0.00 54.16 0.00 -54.16 0.00
10-531-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00
E25 Repairs & Maintenance 0.00 54.16 0.00 -54.16 0.00
10-531-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00
531 Plan & Protect Svcs-Build Reg 0.00 54.16 0.00 -54.16 0.00
532 Plan & Protect Svcs-Env Health
10-532-501020 Salaries 170,870.89 151,059.70 0.00 19,811.19 11.59
10-532-501050 Parttime (wo Benefits)0.00 0.00 0.00 0.00 0.00
10-532-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00
10-532-501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00
10-532-501090 Overtime 46.42 0.00 0.00 46.42 100.00
10-532-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00
10-532-502010 Social Security 11,992.31 10,591.01 0.00 1,401.30 11.68
10-532-502020 Group Health Insurance 30,174.42 26,416.08 0.00 3,758.34 12.46
10-532-502030 Retirement 25,289.03 22,356.94 0.00 2,932.09 11.59
10-532-502040 Workers Compensation 1,779.23 1,779.23 0.00 0.00 0.00
10-532-502050 Life Insurance 276.14 237.42 0.00 38.72 14.02
10-532-502060 Long Term Disability 562.05 491.94 0.00 70.11 12.47
10-532-502070 Employee Assistance Prgm 78.58 72.96 0.00 5.62 7.15
10-532-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 241,069.07 213,005.28 0.00 28,063.79 11.64
10-532-511010 Advertising 102.82 90.00 0.00 12.82 12.47
10-532-511020 Postage 200.00 160.43 0.00 39.57 19.79
10-532-512010 Printing 50.00 0.00 0.00 50.00 100.00
10-532-512020 Copies 20.00 0.00 0.00 20.00 100.00
10-532-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00
10-532-513010 Office Supplies 1,497.18 1,673.07 0.00 -175.89 -11.75
10-532-514030 Small Tools 50.00 0.00 0.00 50.00 100.00
10-532-515030 Insect Control 0.00 0.00 0.00 0.00 0.00
10-532-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00
10-532-517010 Operational Supplies 1,229.00 1,209.65 0.00 19.35 1.57
E10 Materials & Supplies 3,164.00 3,133.15 0.00 30.85 0.98
10-532-520030 Dues And Publications 1,000.00 990.00 0.00 10.00 1.00
10-532-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-532-520070 Training And Education 1,000.00 623.00 0.00 377.00 37.70
10-532-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00
10-532-522020 Professional Services 1,474.00 1,474.00 0.00 0.00 0.00
10-532-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00
10-532-524020 Recycle Collectprocess 0.00 0.00 0.00 0.00 0.00
10-532-524025 Glass Recycling 0.00 0.00 0.00 0.00 0.00
10-532-524026 Household Hazardous Waste 0.00 0.00 0.00 0.00 0.00
10-532-524027 INACTIVE - Portable Recycling 0.00 0.00 0.00 0.00 0.00
GL - Trial Balance by Acct Type and Full Acct Number (10/09/2017 - 8:47 AM)Page 30
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-532-524028 Misc Recycling 0.00 0.00 0.00 0.00 0.00
10-532-524030 Compost Services 221,000.00 202,583.37 18,416.67 -0.04 0.00
10-532-529010 Special Events 700.00 0.00 0.00 700.00 100.00
10-532-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00
E15 Contractual Services 225,174.00 205,670.37 18,416.67 1,086.96 0.48
10-532-534010 Telephone 0.00 0.00 0.00 0.00 0.00
E20 Utilities 0.00 0.00 0.00 0.00 0.00
10-532-540060 Cemetery Maintenance 30,000.00 24,313.27 4,730.00 956.73 3.19
10-532-540065 Cemetery Restoration 0.00 0.00 0.00 0.00 0.00
10-532-541030 Vehicle Wash 1,290.00 1,284.00 0.00 6.00 0.47
10-532-546010 Clothing Expense 1,631.00 763.00 0.00 868.00 53.22
10-532-547010 Equipment Maintenance 80.00 0.00 0.00 80.00 100.00
10-532-547020 Maintenance Agreements 800.00 588.56 16.96 194.48 24.31
10-532-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00
E25 Repairs & Maintenance 33,801.00 26,948.83 4,746.96 2,105.21 6.23
10-532-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00
532 Plan & Protect Svcs-Env Health 503,208.07 448,757.63 23,163.63 31,286.81 6.22
533 PPS - Prop MaintCode Enforce
10-533-501020 Salaries 154,167.75 138,467.56 0.00 15,700.19 10.18
10-533-501060 Seasonal Salaries 15,709.44 11,315.70 0.00 4,393.74 27.97
10-533-501090 Overtime 72.72 0.00 0.00 72.72 100.00
10-533-501095 Overtime Straight Pay 260.00 0.00 0.00 260.00 100.00
10-533-502010 Social Security 13,680.89 10,735.52 0.00 2,945.37 21.53
10-533-502020 Group Health Insurance 23,944.06 21,162.97 0.00 2,781.09 11.61
10-533-502030 Retirement 21,141.08 15,033.89 0.00 6,107.19 28.89
10-533-502040 Workers Compensation 1,874.09 0.00 0.00 1,874.09 100.00
10-533-502050 Life Insurance 241.76 184.39 0.00 57.37 23.73
10-533-502060 Long Term Disability 469.14 413.16 0.00 55.98 11.93
10-533-502070 Employee Assistance Prgm 78.58 72.96 0.00 5.62 7.15
E05 Personnel Services 231,639.51 197,386.15 0.00 34,253.36 14.79
10-533-511010 Advertising 106.23 106.23 0.00 0.00 0.00
10-533-511020 Postage 1,586.69 1,650.17 0.00 -63.48 -4.00
10-533-512010 Printing 254.00 254.00 0.00 0.00 0.00
10-533-512020 Copies 0.00 0.00 0.00 0.00 0.00
10-533-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00
10-533-513010 Office Supplies 1,097.18 1,075.33 0.00 21.85 1.99
10-533-514030 Small Tools 119.91 119.91 0.00 0.00 0.00
10-533-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00
10-533-517010 Operational Supplies 2,534.80 2,472.27 0.00 62.53 2.47
E10 Materials & Supplies 5,698.81 5,677.91 0.00 20.90 0.37
10-533-520030 Dues And Publications 314.98 314.98 0.00 0.00 0.00
GL - Trial Balance by Acct Type and Full Acct Number (10/09/2017 - 8:47 AM)Page 31
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-533-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-533-520070 Training And Education 1,487.19 997.00 0.00 490.19 32.96
10-533-522020 Professional Services 0.00 0.00 0.00 0.00 0.00
10-533-522021 Abatement 58,604.84 46,260.00 0.00 12,344.84 21.06
10-533-522022 Demo 23,500.00 23,500.00 0.00 0.00 0.00
10-533-522070 Legal Services 0.00 0.00 0.00 0.00 0.00
10-533-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00
10-533-529020 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00
E15 Contractual Services 83,907.01 71,071.98 0.00 12,835.03 15.30
10-533-534010 Telephone 0.00 0.00 0.00 0.00 0.00
E20 Utilities 0.00 0.00 0.00 0.00 0.00
10-533-541030 Vehicle Wash 270.00 270.00 0.00 0.00 0.00
10-533-546010 Clothing Expense 1,235.00 1,235.00 0.00 0.00 0.00
10-533-547010 Equipment Maintenance 30.00 0.00 0.00 30.00 100.00
10-533-547020 Maintenance Agreements 750.00 554.13 41.05 154.82 20.64
10-533-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00
E25 Repairs & Maintenance 2,285.00 2,059.13 41.05 184.82 8.09
10-533-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00
533 PPS - Prop MaintCode Enforce 323,530.33 276,195.17 41.05 47,294.11 14.62
534 Plan & Protect Svcs-Bldg Regs
10-534-501020 Salaries 241,926.10 211,510.34 0.00 30,415.76 12.57
10-534-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00
10-534-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00
10-534-501090 Overtime 70.00 0.00 0.00 70.00 100.00
10-534-501095 Overtime Straight Pay 12.00 0.00 0.00 12.00 100.00
10-534-502010 Social Security 16,937.83 14,847.24 0.00 2,090.59 12.34
10-534-502020 Group Health Insurance 50,309.21 43,416.14 0.00 6,893.07 13.70
10-534-502030 Retirement 35,795.72 31,303.62 0.00 4,492.10 12.55
10-534-502040 Workers Compensation 12.43 0.00 0.00 12.43 100.00
10-534-502050 Life Insurance 402.85 330.20 0.00 72.65 18.03
10-534-502060 Long Term Disability 796.31 688.49 0.00 107.82 13.54
10-534-502070 Employee Assistance Prgm 104.77 97.28 0.00 7.49 7.15
10-534-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 346,367.22 302,193.31 0.00 44,173.91 12.75
10-534-511010 Advertising 188.80 188.80 0.00 0.00 0.00
10-534-511020 Postage 1,000.00 1,056.84 0.00 -56.84 -5.68
10-534-512010 Printing 350.00 0.00 0.00 350.00 100.00
10-534-512020 Copies 15.00 0.00 0.00 15.00 100.00
10-534-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00
10-534-513010 Office Supplies 900.00 496.67 0.00 403.33 44.81
10-534-514030 Small Tools 150.00 39.88 0.00 110.12 73.41
10-534-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00
GL - Trial Balance by Acct Type and Full Acct Number (10/09/2017 - 8:47 AM)Page 32
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-534-517010 Operational Supplies 1,006.84 1,220.09 0.00 -213.25 -21.18
E10 Materials & Supplies 3,625.64 3,002.28 0.00 623.36 17.19
10-534-520030 Dues And Publications 3,270.66 3,270.66 0.00 0.00 0.00
10-534-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-534-520070 Training And Education 8,692.00 6,093.22 0.00 2,598.78 29.90
10-534-522020 Professional Services 0.00 0.00 0.00 0.00 0.00
10-534-522021 Abatement 0.00 0.00 0.00 0.00 0.00
10-534-522022 Demo 0.00 0.00 0.00 0.00 0.00
10-534-522070 Legal Services 0.00 0.00 0.00 0.00 0.00
10-534-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00
10-534-529020 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00
E15 Contractual Services 11,962.66 9,363.88 0.00 2,598.78 21.72
10-534-534010 Telephone 0.00 0.00 0.00 0.00 0.00
E20 Utilities 0.00 0.00 0.00 0.00 0.00
10-534-541030 Vehicle Wash 270.00 270.00 0.00 0.00 0.00
10-534-546010 Clothing Expense 1,727.33 1,018.00 0.00 709.33 41.07
10-534-547010 Equipment Maintenance 20.00 0.00 0.00 20.00 100.00
10-534-547020 Maintenance Agreements 983.57 795.35 33.91 154.31 15.69
10-534-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00
E25 Repairs & Maintenance 3,000.90 2,083.35 33.91 883.64 29.45
10-534-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00
534 Plan & Protect Svcs-Bldg Regs 364,956.42 316,642.82 33.91 48,279.69 13.23
535 Public Works-Central Maintenan
10-535-501020 Salaries 327,152.00 293,933.93 0.00 33,218.07 10.15
10-535-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00
10-535-501050 Parttime(wo Benefits)7,400.00 4,188.00 0.00 3,212.00 43.41
10-535-501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00
10-535-501090 Overtime 4,500.00 8,745.42 0.00 -4,245.42 -94.34
10-535-501095 Overtime Straight Pay 500.00 634.79 0.00 -134.79 -26.96
10-535-502010 Social Security 25,975.72 22,488.63 0.00 3,487.09 13.42
10-535-502020 Group Health Insurance 58,302.46 57,255.79 0.00 1,046.67 1.80
10-535-502030 Retirement 49,158.50 44,890.53 0.00 4,267.97 8.68
10-535-502040 Workers Compensation 2,260.55 2,260.55 0.00 0.00 0.00
10-535-502050 Life Insurance 630.60 457.79 0.00 172.81 27.40
10-535-502060 Long Term Disability 989.73 951.16 0.00 38.57 3.90
10-535-502070 Employee Assistance Prgm 183.36 170.24 0.00 13.12 7.16
10-535-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 477,052.92 435,976.83 0.00 41,076.09 8.61
10-535-511010 Advertising 80.00 43.75 0.00 36.25 45.31
10-535-511020 Postage 50.00 6.73 0.00 43.27 86.54
10-535-512020 Copies 10.00 0.00 0.00 10.00 100.00
GL - Trial Balance by Acct Type and Full Acct Number (10/09/2017 - 8:47 AM)Page 33
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-535-513010 Office Supplies 2,312.78 2,312.78 0.00 0.00 0.00
10-535-514011 Gas, Oil, & Antifreeze 0.00 0.00 0.00 0.00 0.00
10-535-514030 Small Tools 7,770.50 5,535.89 0.00 2,234.61 28.76
10-535-517010 Operational Supplies 6,416.72 5,969.73 0.00 446.99 6.97
E10 Materials & Supplies 16,640.00 13,868.88 0.00 2,771.12 16.65
10-535-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00
10-535-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-535-520070 Training And Education 2,000.00 1,942.09 0.00 57.91 2.90
10-535-521005 Tank Insurance 500.00 500.00 0.00 0.00 0.00
10-535-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00
10-535-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00
10-535-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00
E15 Contractual Services 2,500.00 2,442.09 0.00 57.91 2.32
10-535-531010 Electricity 7,560.00 6,212.70 0.00 1,347.30 17.82
10-535-533010 Natural Gas 6,942.89 5,563.70 0.00 1,379.19 19.86
10-535-534010 Telephone 220.00 199.20 0.00 20.80 9.45
10-535-535010 Water 1,400.00 1,155.68 0.00 244.32 17.45
E20 Utilities 16,122.89 13,131.28 0.00 2,991.61 18.56
10-535-540010 Building & Grounds Maint.15,000.00 18,638.11 60.00 -3,698.11 -24.65
10-535-541010 Veh & Equip Parts Etc 535,000.00 534,876.28 0.00 123.72 0.02
10-535-546010 Clothing Expense 5,500.00 4,941.90 -3,940.57 4,498.67 81.79
10-535-547010 Equipment Maintenance 3,000.00 1,837.23 0.00 1,162.77 38.76
10-535-547020 Maintenance Agreements 8,757.11 9,230.57 0.00 -473.46 -5.41
10-535-547030 Radio Maintenance 100.00 0.00 0.00 100.00 100.00
E25 Repairs & Maintenance 567,357.11 569,524.09 -3,880.57 1,713.59 0.30
10-535-572020 Purchase Of Equipment 17,500.00 16,515.00 0.00 985.00 5.63
E70 Capital Purchases 17,500.00 16,515.00 0.00 985.00 5.63
535 Public Works-Central Maintenan 1,097,172.92 1,051,458.17 -3,880.57 49,595.32 4.52
540 Public Works-Admin
10-540-501020 Salaries 204,518.14 183,850.15 0.00 20,667.99 10.11
10-540-501090 Overtime 0.00 0.00 0.00 0.00 0.00
10-540-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00
10-540-502010 Social Security 15,645.64 13,095.89 0.00 2,549.75 16.30
10-540-502020 Group Health Insurance 34,432.33 26,246.15 0.00 8,186.18 23.77
10-540-502030 Retirement 30,268.68 27,209.79 0.00 3,058.89 10.11
10-540-502040 Workers Compensation 115.27 115.27 0.00 0.00 0.00
10-540-502050 Life Insurance 397.56 288.51 0.00 109.05 27.43
10-540-502060 Long Term Disability 530.48 506.25 0.00 24.23 4.57
10-540-502070 Employee Assistance Prgm 78.58 72.96 0.00 5.62 7.15
E05 Personnel Services 285,986.68 251,384.97 0.00 34,601.71 12.10
10-540-511010 Advertising 0.00 0.00 0.00 0.00 0.00
10-540-511020 Postage 200.00 11.19 0.00 188.81 94.41
GL - Trial Balance by Acct Type and Full Acct Number (10/09/2017 - 8:47 AM)Page 34
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-540-512010 Printing 87.60 0.00 0.00 87.60 100.00
10-540-512020 Copies 100.00 0.00 0.00 100.00 100.00
10-540-513010 Office Supplies 250.00 0.00 0.00 250.00 100.00
10-540-514010 Gas 61,000.00 53,257.14 0.00 7,742.86 12.69
10-540-514040 Food 1,091.83 1,091.83 0.00 0.00 0.00
10-540-517010 Operational Supplies 650.00 6.50 0.00 643.50 99.00
E10 Materials & Supplies 63,379.43 54,366.66 0.00 9,012.77 14.22
10-540-520030 Dues And Publications 755.00 755.00 0.00 0.00 0.00
10-540-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-540-520070 Training And Education 4,165.57 4,124.59 0.00 40.98 0.98
10-540-522020 Professional Services 200.00 0.00 0.00 200.00 100.00
10-540-527010 Comm Serv Projects 0.00 0.00 0.00 0.00 0.00
E15 Contractual Services 5,120.57 4,879.59 0.00 240.98 4.71
10-540-534010 Telephone 0.00 0.00 0.00 0.00 0.00
E20 Utilities 0.00 0.00 0.00 0.00 0.00
10-540-547020 Maintenance Agreements 450.00 246.21 8.48 195.31 43.40
E25 Repairs & Maintenance 450.00 246.21 8.48 195.31 43.40
10-540-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00
540 Public Works-Admin 354,936.68 310,877.43 8.48 44,050.77 12.41
541 Public Works-Engineering
10-541-501020 Salaries 758,049.97 666,824.10 0.00 91,225.87 12.03
10-541-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00
10-541-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00
10-541-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00
10-541-501080 Step-up Pay 0.00 0.00 0.00 0.00 0.00
10-541-501090 Overtime 664.86 664.86 0.00 0.00 0.00
10-541-501095 Overtime Straight Pay 135.14 0.00 0.00 135.14 100.00
10-541-502010 Social Security 58,052.02 47,693.14 0.00 10,358.88 17.84
10-541-502020 Group Health Insurance 120,839.39 109,637.70 0.00 11,201.69 9.27
10-541-502030 Retirement 112,309.80 90,446.32 0.00 21,863.48 19.47
10-541-502040 Workers Compensation 3,639.97 3,639.97 0.00 0.00 0.00
10-541-502050 Life Insurance 1,474.68 1,033.53 0.00 441.15 29.91
10-541-502060 Long Term Disability 2,301.79 2,139.10 0.00 162.69 7.07
10-541-502070 Employee Assistance Prgm 314.32 291.80 0.00 22.52 7.16
10-541-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 1,057,781.94 922,370.52 0.00 135,411.42 12.80
10-541-511010 Advertising 621.19 514.00 0.00 107.19 17.26
10-541-511020 Postage 400.00 290.71 0.00 109.29 27.32
10-541-512010 Printing 100.00 38.00 0.00 62.00 62.00
10-541-512020 Copies 75.00 3.47 0.00 71.53 95.37
10-541-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00
GL - Trial Balance by Acct Type and Full Acct Number (10/09/2017 - 8:47 AM)Page 35
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-541-513010 Office Supplies 5,800.00 5,993.75 0.00 -193.75 -3.34
10-541-514030 Small Tools 133.21 0.00 0.00 133.21 100.00
10-541-514040 Food 286.95 286.95 0.00 0.00 0.00
10-541-515040 First Aid Supplies 50.00 10.18 0.00 39.82 79.64
10-541-515070 Const & Inspect Supplies 2,000.00 491.67 0.00 1,508.33 75.42
10-541-515080 Surveying Supplies 2,000.00 909.41 0.00 1,090.59 54.53
10-541-517010 Operational Supplies 1,677.88 1,677.88 0.00 0.00 0.00
E10 Materials & Supplies 13,144.23 10,216.02 0.00 2,928.21 22.28
10-541-520030 Dues And Publications 4,541.60 4,541.60 0.00 0.00 0.00
10-541-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-541-520070 Training And Education 3,000.00 3,088.01 0.00 -88.01 -2.93
10-541-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00
10-541-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00
10-541-522020 Professional Services 3,239.17 820.00 0.00 2,419.17 74.68
10-541-522055 Stormwater Compliance 1,500.00 73.08 0.00 1,426.92 95.13
E15 Contractual Services 12,280.77 8,522.69 0.00 3,758.08 30.60
10-541-534010 Telephone 500.00 420.95 0.00 79.05 15.81
E20 Utilities 500.00 420.95 0.00 79.05 15.81
10-541-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00
10-541-541030 Vehicle Wash 1,000.00 960.00 0.00 40.00 4.00
10-541-546010 Clothing Expense 1,000.00 607.18 0.00 392.82 39.28
10-541-547010 Equipment Maintenance 1,500.00 614.20 0.00 885.80 59.05
10-541-547020 Maintenance Agreements 12,400.00 8,221.95 40.57 4,137.48 33.37
10-541-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00
E25 Repairs & Maintenance 15,900.00 10,403.33 40.57 5,456.10 34.32
10-541-572010 Purchase of Vehicles 0.00 0.00 0.00 0.00 0.00
10-541-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00
10-541-576031 Misc Stormwater Projects 0.00 0.00 0.00 0.00 0.00
10-541-576035 SidewalkGreenway-JCMG 0.00 0.00 0.00 0.00 0.00
E75 Capital Projects 0.00 0.00 0.00 0.00 0.00
541 Public Works-Engineering 1,099,606.94 951,933.51 40.57 147,632.86 13.43
542 Public Works-Street
10-542-501020 Salaries 1,110,951.68 1,017,883.03 0.00 93,068.65 8.38
10-542-501060 Seasonal Salaries 18,000.00 13,198.63 0.00 4,801.37 26.67
10-542-501070 Stand-by Plan 5,000.00 4,012.00 0.00 988.00 19.76
10-542-501090 Overtime 34,536.83 27,686.14 0.00 6,850.69 19.84
10-542-501095 Overtime Straight Pay 963.17 1,011.60 0.00 -48.43 -5.03
10-542-502010 Social Security 89,463.05 78,874.82 0.00 10,588.23 11.84
10-542-502020 Group Health Insurance 189,300.56 167,327.42 0.00 21,973.14 11.61
10-542-502030 Retirement 170,414.84 139,326.75 0.00 31,088.09 18.24
10-542-502040 Workers Compensation 18,752.09 18,752.09 0.00 0.00 0.00
GL - Trial Balance by Acct Type and Full Acct Number (10/09/2017 - 8:47 AM)Page 36
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-542-502050 Life Insurance 2,157.00 1,536.40 0.00 620.60 28.77
10-542-502060 Long Term Disability 3,352.31 3,160.04 0.00 192.27 5.74
10-542-502070 Employee Assistance Prgm 667.42 619.60 0.00 47.82 7.16
10-542-503010 Awards Program 200.00 108.00 0.00 92.00 46.00
10-542-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 1,643,758.95 1,473,496.52 0.00 170,262.43 10.36
10-542-511010 Advertising 676.90 676.90 0.00 0.00 0.00
10-542-511020 Postage 150.00 39.17 0.00 110.83 73.89
10-542-512010 Printing 46.25 0.00 0.00 46.25 100.00
10-542-512020 Copies 10.00 0.00 0.00 10.00 100.00
10-542-513010 Office Supplies 1,655.75 1,655.75 0.00 0.00 0.00
10-542-514020 Chemicals 143,424.28 143,424.28 0.00 0.00 0.00
10-542-514030 Small Tools 9,000.00 8,959.58 0.00 40.42 0.45
10-542-514040 Food 2,000.00 1,932.47 0.00 67.53 3.38
10-542-515010 Stormwater Material 31.80 31.80 0.00 0.00 0.00
10-542-515020 Street Materials 355,358.09 316,033.02 2,000.00 37,325.07 10.50
10-542-515040 First Aid Supplies 468.20 285.10 0.00 183.10 39.11
10-542-515060 Weed Control 3,000.00 1,862.00 0.00 1,138.00 37.93
10-542-515070 Const & Inspect Supplies 144.25 0.00 0.00 144.25 100.00
10-542-517010 Operational Supplies 4,666.85 3,498.95 0.00 1,167.90 25.03
E10 Materials & Supplies 520,632.37 478,399.02 2,000.00 40,233.35 7.73
10-542-520030 Dues And Publications 983.00 983.00 0.00 0.00 0.00
10-542-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-542-520070 Training And Education 3,234.74 3,734.74 0.00 -500.00 -15.46
10-542-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00
10-542-522020 Professional Services 18,382.26 15,168.70 750.00 2,463.56 13.40
10-542-523010 Equipment Rentlease 200.00 77.06 0.00 122.94 61.47
10-542-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00
10-542-529070 Street Light Installation 0.00 0.00 0.00 0.00 0.00
E15 Contractual Services 22,800.00 19,963.50 750.00 2,086.50 9.15
10-542-531010 Electricity 26,582.38 20,191.80 0.00 6,390.58 24.04
10-542-531020 Street Lights 650,000.00 527,858.53 0.00 122,141.47 18.79
10-542-533010 Natural Gas 12,266.63 7,508.14 0.00 4,758.49 38.79
10-542-534010 Telephone 580.00 96.00 0.00 484.00 83.45
10-542-535010 Water 8,430.10 9,288.84 0.00 -858.74 -10.19
E20 Utilities 697,859.11 564,943.31 0.00 132,915.80 19.05
10-542-540010 Building & Grounds Maint.14,218.48 13,993.48 225.00 0.00 0.00
10-542-541030 Vehicle Wash 7,000.00 6,639.00 0.00 361.00 5.16
10-542-542010 Repairs - StopStreet Lights 21,787.84 20,277.22 0.00 1,510.62 6.93
10-542-542030 Signs & Marking Paint 35,156.05 31,490.65 0.00 3,665.40 10.43
10-542-546010 Clothing Expense 10,000.00 8,313.92 0.00 1,686.08 16.86
10-542-547010 Equipment Maintenance 2,851.52 1,388.27 0.00 1,463.25 51.31
10-542-547020 Maintenance Agreements 300.00 300.00 0.00 0.00 0.00
10-542-547030 Radio Maintenance 1,000.00 843.02 0.00 156.98 15.70
E25 Repairs & Maintenance 92,313.89 83,245.56 225.00 8,843.33 9.58
GL - Trial Balance by Acct Type and Full Acct Number (10/09/2017 - 8:47 AM)Page 37
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-542-572010 Purchase Of Vehicles 322,590.00 231,612.00 92,877.00 -1,899.00 -0.59
10-542-572020 Purchase Of Equipment 350,267.00 322,381.50 27,424.00 461.50 0.13
10-542-573030 Purchimprov Landbuildin 20,773.85 20,773.85 0.00 0.00 0.00
10-542-573050 Neighborhood Impr Projs 0.00 0.00 0.00 0.00 0.00
10-542-573060 Sidewalk Rep Program 0.00 0.00 0.00 0.00 0.00
10-542-573061 Street Crack Sealing 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 693,630.85 574,767.35 120,301.00 -1,437.50 -0.21
542 Public Works-Street 3,670,995.17 3,194,815.26 123,276.00 352,903.91 9.61
700 Transfers & Subsidies
10-700-590050 Transfer To Tif Fund 22,750.00 9,872.70 0.00 12,877.30 56.60
10-700-590065 Trans to Self-Funded Hlth Ins 0.00 0.00 0.00 0.00 0.00
10-700-590070 Airport Subsidy 258,459.28 258,459.28 0.00 0.00 0.00
10-700-590075 Transit Subsidy 1,007,265.64 1,007,265.64 0.00 0.00 0.00
10-700-590080 Transfer To Amb Serv 0.00 0.00 0.00 0.00 0.00
E80 Transfers Out 1,288,474.92 1,275,597.62 0.00 12,877.30 1.00
700 Transfers & Subsidies 1,288,474.92 1,275,597.62 0.00 12,877.30 1.00
900 CapitalVehicleEquipment
10-900-571010 Capvehclequip-city Admin 0.00 0.00 0.00 0.00 0.00
10-900-571020 Capvhcleqp-code Enf-adm 0.00 0.00 0.00 0.00 0.00
10-900-571030 Capvhcleqp-bldg Regs 0.00 0.00 0.00 0.00 0.00
10-900-571040 Capvhcleqp-envir Health 0.00 0.00 0.00 0.00 0.00
10-900-571050 Capvhcleqp-p & Transp-adm 0.00 0.00 0.00 0.00 0.00
10-900-571060 Capvhcleqp-pub Works-adm 0.00 0.00 0.00 0.00 0.00
10-900-571070 Capvhcleqp-engineering 0.00 0.00 0.00 0.00 0.00
10-900-571080 Capvhcleqp-street 0.00 0.00 0.00 0.00 0.00
10-900-571090 Capvhcleqp-police 0.00 0.00 0.00 0.00 0.00
10-900-571100 Capvhcleqp-fire 0.00 0.00 0.00 0.00 0.00
10-900-571110 Capvhcleqp-Animal Control 0.00 0.00 0.00 0.00 0.00
10-900-571120 Capvhcleqp-central Maint 0.00 0.00 0.00 0.00 0.00
10-900-571130 Capvhcleqp-airport 0.00 0.00 0.00 0.00 0.00
10-900-571140 Capvhcleqp-contingency 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00
900 CapitalVehicleEquipment 0.00 0.00 0.00 0.00 0.00
990 Capital Projects
10-990-575015 Police HVAC 0.00 0.00 0.00 0.00 0.00
10-990-576007 Stormwater Improvements 750,000.00 0.00 0.00 750,000.00 100.00
10-990-577042 Mo Blvd Sidewalks 0.00 0.00 0.00 0.00 0.00
10-990-577044 Water Street @ Lohman Landing 0.00 0.00 0.00 0.00 0.00
10-990-577045 Clay Street Plaza 0.00 0.00 0.00 0.00 0.00
10-990-577046 Hwy 54 & Stadium Interchange 396,891.29 263,336.99 114,764.01 18,790.29 4.73
10-990-577054 Wayfinding 124,354.97 111,854.97 0.00 12,500.00 10.05
10-990-577056 SOMO Sewer Extension 300,000.00 300,000.00 0.00 0.00 0.00
GL - Trial Balance by Acct Type and Full Acct Number (10/09/2017 - 8:47 AM)Page 38
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-990-577058 Downtown Electric 23,500.00 12,375.00 11,125.00 0.00 0.00
10-990-577060 Ongoing InfrastFacility Needs 288,500.00 11,784.80 0.00 276,715.20 95.92
10-990-577063 Clark Avenue 93,658.26 0.00 0.00 93,658.26 100.00
10-990-577064 Broadway St Sidewalk 0.00 0.00 0.00 0.00 0.00
10-990-577065 South Lincoln Street 61,800.00 39,483.85 22,316.15 0.00 0.00
10-990-577066 Stormwater Projects 0.00 0.00 0.00 0.00 0.00
10-990-590071 Mo Blvd1400-1800 Block 278,564.00 0.00 0.00 278,564.00 100.00
E75 Capital Projects 2,317,268.52 738,835.61 148,205.16 1,430,227.75 61.72
990 Capital Projects 2,317,268.52 738,835.61 148,205.16 1,430,227.75 61.72
Expense Expense 36,697,807.96 30,414,270.92 625,979.51 5,657,557.53 15.42
GL - Trial Balance by Acct Type and Full Acct Number (10/09/2017 - 8:47 AM)Page 39
CITY OF JEFFERSON
FISCAL YEAR 2017 ESTIMATED FUND BALANCE
FYE2016 UNASSIGNED FUND BALANCE (Audited)8,844,970.00$
FYE2016 Fund Balance % of Adopted Budget 28.77%
Reappropriations from FY2016 to FY2017
Remaining Funds from Sale of Old Fire Station #3 (111,788.00)$
MECO Design Contract for Downtown Electric (12,000.00)$
Remaining Funds for Compensation & Class Study (20,754.89)$
Upgrade for Food Inspection Software (1,474.00)$
Remaining balance for court softward project (5,563.24)$
SOMO Sewer Extension (300,000.00)$
Remaining Funds for Public Art (3,665.00)$
NRA Rental Façade (15,066.00)$
NSP Rehab Sales (350.00)$
(470,661.13)$
2017 Adjustments/Supplementals
FY2017 Supplemental Appropriations:
Matching for professional services grant for Capital Area MPO (2,250.00)$
Fire Apparatus Lease Payoff (1,163,313.93)$
Professional Legal Services (Buescher case)(17,000.00)$
Columbia Regional Airport air service guarantee participation (100,000.00)$
Port Feasibility Study (47,600.00)$
Design of South Lincoln Street slope stabilization (61,800.00)$
Stormwater repairs and improvements (750,000.00)$
Legal fees for Mo American Water Tariff Case (20,000.00)$
(2,161,963.93)$
2017 Release of Restricted Funds - Parks Multipurpose Building 1,500,000.00$
FYE2017 ESTIMATED Unassigned Fund Balance 7,712,344.94$
FYE2017 ESTIMATED Fund Balance % of Adopted Budget 23.94%
Tax Period
Due Date to
City Total Lodging Tax JCCVB (3/7)
JCCVB/Tourism Fund
(4/7)**
May-11 6/20/11 91,258.41 38,328.53 51,104.71
Jun-11 7/20/11 101,479.82 42,621.54 56,828.68
Jul-11 8/20/11 88,392.47 37,124.82 49,499.80
Aug-11 9/20/11 73,144.02 30,720.48 40,960.66
Sep-11 10/20/11 103,618.61 43,519.80 58,026.44
Oct-11 11/20/11 105,531.99 44,323.44 59,097.91
Nov-11 12/20/11 66,556.88 27,953.89 37,271.85
Dec-11 1/20/12 52,204.97 21,926.07 29,234.80
Jan-12 2/20/12 65,645.72 27,571.20 36,761.61
566.37 Interest Received
Feb-12 3/20/12 85,143.89 35,760.45 47,680.56
383.96 4/2012 Interest Received
Mar-12 4/20/12 81,904.23 34,399.77 45,866.38
636.05 5/2012 Interest Received
(8.11) 5/2012 Service Charge
Apr-12 5/20/12 103,406.71 43,430.82 57,907.76
685.97 6/2012 Interest Received
(7.25) 6/2012 Service Charge
May-12 6/20/12 89,713.24 37,679.58 50,239.40
785.01 7/2012 Interest Received
(7.25) 7/2012 Service Charge
Jun-12 7/20/12 86,753.72 36,436.56 48,582.08
832.99 8/2012 Interest Received
(7.25) 8/2012 Service Charge
Jul-12 8/20/12 89,904.69 37,759.97 50,346.63
Aug-12 9/20/12 76,708.71 32,217.66 42,956.88
887.55 9/2012 Interest Received
(7.25) 9/2012 Service Charge
987.59 10/2012 Interest Received
(7.50) 10/2012 Service Charge
Sep-12 10/20/12 109,335.16 45,920.77 61,227.69
1,011.18 11/2012 Interest Received
(7.00) 11/2012 Service Charge
Oct-12 11/20/12 109,059.34 45,804.92 61,073.23
45,804.92 JCCVB 3/7 Check Deposited in Error
1,166.54 12/2012 Interest Received
(7.50) 12/2012 Service Charge
Nov-12 12/20/12 69,756.75 29,297.84 39,063.77
(45,804.92) Correction of Deposit Error
1,185.18 1/2013 Interest Received
(7.33) 1/2013 Service Charge
Dec-12 1/20/13 55,126.67 23,153.20 30,870.94
1,108.23 2/2013 Interest Received
(7.35) 2/2013 Service Charge
Jan-13 2/20/13 84,295.92 35,404.29 47,205.71
1,271.02 3/2013 Interest Received
(8.28) 3/2013 Service Charge
Feb-13 3/20/13 84,199.16 35,363.65 47,151.53
1,297.26 4/2013 Interest Received
(8.28) 4/2013 Service Charge
Mar-13 4/20/13 98,008.06 41,163.39 54,884.51
1,413.79 5/2013 Interest Received
(7.37) 5/2013 Service Charge
Apr-13 5/20/13 100,022.48 42,009.44 56,012.59
Tax Period
Due Date to
City Total Lodging Tax JCCVB (3/7)
JCCVB/Tourism Fund
(4/7)**
1,450.30 6/2013 Interest Received
(8.56) 6/2013 Service Charge
(10,000.00) Ck #50 - C H Johnson Consulting
May-13 6/20/13 97,602.44 40,993.02 54,657.37
1,570.41 7/2013 Interest Received
(8.45) 7/2013 Service Charge
(1,187.09) Ck #1001 - C H Johnson Consulting
Jun-13 7/20/13 92,796.57 38,974.56 51,966.08
1,620.41 8/2013 Interest Received
(8.45) 8/2013 Service Charge
(33.25) Ck #1002 - City of Jefferson - RFP Ad
(15,000.00) Ck #1003 - C H Johnson Consulting
(10,000.00) Ck #1004 - C H Johnson Consulting
Jul-13 8/20/13 93,352.06 39,207.87 52,277.15
1,606.48 9/2013 Interest Received
(8.79) 9/2013 Service Charge
(5,000.00) Ck #1005 - C H Johnson Consulting
Aug-13 9/20/13 89,778.97 37,707.17 50,276.22
1,726.08 10/2013 Interest Received
(8.45) 10/2013 Service Charge
(3,000.00) Ck #1006 - C H Johnson Consulting
Sep-13 10/20/13 108,879.17 45,729.25 60,972.34
1,728.36 11/2013 Interest Received
(8.45) 11/2013 Service Charge
Oct-13 11/20/13 120,248.83 50,504.51 67,339.34
1,864.47 12/2013 Interest Received
(8.28) 12/2013 Service Charge
Nov-13 12/20/13 84,253.54 35,386.49 47,181.98
1,918.75 1/2014 Interest Received
(8.28) 1/2014 Service Charge
Dec-13 1/20/14 63,745.74 26,773.21 35,697.61
1,807.90 2/2014 Interest Received
(8.28) 2/2014 Service Charge
Jan-14 2/20/14 92,051.62 38,661.68 51,548.91
(1,562.61) Ck #1007 - C H Johnson Consulting
2,078.72 3/2014 Interest Received
(8.45) 3/2014 Service Charge
Feb-14 3/20/14 80,825.68 33,946.79 45,262.38
2,052.68 4/2014 Interest Received
(8.28) 4/2014 Service Charge
Mar-14 4/30/14 106,553.94 44,752.65 59,670.21
2,198.76 5/2014 Interest Received
(8.29) 5/2014 Service Charge
Apr-14 5/20/14 104,278.69 43,797.05 58,396.07
2,203.13 6/2014 Interest Received
(8.29) 6/2014 Service Charge
May-14 6/20/14 116,059.44 48,744.96 64,993.29
2,391.04 7/2014 Interest Received
(8.29) 7/2014 Service Charge
Jun-14 7/20/14 104,333.69 43,820.15 58,426.87
2,457.38 8/2014 Interest Received
(8.29) 8/2014 Service Charge
Jul-14 8/20/14 98,901.39 41,538.58 55,384.78
2,459.73 9/2014 Interest Received
Tax Period
Due Date to
City Total Lodging Tax JCCVB (3/7)
JCCVB/Tourism Fund
(4/7)**
(8.29) 9/2014 Service Charge
Aug-14 9/20/14 75,962.88 31,904.41 42,539.21
2,593.43 10/2014 Interest Received
(8.29) 10/2014 Service Charge
Sep-14 10/20/14 112,370.02 47,195.41 62,927.21
2,586.87 11/2014 Interest Received
(8.29) 11/2014 Service Charge
Oct-14 11/20/14 116,992.89 49,137.01 65,516.02
2,736.57 12/2014 Interest Received
(14.65) 12/2014 Service Charge
Nov-14 12/20/14 72,761.33 30,559.76 40,746.34
2,798.53 1/2015 Interest Received
(8.29) 1/2015 Service Charge
Dec-14 1/20/15 60,394.73 25,365.79 33,821.05
2,575.56 2/2015 Interest Received
(8.29) 2/2015 Service Charge
Jan-15 2/20/15 85,741.83 36,011.57 48,015.42
2,935.34 3/2015 Interest Received
(8.29) 3/2015 Service Charge
Feb-15 3/20/15 84,317.61 35,413.40 47,217.86
2,911.14 4/2015 Interest Received
(10.54) 4/2015 Service Charge
Mar-15 4/20/15 114,789.97 48,211.79 64,282.38
3,049.41 5/2015 Interest Received
(8.29) 5/2015 Service Charge
Apr-15 5/20/15 102,479.43 43,041.36 57,388.48
3,046.67 6/2015 Interest Received
(8.29) 6/2015 Service Charge
May-15 6/20/15 116,174.48 48,793.28 65,057.71
3,217.49 7/2015 Interest Received
(8.29) 7/2015 Service Charge
Jun-15 7/31/15 97,379.11 40,899.23 54,532.30
3,287.90 8/2015 Interest Received
(10.67) 8/2015 Service Charge
Jul-15 8/20/15 102,541.78 43,067.55 57,423.40
3,307.41 9/2015 Interest Received
(8.58) 9/2015 Service Charge
Aug-15 9/20/15 81,248.87 34,124.53 45,499.37
3,476.74 10/2015 Interest Received
(8.29) 10/2015 Service Charge
Sep-15 10/20/15 102,709.81 43,138.12 57,517.49
3,421.47 11/2015 Interest Received
(8.00) 11/2015 Service Charge
Oct-15 12/1/15 107,837.70 45,291.83 60,389.11
3,605.14 12/2015 Interest Received
(8.29) 12/2015 Service Charge
Nov-15 12/31/15 67,119.58 28,190.22 37,586.96
Sep-15 1,908.92 801.75 1,069.00 late pays
3,666.35 1/2016 Interest Received
(8.29) 1/2016 Service Charge
Dec-15 1/31/16 66,959.22 28,122.88 37,497.16
3,478.72 2/2016 Interest Received
(8.49) 2/2016 Service Charge
Jan-16 2/20/16 83,239.99 34,960.80 46,614.39
Tax Period
Due Date to
City Total Lodging Tax JCCVB (3/7)
JCCVB/Tourism Fund
(4/7)**
3,786.20 3/2016 Interest Received
(8.28) 3/2016 Service Charge
Feb-16 3/20/16 97,559.96 40,975.18 54,633.58
3,718.19 4/2016 Interest Received
(8.27) 4/2016 Service Charge
Mar-16 4/29/16 101,134.20 42,476.36 56,635.16
3,914.86 5/2016 Interest Received
(8.26) 5/2016 Service Charge
Apr-16 5/20/16 140,992.87 59,217.01 78,956.01
3,905.43 6/2016 Interest Received
May-16 6/20/16 112,152.91 47,104.22 62,805.63
3,985.42 7/2016 Interest Received
Jun-16 7/31/16 106,704.37 44,815.83 59,754.44
4,207.43 8/2016 Interest Received
Jul-16 8/20/16 96,811.40 40,660.79 54,214.38
4,136.69 9/2016 Interest Received
Aug-16 9/20/16 88,674.86 37,243.44 49,657.92
4,350.78 10/2016 Interest Received
Sep-16 10/31/16 100,606.10 42,254.56 56,339.42
4,292.30 11/2016 Interest Received
Oct-16 11/20/16 120,471.15 50,597.88 67,463.85
4,531.06 12/2016 Interest Received
Nov-16 12/20/16 88,755.07 37,277.13 49,702.83
4,602.85 1/2017 Interest Received
Dec-16 1/31/17 65,709.30 27,597.91 36,797.21
4,207.06 2/2017 Interest Received
Jan-17 2/20/17 95,905.35 40,280.25 53,706.99
4,726.10 3/2017 Interest Received
Feb-17 3/31/17 95,135.98 39,957.11 53,276.15
4,651.72 4/2017 Interest Received
Mar-17 4/30/17 111,370.63 46,775.67 62,367.55
4,885.76 5/2017 Interest Received
Apr-17 5/30/17 109,652.93 46,054.23 61,405.64
4,807.94 6/2017 Interest Received
May-17 6/30/17 123,148.39 51,722.32 68,963.10
5,089.00 7/2017 Interest Received
Jun-17 7/31/17 120,310.25 50,530.30 67,373.74
5,141.00 8/2017 Interest Received
Jul-17 8/20/17 101,096.32 42,460.45 56,613.94
5,081.97 9/2017 Interest Received
Aug-17 9/30/17 99,136.13 41,637.18 55,516.23
Total 7,153,091.71 3,004,298.53 4,141,609.37
average monthly amount for 4 cent lockbox fund 52,022.49$
**Effective for 25 years starting in 2011
2017 Occupancy 2016 Occupancy 2015 Occupancy 2014 Occupancy 2013 Occupancy 2012 Occupancy
January 48.70%51.30%45.90%49.20%45.30%38.20%
February 56.80%58.60%51.20%56.00%52.90%49.80%
March 62.20%59.80%59.80%59.30%52.90%54.90%
April 62.40%67.20%58.10%63.70%64.10%53.90%
May 63.80%64.90%63.10%64.70%56.80%53.70%
June 70.40%64.00%59.70%63.70%55.70%53.10%
July 65.90%58.20%60.80%59.70%58.50%51.40%
August 61.50%56.50%52.60%54.20%55.80%47.00%
September 62.60%63.30%61.20%63.00%59.30%
October 62.90%60.70%67.60%65.90%59.30%
November 50.60%51.30%48.90%52.40%43.40%
December 42.10%45.10%38.30%38.80%33.00%
COMPARATIVE OCCUPANCY RATE
Ta
b
2
-
M
u
l
t
i
-
S
e
g
m
e
n
t
Currency: USD - US Dollar
Mi
s
s
o
u
r
i
H
o
t
e
l
&
L
o
d
g
i
n
g
A
s
s
o
c
i
a
t
i
o
n
Fo
r
t
h
e
m
o
n
t
h
o
f
:
A
u
g
u
s
t
2
0
1
7
Pe
r
c
e
n
t
C
h
a
n
g
e
f
r
o
m
A
u
g
u
s
t
2
0
1
6
Pe
r
c
e
n
t
C
h
a
n
g
e
f
r
o
m
Y
T
D
2
0
1
6
20
1
7
2
0
1
6
2
0
1
7
2
0
1
6
2
0
1
7
2
0
1
6
O
c
c
A
D
R
R
e
v
P
A
R
Ro
o
m
Re
v
Ro
o
m
Av
a
i
l
Ro
o
m
So
l
d
20
1
7
2
0
1
6
2
0
1
7
2
0
1
6
2
0
1
7
2
0
1
6
O
c
c
A
D
R
R
e
v
P
A
R
Ro
o
m
Re
v
Room AvailRoom Sold Census
S
a
m
p
l
e
C
e
n
s
u
s
S
a
m
p
l
e
Un
i
t
e
d
S
t
a
t
e
s
7
0
.
7
7
0
.
1
1
2
7
.
6
9
1
2
5
.
6
4
9
0
.
3
1
8
8
.
0
8
0
.
9
1
.
6
2
.
5
4
.
4
1
.
9
2
.
8
6
7
.
1
6
6
.
8
1
2
6
.
9
5
1
2
4
.
3
1
8
5
.
2
1
8
3
.
0
1
0
.
5
2
.
1
2
.
7
4
.
5
1
.
8
2
.
4
5
4
9
5
6
3
3
0
5
4
5
1
6
6
7
4
5
3
818501
We
s
t
N
o
r
t
h
C
e
n
t
r
a
l
6
7
.
6
6
7
.
4
1
0
3
.
3
6
1
0
1
.
2
0
6
9
.
8
4
6
8
.
2
1
0
.
3
2
.
1
2
.
4
3
.
9
1
.
5
1
.
7
5
9
.
4
6
0
.
0
9
8
.
0
8
9
6
.
3
7
5
8
.
2
5
5
7
.
8
6
-
1
.
1
1
.
8
0
.
7
2
.
0
1
.
3
0
.
2
4
6
1
7
2
7
5
3
3
6
0
2
5
3
263481
Mi
s
s
o
u
r
i
6
5
.
8
6
3
.
4
1
0
3
.
4
5
9
8
.
0
1
6
8
.
0
5
6
2
.
1
8
3
.
7
5
.
5
9
.
5
1
0
.
4
0
.
8
4
.
6
6
2
.
1
6
2
.
2
9
9
.
6
3
9
5
.
6
9
6
1
.
8
6
5
9
.
4
7
-
0
.
1
4
.
1
4
.
0
4
.
4
0
.
3
0
.
2
1
1
1
8
6
5
2
1
0
2
1
0
1
7
3
0
4
1
Ka
n
s
a
s
C
i
t
y
,
M
O
-
K
S
7
1
.
4
6
8
.
2
1
0
8
.
5
1
9
9
.
8
5
7
7
.
4
7
6
8
.
1
0
4
.
7
8
.
7
1
3
.
8
1
1
.
6
-
1
.
9
2
.
7
6
7
.
6
6
5
.
5
1
0
4
.
1
6
9
9
.
3
5
7
0
.
3
7
6
5
.
0
9
3
.
1
4
.
8
8
.
1
5
.
9
-
2
.
1
1
.
0
2
9
1
2
3
1
3
2
2
0
4
27530
St
L
o
u
i
s
,
M
O
-
I
L
6
9
.
7
6
8
.
0
1
0
8
.
8
5
1
0
2
.
5
7
7
5
.
9
0
6
9
.
7
9
2
.
5
6
.
1
8
.
8
1
0
.
8
1
.
9
4
.
5
6
7
.
1
6
7
.
4
1
0
5
.
5
1
1
0
1
.
3
1
7
0
.
8
2
6
8
.
2
5
-
0
.
4
4
.
1
3
.
8
5
.
2
1
.
4
1
.
0
3
3
2
2
5
1
3
8
7
4
6
3
3
3
20
Co
l
u
m
b
i
a
,
M
O
+
6
8
.
6
6
0
.
4
9
1
.
5
1
8
1
.
7
1
6
2
.
7
9
4
9
.
3
6
1
3
.
6
1
2
.
0
2
7
.
2
2
5
.
6
-
1
.
3
1
2
.
1
6
2
.
9
6
1
.
1
8
7
.
1
9
8
6
.
2
9
5
4
.
8
1
5
2
.
7
5
2
.
8
1
.
0
3
.
9
0
.
3
-
3
.
4
-
0
.
7
3
8
3
0
3
8
0
4
3
1
7
6
Je
f
f
e
r
s
o
n
C
i
t
y
,
M
O
+
6
1
.
5
5
9
.
3
8
0
.
2
3
7
4
.
0
2
4
9
.
3
3
4
3
.
8
6
3
.
8
8
.
4
1
2
.
5
1
2
.
5
0
.
0
3
.
8
6
1
.
7
6
2
.
6
7
9
.
5
3
7
7
.
9
5
4
9
.
0
6
4
8
.
8
0
-
1
.
5
2
.
0
0
.
5
0
.
5
0
.
0
-
1
.
5
1
5
1
1
1
4
9
4
1
0
6
3
Sp
r
i
n
g
f
i
e
l
d
,
M
O
6
9
.
9
6
4
.
7
8
5
.
5
7
8
1
.
1
2
5
9
.
8
5
5
2
.
4
9
8
.
1
5
.
5
1
4
.
0
1
4
.
0
0
.
0
8
.
1
6
4
.
1
6
2
.
8
8
3
.
2
9
8
0
.
2
9
5
3
.
3
6
5
0
.
4
5
1
.
9
3
.
7
5
.
8
5
.
7
-
0
.
1
1
.
9
6
8
4
4
6
0
8
8
4
1
9
8
Br
a
n
s
o
n
,
M
O
5
2
.
6
5
2
.
8
1
0
6
.
6
4
1
0
7
.
4
4
5
6
.
1
0
5
6
.
7
0
-
0
.
3
-
0
.
7
-
1
.
1
-
0
.
8
0
.
3
-
0
.
1
5
1
.
2
5
1
.
7
1
0
1
.
9
3
9
9
.
5
2
5
2
.
2
1
5
1
.
4
3
-
0
.
9
2
.
4
1
.
5
1
.
6
0
.
1
-
0
.
8
1
5
0
3
3
1
3
5
5
1
4
3
8
8
La
k
e
o
f
t
h
e
O
z
a
r
k
s
+
5
7
.
2
5
5
.
5
1
1
3
.
6
6
1
1
2
.
1
7
6
4
.
9
9
6
2
.
2
2
3
.
1
1
.
3
4
.
5
2
.
1
-
2
.
2
0
.
8
5
0
.
7
5
0
.
2
1
0
5
.
3
6
1
0
4
.
1
8
5
3
.
4
2
5
2
.
3
0
1
.
0
1
.
1
2
.
1
1
.
3
-
0
.
9
0
.
1
3
6
1
2
2
7
1
2
1
6
89
Jo
p
l
i
n
,
M
O
6
3
.
7
6
0
.
0
9
0
.
9
7
8
7
.
9
5
5
7
.
9
9
5
2
.
7
5
6
.
3
3
.
4
9
.
9
9
.
8
-
0
.
1
6
.
2
6
3
.
6
6
1
.
7
8
2
.
8
4
8
0
.
2
6
5
2
.
7
1
4
9
.
5
2
3
.
1
3
.
2
6
.
4
6
.
4
-
0
.
1
3
.
1
3
0
2
3
2
2
9
8
2
0
0
9
Sa
i
n
t
J
o
s
e
p
h
,
M
O
+
6
2
.
5
6
4
.
6
1
0
3
.
2
0
8
7
.
5
1
6
4
.
5
3
5
6
.
4
9
-
3
.
1
1
7
.
9
1
4
.
2
2
5
.
4
9
.
8
6
.
3
5
9
.
9
6
1
.
4
8
9
.
2
4
8
4
.
3
8
5
3
.
4
3
5
1
.
8
1
-
2
.
5
5
.
8
3
.
1
5
.
7
2
.
5
-
0
.
1
1
3
1
1
1
2
1
4
1
1
0
7
A
b
l
a
n
k
r
o
w
i
n
d
i
c
a
t
e
s
i
n
s
u
f
f
i
c
i
e
n
t
d
a
t
a
.
Participation
Oc
c
%
Cu
r
r
e
n
t
M
o
n
t
h
-
A
u
g
u
s
t
2
0
1
7
v
s
A
u
g
u
s
t
2
0
1
6
Th
e
S
T
R
D
e
s
t
i
n
a
t
i
o
n
R
e
p
o
r
t
i
s
a
p
u
b
l
i
c
a
t
i
o
n
o
f
S
T
R
,
I
n
c
.
a
n
d
S
T
R
G
l
o
b
a
l
,
L
t
d
.
,
a
n
d
i
s
i
n
t
e
n
d
e
d
s
o
l
e
l
y
f
o
r
u
s
e
b
y
p
a
i
d
s
u
b
s
c
r
i
b
e
rs
.
R
e
p
r
o
d
u
c
t
i
o
n
o
r
d
i
s
t
r
i
b
u
t
i
o
n
o
f
t
h
e
S
T
R
D
e
s
t
i
n
a
t
i
o
n
R
e
p
o
r
t
,
i
n
w
h
o
l
e
o
r
p
a
r
t
,
w
i
t
h
o
u
t
w
r
i
t
t
e
n
p
e
r
m
i
s
s
i
o
n
i
s
p
r
o
h
i
b
i
t
e
d
a
n
d
su
b
j
e
c
t
t
o
l
e
g
a
l
a
c
t
i
o
n
.
I
f
y
o
u
h
a
v
e
r
e
c
e
i
v
e
d
t
h
i
s
r
e
p
o
r
t
a
n
d
a
r
e
N
O
T
a
s
u
b
s
c
r
i
b
e
r
t
o
t
h
e
S
T
R
D
e
s
t
i
n
a
t
i
o
n
Re
p
o
r
t
,
p
l
e
a
s
e
c
o
n
t
a
c
t
u
s
i
m
m
e
d
i
a
t
e
l
y
.
S
o
u
r
c
e
:
2
0
1
7
S
T
R
,
I
n
c
.
/
S
T
R
G
l
o
b
a
l
,
L
t
d
.
t
r
a
d
i
n
g
a
s
"
S
T
R
"
.
Re
v
P
A
R
AD
R
Oc
c
%
Ye
a
r
t
o
D
a
t
e
-
A
u
g
u
s
t
2
0
1
7
v
s
A
u
g
u
s
t
2
0
1
6
Rooms
Re
v
P
A
R
Properties
AD
R
Ta
b
3 ‐
He
l
p
Gl
o
s
s
a
r
y
:
Fr
e
q
u
e
n
t
l
y
A
s
k
e
d
Q
u
e
s
t
i
o
n
s
(
F
A
Q
)
:
No
r
t
h
A
m
e
r
i
c
a
:
I
n
t
e
r
n
a
t
i
o
n
a
l
:
73
5
E
a
s
t
M
a
i
n
S
t
r
e
e
t
,
H
e
n
d
e
r
s
o
n
v
i
l
l
e
,
T
N
3
7
0
7
5
U
S
A
B
l
u
e
F
i
n
B
u
i
l
d
i
n
g
,
1
1
0
S
o
u
t
h
w
a
r
k
S
t
r
e
e
t
,
L
o
n
d
o
n
S
E
1
0
T
A
T
:
+
1
6
1
5
8
2
4
8
6
6
4
T
:
+
4
4
(
0
)
2
0
7
9
2
2
1
9
3
0
ho
t
e
l
i
n
f
o
@
s
t
r
.
c
o
m
As
i
a
P
a
c
i
f
i
c
:
Th
o
n
g
T
e
c
k
B
u
i
l
d
i
n
g
,
1
5
S
c
o
t
t
s
R
o
a
d
#
0
8
-
1
2
,
2
2
8
2
1
8
S
i
n
g
a
p
o
r
e
T:
+
6
4
6
8
0
0
7
8
5
0
Fo
r
a
l
l
S
T
R
F
A
Q
s
,
p
l
e
a
s
e
c
l
i
c
k
h
e
r
e
o
r
v
i
s
i
t
w
w
w
.
s
t
r
.
c
o
m
/
r
e
s
o
u
r
c
e
s
/
f
a
q
Fo
r
t
h
e
l
a
t
e
s
t
i
n
i
n
d
u
s
t
r
y
n
e
w
s
,
v
i
s
i
t
H
o
t
e
l
N
e
w
s
N
o
w
.
c
o
m
.
su
p
p
o
r
t
@
s
t
r
.
c
o
m
Fo
r
a
l
l
S
T
R
d
e
f
i
n
i
t
i
o
n
s
,
p
l
e
a
s
e
v
i
s
i
t
w
w
w
.
s
t
r
.
c
o
m
/
r
e
s
o
u
r
c
e
s
/
g
l
o
s
s
a
r
y
To
l
e
a
r
n
m
o
r
e
a
b
o
u
t
t
h
e
H
o
t
e
l
D
a
t
a
C
o
n
f
e
r
e
n
c
e
,
v
i
s
i
t
H
o
t
e
l
D
a
t
a
C
o
n
f
e
r
e
n
c
e
.
c
o
m
.
ap
i
n
f
o
@
s
t
r
.
c
o
m
Pl
e
a
s
e
v
i
s
i
t
o
u
r
w
e
b
s
i
t
e
a
t
w
w
w
.
s
t
r
.
c
o
m
,
o
r
i
f
y
o
u
n
e
e
d
a
d
d
i
t
i
o
n
a
l
a
s
s
i
s
t
a
n
c
e
p
l
e
a
s
e
r
e
a
c
h
o
u
t
t
o
o
u
r
C
u
s
t
o
m
e
r
S
u
p
p
o
r
t
t
e
a
m
.
DEPARTMENT OF PLANNING AND PROTECTIVE SERVICES
MEMORANDUM
TO: Finance Committee
THROUGH: Sonny Sanders, Director of Planning and Protective Services
FROM: Jayme Abbott, Neighborhood Services Manager
DATE: October 2, 2017
RE: Property Inspection Software
Resolution 2014-21 encouraged staff to utilize all tools to affirmatively and proactively address
neighborhood code enforcement issues. Since February 2016, code enforcement has gone
through several changes including staff, program structure, stream lining reporting, code
review, etc. As of August 31, 2017, staff has investigated 2,678 code enforcement activities with
a 92% voluntary compliance prior to abatement, hearings or summons. Also, Property
Maintenance Inspectors are on track to double FY16 code enforcement activity of 1,651.
In an effort to continue improving code enforcement, a workflow exercise was completed to
document the average cost from the beginning action of the initial inspection of the property to
the end action of abatement and closing the activity out in Springbrook. The complete process
takes approximately 4 hours of the inspector time or $233.84 per code enforcement activity.
The cost to the City was determined by taking the direct and indirect cost per property inspector
then divide by the number of hours one would work in the year (Per communication with
Margaret Mueller). The average total cost, direct and indirect, per property inspector employee
is $121,595 divided by 2,080 hours equals $58.46 an hour, multiplied by 4 hours equals $233.84
per code enforcement activity/process.
Current process requires multiple trips to and from City Hall to check status in Springbrook,
post property, send letter and upload photos into database. This process causes the Property
Inspector to be reactive verses proactive.
While completing the workflow exercise staff took the opportunity to compare the same process
with computer software offering mobile app program and citizen portal. A mobile app program
would allow the Property Maintenance Inspectors to remain out in the field longer, accessing
the City’s financial software to look up property status in real time and therefore taking
proactive actions. In addition, the citizen portal allows the public to report issues, check on
status and/or see if an issue has already been reported.
If the Property Inspector is inspecting a concern reported through the citizen portal, he would
not only be able to take a photo, upload the photo, identify nuisance violations, print letter from
field (print out at City Hall), but also respond to citizen regarding action taken. It is estimated
that the computer software program with mobile app and citizen portal would provide increased
productivity of approximately $86,000 in staff time which would be comparable to ¾ Full Time
Employee. This increase in effectiveness and efficiency would allow inspection of more
properties.
In reviewing several available software vendors, with support of Information Technology, staff
estimates the initial cost for such software to be less than $30,000, hardware cost to be less than
$3,000 and cellular service to be approximately $1,800. These costs estimates include:
• Software and remote access field computers for 5 inspectors
• Software for one administrative staff
• Citizen portal (web interface to www.jeffersoncitymo.gov)
• Associated one time configuration charges
Reoccurring cost starting in FY2019 would be approximately $13,000 per fiscal year beginning
FY2019.
Throughout this process Planning & Protective Services has been collaborating with the
Finance/IT department and has their support and time commitment for this project. This
software does not duplicate existing software functions, but leverages the past investment in our
existing GIS and financial software. This time of year is ideal to move forward in purchasing the
software hardware to support property code enforcement:
• Property inspection staff are entering a slow time of the year and can spend time on
developing the software scope, with IT staff, and participating review of the proposals.
• Program software typically cheaper towards the end of the calendar year.
• Implementing new software during this period would optimize time by implementing
and training Property Inspectors on the new program before the beginning of the weeds
season next spring.
The Finance Department has identified a surplus of approximately $86,400 in the FY2017
Planning and Protective Services personnel budget due to position vacancies. For the current
fiscal year, time does not permit purchasing the software and hardware through the proper
request for proposal process.
Staff request the transfer $34,800 in funds from FY2017 personnel cost to the FY 2018 PPS
budget for the purchase these items. The reoccurring cost in FY2019 will be funded by existing
budget items, already specifically identified to support code deficiency activities.
631 West Main Street
Jefferson City, Missouri 65101
Phone: (573) 636-5000
Fax: (573) 636-6133
Email: mail@thearchitectsalliance.com
NEW FIRE STATION NO. 2
JEFFERSON CITY FIRE DEPARTMENT
3025 Robinson Road
Jefferson City, MO 65101
(PN 1630)
Schematic Design
Report
September 28, 2017
631 WEST MAIN STREET JEFFERSON CITY, MISSOURI 65101-1598 (573) 636-5000 FAX (573) 636-6133
SETH T. EVANS • LARRY D. BRANDHORST • CARY J. GAMPHER
MEMBERS AMERICAN INSTITUTE OF ARCHITECTS
September 28, 2017
Fire Chief, Matt Schofield
Jefferson City Fire Department, City of Jefferson
320 East McCarty Street
Jefferson City, Missouri 65101
Re: Schematic Design
New Station No. 2
Jefferson City Fire Department
Dear Matt,
We are herewith transmitting the Schematic Design Report of the New Fire Station No.2 for Jefferson City
Fire Department. This report defines the overall project scope of each major discipline including
Architectural, Civil, Structural, Mechanical, Electrical, and Plumbing.
The Schematic Design Report has been created through the input of the Jefferson City Fire Department’s
leaders, staff and our team of professional consultants. The report herein represents new construction
located on the selected site at McCarty and Robinson Road, Jefferson City, Missouri. The building
program has been developed into the floor plan and site orientation as depicted in the attached report. All
of these consider project guidelines, and perimeters which strive to achieve long term designed life-cycle
characteristics and durable materials selections.
Please contact us if you have any questions or determine areas of the floor plan or site plan that need
some additional adjustment or revisions to accommodate functions of the new facility, with approval to
proceed, as we move into the Design Development phase of the project.
We are highly optimistic about the positive contribution this project will have on the lives of our
community's citizens and patrons. Again on behalf of everyone at The Architects Alliance and our team
of consultants, we appreciate the opportunity to serve as Architects to the City of Jefferson. With your
authorization we are prepared to implement the next phase of this exciting project. Thank you
Sincerely,
Cary J. Gampher, AIA
Principal
Enclosure
Cc/email:
Cc:
TITLE PAGE Page 1 of 1
NEW FIRE STATION NO. 2
JEFFERSON CITY FIRE DEPARTMENT
3025 Robinson Road
Jefferson City, MO 65101
(PN 1630)
SCHEMATIC DESIGN REPORT
September 28, 2017
Owner:
JEFFERSON CITY FIRE DEPARTMENT
CITY OF JEFFERSON
320 E. McCarty Street
Jefferson City, MO 65101
Prepared by:
Architect:
THE ARCHITECTS ALLIANCE, INC.
631 West Main Street
Jefferson City, Missouri 65101
Telephone (573) 636-5000
Fax (573) 636-6133
Public Safety Architect Consultant:
WSKF ARCHITECTS, INC.
110 Armour Road
North Kansas City, Mo., 64116
Telephone: (816) 300-4101
Fax: (816) 300-4102
Civil Engineer:
CENTRAL MO PROFESSIONAL SERVICES
2500 E. McCarty Street
Jefferson City, MO 65101
Telephone: (573) 634-3455
Fax: (573) 634-8898
Structural Engineer:
ALLSTATE CONSULTANTS, LLC
3312 Lemone Industrial Blvd.
Columbia, MO 65201
Telephone: (573) 875-8799
Fax: (573) 875-8850
Mechanical & Electrical Engineers:
SSC ENGINEERING
18207 Edison Ave.
Chesterfield, Missouri 63005
Telephone: (636) 530-7770
Fax: (636) 530-7877
TABLE OF CONTENTS Page 1 of 1
NEW FIRE STATION NO. 2
JEFFERSON CITY FIRE DEPARTMENT
3025 Robinson Road
Jefferson City, MO 65101
(PN 1630)
SCHEMATIC DESIGN REPORT
September 28, 2017
TABLE OF CONTENTS
A. Progress Drawings .............................................................................................. 7 Pages
1. Site Plan
2. Floor Plan
3. West / North Elevation
4. South / East Elevation
5. Section
6. Previous Elevation Option 1
7. Previous Elevation Option 2
B. Narrative Descriptions ......................................................................................... 9 Pages
1. Architectural
2. Civil
3. Structural
4. Mechanical
5. Electrical
6. IT / DATA
7. Security
8. Fire Alarm
9. Notification Systems
10. Plumbing
11. Fire Protection
C. Cost Estimate ...................................................................................................... 1 Pages
D. Schedule of Milestones ....................................................................................... 1 Pages
NARRATIVE DESCRIPTIONS Page 1 of 10
NEW FIRE STATION NO. 2
JEFFERSON CITY FIRE DEPARTMENT
3025 Robinson Road
Jefferson City, MO 65101
(PN 1630)
SCHEMATIC DESIGN REPORT
September 28, 2017
NARRATIVE DESCRIPTIONS
INTRODUCTION
The building program includes training/conference locations, living areas, sleeping quarters/bunk rooms,
fitness/wellness area, detoxification room, two pull thru apparatus bays and one back in, apparatus support
& equipment spaces, mezzanine storage, and fire training area. All of these consider project guidelines,
and perimeters strive to achieve 50 – 100 year life-cycle design characteristics and durable materials
selections.
Living Areas 5,264 sf.
Apparatus Bay Mezzanine 708 sf.
Apparatus Bay 4,613 sf.
Total 10,585 sf.
Police Dept. Addition - Alternate 1 191 sf.
Future Apparatus Bay Addition 1,463 sf.
I. ARCHITECTURAL
Overall Description: The fire station is a single story, slab-on-grade, steep-pitched roof design. The
buildings systems are light-gauge, load-bearing metal stud for the living quarters and load-bearing concrete
masonry apparatus bays. The finish materials are residential in appearance but commercial in
performance. Overall, the building finishes are generally prefinished (finished by the manufacturer) or site-
finished with high-quality coatings. Windows are aluminum and doors are hollow metal with either hollow
metal doors or solid core wood doors depending location and performance requirements of the opening.
Floors & Floor Finishes: All floors are concrete slab-on-grade design with either light reinforcing (welded
wire fabric) or heavy reinforcing (rebar) depending on the particular room use. Living quarters are light
reinforcing while apparatus bays are heavy reinforcing. All interior concrete floors receive a steel trowel
finish (smooth). Select floors in the living quarters (kitchens, dining, corridors, etc.) are to be ground and
polished to a “salt & pepper” like finish. Floors in quiet areas (dayroom, bunkrooms, offices, etc.) have
carpet tile. Floors at entries have walk-off carpet tile. Floors in wet areas (restroom, showers, etc.) are
troweled epoxy floor finishes.
Floors in wet areas (gear storage, apparatus bay laundry, showers, etc.) are sloped to a floor drain. Floors
that are in semi-wet areas (restrooms, personal laundry, etc.) have a floor drain with a “sweep” around.
Flooring in fitness rooms is rubber.
Wall base is rubber (at carpet tile & smooth troweled floors), ceramic (at polished concrete), or epoxy (at
troweled epoxy floors).
NARRATIVE DESCRIPTIONS Page 2 of 10
Walls & Wall Finishes: Living quarters exterior walls are a combination of brick veneer or formed metal
(prefinished) wall panels, rigid cavity insulation, exterior wall sheathing w/fluid-applied vapor barrier, load-
bearing metal studs, interior gypsum board and interior finish (paint is typical). Living quarters interior walls
are gypsum board, non-structural metal studs and finish (paint is typical). Interior walls that are located in
areas where abuse from use is expected (corridor walls, etc.) incorporate abuse-resistant gypsum board.
Interior walls that are subject to moisture environment (personal laundry rooms, restrooms, etc.) incorporate
moisture-resistant gypsum board with finish (epoxy paint is typical). Interior walls that provide for sound
isolation (bunkrooms, toilets, fitness, etc.) incorporate acoustical batt insulation. Walls in wet areas
(showers, etc.) incorporate cement board with porcelain wall tile.
Interior wall finishes extend to the bottom of roof trusses in most areas.
Apparatus bay walls are load-bearing concrete masonry walls with epoxy paint finish to 10’-0” above finish
floor with alkyd paint from 10’-0” to top of wall.
Exterior walls include cast-stone concrete window sills, window heads and overhead door heads with water-
table. Cast stone to be mortar set with raked and caulked head joints and stainless steel dowel rods and
hot-dipped anchors.
Exterior walls to have polyurethane caulk and closed cell backer rod.
Interiors wall control joints to be latex caulked. Interior horizontal control joints to be pourable-grade
polyurethane. Interior moisture control joints to be mildew-resistant silicone sealant.
Miscellaneous rough carpentry is required for all areas to have wall-mounted equipment or similar wall-
mounted items. Construction #2 grade lumber is to be used.
Insulation: Exterior walls include spray-applied, closed-cell insulation. Roof decks (bottom of roof
sheathing) includes spray-applied, closed-cell insulation with intumescent coating.
Exterior walls (living quarters and apparatus bays) with brick veneer included rigid polyisocyanurate board
insulation with foil laminated to both faces.
Ceilings & Ceiling Finishes: Ceilings in the living quarters are acoustical panels (2’ x 2’) with exposed
ceiling suspension systems. Ceiling panels are fiberglass with either a paint finish or washable finish
depending on location (paint in bunkrooms and washable in laundry). Ceiling finishes in moisture
environments (restrooms, showers, etc.) are moisture resistant gypsum board with painted (epoxy) finish.
With flat bottom chord trusses, gypsum board is attached direction to the bottom chord (unless the spacing
is such that furring is required) with a tape and mud finish to seal the living quarters from the attic space.
Ceiling finish in the apparatus bays is Tectum Board (min. 1 ½” thickness) direct attached to the bottom
chord of the roof trusses (furring channels are needed if the truss space dictates such). The Tectum Board
is specified with an off-white paint coating. Another option would be metal perforated panel decking.
Doors & Windows: Exterior entry doors are aluminum with aluminum frames. Glazing is insulated for
exterior locations and uninsulated for interior locations. Doors and frames are thermally broken at exterior
locations.
Exterior service doors (access to apparatus bays, etc.) are insulated hollow metal with hollow metal frames.
Doors and frames are thermally broken. Glazing is insulated. Finish is alkyd paint.
Interior doors are hollow metal with either solid core wood (prefinished) or hollow metal (depending on
location of opening). Hollow metal frames and doors are finished with alkyd paint. Glazing is non-insulated
and tempered.
NARRATIVE DESCRIPTIONS Page 3 of 10
Overhead doors are sectional and insulated with 50,000 to 100,000 cycle springs with jack shaft motors
and pull chains for emergency use. Doors include insulated glazing if the design includes such.
All finish hardware is commercial grade with continuous hinges at all exterior doors and high-frequency
interior doors. Door gasketing is used at all exterior doors and interior doors where either sound
(bunkrooms, toilets, etc.) or air control (apparatus bays, gear storage, etc.) is needed. Access control (if
desired) is used at vestibule doors and staff doors.
Exterior windows are aluminum with thermally broken frames and tinted, insulated glazing and screens for
operable units. Bunkroom windows are egress design. Exterior windows to have mesh roller shades with
blackout shades at bunkrooms.
Interior windows are either aluminum (entry sidelites) or hollow metal (office sidelites) with clear, tempered
glazing.
Roofing, Soffits, Fascia, & Gutters/Downspouts: Roofing is standing-seam galvalume steel, prefinished,
with prefinished accessories (trim, vents, etc.). Soffits are prefinished steel or aluminum with venting or
non-venting design as the design requires. Fascia and associated trim is prefinished to match the roof and
of similar materials.
Gutters and downspouts are prefinished aluminum. Downspouts include a cast iron “boot” to capture and
direct water to an underground storm water collection system.
Signage: Interior signage is acrylic “plaque” type signs with room use designated including all bunks, toilets,
shower, offices, storage rooms, fitness, etc. Signs are wall-mounted with commercial double-stick tape.
Exterior signage is pin-mounted, prefinished, aluminum letters for station and address information.
Laundry & Bath Accessories: All laundry and bath accessories (paper towel dispenser, toilet paper
dispensers, etc.) are all commercial grade stainless steel or chrome finished. Accessories are provided
for: toilets/showers, laundries, and similar areas.
Lockers: Personal lockers are heavy-gauge, prefinished, 24x24, steel lockers with integral drawer base for
bedding storage. Lockers include interior configuration for hang rod, lockable storage cubicle and boot
tray. All lockers are vented and include a provision for padlock by owner.
Gear storage lockers are heavy-duty, expanded mesh, wall hung, 22 x 22, prefinished with integral hang
hooks, top and bottom shelf as well as back panels.
Cabinets & Pantries: Kitchen cabinets are constructed of Plyboo sheathing with interior cabinets with
melamine finish. Cabinets include stainless steel pulls and heavy duty glides for drawers. Cabinets include
either 5-knuckle or self-closing, commercial-grade European hinges. Interior shelves are either Plyboo or
¾” MDF with melamine finish.
Bathroom vanities are of similar construction to kitchen cabinets. Countertops in kitchens are quartz and in
bathrooms is solid surface.
Countertops in laundries is plastic laminate.
Kitchen backsplash to be ceramic tile with epoxy grout.
Fire Cabinets, Fire Extinguishers & Flagpole: Fire cabinets are prefinished, painted steel with glass
insert. Fire extinguishers are 10 pound, multipurpose, dry chemical type.
Flagpole is 25’, ground-mounted, spun aluminum with internal halyard.
NARRATIVE DESCRIPTIONS Page 4 of 10
Detoxification Room: Walls are to be constructed similar to other interior walls with batt insulation. Interior
wall finish to be porcelain tile with cement backer board. Radiant heat units (approximately 14) and
controller to be furnished by Sunlighten of Kansas City or approved equal manufacturer.
Sustainable Design Features: LEED Characteristic design approaches and sustainable design practices
include site orientation on east-west axis for optimum solar orientation/exposure, site placement using
existing topography, vegetation, and building configuration to deflect cold north winter winds, site utilization
for outdoor water reduction, site gray water collection/retention system. Building elements include large
overhangs to minimize summer solar heat gain and optimize winter solar heat gain, locally sourced
materials, continuous exterior building insulation, low emitting VOC materials, construction activity pollution
prevention, construction waste management, energy efficient HVAC and Lighting systems meeting or
exceeding ASHRAE 90.1 standards. LED lighting technology. Renewable sourced FSC materials.
II. CIVIL
Site Description: The site chosen for fire station #2 is located at 3025 Robinson Road and is located in
east Jefferson City. The property consists of approximately 15 acres of land. The site contains street
frontage along East McCarty Street and Robinson Road along the west and south property lines,
respectively. The north and east property lines are adjacent residential properties. Grades on this site
generally slope west to east with a natural drainage way flowing centrally to the east. Dense vegetation
consisting of large canopy trees and underbrush covers the majority of the site.
Site Grading: The site has been previously graded, which created a small building pad along East McCarty
Street and Robinson Road. The existing building pad will need to be expanded to encompass the proposed
building footprint, which currently is approximately 10,000 square feet. Fill material will be needed to
increase the size of the building pad, while also providing usable ground for driveway and parking areas.
Some fill material will be imported to the site from a City of Jefferson project on Lincoln Street. It is expected
that approximately 3,000-4,000 cubic yards of material will be brought on site and placed for future use.
The remainder of the required fill material is anticipated to come from over-excavation of the building pad
area, as recommended by the geotechnical report and the repositioning of material already on site.
The City of Jefferson also has plans to utilize the remainder of the site to the east as a certified fill site for
their internal operations. This will be an ongoing operation that will generally not affect the grading activities
for this project, but could be beneficial for future fire station expansion, training areas and general use.
Utilities: The site has access to all public utilities. Ameren Missouri has overhead electric lines and Sho-
Me Technologies has a fiber optic line that parallels East McCarty Street within the street right of way.
Sanitary sewer service is provided by the City of Jefferson along the north property line. There is also a 2”
gas main provided by Ameren Missouri, a 6” water main provided by Public Water Supply District No. 2 and
a telephone line provided by CenturyLink that crosses the front half of lot. These three utilities will need to
be relocated to allow room for building construction within the prime building area of the site.
Site Layout: Site layout and building placement is a critical element of this project. Several conceptual
layouts and scenarios were analyzed in this regard. Due to the grades of the site, positioning the building
as close to East McCarty Street as possible reduces the required fill material quantities, but in turn impacts
public utilities on site. After cost considerations, it was determined that relocation of the utilities impacted
by the site layout would be required. It is anticipated that all access from the fire station will be from East
McCarty Street. Close McCarty access also conserves site pavement costs.
Stormwater: The site stormwater will be collected by an enclosed stormwater system and directed to the
east. The City of Jefferson has implemented water quality requirements and will require any added
impervious areas be treated before leaving the immediate site. Treatment options will be analyzed as final
plans are developed for the site. There is a possibility that water quality can be addressed in conjunction
with the development of the City certified fill site, since they will be required to fulfill the same water quality
requirements.
NARRATIVE DESCRIPTIONS Page 5 of 10
Site Concrete: Site concrete will include construction of a heavy duty concrete driveway which will circle
around the building to allow circulation of fire trucks and equipment through the building. It will also include
the construction of parking spaces to serve the facility along with sidewalks for accessibility.
Landscaping: All disturbed areas will be finished graded, seeded and mulched. Parking lot shading will
be required and added to the site per the requirements of the City zoning code. A Type C bufferyard will
be required along the north property line between the site and residential properties.
NARRATIVE DESCRIPTIONS Page 6 of 10
List of Contacts:
City – Planning and Protective Services:
Director - Sonny Sanders (573-634-6410)
Building Code Official – Larry Burkhardt (673-634-3410)
Senior Planner – Eric Barron (573-634-6419)
Public Works:
Director – Matt Morasch (573-634-6453)
City Engineer – David Bange (573-634-6433)
Site Plan Review – Shane Wade (573-634-6449)
Stormwater – Don Fontana (573-634-6452)
Wastewater – Eric Seaman (573-634-6443)
Public Water Supply District No. 2 – Randy Kay (573-635-7011)
Ameren Missouri:
Gas – Jake Martin (573-681-7550)
Electric – Jason Woodard (573-681-7513)
CenturyLink – Alan Groner (573-681-2503)
Sho-Me Technologies – Brad McGoon (417-830-6717)
III. STRUCTURAL
The fire station roof will be framed with cold-formed trusses at 32” on center. Wood sheathing will span
between the trusses and provide a roof diaphragm. Structural masonry walls will support the roof
system. The apparatus bay will consist of 12” thick CMU walls and the remainder will be 8” CMU. Interior
walls will be composed of CMU and cold-formed steel. Isolated steel beams and columns may be required
to support the mezzanine and suspended storage areas. The slab-on-grade will typically be 4” thick. An
8” thick slab-on-grade will support the heavy truck loads at the apparatus bay. The foundation system will
consist of concrete footings or drilled piers bearing on rock. The facility will utilize the Turn-Out Gear Room,
serving dual purpose of a hardened room for emergency shelter consisting of 8” CMU walls, slab-on-glade
floor, with concrete on metal deck ceiling.
IV. MECHANICAL
The main HVAC for the building will be residential split systems with high efficiency gas furnaces to serve
the living quarters. Outdoor air will be integrated and conditioned at each unit and mixed with the return air.
The living quarters will be divided into four (4) zones based on proximity and conditioning needs. The fitness
area will be in its own zone and the thermostat will be located within the space. The bunks, nearby
restrooms, laundry, and associated hallway will be in a zone together having a thermostat in the associated
hallway. Another zone will contain the dayroom, kitchen, and dining and have the thermostat located near
the dining space. The last zone will include JCPD office, the vestibule, the small associated hallway, the
training room, the nearby restroom, and the Captain’s office with the thermostat located in the Captain’s
office. The kitchen will have a hood over the stove/oven with a built in suppression system.
The apparatus bay will have gas fired radiant heating while the restroom, turn-out gear room, and
hose/repair space within the garage will be heated by electric unit heaters. There will be an exhaust system
for the apparatus bays that will exhaust automatically upon detection of contaminants as well as have the
ability to be manually overridden to ventilate the space during the summer. There will also be a vehicle
exhaust system to remove exhaust directly from the vehicles within the bays.
V. ELECTRICAL
The building is proposed to be served by a 120/208 volt, three phase, four wire electrical service from the
NARRATIVE DESCRIPTIONS Page 7 of 10
overhead line that runs along E. McCarty Street. Preliminary discussions with Ameren, the electric utility
company, indicate there is a 3-phase service available for serving the proposed building. This service will
transition from overhead to underground at a new pole and run to an 112.5kVA (presumed) utility
transformer, CT cabinet, meter, service lateral and Service Entrance Rated Automatic Transfer Switch
installed outside building. Service is anticipated to be a 400 amp, 120/208/3/4 service with 4-600kcmil,
#3G, 4” C feeder to 400 amp, 14kAIC Utility Service side Circuit Breaker SER 3-pole ATS to a 400 amp,
Main Lug Only, 84-pole, 120/208/3/4, 14kAIC panelboard. ATS shall be equivalent to ASCO 7000 Series
Service Entrance Rated with Tech Package 150A and 135L accessory and NEMA 3R enclosure. Provide
ground system to include (3) 10’, copper clad steel ground rods, water service pipe and UFER. Provide a
#1/0 main bonding jumper and #1/0 ground conductor from neutral bus in ATS to ground system. Conduit,
trenching, conductors, terminations, meter enclosure and other required devices and equipment shall be
provided by the contractor as required by Ameren and the City. Provide a 150kW, 120/208/3/4, standby
rated, diesel genset with 400 amp output circuit breaker, remote emergency-power-off switch, sound
attenuated weather enclosure mounted on 8” thick concrete pad adjacent to building within 4-sided
protected area. Genset shall be connected as source 2 on ATS with 4-600kcmil, #3G, 4” C feeder to fully
backup entire building electrical load. A remote annunciator shall be provided inside building.
A remote 120/208/3/4, 225A, Main Lug Only, 54-circuit, 10kAIC panelboard with surge protection device
shall be provided at the mezzanine to serve the Apparatus Bay and mechanical equipment.
Provide a Surge Protection Device at the main panelboard. Provide branch circuit breakers as required to
feed the remote panelboard, mechanical, plumbing, fire protection and electrical equipment and device
loads, including interior and exterior building mounted lighting and signage, receptacles, office equipment,
televisions, Surge Protection Device, voice/data rack, access control system, fire alarm system, Emergency
Call/Radio system, intercom, overhead doors, air compressor, SCBA filling system, generator
charger/heater, irrigation system, ceiling fans, condensing units, furnaces, radiant heaters, unit heaters,
laundry equipment, water heater(s), fitness equipment, drop cord reels, mini split system for IT closet,
exhaust fans, dryer booster fan, motorized dampers, kitchen hood with internal fire suppression system,
dishwasher, refrigerator, garbage disposal, coffee maker, drinking fountain, gas valve and miscellaneous
kitchen equipment. Receptacles will be provided along the exterior of the building at approximately 100’
intervals. Circuit breaker for future solar array input can be provided if requested.
Kitchen equipment will be provided with a manual off pushbutton controlling a contactor to remove power
from receptacles, gas valve, range, microwave and similar kitchen equipment, except for refrigerators.
Firefighters will need to manually shut off the kitchen equipment by pressing the pushbutton. Power will be
reinstated by resetting the pushbutton manually.
Seismic restraints will be provided for all lighting, emergency equipment and conduit per IBC requirements.
Lighting fixtures are recommended to consist of 2’x4’ and 2’x2’ linear recessed direct/indirect LED, surface
mounted 6”x4’ LED direct strip light, 8” diameter LED recessed downlight, 6” diameter LED recessed
downlight, pendant mounted LED kitchen table light, undercabinet LED lights, bunk room step lights, and
2’x2’ LED surface mounted high bay lighting throughout the majority of the spaces. Exterior lighting will
consist of LED surface mounted wall packs with emergency drivers, exterior LED sconces, flag pole
uplighting, and nominal 220W LED full cutoff shoebox fixture on 20’ poles and 3’ high by 24” diameter, 72”
deep concrete pier base. Ceiling fans with integral light kit and LED lamps will be provided in the bunk
rooms.
Lighting controls will consist of ceiling and wall mounted occupancy sensors, dimmers and photosensors
for automatic daylight harvesting. Majority of rooms will have wall mounted manual override occupancy
sensors. Bunks will have dimmers at the bed for overhead lights, switches for ceiling fan and lights and
photocell controlled night lights over bed. Fitness and Training Room will have automatic daylight
harvesting photosensors at sidelit zones.
Polycarbonate, battery powered self-testing exit signs and emergency egress lights will be provided along
the path of egress and at exit doors as required by code.
NARRATIVE DESCRIPTIONS Page 8 of 10
Exterior lighting shall be controlled with photocell on/off and lighting contactor.
Lightning protection is not anticipated for this project.
VI. IT / DATA
Provide 2-post floor mounted rack, power strips, rack mounted UPS (2kVA), patch panels, patch cables (1
meter), cable management, plenum rated Cat 6 cables, Cat 6 RJ45 jacks, faceplates, CATV splitters, j-
hooks, conduit, boxes, phone board, receptacles, ground bus and appurtenances. Owner will provide the
switches, servers and wireless access point routers. Provide spare capacity of 20% for patch panels, patch
cables, cable management and rack space. Provide cable jacket and jack colors as selected by the owner.
Test all permanent link cables with a permanent link module to certify compliance with TIA Cat 6 standards
and submit test report indicating compliance and 25 year system warranty. Provide drops at each bunk
room, fitness room, kitchen, day room, office, Turn-Out Gear, Apparatus Bays, SCBA, mezzanine and
Training Room. Each drop to consist of a 4” square box, ¾” conduit, pull string, insulated bushing, 2 cables,
2 jacks and 3-port faceplate with one blank. Training room areas to have 3 cables and jacks per location.
Ceiling mounted wireless access points will be provided in bunk area, training area and apparatus bay for
Wi-Fi service.
Provide data cable/RJ45 and RG6 Quad Shield coaxial cable/Type F connector to each television from IT
Closet for CATV. Coordinate with owner for A/V requirements, anticipated to include (3) HDMI and (1)
3.5mm audio, at each television in a recessed wall box. Wall box to be equivalent to Chief PAC525WP2.
Coordinate with phone provider for phone service to IT Closet. Provide 4’ x 4’ x ¾” fire retardant treated
plywood backboard. Two (2) 4” PVC Schedule 40 conduits with pull strings will be provided between
backboard and underground telephone service along E. McCarty Street. One (1) 2” PVC Schedule 40
conduit with pull string will be provided between backboard and underground cable television service along
E. McCarty Street. Underground utilities will need to be relocated based on the proposed site layout.
Coordination of rerouting will be done with the civil engineer and the utility providers.
VII. SECURITY
Security will be provided in the building to include door contacts, proximity readers, request-to-exit devices,
electric strikes/electrified hardware and video surveillance cameras. Access control shall be provided at all
exterior doors, interior doors off the public corridor, and IT room. Door contacts, prox readers, request-to-
exit devices and electrified hardware rough-ins will consist of a recessed mounted handy-box at all device
locations, with a ½" conduit to a 6” square 3” deep junction box above accessible ceiling.
Interior fixed dome video surveillance cameras will be IP-based POE with full 1080p, 2MP resolution and
receive power from NVR or PoE switch. Cameras to have IR LED source for recording under no light
conditions and have plenum rated, Cat 6, UTP cabling. Cameras are anticipated to be located at perimeter
entries with number of locations as required.
Provide a network-based digital video recorder on an IP-based LAN/WAN infrastructure for a digital video
system using H.264 video compression, 30 FPS, MPEG4, 1 Terabyte Storage.
VIII. FIRE ALARM
A new fire alarm system will be provided with the control panel located at the main entry Vestibule. New
devices will include double action manual pull stations, detectors, photoelectric smoke detectors, water flow
switch, tamper switches, duct detectors, control modules, relays, monitor modules, fire alarm power supply
with charger and batteries for powering new horn/strobe notification appliances, and required emergency
batteries per codes. Fire alarm circuiting shall be class B with signal circuit style 4, notification circuit style
Y and initiating circuits style B. Cabling shall be plenum rated fire alarm certified type. The new fire alarm
panel will provide a general alarm, trouble and supervisory signals to the communicator located in the
NARRATIVE DESCRIPTIONS Page 9 of 10
FACP, which will be connected to a central station. The owner shall coordinate new analog voice lines,
cellular service, IP-based communicator and central station monitoring for the Fire Alarm System. Provide
fire alarm trouble connections at generator set to monitor genset running and alarm conditions.
Provide horn/strobe notification appliances per NFPA 72, ADAAG and IBC, as required.
Nitrogen Dioxide and Carbon Monoxide sensors are anticipated to be provided to help monitor hazardous
conditions and automatically activate exhaust fans.
IX. NOTIFICATION SYSTEMS
Provide an Emergency Notification and Incident Alert System with connections to the IT, TCP/IP, SMTP,
weather radio, ECS/dispatch CAD database, and alerting outputs to LCD/LED displays, strobes, clusters,
speakers and messenger systems. System can turn on house lights, open bay doors, control traffic lights,
send notification by email and text, and shut off kitchen power. Audio notification can be provided over the
phone handsets and wall/ceiling mounted speakers in living quarters and wall-mounted self-amplified horn-
type speakers in the apparatus bays and exterior zones.
One (1) 4” PVC Schedule 40 conduit with (3) 1” innerducts with pull strings will be provided between
backboard and site antenna hut. Additionally, two (2) 20 amp power connections will be provided to the
antenna hut.
X. PLUMBING
The FP and domestic water will enter the building in the Water room as separate services. The domestic
water system will have a hot water loop with a recirc pump to allow a single gas water heater to supply the
entire building. Wall hydrants will be located outside at 50foot intervals. Hose bibbs will be located indoors
at apparatus bays. Trench drains and sand/oil separator will be located in the apparatus bay.
Brief plumbing equipment summary:
Water heater will be gas fired unit, 65gallon and 125,000btu.
2” domestic water service
Floor mounted, flush valve water closets.
Wall hung lavatories.
ADA roll-in showers.
Kitchen sink with disposer and dishwasher hook up.
Floor mount mop basin with mop rack and hose.
Floor drains located in each restroom.
Residential clothes washer/dryer.
Floor mount free standing ice machine.
Commercial gear washing machine.
XI. FIRE PROTECTION
Referenced Material
The building will be provided with an automatic fire sprinkler system designed and installed in
accordance with the requirements of National Fire Protection Association (NFPA) Standards NFPA
13 (not NFPA 13R) and the applicable Building and Fire Codes.
All components and equipment used shall be UL Listed and FM Approved.
NARRATIVE DESCRIPTIONS Page 10 of 10
Utility Services and Fire Pump
The building shall be provided with a minimum 6-inch minimum fire protection service entry (see
above for combination with domestic). The cement lined ductile iron service entry shall be provided
from a point 5-feet outside the building exterior.
Fire hydrant flow test data will be required for the site to be within 12 months of permit submittal, in
accordance with NFPA 13.
Based upon available historic flow test data, a fire pump is not anticipated for this building.
Fire department connections shall be Siamese type and located along the exterior of the building,
near the riser. A hydrant must be provided within 300 feet of the fire department connection.
The fire sprinkler system will be served by a double check detector backflow assembly, located
inside the building.
Exterior notification is to be provided by an electric bell.
Hazard Criteria and Hydraulic Calculations
Sprinkler spacing and pipe sizing will be designed for Light Hazard occupancy, 0.10 gpm/ft2 over
the remote 1500 ft2 area in all public / common areas and other light hazard areas as outlined in
NFPA 13, with pipe sizing based on contractor provided hydraulic calculations.
The mechanical and electrical equipment areas, storage areas, and other ordinary hazard areas
as listed under Group 1 in NFPA 13 will be designed for Ordinary Hazard Group 1, 0.15 gpm/ft2
over the most remote 1500 ft2 area with pipe sizing based on contractor provided hydraulic
calculations.
Any shell/unfinished areas, and other ordinary hazard areas will be designed for Ordinary Hazard
Group 2, 0.20 gpm/ft2 over the remote 1500 ft2 area with pipe sizing based on contractor provided
hydraulic calculations.
The fire sprinkler contractor is to perform and provide hydraulic calculations in accordance with
NFPA 13. A safety factor of 5 PSI is required.
Fire Standpipe System
A fire standpipe system is not required and not anticipated for this facility.
Other Requirements
The inspector’s test and drain may be located at the building riser for wet systems.
Where combustible construction (Type V) is used, fire sprinkler protection will be required within
the attic. Unheated attic spaces will require installation of a dry pipe system.
NEW FIRE STATION NO. 2
JEFFERSON CITY FIRE DEPARTMENT
(PN 1630)
SCHEMATIC DESIGN REPORT
September 28, 2017
PRELIMINARY COST ESTIMATE
LIVING / TRAINING / APPARATUS BAYS Sq. Ft.
Architectural/Structural 9,877 165$ - 165$ 1,629,705$ - 1,629,705$
Mechanical/Electrical/Plumbing 775,000$ - 775,000$
Apparatus Bay Mezzanine 708 50$ - 50$ 35,400$ 35,400$
Building Subtotal 2,440,105$ - 2,440,105$
Civil - Site Cost (Parking, Drives, Etc.) 491,875$ - 708,125$
Construction Subtotal 2,931,980$ - 3,148,230$
Contingency (10%) 293,198$ - 314,823$
General Cond./ Overhead & Profit (10%) 293,198$ - 314,823$
TOTAL ESTIMATED CONSTRUCTION BUDGET 3,518,376$ - 3,777,876$
POLICE DEPT ADDITION - ALTERNATE
Architectural/Structural 191 165$ - 165$ 31,515$ - 31,515$
Mechanical/Electrical/Plumbing 191 70$ 80$ 13,370$ - 15,280$
Addition Subtotal 44,885$ 46,795$
Contingency (10%) 4,489$ - 4,680$
General Cond./ Overhead & Profit (10%) 4,489$ - 4,680$
Alternate Subtotal 53,862$ - 56,154$
TOTAL ESTIMATED CONSTRUCTION BUDGET W/ ALTERNATE 3,572,238$ 3,834,030$
FUTURE APPARATUS BAY
Architectural/Structural 1,463 100$ 146,300$
Mechanical/Electrical/Plumbing 47,986$
Subtotal 194,286$
Contingency (10%)19,429$
General Cond./ Overhead & Profit (10%) 19,429$
TOTAL ESTIMATED CONSTRUCTION BUDGET 233,143$
Construction Cost RangeCost per SF
NOTE: Estimate excludes Professional Services, Testing and Inspections, Printing, Furniture and Costs Due to
inflation.
COST ESTIMATE Page 1 of 1
SCHEDULE OF MILESTONES Page 1 of 1
NEW FIRE STATION NO. 2
JEFFERSON CITY FIRE DEPARTMENT
3025 Robinson Road
Jefferson City, MO 65101
(PN 1630)
SCHEMATIC DESIGN REPORT
September 28, 2017
SCHEDULE OF MILESTONES
Schematic Design Phase 4 weeks
Owner Approval SD Submission TBD
Design Development Phase 4 - 6 weeks
Owner Approval DD Submission TBD
Construction Documents Phase 6 - 8 weeks
Owner Approval CD Submission TBD
Bidding & Negotiations Phase 4 weeks
Award Contract to General Contractor TBD
Construction Phase 10 - 12 months