Loading...
HomeMy Public PortalAbout5-FY20 Streets LOT Revenue ProjectionsSTREETS LOT BUDGETED, ACTUAL, AND FORECASTED DOLLARS Month FY17 percentages FY18 percentages FY19 percentages Average percentage October 6.57% 6.17% 6.22% 6.32% November 4.85% 4.75% 4.53% 4.71% December 7.53% 7.24% 8.05% 7.61% January 6.12% 6.45% 6.62% 6.40% February 6.29% 6.02% 5.87% 6.06% March 5.69% 5.88% 7.60% 6.39% April 4.19% 3.90% 3.78% 3.95% May 6.31% 6.06% 5.87% 6.08% June 10.92% 11.40% 12.55% 11.62% July 15.66% 15.48% 14.44% 15.19% August 14.23% 13.87% 12.87% 13.66% September 11.63% 12.77% 11.60% 12.00% Total 100.00% 100.00% 100.00% 100.00% 3-Apr-20 1st Quarter Tota l 2nd Quarter Total 3rd Quarter Total 4th Quarter Total FY20 Budget dollars FY20 actual and forecast based on trend Percentage +/- based on budget Actual total Budget total total +/- YTD 132,698 128,835 -2.91% 128,835 132,698 -2.91% 98,916 104,375 5.52% 233,210 231,614 0.69% 159,774 209,229 30.95% 442,439 391,388 13.04% 391,388 442,439 13.04% 134,348 143,694 6.96% 586,133 525,737 11.49% 127,334 133,005 4.45% 719,138 653,071 10.12% 134,245 147,831 10.12% 395,928 424,530 7.22% 83,011 91,412 10.12% 127,679 140,601 10.12% 244,113 268,817 10.12% 454,803 500,829 10.12% 319,029 351,314 10.12% 286,853 315,883 10.12% 251,999 277,501 10.12% 857,881 944,698 10.12% 2,100,000 2,312,496 110.12% 2,100,000 000 Streets LOT Budget Compared to FY20 Actual/Forecast Y7'W J, 000 $350,000 $300,000 $250,000 n �7 $200,000 - $150,000 11 ■ $100,000 ■ $50,000 $0 October November December January February March April May June July August September 0 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 i.FY20Actual $128,835 $104,318 $209,229 $143,694 $133,005 $0 $0 $0 $0 $0 $0 $0 Forecast $127,582 $102,313 $204,993 $141,625 $133,005 $147,831 $91,412 $140,601 $268,817 $351,314 $315,883 $277,501 0 Budget FY20 Actual tForecast 0 Budget FY20 Actual tForecast 400,000 350,000 300,000 250,000 200,000 150,000 100,000 50,000 Five Year Actuals Comparison ■ 1 2 3 4 5 6 7 8 ■ FY16 ❑ FY17 FY18 ❑ FY19 ■ FY20 ❑ FY20 9 L 10 11 12 Streets LOT Actual Dollars Earned per Month I_ October - $ 108,126 $ 112,469 $ 126,495 $ 128,835 475,925 November - $ 79,803 $ 86,641 $ 92,146 $ 104,375 362,965 December 159 $ 123,870 $ 131,999 $ 163,940 $ 209,229 629,197 January $ 99,990 $ 100,678 $ 117,630 $ 134,747 $ 143,694 596,739 February $ 100,883 $ 103,484 $ 109,852 $ 119,564 $ 133,005 566,788 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 $719,138 7,457,684 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