-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 5CO02 principles of critical thinking
Original price was: £ 30.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 ADNOC Sourcing Essentials (PSE)
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPS ADNOC APGCM risks & implementation of risk management techniques in contracts
Original price was: £ 40.00.£ 10.00Current price is: £ 10.00.
(Solution) 7CO03 Learning Journal business acumen can deliver commercial benefits and manage resilience
Original price was: £ 40.00.£ 10.00Current price is: £ 10.00.
(Solution) New Royal Commission for AIUla (RCU) Commercial Negotiation Plan- PIN
Original price was: £ 40.00.£ 10.00Current price is: £ 10.00.
This procurement negotiation plan for the ROSHN organization focuses on the aspects of planning and executive negotiations in obtaining the IT consultancy services.
It uses the Bailey et al. negotiation model with the mixed approaches of Porter’s 5 Forces and PESTLED frameworks to carry out the evaluation of the market competencies for enhancing the negotiation plans.
The selected approach focuses with creating stable, win-win relationship with suppliers where most of the concentration is for quality suppliers who have efficient timeline delivery and risk control than just focusing on the price.
Expert holistic planning is imperative to this plan, starting with internal need analysis and assessment of inherent risks and stakeholders.
It must be noted that the information founded in this article would help ROSHN effectively strategise its course of action in face of organisational goals as well as market forces..
Key recommendations from this negotiation plan include:
- Establishing an Integrated Digital Procurement System within the next year to track project timelines and quality metrics, aiming for a 20% improvement in service reliability for IT consultancy services.
- Implementing a Comprehensive Supplier Training Program over the next year, with a goal of achieving at least 80% supplier participation to ensure alignment with ROSHN's operational standards and improve service quality by 25%.
- Conducting Quarterly Supplier Performance Evaluations, utilizing a performance scorecard for at least 90% of suppliers to assess compliance with agreed-upon targets, with the objective of increasing average performance metrics by 15% over the year.
- Developing an Enhanced Risk Assessment Protocol within six months to identify and mitigate key risks in the IT consultancy supply chain, targeting a 30% reduction in overall risk exposure through proactive measures.