HomeMy Public PortalAbout8-Clerk Streets LOT Revenue ProjectionsSTREETS 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 127,555 6.94%127,555 119,282 6.94%
November 4.85%4.75%91,890 92,146 0.28%219,701 211,172 4.04%
December 7.53%7.24%139,995 163,986 17.14%383,687 351,167 9.26%
1st Quarter Total 351,167 383,687 9.26%
January 6.12%6.45%124,756 134,600 7.89%518,287 475,923 8.90%
February 6.29%6.02%116,507 119,391 2.48%637,678 592,430 7.64%
March 5.69%5.88%113,785 152,240 33.80%789,918 706,216 11.85%
2nd Quarter Total 355,048 406,231 14.42%
April 4.19%3.90%75,322 84,248 11.85%874,166 781,538 11.85%
May 6.31%6.06%117,206 131,095 11.85%1,005,261 898,744 11.85%
June 10.92%11.40%220,538 246,672 11.85%1,251,932 1,119,282 11.85%
3rd Quarter Total 413,066 462,014 11.85%
July 15.66%15.48%299,275 334,740 11.85%1,586,672 1,418,557 11.85%
August 14.23%13.87%268,230 300,015 11.85%1,886,687 1,686,787 11.85%
September 11.63%12.77%246,985 276,252 11.85%2,162,940 1,933,772 11.85%
4th Quarter Total 814,490 911,007 11.85%
Total 100.00%100.00%1,933,772 2,162,940 111.85%
1,933,772 2,162,924
2-May-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
$163,986 $134,600 $119,391 $152,240 $0 $0 $0 $0 $0 $0FY19 Actual $127,555
Forecast $127,555
$92,146
$84,248 $131,095 $246,672 $334,740 $300,015 $276,252
$0
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
$350,000
$400,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
400,000
October November December January February March April May June July August September
FY16 FY17 FY18 FY19 FY20 Forecast
Three Year Actuals Comparison