HomeMy Public PortalAbout2017-12-14 NO meeting packet REVISEDMemo
To:Steve Crowell
From:Shiela Pearre
Date:December 7, 2017
Re:Sales Tax Revenues
The City received the December 1% Sales Tax in the amount of $1,333,160 which is $234,427 more
than projected for December. January thru December overage is $4,678 (0.04%) in the General Fund.
1% General Sales Tax
Receipt Actual Budget
Period Receipts Projection1 Variance
Nov-16 Jan-17 $1,083,570 $924,504 $159,066
Dec-16 Feb-17 $806,789 $823,770 ($16,981)
Jan-17 & Oct-Dec 16 Qtrly Mar-17 $1,073,842 $1,129,724 ($55,882)
Feb-17 Apr-17 $843,561 $951,232 ($107,670)
Mar-17 May-17 $687,741 $731,839 ($44,098)
Apr-17 & Jan-Mar 17 Qtrly Jun-17 $1,000,942 $1,071,788 ($70,847)
May-17 Jul-17 $1,154,051 $1,069,247 $84,804
Jun-17 Aug-17 $678,636 $650,040 $28,597
Jul-17 & Apr-June 17 Qtrly Sep-17 $1,143,504 $1,195,077 ($51,574)
Aug-17 Oct-17 $883,215 $969,353 ($86,138)
Sep-17 Nov-17 $615,667 $684,693 ($69,026)
Oct-17 & Jul-Sept 17 Qtrly Dec-17 $1,333,160 $1,098,734 $234,427
Total Overage/Shortfall $11,300,000 $4,678
1Budgeted based on 3-year average percentage
1/2% Capital Improvement Tax - Sales Tax F & G combined
Receipt Actual Budget
Period Receipts Projection2 Variance
Nov-16 Jan-17 $525,521 $396,801 $128,721
Dec-16 Feb-17 $402,964 $353,565 $49,399
Jan-17 & Oct-Dec 16 Qtrly Mar-17 $506,597 $484,882 $21,715
Feb-17 Apr-17 $411,020 $408,272 $2,748
Mar-17 May-17 $340,162 $314,108 $26,054
Apr-17 & Jan-Mar 17 Qtrly Jun-17 $489,008 $460,015 $28,993
May-17 Jul-17 $559,119 $458,924 $100,195
Jun-17 Aug-17 $338,618 $278,999 $59,618
Jul-17 & Apr-June 17 Qtrly Sep-17 $542,457 $512,931 $29,525
Aug-17 Oct-17 $425,493 $416,050 $9,443
Sep-17 Nov-17 $307,281 $411,938 ($104,657)
Oct-17 & Jul-Sept 17 Qtrly Dec-17 $652,070 $353,515 $298,555
Total Overage/Shortfall $4,850,000 $650,311
2Budgeted based on 3-year average percentage
1/2% Parks Sales Tax
Receipt Actual Budget
Period Receipts Projection3 Variance
Nov-16 Jan-17 $525,521 $415,075 $110,446
Dec-16 Feb-17 $395,217 $369,848 $25,369
Jan-17 & Oct-Dec 16 Qtrly Mar-17 $506,524 $507,213 ($689)
Feb-17 Apr-17 $411,020 $427,075 ($16,055)
Mar-17 May-17 $340,162 $328,574 $11,587
Apr-17 & Jan-Mar 17 Qtrly Jun-17 $489,008 $481,201 $7,807
May-17 Jul-17 $559,115 $480,060 $79,055
Jun-17 Aug-17 $338,470 $291,848 $46,622
Jul-17 & Apr-June 17 Qtrly Sep-17 $542,457 $536,554 $5,903
Aug-17 Oct-17 $425,497 $435,211 ($9,714)
Sep-17 Nov-17 $307,305 $430,909 ($123,604)
Oct-17 & Jul-Sept 17 Qtrly Dec-17 $652,101 $369,796 $282,304
Total Overage/Shortfall $5,073,365 $419,032
3Budgeted based on 3-year average percentage
Period
Reporting
Period
Reporting
Period
Reporting
City of Jefferson, Mo. - Account Analysis
Printed 12/14/2017
Account Name General Fund Sales Tax Receipt Month: DECEMBER 2017
Account Number 10-100-400010 Prior 5 years
Monthly
REPORTING PERIOD RECEIPT PERIOD 2012 2013 2014 2015 2016 2017 Average
Nov January 843,061 764,659 741,056 944,619 929,179 1,083,570 act.844,515
Dec February 619,287 703,181 789,830 727,437 812,670 806,789 act.730,481
Jan & Oct-Dec Qtrly March 992,559 1,008,111 920,599 1,091,021 1,183,675 1,073,842 act.1,039,193
Feb April 852,653 777,424 737,482 1,059,943 893,024 843,561 act.864,105
Mar May 530,069 537,141 802,765 618,854 648,305 687,741 act.627,427
Apr & Jan-Mar Qtrly June 1,028,514 1,023,015 865,930 1,045,933 1,119,566 1,000,942 act.1,016,592
May July 797,785 872,436 1,048,754 963,280 1,012,207 1,154,051 act.938,892
Jun August 557,032 546,351 614,048 562,996 661,518 678,636 act.588,389
Jul & Apr-Jun Qtrly September 1,069,414 1,096,581 996,272 1,185,891 1,197,976 1,143,504 act.1,109,227
Aug October 769,129 717,262 919,035 918,839 903,829 883,215 act.845,619
Sept November 615,421 677,366 651,080 661,849 623,645 615,667 act.645,872
Oct & Jul-Sept Qtrly December 982,684 932,387 1,015,322 1,075,638 1,016,682 1,333,160 act.1,004,542
Actual to Date $ 9,657,608 $ 9,655,913 $ 10,102,175 $ 10,856,302 $ 11,002,277 11,304,678
Estimated to Fiscal Year end (based on averages and on Budgeted amount)0
Total Actual & Estimated $ 11,304,678
Less: Budget 11,300,000
Over (Under) Budget $ 4,678
$ 1,083,570
$ 1,890,359
$ 2,964,201
$ 3,807,762 $ 4,495,504
$ 5,496,445
$ 6,650,496
$ 7,329,132
$ 8,472,636
$ 9,355,851
$ 9,971,518
$ 11,304,678
$ 924,504
$ 1,748,274
$ 2,877,998
$ 3,829,230
$ 4,561,069
$ 5,632,857
$ 6,702,104
$ 7,352,144
$ 8,547,221
$ 9,516,574
$ 10,201,266
$ 11,300,000
$ 0
$ 500,000
$ 1,000,000
$ 1,500,000
$ 2,000,000
$ 2,500,000
$ 3,000,000
$ 3,500,000
$ 4,000,000
$ 4,500,000
$ 5,000,000
$ 5,500,000
$ 6,000,000
$ 6,500,000
$ 7,000,000
$ 7,500,000
$ 8,000,000
$ 8,500,000
$ 9,000,000
$ 9,500,000
$ 10,000,000
$ 10,500,000
$ 11,000,000
$ 11,500,000
$ 12,000,000
Nov Dec Jan & Oct-Dec
Qtrly
Feb Mar Apr & Jan-Mar
Qtrly
May Jun Jul & Apr-Jun
Qtrly
Aug Sept Oct & Jul-Sept
Qtrly
REPORTING PERIOD
YTD Actuals vs. YTD Budget
Actual
Budget
City of Jefferson, Mo. - Account Analysis
Printed 12/14/2017
Account Name Capital Imprs Sales Tax Receipt Month: DECEMBER 2017
Account Number 44-100-400010/45-100-440010 Prior 5 years
Monthly
REPORTING PERIOD RECEIPT PERIOD 2012 2013 2014 2015 2016 2017 Average
Nov January 412,434 372,459 359,800 461,560 455,278 525,521 act.412,306
Dec February 308,567 350,813 394,475 362,597 405,543 402,964 act.364,399
Jan & Oct-Dec Qtrly March 466,856 475,110 423,641 511,685 563,056 506,597 act.488,070
Feb April 409,365 372,340 348,172 512,808 431,353 411,020 act.414,808
Mar May 263,902 266,422 399,863 308,247 322,957 340,162 act.312,278
Apr & Jan-Mar Qtrly June 494,757 483,070 416,943 496,466 539,529 489,008 act.486,153
May July 389,423 425,325 503,869 473,120 498,229 559,119 act.457,993
Jun August 278,231 272,603 306,157 280,733 330,112 338,618 act.293,567
Jul & Apr-Jun Qtrly September 504,307 521,260 484,992 565,296 570,134 542,457 act.529,198
Aug October 367,366 357,619 430,185 442,371 435,416 425,493 act.406,591
Sept November 306,968 323,871 324,697 330,393 310,506 307,281 act.319,287
Oct & Jul-Sept Qtrly December 469,095 443,688 485,136 515,478 494,218 652,070 act.481,523
Actual to Date $ 4,671,272 $ 4,664,580 $ 4,877,931 $ 5,260,753 $ 5,356,330 5,500,311
Estimated to Fiscal Year end (based on averages and on Budgeted amount)0
Total Actual & Estimated $ 5,500,311
Less: Budget 4,850,000
Over (Under) Budget $ 650,311
$ 525,521
$ 928,485
$ 1,435,082
$ 1,846,103
$ 2,186,264
$ 2,675,273
$ 3,234,392
$ 3,573,009
$ 4,115,466
$ 4,540,959
$ 4,848,240
$ 5,500,311
$ 396,801
$ 750,365
$ 1,235,247
$ 1,643,519
$ 1,957,627
$ 2,417,642
$ 2,876,567
$ 3,155,566
$ 3,668,497
$ 4,084,547
$ 4,496,485
$ 4,850,000
$ 100,000
$ 350,000
$ 600,000
$ 850,000
$ 1,100,000
$ 1,350,000
$ 1,600,000
$ 1,850,000
$ 2,100,000
$ 2,350,000
$ 2,600,000
$ 2,850,000
$ 3,100,000
$ 3,350,000
$ 3,600,000
$ 3,850,000
$ 4,100,000
$ 4,350,000
$ 4,600,000
$ 4,850,000
$ 5,100,000
$ 5,350,000
$ 5,600,000
$ 5,850,000
Nov Dec Jan & Oct-
Dec Qtrly
Feb Mar Apr & Jan-
Mar Qtrly
May Jun Jul & Apr-Jun
Qtrly
Aug Sept Oct & Jul-
Sept Qtrly
REPORTING PERIOD
YTD Actuals vs. YTD Budget
Actual
Budget
City of Jefferson, Mo. - Account Analysis
Printed 12/14/2017
Account Name Parks Sales Tax Receipt Month: DECEMBER 2017
Account Number 21-210-400010 Prior 5 years
Monthly
REPORTING PERIOD RECEIPT PERIOD 2012 2013 2014 2015 2016 2017 Average
Nov January 405,730 372,447 359,708 461,472 455,239 525,521 act.410,919
Dec February 308,456 350,714 393,562 362,371 405,543 395,217 act.364,129
Jan & Oct-Dec Qtrly March 466,713 475,026 423,546 511,582 563,039 506,524 act.487,981
Feb April 409,353 372,242 348,076 512,738 431,353 411,020 act.414,752
Mar May 263,822 266,456 398,085 308,030 322,957 340,162 act.311,870
Apr & Jan-Mar Qtrly June 494,733 482,382 416,845 496,386 539,529 489,008 act.485,975
May July 389,006 425,194 503,790 473,038 498,229 559,115 act.457,851
Jun August 278,072 272,321 305,930 280,513 330,112 338,470 act.293,390
Jul & Apr-Jun Qtrly September 505,913 521,155 484,904 565,217 572,847 542,457 act.530,007
Aug October 366,846 357,482 430,093 442,370 435,416 425,497 act.406,441
Sept November 306,831 323,768 324,481 330,393 310,506 307,305 act.319,196
Oct & Jul-Sept Qtrly December 468,924 443,569 484,999 515,368 494,218 652,101 act.481,415
Actual to Date $ 4,664,400 $ 4,662,755 $ 4,874,018 $ 5,259,477 $ 5,358,988 5,492,397
Estimated to Fiscal Year end (based on averages and on Budgeted amount)0
Total Actual & Estimated $ 5,492,397
Less: Budget 5,073,365
Over (Under) Budget $ 419,032
$ 525,521
$ 920,739
$ 1,427,263
$ 1,838,283
$ 2,178,445
$ 2,667,453
$ 3,226,568
$ 3,565,038
$ 4,107,495
$ 4,532,991
$ 4,840,296
$ 5,492,397
$ 415,075
$ 784,923
$ 1,292,136
$ 1,719,211
$ 2,047,785
$ 2,528,986
$ 3,009,046
$ 3,300,895
$ 3,837,449
$ 4,272,660
$ 4,703,569
$ 5,073,365
$ 100,000
$ 350,000
$ 600,000
$ 850,000
$ 1,100,000
$ 1,350,000
$ 1,600,000
$ 1,850,000
$ 2,100,000
$ 2,350,000
$ 2,600,000
$ 2,850,000
$ 3,100,000
$ 3,350,000
$ 3,600,000
$ 3,850,000
$ 4,100,000
$ 4,350,000
$ 4,600,000
$ 4,850,000
$ 5,100,000
$ 5,350,000
$ 5,600,000
$ 5,850,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
Revenue Model Report
For Period Ending October 31, 2017
Data as of December 7, 2017
FY 2017 YTD Actual Projected Over/
Description Budget As of 12/7/17 (Under) Budget
Sales Tax and Use Tax $11,300,000.00 $11,304,677.76 $4,677.76
Intergovernmental Taxes $2,220,000.00 $2,209,423.35 $128,134.45
Other Taxes $116,000.00 $114,223.08 ($1,776.92)
Franchise & Utility Tax $7,500,000.00 $7,059,137.77 ($440,862.23)
Property Taxes $5,274,699.00 $5,412,677.55 $137,978.55
Intergovernmental $66,981.54 $27,644.25 ($39,337.29)
Charges for Services $2,715,993.65 $2,769,198.32 $53,204.67
Fees, Licenses, & Permits $708,400.00 $989,811.82 $281,411.82
Fines & Forfeitures $1,009,100.00 $808,999.18 ($200,100.82)
Contributions/Donations $313,051.65 $333,634.08 $20,582.43
Other Operating Revenues $150,538.79 $193,117.56 $42,578.77
Interest Income $110,000.00 $188,032.30 $78,032.30
Other Non Operating Revenue $54,000.00 $123,215.48 $69,215.48
Operating Transfers In $23,800.00 $24,870.56 $1,070.56
Totals $31,562,564.63 $31,558,663.06 $134,809.53
FY2017
Revenue Model Report (Detail)Remaining
For Period Ending October 31, 2017 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification
Description Budget As of 12/7/17 As of 12/7/17 TOTAL (Under) Budget of Formulas
Sales Tax and Use Tax
10-100-400010 Sales Tax $11,300,000.00 $11,304,677.76 $0.00 $11,304,677.76 $4,677.76 $4,677.76
$11,300,000.00 $11,304,677.76 $0.00 $11,304,677.76 $4,677.76 $4,677.76
Intergovernmental Taxes
10-100-401030 Motor Vehicle Sales Tax $550,000.00 $531,555.76 $41,099.66 $572,655.42 $22,655.42 $22,655.42
10-100-403010 Gasoline Tax $1,120,000.00 $1,064,345.81 $97,611.44 $1,161,957.25 $41,957.25 $41,957.25
10-100-430080 Road & Bridge Tax $550,000.00 $613,521.78 $0.00 $613,521.78 $63,521.78 $63,521.78
$2,220,000.00 $2,209,423.35 $138,711.10 $2,348,134.45 $128,134.45 $128,134.45Other Taxes
10-100-403020 Cig Tax $116,000.00 $114,223.08 $0.00 $114,223.08 ($1,776.92)($1,776.92)
$116,000.00 $114,223.08 $0.00 $114,223.08 ($1,776.92)($1,776.92)Franchise & Utility Tax
10-100-410020 Electric Utility Lic Tax $4,000,000.00 $3,905,811.37 $0.00 $3,905,811.37 ($94,188.63)($94,188.63)
10-100-410030 Gas Utility License Tax $1,000,000.00 $787,641.42 $0.00 $787,641.42 ($212,358.58)($212,358.58)
10-100-410052 Telephone/Cell Utility $2,070,000.00 $1,969,399.61 $0.00 $1,969,399.61 ($100,600.39)($100,600.39)
10-100-410053 Telephone/Cell Audit $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
10-100-410060 Cable Franchise Fee $430,000.00 $396,285.37 $0.00 $396,285.37 ($33,714.63)($33,714.63)
$7,500,000.00 $7,059,137.77 $0.00 $7,059,137.77 ($440,862.23)($440,862.23)
Property Taxes
10-100-420010 Current Property Tax $4,617,300.00 $4,720,215.86 $0.00 $4,720,215.86 $102,915.86 $102,915.86
10-100-420020 Del Property Tax $46,000.00 $43,546.50 $0.00 $43,546.50 ($2,453.50)($2,453.50)
10-100-420040 Fin Institution Tax $42,000.00 $53,460.77 $0.00 $53,460.77 $11,460.77 $11,460.77
10-100-420050 Prop Tax Int & Penalties $25,000.00 $25,561.56 $0.00 $25,561.56 $561.56 $561.56
10-100-420055 Surtax Receipts - County Reimb $54,399.00 $54,399.28 $0.00 $54,399.28 $0.28 $0.28
10-100-420060 Surtax Receipts $465,000.00 $464,993.27 $0.00 $464,993.27 ($6.73)($6.73)
10-100-420080 Special Tax Rev $25,000.00 $50,500.31 $0.00 $50,500.31 $25,500.31 $25,500.31
$5,274,699.00 $5,412,677.55 $0.00 $5,412,677.55 $137,978.55 $137,978.55
Intergovernmental
10-100-430040 Local Grant $5,040.00 $5,040.09 $0.00 $5,040.09 $0.09 $0.09
10-100-480020 NSP Rehab Sales $61,941.54 $15,194.16 $0.00 $15,194.16 ($46,747.38)($46,747.38)
10-100-480025 HUD Program Income $0.00 $7,410.00 $0.00 $7,410.00 $7,410.00 $7,410.00
$66,981.54 $27,644.25 $0.00 $27,644.25 ($39,337.29)($39,337.29)Charges for Services
10-100-440010 Admin Charge Backs $1,556,063.00 $1,556,063.00 $0.00 $1,556,063.00 $0.00 $0.00
10-100-440050 Emt Reimbursement $25,000.00 $25,000.00 $0.00 $25,000.00 $0.00 $0.00
10-100-440210 Street Cuts $28,000.00 $21,407.00 $0.00 $21,407.00 ($6,593.00)($6,593.00)
10-100-440910 Fuel Charge - backs $11,000.00 $8,729.20 $0.00 $8,729.20 ($2,270.80)($2,270.80)
10-100-440920 Parts Charge backs $185,000.00 $192,878.91 $0.00 $192,878.91 $7,878.91 $7,878.91
10-100-440930 Labor Charge backs $240,000.00 $228,294.48 $0.00 $228,294.48 ($11,705.52)($11,705.52)
10-100-481020 Cole Cty Animal Rescue $105,508.00 $105,508.04 $0.00 $105,508.04 $0.04 $0.04
10-100-481030 Rent City Hall/Annex $35,000.00 $35,000.00 $0.00 $35,000.00 $0.00 $0.00
10-100-481040 Rent Other $0.00 $12,000.00 $0.00 $12,000.00 $12,000.00 $12,000.00
10-100-481045 Rent-tower Sites $104,000.00 $148,078.17 $0.00 $148,078.17 $44,078.17 $44,078.17
10-100-481065 Parking Spot Maintenance $25,000.00 $25,000.00 $0.00 $25,000.00 $0.00 $0.00
10-100-481075 Cole Cty 911 Reimb $366,423.91 $369,684.77 $0.00 $369,684.77 $3,260.86 $3,260.86
10-100-481080 Sale Of Maps/GIS Data $0.00 $30.00 $0.00 $30.00 $30.00 $30.00
10-100-481085 Cole Cty GIS Joint Coop $15,000.00 $26,100.00 $0.00 $26,100.00 $11,100.00 $11,100.00
10-100-481100 Sale Of Grave Sites $4,000.00 $6,936.00 $0.00 $6,936.00 $2,936.00 $2,936.00
10-100-481105 TIF Administration Fee $15,998.74 $8,498.75 $0.00 $8,498.75 ($7,499.99)($7,499.99)
10-100-481110 Long & Short $0.00 ($10.00)$0.00 ($10.00)($10.00)($10.00)
$2,715,993.65 $2,769,198.32 $0.00 $2,769,198.32 $53,204.67 $53,204.67
Fees, Licenses, & Permits
10-100-450010 Liquor Licenses $66,000.00 $64,965.58 $0.00 $64,965.58 ($1,034.42)($1,034.42)
10-100-450020 Business Licenses $215,000.00 $219,287.68 $0.00 $219,287.68 $4,287.68 $4,287.68
10-100-450021 Home Occupation Permit $1,600.00 $1,695.98 $0.00 $1,695.98 $95.98 $95.98
10-100-450040 Abandoned Bldg. Regist.$0.00 $7,775.00 $0.00 $7,775.00 $7,775.00 $7,775.00
10-100-450041 Abandoned Bldg. Admin Fee $6,500.00 $102,430.00 $0.00 $102,430.00 $95,930.00 $95,930.00
10-100-450045 Building Construct. Fees $150,000.00 $309,019.70 $0.00 $309,019.70 $159,019.70 $159,019.70
10-100-450050 Electrical Certificates $19,000.00 $19,797.00 $0.00 $19,797.00 $797.00 $797.00
10-100-450060 Electrical Permits $4,000.00 $2,619.34 $0.00 $2,619.34 ($1,380.66)($1,380.66)
10-100-450070 Plumbing Licenses $10,500.00 $10,596.00 $0.00 $10,596.00 $96.00 $96.00
10-100-450080 Plumbing Permits $4,000.00 $4,595.75 $0.00 $4,595.75 $595.75 $595.75
10-100-450090 Other Lic & Permits $2,000.00 $1,783.00 $0.00 $1,783.00 ($217.00)($217.00)
10-100-450091 Day Care Inspection Fees $7,000.00 $6,035.00 $0.00 $6,035.00 ($965.00)($965.00)
FY2017
Revenue Model Report (Detail)Remaining
For Period Ending October 31, 2017 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification
Description Budget As of 12/7/17 As of 12/7/17 TOTAL (Under) Budget of Formulas
10-100-450092 Food Inspection Fees $85,000.00 $88,292.49 $0.00 $88,292.49 $3,292.49 $3,292.49
10-100-450100 Curb Cut Permits $800.00 $1,163.00 $0.00 $1,163.00 $363.00 $363.00
10-100-450110 Board Of Adj Fees $1,300.00 $2,730.00 $0.00 $2,730.00 $1,430.00 $1,430.00
10-100-450120 Sign Permits $5,100.00 $6,291.00 $0.00 $6,291.00 $1,191.00 $1,191.00
10-100-450130 Demolition Permits $900.00 $795.00 $0.00 $795.00 ($105.00)($105.00)
10-100-450150 Acc Rep Fees-police $11,200.00 $11,376.70 $0.00 $11,376.70 $176.70 $176.70
10-100-450160 Accrpt/blastg P-fire $900.00 $1,842.00 $0.00 $1,842.00 $942.00 $942.00
10-100-450170 Animal Redemption Fees $60,000.00 $65,795.00 $0.00 $65,795.00 $5,795.00 $5,795.00
10-100-450180 Animal Vaccinations Fees $4,300.00 $4,825.00 $0.00 $4,825.00 $525.00 $525.00
10-100-450185 Animal Cremation Fees $30,000.00 $40,131.00 $0.00 $40,131.00 $10,131.00 $10,131.00
10-100-450186 Animal Boarding Fees $0.00 $930.00 $0.00 $930.00 $930.00 $930.00
10-100-450190 Taxi Permits $700.00 $338.00 $0.00 $338.00 ($362.00)($362.00)
10-100-450230 Vacating Right Of Way $800.00 $1,596.00 $0.00 $1,596.00 $796.00 $796.00
10-100-450250 Rezoning Request $12,000.00 $5,003.60 $0.00 $5,003.60 ($6,996.40)($6,996.40)
10-100-450255 Planning & Zoning Review Fees $8,000.00 $7,048.00 $0.00 $7,048.00 ($952.00)($952.00)
10-100-450260 Non-refundable Plans/spec $1,800.00 $1,055.00 $0.00 $1,055.00 ($745.00)($745.00)
$708,400.00 $989,811.82 $0.00 $989,811.82 $281,411.82 $281,411.82Fines & Forfeitures
10-100-460010 Court Cost $75,500.00 $73,413.50 $0.00 $73,413.50 ($2,086.50)($2,086.50)
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 $12,157.01 $0.00 $12,157.01 ($342.99)($342.99)
10-100-460020 Jail Cost Recovery $4,000.00 $1,589.66 $0.00 $1,589.66 ($2,410.34)($2,410.34)
10-100-460025 Alcohol Offense Cost Rec $8,000.00 $5,638.40 $0.00 $5,638.40 ($2,361.60)($2,361.60)
10-100-460030 Pol Fines-traffic $860,000.00 $688,012.62 $0.00 $688,012.62 ($171,987.38)($171,987.38)
10-100-460090 Parking Fines $53,000.00 $31,283.89 $0.00 $31,283.89 ($21,716.11)($21,716.11)
10-100-460100 Bankcard Charges ($3,900.00)($3,095.90)$0.00 ($3,095.90)$804.10 $804.10
$1,009,100.00 $808,999.18 $0.00 $808,999.18 ($200,100.82)($200,100.82)
Contributions/Donations
10-100-480055 JC Fire Museum $0.00 $3,296.00 $0.00 $3,296.00 $3,296.00 $3,296.00
10-100-480070 Community Projects Donations $10,301.65 $10,301.65 $0.00 $10,301.65 $0.00 $0.00
10-100-480080 Dare Donations $0.00 $500.00 $0.00 $500.00 $500.00 $500.00
10-100-480090 Police K-9 Donations $500.00 $500.00 $0.00 $500.00 $0.00 $0.00
10-100-480165 Animal S Donations $0.00 $15,286.43 $0.00 $15,286.43 $15,286.43 $15,286.43
10-100-481055 Street Repair-Solid Waste Cntr $302,250.00 $303,750.00 $0.00 $303,750.00 $1,500.00 $1,500.00
10-100-481095 Cemetery Donations $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$313,051.65 $333,634.08 $0.00 $333,634.08 $20,582.43 $20,582.43
Other Operating Revenues
10-100-480011 Police Evidence Funds $0.00 $10,457.83 $0.00 $10,457.83 $10,457.83 $10,457.83
10-100-481070 Miscellaneous $35,000.00 $54,385.47 $0.00 $54,385.47 $19,385.47 $19,385.47
10-100-481072 TIF Prof Svcs Deposit $67,538.79 $86,196.29 $0.00 $86,196.29 $18,657.50 $18,657.50
10-100-481074 Revenue Share - Purchasing Card $18,000.00 $16,532.97 $0.00 $16,532.97 ($1,467.03)($1,467.03)
10-100-481077 Insurance Claims $20,000.00 $11,394.51 $0.00 $11,394.51 ($8,605.49)($8,605.49)
10-100-481078 Cafeteria Refunds $10,000.00 $14,150.49 $0.00 $14,150.49 $4,150.49 $4,150.49
$150,538.79 $193,117.56 $0.00 $193,117.56 $42,578.77 $42,578.77Interest Income
10-100-470010 Interest $110,000.00 $188,032.30 $0.00 $188,032.30 $78,032.30 $78,032.30
$110,000.00 $188,032.30 $0.00 $188,032.30 $78,032.30 $78,032.30Other Non Operating Revenue
10-100-485050 Sale Of Assets $54,000.00 $123,215.48 $0.00 $123,215.48 $69,215.48 $69,215.48
$54,000.00 $123,215.48 $0.00 $123,215.48 $69,215.48 $69,215.48Operating Transfers In
10-100-490240 Trsfr From Lodging Tax $23,800.00 $24,870.56 $0.00 $24,870.56 $1,070.56 $1,070.56
10-100-490630 Transfer from Self Funded Hlth Ins $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$23,800.00 $24,870.56 $0.00 $24,870.56 $1,070.56 $1,070.56
$31,562,564.63 $31,558,663.06 $138,711.10 $31,697,374.16 $134,809.53 $134,809.53
CITY OF JEFFERSON
FISCAL YEAR 2017 ESTIMATED FUND BALANCE
FYE2016 UNASSIGNED FUND BALANCE (Audited)8,844,970.00$
FYE2016 Fund Balance % of Adopted Budget 28.77%
Reappropriations from FY2016 to FY2017
Remaining Funds from Sale of Old Fire Station #3 (111,788.00)$
MECO Design Contract for Downtown Electric (12,000.00)$
Remaining Funds for Compensation & Class Study (20,754.89)$
Upgrade for Food Inspection Software (1,474.00)$
Remaining balance for court softward project (5,563.24)$
SOMO Sewer Extension (300,000.00)$
Remaining Funds for Public Art (3,665.00)$
NRA Rental Façade (15,066.00)$
NSP Rehab Sales (350.00)$
(470,661.13)$
2017 Adjustments/Supplementals
FY2017 Supplemental Appropriations:
Matching for professional services grant for Capital Area MPO (2,250.00)$
Fire Apparatus Lease Payoff (1,163,313.93)$
Professional Legal Services (Buescher case)(17,000.00)$
Columbia Regional Airport air service guarantee participation (100,000.00)$
Port Feasibility Study (47,600.00)$
Design of South Lincoln Street slope stabilization (61,800.00)$
Stormwater repairs and improvements (750,000.00)$
Legal fees for Mo American Water Tariff Case (20,000.00)$
Lincoln Street Project (338,694.60)$
Downtown Streetscape Repair & Electric Project (640,000.00)$
New Fire Station #2 (1,221,035.00)$
Computer Software for PPS (34,800.00)$
(4,396,493.53)$
2017 Release of Restricted Funds - Parks Multipurpose Building 1,500,000.00$
FYE2017 ESTIMATED Unassigned Fund Balance 5,477,815.34$
FYE2017 ESTIMATED Fund Balance % of Adopted Budget 17.00%
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
Tax Period
Due Date to
City Total Lodging Tax JCCVB (3/7)
JCCVB/Tourism Fund
(4/7)**
(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
(8.29) 9/2014 Service Charge
Aug‐14 9/20/14 75,962.88 31,904.41 42,539.21
Tax Period
Due Date to
City Total Lodging Tax JCCVB (3/7)
JCCVB/Tourism Fund
(4/7)**
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
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
Tax Period
Due Date to
City Total Lodging Tax JCCVB (3/7)
JCCVB/Tourism Fund
(4/7)**
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
Total 7,384,059.90 3,101,305.16 4,281,521.17
average monthly amount for 4 cent lockbox fund 52,342.70$
**Effective for 25 years starting in 2011
Ta
b
2
-
M
u
l
t
i
-
S
e
g
m
e
n
t
Currency: USD - US Dollar
Mi
s
s
o
u
r
i
H
o
t
e
l
&
L
o
d
g
i
n
g
A
s
s
o
c
i
a
t
i
o
n
Fo
r
t
h
e
m
o
n
t
h
o
f
:
O
c
t
o
b
e
r
2
0
1
7
Pe
r
c
e
n
t
C
h
a
n
g
e
f
r
o
m
O
c
t
o
b
e
r
2
0
1
6
Pe
r
c
e
n
t
C
h
a
n
g
e
f
r
o
m
Y
T
D
2
0
1
6
20
1
7
2
0
1
6
2
0
1
7
2
0
1
6
2
0
1
7
2
0
1
6
O
c
c
A
D
R
R
e
v
P
A
R
Ro
o
m
Re
v
Ro
o
m
Av
a
i
l
Ro
o
m
So
l
d
20
1
7
2
0
1
6
2
0
1
7
2
0
1
6
2
0
1
7
2
0
1
6
O
c
c
A
D
R
R
e
v
P
A
R
Ro
o
m
Re
v
Room AvailRoom Sold Census
S
a
m
p
l
e
C
e
n
s
u
s
S
a
m
p
l
e
Un
i
t
e
d
S
t
a
t
e
s
6
9
.
6
6
8
.
4
1
3
0
.
2
0
1
2
7
.
0
6
9
0
.
5
6
8
6
.
9
6
1
.
6
2
.
5
4
.
1
6
.
1
1
.
9
3
.
6
6
7
.
6
6
7
.
1
1
2
7
.
4
6
1
2
4
.
8
9
8
6
.
1
9
8
3
.
8
5
0
.
7
2
.
1
2
.
8
4
.
7
1
.
8
2
.
6
5
4
7
8
0
3
3
1
6
7
5
1
6
6
0
3
4
3
834248
We
s
t
N
o
r
t
h
C
e
n
t
r
a
l
6
1
.
2
6
3
.
7
9
9
.
1
0
9
8
.
3
0
6
0
.
7
0
6
2
.
5
7
-
3
.
8
0
.
8
-
3
.
0
-
1
.
3
1
.
8
-
2
.
1
6
0
.
1
6
1
.
1
9
8
.
4
0
9
7
.
0
2
5
9
.
0
9
5
9
.
3
0
-
1
.
7
1
.
4
-
0
.
3
1
.
0
1
.
4
-
0
.
4
4
5
9
9
2
7
6
7
3
6
0129
2
6
6
1
1
1
Mi
s
s
o
u
r
i
6
4
.
2
6
5
.
8
1
0
2
.
1
7
9
8
.
6
9
6
5
.
6
1
6
4
.
9
1
-
2
.
4
3
.
5
1
.
1
2
.
4
1
.
3
-
1
.
0
6
2
.
7
6
3
.
1
1
0
0
.
1
1
9
6
.
3
0
6
2
.
8
1
6
0
.
7
5
-
0
.
6
4
.
0
3
.
4
3
.
9
0
.
5
-
0
.
1
1
1
1
9
6
5
6
1
0
2
1
5
2
7
3
7
1
8
Ka
n
s
a
s
C
i
t
y
,
M
O
-
K
S
6
9
.
9
6
9
.
7
1
1
3
.
6
6
1
0
4
.
9
8
7
9
.
4
6
7
3
.
1
7
0
.
3
8
.
3
8
.
6
8
.
4
-
0
.
2
0
.
1
6
7
.
9
6
6
.
3
1
0
5
.
4
1
1
0
0
.
1
2
7
1
.
5
7
6
6
.
4
3
2
.
3
5
.
3
7
.
7
5
.
8
-
1
.
8
0
.
5
2
9
1
2
3
3
3
2
2
0
5
27837
St
L
o
u
i
s
,
M
O
-
I
L
6
5
.
2
6
8
.
0
1
0
6
.
6
0
1
0
5
.
4
3
6
9
.
5
4
7
1
.
7
4
-
4
.
1
1
.
1
-
3
.
1
-
1
.
3
1
.
8
-
2
.
4
6
7
.
4
6
8
.
2
1
0
5
.
8
2
1
0
2
.
0
8
7
1
.
3
5
6
9
.
6
6
-
1
.
2
3
.
7
2
.
4
4
.
0
1
.
5
0
.
3
3
3
0
2
5
1
3
8
7
0
9
33615
Co
l
u
m
b
i
a
,
M
O
+
6
3
.
2
6
5
.
1
9
5
.
3
3
9
4
.
9
1
6
0
.
2
4
6
1
.
8
2
-
3
.
0
0
.
4
-
2
.
6
-
3
.
7
-
1
.
2
-
4
.
2
6
3
.
0
6
1
.
7
8
9
.
9
2
8
8
.
4
2
5
6
.
6
3
5
4
.
5
5
2
.
1
1
.
7
3
.
8
0
.
7
-
3
.
0
-
1
.
0
3
8
3
0
3
8
0
4
3
1
7
6
Je
f
f
e
r
s
o
n
C
i
t
y
,
M
O
+
6
6
.
5
6
6
.
0
8
1
.
0
6
7
9
.
3
3
5
3
.
9
0
5
2
.
3
3
0
.
8
2
.
2
3
.
0
3
.
0
0
.
0
0
.
8
6
2
.
4
6
3
.
2
8
0
.
1
0
7
8
.
1
2
4
9
.
9
9
4
9
.
3
5
-
1
.
2
2
.
5
1
.
3
1
.
3
0
.
0
-
1
.
2
1
5
1
2
1
4
9
4
1
1
4
0
Sp
r
i
n
g
f
i
e
l
d
,
M
O
6
9
.
3
6
8
.
5
8
8
.
2
7
8
4
.
4
1
6
1
.
2
1
5
7
.
8
0
1
.
3
4
.
6
5
.
9
5
.
9
-
0
.
0
1
.
2
6
5
.
0
6
3
.
4
8
3
.
5
9
8
0
.
7
4
5
4
.
3
3
5
1
.
1
8
2
.
5
3
.
5
6
.
2
6
.
1
-
0
.
1
2
.
5
6
8
4
7
6
0
8
6
4
5
1
1
Br
a
n
s
o
n
,
M
O
5
7
.
3
6
4
.
8
9
9
.
6
7
9
6
.
7
6
5
7
.
1
6
6
2
.
7
5
-
1
1
.
6
3
.
0
-
8
.
9
-
8
.
8
0
.
1
-
1
1
.
4
5
2
.
4
5
4
.
0
1
0
1
.
7
3
9
8
.
8
2
5
3
.
2
8
5
3
.
3
6
-
3
.
0
2
.
9
-
0
.
1
-
0
.
0
0
.
1
-
2
.
9
1
5
0
3
3
1
3
5
3
2
4
3
8
8
La
k
e
o
f
t
h
e
O
z
a
r
k
s
+
4
9
.
3
5
1
.
8
9
9
.
1
7
9
5
.
9
1
4
8
.
9
3
4
9
.
7
1
-
4
.
8
3
.
4
-
1
.
6
-
3
.
8
-
2
.
2
-
6
.
9
5
1
.
3
5
1
.
3
1
0
5
.
0
5
1
0
3
.
7
8
5
3
.
9
0
5
3
.
2
3
0
.
0
1
.
2
1
.
3
0
.
1
-
1
.
1
-
1
.
1
3
6
1
2
2
7
1
2
1
6
8
9
Jo
p
l
i
n
,
M
O
6
2
.
9
6
3
.
2
8
1
.
1
3
7
6
.
8
0
5
1
.
0
0
4
8
.
5
4
-
0
.
5
5
.
6
5
.
1
5
.
0
-
0
.
1
-
0
.
6
6
3
.
6
6
1
.
8
8
2
.
5
3
7
9
.
6
8
5
2
.
4
7
4
9
.
2
3
2
.
9
3
.
6
6
.
6
6
.
5
-
0
.
1
2
.
8
3
0
2
3
2
2
9
8
2
0
0
9
Sa
i
n
t
J
o
s
e
p
h
,
M
O
+
6
1
.
0
6
7
.
4
8
6
.
2
5
8
6
.
0
5
5
2
.
6
3
5
8
.
0
1
-
9
.
5
0
.
2
-
9
.
3
-
0
.
4
9
.
8
-
0
.
6
6
0
.
2
6
2
.
9
8
8
.
8
1
8
4
.
9
0
5
3
.
5
0
5
3
.
3
7
-
4
.
2
4
.
6
0
.
2
4
.
2
4
.
0
-
0
.
4
1
3
1
1
1
2
1
4
1
1
0
7
A
b
l
a
n
k
r
o
w
i
n
d
i
c
a
t
e
s
i
n
s
u
f
f
i
c
i
e
n
t
d
a
t
a
.
Re
v
P
A
R
Properties
AD
R
Participation
Oc
c
%
Cu
r
r
e
n
t
M
o
n
t
h
-
O
c
t
o
b
e
r
2
0
1
7
v
s
O
c
t
o
b
e
r
2
0
1
6
Th
e
S
T
R
D
e
s
t
i
n
a
t
i
o
n
R
e
p
o
r
t
i
s
a
p
u
b
l
i
c
a
t
i
o
n
o
f
S
T
R
,
I
n
c
.
a
n
d
S
T
R
G
l
o
b
a
l
,
L
t
d
.
,
a
n
d
i
s
i
n
t
e
n
d
e
d
s
o
l
e
l
y
f
o
r
u
s
e
b
y
p
a
i
d
s
u
b
s
c
r
i
b
e
rs
.
R
e
p
r
o
d
u
c
t
i
o
n
o
r
d
i
s
t
r
i
b
u
t
i
o
n
o
f
t
h
e
S
T
R
D
e
s
t
i
n
a
t
i
o
n
R
e
p
o
r
t
,
i
n
w
h
o
l
e
o
r
p
a
r
t
,
w
i
t
h
o
u
t
w
r
i
t
t
e
n
p
e
r
m
i
s
s
i
o
n
i
s
p
r
o
h
i
b
i
t
e
d
a
n
d
su
b
j
e
c
t
t
o
l
e
g
a
l
a
c
t
i
o
n
.
I
f
y
o
u
h
a
v
e
r
e
c
e
i
v
e
d
t
h
i
s
r
e
p
o
r
t
a
n
d
a
r
e
N
O
T
a
s
u
b
s
c
r
i
b
e
r
t
o
t
h
e
S
T
R
D
e
s
t
i
n
a
t
i
o
n
Re
p
o
r
t
,
p
l
e
a
s
e
c
o
n
t
a
c
t
u
s
i
m
m
e
d
i
a
t
e
l
y
.
S
o
u
r
c
e
:
2
0
1
7
S
T
R
,
I
n
c
.
/
S
T
R
G
l
o
b
a
l
,
L
t
d
.
t
r
a
d
i
n
g
a
s
"
S
T
R
"
.
Re
v
P
A
R
AD
R
Oc
c
%
Ye
a
r
t
o
D
a
t
e
-
O
c
t
o
b
e
r
2
0
1
7
v
s
O
c
t
o
b
e
r
2
0
1
6
Rooms
20
1
7
Oc
c
u
p
a
n
c
y
2
0
1
6
Oc
c
u
p
a
n
c
y
2
0
1
5
Oc
c
u
p
a
n
c
y
2
0
1
4
Oc
c
u
p
a
n
c
y
2
0
1
3
Oc
c
u
p
a
n
c
y
2
0
1
2
Occupancy
Ja
n
u
a
r
y
4
8
.
7
0
%
5
1
.
3
0
%
4
5
.
9
0
%
4
9
.
2
0
%
4
5
.
3
0
%
3
8
.
2
0
%
Fe
b
r
u
a
r
y
5
6
.
8
0
%
5
8
.
6
0
%
5
1
.
2
0
%
5
6
.
0
0
%
5
2
.
9
0
%
4
9
.
8
0
%
Ma
r
c
h
6
2
.
2
0
%
5
9
.
8
0
%
5
9
.
8
0
%
5
9
.
3
0
%
5
2
.
9
0
%
5
4
.
9
0
%
Ap
r
i
l
6
2
.
4
0
%
6
7
.
2
0
%
5
8
.
1
0
%
6
3
.
7
0
%
6
4
.
1
0
%
5
3
.
9
0
%
Ma
y
6
3
.
8
0
%
6
4
.
9
0
%
6
3
.
1
0
%
6
4
.
7
0
%
5
6
.
8
0
%
5
3
.
7
0
%
Ju
n
e
7
0
.
4
0
%
6
4
.
0
0
%
5
9
.
7
0
%
6
3
.
7
0
%
5
5
.
7
0
%
5
3
.
1
0
%
Ju
l
y
6
5
.
9
0
%
5
8
.
2
0
%
6
0
.
8
0
%
5
9
.
7
0
%
5
8
.
5
0
%
5
1
.
4
0
%
Au
g
u
s
t
6
1
.
5
0
%
5
6
.
5
0
%
5
2
.
6
0
%
5
4
.
2
0
%
5
5
.
8
0
%
4
7
.
0
0
%
Se
p
t
e
m
b
e
r
6
4
.
5
0
%
6
2
.
6
0
%
6
3
.
3
0
%
6
1
.
2
0
%
6
3
.
0
0
%
5
9
.
3
0
%
Oc
t
o
b
e
r
6
6
.
5
0
%
6
2
.
9
0
%
6
0
.
7
0
%
6
7
.
6
0
%
6
5
.
9
0
%
5
9
.
3
0
%
No
v
e
m
b
e
r
5
0
.
6
0
%
5
1
.
3
0
%
4
8
.
9
0
%
5
2
.
4
0
%
4
3
.
4
0
%
De
c
e
m
b
e
r
4
2
.
1
0
%
4
5
.
1
0
%
3
8
.
3
0
%
3
8
.
8
0
%
3
3
.
0
0
%
CO
M
P
A
R
A
T
I
V
E
OC
C
U
P
A
N
C
Y
RA
T
E
Ta
b
3 ‐
He
l
p
Gl
o
s
s
a
r
y
:
Fr
e
q
u
e
n
t
l
y
A
s
k
e
d
Q
u
e
s
t
i
o
n
s
(
F
A
Q
)
:
No
r
t
h
A
m
e
r
i
c
a
:
I
n
t
e
r
n
a
t
i
o
n
a
l
:
73
5
E
a
s
t
M
a
i
n
S
t
r
e
e
t
,
H
e
n
d
e
r
s
o
n
v
i
l
l
e
,
T
N
3
7
0
7
5
U
S
A
B
l
u
e
F
i
n
B
u
i
l
d
i
n
g
,
1
1
0
S
o
u
t
h
w
a
r
k
S
t
r
e
e
t
,
L
o
n
d
o
n
S
E
1
0
T
A
T
:
+
1
6
1
5
8
2
4
8
6
6
4
T
:
+
4
4
(
0
)
2
0
7
9
2
2
1
9
3
0
ho
t
e
l
i
n
f
o
@
s
t
r
.
c
o
m
As
i
a
P
a
c
i
f
i
c
:
Th
o
n
g
T
e
c
k
B
u
i
l
d
i
n
g
,
1
5
S
c
o
t
t
s
R
o
a
d
#
0
8
-
1
2
,
2
2
8
2
1
8
S
i
n
g
a
p
o
r
e
T:
+
6
4
6
8
0
0
7
8
5
0
Fo
r
a
l
l
S
T
R
F
A
Q
s
,
p
l
e
a
s
e
c
l
i
c
k
h
e
r
e
o
r
v
i
s
i
t
w
w
w
.
s
t
r
.
c
o
m
/
r
e
s
o
u
r
c
e
s
/
f
a
q
Fo
r
t
h
e
l
a
t
e
s
t
i
n
i
n
d
u
s
t
r
y
n
e
w
s
,
v
i
s
i
t
H
o
t
e
l
N
e
w
s
N
o
w
.
c
o
m
.
su
p
p
o
r
t
@
s
t
r
.
c
o
m
Fo
r
a
l
l
S
T
R
d
e
f
i
n
i
t
i
o
n
s
,
p
l
e
a
s
e
v
i
s
i
t
w
w
w
.
s
t
r
.
c
o
m
/
r
e
s
o
u
r
c
e
s
/
g
l
o
s
s
a
r
y
To
l
e
a
r
n
m
o
r
e
a
b
o
u
t
t
h
e
H
o
t
e
l
D
a
t
a
C
o
n
f
e
r
e
n
c
e
,
v
i
s
i
t
H
o
t
e
l
D
a
t
a
C
o
n
f
e
r
e
n
c
e
.
c
o
m
.
ap
i
n
f
o
@
s
t
r
.
c
o
m
Pl
e
a
s
e
v
i
s
i
t
o
u
r
w
e
b
s
i
t
e
a
t
w
w
w
.
s
t
r
.
c
o
m
,
o
r
i
f
y
o
u
n
e
e
d
a
d
d
i
t
i
o
n
a
l
a
s
s
i
s
t
a
n
c
e
p
l
e
a
s
e
r
e
a
c
h
o
u
t
t
o
o
u
r
C
u
s
t
o
m
e
r
S
u
p
p
o
r
t
t
e
a
m
.