|
City of Little Canada - Gas Franchise Fee Estimate
<br />Information Based on Year Ending April 2003
<br />CLASS
<br />CUSTOMER
<br />ACCOUNTS
<br />THERMS
<br />REVENUE
<br />FRANCHISE
<br />FEE
<br />PERCENT
<br />PER THERM
<br />PER MONTH
<br />Residential
<br />2,540
<br />2,638,992
<br />2,176,466
<br />$30,480
<br />1.4%
<br />$1.00
<br />Comm. Firm Non Demand
<br />391
<br />863,491
<br />687,553
<br />$28,152
<br />4.1%
<br />$6.00
<br />Comm. Firm Demand
<br />72
<br />1,490,429
<br />1,077,364
<br />$43,200
<br />4.0%
<br />$50.00
<br />Small Interruptible
<br />9
<br />635,972
<br />364,841
<br />$13,500
<br />3.7%
<br />$125.00
<br />Med & Lg Interruptible
<br />Firm Transportation
<br />Interruptible Transp.
<br />Total
<br />3,012
<br />5,628,884
<br />$4,306,224
<br />$115,332
<br />2.68%
<br />Residential
<br />Therms
<br />Monthly Bill
<br />Franchise Fee
<br />Percent of Bill
<br />Annual cost • use
<br />Annual cost - flat
<br />20 33
<br />16.1 22.4
<br />$0.23 $0.31
<br />1.4% 1.4%
<br />50
<br />30.6
<br />$0.43
<br />100
<br />54.7
<br />$0.77
<br />1.4% 1.4%
<br />190
<br />98.0
<br />$1.37
<br />1.4%
<br />$ 2.71 $ 3.76 $ 5.14 $ 9.18 $ 16.46
<br />$ 12.00 $ 12.00 $ 12.00 $ 12.00 $ 12.00
<br />Commercial Firm Non Demand
<br />Therms 280 450 700 1,500 2,125
<br />Monthly Bill 137 212 328 675 945
<br />Franchise Fee $5.62 $8.68 $13.46 $27.66 $38.76
<br />Percent of Bill
<br />Annual cost - use
<br />Annual cost- flat
<br />4.1% 4.1%
<br />4.1% 4.1%
<br />4.1% *
<br />$ 67.43 $ 104.18 $ 161.47 § 331.94 $ 465.12
<br />$ 72.00 $ 72.00 $ 72.00 $ 72.00 $ 7Z00
<br />Commercial Firm Demand
<br />Therms 7,000 7,500 10,000 15,000 50,000
<br />Monthly Bill 2,584 2,758 3,627 5,391 17,329
<br />Franchise Fee 103.37 110.32 145.09 215.64 693,15
<br />Percent of Bill
<br />Annual cost • use
<br />Annual cost - flat
<br />4.0% 4.0%
<br />4.0% 4.0%
<br />4.0% *
<br />$ 1,240.39 $ 1,323.84 $ 1,741.12 $ 2,587.73 $ 8,317.77
<br />$ 600.00 $ 600.00 § 600.00 $ 600.00 $ 600.00
<br />Small Medium, & Large Interruptible
<br />Therms 7,200 20,000 37,000 60,000 768,065
<br />Monthly Bill 2,251 6,030 11,049 14,588 180,884
<br />Franchise Fee 83.28 223.11 408.82 539.77 6,692.70
<br />Percent of Bill
<br />Annual cost - use
<br />Annual cost -flat
<br />3.7% 3.7%
<br />3.7% 3.7%
<br />3.7% *
<br />$ 999.36 $ 2,677.32 $ 4,905.87 $ 6,477.25 $ 80,312.42
<br />$ 1,500.00 $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 1,500.00
<br />Data Source: Revenue Query Database
<br />* Using Xcel's original %' s as fee %, varies by class
<br />Monthly bit includes Distribution, Base Cost, Customer Charge, and CIP
<br />CityFee \NewBrtn \Little Canada Model _V
<br />Attachment D
<br />7/19/2003 T. Breuckman
<br />
|