HomeMy Public PortalAbout2018-05-24 packet
Notice of Meeting and Tentative Agenda
CITY OF JEFFERSON
Finance Committee
Thursday, May 24, 2018 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 March 8, 2018 meeting and the April 16, 2018 meeting
4. Financial Reports
a. Sales Tax Report
b. Revenue Model Report
c. Expense Report
d. Fund Balance Report
5. Lodging Tax Report
6. Municipal Court Bid – Ryan Moehlman
7. Proposed Budget Calendar – Margie Mueller
8. New Business
9. Old Business
10. 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, March 8, 2018
MINUTES
The meeting was called to order by the Finance Committee Chairman, Councilman Mihalevich at 7:32 am. Roll
call showed that Councilmen Mihalevich, Graham and Henry were in attendance. Councilman Prather and
Hussey were not in attendance.
Next the minutes of the February 8, 2018 meeting were reviewed. A motion to approve was made by Councilman
Henry and seconded by Councilman Graham. The minutes were approved unanimously.
The next item on the agenda was a report by the Finance Director, Margie Mueller, covering the Financial
Reports. Ms. Mueller reviewed the Revenue Model, the March sales tax receipts, year-to-date general ledger
account information, and the current fund balance calculation.
The next item on the agenda was a report by Chief Accountant, Shiela Pearre, covering the Lodging Tax receipts
to date. 4/7 of the Lodging tax collected during the timeframe where the rate has been 7%, less any expenses paid
by the 4 Cent Lockbox Fund, is $4,431,815. The average monthly amount collected for the 4 Cent Lockbox Fund
is $52,063. A report comparing occupancy rates for 2018, 2017, 2016, 2015, 2014, 2013 and 2012 was included
along with a report listing occupancy rates from other cities.
The next item on the agenda was an update on the Capital Projects List from Ms. Mueller.
There was no new business to discuss.
The next item on the agenda was old business. Councilman Mihalevich brought up potentially moving the
Finance Committee Meeting to another day once the new Council is sworn in after the April election.
Councilman Henry thanked everyone for their commitment and continued service, as this will be his last meeting
as a member of the City Council.
The meeting adjourned at 8:02 am.
As recorded by:
Shiela Pearre, Chief Accountant
Minutes of Meeting
Jefferson City Council Committee on Finance
Monday, April 16, 2018
Item 20 on the Second Regular Council Meeting Agenda
(New City Council)
6:00 PM City Council Meeting
City Hall - 320 E. McCarty Street
City Council Chambers
The meeting was convened at 7:37 P.M. by the current Chair of the Committee,
Councilman Mihalevich for the purpose of election of officers.
Members of the Committee were noted present by roll call:
Present: Graham, Hensley, Mihalevich, Prather, and Wiseman
Absent: None
Councilman Mihalevich opened the floor for nominations of Chair and Vice-Chair.
Chair – Councilman Graham nominated Councilman Prather as Chair.
Councilwoman Wiseman motioned to cease nominations and elect Councilman
Prather by acclamation. Councilman Graham seconded the motion. Councilman
Prather was elected unanimously.
Vice-Chair – Councilman Prather nominated Councilman Mihalevich as Vice-
Chair.
Councilwoman Wiseman motioned to cease nominations and elect Councilman
Mihalevich by acclamation. Councilman Graham seconded the motion.
Councilman Mihalevich was elected unanimously.
There being no further business brought before the Committee at this time,
Councilwoman Wiseman moved for adjournment, seconded by Councilman
Prather, and approved unanimously at 7:39 PM.
Memo
To:Steve Crowell
From:Shiela Pearre
Date:May 7, 2018
Re:Sales Tax Revenues
The City received the May 1% Sales Tax in the amount of $709,248.07 which is $36,477 more
than projected for May. January through May overage is $50,242 (0.44%) in the General Fund.
1% General Sales Tax
Receipt Actual Budget
Period Receipts Projection
1 Variance
Nov-17 Jan-18 $884,259 $ 1,017,766 ($133,507)
Dec-17 Feb-18 $927,290 $ 807,675 $119,615
Jan-18 & Oct-Dec 17 Qtrly Mar-18 $1,155,742 $ 1,152,386 $3,356
Feb-18 Apr-18 $986,714 $ 962,414 $24,301
Mar-18 May-18 $709,248 $ 672,771 $36,477
Apr-18 & Jan-Mar 18 Qtrly Jun-18 $ 1,089,718
May-18 Jul-18 $ 1,077,018
Jun-18 Aug-18 $ 654,961
Jul-18 & Apr-June 18 Qtrly Sep-18 $ 1,213,930
Aug-18 Oct-18 $ 931,219
Sep-18 Nov-18 $ 654,277
Oct-18 & Jul-Sept 18 Qtrly Dec-18 $ 1,178,865
Total Overage/Shortfall $11,413,000 $50,242
1Budgeted based on 3-year average percentage
1/2% Capital Improvement Tax - Sales Tax G
Receipt Actual Budget
Period Receipts Projection
2 Variance
Nov-17 Jan-18 $424,160 $ 445,880 ($21,720)
Dec-17 Feb-18 $444,476 $ 353,840 $90,636
Jan-18 & Oct-Dec 17 Qtrly Mar-18 $575,894 $ 504,857 $71,037
Feb-18 Apr-18 $455,943 $ 421,631 $34,312
Mar-18 May-18 $340,740 $ 294,739 $46,001
Apr-18 & Jan-Mar 18 Qtrly Jun-18 $ 477,402
May-18 Jul-18 $ 471,838
Jun-18 Aug-18 $ 286,937
Jul-18 & Apr-June 18 Qtrly Sep-18 $ 531,819
Aug-18 Oct-18 $ 407,964
Sep-18 Nov-18 $ 286,637
Oct-18 & Jul-Sept 18 Qtrly Dec-18 $ 516,457
BUDGET AMENDMENT DUE TO ORDINANCE 15775 $0 $ 1,035,852 ($1,035,852)
Total Overage/Shortfall $6,035,852 ($815,586)
2Budgeted based on 3-year average percentage
1/2% Parks Sales Tax
Receipt Actual Budget
Period Receipts Projection
3 Variance
Nov-17 Jan-18 $424,192 $ 457,027 ($32,836)
Dec-17 Feb-18 $450,479 $ 362,686 $87,793
Jan-18 & Oct-Dec 17 Qtrly Mar-18 $577,148 $ 517,478 $59,669
Feb-18 Apr-18 $457,060 $ 432,171 $24,888
Mar-18 May-18 $340,708 $ 302,107 $38,601
Apr-18 & Jan-Mar 18 Qtrly Jun-18 $ 489,337
May-18 Jul-18 $ 483,634
Jun-18 Aug-18 $ 294,110
Jul-18 & Apr-June 18 Qtrly Sep-18 $ 545,115
Aug-18 Oct-18 $ 418,163
Sep-18 Nov-18 $ 293,803
Oct-18 & Jul-Sept 18 Qtrly Dec-18 $ 529,369
Total Overage/Shortfall $5,125,000 $178,116
3Budgeted based on 3-year average percentage
Period
Reporting
Period
Reporting
Period
Reporting
City of Jefferson, Mo. - Account Analysis
Account Name General Fund Sales Tax Receipt Month: MAY 2018
Account Number 10-100-400010 Prior 5 years
Monthly
REPORTING PERIOD RECEIPT PERIOD 2013 2014 2015 2016 2017 2018 Average
Nov January 764,659 741,056 944,619 929,179 1,083,570 884,259 act. 892,617
Dec February 703,181 789,830 727,437 812,670 806,789 927,290 act. 767,982
Jan & Oct-Dec Qtrly March 1,008,111 920,599 1,091,021 1,183,675 1,073,842 1,155,742 act. 1,055,450
Feb April 777,424 737,482 1,059,943 893,024 843,561 986,714 act. 862,287
Mar May 537,141 802,765 618,854 648,305 687,741 709,248 act. 658,961
Apr & Jan-Mar Qtrly June 1,023,015 865,930 1,045,933 1,119,566 1,000,942 1,089,718 est. 1,011,077
May July 872,436 1,048,754 963,280 1,012,207 1,154,051 1,077,018 est. 1,010,146
Jun August 546,351 614,048 562,996 661,518 678,636 654,961 est. 612,710
Jul & Apr-Jun Qtrly September 1,096,581 996,272 1,185,891 1,197,976 1,143,504 1,213,930 est. 1,124,045
Aug October 717,262 919,035 918,839 903,829 883,215 931,219 est. 868,436
Sept November 677,366 651,080 661,849 623,645 615,667 654,277 est. 645,921
Oct & Jul-Sept Qtrly December 932,387 1,015,322 1,075,638 1,016,682 1,149,946 1,178,865 est. 1,037,995
Actual to Date $ 9,655,913 $ 10,102,175 $ 10,856,302 $ 11,002,277 $ 11,121,463 4,663,254
Estimated to Fiscal Year end (based on averages and on Budgeted amount)6,799,988
Total Actual & Estimated $ 11,463,242
Less: Budget 11,413,000
Over (Under) Budget $ 50,242
$ 884,259
$ 1,811,549
$ 2,967,291
$ 3,954,006
$ 4,663,254
$ 1,017,766
$ 1,825,441
$ 2,977,827
$ 3,940,241
$ 4,613,012
$ 5,702,730
$ 6,779,748
$ 7,434,709
$ 8,648,639
$ 9,579,858
$ 10,234,135
$ 11,413,000
$ 500,000
$ 750,000
$ 1,000,000
$ 1,250,000
$ 1,500,000
$ 1,750,000
$ 2,000,000
$ 2,250,000
$ 2,500,000
$ 2,750,000
$ 3,000,000
$ 3,250,000
$ 3,500,000
$ 3,750,000
$ 4,000,000
$ 4,250,000
$ 4,500,000
$ 4,750,000
$ 5,000,000
$ 5,250,000
$ 5,500,000
$ 5,750,000
$ 6,000,000
$ 6,250,000
$ 6,500,000
$ 6,750,000
$ 7,000,000
$ 7,250,000
$ 7,500,000
$ 7,750,000
$ 8,000,000
$ 8,250,000
$ 8,500,000
$ 8,750,000
$ 9,000,000
$ 9,250,000
$ 9,500,000
$ 9,750,000
$ 10,000,000
$ 10,250,000
$ 10,500,000
$ 10,750,000
$ 11,000,000
$ 11,250,000
$ 11,500,000
$ 11,750,000
$ 12,000,000
Nov Dec Jan & Oct‐Dec
Qtrly
Feb Mar Apr & Jan‐
Mar Qtrly
May Jun Jul & Apr‐Jun
Qtrly
Aug Sept Oct & Jul‐Sept
Qtrly
REPORTING PERIOD
YTD Actuals vs. YTD Budget
Actual
Budget
Printed 5/14/2018
City of Jefferson, Mo. - Account Analysis
Account Name Capital Imprs Sales Tax Receipt Month: MAY 2018
Account Number 45-100-440010 Prior 5 years
Monthly
REPORTING PERIOD RECEIPT PERIOD 2013 2014 2015 2016 2017 2018 Average
Nov January 372,459 359,800 461,560 455,278 525,521 424,160 act. 434,923
Dec February 350,813 394,475 362,597 405,543 402,964 444,476 act. 383,278
Jan & Oct-Dec Qtrly March 475,110 423,641 511,685 563,056 506,597 575,894 act. 496,018
Feb April 372,340 348,172 512,808 431,353 411,020 455,943 act. 415,139
Mar May 266,422 399,863 308,247 322,957 340,162 340,740 act. 327,530
Apr & Jan-Mar Qtrly June 483,070 416,943 496,466 539,529 489,008 477,402 est. 485,003
May July 425,325 503,869 473,120 498,229 559,119 471,838 est. 491,932
Jun August 272,603 306,157 280,733 330,112 338,618 286,937 est. 305,645
Jul & Apr-Jun Qtrly September 521,260 484,992 565,296 570,134 542,457 531,819 est. 536,828
Aug October 357,619 430,185 442,371 435,416 425,493 407,964 est. 418,217
Sept November 323,871 324,697 330,393 310,506 307,281 286,637 est. 319,350
Oct & Jul-Sept Qtrly December 443,688 485,136 515,478 494,218 561,415 516,457 est. 499,987
Actual to Date $ 4,664,580 $ 4,877,931 $ 5,260,753 $ 5,356,330 $ 5,409,655 2,241,212
Estimated to Fiscal Year end (based on averages and on Budgeted amount)2,979,054
Total Actual & Estimated $ 5,220,266
Less: Budget (Increased by $1,035,852 due to Ordinance 15775) 6,035,852
Over (Under) Budget -$ 815,586
$ 424,160
$ 868,636
$ 1,444,529
$ 1,900,472
$ 2,241,212
$ 445,880
$ 799,720
$ 1,304,577
$ 1,726,207
$ 2,020,946
$ 2,498,348
$ 2,970,186
$ 3,257,123
$ 3,788,942
$ 4,196,906
$ 4,483,543
$ 6,035,852
$ 100,000
$ 350,000
$ 600,000
$ 850,000
$ 1,100,000
$ 1,350,000
$ 1,600,000
$ 1,850,000
$ 2,100,000
$ 2,350,000
$ 2,600,000
$ 2,850,000
$ 3,100,000
$ 3,350,000
$ 3,600,000
$ 3,850,000
$ 4,100,000
$ 4,350,000
$ 4,600,000
$ 4,850,000
$ 5,100,000
$ 5,350,000
Nov Dec Jan & Oct‐
Dec Qtrly
Feb Mar Apr & Jan‐
Mar Qtrly
May Jun Jul & Apr‐Jun
Qtrly
Aug Sept Oct & Jul‐
Sept Qtrly
REPORTING PERIOD
YTD Actuals vs. YTD Budget
Actual
Budget
Printed 5/14/2018
City of Jefferson, Mo. - Account Analysis
Account Name Parks Sales Tax Receipt Month: MAY 2018
Account Number 21-210-400010 Prior 5 years
Monthly
REPORTING PERIOD RECEIPT PERIOD 2012 2013 2014 2015 2016 2017 2018 Average
Nov January 405,730 372,447 359,708 461,472 455,239 525,521 424,192 act. 434,877
Dec February 308,456 350,714 393,562 362,371 405,543 395,217 450,479 act. 381,481
Jan & Oct-Dec Qtrly March 466,713 475,026 423,546 511,582 563,039 506,524 577,148 act. 495,943
Feb April 409,353 372,242 348,076 512,738 431,353 411,020 457,060 act. 415,086
Mar May 263,822 266,456 398,085 308,030 322,957 340,162 340,708 act. 327,138
Apr & Jan-Mar Qtrly June 494,733 482,382 416,845 496,386 539,529 489,008 489,337 est. 484,830
May July 389,006 425,194 503,790 473,038 498,229 559,115 483,634 est. 491,873
Jun August 278,072 272,321 305,930 280,513 330,112 338,470 294,110 est. 305,469
Jul & Apr-Jun Qtrly September 505,913 521,155 484,904 565,217 572,847 542,457 545,115 est. 537,316
Aug October 366,846 357,482 430,093 442,370 435,416 425,497 418,163 est. 418,172
Sept November 306,831 323,768 324,481 330,393 310,506 307,305 293,803 est. 319,291
Oct & Jul-Sept Qtrly December 468,924 443,569 484,999 515,368 494,218 561,445 529,369 est. 499,919
Actual to Date $ 4,664,400 $ 4,662,755 $ 4,874,018 $ 5,259,477 $ 5,358,988 $ 5,401,741 2,249,586
Estimated to Fiscal Year end (based on averages and on Budgeted amount)3,053,530
Total Actual & Estimated $ 5,303,116
Less: Budget 5,125,000
Over (Under) Budget $ 178,116
$ 424,192
$ 874,671
$ 1,451,818
$ 1,908,878
$ 2,249,586
$ 457,027
$ 819,713
$ 1,337,191
$ 1,769,363
$ 2,071,470
$ 2,560,807
$ 3,044,441
$ 3,338,551
$ 3,883,666
$ 4,301,829
$ 4,595,631
$ 5,125,000
$ 100,000
$ 350,000
$ 600,000
$ 850,000
$ 1,100,000
$ 1,350,000
$ 1,600,000
$ 1,850,000
$ 2,100,000
$ 2,350,000
$ 2,600,000
$ 2,850,000
$ 3,100,000
$ 3,350,000
$ 3,600,000
$ 3,850,000
$ 4,100,000
$ 4,350,000
$ 4,600,000
$ 4,850,000
$ 5,100,000
$ 5,350,000
$ 5,600,000
Nov Dec Jan & Oct‐Dec
Qtrly
Feb Mar Apr & Jan‐Mar
Qtrly
May Jun Jul & Apr‐Jun
Qtrly
Aug Sept Oct & Jul‐Sept
Qtrly
REPORTING PERIOD
YTD Actuals vs. YTD Budget
Actual
Budget
Printed 5/14/2018
Re
v
e
n
u
e
Mo
d
e
l
Re
p
o
r
t
Fo
r
Pe
r
i
o
d
En
d
i
n
g
Ap
r
i
l
30
,
20
1
8
Da
t
a
as
of
Ma
y
3,
20
1
8
FY
20
1
8
Y
T
D
Ac
t
u
a
l
P
r
o
j
e
c
t
e
d
Ov
e
r
/
De
s
c
r
i
p
t
i
o
n
Bu
d
g
e
t
As
of
5/
3
/
1
8
(U
n
d
e
r
)
Bu
d
g
e
t
Sa
l
e
s
Ta
x
an
d
Us
e
Ta
x
$1
1
,
4
1
3
,
0
0
0
.
0
0
$
4
,
6
6
3
,
2
5
3
.
7
4
$
5
0
,
2
4
1
.
7
2
In
t
e
r
g
o
v
e
r
n
m
e
n
t
a
l
Ta
x
e
s
$2
,
2
5
9
,
0
0
0
.
0
0
$
5
5
7
,
5
9
1
.
6
8
$
1
0
0
,
8
6
3
.
8
1
Ot
h
e
r
Ta
x
e
s
$1
1
5
,
0
0
0
.
0
0
$
3
3
,
8
0
1
.
4
8
($
2
,
6
1
0
.
9
3
)
Fr
a
n
c
h
i
s
e
& Ut
i
l
i
t
y
Ta
x
$7
,
4
3
0
,
0
0
0
.
0
0
$
2
,
5
8
5
,
8
1
0
.
8
8
$
1
6
2
,
0
2
6
.
9
6
Pr
o
p
e
r
t
y
Ta
x
e
s
$5
,
4
0
6
,
3
9
9
.
0
0
$
5
,
2
4
4
,
8
0
3
.
3
8
($
8
,
2
8
3
.
6
2
)
In
t
e
r
g
o
v
e
r
n
m
e
n
t
a
l
$4
3
4
,
9
7
1
.
5
0
$
2
1
4
,
0
5
2
.
9
6
($
2
0
0
,
0
1
5
.
9
2
)
Ch
a
r
g
e
s
fo
r
Se
r
v
i
c
e
s
$2
,
7
6
4
,
8
3
1
.
6
9
$
2
,
0
9
0
,
1
2
5
.
6
0
$
6
6
,
7
8
9
.
7
2
Fe
e
s
,
Li
c
e
n
s
e
s
,
& Pe
r
m
i
t
s
$8
0
0
,
7
0
0
.
0
0
$
4
2
4
,
5
5
5
.
6
6
$
1
4
3
,
3
2
1
.
0
9
Fi
n
e
s
& Fo
r
f
e
i
t
u
r
e
s
$8
9
4
,
1
0
0
.
0
0
$
3
4
2
,
6
3
0
.
5
8
($
4
3
,
7
0
3
.
7
3
)
Co
n
t
r
i
b
u
t
i
o
n
s
/
D
o
n
a
t
i
o
n
s
$3
1
3
,
7
1
2
.
5
0
$
1
1
7
,
9
2
0
.
0
0
$
1
4
,
0
7
0
.
0
0
Ot
h
e
r
Op
e
r
a
t
i
n
g
Re
v
e
n
u
e
s
$8
4
,
0
0
0
.
0
0
$
2
4
,
9
9
0
.
1
5
($
1
1
8
.
9
7
)
In
t
e
r
e
s
t
In
c
o
m
e
$1
2
1
,
0
6
2
.
3
9
$
5
5
,
6
7
9
.
7
8
$
2
0
,
1
3
5
.
5
9
Ot
h
e
r
No
n
Op
e
r
a
t
i
n
g
Re
v
e
n
u
e
$4
5
,
0
0
0
.
0
0
$
3
1
,
3
4
3
.
4
0
$
1
6
,
3
4
3
.
4
0
Op
e
r
a
t
i
n
g
Tr
a
n
s
f
e
r
s
In
$2
4
,
0
2
4
.
0
0
$7
,
1
5
3
.
1
0
$2
2
4
.
6
3
To
t
a
l
s
$3
2
,
1
0
5
,
8
0
1
.
0
8
$
1
6
,
3
9
3
,
7
1
2
.
3
9
$
3
1
9
,
2
8
3
.
7
4
FY2018
Revenue Model Report (Detail)Remaining
For Period Ending April 30, 2018 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification
Description Budget As of 5/3/18 As of 5/3/18 TOTAL (Under) Budget of Formulas
Sales Tax and Use Tax
10‐100‐400010 Sales Tax $11,413,000.00 $4,663,253.74 $6,799,987.98 $11,463,241.72 $50,241.72 $50,241.72
$11,413,000.00 $4,663,253.74 $6,799,987.98 $11,463,241.72 $50,241.72 $50,241.72
Intergovernmental Taxes
10‐100‐401030 Motor Vehicle Sales Tax $562,000.00 $193,207.81 $380,242.39 $573,450.20 $11,450.20 $11,450.20
10‐100‐403010 Gasoline Tax $1,147,000.00 $364,383.87 $872,029.74 $1,236,413.61 $89,413.61 $89,413.61
10‐100‐430080 Road & Bridge Tax $550,000.00 $0.00 $550,000.00 $550,000.00 $0.00 $0.00
$2,259,000.00 $557,591.68 $1,802,272.13 $2,359,863.81 $100,863.81 $100,863.81
Other Taxes
10‐100‐403020 Cig Tax $115,000.00 $33,801.48 $78,587.59 $112,389.07 ($2,610.93)($2,610.93)
$115,000.00 $33,801.48 $78,587.59 $112,389.07 ($2,610.93)($2,610.93)
Franchise & Utility Tax
10‐100‐410020 Electric Utility Lic Tax $4,050,000.00 $1,162,514.90 $2,902,022.71 $4,064,537.61 $14,537.61 $14,537.61
10‐100‐410021 Electric Utility‐AUDIT $0.00 $233,160.20 $0.00 $233,160.20 $233,160.20 $233,160.20
10‐100‐410030 Gas Utility License Tax $900,000.00 $501,904.26 $416,015.40 $917,919.66 $17,919.66 $17,919.66
10‐100‐410052 Telephone/Cell Utility $2,050,000.00 $604,016.72 $1,363,531.24 $1,967,547.96 ($82,452.04)($82,452.04)
10‐100‐410053 Telephone/Cell Audit $0.00 ($15,210.20)$15,210.20 $0.00 $0.00 $0.00
10‐100‐410060 Cable Franchise Fee $430,000.00 $99,425.00 $309,436.53 $408,861.53 ($21,138.47)($21,138.47)
$7,430,000.00 $2,585,810.88 $5,006,216.08 $7,592,026.96 $162,026.96 $162,026.96
Property Taxes
10‐100‐420010 Current Property Tax $4,740,000.00 $4,648,247.15 $84,282.31 $4,732,529.46 ($7,470.54)($7,470.54)
10‐100‐420020 Del Property Tax $40,000.00 $7,462.29 $25,368.84 $32,831.13 ($7,168.87)($7,168.87)
10‐100‐420040 Fin Institution Tax $48,000.00 $37,276.50 $0.00 $37,276.50 ($10,723.50)($10,723.50)
10‐100‐420050 Prop Tax Int & Penalties $25,000.00 $11,774.35 $17,601.32 $29,375.67 $4,375.67 $4,375.67
10‐100‐420055 Surtax Receipts ‐ County Reimb $54,399.00 $54,399.28 $0.00 $54,399.28 $0.28 $0.28
10‐100‐420060 Surtax Receipts $469,000.00 $457,125.17 $6,911.30 $464,036.47 ($4,963.53)($4,963.53)
10‐100‐420080 Special Tax Rev $30,000.00 $28,518.64 $19,148.24 $47,666.88 $17,666.88 $17,666.88
$5,406,399.00 $5,244,803.38 $153,312.00 $5,398,115.38 ($8,283.62)($8,283.62)
Intergovernmental
10‐100‐430010 Federal Grant $434,971.50 $166,955.58 $68,000.00 $234,955.58 ($200,015.92)($200,015.92)
10‐100‐430040 Local Grant $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
10‐100‐480020 NSP Rehab Sales $0.00 $47,097.38 ($47,097.38)$0.00 $0.00 $0.00
10‐100‐480025 HUD Program Income $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$434,971.50 $214,052.96 $20,902.62 $234,955.58 ($200,015.92)($200,015.92)
Charges for Services
10‐100‐440010 Admin Charge Backs $1,589,556.00 $1,599,415.00 $0.00 $1,599,415.00 $9,859.00 $9,859.00
10‐100‐440050 Emt Reimbursement $25,000.00 $25,000.00 $0.00 $25,000.00 $0.00 $0.00
10‐100‐440210 Street Cuts $26,000.00 $9,323.00 $14,914.89 $24,237.89 ($1,762.11)($1,762.11)
10‐100‐440910 Fuel Charge ‐ backs $14,000.00 $4,016.38 $7,992.11 $12,008.49 ($1,991.51)($1,991.51)
10‐100‐440920 Parts Charge backs $185,000.00 $91,252.78 $124,896.54 $216,149.32 $31,149.32 $31,149.32
10‐100‐440930 Labor Charge backs $245,000.00 $89,830.47 $165,928.77 $255,759.24 $10,759.24 $10,759.24
10‐100‐481020 Cole Cty Animal Rescue $108,145.00 $27,036.43 $81,108.75 $108,145.18 $0.18 $0.18
10‐100‐481030 Rent City Hall/Annex $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
10‐100‐481040 Rent Other $0.00 $0.00 $12,000.00 $12,000.00 $12,000.00 $12,000.00
10‐100‐481045 Rent‐tower Sites $140,000.00 $56,024.77 $91,947.31 $147,972.08 $7,972.08 $7,972.08
10‐100‐481065 Parking Spot Maintenance $25,000.00 $25,000.00 $0.00 $25,000.00 $0.00 $0.00
10‐100‐481075 Cole Cty 911 Reimb $377,368.50 $155,890.27 $221,299.96 $377,190.23 ($178.27)($178.27)
10‐100‐481080 Sale Of Maps/GIS Data $0.00 $50.00 $0.00 $50.00 $50.00 $50.00
10‐100‐481085 Cole Cty GIS Joint Coop $16,850.00 $6,250.00 $10,600.00 $16,850.00 $0.00 $0.00
10‐100‐481100 Sale Of Grave Sites $4,000.00 $816.00 $1,895.28 $2,711.28 ($1,288.72)($1,288.72)
10‐100‐481105 TIF Administration Fee $8,912.19 $230.00 $8,912.19 $9,142.19 $230.00 $230.00
10‐100‐481110 Long & Short $0.00 ($9.50)$0.00 ($9.50)($9.50)($9.50)
$2,764,831.69 $2,090,125.60 $741,495.81 $2,831,621.41 $66,789.72 $66,789.72
Fees, Licenses, & Permits
10‐100‐450010 Liquor Licenses $59,000.00 $6,419.84 $46,510.94 $52,930.78 ($6,069.22)($6,069.22)
10‐100‐450020 Business Licenses $215,000.00 $90,384.25 $123,474.89 $213,859.14 ($1,140.86)($1,140.86)
10‐100‐450021 Home Occupation Permit $1,600.00 $1,060.00 $919.10 $1,979.10 $379.10 $379.10
10‐100‐450040 Abandoned Bldg. Regist. $0.00 $2,890.00 $0.00 $2,890.00 $2,890.00 $2,890.00
10‐100‐450041 Abandoned Bldg. Admin Fee $6,500.00 $151,010.30 ($8,050.44)$142,959.86 $136,459.86 $136,459.86
10‐100‐450045 Building Construct. Fees $245,000.00 $78,291.66 $174,134.20 $252,425.86 $7,425.86 $7,425.86
10‐100‐450050 Electrical Certificates $19,000.00 $17,202.00 $3,149.87 $20,351.87 $1,351.87 $1,351.87
10‐100‐450060 Electrical Permits $4,000.00 $777.50 $2,684.00 $3,461.50 ($538.50)($538.50)
10‐100‐450070 Plumbing Licenses $10,500.00 $10,305.00 $1,744.80 $12,049.80 $1,549.80 $1,549.80
10‐100‐450080 Plumbing Permits $3,600.00 $2,020.00 $2,279.52 $4,299.52 $699.52 $699.52
FY2018
Revenue Model Report (Detail)Remaining
For Period Ending April 30, 2018 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification
Description Budget As of 5/3/18 As of 5/3/18 TOTAL (Under) Budget of Formulas
10‐100‐450090 Other Lic & Permits $2,000.00 $867.00 $1,068.25 $1,935.25 ($64.75)($64.75)
10‐100‐450091 Day Care Inspection Fees $7,000.00 $3,925.00 $4,016.34 $7,941.34 $941.34 $941.34
10‐100‐450092 Food Inspection Fees $85,000.00 $4,038.91 $80,684.21 $84,723.12 ($276.88)($276.88)
10‐100‐450100 Curb Cut Permits $800.00 $265.00 $499.43 $764.43 ($35.57)($35.57)
10‐100‐450110 Board Of Adj Fees $1,300.00 $210.00 $750.70 $960.70 ($339.30)($339.30)
10‐100‐450120 Sign Permits $6,000.00 $2,199.00 $3,660.31 $5,859.31 ($140.69)($140.69)
10‐100‐450130 Demolition Permits $900.00 $477.00 $554.68 $1,031.68 $131.68 $131.68
10‐100‐450150 Acc Rep Fees‐police $11,200.00 $5,110.20 $6,978.86 $12,089.06 $889.06 $889.06
10‐100‐450160 Accrpt/blastg P‐fire $900.00 $333.00 $687.29 $1,020.29 $120.29 $120.29
10‐100‐450170 Animal Redemption Fees $63,000.00 $20,560.00 $39,351.97 $59,911.97 ($3,088.03)($3,088.03)
10‐100‐450180 Animal Vaccinations Fees $4,800.00 $1,975.00 $2,786.55 $4,761.55 ($38.45)($38.45)
10‐100‐450185 Animal Cremation Fees $33,000.00 $15,950.00 $21,744.70 $37,694.70 $4,694.70 $4,694.70
10‐100‐450186 Animal Boarding Fees $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
10‐100‐450190 Taxi Permits $0.00 $52.00 $0.00 $52.00 $52.00 $52.00
10‐100‐450230 Vacating Right Of Way $800.00 $532.00 $431.20 $963.20 $163.20 $163.20
10‐100‐450250 Rezoning Request $10,000.00 $2,884.00 $4,923.65 $7,807.65 ($2,192.35)($2,192.35)
10‐100‐450255 Planning & Zoning Review Fees $8,000.00 $3,804.00 $3,464.79 $7,268.79 ($731.21)($731.21)
10‐100‐450260 Non‐refundable Plans/spec $1,800.00 $1,013.00 $1,015.63 $2,028.63 $228.63 $228.63
$800,700.00 $424,555.66 $519,465.43 $944,021.09 $143,321.09 $143,321.09
Fines & Forfeitures
10‐100‐460010 Court Cost $73,000.00 $30,046.35 $41,122.80 $71,169.15 ($1,830.85)($1,830.85)
10‐100‐460015 Court Restitutions $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
10‐100‐460018 Inmate Security Fund $12,500.00 $4,980.41 $7,100.57 $12,080.98 ($419.02)($419.02)
10‐100‐460020 Jail Cost Recovery $2,000.00 $694.92 $971.91 $1,666.83 ($333.17)($333.17)
10‐100‐460025 Alcohol Offense Cost Rec $7,500.00 $1,600.41 $3,718.42 $5,318.83 ($2,181.17)($2,181.17)
10‐100‐460030 Pol Fines‐traffic $750,000.00 $262,464.97 $425,387.74 $687,852.71 ($62,147.29)($62,147.29)
10‐100‐460090 Parking Fines $53,000.00 $43,755.69 $31,966.04 $75,721.73 $22,721.73 $22,721.73
10‐100‐460100 Bankcard Charges ($3,900.00)($912.17)($2,501.80)($3,413.97)$486.03 $486.03
$894,100.00 $342,630.58 $507,765.69 $850,396.27 ($43,703.73)($43,703.73)
Contributions/Donations
10‐100‐480055 JC Fire Museum $0.00 $1,546.00 $0.00 $1,546.00 $1,546.00 $1,546.00
10‐100‐480070 Community Projects Donations $350.00 $850.00 $0.00 $850.00 $500.00 $500.00
10‐100‐480080 Dare Donations $0.00 $500.00 $0.00 $500.00 $500.00 $500.00
10‐100‐480090 Police K‐9 Donations $500.00 $500.00 $0.00 $500.00 $0.00 $0.00
10‐100‐480165 Animal S Donations $0.00 $11,524.00 $0.00 $11,524.00 $11,524.00 $11,524.00
10‐100‐481055 Street Repair‐Solid Waste Cntr $312,862.50 $103,000.00 $209,862.50 $312,862.50 $0.00 $0.00
10‐100‐481095 Cemetery Donations $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$313,712.50 $117,920.00 $209,862.50 $327,782.50 $14,070.00 $14,070.00
Other Operating Revenues
10‐100‐480011 Police Evidence Funds $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
10‐100‐481070 Miscellaneous $36,000.00 $13,727.55 $19,286.81 $33,014.36 ($2,985.64)($2,985.64)
10‐100‐481072 TIF Prof Svcs Deposit $0.00 $2,306.25 $0.00 $2,306.25 $2,306.25 $2,306.25
10‐100‐481074 Revenue Share ‐ Purchasing Card $18,000.00 $6,379.04 $12,574.67 $18,953.71 $953.71 $953.71
10‐100‐481077 Insurance Claims $20,000.00 $2,577.31 $17,029.40 $19,606.71 ($393.29)($393.29)
10‐100‐481078 Cafeteria Refunds $10,000.00 $0.00 $10,000.00 $10,000.00 $0.00 $0.00
$84,000.00 $24,990.15 $58,890.88 $83,881.03 ($118.97)($118.97)
Interest Income
10‐100‐470010 Interest $121,062.39 $55,679.78 $85,518.20 $141,197.98 $20,135.59 $20,135.59
$121,062.39 $55,679.78 $85,518.20 $141,197.98 $20,135.59 $20,135.59
Other Non Operating Revenue
10‐100‐485050 Sale Of Assets $45,000.00 $31,343.40 $30,000.00 $61,343.40 $16,343.40 $16,343.40
$45,000.00 $31,343.40 $30,000.00 $61,343.40 $16,343.40 $16,343.40
Operating Transfers In
10‐100‐490240 Trsfr From Lodging Tax $24,024.00 $7,153.10 $17,095.53 $24,248.63 $224.63 $224.63
10‐100‐490630 Transfer from Self Funded Hlth Ins $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$24,024.00 $7,153.10 $17,095.53 $24,248.63 $224.63 $224.63
$32,105,801.08 $16,393,712.39 $16,031,372.43 $32,425,084.82 $319,283.74 $319,283.74
CITY OF JEFFERSON
FISCAL YEAR 2018 ESTIMATED FUND BALANCE
FYE2017 UNASSIGNED FUND BALANCE (Audited)9,231,503.12$
FYE2017 Estimated Fund Balance % of Adopted Budget 28.65%
Reappropriations from FY2017 to FY2018
Port Feasibility Study (47,600.00)$
Stormwater repairs and improvements (750,000.00)$
Legal fees for Mo American Water Tariff Case (14,055.15)$
Downtown Streetscape Repair & Electric Project (637,800.00)$
New Fire Station #2 (1,221,035.00)$
Fire Dept building grounds & maintenance for Fire Station #2 (106,785.00)$
Computer Software for PPS (34,800.00)$
Ongoing Infrastructure/Facility Needs (276,715.20)$
Remaining NSP Program Income (47,097.38)$
Public Art (6,740.00)$
CAMPO Grant ‐ City share of $150,000 contract (4,500.00)$
(3,147,127.73)$
2018 Adjustments/Supplementals
FY2018 Supplemental Appropriations:
LCRA Reimbursement (gap financing for Capitol Ave properties) (259,000.00)$
Workers Compensation (300,000.00)$
Purchase of 1 Dump Truck (145,000.00)$
(704,000.00)$
FYE2018 ESTIMATED Unassigned Fund Balance 5,380,375.39$
FYE2018 ESTIMATED Fund Balance % of Adopted Budget 16.58%
Tax Period
Due Date to
City Total Lodging Tax JCCVB (3/7)
JCCVB/Tourism Fund
(4/7)**
May-11 6/20/11 91,258.41 38,328.53 51,104.71
Jun-11 7/20/11 101,479.82 42,621.54 56,828.68
Jul-11 8/20/11 88,392.47 37,124.82 49,499.80
Aug-11 9/20/11 73,144.02 30,720.48 40,960.66
Sep-11 10/20/11 103,618.61 43,519.80 58,026.44
Oct-11 11/20/11 105,531.99 44,323.44 59,097.91
Nov-11 12/20/11 66,556.88 27,953.89 37,271.85
Dec-11 1/20/12 52,204.97 21,926.07 29,234.80
Jan-12 2/20/12 65,645.72 27,571.20 36,761.61
566.37 Interest Received
Feb-12 3/20/12 85,143.89 35,760.45 47,680.56
383.96 4/2012 Interest Received
Mar-12 4/20/12 81,904.23 34,399.77 45,866.38
636.05 5/2012 Interest Received
(8.11) 5/2012 Service Charge
Apr-12 5/20/12 103,406.71 43,430.82 57,907.76
685.97 6/2012 Interest Received
(7.25) 6/2012 Service Charge
May-12 6/20/12 89,713.24 37,679.58 50,239.40
785.01 7/2012 Interest Received
(7.25) 7/2012 Service Charge
Jun-12 7/20/12 86,753.72 36,436.56 48,582.08
832.99 8/2012 Interest Received
(7.25) 8/2012 Service Charge
Jul-12 8/20/12 89,904.69 37,759.97 50,346.63
Aug-12 9/20/12 76,708.71 32,217.66 42,956.88
887.55 9/2012 Interest Received
(7.25) 9/2012 Service Charge
987.59 10/2012 Interest Received
(7.50) 10/2012 Service Charge
Sep-12 10/20/12 109,335.16 45,920.77 61,227.69
1,011.18 11/2012 Interest Received
(7.00) 11/2012 Service Charge
Oct-12 11/20/12 109,059.34 45,804.92 61,073.23
45,804.92 JCCVB 3/7 Check Deposited in Error
1,166.54 12/2012 Interest Received
(7.50) 12/2012 Service Charge
Nov-12 12/20/12 69,756.75 29,297.84 39,063.77
(45,804.92) Correction of Deposit Error
1,185.18 1/2013 Interest Received
(7.33) 1/2013 Service Charge
Dec-12 1/20/13 55,126.67 23,153.20 30,870.94
1,108.23 2/2013 Interest Received
(7.35) 2/2013 Service Charge
Jan-13 2/20/13 84,295.92 35,404.29 47,205.71
1,271.02 3/2013 Interest Received
(8.28) 3/2013 Service Charge
Feb-13 3/20/13 84,199.16 35,363.65 47,151.53
1,297.26 4/2013 Interest Received
(8.28) 4/2013 Service Charge
Mar-13 4/20/13 98,008.06 41,163.39 54,884.51
1,413.79 5/2013 Interest Received
(7.37) 5/2013 Service Charge
Apr-13 5/20/13 100,022.48 42,009.44 56,012.59
Tax Period
Due Date to
City Total Lodging Tax JCCVB (3/7)
JCCVB/Tourism Fund
(4/7)**
1,450.30 6/2013 Interest Received
(8.56) 6/2013 Service Charge
(10,000.00) Ck #50 - C H Johnson Consulting
May-13 6/20/13 97,602.44 40,993.02 54,657.37
1,570.41 7/2013 Interest Received
(8.45) 7/2013 Service Charge
(1,187.09) Ck #1001 - C H Johnson Consulting
Jun-13 7/20/13 92,796.57 38,974.56 51,966.08
1,620.41 8/2013 Interest Received
(8.45) 8/2013 Service Charge
(33.25) Ck #1002 - City of Jefferson - RFP Ad
(15,000.00) Ck #1003 - C H Johnson Consulting
(10,000.00) Ck #1004 - C H Johnson Consulting
Jul-13 8/20/13 93,352.06 39,207.87 52,277.15
1,606.48 9/2013 Interest Received
(8.79) 9/2013 Service Charge
(5,000.00) Ck #1005 - C H Johnson Consulting
Aug-13 9/20/13 89,778.97 37,707.17 50,276.22
1,726.08 10/2013 Interest Received
(8.45) 10/2013 Service Charge
(3,000.00) Ck #1006 - C H Johnson Consulting
Sep-13 10/20/13 108,879.17 45,729.25 60,972.34
1,728.36 11/2013 Interest Received
(8.45) 11/2013 Service Charge
Oct-13 11/20/13 120,248.83 50,504.51 67,339.34
1,864.47 12/2013 Interest Received
(8.28) 12/2013 Service Charge
Nov-13 12/20/13 84,253.54 35,386.49 47,181.98
1,918.75 1/2014 Interest Received
(8.28) 1/2014 Service Charge
Dec-13 1/20/14 63,745.74 26,773.21 35,697.61
1,807.90 2/2014 Interest Received
(8.28) 2/2014 Service Charge
Jan-14 2/20/14 92,051.62 38,661.68 51,548.91
(1,562.61) Ck #1007 - C H Johnson Consulting
2,078.72 3/2014 Interest Received
(8.45) 3/2014 Service Charge
Feb-14 3/20/14 80,825.68 33,946.79 45,262.38
2,052.68 4/2014 Interest Received
(8.28) 4/2014 Service Charge
Mar-14 4/30/14 106,553.94 44,752.65 59,670.21
2,198.76 5/2014 Interest Received
(8.29) 5/2014 Service Charge
Apr-14 5/20/14 104,278.69 43,797.05 58,396.07
2,203.13 6/2014 Interest Received
(8.29) 6/2014 Service Charge
May-14 6/20/14 116,059.44 48,744.96 64,993.29
2,391.04 7/2014 Interest Received
(8.29) 7/2014 Service Charge
Jun-14 7/20/14 104,333.69 43,820.15 58,426.87
2,457.38 8/2014 Interest Received
(8.29) 8/2014 Service Charge
Jul-14 8/20/14 98,901.39 41,538.58 55,384.78
2,459.73 9/2014 Interest Received
Tax Period
Due Date to
City Total Lodging Tax JCCVB (3/7)
JCCVB/Tourism Fund
(4/7)**
(8.29) 9/2014 Service Charge
Aug-14 9/20/14 75,962.88 31,904.41 42,539.21
2,593.43 10/2014 Interest Received
(8.29) 10/2014 Service Charge
Sep-14 10/20/14 112,370.02 47,195.41 62,927.21
2,586.87 11/2014 Interest Received
(8.29) 11/2014 Service Charge
Oct-14 11/20/14 116,992.89 49,137.01 65,516.02
2,736.57 12/2014 Interest Received
(14.65) 12/2014 Service Charge
Nov-14 12/20/14 72,761.33 30,559.76 40,746.34
2,798.53 1/2015 Interest Received
(8.29) 1/2015 Service Charge
Dec-14 1/20/15 60,394.73 25,365.79 33,821.05
2,575.56 2/2015 Interest Received
(8.29) 2/2015 Service Charge
Jan-15 2/20/15 85,741.83 36,011.57 48,015.42
2,935.34 3/2015 Interest Received
(8.29) 3/2015 Service Charge
Feb-15 3/20/15 84,317.61 35,413.40 47,217.86
2,911.14 4/2015 Interest Received
(10.54) 4/2015 Service Charge
Mar-15 4/20/15 114,789.97 48,211.79 64,282.38
3,049.41 5/2015 Interest Received
(8.29) 5/2015 Service Charge
Apr-15 5/20/15 102,479.43 43,041.36 57,388.48
3,046.67 6/2015 Interest Received
(8.29) 6/2015 Service Charge
May-15 6/20/15 116,174.48 48,793.28 65,057.71
3,217.49 7/2015 Interest Received
(8.29) 7/2015 Service Charge
Jun-15 7/31/15 97,379.11 40,899.23 54,532.30
3,287.90 8/2015 Interest Received
(10.67) 8/2015 Service Charge
Jul-15 8/20/15 102,541.78 43,067.55 57,423.40
3,307.41 9/2015 Interest Received
(8.58) 9/2015 Service Charge
Aug-15 9/20/15 81,248.87 34,124.53 45,499.37
3,476.74 10/2015 Interest Received
(8.29) 10/2015 Service Charge
Sep-15 10/20/15 102,709.81 43,138.12 57,517.49
3,421.47 11/2015 Interest Received
(8.00) 11/2015 Service Charge
Oct-15 12/1/15 107,837.70 45,291.83 60,389.11
3,605.14 12/2015 Interest Received
(8.29) 12/2015 Service Charge
Nov-15 12/31/15 67,119.58 28,190.22 37,586.96
Sep-15 1,908.92 801.75 1,069.00 late pays
3,666.35 1/2016 Interest Received
(8.29) 1/2016 Service Charge
Dec-15 1/31/16 66,959.22 28,122.88 37,497.16
3,478.72 2/2016 Interest Received
(8.49) 2/2016 Service Charge
Jan-16 2/20/16 83,239.99 34,960.80 46,614.39
Tax Period
Due Date to
City Total Lodging Tax JCCVB (3/7)
JCCVB/Tourism Fund
(4/7)**
3,786.20 3/2016 Interest Received
(8.28) 3/2016 Service Charge
Feb-16 3/20/16 97,559.96 40,975.18 54,633.58
3,718.19 4/2016 Interest Received
(8.27) 4/2016 Service Charge
Mar-16 4/29/16 101,134.20 42,476.36 56,635.16
3,914.86 5/2016 Interest Received
(8.26) 5/2016 Service Charge
Apr-16 5/20/16 140,992.87 59,217.01 78,956.01
3,905.43 6/2016 Interest Received
May-16 6/20/16 112,152.91 47,104.22 62,805.63
3,985.42 7/2016 Interest Received
Jun-16 7/31/16 106,704.37 44,815.83 59,754.44
4,207.43 8/2016 Interest Received
Jul-16 8/20/16 96,811.40 40,660.79 54,214.38
4,136.69 9/2016 Interest Received
Aug-16 9/20/16 88,674.86 37,243.44 49,657.92
4,350.78 10/2016 Interest Received
Sep-16 10/31/16 100,606.10 42,254.56 56,339.42
4,292.30 11/2016 Interest Received
Oct-16 11/20/16 120,471.15 50,597.88 67,463.85
4,531.06 12/2016 Interest Received
Nov-16 12/20/16 88,755.07 37,277.13 49,702.83
4,602.85 1/2017 Interest Received
Dec-16 1/31/17 65,709.30 27,597.91 36,797.21
4,207.06 2/2017 Interest Received
Jan-17 2/20/17 95,905.35 40,280.25 53,706.99
4,726.10 3/2017 Interest Received
Feb-17 3/31/17 95,135.98 39,957.11 53,276.15
4,651.72 4/2017 Interest Received
Mar-17 4/30/17 111,370.63 46,775.67 62,367.55
4,885.76 5/2017 Interest Received
Apr-17 5/30/17 109,652.93 46,054.23 61,405.64
4,807.94 6/2017 Interest Received
May-17 6/30/17 123,148.39 51,722.32 68,963.10
5,089.00 7/2017 Interest Received
Jun-17 7/31/17 120,310.25 50,530.30 67,373.74
5,141.00 8/2017 Interest Received
Jul-17 8/20/17 101,096.32 42,460.45 56,613.94
5,081.97 9/2017 Interest Received
Aug-17 9/30/17 99,136.13 41,637.18 55,516.23
5,325.63 10/2017 Interest Received
Sep-17 10/31/17 112,835.87 47,391.06 63,188.09
5,243.98 11/2017 Interest Received
Oct-17 11/20/17 118,132.32 49,615.57 66,154.10
5,519.00 12/2017 Interest Received
Nov-17 12/20/17 84,414.19 35,453.96 47,271.95
5,565.66 1/2018 interest Received
Dec-17 1/31/18 64,644.90 27,150.86 36,201.14
5,076.25 2/2018 interest Received
Jan-18 2/20/18 90,463.34 37,994.60 50,659.47
5,710.59 3/2018 interest Received
Feb-18 3/31/18 72,376.53 30,398.14 40,530.86
5,580.76 4/2018 interest Received
Tax Period
Due Date to
City Total Lodging Tax JCCVB (3/7)
JCCVB/Tourism Fund
(4/7)**
Mar-18 4/30/18 128,168.74 53,830.87 71,774.50
Total 7,824,127.60 3,286,133.59 4,555,411.35
average monthly amount for 4 cent lockbox fund 52,160.85$
**Effective for 25 years starting in 2011
2018 Occupancy 2017 Occupancy 2016 Occupancy 2015 Occupancy 2014 Occupancy 2013 Occupancy 2012 Occupancy
January 48.10%48.70%51.30%45.90%49.20%45.30%38.20%
February 53.40%56.80%58.60%51.20%56.00%52.90%49.80%
March 57.60%62.20%59.80%59.80%59.30%52.90%54.90%
April 61.70%62.40%67.20%58.10%63.70%64.10%53.90%
May 63.80%64.90%63.10%64.70%56.80%53.70%
June 70.40%64.00%59.70%63.70%55.70%53.10%
July 65.90%58.20%60.80%59.70%58.50%51.40%
August 61.50%56.50%52.60%54.20%55.80%47.00%
September 64.50%62.60%63.30%61.20%63.00%59.30%
October 66.50%62.90%60.70%67.60%65.90%59.30%
November 51.50%50.60%51.30%48.90%52.40%43.40%
December 40.80%42.10%45.10%38.30%38.80%33.00%
COMPARATIVE OCCUPANCY RATE
Tab 2 - Multi-Segment Currency: USD - US Dollar
Missouri Hotel & Lodging Association
For the month of: April 2018
Percent Change from April 2017 Percent Change from YTD 2017
2018 2017 2018 2017 2018 2017 Occ ADR RevPAR
Room
Rev
Room
Avail
Room
Sold 2018 2017 2018 2017 2018 2017 Occ ADR RevPAR
Room
Rev
Room
Avail
Room
Sold Census Sample Census Sample
United States 67.9 67.3 130.33 126.20 88.54 84.96 0.9 3.3 4.2 6.4 2.1 3.0 63.2 62.6 128.19 124.78 81.00 78.12 0.9 2.7 3.7 5.8 2.0 3.0 54625 33560 5190660 3895338
West North Central 56.2 56.5 95.80 94.50 53.80 53.40 -0.6 1.4 0.8 2.9 2.1 1.5 50.9 51.6 95.56 92.71 48.66 47.80 -1.3 3.1 1.8 4.0 2.2 0.9 4594 2797 362593 269628
Missouri 59.6 61.6 99.85 99.18 59.53 61.09 -3.2 0.7 -2.6 -0.4 2.2 -1.1 53.5 55.3 95.55 94.99 51.10 52.53 -3.3 0.6 -2.7 -0.7 2.1 -1.2 1133 668 103476 75376
Kansas City, MO-KS 64.2 68.2 106.41 103.62 68.32 70.68 -5.9 2.7 -3.3 -0.5 2.9 -3.2 58.0 61.6 101.99 100.21 59.18 61.74 -5.8 1.8 -4.1 -2.1 2.1 -3.8 299 241 32937 28819
St Louis, MO-IL 65.8 68.9 107.00 107.71 70.38 74.25 -4.6 -0.7 -5.2 -4.3 1.0 -3.6 60.2 61.3 100.09 100.91 60.26 61.89 -1.8 -0.8 -2.6 -1.1 1.5 -0.3 334 257 38953 34089
Columbia, MO+60.1 64.0 90.39 88.80 54.36 56.85 -6.1 1.8 -4.4 0.2 4.8 -1.6 51.8 57.1 87.31 85.39 45.25 48.76 -9.2 2.3 -7.2 -2.7 4.8 -4.9 39 31 3886 3258
Jefferson City, MO+61.7 62.4 83.12 80.20 51.31 50.07 -1.1 3.6 2.5 2.5 0.0 -1.1 55.2 58.8 81.52 79.81 44.97 46.91 -6.1 2.1 -4.1 -4.1 0.0 -6.1 15 12 1494 1140
Springfield, MO 67.4 64.3 87.92 83.36 59.28 53.63 4.8 5.5 10.5 14.1 3.3 8.2 60.8 56.5 82.98 80.59 50.47 45.52 7.7 3.0 10.9 13.4 2.3 10.2 70 48 6287 4667
Branson, MO 40.8 45.9 94.12 89.02 38.39 40.89 -11.2 5.7 -6.1 -5.7 0.4 -10.8 35.7 38.6 95.34 90.85 34.08 35.06 -7.4 4.9 -2.8 -2.1 0.7 -6.7 148 34 13451 4488
Lake of the Ozarks+47.8 45.7 96.81 97.06 46.28 44.35 4.6 -0.3 4.4 2.0 -2.2 2.3 37.1 40.6 92.14 90.79 34.15 36.87 -8.7 1.5 -7.4 -9.5 -2.3 -10.9 36 11 2712 1544
Joplin, MO 55.5 60.8 80.32 78.45 44.59 47.74 -8.8 2.4 -6.6 -2.0 4.9 -4.3 53.3 57.5 81.53 78.43 43.42 45.10 -7.4 4.0 -3.7 1.0 4.9 -2.8 32 24 2446 2124
Saint Joseph, MO+59.5 60.5 85.18 85.74 50.72 51.83 -1.5 -0.7 -2.1 7.4 9.8 8.1 52.8 55.0 86.37 86.03 45.64 47.34 -4.0 0.4 -3.6 5.8 9.8 5.4 13 10 1214 1056
Independence, MO+56.6 63.3 84.79 82.12 48.01 51.97 -10.5 3.3 -7.6 -2.3 5.8 -5.4 50.3 54.7 78.99 80.25 39.73 43.87 -8.0 -1.6 -9.4 -4.2 5.8 -2.7 21 14 1631 1392
A blank row indicates insufficient data.
Participation
Occ %
Current Month - April 2018 vs April 2017
The STR Destination Report is a publication of STR, Inc. and STR Global, Ltd., and is intended solely for use by paid subscribers. Reproduction or distribution of the STR Destination Report, in whole or part, without written permission is prohibited and subject to legal action. If you have received this report and are NOT a subscriber to the STR Destination Report, please contact us
immediately. Source: 2018 STR, Inc. / STR Global, Ltd. trading as "STR".
RevPARADROcc %
Year to Date - April 2018 vs April 2017
RoomsRevPARPropertiesADR
Tab 3 - Help
Glossary:
Frequently Asked Questions (FAQ):
North America:International:
735 East Main Street, Hendersonville, TN 37075 USA Blue Fin Building, 110 Southwark Street, London SE1 0TA
T : +1 615 824 8664 T : +44 (0) 20 7922 1930
industryinfo@str.com
Asia Pacific:
Thong Teck Building, 15 Scotts Road #08-12, 228 218 Singapore
T: +64 6800 7850
For all STR FAQs, please click here or visit www.str.com/resources/faq
For the latest in industry news, visit HotelNewsNow.com.
destininfo@str.com
For all STR definitions, please visit www.str.com/resources/glossary
To learn more about the Hotel Data Conference, visit HotelDataConference.com.
apinfo@str.com
Please visit our website at www.str.com, or if you need additional assistance please reach out to our Customer Support team.
MEMORANDUM
TO: Finance Committee
FROM: Ryan Moehlman, City Counselor
DATE: May 21, 2018
RE: Municipal Court Project Completion Funding
Summary
City Staff is recommending an appropriation of $75,000 from the Fire Station 2 project account in
order to complete the Municipal Court renovation project at the City Hall Annex Building at 427
Monroe.
Details
On April 23, 2018, the City opened bids from contractors for the renovation of the top floor of the
City Hall Annex Building at 427 Monroe into a new Municipal Court facility. The apparent lowest
bidder was GBH Builders with base bid of $489,500 (when adding all bid alternates, GBH Builder
continued to be apparent low bidder at $549,035).
A feasibility study conducted by The Architect’s Alliance placed estimated construction costs at
$326,329 to $438,654. As such, actual bids came in at least 12% higher than estimated.
After receiving bids, City staff reviewed and selected recommendations for bid alternates (discussed
below) for a total bid cost of $527,975. Because bids came in higher than expected, The Architects
Alliance worked with GBH Builders to identify options in the construction program where costs
could be reduced. City staff reviewed these options (also discussed below), and selected
recommendations for a few items to reduce costs. However, during such review, staff realized that
the total allowance for security door installations of $5,000 is likely under what actual costs would
be, requiring an addition of $10,000. Currently, based on staff recommendations regarding bid
alternates and cost-savings options, total construction costs stand at $527,867.
Additional project costs will be for fixtures, furnishings, and equipment (FFE) in the estimated
amount of $30,000 (the bulk of this amount being row-type seating for approximately 120 seats in
the courtroom) for a project completion cost of $557,867.
The City Council has previously funded the Municipal Court project (which includes various
components related to the upkeep and modernization of the building itself in addition to the base
Municipal Court renovation project) in the amount of $525,000 out of remaining Sales Tax F funds.
Out of that $525,000 the City has already committed or expended $62,467 for a feasibility study,
design services, and bid advertising, leaving $462,533 available for project completion. This leaves
a funding shortfall of $95,334. Unless directed otherwise, City staff will pay for Bid Alternate 3,
consisting of installation of switching equipment to support a portable generator at $21,740, from the
Fire Department Building and Grounds Fund as such equipment will primarily function to allow the
Fire Administration offices to remain active and operational during a loss-of-power emergency
situation. This leaves $73,594 needing to be funded to allow for project completion. As such, City
staff is requesting an appropriation of $75,000 to allow for project completion. Staff believes an
appropriate place for this funding is from the Fire Station 2 project account, as bids for that project
have come in significantly under bid.
Discussion of Bid Alternates
• Bid Alternate 1 – Exterior Building and Repairs ($13,125). This work would consist of
painting, caulking and other deferred maintenance of the exterior of the Annex Building. This
alternate was not recommended simply because of current budget constraints; the work is not
critical at this time, but will need to be addressed in the future to maintain the long-term
investment and viability of the Annex Building.
• Bid Alternate 2 – New Exterior Door at Administration ($16,735). This work consists of
installing an exterior door, with appropriate stairs and landing, on the north side of the
building which will allow for direct ingress and egress from the Municipal Court
administration staff area. This door would allow staff to direct exit the building without
entering any public area in the case of an emergency and was selected for its significant
enhancement of staff security.
• Bid Alternate 3 - Portable Electric Generator. ($21,740). This work would allow fire staff
to hookup a currently-owned portable generator to the building’s electrical system to allow
continued operations of Fire Administration in the case of power loss on a more flexible and
effective basis and was selected to enhance continuity of government during emergencies.
• Bid Alternate 4 - Acoustical Floor Underlayment ($3,310). This work would help reduce
noise in the lower level due to top floor activity. It was not recommended because concerns
of effectiveness in significantly reducing noise.
• Bid Alternate 5 - Insulation Above Lower Level Ceiling ($4,625). This work would also
help reduce noise in the lower level due to top floor activity in an alternate matter. It was
also not recommended because concerns of effectiveness in significantly reducing noise.
Detailed Discussion of Cost Saving Options
Recommended
• Forgo all wood paneling and replace with accent paint color. (-$7,863.73). This detail
was included in initial plans to add visual interest and create visual focal point at the front the
courtroom.
• Delete casework at Office 115/Judge’s Chambers (-$1,534.70). These were build-in
cabinetry/desk for the judge’s chambers. Staff believes this can be handled more affordably
as part of FFE expense.
• Delete casework at Administration workstation (-$757.05). This space was designed as a
non-transaction work area for Court staff and/or a made-ready area for potential staff
expansion. This work area is not immediately needed and can serve as a flexible work space
for court staff even if not furnished with built-in casework.
Not recommended
• Eliminate new restrooms from scope, existing single occupant restrooms to remain with
no changes. (-$44,336.00). This option would leave the existing bathrooms as is, as opposed
to remodeling the two current single-occupant baths into two double-occupant bathrooms.
This option is not recommended because during court days, the top floor will be occupied by
large number of people and it is not believed that two single-occupant bathrooms would be
sufficient.
• Sealed concrete flooring in courtroom instead of carpet tiles (-$15,767.13). This would
forgo carpet in the courtroom and finish the existing concrete floors. This is not
recommended because of the likely un-uniform appearance and because of substantial
concern regarding the negative acoustical effect of concrete floors on in-courtroom
communications between the court, defendants, and counsel.
• Building permit fee (-2,369.00). The City Council has the ability to waive a building permit
fee for a City project. This is not recommended because it is best practice to charge internal
projects to capture and track all relevant project costs.
• Eliminate bullet resistant material from walls, replace bullet resistant transaction
windows and doors with standard transaction window (-$13,935.90) or Reduce height of
bullet resistant material to 5 ft. (-$3,100.30). These options are not recommended as
comprehensive bullet resistant transactions areas are a key component of employee safety.
• Reduce tile wainscoting to 4 ft. high on wall behind plumbing fixtures. At all other RR
walls remove tile wainscoting and cement board backing and replace with painted
gypsum board (-$7,863.73) and Replace epoxy flooring at RR with sealed concrete
(-$5,322.01). These options are not recommended as tile wainscoting and epoxy flooring will
greatly assist in cleanup and maintenance of what are anticipated to a highly-trafficked public
restrooms and add to the useful life of the restrooms.
• Electrical - Delete new light fixtures in their entirety. Re-use existing fixtures as
designated by project engineer (-$8,549.00). This option is not recommended as new
fixtures are highly-energy efficient LEDs and additional design cost/time would be likely be
needed to design a plan to re-use existing lighting fixtures, reducing cost saving potential.
• Delete built-in casework at Manager workstation, break area, work area, and security
area (-$8,626.25). This was not recommended as these were designed with specific work-
functions and tasks in mind and these areas would still need to be furnished through an
expanded FFE budget with more generic solutions. Actual potential cost saving are unknown
and could minimal.
Proposed FY2019 Budget Calendar
Late March 2018 Finance Department Finance provides Dept. Directors budget working documents
April 27, 2018 Dept. Directors Dept. Directors submit budget working document and pink sheet summaries to Finance
Late Apr/Early May 2018 Finance Department Revenue discussion between Finance Director and City Administrator
May 15, 2018 Finance Department Finance submits compiled budget working documents & pink sheet summaries to City Administrator
May 16 - 28, 2018 City Administrator City Administrator develops budget - meets with Department Directors
May 18 - June 1, 2018 Dept. Directors Departments prepare performance measure information based on data as of 4/30/18
May 28 - June 4, 2018 C.A./Dept. Directors City Administrator shares budget with departments makes any final changes
June 5 - 12, 2018 Finance Department Finance creates City Administrator budget for presentation to the Mayor
June 12 - July 9, 2018 Mayor Mayor reviews C.A. budget and meets with C.A. to develop "Mayor" budget
July 10 - July 23, 2018 Finance Department Finance prepares the Mayor's Budget document for presentation to budget committee
Monday July 23, 2018 Budget Committee Mayor presents budget to budget committee. Discussion of revenues.
Thursday July 26, 2018 Budget Committee Budget highlights. Five Year Financial Plan.
Monday July 30, 2018 Budget Committee Departments make presentations to budget committee (Administration, Police and Fire)
Thursday August 2, 2018 Budget Committee Departments make presentations to budget committee (PPS, PW, WW, Transit, and Parking)
Monday August 6, 2018 Council Meeting Budget bill introduced. Property tax bill introduced. GRUT bill introduced.
Thursday August 9, 2018 Budget Committee Departments make presentations to budget committee (Parks and miscellaneous funds)
Monday August 13, 2018 Budget Committee Committee discussion on budget
Thursday August 16, 2018 Budget Committee Committee discussion on budget
Monday August 20, 2018 Council Meeting Public Hearing and vote on Property Tax Levy and Gross Receipts Utility Tax (GRUT) bills
Public Hearing on Budget Bill then Budget Bill to the informal calendar
Thursday August 23, 2018 Budget Committee Committee discussion on budget. If committee finalizes a budget it can be voted on at 9/4 mtg.
Monday August 27, 2018 Budget Committee Committee discussion on budget. If committee finalizes a budget it can be voted on at 9/4 mtg.
Thursday August 30, 2018 Budget Committee Committee discussion on budget. If committee finalizes a budget it can be voted on at 9/4 mtg.
Tuesday September 4, 2018 Budget Committee Budget bill vote if committee has passed the budget onto the Council
Thursday September 6, 2018 Budget Committee Committee discussion on budget. If committee finalizes a budget it can be voted on at 9/17 mtg.
Monday September 10, 2018 Budget Committee Committee discussion on budget. If committee finalizes a budget it can be voted on at 9/17 mtg.
Thursday September 13, 2018 Budget Committee Committee discussion on budget. If committee finalizes a budget it can be voted on at 9/17 mtg.
Monday September 17, 2018 Council Meeting Budget bill vote if committee has passed the budget onto the Council
Thursday September 20, 2018 Budget Committee * See Note Below
Monday October 22, 2018 Council Meeting Final Scheduled Council Meeting before October 31 Budget Approval Deadline
Budget committee meetings will be 5:30 to 7:30 in council chambers.
*Committee can continue the Monday/Thursday schedule until the budget is approved at committee and forwarded to the council as a whole for vote.
Proposed FY2019 Budget Calendar