ag - xcel energy: responsible by nature · 530 nuc mtc of react pit equip na 531 nuc maint of elect...

7
NSP-MN Schedule 4A OM by FERC Account 2018 Budget vs 2017 Budget Total Company By Utility By Business Area $000s Utility Desc Business Area FERC 2016 Budget 2017 Budget Variance Vanance Electric Benefits Loadings 426.4 Expenditures for Civic 110 109 -0 9% 426.5 Other Deductions NA 500 Stm Prod Op Supr 134 137 2.0% 501 Stm Sen Fuel NA 502 Steam Expenses Major 49 51 8% 505 Stm Gen Elec Exp Major NA 506 Misc Steam Pwr Exp 540 556 15 28% 510 Stm Maint SuperEng 22 23 2.3% 511 Stm Maint of Structures NA 5l2StmMaintotBoiierPlt 25 25 24% 513 Stm Maint of Elec Plant 27 27 1% 514 Stm Maint of Misc Stm PIt 336 345 5% 517 Nuc Oper Super Eng 15614 15541 73 -05% 519 NuclearcoolantsWtr NA 520 Nuclear Steam Expense NA 523 Nuclear Electric Expense NA 524 Nuclear Power Misc Exp 729 791 62 8.6% 528 Nuc Maint Super Eng NA 530 Nuc Mtc of React Pit Equip NA 531 Nuc Maint of Elect Plant NA 532 Nuc Mtc of Misc Nuc Plant NA 535 Hyd OperSuper Eng 2.1% 537 Hydro Oper Hydraulic Exp 3.1% 539 Hydro Oper Misc Sen Exp 1.2% 541 Hydro Mtc Super Eng 3.2% 544 Hyd Maint of Elec Plant 3.2% 545 Hyd Mt Misc Hyd Pint Mjr 2% 546 0th Oper SuperEng 35 35 -03% 548OthOperGenExp 116% 549 0th Oper Misc Sen Exp 31 32 20% 551 0th Mant Super Eng 32% 552 0th Maint of Structures NA 553 0th Mtc of Sen Ele Plant 27 28 3.2% 554 0th Mtc Misc Gen Pit Mjr 2% 556 Load Dispatch 100 102 1.3% 557 Other Power 0th Exp 298 306 2.7% 560 Trans Oper Super Eng 565 582 18 3.1% 561.1 Load Disp-Reiiablity 26% 561.2 Load Disp-Monitor/Operale 288 296 2.9% 561.3 Load Disp-Trans Serv/Sch 2.8% 581.5 Rel/Plan/Standards Dcv 87 89 3.0% 561 Trans Service Studies 3.0% 561.7 Sen lnterconn Studies 10 3.0% 562 Trans Oper Station Exp NA 563 Trans Oper OH Lines 61 63 30% 566lransoperMiscExp 148 152 3.0% 568 Trans Mtce Super Eng NA 570 Tran Mnl of Station Equip NA 571 Trans Mt of Overhead Line NA 5751 Operation Supervision 18 19 3.0% 575.2 DA RT Mkt Admin 40 40 0.8% 575.3 Trans Rights Mkt Admin NA 575.SAnciilaryServMklAdmin 19 19 0.2% 575 Mkt Monitoring/Compliance -1.4% 580 Dist Oper Sup Eng 209 215 30% 581 Dist Load Dispatching 74 76 3.0% 582 Dist Op Station Exp NA 583 Dist Oper Overhead Lines 11 11 3.0% 584 Dist Op US Eiec lines 13 14 30% 585 Dist Oper Slreetlighl NA 588 Dist Oper Meter Exp 46 47 9% 587 Dist Oper Gust Install NA 588 Dist Oper Misc Exp 50 50 0.5% 590 Dist Mtc Super Eng 15 15 1.0% 592 Dist Ml of Station Equip NA 593 Dist MIc of Overhead Lines 28 29 3.0% 595 Dist Mt of Line Transform NA 596 Dist Mtc of Streetlights NA 901 Gust Acct Super se 30% 902 Gust Acct Meter Read 14 14 0% 903 Gust AccI Recrds Coli 1203 244 41 34% 908 Customer Asst Expense 59 60 2.9% Page of 13 November 2015

Upload: doanhanh

Post on 27-Jul-2018

214 views

Category:

Documents


0 download

TRANSCRIPT

NSP-MN

Schedule 4A OM by FERC Account

2018 Budget vs 2017 Budget

Total Company By Utility By Business Area

$000s

UtilityDesc Business Area FERC 2016 Budget 2017 Budget Variance Vanance

Electric Benefits Loadings 426.4 Expenditures for Civic 110 109 -0 9%

426.5 Other Deductions NA

500 Stm Prod Op Supr 134 137 2.0%

501 Stm Sen Fuel NA

502 Steam Expenses Major 49 51 8%

505 Stm Gen Elec Exp Major NA

506 Misc Steam Pwr Exp 540 556 15 28%510 Stm Maint SuperEng 22 23 2.3%

511 Stm Maint of Structures NA

5l2StmMaintotBoiierPlt 25 25 24%

513 Stm Maint of Elec Plant 27 27 1%

514 Stm Maint of Misc Stm PIt 336 345 5%

517 Nuc Oper Super Eng 15614 15541 73 -05%

519 NuclearcoolantsWtr NA

520 Nuclear Steam Expense NA

523 Nuclear Electric Expense NA

524 Nuclear Power Misc Exp 729 791 62 8.6%

528 Nuc Maint Super Eng NA

530 Nuc Mtc of React Pit Equip NA

531 Nuc Maint of Elect Plant NA

532 Nuc Mtc of Misc Nuc Plant NA

535 Hyd OperSuper Eng 2.1%

537 Hydro Oper Hydraulic Exp 3.1%

539 Hydro Oper Misc Sen Exp 1.2%

541 Hydro Mtc Super Eng 3.2%

544 Hyd Maint of Elec Plant 3.2%

545 Hyd Mt Misc Hyd Pint Mjr2%

546 0th Oper SuperEng 35 35 -03%

548OthOperGenExp 116%549 0th Oper Misc Sen Exp 31 32 20%

551 0th Mant Super Eng 32%

552 0th Maint of Structures NA

553 0th Mtc of Sen Ele Plant 27 28 3.2%

554 0th Mtc Misc Gen Pit Mjr 2%556 Load Dispatch 100 102 1.3%

557 Other Power 0th Exp 298 306 2.7%

560 Trans Oper Super Eng 565 582 18 3.1%

561.1 Load Disp-Reiiablity26%

561.2 Load Disp-Monitor/Operale 288 296 2.9%

561.3 Load Disp-Trans Serv/Sch 2.8%

581.5 Rel/Plan/Standards Dcv 87 89 3.0%

561 Trans Service Studies 3.0%

561.7 Sen lnterconn Studies 10 3.0%

562 Trans Oper Station Exp NA

563 Trans Oper OH Lines 61 63 30%

566lransoperMiscExp 148 152 3.0%

568 Trans Mtce Super Eng NA

570 Tran Mnl of Station Equip NA

571 Trans Mt of Overhead Line NA

5751 Operation Supervision 18 19 3.0%

575.2 DA RT Mkt Admin 40 40 0.8%

575.3 Trans Rights Mkt Admin NA

575.SAnciilaryServMklAdmin 19 19 0.2%

575 Mkt Monitoring/Compliance -1.4%

580 Dist Oper Sup Eng 209 215 30%581 Dist Load Dispatching 74 76 3.0%

582 Dist Op Station Exp NA

583 Dist Oper Overhead Lines 11 11 3.0%

584 Dist Op US Eiec lines 13 14 30%585 Dist Oper Slreetlighl

NA

588 Dist Oper Meter Exp 46 47 9%

587 Dist Oper Gust Install NA

588 Dist Oper Misc Exp 50 50 0.5%

590 Dist Mtc Super Eng 15 15 1.0%

592 Dist Ml of Station Equip NA

593 Dist MIc of Overhead Lines 28 29 3.0%

595 Dist Mt of Line Transform NA

596 Dist Mtc of StreetlightsNA

901 Gust Acct Super se 30%902 Gust Acct Meter Read 14 14 0%

903 Gust AccI Recrds Coli 1203 244 41 34%

908 Customer Asst Expense 59 60 2.9%

Page of 13 November 2015

NSP.MNSchedule 4A 0M by FERC Account

2018 Budget vs 2017 BudgetTotal Company By Utility By Business Area

$000s

UtilityDesc Business Area FERC 2016 Budet 2017 Budget Variance Variance

Electric Benefits Loadings 912 Sales Demo Sales 30%

920 AG Salaries 18305 19379 1073 59%

921 AGOfficeSupphes 415 419 1.0%

923 AG Outside Services NA

925 AG Injuries Damages 3494 3618 124 3.5%

926 AG Pen Ben 84277 84601 324 0.4%

930.2 AG sc General Exp NA

Benefits Loadings Total 127561 129208 1647 1.3%

Chief Executive Officer 426.1 Donations 395 395 0%

426.4 Expenditures for Civic 211 216 21%

426 Other Deductions 4.3%

920 AG Salaries 477 491 14 3.0%

921 AG Office Suppl as 12 12 20%923 AG Outside Serv ces 48 49 0%

930 2AG Misc General Exp 863 880 17 1.9%

Chief Executive Officer Total 2008 2044 37 1.8%

Corp Secretary Exec Srvcs 426 Donations 30 30 0.0%

426.4 Expenditures for Civic NA

426.5 Other Deductions 0.0%

524 Nuclear Power Misc Exp NA

566 Trans Oper Misc Exp NA

588 Dist Oper sc Exp NA

593 Dist Mtc of Overhead LInes NA

903 Gust Acct Recrds Coll NA

908 CustomerAsst Expense 106 108 2.1%

909 Cust Serv Instruct Adver 569 569 0.0%

920 AG Salares 3049 3140 91 3.0%

921 AG Office Supplies 742 744 0.2%

923AG Outside Services 657 619 38 -5.8%

930 AG General Advertising 3027 110 83 27%

9302 AG Misc General Exp 1654 627 27 -1 7%931 AG Rents NA

935 AG Maint of Gen PLT 0.0%

Corp Secretary Exec Srvcs Total 9839 9951 112 1.1%

Corporate Other 417.1 Exp from Non-Utilty NA

426.1 Donations NA

426.3 Penalties NA

566 Trans Oper sc Exp 111588 113012 1423 3%

583 Dist Oper Overhead Lines NA

584 Dist Op hG Elec lines NA

586 Dist Oper Meter Exp NA

920 AG Salares NA

921 AG Office Supplies 663 663 00%

922 AG Admn Transfer Crdt 2420 1322 098 -45.4%

929 AG Duplicate Chrg Crdt 4986 4986 0%9302 AG Misc General Exp NA

931 AG Rents NA

Corporate Other Total 104846 107367 2521 2.4%

Distribution Operations 426 Donations NA

4263 Penaltes NA

4264 Expenditures for Civic NA

426 Other Deductions NA

514 Stm Mant of Misc Stm PIt NA

531 Nuc Maintof Elect Plant NA

560 Trans Oper Super Eng -12 5%

562 Trans Oper Station Exp 443 449 4%

566 Trans Oper so Exp 453 254 199 -43.9%

570 Iran Mnt of Station Equip 597 610 13 2.2%

571 Trans Mt of Overhead Line 5694 4829 865 -15.2%

572 Trans Maint of UG lines NA

580 Dist Oper Sup Eng 7728 7580 148 -1 9%

581 Dst Load Dispatching 5903 6019 116 20%

582 St Op Station Exp 1184 209 25 1%

583 Dist Oper Overhead Lines 1529 1661 132 6%

584 Dist Op UG Elec lines 884 828 56 -6.3%

585 Dist Oper Streetlight 1825 1822 -0 2%

586 Gist Oper Meter Exp 2876 2878 203 6%

587 Dist Oper Gust Install 4103 4179 76 1.8%

588 Dish Oper Misc Exp 15965 16321 356 2.2%

589 Dist Rents 493 493 0.0%

590 Dist Mtc Super Eng 177 182 5%

591 Dish Mt of Structures Mjr NA

Page of 13 November 2015

NSP-MNSchedule 4A OM by FERC Account

2016 Budget vs 2017 Budget

Total Company By Utility By Business Area

$000s

Utility Oesc Business Area FRC 2048 Bud9et 2017 BudBet Variance Variance

Electric Distribution Operations 592 Dist Mt of Station Equip 575 583 13%593 st Mtc of Overhead LInes 39021 41188 147 55%594 St Mt of Undergrnd Line 12936 12823 313 -2.4%

595 St Mt of Line Transform 1307 1327 20 16%596 st Mtc of Streethghts 905 908 01%597 Dist Mtc of Meters 154 155 6%

598 Dist Maint of Dist Plant 0%

902 Cust Acct Meter Read NA904 Cust Acct Uncollect 200 200 0%906 Customer Asst Expense NA

920 AG Salaries 536 552 18 30%921 AG Office Supplies 88 88 -0.9%

923 AG Outside Services 93 93 0.0%

925 AGInjuries Damages 93 93 0%

930.1 AG General Advertisng NA

930 AG Misc General Exp 203 203 0.0%

931AGRents NA

935 AG Ma nt of Gen PLT NADistribution Operations Total 103997 105647 1650 16%

Energy Supply 426 Donat ons 34 34 0%

426.4 Expenditures for Civic 12 12 0.0%

426.5 Other Deductions 5%500 Stm Prod Op Supr 7272 7441 169 3%501 Stm Gen Fuel 42 42 0.3%

502 Steam Expenses Major 22666 21983 663 -3.0%

505 Stm Gen Elec Exp Major 1403 1424 21 1.5%

506 Misc Steam Pwr Exp 17593 17717 124 0.7%

507 Stm Pow Gen Rents NA

510 Stm Ma nt SuoerEng 1986 2038 52 6%511 Stm Ma nt of Structures 2784 3003 219 7.9%

512 Stm Ma nt of Boler Pt 39679 37234 2448 -6.2%

Sl3StmMantofElecPlant 4905 5557 851 13.3%

514 Stm Ma nt of Misc Stm PIt 17985 18 742 757 42%517 Nuc Oper Super Eng 26%520 Nuclear Steam Expense NA524 Nuclear PowerMisc Exp 176 179 1.5%

530 Nuc Mtc of React Pit Equip NA531 Nuc Maint of Elect ant NA

532 Nuc Mtc of Misc Nuc Plant NA

535 Hyd Oper Super Eng 36 36 -0.3%

536 Hyd Oper Water for Pwr NA537 Hydro Oper Hydraulic Exp 3.0%

538 Hyd Oper Electric Exp 12 12 0%

539 Hydro Oper sc Son Exp 273 277 6%541 HydroMtcSuperEng 3.1%

542 Hyd Maint of Structures 22 22 0.0%

543 Hydro Mtc Resv Dams 22 22 0.0%

544 Hyd Maint of Elec Plant 87 90 3.2%

545 Hyd Mt Sc Hyd Pint Mjr 59 61 6%548 0th Oper SuperEng 2120 2041 79 -3.7%

547 0th Oper Fuel NA

548 0th Oper Gen Exp 7699 7641 58 -0.8%

549 0th Oper Misc Sen Exp 15 391 22 618 7227 47.0%

550 0th Oper Rents NA

551 0th Maint Super Eng 308 320 12 4.0%

552 0th Maint of Structures 242 2478 764 -23.6%

553 0th Mtc of Gen Ele Plant 17199 20617 3418 19.9%

554 0th Mtc Misc Sen Pit Mjr 1859 1838 21 -1.1%

580 Trans Oper Super Eng 192 190 -1.1%

568 Trans Oper Msc Exp NA570 Tran Mnt of Station Equip NA

571 Trans Mt of Overhead Line NA

572 Trans Maint of US lines NA584 Dist Op US Elec lines NA

588 Dist Oper Meter Exp NA

588 DiSt Oper Misc Exp NA590 Dist Mtc Super Eng 286 291 1.6%

592 Dist Mt of Station Equip NA

593 Dist Mtc of Overhead Llne NA

594 Dist Mt of Undergrnd Line NA595 Dist Mt of Line Transform NA920 AS Salaries 2003 2019 16 08%

Page3ofl3 November2 2015

NSP-MN

Schedule 4A OM by FERC Account

2016 Budget vs 2017 Budget

Total Company By Utility By Business Area

$000s

UtilityDeco Business Area FERC 2016 Budget 2017 Budget Variance Variance

Electric Energy Supply 921 AG Office Suoohes 387 391 0.8%

922 AG Admn Transfer Crdt 675 4058 1383 51.7%

923 AG Outside Services 325 298 27 -8.2%

925 AG Injuries Damages NA

930.1 AG General Advertising NA

930.2 AG Misc General Exp 321 321 0.0%

931 AG Rents NA

935 AG Maint of Gen PLT 0%

Energy Supply Total 165720 172944 7224 4.4%

Financial Operations 426.1 Donations 0%

426.4 Expenditures for Civic 0.2%

426.5 Other Deductions 14 10 -24.7%

500 Stm Prod Op Supr 78 80 3.0%

5o6MiscSteamPwrExp 140 144 3.1%

524 Nuclear Power Misc Exp NA

535 Hyd Oper Super Eng 3.0%

546 0th Oper SuperEng 18 18 3.0%

549 0th Oper Misc Gen Exp 72 74 3.0%

557 Other Power 0th Exp 362 372 2.6%

560 Trans Opel Super Eng NA

566 Trans Oper Misc Exp 300 307 2.3%

573 Trans Mtc of Mac Pit Mjr NA

580 Dist Oper Sup Eng NA

588 Dist Oper sc Exp 29 30 9%

909 Cust Serv Instruct Adver NA

920AG Salaries 12924 13241 317 25%921 AG Office Supplies 734 1.747 13 0.7%

922 AG Admn Transfer Crdt 2.1%

923 AG Outside Services 3971 3834 138 -35%

924 AG Property Insurance 10 227 0765 538 3%

925 AG Injuries Damages 11533 12954 421 12.3%

928 AG Regulatory Comm Exp 5602 5781 179 32%930.2 AG Misc General Exp 20 20 00%931 AG Rents NA

935 AG Ma nt of Sen PLT 10 -70%

Financial Operations Total 47035 49388 2353 5.0%

Gas Systems 426.1 Donations 0%426.3 Pena ties NA

426.4 Expenditures for Civic NA

426 Other Deductions NA

506 Misc Steam Pwr Exp NA

512 Stm Maint of Boiler Pit NA

514 Stm Maint of Misc Stm PIt NA

550 0th Oper Rents NA

560 Trans Oper Super Eng NA

586 Trans Oper Misc Exp NA

580 Dist Oper Sup Eng 201 205 1.7%

582 Dist Op Station Exp NA

584 DistOp US Eiec lines 7866 7958 90 1.1%

588 Dist Oper Misc Exp NA

593 Dist Mtc of Overhead Lines NA

598 Dist Maint of Dist Plant NA

908 Customer Asst Expense NA

909 Cust Sent Instruct Adver NA

920 AG Salaries 29 30 0%

921 A5 Off ce Supplies 13 13 0.0%

923 AG Outside Services NA

9302 AG Misc General Exp 0.0%

935 AG Maint of Sen PLT NA

Gas Systems Total 8119 8213 94 1.2%

General Counsel 426.1 Donations 55 55 0.0%

426.4 Expenditures for Civic 721 711 10 -1 3%

428.5 Other Deductions 0.0%

506 Misc Steam Pwr Exp 80 160 80 1000%

517 Nuc OperSuperEng NA

524 Nuclear Power Misc Exp 838 814 22 -26%

539 Hydro Oper Misc Gen Exp -100 0%

549 0th Oper Misc Sen Exp 413 592 179 432%557 Other Power 0th Exp -100 0%

560 Trans Oper Super Eng NA

581.2 Load Disp-Monitorfoperate NA

5617 Sen Interconn Studies NA

Page of 13 November 2015

NSP-MN

Schedule 4A OM by FERC Account2016 Budget vs 2017 Budget

Total Company By Utility By Busmess Area$000s

Utility Dose Business Area FERC 2018 Budget 2017 Budget Variance VarianceElectric General Counsel 586 Trans Oper Misc Exp 37 27 10 -27.0%

571 irans Mt of Overhead Line NA588 Dist Oper Misc Exp NA908 Customer Asst Expense NA920 AS Salaries 5878 6149 271 46%921 AG Office Supphes 699 712 12 8%922 AG Admn Transfer Crdt NA923AG Outside Services 4134 3482 672 -163%925 AG

Injuries Damages 17 17 0%928 AG Regulatory Comm Exp 440 277 163 -370%930.1 AG General

Advertising 00%9302 AG Misc General Exp 86 89 3%931 AG Rents NA935 AG Maint of Gen PLT 0%

General Counsel Total13413 13072 342

Nuclear Amortz Otner 517 Nuc Oper Super Eng 2113 4085 6198 -293.3%519 Nuclear coolants Wtr 228 151 380 -1662%520 Nuclear Steam Expense 2991 358 4349 -1454%523 Nuclear Electnc Expense 85 87 -101 9%524 Nuclear Power Misc Exp 919 905 1824 -198.5%528 Nuc Maint Super Eng 1143 2375 3519 -307.7%529 Nuc Maint of Structures

-94 8%530 Nuc Mtc of React Pit Equip 4228 4892 9120 -2157%531 Nuc Maint of Elect Plant 4581 551 5132 -112 0%532 Nuc Mtc of Misc Nuc Plant 7936 4112 12048 -151 8%

Nuclear Amortz Other Total 24235 18430 42665 -1760%Nuclear Generation Bus Area 426.1 Donations 12 12 00%

426.3 Penaltes NA428.4 Expenditures for Civic 332 332 0%426 Other Deductions 5%502 Steam Expenses Major NA506 Misc Steam Pwr Exp NA512 Stm Maint of Boi er PIt NA513 Stm Mainl of Elec Plant NA517 Nuc Oper Super Eng 57833 66508 8675 15.0%519 Nuclear coolants Wtr 8710 9181 471 54%520 Nuclear Steam Expense 48131 52248 4118 8.8%523 Nuclear Electric Expense 2149 2205 55 2.6%524 Nuclear Power Misc Exp 133327 135351 2024 5%525 Nuclear Sen Rents 75 75 00%528 Nuc Maint Super Eng 5040 9282 242 84.2%529 Nuc Maint of Structures NA530 Nuc Mtc of React Pit Equip 44706 58168 13460 30.1%531 Nuc Maint of Elect Plant 942 10471 1529 17 1%532 Nuc Mtc of Misc Nuc Plant 17527 29 130 11603 66.2%540 -lyd Oper Rents NA550 0th Opel Rents NA570 Tran Mnt of Station Equip NA588 Dist Oper Misc Exp NA920 AG Salaries 18 19 3.0%921 AG Office Supplies NA922 AS Admn Transfer Crdt NA923 AS Outside Services NA925 AG Injuries Damages NA928 AS Regulatory Comm Exp NA930 AS General Advertising NA930.2 AG Misc General Exp 0%935 AG Maint of Gen PLT NA

Nuclear Generation Bus Area Total 326812 372987 46176 141%Operations Services 426 Donations

0.0%426.4 Expenditures for Civic 34 34 5%428.5 Other Deductions 65 48 17 256%500 Stm Prod Op Supr NA501 Stm Sen Fuel NA508 Misc Steam Pwr Exp 854 654 -0 1%512 Stm Maint of Boiler PIt NA514 Stm Maint of Misc Stm Pt NA517 Nuc Oper Super Eng NA539 Hyd Oper Msc Sen Exp 00%549 0th Oper Misc Sen Exp 83 85 0%556 Load Dispatch 854 863 11%557 Other Power 0th Exp 2388 2421 33 1.4%

Page of 13 November 2015

NSP-MN

Schedule 4A OM by FERC Account

2016 Budget vs 2017 Budget

Total Company By Utility By Business Area$000s

Utdlty Dccc Business Area FERC 2046 Budget 2017 Budget Variance VadaceElectric Operations ServIces 560 Trans Oper Super Eng NA

561 LoadDsp-Reliability NA

561 Load Dsp-Monitor/Operate NA5615 ReIIPlanI Standards Dcv 19 20 3.0%

561.8 Rel/Plan/Standards Dev Serv NA566 Trans Oper Misc Exp 423 430 8%571 Trans Mt of Overhead Line NA575.1 Operation Supervison 190 195 2.8%

575.2 DA RT Mkt Admin 347 349 0.8%

575.3 Trans Rights Mkt Admin NA575 Ancillary Serv Mkt Admin 162 163 2%575.6 Mkt Monitonng/Compuance 35 35 -1 3%580 Dist Oper Sup Eng NA581 Dist Load Dispatchng NA588 Dist Oper MIsC Exp NA593 Dist Mtc of Overhead LInes NA901 Cust Acct Supervise 128 46 82 -64.0%

9o2CustAcctMeterRead 18281 18693 412 2.3%

903 CustAcct Recrds CoU 19.545 19623 78 0.4%

904 CustAcct Unco lect 13299 13507 208 1.6%

905 CuSt Acct Misc NA908 CustomerAsst Expense 312 318 2.0%

909 Cust Serv Instruct Adver NA912 Sales Demo Sales 0%920 AG Salaries 1311 1348 37 28%921 AG Office Supplies 766 782 -05%922 AG Admn Transfer Crdt 30 30 -02%923 AG Outside Services 3973 2818 1156 -29.1%

924 AG Property Insurance NA930.1 AG General Advertising 21 21 0.0%

930 AG Misc General Exp 0%931 AG Rents 0.0%

935 AS Maint of Sen PLT 134 141 54%Operations Services Total 63008 62559 449 -OJ%

Transmission 428 Donations NA4263 Penalties NA426.4 Expenditures for Civic NA426 Other Deductions 0%500 Stm Prod Op Supr NA501 Stm Sen Fuel NA506 Misc Steam Pwr Exp 17 18 0%512 Stm Maint of Boiler PIt NA513 Stm Maint of Elec Plant NA514 Stm Maint of Misc Stm PIt NA517 Nuc Oper Super Eng NA520 Nuclear Steam Expense NA531 Nuc Maint of Elect Plant NA549 0th Oper Misc Sen Exp NA553 0th Mtc of Sen Ele Plant NA554 0th Mtc Misc Sen PIt Mjr NA556 Load Dispatch NA580 Trans Oper Super Eng 7574 7757 184 2.4%

561 Load Dsp-Reliability 43 44 26%561 Load Disp-Monitor/Operate 384 2438 53 2%561 Load Dsp-Trans Serv/Sch 23 24 2.7%

561 Rel/Plan/Standards Dcv 821 844 22 7%561.8 Trans Service Studies 34 35 30%b81.7 Sen Interconn Studies 233 238 11%561.8 ReltPlan/Standards Dee Serv 2159 2379 220 102%582 Trans Oper Staton Exp 936 951 16 17%563 Trans Oper OH Lines 2406 2428 22 0.9%

564 US Line Exp 29%566 Trans Oper Misc Exp 3269 333 84 2.0%

567 Trans Rents 683 883 0.0%

568 Trans Mtce Super Eng 122 124 0.9%

570 Tran Mnt of Station Equip 7117 7125 01%571 Trans Mt of Overhead Line 787 691 98 -3.5%

572 Trans Maint of US lines 219 224 2.1%

573 Trans Mtc of Misc Pit Mjr 22 24 8.7%

580 Dist Oper Sup Eng 1032 048 16 5%581 Dist Load Dispatching NA582 Dist Op Station Exp 1756 794 38 2.2%

Page of 13 November 22015

NSP-MN

Schedule 4A OM by FERC Account2016 Budget vs 2017 Budget

Total Company By Utility By Business Area$000s

Ut1fl Deco Business Area FERC 2016 Budget 2017 Budei Variance VarlaisceElectric Transmission 583 Dist Oper Overhead Lines 175 179 24%

584 Dist Op US Elec lines 22%588 Dist Oper Meter Exp 07%587 Dist Opor Oust Install 00%588 Dist Oper Misc Exp 312 318 12%590 Dist Mtc Super Eng 39 38 -4.6%

591 Dist Mt of Structures Mjr NA592 Dist Mt of Station Equip 7468 7379 89 -1 2%593 Dist Mtc of Overhead Lines 19 19 10%594 Dist Mt of Undergrnd Line -14%595 Dist Mt of Line Transform 1289 1294 04%598 Dist Mtc of Streetl ghts 0%598 Dist Maint of Dist Plant NA903 CuSt Acct Recrds Coll NA904 Cust Acct Uncollect NA909 Oust Serv Instruct Adver NA920 AG Salaries 30 31 30%921 AG Office Supplies 0%922 AG Admn Transfer Crdt 14 14 0%923 AG Outside Services 00%925 AG Injuries Damages NA926 MS Pen Ben NA928 AG Regulatory Comm Exp 97 97 00%930.1 AG General Advertising NA930.2AG Misc General Exp 144 102 42 -290%931 AG Rents NA935 AG Maint of Sen PLT NA

Transmission Total 43126 43571 445 10%Utilities Corp Services 417 Exp from Non-titity NA

426 Donations 4307 4307 00%426 Penalties NA4264 Expenditures for Ctvc 1135 1141 06%426 Other Deductions 289 268 23 -7 9%500 Stm Prod Op Supr 4.8%

506 Misc Steam Pwr Exp 2315 2377 63 2.7%

507 Stm Pow Gen Rents 3437 408 28 -0.8%

510 Stm Maint SuperEng 3.0%

512 Stm Maint of Boiler PIt NA513 Stm Maint of Elec Plant NA514 Stm Maint of Misc Stm PIt 0%517 NucOperSuperEng 10 10 01%520 Nuclear Steam Expense 55%523 Nuclear Electric Expense NA524 Nuclear Power Misc Exp 9821 10075 254 2.6%

525 Nuclear Gen Rents 12688 12 565 122 0%530 Nuc Mtc of React PIt Equip NA532 Nuc Mtc of Misc Nuc Plant NA537 Nydro Oper Hydraul Exp NA539 Hydro Oper Misc Sen Exp 3.1%

540 Hyd Oper Rents 22 22 -0.8%

546 0th OperSuperEng 56%547 0th Oper Fuel NA548 0th Oper Sen Exp NA549 0th Oper Misc Sen Exp 305 314 2.8%

550 0th Oper Rents 1451 1442 -06%554 0th Mtc sc Sen Pit Mjr 36%556 Load Dispatch 146 149 20%557 other Power 0th Exp 941 968 27 8%560 Trans Oper Super Eng 322 331 27%561.2 Load Disp-Monitor/Operate 4323 4415 92 1%561 Rel/Plan/Standards Dev NA562 Trans Oper Station Exp 490 503 12 2.5%

563 Trans Oper OH Lines NA565 Trans of Elec By Others NA566 Trans Oper Misc Exp 913 931 19 2.0%

567 Trans Rents 1694 1696 0.1%

570 Tran Mnt of Station Equip 2.6%

571 Trans Mt of Overhead Line 64 65 22%573 Trans Mtc of Misc Pit Mjr NA575.8 Regional Market Rents 18 17 -1.0%

580 Dist Oper Sup Eng 925 947 21 23%581 Dist Lace Dspatching 1668 1703 34 20%

Page7ofl3 November2 2015