|
Table 1. Scenarios 1 and 2
<br />SCENARIO 1 - Status Quo:
<br />$107 Fee (Includes General
<br />Fund Contt ribution "' $2
<br />Million)
<br />PROJECTED BUDGET
<br />PROJECTED
<br />PROJECTED
<br />FY 2016 -17
<br />FY 2017 -18
<br />FY 2018 -19
<br />Environmental
<br />Support (3500)
<br />Landfill
<br />Services (3510)
<br />Recycling
<br />Services (3520)
<br />Sanitation
<br />Services (3530)
<br />Total
<br />Environmental
<br />Support (3500)
<br />Landfill
<br />Services (3510)
<br />Recycling
<br />Services (3520)
<br />Sanitation
<br />Services (3530)
<br />Tota12
<br />Environmental
<br />Support (3500)
<br />Landfill
<br />Services (3510)
<br />Recycling
<br />Services (3520)
<br />Sanitation
<br />Services (3530)
<br />Total
<br />Program Fee Revenue
<br />1,201,600
<br />600,092
<br />2,927,330
<br />1,710,024
<br />6,439,046
<br />1,195,659
<br />573,324
<br />2,779,878
<br />1,961,015
<br />6,509,876
<br />1,160,497
<br />742,053
<br />3,022,360
<br />1,656,574
<br />6,581,484
<br />Other Revenues
<br />168,117
<br />500,290
<br />997,743
<br />2,104,719
<br />3,770,869
<br />321,347
<br />341,892
<br />1,181,154
<br />2,106,195
<br />4,755,372
<br />211,168
<br />1,371,665
<br />678,918
<br />1,650,292
<br />2,388,466
<br />4,928,843
<br />Total Revenues
<br />1,369,717
<br />1,100,382
<br />3,925,073
<br />3,814,743
<br />10,209,915
<br />1,517,006
<br />915,217
<br />3,961,031
<br />4,067,210
<br />11,265,248
<br />1,420,972
<br />4,672,651
<br />4,045,040
<br />11,510,327
<br />Total Expenses
<br />2,237,464
<br />1,117,414
<br />5,450,893
<br />3,184,184
<br />11,989,955
<br />2,439,253
<br />1,169,634
<br />5,671,206
<br />4,000,651
<br />13,280,744
<br />2,393,635
<br />($1,021,970)
<br />1,530,554
<br />6,233,901
<br />3,416,840
<br />13,574,930
<br />Net Revenues (Deficits)
<br />1 ($867,747)
<br />($17,032)
<br />($1,525,820)
<br />$630,559
<br />1 ($1,780,040)
<br />($922,248)
<br />($254,417)
<br />($1,710,175)
<br />$66,559
<br />1 ($2,015,497)
<br />($109,583)
<br />($1,561,250)
<br />$628,200
<br />1 ($2,064,603)
<br />Scenario 1: Budget Gap
<br />($1,780,040)
<br />($2,015,497)
<br />SCENARIO 1 - Status Quo:
<br />$107 Fee (Includes General
<br />Fund Contribution "' $2
<br />i
<br />Million)
<br />PROJECTED
<br />PROJECTED
<br />FY 2019 -20
<br />FY 2020 -21
<br />Environmental
<br />Support (3500)
<br />Landfill
<br />Services (3510)
<br />Recycling
<br />Services (3520)
<br />Sanitation
<br />Services (3530)
<br />Tota12
<br />Environmental
<br />Support (3500)
<br />Landfill
<br />Services (3510)
<br />Recycling
<br />Services (3520)
<br />Sanitation
<br />Services (3530)
<br />Total
<br />Program Fee Revenue
<br />1,085,588
<br />571,227
<br />2,961,646
<br />2,035,419
<br />6,653,880
<br />1,155,432
<br />607,559
<br />3,121,849
<br />1,842,233
<br />6,727,073
<br />Other Revenues
<br />150,720
<br />310,888
<br />1,762,249
<br />2,469,073
<br />5,597,184
<br />153,750
<br />310,222
<br />1,713,275
<br />2,632,716
<br />4,809,963
<br />Total Revenues
<br />1,236,308
<br />882,115
<br />4,723,895
<br />4,504,492
<br />12,251,065
<br />1,309,182
<br />917,781
<br />4,835,124
<br />4,474,948
<br />11,537,036
<br />Total Expenses
<br />2,381,412
<br />1,253,078
<br />6,496,845
<br />4,465,019
<br />14,596,354
<br />2,426,955
<br />1,276,163
<br />6,557,365
<br />3,869,563
<br />14,130,047
<br />Net Revenues (Deficits)
<br />($1,145,104)
<br />($370,963)
<br />($1,772,951)
<br />$39,473 1
<br />($2,345,290)
<br />($1,117,773)
<br />($358,382)
<br />($1,722,241)
<br />$605,385
<br />1 ($2,593,011)
<br />Scenario 1: Budget Gap
<br />($2,345,290)
<br />($2,593,011)
<br />($2,064,603)
<br />SCENARIO 2 - Break Even
<br />Scenario
<br />PROJECTED BUDGET
<br />PROJECTED
<br />PROJECTED
<br />FY 2016 -17
<br />FY 2017 -18
<br />FY 2018 -19
<br />Environmental
<br />Support (3500)
<br />Landfill
<br />Services (3510)
<br />Recycling
<br />Services (3520)
<br />Sanitation
<br />Services (3530)
<br />Total
<br />Environmental
<br />Support (3500)
<br />Landfill
<br />Services (3510)
<br />Recycling
<br />Services (3520)
<br />Sanitation
<br />Services (3530)
<br />Tota IZ
<br />Environmental
<br />Support (3500)
<br />Landfill
<br />Services (3510)
<br />Recycling
<br />Services (3520)
<br />Sanitation
<br />Services (3530)
<br />Total
<br />Program Fee Revenue
<br />1,533,776
<br />765,985
<br />3,736,574
<br />2,182,751
<br />8,219,086
<br />1,565,842
<br />321,347
<br />1,887,189
<br />750,829
<br />3,640,544
<br />2,568,157
<br />8,525,372
<br />1,524,544
<br />211,168
<br />1,735,711
<br />974,834
<br />3,970,470
<br />2,176,239
<br />8,646,087
<br />Other Revenues
<br />168,117
<br />500,290
<br />997,743
<br />2,104,719
<br />3,770,869
<br />341,892
<br />1,181,154
<br />2,106,195
<br />4,755,372
<br />678,918
<br />1,650,292
<br />2,388,466
<br />4,928,843
<br />Total Revenues
<br />1,701,893
<br />1,266,275
<br />4,734,317
<br />4,287,470
<br />11,989,955
<br />1,092,721
<br />4,821,698
<br />4,674,352
<br />13,280,744
<br />1,653,753
<br />5,620,762
<br />4,564,705
<br />13,574,930
<br />Total Expenses
<br />1 2,237,464
<br />1,117,414
<br />5,450,893
<br />3,184,184
<br />11,989,9551
<br />2,439,253
<br />1 ($552,064)
<br />1,169,634
<br />5,671,206
<br />4,000,651
<br />13,280,7441
<br />1 2,393,635
<br />11 ($657,923)1
<br />1,530,554
<br />6,233,901
<br />3,416,840
<br />13,574,930
<br />Net Revenues (Deficits)
<br />1 ($535,571)
<br />$148,861
<br />($716,576)1
<br />$1,103,286
<br />$0
<br />($76,913)
<br />($849,508)1
<br />$673,701
<br />$0
<br />$123,198
<br />1 ($613,140)1
<br />$1,147,865
<br />1 $0
<br />Scenario 2: Deficit /Surplus w/ General Fund $0
<br />Scenario 2: Break -Even Program Fee w/ General Fund $136.58
<br />$0
<br />$140.13
<br />SCENARIO 2 - Break Even
<br />Scenario
<br />PROJECTED
<br />PROJECTED
<br />FY 2019 -20
<br />FY 2020 -21
<br />Environmental
<br />Support (3500)
<br />Landfill
<br />Services (3510)
<br />Recycling
<br />Services (3520)
<br />Sanitation
<br />Services (3530)
<br />Total2
<br />Environmental
<br />Support (3500)
<br />Landfill
<br />Services (3510)
<br />Recycling
<br />Services (3520)
<br />Sanitation
<br />Services (3530)
<br />Total
<br />Program Fee Revenue
<br />1,468,225
<br />772,567
<br />4,005,536
<br />2,752,843
<br />8,999,170
<br />1,600,803
<br />841,749
<br />4,325,194
<br />2,552,338
<br />9,320,084
<br />Other Revenues
<br />150,720
<br />310,888
<br />1,762,249
<br />2,469,073
<br />5,597,184
<br />153,750
<br />1,754,554
<br />310,222
<br />1,713,275
<br />2,632,716
<br />4,809,963
<br />Total Revenues
<br />1,618,945
<br />1,083,4561
<br />5,767,784
<br />5,221,915
<br />14,596,355
<br />1,151,971
<br />6,038,469
<br />5,185,053
<br />14,130,047
<br />Total Expenses
<br />2,381,412
<br />1,253,078
<br />6,496,845
<br />4,465,019
<br />14,596,354
<br />2,426,955
<br />1 ($672,402)
<br />1,276,163
<br />6,557,365
<br />3,869,563
<br />14,130,047
<br />Net Revenues (Deficits)
<br />1 ($762,467)
<br />($169,623)
<br />($729,061)1
<br />$756,896
<br />$0
<br />($124,193)
<br />($518,896)F
<br />$1,315,491
<br />$0
<br />Scenario 2: Deficit /Surplus w/ General Fund $0
<br />Scenario 2: Break -Even Program Fee w/ General Fund $144.71
<br />$0
<br />$148.24
<br />$0
<br />$140.57
<br />1. The FY 2016 -17 Other Revenues are presented in a manner to be consistent with the County's preliminary budget. The four Projected Years include loan proceeds associated with two collection center construction projects under the Appropriated
<br />Fund Balance line item account. The four Projected Years also include contributions from equipment reserves as a separate line item account. Note that these items (loan proceeds and contributions from equipment reserves) were considered part
<br />of the Appropriated Fund Balance for FY 2016 -17, which was set to zero, and therefore are effectively excluded as Other Revenues within the model for that year.
<br />2. FY 2017 -18 and FY 2019 -20 "Other Revenues" and "Total Revenues" "Total" Column cells include loan proceeds for convenience center construction of $804,784 and $904,255, respectively. These figures do not appear in the individual Division
<br />columns.
<br />3. As a budgetary leveling exercise, SCS developed a methodology to present the net revenue and expense output by the Model as if the Program Fee contribution in the various Scenarios were disbursed evenly across all four Department Divisions,
<br />rather than solely through the Environmental Services Division. The "Leveling Factors" used for this exercise can be seen in Appendix E.
<br />F -1
<br />
|