206456

• Browser built in viewer
• PDF Viewer
• Universal Document Viewer
• Google Docs View
• Google Drive View
• Download Document [pdf]
Not Your Device? Search For Manuals / Datasheets:



File Info : application/pdf, 50 Pages, 939.88KB

Document Document

Southwestern Public Service Company Original Cost of Plant in Service by Primary Account

(a) Base Period, (b) Test Year Period

Balance at

Balance at

FERC

Beginning of

End of

Line

Account

Base Period

Base Period

Total Company Test NM Retail

No.

Description

No.

10/1/2019

Additions

Retirements Transfers/ Others

9/30/2020

Adjustments (1)

Year Period

Test Year Period

1 Electric Plant in Service * Removal of the Asset Retirement Cost
2 Associated with Asset Retirement Obligation 3 Electric Plant Purchased or Sold 4 Completed Const. Not Classified 5 Plant Held For Future Use (3) 6 Construction Work in Progress 7 Electric Plant Acquisition Adjustment 8 Total Electric Plant

101 $ 6,854,848,838 $ 507,853,101 $

101 102 106 105 107 114
$

(23,455,558) -
1,435,779,195 4,167,109
419,658,913 -
8,690,998,495 $

(28,300,863) -
18,427,129 -
1,153,690,580 -
1,651,669,946 $

(69,687,886)

$ 7,293,014,053 $ 1,219,149,338 (2) $

(69,687,886) $

(497,979,366) $ (497,979,366) $

(51,756,421.45)

-

-

-

1,454,206,323

-

4,167,109

(4,167,109) (4)

1,075,370,126 $ (1,075,370,126) (5)

-

-

9,775,001,189 $ 139,612,103

$

8,512,163,391 $ 2,540,311,714

(51,756,421)

-

-

-

1,454,206,323

433,983,370

-

-

-

-

-

-

9,914,613,292 $ 2,974,295,085

*Note: Asset Retirement Cost is included as a part of the FERC Account 101 Balance in the Trial Balance of SPS. These amounts are not included in Rate Base and are removed from this schedule to reflect that.

(c) Explanation of Adjustments (1) Adjustments include plant additions expected to close within five months after the end of the Base Period.
Please refer to the following testimonies and attachments for support of the plant addition adjustments for production, transmission, distribution, and general plant: the Direct Testimony of Mark P. Moeller and its Attachment MPM-3, the Direct Testimony of Mark Lytal and its Attachment ML-3, the Direct Testimony of Jarred J. Cooley and its Attachment JJC-6, the Direct Testimony of Casey S. Meeks and its Attachment CSM-3, the Direct Testimony of Michael O. Remington and its Attachment MOR-3, and the Direct Testimony of Lawrence A. Bick and its Attachment LAB-3. (2) SPS made an adjustment to remove from rate base software application previously allocated to SPS in accordance with a FERC audit. (3) Please refer to the Direct Testimony of Stephanie N. Niemi regarding removal of Plant Held for Future Use. (4) See Attachment SNN-5, page 9, line 5. (5) See Attachment SNN-5, page 9, line 6.

Schedule B-1 Page 1 of 1
Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Original Cost of Plant in Service by Detail Account

(a) Base Period, (b) Test Year Period

Line

No.

Description

FERC Account
No.

Balance at Beginning of Base Period
10/1/2019

Additions

Retirements

Transfers/ Other

Balance at End of
Base Period
9/30/2020

Adjustments (1)

Total Company Test Year Period

NM Retail Test Year
Period

1

Electric Plant in Service

2 Intangible Plant

3

Organization

4

Franchises & Consents

5

Miscellaneous Intangible Plant

6 Total Intangible Plant

301

$

302

303

$

-$ -
223,378,377 223,378,377 $

-$ -
17,345,806 17,345,806 $

-$ -
(3,727,168) (3,727,168) $

-$ -
-$

-$ -
236,997,016 236,997,016 $

-
10,752,727 10,752,727

$
(2)
(4) $

-$ -
247,749,743 247,749,743 $

-
74,673,813 74,673,813

7 Production Plant - Steam

8

Land & Land/Water Rights

310

9

Structures & Improvements

311

10

Boiler Plant Equipment

312

11

Turbogenerator Units

314

12

Accessory Electrical Equipment

315

13

Miscellaneous Power Plant Equipment 316

14

Asset Retirement Cost - Steam

317

15 Total Production Plant - Steam

$

17,078,044 $

243,099,005

1,018,827,793

516,461,428

86,585,199

32,939,001

(254,077)

$ 1,914,736,394 $

-$ 1,881,180 18,336,238 13,621,079 1,913,183 (441,931) 28,300,863 63,610,612 $

-$ (2,379,811) (13,721,742) (5,926,564)
(549,830) (230,797)
(22,808,744) $

-$ -$

17,078,044 $ 242,600,375 1,023,442,289 524,155,942
87,948,552 32,266,273 28,046,786 1,955,538,263 $

4,492,088 13,694,912 7,039,255 1,574,248 1,051,888
27,852,391

$ (5) $

17,078,044 $ 247,092,463 1,037,137,202 531,195,197 89,522,800 33,318,161 28,046,786 1,983,390,654 $

5,247,619 75,527,120 318,892,362 163,620,263 27,446,050 10,090,659
600,824,072

16 Production Plant - Other

17

Land & Land Rights

340

$

18

Structures & Improvements

341

19

Fuel Holders, Producers, & Access.

342

20

Prime Movers

343

21

Generators

344

22

Accessory Electrical Equipment

345

23

Miscellaneous Power Plant Equipment 346

24

Asset Retirement Cost - Other

347

25 Total Production Plant - Other

$

170,750 $ 59,986,486 6,086,051 54,837,615 796,383,448 51,433,697
4,761,570 16,152,845 989,812,463 $

899,025 $ 139,335 122,857 219,576 11,794,166 267,315
19,156 -
13,461,430 $

-$ (101,705)
(15,522) (54,137) (5,620,571)
(9,744)
(5,801,678) $

-$ -$

1,069,775 $

166,893

$

1,236,669 $

403,396

60,024,116

1,954,121

61,978,236

19,763,024

6,193,387

36,090

6,229,477

1,924,178

55,003,053

2,128,742

57,131,795

17,582,048

802,557,044

820,359,032

1,622,916,076

528,481,423

51,701,012

1,938,925

53,639,938

16,930,776

4,770,983

277,447

5,048,429

1,557,303

16,152,845

-

16,152,845

-

997,472,214 $ 826,861,250 (5) $ 1,824,333,464 $ 586,642,149

26 Transmission Plant

27

Land & Land Rights

350

$

164,335,955 $

7,930,758 $

-$

28

Structures & Improvements

352

113,007,250

12,746,669

(530,345)

29

Station Equipment

353

1,190,581,595

63,537,527

(11,248,787)

30

Towers & Fixtures

354

8,208,645

1,512

-

31

Poles & Fixtures

355

1,263,728,703

134,557,573

(1,499,655)

32

Overhead Conductors & Devices

356

470,227,338

27,649,768

(523,271)

33

Underground Conduit

357

274,970

35

-

34

Underground Conductors & Devices

358

489,717

-

-

35

Roads & Trails

359

517,736

-

-

36

Asset Retirement Cost - Transmission 359.1

25,029

-

-

37 Total Transmission Plant

$ 3,211,396,938 $ 246,423,841 $ (13,802,058) $

-$ 349,322 53,756 (56,378) 346,700 $

172,266,713 $ 125,223,575 1,243,219,657
8,210,157 1,396,840,377
497,297,456 275,005 489,717 517,736 25,029
3,444,365,421 $

721,259

$

17,227,252

121,326,991

180,065

78,636,276

27,525,846

663

(591)

13,610

-

245,631,370 (6) $

172,987,972 $ 142,450,826 1,364,546,648
8,390,222 1,475,476,652
524,823,303 275,667 489,126 531,347 25,029
3,689,996,791 $

42,933,611 33,681,212 337,972,079
2,135,625 367,702,323 131,743,343
69,802 124,300 131,412
916,493,707

Schedule B-2 Page 1 of 3
Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Original Cost of Plant in Service by Detail Account

(a) Base Period, (b) Test Year Period

Line

No.

Description

FERC Account
No.

Balance at Beginning of Base Period
10/1/2019

Additions

Retirements

Transfers/ Other

Balance at End of
Base Period
9/30/2020

Adjustments (1)

Total Company Test Year Period

NM Retail Test Year
Period

38 Distribution Plant

39

Land & Land Rights

360

$

19,559,653 $

4,417,115 $

-$

40

Structures & Improvements

361

27,469,034

7,221,178

(228,670)

41

Station Equipment

362

297,997,156

19,288,616

(2,961,523)

42

Poles, Towers, & Fixtures

364

325,058,011

40,297,146

(1,860,193)

43

Overhead Conductors & Devices

365

280,159,013

25,830,993

(2,146,497)

44

Underground Conduit

366

25,739,028

1,115,064

(2,157)

45

Underground Conductors & Devices

367

47,260,163

4,529,056

(40,960)

46

Line Transformers

368

226,313,368

12,438,660

(1,713,661)

47

Services

369

92,432,384

5,719,227

(158,122)

48

Meters

370

70,155,395

2,375,102

(2,334,291)

49

Installations On Customers Premises

371

13,045,566

17

-

50

Street Lighting & Signal Systems

373

29,055,709

7,237,678

(3,220,889)

51

Asset Retirement Cost - Distribution

374

7,467,368

-

-

52 Total Distribution Plant

$ 1,461,711,846 $ 130,469,854 $ (14,666,962) $

-$ (708,516) (708,516) $

23,976,768 $ 34,461,542 313,615,734 363,494,965 303,843,509 26,851,935 51,748,259 237,038,367 97,993,489 70,196,206 13,045,583 33,072,498 7,467,368 1,576,806,222 $

6,020,036

$

3,122,053

28,402,957

15,558,967

16,469,608

2,509,523

4,564,775

(1,460,900)

(1,050,967)

(350,934)

-

3,688,157

-

77,473,276 (7) $

29,996,804 $ 37,583,595 342,018,691 379,053,932 320,313,117 29,361,458 56,313,034 235,577,467 96,942,522 69,845,272 13,045,583 36,760,655 7,467,368 1,654,279,498 $

15,556,537 18,565,349 145,515,339 133,067,904 134,182,388 7,615,965 15,193,432 76,065,057 33,645,732 25,764,595 4,915,732 15,145,597
625,233,626

53 General Plant

54

Land & Land Rights

55

Structures & Improvements

56

Office Furniture & Equipment

57

Transportation Equipment

58

Stores Equipment

59

Tools, Shop, & Garage Equipment

60

Laboratory Equipment

61

Power Operated Equipment

62

Communication Equipment

63

Miscellaneous Equipment

64

Asset Retirement Cost - General

65 Total General Plant

389

$

390

391

392

393

394

395

396

397

398

399.1

$

1,103,209 $ 80,238,101 92,845,225 116,077,468
430,683 46,518,513 11,109,050 14,816,242 123,602,410 2,786,720
64,394 489,592,015 $

2,007,640 $ 6,749,517 28,414,647 6,223,312
5,242,114
6,331,457 54,968,686 $

(4,521) $ (551,884) (6,875,182)
(21) 242 (131,498) (180,542) (1,097,886)
(0) (39,984)
(8,881,277) $

-$ 361,816 361,816 $

3,106,327 $ 86,435,734 114,384,690 122,300,758
430,925 51,629,128 10,928,508 13,718,357 130,295,683 2,746,736
64,394 536,041,240 $

10,304,527 9,874,609 3,502,816
287 1,171,703
54,934 86,540 5,577,849 5,058
30,578,323

$ (8) $

3,106,327 $ 96,740,261 124,259,299 125,803,575
431,211 52,800,831 10,983,442 13,804,897 135,873,533 2,751,794
64,394 566,619,564 $

933,835 29,190,260 37,355,280 37,736,713
131,974 15,811,821 3,346,940 4,232,890 40,846,793
841,209 -
170,427,718

Schedule B-2 Page 2 of 3
Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Original Cost of Plant in Service by Detail Account

(a) Base Period, (b) Test Year Period

Line

No.

Description

FERC Account
No.

Balance at Beginning of Base Period
10/1/2019

Additions

Retirements

Transfers/ Other

Balance at End of
Base Period
9/30/2020

Adjustments (1)

Total Company Test Year Period

NM Retail Test Year
Period

66 Removal of Asset Retirement Costs

67

Asset Retirement Cost - Steam

317

$

68

Asset Retirement Cost - Other

347

69

Asset Retirement Cost - Transmission 359.1

70

Asset Retirement Cost - Distribution

374

71

Asset Retirement Cost - General

399.1

72 Total Removal of Asset Retirement Costs

$

254,077 $ (16,152,845)
(25,029) (7,467,368)
(64,394)
(23,455,558) $

(28,300,863) $ -
(28,300,863) $

-$ -
-$

-$ -
-$

(28,046,786) $ (16,152,845)
(25,029) (7,467,368)
(64,394)
(51,756,421) $

-

$ (28,046,786) $

-

-

(16,152,845)

-

-

(25,029)

-

-

(7,467,368)

-

-

(64,394)

-

-

$ (51,756,421) $

-

73 Total Electric Plant In Service*

101/106 $ 8,267,172,474 $ 497,979,366 $ (69,687,886) $

(0) $ 8,695,463,955 $ 1,219,149,338

$ 9,914,613,292 $ 2,974,295,085

74 Electric Plant Purchased

102

$

-$

-$

-$

-$

-$

-

$

-$

-

75 Electric Plant Held For Future Use (3)

76

Land & Land Rights

105

$

77

Transmission Station Equipment

105

78 Total Electric Plant Held For Future Use

$

4,167,109 $ -
4,167,109 $

-$ -$

-$ -$

-$ -$

4,167,109 $ -
4,167,109 $

(4,167,109) $
(4,167,109) (9) $

-$

-

-

-

-$

-

79 Construction Work in Progress

107

$ 419,658,912.59 $ 1,153,690,579.67

$ (497,979,366.49) $ 1,075,370,125.77 $ (1,075,370,126) $

-$

-

80 Electric Plant Acquisition Adjustment 114

-

-

-

-

-

-

-

-

81 Total Electric Plant

$ 8,690,998,495 $ 1,651,669,946 $ (69,687,886) $ (497,979,366) $ 9,775,001,189 $ 139,612,103

$ 9,914,613,292 $ 2,974,295,085

*Note: Asset Retirement Cost is included as a part of the FERC Account 101 Balance in the Trial Balance of SPS. These amounts are not included in Rate Base and are being removed from this schedule to reflect that.

(c) Explanation of Adjustments (1) Adjustments include plant additions expected to close within five months after the end of the Base Period.
Please refer to the following testimonies and attachments for support of the plant addition adjustments for production, transmission, distribution, and general plant: the Direct Testimony of Mark P. Moeller and its Attachment MPM-3, the Direct Testimony of Mark Lytal and its Attachment ML-3, the Direct Testimony of Jarred J. Cooley and its Attachment JJC-6, the Direct Testimony of Casey S. Meeks and its Attachment CSM-3, the Direct Testimony of Michael O. Remington and its Attachment MOR-3, and the Direct Testimony of Lawrence A. Bick and its Attachment LAB-3. (2) SPS made an adjustment to remove from rate base software application previously allocated to SPS in accordance with a FERC audit. (3) Please refer to the Direct Testimony of Stephanie N. Niemi regarding removal of Plant Held for Future Use. (4) See Attachment SNN-6, page 62, line 39, as well as lines 1 through 38 for details of adjustments. (5) See Attachment SNN-6, page 64, line 141, as well as pages 62-64, lines 40 through 140 for details of adjustments. (6) See Attchment SNN-6, page 67, line 276, as well as pages 64-67, lines 142 through 275 for details of adjustments. (7) See Attachment SNN-6, page 68, line 342, as well as pages 67-68, lines 277 through 341 for details of adjustments. (8) See Attachment SNN-6, page 70, line 424, as well as pages 68-70, lines 343 through 423 for details of adjustments. (9) See Attachment SNN-6, page 85, line 287.

Schedule B-2 Page 3 of 3
Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Original Cost of Plant in Service by Monthly Balances
(a) Base Period, (b) Test Year Period

Line

No.

Description

1

Electric Plant in Service

2 Intangible Plant 3 Organization 4 Franchises & Consents 5 Miscellaneous Intangible Plant 6 Miscellaneous Intangible Plant

7 Total Intangible Plant

8 Production Plant - Steam 9 Fee Land 10 Land & Land Rights 11 Water Rights 12 Production Land Rights NM 13 Structures & Improvements 14 Boiler Plant Equipment. 15 Turbogenerator Units 16 Accessory Electrical Equipment 17 Miscellaneous Power Plant Equipment 18 Asset Retirement Cost - Steam
19 Total Production Plant - Steam

20 Production Plant - Other 21 Fee Land 22 Land Rights 23 Structures & Improvements 24 Fuel Holders, Producer, & Access. 25 Prime Movers 26 Generators 27 Accessory Electrical Equipment 28 Miscellaneous Power Plant Equipment 28 Asset Retirement Cost - Other
29 Total Production Plant - Other

30 Transmission Plant 31 Fee Land 32 Land Rights 33 Structures & Improvements 34 Station Equipment 35 Station Equipment - Prod. 36 Towers & Fixtures 37 Poles & Fixtures 38 Overhead Conductors & Devices 39 Underground Conduit 40 Underground Conductors & Devices 41 Roads & Trails 42 Asset Retirement Cost - Transmission
43 Total Transmission Plant

FERC Acct No.

9/30/2019

10/31/2019

11/30/2019

12/31/2019

1/31/2020

2/29/2020

3/31/2020

4/30/2020

301 $ 302 303.1 303.2
$

201,693,117 21,685,260
223,378,377

$

-

-

202,295,273

21,685,260

$ 223,980,533

$

-

-

204,436,388

21,685,260

$ 226,121,649

$

-

-

208,514,309

21,685,260

$ 230,199,569

$

-

-

209,580,539

21,685,260

$ 231,265,799

$

-

-

210,106,471

21,685,260

$ 231,791,731

$

-

-

211,098,144

21,685,322

$ 232,783,466

$

-

-

211,208,555

21,685,322

$ 232,893,877

310.1 $ 310.2 310.3 310.4 311 312 314 315 316 317
$

4,355,213 1,098,015 11,551,745
73,071 243,099,005 1,018,827,793 516,461,428 86,585,199 32,939,001
(254,077)
1,914,736,394

$

4,355,213

1,098,015

11,551,745

73,071

243,111,149

1,019,017,666

519,195,613

86,658,323

32,939,001

(254,077)

$ 1,917,745,720

$

4,355,213

1,098,015

11,551,745

73,071

244,543,019

1,020,224,588

523,811,095

86,983,621

32,939,001

(254,077)

$ 1,925,325,293

$

4,355,213

1,098,015

11,551,745

73,071

244,685,910

1,022,475,850

524,076,284

87,047,748

32,939,001

28,046,786

$ 1,956,349,625

$

4,355,213

1,098,015

11,551,745

73,071

244,548,153

1,020,089,722

524,309,892

87,289,349

32,910,394

28,046,786

$ 1,954,272,340

$

4,355,213

1,098,015

11,551,745

73,071

244,548,153

1,020,213,534

524,468,632

87,308,229

32,910,394

28,046,786

$ 1,954,573,773

$

4,355,213

1,098,015

11,551,745

73,071

243,011,450

1,016,293,715

520,788,547

86,921,110

32,271,944

28,046,786

$ 1,944,411,598

$

4,355,213

1,098,015

11,551,745

73,071

242,446,460

1,013,650,915

520,800,055

86,892,686

32,236,002

28,046,786

$ 1,941,150,949

340.1 $ 340.2 341 342 343 344 345 346 347
$

170,075 676
59,986,486 6,086,051
54,837,615 796,383,448 51,433,697
4,761,570 16,152,845
989,812,463

$

170,075

676

60,001,794

6,086,051

54,837,615

796,890,920

51,452,531

4,770,939

16,152,845

$ 990,363,445

$

170,075

676

60,129,712

6,100,996

54,837,615

798,913,793

51,507,598

4,770,984

16,152,845

$ 992,584,292

$

170,075

676

60,135,648

6,100,996

54,837,615

798,992,971

51,510,153

4,770,986

16,152,845

$ 992,671,964

$

170,075

676

60,134,177

6,208,909

54,837,615

799,145,051

51,509,520

4,770,986

16,152,845

$ 992,929,851

$

170,075

676

60,136,209

6,208,909

54,837,615

799,172,153

51,510,394

4,770,987

16,152,845

$ 992,959,861

$

115,046

55,704

60,064,789

6,201,277

55,003,053

798,743,946

51,546,692

4,770,976

16,152,845

$ 992,654,329

$

937,040

55,704

60,006,897

6,193,387

55,003,053

798,756,166

51,552,646

4,770,977

16,152,845

$ 993,428,714

350.1 $ 350.2 352 353 353.1 354 355 356 357 358 359 359.1
$

8,811,403 155,524,553 113,007,250 1,147,558,531
43,023,064 8,208,645 1,263,728,703 470,227,338
274,970 489,717 517,736
25,029
3,211,396,938

$

8,605,325

155,729,046

113,944,988

1,151,687,072

42,753,535

8,208,671

1,269,688,926

469,141,108

275,005

489,717

517,736

25,029

$ 3,221,066,159

$

8,605,325

156,283,884

114,538,120

1,154,844,679

42,746,967

8,208,670

1,272,711,365

470,142,207

275,005

489,717

517,736

25,029

$ 3,229,388,703

$

8,845,073

157,280,486

120,515,732

1,173,723,874

42,746,967

8,208,670

1,282,992,088

475,774,199

275,005

489,717

517,736

25,029

$ 3,271,394,574

$

8,845,530

156,515,385

120,738,092

1,176,442,395

42,847,229

8,208,671

1,281,855,261

477,586,644

275,005

489,717

517,736

25,029

$ 3,274,346,693

$

8,845,612

156,694,649

124,566,375

1,185,895,932

42,353,018

8,208,671

1,281,773,997

477,887,976

275,005

489,717

517,736

25,029

$ 3,287,533,715

$

8,746,922

159,958,986

124,709,947

1,188,795,920

42,311,872

8,208,671

1,287,224,137

479,565,067

275,005

489,717

517,736

25,029

$ 3,300,829,008

$

8,844,557

161,252,761

124,737,017

1,193,252,717

42,290,885

8,208,667

1,290,701,344

479,804,066

275,005

489,717

517,736

25,029

$ 3,310,399,500

Schedule B-3 Page 1 of 6
Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Original Cost of Plant in Service by Monthly Balances
(a) Base Period, (b) Test Year Period

Line

No.

Description

1

Electric Plant in Service

2 Intangible Plant 3 Organization 4 Franchises & Consents 5 Miscellaneous Intangible Plant 6 Miscellaneous Intangible Plant

7 Total Intangible Plant

8 Production Plant - Steam 9 Fee Land 10 Land & Land Rights 11 Water Rights 12 Production Land Rights NM 13 Structures & Improvements 14 Boiler Plant Equipment. 15 Turbogenerator Units 16 Accessory Electrical Equipment 17 Miscellaneous Power Plant Equipment 18 Asset Retirement Cost - Steam
19 Total Production Plant - Steam

20 Production Plant - Other 21 Fee Land 22 Land Rights 23 Structures & Improvements 24 Fuel Holders, Producer, & Access. 25 Prime Movers 26 Generators 27 Accessory Electrical Equipment 28 Miscellaneous Power Plant Equipment 28 Asset Retirement Cost - Other
29 Total Production Plant - Other

30 Transmission Plant 31 Fee Land 32 Land Rights 33 Structures & Improvements 34 Station Equipment 35 Station Equipment - Prod. 36 Towers & Fixtures 37 Poles & Fixtures 38 Overhead Conductors & Devices 39 Underground Conduit 40 Underground Conductors & Devices 41 Roads & Trails 42 Asset Retirement Cost - Transmission
43 Total Transmission Plant

FERC Acct No.

5/31/2020

6/30/2020

7/31/2020

8/31/2020

Base Period Ending Balance
9/30/2020

Adjustments (1)

Total Company Test Year
Period

NM Retail Test Year
Period

301 $

-

302

-

303.1

211,313,042

303.2

21,685,406

$ 232,998,448

$

-

-

214,142,674

21,685,406

$ 235,828,080

$

-

-

214,250,672

21,685,406

$ 235,936,078

$

-$

-

214,735,753

21,685,406

$ 236,421,159 $

-$

-

$

-$

-

215,311,609

9,660,128 (2)

224,971,737

74,673,813

21,685,406

1,092,599

22,778,005

-

236,997,016 $ 10,752,727 (4) $ 247,749,743 $ 74,673,813

310.1 $

4,355,213 $

4,355,213 $

4,355,213 $

4,355,213 $

310.2

1,098,015

1,098,015

1,098,015

1,098,015

310.3

11,551,745

11,551,745

11,551,745

11,551,745

310.4

73,071

73,071

73,071

73,071

311

242,538,441

242,264,817

242,521,867

242,532,406

312

1,018,029,794

1,016,965,879

1,020,924,114

1,022,122,964

314

524,214,923

524,564,131

523,411,360

523,449,470

315

87,664,367

87,659,821

87,906,483

87,945,876

316

32,267,008

32,266,273

32,266,273

32,266,273

317

28,046,786

28,046,786

28,046,786

28,046,786

$ 1,949,839,364 $ 1,948,845,752 $ 1,952,154,927 $ 1,953,441,820 $

4,355,213 $

-

$

4,355,213 $

1,338,239

1,098,015

-

1,098,015

337,390

11,551,745

-

11,551,745

3,549,538

73,071

-

73,071

22,453

242,600,375

4,492,088

247,092,463

75,527,120

1,023,442,289

13,694,912

1,037,137,202

318,892,362

524,155,942

7,039,255

531,195,197

163,620,263

87,948,552

1,574,248

89,522,800

27,446,050

32,266,273

1,051,888

33,318,161

10,090,659

28,046,786

-

28,046,786

-

1,955,538,263 $ 27,852,391 (5) $ 1,983,390,654 $ 600,824,072

340.1 $

937,040 $

937,040 $

937,040 $

1,069,099 $

340.2

55,704

55,704

55,704

676

341

60,009,019

60,010,588

60,012,177

60,027,228

342

6,193,387

6,193,387

6,193,387

6,193,387

343

55,003,053

55,003,053

55,003,053

55,003,053

344

798,854,485

793,828,957

801,301,912

802,515,927

345

51,604,176

51,614,782

51,621,208

51,701,608

346

4,770,978

4,770,978

4,770,979

4,770,984

347

16,152,845

16,152,845

16,152,845

16,152,845

$ 993,580,686 $ 988,567,334 $ 996,048,305 $ 997,434,807 $

1,069,099 676
60,024,116 6,193,387 55,003,053 802,557,044 51,701,012 4,770,983 16,152,845
997,472,214

$

166,893

$

1,235,993

-

676

1,954,121

61,978,236

36,090

6,229,477

2,128,742

57,131,795

820,359,032

1,622,916,076

1,938,925

53,639,938

277,447

5,048,429

-

16,152,845

$ 826,861,250 (5) $ 1,824,333,464

$

403,188

208

19,763,024

1,924,178

17,582,048

528,481,423

16,930,776

1,557,303

-

$ 586,642,149

350.1 $

8,847,962 $

8,847,962 $

9,789,193 $

9,948,903 $

350.2

161,273,932

161,306,699

161,336,484

161,354,012

352

124,790,717

124,998,538

125,194,434

125,923,906

353

1,202,221,530

1,202,543,187

1,202,582,927

1,201,700,172

353.1

42,287,290

42,297,164

42,042,070

42,068,537

354

8,208,693

8,208,692

8,208,687

8,208,687

355

1,389,216,319

1,393,028,406

1,393,320,355

1,395,962,519

356

495,118,047

495,769,732

495,885,950

497,290,477

357

275,005

275,005

275,005

275,005

358

489,717

489,717

489,717

489,717

359

517,736

517,736

517,736

517,736

359.1

25,029

25,029

25,029

25,029

$ 3,433,271,977 $ 3,438,307,866 $ 3,439,667,586 $ 3,443,764,699 $

10,508,578 161,758,136 125,223,575 1,201,154,413 42,065,244
8,210,157 1,396,840,377
497,297,456 275,005 489,717 517,736 25,029
3,444,365,421

$

186,643

$ 10,695,220

534,616

162,292,752

17,227,252

142,450,826

87,882,589

1,289,037,002

33,444,402

75,509,646

180,065

8,390,222

78,636,276

1,475,476,652

27,525,846

524,823,303

663

275,667

(591)

489,126

13,610

531,347

-

25,029

$ 245,631,370 (6) $ 3,689,996,791

$

2,611,512

40,322,100

33,681,212

313,615,190

24,356,889

2,135,625

367,702,323

131,743,343

69,802

124,300

131,412

-

$ 916,493,707

Schedule B-3 Page 2 of 6
Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Original Cost of Plant in Service by Monthly Balances
(a) Base Period, (b) Test Year Period

Line

No.

Description

44 Distribution Plant 45 Fee Land 46 Land Dist Rights - NM 47 Land Dist Rights - TX 48 Structures & Improvements 49 Station Equipment 50 Poles, Towers, & Fixtures 51 Overhead Conductors & Devices 52 Underground Conduit 53 Underground Conductors & Devices 54 Line Transformers 55 Services - Overhead 56 Services - Underground 57 Meters 58 Installations On Customers Premises 59 Street Lighting & Signal Systems 60 Asset Retirement Cost - Distribution
61 Total Distribution Plant

62 General Plant 63 Fee Land 64 Land Rights 65 Structures & Improvements 66 Remodeling Leased Facilities 67 Office Furniture & Equipment 68 Info Sys Computers/Peripherals 69 Info Sys Computers 3 yr life 70 Transportation Equipment 71 Stores Equipment 72 Tools, Shop, & Garage Equipment 73 Laboratory Equipment 74 Power Operated Equipment 75 Communication Equipment 76 Miscellaneous Equipment 77 Asset Retirement Cost - General
78 Total General Plant

FERC Acct No.

9/30/2019

10/31/2019

11/30/2019

12/31/2019

1/31/2020

2/29/2020

3/31/2020

4/30/2020

360.1 $ 360.2 360.3 361 362 364 365 366 367 368 369.1 369.2 370 371 373 374
$

8,236,424 8,398,750 2,924,478 27,469,034 297,997,156 325,058,011 280,159,013 25,739,028 47,260,163 226,313,368 48,514,788 43,917,596 70,155,395 13,045,566 29,055,709 7,467,368
1,461,711,846

$

8,239,113

8,581,589

2,925,164

27,492,630

298,346,591

327,319,967

280,511,202

26,279,058

47,667,844

228,198,789

48,727,661

44,083,071

70,695,239

13,045,583

29,666,815

7,467,368

$ 1,469,247,684

$

8,241,835

8,807,473

2,934,130

28,049,334

300,457,513

328,329,969

281,073,172

26,385,214

47,944,046

228,978,039

48,859,450

44,212,314

70,733,134

13,045,583

30,035,159

7,467,368

$ 1,475,553,732

$

8,242,744

9,050,149

2,935,730

29,775,672

306,563,006

333,961,225

284,575,401

26,511,583

48,504,086

228,099,932

49,067,405

44,389,114

68,522,716

13,045,583

30,175,349

7,467,368

$ 1,490,887,064

$

8,247,062

9,288,279

2,935,730

30,819,163

307,979,426

335,457,277

285,423,155

26,584,145

48,978,913

228,592,049

49,290,096

44,626,744

68,646,161

13,045,583

30,615,345

7,467,368

$ 1,497,996,495

$

8,251,949

9,407,533

2,942,619

31,127,892

307,643,761

338,479,347

286,201,656

26,690,636

49,471,769

229,095,915

49,407,971

44,782,138

68,906,511

13,045,583

30,670,124

7,467,368

$ 1,503,592,773

$

8,257,995

9,718,122

2,954,437

31,186,791

307,052,369

342,475,034

287,768,711

26,611,726

49,164,737

230,017,106

49,514,402

44,978,233

69,061,539

13,045,583

30,699,762

7,467,368

$ 1,509,973,914

$

8,258,165

10,109,872

2,954,897

31,378,384

309,079,171

345,711,978

289,996,224

26,639,117

49,249,118

231,373,443

49,683,788

45,708,048

69,256,894

13,045,583

30,745,064

7,467,368

$ 1,520,657,114

389.1 $ 389.2 390 390.1 391 391.1 391.2 392 393 394 395 396 397 398 399.1
$

1,057,242 45,967
76,005,255 4,232,845 18,470,106 74,375,119
116,077,468
430,683 46,518,513 11,109,050 14,816,242 123,602,410
2,786,720 64,394
489,592,015

$

1,057,242

45,967

76,013,659

4,232,845

18,237,529

73,639,064

-

116,359,340

430,925

47,817,125

11,024,872

14,117,586

124,121,260

2,786,720

64,394

$ 489,948,527

$

1,057,242

45,967

76,031,665

4,232,845

18,237,529

71,257,185

-

116,593,805

430,925

47,817,125

11,024,872

14,117,586

124,314,987

2,786,720

64,394

$ 488,012,846

$

1,057,242

45,967

76,031,786

4,232,845

19,343,313

85,653,730

-

117,381,216

430,925

48,764,896

10,938,512

13,993,739

125,327,154

2,786,720

64,394

$ 506,052,439

$

1,057,242

45,967

76,031,883

4,232,845

19,366,371

86,509,143

-

118,332,346

430,925

49,295,582

10,938,512

13,993,739

125,574,901

2,786,720

64,394

$ 508,660,570

$

1,057,242

45,967

76,005,175

4,232,845

19,444,144

88,490,922

-

118,855,355

430,925

49,332,220

10,938,512

13,993,739

126,373,554

2,786,720

64,394

$ 512,051,714

$

1,057,242

45,967

76,005,456

4,232,845

19,444,144

92,757,221

-

119,011,043

430,925

49,417,788

10,938,512

13,993,739

126,335,135

2,786,720

64,394

$ 516,521,132

$

1,057,242

45,967

76,007,858

4,232,845

19,444,144

91,701,255

-

119,382,267

430,925

49,849,272

10,937,865

13,739,331

126,364,362

2,786,634

64,394

$ 516,044,362

Schedule B-3 Page 3 of 6
Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Original Cost of Plant in Service by Monthly Balances
(a) Base Period, (b) Test Year Period

Line

No.

Description

44 Distribution Plant 45 Fee Land 46 Land Dist Rights - NM 47 Land Dist Rights - TX 48 Structures & Improvements 49 Station Equipment 50 Poles, Towers, & Fixtures 51 Overhead Conductors & Devices 52 Underground Conduit 53 Underground Conductors & Devices 54 Line Transformers 55 Services - Overhead 56 Services - Underground 57 Meters 58 Installations On Customers Premises 59 Street Lighting & Signal Systems 60 Asset Retirement Cost - Distribution
61 Total Distribution Plant

62 General Plant 63 Fee Land 64 Land Rights 65 Structures & Improvements 66 Remodeling Leased Facilities 67 Office Furniture & Equipment 68 Info Sys Computers/Peripherals 69 Info Sys Computers 3 yr life 70 Transportation Equipment 71 Stores Equipment 72 Tools, Shop, & Garage Equipment 73 Laboratory Equipment 74 Power Operated Equipment 75 Communication Equipment 76 Miscellaneous Equipment 77 Asset Retirement Cost - General
78 Total General Plant

FERC Acct No.

5/31/2020

6/30/2020

7/31/2020

8/31/2020

Base Period Ending Balance
9/30/2020

Adjustments (1)

Total Company Test Year
Period

NM Retail Test Year
Period

360.1 $

8,324,327

360.2

10,341,327

360.3

2,957,700

361

31,433,945

362

309,564,537

364

348,454,959

365

291,801,113

366

26,625,509

367

49,459,131

368

231,993,474

369.1

50,005,768

369.2

45,944,807

370

69,349,984

371

13,045,583

373

31,311,494

374

7,467,368

$

8,505,198

10,778,592

2,959,012

34,255,573

311,729,374

353,279,795

295,030,936

26,726,742

50,552,184

233,669,134

50,194,657

46,246,084

69,702,662

13,045,583

31,778,701

7,467,368

$

8,505,958

11,026,807

2,962,417

34,391,630

312,062,513

357,558,067

300,154,645

26,784,522

51,058,575

235,162,937

50,472,810

46,479,580

69,841,253

13,045,583

32,085,833

7,467,368

$

9,612,140 $

11,141,973

2,962,417

34,436,776

313,562,835

360,983,549

302,130,523

26,852,692

51,595,371

235,966,004

50,612,478

46,707,456

70,112,305

13,045,583

32,704,147

7,467,368

$ 1,528,081,025 $ 1,545,921,595 $ 1,559,060,498 $ 1,569,893,617 $

9,612,889 $

5,221,139

$ 14,834,029 $

3,384,718

11,399,922

771,897

12,171,819

12,171,819

2,963,957

27,000

2,990,957

-

34,461,542

3,122,053

37,583,595

18,565,349

313,615,734

28,402,957

342,018,691

145,515,339

363,494,965

15,558,967

379,053,932

133,067,904

303,843,509

16,469,608

320,313,117

134,182,388

26,851,935

2,509,523

29,361,458

7,615,965

51,748,259

4,564,775

56,313,034

15,193,432

237,038,367

(1,460,900)

235,577,467

76,065,057

50,842,612

(549,223)

50,293,389

17,256,432

47,150,877

(501,744)

46,649,133

16,389,300

70,196,206

(350,934)

69,845,272

25,764,595

13,045,583

-

13,045,583

4,915,732

33,072,498

3,688,157

36,760,655

15,145,597

7,467,368

-

7,467,368

-

1,576,806,222 $ 77,473,276 (7) $ 1,654,279,498 $ 625,233,626

389.1 $

3,064,881 $

3,064,881 $

3,060,360 $

3,060,360 $

389.2

45,967

45,967

45,967

45,967

390

82,068,044

82,012,867

82,228,502

82,228,502

390.1

4,232,845

4,283,959

3,663,394

3,663,394

391

19,444,144

19,437,207

19,440,250

19,299,308

391.1

91,989,552

92,062,289

93,094,751

93,615,545

391.2

-

-

-

-

392

119,838,185

121,293,458

121,897,045

121,897,045

393

430,925

430,925

430,925

430,925

394

50,732,722

50,763,167

50,787,738

51,051,044

395

10,937,865

10,928,508

10,928,508

10,928,508

396

13,739,331

13,718,357

13,718,357

13,718,357

397

126,680,426

127,952,550

129,026,797

129,872,344

398

2,786,634

2,746,736

2,746,736

2,746,736

399.1

64,394

64,394

64,394

64,394

$ 526,055,915 $ 528,805,266 $ 531,133,724 $ 532,622,429 $

3,060,360 $

-

$

3,060,360 $

920,016

45,967

-

45,967

13,819

82,772,340

10,304,527

93,076,867

28,088,958

3,663,394

-

3,663,394

1,101,303

20,956,894

2,489,103

23,445,997

7,048,420

93,427,796

7,385,507

100,813,302

30,306,860

-

-

-

0

122,300,758

3,502,816

125,803,575

37,736,713

430,925

287

431,211

131,974

51,629,128

1,171,703

52,800,831

15,811,821

10,928,508

54,934

10,983,442

3,346,940

13,718,357

86,540

13,804,897

4,232,890

130,295,683

5,577,849

135,873,533

40,846,793

2,746,736

5,058

2,751,794

841,209

64,394

-

64,394

-

536,041,240 $ 30,578,323 (8) $ 566,619,564 $ 170,427,718

Schedule B-3 Page 4 of 6
Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Original Cost of Plant in Service by Monthly Balances

(a) Base Period, (b) Test Year Period

Line

No.

Description

79 Removal of the Asset Retirement Cost 80 Asset Retirement Cost - Steam 81 Asset Retirement Cost - Other 82 Asset Retirement Cost - Transmission 83 Asset Retirement Cost - Distribution 84 Asset Retirement Cost - General
85 Total Removal of the Asset Retirement Cost

86 Total Electric Plant In Service*

87 Electric Plant Purchased 88 Electric Plant Held For Future Use (3) 89 Construction Work in Progress 90 Electric Plant Acquisition Adjustment

91 Total Electric Plant

FERC Acct No.

9/30/2019

10/31/2019

11/30/2019

12/31/2019

1/31/2020

2/29/2020

3/31/2020

4/30/2020

317 $ 347 359.1 374 399.1
$
101/106 $
102 $
105 $
107 $
114 $
$

254,077 $

254,077 $

254,077 $ (28,046,786) $ (28,046,786) $ (28,046,786) $ (28,046,786) $ (28,046,786)

(16,152,845)

(16,152,845)

(16,152,845)

(16,152,845)

(16,152,845)

(16,152,845)

(16,152,845)

(16,152,845)

(25,029)

(25,029)

(25,029)

(25,029)

(25,029)

(25,029)

(25,029)

(25,029)

(7,467,368)

(7,467,368)

(7,467,368)

(7,467,368)

(7,467,368)

(7,467,368)

(7,467,368)

(7,467,368)

(64,394)

(64,394)

(64,394)

(64,394)

(64,394)

(64,394)

(64,394)

(64,394)

(23,455,558) $ (23,455,558) $ (23,455,558) $ (51,756,421) $ (51,756,421) $ (51,756,421) $ (51,756,421) $ (51,756,421)

8,267,172,474 $ 8,288,896,510 $ 8,313,530,956 $ 8,395,798,814 $ 8,407,715,326 $ 8,430,747,146 $ 8,445,417,025 $ 8,462,818,095

4,167,109 419,658,913
-

$

-

$

4,167,109

$ 438,716,629

$

-

$

-

$

4,167,109

$ 453,269,487

$

-

$

-

$

4,167,109

$ 486,406,071

$

-

$

-

$

4,167,109

$ 522,206,516

$

-

$

-

$

4,167,109

$ 564,562,682

$

-

$

-

$

4,167,109

$ 617,376,175

$

-

$

-

$

4,167,109

$ 736,404,854

$

-

8,690,998,495 $ 8,731,780,247 $ 8,770,967,552 $ 8,886,371,993 $ 8,934,088,951 $ 8,999,476,936 $ 9,066,960,308 $ 9,203,390,058

Schedule B-3 Page 5 of 6
Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Original Cost of Plant in Service by Monthly Balances

(a) Base Period, (b) Test Year Period

Line

No.

Description

79 Removal of the Asset Retirement Cost 80 Asset Retirement Cost - Steam 81 Asset Retirement Cost - Other 82 Asset Retirement Cost - Transmission 83 Asset Retirement Cost - Distribution 84 Asset Retirement Cost - General
85 Total Removal of the Asset Retirement Cost

86 Total Electric Plant In Service*

87 Electric Plant Purchased 88 Electric Plant Held For Future Use (3) 89 Construction Work in Progress 90 Electric Plant Acquisition Adjustment

91 Total Electric Plant

FERC Acct No.

5/31/2020

6/30/2020

7/31/2020

8/31/2020

Base Period Ending Balance
9/30/2020

Adjustments (1)

Total Company Test Year
Period

NM Retail Test Year
Period

317 $ (28,046,786) $ (28,046,786) $ (28,046,786) $ (28,046,786) $

347

(16,152,845)

(16,152,845)

(16,152,845)

(16,152,845)

359.1

(25,029)

(25,029)

(25,029)

(25,029)

374

(7,467,368)

(7,467,368)

(7,467,368)

(7,467,368)

399.1

(64,394)

(64,394)

(64,394)

(64,394)

$ (51,756,421) $ (51,756,421) $ (51,756,421) $ (51,756,421) $

101/106 $ 8,612,070,994 $ 8,634,519,470 $ 8,662,244,696 $ 8,681,822,109 $

102 $

-$

-$

-$

-$

105 $

4,167,109 $

4,167,109 $

4,167,109 $

4,167,109 $

107 $ 709,059,710 $ 802,661,604 $ 882,610,566 $ 974,308,812 $

114 $

-$

-$

-$

-$

$ 9,325,297,813 $ 9,441,348,182 $ 9,549,022,370 $ 9,660,298,029 $

(28,046,786) $

-

$ (28,046,786) $

-

(16,152,845)

-

(16,152,845)

-

(25,029)

-

(25,029)

-

(7,467,368)

-

(7,467,368)

-

(64,394)

-

(64,394)

-

(51,756,421) $

-

$ (51,756,421) $

-

8,695,463,955 $ 1,219,149,338

$ 9,914,613,292 $ 2,974,295,085

-$

-

$

-$

-

4,167,109 $

(4,167,109) (9) $

-

-

1,075,370,126 $ (1,075,370,126) (10) $

-

-

-$

-

$

-

-

9,775,001,189 $ 139,612,103

$ 9,914,613,292 $ 2,974,295,085

*Note: Asset Retirement Cost is included as a part of the FERC Account 101 Balance in the Trial Balance of SPS. These amounts are not included in Rate Base and are removed from this schedule to reflect that.
(c) Explanation of Adjustments
(1) Adjustments include plant additions expected to close within five months after the end of the Base Period.
Please refer to the following testimonies and attachments for support of the plant addition adjustments for production, transmission, distribution, and general plant: the Direct Testimony of Mark P. Moeller and its Attachment MPM-3, the Direct Testimony of Mark Lytal and its Attachment ML-3, the Direct Testimony of Jarred J. Cooley and its Attachment JJC-6, the Direct Testimony of Casey S. Meeks and its Attachment CSM-3, the Direct Testimony of Michael O. Remington and its Attachment MOR-3, and the Direct Testimony of Lawrence A. Bick and its Attachment LAB-3. (2) SPS made an adjustment to remove from rate base software application previously allocated to SPS in accordance with a FERC audit. (3) Please refer to the Direct Testimony of Stephanie N. Niemi regarding removal of Plant Held for Future Use. (4) See Attachment SNN-6, page 62, line 39, as well as lines 1 through 38 for details of adjustments. (5) See Attachment SNN-6, page 64, line 141, as well as pages 62-64, lines 40 through 140 for details of adjustments. (6) See Attchment SNN-6, page 67, line 276, as well as pages 64-67, lines 142 through 275 for details of adjustments. (7) See Attachment SNN-6, page 68, line 342, as well as pages 67-68, lines 277 through 341 for details of adjustments. (8) See Attachment SNN-6, page 70, line 424, as well as pages 68-70, lines 343 through 423 for details of adjustments. (9) See Attachment SNN-6, page 85, line 287. (10) See Attachment SNN-6, page 85, line 279, as well as pages 80-85, lines 1-278 through for details of adjustments.

Schedule B-3 Page 6 of 6
Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Construction Work in Progress

(a) Base Period, (b) Test Year Period

Line

No.

Project No.

Project Description

1 Distribution - New Mexico

2

A.0000424.248 Install Medanos Substation

3

A.0000424.260 Install Medanos Fdr3

4

A.0000424.276 Install new Lynch 115/23kV 50 MVA X

5

A.0001214.009 Install feeders for New Malaga Sub

6

A.0001214.010 Install New Malaga Substation

7

A.0001408.003 SUBS Sisko

8

A.0001419.002 Install Millen #2 28 MVA XFR

9

A.0005507.090 NM - LED Street Light Conversi

10

A.0005521.200 NM - Subs Equipment Replace

11

A.0005584.002 NEW MEXICO MAJOR STORM RECOVERY

12

A.0010002.001 NM - OH Extension Blanket

13

A.0010018.001 NM - OH Rebuild Blanket

14

A.0010060.008 LVNG 7 24 27 CIMAREX N WHITE CITY

15

A.0010060.011 SOLARIS TROVE SWD SLACK SPAN

16

A.0010092.003 Install Loving South T2 Feeders

17

A.0010092.006 Install Ponderosa 3rd Fdr

18

A.0010092.011 JAL EO/SAGEBRUSH WEST EXT/NEW LINE

19

A.0010092.012 Jal/HWY 176 Sage Brush Pearl Extens

20

A.0010092.015 HBB EO/MESQ SWD BATTLE AXE BOWL

21

A.0010092.016 ART/550 E MAIN ST Navajo Soy-biodie

22

A.0010092.019 LOV/CND-HOPI/BOUNDS RD & JD FOREHAN

23

A.0010132.005 SPS 2020 New 28MVA Mobile for SENM

24

A.0000126.016 Artesia Country Club DCP Subs

25

A.0000424.240 Install roadrunner Fdr1

26

A.0000424.241 Install roadrunner Fdr2

27

A.0005508.147 SPS-NM Convert Obsolete Vltg

28

A.0005522.261 TAM: Convert South Loving 69kV

29

A.0005522.272 Artesia Country Club TAM Conve

30

A.0010002.002 NM - UG Extension Blanket

31

A.0010076.002 XTO Chistera PME Reconductor

32

A.0010076.003 CBAD/STRATA RECONDUCTORS/GNOME

33

A.0010076.004 CBAD/STRATA CONVERSION/GNOME P2

34

A.0010092.007 JAL/Serrano RP Site / 10Mi Recon

35

A.0010092.008 20180517_PEARL_4D25

36

A.0010092.009 JAL EO/Sage Brush 4520 / RoadRunner

37

A.0010124.004 Replace Navajo #3 Transformer 115/4

38

A.0000424.238 Install Roadrunner Substation

39

A.0005517.013 NM-Elec-Easement

40

A.0005522.211 Convert Curry Co. Interchange

41

A.0005522.218 Convert Livingston Ridge #1 69

42

A.0005584.005 SPS NM Targeted OH Rebuild - A

43

A.0006062.011 Distribution CIAC NM Elec

44

A.0010002.003 NM - OH New Services Blanket

Estimated Completion
Date

Estimated Cost of Project

Base Period Beginning Balance -
October 1, 2019

Expenditures Through End of Base Period

Closings Through End of Base Period

10/31/2020 $ 6,014,228 $

11/30/2020

667,511

5/31/2021

5,442,882

10/31/2020

5,303,701

12/15/2020

6,539,270

12/31/2020

2,070,189

4/30/2021

5,866,758

Closing Pattern

8,515,034

Closing Pattern

4,004,366

Closing Pattern

417,788

Closing Pattern 49,084,868

Closing Pattern 39,326,361

10/31/2020

569,266

10/31/2020

489,721

10/31/2020

(32,931)

10/31/2020

3,093,083

12/31/2020

909,476

12/31/2020

2,149,772

12/31/2020

57,955

12/31/2020

652,541

12/31/2020

784,613

10/31/2020

2,694,336

11/23/2019

70,320

12/18/2019

-

12/26/2019

2,766

9/30/2020

5,878,828

8/31/2020

864,136

1/30/2020

32,134

Closing Pattern

6,410,455

12/18/2019

-

3/27/2020

171,718

12/5/2019

24

6/26/2020

853,876

8/29/2020

1,014,152

6/19/2020

654,178

12/18/2019

79

4/30/2020

3,488,707

Routine Actual Closings

3,159,773

5/15/2018

16

11/20/2017

-

7/20/2018

7,503,000

4/16/2020

(2,841,507)

Closing Pattern

3,465,848

42,804 $ -
125,394 -
15,091 307,352 870,982 (949,978) 420,450
36,708 1,815,879 416,460 336,698 242,899 3,997,379 1,951,473 216,275 679,592 430,295 215,586 360,315 560,383 319,898 829,311 2,216 1 14,097

5,911,174 169,116 228,661
3,319,476 6,379,061
627,711 1,040,464 2,522,119
196,503 1,133,382 6,239,485 4,042,385
368,765 209,240 526,501 3,916,243 779,815 1,523,097 239,921 301,025 405,789 2,686,692 451,497 332,970 634,137 2,170,711 3,223,771 117,071 502,939 104,753 452,680 341,453 1,395,203 1,686,680 1,743,261
41,664 3,548,942 3,001,171 (201,742)
109,617 -
(448,452) 776,571

$

-

(37,432)

-

-

-

-

-

(2,346,337)

(255,287)

(1,891,452)

(5,532,085)

(4,342,465)

-

-

(393,546)

(2,073,069)

-

-

-

-

-

-

(2,267,376)

(749,430)

(970,836)

(2,413,610)

(7,221,150)

(2,068,544)

(730,907)

(784,344)

(882,975)

(557,040)

(1,755,518)

(2,247,063)

(2,063,160)

(870,974)

(3,551,158)

(3,001,171)

201,742

(109,617)

-

448,452

(770,954)

Schedule B-4 Page 1 of 34 Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Construction Work in Progress

(a) Base Period, (b) Test Year Period

Line

No.

Project No.

Project Description

1 Distribution - New Mexico

2

A.0000424.248 Install Medanos Substation

3

A.0000424.260 Install Medanos Fdr3

4

A.0000424.276 Install new Lynch 115/23kV 50 MVA X

5

A.0001214.009 Install feeders for New Malaga Sub

6

A.0001214.010 Install New Malaga Substation

7

A.0001408.003 SUBS Sisko

8

A.0001419.002 Install Millen #2 28 MVA XFR

9

A.0005507.090 NM - LED Street Light Conversi

10

A.0005521.200 NM - Subs Equipment Replace

11

A.0005584.002 NEW MEXICO MAJOR STORM RECOVERY

12

A.0010002.001 NM - OH Extension Blanket

13

A.0010018.001 NM - OH Rebuild Blanket

14

A.0010060.008 LVNG 7 24 27 CIMAREX N WHITE CITY

15

A.0010060.011 SOLARIS TROVE SWD SLACK SPAN

16

A.0010092.003 Install Loving South T2 Feeders

17

A.0010092.006 Install Ponderosa 3rd Fdr

18

A.0010092.011 JAL EO/SAGEBRUSH WEST EXT/NEW LINE

19

A.0010092.012 Jal/HWY 176 Sage Brush Pearl Extens

20

A.0010092.015 HBB EO/MESQ SWD BATTLE AXE BOWL

21

A.0010092.016 ART/550 E MAIN ST Navajo Soy-biodie

22

A.0010092.019 LOV/CND-HOPI/BOUNDS RD & JD FOREHAN

23

A.0010132.005 SPS 2020 New 28MVA Mobile for SENM

24

A.0000126.016 Artesia Country Club DCP Subs

25

A.0000424.240 Install roadrunner Fdr1

26

A.0000424.241 Install roadrunner Fdr2

27

A.0005508.147 SPS-NM Convert Obsolete Vltg

28

A.0005522.261 TAM: Convert South Loving 69kV

29

A.0005522.272 Artesia Country Club TAM Conve

30

A.0010002.002 NM - UG Extension Blanket

31

A.0010076.002 XTO Chistera PME Reconductor

32

A.0010076.003 CBAD/STRATA RECONDUCTORS/GNOME

33

A.0010076.004 CBAD/STRATA CONVERSION/GNOME P2

34

A.0010092.007 JAL/Serrano RP Site / 10Mi Recon

35

A.0010092.008 20180517_PEARL_4D25

36

A.0010092.009 JAL EO/Sage Brush 4520 / RoadRunner

37

A.0010124.004 Replace Navajo #3 Transformer 115/4

38

A.0000424.238 Install Roadrunner Substation

39

A.0005517.013 NM-Elec-Easement

40

A.0005522.211 Convert Curry Co. Interchange

41

A.0005522.218 Convert Livingston Ridge #1 69

42

A.0005584.005 SPS NM Targeted OH Rebuild - A

43

A.0006062.011 Distribution CIAC NM Elec

44

A.0010002.003 NM - OH New Services Blanket

Base Period Ending Balance September 30, 2020

Expenditures During Period Oct 2020 - Feb 2021

Closings During Period Oct 2020 - Feb 2021

Ending Balance Feb 2021 (1)

$

5,953,978 $

253,748 $

(6,207,726) $

-

131,684

472,178

(603,862)

-

228,661

3,039,261

-

3,267,922

3,319,476

1,849,032

(5,168,508)

-

6,504,455

347,851

(6,852,306)

-

627,711

1,428,832

(2,056,542)

-

1,040,464

3,259,232

-

4,299,696

190,873

1,280,000

(1,425,717)

45,156

248,568

167,031

(196,677)

218,922

112,911

-

(99,810)

13,101

(242,579)

2,325,000

(1,751,730)

330,691

120,370

1,990,930

(1,802,556)

308,745

368,765

201,246

(570,011)

-

209,240

260,902

(470,142)

-

169,663

(46,661)

(123,002)

-

1,843,174

136,816

(1,979,991)

-

779,815

596,111

(1,375,926)

-

1,523,097

541,975

(2,065,073)

-

239,921

(125,885)

(114,036)

-

301,025

315,904

(616,929)

-

405,789

336,380

(742,169)

-

2,686,692

7,640

(2,694,331)

-

-

-

-

-

-

-

-

-

-

-

-

-

-

348,504

(256,653)

91,851

-

-

-

-

-

-

-

-

(11,693)

308,190

(221,949)

74,548

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

777,600

(582,897)

194,703

-

-

-

-

-

-

-

-

1

73,538

(43,054)

30,486

-

(425,000)

425,000

-

19,714

251,960

(208,965)

62,709

Schedule B-4 Page 2 of 34 Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Construction Work in Progress

(a) Base Period, (b) Test Year Period

Line

No.

Project No.

Project Description

45

A.0010002.004 NM - UG New Services Blanket

46

A.0010002.005 NM - OH New Street Light Blanket

47

A.0010010.001 NM - OH Relocation Blanket

48

A.0010018.002 NM - UG Conversion/Rebuild Blanket

49

A.0010018.003 NM - OH Services Renewal Blanket

50

A.0010018.004 NM - UG Services Renewal Blanket

51

A.0010018.005 NM - OH Street Light Rebuild Blanke

52

A.0010018.006 NM - UG Street Light Rebuild Blanke

53

A.0010018.007 NM - Pole Blanket

54

A.0010034.001 NM - OH Reinforcement Blanket

55

D.0005014.011 NM Electric Distribution Transforme

56

D.0005014.030 NM-Electric Meter Blanket

57

A.0010076.006 CBAD/LIVING RIDGE 4A055I RECONS

58

A.0010092.010 JAL/SAGEBRUSH 4515/BELL LAKE NORTH

59

A.0010092.013 Reconductor Carldsbad Feeders

60

A.0010092.014 Hobbs/Snyder #1 Fenway Reconduct

61

A.0001408.002 Purchase Land @ Sisko

62

A.0001408.004 FDRS Sisko

63

A.0010076.007 EUNICE/DODGER FIELD/EXT

64

A.0010092.020 HOBBS /BATX 3470/ RCND 556 - PIPELI

65 Subtotal Distribution - New Mexico

66 Distribution - Texas

67

A.0001022.006 Whitedeer Install new 115/13.2 Subs

68

A.0001163.005 Install Hunsley Substation

69

A.0001163.006 Install Hunsley Substation Feeders

70

A.0005507.089 SPS - TX LED Street Lighting C

71

A.0005521.004 Tx N-Dist Substation Equip Rep

72

A.0005521.085 Feeder breaker degradation - S

73

A.0005521.176 Texas Sub Retirements

74

A.0005583.001 TEXAS MAJOR STORM RECOVERY

75

A.0010001.001 TX - OH Extension Blanket

76

A.0010017.001 TX - OH Rebuild Blanket

77

A.0010017.007 TX - Pole Blanket

78

A.0010067.002 Dumas - TXDOT HWY 287 Lighting Relo

79

A.0010075.001 Rebuild Z18 Dist Line - underbuild

80

A.0010123.011 Replace Existing Lariat XFR

81

A.0010123.013 SPS Used Mobile Transfer Purchase

82

A.0001024.004 Install Hillside #2 115/13.2kV - Fd

83

A.0005521.152 Plant X Distribution Relay Equ

84

A.0005522.233 Convert Springlake - 115/12.5k

85

A.0005583.002 TEXAS POLE INSPECTIONS

86

A.0005583.005 TX Mixed Work Adjustment

87

A.0010009.001 TX - OH Relocation Blanket

Estimated Completion
Date Closing Pattern Closing Pattern Closing Pattern Closing Pattern Closing Pattern Closing Pattern Closing Pattern Closing Pattern Closing Pattern Closing Pattern Routine Actual Closings Routine Actual Closings
7/31/2020 8/28/2020 7/24/2020 3/12/2020 8/31/2020 7/31/2020 8/28/2020 9/30/2020

Estimated Cost of Project 3,059,658 464,263 1,966,943 2,235,830 1,503,984 533,895 2,961,731 599,353 31,188,767 2,418,561 20,765,504 3,619,983 1,198,436 513,892 3,576,903 203,326 1,103,944 2,086,077 764,308 649,692

Base Period Beginning Balance -
October 1, 2019

6,284 -
7,711 420

5,483 19,088 12,808
8,802 44,027 42,863
-

$

13,405,047

Expenditures Through End of Base Period
715,199 46,677
384,645 187,823 237,435 171,537 254,345
79,401 1,971,290
635,678 3,360,469
301,915 1,663,583
659,993 4,338,356
683,295 1,103,944
776,350 702,656 617,114
$ 81,643,229

Closings Through End of Base Period
(701,981) (54,115)
(330,221) (127,719) (234,237) (186,601) (261,434)
(84,834) (1,926,459)
(604,320) (3,360,469)
(301,915) (1,663,583)
(659,993) (4,338,356)
(683,295) (1,103,944)
(776,350) (702,656) (617,114)
$ (67,956,904)

10/31/2020 $ 3,366,232 $

12/31/2020

5,773,952

10/31/2020

196,623

Closing Pattern 16,536,168

Closing Pattern 12,200,940

Closing Pattern

5,807,463

Closing Pattern

4

Closing Pattern

779,544

Closing Pattern 29,516,254

Closing Pattern 65,532,593

Closing Pattern 79,392,499

10/31/2020

26,222

10/31/2021

1,382,653

11/30/2020

428,537

9/30/2020

2,084,307

6/26/2020

37,139

12/13/2019

12,729

7/13/2020

(167,069)

12/18/2017

-

Closing Pattern

-

Closing Pattern

9,698,119

324,076 $ 3,450,815 $

-

52,972

5,289,306

-

-

178,030

-

43,655

4,203,044

(4,042,307)

737,285

1,200,397

(1,445,225)

419,497

1,294,503

(1,199,842)

38,992

499,865

-

305,330

992,391

(715,396)

138,039

3,620,660

(3,594,637)

254,042

8,712,691

(7,827,194)

390,578

16,686,099

(15,873,786)

278,551

208,487

-

-

134,110

-

-

381,506

-

-

2,021,941

-

947,798

457,031

(1,404,829)

1,296,226

(738,227)

(557,999)

185,495

(167,069)

(18,427)

(1,475,075)

1,475,126

(51)

114,171

(14,210)

(97,680)

1,029,977

369,339

(1,370,835)

Schedule B-4 Page 3 of 34 Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Construction Work in Progress

(a) Base Period, (b) Test Year Period

Line

No.

Project No.

Project Description

45

A.0010002.004 NM - UG New Services Blanket

46

A.0010002.005 NM - OH New Street Light Blanket

47

A.0010010.001 NM - OH Relocation Blanket

48

A.0010018.002 NM - UG Conversion/Rebuild Blanket

49

A.0010018.003 NM - OH Services Renewal Blanket

50

A.0010018.004 NM - UG Services Renewal Blanket

51

A.0010018.005 NM - OH Street Light Rebuild Blanke

52

A.0010018.006 NM - UG Street Light Rebuild Blanke

53

A.0010018.007 NM - Pole Blanket

54

A.0010034.001 NM - OH Reinforcement Blanket

55

D.0005014.011 NM Electric Distribution Transforme

56

D.0005014.030 NM-Electric Meter Blanket

57

A.0010076.006 CBAD/LIVING RIDGE 4A055I RECONS

58

A.0010092.010 JAL/SAGEBRUSH 4515/BELL LAKE NORTH

59

A.0010092.013 Reconductor Carldsbad Feeders

60

A.0010092.014 Hobbs/Snyder #1 Fenway Reconduct

61

A.0001408.002 Purchase Land @ Sisko

62

A.0001408.004 FDRS Sisko

63

A.0010076.007 EUNICE/DODGER FIELD/EXT

64

A.0010092.020 HOBBS /BATX 3470/ RCND 556 - PIPELI

65 Subtotal Distribution - New Mexico

66 Distribution - Texas

67

A.0001022.006 Whitedeer Install new 115/13.2 Subs

68

A.0001163.005 Install Hunsley Substation

69

A.0001163.006 Install Hunsley Substation Feeders

70

A.0005507.089 SPS - TX LED Street Lighting C

71

A.0005521.004 Tx N-Dist Substation Equip Rep

72

A.0005521.085 Feeder breaker degradation - S

73

A.0005521.176 Texas Sub Retirements

74

A.0005583.001 TEXAS MAJOR STORM RECOVERY

75

A.0010001.001 TX - OH Extension Blanket

76

A.0010017.001 TX - OH Rebuild Blanket

77

A.0010017.007 TX - Pole Blanket

78

A.0010067.002 Dumas - TXDOT HWY 287 Lighting Relo

79

A.0010075.001 Rebuild Z18 Dist Line - underbuild

80

A.0010123.011 Replace Existing Lariat XFR

81

A.0010123.013 SPS Used Mobile Transfer Purchase

82

A.0001024.004 Install Hillside #2 115/13.2kV - Fd

83

A.0005521.152 Plant X Distribution Relay Equ

84

A.0005522.233 Convert Springlake - 115/12.5k

85

A.0005583.002 TEXAS POLE INSPECTIONS

86

A.0005583.005 TX Mixed Work Adjustment

87

A.0010009.001 TX - OH Relocation Blanket

Base Period Ending Balance September 30, 2020

19,501 (7,438) 62,135 60,525

8,681 4,024 5,720 3,369 88,858 74,221
-

$

27,091,372

Expenditures During Period Oct 2020 - Feb 2021

203,400 40,440
115,500 70,535

85,624 38,178 151,114 17,730 822,562 166,181 1,287,386 165,391
534,706 -

$

23,671,063

Closings During Period Oct 2020 - Feb 2021

(183,748) (28,416)
(164,002) (106,202)

(70,545) (34,897) (138,445) (19,314) (722,240) (240,402) (1,287,386) (165,391)
-

$

(40,966,551)

Ending Balance Feb 2021 (1) 39,154 4,586 13,633 24,857 23,760 7,304 18,389 1,785 189,180 534,706 -

$

9,795,883

$

3,774,891 $

59,570 $

(3,834,462) $

-

5,342,278

663,802

(6,006,080)

-

178,030

19,318

(197,349)

-

204,392

1,692,000

(1,818,392)

78,000

492,457

621,537

(510,458)

603,535

514,157

320,704

(314,039)

520,822

538,857

-

(538,857)

-

582,325

-

(514,758)

67,567

164,062

1,395,000

(1,354,934)

204,128

1,139,538

3,082,838

(3,706,276)

516,100

1,202,890

4,469,870

(5,063,008)

609,752

487,038

1,295

(488,333)

-

134,110

745,998

-

880,107

381,506

5,848

(387,354)

-

2,021,941

-

(2,021,941)

-

-

-

-

-

-

-

-

-

-

-

-

-

(0)

-

-

(0)

2,281

-

(2,281)

0

28,482

239,000

(209,059)

58,423

Schedule B-4 Page 4 of 34 Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Construction Work in Progress

(a) Base Period, (b) Test Year Period

Line

No.

Project No.

Project Description

88

A.0010017.002 TX - UG Conversion/Rebuild Blanket

89

A.0010123.006 Replace Plainview South XFMR

90

A.0010138.002 Install Western Street Sub

91

A.0005508.153 SPS-TX Convert Obsolete Vltg D

92

A.0005583.003 SPS-TX CAPITALIZED ELECTRIC LOCATES

93

A.0006062.010 Distribution CIAC TX Elec

94

A.0010001.002 TX - UG Extension Blanket

95

A.0010001.003 TX - OH New Services Blanket

96

A.0010001.004 TX - UG New Services Blanket

97

A.0010001.006 TX - UG New Street Light Blanket

98

A.0010017.003 TX - OH Services Renewal Blanket

99

A.0010017.005 TX - OH Street Light Rebuild Blanke

100

A.0010017.006 TX - UG Street Light Rebuild Blanke

101

A.0010025.002 TX ? FPIP/REMS Blanket

102

A.0010033.001 TX - OH Reinforcement Blanket

103

A.0010033.002 TX - UG Reinforcement Blanket

104

A.0010123.002 Repl Failed Kite Transfrmr 69/13.2

105

A.0010123.005 Purc 28mva mobile XFER Delta Star

106

D.0005014.009 TX Electric Distribution Transforme

107

D.0005014.028 TX-Electric Meter Blanket

108

A.0010123.009 TX Sub Breaker TAM

109

A.0010156.002 Install Preston West Substation

110

A.0001022.005 Whitedeer Install new 115/13.2

111

A.0001362.002 Install Callahan Substation

112

A.0001388.002 SUB Install Hereford NE T3

113

A.0001418.003 Install Four Way Substation

114

A.0001418.006 Four Way Substation Siting and Lan

115

A.0010067.003 PLV/24TH,QUINCY-COLUMBIA/24TH ST RE

116

A.0010138.003 Install Western Street Feeders

117 Subtotal - Distribution - Texas

118 General

119

A.0000424.249 Install Medanos Subs COMM

120

A.0000545.007 Communication Eq

121

A.0000556.018 Plant X 230kV DFR

122

A.0000588.016 Plant X 230kV RTU Rplmnt

123

A.0000588.024 Gray County RTU Rplmnt

124

A.0000795.003 SPS Sub Comm Network Group 1 C

125

A.0001022.004 Comm Equip @ Whitedeer Sub

126

A.0001151.003 Sundown Transformer Upgr Comm

127

A.0001163.007 Install Hunsley Substation COMM

128

A.0001167.108 Hockley Co SPE Comm

129

A.0001189.006 OPIE Phantom Sub COMM

130

A.0001214.011 Install COMMs for New Malaga Sub

Estimated Completion
Date Closing Pattern
11/26/2019 6/30/2020 9/30/2020 4/23/2020
Closing Pattern Closing Pattern Closing Pattern Closing Pattern Closing Pattern Closing Pattern Closing Pattern Closing Pattern Closing Pattern Closing Pattern Closing Pattern
5/22/2018 6/26/2019 4/16/2020 4/17/2020 12/31/2019 12/1/2022 11/20/2021 12/1/2023 12/31/2022 3/31/2022 1/31/2021 7/31/2020 7/31/2020

Estimated Cost of Project 5,144,603 16 4,469,551 11,087,088 738,723 (3,556,266) 16,578,565 2,982,279 5,720,712 5,176 2,231,934 9,996,155 756,717 2,724,840 3,100,391 275,601 391,805 60,664,765 12,242,775 103,593 3,077,794 887,172 3,246,829 3,064,216 3,050,139 181,552 484,057 283,731

Base Period Beginning Balance -
October 1, 2019

111,352 587,869 403,610
69,910

29,245 35,952 14,176 29,571 31,852 10,840 39,282
86,092 (839) -

395 -

$

6,530,915

Expenditures Through End of Base Period
482,228 (36,763) 5,058,275 460,355 28,440 (13,189) 2,707,131 489,514 1,012,272 (235,552) 360,017 116,664 140,641 106,020 202,064 108,444 450,180 282,530 7,683,797 2,073,187 144,653
8 70,272
588 23,521 26,113 13,252 429,723 283,731
$ 72,723,950

Closings Through End of Base Period
(572,584) (551,106) (5,461,885) (530,265)
(28,440) (29,267) (2,763,798) (472,835) (997,659) 205,808 (329,936) (134,028) (140,602) (92,469) (269,707) (102,354) (450,180) (282,530) (7,683,797) (2,073,187) (144,931)
(429,723) (283,731)
$ (61,767,414)

10/31/2020 $ 137,691 $

12/18/2020

61,337

10/30/2020

400,611

10/30/2020

495,107

11/15/2020

294,947

Closing Pattern

557,840

11/15/2020

116,110

12/15/2020

115,596

12/31/2020

470,368

12/18/2020

603,207

10/2/2020

192,621

12/1/2020

140,786

1,418 $ 124,888
21,955 -
628,338 17,664 19,101 351 7,150

133,278 $ 38,362
367,506 378,159 149,860 584,755 144,198 105,615 449,283 280,103 186,927 142,007

(770,999) -

Schedule B-4 Page 5 of 34 Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Construction Work in Progress

(a) Base Period, (b) Test Year Period

Line

No.

Project No.

Project Description

88

A.0010017.002 TX - UG Conversion/Rebuild Blanket

89

A.0010123.006 Replace Plainview South XFMR

90

A.0010138.002 Install Western Street Sub

91

A.0005508.153 SPS-TX Convert Obsolete Vltg D

92

A.0005583.003 SPS-TX CAPITALIZED ELECTRIC LOCATES

93

A.0006062.010 Distribution CIAC TX Elec

94

A.0010001.002 TX - UG Extension Blanket

95

A.0010001.003 TX - OH New Services Blanket

96

A.0010001.004 TX - UG New Services Blanket

97

A.0010001.006 TX - UG New Street Light Blanket

98

A.0010017.003 TX - OH Services Renewal Blanket

99

A.0010017.005 TX - OH Street Light Rebuild Blanke

100

A.0010017.006 TX - UG Street Light Rebuild Blanke

101

A.0010025.002 TX ? FPIP/REMS Blanket

102

A.0010033.001 TX - OH Reinforcement Blanket

103

A.0010033.002 TX - UG Reinforcement Blanket

104

A.0010123.002 Repl Failed Kite Transfrmr 69/13.2

105

A.0010123.005 Purc 28mva mobile XFER Delta Star

106

D.0005014.009 TX Electric Distribution Transforme

107

D.0005014.028 TX-Electric Meter Blanket

108

A.0010123.009 TX Sub Breaker TAM

109

A.0010156.002 Install Preston West Substation

110

A.0001022.005 Whitedeer Install new 115/13.2

111

A.0001362.002 Install Callahan Substation

112

A.0001388.002 SUB Install Hereford NE T3

113

A.0001418.003 Install Four Way Substation

114

A.0001418.006 Four Way Substation Siting and Lan

115

A.0010067.003 PLV/24TH,QUINCY-COLUMBIA/24TH ST RE

116

A.0010138.003 Install Western Street Feeders

117 Subtotal - Distribution - Texas

118 General

119

A.0000424.249 Install Medanos Subs COMM

120

A.0000545.007 Communication Eq

121

A.0000556.018 Plant X 230kV DFR

122

A.0000588.016 Plant X 230kV RTU Rplmnt

123

A.0000588.024 Gray County RTU Rplmnt

124

A.0000795.003 SPS Sub Comm Network Group 1 C

125

A.0001022.004 Comm Equip @ Whitedeer Sub

126

A.0001151.003 Sundown Transformer Upgr Comm

127

A.0001163.007 Install Hunsley Substation COMM

128

A.0001167.108 Hockley Co SPE Comm

129

A.0001189.006 OPIE Phantom Sub COMM

130

A.0001214.011 Install COMMs for New Malaga Sub

Base Period Ending Balance September 30, 2020

20,996 -

(13,211) (20,714) 30,856 44,183
2,108 40,921 21,919
39 13,551 18,448
5,250 -
(278)

403 70,272
588 23,521 26,113 13,252
-

$

17,487,452

Expenditures During Period Oct 2020 - Feb 2021
239,842 -
204,944 41,340
(510,000) 1,055,040
204,400 359,400
14,960 152,818 351,648
25,680 86,240 130,141 41,341
3,858,984 802,714 99,433 39,458 31,830 130,336 25,104 168,300 -

$

20,870,733

Closings During Period Oct 2020 - Feb 2021
(203,407) -
(141,291) (29,711) 523,211
(812,160) (181,400) (330,661)
(16,105) (153,847) (312,185)
(23,525) (99,791) (148,589) (46,591)
(3,858,984) (802,714) 278 (181,552) -

$

(33,786,605)

Ending Balance Feb 2021 (1) 57,431 63,653 11,629 222,165 53,855 72,922 963 39,893 61,382 2,193 (0) 99,836 109,730 32,418 153,857 51,217 -

$

4,571,579

$

134,696 $

10,311 $

(145,007) $

-

163,250

48,588

(211,838)

-

389,461

47,597

(437,059)

-

378,159

56,880

(435,038)

-

149,860

127,026

(276,886)

-

442,093

157,064

(599,157)

-

161,862

2,291

(164,153)

-

124,716

13,346

(138,062)

-

449,283

20,995

(470,278)

-

280,103

297,366

(577,468)

-

187,278

10,511

(197,789)

-

149,157

14,513

(163,670)

-

Schedule B-4 Page 6 of 34 Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Construction Work in Progress

(a) Base Period, (b) Test Year Period

Line

No.

Project No.

Project Description

131

A.0001563.007 ITC-Bus Sys Purch Sagamore Net Equi

132

A.0003000.689 GMS0C-TX Lab Instruments

133

A.0006056.213 TX-DIST Fleet New Unit Purchases

134

A.0006056.224 Fleet New Unit El Trans TX

135

D.0001723.007 ADMS SW SPS

136

D.0001723.041 ADMS-BS-Lubbock-Workstation

137

D.0001781.041 Security Projects - Electric -

138

D.0001781.042 Security Projects - Electric -

139

D.0001813.023 Amarillo Ops Center Renovation

140

D.0001813.183 Plainview Renovation

141

D.0001821.539 Purch EMS Mapboard Comm Eq AOC SPS

142

D.0001821.540 Purch EMS Mapboard Furniture AOC SP

143

D.0001821.541 Purch EMS Mapboard Building AOC SPS

144

D.0002014.012 ITC-Purch WAN Circuit HW TX

145

D.0002014.014 ITC - WAN Routine HW SPS

146

D.0002015.002 Purch-Satellite Network HW SPS

147

D.0002015.003 Purch Satellite HW NM SPS

148

D.0002021.004 Purch Facility IT Investments HW SP

149

D.0002038.007 DEMS Ph4 HW SPS-10756

150

D.0002038.012 ITC-Purch DEMS HW SPS

151

D.0002106.007 ITC-VoIP Refresh-HW SPS

152

D.0002210.004 BUD-ITC-Purch 2020 IT INFS Ref HW S

153

D.0002210.009 ITC-IT INFS Ref Valkyrie HW SPS

154

D.0002211.008 ITC-Purch 2020 Planned PC HW SPS

155

D.0002211.017 ITC-Purch 2020 Plan PC Pandemic SP

156

D.0002278.002 ITC - SPS Purch Quantar Repeat Rpl

157

D.0002283.004 ITC - Avaya Ref Cloud Deployment SP

158

D.0002354.004 ITC-PC Refreshes-Routine HW-SPS

159

A.0000290.002 Eddy Co Intg, 230kV Dbl Bkr Dbl Bus

160

A.0000673.032 Yoakum 345kV Sub Comms_UID 504

161

A.0000842.001 Plant X BFR RTU

162

A.0000974.011 Optima Comm

163

A.0001118.006 Lock and Key System TX

164

A.0001273.014 Coulter RTU Replacement

165

A.0005014.101 Office Furn & Equipment - Electric

166

A.0005549.009 SPS-Dist Sub Communication Equ

167

A.0006056.214 NM-DIST Fleet New Unit Purchase El

168

A.0006059.006 TX-Dist Electric Tools and Equip

169

A.0006059.007 NM-Dist Electric Tools and Equip

170

A.0006059.168 SPS Transmission Tool Blanket

171

A.0006059.488 Tools & Equipment - Electric - TX

172

A.0010100.004 Convert South Loving COMM

173

D.0001822.058 Purch Sub Frame BAU Sites NM SPS

174

D.0001839.371 Purch SPS Quantar Repeater HW

175

D.0001840.114 Purch Sec Camera HW TX

Estimated Completion
Date 12/31/2020
Closing Pattern Closing Pattern Closing Pattern
12/31/2021 12/31/2021 Closing Pattern Closing Pattern
1/31/2021 12/31/2021
5/31/2021 5/31/2021 5/31/2021 Closing Pattern Closing Pattern 11/30/2020 12/30/2020 Closing Pattern 9/30/2022 9/30/2022 12/20/2020 Closing Pattern 3/31/2021 12/31/2020 12/31/2020 12/30/2020 6/15/2021 Closing Pattern 5/12/2020 7/31/2020 2/25/2020 7/23/2020 Closing Pattern 10/29/2019 Closing Pattern Closing Pattern Closing Pattern Closing Pattern Closing Pattern 4/30/2020 Routine Actual Closings 12/27/2019 1/27/2020 12/26/2019 4/30/2020

Estimated Cost of Project 352,909 404,550 34,003,009 17,384,625 4,868,941 679,918 15,027,329 28,826 4,869,362 331,059 30,737 8,918 2,126,001 23,917,703 44,031 47,462 5,685,187 8,125,697 8,188,428 696,317 651,536 399,496 756,038 398,556 839,533 138,050 14,292,153 (212,748) 4,411 102,716 (132,738) 1,359,034 14,294 747,173 1,421,084 10,309,046 11,193,461 3,477,305 208,327 3,264 129,947 20,995

Base Period Beginning Balance -
October 1, 2019 6,541
186,282 222,313
20,340 8,446,188
4,541 103,536
21,241 2,492,262
860,828 232,464 249,766 1,018,814
489,585 397,971 176,976 704,981 114,705
161,148 309,517 436,230 132,738 145,284 272,244 152,887 154,447 166,463 729,380 553,246 107,957 216,672 149,431 167,463 6,633,436 143,939

Expenditures Through End of Base Period
326,296 (50,131) 4,592,398 1,275,905 2,582,196 325,654 363,927 151,196 4,594,166 338,707
3,630,415 1,066,786 122,592 158,214 848,055 2,166,819 3,506,117 145,317 410,536 336,496 755,038 397,556 160,833 129,050 553,840 (161,148) 26,742 213,170 (132,738) 1,317,181 59,772 737,319 (23,009) 1,247,818 1,488,816 326,601 50,080 3,276,343 223,398

Closings Through End of Base Period
(3,533,401) (1,103,388) (23,058) (3,743,287) (466,979) (294,919) (189,624) (371,109) (336,259) (649,400) (1,418,859) (332,015) (814,901) (130,684) (1,407,908) (2,219,717) (879,281) (107,957) (216,672) (199,511) (167,463) (9,913,096) (367,337)

Schedule B-4 Page 7 of 34 Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Construction Work in Progress

(a) Base Period, (b) Test Year Period

Line

No.

Project No.

Project Description

131

A.0001563.007 ITC-Bus Sys Purch Sagamore Net Equi

132

A.0003000.689 GMS0C-TX Lab Instruments

133

A.0006056.213 TX-DIST Fleet New Unit Purchases

134

A.0006056.224 Fleet New Unit El Trans TX

135

D.0001723.007 ADMS SW SPS

136

D.0001723.041 ADMS-BS-Lubbock-Workstation

137

D.0001781.041 Security Projects - Electric -

138

D.0001781.042 Security Projects - Electric -

139

D.0001813.023 Amarillo Ops Center Renovation

140

D.0001813.183 Plainview Renovation

141

D.0001821.539 Purch EMS Mapboard Comm Eq AOC SPS

142

D.0001821.540 Purch EMS Mapboard Furniture AOC SP

143

D.0001821.541 Purch EMS Mapboard Building AOC SPS

144

D.0002014.012 ITC-Purch WAN Circuit HW TX

145

D.0002014.014 ITC - WAN Routine HW SPS

146

D.0002015.002 Purch-Satellite Network HW SPS

147

D.0002015.003 Purch Satellite HW NM SPS

148

D.0002021.004 Purch Facility IT Investments HW SP

149

D.0002038.007 DEMS Ph4 HW SPS-10756

150

D.0002038.012 ITC-Purch DEMS HW SPS

151

D.0002106.007 ITC-VoIP Refresh-HW SPS

152

D.0002210.004 BUD-ITC-Purch 2020 IT INFS Ref HW S

153

D.0002210.009 ITC-IT INFS Ref Valkyrie HW SPS

154

D.0002211.008 ITC-Purch 2020 Planned PC HW SPS

155

D.0002211.017 ITC-Purch 2020 Plan PC Pandemic SP

156

D.0002278.002 ITC - SPS Purch Quantar Repeat Rpl

157

D.0002283.004 ITC - Avaya Ref Cloud Deployment SP

158

D.0002354.004 ITC-PC Refreshes-Routine HW-SPS

159

A.0000290.002 Eddy Co Intg, 230kV Dbl Bkr Dbl Bus

160

A.0000673.032 Yoakum 345kV Sub Comms_UID 504

161

A.0000842.001 Plant X BFR RTU

162

A.0000974.011 Optima Comm

163

A.0001118.006 Lock and Key System TX

164

A.0001273.014 Coulter RTU Replacement

165

A.0005014.101 Office Furn & Equipment - Electric

166

A.0005549.009 SPS-Dist Sub Communication Equ

167

A.0006056.214 NM-DIST Fleet New Unit Purchase El

168

A.0006059.006 TX-Dist Electric Tools and Equip

169

A.0006059.007 NM-Dist Electric Tools and Equip

170

A.0006059.168 SPS Transmission Tool Blanket

171

A.0006059.488 Tools & Equipment - Electric - TX

172

A.0010100.004 Convert South Loving COMM

173

D.0001822.058 Purch Sub Frame BAU Sites NM SPS

174

D.0001839.371 Purch SPS Quantar Repeater HW

175

D.0001840.114 Purch Sec Camera HW TX

Base Period Ending Balance September 30, 2020
332,838 136,152 1,281,310 192,857 11,028,385 330,195 467,463 149,379 7,086,428 338,707 860,828 232,464 249,766 905,942 599,807 317,258 366,562 1,025,031 2,871,800 3,620,822 145,317 410,536 336,496 755,038 397,556 160,833 129,050 182,730
0 43,606 75,304 754 6,373 (1,521) 565 (3,317) -

Expenditures During Period Oct 2020 - Feb 2021
44,000 20,281 783,605 1,485,000 1,128,730 35,000 1,151,428
2,801,333
8,377 21,290
6,177
1,346,491
12,000 9,000
613,908 1,106,064 1,173,980
551,000 239,000
62,000 1,000 1,000
678,700 5,000
215,012 -
171,681 7
185,000 223,769
69,310 -
58,327 -

Closings During Period Oct 2020 - Feb 2021
(376,838) (156,433) (1,169,464) (1,677,857)
(689,783) (106,861) (9,887,760) (905,942) (1,034,564) (329,258) (375,562) (1,512,099) (696,317) (649,536) (756,038) (398,556) (839,533) (397,742) (215,287) (53,870) (723) (80,107) (193,684) (60,798) (40,177) 3,317 -

Ending Balance Feb 2021 (1) 895,451 12,157,115 365,195 929,107 42,518 347,084 882,119 232,464 255,943 911,734 126,840 3,977,864 4,794,802 398,496 134,050 0 21,434 39 111,266 28,564 9,078 18,150 (0) -

Schedule B-4 Page 8 of 34 Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Construction Work in Progress

(a) Base Period, (b) Test Year Period

Line

No.

Project No.

Project Description

176

D.0002014.001 Purch WAN HW SPS-BSPRJ0001170

177

D.0002014.002 Purch WAN HW NM

178

D.0002014.003 ITC-Purch WAN Generator TX

179

D.0002014.009 ITC-Purch WAN Generator NM

180

D.0002014.013 ITC-Purch WAN Circuit HW NM

181

D.0002018.004 Purch 10GBackhaul HW SPS-BSPRJ00011

182

D.0002194.004 ITC-Purch 2019 Plan Server HW SPS

183

A.0000126.011 Comm Equp @ Artesia Country Club

184

A.0000220.032 Taylor Switching Station RTU Comm N

185

A.0000290.009 Seven Rivers Upgr Eddy Term COMM

186

A.0000350.004 Lost Draw Comm

187

A.0000556.017 Jones #1 DFR

188

A.0000556.020 Tuco A&B DFR

189

A.0000710.007 NM Physical Security Comm

190

A.0000710.012 Nichols Physical Security Tx Comm

191

A.0000902.002 TUCO RTU Addition Comm

192

A.0001045.013 Tolk 230kV Sub COMM

193

A.0001061.003 Purnell 115kV Sub

194

A.0001118.007 Lock and Key System NM

195

A.0003000.668 HAR0C-Purch Plant Tools

196

A.0006056.223 Fleet New Units El Trans NM

197

A.0006056.227 GSMOC Purchase Vehicles

198

A.0006059.016 TX-Dist Subs Tools and Equip

199

A.0006059.063 SPS Sub Comm Tool Blanket

200

A.0006059.088 SPS Sys Protect Comm Eng Testing Eq

201

A.0006059.432 Tool Blanket TX Line

202

A.0010043.001 TX - Communication Equipment Blanke

203

A.0010138.004 Install Western Street Subs Comm

204

D.0002192.004 ITC-Purch 2019 ITINFS Ref HW SPS

205

D.0002193.004 ITC-Purch 2019 Plan PC HW SPS

206

D.0002193.008 ITC-Purch 2019 Printer SPS

207

D.0002203.008 ITC-Purch PTT Mobile HW SPS

208

A.0000556.022 Eddy County 115kV DFR NM

209

A.0006059.100 Tools Blanket TX Subs

210

D.0002014.010 ITC-Purch WAN Generator SC NM

211

D.0002192.017 ITC - Purch ITINFS Valkyrie HW SPS

212

A.0000424.278 Install new Lynch Sub Comms

213

A.0000588.021 Allen RTU Rplmnt

214

A.0000588.025 Industrial RTU Rplmnt

215

A.0000588.029 Owens Corning RTU Rplmnt

216

A.0000588.031 Eddy County RTU

217

A.0000588.033 Seven Rivers RTU Rplcmnt

218

A.0000795.017 Nichols, EAPL terminal COMM

219

A.0001044.009 Tierra Blanca 115kV Sub Comm

220

A.0001228.003 McDowell Creek Sub Comm

Estimated Completion
Date 4/23/2020 4/23/2020 4/30/2020 2/28/2020
12/29/2019 12/27/2019
7/1/2020 12/13/2019
1/30/2020 8/26/2019 10/18/2018 6/30/2020 7/31/2020 6/24/2019 10/10/2021 2/18/2019 5/15/2022 6/28/2019 Closing Pattern Closing Pattern Closing Pattern Closing Pattern Closing Pattern Closing Pattern Closing Pattern Closing Pattern Closing Pattern 5/13/2020 12/27/2019 4/29/2019 4/29/2019 12/27/2019 8/31/2020 4/30/2020 2/28/2020 3/31/2020 5/31/2021 4/15/2021 5/15/2021 12/15/2021 8/24/2020 8/24/2020 5/15/2021 11/15/2021 4/16/2022

Estimated Cost of Project (112,785) (63,639) 6,340 2,492 707,299 48,310 38,662 102,049 145,066 (111,373) (150,584) 243,664 319,407 600,671 541,583 (115,625) 748,599 845,009 1,847,658 375,941 5,886,741 3,972,219 5,091,107 2,106,008 100,120 460,120 319,353 204,089 1,060,743 1,587 100,039 3,951 304,324 19,227 518,724 434,718 739,907 560,592 589,458 554,773 114,623 228,263 462,942 359,796

Base Period Beginning Balance -
October 1, 2019 510,354 285,441 309,911 262,811 563,034
1,618,251 100,993 90,243 13,620 546 1,999 (5,716) 60,904 2,570 931 659 17,612 11,233 90,284 3,884 16,647 -

Expenditures Through End of Base Period
171,440 29,559
886,587 447,156 1,346,634 211,760
56,745 102,049 143,268 (112,313) (151,366) 273,019 330,059
4,642 1,160 (115,625) 22,869 845,034 560,858 52,233 109,791 162,705 120,889 380,111 113,807 262,717 64,821 272,591 (1,308,512) 189,356 111,836 394,175 304,721 250,919 160,027 4,152,825 11,660 53,898 41,969 25,571 554,773 114,623 57,802 75,378 2,007

Closings Through End of Base Period
(681,794) (315,000) (1,196,499) (709,967) (1,909,667) (1,830,011) (157,738) (102,049) (233,511) 112,313 151,366 (286,639) (330,059)
(4,642) -
115,625 -
(845,034) (531,727)
(65,093) (108,650) (100,085) (107,113) (397,452) (111,981) (262,746)
(283,824) 1,218,228 (189,356) (111,836) (398,059) (304,721) (250,919) (176,675) (4,152,825)
(554,773) (114,623) -

Schedule B-4 Page 9 of 34 Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Construction Work in Progress

(a) Base Period, (b) Test Year Period

Line

No.

Project No.

Project Description

176

D.0002014.001 Purch WAN HW SPS-BSPRJ0001170

177

D.0002014.002 Purch WAN HW NM

178

D.0002014.003 ITC-Purch WAN Generator TX

179

D.0002014.009 ITC-Purch WAN Generator NM

180

D.0002014.013 ITC-Purch WAN Circuit HW NM

181

D.0002018.004 Purch 10GBackhaul HW SPS-BSPRJ00011

182

D.0002194.004 ITC-Purch 2019 Plan Server HW SPS

183

A.0000126.011 Comm Equp @ Artesia Country Club

184

A.0000220.032 Taylor Switching Station RTU Comm N

185

A.0000290.009 Seven Rivers Upgr Eddy Term COMM

186

A.0000350.004 Lost Draw Comm

187

A.0000556.017 Jones #1 DFR

188

A.0000556.020 Tuco A&B DFR

189

A.0000710.007 NM Physical Security Comm

190

A.0000710.012 Nichols Physical Security Tx Comm

191

A.0000902.002 TUCO RTU Addition Comm

192

A.0001045.013 Tolk 230kV Sub COMM

193

A.0001061.003 Purnell 115kV Sub

194

A.0001118.007 Lock and Key System NM

195

A.0003000.668 HAR0C-Purch Plant Tools

196

A.0006056.223 Fleet New Units El Trans NM

197

A.0006056.227 GSMOC Purchase Vehicles

198

A.0006059.016 TX-Dist Subs Tools and Equip

199

A.0006059.063 SPS Sub Comm Tool Blanket

200

A.0006059.088 SPS Sys Protect Comm Eng Testing Eq

201

A.0006059.432 Tool Blanket TX Line

202

A.0010043.001 TX - Communication Equipment Blanke

203

A.0010138.004 Install Western Street Subs Comm

204

D.0002192.004 ITC-Purch 2019 ITINFS Ref HW SPS

205

D.0002193.004 ITC-Purch 2019 Plan PC HW SPS

206

D.0002193.008 ITC-Purch 2019 Printer SPS

207

D.0002203.008 ITC-Purch PTT Mobile HW SPS

208

A.0000556.022 Eddy County 115kV DFR NM

209

A.0006059.100 Tools Blanket TX Subs

210

D.0002014.010 ITC-Purch WAN Generator SC NM

211

D.0002192.017 ITC - Purch ITINFS Valkyrie HW SPS

212

A.0000424.278 Install new Lynch Sub Comms

213

A.0000588.021 Allen RTU Rplmnt

214

A.0000588.025 Industrial RTU Rplmnt

215

A.0000588.029 Owens Corning RTU Rplmnt

216

A.0000588.031 Eddy County RTU

217

A.0000588.033 Seven Rivers RTU Rplcmnt

218

A.0000795.017 Nichols, EAPL terminal COMM

219

A.0001044.009 Tierra Blanca 115kV Sub Comm

220

A.0001228.003 McDowell Creek Sub Comm

Base Period Ending Balance September 30, 2020
0 1,706 24,868 23,416 48,043 3,711 63,552 14,436 270 1,826 (29) 64,821 11,660 53,898 41,969 25,571 57,802 75,378 2,007

Expenditures During Period Oct 2020 - Feb 2021
23,250 600,671 43,263 15,746 1,288,000 25,100 227,000 321,000 69,300 152,162 35,168 80,190 9,075 4,650 220,346 352,672 127,764 28,907 98,703 120,146 17,643

Closings During Period Oct 2020 - Feb 2021
(0) (23,250) (600,671) (1,311,416) (73,143) (230,711) (384,552) (75,260) (98,266) (36,974) (80,141) (73,896) (4,650) -

Ending Balance Feb 2021 (1) 0 44,969 40,614 8,476 54,166 20 20 232,006 406,570 169,733 54,478 156,505 195,524 19,650

Schedule B-4 Page 10 of 34 Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Construction Work in Progress

(a) Base Period, (b) Test Year Period

Line

No.

Project No.

Project Description

221

A.0001419.006 Install Millen #2 Comms

222

D.0001810.096 Amarillo Tech Center Land Acquistio

223

D.0001810.097 Amarillo Tech Center Bldg Acquistio

224 Subtotal - General

225 Intangible

226

A.0001577.017 Hale PCMM

227

D.0001723.048 ADMS Data - SPS

228

D.0001771.017 Cert Key CIP SW SPS-10752

229

D.0001796.056 Net Tools Tel Wireless SW SPS-10761

230

D.0001804.344 Synchrophasor SW SPS-10655

231

D.0001804.358 CIP Substation Ph2 SW SPS -10659

232

D.0001825.092 Host Intrusion SW SPS-10684

233

D.0001839.297 Active Directory 2016 SW SPS-10737

234

D.0001901.011 AGIS Meter Data Mgmt (MDM) SW SPS

235

D.0001907.039 AGIS-SPS-Plan&Forecast Tool

236

D.0002008.018 Ent DataBase Security Ph4 SW SPS-10

237

D.0002020.022 ITC Operational Reporting SW SPS-20

238

D.0002037.025 CXT Cust Serv Console SW SPS-10786

239

D.0002041.004 eGRC Phase IV SOx Corp Com SW SPS-1

240

D.0002063.009 ITC-Meridium Upgrade-SW SPS

241

D.0002078.007 TWR SW SPS-10713

242

D.0002084.011 Software Asset Mgmt SW SPS-10729

243

D.0002098.017 CyberArk CIP SW SPS-10749

244

D.0002107.010 ITC-NMS 2.X Upgrade-SW-SPS

245

D.0002180.017 TAHA Data LIC SW SPS-10785

246

D.0002180.021 ITC-TAHA WS3-SW-SPS

247

D.0002186.006 CRS Tech Stack 2019 SW SPS-10746

248

D.0002187.006 Cyber Security Data SW SPS-10743

249

D.0002247.006 CXT-My Acct SW SPS-10778

250

D.0002248.006 CXT-XE COM SW SPS-10779

251

D.0002249.006 CXT-Mobile App PH1 SW SPS-10780

252

D.0002250.006 CXT-Cust API PH1 SW SPS-10781

253

D.0002251.006 CXT-Cust Data SW SPS-10782

254

D.0002253.006 CXT-CIAM SW SPS-10787

255

D.0002257.006 ITC-Data Discovery-SW SPS

256

D.0002259.006 XE1 Wave 5 - Distribution SW-10796

257

D.0002273.006 CEC-Builders Call SW SPS-10723

258

D.0002277.006 ITC - Crew Time Entry App SPS

259

D.0002283.012 ITC - Avaya Ref Cloud Depl SPS SW-1

260

D.0002284.004 ITC-Emptoris Replacement-SW SPS

261

D.0002285.004 ITC-General Counsel Doc Mgmt-SW SPS

262

D.0002286.012 ITC PI for Wind Farms OSI PI Lic SW

263

D.0002305.004 ITC-Primavera Upgrade-SW SPS

Estimated Completion
Date 4/30/2021 5/31/2020 5/29/2020

Estimated Cost of Project 690,261 2,007,640 6,059,770

Base Period Beginning Balance -
October 1, 2019 -

$

31,158,894

Expenditures Through End of Base Period
93,052 2,007,640 6,059,770
$ 60,445,071

Closings Through End of Base Period
(2,007,640) (6,059,770)
$ (52,952,774)

6/24/2021 $ 585,714 $

Closing Pattern

8,221,774

12/10/2021

33,698

10/15/2020

44,053

5/31/2021

153,082

6/30/2021

1,034,919

12/31/2020

82,145

12/31/2020

181,613

Closing Pattern

1,831,229

12/31/2020

1,045,334

11/30/2020

89,622

Closing Pattern

3,300,781

12/31/2022

2,613,109

12/20/2020

82,919

11/30/2020

488,179

6/30/2021

709,383

12/31/2020

110,796

12/31/2020

70,919

12/31/2021

767,510

3/20/2021

1,370,305

3/20/2021

468,755

11/20/2020

164,110

3/26/2021

115,173

12/31/2022

1,013,151

12/31/2022

901,123

12/31/2020

689,337

12/31/2022

2,271,564

12/31/2022

2,438,829

12/31/2022

776,335

10/30/2020

71,445

9/30/2020

21,527

12/31/2022

1,093,687

12/30/2022

534,306

6/15/2021

1,955,907

12/31/2020

379,036

10/20/2020

211,811

12/20/2021

339,466

3/31/2021

247,011

-$ 1,035,549
9,093 284,585 785,146 2,252,425 382,327 157,611
21,243 124 22,557 586,784 30,681 9,865 22,464 49,115 16,882 637,310 43,385 43,933 88,175 547,641 36,590 -

240,954 375,226 115,473
33,343 214,375 502,506 108,318 230,887 431,078 713,207 109,582 132,836 169,246
97,318 319,918 553,560 232,507
90,738 204,866 176,839 455,547 213,924 211,051 250,385 429,743 303,967 1,185,726 1,144,575 692,341 193,298 270,513 789,420 111,687 1,279,005 261,688 183,861 221,852 127,480

$

-

(1,078,669)

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Schedule B-4 Page 11 of 34 Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Construction Work in Progress

(a) Base Period, (b) Test Year Period

Line

No.

Project No.

Project Description

221

A.0001419.006 Install Millen #2 Comms

222

D.0001810.096 Amarillo Tech Center Land Acquistio

223

D.0001810.097 Amarillo Tech Center Bldg Acquistio

224 Subtotal - General

225 Intangible

226

A.0001577.017 Hale PCMM

227

D.0001723.048 ADMS Data - SPS

228

D.0001771.017 Cert Key CIP SW SPS-10752

229

D.0001796.056 Net Tools Tel Wireless SW SPS-10761

230

D.0001804.344 Synchrophasor SW SPS-10655

231

D.0001804.358 CIP Substation Ph2 SW SPS -10659

232

D.0001825.092 Host Intrusion SW SPS-10684

233

D.0001839.297 Active Directory 2016 SW SPS-10737

234

D.0001901.011 AGIS Meter Data Mgmt (MDM) SW SPS

235

D.0001907.039 AGIS-SPS-Plan&Forecast Tool

236

D.0002008.018 Ent DataBase Security Ph4 SW SPS-10

237

D.0002020.022 ITC Operational Reporting SW SPS-20

238

D.0002037.025 CXT Cust Serv Console SW SPS-10786

239

D.0002041.004 eGRC Phase IV SOx Corp Com SW SPS-1

240

D.0002063.009 ITC-Meridium Upgrade-SW SPS

241

D.0002078.007 TWR SW SPS-10713

242

D.0002084.011 Software Asset Mgmt SW SPS-10729

243

D.0002098.017 CyberArk CIP SW SPS-10749

244

D.0002107.010 ITC-NMS 2.X Upgrade-SW-SPS

245

D.0002180.017 TAHA Data LIC SW SPS-10785

246

D.0002180.021 ITC-TAHA WS3-SW-SPS

247

D.0002186.006 CRS Tech Stack 2019 SW SPS-10746

248

D.0002187.006 Cyber Security Data SW SPS-10743

249

D.0002247.006 CXT-My Acct SW SPS-10778

250

D.0002248.006 CXT-XE COM SW SPS-10779

251

D.0002249.006 CXT-Mobile App PH1 SW SPS-10780

252

D.0002250.006 CXT-Cust API PH1 SW SPS-10781

253

D.0002251.006 CXT-Cust Data SW SPS-10782

254

D.0002253.006 CXT-CIAM SW SPS-10787

255

D.0002257.006 ITC-Data Discovery-SW SPS

256

D.0002259.006 XE1 Wave 5 - Distribution SW-10796

257

D.0002273.006 CEC-Builders Call SW SPS-10723

258

D.0002277.006 ITC - Crew Time Entry App SPS

259

D.0002283.012 ITC - Avaya Ref Cloud Depl SPS SW-1

260

D.0002284.004 ITC-Emptoris Replacement-SW SPS

261

D.0002285.004 ITC-General Counsel Doc Mgmt-SW SPS

262

D.0002286.012 ITC PI for Wind Farms OSI PI Lic SW

263

D.0002305.004 ITC-Primavera Upgrade-SW SPS

Base Period Ending Balance September 30, 2020
93,052 -

$

38,651,191

Expenditures During Period Oct 2020 - Feb 2021
376,389 -

$

19,251,103

Closings During Period Oct 2020 - Feb 2021
-

$

(29,410,810)

Ending Balance Feb 2021 (1) 469,442 -

$

28,491,485

$

240,954 $

194,760 $

-$

435,714

332,106

4,434

(336,540)

-

124,566

3,081

-

127,647

317,928

17,373

(335,301)

-

999,520

24,721

-

1,024,241

2,754,931

341,862

-

3,096,792

490,645

20,466

(511,111)

-

388,498

15,290

(403,788)

-

431,078

477,813

(719,086)

189,805

713,207

295,679

(1,008,886)

-

130,825

13,508

(144,333)

-

132,836

165,842

(298,678)

-

169,370

381,182

-

550,552

119,875

2,105

(121,979)

-

319,918

168,261

(488,179)

-

1,140,344

113,206

-

1,253,550

263,188

29,963

(293,150)

-

100,602

29,144

(129,746)

-

204,866

177,332

-

382,198

199,303

726,991

-

926,294

455,547

11,942

-

467,488

263,039

26,227

(289,266)

-

227,933

45,745

-

273,677

887,695

189,824

-

1,077,519

473,128

179,570

-

652,698

347,899

171,044

(518,944)

-

1,273,902

331,090

-

1,604,992

1,692,216

523,684

-

2,215,900

728,931

106,402

-

835,333

193,298

14,542

(207,840)

-

270,513

-

(270,513)

-

789,420

272,990

-

1,062,410

111,687

116,660

-

228,347

1,279,005

416,457

-

1,695,463

261,688

117,348

(379,036)

-

183,861

27,950

(211,811)

-

221,852

105,875

-

327,727

127,480

77,199

-

204,678

Schedule B-4 Page 12 of 34 Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Construction Work in Progress

(a) Base Period, (b) Test Year Period

Line

No.

Project No.

Project Description

264

D.0002308.004 ITC-BUD Upgrade- SW SPS

265

D.0002310.004 ITC UI CREV RIS w PlnrDash SW SPS-2

266

D.0002312.004 ITC-SailPoint Phase 5-SW SPS

267

D.0002326.004 ITC Email Adv Threat Prot SW SPS-20

268

D.0002340.004 ITC Oracle Exadata Refresh SW SPS-2

269

D.0002344.004 ITC OT Monitoring 2020 SW SPS-20018

270

D.0002349.003 ITC-M&D Center thermal SW 200137 SP

271

D.0002365.008 ITC-Appication Performanc SW 200171

272

D.0002366.006 ITC-Service Now SW 200074 SPS

273

D.0002367.004 ITC-Kafka Data Streaming SW 200148

274

D.0002372.006 ITC-Oracle Java Licensing SW 200148

275

A.0005516.002 SPS Landworks - Convert docs to dig

276

D.0001728.007 Sub Asset Mgmt SW SPS

277

D.0001796.034 Net Tools CISCO SW SPS-10718

278

D.0001804.393 ESOM Ph2 SW SPS-10687

279

D.0001805.016 Next Gen MSFT Deploy SW SPS -10693

280

D.0001839.628 ESB Environment SW SPS-10646

281

D.0002001.020 Sailpoint Ph4 SW SPS-10760

282

D.0002020.004 SAP Cont Improve SolMan SW SPS-1070

283

D.0002037.004 CEC-Cust Service Console SW SPS-107

284

D.0002037.019 CEC-Builders Call SW SPS-10723

285

D.0002045.015 Operation Monitor SW SPS-10728

286

D.0002068.004 ITC-Powerplan Upgrade SW SPS-10768

287

D.0002081.011 VMCM SW SPS-10714

288

D.0002135.004 Unix Config SW SPS-10770

289

D.0002165.007 OT Monitor DRAGOS SW SPS-10772

290

D.0002184.004 IIB Lic ESB SW SPS-10742

291

D.0002185.006 Net Auto Platform SW SPS-10741

292

D.0002202.006 Multi Auth SW SPS-10759

293

D.0002244.001 ITC-PCI SPP Settlement SW SPS

294

D.0001787.009 Customer Mgmt SPS

295

D.0001787.014 SAP S&O SW Rel 19 SPS-10733

296

D.0002143.004 Technology Lic SW SPS

297

D.0001787.021 ITC-BS-WS 19 SW Releases - TX 10792

298

D.0002189.006 ITC-Virtual Emergency SW TX-10745

299

D.0002274.004 2019 Advertising & Brand Content Li

300

D.0002279.004 ITC - Upg Pro, Visio, & Adobe Pro S

301

D.0002282.004 ITC-Mainframe Modernization-SW SPS

302

D.0001805.020 ITC-Pandemic-Next Gen MSFT SW SPS

303

D.0002008.022 ITC EDS2-A2A SW SPS-200074

304

D.0002032.009 ITC-Cash Mngmt Sys Replcmnt-SW SPS

305

D.0002111.011 ITC-SubTran Portal App SW 200123 SP

306

D.0002113.009 ITC-Purchase Power Agrmnt-SW SPS

307

D.0002137.013 ITC-CRS Tech Stack SW 200171 SPS

308

D.0002223.009 ITC-Customer Care IVR Up SW 200162

Estimated Completion
Date 12/31/2021 3/31/2021 4/30/2021 12/30/2020 10/31/2021 12/11/2020 12/31/2020 12/31/2020 12/31/2021 12/31/2020 10/30/2020 6/30/2020 12/27/2019 11/23/2019 11/23/2019 12/27/2019 12/27/2019 12/27/2019 12/27/2019 12/20/2021 12/31/2020 12/27/2019 10/31/2019 11/23/2019 12/27/2019 11/27/2019 10/31/2019 1/31/2020 12/27/2019 2/28/2020 12/31/2018 9/30/2019 9/30/2019 12/27/2019 8/31/2020 7/21/2020 12/31/2019 3/31/2020 8/31/2020 11/30/2021 5/30/2021 12/31/2021 11/30/2021 7/20/2021 12/1/2021

Estimated Cost of Project 596,545 317,936 194,498 715,471 923,420 242,478 539,139 501,854 1,244,427 595,029 221,378 455,054 6,349 302 4,667 375,050 8,389 16,572 1,053 920 (16,145) 23,578 20,057 3,624 350 8,203 (32) (961,678) 24,297 195,353 28,611 131 128,187 84,208 3,079 112 (7,392) 299,633 218,996 238,941 959,465 1,143,703 1,070,012 1,314,276

Base Period Beginning Balance -
October 1, 2019 -
1,441,866 722,068 227,870 745,749
1,374,624 1,600,861
164,915 161,819 134,668 191,462 260,429 149,988 500,853 172,321 234,309 405,655 248,250 141,327 119,837
13,172 -

Expenditures Through End of Base Period
182,123 152,479 113,159 693,485 190,581 165,623 145,343 413,033 811,797 112,587 195,473 1,286,684
71,028 (4,328) 42,330 749,558 591,973 62,792 11,268 (121,084) (175,285) 54,940 60,017 80,836 35,494 29,576 18,985 95,342 85,479 338,782 (334,131) 383,270 259,083 430,310 153,862 115,499 438,048 262,392 270,539 14,381 46,394
99 45,209 68,856 19,786

Closings Through End of Base Period
(2,728,550) (793,095) (223,542) (788,078) (2,124,182) (2,192,834) (227,707) (173,087) (315,369) (210,004) (581,689) (207,815) (263,884) (424,640) (343,591) (226,806) (458,619) 334,131 (383,270) (259,083) (443,482) (153,862) (115,499) (438,048) (262,392) (270,539) -

Schedule B-4 Page 13 of 34 Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Construction Work in Progress

(a) Base Period, (b) Test Year Period

Line

No.

Project No.

Project Description

264

D.0002308.004 ITC-BUD Upgrade- SW SPS

265

D.0002310.004 ITC UI CREV RIS w PlnrDash SW SPS-2

266

D.0002312.004 ITC-SailPoint Phase 5-SW SPS

267

D.0002326.004 ITC Email Adv Threat Prot SW SPS-20

268

D.0002340.004 ITC Oracle Exadata Refresh SW SPS-2

269

D.0002344.004 ITC OT Monitoring 2020 SW SPS-20018

270

D.0002349.003 ITC-M&D Center thermal SW 200137 SP

271

D.0002365.008 ITC-Appication Performanc SW 200171

272

D.0002366.006 ITC-Service Now SW 200074 SPS

273

D.0002367.004 ITC-Kafka Data Streaming SW 200148

274

D.0002372.006 ITC-Oracle Java Licensing SW 200148

275

A.0005516.002 SPS Landworks - Convert docs to dig

276

D.0001728.007 Sub Asset Mgmt SW SPS

277

D.0001796.034 Net Tools CISCO SW SPS-10718

278

D.0001804.393 ESOM Ph2 SW SPS-10687

279

D.0001805.016 Next Gen MSFT Deploy SW SPS -10693

280

D.0001839.628 ESB Environment SW SPS-10646

281

D.0002001.020 Sailpoint Ph4 SW SPS-10760

282

D.0002020.004 SAP Cont Improve SolMan SW SPS-1070

283

D.0002037.004 CEC-Cust Service Console SW SPS-107

284

D.0002037.019 CEC-Builders Call SW SPS-10723

285

D.0002045.015 Operation Monitor SW SPS-10728

286

D.0002068.004 ITC-Powerplan Upgrade SW SPS-10768

287

D.0002081.011 VMCM SW SPS-10714

288

D.0002135.004 Unix Config SW SPS-10770

289

D.0002165.007 OT Monitor DRAGOS SW SPS-10772

290

D.0002184.004 IIB Lic ESB SW SPS-10742

291

D.0002185.006 Net Auto Platform SW SPS-10741

292

D.0002202.006 Multi Auth SW SPS-10759

293

D.0002244.001 ITC-PCI SPP Settlement SW SPS

294

D.0001787.009 Customer Mgmt SPS

295

D.0001787.014 SAP S&O SW Rel 19 SPS-10733

296

D.0002143.004 Technology Lic SW SPS

297

D.0001787.021 ITC-BS-WS 19 SW Releases - TX 10792

298

D.0002189.006 ITC-Virtual Emergency SW TX-10745

299

D.0002274.004 2019 Advertising & Brand Content Li

300

D.0002279.004 ITC - Upg Pro, Visio, & Adobe Pro S

301

D.0002282.004 ITC-Mainframe Modernization-SW SPS

302

D.0001805.020 ITC-Pandemic-Next Gen MSFT SW SPS

303

D.0002008.022 ITC EDS2-A2A SW SPS-200074

304

D.0002032.009 ITC-Cash Mngmt Sys Replcmnt-SW SPS

305

D.0002111.011 ITC-SubTran Portal App SW 200123 SP

306

D.0002113.009 ITC-Purchase Power Agrmnt-SW SPS

307

D.0002137.013 ITC-CRS Tech Stack SW 200171 SPS

308

D.0002223.009 ITC-Customer Care IVR Up SW 200162

Base Period Ending Balance September 30, 2020
182,123 152,479 113,159 693,485 190,581 165,623 145,343 413,033 811,797 112,587 195,473
13,584 16,177 14,381 46,394 99 45,209 68,856 19,786

Expenditures During Period Oct 2020 - Feb 2021
135,773 131,472
57,884 21,986 716,232 81,774 398,592 101,945 217,063 482,443 25,905
336 216 29,640 58,863 116,856 30,846 367,867 460,560 401,108

Closings During Period Oct 2020 - Feb 2021
(715,471) (247,397) (543,935) (514,977) (595,029) (221,378) (16,393) (29,640) -

Ending Balance Feb 2021 (1) 317,896 283,952 171,043 906,813 1,028,859 13,920 73,244 163,250 30,945 413,076 529,415 420,894

Schedule B-4 Page 14 of 34 Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Construction Work in Progress

(a) Base Period, (b) Test Year Period

Line

No.

Project No.

Project Description

309

D.0002240.009 ITC-Payroll_and_Benefits SW 200165

310

D.0002265.004 ITC - 2020 Oracle Licenses SW - TX

311

D.0002286.008 ITC PI for Wind Farms Smart Signl S

312

D.0002298.004 ITC-UAS Fleet Mngmt-SW-SPS

313

D.0002322.006 ITC-Outage Employee Experience SPS

314

D.0002329.006 ITC-Upgrade Corporate Fina SW 20009

315

D.0002333.004 ITC ISO Intrfc & Stlmt Rpl SW SPS-2

316

D.0002350.006 ITC-SAS BookRunner Upgra SW 200134

317

D.0002364.006 ITC-BS Resiliency SW 200074 SPS

318 Subtotal - Intangible

319 Production

320

A.0001529.068 MAD1C-Upg DCS Opr Stn-19969

321

A.0001529.084 MAD1C-Rpl #2 HP FWH

322

A.0001529.089 MAD1C-Rpl SH Term Tubes

323

A.0001529.500 MAD Emergent Fund -Steam prod

324

A.0001534.204 PLX0C-Floating pump w piping for pi

325

A.0001534.209 PLX3C Rpl East Waterwall Tubes

326

A.0001534.500 PLX Emergent Fund -Steam prod

327

A.0001545.085 CHC0C-Rpr Water Well Mtr 2019

328

A.0001545.110 CHC3C-Upg CEMs Foxboro Sys

329

A.0001545.130 CHC4C-Rpl Combustor Components -238

330

A.0001545.282 CHC34C CT Control Upgrade

331

A.0001550.500 HAR Emergent Fund -Steam prod

332

A.0001555.148 TOL0C-Rpl Water Treatment Bldg

333

A.0001555.224 TOL2C-Rpr MillF GearBx & Journ

334

A.0001555.258 TOL2C-Rbld T2 Mill B Gearbox

335

A.0001555.300 TOL2C-Prch & Install New GSU XFMR

336

A.0001555.415 TOL0C-Inst Secondary RO Feed Supply

337

A.0001555.421 TOL1C-Rpl TK02 oil circuit breaker

338

A.0001555.422 TOL1C-Rpl UPS Inverters

339

A.0001555.428 TOL2C-Rpl TK32 oil circuit breaker

340

A.0001555.429 TOL2C-Rpl UPS Inverters

341

A.0001555.500 TOL Emergent Fund -Steam prod

342

A.0001555.588 TOL0C- Install Gas Chromatograph

343

A.0001560.126 NIC0C-HW Rd. WW Trtment Improv

344

A.0001560.136 NIC1C-Rpl U1 Volt Reg

345

A.0001560.500 NIC Emergent Fund -Steam prod

346

A.0001563.001 SPS Wind - Sagamore

347

A.0001577.001 SPS Wind -Hale County

348

A.0001586.017 JON0C NOX Controls Enhancement

349

A.0001586.020 JON3C Jones 3&4 Hot Gas Path Replac

350

A.0001586.299 JON0C-Effluent Water Optimization

351

A.0001586.501 JON Emergent Fund -Other prod

Estimated Completion
Date 12/31/2022 3/31/2020 12/20/2021 12/31/2021 12/31/2021 8/30/2021 12/31/2022 6/30/2023 9/30/2020

Estimated Cost of Project 7,762,035 484,788 454,955 702,954 174,866 453,417 3,152,317 2,550,633 402,748

Base Period Beginning Balance -
October 1, 2019 -

$

16,075,525

Expenditures Through End of Base Period
19,807 487,413
4,593 50,821 89,375
7,948 39,691
3,581 400,386
$ 23,146,113

Closings Through End of Base Period
(487,413)
(400,386)
$ (16,242,005)

11/30/2020 $ 527,436 $

11/17/2020

768,293

10/8/2020

1,227,156

Closing Pattern

3,100,023

11/9/2020

718,277

3/1/2020

(693,150)

Closing Pattern

4,929,338

3/31/2020

45,614

7/2/2020

173,856

10/12/2020

2,642,374

12/21/2020

1,106,796

Closing Pattern 12,238,657

8/19/2020

409,955

6/30/2020

(60,227)

12/15/2020

759,969

12/1/2020

(63,447)

2/22/2021

265,914

10/8/2020

397,407

10/21/2020

328,518

10/8/2020

535,924

10/21/2020

277,175

Closing Pattern 12,460,566

8/1/2020

61,263

1/18/2022

8,379,985

9/9/2020

271,737

Closing Pattern

5,783,572

12/4/2020 572,078,972

6/28/2019

473,865

11/30/2020

1,686,671

11/30/2020

12,298,573

12/7/2020

4,283,490

Closing Pattern

1,083,088

4,764
37,157
194,537 2,372,625
11,915 -
18,246 -
205,939 -
2,861,614 -
714,939 49,936
1,323,561 -
264,079 159,430,819
135,656 -

$

348,936

559,808

513,423

139,631

559,185

632,979

1,654,044

122,250

169,678

1,594,597

180,221

2,303,436

336,643

181,485

686,844

960,695

177,139

302,460

164,637

289,446

124,200

846,757

70,955

420,379

172,328

1,418,549

548,555,168

7,332,465

339,769

2,028,746

1,924,539

100,183

$

-

-

-

(48,652)

-

-

(2,587,975)

-

-

-

-

(1,538,870)

-

-

-

-

-

-

-

-

-

(993,229)

-

-

-

(1,437,945)

-

(2,330,340)

-

-

-

-

Schedule B-4 Page 15 of 34 Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Construction Work in Progress

(a) Base Period, (b) Test Year Period

Line

No.

Project No.

Project Description

309

D.0002240.009 ITC-Payroll_and_Benefits SW 200165

310

D.0002265.004 ITC - 2020 Oracle Licenses SW - TX

311

D.0002286.008 ITC PI for Wind Farms Smart Signl S

312

D.0002298.004 ITC-UAS Fleet Mngmt-SW-SPS

313

D.0002322.006 ITC-Outage Employee Experience SPS

314

D.0002329.006 ITC-Upgrade Corporate Fina SW 20009

315

D.0002333.004 ITC ISO Intrfc & Stlmt Rpl SW SPS-2

316

D.0002350.006 ITC-SAS BookRunner Upgra SW 200134

317

D.0002364.006 ITC-BS Resiliency SW 200074 SPS

318 Subtotal - Intangible

319 Production

320

A.0001529.068 MAD1C-Upg DCS Opr Stn-19969

321

A.0001529.084 MAD1C-Rpl #2 HP FWH

322

A.0001529.089 MAD1C-Rpl SH Term Tubes

323

A.0001529.500 MAD Emergent Fund -Steam prod

324

A.0001534.204 PLX0C-Floating pump w piping for pi

325

A.0001534.209 PLX3C Rpl East Waterwall Tubes

326

A.0001534.500 PLX Emergent Fund -Steam prod

327

A.0001545.085 CHC0C-Rpr Water Well Mtr 2019

328

A.0001545.110 CHC3C-Upg CEMs Foxboro Sys

329

A.0001545.130 CHC4C-Rpl Combustor Components -238

330

A.0001545.282 CHC34C CT Control Upgrade

331

A.0001550.500 HAR Emergent Fund -Steam prod

332

A.0001555.148 TOL0C-Rpl Water Treatment Bldg

333

A.0001555.224 TOL2C-Rpr MillF GearBx & Journ

334

A.0001555.258 TOL2C-Rbld T2 Mill B Gearbox

335

A.0001555.300 TOL2C-Prch & Install New GSU XFMR

336

A.0001555.415 TOL0C-Inst Secondary RO Feed Supply

337

A.0001555.421 TOL1C-Rpl TK02 oil circuit breaker

338

A.0001555.422 TOL1C-Rpl UPS Inverters

339

A.0001555.428 TOL2C-Rpl TK32 oil circuit breaker

340

A.0001555.429 TOL2C-Rpl UPS Inverters

341

A.0001555.500 TOL Emergent Fund -Steam prod

342

A.0001555.588 TOL0C- Install Gas Chromatograph

343

A.0001560.126 NIC0C-HW Rd. WW Trtment Improv

344

A.0001560.136 NIC1C-Rpl U1 Volt Reg

345

A.0001560.500 NIC Emergent Fund -Steam prod

346

A.0001563.001 SPS Wind - Sagamore

347

A.0001577.001 SPS Wind -Hale County

348

A.0001586.017 JON0C NOX Controls Enhancement

349

A.0001586.020 JON3C Jones 3&4 Hot Gas Path Replac

350

A.0001586.299 JON0C-Effluent Water Optimization

351

A.0001586.501 JON Emergent Fund -Other prod

Base Period Ending Balance September 30, 2020
19,807 -
4,593 50,821 89,375
7,948 39,691
3,581 -

$

22,979,634

Expenditures During Period Oct 2020 - Feb 2021
697,463 -
242,915 225,063
54,861 220,937 317,947
9,638 2,362

$

11,546,105

Closings During Period Oct 2020 - Feb 2021
(2,362)

$

(9,554,769)

Ending Balance Feb 2021 (1) 717,270 247,509 275,884 144,236 228,884 357,638 13,219 -

$

24,970,969

$

348,936 $

175,602 $

(524,538) $

-

564,572

89,564

(654,136)

-

513,423

606,429

(1,119,851)

-

128,136

229,860

(186,986)

171,011

559,185

159,091

(718,277)

-

827,516

-

(827,516)

-

1,438,694

466,297

(1,414,641)

490,350

134,165

-

(134,165)

-

169,678

622

(170,300)

-

1,594,597

824,773

(2,419,370)

-

180,221

925,089

(1,105,310)

-

782,812

1,285,110

(1,285,868)

782,054

336,643

-

(336,643)

-

387,424

-

(387,424)

-

686,844

23,215

(710,059)

-

3,822,309

51,034

(3,873,343)

-

177,139

88,775

(265,914)

-

302,460

81,542

(384,001)

-

164,637

95,163

(259,799)

-

289,446

233,644

(523,090)

-

124,200

96,337

(220,537)

-

568,468

2,101,744

(1,409,304)

1,260,908

120,890

1,775

(122,665)

-

1,743,939

1,246,490

-

2,990,429

172,328

98,815

(271,143)

-

244,683

524,209

(356,618)

412,274

707,985,988

96,171,835

(804,157,822)

-

5,137,781

722,203

(5,859,984)

-

339,769

1,333,587

(1,673,356)

-

2,028,746

10,046,768

(12,075,514)

-

1,924,539

1,932,441

(3,856,980)

-

100,183

833,284

(670,055)

263,411

Schedule B-4 Page 16 of 34 Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Construction Work in Progress

(a) Base Period, (b) Test Year Period

Line

No.

Project No.

Project Description

352

A.0001598.001 TOL1C-Synchronous Condenser

353

A.0001598.002 TOL2C-Synchronous Condenser

354

A.0001621.004 GCT0C-Interconnect

355

A.0001529.082 MAD3C-Rpl U940 Gen Breaker

356

A.0001534.187 PLX4C-Generator Rewedge

357

A.0001534.200 PLX4C-X4 East BFP element rebuild

358

A.0001545.104 CHC2C-Upg CEMs Foxboro Sys

359

A.0001550.208 HAR3C-H3 Rebag Partial 2019

360

A.0001550.345 HAR3C-Mill B Major Overhaul

361

A.0001550.470 HAR2C-Rpl CT Riser Inlet Vlvs

362

A.0001555.104 TOL0C-Rpl RR Ties PH 5 of 5

363

A.0001555.221 TOL1C-Rpr MillD GearBx & Jrnl

364

A.0001555.299 TOL0C-ICCP Replacement-Tolk

365

A.0001560.094 NIC3C-CT Structure Unit3

366

A.0001560.124 NIC3C-Rpl Condenser Inlet Circ Pipe

367

A.0001560.128 NIC3C-Rpl CW Risers at CT

368

A.0001586.263 JON0C-Rpl Oil Circ Breaker JK10-210

369

A.0001586.500 JON Emergent Fund -Steam prod

370

A.0001590.004 GMS0C-ICCP Replacement-BlackHawk

371

A.0001545.111 CHC4C-Rpl Station Batt

372

A.0001545.123 CHC3C-Rewind Generator

373

A.0001545.260 CHC0C-Arc flash relay, 480 buss G

374

A.0001545.500 CHC Emergent Fund -Steam prod

375

A.0001545.501 CHC Emergent Fund -Other prod

376

A.0001550.186 HAR2C-H2 Rpl #6 LP FWH

377

A.0001550.187 HAR2C-H2 Rpl #5 LP FWH

378

A.0001550.388 HAR2C-Rpl Gen Hydrogen Purity Monit

379

A.0001550.472 HAR2C-Rpl EHC Pump Sys.

380

A.0001555.217 TOL0C-Rail Ballast & Alignmnt

381

A.0001555.226 TOL2C-Rpl Mill E Gearbx & Jour

382

A.0001560.133 NIC3C-Rpl FWH Lvl Transmitters

383

A.0001577.002 Hale-Land & Land Rights

384

A.0001550.346 HAR2C-H2 Rpl Foxboro FBMs

385

A.0001550.392 HAR2C-H2 Rpl Burners

386

A.0001550.406 HAR2C-Rpl Steam Cooled Spacer Tubes

387

A.0001550.407 HAR2C-Inst Maint Switch on MV Bkrs

388

A.0001550.421 HAR2C Gen Stator Rewind

389

A.0001550.471 HAR2C-Rpl CT MCCs on F-Bus

390

A.0001555.413 TOL0C-Rpl TK09 oil circuit breaker

391

A.0001555.414 TOL0C-Startup A-B Transformer DGA

392

A.0001555.420 TOL1C-A B xfmr X winding bushings

393

A.0001555.433 TOL1C-Rpl RH Loops

394

A.0001586.308 JON4C-Exhaust Stack Silencer Baffle

395

A.0001529.083 MAD0C-Rpl Waterwells 2020

396

A.0001529.092 MAD2C-RPL OCB Gen Breaker 52G

Estimated Completion
Date 12/31/2020 12/31/2020 1/1/2026 11/21/2019 10/31/2019 11/22/2019 11/22/2019 9/20/2019 9/24/2020 6/30/2020 11/27/2019 12/19/2019 10/28/2019 11/21/2019 11/21/2019 11/21/2019 11/21/2019
Routine Actual Closings 12/13/2019 8/18/2020 5/31/2019 5/29/2020
Closing Pattern 7/24/2020 5/29/2020 5/29/2020 5/8/2020 5/29/2020
11/27/2019 12/26/2018
3/23/2020 10/30/2018
7/24/2020 5/29/2020 5/29/2020 5/29/2020 5/29/2020 5/29/2020
9/4/2020 7/29/2020 5/29/2020 5/29/2020 3/27/2020
5/8/2020 12/31/2021

Estimated Cost of Project 6,921,627 7,533,450 2,965,056 3,452 6,114 6,226 424,130 171,960 (1,500) 45,766 525,399 1,447 1,463 55,529 5,783,667 212,985 200,965 106,174 5,520,021 206,727 556,218 565,820 23,419 283,329 378,365 37,793 821,994 1,332,494 562,661 658,186 172,402 3,219,962 263,525 337,853 98,411 157,513 1,812,669 723,178 140,840 570,883

Base Period Beginning Balance -
October 1, 2019 1,700,687 1,282,130 221,452 941,049 182,569 143,253 106,182 117,737 142,929 153,520 517,010 101,602 3,523,280 399,411 319,512 235,267 137,310 106,452 17,095 31,368 15,241 56,505 54,986 3,460 8,741 23,731 (75) 2,864 1,140 1,377 1,917 83,902 5,647 -

Expenditures Through End of Base Period
6,114,049 5,750,008 2,195,817
95,257 (222,688)
(15,513) 97,484 12,950 396,662 154,531 746,975 282,138
450 709,481
(4,190) 19,636 177,361 391,321
1,461 73,456 262,212 112,970 516,719 127,738 499,209 501,178 117,622 323,405 437,537 764,420 169,127 821,994 1,811,221 522,817 638,444 191,988 2,921,973 268,787 305,101 104,072 165,255 1,433,054 687,604 129,762 10,172

Closings Through End of Base Period
(316,709) (718,361) (167,057) (240,737) (113,851) (514,400) (297,460) (900,495) (799,148) (102,052) (4,232,762) (395,220) (339,149) (412,627) (498,674) (107,913) (73,456) (262,212) (130,066) (487,843) (142,979) (555,714) (556,164) (121,082) (323,405) (446,278) (764,420) (192,858) (821,994) (1,814,085) (522,817) (639,585) (193,366) (2,923,890) (268,787) (305,101) (104,072) (165,255) (1,516,956) (693,252) (129,762) -

Schedule B-4 Page 17 of 34 Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Construction Work in Progress

(a) Base Period, (b) Test Year Period

Line

No.

Project No.

Project Description

352

A.0001598.001 TOL1C-Synchronous Condenser

353

A.0001598.002 TOL2C-Synchronous Condenser

354

A.0001621.004 GCT0C-Interconnect

355

A.0001529.082 MAD3C-Rpl U940 Gen Breaker

356

A.0001534.187 PLX4C-Generator Rewedge

357

A.0001534.200 PLX4C-X4 East BFP element rebuild

358

A.0001545.104 CHC2C-Upg CEMs Foxboro Sys

359

A.0001550.208 HAR3C-H3 Rebag Partial 2019

360

A.0001550.345 HAR3C-Mill B Major Overhaul

361

A.0001550.470 HAR2C-Rpl CT Riser Inlet Vlvs

362

A.0001555.104 TOL0C-Rpl RR Ties PH 5 of 5

363

A.0001555.221 TOL1C-Rpr MillD GearBx & Jrnl

364

A.0001555.299 TOL0C-ICCP Replacement-Tolk

365

A.0001560.094 NIC3C-CT Structure Unit3

366

A.0001560.124 NIC3C-Rpl Condenser Inlet Circ Pipe

367

A.0001560.128 NIC3C-Rpl CW Risers at CT

368

A.0001586.263 JON0C-Rpl Oil Circ Breaker JK10-210

369

A.0001586.500 JON Emergent Fund -Steam prod

370

A.0001590.004 GMS0C-ICCP Replacement-BlackHawk

371

A.0001545.111 CHC4C-Rpl Station Batt

372

A.0001545.123 CHC3C-Rewind Generator

373

A.0001545.260 CHC0C-Arc flash relay, 480 buss G

374

A.0001545.500 CHC Emergent Fund -Steam prod

375

A.0001545.501 CHC Emergent Fund -Other prod

376

A.0001550.186 HAR2C-H2 Rpl #6 LP FWH

377

A.0001550.187 HAR2C-H2 Rpl #5 LP FWH

378

A.0001550.388 HAR2C-Rpl Gen Hydrogen Purity Monit

379

A.0001550.472 HAR2C-Rpl EHC Pump Sys.

380

A.0001555.217 TOL0C-Rail Ballast & Alignmnt

381

A.0001555.226 TOL2C-Rpl Mill E Gearbx & Jour

382

A.0001560.133 NIC3C-Rpl FWH Lvl Transmitters

383

A.0001577.002 Hale-Land & Land Rights

384

A.0001550.346 HAR2C-H2 Rpl Foxboro FBMs

385

A.0001550.392 HAR2C-H2 Rpl Burners

386

A.0001550.406 HAR2C-Rpl Steam Cooled Spacer Tubes

387

A.0001550.407 HAR2C-Inst Maint Switch on MV Bkrs

388

A.0001550.421 HAR2C Gen Stator Rewind

389

A.0001550.471 HAR2C-Rpl CT MCCs on F-Bus

390

A.0001555.413 TOL0C-Rpl TK09 oil circuit breaker

391

A.0001555.414 TOL0C-Startup A-B Transformer DGA

392

A.0001555.420 TOL1C-A B xfmr X winding bushings

393

A.0001555.433 TOL1C-Rpl RH Loops

394

A.0001586.308 JON4C-Exhaust Stack Silencer Baffle

395

A.0001529.083 MAD0C-Rpl Waterwells 2020

396

A.0001529.092 MAD2C-RPL OCB Gen Breaker 52G

Base Period Ending Balance September 30, 2020
7,814,736 7,032,137 2,195,817
5,281 29,957 60,244 (75) 10,172

Expenditures During Period Oct 2020 - Feb 2021
2,606,419 3,179,672
54,308 -
620,629 -
9,183 -
874,457 622 -
3,461

Closings During Period Oct 2020 - Feb 2021
(10,421,155) (10,211,809)
(5,281) (295,492) (482,427) 75 (622) -

Ending Balance Feb 2021 (1) 2,250,125 0 355,095 9,183 452,275 0 13,634

Schedule B-4 Page 18 of 34 Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Construction Work in Progress

(a) Base Period, (b) Test Year Period

Line

No.

Project No.

Project Description

397

A.0001529.095 MAD0C-Rpl Overhead Crane - NEW

398

A.0001529.106 MAD2C-Hot Gas Path -24305

399

A.0001545.043 CHC2C-Rpl CT Decking

400

A.0001545.089 CHC0C-Rep Water Wells 2020

401

A.0001545.112 CHC4C-Upg CEMSs Foxboro Sys

402

A.0001545.129 CHC4C-Rewind Generator

403

A.0001545.131 CHC2C Rpl Boiler Tube

404

A.0001550.235 HAR2C-H2 Rebag Partial 2020

405

A.0001577.501 HALE Emergent Fund-Other Prod

406

A.0001586.126 JON1C-Rewind Exciter Rotor

407

A.0001586.302 JON1C-Rpl #9 Fan Shroud

408

A.0001586.312 JON1C-Corner Tube Replacement -2404

409 Subtotal - Production

410 Transmission

411

A.0000153.011 Z08 Switch Replacements

412

A.0000153.012 Z50 Muleshoe West Switch

413

A.0000220.006 SPS S&E, Sub

414

A.0000220.018 SPS NM S&E, Sub

415

A.0000220.036 PCA Capbank Rplmt NM

416

A.0000220.037 Cox Int Differential Upgrades

417

A.0000303.044 SPS S&E 69kV Line TX

418

A.0000303.045 SPS S&E 115kV Line TX

419

A.0000303.050 SPS S&E 345kV Line KS

420

A.0000303.085 T30 Str Rpl PPR

421

A.0000303.088 W74 Str Rpl PPR

422

A.0000401.064 Yoakum Relay Upgrade V99 Term

423

A.0000401.065 Plains Relay Upgrade V99 Term

424

A.0000401.066 Floyd Co Y77/Z36 Relay Rplcmnts

425

A.0000424.108 Kiowa-Eddy Co 345kV Line

426

A.0000424.111 Eddy Co 345kV 4 Brkr Ring-Kiow

427

A.0000424.113 Kiowa 345kV Eddy Co Term Sub

428

A.0000424.243 Medanos Sub Tam

429

A.0000424.247 W88 LR SB Reterm

430

A.0000424.266 OPIE 3 W 39 Rbld PHTM RDBF

431

A.0000424.270 Lynch Sub TAM

432

A.0000424.275 CRSR SER1 345kV J16 Relay

433

A.0000499.011 SPS ELR 115kV NM 2016

434

A.0000499.022 Z61 ELR Maintenance

435

A.0000499.032 K59 Str Rpl

436

A.0000514.005 PCA V61 Sub Relay Upg-Carlsbad

437

A.0000640.029 Hale Co 3744,3903,3911,3915 Brkr Rp

438

A.0000640.042 Eddy Co Siemens SVC HMI 4K75 Breake

439

A.0000673.027 TUCO 345kV Sub Reactor/Y Term_

Estimated Completion
Date 9/24/2020 10/9/2021 5/4/2021 7/1/2020 8/21/2020 7/24/2020 7/27/2020 5/29/2020
Closing Pattern 1/6/2021
9/21/2020 3/22/2021

Estimated Cost of Project 714,568 4,347,610 757,549 121,775 255,737 4,115,757 5,196,796 286,325 810,834 1,543,421 150,589 1,939,413

Base Period Beginning Balance -
October 1, 2019 -

$

178,265,041

Expenditures Through End of Base Period
475,677 1,935 2,591
119,055 250,839 8,151,542 3,961,586 250,224
901 66,955 115,377
2,964
$ 619,432,246

Closings Through End of Base Period
(475,677) -
(119,055) (250,839) (8,151,542) (3,961,586) (250,224)
(115,377) -
$ (46,573,320)

12/15/2020 $ 1,801,274 $

12/15/2020

265,712

Closing Pattern

3,458,618

Closing Pattern

2,424,634

3/15/2021

1,390,975

12/15/2020

668,315

Closing Pattern

396,754

Closing Pattern

530,425

Closing Pattern

489,436

10/30/2020

430,953

11/15/2020

596,534

12/15/2020

364,234

12/15/2020

392,267

6/1/2021

422,503

11/15/2020

23,267,523

11/15/2020

14,862,794

11/15/2020

7,801,805

10/15/2020

756,298

10/15/2020

636,414

10/7/2020

5,625,722

5/14/2021

2,100,852

11/15/2020

207,951

11/15/2020

87,235

12/15/2020

64,686

12/15/2020

750,818

3/15/2021

417,091

12/18/2020

1,809,634

12/15/2020

1,853,265

10/30/2020

3,287,761

586,861 105,791 97,490 30,860 1,308,687 2,724,264 425,008 154,131 2,012 20,009 19,970 10,684 107,638 1,532,232

$

752,639

133,659

940,781

609,933

922,585

417,241

365,065

636,630

416,009

310,470

136,741

176,960

177,643

116,147

32,962,937

14,418,761

7,170,875

762,581

623,906

6,465,699

209,855

160,003

196,854

100,362

192,755

272,572

1,939,397

1,474,938

4,280,751

$

-

-

(1,061,530)

(458,937)

-

-

(174,521)

(1,521,577)

-

-

-

-

-

-

-

-

-

-

-

-

-

-

(838)

-

-

-

-

-

-

Schedule B-4 Page 19 of 34 Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Construction Work in Progress

(a) Base Period, (b) Test Year Period

Line

No.

Project No.

Project Description

397

A.0001529.095 MAD0C-Rpl Overhead Crane - NEW

398

A.0001529.106 MAD2C-Hot Gas Path -24305

399

A.0001545.043 CHC2C-Rpl CT Decking

400

A.0001545.089 CHC0C-Rep Water Wells 2020

401

A.0001545.112 CHC4C-Upg CEMSs Foxboro Sys

402

A.0001545.129 CHC4C-Rewind Generator

403

A.0001545.131 CHC2C Rpl Boiler Tube

404

A.0001550.235 HAR2C-H2 Rebag Partial 2020

405

A.0001577.501 HALE Emergent Fund-Other Prod

406

A.0001586.126 JON1C-Rewind Exciter Rotor

407

A.0001586.302 JON1C-Rpl #9 Fan Shroud

408

A.0001586.312 JON1C-Corner Tube Replacement -2404

409 Subtotal - Production

410 Transmission

411

A.0000153.011 Z08 Switch Replacements

412

A.0000153.012 Z50 Muleshoe West Switch

413

A.0000220.006 SPS S&E, Sub

414

A.0000220.018 SPS NM S&E, Sub

415

A.0000220.036 PCA Capbank Rplmt NM

416

A.0000220.037 Cox Int Differential Upgrades

417

A.0000303.044 SPS S&E 69kV Line TX

418

A.0000303.045 SPS S&E 115kV Line TX

419

A.0000303.050 SPS S&E 345kV Line KS

420

A.0000303.085 T30 Str Rpl PPR

421

A.0000303.088 W74 Str Rpl PPR

422

A.0000401.064 Yoakum Relay Upgrade V99 Term

423

A.0000401.065 Plains Relay Upgrade V99 Term

424

A.0000401.066 Floyd Co Y77/Z36 Relay Rplcmnts

425

A.0000424.108 Kiowa-Eddy Co 345kV Line

426

A.0000424.111 Eddy Co 345kV 4 Brkr Ring-Kiow

427

A.0000424.113 Kiowa 345kV Eddy Co Term Sub

428

A.0000424.243 Medanos Sub Tam

429

A.0000424.247 W88 LR SB Reterm

430

A.0000424.266 OPIE 3 W 39 Rbld PHTM RDBF

431

A.0000424.270 Lynch Sub TAM

432

A.0000424.275 CRSR SER1 345kV J16 Relay

433

A.0000499.011 SPS ELR 115kV NM 2016

434

A.0000499.022 Z61 ELR Maintenance

435

A.0000499.032 K59 Str Rpl

436

A.0000514.005 PCA V61 Sub Relay Upg-Carlsbad

437

A.0000640.029 Hale Co 3744,3903,3911,3915 Brkr Rp

438

A.0000640.042 Eddy Co Siemens SVC HMI 4K75 Breake

439

A.0000673.027 TUCO 345kV Sub Reactor/Y Term_

Base Period Ending Balance September 30, 2020
1,935 2,591
901 66,955 2,964

$

751,123,968

Expenditures During Period Oct 2020 - Feb 2021

35,535 224,797 401,554
-

1,555
58,723 1,441,975 15,615 1,270,197

$

131,243,998

Closings During Period Oct 2020 - Feb 2021

(35,535) -

(1,555)
(21,326) (1,508,930) (15,615) -

$

(870,974,882)

Ending Balance Feb 2021 (1) 226,732 404,145 38,298 1,273,161

$

11,393,084

$

752,639 $

884,670 $

(1,637,309)

133,659

119,231

(252,890)

466,111

159,471

(625,583)

256,787

111,295

(368,082)

1,020,075

305,421

-

417,241

209,934

(627,174)

221,403

1,769,718

(1,991,122)

423,740

216,830

(640,570)

416,009

-

(416,009)

310,470

36,771

(347,241)

136,741

390,671

(527,412)

176,960

166,042

(343,002)

177,643

191,429

(369,072)

116,147

153,165

-

35,687,202

1,490,173

(37,177,375)

14,843,769

727,761

(15,571,529)

7,325,006

787,882

(8,112,888)

764,592

35,092

(799,684)

643,915

32,532

(676,447)

6,485,670

21,902

(6,507,571)

209,855

1,122,255

-

160,003

23,701

(183,704)

196,016

1,552

(197,568)

100,362

1,527

(101,889)

192,755

425,755

(618,510)

283,257

120,288

-

2,047,035

237,056

(2,284,091)

1,474,938

151,941

(1,626,879)

5,812,983

40,490

(5,853,473)

1,325,496 269,312 1,332,110 403,544 -

Schedule B-4 Page 20 of 34 Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Construction Work in Progress

(a) Base Period, (b) Test Year Period

Line

No.

Project No.

Project Description

440

A.0000673.029 Yoakum 345kV Sub Reactor/TUCO

441

A.0000710.015 Potter Physical Security INFR TX

442

A.0000768.002 Crosby-Blanco Retermination-11

443

A.0000795.001 SPS Sub Comm Network Group 1 L

444

A.0000795.005 SPS Sub Comm Network Group 1 L 230k

445

A.0000795.016 HRST-EAPL K-44 230kV Line

446

A.0000822.006 Roswell 115/69kV XFMR Upgrades

447

A.0000855.004 SPS Transmission UAV

448

A.0000996.013 SPS SPIRe East Plant XFMR

449

A.0001005.001 Hale to Cox V07

450

A.0001005.002 Y74 Section rebuild

451

A.0001005.003 Z18 HACO Tap Rebuild

452

A.0001022.007 V29 Tap

453

A.0001030.001 Mustang - Seminole New 115kV Line

454

A.0001030.005 Mustang Sub - Terminal Upgrade

455

A.0001030.007 Seminole Sub - Terminal Upgrade

456

A.0001030.008 W11 2 55/59 Circuit DC with U25

457

A.0001030.009 W13 1 62/53 Circuit DC with U25

458

A.0001033.004 Northwest to Rolling Hills 115kV, W

459

A.0001041.009 K53 Term Upgrade Grapevine Nichols

460

A.0001044.008 Tierra Blanca 115kV Sub

461

A.0001045.012 Tolk 230kV Sub

462

A.0001050.002 Etter Rural - Moore Co 115kV, V63 R

463

A.0001059.002 Bushland Auto Bus Diff Relay Upgrad

464

A.0001059.003 Potter Auto Bus Diff Relay Upgrade

465

A.0001059.007 Crosby Co 115kV Bus Diff

466

A.0001114.001 Z18 Tuco-Plainview Line Ph 4

467

A.0001151.001 Sundown Transformer Upgrade

468

A.0001163.001 Hunsley Highside

469

A.0001163.009 Hunsley-Canyon West Remote End

470

A.0001163.010 Hunsley-Randall Remote End

471

A.0001167.037 Terry Co SPE Relay Upgrades TX

472

A.0001167.040 Plant X K46 Line SPE Relay Upgrades

473

A.0001167.041 Wolforth Intg SPE Relay Upgrades TX

474

A.0001167.046 Hockley T31 Line SPE Relay Upgrades

475

A.0001167.050 Denver Cty V16 SPE Relay UPGS TX

476

A.0001167.087 Hale Co SPE Relay UPGS TX

477

A.0001176.002 TUCO NK80 and NK75 TERM UPGRD

478

A.0001189.001 OPIE Phantom Sub 345

479

A.0001189.002 OPIE Phantom U29 reterm Phan to Wd

480

A.0001189.003 OPIE PhantomU28reterm Phan to Red B

481

A.0001189.008 OPIE Phantom Roadrunner 345 Line J-

482

A.0001189.010 OPIE China Draw Phantom 345 Line J-

483

A.0001189.012 OPIE Roadrunner Sub Phantom Termina

484

A.0001189.016 OPIE China Draw Sub Phantom Termin

Estimated Completion
Date 10/30/2020 10/30/2020 3/23/2018
Closing Pattern Closing Pattern
12/31/2020 11/15/2021 12/15/2021 12/15/2020
4/16/2021 1/29/2021 12/4/2020 11/2/2020 12/15/2020 12/15/2020 12/15/2020 12/15/2020 12/15/2020 5/15/2021 5/15/2020 11/15/2021 5/15/2022 12/15/2021 12/15/2020 12/15/2020 5/15/2021 10/2/2020 12/15/2020 12/18/2020 12/18/2020 12/18/2020 5/14/2021 1/29/2021 5/14/2021 12/18/2020 5/14/2021 12/18/2020 12/15/2020 11/15/2021 10/2/2020 10/7/2020 11/15/2021 11/15/2021 11/15/2021 11/15/2021

Estimated Cost of Project 2,419,565 2,359,351 2,006,722 1,439,403 614,749 4,566,806 3,607,098 276,426 13,771,116 1,024,282 598,040 1,274,248 7,581,127 2,622,909 1,978,531 238,870 177,803 3,461,473 214,695 11,950,285 19,772,112 758,231 360,038 593,065 701,963 968,536 5,780,670 1,679,306 288,094 295,930 1,655,488 997,604 675,703 706,709 1,435,982 575,117 269,761 3,650,457 974,143 609,195 21,137,483 20,814,479 5,293,968 6,972,609

Base Period Beginning Balance -
October 1, 2019 2,208,375 26,516 (261,400) 71,744 2,060,747 86,121 913,622 89,614 141,062 20,298 33,031 15,292 331,617 1,628 2,023 1,021 25,689 1,093 6,710 2,328 213,413 267,194 5,245 3,206

Expenditures Through End of Base Period
2,445,721 1,639,998
315,044 1,130,795
660,058 150,719 154,739 1,918,629 137,958 1,950,931 219,154 347,874 1,248,617 6,797,424 1,760,108 1,429,991 128,082 114,400 127,366 224,309 1,042,690 492,005
77,412 126,715 212,895 117,060 669,054 3,292,388 1,363,680 154,339 171,799 239,355 628,036 118,985 489,943 301,238 370,286 143,478 786,695 864,551 556,753 728,479 706,306 151,488 170,301

Closings Through End of Base Period
261,400 (923,507) (111,186) -

Schedule B-4 Page 21 of 34 Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Construction Work in Progress

(a) Base Period, (b) Test Year Period

Line

No.

Project No.

Project Description

440

A.0000673.029 Yoakum 345kV Sub Reactor/TUCO

441

A.0000710.015 Potter Physical Security INFR TX

442

A.0000768.002 Crosby-Blanco Retermination-11

443

A.0000795.001 SPS Sub Comm Network Group 1 L

444

A.0000795.005 SPS Sub Comm Network Group 1 L 230k

445

A.0000795.016 HRST-EAPL K-44 230kV Line

446

A.0000822.006 Roswell 115/69kV XFMR Upgrades

447

A.0000855.004 SPS Transmission UAV

448

A.0000996.013 SPS SPIRe East Plant XFMR

449

A.0001005.001 Hale to Cox V07

450

A.0001005.002 Y74 Section rebuild

451

A.0001005.003 Z18 HACO Tap Rebuild

452

A.0001022.007 V29 Tap

453

A.0001030.001 Mustang - Seminole New 115kV Line

454

A.0001030.005 Mustang Sub - Terminal Upgrade

455

A.0001030.007 Seminole Sub - Terminal Upgrade

456

A.0001030.008 W11 2 55/59 Circuit DC with U25

457

A.0001030.009 W13 1 62/53 Circuit DC with U25

458

A.0001033.004 Northwest to Rolling Hills 115kV, W

459

A.0001041.009 K53 Term Upgrade Grapevine Nichols

460

A.0001044.008 Tierra Blanca 115kV Sub

461

A.0001045.012 Tolk 230kV Sub

462

A.0001050.002 Etter Rural - Moore Co 115kV, V63 R

463

A.0001059.002 Bushland Auto Bus Diff Relay Upgrad

464

A.0001059.003 Potter Auto Bus Diff Relay Upgrade

465

A.0001059.007 Crosby Co 115kV Bus Diff

466

A.0001114.001 Z18 Tuco-Plainview Line Ph 4

467

A.0001151.001 Sundown Transformer Upgrade

468

A.0001163.001 Hunsley Highside

469

A.0001163.009 Hunsley-Canyon West Remote End

470

A.0001163.010 Hunsley-Randall Remote End

471

A.0001167.037 Terry Co SPE Relay Upgrades TX

472

A.0001167.040 Plant X K46 Line SPE Relay Upgrades

473

A.0001167.041 Wolforth Intg SPE Relay Upgrades TX

474

A.0001167.046 Hockley T31 Line SPE Relay Upgrades

475

A.0001167.050 Denver Cty V16 SPE Relay UPGS TX

476

A.0001167.087 Hale Co SPE Relay UPGS TX

477

A.0001176.002 TUCO NK80 and NK75 TERM UPGRD

478

A.0001189.001 OPIE Phantom Sub 345

479

A.0001189.002 OPIE Phantom U29 reterm Phan to Wd

480

A.0001189.003 OPIE PhantomU28reterm Phan to Red B

481

A.0001189.008 OPIE Phantom Roadrunner 345 Line J-

482

A.0001189.010 OPIE China Draw Phantom 345 Line J-

483

A.0001189.012 OPIE Roadrunner Sub Phantom Termina

484

A.0001189.016 OPIE China Draw Sub Phantom Termin

Base Period Ending Balance September 30, 2020
4,654,096 1,666,514
315,044 279,032 660,058 150,719 154,739 3,979,376 137,958 1,950,931 219,154 347,874 1,334,739 7,711,047 1,849,723 1,571,053 128,082 114,400 127,366 113,123 1,042,690 512,304 110,443 126,715 212,895 117,060 684,345 3,624,005 1,363,680 154,339 171,799 240,983 630,059 120,006 515,632 302,331 376,996 143,478 789,022 864,551 556,753 941,891 973,500 156,733 173,506

Expenditures During Period Oct 2020 - Feb 2021
62,442 555,096
809,112 669,555 419,675 961,901 806,701 118,873 7,684,151 704,475 177,906
91,072 1,010,756
957,730 611,724 104,934
57,830 966,840
2,660,023 1,554,457
43,270 223,581 365,916 343,072 142,707 2,363,731 316,035 127,854 118,074 413,541 332,778 247,077 176,920 570,285 247,505 119,266 296,159
42,352 21,507 9,428,968 9,247,001 731,822 1,023,814

Closings During Period Oct 2020 - Feb 2021
(4,716,538) (2,221,610)
(315,044) (1,088,144) (1,329,613)
(570,395) -
(256,831) -
(923,629) (525,781) (1,425,811) (8,721,802) (2,807,453) (2,182,777) (233,016) (172,230)
(113,123)
(350,296) (578,811) (827,052) (5,987,736) (1,679,714) (282,193) (289,873) (962,837) (692,553) (624,501) (262,744) (906,903) (578,260) -

Ending Balance Feb 2021 (1) 1,116,640 4,786,077 9,635,082 1,094,206 3,702,713 2,066,760 153,713 460,132 654,524 367,083 872,616 1,085,182 10,370,860 10,220,501 888,555 1,197,321

Schedule B-4 Page 22 of 34 Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Construction Work in Progress

(a) Base Period, (b) Test Year Period

Line

No.

Project No.

Project Description

485

A.0001189.018 OPIE Phantom Sub Cust Term 1 TOIF

486

A.0001189.019 OPIE Phantom Sub Cust Term 2 TOIF

487

A.0001189.020 Phantom 115kV Bus

488

A.0001189.021 OPIE 3 Roadrunner - China Draw 345k

489

A.0001189.022 Phantom 345 115kV XFMR T02

490

A.0001189.024 Red Bluff U28 Phantom Terminal

491

A.0001189.025 Wood Draw U29 Phantom Terminal

492

A.0001204.002 Z18 Tuco Hale Center Phase 2

493

A.0001214.001 Malaga Bend 115 1247kV Substation T

494

A.0001214.002 Loving South Malaga Bend Terminal

495

A.0001214.003 Phantom Malaga Bend Terminal

496

A.0001214.004 U26 LS Malaga 115kV Line

497

A.0001219.001 K55 AMOCW ELR RFL9300 SPS TX

498

A.0001219.003 T55 DNV CY ELR RFL9300 SPS TX

499

A.0001219.004 K55 MUSTANG ELR RFL9300 SPS TX

500

A.0001219.006 T 55 MUSTANG ELR RFL9300 SPS TX

501

A.0001219.037 T56 Mustang 115 ELR RFL 9300 Relays

502

A.0001228.001 McDowell Creek Substation

503

A.0001237.001 Wollforth transformer upgrade 230/1

504

A.0001243.001 Carlisle Cap Bank Rplmt

505

A.0001252.002 Tuco Bkr Rplc N905 & N912

506

A.0001271.009 REFUND NEF 115kV Line

507

A.0001295.002 Sundown 115kV Capacitor Bank

508

A.0001367.001 Littlefield West Tap Rebuild Line

509

A.0001375.001 Amherst Tap Rebuild Line

510

A.0001383.001 TxDot T 37 Relocate

511

A.0001383.003 TxDot T-36 Relocate

512

A.0001384.001 Inst W76 115KV 1 Wy Sw_XTO PORT TOI

513

A.0001402.002 Tolk T2 345/230 Xfmr Expansion

514

A.0001402.004 Crossroads Sub 345kV Cap Bank

515

A.0001402.005 Tierra Blanca 115kV Cap Bank

516

A.0001402.008 T59 Deaf Smith Curry Upgrade

517

A.0001402.012 T59 NM

518

A.0001402.018 Tuco 230kV Cap Bank 1

519

A.0001407.001 T-63 Transmission Line Relocation

520

A.0001407.003 W-57 Transmission Line Relocation

521

A.0001408.001 W25 Sisko Line

522

A.0001419.001 Millen ? Sub 2nd XFMR TAM

523

A.0001420.001 Finney SSVT 345kV

524

A.0001421.001 Spearman Breaker Replacement 1715

525

A.0001421.003 Spearman Breaker Replacement 1711

526

A.0001427.001 Y58 PH2- BURN to ROXA

527

A.0001477.002 DS #26, W51 SW, TOIF

528

A.0001478.001 Oxy Y79 Tap, Line

529

A.0001480.002 Tip Top Solar, RR Term, Sub

Estimated Completion
Date 11/15/2020 11/15/2020 10/2/2020 11/15/2021 11/15/2021 10/7/2020 10/2/2020 5/15/2021 10/2/2020 10/2/2020 10/2/2020 10/2/2020 10/16/2020 11/13/2020 10/16/2020 11/13/2020 12/18/2020 4/16/2022 4/15/2021 12/18/2020 4/15/2021 8/1/2020 12/18/2020 11/15/2022 5/15/2022 12/31/2020 12/31/2020 10/19/2020 11/15/2021 11/20/2020 11/15/2021 11/20/2020 11/20/2020 5/14/2021 10/31/2020 10/31/2020 4/15/2021 4/15/2021 5/14/2021 12/31/2020 12/31/2020 5/15/2021 4/15/2021 4/15/2021 10/15/2022

Estimated Cost of Project 1,080,421 1,105,107 11,398,177 7,172,251 6,911,940 243,919 162,292 8,032,153 1,337,739 2,403,070 949,837 10,594,404 311,465 305,844 284,233 274,648 314,662 6,912,979 4,086,353 1,944,077 836,388 480,615 1,018,387 978,245 825,742 129,616 (109,664) 77,822 10,241,760 6,327,703 3,516,821 1,314,098 1,953,376 5,201,926 78,834 462,232 552,556 1,070,335 707,953 1,558,825 198,507 9,031,153 (245,614) (179,178) (289,187)

Base Period Beginning Balance -
October 1, 2019 (1,352,515) (1,367,773) 480,147 1,130 819 16,612 8,491 23,645 75,494 438,655 31,686 191,464 108,665 1,095,833 489,418 753 19,197 -

Expenditures Through End of Base Period
589,013 627,366 11,636,884 443,631 381,006 355,772 193,171 2,783,607 1,427,875 2,075,094 960,140 10,247,264 233,950 167,886 204,460 118,670 116,426 110,542 219,134 1,005,504 106,313 489,776 953,565
43,476 656,583 815,968 234,441 100,193 838,011 5,579,117 250,759 563,144 919,303 204,750 (185,219) 363,530 111,677 250,049 102,308 777,847 484,571 262,005 (282,439) (198,666) (122,459)

Closings Through End of Base Period
-

Schedule B-4 Page 23 of 34 Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Construction Work in Progress

(a) Base Period, (b) Test Year Period

Line

No.

Project No.

Project Description

485

A.0001189.018 OPIE Phantom Sub Cust Term 1 TOIF

486

A.0001189.019 OPIE Phantom Sub Cust Term 2 TOIF

487

A.0001189.020 Phantom 115kV Bus

488

A.0001189.021 OPIE 3 Roadrunner - China Draw 345k

489

A.0001189.022 Phantom 345 115kV XFMR T02

490

A.0001189.024 Red Bluff U28 Phantom Terminal

491

A.0001189.025 Wood Draw U29 Phantom Terminal

492

A.0001204.002 Z18 Tuco Hale Center Phase 2

493

A.0001214.001 Malaga Bend 115 1247kV Substation T

494

A.0001214.002 Loving South Malaga Bend Terminal

495

A.0001214.003 Phantom Malaga Bend Terminal

496

A.0001214.004 U26 LS Malaga 115kV Line

497

A.0001219.001 K55 AMOCW ELR RFL9300 SPS TX

498

A.0001219.003 T55 DNV CY ELR RFL9300 SPS TX

499

A.0001219.004 K55 MUSTANG ELR RFL9300 SPS TX

500

A.0001219.006 T 55 MUSTANG ELR RFL9300 SPS TX

501

A.0001219.037 T56 Mustang 115 ELR RFL 9300 Relays

502

A.0001228.001 McDowell Creek Substation

503

A.0001237.001 Wollforth transformer upgrade 230/1

504

A.0001243.001 Carlisle Cap Bank Rplmt

505

A.0001252.002 Tuco Bkr Rplc N905 & N912

506

A.0001271.009 REFUND NEF 115kV Line

507

A.0001295.002 Sundown 115kV Capacitor Bank

508

A.0001367.001 Littlefield West Tap Rebuild Line

509

A.0001375.001 Amherst Tap Rebuild Line

510

A.0001383.001 TxDot T 37 Relocate

511

A.0001383.003 TxDot T-36 Relocate

512

A.0001384.001 Inst W76 115KV 1 Wy Sw_XTO PORT TOI

513

A.0001402.002 Tolk T2 345/230 Xfmr Expansion

514

A.0001402.004 Crossroads Sub 345kV Cap Bank

515

A.0001402.005 Tierra Blanca 115kV Cap Bank

516

A.0001402.008 T59 Deaf Smith Curry Upgrade

517

A.0001402.012 T59 NM

518

A.0001402.018 Tuco 230kV Cap Bank 1

519

A.0001407.001 T-63 Transmission Line Relocation

520

A.0001407.003 W-57 Transmission Line Relocation

521

A.0001408.001 W25 Sisko Line

522

A.0001419.001 Millen ? Sub 2nd XFMR TAM

523

A.0001420.001 Finney SSVT 345kV

524

A.0001421.001 Spearman Breaker Replacement 1715

525

A.0001421.003 Spearman Breaker Replacement 1711

526

A.0001427.001 Y58 PH2- BURN to ROXA

527

A.0001477.002 DS #26, W51 SW, TOIF

528

A.0001478.001 Oxy Y79 Tap, Line

529

A.0001480.002 Tip Top Solar, RR Term, Sub

Base Period Ending Balance September 30, 2020
(763,502) (740,407) 12,117,031 444,761 381,825 372,383 201,662 2,807,253 1,503,369 2,513,749 991,826 10,438,728 233,950 167,886 204,460 118,670 116,426 110,542 219,134 1,005,504 106,313 489,776 1,062,230 1,139,309 1,146,001 816,721 234,441 119,390 838,011 5,579,117 250,759 563,144 919,303 204,750 (185,219) 363,530 111,677 250,049 102,308 777,847 484,571 262,005 (282,439) (198,666) (122,459)

Expenditures During Period Oct 2020 - Feb 2021
12,500 12,500 247,505 67,324 64,829 25,202 23,817 1,951,348
4,098 357,149
25,668 793,109
65,809 126,636
71,553 143,269 197,041
98,696 3,094,203
845,768 365,910
110,084
28,178 28,343 549,032 69,529
327 1,294,634
746,954 (78,053) 424,253 612,320 2,483,559 23,250
5,623 218,100 524,056 323,806 674,889
39,566 4,351,200
34,248 18,124 (167,017)

Closings During Period Oct 2020 - Feb 2021
751,002 727,907 (12,364,536)
(397,586) (225,479) (1,507,467) (2,870,898) (1,017,494) (11,231,837) (299,758) (294,522) (276,013) (261,939) (313,467) (1,851,273) (489,776) (1,172,314) (1,365,753) (303,970) (119,717) (6,326,071) (987,397) (1,531,623) 161,969 (369,153) (1,452,736) (524,137) -

Ending Balance Feb 2021 (1) 512,085 446,654 4,758,600 209,238 3,313,337 472,223 1,167,486 1,174,345 2,132,646 172,706 2,688,308 329,777 774,105 426,115 4,613,205 (248,191) (180,542) (289,476)

Schedule B-4 Page 24 of 34 Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Construction Work in Progress

(a) Base Period, (b) Test Year Period

Line

No.

Project No.

Project Description

530

A.0001485.004 Pole Treatment Program 230kV TX

531

A.0001563.010 SWF Crossroads 345KV Term Sub Upg

532

A.0001563.011 SWF Crossroads 345KV Term Sub Upg T

533

A.0001563.012 Sagamore- Collector Sub South

534

A.0001563.013 Sagamore-TSG North 345KV

535

A.0001563.014 Sagamore-TSG South 345KV

536

A.0001563.024 Sagamore - Collector Sub North

537

A.0001577.012 Hale-230KV Overhead Bus to Tuco Sub

538

A.0000105.007 Plant X Terminal Upgrades TX

539

A.0000126.005 Artesia Cty Club Line

540

A.0000290.001 Eddy County Dbl Bus Dbl Brkr 230kV

541

A.0000303.061 345 kV Emergency H Frame Structures

542

A.0000401.030 Harrington 230kV K44 (FK40)Sub

543

A.0000401.050 East Plant 2K50 Relay Replacement

544

A.0000424.046 Hobbs-Kiowa 345 kV Line Precon

545

A.0000424.114 Kiowa-Eddy Co 345kV Line Pre C

546

A.0000424.119 N Loving-S Loving 115 kV Line

547

A.0000424.121 S Loving 115kV Conv From 69kV

548

A.0000424.122 N Loving 115kV Bus & S Loving

549

A.0000499.013 SPS ELR 115kV TX 2016

550

A.0000499.015 SPS 230kV ELR TX 2016

551

A.0000499.019 J14 ELR Maintenance

552

A.0000514.002 Plant X 115kV Switch Replacement

553

A.0000514.004 Carlsbad 115kV Switch Replacement

554

A.0000538.008 Z18 Tuco-Plainview Line

555

A.0000556.016 Oasis 230 115kV Fault Recorder

556

A.0000635.001 W-26 Cunningham-Monument Tap wreck

557

A.0000635.002 Cunningham W-26 line terminal upgra

558

A.0000640.033 Eddy Co 4K80 Bkr Replace

559

A.0000673.021 TUCO-Yoakum 345kV Line_UID 504

560

A.0000673.040 Terry Co Sub Repeater

561

A.0000781.013 Bushland Relay

562

A.0000795.002 SPS Sub Comm Network Group 1 S

563

A.0000798.012 Cole Rpl Breaker 0845

564

A.0000842.002 Hale Co Relay Upgrade for Plan

565

A.0000842.004 Plant X Add BFR on All 115 kV

566

A.0000866.001 Bailey County-New Amherst 115k

567

A.0000888.002 XTO Tap 3 Way Switch Transmission

568

A.0000916.004 Deaf Smith 230kV Breaker ADD S

569

A.0000974.003 Optima Sub

570

A.0000979.005 Yoakum Relay upgrade Sub Porti

571

A.0000979.008 Relay Upg - DVCY Shell Term

572

A.0001030.002 Mustang - Seminole ROW

573

A.0001059.004 Eddy County 4950 Relay Upgrade TPL

574

A.0001167.004 TUCO SPE relay Upgrades TX

Estimated Completion
Date Closing Pattern
12/31/2020 12/31/2020 12/31/2020 12/31/2020 12/31/2020 12/31/2020 10/31/2020
3/16/2018 11/22/2019 12/19/2019
1/30/2020 12/19/2019 12/20/2019
1/30/2020 5/26/2020 12/13/2019 12/13/2019 11/15/2019 4/30/2020 12/14/2019 10/30/2019 2/28/2020 5/29/2020 12/15/2019 11/1/2019 12/18/2019 12/16/2019 11/22/2019 5/29/2020 5/29/2020 3/20/2020 Closing Pattern 12/16/2016 4/30/2020 2/20/2020 1/27/2020 10/25/2019 10/30/2019
1/0/1900 12/13/2019 10/29/2019
9/30/2020 3/31/2020 10/21/2020

Estimated Cost of Project 154,922 2,810,225 809,201 12,441,809 4,344,778 5,145,044 12,723,674 1,963,896 (2,033) (104,408) (1,930,541) 47,181 121,529 (671) 16,352 (32,453) 38,872 580,789 172,254 48,055 636,769 3,483,428 42,997 (12,739) 337,082 8,648 3,796 6,745,499 395,630 319,954 431,264 (19,636) 335,758 545,121 (17,383) 54,422 165,154 152,297 3,170 314,216 503,679 398,597

Base Period Beginning Balance -
October 1, 2019 -
144,212 1,796,024 17,068,957
177,607 258,427 322,802 122,976 517,470 2,453,537 1,113,571 3,760,045 805,269 2,496,280 1,547,729 1,708,191 403,901 374,324 242,007 1,562,238 186,432 270,445 93,054,047 152,473 301,940 443,904 (387,136) 313,053 6,809,242 830,310 508,878 5,960,752 (165,154) 368,335 502,989 272,321 275,547 710,929

Expenditures Through End of Base Period
144,078 2,873,386
774,104 12,206,183
3,996,986 5,081,852 11,364,072
925,751 (1,302,852)
133,935 1,488,154
21,641 228,068 325,268 (122,976) (517,470) 355,303 (33,001) 947,417 1,250,464 1,523,359 857,648 411,485 4,202,788 276,347 120,732 2,262,920 107,420 (68,246) 17,498,669 423,978 293,217 154,047 (19,636) 192,764
76,863 (830,764) 389,007
11,799 165,154 501,175 116,246 700,577 493,430 1,120,495

Closings Through End of Base Period
1,115,579 (1,929,959) (18,557,112) (199,248) (486,495) (648,070) (2,808,839) (1,080,571) (4,707,462) (2,055,733) (4,019,639) (2,405,377) (2,119,676) (4,606,689) (650,671) (362,600) (3,825,158) (293,852) (202,200) (110,552,716) (576,452) (595,157) (537,859) 387,136 (505,818) (6,886,105) 454 (888,603) (5,972,551) (869,510) (619,235) (972,898) (768,978) (1,831,424)

Schedule B-4 Page 25 of 34 Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Construction Work in Progress

(a) Base Period, (b) Test Year Period

Line

No.

Project No.

Project Description

530

A.0001485.004 Pole Treatment Program 230kV TX

531

A.0001563.010 SWF Crossroads 345KV Term Sub Upg

532

A.0001563.011 SWF Crossroads 345KV Term Sub Upg T

533

A.0001563.012 Sagamore- Collector Sub South

534

A.0001563.013 Sagamore-TSG North 345KV

535

A.0001563.014 Sagamore-TSG South 345KV

536

A.0001563.024 Sagamore - Collector Sub North

537

A.0001577.012 Hale-230KV Overhead Bus to Tuco Sub

538

A.0000105.007 Plant X Terminal Upgrades TX

539

A.0000126.005 Artesia Cty Club Line

540

A.0000290.001 Eddy County Dbl Bus Dbl Brkr 230kV

541

A.0000303.061 345 kV Emergency H Frame Structures

542

A.0000401.030 Harrington 230kV K44 (FK40)Sub

543

A.0000401.050 East Plant 2K50 Relay Replacement

544

A.0000424.046 Hobbs-Kiowa 345 kV Line Precon

545

A.0000424.114 Kiowa-Eddy Co 345kV Line Pre C

546

A.0000424.119 N Loving-S Loving 115 kV Line

547

A.0000424.121 S Loving 115kV Conv From 69kV

548

A.0000424.122 N Loving 115kV Bus & S Loving

549

A.0000499.013 SPS ELR 115kV TX 2016

550

A.0000499.015 SPS 230kV ELR TX 2016

551

A.0000499.019 J14 ELR Maintenance

552

A.0000514.002 Plant X 115kV Switch Replacement

553

A.0000514.004 Carlsbad 115kV Switch Replacement

554

A.0000538.008 Z18 Tuco-Plainview Line

555

A.0000556.016 Oasis 230 115kV Fault Recorder

556

A.0000635.001 W-26 Cunningham-Monument Tap wreck

557

A.0000635.002 Cunningham W-26 line terminal upgra

558

A.0000640.033 Eddy Co 4K80 Bkr Replace

559

A.0000673.021 TUCO-Yoakum 345kV Line_UID 504

560

A.0000673.040 Terry Co Sub Repeater

561

A.0000781.013 Bushland Relay

562

A.0000795.002 SPS Sub Comm Network Group 1 S

563

A.0000798.012 Cole Rpl Breaker 0845

564

A.0000842.002 Hale Co Relay Upgrade for Plan

565

A.0000842.004 Plant X Add BFR on All 115 kV

566

A.0000866.001 Bailey County-New Amherst 115k

567

A.0000888.002 XTO Tap 3 Way Switch Transmission

568

A.0000916.004 Deaf Smith 230kV Breaker ADD S

569

A.0000974.003 Optima Sub

570

A.0000979.005 Yoakum Relay upgrade Sub Porti

571

A.0000979.008 Relay Upg - DVCY Shell Term

572

A.0001030.002 Mustang - Seminole ROW

573

A.0001059.004 Eddy County 4950 Relay Upgrade TPL

574

A.0001167.004 TUCO SPE relay Upgrades TX

Base Period Ending Balance September 30, 2020
144,078 2,873,386
774,104 12,206,183
3,996,986 5,081,852 11,364,072
925,751 (43,061)
139 60,092 (19,636) 0 9,281 0

Expenditures During Period Oct 2020 - Feb 2021
95,973 35,097 774,679 53,366 67,851 2,261,113 980,739
126,331 -

Closings During Period Oct 2020 - Feb 2021
(144,078) (2,969,359)
(809,201) (12,980,863)
(4,050,352) (5,149,703) (13,625,185) (1,906,490)
43,061 -
(139) -
(186,423) 19,636 (9,281) (0)

Ending Balance Feb 2021 (1) 0 0 (0) 0 (0) (0)

Schedule B-4 Page 26 of 34 Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Construction Work in Progress

(a) Base Period, (b) Test Year Period

Line

No.

Project No.

Project Description

575

A.0001189.009 OPIE Phantom Roadrunner 345 ROW

576

A.0001189.011 OPIE China Draw-Phantom 345 ROW

577

A.0001214.005 U26 LS Malaga 115kV ROW

578

A.0001221.002 INST Switch Xcel Portion

579

A.0001273.005 Facil UpgSub Ancillary Eq2016

580

A.0001369.001 Plant X Rpl Brkr Switch WT Sub

581

A.0002055.001 W77 Canyon East Tap to Arrowhe

582

A.0002055.003 Wreckout and Rebuild ROW

583

A.0000105.001 R27 Reconductor

584

A.0000105.005 Tolk Terminal Upgrades

585

A.0000105.008 K45 Reconductor Transmission Portio

586

A.0000286.005 Horz Cap and Pin Replacement TX

587

A.0000290.005 Cunningham Intg, Upgrade Eddy 230kV

588

A.0000303.007 SPS S&E B 230kV, Line

589

A.0000303.040 SPS S&E 69kV Line NM

590

A.0000303.041 SPS S&E 115kV Line NM

591

A.0000303.046 SPS S&E 345kV Line TX

592

A.0000303.053 SPS Priority Defects 69kV Line TX

593

A.0000303.057 SPS Priority Defects 115kV Line TX

594

A.0000350.001 Lost Draw Substation

595

A.0000350.002 Lost Draw TOIF

596

A.0000350.005 Lost Draw to Cochran Retermination

597

A.0000350.006 Lost Draw to Lea Co Plains Retermin

598

A.0000350.008 Lea County Plains 115kV Sub Term Up

599

A.0000424.037 OPIE 3_Hobbs-Kiowa 345kV Line_

600

A.0000424.099 China Draw-Wood Draw 115kV Lin

601

A.0000424.136 Monument-Byrd 115kvRecond Line

602

A.0000424.137 Monument-Byrd ROW

603

A.0000424.150 OPIE PTJU Intrepid Term Sub

604

A.0000424.242 J14 Eddy Reterm Line

605

A.0000469.015 SPS Major Line Refurb 69kV TX

606

A.0000499.004 Line ELR SPS Line

607

A.0000499.012 SPS ELR 69kV TX 2016

608

A.0000499.020 Z05 ELR Maintenance

609

A.0000564.002 Tuco 345 Trsf Rplmnt Sub Portion

610

A.0000609.001 W26 Byrd Tap-Cooper Rch Wreckout Re

611

A.0000636.001 W27 Oil Center-Lea Road reconductor

612

A.0000640.008 Tolk-Repl Bkrs TK12TK39TK43TK5

613

A.0000646.002 Perryton Substation Sub

614

A.0000665.005 TUCO Mooreland Woodward TX RO

615

A.0000673.023 Yoakum-TX/NM Border 345kV Line

616

A.0000673.031 Yoakum Sub Xmfr 345kV/230KV_UI

617

A.0000710.001 NM Physical Security Sub Infrastruc

618

A.0000710.014 Nichols Physical Security INFR Tx

619

A.0000776.003 Spare 230 115 250 MVA

Estimated Completion
Date 3/20/2020 3/20/2020
11/23/2019 10/31/2019
4/30/2020 2/17/2020 3/27/2020 12/16/2019 12/15/2017 3/15/2018 3/23/2018 6/30/2020 10/30/2018 Closing Pattern 8/31/2020 Closing Pattern Closing Pattern 8/15/2020 6/30/2020 10/18/2018 10/18/2018 10/18/2018 10/18/2018 5/31/2019 3/29/2018 8/24/2020 11/20/2018 12/11/2017 3/28/2019 5/11/2020 3/28/2019 10/27/2016 6/30/2020 6/10/2019 5/10/2018 12/15/2021 4/15/2022 12/28/2016 4/30/2019 4/30/2020 5/31/2019 5/31/2019 12/18/2017 10/10/2021 1/30/2020

Estimated Cost of Project 1,075,621 1,280,539 413,959 132,393 122,793 506,048 2,513,988 277 26,690 (28,044) 1,349,769 (333) 47,379,430 72,493 90,414 37,078 233,127 131,624 616,030 271,299 (281,392) (258,608) (200,127) 25,291 1,198,517 1,035,380 (1,006,784) (81) 120,559 33,027,060 1,548,055 (2,022) 2,940,780 2,545,843 2,832 39,743 210,797 679,403 3,979,741 2,512,318 2,259,576

Base Period Beginning Balance -
October 1, 2019 345,560 380,633 385,165 176,832 153,235
4,386,006 560,139 143,585 29,186 44,116 668 81,046 9,001 51,385 9,056 17,850 12,430 77,964 17,753 34,910

Expenditures Through End of Base Period
1,125,121 1,328,958
691,503 239,855 294,212 357,964 5,601,340
277 8,400,684 (268,082) (3,986,673)
196,128 105,304
66,173 830,843 126,534 120,828 344,693 293,754 1,271,601 271,299 (297,876) (273,592) (205,283) 222,377 1,198,517 313,842 (1,005,341) 187,333 211,037 (118,900)
1,622,706 (193,476) 2,205,613
60,308 37,473 (129,426) 324,133 180,858 271,866 685,846
3,009 2,314,347

Closings Through End of Base Period
(1,470,682) (1,709,591) (1,076,668)
(416,687) (447,447) (4,743,970) (6,161,479) (143,862) (8,400,684) 235,662 3,986,673 (240,244) (105,304)
(19,668) (911,889) (131,850)
(88,741) (302,140) (302,810) (1,271,601) (271,299) 297,876 273,592 205,283 (222,377) (1,198,517) (313,842) 1,005,341 (187,333) (228,887) 118,900
(1,635,136)
193,476 (2,205,613)
129,426 (324,133) (258,822) (271,866) (685,846) (2,349,257)

Schedule B-4 Page 27 of 34 Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Construction Work in Progress

(a) Base Period, (b) Test Year Period

Line

No.

Project No.

Project Description

575

A.0001189.009 OPIE Phantom Roadrunner 345 ROW

576

A.0001189.011 OPIE China Draw-Phantom 345 ROW

577

A.0001214.005 U26 LS Malaga 115kV ROW

578

A.0001221.002 INST Switch Xcel Portion

579

A.0001273.005 Facil UpgSub Ancillary Eq2016

580

A.0001369.001 Plant X Rpl Brkr Switch WT Sub

581

A.0002055.001 W77 Canyon East Tap to Arrowhe

582

A.0002055.003 Wreckout and Rebuild ROW

583

A.0000105.001 R27 Reconductor

584

A.0000105.005 Tolk Terminal Upgrades

585

A.0000105.008 K45 Reconductor Transmission Portio

586

A.0000286.005 Horz Cap and Pin Replacement TX

587

A.0000290.005 Cunningham Intg, Upgrade Eddy 230kV

588

A.0000303.007 SPS S&E B 230kV, Line

589

A.0000303.040 SPS S&E 69kV Line NM

590

A.0000303.041 SPS S&E 115kV Line NM

591

A.0000303.046 SPS S&E 345kV Line TX

592

A.0000303.053 SPS Priority Defects 69kV Line TX

593

A.0000303.057 SPS Priority Defects 115kV Line TX

594

A.0000350.001 Lost Draw Substation

595

A.0000350.002 Lost Draw TOIF

596

A.0000350.005 Lost Draw to Cochran Retermination

597

A.0000350.006 Lost Draw to Lea Co Plains Retermin

598

A.0000350.008 Lea County Plains 115kV Sub Term Up

599

A.0000424.037 OPIE 3_Hobbs-Kiowa 345kV Line_

600

A.0000424.099 China Draw-Wood Draw 115kV Lin

601

A.0000424.136 Monument-Byrd 115kvRecond Line

602

A.0000424.137 Monument-Byrd ROW

603

A.0000424.150 OPIE PTJU Intrepid Term Sub

604

A.0000424.242 J14 Eddy Reterm Line

605

A.0000469.015 SPS Major Line Refurb 69kV TX

606

A.0000499.004 Line ELR SPS Line

607

A.0000499.012 SPS ELR 69kV TX 2016

608

A.0000499.020 Z05 ELR Maintenance

609

A.0000564.002 Tuco 345 Trsf Rplmnt Sub Portion

610

A.0000609.001 W26 Byrd Tap-Cooper Rch Wreckout Re

611

A.0000636.001 W27 Oil Center-Lea Road reconductor

612

A.0000640.008 Tolk-Repl Bkrs TK12TK39TK43TK5

613

A.0000646.002 Perryton Substation Sub

614

A.0000665.005 TUCO Mooreland Woodward TX RO

615

A.0000673.023 Yoakum-TX/NM Border 345kV Line

616

A.0000673.031 Yoakum Sub Xmfr 345kV/230KV_UI

617

A.0000710.001 NM Physical Security Sub Infrastruc

618

A.0000710.014 Nichols Physical Security INFR Tx

619

A.0000776.003 Spare 230 115 250 MVA

Base Period Ending Balance September 30, 2020
(3,234) 47,172 3,685 32,087 93,937 60,308 37,473 20,762 -

Expenditures During Period Oct 2020 - Feb 2021
23,762 3,165,082 168,444 93,397 20,171 19,606 83,718 266,724 -

Closings During Period Oct 2020 - Feb 2021
3,234 (3,212,254) (3,685) (200,531) (93,937) (30) -

Ending Balance Feb 2021 (1) 0 23,762 0 93,397 80,479 57,079 83,688 287,486 -

Schedule B-4 Page 28 of 34 Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Construction Work in Progress

(a) Base Period, (b) Test Year Period

Line

No.

Project No.

Project Description

620

A.0000781.014 Coulter Relay

621

A.0000863.001 SPS Sub Comm Network Group 2 L

622

A.0001024.009 Outpost PLC Removal

623

A.0001044.010 Tierra Blanca 115kV Sub Land

624

A.0001044.017 U44 TIBL-HFRD 115kV T-line

625

A.0001050.004 Upgr Moore Co 115kV (V63) Term to E

626

A.0001054.001 Coulter Switch Replacemnts

627

A.0001079.001 Inst 115kV Quincy Sw Station TOIF P

628

A.0001079.002 Inst 115kV Quincy Sw Station Xcel P

629

A.0001126.001 Inst Temp Switch Reimb TOIF

630

A.0001137.001 U-31 reterm Western St Sub

631

A.0001137.002 U-30 reterm Western St Sub

632

A.0001137.003 Western St Sub U-30 terminal (Coult

633

A.0001137.004 Western St Sub U-31 terminal (S Geo

634

A.0001137.005 SOGE, U-31 terminal

635

A.0001137.006 CLTR, U-30 terminal

636

A.0001147.002 V55 Terry Co Terminal

637

A.0001167.033 Indiana V15 SPE Relay Upgrades TX

638

A.0001189.007 OPIE Phantom Sub Land

639

A.0001205.002 Z18 Tuco Hale Center Phase 3

640

A.0001215.001 Inst W39 Switch Poker Cowboy Temp

641

A.0001221.001 INST 3 1 Way SW KEMP

642

A.0001267.001 345/115kV 448MVA XfmrspareSub

643

A.0001285.001 NEF-Targa Reconductor

644

A.0001310.002 Reterm 345KV Line Old J7

645

A.0001319.009 Canyon West Sub W40 Term Upgr

646

A.0001325.006 W77-T75Recond ArrowheadRandall

647

A.0001326.003 Yoakum 230/115 Transformer 2 Upgrad

648

A.0001359.001 Castro Co Terminal Orion Wind

649

A.0001577.004 Hale-Xmsn Serving Generation

650

A.0002049.001 Potash Sub 115 kV Terminal Sub

651

A.0000303.062 V04 Structure Replacement

652

A.0000303.063 V04 Structure Replacement ROW

653

A.0000424.274 K23 Term Str Replacement

654

A.0000499.027 Y79 ELR Maintanence

655

A.0000514.006 Pecos Sub Relay Upg-Carlsbad

656

A.0000628.003 W26 Cooper Rch Oil Ctr Wreck Out Rb

657

A.0000640.039 Sundown Bkr/Sw

658

A.0001030.010 U01 1 U01 14 Circuit DC with U25

659

A.0001061.008 Purnell Sub

660

A.0001167.025 Lamb Co Intg 115kV SPE Relay UPGS T

661

A.0001167.034 Cochran V56 Line SPE Relay Upgrades

662

A.0001219.010 T74 AMA SOUTH ELR RFL9300 SPS TX

663

A.0001219.011 T78 MOORE CO ELR RFL9300 SPS TX

664

A.0001244.001 Terry Co Sub V24 Term Upgrade

Estimated Completion
Date 5/20/2019
Closing Pattern 3/20/2020 7/31/2020
11/15/2021 12/15/2021
4/30/2020 4/30/2019 4/30/2019 8/29/2018 5/14/2020 5/15/2020 5/15/2020 5/15/2020 5/14/2020 4/30/2020 12/13/2019 5/15/2020 12/16/2019 3/15/2022 6/28/2019 4/11/2019 1/31/2019 2/28/2019 6/12/2018 2/26/2018 5/29/2019 5/17/2019 10/27/2016 6/28/2019 4/27/2018 5/21/2020 1/30/2020 2/17/2020 12/13/2019 5/29/2020 2/15/2022 4/30/2020 4/30/2020 7/31/2019 12/17/2021 5/21/2020 10/28/2021 3/12/2021 12/13/2019

Estimated Cost of Project 45,106 60,156,975 335,534 930,510 1,378,437 481,939 267,268 107,741 (115,100) 281,562 173,890 145,621 1,055,905 310,962 66,061 141,238 23,106 834,177 539 3,360,178 (692,821) (130,411) 1,689 (2,213) (1,564) (7,249) (3,913) 397,278 162,708 1,254,185 130,067 159,436 7,334 210,406 1,666,739 2,542,105 967,048 (871,832) 1,039,832 597,536 226,880 173,491 31,214

Base Period Beginning Balance -
October 1, 2019 -
24,142 87,250
30,737 23,275 54,945 64,162 80,635 20,310 55,890 7,829 28,216 11,060 61,927 449 2,660 29,820 18,494

Expenditures Through End of Base Period
127,528 38,975
425,185 930,510
12,127 522
256,159 267,103 526,776 248,449 182,153 147,553 1,329,192 681,329 107,098 151,751 270,748 783,723 240,560
17,778 (982,424) (120,341) 212,904 108,144 (143,802) 131,498 (151,006) (395,023) 400,402 167,878 (140,208) 1,064,271 142,396 165,201 731,850 234,450
44,396 2,770,250
847,412 (871,832)
26,478 834,160
683 1,291 337,742

Closings Through End of Base Period
(127,528) -
(512,435) (930,510)
(256,159) (267,103) (526,776) (248,449) (212,890) (170,828) (1,384,137) (745,491) (107,098) (151,751) (351,384) (804,039) (296,449) 982,424 120,341 (212,904) (108,144) 143,802 (131,498) 151,006 395,023 (400,402) (167,878) 140,208 (1,092,487) (142,396) (165,201) (731,850) (245,510) (2,832,177) (847,861) 871,832 (863,980) (356,236)

Schedule B-4 Page 29 of 34 Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Construction Work in Progress

(a) Base Period, (b) Test Year Period

Line

No.

Project No.

Project Description

620

A.0000781.014 Coulter Relay

621

A.0000863.001 SPS Sub Comm Network Group 2 L

622

A.0001024.009 Outpost PLC Removal

623

A.0001044.010 Tierra Blanca 115kV Sub Land

624

A.0001044.017 U44 TIBL-HFRD 115kV T-line

625

A.0001050.004 Upgr Moore Co 115kV (V63) Term to E

626

A.0001054.001 Coulter Switch Replacemnts

627

A.0001079.001 Inst 115kV Quincy Sw Station TOIF P

628

A.0001079.002 Inst 115kV Quincy Sw Station Xcel P

629

A.0001126.001 Inst Temp Switch Reimb TOIF

630

A.0001137.001 U-31 reterm Western St Sub

631

A.0001137.002 U-30 reterm Western St Sub

632

A.0001137.003 Western St Sub U-30 terminal (Coult

633

A.0001137.004 Western St Sub U-31 terminal (S Geo

634

A.0001137.005 SOGE, U-31 terminal

635

A.0001137.006 CLTR, U-30 terminal

636

A.0001147.002 V55 Terry Co Terminal

637

A.0001167.033 Indiana V15 SPE Relay Upgrades TX

638

A.0001189.007 OPIE Phantom Sub Land

639

A.0001205.002 Z18 Tuco Hale Center Phase 3

640

A.0001215.001 Inst W39 Switch Poker Cowboy Temp

641

A.0001221.001 INST 3 1 Way SW KEMP

642

A.0001267.001 345/115kV 448MVA XfmrspareSub

643

A.0001285.001 NEF-Targa Reconductor

644

A.0001310.002 Reterm 345KV Line Old J7

645

A.0001319.009 Canyon West Sub W40 Term Upgr

646

A.0001325.006 W77-T75Recond ArrowheadRandall

647

A.0001326.003 Yoakum 230/115 Transformer 2 Upgrad

648

A.0001359.001 Castro Co Terminal Orion Wind

649

A.0001577.004 Hale-Xmsn Serving Generation

650

A.0002049.001 Potash Sub 115 kV Terminal Sub

651

A.0000303.062 V04 Structure Replacement

652

A.0000303.063 V04 Structure Replacement ROW

653

A.0000424.274 K23 Term Str Replacement

654

A.0000499.027 Y79 ELR Maintanence

655

A.0000514.006 Pecos Sub Relay Upg-Carlsbad

656

A.0000628.003 W26 Cooper Rch Oil Ctr Wreck Out Rb

657

A.0000640.039 Sundown Bkr/Sw

658

A.0001030.010 U01 1 U01 14 Circuit DC with U25

659

A.0001061.008 Purnell Sub

660

A.0001167.025 Lamb Co Intg 115kV SPE Relay UPGS T

661

A.0001167.034 Cochran V56 Line SPE Relay Upgrades

662

A.0001219.010 T74 AMA SOUTH ELR RFL9300 SPS TX

663

A.0001219.011 T78 MOORE CO ELR RFL9300 SPS TX

664

A.0001244.001 Terry Co Sub V24 Term Upgrade

Base Period Ending Balance September 30, 2020
63,117
12,127 522 (6) 25,607 44,396 29,139 683 1,291 -

Expenditures During Period Oct 2020 - Feb 2021
837,727
53,563 58,943 42,227 2,966 52,606 18,868 136,802 -

Closings During Period Oct 2020 - Feb 2021
(63,950)
-
6 -

Ending Balance Feb 2021 (1) 836,894 65,690 59,465 (0) 67,834 47,362 81,745 19,551 138,093 -

Schedule B-4 Page 30 of 34 Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Construction Work in Progress

(a) Base Period, (b) Test Year Period

Line

No.

Project No.

Project Description

665

A.0001244.003 V24 T Line

666

A.0001383.002 TxDot T 37 Relocate ROW

667

A.0001384.002 Inst W76 115KV 2-1 Wy Sw_XCEL PORT

668

A.0001388.001 Hereford NE Dist Xfmr Add Tam Sub

669

A.0001399.001 Yuma CT/PT Metering

670

A.0001402.007 K91 Newhart Plant X Upgrade

671

A.0001408.005 Sisko Sub TAM

672

A.0000290.010 Eddy County 4K40 ABB Breaker

673

A.0000303.064 T53 PPR Schld pole Replacement

674

A.0000303.067 K90 Str Rpl PPR

675

A.0000303.069 W07 Str Rpl PPR

676

A.0000303.083 T79 Str Rpl PPR

677

A.0000303.090 K24 Str Rpl PPR

678

A.0000303.092 K86 Str Rpl PPR

679

A.0000424.271 K86 Str Rpl PPR

680

A.0000424.272 U38 Lynch to Maddox

681

A.0000499.029 Z65 ELR Maintenance

682

A.0000499.030 Z36 ELR Maintenance

683

A.0000499.031 T68 ELR Maintenance

684

A.0000499.033 T78 Str Rpl

685

A.0000499.052 T52 Str Rpl

686

A.0000795.009 Kirby Fiber Ring Sub

687

A.0000795.010 Kirby Jericho T-52 115kV Line

688

A.0001033.005 Rolling Hills-NW K59 Line

689

A.0001033.006 Rolling Hills-NW K85 Line

690

A.0001033.007 Rolling Hills W46 Terminal Sub

691

A.0001033.008 Northwest W46 Terminal Sub

692

A.0001041.002 Sundown V55 Term Upgrade

693

A.0001041.003 Carlisle String Bus Upgrade

694

A.0001044.002 Castro Co 115kV Sub Term Upgrade

695

A.0001044.004 Hereford 115kV Sub Term Upgrade U44

696

A.0001044.005 Hereford NE 115kV Sub Term Upgrade

697

A.0001044.012 U42 DSTG-TIBL 115kV T-Line

698

A.0001044.013 U47 TIBL-CAWE 115kV T-line

699

A.0001044.014 U48 TIBL-CSCO 115kV T-Line

700

A.0001044.015 U46 TIBL-HFNE 115kV T-Line

701

A.0001044.018 U43 DSTG-TIBL 115kV T-Line

702

A.0001044.020 U45 TIBL-HFRD 115kV T-line

703

A.0001044.021 Canyon West 115kV Sub Term Upgrade

704

A.0001044.024 Hereford 115kV Sub Term Upgrade-U45

705

A.0001044.027 Deaf Smith 115kV Bus Split

706

A.0001059.006 Potter Tertiary Reactors Relay Upga

707

A.0001079.011 Quincy Land

708

A.0001167.068 Seminole W11 SPE Relay UPGS TX

709

A.0001167.071 Higgs T89 SPE Relay UPGS TX

Estimated Completion
Date 2/25/2020 4/14/2020 9/30/2020 5/14/2021 9/30/2020 4/30/2020 4/15/2021 7/31/2020 3/20/2020 5/21/2020 9/30/2020 6/30/2020 6/30/2020 5/21/2020 5/14/2021 5/14/2021 9/30/2020 6/30/2020 6/30/2020 6/30/2020 6/30/2020 5/29/2020 5/29/2020 5/15/2021 5/15/2021 5/15/2021 5/15/2021 4/15/2021 4/15/2021
11/15/2021 11/15/2021 11/15/2021 11/15/2021 11/15/2021 11/15/2021 11/15/2021 11/15/2021 11/15/2021 11/15/2021 11/15/2021
2/15/2022 5/15/2021 9/11/2020 12/18/2020 1/22/2021

Estimated Cost of Project 131,002 192,863 1,122,844 494,784 90,311 1,009,113 968,621 513,908 1,772,575 924,592 142,553 184,256 768,827 848,443 267,944 255,823 825,819 118,762 338,797 464,348 514,273 201,982 495,497 296,097 1,210,478 469,792 325,351 421,265 253,102 212,208 588,585 260,822 440,934 1,343,853 199,319 618,590 331,426 1,525,227 253,816 871,676 1,752,661 793,259 508,551 155,272 165,619

Base Period Beginning Balance -
October 1, 2019 7,588 -
34,115 -

Expenditures Through End of Base Period
175,597 1,187,912 1,006,387
16,600 102,505 856,859
52,134 679,908 1,246,815 739,525 110,362 165,915 693,946 676,056
47,371 36,078 659,860 101,113 288,284 371,587 488,864 201,982 445,493 21,724 18,645
8,035 10,071 23,375 28,384 28,716 31,755 28,760 24,482
4,683 1,734 8,874 8,340 16,043 20,501 55,880 42,412 33,151 508,551 34,649 44,437

Closings Through End of Base Period
(183,185) (1,187,912) (1,040,502)
(102,505) (856,859)
(679,908) (1,246,815) (739,525) (110,362) (165,915) (693,946) (676,056)
(659,860) (101,113) (288,284) (371,587) (488,864) (201,982) (445,493) (508,551) -

Schedule B-4 Page 31 of 34 Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Construction Work in Progress

(a) Base Period, (b) Test Year Period

Line

No.

Project No.

Project Description

665

A.0001244.003 V24 T Line

666

A.0001383.002 TxDot T 37 Relocate ROW

667

A.0001384.002 Inst W76 115KV 2-1 Wy Sw_XCEL PORT

668

A.0001388.001 Hereford NE Dist Xfmr Add Tam Sub

669

A.0001399.001 Yuma CT/PT Metering

670

A.0001402.007 K91 Newhart Plant X Upgrade

671

A.0001408.005 Sisko Sub TAM

672

A.0000290.010 Eddy County 4K40 ABB Breaker

673

A.0000303.064 T53 PPR Schld pole Replacement

674

A.0000303.067 K90 Str Rpl PPR

675

A.0000303.069 W07 Str Rpl PPR

676

A.0000303.083 T79 Str Rpl PPR

677

A.0000303.090 K24 Str Rpl PPR

678

A.0000303.092 K86 Str Rpl PPR

679

A.0000424.271 K86 Str Rpl PPR

680

A.0000424.272 U38 Lynch to Maddox

681

A.0000499.029 Z65 ELR Maintenance

682

A.0000499.030 Z36 ELR Maintenance

683

A.0000499.031 T68 ELR Maintenance

684

A.0000499.033 T78 Str Rpl

685

A.0000499.052 T52 Str Rpl

686

A.0000795.009 Kirby Fiber Ring Sub

687

A.0000795.010 Kirby Jericho T-52 115kV Line

688

A.0001033.005 Rolling Hills-NW K59 Line

689

A.0001033.006 Rolling Hills-NW K85 Line

690

A.0001033.007 Rolling Hills W46 Terminal Sub

691

A.0001033.008 Northwest W46 Terminal Sub

692

A.0001041.002 Sundown V55 Term Upgrade

693

A.0001041.003 Carlisle String Bus Upgrade

694

A.0001044.002 Castro Co 115kV Sub Term Upgrade

695

A.0001044.004 Hereford 115kV Sub Term Upgrade U44

696

A.0001044.005 Hereford NE 115kV Sub Term Upgrade

697

A.0001044.012 U42 DSTG-TIBL 115kV T-Line

698

A.0001044.013 U47 TIBL-CAWE 115kV T-line

699

A.0001044.014 U48 TIBL-CSCO 115kV T-Line

700

A.0001044.015 U46 TIBL-HFNE 115kV T-Line

701

A.0001044.018 U43 DSTG-TIBL 115kV T-Line

702

A.0001044.020 U45 TIBL-HFRD 115kV T-line

703

A.0001044.021 Canyon West 115kV Sub Term Upgrade

704

A.0001044.024 Hereford 115kV Sub Term Upgrade-U45

705

A.0001044.027 Deaf Smith 115kV Bus Split

706

A.0001059.006 Potter Tertiary Reactors Relay Upga

707

A.0001079.011 Quincy Land

708

A.0001167.068 Seminole W11 SPE Relay UPGS TX

709

A.0001167.071 Higgs T89 SPE Relay UPGS TX

Base Period Ending Balance September 30, 2020
16,600 52,134 47,371 36,078 21,724 18,645 8,035 10,071 23,375 28,384 28,716 31,755 28,760 24,482 4,683 1,734 8,874 8,340 16,043 20,501 55,880 42,412 33,151 34,649 44,437

Expenditures During Period Oct 2020 - Feb 2021
74,499 178,129 (60,151) 563,303 (166,000) 43,757 44,918 1,700 62,971 307,692 83,131 61,388 133,779 75,246 4,919 28,659 14,086 15,226 21,215 14,147 55,016 23,342 23,532 22,820 30,832 38,452 373,319 65,724 112,782

Closings During Period Oct 2020 - Feb 2021
(74,499) 60,151 166,000 (1,700) (100,372) (157,219)

Ending Balance Feb 2021 (1) 194,729 615,437 91,128 80,995 84,695 326,337 91,166 71,458 157,154 103,630 33,635 60,414 42,846 39,708 25,898 15,881 63,890 31,682 39,575 43,321 86,711 80,864 406,469 -

Schedule B-4 Page 32 of 34 Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Construction Work in Progress

(a) Base Period, (b) Test Year Period

Line

No.

Project No.

Project Description

710

A.0001167.110 Maddox, SPE Relay Upgrades

711

A.0001219.013 T74 OWEND COR ELR RFL9300 SPS TX

712

A.0001219.017 T79 MOORE CO ELR RFL9300 SPS TX

713

A.0001228.002 McDowell Creek Transformer

714

A.0001228.007 Dumas 19th St Sub LRU

715

A.0001291.002 Denver City Bkr Rplc W950

716

A.0001291.003 Denver City Bkr Rplc W975

717

A.0001314.008 V15 Tuco Indiana Line

718

A.0001383.004 TxDot Z-33 Relocate

719

A.0001396.003 Legacy - Robertson ROW

720

A.0001402.006 J15 Crossroads Tolk Upgrade TX

721

A.0001402.009 K21 Deaf Smith Plant X Upgrade

722

A.0001402.011 K42 Tolk Tuco Upgrade

723

A.0001402.013 J14 Eddy Co Crossroads Upgrade NM

724

A.0001402.017 Tolk Spare 345kV XFMR

725

A.0001402.019 J15 Reterm Line, Tolk

726

A.0001402.020 Crossroads Relay Upgrade, J15 Term

727

A.0001418.002 Four Way T27 Line

728

A.0001419.007 T97 Line Re-Termination

729

A.0001440.001 Spearman Sub, T87 Term

730

A.0001440.002 T87, Line, Str Rplcmnts

731 Subtotal - Transmission

732

Projects < $100,000

733 Total Construction Work In Progress

Estimated Completion Date is the estimated In-Service Date, or closing pattern, from the forecast. However, if the September 2020 balance is zero due to closings, then the actual In-Service date is presented or "Routine Actual Closings" if the actual closings are on routine work orders.
(c) Explanation of Adjustments (1) Southwestern Public Service Company is not requesting CWIP in Rate Base.

Estimated Completion
Date 5/14/2021
10/28/2021 4/23/2021 4/16/2022
11/12/2021 3/15/2021 3/15/2021
10/15/2022 12/31/2020 Closing Pattern
4/30/2020 8/31/2020 4/30/2020 4/30/2020 12/15/2021 11/15/2021 11/15/2021 2/15/2022 4/15/2021 4/15/2021 4/15/2021

Estimated Cost of Project 592,748 230,941 193,298 5,614,039 379,028 463,072 379,828 18,397,368 (181,796) 611,100 416,066 3,607,614 1,314,935 218,650 2,943,643 1,516,261 242,932 773,384 373,277 294,666 421,681

Base Period Beginning Balance -
October 1, 2019 -

$

168,498,441

Expenditures Through End of Base Period
90,053 570
1,291 2,923 3,429 70,441 40,828 26,195 79,415 5,800 385,359 2,881,186 1,006,815 194,244 3,047 48,157 5,818 20,137 43,102 20,454 20,689
$ 286,054,421

Closings Through End of Base Period
(385,359) (2,881,186) (1,006,815) (194,244) -
$ (244,479,938)

$

5,725,049 $ 10,245,549 $ (8,007,012)

$

419,658,913 $ 1,153,690,580 $ (497,979,366)

Schedule B-4 Page 33 of 34 Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Construction Work in Progress

(a) Base Period, (b) Test Year Period

Line

No.

Project No.

Project Description

710

A.0001167.110 Maddox, SPE Relay Upgrades

711

A.0001219.013 T74 OWEND COR ELR RFL9300 SPS TX

712

A.0001219.017 T79 MOORE CO ELR RFL9300 SPS TX

713

A.0001228.002 McDowell Creek Transformer

714

A.0001228.007 Dumas 19th St Sub LRU

715

A.0001291.002 Denver City Bkr Rplc W950

716

A.0001291.003 Denver City Bkr Rplc W975

717

A.0001314.008 V15 Tuco Indiana Line

718

A.0001383.004 TxDot Z-33 Relocate

719

A.0001396.003 Legacy - Robertson ROW

720

A.0001402.006 J15 Crossroads Tolk Upgrade TX

721

A.0001402.009 K21 Deaf Smith Plant X Upgrade

722

A.0001402.011 K42 Tolk Tuco Upgrade

723

A.0001402.013 J14 Eddy Co Crossroads Upgrade NM

724

A.0001402.017 Tolk Spare 345kV XFMR

725

A.0001402.019 J15 Reterm Line, Tolk

726

A.0001402.020 Crossroads Relay Upgrade, J15 Term

727

A.0001418.002 Four Way T27 Line

728

A.0001419.007 T97 Line Re-Termination

729

A.0001440.001 Spearman Sub, T87 Term

730

A.0001440.002 T87, Line, Str Rplcmnts

731 Subtotal - Transmission

Base Period Ending Balance September 30, 2020
90,053 570
1,291 2,923 3,429 70,441 40,828 26,195 79,415 5,800
3,047 48,157 5,818 20,137 43,102 20,454 20,689

$

210,072,924

Expenditures During Period Oct 2020 - Feb 2021
175,652 18,865 90,777 53,336 41,781
273,376 216,426
22,229 50,596 10,300
(123,422)
7,626 38,805 12,320 6,368 157,019 67,550 87,093

$

91,666,866

Closings During Period Oct 2020 - Feb 2021
(130,011) (16,100) 123,422 -

$

(220,868,234)

Ending Balance Feb 2021 (1) 265,705 19,435 92,069 56,259 45,210 343,817 257,254 48,423 10,673 86,962 18,138 26,505 200,122 88,003 107,782

$

80,871,556

732

Projects < $100,000

$

7,963,586 $

36,858,925 $

(31,027,861) $

13,794,649

733 Total Construction Work In Progress

$

1,075,370,126 $

335,108,793 $ (1,236,589,713) $

173,889,206

Estimated Completion Date is the estimated In-Service Date, or closing pattern, from the forecast. However, if the September 2020 balance is zero due to closings, then the actual In-Service date is presented or "Routine Actual Closings" if the actual closings are on routine work orders.
(c) Explanation of Adjustments (1) Southwestern Public Service Company is not requesting CWIP in Rate Base.

Schedule B-4 Page 34 of 34 Sponsors: Niemi, Moeller Case No. 20-00238-UT

Schedule B-5 Page 1 of 4
Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Allowance for Funds Used During Construction Generated and Transferred to Plant in Service

(a) Base Period and Four Years Prior to Base Period, (b) Test Year Period

Line

No.

Calendar Year By Month

Effective Amount Capitalized

Monthly Rate

(Generated)

1

Jan 15

2

Feb 15

3

Mar 15

4

Apr 15

5

May 15

6

Jun 15

7

Jul 15

8

Aug 15

9

Sep 15

10

Oct 15

11

Nov 15

12

Dec 15

13 Historic Period - 12 Months Ended 12/31/2015

0.3256% $ 0.3831% 0.4188% 0.3965% 0.3965% 0.3965% 0.3965% 0.3965% 0.3935% 0.3935% 0.3838% 0.3838%
$

765,601 948,368 1,052,317 852,482 960,497 1,047,326 1,068,956 1,096,721 1,123,359 1,121,515 905,198 862,391
11,804,732

14

Jan 16

15

Feb 16

16

Mar 16

17

Apr 16

18

May 16

19

Jun 16

20

Jul 16

21

Aug 16

22

Sep 16

23

Oct 16

24

Nov 16

25

Dec 16

26 Historic Period - 12 Months Ended 12/31/2016

0.4255% $ 0.4528% 0.4806% 0.4434% 0.4568% 0.4631% 0.5037% 0.5082% 0.5082% 0.5082% 0.5082% 0.5082%
$

1,002,827 1,246,933 1,414,162 1,194,673 1,345,297 1,235,640 1,403,682 1,318,032 1,332,092 1,376,434 1,416,732 1,283,635
15,570,138

27

Jan 17

28

Feb 17

29

Mar 17

30

Apr 17

31

May 17

32

Jun 17

33

Jul 17

34

Aug 17

35

Sep 17

36

Oct 17

37

Nov 17

38

Dec 17

39 Historic Period - 12 Months Ended 12/31/2017

0.4182% $ 0.3905% 0.4395% 0.4339% 0.4339% 0.4339% 0.4630% 0.4630% 0.4630% 0.4695% 0.4695% 0.4695%
$

1,074,885 1,009,066 1,390,255 1,226,368 1,121,638
650,511 1,186,356 1,252,832 1,362,996 1,470,759 1,446,592 1,504,253
14,696,511

40

Jan 18

41

Feb 18

42

Mar 18

43

Apr 18

44

May 18

45

Jun 18

46

Jul 18

47

Aug 18

48

Sep 18

49

Oct 18

50

Nov 18

51

Dec 18

52 Historic Period - 12 Months Ended 12/31/2018

0.4892% $ 0.5100% 0.5066% 0.5066% 0.5324% 0.5324% 0.5423% 0.5423% 0.5423% 0.5423% 0.5423% 0.5423%
$

1,686,871 1,864,412 1,636,729 1,470,429 1,516,849 1,746,044 2,041,732 2,524,438 2,675,000 3,104,604 3,652,672 4,140,967
28,060,746

Amount Transferred To Plant

$

52,717

1,948,935

389,426

521,286

762,718

453,997

610,068

764,782

370,540

2,955,240

3,380,443

1,008,900

$

13,219,053

$

12,605

244,796

1,074,441

432,011

2,002,606

1,127,778

741,752

631,375

1,190,088

1,018,804

385,111

3,881,550

$

12,742,918

$

58,399

208,330

476,054

2,604,045

824,097

1,275,427

123,465

258,847

172,492

641,507

1,638,012

3,615,232

$

11,895,907

$

180,445

1,386,879

3,668,255

1,789,938

3,868,606

1,455,830

436,532

161,950

434,386

264,358

762,288

3,500,620

$

17,910,089

Schedule B-5 Page 2 of 4
Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Allowance for Funds Used During Construction Generated and Transferred to Plant in Service

(a) Base Period and Four Years Prior to Base Period, (b) Test Year Period

Line

No.

Calendar Year By Month

Effective Amount Capitalized

Monthly Rate

(Generated)

53

Jan 19

54

Feb 19

55

Mar 19

56

Apr 19

57

May 19

58

Jun 19

59

Jul 19

60

Aug 19

61

Sep 19

62

Oct 19

63

Nov 19

64

Dec 19

65 Historic Period - 12 Months Ended 12/31/2019

0.5582% 0.5659% 0.5615% 0.5615% 0.5615% 0.5461% 0.5461% 0.5461% 0.5463% 0.5463% 0.5463% 0.5464%
$

4,719,079 4,985,809 5,112,066 5,107,496 5,304,554 2,425,963 1,032,583 1,552,074 2,073,369 2,176,689 2,236,580 2,399,831
39,126,095

66

Oct 19

67

Nov 19

68

Dec 19

69

Jan 20

70

Feb 20

71

Mar 20

72

Apr 20

73

May 20

74

Jun 20

75

Jul 20

76

Aug 20

77

Sep 20

78 Base Period - 12 Months Ended 9/30/2020

0.5463% $ 0.5463% 0.5464% 0.5425% 0.5462% 0.5408% 0.5408% 0.5408% 0.5408% 0.5408% 0.5408% 0.5408%
$

2,176,689 2,236,580 2,399,831 2,614,547 2,843,120 3,032,963 3,529,587 3,799,579 3,941,995 4,377,125 4,821,184 5,367,637
41,140,838

79

Oct 20

0.5408%

80

Nov 20

81

Dec 20

0.5408% 0.5408%

82

Jan 21

0.5408%

83

Feb 21

0.5408%

84 Known and Measurable - 10/01/2020 - 02/28/2021

$

5,563,339 5,461,677 3,011,337
507,955 626,448
15,170,757

85 Test Year Period (Base Period Plus Known and Measurable Adjustments)

$

56,311,595

(c) Explanation of Adjustments AFUDC rates through September 2020 are based on actual monthly data. AFUDC rates for October 2020 through February 2021 are based on forecast data.

Amount Transferred To Plant

348,596 151,292 905,995 735,776 5,990,496 31,348,922 40,153 95,906 113,257 665,603 741,249 2,663,723

$

43,800,967

$

665,603

741,249

2,663,723

45,474

1,371,934

261,357

220,981

9,398,143

486,016

300,088

171,721

165,840

$

16,492,128

$

2,232,982

2,915,869

35,362,199

513,109

54,134

$

41,078,292

$

57,570,420

Schedule B-5 Page 3 of 4
Sponsors: Niemi, Moeller Case No. 20-00238-UT
Southwestern Public Service Company (a), (b), (c) Explanation of Allowance for Funds Used During Construction
Southwestern Public Service Company ("SPS") currently uses an overhead mechanism for assigning costs to construction when the practice is too onerous to charge directly or the mechanism is required by Federal Energy Regulatory Commission ("FERC") rules. The Allowance for Funds Used During Construction ("AFUDC") overhead is discussed below.
Allowance for Funds Used During Construction AFUDC allows the capitalization of the cost of borrowed funds and a reasonable rate on other funds to be charged to projects that are capital in nature until the project is placed in-service. This overhead is excluded from any project that is de minimus or is purchased as an asset and can be placed in-service immediately. The following excerpt from the Uniform System of Accounts for Electric Utilities (18 C.F.R. § 101) defines the methodology employed at SPS.
Federal Energy Regulatory Commission Pt. 101 (17) Allowance for funds used during construction (Major and Non-major Utilities) includes the net cost for the period of construction of borrowed funds used for construction purposes and a reasonable rate on other funds when so used, not to exceed, without prior approval of the Commission, allowances computed in accordance with the formula prescribed in paragraph (a) of this subparagraph. No allowance for funds used during construction charges shall be included in these accounts upon expenditures for construction projects, which have been abandoned.
(a) The formula and elements for the computation of the allowance for funds used during construction shall be:
Ai=s*(S/W)+d*(D/D+P+C)*(1-S/W) Ae=[1-S/W]*[p*(P/D+P+C)+c*(C/D+P+C)]
Ai=Gross allowance for borrowed funds used during construction rate. Ae=Allowance for other funds used during construction rate. S=Average short-term debt. s=Short-term debt interest rate. D=Long-term debt. d=Long-term debt interest rate. P=Preferred stock. p=Preferred stock cost rate. C=Common equity. c=Common equity cost rate. W=Average balance in construction work in progress, less asset retirement
costs (See General Instruction 25) related to plant under construction.

Schedule B-5 Page 4 of 4
Sponsors: Niemi, Moeller Case No. 20-00238-UT
(b) The rates shall be determined annually. The balances for long-term debt, preferred stock, and common equity shall be the actual book balances as of the end of the prior year. The cost rates for long-term debt and preferred stock shall be the weighted average cost determined in the manner indicated in § 35.13 of the Commission's Regulations under the Federal Power Act. The cost rate for common equity shall be the rate granted common equity in the last rate proceeding before the ratemaking body having primary rate jurisdictions. If such cost rate is not available, the average rate actually earned during the preceding three years shall be used. The short-term debt balances and related cost and the average balance for construction work in progress shall be estimated for the current year with appropriate adjustments as actual data becomes available.
The AFUDC rate, a simple rate, is calculated using the above formula (effective with the issuance of Federal Power Commission Order No. 561 on February 2, 1977). It uses the various components of capital, including the cost of short and long-term debt (including restricted-use debt, as required by Accounting Release No. 13, effective May 1, 1983), and preferred and common stock. The rate is applied against the current month's AFUDC base (prior month's lifeto-date construction charges plus one-half of the current month's charges, less one-half of the current month's classifications, and the prior month's AFUDC) for eligible jobs to determine the amount of the monthly AFUDC. FERC allows for semi-annual compounding and this is maintained through the determination of an effective monthly rate using monthly compounding that effectuates the semi-annual compounding effect of the simple rate.
Accounts "419.1 ­ Allowance for Other (Equity) Funds Used During Construction" and "432 ­ Allowance for Borrowed Funds Used During Construction" are credited, in accordance with the ratio derived in the AFUDC formula, with the concurrent debit to Account 107, Construction Work in Progress ("CWIP") by work order. The rate is calculated as amounts in CWIP change, the financing arrangements warrant an updated rate, and adjustments are made to reallocate total AFUDC between the debt and equity components. AFUDC is directly calculated and charged to each work order; no clearing account is used.
FERC's definition of AFUDC includes the net cost (during the period of construction) of borrowed funds used for construction purposes and a reasonable rate on other funds when so used. Pages 1 and 2 of Schedule B-5 list the capitalization rates for the years preceding the base period, the base period, the test year (base period plus known and measurable adjustments) and the amounts generated and transferred to plant-in-service in each of those years.

Southwestern Public Service Company Plant Held for Future Use

(a) Base Period, (b) Test Year Period

Line

No.

Description

Anticipated Use

In Service Date

1 Gaines County Land Acquisition Land for Future Production Facility

2021+

Date of Purchase
8/15/2015

Base Period Balance at
9/30/20

$

4,167,109

Adjustments

$

(4,167,109) $

Test Year Period
-

2 Total Plant Held for Future Use

$

4,167,109 $

(4,167,109) $

-

(c) Explanation of Adjustments Please refer to the Direct Testimony of Stephanie N. Niemi regarding removal of Plant Held for Future Use.

Schedule B-6 Page 1 of 1
Sponsors: Niemi, Moeller Case No. 20-00238-UT

Southwestern Public Service Company Nuclear Fuel in Process

Schedule B-7 Page 1 of 1
Sponsor: Grant Case No. 20-00238-UT

Southwestern Public Service Company has no nuclear facilities. Therefore, this schedule is not applicable.