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) CIPS APCM – Advanced Practitioner Corporate Award
(Solution) 5HR03 (AC2.2) Explain how contingent rewards can impact individual, team and organisational performance
(Solution) CIPS Advanced level Leadership & Management in Procurement and Supply
- In summary, this report has focused on evaluating the impact of approaches to leadership and management in an organisation.
- To achieve this, a focus on Eco2Solar organisation has been prioritised where it has been established that the organisation current success in a project intended to achieve 2,000 installation in different apartments can be credited to their astute leadership and management.
- This equally evidence the organisation position dominating UK solar sector.
- These findings have been affirmed by PESTLE analysis of external factors, RACI Matrix among other tools which have been used.
(Solution) 5OS06 (AC3.3) Assess two specific business benefits that can accrue to organisations which invest in first-rate, up-to-date, evidence-led leadership and management development programmes
(Solution) CIPS ROSHN Sourcing Essentials- PSE
- In this report, the area of focus is on different sourcing approaches which can be used in procurement and supply management (PS&M) in contemporary business environment. This is through the focus of ROSHN organisation in Design Building category of spend.
- To achieve the intended aim of this report, data has been sourced from the organisation internal documents, different CIPS modules and models (Mendelow, STEEPLE and Kraljic). The key findings include ROSHN prefeed approach being multiple sourcing owing to the high-level of market competitiveness. This is with sole and single approaches preferred when only one supplier is being engaged owing to differences in organisation needs.
- Also, the findings evidence that single sourcing prevail in an event many suppliers are available, but an organisation decides to go for one. Another finding in this report is that dual sourcing is used when different methods/options for sourcing are embraced and put in place.
- Finally, through the application of supplier appraisal tool, focusing on the Design Building spend area, an evaluation has been put into account. The result from the appraisal using Carter’s 10C’s evidence organisation success to achieve value for money outcomes and improved market development.
- Internal and external analysis to identify most appropriate sourcing strategy
- Broad sourcing appraisal strategy need to be introduced
- Focus on managing successful sourcing strategy as part of organisation policy and practices
- Involve more stakeholders as part of their operations for success in sourcing strategy
- Pursuing capacity development initiatives for PS&M understanding of relevance of different PS&M