Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
ATMOS Energy Annual Gas Cost Filing
.TMOS energy Charles R. Yarbrough, II Vice President Rates & Reoulatorv Affairs August 31, 2007 TO THE GOVERNING BODY OF ALL MUNICIPALITIES SERVED BY A TMOS ENERGY CORP., MID-TEX DIVISION On August 31, 2007, Atmos Energy Corp., Mid-Tex Division (the "Company"), filed its Annual Gas Cost Reconciliation Filing for the twelve month period ended June 3D, 2007. This report has been prepared in accordance with the Order of the Railroad Commission of Texas under Gas Utilities Docket No. 9400. This report reconciles the Company's expenditures for gas with the billing of those costs to residential, commercial and industrial customers for the period noted above. This filing is for informative purposes only and no action is required on your city's part. Enclosed is a copy of the schedules filed with the Commission. Should you have any questions, please contact me at 214-206-2809. Sincerely, Atmos Energy Corporation 5420 LBJ Freeway, Suite 1800 Dallas, TX 75240 P 214-206-2809 F 214-206-2126 charles.yarbrough@atmosenergy.com ATMOS energy Charles R. Yarbrough, II Vice President Rates & Reoulatorv Affairs August 31, 2006 Mr. Stephen L. Pitner Railroad Commission of Texas Gas Services Division 1701 North Congress Avenue P. O. Box 12967 Austin, Texas 78711-2967 Re: Atmos Energy Corp., Mid-Tex Division Annual Gas Cost Reconciliation Filing Dear Mr. Pitner: Attached is Atmos Energy Corp., Mid-Tex Division's (the "Company") Gas Cost Reconciliation filing for the twelve month period ended June 30, 2007. This report has been prepared in accordance with the order of the Railroad Commission of Texas under Gas Utilities Docket ("GUD") No. 9400. In response to the Railroad Commission of Texas Audit No. 06-037, Auditor's Recommendation, the Company has included an additional schedule (Schedule 9) in the filing to reflect the percentage of Lost and Unaccounted For Gas for the reconciliation period. Additionally, the Company has not included the cost of odorant in gas cost as directed by the Commission; however, the Company again reiterates that it does not agree with this position. The Company is requesting herein an exception to the Final Order issued in GUD 9400, Finding of Fact 121, which directs the Reconciliation Factor to be determined for the "succeeding October through June billing months." In this filing, the Company is requesting the Reconciliation Factor be determined using the months of October through March. Due to the (Over) collection during the current reconciliation period, as shown on Schedule 2 (attached), the Company would prefer to refund the (Over) collection to customers during the typical peak winter usage period to help mitigate the seasonally higher gas cost. The Company has included the standard calculation of the Reconciliation Factor over the nine (9) month period designated in GUD 9400 of ($.0781) and an alternative calculation of the Reconciliation Factor over a six (6) month period of ($.0954). Please advise as soon as possible regarding approval to refund the Over collection over a six (6) month period. Atmos Energy Corporation 5420 LBJ Freeway, Suite 1800 Dallas, TX 75240 n "'l-t A "line "'l~f'\n ~ "')-t A "')n.c .,.. 'lC ....h......I,..... ......~.."I ,,.,ht;;'\"=It"""',.,,~on.c.r"n\f r-nm Atmos Energy Page 2 Included in this filing is my certification, a Table of Contents that provides a listing and description of each document, and all of the reconciliation schedules and workpapers listed on the Table of Contents. Copies of this filing are being provided to all incorporated municipalities served by Atmos Energy Corp., Mid-Tex Division. Should there be any questions related to this filing, please call me at 214-206-2860. Sincerely, Attachments: cc: Mr. William O. Geise, Railroad Commission of Texas Mr. Lindil Fowler, Railroad Commission of Texas Mr. Edward D. Abrahamson, Railroad Commission of Texas ') ATMOS ENERGY CORP., MID-TEX DIVISION ANNUAL GAS COST RECONCILIATION FILING FOR THE PERIOD ENDED JUNE 30, 2007 PREPARED IN ACCORDANCE WITH THE ORDER OF THE RAILROAD COMMISSION OF TEXAS UNDER GAS UTILITIES DOCKET NO. 9400 The attached Annual Gas Cost Reconciliation Filing for the period ended June 30, 2007, was prepared by me or under my direct supervision. J hereby certify that the information contained therein is true and correct and that the Filing was prepared in accordance with the order of the Railroad Commission of Texas in Gas Utilities Docket No. 9400. arbrough, " Vice President Rates & Regulatory Affairs Filed: August 31, 2006 ATMOS ENERGY CORP., MID-TEX DIVISION ANNUAL GAS COST RECONCILIATION FILING FOR THE PERIOD ENDED JUNE 30, 2007 TABLE OF CONTENTS I Document Title I Document Description I Schedule 1 Schedule 2 Schedule 3 Schedule 4 Schedule 5 Schedule 6 Schedule 7 Schedule 8 Schedule 9 Calculation of Reconciliation Factor Summary of (Over)/Under Recovery Gas Cost Incurred Gas Cost Incurred - By Month Gas Cost Billed Interest Calculation Estimated Volume Calculation for (Refund)/Surcharge Summary of (Over)/Under Recovery from Previous Filing Lost And Unaccounted For Gas ("LUG") Calculation WP/Billed Gas Cost WP/LUG-Related Mcf Gas Cost Billed - By Month LUG-Related Volumes/Quantities - By Month Line No. Schedule 1 ATMOS ENERGY CORP., MID-TEX DIVISION ANNUAL GAS COST RECONCILIATION FILING FOR THE PERIOD ENDED JUNE 30, 2007 CALCULATION OF RECONCILIATION FACTOR Description (a) Amount (b) Reference - (c) 1 2 3 4 5 Total Amount to (Retund)/Surcharge $ (9,472,337) Schedule 2, Col. (b), Line 11 Total Estimated Rate R, Rate C and Rate I Met 121,238,452 Schedule 7, Col. (b), Line 11 Reconciliation Factor $ (0.0781) Line 1 divided by Line 3 Schedule 2 A TMOS ENERGY CORP", MID- TEX DIVISION ANNUAL GAS COST RECONCILIATION FILING FOR THE PERIOD ENDED JUNE 30, 2007 SUMMARY OF (OVER)/UNDER RECOVERY Line No. Description Amount Reference (a) (b) (c) 1 Gas Cost Incurred $ 985,247,718 Schedule 3, Co/. (c), Line 23 2 3 Gas Cost Billed 995,250,765 Schedule 5, Co/. (g), Line 14 4 5 Total Gas Cost (Over)/Under Recovered $ (10,003,047) Line 1 minus Line 3 6 7 Amount Remaining from Previous Filing 178,074 Schedule 8, Co/. (b), Line 7 8 9 Interest 352,637 Schedule 6, Co/. (t), Line 27 10 11 Total Amount to (Refund)/Surcharge $ (9,472,337) Line 5 plus Line 7 plus Line 9 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 FERC Account (a) 800 801 802 803 804 805 806 807 808.1 808.2 809 810 811 812 813 (2) 858 ATMOS ENERGY CORP., MID-TEX DIVISION ANNUAL GAS COST RECONCILIATION FILING FOR THE PERIOD ENDED JUNE 30, 2007 GAS COST INCURRED Schedule 3 Description Amount (1) (b) (c) Natural Gas Well Head Purchases Natural Gas Field Line Purchases Natural Gas Gasoline Plant Outlet Purchases Natural Gas Transmission Line Purchases Natural Gas City Gate Purchases Other Gas Purchases Exchange Gas Purchased Gas Expenses Gas Withdrawn From Storage - Debit Gas Delivered To Storage - Credit Withdrawals/Deliveries of Liquefied Natural Gas Held for Processing Gas Used for Compressor Station Fuel - Credit Gas Used for Products Ex1raction - Credit Gas Used for Other Utility Operations - Credit Other Gas Supply Expenses Transmission and Compression of Gas by Others Total Gas Cost Incurred 805 Less: Total Imbalance Fees (3) Total Gas Cost Less Imbalance Fees Note: 1. Reference Schedule 4 for monthly amounts. 2. Excluded pursuant to Railroad Commission letter directive, March 3, 2006. 3. Reference Schedule 4, Line 25. $ 817,487 13,196,886 965,969,504 77,541 (1,941,121 ) 69,191,438 (61,084,942) (174,458) 429,462 $ 986,481,797 $ 1,234,079 $ 985,247,718 Schedule 4 Page 6 of 20 ATMOS ENERGY CORP., MID-TEX DIVISION ANNUAL GAS COST RECONCILIATION FILING FOR THE PERIOD ENDED JUNE 30, 2007 GAS COST INCURRED - BY MONTH Line FERC No. Account Jul-06 Au -06 Se -{)6 Oct-06 Nov-06 Dec-06 (a) (b) (c) (d) (e) (I) (g) 1 800 $ 17,256 $ 75,619 $ 47,531 $ 106,213 $ 34,443 $ 88,169 2 800.1 3 801 4 802 1,699,781 1,278,647 1,423,629 1,482,467 5,046,233 (2,700,077) 5 803 24,043,043 26,439,836 25,596,521 26,039,435 82,120,107 154,719,069 6 804 7 804.1 8 805 33,135 4,854 5,929 9 805.1 10 806 (25,262) (3,875,481 ) 1,186,513 2,374,186 4,345,800 (1,143,847) 11 807 12 808.1 3,240,073 16,532,221 13 808.2 2,070 (2,275,628) (6,838,525) 14 809.1 15 809.2 16 810 17 811 18 812 (13,600) (11,221) (12,427) (7,590) (9,904) (19,228) 19 813 (1) 20 858 16,700 40,128 21 22 23 Tolal Gas Cost Incurred $ 25 723 288 $ 23,907,401 $ 28,274,901 $ 29,999,563 $ 92,517,825 $ 160,683837 24 25 805 $ 101,165 $ 124,594 $ 81,556 $ 184,671 $ 319,498 $ 111,580 26 27 Total Imbalance Fees $ 101,165 $ 124,594 $ 81,556 $ 184,671 $ 319498 $ 111,580 28 29 Total Gas Cost less 30 Imbalance Fees $ 25622123 $ 23,782,807 $ 28,193,345 $ 29,814,892 $ 92,198,327 $ 160 572 257 31 32 33 Note: 34 1. Excluded pursuanllo Railroad Commission lelter directive, March 3, 2006. Schedule 4 Page 7 of 20 ATMOS ENERGY CORP., MID-TEX DIVISION ANNUAL GAS COST RECONCILIATION FILING FOR THE PERIOD ENDED JUNE 30, 2006 GAS COST INCURRED - BY MONTH Line FERC No. Account Jan-07 Feb-07 Mar-{)7 Apr-07 Ma -07 Jun-07 Amount (a) (h) (i) (j) (k) (I) (m) (n) 1 800 $ 63,059 $ 74,043 $ 62,605 $ 77,471 $ 139,387 $ 31,691 $ 817,487 2 800.1 3 801 4 802 1,215,636 B60,803 975,716 1,067,872 400,260 445,920 13,196,B86 5 803 204,281,480 161,603,835 79,203,077 78,972,861 56,058,175 46,892,064 965,969,504 6 804 7 804.1 8 805 420 12,745 9,654 6,146 4,660 77,541 9 805.1 10 806 4,666,579 (7,526,115) (7,015,877) 10,746,884 (7,103,716) 1,429,215 (1,941,121) 11 807 12 808.1 21,003,361 26,019,250 2,396,534 69,191,438 13 808.2 (410,002) 133,470 (20,152,706) (17,429,718) (14,113,905) (61,084,942) 14 809.1 15 809.2 16 810 17 811 18 812 (25,206) (26,255) (17,872) (9,695) (9,220) (12,239) (174,458) 19 813 (1) 20 858 77,383 147,171 77,815 41,713 28,553 429,462 21 22 23 Total Gas Cost Incurred $ 230 872 709 $ 181 298948 $ 75681 996 $ 70 754 054 $ J2 089 867 $ 34 677 406 $ 986 481 797 24 25 805 $ 65,942 $ 140,047 $ 16,164 $ 21,058 $ 67,893 $ 90 $ 1,234,079 26 27 Total Imbalance Fees $ 65,942 $ 140,047 $ 16,164 $ 21,058 $ 67,893 $ (90) $ 1,234,079 28 29 Total Gas Cost Less 30 Imbalance Fees $ 230806 767 $ 181,158,901 $ 75,665,832 $ 70,732,996 $ 32,021,973 $ 34,677 497 $ 985.247,718 31 32 33 Note: 34 1. Excluded pursuant to Railroad Commission lelter directive, March 3, 2006. Schedule 5 ATMOS ENERGY CORP., MID-TEX DIVISION ANNUAL GAS COST RECONCILIATION FILING FOR THE PERIOD ENDED JUNE 30, 2007 GAS COST BILLED Billed Volumes/Quantities Line - --. . ..-..- . Total Gas Cost No. Month-Yr Rate R Me Rate C Me Recovered (1 (a) (b) (c) (g) 1 July-06 1,877,838 2,092,824 3,970,663 281,721 (1) 29,664,509 2 August-06 1,774,467 2,239,462 4,013,929 284,096 (1) 29,573,468 3 Septem ber -06 1,781,686 2,200,621 3,982,307 241,504 (1) 29,091,933 4 October-06 2,180,675 2,470,667 4,651,342 296,280 (1) 40,084,699 5 November-06 4,714,096 3,443,428 8,157,524 354,760 (1) 69,057,186 6 December-06 11,248,603 5,976,126 17,224,729 485,869 (1) 143,755,738 7 January-07 16,702,568 8,226,498 24,929,067 650,492 (1) 186,016,076 8 February-07 18,249,769 9,125,474 27,375,243 536,774 (1) 178,851,349 9 March-07 8,793,299 5,327,089 14,120,388 346,180 (1) 112,633,454 10 April-07 4,799,177 3,691,367 8,490,545 332,731 (1) 67,247,302 11 May-07 3,348,151 3,134,693 6,482,844 251,374 (1) 51,273,484 12 June-07 3,292,349 3,117,566 6,409,914 233,611 (1) 58,001,567 13 14 Total 78,762,678 51,045,815 129,808,493 4,295,392 $ 995,250,765 15 16 17 18 Note: 19 1. Reference Workpaper WP/Billed Gas Cost. Schedule 6 ATMOS ENERGY CORP., MID-TEX DIVISION ANNUAL GAS COST RECONCILIATION FILING FOR THE PERIOD ENDED JUNE 30, 2007 Line No. Month! Year (a) INTEREST CALCULATION Amount of Monthly (Over)! Cumulative (Over)! Interest (Refund)! Monthly Under Recove Under Recove Rate 1 Surchar e Interest (b) (c) (d) (e) (f) $ (4,042,386) $ (4,042,386) 4.250% $ (14,591 ) (5,790,661) (9,833,047) 4.250% (35,493) (898,588) (10,731,634) 4.250% (37,487) (10,269,807) (21,001,441 ) 4.250% (75,807) 23,141,141 2,139,699 4.250% 7,474 16,816,519 18,956,219 4.250% 68,424 44,790,691 63,746,909 4.250% 230,100 2,307,552 66,054,461 4.250% 215,356 (36,967,622) 29,086,839 4.250% 104,992 3,485,694 32,572,533 4.250% 113,781 (19,251,510) 13,321,023 4.250% 48,083 (23,324,070) (10,003,047) 4.250% (34,942) 178,074 (9,824,974) 4.250% (9,824,974) 4.250% (35,464) (9,824,974) 4.250% (35,464) (9,824,974) 4.250% (34,320) (9,424,821 ) 4.250% (400,153) (34,020) (8,735,730) 4.250% (689,091 ) (30,515) (7,301,479) 4.250% (1,434,251) (26,355) (5,229,769) 4.250% (2,071,710) (18,877) (2,968,868) 4.250% (2,260,901 ) (10,025) (1,797,183) 4.250% (1,171,686) (6,487) (1,082,877) 4.250% (714,306) (3,783) (537,841) 4.250% (545,036) (1,941) 4.250% (537,841 ) $ (9,824,974) $ (9,824,974) $ 352,637 1 July-06 2 August-06 3 September-06 4 October-06 5 November-06 6 December-06 7 January-07 8 February-07 9 March-07 10 April-07 11 May-07 12 June-07 13 Beg. Balance Prior Filing (2) 14 July-07 15 August-07 16 September-07 17 October-07 18 November-07 19 December-07 20 January-08 21 February-08 22 March-08 23 April-08 24 May-08 25 June-08 26 27 Total 28 29 30 Notes: 31 1. Interest rate is as of August 24,2005, the market rate for 3 year AAA rated corporate bonds as evidenced by the Bondtrac, Inc. bond market data. 32 2. Reference Schedule 8. A TMOS ENERGY CORP", MID- TEX DIVISION ANNUAL GAS COST RECONCILIATION FILING FOR THE PERIOD ENDED JUNE 30, 2007 Schedule 7 ESTIMATED VOLUME CALCULATION FOR (REFUND)/SURCHARGE Line No. 1 2 3 4 5 6 7 S 9 10 11 12 13 14 15 Month-Yr (a) October-07 November-07 December-07 January-OS February-OS March-OS April-OS May-OS June-OS Total Total Estimated Volume (1) (b) 4,937,S20 S,503,262 17,69S,407 25,564,533 27,S99,120 14,45S,394 S,S14,407 6,725,647 6,636,S63 121,238,452 Note: 1. Volume is estimated for Rate R, Rate C, from WP/Billed Gas Cost; Rate I from WP Lug-Related Mct. line No. Schedule 8 ATMOS ENERGY CORP., MID-TEX DIVISION ANNUAL GAS COST RECONCILIATION FILING FOR THE PERIOD ENDED JUNE 30, 2007 SUMMARY OF (OVER)/UNDER RECOVERY FROM PREVIOUS FILING Description (a) Amount (b) Reference (c) 1 2 3 4 5 6 7 8 9 10 Prior (Over)/Under Gas Cost Recovery $ (22,763,079) (1.055,006) (1 ) Prior Gas Cost Reconciliation Interest Amount Flowed Back to Customers 23,996.159 For the Periods October, 2006 through June, 2007 Total Amount to (Refund)/Surcharge from Previous Filing $ 178,074 Note: 1. Interest rate is as of August 24,2005, the market rate for 3 year AAA rated corporate bonds as evidenced by the Bondtrac. Inc. bond market data. Line No. Schedule 9 ATMOS ENERGY CORP., MID-TEX DIVISION ANNUAL GAS COST RECONCILIATION FILING FOR THE PERIOD ENDED JUNE 30, 2007 LOST AND UNACCOUNTED FOR GAS ("LUG") CALCULATION Description (a) Mcf or Percent (b) Reference (c) 1 Net Purchase Volume 138,143,861 WP/LUG-Related MctCol (d), Ln 13 WP/LUG-Refated Mct Col (e), Ln 133,985,527 13 plus Sch 5 Col (d), Ln 14 24,405 WP/LUG-Related Mct Col 0), Ln 13 4,133,929 Line 1 minus Lines 2 and 3 2.99% Line 4 divided by Line 1 2 3 4 5 Less: Total Sales Volume Less: Company Use Volume LUG Volume lUG Percent ATMOS ENERGY CORP., MID-TEX DIVISION WPl!3i11ed Gas Cost ANNUAL GAS COST RECONCllIA nON FILING Page 14 of 20 FOR THE PERIOD ENDED JUNE 30, 2007 ALTERNATIVE PROPOSAL GAS COST BILLED - BY MONTH Rate R Rate C Rate' Total Billed Line Billing No, Month-Yr Month-Yr Volume EGCF 1 Amount Volume EGCF 1 Amount Volume EGCF 1 Amount Amount Volume (a) (b) (e) (d) (e) (I) (g) (h) (i) (j) (k) (I) (m) 1 Jul-06 Jul-06 1,840,937.3 $ 6.8982 $ 12,895.471.83 2,177,338.5 $ 6.8962 $ 15,015,36188 272,291.0 $ 6 7345 $ 1,833,743.74 $ 29,544,577.42 2 Jun06 Rev (279,8420) 5,1005 (1,427,334.12) (1.427,334.12) 3 JUn-06 37,216.5 5.2229 194,377.84 (154,4599) 52229 (806,728.64) 289,444.0 5.1005 1.476,309.12 863,958.32 4 May-06 1,485.7 5.2229 7,759.49 15.772.6 5.2229 82.378.50 266.0 5.1005 1,356.73 91,494,72 5 Apr-06 (247.0) 5.1005 (1,25982) (1,259.82) 6 Mar-06 (404.0) 6.5215 (2,637.02) 5,037.1 6.5215 32,849.69 (105.0) 6.3687 (88871) 29,54398 7 Feb-06 (128.5) 7,9001 (999.62) 12,700.0 7.9001 100,331.43 (108.0) 7.7149 (83321) 98.498.60 8 Jan-06 (202.7) 12.4916 (2,531.97) 11.807.2 12..4916 147,490.82 22.0 12.1988 268.37 145,227.22 9 Dee-OS (7.8) 12,8612 (98.84) 15,004.0 12.6612 189,968.63 189,869.80 10 Nav-OS (423) 15.1703 (841.76) 9,824,9 15.1703 146,012.12 145,370.37 11 Oct-OS (1,017.8) 15.1703 (15,437.43) 15.1703 (15.437.43) 12 13 Talal 1,877,838_1 $ 6.8564 $ 12,875,262.52 2,092,824.4 $ 7,1232 $ 14,907,864,42 281,721.0 $ 8.6789 $ 1,881,582.10 $ 29,864,509.03 4,252,383.5 14 15 Aug-06 Aug-06 1,783,234.9 $ 6.8982 $ 12,297,544.41 2,224,8715 $ 8.8982 $ 15,343,158.84 274,323.0 $ 6.7345 $ 1,847,428.24 $ 29,488,131.50 16 Jul06 Rev (272,291.0) 6.7345 (1,833,743.74) (1,833,74374) 17 Jul-06 (8,255.0) 6.8962 (43,136.03) 6,626_9 6.8982 45,700.56 282,1850 6.7345 1,900,374.88 1,902,939.41 18 JUn-06 (1,8843) 5.2229 (8,796.76) 3,752.1 5,2229 19,597.01 (11.0) 5.1005 (56.11) 10,744.15 19 May-06 618.2 5.2229 3,228.93 3,461.0 5.2229 18,076.71 (61.0) 5.1005 (311.13) 20,99451 20 Apr-06 (29.0) 5.1005 (147.91) (147.91) 21 Mar-06 (255.8) 6.5215 (1,86817) 128.4 6.5215 837.16 (5,0) 6.3687 (31.84) (862.84) 22 Feb--DB 16-4.5 7.9001 1,299,82 1,141.2 7.9001 9,015.61 (11.0) 7.7149 (84,86) 10,23056 23 Jan-06 (656,4) 12.4918 (8,199.47) (605.2) 12.4916 (7,559,92) (120) 12.1988 (148,39) (15,905.78) 24 Dee-OS (211.2) 12.6612 (2,874.24) 92.7 12.8612 1,173.69 8.0 12.3845 96.92 (1,40183) 25 Nov-05 24 15.1703 36.00 (70) 15.1703 (106,29) (70.29) 26 Oct-OS (490,4) 15.1703 (7,439.72) 15.1703 (7,439.72) 27 28 Tolar 1,774,466.9 $ 6.8923 $ 12,230,194.77 2,239,461.7 $ 6.8900 $ 15,429,893.39 284,098.0 $ 6.7350 $ 1,913,380.06 $ 29,573,468.22 4,298,0245 ATMOS ENERGY CORP., MID-TEX DIVISION WP/BiUed Gas Cost ANNUAL GAS COST RECONCILIATION FILING Page 15 of 20 FOR THE PERIOD ENDED JUNE 30, 2007 ALTERNATIVE PROPOSAL GAS COST BILLED - BY MONTH Rate R Rate C Rate I Total Billed line Billing No. Month-Yr Month-Vr Volume EGCF 1 Amount Volume EGCF 1 Amount Volume EGCF 1 Amount Amount Volume (a) (b) (e) (d) (e) (f) (g) (h) (i) W (k) (I) (m) 29 30 Sep.-D6 Sep-06 1,782,8913 $ 6.8962 $ 12,295,175.12 2,196,707.0 $ 6.8962 $ 15,148,930.88 229,553.0 $ 6.7345 $ 1,545,924.68 $ 28,990,030.68 31 Aug06 Rev (274,3230) 6.7345 (1,847,428.24) (1,847,428.24) 32 Aug-06 6.8962 6.a962 286,125.0 6.7345 1,926,908.81 1,926,908.81 33 Jul-06 (889.1) 6.8962 (8,131.07) 1,6928 68962 11,673 75 (1,697.0) 6.7345 (11,428.45) (5,885.76) 34 Jun-06 328.7 5.2229 1,716.87 511.1 5.2229 2,66942 19.0 5.1005 96.91 4,483.21 35 May-06 (1,909.4) 5.2229 (9,972.66) 1,617.5 5.2229 8,447.83 492.0 5.1005 2,509.45 984.62 36 Apr-06 456.0 5.1005 2,325.83 2.325.83 37 Mar-OO 37.0 6.5215 241.17 (9.2) 6.5215 (80.05) 526,0 6.3687 3,349.94 3,531.04 38 Feb-06 288.0 7.9001 2,275.15 260.0 7.9001 2,054.03 353.0 7.7149 2,723.36 7,052.54 39 Jan-06 388.5 12.4916 4,852.49 (94.5) 12.4916 (1,180.46) 12.1988 3,672.03 40 Dee-OS 334.4 12.6612 4,234.29 (158.6) 12.6612 (2,008.D7) 12.3645 2,226.22 41 Nav-OS 185.9 15.1703 2,819.55 (2.4) 15.1703 (37.02) 2.78254 42 Oct-Os 30.7 15.1703 464.97 15.1703 464.97 43 Aug-05 8.0603 97.3 8.0603 784.27 784.27 44 45 Total 1,781,686.0 $ 6.9011 $ 12,295,675.88 2,200,620.9 $ 6.8941 $ 15,171,27458 241,504.0 $ 6.7286 $ 1,624,982_28 $ 29,091,932.74 4,223,810,9 46 47 Oct-06 Oct-05 2,132,082.1 $ 8.1213 $ 17 ,315,278.28 2,459,566.8 $ 8.1213 $ 19,974,880.02 282,206.0 $ 7.9310 $ 2,238,163.66 $ 39,528,321.95 48 SeptOO Rev (229,553.0) 67345 (1,545,92468) (1,545,924.68) 49 Sep--06 (1,850.3) 6.8962 (11,380.80) 13,981.1 6.8962 96,416.53 244,200.0 6.7345 1,644,564.90 1,729,600.63 50 Aug-06 407.0 6.7345 2,740.94 2,740.94 51 Jul-06 (1,074.7) 6.8962 (7,411.00) 1,360.6 6.8962 9,383.11 (141.0) 6.7345 (949.56) 1,022.54 52 Jun-06 (2,072.4) 52229 (10,824.04) 1,296.8 5.2229 6,772.90 270.0 5.1005 1,377.14 (2,674.01) 53 May-06 (1,312.8) 5.2229 (6,856.68) 793.4 5.2229 4,143.80 (394.0) 5.1005 (2,00960) (4,722.48) 54 Apr-06 (356.0) 5.1005 (1,815.78) (1,815.78) 55 Mar-06 59.4- 6.5215 387.12 (1,266.2) 6.5215 (8,257.52) (417.0) 63687 (2,655.75) (10,52615) 56 Feb-06 (69.3) 7.9001 (547.71) (1,341.4) 7.9001 (10,597.19) (2720) 7.7149 (2,098.46) (13,24337) 57 Jan-06 245.2 12.4916 3,052.44 (1,849.1) 12.4916 (23,098.22) 107.0 12.1988 1,305.27 (18,730.51) 58 Dee-OS 101.1 126812 1,280.30 (1,664.7) 12.6612 (21,077.61) 126.0 12.3645 1,557.93 (18,239.38) 59 Nov-05 (158.6) 15.1703 (2,405.55) (2099) 15.1703 (3,184.70) 42.0 14.8147 622.22 (4,96804) 60 Oct-OS 51.1 15.1703 775.20 15.1703 33.0 14.8147 488.89 1,26409 61 Sep-05 22.0 8.8809 195.38 195.38 62 Aug-OS 3.1 8.0503 2-4.99 8.0603 24.99 63 Nov-06 54,470.7 8.1213 442,373.06 8.1213 442,373.06 64 65 Tolal 2,180,6746 $ 8.1276 $ 17,723,755.60 2,470,667.3 $ 8.1053 $ 20,025,381.11 296,280.0 $ 7.8830 $ 2,335,562.49 $ 40,084,699.19 4,947,621_9 66 ATMOS ENERGY CORP., MID-TEX DIVISION WPffiilled Gas Cost ANNUAL GAS COST RECONCILIATION FILING Page 16 of 20 FOR THE PERIOD ENDED JUNE 3D, 2007 ALTERNATIVE PROPOSAL GAS COST BILLED - BY MONTH Rate R Rate C Rate I Total Billed line Billing No. Month-Yr Month-Yr Volume EGCF 1 Amount Volume EGCF 1 Amount Volume EGCF 1 Amount Amount Volume (a) (b) (e) (d) (e) tn (g) (h) (i) (j) (k) (I) (m) 67 Nov-06 Nov-06 4,640,9ge.3 $ 8.1213 $ 37,690,939.09 3,288.065.7 $ 8.1213 $ 26,703,387.73 348,998.0 $ 7.9310 $ 2,767,888.14 $ 67,162,194.96 68 Oct06 Rev (282,206.0) 7.9310 (2,238,16366) (2,238,16366) 69 Od-06 73,750.1 8.1213 598,946.61 149,2793 8.1213 1,212,341.57 292,211.0 7.9310 2,317,512.89 4,128,80106 70 Sep-06 6.8962 6.8962 (2,786.0) 6.7345 (18,762.32) (18,762.32) 71 Aug-06 (398.0) 6.8962 (2,744.96) 2,477.5 6.8962 17,085.40 (29.0) 6.7345 (195.30) 14,1011:5.14 72 Jul-06 (193.4) 6.8962 (1,333.52) 762.1 6.8962 5,255.59 (845.0) 6,1345 (4,34375) (421.68) 73 Jun-06 (1187) 5.2229 (62017) 3585 52229 1,87241 (7100) 5.1005 (3.621.36) (2,369.11) 74 May-OS 5.2229 (2.8) 52229 (14.57) (63.0) 5.1005 (32133) (335.90) 75 Apr-06 80.2 5.2229 419.03 2.451.7 5.2229 12.805.1. (10.0) 5.1005 (5101) 13.173.17 76 Mar~06 (292) 6.5215 (190.30) 95.5 6.5215 622.80 6.3687 432.51 77 Feb-06 40.6 7.9001 320.51 170.2 7.9001 1,344.60 7.7149 1,665.10 78 Jan-06 (101.8) 124916 (1,27177) (232.7) 124916 (2,906.80) 12.1988 (4,176.57) 79 Dee-OS 246 12.6612 311.47 4.3 12.6612 54.44 12.3645 365.91 80 Nov-OS 29.6 15.1703 44B.28 (1.4) 15.1703 (2124) 14.8147 42"7.04 81 Oct-OS 14.0 15.1703 212.38 15.1703 14.8147 212.38 82 83 Total 4,714,096.2 $ 8.1215 $ 38,285,436.65 3,443,427.9 $ 8.1174 $ 27,951,807.09 354,760.0 $ 7.9489 $ 2,819,942.31 $ 69,057,186.04 8,512.284.0 84 85 Dec-06 Dee-OS 11,250,202.8 $ 8.1213 $ 91,366,271.76 5,971,471.4 $ 8.1213 $ 48,496,110.52 474,143.0 $ 7.9310 $ 3.760,407.76 $ 143,622,79003 86 Nov06 Rev (348,996.0) 7.9310 (2,767,888.14) (2.767,888.14) 87 Nav-06 8.1213 8.1213 358,282.0 7.9310 2,841,519.15 2,841,51915 88 Od-06 (986.4) 8.1213 (8,010.77) (8363) 8.1213 (6.791.92) 2,180.0 7.9310 17,28949 2,48679 89 Scp-06 6.8962 6.8962 214.0 6.7345 1,441.18 1,441.18 90 Aug-OO (686.6) 6.8962 (4,73521) (1,234.6) 6.8962 (8,51391) 48.0 6.7345 32326 (12,92586) 91 Jul-06 (201.8) 6 8962 (1,391.93) 597.8 6.8962 4,12255 6.7345 2.730.62 92 JUn-OO 43.3 5.2229 226.15 386.1 5.2229 2,016.56 5.1005 2,242.71 93 May-OS 52229 5.2229 5.1005 94 Apr-06 77.3 52229 403.68 4872 5.2229 2,544.70 5.1005 2,948.38 95 Mar-OS 14.2 6.5215 92.61 47.0 6.5215 306.51 6_3687 399.12 96 Feb--06 53.1 7.9001 419.50 1,609.9 7.9001 12.718.37 7.7149 13,137.87 97 Jan-06 40.5 12,4916 505.91 1,584.3 12.4916 19,790.44 12.1988 20,296.35 96 Dee-OS 42.8 12.6612 541.77 1,824.2 12.6612 23,096.58 12.3645 23.638_33 99 Nav-OS (2.1) 15.1703 (32.31) 189.1 15.1703 2,868.70 14.8147 2.836_39 100 Oct-OS 5.6 15.1703 84.95 15.1703 14.8147 84.95 101 102 Talal 11,248,602.6 $ 8.1214 $ 91,354,37610 5,976,126.1 $ 81237 S 48,548,26908 4B~,869.0 $ 7.9303 $ 3,853,092.69 $ 14~,7S5.737.88 17,710,597.7 103 ATMOS ENERGY CORP., MID-TEX DIVISION WPIBllled Gas Cost ANNUAL GAS COST RECONCILIATION FILING Page 17 of 20 FOR THE PERIOD ENDED JUNE 30, 2007 ALTERNATIVE PROPOSAL GAS COST BILLED - BY MONTH Rate R Rate C Rate r Total Billed Line Billing No. Monlh~Yr Monlh-Yr Volume EGCF 1 Amount Volume EGCF 1 Amount Volume EGCF 1 Amount Amounl Volume (a) (b) (e) (d) (e) (I) (g) (h) (I) (j) (k) (I) (m) 104 Jan-07 Jan-07 14.435.3966 $ 74003 $ 106,826.265.46 7.228.430.3 $ 7.4003 $ 53.492.552.97 826.3240 $ 7.2269 $ 4.526,35302 $ 164.845.171.45 105 Dec06 Rev (474,143.0) 7.9310 (3.760.407.76) (3.760,407.76) 106 Dee-06 8.1213 8.1213 495,974.0 7.9310 3,933,548.48 3,933,548.48 107 Nov-06 22,566.8 8.1213 183,271.43 35.437.9 8.1213 287,802.06 365.0 7.9310 2,894.80 473,968.29 108 Oct-06 (8659) 8.1213 (7,031.83) 4.1225 8.1213 33,480.14 23.0 7.9310 182.41 26,630.72 109 Sep-06 6.8962 6.8962 20.0 6.7345 134.69 134.69 110 Aug-06 (1.4923) 6.8962 (10.290.85) 8,464.8 6.8962 58,374.95 19.0 6.7345 12796 48,212.05 111 Jul-06 32.4 6.6962 223.30 3,561.7 6,8962 24.562.20 12.0 6.7345 BO.81 24,866.31 112 Jun-06 21.8 5.2229 112.81 295.5 5.2229 1.543.31 5.1005 1,656.13 113 May-06 5.2229 5.2229 4.0 5.1005 20.40 20.40 114 Apr-06 306.6 5.2229 1,601.34 (776,1) 5.2229 (4,05349) 5.1005 (2.452.15) 115 Mar-06 299.7 6.5215 1,954.49 (1.800.2) 8.5215 (10.435.70) 6.3687 (8,481.21) 116 Feb-06 566.2 7.9001 4,473.04 (29.4) 7.9001 (232.26) 7.7149 4,240.77 117 Jan-06 632.3 12.4916 7,898.44 580.7 12.4916 7.253.87 12.1988 15,152.31 118 Dee-OS 48,7 12.6612 616.60 96.9 12.6612 1,228.87 12.3645 1,843.47 119 Noy-OS 404,6 15.1703 6,137.14 (14.8) 15.1703 (224.52) 14.8147 5,912.62 120 Oct-OS 431.1 15.1703 6,539.92 15.1703 14.8147 6,539.92 121 Aug-OS 05 8.0603 4.03 8.0603 4.03 122 Apr-05 12.0 54729 65.68 65.60 123 Jan-05 1.882.0 7.9871 15,031.74 15.031.74 124 Feb-07 2.244,219.5 8.3858 14.331.136.76 947,9284 6.3858 6,053.281.43 20.384,41819 125 126 Total 16,702.568.4 $ 7.2655 $ 121.352.912.08 8,226,498.3 $ 7.2868 $ 59.945.131.83 650.492,0 $ 7.2530 $ 4,718,032.24 $ 186,016,076.14 25,579,558.7 127 128 Feb-07 Feb--07 17,989,854.9 $ 6.3858 $ 114,879,615.48 8,893,702.6 $ 6.3858 $ 56,793,406.25 510,874.0 $ 8.2381 $ 3,185,878.11 $ 174,858,89985 129 Jan07 Rey (628.324.0) 7.2269 (4.526,35302) (4,526.353.02) 130 Jan-07 7,016_0 7.4003 51,920.13 12,078.6 7.4003 89,385.49 652,877.0 7.2269 4,718,247.72 4.859,553.34 131 Dee-06 8.1213 8.1213 1,170.0 7.9310 9,279.22 9,279.22 132 NoY-06 (7.299.5) 8.1213 (59.281.67) 12,400.4 8.1213 100,707.45 58.0 7.9310 460.00 41,885.77 133 Oct-06 (1.6920) 8.1213 (13.741.08) 2,445.3 8.1213 19,858.93 11.0 7.9310 87.24 6,205.10 134 Sep-06 6.8962 1,906.1 6.8962 13,144.92 2.0 6.7345 13.47 13,158.38 135 Aug-06 2.9525 6.8962 20,361.03 6.8962 1.0 6.7345 6.73 20.367.77 136 Jut-DB (77.9) 6.8962 (537.15) 154.8 6.8962 1.067.19 3.0 6.7345 20.20 550,25 137 Jun-06 25.8 5.2229 134.75 53.2 5.2229 277_86 5.1005 412.61 138 MaY-06 5.2229 5.2229 (4.0) 5.1005 (20.40) (20.40) 139 Apr-06 (187.6) 5.2229 (875.36) 202.6 5.2229 1,058.16 51005 182.80 140 Mar-06 (257.2) 6.5215 (1.677.33) 220.5 6.5215 1,437.99 6.3687 (23934) 141 Feb--06 (450.5) 7.9001 (3.558.78) 165.7 7.9001 1,309.05 7.7149 (2.249,71) 142 Jan-06 (515.0) 124916 (8.433.17) 12.4 12.4916 154.90 12.1988 (6.27828) 143 Dee-OS (92.9) 12.6612 (1.176.23) 25.4 12.6612 321.59 12.3645 (854.63) 144 Nay-OS (4050) 15.1703 (6.143,97) (9146) 15.1703 (13.874.30) 14.8147 (20,018.27) 145 Oct-Os (388.9) 15.1703 (5.899 73) 15.1703 14.8147 (5.899.73) 146 Aug-05 8.0603 8.0603 147 Apr-05 (12.0) 5.4729 (65.68) (65.68) 148 Jan-05 (1.8820) 7.9871 (15.03174) (15,031.74) 149 Mar-O? 261.2666 7.7923 2,035.86773 203.020.6 7.7923 1.581.997.27 3,617.864.99 150 151 Tolal 18.249,7693 $ 6.4049 $ 116.888,574.69 9.125,473.6 $ 6.4205 $ '",590.252.74 536.774.0 $ 6.2829 $ 3.372,521.85 $ 178,851,349.28 27.912,016.9 152 ATMOS ENERGY CORP., M/D-TEX DIVISION WPIBilled Gas Cosl ANNUAL GAS COST RECONCILIATION FILING Page 18 of 20 FOR THE PERIOD ENDED JUNE 30, 2007 ALTERNATIVE PROPOSAL GAS COST BILLED - BY MONTH Rale R Rale C Rate I T olal Billed Line Billing No. Month-Vr Month-Yr Volume EGCF 1 Amount Volume EGCF 1 Amount Volume EGCF 1 Amount Amount Volume (a) (b) (e) (d) (e) (f) (g) (h) (i) (j) (k) (I) (m) 153 Mar-07 MAr-OJ 8,748,1598 $ 7.7923 $ 68,152.701.17 5,278.7996 $ 7.7923 $ 41,118,405.45 339,559.0 $ 7.6097 $ 2,583.93125 $ 111,855,037.86 154 Feb-07 10,741.5 6_3858 68,592.94 (4,3604) 6.3858 (27,97242) 517,257.0 6.2361 3,225,683.35 3,266,303.87 155 Feb07 Rev (510,874.0) 6.2361 (3,185,878.11) (3,185,87811) 156 Jfln-07 (1,920.6) 7.4003 (14.21309) 13.619_2 74003 100,785.80 413.0 72269 2,984.69 89,557.40 157 Dec-06 6.1213 8.1213 53.0 7.9310 420.34 420.34 156 Nav-OO (3,115.9) 6.1213 (25,304.92) 5,321.3 8.1213 43,215.95 (228.0) 7.9310 (1,806.26) 16,102.78 159 Oct-06 (516.8) 8.1213 (4,197.09) 701.2 8.1213 5,694.66 7.9310 1,497.57 160 Sep--06 6.8982 (121.0) 6.8962 (834.37) 6.7345 (834.37) 161 Aug-06 (4,1476) 6.8962 (28,602.40) 6.8962 6.7345 (28,60240) 162 Jul.06 59.4 6.8982 409.63 (168.4) 6.8962 (1,161.32) 6.7345 (751.69) 163 Jun-06 544 5.2229 284.13 (42.1) 5.2229 (219.88) 5.1005 64.24 164 May-06 5.2229 5.2229 5.1005 165 Apr-06 867 5.2229 452.83 584 5.2229 294.57 5.1005 747.40 166 Mar-06 43.5 6_5215 283.69 2,363.5 6.5215 15,413.57 6.3687 15,697.25 167 Feb-06 1.8 7.9001 12.64 (452.8) 7.9001 (3,577.17) 7.7149 (3,56453) 168 Jan-06 20.6 12_4916 257.33 (628.3) 12.4916 (7,84847) 12.1988 (7,591.15) 169 Dee-OS 20_0 126612 253.22 1.0 12.6612 12.66 12.3645 265.89 170 NOli-OS 15.7 15.1703 238.17 627.2 15.1703 12,546.87 14.8147 12,787.05 171 Oct-Os 20_5 15.1703 310.99 15.1703 14.8147 31099 172 Aug-05 8.0603 8.0603 173 Apr-05 5.4729 174 Jan-05 7_9871 175 Apr-07 45,776_3 76216 348,897.73 33.192.4 7.6218 252,985.99 601,683.71 176 177 Tolal 8,793,299.2 $ 7.7901 $ 68,500,376.97 5,327,088.8 $ 7.7918 $ 41,507,743.87 346,180.0 $ 7.5837 $ 2,625,333.26 $ 112,633,454.09 14,466,567.9 178 179 Apr-07 Apr-07 4,586,136.2 $ 7.6218 $ 34,954,612.89 3,523,676_1 $ 7.6218 $ 26,856,769.97 304,228.0 $ 7.4431 $ 2,264,399.43 $ 64,075,782.29 180 Mar-07 154,404.7 7.7923 1,203,167.35 106,6201 7.7923 830,816.04 345,546.0 7.6097 2,629,490.33 4,663,473_72 181 Mar07 Rev (339,5590) 7.6097 (2,583,931.25) (2,563.931.25) 182 Feb-07 (14,5103) 6.3858 (92,659.62) (81.8) 6.3858 (522.55) 5,264.0 6.2361 32,827.00 (60,355.17) 183 Jan-07 (527.1) 7.4003 (3,900.40) 5,9367 7.4003 43,932.99 7,006.0 7.2289 50.631.35 90,663_94 184 Dee-06 6.1213 8.1213 5,177.0 7.9310 41.058.56 41,056_56 185 NOII-06 (1,681.1) 8.1213 (13,65288) 3,772.7 6.1213 30,639.15 2,130.0 7.9310 16,892.94 33,879.21 186 Ocl-06 (99.1) 8.1213 (804.58) 4697 8.1213 3,814.57 899.0 7.9310 7,129.93 10,139.93 187 SfJp-06 6.8962 26.2 6.8962 180.40 450.0 6.7345 3,030.53 3,210_93 188 Aug-06 8.3 6.8982 57.24 6.8962 403.0 6.7345 2,714.00 2,771.24 169 Jul-06 (0.3) 6.6962 (2.00) (10.2) 6.8962 (70.34) 527.0 6.7345 3,549.08 3.476.74 190 JUn-06 (1.1) 5.2229 (5.64) (13.5) 5.2229 (70.51) 660.0 5.1005 3,366.33 3,290.18 191 May-06 5.2229 5.2229 5.1005 192 Apr-06 (6.3) 5.2229 (32.90) (71.8) 5.2229 (375.00) 5.1005 (407.91) 193 Mar-06 0.2 6.5215 1.30 (198.8) 6.5215 (1,298.47) 6.3667 (1.295.17) 194 Feb-06 (9.6) 7.9001 (75.84) (8.3) 7.9001 (65.57) 7.7149 (141.41) 195 Jan-06 5.6 12.4916 69_33 (55.2) 12.4916 (689.54) 12.1988 (620.21) 198 Dee-OS 6.4 12.6612 81.03 (65.2) 12.6612 (825.51) 12.3645 (744.48) 197 Nov-OS 15_1703 75.6 15.1703 1.146.87 14.8147 1,146_87 198 Oct-Os (152) 15.1703 (231.04) 15.1703 148147 (231.04) 199 Aug-05 8.0603 8.0603 200 Apr-05 5.04729 201 Jan-05 7.9871 202 May-07 75.466.2 7.6218 575,188.13 51,2932 7.6218 390,946.44 966.134_57 203 204 Total 4,799,177.5 $ 7.6309 $ '",621,812.37 3,691,3674 $ 7.6271 $ 28,154,330.94 33],731.0 $ 7.4269 $ 2,471,158.23 $ 67.247,301_55 8,823,2759 ATMOS ENERGY CORP., MID-TEX DIVISION WPl8i11ed Gas Cost ANNUAL GAS COST RECONCILIATION FILING Page 19 of 20 FOR THE PERIOD ENDED JUNE 30, 2007 ALTERNATIVE PROPOSAL GAS COST BILLED - BY MONTH Rate R Rale C Rate I Total Billed Line Billing No. Month-Yr Month-Vr Volume EGCF 1 Amount Volume EGCF 1 Amount Volume EGCF 1 Amount Amount Volume (a) (b) (c) (d) (e) (f) (g) (h) (i) (j) (k) (I) (m) 205 206 May-07 May-O? 3.324,086.3 $ 7.6218 $ 25.335,520.96 3,037.603.0 $ 7.6218 $ 23.152.00255 245.425.0 $ 7.4432 $ 1.826,738.54 $ 50,314,262.05 207 Apr-07 (1,270.3) 7.6218 (9.681.67) 530.9 7.6218 4.046.49 310,863.0 7.4431 2.313,784,40 2.308,14922 208 AprfJ7 Rev 7.6218 7.6218 (304.228.0) 7.4431 (2.264,399.43) (2.264,39943) 209 Mar-O? (16.648.6) 7.7923 (129,730.81) 8.216,3 7.7923 64.023.87 (812.0) 7.6097 (6,179.05) (71,885.98) 210 Feb-O? (11,735.1) 6.3858 (74.937.75) 14,961.4 6.3858 95,540.64 122.0 62361 760.81 21,363.70 211 Jan-07 (8.228.2) 7.4003 (60.891.07) 8,647.2 7.4003 63.991.87 4.0 7.2269 28.91 3,12971 212 Dec-06 8.1213 8.1213 7.9310 213 Nov-06 (6,416.6) 8.1213 (52.111.05) 5.954.1 8.1213 48.355.03 7.9310 (3,756.02) 214 Oct-06 94 8.1213 76.34 (2186) 8.1213 (1,775.32) 7,9310 (1.698.98) 215 Sep-06 6.8962 (2178) 6.8962 (1.501.99) 6.7345 (1.501.99) 216 Aug-06 4.7 6.8962 32.41 6.8962 6.7345 32.41 217 Jul-06 6.6 6.8962 45.51 371.8 6.8962 2,564.01 6.7345 2,609.52 218 Jun-06 (0.6) 5.2229 (3.08) 0.7 5.2229 3.66 5.1005 0.57 219 May-06 52229 5.2229 5.1005 220 Apr-06 5.6 5.2229 29.25 8.3 5.2229 43.35 5.1005 72.60 221 Mar-06 (10.1) 65215 (65.87) (4.9) 6.5215 (31.96) 6.3687 (97.82) 222 Feb-06 (0.8) 7.9001 (6.32) 0,1 7.9001 0.79 7.7149 (5.53) 223 Jan~06 12.4916 8.0 12.4916 99,93 12.1988 99,93 224 Dee-OS (27.8) 12.6612 (351.98) 25.1 12.6612 317.80 12.3645 (3419) 225 Nav-OS (7.4) 15.1703 (112.56) 4,6 15.1703 69.78 14.8147 (42.78) 226 Oct-OS (04) 15.1703 (6.07) 15.1703 14.8147 (6.07) 227 AUQ-05 8.0603 8.0603 228 Apr-OS 5.4729 229 Jan-05 7.9871 230 JUn-07 68,384.3 7.6045 520,028.33 58,802.6 7.6045 447.164.37 967,192.71 231 232 Tolal 3,348,151.1 $ 7.6245 $ 25,527.834.58 3,134,692.8 $ 7.6163 $ 23,874,914.88 251.374,0 $ 7.4420 $ 1,870,734.17 $ 51,273,483.63 6,734,217.9 233 234 JUn-07 JUn-07 3,316,639.6 $ 8.7500 $ 29,020,596.50 3,055,088.0 $ 8.7500 $ 26,732,020.00 213,402.0 $ 8.5449 $ 1,823,503.42 $ 57,576,119,92 235 Jun-07 (2,2530) 7.6045 (17.132.94) (1.115,4) 7.6045 (8,482.06) (25.615.00) 236 May-07 704.0 7.6218 5,365,75 7,789.4 7.6218 59.36925 254.737.0 7.4432 1,896,05844 1,960,793.43 237 May07 Rev 76218 7.6218 (245.425.0) 7.4432 (1,826,738.54) (1,826,738.54) 238 Apr-07 (3,892.7) 7.6218 (29,669.38) 7,878.0 7.6218 60,044.54 9,460.0 7.4431 70,411.73 100,786.89 239 Mar-07 (4.857.1) 7.7923 (37,847.98) 8,409.7 7.7923 65,530.91 1,320.0 7.6097 10,044.76 37,727.69 240 Feb-07 (7,3914) 6.3858 (47,200.00) 14,099.4 6.3858 90,035.95 66.0 6.2361 411.58 43,247.53 241 Jan-07 (5.188.4) 7.4003 (38.395.72) 11,844.0 7.4003 87,649.15 23.0 7.2269 166.22 49,419.65 242 Dec~06 8.1213 8.1213 11.0 7.9310 87.24 87.24 243 NoV-06 (1.853.1) 8.1213 (15,049.58) 6,703.1 8.1213 54,437.89 17.0 7.9310 134.83 39,523.13 244 Oct-06 (2.1) 8.1213 (17.05) 996.1 8.1213 8,089.63 7.9310 8,072.57 245 Sep-06 68962 6.8962 6,7345 246 Aug-06 5.0 6.8962 34.48 748.8 6.8962 5,163.87 6.7345 5,198.36 247 Jul-06 2.7 6,8962 18.62 307.0 68962 2,117.13 6.7345 2,135.75 248 Jun-06 2,4 5.2229 12.53 286.4 5.2229 1,495,84 5.1005 1,508.37 249 MaY-06 5.2229 5.2229 5.1005 250 Apr-06 (29) 5.2229 (1515) 3.998.3 5.2229 20.882.72 5.1005 20,867.57 251 Mar-06 (14.1) 6.5215 (91,95) (2,4) 6.5215 (15,65) 6.3687 (107.60) 252 Fell-DB (29.0) 7.9001 (229.10) 0.6 7.9001 4.74 7.7149 (224.36) 253 Jan-06 (10.0) 12.4916 (124.92) 12.4916 121988 (12492) 254 Dee-OS (116) 12.6612 (146.87) 126612 12.3645 (146.87) 255 Nov-05 15.1703 15.1703 14.8147 256 Del-OS (3.1) 15.1703 (47.03) 151703 14.8147 (4703) 257 Aug-05 8.0603 8.0603 258 Apr-05 5.4729 259 Jan-05 7.9871 260 JIII-07 503.5 8.7500 4,405.63 534.6 8.7500 4,677.75 9,083.38 261 262 Tolal 3.292.348.7 $ 8.7611 $ 28,844,465.84 3.117,565.6 $ 8.7193 $ 27,183,021.66 233,611.0 $ 8.4503 $ 1.974.07967 $ 58,001,567.17 6.643.5253 263 264 Grand Total 78 762 678.3 $ 582 500 678.03 51 045814.8 $ 381 289 685.58 .. 295 392.0 $ 31460401.35 $ 995 250764.96 134103,885.1 265 266 267 Note: 268 1. Estimated Gas Cost Factor, per monthly Rider GCR - Rate Filings under Docket No 9400. WP/LUG-Related Mcf ATMOS ENERGY CORP., MID-TEX DIVISION ANNUAL GAS COST RECONCILIATION FILING FOR THE PERIOD ENDED JUNE 30, 2007 LUG-RELATED VOLUMES/QUANTITIES _ BY MONTH Net Purchase Mct Net Purchase Btu Net Purchase Industrial Company Line No. Month-Vr MMBtu Factor Mct Mct Use Mct (a) (b) (c) (d) (e) (h) 1 July-06 4,612,169 1.021 4,516,661 272,638 1,980 2 August-06 3,863,767 1.020 3,786,765 275,115 1,828 3 September-06 4,419,918 1.024 4,316,892 232,424 1,805 4 October-06 6,622,555 1.024 6,467,116 286,478 971 5 November-06 12,817,031 1.023 12,526,836 345,738 1,248 6 December-06 21,567,671 1.020 21 , 141 ,658 473,678 2,431 7 January-07 33,430,186 1.023 32,670,943 635,466 3,581 8 February-07 24,130,948 1.021 23,645,245 523,877 4,411 9 March-07 9,964,469 1.023 9,744,266 338,006 2,297 10 April-07 10,377,693 1.020 10,171,215 323,862 1,272 11 May-07 4,514,156 1.020 4,424,185 242,803 1,184 12 June-07 4,835,373 1.022 4,732,079 226,949 1,399 13 Total 141,155,937 138,143,861 4,177 ,034 24,405 ATMOS ENERGY CORP., MID-TEX DIVISION ANNUAL GAS COST RECONCILIATION FILING FOR THE PERIOD ENDED JUNE 30, 2007 AL TERNA TIVE PROPOSAL TABLE OF CONTENTS I Document Title I Document Description 1 Schedule 1 Schedule 2 Schedule 3 Schedule 4 Schedule 5 Schedule 6 Schedule 7 Schedule 8 Schedule 9 Calculation of Reconciliation Factor Summary of (Over)/Under Recovery Gas Cost Incurred Gas Cost Incurred - By Month Gas Cost Billed Interest Calculation Estimated Volume Calculation for (Refund)/Surcharge Summary of (Over)/Under Recovery from Previous Filing Lost And Unaccounted For Gas ("LUG") Calculation WP/Billed Gas Cost WP/LUG-Related Mcf Gas Cost Billed - By Month LUG-Related Volumes/Quantities - By Month line No. Schedule 1 ATMOS ENERGY CORP., MID-TEX DIVISION ANNUAL GAS COST RECONCILIATION FILING FOR THE PERIOD ENDED JUNE 30, 2007 AL TERNA TIVE PROPOSAL CALCULATION OF RECONCILIATION FACTOR Description (a) Amount (b) Reference (c) 1 2 3 4 5 Total Amount to (Refund)/Surcharge $ (9,448,015) Schedule 2, Col. (b), Line 11 Total Estimated Rate R, Rate C and Rate I Mcf 99,061,535 Schedule 7, Col. (b), Line 11 Reconciliation Factor $ (0.0954) Line 1 divided by Line 3 ATMOS ENERGY CORP., MID-TEX DIVISION ANNUAL GAS COST RECONCILIATION FILING FOR THE PERIOD ENDED JUNE 30, 2007 ALTERNATIVE PROPOSAL SUMMARY OF (OVER)/UNDER RECOVERY Schedule 2 Line No. Description Amount Reference (a) (b) (c) 1 Gas Cost Incurred $ 985,247,718 Schedule 3, Col. (c), Line 23 2 3 Gas Cost Billed 995,250,765 Schedule 5, Col. (g), Line 14 4 5 Total Gas Cost (Over)/Under Recovered $ (10,003,047) Line 1 minus Line 3 6 7 Amount Remaining from Previous Filing 178,074 Schedule 8, Col. (b), Line 7 8 9 Interest 376,959 Schedule 6, Col. (t), Line 27 10 11 Total Amount to (Refund)/Surcharge $ (9,448,015) Line 5 plus Line 7 plus Line 9 Schedule 3 ATMOS ENERGY CORP., MID-TEX DIVISION ANNUAL GAS COST RECONCILIATION FILING FOR THE PERIOD ENDED JUNE 30, 2007 AL TERNA TIVE PROPOSAL GAS COST INCURRED Line FERC No. Account Description Amount (1) (a) (b) (c) 1 800 Natural Gas Well Head Purchases $ 817.487 2 801 Natural Gas Field Line Purchases 3 802 Natural Gas Gasoline Plant Outlet Purchases 13,196,886 4 803 Natural Gas Transmission Line Purchases 965,969,504 5 804 Natural Gas City Gate Purchases 6 805 Other Gas Purchases 77 ,541 7 806 Exchange Gas (1,941,121) 8 807 Purchased Gas Expenses 9 808.1 Gas Withdrawn From Storage - Debit 69,191.438 10 808.2 Gas Delivered To Storage - Credit (61,084,942) 11 809 Withdrawals/Deliveries of Liquefied Natural Gas Held for Processing 12 810 Gas Used for Compressor Station Fuel _ Credit 13 811 Gas Used for Products Extraction - Credit 14 812 Gas Used for Other Utility Operations _ Credit (174.458) 15 813 (2) Other Gas Supply Expenses 16 858 Transmission and Compression of Gas by Others 429.462 17 18 19 Total Gas Cost Incurred $ 986,481,797 20 21 805 Less: Tota/lmbalance Fees (3) $ 1,234,079 22 23 Total Gas Cost Less Imbalance Fees $ 985,247,718 24 25 26 Note: 27 1. Reference Schedule 4 for monthly amounts. 28 2. Excluded pursuant to Railroad Commission letter directive, March 3, 2006. 29 3. Reference Schedule 4, Line 25. Schedule 4 Page 6 of 20 ATMOS ENERGY CORP., MID-TEX DIVISION ANNUAL GAS COST RECONCILIATION FILING FOR THE PERIOD ENDED JUNE 3D, 2007 . AL TERNA TIVE PROPOSAL GAS COST INCURRED - BY MONTH line FERC No. Account Jul-06 Au -06 Sep-06 Oct-06 Nov-06 Dec-06 (a) (b) (c) (d) (e) (f) (g) 1 800 $ 17,256 $ 75,619 $ 47,531 $ 106,213 $ 34,443 $ 88,169 2 800.1 3 801 4 802 1,699,781 1,278,647 1,423,629 1,482,467 5,046,233 (2,700,077) 5 803 24,043,043 26,439,836 25,596,521 26,039,435 82,120,107 154,719,069 6 804 7 804.1 8 805 33,135 4,854 5,929 9 805.1 10 806 (25,262) (3,875,481 ) 1,186,513 2,374,186 4,345,800 (1,143,847) 11 807 12 808.1 3,240,073 16,532,221 13 808.2 2,070 (2,275,628) (6,838,525) 14 809.1 15 809.2 16 810 17 811 18 812 (13,600) (11,221) (12,427) (7,590) (9,904) (19,228) 19 813 (1) 20 858 16,700 40,128 21 22 23 Total Gas Cost Incurred $ 25 723 288 $ 23 907401 $ 28274901 $ 29 999 563 $ 92517825 $ 160683837 24 25 805 $ 101,165 $ 124,594 $ 81,556 $ 184,671 $ 319,498 $ 111,580 26 27 Total Imbalance Fees $ 101,165 $ 124,594 $ 81,556 $ 184,671 $ 319,498 $ 111,580 28 29 Total Gas Cost Less 30 Imbalance Fees $ 25,622,123 $ 23,782,807 $ 28,193,345 $ 29,814,892 $ 92,198 327 $ 160,572,257 31 32 33 Note: 34 1. Excluded pursuanl to Railroad Commission letter directive, March 3, 2006. Schedule 4 Page 7 of 20 ATMOS ENERGY CORP., MID-TEX DIVISION ANNUAL GAS COST RECONCILIATION FILING FOR THE PERIOD ENDED JUNE 30, 2006 ALTERNATIVE PROPOSAL GAS COST INCURRED - BY MONTH line FERC No. Account Jan-07 Feb-07 Mar-07 A r-07 May-07 Jun-07 Amount (a) (h) (i) (j) (k) (I) (m) (n) 1 800 $ 63,059 $ 74,043 $ 62,605 $ 77,471 $ 139,387 $ 31,691 $ 817,487 2 800.1 3 801 4 802 1,215,636 860,803 975,716 1,067,872 400,260 445,920 13,196,886 5 803 204,281,480 161,603,835 79,203,077 78,972,861 56,058,175 46,892,064 965,969,504 6 804 7 804.1 8 805 420 12,745 9,654 6,146 4,660 77,541 9 805.1 10 806 4,666,579 (7,526,115) (7,015,877) 10,746,884 (7,103,716) 1,429,215 (1,941,121) 11 807 12 808.1 21,003,361 26,019,250 2,396,534 69,191,438 13 808.2 (410,002) 133,470 (20,152,706) (17,429,718) (14,113,905) (61,084,942) 14 809.1 15 809.2 16 810 17 811 18 812 (25,206) (26,255) (17,872) (9,695) (9,220) (12,239) (174,458) 19 813 (1) 20 858 77,383 147,171 77,815 41,713 28,553 429,462 21 22 23 TOIaI Gas Cost Incurred $ 230 872 709 $ 181 298948 $ 75 681 996 $ 70 754 054 $ 32089 867 $ 34 677 406 $ 986 481 797 24 25 805 $ 65,942 $ 140,047 $ 16,164 $ 21,058 $ 67,893 $ (90) $ 1,234,079 26 27 Tolallmbalance Fees $ 65,942 $ 140,047 $ 16,164 $ 21,058 $ 67,893 $ (90) $ 1,234,079 28 29 Tolal Gas Cost Less 30 Imbalance Fees $ 230 806 767 $ 181,158,901 $ 75,665,832 $ 70,732,996 $ 32,021,973 $ 34,677,497 $ 985,247,718 31 32 33 Nole: 34 1. Excluded pursuant 10 Railroad Commission lelter direclive, March 3, 2006. Schedule 5 ATMOS ENERGY CORP., MID-TEX DIVISION ANNUAL GAS COST RECONCILIATION FILING FOR THE PERIOD ENDED JUNE 30, 2007 AL TERNA TIVE PROPOSAL GAS COST BILLED Billed Volumes/Quantities Line ---- ..._.._ I Total Gas Cost No. Month-Yr Rate R Me Rate C Me Recovered 1 (a) (b) (c) (9) 1 July-06 1,877,838 2,092,824 3,970,663 281,721 (1 ) 29,664,509 2 August-06 1,774,467 2,239,462 4,013,929 284,096 (1 ) 29,573,468 3 September-06 1,781,686 2,200,621 3,982,307 241,504 (1) 29,091,933 4 October-06 2,180,675 2,470,667 4,651,342 296,280 (1) 40,084,699 5 November-06 4,714,096 3,443,428 8,157,524 354,760 (1 ) 69,057,186 6 December-06 11,248,603 5,976,126 17,224,729 485,869 (1 ) 143,755,738 7 January-07 16,702,568 8,226,498 24,929,067 650,492 (1) 186,016,076 8 February-07 18,249,769 9,125,474 27,375,243 536,774 (1) 178,851,349 9 March-07 8,793,299 5,327,089 14,120,388 346,180 (1) 112,633,454 10 April-07 4,799,177 3,691,367 8,490,545 332,731 (1) 67,247,302 11 May-07 3,348,151 3,134,693 6,482,844 251,374 (1) 51,273,484 12 June-07 3,292,349 3,117,566 6,409,914 233,611 (1) 58,001,567 13 14 Total 78,762,678 51,045,815 129,808,493 4,295,392 $ 995,250,765 15 16 17 18 Note: 19 1. Reference Workpaper WP/Billed Gas Cost. Schedule 6 ATMOS ENERGY CORP., MID-TEX DIVISION ANNUAL GAS COST RECONCILIATION FILING FOR THE PERIOD ENDED JUNE 30, 2007 ALTERNATIVE PROPOSAL INTEREST CALCULATION Amount of Line Month! Monthly (Over)1 Cumulative (Over)! Interest (Refund)! Monthly No. Year Under Recove Under Recove Rate 1 Surchar e Interest (a) (b) (c) (d) (e) (f) 1 July-06 $ (4,042,386) $ (4,042,386) 4.250% $ (14,591) 2 August-06 (5,790,661) (9,833,047) 4.250% (35,493) 3 September-06 (898,588) (10,731,634) 4.250% (37,487) 4 October-06 (10,269,807) (21,001,441 ) 4.250% (75,807) 5 November-06 23,141,141 2,139,699 4.250% 7,474 6 December-06 16,816,519 18,956,219 4.250% 68,424 7 January-07 44,790,691 63,746,909 4.250% 230,100 8 February-07 2,307,552 66,054,461 4.250% 215,356 9 March-07 (36,967,622) 29,086,839 4.250% 104,992 10 April-07 3,485,694 32,572,533 4.250% 113,781 11 May-07 (19,251,510) 13,321,023 4.250% 48,083 12 June-07 (23,324,070) (10,003,047) 4.250% (34,942) 13 Beg. Balance Prior Filing (2) 178,074 (9,824,974) 4.250% 14 July-07 (9,824,974) 4.250% (35,464) 15 August-07 (9,824,974) 4.250% (35,464 ) 16 September-07 (9,824,974) 4.250% (34,320) 17 October-07 (9,335,238) 4.250% (489,736) (33,696) 18 November-07 (8,491,880) 4.250% (843,358) (29,663) 19 December-07 (6,736,543) 4.250% (1,755,337) (24,316) 20 January-08 (4,201,040) 4.250% (2,535,503) (15,164) 21 February-08 (1,433,991) 4.250% (2,767,049) (4,842) 22 March-08 4.250% (1,433,991) 23 April-08 4.250% 24 May-08 4.250% 25 June-08 4.250% 26 27 Total $ (9,824,974) $ (9,824,974) $ 376,959 28 29 30 Notes: 31 1. Interest rate is as of August 24, 2005, the market rate for 3 year AAA rated corporate bonds as evidenced by the Bondtrac, Inc. bond market data. 32 2. Reference Schedule 8. A TMOS ENERGY CORP., MID- TEX DIVISION ANNUAL GAS COST RECONCILIATION FILING FOR THE PERIOD ENDED JUNE 30, 2007 AL TERNA TIVE PROPOSAL Schedule 7 ESTIMATED VOLUME CALCULATION FOR (REFUND)/SURCHARGE line No. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Month-Yr ~ October-07 November-07 December-07 January-08 February-08 March-08 April-08 May-08 June-08 Total Total Estimated Volume (1) (b) 4,937,820 8,503,262 17,698,407 25,564,533 27,899,120 14,458,394 99,061,535 Note: 1. Volume is estimated for Rate R, Rate C, from WP/Billed Gas Cost; Rate I from WP Lug-Related Met. Line No. Schedule 8 ATMOS ENERGY CORP., MID-TEX DIVISION ANNUAL GAS COST RECONCILIATION FILING FOR THE PERIOD ENDED JUNE 30, 2007 ALTERNATIVE PROPOSAL SUMMARY OF (OVER)/UNDER RECOVERY FROM PREVIOUS FILING Description (a) Amount (b) Reference (c) 1 2 3 4 5 6 7 8 9 10 Prior (Over)/Under Gas Cost Recovery $ (22,763,079) Prior Gas Cost Reconciliation Interest (1,055,006) (1 ) Amount Flowed Back to Customers 23,996,159 For the Periods October, 2006 through June, 2007 Total Amount to (Refund)/Surcharge from Previous Filing $ 178,074 Note: 1. Interest rate is as of August 24,2005, the market rate for 3 year AAA rated corporate bonds as evidenced by the Bondtrac, Inc. bond market data. Line No. Schedule 9 ATMOS ENERGY CORP., MID-TEX DIVISION ANNUAL GAS COST RECONCILIATION FILING FOR THE PERIOD ENDED JUNE 30, 2007 ALTERNATIVE PROPOSAL LOST AND UNACCOUNTED FOR GAS ("LUG") CALCULATION Description (a) Mcf or Percent (b) Reference (c) 1 Net Purchase Volume 138,143,861 WP/LUG-Related Mcf Col (d), Ln 13 WP/LUG-Related Mcf Col (e), Ln 133,985,527 13 plus Sch 5 Col (d), Ln 14 24,405 WP/LUG-Related Mcf Col 0), Ln 13 4,133,929 Line 1 minus Lines 2 and 3 2.99% Line 4 divided by Line 1 2 3 4 5 Less: Total Sales Volume Less: Company Use Volume LUG Volume LUG Percent ATMOS ENERGY CORP., MID-TEX DIVISION WP/Silled Gas Cosf ANNUAL GAS COST RECONCILIATION FILING Page 14 of 20 FOR THE PERIOD ENDED JUNE 3D, 2007 ALTERNATIVE PROPOSAL GAS COST BILLED - BY MONTH Rate R Rate C Rate I T Dial Billed line Billing No. Month-Yr Month-Yr Volume EGCF 1 Amount Volume EGCF 1 Amount Volume EGCF 1 Amount Amount Volume (a) (b) (e) (d) (e) m (9) (h) (i) OJ (k) (I) (m) 1 Jul-06 Jul-06 1,640,937.3 $ 6.6962 $ 12,695,471.63 2,177,336.5 $ 6.8962 $ 15,015,361.86 272,291.0 $ 6.7345 $ 1,833,743.74 $ 29,544,577.42 2 Jun06 Rev (279,842.0) 5.1005 (1,427,334.12) (1,427,334.12) 3 Jun-06 37,216.5 5.2229 194,317.84 (154,459.9) 5.2229 (606,728.84) 289,444.0 5.1005 1,476,309.12 863,958.32 4 May-06 1.485.7 5.2229 7,759.49 15,772.6 5.2229 82,378.50 266.0 5.1005 1,356.73 91.494.72 5 Apr-06 (247.0) 5.1005 (1,259.82) (1,259.82) 6 Mar-06 (404.4) 6.5215 (2,637.02) 5,037.1 6.5215 32,849.69 (105.0) 6.3687 (668.71) 29,543.96 7 Feb-06 (126.5) 7.9001 (999.62) 12.700.0 7.9001 100,331.43 (108.0) 7.7149 (833.21) 98,498.60 8 Jan-06 (202.7) 12.4916 (2.531.97) 11,607.2 12.4916 147,490.82 22.0 12.1988 268.37 145,227.22 9 Dee-OS (7.8) 12.6612 (98.84) 15,004.0 12.6612 189,968.63 189,869.80 10 Nav-OS (42.3) 15.1703 (641.76) 9,624.9 15.1703 146,012.12 145,370.37 11 Oct-Os (1,017.6) 15.1703 (15,437.43) 15.1703 (15,437.43) 12 13 Talal 1,677,638.1 $ 6.8564 $ 12,875,262.52 2,092,824.4 $ 7.1232 $ 14,907,664.42 281,721.0 $ 6.6789 $ 1,881,582.10 $ 29,664,509.03 4,252,3835 14 15 Aug-06 Aug-06 1,783,234.9 $ 6.8962 $ 12,297,544.41 2,224,871.5 $ 6.6962 $ 15,343,158.84 274,323.0 $ 6.7345 $ 1,847,428.24 $ 29,.188,131.50 16 Jul06 Rev (272,291.0) 6.7345 (1,833,743.74) (1,833,743.74) 17 Jul-06 (6,255.0) 6.8962 (43,136.03) 6,626,9 6.8962 45,700.56 282,185.0 6.7345 1,900,374.88 1,902,939.41 18 Jun-06 (1,684.3) 5.2229 (8,796.76) 3,752.1 5.2229 19,597.01 (11.0) 5.1005 (56.11) 10,744.15 19 May-06 6182 5.2229 3,228.93 3,461.0 52229 18,076.71 (61.0) 5.1005 (311.13) 20,994.51 20 Apr-06 (29.0) 5.1005 (147.91) (147.91) 21 Mar-06 (255.8) 6.5215 (1,668.17) 128.4 6.5215 837.18 (5.0) 6.3687 (31.84) (862.84) 22 Feb.-OS 164.5 7.9001 1,299.82 1,141.2 7.9001 9,015.61 (11.0) 7.7149 (84.86) 10,230.56 23 Jan-06 (856.4) 12.4916 (8,199.47) (605.2) 12.4918 (7,559.92) (12.0) 12.1988 (146.39) (15,905.78) 24 Dee-OS (211.2) 126612 (2,674.24) 92.7 12.6612 1,173.69 8.0 12.3645 98.92 (1,40163) 25 Nav-OS 2.4 15.1703 36.00 (7.0) 15.1703 (106.29) (7029) 26 Oct-Os (490.4) 15.1703 (7,439.72) 15.1703 (7,439.72) 27 28 Talal 1,774,466.9 $ 6.8923 $ 12,230,194.77 2,239,461.7 $ 6.8900 S 15,429,893.39 284,096.0 $ 6.73.'}0 $ 1,913,380.06 S ]Q,573,468.22 4,298,024.5 ATMOS ENERGY CORP:, MID-TEX DIVISION WP/Billed Gas Cost ANNUAL GAS COST RECONCILIATION FILING Page IS of 20 FOR THE PERIOD ENDED JUNE 30, 2007 ALTERNATIVE PROPOSAL GAS COST BILLED - BY MONTH Rate R Rate C Rate I T alaI Billed line Billing No. Month-Yr Month- Yr Volume EGCF 1 Amount Volume EGCF 1 Amount Volume EGCF 1 Amount Amount Volume (a) (b) (e) (d) (e) (f) (g) (h) (i) U) (k) (I) (m) 29 30 Sep-06 Sep-06 1,782,891.3 $ 6.8962 $ 12,295,175.12 2.196.707.0 $ 6.8962 $ 15,148,930.88 229.553.0 $ 6 7345 $ 1,545,92468 $ 28,990,030.68 31 Aug06 Rev (274,323.0) 6.7345 (1,847,426.24) (1,847,42824) 32 Aug-06 6.8962 6.8962 286,125.0 8.7345 1,926,908.81 1,92e,90B.B1 33 Jul-06 (889.1) 6.8962 (6,131.07) 1,692.8 6.8962 11,673.75 (1,697.0) 6.7345 (11,42845) (5,885.76) 34 Jun-06 328.7 5.2229 1,716.87 511.1 5.2229 2,669.42 19.0 5.1005 96.91 4,483.21 35 May-06 (1,909.4) 52229 (9,972.66) 1.817.5 5.2229 8,447.83 492.0 5.1005 2,509.45 984.62 36 Apr-06 456.0 5.1005 2,325.83 2,325.83 37 Mar-06 37.0 6.5215 241.17 (92) 6.5215 (60.06) 526.0 6.3687 3.349.94 3,531.04 38 Feb-06 2680 7.9001 2,275.15 260.0 7.9001 2,054.03 353.0 7.7149 2,72336 7,052.54 39 Jan-06 388.5 12.4916 4,852.49 (94.5) 12.4916 (1,180.46) 12.1988 3,872.03 40 Dee-OS 334.4 126612 4,234.29 (158.8) 12.6612 (2,008.07) 12.3645 2,226.22 41 Nav-OS 185.9 15.1703 2,819.55 (2.4) 15.1703 (37.02) 2,78254 42 Oct-os 30.7 15.1703 464.97 15.1703 484,97 43 Aug-05 8.0603 97.3 8.0603 784.27 784.27 44 45 Tolal 1,781,686.0 $ 6.9011 $ 12,295,675.88 2,200,620.9 $ 6.8941 $ 15,171,274.58 241,504.0 $ 6.7286 $ 1,624,982.28 $ 29,091,932.74 4,223,810.9 46 47 Oct-06 Od-06 2,132,082.1 $ 8.1213 $ 17,315,278.28 2,459,566.8 $ 8.1213 $ 19,974,880.02 282,206.0 $ 7.9310 $ 2,238,163.66 $ 39,528,321.95 48 Sepl06 Rev (229,553.0) 6.7345 (1,545,92468) (1,545,924.68) 49 Sep-06 (1,650.3) 6.8962 (11,380.80) 13,981.1 6.8962 96,41653 244,200.0 6.7345 1,644,564.90 1,729,600.63 50 Aug-06 407.0 6.7345 2,740.94 2,740,94 51 Jul-06 (1,0747) 6.8962 (7,41100) 1,360.6 6.8962 9,383.11 (141.0) 6.7345 (949.56) 1,022.54 52 JUn-06 (2,072.4) 5.2229 (10,82404) 1,296.8 5.2229 6,772.90 270.0 5.1005 1,377.14 (2,674.01) 53 May-06 (1,312.8) 5.2229 (6,856.68) 793.4 5.2229 4,14380 (394.0) 5.1005 (2,009.60) (4,722.48) 54 Apr-06 (356.0) 5.1005 (1,815.78) (1,815.78) 55 Mar-06 59.4 65215 387.12 (1,266.2) 6.5215 (8,257.52) (417.0) 6.3687 (2,655.75) (10,526.15) 56 Feb-06 (693) 7.9001 (547.71) (1,341.4) 7.9001 (10,597.19) (272.0) 7.7149 (2,09846) (13,24337) 57 Jan-06 245.2 12.4916 3,062.44 (1,849.1) 12.4916 (23,098.22) 107.0 12.1988 1,305.27 (18,73051) 58 Dee-OS 101.1 12.6612 1,280.30 (1,664.7) 12.6612 (21,077.61) 126.0 12.3645 1,557.93 (18,23938) 59 Nav-OS (158.8) 15.1703 (2,405.55) (209.9) 15.1703 (3,184.70) 42.0 14.8147 622.22 (4,968.04) 60 Od-05 51.1 15.1703 175.20 15.1703 33.0 14.8147 488.89 1,26409 61 Sep-05 22.0 8.8809 195,38 195.38 62 Aug-05 3.1 8.0603 24.99 8.0603 24.99 63 Nov-06 54,470.7 8.1213 442,373.06 8.1213 442,373.06 64 65 Tolal 2,180,674.6 $ 8.1276 $ 17,723,755.60 2,470,667.3 $ 8.1053 S 20,025,381. 11 2Qfl,280.0 $ 7.8830 $ 2,335,562.49 $ 40,084,699.19 4,947,621.9 66 ATMOS ENERGY CORP., MID-TEX DIVISION WP/Billed Gas Cost ANNUAL GAS COST RECONCILIATION FILING Page 16 of 20 FOR THE PERIOD ENDED JUNE 30, 2007 ALTERNATIVE PROPOSAL GAS COST BILLED - BY MONTH Rate R Rate C Rate I Total Billed Line Billing No. Month-Yr Monlh~Yr Volume EGCF 1 Amount Volume EGCF 1 Amount Volume EGCF 1 Amount Amount Volume (a) (b) (e) (d) (e) (f) (g) (h) (i) Ul (k) (I) (m) 67 Nov-06 Nov-06 4,640,998,3 $ B.1213 $ 37.690,939.09 3,288,065.7 $ B.1213 $ 26,703,367.73 348,998.0 $ 7.9310 $ 2,767,8BB.14 $ 67,162,194.96 68 Oct06 Rev (282,206.0) 7.9310 (2,238,163.66) (2,238,163.66) 69 Oct-06 73,750.1 8.1213 598,946.61 149,279.3 8.1213 1,212.341.57 292,211.0 7.9310 2,317,512.89 4,128,801.06 70 Sep-06 68962 6.8962 (2,786.0) 6.7345 (16,762.32) (18,762.32) 71 Aug-06 (398.0) 6.8962 (2,744.96) 2,477.5 6.8962 17,085.40 (29.0) 6.7345 (195.30) 14,145.14 72 Juf-06 (193.4) 6.8962 (1,33352) 762.1 6.8962 5,255.59 (645.0) 6.7345 (4,343.75) (42168) 73 JUn-06 (1187) 5.2229 (620 17) 358.5 5.2229 1,872.41 (710.0) 5.1005 (3,621.36) (2,36911) 74 May-06 5.2229 (2.8) 5.2229 (14.57) (630) 5.1005 (321.33) (335.90) 75 Apr-06 80.2 5.2229 419.03 2,451.7 5.2229 12,805.14 (10.0) 5.1005 (51.01) 13,173.17 76 Mar-06 (29.2) 6.5215 (190.30) 95.5 6.5215 622.80 6.3687 432.51 77 Feb-06 40.6 7.9001 320.51 170.2 7.9001 1,344.60 7.7149 1,665.10 76 Jan-06 (101.8) 12.4916 (1,271.77) (232.7) 12.4916 (2,906.80) 12.1988 (4,178.57) 79 Dee-OS 24.6 12.6612 311.47 4.3 12.6612 54.44 12.3645 36591 80 Nov-05 29.6 15.1703 448.28 (1.4) 15.1703 (21.24) 14.8147 427.04 81 Oel-05 14.0 15.1703 212.38 15.1703 14.6147 212.38 82 63 Total 4,714,096.2 $ B.1215 $ 38,285,436.65 3,443,427.9 $ 8.1174 $ 27,951,807.09 354,760.0 $ 7.9489 $ 2,819,942.31 $ 69,057,186.04 8,512,284_0 64 65 Dec-06 Dee-OS 11,250,202.8 $ 8.1213 $ 91,366,271.76 5,971,471.4 $ 6.1213 $ 48,496,110.52 474,143.0 $ 7.9310 $ 3,760,407.76 $ 143,622,790.03 66 Nov06 Rev (348,998.0) 7.9310 (2.767,88814) (2,767,68814) 87 Nov-06 8_1213 6.1213 358,282.0 7.9310 2,841,519.15 2,841,519.15 88 Oct-06 (988.4) 8.1213 (8,010.77) (8363) 8.1213 (6,791.92) 2,180.0 7.9310 17,289.49 2,486.79 89 Sep-06 6.8962 6.8962 214.0 6_7345 1,441.18 1,441.18 90 Aug-06 (666.6) 6.8962 (4,735.21) (1,234.6) 6.8962 (8,51391) 48.0 6.7345 323.26 (12,925.86) 91 Jul-OS (201.8) 6.8962 (1,391.93) 597.8 6.8962 4,122.55 6.7345 2,730.62 92 Jun-06 43.3 5.2229 226_15 386.1 5.2229 2,016.56 5.1005 2,242.71 93 May-OS 5.2229 5.2229 5.1005 94 Apr-06 77.3 5.2229 403.68 487.2 5.2229 2,544.70 5.1005 2,948.38 95 Mar-06 14.2 6.5215 92.61 47.0 6.5215 306.51 6.3687 399.12 96 Feb-06 53.1 79001 419.50 1,609.9 7.9001 12,718.37 7.7149 13,137.87 97 Jan-06 40.5 12.4916 505.91 1,584.3 12.4916 19,790.44 12.1988 20,296.35 98 Dee-OS 42.6 12.6612 541.77 1,824.2 126612 23,096.56 12.3645 23,638_33 99 Nav-05 (2.1) 15.1703 (32.31) 189.1 15.1703 2,868.70 14.6147 2,836_39 100 Oct-Os 5.6 15.1703 84.95 15.1703 14.6147 84.95 101 102 Tolal 11,248,602.6 $ 8.1214 $ 91,354,376.10 5,976,126.1 $ 6.1237 $ 48,548,269.08 485,869.0 $ 7.9303 $ 3,653,09269 $ 143,755,737.88 17.710,597.7 103 ATMOS ENERGY CORP., MID-TEX DIVISION Wpmilled Gas Cost ANNUAL GAS COST RECONCILIATION FILING Page 17 of 20 FOR THE PERIOD ENDED JUNE 30, 2007 ALTERNATIVE PROPOSAL GAS COST BILLED - BY MONTH Rate R RaleC Rate I Total Billed Line Billing No. Monlh~Yr Month-Yr Volume EGCF 1 Amount Volume EGCF 1 Amount Volume EGCF 1 Amount Amount Volume (a) (b) (e) (d) (e) (I) (g) (h) (i) (j) (k) (/) (m) 104 Jan-07 Jan-07 14.435,396.6 $ 7.4003 $ 106,826,265.46 7,228,430.3 $ 7.4003 $ 53,492,552.97 828,324.0 $ 7.2269 $ 4,526,353.02 $ 164,845,17145 105 Dec06 Rev (474,143.0) 7.9310 (3,760,407.76) (3,760,407.16) 106 Dec-06 8.1213 8.1213 495,914.0 7.9310 3,933,548.48 3,933,548.48 107 Nov-06 22,566.8 8.1213 183,211.43 35,437.9 8.1213 287.802.06 365.0 7.9310 2,894.80 473,968.29 108 Oct-06 (865.9) 8.1213 (1,031.83) 4,122.5 8.1213 33,480.14 23.0 7,9310 182.41 26,630.72 109 Sep-06 6.8962 6.8962 20.0 6.7345 134.69 134.69 110 Aug-06 (1,492.3) 6.8962 (10,290.65) 8,4648 6.6962 58.374.95 19.0 6.7345 127.96 48,212.05 111 Jul-06 32.4 6.8962 223.30 3,561.7 6.8962 24,562.20 12.0 8.7345 80.81 24,866.31 112 Jun-06 21.6 5.2229 112.61 295.5 5.2229 1,54331 5.1005 1,656.13 113 MaY-06 5.2229 5.2229 4.0 5.1005 20AO 20AO 114 Apr-06 306.6 5.2229 1,601.34 (176.1) 5.2229 (4,05349) 5.1005 (2,452.15) 115 Mar-06 299.7 6.5215 1,954.49 (1,600.2) 6.5215 (10,435.70) 6.3681 (8,481.21) 116 Feb--06 566.2 7.9001 4,473.04 (29.4) 7.9001 (232.26) 7.7149 4,240.77 117 Jan-06 632.3 124916 7,898.44 580.7 12.4916 7,253.87 12.1988 15,152.31 118 Dee-OS 48.7 12.6612 616.60 96.9 12.6612 1,226.87 12.3645 1.843.47 119 Nav-OS 404.6 15.1703 6,137.14 (14.8) 15.1703 (224.52) 14.8147 5,912.62 120 Oct-Os 431.1 15.1703 6,539.92 15.1703 14.8147 6,539.92 121 Aug-05 05 8_0603 4.03 8.0603 4_03 122 Apr-05 12.0 5.4729 65.68 65.68 123 Jan-05 1,882.0 7.9871 15,031.7-4 15,031.74 124 Feb-07 2,244,2195 6.3858 14,331,136.76 947,928.4 6.3858 6,053,281.43 20,384,418.19 125 126 Tolal 16,702,568.4 $ 7.2655 $ 121,352,912.08 8,226,498.3 $ 7.2868 $ 59,945,131.83 650,4920 $ 7.2530 $ 4,718,03224 $ 186,016,076.14 25,579,558.7 127 128 Feb-07 Feb-07 17,989,854_9 $ 6.3858 $ 114,879,615.48 8,893,702.6 $ 6.3858 $ 56,793,406.25 510,874.0 $ 6.2361 $ 3,185,878.11 $ 174,858,899.85 129 Jan07 Rev (626,324.0) 7.2269 (4,526,353.02) (4,526,353.02) 130 Jao-07 7,016.0 7.4003 51,920.13 12,078.6 7.4003 89,385.49 652,877.0 72269 4.718,247.72 4,859,553.34 131 Dec.-06 8.1213 8.1213 1,1700 7.9310 9,279.22 9,279.22 132 Nov-06 (1,2995) 8.1213 (59,281.67) 12,400.4 8.1213 100,707.45 58.0 7.9310 460.00 41.885.77 133 Oct-06 (1,692.0) 8.1213 (13,741.08) 2,445.3 8.1213 19.858.93 11.0 7.9310 87.24 6,205.10 134 Sep-06 6.8962 1,906.1 6.8962 13,144.92 2.0 6.7345 13.47 13,158.38 135 AUQ-06 2,952.5 6_8962 20,361.03 6.8962 1.0 6.7345 6.73 20,367.77 136 Jul-06 (17.9) 6.8962 (537.15) 154.8 6.8962 1,067.19 3.0 6.7345 20.20 550.25 137 Jun--06 25.8 5.2229 134.75 53_2 52229 277.86 5.1005 41261 138 May-06 5.2229 5.2229 (4.0) 5.1005 (20.40) (2040) 139 Apr-06 (167.6) 5.2229 (875.36) 202.6 5.2229 1,056.16 5.1005 182_80 140 Mar-06 (257.2) 6.5215 (1,677.33) 220.5 6.5215 1,437.99 6.3687 (239.34) 141 Feb-06 (450.5) 7_9001 (3,558.76) 165.7 7.9001 1,309.05 7.7149 (2,24971) 142 Jan-06 (515.0) 12.4916 (8,433.17) 12.4 12.4916 154.90 12.1988 (6,278.28) 143 Dec.-OS (92.9) 12.6612 (1,176.23) 254 12.6612 321.59 12.3645 (854.63) 144 Nov-OS (405.0) 15.1703 (6,143.97) (9146) 15.1703 (13,87430) 14.8147 (20,018.27) 145 Oct-Os (388.9) 15_1703 (5,899.73) 15.1703 14.8147 (5,899.73) 146 Aug-05 8.0603 8.0603 147 Apr-OS (12.0) 5.4729 (65.68) (65.68) 148 Jan-OS (1,882.0) 7.9871 (15,031.74) (15,031.74) 149 Mar-07 261,2666 7.7923 2,035,867.73 203,020.8 7.7923 1,581,997.27 3,617,864.99 150 151 Total 18,2-49,769.3 $ 6.4049 $ 116,888,574.69 9,125,473.6 $ 6.-4205 S 58,590,252.74 536,714,0 $ 6.2829 S 3,372,521.85 $ 178,851,349.28 27,912,016.9 152 ATMOS ENERGY CORP., MID-TEX DIVISION WPIBilled Gas Cost ANNUAL GAS COST RECONCILIATION FILING Page 180120 FOR THE PERIOD ENDED JUNE 30, 2007 ALTERNATIVE PROPOSAL GAS COST BILLED - BY MONTH Rate R RaleC Ratel Total Billed Line Billing No. Month-Yr Month-Yr Volume EGCF 1 Amount Volume EGCF 1 Amount Volume EGCF 1 Amount Amount Volume Ca) (b) (e) (d) (e) (I) (g) (h) (I) U> (k) (I) (m) 153 Mar-O? Mar-OJ 8,746,159.8 $ 7_7923 $ 66,152,701.17 5,276,799.6 $ 7.7923 $ 41,116,40545 339,559.0 $ 7.6097 $ 2,563,931.25 $ 111,855,037.86 154 Feb-07 10,741.5 6.3656 66,592.94 (4,360.4) 6.3858 (27,972.42) 517,257.0 6.2361 3,225,663.35 3.266,303.87 155 FebO? Rev (510,674.0) 6.2361 (3,165,676.11) (3,165,67611) 156 Jan-07 (1,9206) 7.4003 (14,213.09) 13,619.2 7.4003 100,785.80 413.0 7.2269 2,984.69 89,557.40 157 Dee-DB 6.1213 6.1213 53.0 7.9310 420.34 420.34 156 Nov-06 (3,115.9) 8.1213 (25,304.92) 5,321.3 8.1213 43,215.95 (226.0) 7.9310 (1,606.26) 16,102.78 159 Oct.06 (516.8) 6.1213 (4,197.09) 701.2 6.1213 5,694.66 7.9310 1,497.57 160 Sep-06 6.8962 (121.0) 6.6962 (634.37) 6.7345 (6307) 161 Aug-06 (4,147.6) 6.8962 (26,602.40) 6.6962 6.7345 (26,60240) 162 Jul-06 59.4 6.6962 409.63 (166.4) 6.6962 (1,161.32) 6,7345 (751.69) 163 Jun-06 54.4 5.2229 284.13 (42.1) 5.2229 (219.66) 5.1005 64.24 164 May-06 5.2229 5.2229 51005 165 Apr-06 86.7 5.2229 452.83 56.4 5.2229 294.57 5.1005 747.40 166 Mar-06 43.5 6.5215 263.69 2,363.5 6.5215 15,413.57 63667 15,697.25 167 Feb-06 1.6 7.9001 12.64 (452.6) 7.9001 (3,577.17) 7.7149 (3,56453) 168 Jan-06 20.6 12.4916 257.33 (626.3) 12.4916 (7,646.47) 12.1966 (7,591.15) 169 Dee-OS 20.0 12.6612 253.22 1.0 12.6612 12.66 12.3645 265.69 170 Nov-05 15.7 15.1703 236.17 627.2 15.1703 12,546.67 14.6147 12,787,05 171 Oct-Os 20.5 15.1703 310.99 15.1703 146147 310.99 172 Aug.05 6.0603 6.0603 173 Apr-05 5.4729 174 Jan-05 7.9871 175 Apr-07 45,7763 7.6216 346,697.73 33,192,4 7.6218 252,965.99 601,883.71 176 177 Total 8,793,299.2 $ 7.7901 $ 68,500,376.97 5,327,088.8 $ 7.7916 $ 41,507,743.67 346,160.0 $ 7.5837 $ 2,625,333.26 $ 112,633,454.09 14,466,567.9 178 179 Apr-07 Apr-07 4,586,136.2 $ 76218 $ 34,954,612.89 3,523.678.1 $ 7.6216 $ 26,856,769.97 304,226.0 $ 74431 $ 2,264,399.43 $ 64,075.782.29 160 Mar-07 154,404.7 7,7923 1,203,167.35 106,620.1 7.7923 630,616.04 345,546.0 7_6097 2,629,490.33 4,663,473.72 181 Mar07 Rev (339,559.0) 76097 (2,563,931.25) (2,563,931.25) 162 Feb-07 (14,510.3) 6.3658 (92,659.62) (61.6) 6.3856 (522.55) 5,264.0 62361 32,627.00 (60,355.17) 163 Jan-07 (527.1) 7.4003 (3,900.40) 5,936.7 74003 43,932.99 7,006.0 7.2269 50,631.35 90,663.94 164 Dee-06 6.1213 6.1213 5,177.0 7.9310 41,058.56 41,056.56 165 Nov-06 (1,661.1) 6.1213 (13,652.66) 3,772.7 6.1213 30,639.15 2,130.0 7.9310 16,692.94 33,67921 166 Oct-06 (991) 8.1213 (604.56) 469.7 8.1213 3,614.57 899.0 7.9310 7.129.93 10,139_93 167 Sep-06 6.8962 26.2 6.6962 160.40 450.0 67345 3,030.53 3,210.93 166 Aug-D6 6.3 6.6962 57.24 6.6962 403.0 6.7345 2,714.00 2.77124 189 Jul-OB (0.3) 6.8962 (2.00) (10.2) 6.6962 (70.34) 527.0 6.7345 3,549.08 3.476.74 190 Jun-06 (1.1) 52229 (5.64) (13.5) 5.2229 (70.51) 660.0 5.1005 3,366.33 3,290.16 191 May-DB 52229 5.2229 5.1005 192 Apr-06 (6.3) 5.2229 (32.90) (71.6) 5.2229 (37500) 5.1005 (407.91) 193 Mar-06 0.2 6.5215 1.30 (196.6) 6.5215 (1,296.47) 6.3687 (1,295.17) 194 Feb-06 (9.6) 7.9001 (75.64) (6.3) 7.9001 (65.57) 7.7149 (14141) 195 Jan-06 5.6 12.4916 69.33 (552) 12.4916 (669.54) 12.1988 (62021) 196 Dee-OS 6.4 12.6612 61.03 (65.2) 12.6612 (625.51) 12.3645 (744.46) 197 Nov-05 15.1703 75.6 15.1703 1,146.67 14.8147 1,146.87 196 Oct-OS (15.2) 15.1703 (231.04) 15.1703 14.6147 (23104) 199 Aug-05 8.0603 8.0603 200 Apr-05 5.4729 201 Jan-05 7.9871 202 May-07 75,466.2 7.6218 575,188.13 51,293.2 7.6218 390,946.44 966,134.57 203 204 Total 4,799,177.5 $ 7.6309 $ 36,621,612.37 3,691,367.4 $ 7.6271 $ 28,154,330,94 332,731.0 $ 7.4269 $ 2,471,156.23 $ 67,247,301.55 8,823.275.9 ATMOS ENERGY CORP., MID-TEX DIVISION WP/BiUed Gas Cost ANNUAL GAS COST RECONCILIATION FILING Page 19 of 20 FOR THE PERIOD ENDED JUNE 3D, 2007 ALTERNATIVE PROPOSAL GAS COST BILLED - BY MONTH Rate R Rate C Rate I Total Billed Line Billing No. Month-Yr Month- Yr Volume EGCF 1 Amount Volume EGCF 1 Amount Volume EGCF 1 Amount Amount Volume (a) (b) (e) (d) (e) <n (g) (h) (i) (j) (k) (I) (m) 205 206 May-OJ May-OJ 3,324,086.3 $ 7.621B $ 25,335,520.96 3,031,603.0 $ 7.621B $ 23,152,002.55 245,4250 $ 7.4432 $ 1 ,B26, 73B.54 $ 50,314,262.05 207 Apr-07 (1,270.3) 7.621B (9,6B1.67) 530.9 7B21B 4,04649 310,B63.0 7.4431 2,313,784.40 2,30B,149.22 208 Apr07 Rev 7.821B 7.621B (304,228.0) 7.4431 (2,264,399.43) (2,264,399.43) 209 Mar-07 (18,648.6) 7.7923 (129.730.81) 8,216.3 7.7923 64,023.87 (812.0) 7.6097 (6,179.05) (71,885.98) 210 Feb-O? (11,735.1) 6.3858 (74,937.75) 14.961.4 6.3858 95,540.64 122.0 6.2361 760.81 21,363.70 211 Jan-07 (8,228.2) 7.4003 (60,891.07) 8,647.2 7.4003 63,991.87 4.0 7.2269 28.91 3,129.71 212 Oec-06 8.1213 8.1213 7.9310 213 Nov-06 (6,416.6) B.1213 (52,111.05) 5,954.1 8.1213 48,355.03 7.9310 (3,75802) 214 Ocl-06 9.4 8.1213 76.34 (21B.6) B.1213 (1,775.32) 7.9310 (1,698.9B) 215 Sep-06 6.8962 (217.8) 6.8962 (1,501.99) 6.7345 (1,501.99) 216 Aug-06 4.7 6.8962 32.41 6.6962 6.7345 32.41 217 Jul-06 6.6 6.e962 45.51 371.8 6.8962 2,564.01 6.7345 2,609.52 218 Jun-06 (0.8) 5.2229 (3.08) 0.7 5.2229 3.66 5.1005 0.57 219 May-06 5.2229 5.2229 5.1005 220 Apr-D6 5.6 5.2229 29_25 8.3 5.2229 43.35 5.1005 72.60 221 Mar-06 (10.1) 6.5215 (85.B7) (4.9) 6.5215 (31.96) 6.3687 (97.82) 222 Feb-06 (0.8) 7.9001 (6.32) 01 7.9001 0.79 7.7149 (5.53) 223 Jan-06 12.4916 8.0 12.4916 99.93 12.1988 99.93 224 Dec-05 (27.8) 12.6612 (35198) 25.1 126612 317.80 12.3645 (34.19) 225 Nov-OS (7.4) 15.1703 (112.56) 4.6 15.1703 69.78 14.8147 (42.78) 226 Oct-Os (0.4) 15.1703 (6.07) 15.1703 14.8147 (607) 227 Aug-05 8.0603 8.0603 22B Apr-05 5.4729 229 Jan-05 7.9871 230 Jun-07 68,384.3 7.6045 520,028.33 58,802.6 7.60""5 447,164.37 967,192.71 231 232 Tolal 3,348,151.1 $ 7.6245 $ 25,527,834.5B 3,134,892.8 $ 7.6163 $ 23,874,914.88 251,374.0 $ 7 4420 $ 1,870,73417 $ 51,273,483.63 6.734,2179 233 234 Jun-07 Jun-07 3,316,639.6 $ 87500 $ 29,020,596.50 3,055,OB8.0 $ 8.7500 $ 28,732,020.00 213,402.0 $ B.5449 $ 1,823,50342 $ 57,576,119.92 235 Jun-07 (2,253.0) , 7.6045 (17,132.94) (1,115.4) 7.6045 (8,482.06) (25,815.00) 236 May-07 70"".0 7.6218 5,365.75 7,789.4 7.6218 59.369.25 254,737.0 7.4432 1,896,058.44 1,960,793.43 237 May07 Rev 7.6218 7.6218 (245,425.0) 7.4432 (1,B26,73B.54) (1,826,738.54) 238 Apr-07 (3,892.7) 7.6218 (29,669.38) 7,878.0 7.6218 60,044.54 9,460.0 7.4431 70,411.73 100,786.89 239 Mar-07 (4,857.1) 7 _7923 (37,847.98) 8,409.7 7.7923 65,530.91 1,320.0 7.6097 10,044.76 37,727.69 240 Feb-07 (7,391.4) 6.3858 (47,200.00) 14,099.4 6.3858 90,035.95 66.0 6.2361 411.58 43,247.53 241 Jan-07 (5,188.4) 7.4003 (38,395.72) 11,844.0 7.4003 87,64915 23.0 7.2269 166.22 49,419.65 242 Dec~06 8.1213 8.1213 11.0 7.9310 87.24 87.24 243 Nov-06 (1,B531) 8.1213 (15,04958) 6,703.1 8.1213 54,437.89 17.0 7.9310 134.83 39,52313 244 Ocl-06 (2.1) 8.1213 (17.05) 996.1 B.1213 8,089.63 7.9310 8,072.57 245 Sep-06 6.8962 8.8962 6.7345 246 Aug-06 5.0 6.8962 34.48 748.8 6.8962 5,163.87 6.7345 5,198.36 247 Jur-06 27 6.8962 18.62 307.0 6.8962 2,117.13 6.7345 2,135.75 24B Jun-06 2.4 5.2229 12.53 286.4 5.2229 1,495_84 5.1005 1,508.37 249 May-OB 5.2229 5.2229 5.1005 250 Apr-06 (2.9) 5.2229 (15.15) 3,998.3 5.2229 20,882.72 5.1005 20,867.57 251 MAr-06 (14.1) 6.5215 (91.95) (2.4) 6.5215 (15.65) 6.3687 (107.80) 252 Feb-DB (290) 7.9001 (229.10) 0.6 7.9001 4.74 7.1149 (224_36) 253 Jan-06 (100) 124916 (124.92) 12.4916 12.1988 (124.92) 254 Dec-OS (11.6) 12.6612 (148.87) 12.6612 12.3645 (146.B7) 255 Nov-OS 15.1703 15.1703 14.8147 256 Oct-OS (3.1) 15.1703 (47.03) 15.1703 14.8147 (47.03) 257 Auy-05 8.0603 8.0603 258 Apr-05 5.4729 259 Jan-05 7.9871 260 Jut-07 503.5 B.7500 4,405.63 534.6 8.7500 4,677. 75 9,083.38 261 262 Tolal 3,292,3-48.7 $ 8.7611 $ 28,844,465.84 3,117,565.6 $ 8.7193 $ 27,183,021.66 233,611.0 $ 8.4503 $ 1,974,079.67 $ 58,001,567.17 6,643,525.3 263 264 Grand Total 78,762,678.3 $ 582,500,678.03 51,045,814.8 $ 381.289,685.58 4,295,392.0 $ 31,460 401.35 $ 995,250,764.96 134.103.885.1 265 266 287 Note: 268 1. Estimated Gas Cost Factor, per monthly Rider GCR - Rate Filings under Dockel No. 9400. WP/LUG-Related Met ATMOS ENERGY CORP., MID-TEX DIVISION ANNUAL GAS COST RECONCILIATION FILING FOR THE PERIOD ENDED JUNE 30, 2007 ALTERNATIVE PROPOSAL LUG-RELATED VOLUMES/QUANTITIES - BY MONTH Net Purchase Met Net Purchase Btu Net Purchase Industrial Company Line No. Month-Yr MMBtu Factor Mct Mcf Use Mct (a) (b) (c) (d) (e) (h) 1 July-06 4,612,169 1.021 4,516,661 272,638 1,980 2 August-06 3,863,767 1.020 3,786,765 275,115 1,828 3 September-06 4,419,918 1.024 4,316,892 232,424 1,805 4 October-06 6,622,555 1.024 6,467,116 286,478 971 5 November-06 12,817,031 1.023 12,526,836 345,738 1,248 6 December-06 21,567,671 1.020 21 , 141 ,658 473,678 2,431 7 January-07 33,430,186 1.023 32,670,943 635,466 3,581 8 February-07 24,130,948 1.021 23,645,245 523,877 4,411 9 March-07 9,964,469 1.023 9,744,266 338,006 2,297 10 April-07 10,377,693 1.020 10,171,215 323,862 1,272 11 May-07 4,514,156 1.020 4,424,185 242,803 1,184 12 June-07 4,835,373 1.022 4,732,079 226,949 1,399 13 Total 141,155,937 138,143,861 4,177,034 24,405