Calculate the wages for each staff member

Assignment Help HR Management

Reference no: EM133034116

SITXHRM002 Roster staff

Assessment 2

PART A
Your Tasks

All relevant information relating to awards and award conditions must be sourced from the attached website

1. You are required to develop the roster for the week commencing 16 January 2017 to 22 January 2017, using the spreadsheets provided.

Note: The information provided below includes a 30 minute meal break for each staff member. You will need to use the Roster spreadsheet to develop this staff roster on the first Tab.

Mark (Front Office grade 1) - will be working from 13.30 - 22.00 on Wed, Thurs, Fri and Sun and from 13.30 - 20.00 on Sat.

Tom (Front Office grade 1) - will be working from 6.00 - 14.30 on Mon, Tues, Wed and Sun and from 6.00 - 12.30 on Saturday.

Jordan (Front Office grade 1) - will be working from 22.00 - 6.30 Tues, Wed, Thurs and Fri and from 24.00 - 6.30 on Sat.

Sam (Front Office grade 2) - will be working from 15.30 - 22.00 on Mon, from 6.00 - 14.30 on Thurs, Fri and Sat and from 13.30 - 22.00 on Sun.

Shelly (Front Office grade 2) - will be working from 13.30 - 22.00 on Mon, Tues, Wed and Thurs and from 13.30 - 20.00 on Fri.

Darren (Front Office grade 3) - will be working from 22.00 - 6.30 on Mon, Fri, Sat and Sun and from 24.00 - 6.30 on Tues.

Scott (Front Office Supervisor) will be working from 6.00 - 14.30 on Mon, Tues, Wed and Sun and from 6.00 - 12.30 on Thurs.

Margaret (Front Office Supervisor) - will be working from 15.30 - 22.00 on Tues, 13.30 - 22.00 on Wed and Sat, 12.30 - 21.00 on Thurs and from 6.00 - 14.30 on Fri.

Part B:

Your Tasks

2. Once you have developed the roster based on the above information, transfer the roster on TAB Part A and:

a. Check if each employee has at least two rostered days off in the week. Highlight these days in grey colour.

b. Calculate the weekly wages for each of the staff.

c. Calculate work hours for the week for each staff member.

d. Locate the correct hourly rate for each staff member based on their award including penalty rates which apply for specific times during weekdays and for Saturdays and Sundays.

d. Calculate the wages for each staff member for the week for this roster.

e. Calculate the total Wages for the wee

Attachment:- Roster staff.rar

Reference no: EM133034116

Questions Cloud

Calculate the Current ratio for Lawson and Dawson : Discuss two limitations of ratio analysis as a fundamental analysis tool. Calculate the Current ratio for Lawson and Dawson

Explain the communication strategies : Explain the communication strategies (what you would do or say) you would use to respond to client's complaints

Explain the annual compounding and constant reinvestment : 1a) You will need $3,000 for a lump sum payment to a friend. If you have $1,200 today to invest at 6% per year, how long will it take to grow to the desired

Strengths and limitations of social identity theory : What are the strengths and limitations of Social Identity Theory when reviewing it from the lens of corporate social responsibility?

Calculate the wages for each staff member : Calculate the wages for each staff member for the week for this roster and Calculate work hours for the week for each staff member

Social and cultural skill mix in the hospitality industry : Provide examples for benefits for using a social and cultural skill mix in the hospitality industry and different religious and cultural beliefs

Explain the professional online presence : What are some things you can do now to ensure you have a professional online presence and that employers will not find information about you that may negatively

Safe and hygienic use of equipment : List 4 general requirements for the safe and hygienic use of equipment including provisions for reporting any issues:

Definition of the concept of service quality : 1. Present three unidimensional and three multidimensional abstract concepts. Explain why these concepts have either one or more than one dimension.

User Account

All Pages