Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

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

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

Discussion Question: Scenario: Imagine a healthcare organization planning to implement a new patient management system to improve operational efficiency. Without proper project management processes,

Discussion Question: Scenario: Imagine a healthcare organization planning to implement a new patient management system to improve operational efficiency. Without proper project management processes, the team may face issues such as unclear goals, budget overruns, and delays. However, with a strategic approach, the project manager ensures the system aligns with

Discussion Question: A growing IT company, TechSolutions, decided to relocate to a larger office space to accommodate its expanding team. The project involved finding a new location, designing the wor

Discussion Question: A growing IT company, TechSolutions, decided to relocate to a larger office space to accommodate its expanding team. The project involved finding a new location, designing the workspace, and ensuring a smooth transition with minimal disruption to operations. Questions: What challenges might arise during an office relocation project,

Discussion ABC Construction Ltd. launched a traditional project to build a shopping mall in a growing urban area, planned for 18 months with a $75 million budget. The project followed a structured wat

Discussion ABC Construction Ltd. launched a traditional project to build a shopping mall in a growing urban area, planned for 18 months with a $75 million budget. The project followed a structured waterfall approach, starting with scoping, where architects, engineers, and investors outlined design, capacity, and regulatory requirements. In the

Purpose In this assignment, you’ll dive into a case study of successful team collaborations to understand what made them work well and the challenges they faced. Your task is to pick a specific projec

Purpose In this assignment, you’ll dive into a case study of successful team collaborations to understand what made them work well and the challenges they faced. Your task is to pick a specific project scenario, analyze its team dynamics, and come up with strategies to boost teamwork. You also need

Purpose The goal of this Unit 2 Individual Assignment is to build on your Unit 1 Individual Assignment by assessing how your emotional intelligence supports or augments your leadership style. This ass

Purpose The goal of this Unit 2 Individual Assignment is to build on your Unit 1 Individual Assignment by assessing how your emotional intelligence supports or augments your leadership style. This assignment will also facilitate your Unit 2 Team Assignment where you will compare each other’s leadership styles and abilities

links are provided The goal of this individual assignment is to give you a sense of your own leadership style and reflect on how you might enhance your leadership skills and performance. Understa

links are provided  The goal of this individual assignment is to give you a sense of your own leadership style and reflect on how you might enhance your leadership skills and performance. Understanding and reflecting on your leadership style is integral to your personal and professional development. It continues to

This assignment will enable you to use EXCEL functions to perform calculations associated with selecting projects based on various factors and criteria, some or all of which could be financial measure

This assignment will enable you to use EXCEL functions to perform calculations associated with selecting projects based on various factors and criteria, some or all of which could be financial measures like net present value, internal rate of return, payback period, etc. You will need to understand the examples on

For this journal, review the following statement, “Salespeople are born and not made.” Do you believe this statement to be true? Why, or why not?How has personal selling evolved? Your journal sho

For this journal, review the following statement, “Salespeople are born and not made.” Do you believe this statement to be true? Why, or why not? How has personal selling evolved? Your journal should consist of a minimum of three well-constructed paragraphs. Sources used, if any, should be listed and formatted

Unit 5 Journal ~ JOURNAL CAHME Competency Reflection Instructions This reflection helps you deepen your understanding of a specific course competency by connecting it to a relevant learning experience

Unit 5 Journal ~ JOURNAL CAHME Competency Reflection Instructions This reflection helps you deepen your understanding of a specific course competency by connecting it to a relevant learning experience from this course. For reference on how your program and courses align with the competencies, please consult the MHCA Program Mapping

10-1 MBA 699Report: After-Action Review MBA 699 Module Ten Report Guidelines and RubricOverview Congratulations! The board of directors agreed to the sale of the organization. However, you have just

10-1 MBA 699Report: After-Action Review  MBA 699 Module Ten Report Guidelines and RubricOverview Congratulations! The board of directors agreed to the sale of the organization. However, you have just been notified that the primary buyer has withdrawn from the sale. After much negotiation, the alternative buyer you identified has acquired

10-2 MBA699 Journal: Personal Action Plan MBA 699 Module Ten Journal Guidelines and RubricOverview In Module One, you performed a personal SWOT analysis and reflected on your readiness for organizati

10-2 MBA699  Journal: Personal Action Plan MBA 699 Module Ten Journal Guidelines and RubricOverview In Module One, you performed a personal SWOT analysis and reflected on your readiness for organizational change. Then, throughout the course, you learned to lead and manage organizational change based on strategic decisions. You have also

Describe intelligence-led policing, contrasting it with community policing and problem-oriented policing. Please ensure to include a minimum of 250 words in your initial response and provide two or mo

Describe intelligence-led policing, contrasting it with community policing and problem-oriented policing. Please ensure to include a minimum of 250 words in your initial response and provide two or more scholarly sources in APA 7th edition with VALID URL sources and in text citations to support your response. 

MBA 699 Module Eight Memo Guidelines and RubricOverview You are a part of the strategic planning team. Your team will communicate the analysis and recommendations in a compelling report for the board

MBA 699 Module Eight Memo Guidelines and RubricOverview You are a part of the strategic planning team. Your team will communicate the analysis and recommendations in a compelling report for the board of directors. The report will also outline a change management strategy. To measure the success of your change

Discussion Imagine you are facilitating a board meeting for the real or fictional company that you selected for your weekly assignments. The board has gathered to hear specific insights regarding D&am

Discussion Imagine you are facilitating a board meeting for the real or fictional company that you selected for your weekly assignments. The board has gathered to hear specific insights regarding D&O insurance. Describe the ethical guidelines surrounding this process for your industry. How can the company use industry norms for

Discussion By now you have seen how complex and nuanced Enterprise Risk Management (ERM) is in both nature and operational execution. Read the article, Beyond good intentions: Navigating the ethical d

Discussion By now you have seen how complex and nuanced Enterprise Risk Management (ERM) is in both nature and operational execution. Read the article, Beyond good intentions: Navigating the ethical dilemmas facing the technology industry, and discuss the following questions: How can technology companies use ERM to overcome the ethical dilemmas