-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) Marketing Mix (4Ps)
Original price was: £ 50.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPD Level 7 7C001- Work and Working Lives in a Changing Business Environment
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
(Solution) ADSM REMEDIAL PROGRAM SPRING 2024 REM 8011 Introduction to Business Management Spring 2024 Integration and Operationalisation of Four Principles of Management
Original price was: £ 40.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPS ROSHN Syndicate Cohort 1 Effective Negotiation (PIN)
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
Executive Summary
This report provides a background of a formal commercial negotiation which has been developed for ROSHN organisation operating in Saudi Arabia (KSA) real estate industry. To achieve the intended aim of this report, the data used has been sourced from information, figures, desk research, external data which guide the negotiation process. The selected category of spend is vehicles. To develop the negotiation plan, different approaches, techniques, theories and concepts have been referenced to analyse and present successful bargaining approach. Further, with different projects being pursued by ROSHN in urban and rural areas, negotiating for good quality vehicles is essential. Hence, over the years, ROSHN demand for different categories of vehicles has been increasing in the past years. As part of negotiation, ROSHN involves experts, basing it to terms and conditions, adequate plan and optmised supply chain and procurement management.
The findings in this report evidence that ROSHN pursues a series of negotiations which are guided by CIPS module models. The phases pursued include preparation, evaluation, proposal, negotiation, settlement and closing. For all these phases, they are resources intensive hence a necessity for pursing a detailed negotiation. Also, the findings in this report evidence the need for involving multiple stakeholders for a successful implementation of the negotiation process. This is essential for managing their competitiveness in their business sector. Part of this report findings also highlight on the need for customising the negotiation plan based on the different stakeholders expectations. This is with optimum success in the negotiation being dependent on how the organisation manage BATNA, MLA and any battle of the forms with good results obtained.
In line with the summary of the findings and conclusions offered, the recommendations include;
- To carry out a detailed planning in their negotiation process to ensure entire stakeholders are engaged with their interests given a priority
- A successful inclusion of technology and innovation to harness process of negotiation plan
- To improve documenting of their operations for optimum involvement of all stakeholders and to manage conflicts of interests in negotiation
- To ensure that customised negotiations are pursued in their different spend categories as opposed to using a single negotiation strategy
(Solution) CIPS ROSHN Commercial Negotiation Plan-PIN
Original price was: £ 40.00.£ 10.00Current price is: £ 10.00.
- This was established after the post-negotiation review which brought out fundamental lessons about the supplier and our company’s negotiation pattern.
- As for certain important aspects, we indeed secured favourable financing conditions; yet, problems arose in attempting to synchronize delivery schedules since such conditions are affected by external supply chain factors.
- The supplier had the better BATNA and acted in a cooperative but very assertive way, and elaborated why the correct approach to negotiations is more equal.
- Further, the experience showed how flexible one has to be, how innovative, and how it pays to be more interested in long-term partnership rather than quick profit. Therefore, it will be useful in the future to improve the techniques of negotiation, improve the knowledge about the actions of suppliers, and improve intercompany and supplier cooperation.
- This will ensure that in future procurement negotiations; better outcomes are achieved.
- ROSHN should ensure that all negotiations within the next 6 months include specific metrics for delivery timelines, quality standards, and service levels, aiming for a 90% satisfaction rate in supplier compliance with these criteria. This approach will help secure more balanced and sustainable agreements.
- Over the next 12 months, ROSHN should develop a supplier relationship management program with bi-annual assessments to track and improve partnership quality. Target at least a 15% increase in supplier engagement scores by the end of the year to gain favorable bargaining positions during market downturns.
- Within 1 month of each major negotiation, conduct debriefing sessions to analyze performance, identify strengths, and address weaknesses. The goal is to improve negotiation effectiveness by at least 10% in the subsequent quarter through targeted adjustments based on these evaluations.
- Within the next 4 months, involve at least 80% of key stakeholders in sourcing strategy meetings to ensure alignment and gather input on critical decisions. This engagement aims to reduce misalignment issues by 20% within the year, resulting in smoother implementation of sourcing strategies.
(Solution) CIPD Level 7 7C001 Question 4 Long-term Economic Trend Currently Affecting Saudi Arabia
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.