Develop the roster for the week commencing

Assignment Help Business Management
Reference no: EM133184031

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.

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.

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

f. Calculate the total Wages for the week.

g. Determine if the wage budget of $7200.00 for the week is being met. By how much is it over or under?

Reference no: EM133184031

Questions Cloud

Different types of jobs within the company : Could you please advise what makes them easy and/or difficult to implement and WHY?
Relevant cyber law : What law are you researching (choose a relevant cyber law)? What position do you want to take regarding your chosen law?
Discuss at least two collaboration challenges : Discuss at least two collaboration challenges and describe at least 5 collaboration tools from the market.
Organization of youth sport : What does every youth coach and every parent of youth athlete, regardless of sport, need to know about ensuring the purpose of youth sport matches
Develop the roster for the week commencing : 1. You are required to develop the roster for the week commencing 16 January 2017 to 22 January 2017, using the spreadsheets provided.
Describe how your chosen ethical model impacts : Describe whether you believe healthcare is a right or a privilege. Describe how your chosen ethical model impacts.
Organizational theory-developement : Question: You have been assigned to a class project with five other students, none of whom you have met before, and some of whom come from different countries.
What crime or crimes has maria committed : What crime or crimes has Maria committed? Explain your reasoning, especially with regard to actus rea, mens rea and corpus delicti.
Essay on a tourism or hospitality current event : Prepare a comprehensive research essay on a Tourism or Hospitality current event/hot topic of your choice. (Digitizing customer experience)

Reviews

Write a Review

Business Management Questions & Answers

  Identify the leader name and share the quote

Locate one leadership quote from a real current or former organizational leader. You can write in paragraph

  Identify two forms of market segmentation for your shoes

Identify two forms of market segmentation for your shoes and support your choices.

  Innovation is not the product of logical thought

Einstein once said, "Innovation is not the product of logical thought, although the result is tied to logical structure."

  New policies and procedures to prospective employees

Explain and discuss how you would "market" these new policies and procedures to prospective employees.

  Real strengths they have and the potential contributions

Consider each member in turn, and think of the real strengths they have and the potential contributions they could make. Are you making the most of your diversity as a team?

  Organizational change was made

Select a time, in your organization, where an organizational change was made. Provide details about the change and why it was necessary.

  Difference between telepresence and video conferencing

1: What is the difference between telepresence and video conferencing?

  Digital business-alternative payment systems like paypal

Explain what are the alternative payment systems like Paypal. Why are on-demand service companies viewed as being disruptive and controversial?

  Two major types of taxation theories

Utilizing the two major types of taxation theories, justify why it is necessary for a government to impose taxes on its citizens? Under what circumstances shoul

  Calculate the total project cost

You serve as the energy champion for a large care facility in Calgary, AB. You received a $200,000 grant from the federal government

  Why change is inevitable for organizations

Why change is inevitable for organizations? Discuss this from the point of the recent COVID-19 pandemic.

  Identify statistical methods used to analyze data

Identify statistical methods used to analyze data. Analyze why the business problem is important. Identify what variable would be best to measure for problem.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd