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 5HR03 contribution of extrinsic and intrinsic rewards to improving employee contribution and sustained organisational performance. (AC 1.5)
(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.
(Solution) CIPD 5C002 (AC1.2) Evaluate a range of analysis tools and methods including how they can be applied to diagnose organisational issues, challenges and opportunities
(Solution) 7C003 Demonstrate curiosity and passion for deep learning
(Solution) Oakwood International 5CO03 Task One –Professional and ethical behaviours
Task One –Professional and ethical behaviours
This task requires you to consider the significance of professional and ethical behaviours for a people practitioner and the values that underpin the people practice profession. To complete the task, you should provide a written response to each of questions below, making appropriate use of academic theory and practical examples to expand your response and illustrate key points.- With reference to typical activities and behaviours, appraise what it means to be a ‘people professional’. (AC 1.1)
- Discuss how ethical values underpin the work of a people professional, including two examples of how ethical values might be applied in a people practice context. (AC 1.2)
- Consider the importance of people professionals being able to influence others and ensure that the ‘people practice voice’ is heard in an organisation, through informed, clear and confident communication. (AC 1.3)
- For each of the situations below (a & b), provide an example of an issue that would cause you to raise the matter to a manager (or other authority) - and describe how you would do this.
- a) where you consider something to be unethical (whether or not it is illegal),
- b) where you believe something contravenes legislation. (AC 1.4)
- Discuss two theories or models relating to the human and business benefits of people at work feeling included, valued, and fairly treated, concluding your discussion with a summary of your own view of these benefits. (AC 2.1)
- Discuss two ways in which a people professional can build inclusivity into a people practice initiative at the design stage, and two ways of checking inclusivity after a people practice initiative is implemented. (AC 2.2)