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 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
(Solution) CIPS Module Title Developing Contracts in Procurement and Supply- PDC
Executive Summary
The significance of the set of terms and conditions chosen from XXX organisation has been assessed in relation to its impact on the organisation. This pertains to the domains of potential hazards related to subpar quality, time delays, escalated expenses, and unethical conduct in effective administration. In addition, the monitoring and administration of essential performance measures have been taken into consideration by utilising the selected terms and conditions. The terms and conditions can be found in appendix 1 of this report. Ultimately, the concept of "battle of the forms" has been chosen as the most effective approach to reaching a mutual agreement that aligns with an organisation's own terms and conditions. The terms and conditions selected in XXX are utilised in the General Conditions of Purchase, which are standardised T&Cs employed in procuring services for the organization. This applies regardless of the quantity of resources utilised in the order, the associated risks, and the specific requirements.
The findings in this report demonstrate that their terms and conditions are successful in guaranteeing the provision of high-quality services to XXX. This involves improving the supply process in a timely manner while ensuring that ethical considerations are properly addressed. An optimal approach also includes utilising these terms and conditions to address performance concerns and assess progress. In order to address the issue of conflicting terms and conditions in the "battle of the forms," the terms and conditions of various suppliers are compared and analysed beforehand to ensure that they are aligned and consistent. In order to fulfill the desired objective of the report, many analytical methods such as the Mendelow Matrix, risk register, contract management cycle, and assessment of the value and impact of vulnerability and risks were employed, following the guidance provided by the CIPS Module Notes.
Based on the results and conclusions, several recommendations might be derived. These include:
- Expand the terms and conditions by adding additional clauses to make them more comprehensive.
- Verify that the suppliers selected have prior experience in providing comparable services to prevent battle of the forms.
- Include provisions in the terms and conditions that align with relevant KSA legislations to enhance their applicability.
- Conduct a benchmark analysis on top-performing organisations in the oil and energy industry in the KSA to enhance their terms and conditions
- Enhance the expertise of the PS&M teams to effectively manage the terms and conditions without encountering significant difficulties.