|
<br /> Page | 21
<br />Cost of Services
<br />Wholesale Customer Revenues and Charges
<br /> The findings and preliminary recommendations in this memorandum are based on information provided to Baker Tilly for this study. We understand that after the SPRWS staff has an opportunity to review and discuss both the analysis and preliminary recommendations some revisions may be needed.
<br />
<br />Future Years 2022 2023 2024 2025 2026 2027
<br />Total Revenue Requirement 7,125,306$ 7,802,211$ 8,348,365$ 8,932,751$ 9,379,388$ 9,848,358$
<br />Roseville
<br />Revenue Requirement 5,355,831$ 5,864,635$ 6,275,159$ 6,714,421$ 7,050,142$ 7,402,649$
<br />Preliminary Volume Rate 2.03$ 2.22$ 2.38$ 2.54$ 2.669389$ 2.80$
<br />Preliminary Volume Fee Revenue 4,647,831$ 5,089,375$ 5,445,631$ 5,826,825$ 6,118,167$ 6,424,075$
<br />Base fee revenue 708,000$ 775,260$ 829,528$ 887,595$ 931,975$ 978,574$
<br />Monthly Base Fee rounded 59,000$ 64,600$ 69,100$ 74,000$ 77,700$ 81,500$
<br />Base fee revenue rounded 708,000$ 775,200$ 829,200$ 888,000$ 932,400$ 978,000$
<br />Volume Fee Revenue needed 4,647,831$ 5,089,435$ 5,445,959$ 5,826,421$ 6,117,742$ 6,424,649$
<br />Volume rate 2.03$ 2.22$ 2.38$ 2.54$ 2.67$ 2.80$
<br />Little Canada
<br />Revenue Requirement 1,128,007$ 1,235,167$ 1,321,629$ 1,414,143$ 1,484,850$ 1,559,093$
<br />Preliminary Volume Rate 2.03$ 2.22$ 2.38$ 2.54$ 2.67$ 2.80$
<br />Preliminary Volume Fee Revenue 959,287$ 1,050,419$ 1,123,949$ 1,202,625$ 1,262,756$ 1,325,894$
<br />Base fee revenue 168,720$ 184,748$ 197,680$ 211,518$ 222,094$ 233,199$
<br />Monthly Base Fee rounded 14,100$ 15,400$ 16,500$ 17,600$ 18,500$ 19,400$
<br />Base fee revenue rounded 169,200$ 184,800$ 198,000$ 211,200$ 222,000$ 232,800$
<br />Volume Fee Revenue needed 958,807$ 1,050,367$ 1,123,629$ 1,202,943$ 1,262,850$ 1,326,293$
<br />Volume rate 2.03$ 2.22$ 2.38$ 2.54$ 2.67$ 2.80$
<br />U of M
<br />Revenue Requirement 641,469$ 702,408$ 751,577$ 804,187$ 844,397$ 886,617$
<br />Preliminary Volume Rate 3.11$ 3.41$ 3.64$ 3.90$ 4.09$ 4.30$
<br />Preliminary Volume Fee Revenue 488,545$ 534,956$ 572,403$ 612,471$ 643,095$ 675,250$
<br />Base fee revenue 152,924$ 167,452$ 179,174$ 191,716$ 201,302$ 211,367$
<br />Monthly Base Fee rounded 12,700$ 14,000$ 14,900$ 16,000$ 16,800$ 17,600$
<br />Base fee revenue rounded 152,400$ 168,000$ 178,800$ 192,000$ 201,600$ 211,200$
<br />Volume Fee Revenue needed 489,069$ 534,408$ 572,777$ 612,187$ 642,797$ 675,417$
<br />Volume rate 3.11$ 3.40$ 3.65$ 3.90$ 4.09$ 4.30$
|