HomeMy Public PortalAbout5-Clerk FY21 Streets LOT Revenue ProjectionsSTREETS LOT BUDGETED, ACTUAL, AND FORECASTED DOLLARS
Month
FY17
percentages
FY18
percentages
FY19
percentages
FY20
percentages
Average
percentage
FY21 Budget
dollars
FY21 actual
and forecast
based on
trend
Percentage
+/- based on
budget Actual total Budget total total +/- YTD
October 6.57%6.17%6.22%5.99%6.24%140,591 169,372 20.47%169,372 140,591 20.47%
November 4.85%4.75%4.53%4.85%4.75%106,983 125,859 17.64%295,231 247,574 19.25%
December 7.53%7.24%8.05%9.74%8.14%183,498 242,841 32.34%538,072 431,072 24.82%
1st Quarter Total 431,072 538,072 24.82%
January 6.12%6.45%6.62%6.75%6.49%146,191 167,940 14.88%706,012 577,263 22.30%
February 6.29%6.02%5.87%6.36%6.14%138,331 159,196 15.08%865,208 715,594 20.91%
March 5.69%5.88%7.60%5.98%6.29%141,774 257,429 81.58%1,122,637 857,368 30.94%
2nd Quarter Total 426,297 584,565 37.13%
April 4.19%3.90%3.78%2.38%3.56%80,262 116,236 44.82%1,238,873 937,630 32.13%
May 6.31%6.06%5.87%4.95%5.80%130,704 164,104 25.55%1,402,977 1,068,334 31.32%
June 10.92%11.40%12.55%12.21%11.77%265,305 382,297 44.10%1,785,274 1,333,639 33.86%
3rd Quarter Total 476,271 662,637 39.13%
July 15.66%15.48%14.44%13.75%14.83%334,331 363,171 8.63%2,148,445 1,667,970 28.81%
August 14.23%13.87%12.87%13.07%13.51%304,576 392,324 28.81%2,540,769 1,972,546 28.81%
September 11.63%12.77%11.60%13.97%12.49%281,593 362,719 28.81%2,903,489 2,254,139 28.81%
4th Quarter Total 920,500 1,118,215 21.48%
Total 100.00%100.00%100.00%100.00%100.00%2,254,139 2,903,489 128.81%
2,254,139 2,903,556
Year to date the actual revenues received for FY21 are 35.98% over the year to date revenues for FY20 and 54.98% over the 5 year average year to date.
1-Sep-21
October November December January February March April May June July August September
Average 118,983 90,741 157,302 119,638 114,098 113,898 67,671 107,538 214,768 272,070 247,415 219,552
Budget 140,591 106,983 183,498 146,191 138,331 141,774 80,262 130,704 265,305 334,331 304,576 281,593
FY21 Actual $169,372 $125,859 $242,841 $167,940 $159,196 $257,429 $116,236 $164,104 $382,297 $363,171 $0 $0
Forecast $392,324 $362,719
-
50,000
100,000
150,000
200,000
250,000
300,000
350,000
400,000
450,000
Streets LOT Budget Compared to FY21 Actual/Forecast
Average Budget FY21 Actual Forecast
-
50,000
100,000
150,000
200,000
250,000
300,000
350,000
400,000
450,000
1 2 3 4 5 6 7 8 9 10 11 12
Average FY16 FY17 FY18 FY19 FY20 FY21 Forecast
Five Year Actuals Comparison to
Month FY16 FY17 FY18 FY19 FY20 FY21 Totals
October - 108,126$ 112,469$ 126,495$ 128,843$ 169,372$ 645,305
November - 79,803$ 86,641$ 92,146$ 104,375$ 125,859$ 488,824
December 159 123,870$ 131,999$ 163,940$ 209,400$ 242,841$ 872,209
January 99,990$ 100,678$ 117,630$ 134,747$ 145,146$ 167,940$ 766,131
February 100,883$ 103,484$ 109,852$ 119,564$ 136,697$ 159,196$ 729,676
March 85,338$ 93,631$ 107,286$ 154,713$ 128,607$ 257,429$ 827,004
April 70,264$ 68,894$ 71,020$ 76,837$ 51,267$ 116,236$ 454,518
May 97,418$ 103,831$ 110,511$ 119,402$ 106,530$ 164,104$ 701,796
June 168,831$ 179,572$ 207,941$ 255,465$ 262,485$ 382,297$ 1,456,591
July 235,029$ 257,593$ 282,181$ 293,877$ 295,744$ 363,171$ 1,727,595
August 208,024$ 234,143$ 252,909$ 262,015$ 281,043$ 1,238,134
September 169,309$ 191,252$ 232,677$ 236,107$ 309,759$ 1,139,104
Total Dollars Received $1,235,245 $1,644,877 $1,823,116 $2,035,308 $2,159,896 $2,148,445 11,046,887
Difference compared to prior year $409,632 $178,239 $212,192 $124,588 -$11,451 913,200
Percent of change 33%11%12%6%-1%1
Budgeted Dollars $700,000 $1,500,000 $1,500,000 $1,933,772 $2,100,000 $2,100,000 9,833,772
Streets LOT Actual Dollars Earned per Month