201208301INT to Staff Exhibits.xls.XLS

wkppr 8
wkppr 7
wkppr 6
wkppr 5
wkppr 4
wkppr 3
wkppr 2
wkppr 1
Exhibit 11
Exhibit 10
Exhibit 9
Exhibit 8
Exhibit 7
Exhibit 6
Exhibit 5
Exhibit 4
WACOG_Change
(a)
(b)
(c)
(d)
RS-1
RS-2
GS-1
Block 1
Block 2
Block 3
LV-1
(1)
(2)
T-3
(3)
INTERMOUNTAIN GAS COMPANY
Summary of Gas Cost Changes
Annual Therms/
Total Annual
Cost of Service Allocation of Gas Cost Adjustment (1)
Line
Billing Determinants
Prices
Cost
Annual
COST OF SERVICE ALLOCATION
No.
Description
INT-G-11-01
INT-G-12-01
Difference
INDIVIDUAL FACTORS
(e)
(f)
(g)
(h)
(i)
(j)
(k)
(l)
(m)
DEMAND CHARGES:
Transportation:
TOTAL
NWP TF-1 Demand 1 (Full Rate) (2)
NWP TF-1 Demand 1 (Discounted) (3)
Upstream Capacity (4)
Demand
Storage:
SGS-1
Capacity Demand
(5)
(6)
TF-2 Reservation
TF-2 Redelivery Charge
LS
Capacity
Liquefaction
Vaporization
TF-2 Reservation
TF-2 Redelivery Charge
Other Storage Facilities
(7)
COMMODITY CHARGES:
Total Producer/Supplier Purchases Including Storage
(8)
TOTAL ANNUAL COST DIFFERENCE
Normalized Sales Volumes (1/1/11 - 12/31/11)
Average Base Rate Change
Other Permanent Changes Proposed:
Elimination of Temporary Credits and Surcharges from Case No. INT-G-11-01
Adjustment to Fixed Cost Collection Rate (see Exhibit 5, Line 24)
Total Permanent Changes Proposed (Lines 24 through 27):
Temporary Surcharge (Credit) Proposed (Exhibit No. 6, Line 4, Cols (b)-(e))
Proposed Average Per Therm Change in Intermountain Gas Company Tariff
(1) See Workpaper No. 5, Line 8
(2) See Workpaper No. 1
(3) See Workpaper No. 2
(4) See Workpaper No. 3
(5) Represents Non-Additive Demand Charge Determinants
(6) Price Reflects Daily Charge; Annual Charge (Column (d) &(g)) equals Price (Column (c) & (f)) times Annual Therms/Billing Determinants (Column (b) & (e)) times 365. Actual Prices include 6 decimals.
(7) See Workpaper No. 4, Line 33, Column (e)
(8) WACOG was approved in INT-G-11-03
To FC exhibit
Summary of Fixed Gas Cost Charges
Current
Producers/
Cost of Service Allocation of Gas Cost Adjustment (1)
Suppliers
Per Therm
NWP TF-1 Demand 1 (Full Rate)
NWP TF-1 Demand 1 (Discounted)
Upstream Capacity
LS-1
Total Fixed Gas Cost Charges
Fixed Cost Collection per Therm (Line 20 divided by Line 21)
Current Fixed Cost Collection per Therm
Adjustment to Fixed Cost Collection (Line 22 minus Line 23)
FIXED COST COLLECTION RATE CALCULATION:
Adjusted Fixed Cost Collection Per Therm (Line 22)
Incremental Fixed Cost Collection (3)
(1) See Workpaper No. 5, Line 8
(2 ) Price Reflects Daily Charge; Annual Charge (Column (d)) equals Price (Column (c)) times Annual Therms (Column (b)) times 365.
(3) See Exhibit 4, Lines 1-19
Summary of Proposed Temporary Surcharges (Credits)
Cost of Service Allocation of Deferred Gas Costs
Management of Pipeline Transportation Capacity (1)
Proposed Temporary Surcharge (Credit) - Fixed Deferral (2)
Proposed Temporary Surcharge (Credit) - Variable Deferral
(4)
Total Proposed Temporary Surcharges (Credits)
(1) See Exhibit No. 7, Line 5, Columns (c) - (f)
(2) See Exhibit No. 8, Line 10, Columns (c) - (f)
(3) See Exhibit No. 9; Line 4, Column (b) plus Line 12, Column (b)
(4) See Exhibit No. 9; Line 4, Column (b) plus Line 20, Column (b)
LV-1,T-1
Allocation of Annualized Credits Resulting from Management of Pipeline Transportation Capacity
Cost of Service Allocation of Deferred Gas Costs (1)
Total
Segmentation Credits
Northwest Pipeline Capacity Releases
Total Management of Pipeline Transportation Capacity
Proposed Price Adjustment Per Therm
(1) See Workpaper No. 5, Line 8
Proposed Temporary Surcharges (Credits) - Fixed Costs
Deferred
Account 1860
Estimated
Cost of Service Allocation of Deferred Gas Costs (2)
Sept. 30, 2012
Percentages
Balance (1)
T-1
Fixed Costs:
From INT-G-11-01 (Accounts 1860.2050 - 2090)
Fixed Cost Collection Adjustment (Accounts 1860.2200)
Capacity Releases & Purchases (Account 1860.2320)
Interest (Account 1860.2430)
Management of Pipeline Transportation Capacity (Account 1860.2530)
Amortization of 1860.2530 (Accounts 1860.2540 - 1860.2550)
Total Fixed Costs
Proposed Temporary Surcharge (Credit)-Fixed Costs
(1) See Workpaper No. 6, Page 1, Lines 53 - 75 and Page 2, Lines 1 - 37
(2) See Workpaper No. 5, Line 8
Proposed Temporary Surcharges (Credits) - Variable Costs
Amount
Account 1860 Variable Amounts Which Apply to RS-1, RS-2, GS-1, and LV-1:
Account 1860 Variable Costs
Proposed Temporary Surcharge (Credit) - Variable Costs
Lost and Unaccounted For Gas Amounts Which Apply to RS-1, RS-2, and GS-1:
Lost and Unaccounted For Gas Amounts from INT-G-10-03 (Account 1860-2120)
Lost and Unaccounted For Gas Amortization (Account 1860-2130)
(Over)/Under Collection of Lost and Unaccounted For Gas from INT-G-10-03
Total Lost and Unaccounted For Gas Amounts Which Apply to RS-1, RS-2, and GS-1
Proposed Temporary Surcharge (Credit) - Lost and Unaccounted For Gas Costs
Lost and Unaccounted For Gas Amounts Which Apply to LV-1, T-3, T-4, and T-5:
Lost and Unaccounted For Gas Amounts from INT-G-10-03 (Account 1860-2120)
Lost and Unaccounted For Gas Amortization (Account 1860-2140)
Total Lost and Unaccounted For Gas Amounts Which Apply to LV-1, T-3, T-4 and T-5
See Workpaper No. 6, Page 1: Line 7, Column (e); Line 11, Column (d) & Line 17, Column (e)
See Workpaper No. 6, Page 1, Line 20, Column (c)
See Workpaper No. 6, Page 1, Line 26, Column (d)
See Workpaper No. 6, Page 1, Line 41, Column (d) plus Line 47, Column (e)
See Workpaper No. 6, Page 1, Line 21, Column (c)
See Workpaper No. 6, Page 1, Line 30, Column (d)
See Workpaper No. 6, Page 1, Line 42, Column (d) plus Line 51, Column (e)
Proposed One-Time Variable Credit
Proposed One-Time Variable Credit:
Account 1860.2180 Credit through 6/30/12 (1)
Actual Sales Volumes (7/1/11 - 6/30/12)
Proposed One-Time Variable Per Therm Credit
See Workpaper No. 6, Page 1, Line 10, Column (d)
Analysis of Annualized Price Change by Class of Service
Normalized Volumes for Twelve Months Ended December 31, 2011
Average Prices Effective
Proposed
per Case Nos. INT-G-11-01 & INT-G-11-03
Adjustments Effective
Proposed Average Prices
Commission Order Nos. 32372 & 32450
Effective 10/1/2012
Percent
Therms/CD Vols.
Revenue
$/Therm
Change
1
Gas Sales:
2
RS-1 Residential
3
RS-2 Residential
4
GS-1 General Service
LV-1 Large Volume
Total Gas Sales
T-3 Transportation
T-4 Transportation
T-5 Transportation (Demand)
T-5 Transportation (Commodity)
Total T-5
Total Transportation
(1) Demand volumes removed from the $/therm calculations
Summary of Northwest Pipeline TF-1 Full Rate Demand Costs
Line
Transportation
Annual Therms
Annual Cost
TF-1 Demand 1 Contract #1
TF-1 Demand 1 Contract #2
TF-1 Demand 1 Contract #3
TF-1 Demand 1 Contract #4
TF-1 Demand 1 Contract #5
TF-1 Demand 1 Contract #6
TF-1 Demand 1 Contract #7 (1)
TF-1 Demand 1 Contract #8 (1)
TF-1 Demand 1 Contract #9 (1)
Total Annual Cost
Total Annual Cost Difference (Row 20 minus Row 10)
(1) This contract was included on Workpaper No. 2 in INT-G-11-01 as a discounted contract. The contract is now priced at full rate.
(2) See Exhibit 4, Line 3, Column (h)
Summary of Northwest Pipeline TF-1 Discounted Demand Costs
Total Annual Cost Difference (Row 11 minus Row 5)
(1) See Exhibit 4, Line 4, Column (h)
Summary of Upstream Capacity Costs
Upstream Agreement #1
Upstream Agreement #2
Upstream Agreement #3
Upstream Agreement #4
Upstream Agreement #5
Upstream Agreement #6
Estimated Upstream Capacity Release Credits
Total Annual Cost Including Capacity Release Credits
Total Annual Cost Difference (Row 18 minus Row 9)
(1) See Exhibit 4, Line 5, Column (h)
Summary of Other Storage Facility Costs
Current
Costs
Monthly
Storage Facilities
Billing Determinant
Monthly Cost
Demand Costs -
Clay Basin I Reservation
Clay Basin II Reservation
Clay Basin III Reservation
Clay Basin I Capacity
Clay Basin II Capacity
Clay Basin III Capacity
Total Demand Costs
Cycling Costs -
Clay Basin Cycling Costs
Rexburg LNG Facility
Transportation Reservation
Variable Transportation
Total Rexburg LNG Facility Costs
Storage Demand Charge Credit
Total Costs Including Storage Credit
Estimated Storage Demand Charge Credit
Total Annual Cost Difference Including Storage Credit (Row 32 minus Row 16)
(1) Charge Based on Maximum Daily Withdrawal
(2) Charge Based on Maximum Contractual Capacity
(3) Non Additive Billing Determinants; Includes only Capacity Volumes
(4) See Exhibit 4, Line 19, Column (h)
Peak Day Analysis for Demand Allocators
Peak Firm Sales
Peak Sales
DEMAND ALLOCATORS PER CASE NO. INT-G-11-01:
Peak Day Therms
Percent of Total
Peak Day Usage Per Customer
January 2012 Actual Customers
(1) Contract Demand Therms
Analysis of Account 1860 Surcharges (Credits)
Estimated September 30, 2012
Detail
Sub-Total
ACCOUNT 1860 VARIABLE AMOUNTS:
Net Cumulative Deferred Gas Balance in 1860.2010 as of 10/1/11
Amortization in 1860.2020 as of 6/30/12
Estimated Therm Sales 7/1 through 9/30/12
Amortization Rate
Estimated Amortization in 1860.2020 at 9/30/12
Estimated Balance in 1860.2010 at 9/30/12
Deferred Gas Costs From Producers/Suppliers in 1860.2180 at 10/1/11
Deferred Gas Costs From Producers/Suppliers in 1860.2180 through 6/30/12
One-Time Variable Credit Balance
Estimated Deferred Costs in 1860.2180 from 7/1 through 9/30/12
Estimated Balance in 1860.2180 at 9/30/12
Daily Gas Excess Sales Deferred in 1860.2240 at 6/30/12
Interest Deferred in 1860.2340 at 10/1/11
Interest Deferred in 1860.2340 through 6/30/12
Estimated Interest from 7/1 through 9/30/12
Estimated Balance in 1860.2340 at 9/30/12
ESTIMATED ACCOUNT 1860 VARIABLE BALANCE AT 9/30/12
ACCOUNT 1860 LOST AND UNACCOUNTED FOR AMOUNTS:
Core Cumulative Deferred Gas Balance in 1860.2120 as of 10/1/11
Industrial Cumulative Deferred Gas Balance in 1860.2120 as of 10/1/11
Net Cumulative Deferred Gas Balance in 1860.2120 as of 10/1/11
Core Amortization in 1860.2130 as of 6/30/12
Estimated Amortization in 1860.2130 at 9/30/12
Industrial Amortization in 1860.2140 as of 6/30/12
Estimated Amortization in 1860.2140 at 9/30/12
Estimated Balance in 1860.2120 at 9/30/12
Lost & Unaccounted For Gas Deferral in 1860.2150 at 10/1/11
Total Lost & Unaccounted For Gas through 6/30/12
Estimated Lost & Unaccounted For Gas 7/1 through 9/30/12
Estimated Total Lost & Unaccounted For Gas at 9/30/12
Base Rate Collection of Lost & Unaccounted For Gas through 6/30/12
Estimated Base Rate Collection of Lost & Unaccounted For Gas 7/1 through 9/30/12
Estimated Base Rate Collection of Lost & Unaccounted For Gas at 9/30/12
Estimated Lost & Unaccounted For Deferral (Total less Base Rate Collection 10/1/11 through 9/30/12)
Estimated Balance in 1860.2150 at 9/30/12
Core Allocation of Lost & Unaccounted For Gas Deferral
Industrial Allocation of Lost & Unaccounted For Gas Deferral
Estimated Balance in 1860.2150 at 9/30/12
Core Lost & Unaccounted For Interest Deferred in 1860.2420 at 10/1/11
Core Lost & Unaccounted For Interest Deferred in 1860.2420 through 6/30/12
Estimated Core Interest from 7/1 through 9/30/12
Estimated Balance in 1860.2420 at 9/30/12
Industrial Lost & Unaccounted For Interest Deferred in 1860.2360 at 10/1/11
Industrial Lost & Unaccounted For Interest Deferred in 1860.2360 through 6/30/12
Estimated Industrial Lost & Unaccounted For Interest from 7/1 through 9/30/12
Estimated Balance in 1860.2360 at 9/30/12
ESTIMATED ACCOUNT 1860 LOST AND UNACCOUNTED FOR BALANCE AT 9/30/12
ACCOUNT 1860 FIXED AMOUNTS:
Net Cumulative Deferred Gas Balance in 1860.2050 at 10/1/11
RS-1 Deferred Gas Balance in 1860.2060 at 10/1/11
Amortization for RS-1 in 1860.2060 at 6/30/12
Estimated RS-1 Therm Sales 7/1 through 9/30/12
RS-1 Amortization Rate
Estimated RS-1 Balance in 1860.2060 at 9/30/12
RS-2 Deferred Gas Balance in 1860.2070 at 10/1/11
Amortization for RS-2 in 1860.2070 at 6/30/12
Estimated RS-2 Therm Sales 7/1 through 9/30/12
RS-2 Amortization Rate
Estimated RS-2 Balance in 1860.2070 at 9/30/12
GS-1 Deferred Gas Balance in 1860.2080 at 10/1/11
Amortization for GS-1 in 1860.2080 at 6/30/12
GS-1 Amortization Rate
Estimated GS-1 Balance in 1860.2080 at 9/30/12
Industrial Deferred Gas Balance in 1860.2090 at 10/1/11
Amortization for LV-1 in 1860.2090 at 6/30/12
Estimated LV-1 Block 1 & 2 Therm Sales 7/1 through 9/30/12
LV-1 Amortization Rate
Estimated Industrial Balance in 1860.2090 at 9/30/12
Estimated Cumulative Balance in 1860.2050 at 9/30/12
Fixed Cost Collection Deferred in 1860.2200 at 10/1/11
Fixed Cost Collection Deferred in 1860.2200 through 6/30/12
Estimated Fixed Cost Collection Deferred from 7/1 through 9/30/12
Estimated Balance in 1860.2200 at 9/30/12
Capacity Released/Purchased Deferred in 1860.2320 at 10/1/11
Capacity Released/Purchased Deferred in 1860.2320 through 6/30/12
Estimated Capacity Released/Purchased Deferred from 7/1 through 9/30/12
Estimated Balance in 1860.2320 at 9/30/12
Interest in 1860.2430 at 10/1/11
Interest Deferred in 1860.2430 through 6/30/12
Estimated Balance in 1860.2430 at 9/30/12
Management of Pipeline Transportation Capacity Deferred in 1860.2530 at 10/1/11
Management of Pipeline Transportation Capacity Deferred in 1860.2530 through 6/30/12
Estimated Deferral in 1860.2530 from 7/1 through 9/30/12
Estimated Balance in 1860.2530 at 9/30/12
RS-1 Amortization in 1860.2540 at 6/30/12
Estimated RS-1 Therm Sales from 7/1 through 9/30/12
Estimated RS-1 Amortization in 1860.2540 at 9/30/12
RS-2 Amortization in 1860.2540 at 6/30/12
Estimated RS-2 Therm Sales from 7/1 through 9/30/12
Estimated RS-2 Amortization in 1860.2540 at 9/30/12
GS-1 Amortization in 1860.2540 at 6/30/12
Estimated GS-1 Therm Sales from 7/1 through 9/30/12
Estimated GS-1 Amortization in 1860.2540 at 9/30/12
Estimated Core Amortization in 1860.2540 at 9/30/12
LV-1 Amortization in 1860.2550 at 6/30/12
Estimated LV-1 Block 1&2 Therm Sales from 7/1 through 9/30/12
Estimated LV-1 Amortization in 1860.2550 at 9/30/12
Estimated Industrial Amortization in 1860.2550 at 9/30/12
Estimated Balance in 1860.2530 at 9/30/12
ESTIMATED ACCOUNT 1860 FIXED BALANCE AT 9/30/12
TOTAL DEFERRED ACCOUNT 1860 BALANCE
check figure
Analysis of LV-1 Tariff Block 1, Block 2, and Block 3 Adjustments
Therm Sales
LV-1 Therm Sales (1/1/11 - 12/31/11)
Blocks 1 and 2 Therm Sales
Percent Therm Sales between Blocks 1 and 2
Proposed Adjustment to LV-1 Tariff (1)
Annualized Adjustment (Line 4 multiplied by Line 5)
Percent Annualized Sales included in Block 1 and Block 2
Adjustment to Block 1 and 2 (Line 7 multiplied by Line 8)
Block 1 and 2 Therms
Price Adjustment/Therm Block 1 and 2 (Line 9 divided by Line 10)
WACOG Commodity Charge Change (2)
Total Price Adjustment/Therm Block 1 and Block 2
Percent Annualized Sales included in Block 2
Adjustment to Block 2 (Line 14 multiplied by Line 15)
Block 2 Therms
Price Adjustment/Therm Block 2 (Line 16 divided by Line 17)
Total Price Adjustment/Therm Block 2
Price Adjustment/Therm Block 3 (3)
Eliminate INT-G-11-01 Variable Temporary
Total Price Adjustment/Therm Block 3
(1) See Exhibit No. 4; Line 30, Column (l) minus the difference of Line 21, Column (f) minus Line 21, Column (c)
(2) See Exhibit No. 4; Line 21, Column (f) minus Line 21, Column (c)
(3) See Exhibit No. 6, Line 3, Column (e)
Analysis of Lost and Unaccounted for Gas ("L&U")
Projected Oct 11 - Sep 12 L&U (Therms)
Estimated Oct 11 - Sep 12 Sales 1
Oct 11 - Sep 12 L&U Factor (line 2 divided by line 3)
Lost & Unaccounted for Gas (1860-2150) 2
L&U rate per therm embedded in base rates
Oct 11 - Sep 12 Collection of Lost & Unaccounted for Gas
Projected L&U (Over)/Under Collection (Line 6 minus Line 9)
1 Estimated Oct 11 - Sep 12 Sales (Therms)
Industrial
Total Sales
2 See Workpaper No. 6, Page 1, Line 34, Column (c)
INT-G-12-
1.00
Lost and Unaccounted for Gas
(Therms)
Lost and Unaccounted for Gas INT-G-12-01 (Therms)
2.00
4497955.00
3.00
592647090.00
4.00
7.59E-03
5.00
1.00
Lost and Unaccounted for Gas
(Dollars)
Lost and Unaccounted for Gas INT-G-12-01 (Dollars)
6.00
1.00
$3,139,485.00
7.00
1.00
592647090.00
8.00
1.00
1.82E-03
9.00
1.00
1078618.00
0.00
10.00
1.00
$2,060,867.00
32937650.00
169920320.00
109074634.00
280714486.00
592647090.00
1.00
3238019.00
0.00
0.00
3238019.00
2.00
3238019.00
0.00
3238019.00
3.00
1.00
5.00
0.00
5.00
1.00
4.00
0.03
5.00
LV-1 Therm Sales (1/1/11 - 12/31/11)
3238019.00
6.00
$103,519.47
2.00
7.00
$103,519.47
8.00
1.00
9.00
$103,519.47
2.00
10.00
3238019.00
11.00
0.03
5.00
12.00
-0.08
13.00
-0.05
5.00
14.00
$103,519.47
15.00
0.00
16.00
$0.00
2.00
17.00
0.00
18.00
0.03
5.00
19.00
-0.08
20.00
-0.05
5.00
14.00
1.00
-1.36E-03
15.00
1.00
-0.08
16.00
1.00
0.04
17.00
1.00
-0.04
5.00
1.00
2.00
1.00
($12,210,475.60)
3.00
1.00
$10,803,825.72
4.00
1.00
29682968.00
5.00
1.00
$0.04
$1,144,872.08
2.00
6.00
1.00
$11,948,697.80
2.00
7.00
1.00
($261,777.80)
2.00
8.00
1.00
($2,141,870.61)
9.00
1.00
($9,795,820.99)
10.00
1.00
($11,937,691.60)
11.00
1.00
($1,022,706.18)
12.00
1.00
($12,960,397.78)
2.00
13.00
1.00
$0.00
14.00
1.00
$48.44
15.00
1.00
($1,510.67)
16.00
1.00
($408.67)
17.00
1.00
($1,870.90)
2.00
18.00
1.00
($13,224,046.48)
2.00
19.00
1.00
20.00
1.00
($1,090,757.19)
21.00
1.00
-356047.31
22.00
1.00
($1,446,804.50)
2.00
23.00
1.00
$967,785.38
24.00
1.00
28891567.00
25.00
1.00
$0.00
$100,253.74
2.00
26.00
1.00
$1,068,039.12
2.00
27.00
1.00
$353,283.68
28.00
1.00
61088751.00
29.00
1.00
$0.00
$97,742.00
2.00
30.00
1.00
$451,025.68
2.00
31.00
1.00
$72,260.30
2.00
32.00
1.00
$4,754.91
33.00
1.00
$3,139,484.65
34.00
1.00
$0.00
35.00
1.00
$3,139,484.65
36.00
1.00
$914,830.45
37.00
1.00
163787.25
38.00
1.00
$1,078,617.70
39.00
1.00
$2,060,866.95
40.00
1.00
$2,065,621.86
41.00
1.00
0.75
$1,549,216.39
2.00
42.00
1.00
0.25
$516,405.46
2.00
43.00
1.00
$2,065,621.85
2.00
44.00
1.00
$59.10
45.00
1.00
$144.59
46.00
1.00
$46.12
47.00
1.00
$249.81
2.00
48.00
1.00
$24.07
49.00
1.00
$46.46
50.00
1.00
$17.47
51.00
1.00
$88.00
2.00
52.00
1.00
$2,138,219.96
2.00
53.00
1.00
54.00
1.00
($5,862,393.72)
55.00
1.00
($4,521.52)
56.00
1.00
$693,448.00
57.00
1.00
1600164.00
58.00
1.00
$0.02
$35,555.64
2.00
59.00
1.00
$724,482.12
2.00
60.00
1.00
$15,738.38
61.00
1.00
$2,133,777.75
62.00
1.00
11130908.00
63.00
1.00
$0.01
$151,269.04
2.00
64.00
1.00
$2,300,785.17
2.00
65.00
1.00
($3,556.40)
66.00
1.00
$2,367,960.14
67.00
1.00
16160495.00
68.00
1.00
$0.03
$419,203.24
2.00
69.00
1.00
$2,783,606.98
2.00
70.00
1.00
$16.30
71.00
1.00
$12,960.05
72.00
1.00
791401.00
73.00
1.00
$0.00
$3,727.50
2.00
74.00
1.00
$16,703.85
2.00
75.00
1.00
($36,815.60)
2.00
1.00
$493,519.71
2.00
1.00
($7,672,621.46)
3.00
1.00
$8,795,402.62
4.00
1.00
$1,616,300.87
5.00
1.00
($1,035,804.14)
6.00
1.00
($2,949,021.23)
7.00
1.00
($1,231,754.94)
8.00
1.00
($5,216,580.31)
9.00
1.00
($50.44)
10.00
1.00
($773.58)
11.00
1.00
($249.51)
12.00
1.00
($1,073.53)
2.00
13.00
1.00
($67,062.86)
14.00
1.00
($4,180,102.49)
15.00
1.00
($571,703.00)
16.00
1.00
($4,818,868.35)
2.00
17.00
1.00
$406,231.31
18.00
1.00
1600164.00
19.00
1.00
$0.01
$21,154.17
2.00
20.00
1.00
$427,385.48
2.00
21.00
1.00
$1,835,535.77
22.00
1.00
11130908.00
23.00
1.00
$0.01
$128,784.61
2.00
24.00
1.00
$1,964,320.38
2.00
25.00
1.00
$1,050,668.52
26.00
1.00
16160495.00
27.00
1.00
$0.01
$192,309.89
2.00
28.00
1.00
$1,242,978.41
2.00
29.00
1.00
$3,634,684.27
30.00
1.00
$14,338.32
31.00
1.00
791401.00
32.00
1.00
$0.00
$3,988.66
2.00
33.00
1.00
$18,326.98
2.00
34.00
1.00
$18,326.98
2.00
35.00
1.00
($1,165,857.10)
2.00
36.00
1.00
($4,804,025.67)
2.00
37.00
1.00
($15,889,852.19)
2.00
($15,889,852.19)
$0.00
1.00
2.00
457182.00
2110168.00
1298661.00
14150.00
3880161.00
3.00
0.12
6.00
0.54
6.00
0.33
6.00
3.65E-03
6.00
1.00
4.00
PROPOSED DEMAND ALLOCATORS PER CASE NO.
:
PROPOSED DEMAND ALLOCATORS PER CASE NO. INT-G-12-01:
5.00
1.00
5.66
7.61
32.72
6.00
1.00
65076.00
220569.00
30607.00
316252.00
7.00
1.00
Peak Day Therms (Line 5 mulitplied by Line 6)
INT-G-12-01 Peak Day Therms (Line 5 mulitplied by Line 6)
368330.00
0.00
1678530.00
0.00
1001461.00
0.00
13150.00
3061471.00
8.00
1.00
0.12
6.00
0.55
6.00
0.33
6.00
4.30E-03
6.00
1.00
7.00
LORI BLATTNER:
from 2012-13f LV1 projection.xlsx
INT-G-11-01
INT-G-11-01
INT-G-11-01
INT-G-11-01
1.00
$75,971.24
2.00
2.00
2.00
266250.00
0.29
$75,971.00
$911,652.00
63299.38
2.00
2.00
1.00
3.00
221840.00
0.29
63299.00
759588.00
75977.10
2.00
2.00
4.00
213010.00
0.29
60780.00
729360.00
5.00
31950000.00
2.38E-03
75977.00
911724.00
63327.81
2.00
13.56
2.00
13.56
6.00
26625000.00
2.38E-03
63314.00
759768.00
2.00
2.00
7.00
25560000.00
2.38E-03
60782.00
729384.00
8.00
84135000.00
$400,123.00
$4,801,476.00
9.00
10.00
84135000.00
7.41E-04
$62,305.00
$747,665.00
11.00
12.00
$17,813.00
$213,750.00
13.00
1.00
21000.00
14.00
1.00
$234,750.00
0.00
15.00
1.00
($2,700,000.00)
16.00
1.00
$3,083,891.00
2.00
2.00
INT-G-12-01
INT-G-12-01
INT-G-12-01
INT-G-12-01
5.00
5.00
17.00
1.00
18.00
266250.00
0.29
$75,971.00
$911,652.00
19.00
221840.00
0.29
63299.00
759588.00
20.00
213010.00
0.29
60780.00
729360.00
21.00
31950000.00
2.38E-03
75977.00
911724.00
22.00
26625000.00
2.38E-03
63314.00
759768.00
23.00
25560000.00
2.38E-03
60782.00
729384.00
24.00
1.00
84135000.00
$400,123.00
0.00
$4,801,476.00
0.00
25.00
1.00
26.00
84135000.00
1.03E-03
6.00
$86,929.00
$1,043,148.05
27.00
1.00
28.00
$7,245.00
12.00
0.00
$86,940.00
29.00
10000.00
30.00
$96,940.00
0.00
31.00
1.00
($2,700,000.00)
32.00
1.00
$3,241,564.00
0.00
33.00
1.00
$157,673.00
0.00
INT-G-11-01
INT-G-11-01
INT-G-11-01
1.00
190217520.00
0.02
$3,188,101.00
2.00
149664020.00
9.68E-03
1448863.00
3.00
155553660.00
0.02
2696640.00
4.00
301155780.00
0.02
5047459.00
5.00
293524680.00
9.67E-03
2839559.00
6.00
160127480.00
0.01
2224408.00
7.00
$17,445,030.00
0.00
8.00
1.00
($500,000.00)
9.00
1.00
$16,945,030.00
INT-G-12-01
INT-G-12-01
INT-G-12-01
10.00
1.00
0.00
0.00
$0.00
11.00
25933250.00
9.92E-03
257358.61
12.00
155025220.00
0.02
2749310.27
13.00
477215600.00
0.02
8208666.92
14.00
378465810.00
9.93E-03
3758102.76
15.00
164786200.00
0.01
1827557.98
16.00
$16,800,997.00
0.00
17.00
1.00
($500,000.00)
18.00
1.00
$16,300,997.00
19.00
1.00
($644,033.00)
0.00
INT-G-11-01
INT-G-11-01
INT-G-11-01
1.00
28548000.00
0.02
$596,508.00
2.00
1.00
29484960.00
0.02
594030.00
3.00
1.00
58560000.00
0.02
1112171.00
4.00
1.00
36600000.00
0.02
903642.00
5.00
1.00
153192960.00
0.00
0.02
6.00
3206351.00
0.00
INT-G-12-01
INT-G-12-01
INT-G-12-01
6.00
1.00
14052500.00
0.02
$282,559.00
7.00
1.00
29404400.00
0.02
627190.00
8.00
1.00
58400000.00
0.02
1291685.00
9.00
1.00
36500000.00
0.03
954085.00
10.00
1.00
32850000.00
8.50E-03
279320.00
11.00
1.00
171206900.00
0.02
3434839.00
12.00
1.00
$228,488.00
0.00
INT-G-11-01
INT-G-11-01
INT-G-11-01
1.00
413667840.00
0.04
$16,097,001.00
2.00
25620000.00
0.05
1362835.00
3.00
73200000.00
0.04
2780430.00
4.00
23607000.00
0.04
896688.00
5.00
49106220.00
0.04
1865251.00
6.00
36600000.00
0.04
1390212.00
7.00
43920000.00
0.04
1668258.00
8.00
36600000.00
0.02
903642.00
9.00
104782140.00
0.03
3383034.00
10.00
807103200.00
0.00
0.04
6.00
$30,347,351.00
0.00
INT-G-12-01
INT-G-12-01
INT-G-12-01
11.00
1.00
412537600.00
0.04
$16,940,550.31
12.00
25550000.00
0.05
1388910.00
13.00
73000000.00
0.04
2935648.00
14.00
64389650.00
0.04
2589386.00
15.00
46230900.00
0.04
1859147.00
16.00
36500000.00
0.04
1467823.00
17.00
87600000.00
0.04
3522778.00
18.00
36500000.00
0.04
1467823.00
19.00
104495850.00
0.04
4202235.00
20.00
886804000.00
0.04
$36,374,300.00
0.00
21.00
1.00
$6,026,949.00
0.00
?10?/?1?/?2012
34441859.15
$29,777,743.00
0.00
$0.86
($129,157.00)
0.00
$0.00
5.00
$29,648,586.00
0.00
$0.86
5.00
-4.30E-03
4.00
179566955.69
136373920.00
0.00
0.76
-4257533.00
0.00
-0.02
5.00
132116387.00
0.00
0.74
5.00
-0.03
4.00
108355214.88
76225727.00
0.00
0.70
-2390316.00
0.00
-0.02
5.00
73835411.00
0.00
0.68
5.00
-0.03
4.00
5.00
3238019.00
1637434.00
0.00
0.51
-165981.00
0.00
-0.05
5.00
1471453.00
0.00
0.45
5.00
-0.10
4.00
6.00
325602048.71
244014824.00
0.75
5.00
-6942987.00
0.00
-0.02
5.00
237071837.00
0.00
0.73
5.00
-0.03
4.00
7.00
72684394.00
1176033.00
0.00
0.02
304548.00
0.00
4.19E-03
1.60E-03
5.00
1480581.00
0.00
0.02
5.00
0.26
5.00
8.00
141865782.00
5883174.00
0.00
0.04
594418.00
0.00
4.19E-03
1.60E-03
5.00
6477592.00
0.00
0.05
5.00
0.10
5.00
9.00
660840.00
556778.00
0.00
0.84
0.00
0.00
0.00
0.00
5.00
556778.00
0.00
0.84
5.00
0.00
0.00
0.00
4.00
10.00
18604304.00
16000.00
0.00
8.60E-04
77952.00
0.00
4.19E-03
1.60E-03
5.00
93952.00
0.00
5.05E-03
5.00
4.87
0.00
0.00
4.00
11.00
18604304.00
572778.00
0.03
5.00
77952.00
4.19E-03
5.00
650730.00
0.03
5.00
0.14
4.00
12.00
233154480.00
7631985.00
0.03
5.00
976918.00
4.19E-03
5.00
8608903.00
0.04
5.00
0.13
4.00
13.00
558756528.71
$251,646,809.00
$0.45
5.00
($5,966,069.00)
($0.01)
5.00
$245,680,740.00
$0.44
5.00
-0.02
4.00
1.00
2.00
($11,937,692.00)
0.00
3.00
307918911.00
4.00
($0.04)
5.00
1.00
2.00
($1,286,355.00)
0.00
3.00
Normalized Sales Volumes (1/1/11 - 12/31/11)
325602048.71
4.00
$0.00
5.00
5.00
6.00
($1,090,757.00)
0.00
7.00
$1,068,039.00
0.00
8.00
($22,718.00)
9.00
Lost and Unaccounted For Gas
Lost and Unaccounted For Gas INT-G-12-01
$1,549,466.00
0.00
10.00
$1,526,748.00
11.00
Normalized Sales Volumes (1/1/11 - 12/31/11)
322364029.71
12.00
$0.00
5.00
13.00
14.00
($356,047.00)
0.00
15.00
$451,026.00
0.00
16.00
$94,979.00
17.00
Lost and Unaccounted For Gas
Lost and Unaccounted For Gas INT-G-12-01
$516,493.00
0.00
18.00
$611,472.00
19.00
Normalized Sales Volumes (1/1/11 - 12/31/11)
236392499.00
20.00
$0.00
5.00
1.00
2.00
1.00
($36,816.00)
0.00
($14,940.00)
-739422.00
0.00
($85,150.00)
-2385934.72
0.00
$59,287.00
-2724320.00
0.00
$3,987.00
-12717.00
0.00
($36,816.00)
$0.00
0.12
0.55
0.33
4.30E-03
1.00
3.00
1616301.00
0.00
302670.00
1315972.00
50828.00
-53169.00
$1,616,301.00
$0.00
0.12
0.55
0.33
4.30E-03
1.00
4.00
-5216580.00
0.00
-627612.00
0.00
-2860126.00
0.00
-1706437.00
0.00
-22405.00
0.00
($5,216,580.00)
$0.00
0.12
0.55
0.33
4.30E-03
1.00
5.00
-1074.00
0.00
-129.00
0.00
-589.00
0.00
-351.00
0.00
-5.00
0.00
($1,074.00)
$0.00
0.12
0.55
0.33
4.30E-03
1.00
6.00
-4818868.00
0.00
-567788.00
0.00
-2620665.00
0.00
1.00
-1612841.00
0.00
-17574.00
0.00
($4,818,868.00)
$0.00
0.12
0.54
0.33
3.65E-03
1.00
7.00
3653011.00
0.00
427385.00
0.00
1964321.00
0.00
1.00
1242978.00
0.00
18327.00
0.00
$3,653,011.00
$0.00
0.12
0.55
0.33
4.30E-03
1.00
8.00
($4,804,026.00)
0.00
($480,414.00)
0.00
($2,286,237.00)
0.00
($1,966,536.00)
0.00
($70,839.00)
0.00
($4,804,026.00)
$0.00
$0.00
$0.00
9.00
1.00
Normalized Sales Volumes (1/1/11 - 12/31/11)
34441859.15
179566955.69
108355214.88
3238019.00
10.00
1.00
($0.01)
5.00
($0.01)
5.00
($0.02)
5.00
($0.02)
5.00
Lori Blattner:
enter A/C 186-205 beginning balance attributed to RS-1
0.12
0.55
0.33
4.30E-03
1.00
($1,331,728.00)
($160,222.00)
0.00
($730,154.00)
0.00
1.00
($435,632.00)
0.00
($5,720.00)
0.00
($1,331,728.00)
0.00
2.00
($2,394,540.00)
($288,090.00)
0.00
($1,312,868.00)
0.00
1.00
($783,297.00)
0.00
($10,285.00)
0.00
($2,394,540.00)
0.00
3.00
($3,726,268.00)
($448,312.00)
($2,043,022.00)
($1,218,929.00)
($16,005.00)
($3,726,268.00)
0.00
4.00
Normalized Sales Volumes (1/1/11 - 12/31/11)
34441859.15
179566955.69
108355214.88
3238019.00
5.00
($0.01)
5.00
($0.01)
5.00
($0.01)
5.00
$0.00
5.00
1.00
($0.01)
($0.01)
($0.01)
$0.00
2.00
-0.01
-0.01
-0.02
-0.02
3.00
7.90E-04
7.90E-04
7.90E-04
-1.36E-03
4.00
($0.03)
($0.02)
($0.03)
($0.03)
?10?/?1?/?2011
INT-G-11-01
INT-G-11-01
INT-G-11-01
1.00
2.00
3.00
621801060.00
$0.04
5.00
$24,392,417.00
$2,934,676.00
0.00
$13,373,777.00
0.00
$7,979,199.00
0.00
$104,765.00
0.00
$0.00
$24,392,417.00
0.00
0.12
0.55
0.33
4.30E-03
1.00
4.00
338495100.00
0.03
9161285.00
1102203.00
0.00
5022913.00
0.00
2996821.00
0.00
39348.00
0.00
1.00
$9,161,285.00
0.00
0.12
0.55
0.33
4.30E-03
1.00
5.00
1250243140.00
0.01
16945030.00
0.00
2038674.00
0.00
9290553.00
0.00
5543024.00
0.00
72779.00
0.00
2.00
$16,945,030.00
0.00
0.12
0.55
0.33
4.30E-03
1.00
6.00
0.12
0.55
0.33
4.30E-03
1.00
7.00
8.00
303370.00
1.55E-03
5.00
171742.00
0.00
20662.00
0.00
94162.00
0.00
56180.00
0.00
738.00
0.00
1.00
$171,742.00
0.00
0.12
0.55
0.33
4.30E-03
1.00
9.00
10920990.00
6.00E-05
5.00
223225.00
0.00
26856.00
0.00
122389.00
0.00
73021.00
0.00
959.00
0.00
2.00
$223,225.00
0.00
0.12
0.55
0.33
4.30E-03
1.00
10.00
10920990.00
0.04
5.00
414779.00
0.00
49902.00
0.00
227414.00
0.00
1.00
135682.00
0.00
1781.00
0.00
3.00
$414,779.00
0.00
0.12
0.55
0.33
4.30E-03
1.00
11.00
10920990.00
3.00E-03
5.00
32763.00
0.00
3942.00
0.00
17963.00
0.00
10717.00
0.00
141.00
0.00
4.00
$32,763.00
0.00
0.12
0.55
0.33
4.30E-03
1.00
12.00
$0.00
13.00
1132000.00
3.06E-03
5.00
1264331.00
0.00
152113.00
693203.00
0.00
1.00
413585.00
5430.00
6.00
$1,264,331.00
0.00
0.12
0.55
0.33
4.30E-03
1.00
14.00
10962235.00
3.90E-04
5.00
1560474.00
0.00
187742.00
855571.00
0.00
1.00
510459.00
6702.00
7.00
$1,560,474.00
0.00
0.12
0.55
0.33
4.30E-03
1.00
15.00
10962235.00
0.06
5.00
702789.00
0.00
84553.00
385323.00
0.00
1.00
229895.00
3018.00
8.00
$702,789.00
0.00
0.12
0.55
0.33
4.30E-03
1.00
16.00
10962235.00
0.04
5.00
458660.00
0.00
55182.00
251472.00
0.00
150036.00
1970.00
9.00
$458,660.00
0.00
0.12
0.55
0.33
4.30E-03
1.00
17.00
10962235.00
0.04
5.00
416346.00
0.00
50091.00
228273.00
0.00
136194.00
1788.00
10.00
$416,346.00
0.00
0.12
0.55
0.33
4.30E-03
1.00
18.00
10962235.00
3.00E-03
5.00
32887.00
0.00
3957.00
18031.00
0.00
10758.00
141.00
11.00
$32,887.00
0.00
0.12
0.55
0.33
4.30E-03
1.00
19.00
3083891.00
371026.00
1690824.00
0.00
1.00
1008796.00
13245.00
11.00
$3,083,891.00
0.00
0.12
0.55
0.33
4.30E-03
1.00
20.00
1.00
$58,860,619.00
$7,081,579.00
$32,271,868.00
$19,254,367.00
$252,805.00
$43.00
$58,860,619.00
0.00
21.00
1.00
Normalized Sales Volumes (
Estimated Volumes)
Normalized Sales Volumes (INT-G-12-01 Estimated Volumes)
33539901.00
182285966.00
107719520.00
3343141.00
0.00
22.00
1.00
$0.21
5.00
$0.18
5.00
$0.18
5.00
$0.08
5.00
$0.00
0.00
0.00
5.00
23.00
1.00
$0.20
$0.18
$0.19
$0.07
24.00
1.00
$0.00
$0.00
$0.00
$0.00
25.00
1.00
26.00
1.00
$0.21
$0.18
$0.18
$0.08
27.00
1.00
0.02
0.02
0.02
7.72E-03
28.00
1.00
Fixed Costs Collected
INT-G-12-01 Fixed Costs Collected
$0.23
$0.19
$0.20
$0.08
IGC:
From "2012-13 LV1 projection.xls" from Lance 7/20/12

IGC:
08 Industustrial by rate class for Lori.xls

?10?/?1?/?2011
?10?/?1?/?2012
INT-G-11-01
INT-G-11-01
INT-G-12-01
INT-G-12-01
1.00
2.00
3.00
807103200.00
$0.04
$30,347,351.00
886804000.00
0.00
$0.04
5.00
$36,374,300.00
0.00
$6,026,949.00
0.00
$725,108.00
0.00
$3,304,431.00
0.00
$1,971,524.00
0.00
$25,886.00
0.00
$0.00
6026949.00
0.00
0.12
0.55
0.33
4.30E-03
1.00
4.00
153192960.00
0.02
3206351.00
171206900.00
0.00
0.02
5.00
3434839.00
0.00
228488.00
0.00
27490.00
0.00
125274.00
0.00
74743.00
0.00
981.00
0.00
228488.00
0.00
0.12
0.55
0.33
4.30E-03
1.00
5.00
1250243140.00
0.01
16945030.00
1201426080.00
0.00
0.01
5.00
16300997.00
0.00
-644033.00
0.00
-77484.00
0.00
-353108.00
0.00
-210675.00
0.00
-2766.00
0.00
-644033.00
0.00
0.12
0.55
0.33
4.30E-03
1.00
6.00
0.00
0.00
7.00
0.00
0.00
8.00
303370.00
1.55E-03
171742.00
303370.00
110730050.00
365.00
1.56E-03
365.00
5.00
172541.69
800.00
0.00
96.00
0.00
439.00
0.00
262.00
0.00
3.00
0.00
$0.00
800.00
0.00
0.12
0.55
0.33
4.30E-03
1.00
9.00
10920990.00
6.00E-05
223225.00
10920990.00
3986161350.00
365.00
6.00E-05
365.00
5.00
226206.46
2981.00
0.00
359.00
0.00
1634.00
0.00
975.00
0.00
13.00
0.00
$0.00
2981.00
0.00
0.12
0.55
0.33
4.30E-03
1.00
10.00
10920990.00
0.04
414779.00
10920990.00
0.04
439172.82
24394.00
0.00
2935.00
0.00
13374.00
0.00
1.00
7980.00
0.00
105.00
0.00
$0.00
24394.00
0.00
0.12
0.55
0.33
4.30E-03
1.00
11.00
10920990.00
3.00E-03
32763.00
10920990.00
3.00E-03
32763.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
$0.00
0.00
0.00
0.12
0.55
0.33
4.30E-03
1.00
12.00
0.00
0.00
13.00
1132000.00
3.06E-03
1264331.00
1132000.00
3.06E-03
1261851.73
-2479.00
-298.00
-1359.00
-811.00
-11.00
$0.00
-2479.00
0.00
0.12
0.55
0.33
4.30E-03
1.00
14.00
10962235.00
3.90E-04
1560474.00
10962350.00
3.90E-04
1560490.53
17.00
2.00
9.00
6.00
0.00
$0.00
17.00
0.00
0.12
0.55
0.33
4.30E-03
1.00
15.00
10962235.00
0.06
702789.00
10962350.00
0.06
702796.00
0.00
7.00
1.00
4.00
2.00
0.00
$0.00
7.00
0.00
0.12
0.55
0.33
4.30E-03
1.00
16.00
10962235.00
0.04
458660.00
10962350.00
0.04
458665.00
0.00
5.00
1.00
2.00
0.00
1.00
2.00
0.00
$0.00
5.00
0.00
0.12
0.55
0.33
4.30E-03
1.00
17.00
10962235.00
0.04
416346.00
10962350.00
0.04
440844.00
0.00
24498.00
2947.00
13432.00
8014.00
105.00
$0.00
24498.00
0.00
0.12
0.55
0.33
4.30E-03
1.00
18.00
10962235.00
3.00E-03
32887.00
10962350.00
3.00E-03
32887.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
$0.00
0.00
0.00
0.12
0.55
0.33
4.30E-03
1.00
19.00
157673.00
0.00
18970.00
86448.00
0.00
51578.00
677.00
157673.00
0.00
0.12
0.55
0.33
4.30E-03
1.00
0.00
0.00
20.00
1.00
0.00
0.00
21.00
1.00
325602048.71
0.42
136140729.00
0.00
325602048.71
0.33
109040870.00
0.00
-27099859.00
0.00