-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 2024 5HR02 Talent management and workforce planning Assessment ID / CIPD_5HR02_22_01
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPS Category & Category Management in Procurement and Supply (PS&M)- APGM Occidental of Oman (Oxy)
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
Executive Summary
This is a business report which evaluate category and contract management using Occidental of Oman (Oxy) organisation in Oman. Specifically, the best practice in category management for harnessing project management and cost management effectiveness has been evaluated. Further, in this business report, entire requirements which guide initiation and readiness in category management, conventional-based sourcing strategies, contract management, techniques have been put into account. In this report, the findings evidence that Oxy organisation operates an effective risk management strategy in contract and category management. Further, to identify the PS&M members capacity development, they are well positioned in implementing their category management. This is with appropriate capacity development required for mitigating existing gaps in their practice. The findings similarly evidence Oxy PS&M as having been successful in sourcing the Health and Safety Equipment (HS&E). To enhance innovativeness in this area, the organisation capitalise on SLA’s and KPIs with auditing being essential for their practice. Further, through an effective use of data analytics, analysis and presenting contract management data and best management process. This enhance stakeholders collaboration and being aware of decision making promoting operations, input and suggestions made. Through stakeholders analysis, stakeholders relations are essential for maintaining stakeholder relations improving the Oxy image and overall market share.
In this report, there are identified gaps which need to be mitigated. These gaps would be managed by use of the following recommendations which are;
- Investing in blockchain technologies, cloud-based platform and L&D strategy for contract management strategy to improve entire stakeholders relationship
- Increasing budget assigned in their PS&M post-COVID pandemic economic recession
- Initiate an organisation team members to improve how they integrate and harmonise PS&M approach in the organisation
- Prioritising on increasing team-based working in their sourcing with entire vendors involved for achieving cost saving
- Engagement of various organisations to improve on skills, competency and acquiring relevant talents
- Approving budget intended to implement risk analysis for various potential risks faced
(Solution) Oakwood International 5CO02 Section One –Report
Original price was: £ 50.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPD Level 7 7OS06 Wellbeing at work
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.
(Solution) 5C003 New (AC3.1) Explore how the role of a people professional is evolving and the implications this has for continuing professional development
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPS Advanced Level Final Project Proposal
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.