Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Make An Excel file a) Create a payroll liabilities schedule with the following items ( Gross pay, Ei Premium, Income taxes, Hosp. Ins. , CPP,
Make An Excel file
a) Create a payroll liabilities schedule with the following items ( Gross pay, Ei Premium, Income taxes, Hosp. Ins. , CPP, union dues, Total deductions, net pay, office salaries, sales salaries). Assume the following information to calculate pay; (office worker \#1 Hourly wage $35.00, total number of hours worked per week 37.5 ), (Sales worker \#1 Hourly wage $25.00, total number of hours worked per week 45), (office worker \#2 Hourly wage $15.00, total number of hours worked per week 20). [ 20 marks] b) Create journal entries for each employee with the appropriate accounts. [ 20 marks] 5) Write 3 interesting facts/ lessons you have learnt in the course so far? [ 5 marks] 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