(Solution) 5CO02 (AC2.1) With reference to a people practice issue, interpret analytical data using appropriate analysis tools and methods
New User Gifts
First Order Deal get Ksh 200 Off.
Original price was: £ 40.00.£ 10.00Current price is: £ 10.00.
Payment Methods:
Description
Solution
Table 1 Data
All department’s performance review judgements as a percentage:
| Department | Quarter | Outstanding | Meets KPIs | Not Quite There | Underperforming |
| Administration Department | 1 | 1 Absent (11-1=10)
2/10 x100= 20% |
1 Absent (11-1=10)
2/10 x100= 20% |
1 Absent (11-1=10)
3/10 x100= 30% |
1 Absent (11-1=10)
3/10 x100= 30% |
| 2 | 1 Absent (11-1=10)
1/10 x100= 10% |
1 Absent (11-1=10)
4/10 x100= 40% |
1 Absent (11-1=10)
4/10 x100= 40% |
1 Absent (11-1=10)
1/10 x100= 10% |
|
| Sales Department | 1 | 100.00% | 0.00% | 0.00% | 0.OO% |
| 2 | 0.00% | 100.00% | 0.00% | 0.00% | |
| Logistics Department | 1 | 4/10 x100=
20% |
8/10 x100=
40.00% |
6/10 x100=
30.00% |
2/10 x100=
10.00% |
| 2 | 5/20-2 Absent x100=
27.78% |
9/20-2 Absent x100=
50.00% |
4/20-2 Absent x 100= 22.22% | 0.00% | |
| Research & Development | 1 | 3/10 x100=
30.00% |
3/10 x100=
30.00% |
1/10 x100=
10.00% |
3/10 x100=
30.00% |
| 2 | 1 Absent =(10-1=9)
5/9 55.55 |
1 Absent =
3/9 33.33% |
1 Absent =
1/9 11.11% |
0.00% |
Bonus Payments Calculation for ‘Outstanding’ Employees
Each eligible employee in the administrative department had their bonus payments added together during the first quarter to determine their overall bonus payment. This was the entire bonus sum that was due for that particular division and time period.
Formulae for Bonus: Salary x 0.04
| Department | Employee | Salary | Bonus | Quarter |
| Administration | Saffron Finch | £24,000 | £960 | Q1 |
| Robin Bird | £31,500 | £1,260 | Q1 | |
| Logistics | Sally Rigbye | £23,750 | £950 | Q1 |
| Julie Chisnall | £19,500 | £780 | Q1 | |
| Rick Lovall | £19,500 | £780 | Q1 | |
| Gill Jamieson | £19,500 | £780 | Q1 | |
| Research & Dev. | Ethan Brar | £32,500 | £1,300 | Q1 |
| Tasha Graham | £29,500 | £1,180 | Q1 | |
| Jennifer Frost | £29,500 | £1,180 | Q1 | |
| Administration | Saffron Finch | £24,000 | £960 | Q2 |
| Logistics | Ruth Sixsmith | £23,750 | £950 | Q2 |
| Wendy Boot | £23,750 | £950 | Q2 | |
| Jean Livesey | £26,000 | £1,040 | Q2 | |
| Julie Chisnall | £19,500 | £780 | Q2 | |
| Gill Jamieson | £19,500 | £780 | Q2 | |
| Research & Dev. | Ethan Brar | £32,500 | £1,300 | Q2 |
| Harrison Briggs | £32,500 | £1,300 | Q2 | |
| Tasha Graham | £29,500 | £1,180 | Q2 | |
| Jennifer Frost | £29,500 | £1,180 | Q2 | |
| Steve Owen | £29,500 | £1,180 | Q2 | |
| Total | £9,170 | Q1 Total | ||
| £11,600 | Q2 Total | |||
| £20,770 | Overall Total |
Summary of Bonus Payments
| Quarter | Total (£) |
| Quarter 1 | £9,170 |
| Quarter 2 | £11,600 |
| Overall Total | £20,770 |
Bonus Information Analysis
The Administration and Logistics teams earned constant awards in both Q1 and Q2, demonstrating consistent performance across departments, according to the bonus data. Particularly in the second quarter, a larger number of employees in the Logistics and Research & Development divisions received incentives. Bonuses went up from £9,170 in Q1 to £11,600 in Q2, which could be attributed to more output or better performance reviews in the second quarter.
Please click the following icon to access this assessment in full
Related Papers
(Solution) short summary of your current work role or if you are not currently in work, a short summary of your recent work experience
(Solution) CIPS Strategic Supply Chain Management APSS
- The supply chain mapping for an organisation spend category is influenced by several elements, among them environmental scanning to identify the micro and macro factors.
- Other aspects considered in the mapping are the facilities, location, and time.
- In the implementation process, it involves making suitable changes and adding value to the process.
- Drawing from the STEEPLE, Porter’s five forces, SWOT analysis, and Kraljic matrix, some of the key elements are the relationship with the vendors, consideration of various competitors, and ensuring customised category of spend.
- Quality and timely delivery of the spend category is also an important consideration area.