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) 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)
(Solution) CIPD Question 2: Evaluation of Individual and Team/Company-wide Contingency Pay Scheme
(Solution) CIPD 7C004 Task 2.3: Ethical Issues Connected with Project
(Solution) CIPS Negotiation Plan (PIN) Sustainable Water Solutions Company (SWS)
In this integrated assessment, the focus is to come up with a negotiation plan formalised which is applicable in Abu Dhabi Sustainable Water Solutions (ADSWS). The organisation operating in United Arab Emirates (UAE) water industry have different categories of spend which involve an active negotiation plan process. In order to achieve this report objective, a set of data and information has been sourced and used in developing the negotiation plan. The data and information is sourced by use of illustrations, data, desk research and peer reviewed sources for supporting implementation of negotiation. The spend area selected for this report is construction of sewer networks for enhancing the organisation operations in water management process. From the different projects being pursued by ADSWS, they are actively involved in sourcing for various construction of sewer networks. The key findings evidence that with UAE population increasing, the demand for construction of sewer networks has been on the rise. As a result, the key findings evidence organisations have been investing on expertise support, embracing terms and conditions, detailed planning and optimisation of supply chain network and PS&M organisation.
From the analysis, the key findings evidence ADSWS as pursuing a set of negotiations which are guided by the application of different CIPS Models strategy. The CIPS guidance evidence negotiation strategy as involving preparing, evaluating, proposing, negotiating settling issues and closure. Considering these stages involve immense resources being embraced, there is a need for involving multiple stakeholders for successful negotiation process. Also, the findings in this report elaborately evidence need to involve multiple stakeholders for success in negotiation strategy. There is a need for managing the leverage on the water sector of operstion through effective negotiation process. In this report, an emphasis has been put on need to customise the negotiation process for aligning different stakeholders needs and expectation. The findings evidence tis a being relevant for managing BATNA, MLA and different conflict which come from varying interests of engaged parties in the negotiation process. The rationale of this is that success in negotiation has a critical importance for the organisation survival.
From these findings and eventual conclusions generated, various recommendations have been generated including;
- To successfully implement detailed preparations in negotiation strategy for ensuring entire stakeholders offer their interests and priority in negotiation
- A successful embrace of innovativeness and technologies in negotiation plan strategy
- Ensuring custom-made negotiation process in multiple spend areas as opposed to a general negotiation process
- To enhance effective documentation of negotiation process with any disagreements in negotiation plan successfully