-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) CIPD Question 4: Using Job Evaluations for Determining Reward Decisions
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPD PWC 3COO2- Principles of Analytics
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.
(Solution) New Assessment ID / CIPD_5CO03_24_01 5CO03 Professional behaviours and valuing people
Original price was: £ 15.00.£ 10.00Current price is: £ 10.00.
Question 5 (AC2.1) 7C002 succession planning are elitist in character and inappropriate for use by organisations committed to equality, diversity and inclusion
Original price was: £ 15.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPS ADNOC Sourcing Essentials PSE
Original price was: £ 50.00.£ 10.00Current price is: £ 10.00.
- For the current report, the sourcing approaches identified and in-depth explained are informed by the ADNOC chemicals sourcing.
- In tandem with the different spend categories, different sourcing approaches for the spend have been applied with a supplier appraisal generated at the end.
- Through an in-depth analysis, sourcing strategies evaluating in areas of multiple, single, dual and sole. For procuring the chemicals, multiple sourcing is the best practice due to the procurement process characteristic.
- As evidenced from Kraljic analysis matrix, suppliers relations are noted with chemicals procurement being a leverage category.
- The Carter’s 10Cs model is applicable to pursue suppliers appraisal for chemicals sourcing supplier appraisal.
(Solution) 5C003 reasons why this is important and the consequences of people practitioners not being willing or able to influence others (AC 1.3)
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.