Loading...
HomeMy WebLinkAboutU-1034-99 Exhibit 6 Schultz.pdf- - - - Li n e No . Pa r t i c u l a r s (a ) 1 Co s t o f S e r v i c e : 2 Op e r a t i n g R e v e n u e s - 3 Ga s s a l e s 4 Ot h e r 5 To t a l 6 Op e r a t i n g E x p e n s e s - 7 Co s t o f g a s 8 Op e r a t i o n a n d 9 ma i n t e n a n c e 10 De p r e c i a t i o n 11 Ge n e r a l t a x e s 12 In c o m e t a x e s 13 To t a l 14 Op e r a t i n g I n c o m e 15 Ra t e B a s e 16 Re t u r n - - - - - - - - - - - - -IN T E R M U N T A I N G A S C O M P A N CO S T O F S E R V I C E A N D I N C R E A S E D R E V E N U E R E Q U I R E TW L V E M O N T H S E N D E D J U L Y 3 1 , 1 9 8 2 AS A D J U S T E D Ac t u a l Pr o j e c t e d Te s t Y e a r Te s t Y e a r Co m p a n y Ad j u s t e d 5 M o n t h s E n d e d 7 M o n t h s E n d e d 12 M o n t h s E n d e d No r m l i z a t i o n No r m l i z e d Pr o p o s e d Te s t Y e a r 12 / 3 1 / 8 1 7/ 3 1 / 8 2 7/ 3 1 / 8 2 Ad j u s t m e n t 7/ 3 1 / 8 2 Ad j u s t m e n t s 7/ 3 1 / 8 2 (b ) (c ) (d ) (e ) (f ) (g ) (h ) $5 5 , 8 9 9 , 2 5 9 $9 0 , 5 6 4 , 0 0 0 $1 4 6 , 4 6 3 , 2 5 9 $( 9 , 4 9 6 , 0 4 0 ) $1 3 6 , 9 6 7 , 2 1 9 $ - $1 3 6 , 9 6 7 , 2 1 9 79 0 , 0 3 3 1, 2 8 0 , 0 0 0 2, 0 7 0 , 0 3 3 - 2, 0 7 0 , 0 3 3 - 2, 0 7 0 , 0 3 3 56 , 6 8 9 , 2 9 2 91 , 8 4 4 , 0 0 0 14 8 , 5 3 3 , 2 9 2 (9 , 4 9 6 , 0 4 0 ) 13 9 , 0 3 7 , 2 5 2 - 13 9 , 0 3 7 , 2 5 2 46 , 2 8 2 , 7 9 7 71 , 3 8 2 , 0 0 0 11 7 , 6 6 4 , 7 9 7 (5 , 4 1 3 , 8 0 4 ) 11 2 , 2 5 0 , 9 9 3 - 11 2 , 2 5 0 , 9 9 3 5, 5 4 2 , 1 6 2 8, 4 9 4 , 0 0 0 14 , 0 3 6 , 1 6 2 - 14 , 0 3 6 , 1 6 2 1, 3 5 6 , 9 7 6 15 , 3 9 3 , 1 3 8 1, 4 9 7 , 8 2 9 2, 2 0 3 , 0 0 0 3, 7 0 0 , 8 2 9 - 3, 7 0 0 , 8 2 9 (3 , 8 1 0 ) 3, 6 9 7 , 0 1 9 1, 1 8 4 , 6 4 1 2, 2 9 4 , 0 0 0 3, 4 7 8 , 6 4 1 - 3, 4 7 8 , 6 4 1 18 , 2 9 8 3, 4 9 6 , 9 3 9 46 3 , 0 6 3 2, 8 9 9 , 0 0 0 3, 3 6 2 , 0 6 3 (2 , 0 2 1 , 1 1 5 ) 1, 3 4 0 , 9 4 8 (7 5 1 , 7 5 9 ) 58 9 , 1 8 9 54 , 9 7 0 , 4 9 2 87 , 2 7 2 , 0 0 0 14 2 , 2 4 2 , 4 9 2 (7 , 4 3 4 , 9 1 9 ) 13 4 , 8 0 7 , 5 7 3 61 9 , 7 0 5 13 5 , 4 2 7 , 2 7 8 $ 1 . 7 1 8 . 8 0 0 $ 4 . 5 7 2 . 0 0 0 $ 6. 2 . 2 0 , 8 0 0 $( 2 . 0 6 1 , 1 2 1 ) $ 4, 2 2 9 , 6 7 9 $ ( 6 1 9 , 7 0 5 ) $ 3. 6 0 9 . ~ m , - - Pr o p o s e d Re v e n u e De f i c i e n c y (i ) $1 0 , 0 9 7 , 6 1 7 10 , 0 9 7 , 6 1 7 4, 9 9 9 , 3 3 0 4, 9 9 9 , 3 3 0 $ 5 . 0 9 8 . 2 8 7 - - - In t e r m o u n t a i n G a s C o m p a n y Ca s e N o . U - L 0 3 4 - 9 9 Ex h i b i t 6 Sc h e d u l e 1 Wi t n e s s : S c h u l t z Co s t o f S e r v i c e an d R e q u i r e d Re v e n u e s (j ) $1 4 7 , 0 6 4 , 8 3 6 " 2, 0 7 0 , 0 3 3 14 9 , 1 3 4 , 8 6 9 11 2 , 2 5 0 , 9 9 3 15 , 3 9 3 , 1 3 8 3, 6 9 7 , 0 1 9 3, 4 9 6 " , 9 3 9 5, 5 8 8 , 5 1 9 14 0 , 4 2 6 , 6 0 8 $ 8 . 7 0 8 . 2 6 1 $ 7 4 , 7 8 1 . 1 2 0 11 , 6 4 5 % I I I I I Line I No. I 1 2 I 3 4 5 I 6 7 I 8 9 I 10 I I I I I I I I I I I INTERMOUNTAIN GAS COMPAN Intermountain Gas Company Case No. U-1034-99 Exhibit 6 Schedule 2 Witness: Schultz GAS SALES - NORMLIZATION ADJUSTMENT TWELVE MONTHS ENDING JULY 31, 1982 Description (a) Actual 12 Months Ended December 31, 1981 Adjustments: Base year rate changes ànd customer contract chànges Weather normalization Customer volume changes Projected sales decline Test Year as Adjusted Test Year Ended July 31, 1982 Adjustment Required Therms Amount (b)(c) 306,641,100 $141,397,444 20,720 8,512,067 (66,206,799) (6,192,427) 27,369,019 4,809,489 (33,082,485) (3,526,248) 242,774,661 136 , ~6 7, 219 146,463,259 $ (9.496,040) I I I I I I I I I I I I I I I I I I I I I I INTERMOUNTAIN GAS COMPAN Intermountain Gas Company Case No. U- 1034-99 Exhibit 6 Schedule 3 Witness: Schultz COST OF GAS - NORMLIZATION ADJUSTMENT TWELVE MONTHS ENDING JULY 31 t 1982 Line No.Description (a) 1 2 3 4 PURCHASE REQUIREMENTS (THERMS): Gas Sales Company Use Unaccounted for gas 5 6 7 8 9 10 11 12 13 14 15 GAS PURCHASES: ODL - Demand Commodity SGS - Demand Seasonal Demand Commodity LS- 1 - Demand Capacity Liquefaction Vaporization 16 Test Year as Adjusted Test Year Ended July 31, 1982 245,245,835 17 18 Normalization Adjustment *Non-add demand units **4/1/82 rates Twelve Months Ended 12/31/81 (b) 306,641,100 471,174 2,000,000 309,112.274 Requirements 1,630,235* 236,634,835 239,204* 8,611 ,000* 8,611 ,000 720,000* 7,705,200* 1,877 ,000* 1,877 ,000* Adjustment (c) (63,866,439) (63,866,439) Rate** '$.15680 .42562 .15300 .01069 .42772 .03376 .03854 .01092 .00410 Test Year 7/31/82 Normalized (d) 242,774,661 471,174 2,000,000 245,245,835 Amount $ 3,067,450 100 , 716 , 5 1 8 256,187 644,361 3,683,097 291,686 3,563,501 20,497 7,696 112,250,993 117,664,797 $ (5.413,804) I I I I I Line I No. I 1 2 I 3 4 5 I 6 7 8 I 9 10 11 I 12 13 I 14 15 I 16 17 I 18 19 20 I 21 22 I 23 24 I 25 26 27 I 28 29 I 30 31 32 I I I Intermountain Gas Company Case No. U-I034-99 Exhibit 6 Schedule 4 Page 1 of 4 Witness: SchultzINTERMOUNTAIN GAS COMPAN ADJUSTMENTS TO TEST YEAR COST OF SERVICE TWELVE MONTHS ENDING JULY 31, 1982 Description (a) OPERATION AND MAINTENANCE EXPENSES 1. Salar ies and Wages: Annualization of payroll for the month ended July 31, 1982 Wage increases to be paid for period 8/1/82-7/31/83 Amortization of deferred vacation pay expense included in pro-jected data $ Total deferral to be amortized Adjustment required Accrued vacation expense~ 11 /28/82 $ Average annualized wage increase Adjustment required Total Salary and Wage Adjustment 2. Employee Pension Expense: Test year as adjusted Test year ended July 31, 1982 Adjustment required 3. Group Insurance Expense: Test year as adjusted Test year ended July 31, 1982 Adjustment required 4. Other Insurance Expense: Test year as adjusted Test year ended July 31, 1982 Adjustment required 5. Regulatory Commission Expense: Test year as adjusted Test year ended July 31, 1982 Adjustment required Amount (b) $316,610 460,552 233,331 397,007 163,676 397,007 9.3% 36,922 $977,760 498,335 447,687 50,648 685,666 615,978 69,688 391,551 409,793 (18,242) 478,831 456,260 22,571 I I I I I I I I I I I I I I I I I I I I I I \ Line No. 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 INTERMOUNTAIN GAS COMPAN Intermountain Gas Company Case No. U-1034-99 Exhibit 6 Schedule 4 Page 2 of 4 Witness: Schultz ADJUSTMENTS TO TEST YEAR COST OF SERVICE TWELVE MONTHS ENDING JULY 31, 1982 Description (a) 6.Provision for Bad Debts: Test year sales revenue in- cluding normalization and revenue deficiency (est.) Provision rate per dollar Adjusted test year provision Test year ended July 31, 1982 - 5 months ending 12/31/81 Supplemen tal provision booked 7/81 7 months ended 7/31/82 Adjustment required 7.Removal of amortization of deferred bad debt expense in order to match revenues stated at 4/1/82 rates 8.Weatherization and Financing Program Expenses: A. Weatherization expenses - Test year as adjusted Test year ended July 31, 1982 Adjustment required B. Water Heater and Retrofit Rebate Program - Test year as adjusated Test year ended July 31, 1982 Adjustment required C. Other Administrative Expenses - Test year as adjusted Test year ended July 31, 1982 Adjustment required 9.Refund of C & K Exploration Advances: Normlized therm sales level Refund rate per Case U-1034-96 Test year as adjusted Test year ended July 31, 1982 Adjustment required 340,814 (125,000) 561,204 242,774,661 .00088 Amount (b) $150,000,000 .006 900,000 777,018 122,982 (356,352) 45,600 72,743 (27,141) 300,700 300,700 16.,605 16,605 (213.642) (106,923) (106,719) I I I I I I I I I I I I I I I I I I I I I I INTERMOUNTAIN GAS COMPAN In termoun tain Gas Company Case No. U-1034-99 Exhibit 6 Schedule 4 Page 3 of 4 Witness: Schultz ADJUSTMNTS TO TEST YEA COST OF SERVICE TWELVE MONTHS ENDING JULY 31, 1982 Line No.Description Amount (a)(b) 71 10.Price Level Adjustment for 72 Other Non-Payroll Operation 73 and Maintenance Expenses: 74 Total 0 & M expense 12 75 months ending 7/31/82 14,036,162 76 o & M expenses separately 77 adjusted - 78 Salaries and wages $6,869,238 79 Amortization of vacation 80 accrual 233,331 81 Employee pension expense 447,687 82 Group insurance expense 615,978 83 Other insurance expense 409,793 84 Regulatory commission 85 expense 456,260 86 Provision for bad debts 777 ,018 87 Amortization of deferred 88 bad debt expense 356,352 89 RCS and weatherization 90 expenses 72,743 91 Water heater and retrofit 92 reba te expenses 93 Other f inanc ing program 94 expenses 95 Refund of C & K Exploration 96 advances (106,923)10,131,477 97 0 & M expenses not separately 98 adjusted 3,904,685 99 Price level factor (CPI-U for 100 11/80 -10/81)7.70% 101 Adjustment required 300,661 102 11.Conference Center Adjustment (13,344) 103 12.Amortization of underground storage study writeoff 17,16 i 104 Total Operation and Maintenance Expense Adjustment ll6.976 105 DEPRECIATION EXPENSE 106 Monthly depreciation provision 107 applicable to conference center $635 108 x . 12 109 Annual depreciation provision 7,620 110 Adjustment factor 50% 111 Adjustment required $(3.810) I I I I I Line No. I 112 I 113 114 115 I 116 117 118 I 119 120 I 121 122 I 123 124 I 125 126 I 127 128 129 I 130 131 132 I 133 134 135 I 136 137 I 138 139 I 140 141 I 142 143 I 144 I 145 146 I INTERMOUNTAIN GAS COMPAN Intermountain Gas Company Case No. U-1034-99 Exhibit 6 Schedule 4 Page 4 of 4 Witness: Schultz ADJUSTMENTS TO TEST YEA COST OF SERVICE TWELVE MONTHS ENDING JULY 31. 1982 Description (a) GENERA TAXES 1. Property Taxes: Taxable base ê 12/31/81 Levy rate Test year as adjusted Test year ended July 31. 1982 Adjustment required 2. Payroll Taxes: Test year as adjusted Test year ended July 31. 1982 Adjustment required Total General Taxes Adjustment INCOME TAXES ê STATUTORY RATES Operating Revenues Operating Expenses (except income taxes) Income before interest and income taxes Interest charges - Rate base L/T & SIT debt weighted average interest cost (schedule 5) State Taxable Income Less State Taxes ê 6 1/2% Federal Taxable Income Federal Taxes ê 46% Less - surtax exemption ITC amortization Net Federal Tax State Tax Amortization of Unfunded Future Tax Liab il ity Income taxes for test year as adjusted Test year ended July 31, 1982 Adjustment required $ 64.187.791 1.023257% $ 74,781.120 4.313% Amount (b) 656,806 702,154 (45,348) 626.205 562.559 63,646 $18,298 $139,037.252 134.838,089 4.199,163 3.225,310 973,853 63.300 L- 910.553 418,854 (19.875) (116,000) 282,979 63.300 242,910 589.189 1.340,948 $ (751,759) - - - - - - - - - - - - - - - - - - - - - - Li n e No . 1 2 3 4 5 6 7 8 IN T E R M O U N T A I N G A S C O M P A N Y CA P I T A L S T R U C T U R E A N D C O S T O F C A P I T A L AS O F J U L Y 3 1 , 1 9 8 2 IN C L U D I N G U N A M O R T I Z E D I N V E S T M E N T T A X C R E D I T S Cl a s s o f Ca p i t a l (a ) Re q u i r e d Ad j u s t m e n t (c ) As Pe r c e n t Ad j u s t e d of T o t a l (d ) (e ) $ 2 , 0 6 8 , 2 5 0 2. 7 3 0 % 30 , 8 2 1 , 2 5 0 40 . 6 8 9 6, 1 4 6 , 2 5 0 8. 1 1 4 25 , 9 9 4 , 8 9 1 34 . 3 1 7 7, 6 7 7 , 8 7 7 10 . 1 3 6 3, 0 4 0 , 7 2 3 4. 0 1 4 $7 5 . 7 4 9 . 2 4 1 lO O . _ O O Q % Am o u n t Ou t s t a n d i n g (b ) Sh o r t - T e r m D e b t $ 2 , 0 6 8 , 2 5 0 $ Lo n g - T e r m D e b t 30 , 8 2 1 , 2 5 0 Pr e f e r r e d E q u i t y 6, 1 4 6 , 2 5 0 Co m m o n E q u i t y 28 , 3 0 6 , 0 0 0 (2 , 3 1 1 , 1 0 9 ) De f e r r e d I n c o m e Ta x e s 7, 6 7 7 , 8 7 7 Un a m o r t i z e d I T C 3, 0 4 0 , 7 2 3 To t a l $7 8 . 0 6 0 . 3 5 0 $( 2 . 3 1 1 . 1 0 9 ) lI L I T a n d S I T d e b t w e i g h t e d av e r a g e i n t e r e s t c o s t : LI T d e b t SI T d e b t 3. 8 6 3 % .4 5 0 4. 3 1 3 % In t e r m o u n t a i n G a s C o m p a n y Ca s e N o . U - 1 0 3 4 - 9 9 Ex h i b i t 6 Sc h e d u l e 5 Wi t n e s s : S c h u l t z We i g h t e d Ef f e c t i v e A v e r a g e C o s t Co s t R a t e o f C a p i t a l (f ) (g ) .4 5 0 % l I 3. 8 6 3 I I 16 . 5 0 0 % 9. 4 9 4 8. 4 7 6 .6 8 8 18 . 0 0 0 6. 1 7 7 11 . 6 4 5 .4 6 7 11 . 6 4 5 % I I I I I I Line No. I I 1 2 I 3 I 4 5 I 6 7 8 I 9 I 10 11 I I I I I I I I I Intermountain Gas Company Case No. U-1034-99 Exhibit 6 Schedule 6 Page 1 of 6 Wi tness : Schul t z INTERMOUNTAIN GAS COMPAN CALCULATION OF AVERAGE RATE BASE AN RETUR DOLLAS TWELVE MONTHS ENDING JULY 31, 1982 Description Amount (a)(b) Gas Plant In Service: Original cost Less accumulated depreciation $110,479,203 (38,444,368) Net Gas Plant in Service 72,034,835 Advances in Aid of Construction (94,847) Working Capital: Materials & supplies inventory LNG inventory Cash working capital 669,592 2,171,540 Overall Rate of Return $ 74,781.120 11.645% Average Rate Base Return Dollars $ 8,708,261 I I I I I I I I I I I I I I I I I I I I I I Line No.Month (a) 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 July 1981 August September October November December *January 1982 *February *March *April *May *June *July Total26 27 28 Average Balance INTERMOUNTAIN GAS COMPANY GAS PLAT- IN-SERVICE ORIGINAL COST TWLVE MONTHS ENDING JULY 31, 1982 Net Month End Additions Balance (b)(c) $$109,030,944 39,698 109,070,642 772,147 109,842,789 93,833 109,936,622 185,985 110,122,607 211 ,811 110,334,418 206,000 110,540,418 58,000 110,598,418 208,000 110,806,418 318,000 111,124,418 534,000 111,658,418 556,000 112,214,418 477 ,000 112,691,418 29 30 Adjustment for 50% of Original Conference Center Cost 31 Average Balance as Adjusted *projected data Intermountain Gas Company Case No. U~1034-99 Exhibit 6 Schedule 6 Page 2 of 6 Witness: Schul tz I I I I I I LineNo. I I I I I I I I I I I I I I I I 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Month (a) July 1981 August September October November December *January 1982 *February *March *April *May *June *July Total Average Balance INTERMOUNTAIN GAS COMPANY GAS PLANT-IN-SERVICE ACCUMULATED DEPRECIATION TWELVE MONTHS ENDING JULY 31, 1982 Net Month End Provision Balance (b)(c) $$37,371,646 (257,147)37,114,499 234,726 37,349,225 303,919 37,653,144 213,493 37,866,637 303,366 38,170,003 285,895 38,455,898 298,896 38,754,794 287,895 39,042,689 286,896 39,329,585 269,895 39,599,480 273,896 39,873,376 277,895 40,151,271 Adjustment for 50% of Accumulated Depreciation on Conference Center Average Adjusted Balance *projected data Intermountain Gas Company Case No. U-1034-99 Exhibit 6 Schedule 6 Page 3 of 6 Witness: Schultz I I I I I I I I I I I I I I I I I I I I I I INTERMOUNTAIN GAS COMPAN ADVANCES IN AID OF CONSTRUCTION TWELVE MONTHS ENDING JULY 31, 1982 Line No. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 *projected data Intermountain Gas Company Case No. U-I034-99 Exhibit 6 Schedule 6 Page 4 of 6 Witness: Schultz I I I I I I I I I I I I I I I I I I I I I I INTERMOUNTAIN GAS COMPAN MATERIALS & SUPPLIES INVENTORY TWELVE MONTHS ENDING JULY 31, 1982 Line No. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 *projected data Intermountain Gas Company Case No. U-I034-99 Exhibit 6 Schedule 6 Page 5 of 6 Witness: Schultz I I I I I Line I No. I 1 2 3 I 4 5 6 I 7 8 9 I 10 11 12 I 13 14 15 I 16 17 18 I 19 20 21 I 22 23 24 I 25 I 26 27 I 28 I I *projected data I I I Intermountain Gas Company Case No. U-1034-99 Exhibit 6 Schedule 6 Page 6 of 6 Witness: Schultz INTERMOUNTAIN GAS COMPAN LNG STORAGE INVENTORY TWELVE MONTHS ENING JULY 31, 1982 Month End Month Net Change Balance (a)(b)(c) July 1981 $$2,416,368 (13,524) August 2,402,844 (3,768) September 2,399,076 (13,357) October 2,385,719 312,255 November 2,697,974 (l,099,699) December 1,598,275 (508,997) *January 1982 1,089,278 (395,182) *February 694,096 796,252 *March 1,490,348 757,701 *April 2,248,049 618,627 *May 2,866,676 338,971 *June 3,205,647 338,972 *July 3,544,619 Total Average Balance 26,058,479T 12 $ 2.171.540