Cities Index.
Recommended FY 22-23 Solid Waste Management Fund Financial Plan

Sunnyvale City Council
June 28, 2022

Document
Recommended FY 22-23 Solid Waste Management Fund Financial Plan
Meeting
June 28, 2022
Body
Sunnyvale City Council
Pages
2
Original file
717 KB
Text extracted from the city's file for reading and search. Open the original on legistar.granicus.com. That file is the official record.

RESERVE/FUND BALANCE, JULY 1
CURRENT RESOURCES:

Rental Income
Service Fees
Miscellaneous Revenues
Transfers From Other Funds
SMaRT Station Revenues
Bond Proceeds
County Wide AB939 Fee
Interest Income

TOTAL CURRENT RESOURCES

TOTAL AVAILABLE RESOURCES
CURRENT REQUIREMENTS:

Interfund Loan Repayment
Debt Service
Operations
Solid Waste Collection Contract
Special Projects
Infrastructure Projects
Project Operating
In-Lieu Charges
SMaRT Expense Share (Sunnyvale)
Long Term Rent - SMaRT and Landfill
Civic Center Rent
Transfer To General Fund
Transfer To Payroll and Benefits Fund

TOTAL CURRENT REQUIREMENTS
RESERVES:

Contingencies
Rate Stabilization Reserve

TOTAL RESERVES
FUND BALANCE, JUNE 30
STATISTICS:

Refuse Rate Increase
Prior Year Refuse Rate Increase
FY 2021/2022
TO
ACTUAL CURRENT BUDGET PLAN PLAN PLAN PLAN PLAN PLAN PLAN PLAN PLAN FY 2031/2032 2020/2021 2021/2022 2022/2023 2023/2024 2024/2025 2025/2026 2026/2027 2027/2028 2028/2029 2029/2030 2030/2031 2031/2032 TOTAL ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ------------------- 24,342,710 23,852,057 21,639,244 31,129,024 18,472,550 9,684,747 6,217,454 6,989,632 8,616,846 10,577,462 12,654,779 15,291,550 23,852,057 ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ------------------- 232,423 256,595 263,010 269,585 276,325 283,233 290,314 297,572 305,011 312,636 320,452 328,463 3,203,195 49,741,885 52,720,000 55,658,742 59,013,573 62,554,387 66,025,530 69,359,159 72,167,511 74,367,899 76,635,376 78,971,989 80,590,125 748,064,289 (90,997) 61,480 61,870 62,263 62,661 63,063
63,468 63,878 64,292 64,710 65,132 65,558 698,375
89,507 0 0 0 0 0 0 0 0 0 0 0 0
398,084 2,116,163 1,850,222 1,896,478 1,943,889 1,992,487 2,042,299 2,093,356 2,145,690 2,199,333 2,254,316 2,310,674 22,844,906 0 0 18,000,000 0 0 0 0 0 0 0 0 0 18,000,000
169,121 136,229 135,676 135,676 135,676 135,676 135,676 135,676 135,676 135,676 135,676 135,676 1,492,986 459,378 424,299 610,373 362,207 189,897 121,911 137,052 168,958 207,401 248,133 299,834 430,744 3,200,809 ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ------------------- 50,999,400 55,714,766 76,579,892 61,739,781 65,162,835 68,621,899 72,027,968 74,926,951 77,225,968 79,595,863 82,047,398 83,861,239 797,504,560 ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ------------------- 75,342,110 79,566,822 98,219,136 92,868,805 83,635,385 78,306,646 78,245,422 81,916,583 85,842,815 90,173,325 94,702,177 99,152,789 821,356,617 ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ------------------- 3,874,946 3,713,816 3,470,202 3,048,003 0 0 0 0 0 0 0 0 10,232,021 1,246,631 0 0 2,205,016 2,205,016 2,205,016 2,205,016 2,205,016 2,205,016 2,205,016 2,205,016 2,205,016 19,845,144 2,520,955 4,000,914 3,645,281 3,858,520 3,824,545 2,986,432 3,068,295 3,174,659 3,264,449 3,356,870 3,454,481 3,550,259 38,184,705 22,998,755 25,323,223 27,241,856 29,103,293 30,975,059 31,904,311 32,861,440 33,847,283 34,862,702 35,908,583 36,985,840 38,095,416 357,109,006 463,081 1,079,828 1,410,476 1,071,634 856,971 561,757 559,540 523,496 376,631 643,326 389,458 444,162 7,917,280 3,800 434,021 3,100,397 6,113,448 6,099,940 3,103,938 154,570 112,419 120,423 125,240 130,249 135,459 19,630,103 0 0 (197,708) (201,662) (205,696) (211,867) (218,223) (224,769) (231,512) (238,458) (245,611) (252,980) (2,228,486) 3,083,884 3,164,690 4,179,510 4,297,554 4,406,429 4,518,027 4,632,414 4,749,661 4,869,840 4,993,023 5,119,285 5,248,704 50,179,137 14,813,749 18,044,950 22,084,304 22,534,269 23,346,311 24,501,158 25,384,658 26,219,628 27,016,951 27,670,280 28,341,330 29,029,070 274,172,909 1,309,136 1,335,319 1,362,025 1,389,266 1,430,944 1,473,872 1,518,088 1,563,631 1,610,540 1,658,856 1,708,622 1,759,881 16,811,045 0 0 175,106 355,465 366,129 377,113 388,426 400,079 412,081 424,444 437,177 450,292 3,786,312 975,326 200,651 16,101 15,475 18,002 21,206 23,852 23,173 34,891 21,363 99,615 127,900 602,228 199,790 630,166 602,563 605,975 626,988 648,229 677,713 705,461 723,340 750,003 785,164 699,118 7,454,720 ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ------------------- 51,490,053 57,927,578 67,090,113 74,396,255 73,950,638 72,089,192 71,255,790 73,299,736 75,265,353 77,518,546 79,410,627 81,492,297 803,696,124 ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ------------------- 4,033,346 4,736,909 5,297,144 5,549,608 5,814,591 5,939,190 6,131,439 6,324,157 6,514,410 6,693,573 6,878,165 7,067,474 7,067,474 19,818,711 16,902,336 25,831,879 12,922,942 3,870,156 278,264 858,193 2,292,689 4,063,052 5,961,206 8,413,385 10,593,018 10,593,018 ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ------------------- 23,852,057 21,639,244 31,129,024 18,472,550 9,684,747 6,217,454 6,989,632 8,616,846 10,577,462 12,654,779 15,291,550 17,660,492 17,660,492 ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ------------------- 0 0 0 0 0 0 0 0 0 0 0 0 0
========== ========== ========== ========== ========== ========== ========== ========== ========== ========== ========== ========== ===========

0.0% 4.0% 5.0% 5.5% 6.0% 5.5% 5.0% 4.0% 3.0% 3.0% 3.0% 2.0%

0.0% 1.0% 5.0% 5.0% 5.0% 3.0% 3.0% 2.0% 2.0% 2.0% 2.0% 2.0% JULY 1, 2021 TO JUNE 30, 2032

CITY OF SUNNYVALE

LONG TERM FINANCIAL PLAN
6100. SOLID WASTE MANAGEMENT FUND
Attachment 7

Page 1 of 2 ends

RESERVE/FUND BALANCE, JULY 1
CURRENT RESOURCES:

Rental Income
Service Fees
Miscellaneous Revenues
Transfers From Other Funds
SMaRT Station Revenues
Bond Proceeds
County Wide AB939 Fee
Interest Income

TOTAL CURRENT RESOURCES

TOTAL AVAILABLE RESOURCES
CURRENT REQUIREMENTS:

Interfund Loan Repayment
Debt Service
Operations
Solid Waste Collection Contract
Special Projects
Infrastructure Projects
Project Operating
In-Lieu Charges
SMaRT Expense Share (Sunnyvale)
Long Term Rent - SMaRT and Landfill
Civic Center Rent
Transfer To General Fund
Transfer To Payroll and Benefits Fund

TOTAL CURRENT REQUIREMENTS
RESERVES:

Contingencies
Rate Stabilization Reserve

TOTAL RESERVES
FUND BALANCE, JUNE 30
STATISTICS:

Refuse Rate Increase
Prior Year Refuse Rate Increase
FY 2032/2033 FY 2021/2022
TO TO
PLAN PLAN PLAN PLAN PLAN PLAN PLAN PLAN PLAN PLAN FY 2041/2042 FY 2041/2042 2032/2033 2033/2034 2034/2035 2035/2036 2036/2037 2037/2038 2038/2039 2039/2040 2040/2041 2041/2042 TOTAL TOTAL ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------------------------- ------------------- ------------------- 17,660,492 19,754,420 21,389,579 22,472,298 23,083,986 22,925,176 22,605,540 21,699,872 20,079,044 17,796,627 17,660,492 23,852,057 ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------------------------- ------------------- ------------------- 336,675 345,092 353,719 362,562 371,626 380,917 390,440 400,201 410,206 420,461 3,771,897 6,975,092 82,241,416 83,926,543 85,646,198 87,401,088 89,191,937 91,019,479 92,884,469 94,787,671 96,729,871 98,711,866 902,540,537 1,650,604,827 65,989 66,424 66,863 67,306 67,755 68,207 68,664 69,126 69,592 70,063 679,988 1,378,362 0 0 0 0 0 0 0 0 0 0 0 0
2,368,441 2,427,652 2,488,343 2,550,551 2,614,315 2,679,673 2,746,665 2,815,332 2,885,715 2,957,858 26,534,544 49,379,450 0 0 0 0 0 0 0 0 0 0 0 18,000,000
135,676 135,676 135,676 135,676 135,676 135,676 135,676 135,676 135,676 135,676 1,356,757 2,849,743 481,815 521,697 548,105 563,024 559,151 551,355 529,265 489,733 434,064 368,849 5,047,058 8,247,867 ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------------------------- ------------------- ------------------- 85,630,011 87,423,082 89,238,903 91,080,208 92,940,459 94,835,307 96,755,178 98,697,738 100,665,123 102,664,773 939,930,783 1,737,435,343 ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ------------------- ------------------- 103,290,504 107,177,503 110,628,483 113,552,506 116,024,445 117,760,482 119,360,718 120,397,610 120,744,167 120,461,400 957,591,275 1,761,287,399 ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ------------------- ------------------- 0 0 0 0 0 0 0 0 0 0 0 10,232,021
2,205,016 2,205,016 2,205,016 2,205,016 2,205,016 2,205,016 2,205,016 2,205,016 2,205,016 2,205,016 22,050,160 41,895,304 3,666,880 3,772,927 3,881,941 3,993,998 4,109,178 4,227,560 4,349,227 4,474,262 4,602,749 4,809,633 41,888,355 80,073,060 39,238,278 40,415,426 41,627,889 42,876,726 44,163,028 45,487,918 46,852,556 48,258,133 49,705,877 51,197,053 449,822,884 806,931,889 403,067 413,179 477,949 428,049 726,328 443,825 449,070 530,634 466,309 278,559 4,616,969 12,534,249 140,878 146,513 152,374 158,469 164,808 171,399 178,256 185,386 192,802 200,514 1,691,398 21,321,501 (260,569) (268,386) (276,438) (284,731) (293,273) (299,138) (308,112) (308,112) (308,112) (308,112) (2,914,983) (5,143,469) 5,382,068 5,518,755 5,659,211 5,803,167 5,950,711 6,101,932 6,256,922 6,415,777 6,578,590 6,745,462 60,412,595 110,591,732 29,740,646 30,468,100 31,214,884 31,981,537 32,768,611 33,576,676 34,406,320 35,257,770 36,132,008 37,030,067 332,576,619 606,749,529 1,812,677 1,867,057 1,923,069 1,980,761 2,040,184 2,101,389 2,164,431 2,229,364 2,296,245 2,365,132 20,780,310 37,591,355 463,801 477,715 492,046 506,808 522,012 537,672 553,803 570,417 587,530 605,155 5,316,959 9,103,271 36,350 34,546 29,908 33,820 28,922 50,921 64,946 46,673 71,962 74,121 472,171 1,074,399 706,991 737,075 768,336 784,900 713,745 549,771 488,411 453,246 416,564 135,977 5,755,016 13,209,736 ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------------------------- ------------------- ------------------- 83,536,083 85,787,923 88,156,185 90,468,520 93,099,269 95,154,942 97,660,846 100,318,566 102,947,540 105,338,579 942,468,454 1,746,164,579 ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------------------------- ------------------- ------------------- 7,264,580 7,465,645 7,672,471 7,885,226 8,104,082 8,329,215 8,560,810 8,799,016 9,044,063 9,303,675 9,303,675 9,303,675 12,489,840 13,923,934 14,799,826 15,198,760 14,821,094 14,276,325 13,139,062 11,280,027 8,752,563 5,819,145 5,819,145 5,819,145 ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ------------------- ------------------- 19,754,420 21,389,579 22,472,298 23,083,986 22,925,176 22,605,540 21,699,872 20,079,044 17,796,627 15,122,821 15,122,821 15,122,821 ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------------------------- ------------------- ------------------- 0 0 0 0 0 0 0 0 0 0 0 0
========== ========== ========== ========== ========== ========== ========== ========== ========== ========== =========== ===========

2.0% 2.0% 2.0% 2.0% 2.0% 2.0% 2.0% 2.0% 2.0% 2.0%

3.0% 3.0% 3.0% 2.0% 2.0% 2.0% 2.0% 2.0% 3.0% 0.0%
JULY 1, 2032 TO JUNE 30, 2042

CITY OF SUNNYVALE

LONG TERM FINANCIAL PLAN
6100. SOLID WASTE MANAGEMENT FUND
Attachment 7

Page 2 of 2 ends
← All documents from this meeting