Summative Evaluative Report (Component 1)

CASE STUDY

Fitzpatricks is a large chain of supermarkets and is one of the largest five supermarkets operating throughout the UK. The brand prides itself on the ability to attract good staff and keep them motivated as they appreciate a good level of employee satisfaction is essential to maintaining their performance. You are required to analyse the data provided and complete the following tasks to identify in relation to this organisation;


Task 1: Analyse the summary employee data extracted on 1st December 2021 for stores based in the Yorkshire region to produce a report of the key HRM metrics.


Key HRM metrics to calculate:

Turnover rates

Contract types (PT/FT/Zero Hours)

Variation in Employee Satisfaction Ratings

Gender ratios


Key questions to consider:

What is the proportion of different contract types by store?

Is any type of contract strongly correlated to employee satisfaction?

Does the turnover of staff impact on employee satisfaction?

What is the correlation between FT contracts and turnover rates?

Create a scatter plot of turnover and employee satisfaction then create a least squares regression line to explore these two sets of data. Can you predict what the turnover of staff would be for a store with an employee satisfaction score of 70?

Task 2: Analyse the breakdown of employee data for the store with the lowest employee satisfaction (Brompton) to produce further analysis impacting performance.


Key Metrics to calculate:

Average Length of Service

Average Pay

Age range

Gender ratios

Variation in Performance Scores

Calculate the summary statistics for employee salary


Key questions to consider:

What is the gender pay gap for the Brompton store?

What is the pay ratio between the highest paid employee and the lowest paid employee?

Calculate the summary statistics for employee salary

What proportion of males and females are the top 25% of salary earners?

Does the age of employee impact on the length of service?

Is there a relationship between employee performance and salary?

What is the percentage of males and females by contract type?


Presentation: Your assignment should be presented in a report format which includes the relevant data presentation and representation, along with a summary of findings from your analysis.

The assessment requirements will be focused on HR metrics and the use of the analytical models to analyse the given data set, such as:

examining the relationship between two variables (e.g. correlation).

predicting values of a variables based on existing correlation between two variables.

calculating the proportions of some data characteristics.

Calculation ratios

Calculate the summary statistics.


Guidance:

The assignment is a written report (50% weighting). Your response to the question requires you to:

Conduct a wide research on the HR metrics and expand your reading.

Using appropriate data analysis methods, analyse the employee data in the context of the allocated case study to calculate key HRM metrics in response to key questions. Develop a report that presents the data clearly to illustrates the findings and provides clear explanations.

Word Length 2,000 words (+/- 10%) Charts/ diagrams should be included within the report and are excluded from the overall word-length.

Acknowledge all sources and references throughout, using the Harvard referencing system within the main body of your assignment and bibliography, Further information is available on the university Skills for Learning website.

Analytical in nature. Ensure any findings are justified through the analysis and aim to provide rationale for any judgement.


What Students Are Saying About Us

.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐
"Honestly, I was afraid to send my paper to you, but you proved you are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"

.......... Customer ID: 11***| Rating: ⭐⭐⭐⭐⭐
"This company is the best there is. They saved me so many times, I cannot even keep count. Now I recommend it to all my friends, and none of them have complained about it. The writers here are excellent."


"Order a custom Paper on Similar Assignment at essayfount.com! No Plagiarism! Enjoy 20% Discount!"