-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) (AC1.2) Explain the impact of changing labour market conditions on resourcing decisions
Original price was: £ 40.00.£ 10.00Current price is: £ 10.00.
(Solution) 5C003 Discuss, with examples, how you have, or would, achieve both of these (AC 2.2)
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.
Question 13 (AC 4.1) 7C002 partner formally with major customers or customer groups to evaluate and improve the performance of the people employed
Original price was: £ 15.00.£ 10.00Current price is: £ 10.00.
(Solution) Oakwood Assessment ID / CIPD_3CO04_24_01 3CO04 Essentials of people practice
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPS ADNOC Leadership and Management in Procurement and Supply
Original price was: £ 40.00.£ 10.00Current price is: £ 10.00.
- This assessment has delved on evaluation of impact of leadership and management approaches in an organisation.
- By evaluation XXX organisation operating in UAE oil and gas sector, the organisation successful project implementation is to increase their offshore oil and gas exploration to increase with upwards of 10,000 new exploration wells which demand a high-level leadership and management.
- This similarly highlight the positioning of XXX in UAE and international oil and gas industry.
- A set of tools including RACI, Leadership Matrix, Mendelow and RACI were adopted in sourcing this assessment findings.
(Solution) Breaking the Mold: Transformation at Sunmark Bank
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.