-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) 7CO03 Learning Plan Curiosity and passion for deep learning
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPS Advanced level Leadership & Management in Procurement and Supply
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
- In summary, this report has focused on evaluating the impact of approaches to leadership and management in an organisation.
- To achieve this, a focus on Eco2Solar organisation has been prioritised where it has been established that the organisation current success in a project intended to achieve 2,000 installation in different apartments can be credited to their astute leadership and management.
- This equally evidence the organisation position dominating UK solar sector.
- These findings have been affirmed by PESTLE analysis of external factors, RACI Matrix among other tools which have been used.
(Solution) 5C003 New (AC2.2) Discuss strategies for designing and ensuring inclusive people practices
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.
(Solution) New 5HR01 (AC1.1) Differentiate between employee involvement and employee participation and how they build relationships
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.
(Solution) AbbVie PART 1: Case Study Analysis
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPD 5HR03 principles of reward and its importance to organisational culture and performance management. (AC 1.1)
Original price was: £ 50.00.£ 10.00Current price is: £ 10.00.