Full Text
DRAFT Table A-1 Millcreek Historic and Projected Revenue Requirement Assumed Annual Rate of Inflation: 3.0% Estimated Estimated Budgeted Projected Projected Projected Projected Projected Projected Projected Projected Projected Item 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Administration $359,106 $359,106 $819,933 $846,784 $874,519 $903,168 $932,761 $963,329 $994,904 $1,027,521 $1,061,212 $1,096,015 Director/Designee $30,120 $30,120 $30,120 $31,024 $31,954 $32,913 $33,900 $34,917 $35,965 $37,044 $38,155 $39,300 Administration $10,336 $10,336 $12,403 $12,775 $13,159 $13,553 $13,960 $14,379 $14,810 $15,254 $15,712 $16,183 SW Engineer $174,950 $174,950 $174,950 $180,199 $185,604 $191,173 $196,908 $202,815 $208,899 $215,166 $221,621 $228,270 SW Lead Inspector $143,700 $143,700 $143,700 $148,011 $152,451 $157,025 $161,736 $166,588 $171,585 $176,733 $182,035 $187,496 SW Inspector $0 $0 $120,100 $124,304 $128,654 $133,157 $137,818 $142,641 $147,634 $152,801 $158,149 $163,684 SW Inspector $0 $0 $120,100 $124,304 $128,654 $133,157 $137,818 $142,641 $147,634 $152,801 $158,149 $163,684 Rocky Mountain Power Billing Contract $0 $0 $90,000 $93,150 $96,410 $99,785 $103,277 $106,892 $110,633 $114,505 $118,513 $122,661 Billing Specialist $120,360 $124,573 $128,933 $133,445 $138,116 $142,950 $147,953 $153,132 $158,491 $164,038 Storm Water Coalition $8,200 $8,446 $8,699 $8,960 $9,229 $9,506 $9,791 $10,085 $10,388 $10,699 Operations $384,000 $384,000 $747,763 $746,956 $758,409 $778,708 $805,244 $832,687 $861,070 $890,423 $920,781 $952,178 Operations Lead $76,704 $103,655 $132,154 $162,270 $167,138 $172,152 $177,317 $182,636 $188,115 $193,759 Operations Crew $64,049 $86,986 $111,457 $137,541 $142,375 $147,380 $152,560 $157,923 $163,474 $169,220 Operations Crew $64,049 $86,986 $111,457 $137,541 $142,375 $147,380 $152,560 $157,923 $163,474 $169,220 Vactor Truck $55,397 $75,236 $96,402 $118,962 $123,143 $127,472 $131,952 $136,590 $141,392 $146,362 Sweeper $53,719 $72,956 $93,480 $115,357 $119,412 $123,609 $127,954 $132,451 $137,107 $141,926 Camera Truck $49,845 $67,695 $86,739 $107,038 $110,800 $114,695 $118,726 $122,900 $127,219 $131,691 County Contract (Phase Out) $384,000 $384,000 $384,000 $253,440 $126,720 $0 $0 $0 $0 $0 $0 $0 Capital Expenditures $1,237,000 $757,000 $1,526,000 $1,571,780 $1,618,933 $1,667,501 $1,762,546 $1,769,052 $1,822,124 $1,876,788 $1,983,762 $1,991,084 Emergency Reactionary Capital Spending $250,000 $772,500 $795,675 $819,545 $844,132 $869,456 $895,539 $922,405 $950,078 $978,580 Additional Storm Drain Investigation $500,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 Master Planning Updates $0 $0 $0 $0 $45,020 $0 $0 $0 $50,671 $0 Proactive Capital 10 year average spending $776,000 $799,280 $823,258 $847,956 $873,395 $899,597 $926,585 $954,382 $983,014 $1,012,504 Debt $0 $0 $410,000 $410,000 $410,000 $410,000 $410,000 $410,000 $410,000 $410,000 $410,000 $410,000 Public Works Yard (Savings) $410,000 $410,000 $410,000 $410,000 $410,000 $0 $0 $0 $0 $0 Public Works Yard (Debt) $0 $0 $0 $0 $0 $410,000 $410,000 $410,000 $410,000 $410,000 Total $1,980,106 $1,500,106 $3,503,696 $3,575,520 $3,661,862 $3,759,377 $3,910,551 $3,975,068 $4,088,098 $4,204,731 $4,375,755 $4,449,277 ---PAGE BREAK--- DRAFT Table A-2 Millcreek Existing and Projected Customer Base by Customer Class (Effective ERUs) With 0.5% Growth Rate Estimated Estimated Analyzed Projected Projected Projected Projected Projected Projected Projected Projected Projected Customer by Class 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Single Family (under 11,000 SF) 8,601 8,644 8,687 8,731 8,775 8,818 8,863 8,907 8,951 8,996 Single Family (over 11,000 SF) 6,788 6,822 6,856 6,890 6,925 6,959 6,994 7,029 7,064 7,100 Commercial / Institutional / Civic 9,337 9,384 9,431 9,478 9,525 9,573 9,621 9,669 9,717 9,766 Multi Family Stacked 3,267 3,283 3,300 3,316 3,333 3,350 3,366 3,383 3,400 3,417 Multi Family (townhomes) 1,519 1,527 1,534 1,542 1,550 1,558 1,565 1,573 1,581 1,589 Total ERUs 29,513 29,660 29,808 29,957 30,107 30,258 30,409 30,561 30,714 30,868 Table A-3 Millcreek Historic and Projected Expenses and Revenues Estimated Estimated Budgeted Projected Projected Projected Projected Projected Projected Projected Projected Projected Item 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Total Expenses $1,980,106 $1,500,106 $3,503,696 $3,575,520 $3,661,862 $3,759,377 $3,910,551 $3,975,068 $4,088,098 $4,204,731 $4,375,755 $4,449,277 Total Non-Rate Revenue $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Scenario 1: Do Nothing and Keep Existing Rates Total Rate Revenues $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Total Revenues $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Revenue Surplus (-Shortfall) -$1,980,106 -$1,500,106 -$3,503,696 -$3,575,520 -$3,661,862 -$3,759,377 -$3,910,551 -$3,975,068 -$4,088,098 -$4,204,731 -$4,375,755 -$4,449,277 Scenario 2: Meet Revenue Need with Initial and Annual Increases Total Rate Revenues $3,475,973 $3,573,700 $3,674,174 $3,777,474 $3,883,677 $3,992,867 $4,105,126 $4,220,542 $4,339,203 $4,461,199 Total Revenues $3,475,973 $3,573,700 $3,674,174 $3,777,474 $3,883,677 $3,992,867 $4,105,126 $4,220,542 $4,339,203 $4,461,199 Revenue Surplus (-Shortfall) -$27,723 -$1,820 $12,312 $18,096 -$26,874 $17,799 $17,029 $15,811 -$36,553 $11,923