Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Follow these steps to create a Big Mac Index. Use the Module Two Spreadsheet Task: Template and Worksheet to complete this task. Product Selection :
Follow these steps to create a "Big Mac Index." Use the Module Two Spreadsheet Task: Template and Worksheet to complete this task.
- Product Selection: Select a product. For example, if you like apples use apples.
- Price Research: Find prices for a selected product in five different countries around the world, apart from the United States. use the U.S. price as a base.
- Spreadsheet: Use the template to create a spreadsheet that compares the price of the selected product in USD to prices for the product in international markets. this partcan reference the website Global Cost of Living in the module resources.
- Currency Determination: Calculate the percentage difference in USD product price and the selected foreign market prices. Based on the product and calculation, is the currency undervalued or overvalued?
- Purchasing Power: How many minimum hourly wages in each of the five countries does it take to purchase the selected product? complete this part, refer to the webpage World Economic Forum - Minimum Wage Tracker.
- Summary: This short write-up should be done directly as a short paragraph in your Excel spreadsheet.
- What was learned from this exercise?
- Is the chosen product cheaper in the United States or in foreign markets?
- Did it find that, based on hourly salary, the product is more affordable in the United States? If not, which country had the most affordability?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started