Loading...
HomeMy Public PortalAbout5-Clerk FY20 Streets LOT Revenue ProjectionsSTREETS LOT BUDGETED, ACTUAL, AND FORECASTED DOLLARS Month FY17 percentages FY18 percentages FY19 percentages Average percentage FY20 Budget dollars FY20 actual and forecast based on trend Percentage +/- based on budget Actual total Budget total total +/- YTD October 6.57%6.17%6.22%6.32%132,698 128,849 -2.90%128,849 132,698 -2.90% November 4.85%4.75%4.53%4.71%98,916 102,313 3.43%231,162 231,614 -0.20% December 7.53%7.24%8.05%7.61%159,774 159,455 -0.20%390,617 391,388 -0.20% 1st Quarter Total 391,388 390,617 -0.20% January 6.12%6.45%6.62%6.40%134,348 134,080 -0.20%524,696 525,737 -0.20% February 6.29%6.02%5.87%6.06%127,334 127,080 -0.20%651,776 653,071 -0.20% March 5.69%5.88%7.60%6.39%134,245 133,976 -0.20%785,753 787,316 -0.20% 2nd Quarter Total 395,928 395,136 -0.20% April 4.19%3.90%3.78%3.95%83,011 82,845 -0.20%868,597 870,327 -0.20% May 6.31%6.06%5.87%6.08%127,679 127,424 -0.20%996,022 998,006 -0.20% June 10.92%11.40%12.55%11.62%244,113 243,625 -0.20%1,239,646 1,242,119 -0.20% 3rd Quarter Total 454,803 453,894 -0.20% July 15.66%15.48%14.44%15.19%319,029 318,391 -0.20%1,558,037 1,561,148 -0.20% August 14.23%13.87%12.87%13.66%286,853 286,279 -0.20%1,844,316 1,848,001 -0.20% September 11.63%12.77%11.60%12.00%251,999 251,495 -0.20%2,095,811 2,100,000 -0.20% 4th Quarter Total 857,881 856,165 -0.20% Total 100.00%100.00%100.00%100.00%2,100,000 2,095,811 99.80% 2,100,000 2,095,800 2-Jan-20 October November December January February March April May June July August September Budget $132,698 $98,916 $159,774 $134,348 $127,334 $134,245 $83,011 $127,679 $244,113 $319,029 $286,853 $251,999 FY20 Actual $128,849 $102,313 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Forecast $127,582 $102,313 $159,455 $134,080 $127,080 $133,976 $82,845 $127,424 $243,625 $318,391 $286,279 $251,495 $0 $50,000 $100,000 $150,000 $200,000 $250,000 $300,000 $350,000 Streets LOT Budget Compared to FY20 Actual/Forecast Budget FY20 Actual Forecast - 50,000 100,000 150,000 200,000 250,000 300,000 350,000 1 2 3 4 5 6 7 8 9 10 11 12 FY16 FY17 FY18 FY19 FY20 FY20 Five Year Actuals Comparison Month FY16 FY17 FY18 FY19 FY20 Totals October - 108,126$ 112,469$ 126,495$ 128,849$ 475,939 November - 79,803$ 86,641$ 92,146$ 102,313$ 360,903 December 159 123,870$ 131,999$ 163,940$ 419,968 January 99,990$ 100,678$ 117,630$ 134,747$ 453,045 February 100,883$ 103,484$ 109,852$ 119,564$ 433,783 March 85,338$ 93,631$ 107,286$ 154,713$ 440,968 April 70,264$ 68,894$ 71,020$ 76,837$ 287,015 May 97,418$ 103,831$ 110,511$ 119,402$ 431,162 June 168,831$ 179,572$ 207,941$ 255,465$ 811,809 July 235,029$ 257,593$ 282,181$ 293,877$ 1,068,680 August 208,024$ 234,143$ 252,909$ 262,015$ 957,091 September 169,309$ 191,252$ 232,677$ 236,107$ 829,345 Total Dollars Received $1,235,245 $1,644,877 $1,823,116 $2,035,308 $231,162 6,969,708 Difference compared to prior year $409,632 $178,239 $212,192 Percent of change 33%11%12%0%0 Budgeted Dollars $700,000 $1,500,000 $1,500,000 $1,933,772 $2,100,000 Streets LOT Actual Dollars Earned per Month