HomeMy Public PortalAbout20140814 finance packet
Notice of Meeting and Tentative Agenda
CITY OF JEFFERSON
Finance Committee
Thursday, August 14, 2014 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 July 10, 2014 meeting.
4. Financial Reports
a. Revenue Model Report
b. Sales Tax Report
c. Revenue Expense Report
d. Fund Balance Report
5. Lodging Tax Report
6. Financial Policies
7. Fire Pension Note
8. Discussion of City Administrator Purchasing Authority Process
9. EAP and Other Insurance Information
10. New Business
11. Old Business
12. 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, July 10, 2014
MINUTES
The meeting was called to order by the Finance Committee Chairman, Councilman Bray at 7:32 am. Roll call
showed that Councilmen Bray, Graham, Scrivner, Mihalevich and Prather were in attendance.
Next the minutes of the June 12, 2014 meeting were reviewed. A motion to approve was made by Councilman
Graham and seconded by Councilman Prather. The minutes were approved unanimously.
The next item on the agenda was a report by Interim Finance Director, Bill Betts, covering the Financial
Reports. Mr. Betts reviewed the Revenue Model and explained some variances. Other information reviewed
included July sales tax figures, year-to-date general ledger account information, and the current fund balance
calculation.
The next item on the agenda was a report by Mr. Betts, 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 $1,852,150. The average monthly amount collected for the 4 Cent Lockbox Fund is $50,272.
A report comparing occupancy rates for 2014, 2013 and 2012 was included along with a report listing
occupancy rates from other cities.
The next item on the agenda was Funding for the Fire Pension note. Mr. Betts informed the committee of
different funding options for repayment of the Fire Pension note. The committee would like to have Mr. Norm
Robinson and Mr. Kevin Bagby at the next meeting to discuss this further.
The next item on the agenda was new business. Mr. Betts gave each committee member a brochure from GFOA
which discusses fund balance.
The next item on the agenda was old business. Mr. Betts reviewed the budget schedule stating that it would
most likely be late August or early September before the budget was presented to the budget committee.
A motion to adjourn was made by Councilman Graham and seconded by Councilman Prather. The motion
passed unanimously and the meeting adjourned at 8:07 am.
As recorded by:
Cara Sankey, Accountant
For Period Ending July 31, 2014
Data as of 8-05-14 for period ending 7-31-14
CFY 2014 YTD Actual Projected Over/
Description Budget As of 7-31-14 (Under} Budget
Sales Tax and Use Tax $ 9 ,640,000.00 $ 6,520,465.14 ** $ 288,147 .14
Intergovernmental Taxes $ 2,080,000.00 $ 1,476,901.93 $ 62,603.10
Other Taxes $ 120,000.00 $ $
Franchise & Utility Tax $ 7,040,000.00 $ 5,059,944.98 $
Property Taxes $ 5,209,000.00 $ 5,144, 786.54 $
Intergovernmental $ 6,610.00 $ 18,077.41 $ 11,467.41
Charges for Services $ 2,082,965.63 $ 1,894,295.31 $ 32,685.12
Fees, Licenses, & Permits $ 713,600.00 $ 594,872.00 $ (10,975 .20)
Fines & Forfeitures $ 1,009,980.00 $ 734,706.38 $ (11,996.48)
Contributions/Donations $ 117,740.00 $ 121,530.03 $
Other Operating Revenues $ 67,804.08 $ 132,703.47 $
Interest Income $ 65,000.00 $ 67,245.48 $ 21,951.40
Other Non Operating Revenue $ 20,000.00 $ 23,414.00 $ 3,414.00
Operating Transfers In $ 21,940.00 $ 17,537.92 $ 1,116.47
Totals $ 28,194,639 .71 $ 21,886,003.41 $ 991,944.00
**Includes August 2014 actua l sa les tax receipts amount
NOTES for August Finance Meeting:
Revenue Model Report (Detail)
For Period Ending July 31, 2014
Description
Sales Tax and Use Tax
10-100-400010
10-100-400020
Sa les Ta x (Inc . March Actual}
Sa les Ta x Interest
Intergovernmental Taxes
10-100-401030
10-100-403010
10-100-430080
Other Taxes
Motor Vehicle Sales Ta x
Gasoline Tax
Road & Bridge Tax
Start
Month
2
2
2
0
1
Electric Utili ty Lie Ta x 1
Gas Utility License Ta x 1
Telephone Cell w/o audit mon ey 1
Telecom Audit
Cable Franchise Fee R/1
Budget
9,640,000.00
0.00
9,64 0,000.00
430,000.00
1,100,000.00
550.000.00
2 ,080 ,000.00
120,000.00
120 000.00
3,220,000.00
925,000.00
2,4 50,000.00
110,000.00
335,000.00
10-100-410020
10-100-410030
10-100-410052
10-1 00-410053
10-100-410060
10-100-410061 Cable Utility Audit .::..$ _____ _
Property Taxes
10-100-420010
10-100-420020
10-100-420040
10-100-420050
10-100-420055
10-100-420060
10-100-420080
Current Property Ta x
Del Property Ta x
Fin In stitution Tax
Prop Tax lnt & Penalties
Surtax Receipts-County Reimb
Surtax Receipts
Special Tax Rev
I nte rgove rnme nta I
10-100-430010 Fe deral Grant
10-100-430100
10-100-480020
10-100-480025
State DNR Historic Pres
NSP Rehab Sales
HUD Program Income
Charges for Services
10-100-440010 Admin Charge Backs
10-100-440050
10-100-440210
10-100-440910
10-100-440920
10-100-440930
0-100-450189
10-100-481020
10-100-481030
0-100-481040
0-100-481045
Emt Reimbursement
Street Cuts
Fuel Charge-backs
Parts Charge backs
Labor Charge backs
Animal Shelter Bricks
Cole ay Animal Rescue
Rent City Hall/annex
Rent Other
Rent-tower Sites
0
0
0
0
0
0
2
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
7,040,000.00
4,600,000.00
40,000.00
10 ,000.00
20,000 .00
S4,000.00
470,000.00
1S ,OOO.OO
S,209 ,000 .00
0.00
0.00
o.oo
6.610.00
6,610.00
1,2 25,5S9.00
o.oo
25,000.00
0.00
91,600.00
137,400.00
o.oo
100,000.00
6,500.00
12,000.00
80,000.00
Initial Estimated
Revenue
YTD Actual
As of 7-31-14
9 ,640,000.00 6,520,465.14
0 .00
6,520,46 5.14
450,469.49
1,095,781.10
550,000.00
131,715.76
297,777.52
628,592 .75
550,531.66
1,476,90 1.93
79.522 .82
79 ,522.82
3,422,802.04 2,184,791.97
908,060.23 934,270.28
2,383,173.00 1,487,273.61
164,401.06
337,942 .30 285 ,208.06
Remaining
Estimated Revenues
8-14 thru 10-14
3,407,68 2.00
0.00
3,407,682.00
196,201.66
469,499.51
0.00
665,701.17
43.634 .26
43,634 .26
1,4S9 ,421.28
141,631.98
779,17S.42
0.00
83,944.54
$ 4,000.00 .::...$ ------
4,570,217.73
64,812.1S
16,S19.7S
29,246.15
S4,399.28
471,744.89
27,3S9.89
6,610.00
1,225,559.00
25,411.SO
84,442.07
124,065.41
100,000.00
6,SOO .OO
12,000.00
80,000.00
S,OS9 ,944.98
4,498,S13.09
40,810.26
41,S34.94
20,492 .62
S4,399.28
470,784.96
18.251.39
S,144, 786 .S4
11,467.41
0.00
0.00
6,610 .00
18,077.41
1,225,5S9.00
0.00
22,790.00
12,876.52
98,266.13
96,860.12
500.00
75,000.00
6,500.00
0.00
71936.49
2,464,173.22
26,164.38
10,864.21
1,175.2S
7,70S.39
0.00
1,648.05
7.S69.65
S5,126.92
0.00
0.00
0.00
0.00
0.00
0 .00
o.oo
6,665 .00
0.00
25,852.00
35,922 .34
0 .00
25,000.00
0.00
12,000.00
22 804.6S
$
Actual & Estimated
TOTAL
Projected Over/ Verification
(Under) Budget of Formulas
9,928,147.14
0.00
9,9 28,147.14
493,979.18
1,098,092.26
550,531.66
2,142,603.10
123.157.08
123,157.08
288,147 .14
0.00
288,147.14
63,979 .18
(1 ,907.74)
S31.66
62 ,603 .10
3.157.08
3,157.08
3 ,644,213 .2S 424,213.25
1,075 ,902.26 150,902.26
2,266,449.03 (183,SS0.97 )
164,401.06 S4,401.06
369,1S2.60 34,1S2.60
4,000.00 .::..$ __ __,4,c:..OO::...:O...:.Oc;;.O
7,524,118.20 484,118 .2 0
4,S24,677.47
S1,6 74.47
42,710.19
28,198.01
54,399.28
472,433.01
2S.821.04
S,199,9 13.46
11,467.41
0.00
0.00
6.610.00
18,077.41
1,22S,S59.00
0.00
29 ,45S .OO
12,876.52
124,118.13
132,782.46
500.00
100,000.00
6,500.00
12,000.00
94,741.14
(7S,322.53)
11,674.47
32,710.19
8,198.01
399.28
2,433.01
10.821.04
(9 ,086.54)
11,467.41
0.0 0
0.00
0.00
11,467.41
0 .00
0.00
4,4SS.OO
12,876.52
32,S18.13
(4,617.54)
500.00
0.00
0 .00
0.00
14 741.14
288,147.14
.I!..QQ
288,147.14
63,979.18
(1,907.74)
?l.k.§2
62,603.10
3,157.08
3,157.08
424,213.25
150,902.26
1183,550.97)
54,401.06
34,152.60
4,000.00
4841118.20
(75,322.53)
11,674.47
32,710.19
8,198.01
399.28
2,433.01
10,821.04
(9,086.541
11,467.41
0.00
0.00
!L!!!!
11,467.41
0.00
0.00
4,455.00
12,876.52
32,518.13
(4,617.54)
500.00
0.00
0 .00
0.00
14,741.14
Revenue Model Report (Detail )
For Period Ending July 3 1,2014
Description
10-100-481075
10 -1 00-481080
10-100-4810 85
10-100-481090
10-100-481100
10 -100-481110
Cole Ct y 911 Rei mb
Sale Of Ma ps/gis Data
Cole Ct y Gi s Jo int Coo p
Col e Cty She riff-New World
Sa le Of Grav e Si tes
Long & Sh ort
Start
Month
0
0
0
0
0
0
Rema ining
Ini t ia l Estimated YTD Act ual Estima t ed Revenues Actua l & Estimat ed
Bu dget Re venue As of 7-31 -14 B-1 4 thru 10-14 TOTAL
35 8,228.63 3S 8,22 8.63 268 ,950 .19 89,161.44 358,111.63
Proj ec t ed Ov er/ Verifi cation
(Un der) Budget of Formulas
(117.00) (117.00)
o.oo 0.00 140.00 0.00 140.00 140.00 140.00
15,000.00 15 ,000.00 11,250.00 3, 750 .00 15,000 .00 0.00 0.00
28,678.00 0.00 0.00 0.00 0 .00 (28,678.0 0) (28,678.00)
3,000 .00 3,000.00 3,600.00 200.00 3,8 00 .00 80 0.00 80 0.00
0.00 0.00 66.86 0.00 66.86 66.86 §ll§
---------------------2~·~08~2~,9~6~5~.6~3~-----------------~1~,8~94~,~2 9~5~.3~1~------~2~2 ~1,~35~5M.44_. ________ _.2~,1~1~5 ,~6~50•.-7 S._ ______ ~32~,6~8~5~.12 ______ _.3~2·~~-5 .• 1 ~2
10-100-4500 10
1 0 -1 00-4500 20
10-100-4500 21
10 -100-450030
10-100-450040
10-100-450041
10-100-450045
10-100-450050
10-100-450060
10-100-45 00 70
10-100-450080
10-100-450090
10-100-450091
10-100-450092
10-100-450100
10-100-450110
10-100-450120
10-100-450130
10-100-450150
10-100-450160
10-100-450170
10-100-450180
10-100-450185
10-100-450186
10-100-450190
10-100-450230
10-100-450 250
10 -100-450260
Li quo r Li ce nses
Bu si ness Li ce ns es
Home Occupatio n Permit
So lic itors Lie
Aban doned Bld g. Reg
Aba nd oned Bldg. Ad min Fee
Bldg . Constr Fees
Electrica l Ce rt ificates
Electrica l Pe rmits
Pl umbi ng Li ce nses
Plumbing Permits
Othe r Li e & Perm its
Day Care In spect ion Fees
Food 1 nspection Fees
Cu r b Cut Permit s
Board Of Ad j Fe e s
Sign Permits
Demolition Permits
Ace Re p Fees-poli ce
Accrpt /blastg P-fire
An imal Rede m ption Fees
Ani ma l Vaccina t io n s Fees
Ani ma l Crematio n Fees
Ani ma l Boa rdin g Fees
Taxi Pe rmits
Vacatin g Rig ht Of Way
Re zonin g Request
No n-re fund able Pl ans/s pe c
Fines & Forfeitures
10-100-460010
10-100-460015
10-100-46001 8
10-100-460020
10-100-460025
10-100-460030
10-100-460040
10-100-460050
10-100-460060
Court Co s t
Court Re stitution s
Inmate Se curity Fund
Jail Co st Recovery
Alcohol Offense Co s t Rec
Po l Fin e s-traffic
Pol Ti ck ets-parking
Pol fines-Other
Dog Fin es
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
65,000.00
205,000.00
1,500.00
0.00
0.00
0.00
200,000.00
16,000 .00
2,500 .00
10,000 .00
5,000 .00
1,500.00
8,000 .00
88,000.00
1,500.00
1,200.00
4,000.00
500.00
1 2,000.00
500.00
53,000.00
4,500 .00
20,000.00
0 .00
500.00
400.00
10,000.00
3,000.00
7 13,600.00
80,000 .00
1,3 00.00
12,0 80.00
10,000.00
10,000.00
850,000.00
1,000.00
0 .00
0 .00
64,405 .00
216,0 00 .00
1,666.00
129,807.55
16,398.00
4,592.37
10,384.00
5,937.50
2,597.19
8,515.00
86,739.25
1,5 1 8 .00
5,240.00
916.00
1 2,387.67
793.50
52,360.00
5,140.00
23,665 .00
0 .00
500.00
3 15.0 0
11,651 .00
2,727 .25
82,550.20
1,986.90
13,155.29
11,661.07
9,810.00
836,162.5 4
63,3 12.50
181,89 1.10
1,144.00
0.00
88.00
6,104.17
123,527.86
16,720.00
3,087.81
11 ,217.00
3,747.25
2,460.78
5,145.00
88,420.33
364.00
1,442.00
3,327.00
624.00
8,546.20
579.00
39,930.00
3,680.00
18,560.00
0 .00
550.00
650.00
8,208.00
1 ,546.00
594,872.00
55,451.16
1,293 .16
8,933.96
7,501.02
5,352.50
620,127.92
0 .00
0 .00
0.00
2,143 .75
32,778.67
312 .00
0.00
0.00
0.00
29 ,618 .91
976 .50
2,13 0.90
1,144.00
1,393 .75
48 7.50
2,720 .00
1,869.46
918.00
0 .00
2,419.00
310.00
3,033.38
3 15.50
13,217.50
1,350.00
6,1 65 .00
0 .00
37 .50
215.00
3,794.00
402.50
107,75 2.81
22,272.06
770.15
3,528.95
2,376.85
2,154.13
23 1,624.35
0 .00
0 .00
0 .00
65,456.2 5
214,669.77
1,456.00
0.00
88.00
6,104.17
153 ,146.77
17,696.50
5,218.71
12,361.00
5,141.00
2,948.28
7,865.00
90,289 .79
1,282.0D
1,442.00
5,746.00
934.00
11,579.58
89 4.50
53,147.50
5,030.00
24,725 .00
0 .00
5 87 .5 0
865.00
12,002.00
1,948 .50
702,624.81
77,723 .22
2,063 .31
12,462 .91
9,877 .87
7,506.63
851,752.27
0.00
0 .00
0 .00
456 .25
9,669 .77
(44.00)
0.00
88 .00
6,104.17
(46,853 .23)
1,696.50
2,718.7 1
2,361.00
141.00
1,448 .28
(135.00)
2,289.79
(218.00)
242 .00
1,746.00
434.00
{420.42)
394.5 0
147.50
530.00
4,725 .00
0.00
87.5 0
465.00
2,002 .00
(1,051.50)
(10,975 .20)
(2,276 .79)
763.31
382.91
{122 .13)
{2,493.38}
1, 75 2.26
(1,000 .00}
0.00
0.00
4S6.2S
9,669.77
144.00)
0.00
88.00
6,104.17
(46,8S3 .23)
1,696.50
2,718.71
2,36 1.00
141.00
1,448.28
1135.00)
2,289.79
1218.00)
24 2.00
1,746.00
434.00
(42D.42)
394.50
147.5 0
530.00
4,72S .OO
0.00
87.50
465.00
2,002.00
!1 .051.SO)
(10,975.20)
(2,276.79)
763.31
382.91
(1 22.13)
(2 ,493.38)
1,752.26
(1,000.00)
0.00
0.00
Revenue Model Report (Detail)
For Period Ending July 31, 2014
10-100-460070
10-100-460090
10-100-460100
10-100-430055
10-100-480010
10-100-480015
10-100-480030
10-100-480050
10-100-480055
10-100-480063
10-100-480065
10 -1 00-480070
10-100-480080
10-100-480090
10-100-480165
10-100-481050
10-10 0-481055
10-100-481095
10-100-486070
Description
P & Code Violations
Parking Fines
Bankcard Charges
DARE Contri
Citizen Participation
Sidewalk Waiver Revenue
Donations-Recycling
Sober Dr iver Program
JC Fire Museum
Private Donations-Cultural Art
Cu ltural Arts
Community Projects Donations
Dare Donations
Police K-9 Donations
Animal S Donations
Transfer St n/Ping-Sid Wst Cntr
Street Repa i r-Solid Waste Cntr
Cemetery Do nation s
Cap Co ntr-n ei ghor hood 1 mp Pro
Other Operating Revenues
10-100-450187 Spec ial Sn Program
10-100-450188 Adoption Vou cher Program
10-100-481070
10-100-481072
10-100-481077
10-100-481078
Miscellaneous
TIF Prof Svcs Deposit
Insurance Claims
Cafeteria Refunds
Interest Income
10-100-4 70010
10-100-470051
Interest
Unrealized Gains and Losses
Other Non Operating Revenue
10-100-485049 Cap Vhcl Equip sale of assets
10-100-485050 Sale Of Assets
Operating Transfers In
10-100-490193 Trsfer From Grant Fund
10-100-490240 Trsfr From Lodging Tax
10-100-490260
10-100-490280
10-100-490353
10-100-490600
10-100-490620
Trsfr from Fi reman's Spec Rev
Trnf from Stone ridge TDD
Transfer From Cit "e"
Transfer from Water Fund
Transfer from Parking Fund
Start
Month
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Budget
0.00
58,600.00
(13 ,000.00)
1,009,980.00
0 .00
0.00
0 .00
0.00
6,040.00
0.00
0.00
0.00
700 .00
500.00
500.00
0.00
0.00
110,000.00
0 .00
0 .00
117,740 .00
0.00
0.00
24,000.00
0.00
43,804.08
0 .00
67,804.08
65,000.00
0.00
65 ,000.00
0 .00
21,940 .00
0 .00
0 .00
0 .00
0.00
0 .00
Initial Estimated
Revenue
41,650.35
(13 ,8 43 .12)
27,535.59
12,098.45
65,000 .00
20 ,000.00
19,930.23
YfD Actual
As of7-31-14
0.00
46,889 .49
(10,842 .83 )
734,706 .38
0.00
711.93
0 .00
0 .00
3,110.00
9,634.50
0 .00
1,000.00
700 .00
500.00
500 .00
10,748.30
0.00
94,462.50
0 .00
162.80
121,5 30.03
0 .00
0 .0 0
73,146 .20
0.00
59,557.27
0.00
132,703.47
67,245.48
0.00
67,245 .48
23,414.00
23 ,414.00
0.00
17,537.92
0.00
0.00
0 .00
0 .00
0 .00
Remaining
Estimated Revenues
B-14-thru 10-14
0.00
5,555.92
(5 ,005.25)
263,277.14
0.00
0.00
0.00
0 .00
2,930.00
0.00
0.00
0 .00
0.00
0 .00
0.00
0.00
0 .00
28 ,912.85
0 .00
0 .00
31,842.85
0.00
0 .00
13 ,782.53
0 .00
1,027.50
0.00
14,810.03
19,705 .92
0.00
19,705 .92
0.00
0 .00
0.00
5,518.55
0.00
0.00
0.00
0.00
0 .00
Actual & Estimated
TOTAL
0.00
52,445.41
(15,848.08)
Projected Over I Verification
(Under) Budget of Formulas
0.00 0.00
(6,154.59) (6,154.591
(2,848.08) (2,848.08)
997,983.52 __ .....:..(1....;1,996.48) (11,996.48)
0.00
711 .93
0 .00
0 .00
6,040 .00
9,634.50
0.00
1,000.00
700 .00
500.00
500.00
10,748.30
0 .00
123,375 .35
0 .00
162.80
15 3,3 72.88
0 .00
0 .00
86,928 .73
0 .00
60,584.77
0.00
147,513.50
86,951.40
0.00
86,951.40
0.00
23,414.00
23,414 .00
0.00
23,056.47
0.00
0.00
0.00
0.00
0.00
0.00
711.93
0.00
0.00
0.00
9,634.50
0.00
1,000.00
0 .00
0 .00
0.00
10,748.30
0.00
13 ,375 .35
0.00
162.80
35,632 .88
0.00
0.00
62,928 .73
0.00
16,780.69
0.00
79,709.42
21,951.40
0 .00
21 ,951.40
0.00
3,414.00
3,414.00
0 .00
1,116.47
0 .00
0.00
0.00
0.00
0 .00
0.00
711.93
0.00
0.00
0.00
9,634 .5 0
0.00
1,000.00
0.00
0.00
0.00
10,748.30
0.00
13,375.35
0.00
ill&Q
35,632.88
0.00
0.00
62,928.73
0.00
16,780.69
2&2
79,709.4 2
21,95 1.40
2&2
21 ,95 1.40
0.00
1,116.47
0.00
0.00
0.00
0.00
2&2
Revenue Model Report (Detail)
For Period Ending July 31, 2014
Description
Start
Month Budget
21,940.00
28,194,639 .71
Initial Estimated YTD Actual
Revenue As of7-31-14 -17,537.92
21,886,003.41
Remaining
Estimated Revenues Actual & Estimated Projected Over/ Verification
8-14 thru 10-14 TOTAL (Under) Budget of Formulas
5,518.55 23,056.47 1,116.47 1,116.47 -7,300,580.30 29,186,583.71 991,944.00 991,944.00
Memo
To:Steve Crowell
From:Shiela Pearre
Date:August 8, 2014
Re:Sales Tax Revenues
The City received the August 1% Sales Tax in the amount of $614,048 which is $67697 more
than projected for August. January thru August overage is $288,146 (2.99%) in the General Fund.
1% General Sales Tax
Receipt Budget Actual
Period Projection Receipts Variance
Nov-13 Jan-14 $764,659 $741,056 ($23,603)
Dec-13 Feb-14 $703,181 $789,830 $86,649
Jan-14 & Oct-Dec 13 Qtrly Mar-14 $1,008,111 $920,599 ($87,512)
Feb-14 Apr-14 $777,424 $737,482 ($39,942)
Mar-14 May-14 $537,141 $802,765 $265,624
Apr-14 & Jan-Mar 14 Qtrly Jun-14 $1,023,015 $865,930 ($157,085)
May-14 Jul-14 $872,436 $1,048,754 $176,318
Jun-14 Aug-14 $546,351 $614,048 $67,697
Jul-14 & Apr-June 14 Qtrly Sep-14 $1,096,581
Aug-14 Oct-14 $717,262
Sep-14 Nov-14 $677,366
Oct-14 & Jul-Sept 14 Qtrly Dec-14 $916,473
Total Overage/Shortfall $288,146
1/2% Capital Improvement Tax
Receipt Budget Actual
Period Projection Receipts Variance
Nov-13 Jan-14 $416,244 $359,800 ($56,444)
Dec-13 Feb-14 $311,418 $394,475 $83,057
Jan-14 & Oct-Dec 13 Qtrly Mar-14 $471,169 $423,641 ($47,528)
Feb-14 Apr-14 $413,147 $348,172 ($64,975)
Mar-14 May-14 $266,340 $399,863 $133,523
Apr-14 & Jan-Mar 14 Qtrly Jun-14 $499,328 $416,943 ($82,385)
May-14 Jul-14 $393,021 $503,869 $110,848
Jun-14 Aug-14 $280,801 $306,157 $25,356
Jul-14 & Apr-June 14 Qtrly Sep-14 $508,966
Aug-14 Oct-14 $370,760
Sep-14 Nov-14 $268,825
Oct-14 & Jul-Sept 14 Qtrly Dec-14 $499,981
Total Overage/Shortfall $101,452
1/2% Parks Sales Tax
Receipt Budget Actual
Period Projection Receipts Variance
Nov-13 Jan-14 $372,447 $359,708 ($12,739)
Dec-13 Feb-14 $350,714 $393,562 $42,848
Jan-14 & Oct-Dec 13 Qtrly Mar-14 $475,026 $423,546 ($51,480)
Feb-14 Apr-14 $372,242 $348,076 ($24,166)
Mar-14 May-14 $266,456 $398,085 $131,629
Apr-14 & Jan-Mar 14 Qtrly Jun-14 $482,382 $416,845 ($65,537)
May-14 Jul-14 $425,194 $503,790 $78,596
Jun-14 Aug-14 $272,321 $305,930 $33,609
Jul-14 & Apr-June 14 Qtrly Sep-14 $521,155
Aug-14 Oct-14 $357,482
Sep-14 Nov-14 $323,768
Oct-14 & Jul-Sept 14 Qtrly Dec-14 $419,277
Total Overage/Shortfall $132,759
Period
Reporting
Period
Reporting
Period
Reporting
City of Jefferson, Mo. - Account Analysis
Printed 8/8/2014
Account Name General Fund Sales Tax Rate:One percent (1%)Receipt Month: AUGUST 2014
Account Number 10-100-400010
Monthly
REPORTING PERIOD RECEIPT PERIOD 2009 2010 2011 2012 2013 2014 Average
Nov January 787,676 928,460 809,385 843,061 764,659 741,056 act.826,648
Dec February 572,813 631,137 833,919 619,287 703,181 789,830 act.672,067
Jan & Oct-Dec Qtrly March 1,079,246 894,158 589,958 992,559 1,008,111 920,599 act.912,806
Feb April 763,906 774,964 978,391 852,653 777,424 737,482 act.829,468
Mar May 516,016 592,657 633,676 530,069 537,141 802,765 act.561,912
Apr & Jan-Mar Qtrly June 934,660 843,712 925,555 1,028,514 1,023,015 865,930 act.951,091
May July 686,153 939,495 955,495 797,785 872,436 1,048,754 act.850,273
Jun August 526,097 495,667 566,299 557,032 546,351 614,048 act.538,289
Jul & Apr-Jun Qtrly September 1,006,120 1,040,156 1,032,258 1,069,414 1,096,581 1,096,581 est.1,048,906
Aug October 718,480 822,163 797,510 769,129 717,262 717,262 est.764,909
Sept November 554,824 482,807 536,185 615,421 677,366 677,366 est.573,321
Oct & Jul-Sept Qtrly December 801,780 881,780 1,032,046 982,684 932,387 916,473 est.926,135
Actual to Date $ 8,947,771 $ 9,327,157 $ 9,690,677 $ 9,657,608 $ 9,655,913 6,520,465
Estimated to Fiscal Year end (based on averages and on Budgeted amount)3,407,681
Total Actual & Estimated $ 9,928,147
Less: Budget 9,640,000
Over (Under) Budget $ 288,147
$ 741,056.45
$ 1,530,886.91
$ 2,451,485.95
$ 3,188,968.08
$ 3,991,732.73
$ 4,857,663.18
$ 5,906,417.41
$ 6,520,465.33
$ 764,659.19
$1,467,840.39
$2,475,951.79
$3,253,375.33
$3,790,516.42
$4,813,531.75
$5,685,967.41
$6,232,318.77
$7,328,899.63
$8,046,161.24
$8,723,526.86
$9,640,000.00
$ 500,000.00
$ 750,000.00
$ 1,000,000.00
$ 1,250,000.00
$ 1,500,000.00
$ 1,750,000.00
$ 2,000,000.00
$ 2,250,000.00
$ 2,500,000.00
$ 2,750,000.00
$ 3,000,000.00
$ 3,250,000.00
$ 3,500,000.00
$ 3,750,000.00
$ 4,000,000.00
$ 4,250,000.00
$ 4,500,000.00
$ 4,750,000.00
$ 5,000,000.00
$ 5,250,000.00
$ 5,500,000.00
$ 5,750,000.00
$ 6,000,000.00
$ 6,250,000.00
$ 6,500,000.00
$ 6,750,000.00
$ 7,000,000.00
$ 7,250,000.00
$ 7,500,000.00
$ 7,750,000.00
$ 8,000,000.00
$ 8,250,000.00
$ 8,500,000.00
$ 8,750,000.00
$ 9,000,000.00
$ 9,250,000.00
$ 9,500,000.00
$ 9,750,000.00
$ 10,000,000.00
$ 10,250,000.00
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 8/8/2014
Account Name Capital Imprs Sales Tax Rate:One-Half percent (½%)Receipt Month: AUGUST 2014
Account Number 44-100-400010 F - effective 4/1/12
Monthly
REPORTING PERIOD RECEIPT PERIOD 2009 2010 2011 2012 2013 2014 Average
Nov January 384,327 455,480 396,799 412,434 372,459 359,800 act.404,300
Dec February 286,909 313,836 407,407 308,567 350,813 394,475 act.333,506
Jan & Oct-Dec Qtrly March 505,185 415,473 280,758 466,856 475,110 423,641 act.428,677
Feb April 365,514 370,473 452,824 409,365 372,340 348,172 act.394,103
Mar May 257,313 295,545 315,165 263,902 266,422 399,863 act.279,669
Apr & Jan-Mar Qtrly June 453,788 400,667 439,298 494,757 483,070 416,943 act.454,316
May July 326,501 462,244 468,643 389,423 425,325 503,869 act.414,427
Jun August 261,707 247,260 282,859 278,231 272,603 306,157 act.268,532
Jul & Apr-Jun Qtrly September 481,799 495,398 482,244 504,307 521,260 508,966 est.497,002
Aug October 348,002 395,058 382,206 367,366 357,619 370,760 est.370,050
Sept November 276,487 240,417 266,364 306,968 323,871 268,825 est.282,821
Oct & Jul-Sept Qtrly December 384,320 428,058 495,406 469,095 443,688 499,981 est.444,113
Actual to Date $ 4,331,852 $ 4,519,908 $ 4,669,974 $ 4,671,272 $ 4,664,580 3,152,920
Estimated to Fiscal Year end (based on averages and on Budgeted amount)1,648,532
Total Actual & Estimated $ 4,801,452
Less: Budget 4,700,000
Over (Under) Budget $ 101,452
$ 359,799.94
$ 754,275.37
$ 1,177,916.24
$ 1,526,088.37
$ 1,925,951.58
$ 2,342,894.17
$ 2,846,763.19
$ 3,152,920.28
$ 416,244.00
$727,662.00
$1,198,831.00
$1,611,978.00
$1,878,318.00
$2,377,646.00
$2,770,667.00
$3,051,468.00
$3,560,434.00
$3,931,194.00
$4,200,019.00
$4,700,000.00
$ 100,000.00
$ 350,000.00
$ 600,000.00
$ 850,000.00
$ 1,100,000.00
$ 1,350,000.00
$ 1,600,000.00
$ 1,850,000.00
$ 2,100,000.00
$ 2,350,000.00
$ 2,600,000.00
$ 2,850,000.00
$ 3,100,000.00
$ 3,350,000.00
$ 3,600,000.00
$ 3,850,000.00
$ 4,100,000.00
$ 4,350,000.00
$ 4,600,000.00
$ 4,850,000.00
$ 5,100,000.00
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 8/8/2014
Account Name Parks Sales Tax Rate:One-Half percent (½%)Receipt Month: AUGUST 2014
Account Number 21-210-400010
Monthly
REPORTING PERIOD RECEIPT PERIOD 2009 2010 2011 2012 2013 2014 Average
Nov January 384,305 455,442 396,815 405,730 372,447 359,708 act.402,948
Dec February 286,889 313,792 407,348 308,456 350,714 393,562 act.333,440
Jan & Oct-Dec Qtrly March 507,768 415,275 280,734 466,713 475,026 423,546 act.429,103
Feb April 365,727 370,308 452,735 409,353 372,242 348,076 act.394,073
Mar May 256,675 295,529 315,030 263,822 266,456 398,085 act.279,502
Apr & Jan-Mar Qtrly June 453,016 400,500 439,265 494,733 482,382 416,845 act.453,979
May July 326,518 461,255 468,387 389,006 425,194 503,790 act.414,072
Jun August 261,622 247,216 282,836 278,072 272,321 305,930 act.268,413
Jul & Apr-Jun Qtrly September 481,772 495,222 482,150 505,913 521,155 521,155 est.497,242
Aug October 347,721 395,014 382,115 366,846 357,482 357,482 est.369,836
Sept November 275,469 240,348 264,735 306,831 323,768 323,768 est.282,230
Oct & Jul-Sept Qtrly December 384,300 428,200 495,305 468,924 443,569 419,277 est.444,060
Actual to Date $ 4,331,782 $ 4,518,100 $ 4,667,453 $ 4,664,400 $ 4,662,755 3,149,541
Estimated to Fiscal Year end (based on averages and on Budgeted amount)1,621,682
Total Actual & Estimated $ 4,771,223
Less: Budget 4,638,464
Over (Under) Budget $ 132,759
$ 359,708.18
$ 753,270.03
$ 1,176,815.59
$ 1,524,891.51
$ 1,922,976.56
$ 2,339,821.20
$ 2,843,610.78
$ 3,149,540.59
$ 372,447.00
$723,161.00
$1,198,187.00
$1,570,429.00
$1,836,885.00
$2,319,267.00
$2,744,461.00
$3,016,782.00
$3,537,937.00
$3,895,419.00
$4,219,187.00
$4,638,464.00
$ 100,000.00
$ 350,000.00
$ 600,000.00
$ 850,000.00
$ 1,100,000.00
$ 1,350,000.00
$ 1,600,000.00
$ 1,850,000.00
$ 2,100,000.00
$ 2,350,000.00
$ 2,600,000.00
$ 2,850,000.00
$ 3,100,000.00
$ 3,350,000.00
$ 3,600,000.00
$ 3,850,000.00
$ 4,100,000.00
$ 4,350,000.00
$ 4,600,000.00
$ 4,850,000.00
$ 5,100,000.00
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
General Ledger
Trial Balance by Acct Type and Full
Acct Number
User: spearre
Printed: 08/05/14 08:49:20
Period 01 - 13
Fiscal Year 2014
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10 General Fund
Revenue Revenue
100 Revenue
10-100-400010 Sales Tax 9,640,000.00 5,906,417.41 0.00 3,733,582.59 38.73
10-100-400020 Sales Tax Interest 0.00 0.00 0.00 0.00 0.00
R10 Sales & Use Taxes 9,640,000.00 5,906,417.41 0.00 3,733,582.59 38.73
10-100-401030 Motor Vehicle Tax 430,000.00 297,777.52 0.00 132,222.48 30.75
10-100-403010 Gasoline Tax 1,100,000.00 628,592.75 0.00 471,407.25 42.86
10-100-430080 Road & Bridge Tax 550,000.00 550,531.66 0.00 -531.66 -0.10
R16 Intergovernmental Taxes 2,080,000.00 1,476,901.93 0.00 603,098.07 29.00
10-100-403020 Cigarette Tax 120,000.00 79,522.48 0.00 40,477.52 33.73
R20 Other Taxes 120,000.00 79,522.48 0.00 40,477.52 33.73
10-100-410020 Electric Utility Lic Tax 3,220,000.00 2,184,792.00 0.00 1,035,208.00 32.15
10-100-410021 Electric Utility-AUDIT 0.00 0.00 0.00 0.00 0.00
10-100-410030 Gas Utility License Tax 925,000.00 934,270.28 0.00 -9,270.28 -1.00
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,450,000.00 1,487,293.38 0.00 962,706.62 39.29
10-100-410053 TelephoneCell Utility-AUDIT 110,000.00 164,401.06 0.00 -54,401.06 -49.46
10-100-410060 Cable Franchise Fee 335,000.00 285,208.06 0.00 49,791.94 14.86
10-100-410061 Cable Utility-AUDIT 0.00 4,000.00 0.00 -4,000.00 0.00
R30 Franchise & Utility Tax 7,040,000.00 5,059,964.78 0.00 1,980,035.22 28.13
10-100-420010 Cur Property Tax 4,600,000.00 4,498,513.37 0.00 101,486.63 2.21
10-100-420020 Del Property Tax 40,000.00 42,912.92 0.00 -2,912.92 -7.28
10-100-420040 Fin Inst Tax 10,000.00 41,534.94 0.00 -31,534.94 -315.35
10-100-420050 Prop Tax Int & Penalties 20,000.00 20,492.63 0.00 -492.63 -2.46
10-100-420055 Surtax Receipts - County Reimb 54,000.00 54,399.28 0.00 -399.28 -0.74
10-100-420060 Surtax Receipts 470,000.00 471,264.60 0.00 -1,264.60 -0.27
10-100-420080 Special Tax Rev 15,000.00 18,251.39 0.00 -3,251.39 -21.68
R40 Property Taxes 5,209,000.00 5,147,369.13 0.00 61,630.87 1.18
GL - Trial Balance by Acct Type and Full Acct Number (08/05/2014 - 8:49 AM)Page 1
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-100-430010 Federal Grants 0.00 12,291.89 0.00 -12,291.89 0.00
10-100-430020 State Grants 0.00 0.00 0.00 0.00 0.00
10-100-430040 Local Grants 0.00 0.00 0.00 0.00 0.00
10-100-430060 Drug Forfeiture 0.00 5,173.92 0.00 -5,173.92 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 0.00 0.00 0.00 0.00 0.00
10-100-480025 HUD Program Income 6,610.00 6,610.00 0.00 0.00 0.00
R50 Intergovernmental 6,610.00 24,075.81 0.00 -17,465.81 -264.23
10-100-440010 Admin Charge Backs 1,225,559.00 1,225,559.00 0.00 0.00 0.00
10-100-440050 Emt Reimbursement 0.00 0.00 0.00 0.00 0.00
10-100-440210 Street Cuts 25,000.00 22,790.00 0.00 2,210.00 8.84
10-100-440910 Fuel Charge-backs 0.00 12,876.52 0.00 -12,876.52 0.00
10-100-440920 Parts Charge-back 91,600.00 98,266.13 0.00 -6,666.13 -7.28
10-100-440930 Labor Charge-backs 137,400.00 96,860.72 0.00 40,539.28 29.50
10-100-450189 Animal Shelter Bricks 0.00 500.00 0.00 -500.00 0.00
10-100-481020 Cole Cty Animal Rescue 100,000.00 75,000.00 0.00 25,000.00 25.00
10-100-481030 Rent City Hallannex 6,500.00 6,500.00 0.00 0.00 0.00
10-100-481040 Rent Other 12,000.00 0.00 0.00 12,000.00 100.00
10-100-481045 Rent-tower Sites 80,000.00 71,936.51 0.00 8,063.49 10.08
10-100-481065 Parking Spot Maintenance 0.00 0.00 0.00 0.00 0.00
10-100-481075 Cole Cty 911 Reimb 358,228.63 268,950.19 0.00 89,278.44 24.92
10-100-481080 Sale Of Mapsgis Data 0.00 140.00 0.00 -140.00 0.00
10-100-481085 Cole Cty Gis Joint Coop 15,000.00 11,250.00 0.00 3,750.00 25.00
10-100-481090 Cole Cty Sheriff-New World 28,678.00 0.00 0.00 28,678.00 100.00
10-100-481100 Sale Of Grave Sites 3,000.00 3,600.00 0.00 -600.00 -20.00
10-100-481105 TIF Administration Fee 0.00 0.00 0.00 0.00 0.00
10-100-481110 Long & Short 0.00 66.86 0.00 -66.86 0.00
R60 Charges for Services 2,082,965.63 1,894,295.93 0.00 188,669.70 9.06
10-100-450010 Liquor Licenses 65,000.00 63,312.50 0.00 1,687.50 2.60
10-100-450020 Business Licenses 205,000.00 183,887.42 0.00 21,112.58 10.30
10-100-450021 Home Occupation Permit 1,500.00 1,144.00 0.00 356.00 23.73
10-100-450030 Soliciters Licenses 0.00 0.00 0.00 0.00 0.00
10-100-450040 Abandoned Bldg Registration 0.00 88.00 0.00 -88.00 0.00
10-100-450041 Abandoned Bldg Admin Fee 0.00 6,104.17 0.00 -6,104.17 0.00
10-100-450045 Bldg Constr Fees 200,000.00 125,271.59 0.00 74,728.41 37.36
10-100-450050 Electrical Certificates 16,000.00 16,720.00 0.00 -720.00 -4.50
10-100-450060 Electrical Permits 2,500.00 3,087.81 0.00 -587.81 -23.51
10-100-450070 Plumbing Licenses 10,000.00 11,217.00 0.00 -1,217.00 -12.17
10-100-450080 Plumbing Permits 5,000.00 3,937.25 0.00 1,062.75 21.26
10-100-450090 Other Lic & Permits 1,500.00 2,460.78 0.00 -960.78 -64.05
10-100-450091 Day Care Inspection Fees 8,000.00 5,145.00 0.00 2,855.00 35.69
10-100-450092 Food Inspection Fees 88,000.00 88,420.33 0.00 -420.33 -0.48
10-100-450100 Curb Cut Permits 1,500.00 364.00 0.00 1,136.00 75.73
10-100-450110 Board Of Adj Fees 1,200.00 1,442.00 0.00 -242.00 -20.17
10-100-450120 Sign Permits 4,000.00 3,327.00 0.00 673.00 16.83
10-100-450130 Demolition Permits 500.00 624.00 0.00 -124.00 -24.80
GL - Trial Balance by Acct Type and Full Acct Number (08/05/2014 - 8:49 AM)Page 2
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-100-450150 Acc Rep Fees-police 12,000.00 8,581.20 0.00 3,418.80 28.49
10-100-450160 Accrptblastg P-fire 500.00 584.00 0.00 -84.00 -16.80
10-100-450170 Animal Redemption Fees 53,000.00 41,330.00 0.00 11,670.00 22.02
10-100-450180 Animal Vaccinations Fees 4,500.00 3,780.00 0.00 720.00 16.00
10-100-450185 Animal Cremation Fees 20,000.00 18,560.00 0.00 1,440.00 7.20
10-100-450186 Animal Boarding Fees 0.00 0.00 0.00 0.00 0.00
10-100-450190 Taxi Permits 500.00 575.00 0.00 -75.00 -15.00
10-100-450230 Vacating Right Of Way 400.00 650.00 0.00 -250.00 -62.50
10-100-450250 Rezoning Request 10,000.00 8,445.00 0.00 1,555.00 15.55
10-100-450260 Non-refundable Plansspec 3,000.00 1,546.00 0.00 1,454.00 48.47
R65 Fees Licenses & Permits 713,600.00 600,604.05 0.00 112,995.95 15.83
10-100-460010 Court Cost 80,000.00 55,783.49 0.00 24,216.51 30.27
10-100-460015 Court Restitutions 1,300.00 1,293.34 0.00 6.66 0.51
10-100-460018 Inmate Security Fund 12,080.00 8,987.97 0.00 3,092.03 25.60
10-100-460020 Jail Cost Recovery 10,000.00 7,532.65 0.00 2,467.35 24.67
10-100-460025 Alcohol Offense Cost Rec 10,000.00 5,352.50 0.00 4,647.50 46.48
10-100-460030 Pol Fines-traffic 850,000.00 623,740.09 0.00 226,259.91 26.62
10-100-460040 Pol Tickets-parking 1,000.00 0.00 0.00 1,000.00 100.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 58,600.00 47,099.49 0.00 11,500.51 19.63
10-100-460100 Bankcard Charges -13,000.00 -10,842.83 0.00 -2,157.17 16.59
R70 Fines & Forfeitures 1,009,980.00 738,946.70 0.00 271,033.30 26.84
10-100-430055 INACTIVE - DARE Contributions 0.00 0.00 0.00 0.00 0.00
10-100-480010 Citizen Participation 0.00 711.93 0.00 -711.93 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 6,040.00 3,110.00 0.00 2,930.00 48.51
10-100-480055 JC Fire Museum 0.00 9,884.50 0.00 -9,884.50 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 1,000.00 0.00 -1,000.00 0.00
10-100-480070 Community Projects Donations 700.00 700.00 0.00 0.00 0.00
10-100-480080 Dare Donations 500.00 500.00 0.00 0.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 10,754.31 0.00 -10,754.31 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 110,000.00 94,462.50 0.00 15,537.50 14.13
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 162.80 0.00 -162.80 0.00
R72 ContributionsDonations 117,740.00 121,786.04 0.00 -4,046.04 -3.44
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-481070 Miscellaneous 24,000.00 73,156.20 0.00 -49,156.20 -204.82
10-100-481072 TIF Prof Svcs Deposit 0.00 0.00 0.00 0.00 0.00
10-100-481077 Insurance Claims 43,804.08 60,420.35 0.00 -16,616.27 -37.93
GL - Trial Balance by Acct Type and Full Acct Number (08/05/2014 - 8:49 AM)Page 3
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-100-481078 Cafeteria Refunds 0.00 0.00 0.00 0.00 0.00
R75 Other Operating Revenues 67,804.08 133,576.55 0.00 -65,772.47 -97.00
10-100-470010 Interest 65,000.00 67,245.48 0.00 -2,245.48 -3.45
10-100-470051 Unrealized Gainslosses 0.00 0.00 0.00 0.00 0.00
R80 Interest Income 65,000.00 67,245.48 0.00 -2,245.48 -3.45
10-100-485049 Capvhcleqp-sale Of Assets 0.00 0.00 0.00 0.00 0.00
10-100-485050 Sale Of Assets 20,000.00 23,414.00 0.00 -3,414.00 -17.07
R85 Other Non-Operating Revenue 20,000.00 23,414.00 0.00 -3,414.00 -17.07
10-100-490193 Trsfr From Grant Fund 0.00 0.00 0.00 0.00 0.00
10-100-490240 Trsfr From Lodging Tax 21,940.00 17,537.92 0.00 4,402.08 20.06
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
R90 Transfers In 21,940.00 17,537.92 0.00 4,402.08 20.06
10-100-495995 Transfer From(to) Surplus 419,573.41 0.00 0.00 419,573.41 100.00
10-100-495996 Trnasfer From(To) Surplus 0.00 0.00 0.00 0.00 0.00
R99 Carry Over Surplus 419,573.41 0.00 0.00 419,573.41 100.00
100 Revenue 28,614,213.12 21,291,658.21 0.00 7,322,554.91 25.59
149 Entitlement Grant
10-149-430010 Federal Grants 719,083.74 210,772.78 0.00 508,310.96 70.69
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 719,083.74 210,772.78 0.00 508,310.96 70.69
149 Entitlement Grant 719,083.74 210,772.78 0.00 508,310.96 70.69
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
300 Police Department
10-300-430010 Federal Grants 286,113.85 282,800.39 0.00 3,313.46 1.16
10-300-430020 State Grants 0.00 0.00 0.00 0.00 0.00
10-300-430040 Local Grants 0.00 42,354.73 0.00 -42,354.73 0.00
10-300-430074 Overtime Reimb 58,505.60 25,177.22 0.00 33,328.38 56.97
R50 Intergovernmental 344,619.45 350,332.34 0.00 -5,712.89 -1.66
GL - Trial Balance by Acct Type and Full Acct Number (08/05/2014 - 8:49 AM)Page 4
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
300 Police Department 344,619.45 350,332.34 0.00 -5,712.89 -1.66
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 184,966.60 184,966.60 0.00 0.00 0.00
R50 Intergovernmental 184,966.60 184,966.60 0.00 0.00 0.00
310 School Resource Officer 184,966.60 184,966.60 0.00 0.00 0.00
320 M.U.S.T.A.N.G.
10-320-430010 Federal Grants 54.99 17,517.86 0.00 -17,462.87 -31,756.45
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 0.00 0.00 0.00 0.00 0.00
R50 Intergovernmental 54.99 17,517.86 0.00 -17,462.87 -31,756.45
320 M.U.S.T.A.N.G.54.99 17,517.86 0.00 -17,462.87 -31,756.45
400 Fire Department
10-400-430010 Federal Grants 184,500.00 0.00 0.00 184,500.00 100.00
10-400-430040 Local Grants 0.00 0.00 0.00 0.00 0.00
R50 Intergovernmental 184,500.00 0.00 0.00 184,500.00 100.00
400 Fire Department 184,500.00 0.00 0.00 184,500.00 100.00
522 Plan & Protect Svcs-MPO
10-522-430010 Federal Grants 148,200.00 55,174.23 0.00 93,025.77 62.77
10-522-430020 State Grants 0.00 0.00 0.00 0.00 0.00
10-522-430040 Local Grants 9,262.50 4,999.65 0.00 4,262.85 46.02
R50 Intergovernmental 157,462.50 60,173.88 0.00 97,288.62 61.79
522 Plan & Protect Svcs-MPO 157,462.50 60,173.88 0.00 97,288.62 61.79
530 Plan & Protect Svc-RedevGrant
10-530-430010 Federal Grants 1,374,095.19 666,340.19 0.00 707,755.00 51.51
10-530-430020 State Grants 1,250.00 1,250.00 0.00 0.00 0.00
10-530-430040 Local Grants 0.00 0.00 0.00 0.00 0.00
R50 Intergovernmental 1,375,345.19 667,590.19 0.00 707,755.00 51.46
530 Plan & Protect Svc-RedevGrant 1,375,345.19 667,590.19 0.00 707,755.00 51.46
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 11,000.00 10,980.00 0.00 20.00 0.18
R50 Intergovernmental 11,000.00 10,980.00 0.00 20.00 0.18
GL - Trial Balance by Acct Type and Full Acct Number (08/05/2014 - 8:49 AM)Page 5
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
532 Plan & Protect Svcs-Env Health 11,000.00 10,980.00 0.00 20.00 0.18
990 Capital Projects
10-990-430010 Federal Grants 1,401,414.33 183,820.20 0.00 1,217,594.13 86.88
10-990-430020 State Grants 0.00 0.00 0.00 0.00 0.00
10-990-430040 Local Grants 0.00 0.00 0.00 0.00 0.00
R50 Intergovernmental 1,401,414.33 183,820.20 0.00 1,217,594.13 86.88
990 Capital Projects 1,401,414.33 183,820.20 0.00 1,217,594.13 86.88
Revenue Revenue 32,992,659.92 22,977,812.06 0.00 10,014,847.86 30.35
Expense Expense
110 Mayor & Council
10-110-501010 Salary-Elected Officials 64,800.00 42,975.00 0.00 21,825.00 33.68
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 3,287.98 0.00 1,669.22 33.67
10-110-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00
10-110-502040 Workers Compensation 103.26 103.26 0.00 0.00 0.00
E05 Personnel Services 69,860.46 46,366.24 0.00 23,494.22 33.63
10-110-511010 Advertising 0.00 0.00 0.00 0.00 0.00
10-110-511020 Postage 100.00 29.06 0.00 70.94 70.94
10-110-512010 Printing 750.00 21.00 0.00 729.00 97.20
10-110-512020 Copies 500.00 96.90 0.00 403.10 80.62
10-110-513010 Office Supplies 400.00 239.76 218.75 -58.51 -14.63
10-110-514040 Food 412.05 0.00 0.00 412.05 100.00
E10 Materials & Supplies 2,162.05 386.72 218.75 1,556.59 72.00
10-110-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00
10-110-520025 Security 3,000.00 304.75 0.00 2,695.25 89.84
10-110-520030 Dues And Publications 4,582.90 4,582.90 0.00 0.00 0.00
10-110-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-110-520070 Training & Education 417.10 138.47 0.00 278.63 66.80
10-110-522020 Professional Services 87.95 87.95 0.00 0.00 0.00
10-110-529010 Special Events 0.00 0.00 0.00 0.00 0.00
E15 Contractual Services 8,087.95 5,114.07 0.00 2,973.88 36.77
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 0.00 0.00 0.00 0.00 0.00
E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00
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
GL - Trial Balance by Acct Type and Full Acct Number (08/05/2014 - 8:49 AM)Page 6
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
110 Mayor & Council 80,110.46 51,867.03 218.75 28,024.69 34.98
120 City Clerk
10-120-501020 Salaries 63,969.55 45,835.68 0.00 18,133.87 28.35
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 4,893.67 3,301.51 0.00 1,592.16 32.54
10-120-502020 Group Health Insurance 12,300.85 9,144.28 0.00 3,156.57 25.66
10-120-502030 Retirement 12,602.00 8,296.66 0.00 4,305.34 34.16
10-120-502040 Workers Compensation 103.26 103.26 0.00 0.00 0.00
10-120-502050 Life Insurance 108.44 74.83 0.00 33.61 30.99
10-120-502060 Long Term Disability 179.04 123.77 0.00 55.27 30.87
10-120-502070 Employee Assistance Prgm 29.53 22.24 0.00 7.29 24.69
E05 Personnel Services 94,186.34 66,902.23 0.00 27,284.11 28.97
10-120-511020 Postage 270.00 50.49 0.00 219.51 81.30
10-120-512010 Printing 0.00 0.00 0.00 0.00 0.00
10-120-512020 Copies 500.00 383.62 0.00 116.38 23.28
10-120-513010 Office Supplies 1,000.00 223.83 0.00 776.17 77.62
E10 Materials & Supplies 1,770.00 657.94 0.00 1,112.06 62.83
10-120-520030 Dues And Publications 250.00 185.00 0.00 65.00 26.00
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 297.00 0.00 703.00 70.30
10-120-522020 Professional Services 750.00 0.00 0.00 750.00 100.00
10-120-529030 Election Expense 50,000.00 21,613.64 0.00 28,386.36 56.77
E15 Contractual Services 52,000.00 22,095.64 0.00 29,904.36 57.51
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 400.00 416.25 218.75 -235.00 -58.75
10-120-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00
E25 Repairs & Maintenance 400.00 416.25 218.75 -235.00 -58.75
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 148,356.34 90,072.06 218.75 58,065.54 39.14
140 City Administrator
10-140-501020 Salaries 158,689.92 130,572.01 0.00 28,117.91 17.72
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 12,139.78 9,583.07 0.00 2,556.71 21.06
10-140-502020 Group Health Insurance 13,866.75 11,467.02 0.00 2,399.73 17.31
GL - Trial Balance by Acct Type and Full Acct Number (08/05/2014 - 8:49 AM)Page 7
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-140-502030 Retirement 27,331.24 12,388.62 0.00 14,942.62 54.67
10-140-502040 Workers Compensation 542.12 542.12 0.00 0.00 0.00
10-140-502050 Life Insurance 247.61 194.51 0.00 53.10 21.45
10-140-502060 Long Term Disability 424.74 308.71 0.00 116.03 27.32
10-140-502070 Employee Assistance Prgm 36.72 31.53 0.00 5.19 14.13
E05 Personnel Services 213,278.88 165,087.59 0.00 48,191.29 22.60
10-140-511010 Advertising 1,000.00 0.00 0.00 1,000.00 100.00
10-140-511020 Postage 400.00 141.09 0.00 258.91 64.73
10-140-512010 Printing 300.00 90.00 0.00 210.00 70.00
10-140-512020 Copies 500.00 115.07 0.00 384.93 76.99
10-140-513010 Office Supplies 1,200.00 854.57 218.75 126.69 10.56
10-140-517010 Operational Supplies 1,750.00 0.00 0.00 1,750.00 100.00
E10 Materials & Supplies 5,150.00 1,200.73 218.75 3,730.53 72.44
10-140-520030 Dues And Publications 600.00 365.00 0.00 235.00 39.17
10-140-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-140-520070 Training And Education 1,200.00 545.37 0.00 654.63 54.55
10-140-520080 Tuition Reimbursement 2,000.00 0.00 0.00 2,000.00 100.00
10-140-520090 Recruitment 7,960.75 7,960.75 0.00 0.00 0.00
10-140-520095 Relocation Fees 17,402.06 17,402.06 0.00 0.00 0.00
10-140-522020 Professional Services 2,000.00 219.39 0.00 1,780.61 89.03
E15 Contractual Services 31,162.81 26,492.57 0.00 4,670.24 14.99
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 250.00 115.44 0.00 134.56 53.82
10-140-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00
E25 Repairs & Maintenance 250.00 115.44 0.00 134.56 53.82
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 249,841.69 192,896.33 218.75 56,726.62 22.71
149 Entitlement Grant
10-149-501020 Salaries 21,017.50 12,131.96 0.00 8,885.54 42.28
10-149-501050 Parttime(wo Benefits)16,000.00 9,660.00 0.00 6,340.00 39.63
10-149-502010 Social Security 1,921.66 1,667.02 0.00 254.64 13.25
10-149-502020 Group Health Insurance 2,363.92 1,801.40 0.00 562.52 23.80
10-149-502030 Retirement 2,803.50 2,195.92 0.00 607.58 21.67
10-149-502050 Life Insurance 25.59 19.43 0.00 6.16 24.07
10-149-502060 Long Term Disability 42.42 31.75 0.00 10.67 25.15
E05 Personnel Services 44,174.59 27,507.48 0.00 16,667.11 37.73
10-149-511010 Advertising 1,500.00 498.75 0.00 1,001.25 66.75
10-149-511020 Postage 699.37 367.12 0.00 332.25 47.51
GL - Trial Balance by Acct Type and Full Acct Number (08/05/2014 - 8:49 AM)Page 8
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-149-512020 Copies 0.63 0.63 0.00 0.00 0.00
10-149-513010 Office Supplies 1,500.00 584.56 0.00 915.44 61.03
10-149-517010 Operational Supplies 700.00 147.23 0.00 552.77 78.97
E10 Materials & Supplies 4,400.00 1,598.29 0.00 2,801.71 63.68
10-149-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-149-520070 Training And Education 2,671.34 1,171.34 0.00 1,500.00 56.15
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 60,018.00 29,652.00 0.00 30,366.00 50.59
10-149-528012 Housing Rehab-Energy Efficienc 42,402.00 24,848.15 0.00 17,553.85 41.40
10-149-528020 Housing Assistance 30,379.00 30,379.00 0.00 0.00 0.00
10-149-528030 Public Improvement 363,071.17 98,998.21 239,226.65 24,846.31 6.84
10-149-528040 Neighborhood Redevelopmnt 103,536.69 77,431.69 0.00 26,105.00 25.21
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 6,778.00 1,733.00 0.00 5,045.00 74.43
10-149-528080 Homeless Objectives 22,524.00 0.00 0.00 22,524.00 100.00
E15 Contractual Services 631,380.20 264,213.39 239,226.65 127,940.16 20.26
10-149-547020 Maintenance Agreements 738.95 414.08 207.04 117.83 15.95
E25 Repairs & Maintenance 738.95 414.08 207.04 117.83 15.95
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 45,000.00 0.00 0.00 45,000.00 100.00
E75 Capital Projects 45,000.00 0.00 0.00 45,000.00 100.00
149 Entitlement Grant 725,693.74 293,733.24 239,433.69 192,526.81 26.53
150 City Counselor
10-150-501020 Salaries 226,856.91 126,197.99 0.00 100,658.92 44.37
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,354.55 8,988.12 0.00 8,366.43 48.21
10-150-502020 Group Health Insurance 33,916.35 18,670.39 0.00 15,245.96 44.95
10-150-502030 Retirement 44,534.97 22,841.54 0.00 21,693.43 48.71
10-150-502040 Workers Compensation 370.02 370.02 0.00 0.00 0.00
10-150-502050 Life Insurance 364.39 209.12 0.00 155.27 42.61
10-150-502060 Long Term Disability 555.12 316.75 0.00 238.37 42.94
10-150-502070 Employee Assistance Prgm 74.15 55.85 0.00 18.30 24.68
10-150-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 324,026.46 177,649.78 0.00 146,376.68 45.17
10-150-511010 Advertising 0.00 0.00 0.00 0.00 0.00
GL - Trial Balance by Acct Type and Full Acct Number (08/05/2014 - 8:49 AM)Page 9
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-150-511020 Postage 450.00 373.93 0.00 76.07 16.90
10-150-512010 Printing 125.00 0.00 0.00 125.00 100.00
10-150-512020 Copies 670.00 179.57 0.00 490.43 73.20
10-150-513010 Office Supplies 1,800.00 609.16 0.00 1,190.84 66.16
10-150-517010 Operational Supplies 25.00 0.00 0.00 25.00 100.00
E10 Materials & Supplies 3,070.00 1,162.66 0.00 1,907.34 62.13
10-150-520020 Auditing Travel Expense 0.00 0.00 0.00 0.00 0.00
10-150-520030 Dues And Publications 12,400.00 3,655.81 0.00 8,744.19 70.52
10-150-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-150-520070 Training And Education 5,000.00 4,369.14 0.00 630.86 12.62
10-150-520080 Tuition Reimbursement 3,420.00 2,565.00 0.00 855.00 25.00
10-150-521010 Malpractice Insurance 3,000.00 1,712.00 0.00 1,288.00 42.93
10-150-522020 Professional Services 10,540.00 3,076.07 0.00 7,463.93 70.82
10-150-525030 Court Cost & Witness Fees 60.00 57.00 0.00 3.00 5.00
E15 Contractual Services 34,420.00 15,435.02 0.00 18,984.98 55.16
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 1,250.00 1,009.45 399.91 -159.36 -12.75
10-150-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00
E25 Repairs & Maintenance 1,250.00 1,009.45 399.91 -159.36 -12.75
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 362,766.46 195,256.91 399.91 167,109.65 46.07
160 Municipal Court
10-160-501010 Salary-elected Officals 60,000.00 39,999.92 0.00 20,000.08 33.33
10-160-501020 Salaries 97,303.63 69,774.07 0.00 27,529.56 28.29
10-160-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00
10-160-501050 Parttime(wo Benefits)9,500.00 3,202.38 0.00 6,297.62 66.29
10-160-501090 Overtime 7,200.00 286.21 0.00 6,913.79 96.02
10-160-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00
10-160-502010 Social Security 13,418.38 8,541.58 0.00 4,876.80 36.34
10-160-502020 Group Health Insurance 12,436.90 8,276.99 0.00 4,159.91 33.45
10-160-502030 Retirement 20,863.01 12,668.28 0.00 8,194.73 39.28
10-160-502040 Workers Compensation 154.89 154.89 0.00 0.00 0.00
10-160-502050 Life Insurance 163.88 113.54 0.00 50.34 30.72
10-160-502060 Long Term Disability 272.64 188.37 0.00 84.27 30.91
10-160-502070 Employee Assistance Prgm 51.73 38.98 0.00 12.75 24.65
E05 Personnel Services 221,365.06 143,245.21 0.00 78,119.85 35.29
10-160-511010 Advertising 0.00 0.00 0.00 0.00 0.00
10-160-511020 Postage 4,000.00 1,947.91 0.00 2,052.09 51.30
10-160-512010 Printing 1,090.00 41.50 0.00 1,048.50 96.19
GL - Trial Balance by Acct Type and Full Acct Number (08/05/2014 - 8:49 AM)Page 10
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-160-512020 Copies 1,000.00 99.52 0.00 900.48 90.05
10-160-513010 Office Supplies 1,600.00 147.61 0.00 1,452.39 90.77
E10 Materials & Supplies 7,690.00 2,236.54 0.00 5,453.46 70.92
10-160-520025 Security 10,000.00 5,464.32 0.00 4,535.68 45.36
10-160-520030 Dues And Publications 450.00 392.32 0.00 57.68 12.82
10-160-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-160-520070 Training And Education 2,000.00 552.95 0.00 1,447.05 72.35
10-160-522020 Professional Services 3,000.00 1,125.00 0.00 1,875.00 62.50
10-160-525005 Appointed Counsel 7,000.00 4,589.30 0.00 2,410.70 34.44
10-160-525010 Care Of Prisoners 3,380.50 0.00 0.00 3,380.50 100.00
10-160-525030 Court Cost & Witness Fees 40.00 0.00 0.00 40.00 100.00
E15 Contractual Services 25,870.50 12,123.89 0.00 13,746.61 53.14
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 1,200.00 349.41 218.75 631.85 52.65
10-160-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00
E25 Repairs & Maintenance 1,200.00 349.41 218.75 631.85 52.65
10-160-572020 Purchase Of Equipment 16,251.06 1,562.42 14,726.06 -37.42 -0.23
E70 Capital Purchases 16,251.06 1,562.42 14,726.06 -37.42 -0.23
160 Municipal Court 272,376.62 159,517.47 14,944.81 97,914.35 35.95
170 Human Resources
10-170-501020 Salaries 150,912.28 109,126.10 0.00 41,786.18 27.69
10-170-501050 Parttime(wo Benefits)9,600.00 7,773.86 0.00 1,826.14 19.02
10-170-501090 Overtime 300.00 308.74 0.00 -8.74 -2.91
10-170-502010 Social Security 12,302.14 9,130.64 0.00 3,171.50 25.78
10-170-502020 Group Health Insurance 16,353.16 8,899.02 0.00 7,454.14 45.58
10-170-502030 Retirement 29,742.18 19,807.66 0.00 9,934.52 33.40
10-170-502040 Workers Compensation 301.18 301.18 0.00 0.00 0.00
10-170-502050 Life Insurance 250.06 175.96 0.00 74.10 29.63
10-170-502060 Long Term Disability 366.60 259.12 0.00 107.48 29.32
10-170-502070 Employee Assistance Prgm 46.53 45.13 0.00 1.40 3.01
10-170-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 220,174.13 155,827.41 0.00 64,346.72 29.23
10-170-511010 Advertising 150.00 71.75 0.00 78.25 52.17
10-170-511020 Postage 1,000.00 74.04 0.00 925.96 92.60
10-170-512010 Printing 2,500.00 495.10 0.00 2,004.90 80.20
10-170-512020 Copies 1,500.00 267.84 0.00 1,232.16 82.14
10-170-513010 Office Supplies 1,500.00 367.18 0.00 1,132.82 75.52
10-170-517010 Operational Supplies 1,350.00 38.94 0.00 1,311.06 97.12
E10 Materials & Supplies 8,000.00 1,314.85 0.00 6,685.15 83.56
10-170-520030 Dues And Publications 1,255.00 407.50 0.00 847.50 67.53
GL - Trial Balance by Acct Type and Full Acct Number (08/05/2014 - 8:49 AM)Page 11
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
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,676.30 0.00 1,823.70 52.11
10-170-520070 Training And Education 4,000.00 2,300.86 0.00 1,699.14 42.48
10-170-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00
10-170-521060 Drugalcohol Screening 6,000.00 5,751.75 0.00 248.25 4.14
10-170-522020 Professional Services 8,000.00 1,539.57 0.00 6,460.43 80.76
10-170-529010 Special Events 0.00 0.00 0.00 0.00 0.00
10-170-529015 Human Rights Commission 0.00 0.00 0.00 0.00 0.00
E15 Contractual Services 22,755.00 11,675.98 0.00 11,079.02 48.69
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 200.00 218.76 218.75 -237.51 -118.75
10-170-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00
E25 Repairs & Maintenance 200.00 218.76 218.75 -237.51 -118.75
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 251,129.13 169,037.00 218.75 81,873.39 32.60
180 Finance Department
10-180-501020 Salaries 639,306.34 396,137.91 0.00 243,168.43 38.04
10-180-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00
10-180-501050 Parttime(wo Benefits)18,904.18 12,796.96 0.00 6,107.22 32.31
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
10-180-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00
10-180-502010 Social Security 50,353.11 30,497.19 0.00 19,855.92 39.43
10-180-502020 Group Health Insurance 76,739.99 55,734.81 0.00 21,005.18 27.37
10-180-502030 Retirement 125,943.35 71,701.11 0.00 54,242.24 43.07
10-180-502040 Workers Compensation 1,634.95 1,634.95 0.00 0.00 0.00
10-180-502050 Life Insurance 1,095.73 651.78 0.00 443.95 40.52
10-180-502060 Long Term Disability 1,691.84 1,072.30 0.00 619.54 36.62
10-180-502070 Employee Assistance Prgm 285.94 215.35 0.00 70.59 24.69
E05 Personnel Services 915,955.43 570,442.36 0.00 345,513.07 37.72
10-180-511010 Advertising 2,000.00 52.50 0.00 1,947.50 97.38
10-180-511020 Postage 13,500.00 6,218.03 0.00 7,281.97 53.94
10-180-511021 Mail Machine Cost 2,000.00 1,876.50 0.00 123.50 6.18
10-180-512010 Printing 6,500.00 1,952.21 0.00 4,547.79 69.97
10-180-512020 Copies 5,000.00 2,160.18 0.00 2,839.82 56.80
10-180-512021 Copy Machine Cost 0.00 -858.71 1,312.47 -453.76 0.00
10-180-513010 Office Supplies 6,000.00 3,630.52 0.00 2,369.48 39.49
10-180-517010 Operational Supplies 4,000.00 2,328.38 0.00 1,671.62 41.79
E10 Materials & Supplies 39,000.00 17,359.61 1,312.47 20,327.92 52.12
10-180-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00
GL - Trial Balance by Acct Type and Full Acct Number (08/05/2014 - 8:49 AM)Page 12
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-180-520020 Auditing Travel Expenses 0.00 0.00 0.00 0.00 0.00
10-180-520030 Dues And Publications 2,400.00 1,724.08 0.00 675.92 28.16
10-180-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-180-520070 Training And Education 2,200.00 152.32 0.00 2,047.68 93.08
10-180-520080 Tuition Reimbursement 1,800.00 0.00 0.00 1,800.00 100.00
10-180-522010 Audit 27,700.00 38,955.00 0.00 -11,255.00 -40.63
10-180-522020 Professional Services 0.00 0.00 0.00 0.00 0.00
E15 Contractual Services 34,100.00 40,831.40 0.00 -6,731.40 -19.74
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 2,000.00 928.15 0.00 1,071.85 53.59
10-180-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00
E25 Repairs & Maintenance 2,000.00 928.15 0.00 1,071.85 53.59
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 991,055.43 629,561.52 1,312.47 360,181.44 36.34
185 Non-Departmental
10-185-501020 Salaries 0.00 0.00 0.00 0.00 0.00
10-185-501021 Vacancy Savings 16,577.11 0.00 0.00 16,577.11 100.00
10-185-501022 Separation Incentive Prog Svgs 22,325.24 0.00 0.00 22,325.24 100.00
10-185-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00
10-185-502021 Self Insurance-Group Health 56,030.00 72,078.94 0.00 -16,048.94 -28.64
10-185-502022 Wellness Assessment 25,000.00 0.00 0.00 25,000.00 100.00
10-185-503010 Awards Program 3,000.00 0.00 0.00 3,000.00 100.00
10-185-504010 Employee Salary Guarantee Fund 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 122,932.35 72,078.94 0.00 50,853.41 41.37
10-185-514010 Gas 19,000.00 13,552.79 0.00 5,447.21 28.67
10-185-514011 Gas Oil & Antifreeze 0.00 522.78 0.00 -522.78 0.00
10-185-514012 Gas, Oil, Antifreeze ALLOCATE 0.00 0.00 0.00 0.00 0.00
E10 Materials & Supplies 19,000.00 14,075.57 0.00 4,924.43 25.92
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 287,100.00 247,793.02 0.00 39,306.98 13.69
10-185-521020 Insurance Deductible 30,000.00 10,182.27 0.00 19,817.73 66.06
10-185-521030 Self Ins Prop & Casualty 70,000.00 95,704.38 -68.28 -25,636.10 -36.62
10-185-521070 Prov For Unsettled Claims 0.00 0.00 0.00 0.00 0.00
10-185-522015 TIF Prof Svcs 0.00 -11.52 0.00 11.52 0.00
10-185-522020 Professional Services 129,050.00 24,164.97 8,216.66 96,668.37 74.91
10-185-522025 JCTV 55,000.00 27,500.00 27,500.00 0.00 0.00
10-185-524010 Trash Collections 500.00 0.00 0.00 500.00 100.00
10-185-526030 Assessment Charge 45,500.00 34,174.93 0.00 11,325.07 24.89
10-185-527020 Economic Development 185,000.00 185,000.00 46,250.00 -46,250.00 -25.00
GL - Trial Balance by Acct Type and Full Acct Number (08/05/2014 - 8:49 AM)Page 13
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-185-529010 Special Events 7,000.00 1,505.00 0.00 5,495.00 78.50
E15 Contractual Services 809,150.00 626,013.05 81,898.38 101,238.57 12.51
10-185-531010 Electricity 42,400.00 21,051.68 0.00 21,348.32 50.35
10-185-533010 Natural Gas 6,000.00 5,261.29 0.00 738.71 12.31
10-185-535010 WaterSewer 6,000.00 3,488.93 0.00 2,511.07 41.85
10-185-535020 Downtown Irrigation 0.00 0.00 0.00 0.00 0.00
E20 Utilities 54,400.00 29,801.90 0.00 24,598.10 45.22
10-185-540010 Building & Grounds Maint.60,000.00 26,866.77 17,777.89 15,355.34 25.59
10-185-540020 Tree & Landscape Maint 25,000.00 25,000.00 0.00 0.00 0.00
10-185-547020 Maintenance Agreements 2,000.00 1,248.00 0.00 752.00 37.60
E25 Repairs & Maintenance 87,000.00 53,114.77 17,777.89 16,107.34 18.51
10-185-550010 Miscellaneous 10,000.00 1,343.00 0.00 8,657.00 86.57
10-185-550015 Bad Debt Expense 0.00 0.00 0.00 0.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-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 5,500.00 2,780.00 0.00 2,720.00 49.45
10-185-550041 ALPLA Settlement 50,000.00 50,000.00 0.00 0.00 0.00
10-185-550043 JC Fire Museum 0.00 11,247.91 0.00 -11,247.91 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 0.00 0.00 0.00 0.00 0.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 75,500.00 75,370.91 0.00 129.09 0.17
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
185 Non-Departmental 1,167,982.35 870,455.14 99,676.27 197,850.94 16.94
190 I.T. Department
10-190-501020 Salaries 551,117.31 394,848.59 0.00 156,268.72 28.35
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 0.00 0.00 0.00 0.00 0.00
GL - Trial Balance by Acct Type and Full Acct Number (08/05/2014 - 8:49 AM)Page 14
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-190-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00
10-190-502010 Social Security 42,160.47 28,895.37 0.00 13,265.10 31.46
10-190-502020 Group Health Insurance 63,175.48 45,245.31 0.00 17,930.17 28.38
10-190-502030 Retirement 108,570.11 71,467.83 0.00 37,102.28 34.17
10-190-502040 Workers Compensation 783.06 783.06 0.00 0.00 0.00
10-190-502050 Life Insurance 908.88 639.41 0.00 269.47 29.65
10-190-502060 Long Term Disability 1,459.74 1,010.45 0.00 449.29 30.78
10-190-502070 Employee Assistance Prgm 205.35 154.69 0.00 50.66 24.67
E05 Personnel Services 768,380.40 543,044.71 0.00 225,335.69 29.33
10-190-511010 Advertising 500.00 50.75 0.00 449.25 89.85
10-190-511020 Postage 200.00 12.26 0.00 187.74 93.87
10-190-512010 Printing 0.00 0.00 0.00 0.00 0.00
10-190-512020 Copies 200.00 26.83 0.00 173.17 86.59
10-190-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00
10-190-513010 Office Supplies 1,000.00 817.37 0.00 182.63 18.26
10-190-514030 Small Tools 0.00 0.00 0.00 0.00 0.00
10-190-514040 Food 50.00 20.50 0.00 29.50 59.00
10-190-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00
10-190-517010 Operational Supplies 1,500.00 1,232.81 0.00 267.19 17.81
E10 Materials & Supplies 3,450.00 2,160.52 0.00 1,289.48 37.38
10-190-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00
10-190-520030 Dues And Publications 500.00 200.00 0.00 300.00 60.00
10-190-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-190-520070 Training And Education 8,000.00 6,911.99 0.00 1,088.01 13.60
10-190-520080 Tuition Reimbursement 7,500.00 1,200.00 0.00 6,300.00 84.00
10-190-522020 Professional Services 2,000.00 808.91 0.00 1,191.09 59.55
10-190-522030 Services - Prof Training 0.00 0.00 0.00 0.00 0.00
10-190-522040 Service-internet T1 Web 19,800.00 12,947.76 0.00 6,852.24 34.61
10-190-522050 Service-remote Locations 0.00 0.00 0.00 0.00 0.00
10-190-522060 City Web Site 2,000.00 159.98 0.00 1,840.02 92.00
E15 Contractual Services 39,800.00 22,228.64 0.00 17,571.36 44.15
10-190-534010 Telephone 60,000.00 33,152.25 0.00 26,847.75 44.75
E20 Utilities 60,000.00 33,152.25 0.00 26,847.75 44.75
10-190-545010 Software Licensemaint 229,500.00 190,122.56 5,909.53 33,467.91 14.58
10-190-545020 Citywide Wiringnetwork 3,000.00 2,800.93 0.00 199.07 6.64
10-190-547010 Equipment Maintenance 3,000.00 1,894.11 0.00 1,105.89 36.86
10-190-547020 Maintenance Agreements 34,000.00 30,274.37 181.16 3,544.47 10.42
E25 Repairs & Maintenance 269,500.00 225,091.97 6,090.69 38,317.34 14.22
10-190-572020 Purchase Of Equipment 25,000.00 24,999.36 0.00 0.64 0.00
E70 Capital Purchases 25,000.00 24,999.36 0.00 0.64 0.00
190 I.T. Department 1,166,130.40 850,677.45 6,090.69 309,362.26 26.53
300 Police Department
GL - Trial Balance by Acct Type and Full Acct Number (08/05/2014 - 8:49 AM)Page 15
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-300-501020 Salaries 3,946,429.11 2,817,576.47 0.00 1,128,852.64 28.60
10-300-501030 Holiday Pay 119,000.00 89,572.33 0.00 29,427.67 24.73
10-300-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00
10-300-501050 Parttime(wo Benefits)30,400.00 18,921.00 0.00 11,479.00 37.76
10-300-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00
10-300-501070 Stand-by Plan 6,800.00 5,832.00 0.00 968.00 14.24
10-300-501090 Overtime 228,908.10 140,052.28 0.00 88,855.82 38.82
10-300-501095 Overtime Straight Pay 6,000.00 2,713.92 0.00 3,286.08 54.77
10-300-502010 Social Security 327,345.92 222,760.55 0.00 104,585.37 31.95
10-300-502020 Group Health Insurance 703,711.28 460,520.69 0.00 243,190.59 34.56
10-300-502030 Retirement 918,697.38 579,665.36 0.00 339,032.02 36.90
10-300-502040 Workers Compensation 70,999.83 70,999.83 0.00 0.00 0.00
10-300-502050 Life Insurance 6,782.09 4,466.41 0.00 2,315.68 34.14
10-300-502060 Long Term Disability 11,071.66 7,305.21 0.00 3,766.45 34.02
10-300-502070 Employee Assistance Prgm 1,927.56 1,442.89 0.00 484.67 25.14
10-300-503010 Awards Program 1,600.00 1,600.00 0.00 0.00 0.00
10-300-503020 Unemployment Compensation 1,000.00 129.30 0.00 870.70 87.07
E05 Personnel Services 6,380,672.93 4,423,558.24 0.00 1,957,114.69 30.67
10-300-511010 Advertising 3,000.00 1,271.25 0.00 1,728.75 57.63
10-300-511020 Postage 1,500.00 914.06 0.00 585.94 39.06
10-300-512010 Printing 6,000.00 5,630.60 0.00 369.40 6.16
10-300-512020 Copies 200.00 0.00 0.00 200.00 100.00
10-300-512030 Photographic Supplies 2,000.00 1,097.85 0.00 902.15 45.11
10-300-513010 Office Supplies 9,000.00 5,717.44 0.00 3,282.56 36.47
10-300-514010 Gas 282,000.00 151,996.69 0.00 130,003.31 46.10
10-300-514040 Food 700.00 211.46 0.00 488.54 69.79
10-300-515040 First Aid Supplies 1,000.00 802.88 0.00 197.12 19.71
10-300-516010 Ammunition & Firearms Supplies 23,000.00 17,607.13 5,117.50 275.37 1.20
10-300-516020 Dare Program 16,500.00 4,900.89 10,808.72 790.39 4.79
10-300-516030 Special Investigation 2,500.00 2,006.80 0.00 493.20 19.73
10-300-516040 Investigations (Grant)0.00 0.00 0.00 0.00 0.00
10-300-516050 Community Projects 700.00 175.00 0.00 525.00 75.00
10-300-517010 Operational Supplies 34,000.00 31,136.31 300.00 2,563.69 7.54
E10 Materials & Supplies 382,100.00 223,468.36 16,226.22 142,405.42 37.27
10-300-520030 Dues And Publications 4,000.00 3,368.46 0.00 631.54 15.79
10-300-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-300-520070 Training And Education 0.00 -192.00 0.00 192.00 0.00
10-300-520080 Tuition Reimbursement 5,100.00 1,710.00 0.00 3,390.00 66.47
10-300-520090 Recruitment 1,800.00 1,269.00 0.00 531.00 29.50
10-300-521040 Medical Claimsservices 6,755.25 6,365.00 0.00 390.25 5.78
10-300-521050 Medical Services 0.00 0.00 0.00 0.00 0.00
10-300-522020 Professional Services 18,944.75 14,435.15 0.00 4,509.60 23.80
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-523010 Equipment Rentlease 6,900.00 6,900.00 0.00 0.00 0.00
10-300-523030 Building Lease 1,200.00 1,000.00 200.00 0.00 0.00
10-300-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00
GL - Trial Balance by Acct Type and Full Acct Number (08/05/2014 - 8:49 AM)Page 16
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-300-525020 Sober Driver Program 11,040.00 2,690.50 0.00 8,349.50 75.63
10-300-525050 Police Reserve 0.00 0.00 0.00 0.00 0.00
10-300-529010 Special Events 2,200.00 1,031.79 0.00 1,168.21 53.10
E15 Contractual Services 57,940.00 38,577.90 200.00 19,162.10 33.07
10-300-531010 Electricity 60,000.00 39,320.37 0.00 20,679.63 34.47
10-300-533010 Natural Gas 14,800.00 12,032.65 0.00 2,767.35 18.70
10-300-534010 Telephone 10,900.00 1,326.58 0.00 9,573.42 87.83
10-300-535010 WaterSewer 4,200.00 2,784.91 0.00 1,415.09 33.69
E20 Utilities 89,900.00 55,464.51 0.00 34,435.49 38.30
10-300-540010 Building & Grounds Maint.51,000.00 27,663.41 -12,660.45 35,997.04 70.58
10-300-541030 Vehicle Wash 12,000.00 9,198.70 0.00 2,801.30 23.34
10-300-544010 K-9 Operations 10,500.00 6,398.09 0.00 4,101.91 39.07
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 17,500.00 5,004.23 0.00 12,495.77 71.40
10-300-546010 Clothing Expense 43,000.00 39,190.57 -478.50 4,287.93 9.97
10-300-546020 Uniform Cleaning 26,000.00 17,030.61 0.00 8,969.39 34.50
10-300-547010 Equipment Maintenance 12,844.00 10,227.33 0.00 2,616.67 20.37
10-300-547020 Maintenance Agreements 21,042.20 20,141.69 900.51 0.00 0.00
10-300-547030 Radio Maintenance 9,113.80 4,950.72 0.00 4,163.08 45.68
E25 Repairs & Maintenance 203,000.00 139,805.35 -12,238.44 75,433.09 37.16
10-300-572010 Purchase Of Vehicles 250,000.00 250,000.00 0.00 0.00 0.00
10-300-572020 Purchase Of Equipment 0.00 0.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 11,086.20 11,086.20 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 10,133.00 8,418.11 0.00 1,714.89 16.92
10-300-572100 MDT Year 3 Equipment 264,894.65 264,894.65 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-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
GL - Trial Balance by Acct Type and Full Acct Number (08/05/2014 - 8:49 AM)Page 17
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
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 536,113.85 534,398.96 0.00 1,714.89 0.32
300 Police Department 7,649,726.78 5,415,273.32 4,187.78 2,230,265.68 29.15
310 School Resource Officer
10-310-501020 Salaries 237,278.98 157,616.35 0.00 79,662.63 33.57
10-310-501030 Holiday Pay 6,000.00 3,503.06 0.00 2,496.94 41.62
10-310-501090 Overtime 7,126.00 16,745.31 0.00 -9,619.31 -134.99
10-310-501095 Overtime Straight Pay 0.00 410.80 0.00 -410.80 0.00
10-310-502010 Social Security 19,155.98 12,230.12 0.00 6,925.86 36.16
10-310-502020 Group Health Insurance 40,725.87 34,132.63 0.00 6,593.24 16.19
10-310-502030 Retirement 54,838.69 37,081.21 0.00 17,757.48 32.38
10-310-502040 Workers Compensation 3,631.31 3,631.31 0.00 0.00 0.00
10-310-502050 Life Insurance 401.52 257.43 0.00 144.09 35.89
10-310-502060 Long Term Disability 663.84 426.51 0.00 237.33 35.75
10-310-502070 Employee Assistance Prgm 111.00 83.63 0.00 27.37 24.66
E05 Personnel Services 369,933.19 266,118.36 0.00 103,814.83 28.06
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 369,933.19 266,118.36 0.00 103,814.83 28.06
320 M.U.S.T.A.N.G.
10-320-501020 Salaries 92,726.19 65,964.13 0.00 26,762.06 28.86
10-320-501030 Holiday Pay 2,500.00 2,324.66 0.00 175.34 7.01
10-320-501090 Overtime 6,897.00 9,115.88 0.00 -2,218.88 -32.17
10-320-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00
10-320-502010 Social Security 7,812.42 5,545.54 0.00 2,266.88 29.02
10-320-502020 Group Health Insurance 17,953.72 11,834.94 0.00 6,118.78 34.08
10-320-502030 Retirement 22,364.98 16,100.18 0.00 6,264.80 28.01
10-320-502040 Workers Compensation 1,677.98 1,677.98 0.00 0.00 0.00
10-320-502050 Life Insurance 157.92 108.50 0.00 49.42 31.29
10-320-502060 Long Term Disability 259.68 177.67 0.00 82.01 31.58
GL - Trial Balance by Acct Type and Full Acct Number (08/05/2014 - 8:49 AM)Page 18
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-320-502070 Employee Assistance Prgm 44.40 33.46 0.00 10.94 24.64
E05 Personnel Services 152,394.29 112,882.94 0.00 39,511.35 25.93
10-320-514010 Gas 20,000.00 4,358.07 0.00 15,641.93 78.21
10-320-516040 Investigations 16,954.99 15,265.17 0.00 1,689.82 9.97
10-320-517010 Operational Supplies 1,000.00 170.00 0.00 830.00 83.00
E10 Materials & Supplies 37,954.99 19,793.24 0.00 18,161.75 47.85
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 13,100.00 13,100.00 0.00 0.00 0.00
10-320-523020 Building Lease 0.00 0.00 0.00 0.00 0.00
E15 Contractual Services 13,100.00 13,100.00 0.00 0.00 0.00
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.203,449.28 145,776.18 0.00 57,673.10 28.35
330 Animal Control
10-330-501020 Salaries 311,708.10 225,362.34 0.00 86,345.76 27.70
10-330-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00
10-330-501050 Parttime(wo Benefits)600.00 0.00 0.00 600.00 100.00
10-330-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00
10-330-501070 Stand-by Plan 3,000.00 3,100.00 0.00 -100.00 -3.33
10-330-501090 Overtime 1,709.00 1,071.26 0.00 637.74 37.32
10-330-501095 Overtime Straight Pay 500.00 155.00 0.00 345.00 69.00
10-330-502010 Social Security 24,290.06 16,662.69 0.00 7,627.37 31.40
10-330-502020 Group Health Insurance 57,550.07 39,286.08 0.00 18,263.99 31.74
10-330-502030 Retirement 62,432.67 36,816.97 0.00 25,615.70 41.03
10-330-502040 Workers Compensation 5,137.19 5,137.19 0.00 0.00 0.00
10-330-502050 Life Insurance 527.52 368.20 0.00 159.32 30.20
10-330-502060 Long Term Disability 870.96 609.26 0.00 261.70 30.05
10-330-502070 Employee Assistance Prgm 177.60 133.80 0.00 43.80 24.66
10-330-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 468,503.17 328,702.79 0.00 139,800.38 29.84
10-330-511010 Advertising 500.00 0.00 0.00 500.00 100.00
10-330-511020 Postage 500.00 38.38 0.00 461.62 92.32
10-330-512010 Printing 1,700.00 1,044.98 0.00 655.02 38.53
10-330-512020 Copies 20.00 0.00 0.00 20.00 100.00
GL - Trial Balance by Acct Type and Full Acct Number (08/05/2014 - 8:49 AM)Page 19
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-330-513010 Office Supplies 800.00 429.62 0.00 370.38 46.30
10-330-514030 Small Tools 250.00 42.10 0.00 207.90 83.16
10-330-515040 First Aid Supplies 650.00 454.17 0.00 195.83 30.13
10-330-517010 Operational Supplies 6,000.00 4,947.25 0.00 1,052.75 17.55
E10 Materials & Supplies 10,420.00 6,956.50 0.00 3,463.50 33.24
10-330-520030 Dues And Publications 1,524.65 802.75 0.00 721.90 47.35
10-330-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-330-520070 Training And Education 1,650.00 1,568.87 0.00 81.13 4.92
10-330-521040 Medical Claimsservices 1,000.00 0.00 0.00 1,000.00 100.00
10-330-522020 Professional Services 8,975.35 3,337.46 0.00 5,637.89 62.82
10-330-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00
10-330-529050 Spay & Neuter Program 10,000.00 3,984.57 0.00 6,015.43 60.15
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
E15 Contractual Services 23,150.00 9,693.65 0.00 13,456.35 58.13
10-330-531010 Electricity 24,000.00 15,862.55 0.00 8,137.45 33.91
10-330-533010 Natural Gas 13,200.00 10,670.30 0.00 2,529.70 19.16
10-330-534010 Telephone 572.00 191.80 0.00 380.20 66.47
10-330-535010 WaterSewer 2,500.00 2,293.56 0.00 206.44 8.26
E20 Utilities 40,272.00 29,018.21 0.00 11,253.79 27.94
10-330-540010 Building & Grounds Maint.8,644.00 5,193.55 -2,380.90 5,831.35 67.46
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 42,000.00 25,917.38 0.00 16,082.62 38.29
10-330-546010 Clothing Expense 3,000.00 1,749.86 0.00 1,250.14 41.67
10-330-546020 Uniform Cleaning 100.00 0.00 0.00 100.00 100.00
10-330-547010 Equipment Maintenance 1,800.00 1,720.99 0.00 79.01 4.39
10-330-547020 Maintenance Agreements 1,656.00 1,500.00 0.00 156.00 9.42
10-330-547030 Radio Maintenance 700.00 0.00 0.00 700.00 100.00
E25 Repairs & Maintenance 58,440.00 36,621.78 -2,380.90 24,199.12 41.41
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 0.00 0.00 0.00 0.00 0.00
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 600,785.17 410,992.93 -2,380.90 192,173.14 31.99
390 9-1-1 Police
10-390-501020 Salaries 765,641.65 521,071.16 0.00 244,570.49 31.94
10-390-501030 Holiday Pay 29,000.00 22,630.62 0.00 6,369.38 21.96
10-390-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00
10-390-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00
GL - Trial Balance by Acct Type and Full Acct Number (08/05/2014 - 8:49 AM)Page 20
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-390-501090 Overtime 15,814.00 14,102.33 0.00 1,711.67 10.82
10-390-501095 Overtime Straight Pay 500.00 88.66 0.00 411.34 82.27
10-390-502010 Social Security 62,038.10 40,385.27 0.00 21,652.83 34.90
10-390-502020 Group Health Insurance 157,153.93 96,996.03 0.00 60,157.90 38.28
10-390-502030 Retirement 159,758.26 96,251.68 0.00 63,506.58 39.75
10-390-502040 Workers Compensation 1,350.99 1,350.99 0.00 0.00 0.00
10-390-502050 Life Insurance 1,305.36 839.16 0.00 466.20 35.71
10-390-502060 Long Term Disability 2,142.66 1,376.72 0.00 765.94 35.75
10-390-502070 Employee Assistance Prgm 438.45 330.30 0.00 108.15 24.67
10-390-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 1,195,143.40 795,422.92 0.00 399,720.48 33.45
10-390-511010 Advertising 200.00 0.00 0.00 200.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 433.22 0.00 4,566.78 91.34
E10 Materials & Supplies 5,200.00 433.22 0.00 4,766.78 91.67
10-390-520030 Dues And Publications 900.00 115.00 0.00 785.00 87.22
10-390-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-390-520070 Training And Education 0.00 -12.00 0.00 12.00 0.00
10-390-522020 Professional Services 2,000.00 649.00 0.00 1,351.00 67.55
10-390-523010 Equipment Rentlease 100,000.00 72,586.45 1,620.00 25,793.55 25.79
E15 Contractual Services 102,900.00 73,338.45 1,620.00 27,941.55 27.15
10-390-534010 Telephone 150.00 0.00 0.00 150.00 100.00
E20 Utilities 150.00 0.00 0.00 150.00 100.00
10-390-546010 Clothing Expense 6,400.00 12.00 0.00 6,388.00 99.81
10-390-546020 Uniform Cleaning 0.00 0.00 0.00 0.00 0.00
10-390-547010 Equipment Maintenance 3,000.00 1,653.60 0.00 1,346.40 44.88
10-390-547020 Maintenance Agreements 25,000.00 15,356.25 4,999.50 4,644.25 18.58
10-390-547030 Radio Maintenance 4,000.00 900.00 0.00 3,100.00 77.50
E25 Repairs & Maintenance 38,400.00 17,921.85 4,999.50 15,478.65 40.31
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,341,793.40 887,116.44 6,619.50 448,057.46 33.39
400 Fire Department
10-400-501020 Salaries 3,413,576.57 2,425,149.03 0.00 988,427.54 28.96
10-400-501030 Holiday Pay 267,630.97 240,770.40 0.00 26,860.57 10.04
10-400-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00
10-400-501080 Step-up Pay 28,000.00 19,770.00 0.00 8,230.00 29.39
10-400-501090 Overtime 30,000.00 20,946.79 0.00 9,053.21 30.18
10-400-501095 Overtime Straight Pay 32,000.00 18,384.44 0.00 13,615.56 42.55
10-400-502010 Social Security 53,115.63 36,370.29 0.00 16,745.34 31.53
10-400-502020 Group Health Insurance 591,688.25 395,237.25 0.00 196,451.00 33.20
10-400-502030 Retirement 1,639,063.50 1,151,088.91 0.00 487,974.59 29.77
GL - Trial Balance by Acct Type and Full Acct Number (08/05/2014 - 8:49 AM)Page 21
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-400-502040 Workers Compensation 108,750.00 108,750.00 0.00 0.00 0.00
10-400-502050 Life Insurance 5,774.79 3,960.12 0.00 1,814.67 31.42
10-400-502060 Long Term Disability 9,511.67 6,511.06 0.00 3,000.61 31.55
10-400-502070 Employee Assistance Prgm 1,608.36 1,211.65 0.00 396.71 24.67
10-400-503010 Awards Program 1,000.00 633.21 0.00 366.79 36.68
E05 Personnel Services 6,181,719.74 4,428,783.15 0.00 1,752,936.59 28.36
10-400-511010 Advertising 150.00 0.00 0.00 150.00 100.00
10-400-511020 Postage 300.00 172.87 0.00 127.13 42.38
10-400-512010 Printing 1,250.00 1,038.18 0.00 211.82 16.95
10-400-512020 Copies 200.00 0.00 0.00 200.00 100.00
10-400-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00
10-400-513010 Office Supplies 1,800.00 809.34 0.00 990.66 55.04
10-400-514010 Gas 77,000.00 43,902.35 0.00 33,097.65 42.98
10-400-514020 Chemicals 2,000.00 638.14 0.00 1,361.86 68.09
10-400-514030 Small Tools 2,397.67 1,285.99 0.00 1,111.68 46.37
10-400-514040 Food 0.00 0.00 0.00 0.00 0.00
10-400-515040 First Aid Supplies 400.00 0.00 0.00 400.00 100.00
10-400-517010 Operational Supplies 8,180.00 4,929.34 211.50 3,039.16 37.15
E10 Materials & Supplies 93,677.67 52,776.21 211.50 40,689.96 43.44
10-400-520030 Dues And Publications 1,240.00 576.95 0.00 663.05 53.47
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 10,000.00 5,935.00 0.00 4,065.00 40.65
10-400-520080 Tuition Reimbursement 5,000.00 0.00 0.00 5,000.00 100.00
10-400-520085 Traing-Home Land Security 0.00 0.00 0.00 0.00 0.00
10-400-521040 Medical Claimsservices 2,700.00 2,227.25 0.00 472.75 17.51
10-400-522020 Professional Services 1,200.00 900.00 0.00 300.00 25.00
10-400-523010 Equipment Rentlease 2,000.00 0.00 0.00 2,000.00 100.00
10-400-524010 Trash Collections 250.00 0.00 0.00 250.00 100.00
10-400-529010 Special Events 6,000.00 4,454.02 0.00 1,545.98 25.77
10-400-529040 INACTIVE - Fire Hydrants 0.00 0.00 0.00 0.00 0.00
E15 Contractual Services 28,390.00 14,093.22 0.00 14,296.78 50.36
10-400-531010 Electricity 27,500.00 17,867.21 0.00 9,632.79 35.03
10-400-533010 Natural Gas 17,500.00 17,120.19 0.00 379.81 2.17
10-400-534010 Telephone 17,500.00 11,880.42 0.00 5,619.58 32.11
10-400-535010 WaterSewer 8,720.00 8,122.67 0.00 597.33 6.85
E20 Utilities 71,220.00 54,990.49 0.00 16,229.51 22.79
10-400-540010 Building & Grounds Maint.44,934.00 32,472.39 -1,999.64 14,461.25 32.18
10-400-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00
10-400-546010 Clothing Expense 35,000.00 23,933.92 -10,122.43 21,188.51 60.54
10-400-546020 Uniform Cleaning 1,066.00 0.00 0.00 1,066.00 100.00
10-400-547010 Equipment Maintenance 18,000.00 4,979.11 0.00 13,020.89 72.34
10-400-547020 Maintenance Agreements 13,900.00 17,940.84 -8,150.61 4,109.77 29.57
10-400-547030 Radio Maintenance 7,000.00 441.35 0.00 6,558.65 93.70
E25 Repairs & Maintenance 119,900.00 79,767.61 -20,272.68 60,405.07 50.38
GL - Trial Balance by Acct Type and Full Acct Number (08/05/2014 - 8:49 AM)Page 22
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-400-572010 Purchase Of Vehicles 0.00 0.00 0.00 0.00 0.00
10-400-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
10-400-572021 Purchase of Equipment-ONE TIME 253,573.50 24,769.42 0.00 228,804.08 90.23
10-400-572060 Fire Grant Equipgear 0.00 0.00 0.00 0.00 0.00
10-400-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00
E70 Capital Purchases 253,573.50 24,769.42 0.00 228,804.08 90.23
400 Fire Department 6,748,480.91 4,655,180.10 -20,061.18 2,113,361.99 31.32
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 0.00 0.00 0.00 0.00
10-500-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-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
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
GL - Trial Balance by Acct Type and Full Acct Number (08/05/2014 - 8:49 AM)Page 23
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00
500 Public Works 0.00 0.00 0.00 0.00 0.00
520 Plan & Protect Svcs-Admin
10-520-501020 Salaries 205,628.16 147,060.06 0.00 58,568.10 28.48
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 15,730.55 10,732.76 0.00 4,997.79 31.77
10-520-502020 Group Health Insurance 31,736.64 21,507.41 0.00 10,229.23 32.23
10-520-502030 Retirement 40,508.75 26,617.91 0.00 13,890.84 34.29
10-520-502040 Workers Compensation 524.91 524.91 0.00 0.00 0.00
10-520-502050 Life Insurance 347.76 240.54 0.00 107.22 30.83
10-520-502060 Long Term Disability 531.84 367.85 0.00 163.99 30.83
10-520-502070 Employee Assistance Prgm 88.80 66.89 0.00 21.91 24.67
10-520-503010 Awards Program 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 295,097.41 207,118.33 0.00 87,979.08 29.81
10-520-511010 Advertising 3.33 0.00 0.00 3.33 100.00
10-520-511020 Postage 200.00 57.49 0.00 142.51 71.26
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 800.00 569.90 0.00 230.10 28.76
10-520-514010 Gas 20,000.00 7,648.57 0.00 12,351.43 61.76
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 196.67 196.67 0.00 0.00 0.00
E10 Materials & Supplies 21,200.00 8,472.63 0.00 12,727.37 60.03
10-520-520030 Dues And Publications 300.00 211.10 0.00 88.90 29.63
10-520-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-520-520070 Training And Education 1,500.00 224.00 0.00 1,276.00 85.07
10-520-522020 Professional Services 3,650.00 3,562.95 0.00 87.05 2.38
E15 Contractual Services 5,450.00 3,998.05 0.00 1,451.95 26.64
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,000.00 534.62 15.84 449.54 44.95
E25 Repairs & Maintenance 1,000.00 534.62 15.84 449.54 44.95
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 322,747.41 220,123.63 15.84 102,607.94 31.79
GL - Trial Balance by Acct Type and Full Acct Number (08/05/2014 - 8:49 AM)Page 24
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
521 Plan & Protect Svcs-Planning
10-521-501020 Salaries 51,891.84 39,776.28 0.00 12,115.56 23.35
10-521-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00
10-521-501050 Parttime(wo Benefits)12,480.00 8,184.00 0.00 4,296.00 34.42
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 4,924.45 3,668.85 0.00 1,255.60 25.50
10-521-502020 Group Health Insurance 5,961.16 3,945.00 0.00 2,016.16 33.82
10-521-502030 Retirement 10,222.69 7,199.48 0.00 3,023.21 29.57
10-521-502040 Workers Compensation 86.05 86.05 0.00 0.00 0.00
10-521-502050 Life Insurance 87.36 60.42 0.00 26.94 30.84
10-521-502060 Long Term Disability 145.20 100.43 0.00 44.77 30.83
10-521-502070 Employee Assistance Prgm 22.20 16.72 0.00 5.48 24.68
10-521-503010 Awards Program 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 85,820.95 63,037.23 0.00 22,783.72 26.55
10-521-511010 Advertising 6,500.00 2,253.75 0.00 4,246.25 65.33
10-521-511020 Postage 1,500.00 423.61 0.00 1,076.39 71.76
10-521-512010 Printing 100.00 0.00 0.00 100.00 100.00
10-521-512020 Copies 100.00 0.00 0.00 100.00 100.00
10-521-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00
10-521-513010 Office Supplies 1,000.00 372.39 0.00 627.61 62.76
10-521-514040 Food 100.00 0.00 0.00 100.00 100.00
10-521-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00
10-521-517010 Operational Supplies 2,000.00 28.54 0.00 1,971.46 98.57
E10 Materials & Supplies 11,300.00 3,078.29 0.00 8,221.71 72.76
10-521-520030 Dues And Publications 15,500.00 15,448.70 0.00 51.30 0.33
10-521-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-521-520070 Training And Education 1,700.00 249.00 0.00 1,451.00 85.35
10-521-520080 Tuition Reimbursement 1,600.00 0.00 0.00 1,600.00 100.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 18,800.00 15,697.70 0.00 3,102.30 16.50
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,400.00 1,090.31 226.72 82.97 5.93
E25 Repairs & Maintenance 1,400.00 1,090.31 226.72 82.97 5.93
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 117,320.95 82,903.53 226.72 34,190.70 29.14
GL - Trial Balance by Acct Type and Full Acct Number (08/05/2014 - 8:49 AM)Page 25
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
522 Plan & Protect Svcs-MPO
10-522-501020 Salaries 106,803.34 75,229.56 0.00 31,573.78 29.56
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 8,170.45 5,676.88 0.00 2,493.57 30.52
10-522-502020 Group Health Insurance 18,528.02 8,237.69 0.00 10,290.33 55.54
10-522-502030 Retirement 21,230.20 10,932.63 0.00 10,297.57 48.50
10-522-502040 Workers Compensation 206.52 206.52 0.00 0.00 0.00
10-522-502050 Life Insurance 213.36 121.71 0.00 91.65 42.96
10-522-502060 Long Term Disability 352.32 200.81 0.00 151.51 43.00
10-522-502070 Employee Assistance Prgm 44.40 33.46 0.00 10.94 24.64
E05 Personnel Services 155,548.61 100,639.26 0.00 54,909.35 35.30
10-522-511010 Advertising 1,000.00 631.30 0.00 368.70 36.87
10-522-511020 Postage 400.00 86.92 0.00 313.08 78.27
10-522-512010 Printing 400.00 0.00 0.00 400.00 100.00
10-522-512020 Copies 50.00 0.18 0.00 49.82 99.64
10-522-513010 Office Supplies 1,000.00 154.17 0.00 845.83 84.58
10-522-514040 Food 200.00 8.97 0.00 191.03 95.52
10-522-517010 Operational Supplies 800.00 18.07 0.00 781.93 97.74
E10 Materials & Supplies 3,850.00 899.61 0.00 2,950.39 76.63
10-522-520030 Dues And Publications 1,000.00 664.65 0.00 335.35 33.54
10-522-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-522-520070 Training And Education 2,500.00 1,568.44 0.00 931.56 37.26
10-522-522020 Professional Services 24,000.00 5,306.81 18,693.19 0.00 0.00
10-522-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00
E15 Contractual Services 27,500.00 7,539.90 18,693.19 1,266.91 4.61
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 1,400.00 295.36 29.76 1,074.88 76.78
10-522-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00
E25 Repairs & Maintenance 1,400.00 295.36 29.76 1,074.88 76.78
10-522-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
522 Plan & Protect Svcs-MPO 188,298.61 109,374.13 18,722.95 60,201.53 31.97
530 Plan & Protect Svc-RedevGrant
10-530-501020 Salaries 57,138.01 40,729.89 0.00 16,408.12 28.72
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 4,371.06 2,767.44 0.00 1,603.62 36.69
GL - Trial Balance by Acct Type and Full Acct Number (08/05/2014 - 8:49 AM)Page 26
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-530-502020 Group Health Insurance 8,609.94 4,968.90 0.00 3,641.04 42.29
10-530-502030 Retirement 11,256.19 7,372.21 0.00 3,883.98 34.51
10-530-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00
10-530-502050 Life Insurance 105.84 66.03 0.00 39.81 37.61
10-530-502060 Long Term Disability 176.64 108.89 0.00 67.75 38.35
10-530-502070 Employee Assistance Prgm 33.30 25.09 0.00 8.21 24.65
E05 Personnel Services 81,690.98 56,038.45 0.00 25,652.53 31.40
10-530-511010 Advertising 300.00 0.00 0.00 300.00 100.00
10-530-511020 Postage 100.00 40.84 0.00 59.16 59.16
10-530-512010 Printing 50.00 32.00 0.00 18.00 36.00
10-530-512020 Copies 50.00 0.00 0.00 50.00 100.00
10-530-513010 Office Supplies 300.00 172.76 0.00 127.24 42.41
10-530-517010 Operational Supplies 300.00 10.50 0.00 289.50 96.50
E10 Materials & Supplies 1,100.00 256.10 0.00 843.90 76.72
10-530-520030 Dues And Publications 360.50 0.00 0.00 360.50 100.00
10-530-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-530-520070 Training And Education 1,800.00 1,054.80 0.00 745.20 41.40
10-530-522020 Professional Services 2,500.00 420.00 0.00 2,080.00 83.20
10-530-528085 Fair Housing Assistance Prog 1,250.00 0.00 0.00 1,250.00 100.00
E15 Contractual Services 5,910.50 1,474.80 0.00 4,435.70 75.05
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 289.50 168.54 17.28 103.68 35.81
E25 Repairs & Maintenance 289.50 168.54 17.28 103.68 35.81
10-530-550020 Neighborhood Reinvestment 45,000.00 22,735.76 0.00 22,264.24 49.48
10-530-550030 Old Town Projects 45,500.00 29,359.68 0.00 16,140.32 35.47
10-530-550031 Historic Preservation Grant 1,734.00 650.80 0.00 1,083.20 62.47
10-530-550035 Old Town Redev Committee 0.00 -15.00 0.00 15.00 0.00
10-530-550037 Historic Preservation Comm 1,000.00 171.00 0.00 829.00 82.90
10-530-550050 Neighb Stablization Prog 105,516.24 27.00 0.00 105,489.24 99.97
10-530-550060 MSP 1,105,349.09 756,314.27 281,625.19 67,409.63 6.10
10-530-550090 Hazard Mitigation 217,664.81 217,664.81 0.00 0.00 0.00
E30 Other Operating Expenses 1,521,764.14 1,026,908.32 281,625.19 213,230.63 14.01
530 Plan & Protect Svc-RedevGrant 1,610,755.12 1,084,846.21 281,642.47 244,266.44 15.16
531 Plan & Protect Svcs-Build Reg
10-531-501020 Salaries 363,817.21 249,877.40 0.00 113,939.81 31.32
10-531-501060 Seasonal Salaries 18,710.58 3,839.00 0.00 14,871.58 79.48
10-531-501090 Overtime 2,849.42 2,849.42 0.00 0.00 0.00
10-531-501095 Overtime Straight Pay 630.00 191.76 0.00 438.24 69.56
10-531-502010 Social Security 29,529.55 18,737.91 0.00 10,791.64 36.55
10-531-502020 Group Health Insurance 54,594.03 32,984.85 0.00 21,609.18 39.58
GL - Trial Balance by Acct Type and Full Acct Number (08/05/2014 - 8:49 AM)Page 27
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-531-502030 Retirement 68,404.76 35,520.78 0.00 32,883.98 48.07
10-531-502040 Workers Compensation 6,952.84 6,952.84 0.00 0.00 0.00
10-531-502050 Life Insurance 580.83 368.47 0.00 212.36 36.56
10-531-502060 Long Term Disability 972.93 619.05 0.00 353.88 36.37
10-531-502070 Employee Assistance Prgm 157.11 117.49 0.00 39.62 25.22
E05 Personnel Services 547,199.26 352,058.97 0.00 195,140.29 35.66
10-531-511010 Advertising 250.75 246.35 0.00 4.40 1.75
10-531-511020 Postage 2,000.00 1,971.88 0.00 28.12 1.41
10-531-512010 Printing 700.00 632.52 0.00 67.48 9.64
10-531-512020 Copies 10.00 0.00 0.00 10.00 100.00
10-531-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00
10-531-513010 Office Supplies 1,729.25 491.35 0.00 1,237.90 71.59
10-531-514030 Small Tools 300.00 129.58 0.00 170.42 56.81
10-531-515040 First Aid Supplies 30.00 0.00 0.00 30.00 100.00
10-531-517010 Operational Supplies 2,695.00 2,325.81 0.00 369.19 13.70
E10 Materials & Supplies 7,715.00 5,797.49 0.00 1,917.51 24.85
10-531-520030 Dues And Publications 1,500.00 886.99 0.00 613.01 40.87
10-531-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-531-520070 Training And Education 2,500.00 874.00 0.00 1,626.00 65.04
10-531-522020 Professional Services 0.00 0.00 0.00 0.00 0.00
10-531-522021 Abatement 15,000.00 12,587.62 0.00 2,412.38 16.08
10-531-522022 Demo 20,000.00 0.00 0.00 20,000.00 100.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 39,000.00 14,348.61 0.00 24,651.39 63.21
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 545.00 545.00 0.00 0.00 0.00
10-531-546010 Clothing Expense 820.00 808.50 0.00 11.50 1.40
10-531-547010 Equipment Maintenance 60.00 0.00 0.00 60.00 100.00
10-531-547020 Maintenance Agreements 1,500.00 877.92 240.64 381.44 25.43
10-531-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00
E25 Repairs & Maintenance 2,925.00 2,231.42 240.64 452.94 15.49
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 596,839.26 374,436.49 240.64 222,162.13 37.22
532 Plan & Protect Svcs-Env Health
10-532-501020 Salaries 130,608.56 89,196.92 0.00 41,411.64 31.71
10-532-501060 Seasonal Salaries 3,957.00 383.00 0.00 3,574.00 90.32
10-532-501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00
10-532-501090 Overtime 220.00 0.00 0.00 220.00 100.00
GL - Trial Balance by Acct Type and Full Acct Number (08/05/2014 - 8:49 AM)Page 28
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-532-501095 Overtime Straight Pay 60.00 0.00 0.00 60.00 100.00
10-532-502010 Social Security 10,315.69 6,582.08 0.00 3,733.61 36.19
10-532-502020 Group Health Insurance 21,485.14 13,255.12 0.00 8,230.02 38.31
10-532-502030 Retirement 25,785.05 16,144.58 0.00 9,640.47 37.39
10-532-502040 Workers Compensation 1,884.50 1,884.50 0.00 0.00 0.00
10-532-502050 Life Insurance 220.08 144.95 0.00 75.13 34.14
10-532-502060 Long Term Disability 363.60 240.02 0.00 123.58 33.99
10-532-502070 Employee Assistance Prgm 55.50 41.80 0.00 13.70 24.68
10-532-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 194,955.12 127,872.97 0.00 67,082.15 34.41
10-532-511010 Advertising 145.00 0.00 0.00 145.00 100.00
10-532-511020 Postage 200.00 91.16 0.00 108.84 54.42
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,000.00 438.41 0.00 561.59 56.16
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 30.00 0.00 0.00 30.00 100.00
10-532-517010 Operational Supplies 1,200.00 899.02 0.00 300.98 25.08
E10 Materials & Supplies 2,695.00 1,428.59 0.00 1,266.41 46.99
10-532-520030 Dues And Publications 880.00 345.00 0.00 535.00 60.80
10-532-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-532-520070 Training And Education 800.00 678.00 0.00 122.00 15.25
10-532-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00
10-532-522020 Professional Services 1,155.00 157.50 997.50 0.00 0.00
10-532-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00
10-532-524020 Recycle Collectprocess 1,000.00 -517.38 0.00 1,517.38 151.74
10-532-524025 Glass Recycling 10,000.00 3,740.00 1,870.00 4,390.00 43.90
10-532-524026 Household Hazardous Waste 20,000.00 13,789.29 -12,659.35 18,870.06 94.35
10-532-524027 INACTIVE - Portable Recycling 0.00 0.00 0.00 0.00 0.00
10-532-524028 Misc Recycling 7,000.00 1,567.50 0.00 5,432.50 77.61
10-532-524030 Compost Services 212,000.00 159,000.03 53,000.01 -0.04 0.00
10-532-529010 Special Events 0.00 0.00 0.00 0.00 0.00
10-532-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00
E15 Contractual Services 252,835.00 178,759.94 43,208.16 30,866.90 12.21
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 25,000.00 16,197.72 8,020.00 782.28 3.13
10-532-540065 Cemetery Restoration 5,000.00 0.00 4,960.00 40.00 0.80
10-532-541030 Vehicle Wash 1,290.00 1,284.00 0.00 6.00 0.47
10-532-546010 Clothing Expense 300.00 265.96 0.00 34.04 11.35
10-532-547010 Equipment Maintenance 80.00 0.00 0.00 80.00 100.00
10-532-547020 Maintenance Agreements 1,200.00 777.49 216.64 205.87 17.16
10-532-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00
GL - Trial Balance by Acct Type and Full Acct Number (08/05/2014 - 8:49 AM)Page 29
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
E25 Repairs & Maintenance 32,870.00 18,525.17 13,196.64 1,148.19 3.49
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 483,355.12 326,586.67 56,404.80 100,363.65 20.76
535 Public Works-Central Maintenan
10-535-501020 Salaries 331,324.54 234,175.03 0.00 97,149.51 29.32
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 2,185.50 0.00 5,214.50 70.47
10-535-501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00
10-535-501090 Overtime 9,500.00 9,837.57 0.00 -337.57 -3.55
10-535-501095 Overtime Straight Pay 500.00 290.67 0.00 209.33 41.87
10-535-502010 Social Security 26,294.93 17,445.51 0.00 8,849.42 33.65
10-535-502020 Group Health Insurance 83,283.30 55,307.18 0.00 27,976.12 33.59
10-535-502030 Retirement 66,255.94 44,218.84 0.00 22,037.10 33.26
10-535-502040 Workers Compensation 4,715.54 4,715.54 0.00 0.00 0.00
10-535-502050 Life Insurance 561.12 387.48 0.00 173.64 30.95
10-535-502060 Long Term Disability 926.64 639.84 0.00 286.80 30.95
10-535-502070 Employee Assistance Prgm 177.60 133.80 0.00 43.80 24.66
10-535-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 530,939.61 369,336.96 0.00 161,602.65 30.44
10-535-511010 Advertising 80.00 25.95 0.00 54.05 67.56
10-535-511020 Postage 50.00 0.94 0.00 49.06 98.12
10-535-512020 Copies 10.00 0.00 0.00 10.00 100.00
10-535-513010 Office Supplies 1,000.00 412.17 0.00 587.83 58.78
10-535-514011 Gas, Oil, & Antifreeze 0.00 0.00 0.00 0.00 0.00
10-535-514030 Small Tools 7,000.00 3,811.40 0.00 3,188.60 45.55
10-535-517010 Operational Supplies 8,000.00 4,573.81 0.00 3,426.19 42.83
E10 Materials & Supplies 16,140.00 8,824.27 0.00 7,315.73 45.33
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 199.00 0.00 1,801.00 90.05
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,000.00 199.00 0.00 1,801.00 90.05
10-535-531010 Electricity 5,007.94 4,091.90 0.00 916.04 18.29
10-535-533010 Natural Gas 8,042.06 7,962.27 0.00 79.79 0.99
10-535-534010 Telephone 0.00 0.00 0.00 0.00 0.00
10-535-535010 WaterSewer 1,215.00 914.84 0.00 300.16 24.70
E20 Utilities 14,265.00 12,969.01 0.00 1,295.99 9.09
10-535-540010 Building & Grounds Maint.9,500.00 7,525.58 50.00 1,924.42 20.26
10-535-541010 Veh & Equip Parts Etc 419,500.00 297,919.54 0.00 121,580.46 28.98
GL - Trial Balance by Acct Type and Full Acct Number (08/05/2014 - 8:49 AM)Page 30
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-535-546010 Clothing Expense 7,000.00 4,278.03 -2,788.33 5,510.30 78.72
10-535-547010 Equipment Maintenance 3,500.00 684.79 0.00 2,815.21 80.43
10-535-547020 Maintenance Agreements 4,000.00 2,157.99 52.80 1,789.21 44.73
10-535-547030 Radio Maintenance 500.00 0.00 0.00 500.00 100.00
E25 Repairs & Maintenance 444,000.00 312,565.93 -2,685.53 134,119.60 30.21
10-535-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
535 Public Works-Central Maintenan 1,007,344.61 703,895.17 -2,685.53 306,134.97 30.39
540 Public Works-Admin
10-540-501020 Salaries 188,433.84 137,575.49 0.00 50,858.35 26.99
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 14,415.19 9,666.89 0.00 4,748.30 32.94
10-540-502020 Group Health Insurance 30,833.98 20,429.37 0.00 10,404.61 33.74
10-540-502030 Retirement 37,121.47 24,901.15 0.00 12,220.32 32.92
10-540-502040 Workers Compensation 567.94 567.94 0.00 0.00 0.00
10-540-502050 Life Insurance 309.12 218.71 0.00 90.41 29.25
10-540-502060 Long Term Disability 462.24 319.71 0.00 142.53 30.83
10-540-502070 Employee Assistance Prgm 66.60 50.17 0.00 16.43 24.67
E05 Personnel Services 272,210.38 193,729.43 0.00 78,480.95 28.83
10-540-511010 Advertising 0.00 0.00 0.00 0.00 0.00
10-540-511020 Postage 200.00 60.70 0.00 139.30 69.65
10-540-512010 Printing 200.00 33.00 0.00 167.00 83.50
10-540-512020 Copies 100.00 0.11 0.00 99.89 99.89
10-540-513010 Office Supplies 700.00 112.00 0.00 588.00 84.00
10-540-514010 Gas 128,500.00 94,865.25 0.00 33,634.75 26.17
10-540-514040 Food 1,000.00 697.68 0.00 302.32 30.23
10-540-517010 Operational Supplies 700.91 57.46 0.00 643.45 91.80
E10 Materials & Supplies 131,400.91 95,826.20 0.00 35,574.71 27.07
10-540-520030 Dues And Publications 1,000.00 600.20 0.00 399.80 39.98
10-540-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-540-520070 Training And Education 1,968.32 836.52 0.00 1,131.80 57.50
10-540-522020 Professional Services 800.00 0.00 0.00 800.00 100.00
10-540-527010 Comm Serv Projects 0.00 0.00 0.00 0.00 0.00
E15 Contractual Services 3,768.32 1,436.72 0.00 2,331.60 61.87
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 960.77 744.13 216.64 0.00 0.00
E25 Repairs & Maintenance 960.77 744.13 216.64 0.00 0.00
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
GL - Trial Balance by Acct Type and Full Acct Number (08/05/2014 - 8:49 AM)Page 31
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
540 Public Works-Admin 408,340.38 291,736.48 216.64 116,387.26 28.50
541 Public Works-Engineering
10-541-501020 Salaries 662,630.75 474,682.81 0.00 187,947.94 28.36
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 200.00 764.37 0.00 -564.37 -282.19
10-541-501095 Overtime Straight Pay 200.00 287.90 0.00 -87.90 -43.95
10-541-502010 Social Security 50,721.85 34,540.05 0.00 16,181.80 31.90
10-541-502020 Group Health Insurance 96,562.21 62,563.08 0.00 33,999.13 35.21
10-541-502030 Retirement 130,617.06 84,034.11 0.00 46,582.95 35.66
10-541-502040 Workers Compensation 1,204.70 1,204.70 0.00 0.00 0.00
10-541-502050 Life Insurance 1,100.40 766.84 0.00 333.56 30.31
10-541-502060 Long Term Disability 1,816.32 1,266.59 0.00 549.73 30.27
10-541-502070 Employee Assistance Prgm 244.20 183.96 0.00 60.24 24.67
10-541-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00
E05 Personnel Services 945,297.49 660,294.41 0.00 285,003.08 30.15
10-541-511010 Advertising 800.00 792.75 0.00 7.25 0.91
10-541-511020 Postage 800.00 147.56 0.00 652.44 81.56
10-541-512010 Printing 100.00 402.26 0.00 -302.26 -302.26
10-541-512020 Copies 75.00 0.00 0.00 75.00 100.00
10-541-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00
10-541-513010 Office Supplies 6,500.00 2,746.29 0.00 3,753.71 57.75
10-541-514030 Small Tools 200.00 0.00 0.00 200.00 100.00
10-541-514040 Food 150.00 86.13 0.00 63.87 42.58
10-541-515040 First Aid Supplies 50.00 0.00 0.00 50.00 100.00
10-541-515070 Const & Inspect Supplies 2,000.00 283.76 0.00 1,716.24 85.81
10-541-515080 Surveying Supplies 2,000.00 525.85 0.00 1,474.15 73.71
10-541-517010 Operational Supplies 1,150.00 983.82 0.00 166.18 14.45
E10 Materials & Supplies 13,825.00 5,968.42 0.00 7,856.58 56.83
10-541-520030 Dues And Publications 4,000.00 1,943.80 0.00 2,056.20 51.41
10-541-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-541-520070 Training And Education 4,500.00 1,975.24 0.00 2,524.76 56.11
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,800.00 301.00 0.00 3,499.00 92.08
10-541-522055 Stormwater Compliance 1,500.00 1,111.03 0.00 388.97 25.93
E15 Contractual Services 13,800.00 5,331.07 0.00 8,468.93 61.37
10-541-534010 Telephone 1,000.00 299.92 0.00 700.08 70.01
E20 Utilities 1,000.00 299.92 0.00 700.08 70.01
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
GL - Trial Balance by Acct Type and Full Acct Number (08/05/2014 - 8:49 AM)Page 32
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-541-546010 Clothing Expense 1,000.00 325.54 0.00 674.46 67.45
10-541-547010 Equipment Maintenance 1,500.00 843.12 0.00 656.88 43.79
10-541-547020 Maintenance Agreements 13,000.00 9,370.42 258.88 3,370.70 25.93
10-541-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00
E25 Repairs & Maintenance 16,500.00 11,499.08 258.88 4,742.04 28.74
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 990,422.49 683,392.90 258.88 306,770.71 30.97
542 Public Works-Street
10-542-501020 Salaries 1,010,882.92 723,269.30 0.00 287,613.62 28.45
10-542-501060 Seasonal Salaries 20,543.42 16,026.14 0.00 4,517.28 21.99
10-542-501070 Stand-by Plan 4,081.31 3,076.00 0.00 1,005.31 24.63
10-542-501090 Overtime 65,000.00 59,545.71 0.00 5,454.29 8.39
10-542-501095 Overtime Straight Pay 2,000.00 228.82 0.00 1,771.18 88.56
10-542-502010 Social Security 80,893.69 58,026.90 0.00 22,866.79 28.27
10-542-502020 Group Health Insurance 167,122.47 107,505.76 0.00 59,616.71 35.67
10-542-502030 Retirement 204,267.42 135,736.38 0.00 68,531.04 33.55
10-542-502040 Workers Compensation 26,942.26 26,942.26 0.00 0.00 0.00
10-542-502050 Life Insurance 1,700.04 1,181.56 0.00 518.48 30.50
10-542-502060 Long Term Disability 2,785.20 1,933.93 0.00 851.27 30.56
10-542-502070 Employee Assistance Prgm 521.70 393.02 0.00 128.68 24.67
10-542-503010 Awards Program 200.00 0.00 0.00 200.00 100.00
10-542-503020 Unemployment Compensation 250.00 0.00 0.00 250.00 100.00
E05 Personnel Services 1,587,190.43 1,133,865.78 0.00 453,324.65 28.56
10-542-511010 Advertising 300.00 306.83 0.00 -6.83 -2.28
10-542-511020 Postage 150.00 79.41 0.00 70.59 47.06
10-542-512010 Printing 59.31 0.00 0.00 59.31 100.00
10-542-512020 Copies 50.69 42.83 0.00 7.86 15.51
10-542-513010 Office Supplies 1,323.68 618.06 0.00 705.62 53.31
10-542-514020 Chemicals 450,000.00 272,682.26 -301,684.51 479,002.25 106.44
10-542-514030 Small Tools 8,696.48 5,252.58 0.00 3,443.90 39.60
10-542-514040 Food 1,037.84 1,037.84 0.00 0.00 0.00
10-542-515010 Stormwater Material 0.00 0.00 0.00 0.00 0.00
10-542-515020 Street Materials 274,750.00 134,364.91 -1,578.85 141,963.94 51.67
10-542-515040 First Aid Supplies 500.00 315.50 0.00 184.50 36.90
10-542-515060 Weed Control 1,500.00 1,461.50 0.00 38.50 2.57
10-542-515070 Const & Inspect Supplies 200.00 0.00 0.00 200.00 100.00
10-542-517010 Operational Supplies 5,000.00 3,701.92 0.00 1,298.08 25.96
E10 Materials & Supplies 743,568.00 419,863.64 -303,263.36 626,967.72 84.32
10-542-520030 Dues And Publications 584.00 527.00 0.00 57.00 9.76
GL - Trial Balance by Acct Type and Full Acct Number (08/05/2014 - 8:49 AM)Page 33
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
10-542-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00
10-542-520070 Training And Education 2,068.00 437.39 0.00 1,630.61 78.85
10-542-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00
10-542-522020 Professional Services 15,000.00 12,790.00 1,100.00 1,110.00 7.40
10-542-523010 Equipment Rentlease 200.00 60.00 0.00 140.00 70.00
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 17,852.00 13,814.39 1,100.00 2,937.61 16.46
10-542-531010 Electricity 25,000.00 19,033.41 0.00 5,966.59 23.87
10-542-531020 Street Lights 527,900.00 463,166.17 0.00 64,733.83 12.26
10-542-533010 Natural Gas 17,000.00 13,749.84 0.00 3,250.16 19.12
10-542-534010 Telephone 500.00 357.75 0.00 142.25 28.45
10-542-535010 WaterSewer 6,000.00 4,418.42 0.00 1,581.58 26.36
E20 Utilities 576,400.00 500,725.59 0.00 75,674.41 13.13
10-542-540010 Building & Grounds Maint.7,000.00 2,652.20 75.00 4,272.80 61.04
10-542-541030 Vehicle Wash 6,840.00 6,840.00 0.00 0.00 0.00
10-542-542010 Repairs - Stop Lights 10,000.00 6,665.16 0.00 3,334.84 33.35
10-542-542030 Signs & Marking Paint 35,000.00 28,020.51 0.00 6,979.49 19.94
10-542-546010 Clothing Expense 10,000.00 5,239.69 0.00 4,760.31 47.60
10-542-547010 Equipment Maintenance 2,806.24 2,173.86 0.00 632.38 22.53
10-542-547020 Maintenance Agreements 500.00 315.36 18.00 166.64 33.33
10-542-547030 Radio Maintenance 273.76 624.53 0.00 -350.77 -128.13
E25 Repairs & Maintenance 72,420.00 52,531.31 93.00 19,795.69 27.33
10-542-572010 Purchase Of Vehicles 0.00 0.00 0.00 0.00 0.00
10-542-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00
10-542-573030 Purchimprov Landbuildin 0.00 0.00 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 0.00 0.00 0.00 0.00 0.00
542 Public Works-Street 2,997,430.43 2,120,800.71 -302,070.36 1,178,700.08 39.32
700 Transfers & Subsidies
10-700-590050 Transfer To Tif Fund 4,000.00 1,515.57 0.00 2,484.43 62.11
10-700-590070 Airport Subsidy 170,789.16 170,789.16 0.00 0.00 0.00
10-700-590075 Transit Subsidy 363,990.70 363,990.70 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 538,779.86 536,295.43 0.00 2,484.43 0.46
700 Transfers & Subsidies 538,779.86 536,295.43 0.00 2,484.43 0.46
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
GL - Trial Balance by Acct Type and Full Acct Number (08/05/2014 - 8:49 AM)Page 34
Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable
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 Rescue 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-577042 Mo Blvd Sidewalks 75,447.33 81,464.83 -10,700.55 4,683.05 6.21
10-990-577044 Water Street @ Lohman Landing 465,460.00 0.00 311,760.19 153,699.81 33.02
10-990-577045 Clay Street Plaza 72,800.00 0.00 0.00 72,800.00 100.00
10-990-577046 Hwy 54 & Stadium Interchange 787,707.00 28,591.91 57,528.44 701,586.65 89.07
E75 Capital Projects 1,401,414.33 110,056.74 358,588.08 932,769.51 66.56
990 Capital Projects 1,401,414.33 110,056.74 358,588.08 932,769.51 66.56
Expense Expense 32,992,659.92 21,927,979.57 762,659.14 10,302,021.21 31.23
GL - Trial Balance by Acct Type and Full Acct Number (08/05/2014 - 8:49 AM)Page 35
FUND BALANCE CALCULATION
FYE 13 Unassigned General Fund Balance 4,944,983.00$ Per Tentative Audited CAFR
Supplemental Appropriation (50,000.00)$ Bill 2013-105 Ordinance 15204 - ALPLA Settlement
Supplemental Appropriation (100,000.00)$ Bill 2013-133 Ordinance 15231 - Replenish Funds Used for Street Chemicals
Supplemental Appropriation (200,000.00)$ Bill 2014-17 Ordinance 15272 - Replenish Funds Used for Street Chemicals
Supplemental Appropriation (14,220.16)$ Bill 2014-39 Ordinance 15294 - Execute Defense Sharing Agreement with Cole County
Supplemental Appropriation (25,000.00)$ Bill 2014-49 Ordinance 15297 - Replenish Funds Used for Street Chemicals
Estimated FY14 Fund Balance 4,555,762.84$
Unreserved Fund Balance Percentage 15.88%Based on original budget of $28,688,000
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
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
Tax Period
Due Date to
City Total Lodging Tax JCCVB (3/7)
JCCVB/Tourism Fund
(4/7)
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
Total 3,425,932.00 1,438,891.44 1,912,959.86
average monthly amount for 4 cent lockbox fund 50,487.42$
2014 Occupancy 2013 Occupancy 2012 Occupancy
January 49.20%45.30%38.20%
February 56.00%52.90%49.80%
March 59.30%52.90%54.90%
April 63.70%64.10%53.90%
May 64.70%56.80%53.70%
June 63.70%55.70%53.10%
July 58.50%51.40%
August 55.80%47.00%
September 63.00%59.30%
October 65.90%59.30%
November 52.40%43.40%
December 38.80%33.00%
COMPARATIVE OCCUPANCY RATE
Tab 2 - Multi-Segment Currency: USD - US Dollar
Missouri Hotel & Lodging Association
For the month of: June 2014
Percent Change from June 2013 Percent Change from YTD 2013
2014 2013 2014 2013 2014 2013 Occ ADR RevPAR
Room
Rev
Room
Avail
Room
Sold 2014 2013 2014 2013 2014 2013 Occ ADR RevPAR
Room
Rev
Room
Avail
Room
Sold Census Sample Census Sample
United States 71.7 69.7 116.20 111.46 83.27 77.65 2.9 4.3 7.2 8.2 0.9 3.7 63.7 61.7 114.06 109.53 72.64 67.55 3.3 4.1 7.5 8.4 0.8 4.1 53143 30653 4955499 3555273
West North Central 72.6 69.6 95.06 91.25 69.01 63.51 4.3 4.2 8.7 10.0 1.2 5.6 57.2 55.2 88.33 85.21 50.56 47.02 3.7 3.7 7.5 8.8 1.2 4.9 4456 2542 344753 244838
Missouri 70.5 67.2 94.08 89.24 66.35 59.93 5.0 5.4 10.7 10.7 0.0 5.0 56.2 53.2 88.37 84.46 49.69 44.93 5.7 4.6 10.6 10.1 -0.4 5.2 1127 625 102406 71555
Kansas City, MO-KS 80.5 72.3 96.91 90.61 78.00 65.47 11.4 7.0 19.1 18.3 -0.7 10.6 61.4 56.8 89.59 86.66 55.02 49.22 8.1 3.4 11.8 11.7 -0.1 8.0 290 220 32010 26743
St Louis, MO-IL 75.1 76.8 99.26 93.66 74.55 71.91 -2.2 6.0 3.7 4.3 0.6 -1.6 63.3 60.5 94.63 89.45 59.92 54.10 4.7 5.8 10.8 10.0 -0.7 4.0 326 231 37760 30719
Columbia, MO+66.4 67.1 81.03 73.73 53.77 49.48 -1.1 9.9 8.7 15.5 6.3 5.1 57.4 58.1 81.25 74.94 46.65 43.53 -1.1 8.4 7.2 9.9 2.6 1.4 38 29 3886 3253
Jefferson City, MO+63.7 55.7 73.23 65.15 46.63 36.29 14.4 12.4 28.5 28.5 0.0 14.4 59.4 54.6 74.94 68.34 44.54 37.33 8.8 9.7 19.3 21.2 1.6 10.5 15 11 1494 1063
Springfield, MO 66.0 64.9 77.70 74.75 51.28 48.50 1.7 3.9 5.7 2.3 -3.2 -1.6 55.4 52.1 75.58 72.89 41.87 37.98 6.3 3.7 10.2 6.7 -3.3 2.9 66 44 5996 4312
Branson, MO 58.9 48.5 101.51 98.09 59.75 47.62 21.2 3.5 25.5 21.3 -3.3 17.2 37.8 33.4 89.82 86.01 33.92 28.71 13.2 4.4 18.2 15.3 -2.4 10.4 155 38 14156 5283
Lake of the Ozarks+62.9 59.5 105.88 104.00 66.57 61.85 5.7 1.8 7.6 7.7 0.1 5.8 42.5 42.5 93.42 91.63 39.74 38.94 0.1 2.0 2.1 2.6 0.5 0.6 38 10 2807 1433
Joplin, MO 69.3 62.1 72.06 69.31 49.93 43.03 11.6 4.0 16.1 16.1 0.0 11.6 56.4 51.7 68.88 67.91 38.87 35.12 9.1 1.4 10.7 10.7 0.0 9.1 34 23 2713 2225
A blank row indicates insufficient data.Source 2014 STR, Inc.
RevPAR PropertiesADR
Participation
Occ %
Current Month - June 2014 vs June 2013
DISCLOSURE Destination Reports are publications of STR, Inc. (Reports containing only North American data) and STR Global Ltd (Reports containing worldwide data) and are intended solely for use by our paid subscribers. Reproduction or distribution of Destination Reports, in whole or part,
without written permission of either STR, Inc. or STR Global Ltd. is prohibited and subject to legal action. Site licenses are available. Please consult your contract with STR, Inc. or STR Global, Ltd for the terms and conditions governing the ownership, distribution and use of Destination Reports
and their contents.
RevPARADROcc %
Year to Date - June 2014 vs June 2013
Rooms
BILL NO. [Bill No.]
SPONSORED BY COUNCILMAN _______________________
ORDINANCE NO.
AN ORDINANCE OF THE CITY OF JEFFERSON, MISSOURI, PERTAINING TO THE
PURCHASING AUTHORITY OF THE CITY ADMINISTRATOR
BE IT ENACTED BY THE COUNCIL OF THE CITY OF JEFFERSON, MISSOURI, AS
FOLLOWS:
Section 1. Chapter 26A (Purchasing and Finance) Section 20 (City
administrator power to execute contracts ) is amended as follows:
Sec. 26A-20. City administrator power to execute contracts.
A. The city administrator is hereby authorized to sign contracts on behalf of the city, provided the
following criteria are met:
1. The contract has a cumulative total value of less than twenty five thousand dollars
($25,000.00) per year, unless specifically authorized by the City Council; or
2. The contract has a combined total value of no greater than fifty thousand ($50,000.00) per
year, the city administrator may place the same on the consent agenda for approval by
the Council in one meeting. The contract the City Administrator proposes to sign along
with a memorandum giving a brief explanation of the contract shall be sufficient. Such
contract shall be removed from the consent agenda shall be considered rejected if
any two councilpersons vote to remove reject the same and it shall thereafter be voted
separately from the remaining consent agenda items.
B. The city administrator shall not have the power to sign any contract pertaining to the purchase or sale
of real estate, unless specifically authorized by the City Council, except that such prohibition shall not
apply to:
1. Leases which are no more than twenty five thousand dollars ($25,000) in total value including
all renewals; or
2. The accepting or granting of easements across city property.
Section 2. This Ordinance shall be in full force and effect from and after the
date of its passage and approval.
Passed: Approved:
Presiding Officer Mayor
ATTEST: APPROVED AS TO FORM:
City Clerk City Counselor
FINANCE DEPARTMENT
PURCHASING DIVISION
SUBJECT: Proposal 2733-Employee Assistance Program
Human Resources, Opened May 15, 2014
RECOMMENDATION:
Staff recommends award of the proposal to the lowest and best offer, Personal Assistance
Services of St. Louis, Missouri for the six session option. Based on an estimate of 400
employees at $1.80 each on a monthly basis, the estimated annual cost will be $8,640.00. The
total five year cost, if all renewals are exercised, is estimated to be $43,200.00.
RESPONSES RECEIVED: Six Visit Option Year 1 Year2 Year3 Year 4 Year 5
Alternatives, Kansas City, MO
Personal Assistance Serv., St. Louis, MO
Ceridian, Minneapolis, MO
Capital Region, Jefferson City, MO
Humana, New York, NY
8,400.00 8,400.00 8,928.00 8,928.00 9,456.00
8,640.00 8,640.00 8,640.00 8,640.00 8,640.00
8,928.00 8,928.00 8,928.00 8,928.00 8,928.00
8,928.00 9,216.00 9,504.00 9,792.00 10,080.00
13,440.00 13,440.00 13,440.00 13,440.00 13,440.00
The request was advertised in News Tribune, posted on the city web site, and sent to twenty-three
additional vendors who did not respond.
FISCAL NOTE:
Funds will be requested in the FY 2015 budget to accommodate the costs for year one. The
expenses are charged to each department as an employee benefit.
PAST PERFORMANCE:
The City has not awarded contracts to this vendor in the past; however staff believes the firm will
complete the services as specified.
ATTACHMENTS-SUPPORTING DOCUMENTATION
l -C)c ~->=-->.~ ,~S\~ ~~
Human Resources Director
INTER-OFFICE
TO: Mayor Eric Struemph
Members of the City Council
FROM: Gail Strope ~
Director of Human Resources
DATE: July 30, 2014
MEMO
SUBJECT: Contract with Personal Assistance Services for Employee Assistance
Program services.
The City has offered a professional Employee Assistance Program for employees since
August of 1994. The City recently distributed a request for proposal for Employee
Assistance Program services and received five proposals. A committee consisting of
myself and Sarah Trittler from Human Resources, Cindy Lambert and Drew Hilpert from
Law department, Bill Betts from Information Technology, Clara Haenchen from
Wastewater, and Tina Werner from Parks & Recreation reviewed the proposals and
recommends Personal Assistance Services (PAS) as the lowest and best proposal.
PAS is located in St. Louis and is knowledgeable about the central Missouri area. They
have excellent resources for our employees, are available 24 hours a day, and received
excellent feedback from their references. The contract provides for employees and their
family members to receive up to six visits with a licensed counselor per event per year. In
addition, PAS provides numerous life management services such as assistance with
childcare, caregiver planning, elder care, identity theft assistance, financial coaching,
education financing, etc.
The contract will include one year of service beginning January 1, 2015 with four one-year
renewable extensions with no price increase. Total cost per year is $8,640. Staff is
requesting the Council authorize a contract with Personal Assistance Services for
professional Employee Assistance Program services.
Please feel free to contact me if you have any questions or comments.
CITY OF JEFFERSON
EMPLOYEE ASSISTANCE PROGRAM AGREEMENT
THIS AGREEMENT, made this __ day of August, 2014, by and between Personal Assistance Services,
a nonprofit corporation located at 9735 Landmark Parkway, Suit 17, St. Louis, Missouri, hereinafter
designated "Provider," and the City of Jefferson, Missouri, a municipal corporation, hereinafter designated
"City," located at 320 East McCarty Street, Jefferson City, Missouri, 65101.
WHEREAS, Provider, provides assistance to business, governmental, and educational organizations with
the design, implementation, and maintenance of EAP for the employees of such businesses, governmental,
and educational organizations; and
WHEREAS, the City desires that such a program should be available to its employees.
NOW THEREFORE, for and in consideration of the mutual promises contained herein, it is understood
and agreed as follows:
1. Responsibilities of Provider.
A. Assist in the introduction of the Personal Assistance Services: Employee Assistance Program
for the City and its management and appropriate staff.
B. Assist the City in the development, review and modification of procedures relating to the
operation of Personal Assistance Services: EAP.
C. Hold up to six (6) training sessions per year for all appropriate levels of City management,
supervisory personnel, and employees.
D. Provide timely assistance to City's employees and their immediate family members whose
primary residence is with the employee or are dependents of the employee for federal income
tax purposes, through individual interviews and/or counseling sessions. For purposes of this
agreement, immediate family members are defined as husband, wife, son, son-in-law,
daughter, daughter-in-law, mother, mother-in-law, father, father-in-law, brother, brother-in-
law, sister, sister-in-law, grandparents, and grandchildren. Such sessions will be in response
to supervisor, management, or self-referrals and will be held at Personal Assistance Services
as mutually agreed upon by the client involved in such session. The number of counseling
sessions available to each employee and/or family member are set for on Attachment A
attached hereto. Referrals for financial counseling or legal or medical services for employees
or family members are offered on an as needed basis throughout the agreement year.
E. Provide on-site assistance to the City's employees for critical incident debriefing.
F. Where the Personal Assistance Services: EAP staff deems necessary referrals will be made
for City's employees and their family members to other agencies and individuals for assistance.
In making such referrals to other agencies, due regard will be given to the appropriateness of
the referrals in view of the need, location, cost and available resources. The Personal
Assistance Services: EAP staff will advise those employees or family members referred to other
sources for assistance, that the employee and/or family member individually, and not City, will
be responsible for payment of all costs and fees of any such agency for services rendered to
them.
G. Consult with individual supervisors or City regarding potential supervisory referrals.
H. Provide the City, on a quarterly and annual basis, a report of EAP activities. The annual
report shall include a statistical analysis of the number and types of referrals, including
self-referrals and supervisory referrals an groupings of employees or family members by age,
gender, length of employment, and problem categories; provided if in the opinion of Provider
any statistical category could compromise confidentiality of a user, then said category shall be
omitted from the report.
I. Designate a Personal Assistance Services: EAP representative to the City in the day-to-day
contact regarding the services covered by the Agreement.
J. Acknowledge that all of the above responsibilities and treatments rendered by it will be
conducted by duly qualified and, if required, licensed personnel, and that any and all referrals
made by it will be made to such duly qualified and licensed personnel.
K. Prepare and obtain a consent form to be signed by each participating employee and/or family
member prior to the release or receipt of any information concerning that employee and/or
family member except when: a medical emergency occurs; a court order or subpoena requires
disclosure; or a client presents a serious threat to the life or safety of himself/herself or others.
Personal Assistance Services and its agents and employees will be held harmless for any loss.
cost or damages allegedly sustained by an employee and/or family member because of release
of information under the circumstance listed above. A supervisor of the City and/or Personal
Assistance Services: EAP staff members will explain such form to each participating employee
L. Maintain and keep files on each City employee and/or family members that participates in the
Personal Assistance Services: EAP Program. Such files and records will become and shall
remain the property of Provider. Strict confidentiality and security shall be maintained. Only
Personal Assistance Services: EAP staff shall have access to such files with the exception of
the circumstances listed in l.(K).
M. Communicate and promote the benefits of EAP to employees, supervisory personnel, and
management through a combined effort of orientation sessions and written promotional
materials.
2. Responsibilities of the City.
A. Provide such meeting places and facilities as may be required for planning and evaluation
meetings, group orientation sessions, sessions with individual supervisor and employees, and
separate group educational in-service programs.
B. Assume responsibility for scheduling and notifying participants of such meetings.
C. Distribute internal and external publicity and communications provided by Personal
Assistance Services: EAP, subjection to the City's approval, to initiate and maintain the
Program. The City acknowledges that Provider recommendations as to the timing of such
publicity and communications.
D. Designate an employee of the City to be the coordinator of the Program and, as such, to
represent the City to Provider in the day-to-day activities and contacts regarding services
provided by Provider as described in this Agreement.
E. Compensate Provider in the amount specified in Attachment A. Covered employees shall
included regular full-time and regular part-time employees of the City whether or not such
-2-
employees will actually participate in the Personal Assistance Services: Employee Assistance
Program. The Determination of covered employees shall be made as of the initial agreement
date and redetermined at the end of each quarter, i.e., every three months. Billings shall be
made in advance on a quarterly basis and the amount due is payable upon receipt of billing.
3. Duration and Renewal of Contract.
A. This Contract shall be in effect from January 1, 2015, through December 31, 2015, with four
(4) additional one (1) year renewals. Notice of intent to renew must be provided by both parties
sixty (60) days prior to the expiration of the Contract.
B. The Contract shall not bind, nor purport to bind, the City for any contractual commitment in
excess of one (l) year, except that, as referenced in sub-paragraph A above, at the end of each
one (1) year period the parties may renew this Contract for an additional one (l) year period.
The total length of the Contract shall not exceed five (5) years. If the Contract is renewed, the
terms and conditions of this Contract shall remain the same, including, but not limited to, the
duties of Provider and the compensation to be paid by the City as set out in paragraph 2E of
this Contract.
4. Cancellation.
The City and/or the Provider may cancel the Agreement at any time for breach of contractual obligations by
providing a written notice of such cancellation to the other party. Should the City or the Provider exercise its
right to cancel the Contact for such reasons, the cancellation shall become effective on the date as specified in
the notice of cancellation sent to the other party.
5. Termination
The City and the Provider reserve~ the right to terminate the Agreement for the sake of convenience without penalty
of recourse by the other party, by giving to the other party a written notice of such termination at least sixty (60) days
prior to termination.
6. Personnel of Provider.
All personnel associated with Provider in connection with its Employee Assistance Program shall be deemed
employees, agents, servants or independent contractual of Provider and not employees of the City. Physicians
or other health professionals, personnel or agencies to whom the employees of the City may be referred for
independent consultation or treatment as a result of this program shall not be considered as employees, agents,
servants or independent contractual of Provider. Therefore, Provider shall assume all legal and financial
responsibility for taxes, FICA, employee fringe benefits, workers compensation, employee insurance, minimum
wage requirements, overtime, and other employment related cost, and agrees to indemnifY, save and hold the
City, its officers, agents and employees, harmless from and against, any and all loss, cost (including attorney
fees), injury, and damage of any kind related to such matters.
7. Modification of Agreement
Any change in this Agreement, whether by modification and/or by supplementation, must be accomplished by a formal
contractual amendment signed and approved by and between the duly authorized representatives of the Provider and
the City. Any such amendment shall specify an effective date, any increases or decreases in the amount of the
Provider's compensation, if applicable, and be entitled as an "Amendment," and signed by the parties identified in
the preceding sentence. Personal Assistance Services expressly and explicitly understands and agrees that no other
method and/or no other document, including correspondence, acts, or oral communications by or from any person,
shall be used or construed as an amendment to the Agreement.
8. Confidentiality
All material developed or acquired by Provider as a result of work under this Agreement shall remain the
property of the Provider except as otherwise provided in this contract. No material or reports prepared by
Provider shall be released to the public.
-3-
9. Assignments.
Provider shall not assign any interest in the Agreement and shall not transfer any interest, whatsoever, in the
Agreement without the prior written consent of the City.
10. Conflicts of Interest.
Provider covenants that it presently has no interest and shall not acquire any interest, directly or indirectly,
which would conflict in any manner or degree with the performance ofthe services hereunder. Provider further
covenants that no person having any such known interest shall be employed or conveyed an interest, directly
or indirectly, in the Agreement.
11. Applicable Law.
The Agreement shall be construed according to the laws of the State of Missouri. Provider shall comply with
all local, state and federal laws and regulations related to the performance of the Contact to the extent that the
same may be applicable, including the Fair Labor Standards Act, Fair Employment Practices, and the Equal
Opportunity Employment Act.
12. Entire Agreement.
The Agreement between the City and Provider shall consist of:
A. The Request for Proposal (RFP) and any amendments hereto;
B. The proposal submitted by Provider in response to the RFP; and
C. This Agreement. The documents mentioned in (a) and (b) are incorporated into this Agreement
by reference and are as fully a part of this Agreement as if set out in full herein. In the event
of a conflict in language between the three documents referenced above, the provisions and
requirements set forth in this Agreement shall govern.
13. Waivers.
No provision in this Agreement, the RFP, or Provider's proposal shall be construed as an express or implied
waiver by the City of Jefferson of any existing or future right and/or remedy available by law in the event of any
claim of default or breach of Agreement.
14. Liability for Injury.
Provider shall be responsible for any and all injury or damages caused by an act or omission of Provider as a
result of any service rendered under the terms and conditions of the Agreement. In addition to any liability
imposed upon Provider on the account of personal injury, bodily injury, including death, or property damage
suffered as a result of Provider's performance under the Agreement, Provider assumes the obligation to save
the City, including its agents, employees and officers, harmless and to indemnify the City including its agents,
employees and officers, from every expense, liability or under payment arising out of such act of omission under
the terms of this Agreement causing such liability. Provider also agrees to hold the City, including its agents,
employees and officers, harmless for any act or omission committed by any subcontract or other person
employed by or under the supervision of Provider under the terms of the Contact.
15. Illegal Immigration.
Prior to commencement of the work:
A. Provider shall, by sworn affidavit and provision of documentation, affirm its enrollment and
participation in a federal work authorization program with respect to the employees working
in connection with the contracted services.
B. Provider shall sign an affidavit affirming that it does not knowingly employ any person who
is an unauthorized alien in connection with the contracted services.
-4-
C. If Provider is a sole proprietorship, partnership, or limited partnership, contractor shall
provide proof of citizenship or lawful presence of the owner prior to issuance of the Notice to
Proceed.
16. Notices.
Any written notice to the City shall be deemed sufficient when deposited in the United States mail, postage
prepaid, and addressed to City of Jefferson, 320 East McCarty, Jefferson City, Missouri, 65101. Any written
notice to Provider shall be deemed sufficient when deposited in the United States mail, postage prepaid, and
addressed to Personal Assistance Services, 9735 Landmark Parkway, Suit 17, St. Louis, Missouri, 63127.
17. Indemnity.
Provider shall defend, protect and hold harmless the City, its officers, agencies and employees against all suits
of law or in equity and from all damages, claims or demands for equipment, supplies and services provided
Provider.
18. Paragraph Headings.
The headings of each paragraph contained herein are for convenience in reference only and are not intended
to define or limit the scope of any provision of this Agreement.
IN WITNESS WHEREOF, the parties have executed this Agreement the day and year first above written.
CITY OF JEFFERSON, MISSOURI PERSONAL ASSISTANCE SERVICES
City Administrator Title:
ATTEST: ATTEST:
City Clerk Title:
APPROVEI} ~S TO FORM:
~?11 '. ·'-. .... ~ /. ' {// L (//
-5 -
ATTACHMENT A
PERSONAL ASSISTANCE SERVICES
Employee Assistance Program Contract
1. The commencement date of this Agreement shall be January 1, 2015.
2. A total of six ( 6) 60-minute psychological counseling sessions per family unit per contractual year will
be offered. Family unit will consist of the employee and employee's immediate family.
3. The amount of compensation paid to Personal Assistance Services by the City of Jefferson will be
$21.60 per covered employee for year number one, $21.60 for year number two, $21.60 for year
number three, $21.60 for year number four and $21.60 for year number five. Payments are to be made
as described in Section 2e.
-6-
City of Jefferson, Missouri
Tabulation of Bids
Proposal 2733
Date: May 15, 2014
Subject: Employee Assistance Program Alternatives
Dept: Personnel Kansas City MO
PAGE 1
ITEM Year One Year Two Year Three Year Four Year 5
EAP Enrollment 400
4 visit EAP $1.41 $1.41 $1.54 $1.54 $1.63
Case Management Services included included included included included
Communications (Annual Fee or $/ee/month) included included included included included
Set Up (One time Charge) included included included included included
Number of Hours of Supervisor/empl. Training 5 hrs/year 5 hrs/year 5 hrs/year 5 hrs/year 5 hrs/year
'
'
Crisis Intervention 10 hrs/year 10 hrs/year 10 hrs/year 10 hrs/year 10 hrs/year
Management Consultations included included included included included
On Site Briefings included included included included included
Work/Life Services Available included included included included included
Emotional, Psychological, Marital, Family included included included included included
Alcohol Abuse, substance abuse included included included included included
Job related problems included included included included included
Child/Elder Care included included included included included
Legal included included included included included
Financial included included included included included
Educational-Wellness sTeleseminars included included included included included
Additional programs: Interactive Web Site included included included included included
Additional programs: Grab-A-Cab included included included included included
Additional Programs: Life Coaching included included included included included
City of Jefferson, Missouri
Tabulation of Bids
Proposal 2733
Date: May 15, 2014
Subject: Employee Assistance Program Alternatives
Dept: Personnel Kansas City MO
PAGE 2
ITEM Year One Year Two Year Three Year Four YearS I
EAP Enrollment 400
.
6 Visit EAP $1.75 $1.75 $1.86 $1.86 $1.9T
Case Management Services included included included included included •
Communications (Annual Fee or $/ee/month) included included included included included I
Set Up (One time Charge) included included included included included
Number of Hours of Supervisor/empl. Training 5 hrs/year 5 hrs/year 5 hrs/year 5 hrs/year 5 hrs/year
Crisis Intervention 10 hrs/year 10 hrs/year 10 hrs/year 10 hrs/year 10 hrs/year
Management Consultations included included included included included
On Site Briefings included included included included included
Work/Life Services Available included included included included included
Emotional, Psychological, Marital, Family included included included included included
Alcohol Abuse, substance abuse included included included included included
Job related problems included included included included included
Child/Elder Care included included included included included
Legal included included included included included
Financial included included included included included
Educational-Wellness sTeleseminars included included included included included
Additional programs: Interactive Web Site included included included included included
Additional programs: Grab-A-Cab included included included included included
Additional Programs: Life Coaching_ included included included included included
---·· -
City of Jefferson, Missouri
Tabulation of Bids
Proposal 2733
Date: May 15. 2014
Subject: Employee Assistance Program Alternatives
Dept: Personnel Kansas City MO
PAGE 3
ITEM Year One Year Two Year Three Year Four YearS
NOTE:
GENERAL FEE ASSUMPTIONS & CONSIDERATIONS 1. Fee discount applies for more than 500 employees (3%) up to 750 employees.
2. Brochures, wlalet cards, and posters needed during the year, are included.
3. Additional hours, if requested are $1 00/hour (all training in whole hour increments)
4. Additional CISD hours if requested are 175.00/hour. (in whole hour increments)
5 We assume on -site brifings are account management visits are no additional charge
6. Family members are included at no additional charge. Adult children in school included.
7. All services are unlimited during the contract year for different incidences.
Discount for prompt payment on invoices no prompt payment offered
Prices contained in this bid are firm for 90 days
Cooperative procurement by Cole County yes
Housing Authority yes
Represent a disadvantaged business enterprise no
Represent a woman owned business entreprise no
Tabulation to be emailed or fax to rread}'@alternativesEAP.com
·-
City of Jefferson, Missouri
Tabulation of Bids
Proposal 2733
Date: May 15, 2014
Subject: Employee Assistance Program Personal Assistance Serv.
Dept: Personnel St. Louis MO
PAGE 4
ITEM Year One Year Two Year Three Year Four Year 5
EAP Enrollment 400
4 visit EAP $1 65 $1.65 $1.65 $1.65 $1.65
Case Management Services included included included included included
Communications (Annual Fee or $/ee/month) included included included included included
I Set Up (One time Charge) included included included included included
Number of Hours of Supervisor/empl. Training On site training On site training On site training On site training On site training
bank of 6 hrs bank of 6 hrs bank of 6 hrs bank of 6 hrs bank of 6 hrs
per plan year. per plan year. per plan year. per plan year. per plan year.
Add'l hours Add'l hours Add'l hours Add'l hours Add'l hours
$250.00 $250.00 $250.00 $250.00 $250.00
Crisis Intervention See on site See on site See on site See on site See on site
bank above bank above bank above bank above bank above
Management Consultations included included included included included
On Site Briefings included included included included included
Work/Life Services Available included included included included included .
Emotional, Psychological, Marital, Family included included included included included •
Alcohol Abuse, substance abuse included included included included included
Job related problems included included included included included
Child/Elder Care included included included included included
Legal included included included included included
Financial included included included included included
Educational included included included included included
Additional Programs -Life Management Coaching included included included included included
Services (health, nutrition, career, retirement,
parenting, getting organized, elder care
coordination and financial consult, will kits, care
giving ping, education, child dev., tobacco cessation
City of Jefferson, Missouri
Tabulation of Bids
Proposal 2733
Date: May 15, 2014
Subject: Employee Assistance Program Personal Assistance Serv.
Dept: Personnel St. Louis MO
PAGE 5
ITEM Year One Year Two Year Three Year Four Year5
EAP Enrollment 400
6 Visit EAP $1.80 $1.80 $1.80 $1.80 $1.80
Case Management Services included included included included included
Communications (Annual Fee or $/ee/month) included included included included included
Set Up (One time Charge) included included included included included
Number of Hours of Supervisor/empl. Training On site training On site training On site training On site training On site training
bank of 6 hrs bank of 6 hrs bank of 6 hrs bank of 6 hrs bank of 6 hrs
per plan year. per plan year. per plan year. per plan year. per plan year.
Add'l hours Add'l hours Add'l hours Add'l hours Add'l hours
$250.00 $250.00 $250.00 $250.00 $250.00
Crisis Intervention See on site See on site See on site See on site See on site
bank above bank above bank above bank above bank above
Management Consultations included included included included included
On Site Briefings included included included included included
Work/Life Services Available included included included included included
Emotional, Psychological, Marital, Family included included included included included
Alcohol Abuse, substance abuse included included included included included
Job related problems included included included included included
Child/Elder Care included included included included included
Legal included included included included included
Financial included included included included included
Educational included included included included included
Additional Programs -Life Management Coaching included included included included included
Services (health, nutrition, career, retirement,
parenting, getting organized, elder care
coordination and financial consult, will kits, care
giving ping, education, child dev , tobacco cessation
City of Jefferson, Missouri
Tabulation of Bids
Proposal 2733
Date: May 15. 2014
Subject: Employee Assistance Program Personal Assistance Serv.
Dept: Personnel St. Louis MO
PAGE6
ITEM Year One Year Two Year Three Year Four Year 5
NOTE:
Indicate any enrollment threshold that would
impact the proposed rates. None. The rates are all-inclusive. Our capitated fees will remain in effect for a five three years
assuming that no substantial changes are made to the scope of services, consideration clauses
or plan design during this period.
I
Discount for prompt payment on invoices Discount for prompt payment is available
Prices contained in this bid are firm for 30 days
' Cooperative procurement by Cole County yes i
Housing Authority yes
Represent a disadvantaged business enterprise no
Represent a woman owned business entreprise yes
Tabulation to be emailed or fax to SQskinner@QaseaQcom
----------
City of Jefferson, Missouri
Tabulation of Bids
Proposal 2733
Date: May 15. 2014
Subject: Employee Assistance Program Ceridian
Dept: Personnel Minneapolis MN
PAGE 7
ITEM Year One Year Two Year Three Year Four YearS
EAP Enrollment 400
4 visit EAP $1.77 $1.77 $1.77 $1.77 $1.77
Case Management Services included included included included included
Communications (Annual Fee or $/ee/month) included included included included included
Set Up (One time Charge) included included included included included
Number of Hours of Supervisor/empl. Training 3 hrs of training 3 hrs of training 3 hrs of training 3 hrs of training 3 hrs of training
Crisis Intervention Unlimited -up to 20 hours per incident as clinically appropriate.
Management Consultations included included included included included
On Site Briefings 3 hrs of training i included included included included
Work/Life Services Available
Emotional, Psychological, Marital, Family included included included included included
Alcohol Abuse, substance abuse included iocluded included included included
Job related problems included included included included included
Child/Elder Care included included included included included
Legal included included included included included
Financial included included included included included
Educational-Wellness sTeleseminars included included included included included
Additional Programs Additional wellness programs available. Pricing available upon request.
City of Jefferson, Missouri
Tabulation of Bids
Proposal 2733
Date: May 15, 2014
Subject: Employee Assistance Program Ceridian
Dept: Personnel Minneapolis MN
PAGE 8
ITEM Year One Year Two Year Three Year Four Year 5
EAP Enrollment 400
6 Visit EAP $1.86 $1.86 $1.86 $1.86 $1.86
Case Management Services included included included included included
Communications (Annual Fee or $/ee/month) included included included included included
Set Up (One time Charge) included included included included included
Number of Hours of Supervisor/empl. Training 3 hrs of training 3 hrs of training 3 hrs of training 3 hrs of training 3 hrs of training
Crisis Intervention Unlimited -up to 20 hours per incident as clinically appropriate.
Management Consultations included included included included included
On Site Briefings 3 hrs of training i included included included included
Work/Life Services Available
Emotional, Psychological, Marital, Family included included included included included
Alcohol Abuse, substance abuse included included included included included
Job related problems included included included included included
Child/Elder Care included included included included included
Legal included included included included included
Financial included included included included included
Educational-Wellness sTeleseminars included included included included included
-
~ditional Programs
--------
Additional wellness programs available. Pricing available upon request
City of Jefferson, Missouri
Tabulation of Bids
Proposal 2733
Date: May 15, 2014
Subject: Employee Assistance Program Ceridian
Dept: Personnel Minneapolis MN
PAGE 9
ITEM Year One Year Two Year Three Year Four Year5
Discount for prompt payment 0% -Net 30 days
Prices contained in this propsal firm for 60 days
Agree to cooperative procurement Cole Co. yes
Housing Authority yes
Represent a disadvantaged business no
Represent a woman owned business no
Tabulation to be sent to email or fax chris.Qowers@ceridian.com
City of Jefferson, Missouri
Tabulation of Bids
Proposal 2733
Date: May 15. 2014
Subject: Employee Assistance Program Capital Region
Dept: Personnel Jefferson City MO
PAGE10
ITEM Year One Year Two Year Three Year Four Year 5
EAP Enrollment 400
4 visit EAP $1.86 $1.92 $1.98 $2.04 $2.10
Case Management Services 0 0 0 0 0
Communications (Annual Fee or $/ee/month) 0 0 0 0 0
Set Up (One time Charge) 0 0 0 0 0
Number of Hours of Supervisor/empl. Training 4 4 4 4 4
Crisis Intervention 0 0 0 0 0
Management Consultations 0 0 0 0 0
On Site Briefings 0 0 0 0 0
Work/life Services Available
Emotional, Psychological, Marital, Family yes yes yes yes yes
Alcohol Abuse, substance abuse yes yes yes yes yes
Job related problems yes yes yes yes yes
Child/Elder Care yes yes yes yes yes
Legal yes yes yes yes yes
Financial yes yes yes yes yes
Educational-Wellness sTeleseminars yes yes yes yes yes
. ,Additional Programs
------------'-----
yes
,_
yes __ yes yes yes
City of Jefferson, Missouri
Tabulation of Bids
Proposal 2733
Date: May 15,2014
Subject: Employee Assistance Program Capital Region
Dept: Personnel Jefferson City MO
PAGE 11
ITEM Year One Year Two Year Three Year Four YearS
EAP Enrollment 400
6 Visit EAP $2.02 $2.08 $2.14 $2.20 $2.27
Case Management Services 0 0 0 0 0
Communications (Annual Fee or $/ee/month) 0 0 0 0 0
Set Up (One time Charge) 0 0 0 0 0
Number of Hours of Supervisor/em pl. Training 4 4 4 4 41
I
I
.
Crisis Intervention 0 0 0 0 0
'
Management Consultations 0 0 0 0 0
On Site Briefings 0 0 0 0 0
Work/Life Services Available
Emotional. Psychological, Marital. Family yes yes yes yes yes
Alcohol Abuse, substance abuse yes yes yes yes yes
Job related problems yes yes yes yes yes
Child/Elder Care yes yes yes yes yes
Legal yes yes yes yes yes
Financial yes yes yes yes yes
Educational-Wellness sTeleseminars yes yes yes yes yes
Additional Programs yes yes yes yes yes
City of Jefferson, Missouri
Tabulation of Bids
Proposal 2733
Date: May 15. 2014
Subject: Employee Assistance Program Capital Region
Dept: Personnel Jefferson City MO
PAGE12
ITEM Year One Year Two Year Three Year Four YearS
Discount for prompt payment 0%-0 days
Prices contained in this propsal firm for 120 days
Agree to cooperative procurement Cole Co. yes
Housing Authority yes
Represent a disadvantaged business no
Represent a woman owned business no
Tabulation to be sent to email or fax jwieberg@crmc.org
City of Jefferson, Missouri
Tabulation of Bids
Proposal 2733
Date: May 15. 2014
Subject: Employee Assistance Program Humana
Dept: Personnel New York, NY
PAGE13
ITEM Year One Year Two Year Three Year Four Year 5
EAP Enrollment 400
4 visit EAP $2.12 $2.12 $2.12 $2.12 $2.12
Case Management Services included inclulded included included included
Communications (Annual Fee or $/ee/month) Our fees include the printing and production of a program brochure equivalent to 150 percent
of the the City's total employee population for the term of the contract.
Set Up (One time Charge) 0 Ol 0 0 0
Number of Hours of Supervisor/empl. Training Manager training on the use of the EAP is included and unlimited. Management skills training
can be provided for $650/hour plus travel.
Crisis Intervention Availiable for $250/hour plus travel.
Management Consultations Unlimited Unlimited Unlimited Unlimited Unlimited
On Site Briefings Unlimited Unlimited Unlimited Unlimited Unlimited
Work/Life Services Available
Emotional, Psychological, Marital, Family Included Included Included Included Included
Alcohol Abuse, substance abuse Included Included Included Included Included
Job related problems Included Included Included Included Included
Child/Elder Care Included Included Included Included Included
Legal Included Included Included Included Included
Financial Included Included Included Included Included
Educational-Wellness sTeleseminars Included Included Included Included Included
Additional Programs
-
City of Jefferson, Missouri
Tabulation of Bids
Proposal 2733
Date: May15,2014
Subject: Employee Assistance Program Humana
Dept: Personnel New York, NY
PAGE 14
• ITEM Year One Year Two Year Three Year Four Year5 '
EAP Enrollment 400
6 Visit EAP $2.80 $2.80 $2.80 $2.80 $2.80
Case Management Services
Communications (Annual Fee or $/ee/month) Our fees include the printing and production of a program brochure equivalent to 150 percent
of the the City's total employee population for the term of the contract.
Set Up (One time Charge) 0 0 0 0 0
Number of Hours of Supervisor/empl. Training Manager training on the use of the EAP is included and unlimited. Management skills training
can be provided for $650/hour plus travel.
Crisis Intervention Availiable for $250/hour plus travel.
Management Consultations Unlimited Unlimited Unlimited Unlimited Unlimited
On Site Briefings Unlimited Unlimited Unlimited Unlimited Unlimited
Work/Life Services Available
Emotional, Psychological, Marital, Family Included Included Included Included Included
Alcohol Abuse, substance abuse Included Included Included Included Included
Job related problems Included Included Included Included Included
Child/Elder Care Included Included Included Included Included
Legal Included Included Included Included Included
Financial Included Included Included Included Included
Educational-Wellness sTeleseminars Included Included Included Included Included
Additional Programs
City of Jefferson, Missouri
Tabulation of Bids
Proposal 2733
Date: May 15. 2014
Subject: Employee Assistance Program Humana
Dept: Personnel New York, NY
PAGE15
ITEM Year One Year Two Year Three Year Four YearS
Indicate any enrollment threshold that would Fees quoted are payable per employee per month for actual eligible count, and are valid for not
impact the proposed rates less than 360 employees. Reductions in employee count below this minimum, whether due to
employee attrition or network members opting out of the program, allow us to adjust fees. i
Discount for prompt payment 0%-0 days
Prices contained in this propsal firm for 1095 days with three year contract
Agree to cooperative procurement Cole Co. yes
Housing Authority yes
Represent a disadvantaged business no
Represent a woman owned business no
Tabulation to be sent to email or fax chenderson12@humana.com