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 5HR02 (AC3.2) Compare different approaches to retaining people
(Solution) CIPD Level 5 New AVADO_5HR01_24_06 5HR01 – Employment relationship management
(Solution) CIPD New 5CO03 Professional behaviours and valuing people Assessment ID / CIPD_5CO03_23_01
(Solution) New 5HR01 (AC3.3) Advise on the importance of handling grievances effectively
(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.