-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 PSE Sourcing Essentials Assessment
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
- Smiths Detection has a robust procurement and supply guided by various clauses, including control, quality, records, and timely management of the sourcing process.
- For different categories of spend, Smiths Detection applies single, dual, multiple, or sole sourcing process.
- Drawing from the pros and cons of the different sourcing methods, it is apparent that there is no unique and universal approach for Smiths Detection sourcing.
- Rather, the approaches are unique to the categories of spend.
- Drawing from the Carter’s 10 Cs appraisal model, it is essential for Smiths Detection to examine the various aspects of the potential suppliers for informed decision-making process.
(Solution) CIPS New global strategic practice used in management of a supply chain in an organisation
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.
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
(Solution) Principles of Marketing Market Segmentation & Targeting
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.
(Solution) New 5HR01 (AC1.1) Differentiate between employee involvement and employee participation and how they build relationships
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.
(Solution) 5CO01 (AC1.2) Analyse connections between organisational strategy, products, services and customers
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.
(Solution) 5C003 Appraise what it means to be a people professional. (AC 1.1)
Original price was: £ 40.00.£ 10.00Current price is: £ 10.00.