Part 3-Substantive Testing of the Revenue (Order to Cash) Cycle. As revenue is considered a high-risk...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Part 3-Substantive Testing of the Revenue (Order to Cash) Cycle. As revenue is considered a high-risk area for most audit engagements (PCAOB 2014), you will utilize Tableau to create data visualizations and dashboards for various aspects of the audit of US Superstore's revenue (order to cash) cycle and related accounts. For the following issues, first, brainstorm in your group to develop questions that you need to evaluate with Tableau, and second, prepare the necessary data visualizations related to the following issues and questions you developed. (Refer to Chapter 7, Revenue and Collection Cycle). Your engagement partner provided the following initial substantive testing issues to your team that need to be evaluated: (1) Are there any indicators of slow-moving product? (2) Are there any indications of cut-off issues? (3) Are there any indicators of related-party transactions? (4) Which customers should receive confirmations? (5) Are there any issues or concerns with discounts and cash receipts? (6) What is the Accounts Receivable 12/31 balance for each year? Are there concerns as to the quality of US Superstore's accounts receivable? For 12/31/14, what is the total amount of accounts receivable that are more than 30, 60, and 90 days past due? Based on this analysis, identify risky items. Explain why you consider these items risky. (8) Are there any indicators that inventory might be overvalued? (9) What are shipping costs per region or product? (10) Are there any other issues you think are important? Part 3-Substantive Testing of the Revenue (Order to Cash) Cycle. As revenue is considered a high-risk area for most audit engagements (PCAOB 2014), you will utilize Tableau to create data visualizations and dashboards for various aspects of the audit of US Superstore's revenue (order to cash) cycle and related accounts. For the following issues, first, brainstorm in your group to develop questions that you need to evaluate with Tableau, and second, prepare the necessary data visualizations related to the following issues and questions you developed. (Refer to Chapter 7, Revenue and Collection Cycle). Your engagement partner provided the following initial substantive testing issues to your team that need to be evaluated: (1) Are there any indicators of slow-moving product? (2) Are there any indications of cut-off issues? (3) Are there any indicators of related-party transactions? (4) Which customers should receive confirmations? (5) Are there any issues or concerns with discounts and cash receipts? (6) What is the Accounts Receivable 12/31 balance for each year? Are there concerns as to the quality of US Superstore's accounts receivable? For 12/31/14, what is the total amount of accounts receivable that are more than 30, 60, and 90 days past due? Based on this analysis, identify risky items. Explain why you consider these items risky. (8) Are there any indicators that inventory might be overvalued? (9) What are shipping costs per region or product? (10) Are there any other issues you think are important?
Expert Answer:
Answer rating: 100% (QA)
Here are the questions I would evaluate with Tableau for the given issues along with sample data visualizations 1 Are there any indicators of slowmovi... View the full answer
Related Book For
Auditing and Assurance services an integrated approach
ISBN: 978-0132575959
14th Edition
Authors: Alvin a. arens, Randal j. elder, Mark s. Beasley
Posted Date:
Students also viewed these accounting questions
-
You have been asked to perform substantive testing of the receivables account for Ocie's Manufacturing. You have been instructed to utilize sampling techniques. There are 3,000 customer accounts...
-
Transactions related to revenue and cash receipts completed by Tex Max Inc. during the month of March 2010 are as follows: Mar. 2. Issued Invoice No. 512 to Browne Co., $820. 4. Received cash from...
-
Transactions related to revenue and cash receipts completed by Starcom Inc. during the month of March 2006 are as follows: Mar. 2. Issued Invoice No. 512 to Conrad Co., $790. 4. Received cash from...
-
East Corp is a mature company and expects its sales and operating costs to be fixed (or unchanged) in perpetuity. It has sales of $524,000 and operating costs of $272,480. The firm has a tax rate of...
-
Who are the providers (savers) and users (borrowers) of capital? How is capital transferred between savers and borrowers? Assume that you recently graduated and have just reported to work as an...
-
Suppose the Australian dollar to U.S. dollar exchange rate is 1.0757 and the euro to the U.S. dollar exchange rate is 0.7234, what would be the value of Australian dollar to euro exchange rate?
-
You have recently been employed as the manager of internal audit for a large multinational financial services company. It is clear to you that you have been given the job because of your reputation...
-
Select an IT project that you are familiar with and comment on whether there was a formal project sponsor and champion, which business managers played these roles, and whether or not you think their...
-
In 2021 Navarro Corp. implemented a program to improve product quality. The quality program focused on training the managers responsible for the purchase of raw materials. The quality program also...
-
From the trial balance of Gabriella Leitz, Attorney-at-Law, given in Figure 2.7, prepare (a) An income statement for the month of January, (b) A statement of owners equity for the month ended January...
-
You may have to use global variables to hold the constants needed for the arithmetic. Required: The temperature conversion procedures must be in a separate asm file called conversion.asm. This means...
-
Explain: What does the picture tell? What is the motif? How does it affect you and the viewers? 10 AFP
-
A critic of the IFRS said, "since there is no one government enforcer of accounting rules, the IFRS is different from country to country. So, the idea of a single unified accounting standard is an...
-
In the two-period model of investment the production function is given by Q=9K(2/3) . The initial capital stock is K1=110. The interest rate is 20%. a) What is the optimal amount of investment if...
-
What are 10 questions about a diet after reviewing their nutrition screening?
-
scenario Scenario Anne knows that she is going to incur increased costs if she expands her business. She is concerned about the impact these costs will have on her profit margin and the long-term...
-
[Suppose a person's weight is evenly distributed over the four legs of a chair (person plus chair:82.0kg). The area of contact with the floor is 2.00 cm for each chair leg. Calculate the pressure on...
-
Banner Company acquires an 80% interest in Roller Company for $640,000 cash on January 1, 2013. The NCI has a fair value of $160,000. Any excess of cost over book value is attributed to goodwill. To...
-
Following are several decisions that the auditor must make in an audit of a nonpublic company. Letters indicate alternative conclusions that could be made. Required a. Identify the sequence in which...
-
Explain why most auditors consider the receipt of goods and services the most important point in the acquisition and payment cycle.
-
Explain why many people think of internal auditors as the primary group responsible for conducting operational audits.
-
For the gamma regression model of Exercise 5.2, E [ y x ] = exp ( x ) and V [ y x ] = ( exp ( x ) ) 2 / 2 (a) Show that these conditions imply that E [ x { ( y x ) 2 ( exp ( x ) ) 2 /...
-
Consider the linear regression model for data independent over i with y i = x i + u i . Suppose E [ u i x i ] 0 but there are available instruments z i with E [ u i z i ] = 0 and V [ u i z i ]...
-
A nonnegative integer variable \(y\) that is geometric distributed has density (or more formally probability mass function) \(f(y)=(y+1)(2 \lambda)^{y}(1+2 \lambda)^{-(y+0.5)}, y=\) \(0,1,2, \ldots,...
Study smarter with the SolutionInn App