Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Sunnyside Inc is being audited by Swan and Co, External Auditors. The lead partner on the engagement is interested in utilizing Audit. Data Analytics (ADA)

image text in transcribed
image text in transcribed
image text in transcribed
Sunnyside Inc is being audited by Swan and Co, External Auditors. The lead partner on the engagement is interested in utilizing Audit. Data Analytics (ADA) as a substantive test of details, and is discussing the most beneficial use of this technique with the audit manager who will assume responsibility for the day-to-day overseeing of the audit. Scenarios, whereby ADA can be utilized as a substantive test of details, include: (Select all that apply) Vouching accounts receivable balances to records of subsequent cash receipts from customers. Matching IT intemal controls to the relevant audit assertions which will be used to test those controls. Matching information contained in shipping documents, bills of lading, and sales invoices. Vouching procedure whereby inventory quantities are matched to depreciation expenses and inventory acquisitions. Stateside External Auditors are currently conducting the audit of Safeway Enterprises; a large, decentralized client with seasonal variations in revenue and operations throughout the United States. As part of their risk assessment procedures, Stateside has decided. to utilize a regression analysis in order to analyze Safeway's revenue accounts, Regression analysis is well suited to an investigation of this nature because; (Select all thot apply.) Regression analysis can help the auditor discover anomalous items which may be worthy of further investigation. Regression analysis can be used as a substitute for other, more time-consuming substantive procedures. The prediction equation generated by the regression analysis will ensure that all unacceptable variations are removed from. the analysis to ensure the robustness of the statistical test. Regression analysis can incorporate the seasonality of the client's business into the prediction equation. client's data. You are given sales data and you provide a line chart of the transactions for the 2018. Click here to access a Tableau file, and here to access a Power BI file. (The Tableau and Power BI files contain the same visualizations; you can use either to answer the questions in this assignment. Your instructor may specify which program they prefer you to use.) How to Access Tableau: You can open the Tableau file in this problem statement with Tableau desktop software. If you do not have Tableau desktop software, you can download the most recent version of Tableau Reader, a free program that allows you to open Tableau visualizations. To get the most recent version, search for "Tableau Reader" in your internet browser. How to Access Power BI: You can open the Power BI file in this problem statement with Power BI Desktop. If you do not have it already, you can downioad PowerBI Desktop here: here. Parta What is this test doing? Reviewing controls over sales revenue. Looking for patterns in data that stand out. Generating information about best-selling products. Comparing prior year sales to current year sales

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions