-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) (AC2.3) Evaluate the strengths and weaknesses of different methods of recruitment and selection to build effective workforces.
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.
(Solution) ICS Learn CIPD Level 5 Talent Management and Workforce Planning (5HR02)
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPS PSE NUPCO Sourcing Essentials
Original price was: £ 50.00.£ 10.00Current price is: £ 10.00.
- In this analysis, we compared four sourcing strategies used by the NUPCO organization for their IT spending. According to these sourcing strategies, we have evaluated prospective IT providers.
- It has been found that NUPCO's IT spend category is best served by a multi-source procurement strategy. It was decided that the solitary, dual, and multiple sourcing discussion should occur elsewhere.
- The Kraljic analysis tool's conclusions about the leveraged nature of the supplier relationship and IT procurement's technical and quality requirements led to the adoption of this approach.
- Carter's 10Cs methodology will be used to identify an IT provider.
(Solution) CIPS Advanced Level Final Project Proposal
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPD 7OS05: Managing People in an International Context
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
(Solution) Oakwood Level 5 5HR01 Employment relationship management Assessment ID / CIPD_5HR01_22_01
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.