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 APGLM Impact of Leadership Approaches on Job Satisfaction
(Solution) CIPS Project Module 6- Project, Programme and Change Management in Procurement and Supply Chain
Executive Summary
For this project, the purpose was to access the overarching process and approach to SRM within Oxy organisation and coming up with appropriate implementation plan. The relevance of this project was informed by the fact that with the organisation having a large scale of operations with multiple end users, SRM is a significant issue. Also, the organisation operating in both local and international operations with multiple suppliers and spend areas to be coordinated. The outcome of this would be to promote and improve SRM for aligning with Oxy organisation strategic objectifies, supply chain function being strategic integral partner as opposed to just transactional player. Owing to the importance of SRM improvement, the different outcomes would entail;
- Enhanced Suppliers Performance- With an upward of 50,000 orders annually with 40% valued more than 5 million Omanis and 50% 20 Million Omanis, failure to timely settle invoices, demand for high quality materials and minimising effects would be considered.
- Cost savings- With improved SRM, it is possible for Oxy to negotiate appropriate terms, lower procurement costs (5 Rights not currently achieved) hence working below targets and lead times delivery reduced and achieving economies of scale.
- Increased efficiency- improved and streamlined SRM improve operational efficiency, reducing wastes in administration process for SRM (25% of entire suppliers pay delayed)
- Risk mitigation- this include identification of risks linked with suppliers such as dissatisfaction, financial instability and geopolitical challenges
- Oxy organisation PS&M is supposed to come up with appropriate systems and techniques for improvement of SRM
- Oxy organisation need to make sure they use various automations including AI and robotics for improving collaboration and SRM efficiency.
- Facilitate policies management for improving their operations in onshore and offshore operations with an improved SRM
- Short courses on SRM need to be provided starting with PS&M leadership to achieve 50% increase in awareness of SRM improvements areas.
- Stakeholders relations improved by leveraging on available technologies of communication and interaction.
- Ensure there is 70% increase in budget on SRM improvements
(Solution) CIPS Advanced Level Contract & Category Management in P&S – APGM
- This business report has been used for evaluating the category and contract management in Eco2Solar Company.
- In particular, Eco2Solar operates to improve their project management (PM) and Cost Management (CM) as part of their category management has been evaluated.
- The areas of focus has included an evaluation of requirements for initiating and preparing category management, strategic and conventional sourcing process and role in contract management, tools and techniques for mapping categories of direct and indirect expenditure.
- From the findings obtained, innovative measures for improving the supply chain in light of categories and category management has been recommended.
- Further, in this business report, the contract administration and contract management in case of category management has similarly been evaluated in context of category management this is with assessment of risks and implementation of risk management techniques in contracts being reviewed in context of category management.
- In order to appreciate the best practice in category and contract management in the selected Eco2Solar construction spend area, use of quantitative and desk research has been pursued to obtain relevant data.
- Additionally, different tools have been applied such as Mendelow Stakeholders analysis, CIPS Category Management Cycle, CIPS Contract Management Cycle, Suppliers positioning, PESTLE analysis and SWOT analysis.
- Considering this business report findings, Eco2Solar need to improve their approach for risk management and efficiency and effectiveness of category and contract management.
- From these finding, the stakeholders collaboration in Eco2Solar need to be improved which can be done by embrace of blockchain technologies.
- Also, by identifying their PS&M teams training and capacity development, they would be able to improve on their category management. In the contemporary procurement environment, the training and capacity development has been noted as the best practice to manage gaps in their operations. Also, the findings indicate the need for Eco2Solar to improve their category management of their construction spend by coming up with appropriate SLA’s agreement and KPIs while ensuring they capitalise on innovativeness.
- For the project management and cost management, this being a long-term investment would require an improved auditing. This can entail embrace of analytics to analyse and present contract management data and appropriate management strategy.
- The importance of improved collaboration is ensuring stakeholders active involvement and awareness on core decisions made as this could harness their practice, contribution and suggestions noted.
- By successfully pursuing stakeholder analysis, it is important to maintain stakeholders relations which promote Eco2Solar organisation image and increase their market share.