The URL can be used to link to this page

Memo- 2012 BudgetCITY OF HOPKINS FINANCE DEPARTMENT MEMORANDUM Date: August 5, 2011 To: Mayor & City Council From: Christine Harkess, Finance Director Subject: 2012 Budget A revised General Fund budget is attached for your review. The increase in General Fund expenditures is at 3.26%, an increase from 2.96% that was presented at the last work session. This results in a tax levy increase of 2.30% down from the 2.43% previously presented. The addition of the electrical inspector, corresponding revenues, and modifications to individual budgets resulted in these changes. These will be discussed further at the work session. I still do not have all the factors for the tax rate calculation so we do not yet know how this will impact individual properties. We continue to work toward obtaining this information and if received by Tuesday we will provide this detail. I do know however, that the former market value homestead credit (MVHC) has been converted to a value exclusion for qualifying properties and this will result in a reduction of value for the City with the end result being an increased tax rate as we are spreading the needed taxes on less value. The city collects all taxes levied, qualifying homeowners get a credit on their taxes similar to the former MVHC program but instead of the state paying the former MVHC credit all other properties in Hopkins will be paying for the reduction in taxes to qualifying homeowners. In addition, information regarding the electric and gas franchise fee is attached. I briefly spoke with our government relations representative from Xcel who indicated that they no longer do percentage based fees, however I have a summary of the MN communities in which they have franchise fees (attached) and there are several who have percentage based fees so I will be following up with her when she is back in the office on Monday to get clarification. I have put a proposal together for suggested rate increases to get the discussion started. As previously discussed any increase in the rate will be earmarked for capital improvements. Attached are the following: 1. Preliminary General Fund Budget - updated 2. 2012 Preliminary Tax Levy and a history of the tax levy from 2004 — 2011 3. Analysis of electric and gas franchise fees 4. Xcel rates by customer class and number of cities with that rate a. At this point I don't have a similar report from Centerpoint but we have a request in to see if we can get one. 5. Xcel Energy electric surcharges (franchise fees) for MN communities 08/04/2011 CITY OF HOPKINS ANALYSIS OF GENERAL FUND EXPENDITURE BUDGET Inspections Increase Building Code Inspections 252,170 270,030 17,860 195,311 (Decrease) Fire Inspections 38,205 Materials (3,407) 34,497 2011 2012 from % 2,043 Supplies Capital Intergovt'I Department Budget Budget 2011 Budget Incr/(Decr) Salaries & Services Outlay Chargeback's jCIty Council 71,547 68,697 2,850 -3.98%j 26,497 42,200 2,974 Administrative Services 3,566 Vacant Property Management 2,700 2,700 - - 2,700 Administration 167,300 171,047 3,747 3.51% 214,622 22,425 (66,000) Personnel 43,924 44,563 639 57,148 3,415 (16,000) Wellness 2,000 2,000 - 2,000 Information Services 238,446 252,316 13,870 244,881 29,435 (22,000) Total Administrative Services 451,670 469,926 18,256 4.04% Finance Budget 23,066 26,368 3,302 37,324 3,044 (14,000) Debt Management - - - 12,448 1,670 (14,118) General Accounting 129,448 135,766 6,318 145,713 40,053 (50,000) Payroll 46,729 45,541 (1,188) 60,441 5,100 (20,000) TIF Administration - - - 12,448 2,495 (14,943) Utility Billing 4,000 5,000 1,000 93,630 25,478 (114,108) Total Finance 203,243 212,675 9,432 4.64% Le al 135,000 135,000 - 0.00% 135,000 Munici al Building 294,818 297,637 2,819 0.96% 136,412 201,225 (40,000) Rece tionist 44,172 45,168 996 2.25% 44,389 779 lAssessing 167,236 173,766 6,530 3.90% 85,988 111,778 (24,000) City Clerk City Clerk 19,360 20,011 651 38,808 6,203 (25,000) Records Management 29,833 35,945 6,112 30,709 17,236 (12,000) Elections 50,222 62,547 12,325 33,051 29,496 Total City Clerk 99,415 118,603 19,088 19.20% Inspections Building Code Inspections 252,170 270,030 17,860 195,311 74,719 Fire Inspections 38,205 34,798 (3,407) 34,497 301 Heating & Plumbing Inspections 90,400 92,443 2,043 88,669 3,774 Housing Inspections 134,680 137,161 2,481 129,720 7,441 Restaurant & Hotel Inspections 23,309 23,005 (304) 2,921 20,084 Misc. Community Inspections 75,143 78,117 2,974 74,551 3,566 Vacant Property Management 2,700 2,700 - - 2,700 Total Inspections 616,607 638,254 21,647 3.51% 12,709 Police Police Administration 480,615 503,587 22,972 403,120 100,467 Patrol 2,360,705 2,499,513 138,808 2,240,954 258,559 Heat Team 73,298 76,866 3,568 56,609 20,257 Reserves 33,620 34,769 1,149 26,352 8,417 Investigations 499,148 516,731 17,583 440,803 75,928 Metro Drug Task Force 105,737 105,686 (51) 104,496 1,190 Pawn Shop 3,436 3,523 87 3,385 138 Outreach 80,804 84,148 3,344 71,439 12,709 Fire (Decrease) Materials 2011 2012 from % Supplies Capital Intergovt'I Department Budget Budget 2011 Budget Incr/(Decr) Salaries & Services Outlay Chargeback's Communications (Dispatch) 526,782 555,001 28,219 475,608 79,393 Support Services (Records) 255,560 254,816 (744) 246,588 8,228 Systems Management 64,682 65,182 500 65,182 Total Police 4,484,387 4 699 822 215,435 4.80% Fire Fire Department 833,587 853,458 19,871 503,936 349,522 Emergency Preparedness 4,671 4,880 209 - 4,880 Total Fire 838,258 858,338 20,080 2AW/fl Public Works PW Building 33,692 32,965 (727) 36,071 66,894 (70,000) Equipment Services 78,446 86,330 7,884 211,794 17,536 (143,000) Administration 26,478 27,924 1,446 162,347 13,577 (148,000) Engineering 137,802 133,242 (4,560) 168,918 29,324 (65,000) Street & Alleys 853,812 858,720 4,908 360,526 610,194 (112,000) Snow & Ice Removal 205,615 197,550 (8,065) 119,918 77,632 - Parks 628,101 652,569 24,468 434,738 217,831 Tree Service 210,454 209,904 550 125,680 84,224 Total Public Works 2,174,400 2 199 204 24,804 1.14% Recreation Playground 20,198 21,034 836 21,034 Ice Rink 12,284 12,192 (92) 12,192 Park Service 12,518 12,810 292 12,810 - Joint Recreation 147,000 152,000 5,000 152,000 Skate Park 7,721 7,099 622 4,852 2,247 Total Recreation 199,721 205,135 5,414 Activity Center Act Ctr - Community Use 274,008 266,031 (7,977) 209,725 56,306 Act Ctr - Maintenance 59,463 58,964 499 18,047 40,917 Total Activity Center 333,471 324,995 8,476 -2.54% ]Plarming & Zoning 125,182 127,871 2,689 2.15% 131,082 16,789 (20,000) Tuition Reimbursement 10,200 10,200 - 0.00% lContingency 60Y000 50,000 - 0.00% Total Expenditures 10,299,327 10,635,191 335,864 3.26% 8,403,202 3,161,958 (990,169) 79.01% Other Financing Uses Transfers Out 10,574,991 Total Other Financing Uses 0.00%1 10,200 50,000 �1 10,635,191 2.24% CITY OF HOPKINS ANALYSIS OF GENERAL FUND REVENUE BUDGET Finance Police Increase 5,200 5,750 550 449 Miscellaneous (Decrease) 4,800 - 2011 2012 from Department Budget Budget 2011 Budget Incr/(Decr) Unallocated 115,000 - 0.00% 10,000 6,000 Property Taxes - levy 8,797,414 10,000 (8,797,414) Property Taxes - delinq 45,000 45,000 - Penalties 6,000 8,000 2,000 Miscellaneous 15,000 15,000 - Fiscal Disparities (incl w/taxes) - - 300 PERA Aid 20,510 20,510 - MVHC - unallotment (232,850) - 232,850 Interest Earnings 75,000 25,000 (50,000) Franchise Fees 290,000 290,000 - Miscellaneous 500 - (500) Total Unallocated 9,016,574 403,510 (8,613,064) -95.52% Finance Police 400 Current Services 5,200 5,750 550 449 Miscellaneous 4,800 4,800 - Total Finance 10,000 10,550 550 5.50% Total City Clerk 22,100 13,000 9,100) -41.18% 360 Le al - Court Fines 115,000 115,000 - 0.00% Municipal Building 380 Rent 2,500 2,500 449 Other Miscellaneous - - Total Municipal Bulldlnq 2,500 2,500 - 0.00% 400Assessin - Charges for Service 1,000 1,200 200 20.00% City Clerk Police 312 Licenses 7,500 5,000 (2,500) 364 Administrative Citations 3,500 8,000 4,500 400 Charges for Service 11,100 - (11,100) Total City Clerk 22,100 13,000 9,100) -41.18% Inspections Police 318 Licenses and permits 255,100 274,100 19,000 Plan Check Fees 32,000 32,000 - Char es for Service 39,450 39,950 500 Total Inspections 326,550 346,050 19,500 5.97% Property Intergovt'I Taxes Revenue 08/04/2011 Licenses Charges Permits Investment for Current Other Franchise & Fines Earning Services Revenues Fees 45,000 Police 8,000 330 Federal Grant - - - 344 State Aid 177,700 177,000 (700) 345 State Grants 4,000 10,000 6,000 345 POST Reimbursement 10,000 9,000 (1,000) 115,000 911 Service Fee - IGR 24,860 24,860 2,500 County Grants - - - 313 Licenses 95,900 96,200 300 360 Court Fines 20,000 - (20,000) Forfeitures 39,950 - Penalties 2,500 2,500 9,000 400 Charges for Services 43,500 40,000 (3,500) 449 Other Miscellaneous - 500 500 440 Contributions 500 500 - Totai Police 378,960 360,560 18,400) -4.86% Property Intergovt'I Taxes Revenue 08/04/2011 Licenses Charges Permits Investment for Current Other Franchise & Fines Earning Services Revenues Fees 45,000 8,000 15,000 20,510 25,000 290,000 5,750 4,800 115,000 2,500 1,200 5,000 8,000 274,100 32,000 39,950 177,000 10,000 9,000 24,860 96,200 2,500 40,000 500 500 Increase (Decrease) Licenses Charges 2011 2012 from % Property Intergovt'I Permits Investment for Current Other Franchise Department Budget Budget 2011 Budget Incr/(Decr) Taxes Revenue & Fines Earning Services Revenues Fees 3,500 70,000 9,415 125,000 1.000 68,000 436,370 514,715 1,694,535 2012 Revenue Shortfall - LEVY NEEDED( (8,940.656) 8,905,156 No levy limits for 2012 35,500 Special Levy - PERA 2011 Levy - inlcudes special levies for GF 8,797,414 8,940,656 Total Estimated TAX LEVY 1,694,535 Non tax revenues 10,635,191 Total Revenues shortfall 70,000 2,750 4,000 26,000 15,000 8,500 10,700 2,000 800 1,500 92,000 25,000 245,150 115,300 290,000 Total Misc 405,300 Fire 318 Licenses 3,500 3,500 9,415 320 Permits 1,800 - (1,800) 125,000 Federal Grant - - Equipment Use Charge 344 State Aid 85,000 70,000 (15,000) Charges for Service County Grants - - 449 Administrative Citations - - - 400 Current Service 6,200 70,000 63,800 - Donations Total Public Works - 141,165 Miscellaneous - - Total Fire 96,500 143,500 47,000 48.70% 3,500 70,000 9,415 125,000 1.000 68,000 436,370 514,715 1,694,535 2012 Revenue Shortfall - LEVY NEEDED( (8,940.656) 8,905,156 No levy limits for 2012 35,500 Special Levy - PERA 2011 Levy - inlcudes special levies for GF 8,797,414 8,940,656 Total Estimated TAX LEVY 1,694,535 Non tax revenues 10,635,191 Total Revenues shortfall 70,000 2,750 4,000 26,000 15,000 8,500 10,700 2,000 800 1,500 92,000 25,000 245,150 115,300 290,000 Total Misc 405,300 Public Works 329 Licenses & Permits 9,490 9,415 (75) 344 State Aid 120,000 125,000 5,000 384 Equipment Use Charge - - - 400 Charges for Service 2,250 2,750 500 449 Miscellaneous Revenue 2,100 4,000 1,900 450 Sale of Fixed Assets - - - Total Public Works 133,840 141,165 7,325 5.47% Activity Center 380 Rent 26,000 26,000 - 400 Charges for Services 15,000 15,000 404 Memberships 8,500 8,500 440 Contributions 10,700 10,700 445 Fundraising 2,000 2,000 449 Other Miscellaneous 800 800 Total Activity Center 63,000 63,000 0.00% Planning & Zoning 320 Permits 1,000 1,000 387 Variances 1,500 1,500 400 Charges for Service - Total Planning & zoning 2,500 2,500 0.00% Excess Funds from Section 8 92,000 Use of 2009 Budget Reserves 130,803 - Total Revenues 10,299,327 1,694,535 (8,565,989) -83.17% Total Expenditures 10,299,327 10,635,191 335,864 3.26% 3,500 70,000 9,415 125,000 1.000 68,000 436,370 514,715 1,694,535 2012 Revenue Shortfall - LEVY NEEDED( (8,940.656) 8,905,156 No levy limits for 2012 35,500 Special Levy - PERA 2011 Levy - inlcudes special levies for GF 8,797,414 8,940,656 Total Estimated TAX LEVY 1,694,535 Non tax revenues 10,635,191 Total Revenues shortfall 70,000 2,750 4,000 26,000 15,000 8,500 10,700 2,000 800 1,500 92,000 25,000 245,150 115,300 290,000 Total Misc 405,300 CITY OF HOPKINS ANALYSIS OF TAX LEVY 08/04/2011 Special Levies: PERA Levy MVHC Levy - for unallotment of 2008 & 2009 MVHC Levy - for unallotment of 2010 Subtotal - Special Levies Other Debt Levies: 1999D GO Perm Impr Revolving Bonds 2001 GO Refunding Bonds - Park & Rec 2002B GO Improv Revolving Bonds 2003 HRA Revenue Bonds 2007B GO Improv Revolving Bonds 2007A Capital Improvement Bonds 2010A GO Improvement Bonds 2010B Refunding (20028 Improv Bds) Subtotal - Debt Levies Total - Special Levies TOTAL LEVIES Increase over prior year Percentage Incr (Decr) - Total Tax Capacity Rate (per HC rate cards) 11,815 11,815 11,815 11,815 11,815 35,500 35,500 35,500 35,500 - - - - - - 239,175 - - levied back 60% 398,492 2008 & 2009 unallotment - - 222,850 - levied back 95.7% 232,850 2010 unallotment 11,815 21,815 31,815 31,815 11,815 35,500 274,675 258,350 35,500 (b) 26,000 26,000 26,000 26,000 26,000 26,000 - - - 210,000 190,000 180,000 175,000 150,000 130,000 108,000 - 59,000 59,000 59,000 59,000 59,000 59,000 59,000 59,000 - - 234,450 240,000 235,000 230,000 225,000 200,000 200,000 220,000 2023 - - - 175,000 175,000 185,000 172,000 184,500 2017 642,000 642,000 715,000 710,000 765,900 2022 910,900 levy requirement - - - 100,000 77,000 2025 145,000 less - Enterprise Fund Leases - - - - 59,000 2013 765,900 - Reduction due to adequate cash projections 1,038,000 812,000 1,217,000 1,207,000 1,282,000 1,257,000 1,267,000 1,241,000 1,306,400 5.27% 765,900 $ 1,049,815 $ 833,815 $ 1,248,815 $ 1,238,815 $ 1,293,815 $1,292,500 $1,541,675 $ 1,499,350 $ 1,341,900 -10.50% $ 7,704,136 $ 8,120,078 $ 8,438,078 $ 8,805,758 $ 9,194,380 $ 9,553,114 $ 9,925,685 $10,138,414 $ 10,372,056 2.30% $ 535,884 $ 415,942 $ 318,000 $ 367,680 $ 388,622 $ 358,734 $ 372,571 $ 212,729 $ 233,642 7.48% 5.40% 3.92% 4.36% 4.41% 3.90% 3.90% 2.14% 2.30% 56.664 48.944 48.262 45.8762 45.401 47.315 48.999 55.739 Incr from Purpose 2004 2005 2006 2007 2008 2009 2010 2011 2012 Est 2011 Subject to Levy Limits General Fund $ 6,654,321 $ 7,261,263 $ 7,164,263 $ 7,516,943 $ 7,825,565 $8,160,614 $8,384,010 $ 8,539,064 $ 8,905,156 (a) Capital Levy 25,000 25,000 50,000 75,000 100,000 100,000 125,000 Total Levy subject to Limits $ 6,654,321 $ 7,286,263 $ 7,189,263 $ 7,566,943 $ 7,900,565 $ 8,260,614 $ 8,384,010 $ 8,639,064 $ 9,030,156 4.63% 2012 no levy limits 2011 levy limit was 3.04% Special Levies: PERA Levy MVHC Levy - for unallotment of 2008 & 2009 MVHC Levy - for unallotment of 2010 Subtotal - Special Levies Other Debt Levies: 1999D GO Perm Impr Revolving Bonds 2001 GO Refunding Bonds - Park & Rec 2002B GO Improv Revolving Bonds 2003 HRA Revenue Bonds 2007B GO Improv Revolving Bonds 2007A Capital Improvement Bonds 2010A GO Improvement Bonds 2010B Refunding (20028 Improv Bds) Subtotal - Debt Levies Total - Special Levies TOTAL LEVIES Increase over prior year Percentage Incr (Decr) - Total Tax Capacity Rate (per HC rate cards) 11,815 11,815 11,815 11,815 11,815 35,500 35,500 35,500 35,500 - - - - - - 239,175 - - levied back 60% 398,492 2008 & 2009 unallotment - - 222,850 - levied back 95.7% 232,850 2010 unallotment 11,815 21,815 31,815 31,815 11,815 35,500 274,675 258,350 35,500 (b) 26,000 26,000 26,000 26,000 26,000 26,000 - - - 210,000 190,000 180,000 175,000 150,000 130,000 108,000 - 59,000 59,000 59,000 59,000 59,000 59,000 59,000 59,000 - - 234,450 240,000 235,000 230,000 225,000 200,000 200,000 220,000 2023 - - - 175,000 175,000 185,000 172,000 184,500 2017 642,000 642,000 715,000 710,000 765,900 2022 910,900 levy requirement - - - 100,000 77,000 2025 145,000 less - Enterprise Fund Leases - - - - 59,000 2013 765,900 - Reduction due to adequate cash projections 1,038,000 812,000 1,217,000 1,207,000 1,282,000 1,257,000 1,267,000 1,241,000 1,306,400 5.27% 765,900 $ 1,049,815 $ 833,815 $ 1,248,815 $ 1,238,815 $ 1,293,815 $1,292,500 $1,541,675 $ 1,499,350 $ 1,341,900 -10.50% $ 7,704,136 $ 8,120,078 $ 8,438,078 $ 8,805,758 $ 9,194,380 $ 9,553,114 $ 9,925,685 $10,138,414 $ 10,372,056 2.30% $ 535,884 $ 415,942 $ 318,000 $ 367,680 $ 388,622 $ 358,734 $ 372,571 $ 212,729 $ 233,642 7.48% 5.40% 3.92% 4.36% 4.41% 3.90% 3.90% 2.14% 2.30% 56.664 48.944 48.262 45.8762 45.401 47.315 48.999 55.739 ANALYSIS OF FRANCHISE FEE REVENUES Revenues 2010 No of Estimated 286,403.63 2010 287,262.55 2007 No of Propsd Customers 2010 2012 General Fund Increase Current Customers TOTAL 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Xcel Enerov Rate Dec 2010 2.00 7,915 47,490.00 189,960.00 94,484.19 Residential 1.00 7,939 94,484.19 23,450.29 23,527.90 23,735.54 23,770.46 Small C & I Non Demand 2.00 691 16,910.11 4,228.28 4,316.43 4,163.21 4,202.19 Small C & I Demand 9.00 318 34,643.40 8,785.17 8,600.88 8,636.88 8,620.47 Large C & 1 63.00 59 42,556.50 10,708.11 10,584.00 10,428.39 10,836.00 208,869.80 188,594.20 47,171.85 47,029.21 46,964.02 47,429.12 Current (1.54) (0.60) (1.15) 0.50 (0.29) Increase Centerpoint Energy Rate 188,592.66 47,171.25 47,028.06 46,964.52 47,428.83 to CIP Write off Recovery (4,294.69) 2.00 (4,294.69) 27,528.00 110,112.00 53,404.60 56,707.40 Commercial B 2010 6.00 232 4,176.00 16,704.00 Centerpoint Energy 9,768.00 Commercial/Industrial C TOTAL 20.00 325 19,500.00 78,000.00 Residential/Commercial A 1.00 4,525 53,404.60 13,478.60 13,581.40 12,918.80 13,425.80 Commercial B 3.00 203 6,936.00 1,746.00 1,692.00 1,695.00 1,803.00 Commercial/Industrial C 9.00 248 27,459.00 7,200.00 7,164.00 7,020.00 6,075.00 Small Dual Fuel A 18.00 21 4,356.00 1,134.00 1,116.00 1,152.00 954.00 Small Dual Fuel B 63.00 9 6,615.00 1,701.00 1,575.00 1,701.00 1,638.00 Large Volume Dual Fuel 63.00 - (54.00) - 126.00 (180.00) - 98,716.60 25,259.60 25,254.40 24,306.80 23,895.80 TOTAL 287,309.26 excl write off recovery Analysis of Revenues Generated from New Rates Franchise Revenues 2010 No of Estimated 286,403.63 2010 287,262.55 2007 Current Propsd Customers Quarterly 2012 General Fund Increase Xcel Energy Rate Rate June 2011 Revenue Annual Revenue to CIP Residential 1.00 2.00 7,915 47,490.00 189,960.00 94,484.19 95,475.81 Small C & I Non Demand 2.00 4.00 730 8,760.00 35,040.00 16,910.11 18,129.89 Small C & I Demand 9.00 20.00 328 19,680.00 78,720.00 34,643.40 44,076.60 Large C & 1 63.00 126.00 62 23,436.00 93,744.00 42,556.50 51,187.50 99,366.00 397,464.00 188,594.20 208,869.80 No of Estimated 2010 Current Propsd Customers Quarterly 2012 General Fund Increase Centerpoint Energy Rate Rate June 2011 Revenue Annual Revenue to CIP Residential/Commercial A 1.00 2.00 4,588 27,528.00 110,112.00 53,404.60 56,707.40 Commercial B 3.00 6.00 232 4,176.00 16,704.00 6,936.00 9,768.00 Commercial/Industrial C 9.00 20.00 325 19,500.00 78,000.00 27,459.00 50,541.00 Small Dual Fuel A 18.00 35.00 31 3,255.00 13,020.00 4,356.00 8,664.00 Small Dual Fuel B 63.00 126.00 10 3,780.00 15,120.00 6,615.00 8,505.00 Large Volume Dual Fuel 63.00 126.00 - - - - - 58,239.00 232,956.00 98,770.60 134,185.40 Totals 630,420.00 287,364.80 343,055.20 Franchise Revenues 2010 287,309.26 2009 286,403.63 2008 287,262.55 2007 288,904.47 2006 285,588.68 2005 307,456.67 2004 242,431.30 Xcel Energy Rates and Number of Cities with that Rate Xcel Energy Residential Small C & I Non Demand Small C & I Demand Large C&I No of Current Customers Rate June 2011 1.00 7,915 2.00 730 9.00 328 63.00 62 Current Rate Proposed Rate Xcel Energy Rates and Number of Cities with that Rate Res Fee Sm C&I Non Dmd Sm C&I Dmd Large C&I 0.50 1 1.00 1 2.50 3 2.50 2 0.75 2 1.10 1 2.75 1 2.75 1 1.00 4 1.38 1 4.50 1 4.50 1.30 3 1.50 2 4.64 1 5.00 1.35 1 1.60 1 5.00 1 7.50 1.50 4 1.65 1 8.25 1 10.00 1.52 1 1.75 1 9.00 4 15.45 1.65 1 2.00 6 9.25 1 33.00 2.00 4 2.50 4 10.00 4 36.00 2.05 1 2.75 1 13.25 1 50.00 2.06 1 3.00 3 14.00 3 51.00 2.35 1 3.10 1 14.40 1 55.00 2.50 6 3.25 1 15.00 2 63.00 2.60 1 4.00 1 16.00 1 67.50 2.75 2 4.50 3 18.00 1 70.00 3.00 3 4.64 1 20.60 1 73.00 3.25 1 5.00 4 21.00 1 75.00 5.25 1 22.50 1 91.51 5.50 1 25.00 3 99.00 6.00 1 31.00 1 110.00 6.33 1 32.00 1 110.28 8.00 1 35.00 2 125.00 40.00 1 130.00 136.50 190.00 206.00 230.00 280.00 335.00 1 1 1 1 1 1 1 3 1 2 1 1 1 1 1 1 1 1 1 3 1 1 1 1 1 1 1 Centerpoint Energy Rates and Number of Cities with that Rate Current Rate Proposed Rate Centerpoint Energy Small Dual Small Dual Large Volume No of Residential Commercial A Comm/Ind B Comm/Ind C Fuel A Fuel B Dual Fuel Current Customers 0.95 1 1.00 2 1.00 1 1.00 2 1.00 1 1.00 2 1.00 1 Centerpoint Energy Rate June 2011 1.00 4 1.50 1 2.50 2 2.50 2 2.50 2 2.50 2 2.50 2 Residential/Commercial A 1.00 4,588 1.40 1 1.58 1 2.75 1 2.75 1 2.75 1 2.75 1 2.75 1 Commercial B 3.00 232 1.50 3 1.80 1 3.00 2 3.00 1 3.00 2 3.00 2 3.00 1 Commercial/Industrial C 9.00 325 1.52 1 2.00 1 4.00 2 5.00 3 5.00 2 5.00 1 5.00 3 Small Dual Fuel A 18.00 31 1.65 1 2.05 1 5.00 6 8.00 1 10.00 1 10.00 1 14.08 1 Small Dual Fuel B 63.00 10 2.00 5 2.50 4 5.15 1 8.25 1 13.25 1 13.25 1 17.00 1 Large Volume Dual Fuel 63.00 - 2.05 1 2.75 2 5.25 1 9.00 1 13.33 1 14.08 1 24.75 1 2.50 3 3.00 2 6.00 1 10.00 1 14.08 1 16.50 1 25.00 1 2.75 2 3.33 1 6.33 1 12.00 1 15.00 1 17.00 1 50.00 2 3.00 1 4.00 1 8.00 2 13.25 1 16.50 1 20.00 2 60.00 1 4.95 1 8.25 1 14.08 1 17.00 1 30.00 1 63.00 1 5.00 5 9.00 1 15.00 1 18.00 1 35.00 1 73.00 1 6.00 0 10.00 1 16.00 1 20.00 1 40.00 1 75.00 1 20.00 0 20.00 1 30.00 1 63.00 1 98.88 1 20.60 1 35.00 1 98.88 1 125.00 1 27.00 1 51.50 1 125.00 1 126.00 0 35.00 2 70.00 1 126.00 0 300.00 1 35.00 75.00 1 150.00 1 750.00 1 100.00 1 300.00 1 900.00 1 Northern States Power Company, a Minnesota corporation Minneapolis Minnesota 55401 Updated: 03/01/2011 MINNESOTA CITY SURCHARGES - ELECTRIC Page 1 of 7 FRANCHISE FEES A franchise fee as designated below will be included in the customers' monthly bills computed under the indicated rate classes and effective in the following Minnesota communities: - Indicates fee is not applied (U) Indicates unincorporated community (� p X C UE l0 f)Z car, Vv W a1F E (DJ U d J Nrn �? d C CL E 20..2 mc" t1 .� lC CE E 2aQ Y Q VCL W d 0 c o i W Afton $2.00 $2.00 $5.00 $5.00 $1.00 $1.00 $1.00 0112005 08/16/2024 Albertville $2.50 $5.00 $10.00 $50.00 $2.00 - - 03!2011 09/07/2029 Baker (U) $3.25 $3.25 - - - - - 03/1994 -- Bayport $1.50 $3.00 $25.00 $50.00 $3.00 $3.00 $25.00 02/2011 12/31/2013 Brooklyn Center $1.52 $3.10 $20.60 $99.00 $12.40 $12.40 $12.40 0412009 12/08/2023 Champlin $2.50 $8.00 $35.00 $125.00 $15.00 $15.00 $15.00 01/2009 11/23/2028 Chisago City $1.30 $5.00 $15.00 $55.00 $5.00 $5.00 $15.00 06/2009 02/28/2029 Circle Pines $2.75 $3.00 $35.00 $3.00 - - 1012009 08/24/2029 Coon Rapids b 4.0% 4.0% 4.0% 4.0% - - - 07/1992 01/13/2012 Cottage Grove $1.65 $1.65 $8.25 $33.00 $3.30 $0.83 $8.25 01/2010 11/04/2023 Deephaven $2.50 $2.50 $2.50 $2.50 $2.50 $2.50 $2.50 04/2002 11/02/2030 Dilworth $2.60 $6.00 $21.00 $136.50 - $6.00 $21.00 01/2011 05/10/2018 Excelsior $2.50 $2.50 $2.50 $2.50 $2.50 $2.50 $2.50 12/2005 10/1812012 Faribault` $1.35 $1.60 $32.00 $280.00 - - - 01/2006 11/08/2024 Golden Valley $2.00 $2.00 $22.50 $206.00 - - - 01/2011 12/17/2027 Goodview $2.75 $3.00 $25.00 $110.00 $25.00 $2.50 $10.00 07/2006 04/30/2026 Grant $2.35 $2.00 $14.00 $75.00 $2.00 $2.00 $2.00 01/2010 12/31/2014 Hopkins $1.00 $2.00 $9.00 $63.00 - - - 02/2004 12/31/2011 Lindstrom $1.30 $5.00 $15.00 $55.00 $5.00 $5.00 $15.00 06/2009 02/28/2029 Little Canada $2.75 $5.25 $40.00 $230.00 $15.50 $2.00 $3.00 07/2010 08/26/2023 Mahtomedi $1.30 $1.38 $14.40 $110.28 $12.71 $0.63 $14.84 01/2005 10/18/2024 Mankato $0.50 $1.00 $10.00 $130.00 $1.00 $0.25 $1.00 10/2008 04/10,12014 Maplewood $0.75 $1.50 $9.00 $67.50 $0.75 $0.75 $0.75 03/2010 02/28/2015 Northern States Power Company, a Minnesota corporation Minneapolis, Minnesota 55401 Updated: 03/01/2011 MINNESOTA CITY SURCHARGES - ELECTRIC Page 2 of 7 m ar m as E E O C S7 N O `� V 7�+ 7� V C 3O V Q tC 0 *' V i U ami t:O 9)Z 1:W `9 bJ 2aZ �3a4i 2n.o W X wo W 3.0% >100 kW at 5.0% 5.0% 5.0% primary or higher voltage a Minneapolis <100 kW at <100 kW at 0 5.010 0 5.0% 0 5.0% 0112005 12/31/2014 effective secondary secondary 5.0% 01/1994 voltage voltage >100 kW at secondary voltage Minnetonka $2.50 $4.50 $4.50 $4.50 - $4.50 $4.50 11/2007 08/09/2018 Monticello $1.95 $5.50 $31.00 $190.00 $12.00 $12.00 $31.00 06/2007 05/31/2027 Mound $2.75 $2.75 $2.75 $2.75 $2.75 $2.75 $2.75 02/2011 12/31/2011 Mounds View 3.87% 3.87% 3.87% 3.87% 3.87% 3.87% 3.87% 01/2011 12/31/2011 New Brighton $0.0023 $0.0023 $0.0016 $0.0009 $0.0023 $0.0023 $0.0016 01/2003 11/25/2022 per kWh per kWh per kWh per kWh per kWh per kWh per kWh New Hope $1.50 $4.50 $9.00 $36.00 $4.50 $4.50 $4.50 0112004 12/08/2011 Newport $1.00 $1.50 $14.00 $70.00 $5.00 $1.00 $10.00 01/2011 10/18/2026 North Mankato $0.75 $1.10 $9.25 $125.00 $13.25 $1.10 $9.25 06/2008 03/31/2014 Oakdale $1.00 $2.00 $9.00 $7.50 $6.00 $1.50 $7.50 09/2008 10/27/2023 Owatonna $0.0016 per kWh Customer peak demand less than 100 kW in calendar year 01/2003 04/01/2022 $0.0014 per kWh Customer peak demand greater than 100 kW in calendar year Prior Lake $1.50 $5.00 $10.00 $50.00 - - - 0712006 03/19/2026 Richfield $2.05 $6.33 $14.08 $91.51 - - - 08/2010 03/12/2027 Robbinsdale 4.0% 4.0% 4.0% 4.0% 4.0% 4.0% 4.0% 06/2009 07/01/2011 4.0% 4.0% 4.0% 4.0% 4.0% 4.0% 4.0% 06/2011 07/01/2013 Sartell e See the fee schedule in the Notes section. 01/2007 12/31/2023 Sauk Rapids 3.0% Customers who purchase $50,000 or less in calendar year 08/2003 06/15/2023 1.5% That part which exceeds $50,000 in calendar year South St. Paul' 3.0% 3.0% 3.0% 3.0% - - 07/2000 06/30/2015 St. Cloud 9 3.0% 3.0% 3.0% 3.0% - - - 09/2007 08/31/2027 2% purchase 5$100,000 in calendar year St. Joseph $1.00 $1.75 $10.00 $8.00 $1.00 $10.00 0212004 11/19/2023 1.5% that part >$100,000 in calendar year Northern States Power Company, a Minnesota corporation Minneapolis Minnesota 55401 Updated: 03/01/2011 MINNESOTA CITY SURCHARGES - ELECTRIC Page 3 of 7 d v C � c d o � � 0 V E U° 2� U N o y 'CL ac c > E E E v� 2 Z E o � CL q 0 x w v ac o rqz ay$' aD E 20.z 2 I w w St. Louis Park $2.00 $4.00 $13.25 $73.00 - $4.00 $10.00 02/2011 02/18/2013 St. Michael $2.50 $2.50 $2.50 $10.00 $10.00 $2.50 $10.00 02/2004 11/24/2023 St. Paul n See the fee schedule in the Notes section. 11/2006 08/31/2026 St. Paul Park $1.50 $2.00 $25.00 $335.00 $10.00 $1.00 $5.00 0812005 05/15/2025 Stillwater $2.00 $2.50 $18.00 $125.00 $4.00 $2.00 $18.00 12/2003 06/30/2015 Watertown $3.00 $4.50 $16.00 $51.00 - $13.50 $21.00 04/2010 04/10/2027 Wayzata $2.06 $4.64 $4.64 $15.45 $1.03 $1.03 $1.03 03/2011 11/30/2026 West St. Paul' 5.26% 5.26% 5.26% 5.26% - - - 12/1966 •- White Bear Lake 1.5% 1.5% 1.5% 1.5% 1.5% 1.5% j 1.5% 0511998 05/01/2018 Winona 4.0% Customers who purchase $100,000 or less in calendar year 06/2003 06/15/2023 1.5% That part which exceeds $100,000 in calendar year Northern States Power Company, a Minnesota corporation Minneapolis, Minnesota 55401 Updated: 03/01/2011 MINNESOTA CITY SURCHARGES — ELECTRIC Page 4 of 7 NOTES a Baker: (Not a franchise fee.) Represents a city fee collected to cover energy usage and maintenance on community street lighting. b Coon Rapids: The franchise fee excludes rate schedules for highway lighting, municipal street lighting, municipal water pumping, municipal fire sirens, and municipal sewage disposal service. ° Faribault: The franchise fee excludes invoices to the city for street lighting and municipal pumping. d Minneapolis: The franchise fee for the residential customer class will change to 4.5% effective January 1, 2013. e Sartell: Effective with January of the respective years, the monthly franchise fee will be as follows: • 2007 and 2008 $2.50 • 2013 and 2014 $3.25 • 2019 and 2020 $4.00 • 2009 and 2010 $2.75 • 2015 and 2016 $3.50 • 2021 and 2022 $4.25 • 2011 and 2012 $3.00 • 2017 and 2018 $3.75 • 2023 $4.50 ' South St. Paul: The franchise fee excludes rate schedules for highway lighting, municipal street lighting, municipal water pumping, municipal traffic signals, municipal fire sirens, and municipal sewage disposal service. e St. Cloud: The franchise fee for residential heating customers will be 1.5% during the months of November - April. Northern States Power Company, a Minnesota corporation Minneapolis, Minnesota 55401 Updated: 03/01/2011 MINNESOTA CITY SURCHARGES - ELECTRIC Page 5 of 7 n St Paul: The monthly franchise fee will be as stated below. The residential service franchise fee will be as stated except during the months of November - April when there will be no fee. The fee shall not exceed $620,000 during any calendar year from any large commercial and industrial customer qualifying for service on the Competitive Market Rider. The schedule below shows the meter, energy, and demand factor for each year of the St. Paul franchise and for each of the customer classifications. Customer Class Meter Factor - Monthly Charge per Account Start Date 1 -Nov -2006 1 -Nov -2008 1 -Nov -2010 1 -Nov -2012 1 -Nov -2014 End Date 31 -Oct -2008 31 -Oct -2010 31 -Oct -2012 31 -Oct -2014 31 -Oct -2016 Residential (May - October) $2.63 $2.70 $2.77 $2.84 $2.91 Small Commercial & Industrial Non -Demand $2.96 $3.09 $3.22 $3.35 $3.48 Firm Secondary $2.96 $3.09 $3.22 $3.35 $3.48 Firm Primary $2.96 $3.09 $3.22 $3.35 $3.48 Interruptible Secondary $2.96 $3.09 $3.22 $3.35 $3.48 Interruptible Primary $2.96 $3.09 $3.22 $3.35 $3.48 Large Commercial & Industrial Special $5.04 $5.11 $5.18 $5.25 $5.32 Firm Secondary $5.04 $5.11 $5.18 $5.25 $5.32 Firm Primary $5.04 $5.11 $5.18 $5.25 $5.32 Firm Trans. Transf. $5.04 $5.11 $5.18 $5.25 $5.32 Interruptible Secondary $5.04 $5.11 $5.18 $5.25 $5.32 Interruptible Primary $5.04 $5.11 $5.18 $5.25 $5.32 Interruptible TT $5.04 $5.11 $5.18 $5.25 $5.32 Standby Service None None None None None Public Street & Highway Lighting $6.74 $6.81 $6.88 $6.95 $7.02 Small Municipal Pumping Non -Demand $2.96 $3.09 $3.22 $3.35 $3.48 Demand Secondary $2.96 $3.09 $3.22 $3.35 $3.48 Demand Primary $2.96 $3.09 $3.22 $3.35 $3.48 Large Municipal Pumping Demand Primary (Sec cost) $2.96 $3.09 $3.22 $3.35 $3.48 Fire and Civil Defense Siren Service $2.96 $3.09 $3.22 $3.35 $3.48 Start Date 1 -Nov -2016 1 -Nov -2018 1 -Nov -2020 1 -Nov -2022 1 -Nov -2024 End Date 31 -Oct -2018 31 -Oct -2020 31 -Oct -2022 31 -Oct -2024 31 -Au -2026 Residential (May - October) $3.03 $3.15 $3.27 $3.40 $3.54 Small Commercial & Industrial Non -Demand $3.62 $3.76 $3.91 $4.07 $4.23 Firm Secondary $3.62 $3.76 $3.91 $4.07 $4.23 Firm Primary $3.62 $3.76 $3.91 $4.07 $4.23 Interruptible Secondary $3.62 $3.76 $3.91 $4.07 $4.23 Interruptible Primary $3.62 $3.76 $3.91 $4.07 $4.23 Large Commercial & Industrial Special $5.53 $5.75 $5.98 $6.22 $6.47 Firm Secondary $5.53 $5.75 $5.98 $6.22 $6.47 Firm Primary $5.53 $5.75 $5.98 $6.22 $6.47 Firm Trans. Transf. $5.53 $5.75 $5.98 $6.22 $6.47 Interruptible Secondary $5.53 $5.75 $5.98 $6.22 $6.47 Interruptible Primary $5.53 $5.75 $5.98 $6.22 $6.47 Interruptible TT $5.53 $5.75 $5.98 $6.22 $6.47 Standby Service None None None None None Public Street & Highway Lighting $7.30 $7.59 $7.90 $8.21 $8.54 Small Municipal Pumping Non -Demand $3.62 $3.76 $3.91 $4.07 $4.23 Demand Secondary $3.62 $3.76 $3.91 $4.07 $4.23 Demand Primary $3.62 $3.76 $3.91 $4.07 $4.23 Large Municipal Pumping Demand Primary (Sec cust) $3.62 $3.76 $3.91 $4.07 $4.23 Fire and Civil Defense Siren Service $3.62 $3.76 $3.91 $4.07 $4.23 Northern States Power Company, a Minnesota corporation Minneapolis, Minnesota 55401 Updated: 03/01/2011 MINNESOTA CITY SURCHARGES - ELECTRIC St. Paul: (continued) Page 6 of 7 Customer Class Energy Factor - Monthly Charge per kWh Start Date 1 -Nov -2006 1 -Nov -2008 1 -Nov -2010 1 -Nov -2012 1 -Nov -2014 End Date 31 -Oct -2008 31 -Oct -2010 31 -Oct -2012 31 -Oct -2014 31 -Oct -2016 Residential (May - October) $0.0094 $0.0095 $0.0096 $0.0097 $0.0098 Small Commercial & Industrial Non -Demand $0.0040 $0.0040 $0.0040 $0.0040 $0.0040 Firm Secondary $0.0018 $0.0018 $0.0018 $0.0018 $0.0018 Firm Primary $0.0018 $0.0018 $0.0018 $0.0018 $0.0018 Interruptible Secondary $0.0018 $0.0018 $0.0018 $0.0018 $0.0018 Interruptible Primary $0.0018 $0,0018 $0.0018 $0.0018 $0.0018 Large Commercial & Industrial Special $0.0028 $0.0028 $0.0028 $0.0028 $0.0028 Firm Secondary $0.0013 $0.0013 $0.0013 $0.0013 $0.0013 Firm Primary $0.0013 $0.0013 $0.0013 $0.0013 $0.0013 Firm Trans. Transf. $0.0013 $0.0013 $0.0013 $0.0013 $0.0013 Interruptible Secondary $0.0013 $0.0013 $0.0013 $0.0013 $0.0013 Interruptible Primary $0.0013 $0.0013 $0.0013 $0.0013 $0.0013 Interruptible TT $0.0013 $0.0013 $0.0013 $0.0013 $0.0013 Standby Service None None None None None Public Street & Highway Lighting $0.0040 $0.0040 $0.0040 $0.0040 $0.0040 Small Municipal Pumping Non -Demand $0.0040 $0.0040 $0.0040 $0.0040 $0.0040 Demand Secondary $0.0018 $0.0018 $0.0018 $0.0018 $0.0018 Demand Primary $0.0018 $0.0018 $0.0018 $0.0018 $0.0018 Large Municipal Pumping Demand Primary (Sec cult) $0.0018 $0.0018 $0.0018 $0.0018 $0.0018 Fire and Civil Defense Siren Service $0.0018 $0.0018 $0.0018 $0.0018 $0.0018 Start Date 1 -Nov -2016 1 -Nov -2018 1 -Nov -2020 1 -Nov -2022 1 -Nov -2024 End Date 31 -Oct -2018 31 -Oct -2020 31 -Oct -2022 31 -Oct -2024 31 -Au -2026 Residential (May - October) $0.0102 $0.0106 $0.0110 $0.0115 $0.0119 Small Commercial & Industrial Non -Demand $0.0042 $0.0043 $0.0045 $0.0047 $0.0049 Firm Secondary $0.0019 $0.0019 $0.0020 $0.0021 $0.0022 Firm Primary $0.0019 $0.0019 $0.0020 $0.0021 $0.0022 Interruptible Secondary $0.0019 $0.0019 $0.0020 $0.0021 $0.0022 Interruptible Primary $0.0019 $0.0019 $0.0020 $0.0021 $0.0022 Large Commercial & Industrial Special $0.0029 $0.0030 $0.0031 $0.0033 $0.0034 Firm Secondary $0.0014 $0.0014 $0.0015 $0.0015 $0.0016 Firm Primary $0.0014 $0.0014 $0.0015 $0.0015 $0.0016 Firm Trans. Transf. $0.0014 $0.0014 $0.0015 $0.0015 $0.0016 Interruptible Secondary $0.0014 $0.0014 $0.0015 $0.0015 $0.0016 Interruptible Primary $0.0014 $0.0014 $0.0015 $0.0015 $0.0016 Interruptible TT $0.0014 $0.0014 $0.0015 $0.0015 $0.0016 Standby Service None None None None None Public Street & Highway Lighting $0.0042 $0.0043 $0.0045 $0.0047 $0.0049 Small Municipal Pumping Non -Demand $0.0042 $0.0043 $0.0045 $0.0047 $0.0049 Demand Secondary $0.0019 $0.0019 $0.0020 $0.0021 $0.0022 Demand Primary $0.0019 $0.0019 $0.0020 $0.0021 $0.0022 Large Municipal Pumping Demand Primary (Sec cust) $0.0019 $0.0019 $0.0020 $0.0021 $0.0022 Fire and Civil Defense Siren Service $0.0019 $0.0019 $0.0020 $0.0021 $0.0022 Northern States Power Company, a Minnesota corporation Minneapolis Minnesota 55401 Updated: 03/01/2011 MINNESOTA CITY SURCHARGES - ELECTRIC St. Paul: (continued) Page 7 of 7 Customer Class Demand Factor - Monthly Charge per kW Start Date 1 -Nov -2006 1 -Nov -2008 1 -Nov -2010 1 -Nov -2012 1 -Nov -2014 End Date 31 -Oct -2008 31 -Oct -2010 31 -Oct -2012 31 -Oct -2014 31 -Oct -2016 Residential (May - October) None None None None None Small Commercial & Industrial Non -Demand None None None None None Firm Secondary $1.10 $1.10 $1.10 $1.10 $1.10 Firm Primary $1.06 $1.06 $1.06 $1.06 $1.06 Interruptible Secondary $1.10 $1.10 $1.10 $1.10 $1.10 Interruptible Primary $1.06 $1.06 $1.06 $1.06 $1.06 Large Commercial & Industrial Special None None None None None Firm Secondary $1.10 $1.10 $1.10 $1.10 $1.10 Firm Primary $1.06 $1.06 $1.06 $1.06 $1.06 Firm Trans. Transf. $1.06 $1.06 $1.06 $1.06 $1.06 Interruptible Secondary $0.81 $0.81 $0.81 $0.81 $0.81 Interruptible Primary $0.71 $0.71 $0.71 $0.71 $0.71 Interruptible TT $0.51 $0.54 $0.57 $0.60 $0.63 Standby Service $0.30 $0.33 $0.36 $0.39 $0.42 Public Street & Highway Lighting None None None None None Small Municipal Pumping Non -Demand None None None None None Demand Secondary $1.10 $1.10 $1.10 $1.10 $1.10 Demand Primary $1.06 $1.06 $1.06 $1.06 $1.06 Large Municipal Pumping Demand Primary (Sec cust) $1.06 $1.06 $1.06 $1.06 $1.06 Fire and Civil Defense Siren Service $1.06 $1.06 $1.06 $1.06 $1.06 Start Date 1 -Nov -2016 1 -Nov -2018 1 -Nov -2020 1 -Nov -2022 1 -Nov -2024 End Date 31 -Oct -2018 31 -Oct -2020 31 -Oct -2022 31 -Oct -2024 31 -Au -2026 Residential (May - October) None None None None None Small Commercial & Industrial Non -Demand None None None None None Firm Secondary $1.14 $1.19 $1.24 $1.29 $1.34 Firm Primary $1.10 $1.15 $1.19 $1.24 $1.29 Interruptible Secondary $1.14 $1.19 $1.24 $1.29 $1.34 Interruptible Primary $1.10 $1.15 $1.19 $1.24 $1.29 Large Commercial & Industrial Special None None None None None Firm Secondary $1.14 $1.19 $1.24 $1.29 $1.34 Firm Primary $1.10 $1.15 $1.19 $1.24 $1.29 Firm Trans. Transf. $1.10 $1.15 $1.19 $1.24 $1.29 Interruptible Secondary $0.84 $0.88 $0.91 $0.95 $0.99 Interruptible Primary $0.74 $0.77 $0.80 $0.83 $0.86 Interruptible TT $0.66 $0.68 $0.71 $0.74 $0.77 Standby Service $0.44 $0.45 $0.47 $0.49 $0.51 Public Street & Highway Lighting None None None None None Small Municipal Pumping Non -Demand None None None None None Demand Secondary $1.14 $1.19 $1.24 $1.29 $1.34 Demand Primary $1.10 $1.15 $1.19 $1.24 $1.29 Large Municipal Pumping Demand Primary (Sec cust) $1.10 $1.15 $1.19 $1.24 $1.29 Fire and Civil Defense Siren Service $1.10 $1.15 $1.19 $1.24 $1.29 'West St. Paul: (Not a franchise fee.) Represents a city fee on gross earnings derived from the sale of electricity within the city pursuant to city code (approved in 1966). The gross earnings sum excludes electric energy supplied to the city for municipal services. CENTERPOINT ENERGY Franchise Fee Report In L€eu of ER Fee City Fee Status Calc. Method Franchise Fee Schedule perm€t Fees Exemption 8/5/2011 Fee Start Annexafion Sunsei/Review Date Audit Dote Franchise Renewal Date Afton Approved Flat Rate Residential = $2.00 Yes No 01/01/2005 Yes None 01/14/2025 Comm A= $4.00 Comm B = $5.00 Comm C = $5.00 SVDF A = $5.00 SVDF B = $5.00 LVDF = $5.00 Alexandria Approved % of Revenue All Customers = 5% Yes No 04/01 /2004 Yes None 11/25/2013 Anoka Approved Flat Rate Residential = $2.75 Yes Na -01/05/2004 Sunset 08/20/2012 Comm A = $2.75 12/31/2011 Comm B = $8.00 Comm C = $35.00 SVDF A = $75.00 SVDF 8 = $300.00 LVDF = $900.00 Benson Approved Flat Rate Residential = $2.00 Yes No 01/01/2010 Yes Review every 2 01 /30/2012 Comm A= $3.33 Comm B = $4.00 01years /01/2012 Comm C = $10.00 SVDF A = $13.33 SVDF B = $20.00 LVDF = $50,00 Blue Earth Approved Flat Rate Residential = $2.00 Yes No 12/01 /2003 YesNone 04/11/2020 All Others = $3.00 Brooklyn Center Approved Flat Rate Residential = $1.52 Yes No 05/12/2009 Nane 09/15/2013 Comm A= $1.58 Comm B = $5.15 Comm C = $20.60 SVDF A = $51.50 SVDF B = $98.88 LVDF = $98.88 Champlin Approved Flat Rate Residential = $2.50 No No 01/01/2009 None 11/24/2028 Comm A = $2.50 Comm B = $8.00 Comm C = $35.00 SVDF A = $70.00 SVDF B = $125.00 LVDF = $125.00 Coon Rapids Approved %of Revenue Alt Customers = 4% No No 01101/i992 None )0/13/2025 Franchise Fee Report 8!-5/2011 Ci Fee Status Calc. Method Franchise Fee Schedule In Lieu of Permit Fees ER Fee Exemption Fee Start Annexation Sunset/Review Franchise Date Audit Date Renewal Date Cottage Grove Approved Flat Rate Residential= $1.65 Yes No 01/01/2010 Yes None 02/02/2024 Comm A = $4.95 Comm B & C= $8.25 SVDF A & B = $16.50 LVDF = $24.75 F&I ip $24.75 Deephaven Approved Flat Rate All Customers = $2.50 No No 02/04/2002 None 01/10/2017 Excelsior Granite Falls Approved Approved Flat Rate % of Revenue All Customers = $2.50 5% With a $1,500 Yes No No 10/15/2005 None 06/13/2012 maximum per month No 03/31 /2005 None 03/30/2025 Hopkins Approved -Rate Residential= $1.00 No No 02/06/2004 Sunset 11/25/2022 Comm A = $1,00 12/31/2011 Comm B = $3.00 Comm C = $9.00 SVDF A= $18.00 SVDF 8 - $63.00 LVDF = $63.00 Lake Crystal Little Falls Approved % of Revenue All Customers = 5% No No 08/01/2003 Yes None 06/02/2014 Approved Flat Rate Residential = $1.00 No No 01/01/2004 Yes None 03/12/2012 All Others = $5.00 long Prairie Approved Fiat Rate All Customers = $1.00 No No 01/01 /2007 Yes None 08/07/2016 MankatoI Approved Flat Rate Residential = $0.95 No No 10/01/2008 Yes None 04/11/2014 Comm A = $2.50 Comm B = $5.25 Comm C = $12.00 SVDF A = $15.00 SVDF B = $20.00 LVDF = $2S.00 Minneapolis Approved % of Revenue Residential = 4.507o Yes No 01/01/1992 None 01/01/2015 Comm A,B,C = 5% SVDF = 5% LVDF = 3% Morris Approved Flat Rate Residential = $2.00 Yes No 07/01 /2004 Yes None 07/07/2012 Comm A = $5.00 Comm 3 = $9.00 Comm C = $27.00 SVDF-A = $35,00 SVDF-B = $35.00 LVDF = $750.00 Franchise Fee Report City Fee Status Calc. Method Franchise Fee Schedule 8/5/2011 In Lieu of ER Fee Fee Start Annexation Sunset/Review Franchise Permit Fees Exemption Date Audit Dote Renewal Date Mound Approved Flat Rate All customers = $2.75 No No 01/01/2011 12/31/2012 09/10/2022 Mounds View Approved % of Revenue All customers = 3.87% No No 01/01/2011 Sunsets 07/01/2019 All customers = 3.79% 01/01/2010 12/31/2011 Sunsets New Hope Approved Flat Rate Residential = $1.50 Yes No 01/01/2004 Review 05/14/2023 Comm A= $3.00 01/01/2012 Comm B = $6.00 Review Comm C = $20.00 SVDF A = $30.00 SVDF B = $40.00 LVDF = $60.00 North Mankato Approved Flat Rate Residential $1.00 No Yes 06/01/2008 Yes 04/20/2029 Comm A 8.00 Comm B 10.00 Comm C 15.00 SVDF A 20.00 SVDF B 30.00 LVDF 75.00 Oakdale Approved Flat Rate Residential = Yes Yes <4 hours 12/01/2010 None 11/09/2030 $ 1.50 01/20/2004 COMMA&B= $ 5.00 Comm C = $ 8.00 SVDF A & B = $17.00 LVDF = $17.00 Firm Transportation= $17.00 Interrruptible Transportation= $17.00 Owatonna Approved % of Revenue Residential = 1.757* Yes No 01/01/2003 Yes None 12/31/2022 Comm A & B = 1.75% Comm C = 1.00% SVDF A & B = 1.00% LVDF = 1.00% Franchise Fee Report In Lieu of. ER Fee City Fee Status Calc, Method Franchise Fee Schedule Permit Fees Exemption 8/5/2011 Fee Start Annexation Sunset/Review Franchise Date Audit Dote Renewal Date Prior Lake Approved Flat Rate Residential $1.50 Yes No 07/01/2006 Yes None 03/20/2026 Comm -A $1.50 Comm -B $5.00 Comm -C $5.00 SVDF-A $10.00 SVDF- B $10.00 LVDF $50.00 Richfield Approved Flat Rate Residential = $1.65 - Yes No 02/03/2004 Review 07/30/2023 $1.88 - $2.05 06130/2011 Comm A = $1.65 - $1.88 FF increase -$2,05 Comm B = $5.10 - $5.81 -$6.33 Comm C = $11.33- $12.92-$14.08 SVDF A = $11.33 - $12.92-$14.08 SVDF B= $11.33- $12.92-$14.08 LVDF = $11.33- 11.33- $12.92 - $14.08 $12.92-$14.08 Robbinsdate Approved % of Revenue All customers = 4% No - but not No 06/01/2003 Sunset 08/08/2022 required to 07/0112013 pay (some Sauk Centre Approved % of Revenue All Customers = 1.5% No No 02/22/2010 Yes Review every 2 09/10/2028 years Sleepy Eye Approved % of Revenue A11 customers = 2% Yes No 01/01/1998 Yes None 01/01/2018 St. Augusta Approved Hot Rote Residential $3.00 Yes No 01/03/2010 Yes Review every 2 10/21/2023 Firm A $5.00 years Firm B $5.00 Firm C $5.00 SVDF A & B $3.00 LVDF $5.00 St. Louis Park Approved Flat Rate Residential = $2.00 No No 02/11/2011 None 05/14/2013 Comm A = $2.00 01/04/2004 Comm B = $4.00 Comm C = $13.25 SVDF A&B = $13.25 LVDF = $73.00 Franchise Fee Report City Fee Status Calc, Method Franchise Fee Schedule 8/5/2011 In Lieu of ER Fee Fee Start Annexation Sunset/Review Franchise Permit Fees Exemption Date Audit Dote Renewal Date Waseca Approved Flat Rate Residential $1.40 Yes Yes 09/01/2010 Yes Review every 2 07/06/2030 Com A $1.80 years COMB $5.00 Corn C $16.00 SVDF A $100,00 SVDF 8 $150,00 LVDF $300.00