Rolls-Royce Turbine Engines. Rolls-Royce is struggling with its pricing strategy with a number of its major customers in Continental Europe, particularly Airbus. Since Rolls-Royce is a British company with most manufacturing of the Airbus engines in the United Kingdom, costs are predominantly denominated in British pounds. But in the period shown in the popup window.2.20072009, the pound steadily weakened against the euro. Rolls-Royce has traditionally denominated , its sales contracts with Airbus in Airbus home currency, the euro. After completing the table answer the following questions: a. Assuming each Rolls-Royce engine marketed to Airbus is initially priced at E22.83 million each, how has the price of that engine changed over the period shown when priced in euros at the current spot rate? b. Complete the table in the popup window, B. What is the cumulative percentage change in the price of the engine in euros for the two-year period? c. If the price elasticity of demand for Rolls-Royce turbine sales to Airbus is relatively inelastic, and the price of the engine in British pounds never changes over the period, what does this price change mean for Rolls-Royce's total sales revenue on sales to Airbus of this engine? d. Compare the prices and volumes for the first quarter of each of the three years shown in the table in part b above. Who has benefitted the most from the exchange rate changes? a. Compute the sales prices per unit of engine in euros for the three-year period in the following table: (Round to two decimal places.) Date 29 2007 4Q 2007 1Q 2008 20 2008 1Q 2007 22.83 1.4918 22.83 Price (millions of pounds, ) Spot rate (euro = 1.00 pound) Price (millions of euros, ) 22.83 3Q 2007 22.83 1.4893 le 22.83 1.4113 22.83 1.3185 1.4714 1.2805 34.06 E Date 3Q 2008 20 2009 4Q 2009 49 2008 22.83 E 10 2009 22.83 3Q 2009 22.83 22.83 22.83 Price (millions of pounds, ) Spot rate (euro = 1.00 pound) Price (millions of euros, ) 22.83 1.2556 1.1949 1.1044 1.1368 1.1487 1.1092 ] e two-year period? Data table - MAIN TABLE Data table TABLE FOR TB Date 1Q 2007 2Q 2007 3Q 2007 4Q 2007 1Q 2008 2Q 2008 22.83 22.83 22.83 22.83 22.83 22.83 Date 1Q 2007 1Q 2008 1Q 2009 % Chg Price (millions of pounds, ) Spot rate (euro = 1.00 pound) 1.4918 1.4714 1.4693 1.4113 1.3185 1.2605 22.83 22.83 22.83 % Price (millions of euros, ) Price (in millions of pounds, ) Spot rate (/) 34.06 1.4918 1.3185 1.1044 34.06 30.10 25.21 % Date 3Q 2008 4Q 2008 1Q 2009 2Q 2009 3Q 2009 4Q 2009 Price (in millions of euros, ) Sales volume (engines) 200 220 240 20.00 % 22.83 22.83 22.83 22.83 22.83 22.83 Price (millions of pounds, ) Spot rate (euro = 1.00 pound) Total cost to Airbus (millions of ) 6,812 6,622 6,050 % 1.2556 1.1949 1.1044 1.1368 1.1487 1.1092 Total revenue to RR (millions of ) 4,566 5,023 5,479 % Price (millions of euros, ) Print Done Print Done