Reference no: EM132142854
Assignment: Excel Analysis
Instructions:
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
|
U.S.
|
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%
|
30%
|
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.
Assignment 2: Decision Analysis Toolkit
Instructions:
In this assignment, you will create a PowerPoint presentation that details a number of quantitative analysis methods and indicates how and when they should be used to solve business problems.
Requirements:
• Include an analysis of 10 different methods.
o At least four methods must not have been directly covered in the course.
For each analysis method include:
o A one slide description of the method and the type of problem it can be used to solve.
o An example of the method in use.
o 2-4 references describing the method and/or examples
Practical example
o invent a business problem, and briefly describe it in one slide
o create a simple decision tree to select the quantitative method used to evaluate it
o include a sample evaluation and recommendation for the business problem
List two strategies for consulting stakeholders
: List two strategies for consulting stakeholders about the vision and mission of the organization.
|
Define strengths and weaknesses in the delivery of services
: Critically analyse the strengths and weaknesses in the delivery of services to remote communities via face to face and virtual service models.
|
Different environments within an organization
: With respect to the different environments within an organization (certain, risk, or uncertain), why is it best for an organization to support both systematic o
|
Improved information system for organization
: Organizations change is the norm today. When designing a new or improved information system for an organization,
|
Create a simple decision tree to select quantitative method
: Create a PowerPoint presentation that details a number of quantitative analysis methods and indicates how and when they should be used to solve business problem
|
What value to your future career in business
: What value to your future career in business is supported by research, analysis and communication (writing and speaking)?
|
System development failures have been discussed
: System development failures have been discussed, written about, and held up as model of what not to do.
|
Manage the relationships between planning
: Within this complexity, what is a role that a manager may play in an effort to manage the relationships between planning, controlling, organizing, and leading?
|
Knowing-doing gap is one of the big challenges of strategy
: The "knowing-doing gap" is one of the big challenges of strategy.
|