Please help me with all parts Problem 12-8 (algorithmic) Question Help Rolls-Royce Turbine Engines....
70.2K
Verified Solution
Link Copied!
Question
Finance
Please help me with all parts
Problem 12-8 (algorithmic) Question Help 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.52 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 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 Price (millions of pounds, ) 22.52 22.52 22.52 22.52 22.52 22.52 Spot rate (euro = 1.00 pound) 1.4926 1.4743 1.4697 1.4104 1.3186 1.2628 Price (millions of euros, ) 33.61 Date 3Q 2008 4Q 2008 1Q 2009 2Q 2009 3Q 2009 4Q 2009 Price (millions of pounds, ) 22.52 22.52 22.52 22.52 22.52 22.52 Spot rate (euro = 1.00 pound) 1.2554 1.1901 1.1027 1.1354 1.1498 Price (millions of euros, ) Data Table Data Table Date 1Q 2007 2Q 2007 3Q 2007 4Q 2007 1Q 2008 2Q 2008 Price (millions of pounds, ) 22.52 22.52 22.52 22.52 22.52 22.52 Date 1Q 2007 1Q 2008 1Q 2009 % Chg Spot rate (euro = 1.00 pound) 1.4926 1.4743 1.4697 1.4104 1.3186 1.2628 Price (in millions of pounds, ) 22.52 22.52 22.52 % Price (millions of euros, ) 33.61 Spot rate (/) 1.4926 1.3186 1.1027 Price (in millions of euros, ) 33.61 29.69 24.83 % Date 3Q 2008 4Q 2008 1Q 2009 2Q 2009 3Q 2009 4Q 2009 Sales volume (engines) 500 550 600 20.00 % Price (millions of pounds, ) 22.52 22.52 22.52 22.52 22.52 22.52 Total cost to Airbus (millions of ) 16,805 1.2554 16,330 % 14,898 Spot rate (euro = 1.00 pound) 1.1901 1.1027 1.1071 1.1354 1.1498 Total revenue to RR (millions of ) 11,260 12,386 13,512 % Price (millions of euros, ) Print Done Print Done Problem 12-8 (algorithmic) Question Help 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.52 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 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 Price (millions of pounds, ) 22.52 22.52 22.52 22.52 22.52 22.52 Spot rate (euro = 1.00 pound) 1.4926 1.4743 1.4697 1.4104 1.3186 1.2628 Price (millions of euros, ) 33.61 Date 3Q 2008 4Q 2008 1Q 2009 2Q 2009 3Q 2009 4Q 2009 Price (millions of pounds, ) 22.52 22.52 22.52 22.52 22.52 22.52 Spot rate (euro = 1.00 pound) 1.2554 1.1901 1.1027 1.1354 1.1498 Price (millions of euros, ) Data Table Data Table Date 1Q 2007 2Q 2007 3Q 2007 4Q 2007 1Q 2008 2Q 2008 Price (millions of pounds, ) 22.52 22.52 22.52 22.52 22.52 22.52 Date 1Q 2007 1Q 2008 1Q 2009 % Chg Spot rate (euro = 1.00 pound) 1.4926 1.4743 1.4697 1.4104 1.3186 1.2628 Price (in millions of pounds, ) 22.52 22.52 22.52 % Price (millions of euros, ) 33.61 Spot rate (/) 1.4926 1.3186 1.1027 Price (in millions of euros, ) 33.61 29.69 24.83 % Date 3Q 2008 4Q 2008 1Q 2009 2Q 2009 3Q 2009 4Q 2009 Sales volume (engines) 500 550 600 20.00 % Price (millions of pounds, ) 22.52 22.52 22.52 22.52 22.52 22.52 Total cost to Airbus (millions of ) 16,805 1.2554 16,330 % 14,898 Spot rate (euro = 1.00 pound) 1.1901 1.1027 1.1071 1.1354 1.1498 Total revenue to RR (millions of ) 11,260 12,386 13,512 % Price (millions of euros, ) Print Done Print Done
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!