-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) 5OS04 Question 8 (AC 3.2) features of people management in a typical Japanese company employing professional staff
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPD AVADO New 5HR03- Reward for Performance and Contribution
Original price was: £ 15.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPD 5C002 (AC2.2) Present key findings for stakeholders from people practice activities and initiatives
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPS ADNOC Cohort 15 Practitioner PSE Sourcing Essentials
Original price was: £ 50.00.£ 10.00Current price is: £ 10.00.
- In summary, in this report, sourcing approaches have been evaluated.
- By focusing on ADNOC fuel main category of spend and other spend categories, the sourcing approaches have been identified to include multiple, single, dual, and sole.
- In ADNOC, the procurement process includes a detailed process that is defined by the transitioning of sourced products and services to the organisation.
- The identified spend categories are strategic, leverage, bottleneck, and non-critical items. Also, the products have been categorised into those with high-profit implications, risks incurred, and reliable.
- In the identified area of spend, multiple sourcing is preferred due to the critical nature of the identified spend category.
(Solution) New CIPD Level 5 5C002: Evidence-based Practice
Original price was: £ 70.00.£ 10.00Current price is: £ 10.00.
(Solution) 7HR02 Question 1 External and Internal Factors Shaping Organisation’s Resourcing and Talent Strategy
Original price was: £ 15.00.£ 10.00Current price is: £ 10.00.