Week 14 - Payroll Homework Assignment - Excel simranjit singh rakhra ($5 X File Home Insert Page Layout Formulas Data Review View Help Acrobat Tell me what you want to do d Cut Arial - 12 - A A = al Wrap Text General EX _ AutoSum AY O Copy Fill Paste BIULA Merge & Center $ ~ % " Conditional Format as Cell Insert Delete Format Sort & Find & Format Painter Formatting " Table " Styles Clear Filter ~ Select ~ Clipboard Font Alignment Number Styles Cells Editing 114 X V fx A B C D E F G H J K L M N O P Q R C & R TOYS IN GENERAL JOURNAL PAGE 4 Date Account Titles and Description PR Dr. Cr. Co 21 22 23 24 25 ... 26 Payroll Register Gen. Journal Ledger + Ready Accessibility: Investigate 100% AMC +6.94% Search X P O W ENG 8:40 AM US 2023-04-11Week 14 - Payroll Homework Assignment - Excel simranjit singh rakhra ($5 X File Home Insert Page Layout Formulas Data Review View Help Acrobat Tell me what you want to do d Cut Arial - 12 - A A = _ AutoSum al Wrap Text General EX AY O Copy Fill Paste Format Painter Merge & Center $ ~ % " Conditional Format as Cell Insert Delete Format Sort & Find & Formatting " Table . Styles ~ Clear Filter ~ Select Clipboard Font Alignment Number Styles Cells Editing J53 I X V fx A B C D E G H J K L M N O P Q R S T Date Explanation Post Ref. Debit Credit Dr/Cr Balance CO 10 INCOME TAX PAYABLE ACCOUNT NO. 210 Date Post Explanation Ref. Debit Credit Dr/Cr Balance 14 16 17 19 CPP PAYABLE ACCOUNT NO. 212 20 Date Post Explanation Ref. Debit Credit Dr/Cr Balance 21 22 23 24 25 26 EI PAYABLE ACCOUNT NO. 214 27 Date Post Explanation Ref Debit Credit Dr/Cr Balance 28 29 30 31 I ... Payroll Register Gen. Journal Ledger + Ready * Accessibility: Investigate 100% AMC Search X P ENG 8:40 AM +6.94% LOHCO W US 2023-04-11Week 14 - Payroll Homework Assignment - Excel simranjit singh rakhra ($5 X File Home Insert Page Layout Formulas Data Review View Help Acrobat Tell me what you want to do d Cut - 12 AA = al Wrap Text General EX _ AutoSum Arial AY O Copy Fill Paste Format Painter BIULA Merge & Center $ ~ % " Conditional Format as Cell Insert Delete Format Sort & Find & Formatting " Table " Styles Clear Filter ~ Select ~ Clipboard Font Alignment Number Styles Cells Editing L19 X V fx A B C D E G H J K L M N O P Q C & R TOYS PAYROLL REGISTER FOR OCTOBER 18, 2023 W N Employee Net Claim Deductions Name Code Weekly Salary Net Pay Chq. No. IT CPP EI Union Dues Medical Insurance lan King 945.00 10.00 29.00 72 8 Frank Pearson 972.00 10.00 29.00 73 - NOW Emma Taylor 1, 143.00 10.00 74 10 Leslie Smith 892.00 10.00 29.00 75 11 12 13 14 15 Instructions 16 1. Calculate Income Tax (20.05), CPP (5.95%), and El (1.53%) for each employee in the Payroll Register 17 2. Other payroll deductions have been added for you (i.e. Union Dues and Medical Insurance). Note that Emma Taylor doesn't contribute to Medical Insurance as she is covered by her husband's plan 18 3. Calculate net pay for each employee 19 4. Calculate totals for each column 20 5. Journalize the entry to record the weekly payroll on October 18, 2023 21 6. Journalize the entry to pay the employees on October 20, 2023 22 7. Post both transactions to the General Ledger 23 24 25 26 27 I ... Payroll Register Gen. Journal Ledger + Ready * Accessibility: Investigate 100% AMC Search X P W ENG 8:40 AM +6.94% LOCO US 2023-04-11