-75%
(Solution) CIPD Avado SECTION 2 1.4 Data Analysis
New User Gifts
First Order Deal get Ksh 200 Off.
KaribuCustomer
Original price was: £ 40.00.£ 10.00Current price is: £ 10.00.
Payment Methods:
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) 5CO03 continuing professional development activities on own behaviour and performance
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
(Solution) New CIPD Assessment ID/CIPD_3CO02_23_01 Principles of analytics
Original price was: £ 40.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPD Level 5 Avado New 5CO02 Evidence-based practice
Original price was: £ 40.00.£ 10.00Current price is: £ 10.00.
(Solution) 7CO03 Learning Journal business acumen can deliver commercial benefits and manage resilience
Original price was: £ 40.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPS Advanced Final Project Module 6 – Project, Programme and Change Management in Procurement & Supply
Original price was: £ 40.00.£ 10.00Current price is: £ 10.00.
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