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 New Global Strategic Supply Chain Project
- The purpose of this project is to evaluate supply chain automation by leveraging Industry 4.0 technologies. The identified technologies include Artificial Intelligence (AI) and Machine Learning (ML) noted as critical for streamlining operations and obtaining value-for-money outcomes. This has been pursued by focusing on Wood Plc.
- To conclude, the generated findings of this report evidence WPC is today adopting the application of iSourcing in their procurement and supply management (PS&M).
- In the current project, through an evaluation of options for automation of the organization PS&M, the findings evidence the existence of different limitations hindering the success of their system. The issues of cost overruns, lack of collaboration, and inefficient supply chain as the organization is expanding its current operations have been noted to include limitations of their current sourcing.
- Success in the automation of their supply chain has been identified to lead to the following outcomes;
- Organisation achievement owing to automation of their supply chain, increased confidence and capability, talent management, and employee competency
- Improved stakeholders relations (a later section of stakeholders analysis) easing the change process. Through the iSourcing improvement, WPC would be in a position of harnessing technical and commercial evaluation processes.
- Increased and robust systems and policies which mitigate overall gaps in sourcing system transformation
- Today, only lower than 10% of the entire WPC resources are used to prioritize automation and IT integration successfully. Automation would improve the use of resources in their operations
- Involve their IT and finance departments to ensure within a period of 6 months they
- WPC needs to consider embracing sustainable practices as part of investing in their Industry 4.0 technologies
- Through the adoption of automation, better communication systems backed by AI and ML would be introduced to achieve 70% increased communication effectiveness.
- It is important to increase this through increasing collaboration and alignment of all their interests holistically
- Partnering with institutions for the provision of capacity development opportunities for the PS&M teams and other organizations for the success of the automation process
- Expanding their sourcing of Industry 4.0 technologies. This is to involve highly reputable global companies hence efficient operations and integration of AI
- Source of support from the government to ensure that they are facilitated in terms of policies and appropriate regulations to guide the automation process.
(Solution) CIPD 7C002 Question 8: High performance work practices
(Solution) 5CO01 (AC2.3) Explain different approaches to managing change
(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