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 MER Developing Contracts
In summary, this report has focused on evaluation the selection criteria and sourcing strategies for enabling appropriate selection of suppliers for goods, services and works. Through a focus on Ericsson organisation different spend categories, a set of sourcing approaches have been identified. The approaches have been evaluated through the application of different tools and techniques. This is with different available data from Ericsson spend categories being evaluated in detail. Further, for the different approaches, the risk analysis and potential challenges impacting their implementation. The findings indicate that there is no one-size-fits all approach for selection criteria and sourcing strategies. The best practice is dependent on the organisation category of spend and suppliers availability.
A set of recommendations can be provided for successful formulation of selection criteria and sourcing strategies. These include;
- In SWOT analysis, one of the identified weakness is failure to use technologies in their sourcing approach. As a best practice, Ericsson can make investments in modernised technology including AI, machine learning in improving their sourcing strategies
- Since there is no one-size-fits all approach of selection criteria and sourcing strategies, the best practice would be to harness collaborative and partnerships relations for success of their sourcing.
- Pursue a holistic L&D practices by the PS&M in order to understand the best sourcing approach which would be in a position of enhancing the overall process of sourcing
- Further, from the risk analysis, some of the risks identified are not UpToDate. Hence, it is important continuously updating supply chain networks for identifying potential risks which are internal and external.
(Solution) 70S05 Question 4 (AC 4.1) Balancing Global Corporate Norms with Local Labour Practices
(Solution) CIPS ADNOC Onshore Developing Contracts in Procurement and Supply (PDC)
Executive Summary
For this second assessment in CIPS practitioner qualification, it evaluate role of contract terms and conditions. By using ADNOC Onshore organisation as the organisation of focus, the role of terms and conditions to enhance management of risks of quality, time extension, costs overruns and unethical issues which affect stakeholders. As part of this assessment, the performance measures and management in ADNOC Onshore practices have equally been put into consideration. For ADNOC Onshore which operates in United Arab Emirates onshore and offshore operations, the terms and conditions are identified as appropriate for enhancing the organisation competitiveness in this sector. This is since the terms and conditions influence on the risk level and power held to implement contracts.
In regard to the findings, they indicate that the terms and conditions are appropriate for ensuring that the organisation is well positioned to engage most qualified suppliers. The relevance of using the terms and conditions are essential for ensuring success in solving the different issues faced. Further, from the different findings, they evidence the terms and conditions as force majeure, performance, quality requirements, cost management, indemnity, insurance cover and risks. Also, the findings note that for ADNOC Onshore different departments working in synch, the terms and conditions are identified as essential to link them with all their departments. This is for ADNOC Onshore ensuring dominance of their oil and gas sector maintaining competitiveness in their practice.
Finally, battle of forms have been used with their importance guiding establishment of mutual agreement on best practice to implement contracts. The outcome of this is different terms and conditions existing with a mutual agreement attained.
At the end, from the different gaps and challenges identified in this report, the suggested recommendations are;
- Improve the awareness level amongst the PS&M teams for aligning their terms and conditions in different contracts
- Establishing various terms and conditions for their different spend categories
- Mutually agree on the different terms and conditions for solving battle of the forms issue
- To initiate technology and innovativeness for the overall PS&M operations
- Be able to implement various KPIs and SLAs on contract adoption