please solve only question 4 and 5. thanks

Alpaca Farms requires some help with some of their month end functions. There are 5 separate tasks. They can be performed in any order. (87 marks) 1. Prepare a Bank Reconciliation based on the two documents provided for September 30, 2020. 113 Gera Lady Rocourt 08H De Description ORP Opening Lelance 07 Sep Cheque 1412 ces Cheque 1500 - Emert 168pchegue inventory 19 Sep Cheque 2 ep Chero GG De Gde are GOOOH S0000 300.00 2.300.00 2300000 . 230000 BOOTCH 8630 SS.COM BANKSTATEIE De Description Windows Deposit 01 Sep Opening Blog 840000 07 Sportart 130000 Sep 0 16-Sep Cheque 1901 000 19 Sep Chege 1 230000 415000 19SP NSFO 200.00 195 NFC ODO 181000 3D&p Inforest 8000 1890.00 Note: In case of any discrepancy between dollar amounts assume the bank statement is correct. 2. Create a Trial Balance for Alpaca Farms using the accounts and corresponding normal balances provided below: 13 mars Account Balance Farmer Brown, Capital 22.400.00 Accounts Payable 13.200.00 Insurance Expense 1.000.00 Service Revenue 6.800.00 Equipment 30,500.00 Supplies Expense 2,900.00 Cash 7,700.00 Salaries Expense 4.100.00 Farmer Brown Withdrawals 3,100.00 Rent Expense 2,200.00 Telephone Expense 1.200.00 Bank Loan 11,700.00 Prepaid Rent 1.400.00 3. Prepare two journal entries based on the following information: 10 marks) a) Record the establishment of a Petty Cash Fund - Sept 1st b) Record the reimbursement of the Petty Cash fund on Sept 30th On September 1, 2020, Alpaca Farms established a petty cash fund of $200. During the month Farmer Brown paid out the following amounts. Sep 6 Purchased stamps for S40 Sep 8 Paid a S20 delivery charge on an outgoing package Sep 10 Paid S25 for public transit fares for employees on company business Sep 14 Purchased coffee and doughnuts for S8 for clients during a meeting Sep 15 Bought a package of paper for 7 for the copy machine Farmer Brown counted the fund on Sept 16 and found S105 in the petty cash box. 4. The payroll records of Alpaca Farms provided the following information for the weekly pay period ended December 27, 2020. FR Employee Hours Hourly Rate Income Tax CPP Union Dues Fred Moo 43 $ 12.00 61.00 24005 9.005 10.00 Kerry Cluck 46 $ 15.00$ 101.00 34.00 $ 12.00 $ 20.00 Jessie Wool 48 $ 17.00 $ 134.00 $ 42.00 14.00 5 10.00 Stephen Hay 40 s 14.00 66.00 25.00 9.00 $ 10.00 Note All employees are paid 1.5 times their hourly wage for hours worked in excess of 40 hours per week. The company contributes 100% for its share of CPP and 140% of EL Required a) Calculate gross and net pay for each employee. Round all answers to the nearest whole number. (20 marks) Grom Emre's C Income OPP Empers Cost:CPP Unionum Employee Fred Me Kamyud lessie Wool Stephen To b) Prepare the payroll journal entries for December 27, 2020 (1) marks) Prepare a journal entry to record cash payment of the payroll liabilities due to the CRA on January 15, 2020. (4 marks) s. Perform a horizontal analysis for Alpaca Farms Use 2017 as the base year (14 marks) Alpaca Farms Income Statement (in Thousands) For Years Ended Dec 31, 2017-2019 Revenue Expenses Net Income 2019 1,234 907 327 2018 1.100 1,009 91 2017 988 678 310 A table has been provided to conduct the analysis. 2019 Alpaca Farms Horizontial Analysis For Years Ended December 31, 2017-2019 2018 of Xof Chance Value Xof 2017 Change 2017 Value % of 2017 Value of Chance of 2017 Revenue Expenses Net Income