-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) CIPD Explain what diversity and inclusion mean and why they are important (AC3.4)
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
(Solution) Oakwood International 5CO02 Evidence-based practice Assessment ID / CIPD_5CO02_23_01
Original price was: £ 50.00.£ 10.00Current price is: £ 10.00.
(Solution) Module 1 & 2 PDO Cohort (Advanced Practitioner) AS1 PDV
Original price was: £ 20.00.£ 10.00Current price is: £ 10.00.
This assignment for Module 1 and 2 intend to evaluate how stakeholders influence a particular spend category. The organisation of focus is Alaraby TV.
To achieve the intended aim of this report, a holistic market analysis has been pursued for supporting value for money outcomes in selected spend category. The spend category is sourcing for Employees Resource Planning (ERP) system for management of Alaraby TV employees data.
The analysis has been based on different tools supported by CIPS Module notes to evaluate stakeholders relations and value for money outcomes.
In the market analysis outcomes, market data has been sourced for Alaraby TV analysing the implication of business environment strategies. This is in terms of ability to offer quality media sector services in Qatar.
Their practices in the media sector influence their customers satisfaction and stakeholders relation.
The key findings evidence that the ERP system sourcing is important for media services provision. This is by actively coordinating the PS&M teams and the rest of stakeholders.
The key findings also note that the impact of stakeholders is evidenced on the scope in which they prioritise Key Performance Indicators (KPIs) for sustainability operations.
In the findings and conclusions, various recommendations can be generated which are;
- Improved stakeholders relationships successfully
- Implementing Saudisation policy in stakeholders relations
- Direct engagement of all suppliers in their industry and at the same time managing competition
- Develop customised policies for PS&M relationship with their suppliers
- Engaging organisations with value for money outcomes to modernise their interaction with different suppliers.
(Solution) Level 7 7C001 Question 5 Effects of Technological Developments on Recruitment and Selection in Organisations
Original price was: £ 15.00.£ 10.00Current price is: £ 10.00.
(Solution) New CIPD 5HR03: Reward for Performance and Contribution
Original price was: £ 30.00.£ 10.00Current price is: £ 10.00.
(Solution) CIPS FIDIC Contracts Advanced Practitioner Corporate Award (APCE)
Original price was: £ 40.00.£ 10.00Current price is: £ 10.00.
- In this report, an evaluation of a contract by Oracle which is FIDIC guiding their construction projects in more than 67 countries globally has been carried out.
- It is evident from the analysis that there are varying contractual terms having an influence on the power and risk distribution between a supplier and an organisation.
- The rationale of this is that a contract is a legally enforceable agreement between different parties with specific acts or practices to be put into account.
- The core report areas of focus of focus has included the issues of price, quality, construction projects delivery timeline and health and safety have been put into account on the extent in which the risk and power are distributed between the contractor and the organisations.
- In the components identified, it is evident that irrespective of whether the buyer or supplier executes the risk or power.
- Through the application of different tools such as Mendelow stakeholders matrix, SWOT analysis and others, distinct issues and risks characterised by various challenges in the construction projects execution with their mitigation approaches and risks have been evidenced.
- As evidenced from the Kraljic analysis, it is evident that contractual terms have a strategic relevance in the context of Oracle informing on their holistic leveraging on the risks and powers of the contract.
- In situations where Oracle fails in leveraging on contract holistic risks power balance, warrant and also insurance cover is used.