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) 70S05 Question 1 (AC 1.4) People-Related Ethical Issues for Fitter Threads Ltd
(Solution) CIPS Advanced Level Contract & Category Management in P&S – APGM
- 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) CIPS Module Sourcing Essentials (PSE) SWS (Sustainable Water Solution)
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.