Scenario You are a business development manager reporting to the vice president (VP) of business development at one of the largest life sciences

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.

You are working with the strategic planning team to assess the current data to make recommendations to its board of directors regarding the organization’s exit strategy. You have started creating your plan for the organizational change and selected members for the guiding coalition. Your next task is to help determine the value of the organization’s assets to the potential acquirer.

One of the core strengths of the organization lies in the value of its talent. Potential buyers in this industry want to know that the organization that they acquire is going to be able retain their valuable employees. So, the VP has asked you to analyze the human resource data in order to determine what the organization is worth. This includes taking a close look at the organization’s human resources, analyzing the attrition data, and making predictions about employee stability in case of an acquisition.

The organization has been collecting information about its employees since its inception in 1999; this information has been organized in a spreadsheet. In order to understand recent trends in your organization’s workforce, you will analyze this employee data. Your analysis will look at employee attrition and retention and will be included in your report. This will provide a clear picture of your organization’s workforce to help anticipate its perceived value with potential buyers.

Prompt

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 from the course scenario. 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.
  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 chart types that you believe are best suited to represent the required data.
  3. Retention: Compare the attrition analysis data with your current employee details to evaluate and prevent future attrition.
  4. Actionable steps: Based on findings from your retention analysis, provide three specific actions that the organization can take to prevent employees from leaving. Provide a rationale.

What to Submit

Submit a 5- to 6-page Word document using double spacing, 12-point Times New Roman font, and one-inch margins. Sources should be cited according to APA style. Consult the Shapiro Library APA Style Guide for more information on citations

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Module 4 – CaseManaging ChangeAssignment OverviewChange Management Rapid technology changes in workplaces can cause stress, prompting employees to resist

Module 4 – CaseManaging ChangeAssignment OverviewChange Management Rapid technology changes in workplaces can cause stress, prompting employees to resist adopting new tools. This resistance stems from fear of obsolescence, disrupted routines, and perceived tool complexity. Addressing these anxieties through effective communication and training is crucial for smooth technological transitions. **Complete

MBA 645 Module Two Communication Plan Guidelines and RubricOverview Stakeholders are individuals or groups that have an active interest in an

MBA 645 Module Two Communication Plan Guidelines and RubricOverview Stakeholders are individuals or groups that have an active interest in an organization. Stakeholders and stakeholder groups typically include employees, vendors, communities, government agencies, customers, investors, and lenders. Different stakeholders have different interests, attitudes, and priorities. Effective communication ensures that they

MBA 645 Module Two Communication Plan Guidelines and RubricOverview Stakeholders are individuals or groups that have an active interest in an

MBA 645 Module Two Communication Plan Guidelines and RubricOverview Stakeholders are individuals or groups that have an active interest in an organization. Stakeholders and stakeholder groups typically include employees, vendors, communities, government agencies, customers, investors, and lenders. Different stakeholders have different interests, attitudes, and priorities. Effective communication ensures that they

Module 3 – CaseResponsible LeadershipAssignment OverviewThe Diverse Workplace Cultural Intelligence (CQ) drives understanding across diverse backgrounds

Module 3 – CaseResponsible LeadershipAssignment OverviewThe Diverse Workplace Cultural Intelligence (CQ) drives understanding across diverse backgrounds and enhances workplace inclusion. Diversity brings varied perspectives, but challenges may arise from misunderstandings and biases. Inclusion, propelled by CQ, ensures diverse talents are harnessed, fostering innovation and collaboration despite inherent workplace challenges. Complete

Module 3 – SLPResponsible LeadershipAssignment OverviewCommunication Effective communication boosts productivity, fosters teamwork, reduces

Module 3 – SLPResponsible LeadershipAssignment OverviewCommunication Effective communication boosts productivity, fosters teamwork, reduces misunderstandings, drives employee engagement, and improves decision-making to build a successful workplace culture. **Complete SLP 3 before Case 3** Session Long Project 3 Resources 13 Strategies For Breaking Down Silos And Boosting Interdepartmental Communication (2023) How to Improve Cross-Functional