Laserfiche WebLink
City of Roseville <br />2017 Utility Rate Analysis (Quarterly) <br />Water Rates: Customer -Based <br />Single -Family Residential <br />Multi -Family and Non -Residential <br />5/8" Meter or 3/4" Meter <br />1.0" Meter <br />1.5" Meter <br />2.0" Meter <br />3.0" Meter <br />4.0" Meter <br />6.0" Meter <br />Water Rates: Linear Miles -Based <br />Single -Family Residential (a) <br />Other <br />Linear <br />Base Fee <br />Base Fee Analysis <br />Miles <br /># of <br />Linear Miles <br />Base Fee <br />% of <br />% of <br />39 <br />Customers <br />Base Fee <br />Revenue <br />Customers <br />Revenue <br />%Diff. <br />9,497 <br />$ 53.15 <br />$ 504,766 <br />92.7% <br />84.3% <br />-8.4% <br />Diff <br />Customer <br />Single -Family Residential <br />0.0% <br />0.0% <br />0.0% <br />70 <br />53.15 <br />3,721 <br />0.7% <br />0.6% <br />-0.1% <br />276 <br />66.45 <br />18,340 <br />2.7% <br />3.1% <br />0.4% <br />210 <br />106.10 <br />22,281 <br />2.1% <br />3.7% <br />1.7% <br />144 <br />199.30 <br />28,699 <br />1.4% <br />4.8% <br />3.4% <br />42 <br />398.60 <br />16,741 <br />0.4% <br />2.8% <br />2.4% <br />1 <br />797.20 <br />797 <br />0.0% <br />0.1% <br />0.1% <br />2 <br />1,594.45 <br />3,189 <br />0.0% <br />0.5% <br />0.5% <br />10,242 <br />229 <br />$ 598,534 <br />2.0" Meter <br />199.30 <br />28,699 <br />Linear <br />Base Fee <br />% of <br />Miles <br />Revenue <br />Linear Miles <br />127 <br />$ 504,766 <br />76.3% <br />39 <br />93,768 <br />23.7% <br />166 <br />$ 598,534 <br />(a) Based on 75 SF Homes per linear mile (@ 70 ft/home) <br />% of <br />Revenue <br />% Diff. <br />84.3% <br />8.1% <br />15.7% <br />-8.1% <br />Attachment B <br />Updated 8/23117 <br />Water Rate Sensitivity Analysis <br />Annual <br />Current <br />Base Fee <br />% <br />Revised <br />Revised <br />Diff. Per <br />Fee <br />Revenue <br />Chame <br />Base Fee <br />Revenue <br />Diff <br />Customer <br />Single -Family Residential <br />$ 53.15 <br />$ 504,766 <br />-10% <br />$ 47.84 <br />$ 454,289 <br />$ (50,477) <br />$ (21) <br />Multi -Family and Non -Residential <br />5/8" Meter or 3/4" Meter <br />53.15 <br />3,721 <br />54% <br />81.85 <br />5,730 <br />2,009 <br />115 <br />1.0" Meter <br />66.45 <br />18,340 <br />54% <br />102.33 <br />28,244 <br />9,904 <br />144 <br />1.5" Meter <br />106.10 <br />22,281 <br />54% <br />163.39 <br />34,313 <br />12,032 <br />229 <br />2.0" Meter <br />199.30 <br />28,699 <br />54% <br />306.92 <br />44,197 <br />15,498 <br />430 <br />=745 customers <br />3.0" Meter <br />398.60 <br />16,741 <br />54% <br />613.84 <br />25,781 <br />9,040 <br />861 <br />4.0" Meter <br />797.20 <br />797 <br />54% <br />1,227.69 <br />1,228 <br />430 <br />1,722 <br />6.0" Meter <br />1,594.45 <br />3,189 <br />54% <br />2,455.45 <br />4,911 <br />1,722 <br />3,444 <br />$ 598,534 <br />$ 598,692 <br />158 <br />NOTE: A 10% decrease in SF rates <br />would require <br />a corresponding <br />increase of 54% for <br />all other properties <br />