-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) 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) 7C001 Question 4: Long-term economic trend affecting country
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
(Solution) Outline of the Proximie’s Business Model
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.
Solution) 7C002 Question 6 (AC2.2) People Management Practices with improved business performance
Original price was: £ 50.00.£ 10.00Current price is: £ 10.00.
(Solution) Level 5 5HR01 Employment relationship management Assessment ID / CIPD_5HR01_22_01
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPS PIN NUPCO Formal Commercial Negotiation Plan
Original price was: £ 50.00.£ 10.00Current price is: £ 10.00.
- For the current integrated modules assignment, a formal negotiation plan has been developed appropriate for the Procurement and Supply Management (PS&M) focusing on organisation operations.
- In this assessment, the National Unified Procurement Company (NUPCO) a leader in Saudi Arabia procurement, logistics and supply chain management for pharmaceutical, medical devices and supplies for government hospitals in Saudi Arabia (KSA).
- Further, the Ultrasound Machines procurement category has been identified in this report. By successfully reflecting on the content from driving value through procurement and supply, managing expenditures, developing contracts, sourcing essentials, negotiation in procurement and supply, relevant insights of the negotiation plan has been provided. Further, in this integrative assessment, the various tools applied include STEEPLE, Porter’s 5 Forces, SWOT analysis and Mendelow Matrix Stakeholders have been used to develop a successful negotiation strategy.
- The importance of this has been informed by the fact that NUPCO being a procurement organisation prioritise on attaining cost spending efficiencies and improvement of the healthcare services providers to government hospitals.
- This is with the skills, concessions, alternatives in the negotiation prioritised identified in this integrative assessment.