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 7C004 Task 2.2 Justifying Research Methods
(Solution) 5C003 New (AC3.2) Assess your strengths, weaknesses and development areas based on self-assessment and feedback from others
(Solution) ACT501 MBA Financial and Managerial Accounting
(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