Answered step by step
Verified Expert Solution
Question
1 Approved Answer
all of the questions EMPLOYEES & PAYROLL Module Setup and Processing UDO Challenge Exercise 07 C7-2, Glass (EMPLOYEES & PAYROLL, PAYABLES and COMPANY Modules) The
all of the questions EMPLOYEES & PAYROLL Module Setup and Processing UDO Challenge Exercise 07 C7-2, Glass (EMPLOYEES & PAYROLL, PAYABLES and COMPANY Modules) The company sells assorted glasses and glassware products to both wholesale and retail customers. This exercise is a review of the EMPLOYEES & PAYROLL, PAYABLES and COMPANY modules. 1 Refer to Exercise 1-1b to unzip the 07 C7-2 Glass.exe file 2 Open the 07 7C-2 Glass file Payroll information: All employees are paid as noted in the information below. Overtime is paid at time and a half (regular pay plus % regular pay). Vacation pay (4%) is retained from hourly and commission employees, until the employee takes a vacation. Vacation pay is not calculated for salaried employees. The El rate is 1.4% times the employee deductions. It is assumed that the employee is exempt from the Employee Health Tax (EHT). Union Dues are deducted from hourly and commission employees' paycheques. The company has a pension plan. The Company allows employees to receive a payroll loan up to $700.00 for extenuating circumstances The loan is repayable by all employees at $20.00 per pay. There are no outstanding loans. January Hourly and commission employees are paid weekly Pay Dates: Salaried employees are paid bi-weekly (4th and 18th). Weekly January 3 Deductions per pay period: Medical Pension Union Dues Safety Shoes January 10 Hourly employees: January 17 Commission employees: January 24" Salary employees: Bi-Weekly January 3 January 17 T 3> Record and Post the following transactions for January. Change employee "A-YOUR ACTUAL LAST, First Name to your own name before processing Jan 2 Received "Memo Sal-Rev' from the owner to reverse the December 31" payroll accrual in the amount of $1,500 for all employees. (The total accrual for wages and salaries was accrued in Salaries Expense at Dec 31, 2024.) Jan 3 Process a payroll cheque run for ALL pay periods. Note: A-YOUR ACTUAL LAST, First Name worked 40 hours + 4 hours overtime, and Valerie Kott worked 40 hours and earned $450 in commissions Jan 6 Valerie Valerie Kott phoned this morning requesting one week off for personal reasons and asked for her vacation pay. Released total vacation pay owing (40 hours) as of January 4". Did not deduct for medical plan or union dues. Learning Sagd b om 7-436 Jan 13 Vibeke Ipanaque and Hardeep Singh both returned to work today. They will each be working just one week in this pay period (ending Jan. 17). Make sure their employee setup reflects this (income tab) to ensure taxes will be deducted properly. Return Vibeke Ipanaque to Active Employee" status. Jan 13 Jan 15 Canada Revenue Agency (CRA) payroll auditor arrived today to do an audit on the previous year's payroll records. The payroll auditor verified that the previous year's files and records were in order. The manager approved issuing the next cheque to the Receiver General, for December 31, amount owing for PAYROLL amounts (Trial Balance amounts at January 1). Jan 17 Pay by Payroll Cheque Run, pay period effective today. Singh, Hardeep for 40 hours. She is repaying her loan by $20.00 per pay Ipanaque, Vibeke for $912.00 commission for 40 hours Lions, Herve for 80 hours and 1 hour overtime A-YOUR ACTUAL Last, First Name Salary (80 hours per period) After the payroll cheque run is completed, return Vibeke and Hardeep to 26 pay periods per year. Jan 20 The owner has given you a memo to update the accounting records by recording a payroll accrual for $976.00 salary and $350.00 commission, for the period ending today. The owner needs the reports, listed below, for a meeting with the bank. 4 > Print the following reports for the manager for his meeting with the bank manager. a) Balance Sheet b) Income Statement (All amounts will be zero, except for payroll) c) Payroll Journal Entries, with corrections, to January 20 d) All Journal Entries, with corrections, for the same period e) General Journal Entries for the same period f) Cheque log for January 1 to January 20 EMPLOYEES & PAYROLL Module Setup and Processing UDO Challenge Exercise 07 C7-2, Glass (EMPLOYEES & PAYROLL, PAYABLES and COMPANY Modules) The company sells assorted glasses and glassware products to both wholesale and retail customers. This exercise is a review of the EMPLOYEES & PAYROLL, PAYABLES and COMPANY modules. 1 Refer to Exercise 1-1b to unzip the 07 C7-2 Glass.exe file 2 Open the 07 7C-2 Glass file Payroll information: All employees are paid as noted in the information below. Overtime is paid at time and a half (regular pay plus % regular pay). Vacation pay (4%) is retained from hourly and commission employees, until the employee takes a vacation. Vacation pay is not calculated for salaried employees. The El rate is 1.4% times the employee deductions. It is assumed that the employee is exempt from the Employee Health Tax (EHT). Union Dues are deducted from hourly and commission employees' paycheques. The company has a pension plan. The Company allows employees to receive a payroll loan up to $700.00 for extenuating circumstances The loan is repayable by all employees at $20.00 per pay. There are no outstanding loans. January Hourly and commission employees are paid weekly Pay Dates: Salaried employees are paid bi-weekly (4th and 18th). Weekly January 3 Deductions per pay period: Medical Pension Union Dues Safety Shoes January 10 Hourly employees: January 17 Commission employees: January 24" Salary employees: Bi-Weekly January 3 January 17 T 3> Record and Post the following transactions for January. Change employee "A-YOUR ACTUAL LAST, First Name to your own name before processing Jan 2 Received "Memo Sal-Rev' from the owner to reverse the December 31" payroll accrual in the amount of $1,500 for all employees. (The total accrual for wages and salaries was accrued in Salaries Expense at Dec 31, 2024.) Jan 3 Process a payroll cheque run for ALL pay periods. Note: A-YOUR ACTUAL LAST, First Name worked 40 hours + 4 hours overtime, and Valerie Kott worked 40 hours and earned $450 in commissions Jan 6 Valerie Valerie Kott phoned this morning requesting one week off for personal reasons and asked for her vacation pay. Released total vacation pay owing (40 hours) as of January 4". Did not deduct for medical plan or union dues. Learning Sagd b om 7-436 Jan 13 Vibeke Ipanaque and Hardeep Singh both returned to work today. They will each be working just one week in this pay period (ending Jan. 17). Make sure their employee setup reflects this (income tab) to ensure taxes will be deducted properly. Return Vibeke Ipanaque to Active Employee" status. Jan 13 Jan 15 Canada Revenue Agency (CRA) payroll auditor arrived today to do an audit on the previous year's payroll records. The payroll auditor verified that the previous year's files and records were in order. The manager approved issuing the next cheque to the Receiver General, for December 31, amount owing for PAYROLL amounts (Trial Balance amounts at January 1). Jan 17 Pay by Payroll Cheque Run, pay period effective today. Singh, Hardeep for 40 hours. She is repaying her loan by $20.00 per pay Ipanaque, Vibeke for $912.00 commission for 40 hours Lions, Herve for 80 hours and 1 hour overtime A-YOUR ACTUAL Last, First Name Salary (80 hours per period) After the payroll cheque run is completed, return Vibeke and Hardeep to 26 pay periods per year. Jan 20 The owner has given you a memo to update the accounting records by recording a payroll accrual for $976.00 salary and $350.00 commission, for the period ending today. The owner needs the reports, listed below, for a meeting with the bank. 4 > Print the following reports for the manager for his meeting with the bank manager. a) Balance Sheet b) Income Statement (All amounts will be zero, except for payroll) c) Payroll Journal Entries, with corrections, to January 20 d) All Journal Entries, with corrections, for the same period e) General Journal Entries for the same period f) Cheque log for January 1 to January 20
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