HangHor/FinQA_Normalized_ALL huggingface dataset:
entergy texas , inc .and subsidiaries management 2019s financial discussion and analysis plan to spin off the utility 2019s transmission business see the 201cplan to spin off the utility 2019s transmission business 201d section of entergy corporation and subsidiaries management 2019s financial discussion and analysis for a discussion of this matter , including the planned retirement of debt and preferred securities .results of operations net income 2011 compared to 2010 net income increased by $ 14.6 million primarily due to higher net revenue , partially offset by higher taxes other than income taxes , higher other operation and maintenance expenses , and higher depreciation and amortization expenses .2010 compared to 2009 net income increased by $ 2.4 million primarily due to higher net revenue and lower interest expense , partially offset by lower other income , higher taxes other than income taxes , and higher other operation and maintenance expenses .net revenue 2011 compared to 2010 net revenue consists of operating revenues net of : 1 ) fuel , fuel-related expenses , and gas purchased for resale , 2 ) purchased power expenses , and 3 ) other regulatory charges ( credits ) .following is an analysis of the change in net revenue comparing 2011 to 2010 .amount ( in millions ) .
[['', 'amount ( in millions )'], ['2010 net revenue', '$ 540.2'], ['retail electric price', '36.0'], ['volume/weather', '21.3'], ['purchased power capacity', '-24.6 ( 24.6 )'], ['other', '4.9'], ['2011 net revenue', '$ 577.8']]
the retail electric price variance is primarily due to rate actions , including an annual base rate increase of $ 59 million beginning august 2010 , with an additional increase of $ 9 million beginning may 2011 , as a result of the settlement of the december 2009 rate case .see note 2 to the financial statements for further discussion of the rate case settlement .the volume/weather variance is primarily due to an increase of 721 gwh , or 4.5% ( 4.5 % ) , in billed electricity usage , including the effect of more favorable weather on residential and commercial sales compared to last year .usage in the industrial sector increased 8.2% ( 8.2 % ) primarily in the chemicals and refining industries .the purchased power capacity variance is primarily due to price increases for ongoing purchased power capacity and additional capacity purchases. .

Question: what was the average net revenue from 2010 to 2011
Answer: 559
entergy arkansas , inc .and subsidiaries management 2019s financial discussion and analysis results of operations net income 2017 compared to 2016 net income decreased $ 27.4 million primarily due to higher nuclear refueling outage expenses , higher depreciation and amortization expenses , higher taxes other than income taxes , and higher interest expense , partially offset by higher other income .2016 compared to 2015 net income increased $ 92.9 million primarily due to higher net revenue and lower other operation and maintenance expenses , partially offset by a higher effective income tax rate and higher depreciation and amortization expenses .net revenue 2017 compared to 2016 net revenue consists of operating revenues net of : 1 ) fuel , fuel-related expenses , and gas purchased for resale , 2 ) purchased power expenses , and 3 ) other regulatory charges ( credits ) . a0 a0following is an analysis of the change in net revenue comparing 2017 to 2016 .amount ( in millions ) .
[['', 'amount ( in millions )'], ['2016 net revenue', '$ 1520.5'], ['retail electric price', '33.8'], ['opportunity sales', '5.6'], ['asset retirement obligation', '-14.8 ( 14.8 )'], ['volume/weather', '-29.0 ( 29.0 )'], ['other', '6.5'], ['2017 net revenue', '$ 1522.6']]
the retail electric price variance is primarily due to the implementation of formula rate plan rates effective with the first billing cycle of january 2017 and an increase in base rates effective february 24 , 2016 , each as approved by the apsc .a significant portion of the base rate increase was related to the purchase of power block 2 of the union power station in march 2016 .the increase was partially offset by decreases in the energy efficiency rider , as approved by the apsc , effective april 2016 and january 2017 .see note 2 to the financial statements for further discussion of the rate case and formula rate plan filings .see note 14 to the financial statements for further discussion of the union power station purchase .the opportunity sales variance results from the estimated net revenue effect of the 2017 and 2016 ferc orders in the opportunity sales proceeding attributable to wholesale customers .see note 2 to the financial statements for further discussion of the opportunity sales proceeding. .

Question: how much higher is net revenue in 2017 than 2016 ? ( in millions )
Answer: 2.1
notes to consolidated financial statements 2014 ( continued ) fiscal years ended may 25 , 2008 , may 27 , 2007 , and may 28 , 2006 columnar amounts in millions except per share amounts administrative expenses , including the reclassification of the cumulative after-tax charges of $ 21.9 million from accumulated other comprehensive income .during fiscal 2007 , the company closed on the sale of these notes for approximately $ 117 million , net of transaction expenses , resulting in no additional gain or loss .8 .inventories the major classes of inventories are as follows: .
[['', '2008', '2007'], ['raw materials and packaging', '$ 580.8', '$ 458.5'], ['work in progress', '100.0', '94.6'], ['finished goods', '1179.1', '1001.3'], ['supplies and other', '71.6', '70.7'], ['total', '$ 1931.5', '$ 1625.1']]
9 .credit facilities and borrowings at may 25 , 2008 , the company had credit lines from banks that totaled approximately $ 2.3 billion .these lines are comprised of a $ 1.5 billion multi-year revolving credit facility with a syndicate of financial institutions which matures in december 2011 , uncommitted short-term loan facilities approximating $ 364 million , and uncommitted trade finance facilities approximating $ 424 million .borrowings under the multi-year facility bear interest at or below prime rate and may be prepaid without penalty .the company has not drawn upon this multi- year facility .the uncommitted trade finance facilities mentioned above were maintained in order to finance certain working capital needs of the company 2019s trading and merchandising operations .subsequent to the sale of this business in june 2008 , the company exited these facilities .the company finances its short-term liquidity needs with bank borrowings , commercial paper borrowings , and bankers 2019 acceptances .as of may 25 , 2008 , the company had outstanding borrowings of $ 578.3 million , primarily under the commercial paper arrangements .the weighted average interest rate on these borrowings as of may 25 , 2008 was 2.76% ( 2.76 % ) .the average consolidated short-term borrowings outstanding under these facilities were $ 418.5 million and $ 4.3 million for fiscal 2008 and 2007 , respectively. .

Question: what percentage of total inventories is comprised of finished goods in 2008?
Answer: 61%
part ii item 5 2014market for registrant 2019s common equity and related stockholder matters market information .the common stock of the company is currently traded on the new york stock exchange ( nyse ) under the symbol 2018 2018aes . 2019 2019 the following tables set forth the high and low sale prices for the common stock as reported by the nyse for the periods indicated .price range of common stock .
[['2002 first quarter', 'high $ 17.84', 'low $ 4.11', '2001 first quarter', 'high $ 60.15', 'low $ 41.30'], ['second quarter', '9.17', '3.55', 'second quarter', '52.25', '39.95'], ['third quarter', '4.61', '1.56', 'third quarter', '44.50', '12.00'], ['fourth quarter', '3.57', '0.95', 'fourth quarter', '17.80', '11.60']]
holders .as of march 3 , 2003 , there were 9663 record holders of the company 2019s common stock , par value $ 0.01 per share .dividends .under the terms of the company 2019s senior secured credit facilities entered into with a commercial bank syndicate , the company is not allowed to pay cash dividends .in addition , the company is precluded from paying cash dividends on its common stock under the terms of a guaranty to the utility customer in connection with the aes thames project in the event certain net worth and liquidity tests of the company are not met .the ability of the company 2019s project subsidiaries to declare and pay cash dividends to the company is subject to certain limitations in the project loans , governmental provisions and other agreements entered into by such project subsidiaries .securities authorized for issuance under equity compensation plans .see the information contained under the caption 2018 2018securities authorized for issuance under equity compensation plans 2019 2019 of the proxy statement for the annual meeting of stockholders of the registrant to be held on may 1 , 2003 , which information is incorporated herein by reference. .

Question: was the 2002 first quarter variance in high & low stock prices greater than the 2001 first quarter variance?
Answer: no
note 8 2014 benefit plans the company has defined benefit pension plans covering certain employees in the united states and certain international locations .postretirement healthcare and life insurance benefits provided to qualifying domestic retirees as well as other postretirement benefit plans in international countries are not material .the measurement date used for the company 2019s employee benefit plans is september 30 .effective january 1 , 2018 , the legacy u.s .pension plan was frozen to limit the participation of employees who are hired or re-hired by the company , or who transfer employment to the company , on or after january 1 , net pension cost for the years ended september 30 included the following components: .
[['( millions of dollars )', 'pension plans 2018', 'pension plans 2017', 'pension plans 2016'], ['service cost', '$ 136', '$ 110', '$ 81'], ['interest cost', '90', '61', '72'], ['expected return on plan assets', '-154 ( 154 )', '-112 ( 112 )', '-109 ( 109 )'], ['amortization of prior service credit', '-13 ( 13 )', '-14 ( 14 )', '-15 ( 15 )'], ['amortization of loss', '78', '92', '77'], ['settlements', '2', '2014', '7'], ['net pension cost', '$ 137', '$ 138', '$ 113'], ['net pension cost included in the preceding table that is attributable to international plans', '$ 34', '$ 43', '$ 35']]
net pension cost included in the preceding table that is attributable to international plans $ 34 $ 43 $ 35 the amounts provided above for amortization of prior service credit and amortization of loss represent the reclassifications of prior service credits and net actuarial losses that were recognized in accumulated other comprehensive income ( loss ) in prior periods .the settlement losses recorded in 2018 and 2016 primarily included lump sum benefit payments associated with the company 2019s u.s .supplemental pension plan .the company recognizes pension settlements when payments from the supplemental plan exceed the sum of service and interest cost components of net periodic pension cost associated with this plan for the fiscal year. .

Question: what was the average pension service cost from 2016 to 2018 in millions
Answer: 109
page 15 of 100 shareholder return performance the line graph below compares the annual percentage change in ball corporation 2019s cumulative total shareholder return on its common stock with the cumulative total return of the dow jones containers & packaging index and the s&p composite 500 stock index for the five-year period ended december 31 , 2010 .it assumes $ 100 was invested on december 31 , 2005 , and that all dividends were reinvested .the dow jones containers & packaging index total return has been weighted by market capitalization .total return analysis .
[['', '12/31/05', '12/31/06', '12/31/07', '12/31/08', '12/31/09', '12/31/10'], ['ball corporation', '$ 100.00', '$ 110.86', '$ 115.36', '$ 107.58', '$ 134.96', '$ 178.93'], ['dj containers & packaging index', '$ 100.00', '$ 112.09', '$ 119.63', '$ 75.00', '$ 105.34', '$ 123.56'], ['s&p 500 index', '$ 100.00', '$ 115.80', '$ 122.16', '$ 76.96', '$ 97.33', '$ 111.99'], ['copyright a9 2011 standard & poor 2019s a division of the mcgraw-hill companies inc . all rights reserved . ( www.researchdatagroup.com/s&p.htm )', 'copyright a9 2011 standard & poor 2019s a division of the mcgraw-hill companies inc . all rights reserved . ( www.researchdatagroup.com/s&p.htm )', 'copyright a9 2011 standard & poor 2019s a division of the mcgraw-hill companies inc . all rights reserved . ( www.researchdatagroup.com/s&p.htm )', 'copyright a9 2011 standard & poor 2019s a division of the mcgraw-hill companies inc . all rights reserved . ( www.researchdatagroup.com/s&p.htm )', 'copyright a9 2011 standard & poor 2019s a division of the mcgraw-hill companies inc . all rights reserved . ( www.researchdatagroup.com/s&p.htm )', 'copyright a9 2011 standard & poor 2019s a division of the mcgraw-hill companies inc . all rights reserved . ( www.researchdatagroup.com/s&p.htm )', 'copyright a9 2011 standard & poor 2019s a division of the mcgraw-hill companies inc . all rights reserved . ( www.researchdatagroup.com/s&p.htm )'], ['copyright a9 2011 dow jones & company . all rights reserved .', 'copyright a9 2011 dow jones & company . all rights reserved .', 'copyright a9 2011 dow jones & company . all rights reserved .', 'copyright a9 2011 dow jones & company . all rights reserved .', 'copyright a9 2011 dow jones & company . all rights reserved .', 'copyright a9 2011 dow jones & company . all rights reserved .', 'copyright a9 2011 dow jones & company . all rights reserved .']]
.

Question: what was the difference in percentage cumulative total shareholder return for ball corporation compared to the s&p 500 index for the five year period ending 12/31/10?
Answer: 66.94
future regulatory developments future regulatory developments and actions could affect operations and increase operating costs for the airline industry , including our airline subsidiaries .see part i , item 1a .risk factors - " if we are unable to obtain and maintain adequate facilities and infrastructure throughout our system and , at some airports , adequate slots , we may be unable to operate our existing flight schedule and to expand or change our route network in the future , which may have a material adverse impact on our operations ," "our business is subject to extensive government regulation , which may result in increases in our costs , disruptions to our operations , limits on our operating flexibility , reductions in the demand for air travel , and competitive disadvantages" and "we are subject to many forms of environmental regulation and may incur substantial costs as a result" for additional information .employees and labor relations the airline business is labor intensive .in 2013 , salaries , wages , and benefits were one of our largest expenses and represented approximately 22% ( 22 % ) of our operating expenses .the table below presents our approximate number of active full-time equivalent employees as of december 31 , 2013 .american us airways wholly-owned regional carriers total .
[['', 'american', 'us airways', 'wholly-owned regional carriers', 'total'], ['pilots', '7900', '4100', '3400', '15400'], ['flight attendants', '15000', '7700', '2100', '24800'], ['maintenance personnel', '11300', '3100', '2400', '16800'], ['fleet service personnel', '7400', '5500', '1700', '14600'], ['passenger service personnel', '10300', '6200', '6400', '22900'], ['administrative and other', '8200', '5500', '2200', '15900'], ['total', '60100', '32100', '18200', '110400']]
.

Question: what is the ratio of the total flight attendants to pilots
Answer: 1.62
Explanation: based on the ratio it means there is 1.62 flight attendants for every pilot
performance graph the annual changes for the period shown november 18 , 2013 ( when our ordinary shares began trading in the "when-issued" market ) to december 31 , 2016 in the graph on this page are based on the assumption that $ 100 had been invested in allegion plc ordinary shares , the standard & poor 2019s 500 stock index ( "s&p 500" ) and the standard & poor's 400 capital goods index ( "s&p 400 capital goods" ) on november 18 , 2013 , and that all quarterly dividends were reinvested .the total cumulative dollar returns shown on the graph represent the value that such investments would have had on december 31 , 2016 .november 18 , 2013 december 31 , 2013 december 31 , 2014 december 31 , 2015 december 31 , 2016 .
[['', 'november 18 2013', 'december 31 2013', 'december 31 2014', 'december 31 2015', 'december 31 2016'], ['allegion plc', '100.00', '91.16', '115.11', '137.71', '134.67'], ['s&p 500', '100.00', '103.44', '117.59', '119.22', '133.48'], ['s&p 400 capital goods', '100.00', '105.46', '105.72', '99.90', '131.80']]
.

Question: considering the year 2015 , what was the lowest return for the investment?
Answer: -0.1%
Explanation: it is the minimum value of the investment in that year .
five-year stock performance graph the graph below illustrates the cumulative total shareholder return on snap-on common stock since december 31 , 2007 , assuming that dividends were reinvested .the graph compares snap-on 2019s performance to that of the standard & poor 2019s 500 stock index ( 201cs&p 500 201d ) and a peer group .snap-on incorporated total shareholder return ( 1 ) fiscal year ended ( 2 ) snap-on incorporated peer group ( 3 ) s&p 500 .
[['fiscal year ended ( 2 )', 'snap-onincorporated', 'peer group ( 3 )', 's&p 500'], ['december 31 2007', '$ 100.00', '$ 100.00', '$ 100.00'], ['december 31 2008', '83.66', '66.15', '63.00'], ['december 31 2009', '93.20', '84.12', '79.67'], ['december 31 2010', '128.21', '112.02', '91.67'], ['december 31 2011', '117.47', '109.70', '93.61'], ['december 31 2012', '187.26', '129.00', '108.59']]
( 1 ) assumes $ 100 was invested on december 31 , 2007 , and that dividends were reinvested quarterly .( 2 ) the company's fiscal year ends on the saturday that is on or nearest to december 31 of each year ; for ease of calculation , the fiscal year end is assumed to be december 31 .( 3 ) the peer group consists of : stanley black & decker , inc. , danaher corporation , emerson electric co. , genuine parts company , newell rubbermaid inc. , pentair ltd. , spx corporation and w.w .grainger , inc .cooper industries plc , a former member of the peer group , was removed , as it was acquired by a larger , non-comparable company in 2012 .2012 annual report 23 snap-on incorporated peer group s&p 500 2007 2008 201120102009 2012 .

Question: what is the growth rate of snap's share price from 2007 to 2008?
Answer: -16.34%
entergy texas , inc .and subsidiaries management 2019s financial discussion and analysis results of operations net income 2016 compared to 2015 net income increased $ 37.9 million primarily due to lower other operation and maintenance expenses , the asset write-off of its receivable associated with the spindletop gas storage facility in 2015 , and higher net revenue .2015 compared to 2014 net income decreased $ 5.2 million primarily due to the asset write-off of its receivable associated with the spindletop gas storage facility and higher other operation and maintenance expenses , partially offset by higher net revenue and a lower effective tax rate .net revenue 2016 compared to 2015 net revenue consists of operating revenues net of : 1 ) fuel , fuel-related expenses , and gas purchased for resale , 2 ) purchased power expenses , and 3 ) other regulatory charges .following is an analysis of the change in net revenue comparing 2016 to 2015 .amount ( in millions ) .
[['', 'amount ( in millions )'], ['2015 net revenue', '$ 637.2'], ['reserve equalization', '14.3'], ['purchased power capacity', '12.4'], ['transmission revenue', '7.0'], ['retail electric price', '5.4'], ['net wholesale', '-27.8 ( 27.8 )'], ['other', '-4.3 ( 4.3 )'], ['2016 net revenue', '$ 644.2']]
the reserve equalization variance is primarily due to a reduction in reserve equalization expense primarily due to changes in the entergy system generation mix compared to the same period in 2015 as a result of the execution of a new purchased power agreement and entergy mississippi 2019s exit from the system agreement , each in november 2015 , and entergy texas 2019s exit from the system agreement in august 2016 .see note 2 to the financial statements for a discussion of the system agreement .the purchased power capacity variance is primarily due to decreased expenses due to the termination of the purchased power agreements between entergy louisiana and entergy texas in august 2016 , as well as capacity cost changes for ongoing purchased power capacity contracts .the transmission revenue variance is primarily due to an increase in attachment o rates charged by miso to transmission customers and a settlement of attachment o rates previously billed to transmission customers by miso. .

Question: was the change in net revenue from changes in transmission revenue more significant than the change due to the retail electric price change?
Answer: yes
in the ordinary course of business , based on our evaluations of certain geologic trends and prospective economics , we have allowed certain lease acreage to expire and may allow additional acreage to expire in the future .if production is not established or we take no other action to extend the terms of the leases , licenses or concessions , undeveloped acreage listed in the table below will expire over the next three years .we plan to continue the terms of certain of these licenses and concession areas or retain leases through operational or administrative actions ; however , the majority of the undeveloped acres associated with other africa as listed in the table below pertains to our licenses in ethiopia and kenya , for which we executed agreements in 2015 to sell .the kenya transaction closed in february 2016 and the ethiopia transaction is expected to close in the first quarter of 2016 .see item 8 .financial statements and supplementary data - note 5 to the consolidated financial statements for additional information about this disposition .net undeveloped acres expiring year ended december 31 .
[['( in thousands )', 'net undeveloped acres expiring year ended december 31 , 2016', 'net undeveloped acres expiring year ended december 31 , 2017', 'net undeveloped acres expiring year ended december 31 , 2018'], ['u.s .', '68', '89', '128'], ['e.g .', '2014', '92', '36'], ['other africa', '189', '4352', '854'], ['total africa', '189', '4444', '890'], ['other international', '2014', '2014', '2014'], ['total', '257', '4533', '1018']]
.

Question: for 2016 , what was the total african and us net undeveloped acres expiring , in thousands ? \\n
Answer: 257