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, E, 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.87 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, E. 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 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.87 22.87 22.87 22.87 22.87 22.87 Price (millions of pounds, ) Spot rate (euro = 1.00 pound) Price (millions of euros, ) 1.4946 1.4742 1.4686 1.4143 1.3171 1.2647 34.18 Date 3Q 2008 4Q 2008 1Q 2009 2Q 2009 3Q 2009 4Q 2009 22.87 22.87 22.87 22.87 22.87 22.87 Price (millions of pounds, ) Spot rate (euro = 1.00 pound) Price (millions of euros, ) 1.2568 1.1912 1.1014 1.1398 1.1453 1.1083 Date 1Q 2007 2Q 2007 3Q 2007 4Q 2007 1Q 2008 2Q 2008 22.87 22.87 22.87 22.87 22.87 22.87 Price (millions of pounds, ) Spot rate (euro = 1.00 pound) Price (millions of euros, ) 1.4946 1.4742 1.4686 1.4143 1.3171 1.2647 34.18 Date 3Q 2008 4Q 2008 1Q 2009 2Q 2009 3Q 2009 4Q 2009 22.87 22.87 22.87 22.87 22.87 22.87 Price (millions of pounds, ) Spot rate (euro = 1.00 pound) Price (millions of euros, ) 1.2568 1.1912 1.1014 1.1398 1.1453 1.1083 Date 1Q 2007 1Q 2008 1Q 2009 % Chg 22.87 22.87 22.87 % 1.4946 1.3171 1.1014 Price (in millions of pounds, ) Spot rate (/) Price (in millions of euros, ) Sales volume (engines) Total cost to Airbus (millions of ) 34.18 30.12 25.19 % 500 550 600 20.00 % 17,090 16,566 15,114 % Total revenue to RR (millions of ) 11,435 12,579 13,722 % 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, E, 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.87 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, E. 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 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.87 22.87 22.87 22.87 22.87 22.87 Price (millions of pounds, ) Spot rate (euro = 1.00 pound) Price (millions of euros, ) 1.4946 1.4742 1.4686 1.4143 1.3171 1.2647 34.18 Date 3Q 2008 4Q 2008 1Q 2009 2Q 2009 3Q 2009 4Q 2009 22.87 22.87 22.87 22.87 22.87 22.87 Price (millions of pounds, ) Spot rate (euro = 1.00 pound) Price (millions of euros, ) 1.2568 1.1912 1.1014 1.1398 1.1453 1.1083 Date 1Q 2007 2Q 2007 3Q 2007 4Q 2007 1Q 2008 2Q 2008 22.87 22.87 22.87 22.87 22.87 22.87 Price (millions of pounds, ) Spot rate (euro = 1.00 pound) Price (millions of euros, ) 1.4946 1.4742 1.4686 1.4143 1.3171 1.2647 34.18 Date 3Q 2008 4Q 2008 1Q 2009 2Q 2009 3Q 2009 4Q 2009 22.87 22.87 22.87 22.87 22.87 22.87 Price (millions of pounds, ) Spot rate (euro = 1.00 pound) Price (millions of euros, ) 1.2568 1.1912 1.1014 1.1398 1.1453 1.1083 Date 1Q 2007 1Q 2008 1Q 2009 % Chg 22.87 22.87 22.87 % 1.4946 1.3171 1.1014 Price (in millions of pounds, ) Spot rate (/) Price (in millions of euros, ) Sales volume (engines) Total cost to Airbus (millions of ) 34.18 30.12 25.19 % 500 550 600 20.00 % 17,090 16,566 15,114 % Total revenue to RR (millions of ) 11,435 12,579 13,722 %