Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles Of Taxation For Business And Investment Planning 2023

Authors: Sally Jones, Shelley Rhoades-Catanach, Sandra Callaghan, Thomas Kubick

26th Edition

1264229747, 978-1264229741

Students also viewed these Accounting questions

Question

c. What are the job responsibilities?

Answered: 1 week ago