Question
Fina-3048 S20 Labour Costing Assignment The purpose of this assignment is demonstrating the payroll calculations and Labour Cost calculations for a business that can be
Fina-3048 S20
Labour Costing Assignment
The purpose of this assignment is demonstrating the payroll calculations and Labour Cost calculations for a business that can be used to analysis the efficiency and quality of work provided by employees.
Submit the completed assignment to the submission folder before: Wednesday June 28/23 at 11:59 pm (est)
The Rolling Rock Restaurant records its payroll weekly for salaried and hourly rate employees separately.In the restaurant the tips are controlled and distributed to employees by their assigned percentage. During the past week $1525.00 was collected as tips from customers.
The statutory deduction rates for 2023 are:
CPP - 5.95%, EI - 1.58%, Income Tax - 22.4%, Vacation pay is accrued at a rate of 4%.
Instructions:
- Using the information provided, complete the payroll chart on the following page.
- How much will be spent on overtime wages?
- Calculate the CPP exemption for payroll being paid weekly.
- Add a column at the end of the chart to calculate the accrued vacation pay for each employee.
- Assuming the employer's contribution is 100% for Canada Pension Plan and 140% for Employment Insurance, what is the employer's total expense for the week?
- How much is the total labour cost for the week including the vacation pay and employer contribution that will be paid out a later date?
- Calculate the labour cost percentage for the week if total sales for the week were $ 58,740.
- The managers want to analysis the performance and efficiency of the staff by calculating the Sales per Person. Using the total sales of $ 58,740, Calculate the Sales per Person for the Restaurant
- Since the kitchen works as a team, Calculate the Sales per Person Hour for the kitchen staff, using the total sales of$ 58,740. Remember that some of the kitchen staff is paid salary and some are paid an hourly rate.
| Position | Hours Worked | Hourly Rate/Annual Rate | Regular Earnings | Overtime Earnings | Total Earned | Controlled Tips % | Controlled Tips | Gross Pay | CPP | EI | Income Tax | Net Pay | |
| Department/ Employee | |||||||||||||
| Salaried Employees | Chef | 65 | $ 65,000.00 | ||||||||||
| Hoban, Jack | Asst. Manager | 50 | $ 35,103.00 | ||||||||||
| Lee, Kwan | DR Manager | 60 | $ 70,226.00 | ||||||||||
| Mubutu, Ali | Sou Chef | 55 | $ 40,000.00 | ||||||||||
| Yoaz, Leah | |||||||||||||
| Subtotal | |||||||||||||
| Hourly Employees | |||||||||||||
| Ali, Baba | Server | 20 | $ 16.00 | 7.67% | |||||||||
| Cameron, Tia | Server | 16 | $ 16.00 | 9.59% | |||||||||
| Ervin, John | Server | 40 | $ 16.25 | 7.29% | |||||||||
| Jasmeen Kaur | Server | 36 | $ 16.00 | 5.97% | |||||||||
| Kohl, Akashdeep | Cook | 40 | $ 18.50 | 14.56% | |||||||||
| Miser, Colin | Cook | 45 | $ 17.25 | 15.20% | |||||||||
| Torbot, Jessica | Kitchen Help | 24 | $ 16.00 | 13.43% | |||||||||
| William, Angel | Server | 38 | $ 16.00 | 7.29% | |||||||||
| Wood, Cyndy | Server | 39 | $ 16.00 | 7.30% | |||||||||
| Brittany Jones | Dishwasher | 44 | $ 16.00 | 3.90% | |||||||||
| Whitney Houston | Dishwasher | 12 | $ 15.00 | 3.90% | |||||||||
| Boris Jeltzen | Dishwasher | 18 | $ 15.00 | 3.90% | |||||||||
| Subtotal | 100.00% |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Tourism Concepts And Practices
Authors: John R Walker, Josielyn T Walker
1st Edition
0138142459, 9780138142452
