-75%
(Solution) CIPD Avado SECTION 2 1.4 Data Analysis
New User Gifts
First Order Deal get Ksh 200 Off.
KaribuCustomer
Original price was: £ 40.00.£ 10.00Current price is: £ 10.00.
Payment Methods:
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 Avado 5HR01- Employment Relationship Management
Original price was: £ 40.00.£ 10.00Current price is: £ 10.00.
(Solution) 7HR01 Question 4 (AC 4.1) different forms of collective bargaining, one in a unionised and one in a non-unionised environment
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPS FIDIC Terms and Conditions PDC
Original price was: £ 40.00.£ 10.00Current price is: £ 10.00.
- This report evaluates the terms and conditions that are applicable in a contract management process to improve its implementation.
- By referencing FIDIC organisation terms and conditions, their effectiveness in mitigating issues with time, unethical, quality, costs and performance management has been evaluated.
- These terms and conditions are grouped into the goods quality, guidelines of goods and services inspection, communication, and time extension.
- Part of the analysis involves the evaluation of performance measures essential to improve management and monitoring of the stakeholder’s involvement in the contract process.
- At the end, battle of forms has been evaluated, which involves failure to agree on set terms and conditions.
- To solve this, short-term rule and long-term rule and Lord Deming could be adopted.
(Solution) CIPS Module 3 Sourcing Essentials (PSE)
Original price was: £ 40.00.£ 10.00Current price is: £ 10.00.
In this report, the area of focus is on ROSHN’s procurement and vendor management strategies in alignment with Saudi Arabia’s Vision 2030. ROSHN, a leading real estate development company, is committed to building sustainable communities and increasing homeownership within the Kingdom. The company manages its entire development pipeline, from land acquisition to home construction and distribution, ensuring control over quality and costs. One of ROSHN’s key objectives is to achieve 70% homeownership by 2030, while promoting employment and economic growth in Saudi Arabia. The Procurement and Commercial functions at ROSHN play a critical role in achieving these goals. The Vendor Management Team (VMT) employs various strategic tools, such as Porter’s Five Forces and PESTLE Analysis, to evaluate suppliers and market conditions. These tools help ROSHN in negotiating better terms, securing reliable suppliers, and maintaining project timelines. Furthermore, ROSHN’s procurement cycle is structured to ensure compliance, cost efficiency, and project quality through a Pre-Qualification Questionnaire (PQQ) and supplier registration processes. ROSHN’s sourcing strategies, including sole, single, dual, and multiple sourcing, allow the company to manage supply risks while maintaining competitive pricing and consistent quality. The company also utilizes the Kraljic Matrix to categorize suppliers based on their strategic importance and supply risks, ensuring that critical infrastructure needs are met.
The conclusions generated lead to development of the following recommendations;
- Streamline the PQQ process to reduce onboarding time and ensure suppliers meet compliance and quality standards more efficiently.
- Cultivate long-term relationships with key suppliers for critical infrastructure projects to ensure timely and high-quality delivery.
- Use data analytics to enhance supplier evaluation, improving decision-making accuracy and reducing supply chain risks.
- Increase the use of eSourcing tools to boost competition among suppliers, potentially reducing procurement costs.
- Regularly run mini-competitions to ensure competitive pricing and maintain high service quality.
(Solution) ICS Learn CIPD Level 5 Evidence Based Practice (5CO02)
Original price was: £ 40.00.£ 10.00Current price is: £ 10.00.