Question #3 (10 marks) Worksheet 3. Adult Bar Company Payroll Using your knowledge of spreadsheet software, using formulas and functions where appropriate, make a spreadsheet for the following company payroll. Payroll refers to how much you as the business owner need to pay your employees for their labour. You have fifteen employees on the payroll. See the table below. Managers are paid $29.00 per hour. For the other employees you will decide their minimum wage based on their position, age, and hours worked. See guideline below. Wait staff serve liquor and busboys dont A "normal" work week is 40 hours. Anything over 40 hours is overtime. Overtime hours are paid at a rate of 1.5 times their normal hourly wage. Determine how much each employee is owed based on the table below for one week Total all the wages paid to employees to get a grand total of how much money you will spend on payroll for this pay period. Use borders and shading. Your spreadsheet might look something like this: Employee Age Position Wage Hours Pay A. Arms 25 Manager 60 B. Boyd 32 Manager 55 C. Carmen 23 Wait staff 33 D. Donald 22 Wait staff 45 E. Ericson 21 Wait staff 19 F. Falcone 19 Wait staff 28 G. Gomes 24 Wait staff 36 H. Homes 22 Wait staff 48 I. lotona 21 Wait staff 35 J. Jones 20 Wait staff 48 K. Katt 19 Wait staff 35 L. Lemon 18 Busboy 35 M. Mariani 18 Busboy 25 N. Nichols 17 Busboy 25 O. Ostram 17 Busboy 32 ONTARIO MINUMUM WAGE RATES Minimum Wage Rate Current Rates: Rates as of January 1, 2018 General Minimum Wage $14.00 per hour Student Minimum Wage $13.15 per hour Liquor Servers Minimum Wage $12.20 per hour NOTES: Student minimum wage - This rate applies to students under the age of 18 who work 28 hours a week or less when school is in session, or work during a school break or summer holidays. If a student works more than 28 hours a week, then they are paid the general minimum wage. Liquor servers minimum wage - This hourly rate applies to employees who serve liquor directly to customers or guests in licensed premises as a regular part of their work