|
<br />City of Roseville - Electric Franchise Fee Estimate
<br />Information Based on Year Ending November 2002
<br />
<br /> Xcel %of Franchise Fee Franchise Fee
<br /> Customer Electric Electric Revenues Based on Revenues
<br />Class Accounts kWh Revenues Revenues as % Elac. RlIv. Fee Per kWh (from FeelkWh
<br />Residential 14,758 109,862,927 $8,465,427.00 0.56% $47,406.39 $0.00033 $36,254.77
<br />8m C&! - Non-Oem 1,049 15,881,998 $1,179,471.00 0.56% $6,605.04 $0.00033 $5,241.06
<br />Sm C&I - Demand 860 108,401,108 $6,356,409.00 0.56% $35,595.89 $0.00033 $35,772.37
<br />Large C&I 201 285,774,218 $14,203,753.00 0.56% $79,541.02 $0.00033 $94,305.49
<br />Public Street Ltg 33 1,316,984 $151,513.00 0.56% $848.47 $0.00033 $434.60
<br />Muni Pumping - NfD 22 98,276 $8,006.00 0.56% $44.83 $0.00033 $32.43
<br />Muni Pumping - Oem 3 129,953 $11,357.00 0.56% $63.60 $0.00033 $42.88
<br />Total 16,926 521,465,464 $30,375,936.00 0.56% $170,105.24 $0.00033 $172,083.60
<br />" (For$170,OOOesl;maledslreellighlbudgel)
<br />
<br /> Xcel %of Franchise Fee Franchise Fee
<br /> Customer Electric Electric Revenues Based on Revenues
<br />Class Accounts kWh Revenues Revenues (lls%EI(lc.R(lv. Fee Per kWh {lromFulkWh
<br />Residential 14,758 109,862,927 $8,465,427.00 0.77% $65,183.79 $0.00045 $49,438.32
<br />Sm C&I - Non-Oem 1,049 15,881,998 $1,179,471.00 0.77% $9,081.93 $0.00045 $7,146.90
<br />Sm C&I - Demand 860 108,401,108 $6,356,409.00 0.77% $48,944.35 $0.00045 $48,780.50
<br />large C&I 201 285,774,218 $14,203,753.00 0.77% $109,368.90 $0.00045 $128,598.40
<br />Public Street Llg 33 1,316,984 $151,513.00 0.77% $1,166.65 $0.00045 $592.64
<br />Muni Pumping - N/D 22 98,276 $8,006.00 0.77% $61.65 $0.00045 $44.22
<br />Muni Pumping - Oem 3 129,953 $11,357.00 0.77% $87.45 $0.00045 $58.48
<br />Total 16,926 521,465,464 $30,375,936.00 0.77% $233,894.71 $0.00045 $234,659.46
<br />. (For $231,000 estimated Slreetlighlblldgel)
<br />Typical Monthly Bills by Customer Class (for $231,000 estimated street light budget)
<br />Residential Without Saaee Heatina
<br />Kilowatt-Hours 250 500 750 1,000 1,500
<br />Monthly Bill $21.58 $38.53 $55.48 $72.43 $106.33
<br />Franchise Fee (% of Elm:. Rev) $0.17 $0,30 $0.43 $0.56 $0.82
<br />Percent of bill 0.770% 0.770% 0.770% 0.770% 0.770%
<br />Franchise Fee (Fee/kWh) $0.11 $0.23 $0.34 $0.45 $0.68
<br />Percent of bill 0,521% 0.584% 0.608% 0.621% 0.635%
<br />Residential With Soace Heatina
<br />Kilowatt-Hours 1,000 1,500 2,000 2,500 3,000
<br />Monthly Bill $66.10 $96.08 $126.06 $156.04 $186.02
<br />Franchise Fee (% 01 Elec. Rov) $0,51 $0.74 $0.97 $1.20 $1.43
<br />Percent of bill 0.770% 0.770% 0.770% 0.770% 0.770%
<br />Franchise Fee (Fee/kWh) $0.45 $0.68 $0.90 $1.13 $1.35
<br />Percent of bill 0.681% 0.703% 0.714% 0.721% 0.7;26%
<br />8m C&I - N/D
<br />Kilowatt.Hours 500 1,500 2,000 2,500 3,000
<br />Monthly BHI $40.60 $107.89 $141.54 $175.19 $208.83
<br />Franchise Fee (% of Elec. Rev) $0.31 $0.83 $1.09 $1.35 $1.61
<br />Percent of blll 0.770% 0.770% 0.770% 0.770% 0.770%
<br />Franchise Fee (Foofl<Wh) $0.23 $0.68 $0.90 $1.13 $1.35
<br />Percent of bill 0.554% 0.626% 0.636% 0.642% 0.646%
<br />Sm & Laroe C&I - Demand
<br />Kllowatts 25 95 100 500 1000
<br />Kilowatt-Hours 2,000 40,000 10,000 200,000 650,000
<br />Monthly Bill $274.67 $1,976.20 $1,094.00 $10,052.76 $26,094.61
<br />Franchise Fee (% or Elec. Rev) $2.11 $15.22 $8.42 $77.41 $200.93
<br />Percent of bill 0.770% 0.770% 0.770% 0.770% 0.770%
<br />Franchise Fee (Fee/kWh) $0.90 $18.00 $4.50 $90.00 $292.50
<br />Percenlofbil! 0,328% 0.911% 0.411% 0.895% 1.121%
<br />" DataSoUfce:Revenue Query Dalabase
<br />
|