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) Strategic Supply Chain Management for Circular Economy (CE) PART 2: Contemporary Issues in Strategic Supply Chain
(Solution) Sourcing essentials (PSE) Saudi Downtown Company (SDC) Information Technology (IT) systems
In this report, an evaluation of various sourcing approaches used in sourcing has been pursued. Through a focus on Saudi Downtown Company (SDC), sourcing of Information Technology (IT) systems post COVID due to popularity of remote working in the different departments has been identified as the spend area.
In the evaluation process, different tools including Mendelow Matrix, Kraljic Matrix, SWOT analysis, Hierarchy of need, and Peter Block Grid have been adopted in the analysis.
The different sourcing approaches have been identified and their influence for the organisation best practice noted. At the end, by using Cater’s 10C’s tool, supplier appraisal has been carried out for the identified spend area.
The findings in this assessment evidence that SDC adopts various sourcing approaches for their different spend categories.
There is nevertheless a challenge in embracing strategic sourcing in their operations. Further, the organisation use different sourcing approaches including multiple sourcing, single sourcing, sole sourcing and dual sourcing.
All these sourcing approaches are distinct and involved in engagement of different suppliers, only one supplier involved, monopolistic suppliers engaged and suppliers with demands which conflict respectively.
In line with the findings and conclusions obtained in this assessment, various recommendations have been suggested for SDC. They include;
- To select best sourcing approach informed by the characteristics of their spend categories
- Ensure various legislations and policies are initiated to aid use of technologies and innovation in their sourcing process
- Implement a fully streamlined PS&M strategy with entire stakeholders interests prioritised
- Improve information flow and supporting their sourcing strategy by leverage on different approaches (RFQ, RFP and e-Auction) integrated to product lifecycle
Assessment ID/CIPD_5HR02_22_01 Talent management and workforce planning
Solution Table of Content AC 1.1 ……………………………………………………………………………………………………………….7 AC 1.2 ……………………………………………………………………………………………………………….8 AC 1.3 …………………………………………..……………………………………………………………………9 AC 2.1 ………………………………………………………..…………………………………………….………10 AC 2.2……………………………………………………………………………………………………..………..11 AC 2.3…………………………………………………………………………….…………………………………12
(Solution) CIPD 7C002 Question 14: CIPD Purpose champion better work and working lives
(Solution) CIPD PWC 3COO2- Principles of Analytics
(Solution) CIPS ROSHN Negotiation Process
In this integrated assessment, a focus on a formal negotiation plan has been pursued. This is through the focus of Roshn organisation which is a Saudi Arabia’s largest real estate development company owned by the Public Investment Fund for KSA, has Vision 2030 supplier sourcing management strategies. The firm’s procurement department relies on a model outlined by Bailey et al that provides a rigorous approach to preparation and analysis in order to get better bargains. Hence, the Roshn internal supplier data collection and external market research to create accurate supplier risk and sourcing plans.
A variety of tools is applied, such as the Kraljic Matrix that is used to sort suppliers. The key findings note that different training activities include negotiation simulations and skills to prepare and help procurement officers for the journey. Another key finding ius that detailed planning and analytical structures accompany objectives and concession tracking. Another key finding note that supply relations are strategically classified on issues of risk and consequences as far as supply management is concerned. On a continuous basis, repetition and necessarily sequenced post negotiation reviews improve processes gradually for a successful negotiation plan.
From the findings and conclusions obtained, to maximise efficiency and optimise outcomes, it is recommended:
- Roshn standardise the Bailey et al procurement framework.
- Regular training will develop negotiation mastery, and the Kraljic Matrix will tailor strategies per supplier importance.
- Sourcing strategies should evolve through market reviews. Building long-term, trusting partnerships will foster competitiveness beyond transactions.
- Clear metrics measuring initiatives' success will empower data-driven process adjustments.
- Adopting these practices will enhance Roshn's sustainable sourcing in support of Vision 2030 goals.