416859 8/25/1997 328530 8/26/1997 580230 8/27/1997 557912 8/28/1997 470345 8/29/1997 506073 8/30/1997 $5,000.00 Finance & Accounts...

 

 

 

Transcribed Image Text:

416859 8/25/1997 328530 8/26/1997 580230 8/27/1997 557912 8/28/1997 470345 8/29/1997 506073 8/30/1997 $5,000.00 Finance & Accounts HR & Facilities 1 HR & Facilities 3 3 $57,000.00 $2,000.00 $0.00 $61,000.00 $2,000.00 $0.00 $61,000.00 $2,000.00 $0.00 HR & Facilities 3 HR & Facilities 4 $61,000.00 $2,000.00 $0.00 $61,000.00 $2,000.00 $0.00 IT 3 Essential Employee $75,000.00 $2,000.00 440265 8/31/1997 IT 3 $75,000.00 $2,000.00 $5,000.00 468069 9/1/1997 IT 3 $75,000.00 $2,000.00 $5,000.00 374957 9/2/1997 IT $75,000.00 $2,000.00 $5,000.00 513536 9/3/1997 Logistics 3 $62,000.00 $2,000.00 $0.00 460143 9/7/1987 Logistics 3 $62,000.00 $2,000.00 $0.00 589832 9/8/1987 $0.00 Logistics 3 Essential Employee $62,000.00 $2,000.00 4238179/9/1987 $0.00 Logistics 4 Above performance. $62,000.00 $2,000.00 513076 9/10/1987 Management 2 $370,834.00 $0.00 $0.00 390362 9/11/1987 Management 3 $247,324.00 $0.00 $0.00 378723 9/12/1987 Management 3 $237,385.00 $0.00 $0.00 444407 9/13/1987 328698 9/14/1987 $0.00 Management 4 $245,048.00 $0.00 $0.00 Manufacturing 1 Essential Employee $46,000.00 $2,000.00 364811 9/15/1987 Manufacturing 2 $42,000.00 $2,000.00 $0.00 446576 9/16/1987 Manufacturing 3 $48,000.00 $2,000.00 $0.00 374689 9/17/1987 Manufacturing 3 $48,000.00 $2,000.00 $0.00 575866 9/18/1987 Manufacturing 3 $48,000.00 $2,000.00 $0.00 336426 9/19/1987 604892 9/20/1987 397725 9/21/1987 $2,700.00 Manufacturing 3 $48,000.00 $2,000.00 $0.00 Manufacturing 3 $48,000.00 $2,000.00 $0.00 Manufacturing 3 Great job. $42,000.00 $2,000.00 Company leaders need to keep a watchful eye on the economy and how micro- and macro- environments affect their business. Successful leaders are always a step ahead. They stay there by leading with data-driven decisions that allow their companies to anticipate and respond to challenges. In this module, you've learned how information is key in making decisions and solving problems; however, research and analytical skills are also needed to extract value from data. Information-gathering should align with research objectives. Qualitative and quantitative data alongside relevant and credible primary and secondary sources are fundamental ingredients for informing good judgement. Prompt In a report by the U.S. Department of Commerce, the U.S. economy contracted at an annual rate of 4.8% in the first quarter of this year. For this assignment, you will take on the role of an HR manager at an air transportation supply company. The company is currently struggling with a significant loss of revenue and considering operational costs. You have been asked to analyze employee performance over the last year and make sense of the data. Using a summary (provided below) of the company's employee salaries, bonuses, and performance data, address the following rubric criteria: Interpretation: Discuss your interpretation of the data. What questions emerge from your analysis of the data? What story can they tell about the company's employees? Analysis: Explain how the provided data helps you understand your employees and how the company is using its financial resources. Identify potential gaps or issues in the data. What is the quantitative and qualitative data telling you? Are there any underlying issues or perspectives? What is the data not telling you? What additional primary and secondary sources would help the company make a decision? Conclusion and related outcomes: Describe how you have used data to determine a strategy. Use evidence to support your explanations. What would your strategy be if you were asked to recommend a 10% reduction in the budget? How would you synthesize and defend your decision process? This resource will assist you as you complete your paper. Air Transportation Supplier HR Performance Data Spreadsheet. This summary table of your company's HR performance data will inform your work on this assignment. EMPLOYEE ID DATE OF HIRE DEPARTMENT PERFORMANCE SCORE (1-4) MANAGER COMMENTARY SALARY BONUS OVERTIME 485607 8/6/1987 Account Planning 1 $48,200.00 $2,000.00 $0.00 393786 8/7/1987 Account Planning 3 $48,200.00 $2,000.00 $0.00 355232 8/8/1987 Account Planning 3 420444 8/9/1987 380553 8/10/1987 $2,000.00 Account Planning 3 $48,200.00 $48,200.00 $2,000.00 $2,000.00 $0.00 $0.00 Account Planning 3 Essential Employee $48,200.00 $0.00 427151 8/11/1987 547926 8/12/1987 Account Planning 3 $48,200.00 $2,000.00 $0.00 Account Planning 3 $48,200.00 $2,000.00 $0.00 417193 8/13/1987 509063 8/14/1987 $2,000.00 Account Planning 3 Account Service1 $0.00 $48,200.00 $2,000.00 $0.00 Needs motivation. Issues with manager.$42,000.00 435359 8/15/1987 512184 8/16/1987 438389 8/17/1987 443122 8/15/1997 397561 8/16/1997 Account Service 2 $42,000.00 $2,000.00 $0.00 Account Service 2 Account Service 3 $45,000.00 $2,000.00 $0.00 $42,000.00 $2,000.00 $0.00 Account Service 3 $42,000.00 $2,000.00 $0.00 555048 8/17/1997 Account Service 3 Account Service 3 $42,000.00 $2,000.00 $0.00 $42,000.00 $2,000.00 $0.00 453271 8/18/1997 Account Service 3 $42,000.00 $2,000.00 $0.00 464630 8/19/1997 Account Service 3 $45,000.00 $2,000.00 $0.00 519760 8/20/1997 442969 8/21/1997 580205 8/22/1997 432466 8/23/1997 462316 8/24/1997 Account Service 3 Account Service 3 $45,000.00 $2,000.00 $0.00 $45,000.00 $2,000.00 $0.00 Finance & Accounts Finance & Accounts Finance & Accounts 1 $57,000.00 $2,000.00 $0.00 3 $57,000.00 $2,000.00 $0.00 3 $57,000.00 $2,000.00 $0.00 564463 9/22/1987 424162 9/23/1987 385138 9/24/1987 502794 9/25/1987 568130 9/26/1987 $0.00 Manufacturing 3 Manufacturing 3 Manufacturing 3 Manufacturing 3 Manufacturing 3 $42,000.00 $2,000.00 $2,700.00 $42,000.00 $2,000.00 $2,700.00 $42,000.00 $2,000.00 $2,700.00 $42,000.00 $2,000.00 $0.00 Essential Employee $42,000.00 $2,000.00 605566 9/27/1987 Manufacturing 3 $46,000.00 $2,000.00 $0.00 328667 9/28/1987 Manufacturing 3 $46,000.00 $2,000.00 $0.00 467513 9/29/1987 Manufacturing 3 $46,000.00 $2,000.00 $0.00 4360009/30/1987 Manufacturing 3 $46,000.00 $2,000.00 $0.00 454819 9/29/1992 Manufacturing 3 $46,000.00 $2,000.00 $0.00 545925 9/30/1992 $2,000.00 Manufacturing 4 Never late. Hardworking employee. $48,000.00 $0.00 340158 10/1/1992 Manufacturing 4 $42,000.00 $2,000.00 $2,700.00 612983 10/2/1992 Research 3 Trying hard. $55,000.00 $2,000.00 $0.00 456221 10/3/1992 Research 3 $55,000.00 $2,000.00 $0.00 457949 10/4/1992 Research 3 $55,000.00 $2,000.00 $0.00 592862 10/5/1992 $0.00 Research 3 Essential Employee $55,000.00 $2,000.00 492087 10/6/1992 Sales 2 $55,000.00 $2,000.00 $0.00 350488 10/7/1992 Sales 2 $77,000.00 $2,000.00 $0.00 490196 10/8/1992 Sales 3 $55,000.00 $2,000.00 $1,100.00 561413 10/9/1992 Team leader. $55,000.00 Sales 3 $2,000.00 $1,100.00 383332 10/10/1992 321027 10/11/1992 Sales 3 Sales 3 $55,000.00 $2,000.00 $1,100.00 $55,000.00 $2,000.00 $0.00 598755 10/14/1987 Sales 3 326815 10/15/1987 Sales 3 $55,000.00 $77,000.00 $2,000.00 $0.00 $2,000.00 $0.00 483908 10/16/1987 Sales 4 Essential Employee $55,000.00 $2,000.00 $1,100.00 374331 10/17/1987 Web Development 3 $75,000.00 $2,000.00 $0.00 576190 10/18/1987 Web Development 3 $75,000.00 $2,000.00 $0.00 535048 10/19/1987 Web Development 3 $75,000.00 $2,000.00 $0.00 478733 10/20/1987 Web Development 3 $75,000.00 $2,000.00 $0.00 510395 10/21/1987 Web Development 3 $75,000.00 $2,000.00 $0.00 416859 8/25/1997 328530 8/26/1997 580230 8/27/1997 557912 8/28/1997 470345 8/29/1997 506073 8/30/1997 $5,000.00 Finance & Accounts HR & Facilities 1 HR & Facilities 3 3 $57,000.00 $2,000.00 $0.00 $61,000.00 $2,000.00 $0.00 $61,000.00 $2,000.00 $0.00 HR & Facilities 3 HR & Facilities 4 $61,000.00 $2,000.00 $0.00 $61,000.00 $2,000.00 $0.00 IT 3 Essential Employee $75,000.00 $2,000.00 440265 8/31/1997 IT 3 $75,000.00 $2,000.00 $5,000.00 468069 9/1/1997 IT 3 $75,000.00 $2,000.00 $5,000.00 374957 9/2/1997 IT $75,000.00 $2,000.00 $5,000.00 513536 9/3/1997 Logistics 3 $62,000.00 $2,000.00 $0.00 460143 9/7/1987 Logistics 3 $62,000.00 $2,000.00 $0.00 589832 9/8/1987 $0.00 Logistics 3 Essential Employee $62,000.00 $2,000.00 4238179/9/1987 $0.00 Logistics 4 Above performance. $62,000.00 $2,000.00 513076 9/10/1987 Management 2 $370,834.00 $0.00 $0.00 390362 9/11/1987 Management 3 $247,324.00 $0.00 $0.00 378723 9/12/1987 Management 3 $237,385.00 $0.00 $0.00 444407 9/13/1987 328698 9/14/1987 $0.00 Management 4 $245,048.00 $0.00 $0.00 Manufacturing 1 Essential Employee $46,000.00 $2,000.00 364811 9/15/1987 Manufacturing 2 $42,000.00 $2,000.00 $0.00 446576 9/16/1987 Manufacturing 3 $48,000.00 $2,000.00 $0.00 374689 9/17/1987 Manufacturing 3 $48,000.00 $2,000.00 $0.00 575866 9/18/1987 Manufacturing 3 $48,000.00 $2,000.00 $0.00 336426 9/19/1987 604892 9/20/1987 397725 9/21/1987 $2,700.00 Manufacturing 3 $48,000.00 $2,000.00 $0.00 Manufacturing 3 $48,000.00 $2,000.00 $0.00 Manufacturing 3 Great job. $42,000.00 $2,000.00 Company leaders need to keep a watchful eye on the economy and how micro- and macro- environments affect their business. Successful leaders are always a step ahead. They stay there by leading with data-driven decisions that allow their companies to anticipate and respond to challenges. In this module, you've learned how information is key in making decisions and solving problems; however, research and analytical skills are also needed to extract value from data. Information-gathering should align with research objectives. Qualitative and quantitative data alongside relevant and credible primary and secondary sources are fundamental ingredients for informing good judgement. Prompt In a report by the U.S. Department of Commerce, the U.S. economy contracted at an annual rate of 4.8% in the first quarter of this year. For this assignment, you will take on the role of an HR manager at an air transportation supply company. The company is currently struggling with a significant loss of revenue and considering operational costs. You have been asked to analyze employee performance over the last year and make sense of the data. Using a summary (provided below) of the company's employee salaries, bonuses, and performance data, address the following rubric criteria: Interpretation: Discuss your interpretation of the data. What questions emerge from your analysis of the data? What story can they tell about the company's employees? Analysis: Explain how the provided data helps you understand your employees and how the company is using its financial resources. Identify potential gaps or issues in the data. What is the quantitative and qualitative data telling you? Are there any underlying issues or perspectives? What is the data not telling you? What additional primary and secondary sources would help the company make a decision? Conclusion and related outcomes: Describe how you have used data to determine a strategy. Use evidence to support your explanations. What would your strategy be if you were asked to recommend a 10% reduction in the budget? How would you synthesize and defend your decision process? This resource will assist you as you complete your paper. Air Transportation Supplier HR Performance Data Spreadsheet. This summary table of your company's HR performance data will inform your work on this assignment. EMPLOYEE ID DATE OF HIRE DEPARTMENT PERFORMANCE SCORE (1-4) MANAGER COMMENTARY SALARY BONUS OVERTIME 485607 8/6/1987 Account Planning 1 $48,200.00 $2,000.00 $0.00 393786 8/7/1987 Account Planning 3 $48,200.00 $2,000.00 $0.00 355232 8/8/1987 Account Planning 3 420444 8/9/1987 380553 8/10/1987 $2,000.00 Account Planning 3 $48,200.00 $48,200.00 $2,000.00 $2,000.00 $0.00 $0.00 Account Planning 3 Essential Employee $48,200.00 $0.00 427151 8/11/1987 547926 8/12/1987 Account Planning 3 $48,200.00 $2,000.00 $0.00 Account Planning 3 $48,200.00 $2,000.00 $0.00 417193 8/13/1987 509063 8/14/1987 $2,000.00 Account Planning 3 Account Service1 $0.00 $48,200.00 $2,000.00 $0.00 Needs motivation. Issues with manager.$42,000.00 435359 8/15/1987 512184 8/16/1987 438389 8/17/1987 443122 8/15/1997 397561 8/16/1997 Account Service 2 $42,000.00 $2,000.00 $0.00 Account Service 2 Account Service 3 $45,000.00 $2,000.00 $0.00 $42,000.00 $2,000.00 $0.00 Account Service 3 $42,000.00 $2,000.00 $0.00 555048 8/17/1997 Account Service 3 Account Service 3 $42,000.00 $2,000.00 $0.00 $42,000.00 $2,000.00 $0.00 453271 8/18/1997 Account Service 3 $42,000.00 $2,000.00 $0.00 464630 8/19/1997 Account Service 3 $45,000.00 $2,000.00 $0.00 519760 8/20/1997 442969 8/21/1997 580205 8/22/1997 432466 8/23/1997 462316 8/24/1997 Account Service 3 Account Service 3 $45,000.00 $2,000.00 $0.00 $45,000.00 $2,000.00 $0.00 Finance & Accounts Finance & Accounts Finance & Accounts 1 $57,000.00 $2,000.00 $0.00 3 $57,000.00 $2,000.00 $0.00 3 $57,000.00 $2,000.00 $0.00 564463 9/22/1987 424162 9/23/1987 385138 9/24/1987 502794 9/25/1987 568130 9/26/1987 $0.00 Manufacturing 3 Manufacturing 3 Manufacturing 3 Manufacturing 3 Manufacturing 3 $42,000.00 $2,000.00 $2,700.00 $42,000.00 $2,000.00 $2,700.00 $42,000.00 $2,000.00 $2,700.00 $42,000.00 $2,000.00 $0.00 Essential Employee $42,000.00 $2,000.00 605566 9/27/1987 Manufacturing 3 $46,000.00 $2,000.00 $0.00 328667 9/28/1987 Manufacturing 3 $46,000.00 $2,000.00 $0.00 467513 9/29/1987 Manufacturing 3 $46,000.00 $2,000.00 $0.00 4360009/30/1987 Manufacturing 3 $46,000.00 $2,000.00 $0.00 454819 9/29/1992 Manufacturing 3 $46,000.00 $2,000.00 $0.00 545925 9/30/1992 $2,000.00 Manufacturing 4 Never late. Hardworking employee. $48,000.00 $0.00 340158 10/1/1992 Manufacturing 4 $42,000.00 $2,000.00 $2,700.00 612983 10/2/1992 Research 3 Trying hard. $55,000.00 $2,000.00 $0.00 456221 10/3/1992 Research 3 $55,000.00 $2,000.00 $0.00 457949 10/4/1992 Research 3 $55,000.00 $2,000.00 $0.00 592862 10/5/1992 $0.00 Research 3 Essential Employee $55,000.00 $2,000.00 492087 10/6/1992 Sales 2 $55,000.00 $2,000.00 $0.00 350488 10/7/1992 Sales 2 $77,000.00 $2,000.00 $0.00 490196 10/8/1992 Sales 3 $55,000.00 $2,000.00 $1,100.00 561413 10/9/1992 Team leader. $55,000.00 Sales 3 $2,000.00 $1,100.00 383332 10/10/1992 321027 10/11/1992 Sales 3 Sales 3 $55,000.00 $2,000.00 $1,100.00 $55,000.00 $2,000.00 $0.00 598755 10/14/1987 Sales 3 326815 10/15/1987 Sales 3 $55,000.00 $77,000.00 $2,000.00 $0.00 $2,000.00 $0.00 483908 10/16/1987 Sales 4 Essential Employee $55,000.00 $2,000.00 $1,100.00 374331 10/17/1987 Web Development 3 $75,000.00 $2,000.00 $0.00 576190 10/18/1987 Web Development 3 $75,000.00 $2,000.00 $0.00 535048 10/19/1987 Web Development 3 $75,000.00 $2,000.00 $0.00 478733 10/20/1987 Web Development 3 $75,000.00 $2,000.00 $0.00 510395 10/21/1987 Web Development 3 $75,000.00 $2,000.00 $0.00