Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

CO3 - Solve business problems with appropriate quantitative decision-making models Marco shoe company would like to expand their shoe stores to other parts of the

  • CO3 - 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.

Country Profitability
United States $120,000.00
Canada $80,000.00
Germany $20,000.00
France $100,000.00
Ireland $35,000.00
Spain $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.

Country Year One Year Two Year Three Year Four Year Five
United 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, table to show the potential profitability for each location for the next five years, then make your expansion selection. Please small summary of why this location was chosen for the expansion. Based on the information provided submit an Excel document containing the following:

  • A table to show the potential profitability for each location for the next five years then make our expansion selection based on the information provided.
  • In the output table please show the yearly profitability and a total profitability for each country.
  • Below your solution output in excel please write a analysis of this location was chosen for the expansion.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management

Authors: Chuck Williams

4th Edition

978-0324316797, 0324316798

More Books

Students also viewed these General Management questions