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 2: Evaluation of Individual and Team/Company-wide Contingency Pay Scheme
(Solution) CIPS Qatar Developing Contracts- PDC
This report has focused on the terms and conditions developed in QRC and their importance in sourcing noted. The terms and conditions identified are used in sourcing for secondment services by QRC as part of their operations in Qatar Railway sector.
The focus is on the success of the terms and conditions in ensuring risk of poor quality achieved, time extension, costs increase and unethical strategies.
Additionally, part of this research has focused on evaluating the performance measures monitoring process and management by use of terms and conditions which have been identified and summarised.
The different terms and conditions as evidenced in appendix section are detailed and holistic. This is with battle of the forms being embraced to come up with common agreement based on terms and conditions set.
The use of the identified terms and conditions in QRC are informed by need for use of various resources, ordering process, risks management and demands specified.
The main findings in this report highlight the different terms and conditions as holistic to ensure high-level quality services provided by QRC organisation.
This is at the same time making sure supply strategy is on-time and ethical sourcing pursued. This is in terms and conditions applied in resolving challenges with performance and monitoring success levels.
The key findings in this report similarly highlight that the different terms and conditions are used in resolving performance challenges owing to differences in their representation. This has been identified to be regarded as battle of the forms.
The main findings is that before the process of negotiation is initiated, it is essential to benchmark to identify their core differences.
The different findings in this report have been obtained by using different tools and techniques in line with the CIPS Module Notes. These key findings informed on the following recommendations;
- Broadening terms and conditions successfully
- Enhancing suppliers involvement in offering services for avoiding battle of the forms
- Terms and conditions integrating Qatar government laws and policies
- Benchmarking high performers in Qatar
- Improving experiences and knowledge of PS&M teams for terms and conditions successful management