|
Table 2. Scenarios 4 and 5
<br />68
<br />I I F1 I I
<br />Scenario 413 - Break -Even Analysis:Program Fee Set to Balance Budget Including General Funds
<br />PROJECTED BUDGET
<br />PROJECTED
<br />PROJECTED
<br />SCENARIO 5 - $0 Program Fee
<br />(All Make -up Funding
<br />through General Fund)
<br />PROJECTED
<br />PROJECTED
<br />FY 2016 -17
<br />FY 2017.18
<br />FY 2018 -19
<br />FY 2019 -20
<br />FY 2020 -21
<br />Environmental
<br />Support (3500)
<br />Status Quo: $107 Fee
<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,5741
<br />2,182,751
<br />8,219,086
<br />1,565,842
<br />750,829
<br />3,640,544
<br />2,568,157
<br />8,525,372
<br />1,524,544
<br />974,834
<br />3,970,470
<br />2,176,239
<br />8,646,087
<br />Program Fee Revenue
<br />1,468,2251
<br />772,567
<br />4,005,536
<br />2,752,8431
<br />8,999,170
<br />SCENARIO 4 -Break Even
<br />(Includes General Fund
<br />Scenario
<br />2,552,338
<br />9,320,084
<br />Other Revenues
<br />168,117
<br />Total
<br />997,743
<br />2,104,719
<br />3,770,869
<br />321,347
<br />Total s
<br />1,181,154
<br />2,106,195
<br />4,755,372
<br />211,168
<br />Total
<br />Contribution - '
<br />$2 Million)
<br />2,388,466
<br />4,928,843
<br />Other Revenues
<br />Sanitation
<br />Total z
<br />1,762,249
<br />2,469,073
<br />5,597,184
<br />Sanitation
<br />Total
<br />1,713,275
<br />Environmental
<br />Landfill
<br />Recycling
<br />Sanitation
<br />1,266,275
<br />Environmental
<br />Landfill
<br />Recycling
<br />Sanitation
<br />1,092,721
<br />Environmental
<br />Landfill
<br />Recycling
<br />Sanitation
<br />1,653,753
<br />5,620,762
<br />Environmental
<br />Landfill
<br />Recycling
<br />Services
<br />1,083,456
<br />Environmental
<br />Landfill
<br />Recycling
<br />Services
<br />1,151,971
<br />6,038,469
<br />Support (3500)
<br />Services (3510)
<br />Services (3520)
<br />Services (3530)
<br />1,117,414
<br />Support (3500)
<br />Services (3510)
<br />Services (3520)
<br />Services (3530)
<br />1,169,634
<br />Support (3500)
<br />Services (3510)
<br />Services (3520)
<br />Services (3530)
<br />1,530,554
<br />6,233,901
<br />Support (3500)
<br />Services (3510)
<br />Services (3520)
<br />(3530)
<br />1,253,078
<br />Support (3500)
<br />Services (3510)
<br />Services (3520)
<br />(3530)
<br />1,276,163
<br />Scenario 4A - Break -Even Analysis: Program Fee Set to Balance Budget Excluding General Funds
<br />3,869,563
<br />14,130,047
<br />Net Revenues (Deficits)
<br />($535,571)
<br />$148,861
<br />I
<br />$1,103,286
<br />$0
<br />($552,064)
<br />($76,913)
<br />Scenario 4A- Break -Even Analysis: Program Fee Set to Balance Budget Excluding General Funds
<br />$673,701
<br />$0
<br />($657,923)
<br />$123,198
<br />($613,140)
<br />Program Fee Revenue
<br />1 1,907,8801
<br />952,8161
<br />4,647,9631
<br />2,715,1461
<br />10,223,805
<br />1,934,045
<br />927,384
<br />4,496,609
<br />3,172,053
<br />10,530,0911
<br />1,878,031
<br />1,200,863
<br />4,891,080
<br />2,680,831
<br />10,650,806
<br />Program Fee Revenue
<br />1 1,795,2971
<br />944,6701
<br />4,897,8371
<br />3,366,0851
<br />11,003,8891
<br />1,945,131
<br />1,022,806
<br />5,255,529
<br />3,101,337
<br />11,324,803
<br />Other Revenues
<br />168,117
<br />500,290
<br />997,743
<br />100,000
<br />1,766,150
<br />321,347
<br />341,8921
<br />1,181,1541
<br />101,4761
<br />2,750,6531
<br />211,168
<br />678,918
<br />1,650,292
<br />383,747
<br />2,924,124
<br />Other Revenues
<br />150,7201
<br />310,8881
<br />1,762,2491
<br />464,3541
<br />3,592,465W
<br />153,7501
<br />310,2221
<br />1,713,2751
<br />627,997
<br />2,805,244
<br />Total Revenues
<br />2,075,997
<br />1,453,106
<br />5,645,706
<br />2,515,146
<br />11,959,955
<br />2,255,392
<br />1,269,2771
<br />5,677,7631
<br />3,273,5281
<br />13,280,744
<br />1 2,089,198
<br />1,879,782
<br />6,541,372
<br />3,064,575
<br />13,574,930
<br />Total Revenues
<br />1,946,017
<br />1,255,558
<br />6,660,086
<br />3,830,439
<br />14,596,354
<br />2,098,581
<br />1,333,025
<br />6,968,804
<br />3,729,334
<br />14,130,047
<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,530,554
<br />6,233,901
<br />3,416,840
<br />13,574,930
<br />Total Expenses
<br />2,381,412
<br />1,253,075
<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 />($161,467)
<br />$335,692
<br />$194,813
<br />($369,038)
<br />$0
<br />($183,861)
<br />$99,643
<br />$6,557
<br />($727,123)
<br />$0
<br />($304,436)
<br />$349,225
<br />$307,470
<br />($352,262)
<br />$0
<br />Net Revenues (Deficits)
<br />1 ($435,395)
<br />$2,480
<br />1 $163,240
<br />($634,580)
<br />$0
<br />N ($328,074)
<br />$56,865
<br />1 $411,439
<br />1 ($140,229)
<br />$0
<br />I I F1 I I
<br />Scenario 413 - Break -Even Analysis:Program Fee Set to Balance Budget Including General Funds
<br />PROJECTED BUDGET
<br />PROJECTED
<br />PROJECTED
<br />SCENARIO 5 - $0 Program Fee
<br />(All Make -up Funding
<br />through General Fund)
<br />PROJECTED
<br />PROJECTED
<br />FY 2016.17
<br />FY 2017.18
<br />FY 2018.19
<br />FY 2019.20
<br />Scenario 4B - Break -Even Analysis:Program Fee Set to Balance Budget Including General Funds
<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,5741
<br />2,182,751
<br />8,219,086
<br />1,565,842
<br />750,829
<br />3,640,544
<br />2,568,157
<br />8,525,372
<br />1,524,544
<br />974,834
<br />3,970,470
<br />2,176,239
<br />8,646,087
<br />Program Fee Revenue
<br />1,468,2251
<br />772,567
<br />4,005,536
<br />2,752,8431
<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 />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 />678,918
<br />1,650,292
<br />2,388,466
<br />4,928,843
<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,701,893
<br />1,266,275
<br />4,734,317
<br />4,287,470
<br />11,989,955
<br />1,887,189
<br />1,092,721
<br />4,821,698
<br />4,674,352
<br />13,280,744
<br />1,735,711
<br />1,653,753
<br />5,620,762
<br />4,564,705
<br />13,574,930
<br />Total Revenues
<br />1,618,945
<br />1,083,456
<br />5,767,784
<br />5,221,915
<br />14,596,355
<br />1,754,554
<br />1,151,971
<br />6,038,469
<br />5,185,053
<br />14,130,047
<br />Total Expenses
<br />2,237,464
<br />1,117,414
<br />5,450,893
<br />3,184,154
<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,530,554
<br />6,233,901
<br />3,416,840
<br />13,574,930
<br />Total Expenses
<br />2,381,412
<br />1,253,078
<br />6,496,845
<br />4,465,019
<br />1405960354
<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 />($535,571)
<br />$148,861
<br />($716,576)
<br />$1,103,286
<br />$0
<br />($552,064)
<br />($76,913)
<br />($849,508)
<br />$673,701
<br />$0
<br />($657,923)
<br />$123,198
<br />($613,140)
<br />$1,147,865
<br />$0
<br />0 Net Revenues (Deficits)
<br />($762,467)
<br />($169,623)
<br />($729,061)
<br />$756,896
<br />$0
<br />1 ($672,402)
<br />($124,193)
<br />($518,896)
<br />$1,315,491
<br />$0
<br />Scenario 4A: Deficit /Surplus w/o General Fund 50 yU yU Scenario 4A: Deficit /Surplus w/o General Fund yU yU
<br />Scenario 4A: Break -Even Program Fee w/o General Fund $169.89 $173.08 $173.16 Scenario 4A: Break -Even Program Fee w/o General Fund $176.95 $180.13
<br />Scenario 4B: Deficit /Surplus w/ General Fund $0 $0 $0 Scenario 413: Deficit /Surplus w/ General Fund $0 $0
<br />Scenario 4B: Break -Even Program Fee w/ General Fund $136.58 $140.13 $140.57 Scenario 46: Break -Even Program Fee w/ General Fund $144.71 $148.24
<br />SCENARIO 5 - $0 Program
<br />Fee (All Make -up Funding
<br />through General Fund)
<br />PROJECTED BUDGET
<br />PROJECTED
<br />PROJECTED
<br />SCENARIO 5 - $0 Program Fee
<br />(All Make -up Funding
<br />through General Fund)
<br />PROJECTED
<br />PROJECTED
<br />FY 2016.17
<br />FY 2017.18
<br />FY 2018.19
<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 />Total
<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 />Total
<br />Environmental
<br />Support (3500)
<br />Landfill
<br />Services (3510)
<br />Recycling
<br />Services (3520)
<br />Sanitation
<br />Services
<br />(3530)
<br />Total'
<br />Environmental
<br />Support (3500)
<br />Landfill
<br />Services (3510)
<br />Recycling
<br />Services (3520)
<br />Sanitation
<br />Services
<br />(3530)
<br />Total
<br />Scenario SA - $0 Program Fee: (Excludes General Fund Contribution)
<br />W
<br />Scenario SA- $0 Program Fee:
<br />(Excludes General Fund Contribution)
<br />Program Fee Revenue
<br />0
<br />0
<br />01
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />Program Fee Revenue
<br />0
<br />01
<br />01
<br />01
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />Other Revenues
<br />168,117
<br />500,290
<br />997,743
<br />100,000
<br />1,766,150
<br />321,3471
<br />341,892
<br />1,181,154
<br />101,476
<br />2,750,653
<br />211,168
<br />678,918
<br />1,650,292
<br />383,747
<br />2,924,124
<br />Other Revenues
<br />150,720
<br />310,8881
<br />1,762,2491
<br />464,3541
<br />3,492,994
<br />153,750
<br />310,222
<br />1,713,275
<br />627,997
<br />2,805,244
<br />Total Revenues
<br />168,117
<br />500,290
<br />997,743
<br />100,000
<br />1,766,150
<br />321,347
<br />341,892
<br />1,181,154
<br />101,476
<br />2,750,653
<br />211,168
<br />678,918
<br />1,650,292
<br />383,747
<br />2,924,124
<br />Total Revenues
<br />150,720
<br />310,888
<br />1,762,249
<br />464,354
<br />4,297,778
<br />153,750
<br />310,222
<br />1,713,275
<br />627,997
<br />2,805,244
<br />Total Expenses
<br />2,237,464
<br />1,117,414
<br />5,450,893
<br />3,184,154
<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,530,554
<br />6,233,901
<br />3,416,840
<br />13,574,930
<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 />($2,069,347)
<br />($617,124)
<br />($4,453,150)
<br />($3,054,184)
<br />($10,223,805)
<br />($2,117,906)
<br />($827,742)
<br />($4,490,052)
<br />($3,899,175)
<br />($10,530,091)
<br />($2,182,467)
<br />($851,636)
<br />($4,583,610)
<br />($3,033,093)
<br />($10,650,806)
<br />Net Revenues (Deficits)
<br />($2,230,692)
<br />($942,190)
<br />($4,734,597)
<br />($4,000,665)
<br />($10,298,576)
<br />($2,273,205)
<br />($965,941)
<br />($4,844,090)
<br />($3,241,566)
<br />($11,324,803)
<br />Scenario 58 - $0 Program Fee: (Includes General Fund Contribution - $2 Million) Iiiiiiii
<br />Scenario 5B - $0 Program Fee:
<br />(Includes General Fund Contribution - $2 Million)
<br />Program Fee Revenue
<br />0
<br />0
<br />01
<br />0
<br />0
<br />0
<br />0
<br />01
<br />01
<br />0
<br />0
<br />0
<br />01
<br />01
<br />01
<br />Program Fee Revenue
<br />01
<br />01
<br />01
<br />011
<br />0
<br />01
<br />01
<br />01
<br />01
<br />0
<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,1541
<br />2,106,1951
<br />4,755,372
<br />211,168
<br />678,918
<br />1,650,2921
<br />2,388,4661
<br />4,928,8431
<br />Other Revenues
<br />1 150,7201
<br />310,8881
<br />1,762,2491
<br />2,469,0731
<br />5,497,713
<br />153,7501
<br />310,2221
<br />1,713,2751
<br />2,632,7161
<br />4,809,963
<br />Total 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 />678,918
<br />1,650,292
<br />2,388,466
<br />4,928,543
<br />Total Revenues
<br />150,720
<br />310,888
<br />1,762,249
<br />2,469,073
<br />5,497,713
<br />153,750
<br />310,222
<br />1,713,275
<br />2,632,716
<br />4,809,963
<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,530,554
<br />6,233,901
<br />3,416,840
<br />13,574,930
<br />Total Expenses
<br />2,381,412
<br />1,253,075
<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 />($2,069,347)
<br />($617,124)
<br />($4,453,150)
<br />($1,079,465)
<br />($8,219,086)
<br />($2,117,906)
<br />($827,742)
<br />($4,490,052)
<br />($1,894,456)
<br />($8,525,372)
<br />($2,182,467)
<br />($851,636)
<br />($4,583,610)
<br />($1,028,374)
<br />(_9 646 OR7)1
<br />J Net Revenues (Deficits)
<br />1 ($2,230,692)
<br />($942,190)
<br />($4,734,597)
<br />($1,995,946)
<br />($9,098,641)
<br />($2,273,205)
<br />($965,941)
<br />($4,844,090)
<br />($1,236,847)
<br />($9,320,084)
<br />Scenario 5A: Deficit /Surplus w/o General Fund jyiu,zzs,BU5)
<br />Scenario 5A: Cents on Tax Rate: w/o General Fund ($0.06)
<br />Scenario 513: Deficit /Surplus w/ General Fund ($8,219,086)
<br />Scenario 5B: Cents on Tax Rate: w/ General Fund ($0.05)
<br />(S1U,53U,U91) IS1U,b5U,BUb) Scenario 5A: Deficit /Surplus w/o General Fund (S1U,29ts,5 /b)
<br />($0.06) ($0.06) Scenario SA: Cents on Tax Rate: w/o General Fund ($0.06)
<br />($8,525,372) ($8,646,087) Scenario 513: Deficit /Surplus w/ General Fund ($9,098,641)
<br />($0.05) ($0.05) Scenario 513: Cents on Tax Rate: w/ General Fund ($0.05)
<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
<br />construction projects under the Appropriated Fund Balance line item account. The four Projected Years also include contributions from equipment reserves as a separate line item account. Note that
<br />these items (loan proceeds and contributions from equipment reserves) were considered part of the Appropriated Fund Balance for FY 2016 -17, which was set to zero, and therefore are effectively
<br />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
<br />figures do not appear in the individual Division columns.
<br />F -2
<br />(y11,324,BU3)
<br />($0.07)
<br />($9,320,084)
<br />($0.06)
<br />
|