HomeMy Public PortalAbout5-Clerk FY19 Final Streets LOT Revenue ProjectionsMonth FY16 FY17 FY18 FY19 Totals
October - 108,126$ 112,469$ 126,495$ 347,090
November - 79,803$ 86,641$ 92,146$ 258,590
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,242$ 957,318
September 169,309$ 191,252$ 232,677$ 238,744$ 831,982
Total Dollars Received $1,235,245 $1,644,877 $1,823,116 $2,038,172 6,741,410
Difference compared to prior year $409,632 $178,239 $215,056
Percent of change 33%11%12%0
Budgeted Dollars $700,000 $1,500,000 $1,500,000 $1,933,772
Streets LOT Actual Dollars Earned per Month
STREETS LOT BUDGETED, ACTUAL, AND FORECASTED DOLLARS
Month
FY17
percentages
FY18
percentages
FY19 Budget
dollars
FY19 actual
and forecast
based on trend
Percentage
+/- based on
budget Actual total Budget total total +/- YTD
October 6.57%6.17%119,282 126,495 6.05%126,495 119,282 6.05%
November 4.85%4.75%91,890 92,146 0.28%218,641 211,172 3.54%
December 7.53%7.24%139,995 163,940 17.10%382,581 351,167 8.95%
1st Quarter Total 351,167 382,581 8.95%
January 6.12%6.45%124,756 134,747 8.01%517,328 475,923 8.70%
February 6.29%6.02%116,507 119,564 2.62%636,892 592,430 7.50%
March 5.69%5.88%113,785 154,713 35.97%791,605 706,216 12.09%
2nd Quarter Total 355,048 409,024 15.20%
April 4.19%3.90%75,322 76,837 2.01%868,442 781,538 11.12%
May 6.31%6.06%117,206 119,402 1.87%987,844 898,744 9.91%
June 10.92%11.40%220,538 255,465 15.84%1,243,309 1,119,282 11.08%
3rd Quarter Total 413,066 451,704 9.35%
July 15.66%15.48%299,275 293,877 -1.80%1,537,186 1,418,557 8.36%
August 14.23%13.87%268,230 262,242 -2.23%1,799,428 1,686,787 6.68%
September 11.63%12.77%246,985 238,744 -3.34%2,038,172 1,933,772 5.40%
4th Quarter Total 814,490 794,863 -2.41%
Total 100.00%100.00%1,933,772 2,038,172 105.40%
1,933,772 2,038,196
26-Nov-19
October November December January February March April May June July August September
Budget $98,603 $72,774 $112,959 $91,811 $94,369 $85,384 $62,826 $94,686 $163,756 $234,905 $213,520 $174,407
FY19 Actual $126,495 $92,146 $163,940 $134,747 $119,564 $154,713 $76,837 $119,402 $255,465 $293,877 $262,242 $238,744
Forecast $126,495 $92,146 $163,940 $134,747 $119,564 $154,713 $76,837 $119,402 $255,465 $293,877 $262,242 $238,744
$0
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
$350,000
Streets LOT Budget Compared to FY16 Actual/Forecast
Budget FY19 Actual Forecast
-
50,000
100,000
150,000
200,000
250,000
300,000
350,000
October November December January February March April May June July August September
FY16 FY17 FY18 FY19 FY20 Forecast
Four Year Actuals Comparison