Loading...
HomeMy WebLinkAboutU-1034-99 (INT) Exhibit 11 Lebens.pdfIN T E R M O U N T A I N G A S C O M P A N Y CO S T O F S E R V I C E A N R A T E O F R E T U R TW E L V E M O N T H S E N D E D J U L Y 3 1 , 1 9 8 2 A S A D J U S T E D Li n e No . Co s t o f S e r v i c e Pe r St a f f (b ) (c ) Re q u i r e d Ad j u s t m e n t s De s c r i p t i o n (a ) 1 2 3 CO S T O F S E R V I C E : Op e r a t i n g R e v e n u e s - Ga s s a l e s Ot h e r o p e r a t i n g r e v e n u e s $( 3 , 6 6 2 , 4 0 9 ) ~ 1 $1 3 9 , 7 6 4 , 0 0 6 3, 4 3 9 , 3 7 6 14 3 , 2 0 3 , 3 8 2 (3 , 6 6 2 , 4 0 9 ) 4 5 6 7 8 9 Op e r a t i n g E x p e n s e s - Co s t o f g a s Op e r a t i o n & m a i n t e n a n c e De p r e c i a t i o n Ge n e r a l t a x e s In c o m e t a x e s (4 7 4 , 3 4 1 ) (2 , 7 7 4 , 7 9 3 ) (2 , 6 2 1 , 5 5 0 ) 32 1 , 0 9 8 11 3 , 0 1 4 , 7 9 1 14 , 5 8 0 , 8 4 8 3, 6 7 0 , 6 8 5 3, 4 8 3 , 5 6 8 2, 5 3 3 , 9 5 4 13 7 , 2 8 3 , 8 4 6 10 $ 5 . 9 1 9 . 5 3 6 $ ( 8 8 7 , 6 1 6 ) $ 0 8 0 , 6 2 8 ) Op e r a t i n g I n c o m e 11 $ 6 7 . 4 6 8 . 5 2 3 Ra t e B a s e 12 8. 7 7 4 % Re t u r n Co s t o f S e r v i c e Pe r C o m p a n y 1 rg C u r r e n t R a t e s - I (d ) $1 3 6 , 1 0 1 , 5 9 7 3, 4 3 9 , 3 7 6 13 9 , 5 4 0 , 9 7 3 11 0 , 3 9 3 , 2 4 1 14 , 9 0 1 , 9 4 6 3, 6 7 0 , 6 8 5 3, 4 8 3 , 5 6 8 2, 0 5 9 , 6 1 3 13 4 , 5 0 9 , 0 5 3 $ 5 . 0 3 1 . 9 2 Q $ 6 7 . 2 8 7 . 8 9 5 7. 4 I a % Co m p a n y P r o p o s e d Re v e n u e De f i c i e n c y (e ) $7 , 4 6 4 , 1 7 9 7, 4 6 4 , 1 7 9 3, 6 9 5 , 5 1 5 3, 6 9 5 , 5 1 5 $3 . 7 6 8 . 6 6 4 $ II A p r i l 1 , 1 9 8 2 r a t e s 21 A d d i n g b a c k C o m p a n y ' s p r o j e c t e d s a l e s d e c l i n e f i g u r e p e r r e v i s e d w o r k p a p e r # 1 0 2 - W i t n e s s : S c h u l t z ( 6 , 1 5 9 , 3 6 7 t h e r m s ) 3/ R e p r e s e n t s C o m p a n y p r o p o s e d r a t e b a s e o f $ 6 7 , 2 8 6 , 4 4 0 p e r r e v i s e d E x h i b i t 6 , S c h e d u l e 6 , p a g e 1 o f 8 p l u s s t a f f p r o p o s e d - a d j u s t m e n t o f $ 1 , 4 5 5 p e r s t a f f E x h i b i t N o . 1 0 2 , S c h e d u l e 1 ~/ R e p r e s e n t s r a t e o f r e t u r n p r o p o s e d b y C o m p a n y i n r e v i s e d E x h i b i t 3 , S c h e d u l e 1 , p a g e 1 o f 5 p 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 1 1 Sc h e d u l e 1 Wi t n e s s : L e b e n s 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 (f ) $1 4 3 , 5 6 5 , 7 7 6 3, 4 3 9 , 3 7 6 14 7 , 0 0 5 , 1 5 2 11 0 , 3 9 3 , 2 4 1 14 , 9 0 1 , 9 4 6 3, 6 7 0 , 6 8 5 3, 4 8 3 , 5 6 8 5, 7 5 5 , 1 2 8 13 8 , 2 0 4 , 5 6 8 $ 8 , 8 0 0 , 5 8 4 $ 6 7 , 2 8 7 , 8 9 5 ' l / 13 . 0 J ~ % ~ 1 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 29 '\30 31 32 Intermountain Gas Company Case No. U-I034-99 Exhibit 11 Schedule 2 Page 1 of 2 Witness: Lebens INTERMOUNTAIN GAS COMPAN REQUIRED ADJUSTMTS TO STAFF'S PROPOSED COST OF SERVICE Description (a) Amount (b) COST OF GAS Projected therm sales decline ODL-l commodity rate in effect (6,159,367) .42562 Adjustment required $ (2,621,550) OPERATION AN MAINTENANCE EXPENSE Provision for Bad Debts: Adjusted test year sales revenues Company proposed provision rate Bad debt level proposed. by Company Staff proposed level Adj us tmen t required $147,000,000 .00685 1,006,950 882,000 124,950 Weatherization & Financial Program Expenses: Minimum level of other financing and administrative expenses Test year ended July 31, 1982 Increased level of expense Staff proposed level Adjustment required 69,583 17,060 52,523 52,523 Refund of C & K Exploration Advances: Company's normalized therm sales level Refund rate Test year as adjusted Staff proposed level Adjustment required 240,020,227 .00088 (211 ,218) (216,638) 5,420 Price Level Adjustment: o & M expenses not separately adjusted as proposed by Staff Price level factor Price level adjustment Staff proposed adjustment Adjustment required 3,735,278 .062 231,587 93,382 138,205 $321,098Total 0 & M Adjustment Required Line No. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 Intermountain Gas Company Case No. U-I034-99 Exhibit 11 Schedule 2 Page 2 of 2 Witness: Lebens INTERMOUNTAIN GAS COMPAN REQUIRED ADJUSTliNTS TO STAFF'S PROPOSED COST OF SERVICE Description (a) Amount (b) INCOME TAXES ~ STATUTORY RATES Operating Revenues Operating Expenses (excluding income taxes) Income before interest & income taxes Interest Charges - Rate base LIT & SIT debt weighted average interest cost $ 139,540,973 (132,449,440)7,091,533 $67,287,895 4.678% 11 (3iI47,728) State Taxable Income Less - State Taxes ~ 6 1/2% 3,943,805 (456,347) Federal Taxable Income $3,687 i458 Federal Taxes ~ 46% Less - surtax exemption ITC amortization $1,696,231 09,875) (116,000) Net Federal Tax State Tax Amortization of Unfunded Future Tax Liability 1,560,356 256,347 242,910 Income Taxes for Test Year as Adjusted Income Taxes for Staff Proposed Test Year 2,059,613 2,533,954 (474,341)Adjustment Required $ 11 Per revised Exhibit 6, Schedule 5 Li n e No . 3 4 5 6 De s c r i p t i o n (a ) 1 2 Tw e l v e m o n t h s e n d e d Ju l y 3 1 , 1 9 8 2 Tw e l v e m o n t h s e n d e d Au g u s t 3 1 , 1 9 8 2 Tw e l v e m o n t h s e n d e d Se p t e m b e r 3 0 , 1 9 8 2 IN T E R M O U N T A I N G A S C O M P A N Y RE C A P O F R E V E N U E S A N D N E T BA D D E B T W R I T E - O F F S Ac t u a l R e v e n u e Su b j e c t t o B a d D e b t Pr o v i s i o n Ac t u a l Wr i t e - o f f s (b ) (c ) $1 4 9 , 4 2 0 , 1 0 8 $1 , 4 1 8 , 6 8 6 $1 4 7 , 4 2 4 , 2 0 7 $1 , 4 6 5 , 4 4 4 $1 4 6 , 8 1 3 , 8 8 4 $1 , 5 0 5 , 4 7 2 Ac t u a l Re c o v e r i e s (d ) $4 5 7 , 3 8 6 $4 7 8 , 8 1 1 $5 0 0 , 9 2 5 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 1 1 Sc h e d u l e 3 Wi t n e s s : L e b e n s Ac t u a l Ne t Wr i t e - o f f s Ne t W r i t e - o f f s as a P e r c e n t of R e v e n u e (e ) (f ) $ 9 6 1 , 3 0 0 .6 4 3 % $ 9 8 6 , 6 3 3 .6 6 9 % $ 1 , 0 0 4 , 5 4 7 .6 8 5 % Li n e No . De s c r i p t i o n (a ) 1 Lo a n s O u t s t a n d i n g 2 Lo a n s A c c e p t e d a n d i n P r o c e s s 3 To t a l 4 5 6 Av e r a g e B a l a n c e Su b s i d y R a t e Mi n i m u m . F e e i n F i s c a l 1 9 8 3 IN T E R M O U N T A I N G A S C O M P A N CA L C U L A T I O N O F M I N I M U M F E E FO R S U B S I D I Z E D F I N A N C I N G P R O G R A Ac t u a l Ba l a n c e p e r IF N B a t 9/ 3 0 / 8 2 (b ) $1 , 0 0 8 , 8 9 9 46 1 , 0 0 0 $1 , 4 6 4 , 8 9 9 As s u m e d Pr i n c i p a l Am o r t i z a t i o n at 1 0 % (c ) $1 0 0 , 3 9 0 46 , 1 0 0 $1 4 6 , 4 9 0 . 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 1 1 Sc h e d u l e 4 Wi t n e s s : L e b e n s As s u m e d Ba l a n c e 9/ 3 0 / 8 3 (d ) $ 9 0 3 , 5 0 9 41 4 , 9 0 0 $1 , 3 1 8 , 4 0 9 $1 , 3 9 1 , 6 5 4 5% $ 69 t 5 8 3 IN T E R M O U N T A I N G A S C O M P A N Y 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 - I 0 3 4 - 9 9 Ex h i b i t 1 1 Sc h e d u l e 5 Wi t n e s s : L e b e n s PR I C E L E V E L A D J U S T M E N T F A C T O R C A L C U L A T I O N TW E L V E M O N T H S E N D E D J U L Y 3 1 , 1 9 8 2 1 Co n s u m e r P r i c e I n d e x Im p l i c i t Pr o d u c e r s Pr i c e D e n a t o r - Pr i c e I n d e x - Al l I t e m s L e s s To t a l G o o d s Fi n i s h e d G o o d s En e r g y , F o o d an d Ex c l u d i n g an d H o m e Pe r i o d Se r v i c e s Fo o d Se r v i c e s Pu r c h a s e Av e r a g e -(a ) (b ) (c ) (d ) (e ) (f ) Ju l y 1 9 8 1 ~ 19 3 . 8 27 4 . 3 30 8 . 6 23 2 . 6 27 0 . 6 Ju l y 1 9 8 2 * 20 4 . 8 28 6 . 4 33 6 . 6 25 0 . 3 29 3 . 4 Pe r c e n t a g e C h a n g e 5. 7 % A. 4 % 8. 4 % Li n e No .2 3 4 5 Av e r a g e C h a n g e o f Th r e e I n d i c e s 6. 2 % * S o u r c e : S t a f f W i t n e s s H y l e n , E x h i b i t 1 0 2 , S c h e d u l e 5 ~ g-ou '""''''" I'"'""".;is'" ,.¡t:..'"i: ..;j. Q)"o 0 .u.. (te z"" :: toJ. .."0 Q)QJ tU '.. OJ i:.¡ fJ,. .c .¡i: as ~ CJ...Ht) ritr ~ ~ ~U ~ ¡: ~ ~'" ~ :x f¡ ~i~ ~~ -; ~ ~ "+-H ~ g~ '6.. H '" ~! ~i: 0 ~¡; Z fJ .. '" '" ",:; g ~g Ëen 0H !l ~ ~ ~ di00U ~ '" ~ ~ '" ~~ gw ~t~~:èlU J, 4- +o it ~ ~ Cl '" ~ ¡ g~i: Q, Q).! -. ~~~-- -= Æ g.~__ ~ '" ..~i: ..'" "'~n;.~~ .~~ ~'" ;: +.. O'~'" .i..~ ~12..o"' ""o.s.. :: §.... ~.... ~oZ ..'" "" '" '" ~ ~ g~ ~ 2l gcJ iE "" ~~~ ~..;: ..'" 0'''.. ~ '" g:,, "'I ~ .u Ø) ?~ '" '" :: ~.. '" ~ QJ"O~ a.~ ;.~ g.~ :3 ~ ~;te "" ,. ~ .s g" ~ ~o..'" æ :;o tf~ ~g ~ tn -H '"~ ""s ~ ~ B -;.- ~'" 0'''.. ~ '" '"'" '""" '"ei: -.OJ II ~:: ..4l ~ g¡ ~ ~I ~ ~ ~ EI ~..I ~J5 ~ e lòl,4 :z ...._---M ~ M NON ø .. ~ ~ ~ ~ ~ 00 00 ~ 00 M 00 M a ~ ~ N 0 00 ~ ~ ~ ~I~ ~ ~ tnN.. ...... __.. ....~ MMN N IN -_....'-..-..--~ø-51 ------00 NON ~ ~ 00 00 00 00 '" ~ ~ ~ ~ ~ N 0 OO~ ~ N 0 00 '" ~ IN 0 00 ~I~ 00 M 00 M N.. IN M~ tn ~ ~ 00 ~ ~ '" tn M N.. 0 ~ ~ ~ ~ ~ M.. 0-C~--- NNNNNNN..........-_.. ø-~I \0 .. 0 00 00 N \0 N Cl .. IN CX.. 0 \O.. N 0 00 \0 -. N 0 co \O.. N d co "'I ~I0\0 N ~ M 0 \0 M ~ \0 M ~ \0 M ~ ~ \0 tn MIN.. 0 ~ ~ \0 tn.. M.. 000 ~ ~ \0 \0 \0 tn tn...... M M M IN N N IN N IN N IN................ ø- M M 0 ~ ~.. M \0 ~ IN \0 ~ N tn 00 ~.. tn ~ M ~.. tn ~ M ~.. tn ~MI ~Itn M.. 00 \0 tn M .. ~ 00 \0 .. M .. ~ 00 00 ~ \0 \0 tn tn .. M M N IN ..MMMNNNNN............ ø- ---------------~ 0 ~ 0 ~ ~ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 01 jlN 0 ø ~ ~ ~ ~~ ~ ~~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ I~ ---------------ø- ~13 co M 10. 0\ .. \0 M", 0\ C' \0 0\ N ~ co .. _ LI 0\ M ~ .. ~ CJ M ~ - ~ CJ MI ~IC' M C' _ _ CJ CJ ~ LI.. N 0 0\ ~ LI M M N.. _ 0 0 CJ co ø ~ ~ '" ~LIMNNNN_______ --..---- ø- "" "" 0 CJ CJ _ M '" 0\ N \0 CJ N tt co ~ _li O'(l ~ - LI CJ M ~.. ~ 0\ MI ~Ian M.- co \0 an M _ CJ ø "'.. M.. CJ co co ~ \0 \0 LI LI ~ M M N N -MMMNNC'NN_..____ ø- co LI M an M co 0 0 0000000 an an LI LI an LI LI ~ an LI LI an an an LIM..CO o~co~o'" NCO~O'" N N..N..N ~ N.. N..N..N..N~ ~ ~ ~~ q ~~~ ~~~ ~ CJCO.. '" '" an an.. ~ M M N N__ N NN N C'.N _.... _....._ø- co .. 0 '" N co.. 0 \0 C' co ~ 0 \0 N co ~ 0 \0 N co.. 0 '" N co ~ 0 '" NI ~ILI co 0' 0\ 0 .. co '" M ._ co '" .. ._ O'.. NO.. an N 0 co an M 0 00 \0 M .... LI LI an \0 an LI an an an ~ ~ ~ ~ M an an an ~ .. ~ ~ M M M M N N N Nø- . .. N 0 co \0 ~ N 0 co ",.. N 0 OJ \0 ~ N 0 co \O.. eN 0 co ",.. N 000 "'I ~IO.. '" .. CJ co 0 0'.. \0 LI ~ M _ 0.. '" an M N _ 0 CJ.. \0 LI ~ M - 0M _._ _ _ _ N __ _ ___ _.. NNNNN N N"" -.... - - -- ø- .. N 0 co \0 ~ N 0 co \0 ~ N 0 co '" .. N 0 co \0 -d N 0 00 \0 ~ N 0 co \01 ~Ian..M_oO\co..an..MN_CJco.."'anMN_OCJ.."'LI~M.. .M MMMMN NNN C'N N N __.. _ __ --- ø- 0000000000000 ~o 0 0 0 0 0 0 0 0 0000000LI an LI an an an an LI LI an an an LI LI LI an LI LI LI an an LI an an LI LI LI LI an LI0\ co .. \0 LI .. M N"" 0 0\ co .. '" an ~ M N"" 0 CJ co.. \0 LI.. M N ..ÑÑÑÑÑÑÑÑÑÑ ~~~~ ~~~ ~~ ~ø- 000000000000000LI O..-.- -co COCl co co 00 co ci co_MNNNN_________, , I , I , , , , , , , , , ,I ~I ø- 0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 00 000 0 0 001 ~I000000000000000000000000000000___ _ .____.. _._"" _._.. _ _____ __.. -.. - - -.. ø- ii ~_,N M .. LI \0 .. co CJ 0 _ C' M ~ LI '" .. co CJ 0 _ N M ~ LI '" .. co CJ 0___ _ _.. ____ NN N N N N N N N NM _NM..Ll\O..ciCJO_NM~LI"'..COO\O_NM..Ll\O..COO\O ..___~______NNNNC'NNNNNM M