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, 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 22.24 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 1Q 2007 2Q 2007 3Q 2007 4Q 2007 1Q 2008 2Q 2008 22.24 22.24 22.24 22.24 22.24 22.24 Price (millions of pounds, ) Spot rate (euro = 1.00 pound) Price (millions of euros, ) = 1.4929 1.4738 1.4657 1.4135 1.3155 1.2613 33.20 Date 3Q 2008 4Q 2008 1Q 2009 2Q 2009 3Q 2009 4Q 2009 22.24 22.24 22.24 22.24 22.24 22.24 Price (millions of pounds, ) Spot rate (euro = 1.00 pound) Price (millions of euros, ) = 037 .1465 1. Date 1Q 2007 2Q 2007 3Q 2007 4Q 2007 1Q 2008 2Q 2008 22.24 22.24 22.24 22.24 22.24 22.24 Price (millions of pounds, ) Spot rate (euro = 1.00 pound) = 1.4929 1.4738 1.4657 1.4135 1.3155 1.2613 Price (millions of euros, ) 33.20 Date 3Q 2008 4Q 2008 1Q 2009 2Q 2009 3Q 2009 4Q 2009 22.24 22.24 22.24 22.24 22.24 22.24 Price (millions of pounds, ) Spot rate (euro = 1.00 pound) 1.2594 1.1924 1.1037 1.1377 1.1465 1.1066 Price (millions of euros, ) Date 1Q 2007 1Q 2008 1Q 2009 % Chg 22.24 22.24 22.24 % Price (in millions of pounds, ) Spot rate (/) 1.4929 1.3155 1.1037 33.20 29.26 24.55 % Price (in millions of euros, ) Sales volume (engines) 200 220 240 20.00 % Total cost to Airbus (millions of ) 6,640 6,437 5,892 % Total revenue to RR (millions of ) 4,448 4,893 5,338 %