Loading...
HomeMy WebLinkAbout20160812McGrath Exhibit 28.pdfRonald L. Williams, ISB No. 3034 Williams Bradbury, P.C. 1015 W. Hays St. Boise, ID 83702 Telephone: (208) 344-6633 Email: ron@williamsbradbury.com Attorneys for Intermountain Gas Company BEFORE THE IDAHO PUBLIC UTILITES COMMISSION IN THE MATTER OF THE APPLICATION OF INTERMOUNTAIN GAS COMPANY FOR THE AUTHORITY TO CHANGE ITS RATES AND CHARGES FOR NATURAL GAS SERVICE TO NATURAL GAS CUSTOMERS IN THE STATE OF IDAHO ) ) ) ) ) ) ) Case No. INT-G-16-02 EXHIBIT 28 In t e r m o u n t a i n G a s C o m p a n y FC C M M o n t h l y E x a m p l e R a t e S c h e d u l e R S C a l c u l a t i o n s EX A M P L E R A T E S C H E D U L E R S F C C A C T U A L C A L C U L A T I O N S F C C M Y E A R 1 Ja n u a r y Fe b r u a r y Ma r c h Ap r i l Ma y Ju n e Ju l y Au g u s t Se p t e m b e r Oc t o b e r No v e m b e r De c e m b e r To t a l Ex p l a n a t i o n (A ) (B ) (C ) (D ) (E ) (F ) (G ) (H ) (I ) (J ) (K ) (L ) (M ) (N ) 1 Ex a m p l e " A c t u a l " R S C u s t o m e r s 31 2 , 7 4 1 31 3 , 2 3 4 31 3 , 6 4 4 31 3 , 6 3 5 31 3 , 5 9 1 31 3 , 4 9 5 31 4 , 2 1 7 31 4 , 9 1 1 31 5 , 5 6 9 31 6 , 4 0 0 31 6 , 9 4 1 31 7 , 4 6 3 3,7 7 5 , 8 3 9 Ex a m p l e " b o o k e d " c u s t o m e r s 2 Ex a m p l e " A c t u a l " R S T h e r m s 43 , 8 3 0 , 6 3 1 35 , 2 1 8 , 7 9 5 26 , 3 9 7 , 2 9 3 20 , 8 7 2 , 9 7 5 10 , 9 7 1 , 5 6 8 7,3 6 0 , 7 9 8 5,0 0 6 , 6 5 1 4,2 9 4 , 7 8 8 4, 7 8 9 , 8 1 4 7, 2 4 3 , 3 0 4 16 , 0 6 2 , 1 2 5 33 , 4 2 0 , 9 2 7 21 5 , 4 6 9 , 6 6 8 Ex a m p l e " b o o k e d " t h e r m s 3 "A p p r o v e d " R a t e s 4 Cu s t o m e r C h a r g e $1 0 . 0 0 $1 0 . 0 0 $1 0 . 0 0 $1 0 . 0 0 $1 0 . 0 0 $1 0 . 0 0 $1 0 . 0 0 $1 0 . 0 0 $1 0 . 0 0 $1 0 . 0 0 $1 0 . 0 0 $1 0 . 0 0 5 Vo l u m e t r i c r a t e $0 . 1 1 2 6 5 $0 . 1 1 2 6 5 $0 . 1 1 2 6 5 $0 . 1 1 2 6 5 $0 . 1 1 2 6 5 $0 . 1 1 2 6 5 $0 . 1 1 2 6 5 $0 . 1 1 2 6 5 $0 . 1 1 2 6 5 $0 . 1 1 2 6 5 $0 . 1 1 2 6 5 $0 . 1 1 2 6 5 6 To t a l A c t u a l R S M a r g i n $8 , 0 6 4 , 9 3 2 $7 , 0 9 9 , 7 3 6 $6 , 1 1 0 , 0 9 4 $5 , 4 8 7 , 6 8 8 $4 , 3 7 1 , 8 5 6 $3 , 9 6 4 , 1 4 4 $3 , 7 0 6 , 1 7 0 $3 , 6 3 2 , 9 1 5 $3 , 6 9 5 , 2 5 9 $3 , 9 7 9 , 9 5 7 $4 , 9 7 8 , 8 0 4 $6 , 9 3 9 , 4 9 5 $6 2 , 0 3 1 , 0 4 9 Lin e 7 + L i n e 8 7 Ac t u a l M a r g i n - C u s t o m e r C h a r g e s $3 , 1 2 7 , 4 1 2 $3 , 1 3 2 , 3 3 8 $3 , 1 3 6 , 4 3 9 $3 , 1 3 6 , 3 4 7 $3 , 1 3 5 , 9 0 8 $3 , 1 3 4 , 9 5 0 $3 , 1 4 2 , 1 7 1 $3 , 1 4 9 , 1 0 7 $3 , 1 5 5 , 6 8 6 $3 , 1 6 3 , 9 9 9 $3 , 1 6 9 , 4 0 5 $3 , 1 7 4 , 6 2 8 $3 7 , 7 5 8 , 3 9 1 Lin e 1 x L i n e 4 8 Ac t u a l M a r g i n - V o l u m e t r i c C h a r g e s $4 , 9 3 7 , 5 2 1 $3 , 9 6 7 , 3 9 7 $2 , 9 7 3 , 6 5 5 $2 , 3 5 1 , 3 4 1 $1 , 2 3 5 , 9 4 7 $8 2 9 , 1 9 4 $5 6 3 , 9 9 9 $4 8 3 , 8 0 8 $5 3 9 , 5 7 3 $8 1 5 , 9 5 8 $1 , 8 0 9 , 3 9 8 $3 , 7 6 4 , 8 6 7 $2 4 , 2 7 2 , 6 5 8 Lin e 2 x L i n e 5 9 FC C M C a l c u l a t i o n s 10 Ta r g e t F C C R S M a r g i n / C u s t o m e r $1 5 . 3 3 $1 2 . 9 2 $9 . 9 8 $7 . 4 6 $3 . 9 6 $2 . 6 4 $1 . 7 9 $1 . 5 4 $1 . 7 1 $2 . 5 6 $5 . 7 7 $1 2 . 1 0 Ta r g e t F C C m a r g i n / c u s t o m e r a s de t e r m i n e d i n t h i s p r o c e e d i n g 11 Ac t u a l V o l u m e t r i c M a r g i n / C u s t o m e r $1 5 . 7 9 $1 2 . 6 7 $9 . 4 8 $7 . 5 0 $3 . 9 4 $2 . 6 4 $1 . 7 9 $1 . 5 4 $1 . 7 1 $2 . 5 8 $5 . 7 1 $1 1 . 8 6 Lin e 8 / L i n e 1 12 Dif f e r e n c e : A c t u a l - F C C T a r g e t M a r g i n / Cu s t o m e r ( S u r p l u s , ( D e f i c i e n c y ) ) $0 . 4 6 ($ 0 . 2 6 ) ($ 0 . 5 0 ) $0 . 0 4 ($ 0 . 0 2 ) $0 . 0 0 $0 . 0 0 $0 . 0 0 $0 . 0 0 $0 . 0 2 ($ 0 . 0 6 ) ($ 0 . 2 4 ) Lin e 1 1 - L i n e 1 0 13 Ma r g i n : S u r p l u s , ( D e f i c i e n c y ) $1 4 3 , 8 1 1 ($ 8 0 , 9 6 7 ) ($ 1 5 6 , 5 0 8 ) $1 1 , 6 9 8 ($ 6 , 2 1 1 ) $0 $0 $0 $0 $6 , 0 7 4 ($ 1 8 , 2 7 7 ) ($ 7 6 , 8 3 4 ) ($ 1 7 7 , 2 1 3 ) Lin e 1 2 x L i n e 1 Fo r e x a m p l e , " A p p r o v e d " r a t e s s e t a t pr o p o s e d r a t e s i n t h i s p r o c e e d i n g Exhibit No. 28 Case No. INT-G-16-02 M. McGrath, IGC p. 1 of 2 In t e r m o u n t a i n G a s C o m p a n y FC C M M o n t h l y E x a m p l e R a t e S c h e d u l e G S - 1 C a l c u l a t i o n s EX A M P L E R A T E S C H E D U L E G S F C C A C T U A L C A L C U L A T I O N S F C C M Y E A R 1 Ja n u a r y Fe b r u a r y Ma r c h Ap r i l Ma y Ju n e Ju l y Au g u s t Se p t e m b e r Oc t o b e r No v e m b e r De c e m b e r To t a l Ex p l a n a t i o n (A ) (B ) (C ) (D ) (E ) (F ) (G ) (H ) (I ) (J ) (K ) (L ) (M ) (N ) 1 Ex a m p l e " A c t u a l " C u s t o m e r s 32 , 8 2 9 32 , 8 2 6 32 , 8 0 0 32 , 7 4 1 32 , 6 9 4 32 , 6 3 2 32 , 6 9 9 32 , 7 5 3 32 , 8 0 3 32 , 8 9 5 32 , 9 3 7 32 , 9 8 8 39 3 , 5 9 7 Ex a m p l e " b o o k e d " c u s t o m e r s 2 Ex a m p l e " A c t u a l " T h e r m s 21 , 5 2 8 , 7 0 6 17 , 3 0 0 , 7 2 0 13 , 0 9 3 , 2 4 3 9, 7 6 4 , 6 0 6 5, 4 7 3 , 5 0 7 4, 4 8 8 , 4 2 6 2, 9 8 0 , 8 0 8 2,5 8 2 , 6 3 1 3,2 0 6 , 3 4 5 3,6 9 8 , 8 8 3 8,5 9 6 , 4 6 0 16 , 6 2 5 , 1 2 6 10 9 , 3 3 9 , 4 6 2 Ex a m p l e " b o o k e d " t h e r m s 3 Ex a m p l e A c t u a l B l o c k 1 T h e r m s 4, 5 4 8 , 9 0 5 4, 5 4 9 , 8 9 4 3, 8 7 3 , 2 9 8 3, 5 8 6 , 9 7 9 2, 0 3 7 , 1 9 4 1, 4 3 1 , 5 1 3 87 5 , 8 3 6 71 7 , 2 7 3 95 1 , 2 9 8 1,2 0 3 , 2 7 9 3,4 2 5 , 1 7 7 4, 2 0 4 , 8 6 8 31 , 4 0 5 , 5 1 5 Ex a m p l e " b o o k e d " t h e r m s : B l o c k 1 4 Ex a m p l e A c t u a l B l o c k 2 T h e r m s 10 , 7 3 8 , 3 8 4 8, 5 2 5 , 1 4 7 6, 2 2 4 , 8 6 1 4, 5 5 0 , 0 4 2 2, 4 9 7 , 8 6 0 2, 1 8 0 , 7 6 9 1, 3 6 1 , 2 5 4 1,1 6 0 , 6 8 4 1,5 4 4 , 5 6 3 1,4 0 5 , 1 4 9 3,6 1 5 , 3 7 4 8, 2 3 5 , 0 0 7 52 , 0 3 9 , 0 9 2 Ex a m p l e " b o o k e d " t h e r m s : B l o c k 2 5 Ex a m p l e A c t u a l B l o c k 3 T h e r m s 5, 3 5 0 , 5 8 2 3, 8 5 2 , 5 5 0 2, 7 5 3 , 7 3 4 1, 4 6 1 , 0 2 1 76 6 , 7 3 9 74 8 , 6 1 4 49 7 , 3 8 0 53 6 , 6 2 9 34 5 , 7 1 7 77 3 , 7 0 3 1,3 1 0 , 4 3 9 3, 5 3 2 , 3 5 7 21 , 9 2 9 , 4 6 4 Ex a m p l e " b o o k e d " t h e r m s : B l o c k 3 6 Ex a m p l e A c t u a l B l o c k 4 T h e r m s 89 0 , 8 3 5 37 3 , 1 2 9 24 1 , 3 5 0 16 6 , 5 6 5 17 1 , 7 1 5 12 7 , 5 3 1 24 6 , 3 3 8 16 8 , 0 4 5 36 4 , 7 6 7 31 6 , 7 5 2 24 5 , 4 7 0 65 2 , 8 9 4 3, 9 6 5 , 3 9 1 Ex a m p l e " b o o k e d " t h e r m s : B l o c k 4 7 "A p p r o v e d " R a t e s 8 Cu s t o m e r C h a r g e $3 5 . 0 0 $3 5 . 0 0 $3 5 . 0 0 $3 5 . 0 0 $3 5 . 0 0 $3 5 . 0 0 $3 5 . 0 0 $3 5 . 0 0 $3 5 . 0 0 $3 5 . 0 0 $3 5 . 0 0 $3 5 . 0 0 9 Vo l u m e t r i c r a t e : B l o c k 1 $0 . 1 1 0 7 6 $0 . 1 1 0 7 6 $0 . 1 1 0 7 6 $0 . 1 1 0 7 6 $0 . 1 1 0 7 6 $0 . 1 1 0 7 6 $0 . 1 1 0 7 6 $0 . 1 1 0 7 6 $0 . 1 1 0 7 6 $0 . 1 1 0 7 6 $0 . 1 1 0 7 6 $0 . 1 1 0 7 6 10 Vo l u m e t r i c r a t e : B l o c k 2 $0 . 0 9 6 6 2 $0 . 0 9 6 6 2 $0 . 0 9 6 6 2 $0 . 0 9 6 6 2 $0 . 0 9 6 6 2 $0 . 0 9 6 6 2 $0 . 0 9 6 6 2 $0 . 0 9 6 6 2 $0 . 0 9 6 6 2 $0 . 0 9 6 6 2 $0 . 0 9 6 6 2 $0 . 0 9 6 6 2 11 Vo l u m e t r i c r a t e : B l o c k 3 $0 . 0 8 2 9 7 $0 . 0 8 2 9 7 $0 . 0 8 2 9 7 $0 . 0 8 2 9 7 $0 . 0 8 2 9 7 $0 . 0 8 2 9 7 $0 . 0 8 2 9 7 $0 . 0 8 2 9 7 $0 . 0 8 2 9 7 $0 . 0 8 2 9 7 $0 . 0 8 2 9 7 $0 . 0 8 2 9 7 12 Vo l u m e t r i c r a t e : B l o c k 4 $0 . 0 7 5 0 0 $0 . 0 7 5 0 0 $0 . 0 7 5 0 0 $0 . 0 7 5 0 0 $0 . 0 7 5 0 0 $0 . 0 7 5 0 0 $0 . 0 7 5 0 0 $0 . 0 7 5 0 0 $0 . 0 7 5 0 0 $0 . 0 7 5 0 0 $0 . 0 7 5 0 0 $0 . 0 7 5 0 0 13 To t a l A c t u a l R S M a r g i n $3 , 2 0 1 , 1 3 4 $2 , 8 2 4 , 1 7 4 $2 , 4 2 5 , 0 3 6 $2 , 1 1 6 , 5 6 6 $1 , 6 8 7 , 7 7 0 $1 , 5 8 3 , 0 5 2 $1 , 4 3 2 , 7 4 6 $1 , 3 9 5 , 0 8 1 $1 , 4 5 8 , 7 5 5 $1 , 5 0 8 , 3 1 6 $2 , 0 0 8 , 6 1 6 $2 , 7 5 8 , 0 1 8 $2 4 , 3 9 9 , 2 6 4 Lin e 1 4 + L i n e 1 5 14 Ac t u a l M a r g i n - C u s t o m e r C h a r g e s $1 , 1 4 9 , 0 0 5 $1 , 1 4 8 , 8 9 7 $1 , 1 4 8 , 0 0 5 $1 , 1 4 5 , 9 3 4 $1 , 1 4 4 , 2 9 2 $1 , 1 4 2 , 1 1 4 $1 , 1 4 4 , 4 7 1 $1 , 1 4 6 , 3 6 3 $1 , 1 4 8 , 1 1 2 $1 , 1 5 1 , 3 2 5 $1 , 1 5 2 , 7 8 9 $1 , 1 5 4 , 5 7 4 $1 3 , 7 7 5 , 8 8 0 Lin e 1 x L i n e 5 15 Ac t u a l M a r g i n - V o l u m e t r i c C h a r g e s $2 , 0 5 2 , 1 3 0 $1 , 6 7 5 , 2 7 7 $1 , 2 7 7 , 0 3 1 $9 7 0 , 6 3 2 $5 4 3 , 4 7 8 $4 4 0 , 9 3 8 $2 8 8 , 2 7 5 $2 4 8 , 7 1 8 $3 1 0 , 6 4 3 $3 5 6 , 9 9 1 $8 5 5 , 8 2 7 $1 , 6 0 3 , 4 4 4 $1 0 , 6 2 3 , 3 8 4 Σ ( L i n e s 3 t o 6 ) x ( L i n e s 9 t o 1 2 ) 16 FC C M C a l c u l a t i o n s 17 Ac t u a l V o l u m e t r i c M a r g i n / C u s t o m e r $6 2 . 5 1 $5 1 . 0 4 $3 8 . 9 3 $2 9 . 6 5 $1 6 . 6 2 $1 3 . 5 1 $8 . 8 2 $7 . 5 9 $9 . 4 7 $1 0 . 8 5 $2 5 . 9 8 $4 8 . 6 1 Lin e 1 5 / L i n e 1 18 Dif f e r e n c e : A c t u a l - F C C T a r g e t M a r g i n / Cu s t o m e r ( S u r p l u s , ( D e f i c i e n c y ) ) $1 . 8 2 ($ 1 . 0 4 ) ($ 2 . 0 5 ) $0 . 1 5 ($ 0 . 0 8 ) $0 . 0 0 $0 . 0 0 $0 . 0 0 $0 . 0 0 $0 . 0 8 ($ 0 . 2 6 ) ($ 0 . 9 9 ) Lin e 1 7 - L i n e 19 Ma r g i n : S u r p l u s , ( D e f i c i e n c y ) $5 9 , 7 7 1 ($ 3 4 , 1 8 9 ) ($ 6 7 , 2 1 2 ) $4 , 8 2 9 ($ 2 , 7 3 1 ) $0 $0 $0 $0 $2 , 6 5 8 ($ 8 , 6 4 5 ) ($ 3 2 , 7 2 3 ) ($ 7 8 , 2 4 3 ) Lin e 1 8 x L i n e 1 Fo r t h i s e x a m p l e , " A p p r o v e d " r a t e s se t a t p r o p o s e d r a t e s i n t h i s pr o c e e d i n g Exhibit No. 28 Case No. INT-G-16-02 M. McGrath, IGC p. 2 of 2