Description
Solution
SECTION 2
1.4 Data Analysis
To calculate the percentage turnover for each department, I used the formula:
Turnover Percentage= (Total Employees/Leavers) ×100
2020
- Administration: 4/22×100=18.2%
- Maintenance: 5/9×100=55.6%
- Marketing: 0/4×100=0%
- Production: 70/231×100=30.3%
- People Team: 1/6×100=16.7%
- Research & Design: 1/4×100=25%
- Sales: 19/42×100=45.2%
- Packing & Dispatch: 21/36×100=58.3%
- Finance: 2/5×100=40%
2021
- Administration: 8/20×100=40%
- Maintenance: 3/8×100=37.5%
- Marketing: 0/4×100=0%
- Production: 3/2198×100=16.2%
- People Team: 0/6×100=0%
- Research & Design: 0/3×100=0%
- Sales: 3/35×100=8.6%
- Packing & Despatch: 6/15×100=40%
- Finance: 0/4×100=0%
2022
- Administration: 9/20×100=45%
- Maintenance: 3/8×100=37.5%
- Marketing: 1/4×100=25%
- Production: 3/8178×100=21.3%
- People Team: 3/6×100=50%
- Research & Design: 0/4×100=0%
- Sales: 0/40×100=0%
- Packing & Despatch: 8/16×100=50%
- Finance: 0/4×100=0%
2023
- Administration: 2/18×100=11.1%
- Maintenance: 1/7×100=14.3%
- Marketing: 0/4×100=0%
- Production: 29/181×100=16%
- People Team: 2/5×100=40%
- Research & Design: 1/4×100=25%
- Sales: 2/45×100=4.4%
- Packing & Despatch: 3/15×100=20%
- Finance: 0/3×100=0%
To calculate the overall turnover rate for the entire organization each year, we sum the total number of leavers and total employees, then apply the turnover formula:
Overall Turnover Percentage= (Total Employees/Total Leavers) ×100
2020:
- Total employees = 359
- Total leavers = 123
- Turnover: 123359×100=34.3%
2021:
- Total employees = 285
- Total leavers = 52
- Turnover: 52285×100=18.2%
2022:
- Total employees = 275
- Total leavers = 62
- Turnover: 62275×100=22.5%
2023:
- Total employees = 282
- Total leavers = 40
- Turnover: 40282×100=14.2%
Data Presentation
- Bar Graph-The following is the Bar Graph presenting the year-wise Turnover percentages of each department (2020-2023). It has a graphical display of the turnover rates by department making it less time consuming to determine departments with high or little turnover in the previous years.
Please click the following icon to access this assessment in full
Related Papers
(Solution) CIPD New 5HR03: Reward for Performance and Contribution
(Solution) CIPS Emirates Transport Company Strategic Supply Chain Management SSCM
- This assessment has focused on evaluating the supply chain map in Tyres spend category in ETC organisation.
- The relevance of this has been to enumerate the extent in which their supply chain is characterised by strengths and weaknesses as it influence the scope of the stakeholders interaction.
- Successful evaluation and eventual development of supply chain is core as it note on stakeholders visibility, ethical-best practice, risk management and costs reduction.
- Strengths identified to be associated with the 2-tier supply chain entail a high-level collaboration, cost reduction and managing time appropriately.
- ETC is found to gain from a high-level positioning in UAE Transport sector. This is with their innovation increasing since supply chain is integrated with technology use.
(Solution) CIPD Level 7 7HR02 Question 4 (AC 4.2) contemporary methods that utilise technology to manage both individual and team performance
(Solution) CIPD New 5HR02- Talent Management and Workforce Planning
(Solution) New 5CO01 Organisational performance and culture in practice Assessment ID / CIPD_5CO01_23_01
(Solution) CIPS ROSHN Module: Sourcing Essentials: PSE
Executive Summary
The goal of this evaluation was to compare and contrast various methods of sourcing. Various sourcing strategies have been assessed by centering on the ROSHN organization's Health and Safety Equipment (HS&E) expenditure category. Among these methods were sole, dual, multiple, and single sourcing. Various expenditure categories, including transportation, information technology, logistics, and employee uniforms, have been used to compare and contrast this. Tools such as the Mendelow Matrix analysis (for stakeholders), the Kraljic Analysis (for hazards), SWOT, and PESTLE (to determine if the market is oligopolistic or monopolistic) have been employed to carry out the analysis. The key findings evidence that ROSHN's sourcing strategies assist them successfully initiate projects which would lead to an increased house ownership in Saudi Arabia (KSA) as part of achieving their vision 2030. Further, the main findings evidence the multiple sourcing as involving many suppliers in an oligopolistic market, single one supplier with sole only one supplier available with dual involving two suppliers. Another key finding is that through the application of
been found by using the 10Cs model proposed by Carter, which focuses on technical and financial ratios among other things a strategic appraisal has been achieved. Managing the IT consultancy category is possible, according to ROSHN's study, because they've invested in the specified sourcing methods. With their varied and distinct applications in sourcing, each of the examined sourcing approaches has its own set of pros and cons.
From the findings and conclusions generated, various recommendations can be suggested which include;
• Formulate a plan for utilising various sourcing strategies according to their respective expenditure categories
• Make plans and procedures to include technology into their sourcing strategies.
• Simplify sourcing strategies while considering the needs of all parties involved.
• Enhance communication procedures as a means to measure the success of sourcing strategies.