Please state how you derieve at the figures when preparing the worksheet.
You are the auditors of Ty' apollo Limited, a manufacturing company. You are assigned to complete the test of the expenses and have been presented with the attached schedule of expenses for the year ended March 31,2021 and the comparatives for 2020. The audit supervisor has set the materiality level at $55,000. Required: Perform the steps to be carried out in applying analytical procedures to audit the expenses. Prepare the worksheet.(PLEASE SHOW ALL WORKING Identify at least five accounts for further investigation and briefly state why and the procedure you will employ in carrying out the investigation. Ty'apollo Limited Income Statem ent Accounts - All Divisions For the Year Ended March 31, 2021 2021 2020 Sales Sales Returns and Allowances Cost of Sales Salaries-Management Salaries-Office Licensing and certification fees Security Insurance $ 153,918,731 184,103 109,284,780 2,081,266 315,169 190,650 450,603 93,197 $ 148,764,555 178,518 106,255,499 2,387,993 296,681 172,883 637,580 103,842 Medical benefits 23,721 29,453 162,512 198,009 6,989 5,555 22,585 178,009 Advertising Business publications Property taxes Bad debts Depreciation expense Accounting fees Salaries-Sales 841,699 1,034,060 5,336,783 4,641,982 273,956 297,777 14,970,669 15,327,777 595,389 491,794 1,113,539 1,339,626 4,891,065 5,340,271 Wages Rental Wages-Mechanics Wages-Warehouse Garbage collection Payroll benefits Rent- Warehouse 27,649 29,771 2,657,889 2,937,730 802,855 764,346 32,402 45,173 Telephone Utilities 262,393 267,005 89,763 133,518 12,350 17,282 166,985 168,405 Postage Linen service Repairs and maintenance Cleaning service Legal service Fuel 89,800 81,589 396,016 190,540 186,547 341,192 Travel and entertainment 203,389 103,842 228,555 237,350 149,828 148,340 Pension expense Office supplies Miscellaneous Other Expense-Interest 300,188 105,931 2,181,948 302,447,300 2,299,217 295,651,758 You are the auditors of Ty' apollo Limited, a manufacturing company. You are assigned to complete the test of the expenses and have been presented with the attached schedule of expenses for the year ended March 31,2021 and the comparatives for 2020. The audit supervisor has set the materiality level at $55,000. Required: Perform the steps to be carried out in applying analytical procedures to audit the expenses. Prepare the worksheet.(PLEASE SHOW ALL WORKING Identify at least five accounts for further investigation and briefly state why and the procedure you will employ in carrying out the investigation. Ty'apollo Limited Income Statem ent Accounts - All Divisions For the Year Ended March 31, 2021 2021 2020 Sales Sales Returns and Allowances Cost of Sales Salaries-Management Salaries-Office Licensing and certification fees Security Insurance $ 153,918,731 184,103 109,284,780 2,081,266 315,169 190,650 450,603 93,197 $ 148,764,555 178,518 106,255,499 2,387,993 296,681 172,883 637,580 103,842 Medical benefits 23,721 29,453 162,512 198,009 6,989 5,555 22,585 178,009 Advertising Business publications Property taxes Bad debts Depreciation expense Accounting fees Salaries-Sales 841,699 1,034,060 5,336,783 4,641,982 273,956 297,777 14,970,669 15,327,777 595,389 491,794 1,113,539 1,339,626 4,891,065 5,340,271 Wages Rental Wages-Mechanics Wages-Warehouse Garbage collection Payroll benefits Rent- Warehouse 27,649 29,771 2,657,889 2,937,730 802,855 764,346 32,402 45,173 Telephone Utilities 262,393 267,005 89,763 133,518 12,350 17,282 166,985 168,405 Postage Linen service Repairs and maintenance Cleaning service Legal service Fuel 89,800 81,589 396,016 190,540 186,547 341,192 Travel and entertainment 203,389 103,842 228,555 237,350 149,828 148,340 Pension expense Office supplies Miscellaneous Other Expense-Interest 300,188 105,931 2,181,948 302,447,300 2,299,217 295,651,758
