Loading...
HomeMy Public PortalAbout2014-07 Meeting - Sales Tax ReportMemo To:Steve Crowell From:Shiela Pearre Date:July 7, 2014 Re:Sales Tax Revenues The City received the June 1% Sales Tax in the amount of $1,048,754 which is $176,318 more than projected for July. January thru July overage is $220,450 (2.29%) in the General Fund. 1% General Sales Tax Receipt Budget Actual Period Projection Receipts Variance Nov-13 Jan-14 $764,659 $741,056 ($23,603) Dec-13 Feb-14 $703,181 $789,830 $86,649 Jan-14 & Oct-Dec 13 Qtrly Mar-14 $1,008,111 $920,599 ($87,512) Feb-14 Apr-14 $777,424 $737,482 ($39,942) Mar-14 May-14 $537,141 $802,765 $265,624 Apr-14 & Jan-Mar 14 Qtrly Jun-14 $1,023,015 $865,930 ($157,085) May-14 Jul-14 $872,436 $1,048,754 $176,318 Jun-14 Aug-14 $546,351 Jul-14 & Apr-June 14 Qtrly Sep-14 $1,096,581 Aug-14 Oct-14 $717,262 Sep-14 Nov-14 $677,366 Oct-14 & Jul-Sept 14 Qtrly Dec-14 $916,473 Total Overage/Shortfall $220,450 1/2% Capital Improvement Tax Receipt Budget Actual Period Projection Receipts Variance Nov-13 Jan-14 $416,244 $359,800 ($56,444) Dec-13 Feb-14 $311,418 $394,475 $83,057 Jan-14 & Oct-Dec 13 Qtrly Mar-14 $471,169 $423,641 ($47,528) Feb-14 Apr-14 $413,147 $348,172 ($64,975) Mar-14 May-14 $266,340 $399,863 $133,523 Apr-14 & Jan-Mar 14 Qtrly Jun-14 $499,328 $416,943 ($82,385) May-14 Jul-14 $393,021 $503,869 $110,848 Jun-14 Aug-14 $280,801 Jul-14 & Apr-June 14 Qtrly Sep-14 $508,966 Aug-14 Oct-14 $370,760 Sep-14 Nov-14 $268,825 Oct-14 & Jul-Sept 14 Qtrly Dec-14 $499,981 Total Overage/Shortfall $76,096 1/2% Parks Sales Tax Receipt Budget Actual Period Projection Receipts Variance Nov-13 Jan-14 $372,447 $359,708 ($12,739) Dec-13 Feb-14 $350,714 $393,562 $42,848 Jan-14 & Oct-Dec 13 Qtrly Mar-14 $475,026 $423,546 ($51,480) Feb-14 Apr-14 $372,242 $348,076 ($24,166) Mar-14 May-14 $266,456 $398,085 $131,629 Apr-14 & Jan-Mar 14 Qtrly Jun-14 $482,382 $416,845 ($65,537) May-14 Jul-14 $425,194 $503,790 $78,596 Jun-14 Aug-14 $272,321 Jul-14 & Apr-June 14 Qtrly Sep-14 $521,155 Aug-14 Oct-14 $357,482 Sep-14 Nov-14 $323,768 Oct-14 & Jul-Sept 14 Qtrly Dec-14 $419,277 Total Overage/Shortfall $99,150 Period Reporting Period Reporting Period Reporting City of Jefferson, Mo. - Account Analysis Printed 7/7/2014 Account Name General Fund Sales Tax Rate:One percent (1%)Receipt Month: JULY 2014 Account Number 10-100-400010 Monthly REPORTING PERIOD RECEIPT PERIOD 2009 2010 2011 2012 2013 2014 Average Nov January 787,676 928,460 809,385 843,061 764,659 741,056 act.826,648 Dec February 572,813 631,137 833,919 619,287 703,181 789,830 act.672,067 Jan & Oct-Dec Qtrly March 1,079,246 894,158 589,958 992,559 1,008,111 920,599 act.912,806 Feb April 763,906 774,964 978,391 852,653 777,424 737,482 act.829,468 Mar May 516,016 592,657 633,676 530,069 537,141 802,765 act.561,912 Apr & Jan-Mar Qtrly June 934,660 843,712 925,555 1,028,514 1,023,015 865,930 act.951,091 May July 686,153 939,495 955,495 797,785 872,436 1,048,754 act.850,273 Jun August 526,097 495,667 566,299 557,032 546,351 546,351 est.538,289 Jul & Apr-Jun Qtrly September 1,006,120 1,040,156 1,032,258 1,069,414 1,096,581 1,096,581 est.1,048,906 Aug October 718,480 822,163 797,510 769,129 717,262 717,262 est.764,909 Sept November 554,824 482,807 536,185 615,421 677,366 677,366 est.573,321 Oct & Jul-Sept Qtrly December 801,780 881,780 1,032,046 982,684 932,387 916,473 est.926,135 Actual to Date $ 8,947,771 $ 9,327,157 $ 9,690,677 $ 9,657,608 $ 9,655,913 5,906,417 Estimated to Fiscal Year end (based on averages and on Budgeted amount)3,954,033 Total Actual & Estimated $ 9,860,450 Less: Budget 9,640,000 Over (Under) Budget $ 220,450 $ 741,056.45 $ 1,530,886.91 $ 2,451,485.95 $ 3,188,968.08 $ 3,991,732.73 $ 4,857,663.18 $ 5,906,417.41 $ 764,659.19 $1,467,840.39 $2,475,951.79 $3,253,375.33 $3,790,516.42 $4,813,531.75 $5,685,967.41 $6,232,318.77 $7,328,899.63 $8,046,161.24 $8,723,526.86 $9,640,000.00 $ 500,000.00 $ 750,000.00 $ 1,000,000.00 $ 1,250,000.00 $ 1,500,000.00 $ 1,750,000.00 $ 2,000,000.00 $ 2,250,000.00 $ 2,500,000.00 $ 2,750,000.00 $ 3,000,000.00 $ 3,250,000.00 $ 3,500,000.00 $ 3,750,000.00 $ 4,000,000.00 $ 4,250,000.00 $ 4,500,000.00 $ 4,750,000.00 $ 5,000,000.00 $ 5,250,000.00 $ 5,500,000.00 $ 5,750,000.00 $ 6,000,000.00 $ 6,250,000.00 $ 6,500,000.00 $ 6,750,000.00 $ 7,000,000.00 $ 7,250,000.00 $ 7,500,000.00 $ 7,750,000.00 $ 8,000,000.00 $ 8,250,000.00 $ 8,500,000.00 $ 8,750,000.00 $ 9,000,000.00 $ 9,250,000.00 $ 9,500,000.00 $ 9,750,000.00 $ 10,000,000.00 $ 10,250,000.00 Nov Dec Jan & Oct- Dec Qtrly Feb Mar Apr & Jan- Mar Qtrly May Jun Jul & Apr- Jun Qtrly Aug Sept Oct & Jul- Sept Qtrly REPORTING PERIOD YTD Actuals vs. YTD Budget Actual Budget City of Jefferson, Mo. - Account Analysis Printed 7/7/2014 Account Name Capital Imprs Sales Tax Rate:One-Half percent (½%)Receipt Month: JULY 2014 Account Number 44-100-400010 F - effective 4/1/12 Monthly REPORTING PERIOD RECEIPT PERIOD 2009 2010 2011 2012 2013 2014 Average Nov January 384,327 455,480 396,799 412,434 372,459 359,800 act.404,300 Dec February 286,909 313,836 407,407 308,567 350,813 394,475 act.333,506 Jan & Oct-Dec Qtrly March 505,185 415,473 280,758 466,856 475,110 423,641 act.428,677 Feb April 365,514 370,473 452,824 409,365 372,340 348,172 act.394,103 Mar May 257,313 295,545 315,165 263,902 266,422 399,863 act.279,669 Apr & Jan-Mar Qtrly June 453,788 400,667 439,298 494,757 483,070 416,943 act.454,316 May July 326,501 462,244 468,643 389,423 425,325 503,869 act.414,427 Jun August 261,707 247,260 282,859 278,231 272,603 280,801 est.268,532 Jul & Apr-Jun Qtrly September 481,799 495,398 482,244 504,307 521,260 508,966 est.497,002 Aug October 348,002 395,058 382,206 367,366 357,619 370,760 est.370,050 Sept November 276,487 240,417 266,364 306,968 323,871 268,825 est.282,821 Oct & Jul-Sept Qtrly December 384,320 428,058 495,406 469,095 443,688 499,981 est.444,113 Actual to Date $ 4,331,852 $ 4,519,908 $ 4,669,974 $ 4,671,272 $ 4,664,580 2,846,763 Estimated to Fiscal Year end (based on averages and on Budgeted amount)1,929,333 Total Actual & Estimated $ 4,776,096 Less: Budget 4,700,000 Over (Under) Budget $ 76,096 $ 359,799.94 $ 754,275.37 $ 1,177,916.24 $ 1,526,088.37 $ 1,925,951.58 $ 2,342,894.17 $ 2,846,763.19 $ 416,244.00 $727,662.00 $1,198,831.00 $1,611,978.00 $1,878,318.00 $2,377,646.00 $2,770,667.00 $3,051,468.00 $3,560,434.00 $3,931,194.00 $4,200,019.00 $4,700,000.00 $ 100,000.00 $ 350,000.00 $ 600,000.00 $ 850,000.00 $ 1,100,000.00 $ 1,350,000.00 $ 1,600,000.00 $ 1,850,000.00 $ 2,100,000.00 $ 2,350,000.00 $ 2,600,000.00 $ 2,850,000.00 $ 3,100,000.00 $ 3,350,000.00 $ 3,600,000.00 $ 3,850,000.00 $ 4,100,000.00 $ 4,350,000.00 $ 4,600,000.00 $ 4,850,000.00 $ 5,100,000.00 Nov Dec Jan & Oct- Dec Qtrly Feb Mar Apr & Jan- Mar Qtrly May Jun Jul & Apr- Jun Qtrly Aug Sept Oct & Jul- Sept Qtrly REPORTING PERIOD YTD Actuals vs. YTD Budget Actual Budget City of Jefferson, Mo. - Account Analysis Printed 7/7/2014 Account Name Parks Sales Tax Rate:One-Half percent (½%)Receipt Month: JULY 2014 Account Number 21-210-400010 Monthly REPORTING PERIOD RECEIPT PERIOD 2009 2010 2011 2012 2013 2014 Average Nov January 384,305 455,442 396,815 405,730 372,447 359,708 act.402,948 Dec February 286,889 313,792 407,348 308,456 350,714 393,562 act.333,440 Jan & Oct-Dec Qtrly March 507,768 415,275 280,734 466,713 475,026 423,546 act.429,103 Feb April 365,727 370,308 452,735 409,353 372,242 348,076 act.394,073 Mar May 256,675 295,529 315,030 263,822 266,456 398,085 act.279,502 Apr & Jan-Mar Qtrly June 453,016 400,500 439,265 494,733 482,382 416,845 act.453,979 May July 326,518 461,255 468,387 389,006 425,194 503,790 act.414,072 Jun August 261,622 247,216 282,836 278,072 272,321 272,321 est.268,413 Jul & Apr-Jun Qtrly September 481,772 495,222 482,150 505,913 521,155 521,155 est.497,242 Aug October 347,721 395,014 382,115 366,846 357,482 357,482 est.369,836 Sept November 275,469 240,348 264,735 306,831 323,768 323,768 est.282,230 Oct & Jul-Sept Qtrly December 384,300 428,200 495,305 468,924 443,569 419,277 est.444,060 Actual to Date $ 4,331,782 $ 4,518,100 $ 4,667,453 $ 4,664,400 $ 4,662,755 2,843,611 Estimated to Fiscal Year end (based on averages and on Budgeted amount)1,894,003 Total Actual & Estimated $ 4,737,614 Less: Budget 4,638,464 Over (Under) Budget $ 99,150 $ 359,708.18 $ 753,270.03 $ 1,176,815.59 $ 1,524,891.51 $ 1,922,976.56 $ 2,339,821.20 $ 2,843,610.78 $ 372,447.00 $723,161.00 $1,198,187.00 $1,570,429.00 $1,836,885.00 $2,319,267.00 $2,744,461.00 $3,016,782.00 $3,537,937.00 $3,895,419.00 $4,219,187.00 $4,638,464.00 $ 100,000.00 $ 350,000.00 $ 600,000.00 $ 850,000.00 $ 1,100,000.00 $ 1,350,000.00 $ 1,600,000.00 $ 1,850,000.00 $ 2,100,000.00 $ 2,350,000.00 $ 2,600,000.00 $ 2,850,000.00 $ 3,100,000.00 $ 3,350,000.00 $ 3,600,000.00 $ 3,850,000.00 $ 4,100,000.00 $ 4,350,000.00 $ 4,600,000.00 $ 4,850,000.00 $ 5,100,000.00 Nov Dec Jan & Oct- Dec Qtrly Feb Mar Apr & Jan- Mar Qtrly May Jun Jul & Apr- Jun Qtrly Aug Sept Oct & Jul- Sept Qtrly REPORTING PERIOD YTD Actuals vs. YTD Budget Actual Budget