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) Assessment ID / CIPD_5HR01_22_01 5HR01 Employment relationship management
(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 3 3CO04 Essentials of people practice Assessment ID / CIPD_3CO04_23_01
(Solution) CIPS Advanced Final Project Module 6 – Project, Programme and Change Management in Procurement & Supply
This project aim was evaluation of introduction of 3D printing in the spare parts supply chain in ADNOC in UAE. The importance of working on this report is guided by view that ADNOC is working to embrace automation of their supply chain particularly in the category of spare parts sourcing. Hence, for a successful sourcing, investments in 3D printing is identified as core for success in their operations. This is since 3D printing and other forms of automation are increasingly being adopted in different organisations supply chains locally in UAE and internationally. For the importance of investing in 3D printing, the findings of this report evidence the required results to entail;
- ADNOC success owing to remodelling of PS&M strategy, confident and capacity of spare parts sourcing, talent management and staff competency
- Improved relations with entire stakeholders (as explained in stakeholders matrix) improving overall organisation operations. 3-D printing would be an improvement from the current iSourcing hence success in technical and commercial-based evaluation
- Enhance an improvement and robust system and policy development to manage any potential gap in PS&M transformation
- Today, lower than 10% of ADNOC PS&M would be aligned to implementation of 3D printing and other modernisation strategies appropriate for the organisation
- Ensure development of new systems and policies which are appropriate for enhancing the current and future implementation of 3D printing and more modernised systems as a progress of their modernisation
- There is a necessity for successfully adopting 3D printing starting with their spare parts sourcing
- By collaborating with UAE government which owns 70% of the ADNOC shares, more revenues would be provided for the organisation successful operations.
- ADNOC engaging all the stakeholders holistically by understanding their interests and expectations
- There is a need to collaborate with government in UAE and other regulators for the sake of improving the suppliers relations
- By collaborating with institutions, they would successfully offer employees learning opportunities
- Adoption of strategic sourcing as part of ADNOC sourcing of 3D printing in spare parts sourcing