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 5C002 (AC1.4) Explain a range of (2) decision-making processes
(Solution) Level 5 Assessment ID / CIPD_5HR01_24_015HR01 Employment relationship management
(Solution) CIPD 7HR03 Strategic Reward Management
(Solution) (AC4.1) Assess suitable types of contractual arrangements dependent on specific workforce need
Solution Permanent, full-time contracts Permanent, full-time contracts for delivery drivers offer both benefits and drawbacks, making their suitability dependent on ParcelCare’s operational needs and goals. Pros Permanent, full-time contracts provide job security and consistent income for delivery drivers, enhancing employee satisfaction and loyalty. This stability can lead to higher motivation and productivity, reducing turnover rates and the associated costs of recruitment and training as evidenced by Personio (2023). Full-time contracts also facilitate better workforce planning, ensuring ParcelCare has reliable staffing to meet delivery demands. Cons However, these contracts can be less flexible and more costly for the company. Full-time employees typically require benefits such as health insurance, paid leave, and retirement plans, increasing operational expenses. Additionally, the rigidity of permanent contracts may not align with fluctuating delivery volumes, leading to inefficiencies during low-demand periods. Suitability For ParcelCare, full-time contracts can be suitable if delivery volumes are consistently high, ensuring a stable workforce. However, a mixed model that includes part-time or flexible contracts might offer the necessary flexibility to adapt to changing demands while controlling costs. Part-Time Contracts Part-time contracts offer flexibility for delivery drivers, allowing them to balance work with other commitments. Drivers benefit from a stable income, albeit at reduced hours, while ParcelCare can adjust staffing levels according to demand. A significant advantage of part-time contracts is reduced costs associated with employee benefits, as part-time workers may not qualify for full benefits packages (Abogados, 2019). However, part-time drivers may lack the same commitment or availability as full-time employees, potentially impacting reliability and consistency. Zero-Hours Contracts Zero-hours contracts provide maximum flexibility, allowing ParcelCare to scale staffing up or down based on delivery demand without a fixed commitment to provide hours (CIPD, 2023c). For drivers, these contracts offer freedom to accept or decline work, appealing to those seeking flexibility. However, they also result in income uncertainty and lack of guaranteed hours, which can be challenging for drivers seeking stability. For ParcelCare, zero-hours contracts minimise costs during low-demand periods but may lead to difficulties in maintaining a loyal and consistent workforce due to potential driver dissatisfaction. Part-time contracts are most suitable for ParcelCare’s delivery drivers. They offer a stable income and consistent work schedule, which can enhance job satisfaction and reliability while allowing ParcelCare to adjust staffing levels as needed. This balance supports both operational needs and employee stability. Please click the following icon to access this assessment in full