Loading...
HomeMy Public PortalAbout7- Clerk FY21 Streets LOT Revenue ProjectionsSTREETS LOT BUDGETED, ACTUAL, AND FORECASTED DOLLARS Month FY17 percentages FY18 percentages FY19 percentages FY20 percentages Average percentage October 6.57% 6.17% 6.22% 5.99% 6.24% November 4.85% 4.75% 4.53% 4.85% 4.75% December 7.53% 7.24% 8.05% 9.74% 8.14% January 6.12% 6.45% 6.62% 6.75% 6.49% February 6.29% 6.02% 5.87% 6.36% 6.14% March 5.69% 5.88% 7.60% 5.98% 6.29% April 4.19% 3.90% 3.78% 2.38% 3.56% May 6.31% 6.06% 5.87% 4.95% 5.80% June 10.92% 11.40% 12.55% 12.21% 11.77% July 15.66% 15.48% 14.44% 13.75% 14.83% August 14.23% 13.87% 12.87% 13.07% 13.51% September 11.63% 12.77% 11.60% 13.97% 12.49% Total 100.00% 100.00% 100.00% 100.00% 100.00% FY21 Budget dollars FY21 actual and forecast based on trend Percentage +/- based on budget Actual total Budget total total +1- YTD 123,522 154,595 25.16% 154,595 123,522 25.16% 89,980 106,584 18.45% 160,086 189,627 18.45% 373,588 450,806 20.67% 131,580 15 5, 860 18.45% 116,754 138,298 18.45% 151,076 17 8, 95 5 18.45% 399,410 473,113 18.45% 75,031 88,876 18.45% 116,595 138,111 18.45% 249,460 295,493 18.45% 441,086 522,480 18.45% 286,969 339,924 18.45% 255,856 303,069 18.45% 230,557 273,102 18.45% 773,383 916,095 18.45% 1,987,467 2,362,494 125.16% 1,987,467 1st Quarter Total 2nd Quarter Total 3rd Quarter Total 4th Quarter Total Year to date the actual revenues received for FY21 are 19.99% over the year to date revenues for FY20 and 29.93% over the 5 year average year to date. 25 -Nov -20 Streets LOT Budget Compared to FY21 Actual/Forecast QMJJ, VVV $350,000 $300,000 $250,000 $200,000 $150,000 $100,000 ❑ ■ $50,000 $0 October November December January February March April May June July August September o 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 FY21 Actual $154,595 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Forecast $154,595 $106,584 $189,627 $155,860 $138,298 $178,955 $88,876 $138,111 $295,493 $339,924 $303,069 $273,102 0 Budget fFY21 Actual -M-Forecast 400,000 Five Year Actuals Comparison 350,000 300,000 250,000 200,000 150,000 100,000 50,000 [ 1 F I I r 7 I r I 2 3 4 5 6 7 8 9 10 11 12 ■ FY16 ■ FY17 ■ FY18 0 FY19 ■ FY21 ❑ FY21 Streets LOT Actual Dollars Earned per Month n h FY16 FY17 FY18 FY19 FY20 FY21 October - $ 108,126 $ 112,469 $ 126,495 $ 128,843 $ 154,595 475,933 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,146 598,191 February $ 100,883 $ 103,484 $ 109,852 $ 119,564 $ 136,697 570,480 March $ 85,338 $ 93,631 $ 107,286 $ 154,713 $ 128,607 569,575 April $ 70,264 $ 68,894 $ 71,020 $ 76,837 $ 51,267 338,282 May $ 97,418 $ 103,831 $ 110,511 $ 119,402 $ 106,530 537,692 June $ 168,831 $ 179,572 $ 207,941 $ 255,465 $ 262,485 1,074,294 July $ 235,029 $ 257,593 $ 282,181 $ 293,877 $ 295,744 1,364,424 August $ 208,024 $ 234,143 $ 252,909 $ 262,015 $ 281,043 1,238,134 September $ 169,309 $ 191,252 $ 232,677 $ 236,107 $ 300,413 1,129,758 Total Dollars Received $1,235,245 $1,644,877 $1,823,116 $2,035,308 $2,150,550 $154,595 8,889,096 Difference compared to prior year $409,632 $178,239 $212,192 $115,242 -$1,995,955 Percent of change 33% 11% 12% 6% -93% 0 Budgeted Dollars $700,000 $1,500,000 $1,500,000 $1,933,772 $2,100,000 $2,100,000