-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) New PSE Sourcing Essentials ROSHN Syndicate Cohort
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.
This report makes use of the case study of ROSHN — Saudi Arabia’s leading real estate developer having the responsibilities of delivering quality homes.
ROSNH plays an important role in the organization of construction activity in KSA and currently owns more than sixty percent in the market of residence construction.
The key findings evidence that procurement practices of the organization are orderly with keen emphasis on the relationship it has with the suppliers so as to deliver construction materials in the shortest times and most efficient costs possible.
The key findings evidence that an effective sourcing approaches will work to strengthen ROSHN’s procurement systems, minimize supply-chain vulnerabilities, and centralize costs for the organisation while offering the organization compliance with burgeoning sustainability shifts in the constructions industry.
The following paper assesses the current sourcing initiatives and provides several critical suggestions that can strengthen procurement and supply chain.
The key recommendations arising from this analysis include:
- ROSHN should incorporate Porter’s Five Forces and PESTLE analysis into the organization’s Vendor Management Team (VMT)
- The expansion of the approved list of suppliers by not less than fifteen percent in the course of the next year is vital in eliminating reliance on a few suppliers.
- Improving eSourcing tools especially eAuctions to apply competitive pressures and lower costs of procurement. This will solve the problem of inefficiency in the tendering process and increase transparency while RHOSN already has efficient technology solutions for engaging suppliers.
- Obligatory implementation of a supplier sustainability program that identifies suppliers with high levels of CS
(Solution) CIPD Level 5 Avado PQ CIPD_5CO03_24_01 5C003
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
(Solution) Module Title: Sourcing Essentials PSE PDO Cohort 9 (Advanced Practitioner)
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
Executive Summary
This report has focused on evaluating specific sourcing approaches which are used in different spend categories in Alaraby TV Network. This is achieved by focusing on the Information Technology (IT) as spend category for the organisation and particularly hardware sub-category. As part of fully digitising media operations in Alaraby TV Network, the organisation has been sourcing IT systems meant for enhancing their operations. As part of analysis, other spend areas including logistics, health and safety tools, communication equipment and videography and leasing for vehicles used in movement in Qatar. For the purpose of noting on various sourcing approaches, different tools in CIPS have been used including Mendelow Matrix, Kraljic tool among others.
The key findings in this report is that organisations use different sourcing approaches in their categories of spend. The choice of sourcing approaches is informed by the engaged stakeholders, the spend categories and external/internal factors. Also, the findings evidence that sourcing approaches are informed by the organisations position in their business environment. This report findings has identified these approaches as including single, sole, dual and multiple. Also, key findings in the supplier appraisal of the IT hardware sub-category, suppliers are best evaluated in line with the Cater’s 10Cs being applied. The application of the different sourcing approaches lead to Alaraby TV Network to dominate the entire Middle East region and leveraging on competitive advantage. Multiple sourcing has been identified in the findings as involving many suppliers with single sourcing involving one supplier while dual sourcing including different suppliers having demands that conflict.
From the identified gaps in this report, the following recommendations can be used to fill these gaps;
- Opting for most appropriate sourcing approach guided by spend category
- Priority on policies for PS&M to guarantee integration of all stakeholders interest
- Simplify overall procurement strategy for ensuring prioritisation of stakeholders point of view
- Using technologies in phases of procurement lifecycle including RFQ, RFP, e-Auction intended to improve how information ,flows in sourcing approaches identified
(Solution) CIPD 7OS05 major alternative international organisational forms and their consequences for the management of people
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
(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) Case Strategy- Proximie
Original price was: £ 70.00.£ 10.00Current price is: £ 10.00.