Question: 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Economics Questions!