The URL can be used to link to this page

Home My Public Portal About2017-08 NO Meeting packetMemo To:Steve Crowell From:Shiela Pearre Date:August 7, 2017 Re:Sales Tax Revenues The City received the August 1% Sales Tax in the amount of $678,636 which is $28,597 more than projected for August. January thru August shortfall is $23,011 (0.2%) 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,195,077 Aug-17 Oct-17 $969,353 Sep-17 Nov-17 $959,772 Oct-17 & Jul-Sept 17 Qtrly Dec-17 $823,654 Total Overage/Shortfall $11,300,000 ($23,011) 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 $512,931 Aug-17 Oct-17 $416,050 Sep-17 Nov-17 $411,938 Oct-17 & Jul-Sept 17 Qtrly Dec-17 $353,515 Total Overage/Shortfall $4,850,000 $417,443 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 $536,554 Aug-17 Oct-17 $435,211 Sep-17 Nov-17 $430,909 Oct-17 & Jul-Sept 17 Qtrly Dec-17 $369,796 Total Overage/Shortfall $5,073,365 $264,143 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: AUGUST 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,195,077 est. 1,109,227 Aug October 769,129 717,262 919,035 918,839 903,829 969,353 est. 845,619 Sept November 615,421 677,366 651,080 661,849 623,645 959,772 est. 645,872 Oct & Jul-Sept Qtrly December 982,684 932,387 1,015,322 1,075,638 1,016,682 823,654 est. 1,004,542 Actual to Date $ 9,657,608 $ 9,655,913 $ 10,102,175 $ 10,856,302 $ 11,002,277 7,329,132 Estimated to Fiscal Year end (based on averages and on Budgeted amount)3,947,856 Total Actual & Estimated $ 11,276,989 Less: Budget 11,300,000 Over (Under) Budget -$ 23,011 $ 1,083,570 $ 1,890,359 $ 2,964,201 $ 3,807,762 $ 4,495,504 $ 5,496,445 $ 6,650,496 $ 7,329,132 $ 924,504 $ 1,748,274 $ 2,877,998 $ 3,829,230 $ 4,561,069 $ 5,632,857 $ 6,702,104 $ 7,352,144 $ 8,547,221 $ 9,516,574 $ 10,476,346 $ 11,300,000 $ 0 $ 500,000 $ 1,000,000 $ 1,500,000 $ 2,000,000 $ 2,500,000 $ 3,000,000 $ 3,500,000 $ 4,000,000 $ 4,500,000 $ 5,000,000 $ 5,500,000 $ 6,000,000 $ 6,500,000 $ 7,000,000 $ 7,500,000 $ 8,000,000 $ 8,500,000 $ 9,000,000 $ 9,500,000 $ 10,000,000 $ 10,500,000 $ 11,000,000 $ 11,500,000 $ 12,000,000 Nov Dec Jan & Oct‐ Dec Qtrly Feb Mar Apr & Jan‐ Mar Qtrly May Jun Jul & Apr‐Jun Qtrly Aug Sept Oct & Jul‐ Sept Qtrly REPORTING PERIOD YTD Actuals vs. YTD Budget Actual Budget Printed 8/7/2017 City of Jefferson, Mo. - Account Analysis Account Name Capital Imprs Sales Tax Receipt Month: AUGUST 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 512,931 est. 529,198 Aug October 367,366 357,619 430,185 442,371 435,416 416,050 est. 406,591 Sept November 306,968 323,871 324,697 330,393 310,506 411,938 est. 319,287 Oct & Jul-Sept Qtrly December 469,095 443,688 485,136 515,478 494,218 353,515 est. 481,523 Actual to Date $ 4,671,272 $ 4,664,580 $ 4,877,931 $ 5,260,753 $ 5,356,330 3,573,009 Estimated to Fiscal Year end (based on averages and on Budgeted amount)1,694,434 Total Actual & Estimated $ 5,267,443 Less: Budget 4,850,000 Over (Under) Budget $ 417,443 $ 525,521 $ 928,485 $ 1,435,082 $ 1,846,103 $ 2,186,264 $ 2,675,273 $ 3,234,392 $ 3,573,009 $ 396,801 $ 750,365 $ 1,235,247 $ 1,643,519 $ 1,957,627 $ 2,417,642 $ 2,876,567 $ 3,155,566 $ 3,668,497 $ 4,084,547 $ 4,496,485 $ 4,850,000 $ 100,000 $ 350,000 $ 600,000 $ 850,000 $ 1,100,000 $ 1,350,000 $ 1,600,000 $ 1,850,000 $ 2,100,000 $ 2,350,000 $ 2,600,000 $ 2,850,000 $ 3,100,000 $ 3,350,000 $ 3,600,000 $ 3,850,000 $ 4,100,000 $ 4,350,000 $ 4,600,000 $ 4,850,000 $ 5,100,000 Nov Dec Jan & Oct‐ Dec Qtrly Feb Mar Apr & Jan‐ Mar Qtrly May Jun Jul & Apr‐Jun Qtrly Aug Sept Oct & Jul‐ Sept Qtrly REPORTING PERIOD YTD Actuals vs. YTD Budget Actual Budget Printed 8/7/2017 City of Jefferson, Mo. - Account Analysis Account Name Parks Sales Tax Receipt Month: AUGUST 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 536,554 est. 530,007 Aug October 366,846 357,482 430,093 442,370 435,416 435,211 est. 406,441 Sept November 306,831 323,768 324,481 330,393 310,506 430,909 est. 319,196 Oct & Jul-Sept Qtrly December 468,924 443,569 484,999 515,368 494,218 369,796 est. 481,415 Actual to Date $ 4,664,400 $ 4,662,755 $ 4,874,018 $ 5,259,477 $ 5,358,988 3,565,038 Estimated to Fiscal Year end (based on averages and on Budgeted amount)1,772,471 Total Actual & Estimated $ 5,337,508 Less: Budget 5,073,365 Over (Under) Budget $ 264,143 $ 525,521 $ 920,739 $ 1,427,263 $ 1,838,283 $ 2,178,445 $ 2,667,453 $ 3,226,568 $ 3,565,038 $ 415,075 $ 784,923 $ 1,292,136 $ 1,719,211 $ 2,047,785 $ 2,528,986 $ 3,009,046 $ 3,300,895 $ 3,837,449 $ 4,272,660 $ 4,703,569 $ 5,073,365 $ 100,000 $ 350,000 $ 600,000 $ 850,000 $ 1,100,000 $ 1,350,000 $ 1,600,000 $ 1,850,000 $ 2,100,000 $ 2,350,000 $ 2,600,000 $ 2,850,000 $ 3,100,000 $ 3,350,000 $ 3,600,000 $ 3,850,000 $ 4,100,000 $ 4,350,000 $ 4,600,000 $ 4,850,000 $ 5,100,000 $ 5,350,000 Nov Dec Jan & Oct ‐ Dec Qtrly Feb Mar Apr & Jan‐ Mar Qtrly May Jun Jul & Apr‐Jun Qtrly Aug Sept Oct & Jul‐ Sept Qtrly REPORTING PERIOD YTD Actuals vs. YTD Budget Actual Budget Printed 8/7/2017 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 Ju l y 31 , 20 1 7 Da t a as of Au g u s t 7, 20 1 7 FY 20 1 7 Y T D Ac t u a l P r o j e c t e d Ov e r / De s c r i p t i o n Bu d g e t As of 8/ 7 / 1 7 (U n d e r ) Bu d g e t Sa l e s Ta x an d Us e Ta x $1 1 , 3 0 0 , 0 0 0 . 0 0 $ 7 , 3 2 9 , 1 3 2 . 3 8 ($ 2 3 , 0 1 1 . 1 9 ) In t e r g o v e r n m e n t a l Ta x e s $2 , 2 2 0 , 0 0 0 . 0 0 $ 1 , 0 2 7 , 7 8 8 . 3 2 $ 4 2 , 8 2 9 . 5 7 Ot h e r Ta x e s $1 1 6 , 0 0 0 . 0 0 $ 7 5 , 4 7 6 . 8 0 ($ 1 , 4 7 6 . 4 2 ) Fr a n c h i s e & Ut i l i t y Ta x $7 , 5 0 0 , 0 0 0 . 0 0 $ 4 , 5 2 7 , 4 1 0 . 4 8 ($ 2 9 2 , 0 4 3 . 4 7 ) Pr o p e r t y Ta x e s $5 , 2 7 4 , 6 9 9 . 0 0 $ 5 , 3 5 5 , 1 2 3 . 8 6 $ 1 2 9 , 3 4 1 . 1 0 In t e r g o v e r n m e n t a l $6 6 , 9 8 1 . 5 4 $ 6 5 , 7 0 1 . 6 3 $ 3 , 7 6 0 . 0 9 Ch a r g e s fo r Se r v i c e s $2 , 7 1 5 , 9 9 3 . 6 5 $ 2 , 4 2 4 , 6 5 3 . 7 0 $ 1 , 0 6 0 . 4 4 Fe e s , Li c e n s e s , & Pe r m i t s $7 0 8 , 4 0 0 . 0 0 $ 8 0 5 , 6 7 0 . 5 6 $ 2 1 8 , 8 5 7 . 5 4 Fi n e s & Fo r f e i t u r e s $1 , 0 0 9 , 1 0 0 . 0 0 $ 6 1 7 , 9 8 5 . 9 2 ($ 1 4 1 , 3 2 5 . 3 1 ) Co n t r i b u t i o n s / D o n a t i o n s $3 0 8 , 2 8 8 . 2 5 $ 1 9 5 , 4 5 4 . 0 1 $ 1 4 , 4 1 5 . 7 6 Ot h e r Op e r a t i n g Re v e n u e s $8 4 , 1 8 1 . 2 5 $ 1 3 5 , 4 5 5 . 8 7 $ 8 6 , 4 5 8 . 0 4 In t e r e s t In c o m e $1 1 0 , 0 0 0 . 0 0 $ 1 1 6 , 0 6 3 . 4 0 $ 4 2 , 4 6 8 . 8 3 Ot h e r No n Op e r a t i n g Re v e n u e $5 4 , 0 0 0 . 0 0 $ 9 6 , 7 9 9 . 5 0 $ 6 2 , 7 9 9 . 5 0 Op e r a t i n g Tr a n s f e r s In $23 , 8 0 0 . 0 0 $16 , 2 0 2 . 9 8 $39 4 . 6 3 To t a l s $3 1 , 4 9 1 , 4 4 3 . 6 9 $ 2 2 , 7 8 8 , 9 1 9 . 4 1 $ 1 4 4 , 5 2 9 . 1 3 FY2017 Revenue Model Report (Detail)Remaining For Period Ending July 31, 2017 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Budget As of 8/7/17 As of 8/7/17 TOTAL (Under) Budget of Formulas Sales Tax and Use Tax 10‐100‐400010 Sales Tax $11,300,000.00 $7,329,132.38 $3,947,856.43 $11,276,988.81 ($23,011.19)($23,011.19) $11,300,000.00 $7,329,132.38 $3,947,856.43 $11,276,988.81 ($23,011.19) ($23,011.19) Intergovernmental Taxes 10‐100‐401030 Motor Vehicle Sales Tax $550,000.00 $337,522.09 $227,962.78 $565,484.87 $15,484.87 $15,484.87 10‐100‐403010 Gasoline Tax $1,120,000.00 $659,973.51 $487,078.48 $1,147,051.99 $27,051.99 $27,051.99 10‐100‐430080 Road & Bridge Tax $550,000.00 $30,292.72 $520,000.00 $550,292.72 $292.72 $292.72 $2,220,000.00 $1,027,788.32 $1,235,041.25 $2,262,829.57 $42,829.57 $42,829.57 Other Taxes 10‐100‐403020 Cig Tax $116,000.00 $75,476.80 $39,046.78 $114,523.58 ($1,476.42)($1,476.42) $116,000.00 $75,476.80 $39,046.78 $114,523.58 ($1,476.42)($1,476.42) Franchise & Utility Tax 10‐100‐410020 Electric Utility Lic Tax $4,000,000.00 $2,240,992.05 $1,698,111.60 $3,939,103.65 ($60,896.35)($60,896.35) 10‐100‐410030 Gas Utility License Tax $1,000,000.00 $650,639.17 $169,322.78 $819,961.95 ($180,038.05)($180,038.05) 10‐100‐410052 Telephone/Cell Utility $2,070,000.00 $1,355,832.88 $682,545.86 $2,038,378.74 ($31,621.26)($31,621.26) 10‐100‐410053 Telephone/Cell Audit $0.00 ($15,210.20)$16,210.20 $1,000.00 $1,000.00 $1,000.00 10‐100‐410060 Cable Franchise Fee $430,000.00 $295,156.58 $114,355.61 $409,512.19 ($20,487.81)($20,487.81) $7,500,000.00 $4,527,410.48 $2,680,546.05 $7,207,956.53 ($292,043.47)($292,043.47) Property Taxes 10‐100‐420010 Current Property Tax $4,617,300.00 $4,704,724.26 $15,431.86 $4,720,156.12 $102,856.12 $102,856.12 10‐100‐420020 Del Property Tax $46,000.00 $29,120.51 $10,484.56 $39,605.07 ($6,394.93)($6,394.93) 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 $16,989.41 $7,994.98 $24,984.39 ($15.61)($15.61) 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,016.89 $1,380.08 $465,396.97 $396.97 $396.97 10‐100‐420080 Special Tax Rev $25,000.00 $32,412.74 $13,624.77 $46,037.51 $21,037.51 $21,037.51 $5,274,699.00 $5,355,123.86 $48,916.24 $5,404,040.10 $129,341.10 $129,341.10 Intergovernmental 10‐100‐430040 Local Grant $5,040.00 $0.09 $5,040.00 $5,040.09 $0.09 $0.09 10‐100‐480020 NSP Rehab Sales $61,941.54 $62,291.54 $0.00 $62,291.54 $350.00 $350.00 10‐100‐480025 HUD Program Income $0.00 $3,410.00 $0.00 $3,410.00 $3,410.00 $3,410.00 $66,981.54 $65,701.63 $5,040.00 $70,741.63 $3,760.09 $3,760.09 Charges for Services 10‐100‐440010 Admin Charge Backs $1,556,063.00 $1,556,063.00 $0.00 $1,556,063.00 $0.00 $0.00 10‐100‐440050 Emt Reimbursement $25,000.00 $25,000.00 $0.00 $25,000.00 $0.00 $0.00 10‐100‐440210 Street Cuts $28,000.00 $15,462.00 $8,217.69 $23,679.69 ($4,320.31)($4,320.31) 10‐100‐440910 Fuel Charge ‐ backs $11,000.00 $6,403.97 $2,727.39 $9,131.36 ($1,868.64)($1,868.64) 10‐100‐440920 Parts Charge backs $185,000.00 $130,122.85 $57,996.77 $188,119.62 $3,119.62 $3,119.62 10‐100‐440930 Labor Charge backs $240,000.00 $153,914.20 $80,436.63 $234,350.83 ($5,649.17)($5,649.17) 10‐100‐481020 Cole Cty Animal Rescue $105,508.00 $79,131.03 $26,377.00 $105,508.03 $0.03 $0.03 10‐100‐481030 Rent City Hall/Annex $35,000.00 $35,000.00 $0.00 $35,000.00 $0.00 $0.00 10‐100‐481040 Rent Other $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10‐100‐481045 Rent‐tower Sites $104,000.00 $95,249.62 $15,030.03 $110,279.65 $6,279.65 $6,279.65 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 $277,846.28 $88,316.71 $366,162.99 ($260.92)($260.92) 10‐100‐481080 Sale Of Maps/GIS Data $0.00 $10.00 $0.00 $10.00 $10.00 $10.00 10‐100‐481085 Cole Cty GIS Joint Coop $15,000.00 $11,250.00 $3,750.00 $15,000.00 $0.00 $0.00 10‐100‐481100 Sale Of Grave Sites $4,000.00 $5,712.00 $1,818.18 $7,530.18 $3,530.18 $3,530.18 10‐100‐481105 TIF Administration Fee $15,998.74 $8,498.75 $7,729.99 $16,228.74 $230.00 $230.00 10‐100‐481110 Long & Short $0.00 ($10.00)$0.00 ($10.00)($10.00)($10.00) $2,715,993.65 $2,424,653.70 $292,400.39 $2,717,054.09 $1,060.44 $1,060.44 Fees, Licenses, & Permits 10‐100‐450010 Liquor Licenses $66,000.00 $61,434.00 $1,372.48 $62,806.48 ($3,193.52)($3,193.52) 10‐100‐450020 Business Licenses $215,000.00 $186,018.65 $28,732.02 $214,750.67 ($249.33)($249.33) 10‐100‐450021 Home Occupation Permit $1,600.00 $1,324.98 $177.32 $1,502.30 ($97.70)($97.70) 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 $72,581.00 $3,075.68 $75,656.68 $69,156.68 $69,156.68 10‐100‐450045 Building Construct. Fees $150,000.00 $241,828.47 $45,579.42 $287,407.89 $137,407.89 $137,407.89 10‐100‐450050 Electrical Certificates $19,000.00 $18,681.00 $1,278.01 $19,959.01 $959.01 $959.01 10‐100‐450060 Electrical Permits $4,000.00 $2,192.84 $1,956.06 $4,148.90 $148.90 $148.90 10‐100‐450070 Plumbing Licenses $10,500.00 $10,059.00 $617.47 $10,676.47 $176.47 $176.47 10‐100‐450080 Plumbing Permits $4,000.00 $3,460.75 $1,011.99 $4,472.74 $472.74 $472.74 10‐100‐450090 Other Lic & Permits $2,000.00 $631.00 $943.84 $1,574.84 ($425.16)($425.16) 10‐100‐450091 Day Care Inspection Fees $7,000.00 $5,200.00 $2,412.73 $7,612.73 $612.73 $612.73 FY2017 Revenue Model Report (Detail)Remaining For Period Ending July 31, 2017 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Budget As of 8/7/17 As of 8/7/17 TOTAL (Under) Budget of Formulas 10‐100‐450092 Food Inspection Fees $85,000.00 $87,194.07 ($3,570.96)$83,623.11 ($1,376.89)($1,376.89) 10‐100‐450100 Curb Cut Permits $800.00 $898.00 $249.47 $1,147.47 $347.47 $347.47 10‐100‐450110 Board Of Adj Fees $1,300.00 $1,470.00 $415.70 $1,885.70 $585.70 $585.70 10‐100‐450120 Sign Permits $5,100.00 $4,862.00 $1,083.50 $5,945.50 $845.50 $845.50 10‐100‐450130 Demolition Permits $900.00 $424.00 $168.63 $592.63 ($307.37)($307.37) 10‐100‐450150 Acc Rep Fees‐police $11,200.00 $8,399.20 $2,550.40 $10,949.60 ($250.40)($250.40) 10‐100‐450160 Accrpt/blastg P‐fire $900.00 $425.00 $483.97 $908.97 $8.97 $8.97 10‐100‐450170 Animal Redemption Fees $60,000.00 $46,835.00 $16,871.37 $63,706.37 $3,706.37 $3,706.37 10‐100‐450180 Animal Vaccinations Fees $4,300.00 $3,825.00 $1,143.50 $4,968.50 $668.50 $668.50 10‐100‐450185 Animal Cremation Fees $30,000.00 $26,565.00 $9,048.57 $35,613.57 $5,613.57 $5,613.57 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 $260.00 $0.00 $260.00 ($440.00)($440.00) 10‐100‐450230 Vacating Right Of Way $800.00 $1,197.00 $39.50 $1,236.50 $436.50 $436.50 10‐100‐450250 Rezoning Request $12,000.00 $4,267.60 $3,822.67 $8,090.27 ($3,909.73)($3,909.73) 10‐100‐450255 Planning & Zoning Review Fees $8,000.00 $6,177.00 $1,994.49 $8,171.49 $171.49 $171.49 10‐100‐450260 Non‐refundable Plans/spec $1,800.00 $755.00 $129.14 $884.14 ($915.86)($915.86) $708,400.00 $805,670.56 $121,586.98 $927,257.54 $218,857.54 $218,857.54 Fines & Forfeitures 10‐100‐460010 Court Cost $75,500.00 $54,329.63 $18,636.96 $72,966.59 ($2,533.41)($2,533.41) 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 $9,030.55 $3,087.80 $12,118.35 ($381.65)($381.65) 10‐100‐460020 Jail Cost Recovery $4,000.00 $1,398.98 $542.00 $1,940.98 ($2,059.02)($2,059.02) 10‐100‐460025 Alcohol Offense Cost Rec $8,000.00 $4,665.00 $2,039.18 $6,704.18 ($1,295.82)($1,295.82) 10‐100‐460030 Pol Fines‐traffic $860,000.00 $524,378.96 $200,586.92 $724,965.88 ($135,034.12)($135,034.12) 10‐100‐460090 Parking Fines $53,000.00 $26,594.53 $26,564.81 $53,159.34 $159.34 $159.34 10‐100‐460100 Bankcard Charges ($3,900.00)($2,411.73)($1,668.90)($4,080.63)($180.63)($180.63) $1,009,100.00 $617,985.92 $249,788.77 $867,774.69 ($141,325.31)($141,325.31) Contributions/Donations 10‐100‐480055 JC Fire Museum $0.00 $2,016.00 $0.00 $2,016.00 $2,016.00 $2,016.00 10‐100‐480070 Community Projects Donations $5,538.25 $5,538.25 $0.00 $5,538.25 $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 $11,899.76 $0.00 $11,899.76 $11,899.76 $11,899.76 10‐100‐481055 Street Repair‐Solid Waste Cntr $302,250.00 $175,000.00 $127,250.00 $302,250.00 $0.00 $0.00 10‐100‐481095 Cemetery Donations $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $308,288.25 $195,454.01 $127,250.00 $322,704.01 $14,415.76 $14,415.76 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 $40,178.70 $12,051.29 $52,229.99 $17,229.99 $17,229.99 10‐100‐481072 TIF Prof Svcs Deposit $1,181.25 $62,529.11 $0.00 $62,529.11 $61,347.86 $61,347.86 10‐100‐481074 Revenue Share ‐ Purchasing Card $18,000.00 $12,322.23 $6,504.70 $18,826.93 $826.93 $826.93 10‐100‐481077 Insurance Claims $20,000.00 $9,968.00 $6,627.43 $16,595.43 ($3,404.57)($3,404.57) 10‐100‐481078 Cafeteria Refunds $10,000.00 $0.00 $10,000.00 $10,000.00 $0.00 $0.00 $84,181.25 $135,455.87 $35,183.42 $170,639.29 $86,458.04 $86,458.04 Interest Income 10‐100‐470010 Interest $110,000.00 $116,063.40 $36,405.43 $152,468.83 $42,468.83 $42,468.83 $110,000.00 $116,063.40 $36,405.43 $152,468.83 $42,468.83 $42,468.83 Other Non Operating Revenue 10‐100‐485050 Sale Of Assets $54,000.00 $96,799.50 $20,000.00 $116,799.50 $62,799.50 $62,799.50 $54,000.00 $96,799.50 $20,000.00 $116,799.50 $62,799.50 $62,799.50 Operating Transfers In 10‐100‐490240 Trsfr From Lodging Tax $23,800.00 $16,202.98 $7,991.65 $24,194.63 $394.63 $394.63 10‐100‐490630 Transfer from Self Funded Hlth Ins $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $23,800.00 $16,202.98 $7,991.65 $24,194.63 $394.63 $394.63 $31,491,443.69 $22,788,919.41 $8,847,053.41 $31,635,972.82 $144,529.13 $144,529.13 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)$ (1,391,963.93)$ 2017 Release of Restricted Funds ‐ Parks Multipurpose Building 1,500,000.00$ FYE2017 ESTIMATED Unassigned Fund Balance 8,482,344.94$ FYE2017 ESTIMATED Fund Balance % of Adopted Budget 26.33% 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 Total 6,832,549.01 2,869,670.60 3,951,882.49 average monthly amount for 4 cent lockbox fund 51,705.78$ **Effective for 25 years starting in 2011 2017 Occupancy 2016 Occupancy 2015 Occupancy 2014 Occupancy 2013 Occupancy 2012 Occupancy January 48.70%51.30%45.90%49.20%45.30%38.20% February 56.80%58.60%51.20%56.00%52.90%49.80% March 62.20%59.80%59.80%59.30%52.90%54.90% April 62.40%67.20%58.10%63.70%64.10%53.90% May 63.80%64.90%63.10%64.70%56.80%53.70% June 70.40%64.00%59.70%63.70%55.70%53.10% July 58.20%60.80%59.70%58.50%51.40% August 56.50%52.60%54.20%55.80%47.00% September 62.60%63.30%61.20%63.00%59.30% October 62.90%60.70%67.60%65.90%59.30% November 50.60%51.30%48.90%52.40%43.40% December 42.10%45.10%38.30%38.80%33.00% COMPARATIVE OCCUPANCY RATE Tab 2 - Multi-Segment Currency: USD - US Dollar Missouri Hotel & Lodging Association For the month of: June 2017 Percent Change from June 2016 Percent Change from YTD 2016 2017 2016 2017 2016 2017 2016 Occ ADR RevPAR Room Rev Room Avail Room Sold 2017 2016 2017 2016 2017 2016 Occ ADR RevPAR Room Rev Room Avail Room Sold Census Sample Census Sample United States 73.4 72.8 129.12 126.50 94.73 92.14 0.7 2.1 2.8 4.7 1.9 2.6 65.4 64.9 126.01 123.13 82.35 79.92 0.7 2.3 3.0 4.9 1.8 2.5 54803 32880 5150350 3800350 West North Central 70.5 70.9 103.53 101.62 72.95 72.06 -0.6 1.9 1.2 2.6 1.4 0.7 56.3 56.9 95.82 94.21 53.98 53.62 -1.0 1.7 0.7 1.9 1.3 0.2 4600 2724 358545 261013 Missouri 73.4 73.0 103.33 99.81 75.82 72.90 0.5 3.5 4.0 4.5 0.4 0.9 60.0 60.1 97.99 94.21 58.75 56.65 -0.3 4.0 3.7 4.1 0.4 0.1 1113 644 101466 72447 Kansas City, MO-KS 78.1 76.1 106.33 102.43 83.01 77.91 2.6 3.8 6.5 4.9 -1.6 1.0 65.9 63.5 102.68 98.53 67.67 62.60 3.7 4.2 8.1 6.3 -1.7 2.0 291 229 32210 27538 St Louis, MO-IL 76.8 77.3 108.94 105.82 83.72 81.82 -0.6 3.0 2.3 3.9 1.6 0.9 65.5 65.7 104.25 100.44 68.23 66.03 -0.4 3.8 3.3 4.7 1.3 0.9 331 250 38517 33100 Columbia, MO+73.1 69.0 85.36 84.59 62.41 58.33 6.0 0.9 7.0 3.0 -3.8 2.0 60.7 60.4 86.41 87.16 52.48 52.67 0.5 -0.9 -0.4 -4.1 -3.8 -3.3 37 29 3708 3080 Jefferson City, MO+70.4 65.6 77.25 75.34 54.39 49.40 7.4 2.5 10.1 10.1 0.0 7.4 61.1 63.5 80.09 79.18 48.91 50.26 -3.8 1.2 -2.7 -2.7 0.0 -3.8 15 12 1494 1140 Springfield, MO 74.2 74.5 85.72 82.65 63.62 61.58 -0.4 3.7 3.3 3.2 -0.1 -0.5 61.5 61.0 82.75 79.78 50.86 48.65 0.8 3.7 4.5 4.4 -0.1 0.7 68 46 6088 4340 Branson, MO 69.8 67.5 112.15 106.23 78.32 71.72 3.4 5.6 9.2 9.1 -0.1 3.3 46.7 46.7 96.83 94.00 45.22 43.88 0.0 3.0 3.0 3.2 0.1 0.2 150 32 13551 4324 Lake of the Ozarks+65.2 65.3 115.31 111.66 75.23 72.90 -0.1 3.3 3.2 0.9 -2.2 -2.3 46.9 46.0 99.24 97.81 46.53 44.98 2.0 1.5 3.5 3.1 -0.4 1.6 36 11 2712 1544 Joplin, MO 76.0 71.6 85.00 81.93 64.56 58.64 6.1 3.7 10.1 10.0 -0.1 6.0 62.5 61.0 80.37 78.25 50.24 47.75 2.4 2.7 5.2 5.1 -0.1 2.3 30 23 2298 2009 Saint Joseph, MO+70.5 75.6 89.38 86.18 63.05 65.12 -6.6 3.7 -3.2 -3.2 0.0 -6.6 59.1 60.2 86.64 83.43 51.21 50.25 -1.9 3.9 1.9 1.9 0.0 -1.9 12 10 1106 999 A blank row indicates insufficient data.Source 2017 STR, Inc. Participation Occ % Current Month - June 2017 vs June 2016 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 2017 vs June 2016 RoomsRevPARPropertiesADR Tab 3 - Help All data is processed by STR using both the current and historical sampling of hotels. For further questions about the methodology used to produce our reports, please email destin@str.com. Average Daily Rate (ADR) Room revenue divided by rooms sold, displayed as the average rental rate for a single room. Census (properties and rooms) The number of properties and rooms that exist in our database for the area(s) or segment(s) shown on the report. Contract Rooms Contract rooms are occupied at rates stipulated by contracts – such as for airline crews and permanent guests. Room allotments that do not require guaranteed use or payment should not be classified as contract. Rooms sold under such allotments should be classified as transient. Country A geographic area that has internationally recognized boundaries, an organized economy, and a sovereign government with external recognition. It is typically recognized by the International Organization for Standardization (ISO). Custom Segments Defined by a + at the end of the segment name. If a custom segment is based on a selected group of properties, new properties that come into the area will NOT automatically be added to this segment. The new property can be added alone as long as it has no more than five months of data. Once the property has six or more months of data it is considered an established property, requiring a two property change (add one/drop one or add two). Demand (Rooms Sold) The number of rooms sold or rented (excludes complimentary rooms). Exchange Rate The factor used to convert revenue from U.S. Dollars to the local currency. The exchange rate data is obtained from Oanda.com. Any aggregated number in the report (YTD, Running 3 month, Running 12 month) uses the exchange rate of each relative month when calculating the data. Group Rooms Group rooms are sold simultaneously in blocks of a minimum of ten rooms or more (e.g. group tours, domestic and international groups, association, convention and corporate groups). Index Index (Occupancy, ADR, RevPar) - Property performance divided by competitive set performance multiplied by 100. Internationally, indexes are also referred to as MPI – Market Penetration Index (Occupancy Index), ARI – Average Rate Index (ADR Index), and RGI – Revenue/RevPAR Generation Index (RevPAR Index). Market A geographic area within a country. Markets are defined by STR and STR Global. Occupancy (Occ) Rooms sold divided by rooms available multiplied by 100. Occupancy is always expressed as a percentage of rooms occupied. Percent Change Amount of growth - up, flat, or down - this period versus same period last year (month or year-to-date). Calculated as ((TY - LY) / LY) * 100. Revenue (Room Revenue) Total room revenue generated from the sale or rental of rooms. RevPAR (Revenue Per Available Room) Room revenue divided by rooms available. Sample or % Room Participants The percent of rooms from which STR receives data. Calculated as (Sample Rooms/Census Rooms)* "100" Sub-Market A geographic sub-area within a Market. Sub-markets are defined by STR and STR Global. Supply (Rooms Available) The number of rooms times the number of days in the period. Transient Rooms Transient rooms Include rooms occupied by those with reservations at rack, corporate, corporate negotiated, package, government, or foreign traveler rates. Also includes occupied rooms booked via third party web sites (exception: simultaneous bookings of ten or more rooms which should be defined as group). Twelve Month Moving Average Measures (Occ, ADR, RevPAR, Supply, Demand, Revenue) are calculated using the sum of the values of the given month and of the preceding eleven months. WD (Weekday) Average of Sunday through Thursday WE (Weekend) Average of Friday and Saturday Measures (Occ, ADR, RevPAR, Supply, Demand, Revenue) are calculated using the sum of the values from January 1 of the given year.