-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 Sourcing Essentials (PSE) SWS (Sustainable Water Solution)
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
Executive Summary
This report evaluates and contrasts various sourcing strategies within the SWS (Sustainable Water Solution) organisation, focusing on the health and safety (HS&E) category of spend during the COVID-19 pandemic, which necessitated remote working. To assess the different sourcing strategies, tools such as the Kraljic analysis, Mendelow's stakeholder analysis, the business hierarchy of needs, and the SWOT analysis were employed. Additionally, the Peter Block Grid was used to categorise stakeholders based on their interests and positions related to the sourcing strategies.
In the supplier evaluation for the HS&E category of spend within SWS, Carter's 10Cs methodology was applied to assess different sourcing strategies. The results indicate that SWS should adopt a strategic sourcing approach to sustain its leadership in the sustainability and water management industry while maximising efficiency. The sourcing strategies include multiple sourcing (engaging with multiple suppliers), single sourcing (working with one supplier), sole sourcing (working with a monopolistic supplier), and dual sourcing (working with two suppliers who might have conflicting demands).
In conclusion, the recommendations for SWS's sourcing strategies in the HS&E category of spend are as follows:
- Determine the most suitable sourcing strategy based on the characteristics of the spend category.
- Ensure procurement policies are comprehensive and prioritize health and safety standards.
- Simplify the procurement process while considering the interests of all stakeholders.
(Solution) Level 7 7C003 Continuing Professional Development plan
Original price was: £ 15.00.£ 10.00Current price is: £ 10.00.
(Solution) 5C003 outcome of your assessment (strengths, weaknesses and development areas) and the information that informed your conclusions. (AC 3.2)
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPS Supply Chain Analysis Methods
Original price was: £ 40.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPD Level 5 CIPD_5HR01_24_01 5HR01 Employment relationship management
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPS Developing Contracts in Procurement and Supply RCU PDC
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
- This report has focused on evaluating Royal Commission for AlUla (RCU) contract terms and conditions.
- The area of focus in the contract entail its relevance in assisting the management of issues associated with quality, risk of time extension, risk of costs increase and unethical practices impacting the stakeholders.
- Other than this, the performance measures and management in the organisation operations has been put into account.
- For achieving this, RCU operating in the KSA tourism and culture sector has put into account.
- The contract selected is used in most of the services which are sourced by the organisation from different suppliers. This is to define the level of risk and power that each has in the contract implementation.
- Despite of existence of areas of improvement, clauses lacking detail and lack of sufficient protection, the contract terms and conditions are relevant for RCU operations.
- For all the parties and stakeholders involved in a contract implementation, there is a clear risk allocation and management. This is with the performance being measured and monitored based on their interests.
- There is a need for investing in modernised approaches intended to protect the organisation from the battle of the forms.