Loading...
HomeMy Public PortalAbout4-Clerk FY20 Streets LOT Revenue Projections MaySTREETS 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% 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,836 -2.91% 128,836 132,698 -2.91% 98,916 104,375 5.52% 233,211 231,614 0.69% 159,774 209,400 31.06% 442,611 391,388 13.09% 391,388 442,611 13.09% 134,348 145,638 8.40% 588,249 525,737 11.89% 127,334 136,283 7.03% 724,532 653,071 10.94% 134,245 128,138 -4.55% 852,670 787,316 8.30% 395,928 410,059 3.57% 83,011 51,267 -38.24% 903,937 870,327 3.86% 127,679 104,829 -17.90% 1,008,766 998,006 1.08% 244,113 246,749 1.08% 454,803 402,845 -11.42% 319,029 322,474 1.08% 286,853 289,951 1.08% 251,999 254,721 1.08% 857,881 867,146 1.08% 2,100,000 2,122,661 101.08% 2,100,000 Year to date the actual revenues received for FY20 are 2.12% over the year to date revenues for FY19 and 18.22% over the 4 year average year to date. 1-Jul-20 $350,000 $300,000 $250,000 $200,000 $150,000 $100,000 $50,000 $0 Streets LOT Budget Compared to FY20 Actual/Forecast 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 ,iii,FY20 Actual $128,836 $104,375 $209,400 $145,638 $136,283 $128,138 $51,267 $104,829 $0 $0 $0 $0 Forecast $128,835 $104,375 $209,400 $143,768 $134,509 $126,282 $49,516 $104,829 $246,749 $322,474 $289,951 $254,721 ❑ Budget fFY20 Actual --Forecast 350,000 300,000 250,000 200,000 150,000 100,000 50,000 Five Year Actuals Comparison 1 ■ L1 ■ ■ ft 1 i MEmm ik L 2 3 4 5 6 7 8 9 10 11 12 • FY16 ❑ FY17 FY18 0 FY19 • FY20 0 FY20 Streets LOT Actual Dollars Earned per Month I_ October - $ 108,126 $ 112,469 $ 126,495 $ 128,836 475,926 November - $ 79,803 $ 86,641 $ 92,146 $ 104,375 362,965 December 159 $ 123,870 $ 131,999 $ 163,940 $ 209,400 629,368 January $ 99,990 $ 100,678 $ 117,630 $ 134,747 $ 145,638 598,683 February $ 100,883 $ 103,484 $ 109,852 $ 119,564 $ 136,283 570,066 March $ 85,338 $ 93,631 $ 107,286 $ 154,713 $ 128,138 569,106 April $ 70,264 $ 68,894 $ 71,020 $ 76,837 $ 51,267 338,282 May $ 97,418 $ 103,831 $ 110,511 $ 119,402 $ 104,829 535,991 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 $1,008,766 7,747,312 Difference compared to prior year $409,632 $178,239 $212,192 -$1,026,542 Percent of change 33% 11% 12% -50% 0 Budgeted Dollars $700,000 $1,500,000 $1,500,000 $1,933,772 $2,100,000