-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 Occidental of Oman Leadership & Management in Procurement and Supply
Original price was: £ 40.00.£ 10.00Current price is: £ 10.00.
- In conclusion, this assessment has evaluated leadership and management in procurement and supply in Occidental of Oman.
- The scope of this report include the leadership and management on organisational behaviour, leadership approaches on job satisfaction and sources of power in the organisation it relevance.
- Further, this assessment has focused on relevance of equality and diversity policies in Occidental of Oman company. There are different tools and techniques which have been used including PESTLE which note that the leadership and management are distinct meanings but interchangeably applied.
- Also, the models used in analysis evidence the concepts as influencing organisation behaviour. The findings evidence existence of stable and holistic leadership in the organisation.
(Solution) CIPD Oakwood International 5CO03 Professional behaviours and valuing people
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPD 7C002 Question 8: High Performance Work Practices Benefit Employers and Employees
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.
(Solution) 5CO02 (AC1.3) Explain the principles of critical thinking including how you apply these to your own and others’ ideas
Original price was: £ 40.00.£ 10.00Current price is: £ 10.00.
(Solution) 5CO03 strategies for designing and ensuring inclusive people practices
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPD 50S02 New Task 1- Written Response
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.