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 Sourcing Essentials PSE
- For the current report, the sourcing approaches identified and in-depth explained are informed by the ADNOC chemicals sourcing.
- In tandem with the different spend categories, different sourcing approaches for the spend have been applied with a supplier appraisal generated at the end.
- Through an in-depth analysis, sourcing strategies evaluating in areas of multiple, single, dual and sole. For procuring the chemicals, multiple sourcing is the best practice due to the procurement process characteristic.
- As evidenced from Kraljic analysis matrix, suppliers relations are noted with chemicals procurement being a leverage category.
- The Carter’s 10Cs model is applicable to pursue suppliers appraisal for chemicals sourcing supplier appraisal.
(Solution) CIPS Module Title Developing Contracts in Procurement and Supply- PDC
Executive Summary
The significance of the set of terms and conditions chosen from XXX organisation has been assessed in relation to its impact on the organisation. This pertains to the domains of potential hazards related to subpar quality, time delays, escalated expenses, and unethical conduct in effective administration. In addition, the monitoring and administration of essential performance measures have been taken into consideration by utilising the selected terms and conditions. The terms and conditions can be found in appendix 1 of this report. Ultimately, the concept of "battle of the forms" has been chosen as the most effective approach to reaching a mutual agreement that aligns with an organisation's own terms and conditions. The terms and conditions selected in XXX are utilised in the General Conditions of Purchase, which are standardised T&Cs employed in procuring services for the organization. This applies regardless of the quantity of resources utilised in the order, the associated risks, and the specific requirements.
The findings in this report demonstrate that their terms and conditions are successful in guaranteeing the provision of high-quality services to XXX. This involves improving the supply process in a timely manner while ensuring that ethical considerations are properly addressed. An optimal approach also includes utilising these terms and conditions to address performance concerns and assess progress. In order to address the issue of conflicting terms and conditions in the "battle of the forms," the terms and conditions of various suppliers are compared and analysed beforehand to ensure that they are aligned and consistent. In order to fulfill the desired objective of the report, many analytical methods such as the Mendelow Matrix, risk register, contract management cycle, and assessment of the value and impact of vulnerability and risks were employed, following the guidance provided by the CIPS Module Notes.
Based on the results and conclusions, several recommendations might be derived. These include:
- Expand the terms and conditions by adding additional clauses to make them more comprehensive.
- Verify that the suppliers selected have prior experience in providing comparable services to prevent battle of the forms.
- Include provisions in the terms and conditions that align with relevant KSA legislations to enhance their applicability.
- Conduct a benchmark analysis on top-performing organisations in the oil and energy industry in the KSA to enhance their terms and conditions
- Enhance the expertise of the PS&M teams to effectively manage the terms and conditions without encountering significant difficulties.
Question 5 (AC2.1) 7C002 succession planning are elitist in character and inappropriate for use by organisations committed to equality, diversity and inclusion
(Solution) (AC2.2) Evaluate the techniques used to support the process of workforce planning
(Solution) CIPS Advanced Practitioner Commercial Management Assessment
Executive Summary
For this assessment, a business report has been developed for evaluating global commercial strategy. This report focuses on S-Chem organisation. The importance of evaluating the global commercial strategy is informed by its effectiveness in guiding an organisation successful leverage on competitive advantage and dominance in their business environment. To achieve the intended business report aim, the focus areas included relationship between strategy and corporate; business and functional structures, methods of analysis of supply chain, resources management for supporting development and implementation of strategy and how costs and finances influence supply chains. Through the application of different models and theories (CIPS Module Notes), a set of findings have been generated. The key findings indicate that there exist a direct relationship of strategy and corporate; business and functional structures. In regard to supply chain analysis, various tools are applicable which are qualitative and quantitative. The findings indicate the analysis target areas of supply chain visibility, risk management, competition and improvement areas in their supply chain. Another key finding evidence effective use of resources is dependent on holistic inclusion of all stakeholders. With S-Chem being a conglomerate of various entities, implementing a global commercial strategy would mean that they reduce their costs overruns, increased profitability and dominate the chemicals manufacturing industry. This is since it is aligned to the Key Performance Indicators (KPIs) which impact the contract management and supply chain management.
In line with key findings and conclusions generated, a set of recommendations have been obtained which include;
- Embrace in technology and innovation for purpose of improved analysis of relations of corporate and strategy
- Enhance flexibility of supply chain by improving collaboration of different suppliers
- Actively involve PS&M department in supply chain analysis by predicting and satisfying customer demands
- Update the supply chain network for management of the different identified risks