Crisis Management Final Assignment What is Required

The final assignment is based on the Marriott International Data Breach Case (2018) and is divided into two separate parts:

You are the CEO of the company and need to put in place a team and plan who deals with the following issues:

A total estimate of 1 billion dollars as overall costs.

Possible compensation for a new passport along with credit charges if fraud was committed (to be determined).

123 million Dollars in GDPR fines from the SEC.

Lost of 10% of satisfaction and trust within your clients.

Overall aim: Provide a full crisis management action plan which includes:

1. Crisis team in place with main duties/goals

2. Official response and PR strategy

3. Applying the dining rule create:

5 year Business Plan impact over the company to recover and mitigate the damage (see 2019 annual report as base).

Propose specific actions to recuperate customers and satisfaction.

IT immediate actions and future security structure.

READ:

https://stocklight.com/stocks/us/services/nasdaq-m…

https://www.nytimes.com/2018/11/30/business/marrio…

https://www.idstrong.com/sentinel/marriott-data-br…

WACHT:

the assessment need as below

1- Use Business Plan examples to project your P&L (attached as Marriot Case Final EXCEL-P&L 2023)

.2- POWER POINT to explain the above requests. submit your power point presentation following the assignement instructions and index

ATTACHMENTS

Chosen Business: Hilton Garden Inn by Hilton

Project Title:

360-Degree Market Analysis for Business Expansion

Project Focus:

This final project is an individual academic report for the International Business Strategy course.
The purpose of the project is to evaluate four potential foreign markets and recommend the best country for international expansion for a hospitality business.

For this project, I will focus on Hilton Garden Inn by Hilton, a well-known hospitality brand within the Hilton portfolio, and assess which country would be the most suitable destination for expansion.

---

Main Requirements

1. Introduction

In this section, I need to briefly introduce the chosen hospitality business.

This includes:

• The business profile / field of operation
• The main competitors / rivals
• The target audience
• The current headquarters (city and country)
• The motivation behind expansion
• A clear explanation of the problem or market gap that is not fully solved by competitors
• Mentioning a few existing alternatives in the market

My chosen business:

• Hilton Garden Inn by Hilton
• A globally recognized upper-midscale hotel brand
• Focused on business and leisure travelers
• Known for reliable service, modern comfort, and strong brand recognition

---

2. Expansion Routes and Market Analysis

This is the main analytical part of the project.

I need to compare 4 selected countries as potential markets for the expansion of Hilton Garden Inn.

The analysis must be based on 4 international rankings:

1. IMD World Competitiveness Ranking
2. Transparency International Corruption Perceptions Index (CPI)
3. World Bank Ease of Doing Business Ranking
4. WIPO Global Innovation Index

---

2.1 Overview of the Country Rankings

In this section, I must:

• Insert Table 1 with the raw ranking data for the 4 selected countries
• Use the 4 rankings above
• Present the actual positions / ranks for each country
• Add Figure 1 (bar chart) showing the distribution of countries by rankings
• Briefly explain the key observations

---

2.2 Presentation of the Normalized Rankings

In this section, I must:

• Insert Table 2 with the normalized ranking results
• Use the provided Excel template to apply the normalization method
• Make all ranking indicators comparable
• Briefly explain the observations after normalization

---

2.3 Final Ranking of the Destination Markets

In this section, I must:

• Insert Table 3 showing the weights assigned to the 4 rankings
• Make sure all weights add up to 1.00
• Explain why each ranking received its weight based on the business needs of Hilton Garden Inn
• Insert Table 4 with the final weighted results
• Multiply:
  • Normalized scores selected weights
• Calculate the Overall Ranking Score for each country
• Rank the countries from highest to lowest
• Identify the best country for expansion
• Provide a clear recommendation supported by logic and data
• Add Figure 2 (bar chart) showing the final ranking of countries

Also required in this section:

• Explain the comparative advantages of the recommended country
• Mention possible market limits / obstacles / risks for expansion in that country
• Support observations with in-text citations
  • Example: (Transparency International, 2024)

---

3. Conclusion

In the conclusion, I need to write a short paragraph that:

• Summarizes the findings
• Restates the most suitable country for expansion
• Explains whether the market entry is strategically attractive for Hilton Garden Inn
• Provides a final professional recommendation

---

4. References

I must include:

• A full reference list
• In alphabetical order
• Following APA 7th edition style
• All sources used in the report, including rankings, data sources, charts, and any external research

---

Important Notes

• The project must be completed individually
• The final submission must be uploaded as a PDF
• The Excel file is only for calculations and should not be submitted
• All charts, tables, and figures must include:
  • A title
  • A caption
  • A source
• The report should be written in a clear academic and professional style
• English quality is important, as part of the grade depends on the quality of written English

---

My Chosen Business for the Project

Hilton Garden Inn by Hilton

For this project, I will analyze the international expansion potential of Hilton Garden Inn, a hospitality brand under Hilton.
The goal is to identify the most suitable foreign market among four selected countries using a data-driven market ranking approach.

---

Short Academic Statement (Ready to Use)

If you want to mention your topic in one sentence, you can write:

This project will evaluate the international expansion potential of Hilton Garden Inn by Hilton by comparing four selected countries using key global business and market rankings in order to identify the most suitable destination for strategic expansion.

Hello,

Please read the attached images carefully.

1. Make a PowerPoint presentation about the first question exactly as written in the file:
   Organizational Culture Description according to one of the theories.
   Use Scheins model (Artifacts, Values, Beliefs/Basic Assumptions) and apply it to No.8 Kitchen & Take Away, Lucerne.

Restaurant information:

No.8 Kitchen & Take Away Lucerne, Switzerland

1. Add real photos of the restaurant and put a citation under each photo.
2. AI is strictly NOT allowed. Use your own words.
3. Add RGU references (similar to Harvard style).
4. Make two designs: one PowerPoint and one Canva.
   Please be very creative. I only need one or two slides, but they should look very creative.

Also prepare a short speech (about 2 minutes) to explain the slide.

DiscussionHR – Turnover Discussion

Turnover imposes massive hidden costs on food and beverage operations, often exceeding 100-200% of an employee’s annual salary when factoring direct and indirect losses. At master’s level, analyze these through financial modeling, HR metrics, and leadership frameworks like Collins’ Level 5 accountability to justify proactive retention strategies.

Direct Costs

Severing an employee triggers immediate expenses like recruitment advertising ($1,000-$5,000 per role), background checks, and agency fees (15-25% of salary). Training replacements consumes 200-300 hours for line cooks or servers, at $15-25/hour opportunity cost, while uniforms and onboarding kits add $500+. Front-of-house turnover disrupts scheduling, incurring overtime premiums (1.5x rate) during 4-6 week ramp-up periods.

Indirect Costs

Productivity dips 50-70% for new hires, inflating waste (e.g., 2-5% food cost overrun from errors) and comps (guest satisfaction scores drop 15-20%). Knowledge loss erodes menu consistencylosing a lead line cook means recipe deviations costing 3-8% margins. Team morale fractures, amplifying absenteeism (up 25%) and cross-training burdens, while guest loyalty erodes via inconsistent service (repeat visits fall 10-15%).

Cost Modelling Table

Position	Annual Salary	Turnover Cost (% of Salary)	Total Cost per Exit	Annual Impact (50% Turnover Rate, 20 Staff)
Dishwasher	$35,000	100-150%	$35k-$52k	$350k-$520k
Line Cook	$50,000	150-250%	$75k-$125k	$750k-$1.25M
Server	$45,000 + tips	120-200%	$54k-$90k	$540k-$900k
FOH Manager	$75,000	200-300%	$150k-$225k	$1.5M-$2.25M (fewer exits)
Total	–	–	–	$3.14M-$4.92M

Assumptions: U.S. urban F&B; data from HCI, Deloitte hospitality benchmarks.

Discussion Prompts

1. Quantify turnover ROI: If a 50-employee operation loses $4M annually, model break-even retention investment (e.g., $200k training vs. Danny Meyer’s HQ hiring). Link to Window/Mirrordoes crediting teams reduce exits?
2. Position-specific analysis: Why does sous-chef turnover ($100k+) exceed dishwasher ($40k), yet ops prioritize low-skill hires? Propose HQ rubrics for all levels.
3. Cultural linkage: Connect Northouse servant leadership (Ch. 10) to engagementhow does humility cut indirect costs like morale erosion?
4. Peer case: Share a team experience; calculate its cost using the table. What Level 5 intervention (window credit) prevents recurrence?
5. Strategic response: Design a $50k pilot (training + debriefs) targeting 20% turnover drop. Forecast P&L impact over 12 months.

7. Discussion

   Criteria	Ratings	Pts
   This criterion is linked to a Learning OutcomePost Sources	5 pts 0 pts	5 pts
   This criterion is linked to a Learning OutcomeWord count	10 pts 0 pts	10 pts
   This criterion is linked to a Learning OutcomeContent	10 pts 0 pts	10 pts
   This criterion is linked to a Learning OutcomeReply	5 pts 0 pts	5 pts
   This criterion is linked to a Learning OutcomeReply Source	5 pts 0 pts	5 pts
   This criterion is linked to a Learning OutcomeResponse ContentActivity such as reading, watching video, training	5 pts 0 pts	5 pts
   Total Points: 40

Part 1 (700 words)

700 words in paragraphs under headings and with your conclusion/solution.
Problem Analysis
Theory Application
Recommendations
Chef Example

Part 2 (550 words)
Copy the case study with your response (solution) in any AI.
Ask for the solutions in 150 words each from the top three (3) business consulting companies MBB McKinsey, Boston Consulting Group, Bain & Company.
Provide a short reflection (100 words) of your and the consulting companies findings, difference?
McKinsey (150 words)
Bain (150 words)
Boston Consulting Group (150 words)
Reflection (100 words)

Part 3
Then upload and submit your case study answer.

Real-Life Case Study: Danny Meyers Hospitality Quotient

What are your interpretation / view of David Meyers philosophy. Follow the above format / rubric.

Meyer developed HQ with Susan Salgado to hire for unteachable traits like empathy amid NYC competition. At Gramercy Tavern, it sustained loyalty despite father’s bankruptcy lessons. Apply to staffing: Rate candidates on optimism; role-play attribution in errors. Links to Collins via outward credit.

Dear Studypool Support Team,
I urgently require assistance from a qualified tutor with expertise in hotel financial modeling and hospitality investment analysis to review and solve my final project.
The project is part of my academic course in Hotel Real Estate Investment Strategy, and the assignment requires building a 10-year financial analysis in Excel including GOP, NOI, and IRR calculations based on the provided case study.
To simplify the information and clarify the correct calculation for the tutor, the correct room allocation should be calculated as follows based on the occupancy assumption:
Leisure Segment Number of Rooms: 250 Corporate Segment Number of Rooms: 125
This clarification is important to ensure the financial model and projections are calculated correctly.
I kindly request support from a specialized tutor to focus on solving the financial model accurately based on these room numbers and the data provided in the project instructions.
Your urgent support is highly appreciated as this assignment is very important for my academic progress.
Thank you.

Dear Studypool Support Team,

I urgently require assistance from a qualified tutor with expertise in hotel financial modeling and hospitality investment analysis to review and solve my final project.

The project is part of my academic course in Hotel Real Estate Investment Strategy, and the assignment requires building a 10-year financial analysis in Excel including GOP, NOI, and IRR calculations based on the provided case study.

To simplify the information and clarify the correct calculation for the tutor, the correct room allocation should be calculated as follows based on the occupancy assumption: