-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) CIPS Oman Cohort PSE Sourcing Essentials
Original price was: £ 50.00.£ 10.00Current price is: £ 10.00.
- This assessment has focused on identifying four sourcing approaches and explaining their application in the category of spend within XXX organisation.
- Based on the different categories selected in sourcing approaches, IT category of spend supplier appraisal has been conducted.
- Through a detailed evaluation, the sourcing approaches identified include multiple, single, dual, and sole.
- For the IT category of spend, multiple sourcing has been selected as the most suitable due to the procurement nature.
- In the Kraljic analysis tool identifying the nature of supplier relationships, IT has been classified as a leverage item.
- The availability of different suppliers in procurement is identified as a multiple sourcing approach.
- A single, dual or sole supplier is not suitable for IT procurement due to its technical and quality specifications required.
- Carter’s 10Cs model has been selected for XXX IT sourcing supplier selection in the supplier selection.
(Solution) 5CO01 (AC1.1) Evaluate the advantages and disadvantages of different types of organisation structures, including the reasons underpinning them
Original price was: £ 20.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
(Solution) Market Research and Analytics ABS BBA in Marketing
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
(Solution) 5C003 Professional Behaviours and Valuing People Assessment
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPD 5HR03 Task Two – Report Section Two
Original price was: £ 40.00.£ 10.00Current price is: £ 10.00.