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 Advanced Final Project Module 6 – Project, Programme and Change Management in Procurement & Supply
This project aim was evaluation of introduction of 3D printing in the spare parts supply chain in ADNOC in UAE. The importance of working on this report is guided by view that ADNOC is working to embrace automation of their supply chain particularly in the category of spare parts sourcing. Hence, for a successful sourcing, investments in 3D printing is identified as core for success in their operations. This is since 3D printing and other forms of automation are increasingly being adopted in different organisations supply chains locally in UAE and internationally. For the importance of investing in 3D printing, the findings of this report evidence the required results to entail;
- ADNOC success owing to remodelling of PS&M strategy, confident and capacity of spare parts sourcing, talent management and staff competency
- Improved relations with entire stakeholders (as explained in stakeholders matrix) improving overall organisation operations. 3-D printing would be an improvement from the current iSourcing hence success in technical and commercial-based evaluation
- Enhance an improvement and robust system and policy development to manage any potential gap in PS&M transformation
- Today, lower than 10% of ADNOC PS&M would be aligned to implementation of 3D printing and other modernisation strategies appropriate for the organisation
- Ensure development of new systems and policies which are appropriate for enhancing the current and future implementation of 3D printing and more modernised systems as a progress of their modernisation
- There is a necessity for successfully adopting 3D printing starting with their spare parts sourcing
- By collaborating with UAE government which owns 70% of the ADNOC shares, more revenues would be provided for the organisation successful operations.
- ADNOC engaging all the stakeholders holistically by understanding their interests and expectations
- There is a need to collaborate with government in UAE and other regulators for the sake of improving the suppliers relations
- By collaborating with institutions, they would successfully offer employees learning opportunities
- Adoption of strategic sourcing as part of ADNOC sourcing of 3D printing in spare parts sourcing
(Solution) 7C003 Assess the benefits of networking to enhance own career and contribution to organisational effectiveness
(Solution) 5CO03 Recognise when and how you would raise matters which conflict with ethical values or legislation. (AC1.4)
(Solution) CIPS New APCE Advanced Category Management
- In summary, this assignment has focused on evaluating the source of power and risk of an organisation contractual terms. This has been conducted through the focus of SSMC organisation which is currently being engaged in procurement of first aid materials.
- Through a series of analysis, the power and risk distribution has been evidenced as varying in different phenomenon to SSMC and their engaged suppliers. The rationale of this is that for the success of a contract, the legal provisions are critical among the involved parties with clearly set requirements to be adhered to or abstained.
- By using different tools including supplier preferencing matrix, Porter’s 5 forces and Turn-key model have been adopted for this research.
- It has been established that in most instances, SSMC has the power with majority of the risks being held by the supplier. An evaluation of the different components of the contract has been conducted with the clauses of interest including costs, quality level, time for delivery and ethics which influence the power and risk of the suppliers.
- From the analysis of stakeholders by use of the Mendelow stakeholder’s matrix and SWOT analysis, the various issues and risks represent the noted issues in procurement of the fast aid and safety measures in today COVID-19 pandemic.
- As evidenced in the Kraljic analysis, various contract terms are of strategic relevance to SSMC which affirm on its approach of holistically leveraging on contractual risk and power.
- Where the SSMC lacks a holistic balance on the risks and power, a warrant or insurance is granted for guaranteeing their safety.