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 ADNOC APGCM Module: Contract & Category Management in P&S
In summary, this report has provided a comprehensive analysis of ADNOC’s procurement strategies and risk management frameworks underscores the critical importance of proactive and strategic approaches in the energy sector. The key findings indicate that through embracing advanced technologies such as AI-driven analytics and supply chain management software, ADNOC can effectively anticipate market trends, mitigate operational risks, and enhance decision-making capabilities. Moreover, the development of agile compliance and sustainability programs enables ADNOC to adapt swiftly to regulatory changes while bolstering its reputation as a responsible corporate entity.
Another key finding is that supplier diversification emerges as a pivotal strategy to safeguard against supply chain disruptions, offering ADNOC flexibility and resilience in volatile market conditions. This is with the findings evidencing that strategic partnerships with suppliers not only mitigate risks associated with single-source dependency but also foster innovation and quality improvements. The emphasis on continuous performance improvement and the proactive management of contract lifecycles further contribute to ADNOC’s operational efficiency and cost-effectiveness.
By using different models and techniques analysis, ADNOC’s commitment to integrating these strategic recommendations into its procurement practices positions the organization to achieve sustainable growth, operational excellence, and competitive advantage in the global energy market. By aligning procurement strategies with broader organisational goals and leveraging cutting-edge technologies, ADNOC can navigate complexities, drive innovation, and ensure long-term success in a rapidly evolving industry landscape.
Recommendations
- Implement one AI-driven analytics platform by Q4 2024, integrating with existing systems and training staff to enhance forecasting accuracy and negotiate a 10% reduction in supplier costs, led by the IT, procurement, and finance departments. Despite potential initial costs and staff adaptation challenges, this initiative aims to achieve a 15% increase in forecasting accuracy.
- Fully deploy advanced supply chain management software by Q2 2025, partnering with a leading provider and training teams to reduce disruptions by 20%, thus increasing overall supply chain efficiency by 5%. This effort involves collaboration between supply chain management, IT, and vendor management teams, despite initial disruptions and high upfront costs.
- Establish a cross-functional compliance team by Q3 2024 to develop three new policies annually, ensuring 100% compliance with regulations and enhancing reputation metrics by 15%. Led by legal, compliance, and HR departments, this initiative aims to overcome resistance to policy changes and resource-intensive monitoring efforts.
- Implement three financial instruments (futures, options, currency swaps) by Q3 2024, collaborating with financial experts to reduce financial risks by 20% and achieve a 10% increase in financial stability. This effort, led by finance, risk management, and external advisors, addresses potential challenges in market volatility and regulatory constraints.
- Engage multiple suppliers and form five strategic partnerships by Q4 2024, increasing supplier diversity by 30% and improving supply chain reliability metrics by 10%. Led by procurement, vendor management, and supply chain analysts, this initiative aims to mitigate dependency risks and manage supplier relationships effectively. Potential challenges include maintaining consistency in product/service quality across diverse suppliers and increased administrative burden in managing multiple partnerships.
- Conduct market and competitor analyses twice a year starting Q3 2024, aiming to increase procurement cost savings by 15% through better negotiation strategies and timely market insights. This effort, involving procurement, and strategy departments, addresses challenges in data availability and competitive analysis capabilities. Potential challenges include delays in obtaining and analysing market data and difficulty in predicting competitive moves accurately.
(Solution) 5HR03 (AC3.1) Assess the business context of the reward environment
(Solution) 5C003 New (AC2.1) Argue the human and business benefits of people feeling included, valued, and fairly treated at work linking to related theory
(Solution) New PSE Sourcing Essentials ROSHN Syndicate Cohort
This report makes use of the case study of ROSHN — Saudi Arabia’s leading real estate developer having the responsibilities of delivering quality homes.
ROSNH plays an important role in the organization of construction activity in KSA and currently owns more than sixty percent in the market of residence construction.
The key findings evidence that procurement practices of the organization are orderly with keen emphasis on the relationship it has with the suppliers so as to deliver construction materials in the shortest times and most efficient costs possible.
The key findings evidence that an effective sourcing approaches will work to strengthen ROSHN’s procurement systems, minimize supply-chain vulnerabilities, and centralize costs for the organisation while offering the organization compliance with burgeoning sustainability shifts in the constructions industry.
The following paper assesses the current sourcing initiatives and provides several critical suggestions that can strengthen procurement and supply chain.
The key recommendations arising from this analysis include:
- ROSHN should incorporate Porter’s Five Forces and PESTLE analysis into the organization’s Vendor Management Team (VMT)
- The expansion of the approved list of suppliers by not less than fifteen percent in the course of the next year is vital in eliminating reliance on a few suppliers.
- Improving eSourcing tools especially eAuctions to apply competitive pressures and lower costs of procurement. This will solve the problem of inefficiency in the tendering process and increase transparency while RHOSN already has efficient technology solutions for engaging suppliers.
- Obligatory implementation of a supplier sustainability program that identifies suppliers with high levels of CS