AutoSave . OFF A ? . CFO ... w 2022 Baro Industries - Payroll information Home Insert Draw Design Layout References Mailings Review View Acrobat ? Tell me Share Comments Calibri (Bo... 11 AA Aa Ap AL AaBbCcDdEe AaBbCcDdEe AaBbCcD Paste BIU 1vab X2 Av L Av E Normal No Spacing Heading 1 Styles Dictate Sensitivity Editor Create and Share Request Pane Adobe PDF Signatures 16 Baro Industries - BC Company Instructions You are the new payroll officer for Baro Industries. No one in the office knows how to do payroll. You are on your own. You are confident you can get the job done. You know where to look to find all the information needed. December 23, 2022 is the last pay period of the calendar year. Pay day is Dec 30, 2022. You will need to: 1. Tally the employees hours worked on the Payroll Register 2. Calculate the all withholdings, CPP, El, Federal and Provincial Income Taxes 3. Update the Employee Individual Earnings Record Journalize the payroll, the employees are paid the following Friday. 5. Answer the question on the General Journal Sheet, page 3. Baro Industries Payroll Time Sheet Pay Period #26 December 9 to 23, 2022 Employee Week 1 Week 2 Total No. Name 1 2 3 4 5 6 7 Total 8 9 10 11 12 13 14 Total Hours S01 St. Pierre, Peter 506 Wong, Anabel W12 Mcpherson, Will 8 8 8 8 8 2 42 8 8 8 8 8 1 41 83 W15 | Wissinski, Lindy 8 8 8 8 8 41 8 8 8 41 82 W23 Gortva, Eva 8 8 8 24 8 8 8 24 48 Page 1 of 3 360 words X English (United States) Focus E + 130%AutoSave . OFF A ? . CFO ... w 2022 Baro Industries - Payroll information Home Insert Draw Design Layout References Mailings Review View Acrobat ? Tell me Share Comments Calibri (Bo... 11 A A Aa Ap AL AaBbCcDdEe AaBbCcDdEe AaBbCcD Paste BI Uv ab *2 Av L Av Normal No Spacing Heading 1 Styles Dictate Sensitivity Editor Create and Share Request Pane Adobe PDF Signatures 18 Employee information: St. Pierre, Peter, Salary Employee Bi-Weekly rate $2500.00 Federal Net Claim Code Provincial Net Claim Code Wong, Anabel Salary Employee Bi-Weekly rate $2000.00 Federal Net Claim Code Provincial Net Claim Code McPherson, Will Wage Pay Hourly Pay Rate $16.00 Federal Net Claim Code 1 Provincial Net Claim Code Wissinski, Lindy Wage Pay Hourly Pay Rate 20.00 Federal Net Claim Code vincial Net Claim Code Gortva, Eva Wage Pay Hourly Pay Rate 18.00 Federal Net Claim Code 5 Provincial Net Claim Code 5 CPP - July 1, 2022 Maximum Pensionable Earnings Annual basic Exemption Maximum Contributory Earnings Contribution Rate Maximum Employee Contributions El - July 1, 2022 Maximum Annual Insurable Earnings Premium rate Maximum Annual Employee Premium Page 2 of 3 360 words QX English (United States) Focus E 120%AutoSave . OFF A ? . CFO ... w 2022 Baro Industries - Payroll information Home Insert Draw Design Layout References Mailings Review View Acrobat ? Tell me Share Comments Calibri (Bo... 11 A A Aa Ap AL AaBbCcDdEe AaBbCcDdEe AaBbCcD Paste B I Uv ab Av LAV EE E Normal No Spacing Heading 1 Styles Dictate Sensitivity Editor Create and Share Request *2 Pane Adobe PDF Signatures 16 Journalize the payroll entries: Baro Industries GENERAL JOURNAL Question: #1) Complete the journal entry for the December remittance due in January. Page 3 of 3 360 words QX English (United States) Focus E 110%AutoSave OFF A A FC ... 2022 Baro Industries - Payroll Journal and Register Home Insert Draw Page Layout Formulas Data Review View Acrobat ? Tell me Share Comments Calibri (Body) 11 AA do v General Conditional Formatting Insert v O Format as Table Delete v Paste BIUv A v % 9 Sort & Find & Analyze Sensitivity Create and Share Cell Styles v Format v Filter Select Data Adobe PDF A4 X V fx B D E G H M N P Q R S T U V W Baro Industries Payroll Registe D W N H Pay Period #26 December 9 to 23, 2022 OverTime Rate Total Reg OverTime Regular Premium EI Fed. Prov. Total Salaries Wages 5 Employee of pay Hours Hours Pay Pay Gross Pay CPP Premiums Income tax Income Tax Deductions Net pay Expense Expense 6 No. Name SO1 St. Pierre, Peter 8 Wong, Anabel 9 W12 Mcpherson, Will 10 W15 Wissinski, Lindy 11 Gortva, Eva 12 TOTALS 13 37 Employee Earnings Records Payroll Register + Ready 100%