Solve business problems with appropriate quantitative decision-making models
Marco shoe company would like to expand their shoe stores to other parts of the world. They currently operate in United States, Canada, Germany, France, Ireland and Spain. The company is now looking to open one additional store in the upcoming year and would like to calculate the risk and decide on where to open the new store. The risk in each location is different. Here is the chart of each of the current last year’s income.

CountryProfitabilityUnited States$120,000.00Canada  $80,000.00Germany  $20,000.00France$100,000.00Ireland  $35,000.00Spain  $85,000.00

The business analyst has evaluated the risk associated with opening another store in each country had has presented the probability of success for the next five years.
CountryYear OneYear TwoYear ThreeYear FourYear FiveUnited States 20%15%25%30%35%CAnada 15%20%22%25%30%Germany 40%45%50%55%60%France 35%40%45%50%55%Ireland 10%20%25%30%35%Spain 10%20%25%40%50%
Based on the information provided, create a table to show the potential profitability for each location for the next five years, then make your expansion selection. Please write a small summary of why this location was chosen for the expansion.