HR ANALYTICSCOMPREHENSIVE ASSIGNMENTOBJECTIVE:Company ABC is struggling finding skilled trades and manual labour forces for their robotics company. Put together a recruitment and retention...

I don't need the whole assignment just a part of it.


HR ANALYTICS COMPREHENSIVE ASSIGNMENT OBJECTIVE: Company ABC is struggling finding skilled trades and manual labour forces for their robotics company. Put together a recruitment and retention business case based on the analytical data set provided REQUIRED CONTENT: 1. Select TWO study/papers that support your business case 2. Complete a professional business case report outlining your approach to both your recruitment and retention efforts. 3. References 4. Attached studies/paper 5. Provide your analytical analysis for at least 2 criteria’s (of all that you have learnt till )using the excel data sheet attached . 6. Work on the Excel spread sheet and attach the snap shot of your analysis OUTLINE OF ASSIGNMENT: Phase 1-Put together a business case on how Company ABC can increase staffing through recruitment in the above job areas (labourers & trade operators). Phase 2 -expand the business case to examine how the company will retain not only the newly hired employees but their already existing staff. Consider the following elements · Required Skill Sets (task-KSA(O)) · Competitive market analysis · Benefits · Pay Structure · Current employee tenure (regression analysis) · Current employee performance & satisfaction (chi-square analysis) · Etc. ADDITIONAL INFORMATION: Analytical Data SCORE 100 Points (20% of weight) SCORING/RUBRIC CATEGORY POINTS AVAILABLE POINTS SCORED COMMENTS Introduction Clear thesis of problem and objectives/goals 20 Study/Paper: Summarize and discuss relevance of article to support your business plan approach 20 Recruitment Plan Summarize plan and provided detailed data analysis to support your approach 20 Retention Plan Summarize plan and provided detailed data analysis to support your approach 20 Professionalism: Report presentation, organization, clarity, spelling, grammar, references 20 TOTAL 100 Employee Data PRODUCTION FLOOR DEPARTMENT Employee IDAgeJob TitleCompenstation AnnuallyBenefits Compensation AnnuallyYears of ServiceVacation (days)Satisfaction Survey (1-5)Interpersonal ConflictRole AmbiguityTurnover IntentionsBurnoutPerformance Score (1-10) E00156Supervisor642355364202523.33.54.22.48.95 E00242Trade Opeartor60284389651043.83.61.71.52.27 E00369Labourer46344268911053.33.44.44.02.82 E00436Labourer496323687101534.04.52.63.88.17 E00536Labourer40023456381533.74.81.23.81.00 E00658Supervisor510015101162024.03.53.33.58.12 E00726Labourer32000369531043.23.93.73.74.96 E00824Trade Opeartor49756269921052.33.54.11.64.36 E00940Labourer365354268121512.84.12.82.51.00 E01046Supervisor603764268121524.85.05.03.67.18 E01131Labourer38542396581232.02.91.42.85.63 E01228Labourer36561300131054.33.43.22.95.30 E01333Trade Opeartor44452296321043.34.34.43.13.32 E01457Trade Opeartor567605236172014.03.74.23.06.20 E01563Trade Opeartor556325368182024.05.03.82.68.53 E01658Labourer400834369141232.73.34.92.12.38 E01740Labourer32000389651043.83.64.92.51.00 E01849Trade Opeartor543374268121523.34.31.72.93.83 E01939Trade Opeartor523654368131523.03.92.93.49.24 E02047Labourer49855412091234.04.02.43.25.25 E02142Labourer46275412091233.73.22.82.62.13 E02236Labourer47313389651044.24.42.24.23.85 E02329Trade Opeartor50220300131054.83.54.54.06.46 E02426Manager59122296321043.03.44.93.36.68 E02546Supervisor584814268121513.84.04.63.15.00 E02657Trade Opeartor498565101162022.73.33.41.73.08 E02762Trade Opeartor47194396861043.53.01.72.57.15 E02852Labourer39055375841043.03.81.11.07.18 E02957Labourer502364210101533.03.44.32.55.06 E03023Supervisor48977268911052.72.91.22.13.39 E03127Trade Opeartor41785300131042.53.03.12.18.42 E03238Trade Opeartor50593412091233.53.53.42.27.77 E03346Supervisor632145368182013.23.43.03.12.58 E03449Supervisor612685101162023.03.23.24.64.55 E03550Trade Opeartor48563396861253.22.52.82.84.50 E03653Trade Opeartor544333687101535.05.04.33.44.34 E03748Labourer482643756111533.33.52.02.17.20 E03833Labourer39394300131044.74.13.13.88.23 E03965Supervisor596995368182022.01.91.41.04.05 E04044Supervisor563845101162022.82.62.12.52.77 E04152Manager635985426192013.73.91.74.08.10 E04222Labourer46344268911053.84.72.83.36.11 E04338Labourer496323687101532.33.14.51.03.17 E04434Labourer40023456381532.83.94.03.27.85 E04554Supervisor510015101162023.23.41.73.57.61 E04630Labourer32000369531043.54.44.63.15.88 E04730Trade Opeartor49756269921052.73.73.42.26.13 E04826Labourer365354268121513.23.61.41.07.86 E04952Supervisor603764268121522.21.73.62.26.32 E05037Labourer38542396581234.53.92.54.24.25 E05125Labourer36561300131053.22.93.02.44.68 E05235Trade Opeartor44452296321043.54.14.13.22.62 E05358Trade Opeartor567605236172013.84.64.53.77.34 E05461Trade Opeartor556325368182023.23.72.41.05.00 E05542Labourer400834369141233.03.21.94.53.08 E05632Labourer32000389651043.74.03.12.07.15 E05741Trade Opeartor543374268121524.03.42.44.27.18 E05841Trade Opeartor523654368131524.53.31.62.85.06 E05935Labourer49855412091234.03.23.63.53.39 E06039Labourer46275412091233.24.54.74.58.42 E06130Labourer47313389651042.53.53.72.47.77 E06229Trade Opeartor50220300131053.03.13.63.32.58 E06325Manager59122296321042.83.92.93.14.55 E06450Supervisor584814268121515.05.03.35.04.50 E06559Trade Opeartor498565101162022.33.22.81.84.34 E06646Trade Opeartor47194396861043.82.41.42.87.20 E06731Labourer39055375841042.73.91.11.68.23 E06836Labourer502364210101533.02.71.92.44.05 E06937Supervisor48977268911052.32.61.43.02.77 E07029Trade Opeartor41785300131043.54.72.33.78.10 E07145Trade Opeartor50593412091233.84.12.32.86.11 E07264Supervisor632145368182014.04.13.24.43.17 E07359Supervisor612685101162024.03.11.82.17.85 E07442Trade Opeartor48563396861253.54.04.53.07.61 E07553Trade Opeartor544333687101533.32.31.63.75.88 Company Data * All values in millions of CAD dollars ($)201920202021 Compensation Expenses (Base & Variable Pay):41.350.243.9 Pay-for-Performance Expenses:6.911.410.6 Benefits Expenses: 16.818.420.1 Total Operating Expenses:56.572.770.3 Total Revenue:103.3189.7190.9 Employees260.0301.0271.0 Departures/Turnover12.036.054.0