HomeMy Public PortalAbout4-Clerk FY19 Streets LOT Revenue Projections AprilSTREETS 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,681 7.96%518,368 475,923 8.92%
February 6.29%6.02%116,507 119,471 2.54%637,839 592,430 7.66%
March 5.69%5.88%113,785 154,035 35.37%791,874 706,216 12.13%
2nd Quarter Total 355,048 408,187 14.97%
April 4.19%3.90%75,322 75,554 0.31%867,428 781,538 10.99%
May 6.31%6.06%117,206 130,087 10.99%997,515 898,744 10.99%
June 10.92%11.40%220,538 244,775 10.99%1,242,290 1,119,282 10.99%
3rd Quarter Total 413,066 450,416 9.04%
July 15.66%15.48%299,275 332,166 10.99%1,574,456 1,418,557 10.99%
August 14.23%13.87%268,230 297,709 10.99%1,872,165 1,686,787 10.99%
September 11.63%12.77%246,985 274,128 10.99%2,146,293 1,933,772 10.99%
4th Quarter Total 814,490 904,003 10.99%
Total 100.00%100.00%1,933,772 2,146,293 110.99%
1,933,772 2,146,294
3-Jun-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 $127,555 $92,146 $163,986 $134,681 $119,471 $154,035 $75,554 $0 $0 $0 $0 $0
Forecast $127,555 $92,146 $163,986 $134,681 $119,471 $154,035 $75,554 $130,087 $244,775 $450,416 $332,166 $297,709
$0
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
$350,000
$400,000
$450,000
$500,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
450,000
500,000
October November December January February March April May June July August September
FY16 FY17 FY18 FY19 FY20 Forecast
Three Year Actuals Comparison
Month FY16 FY17 FY18 FY19 Totals
October - 108,126$ 112,469$ 127,555$ 220,595
November - 79,803$ 86,641$ 92,146$ 166,444
December 159 123,870$ 131,999$ 163,986$ 256,028
January 99,990$ 100,678$ 117,630$ 134,681$ 318,298
February 100,883$ 103,484$ 109,852$ 119,471$ 314,219
March 85,338$ 93,631$ 107,286$ 154,035$ 286,255
April 70,264$ 68,894$ 71,020$ 75,554$ 210,178
May 97,418$ 103,831$ 110,511$ 311,760
June 168,831$ 179,572$ 207,941$ 556,344
July 235,029$ 257,593$ 282,181$ 774,803
August 208,024$ 234,143$ 252,909$ 695,076
September 169,309$ 191,252$ 232,677$ 593,238
Total Dollars Received $1,235,245 $1,644,877 $1,823,116 4,703,238
Difference compared to prior year $409,632 $178,239
Percent of change 33%11%0%0
Budgeted Dollars $700,000 $1,500,000 $1,500,000
Streets LOT Actual Dollars Earned per Month