-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 ADNOC Sustainable global sourcing decisions
Original price was: £ 50.00.£ 10.00Current price is: £ 10.00.
(Solution) ROSHN CIPS PIN Market Analysis
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
(Solution) Question 3- Leadership Style in Sunmark Bank good at moment or not
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPS Advanced Practitioner Corporate Award (APGSS)
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.
For this module “Global Strategic Supply Chain Management”, assessment, a business report which evaluate global strategic approach for management of organisation supply chain has been developed.
This has been achieved by evaluating impact of market changes on supply chain, sustainable global sourcing decisions, strategic logistical implications of globalisations, and impact of supply chain management on corporate performance.
The organisation of focus is Hertfordshire and West Essex (H&WE) NHS Procurement Services with provision of laptops and computers hardware for entire 5 trusts category of spend.
Key findings have been obtained in this report based on analysed data, desk research, facts and CIPS Models and tools (Porter’s 5 Forces, SWOT and STEEPLED analysis and more). One of the main findings is that H&WE does not have a structured supply chain. This is despite of existence of several tiers in the sourcing process of laptops and computers hardware.
Another finding is that different factors including social, technology, economy, environment, politics, legal and demographics impact supply chain of H&WE. For sustainable global sourcing decisions, the key findings indicate H&WE as prioritising on 3P’s triple bottom-line of procurement. This is by focusing on Profit, Planet and People.
The strategic logistical implications of globalisation main findings include different strategic considerations, logistical risks and opportunities.
The final key findings is that supply chain management has a direct implication on corporate performance.
From the conclusions of this report, a set of recommendations have been generated which include;
- For supply chain sustainable development, include collaboration, networks improvement and innovativeness
- PS&M in H&WE facilitate L&D opportunities for enhancing ability for supply chain development process
- Improve all stakeholders relations in supply chain for management of different conflicts in their operations
- To develop a well-structured supply chain which is currently lacking in H&WE for management of supply chain risks and performance level challenges
(Solution) 7CO03 Learning Journal business acumen can deliver commercial benefits and manage resilience
Original price was: £ 40.00.£ 10.00Current price is: £ 10.00.
(Solution) Assessment ID / CIPD_5HR01_22_01 5HR01 Employment relationship management
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.