-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 Advanced Level Contract & Category Management in P&S – APGM
Original price was: £ 40.00.£ 10.00Current price is: £ 10.00.
- This business report has been used for evaluating the category and contract management in Eco2Solar Company.
- In particular, Eco2Solar operates to improve their project management (PM) and Cost Management (CM) as part of their category management has been evaluated.
- The areas of focus has included an evaluation of requirements for initiating and preparing category management, strategic and conventional sourcing process and role in contract management, tools and techniques for mapping categories of direct and indirect expenditure.
- From the findings obtained, innovative measures for improving the supply chain in light of categories and category management has been recommended.
- Further, in this business report, the contract administration and contract management in case of category management has similarly been evaluated in context of category management this is with assessment of risks and implementation of risk management techniques in contracts being reviewed in context of category management.
- In order to appreciate the best practice in category and contract management in the selected Eco2Solar construction spend area, use of quantitative and desk research has been pursued to obtain relevant data.
- Additionally, different tools have been applied such as Mendelow Stakeholders analysis, CIPS Category Management Cycle, CIPS Contract Management Cycle, Suppliers positioning, PESTLE analysis and SWOT analysis.
- Considering this business report findings, Eco2Solar need to improve their approach for risk management and efficiency and effectiveness of category and contract management.
- From these finding, the stakeholders collaboration in Eco2Solar need to be improved which can be done by embrace of blockchain technologies.
- Also, by identifying their PS&M teams training and capacity development, they would be able to improve on their category management. In the contemporary procurement environment, the training and capacity development has been noted as the best practice to manage gaps in their operations. Also, the findings indicate the need for Eco2Solar to improve their category management of their construction spend by coming up with appropriate SLA’s agreement and KPIs while ensuring they capitalise on innovativeness.
- For the project management and cost management, this being a long-term investment would require an improved auditing. This can entail embrace of analytics to analyse and present contract management data and appropriate management strategy.
- The importance of improved collaboration is ensuring stakeholders active involvement and awareness on core decisions made as this could harness their practice, contribution and suggestions noted.
- By successfully pursuing stakeholder analysis, it is important to maintain stakeholders relations which promote Eco2Solar organisation image and increase their market share.
(Solution) CIPD Level 7 Provide an overview of sources you are going to explore and review
Original price was: £ 40.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPD 5C002- Evidence-based practice
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.
(Solution) 7C003 Reflect on levels of self-awareness, self-management and continuous self-improvement, leading to improved organisational success and career progression
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPD Describe different types of learning needs and reasons why they arise for individuals and organisations. (AC6.2)
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPD 5C002 (AC1.4) Explain a range of (2) decision-making processes
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.