-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 Assessment 3 PSE Sourcing Essentials
Original price was: £ 50.00.£ 10.00Current price is: £ 10.00.
- In summary, sourcing approaches has been evaluated in this assessment. This is through the focus of ADNOC organisation spend category.
- The selected spend category is IT for their advancement of remote and flexible working post-COVID-19 pandemic. Also, by comparing this with other different spend categories, the sourcing approaches evaluated included sole, multiple, single and dual sourcing.
- Through the application of different CIPS tools and techniques Kraljic analysis, Stakeholders analysis, SWOT and PESTLE analysis, a successful evaluation has been put into active process. This is with the best practice in ADNOC being identified and prioritised.
- Further, for the successful sourcing of ADNOC IT system, a successful suppliers appraisal process has been pursued.
- This has been done through the application of Cater’s 10C’s Model. As part of this analysis, the best supplier has been noted and involved.
(Solution) GE’s approach to innovation in the past
Original price was: £ 50.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPD Level 7 Strategic Employment Relations
Original price was: £ 40.00.£ 10.00Current price is: £ 10.00.
(Solution) Value Management (VM) and Risk ManagementIndividual Inquiry-based Report
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
(Solution) 5CO01 (AC2.1) Explain theories and models which examine organisational culture and human behaviour
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPS APGCE Supply Chain Analysis Methods
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.