Competencies In this project, you will demonstrate your mastery of the following competencies:

  

Competencies

In this project, you will demonstrate your mastery of the following competencies:

• Manage stakeholder relationships to sustain a competitive advantage
• Align and integrate a short-term goal with a strategic plan
• Create a change management strategy

Scenario

You are a business development manager reporting to the vice president (VP) of business development at one of the largest life sciences organizations in the Midwest. While the organization has shown constant growth and profitability since its inception in 1999, the owners have decided that it is time to sell. Given the current uncertainty in global markets, the organization’s board of directors is not convinced that this is the right approach.

While work was underway to find a potential buyer, the VP called on you to join the strategic planning team to assess the organization’s exit strategy and make recommendations to its board of directors. You have been working closely with your strategic planning team to make some initial analyses and recommendations to help plan for the sale of the organization.

As part of the planning team, your first task was to select people from your organization to build a guiding coalition to help the organization transition during and after the acquisition.

Then, you were asked to analyze one of the organization’s core strengths, its talented pool of employees. This included analyzing the attrition data to understand why employees have left the organization and recommending ways to ensure employee stability in the future. This essential information will be provided to potential acquirers to assure them of the organization’s ability to retain talent.

While planning was underway, your first potential buyer started to get cold feet. So, you were asked to research an alternative buyer and build a contingency plan. This contingency plan is an important part of your exit strategy and your report to the board of directors. You and your team were also asked to formulate an acquisition road map that lays out the action steps and timelines for the plan.

Now that the initial analysis and plans are complete, your VP is ready to make the presentation to the board of directors. The VP has asked you to prepare a formal report that you will send to the board prior to the presentation. This report will include the analyses and plans you have developed over the last few weeks. It is important to note that your report will provide a first impression to the board about the upcoming presentation and meeting. You need to craft a compelling message that provides insights based on all the work your team has done and substantiates your position with data. In addition, as a part of your report, you will also outline a change management strategy that will help ensure a smoother transition after the sale of the organization.

Directions

Write a merger integration report that includes your analyses and insights and provides a change management strategy for moving forward toward a sale of the organization in the course scenario. Compile your work from Milestones One, Two, and Three in your report. Remember to address and incorporate any feedback you may have received from your instructor on your milestone assignments.

Guiding coalition: Use the organizational chart and the employee personas provided to guide your selection of the guiding coalition for the organization in the scenario.

Specifically, you must address the following rubric criteria:

1. Recommendation: Use the organizational chart and the personas to identify people who should be part of the guiding coalition. Review the personas to identify the individuals who have the influence and commitment to make a positive impact while providing guidance for the change initiative.
2. Rationale: Justify your choice of guiding coalition team members. Your responses should address the following for each individual you recommend for the coalition:
   1. What is the person’s title and how many people do they manage?
   2. How long has each person been with the organization?
   3. What area(s) of the organization does this person influence?
   4. What is your rationale for choosing the person? Consider the person’s characteristics for your rationale.
   5. What role will each person fulfill as a member of the guiding coalition?
3. Team-building strategies: Describe activities and strategies you will introduce to build a well-functioning team. Your response should address the following:
   1. What strategies will help the members align with the change initiative of the organization in the scenario?
   2. What steps or actions will you take to establish a sense of urgency within the team?
   3. How do these activities and strategies help build trust?

Employee attrition analysis report: First, use the employee attrition data to create visuals in Tableau that capture the trends and possible reasons for retention and attrition in the organization. Then, write a report about the current state of human resources and attrition. Include screenshots from your visualizations to support your report. Remember to consider the employee’s employment status when visualizing and analyzing the data. The Status column in the spreadsheet indicates whether the employee is a current or former employee of the organization.

Specifically, you must address the following criteria:

1. Current employee demographics: Summarize the current employee demographics for the organization from the course scenario.
   1. Use Tableau to visualize the demographic data such as age, sex, marital status, and experience and include the corresponding screenshots in your summary. Choose the graphs or charts that that are best suited to represent the demographic data.
   2. Choose at least two different graph or chart types to represent the demographic data and include the corresponding screenshots in your written summary. Explain why you have selected the specific chart types to represent your data.
2. Attrition analysis : Analyze the given employee data to answer the following questions about attrition in the organization, including its causes and the relationship between attrition and various employment factors. Use Tableau to create a visual summary of the data and include the corresponding screenshots in your analysis. Choose the graphs or charts you believe are best suited to represent the required data.
   1. Identify the five top reasons for attrition.
   2. For those who left the organization, how many years had it been since their last promotion?
   3. At what age does an employee typically exit the organization?
   4. After how many years of employment does someone typically leave the company?
   5. What is the connection between how many times a year a person was trained, how long they stayed at the organization, and whether they have left?
3. Retention: Compare the attrition analysis data with your current employee details to evaluate and prevent future attrition. Your response should address the following:
   1. Using the trends from the attrition data identify if more current employees are likely to leave. Explain your findings.