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) CIPD Level 5 50S01- Specialist Employment Law
(Solution) 70S05 Question 3 (AC 3.1) Initial Outline of a Plan for the Effective Induction, Orientation and Socialisation
(Solution) CIPS APGCE Costs and Financial Implications on Supply Chains
For this assignment, a business report evaluating global commercial strategy has been developed. As part of this evaluation focuses on Hertfordshire and West Essex (H&WE) NHS organisation.
Importantly, the rationale of this evaluation is informed by the fact that an organisation strategy guides an organisation success in achieving a competitive advantage and dominating their market of operations.
Focus areas in this report include relationship of strategy and corporate, business and functional structures, methods used to analyse supply chain, managing resources for supporting development and implementation of strategy and how costs and finance could impact on supply chain.
Through the application of different CIPS Models and techniques (Mendelow Matrix, PESTLE Generic Analysis tool, and risks register), various findings were obtained. The findings support existence of a direct correlation of strategy, corporate, functional structures and business practice.
In analysis of supply chain, predictive and descriptive approaches which are quantitative and qualitative identified as relevant for the evaluation. Also, by ensuring all relevant stakeholders are engaged in the process, successful costs management and supply chain analysis identified.
(Solution) CIPS New global strategic practice used in management of a supply chain in an organisation
This advanced level third module assessment focuses on evaluating global strategic practice used in management of a supply chain in an organisation.
The rationale for working on this assignment is guided by findings that supply chain development has an influence on positioning of an organisation in a market and sustainability in sourcing process.
Also, with globalisation a current trend in modern procurement and supply chain management market, it influence how supply chain management is pursued and performance in corporate level. The organisation of focus is XXZ organisation engaged in provision of procurement outsourcing services in Qatar.
As a subsidiary with headquarters in United Kingdom, XXZ organisation supply chain and globalisation has a direct link with corporate performance. This is despite of the identified challenges, risks and opportunities.
The key findings in this report evidence supply chain network inclusive of different tiers as impacting organisation operations. This is since it has an influence on positioning for achieving set goals and corporate strategy.
From the analysis findings, the use of various models for challenges and opportunities (SWOT) and environment analysis impact on supply chain (STEEPLED) XXZ organisation is appropriately positioned in using different supply chain strategies.
The different stakeholders have also been identified to impact the supply chain management success influenced by financial and non-financial factor.
The findings and conclusions made in this report inform a set of improvement areas;
- Enhance collaboration, networking and innovativeness for sustainability of supply chain network
- Investing in L&D opportunities for XXZ PS&M teams to understand impact of supply chain and competitiveness
- Management of encountered supply chain relations conflicts to ensure stakeholders involvement and inclusion in its implementation
- Transition supply chain network to include globalisation demands with all risks and challenges managed