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) CIPD 7C002- People Management and Development Strategies for Performance
(Solution) CIPS New PDV- Driving Value Through Procurement and Supply; Managing Expenditures with Suppliers
- Based on the above discussion, this paper has demonstrated that procurement and supply functions in an organisation are critical in reducing costs, ensuring cost-effectiveness and value for money.
- The procurement department at RCU is key to preventing adverse effects resulting from the adoption of new technology within the industry.
- Each organization has its set of rules and blueprints that determine the procurement and supply activities. These rules are beneficial to the organization in several ways, which include improving financial stability, lowering business risk, increasing employee performance, and creating better supplier relationships.
- Investors’ involvement in the procurement and supply process is critical since it facilitates business transformation.
- Effective procurement and supply management is important to organizations because it is central to the success of organization. The procurement department at RCU focused on the purchase of IT software as the area of spend.
(Solution) CIPS PIN Effective Negotiation ROSHN Syndicate Cohort 1
The purpose of this report was to develop a commercial negotiation plan. This plan is applicable by the organisation in the identified spend category.
In this context of the assessment, ROSHN, one of the leading Saudi Arabian real estate development companies in line with the Kingdom’s Vision 2030 has been used successfully.
The key findings in this report evidence that the mission of ROSHN is to meet housing needs and have made it their goal to build 70% homes for Saudi families within the year 2030.
Another key finding is that procurement division the Vendor Management Team (VMT) and Commercial Procurement Team provides timely delivery of resources for housing projects at HDB.
The major findings in this assessment also evidence that Mendelow’s Matrix, PESTLED analysis, and Kraljic Matrix are all components of Roshn’s main strategic procurement cycle, which also places a focus on Principled negotiations when it comes to procuring for necessary resources.
Another main finding is that, as it can be seen from the above discussion, most of the choices made by ROSHN in procurement positively influence its procuring activities regarding its strategy and Vision 2030 objectives.
Nonetheless, there are opportunities for improvement about supplier analysis, risk management, stakeholder management, and the tracking of concessions, which would provide greater negotiating power and procurement performance.
Based on these key findings and generated conclusions, a set of recommendations have been generated which are relevant in this report which entail;
- Ensure that supplier evaluations reflect Vision 2030 by using innovation, sustainability, and sound supplier financials.
- Prepare a detailed risk management plan on sourcing with special reference to using alternate sources as well as pre-screened backups to replace regular suppliers.
- Improve contact with negative factors that affect company regulations.
- Evaluate the factors prevailing in the market to get better negotiation power from the supplier.
- Increase specific characteristics, for example, supplier reliability which contain qualitative elements.