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) AC1.2 Explain the impact of changing labour market conditions on resourcing decisions
Terms and conditions help the organisation ensure relevant performance measures are monitored and managed
(Solution) CIPS Module: Global Strategic Supply Chain Management
- In this assessment, the focus has been on evaluating global strategic approach for WoodPlc supply chain identified. The relevance of this is informed by assumption that supply chain is anchored on the need to influence changes in market in supply chain practices. This is while sustainable global sourcing strategies being used.
- The findings evidence strategic logistical impact of an organisation and supply chain management process has an impact on corporate performance. The different tools and techniques which have been applied inform on the best practice of the organisation operations.
- For WoodPlc organisation working in oil and gas contracting sector in UAE, reviewing of their supply chain is used by use of best practice in their practice. Also, an identification of entire risks, issues incurred and opportunities evident.
- The findings in this report evidence different challenges as affecting collaboration. This assessment recommend need for Improving collaboration, network-based practice and innovativeness to ensure they embrace sustainability in supply chain
- Today, WoodPlc has been identified as lacking appropriate continuous development strategy for all stakeholders and end-users of their operations. Improving supply chain development through an increased chances for learning
- In WoodPlc, they are encountering immense transitioning from modern supply chain and use of technologies. There is a need to manage all the supply chain relations. This is for the Conflicts management in entire supply chain relations to ensure stakeholders are involved and part of the implementation of the practice
- In this report, it has been concluded on the existing challenges in their tiers. To manage the challenges identified from the Porters 5 forces analysis, there is a need to introduce end-to-end supply chain for their overall demands which capture various tiers for including all operations. This is to guarantee a successful management of the overall supply chain and performance management issues
(Solution) 5CO02 (AC1.3) Explain the principles of critical thinking including how you apply these to your own and others’ ideas
(Solution) 5HR03 AC1.1) Explain the principles of reward and its importance to organisational culture and performance management.
(Solution) ROSHN CIPS PIN Procurement Cycle and Sourcing Activity
Roshn is a national real estate developer owned by the Public Investment Fund of Saudi Arabia. Established in 2020, ROSHN’s mission is to deliver high-quality, affordable housing and develop thriving community destinations across the Kingdom.
As one of the largest real estate groups in the Middle East, ROSHN manages a portfolio of ambitious residential and mixed-use projects. With operations in major cities, ROSHN’s developments will contribute to Vision 2030 goals of increasing home ownership rates and improving quality of life for citizens.
To effectively manage its large-scale, nationwide portfolio, ROSHN relies extensively on advanced information technologies and robust cybersecurity protections to support all aspects of its business.
The scope of the organisation operations is as summarised in figure 1;
Figure 1:Summary of ROSHN Projects
Source: ROSHN (2023)
To evidence ROSHN’s success, several key investments have been made supporting their projects. The Public Investment Fund provided an initial $2 billion seed funding for Roshn's development, a historical area transforming ancient sites into vibrant destinations.
Additionally, over $3.2 billion has been committed through public-private partnerships for critical infrastructure development by 2023.
This success is informed by ROSHN’s strategic plans, which oversee approximately 25,000 square kilometers encompassing residential communities, natural assets like oasis valleys and mountains, and cultural heritage sites across Saudi Arabia (Argaam 2022).
The significant investments reflect confidence that ROSHN can successfully deliver on their mission of developing thriving regions nationwide.