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./15 mark) G D C General Leder Acourt C Date Description 01 Sep Opening Bence 07-Sep Cheque 12 168 Chervertory 198pchoge 1 2 Gap Cheque 5000 4800.00 00.00 8.400.000 8.300.000 410000 DR 6.OR 5.000 SODOH 2.300.00 BANK STATEMENT Date Description Window Deposit BE 01 Sep Opening aange B.40000 07 Sparta Prayer 130000 710000 Sep OGO 1628p Cheque 1901 1000 19 Sepet 230000 415000 19 Sep NSF Chege 18 2300.00 185000 198p SFO 000 TO 30 Spinterest 80.00 583000 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 ist b) Record the reimbursement of the Petty Cash fund on Sept 30th On September 1, 2020, Alpaca Farms established a petty cash fund of S200. During the month Farmer Brown paid out the following amounts. Sep 6 Purchased stamps for $40 Sep 8 Paid a $20 delivery charge on an outgoing package Sep 10 Paid $25 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 57 for the copy machine Farmer Brown counted the fund on Sept 16 and found Sles in the petty cash box. Prepare two journal entries based on the following information: a) Record the establishment of a Pelly Cash Fund Soptist b) Record the reimbursement of the Petty Cash finden Sort 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 statips for $40 Sep 8 Paid a $20 delivery charge on an outgoing package Sep 10 Paid S25 for public transitores for employees en company business Sep 14 Purchased coffee and doughnuts for Ss for clients during a meeting Sep 15 Bought a package of paper for 57 for the copy machine Farmer Brown counted the fund on Sept 16 and found Sios in th the petty cash box The payroll records of Alpaca Farms provided the following information for the weekly pay period ended December 27, 2020. HU Holy Rata Income Tax Us Fred Mo 4 IS 12005 61005 2400 9005 1000 Kamy Chuck 15 15.00 101005 H00 2005 10 DO W 15 170015 105 14.00 10.00 40 14005 66.00 900 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 1-40% of JET Required a) Cakulate gross and net pay for each employee. Round all answers to the nearest whole number. 20 av b) Prepare the payroll journal entries for December 27, 2020 ark c) Prepare a journal entry to record cash payment of the payroll liabilities due to the CRA on January 15, 2020.dmarks! Perform a horizontal analysis for Alpaca Farms Use 2017 as the base year (14 martie Alpaca Farms Income Statement in Thousands) For Years Ended Dec 11, 2017-2019 2019 2018 2017 Revenue 124 1.100 988 Expenses 902 1.000 628 Net Income 227 21 310 A table has been provided to contact the analysis. ArcaFarms ratanatya for Years Ended December 11, 2012, 2019 2019 2016 2017 of Change No 2017 Change Valur Sof2017 &M 2017 Change Revue enes Netcome